459: from mtl_system_items_kfv
460: where inventory_item_id = var_comp_id
461: and organization_id = arg_org_id;
462:
463: fnd_message.set_name('FLM','FLM_SYNCH_INVALID_SEQ');
464: fnd_message.set_token('SCHEDULE',arg_schedule_number);
465: fnd_message.set_token('COMPONENT',var_comp_name);
466: MRP_UTIL.MRP_LOG(fnd_message.get);
467: var_line_op_seq_id := NULL;
460: where inventory_item_id = var_comp_id
461: and organization_id = arg_org_id;
462:
463: fnd_message.set_name('FLM','FLM_SYNCH_INVALID_SEQ');
464: fnd_message.set_token('SCHEDULE',arg_schedule_number);
465: fnd_message.set_token('COMPONENT',var_comp_name);
466: MRP_UTIL.MRP_LOG(fnd_message.get);
467: var_line_op_seq_id := NULL;
468: var_status := fnd_concurrent.set_completion_status( status => 'WARNING',
461: and organization_id = arg_org_id;
462:
463: fnd_message.set_name('FLM','FLM_SYNCH_INVALID_SEQ');
464: fnd_message.set_token('SCHEDULE',arg_schedule_number);
465: fnd_message.set_token('COMPONENT',var_comp_name);
466: MRP_UTIL.MRP_LOG(fnd_message.get);
467: var_line_op_seq_id := NULL;
468: var_status := fnd_concurrent.set_completion_status( status => 'WARNING',
469: message => '');
462:
463: fnd_message.set_name('FLM','FLM_SYNCH_INVALID_SEQ');
464: fnd_message.set_token('SCHEDULE',arg_schedule_number);
465: fnd_message.set_token('COMPONENT',var_comp_name);
466: MRP_UTIL.MRP_LOG(fnd_message.get);
467: var_line_op_seq_id := NULL;
468: var_status := fnd_concurrent.set_completion_status( status => 'WARNING',
469: message => '');
470:
601: var_alt_rtg := scheds1.alternate_routing_designator;
602: var_roll_forwarded_flag := scheds1.roll_forwarded_flag;
603:
604: if (var_roll_forwarded_flag = 1) then
605: fnd_message.set_name('FLM','FLM_SYNCH_ROLL_FORWARDED');
606: fnd_message.set_token('SCHEDULE',var_schedule_number);
607: MRP_UTIL.MRP_LOG(fnd_message.get);
608: else
609: if g_debug then
602: var_roll_forwarded_flag := scheds1.roll_forwarded_flag;
603:
604: if (var_roll_forwarded_flag = 1) then
605: fnd_message.set_name('FLM','FLM_SYNCH_ROLL_FORWARDED');
606: fnd_message.set_token('SCHEDULE',var_schedule_number);
607: MRP_UTIL.MRP_LOG(fnd_message.get);
608: else
609: if g_debug then
610: MRP_UTIL.MRP_LOG('Retrieved Schedules '||
603:
604: if (var_roll_forwarded_flag = 1) then
605: fnd_message.set_name('FLM','FLM_SYNCH_ROLL_FORWARDED');
606: fnd_message.set_token('SCHEDULE',var_schedule_number);
607: MRP_UTIL.MRP_LOG(fnd_message.get);
608: else
609: if g_debug then
610: MRP_UTIL.MRP_LOG('Retrieved Schedules '||
611: ' Assy '|| to_char(var_assy_item_id) ||