Advertisement
Guest User

Untitled

a guest
Oct 20th, 2014
631
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. FUNCTION cancel_move_order(usr IN bp_apps.AppsUsr)
  2. RETURN BOOLEAN
  3. IS
  4. v_ret varchar2(1);
  5. v_msg_cnt number;
  6. v_msg varchar2(1000);
  7. v_header_id mtl_txn_request_headers.header_id%TYPE := gem_txn.get_number('header_id');
  8. v_api_version NUMBER := 1.0;
  9. BEGIN
  10. INV_MO_ADMIN_PUB.CANCEL_ORDER(
  11. p_api_version => v_api_version,
  12. p_init_msg_list => FND_API.G_FALSE,
  13. p_commit => FND_API.G_FALSE,
  14. p_validation_level => FND_API.G_VALID_LEVEL_FULL,
  15. p_header_Id => v_header_id,
  16. x_msg_count => v_msg_cnt,
  17. x_msg_data => v_msg,
  18. x_return_status => v_ret );
  19.  
  20. IF (v_ret != FND_API.G_RET_STS_SUCCESS) THEN
  21. IF v_msg_cnt IS NOT NULL THEN
  22. FOR i IN 1..v_msg_cnt LOOP
  23. bpascui.display_error('MO HEADER API ERROR: ', FND_MSG_PUB.Get(i,NULL), usr.error_wait);
  24. END LOOP;
  25.  
  26. RETURN (FALSE);
  27. ELSE
  28. bpascui.display_error('MO HEADER API ERROR', usr.error_wait);
  29.  
  30. RETURN (FALSE);
  31. END IF;
  32. ELSE
  33. co_debug.debug('bpa_request.cancel_move_order', 'completed');
  34. RETURN (TRUE);
  35. co_debug.debug('bpa_request.cancel_move_order', 'move order: '||v_header_id||'cancelled');
  36. END IF;
  37. END cancel_move_order;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement