DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on OE_DEBUG_PUB

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

1443: if( l_rt_cicd_summary.cost_organization_id.count > 0 ) then
1444: for i in l_rt_cicd_summary.cost_organization_id.first..l_rt_cicd_summary.cost_organization_id.last
1445: loop
1446:
1447: oe_debug_pub.add( i || ') ' || 'Cost Header Info: ' ||
1448: ' CFG ID ' || l_rt_cicd_summary.config_item_id(i) ||
1449: ' cst org ' || l_rt_cicd_summary.cost_organization_id(i) ||
1450: ' cst id ' || l_rt_cicd_summary.cost_type_id(i) ||
1451: ' m cost ' || l_rt_cicd_summary.material_cost(i) ||

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

1461: + l_rt_cicd_summary.overhead_cost(i) ;
1462:
1463:
1464:
1465: oe_debug_pub.add( ' item cost ' || l_rt_cicd_summary.item_cost(i) , 1 );
1466:
1467:
1468: end loop ;
1469:

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

1470:
1471: else
1472:
1473:
1474: oe_debug_pub.add( ' no new item cost records for upgrade ' , 1 );
1475:
1476: end if;
1477:
1478:

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

1639: and cost_type_id = l_rt_cicd_summary.cost_type_id(j) ;
1640:
1641:
1642: IF PG_DEBUG <> 0 THEN
1643: oe_debug_pub.add('Create_Item: ' || 'after update:CST_ITEM_COSTS '|| to_char(sql%rowcount),2);
1644: END IF;
1645: else
1646:
1647: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS as no new records inserted ' , 1 ) ;

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

1643: oe_debug_pub.add('Create_Item: ' || 'after update:CST_ITEM_COSTS '|| to_char(sql%rowcount),2);
1644: END IF;
1645: else
1646:
1647: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS as no new records inserted ' , 1 ) ;
1648:
1649: end if;
1650:
1651:

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

1669: exception
1670: when no_data_found then
1671:
1672: IF PG_DEBUG <> 0 THEN
1673: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1674: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1675: END IF;
1676:
1677: l_cto_cost_type_id := 7 ;

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

1670: when no_data_found then
1671:
1672: IF PG_DEBUG <> 0 THEN
1673: oe_debug_pub.add('Create_Item: ' || ' no_data_found error CTO cost type id does not exist',2);
1674: oe_debug_pub.add('Create_Item: ' || ' defaulting CTO cost type id = 7 ',2);
1675: END IF;
1676:
1677: l_cto_cost_type_id := 7 ;
1678:

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

1681: from cst_cost_types
1682: where cost_type_id = l_cto_cost_type_id ;
1683:
1684: IF PG_DEBUG <> 0 THEN
1685: oe_debug_pub.add('Create_Item: ' || ' cost type id = ' || l_cto_cost_type_id ||
1686: ' has cost_type = ' || v_cto_cost_type_name ,2);
1687: END IF;
1688: exception
1689: when no_data_found then

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

1687: END IF;
1688: exception
1689: when no_data_found then
1690: IF PG_DEBUG <> 0 THEN
1691: oe_debug_pub.add('Create_Item: ' || ' no_data_found error for cost type id = 7 ',2);
1692: END IF;
1693: cto_msg_pub.cto_message('BOM','CTO_COST_NOT_FOUND');
1694: raise FND_API.G_EXC_ERROR;
1695: when others then

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

1863: and cost_type_id = l_cto_cost_type_id ;
1864:
1865:
1866: IF PG_DEBUG <> 0 THEN
1867: oe_debug_pub.add('Create_Item: ' || 'after update:cst_item_costs for CTO cost type '||to_char(sql%rowcount),2);
1868: END IF;
1869:
1870: else
1871:

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

1868: END IF;
1869:
1870: else
1871:
1872: oe_debug_pub.add( 'No update required to CST_ITEM_COSTS for CTO cost type as no new records inserted ' , 1 ) ;
1873:
1874: end if;
1875:
1876: