DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on OE_DEBUG_PUB

Line 1304: oe_debug_pub.add( i || ') ' || 'Cost Header Info: ' ||

1300: if( l_rt_cicd_summary.cost_organization_id.count > 0 ) then
1301: for i in l_rt_cicd_summary.cost_organization_id.first..l_rt_cicd_summary.cost_organization_id.last
1302: loop
1303:
1304: oe_debug_pub.add( i || ') ' || 'Cost Header Info: ' ||
1305: ' CFG ID ' || l_rt_cicd_summary.config_item_id(i) ||
1306: ' cst org ' || l_rt_cicd_summary.cost_organization_id(i) ||
1307: ' cst id ' || l_rt_cicd_summary.cost_type_id(i) ||
1308: ' m cost ' || l_rt_cicd_summary.material_cost(i) ||

Line 1322: oe_debug_pub.add( ' item cost ' || l_rt_cicd_summary.item_cost(i) , 1 );

1318: + l_rt_cicd_summary.overhead_cost(i) ;
1319:
1320:
1321:
1322: oe_debug_pub.add( ' item cost ' || l_rt_cicd_summary.item_cost(i) , 1 );
1323:
1324:
1325: end loop ;
1326:

Line 1331: oe_debug_pub.add( ' no new item cost records for upgrade ' , 1 );

1327:
1328: else
1329:
1330:
1331: oe_debug_pub.add( ' no new item cost records for upgrade ' , 1 );
1332:
1333: end if;
1334:
1335:

Line 1500: oe_debug_pub.add('Create_Item: ' || 'after update:CST_ITEM_COSTS '|| to_char(sql%rowcount),2);

1496: and cost_type_id = l_rt_cicd_summary.cost_type_id(j) ;
1497:
1498:
1499: IF PG_DEBUG <> 0 THEN
1500: oe_debug_pub.add('Create_Item: ' || 'after update:CST_ITEM_COSTS '|| to_char(sql%rowcount),2);
1501: END IF;
1502: else
1503:
1504: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS as no new records inserted ' , 1 ) ;

Line 1504: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS as no new records inserted ' , 1 ) ;

1500: oe_debug_pub.add('Create_Item: ' || 'after update:CST_ITEM_COSTS '|| to_char(sql%rowcount),2);
1501: END IF;
1502: else
1503:
1504: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS as no new records inserted ' , 1 ) ;
1505:
1506: end if;
1507:
1508:

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

1526: exception
1527: when no_data_found then
1528:
1529: IF PG_DEBUG <> 0 THEN
1530: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1531: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1532: END IF;
1533:
1534: l_cto_cost_type_id := 7 ;

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

1527: when no_data_found then
1528:
1529: IF PG_DEBUG <> 0 THEN
1530: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1531: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1532: END IF;
1533:
1534: l_cto_cost_type_id := 7 ;
1535:

Line 1542: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || l_cto_cost_type_id ||

1538: from cst_cost_types
1539: where cost_type_id = l_cto_cost_type_id ;
1540:
1541: IF PG_DEBUG <> 0 THEN
1542: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || l_cto_cost_type_id ||
1543: ' has cost_type = ' || v_cto_cost_type_name ,2);
1544: END IF;
1545: exception
1546: when no_data_found then

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

1544: END IF;
1545: exception
1546: when no_data_found then
1547: IF PG_DEBUG <> 0 THEN
1548: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1549: END IF;
1550: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1551: raise FND_API.G_EXC_ERROR;
1552: when others then

Line 1724: oe_debug_pub.add('Create_Item: ' || 'after update:cst_item_costs for CTO cost type '||to_char(sql%rowcount),2);

1720: and cost_type_id = l_cto_cost_type_id ;
1721:
1722:
1723: IF PG_DEBUG <> 0 THEN
1724: oe_debug_pub.add('Create_Item: ' || 'after update:cst_item_costs for CTO cost type '||to_char(sql%rowcount),2);
1725: END IF;
1726:
1727: else
1728:

Line 1729: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS for CTO cost type as no new records inserted ' , 1 ) ;

1725: END IF;
1726:
1727: else
1728:
1729: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS for CTO cost type as no new records inserted ' , 1 ) ;
1730:
1731: end if;
1732:
1733: