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

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

57: the global temporary tables.
58: ------------------------------------------------------------------------------------------*/
59:
60: G_PKG_NAME CONSTANT VARCHAR2(30) :='CST_LcmAdjustments_PVT';
61: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
63:
64: G_PO_APPLICATION_ID CONSTANT NUMBER := 201;
65:

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

106: l_api_version CONSTANT NUMBER := 1.0;
107: l_return_status VARCHAR2(1);
108: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
109:
110: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
111: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
112: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
113: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
114: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

107: l_return_status VARCHAR2(1);
108: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
109:
110: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
111: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
112: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
113: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
114: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
115: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

108: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
109:
110: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
111: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
112: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
113: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
114: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
115: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
116:

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

109:
110: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
111: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
112: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
113: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
114: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
115: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
116:
117: l_stmt_num NUMBER;

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

110: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
111: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
112: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
113: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
114: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
115: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
116:
117: l_stmt_num NUMBER;
118: l_num_records NUMBER;

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

111: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
112: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
113: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
114: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
115: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
116:
117: l_stmt_num NUMBER;
118: l_num_records NUMBER;
119: l_no_of_errored NUMBER;

Line 133: FND_LOG.STRING(

129: l_stmt_num := 0;
130:
131: /* Procedure level log message for Entry point */
132: IF (l_pLog) THEN
133: FND_LOG.STRING(
134: FND_LOG.LEVEL_PROCEDURE,
135: l_module || '.begin',
136: '>> ' || l_api_name || ': Parameters:' ||
137: ' Group id ' || p_group_id ||

Line 134: FND_LOG.LEVEL_PROCEDURE,

130:
131: /* Procedure level log message for Entry point */
132: IF (l_pLog) THEN
133: FND_LOG.STRING(
134: FND_LOG.LEVEL_PROCEDURE,
135: l_module || '.begin',
136: '>> ' || l_api_name || ': Parameters:' ||
137: ' Group id ' || p_group_id ||
138: ', Organization id ' || p_organization_id

Line 266: FND_LOG.STRING(

262: END IF;
263:
264: l_stmt_num := 90;
265: IF (l_pLog) THEN
266: FND_LOG.STRING(
267: FND_LOG.LEVEL_PROCEDURE,
268: l_module || '.end',
269: '<< ' || l_api_name
270: );

Line 267: FND_LOG.LEVEL_PROCEDURE,

263:
264: l_stmt_num := 90;
265: IF (l_pLog) THEN
266: FND_LOG.STRING(
267: FND_LOG.LEVEL_PROCEDURE,
268: l_module || '.end',
269: '<< ' || l_api_name
270: );
271: END IF;

Line 284: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

280: FND_MESSAGE.SET_MODULE(l_module);
281: fnd_file.put_line( FND_FILE.LOG, FND_MESSAGE.GET);
282:
283: IF l_ulog THEN
284: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
285: END IF;
286:
287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',FND_MESSAGE.GET);
288:

Line 293: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK;
291:
292: IF (l_ulog) THEN
293: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
294: END IF;
295:
296: /* Set concurrent program status to error */
297: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);

Line 303: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301:
302: IF (l_exceptionLog) THEN
303: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
304: END IF;
305:
306: /* Set concurrent program status to error */
307: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);

Line 317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

313: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
314: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
315: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
316: IF (l_uLog) THEN
317: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
318: FND_MSG_PUB.ADD;
319:
320: END IF;
321:

Line 325: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

321:
322: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
323: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
324: IF (l_uLog) THEN
325: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
326: FND_MSG_PUB.ADD;
327:
328: END IF;
329:

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

382: l_api_version CONSTANT NUMBER := 1.0;
383: l_return_status VARCHAR2(1);
384: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
385:
386: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
387: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
388: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
389: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
390: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

383: l_return_status VARCHAR2(1);
384: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
385:
386: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
387: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
388: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
389: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
390: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
391: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

384: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
385:
386: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
387: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
388: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
389: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
390: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
391: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
392:

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

385:
386: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
387: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
388: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
389: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
390: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
391: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
392:
393: l_stmt_num NUMBER;

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

386: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
387: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
388: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
389: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
390: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
391: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
392:
393: l_stmt_num NUMBER;
394: l_num_records NUMBER;

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

387: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
388: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
389: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
390: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
391: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
392:
393: l_stmt_num NUMBER;
394: l_num_records NUMBER;
395: l_msg_data VARCHAR2(240);

Line 435: FND_LOG.STRING(

431: l_stmt_num := 0;
432:
433: /* Procedure level log message for Entry point */
434: IF (l_pLog) THEN
435: FND_LOG.STRING(
436: FND_LOG.LEVEL_PROCEDURE,
437: l_module || '.begin',
438: '>> ' || l_api_name || ': Parameters:' ||
439: ' Api version ' || p_api_version ||

Line 436: FND_LOG.LEVEL_PROCEDURE,

432:
433: /* Procedure level log message for Entry point */
434: IF (l_pLog) THEN
435: FND_LOG.STRING(
436: FND_LOG.LEVEL_PROCEDURE,
437: l_module || '.begin',
438: '>> ' || l_api_name || ': Parameters:' ||
439: ' Api version ' || p_api_version ||
440: ', Init msg list ' || p_init_msg_list ||

Line 607: FND_LOG.STRING(

603: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(li.transaction_date, l_legal_entity_id) <= Trunc(oap.schedule_close_date);
604:
605: IF (l_sLog AND l_pLog) THEN
606: l_num_records := SQL%ROWCOUNT;
607: FND_LOG.STRING(
608: FND_LOG.LEVEL_PROCEDURE,
609: l_module || '.query(' || l_stmt_num || ')',
610: l_num_records || ' Rows inserted'
611: );

Line 608: FND_LOG.LEVEL_PROCEDURE,

604:
605: IF (l_sLog AND l_pLog) THEN
606: l_num_records := SQL%ROWCOUNT;
607: FND_LOG.STRING(
608: FND_LOG.LEVEL_PROCEDURE,
609: l_module || '.query(' || l_stmt_num || ')',
610: l_num_records || ' Rows inserted'
611: );
612:

Line 650: FND_LOG.STRING(

646: CONNECT BY rt.parent_transaction_id = PRIOR rt.transaction_id;
647:
648: IF (l_sLog AND l_pLog) THEN
649: l_num_records := SQL%ROWCOUNT;
650: FND_LOG.STRING(
651: FND_LOG.LEVEL_PROCEDURE,
652: l_module || '.query(' || l_stmt_num || ')',
653: l_num_records || ' Rows inserted'
654: );

Line 651: FND_LOG.LEVEL_PROCEDURE,

647:
648: IF (l_sLog AND l_pLog) THEN
649: l_num_records := SQL%ROWCOUNT;
650: FND_LOG.STRING(
651: FND_LOG.LEVEL_PROCEDURE,
652: l_module || '.query(' || l_stmt_num || ')',
653: l_num_records || ' Rows inserted'
654: );
655:

Line 694: FND_LOG.STRING(

690: AND rt_parent.transaction_id (+) = rt.parent_transaction_id;
691:
692: IF (l_sLog AND l_pLog) THEN
693: l_num_records := SQL%ROWCOUNT;
694: FND_LOG.STRING(
695: FND_LOG.LEVEL_PROCEDURE,
696: l_module || '.query(' || l_stmt_num || ')',
697: l_num_records || ' Rows inserted'
698: );

Line 695: FND_LOG.LEVEL_PROCEDURE,

691:
692: IF (l_sLog AND l_pLog) THEN
693: l_num_records := SQL%ROWCOUNT;
694: FND_LOG.STRING(
695: FND_LOG.LEVEL_PROCEDURE,
696: l_module || '.query(' || l_stmt_num || ')',
697: l_num_records || ' Rows inserted'
698: );
699:

Line 708: FND_LOG.STRING(

704: WHERE lcm_transaction_id < 0;
705:
706: IF (l_sLog AND l_pLog) THEN
707: l_num_records := SQL%ROWCOUNT;
708: FND_LOG.STRING(
709: FND_LOG.LEVEL_PROCEDURE,
710: l_module || '.query(' || l_stmt_num || ')',
711: l_num_records || ' Rows Deleted'
712: );

Line 709: FND_LOG.LEVEL_PROCEDURE,

705:
706: IF (l_sLog AND l_pLog) THEN
707: l_num_records := SQL%ROWCOUNT;
708: FND_LOG.STRING(
709: FND_LOG.LEVEL_PROCEDURE,
710: l_module || '.query(' || l_stmt_num || ')',
711: l_num_records || ' Rows Deleted'
712: );
713:

Line 885: FND_LOG.STRING(

881: acc.prior_landed_cost;
882:
883: IF (l_sLog AND l_pLog) THEN
884: l_num_records := SQL%ROWCOUNT;
885: FND_LOG.STRING(
886: FND_LOG.LEVEL_PROCEDURE,
887: l_module || '.query(' || l_stmt_num || ')',
888: l_num_records || ' Rows updated'
889: );

Line 886: FND_LOG.LEVEL_PROCEDURE,

882:
883: IF (l_sLog AND l_pLog) THEN
884: l_num_records := SQL%ROWCOUNT;
885: FND_LOG.STRING(
886: FND_LOG.LEVEL_PROCEDURE,
887: l_module || '.query(' || l_stmt_num || ')',
888: l_num_records || ' Rows updated'
889: );
890:

Line 921: FND_LOG.STRING(

917: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id);
918:
919: IF (l_sLog AND l_pLog) THEN
920: l_num_records := SQL%ROWCOUNT;
921: FND_LOG.STRING(
922: FND_LOG.LEVEL_PROCEDURE,
923: l_module || '.query(' || l_stmt_num || ')',
924: l_num_records || ' Rows inserted'
925: );

Line 922: FND_LOG.LEVEL_PROCEDURE,

918:
919: IF (l_sLog AND l_pLog) THEN
920: l_num_records := SQL%ROWCOUNT;
921: FND_LOG.STRING(
922: FND_LOG.LEVEL_PROCEDURE,
923: l_module || '.query(' || l_stmt_num || ')',
924: l_num_records || ' Rows inserted'
925: );
926:

Line 958: FND_LOG.STRING(

954: AND error_column = 'ACCOUNT');
955:
956: IF (l_sLog AND l_pLog) THEN
957: l_num_records := SQL%ROWCOUNT;
958: FND_LOG.STRING(
959: FND_LOG.LEVEL_PROCEDURE,
960: l_module || '.query(' || l_stmt_num || ')',
961: l_num_records || ' Rows updated'
962: );

Line 959: FND_LOG.LEVEL_PROCEDURE,

955:
956: IF (l_sLog AND l_pLog) THEN
957: l_num_records := SQL%ROWCOUNT;
958: FND_LOG.STRING(
959: FND_LOG.LEVEL_PROCEDURE,
960: l_module || '.query(' || l_stmt_num || ')',
961: l_num_records || ' Rows updated'
962: );
963:

Line 976: FND_LOG.STRING(

972: AND error_column = 'ACCOUNT');
973:
974: IF (l_sLog AND l_pLog) THEN
975: l_num_records := SQL%ROWCOUNT;
976: FND_LOG.STRING(
977: FND_LOG.LEVEL_PROCEDURE,
978: l_module || '.query(' || l_stmt_num || ')',
979: l_num_records || ' Rows deleted'
980: );

Line 977: FND_LOG.LEVEL_PROCEDURE,

973:
974: IF (l_sLog AND l_pLog) THEN
975: l_num_records := SQL%ROWCOUNT;
976: FND_LOG.STRING(
977: FND_LOG.LEVEL_PROCEDURE,
978: l_module || '.query(' || l_stmt_num || ')',
979: l_num_records || ' Rows deleted'
980: );
981:

Line 994: FND_LOG.STRING(

990: AND error_column = 'ACCOUNT');
991:
992: IF (l_sLog AND l_pLog) THEN
993: l_num_records := SQL%ROWCOUNT;
994: FND_LOG.STRING(
995: FND_LOG.LEVEL_PROCEDURE,
996: l_module || '.query(' || l_stmt_num || ')',
997: l_num_records || ' Rows deleted'
998: );

Line 995: FND_LOG.LEVEL_PROCEDURE,

991:
992: IF (l_sLog AND l_pLog) THEN
993: l_num_records := SQL%ROWCOUNT;
994: FND_LOG.STRING(
995: FND_LOG.LEVEL_PROCEDURE,
996: l_module || '.query(' || l_stmt_num || ')',
997: l_num_records || ' Rows deleted'
998: );
999:

Line 1012: FND_LOG.STRING(

1008: AND error_column = 'ACCOUNT');
1009:
1010: IF (l_sLog AND l_pLog) THEN
1011: l_num_records := SQL%ROWCOUNT;
1012: FND_LOG.STRING(
1013: FND_LOG.LEVEL_PROCEDURE,
1014: l_module || '.query(' || l_stmt_num || ')',
1015: l_num_records || ' Rows deleted'
1016: );

Line 1013: FND_LOG.LEVEL_PROCEDURE,

1009:
1010: IF (l_sLog AND l_pLog) THEN
1011: l_num_records := SQL%ROWCOUNT;
1012: FND_LOG.STRING(
1013: FND_LOG.LEVEL_PROCEDURE,
1014: l_module || '.query(' || l_stmt_num || ')',
1015: l_num_records || ' Rows deleted'
1016: );
1017:

Line 1025: FND_LOG.STRING(

1021:
1022: l_stmt_num := 180;
1023:
1024: IF (l_pLog) THEN
1025: FND_LOG.STRING(
1026: FND_LOG.LEVEL_PROCEDURE,
1027: l_module || '.end',
1028: '<< ' || l_api_name || ': Out Parameters:' ||
1029: ' x_ledger_id ' || x_ledger_id ||

Line 1026: FND_LOG.LEVEL_PROCEDURE,

1022: l_stmt_num := 180;
1023:
1024: IF (l_pLog) THEN
1025: FND_LOG.STRING(
1026: FND_LOG.LEVEL_PROCEDURE,
1027: l_module || '.end',
1028: '<< ' || l_api_name || ': Out Parameters:' ||
1029: ' x_ledger_id ' || x_ledger_id ||
1030: ', x_primary_cost_method ' || x_primary_cost_method ||

Line 1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

1036:
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.g_ret_sts_error;
1039: IF (l_ulog) THEN
1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1041: END IF;
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: x_return_status := FND_API.g_ret_sts_error;

Line 1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: x_return_status := FND_API.g_ret_sts_error;
1045: IF (l_exceptionLog) THEN
1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1047: END IF;
1048:
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.g_ret_sts_error;

Line 1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1055: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1056: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1057: FND_MSG_PUB.ADD;
1058:
1059: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1060: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

Line 1061: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

1057: FND_MSG_PUB.ADD;
1058:
1059: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1060: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1061: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1062: FND_MSG_PUB.ADD;
1063:
1064: END IF;
1065:

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

1107: l_api_version CONSTANT NUMBER := 1.0;
1108: l_return_status VARCHAR2(1);
1109: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1110:
1111: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1112: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1113: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1114: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1115: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

1108: l_return_status VARCHAR2(1);
1109: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1110:
1111: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1112: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1113: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1114: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1115: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1116: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

1109: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1110:
1111: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1112: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1113: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1114: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1115: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1116: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1117:

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

1110:
1111: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1112: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1113: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1114: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1115: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1116: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1117:
1118: l_stmt_num NUMBER;

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

1111: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1112: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1113: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1114: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1115: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1116: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1117:
1118: l_stmt_num NUMBER;
1119: l_num_records NUMBER;

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

1112: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1113: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1114: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1115: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1116: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1117:
1118: l_stmt_num NUMBER;
1119: l_num_records NUMBER;
1120: l_msg_data VARCHAR2(240);

Line 1128: FND_LOG.STRING(

1124: l_stmt_num := 0;
1125:
1126: /* Procedure level log message for Entry point */
1127: IF (l_pLog) THEN
1128: FND_LOG.STRING(
1129: FND_LOG.LEVEL_PROCEDURE,
1130: l_module || '.begin',
1131: '>> ' || l_api_name || ': Parameters:' ||
1132: ' Api version ' || p_api_version ||

Line 1129: FND_LOG.LEVEL_PROCEDURE,

1125:
1126: /* Procedure level log message for Entry point */
1127: IF (l_pLog) THEN
1128: FND_LOG.STRING(
1129: FND_LOG.LEVEL_PROCEDURE,
1130: l_module || '.begin',
1131: '>> ' || l_api_name || ': Parameters:' ||
1132: ' Api version ' || p_api_version ||
1133: ', Init msg list ' || p_init_msg_list ||

Line 1299: FND_LOG.STRING(

1295: LCM_account ;
1296:
1297: IF (l_sLog AND l_pLog) THEN
1298: l_num_records := SQL%ROWCOUNT;
1299: FND_LOG.STRING(
1300: FND_LOG.LEVEL_PROCEDURE,
1301: l_module || '.query(' || l_stmt_num || ')',
1302: l_num_records || ' Rows inserted'
1303: );

Line 1300: FND_LOG.LEVEL_PROCEDURE,

1296:
1297: IF (l_sLog AND l_pLog) THEN
1298: l_num_records := SQL%ROWCOUNT;
1299: FND_LOG.STRING(
1300: FND_LOG.LEVEL_PROCEDURE,
1301: l_module || '.query(' || l_stmt_num || ')',
1302: l_num_records || ' Rows inserted'
1303: );
1304:

Line 1450: FND_LOG.STRING(

1446: adj_acc.accounting_line_type;
1447:
1448: IF (l_sLog AND l_pLog) THEN
1449: l_num_records := SQL%ROWCOUNT;
1450: FND_LOG.STRING(
1451: FND_LOG.LEVEL_PROCEDURE,
1452: l_module || '.query(' || l_stmt_num || ')',
1453: l_num_records || ' Rows inserted'
1454: );

Line 1451: FND_LOG.LEVEL_PROCEDURE,

1447:
1448: IF (l_sLog AND l_pLog) THEN
1449: l_num_records := SQL%ROWCOUNT;
1450: FND_LOG.STRING(
1451: FND_LOG.LEVEL_PROCEDURE,
1452: l_module || '.query(' || l_stmt_num || ')',
1453: l_num_records || ' Rows inserted'
1454: );
1455:

Line 1573: FND_LOG.STRING(

1569: msi.primary_uom_code;
1570:
1571: IF (l_sLog AND l_pLog) THEN
1572: l_num_records := SQL%ROWCOUNT;
1573: FND_LOG.STRING(
1574: FND_LOG.LEVEL_PROCEDURE,
1575: l_module || '.query(' || l_stmt_num || ')',
1576: l_num_records || ' Rows inserted'
1577: );

Line 1574: FND_LOG.LEVEL_PROCEDURE,

1570:
1571: IF (l_sLog AND l_pLog) THEN
1572: l_num_records := SQL%ROWCOUNT;
1573: FND_LOG.STRING(
1574: FND_LOG.LEVEL_PROCEDURE,
1575: l_module || '.query(' || l_stmt_num || ')',
1576: l_num_records || ' Rows inserted'
1577: );
1578:

Line 1587: FND_LOG.STRING(

1583: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1584:
1585: IF (l_sLog AND l_pLog) THEN
1586: l_num_records := SQL%ROWCOUNT;
1587: FND_LOG.STRING(
1588: FND_LOG.LEVEL_PROCEDURE,
1589: l_module || '.query(' || l_stmt_num || ')',
1590: l_num_records || ' Rows updated'
1591: );

Line 1588: FND_LOG.LEVEL_PROCEDURE,

1584:
1585: IF (l_sLog AND l_pLog) THEN
1586: l_num_records := SQL%ROWCOUNT;
1587: FND_LOG.STRING(
1588: FND_LOG.LEVEL_PROCEDURE,
1589: l_module || '.query(' || l_stmt_num || ')',
1590: l_num_records || ' Rows updated'
1591: );
1592:

Line 1723: FND_LOG.STRING(

1719: msi.primary_uom_code;
1720:
1721: IF (l_sLog AND l_pLog) THEN
1722: l_num_records := SQL%ROWCOUNT;
1723: FND_LOG.STRING(
1724: FND_LOG.LEVEL_PROCEDURE,
1725: l_module || '.query(' || l_stmt_num || ')',
1726: l_num_records || ' Rows inserted'
1727: );

Line 1724: FND_LOG.LEVEL_PROCEDURE,

1720:
1721: IF (l_sLog AND l_pLog) THEN
1722: l_num_records := SQL%ROWCOUNT;
1723: FND_LOG.STRING(
1724: FND_LOG.LEVEL_PROCEDURE,
1725: l_module || '.query(' || l_stmt_num || ')',
1726: l_num_records || ' Rows inserted'
1727: );
1728:

Line 1737: FND_LOG.STRING(

1733: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1734:
1735: IF (l_sLog AND l_pLog) THEN
1736: l_num_records := SQL%ROWCOUNT;
1737: FND_LOG.STRING(
1738: FND_LOG.LEVEL_PROCEDURE,
1739: l_module || '.query(' || l_stmt_num || ')',
1740: l_num_records || ' Rows updated'
1741: );

Line 1738: FND_LOG.LEVEL_PROCEDURE,

1734:
1735: IF (l_sLog AND l_pLog) THEN
1736: l_num_records := SQL%ROWCOUNT;
1737: FND_LOG.STRING(
1738: FND_LOG.LEVEL_PROCEDURE,
1739: l_module || '.query(' || l_stmt_num || ')',
1740: l_num_records || ' Rows updated'
1741: );
1742:

Line 1750: FND_LOG.STRING(

1746:
1747:
1748: l_stmt_num := 110;
1749: IF (l_pLog) THEN
1750: FND_LOG.STRING(
1751: FND_LOG.LEVEL_PROCEDURE,
1752: l_module || '.end',
1753: '<< ' || l_api_name || ': Out Parameters:' ||
1754: ', x_return_status ' || x_return_status

Line 1751: FND_LOG.LEVEL_PROCEDURE,

1747:
1748: l_stmt_num := 110;
1749: IF (l_pLog) THEN
1750: FND_LOG.STRING(
1751: FND_LOG.LEVEL_PROCEDURE,
1752: l_module || '.end',
1753: '<< ' || l_api_name || ': Out Parameters:' ||
1754: ', x_return_status ' || x_return_status
1755: );

Line 1763: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

1759:
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: x_return_status := FND_API.g_ret_sts_error;
1762: IF (l_uLog) THEN
1763: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1764: END IF;
1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: x_return_status := FND_API.g_ret_sts_error;

Line 1769: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: x_return_status := FND_API.g_ret_sts_error;
1768: IF (l_exceptionLog) THEN
1769: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1770: END IF;
1771:
1772: WHEN OTHERS THEN
1773: x_return_status := FND_API.g_ret_sts_error;

Line 1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1778: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1779: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1780: FND_MSG_PUB.ADD;
1781:
1782: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1783: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

Line 1784: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

1780: FND_MSG_PUB.ADD;
1781:
1782: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1783: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1784: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1785: FND_MSG_PUB.ADD;
1786:
1787: END IF;
1788:

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

1832: l_api_version CONSTANT NUMBER := 1.0;
1833: l_return_status VARCHAR2(1);
1834: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1835:
1836: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1837: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1838: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1839: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1840: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

1833: l_return_status VARCHAR2(1);
1834: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1835:
1836: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1837: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1838: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1839: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1840: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1841: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

1834: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1835:
1836: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1837: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1838: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1839: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1840: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1841: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1842:

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

1835:
1836: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1837: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1838: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1839: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1840: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1841: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1842:
1843: l_stmt_num NUMBER;

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

1836: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1837: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1838: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1839: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1840: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1841: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1842:
1843: l_stmt_num NUMBER;
1844: l_num_records NUMBER;

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

1837: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1838: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1839: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1840: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1841: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1842:
1843: l_stmt_num NUMBER;
1844: l_num_records NUMBER;
1845: l_msg_data VARCHAR2(240);

Line 1854: FND_LOG.STRING(

1850: l_stmt_num := 0;
1851:
1852: /* Procedure level log message for Entry point */
1853: IF (l_pLog) THEN
1854: FND_LOG.STRING(
1855: FND_LOG.LEVEL_PROCEDURE,
1856: l_module || '.begin',
1857: '>> ' || l_api_name || ': Parameters:' ||
1858: ' Api version ' || p_api_version ||

Line 1855: FND_LOG.LEVEL_PROCEDURE,

1851:
1852: /* Procedure level log message for Entry point */
1853: IF (l_pLog) THEN
1854: FND_LOG.STRING(
1855: FND_LOG.LEVEL_PROCEDURE,
1856: l_module || '.begin',
1857: '>> ' || l_api_name || ': Parameters:' ||
1858: ' Api version ' || p_api_version ||
1859: ', Init msg list ' || p_init_msg_list ||

Line 1972: FND_LOG.STRING(

1968: FROM cst_lc_rae_events_gt;
1969:
1970: IF (l_sLog AND l_pLog) THEN
1971: l_num_records := SQL%ROWCOUNT;
1972: FND_LOG.STRING(
1973: FND_LOG.LEVEL_PROCEDURE,
1974: l_module || '.query(' || l_stmt_num || ')',
1975: l_num_records || ' Rows inserted'
1976: );

Line 1973: FND_LOG.LEVEL_PROCEDURE,

1969:
1970: IF (l_sLog AND l_pLog) THEN
1971: l_num_records := SQL%ROWCOUNT;
1972: FND_LOG.STRING(
1973: FND_LOG.LEVEL_PROCEDURE,
1974: l_module || '.query(' || l_stmt_num || ')',
1975: l_num_records || ' Rows inserted'
1976: );
1977:

Line 2076: FND_LOG.STRING(

2072: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2073:
2074: IF (l_sLog AND l_pLog) THEN
2075: l_num_records := SQL%ROWCOUNT;
2076: FND_LOG.STRING(
2077: FND_LOG.LEVEL_PROCEDURE,
2078: l_module || '.query(' || l_stmt_num || ')',
2079: l_num_records || ' Rows inserted'
2080: );

Line 2077: FND_LOG.LEVEL_PROCEDURE,

2073:
2074: IF (l_sLog AND l_pLog) THEN
2075: l_num_records := SQL%ROWCOUNT;
2076: FND_LOG.STRING(
2077: FND_LOG.LEVEL_PROCEDURE,
2078: l_module || '.query(' || l_stmt_num || ')',
2079: l_num_records || ' Rows inserted'
2080: );
2081:

Line 2178: FND_LOG.STRING(

2174: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2175:
2176: IF (l_sLog AND l_pLog) THEN
2177: l_num_records := SQL%ROWCOUNT;
2178: FND_LOG.STRING(
2179: FND_LOG.LEVEL_PROCEDURE,
2180: l_module || '.query(' || l_stmt_num || ')',
2181: l_num_records || ' Rows inserted'
2182: );

Line 2179: FND_LOG.LEVEL_PROCEDURE,

2175:
2176: IF (l_sLog AND l_pLog) THEN
2177: l_num_records := SQL%ROWCOUNT;
2178: FND_LOG.STRING(
2179: FND_LOG.LEVEL_PROCEDURE,
2180: l_module || '.query(' || l_stmt_num || ')',
2181: l_num_records || ' Rows inserted'
2182: );
2183:

Line 2226: FND_LOG.STRING(

2222: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;
2223:
2224: IF (l_sLog AND l_pLog) THEN
2225: l_num_records := SQL%ROWCOUNT;
2226: FND_LOG.STRING(
2227: FND_LOG.LEVEL_PROCEDURE,
2228: l_module || '.query(' || l_stmt_num || ')',
2229: l_num_records || ' Rows inserted'
2230: );

Line 2227: FND_LOG.LEVEL_PROCEDURE,

2223:
2224: IF (l_sLog AND l_pLog) THEN
2225: l_num_records := SQL%ROWCOUNT;
2226: FND_LOG.STRING(
2227: FND_LOG.LEVEL_PROCEDURE,
2228: l_module || '.query(' || l_stmt_num || ')',
2229: l_num_records || ' Rows inserted'
2230: );
2231:

Line 2317: FND_LOG.STRING(

2313: FROM CST_LC_MMT_GT;
2314:
2315: IF (l_sLog AND l_pLog) THEN
2316: l_num_records := SQL%ROWCOUNT;
2317: FND_LOG.STRING(
2318: FND_LOG.LEVEL_PROCEDURE,
2319: l_module || '.query(' || l_stmt_num || ')',
2320: l_num_records || ' Rows inserted'
2321: );

Line 2318: FND_LOG.LEVEL_PROCEDURE,

2314:
2315: IF (l_sLog AND l_pLog) THEN
2316: l_num_records := SQL%ROWCOUNT;
2317: FND_LOG.STRING(
2318: FND_LOG.LEVEL_PROCEDURE,
2319: l_module || '.query(' || l_stmt_num || ')',
2320: l_num_records || ' Rows inserted'
2321: );
2322:

Line 2369: FND_LOG.STRING(

2365: AND cmap.transaction_type_id = rae.event_type_id;
2366:
2367: IF (l_sLog AND l_pLog) THEN
2368: l_num_records := SQL%ROWCOUNT;
2369: FND_LOG.STRING(
2370: FND_LOG.LEVEL_PROCEDURE,
2371: l_module || '.query(' || l_stmt_num || ')',
2372: l_num_records || ' Rows inserted'
2373: );

Line 2370: FND_LOG.LEVEL_PROCEDURE,

2366:
2367: IF (l_sLog AND l_pLog) THEN
2368: l_num_records := SQL%ROWCOUNT;
2369: FND_LOG.STRING(
2370: FND_LOG.LEVEL_PROCEDURE,
2371: l_module || '.query(' || l_stmt_num || ')',
2372: l_num_records || ' Rows inserted'
2373: );
2374:

Line 2430: FND_LOG.STRING(

2426: AND process_status = 2;
2427:
2428: IF (l_sLog AND l_pLog) THEN
2429: l_num_records := SQL%ROWCOUNT;
2430: FND_LOG.STRING(
2431: FND_LOG.LEVEL_PROCEDURE,
2432: l_module || '.query(' || l_stmt_num || ')',
2433: l_num_records || ' Rows inserted'
2434: );

Line 2431: FND_LOG.LEVEL_PROCEDURE,

2427:
2428: IF (l_sLog AND l_pLog) THEN
2429: l_num_records := SQL%ROWCOUNT;
2430: FND_LOG.STRING(
2431: FND_LOG.LEVEL_PROCEDURE,
2432: l_module || '.query(' || l_stmt_num || ')',
2433: l_num_records || ' Rows inserted'
2434: );
2435:

Line 2450: FND_LOG.STRING(

2446: WHERE t.transaction_id = e.transaction_id);
2447:
2448: IF (l_sLog AND l_pLog) THEN
2449: l_num_records := SQL%ROWCOUNT;
2450: FND_LOG.STRING(
2451: FND_LOG.LEVEL_PROCEDURE,
2452: l_module || '.query(' || l_stmt_num || ')',
2453: l_num_records || ' Rows deleted'
2454: );

Line 2451: FND_LOG.LEVEL_PROCEDURE,

2447:
2448: IF (l_sLog AND l_pLog) THEN
2449: l_num_records := SQL%ROWCOUNT;
2450: FND_LOG.STRING(
2451: FND_LOG.LEVEL_PROCEDURE,
2452: l_module || '.query(' || l_stmt_num || ')',
2453: l_num_records || ' Rows deleted'
2454: );
2455:

Line 2460: FND_LOG.STRING(

2456: END IF;
2457:
2458: l_stmt_num := 100;
2459: IF (l_pLog) THEN
2460: FND_LOG.STRING(
2461: FND_LOG.LEVEL_PROCEDURE,
2462: l_module || '.end',
2463: '<< ' || l_api_name || ': Out Parameters:' ||
2464: ', x_return_status ' || x_return_status

Line 2461: FND_LOG.LEVEL_PROCEDURE,

2457:
2458: l_stmt_num := 100;
2459: IF (l_pLog) THEN
2460: FND_LOG.STRING(
2461: FND_LOG.LEVEL_PROCEDURE,
2462: l_module || '.end',
2463: '<< ' || l_api_name || ': Out Parameters:' ||
2464: ', x_return_status ' || x_return_status
2465: );

Line 2473: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

2469:
2470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2471: x_return_status := FND_API.g_ret_sts_error;
2472: IF (l_uLog) THEN
2473: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2474: END IF;
2475:
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: x_return_status := FND_API.g_ret_sts_error;

Line 2479: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

2475:
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: x_return_status := FND_API.g_ret_sts_error;
2478: IF (l_exceptionLog) THEN
2479: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2480: END IF;
2481:
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.g_ret_sts_error;

Line 2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2488: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2489: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2490: FND_MSG_PUB.ADD;
2491:
2492: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2493: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

Line 2494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

2490: FND_MSG_PUB.ADD;
2491:
2492: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2493: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2494: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2495: FND_MSG_PUB.ADD;
2496:
2497: END IF;
2498:

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

2544: l_api_version CONSTANT NUMBER := 1.0;
2545: l_return_status VARCHAR2(1);
2546: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
2547:
2548: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2549: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2550: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

2545: l_return_status VARCHAR2(1);
2546: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
2547:
2548: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2549: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2550: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

2546: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
2547:
2548: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2549: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2550: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:

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

2547:
2548: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2549: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2550: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:
2555: l_stmt_num NUMBER;

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

2548: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2549: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2550: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:
2555: l_stmt_num NUMBER;
2556: l_num_records NUMBER;

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

2549: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2550: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2551: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2552: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2553: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2554:
2555: l_stmt_num NUMBER;
2556: l_num_records NUMBER;
2557: l_msg_data VARCHAR2(240);

Line 2567: FND_LOG.STRING(

2563: l_stmt_num := 0;
2564:
2565: /* Procedure level log message for Entry point */
2566: IF (l_pLog) THEN
2567: FND_LOG.STRING(
2568: FND_LOG.LEVEL_PROCEDURE,
2569: l_module || '.begin',
2570: '>> ' || l_api_name || ': Parameters:' ||
2571: ' Api version ' || p_api_version ||

Line 2568: FND_LOG.LEVEL_PROCEDURE,

2564:
2565: /* Procedure level log message for Entry point */
2566: IF (l_pLog) THEN
2567: FND_LOG.STRING(
2568: FND_LOG.LEVEL_PROCEDURE,
2569: l_module || '.begin',
2570: '>> ' || l_api_name || ': Parameters:' ||
2571: ' Api version ' || p_api_version ||
2572: ', Init msg list ' || p_init_msg_list ||

Line 2745: FND_LOG.STRING(

2741: AND msi.organization_id (+) = clai.organization_id;
2742:
2743: IF (l_sLog AND l_pLog) THEN
2744: l_num_records := SQL%ROWCOUNT;
2745: FND_LOG.STRING(
2746: FND_LOG.LEVEL_PROCEDURE,
2747: l_module || '.query(' || l_stmt_num || ')',
2748: l_num_records || ' Rows inserted'
2749: );

Line 2746: FND_LOG.LEVEL_PROCEDURE,

2742:
2743: IF (l_sLog AND l_pLog) THEN
2744: l_num_records := SQL%ROWCOUNT;
2745: FND_LOG.STRING(
2746: FND_LOG.LEVEL_PROCEDURE,
2747: l_module || '.query(' || l_stmt_num || ')',
2748: l_num_records || ' Rows inserted'
2749: );
2750:

Line 2778: FND_LOG.STRING(

2774: and gps.closing_status <> 'O';
2775:
2776: IF (l_sLog AND l_pLog) THEN
2777: l_num_records := SQL%ROWCOUNT;
2778: FND_LOG.STRING(
2779: FND_LOG.LEVEL_PROCEDURE,
2780: l_module || '.query(' || l_stmt_num || ')',
2781: l_num_records || ' Rows inserted'
2782: );

Line 2779: FND_LOG.LEVEL_PROCEDURE,

2775:
2776: IF (l_sLog AND l_pLog) THEN
2777: l_num_records := SQL%ROWCOUNT;
2778: FND_LOG.STRING(
2779: FND_LOG.LEVEL_PROCEDURE,
2780: l_module || '.query(' || l_stmt_num || ')',
2781: l_num_records || ' Rows inserted'
2782: );
2783:

Line 2801: FND_LOG.STRING(

2797: AND e.group_id = p_group_id);
2798:
2799: IF (l_sLog AND l_pLog) THEN
2800: l_num_records := SQL%ROWCOUNT;
2801: FND_LOG.STRING(
2802: FND_LOG.LEVEL_PROCEDURE,
2803: l_module || '.query(' || l_stmt_num || ')',
2804: l_num_records || ' Rows updated'
2805: );

Line 2802: FND_LOG.LEVEL_PROCEDURE,

2798:
2799: IF (l_sLog AND l_pLog) THEN
2800: l_num_records := SQL%ROWCOUNT;
2801: FND_LOG.STRING(
2802: FND_LOG.LEVEL_PROCEDURE,
2803: l_module || '.query(' || l_stmt_num || ')',
2804: l_num_records || ' Rows updated'
2805: );
2806:

Line 2821: FND_LOG.STRING(

2817: AND process_status = 1;
2818:
2819: IF (l_sLog AND l_pLog) THEN
2820: l_num_records := SQL%ROWCOUNT;
2821: FND_LOG.STRING(
2822: FND_LOG.LEVEL_PROCEDURE,
2823: l_module || '.query(' || l_stmt_num || ')',
2824: l_num_records || ' Rows updated'
2825: );

Line 2822: FND_LOG.LEVEL_PROCEDURE,

2818:
2819: IF (l_sLog AND l_pLog) THEN
2820: l_num_records := SQL%ROWCOUNT;
2821: FND_LOG.STRING(
2822: FND_LOG.LEVEL_PROCEDURE,
2823: l_module || '.query(' || l_stmt_num || ')',
2824: l_num_records || ' Rows updated'
2825: );
2826:

Line 2832: FND_LOG.STRING(

2828:
2829: l_stmt_num := 50;
2830: IF (
2831: l_pLog) THEN
2832: FND_LOG.STRING(
2833: FND_LOG.LEVEL_PROCEDURE,
2834: l_module || '.end',
2835: '<< ' || l_api_name || ': Out Parameters:' ||
2836: ' x_no_of_errored ' || x_no_of_errored ||

Line 2833: FND_LOG.LEVEL_PROCEDURE,

2829: l_stmt_num := 50;
2830: IF (
2831: l_pLog) THEN
2832: FND_LOG.STRING(
2833: FND_LOG.LEVEL_PROCEDURE,
2834: l_module || '.end',
2835: '<< ' || l_api_name || ': Out Parameters:' ||
2836: ' x_no_of_errored ' || x_no_of_errored ||
2837: ', x_return_status ' || x_return_status

Line 2846: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

2842:
2843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2844: x_return_status := FND_API.g_ret_sts_error;
2845: IF (l_uLog) THEN
2846: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2847: END IF;
2848:
2849: WHEN FND_API.G_EXC_ERROR THEN
2850: x_return_status := FND_API.g_ret_sts_error;

Line 2852: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

2848:
2849: WHEN FND_API.G_EXC_ERROR THEN
2850: x_return_status := FND_API.g_ret_sts_error;
2851: IF (l_exceptionLog) THEN
2852: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2853: END IF;
2854:
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.g_ret_sts_error;

Line 2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2861: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2862: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2863: FND_MSG_PUB.ADD;
2864:
2865: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2866: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

Line 2867: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

2863: FND_MSG_PUB.ADD;
2864:
2865: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2866: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2867: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2868: FND_MSG_PUB.ADD;
2869:
2870: END IF;
2871: