DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_AUTH dependencies on PO_CORE_S

Line 115: RAISE PO_CORE_S.g_early_return_exc;

111:
112: d_progress := 20;
113: p_action_ctl_rec.return_status := 'U';
114: l_err_msg := 'change_doc_auth_state not successful';
115: RAISE PO_CORE_S.g_early_return_exc;
116:
117: END IF;
118: /* Bug 14046925 : Skipping supply and archive for Mod*/
119: if p_action_ctl_rec.draft_id <> -1 then

Line 142: RAISE PO_CORE_S.g_early_return_exc;

138: THEN
139: d_progress := 40;
140: p_action_ctl_rec.return_status := 'U';
141: l_err_msg := 'get_supply_action_name not successful';
142: RAISE PO_CORE_S.g_early_return_exc;
143: END IF;
144:
145: d_progress := 50;
146: IF (PO_LOG.d_stmt) THEN

Line 165: RAISE PO_CORE_S.g_early_return_exc;

161: IF (NOT l_bool_ret_sts)
162: THEN
163: d_progress := 60;
164: l_err_msg := 'po_req_supply returned false';
165: RAISE PO_CORE_S.g_early_return_exc;
166: END IF;
167:
168: END IF; -- p_action_ctl_rec.document_type <> 'PA'
169:

Line 199: l_enable_payment_inst := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,

195:
196: SELECT org_id INTO l_org_id
197: FROM po_headers_all poh
198: WHERE poh.po_header_id = p_action_ctl_rec.document_id ;
199: l_enable_payment_inst := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
200: p_option_column => PO_CORE_S.g_PAYMENT_INSTR_COL);
201: IF l_enable_payment_inst = 'Y' THEN
202: PO_CORE_S3.generate_payment_sequence (p_po_header_id => p_action_ctl_rec.document_id);
203: END IF;

Line 200: p_option_column => PO_CORE_S.g_PAYMENT_INSTR_COL);

196: SELECT org_id INTO l_org_id
197: FROM po_headers_all poh
198: WHERE poh.po_header_id = p_action_ctl_rec.document_id ;
199: l_enable_payment_inst := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
200: p_option_column => PO_CORE_S.g_PAYMENT_INSTR_COL);
201: IF l_enable_payment_inst = 'Y' THEN
202: PO_CORE_S3.generate_payment_sequence (p_po_header_id => p_action_ctl_rec.document_id);
203: END IF;
204: END IF;

Line 202: PO_CORE_S3.generate_payment_sequence (p_po_header_id => p_action_ctl_rec.document_id);

198: WHERE poh.po_header_id = p_action_ctl_rec.document_id ;
199: l_enable_payment_inst := PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
200: p_option_column => PO_CORE_S.g_PAYMENT_INSTR_COL);
201: IF l_enable_payment_inst = 'Y' THEN
202: PO_CORE_S3.generate_payment_sequence (p_po_header_id => p_action_ctl_rec.document_id);
203: END IF;
204: END IF;
205:
206: PO_DOCUMENT_ARCHIVE_GRP.archive_po(

Line 221: RAISE PO_CORE_S.g_early_return_exc;

217: IF (l_ret_sts <> 'S')
218: THEN
219: d_progress := 90;
220: l_err_msg := 'archive_po not successful';
221: RAISE PO_CORE_S.g_early_return_exc;
222: END IF;
223:
224: END IF; -- if p_action_ctl_rec.document_type <> 'REQUISITION'
225:

Line 230: WHEN PO_CORE_S.g_early_return_exc THEN

226: -- TODO: ANALYZE return_code value (as opposed to return_status).
227: p_action_ctl_rec.return_status := 'S';
228:
229: EXCEPTION
230: WHEN PO_CORE_S.g_early_return_exc THEN
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;

Line 343: RAISE PO_CORE_S.g_early_return_exc;

339:
340: d_progress := 30;
341: p_action_ctl_rec.return_status := 'U';
342: l_err_msg := 'reject_status_check not successful';
343: RAISE PO_CORE_S.g_early_return_exc;
344:
345: END IF;
346:
347: IF (p_action_ctl_rec.return_code IS NOT NULL)

Line 354: RAISE PO_CORE_S.g_early_return_exc;

350: d_progress := 40;
351: p_action_ctl_rec.return_status := 'S';
352: p_action_ctl_rec.return_code := 'STATE_FAILED';
353: l_err_msg := 'State check failed';
354: RAISE PO_CORE_S.g_early_return_exc;
355:
356: END IF;
357:
358: -- reset return status and return code after reject_status_check call

Line 378: RAISE PO_CORE_S.g_early_return_exc;

374:
375: d_progress := 60;
376: p_action_ctl_rec.return_status := 'U';
377: l_err_msg := 'get_doc_preparer_id not successful';
378: RAISE PO_CORE_S.g_early_return_exc;
379:
380: END IF;
381:
382: d_progress := 70;

Line 389: IF ( PO_CORE_S.is_encumbrance_on(

385: PO_LOG.stmt(d_module, d_progress, 'l_preparer_id', l_preparer_id);
386: END IF;
387:
388:
389: IF ( PO_CORE_S.is_encumbrance_on(
390: p_doc_type => p_action_ctl_rec.document_type
391: , p_org_id => NULL
392: )
393: )

Line 451: RAISE PO_CORE_S.g_early_return_exc;

447:
448: d_progress := 110;
449: p_action_ctl_rec.return_status := 'U';
450: l_err_msg := 'do_reject not successful';
451: RAISE PO_CORE_S.g_early_return_exc;
452:
453: END IF;
454:
455: d_progress := 120;

Line 478: RAISE PO_CORE_S.g_early_return_exc;

474: d_progress := 130;
475: p_action_ctl_rec.return_status := 'S';
476: p_action_ctl_rec.return_code := 'P';
477: l_err_msg := 'funds do_reject partial';
478: RAISE PO_CORE_S.g_early_return_exc;
479:
480: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE)
481: THEN
482:

Line 487: RAISE PO_CORE_S.g_early_return_exc;

483: d_progress := 140;
484: p_action_ctl_rec.return_status := 'S';
485: p_action_ctl_rec.return_code := 'F';
486: l_err_msg := 'funds do_reject failure';
487: RAISE PO_CORE_S.g_early_return_exc;
488:
489: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FATAL)
490: THEN
491:

Line 496: RAISE PO_CORE_S.g_early_return_exc;

492: d_progress := 150;
493: p_action_ctl_rec.return_status := 'S';
494: p_action_ctl_rec.return_code := 'T';
495: l_err_msg := 'funds do_reject fatal';
496: RAISE PO_CORE_S.g_early_return_exc;
497:
498: ELSE
499:
500: d_progress := 160;

Line 503: RAISE PO_CORE_S.g_early_return_exc;

499:
500: d_progress := 160;
501: p_action_ctl_rec.return_status := 'U';
502: l_err_msg := 'Bad return code from funds do_reject';
503: RAISE PO_CORE_S.g_early_return_exc;
504:
505: END IF; -- if l_enc_ret_code IN (...)
506:
507: END IF; -- if l_enc_flag = 'Y' ...

Line 537: RAISE PO_CORE_S.g_early_return_exc;

533:
534: d_progress := 180;
535: p_action_ctl_rec.return_status := 'U';
536: l_err_msg := 'change_doc_auth_state not successful';
537: RAISE PO_CORE_S.g_early_return_exc;
538:
539: END IF;
540:
541: d_progress := 190;

Line 559: -- RAISE PO_CORE_S.g_early_return_exc;

555: -- THEN
556: -- d_progress := 195;
557: -- p_action_ctl_rec.return_status := 'U';
558: -- l_err_msg := 'get_supply_action_name not successful';
559: -- RAISE PO_CORE_S.g_early_return_exc;
560: -- END IF;
561: --
562: -- d_progress := 200;
563: -- IF (PO_LOG.d_stmt) THEN

Line 583: -- RAISE PO_CORE_S.g_early_return_exc;

579: -- THEN
580: -- d_progress := 210;
581: -- p_action_ctl_rec.return_status := 'U';
582: -- l_err_msg := 'po_req_supply returned false';
583: -- RAISE PO_CORE_S.g_early_return_exc;
584: -- END IF;
585: --
586: -- END IF; -- document_type <> 'PA'
587:

Line 591: WHEN PO_CORE_S.g_early_return_exc THEN

587:
588: p_action_ctl_rec.return_status := 'S';
589:
590: EXCEPTION
591: WHEN PO_CORE_S.g_early_return_exc THEN
592: IF (p_action_ctl_rec.return_status = 'U')
593: THEN
594: IF (PO_LOG.d_exc) THEN
595: PO_LOG.exc(d_module, d_progress, l_err_msg);

Line 708: RAISE PO_CORE_S.g_early_return_exc;

704: THEN
705: d_progress := 20;
706: l_ret_sts := 'U';
707: l_err_msg := 'change doc state not successful';
708: RAISE PO_CORE_S.g_early_return_exc;
709: END IF;
710:
711: d_progress := 30;
712: l_ret_sts := 'S';

Line 715: WHEN PO_CORE_S.g_early_return_exc THEN

711: d_progress := 30;
712: l_ret_sts := 'S';
713:
714: EXCEPTION
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);

Line 822: RAISE PO_CORE_S.g_early_return_exc;

818:
819: d_progress := 20;
820: l_err_msg := 'Invalid document type';
821: l_ret_sts := 'U';
822: RAISE PO_CORE_S.g_early_return_exc;
823:
824: END IF;
825:
826: d_progress := 30;

Line 847: RAISE PO_CORE_S.g_early_return_exc;

843: THEN
844:
845: d_progress := 40;
846: l_err_msg := 'check_doc_state not successful';
847: RAISE PO_CORE_S.g_early_return_exc;
848:
849: END IF;
850:
851: IF (NOT l_doc_state_ok)

Line 858: RAISE PO_CORE_S.g_early_return_exc;

854: d_progress := 45;
855: l_ret_sts := 'S';
856: p_action_ctl_rec.return_code := 'STATE_FAILED';
857: l_err_msg := 'State check failed.';
858: RAISE PO_CORE_S.g_early_return_exc;
859:
860: END IF;
861:
862: d_progress := 50;

Line 864: l_req_enc_on := PO_CORE_S.is_encumbrance_on(

860: END IF;
861:
862: d_progress := 50;
863:
864: l_req_enc_on := PO_CORE_S.is_encumbrance_on(
865: p_doc_type => PO_CORE_S.g_doc_type_REQUISITION
866: , p_org_id => NULL
867: );
868:

Line 865: p_doc_type => PO_CORE_S.g_doc_type_REQUISITION

861:
862: d_progress := 50;
863:
864: l_req_enc_on := PO_CORE_S.is_encumbrance_on(
865: p_doc_type => PO_CORE_S.g_doc_type_REQUISITION
866: , p_org_id => NULL
867: );
868:
869: d_progress := 60;

Line 902: RAISE PO_CORE_S.g_early_return_exc;

898:
899: d_progress := 80;
900: l_ret_sts := 'U';
901: l_err_msg := 'do_return not successful';
902: RAISE PO_CORE_S.g_early_return_exc;
903:
904: END IF;
905:
906: d_progress := 90;

Line 929: RAISE PO_CORE_S.g_early_return_exc;

925: d_progress := 110;
926: l_ret_sts := 'S';
927: p_action_ctl_rec.return_code := 'P';
928: l_err_msg := 'funds do_return partial';
929: RAISE PO_CORE_S.g_early_return_exc;
930:
931: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE)
932: THEN
933:

Line 938: RAISE PO_CORE_S.g_early_return_exc;

934: d_progress := 120;
935: l_ret_sts := 'S';
936: p_action_ctl_rec.return_code := 'F';
937: l_err_msg := 'funds do_return failure';
938: RAISE PO_CORE_S.g_early_return_exc;
939:
940: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FATAL)
941: THEN
942:

Line 947: RAISE PO_CORE_S.g_early_return_exc;

943: d_progress := 130;
944: l_ret_sts := 'S';
945: p_action_ctl_rec.return_code := 'T';
946: l_err_msg := 'funds do_return fatal';
947: RAISE PO_CORE_S.g_early_return_exc;
948:
949: ELSE
950:
951: d_progress := 140;

Line 954: RAISE PO_CORE_S.g_early_return_exc;

950:
951: d_progress := 140;
952: l_ret_sts := 'U';
953: l_err_msg := 'Bad return code from funds do_return';
954: RAISE PO_CORE_S.g_early_return_exc;
955:
956: END IF; -- if l_enc_ret_code IN (...)
957:
958: END IF; -- IF l_req_enc_on

Line 976: RAISE PO_CORE_S.g_early_return_exc;

972:
973: d_progress := 160;
974: l_ret_sts := 'U';
975: l_err_msg := 'get_doc_preparer_id not successful';
976: RAISE PO_CORE_S.g_early_return_exc;
977:
978: END IF;
979:
980: d_progress := 170;

Line 1008: RAISE PO_CORE_S.g_early_return_exc;

1004:
1005: d_progress := 180;
1006: l_ret_sts := 'U';
1007: l_err_msg := 'change_doc_auth_state not successful';
1008: RAISE PO_CORE_S.g_early_return_exc;
1009:
1010: END IF;
1011:
1012: d_progress := 190;

Line 1027: RAISE PO_CORE_S.g_early_return_exc;

1023: THEN
1024: d_progress := 195;
1025: l_ret_sts := 'U';
1026: l_err_msg := 'get_supply_action_name not successful';
1027: RAISE PO_CORE_S.g_early_return_exc;
1028: END IF;
1029:
1030: d_progress := 200;
1031: IF (PO_LOG.d_stmt) THEN

Line 1051: RAISE PO_CORE_S.g_early_return_exc;

1047: THEN
1048: d_progress := 210;
1049: l_ret_sts := 'U';
1050: l_err_msg := 'po_req_supply returned false';
1051: RAISE PO_CORE_S.g_early_return_exc;
1052: END IF;
1053:
1054: d_progress := 220;
1055: p_action_ctl_rec.return_code := NULL;

Line 1059: WHEN PO_CORE_S.g_early_return_exc THEN

1055: p_action_ctl_rec.return_code := NULL;
1056: l_ret_sts := 'S';
1057:
1058: EXCEPTION
1059: WHEN PO_CORE_S.g_early_return_exc THEN
1060: IF (l_ret_sts = 'U') THEN
1061: IF (PO_LOG.d_exc) THEN
1062: PO_LOG.exc(d_module, d_progress, l_err_msg);
1063: END IF;

Line 1189: RAISE PO_CORE_S.g_invalid_call_exc;

1185: l_supply_action := 'Remove_Return_Req_Supply';
1186:
1187: ELSE
1188:
1189: RAISE PO_CORE_S.g_invalid_call_exc;
1190:
1191: END IF; -- p_action IN ...
1192:
1193: x_supply_action := l_supply_action;