APPS.CTO_UPDATE_CONFIGS_PK dependencies on OE_DEBUG_PUB

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

4221: t_ato_line_id( t_ato_line_id.last+1) := t_bcol(i).ato_line_id;
4222: END IF; --t_ato_line_id
4223:
4224: IF PG_DEBUG <> 0 THEN
4225: oe_debug_pub.add('Check_invalid_configurations: ' ||
4226: 'INVALID MODEL SETUP exists for line id ' ||t_bcol(i).line_id
4227: || ' model item ' || t_bcol(i).inventory_item_id
4228: || ' Ship from org'||t_bcol(i).ship_from_org_id
4229: || ' item config creation ' || t_bcol(i).config_creation

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

4245: end loop ;
4246:
4247: l_stmt_num := 70;
4248: IF t_ato_line_id.count = 0 THEN
4249: oe_debug_pub.add('There are NO invalid configurations',5);
4250:
4251: ELSIF t_ato_line_id.count > 0 THEN
4252: l_stmt_num := 75;
4253: oe_debug_pub.add('There are ' || t_ato_line_id.count ||'top ato models with invalid configurations');

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

4249: oe_debug_pub.add('There are NO invalid configurations',5);
4250:
4251: ELSIF t_ato_line_id.count > 0 THEN
4252: l_stmt_num := 75;
4253: oe_debug_pub.add('There are ' || t_ato_line_id.count ||'top ato models with invalid configurations');
4254:
4255: l_stmt_num := 80;
4256: FORALL j IN t_ato_line_id.first..t_ato_line_id.last
4257: UPDATE bom_cto_order_lines_upg

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

4258: SET status = 'ERROR'
4259: WHERE ato_line_id = t_ato_line_id(j);
4260:
4261: l_stmt_num:= 90;
4262: oe_debug_pub.add('Updated '||sql%rowcount||'lines with error status',1);
4263:
4264: END IF;
4265:
4266: