DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on FND_LOG

Line 63: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

59: --
60: PROCEDURE print_debuginfo(
61: p_module IN VARCHAR2,
62: p_debug_text IN VARCHAR2,
63: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
64: );
65:
66: -- Get Employee Full Name from HR tables
67:

Line 4000: FND_LOG.LEVEL_UNEXPECTED

3996: || x_paymentTab(i).payment_id
3997: || 'returned: '
3998: || l_return_status
3999: || '. Raising exception ..',
4000: FND_LOG.LEVEL_UNEXPECTED
4001: );
4002:
4003: /*
4004: * This should never happen. Raise an

Line 4135: FND_LOG.LEVEL_UNEXPECTED

4131: */
4132: print_debuginfo(l_module_name, 'Reporting '
4133: || 'amount is -1. '
4134: || 'Raising exception.',
4135: FND_LOG.LEVEL_UNEXPECTED
4136: );
4137:
4138: APP_EXCEPTION.RAISE_EXCEPTION;
4139:

Line 4193: FND_LOG.LEVEL_UNEXPECTED

4189:
4190: WHEN OTHERS THEN
4191: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
4192: || 'to call GL API ''gl_currency_api.convert_amount()''.',
4193: FND_LOG.LEVEL_UNEXPECTED
4194: );
4195:
4196: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4197: FND_LOG.LEVEL_UNEXPECTED);

Line 4197: FND_LOG.LEVEL_UNEXPECTED);

4193: FND_LOG.LEVEL_UNEXPECTED
4194: );
4195:
4196: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4197: FND_LOG.LEVEL_UNEXPECTED);
4198: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4199: FND_LOG.LEVEL_UNEXPECTED);
4200:
4201: /*

Line 4199: FND_LOG.LEVEL_UNEXPECTED);

4195:
4196: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
4197: FND_LOG.LEVEL_UNEXPECTED);
4198: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
4199: FND_LOG.LEVEL_UNEXPECTED);
4200:
4201: /*
4202: * Propogate exception to caller.
4203: */

Line 5836: FND_LOG.LEVEL_UNEXPECTED

5832: || '# payments passed to hook: '
5833: || l_preHookPaymentTab.COUNT
5834: || ', # payments returning from hook: '
5835: || x_hookPaymentTab.COUNT,
5836: FND_LOG.LEVEL_UNEXPECTED
5837: );
5838:
5839: print_debuginfo(l_module_name, 'Aborting program ..',
5840: FND_LOG.LEVEL_UNEXPECTED);

Line 5840: FND_LOG.LEVEL_UNEXPECTED);

5836: FND_LOG.LEVEL_UNEXPECTED
5837: );
5838:
5839: print_debuginfo(l_module_name, 'Aborting program ..',
5840: FND_LOG.LEVEL_UNEXPECTED);
5841:
5842: APP_EXCEPTION.RAISE_EXCEPTION;
5843:
5844: END IF;

Line 5854: FND_LOG.LEVEL_UNEXPECTED

5850: || '# documents passed to hook: '
5851: || l_preHookDocsInPmtTab.COUNT
5852: || ', # documents returning from hook: '
5853: || x_hookDocsInPmtTab.COUNT,
5854: FND_LOG.LEVEL_UNEXPECTED
5855: );
5856:
5857: print_debuginfo(l_module_name, 'Aborting program ..',
5858: FND_LOG.LEVEL_UNEXPECTED);

Line 5858: FND_LOG.LEVEL_UNEXPECTED);

5854: FND_LOG.LEVEL_UNEXPECTED
5855: );
5856:
5857: print_debuginfo(l_module_name, 'Aborting program ..',
5858: FND_LOG.LEVEL_UNEXPECTED);
5859:
5860: APP_EXCEPTION.RAISE_EXCEPTION;
5861:
5862: END IF;

Line 6533: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);

6529: EXCEPTION
6530: WHEN OTHERS THEN
6531: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
6532: || 'to get calling application short name. Provided payment '
6533: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
6534: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6535: FND_LOG.LEVEL_UNEXPECTED);
6536: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6537: FND_LOG.LEVEL_UNEXPECTED);

Line 6535: FND_LOG.LEVEL_UNEXPECTED);

6531: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
6532: || 'to get calling application short name. Provided payment '
6533: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
6534: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6535: FND_LOG.LEVEL_UNEXPECTED);
6536: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6537: FND_LOG.LEVEL_UNEXPECTED);
6538:
6539: /*

Line 6537: FND_LOG.LEVEL_UNEXPECTED);

6533: || 'request id: ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
6534: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6535: FND_LOG.LEVEL_UNEXPECTED);
6536: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6537: FND_LOG.LEVEL_UNEXPECTED);
6538:
6539: /*
6540: * Propogate exception to caller.
6541: */

Line 6602: FND_LOG.LEVEL_UNEXPECTED);

6598: print_debuginfo(l_module_name, 'Fatal: External app hook '''
6599: || l_hook_name || ''', generated exception. Please '
6600: || ' contact implementor of hook in product '
6601: || l_app_short_name || ' for fix.',
6602: FND_LOG.LEVEL_UNEXPECTED);
6603:
6604: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6605: FND_LOG.LEVEL_UNEXPECTED);
6606: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,

Line 6605: FND_LOG.LEVEL_UNEXPECTED);

6601: || l_app_short_name || ' for fix.',
6602: FND_LOG.LEVEL_UNEXPECTED);
6603:
6604: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6605: FND_LOG.LEVEL_UNEXPECTED);
6606: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6607: FND_LOG.LEVEL_UNEXPECTED);
6608:
6609: /*

Line 6607: FND_LOG.LEVEL_UNEXPECTED);

6603:
6604: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
6605: FND_LOG.LEVEL_UNEXPECTED);
6606: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
6607: FND_LOG.LEVEL_UNEXPECTED);
6608:
6609: /*
6610: * Propogate exception to caller.
6611: */

Line 7969: FND_LOG.LEVEL_UNEXPECTED

7965:
7966: print_debuginfo(l_module_name, 'Unknown rejection level: '
7967: || p_rej_level
7968: || '. Aborting payment creation ..',
7969: FND_LOG.LEVEL_UNEXPECTED
7970: );
7971:
7972: APP_EXCEPTION.RAISE_EXCEPTION;
7973:

Line 8031: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);

8027: WHEN OTHERS THEN
8028: print_debuginfo(l_module_name, 'Fatal: Exception when updating '
8029: || 'payment request/payment/document status after payment '
8030: || 'creation. All changes will be rolled back. Payment request '
8031: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
8032: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8033: FND_LOG.LEVEL_UNEXPECTED);
8034: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8035: FND_LOG.LEVEL_UNEXPECTED);

Line 8033: FND_LOG.LEVEL_UNEXPECTED);

8029: || 'payment request/payment/document status after payment '
8030: || 'creation. All changes will be rolled back. Payment request '
8031: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
8032: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8033: FND_LOG.LEVEL_UNEXPECTED);
8034: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8035: FND_LOG.LEVEL_UNEXPECTED);
8036:
8037: /*

Line 8035: FND_LOG.LEVEL_UNEXPECTED);

8031: || 'id is ' || p_payreq_id, FND_LOG.LEVEL_UNEXPECTED);
8032: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8033: FND_LOG.LEVEL_UNEXPECTED);
8034: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8035: FND_LOG.LEVEL_UNEXPECTED);
8036:
8037: /*
8038: * Propogate exception to caller.
8039: */

Line 8432: FND_LOG.LEVEL_UNEXPECTED

8428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8429:
8430: print_debuginfo(l_module_name, 'API call did not succeed. '
8431: || 'Aborting build program .. ',
8432: FND_LOG.LEVEL_UNEXPECTED
8433: );
8434:
8435: APP_EXCEPTION.RAISE_EXCEPTION;
8436:

Line 8536: FND_LOG.LEVEL_UNEXPECTED

8532: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8533:
8534: print_debuginfo(l_module_name, 'API call did not succeed. '
8535: || 'Aborting build program .. ',
8536: FND_LOG.LEVEL_UNEXPECTED
8537: );
8538:
8539: APP_EXCEPTION.RAISE_EXCEPTION;
8540:

Line 8662: FND_LOG.LEVEL_UNEXPECTED

8658: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8659:
8660: print_debuginfo(l_module_name, 'API call did not '
8661: || 'succeed. Aborting build program .. ',
8662: FND_LOG.LEVEL_UNEXPECTED
8663: );
8664:
8665: APP_EXCEPTION.RAISE_EXCEPTION;
8666:

Line 8762: FND_LOG.LEVEL_UNEXPECTED

8758:
8759: print_debuginfo(l_module_name, 'Unknown rejection level: '
8760: || p_rej_level
8761: || '. Aborting payment creation ..',
8762: FND_LOG.LEVEL_UNEXPECTED
8763: );
8764:
8765: APP_EXCEPTION.RAISE_EXCEPTION;
8766:

Line 8774: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);

8770:
8771: EXCEPTION
8772: WHEN OTHERS THEN
8773: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
8774: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
8775: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8776: FND_LOG.LEVEL_UNEXPECTED);
8777: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8778: FND_LOG.LEVEL_UNEXPECTED);

Line 8776: FND_LOG.LEVEL_UNEXPECTED);

8772: WHEN OTHERS THEN
8773: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
8774: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
8775: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8776: FND_LOG.LEVEL_UNEXPECTED);
8777: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8778: FND_LOG.LEVEL_UNEXPECTED);
8779:
8780: /*

Line 8778: FND_LOG.LEVEL_UNEXPECTED);

8774: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
8775: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
8776: FND_LOG.LEVEL_UNEXPECTED);
8777: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
8778: FND_LOG.LEVEL_UNEXPECTED);
8779:
8780: /*
8781: * Propogate exception to caller.
8782: */

Line 9016: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);

9012: RETURN NULL;
9013: END IF;
9014:
9015: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
9016: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
9017: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
9018: FND_LOG.LEVEL_UNEXPECTED);
9019: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
9020: FND_LOG.LEVEL_UNEXPECTED);

Line 9018: FND_LOG.LEVEL_UNEXPECTED);

9014:
9015: print_debuginfo(l_module_name, 'Fatal: Exception when attempting '
9016: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
9017: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
9018: FND_LOG.LEVEL_UNEXPECTED);
9019: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
9020: FND_LOG.LEVEL_UNEXPECTED);
9021:
9022: /*

Line 9020: FND_LOG.LEVEL_UNEXPECTED);

9016: || 'to raise business event.', FND_LOG.LEVEL_UNEXPECTED);
9017: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
9018: FND_LOG.LEVEL_UNEXPECTED);
9019: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
9020: FND_LOG.LEVEL_UNEXPECTED);
9021:
9022: /*
9023: * Propogate exception to caller.
9024: */

Line 9339: FND_LOG.LEVEL_UNEXPECTED

9335: || 'system option is not set at enterprise level. '
9336: || 'It is mandatory to '
9337: || 'setup review pmts flag at enterprise level '
9338: || 'Raising exception.. ',
9339: FND_LOG.LEVEL_UNEXPECTED
9340: );
9341:
9342: APP_EXCEPTION.RAISE_EXCEPTION;
9343:

Line 9359: FND_LOG.LEVEL_UNEXPECTED

9355: || 'enterprise level. It is mandatory to '
9356: || 'setup only one review payment flag sys option '
9357: || 'at enterprise level. '
9358: || 'Raising exception.. ',
9359: FND_LOG.LEVEL_UNEXPECTED
9360: );
9361:
9362: APP_EXCEPTION.RAISE_EXCEPTION;
9363:

Line 9480: FND_LOG.LEVEL_UNEXPECTED

9476: || 'system option is not set at enterprise level. '
9477: || 'It is mandatory to '
9478: || 'setup rejection levels at enterprise level '
9479: || 'Raising exception.. ',
9480: FND_LOG.LEVEL_UNEXPECTED
9481: );
9482:
9483: APP_EXCEPTION.RAISE_EXCEPTION;
9484:

Line 9500: FND_LOG.LEVEL_UNEXPECTED

9496: || 'enterprise level. It is mandatory to '
9497: || 'setup only one payment rejection level '
9498: || 'at enterprise level. '
9499: || 'Raising exception.. ',
9500: FND_LOG.LEVEL_UNEXPECTED
9501: );
9502:
9503: APP_EXCEPTION.RAISE_EXCEPTION;
9504:

Line 10251: FND_LOG.LEVEL_UNEXPECTED

10247: * exception.
10248: */
10249: print_debuginfo(l_module_name, 'Maturity date is a must '
10250: || 'for a bill payable. Aborting ..',
10251: FND_LOG.LEVEL_UNEXPECTED
10252: );
10253:
10254: APP_EXCEPTION.RAISE_EXCEPTION;
10255:

Line 10831: FND_LOG.LEVEL_UNEXPECTED

10827: WHEN OTHERS THEN
10828: print_debuginfo(l_module_name, 'Fatal: Japanese bank charge '
10829: || 'hook ''' || l_hook_name
10830: || ''', generated exception.',
10831: FND_LOG.LEVEL_UNEXPECTED
10832: );
10833:
10834: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10835: FND_LOG.LEVEL_UNEXPECTED);

Line 10835: FND_LOG.LEVEL_UNEXPECTED);

10831: FND_LOG.LEVEL_UNEXPECTED
10832: );
10833:
10834: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10835: FND_LOG.LEVEL_UNEXPECTED);
10836: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10837: FND_LOG.LEVEL_UNEXPECTED);
10838:
10839: /*

Line 10837: FND_LOG.LEVEL_UNEXPECTED);

10833:
10834: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10835: FND_LOG.LEVEL_UNEXPECTED);
10836: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10837: FND_LOG.LEVEL_UNEXPECTED);
10838:
10839: /*
10840: * Propogate exception to caller.
10841: */

Line 10854: FND_LOG.LEVEL_UNEXPECTED

10850:
10851: print_debuginfo(l_module_name, 'Fatal: Japanese bank charge hook '''
10852: || l_hook_name || ''' returned error status code: '
10853: || l_return_status,
10854: FND_LOG.LEVEL_UNEXPECTED
10855: );
10856:
10857: print_debuginfo(l_module_name, 'Raising exception .. ',
10858: FND_LOG.LEVEL_UNEXPECTED);

Line 10858: FND_LOG.LEVEL_UNEXPECTED);

10854: FND_LOG.LEVEL_UNEXPECTED
10855: );
10856:
10857: print_debuginfo(l_module_name, 'Raising exception .. ',
10858: FND_LOG.LEVEL_UNEXPECTED);
10859:
10860: APP_EXCEPTION.RAISE_EXCEPTION;
10861:
10862: END IF;

Line 10992: FND_LOG.LEVEL_UNEXPECTED

10988:
10989: WHEN OTHERS THEN
10990: print_debuginfo(l_module_name, 'Fatal: Extended witholding hook '''
10991: || l_hook_name || ''', generated exception. ',
10992: FND_LOG.LEVEL_UNEXPECTED
10993: );
10994:
10995: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10996: FND_LOG.LEVEL_UNEXPECTED);

Line 10996: FND_LOG.LEVEL_UNEXPECTED);

10992: FND_LOG.LEVEL_UNEXPECTED
10993: );
10994:
10995: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10996: FND_LOG.LEVEL_UNEXPECTED);
10997: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10998: FND_LOG.LEVEL_UNEXPECTED);
10999:
11000: /*

Line 10998: FND_LOG.LEVEL_UNEXPECTED);

10994:
10995: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE,
10996: FND_LOG.LEVEL_UNEXPECTED);
10997: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM,
10998: FND_LOG.LEVEL_UNEXPECTED);
10999:
11000: /*
11001: * Propogate exception to caller.
11002: */

Line 11015: FND_LOG.LEVEL_UNEXPECTED

11011:
11012: print_debuginfo(l_module_name, 'Fatal: Extended witholding hook '''
11013: || l_hook_name || ''' returned error status code: '
11014: || l_return_status,
11015: FND_LOG.LEVEL_UNEXPECTED
11016: );
11017:
11018: print_debuginfo(l_module_name, 'Raising exception .. ',
11019: FND_LOG.LEVEL_UNEXPECTED);

Line 11019: FND_LOG.LEVEL_UNEXPECTED);

11015: FND_LOG.LEVEL_UNEXPECTED
11016: );
11017:
11018: print_debuginfo(l_module_name, 'Raising exception .. ',
11019: FND_LOG.LEVEL_UNEXPECTED);
11020:
11021: APP_EXCEPTION.RAISE_EXCEPTION;
11022:
11023: END IF;

Line 14598: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

14594: *---------------------------------------------------------------------*/
14595: PROCEDURE print_debuginfo(
14596: p_module IN VARCHAR2,
14597: p_debug_text IN VARCHAR2,
14598: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
14599: )
14600: IS
14601: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
14602: BEGIN

Line 14601: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;

14597: p_debug_text IN VARCHAR2,
14598: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
14599: )
14600: IS
14601: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
14602: BEGIN
14603:
14604: /*
14605: * Set the debug level to the value passed in

Line 14615: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

14611:
14612: /*
14613: * Write the debug message to the concurrent manager log file.
14614: */
14615: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
14616: iby_build_utils_pkg.print_debuginfo(p_module, p_debug_text,
14617: p_debug_level);
14618: END IF;
14619: