APPS.CTO_UPDATE_CONFIGS_PK dependencies on OE_DEBUG_PUB

Line 3845: oe_debug_pub.add('Check_invalid_configurations: ' ||

3841: t_ato_line_id( t_ato_line_id.last+1) := t_bcol(i).ato_line_id;
3842: END IF; --t_ato_line_id
3843:
3844: IF PG_DEBUG <> 0 THEN
3845: oe_debug_pub.add('Check_invalid_configurations: ' ||
3846: 'INVALID MODEL SETUP exists for line id ' ||t_bcol(i).line_id
3847: || ' model item ' || t_bcol(i).inventory_item_id
3848: || ' Ship from org'||t_bcol(i).ship_from_org_id
3849: || ' item config creation ' || t_bcol(i).config_creation

Line 3869: oe_debug_pub.add('There are NO invalid configurations',5);

3865: end loop ;
3866:
3867: l_stmt_num := 70;
3868: IF t_ato_line_id.count = 0 THEN
3869: oe_debug_pub.add('There are NO invalid configurations',5);
3870:
3871: ELSIF t_ato_line_id.count > 0 THEN
3872: l_stmt_num := 75;
3873: oe_debug_pub.add('There are ' || t_ato_line_id.count ||'top ato models with invalid configurations');

Line 3873: oe_debug_pub.add('There are ' || t_ato_line_id.count ||'top ato models with invalid configurations');

3869: oe_debug_pub.add('There are NO invalid configurations',5);
3870:
3871: ELSIF t_ato_line_id.count > 0 THEN
3872: l_stmt_num := 75;
3873: oe_debug_pub.add('There are ' || t_ato_line_id.count ||'top ato models with invalid configurations');
3874:
3875: l_stmt_num := 80;
3876: FORALL j IN t_ato_line_id.first..t_ato_line_id.last
3877: UPDATE bom_cto_order_lines_upg

Line 3882: oe_debug_pub.add('Updated '||sql%rowcount||'lines with error status',1);

3878: SET status = 'ERROR'
3879: WHERE ato_line_id = t_ato_line_id(j);
3880:
3881: l_stmt_num:= 90;
3882: oe_debug_pub.add('Updated '||sql%rowcount||'lines with error status',1);
3883:
3884: END IF;
3885:
3886: