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 1308: FND_LOG.STRING(

1304: 0)) * rt.source_doc_quantity) <> 0;
1305:
1306: IF (l_sLog AND l_pLog) THEN
1307: l_num_records := SQL%ROWCOUNT;
1308: FND_LOG.STRING(
1309: FND_LOG.LEVEL_PROCEDURE,
1310: l_module || '.query(' || l_stmt_num || ')',
1311: l_num_records || ' Rows inserted'
1312: );

Line 1309: FND_LOG.LEVEL_PROCEDURE,

1305:
1306: IF (l_sLog AND l_pLog) THEN
1307: l_num_records := SQL%ROWCOUNT;
1308: FND_LOG.STRING(
1309: FND_LOG.LEVEL_PROCEDURE,
1310: l_module || '.query(' || l_stmt_num || ')',
1311: l_num_records || ' Rows inserted'
1312: );
1313:

Line 1466: FND_LOG.STRING(

1462: 0)) * source_doc_quantity) <> 0;
1463:
1464: IF (l_sLog AND l_pLog) THEN
1465: l_num_records := SQL%ROWCOUNT;
1466: FND_LOG.STRING(
1467: FND_LOG.LEVEL_PROCEDURE,
1468: l_module || '.query(' || l_stmt_num || ')',
1469: l_num_records || ' Rows inserted'
1470: );

Line 1467: FND_LOG.LEVEL_PROCEDURE,

1463:
1464: IF (l_sLog AND l_pLog) THEN
1465: l_num_records := SQL%ROWCOUNT;
1466: FND_LOG.STRING(
1467: FND_LOG.LEVEL_PROCEDURE,
1468: l_module || '.query(' || l_stmt_num || ')',
1469: l_num_records || ' Rows inserted'
1470: );
1471:

Line 1590: FND_LOG.STRING(

1586: HAVING sum(mmt.primary_quantity) <> 0;
1587:
1588: IF (l_sLog AND l_pLog) THEN
1589: l_num_records := SQL%ROWCOUNT;
1590: FND_LOG.STRING(
1591: FND_LOG.LEVEL_PROCEDURE,
1592: l_module || '.query(' || l_stmt_num || ')',
1593: l_num_records || ' Rows inserted'
1594: );

Line 1591: FND_LOG.LEVEL_PROCEDURE,

1587:
1588: IF (l_sLog AND l_pLog) THEN
1589: l_num_records := SQL%ROWCOUNT;
1590: FND_LOG.STRING(
1591: FND_LOG.LEVEL_PROCEDURE,
1592: l_module || '.query(' || l_stmt_num || ')',
1593: l_num_records || ' Rows inserted'
1594: );
1595:

Line 1604: FND_LOG.STRING(

1600: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1601:
1602: IF (l_sLog AND l_pLog) THEN
1603: l_num_records := SQL%ROWCOUNT;
1604: FND_LOG.STRING(
1605: FND_LOG.LEVEL_PROCEDURE,
1606: l_module || '.query(' || l_stmt_num || ')',
1607: l_num_records || ' Rows updated'
1608: );

Line 1605: FND_LOG.LEVEL_PROCEDURE,

1601:
1602: IF (l_sLog AND l_pLog) THEN
1603: l_num_records := SQL%ROWCOUNT;
1604: FND_LOG.STRING(
1605: FND_LOG.LEVEL_PROCEDURE,
1606: l_module || '.query(' || l_stmt_num || ')',
1607: l_num_records || ' Rows updated'
1608: );
1609:

Line 1741: FND_LOG.STRING(

1737: HAVING sum(txn.layer_quantity) <> 0;
1738:
1739: IF (l_sLog AND l_pLog) THEN
1740: l_num_records := SQL%ROWCOUNT;
1741: FND_LOG.STRING(
1742: FND_LOG.LEVEL_PROCEDURE,
1743: l_module || '.query(' || l_stmt_num || ')',
1744: l_num_records || ' Rows inserted'
1745: );

Line 1742: FND_LOG.LEVEL_PROCEDURE,

1738:
1739: IF (l_sLog AND l_pLog) THEN
1740: l_num_records := SQL%ROWCOUNT;
1741: FND_LOG.STRING(
1742: FND_LOG.LEVEL_PROCEDURE,
1743: l_module || '.query(' || l_stmt_num || ')',
1744: l_num_records || ' Rows inserted'
1745: );
1746:

Line 1755: FND_LOG.STRING(

1751: SET transaction_id = MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL;
1752:
1753: IF (l_sLog AND l_pLog) THEN
1754: l_num_records := SQL%ROWCOUNT;
1755: FND_LOG.STRING(
1756: FND_LOG.LEVEL_PROCEDURE,
1757: l_module || '.query(' || l_stmt_num || ')',
1758: l_num_records || ' Rows updated'
1759: );

Line 1756: FND_LOG.LEVEL_PROCEDURE,

1752:
1753: IF (l_sLog AND l_pLog) THEN
1754: l_num_records := SQL%ROWCOUNT;
1755: FND_LOG.STRING(
1756: FND_LOG.LEVEL_PROCEDURE,
1757: l_module || '.query(' || l_stmt_num || ')',
1758: l_num_records || ' Rows updated'
1759: );
1760:

Line 1768: FND_LOG.STRING(

1764:
1765:
1766: l_stmt_num := 110;
1767: IF (l_pLog) THEN
1768: FND_LOG.STRING(
1769: FND_LOG.LEVEL_PROCEDURE,
1770: l_module || '.end',
1771: '<< ' || l_api_name || ': Out Parameters:' ||
1772: ', x_return_status ' || x_return_status

Line 1769: FND_LOG.LEVEL_PROCEDURE,

1765:
1766: l_stmt_num := 110;
1767: IF (l_pLog) THEN
1768: FND_LOG.STRING(
1769: FND_LOG.LEVEL_PROCEDURE,
1770: l_module || '.end',
1771: '<< ' || l_api_name || ': Out Parameters:' ||
1772: ', x_return_status ' || x_return_status
1773: );

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

1777:
1778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1779: x_return_status := FND_API.g_ret_sts_error;
1780: IF (l_uLog) THEN
1781: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1782: END IF;
1783:
1784: WHEN FND_API.G_EXC_ERROR THEN
1785: x_return_status := FND_API.g_ret_sts_error;

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

1783:
1784: WHEN FND_API.G_EXC_ERROR THEN
1785: x_return_status := FND_API.g_ret_sts_error;
1786: IF (l_exceptionLog) THEN
1787: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1788: END IF;
1789:
1790: WHEN OTHERS THEN
1791: x_return_status := FND_API.g_ret_sts_error;

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

1793: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1794: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1795: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1796: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1797: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1798: FND_MSG_PUB.ADD;
1799:
1800: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1801: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

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

1798: FND_MSG_PUB.ADD;
1799:
1800: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
1801: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
1802: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1803: FND_MSG_PUB.ADD;
1804:
1805: END IF;
1806:

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

1850: l_api_version CONSTANT NUMBER := 1.0;
1851: l_return_status VARCHAR2(1);
1852: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1853:
1854: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1855: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1856: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1857: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1858: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

1851: l_return_status VARCHAR2(1);
1852: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1853:
1854: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1855: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1856: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1857: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1858: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1859: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

1852: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
1853:
1854: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1855: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1856: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1857: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1858: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1859: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1860:

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

1853:
1854: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1855: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1856: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1857: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1858: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1859: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1860:
1861: l_stmt_num NUMBER;

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

1854: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1855: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1856: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1857: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1858: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1859: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1860:
1861: l_stmt_num NUMBER;
1862: l_num_records NUMBER;

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

1855: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1856: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1857: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
1858: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1859: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1860:
1861: l_stmt_num NUMBER;
1862: l_num_records NUMBER;
1863: l_msg_data VARCHAR2(240);

Line 1872: FND_LOG.STRING(

1868: l_stmt_num := 0;
1869:
1870: /* Procedure level log message for Entry point */
1871: IF (l_pLog) THEN
1872: FND_LOG.STRING(
1873: FND_LOG.LEVEL_PROCEDURE,
1874: l_module || '.begin',
1875: '>> ' || l_api_name || ': Parameters:' ||
1876: ' Api version ' || p_api_version ||

Line 1873: FND_LOG.LEVEL_PROCEDURE,

1869:
1870: /* Procedure level log message for Entry point */
1871: IF (l_pLog) THEN
1872: FND_LOG.STRING(
1873: FND_LOG.LEVEL_PROCEDURE,
1874: l_module || '.begin',
1875: '>> ' || l_api_name || ': Parameters:' ||
1876: ' Api version ' || p_api_version ||
1877: ', Init msg list ' || p_init_msg_list ||

Line 1990: FND_LOG.STRING(

1986: FROM cst_lc_rae_events_gt;
1987:
1988: IF (l_sLog AND l_pLog) THEN
1989: l_num_records := SQL%ROWCOUNT;
1990: FND_LOG.STRING(
1991: FND_LOG.LEVEL_PROCEDURE,
1992: l_module || '.query(' || l_stmt_num || ')',
1993: l_num_records || ' Rows inserted'
1994: );

Line 1991: FND_LOG.LEVEL_PROCEDURE,

1987:
1988: IF (l_sLog AND l_pLog) THEN
1989: l_num_records := SQL%ROWCOUNT;
1990: FND_LOG.STRING(
1991: FND_LOG.LEVEL_PROCEDURE,
1992: l_module || '.query(' || l_stmt_num || ')',
1993: l_num_records || ' Rows inserted'
1994: );
1995:

Line 2094: FND_LOG.STRING(

2090: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2091:
2092: IF (l_sLog AND l_pLog) THEN
2093: l_num_records := SQL%ROWCOUNT;
2094: FND_LOG.STRING(
2095: FND_LOG.LEVEL_PROCEDURE,
2096: l_module || '.query(' || l_stmt_num || ')',
2097: l_num_records || ' Rows inserted'
2098: );

Line 2095: FND_LOG.LEVEL_PROCEDURE,

2091:
2092: IF (l_sLog AND l_pLog) THEN
2093: l_num_records := SQL%ROWCOUNT;
2094: FND_LOG.STRING(
2095: FND_LOG.LEVEL_PROCEDURE,
2096: l_module || '.query(' || l_stmt_num || ')',
2097: l_num_records || ' Rows inserted'
2098: );
2099:

Line 2196: FND_LOG.STRING(

2192: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2193:
2194: IF (l_sLog AND l_pLog) THEN
2195: l_num_records := SQL%ROWCOUNT;
2196: FND_LOG.STRING(
2197: FND_LOG.LEVEL_PROCEDURE,
2198: l_module || '.query(' || l_stmt_num || ')',
2199: l_num_records || ' Rows inserted'
2200: );

Line 2197: FND_LOG.LEVEL_PROCEDURE,

2193:
2194: IF (l_sLog AND l_pLog) THEN
2195: l_num_records := SQL%ROWCOUNT;
2196: FND_LOG.STRING(
2197: FND_LOG.LEVEL_PROCEDURE,
2198: l_module || '.query(' || l_stmt_num || ')',
2199: l_num_records || ' Rows inserted'
2200: );
2201:

Line 2244: FND_LOG.STRING(

2240: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;
2241:
2242: IF (l_sLog AND l_pLog) THEN
2243: l_num_records := SQL%ROWCOUNT;
2244: FND_LOG.STRING(
2245: FND_LOG.LEVEL_PROCEDURE,
2246: l_module || '.query(' || l_stmt_num || ')',
2247: l_num_records || ' Rows inserted'
2248: );

Line 2245: FND_LOG.LEVEL_PROCEDURE,

2241:
2242: IF (l_sLog AND l_pLog) THEN
2243: l_num_records := SQL%ROWCOUNT;
2244: FND_LOG.STRING(
2245: FND_LOG.LEVEL_PROCEDURE,
2246: l_module || '.query(' || l_stmt_num || ')',
2247: l_num_records || ' Rows inserted'
2248: );
2249:

Line 2335: FND_LOG.STRING(

2331: FROM CST_LC_MMT_GT;
2332:
2333: IF (l_sLog AND l_pLog) THEN
2334: l_num_records := SQL%ROWCOUNT;
2335: FND_LOG.STRING(
2336: FND_LOG.LEVEL_PROCEDURE,
2337: l_module || '.query(' || l_stmt_num || ')',
2338: l_num_records || ' Rows inserted'
2339: );

Line 2336: FND_LOG.LEVEL_PROCEDURE,

2332:
2333: IF (l_sLog AND l_pLog) THEN
2334: l_num_records := SQL%ROWCOUNT;
2335: FND_LOG.STRING(
2336: FND_LOG.LEVEL_PROCEDURE,
2337: l_module || '.query(' || l_stmt_num || ')',
2338: l_num_records || ' Rows inserted'
2339: );
2340:

Line 2387: FND_LOG.STRING(

2383: AND cmap.transaction_type_id = rae.event_type_id;
2384:
2385: IF (l_sLog AND l_pLog) THEN
2386: l_num_records := SQL%ROWCOUNT;
2387: FND_LOG.STRING(
2388: FND_LOG.LEVEL_PROCEDURE,
2389: l_module || '.query(' || l_stmt_num || ')',
2390: l_num_records || ' Rows inserted'
2391: );

Line 2388: FND_LOG.LEVEL_PROCEDURE,

2384:
2385: IF (l_sLog AND l_pLog) THEN
2386: l_num_records := SQL%ROWCOUNT;
2387: FND_LOG.STRING(
2388: FND_LOG.LEVEL_PROCEDURE,
2389: l_module || '.query(' || l_stmt_num || ')',
2390: l_num_records || ' Rows inserted'
2391: );
2392:

Line 2448: FND_LOG.STRING(

2444: AND process_status = 2;
2445:
2446: IF (l_sLog AND l_pLog) THEN
2447: l_num_records := SQL%ROWCOUNT;
2448: FND_LOG.STRING(
2449: FND_LOG.LEVEL_PROCEDURE,
2450: l_module || '.query(' || l_stmt_num || ')',
2451: l_num_records || ' Rows inserted'
2452: );

Line 2449: FND_LOG.LEVEL_PROCEDURE,

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

Line 2468: FND_LOG.STRING(

2464: WHERE t.transaction_id = e.transaction_id);
2465:
2466: IF (l_sLog AND l_pLog) THEN
2467: l_num_records := SQL%ROWCOUNT;
2468: FND_LOG.STRING(
2469: FND_LOG.LEVEL_PROCEDURE,
2470: l_module || '.query(' || l_stmt_num || ')',
2471: l_num_records || ' Rows deleted'
2472: );

Line 2469: FND_LOG.LEVEL_PROCEDURE,

2465:
2466: IF (l_sLog AND l_pLog) THEN
2467: l_num_records := SQL%ROWCOUNT;
2468: FND_LOG.STRING(
2469: FND_LOG.LEVEL_PROCEDURE,
2470: l_module || '.query(' || l_stmt_num || ')',
2471: l_num_records || ' Rows deleted'
2472: );
2473:

Line 2478: FND_LOG.STRING(

2474: END IF;
2475:
2476: l_stmt_num := 100;
2477: IF (l_pLog) THEN
2478: FND_LOG.STRING(
2479: FND_LOG.LEVEL_PROCEDURE,
2480: l_module || '.end',
2481: '<< ' || l_api_name || ': Out Parameters:' ||
2482: ', x_return_status ' || x_return_status

Line 2479: FND_LOG.LEVEL_PROCEDURE,

2475:
2476: l_stmt_num := 100;
2477: IF (l_pLog) THEN
2478: FND_LOG.STRING(
2479: FND_LOG.LEVEL_PROCEDURE,
2480: l_module || '.end',
2481: '<< ' || l_api_name || ': Out Parameters:' ||
2482: ', x_return_status ' || x_return_status
2483: );

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

2487:
2488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2489: x_return_status := FND_API.g_ret_sts_error;
2490: IF (l_uLog) THEN
2491: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2492: END IF;
2493:
2494: WHEN FND_API.G_EXC_ERROR THEN
2495: x_return_status := FND_API.g_ret_sts_error;

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

2493:
2494: WHEN FND_API.G_EXC_ERROR THEN
2495: x_return_status := FND_API.g_ret_sts_error;
2496: IF (l_exceptionLog) THEN
2497: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2498: END IF;
2499:
2500: WHEN OTHERS THEN
2501: x_return_status := FND_API.g_ret_sts_error;

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

2503: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2504: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2505: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2506: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2507: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2508: FND_MSG_PUB.ADD;
2509:
2510: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2511: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

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

2508: FND_MSG_PUB.ADD;
2509:
2510: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2511: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2512: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2513: FND_MSG_PUB.ADD;
2514:
2515: END IF;
2516:

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

2562: l_api_version CONSTANT NUMBER := 1.0;
2563: l_return_status VARCHAR2(1);
2564: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
2565:
2566: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2567: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2568: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2569: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2570: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

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

2563: l_return_status VARCHAR2(1);
2564: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
2565:
2566: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2567: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2568: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2569: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2570: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2571: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

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

2564: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
2565:
2566: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2567: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2568: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2569: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2570: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2571: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2572:

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

2565:
2566: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2567: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2568: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2569: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2570: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2571: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2572:
2573: l_stmt_num NUMBER;

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

2566: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2567: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2568: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2569: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2570: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2571: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2572:
2573: l_stmt_num NUMBER;
2574: l_num_records NUMBER;

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

2567: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2568: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2569: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
2570: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2571: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2572:
2573: l_stmt_num NUMBER;
2574: l_num_records NUMBER;
2575: l_msg_data VARCHAR2(240);

Line 2585: FND_LOG.STRING(

2581: l_stmt_num := 0;
2582:
2583: /* Procedure level log message for Entry point */
2584: IF (l_pLog) THEN
2585: FND_LOG.STRING(
2586: FND_LOG.LEVEL_PROCEDURE,
2587: l_module || '.begin',
2588: '>> ' || l_api_name || ': Parameters:' ||
2589: ' Api version ' || p_api_version ||

Line 2586: FND_LOG.LEVEL_PROCEDURE,

2582:
2583: /* Procedure level log message for Entry point */
2584: IF (l_pLog) THEN
2585: FND_LOG.STRING(
2586: FND_LOG.LEVEL_PROCEDURE,
2587: l_module || '.begin',
2588: '>> ' || l_api_name || ': Parameters:' ||
2589: ' Api version ' || p_api_version ||
2590: ', Init msg list ' || p_init_msg_list ||

Line 2767: FND_LOG.STRING(

2763: AND msi.organization_id (+) = clai.organization_id;
2764:
2765: IF (l_sLog AND l_pLog) THEN
2766: l_num_records := SQL%ROWCOUNT;
2767: FND_LOG.STRING(
2768: FND_LOG.LEVEL_PROCEDURE,
2769: l_module || '.query(' || l_stmt_num || ')',
2770: l_num_records || ' Rows inserted'
2771: );

Line 2768: FND_LOG.LEVEL_PROCEDURE,

2764:
2765: IF (l_sLog AND l_pLog) THEN
2766: l_num_records := SQL%ROWCOUNT;
2767: FND_LOG.STRING(
2768: FND_LOG.LEVEL_PROCEDURE,
2769: l_module || '.query(' || l_stmt_num || ')',
2770: l_num_records || ' Rows inserted'
2771: );
2772:

Line 2800: FND_LOG.STRING(

2796: and gps.closing_status <> 'O';
2797:
2798: IF (l_sLog AND l_pLog) THEN
2799: l_num_records := SQL%ROWCOUNT;
2800: FND_LOG.STRING(
2801: FND_LOG.LEVEL_PROCEDURE,
2802: l_module || '.query(' || l_stmt_num || ')',
2803: l_num_records || ' Rows inserted'
2804: );

Line 2801: FND_LOG.LEVEL_PROCEDURE,

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

Line 2823: FND_LOG.STRING(

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

Line 2824: FND_LOG.LEVEL_PROCEDURE,

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

Line 2843: FND_LOG.STRING(

2839: AND process_status = 1;
2840:
2841: IF (l_sLog AND l_pLog) THEN
2842: l_num_records := SQL%ROWCOUNT;
2843: FND_LOG.STRING(
2844: FND_LOG.LEVEL_PROCEDURE,
2845: l_module || '.query(' || l_stmt_num || ')',
2846: l_num_records || ' Rows updated'
2847: );

Line 2844: FND_LOG.LEVEL_PROCEDURE,

2840:
2841: IF (l_sLog AND l_pLog) THEN
2842: l_num_records := SQL%ROWCOUNT;
2843: FND_LOG.STRING(
2844: FND_LOG.LEVEL_PROCEDURE,
2845: l_module || '.query(' || l_stmt_num || ')',
2846: l_num_records || ' Rows updated'
2847: );
2848:

Line 2854: FND_LOG.STRING(

2850:
2851: l_stmt_num := 50;
2852: IF (
2853: l_pLog) THEN
2854: FND_LOG.STRING(
2855: FND_LOG.LEVEL_PROCEDURE,
2856: l_module || '.end',
2857: '<< ' || l_api_name || ': Out Parameters:' ||
2858: ' x_no_of_errored ' || x_no_of_errored ||

Line 2855: FND_LOG.LEVEL_PROCEDURE,

2851: l_stmt_num := 50;
2852: IF (
2853: l_pLog) THEN
2854: FND_LOG.STRING(
2855: FND_LOG.LEVEL_PROCEDURE,
2856: l_module || '.end',
2857: '<< ' || l_api_name || ': Out Parameters:' ||
2858: ' x_no_of_errored ' || x_no_of_errored ||
2859: ', x_return_status ' || x_return_status

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

2864:
2865: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2866: x_return_status := FND_API.g_ret_sts_error;
2867: IF (l_uLog) THEN
2868: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2869: END IF;
2870:
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.g_ret_sts_error;

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

2870:
2871: WHEN FND_API.G_EXC_ERROR THEN
2872: x_return_status := FND_API.g_ret_sts_error;
2873: IF (l_exceptionLog) THEN
2874: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2875: END IF;
2876:
2877: WHEN OTHERS THEN
2878: x_return_status := FND_API.g_ret_sts_error;

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

2880: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2881: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2882: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2883: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2885: FND_MSG_PUB.ADD;
2886:
2887: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2888: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);

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

2885: FND_MSG_PUB.ADD;
2886:
2887: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
2888: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
2889: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2890: FND_MSG_PUB.ADD;
2891:
2892: END IF;
2893: