eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG dependencies on FND_LOG

Line 7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3:
4: --
5: -- Declare global variables
6: --
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_BUILD_INSTRUCTIONS_PUB_PKG';
10:
11: --

Line 8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

4: --
5: -- Declare global variables
6: --
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBY_BUILD_INSTRUCTIONS_PUB_PKG';
10:
11: --
12: -- List of instruction statuses that are used / set in this

Line 487: FND_LOG.LEVEL_UNEXPECTED

483: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
484: print_debuginfo(l_module_name, 'Check '
485: || 'numbering module returned failure '
486: || 'response. Aborting.. ',
487: FND_LOG.LEVEL_UNEXPECTED
488: );
489:
490: END IF;
491: APP_EXCEPTION.RAISE_EXCEPTION;

Line 534: FND_LOG.LEVEL_UNEXPECTED

530: print_debuginfo(l_module_name, 'Extract and '
531: || 'format operation generated '
532: || 'exception for payment instruction '
533: || l_pmtInstrTab(i).payment_instruction_id,
534: FND_LOG.LEVEL_UNEXPECTED
535: );
536:
537: print_debuginfo(l_module_name, 'SQL code: '
538: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 538: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

534: FND_LOG.LEVEL_UNEXPECTED
535: );
536:
537: print_debuginfo(l_module_name, 'SQL code: '
538: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
539: print_debuginfo(l_module_name, 'SQL err msg: '
540: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
541:
542: END IF;

Line 540: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

536:
537: print_debuginfo(l_module_name, 'SQL code: '
538: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
539: print_debuginfo(l_module_name, 'SQL err msg: '
540: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
541:
542: END IF;
543: /*
544: * Propogate exception.

Line 646: || l_callout_name, FND_LOG.LEVEL_UNEXPECTED);

642:
643: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
644: print_debuginfo(l_module_name,
645: 'Attempting to call hook: '
646: || l_callout_name, FND_LOG.LEVEL_UNEXPECTED);
647:
648: END IF;
649: l_stmt := 'CALL '|| l_callout_name
650: || '(:1, :2, :3, :4, :5, :6, :7, :8)';

Line 672: || l_ret_status, FND_LOG.LEVEL_UNEXPECTED);

668: print_debuginfo(l_module_name,
669: 'Finished invoking hook: '
670: || l_callout_name
671: || ', return status: '
672: || l_ret_status, FND_LOG.LEVEL_UNEXPECTED);
673:
674: END IF;
675: /*
676: * If the called procedure did not return success,

Line 690: FND_LOG.LEVEL_UNEXPECTED);

686: || l_callout_name
687: || ''', returned failure status - '
688: || l_ret_status
689: || '. Raising exception.',
690: FND_LOG.LEVEL_UNEXPECTED);
691:
692: END IF;
693: APP_EXCEPTION.RAISE_EXCEPTION;
694:

Line 705: FND_LOG.LEVEL_UNEXPECTED);

701: print_debuginfo(l_module_name,
702: 'Callout "'
703: || l_callout_name
704: || '" not implemented by application - AP',
705: FND_LOG.LEVEL_UNEXPECTED);
706:
707: print_debuginfo(l_module_name,
708: 'Skipping hook call.');
709:

Line 719: FND_LOG.LEVEL_UNEXPECTED

715: 'Fatal: External app '
716: || 'callout '''
717: || l_callout_name
718: || ''', generated exception.',
719: FND_LOG.LEVEL_UNEXPECTED
720: );
721:
722: END IF;
723: l_error_code := 'IBY_INS_AWT_CERT_HOOK_FAILED';

Line 784: FND_LOG.LEVEL_UNEXPECTED

780: print_debuginfo(l_module_name, 'Extract and '
781: || 'format operation generated '
782: || 'exception for payment instruction '
783: || l_pmtInstrTab(i).payment_instruction_id,
784: FND_LOG.LEVEL_UNEXPECTED
785: );
786:
787: print_debuginfo(l_module_name, 'SQL code: '
788: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 788: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

784: FND_LOG.LEVEL_UNEXPECTED
785: );
786:
787: print_debuginfo(l_module_name, 'SQL code: '
788: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
789: print_debuginfo(l_module_name, 'SQL err msg: '
790: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
791:
792: END IF;

Line 790: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

786:
787: print_debuginfo(l_module_name, 'SQL code: '
788: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
789: print_debuginfo(l_module_name, 'SQL err msg: '
790: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
791:
792: END IF;
793: /*
794: * Propogate exception.

Line 989: FND_LOG.LEVEL_UNEXPECTED

985: print_debuginfo(l_module_name, 'Attributes of payment '
986: || 'instruction id: '
987: || p_pmt_instr_id
988: || ' could not be retrieved. Aborting rebuild ..',
989: FND_LOG.LEVEL_UNEXPECTED
990: );
991:
992: END IF;
993: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1199: FND_LOG.LEVEL_UNEXPECTED

1195: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1196: print_debuginfo(l_module_name, 'Check '
1197: || 'numbering module returned failure '
1198: || 'response. Aborting.. ',
1199: FND_LOG.LEVEL_UNEXPECTED
1200: );
1201:
1202: END IF;
1203: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1246: FND_LOG.LEVEL_UNEXPECTED

1242: print_debuginfo(l_module_name, 'Extract and '
1243: || 'format operation generated '
1244: || 'exception for payment instruction '
1245: || l_instr_tab(i).payment_instruction_id,
1246: FND_LOG.LEVEL_UNEXPECTED
1247: );
1248:
1249: print_debuginfo(l_module_name, 'SQL code: '
1250: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 1250: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

1246: FND_LOG.LEVEL_UNEXPECTED
1247: );
1248:
1249: print_debuginfo(l_module_name, 'SQL code: '
1250: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
1251: print_debuginfo(l_module_name, 'SQL err msg: '
1252: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
1253:
1254: END IF;

Line 1252: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

1248:
1249: print_debuginfo(l_module_name, 'SQL code: '
1250: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
1251: print_debuginfo(l_module_name, 'SQL err msg: '
1252: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
1253:
1254: END IF;
1255: /*
1256: * Propogate exception.

Line 1383: FND_LOG.LEVEL_UNEXPECTED

1379: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1380: print_debuginfo(l_module_name, 'Check '
1381: || 'numbering module returned failure '
1382: || 'response. Aborting.. ',
1383: FND_LOG.LEVEL_UNEXPECTED
1384: );
1385:
1386: END IF;
1387: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1430: FND_LOG.LEVEL_UNEXPECTED

1426: print_debuginfo(l_module_name, 'Extract and '
1427: || 'format operation generated '
1428: || 'exception for payment instruction '
1429: || l_instr_tab(i).payment_instruction_id,
1430: FND_LOG.LEVEL_UNEXPECTED
1431: );
1432:
1433: print_debuginfo(l_module_name, 'SQL code: '
1434: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 1434: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

1430: FND_LOG.LEVEL_UNEXPECTED
1431: );
1432:
1433: print_debuginfo(l_module_name, 'SQL code: '
1434: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
1435: print_debuginfo(l_module_name, 'SQL err msg: '
1436: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
1437:
1438: END IF;

Line 1436: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

1432:
1433: print_debuginfo(l_module_name, 'SQL code: '
1434: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
1435: print_debuginfo(l_module_name, 'SQL err msg: '
1436: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
1437:
1438: END IF;
1439: /*
1440: * Propogate exception.

Line 1552: FND_LOG.LEVEL_UNEXPECTED

1548: print_debuginfo(l_module_name, 'Extract and '
1549: || 'format operation generated '
1550: || 'exception for payment instruction '
1551: || l_instr_tab(i).payment_instruction_id,
1552: FND_LOG.LEVEL_UNEXPECTED
1553: );
1554:
1555: print_debuginfo(l_module_name, 'SQL code: '
1556: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

Line 1556: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);

1552: FND_LOG.LEVEL_UNEXPECTED
1553: );
1554:
1555: print_debuginfo(l_module_name, 'SQL code: '
1556: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
1557: print_debuginfo(l_module_name, 'SQL err msg: '
1558: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
1559:
1560: END IF;

Line 1558: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);

1554:
1555: print_debuginfo(l_module_name, 'SQL code: '
1556: || SQLCODE, FND_LOG.LEVEL_UNEXPECTED);
1557: print_debuginfo(l_module_name, 'SQL err msg: '
1558: || SQLERRM, FND_LOG.LEVEL_UNEXPECTED);
1559:
1560: END IF;
1561: /*
1562: * Propogate exception.

Line 2216: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT

2212: *---------------------------------------------------------------------*/
2213: PROCEDURE print_debuginfo(
2214: p_module IN VARCHAR2,
2215: p_debug_text IN VARCHAR2,
2216: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
2217: )
2218: IS
2219: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
2220: BEGIN

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

2215: p_debug_text IN VARCHAR2,
2216: p_debug_level IN VARCHAR2 DEFAULT FND_LOG.LEVEL_STATEMENT
2217: )
2218: IS
2219: l_default_debug_level VARCHAR2(200) := FND_LOG.LEVEL_STATEMENT;
2220: BEGIN
2221:
2222: IF (p_debug_level IS NOT NULL) THEN
2223: l_default_debug_level := p_debug_level;

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

2225:
2226: /*
2227: * Write the debug message to the concurrent manager log file.
2228: */
2229: IF (l_default_debug_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2230: iby_build_utils_pkg.print_debuginfo(p_module, p_debug_text,
2231: p_debug_level);
2232: END IF;
2233: