DBA Data[Home] [Help]

APPS.PO_FUNDS_CHECKER dependencies on PO_MESSAGE_S

Line 261: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

257: p_fc_ok => l_fc_ok) then
258:
259: -- dbms_output.put_line('funds control not ok');
260:
261: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
262: token1 => 'FILE',
263: value1 => 'PO_FUNDS_CHECKER',
264: token2 => 'ERR_NUMBER',
265: value2 => '005',

Line 285: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

281: -- dbms_output.put_line('init funds checker');
282:
283: if not po_fc_init then
284:
285: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
286: token1 => 'FILE',
287: value1 => 'PO_FUNDS_CHECKER',
288: token2 => 'ERR_NUMBER',
289: value2 => '010',

Line 311: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

307: p_override_period => g_override_period,
308: p_recreate_demand => g_recreate_demand,
309: p_packetid => g_packetid) then
310:
311: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
312: token1 => 'FILE',
313: value1 => 'PO_FUNDS_CHECKER',
314: token2 => 'ERR_NUMBER',
315: value2 => '015',

Line 400: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

396: p_return_code => g_return_code) then
397:
398: GL_FUNDS_CHECKER_PKG.GLXFPP(p_packetid => g_packetid);
399:
400: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
401: token1 => 'FILE',
402: value1 => 'PO_FUNDS_CHECKER',
403: token2 => 'ERR_NUMBER',
404: value2 => '020',

Line 419: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

415: (g_fcmode in ('R', 'A'))) then
416:
417: if not po_rollup_enc then
418:
419: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
420: token1 => 'FILE',
421: value1 => 'PO_FUNDS_CHECKER',
422: token2 => 'ERR_NUMBER',
423: value2 => '025',

Line 437: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

433: (g_fcmode in ('R', 'A'))) then
434:
435: if not po_rollup_enc then
436:
437: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
438: token1 => 'FILE',
439: value1 => 'PO_FUNDS_CHECKER',
440: token2 => 'ERR_NUMBER',
441: value2 => '030',

Line 453: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

449: -- Insert into Errors table
450:
451: if not po_err_insert then
452:
453: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
454: token1 => 'FILE',
455: value1 => 'PO_FUNDS_CHECKER',
456: token2 => 'ERR_NUMBER',
457: value2 => '035',

Line 472: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

468: -- Insert into Errors table
469:
470: if not po_err_insert then
471:
472: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
473: token1 => 'FILE',
474: value1 => 'PO_FUNDS_CHECKER',
475: token2 => 'ERR_NUMBER',
476: value2 => '040',

Line 503: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

499: if req_enc%ISOPEN then
500: close req_enc;
501: end if;
502:
503: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
504: location => '045',
505: error_code => SQLCODE);
506:
507: return(FALSE);

Line 721: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

717: if not po_fc_init then
718:
719: -- dbms_output.put_line('po-fc_init = false');
720:
721: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
722: token1 => 'FILE',
723: value1 => 'PO_FUNDS_CHECKER',
724: token2 => 'ERR_NUMBER',
725: value2 => '050',

Line 746: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

742: p_shipid => p_shipid,
743: p_distid => p_distid,
744: p_fclevel => g_fclevel) then
745:
746: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
747: token1 => 'FILE',
748: value1 => 'PO_FUNDS_CHECKER',
749: token2 => 'ERR_NUMBER',
750: value2 => '055',

Line 767: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

763: -- dbms_output.put_line('before get select clause');
764:
765: if not po_fc_sel(p_goodstmt => l_goodstmt) then
766:
767: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
768: token1 => 'FILE',
769: value1 => 'PO_FUNDS_CHECKER',
770: token2 => 'ERR_NUMBER',
771: value2 => '060',

Line 790: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

786:
787: if not po_fc_run(p_packetid => p_packetid) then
788:
789:
790: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
791: token1 => 'FILE',
792: value1 => 'PO_FUNDS_CHECKER',
793: token2 => 'ERR_NUMBER',
794: value2 => '065',

Line 913: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

909: if pkt%ISOPEN then
910: close pkt;
911: end if;
912:
913: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
914: location => '070',
915: error_code => SQLCODE);
916:
917: return(FALSE);

Line 935: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

931: if g_doctyp = 'REQUISITION' then
932:
933: if not po_fc_selreq then
934:
935: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
936: token1 => 'FILE',
937: value1 => 'PO_FUNDS_CHECKER',
938: token2 => 'ERR_NUMBER',
939: value2 => '075',

Line 950: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

946: elsif g_doctyp = 'PO' then
947:
948: if not po_fc_selpo then
949:
950: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
951: token1 => 'FILE',
952: value1 => 'PO_FUNDS_CHECKER',
953: token2 => 'ERR_NUMBER',
954: value2 => '080',

Line 967: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

963: if g_docsubtyp = 'BLANKET' then
964:
965: if not po_fc_selblnkrel then
966:
967: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
968: token1 => 'FILE',
969: value1 => 'PO_FUNDS_CHECKER',
970: token2 => 'ERR_NUMBER',
971: value2 => '085',

Line 982: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

978: elsif g_docsubtyp = 'SCHEDULED' then
979:
980: if not po_fc_selschrel then
981:
982: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
983: token1 => 'FILE',
984: value1 => 'PO_FUNDS_CHECKER',
985: token2 => 'ERR_NUMBER',
986: value2 => '090',

Line 995: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

991: end if;
992:
993: else
994:
995: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
996: token1 => 'FILE',
997: value1 => 'PO_FUNDS_CHECKER',
998: token2 => 'ERR_NUMBER',
999: value2 => '095',

Line 1008: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

1004: end if;
1005:
1006: else
1007:
1008: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
1009: token1 => 'FILE',
1010: value1 => 'PO_FUNDS_CHECKER',
1011: token2 => 'ERR_NUMBER',
1012: value2 => '100',

Line 1028: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

1024: EXCEPTION
1025:
1026: WHEN OTHERS THEN
1027:
1028: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
1029: location => '105',
1030: error_code => SQLCODE);
1031:
1032: return(FALSE);

Line 2151: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR_WITH_MSG',

2147: /* DEBUG g_userid := 1; */
2148:
2149: if g_userid = -1 then
2150:
2151: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR_WITH_MSG',
2152: token1 => 'FILE',
2153: value1 => 'PO_FUNDS_CHECKER',
2154: token2 => 'ERR_NUMBER',
2155: value2 => '110',

Line 2181: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR_WITH_MSG',

2177:
2178:
2179: if g_loginid = -1 then
2180:
2181: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR_WITH_MSG',
2182: token1 => 'FILE',
2183: value1 => 'PO_FUNDS_CHECKER',
2184: token2 => 'ERR_NUMBER',
2185: value2 => '115',

Line 2262: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

2258: if dbms_sql.is_open(cur_insert) then
2259: dbms_sql.close_cursor(cur_insert);
2260: end if;
2261:
2262: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
2263: location => '120',
2264: error_code => SQLCODE);
2265:
2266: return(FALSE);

Line 2283: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2279: if g_doctyp = 'REQUISITION' then
2280:
2281: if not po_rollup_req then
2282:
2283: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2284: token1 => 'FILE',
2285: value1 => 'PO_FUNDS_CHECKER',
2286: token2 => 'ERR_NUMBER',
2287: value2 => '125',

Line 2298: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2294: elsif g_doctyp = 'PO' then
2295:
2296: if not po_rollup_po then
2297:
2298: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2299: token1 => 'FILE',
2300: value1 => 'PO_FUNDS_CHECKER',
2301: token2 => 'ERR_NUMBER',
2302: value2 => '130',

Line 2315: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2311: if g_docsubtyp = 'BLANKET' then
2312:
2313: if not po_rollup_blnkrel then
2314:
2315: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2316: token1 => 'FILE',
2317: value1 => 'PO_FUNDS_CHECKER',
2318: token2 => 'ERR_NUMBER',
2319: value2 => '135',

Line 2330: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2326: elsif g_docsubtyp = 'SCHEDULED' then
2327:
2328: if not po_rollup_schrel then
2329:
2330: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2331: token1 => 'FILE',
2332: value1 => 'PO_FUNDS_CHECKER',
2333: token2 => 'ERR_NUMBER',
2334: value2 => '140',

Line 2343: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2339: end if;
2340:
2341: else
2342:
2343: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2344: token1 => 'FILE',
2345: value1 => 'PO_FUNDS_CHECKER',
2346: token2 => 'ERR_NUMBER',
2347: value2 => '145',

Line 2356: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2352: end if;
2353:
2354: else
2355:
2356: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2357: token1 => 'FILE',
2358: value1 => 'PO_FUNDS_CHECKER',
2359: token2 => 'ERR_NUMBER',
2360: value2 => '150',

Line 2414: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

2410: -- Update Distributions with Funds Check Results
2411:
2412: if not po_fc_dist then
2413:
2414: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
2415: token1 => 'FILE',
2416: value1 => 'PO_FUNDS_CHECKER',
2417: token2 => 'ERR_NUMBER',
2418: value2 => '155',

Line 2447: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

2443: EXCEPTION
2444:
2445: WHEN OTHERS THEN
2446:
2447: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
2448: location => '160',
2449: error_code => SQLCODE);
2450:
2451: return(FALSE);

Line 2587: PO_MESSAGE_S.APP_ERROR('PO_ALL_TRACE_ERROR',

2583: -- Update Distributions with Funds Check Results
2584:
2585: if not po_fc_dist then
2586:
2587: PO_MESSAGE_S.APP_ERROR('PO_ALL_TRACE_ERROR',
2588: 'FILE', 'PO_FUNDS_CHECKER',
2589: 'ERR_NUMBER', '165',
2590: 'SUBROUTINE', 'PO_ROLLUP_PO()');
2591: return(FALSE);

Line 2652: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

2648: EXCEPTION
2649:
2650: WHEN OTHERS THEN
2651:
2652: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
2653: location => '170',
2654: error_code => SQLCODE);
2655:
2656: return(FALSE);

Line 2792: PO_MESSAGE_S.APP_ERROR('PO_ALL_TRACE_ERROR',

2788: -- Update Distributions with Funds Check Results
2789:
2790: if not po_fc_dist then
2791:
2792: PO_MESSAGE_S.APP_ERROR('PO_ALL_TRACE_ERROR',
2793: 'FILE', 'PO_FUNDS_CHECKER',
2794: 'ERR_NUMBER', '175',
2795: 'SUBROUTINE', 'PO_ROLLUP_BLNKREL()');
2796: return(FALSE);

Line 2857: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

2853: EXCEPTION
2854:
2855: WHEN OTHERS THEN
2856:
2857: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
2858: location => '180',
2859: error_code => SQLCODE);
2860:
2861: return(FALSE);

Line 2943: PO_MESSAGE_S.APP_ERROR('PO_ALL_TRACE_ERROR',

2939: -- Update Distributions with Funds Check Results
2940:
2941: if not po_fc_dist then
2942:
2943: PO_MESSAGE_S.APP_ERROR('PO_ALL_TRACE_ERROR',
2944: 'FILE', 'PO_FUNDS_CHECKER',
2945: 'ERR_NUMBER', '185',
2946: 'SUBROUTINE', 'PO_ROLLUP_SCHREL()');
2947: return(FALSE);

Line 2985: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

2981: EXCEPTION
2982:
2983: WHEN OTHERS THEN
2984:
2985: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
2986: location => '190',
2987: error_code => SQLCODE);
2988:
2989: return(FALSE);

Line 3139: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

3135: EXCEPTION
3136:
3137: WHEN OTHERS THEN
3138:
3139: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
3140: location => '195',
3141: error_code => SQLCODE);
3142:
3143: return(FALSE);

Line 3277: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',

3273: if report_seq%ISOPEN then
3274: close report_seq;
3275: end if;
3276:
3277: PO_MESSAGE_S.SQL_ERROR(routine => 'PO_FUNDS_CHECKER',
3278: location => '200',
3279: error_code => SQLCODE);
3280:
3281: return(FALSE);