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.60 2010/06/15 09:05:44 mpuranik 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 99: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

95: PROCEDURE debug
96: ( line IN VARCHAR2,
97: msg_prefix IN VARCHAR2 DEFAULT 'CST',
98: msg_module IN VARCHAR2 DEFAULT 'CST_XLA_PVT',
99: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
100: IS
101: l_msg_prefix VARCHAR2(64);
102: l_msg_level NUMBER;
103: l_msg_module VARCHAR2(256);

Line 115: l_msg_level := FND_LOG.LEVEL_EXCEPTION;

111: l_msg_level := msg_level;
112: l_msg_module := msg_module;
113:
114: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
115: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
116: END IF;
117:
118: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
119: RETURN;

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

114: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
115: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
116: END IF;
117:
118: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
119: RETURN;
120: END IF;
121:
122: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

118: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND PG_DEBUG = 'N' THEN
119: RETURN;
120: END IF;
121:
122: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
123: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
124: END IF;
125:
126: EXCEPTION

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

119: RETURN;
120: END IF;
121:
122: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
123: FND_LOG.STRING(l_msg_level, l_msg_module, SUBSTRB(l_line,1,4000));
124: END IF;
125:
126: EXCEPTION
127: WHEN OTHERS THEN RAISE;

Line 270: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

266: PROCEDURE dump_trx_info
267: (p_trx_info IN t_xla_inv_trx_info,
268: msg_prefix IN VARCHAR2 DEFAULT 'CST',
269: msg_module IN VARCHAR2 DEFAULT 'CST_XLA_PVT',
270: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
271: IS
272: BEGIN
273: debug( 'dump_trx_info +' ,msg_prefix,msg_module,msg_level);
274: debug( ' p_trx_info.transaction_date :'||p_trx_info.transaction_date ,msg_prefix,msg_module,msg_level);

Line 395: /* FND Logging */

391: l_errbuf VARCHAR2(1000);
392: l_retcode NUMBER;
393: l_request_id NUMBER;
394:
395: /* FND Logging */
396: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
397: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
398: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
399: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

393: l_request_id NUMBER;
394:
395: /* FND Logging */
396: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
397: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
398: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
399: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
400: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
401: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

394:
395: /* FND Logging */
396: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
397: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
398: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
399: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
400: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
401: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
402:

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

395: /* FND Logging */
396: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
397: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
398: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
399: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
400: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
401: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
402:
403: BEGIN

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

396: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
397: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
398: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
399: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
400: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
401: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
402:
403: BEGIN
404: SAVEPOINT Create_RCVXLAEvent;

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

397: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
398: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
399: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
400: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
401: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
402:
403: BEGIN
404: SAVEPOINT Create_RCVXLAEvent;
405: l_stmt_num := 0;

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

404: SAVEPOINT Create_RCVXLAEvent;
405: l_stmt_num := 0;
406:
407: IF l_procLog THEN
408: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
409: ,'Create_RCVXLAEvent <<');
410: END IF;
411: IF l_stmtLog THEN
412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

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

408: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
409: ,'Create_RCVXLAEvent <<');
410: END IF;
411: IF l_stmtLog THEN
412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
413: 'Transaction: '||p_trx_info.TRANSACTION_ID||
414: ': Accounting Event: '||p_trx_info.ACCT_EVENT_ID );
415: END IF;
416:

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

443: l_pjm_blueprint := 'N';
444: END;
445: IF ( l_pjm_blueprint = 'Y' ) THEN
446: IF l_procLog THEN
447: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
448: END IF;
449: return;
450: END IF;
451: */

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

501: WHERE TRANSACTION_TYPE_ID = p_trx_info.ACCT_EVENT_TYPE_ID
502: AND ATTRIBUTE is NULL;
503: END IF;
504: IF l_stmtLog THEN
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Type Code: '||l_event_type_code );
506: END IF;
507: -- SLA API to generate the event
508: l_stmt_num := 40;
509:

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

521: p_security_context => l_security_data
522: );
523:
524: IF l_stmtLog THEN
525: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id );
526: END IF;
527:
528: IF l_event_id is NULL THEN
529: IF l_unexpLog THEN

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

526: END IF;
527:
528: IF l_event_id is NULL THEN
529: IF l_unexpLog THEN
530: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Event creation failed for: Transaction ID: '||
531: to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
532: END IF;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;

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

694: -- p_budgetary_control_flag => 'Y'
695: -- );
696:
697: -- IF l_stmtLog THEN
698: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Encumbrance Event ID: '||l_bc_event_id );
699: -- END IF;
700:
701: -- IF l_bc_event_id is NULL THEN
702: -- IF l_unexpLog THEN

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

699: -- END IF;
700:
701: -- IF l_bc_event_id is NULL THEN
702: -- IF l_unexpLog THEN
703: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
704: -- to_char(p_trx_info.TRANSACTION_ID)||'Accounting Event ID: '||to_char(p_trx_info.ACCT_EVENT_ID));
705: -- END IF;
706: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: -- END IF;

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

744: -- l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
745: -- l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
746: -- IF G_DEBUG = 'Y' THEN
747: -- IF l_unexpLog THEN
748: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
749: -- END IF;
750: -- END IF;
751: -- RAISE FND_API.g_exc_unexpected_error;
752: -- END IF;

Line 758: -- 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);

754: -- IF ( l_bc_status = 'XLA_NO_JOURNAL') THEN
755: -- l_api_message := 'Journal Lines could not be created for the Encumbrance Event. Please inform your Administrator';
756: -- IF G_DEBUG = 'Y' THEN
757: -- IF l_unexpLog THEN
758: -- 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);
759: -- END IF;
760: -- END IF;
761: -- END IF;
762:

Line 773: 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));

769: Referred doc MED_PSA_CST_XLA_GL.doc
770: */
771:
772: IF l_procLog THEN
773: 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));
774: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));
775: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
776: END IF;
777:

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

770: */
771:
772: IF l_procLog THEN
773: 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));
774: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));
775: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
776: END IF;
777:
778: EXCEPTION

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

771:
772: IF l_procLog THEN
773: 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));
774: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module, ': Event Id: '||to_char(l_event_id));
775: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_RCVXLAEvent >>');
776: END IF;
777:
778: EXCEPTION
779: WHEN FND_API.g_exc_error THEN

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

808: x_return_status := fnd_api.g_ret_sts_unexp_error ;
809: x_msg_data := SQLERRM;
810:
811: IF l_unexpLog THEN
812: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||' '||l_stmt_num
813: ,'Create_RCVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
814: END IF;
815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg

Line 892: /* FND Logging */

888: l_user_id NUMBER;
889: l_resp_id NUMBER;
890: l_resp_appl_id NUMBER;
891:
892: /* FND Logging */
893: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
894: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
895: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
896: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

890: l_resp_appl_id NUMBER;
891:
892: /* FND Logging */
893: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
894: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
895: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
896: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
897: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
898: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

891:
892: /* FND Logging */
893: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
894: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
895: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
896: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
897: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
898: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
899:

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

892: /* FND Logging */
893: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
894: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
895: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
896: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
897: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
898: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
899:
900: --BUG#6125007

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

893: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
894: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
895: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
896: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
897: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
898: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
899:
900: --BUG#6125007
901: l_psa_ins_flag VARCHAR2(1) := 'N';

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

894: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
895: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
896: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
897: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
898: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
899:
900: --BUG#6125007
901: l_psa_ins_flag VARCHAR2(1) := 'N';
902:

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

910: BEGIN
911: SAVEPOINT Create_INVXLAEvent;
912: l_stmt_num := 0;
913: IF l_procLog THEN
914: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin','Create_INVXLAEvent <<');
915: END IF;
916:
917: --Display the content of p_trx_info
918: dump_trx_info(p_trx_info => p_trx_info,

Line 921: msg_level => FND_LOG.LEVEL_STATEMENT);

917: --Display the content of p_trx_info
918: dump_trx_info(p_trx_info => p_trx_info,
919: msg_prefix => 'CST',
920: msg_module => 'Create_INVXLAEvent',
921: msg_level => FND_LOG.LEVEL_STATEMENT);
922:
923: -- Standard call to check for call compatibility
924: IF NOT FND_API.Compatible_API_Call (
925: l_api_version,

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

987: END;
988:
989: IF ( l_mta_exists = 0) THEN
990: IF l_procLog THEN
991: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
992: END IF;
993: return;
994: END IF;
995:

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

1000: package CST_PRJMFG_ACCT_HOOK where the custom code must be extended
1001: For more information visit 9145770
1002: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
1003: IF l_stmtLog THEN
1004: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1005: 'Calling the client extension CST_Blueprint_create_SLA'||
1006: ' for Inventory Transaction: '||p_trx_info.TRANSACTION_ID);
1007: END IF;
1008: l_post_option := NVL(CST_PRJMFG_ACCT_HOOK.blueprint_sla_hook(

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

1016: x_msg_data := l_msg_data;
1017: RAISE FND_API.g_exc_unexpected_error;
1018: ELSIF (l_post_option = 1) THEN
1019: IF l_stmtLog THEN
1020: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1021: 'Hook was used, events will be created for Inventory Transaction: '||
1022: p_trx_info.TRANSACTION_ID );
1023: END IF;
1024: ELSE

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

1022: p_trx_info.TRANSACTION_ID );
1023: END IF;
1024: ELSE
1025: IF l_stmtLog THEN
1026: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1027: 'Hook was not used, events will not be created for Inventory Transaction: '||
1028: p_trx_info.TRANSACTION_ID );
1029: END IF;
1030: IF l_procLog THEN

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

1027: 'Hook was not used, events will not be created for Inventory Transaction: '||
1028: p_trx_info.TRANSACTION_ID );
1029: END IF;
1030: IF l_procLog THEN
1031: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
1032: END IF;
1033: return;
1034: END IF;
1035: END IF;

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

1374: p_valuation_method => NULL,
1375: p_security_context => l_security_data
1376: );
1377: IF l_stmtLog THEN
1378: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction:
1379: '||p_trx_info.TRANSACTION_ID||' : Source Type ID:
1380: '||p_trx_info.TXN_SRC_TYPE_ID||' : Event Type:
1381: '||l_events(l_index).event_type_code||' :Event ID: '||l_event_id);
1382: END IF;

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

1428: -- l_psa_ins_flag := 'Y';
1429: -- END IF;
1430:
1431: -- IF l_stmtLog THEN
1432: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'MMT PSA event event_type_code: '||l_events(l_index).event_type_code );
1433: -- END IF;
1434:
1435:
1436: -- /* Create the encumbrance event for this transaction */

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

1448: -- p_security_context => l_security_data,
1449: -- p_budgetary_control_flag => 'Y'
1450: -- );
1451: -- IF l_stmtLog THEN
1452: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Encumbrance Event ID: '||l_bc_event_id );
1453: -- END IF;
1454:
1455: -- IF l_bc_event_id is NULL THEN
1456: -- IF l_unexpLog THEN

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

1453: -- END IF;
1454:
1455: -- IF l_bc_event_id is NULL THEN
1456: -- IF l_unexpLog THEN
1457: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Encumbrance Event creation failed for: Transaction ID: '||
1458: -- to_char(p_trx_info.TRANSACTION_ID));
1459: -- END IF;
1460: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: -- END IF;

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

1508: -- l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1509: -- l_api_message := 'Error in Encumbrance Accounting/Budgetory Control';
1510: -- IF G_DEBUG = 'Y' THEN
1511: -- IF l_unexpLog THEN
1512: -- FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module,'Budgetary Control Failed for Event with BC Status Code: '||l_bc_status);
1513: -- END IF;
1514: -- END IF;
1515: -- RAISE FND_API.g_exc_unexpected_error;
1516: -- END IF;

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

1519:
1520: /*Commented for single event -Inventory ends }*/
1521:
1522: IF l_procLog THEN
1523: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_INVXLAEvent >>');
1524: END IF;
1525: EXCEPTION
1526: WHEN FND_API.g_exc_error THEN
1527: ROLLBACK TO Create_INVXLAEvent;

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

1540: WHEN OTHERS THEN
1541: ROLLBACK TO Create_INVXLAEvent;
1542: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1543: IF l_unexpLog THEN
1544: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_INVXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1545: END IF;
1546:
1547: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1548: FND_MSG_PUB.add_exc_msg

Line 1614: /* FND Logging */

1610:
1611: --Blue Print client extension
1612: l_post_option NUMBER;
1613:
1614: /* FND Logging */
1615: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1616: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1617: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1618: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

1612: l_post_option NUMBER;
1613:
1614: /* FND Logging */
1615: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1616: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1617: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1618: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1619: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1620: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

1613:
1614: /* FND Logging */
1615: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1616: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1617: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1618: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1619: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1620: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1621:

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

1614: /* FND Logging */
1615: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1616: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1617: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1618: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1619: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1620: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1621:
1622:

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

1615: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1616: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1617: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1618: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1619: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1620: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1621:
1622:
1623: BEGIN

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

1616: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1617: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1618: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1619: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1620: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1621:
1622:
1623: BEGIN
1624: SAVEPOINT Create_WIPXLAEvent;

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

1624: SAVEPOINT Create_WIPXLAEvent;
1625: l_stmt_num := 0;
1626:
1627: IF l_procLog THEN
1628: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
1629: ,' Create_WIPXLAEvent <<');
1630: END IF;
1631: IF l_stmtLog THEN
1632: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

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

1628: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin'
1629: ,' Create_WIPXLAEvent <<');
1630: END IF;
1631: IF l_stmtLog THEN
1632: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1633: ': Transaction ID: '|| p_trx_info.TRANSACTION_ID||
1634: ': Transaction Type: '|| p_trx_info.TXN_TYPE_ID||
1635: ': Resource ID: '|| p_trx_info.WIP_RESOURCE_ID ||
1636: ': Basis Type: '||p_trx_info.WIP_BASIS_TYPE_ID ||

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

1672: package CST_PRJMFG_ACCT_HOOK where the custom code must be extended
1673: For more information visit 9145770
1674: +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
1675: IF l_stmtLog THEN
1676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1677: 'Calling the client extension CST_Blueprint_create_SLA'||
1678: ' for WCTI Transaction: '||p_trx_info.TRANSACTION_ID);
1679: END IF;
1680: l_post_option := NVL(CST_PRJMFG_ACCT_HOOK.blueprint_sla_hook(

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

1688: x_msg_data := l_msg_data;
1689: RAISE FND_API.g_exc_unexpected_error;
1690: ELSIF (l_post_option = 1) THEN
1691: IF l_stmtLog THEN
1692: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1693: 'Hook was used, events will be created for WCTI Transaction: '||
1694: p_trx_info.TRANSACTION_ID );
1695: END IF;
1696: ELSE

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

1694: p_trx_info.TRANSACTION_ID );
1695: END IF;
1696: ELSE
1697: IF l_stmtLog THEN
1698: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
1699: 'Hook was not used, events will not be created for WCTI Transaction: '||
1700: p_trx_info.TRANSACTION_ID );
1701: END IF;
1702: IF l_procLog THEN

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

1699: 'Hook was not used, events will not be created for WCTI Transaction: '||
1700: p_trx_info.TRANSACTION_ID );
1701: END IF;
1702: IF l_procLog THEN
1703: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1704: END IF;
1705: return;
1706: END IF;
1707: END IF;

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

1756: WHERE TRANSACTION_TYPE_ID = p_trx_info.TXN_TYPE_ID
1757: AND ATTRIBUTE IS NULL;
1758: END IF;
1759: IF l_stmtLog THEN
1760: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Type: '||l_event_type_code);
1761: END IF;
1762: -- SLA API to generate the event
1763: l_stmt_num := 40;
1764:

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

1776: p_security_context => l_security_data
1777: );
1778:
1779: IF l_stmtLog THEN
1780: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id);
1781: END IF;
1782: IF l_event_id is NULL THEN
1783: IF l_unexpLog THEN
1784: 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 1784: 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));

1780: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module, 'Event ID: '||l_event_id);
1781: END IF;
1782: IF l_event_id is NULL THEN
1783: IF l_unexpLog THEN
1784: 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));
1785: END IF;
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: IF l_procLog THEN

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

1785: END IF;
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: IF l_procLog THEN
1789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPXLAEvent >>');
1790: END IF;
1791:
1792: EXCEPTION
1793: WHEN FND_API.g_exc_error THEN

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

1807: WHEN OTHERS THEN
1808: ROLLBACK TO Create_WIPXLAEvent;
1809: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1810: IF l_unexpLog THEN
1811: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
1812: ,'Create_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
1813: END IF;
1814:
1815: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1881: /* FND Logging */

1877: l_index NUMBER;
1878: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
1879:
1880:
1881: /* FND Logging */
1882: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1883: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1884: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1885: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

1879:
1880:
1881: /* FND Logging */
1882: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1883: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1884: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1885: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1886: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1887: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

1880:
1881: /* FND Logging */
1882: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1883: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1884: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1885: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1886: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1887: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1888:

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

1881: /* FND Logging */
1882: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1883: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1884: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1885: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1886: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1887: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1888:
1889:

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

1882: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
1883: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1884: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1885: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1886: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1887: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1888:
1889:
1890: BEGIN

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

1883: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
1884: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1885: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1886: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1887: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1888:
1889:
1890: BEGIN
1891:

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

1892: SAVEPOINT CreateBulk_WIPXLAEvent;
1893: l_stmt_num := 0;
1894:
1895: IF l_procLog THEN
1896: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' CreateBulk_WIPXLAEvent <<');
1897: END IF;
1898:
1899: -- Standard call to check for call compatibility
1900: IF NOT FND_API.Compatible_API_Call (

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

1925: END;
1926: /* Modified to call the Blue Print hook
1927: IF ( l_pjm_blueprint = 'Y' ) THEN
1928: IF l_procLog THEN
1929: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','CreateBulk_WIPXLAEvent >>');
1930: END IF;
1931: return;
1932: END IF;
1933: */

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

2051: p_entity_type_code => 'WIP_ACCOUNTING_EVENTS');
2052:
2053:
2054: IF l_procLog THEN
2055: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.end','CreateBulk_WIPXLAEvent >>');
2056: END IF;
2057:
2058: EXCEPTION
2059: WHEN FND_API.g_exc_error THEN

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

2073: WHEN OTHERS THEN
2074: ROLLBACK TO CreateBulk_WIPXLAEvent;
2075: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2076: IF l_unexpLog THEN
2077: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'CreateBulk_WIPXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2078: END IF;
2079:
2080: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2081: FND_MSG_PUB.add_exc_msg

Line 2146: /* FND Logging */

2142: l_index NUMBER;
2143: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2144:
2145:
2146: /* FND Logging */
2147: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2148: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2149: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2150: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

2144:
2145:
2146: /* FND Logging */
2147: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2148: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2149: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2150: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2151: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2152: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

2145:
2146: /* FND Logging */
2147: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2148: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2149: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2150: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2151: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2152: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2153:

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

2146: /* FND Logging */
2147: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2148: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2149: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2150: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2151: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2152: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2153:
2154: BEGIN

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

2147: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2148: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2149: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2150: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2151: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2152: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2153:
2154: BEGIN
2155:

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

2148: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2149: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2150: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2151: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2152: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2153:
2154: BEGIN
2155:
2156: SAVEPOINT Create_CostUpdateXLAEvent;

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

2156: SAVEPOINT Create_CostUpdateXLAEvent;
2157: l_stmt_num := 0;
2158:
2159: IF l_procLog THEN
2160: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_CostUpdateXLAEvent <<');
2161: END IF;
2162:
2163: -- Standard call to check for call compatibility
2164: IF NOT FND_API.Compatible_API_Call (

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

2189: END;
2190: /* Modified to enable the call to the blue print hook
2191: IF ( l_pjm_blueprint = 'Y' ) THEN
2192: IF l_procLog THEN
2193: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');
2194: END IF;
2195: return;
2196: END IF;
2197: */

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

2283: p_entity_type_code => 'MTL_ACCOUNTING_EVENTS');
2284:
2285:
2286: IF l_procLog THEN
2287: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_CostUpdateXLAEvent >>');
2288: END IF;
2289:
2290: EXCEPTION
2291: WHEN FND_API.g_exc_error THEN

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

2305: WHEN OTHERS THEN
2306: ROLLBACK TO Create_CostUpdateXLAEvent;
2307: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2308: IF l_unexpLog THEN
2309: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num ,'Create_CostUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2310: END IF;
2311:
2312: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: FND_MSG_PUB.add_exc_msg

Line 2377: /* FND Logging */

2373: l_index NUMBER;
2374:
2375: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2376:
2377: /* FND Logging */
2378: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2380: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2381: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

2375: l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;
2376:
2377: /* FND Logging */
2378: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2380: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2381: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2382: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2383: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

2376:
2377: /* FND Logging */
2378: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2380: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2381: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2382: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2383: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2384:

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

2377: /* FND Logging */
2378: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2380: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2381: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2382: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2383: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2384:
2385: BEGIN

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

2378: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2380: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2381: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2382: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2383: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2384:
2385: BEGIN
2386:

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

2379: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
2380: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2381: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2382: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2383: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2384:
2385: BEGIN
2386:
2387: SAVEPOINT Create_WIPUpdateXLAEvent;

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

2387: SAVEPOINT Create_WIPUpdateXLAEvent;
2388: l_stmt_num := 0;
2389:
2390: IF l_procLog THEN
2391: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.begin' ,' Create_WIPUpdateXLAEvent <<');
2392: END IF;
2393:
2394: -- Standard call to check for call compatibility
2395: IF NOT FND_API.Compatible_API_Call (

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

2421:
2422: /* Modified to enable the call to the blue print hook
2423: IF ( l_pjm_blueprint = 'Y' ) THEN
2424: IF l_procLog THEN
2425: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');
2426: END IF;
2427: return;
2428: END IF;
2429: */

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

2499: p_entity_type_code => 'WIP_ACCOUNTING_EVENTS');
2500:
2501:
2502: IF l_procLog THEN
2503: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, l_module||'.end','Create_WIPUpdateXLAEvent >>');
2504: END IF;
2505:
2506: EXCEPTION
2507: WHEN FND_API.g_exc_error THEN

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

2521: WHEN OTHERS THEN
2522: ROLLBACK TO Create_WIPUpdateXLAEvent;
2523: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2524: IF l_unexpLog THEN
2525: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, l_module||':'||l_stmt_num
2526: ,'Create_WIPUpdateXLAEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
2527: END IF;
2528:
2529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN