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_PENDINGTXNSREPORT_PVT dependencies on FND_LOG

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

1: PACKAGE BODY CST_PendingTxnsReport_PVT AS
2: /* $Header: CSTVPTRB.pls 120.17 2010/12/12 17:28:37 vkatakam ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_PendingTxnsReport_PVT';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: -- API name : generateXML
8: -- Description : The API is directly called by the Period Close Pending
9: -- transactions report.

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

53:
54: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
55: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
56:
57: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
58: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
59: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
60: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
61: /*Bug 7305146*/

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

54: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
55: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
56:
57: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
58: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
59: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
60: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
61: /*Bug 7305146*/
62: l_encoding VARCHAR2(20);

Line 59: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

55: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
56:
57: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
58: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
59: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
60: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
61: /*Bug 7305146*/
62: l_encoding VARCHAR2(20);
63: l_xml_header VARCHAR2(100);

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

56:
57: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
58: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
59: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
60: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
61: /*Bug 7305146*/
62: l_encoding VARCHAR2(20);
63: l_xml_header VARCHAR2(100);
64: l_legal_entity NUMBER := 0;

Line 69: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

65:
66: BEGIN
67:
68: IF (l_pLog) THEN
69: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
70: l_module || '.begin',
71: '>>> ' || l_api_name || ':Parameters:' ||
72: 'Org id: ' || p_org_id ||
73: '; period id: ' || p_period_id ||

Line 402: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

398: l_offset := l_offset + l_amount;
399: END LOOP;
400:
401: IF (l_eventLog) THEN
402: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
403: l_module || '.' || l_stmt_num,
404: 'Completed writing to output file');
405: END IF;
406:

Line 412: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

408: DBMS_LOB.FREETEMPORARY (l_xml_doc);
409: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', 'Request Completed Successfully');
410:
411: IF (l_pLog) THEN
412: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
413: l_module || '.end',
414: '<<< ' || l_api_name);
415: END IF;
416:

Line 429: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

425: x_return_status=> l_return_status);
426: l_msg_data := SUBSTRB (SQLERRM,1,240);
427: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
428: IF (l_uLog) THEN
429: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
430: l_module || '.' || l_stmt_num,
431: l_msg_data);
432: END IF;
433: WHEN OTHERS THEN

Line 435: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

431: l_msg_data);
432: END IF;
433: WHEN OTHERS THEN
434: IF (l_uLog) THEN
435: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
436: l_module || '.' || l_stmt_num,
437: SUBSTRB (SQLERRM , 1 , 240));
438: END IF;
439: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

479:
480: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
481: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
482:
483: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
484: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
485: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
486: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
487:

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

480: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
481: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
482:
483: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
484: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
485: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
486: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
487:
488: BEGIN

Line 485: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

481: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
482:
483: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
484: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
485: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
486: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
487:
488: BEGIN
489:

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

482:
483: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
484: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
485: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
486: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
487:
488: BEGIN
489:
490: IF (l_pLog) THEN

Line 491: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

487:
488: BEGIN
489:
490: IF (l_pLog) THEN
491: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
492: l_module || '.begin',
493: '>>> ' || l_api_name);
494: END IF;
495:

Line 582: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

578: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: IF (l_pLog) THEN
582: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
583: l_module || '.end',
584: '<<< ' || l_api_name);
585: END IF;
586: EXCEPTION

Line 596: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

592: );
593: WHEN OTHERS THEN
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
595: IF (l_uLog) THEN
596: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
597: l_module || '.' || l_stmt_num,
598: SUBSTRB (SQLERRM , 1 , 240));
599: END IF;
600:

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

633:
634: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
635: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
636:
637: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
638: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
639: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
640: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
641: BEGIN

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

634: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
635: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
636:
637: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
638: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
639: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
640: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
641: BEGIN
642:

Line 639: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

635: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
636:
637: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
638: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
639: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
640: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
641: BEGIN
642:
643: IF (l_pLog) THEN

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

636:
637: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
638: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
639: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
640: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
641: BEGIN
642:
643: IF (l_pLog) THEN
644: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 644: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

640: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
641: BEGIN
642:
643: IF (l_pLog) THEN
644: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
645: l_module || '.begin',
646: '>>> ' || l_api_name);
647: END IF;
648:

Line 768: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

764: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
765: p_data => x_msg_data);
766:
767: IF (l_pLog) THEN
768: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
769: l_module || '.end',
770: '<<< ' || l_api_name);
771: END IF;
772:

Line 781: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

777: p_data => x_msg_data);
778: WHEN OTHERS THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: IF (l_uLog) THEN
781: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
782: l_module || '.' || l_stmt_num,
783: SUBSTRB (SQLERRM , 1 , 240));
784: END IF;
785:

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

813:
814: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
815: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
816:
817: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
818: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
819: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
820: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
821: BEGIN

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

814: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
815: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
816:
817: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
818: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
819: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
820: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
821: BEGIN
822: IF (l_pLog) THEN

Line 819: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

815: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
816:
817: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
818: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
819: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
820: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
821: BEGIN
822: IF (l_pLog) THEN
823: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

816:
817: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
818: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
819: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
820: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
821: BEGIN
822: IF (l_pLog) THEN
823: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
824: l_module || '.begin',

Line 823: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

819: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
820: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
821: BEGIN
822: IF (l_pLog) THEN
823: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
824: l_module || '.begin',
825: '>>> ' || l_api_name);
826: END IF;
827:

Line 932: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

928: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
929: p_data => x_msg_data);
930:
931: IF (l_pLog) THEN
932: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
933: l_module || '.end',
934: '<<< ' || l_api_name);
935: END IF;
936: EXCEPTION

Line 944: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

940: p_data => x_msg_data);
941: WHEN OTHERS THEN
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: IF (l_uLog) THEN
944: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
945: l_module || '.' || l_stmt_num,
946: SUBSTRB (SQLERRM , 1 , 240));
947: END IF;
948:

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

976:
977: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
978: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
979:
980: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
981: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
982: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
983: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
984: BEGIN

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

977: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
978: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
979:
980: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
981: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
982: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
983: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
984: BEGIN
985: IF (l_pLog) THEN

Line 982: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

978: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
979:
980: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
981: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
982: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
983: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
984: BEGIN
985: IF (l_pLog) THEN
986: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

979:
980: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
981: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
982: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
983: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
984: BEGIN
985: IF (l_pLog) THEN
986: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
987: l_module || '.begin',

Line 986: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

982: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
983: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
984: BEGIN
985: IF (l_pLog) THEN
986: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
987: l_module || '.begin',
988: '>>> ' || l_api_name);
989: END IF;
990:

Line 1099: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data);
1098: IF (l_pLog) THEN
1099: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1100: l_module || '.end',
1101: '<<< ' || l_api_name);
1102: END IF;
1103: EXCEPTION

Line 1111: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1107: p_data => x_msg_data);
1108: WHEN OTHERS THEN
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1110: IF (l_uLog) THEN
1111: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1112: l_module || '.' || l_stmt_num,
1113: SUBSTRB (SQLERRM , 1 , 240));
1114: END IF;
1115:

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

1148:
1149: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1150: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1151:
1152: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1153: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1154: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1155: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1156: BEGIN

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

1149: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1150: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1151:
1152: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1153: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1154: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1155: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1156: BEGIN
1157: IF (l_pLog) THEN

Line 1154: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1150: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1151:
1152: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1153: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1154: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1155: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1156: BEGIN
1157: IF (l_pLog) THEN
1158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

1151:
1152: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1153: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1154: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1155: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1156: BEGIN
1157: IF (l_pLog) THEN
1158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1159: l_module || '.begin',

Line 1158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1154: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1155: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1156: BEGIN
1157: IF (l_pLog) THEN
1158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1159: l_module || '.begin',
1160: '>>> ' || l_api_name);
1161: END IF;
1162:

Line 1248: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

1244: DBMS_XMLGEN.closeContext(l_ctx);
1245: CLOSE l_ref_cur;
1246:
1247: IF (l_eventLog) THEN
1248: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
1249: l_module || '.' || l_stmt_num,
1250: 'Completed WSMTI transactions');
1251: END IF;
1252:

Line 1327: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

1323: DBMS_XMLGEN.closeContext(l_ctx);
1324: CLOSE l_ref_cur;
1325:
1326: IF (l_eventLog) THEN
1327: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
1328: l_module || '.' || l_stmt_num,
1329: 'Completed WLMTI transactions');
1330: END IF;
1331:

Line 1396: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,

1392: DBMS_XMLGEN.closeContext(l_ctx);
1393: CLOSE l_ref_cur;
1394:
1395: IF (l_eventLog) THEN
1396: FND_LOG.STRING (FND_LOG.LEVEL_EVENT,
1397: l_module || '.' || l_stmt_num,
1398: 'Completed WLSMI transactions');
1399: END IF;
1400:

Line 1427: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1423: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1424: p_data => x_msg_data);
1425:
1426: IF (l_pLog) THEN
1427: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1428: l_module || '.end',
1429: '<<< ' || l_api_name);
1430: END IF;
1431: EXCEPTION

Line 1439: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1435: p_data => x_msg_data);
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1438: IF (l_uLog) THEN
1439: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1440: l_module || '.' || l_stmt_num,
1441: SUBSTRB (SQLERRM , 1 , 240));
1442: END IF;
1443:

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

1472: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1473: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1474: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1475:
1476: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1477: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1478: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1479: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1480: BEGIN

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

1473: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1474: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1475:
1476: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1477: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1478: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1479: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1480: BEGIN
1481: IF (l_pLog) THEN

Line 1478: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1474: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1475:
1476: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1477: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1478: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1479: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1480: BEGIN
1481: IF (l_pLog) THEN
1482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

1475:
1476: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1477: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1478: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1479: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1480: BEGIN
1481: IF (l_pLog) THEN
1482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1483: l_module || '.begin',

Line 1482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1478: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1479: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1480: BEGIN
1481: IF (l_pLog) THEN
1482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1483: l_module || '.begin',
1484: '>>> ' || l_api_name);
1485: END IF;
1486:

Line 1628: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1624: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1625: p_data => x_msg_data);
1626:
1627: IF (l_pLog) THEN
1628: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1629: l_module || '.end',
1630: '<<< ' || l_api_name);
1631: END IF;
1632:

Line 1641: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1637: p_data => x_msg_data);
1638: WHEN OTHERS THEN
1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1640: IF (l_uLog) THEN
1641: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1642: l_module || '.' || l_stmt_num,
1643: SUBSTRB (SQLERRM , 1 , 240));
1644: END IF;
1645:

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

1673:
1674: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1675: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1676:
1677: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1678: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1679: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1680: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1681: BEGIN

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

1674: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1675: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1676:
1677: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1678: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1679: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1680: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1681: BEGIN
1682: IF (l_pLog) THEN

Line 1679: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1675: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1676:
1677: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1678: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1679: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1680: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1681: BEGIN
1682: IF (l_pLog) THEN
1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

1676:
1677: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1678: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1679: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1680: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1681: BEGIN
1682: IF (l_pLog) THEN
1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1684: l_module || '.begin',

Line 1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1679: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1680: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1681: BEGIN
1682: IF (l_pLog) THEN
1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1684: l_module || '.begin',
1685: '>>> ' || l_api_name);
1686: END IF;
1687:

Line 1799: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1795: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:
1798: IF (l_pLog) THEN
1799: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1800: l_module || '.end',
1801: '<<< ' || l_api_name);
1802: END IF;
1803: EXCEPTION

Line 1811: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1807: p_data => x_msg_data);
1808: WHEN OTHERS THEN
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1810: IF (l_uLog) THEN
1811: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1812: l_module || '.' || l_stmt_num,
1813: SUBSTRB (SQLERRM , 1 , 240));
1814: END IF;
1815:

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

1843:
1844: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1845: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1846:
1847: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1848: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1849: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1850: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1851: BEGIN

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

1844: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1845: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1846:
1847: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1848: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1849: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1850: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1851: BEGIN
1852: IF (l_pLog) THEN

Line 1849: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1845: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
1846:
1847: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1848: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1849: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1850: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1851: BEGIN
1852: IF (l_pLog) THEN
1853: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

1846:
1847: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
1848: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1849: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1850: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1851: BEGIN
1852: IF (l_pLog) THEN
1853: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1854: l_module || '.begin',

Line 1853: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1849: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1850: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1851: BEGIN
1852: IF (l_pLog) THEN
1853: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1854: l_module || '.begin',
1855: '>>> ' || l_api_name);
1856: END IF;
1857:

Line 1954: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1950: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1951: p_data => x_msg_data);
1952:
1953: IF (l_pLog) THEN
1954: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1955: l_module || '.end',
1956: '<<< ' || l_api_name);
1957: END IF;
1958: EXCEPTION

Line 1967: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

1963:
1964: WHEN OTHERS THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1966: IF (l_uLog) THEN
1967: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1968: l_module || '.' || l_stmt_num,
1969: SUBSTRB (SQLERRM , 1 , 240));
1970: END IF;
1971:

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

2000:
2001: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2002: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2003:
2004: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2005: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2006: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2007: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2008: BEGIN

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

2001: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2002: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2003:
2004: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2005: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2006: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2007: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2008: BEGIN
2009: IF (l_pLog) THEN

Line 2006: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2002: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2003:
2004: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2005: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2006: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2007: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2008: BEGIN
2009: IF (l_pLog) THEN
2010: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

2003:
2004: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2005: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2006: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2007: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2008: BEGIN
2009: IF (l_pLog) THEN
2010: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2011: l_module || '.begin',

Line 2010: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2006: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2007: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2008: BEGIN
2009: IF (l_pLog) THEN
2010: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2011: l_module || '.begin',
2012: '>>> ' || l_api_name);
2013: END IF;
2014:

Line 2192: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2188: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2189: p_data => x_msg_data);
2190:
2191: IF (l_pLog) THEN
2192: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2193: l_module || '.end',
2194: '<<< ' || l_api_name);
2195: END IF;
2196: EXCEPTION

Line 2204: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

2200: p_data => x_msg_data);
2201: WHEN OTHERS THEN
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2203: IF (l_uLog) THEN
2204: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2205: l_module || '.' || l_stmt_num,
2206: SUBSTRB (SQLERRM , 1 , 240));
2207: END IF;
2208:

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

2236:
2237: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2238: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2239:
2240: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2241: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2242: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2243: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2244: BEGIN

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

2237: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2238: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2239:
2240: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2241: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2242: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2243: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2244: BEGIN
2245: IF (l_pLog) THEN

Line 2242: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2238: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2239:
2240: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2241: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2242: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2243: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2244: BEGIN
2245: IF (l_pLog) THEN
2246: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

2239:
2240: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2241: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2242: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2243: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2244: BEGIN
2245: IF (l_pLog) THEN
2246: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2247: l_module || '.begin',

Line 2246: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2242: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2243: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2244: BEGIN
2245: IF (l_pLog) THEN
2246: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2247: l_module || '.begin',
2248: '>>> ' || l_api_name);
2249: END IF;
2250:

Line 2385: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2381: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2382: p_data => x_msg_data);
2383:
2384: IF (l_pLog) THEN
2385: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2386: l_module || '.end',
2387: '<<< ' || l_api_name);
2388: END IF;
2389: EXCEPTION

Line 2397: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

2393: p_data => x_msg_data);
2394: WHEN OTHERS THEN
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2396: IF (l_uLog) THEN
2397: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2398: l_module || '.' || l_stmt_num,
2399: SUBSTRB (SQLERRM , 1 , 240));
2400: END IF;
2401:

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

2429:
2430: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2431: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2432:
2433: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2434: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2435: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2436: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2437: BEGIN

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

2430: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
2431: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2432:
2433: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2434: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2435: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2436: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2437: BEGIN
2438: IF (l_pLog) THEN

Line 2435: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2431: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.' || l_full_name;
2432:
2433: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2434: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2435: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2436: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2437: BEGIN
2438: IF (l_pLog) THEN
2439: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

2432:
2433: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);
2434: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2435: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2436: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2437: BEGIN
2438: IF (l_pLog) THEN
2439: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2440: l_module || '.begin',

Line 2439: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2435: l_eventLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2436: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2437: BEGIN
2438: IF (l_pLog) THEN
2439: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2440: l_module || '.begin',
2441: '>>> ' || l_api_name);
2442: END IF;
2443:

Line 2526: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

2522: -- Standard call to get message count and if count is 1, get message info.
2523: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2524: p_data => x_msg_data);
2525: IF (l_pLog) THEN
2526: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
2527: l_module || '.end',
2528: '<<< ' || l_api_name);
2529: END IF;
2530: EXCEPTION

Line 2538: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,

2534: p_data => x_msg_data);
2535: WHEN OTHERS THEN
2536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2537: IF (l_uLog) THEN
2538: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2539: l_module || '.' || l_stmt_num,
2540: SUBSTRB (SQLERRM , 1 , 240));
2541: END IF;
2542: