DBA Data[Home] [Help]

APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on MRP_UTIL

Line 315: MRP_UTIL.MRP_LOG('In get assemblies');

311: assy_table(1).usage := 1;
312: max_comp_count := 0;
313:
314: if g_debug then
315: MRP_UTIL.MRP_LOG('In get assemblies');
316: end if;
317: /* Added to retrive inherit_phantom_op_seq value for Bug # 1973152 */
318: SELECT inherit_phantom_op_seq INTO var_inherit_phantom
319: from bom_parameters

Line 363: MRP_UTIL.MRP_LOG(' Component ' || to_char(var_comp_id) ||

359: var_basis_type := comp_record.basis_type;
360: var_qty_per_lot := comp_record.component_quantity;
361:
362: if g_debug then
363: MRP_UTIL.MRP_LOG(' Component ' || to_char(var_comp_id) ||
364: ' Usage '|| to_char(var_usage) ||
365: ' Wip Supply type '|| to_char(var_wip_supply_type) ||
366: ' Basis Type '||to_char(var_basis_type) ||
367: ' Qty '||to_char(var_qty_per_lot));

Line 371: MRP_UTIL.MRP_LOG('Phantom Component ');

367: ' Qty '||to_char(var_qty_per_lot));
368: end if;
369: if var_wip_supply_type = 6 then
370: if g_debug then
371: MRP_UTIL.MRP_LOG('Phantom Component ');
372: end if;
373: max_assy_count := max_assy_count + 1;
374: assy_table(max_assy_count).item_id := var_comp_id;
375: assy_table(max_assy_count).usage :=

Line 423: MRP_UTIL.MRP_LOG(' Line '|| to_char(var_line_id));

419: WHEN no_data_found THEN
420: var_line_id := NULL;
421: end;
422: if g_debug then
423: MRP_UTIL.MRP_LOG(' Line '|| to_char(var_line_id));
424: end if;
425: if var_line_id is not null then
426: -- If it's 1st level Subassembly, the component operation_seq_num
427: -- is the operation_seq_num obtained from the BOM. Otherwise,

Line 466: MRP_UTIL.MRP_LOG(fnd_message.get);

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:

Line 473: MRP_UTIL.MRP_LOG(' Line-Op : '|| to_char(var_line_op_seq_id));

469: message => '');
470:
471: end;
472: if g_debug then
473: MRP_UTIL.MRP_LOG(' Line-Op : '|| to_char(var_line_op_seq_id));
474: end if;
475: if g_debug then
476: MRP_UTIL.MRP_LOG(' Line-op : '|| to_char(var_operation_seq_num));
477: end if;

Line 476: MRP_UTIL.MRP_LOG(' Line-op : '|| to_char(var_operation_seq_num));

472: if g_debug then
473: MRP_UTIL.MRP_LOG(' Line-Op : '|| to_char(var_line_op_seq_id));
474: end if;
475: if g_debug then
476: MRP_UTIL.MRP_LOG(' Line-op : '|| to_char(var_operation_seq_num));
477: end if;
478:
479: -- Find out if the component used in the particular operation seq number has
480: -- been synchronized

Line 607: MRP_UTIL.MRP_LOG(fnd_message.get);

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) ||

Line 610: MRP_UTIL.MRP_LOG('Retrieved Schedules '||

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) ||
612: ' Line '|| to_char(var_line_id) ||
613: ' Qty '|| to_char(var_qty) ||
614: ' Start Date'|| to_char(var_start_date) ||

Line 637: MRP_UTIL.MRP_LOG(

633: var_current_row := 1;
634:
635: while var_comp_tbl.EXISTS(var_current_row) LOOP
636: if g_debug then
637: MRP_UTIL.MRP_LOG(
638: ' Component '||
639: to_char(var_comp_tbl(var_current_row).item_id) ||
640: ' Usage '||
641: to_char(var_comp_tbl(var_current_row).usage));

Line 736: MRP_UTIL.MRP_LOG('Found build sequence '||

732: loop_count := loop_count + 1;
733:
734: EXIT WHEN var_count = 0;
735: if g_debug then
736: MRP_UTIL.MRP_LOG('Found build sequence '||
737: to_char(var_build_seq_id));
738: end if;
739: var_x := ROUND(1/(10*loop_count), 6);
740: var_y := ROUND(1/(10*(loop_count-1)), 6);

Line 753: MRP_UTIL.MRP_LOG('Creating schedule: '||

749: -- at this point, var_build_seq_id holds the correct build_sequence
750: l_flow_schedule_rec.build_sequence := var_build_seq_id;
751:
752: if g_debug then
753: MRP_UTIL.MRP_LOG('Creating schedule: '||
754: ' Assy ' ||
755: to_char(l_flow_schedule_rec.primary_item_id) ||
756: ' Line ' ||
757: to_char(l_flow_schedule_rec.line_id) ||