eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CLOSE dependencies on PO_DOCUMENT_ACTION_PVT

Line 166: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

162: -- on the action. All actions will populate at least a return_status.
163: --End of Comments
164: -------------------------------------------------------------------------------
165: PROCEDURE manual_close_po(
166: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
167: )
168: IS
169:
170: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CLOSE.manual_close_po';

Line 351: -- PO_DOCUMENT_ACTION_PVT.do_action, which normally handles rolling back for other actions,

347:
348: d_progress := 200;
349:
350: -- From this point forward, need to rollback on early return or exception
351: -- PO_DOCUMENT_ACTION_PVT.do_action, which normally handles rolling back for other actions,
352: -- only rolls back on return_status = 'U'. Since we return 'S' for any encumbrance
353: -- functional errors, we want to undo the following AP INVOICE OPEN update SQL in those cases
354: l_rollback_flag := TRUE;
355:

Line 357: AND (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))

353: -- functional errors, we want to undo the following AP INVOICE OPEN update SQL in those cases
354: l_rollback_flag := TRUE;
355:
356: IF ((p_action_ctl_rec.calling_mode = 'AP')
357: AND (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
358: THEN
359:
360: d_progress := 210;
361:

Line 370: IF ((p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

366:
367: END IF; -- if p_action_ctl_rec.calling_mode = 'AP' ...
368:
369:
370: IF ((p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
371: OR ((p_action_ctl_rec.calling_mode = 'AP') AND
372: (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)))
373: THEN
374:

Line 372: (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)))

368:
369:
370: IF ((p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
371: OR ((p_action_ctl_rec.calling_mode = 'AP') AND
372: (p_action_ctl_rec.action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)))
373: THEN
374:
375: d_progress := 220;
376:

Line 468: (p_action_ctl_rec.action NOT IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,

464:
465: d_progress := 290;
466:
467: IF ((p_action_ctl_rec.document_type <> 'PA') AND
468: (p_action_ctl_rec.action NOT IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
469: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)))
470: THEN
471:
472: d_progress := 300;

Line 469: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)))

465: d_progress := 290;
466:
467: IF ((p_action_ctl_rec.document_type <> 'PA') AND
468: (p_action_ctl_rec.action NOT IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV,
469: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)))
470: THEN
471:
472: d_progress := 300;
473:

Line 506: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

502: ELSIF (l_ret_sts = 'U') THEN
503: IF (PO_LOG.d_exc) THEN
504: PO_LOG.exc(d_module, d_progress, d_msg);
505: END IF;
506: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
507: END IF;
508:
509: IF (l_rollback_flag) THEN
510: ROLLBACK TO DA_MANUAL_CLOSE_SP;

Line 529: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

525: EXCEPTION
526: WHEN others THEN
527: p_action_ctl_rec.return_status := 'U';
528:
529: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
530:
531: IF (PO_LOG.d_exc) THEN
532: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
533: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

Line 580: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

576: -- on the action. All actions will populate at least a return_status.
577: --End of Comments
578: -------------------------------------------------------------------------------
579: PROCEDURE auto_close_po(
580: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
581: )
582: IS
583:
584: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CLOSE.auto_close_po';

Line 806: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

802: ELSIF (l_ret_sts = 'U') THEN
803: IF (PO_LOG.d_exc) THEN
804: PO_LOG.exc(d_module, d_progress, d_msg);
805: END IF;
806: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
807: END IF;
808: END;
809:
810: p_action_ctl_rec.return_status := l_ret_sts;

Line 823: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

819: EXCEPTION
820: WHEN others THEN
821: p_action_ctl_rec.return_status := 'U';
822:
823: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
824:
825: IF (PO_LOG.d_exc) THEN
826: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
827: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

Line 931: IF ((p_calling_mode = 'AP') AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))

927: BEGIN
928:
929: d_progress := 10;
930:
931: IF ((p_calling_mode = 'AP') AND (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV))
932: THEN
933:
934: -- bug 3454885
935: -- If a parent entity of the shipment is FINALLY CLOSED,

Line 965: AND ( pol.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

961: WHERE poll.line_location_id = p_shipment_id
962: AND pol.po_line_id = poll.po_line_id
963: AND por.po_release_id(+) = poll.po_release_id
964: AND ppo_ll.line_location_id(+) = poll.source_shipment_id
965: AND ( pol.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
966: OR por.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
967: OR ppo_ll.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
968: )
969: ;

Line 966: OR por.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

962: AND pol.po_line_id = poll.po_line_id
963: AND por.po_release_id(+) = poll.po_release_id
964: AND ppo_ll.line_location_id(+) = poll.source_shipment_id
965: AND ( pol.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
966: OR por.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
967: OR ppo_ll.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
968: )
969: ;
970:

Line 967: OR ppo_ll.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

963: AND por.po_release_id(+) = poll.po_release_id
964: AND ppo_ll.line_location_id(+) = poll.source_shipment_id
965: AND ( pol.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
966: OR por.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
967: OR ppo_ll.closed_code = PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
968: )
969: ;
970:
971: IF (l_line_finally_closed > 0)

Line 984: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;

980: END IF; -- p_calling_mode = 'AP' AND p_action = 'INVOICE OPEN'
981:
982: d_progress := 40;
983:
984: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
985: l_allowed_states.hold_flag := NULL;
986: l_allowed_states.frozen_flag := NULL;
987: l_allowed_states.fully_reserved_flag := NULL;
988:

Line 989: IF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV)

985: l_allowed_states.hold_flag := NULL;
986: l_allowed_states.frozen_flag := NULL;
987: l_allowed_states.fully_reserved_flag := NULL;
988:
989: IF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV)
990: THEN
991:
992: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
993: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

Line 992: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

988:
989: IF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV)
990: THEN
991:
992: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
993: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
994:
995: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV)
996: THEN

Line 993: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

989: IF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_INV)
990: THEN
991:
992: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
993: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
994:
995: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV)
996: THEN
997:

Line 995: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV)

991:
992: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
993: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
994:
995: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV)
996: THEN
997:
998: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
999: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

Line 998: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

994:
995: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV)
996: THEN
997:
998: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
999: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1000:
1001: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE)
1002: THEN

Line 999: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

995: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV)
996: THEN
997:
998: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
999: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1000:
1001: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE)
1002: THEN
1003:

Line 1001: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE)

997:
998: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
999: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1000:
1001: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE)
1002: THEN
1003:
1004: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1005: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

Line 1004: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

1000:
1001: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE)
1002: THEN
1003:
1004: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1005: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1006: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1007:
1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

Line 1005: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

1001: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE)
1002: THEN
1003:
1004: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1005: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1006: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1007:
1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1009: THEN

Line 1006: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

1002: THEN
1003:
1004: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1005: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1006: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1007:
1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1009: THEN
1010:

Line 1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

1004: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1005: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1006: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1007:
1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1009: THEN
1010:
1011: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

Line 1011: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

1007:
1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1009: THEN
1010:
1011: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1013: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1014: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1015:

Line 1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

1008: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1009: THEN
1010:
1011: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1013: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1014: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1015:
1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)

Line 1013: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

1009: THEN
1010:
1011: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1013: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1014: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1015:
1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1017: THEN

Line 1014: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

1010:
1011: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1013: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1014: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1015:
1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1017: THEN
1018:

Line 1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)

1012: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1013: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1014: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1015:
1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1017: THEN
1018:
1019: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

Line 1019: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

1015:
1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1017: THEN
1018:
1019: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1021: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1022: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1023:

Line 1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

1016: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
1017: THEN
1018:
1019: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1021: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1022: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1023:
1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)

Line 1021: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

1017: THEN
1018:
1019: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1021: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1022: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1023:
1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)
1025: THEN

Line 1022: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

1018:
1019: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1021: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1022: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1023:
1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)
1025: THEN
1026:

Line 1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)

1020: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1021: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1022: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1023:
1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)
1025: THEN
1026:
1027: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1028: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

Line 1027: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

1023:
1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)
1025: THEN
1026:
1027: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1028: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1029: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1030:
1031: --

Line 1028: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

1024: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_INV)
1025: THEN
1026:
1027: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1028: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1029: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1030:
1031: --
1032: -- Allow finally closed for AP re-open finally closed document (AP invoice open)

Line 1029: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

1025: THEN
1026:
1027: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1028: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1029: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1030:
1031: --
1032: -- Allow finally closed for AP re-open finally closed document (AP invoice open)
1033:

Line 1036: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED;

1032: -- Allow finally closed for AP re-open finally closed document (AP invoice open)
1033:
1034: IF (p_calling_mode = 'AP')
1035: THEN
1036: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED;
1037: END IF;
1038:
1039: --
1040:

Line 1041: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)

1037: END IF;
1038:
1039: --
1040:
1041: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
1042: THEN
1043:
1044: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1045: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

Line 1044: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

1040:
1041: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
1042: THEN
1043:
1044: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1045: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1046: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1047:
1048: ELSE

Line 1045: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

1041: ELSIF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
1042: THEN
1043:
1044: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1045: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1046: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1047:
1048: ELSE
1049:

Line 1046: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

1042: THEN
1043:
1044: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1045: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1046: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1047:
1048: ELSE
1049:
1050: d_progress := 50;

Line 1090: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1086: ELSIF (l_ret_sts = 'U') THEN
1087: IF (PO_LOG.d_exc) THEN
1088: PO_LOG.exc(d_module, d_progress, d_msg);
1089: END IF;
1090: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1091: l_ret_val := FALSE;
1092: END IF;
1093: END;
1094:

Line 1109: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1105: EXCEPTION
1106: WHEN others THEN
1107: x_return_status := 'U';
1108:
1109: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1110:
1111: IF (PO_LOG.d_exc) THEN
1112: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1113: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 1200: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;

1196: BEGIN
1197:
1198: d_progress := 10;
1199:
1200: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;

Line 1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;

1197:
1198: d_progress := 10;
1199:
1200: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

Line 1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;

1198: d_progress := 10;
1199:
1200: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;

Line 1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;

1199:
1200: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
1207: l_allowed_states.auth_states(8) := PO_DOCUMENT_ACTION_PVT.g_doc_status_SENT;

Line 1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;

1200: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
1207: l_allowed_states.auth_states(8) := PO_DOCUMENT_ACTION_PVT.g_doc_status_SENT;
1208:

Line 1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;

1201: l_allowed_states.auth_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INCOMPLETE;
1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
1207: l_allowed_states.auth_states(8) := PO_DOCUMENT_ACTION_PVT.g_doc_status_SENT;
1208:
1209: l_allowed_states.hold_flag := NULL;

Line 1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;

1202: l_allowed_states.auth_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_status_INPROCESS;
1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
1207: l_allowed_states.auth_states(8) := PO_DOCUMENT_ACTION_PVT.g_doc_status_SENT;
1208:
1209: l_allowed_states.hold_flag := NULL;
1210: l_allowed_states.frozen_flag := NULL;

Line 1207: l_allowed_states.auth_states(8) := PO_DOCUMENT_ACTION_PVT.g_doc_status_SENT;

1203: l_allowed_states.auth_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED;
1204: l_allowed_states.auth_states(5) := PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED;
1205: l_allowed_states.auth_states(6) := PO_DOCUMENT_ACTION_PVT.g_doc_status_REAPPROVAL;
1206: l_allowed_states.auth_states(7) := PO_DOCUMENT_ACTION_PVT.g_doc_status_PREAPPROVED;
1207: l_allowed_states.auth_states(8) := PO_DOCUMENT_ACTION_PVT.g_doc_status_SENT;
1208:
1209: l_allowed_states.hold_flag := NULL;
1210: l_allowed_states.frozen_flag := NULL;
1211: l_allowed_states.fully_reserved_flag := NULL;

Line 1213: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

1209: l_allowed_states.hold_flag := NULL;
1210: l_allowed_states.frozen_flag := NULL;
1211: l_allowed_states.fully_reserved_flag := NULL;
1212:
1213: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1214: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1215: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1216: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1217:

Line 1214: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;

1210: l_allowed_states.frozen_flag := NULL;
1211: l_allowed_states.fully_reserved_flag := NULL;
1212:
1213: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1214: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1215: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1216: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1217:
1218: d_progress := 20;

Line 1215: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;

1211: l_allowed_states.fully_reserved_flag := NULL;
1212:
1213: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1214: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1215: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1216: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1217:
1218: d_progress := 20;
1219:

Line 1216: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

1212:
1213: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
1214: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_RCV;
1215: l_allowed_states.closed_states(3) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED_INV;
1216: l_allowed_states.closed_states(4) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
1217:
1218: d_progress := 20;
1219:
1220: l_state_check_ok := PO_DOCUMENT_ACTION_UTIL.check_doc_state(

Line 1251: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1247: ELSIF (l_ret_sts = 'U') THEN
1248: IF (PO_LOG.d_exc) THEN
1249: PO_LOG.exc(d_module, d_progress, d_msg);
1250: END IF;
1251: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1252: l_ret_val := FALSE;
1253: END IF;
1254: END;
1255:

Line 1270: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1266: EXCEPTION
1267: WHEN others THEN
1268: x_return_status := 'U';
1269:
1270: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1271:
1272: IF (PO_LOG.d_exc) THEN
1273: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1274: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 1384: IF (p_action <> PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

1380: BEGIN
1381:
1382: d_progress := 10;
1383:
1384: IF (p_action <> PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1385: THEN
1386:
1387: d_progress := 20;
1388: x_online_report_id := NULL;

Line 1511: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1507: ELSIF (l_ret_sts = 'U') THEN
1508: IF (PO_LOG.d_exc) THEN
1509: PO_LOG.exc(d_module, d_progress, d_msg);
1510: END IF;
1511: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1512: l_ret_val := FALSE;
1513: END IF;
1514: END;
1515:

Line 1531: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1527: EXCEPTION
1528: WHEN others THEN
1529: x_return_status := 'U';
1530:
1531: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1532:
1533: IF (PO_LOG.d_exc) THEN
1534: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1535: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 1744: IF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

1740:
1741: END IF; -- if p_shipment_id is not null
1742:
1743:
1744: IF (p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
1745: THEN
1746:
1747: d_progress := 90;
1748:

Line 1857: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);

1853: ELSIF (l_ret_sts = 'U') THEN
1854: IF (PO_LOG.d_exc) THEN
1855: PO_LOG.exc(d_module, d_progress, d_msg);
1856: END IF;
1857: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, d_msg);
1858: END IF;
1859: END;
1860:
1861: x_return_status := l_ret_sts;

Line 1876: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

1872: EXCEPTION
1873: WHEN others THEN
1874: x_return_status := 'U';
1875:
1876: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1877:
1878: IF (PO_LOG.d_exc) THEN
1879: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1880: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 2267: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2263: EXCEPTION
2264: WHEN others THEN
2265: x_return_status := 'U';
2266:
2267: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2268:
2269: IF (PO_LOG.d_exc) THEN
2270: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2271: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 2780: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

2776: EXCEPTION
2777: WHEN others THEN
2778: x_return_status := 'U';
2779:
2780: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
2781:
2782: IF (PO_LOG.d_exc) THEN
2783: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2784: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 3227: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'handle_ctl_action_history not successful');

3223: THEN
3224:
3225: d_progress := 430;
3226: l_ret_sts := 'U';
3227: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'handle_ctl_action_history not successful');
3228: IF (PO_LOG.d_exc) THEN
3229: PO_LOG.exc(d_module, d_progress, 'handle_ctl_action_history not successful');
3230: END IF;
3231:

Line 3264: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

3260: END IF;
3261:
3262: x_return_status := 'U';
3263:
3264: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
3265:
3266: IF (PO_LOG.d_exc) THEN
3267: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
3268: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 3311: IF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,

3307:
3308: IF (p_document_type = 'PO')
3309: THEN
3310:
3311: IF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
3312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
3313: THEN
3314:
3315: IF (p_shipment_id IS NOT NULL)

Line 3312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)

3308: IF (p_document_type = 'PO')
3309: THEN
3310:
3311: IF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
3312: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
3313: THEN
3314:
3315: IF (p_shipment_id IS NOT NULL)
3316: THEN

Line 3331: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,

3327: l_supply_action := 'Create_PO_Supply';
3328:
3329: END IF; -- p_shipment_id is not null
3330:
3331: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
3332: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
3333: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
3334: THEN
3335:

Line 3332: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,

3328:
3329: END IF; -- p_shipment_id is not null
3330:
3331: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
3332: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
3333: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
3334: THEN
3335:
3336: IF (p_shipment_id IS NOT NULL)

Line 3333: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

3329: END IF; -- p_shipment_id is not null
3330:
3331: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
3332: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
3333: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
3334: THEN
3335:
3336: IF (p_shipment_id IS NOT NULL)
3337: THEN

Line 3357: IF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,

3353:
3354: ELSIF (p_document_type = 'RELEASE')
3355: THEN
3356:
3357: IF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
3358: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
3359: THEN
3360:
3361: IF (p_shipment_id IS NOT NULL)

Line 3358: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)

3354: ELSIF (p_document_type = 'RELEASE')
3355: THEN
3356:
3357: IF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN,
3358: PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN_RCV)
3359: THEN
3360:
3361: IF (p_shipment_id IS NOT NULL)
3362: THEN

Line 3373: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,

3369:
3370: END IF; -- p_shipment_id is not null
3371:
3372:
3373: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
3374: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
3375: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
3376: THEN
3377:

Line 3374: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,

3370: END IF; -- p_shipment_id is not null
3371:
3372:
3373: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
3374: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
3375: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
3376: THEN
3377:
3378: IF (p_shipment_id IS NOT NULL)

Line 3375: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)

3371:
3372:
3373: ELSIF p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE,
3374: PO_DOCUMENT_ACTION_PVT.g_doc_action_CLOSE_RCV,
3375: PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)
3376: THEN
3377:
3378: IF (p_shipment_id IS NOT NULL)
3379: THEN

Line 3417: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'po_req_supply call not successful');

3413: x_return_status := 'U';
3414: IF (PO_LOG.d_exc) THEN
3415: PO_LOG.exc(d_module, d_progress, 'po_req_supply call not successful');
3416: END IF;
3417: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, 'po_req_supply call not successful');
3418:
3419: ELSE
3420:
3421: d_progress := 40;

Line 3440: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

3436: EXCEPTION
3437: WHEN others THEN
3438: x_return_status := 'U';
3439:
3440: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
3441:
3442: IF (PO_LOG.d_exc) THEN
3443: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
3444: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

Line 3627: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);

3623: EXCEPTION
3624: WHEN others THEN
3625: x_return_status := 'U';
3626:
3627: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
3628:
3629: IF (PO_LOG.d_exc) THEN
3630: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
3631: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);