DBA Data[Home] [Help]

APPS.PO_FUNDS_CHECKER dependencies on PO_FUNDS_CHECKER

Line 1: PACKAGE BODY PO_FUNDS_CHECKER AS

1: PACKAGE BODY PO_FUNDS_CHECKER AS
2: /* $Header: POXPOFCB.pls 115.8 2003/03/06 10:07:11 krsethur ship $ */
3:
4: -- Types :
5: --

Line 222: 'Starting PO Funds Checker:' || g_delim ||

218: -- dbms_output.put_line('in funds control');
219: -- FRKHAN BUG 941171 9/14/99
220: IF LENGTH (g_dbug) < x_max_length THEN
221: g_dbug := g_dbug ||
222: 'Starting PO Funds Checker:' || g_delim ||
223: 'Hdr:' || p_docid || g_delim ||
224: 'Type:' || p_doctyp || g_delim ||
225: 'Subtype:' || p_docsubtyp || g_delim ||
226: 'Line:' || p_lineid || g_delim ||

Line 263: value1 => 'PO_FUNDS_CHECKER',

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',
266: token3 => 'SUBROUTINE',
267: value3 => 'PO_FUNDS_CONTROL()');

Line 287: value1 => 'PO_FUNDS_CHECKER',

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',
290: token3 => 'SUBROUTINE',
291: value3 => 'PO_FUNDS_CONTROL()');

Line 313: value1 => 'PO_FUNDS_CHECKER',

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',
316: token3 => 'SUBROUTINE',
317: value3 => 'PO_FUNDS_CONTROL()');

Line 402: value1 => 'PO_FUNDS_CHECKER',

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',
405: token3 => 'SUBROUTINE',
406: value3 => 'PO_FUNDS_CONTROL()');

Line 421: value1 => 'PO_FUNDS_CHECKER',

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',
424: token3 => 'SUBROUTINE',
425: value3 => 'PO_FUNDS_CONTROL()');

Line 439: value1 => 'PO_FUNDS_CHECKER',

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',
442: token3 => 'SUBROUTINE',
443: value3 => 'PO_FUNDS_CONTROL()');

Line 455: value1 => 'PO_FUNDS_CHECKER',

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',
458: token3 => 'SUBROUTINE',
459: value3 => 'PO_FUNDS_CONTROL()');

Line 474: value1 => 'PO_FUNDS_CHECKER',

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',
477: token3 => 'SUBROUTINE',
478: value3 => 'PO_FUNDS_CONTROL()');

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 723: value1 => 'PO_FUNDS_CHECKER',

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',
726: token3 => 'SUBROUTINE',
727: value3 => 'PO_FC_INS()');

Line 748: value1 => 'PO_FUNDS_CHECKER',

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',
751: token3 => 'SUBROUTINE',
752: value3 => 'PO_FC_INS()');

Line 769: value1 => 'PO_FUNDS_CHECKER',

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',
772: token3 => 'SUBROUTINE',
773: value3 => 'PO_FC_INS()');

Line 792: value1 => 'PO_FUNDS_CHECKER',

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',
795: token3 => 'SUBROUTINE',
796: value3 => 'PO_FC_INS()');

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 937: value1 => 'PO_FUNDS_CHECKER',

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',
940: token3 => 'SUBROUTINE',
941: value3 => 'PO_FC_SEL()');

Line 952: value1 => 'PO_FUNDS_CHECKER',

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',
955: token3 => 'SUBROUTINE',
956: value3 => 'PO_FC_SEL()');

Line 969: value1 => 'PO_FUNDS_CHECKER',

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',
972: token3 => 'SUBROUTINE',
973: value3 => 'PO_FC_SEL()');

Line 984: value1 => 'PO_FUNDS_CHECKER',

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',
987: token3 => 'SUBROUTINE',
988: value3 => 'PO_FC_SEL()');

Line 997: value1 => 'PO_FUNDS_CHECKER',

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',
1000: token3 => 'SUBROUTINE',
1001: value3 => 'PO_FC_SEL()');

Line 1010: value1 => 'PO_FUNDS_CHECKER',

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',
1013: token3 => 'SUBROUTINE',
1014: value3 => 'PO_FC_SEL()');

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 2153: value1 => 'PO_FUNDS_CHECKER',

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',
2156: token3 => 'SUBROUTINE',
2157: value3 => 'PO_FC_RUN()',

Line 2183: value1 => 'PO_FUNDS_CHECKER',

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',
2186: token3 => 'SUBROUTINE',
2187: value3 => 'PO_FC_RUN()',

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 2285: value1 => 'PO_FUNDS_CHECKER',

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',
2288: token3 => 'SUBROUTINE',
2289: value3 => 'PO_ROLLUP_ENC()');

Line 2300: value1 => 'PO_FUNDS_CHECKER',

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',
2303: token3 => 'SUBROUTINE',
2304: value3 => 'PO_ROLLUP_ENC()');

Line 2317: value1 => 'PO_FUNDS_CHECKER',

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',
2320: token3 => 'SUBROUTINE',
2321: value3 => 'PO_ROLLUP_ENC()');

Line 2332: value1 => 'PO_FUNDS_CHECKER',

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',
2335: token3 => 'SUBROUTINE',
2336: value3 => 'PO_ROLLUP_ENC()');

Line 2345: value1 => 'PO_FUNDS_CHECKER',

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',
2348: token3 => 'SUBROUTINE',
2349: value3 => 'PO_ROLLUP_ENC()');

Line 2358: value1 => 'PO_FUNDS_CHECKER',

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',
2361: token3 => 'SUBROUTINE',
2362: value3 => 'PO_ROLLUP_ENC()');

Line 2416: value1 => 'PO_FUNDS_CHECKER',

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',
2419: token3 => 'SUBROUTINE',
2420: value3 => 'PO_ROLLUP_REQ()');

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 2588: 'FILE', 'PO_FUNDS_CHECKER',

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);
2592:

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 2793: 'FILE', 'PO_FUNDS_CHECKER',

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);
2797:

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 2944: 'FILE', 'PO_FUNDS_CHECKER',

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);
2948:

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);

Line 3304: END PO_FUNDS_CHECKER;

3300: END get_debug;
3301:
3302: /* ----------------------------------------------------------------------- */
3303:
3304: END PO_FUNDS_CHECKER;
3305: