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

Line 4: /* FND Logging Constants */

1: PACKAGE BODY CST_XLA_PVT AS
2: /* $Header: CSTVXLAB.pls 120.43.12010000.4 2008/11/04 18:28:07 hyu ship $ */
3:
4: /* FND Logging Constants */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_XLA_PVT';
6: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
8: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

4: /* FND Logging Constants */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_XLA_PVT';
6: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
8: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9:
10: /* Global Constants */
11: G_CST_APPLICATION_ID CONSTANT NUMBER := 707;
12: G_INV_APPLICATION_ID CONSTANT NUMBER := 401;

Line 36: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

32: PROCEDURE debug
33: ( line IN VARCHAR2,
34: msg_prefix IN VARCHAR2 DEFAULT 'CST',
35: msg_module IN VARCHAR2 DEFAULT 'CST_XLA_PVT',
36: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
37: IS
38: l_msg_prefix VARCHAR2(64);
39: l_msg_level NUMBER;
40: l_msg_module VARCHAR2(256);

Line 52: l_msg_level := FND_LOG.LEVEL_EXCEPTION;

48: l_msg_level := msg_level;
49: l_msg_module := msg_module;
50:
51: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
52: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
53: END IF;
54:
55: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
56: RETURN;

Line 55: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN

51: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
52: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
53: END IF;
54:
55: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
56: RETURN;
57: END IF;
58:
59: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 59: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

55: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
56: RETURN;
57: END IF;
58:
59: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
60: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
61: END IF;
62:
63: EXCEPTION

Line 60: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));

56: RETURN;
57: END IF;
58:
59: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
60: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
61: END IF;
62:
63: EXCEPTION
64: WHEN OTHERS THEN RAISE;

Line 207: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

203: PROCEDURE dump_trx_info
204: (p_trx_info IN t_xla_inv_trx_info,
205: msg_prefix IN VARCHAR2 DEFAULT 'CST',
206: msg_module IN VARCHAR2 DEFAULT 'CST_XLA_PVT',
207: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
208: IS
209: BEGIN
210: debug( 'dump_trx_info +' ,msg_prefix,msg_module,msg_level);
211: debug( ' p_trx_info.transaction_date :'||p_trx_info.transaction_date ,msg_prefix,msg_module,msg_level);

Line 304: /* FND Logging */

300: l_errbuf VARCHAR2(1000);
301: l_retcode NUMBER;
302: l_request_id NUMBER;
303:
304: /* FND Logging */
305: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
306: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

302: l_request_id NUMBER;
303:
304: /* FND Logging */
305: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
306: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
309: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
310: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

303:
304: /* FND Logging */
305: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
306: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
309: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
310: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
311:

Line 308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

304: /* FND Logging */
305: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
306: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
309: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
310: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
311:
312: BEGIN

Line 309: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

305: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
306: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
309: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
310: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
311:
312: BEGIN
313: SAVEPOINT Create_RCVXLAEvent;

Line 310: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

306: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
307: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
308: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
309: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
310: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
311:
312: BEGIN
313: SAVEPOINT Create_RCVXLAEvent;
314: l_stmt_num := 0;

Line 317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'

313: SAVEPOINT Create_RCVXLAEvent;
314: l_stmt_num := 0;
315:
316: IF l_procLog THEN
317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
318: ,'Create_RCVXLAEvent <<');
319: END IF;
320: IF l_stmtLog THEN
321: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

Line 321: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

317: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
318: ,'Create_RCVXLAEvent <<');
319: END IF;
320: IF l_stmtLog THEN
321: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
322: 'Transaction: '||p_trx_info.TRANSACTION_ID||
323: ': Accounting Event: '||p_trx_info.ACCT_EVENT_ID );
324: END IF;
325:

Line 356: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');

352: l_pjm_blueprint := 'N';
353: END;
354: IF ( l_pjm_blueprint = 'Y' ) THEN
355: IF l_procLog THEN
356: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
357: END IF;
358: return;
359: END IF;
360: */

Line 414: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Type Code: '||l_event_type_code );

410: WHERE TRANSACTION_TYPE_ID = p_trx_info.ACCT_EVENT_TYPE_ID
411: AND ATTRIBUTE is NULL;
412: END IF;
413: IF l_stmtLog THEN
414: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Type Code: '||l_event_type_code );
415: END IF;
416: -- SLA API to generate the event
417: l_stmt_num := 40;
418:

Line 432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id );

428: p_security_context => l_security_data
429: );
430:
431: IF l_stmtLog THEN
432: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id );
433: END IF;
434:
435: IF l_event_id is NULL THEN
436: IF l_unexpLog THEN

Line 437: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Event creation failed for: Transaction ID: '||

433: END IF;
434:
435: IF l_event_id is NULL THEN
436: IF l_unexpLog THEN
437: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Event creation failed for: Transaction ID: '||
438: to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
439: END IF;
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;

Line 575: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Encumbrance Event ID: '||l_bc_event_id );

571: p_budgetary_control_flag => 'Y'
572: );
573:
574: IF l_stmtLog THEN
575: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Encumbrance Event ID: '||l_bc_event_id );
576: END IF;
577:
578: IF l_bc_event_id is NULL THEN
579: IF l_unexpLog THEN

Line 580: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||

576: END IF;
577:
578: IF l_bc_event_id is NULL THEN
579: IF l_unexpLog THEN
580: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
581: to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
582: END IF;
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;

Line 625: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);

621: l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
622: l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
623: IF G_DEBUG = 'Y' THEN
624: IF l_unexpLog THEN
625: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
626: END IF;
627: END IF;
628: RAISE FND_API.g_exc_unexpected_error;
629: END IF;

Line 635: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Journal Lines could not be created for the Encumbrance Event. Please inform your Administrator. BC Status Code: '||l_bc_status);

631: IF ( l_bc_status = 'XLA_NO_JOURNAL') THEN
632: l_api_message := 'Journal Lines could not be created for the Encumbrance Event. Please inform your Administrator';
633: IF G_DEBUG = 'Y' THEN
634: IF l_unexpLog THEN
635: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Journal Lines could not be created for the Encumbrance Event. Please inform your Administrator. BC Status Code: '||l_bc_status);
636: END IF;
637: END IF;
638: END IF;
639:

Line 643: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Transaction ID: '|| to_char(p_trx_info.TRANSACTION_ID)||': Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));

639:
640: END IF; /* Encumbrance Reversal */
641:
642: IF l_procLog THEN
643: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Transaction ID: '|| to_char(p_trx_info.TRANSACTION_ID)||': Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));
645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
646: END IF;
647:

Line 644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));

640: END IF; /* Encumbrance Reversal */
641:
642: IF l_procLog THEN
643: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Transaction ID: '|| to_char(p_trx_info.TRANSACTION_ID)||': Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));
645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
646: END IF;
647:
648: EXCEPTION

Line 645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');

641:
642: IF l_procLog THEN
643: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Transaction ID: '|| to_char(p_trx_info.TRANSACTION_ID)||': Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
644: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));
645: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
646: END IF;
647:
648: EXCEPTION
649: WHEN FND_API.g_exc_error THEN

Line 682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num

678: x_return_status := fnd_api.g_ret_sts_unexp_error ;
679: x_msg_data := SQLERRM;
680:
681: IF l_unexpLog THEN
682: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num
683: ,'Create_RCVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
684: END IF;
685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.add_exc_msg

Line 762: /* FND Logging */

758: l_user_id NUMBER;
759: l_resp_id NUMBER;
760: l_resp_appl_id NUMBER;
761:
762: /* FND Logging */
763: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
764: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

760: l_resp_appl_id NUMBER;
761:
762: /* FND Logging */
763: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
764: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
767: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
768: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

761:
762: /* FND Logging */
763: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
764: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
767: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
768: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
769:

Line 766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

762: /* FND Logging */
763: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
764: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
767: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
768: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
769:
770: --BUG#6125007

Line 767: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

763: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
764: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
767: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
768: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
769:
770: --BUG#6125007
771: l_psa_ins_flag VARCHAR2(1) := 'N';

Line 768: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

764: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
765: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
766: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
767: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
768: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
769:
770: --BUG#6125007
771: l_psa_ins_flag VARCHAR2(1) := 'N';
772:

Line 782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin','Create_INVXLAEvent <<');

778: BEGIN
779: SAVEPOINT Create_INVXLAEvent;
780: l_stmt_num := 0;
781: IF l_procLog THEN
782: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin','Create_INVXLAEvent <<');
783: END IF;
784:
785: --Display the content of p_trx_info
786: dump_trx_info(p_trx_info => p_trx_info,

Line 789: msg_level => FND_LOG.LEVEL_STATEMENT);

785: --Display the content of p_trx_info
786: dump_trx_info(p_trx_info => p_trx_info,
787: msg_prefix => 'CST',
788: msg_module => 'Create_INVXLAEvent',
789: msg_level => FND_LOG.LEVEL_STATEMENT);
790:
791: -- Standard call to check for call compatibility
792: IF NOT FND_API.Compatible_API_Call (
793: l_api_version,

Line 859: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');

855: END;
856:
857: IF ( l_mta_exists = 0 OR l_pjm_blueprint = 'Y' ) THEN
858: IF l_procLog THEN
859: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
860: END IF;
861: return;
862: END IF;
863:

Line 1204: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction:

1200: p_valuation_method => NULL,
1201: p_security_context => l_security_data
1202: );
1203: IF l_stmtLog THEN
1204: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction:
1205: '||p_trx_info.TRANSACTION_ID||' : Source Type ID:
1206: '||p_trx_info.TXN_SRC_TYPE_ID||' : Event Type:
1207: '||l_events(l_index).event_type_code||' :Event ID: '||l_event_id);
1208: END IF;

Line 1254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'MMT PSA event event_type_code: '||l_events(l_index).event_type_code );

1250: l_psa_ins_flag := 'Y';
1251: END IF;
1252:
1253: IF l_stmtLog THEN
1254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'MMT PSA event event_type_code: '||l_events(l_index).event_type_code );
1255: END IF;
1256:
1257:
1258: /* Create the encumbrance event for this transaction */

Line 1272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Encumbrance Event ID: '||l_bc_event_id );

1268: p_security_context => l_security_data,
1269: p_budgetary_control_flag => 'Y'
1270: );
1271: IF l_stmtLog THEN
1272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Encumbrance Event ID: '||l_bc_event_id );
1273: END IF;
1274:
1275: IF l_bc_event_id is NULL THEN
1276: IF l_unexpLog THEN

Line 1277: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||

1273: END IF;
1274:
1275: IF l_bc_event_id is NULL THEN
1276: IF l_unexpLog THEN
1277: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
1278: to_char(p_trx_info.TRANSACTION_ID));
1279: END IF;
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END IF;

Line 1326: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);

1322: l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1323: l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
1324: IF G_DEBUG = 'Y' THEN
1325: IF l_unexpLog THEN
1326: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
1327: END IF;
1328: END IF;
1329: RAISE FND_API.g_exc_unexpected_error;
1330: END IF;

Line 1335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');

1331:
1332: END IF; /* ENCUMBRANCE_FLAG = 'Y' */
1333:
1334: IF l_procLog THEN
1335: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
1336: END IF;
1337: EXCEPTION
1338: WHEN FND_API.g_exc_error THEN
1339: ROLLBACK TO Create_INVXLAEvent;

Line 1356: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));

1352: WHEN OTHERS THEN
1353: ROLLBACK TO Create_INVXLAEvent;
1354: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1355: IF l_unexpLog THEN
1356: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1357: END IF;
1358:
1359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1360: FND_MSG_PUB.add_exc_msg

Line 1423: /* FND Logging */

1419:
1420: l_event_id NUMBER;
1421: l_event_type_code VARCHAR2(30);
1422:
1423: /* FND Logging */
1424: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1425: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

1421: l_event_type_code VARCHAR2(30);
1422:
1423: /* FND Logging */
1424: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1425: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1428: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1429: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1422:
1423: /* FND Logging */
1424: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1425: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1428: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1429: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1430:

Line 1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1423: /* FND Logging */
1424: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1425: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1428: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1429: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1430:
1431:

Line 1428: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1424: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1425: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1428: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1429: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1430:
1431:
1432: BEGIN

Line 1429: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1425: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1426: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1427: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1428: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1429: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1430:
1431:
1432: BEGIN
1433: SAVEPOINT Create_WIPXLAEvent;

Line 1437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'

1433: SAVEPOINT Create_WIPXLAEvent;
1434: l_stmt_num := 0;
1435:
1436: IF l_procLog THEN
1437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
1438: ,' Create_WIPXLAEvent <<');
1439: END IF;
1440: IF l_stmtLog THEN
1441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

Line 1441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

1437: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
1438: ,' Create_WIPXLAEvent <<');
1439: END IF;
1440: IF l_stmtLog THEN
1441: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1442: ': Transaction ID: '|| p_trx_info.TRANSACTION_ID||
1443: ': Transaction Type: '|| p_trx_info.TXN_TYPE_ID||
1444: ': Resource ID: '|| p_trx_info.WIP_RESOURCE_ID ||
1445: ': Basis Type: '||p_trx_info.WIP_BASIS_TYPE_ID ||

Line 1479: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');

1475: END;
1476:
1477: IF ( l_pjm_blueprint = 'Y' ) THEN
1478: IF l_procLog THEN
1479: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1480: END IF;
1481: return;
1482: END IF;
1483:

Line 1535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Type: '||l_event_type_code);

1531: WHERE TRANSACTION_TYPE_ID = p_trx_info.TXN_TYPE_ID
1532: AND ATTRIBUTE IS NULL;
1533: END IF;
1534: IF l_stmtLog THEN
1535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Type: '||l_event_type_code);
1536: END IF;
1537: -- SLA API to generate the event
1538: l_stmt_num := 40;
1539:

Line 1553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id);

1549: p_security_context => l_security_data
1550: );
1551:
1552: IF l_stmtLog THEN
1553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id);
1554: END IF;
1555: IF l_event_id is NULL THEN
1556: IF l_unexpLog THEN
1557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Event creation failed for: Transaction ID: '||to_char(p_trx_info.TRANSACTION_ID)||': Organization ID: '||to_char(p_trx_info.INV_ORGANIZATION_ID));

Line 1557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Event creation failed for: Transaction ID: '||to_char(p_trx_info.TRANSACTION_ID)||': Organization ID: '||to_char(p_trx_info.INV_ORGANIZATION_ID));

1553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id);
1554: END IF;
1555: IF l_event_id is NULL THEN
1556: IF l_unexpLog THEN
1557: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Event creation failed for: Transaction ID: '||to_char(p_trx_info.TRANSACTION_ID)||': Organization ID: '||to_char(p_trx_info.INV_ORGANIZATION_ID));
1558: END IF;
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;
1561: IF l_procLog THEN

Line 1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');

1558: END IF;
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;
1561: IF l_procLog THEN
1562: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1563: END IF;
1564:
1565: EXCEPTION
1566: WHEN FND_API.g_exc_error THEN

Line 1584: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num

1580: WHEN OTHERS THEN
1581: ROLLBACK TO Create_WIPXLAEvent;
1582: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1583: IF l_unexpLog THEN
1584: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
1585: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1586: END IF;
1587:
1588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1654: /* FND Logging */

1650: l_index NUMBER;
1651: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1652:
1653:
1654: /* FND Logging */
1655: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1656: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

1652:
1653:
1654: /* FND Logging */
1655: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1656: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1659: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1660: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1653:
1654: /* FND Logging */
1655: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1656: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1659: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1660: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1661:

Line 1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1654: /* FND Logging */
1655: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1656: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1659: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1660: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1661:
1662:

Line 1659: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1655: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1656: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1659: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1660: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1661:
1662:
1663: BEGIN

Line 1660: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1656: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1657: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1658: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1659: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1660: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1661:
1662:
1663: BEGIN
1664:

Line 1669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' CreateBulk_WIPXLAEvent <<');

1665: SAVEPOINT CreateBulk_WIPXLAEvent;
1666: l_stmt_num := 0;
1667:
1668: IF l_procLog THEN
1669: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' CreateBulk_WIPXLAEvent <<');
1670: END IF;
1671:
1672: -- Standard call to check for call compatibility
1673: IF NOT FND_API.Compatible_API_Call (

Line 1702: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','CreateBulk_WIPXLAEvent >>');

1698: END;
1699:
1700: IF ( l_pjm_blueprint = 'Y' ) THEN
1701: IF l_procLog THEN
1702: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','CreateBulk_WIPXLAEvent >>');
1703: END IF;
1704: return;
1705: END IF;
1706:

Line 1807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end','CreateBulk_WIPXLAEvent >>');

1803: p_entity_type_code => 'WIP_ACCOUNTING_EVENTS');
1804:
1805:
1806: IF l_procLog THEN
1807: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end','CreateBulk_WIPXLAEvent >>');
1808: END IF;
1809:
1810: EXCEPTION
1811: WHEN FND_API.g_exc_error THEN

Line 1829: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));

1825: WHEN OTHERS THEN
1826: ROLLBACK TO CreateBulk_WIPXLAEvent;
1827: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1828: IF l_unexpLog THEN
1829: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1830: END IF;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1833: FND_MSG_PUB.add_exc_msg

Line 1898: /* FND Logging */

1894: l_index NUMBER;
1895: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1896:
1897:
1898: /* FND Logging */
1899: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1900: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

1896:
1897:
1898: /* FND Logging */
1899: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1900: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1903: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1904: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1897:
1898: /* FND Logging */
1899: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1900: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1903: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1904: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1905:

Line 1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

1898: /* FND Logging */
1899: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1900: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1903: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1904: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1905:
1906: BEGIN

Line 1903: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1899: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1900: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1903: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1904: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1905:
1906: BEGIN
1907:

Line 1904: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1900: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1901: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1902: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1903: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1904: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1905:
1906: BEGIN
1907:
1908: SAVEPOINT Create_CostUpdateXLAEvent;

Line 1912: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_CostUpdateXLAEvent <<');

1908: SAVEPOINT Create_CostUpdateXLAEvent;
1909: l_stmt_num := 0;
1910:
1911: IF l_procLog THEN
1912: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_CostUpdateXLAEvent <<');
1913: END IF;
1914:
1915: -- Standard call to check for call compatibility
1916: IF NOT FND_API.Compatible_API_Call (

Line 1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');

1941: END;
1942:
1943: IF ( l_pjm_blueprint = 'Y' ) THEN
1944: IF l_procLog THEN
1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');
1946: END IF;
1947: return;
1948: END IF;
1949: -- Get Ledger

Line 2032: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');

2028: p_entity_type_code => 'MTL_ACCOUNTING_EVENTS');
2029:
2030:
2031: IF l_procLog THEN
2032: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');
2033: END IF;
2034:
2035: EXCEPTION
2036: WHEN FND_API.g_exc_error THEN

Line 2054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));

2050: WHEN OTHERS THEN
2051: ROLLBACK TO Create_CostUpdateXLAEvent;
2052: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2053: IF l_unexpLog THEN
2054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2055: END IF;
2056:
2057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2058: FND_MSG_PUB.add_exc_msg

Line 2122: /* FND Logging */

2118: l_index NUMBER;
2119:
2120: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2121:
2122: /* FND Logging */
2123: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

2120: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2121:
2122: /* FND Logging */
2123: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2127: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2128: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2121:
2122: /* FND Logging */
2123: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2127: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2128: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2129:

Line 2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

2122: /* FND Logging */
2123: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2127: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2128: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2129:
2130: BEGIN

Line 2127: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2123: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2127: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2128: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2129:
2130: BEGIN
2131:

Line 2128: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2124: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2125: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2126: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2127: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2128: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2129:
2130: BEGIN
2131:
2132: SAVEPOINT Create_WIPUpdateXLAEvent;

Line 2136: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_WIPUpdateXLAEvent <<');

2132: SAVEPOINT Create_WIPUpdateXLAEvent;
2133: l_stmt_num := 0;
2134:
2135: IF l_procLog THEN
2136: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_WIPUpdateXLAEvent <<');
2137: END IF;
2138:
2139: -- Standard call to check for call compatibility
2140: IF NOT FND_API.Compatible_API_Call (

Line 2169: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');

2165: END;
2166:
2167: IF ( l_pjm_blueprint = 'Y' ) THEN
2168: IF l_procLog THEN
2169: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');
2170: END IF;
2171: return;
2172: END IF;
2173: -- Get Ledger

Line 2239: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');

2235: p_entity_type_code => 'WIP_ACCOUNTING_EVENTS');
2236:
2237:
2238: IF l_procLog THEN
2239: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');
2240: END IF;
2241:
2242: EXCEPTION
2243: WHEN FND_API.g_exc_error THEN

Line 2261: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num

2257: WHEN OTHERS THEN
2258: ROLLBACK TO Create_WIPUpdateXLAEvent;
2259: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2260: IF l_unexpLog THEN
2261: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
2262: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2263: END IF;
2264:
2265: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN