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

Line 69: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

65: --=================
66:
67: BEGIN
68:
69: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
70: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
71: ,G_MODULE_HEAD || l_routine || '.begin'
72: ,l_routine || '<'
73: );

Line 70: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

66:
67: BEGIN
68:
69: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
70: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
71: ,G_MODULE_HEAD || l_routine || '.begin'
72: ,l_routine || '<'
73: );
74: END IF;

Line 96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

92: -- a complete rollback if the process errors out
93:
94: COMMIT;
95:
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
98: ,G_MODULE_HEAD || l_routine || '.end'
99: ,l_routine || '>'
100: );

Line 97: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

93:
94: COMMIT;
95:
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
98: ,G_MODULE_HEAD || l_routine || '.end'
99: ,l_routine || '>'
100: );
101: END IF;

Line 136: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

132: l_error_msg VARCHAR2(2000);
133:
134: BEGIN
135:
136: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
138: ,G_MODULE_HEAD || l_routine || '.begin'
139: ,l_routine || '<'
140: );

Line 137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

133:
134: BEGIN
135:
136: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
138: ,G_MODULE_HEAD || l_routine || '.begin'
139: ,l_routine || '<'
140: );
141: END IF;

Line 213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

209: ,p_prg_appid => p_prg_appid);
210:
211: END IF;
212:
213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
215: ,G_MODULE_HEAD || l_routine || '.end'
216: ,l_routine || '>'
217: );

Line 214: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

210:
211: END IF;
212:
213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
214: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
215: ,G_MODULE_HEAD || l_routine || '.end'
216: ,l_routine || '>'
217: );
218: END IF;

Line 250: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

246: l_error_msg VARCHAR2(240);
247:
248: BEGIN
249:
250: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
252: ,G_MODULE_HEAD || l_routine || '.begin'
253: ,l_routine || '<'
254: );

Line 251: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

247:
248: BEGIN
249:
250: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
251: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
252: ,G_MODULE_HEAD || l_routine || '.begin'
253: ,l_routine || '<'
254: );
255: END IF;

Line 302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

298: ,p_req_id => p_req_id
299: ,p_prg_id => p_prg_id
300: ,p_prg_appid => p_prg_appid);
301:
302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
304: ,G_MODULE_HEAD || l_routine || '.paclowcode'
305: ,l_error_msg
306: );

Line 303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

299: ,p_prg_id => p_prg_id
300: ,p_prg_appid => p_prg_appid);
301:
302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
304: ,G_MODULE_HEAD || l_routine || '.paclowcode'
305: ,l_error_msg
306: );
307: END IF;

Line 331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

327: ,p_prg_appid => p_prg_appid);
328:
329: END IF;
330:
331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
333: ,G_MODULE_HEAD || l_routine || '.end'
334: ,l_routine || '>'
335: );

Line 332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

328:
329: END IF;
330:
331: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
333: ,G_MODULE_HEAD || l_routine || '.end'
334: ,l_routine || '>'
335: );
336: END IF;

Line 375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

371: l_error_msg VARCHAR2(240);
372:
373: BEGIN
374:
375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
377: ,G_MODULE_HEAD || l_routine || '.begin'
378: ,l_routine || '<'
379: );

Line 376: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

372:
373: BEGIN
374:
375: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
377: ,G_MODULE_HEAD || l_routine || '.begin'
378: ,l_routine || '<'
379: );
380: END IF;

Line 491: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

487: ,p_prg_appid => p_prg_appid);
488:
489: END IF;
490:
491: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
493: ,G_MODULE_HEAD || l_routine || '.end'
494: ,l_routine || '>'
495: );

Line 492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

488:
489: END IF;
490:
491: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
493: ,G_MODULE_HEAD || l_routine || '.end'
494: ,l_routine || '>'
495: );
496: END IF;

Line 533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

529: l_error_msg VARCHAR2(240);
530:
531: BEGIN
532:
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
535: ,G_MODULE_HEAD || l_routine || '.begin'
536: ,l_routine || '<'
537: );

Line 534: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

530:
531: BEGIN
532:
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
535: ,G_MODULE_HEAD || l_routine || '.begin'
536: ,l_routine || '<'
537: );
538: END IF;

Line 652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

648: ,p_prg_appid => p_prg_appid);
649:
650: END IF;
651:
652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
653: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
654: ,G_MODULE_HEAD || l_routine || '.end'
655: ,l_routine || '>'
656: );

Line 653: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

649:
650: END IF;
651:
652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
653: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
654: ,G_MODULE_HEAD || l_routine || '.end'
655: ,l_routine || '>'
656: );
657: END IF;

Line 699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

695: DELETE MTL_PAC_ACT_CST_DTL_TEMP
696: WHERE pac_period_id = p_period_id
697: AND cost_group_id = p_cost_group_id;
698:
699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.string(FND_LOG.LEVEL_EVENT
701: , G_MODULE_HEAD || l_routine || '.Before_retrieve_items'
702: , 'Before Retrieve interorg items'
703: );

Line 700: FND_LOG.string(FND_LOG.LEVEL_EVENT

696: WHERE pac_period_id = p_period_id
697: AND cost_group_id = p_cost_group_id;
698:
699: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
700: FND_LOG.string(FND_LOG.LEVEL_EVENT
701: , G_MODULE_HEAD || l_routine || '.Before_retrieve_items'
702: , 'Before Retrieve interorg items'
703: );
704: END IF;

Line 836: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

832: l_txn_category NUMBER;
833:
834: BEGIN
835:
836: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
838: ,G_MODULE_HEAD || l_routine || '.begin'
839: ,l_routine || '<'
840: );

Line 837: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

833:
834: BEGIN
835:
836: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
838: ,G_MODULE_HEAD || l_routine || '.begin'
839: ,l_routine || '<'
840: );
841: END IF;

Line 909: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

905: l_error_msg := NVL(l_error_msg, 'No Error');
906:
907: IF l_error_num <> 0
908: THEN
909: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
911: , G_MODULE_HEAD || l_routine || '.others'
912: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
913: ||l_upd_val_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg

Line 910: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

906:
907: IF l_error_num <> 0
908: THEN
909: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
911: , G_MODULE_HEAD || l_routine || '.others'
912: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
913: ||l_upd_val_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
914: );

Line 968: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

964: l_error_num := NVL(l_error_num, 0);
965: l_error_code := NVL(l_error_code, 'No Error');
966: l_error_msg := NVL(l_error_msg, 'No Error');
967:
968: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
969: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
970: ,G_MODULE_HEAD || l_routine || '.inscppb5'
971: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
972: );

Line 969: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

965: l_error_code := NVL(l_error_code, 'No Error');
966: l_error_msg := NVL(l_error_msg, 'No Error');
967:
968: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
969: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
970: ,G_MODULE_HEAD || l_routine || '.inscppb5'
971: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
972: );
973: END IF;

Line 1015: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1011: l_error_msg := NVL(l_error_msg, 'No Error');
1012:
1013: IF l_error_num <> 0
1014: THEN
1015: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1016: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1017: , G_MODULE_HEAD || l_routine || '.others'
1018: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
1019: ||l_upd_val_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg

Line 1016: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

1012:
1013: IF l_error_num <> 0
1014: THEN
1015: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1016: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1017: , G_MODULE_HEAD || l_routine || '.others'
1018: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
1019: ||l_upd_val_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
1020: );

Line 1053: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1049: l_error_num := NVL(l_error_num, 0);
1050: l_error_code := NVL(l_error_code, 'No Error');
1051: l_error_msg := NVL(l_error_msg, 'No Error');
1052:
1053: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1055: ,G_MODULE_HEAD || l_routine || '.inscppb'
1056: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
1057: );

Line 1054: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1050: l_error_code := NVL(l_error_code, 'No Error');
1051: l_error_msg := NVL(l_error_msg, 'No Error');
1052:
1053: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1055: ,G_MODULE_HEAD || l_routine || '.inscppb'
1056: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
1057: );
1058: END IF;

Line 1081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1077: l_error_num := NVL(l_error_num, 0);
1078: l_error_code := NVL(l_error_code, 'No Error');
1079: l_error_msg := NVL(l_error_msg, 'No Error');
1080:
1081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1083: ,G_MODULE_HEAD || l_routine || '.updcppb3'
1084: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
1085: );

Line 1082: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1078: l_error_code := NVL(l_error_code, 'No Error');
1079: l_error_msg := NVL(l_error_msg, 'No Error');
1080:
1081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1082: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1083: ,G_MODULE_HEAD || l_routine || '.updcppb3'
1084: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
1085: );
1086: END IF;

Line 1092: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1088: END IF;
1089:
1090: IF l_error_num <> 0
1091: THEN
1092: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1094: , G_MODULE_HEAD || l_routine || '.others'
1095: , 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg
1096: );

Line 1093: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

1089:
1090: IF l_error_num <> 0
1091: THEN
1092: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1093: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1094: , G_MODULE_HEAD || l_routine || '.others'
1095: , 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg
1096: );
1097: END IF;

Line 1106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1102: FND_MSG_PUB.Add;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1108: ,G_MODULE_HEAD || l_routine || '.end'
1109: ,l_routine || '>'
1110: );

Line 1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1107: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1108: ,G_MODULE_HEAD || l_routine || '.end'
1109: ,l_routine || '>'
1110: );
1111: END IF;

Line 1377: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1373: l_loop_count NUMBER := 0;
1374:
1375: BEGIN
1376:
1377: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1378: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1379: ,G_MODULE_HEAD || l_routine || '.begin'
1380: ,l_routine || '<'
1381: );

Line 1378: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1374:
1375: BEGIN
1376:
1377: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1378: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1379: ,G_MODULE_HEAD || l_routine || '.begin'
1380: ,l_routine || '<'
1381: );
1382: END IF;

Line 1384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1380: ,l_routine || '<'
1381: );
1382: END IF;
1383:
1384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1386: ,G_MODULE_HEAD || l_routine || 'Daterange'
1387: ,'Start Date:' || p_start_date || ' End Date:' ||
1388: p_end_date

Line 1385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1381: );
1382: END IF;
1383:
1384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1386: ,G_MODULE_HEAD || l_routine || 'Daterange'
1387: ,'Start Date:' || p_start_date || ' End Date:' ||
1388: p_end_date
1389: );

Line 1419: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1415: ,p_subinventory_code => l_cst_own_txns_tab(i).subinventory_code
1416: ,x_exp_flag => l_exp_flag
1417: ,x_exp_item => l_exp_item);
1418:
1419: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1421: ,G_MODULE_HEAD || l_routine || '.befcostinvtxn'
1422: ,'Before calling cost_inv_txn: Cost Group Id:' ||
1423: p_cost_group_id || ' Txn Id:' || l_cst_own_txns_tab(i).transaction_id

Line 1420: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1416: ,x_exp_flag => l_exp_flag
1417: ,x_exp_item => l_exp_item);
1418:
1419: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1421: ,G_MODULE_HEAD || l_routine || '.befcostinvtxn'
1422: ,'Before calling cost_inv_txn: Cost Group Id:' ||
1423: p_cost_group_id || ' Txn Id:' || l_cst_own_txns_tab(i).transaction_id
1424: );

Line 1447: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1443: l_error_num := NVL(l_error_num, 0);
1444: l_error_code := NVL(l_error_code, 'No Error');
1445: l_error_msg := NVL(l_error_msg, 'No Error');
1446:
1447: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1449: ,G_MODULE_HEAD || l_routine || '.inscppb'
1450: ,'After calling insert_into_cppb1:'|| l_error_num || l_error_code || l_error_msg
1451: );

Line 1448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1444: l_error_code := NVL(l_error_code, 'No Error');
1445: l_error_msg := NVL(l_error_msg, 'No Error');
1446:
1447: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1449: ,G_MODULE_HEAD || l_routine || '.inscppb'
1450: ,'After calling insert_into_cppb1:'|| l_error_num || l_error_code || l_error_msg
1451: );
1452: END IF;

Line 1487: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1483: ,o_err_num => l_error_num
1484: ,o_err_code => l_error_code
1485: ,o_err_msg => l_error_msg);
1486:
1487: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1489: ,G_MODULE_HEAD || l_routine || '.befcostinvtxn'
1490: ,'After calling cost_inv_txn:'|| l_error_num || l_error_code || l_error_msg
1491: );

Line 1488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1484: ,o_err_code => l_error_code
1485: ,o_err_msg => l_error_msg);
1486:
1487: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1489: ,G_MODULE_HEAD || l_routine || '.befcostinvtxn'
1490: ,'After calling cost_inv_txn:'|| l_error_num || l_error_code || l_error_msg
1491: );
1492: END IF;

Line 1502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1498: l_error_msg := NVL(l_error_msg, 'No Error');
1499:
1500: IF l_error_num <> 0
1501: THEN
1502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1504: , G_MODULE_HEAD || l_routine || '.others'
1505: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
1506: ||l_cst_own_txns_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg

Line 1503: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

1499:
1500: IF l_error_num <> 0
1501: THEN
1502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1504: , G_MODULE_HEAD || l_routine || '.others'
1505: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
1506: ||l_cst_own_txns_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
1507: );

Line 1544: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1540: l_error_num := NVL(l_error_num, 0);
1541: l_error_code := NVL(l_error_code, 'No Error');
1542: l_error_msg := NVL(l_error_msg, 'No Error');
1543:
1544: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1545: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1546: ,G_MODULE_HEAD || l_routine || '.inscppb2'
1547: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
1548: );

Line 1545: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1541: l_error_code := NVL(l_error_code, 'No Error');
1542: l_error_msg := NVL(l_error_msg, 'No Error');
1543:
1544: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1545: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1546: ,G_MODULE_HEAD || l_routine || '.inscppb2'
1547: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
1548: );
1549: END IF;

Line 1572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1568: l_error_num := NVL(l_error_num, 0);
1569: l_error_code := NVL(l_error_code, 'No Error');
1570: l_error_msg := NVL(l_error_msg, 'No Error');
1571:
1572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1574: ,G_MODULE_HEAD || l_routine || '.updcppb1'
1575: ,'After calling update_cppb:'|| l_error_num || l_error_code || l_error_msg
1576: );

Line 1573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1569: l_error_code := NVL(l_error_code, 'No Error');
1570: l_error_msg := NVL(l_error_msg, 'No Error');
1571:
1572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1573: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1574: ,G_MODULE_HEAD || l_routine || '.updcppb1'
1575: ,'After calling update_cppb:'|| l_error_num || l_error_code || l_error_msg
1576: );
1577: END IF;

Line 1591: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1587: RAISE FND_API.G_EXC_ERROR;
1588: END IF;
1589:
1590:
1591: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1593: ,G_MODULE_HEAD || l_routine || '.end'
1594: ,l_routine || '>'
1595: );

Line 1592: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1588: END IF;
1589:
1590:
1591: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1592: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1593: ,G_MODULE_HEAD || l_routine || '.end'
1594: ,l_routine || '>'
1595: );
1596: END IF;

Line 1712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1708: l_login_id NUMBER;
1709:
1710: BEGIN
1711:
1712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1713: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1714: ,G_MODULE_HEAD || l_routine || '.begin'
1715: ,l_routine || '<'
1716: );

Line 1713: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1709:
1710: BEGIN
1711:
1712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1713: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1714: ,G_MODULE_HEAD || l_routine || '.begin'
1715: ,l_routine || '<'
1716: );
1717: END IF;

Line 1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1844: , p_req_id => l_req_id
1845: , p_prg_id => l_prg_id
1846: , p_prg_appid => l_prg_appid);
1847:
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1850: ,G_MODULE_HEAD || l_routine || '.end'
1851: ,l_routine || '>'
1852: );

Line 1849: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1845: , p_prg_id => l_prg_id
1846: , p_prg_appid => l_prg_appid);
1847:
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1850: ,G_MODULE_HEAD || l_routine || '.end'
1851: ,l_routine || '>'
1852: );
1853: END IF;

Line 1888: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1884: x_errbuf := substrb(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE)
1885: ,1
1886: ,250);
1887:
1888: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1889: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1890: , G_MODULE_HEAD || l_routine , x_errbuf
1891: );
1892: END IF;

Line 1889: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

1885: ,1
1886: ,250);
1887:
1888: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1889: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1890: , G_MODULE_HEAD || l_routine , x_errbuf
1891: );
1892: END IF;
1893:

Line 1928: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1924: ( FND_FILE.log
1925: , 'Error in begin_cp_worker '|| x_errbuf
1926: );
1927:
1928: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1929: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1930: , G_MODULE_HEAD || l_routine ||'.others_exc'
1931: , 'others:' || x_errbuf
1932: );

Line 1929: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

1925: , 'Error in begin_cp_worker '|| x_errbuf
1926: );
1927:
1928: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1929: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1930: , G_MODULE_HEAD || l_routine ||'.others_exc'
1931: , 'others:' || x_errbuf
1932: );
1933: END IF;