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 1009: oe_debug_pub.add( ' check_ct_updateable is null -> true ' ) ;

1005: -- fnd_message.Set_Name('BOM', 'CST_ITEM_USED_IN_TXN');
1006: RetVal := FALSE;
1007: ELSE
1008: IF PG_DEBUG <> 0 THEN
1009: oe_debug_pub.add( ' check_ct_updateable is null -> true ' ) ;
1010: END IF;
1011:
1012: RetVal := TRUE;
1013: END IF;

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

1013: END IF;
1014:
1015: ELSE
1016: IF PG_DEBUG <> 0 THEN
1017: oe_debug_pub.add( ' cost type id not 1 ' ) ;
1018: END IF;
1019:
1020: RetVal := TRUE;
1021: END IF;

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

1022:
1023: IF PG_DEBUG <> 0 THEN
1024:
1025: if( RetVal = TRUE ) then
1026: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;
1027: elsif( RetVal = False ) then
1028: oe_debug_pub.add( ' check_ct_updateable is false' ) ;
1029: elsif( RetVal is null ) then
1030: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;

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

1024:
1025: if( RetVal = TRUE ) then
1026: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;
1027: elsif( RetVal = False ) then
1028: oe_debug_pub.add( ' check_ct_updateable is false' ) ;
1029: elsif( RetVal is null ) then
1030: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;
1031: end if ;
1032: END IF;

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

1026: oe_debug_pub.add( ' check_ct_updateable is true ' ) ;
1027: elsif( RetVal = False ) then
1028: oe_debug_pub.add( ' check_ct_updateable is false' ) ;
1029: elsif( RetVal is null ) then
1030: oe_debug_pub.add( ' check_ct_updateable is null ' ) ;
1031: end if ;
1032: END IF;
1033:
1034:

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

1196: lStmtNumber := 10;
1197:
1198:
1199: if p_cfg_itm_tbl.COUNT = 0 then
1200: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Array p_cfg_itm_tbl does not contain any rows to process.');
1201: return(1);
1202: else
1203: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Going to process '||p_cfg_itm_tbl.COUNT|| ' rows... ');
1204:

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

1199: if p_cfg_itm_tbl.COUNT = 0 then
1200: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Array p_cfg_itm_tbl does not contain any rows to process.');
1201: return(1);
1202: else
1203: oe_debug_pub.add ('Cost_Roll_Up_ML: '|| 'Going to process '||p_cfg_itm_tbl.COUNT|| ' rows... ');
1204:
1205: end if;
1206:
1207: gUserId := nvl(fnd_global.user_id, -1);

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

1207: gUserId := nvl(fnd_global.user_id, -1);
1208: gLoginId := nvl(fnd_global.login_id, -1);
1209:
1210: IF PG_DEBUG <> 0 THEN
1211: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'gUserId::'||to_char(gUserId)
1212: ||'::gLoginId::'||to_char(gLoginId), 2);
1213:
1214: END IF;
1215:

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

1222:
1223:
1224:
1225: IF PG_DEBUG <> 0 THEN
1226: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'lRollupId::'||to_char(lRollupId), 2);
1227: END IF;
1228:
1229: lStmtNumber := 20;
1230: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

Line 1234: oe_debug_pub.add('Cost_Roll_Up_ML '

1230: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
1231:
1232: IF lMrpAssignmentSet is null THEN
1233: IF PG_DEBUG <> 0 THEN
1234: oe_debug_pub.add('Cost_Roll_Up_ML '
1235: || 'Default assignment set is null', 1);
1236: END IF;
1237:
1238:

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

1239: --FND_MESSAGE.set_name('BOM','CTO_MRP_ASSIGNMENT_SET');
1240: --raise CTO_MRP_ASSIGNMENT_SET;
1241: ELSE
1242: IF PG_DEBUG <> 0 THEN
1243: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Default assignment set is '
1244: ||to_char(lMrpAssignmentSet), 2);
1245: END IF;
1246: END IF;
1247:

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

1253: lConversionType := FND_PROFILE.VALUE('CURRENCY_CONVERSION_TYPE');
1254:
1255:
1256: IF PG_DEBUG <> 0 THEN
1257: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Currency Conversion Type ::'
1258: ||lConversionType, 2);
1259: END IF;
1260:
1261:

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

1266: */
1267:
1268:
1269: IF PG_DEBUG <> 0 THEN
1270: oe_debug_pub.add ('Fetching CTO cost_type_id..');
1271: END IF;
1272:
1273:
1274:

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

1288: -- goto endloop; bug 4177423
1289: raise FND_API.G_EXC_ERROR;
1290:
1291: when others then
1292: oe_debug_pub.add('Unexpected error while getting the cost_type_id: ' ||sqlerrm);
1293: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1294:
1295: end;
1296:

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

1309: exception
1310: when no_data_found then
1311:
1312: IF PG_DEBUG <> 0 THEN
1313: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1314: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1315: END IF;
1316:
1317: v_cto_cost_type_id := 7 ;

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

1310: when no_data_found then
1311:
1312: IF PG_DEBUG <> 0 THEN
1313: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1314: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1315: END IF;
1316:
1317: v_cto_cost_type_id := 7 ;
1318:

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

1321: from cst_cost_types
1322: where cost_type_id = v_cto_cost_type_id ;
1323:
1324: IF PG_DEBUG <> 0 THEN
1325: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||
1326: ' has cost_type = ' || v_cto_cost_type_name ,2);
1327: END IF;
1328: exception
1329: when no_data_found then

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

1327: END IF;
1328: exception
1329: when no_data_found then
1330: IF PG_DEBUG <> 0 THEN
1331: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1332: END IF;
1333: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1334: raise FND_API.G_EXC_ERROR;
1335: when others then

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

1350:
1351: lStmtNumber := 27;
1352: lBuyCostType := FND_PROFILE.VALUE('CTO_BUY_COST_TYPE');
1353: IF PG_DEBUG <> 0 THEN
1354: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type ::'|| lBuyCostType , 2);
1355: END IF;
1356:
1357:
1358: lStmtNumber := 28;

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

1363: from cst_cost_types
1364: where cost_type = lBuyCostType ;
1365:
1366: IF PG_DEBUG <> 0 THEN
1367: oe_debug_pub.add('Cost_Roll_Up_ML ' || 'Buy Cost Type id ::'
1368: || v_buy_cost_type_id , 2);
1369: END IF;
1370:
1371: exception

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

1382:
1383: else /* fix for bug 4177423 */
1384:
1385: IF PG_DEBUG <> 0 THEN
1386: oe_debug_pub.add('Cost_Roll_Up_ML ' || ' Defaulting Buy Cost Type to CTO cost id ' || v_cto_cost_type_id , 2);
1387: END IF;
1388:
1389: v_buy_cost_type_id := v_cto_cost_type_id ;
1390:

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

1393:
1394: lStmtNumber := 29;
1395:
1396: IF PG_DEBUG <> 0 THEN
1397: oe_debug_pub.add('Cost_Roll_Up_ML ' || ' opening buy cost cursor for bcso ' , 2);
1398: END IF;
1399:
1400:
1401:

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

1414:
1415:
1416:
1417:
1418: oe_debug_pub.add ('---------------------------------------------------------------------------');
1419: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||
1420: ' in orgn '||p_cfg_itm_tbl(i).cfg_org_id);
1421: oe_debug_pub.add ('---------------------------------------------------------------------------');
1422:

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

1415:
1416:
1417:
1418: oe_debug_pub.add ('---------------------------------------------------------------------------');
1419: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||
1420: ' in orgn '||p_cfg_itm_tbl(i).cfg_org_id);
1421: oe_debug_pub.add ('---------------------------------------------------------------------------');
1422:
1423: open c_buy_items( p_cfg_itm_tbl(i).cfg_item_id,

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

1417:
1418: oe_debug_pub.add ('---------------------------------------------------------------------------');
1419: oe_debug_pub.add ('Processing config_item_id '|| p_cfg_itm_tbl(i).cfg_item_id ||
1420: ' in orgn '||p_cfg_itm_tbl(i).cfg_org_id);
1421: oe_debug_pub.add ('---------------------------------------------------------------------------');
1422:
1423: open c_buy_items( p_cfg_itm_tbl(i).cfg_item_id,
1424: p_cfg_itm_tbl(i).cfg_org_id) ;
1425:

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

1439: where org_id = c_oper_unit;
1440:
1441:
1442: IF PG_DEBUG <> 0 THEN
1443: oe_debug_pub.add('Cost_Roll_Up_ML ' ||
1444: ' model ' || c_model_item_id ||
1445: ' config ' || c_config_item_id ||
1446: ' org ' || c_org_id ||
1447: ' po val ' || c_po_valid_org ||

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

1463: when no_data_found then
1464: v_buy_cost := null ;
1465:
1466: IF PG_DEBUG <> 0 THEN
1467: oe_debug_pub.add('no buy cost exists for item ' || c_config_item_id
1468: || ' in org ' || c_org_id , 2);
1469: END IF;
1470:
1471:

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

1469: END IF;
1470:
1471:
1472: when others then
1473: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);
1474: oe_debug_pub.add(sqlerrm);
1475: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1476:
1477: end ;

Line 1474: oe_debug_pub.add(sqlerrm);

1470:
1471:
1472: when others then
1473: oe_debug_pub.add('Unexpected error while checking buy cost for item_id ' ||c_config_item_id|| ' in orgn '||c_org_id);
1474: oe_debug_pub.add(sqlerrm);
1475: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1476:
1477: end ;
1478:

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

1491: when no_data_found then
1492:
1493:
1494: IF PG_DEBUG <> 0 THEN
1495: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
1496: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_org_id , 1);
1497: END IF;
1498:
1499:

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

1492:
1493:
1494: IF PG_DEBUG <> 0 THEN
1495: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
1496: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_org_id , 1);
1497: END IF;
1498:
1499:
1500: -- cto_msg_pub.cto_message('BOM', l_xmsgdata);

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

1553:
1554: lStmtNumber := 35;
1555:
1556: IF PG_DEBUG <> 0 THEN
1557: oe_debug_pub.add('going to populate buy cost for item ' || c_config_item_id
1558: || ' for $ ' || v_buy_item_cost , 2);
1559: END IF;
1560:
1561: populate_buy_cost_rollup( c_config_item_id

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

1565: , x_return_status) ;
1566:
1567: if x_return_status = FND_API.G_RET_STS_ERROR then
1568: ROLLBACK to CTOCST;
1569: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1570: goto endloop;
1571:
1572: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1573: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');

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

1569: oe_debug_pub.add ('Expected error in populate_buy_cost_rollup.');
1570: goto endloop;
1571:
1572: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1573: oe_debug_pub.add ('UnExpected error in populate_buy_cost_rollup.');
1574: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1575: end if;
1576:
1577:

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

1577:
1578: else
1579:
1580: IF PG_DEBUG <> 0 THEN
1581: oe_debug_pub.add('buy cost exists for item ' || c_config_item_id
1582: || ' for $ ' || v_buy_cost , 2);
1583: END IF;
1584:
1585: end if ;

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

1595:
1596:
1597: lStmtNumber := 37;
1598: IF PG_DEBUG <> 0 THEN
1599: oe_debug_pub.add ('Fetching c_matched_items_cost_synchup cursor ..');
1600: END IF;
1601:
1602: /* copy valuation cost to cto cost for matched items */
1603:

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

1611:
1612: close c_matched_items_cost_synchup;
1613:
1614: IF PG_DEBUG <> 0 THEN
1615: oe_debug_pub.add ('c_match_config_item_id = '|| c_match_config_item_id || ';' ||
1616: 'c_organization_id = '|| c_organization_id || ';' ||
1617: 'c_primary_cost_method = '|| c_primary_cost_method || ';' ||
1618: 'c_valuation_cost = '|| c_valuation_cost );
1619: END IF;

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

1633:
1634: end;
1635:
1636: IF PG_DEBUG <> 0 THEN
1637: oe_debug_pub.add ('v_cto_cost = '|| v_cto_cost );
1638: END IF;
1639:
1640: lStmtNumber := 39;
1641: if( c_valuation_cost <> v_cto_cost or v_cto_cost is null ) then

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

1649: end if;
1650:
1651:
1652: IF PG_DEBUG <> 0 THEN
1653: oe_debug_pub.add('calling costing API', 2);
1654: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet || '; cto cost id ' || v_cto_cost_type_id ||
1655: ' buy cost id ' || v_buy_cost_type_id , 2);
1656:
1657: END IF;

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

1650:
1651:
1652: IF PG_DEBUG <> 0 THEN
1653: oe_debug_pub.add('calling costing API', 2);
1654: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet || '; cto cost id ' || v_cto_cost_type_id ||
1655: ' buy cost id ' || v_buy_cost_type_id , 2);
1656:
1657: END IF;
1658:

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

1712: If lCnt > 0 Then
1713: l_cost_data_exists := 'Y';
1714: End if;
1715: IF PG_DEBUG <> 0 THEN
1716: oe_debug_pub.add('populate_buy_cost: ' || 'rows inserted into bom_lists::'||to_char(lCnt), 2);
1717: END IF;
1718:
1719: << endloop>>
1720: null;

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

1740: -- Bug Fix 4867460
1741: If l_cost_data_exists = 'Y' Then
1742:
1743: If PG_DEBUG <> 0 Then
1744: oe_debug_pub.add('Populate_buy_cost: Calling Supply Chain Rollup program',5);
1745: End if;
1746:
1747: /* Commented as part of Bugfix 7246036
1748: CSTPSCEX.Supply_Chain_Rollup(

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

1793: i_buy_cost_detail => 1 ); --Bugfix 7246036: Passing preserve buy cost details parameter as Yes.
1794:
1795: IF lErrorCode <> 0 THEN
1796: IF PG_DEBUG <> 0 THEN
1797: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
1798: END IF;
1799: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1800: ELSE
1801: IF PG_DEBUG <> 0 THEN

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

1798: END IF;
1799: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1800: ELSE
1801: IF PG_DEBUG <> 0 THEN
1802: oe_debug_pub.add('populate_buy_cost: ' || 'SC Rollup API returned with success', 1);
1803: END IF;
1804:
1805:
1806: END IF;

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

1807:
1808: Else
1809:
1810: If PG_DEBUG <> 0 Then
1811: oe_debug_pub.add('Populate_buy_cost: No cost data exists. No need to call Supply chain Cost rollup API',5);
1812: End if;
1813:
1814: End if;
1815: /*

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

1849:
1850: IF (l_cost_update_required = 'Y') THEN
1851:
1852: IF PG_DEBUG <> 0 THEN
1853: oe_debug_pub.add('***************** going to do frozen cost update for config ' || c_config_item_id
1854: || ' in org ' || c_organization_id , 1);
1855: END IF;
1856:
1857:

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

1860: and organization_id = c_organization_id
1861: and cost_type_id = 1 ;
1862:
1863: IF PG_DEBUG <> 0 THEN
1864: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
1865: END IF;
1866:
1867:
1868: delete from cst_item_costs

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

1871: and cost_type_id = 1 ;
1872:
1873:
1874: IF PG_DEBUG <> 0 THEN
1875: oe_debug_pub.add('deleted headers ' || SQL%ROWCOUNT , 1);
1876: END IF;
1877:
1878:
1879: copy_ctocost_to_frozen ( c_config_item_id

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

1893:
1894:
1895:
1896: IF PG_DEBUG <> 0 THEN
1897: oe_debug_pub.add('populate_buy_cost: ' || 'At end of cost rollup', 2);
1898: END IF;
1899: return(1);
1900:
1901: EXCEPTION

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

1899: return(1);
1900:
1901: EXCEPTION
1902: WHEN NO_DATA_FOUND THEN
1903: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
1904: return(0);
1905:
1906: WHEN CTO_MRP_ASSIGNMENT_SET THEN
1907: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);

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

1903: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
1904: return(0);
1905:
1906: WHEN CTO_MRP_ASSIGNMENT_SET THEN
1907: oe_debug_pub.add ('populate_buy_cost: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);
1908:
1909: cto_msg_pub.count_and_get
1910: ( p_msg_count => x_msg_count
1911: , p_msg_data => x_msg_data

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

1914: return(0);
1915:
1916:
1917: WHEN FND_API.G_EXC_ERROR THEN
1918: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
1919:
1920: cto_msg_pub.count_and_get
1921: ( p_msg_count => x_msg_count
1922: , p_msg_data => x_msg_data

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

1926: return(0);
1927:
1928:
1929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1930: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
1931:
1932: cto_msg_pub.count_and_get
1933: ( p_msg_count => x_msg_count
1934: , p_msg_data => x_msg_data

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

1937:
1938: return(-1);
1939:
1940: WHEN OTHERS THEN
1941: oe_debug_pub.add ('Cost_Roll_Up_ML ' || 'cost_rollup::other excpn ::'||to_char(lStmtNumber)||sqlerrm, 1);
1942:
1943: cto_msg_pub.count_and_get
1944: ( p_msg_count => x_msg_count
1945: , p_msg_data => x_msg_data

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

2107:
2108: gUserId := nvl(fnd_global.user_id, -1);
2109: gLoginId := nvl(fnd_global.login_id, -1);
2110: IF PG_DEBUG <> 0 THEN
2111: oe_debug_pub.add('Cost_Rollup_ML: ' || 'gUserId::'||to_char(gUserId)
2112: ||'::gLoginId::'||to_char(gLoginId), 2);
2113:
2114: oe_debug_pub.add('Cost_Rollup_ML: ' || 'top line ::'|| pTopAtoLineId , 2 );
2115: END IF;

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

2110: IF PG_DEBUG <> 0 THEN
2111: oe_debug_pub.add('Cost_Rollup_ML: ' || 'gUserId::'||to_char(gUserId)
2112: ||'::gLoginId::'||to_char(gLoginId), 2);
2113:
2114: oe_debug_pub.add('Cost_Rollup_ML: ' || 'top line ::'|| pTopAtoLineId , 2 );
2115: END IF;
2116:
2117:
2118: -- changed sequence as per bugfix 3239456

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

2124:
2125:
2126:
2127: IF PG_DEBUG <> 0 THEN
2128: oe_debug_pub.add('Cost_Rollup_ML: ' || 'lRollupId::'||to_char(lRollupId), 2);
2129: END IF;
2130:
2131: lStmtNumber := 20;
2132: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

Line 2136: oe_debug_pub.add('Cost_Rollup_ML: '

2132: lMrpAssignmentSet := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
2133:
2134: IF lMrpAssignmentSet is null THEN
2135: IF PG_DEBUG <> 0 THEN
2136: oe_debug_pub.add('Cost_Rollup_ML: '
2137: || 'Default assignment set is null', 1);
2138: END IF;
2139:
2140:

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

2141: --FND_MESSAGE.set_name('BOM','CTO_MRP_ASSIGNMENT_SET');
2142: --raise CTO_MRP_ASSIGNMENT_SET;
2143: ELSE
2144: IF PG_DEBUG <> 0 THEN
2145: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Default assignment set is '
2146: ||to_char(lMrpAssignmentSet), 2);
2147: END IF;
2148: END IF;
2149:

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

2155: lConversionType := FND_PROFILE.VALUE('CURRENCY_CONVERSION_TYPE');
2156:
2157:
2158: IF PG_DEBUG <> 0 THEN
2159: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Currency Conversion Type ::'
2160: ||lConversionType, 2);
2161: END IF;
2162:
2163: lStmtNumber := 27;

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

2162:
2163: lStmtNumber := 27;
2164: lBuyCostType := FND_PROFILE.VALUE('CTO_BUY_COST_TYPE');
2165: IF PG_DEBUG <> 0 THEN
2166: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type ::'|| lBuyCostType , 2);
2167: END IF;
2168:
2169:
2170: lStmtNumber := 28;

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

2175: from cst_cost_types
2176: where cost_type = lBuyCostType ;
2177:
2178: IF PG_DEBUG <> 0 THEN
2179: oe_debug_pub.add('Cost_Rollup_ML: ' || 'Buy Cost Type id ::'
2180: || v_buy_cost_type_id , 2);
2181: END IF;
2182:
2183: exception

Line 2204: oe_debug_pub.add('Cost_Rollup_ML: '

2200:
2201: lStmtNumber := 29;
2202:
2203: IF PG_DEBUG <> 0 THEN
2204: oe_debug_pub.add('Cost_Rollup_ML: '
2205: || ' opening buy cost cursor for bcso ' , 2);
2206: END IF;
2207:
2208: if( lBuyCostType is not null ) then

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

2220:
2221: exit when c_buy_items%notfound ;
2222:
2223: IF PG_DEBUG <> 0 THEN
2224: oe_debug_pub.add('Cost_Rollup_ML: ' ||
2225: ' fetched line ' || c_line_id ||
2226: ' model ' || c_model_item_id ||
2227: ' config ' || c_config_item_id ||
2228: ' cost org ' || c_cost_org_id || --3116778

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

2244: when no_data_found then
2245: v_buy_cost := null ;
2246:
2247: IF PG_DEBUG <> 0 THEN
2248: oe_debug_pub.add('no buy cost exists for item ' || c_config_item_id
2249: || ' in org ' || c_cost_org_id , 2); -- 3116778
2250: END IF;
2251:
2252:

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

2277: when no_data_found then
2278:
2279:
2280: IF PG_DEBUG <> 0 THEN
2281: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
2282: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_cost_org_id , 1);
2283: END IF;
2284:
2285:

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

2278:
2279:
2280: IF PG_DEBUG <> 0 THEN
2281: oe_debug_pub.add('create_config_item_wf: ' || 'Item Not Enabled in PO Validation Org ' || c_po_valid_org , 1);
2282: oe_debug_pub.add('create_config_item_wf: ' || 'PO Validation Org for Org ' || c_cost_org_id , 1);
2283: END IF;
2284:
2285:
2286: -- cto_msg_pub.cto_message('BOM', l_xmsgdata);

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

2336:
2337: lStmtNumber := 35;
2338:
2339: IF PG_DEBUG <> 0 THEN
2340: oe_debug_pub.add('going to populate buy cost for item ' || c_config_item_id
2341: || ' for $ ' || v_buy_item_cost , 2);
2342: END IF;
2343:
2344: populate_buy_cost( c_line_id

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

2350:
2351: else
2352:
2353: IF PG_DEBUG <> 0 THEN
2354: oe_debug_pub.add('buy cost exists for item ' || c_config_item_id
2355: || ' for $ ' || v_buy_cost || 'in org ' || c_cost_org_id, 2); -- 3116778
2356: END IF;
2357:
2358: end if ;

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

2379: -- 2. costing_enabled_flag = Y
2380: -- 3. primary_cost_method = 1 (standard)
2381: --
2382: IF PG_DEBUG <> 0 THEN
2383: oe_debug_pub.add('Cost_Rollup_ML: ' || 'inserting into cst_sc_lists', 2);
2384: END IF;
2385:
2386:
2387: /*

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

2453:
2454: -- debug 3116778
2455: lCnt := sql%rowcount;
2456: IF PG_DEBUG <> 0 THEN
2457: oe_debug_pub.add('Cost_Rollup_ML: ' || 'rows inserted into cst_sc_lists::'||to_char(lCnt), 2);
2458: END IF;
2459: cst_sc_list_count := lCnt; -- Bug# 4867460
2460: open cst_cur ( lRollupId ) ;
2461:

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

2465:
2466: exit when cst_cur%notfound ;
2467:
2468: IF PG_DEBUG <> 0 THEN
2469: oe_debug_pub.add('Cst list has item : ' ||d_item_id|| ' in org ' || d_org_id,1);
2470: END IF;
2471:
2472: end loop;
2473: close cst_cur;

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

2476:
2477:
2478: lCnt := sql%rowcount;
2479: IF PG_DEBUG <> 0 THEN
2480: oe_debug_pub.add('Cost_Rollup_ML: ' || 'rows inserted into cst_sc_lists::'||to_char(lCnt), 2);
2481: END IF;
2482:
2483: --
2484: -- call SC Cost Rollup API

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

2533: exception
2534: when no_data_found then
2535:
2536: IF PG_DEBUG <> 0 THEN
2537: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
2538: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
2539: END IF;
2540:
2541: v_cto_cost_type_id := 7 ;

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

2534: when no_data_found then
2535:
2536: IF PG_DEBUG <> 0 THEN
2537: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
2538: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
2539: END IF;
2540:
2541: v_cto_cost_type_id := 7 ;
2542:

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

2545: from cst_cost_types
2546: where cost_type_id = v_cto_cost_type_id ;
2547:
2548: IF PG_DEBUG <> 0 THEN
2549: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || v_cto_cost_type_id ||
2550: ' has cost_type = ' || v_cto_cost_type_name ,2);
2551: END IF;
2552: exception
2553: when no_data_found then

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

2551: END IF;
2552: exception
2553: when no_data_found then
2554: IF PG_DEBUG <> 0 THEN
2555: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
2556: END IF;
2557: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
2558: raise FND_API.G_EXC_ERROR;
2559: when others then

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

2582:
2583: open c1_cst ( c1_config_item_id ) ;
2584:
2585: IF PG_DEBUG <> 0 THEN
2586: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2587: END IF;
2588:
2589: loop
2590:

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

2592:
2593: exit when c1_cst%notfound ;
2594:
2595: IF PG_DEBUG <> 0 THEN
2596: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2597: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||
2598: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2599: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2600: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||

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

2593: exit when c1_cst%notfound ;
2594:
2595: IF PG_DEBUG <> 0 THEN
2596: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2597: oe_debug_pub.add( 'iid ' || v_cur_c1_cst.inventory_item_id ||
2598: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2599: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2600: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||
2601: ' mcst ' || to_char( v_cur_c1_cst.material_cost ) ||

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

2607:
2608: end loop ;
2609:
2610: IF PG_DEBUG <> 0 THEN
2611: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;
2612: END IF;
2613:
2614: close c1_cst ;
2615:

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

2623: lStmtNumber := 60;
2624: if cst_sc_list_count > 0 then --bug4867460: call the costing api only if records are inserted
2625: -- in cst_sc_lists. This is to improve performance.
2626: IF PG_DEBUG <> 0 THEN
2627: oe_debug_pub.add('******************** calling costing API ****************** ', 2);
2628: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet ||
2629: ' cto cost id ' || v_cto_cost_type_id ||
2630: ' buy cost id ' || v_buy_cost_type_id , 2);
2631:

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

2624: if cst_sc_list_count > 0 then --bug4867460: call the costing api only if records are inserted
2625: -- in cst_sc_lists. This is to improve performance.
2626: IF PG_DEBUG <> 0 THEN
2627: oe_debug_pub.add('******************** calling costing API ****************** ', 2);
2628: oe_debug_pub.add(' Params assig set ' || lMrpAssignmentSet ||
2629: ' cto cost id ' || v_cto_cost_type_id ||
2630: ' buy cost id ' || v_buy_cost_type_id , 2);
2631:
2632: END IF;

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

2680: i_buy_cost_detail => 1 ); --Bugfix 7246036: Passing preserve buy cost details parameter as Yes.
2681:
2682: IF lErrorCode <> 0 THEN
2683: IF PG_DEBUG <> 0 THEN
2684: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with error::'||lErrorMsg, 1);
2685: END IF;
2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2687: ELSE
2688: IF PG_DEBUG <> 0 THEN

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

2685: END IF;
2686: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2687: ELSE
2688: IF PG_DEBUG <> 0 THEN
2689: oe_debug_pub.add('************** Cost_Rollup_ML: ' || 'SC Rollup API returned with success', 1);
2690: END IF;
2691:
2692:
2693: END IF;

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

2692:
2693: END IF;
2694: Else
2695: IF PG_DEBUG <> 0 Then
2696: oe_debug_pub.add('No cost data Exists. No need to call supply Chain cost rollup API',5);
2697: End if;
2698: End If; -- Bug fix 4867460
2699:
2700:

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

2702:
2703: open c1_cst ( c1_config_item_id ) ;
2704:
2705: IF PG_DEBUG <> 0 THEN
2706: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2707: END IF;
2708:
2709: loop
2710:

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

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

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

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

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

2726:
2727: end loop ;
2728:
2729: IF PG_DEBUG <> 0 THEN
2730: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;
2731: END IF;
2732:
2733: close c1_cst ;
2734:

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

2749: --Bugfix 6717614
2750: if cst_sc_list_count = 0 then
2751:
2752: IF PG_DEBUG <> 0 THEN
2753: oe_debug_pub.add('***No need to do frozen cost update as no rollup has been done' , 1);
2754: END IF;
2755:
2756: else
2757: /*update Frozen cost with CTO Cost in case of standard costing organizations */

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

2776: IF (l_cost_update_required = 'Y') THEN
2777:
2778:
2779: IF PG_DEBUG <> 0 THEN
2780: oe_debug_pub.add('********************** going to do frozen cost update for config ' || c_config_item_id
2781: || ' in org ' || c_organization_id , 1);
2782: END IF;
2783:
2784:

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

2787: and organization_id = c_organization_id
2788: and cost_type_id = 1 ;
2789:
2790: IF PG_DEBUG <> 0 THEN
2791: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
2792: END IF;
2793:
2794:
2795: delete from cst_item_costs

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

2798: and cost_type_id = 1 ;
2799:
2800:
2801: IF PG_DEBUG <> 0 THEN
2802: oe_debug_pub.add('deleted headers ' || SQL%ROWCOUNT , 1);
2803: END IF;
2804:
2805:
2806: copy_ctocost_to_frozen ( c_config_item_id

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

2819:
2820: open c1_cst ( c1_config_item_id ) ;
2821:
2822: IF PG_DEBUG <> 0 THEN
2823: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2824: END IF;
2825:
2826: loop
2827:

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

2829:
2830: exit when c1_cst%notfound ;
2831:
2832: IF PG_DEBUG <> 0 THEN
2833: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2834: oe_debug_pub.add( ' iid ' || v_cur_c1_cst.inventory_item_id ||
2835: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2836: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2837: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||

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

2830: exit when c1_cst%notfound ;
2831:
2832: IF PG_DEBUG <> 0 THEN
2833: oe_debug_pub.add( 'printing sc rollup values ' ,1 ) ;
2834: oe_debug_pub.add( ' iid ' || v_cur_c1_cst.inventory_item_id ||
2835: ' org ' || to_char( v_cur_c1_cst.organization_id) ||
2836: ' cstyp ' || to_char( v_cur_c1_cst.cost_type_id) ||
2837: ' icst ' || to_char( v_cur_c1_cst.item_cost ) ||
2838: ' mcst ' || to_char( v_cur_c1_cst.material_cost ) ||

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

2843:
2844: end loop ;
2845:
2846: IF PG_DEBUG <> 0 THEN
2847: oe_debug_pub.add( 'done printing sc rollup values ' ,1 ) ;
2848: END IF;
2849:
2850: close c1_cst ;
2851:

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

2853:
2854:
2855:
2856: IF PG_DEBUG <> 0 THEN
2857: oe_debug_pub.add('Cost_Rollup_ML: ' || 'At end of cost rollup', 2);
2858: END IF;
2859: return(1);
2860:
2861: EXCEPTION

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

2859: return(1);
2860:
2861: EXCEPTION
2862: WHEN NO_DATA_FOUND THEN
2863: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
2864: return(0);
2865:
2866: WHEN CTO_MRP_ASSIGNMENT_SET THEN
2867: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);

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

2863: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::ndf::'||to_char(lStmtNumber)||sqlerrm, 1);
2864: return(0);
2865:
2866: WHEN CTO_MRP_ASSIGNMENT_SET THEN
2867: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::mrp assgn set is null'||to_char(lStmtNumber)||sqlerrm, 1);
2868:
2869: cto_msg_pub.count_and_get
2870: ( p_msg_count => x_msg_count
2871: , p_msg_data => x_msg_data

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

2875: return(0);
2876:
2877:
2878: WHEN FND_API.G_EXC_ERROR THEN
2879: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::exp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2880:
2881: cto_msg_pub.count_and_get
2882: ( p_msg_count => x_msg_count
2883: , p_msg_data => x_msg_data

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

2887: return(0);
2888:
2889:
2890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2891: oe_debug_pub.add ('Cost_Rollup_ML: ' || 'cost_rollup::unexp error::'||to_char(lStmtNumber)||sqlerrm, 1);
2892:
2893: cto_msg_pub.count_and_get
2894: ( p_msg_count => x_msg_count
2895: , p_msg_data => x_msg_data