DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_AUTH dependencies on PO_DOCUMENT_ACTION_PVT

Line 54: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

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

Line 103: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED

99: , p_fwd_to_id => p_action_ctl_rec.forward_to_id
100: , p_offline_code => p_action_ctl_rec.offline_code
101: , p_approval_path_id => p_action_ctl_rec.approval_path_id
102: , p_note => p_action_ctl_rec.note
103: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED
104: , p_notify_action => 'APPROVAL'
105: , p_notify_employee => p_action_ctl_rec.forward_to_id
106: , x_return_status => l_ret_sts
107: );

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

231: p_action_ctl_rec.return_status := 'U';
232: IF (PO_LOG.d_exc) THEN
233: PO_LOG.exc(d_module, d_progress, l_err_msg);
234: END IF;
235: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
236:
237: END;
238:
239: IF (PO_LOG.d_proc) THEN

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

246: EXCEPTION
247: WHEN OTHERS THEN
248: p_action_ctl_rec.return_status := 'U';
249:
250: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
251: IF (PO_LOG.d_exc) THEN
252: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
253: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
254: PO_LOG.proc_end(d_module);

Line 294: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

290: -- on the action. All actions will populate at least a return_status.
291: --End of Comments
292: -------------------------------------------------------------------------------
293: PROCEDURE reject(
294: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
295: )
296: IS
297:
298: l_doc_state_ok BOOLEAN;

Line 525: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED

521: , p_fwd_to_id => p_action_ctl_rec.forward_to_id
522: , p_offline_code => p_action_ctl_rec.offline_code
523: , p_approval_path_id => p_action_ctl_rec.approval_path_id
524: , p_note => p_action_ctl_rec.note
525: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_REJECTED
526: , p_notify_action => 'REJECTED_BY_APPROVER'
527: , p_notify_employee => l_preparer_id
528: , x_return_status => l_ret_sts
529: );

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

595: PO_LOG.exc(d_module, d_progress, l_err_msg);
596: END IF;
597: END IF;
598:
599: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
600:
601: END;
602:
603: IF (PO_LOG.d_proc) THEN

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

612: EXCEPTION
613: WHEN OTHERS THEN
614: p_action_ctl_rec.return_status := 'U';
615:
616: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
617: IF (PO_LOG.d_exc) THEN
618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
619: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
620: PO_LOG.proc_end(d_module);

Line 657: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

653: -- on the action. All actions will populate at least a return_status.
654: --End of Comments
655: -------------------------------------------------------------------------------
656: PROCEDURE forward(
657: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
658: )
659: IS
660:
661: l_ret_sts VARCHAR2(1);

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

715: WHEN PO_CORE_S.g_early_return_exc THEN
716: IF (PO_LOG.d_exc) THEN
717: PO_LOG.exc(d_module, d_progress, l_err_msg);
718: END IF;
719: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
720:
721: END;
722:
723: p_action_ctl_rec.return_status := l_ret_sts;

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

731: EXCEPTION
732: WHEN OTHERS THEN
733: p_action_ctl_rec.return_status := 'U';
734:
735: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
736: IF (PO_LOG.d_exc) THEN
737: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
738: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
739: PO_LOG.proc_end(d_module);

Line 778: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type

774: -- on the action. All actions will populate at least a return_status.
775: --End of Comments
776: -------------------------------------------------------------------------------
777: PROCEDURE return_action(
778: p_action_ctl_rec IN OUT NOCOPY PO_DOCUMENT_ACTION_PVT.doc_action_call_rec_type
779: )
780: IS
781:
782: l_ret_sts VARCHAR2(1);

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

824: END IF;
825:
826: d_progress := 30;
827:
828: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
829: l_allowed_states.hold_flag := 'N';
830: l_allowed_states.frozen_flag := 'N';
831: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
832: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;

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

827:
828: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
829: l_allowed_states.hold_flag := 'N';
830: l_allowed_states.frozen_flag := 'N';
831: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
832: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
833:
834: l_doc_state_ok := PO_DOCUMENT_ACTION_UTIL.check_doc_state(
835: p_document_id => p_action_ctl_rec.document_id

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

828: l_allowed_states.auth_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_status_APPROVED;
829: l_allowed_states.hold_flag := 'N';
830: l_allowed_states.frozen_flag := 'N';
831: l_allowed_states.closed_states(1) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_CLOSED;
832: l_allowed_states.closed_states(2) := PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_OPEN;
833:
834: l_doc_state_ok := PO_DOCUMENT_ACTION_UTIL.check_doc_state(
835: p_document_id => p_action_ctl_rec.document_id
836: , p_document_type => p_action_ctl_rec.document_type

Line 996: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED

992: , p_fwd_to_id => NULL
993: , p_offline_code => NULL
994: , p_approval_path_id => p_action_ctl_rec.approval_path_id
995: , p_note => p_action_ctl_rec.note
996: , p_new_status => PO_DOCUMENT_ACTION_PVT.g_doc_status_RETURNED
997: , p_notify_action => 'APPROVAL'
998: , p_notify_employee => l_preparer_id
999: , x_return_status => l_ret_sts
1000: );

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

1062: PO_LOG.exc(d_module, d_progress, l_err_msg);
1063: END IF;
1064: END IF;
1065:
1066: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
1067: END;
1068:
1069: p_action_ctl_rec.return_status := l_ret_sts;
1070: IF (PO_LOG.d_proc) THEN

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

1079: EXCEPTION
1080: WHEN OTHERS THEN
1081: p_action_ctl_rec.return_status := 'U';
1082:
1083: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1084: IF (PO_LOG.d_exc) THEN
1085: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1086: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1087: PO_LOG.proc_end(d_module);

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

1146: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1148: END IF;
1149:
1150: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,
1151: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))
1152: THEN
1153:
1154: IF (p_document_type = 'PO')

Line 1151: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))

1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1148: END IF;
1149:
1150: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,
1151: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))
1152: THEN
1153:
1154: IF (p_document_type = 'PO')
1155: THEN

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

1176: l_supply_action := 'Approve_Req_Supply';
1177:
1178: END IF; -- document_type = 'PO'
1179:
1180: ELSIF ((p_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RETURN)
1181: AND (p_document_type = 'REQUISITION'))
1182: THEN
1183:
1184: d_progress := 60;

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

1201:
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: x_return_status := 'U';
1205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1206: IF (PO_LOG.d_exc) THEN
1207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1209: PO_LOG.proc_end(d_module);