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

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

81: l_exp_flag NUMBER;
82: l_exp_item NUMBER;
83: BEGIN
84:
85: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
86: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
87: ,G_MODULE_HEAD || l_routine || '.begin'
88: ,l_routine || '<'
89: );

Line 86: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

82: l_exp_item NUMBER;
83: BEGIN
84:
85: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
86: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
87: ,G_MODULE_HEAD || l_routine || '.begin'
88: ,l_routine || '<'
89: );
90: END IF;

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

123: g_loop_flag := 0;
124: x_exp_item := l_exp_item;
125: x_exp_flag := l_exp_flag;
126:
127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
129: ,G_MODULE_HEAD || l_routine || '.end'
130: ,l_routine || '>'
131: );

Line 128: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

124: x_exp_item := l_exp_item;
125: x_exp_flag := l_exp_flag;
126:
127: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
129: ,G_MODULE_HEAD || l_routine || '.end'
130: ,l_routine || '>'
131: );
132: END IF;

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

212: l_routine CONSTANT VARCHAR2(30) := 'get_phase_status';
213:
214: BEGIN
215:
216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
218: ,G_MODULE_HEAD || l_routine || '.begin'
219: ,l_routine || '<'
220: );

Line 217: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

213:
214: BEGIN
215:
216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
218: ,G_MODULE_HEAD || l_routine || '.begin'
219: ,l_routine || '<'
220: );
221: END IF;

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

239: AND process_phase = p_phase
240: AND cost_group_id = p_cost_group_id;
241: END IF;
242:
243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
245: ,G_MODULE_HEAD || l_routine || '.end'
246: ,l_routine || '>'
247: );

Line 244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

240: AND cost_group_id = p_cost_group_id;
241: END IF;
242:
243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
244: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
245: ,G_MODULE_HEAD || l_routine || '.end'
246: ,l_routine || '>'
247: );
248: END IF;

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

289: x_process_upto_date DATE;
290:
291: BEGIN
292:
293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
294: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
295: ,G_MODULE_HEAD || l_routine || '.begin'
296: ,l_routine || '<'
297: );

Line 294: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

290:
291: BEGIN
292:
293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
294: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
295: ,G_MODULE_HEAD || l_routine || '.begin'
296: ,l_routine || '<'
297: );
298: END IF;

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

308: TRUNC(FND_DATE.canonical_to_date(l_process_upto_date)) + (86399/86400);
309:
310: RETURN x_process_upto_date;
311:
312: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
314: ,G_MODULE_HEAD || l_routine || '.end'
315: ,l_routine || '>'
316: );

Line 313: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

309:
310: RETURN x_process_upto_date;
311:
312: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
314: ,G_MODULE_HEAD || l_routine || '.end'
315: ,l_routine || '>'
316: );
317: END IF;

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

357:
358: BEGIN
359:
360:
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
363: ,G_MODULE_HEAD || l_routine || '.begin'
364: ,l_routine || '<'
365: );

Line 362: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

358: BEGIN
359:
360:
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
363: ,G_MODULE_HEAD || l_routine || '.begin'
364: ,l_routine || '<'
365: );
366: END IF;

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

395: l_error_msg := NVL(l_error_msg, 'No Error');
396:
397: IF l_error_num <> 0
398: THEN
399: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
401: , G_MODULE_HEAD || l_routine || '.others'
402: , 'process_nonreworkassembly_txns for cost group '||p_cost_group_id||' item id '
403: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg

Line 400: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

396:
397: IF l_error_num <> 0
398: THEN
399: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
401: , G_MODULE_HEAD || l_routine || '.others'
402: , 'process_nonreworkassembly_txns for cost group '||p_cost_group_id||' item id '
403: ||p_inventory_item_id||' ('||l_error_code||') '||l_error_msg
404: );

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

413:
414: END IF;
415:
416:
417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
419: ,G_MODULE_HEAD || l_routine || '.end'
420: ,l_routine || '>'
421: );

Line 418: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

414: END IF;
415:
416:
417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
419: ,G_MODULE_HEAD || l_routine || '.end'
420: ,l_routine || '>'
421: );
422: END IF;

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

464:
465: BEGIN
466:
467:
468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
470: ,G_MODULE_HEAD || l_routine || '.begin'
471: ,l_routine || '<'
472: );

Line 469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

465: BEGIN
466:
467:
468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
470: ,G_MODULE_HEAD || l_routine || '.begin'
471: ,l_routine || '<'
472: );
473: END IF;

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

512:
513: END IF;
514:
515:
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
518: ,G_MODULE_HEAD || l_routine || '.end'
519: ,l_routine || '>'
520: );

Line 517: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

513: END IF;
514:
515:
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
518: ,G_MODULE_HEAD || l_routine || '.end'
519: ,l_routine || '>'
520: );
521: END IF;

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

602: l_loop_count NUMBER := 0;
603:
604: BEGIN
605:
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
608: ,G_MODULE_HEAD || l_routine || '.begin'
609: ,l_routine || '<'
610: );

Line 607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

603:
604: BEGIN
605:
606: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
607: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
608: ,G_MODULE_HEAD || l_routine || '.begin'
609: ,l_routine || '<'
610: );
611: END IF;

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

649: l_error_num := NVL(l_error_num, 0);
650: l_error_code := NVL(l_error_code, 'No Error');
651: l_error_msg := NVL(l_error_msg, 'No Error');
652:
653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
655: ,G_MODULE_HEAD || l_routine || '.inscppb5'
656: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
657: );

Line 654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

650: l_error_code := NVL(l_error_code, 'No Error');
651: l_error_msg := NVL(l_error_msg, 'No Error');
652:
653: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
655: ,G_MODULE_HEAD || l_routine || '.inscppb5'
656: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
657: );
658: END IF;

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

697:
698: END IF; -- error number check
699:
700: IF l_error_num <> 0 THEN
701: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
703: , G_MODULE_HEAD || l_routine || '.others'
704: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
705: ||l_upd_val_txn_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg

Line 702: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

698: END IF; -- error number check
699:
700: IF l_error_num <> 0 THEN
701: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
703: , G_MODULE_HEAD || l_routine || '.others'
704: , 'cost_inv_txn for cost group '||p_cost_group_id||' txn id '
705: ||l_upd_val_txn_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
706: );

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

741: l_error_num := NVL(l_error_num, 0);
742: l_error_code := NVL(l_error_code, 'No Error');
743: l_error_msg := NVL(l_error_msg, 'No Error');
744:
745: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
746: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
747: ,G_MODULE_HEAD || l_routine || '.inscppb6'
748: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
749: );

Line 746: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

742: l_error_code := NVL(l_error_code, 'No Error');
743: l_error_msg := NVL(l_error_msg, 'No Error');
744:
745: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
746: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
747: ,G_MODULE_HEAD || l_routine || '.inscppb6'
748: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
749: );
750: END IF;

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

790: l_error_num := NVL(l_error_num, 0);
791: l_error_code := NVL(l_error_code, 'No Error');
792: l_error_msg := NVL(l_error_msg, 'No Error');
793:
794: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
796: ,G_MODULE_HEAD || l_routine || '.updcppb3'
797: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
798: );

Line 795: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

791: l_error_code := NVL(l_error_code, 'No Error');
792: l_error_msg := NVL(l_error_msg, 'No Error');
793:
794: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
796: ,G_MODULE_HEAD || l_routine || '.updcppb3'
797: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
798: );
799: END IF;

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

801: END IF;
802:
803: IF l_error_num <> 0
804: THEN
805: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
807: , G_MODULE_HEAD || l_routine || '.others'
808: , 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg
809: );

Line 806: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

802:
803: IF l_error_num <> 0
804: THEN
805: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
807: , G_MODULE_HEAD || l_routine || '.others'
808: , 'Error for cost group '||p_cost_group_id||' ('||l_error_code||') '||l_error_msg
809: );
810: END IF;

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

816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
818:
819:
820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
822: ,G_MODULE_HEAD || l_routine || '.end'
823: ,l_routine || '>'
824: );

Line 821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

817: END IF;
818:
819:
820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
822: ,G_MODULE_HEAD || l_routine || '.end'
823: ,l_routine || '>'
824: );
825: END IF;

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

867: l_count NUMBER;
868:
869: BEGIN
870:
871: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
873: ,G_MODULE_HEAD || l_routine || '.begin'
874: ,l_routine || '<'
875: );

Line 872: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

868:
869: BEGIN
870:
871: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
873: ,G_MODULE_HEAD || l_routine || '.begin'
874: ,l_routine || '<'
875: );
876: END IF;

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

955: RAISE FND_API.G_EXC_ERROR;
956:
957: END IF;
958:
959: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
961: ,G_MODULE_HEAD || l_routine || '.end'
962: ,l_routine || '>'
963: );

Line 960: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

956:
957: END IF;
958:
959: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
961: ,G_MODULE_HEAD || l_routine || '.end'
962: ,l_routine || '>'
963: );
964: END IF;

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

981: l_uom_control NUMBER;
982:
983: BEGIN
984:
985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
986: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
987: ,G_MODULE_HEAD || l_routine || '.begin'
988: ,l_routine || '<'
989: );

Line 986: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

982:
983: BEGIN
984:
985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
986: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
987: ,G_MODULE_HEAD || l_routine || '.begin'
988: ,l_routine || '<'
989: );
990: END IF;

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

995: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.PRIMARY_UNIT_OF_MEASURE';
996:
997: RETURN l_uom_control;
998:
999: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: ,G_MODULE_HEAD || l_routine || '.end'
1002: ,l_routine || '>'
1003: );

Line 1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

996:
997: RETURN l_uom_control;
998:
999: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1001: ,G_MODULE_HEAD || l_routine || '.end'
1002: ,l_routine || '>'
1003: );
1004: END IF;

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

1027: l_message VARCHAR2(250);
1028:
1029: BEGIN
1030:
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1033: ,G_MODULE_HEAD || l_routine || '.begin'
1034: ,l_routine || '<'
1035: );

Line 1032: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1028:
1029: BEGIN
1030:
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1033: ,G_MODULE_HEAD || l_routine || '.begin'
1034: ,l_routine || '<'
1035: );
1036: END IF;

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

1074: FND_MSG_PUB.Add;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:
1078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1080: ,G_MODULE_HEAD || l_routine || '.end'
1081: ,l_routine || '>'
1082: );

Line 1079: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:
1078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1080: ,G_MODULE_HEAD || l_routine || '.end'
1081: ,l_routine || '>'
1082: );
1083: END IF;

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

1108: l_mat_relief_algorithm NUMBER;
1109:
1110: BEGIN
1111:
1112: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1113: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1114: ,G_MODULE_HEAD || l_routine || '.begin'
1115: ,l_routine || '<'
1116: );

Line 1113: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1109:
1110: BEGIN
1111:
1112: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1113: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1114: ,G_MODULE_HEAD || l_routine || '.begin'
1115: ,l_routine || '<'
1116: );
1117: END IF;

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

1127:
1128: x_pac_rates_id := l_pac_rates_id;
1129: x_mat_relief_algorithm := l_mat_relief_algorithm;
1130:
1131: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1133: ,G_MODULE_HEAD || l_routine || '.end'
1134: ,l_routine || '>'
1135: );

Line 1132: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1128: x_pac_rates_id := l_pac_rates_id;
1129: x_mat_relief_algorithm := l_mat_relief_algorithm;
1130:
1131: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1133: ,G_MODULE_HEAD || l_routine || '.end'
1134: ,l_routine || '>'
1135: );
1136: END IF;

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

1158: l_process_upto_date DATE;
1159:
1160: BEGIN
1161:
1162: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1164: ,G_MODULE_HEAD || l_routine || '.begin'
1165: ,l_routine || '<'
1166: );

Line 1163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1159:
1160: BEGIN
1161:
1162: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1164: ,G_MODULE_HEAD || l_routine || '.begin'
1165: ,l_routine || '<'
1166: );
1167: END IF;

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

1202: RAISE FND_API.G_EXC_ERROR;
1203: END IF;
1204: END IF; -- run options check
1205:
1206: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1207: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1208: ,G_MODULE_HEAD || l_routine || '.end'
1209: ,l_routine || '>'
1210: );

Line 1207: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1203: END IF;
1204: END IF; -- run options check
1205:
1206: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1207: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1208: ,G_MODULE_HEAD || l_routine || '.end'
1209: ,l_routine || '>'
1210: );
1211: END IF;

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

1235: l_num_of_assignments NUMBER;
1236:
1237: BEGIN
1238:
1239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1241: ,G_MODULE_HEAD || l_routine || '.begin'
1242: ,l_routine || '<'
1243: );

Line 1240: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1236:
1237: BEGIN
1238:
1239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1241: ,G_MODULE_HEAD || l_routine || '.begin'
1242: ,l_routine || '<'
1243: );
1244: END IF;

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

1269:
1270: */
1271: END IF;
1272:
1273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1275: ,G_MODULE_HEAD || l_routine || '.end'
1276: ,l_routine || '>'
1277: );

Line 1274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1270: */
1271: END IF;
1272:
1273: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1274: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1275: ,G_MODULE_HEAD || l_routine || '.end'
1276: ,l_routine || '>'
1277: );
1278: END IF;

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

1298: l_cost_method NUMBER;
1299:
1300: BEGIN
1301:
1302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1304: ,G_MODULE_HEAD || l_routine || '.begin'
1305: ,l_routine || '<'
1306: );

Line 1303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1299:
1300: BEGIN
1301:
1302: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1303: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1304: ,G_MODULE_HEAD || l_routine || '.begin'
1305: ,l_routine || '<'
1306: );
1307: END IF;

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

1313: AND clct.cost_type_id = p_cost_type_id;
1314:
1315: x_cost_method := l_cost_method;
1316:
1317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1319: ,G_MODULE_HEAD || l_routine || '.end'
1320: ,l_routine || '>'
1321: );

Line 1318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1314:
1315: x_cost_method := l_cost_method;
1316:
1317: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1319: ,G_MODULE_HEAD || l_routine || '.end'
1320: ,l_routine || '>'
1321: );
1322: END IF;

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

1344: l_count NUMBER;
1345: l_message VARCHAR2(250);
1346: BEGIN
1347:
1348: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1349: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1350: ,G_MODULE_HEAD || l_routine || '.begin'
1351: ,l_routine || '<'
1352: );

Line 1349: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1345: l_message VARCHAR2(250);
1346: BEGIN
1347:
1348: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1349: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1350: ,G_MODULE_HEAD || l_routine || '.begin'
1351: ,l_routine || '<'
1352: );
1353: END IF;

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

1375: FND_MSG_PUB.Add;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1380: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1381: ,G_MODULE_HEAD || l_routine || '.end'
1382: ,l_routine || '>'
1383: );

Line 1380: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1380: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1381: ,G_MODULE_HEAD || l_routine || '.end'
1382: ,l_routine || '>'
1383: );
1384: END IF;

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

1408: l_end_date VARCHAR2(30);
1409:
1410: BEGIN
1411:
1412: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1413: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1414: ,G_MODULE_HEAD || l_routine || '.begin'
1415: ,l_routine || '<'
1416: );

Line 1413: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1409:
1410: BEGIN
1411:
1412: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1413: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1414: ,G_MODULE_HEAD || l_routine || '.begin'
1415: ,l_routine || '<'
1416: );
1417: END IF;

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

1429:
1430: -- set to 23:59:59 to retrieve all the records
1431: x_end_date := TRUNC(FND_DATE.canonical_to_date(l_end_date)) + (86399/86400);
1432:
1433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1435: ,G_MODULE_HEAD || l_routine || '.end'
1436: ,l_routine || '>'
1437: );

Line 1434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1430: -- set to 23:59:59 to retrieve all the records
1431: x_end_date := TRUNC(FND_DATE.canonical_to_date(l_end_date)) + (86399/86400);
1432:
1433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1435: ,G_MODULE_HEAD || l_routine || '.end'
1436: ,l_routine || '>'
1437: );
1438: END IF;

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

1459: l_count NUMBER;
1460: l_message VARCHAR2(250);
1461: BEGIN
1462:
1463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1464: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1465: ,G_MODULE_HEAD || l_routine || '.begin'
1466: ,l_routine || '<'
1467: );

Line 1464: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1460: l_message VARCHAR2(250);
1461: BEGIN
1462:
1463: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1464: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1465: ,G_MODULE_HEAD || l_routine || '.begin'
1466: ,l_routine || '<'
1467: );
1468: END IF;

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

1483: FND_MSG_PUB.Add;
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486:
1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1489: ,G_MODULE_HEAD || l_routine || '.end'
1490: ,l_routine || '>'
1491: );

Line 1488: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486:
1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1489: ,G_MODULE_HEAD || l_routine || '.end'
1490: ,l_routine || '>'
1491: );
1492: END IF;

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

1516: l_period_complete NUMBER;
1517: l_message VARCHAR2(250);
1518: BEGIN
1519:
1520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1522: ,G_MODULE_HEAD || l_routine || '.begin'
1523: ,l_routine || '<'
1524: );

Line 1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1517: l_message VARCHAR2(250);
1518: BEGIN
1519:
1520: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1522: ,G_MODULE_HEAD || l_routine || '.begin'
1523: ,l_routine || '<'
1524: );
1525: END IF;

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

1554: END IF;
1555:
1556: END IF;
1557:
1558: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1560: ,G_MODULE_HEAD || l_routine || '.prevpd'
1561: ,'Previous Period Id:' || l_prev_period_id
1562: );

Line 1559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1555:
1556: END IF;
1557:
1558: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1560: ,G_MODULE_HEAD || l_routine || '.prevpd'
1561: ,'Previous Period Id:' || l_prev_period_id
1562: );
1563: END IF;

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

1563: END IF;
1564:
1565: x_prev_period_id := l_prev_period_id;
1566:
1567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1569: ,G_MODULE_HEAD || l_routine || '.end'
1570: ,l_routine || '>'
1571: );

Line 1568: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1564:
1565: x_prev_period_id := l_prev_period_id;
1566:
1567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1569: ,G_MODULE_HEAD || l_routine || '.end'
1570: ,l_routine || '>'
1571: );
1572: END IF;

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

1593: l_count NUMBER;
1594: l_message VARCHAR2(250);
1595: BEGIN
1596:
1597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1598: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1599: ,G_MODULE_HEAD || l_routine || '.begin'
1600: ,l_routine || '<'
1601: );

Line 1598: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1594: l_message VARCHAR2(250);
1595: BEGIN
1596:
1597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1598: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1599: ,G_MODULE_HEAD || l_routine || '.begin'
1600: ,l_routine || '<'
1601: );
1602: END IF;

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

1620: FND_MSG_PUB.Add;
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1626: ,G_MODULE_HEAD || l_routine || '.end'
1627: ,l_routine || '>'
1628: );

Line 1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1625: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1626: ,G_MODULE_HEAD || l_routine || '.end'
1627: ,l_routine || '>'
1628: );
1629: END IF;

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

1650: l_message VARCHAR2(250);
1651:
1652: BEGIN
1653:
1654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1655: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1656: ,G_MODULE_HEAD || l_routine || '.begin'
1657: ,l_routine || '<'
1658: );

Line 1655: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1651:
1652: BEGIN
1653:
1654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1655: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1656: ,G_MODULE_HEAD || l_routine || '.begin'
1657: ,l_routine || '<'
1658: );
1659: END IF;

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

1693: FND_MSG_PUB.Add;
1694: RAISE FND_API.G_EXC_ERROR;
1695: END IF;
1696:
1697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1699: ,G_MODULE_HEAD || l_routine || '.end'
1700: ,l_routine || '>'
1701: );

Line 1698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1694: RAISE FND_API.G_EXC_ERROR;
1695: END IF;
1696:
1697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1699: ,G_MODULE_HEAD || l_routine || '.end'
1700: ,l_routine || '>'
1701: );
1702: END IF;

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

2166: group2_other_except EXCEPTION;
2167: error_transaction_id NUMBER;
2168: BEGIN
2169:
2170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2172: ,G_MODULE_HEAD || l_routine || '.begin'
2173: ,l_routine || '<'
2174: );

Line 2171: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2167: error_transaction_id NUMBER;
2168: BEGIN
2169:
2170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2172: ,G_MODULE_HEAD || l_routine || '.begin'
2173: ,l_routine || '<'
2174: );
2175: END IF;

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

2197: END IF;
2198:
2199: CLOSE get_llc_cur;
2200:
2201: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2202: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2203: ,G_MODULE_HEAD || l_routine || '.lowlvcg'
2204: ,'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id || ' Low Level Code:' || l_low_level_code
2205: );

Line 2202: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2198:
2199: CLOSE get_llc_cur;
2200:
2201: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2202: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2203: ,G_MODULE_HEAD || l_routine || '.lowlvcg'
2204: ,'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id || ' Low Level Code:' || l_low_level_code
2205: );
2206: END IF;

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

2243: -- Process Group 2 transactions for a completion item in the current level
2244: -- interorg transactions within the same cost group and
2245: -- non interorg transactions
2246: -- ======================================================================
2247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2249: ,G_MODULE_HEAD || l_routine || '.group2_non_interorg'
2250: ,'Group 2 - Transaction Id:'|| l_group2_other_tab(i).transaction_id );
2251:

Line 2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2244: -- interorg transactions within the same cost group and
2245: -- non interorg transactions
2246: -- ======================================================================
2247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2249: ,G_MODULE_HEAD || l_routine || '.group2_non_interorg'
2250: ,'Group 2 - Transaction Id:'|| l_group2_other_tab(i).transaction_id );
2251:
2252: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

Line 2252: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2249: ,G_MODULE_HEAD || l_routine || '.group2_non_interorg'
2250: ,'Group 2 - Transaction Id:'|| l_group2_other_tab(i).transaction_id );
2251:
2252: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2253: ,G_MODULE_HEAD || l_routine || '.gp2_item_id'
2254: ,'Inventory Item Id:' || p_inventory_item_id || ' ' || 'Cost Group Id:'
2255: || p_cg_tab(l_current_index).cost_group_id || ' Period Id:' || p_period_id
2256: );

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

2263: ,x_exp_flag => l_exp_flag
2264: ,x_exp_item => l_exp_item
2265: );
2266:
2267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2268: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2269: ,G_MODULE_HEAD || l_routine || '.exp_flag_wip'
2270: ,'Exp Flag:' || l_exp_flag || ' ' ||
2271: 'Exp Item:' || l_exp_item

Line 2268: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2264: ,x_exp_item => l_exp_item
2265: );
2266:
2267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2268: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2269: ,G_MODULE_HEAD || l_routine || '.exp_flag_wip'
2270: ,'Exp Flag:' || l_exp_flag || ' ' ||
2271: 'Exp Item:' || l_exp_item
2272: );

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

2291: ,o_err_num => l_error_num
2292: ,o_err_code => l_error_code
2293: ,o_err_msg => l_error_msg
2294: );
2295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2297: ,G_MODULE_HEAD || l_routine || '.inscppb10'
2298: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
2299: );

Line 2296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2292: ,o_err_code => l_error_code
2293: ,o_err_msg => l_error_msg
2294: );
2295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2297: ,G_MODULE_HEAD || l_routine || '.inscppb10'
2298: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
2299: );
2300: END IF;

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

2326: , x_err_code => l_error_code
2327: , x_err_msg => l_error_msg
2328: );
2329:
2330: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2332: ,G_MODULE_HEAD || l_routine || '.gp2_charge_wip'
2333: ,'Charge WIP Material:'|| l_error_num || ' ' ||
2334: l_error_code || ' ' || l_error_msg

Line 2331: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2327: , x_err_msg => l_error_msg
2328: );
2329:
2330: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2332: ,G_MODULE_HEAD || l_routine || '.gp2_charge_wip'
2333: ,'Charge WIP Material:'|| l_error_num || ' ' ||
2334: l_error_code || ' ' || l_error_msg
2335: );

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

2359: ,o_err_num => l_error_num
2360: ,o_err_code => l_error_code
2361: ,o_err_msg => l_error_msg
2362: );
2363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2365: ,G_MODULE_HEAD || l_routine || '.inscppb11'
2366: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
2367: );

Line 2364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2360: ,o_err_code => l_error_code
2361: ,o_err_msg => l_error_msg
2362: );
2363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2364: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2365: ,G_MODULE_HEAD || l_routine || '.inscppb11'
2366: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
2367: );
2368: END IF;

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

2407: ,o_err_num => l_error_num
2408: ,o_err_code => l_error_code
2409: ,o_err_msg => l_error_msg);
2410:
2411: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2413: ,G_MODULE_HEAD || l_routine || '.befcostinvtxn'
2414: ,'After calling cost_inv_txn:'|| l_error_num || l_error_code || l_error_msg);
2415: END IF;

Line 2412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2408: ,o_err_code => l_error_code
2409: ,o_err_msg => l_error_msg);
2410:
2411: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2413: ,G_MODULE_HEAD || l_routine || '.befcostinvtxn'
2414: ,'After calling cost_inv_txn:'|| l_error_num || l_error_code || l_error_msg);
2415: END IF;
2416:

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

2465: l_error_num := NVL(l_error_num, 0);
2466: l_error_code := NVL(l_error_code, 'No Error');
2467: l_error_msg := NVL(l_error_msg, 'No Error');
2468:
2469: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2470: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2471: ,G_MODULE_HEAD || l_routine || '.inscppb12'
2472: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
2473: );

Line 2470: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2466: l_error_code := NVL(l_error_code, 'No Error');
2467: l_error_msg := NVL(l_error_msg, 'No Error');
2468:
2469: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2470: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2471: ,G_MODULE_HEAD || l_routine || '.inscppb12'
2472: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
2473: );
2474: END IF;

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

2493: l_error_num := NVL(l_error_num, 0);
2494: l_error_code := NVL(l_error_code, 'No Error');
2495: l_error_msg := NVL(l_error_msg, 'No Error');
2496:
2497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2498: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2499: ,G_MODULE_HEAD || l_routine || '.updcppb11'
2500: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
2501: );

Line 2498: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2494: l_error_code := NVL(l_error_code, 'No Error');
2495: l_error_msg := NVL(l_error_msg, 'No Error');
2496:
2497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2498: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2499: ,G_MODULE_HEAD || l_routine || '.updcppb11'
2500: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
2501: );
2502: END IF;

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

2517: l_current_index := p_cg_tab.NEXT(l_current_index);
2518:
2519: END LOOP; -- cost group loop
2520:
2521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2523: ,G_MODULE_HEAD || l_routine || '.end'
2524: ,l_routine || '>'
2525: );

Line 2522: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2518:
2519: END LOOP; -- cost group loop
2520:
2521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2523: ,G_MODULE_HEAD || l_routine || '.end'
2524: ,l_routine || '>'
2525: );
2526: END IF;

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

2528: EXCEPTION
2529: WHEN FND_API.G_EXC_ERROR THEN
2530: RAISE FND_API.G_EXC_ERROR;
2531: WHEN group2_other_except THEN
2532: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2533: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2534: , G_MODULE_HEAD || l_routine || '.group2_other_exc'
2535: , 'group2_other_exc for txn_id '||error_transaction_id || l_error_code || l_error_msg
2536: );

Line 2533: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2529: WHEN FND_API.G_EXC_ERROR THEN
2530: RAISE FND_API.G_EXC_ERROR;
2531: WHEN group2_other_except THEN
2532: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2533: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2534: , G_MODULE_HEAD || l_routine || '.group2_other_exc'
2535: , 'group2_other_exc for txn_id '||error_transaction_id || l_error_code || l_error_msg
2536: );
2537: END IF;

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

2600: AND inventory_item_id = c_inventory_item_id;
2601:
2602: BEGIN
2603:
2604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2606: ,G_MODULE_HEAD || l_routine || '.begin'
2607: ,l_routine || '<'
2608: );

Line 2605: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2601:
2602: BEGIN
2603:
2604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2606: ,G_MODULE_HEAD || l_routine || '.begin'
2607: ,l_routine || '<'
2608: );
2609: END IF;

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

2682:
2683: END LOOP;
2684:
2685:
2686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2687: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2688: ,G_MODULE_HEAD || l_routine || '.end'
2689: ,l_routine || '>'
2690: );

Line 2687: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2683: END LOOP;
2684:
2685:
2686: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2687: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2688: ,G_MODULE_HEAD || l_routine || '.end'
2689: ,l_routine || '>'
2690: );
2691: END IF;

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

2761: l_continue_loop_flag VARCHAR2(1) := 'Y';
2762:
2763: BEGIN
2764:
2765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2766: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2767: ,G_MODULE_HEAD || l_routine || '.begin'
2768: ,l_routine || '<'
2769: );

Line 2766: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2762:
2763: BEGIN
2764:
2765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2766: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2767: ,G_MODULE_HEAD || l_routine || '.begin'
2768: ,l_routine || '<'
2769: );
2770: END IF;

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

2811: -- Completion Items not exist
2812: l_topmost_bom_level_code := 1000;
2813: END IF;
2814:
2815: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2816: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2817: ,G_MODULE_HEAD || l_routine || '.topmostbomlvl'
2818: ,'Topmost bom level code across items in all CGs:' || l_topmost_bom_level_code
2819: );

Line 2816: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2812: l_topmost_bom_level_code := 1000;
2813: END IF;
2814:
2815: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2816: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2817: ,G_MODULE_HEAD || l_routine || '.topmostbomlvl'
2818: ,'Topmost bom level code across items in all CGs:' || l_topmost_bom_level_code
2819: );
2820: END IF;

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

2856: INTO l_topmost_absl_level_code
2857: FROM cst_pac_itms_absl_codes
2858: WHERE pac_period_id = p_period_id;
2859:
2860: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2862: ,G_MODULE_HEAD || l_routine || '.topmostabscode'
2863: ,'Topmost absorption level code:' || l_topmost_absl_level_code
2864: );

Line 2861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2857: FROM cst_pac_itms_absl_codes
2858: WHERE pac_period_id = p_period_id;
2859:
2860: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2862: ,G_MODULE_HEAD || l_routine || '.topmostabscode'
2863: ,'Topmost absorption level code:' || l_topmost_absl_level_code
2864: );
2865: END IF;

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

2865: END IF;
2866:
2867: WHILE (l_absorption_level_code >= l_topmost_absl_level_code) LOOP
2868:
2869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2871: ,G_MODULE_HEAD || l_routine || '.abslvcode'
2872: ,'Current absorption level code:' || l_absorption_level_code
2873: );

Line 2870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2866:
2867: WHILE (l_absorption_level_code >= l_topmost_absl_level_code) LOOP
2868:
2869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2870: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2871: ,G_MODULE_HEAD || l_routine || '.abslvcode'
2872: ,'Current absorption level code:' || l_absorption_level_code
2873: );
2874: END IF;

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

2915:
2916:
2917: WHILE (items_in_current_absl_cur%FOUND) LOOP
2918:
2919: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2920: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2921: ,G_MODULE_HEAD || l_routine || '.absitem'
2922: ,'Current Absorption level item:' || items_in_current_absl_row.inventory_item_id
2923: );

Line 2920: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2916:
2917: WHILE (items_in_current_absl_cur%FOUND) LOOP
2918:
2919: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2920: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2921: ,G_MODULE_HEAD || l_routine || '.absitem'
2922: ,'Current Absorption level item:' || items_in_current_absl_row.inventory_item_id
2923: );
2924: END IF;

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

2940: AND cpet.assembly_item_id = items_in_current_absl_row.inventory_item_id
2941: AND cpet.component_item_id <> cpet.assembly_item_id
2942: );
2943:
2944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2945: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2946: ,G_MODULE_HEAD || l_routine || '.minchildabslv'
2947: ,'Highest absorption level across its child items:' || l_min_child_absl_level_code
2948: );

Line 2945: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2941: AND cpet.component_item_id <> cpet.assembly_item_id
2942: );
2943:
2944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2945: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2946: ,G_MODULE_HEAD || l_routine || '.minchildabslv'
2947: ,'Highest absorption level across its child items:' || l_min_child_absl_level_code
2948: );
2949: END IF;

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

2954:
2955: -- bump up the absorption level of parent item
2956: l_reposition_absl_level_code := l_min_child_absl_level_code - 1;
2957:
2958: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2959: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2960: ,G_MODULE_HEAD || l_routine || '.reposabslvcode'
2961: ,'Reposition Absorption Level Code:' || l_reposition_absl_level_code || ' Item Id:' || items_in_current_absl_row.inventory_item_id
2962: );

Line 2959: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2955: -- bump up the absorption level of parent item
2956: l_reposition_absl_level_code := l_min_child_absl_level_code - 1;
2957:
2958: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2959: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2960: ,G_MODULE_HEAD || l_routine || '.reposabslvcode'
2961: ,'Reposition Absorption Level Code:' || l_reposition_absl_level_code || ' Item Id:' || items_in_current_absl_row.inventory_item_id
2962: );
2963: END IF;

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

2979: END LOOP; -- absorption level loop
2980:
2981: END LOOP; -- absorption loop count
2982:
2983: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2984: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2985: ,G_MODULE_HEAD || l_routine || '.end'
2986: ,l_routine || '>'
2987: );

Line 2984: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2980:
2981: END LOOP; -- absorption loop count
2982:
2983: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2984: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2985: ,G_MODULE_HEAD || l_routine || '.end'
2986: ,l_routine || '>'
2987: );
2988: END IF;

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

3032: ( FND_FILE.log
3033: , '>> CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'
3034: );
3035:
3036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3038: ,G_MODULE_HEAD || l_routine || '.begin'
3039: ,l_routine || '<'
3040: );

Line 3037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3033: , '>> CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'
3034: );
3035:
3036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3037: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3038: ,G_MODULE_HEAD || l_routine || '.begin'
3039: ,l_routine || '<'
3040: );
3041: END IF;

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

3060: AND mmtt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3061: AND ROWNUM = 1;
3062:
3063:
3064: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3065: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3066: ,G_MODULE_HEAD || l_routine || '.pendmmtt'
3067: ,'Pending Txns in MMTT:' || l_count_rows
3068: );

Line 3065: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3061: AND ROWNUM = 1;
3062:
3063:
3064: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3065: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3066: ,G_MODULE_HEAD || l_routine || '.pendmmtt'
3067: ,'Pending Txns in MMTT:' || l_count_rows
3068: );
3069: END IF;

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

3083: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mti.organization_id) = 'Y'
3084: AND mti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3085: AND ROWNUM = 1;
3086:
3087: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3089: ,G_MODULE_HEAD || l_routine || '.pendmti'
3090: ,'Pending Txns in MTI:' || l_count_rows
3091: );

Line 3088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3084: AND mti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3085: AND ROWNUM = 1;
3086:
3087: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3088: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3089: ,G_MODULE_HEAD || l_routine || '.pendmti'
3090: ,'Pending Txns in MTI:' || l_count_rows
3091: );
3092: END IF;

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

3106: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wcti.organization_id) = 'Y'
3107: AND wcti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3108: AND ROWNUM = 1;
3109:
3110: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3112: ,G_MODULE_HEAD || l_routine || '.pendwcti'
3113: ,'Pending Txns in WCTI:' || l_count_rows
3114: );

Line 3111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3107: AND wcti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3108: AND ROWNUM = 1;
3109:
3110: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3112: ,G_MODULE_HEAD || l_routine || '.pendwcti'
3113: ,'Pending Txns in WCTI:' || l_count_rows
3114: );
3115: END IF;

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

3133: )
3134: AND rti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3135: AND ROWNUM = 1;
3136:
3137: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3139: ,G_MODULE_HEAD || l_routine || '.pendrti'
3140: ,'Pending Txns in RTI:' || l_count_rows
3141: );

Line 3138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3134: AND rti.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3135: AND ROWNUM = 1;
3136:
3137: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3139: ,G_MODULE_HEAD || l_routine || '.pendrti'
3140: ,'Pending Txns in RTI:' || l_count_rows
3141: );
3142: END IF;

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

3166: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(mmt.organization_id) = 'Y'
3167: AND mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3168: AND ROWNUM = 1;
3169:
3170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3171: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3172: ,G_MODULE_HEAD || l_routine || '.backmmt'
3173: ,'Backdated Txns in MMT:' || l_count_rows
3174: );

Line 3171: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3167: AND mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3168: AND ROWNUM = 1;
3169:
3170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3171: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3172: ,G_MODULE_HEAD || l_routine || '.backmmt'
3173: ,'Backdated Txns in MMT:' || l_count_rows
3174: );
3175: END IF;

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

3197: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(wt.organization_id) = 'Y'
3198: AND wt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3199: AND ROWNUM = 1;
3200:
3201: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3202: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3203: ,G_MODULE_HEAD || l_routine || '.backwt'
3204: ,'Backdated Txns in WT:' || l_count_rows
3205: );

Line 3202: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3198: AND wt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3199: AND ROWNUM = 1;
3200:
3201: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3202: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3203: ,G_MODULE_HEAD || l_routine || '.backwt'
3204: ,'Backdated Txns in WT:' || l_count_rows
3205: );
3206: END IF;

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

3228: AND CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(rt.organization_id) = 'Y'
3229: AND rt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3230: AND ROWNUM = 1;
3231:
3232: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3234: ,G_MODULE_HEAD || l_routine || '.backrt'
3235: ,'Backdated Txns in RT:' || l_count_rows
3236: );

Line 3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3229: AND rt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3230: AND ROWNUM = 1;
3231:
3232: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3234: ,G_MODULE_HEAD || l_routine || '.backrt'
3235: ,'Backdated Txns in RT:' || l_count_rows
3236: );
3237: END IF;

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

3260: AND rae.transaction_date BETWEEN p_period_start_date AND p_period_end_date
3261: AND rae.event_type_id IN (7,8, 9, 10)
3262: AND ROWNUM = 1;
3263:
3264: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3265: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3266: ,G_MODULE_HEAD || l_routine || '.backrae'
3267: ,'Backdated Txns in RAE:' || l_count_rows
3268: );

Line 3265: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3261: AND rae.event_type_id IN (7,8, 9, 10)
3262: AND ROWNUM = 1;
3263:
3264: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3265: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3266: ,G_MODULE_HEAD || l_routine || '.backrae'
3267: ,'Backdated Txns in RAE:' || l_count_rows
3268: );
3269: END IF;

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

3278: ( FND_FILE.log
3279: , '<< CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'
3280: );
3281:
3282: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3283: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3284: ,G_MODULE_HEAD || l_routine || '.end'
3285: ,l_routine || '>'
3286: );

Line 3283: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3279: , '<< CST_PERIODIC_ABSORPTION_PROC:validate_uncosted_txns'
3280: );
3281:
3282: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3283: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3284: ,G_MODULE_HEAD || l_routine || '.end'
3285: ,l_routine || '>'
3286: );
3287: END IF;

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

3288:
3289:
3290: EXCEPTION
3291: WHEN l_pending_txns_except THEN
3292: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3294: , G_MODULE_HEAD || l_routine || '.pendtxn1_exc'
3295: , 'Pending Trasactions exist. Process all the pending transactions by import through applications interface'
3296: );

Line 3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

3289:
3290: EXCEPTION
3291: WHEN l_pending_txns_except THEN
3292: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3294: , G_MODULE_HEAD || l_routine || '.pendtxn1_exc'
3295: , 'Pending Trasactions exist. Process all the pending transactions by import through applications interface'
3296: );
3297: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

Line 3297: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3294: , G_MODULE_HEAD || l_routine || '.pendtxn1_exc'
3295: , 'Pending Trasactions exist. Process all the pending transactions by import through applications interface'
3296: );
3297: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3298: , G_MODULE_HEAD || l_routine || '.pendtxn2_exc'
3299: , 'Rerun the processor with run options Start'
3300: );
3301: END IF;

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

3304: FND_MSG_PUB.Add;
3305: RAISE FND_API.G_EXC_ERROR;
3306:
3307: WHEN l_backdated_txns_except THEN
3308: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3309: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3310: , G_MODULE_HEAD || l_routine || '.backdated_exc'
3311: , 'Backdated Trasactions exist. Rerun the processor with run options Start');
3312: END IF;

Line 3309: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

3305: RAISE FND_API.G_EXC_ERROR;
3306:
3307: WHEN l_backdated_txns_except THEN
3308: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3309: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3310: , G_MODULE_HEAD || l_routine || '.backdated_exc'
3311: , 'Backdated Trasactions exist. Rerun the processor with run options Start');
3312: END IF;
3313:

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

3352: ( FND_FILE.log
3353: , '>> CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'
3354: );
3355:
3356: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3358: ,G_MODULE_HEAD || l_routine || '.begin'
3359: ,l_routine || '<'
3360: );

Line 3357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3353: , '>> CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'
3354: );
3355:
3356: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3358: ,G_MODULE_HEAD || l_routine || '.begin'
3359: ,l_routine || '<'
3360: );
3361: END IF;

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

3399: ( FND_FILE.log
3400: , '<< CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'
3401: );
3402:
3403: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3404: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3405: ,G_MODULE_HEAD || l_routine || '.end'
3406: ,l_routine || '>'
3407: );

Line 3404: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3400: , '<< CST_PERIODIC_ABSORPTION_PROC.Insert_Ending_Balance_All_Cgs'
3401: );
3402:
3403: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3404: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3405: ,G_MODULE_HEAD || l_routine || '.end'
3406: ,l_routine || '>'
3407: );
3408: END IF;

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

3522: l_cost_update_type NUMBER;
3523:
3524: BEGIN
3525:
3526: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3528: ,G_MODULE_HEAD || l_routine || '.begin'
3529: ,l_routine || '<'
3530: );

Line 3527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3523:
3524: BEGIN
3525:
3526: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3527: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3528: ,G_MODULE_HEAD || l_routine || '.begin'
3529: ,l_routine || '<'
3530: );
3531: END IF;

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

3641:
3642: l_current_level_code := l_current_level_idx;
3643:
3644: -- Display current BOM level code
3645: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3646: FND_LOG.string(FND_LOG.LEVEL_EVENT
3647: , G_MODULE_HEAD || l_routine || '.currentabslevel'
3648: , 'Current absorption Level Code:' || l_current_level_code
3649: );

Line 3646: FND_LOG.string(FND_LOG.LEVEL_EVENT

3642: l_current_level_code := l_current_level_idx;
3643:
3644: -- Display current BOM level code
3645: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3646: FND_LOG.string(FND_LOG.LEVEL_EVENT
3647: , G_MODULE_HEAD || l_routine || '.currentabslevel'
3648: , 'Current absorption Level Code:' || l_current_level_code
3649: );
3650: END IF;

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

3674:
3675: l_inventory_item_id := G_ITEM_LEVEL_TBL(l_item_idx).inventory_item_id;
3676: l_inventory_item_number := Get_Item_Number(l_inventory_item_id);
3677:
3678: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3680: , G_MODULE_HEAD || l_routine ||'.item'
3681: , 'Inventory Item Id:' || l_inventory_item_id ||
3682: ' Item Number:' || l_inventory_item_number

Line 3679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3675: l_inventory_item_id := G_ITEM_LEVEL_TBL(l_item_idx).inventory_item_id;
3676: l_inventory_item_number := Get_Item_Number(l_inventory_item_id);
3677:
3678: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3680: , G_MODULE_HEAD || l_routine ||'.item'
3681: , 'Inventory Item Id:' || l_inventory_item_id ||
3682: ' Item Number:' || l_inventory_item_number
3683: );

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

3867: IF (l_interorg_item_flag = 1 AND l_iteration_proc_flag = 'Y') THEN
3868:
3869: -- Check whether tolerance achieved for an interorg item in the
3870: -- current absorption level
3871: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3872: FND_LOG.string(FND_LOG.LEVEL_EVENT
3873: , G_MODULE_HEAD || l_routine || '.check_nontol_items_lvl'
3874: , 'Check whether tolerance achieved for the item'
3875: );

Line 3872: FND_LOG.string(FND_LOG.LEVEL_EVENT

3868:
3869: -- Check whether tolerance achieved for an interorg item in the
3870: -- current absorption level
3871: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3872: FND_LOG.string(FND_LOG.LEVEL_EVENT
3873: , G_MODULE_HEAD || l_routine || '.check_nontol_items_lvl'
3874: , 'Check whether tolerance achieved for the item'
3875: );
3876: END IF;

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

3908: -- ==========================================================================
3909: IF (l_interorg_item_flag = 1 AND l_tol_item_flag = G_TOL_ACHIEVED_FORALL_CG ) OR
3910: (l_interorg_item_flag = 0) OR (l_iteration_proc_flag = 'N' ) THEN
3911:
3912: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3913: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3914: , G_MODULE_HEAD || l_routine || '.gp2txn'
3915: , 'Processing WIP Issue and other group 2 transactions'
3916: );

Line 3913: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3909: IF (l_interorg_item_flag = 1 AND l_tol_item_flag = G_TOL_ACHIEVED_FORALL_CG ) OR
3910: (l_interorg_item_flag = 0) OR (l_iteration_proc_flag = 'N' ) THEN
3911:
3912: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3913: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3914: , G_MODULE_HEAD || l_routine || '.gp2txn'
3915: , 'Processing WIP Issue and other group 2 transactions'
3916: );
3917: END IF;

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

4084:
4085:
4086: END IF; -- iteration process enabled check
4087:
4088: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4089: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4090: ,G_MODULE_HEAD || l_routine || '.end'
4091: ,l_routine || '>'
4092: );

Line 4089: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4085:
4086: END IF; -- iteration process enabled check
4087:
4088: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4089: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4090: ,G_MODULE_HEAD || l_routine || '.end'
4091: ,l_routine || '>'
4092: );
4093: END IF;

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

4200: ( FND_FILE.log
4201: , '>> CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'
4202: );
4203:
4204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4206: ,G_MODULE_HEAD || l_routine || '.begin'
4207: ,l_routine || '<'
4208: );

Line 4205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4201: , '>> CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'
4202: );
4203:
4204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4205: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4206: ,G_MODULE_HEAD || l_routine || '.begin'
4207: ,l_routine || '<'
4208: );
4209: END IF;

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

4222: l_loop_count := l_logical_txn_tab.count;
4223:
4224: FOR i IN 1..l_loop_count
4225: LOOP
4226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4228: ,G_MODULE_HEAD || l_routine || '.logical_txn1'
4229: ,'logical transaction - Transaction Id:' || l_logical_txn_tab(i).transaction_id || ' Action Id:' || l_logical_txn_tab(i).transaction_action_id
4230: );

Line 4227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4223:
4224: FOR i IN 1..l_loop_count
4225: LOOP
4226: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4228: ,G_MODULE_HEAD || l_routine || '.logical_txn1'
4229: ,'logical transaction - Transaction Id:' || l_logical_txn_tab(i).transaction_id || ' Action Id:' || l_logical_txn_tab(i).transaction_action_id
4230: );
4231: END IF;

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

4229: ,'logical transaction - Transaction Id:' || l_logical_txn_tab(i).transaction_id || ' Action Id:' || l_logical_txn_tab(i).transaction_action_id
4230: );
4231: END IF;
4232:
4233: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4234: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4235: ,G_MODULE_HEAD || l_routine || '.logical_txn2'
4236: ,'Source Type Id:' || l_logical_txn_tab(i).transaction_source_type_id || ' inventory item id:' || l_logical_txn_tab(i).inventory_item_id
4237: );

Line 4234: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4230: );
4231: END IF;
4232:
4233: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4234: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4235: ,G_MODULE_HEAD || l_routine || '.logical_txn2'
4236: ,'Source Type Id:' || l_logical_txn_tab(i).transaction_source_type_id || ' inventory item id:' || l_logical_txn_tab(i).inventory_item_id
4237: );
4238: END IF;

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

4283: ( FND_FILE.log
4284: , '<< CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'
4285: );
4286:
4287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4289: ,G_MODULE_HEAD || l_routine || '.end'
4290: ,l_routine || '>'
4291: );

Line 4288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4284: , '<< CST_PERIODIC_ABSORPTION_PROC:process_logical_txns'
4285: );
4286:
4287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4288: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4289: ,G_MODULE_HEAD || l_routine || '.end'
4290: ,l_routine || '>'
4291: );
4292: END IF;

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

4415:
4416:
4417: BEGIN
4418:
4419: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4420: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4421: ,G_MODULE_HEAD || l_routine || '.begin'
4422: ,l_routine || '<'
4423: );

Line 4420: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4416:
4417: BEGIN
4418:
4419: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4420: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4421: ,G_MODULE_HEAD || l_routine || '.begin'
4422: ,l_routine || '<'
4423: );
4424: END IF;

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

4434: l_current_index := p_cg_tab.FIRST;
4435:
4436: LOOP
4437:
4438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4440: ,G_MODULE_HEAD || l_routine || '.cgid'
4441: ,'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id
4442: );

Line 4439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4435:
4436: LOOP
4437:
4438: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4440: ,G_MODULE_HEAD || l_routine || '.cgid'
4441: ,'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id
4442: );
4443: END IF;

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

4481: RAISE FND_API.G_EXC_ERROR;
4482: END IF;
4483: -- store the request id in G_REQUEST_TABLE
4484: fnd_file.put_line(FND_FILE.LOG, 'Request Id for Cost Group ' || p_cg_tab(l_current_index).cost_group_id ||' : '||l_submit_req_id);
4485: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4486: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4487: ,G_MODULE_HEAD || l_routine || '.reqId'
4488: ,'Request '|| l_submit_req_id ||' submitted for Cost Group Id: ' || p_cg_tab(l_current_index).cost_group_id
4489: );

Line 4486: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4482: END IF;
4483: -- store the request id in G_REQUEST_TABLE
4484: fnd_file.put_line(FND_FILE.LOG, 'Request Id for Cost Group ' || p_cg_tab(l_current_index).cost_group_id ||' : '||l_submit_req_id);
4485: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4486: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4487: ,G_MODULE_HEAD || l_routine || '.reqId'
4488: ,'Request '|| l_submit_req_id ||' submitted for Cost Group Id: ' || p_cg_tab(l_current_index).cost_group_id
4489: );
4490: END IF;

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

4578: ( FND_FILE.log
4579: , 'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id
4580: );
4581:
4582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4584: ,G_MODULE_HEAD || l_routine || '.cgid'
4585: ,'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id
4586: );

Line 4583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4579: , 'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id
4580: );
4581:
4582: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4584: ,G_MODULE_HEAD || l_routine || '.cgid'
4585: ,'Cost Group Id:' || p_cg_tab(l_current_index).cost_group_id
4586: );
4587: END IF;

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

4685: );
4686: END IF; -- Phase 7 check
4687:
4688:
4689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4691: ,G_MODULE_HEAD || l_routine || '.end'
4692: ,l_routine || '>'
4693: );

Line 4690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4686: END IF; -- Phase 7 check
4687:
4688:
4689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4690: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4691: ,G_MODULE_HEAD || l_routine || '.end'
4692: ,l_routine || '>'
4693: );
4694: END IF;

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

4774: l_cost_group_idx BINARY_INTEGER;
4775:
4776: BEGIN
4777:
4778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4779: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4780: ,G_MODULE_HEAD || l_routine || '.begin'
4781: ,l_routine || '<'
4782: );

Line 4779: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

4775:
4776: BEGIN
4777:
4778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4779: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
4780: ,G_MODULE_HEAD || l_routine || '.begin'
4781: ,l_routine || '<'
4782: );
4783: END IF;

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

4903: l_end_date := CST_PERIODIC_ABSORPTION_PROC.Find_Prev_Process_Upto_Date
4904: (p_pac_period_id => p_period_id);
4905: END IF;
4906:
4907: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_EVENT
4909: ,G_MODULE_HEAD || l_routine || '.dtrange'
4910: ,'Date Range:' || TO_CHAR(l_start_date,'DD-MON-YYYY HH24:MI:SS') || ' ' || TO_CHAR(l_end_date,'DD-MON-YYYY HH24:MI:SS')
4911: );

Line 4908: FND_LOG.string(FND_LOG.LEVEL_EVENT

4904: (p_pac_period_id => p_period_id);
4905: END IF;
4906:
4907: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4908: FND_LOG.string(FND_LOG.LEVEL_EVENT
4909: ,G_MODULE_HEAD || l_routine || '.dtrange'
4910: ,'Date Range:' || TO_CHAR(l_start_date,'DD-MON-YYYY HH24:MI:SS') || ' ' || TO_CHAR(l_end_date,'DD-MON-YYYY HH24:MI:SS')
4911: );
4912: END IF;

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

4916: LOOP
4917:
4918: -- The following checks need to be made for each cost group
4919:
4920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4921: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4922: ,G_MODULE_HEAD || l_routine || '.cgid'
4923: ,'Cost Group Id:' || l_txn_tab(l_current_index).cost_group_id
4924: );

Line 4921: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4917:
4918: -- The following checks need to be made for each cost group
4919:
4920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4921: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4922: ,G_MODULE_HEAD || l_routine || '.cgid'
4923: ,'Cost Group Id:' || l_txn_tab(l_current_index).cost_group_id
4924: );
4925: END IF;

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

5010: ,p_end_date => l_end_date
5011: ,p_run_options => l_run_options
5012: );
5013:
5014: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5015: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5016: ,G_MODULE_HEAD || l_routine || '.end'
5017: ,l_routine || '>'
5018: );

Line 5015: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5011: ,p_run_options => l_run_options
5012: );
5013:
5014: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5015: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5016: ,G_MODULE_HEAD || l_routine || '.end'
5017: ,l_routine || '>'
5018: );
5019: END IF;

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

5034: x_return_status := FND_API.G_RET_STS_ERROR;
5035: x_msg_data := l_msg_data;
5036: END IF;
5037:
5038: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5039: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5040: , G_MODULE_HEAD || l_routine , x_msg_data
5041: );
5042: END IF;

Line 5039: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

5035: x_msg_data := l_msg_data;
5036: END IF;
5037:
5038: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5039: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5040: , G_MODULE_HEAD || l_routine , x_msg_data
5041: );
5042: END IF;
5043:

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

5054: ( FND_FILE.log
5055: , 'Error in transfer_cp_manager '|| x_msg_data || ' ' || substr(l_msg_data, 1,250)
5056: );
5057:
5058: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5059: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5060: , G_MODULE_HEAD || l_routine ||'.others_exc'
5061: , 'others:' || x_msg_data || ' ' || substr(l_msg_data, 1,250)
5062: );

Line 5059: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

5055: , 'Error in transfer_cp_manager '|| x_msg_data || ' ' || substr(l_msg_data, 1,250)
5056: );
5057:
5058: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5059: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5060: , G_MODULE_HEAD || l_routine ||'.others_exc'
5061: , 'others:' || x_msg_data || ' ' || substr(l_msg_data, 1,250)
5062: );
5063: END IF;