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.CST_UNINVOICEDRECEIPTS_PVT dependencies on FND_LOG

Line 5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY CST_UninvoicedReceipts_PVT AS
2: /* $Header: CSTVURRB.pls 120.7.12010000.2 2008/08/08 12:34:39 smsasidh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='CST_UninvoicedReceipts_PVT';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: G_GL_APPLICATION_ID CONSTANT NUMBER := 101;
8: G_PO_APPLICATION_ID CONSTANT NUMBER := 201;
9:

Line 51: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

47: /* 2- PROCEDURE */
48: /* 1- STATEMENT */
49:
50: /* In general, we should use the following:
51: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

Line 52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

48: /* 1- STATEMENT */
49:
50: /* In general, we should use the following:
51: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

49:
50: /* In general, we should use the following:
51: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

50: /* In general, we should use the following:
51: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58: */

Line 55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

51: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58: */
59:

Line 56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58: */
59:
60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

Line 57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58: */
59:
60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
61: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

Line 60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58: */
59:
60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
61: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
63: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
64:

Line 61: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58: */
59:
60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
61: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
63: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
64:
65: l_msg_count NUMBER;

Line 62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

58: */
59:
60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
61: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
63: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
64:
65: l_msg_count NUMBER;
66: l_msg_data VARCHAR2(240);

Line 63: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

59:
60: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
61: l_exceptionLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
62: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
63: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
64:
65: l_msg_count NUMBER;
66: l_msg_data VARCHAR2(240);
67:

Line 96: FND_LOG.STRING(

92:
93: l_stmt_num := 0;
94: -- Procedure level log message for Entry point
95: IF (l_pLog) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,
98: l_module || '.begin',
99: 'Start_Process <<' ||
100: 'p_title = ' || p_title ||','||

Line 97: FND_LOG.LEVEL_PROCEDURE,

93: l_stmt_num := 0;
94: -- Procedure level log message for Entry point
95: IF (l_pLog) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,
98: l_module || '.begin',
99: 'Start_Process <<' ||
100: 'p_title = ' || p_title ||','||
101: 'p_accrued_receipts = ' || p_accrued_receipts ||','||

Line 454: FND_LOG.STRING(

450: END IF;
451:
452: -- Procedure level log message for exit point
453: IF (l_pLog) THEN
454: FND_LOG.STRING(
455: FND_LOG.LEVEL_PROCEDURE,
456: l_module || '.end',
457: 'Start_Process >>'
458: );

Line 455: FND_LOG.LEVEL_PROCEDURE,

451:
452: -- Procedure level log message for exit point
453: IF (l_pLog) THEN
454: FND_LOG.STRING(
455: FND_LOG.LEVEL_PROCEDURE,
456: l_module || '.end',
457: 'Start_Process >>'
458: );
459: END IF;

Line 465: FND_LOG.STRING(

461: EXCEPTION
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:
464: IF (l_exceptionLog) THEN
465: FND_LOG.STRING(
466: FND_LOG.LEVEL_EXCEPTION,
467: l_module || '.' || l_stmt_num,
468: l_msg_data
469: );

Line 466: FND_LOG.LEVEL_EXCEPTION,

462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:
464: IF (l_exceptionLog) THEN
465: FND_LOG.STRING(
466: FND_LOG.LEVEL_EXCEPTION,
467: l_module || '.' || l_stmt_num,
468: l_msg_data
469: );
470: END IF;

Line 485: -- Unexpected level log message for FND log

481: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_msg_data);
482:
483: WHEN OTHERS THEN
484:
485: -- Unexpected level log message for FND log
486: IF (l_uLog) THEN
487: FND_LOG.STRING(
488: FND_LOG.LEVEL_UNEXPECTED,
489: l_module || '.' || l_stmt_num,

Line 487: FND_LOG.STRING(

483: WHEN OTHERS THEN
484:
485: -- Unexpected level log message for FND log
486: IF (l_uLog) THEN
487: FND_LOG.STRING(
488: FND_LOG.LEVEL_UNEXPECTED,
489: l_module || '.' || l_stmt_num,
490: SQLERRM
491: );

Line 488: FND_LOG.LEVEL_UNEXPECTED,

484:
485: -- Unexpected level log message for FND log
486: IF (l_uLog) THEN
487: FND_LOG.STRING(
488: FND_LOG.LEVEL_UNEXPECTED,
489: l_module || '.' || l_stmt_num,
490: SQLERRM
491: );
492: END IF;

Line 547: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

543: l_return_status VARCHAR2(1);
544: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
545: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
546:
547: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
548: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
549: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
550:
551: l_stmt_num NUMBER;

Line 548: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

544: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
545: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
546:
547: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
548: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
549: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
550:
551: l_stmt_num NUMBER;
552: l_ctx DBMS_XMLGEN.CTXHANDLE;

Line 549: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

545: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
546:
547: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
548: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
549: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
550:
551: l_stmt_num NUMBER;
552: l_ctx DBMS_XMLGEN.CTXHANDLE;
553:

Line 559: FND_LOG.STRING(

555:
556: l_stmt_num := 0;
557: -- Procedure level log message for Entry point
558: IF (l_pLog) THEN
559: FND_LOG.STRING(
560: FND_LOG.LEVEL_PROCEDURE,
561: l_module || '.begin',
562: 'Generate_XML <<');
563: END IF;

Line 560: FND_LOG.LEVEL_PROCEDURE,

556: l_stmt_num := 0;
557: -- Procedure level log message for Entry point
558: IF (l_pLog) THEN
559: FND_LOG.STRING(
560: FND_LOG.LEVEL_PROCEDURE,
561: l_module || '.begin',
562: 'Generate_XML <<');
563: END IF;
564:

Line 602: FND_LOG.STRING(

598: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);
599:
600: -- Procedure level log message for exit point
601: IF (l_pLog) THEN
602: FND_LOG.STRING(
603: FND_LOG.LEVEL_PROCEDURE,
604: l_module || '.end',
605: 'Generate_XML >>'
606: );

Line 603: FND_LOG.LEVEL_PROCEDURE,

599:
600: -- Procedure level log message for exit point
601: IF (l_pLog) THEN
602: FND_LOG.STRING(
603: FND_LOG.LEVEL_PROCEDURE,
604: l_module || '.end',
605: 'Generate_XML >>'
606: );
607: END IF;

Line 630: FND_LOG.STRING(

626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627:
628: -- Unexpected level log message
629: IF (l_uLog) THEN
630: FND_LOG.STRING(
631: FND_LOG.LEVEL_UNEXPECTED,
632: l_module || '.' || l_stmt_num,
633: SQLERRM
634: );

Line 631: FND_LOG.LEVEL_UNEXPECTED,

627:
628: -- Unexpected level log message
629: IF (l_uLog) THEN
630: FND_LOG.STRING(
631: FND_LOG.LEVEL_UNEXPECTED,
632: l_module || '.' || l_stmt_num,
633: SQLERRM
634: );
635: END IF;

Line 684: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

680: l_return_status VARCHAR2(1);
681: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
682: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
683:
684: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
685: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
686: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
687:
688: l_ctx DBMS_XMLGEN.CTXHANDLE;

Line 685: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

681: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
682: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
683:
684: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
685: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
686: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
687:
688: l_ctx DBMS_XMLGEN.CTXHANDLE;
689: l_offset NUMBER;

Line 686: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

682: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
683:
684: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
685: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
686: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
687:
688: l_ctx DBMS_XMLGEN.CTXHANDLE;
689: l_offset NUMBER;
690: l_stmt_num NUMBER;

Line 702: FND_LOG.STRING(

698:
699: l_stmt_num := 0;
700: -- Procedure level log message for Entry point
701: IF (l_pLog) THEN
702: FND_LOG.STRING(
703: FND_LOG.LEVEL_PROCEDURE,
704: l_module || '.begin',
705: 'Merge_XML <<');
706: END IF;

Line 703: FND_LOG.LEVEL_PROCEDURE,

699: l_stmt_num := 0;
700: -- Procedure level log message for Entry point
701: IF (l_pLog) THEN
702: FND_LOG.STRING(
703: FND_LOG.LEVEL_PROCEDURE,
704: l_module || '.begin',
705: 'Merge_XML <<');
706: END IF;
707:

Line 786: FND_LOG.STRING(

782: END IF;
783:
784: -- Procedure level log message for exit point
785: IF (l_pLog) THEN
786: FND_LOG.STRING(
787: FND_LOG.LEVEL_PROCEDURE,
788: l_module || '.end',
789: 'Merge_XML >>'
790: );

Line 787: FND_LOG.LEVEL_PROCEDURE,

783:
784: -- Procedure level log message for exit point
785: IF (l_pLog) THEN
786: FND_LOG.STRING(
787: FND_LOG.LEVEL_PROCEDURE,
788: l_module || '.end',
789: 'Merge_XML >>'
790: );
791: END IF;

Line 814: FND_LOG.STRING(

810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
811:
812: -- Unexpected level log message
813: IF (l_uLog) THEN
814: FND_LOG.STRING(
815: FND_LOG.LEVEL_UNEXPECTED,
816: l_module || '.' || l_stmt_num,
817: SQLERRM
818: );

Line 815: FND_LOG.LEVEL_UNEXPECTED,

811:
812: -- Unexpected level log message
813: IF (l_uLog) THEN
814: FND_LOG.STRING(
815: FND_LOG.LEVEL_UNEXPECTED,
816: l_module || '.' || l_stmt_num,
817: SQLERRM
818: );
819: END IF;

Line 862: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

858: l_return_status VARCHAR2(1);
859: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
860: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
861:
862: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
863: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
864: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
865:
866: l_stmt_num NUMBER;

Line 863: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

859: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
860: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
861:
862: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
863: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
864: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
865:
866: l_stmt_num NUMBER;
867: l_amount NUMBER;

Line 864: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

860: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
861:
862: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
863: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
864: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
865:
866: l_stmt_num NUMBER;
867: l_amount NUMBER;
868: l_offset NUMBER;

Line 877: FND_LOG.STRING(

873:
874: l_stmt_num := 0;
875: -- Procedure level log message for Entry point
876: IF (l_pLog) THEN
877: FND_LOG.STRING(
878: FND_LOG.LEVEL_PROCEDURE,
879: l_module || '.begin',
880: 'Print_ClobOutput <<');
881: END IF;

Line 878: FND_LOG.LEVEL_PROCEDURE,

874: l_stmt_num := 0;
875: -- Procedure level log message for Entry point
876: IF (l_pLog) THEN
877: FND_LOG.STRING(
878: FND_LOG.LEVEL_PROCEDURE,
879: l_module || '.begin',
880: 'Print_ClobOutput <<');
881: END IF;
882:

Line 929: FND_LOG.STRING(

925: END LOOP;
926:
927: -- Procedure level log message for exit point
928: IF (l_pLog) THEN
929: FND_LOG.STRING(
930: FND_LOG.LEVEL_PROCEDURE,
931: l_module || '.end',
932: 'Print_ClobOutput >>'
933: );

Line 930: FND_LOG.LEVEL_PROCEDURE,

926:
927: -- Procedure level log message for exit point
928: IF (l_pLog) THEN
929: FND_LOG.STRING(
930: FND_LOG.LEVEL_PROCEDURE,
931: l_module || '.end',
932: 'Print_ClobOutput >>'
933: );
934: END IF;

Line 957: FND_LOG.STRING(

953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954:
955: -- Unexpected level log message
956: IF (l_uLog) THEN
957: FND_LOG.STRING(
958: FND_LOG.LEVEL_UNEXPECTED,
959: l_module || '.' || l_stmt_num,
960: SQLERRM
961: );

Line 958: FND_LOG.LEVEL_UNEXPECTED,

954:
955: -- Unexpected level log message
956: IF (l_uLog) THEN
957: FND_LOG.STRING(
958: FND_LOG.LEVEL_UNEXPECTED,
959: l_module || '.' || l_stmt_num,
960: SQLERRM
961: );
962: END IF;