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.CTO_CONFIG_COST_PK dependencies on OE_DEBUG_PUB

Line 29: oe_debug_pub.add( 'Inside cost_update_required ' ,1 ) ;

25:
26:
27: begin
28: IF PG_DEBUG <> 0 THEN
29: oe_debug_pub.add( 'Inside cost_update_required ' ,1 ) ;
30: END IF;
31:
32: OPEN cost_details(p_config_item_id, p_organization_id, 1);
33: FETCH cost_details INTO v_cost_details_frozen;

Line 36: oe_debug_pub.add( 'v_cost_details_frozen ' ,1 ) ;

32: OPEN cost_details(p_config_item_id, p_organization_id, 1);
33: FETCH cost_details INTO v_cost_details_frozen;
34:
35: IF PG_DEBUG <> 0 THEN
36: oe_debug_pub.add( 'v_cost_details_frozen ' ,1 ) ;
37: oe_debug_pub.add( ' iid ' || v_cost_details_frozen.inventory_item_id ||
38: ' org ' || to_char( v_cost_details_frozen.organization_id) ||
39: ' cstyp ' || to_char( v_cost_details_frozen.cost_type_id) ||
40: ' icst ' || to_char( v_cost_details_frozen.item_cost ) ||

Line 37: oe_debug_pub.add( ' iid ' || v_cost_details_frozen.inventory_item_id ||

33: FETCH cost_details INTO v_cost_details_frozen;
34:
35: IF PG_DEBUG <> 0 THEN
36: oe_debug_pub.add( 'v_cost_details_frozen ' ,1 ) ;
37: oe_debug_pub.add( ' iid ' || v_cost_details_frozen.inventory_item_id ||
38: ' org ' || to_char( v_cost_details_frozen.organization_id) ||
39: ' cstyp ' || to_char( v_cost_details_frozen.cost_type_id) ||
40: ' icst ' || to_char( v_cost_details_frozen.item_cost ) ||
41: ' mcst ' || to_char( v_cost_details_frozen.material_cost ) ||

Line 54: oe_debug_pub.add( 'v_cost_details_cto ' ,1 ) ;

50: OPEN cost_details(p_config_item_id, p_organization_id, p_cto_cost_type_id);
51: FETCH cost_details INTO v_cost_details_cto;
52:
53: IF PG_DEBUG <> 0 THEN
54: oe_debug_pub.add( 'v_cost_details_cto ' ,1 ) ;
55: oe_debug_pub.add( ' iid ' || v_cost_details_cto.inventory_item_id ||
56: ' org ' || to_char( v_cost_details_cto.organization_id) ||
57: ' cstyp ' || to_char( v_cost_details_cto.cost_type_id) ||
58: ' icst ' || to_char( v_cost_details_cto.item_cost ) ||

Line 55: oe_debug_pub.add( ' iid ' || v_cost_details_cto.inventory_item_id ||

51: FETCH cost_details INTO v_cost_details_cto;
52:
53: IF PG_DEBUG <> 0 THEN
54: oe_debug_pub.add( 'v_cost_details_cto ' ,1 ) ;
55: oe_debug_pub.add( ' iid ' || v_cost_details_cto.inventory_item_id ||
56: ' org ' || to_char( v_cost_details_cto.organization_id) ||
57: ' cstyp ' || to_char( v_cost_details_cto.cost_type_id) ||
58: ' icst ' || to_char( v_cost_details_cto.item_cost ) ||
59: ' mcst ' || to_char( v_cost_details_cto.material_cost ) ||

Line 71: oe_debug_pub.add('***Inside 1st if.. total cost is same..' , 1);

67:
68: IF ( nvl(v_cost_details_frozen.item_cost,0) = nvl(v_cost_details_cto.item_cost,0) ) THEN
69:
70: IF PG_DEBUG <> 0 THEN
71: oe_debug_pub.add('***Inside 1st if.. total cost is same..' , 1);
72: END IF; --item cost same.. check for cost components
73:
74: IF Nvl(v_cost_details_frozen.material_cost, -1) = Nvl(v_cost_details_cto.material_cost, -1) and
75: Nvl(v_cost_details_frozen.material_overhead_cost, -1) = Nvl(v_cost_details_cto.material_overhead_cost, -1) and

Line 81: oe_debug_pub.add('***Inside 2nd if.. component costs are same..no processing needed' , 1);

77: Nvl(v_cost_details_frozen.outside_processing_cost, -1) = Nvl(v_cost_details_cto.outside_processing_cost, -1) AND
78: Nvl(v_cost_details_frozen.overhead_cost, -1) = Nvl(v_cost_details_cto.overhead_cost, -1) THEN
79:
80: IF PG_DEBUG <> 0 THEN
81: oe_debug_pub.add('***Inside 2nd if.. component costs are same..no processing needed' , 1);
82: END IF;
83:
84: return 'N';
85: else

Line 216: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS',2);

212: 0 -- C.attribute15
213: );
214:
215: IF PG_DEBUG <> 0 THEN
216: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
217:
218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
219: END IF;
220:

Line 218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

214:
215: IF PG_DEBUG <> 0 THEN
216: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
217:
218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
219: END IF;
220:
221: /*------ ----------------------------------------------+
222: Insert rows into the cst_item_cost_details table

Line 320: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details',2);

316: from mtl_parameters mp
317: where mp.organization_id = p_organization_id ;
318:
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details',2);
321:
322: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
323: END IF;
324:

Line 322: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);

318:
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details',2);
321:
322: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
323: END IF;
324:
325:
326: exception

Line 330: oe_debug_pub.add('populate_buy_cost: ' || 'populate_buy_cost no data found ',2);

326: exception
327: when NO_DATA_FOUND THEN
328:
329: IF PG_DEBUG <> 0 THEN
330: oe_debug_pub.add('populate_buy_cost: ' || 'populate_buy_cost no data found ',2);
331: END IF;
332:
333: when OTHERS THEN
334:

Line 336: oe_debug_pub.add('populate_buy_cost: ' || 'populate_buy_cost others '||sqlerrm,2);

332:
333: when OTHERS THEN
334:
335: IF PG_DEBUG <> 0 THEN
336: oe_debug_pub.add('populate_buy_cost: ' || 'populate_buy_cost others '||sqlerrm,2);
337: END IF;
338:
339:
340:

Line 472: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS',2);

468: 0 -- C.attribute15
469: );
470:
471: IF PG_DEBUG <> 0 THEN
472: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS',2);
473:
474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
475: END IF;
476:

Line 474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

470:
471: IF PG_DEBUG <> 0 THEN
472: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS',2);
473:
474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
475: END IF;
476:
477: /*------ ----------------------------------------------+
478: Insert rows into the cst_item_cost_details table

Line 576: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details',2);

572: from mtl_parameters mp
573: where mp.organization_id = p_organization_id ;
574:
575: IF PG_DEBUG <> 0 THEN
576: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details',2);
577:
578: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
579: END IF;
580:

Line 578: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);

574:
575: IF PG_DEBUG <> 0 THEN
576: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details',2);
577:
578: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
579: END IF;
580:
581:
582: exception

Line 586: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'populate_buy_cost others '||sqlerrm,2);

582: exception
583:
584: when OTHERS THEN
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'populate_buy_cost others '||sqlerrm,2);
587:
588:
589: end populate_buy_cost_rollup;
590:

Line 727: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

723: and C.organization_id = p_organization_id
724: and C.cost_type_id = p_cto_cost_type_id;
725:
726: IF PG_DEBUG <> 0 THEN
727: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
728: END IF;
729:
730: /*------ ----------------------------------------------+
731: Insert rows into the cst_item_cost_details table

Line 832: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);

828: and C.organization_id = p_organization_id
829: and C.cost_type_id = p_cto_cost_type_id ;
830:
831: IF PG_DEBUG <> 0 THEN
832: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
833: END IF;
834:
835: --Begin Bugfix 6363308
836: lStmtNumber := 250;

Line 839: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'Inserting records in csc and cec',2);

835: --Begin Bugfix 6363308
836: lStmtNumber := 250;
837:
838: IF PG_DEBUG <> 0 THEN
839: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'Inserting records in csc and cec',2);
840: END IF;
841:
842: INSERT INTO cst_standard_costs
843: (cost_update_id,

Line 872: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);

868: AND inventory_item_id = p_config_item_id
869: AND cost_type_id = 1;
870:
871: IF PG_DEBUG <> 0 THEN
872: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_standard_costs ' || sql%rowcount ,2);
873: END IF;
874:
875: lStmtNumber := 260;
876:

Line 908: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_elemental_costs ' || sql%rowcount ,2);

904: AND cost_type_id = 1
905: GROUP BY cost_element_id;
906:
907: IF PG_DEBUG <> 0 THEN
908: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_elemental_costs ' || sql%rowcount ,2);
909: END IF;
910: --End Bugfix 6363308
911:
912:

Line 922: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'copy_ctocost_to_frozen no data found ',2);

918: xMessageName := 'CTO_CALC_COST_ROLLUP_ERROR';
919: */
920:
921: IF PG_DEBUG <> 0 THEN
922: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'copy_ctocost_to_frozen no data found ',2);
923: END IF;
924:
925: when OTHERS THEN
926: /*

Line 934: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'copy_ctocost_to_frozen others ',2);

930: xMessageName := 'CTO_CALC_COST_ROLLUP_ERROR';
931: */
932:
933: IF PG_DEBUG <> 0 THEN
934: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'copy_ctocost_to_frozen others ',2);
935: END IF;
936:
937:
938:

Line 977: oe_debug_pub.add('Inside check_ct_updateable for p_inventory_item_id :'||p_inventory_item_id ||' p_organization_id :'||p_organization_id||' p_cost_type_id :'||p_cost_type_id );

973: BEGIN
974: -- If we are dealing with a frozon cost type, it is only updateable when
975: -- there does not exist any transactions.
976: IF PG_DEBUG <> 0 THEN
977: oe_debug_pub.add('Inside check_ct_updateable for p_inventory_item_id :'||p_inventory_item_id ||' p_organization_id :'||p_organization_id||' p_cost_type_id :'||p_cost_type_id );
978: END IF;
979:
980: IF ( p_cost_type_id = 1) THEN
981: IF (Updateable is NULL) THEN

Line 987: oe_debug_pub.add('Inside check_ct_updateable : After closing Check_Updateable flag is :'|| Updateable);

983: Fetch Check_Updateable into Updateable;
984: Close Check_Updateable;
985:
986: IF PG_DEBUG <> 0 THEN
987: oe_debug_pub.add('Inside check_ct_updateable : After closing Check_Updateable flag is :'|| Updateable);
988: END IF;
989:
990: IF (Updateable is Null) THEN
991:

Line 997: oe_debug_pub.add('Inside check_ct_updateable : After closing Check_Updateable_2 flag is :'|| Updateable);

993: Fetch Check_Updateable_2 into Updateable;
994: Close Check_Updateable_2;
995:
996: IF PG_DEBUG <> 0 THEN
997: oe_debug_pub.add('Inside check_ct_updateable : After closing Check_Updateable_2 flag is :'|| Updateable);
998: END IF;
999: END IF;
1000:
1001: IF (Updateable is NULL) THEN

Line 1003: oe_debug_pub.add('Inside check_ct_updateable : Checking for intransit_count');

999: END IF;
1000:
1001: IF (Updateable is NULL) THEN
1002: IF PG_DEBUG <> 0 THEN
1003: oe_debug_pub.add('Inside check_ct_updateable : Checking for intransit_count');
1004: END IF;
1005:
1006: select count(*)
1007: into intransit_count

Line 1014: oe_debug_pub.add('Inside check_ct_updateable : Intransit_count ='|| intransit_count);

1010: and m.intransit_owning_org_id = p_organization_id
1011: and m.to_organization_id = p_organization_id ;
1012:
1013: IF PG_DEBUG <> 0 THEN
1014: oe_debug_pub.add('Inside check_ct_updateable : Intransit_count ='|| intransit_count);
1015: END IF;
1016:
1017: IF (intransit_count > 0) THEN
1018: Updateable := 'NO';

Line 1028: oe_debug_pub.add( ' check_ct_updateable is null -> true ' ) ;

1024: -- fnd_message.Set_Name('BOM', 'CST_ITEM_USED_IN_TXN');
1025: RetVal := FALSE;
1026: ELSE
1027: IF PG_DEBUG <> 0 THEN
1028: oe_debug_pub.add( ' check_ct_updateable is null -> true ' ) ;
1029: END IF;
1030:
1031: RetVal := TRUE;
1032: END IF;

Line 1036: oe_debug_pub.add( ' cost type id not 1 ' ) ;

1032: END IF;
1033:
1034: ELSE
1035: IF PG_DEBUG <> 0 THEN
1036: oe_debug_pub.add( ' cost type id not 1 ' ) ;
1037: END IF;
1038:
1039: RetVal := TRUE;
1040: END IF;

Line 1045: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;

1041:
1042: IF PG_DEBUG <> 0 THEN
1043:
1044: if( RetVal = TRUE ) then
1045: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;
1046: elsif( RetVal = False ) then
1047: oe_debug_pub.add( ' check_ct_updateable is false' ) ;
1048: elsif( RetVal is null ) then
1049: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;

Line 1047: oe_debug_pub.add( ' check_ct_updateable is false' ) ;

1043:
1044: if( RetVal = TRUE ) then
1045: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;
1046: elsif( RetVal = False ) then
1047: oe_debug_pub.add( ' check_ct_updateable is false' ) ;
1048: elsif( RetVal is null ) then
1049: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;
1050: end if ;
1051: END IF;

Line 1049: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;

1045: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;
1046: elsif( RetVal = False ) then
1047: oe_debug_pub.add( ' check_ct_updateable is false' ) ;
1048: elsif( RetVal is null ) then
1049: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;
1050: end if ;
1051: END IF;
1052:
1053:

Line 1232: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Array p_cfg_itm_tbl does not contain any rows to process.');

1228: --Bugfix 12957444: Cleaning the global collection.
1229: CTO_COST_ROLLUP_CONC_PK.g_error_cache.delete;
1230:
1231: if p_cfg_itm_tbl.COUNT = 0 then
1232: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Array p_cfg_itm_tbl does not contain any rows to process.');
1233: return(1);
1234: else
1235: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Going to process '||p_cfg_itm_tbl.COUNT|| ' rows... ');
1236:

Line 1235: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Going to process '||p_cfg_itm_tbl.COUNT|| ' rows... ');

1231: if p_cfg_itm_tbl.COUNT = 0 then
1232: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Array p_cfg_itm_tbl does not contain any rows to process.');
1233: return(1);
1234: else
1235: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Going to process '||p_cfg_itm_tbl.COUNT|| ' rows... ');
1236:
1237: end if;
1238:
1239: gUserId := nvl(fnd_global.user_id, -1);

Line 1243: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'gUserId::'||to_char(gUserId)

1239: gUserId := nvl(fnd_global.user_id, -1);
1240: gLoginId := nvl(fnd_global.login_id, -1);
1241:
1242: IF PG_DEBUG <> 0 THEN
1243: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'gUserId::'||to_char(gUserId)
1244: ||'::gLoginId::'||to_char(gLoginId), 2);
1245:
1246: END IF;
1247:

Line 1258: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'lRollupId::'||to_char(lRollupId), 2);

1254:
1255:
1256:
1257: IF PG_DEBUG <> 0 THEN
1258: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'lRollupId::'||to_char(lRollupId), 2);
1259: END IF;
1260:
1261: lStmtNumber := 20;
1262: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

Line 1266: oe_debug_pub.add('Cost_Roll_Up_ML '

1262: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
1263:
1264: IF lMrpAssignmentSet is null THEN
1265: IF PG_DEBUG <> 0 THEN
1266: oe_debug_pub.add('Cost_Roll_Up_ML '
1267: || 'Default assignment set is null', 1);
1268: END IF;
1269:
1270:

Line 1275: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Default assignment set is '

1271: --FND_MESSAGE.set_name('BOM','CTO_MRP_ASSIGNMENT_SET');
1272: --raise CTO_MRP_ASSIGNMENT_SET;
1273: ELSE
1274: IF PG_DEBUG <> 0 THEN
1275: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Default assignment set is '
1276: ||to_char(lMrpAssignmentSet), 2);
1277: END IF;
1278: END IF;
1279:

Line 1289: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Currency Conversion Type ::'

1285: lConversionType := FND_PROFILE.VALUE('CURRENCY_CONVERSION_TYPE');
1286:
1287:
1288: IF PG_DEBUG <> 0 THEN
1289: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Currency Conversion Type ::'
1290: ||lConversionType, 2);
1291: END IF;
1292:
1293:

Line 1302: oe_debug_pub.add ('Fetching CTO cost_type_id..');

1298: */
1299:
1300:
1301: IF PG_DEBUG <> 0 THEN
1302: oe_debug_pub.add ('Fetching CTO cost_type_id..');
1303: END IF;
1304:
1305:
1306:

Line 1324: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);

1320: -- goto endloop; bug 4177423
1321: raise FND_API.G_EXC_ERROR;
1322:
1323: when others then
1324: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);
1325: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1326:
1327: end;
1328:

Line 1345: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);

1341: exception
1342: when no_data_found then
1343:
1344: IF PG_DEBUG <> 0 THEN
1345: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1346: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1347: END IF;
1348:
1349: v_cto_cost_type_id := 7 ;

Line 1346: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);

1342: when no_data_found then
1343:
1344: IF PG_DEBUG <> 0 THEN
1345: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1346: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1347: END IF;
1348:
1349: v_cto_cost_type_id := 7 ;
1350:

Line 1357: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||

1353: from cst_cost_types
1354: where cost_type_id = v_cto_cost_type_id ;
1355:
1356: IF PG_DEBUG <> 0 THEN
1357: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||
1358: ' has cost_type = ' || v_cto_cost_type_name ,2);
1359: END IF;
1360: exception
1361: when no_data_found then

Line 1363: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);

1359: END IF;
1360: exception
1361: when no_data_found then
1362: IF PG_DEBUG <> 0 THEN
1363: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1364: END IF;
1365: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1366: raise FND_API.G_EXC_ERROR;
1367: when others then

Line 1386: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type ::'|| lBuyCostType , 2);

1382:
1383: lStmtNumber := 27;
1384: lBuyCostType := FND_PROFILE.VALUE('CTO_BUY_COST_TYPE');
1385: IF PG_DEBUG <> 0 THEN
1386: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type ::'|| lBuyCostType , 2);
1387: END IF;
1388:
1389:
1390: lStmtNumber := 28;

Line 1399: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type id ::'

1395: from cst_cost_types
1396: where cost_type = lBuyCostType ;
1397:
1398: IF PG_DEBUG <> 0 THEN
1399: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type id ::'
1400: || v_buy_cost_type_id , 2);
1401: END IF;
1402:
1403: exception

Line 1418: oe_debug_pub.add('Cost_Roll_Up_ML ' || ' Defaulting Buy Cost Type to CTO cost id ' || v_cto_cost_type_id , 2);

1414:
1415: else /* fix for bug 4177423 */
1416:
1417: IF PG_DEBUG <> 0 THEN
1418: oe_debug_pub.add('Cost_Roll_Up_ML ' || ' Defaulting Buy Cost Type to CTO cost id ' || v_cto_cost_type_id , 2);
1419: END IF;
1420:
1421: v_buy_cost_type_id := v_cto_cost_type_id ;
1422:

Line 1429: oe_debug_pub.add('Cost_Roll_Up_ML ' || ' opening buy cost cursor for bcso ' , 2);

1425:
1426: lStmtNumber := 29;
1427:
1428: IF PG_DEBUG <> 0 THEN
1429: oe_debug_pub.add('Cost_Roll_Up_ML ' || ' opening buy cost cursor for bcso ' , 2);
1430: END IF;
1431:
1432:
1433:

Line 1456: oe_debug_pub.add ('---------------------------------------------------------------------------');

1452:
1453:
1454:
1455:
1456: oe_debug_pub.add ('---------------------------------------------------------------------------');
1457: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||
1458: ' in orgn '||p_cfg_itm_tbl(i).cfg_org_id);
1459: oe_debug_pub.add ('---------------------------------------------------------------------------');
1460:

Line 1457: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||

1453:
1454:
1455:
1456: oe_debug_pub.add ('---------------------------------------------------------------------------');
1457: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||
1458: ' in orgn '||p_cfg_itm_tbl(i).cfg_org_id);
1459: oe_debug_pub.add ('---------------------------------------------------------------------------');
1460:
1461: open c_buy_items( p_cfg_itm_tbl(i).cfg_item_id,

Line 1459: oe_debug_pub.add ('---------------------------------------------------------------------------');

1455:
1456: oe_debug_pub.add ('---------------------------------------------------------------------------');
1457: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||
1458: ' in orgn '||p_cfg_itm_tbl(i).cfg_org_id);
1459: oe_debug_pub.add ('---------------------------------------------------------------------------');
1460:
1461: open c_buy_items( p_cfg_itm_tbl(i).cfg_item_id,
1462: p_cfg_itm_tbl(i).cfg_org_id) ;
1463:

Line 1476: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'c_oper_unit is null for this config. Skipping this config..');

1472: --Bugfix 12957444: Checking if c_oper_unit is null. The next sql gives ndf
1473: --exception otherwise and the block of configs is not processed.
1474: if c_oper_unit is null then
1475: IF PG_DEBUG <> 0 THEN
1476: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'c_oper_unit is null for this config. Skipping this config..');
1477: END IF;
1478:
1479: lStmtNumber := 29.1;
1480: CTO_COST_ROLLUP_CONC_PK.g_error_cache(p_cfg_itm_tbl(i).cfg_item_id || '-' || p_cfg_itm_tbl(i).cfg_org_id) := i;

Line 1495: oe_debug_pub.add('Cost_Roll_Up_ML ' ||

1491: where org_id = c_oper_unit;
1492:
1493:
1494: IF PG_DEBUG <> 0 THEN
1495: oe_debug_pub.add('Cost_Roll_Up_ML ' ||
1496: ' model ' || c_model_item_id ||
1497: ' config ' || c_config_item_id ||
1498: ' org ' || c_org_id ||
1499: ' po val ' || c_po_valid_org ||

Line 1519: oe_debug_pub.add('no buy cost exists for item ' || c_config_item_id

1515: when no_data_found then
1516: v_buy_cost := null ;
1517:
1518: IF PG_DEBUG <> 0 THEN
1519: oe_debug_pub.add('no buy cost exists for item ' || c_config_item_id
1520: || ' in org ' || c_org_id , 2);
1521: END IF;
1522:
1523:

Line 1525: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);

1521: END IF;
1522:
1523:
1524: when others then
1525: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);
1526: oe_debug_pub.add(sqlerrm);
1527: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1528:
1529: end ;

Line 1526: oe_debug_pub.add(sqlerrm);

1522:
1523:
1524: when others then
1525: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);
1526: oe_debug_pub.add(sqlerrm);
1527: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1528:
1529: end ;
1530:

Line 1547: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);

1543: when no_data_found then
1544:
1545:
1546: IF PG_DEBUG <> 0 THEN
1547: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
1548: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_org_id , 1);
1549: END IF;
1550:
1551:

Line 1548: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_org_id , 1);

1544:
1545:
1546: IF PG_DEBUG <> 0 THEN
1547: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
1548: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_org_id , 1);
1549: END IF;
1550:
1551:
1552: -- cto_msg_pub.cto_message('BOM', l_xmsgdata);

Line 1609: oe_debug_pub.add('going to populate buy cost for item ' || c_config_item_id

1605:
1606: lStmtNumber := 35;
1607:
1608: IF PG_DEBUG <> 0 THEN
1609: oe_debug_pub.add('going to populate buy cost for item ' || c_config_item_id
1610: || ' for $ ' || v_buy_item_cost , 2);
1611: END IF;
1612:
1613: populate_buy_cost_rollup( c_config_item_id

Line 1621: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');

1617: , x_return_status) ;
1618:
1619: if x_return_status = FND_API.G_RET_STS_ERROR then
1620: ROLLBACK to CTOCST;
1621: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1622: goto endloop;
1623:
1624: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1625: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');

Line 1625: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');

1621: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1622: goto endloop;
1623:
1624: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1625: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');
1626: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1627: end if;
1628:
1629:

Line 1633: oe_debug_pub.add('buy cost exists for item ' || c_config_item_id

1629:
1630: else
1631:
1632: IF PG_DEBUG <> 0 THEN
1633: oe_debug_pub.add('buy cost exists for item ' || c_config_item_id
1634: || ' for $ ' || v_buy_cost , 2);
1635: END IF;
1636:
1637: end if ;

Line 1651: oe_debug_pub.add ('Fetching c_matched_items_cost_synchup cursor ..');

1647:
1648:
1649: lStmtNumber := 37;
1650: IF PG_DEBUG <> 0 THEN
1651: oe_debug_pub.add ('Fetching c_matched_items_cost_synchup cursor ..');
1652: END IF;
1653:
1654: /* copy valuation cost to cto cost for matched items */
1655:

Line 1667: oe_debug_pub.add ('c_match_config_item_id = '|| c_match_config_item_id || ';' ||

1663:
1664: close c_matched_items_cost_synchup;
1665:
1666: IF PG_DEBUG <> 0 THEN
1667: oe_debug_pub.add ('c_match_config_item_id = '|| c_match_config_item_id || ';' ||
1668: 'c_organization_id = '|| c_organization_id || ';' ||
1669: 'c_primary_cost_method = '|| c_primary_cost_method || ';' ||
1670: 'c_valuation_cost = '|| c_valuation_cost );
1671: END IF;

Line 1689: oe_debug_pub.add ('v_cto_cost = '|| v_cto_cost );

1685:
1686: end;
1687:
1688: IF PG_DEBUG <> 0 THEN
1689: oe_debug_pub.add ('v_cto_cost = '|| v_cto_cost );
1690: END IF;
1691:
1692: lStmtNumber := 39;
1693: if( c_valuation_cost <> v_cto_cost or v_cto_cost is null ) then

Line 1705: oe_debug_pub.add('calling costing API', 2);

1701: end if;
1702:
1703:
1704: IF PG_DEBUG <> 0 THEN
1705: oe_debug_pub.add('calling costing API', 2);
1706: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet || '; cto cost id ' || v_cto_cost_type_id ||
1707: ' buy cost id ' || v_buy_cost_type_id , 2);
1708:
1709: END IF;

Line 1706: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet || '; cto cost id ' || v_cto_cost_type_id ||

1702:
1703:
1704: IF PG_DEBUG <> 0 THEN
1705: oe_debug_pub.add('calling costing API', 2);
1706: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet || '; cto cost id ' || v_cto_cost_type_id ||
1707: ' buy cost id ' || v_buy_cost_type_id , 2);
1708:
1709: END IF;
1710:

Line 1768: oe_debug_pub.add('populate_buy_cost: ' || 'rows inserted into bom_lists::'||to_char(lCnt), 2);

1764: If lCnt > 0 Then
1765: l_cost_data_exists := 'Y';
1766: End if;
1767: IF PG_DEBUG <> 0 THEN
1768: oe_debug_pub.add('populate_buy_cost: ' || 'rows inserted into bom_lists::'||to_char(lCnt), 2);
1769: END IF;
1770:
1771: << endloop>>
1772: null;

Line 1796: oe_debug_pub.add('Populate_buy_cost: Calling Supply Chain Rollup program',5);

1792: -- Bug Fix 4867460
1793: If l_cost_data_exists = 'Y' Then
1794:
1795: If PG_DEBUG <> 0 Then
1796: oe_debug_pub.add('Populate_buy_cost: Calling Supply Chain Rollup program',5);
1797: End if;
1798:
1799: /* Commented as part of Bugfix 7246036
1800: CSTPSCEX.Supply_Chain_Rollup(

Line 1849: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);

1845: i_buy_cost_detail => 1 ); --Bugfix 7246036: Passing preserve buy cost details parameter as Yes.
1846:
1847: IF lErrorCode <> 0 THEN
1848: IF PG_DEBUG <> 0 THEN
1849: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
1850: END IF;
1851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1852: ELSE
1853: IF PG_DEBUG <> 0 THEN

Line 1854: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with success', 1);

1850: END IF;
1851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1852: ELSE
1853: IF PG_DEBUG <> 0 THEN
1854: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with success', 1);
1855: END IF;
1856:
1857:
1858: END IF;

Line 1863: oe_debug_pub.add('Populate_buy_cost: No cost data exists. No need to call Supply chain Cost rollup API',5);

1859:
1860: Else
1861:
1862: If PG_DEBUG <> 0 Then
1863: oe_debug_pub.add('Populate_buy_cost: No cost data exists. No need to call Supply chain Cost rollup API',5);
1864: End if;
1865:
1866: End if;
1867: /*

Line 1889: oe_debug_pub.add('Config::' || p_cfg_itm_tbl(i).cfg_item_id || ' in org::' || p_cfg_itm_tbl(i).cfg_org_id ||

1885: --Bugfix 12957444: Skipping the configs that are in error cache.
1886: if CTO_COST_ROLLUP_CONC_PK.g_error_cache.exists(p_cfg_itm_tbl(i).cfg_item_id || '-' || p_cfg_itm_tbl(i).cfg_org_id)
1887: then
1888: IF PG_DEBUG <> 0 THEN
1889: oe_debug_pub.add('Config::' || p_cfg_itm_tbl(i).cfg_item_id || ' in org::' || p_cfg_itm_tbl(i).cfg_org_id ||
1890: 'is in error. Skipping it.');
1891: END IF;
1892:
1893: goto endloop2;

Line 1910: oe_debug_pub.add('populate_buy_cost: ' || 'v_primary_cost_method = '||v_primary_cost_method);

1906: from mtl_parameters mp1
1907: where mp1.organization_id = c_organization_id ;
1908:
1909: IF PG_DEBUG <> 0 THEN
1910: oe_debug_pub.add('populate_buy_cost: ' || 'v_primary_cost_method = '||v_primary_cost_method);
1911: END IF;
1912: -- If the org is Standard cost then check if the Item is transacted
1913: --
1914: IF (v_primary_cost_method = 1) THEN

Line 1922: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable = TRUE' );

1918: END IF;
1919:
1920: IF PG_DEBUG <> 0 THEN
1921: IF (v_is_cst_updatable = TRUE) THEN
1922: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable = TRUE' );
1923: ELSE
1924: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable = FALSE' );
1925: END IF;
1926: END IF;

Line 1924: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable = FALSE' );

1920: IF PG_DEBUG <> 0 THEN
1921: IF (v_is_cst_updatable = TRUE) THEN
1922: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable = TRUE' );
1923: ELSE
1924: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable = FALSE' );
1925: END IF;
1926: END IF;
1927:
1928: IF (v_is_cst_updatable = TRUE) THEN

Line 1930: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable is true. So frozen cost is updatable');

1926: END IF;
1927:
1928: IF (v_is_cst_updatable = TRUE) THEN
1929: IF PG_DEBUG <> 0 THEN
1930: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable is true. So frozen cost is updatable');
1931: END IF;
1932:
1933: --exit when c_frozen_cost_update%notfound ; Bugfix 6038548
1934: IF c_frozen_cost_update%found THEN --Bugfix 6038548

Line 1945: oe_debug_pub.add('***************** going to do frozen cost update for config ' || c_config_item_id

1941:
1942: IF (l_cost_update_required = 'Y') THEN
1943:
1944: IF PG_DEBUG <> 0 THEN
1945: oe_debug_pub.add('***************** going to do frozen cost update for config ' || c_config_item_id
1946: || ' in org ' || c_organization_id , 1);
1947: END IF;
1948:
1949:

Line 1956: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);

1952: and organization_id = c_organization_id
1953: and cost_type_id = 1 ;
1954:
1955: IF PG_DEBUG <> 0 THEN
1956: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
1957: END IF;
1958:
1959:
1960: delete from cst_item_costs

Line 1967: oe_debug_pub.add('deleted headers ' || SQL%ROWCOUNT , 1);

1963: and cost_type_id = 1 ;
1964:
1965:
1966: IF PG_DEBUG <> 0 THEN
1967: oe_debug_pub.add('deleted headers ' || SQL%ROWCOUNT , 1);
1968: END IF;
1969:
1970:
1971: copy_ctocost_to_frozen ( c_config_item_id

Line 1979: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable is false. So frozen cost is not updatable. Updating Cto cost with frozen cost');

1975: END IF;
1976: END IF; --c_frozen_cost_update%found. Bugfix 6038548
1977: ELSE
1978: IF PG_DEBUG <> 0 THEN
1979: oe_debug_pub.add('populate_buy_cost: ' || 'v_is_cst_updatable is false. So frozen cost is not updatable. Updating Cto cost with frozen cost');
1980: END IF;
1981: -- Update CTO cost with Frozen cost
1982: --
1983: CTO_UTILITY_PK.copy_cost(v_primary_cost_method

Line 2002: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);

1998: END LOOP;
1999:
2000: --Bugfix 12957444: Adding some debugging.
2001: IF PG_DEBUG <> 0 THEN
2002: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);
2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);
2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop

Line 2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);

1999:
2000: --Bugfix 12957444: Adding some debugging.
2001: IF PG_DEBUG <> 0 THEN
2002: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);
2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);
2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);

Line 2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');

2000: --Bugfix 12957444: Adding some debugging.
2001: IF PG_DEBUG <> 0 THEN
2002: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);
2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);
2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);
2008: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.next(l_error_cache_val);

Line 2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);

2003: oe_debug_pub.add('Cost_Roll_Up_ML:' || 'No. of configs in error::' || CTO_COST_ROLLUP_CONC_PK.g_error_cache.count);
2004: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========Printing configs in error============');
2005: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.first;
2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);
2008: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.next(l_error_cache_val);
2009: end loop;
2010: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========End printing configs in error============');
2011: END IF;

Line 2010: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========End printing configs in error============');

2006: while l_error_cache_val is not null loop
2007: oe_debug_pub.add('Config-Org::' || l_error_cache_val);
2008: l_error_cache_val := CTO_COST_ROLLUP_CONC_PK.g_error_cache.next(l_error_cache_val);
2009: end loop;
2010: oe_debug_pub.add('Cost_Roll_Up_ML:' || '===========End printing configs in error============');
2011: END IF;
2012:
2013: if CTO_COST_ROLLUP_CONC_PK.g_error_cache.count <> 0 then
2014: l_ret_val := 0;

Line 2024: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);

2020: return(l_ret_val);
2021:
2022: EXCEPTION
2023: WHEN NO_DATA_FOUND THEN
2024: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
2025: return(0);
2026:
2027: WHEN CTO_MRP_ASSIGNMENT_SET THEN
2028: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);

Line 2028: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);

2024: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
2025: return(0);
2026:
2027: WHEN CTO_MRP_ASSIGNMENT_SET THEN
2028: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);
2029:
2030: cto_msg_pub.count_and_get
2031: ( p_msg_count => x_msg_count
2032: , p_msg_data => x_msg_data

Line 2039: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);

2035: return(0);
2036:
2037:
2038: WHEN FND_API.G_EXC_ERROR THEN
2039: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2040:
2041: cto_msg_pub.count_and_get
2042: ( p_msg_count => x_msg_count
2043: , p_msg_data => x_msg_data

Line 2051: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);

2047: return(0);
2048:
2049:
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2052:
2053: cto_msg_pub.count_and_get
2054: ( p_msg_count => x_msg_count
2055: , p_msg_data => x_msg_data

Line 2062: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::other excpn ::'||to_char(lStmtNumber)||sqlerrm, 1);

2058:
2059: return(-1);
2060:
2061: WHEN OTHERS THEN
2062: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::other excpn ::'||to_char(lStmtNumber)||sqlerrm, 1);
2063:
2064: cto_msg_pub.count_and_get
2065: ( p_msg_count => x_msg_count
2066: , p_msg_data => x_msg_data

Line 2236: oe_debug_pub.add('Cost_Rollup_ML: ' || 'gUserId::'||to_char(gUserId)

2232:
2233: gUserId := nvl(fnd_global.user_id, -1);
2234: gLoginId := nvl(fnd_global.login_id, -1);
2235: IF PG_DEBUG <> 0 THEN
2236: oe_debug_pub.add('Cost_Rollup_ML: ' || 'gUserId::'||to_char(gUserId)
2237: ||'::gLoginId::'||to_char(gLoginId), 2);
2238:
2239: oe_debug_pub.add('Cost_Rollup_ML: ' || 'top line ::'|| pTopAtoLineId , 2 );
2240: END IF;

Line 2239: oe_debug_pub.add('Cost_Rollup_ML: ' || 'top line ::'|| pTopAtoLineId , 2 );

2235: IF PG_DEBUG <> 0 THEN
2236: oe_debug_pub.add('Cost_Rollup_ML: ' || 'gUserId::'||to_char(gUserId)
2237: ||'::gLoginId::'||to_char(gLoginId), 2);
2238:
2239: oe_debug_pub.add('Cost_Rollup_ML: ' || 'top line ::'|| pTopAtoLineId , 2 );
2240: END IF;
2241:
2242:
2243: -- changed sequence as per bugfix 3239456

Line 2253: oe_debug_pub.add('Cost_Rollup_ML: ' || 'lRollupId::'||to_char(lRollupId), 2);

2249:
2250:
2251:
2252: IF PG_DEBUG <> 0 THEN
2253: oe_debug_pub.add('Cost_Rollup_ML: ' || 'lRollupId::'||to_char(lRollupId), 2);
2254: END IF;
2255:
2256: lStmtNumber := 20;
2257: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

Line 2261: oe_debug_pub.add('Cost_Rollup_ML: '

2257: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2258:
2259: IF lMrpAssignmentSet is null THEN
2260: IF PG_DEBUG <> 0 THEN
2261: oe_debug_pub.add('Cost_Rollup_ML: '
2262: || 'Default assignment set is null', 1);
2263: END IF;
2264:
2265:

Line 2270: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Default assignment set is '

2266: --FND_MESSAGE.set_name('BOM','CTO_MRP_ASSIGNMENT_SET');
2267: --raise CTO_MRP_ASSIGNMENT_SET;
2268: ELSE
2269: IF PG_DEBUG <> 0 THEN
2270: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Default assignment set is '
2271: ||to_char(lMrpAssignmentSet), 2);
2272: END IF;
2273: END IF;
2274:

Line 2284: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Currency Conversion Type ::'

2280: lConversionType := FND_PROFILE.VALUE('CURRENCY_CONVERSION_TYPE');
2281:
2282:
2283: IF PG_DEBUG <> 0 THEN
2284: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Currency Conversion Type ::'
2285: ||lConversionType, 2);
2286: END IF;
2287:
2288: lStmtNumber := 27;

Line 2291: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type ::'|| lBuyCostType , 2);

2287:
2288: lStmtNumber := 27;
2289: lBuyCostType := FND_PROFILE.VALUE('CTO_BUY_COST_TYPE');
2290: IF PG_DEBUG <> 0 THEN
2291: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type ::'|| lBuyCostType , 2);
2292: END IF;
2293:
2294:
2295: lStmtNumber := 28;

Line 2304: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type id ::'

2300: from cst_cost_types
2301: where cost_type = lBuyCostType ;
2302:
2303: IF PG_DEBUG <> 0 THEN
2304: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type id ::'
2305: || v_buy_cost_type_id , 2);
2306: END IF;
2307:
2308: exception

Line 2329: oe_debug_pub.add('Cost_Rollup_ML: '

2325:
2326: lStmtNumber := 29;
2327:
2328: IF PG_DEBUG <> 0 THEN
2329: oe_debug_pub.add('Cost_Rollup_ML: '
2330: || ' opening buy cost cursor for bcso ' , 2);
2331: END IF;
2332:
2333: if( lBuyCostType is not null ) then

Line 2349: oe_debug_pub.add('Cost_Rollup_ML: ' ||

2345:
2346: exit when c_buy_items%notfound ;
2347:
2348: IF PG_DEBUG <> 0 THEN
2349: oe_debug_pub.add('Cost_Rollup_ML: ' ||
2350: ' fetched line ' || c_line_id ||
2351: ' model ' || c_model_item_id ||
2352: ' config ' || c_config_item_id ||
2353: ' cost org ' || c_cost_org_id || --3116778

Line 2373: oe_debug_pub.add('no buy cost exists for item ' || c_config_item_id

2369: when no_data_found then
2370: v_buy_cost := null ;
2371:
2372: IF PG_DEBUG <> 0 THEN
2373: oe_debug_pub.add('no buy cost exists for item ' || c_config_item_id
2374: || ' in org ' || c_cost_org_id , 2); -- 3116778
2375: END IF;
2376:
2377:

Line 2406: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);

2402: when no_data_found then
2403:
2404:
2405: IF PG_DEBUG <> 0 THEN
2406: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
2407: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_cost_org_id , 1);
2408: END IF;
2409:
2410:

Line 2407: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_cost_org_id , 1);

2403:
2404:
2405: IF PG_DEBUG <> 0 THEN
2406: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
2407: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_cost_org_id , 1);
2408: END IF;
2409:
2410:
2411: -- cto_msg_pub.cto_message('BOM', l_xmsgdata);

Line 2465: oe_debug_pub.add('going to populate buy cost for item ' || c_config_item_id

2461:
2462: lStmtNumber := 35;
2463:
2464: IF PG_DEBUG <> 0 THEN
2465: oe_debug_pub.add('going to populate buy cost for item ' || c_config_item_id
2466: || ' for $ ' || v_buy_item_cost , 2);
2467: END IF;
2468:
2469: populate_buy_cost( c_line_id

Line 2479: oe_debug_pub.add('buy cost exists for item ' || c_config_item_id

2475:
2476: else
2477:
2478: IF PG_DEBUG <> 0 THEN
2479: oe_debug_pub.add('buy cost exists for item ' || c_config_item_id
2480: || ' for $ ' || v_buy_cost || 'in org ' || c_cost_org_id, 2); -- 3116778
2481: END IF;
2482:
2483: end if ;

Line 2508: oe_debug_pub.add('Cost_Rollup_ML: ' || 'inserting into cst_sc_lists', 2);

2504: -- 2. costing_enabled_flag = Y
2505: -- 3. primary_cost_method = 1 (standard)
2506: --
2507: IF PG_DEBUG <> 0 THEN
2508: oe_debug_pub.add('Cost_Rollup_ML: ' || 'inserting into cst_sc_lists', 2);
2509: END IF;
2510:
2511:
2512: /*

Line 2582: oe_debug_pub.add('Cost_Rollup_ML: ' || 'rows inserted into cst_sc_lists::'||to_char(lCnt), 2);

2578:
2579: -- debug 3116778
2580: lCnt := sql%rowcount;
2581: IF PG_DEBUG <> 0 THEN
2582: oe_debug_pub.add('Cost_Rollup_ML: ' || 'rows inserted into cst_sc_lists::'||to_char(lCnt), 2);
2583: END IF;
2584: cst_sc_list_count := lCnt; -- Bug# 4867460
2585: open cst_cur ( lRollupId ) ;
2586:

Line 2594: oe_debug_pub.add('Cst list has item : ' ||d_item_id|| ' in org ' || d_org_id,1);

2590:
2591: exit when cst_cur%notfound ;
2592:
2593: IF PG_DEBUG <> 0 THEN
2594: oe_debug_pub.add('Cst list has item : ' ||d_item_id|| ' in org ' || d_org_id,1);
2595: END IF;
2596:
2597: end loop;
2598: close cst_cur;

Line 2605: oe_debug_pub.add('Cost_Rollup_ML: ' || 'rows inserted into cst_sc_lists::'||to_char(lCnt), 2);

2601:
2602:
2603: lCnt := sql%rowcount;
2604: IF PG_DEBUG <> 0 THEN
2605: oe_debug_pub.add('Cost_Rollup_ML: ' || 'rows inserted into cst_sc_lists::'||to_char(lCnt), 2);
2606: END IF;
2607:
2608: --
2609: -- call SC Cost Rollup API

Line 2662: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);

2658: exception
2659: when no_data_found then
2660:
2661: IF PG_DEBUG <> 0 THEN
2662: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
2663: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
2664: END IF;
2665:
2666: v_cto_cost_type_id := 7 ;

Line 2663: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);

2659: when no_data_found then
2660:
2661: IF PG_DEBUG <> 0 THEN
2662: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
2663: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
2664: END IF;
2665:
2666: v_cto_cost_type_id := 7 ;
2667:

Line 2674: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||

2670: from cst_cost_types
2671: where cost_type_id = v_cto_cost_type_id ;
2672:
2673: IF PG_DEBUG <> 0 THEN
2674: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||
2675: ' has cost_type = ' || v_cto_cost_type_name ,2);
2676: END IF;
2677: exception
2678: when no_data_found then

Line 2680: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);

2676: END IF;
2677: exception
2678: when no_data_found then
2679: IF PG_DEBUG <> 0 THEN
2680: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
2681: END IF;
2682: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2683: raise FND_API.G_EXC_ERROR;
2684: when others then

Line 2711: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;

2707:
2708: open c1_cst ( c1_config_item_id ) ;
2709:
2710: IF PG_DEBUG <> 0 THEN
2711: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2712: END IF;
2713:
2714: loop
2715:

Line 2721: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;

2717:
2718: exit when c1_cst%notfound ;
2719:
2720: IF PG_DEBUG <> 0 THEN
2721: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2722: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||
2723: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2724: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2725: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||

Line 2722: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||

2718: exit when c1_cst%notfound ;
2719:
2720: IF PG_DEBUG <> 0 THEN
2721: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2722: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||
2723: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2724: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2725: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||
2726: ' mcst ' || to_char( v_cur_c1_cst.material_cost ) ||

Line 2736: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;

2732:
2733: end loop ;
2734:
2735: IF PG_DEBUG <> 0 THEN
2736: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;
2737: END IF;
2738:
2739: close c1_cst ;
2740:

Line 2752: oe_debug_pub.add('** calling costing API ', 2);

2748: lStmtNumber := 60;
2749: if cst_sc_list_count > 0 then --bug4867460: call the costing api only if records are inserted
2750: -- in cst_sc_lists. This is to improve performance.
2751: IF PG_DEBUG <> 0 THEN
2752: oe_debug_pub.add('******************** calling costing API ****************** ', 2);
2753: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet ||
2754: ' cto cost id ' || v_cto_cost_type_id ||
2755: ' buy cost id ' || v_buy_cost_type_id , 2);
2756:

Line 2753: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet ||

2749: if cst_sc_list_count > 0 then --bug4867460: call the costing api only if records are inserted
2750: -- in cst_sc_lists. This is to improve performance.
2751: IF PG_DEBUG <> 0 THEN
2752: oe_debug_pub.add('******************** calling costing API ****************** ', 2);
2753: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet ||
2754: ' cto cost id ' || v_cto_cost_type_id ||
2755: ' buy cost id ' || v_buy_cost_type_id , 2);
2756:
2757: END IF;

Line 2809: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);

2805: i_buy_cost_detail => 1 ); --Bugfix 7246036: Passing preserve buy cost details parameter as Yes.
2806:
2807: IF lErrorCode <> 0 THEN
2808: IF PG_DEBUG <> 0 THEN
2809: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
2810: END IF;
2811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2812: ELSE
2813: IF PG_DEBUG <> 0 THEN

Line 2814: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with success', 1);

2810: END IF;
2811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2812: ELSE
2813: IF PG_DEBUG <> 0 THEN
2814: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with success', 1);
2815: END IF;
2816:
2817:
2818: END IF;

Line 2821: oe_debug_pub.add('No cost data Exists. No need to call supply Chain cost rollup API',5);

2817:
2818: END IF;
2819: Else
2820: IF PG_DEBUG <> 0 Then
2821: oe_debug_pub.add('No cost data Exists. No need to call supply Chain cost rollup API',5);
2822: End if;
2823: End If; -- Bug fix 4867460
2824:
2825:

Line 2831: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;

2827:
2828: open c1_cst ( c1_config_item_id ) ;
2829:
2830: IF PG_DEBUG <> 0 THEN
2831: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2832: END IF;
2833:
2834: loop
2835:

Line 2841: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;

2837:
2838: exit when c1_cst%notfound ;
2839:
2840: IF PG_DEBUG <> 0 THEN
2841: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2842: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||
2843: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2844: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2845: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||

Line 2842: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||

2838: exit when c1_cst%notfound ;
2839:
2840: IF PG_DEBUG <> 0 THEN
2841: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2842: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||
2843: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2844: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2845: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||
2846: ' mcst ' || to_char( v_cur_c1_cst.material_cost ) ||

Line 2855: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;

2851:
2852: end loop ;
2853:
2854: IF PG_DEBUG <> 0 THEN
2855: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;
2856: END IF;
2857:
2858: close c1_cst ;
2859:

Line 2878: oe_debug_pub.add('***No need to do frozen cost update as no rollup has been done' , 1);

2874: --Bugfix 6717614
2875: if cst_sc_list_count = 0 then
2876:
2877: IF PG_DEBUG <> 0 THEN
2878: oe_debug_pub.add('***No need to do frozen cost update as no rollup has been done' , 1);
2879: END IF;
2880:
2881: else
2882: /*update Frozen cost with CTO Cost in case of standard costing organizations */

Line 2902: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_primary_cost_method = '||v_primary_cost_method);

2898: from mtl_parameters mp1
2899: where mp1.organization_id = c_organization_id ;
2900:
2901: IF PG_DEBUG <> 0 THEN
2902: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_primary_cost_method = '||v_primary_cost_method);
2903: END IF;
2904:
2905: -- If the org is Standard cost then check if the Item is transacted
2906: --

Line 2915: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = TRUE' );

2911: END IF;
2912:
2913: IF PG_DEBUG <> 0 THEN
2914: IF (v_is_cst_updatable = TRUE) THEN
2915: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = TRUE' );
2916: ELSE
2917: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = FALSE' );
2918: END IF;
2919: END IF;

Line 2917: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = FALSE' );

2913: IF PG_DEBUG <> 0 THEN
2914: IF (v_is_cst_updatable = TRUE) THEN
2915: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = TRUE' );
2916: ELSE
2917: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = FALSE' );
2918: END IF;
2919: END IF;
2920:
2921: -- bug 13106676

Line 2927: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = TRUE, so calling the frozen cost update API');

2923: --
2924: IF (v_is_cst_updatable = TRUE) THEN
2925:
2926: IF PG_DEBUG <> 0 THEN
2927: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = TRUE, so calling the frozen cost update API');
2928: END IF;
2929:
2930: --Bugfix 6717614
2931: lStmtNumber := 95;

Line 2940: oe_debug_pub.add('********************** going to do frozen cost update for config ' || c_config_item_id

2936: IF (l_cost_update_required = 'Y') THEN
2937:
2938:
2939: IF PG_DEBUG <> 0 THEN
2940: oe_debug_pub.add('********************** going to do frozen cost update for config ' || c_config_item_id
2941: || ' in org ' || c_organization_id , 1);
2942: END IF;
2943:
2944:

Line 2951: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);

2947: and organization_id = c_organization_id
2948: and cost_type_id = 1 ;
2949:
2950: IF PG_DEBUG <> 0 THEN
2951: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
2952: END IF;
2953:
2954:
2955: delete from cst_item_costs

Line 2962: oe_debug_pub.add('deleted headers ' || SQL%ROWCOUNT , 1);

2958: and cost_type_id = 1 ;
2959:
2960:
2961: IF PG_DEBUG <> 0 THEN
2962: oe_debug_pub.add('deleted headers ' || SQL%ROWCOUNT , 1);
2963: END IF;
2964:
2965:
2966: copy_ctocost_to_frozen ( c_config_item_id

Line 2973: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = FALSE, so updating CTO cost with Frozen cost');

2969:
2970: END IF; --l_cost_update_required Bugfix 6717614
2971: ELSE
2972: IF PG_DEBUG <> 0 THEN
2973: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_is_cst_updatable = FALSE, so updating CTO cost with Frozen cost');
2974: END IF;
2975: -- Update CTO cost with Frozen cost
2976: --
2977: CTO_UTILITY_PK.copy_cost(v_primary_cost_method

Line 2998: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;

2994:
2995: open c1_cst ( c1_config_item_id ) ;
2996:
2997: IF PG_DEBUG <> 0 THEN
2998: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2999: END IF;
3000:
3001: loop
3002:

Line 3008: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;

3004:
3005: exit when c1_cst%notfound ;
3006:
3007: IF PG_DEBUG <> 0 THEN
3008: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
3009: oe_debug_pub.add( ' iid ' || v_cur_c1_cst.inventory_item_id ||
3010: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
3011: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
3012: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||

Line 3009: oe_debug_pub.add( ' iid ' || v_cur_c1_cst.inventory_item_id ||

3005: exit when c1_cst%notfound ;
3006:
3007: IF PG_DEBUG <> 0 THEN
3008: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
3009: oe_debug_pub.add( ' iid ' || v_cur_c1_cst.inventory_item_id ||
3010: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
3011: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
3012: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||
3013: ' mcst ' || to_char( v_cur_c1_cst.material_cost ) ||

Line 3022: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;

3018:
3019: end loop ;
3020:
3021: IF PG_DEBUG <> 0 THEN
3022: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;
3023: END IF;
3024:
3025: close c1_cst ;
3026:

Line 3032: oe_debug_pub.add('Cost_Rollup_ML: ' || 'At end of cost rollup', 2);

3028:
3029:
3030:
3031: IF PG_DEBUG <> 0 THEN
3032: oe_debug_pub.add('Cost_Rollup_ML: ' || 'At end of cost rollup', 2);
3033: END IF;
3034: return(1);
3035:
3036: EXCEPTION

Line 3038: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);

3034: return(1);
3035:
3036: EXCEPTION
3037: WHEN NO_DATA_FOUND THEN
3038: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
3039: return(0);
3040:
3041: WHEN CTO_MRP_ASSIGNMENT_SET THEN
3042: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);

Line 3042: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);

3038: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
3039: return(0);
3040:
3041: WHEN CTO_MRP_ASSIGNMENT_SET THEN
3042: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);
3043:
3044: cto_msg_pub.count_and_get
3045: ( p_msg_count => x_msg_count
3046: , p_msg_data => x_msg_data

Line 3054: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);

3050: return(0);
3051:
3052:
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
3055:
3056: cto_msg_pub.count_and_get
3057: ( p_msg_count => x_msg_count
3058: , p_msg_data => x_msg_data

Line 3066: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);

3062: return(0);
3063:
3064:
3065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3066: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
3067:
3068: cto_msg_pub.count_and_get
3069: ( p_msg_count => x_msg_count
3070: , p_msg_data => x_msg_data