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

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

307:
308: BEGIN
309:
310:
311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
313: , G_MODULE_HEAD || l_routine ||'.begin'
314: , l_routine || '<'
315: );

Line 312: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

308: BEGIN
309:
310:
311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
313: , G_MODULE_HEAD || l_routine ||'.begin'
314: , l_routine || '<'
315: );
316: END IF;

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

330:
331:
332: CLOSE new_pwac_cost_cur;
333:
334: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: FND_LOG.string(FND_LOG.LEVEL_EVENT
336: , G_MODULE_HEAD || l_routine ||'.Directnewcost'
337: , 'Correspond Txn Id:' || p_opp_transaction_id ||
338: ' Correspond organization Id:' || p_opp_organization_id

Line 335: FND_LOG.string(FND_LOG.LEVEL_EVENT

331:
332: CLOSE new_pwac_cost_cur;
333:
334: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: FND_LOG.string(FND_LOG.LEVEL_EVENT
336: , G_MODULE_HEAD || l_routine ||'.Directnewcost'
337: , 'Correspond Txn Id:' || p_opp_transaction_id ||
338: ' Correspond organization Id:' || p_opp_organization_id
339: || ' New Cost:' || l_correspond_pmac_cost

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

376: INTO l_correspond_pmac_cost;
377:
378: CLOSE new_pwac_cost_cur;
379:
380: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.string(FND_LOG.LEVEL_EVENT
382: , G_MODULE_HEAD || l_routine ||'.Intransitnewcost'
383: , 'Correspond Txn Id:' || p_opp_transaction_id ||
384: ' Correspond organization Id:' || l_correspond_org_id ||

Line 381: FND_LOG.string(FND_LOG.LEVEL_EVENT

377:
378: CLOSE new_pwac_cost_cur;
379:
380: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.string(FND_LOG.LEVEL_EVENT
382: , G_MODULE_HEAD || l_routine ||'.Intransitnewcost'
383: , 'Correspond Txn Id:' || p_opp_transaction_id ||
384: ' Correspond organization Id:' || l_correspond_org_id ||
385: ' New Cost:' || l_correspond_pmac_cost

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

389: END IF; -- interorg transaction check
390:
391: x_correspond_pmac_cost := l_correspond_pmac_cost;
392:
393: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
395: , G_MODULE_HEAD || l_routine ||'.end'
396: , l_routine || '>'
397: );

Line 394: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

390:
391: x_correspond_pmac_cost := l_correspond_pmac_cost;
392:
393: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
395: , G_MODULE_HEAD || l_routine ||'.end'
396: , l_routine || '>'
397: );
398: END IF;

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

470: new_cost_intransit_excep EXCEPTION;
471:
472: BEGIN
473:
474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
475: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
476: , G_MODULE_HEAD || l_routine ||'.begin'
477: , l_routine || '<'
478: );

Line 475: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

471:
472: BEGIN
473:
474: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
475: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
476: , G_MODULE_HEAD || l_routine ||'.begin'
477: , l_routine || '<'
478: );
479: END IF;

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

494: INTO l_new_correspond_cost;
495:
496: CLOSE new_pwac_cost_cur;
497:
498: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
499: FND_LOG.string(FND_LOG.LEVEL_EVENT
500: , G_MODULE_HEAD || l_routine ||'.Directnewcost'
501: , 'Correspond Txn Id:' || p_opp_transaction_id ||
502: ' Correspond organization Id:' || p_opp_organization_id || ' Cost element Id:' || p_cost_element_id ||

Line 499: FND_LOG.string(FND_LOG.LEVEL_EVENT

495:
496: CLOSE new_pwac_cost_cur;
497:
498: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
499: FND_LOG.string(FND_LOG.LEVEL_EVENT
500: , G_MODULE_HEAD || l_routine ||'.Directnewcost'
501: , 'Correspond Txn Id:' || p_opp_transaction_id ||
502: ' Correspond organization Id:' || p_opp_organization_id || ' Cost element Id:' || p_cost_element_id ||
503: ' Level Type:' || p_level_type || ' New Cost:' || l_new_correspond_cost

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

545: -- END IF;
546:
547: CLOSE new_pwac_cost_cur;
548:
549: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.string(FND_LOG.LEVEL_EVENT
551: , G_MODULE_HEAD || l_routine ||'.Intransitnewcost'
552: , 'Correspond Txn Id:' || p_opp_transaction_id ||
553: ' Correspond organization Id:' || l_correspond_org_id || ' Cost element Id:' || p_cost_element_id ||

Line 550: FND_LOG.string(FND_LOG.LEVEL_EVENT

546:
547: CLOSE new_pwac_cost_cur;
548:
549: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.string(FND_LOG.LEVEL_EVENT
551: , G_MODULE_HEAD || l_routine ||'.Intransitnewcost'
552: , 'Correspond Txn Id:' || p_opp_transaction_id ||
553: ' Correspond organization Id:' || l_correspond_org_id || ' Cost element Id:' || p_cost_element_id ||
554: ' Level Type:' || p_level_type || ' New Cost:' ||

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

559: END IF; -- interorg transaction check
560:
561: x_new_correspond_cost := l_new_correspond_cost;
562:
563: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
564: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
565: , G_MODULE_HEAD || l_routine ||'.end'
566: , l_routine || '>'
567: );

Line 564: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

560:
561: x_new_correspond_cost := l_new_correspond_cost;
562:
563: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
564: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
565: , G_MODULE_HEAD || l_routine ||'.end'
566: , l_routine || '>'
567: );
568: END IF;

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

662: l_cost_group_id NUMBER;
663:
664: BEGIN
665:
666: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
668: , G_MODULE_HEAD || l_routine ||'.begin'
669: , l_routine || '<'
670: );

Line 667: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

663:
664: BEGIN
665:
666: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
668: , G_MODULE_HEAD || l_routine ||'.begin'
669: , l_routine || '<'
670: );
671: END IF;

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

669: , l_routine || '<'
670: );
671: END IF;
672:
673: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
674: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
675: , G_MODULE_HEAD || l_routine ||'.txnid'
676: , 'Transaction ID:' || p_transaction_id
677: );

Line 674: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

670: );
671: END IF;
672:
673: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
674: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
675: , G_MODULE_HEAD || l_routine ||'.txnid'
676: , 'Transaction ID:' || p_transaction_id
677: );
678: END IF;

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

711:
712: CLOSE direct_actual_cost_cur;
713:
714:
715: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
717: , G_MODULE_HEAD || l_routine ||'.Direct_txn'
718: , 'Correspond Txn Info: Organization Id:' ||
719: p_opp_organization_id || ' Transaction Id:' ||

Line 716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

712: CLOSE direct_actual_cost_cur;
713:
714:
715: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
717: , G_MODULE_HEAD || l_routine ||'.Direct_txn'
718: , 'Correspond Txn Info: Organization Id:' ||
719: p_opp_organization_id || ' Transaction Id:' ||
720: p_opp_transaction_id ||

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

773: CLOSE intransit_actual_cost_cur;
774:
775: IF l_correspond_txn_flag = 'C' THEN
776: -- Display a message that not cost group found
777: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
778: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
779: , G_MODULE_HEAD || l_routine ||'.nocg'
780: , 'No Cost Group found'
781: );

Line 778: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

774:
775: IF l_correspond_txn_flag = 'C' THEN
776: -- Display a message that not cost group found
777: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
778: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
779: , G_MODULE_HEAD || l_routine ||'.nocg'
780: , 'No Cost Group found'
781: );
782: END IF;

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

781: );
782: END IF;
783: END IF;
784:
785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
787: , G_MODULE_HEAD || l_routine ||'.Direct_txn'
788: , 'Correspond Txn Info: Organization Id:' ||
789: l_correspond_org_id || ' Transaction Id:' ||

Line 786: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

782: END IF;
783: END IF;
784:
785: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
787: , G_MODULE_HEAD || l_routine ||'.Direct_txn'
788: , 'Correspond Txn Info: Organization Id:' ||
789: l_correspond_org_id || ' Transaction Id:' ||
790: p_transaction_id ||

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

799:
800: x_correspond_actual_cost := l_correspond_actual_cost;
801: x_correspond_txn_flag := l_correspond_txn_flag;
802:
803: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
805: , G_MODULE_HEAD || l_routine ||'.end'
806: , l_routine || '>'
807: );

Line 804: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

800: x_correspond_actual_cost := l_correspond_actual_cost;
801: x_correspond_txn_flag := l_correspond_txn_flag;
802:
803: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
805: , G_MODULE_HEAD || l_routine ||'.end'
806: , l_routine || '>'
807: );
808: END IF;

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

810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: WHEN OTHERS THEN
814: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
816: , G_MODULE_HEAD || l_routine ||'.others_exc'
817: , 'txn_id '|| p_transaction_id || 'Opp Txn_id '||p_opp_transaction_id || SQLCODE || substr(SQLERRM, 1,200)
818: );

Line 815: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

811: WHEN FND_API.G_EXC_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: WHEN OTHERS THEN
814: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
815: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
816: , G_MODULE_HEAD || l_routine ||'.others_exc'
817: , 'txn_id '|| p_transaction_id || 'Opp Txn_id '||p_opp_transaction_id || SQLCODE || substr(SQLERRM, 1,200)
818: );
819: END IF;

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

983: ,l_pac_interorg_txns_tab(i).transaction_id
984: ,p_inventory_item_id
985: ) LOOP
986:
987: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
989: , G_MODULE_HEAD || l_routine ||'.txnid'
990: , 'interorg_txn_id:' || l_pac_interorg_txns_tab(i).transaction_id
991: );

Line 988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

984: ,p_inventory_item_id
985: ) LOOP
986:
987: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
989: , G_MODULE_HEAD || l_routine ||'.txnid'
990: , 'interorg_txn_id:' || l_pac_interorg_txns_tab(i).transaction_id
991: );
992: END IF;

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

1005: ,x_correspond_actual_cost => l_correspond_actual_cost
1006: ,x_correspond_txn_flag => l_correspond_txn_flag
1007: );
1008:
1009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1011: , G_MODULE_HEAD || l_routine ||'.actual_cost'
1012: , 'Correspond Actual Cost:' || l_correspond_actual_cost
1013: || ' ' || 'Correspond Txn Flag:' || l_correspond_txn_flag

Line 1010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1006: ,x_correspond_txn_flag => l_correspond_txn_flag
1007: );
1008:
1009: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1011: , G_MODULE_HEAD || l_routine ||'.actual_cost'
1012: , 'Correspond Actual Cost:' || l_correspond_actual_cost
1013: || ' ' || 'Correspond Txn Flag:' || l_correspond_txn_flag
1014: );

Line 1016: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1012: , 'Correspond Actual Cost:' || l_correspond_actual_cost
1013: || ' ' || 'Correspond Txn Flag:' || l_correspond_txn_flag
1014: );
1015:
1016: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1017: , G_MODULE_HEAD || l_routine ||'.inttxns'
1018: , 'Transfer transaction id:' || l_pac_interorg_txns_tab(i).transfer_transaction_id
1019: || ' ' || 'Transfer Organization id:' || l_pac_interorg_txns_tab(i).transfer_organization_id
1020: );

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

1045: WHEN NO_DATA_FOUND THEN
1046: l_moh_absorption_cost := 0;
1047: END;
1048:
1049: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1050: FND_LOG.string(FND_LOG.LEVEL_STATEMENT , G_MODULE_HEAD || l_routine ||'.moh_actual_cost'
1051: , 'After MOH Retrieve: Cost Group Id:' || l_pac_interorg_txns_tab(i).cost_group_id ||
1052: ' Transaction Id:' || l_pac_interorg_txns_tab(i).transaction_id ||
1053: ' Period Id:' || p_period_id || ' Level Type:' || pac_bal_txn_idx.level_type

Line 1050: FND_LOG.string(FND_LOG.LEVEL_STATEMENT , G_MODULE_HEAD || l_routine ||'.moh_actual_cost'

1046: l_moh_absorption_cost := 0;
1047: END;
1048:
1049: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1050: FND_LOG.string(FND_LOG.LEVEL_STATEMENT , G_MODULE_HEAD || l_routine ||'.moh_actual_cost'
1051: , 'After MOH Retrieve: Cost Group Id:' || l_pac_interorg_txns_tab(i).cost_group_id ||
1052: ' Transaction Id:' || l_pac_interorg_txns_tab(i).transaction_id ||
1053: ' Period Id:' || p_period_id || ' Level Type:' || pac_bal_txn_idx.level_type
1054: );

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

1060: UPDATE MTL_PAC_ACT_CST_DTL_TEMP
1061: SET moh_absorption_cost = l_moh_absorption_cost
1062: WHERE CURRENT OF pac_bal_txn_cursor;
1063:
1064: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1066: , G_MODULE_HEAD || l_routine ||'.ce'
1067: , 'MOH Absorption Cost Update:' || l_moh_absorption_cost
1068: );

Line 1065: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1061: SET moh_absorption_cost = l_moh_absorption_cost
1062: WHERE CURRENT OF pac_bal_txn_cursor;
1063:
1064: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1065: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1066: , G_MODULE_HEAD || l_routine ||'.ce'
1067: , 'MOH Absorption Cost Update:' || l_moh_absorption_cost
1068: );
1069: END IF;

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

1097: IF (l_correspond_txn_flag = 'N') AND (l_pac_interorg_txns_tab(i).transaction_action_id = 3 ) THEN
1098:
1099: -- Get Corresponding Cost Group Id
1100: l_correspond_cost_group_id := get_cost_group(l_pac_interorg_txns_tab(i).transfer_organization_id);
1101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1103: , G_MODULE_HEAD || l_routine || '.cgid'
1104: , 'Corresponding Cost Group Id:' || l_correspond_cost_group_id
1105: );

Line 1102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1098:
1099: -- Get Corresponding Cost Group Id
1100: l_correspond_cost_group_id := get_cost_group(l_pac_interorg_txns_tab(i).transfer_organization_id);
1101: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1103: , G_MODULE_HEAD || l_routine || '.cgid'
1104: , 'Corresponding Cost Group Id:' || l_correspond_cost_group_id
1105: );
1106: END IF;

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

1124:
1125: CLOSE pac_group1_cost_layer;
1126:
1127:
1128: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1130: , G_MODULE_HEAD || l_routine || '.cortxn'
1131: , 'Corresponding Transaction Id:' || l_correspond_transaction_id ||
1132: ' Corresponding Layer Id:' || l_correspond_cost_layer_id

Line 1129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1125: CLOSE pac_group1_cost_layer;
1126:
1127:
1128: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1130: , G_MODULE_HEAD || l_routine || '.cortxn'
1131: , 'Corresponding Transaction Id:' || l_correspond_transaction_id ||
1132: ' Corresponding Layer Id:' || l_correspond_cost_layer_id
1133: );

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

1151:
1152: CLOSE pac_intorg_itms_cur;
1153:
1154:
1155: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1157: , G_MODULE_HEAD || l_routine || '.intflag'
1158: , 'Corresponding Cost Group Id:' || l_correspond_cost_group_id ||
1159: ' Interorg Receipt Flag:' || l_interorg_receipt_flag ||

Line 1156: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1152: CLOSE pac_intorg_itms_cur;
1153:
1154:
1155: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1157: , G_MODULE_HEAD || l_routine || '.intflag'
1158: , 'Corresponding Cost Group Id:' || l_correspond_cost_group_id ||
1159: ' Interorg Receipt Flag:' || l_interorg_receipt_flag ||
1160: ' Interorg Shipment Flag:' || l_interorg_shipment_flag

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

1235: WHEN FND_API.G_EXC_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: WHEN OTHERS THEN
1238:
1239: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1241: , G_MODULE_HEAD || l_routine ||'.others_exc'
1242: , 'Item_id' ||p_inventory_item_id || SQLCODE || substr(SQLERRM, 1,200)
1243: );

Line 1240: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

1236: RAISE FND_API.G_EXC_ERROR;
1237: WHEN OTHERS THEN
1238:
1239: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
1241: , G_MODULE_HEAD || l_routine ||'.others_exc'
1242: , 'Item_id' ||p_inventory_item_id || SQLCODE || substr(SQLERRM, 1,200)
1243: );
1244: END IF;

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

1290: ( FND_FILE.log
1291: , '>> CST_PERIODIC_ABSORPTION_PROC:Calc_Pmac_For_Interorg'
1292: );
1293:
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1296: ,G_MODULE_HEAD || l_routine || '.begin'
1297: ,l_routine || '<'
1298: );

Line 1295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1291: , '>> CST_PERIODIC_ABSORPTION_PROC:Calc_Pmac_For_Interorg'
1292: );
1293:
1294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1296: ,G_MODULE_HEAD || l_routine || '.begin'
1297: ,l_routine || '<'
1298: );
1299: END IF;

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

1301: -- Get the period quantity upto interorg receipts
1302: l_cg_idx := to_char(p_cost_group_id);
1303: l_period_quantity := G_CST_GROUP_TBL(l_cg_idx).period_new_quantity;
1304:
1305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1307: ,G_MODULE_HEAD || l_routine || 'pdqty'
1308: ,'Cost Group Id:' || p_cost_group_id || ' Inventory Item Id:' || p_inventory_item_id || ' Period Quantity upto interorg receipts:' || l_period_quantity
1309: );

Line 1306: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1302: l_cg_idx := to_char(p_cost_group_id);
1303: l_period_quantity := G_CST_GROUP_TBL(l_cg_idx).period_new_quantity;
1304:
1305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1307: ,G_MODULE_HEAD || l_routine || 'pdqty'
1308: ,'Cost Group Id:' || p_cost_group_id || ' Inventory Item Id:' || p_inventory_item_id || ' Period Quantity upto interorg receipts:' || l_period_quantity
1309: );
1310: END IF;

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

1357: AND cpllc.cost_group_id = p_cost_group_id);
1358: END IF;
1359:
1360: IF SQL%NOTFOUND THEN
1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1363: ,G_MODULE_HEAD || l_routine || 'nompacd'
1364: ,'Stmt Num: ' || l_stmt_num || ' No records in MPACD for txn_category 8'
1365: );

Line 1362: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1358: END IF;
1359:
1360: IF SQL%NOTFOUND THEN
1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1363: ,G_MODULE_HEAD || l_routine || 'nompacd'
1364: ,'Stmt Num: ' || l_stmt_num || ' No records in MPACD for txn_category 8'
1365: );
1366: END IF;

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

1796: ( FND_FILE.log
1797: , '>> CST_PERIODIC_ABSORPTION_PROC.Calc_Pmac_Update_Cppb'
1798: );
1799:
1800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1802: ,G_MODULE_HEAD || l_routine || '.begin'
1803: ,l_routine || '>'
1804: );

Line 1801: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1797: , '>> CST_PERIODIC_ABSORPTION_PROC.Calc_Pmac_Update_Cppb'
1798: );
1799:
1800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1802: ,G_MODULE_HEAD || l_routine || '.begin'
1803: ,l_routine || '>'
1804: );
1805: END IF;

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

1824: END IF;
1825:
1826: CLOSE get_llc_cur;
1827:
1828: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1830: ,G_MODULE_HEAD || l_routine || '.cllc'
1831: ,'Cost Group Id: ' || l_cost_group_id || 'Period Quantity: ' ||
1832: l_period_quantity || 'Low Level Code: ' || l_low_level_code

Line 1829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

1825:
1826: CLOSE get_llc_cur;
1827:
1828: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
1830: ,G_MODULE_HEAD || l_routine || '.cllc'
1831: ,'Cost Group Id: ' || l_cost_group_id || 'Period Quantity: ' ||
1832: l_period_quantity || 'Low Level Code: ' || l_low_level_code
1833: );

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

1940: ( FND_FILE.log
1941: , '<< CST_PERIODIC_ABSORPTION_PROC.Calc_Pmac_Update_Cppb'
1942: );
1943:
1944: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1946: ,G_MODULE_HEAD || l_routine || '.end'
1947: ,l_routine || '>'
1948: );

Line 1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1941: , '<< CST_PERIODIC_ABSORPTION_PROC.Calc_Pmac_Update_Cppb'
1942: );
1943:
1944: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1945: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1946: ,G_MODULE_HEAD || l_routine || '.end'
1947: ,l_routine || '>'
1948: );
1949: END IF;

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

1982: l_routine CONSTANT VARCHAR2(30) := 'create_mpacd_with_new_values';
1983:
1984: BEGIN
1985:
1986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1988: , G_MODULE_HEAD || l_routine ||'.begin'
1989: , l_routine || '<'
1990: );

Line 1987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1983:
1984: BEGIN
1985:
1986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1987: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1988: , G_MODULE_HEAD || l_routine ||'.begin'
1989: , l_routine || '<'
1990: );
1991: END IF;

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

2057: AND mpacdt.cost_group_id = cpitt.cost_group_id
2058: AND mpacdt.inventory_item_id = cpitt.inventory_item_id;
2059:
2060:
2061: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2062: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2063: , G_MODULE_HEAD || l_routine ||'.end'
2064: , l_routine || '>'
2065: );

Line 2062: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2058: AND mpacdt.inventory_item_id = cpitt.inventory_item_id;
2059:
2060:
2061: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2062: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2063: , G_MODULE_HEAD || l_routine ||'.end'
2064: , l_routine || '>'
2065: );
2066: END IF;

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

2068: EXCEPTION
2069: WHEN FND_API.G_EXC_ERROR THEN
2070: RAISE FND_API.G_EXC_ERROR;
2071: WHEN OTHERS THEN
2072: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2073: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2074: , G_MODULE_HEAD || l_routine ||'.others_exc'
2075: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2076: );

Line 2073: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2069: WHEN FND_API.G_EXC_ERROR THEN
2070: RAISE FND_API.G_EXC_ERROR;
2071: WHEN OTHERS THEN
2072: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2073: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2074: , G_MODULE_HEAD || l_routine ||'.others_exc'
2075: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2076: );
2077: END IF;

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

2149: l_item_balance NUMBER;
2150:
2151: BEGIN
2152:
2153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2154: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2155: , G_MODULE_HEAD || l_routine ||'.begin'
2156: , l_routine || 'Item Id '||p_inventory_item_id|| ' Cost Group Id '||p_cost_group_id|| '<'
2157: );

Line 2154: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2150:
2151: BEGIN
2152:
2153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2154: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2155: , G_MODULE_HEAD || l_routine ||'.begin'
2156: , l_routine || 'Item Id '||p_inventory_item_id|| ' Cost Group Id '||p_cost_group_id|| '<'
2157: );
2158: END IF;

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

2166: to_char(mpacd_idx.cost_element_id) || to_char(mpacd_idx.level_type);
2167: l_item_cost := G_CG_PWAC_COST_TBL(l_cg_elmnt_lv_idx).final_new_cost;
2168: l_item_balance := G_CG_PWAC_COST_TBL(l_cg_elmnt_lv_idx).period_new_balance;
2169:
2170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2172: , G_MODULE_HEAD || l_routine ||'.cgellvic'
2173: , 'Cost Layer Id:' || mpacd_idx.cost_layer_id || 'Cost Group element level idx:' || l_cg_elmnt_lv_idx || ' Item Cost:' || l_item_cost || ' Item Balance:' || l_item_balance
2174: );

Line 2171: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2167: l_item_cost := G_CG_PWAC_COST_TBL(l_cg_elmnt_lv_idx).final_new_cost;
2168: l_item_balance := G_CG_PWAC_COST_TBL(l_cg_elmnt_lv_idx).period_new_balance;
2169:
2170: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2171: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2172: , G_MODULE_HEAD || l_routine ||'.cgellvic'
2173: , 'Cost Layer Id:' || mpacd_idx.cost_layer_id || 'Cost Group element level idx:' || l_cg_elmnt_lv_idx || ' Item Cost:' || l_item_cost || ' Item Balance:' || l_item_balance
2174: );
2175: END IF;

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

2190: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id
2191: AND cpicd.cost_element_id = mpacd_idx.cost_element_id
2192: AND cpicd.level_type = mpacd_idx.level_type;
2193:
2194: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2195: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2196: , G_MODULE_HEAD || l_routine ||'.upd'
2197: , 'Update CPICD: ' || 'Item Cost:' || l_item_cost || ' Item Balance:' || l_item_balance
2198: );

Line 2195: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2191: AND cpicd.cost_element_id = mpacd_idx.cost_element_id
2192: AND cpicd.level_type = mpacd_idx.level_type;
2193:
2194: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2195: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2196: , G_MODULE_HEAD || l_routine ||'.upd'
2197: , 'Update CPICD: ' || 'Item Cost:' || l_item_cost || ' Item Balance:' || l_item_balance
2198: );
2199: END IF;

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

2318:
2319:
2320: END LOOP; -- end of mpacd temp loop
2321:
2322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2324: , G_MODULE_HEAD || l_routine ||'.mpacdcg'
2325: , 'MPACD Loop complete: ' || ' Cost Group Id:' || p_cost_group_id
2326: );

Line 2323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2319:
2320: END LOOP; -- end of mpacd temp loop
2321:
2322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2324: , G_MODULE_HEAD || l_routine ||'.mpacdcg'
2325: , 'MPACD Loop complete: ' || ' Cost Group Id:' || p_cost_group_id
2326: );
2327: END IF;

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

2362: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2363: );
2364: END LOOP;
2365: END IF;
2366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2367: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2368: , G_MODULE_HEAD || l_routine ||'.end'
2369: , l_routine || '>'
2370: );

Line 2367: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2363: );
2364: END LOOP;
2365: END IF;
2366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2367: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2368: , G_MODULE_HEAD || l_routine ||'.end'
2369: , l_routine || '>'
2370: );
2371: END IF;

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

2373: EXCEPTION
2374: WHEN FND_API.G_EXC_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: WHEN OTHERS THEN
2377: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2379: , G_MODULE_HEAD || l_routine ||'.others_exc'
2380: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2381: );

Line 2378: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2374: WHEN FND_API.G_EXC_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: WHEN OTHERS THEN
2377: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2379: , G_MODULE_HEAD || l_routine ||'.others_exc'
2380: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2381: );
2382: END IF;

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

2422: l_cst_group_idx BINARY_INTEGER;
2423:
2424: BEGIN
2425:
2426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2428: , G_MODULE_HEAD || l_routine ||'.begin'
2429: , l_routine || '<'
2430: );

Line 2427: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2423:
2424: BEGIN
2425:
2426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2428: , G_MODULE_HEAD || l_routine ||'.begin'
2429: , l_routine || '<'
2430: );
2431: END IF;

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

2460: -- the following commit is required to prevent
2461: -- a complete rollback if the process errors out
2462: COMMIT;
2463:
2464: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2465: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2466: , G_MODULE_HEAD || l_routine ||'.end'
2467: , l_routine || '>'
2468: );

Line 2465: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2461: -- a complete rollback if the process errors out
2462: COMMIT;
2463:
2464: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2465: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2466: , G_MODULE_HEAD || l_routine ||'.end'
2467: , l_routine || '>'
2468: );
2469: END IF;

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

2471: EXCEPTION
2472: WHEN FND_API.G_EXC_ERROR THEN
2473: RAISE FND_API.G_EXC_ERROR;
2474: WHEN OTHERS THEN
2475: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2476: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2477: , G_MODULE_HEAD || l_routine ||'.others_exc'
2478: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2479: );

Line 2476: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2472: WHEN FND_API.G_EXC_ERROR THEN
2473: RAISE FND_API.G_EXC_ERROR;
2474: WHEN OTHERS THEN
2475: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2476: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2477: , G_MODULE_HEAD || l_routine ||'.others_exc'
2478: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2479: );
2480: END IF;

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

2541: l_cst_group_idx BINARY_INTEGER;
2542:
2543: BEGIN
2544:
2545: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2546: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2547: , G_MODULE_HEAD || l_routine ||'.begin'
2548: , l_routine || '<'
2549: );

Line 2546: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2542:
2543: BEGIN
2544:
2545: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2546: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2547: , G_MODULE_HEAD || l_routine ||'.begin'
2548: , l_routine || '<'
2549: );
2550: END IF;

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

2582: -- a complete rollback if the process errors out
2583:
2584: COMMIT;
2585:
2586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2587: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2588: , G_MODULE_HEAD || l_routine ||'.end'
2589: , l_routine || '>'
2590: );

Line 2587: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2583:
2584: COMMIT;
2585:
2586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2587: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2588: , G_MODULE_HEAD || l_routine ||'.end'
2589: , l_routine || '>'
2590: );
2591: END IF;

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

2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: RAISE FND_API.G_EXC_ERROR;
2596: WHEN OTHERS THEN
2597: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2599: , G_MODULE_HEAD || l_routine ||'.others_exc'
2600: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2601: );

Line 2598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2594: WHEN FND_API.G_EXC_ERROR THEN
2595: RAISE FND_API.G_EXC_ERROR;
2596: WHEN OTHERS THEN
2597: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2598: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2599: , G_MODULE_HEAD || l_routine ||'.others_exc'
2600: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2601: );
2602: END IF;

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

2693: l_message VARCHAR2(2000);
2694:
2695: BEGIN
2696:
2697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2699: , G_MODULE_HEAD || l_routine ||'.begin'
2700: , l_routine || '<'
2701: );

Line 2698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2694:
2695: BEGIN
2696:
2697: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2698: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2699: , G_MODULE_HEAD || l_routine ||'.begin'
2700: , l_routine || '<'
2701: );
2702: END IF;

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

2703:
2704: -- Assign Inventory Item Number
2705: l_inventory_item_number := p_inventory_item_number;
2706:
2707: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2708: FND_LOG.string(FND_LOG.LEVEL_EVENT
2709: , G_MODULE_HEAD || l_routine ||'.item'
2710: , 'Inventory Item Id:' || p_inventory_item_id ||
2711: ' Item Number:' || l_inventory_item_number

Line 2708: FND_LOG.string(FND_LOG.LEVEL_EVENT

2704: -- Assign Inventory Item Number
2705: l_inventory_item_number := p_inventory_item_number;
2706:
2707: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2708: FND_LOG.string(FND_LOG.LEVEL_EVENT
2709: , G_MODULE_HEAD || l_routine ||'.item'
2710: , 'Inventory Item Id:' || p_inventory_item_id ||
2711: ' Item Number:' || l_inventory_item_number
2712: );

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

2736: -- ======================================
2737: l_cost_group_id_idx := cost_group_item_info_row.cost_group_id;
2738: l_cost_group_name := G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
2739:
2740: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2741: FND_LOG.string(FND_LOG.LEVEL_EVENT
2742: , G_MODULE_HEAD || l_routine ||'.cgname'
2743: , 'Cost Group Index:' || l_cost_group_id_idx || ' Cost Group Name:' || l_cost_group_name ||
2744: ' Prev Itr Item Cost:' || cost_group_item_info_row.prev_itr_item_cost ||

Line 2741: FND_LOG.string(FND_LOG.LEVEL_EVENT

2737: l_cost_group_id_idx := cost_group_item_info_row.cost_group_id;
2738: l_cost_group_name := G_CST_GROUP_TBL(l_cost_group_id_idx).cost_group;
2739:
2740: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2741: FND_LOG.string(FND_LOG.LEVEL_EVENT
2742: , G_MODULE_HEAD || l_routine ||'.cgname'
2743: , 'Cost Group Index:' || l_cost_group_id_idx || ' Cost Group Name:' || l_cost_group_name ||
2744: ' Prev Itr Item Cost:' || cost_group_item_info_row.prev_itr_item_cost ||
2745: ' Curr Itr Item Cost:' || cost_group_item_info_row.item_cost

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

2785: EXCEPTION
2786: WHEN FND_API.G_EXC_ERROR THEN
2787: RAISE FND_API.G_EXC_ERROR;
2788: WHEN OTHERS THEN
2789: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2791: , G_MODULE_HEAD || l_routine ||'.others_exc'
2792: , 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num || SQLCODE || substr(SQLERRM, 1,200)
2793: );

Line 2790: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2786: WHEN FND_API.G_EXC_ERROR THEN
2787: RAISE FND_API.G_EXC_ERROR;
2788: WHEN OTHERS THEN
2789: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2791: , G_MODULE_HEAD || l_routine ||'.others_exc'
2792: , 'Item_id'||p_inventory_item_id ||'Iteration Number' ||p_iteration_num || SQLCODE || substr(SQLERRM, 1,200)
2793: );
2794: END IF;

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

2851: l_cost_group_id_idx BINARY_INTEGER;
2852: l_organization_id_idx BINARY_INTEGER;
2853:
2854: BEGIN
2855: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2856: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2857: , G_MODULE_HEAD || l_routine ||'.begin'
2858: , 'Initialize <'
2859: );

Line 2856: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2852: l_organization_id_idx BINARY_INTEGER;
2853:
2854: BEGIN
2855: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2856: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2857: , G_MODULE_HEAD || l_routine ||'.begin'
2858: , 'Initialize <'
2859: );
2860: END IF;

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

2885: INTO cst_group_row;
2886:
2887: END LOOP;
2888:
2889: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2890: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2891: , G_MODULE_HEAD || l_routine || '.valid_cost_group'
2892: , 'Number of valid cost groups in LE:' || G_CST_GROUP_TBL.COUNT
2893: );

Line 2890: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2886:
2887: END LOOP;
2888:
2889: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2890: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2891: , G_MODULE_HEAD || l_routine || '.valid_cost_group'
2892: , 'Number of valid cost groups in LE:' || G_CST_GROUP_TBL.COUNT
2893: );
2894: END IF;

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

2916: INTO cst_group_org_row;
2917:
2918: END LOOP;
2919:
2920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2921: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2922: , G_MODULE_HEAD || l_routine || '.valid_organizations'
2923: , 'Number of valid organizations:'|| G_CST_GROUP_ORG_TBL.COUNT
2924: );

Line 2921: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

2917:
2918: END LOOP;
2919:
2920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2921: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
2922: , G_MODULE_HEAD || l_routine || '.valid_organizations'
2923: , 'Number of valid organizations:'|| G_CST_GROUP_ORG_TBL.COUNT
2924: );
2925: END IF;

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

2926:
2927: CLOSE cst_group_org_cursor;
2928:
2929:
2930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2931: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2932: , G_MODULE_HEAD || l_routine ||'.end'
2933: , l_routine || '>'
2934: );

Line 2931: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2927: CLOSE cst_group_org_cursor;
2928:
2929:
2930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2931: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2932: , G_MODULE_HEAD || l_routine ||'.end'
2933: , l_routine || '>'
2934: );
2935: END IF;

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

2937: EXCEPTION
2938: WHEN FND_API.G_EXC_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: WHEN OTHERS THEN
2941: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2942: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2943: , G_MODULE_HEAD || l_routine ||'.others_exc'
2944: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2945: );

Line 2942: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

2938: WHEN FND_API.G_EXC_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: WHEN OTHERS THEN
2941: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2942: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
2943: , G_MODULE_HEAD || l_routine ||'.others_exc'
2944: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
2945: );
2946: END IF;

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

2990: l_routine CONSTANT VARCHAR2(30) := 'Populate_Temp_Tables';
2991: l_txn_type NUMBER := 0;
2992: BEGIN
2993:
2994: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2995: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2996: , G_MODULE_HEAD || l_routine ||'.begin'
2997: , l_routine || '<'
2998: );

Line 2995: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2991: l_txn_type NUMBER := 0;
2992: BEGIN
2993:
2994: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2995: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2996: , G_MODULE_HEAD || l_routine ||'.begin'
2997: , l_routine || '<'
2998: );
2999: END IF;

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

3372: AND ccga3.cost_group_id = p_cost_group_id )))))
3373: )));
3374:
3375:
3376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3378: , G_MODULE_HEAD || l_routine ||'.end'
3379: , l_routine || '>'
3380: );

Line 3377: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3373: )));
3374:
3375:
3376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3378: , G_MODULE_HEAD || l_routine ||'.end'
3379: , l_routine || '>'
3380: );
3381: END IF;

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

3383: EXCEPTION
3384: WHEN FND_API.G_EXC_ERROR THEN
3385: RAISE FND_API.G_EXC_ERROR;
3386: WHEN OTHERS THEN
3387: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3389: , G_MODULE_HEAD || l_routine ||'.others_exc'
3390: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3391: );

Line 3388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

3384: WHEN FND_API.G_EXC_ERROR THEN
3385: RAISE FND_API.G_EXC_ERROR;
3386: WHEN OTHERS THEN
3387: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3388: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3389: , G_MODULE_HEAD || l_routine ||'.others_exc'
3390: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3391: );
3392: END IF;

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

3784: l_cg_idx BINARY_INTEGER;
3785:
3786: BEGIN
3787:
3788: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3790: , G_MODULE_HEAD || l_routine ||'.begin'
3791: , l_routine || '<'
3792: );

Line 3789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3785:
3786: BEGIN
3787:
3788: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3789: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3790: , G_MODULE_HEAD || l_routine ||'.begin'
3791: , l_routine || '<'
3792: );
3793: END IF;

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

3869: l_cg_idx := p_cost_group_id;
3870: G_CST_GROUP_TBL(l_cg_idx).period_new_quantity := l_period_qty_bef_intorg;
3871:
3872:
3873: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3875: , G_MODULE_HEAD || l_routine ||'.cgpd1'
3876: , 'G_CST_GROUP_TBL Cost Group Id:' || p_cost_group_id || ' Inventory Item Id:' || p_inventory_item_id ||
3877: ' Period Quantity Before Inter org:' || G_CST_GROUP_TBL(l_cg_idx).period_new_quantity

Line 3874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3870: G_CST_GROUP_TBL(l_cg_idx).period_new_quantity := l_period_qty_bef_intorg;
3871:
3872:
3873: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3874: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3875: , G_MODULE_HEAD || l_routine ||'.cgpd1'
3876: , 'G_CST_GROUP_TBL Cost Group Id:' || p_cost_group_id || ' Inventory Item Id:' || p_inventory_item_id ||
3877: ' Period Quantity Before Inter org:' || G_CST_GROUP_TBL(l_cg_idx).period_new_quantity
3878: );

Line 3880: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

3876: , 'G_CST_GROUP_TBL Cost Group Id:' || p_cost_group_id || ' Inventory Item Id:' || p_inventory_item_id ||
3877: ' Period Quantity Before Inter org:' || G_CST_GROUP_TBL(l_cg_idx).period_new_quantity
3878: );
3879:
3880: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
3881: , G_MODULE_HEAD || l_routine ||'.cgpd2'
3882: , 'G_PWAC_NEW_COST_TBL Cost Group Id:' || p_cost_group_id || ' Inventory Item Id:' || p_inventory_item_id ||
3883: ' Period Qty Before Inter org:' || G_PWAC_NEW_COST_TBL(1)(1).period_qty_bef_intorg
3884: );

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

3885:
3886: END IF;
3887:
3888:
3889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3890: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3891: , G_MODULE_HEAD || l_routine ||'.end'
3892: , l_routine || '>'
3893: );

Line 3890: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

3886: END IF;
3887:
3888:
3889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3890: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
3891: , G_MODULE_HEAD || l_routine ||'.end'
3892: , l_routine || '>'
3893: );
3894: END IF;

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

3897: EXCEPTION
3898: WHEN FND_API.G_EXC_ERROR THEN
3899: RAISE FND_API.G_EXC_ERROR;
3900: WHEN OTHERS THEN
3901: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3902: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3903: , G_MODULE_HEAD || l_routine ||'.others_exc'
3904: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3905: );

Line 3902: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

3898: WHEN FND_API.G_EXC_ERROR THEN
3899: RAISE FND_API.G_EXC_ERROR;
3900: WHEN OTHERS THEN
3901: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3902: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
3903: , G_MODULE_HEAD || l_routine ||'.others_exc'
3904: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
3905: );
3906: END IF;

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

4019: FOR i IN 1..l_loop_count
4020: LOOP
4021:
4022:
4023: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4024: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4025: ,G_MODULE_HEAD || l_routine || '.costinvtxn_gp1'
4026: ,'Transaction Id:'|| l_group1_interorg_tab(i).transaction_id ||
4027: ' Primary Qty:' || l_group1_interorg_tab(i).primary_quantity

Line 4024: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4020: LOOP
4021:
4022:
4023: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4024: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4025: ,G_MODULE_HEAD || l_routine || '.costinvtxn_gp1'
4026: ,'Transaction Id:'|| l_group1_interorg_tab(i).transaction_id ||
4027: ' Primary Qty:' || l_group1_interorg_tab(i).primary_quantity
4028: );

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

4034: l_group1_interorg_tab(i).exp_flag := 1;
4035: END IF;
4036:
4037:
4038: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4039: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4040: ,G_MODULE_HEAD || l_routine || '.exp_flag'
4041: ,'Expense Flag:'|| l_group1_interorg_tab(i).exp_flag ||
4042: ' Expense Item:' || l_group1_interorg_tab(i).exp_item

Line 4039: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4035: END IF;
4036:
4037:
4038: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4039: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4040: ,G_MODULE_HEAD || l_routine || '.exp_flag'
4041: ,'Expense Flag:'|| l_group1_interorg_tab(i).exp_flag ||
4042: ' Expense Item:' || l_group1_interorg_tab(i).exp_item
4043: );

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

4057: ,o_err_num => l_error_num
4058: ,o_err_code => l_error_code
4059: ,o_err_msg => l_error_msg
4060: );
4061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4062: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4063: ,G_MODULE_HEAD || l_routine || '.incppbir1'
4064: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4065: );

Line 4062: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4058: ,o_err_code => l_error_code
4059: ,o_err_msg => l_error_msg
4060: );
4061: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4062: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4063: ,G_MODULE_HEAD || l_routine || '.incppbir1'
4064: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4065: );
4066: END IF;

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

4099: , o_err_code => l_error_code
4100: , o_err_msg => l_error_msg
4101: );
4102:
4103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4104: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4105: ,G_MODULE_HEAD || l_routine || '.PAC_inv_Processor_gp1'
4106: ,'PAC Inventory Processor:'|| l_error_num || ' ' ||
4107: l_error_code || ' ' || l_error_msg

Line 4104: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4100: , o_err_msg => l_error_msg
4101: );
4102:
4103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4104: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4105: ,G_MODULE_HEAD || l_routine || '.PAC_inv_Processor_gp1'
4106: ,'PAC Inventory Processor:'|| l_error_num || ' ' ||
4107: l_error_code || ' ' || l_error_msg
4108: );

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

4111:
4112: END IF; -- error num check
4113:
4114: IF l_error_num <> 0 THEN
4115: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4116: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4117: , G_MODULE_HEAD || l_routine || '.others'
4118: , 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4119: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg

Line 4116: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

4112: END IF; -- error num check
4113:
4114: IF l_error_num <> 0 THEN
4115: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4116: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4117: , G_MODULE_HEAD || l_routine || '.others'
4118: , 'group1 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4119: || l_group1_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4120: );

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

4176: AND cost_group_id = p_cost_group_id
4177: AND pac_period_id = p_period_id
4178: AND cost_type_id = p_cost_type_id;
4179:
4180: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4182: ,G_MODULE_HEAD || l_routine || '.After_ins_MPACD_TEMP'
4183: ,'After inserting mtl_pac_act_cst_dtl_temp:'||
4184: l_group1_interorg_tab(i).transaction_id

Line 4181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4177: AND pac_period_id = p_period_id
4178: AND cost_type_id = p_cost_type_id;
4179:
4180: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4182: ,G_MODULE_HEAD || l_routine || '.After_ins_MPACD_TEMP'
4183: ,'After inserting mtl_pac_act_cst_dtl_temp:'||
4184: l_group1_interorg_tab(i).transaction_id
4185: );

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

4243: AND mpacdt.cost_type_id = p_cost_type_id
4244: AND mpacdt.cost_element_id = cce.cost_element_id
4245: AND mpacdt.level_type = lt.level_type);
4246:
4247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4249: ,G_MODULE_HEAD || l_routine || '.After_pad_MPACD_TEMP'
4250: ,'After padding mtl_pac_act_cst_dtl_temp:'||
4251: l_group1_interorg_tab(i).transaction_id

Line 4248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4244: AND mpacdt.cost_element_id = cce.cost_element_id
4245: AND mpacdt.level_type = lt.level_type);
4246:
4247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4249: ,G_MODULE_HEAD || l_routine || '.After_pad_MPACD_TEMP'
4250: ,'After padding mtl_pac_act_cst_dtl_temp:'||
4251: l_group1_interorg_tab(i).transaction_id
4252: );

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

4288: l_error_num := NVL(l_error_num, 0);
4289: l_error_code := NVL(l_error_code, 'No Error');
4290: l_error_msg := NVL(l_error_msg, 'No Error');
4291:
4292: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4294: ,G_MODULE_HEAD || l_routine || '.inscppir2'
4295: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4296: );

Line 4293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4289: l_error_code := NVL(l_error_code, 'No Error');
4290: l_error_msg := NVL(l_error_msg, 'No Error');
4291:
4292: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4294: ,G_MODULE_HEAD || l_routine || '.inscppir2'
4295: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4296: );
4297: END IF;

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

4325: l_error_code := NVL(l_error_code, 'No Error');
4326: l_error_msg := NVL(l_error_msg, 'No Error');
4327:
4328:
4329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4330: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4331: ,G_MODULE_HEAD || l_routine || '.calcpmac'
4332: ,'After calling calculate_periodic_cost:'|| l_error_num || l_error_code || l_error_msg
4333: );

Line 4330: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4326: l_error_msg := NVL(l_error_msg, 'No Error');
4327:
4328:
4329: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4330: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4331: ,G_MODULE_HEAD || l_routine || '.calcpmac'
4332: ,'After calling calculate_periodic_cost:'|| l_error_num || l_error_code || l_error_msg
4333: );
4334: END IF;

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

4506: ELSIF (l_group2_interorg_tab(i).exp_item = 1) THEN
4507: l_group2_interorg_tab(i).exp_flag := 1;
4508: END IF;
4509:
4510: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4512: ,G_MODULE_HEAD || l_routine || '.exp_flag'
4513: ,'Exp Flag:' || l_group2_interorg_tab(i).exp_flag || ' ' ||
4514: 'Exp Item:' || l_group2_interorg_tab(i).exp_item

Line 4511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4507: l_group2_interorg_tab(i).exp_flag := 1;
4508: END IF;
4509:
4510: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4512: ,G_MODULE_HEAD || l_routine || '.exp_flag'
4513: ,'Exp Flag:' || l_group2_interorg_tab(i).exp_flag || ' ' ||
4514: 'Exp Item:' || l_group2_interorg_tab(i).exp_item
4515: );

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

4530: ,o_err_num => l_error_num
4531: ,o_err_code => l_error_code
4532: ,o_err_msg => l_error_msg
4533: );
4534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4536: ,G_MODULE_HEAD || l_routine || '.incppbii1'
4537: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4538: );

Line 4535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4531: ,o_err_code => l_error_code
4532: ,o_err_msg => l_error_msg
4533: );
4534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4536: ,G_MODULE_HEAD || l_routine || '.incppbii1'
4537: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4538: );
4539: END IF;

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

4572: , o_err_code => l_error_code
4573: , o_err_msg => l_error_msg
4574: );
4575:
4576: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4578: ,G_MODULE_HEAD || l_routine || '.PAC_inv_Processor_gp2'
4579: ,'PAC Inventory Processor:'|| l_error_num || ' ' ||
4580: l_error_code || ' ' || l_error_msg

Line 4577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4573: , o_err_msg => l_error_msg
4574: );
4575:
4576: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4578: ,G_MODULE_HEAD || l_routine || '.PAC_inv_Processor_gp2'
4579: ,'PAC Inventory Processor:'|| l_error_num || ' ' ||
4580: l_error_code || ' ' || l_error_msg
4581: );

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

4584:
4585: END IF; -- error num check
4586:
4587: IF l_error_num <> 0 THEN
4588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4589: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4590: , G_MODULE_HEAD || l_routine || '.others'
4591: , 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4592: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg

Line 4589: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

4585: END IF; -- error num check
4586:
4587: IF l_error_num <> 0 THEN
4588: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4589: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4590: , G_MODULE_HEAD || l_routine || '.others'
4591: , 'group2 cost_inv_txn for cost group '|| p_cost_group_id ||' txn id '
4592: || l_group2_interorg_tab(i).transaction_id||' ('||l_error_code||') '||l_error_msg
4593: );

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

4647: AND cost_group_id = p_cost_group_id
4648: AND pac_period_id = p_period_id
4649: AND cost_type_id = p_cost_type_id;
4650:
4651: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4653: ,G_MODULE_HEAD || l_routine || '.after_ins_gp2'
4654: ,'After inserting mtl_pac_act_cst_dtl_temp:' ||
4655: l_group2_interorg_tab(i).transaction_id

Line 4652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4648: AND pac_period_id = p_period_id
4649: AND cost_type_id = p_cost_type_id;
4650:
4651: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4653: ,G_MODULE_HEAD || l_routine || '.after_ins_gp2'
4654: ,'After inserting mtl_pac_act_cst_dtl_temp:' ||
4655: l_group2_interorg_tab(i).transaction_id
4656: );

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

4713: AND mpacdt.cost_element_id = cce.cost_element_id
4714: AND mpacdt.level_type = lt.level_type);
4715:
4716:
4717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4719: ,G_MODULE_HEAD || l_routine || '.after_pad_gp2'
4720: ,'After padding mtl_pac_act_cst_dtl_temp:'||
4721: l_group2_interorg_tab(i).transaction_id

Line 4718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4714: AND mpacdt.level_type = lt.level_type);
4715:
4716:
4717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4719: ,G_MODULE_HEAD || l_routine || '.after_pad_gp2'
4720: ,'After padding mtl_pac_act_cst_dtl_temp:'||
4721: l_group2_interorg_tab(i).transaction_id
4722: );

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

4753: l_error_num := NVL(l_error_num, 0);
4754: l_error_code := NVL(l_error_code, 'No Error');
4755: l_error_msg := NVL(l_error_msg, 'No Error');
4756:
4757: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4758: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4759: ,G_MODULE_HEAD || l_routine || '.inscppii2'
4760: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4761: );

Line 4758: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4754: l_error_code := NVL(l_error_code, 'No Error');
4755: l_error_msg := NVL(l_error_msg, 'No Error');
4756:
4757: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4758: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4759: ,G_MODULE_HEAD || l_routine || '.inscppii2'
4760: ,'After calling insert_into_cppb:'|| l_error_num || l_error_code || l_error_msg
4761: );
4762: END IF;

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

4780: l_error_num := NVL(l_error_num, 0);
4781: l_error_code := NVL(l_error_code, 'No Error');
4782: l_error_msg := NVL(l_error_msg, 'No Error');
4783:
4784: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4785: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4786: ,G_MODULE_HEAD || l_routine || '.upppii1'
4787: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
4788: );

Line 4785: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

4781: l_error_code := NVL(l_error_code, 'No Error');
4782: l_error_msg := NVL(l_error_msg, 'No Error');
4783:
4784: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4785: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4786: ,G_MODULE_HEAD || l_routine || '.upppii1'
4787: ,'After calling update_item_cppb:'|| l_error_num || l_error_code || l_error_msg
4788: );
4789: END IF;

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

4789: END IF;
4790: END IF; -- error check
4791:
4792: IF l_error_num <> 0 THEN
4793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4795: , G_MODULE_HEAD || l_routine || '.others'
4796: , 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4797: ||l_txn_category||' t_low_level_code ' ||p_low_level_code

Line 4794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

4790: END IF; -- error check
4791:
4792: IF l_error_num <> 0 THEN
4793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
4795: , G_MODULE_HEAD || l_routine || '.others'
4796: , 'CSTPPWAC.update_item_cppb for CG '|| p_cost_group_id ||' txn category '
4797: ||l_txn_category||' t_low_level_code ' ||p_low_level_code
4798: ||' error('||l_error_code||') '||l_error_msg

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

5078: -- inventory item, cost group, pac period
5079: -- =========================================================================
5080: l_period_quantity := G_PWAC_NEW_COST_TBL(1)(1).period_qty_bef_intorg;
5081:
5082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5084: ,G_MODULE_HEAD || l_routine || '.qtybef'
5085: ,'Qty before intorg txns:' || l_period_quantity
5086: );

Line 5083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5079: -- =========================================================================
5080: l_period_quantity := G_PWAC_NEW_COST_TBL(1)(1).period_qty_bef_intorg;
5081:
5082: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5083: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5084: ,G_MODULE_HEAD || l_routine || '.qtybef'
5085: ,'Qty before intorg txns:' || l_period_quantity
5086: );
5087: END IF;

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

5118: l_loop_count := l_group1_interorg_tab.count;
5119:
5120: FOR i IN 1..l_loop_count
5121: LOOP
5122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5124: ,G_MODULE_HEAD || l_routine || '.group1_interorg'
5125: ,'Group 1 -- Transaction Id:'|| l_group1_interorg_tab(i).transaction_id
5126: );

Line 5123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5119:
5120: FOR i IN 1..l_loop_count
5121: LOOP
5122: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5124: ,G_MODULE_HEAD || l_routine || '.group1_interorg'
5125: ,'Group 1 -- Transaction Id:'|| l_group1_interorg_tab(i).transaction_id
5126: );
5127: END IF;

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

5131: ELSIF (l_group1_interorg_tab(i).exp_item = 1) THEN
5132: l_group1_interorg_tab(i).exp_flag := 1;
5133: END IF;
5134:
5135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5137: ,G_MODULE_HEAD || l_routine || '.exp_flag'
5138: ,'Expense Flag:'|| l_group1_interorg_tab(i).exp_flag ||
5139: ' Expense Item:' || l_group1_interorg_tab(i).exp_item

Line 5136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5132: l_group1_interorg_tab(i).exp_flag := 1;
5133: END IF;
5134:
5135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5137: ,G_MODULE_HEAD || l_routine || '.exp_flag'
5138: ,'Expense Flag:'|| l_group1_interorg_tab(i).exp_flag ||
5139: ' Expense Item:' || l_group1_interorg_tab(i).exp_item
5140: );

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

5205:
5206:
5207: WHILE pac_txn_cursor%FOUND LOOP
5208:
5209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5210: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5211: ,G_MODULE_HEAD || l_routine || '.pac_txn_cursor'
5212: ,'Cost element Id:' || l_cost_element_id || ' '
5213: || 'Level Type:' || l_level_type

Line 5210: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5206:
5207: WHILE pac_txn_cursor%FOUND LOOP
5208:
5209: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5210: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5211: ,G_MODULE_HEAD || l_routine || '.pac_txn_cursor'
5212: ,'Cost element Id:' || l_cost_element_id || ' '
5213: || 'Level Type:' || l_level_type
5214: );

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

5249: ,p_transaction_action_id => l_group1_interorg_tab(i).transaction_action_id
5250: ,p_group_num => 1
5251: ,x_correspond_pmac_cost => l_correspond_pmac_cost);
5252:
5253: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5255: ,G_MODULE_HEAD || l_routine || '.corr_pmac'
5256: ,'Correspond PMAC Cost:' || l_correspond_pmac_cost
5257: );

Line 5254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5250: ,p_group_num => 1
5251: ,x_correspond_pmac_cost => l_correspond_pmac_cost);
5252:
5253: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5255: ,G_MODULE_HEAD || l_routine || '.corr_pmac'
5256: ,'Correspond PMAC Cost:' || l_correspond_pmac_cost
5257: );
5258: END IF;

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

5268: l_unit_transfer_cost := l_transfer_cost / l_txn_quantity;
5269:
5270: END IF; -- IF l_group1_idx.transfer_percentage <> 0 THEN
5271:
5272: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5273: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5274: ,G_MODULE_HEAD || l_routine || '.txfr_cost1'
5275: ,'Transaction Qty:' || l_txn_quantity || ' Transfer Percentage:' || l_group1_interorg_tab(i).transfer_percentage || ' Unit Transfer Cost:' || l_unit_transfer_cost
5276: );

Line 5273: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5269:
5270: END IF; -- IF l_group1_idx.transfer_percentage <> 0 THEN
5271:
5272: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5273: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5274: ,G_MODULE_HEAD || l_routine || '.txfr_cost1'
5275: ,'Transaction Qty:' || l_txn_quantity || ' Transfer Percentage:' || l_group1_interorg_tab(i).transfer_percentage || ' Unit Transfer Cost:' || l_unit_transfer_cost
5276: );
5277: END IF;

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

5293: (transportation_cost/l_txn_quantity) + moh_absorption_cost), l_new_correspond_cost),l_new_correspond_cost)
5294: , transfer_cost = DECODE(cost_element_id, 2, decode(level_type,1, l_unit_transfer_cost,0),0)
5295: WHERE CURRENT OF pac_txn_cursor;
5296:
5297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5298: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5299: ,G_MODULE_HEAD || l_routine || '.upd_with_new_cost'
5300: ,'New Cost of corresponding transaction:' || l_new_correspond_cost
5301: );

Line 5298: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5294: , transfer_cost = DECODE(cost_element_id, 2, decode(level_type,1, l_unit_transfer_cost,0),0)
5295: WHERE CURRENT OF pac_txn_cursor;
5296:
5297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5298: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5299: ,G_MODULE_HEAD || l_routine || '.upd_with_new_cost'
5300: ,'New Cost of corresponding transaction:' || l_new_correspond_cost
5301: );
5302:

Line 5303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5299: ,G_MODULE_HEAD || l_routine || '.upd_with_new_cost'
5300: ,'New Cost of corresponding transaction:' || l_new_correspond_cost
5301: );
5302:
5303: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5304: ,G_MODULE_HEAD || l_routine || '.transmohcost'
5305: ,'Transfer Cost:' || pac_txn_cursor_row.transfer_cost
5306: || ' Transportation Cost:' || pac_txn_cursor_row.transportation_cost || ' Transaction Qty:' || abs(l_group1_interorg_tab(i).primary_quantity) || ' MOH Absorption Cost:' || pac_txn_cursor_row.moh_absorption_cost
5307: );

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

5314: -- inventory item id, cost group, pac period
5315: -- ===============================================================================
5316:
5317:
5318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5319: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5320: ,G_MODULE_HEAD || l_routine || '.pac_txn_cursor_first'
5321: ,'Cost element Id:' || l_cost_element_id || ' '
5322: || 'Level Type:' || l_level_type

Line 5319: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5315: -- ===============================================================================
5316:
5317:
5318: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5319: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5320: ,G_MODULE_HEAD || l_routine || '.pac_txn_cursor_first'
5321: ,'Cost element Id:' || l_cost_element_id || ' '
5322: || 'Level Type:' || l_level_type
5323: );

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

5347: -- cumulate the running balance for cost element,level type
5348: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance :=
5349: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance + l_txn_qty * l_actual_cost;
5350:
5351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5353: ,G_MODULE_HEAD || l_routine || '.newbal'
5354: ,'New balance before PCU value change:' || G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance
5355: );

Line 5352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5348: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance :=
5349: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance + l_txn_qty * l_actual_cost;
5350:
5351: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5353: ,G_MODULE_HEAD || l_routine || '.newbal'
5354: ,'New balance before PCU value change:' || G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance
5355: );
5356: END IF;

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

5395: -- ============================================================
5396: -- Re-average to calculate the new periodic moving average cost
5397: -- of the item in each cost element, level type
5398: -- ============================================================
5399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5401: ,G_MODULE_HEAD || l_routine || '.qtyaft'
5402: ,'Period Quantity after interorg receipts:'|| l_period_quantity
5403: );

Line 5400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5396: -- Re-average to calculate the new periodic moving average cost
5397: -- of the item in each cost element, level type
5398: -- ============================================================
5399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5401: ,G_MODULE_HEAD || l_routine || '.qtyaft'
5402: ,'Period Quantity after interorg receipts:'|| l_period_quantity
5403: );
5404: END IF;

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

5425: ELSE
5426: l_pcu_value_balance := 0;
5427: END IF;
5428:
5429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5431: ,G_MODULE_HEAD || l_routine || '.pcuvalbal'
5432: ,'PCU value change balance: CG-element-level' || l_cg_elmnt_lv_idx || ' '
5433: || l_pcu_value_balance

Line 5430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5426: l_pcu_value_balance := 0;
5427: END IF;
5428:
5429: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5431: ,G_MODULE_HEAD || l_routine || '.pcuvalbal'
5432: ,'PCU value change balance: CG-element-level' || l_cg_elmnt_lv_idx || ' '
5433: || l_pcu_value_balance
5434: );

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

5440: -- ===========================================================================
5441: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance :=
5442: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance + l_pcu_value_balance;
5443:
5444: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5446: ,G_MODULE_HEAD || l_routine || '.newpcuval'
5447: ,'New balance after PCU value change:' || G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance
5448: );

Line 5445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5441: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance :=
5442: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance + l_pcu_value_balance;
5443:
5444: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5446: ,G_MODULE_HEAD || l_routine || '.newpcuval'
5447: ,'New balance after PCU value change:' || G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance
5448: );
5449: END IF;

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

5460: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).final_new_cost
5461: := l_period_new_balance / l_period_quantity;
5462: END IF;
5463:
5464: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5465: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5466: ,G_MODULE_HEAD || l_routine || '.pdnewbal'
5467: ,'Cost Element Id:' || l_cost_element_id || ' Level Type:'
5468: || l_level_type || 'Period New Balance:'|| l_period_new_balance

Line 5465: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5461: := l_period_new_balance / l_period_quantity;
5462: END IF;
5463:
5464: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5465: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5466: ,G_MODULE_HEAD || l_routine || '.pdnewbal'
5467: ,'Cost Element Id:' || l_cost_element_id || ' Level Type:'
5468: || l_level_type || 'Period New Balance:'|| l_period_new_balance
5469: );

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

5494: l_cost_element_id := l_cost_element_id + 1;
5495: END LOOP;
5496:
5497:
5498: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5500: , G_MODULE_HEAD || l_routine || '.pwacic'
5501: , 'Cost Group Id:' || p_cost_group_id || 'PWAC Item Cost:' || l_pwac_item_cost
5502: );

Line 5499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5495: END LOOP;
5496:
5497:
5498: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5500: , G_MODULE_HEAD || l_routine || '.pwacic'
5501: , 'Cost Group Id:' || p_cost_group_id || 'PWAC Item Cost:' || l_pwac_item_cost
5502: );
5503: END IF;

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

5615: G_CG_PWAC_COST_TBL(l_cg_pwac_idx).final_new_cost := G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).final_new_cost;
5616:
5617: G_CG_PWAC_COST_TBL(l_cg_pwac_idx).period_new_balance := G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance;
5618:
5619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5621: , G_MODULE_HEAD || l_routine || '.fncpnb'
5622: , 'Cost Group Element Level idx:' || l_cg_pwac_idx || ' CG PWAC final new cost:' || G_CG_PWAC_COST_TBL(l_cg_pwac_idx).final_new_cost || ' CG PWAC period new balance:' || G_CG_PWAC_COST_TBL(l_cg_pwac_idx).period_new_balance
5623: );

Line 5620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

5616:
5617: G_CG_PWAC_COST_TBL(l_cg_pwac_idx).period_new_balance := G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance;
5618:
5619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5620: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
5621: , G_MODULE_HEAD || l_routine || '.fncpnb'
5622: , 'Cost Group Element Level idx:' || l_cg_pwac_idx || ' CG PWAC final new cost:' || G_CG_PWAC_COST_TBL(l_cg_pwac_idx).final_new_cost || ' CG PWAC period new balance:' || G_CG_PWAC_COST_TBL(l_cg_pwac_idx).period_new_balance
5623: );
5624: END IF;

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

5643: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
5644: WHEN FND_API.G_EXC_ERROR THEN
5645: RAISE FND_API.G_EXC_ERROR;
5646: WHEN OTHERS THEN
5647: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5648: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5649: , G_MODULE_HEAD || l_routine ||'.others_exc'
5650: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
5651: );

Line 5648: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION

5644: WHEN FND_API.G_EXC_ERROR THEN
5645: RAISE FND_API.G_EXC_ERROR;
5646: WHEN OTHERS THEN
5647: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5648: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION
5649: , G_MODULE_HEAD || l_routine ||'.others_exc'
5650: , 'others:' || SQLCODE || substr(SQLERRM, 1,200)
5651: );
5652: END IF;

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

5816:
5817: l_low_level_code_exist NUMBER;
5818:
5819: BEGIN
5820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5822: , G_MODULE_HEAD || l_routine ||'.begin'
5823: , l_routine || '<'
5824: );

Line 5821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

5817: l_low_level_code_exist NUMBER;
5818:
5819: BEGIN
5820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
5822: , G_MODULE_HEAD || l_routine ||'.begin'
5823: , l_routine || '<'
5824: );
5825: END IF;

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

5829: -- =======================
5830: -- API body
5831: -- =======================
5832:
5833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5834: FND_LOG.string(FND_LOG.LEVEL_EVENT
5835: , G_MODULE_HEAD || l_routine || '.before_set_process'
5836: , 'Before Set Process Status'
5837: );

Line 5834: FND_LOG.string(FND_LOG.LEVEL_EVENT

5830: -- API body
5831: -- =======================
5832:
5833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5834: FND_LOG.string(FND_LOG.LEVEL_EVENT
5835: , G_MODULE_HEAD || l_routine || '.before_set_process'
5836: , 'Before Set Process Status'
5837: );
5838: END IF;

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

5851: , p_period_end_date => p_end_date
5852: , p_phase_status => 2
5853: );
5854:
5855: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5856: FND_LOG.string(FND_LOG.LEVEL_EVENT
5857: , G_MODULE_HEAD || l_routine || '.Before_iteration_loop'
5858: , 'Before Iteration Loop'
5859: );

Line 5856: FND_LOG.string(FND_LOG.LEVEL_EVENT

5852: , p_phase_status => 2
5853: );
5854:
5855: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5856: FND_LOG.string(FND_LOG.LEVEL_EVENT
5857: , G_MODULE_HEAD || l_routine || '.Before_iteration_loop'
5858: , 'Before Iteration Loop'
5859: );
5860: END IF;

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

5891: l_end_iteration_num := l_prev_iteration_count + 1;
5892: END IF;
5893:
5894:
5895: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5896: FND_LOG.string(FND_LOG.LEVEL_EVENT
5897: ,G_MODULE_HEAD || l_routine || '.iteration_num_range'
5898: ,'Starting Iteration Number:'|| l_start_iteration_num
5899: || ' Ending Iteration Number:' || l_end_iteration_num

Line 5896: FND_LOG.string(FND_LOG.LEVEL_EVENT

5892: END IF;
5893:
5894:
5895: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5896: FND_LOG.string(FND_LOG.LEVEL_EVENT
5897: ,G_MODULE_HEAD || l_routine || '.iteration_num_range'
5898: ,'Starting Iteration Number:'|| l_start_iteration_num
5899: || ' Ending Iteration Number:' || l_end_iteration_num
5900: );

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

5899: || ' Ending Iteration Number:' || l_end_iteration_num
5900: );
5901: END IF;
5902:
5903: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5904: FND_LOG.string(FND_LOG.LEVEL_EVENT
5905: ,G_MODULE_HEAD || l_routine || '.Item'
5906: ,'Inventory Item Id:'|| p_inventory_item_id
5907: );

Line 5904: FND_LOG.string(FND_LOG.LEVEL_EVENT

5900: );
5901: END IF;
5902:
5903: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5904: FND_LOG.string(FND_LOG.LEVEL_EVENT
5905: ,G_MODULE_HEAD || l_routine || '.Item'
5906: ,'Inventory Item Id:'|| p_inventory_item_id
5907: );
5908: END IF;

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

5981:
5982: -- Assign iteration number
5983: l_iteration_num := l_iteration_num_idx;
5984:
5985: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5986: FND_LOG.string(FND_LOG.LEVEL_EVENT
5987: ,G_MODULE_HEAD || l_routine || '.iteration'
5988: ,'ITERATION NUMBER:'|| l_iteration_num
5989: );

Line 5986: FND_LOG.string(FND_LOG.LEVEL_EVENT

5982: -- Assign iteration number
5983: l_iteration_num := l_iteration_num_idx;
5984:
5985: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5986: FND_LOG.string(FND_LOG.LEVEL_EVENT
5987: ,G_MODULE_HEAD || l_routine || '.iteration'
5988: ,'ITERATION NUMBER:'|| l_iteration_num
5989: );
5990: END IF;

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

6008: ELSE
6009: t_low_level_code := l_optimal_cg_idx.low_level_code;
6010: END IF;
6011:
6012: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6013: FND_LOG.string(FND_LOG.LEVEL_EVENT
6014: ,G_MODULE_HEAD || l_routine || '.tlevel'
6015: ,'Completion or no completion level:' || t_low_level_code
6016: );

Line 6013: FND_LOG.string(FND_LOG.LEVEL_EVENT

6009: t_low_level_code := l_optimal_cg_idx.low_level_code;
6010: END IF;
6011:
6012: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6013: FND_LOG.string(FND_LOG.LEVEL_EVENT
6014: ,G_MODULE_HEAD || l_routine || '.tlevel'
6015: ,'Completion or no completion level:' || t_low_level_code
6016: );
6017: END IF;

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

6138: G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).cost_group_id := pcu_idx.cost_group_id;
6139: G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).cost_element_id := pcu_idx.cost_element_id;
6140: G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).level_type := pcu_idx.level_type;
6141:
6142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6143: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
6144: , G_MODULE_HEAD || l_routine ||'.cgellvic'
6145: , 'PCU Value Change :Cost Group element level idx:' || l_cg_elmt_lv_idx ||
6146: 'Balance:' || G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).pcu_value_balance

Line 6143: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

6139: G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).cost_element_id := pcu_idx.cost_element_id;
6140: G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).level_type := pcu_idx.level_type;
6141:
6142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6143: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
6144: , G_MODULE_HEAD || l_routine ||'.cgellvic'
6145: , 'PCU Value Change :Cost Group element level idx:' || l_cg_elmt_lv_idx ||
6146: 'Balance:' || G_PCU_VALUE_CHANGE_TBL(l_cg_elmt_lv_idx).pcu_value_balance
6147: );

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

6294: AND pac_period_id = p_period_id
6295: AND diverging_flag <> 'Y';
6296:
6297:
6298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
6300: , G_MODULE_HEAD || l_routine || '.upd_tolerance_flag'
6301: , 'Tolerance Flag:' || l_tolerance_flag || ' ' ||
6302: 'Inventory Item Id:' || l_inventory_item_id

Line 6299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT

6295: AND diverging_flag <> 'Y';
6296:
6297:
6298: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
6300: , G_MODULE_HEAD || l_routine || '.upd_tolerance_flag'
6301: , 'Tolerance Flag:' || l_tolerance_flag || ' ' ||
6302: 'Inventory Item Id:' || l_inventory_item_id
6303: );

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

6335: -- before exiting the above loop.
6336:
6337: IF l_tolerance_flag <> 'Y' THEN
6338:
6339: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6340: FND_LOG.string(FND_LOG.LEVEL_EVENT
6341: , G_MODULE_HEAD || l_routine || '.upd_final_iteration'
6342: , 'Final Iteration for the item:' || l_inventory_item_id
6343: );

Line 6340: FND_LOG.string(FND_LOG.LEVEL_EVENT

6336:
6337: IF l_tolerance_flag <> 'Y' THEN
6338:
6339: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6340: FND_LOG.string(FND_LOG.LEVEL_EVENT
6341: , G_MODULE_HEAD || l_routine || '.upd_final_iteration'
6342: , 'Final Iteration for the item:' || l_inventory_item_id
6343: );
6344: END IF;

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

6383:
6384: END IF; -- run option check
6385:
6386:
6387: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6388: FND_LOG.string(FND_LOG.LEVEL_EVENT
6389: , G_MODULE_HEAD || l_routine || '.After_iteration_loop'
6390: , 'After Iteration Loop'
6391: );

Line 6388: FND_LOG.string(FND_LOG.LEVEL_EVENT

6384: END IF; -- run option check
6385:
6386:
6387: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6388: FND_LOG.string(FND_LOG.LEVEL_EVENT
6389: , G_MODULE_HEAD || l_routine || '.After_iteration_loop'
6390: , 'After Iteration Loop'
6391: );
6392: END IF;

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

6400: G_PCU_VALUE_CHANGE_TBL.delete;
6401:
6402: END IF; -- interorg items found check
6403:
6404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6405: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6406: , G_MODULE_HEAD || l_routine ||'.end'
6407: , l_routine || '>'
6408: );

Line 6405: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

6401:
6402: END IF; -- interorg items found check
6403:
6404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6405: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
6406: , G_MODULE_HEAD || l_routine ||'.end'
6407: , l_routine || '>'
6408: );
6409: END IF;