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_AUTH dependencies on PO_DOCUMENT_ACTION_PVT

Line 53: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

49: -- on the action. All actions will populate at least a return_status.
50: --End of Comments
51: -------------------------------------------------------------------------------
52: PROCEDURE approve(
53: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
54: )
55: IS
56:
57: l_ret_sts VARCHAR2(1);

Line 99: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED

95: , p_fwd_to_id => p_action_ctl_rec.forward_to_id
96: , p_offline_code => p_action_ctl_rec.offline_code
97: , p_approval_path_id => p_action_ctl_rec.approval_path_id
98: , p_note => p_action_ctl_rec.note
99: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED
100: , p_notify_action => 'APPROVAL'
101: , p_notify_employee => p_action_ctl_rec.forward_to_id
102: , x_return_status => l_ret_sts
103: );

Line 212: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

208: p_action_ctl_rec.return_status := 'U';
209: IF (PO_LOG.d_exc) THEN
210: PO_LOG.exc(d_module, d_progress, l_err_msg);
211: END IF;
212: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
213:
214: END;
215:
216: IF (PO_LOG.d_proc) THEN

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

223: EXCEPTION
224: WHEN OTHERS THEN
225: p_action_ctl_rec.return_status := 'U';
226:
227: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
228: IF (PO_LOG.d_exc) THEN
229: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
230: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
231: PO_LOG.proc_end(d_module);

Line 271: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

267: -- on the action. All actions will populate at least a return_status.
268: --End of Comments
269: -------------------------------------------------------------------------------
270: PROCEDURE reject(
271: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
272: )
273: IS
274:
275: l_doc_state_ok BOOLEAN;

Line 494: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED

490: , p_fwd_to_id => p_action_ctl_rec.forward_to_id
491: , p_offline_code => p_action_ctl_rec.offline_code
492: , p_approval_path_id => p_action_ctl_rec.approval_path_id
493: , p_note => p_action_ctl_rec.note
494: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED
495: , p_notify_action => 'REJECTED_BY_APPROVER'
496: , p_notify_employee => l_preparer_id
497: , x_return_status => l_ret_sts
498: );

Line 568: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

564: PO_LOG.exc(d_module, d_progress, l_err_msg);
565: END IF;
566: END IF;
567:
568: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
569:
570: END;
571:
572: IF (PO_LOG.d_proc) THEN

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

581: EXCEPTION
582: WHEN OTHERS THEN
583: p_action_ctl_rec.return_status := 'U';
584:
585: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
586: IF (PO_LOG.d_exc) THEN
587: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
588: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
589: PO_LOG.proc_end(d_module);

Line 626: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

622: -- on the action. All actions will populate at least a return_status.
623: --End of Comments
624: -------------------------------------------------------------------------------
625: PROCEDURE forward(
626: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
627: )
628: IS
629:
630: l_ret_sts VARCHAR2(1);

Line 687: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

683: WHEN PO_CORE_S.g_early_return_exc THEN
684: IF (PO_LOG.d_exc) THEN
685: PO_LOG.exc(d_module, d_progress, l_err_msg);
686: END IF;
687: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
688:
689: END;
690:
691: p_action_ctl_rec.return_status := l_ret_sts;

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

699: EXCEPTION
700: WHEN OTHERS THEN
701: p_action_ctl_rec.return_status := 'U';
702:
703: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
704: IF (PO_LOG.d_exc) THEN
705: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
706: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
707: PO_LOG.proc_end(d_module);

Line 746: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

742: -- on the action. All actions will populate at least a return_status.
743: --End of Comments
744: -------------------------------------------------------------------------------
745: PROCEDURE return_action(
746: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
747: )
748: IS
749:
750: l_ret_sts VARCHAR2(1);

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

792: END IF;
793:
794: d_progress := 30;
795:
796: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
797: l_allowed_states.hold_flag := 'N';
798: l_allowed_states.frozen_flag := 'N';
799: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
800: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

Line 799: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;

795:
796: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
797: l_allowed_states.hold_flag := 'N';
798: l_allowed_states.frozen_flag := 'N';
799: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
800: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
801:
802: l_doc_state_ok := PO_DOCUMENT_ACTION_UTIL.check_doc_state(
803: p_document_id => p_action_ctl_rec.document_id

Line 800: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

796: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
797: l_allowed_states.hold_flag := 'N';
798: l_allowed_states.frozen_flag := 'N';
799: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
800: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
801:
802: l_doc_state_ok := PO_DOCUMENT_ACTION_UTIL.check_doc_state(
803: p_document_id => p_action_ctl_rec.document_id
804: , p_document_type => p_action_ctl_rec.document_type

Line 958: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED

954: , p_fwd_to_id => NULL
955: , p_offline_code => NULL
956: , p_approval_path_id => p_action_ctl_rec.approval_path_id
957: , p_note => p_action_ctl_rec.note
958: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED
959: , p_notify_action => 'APPROVAL'
960: , p_notify_employee => l_preparer_id
961: , x_return_status => l_ret_sts
962: );

Line 1028: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

1024: PO_LOG.exc(d_module, d_progress, l_err_msg);
1025: END IF;
1026: END IF;
1027:
1028: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
1029: END;
1030:
1031: p_action_ctl_rec.return_status := l_ret_sts;
1032: IF (PO_LOG.d_proc) THEN

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

1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: p_action_ctl_rec.return_status := 'U';
1044:
1045: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1046: IF (PO_LOG.d_exc) THEN
1047: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1048: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1049: PO_LOG.proc_end(d_module);

Line 1112: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,

1108: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1109: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1110: END IF;
1111:
1112: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,
1113: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))
1114: THEN
1115:
1116: IF (p_document_type = 'PO')

Line 1113: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))

1109: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1110: END IF;
1111:
1112: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,
1113: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))
1114: THEN
1115:
1116: IF (p_document_type = 'PO')
1117: THEN

Line 1142: ELSIF ((p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)

1138: l_supply_action := 'Approve_Req_Supply';
1139:
1140: END IF; -- document_type = 'PO'
1141:
1142: ELSIF ((p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)
1143: AND (p_document_type = 'REQUISITION'))
1144: THEN
1145:
1146: d_progress := 60;

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

1163:
1164: EXCEPTION
1165: WHEN OTHERS THEN
1166: x_return_status := 'U';
1167: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1168: IF (PO_LOG.d_exc) THEN
1169: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1170: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1171: PO_LOG.proc_end(d_module);