eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_KANBAN_PLAN_PK dependencies on MRP_UTIL

Line 26: MRP_UTIL.MRP_LOG (g_log_message);

22:
23: g_stmt_num := 20;
24: IF g_debug THEN
25: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
26: MRP_UTIL.MRP_LOG (g_log_message);
27: g_log_message := 'Entering Start_Kanban_Plan function';
28: MRP_UTIL.MRP_LOG (g_log_message);
29: END IF;
30:

Line 28: MRP_UTIL.MRP_LOG (g_log_message);

24: IF g_debug THEN
25: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
26: MRP_UTIL.MRP_LOG (g_log_message);
27: g_log_message := 'Entering Start_Kanban_Plan function';
28: MRP_UTIL.MRP_LOG (g_log_message);
29: END IF;
30:
31:
32: -- ------------------------------------------------------------------------

Line 112: MRP_UTIL.MRP_LOG (g_log_message);

108: -- and then blow it down to the component item/locations
109:
110: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN
111: g_log_message := 'Error in SNAPSHOT_ITEM_LOCATIONS';
112: MRP_UTIL.MRP_LOG (g_log_message);
113: raise exc_error_condition;
114: END IF;
115:
116: commit;

Line 135: MRP_UTIL.MRP_LOG (g_log_message);

131:
132: WHEN exc_error_condition THEN
133: ROLLBACK;
134: g_log_message := 'Program encountered Error condition Exception';
135: MRP_UTIL.MRP_LOG (g_log_message);
136: RETURN FALSE;
137:
138: WHEN exc_replan_error THEN
139: g_log_message := 'Incomplete Information For Replan';

Line 140: MRP_UTIL.MRP_LOG (g_log_message);

136: RETURN FALSE;
137:
138: WHEN exc_replan_error THEN
139: g_log_message := 'Incomplete Information For Replan';
140: MRP_UTIL.MRP_LOG (g_log_message);
141: Return FALSE;
142:
143: WHEN NO_DATA_FOUND THEN
144: g_log_message := 'Invalid Kanban Plan Id';

Line 145: MRP_UTIL.MRP_LOG (g_log_message);

141: Return FALSE;
142:
143: WHEN NO_DATA_FOUND THEN
144: g_log_message := 'Invalid Kanban Plan Id';
145: MRP_UTIL.MRP_LOG (g_log_message);
146: Return FALSE;
147:
148: WHEN OTHERS THEN
149: g_log_message := 'START_KANBAN_PLAN Sql Error ';

Line 150: MRP_UTIL.MRP_LOG (g_log_message);

146: Return FALSE;
147:
148: WHEN OTHERS THEN
149: g_log_message := 'START_KANBAN_PLAN Sql Error ';
150: MRP_UTIL.MRP_LOG (g_log_message);
151: g_log_message := sqlerrm;
152: MRP_UTIL.MRP_LOG (g_log_message);
153: RETURN FALSE;
154:

Line 152: MRP_UTIL.MRP_LOG (g_log_message);

148: WHEN OTHERS THEN
149: g_log_message := 'START_KANBAN_PLAN Sql Error ';
150: MRP_UTIL.MRP_LOG (g_log_message);
151: g_log_message := sqlerrm;
152: MRP_UTIL.MRP_LOG (g_log_message);
153: RETURN FALSE;
154:
155: END START_KANBAN_PLAN;
156:

Line 187: MRP_UTIL.MRP_LOG (g_log_message);

183: EXCEPTION
184:
185: WHEN OTHERS THEN
186: g_log_message := 'END_KANBAN_PLAN Sql Error ';
187: MRP_UTIL.MRP_LOG (g_log_message);
188: g_log_message := sqlerrm;
189: MRP_UTIL.MRP_LOG (g_log_message);
190: RETURN FALSE;
191:

Line 189: MRP_UTIL.MRP_LOG (g_log_message);

185: WHEN OTHERS THEN
186: g_log_message := 'END_KANBAN_PLAN Sql Error ';
187: MRP_UTIL.MRP_LOG (g_log_message);
188: g_log_message := sqlerrm;
189: MRP_UTIL.MRP_LOG (g_log_message);
190: RETURN FALSE;
191:
192: END END_KANBAN_PLAN;
193:

Line 260: MRP_UTIL.MRP_LOG (g_log_message);

256: BEGIN
257:
258: IF g_debug THEN
259: g_log_message := 'Entering Get_Prorated_Demand Function';
260: MRP_UTIL.MRP_LOG (g_log_message);
261: g_log_message := 'Bucket_Type : ' || to_char (p_bucket_type);
262: MRP_UTIL.MRP_LOG (g_log_message);
263: g_log_message := 'In demand date : ' ||
264: fnd_date.date_to_canonical(p_in_demand_date);

Line 262: MRP_UTIL.MRP_LOG (g_log_message);

258: IF g_debug THEN
259: g_log_message := 'Entering Get_Prorated_Demand Function';
260: MRP_UTIL.MRP_LOG (g_log_message);
261: g_log_message := 'Bucket_Type : ' || to_char (p_bucket_type);
262: MRP_UTIL.MRP_LOG (g_log_message);
263: g_log_message := 'In demand date : ' ||
264: fnd_date.date_to_canonical(p_in_demand_date);
265: MRP_UTIL.MRP_LOG (g_log_message);
266: g_log_message := 'In Rate end date : ' ||

Line 265: MRP_UTIL.MRP_LOG (g_log_message);

261: g_log_message := 'Bucket_Type : ' || to_char (p_bucket_type);
262: MRP_UTIL.MRP_LOG (g_log_message);
263: g_log_message := 'In demand date : ' ||
264: fnd_date.date_to_canonical(p_in_demand_date);
265: MRP_UTIL.MRP_LOG (g_log_message);
266: g_log_message := 'In Rate end date : ' ||
267: fnd_date.date_to_canonical(p_in_rate_end_date);
268: MRP_UTIL.MRP_LOG (g_log_message);
269: g_log_message := 'In demand qty : ' || to_char (p_in_demand_qty);

Line 268: MRP_UTIL.MRP_LOG (g_log_message);

264: fnd_date.date_to_canonical(p_in_demand_date);
265: MRP_UTIL.MRP_LOG (g_log_message);
266: g_log_message := 'In Rate end date : ' ||
267: fnd_date.date_to_canonical(p_in_rate_end_date);
268: MRP_UTIL.MRP_LOG (g_log_message);
269: g_log_message := 'In demand qty : ' || to_char (p_in_demand_qty);
270: MRP_UTIL.MRP_LOG (g_log_message);
271: END IF;
272: --initialize

Line 270: MRP_UTIL.MRP_LOG (g_log_message);

266: g_log_message := 'In Rate end date : ' ||
267: fnd_date.date_to_canonical(p_in_rate_end_date);
268: MRP_UTIL.MRP_LOG (g_log_message);
269: g_log_message := 'In demand qty : ' || to_char (p_in_demand_qty);
270: MRP_UTIL.MRP_LOG (g_log_message);
271: END IF;
272: --initialize
273:
274: l_demand_date := p_in_demand_date;

Line 411: MRP_UTIL.MRP_LOG (g_log_message);

407: p_out_demand_qty := l_demand_quantity;
408:
409: IF g_debug THEN
410: g_log_message := 'Current workdays : ' || to_char (l_current_workdays);
411: MRP_UTIL.MRP_LOG (g_log_message);
412: g_log_message := 'Total Workdays : ' || to_char (l_total_workdays);
413: MRP_UTIL.MRP_LOG (g_log_message);
414: g_log_message := 'Out Demand Date : ' || to_char (l_demand_date);
415: MRP_UTIL.MRP_LOG (g_log_message);

Line 413: MRP_UTIL.MRP_LOG (g_log_message);

409: IF g_debug THEN
410: g_log_message := 'Current workdays : ' || to_char (l_current_workdays);
411: MRP_UTIL.MRP_LOG (g_log_message);
412: g_log_message := 'Total Workdays : ' || to_char (l_total_workdays);
413: MRP_UTIL.MRP_LOG (g_log_message);
414: g_log_message := 'Out Demand Date : ' || to_char (l_demand_date);
415: MRP_UTIL.MRP_LOG (g_log_message);
416: g_log_message := 'Out Demand qty : ' || to_char (l_demand_quantity);
417: MRP_UTIL.MRP_LOG (g_log_message);

Line 415: MRP_UTIL.MRP_LOG (g_log_message);

411: MRP_UTIL.MRP_LOG (g_log_message);
412: g_log_message := 'Total Workdays : ' || to_char (l_total_workdays);
413: MRP_UTIL.MRP_LOG (g_log_message);
414: g_log_message := 'Out Demand Date : ' || to_char (l_demand_date);
415: MRP_UTIL.MRP_LOG (g_log_message);
416: g_log_message := 'Out Demand qty : ' || to_char (l_demand_quantity);
417: MRP_UTIL.MRP_LOG (g_log_message);
418: g_log_message := 'Exiting Get_Prorated_Demand Function';
419: MRP_UTIL.MRP_LOG (g_log_message);

Line 417: MRP_UTIL.MRP_LOG (g_log_message);

413: MRP_UTIL.MRP_LOG (g_log_message);
414: g_log_message := 'Out Demand Date : ' || to_char (l_demand_date);
415: MRP_UTIL.MRP_LOG (g_log_message);
416: g_log_message := 'Out Demand qty : ' || to_char (l_demand_quantity);
417: MRP_UTIL.MRP_LOG (g_log_message);
418: g_log_message := 'Exiting Get_Prorated_Demand Function';
419: MRP_UTIL.MRP_LOG (g_log_message);
420: END IF;
421:

Line 419: MRP_UTIL.MRP_LOG (g_log_message);

415: MRP_UTIL.MRP_LOG (g_log_message);
416: g_log_message := 'Out Demand qty : ' || to_char (l_demand_quantity);
417: MRP_UTIL.MRP_LOG (g_log_message);
418: g_log_message := 'Exiting Get_Prorated_Demand Function';
419: MRP_UTIL.MRP_LOG (g_log_message);
420: END IF;
421:
422: RETURN TRUE;
423:

Line 427: MRP_UTIL.MRP_LOG (g_log_message);

423:
424: EXCEPTION
425: WHEN OTHERS THEN
426: g_log_message := 'GET_PRORATED_DEMAND Sql Error ';
427: MRP_UTIL.MRP_LOG (g_log_message);
428: g_log_message := sqlerrm;
429: MRP_UTIL.MRP_LOG (g_log_message);
430: RETURN FALSE;
431:

Line 429: MRP_UTIL.MRP_LOG (g_log_message);

425: WHEN OTHERS THEN
426: g_log_message := 'GET_PRORATED_DEMAND Sql Error ';
427: MRP_UTIL.MRP_LOG (g_log_message);
428: g_log_message := sqlerrm;
429: MRP_UTIL.MRP_LOG (g_log_message);
430: RETURN FALSE;
431:
432: END Get_Prorated_Demand;
433:

Line 502: MRP_UTIL.MRP_LOG (g_log_message);

498: BEGIN
499:
500: IF g_debug THEN
501: g_log_message := 'Entering Explode_Repetitive_Forecast Function';
502: MRP_UTIL.MRP_LOG (g_log_message);
503: END IF;
504:
505: -- some constraints we have to consider for daily forecasts. The
506: -- processing for weekly and periodic forecasts is done later

Line 528: MRP_UTIL.MRP_LOG (g_log_message);

524: -- Depending on the bucket type go after the respective cursor
525:
526: IF g_debug THEN
527: g_log_message := 'Going in while loop inside Explode_Repetitive_Forecast';
528: MRP_UTIL.MRP_LOG (g_log_message);
529: END IF;
530:
531: IF p_bucket_type = 1 THEN -- daily buckets
532:

Line 570: MRP_UTIL.MRP_LOG (g_log_message);

566: END IF;
567:
568: IF g_debug THEN
569: g_log_message := 'Done with the buckets';
570: MRP_UTIL.MRP_LOG (g_log_message);
571: END IF;
572:
573: -- we need to do some extra work for weekly and periodic
574: -- forecasts in order to figure out the correct demand in the

Line 581: MRP_UTIL.MRP_LOG (g_log_message);

577: IF p_bucket_type = 2 OR p_bucket_type = 3 THEN
578: -- Call the prorating function
579: IF g_debug THEN
580: g_log_message := 'Call the prorating function';
581: MRP_UTIL.MRP_LOG (g_log_message);
582: END IF;
583:
584: IF NOT Get_Prorated_Demand (
585: p_bucket_type,

Line 618: MRP_UTIL.MRP_LOG (g_log_message);

614: l_line_id := p_line_id;
615: END IF;
616: IF g_debug THEN
617: g_log_message := 'Inserting into MRP_KANBAN_DEMAND';
618: MRP_UTIL.MRP_LOG (g_log_message);
619: g_log_message := 'LineN : ' || to_char(l_line_id);
620: MRP_UTIL.MRP_LOG (g_log_message);
621: g_log_message := 'in erd ItemN : ' || to_char(p_inventory_item_id);
622: MRP_UTIL.MRP_LOG (g_log_message);

Line 620: MRP_UTIL.MRP_LOG (g_log_message);

616: IF g_debug THEN
617: g_log_message := 'Inserting into MRP_KANBAN_DEMAND';
618: MRP_UTIL.MRP_LOG (g_log_message);
619: g_log_message := 'LineN : ' || to_char(l_line_id);
620: MRP_UTIL.MRP_LOG (g_log_message);
621: g_log_message := 'in erd ItemN : ' || to_char(p_inventory_item_id);
622: MRP_UTIL.MRP_LOG (g_log_message);
623: g_log_message := 'in erd demand date: ' || to_char(l_demand_date);
624: MRP_UTIL.MRP_LOG (g_log_message);

Line 622: MRP_UTIL.MRP_LOG (g_log_message);

618: MRP_UTIL.MRP_LOG (g_log_message);
619: g_log_message := 'LineN : ' || to_char(l_line_id);
620: MRP_UTIL.MRP_LOG (g_log_message);
621: g_log_message := 'in erd ItemN : ' || to_char(p_inventory_item_id);
622: MRP_UTIL.MRP_LOG (g_log_message);
623: g_log_message := 'in erd demand date: ' || to_char(l_demand_date);
624: MRP_UTIL.MRP_LOG (g_log_message);
625: g_log_message := 'in erd demand quant: ' || to_char(l_demand_quantity);
626: MRP_UTIL.MRP_LOG (g_log_message);

Line 624: MRP_UTIL.MRP_LOG (g_log_message);

620: MRP_UTIL.MRP_LOG (g_log_message);
621: g_log_message := 'in erd ItemN : ' || to_char(p_inventory_item_id);
622: MRP_UTIL.MRP_LOG (g_log_message);
623: g_log_message := 'in erd demand date: ' || to_char(l_demand_date);
624: MRP_UTIL.MRP_LOG (g_log_message);
625: g_log_message := 'in erd demand quant: ' || to_char(l_demand_quantity);
626: MRP_UTIL.MRP_LOG (g_log_message);
627:
628: END IF;

Line 626: MRP_UTIL.MRP_LOG (g_log_message);

622: MRP_UTIL.MRP_LOG (g_log_message);
623: g_log_message := 'in erd demand date: ' || to_char(l_demand_date);
624: MRP_UTIL.MRP_LOG (g_log_message);
625: g_log_message := 'in erd demand quant: ' || to_char(l_demand_quantity);
626: MRP_UTIL.MRP_LOG (g_log_message);
627:
628: END IF;
629:
630:

Line 760: MRP_UTIL.MRP_LOG (g_log_message);

756: --exception handling
757: EXCEPTION
758: WHEN OTHERS THEN
759: g_log_message := 'EXPLODE_REPETITIVE_FORECAST Sql Error ';
760: MRP_UTIL.MRP_LOG (g_log_message);
761: g_log_message := sqlerrm;
762: MRP_UTIL.MRP_LOG (g_log_message);
763: RETURN FALSE;
764: END Explode_Repetitive_Forecast;

Line 762: MRP_UTIL.MRP_LOG (g_log_message);

758: WHEN OTHERS THEN
759: g_log_message := 'EXPLODE_REPETITIVE_FORECAST Sql Error ';
760: MRP_UTIL.MRP_LOG (g_log_message);
761: g_log_message := sqlerrm;
762: MRP_UTIL.MRP_LOG (g_log_message);
763: RETURN FALSE;
764: END Explode_Repetitive_Forecast;
765:
766: -- ========================================================================

Line 994: MRP_UTIL.MRP_LOG (g_log_message);

990:
991: IF g_debug THEN
992:
993: g_log_message := 'Entering Cascade_Fcst_Demand function';
994: MRP_UTIL.MRP_LOG (g_log_message);
995: g_log_message := 'Cascading Demand For : ';
996: MRP_UTIL.MRP_LOG (g_log_message);
997: g_log_message := 'Line : ' || to_char(p_line_id);
998: MRP_UTIL.MRP_LOG (g_log_message);

Line 996: MRP_UTIL.MRP_LOG (g_log_message);

992:
993: g_log_message := 'Entering Cascade_Fcst_Demand function';
994: MRP_UTIL.MRP_LOG (g_log_message);
995: g_log_message := 'Cascading Demand For : ';
996: MRP_UTIL.MRP_LOG (g_log_message);
997: g_log_message := 'Line : ' || to_char(p_line_id);
998: MRP_UTIL.MRP_LOG (g_log_message);
999: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1000: MRP_UTIL.MRP_LOG (g_log_message);

Line 998: MRP_UTIL.MRP_LOG (g_log_message);

994: MRP_UTIL.MRP_LOG (g_log_message);
995: g_log_message := 'Cascading Demand For : ';
996: MRP_UTIL.MRP_LOG (g_log_message);
997: g_log_message := 'Line : ' || to_char(p_line_id);
998: MRP_UTIL.MRP_LOG (g_log_message);
999: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1000: MRP_UTIL.MRP_LOG (g_log_message);
1001: g_log_message := 'Sub : ' || p_subinventory;
1002: MRP_UTIL.MRP_LOG (g_log_message);

Line 1000: MRP_UTIL.MRP_LOG (g_log_message);

996: MRP_UTIL.MRP_LOG (g_log_message);
997: g_log_message := 'Line : ' || to_char(p_line_id);
998: MRP_UTIL.MRP_LOG (g_log_message);
999: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1000: MRP_UTIL.MRP_LOG (g_log_message);
1001: g_log_message := 'Sub : ' || p_subinventory;
1002: MRP_UTIL.MRP_LOG (g_log_message);
1003: g_log_message := 'Loc : ' || p_locator_id;
1004: MRP_UTIL.MRP_LOG (g_log_message);

Line 1002: MRP_UTIL.MRP_LOG (g_log_message);

998: MRP_UTIL.MRP_LOG (g_log_message);
999: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1000: MRP_UTIL.MRP_LOG (g_log_message);
1001: g_log_message := 'Sub : ' || p_subinventory;
1002: MRP_UTIL.MRP_LOG (g_log_message);
1003: g_log_message := 'Loc : ' || p_locator_id;
1004: MRP_UTIL.MRP_LOG (g_log_message);
1005: END IF;
1006:

Line 1004: MRP_UTIL.MRP_LOG (g_log_message);

1000: MRP_UTIL.MRP_LOG (g_log_message);
1001: g_log_message := 'Sub : ' || p_subinventory;
1002: MRP_UTIL.MRP_LOG (g_log_message);
1003: g_log_message := 'Loc : ' || p_locator_id;
1004: MRP_UTIL.MRP_LOG (g_log_message);
1005: END IF;
1006:
1007: -- Depending on the boolean flag p_recursive, we decide what cursor
1008: -- we want to go after. We know that we will have a line reference

Line 1075: MRP_UTIL.MRP_LOG (g_log_message);

1071: END IF;
1072:
1073: IF g_debug THEN
1074: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1075: MRP_UTIL.MRP_LOG (g_log_message);
1076: g_log_message := 'Net_Planning_Percent is : ' ||
1077: to_char (l_net_planning_percent);
1078: MRP_UTIL.MRP_LOG (g_log_message);
1079: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);

Line 1078: MRP_UTIL.MRP_LOG (g_log_message);

1074: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1075: MRP_UTIL.MRP_LOG (g_log_message);
1076: g_log_message := 'Net_Planning_Percent is : ' ||
1077: to_char (l_net_planning_percent);
1078: MRP_UTIL.MRP_LOG (g_log_message);
1079: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1080: MRP_UTIL.MRP_LOG (g_log_message);
1081: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1082: MRP_UTIL.MRP_LOG (g_log_message);

Line 1080: MRP_UTIL.MRP_LOG (g_log_message);

1076: g_log_message := 'Net_Planning_Percent is : ' ||
1077: to_char (l_net_planning_percent);
1078: MRP_UTIL.MRP_LOG (g_log_message);
1079: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1080: MRP_UTIL.MRP_LOG (g_log_message);
1081: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1082: MRP_UTIL.MRP_LOG (g_log_message);
1083:
1084: g_log_message := 'Sub: ' || l_subinventory;

Line 1082: MRP_UTIL.MRP_LOG (g_log_message);

1078: MRP_UTIL.MRP_LOG (g_log_message);
1079: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1080: MRP_UTIL.MRP_LOG (g_log_message);
1081: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1082: MRP_UTIL.MRP_LOG (g_log_message);
1083:
1084: g_log_message := 'Sub: ' || l_subinventory;
1085: MRP_UTIL.MRP_LOG (g_log_message);
1086: END IF;

Line 1085: MRP_UTIL.MRP_LOG (g_log_message);

1081: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1082: MRP_UTIL.MRP_LOG (g_log_message);
1083:
1084: g_log_message := 'Sub: ' || l_subinventory;
1085: MRP_UTIL.MRP_LOG (g_log_message);
1086: END IF;
1087:
1088:
1089: -- calculate the demand quantity to be passed down using all the

Line 1147: MRP_UTIL.MRP_LOG (g_log_message);

1143: /* End of Update */
1144:
1145: IF g_debug THEN
1146: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
1147: MRP_UTIL.MRP_LOG (g_log_message);
1148: END IF;
1149:
1150: -- now insert the demand into the kanban demand table if its > 0
1151:

Line 1230: MRP_UTIL.MRP_LOG (g_log_message);

1226: /* End of Update */
1227:
1228: IF g_debug THEN
1229: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
1230: MRP_UTIL.MRP_LOG (g_log_message);
1231: END IF;
1232:
1233: -- call the function that explodes repetitive foreast demand
1234:

Line 1269: MRP_UTIL.MRP_LOG (g_log_message);

1265:
1266: IF ( l_running_total_quantity > 0) THEN
1267: IF g_debug THEN
1268: g_log_message := 'Calling Cascade_Forecast_Demand in recursive mode';
1269: MRP_UTIL.MRP_LOG (g_log_message);
1270: END IF;
1271:
1272: if (p_assembly_item_id = l_component_id) then
1273: l_bill_or_ps := 2;

Line 1304: MRP_UTIL.MRP_LOG (g_log_message);

1300: l_comp_foq);
1301:
1302: IF g_debug THEN
1303: g_log_message := 'returned from the Cascade_Fcst_Demand call';
1304: MRP_UTIL.MRP_LOG (g_log_message);
1305: END IF;
1306:
1307: IF NOT l_ret_val THEN
1308: RETURN FALSE;

Line 1329: MRP_UTIL.MRP_LOG (g_log_message);

1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1328: g_log_message := 'Cascade_Fcst_Demand Sql Error ';
1329: MRP_UTIL.MRP_LOG (g_log_message);
1330: g_log_message := sqlerrm;
1331: MRP_UTIL.MRP_LOG (g_log_message);
1332: RETURN FALSE;
1333:

Line 1331: MRP_UTIL.MRP_LOG (g_log_message);

1327: WHEN OTHERS THEN
1328: g_log_message := 'Cascade_Fcst_Demand Sql Error ';
1329: MRP_UTIL.MRP_LOG (g_log_message);
1330: g_log_message := sqlerrm;
1331: MRP_UTIL.MRP_LOG (g_log_message);
1332: RETURN FALSE;
1333:
1334: END Cascade_Fcst_Demand;
1335:

Line 1549: MRP_UTIL.MRP_LOG (g_log_message);

1545:
1546: IF g_debug THEN
1547:
1548: g_log_message := 'Entering Cascade_Ap_Demand function';
1549: MRP_UTIL.MRP_LOG (g_log_message);
1550: g_log_message := 'Cascading Demand For : ';
1551: MRP_UTIL.MRP_LOG (g_log_message);
1552: g_log_message := 'Line : ' || to_char(p_line_id);
1553: MRP_UTIL.MRP_LOG (g_log_message);

Line 1551: MRP_UTIL.MRP_LOG (g_log_message);

1547:
1548: g_log_message := 'Entering Cascade_Ap_Demand function';
1549: MRP_UTIL.MRP_LOG (g_log_message);
1550: g_log_message := 'Cascading Demand For : ';
1551: MRP_UTIL.MRP_LOG (g_log_message);
1552: g_log_message := 'Line : ' || to_char(p_line_id);
1553: MRP_UTIL.MRP_LOG (g_log_message);
1554: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1555: MRP_UTIL.MRP_LOG (g_log_message);

Line 1553: MRP_UTIL.MRP_LOG (g_log_message);

1549: MRP_UTIL.MRP_LOG (g_log_message);
1550: g_log_message := 'Cascading Demand For : ';
1551: MRP_UTIL.MRP_LOG (g_log_message);
1552: g_log_message := 'Line : ' || to_char(p_line_id);
1553: MRP_UTIL.MRP_LOG (g_log_message);
1554: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1555: MRP_UTIL.MRP_LOG (g_log_message);
1556: g_log_message := 'Sub : ' || p_subinventory;
1557: MRP_UTIL.MRP_LOG (g_log_message);

Line 1555: MRP_UTIL.MRP_LOG (g_log_message);

1551: MRP_UTIL.MRP_LOG (g_log_message);
1552: g_log_message := 'Line : ' || to_char(p_line_id);
1553: MRP_UTIL.MRP_LOG (g_log_message);
1554: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1555: MRP_UTIL.MRP_LOG (g_log_message);
1556: g_log_message := 'Sub : ' || p_subinventory;
1557: MRP_UTIL.MRP_LOG (g_log_message);
1558: g_log_message := 'Loc : ' || p_locator_id;
1559: MRP_UTIL.MRP_LOG (g_log_message);

Line 1557: MRP_UTIL.MRP_LOG (g_log_message);

1553: MRP_UTIL.MRP_LOG (g_log_message);
1554: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1555: MRP_UTIL.MRP_LOG (g_log_message);
1556: g_log_message := 'Sub : ' || p_subinventory;
1557: MRP_UTIL.MRP_LOG (g_log_message);
1558: g_log_message := 'Loc : ' || p_locator_id;
1559: MRP_UTIL.MRP_LOG (g_log_message);
1560:
1561: END IF;

Line 1559: MRP_UTIL.MRP_LOG (g_log_message);

1555: MRP_UTIL.MRP_LOG (g_log_message);
1556: g_log_message := 'Sub : ' || p_subinventory;
1557: MRP_UTIL.MRP_LOG (g_log_message);
1558: g_log_message := 'Loc : ' || p_locator_id;
1559: MRP_UTIL.MRP_LOG (g_log_message);
1560:
1561: END IF;
1562:
1563:

Line 1634: MRP_UTIL.MRP_LOG (g_log_message);

1630: END IF;
1631:
1632: IF g_debug THEN
1633: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1634: MRP_UTIL.MRP_LOG (g_log_message);
1635: g_log_message := 'Net_Planning_Percent is : ' ||
1636: to_char (l_net_planning_percent);
1637: MRP_UTIL.MRP_LOG (g_log_message);
1638: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);

Line 1637: MRP_UTIL.MRP_LOG (g_log_message);

1633: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1634: MRP_UTIL.MRP_LOG (g_log_message);
1635: g_log_message := 'Net_Planning_Percent is : ' ||
1636: to_char (l_net_planning_percent);
1637: MRP_UTIL.MRP_LOG (g_log_message);
1638: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1639: MRP_UTIL.MRP_LOG (g_log_message);
1640: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1641: MRP_UTIL.MRP_LOG (g_log_message);

Line 1639: MRP_UTIL.MRP_LOG (g_log_message);

1635: g_log_message := 'Net_Planning_Percent is : ' ||
1636: to_char (l_net_planning_percent);
1637: MRP_UTIL.MRP_LOG (g_log_message);
1638: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1639: MRP_UTIL.MRP_LOG (g_log_message);
1640: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1641: MRP_UTIL.MRP_LOG (g_log_message);
1642: END IF;
1643:

Line 1641: MRP_UTIL.MRP_LOG (g_log_message);

1637: MRP_UTIL.MRP_LOG (g_log_message);
1638: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1639: MRP_UTIL.MRP_LOG (g_log_message);
1640: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1641: MRP_UTIL.MRP_LOG (g_log_message);
1642: END IF;
1643:
1644: -- calculate the demand quantity to be passed down using all the
1645: -- percentages and yields stuff that we've got

Line 1684: MRP_UTIL.MRP_LOG (g_log_message);

1680: /* End of Update */
1681:
1682: IF g_debug THEN
1683: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
1684: MRP_UTIL.MRP_LOG (g_log_message);
1685: END IF;
1686:
1687: -- now insert the demand into the kanban demand table if its > 0
1688:

Line 1754: MRP_UTIL.MRP_LOG (g_log_message);

1750:
1751: IF ( l_running_total_quantity > 0) THEN
1752: IF g_debug THEN
1753: g_log_message := 'Calling Cascade_Ap_Demand in recursive mode';
1754: MRP_UTIL.MRP_LOG (g_log_message);
1755: END IF;
1756:
1757: if (p_assembly_item_id = l_component_id) then
1758: l_bill_or_ps := 2;

Line 1791: MRP_UTIL.MRP_LOG (g_log_message);

1787: l_comp_foq);
1788:
1789: IF g_debug THEN
1790: g_log_message := 'returned from the cascade call';
1791: MRP_UTIL.MRP_LOG (g_log_message);
1792: END IF;
1793:
1794:
1795: IF NOT l_ret_val THEN

Line 1816: MRP_UTIL.MRP_LOG (g_log_message);

1812: --exception handling
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: g_log_message := 'Cascade_Ap_Demand Sql Error ';
1816: MRP_UTIL.MRP_LOG (g_log_message);
1817: g_log_message := sqlerrm;
1818: MRP_UTIL.MRP_LOG (g_log_message);
1819: RETURN FALSE;
1820:

Line 1818: MRP_UTIL.MRP_LOG (g_log_message);

1814: WHEN OTHERS THEN
1815: g_log_message := 'Cascade_Ap_Demand Sql Error ';
1816: MRP_UTIL.MRP_LOG (g_log_message);
1817: g_log_message := sqlerrm;
1818: MRP_UTIL.MRP_LOG (g_log_message);
1819: RETURN FALSE;
1820:
1821: END Cascade_Ap_Demand;
1822:

Line 2036: MRP_UTIL.MRP_LOG (g_log_message);

2032:
2033: IF g_debug THEN
2034:
2035: g_log_message := 'Entering Cascade_Mds_Mps_Demand function';
2036: MRP_UTIL.MRP_LOG (g_log_message);
2037: g_log_message := 'Cascading Demand For : ';
2038: MRP_UTIL.MRP_LOG (g_log_message);
2039: g_log_message := 'Line : ' || to_char(p_line_id);
2040: MRP_UTIL.MRP_LOG (g_log_message);

Line 2038: MRP_UTIL.MRP_LOG (g_log_message);

2034:
2035: g_log_message := 'Entering Cascade_Mds_Mps_Demand function';
2036: MRP_UTIL.MRP_LOG (g_log_message);
2037: g_log_message := 'Cascading Demand For : ';
2038: MRP_UTIL.MRP_LOG (g_log_message);
2039: g_log_message := 'Line : ' || to_char(p_line_id);
2040: MRP_UTIL.MRP_LOG (g_log_message);
2041: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
2042: MRP_UTIL.MRP_LOG (g_log_message);

Line 2040: MRP_UTIL.MRP_LOG (g_log_message);

2036: MRP_UTIL.MRP_LOG (g_log_message);
2037: g_log_message := 'Cascading Demand For : ';
2038: MRP_UTIL.MRP_LOG (g_log_message);
2039: g_log_message := 'Line : ' || to_char(p_line_id);
2040: MRP_UTIL.MRP_LOG (g_log_message);
2041: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
2042: MRP_UTIL.MRP_LOG (g_log_message);
2043: g_log_message := 'Sub : ' || p_subinventory;
2044: MRP_UTIL.MRP_LOG (g_log_message);

Line 2042: MRP_UTIL.MRP_LOG (g_log_message);

2038: MRP_UTIL.MRP_LOG (g_log_message);
2039: g_log_message := 'Line : ' || to_char(p_line_id);
2040: MRP_UTIL.MRP_LOG (g_log_message);
2041: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
2042: MRP_UTIL.MRP_LOG (g_log_message);
2043: g_log_message := 'Sub : ' || p_subinventory;
2044: MRP_UTIL.MRP_LOG (g_log_message);
2045: g_log_message := 'Loc : ' || p_locator_id;
2046: MRP_UTIL.MRP_LOG (g_log_message);

Line 2044: MRP_UTIL.MRP_LOG (g_log_message);

2040: MRP_UTIL.MRP_LOG (g_log_message);
2041: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
2042: MRP_UTIL.MRP_LOG (g_log_message);
2043: g_log_message := 'Sub : ' || p_subinventory;
2044: MRP_UTIL.MRP_LOG (g_log_message);
2045: g_log_message := 'Loc : ' || p_locator_id;
2046: MRP_UTIL.MRP_LOG (g_log_message);
2047:
2048:

Line 2046: MRP_UTIL.MRP_LOG (g_log_message);

2042: MRP_UTIL.MRP_LOG (g_log_message);
2043: g_log_message := 'Sub : ' || p_subinventory;
2044: MRP_UTIL.MRP_LOG (g_log_message);
2045: g_log_message := 'Loc : ' || p_locator_id;
2046: MRP_UTIL.MRP_LOG (g_log_message);
2047:
2048:
2049: END IF;
2050:

Line 2122: MRP_UTIL.MRP_LOG (g_log_message);

2118: END IF;
2119:
2120: IF g_debug THEN
2121: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
2122: MRP_UTIL.MRP_LOG (g_log_message);
2123: g_log_message := 'Net_Planning_Percent is : ' ||
2124: to_char (l_net_planning_percent);
2125: MRP_UTIL.MRP_LOG (g_log_message);
2126: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);

Line 2125: MRP_UTIL.MRP_LOG (g_log_message);

2121: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
2122: MRP_UTIL.MRP_LOG (g_log_message);
2123: g_log_message := 'Net_Planning_Percent is : ' ||
2124: to_char (l_net_planning_percent);
2125: MRP_UTIL.MRP_LOG (g_log_message);
2126: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
2127: MRP_UTIL.MRP_LOG (g_log_message);
2128: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
2129: MRP_UTIL.MRP_LOG (g_log_message);

Line 2127: MRP_UTIL.MRP_LOG (g_log_message);

2123: g_log_message := 'Net_Planning_Percent is : ' ||
2124: to_char (l_net_planning_percent);
2125: MRP_UTIL.MRP_LOG (g_log_message);
2126: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
2127: MRP_UTIL.MRP_LOG (g_log_message);
2128: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
2129: MRP_UTIL.MRP_LOG (g_log_message);
2130: END IF;
2131:

Line 2129: MRP_UTIL.MRP_LOG (g_log_message);

2125: MRP_UTIL.MRP_LOG (g_log_message);
2126: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
2127: MRP_UTIL.MRP_LOG (g_log_message);
2128: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
2129: MRP_UTIL.MRP_LOG (g_log_message);
2130: END IF;
2131:
2132: -- calculate the demand quantity to be passed down using all the
2133: -- percentages and yields stuff that we've got

Line 2172: MRP_UTIL.MRP_LOG (g_log_message);

2168: /* End of Update */
2169:
2170: IF g_debug THEN
2171: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
2172: MRP_UTIL.MRP_LOG (g_log_message);
2173: END IF;
2174:
2175: -- now insert the demand into the kanban demand table if its > 0
2176:

Line 2242: MRP_UTIL.MRP_LOG (g_log_message);

2238:
2239: IF ( l_running_total_quantity > 0) THEN
2240: IF g_debug THEN
2241: g_log_message := 'Calling Cascade_Mds_Mps_Demand in recursive mode';
2242: MRP_UTIL.MRP_LOG (g_log_message);
2243: END IF;
2244:
2245: if (p_assembly_item_id = l_component_id) then
2246: l_bill_or_ps := 2;

Line 2277: MRP_UTIL.MRP_LOG (g_log_message);

2273: l_comp_foq);
2274:
2275: IF g_debug THEN
2276: g_log_message := 'returned from the cascade call';
2277: MRP_UTIL.MRP_LOG (g_log_message);
2278: END IF;
2279:
2280:
2281: IF NOT l_ret_val THEN

Line 2302: MRP_UTIL.MRP_LOG (g_log_message);

2298: --exception handling
2299: EXCEPTION
2300: WHEN OTHERS THEN
2301: g_log_message := 'Cascade_Mds_Mps_Demand Sql Error ';
2302: MRP_UTIL.MRP_LOG (g_log_message);
2303: g_log_message := sqlerrm;
2304: MRP_UTIL.MRP_LOG (g_log_message);
2305: RETURN FALSE;
2306:

Line 2304: MRP_UTIL.MRP_LOG (g_log_message);

2300: WHEN OTHERS THEN
2301: g_log_message := 'Cascade_Mds_Mps_Demand Sql Error ';
2302: MRP_UTIL.MRP_LOG (g_log_message);
2303: g_log_message := sqlerrm;
2304: MRP_UTIL.MRP_LOG (g_log_message);
2305: RETURN FALSE;
2306:
2307: END Cascade_Mds_Mps_Demand;
2308:

Line 2378: MRP_UTIL.MRP_LOG (g_log_message);

2374: BEGIN
2375:
2376: IF g_debug THEN
2377: g_log_message := 'Inserting Demand For :';
2378: MRP_UTIL.MRP_LOG (g_log_message);
2379: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2380: MRP_UTIL.MRP_LOG (g_log_message);
2381: g_log_message := 'Line Reference :' || to_char(p_line_id);
2382: MRP_UTIL.MRP_LOG (g_log_message);

Line 2380: MRP_UTIL.MRP_LOG (g_log_message);

2376: IF g_debug THEN
2377: g_log_message := 'Inserting Demand For :';
2378: MRP_UTIL.MRP_LOG (g_log_message);
2379: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2380: MRP_UTIL.MRP_LOG (g_log_message);
2381: g_log_message := 'Line Reference :' || to_char(p_line_id);
2382: MRP_UTIL.MRP_LOG (g_log_message);
2383: END IF;
2384:

Line 2382: MRP_UTIL.MRP_LOG (g_log_message);

2378: MRP_UTIL.MRP_LOG (g_log_message);
2379: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2380: MRP_UTIL.MRP_LOG (g_log_message);
2381: g_log_message := 'Line Reference :' || to_char(p_line_id);
2382: MRP_UTIL.MRP_LOG (g_log_message);
2383: END IF;
2384:
2385: g_stmt_num := 170;
2386: IF g_debug THEN

Line 2388: MRP_UTIL.MRP_LOG (g_log_message);

2384:
2385: g_stmt_num := 170;
2386: IF g_debug THEN
2387: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2388: MRP_UTIL.MRP_LOG (g_log_message);
2389: END IF;
2390:
2391: -- the first insert here is for the item for which we have
2392: -- foreacast based on the allocation percentages mentioned

Line 2425: MRP_UTIL.MRP_LOG (g_log_message);

2421: End;
2422: END IF;
2423: IF g_debug THEN
2424: g_log_message := 'demand quantity:'||to_char(l_forecast_quantity);
2425: MRP_UTIL.MRP_LOG (g_log_message);
2426: g_log_message := 'demand date:'||to_char(l_forecast_date);
2427: MRP_UTIL.MRP_LOG (g_log_message);
2428: END IF;
2429:

Line 2427: MRP_UTIL.MRP_LOG (g_log_message);

2423: IF g_debug THEN
2424: g_log_message := 'demand quantity:'||to_char(l_forecast_quantity);
2425: MRP_UTIL.MRP_LOG (g_log_message);
2426: g_log_message := 'demand date:'||to_char(l_forecast_date);
2427: MRP_UTIL.MRP_LOG (g_log_message);
2428: END IF;
2429:
2430: IF l_rate_end_date IS NULL THEN
2431: -- not a repetitive forecast - simple processing

Line 2548: MRP_UTIL.MRP_LOG (g_log_message);

2544:
2545: g_stmt_num := 175;
2546: IF g_debug THEN
2547: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2548: MRP_UTIL.MRP_LOG (g_log_message);
2549: g_log_message := 'Calling Cascade_Fcst_Demand in NON Recursive Mode';
2550: MRP_UTIL.MRP_LOG (g_log_message);
2551: END IF;
2552:

Line 2550: MRP_UTIL.MRP_LOG (g_log_message);

2546: IF g_debug THEN
2547: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2548: MRP_UTIL.MRP_LOG (g_log_message);
2549: g_log_message := 'Calling Cascade_Fcst_Demand in NON Recursive Mode';
2550: MRP_UTIL.MRP_LOG (g_log_message);
2551: END IF;
2552:
2553: -- Before we call the function Cascade_Fcst_Demand,
2554: -- we need to set the flags

Line 2602: MRP_UTIL.MRP_LOG (g_log_message);

2598: --exception handling
2599: EXCEPTION
2600: WHEN OTHERS THEN
2601: g_log_message := 'INSERT_FCST_DEMAND Sql Error ';
2602: MRP_UTIL.MRP_LOG (g_log_message);
2603: g_log_message := sqlerrm;
2604: MRP_UTIL.MRP_LOG (g_log_message);
2605: RETURN FALSE;
2606:

Line 2604: MRP_UTIL.MRP_LOG (g_log_message);

2600: WHEN OTHERS THEN
2601: g_log_message := 'INSERT_FCST_DEMAND Sql Error ';
2602: MRP_UTIL.MRP_LOG (g_log_message);
2603: g_log_message := sqlerrm;
2604: MRP_UTIL.MRP_LOG (g_log_message);
2605: RETURN FALSE;
2606:
2607: END Insert_Fcst_Demand;
2608:

Line 2663: MRP_UTIL.MRP_LOG (g_log_message);

2659: -- ---------------------------------------------
2660:
2661: IF g_debug THEN
2662: g_log_message := 'Inserting Demand For :';
2663: MRP_UTIL.MRP_LOG (g_log_message);
2664: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2665: MRP_UTIL.MRP_LOG (g_log_message);
2666: g_log_message := 'Alternate : ' || p_alt_bom ;
2667: MRP_UTIL.MRP_LOG (g_log_message);

Line 2665: MRP_UTIL.MRP_LOG (g_log_message);

2661: IF g_debug THEN
2662: g_log_message := 'Inserting Demand For :';
2663: MRP_UTIL.MRP_LOG (g_log_message);
2664: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2665: MRP_UTIL.MRP_LOG (g_log_message);
2666: g_log_message := 'Alternate : ' || p_alt_bom ;
2667: MRP_UTIL.MRP_LOG (g_log_message);
2668: g_log_message := 'Line Reference :' || to_char(p_line_id);
2669: MRP_UTIL.MRP_LOG (g_log_message);

Line 2667: MRP_UTIL.MRP_LOG (g_log_message);

2663: MRP_UTIL.MRP_LOG (g_log_message);
2664: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2665: MRP_UTIL.MRP_LOG (g_log_message);
2666: g_log_message := 'Alternate : ' || p_alt_bom ;
2667: MRP_UTIL.MRP_LOG (g_log_message);
2668: g_log_message := 'Line Reference :' || to_char(p_line_id);
2669: MRP_UTIL.MRP_LOG (g_log_message);
2670: END IF;
2671:

Line 2669: MRP_UTIL.MRP_LOG (g_log_message);

2665: MRP_UTIL.MRP_LOG (g_log_message);
2666: g_log_message := 'Alternate : ' || p_alt_bom ;
2667: MRP_UTIL.MRP_LOG (g_log_message);
2668: g_log_message := 'Line Reference :' || to_char(p_line_id);
2669: MRP_UTIL.MRP_LOG (g_log_message);
2670: END IF;
2671:
2672: g_stmt_num := 170;
2673: IF g_debug THEN

Line 2675: MRP_UTIL.MRP_LOG (g_log_message);

2671:
2672: g_stmt_num := 170;
2673: IF g_debug THEN
2674: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2675: MRP_UTIL.MRP_LOG (g_log_message);
2676: END IF;
2677:
2678: -- the first insert here is for the item for which we have
2679: -- mds/mps based on the allocation percentages mentioned

Line 2698: MRP_UTIL.MRP_LOG (g_log_message);

2694: EXIT WHEN item_schedule_entries%NOTFOUND;
2695:
2696: IF g_debug THEN
2697: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
2698: MRP_UTIL.MRP_LOG (g_log_message);
2699: g_log_message := 'demand date:'||to_char(l_schedule_date);
2700: MRP_UTIL.MRP_LOG (g_log_message);
2701: END IF;
2702:

Line 2700: MRP_UTIL.MRP_LOG (g_log_message);

2696: IF g_debug THEN
2697: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
2698: MRP_UTIL.MRP_LOG (g_log_message);
2699: g_log_message := 'demand date:'||to_char(l_schedule_date);
2700: MRP_UTIL.MRP_LOG (g_log_message);
2701: END IF;
2702:
2703: /* Bug 2279877, we allow null-line for discrete and not get line from primary rtg
2704: IF (l_line_id is NULL) THEN

Line 2795: MRP_UTIL.MRP_LOG (g_log_message);

2791:
2792: g_stmt_num := 175;
2793: IF g_debug THEN
2794: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2795: MRP_UTIL.MRP_LOG (g_log_message);
2796: g_log_message := 'Calling Cascade_Ap_Demand in NON Recursive Mode';
2797: MRP_UTIL.MRP_LOG (g_log_message);
2798: END IF;
2799:

Line 2797: MRP_UTIL.MRP_LOG (g_log_message);

2793: IF g_debug THEN
2794: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2795: MRP_UTIL.MRP_LOG (g_log_message);
2796: g_log_message := 'Calling Cascade_Ap_Demand in NON Recursive Mode';
2797: MRP_UTIL.MRP_LOG (g_log_message);
2798: END IF;
2799:
2800: -- Before we call the function Cascade_Ap_Demand,
2801: -- we need to set the flags

Line 2845: MRP_UTIL.MRP_LOG (g_log_message);

2841: --exception handling
2842: EXCEPTION
2843: WHEN OTHERS THEN
2844: g_log_message := 'INSERT_AP_DEMAND Sql Error ';
2845: MRP_UTIL.MRP_LOG (g_log_message);
2846: g_log_message := sqlerrm;
2847: MRP_UTIL.MRP_LOG (g_log_message);
2848: RETURN FALSE;
2849:

Line 2847: MRP_UTIL.MRP_LOG (g_log_message);

2843: WHEN OTHERS THEN
2844: g_log_message := 'INSERT_AP_DEMAND Sql Error ';
2845: MRP_UTIL.MRP_LOG (g_log_message);
2846: g_log_message := sqlerrm;
2847: MRP_UTIL.MRP_LOG (g_log_message);
2848: RETURN FALSE;
2849:
2850: END Insert_Ap_Demand;
2851:

Line 2905: MRP_UTIL.MRP_LOG (g_log_message);

2901: -- ---------------------------------------------
2902:
2903: IF g_debug THEN
2904: g_log_message := 'Inserting Demand For :';
2905: MRP_UTIL.MRP_LOG (g_log_message);
2906: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2907: MRP_UTIL.MRP_LOG (g_log_message);
2908: g_log_message := 'Line Reference :' || to_char(p_line_id);
2909: MRP_UTIL.MRP_LOG (g_log_message);

Line 2907: MRP_UTIL.MRP_LOG (g_log_message);

2903: IF g_debug THEN
2904: g_log_message := 'Inserting Demand For :';
2905: MRP_UTIL.MRP_LOG (g_log_message);
2906: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2907: MRP_UTIL.MRP_LOG (g_log_message);
2908: g_log_message := 'Line Reference :' || to_char(p_line_id);
2909: MRP_UTIL.MRP_LOG (g_log_message);
2910: END IF;
2911:

Line 2909: MRP_UTIL.MRP_LOG (g_log_message);

2905: MRP_UTIL.MRP_LOG (g_log_message);
2906: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2907: MRP_UTIL.MRP_LOG (g_log_message);
2908: g_log_message := 'Line Reference :' || to_char(p_line_id);
2909: MRP_UTIL.MRP_LOG (g_log_message);
2910: END IF;
2911:
2912: g_stmt_num := 170;
2913: IF g_debug THEN

Line 2915: MRP_UTIL.MRP_LOG (g_log_message);

2911:
2912: g_stmt_num := 170;
2913: IF g_debug THEN
2914: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2915: MRP_UTIL.MRP_LOG (g_log_message);
2916: END IF;
2917:
2918: -- the first insert here is for the item for which we have
2919: -- mds/mps based on the allocation percentages mentioned

Line 2938: MRP_UTIL.MRP_LOG (g_log_message);

2934: EXIT WHEN item_schedule_entries%NOTFOUND;
2935:
2936: IF g_debug THEN
2937: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
2938: MRP_UTIL.MRP_LOG (g_log_message);
2939: g_log_message := 'demand date:'||to_char(l_schedule_date);
2940: MRP_UTIL.MRP_LOG (g_log_message);
2941: END IF;
2942:

Line 2940: MRP_UTIL.MRP_LOG (g_log_message);

2936: IF g_debug THEN
2937: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
2938: MRP_UTIL.MRP_LOG (g_log_message);
2939: g_log_message := 'demand date:'||to_char(l_schedule_date);
2940: MRP_UTIL.MRP_LOG (g_log_message);
2941: END IF;
2942:
2943: IF (l_line_id is NULL) THEN
2944: Begin

Line 3033: MRP_UTIL.MRP_LOG (g_log_message);

3029:
3030: g_stmt_num := 175;
3031: IF g_debug THEN
3032: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3033: MRP_UTIL.MRP_LOG (g_log_message);
3034: g_log_message := 'Calling Cascade_Mds_Mps_Demand in NON Recursive Mode';
3035: MRP_UTIL.MRP_LOG (g_log_message);
3036: END IF;
3037:

Line 3035: MRP_UTIL.MRP_LOG (g_log_message);

3031: IF g_debug THEN
3032: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3033: MRP_UTIL.MRP_LOG (g_log_message);
3034: g_log_message := 'Calling Cascade_Mds_Mps_Demand in NON Recursive Mode';
3035: MRP_UTIL.MRP_LOG (g_log_message);
3036: END IF;
3037:
3038: -- Before we call the function Cascade_Mds_Mps_Demand,
3039: -- we need to set the flags

Line 3092: MRP_UTIL.MRP_LOG (g_log_message);

3088: --exception handling
3089: EXCEPTION
3090: WHEN OTHERS THEN
3091: g_log_message := 'INSERT_DEMAND Sql Error ';
3092: MRP_UTIL.MRP_LOG (g_log_message);
3093: g_log_message := sqlerrm;
3094: MRP_UTIL.MRP_LOG (g_log_message);
3095: RETURN FALSE;
3096:

Line 3094: MRP_UTIL.MRP_LOG (g_log_message);

3090: WHEN OTHERS THEN
3091: g_log_message := 'INSERT_DEMAND Sql Error ';
3092: MRP_UTIL.MRP_LOG (g_log_message);
3093: g_log_message := sqlerrm;
3094: MRP_UTIL.MRP_LOG (g_log_message);
3095: RETURN FALSE;
3096:
3097: END Insert_Mds_Mps_Demand;
3098:

Line 3259: MRP_UTIL.MRP_LOG (g_log_message);

3255: EXIT WHEN cur_forecast_entries%NOTFOUND;
3256:
3257: IF g_debug THEN
3258: g_log_message := 'Forecast Entry Details : ' ;
3259: MRP_UTIL.MRP_LOG (g_log_message);
3260: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3261: MRP_UTIL.MRP_LOG (g_log_message);
3262: END IF;
3263:

Line 3261: MRP_UTIL.MRP_LOG (g_log_message);

3257: IF g_debug THEN
3258: g_log_message := 'Forecast Entry Details : ' ;
3259: MRP_UTIL.MRP_LOG (g_log_message);
3260: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3261: MRP_UTIL.MRP_LOG (g_log_message);
3262: END IF;
3263:
3264: ELSIF ( g_kanban_info_rec.input_type = 2 OR
3265: g_kanban_info_rec.input_type = 3 ) THEN

Line 3281: MRP_UTIL.MRP_LOG (g_log_message);

3277: EXIT WHEN cur_schedule_entries%NOTFOUND;
3278:
3279: IF g_debug THEN
3280: g_log_message := 'Schedule Entry Details : ' ;
3281: MRP_UTIL.MRP_LOG (g_log_message);
3282: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3283: MRP_UTIL.MRP_LOG (g_log_message);
3284: g_log_message := 'Line Reference :' || to_char(l_line_id);
3285: MRP_UTIL.MRP_LOG (g_log_message);

Line 3283: MRP_UTIL.MRP_LOG (g_log_message);

3279: IF g_debug THEN
3280: g_log_message := 'Schedule Entry Details : ' ;
3281: MRP_UTIL.MRP_LOG (g_log_message);
3282: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3283: MRP_UTIL.MRP_LOG (g_log_message);
3284: g_log_message := 'Line Reference :' || to_char(l_line_id);
3285: MRP_UTIL.MRP_LOG (g_log_message);
3286: END IF;
3287: ELSIF ( g_kanban_info_rec.input_type = 4) THEN

Line 3285: MRP_UTIL.MRP_LOG (g_log_message);

3281: MRP_UTIL.MRP_LOG (g_log_message);
3282: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3283: MRP_UTIL.MRP_LOG (g_log_message);
3284: g_log_message := 'Line Reference :' || to_char(l_line_id);
3285: MRP_UTIL.MRP_LOG (g_log_message);
3286: END IF;
3287: ELSIF ( g_kanban_info_rec.input_type = 4) THEN
3288: -- input is Actual Production (type = 4)
3289:

Line 3303: MRP_UTIL.MRP_LOG (g_log_message);

3299: EXIT WHEN GetActualProductionDemand%NOTFOUND;
3300:
3301: IF g_debug THEN
3302: g_log_message := 'Schedule Entry Details : ' ;
3303: MRP_UTIL.MRP_LOG (g_log_message);
3304: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3305: MRP_UTIL.MRP_LOG (g_log_message);
3306: g_log_message := 'Alternate : ' || l_alt_bom;
3307: MRP_UTIL.MRP_LOG (g_log_message);

Line 3305: MRP_UTIL.MRP_LOG (g_log_message);

3301: IF g_debug THEN
3302: g_log_message := 'Schedule Entry Details : ' ;
3303: MRP_UTIL.MRP_LOG (g_log_message);
3304: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3305: MRP_UTIL.MRP_LOG (g_log_message);
3306: g_log_message := 'Alternate : ' || l_alt_bom;
3307: MRP_UTIL.MRP_LOG (g_log_message);
3308: g_log_message := 'Line Reference :' || to_char(l_line_id);
3309: MRP_UTIL.MRP_LOG (g_log_message);

Line 3307: MRP_UTIL.MRP_LOG (g_log_message);

3303: MRP_UTIL.MRP_LOG (g_log_message);
3304: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3305: MRP_UTIL.MRP_LOG (g_log_message);
3306: g_log_message := 'Alternate : ' || l_alt_bom;
3307: MRP_UTIL.MRP_LOG (g_log_message);
3308: g_log_message := 'Line Reference :' || to_char(l_line_id);
3309: MRP_UTIL.MRP_LOG (g_log_message);
3310: END IF;
3311: END IF;

Line 3309: MRP_UTIL.MRP_LOG (g_log_message);

3305: MRP_UTIL.MRP_LOG (g_log_message);
3306: g_log_message := 'Alternate : ' || l_alt_bom;
3307: MRP_UTIL.MRP_LOG (g_log_message);
3308: g_log_message := 'Line Reference :' || to_char(l_line_id);
3309: MRP_UTIL.MRP_LOG (g_log_message);
3310: END IF;
3311: END IF;
3312:
3313: g_stmt_num := 160;

Line 3316: MRP_UTIL.MRP_LOG (g_log_message);

3312:
3313: g_stmt_num := 160;
3314: IF g_debug THEN
3315: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3316: MRP_UTIL.MRP_LOG (g_log_message);
3317: g_log_message := 'Calling Insert Demand function';
3318: MRP_UTIL.MRP_LOG (g_log_message);
3319: END IF;
3320:

Line 3318: MRP_UTIL.MRP_LOG (g_log_message);

3314: IF g_debug THEN
3315: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3316: MRP_UTIL.MRP_LOG (g_log_message);
3317: g_log_message := 'Calling Insert Demand function';
3318: MRP_UTIL.MRP_LOG (g_log_message);
3319: END IF;
3320:
3321: -- call the function to insert demand and explode it through
3322: -- to the bottom of the bill

Line 3362: MRP_UTIL.MRP_LOG (g_log_message);

3358: --exception handling
3359: EXCEPTION
3360: WHEN OTHERS THEN
3361: g_log_message := 'RETRIEVE_KANBAN_DEMAND Sql Error ';
3362: MRP_UTIL.MRP_LOG (g_log_message);
3363: g_log_message := sqlerrm;
3364: MRP_UTIL.MRP_LOG (g_log_message);
3365: RETURN FALSE;
3366:

Line 3364: MRP_UTIL.MRP_LOG (g_log_message);

3360: WHEN OTHERS THEN
3361: g_log_message := 'RETRIEVE_KANBAN_DEMAND Sql Error ';
3362: MRP_UTIL.MRP_LOG (g_log_message);
3363: g_log_message := sqlerrm;
3364: MRP_UTIL.MRP_LOG (g_log_message);
3365: RETURN FALSE;
3366:
3367: END Retrieve_Kanban_Demand;
3368:

Line 3461: MRP_UTIL.MRP_LOG (g_log_message);

3457:
3458: Exception
3459: WHEN OTHERS THEN
3460: g_log_message := 'KANBAN_CALCULATION_PVT Sql Error ';
3461: MRP_UTIL.MRP_LOG (g_log_message);
3462: g_log_message := sqlerrm;
3463: MRP_UTIL.MRP_LOG (g_log_message);
3464: RETURN FALSE;
3465:

Line 3463: MRP_UTIL.MRP_LOG (g_log_message);

3459: WHEN OTHERS THEN
3460: g_log_message := 'KANBAN_CALCULATION_PVT Sql Error ';
3461: MRP_UTIL.MRP_LOG (g_log_message);
3462: g_log_message := sqlerrm;
3463: MRP_UTIL.MRP_LOG (g_log_message);
3464: RETURN FALSE;
3465:
3466: END Kanban_Calculation_Pvt;
3467: -- ========================================================================

Line 3542: MRP_UTIL.MRP_LOG (g_log_message);

3538: BEGIN
3539:
3540: IF g_debug THEN
3541: g_log_message := 'Entering Calculate_Kanban_Quantity Function';
3542: MRP_UTIL.MRP_LOG (g_log_message);
3543: END IF;
3544:
3545: OPEN cur_kanban_demand;
3546:

Line 3556: MRP_UTIL.MRP_LOG (g_log_message);

3552: l_locator_id;
3553:
3554: IF g_debug THEN
3555: g_log_message := 'Item Id : ' || to_char (l_item_id);
3556: MRP_UTIL.MRP_LOG (g_log_message);
3557: g_log_message := 'SubInventory : ' || l_subinventory;
3558: MRP_UTIL.MRP_LOG (g_log_message);
3559: g_log_message := 'Locator : ' || to_char(l_locator_id);
3560: MRP_UTIL.MRP_LOG (g_log_message);

Line 3558: MRP_UTIL.MRP_LOG (g_log_message);

3554: IF g_debug THEN
3555: g_log_message := 'Item Id : ' || to_char (l_item_id);
3556: MRP_UTIL.MRP_LOG (g_log_message);
3557: g_log_message := 'SubInventory : ' || l_subinventory;
3558: MRP_UTIL.MRP_LOG (g_log_message);
3559: g_log_message := 'Locator : ' || to_char(l_locator_id);
3560: MRP_UTIL.MRP_LOG (g_log_message);
3561: END IF;
3562:

Line 3560: MRP_UTIL.MRP_LOG (g_log_message);

3556: MRP_UTIL.MRP_LOG (g_log_message);
3557: g_log_message := 'SubInventory : ' || l_subinventory;
3558: MRP_UTIL.MRP_LOG (g_log_message);
3559: g_log_message := 'Locator : ' || to_char(l_locator_id);
3560: MRP_UTIL.MRP_LOG (g_log_message);
3561: END IF;
3562:
3563:
3564: EXIT WHEN cur_kanban_demand%NOTFOUND;

Line 3612: MRP_UTIL.MRP_LOG (g_log_message);

3608:
3609:
3610: IF g_debug THEN
3611: g_log_message := 'Calling Kanban Qty Calc API';
3612: MRP_UTIL.MRP_LOG (g_log_message);
3613: g_log_message := 'Parameters Passed to the Kanban Qty Calc API : ';
3614: MRP_UTIL.MRP_LOG (g_log_message);
3615: g_log_message := 'Demand :' || to_char (l_average_demand);
3616: MRP_UTIL.MRP_LOG (g_log_message);

Line 3614: MRP_UTIL.MRP_LOG (g_log_message);

3610: IF g_debug THEN
3611: g_log_message := 'Calling Kanban Qty Calc API';
3612: MRP_UTIL.MRP_LOG (g_log_message);
3613: g_log_message := 'Parameters Passed to the Kanban Qty Calc API : ';
3614: MRP_UTIL.MRP_LOG (g_log_message);
3615: g_log_message := 'Demand :' || to_char (l_average_demand);
3616: MRP_UTIL.MRP_LOG (g_log_message);
3617: g_log_message := 'Min Order Qty :'
3618: || to_char (l_pull_sequence_rec.minimum_order_quantity);

Line 3616: MRP_UTIL.MRP_LOG (g_log_message);

3612: MRP_UTIL.MRP_LOG (g_log_message);
3613: g_log_message := 'Parameters Passed to the Kanban Qty Calc API : ';
3614: MRP_UTIL.MRP_LOG (g_log_message);
3615: g_log_message := 'Demand :' || to_char (l_average_demand);
3616: MRP_UTIL.MRP_LOG (g_log_message);
3617: g_log_message := 'Min Order Qty :'
3618: || to_char (l_pull_sequence_rec.minimum_order_quantity);
3619: MRP_UTIL.MRP_LOG (g_log_message);
3620: g_log_message := 'Fixed Lot Multiplier : '

Line 3619: MRP_UTIL.MRP_LOG (g_log_message);

3615: g_log_message := 'Demand :' || to_char (l_average_demand);
3616: MRP_UTIL.MRP_LOG (g_log_message);
3617: g_log_message := 'Min Order Qty :'
3618: || to_char (l_pull_sequence_rec.minimum_order_quantity);
3619: MRP_UTIL.MRP_LOG (g_log_message);
3620: g_log_message := 'Fixed Lot Multiplier : '
3621: || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
3622: MRP_UTIL.MRP_LOG (g_log_message);
3623: g_log_message := 'Fixed Days Supply :'

Line 3622: MRP_UTIL.MRP_LOG (g_log_message);

3618: || to_char (l_pull_sequence_rec.minimum_order_quantity);
3619: MRP_UTIL.MRP_LOG (g_log_message);
3620: g_log_message := 'Fixed Lot Multiplier : '
3621: || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
3622: MRP_UTIL.MRP_LOG (g_log_message);
3623: g_log_message := 'Fixed Days Supply :'
3624: || to_char (l_pull_sequence_rec.safety_stock_days);
3625: MRP_UTIL.MRP_LOG (g_log_message);
3626: g_log_message := 'Replenishment Lead Time :'

Line 3625: MRP_UTIL.MRP_LOG (g_log_message);

3621: || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
3622: MRP_UTIL.MRP_LOG (g_log_message);
3623: g_log_message := 'Fixed Days Supply :'
3624: || to_char (l_pull_sequence_rec.safety_stock_days);
3625: MRP_UTIL.MRP_LOG (g_log_message);
3626: g_log_message := 'Replenishment Lead Time :'
3627: || to_char (l_pull_sequence_rec.replenishment_lead_time);
3628: MRP_UTIL.MRP_LOG (g_log_message);
3629: g_log_message := 'Calculate Kanban Flag :'

Line 3628: MRP_UTIL.MRP_LOG (g_log_message);

3624: || to_char (l_pull_sequence_rec.safety_stock_days);
3625: MRP_UTIL.MRP_LOG (g_log_message);
3626: g_log_message := 'Replenishment Lead Time :'
3627: || to_char (l_pull_sequence_rec.replenishment_lead_time);
3628: MRP_UTIL.MRP_LOG (g_log_message);
3629: g_log_message := 'Calculate Kanban Flag :'
3630: || to_char (l_pull_sequence_rec.calculate_kanban_flag);
3631: MRP_UTIL.MRP_LOG (g_log_message);
3632: g_log_message := 'Kanban Size :'

Line 3631: MRP_UTIL.MRP_LOG (g_log_message);

3627: || to_char (l_pull_sequence_rec.replenishment_lead_time);
3628: MRP_UTIL.MRP_LOG (g_log_message);
3629: g_log_message := 'Calculate Kanban Flag :'
3630: || to_char (l_pull_sequence_rec.calculate_kanban_flag);
3631: MRP_UTIL.MRP_LOG (g_log_message);
3632: g_log_message := 'Kanban Size :'
3633: || to_char (l_pull_sequence_rec.kanban_size);
3634: MRP_UTIL.MRP_LOG (g_log_message);
3635: g_log_message := 'Number of Cards :'

Line 3634: MRP_UTIL.MRP_LOG (g_log_message);

3630: || to_char (l_pull_sequence_rec.calculate_kanban_flag);
3631: MRP_UTIL.MRP_LOG (g_log_message);
3632: g_log_message := 'Kanban Size :'
3633: || to_char (l_pull_sequence_rec.kanban_size);
3634: MRP_UTIL.MRP_LOG (g_log_message);
3635: g_log_message := 'Number of Cards :'
3636: || to_char (l_pull_sequence_rec.number_of_cards);
3637: MRP_UTIL.MRP_LOG (g_log_message);
3638: END IF;

Line 3637: MRP_UTIL.MRP_LOG (g_log_message);

3633: || to_char (l_pull_sequence_rec.kanban_size);
3634: MRP_UTIL.MRP_LOG (g_log_message);
3635: g_log_message := 'Number of Cards :'
3636: || to_char (l_pull_sequence_rec.number_of_cards);
3637: MRP_UTIL.MRP_LOG (g_log_message);
3638: END IF;
3639:
3640: -- specify the version of the API we want to call
3641: l_api_version := 1.0;

Line 3658: MRP_UTIL.MRP_LOG (g_log_message);

3654:
3655: IF l_return_status <> 'S' THEN
3656: IF g_debug THEN
3657: g_log_message := 'Error in Kanban Quantity Calculation API';
3658: MRP_UTIL.MRP_LOG (g_log_message);
3659: END IF;
3660: RETURN FALSE;
3661: END IF;
3662:

Line 3678: MRP_UTIL.MRP_LOG (g_log_message);

3674: l_pull_sequence_rec.number_of_cards ) THEN
3675:
3676: IF g_debug THEN
3677: g_log_message := 'Error in Kanban Calculation function';
3678: MRP_UTIL.MRP_LOG (g_log_message);
3679: END IF;
3680: RETURN FALSE;
3681:
3682: END IF;

Line 3718: MRP_UTIL.MRP_LOG (g_log_message);

3714:
3715: IF g_debug THEN
3716: g_log_message := 'Kanban Size after Calculation : '
3717: || to_char(l_pull_sequence_rec.kanban_size);
3718: MRP_UTIL.MRP_LOG (g_log_message);
3719: g_log_message := 'Kanban Number after Calculation : '
3720: || to_char(l_pull_sequence_rec.number_of_cards);
3721: MRP_UTIL.MRP_LOG (g_log_message);
3722: END IF;

Line 3721: MRP_UTIL.MRP_LOG (g_log_message);

3717: || to_char(l_pull_sequence_rec.kanban_size);
3718: MRP_UTIL.MRP_LOG (g_log_message);
3719: g_log_message := 'Kanban Number after Calculation : '
3720: || to_char(l_pull_sequence_rec.number_of_cards);
3721: MRP_UTIL.MRP_LOG (g_log_message);
3722: END IF;
3723:
3724: -- call the inventory api for inserting into mtl_pull_sequences
3725: l_return_status := 'S'; -- initialize to success

Line 3740: MRP_UTIL.MRP_LOG (g_log_message);

3736:
3737: IF l_return_status <> 'S' THEN
3738: IF g_debug THEN
3739: g_log_message := 'Error in Inventory Insert/Update API';
3740: MRP_UTIL.MRP_LOG (g_log_message);
3741: g_log_message := 'Return Code : ' || l_return_status;
3742: MRP_UTIL.MRP_LOG (g_log_message);
3743: END IF;
3744: RETURN FALSE;

Line 3742: MRP_UTIL.MRP_LOG (g_log_message);

3738: IF g_debug THEN
3739: g_log_message := 'Error in Inventory Insert/Update API';
3740: MRP_UTIL.MRP_LOG (g_log_message);
3741: g_log_message := 'Return Code : ' || l_return_status;
3742: MRP_UTIL.MRP_LOG (g_log_message);
3743: END IF;
3744: RETURN FALSE;
3745: END IF;
3746:

Line 3762: MRP_UTIL.MRP_LOG (g_log_message);

3758: --exception handling
3759: EXCEPTION
3760: WHEN OTHERS THEN
3761: g_log_message := 'CALCULATE_KANBAN_QUANTITY Sql Error ';
3762: MRP_UTIL.MRP_LOG (g_log_message);
3763: g_log_message := sqlerrm;
3764: MRP_UTIL.MRP_LOG (g_log_message);
3765: RETURN FALSE;
3766:

Line 3764: MRP_UTIL.MRP_LOG (g_log_message);

3760: WHEN OTHERS THEN
3761: g_log_message := 'CALCULATE_KANBAN_QUANTITY Sql Error ';
3762: MRP_UTIL.MRP_LOG (g_log_message);
3763: g_log_message := sqlerrm;
3764: MRP_UTIL.MRP_LOG (g_log_message);
3765: RETURN FALSE;
3766:
3767: END Calculate_Kanban_Quantity;
3768:

Line 3819: MRP_UTIL.MRP_LOG (g_log_message);

3815:
3816: g_stmt_num := 10;
3817: IF g_debug THEN
3818: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3819: MRP_UTIL.MRP_LOG (g_log_message);
3820: END IF;
3821:
3822: -- check for mandatory parameters
3823: -- and issue appropriate error messages

Line 3841: MRP_UTIL.MRP_LOG (g_log_message);

3837:
3838: IF p_organization_id IS NULL OR p_kanban_plan_id IS NULL OR
3839: ((p_bom_effectivity IS NULL OR p_cutoff_date IS NULL) AND
3840: p_replan_flag = 2) THEN
3841: MRP_UTIL.MRP_LOG (g_log_message);
3842: raise exc_error_condition;
3843: END IF;
3844:
3845: -- get all the parameters passed to this concurrent program into

Line 3865: MRP_UTIL.MRP_LOG (g_log_message);

3861: g_kanban_info_rec.replan_flag := p_replan_flag;
3862:
3863: IF g_debug THEN
3864: g_log_message := 'Parameters passed to the program :';
3865: MRP_UTIL.MRP_LOG (g_log_message);
3866: g_log_message := 'organization_id : ' || p_organization_id;
3867: MRP_UTIL.MRP_LOG (g_log_message);
3868: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
3869: MRP_UTIL.MRP_LOG (g_log_message);

Line 3867: MRP_UTIL.MRP_LOG (g_log_message);

3863: IF g_debug THEN
3864: g_log_message := 'Parameters passed to the program :';
3865: MRP_UTIL.MRP_LOG (g_log_message);
3866: g_log_message := 'organization_id : ' || p_organization_id;
3867: MRP_UTIL.MRP_LOG (g_log_message);
3868: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
3869: MRP_UTIL.MRP_LOG (g_log_message);
3870: g_log_message := 'from_item_id : ' || p_from_item;
3871: MRP_UTIL.MRP_LOG (g_log_message);

Line 3869: MRP_UTIL.MRP_LOG (g_log_message);

3865: MRP_UTIL.MRP_LOG (g_log_message);
3866: g_log_message := 'organization_id : ' || p_organization_id;
3867: MRP_UTIL.MRP_LOG (g_log_message);
3868: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
3869: MRP_UTIL.MRP_LOG (g_log_message);
3870: g_log_message := 'from_item_id : ' || p_from_item;
3871: MRP_UTIL.MRP_LOG (g_log_message);
3872: g_log_message := 'to_item_id : ' || p_to_item;
3873: MRP_UTIL.MRP_LOG (g_log_message);

Line 3871: MRP_UTIL.MRP_LOG (g_log_message);

3867: MRP_UTIL.MRP_LOG (g_log_message);
3868: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
3869: MRP_UTIL.MRP_LOG (g_log_message);
3870: g_log_message := 'from_item_id : ' || p_from_item;
3871: MRP_UTIL.MRP_LOG (g_log_message);
3872: g_log_message := 'to_item_id : ' || p_to_item;
3873: MRP_UTIL.MRP_LOG (g_log_message);
3874: g_log_message := 'category_set_id : ' || p_category_set_id;
3875: MRP_UTIL.MRP_LOG (g_log_message);

Line 3873: MRP_UTIL.MRP_LOG (g_log_message);

3869: MRP_UTIL.MRP_LOG (g_log_message);
3870: g_log_message := 'from_item_id : ' || p_from_item;
3871: MRP_UTIL.MRP_LOG (g_log_message);
3872: g_log_message := 'to_item_id : ' || p_to_item;
3873: MRP_UTIL.MRP_LOG (g_log_message);
3874: g_log_message := 'category_set_id : ' || p_category_set_id;
3875: MRP_UTIL.MRP_LOG (g_log_message);
3876: g_log_message := 'category_structure_id : ' || p_category_structure_id;
3877: MRP_UTIL.MRP_LOG (g_log_message);

Line 3875: MRP_UTIL.MRP_LOG (g_log_message);

3871: MRP_UTIL.MRP_LOG (g_log_message);
3872: g_log_message := 'to_item_id : ' || p_to_item;
3873: MRP_UTIL.MRP_LOG (g_log_message);
3874: g_log_message := 'category_set_id : ' || p_category_set_id;
3875: MRP_UTIL.MRP_LOG (g_log_message);
3876: g_log_message := 'category_structure_id : ' || p_category_structure_id;
3877: MRP_UTIL.MRP_LOG (g_log_message);
3878: g_log_message := 'from_category_id : ' || p_from_category;
3879: MRP_UTIL.MRP_LOG (g_log_message);

Line 3877: MRP_UTIL.MRP_LOG (g_log_message);

3873: MRP_UTIL.MRP_LOG (g_log_message);
3874: g_log_message := 'category_set_id : ' || p_category_set_id;
3875: MRP_UTIL.MRP_LOG (g_log_message);
3876: g_log_message := 'category_structure_id : ' || p_category_structure_id;
3877: MRP_UTIL.MRP_LOG (g_log_message);
3878: g_log_message := 'from_category_id : ' || p_from_category;
3879: MRP_UTIL.MRP_LOG (g_log_message);
3880: g_log_message := 'to_category_id : ' || p_to_category;
3881: MRP_UTIL.MRP_LOG (g_log_message);

Line 3879: MRP_UTIL.MRP_LOG (g_log_message);

3875: MRP_UTIL.MRP_LOG (g_log_message);
3876: g_log_message := 'category_structure_id : ' || p_category_structure_id;
3877: MRP_UTIL.MRP_LOG (g_log_message);
3878: g_log_message := 'from_category_id : ' || p_from_category;
3879: MRP_UTIL.MRP_LOG (g_log_message);
3880: g_log_message := 'to_category_id : ' || p_to_category;
3881: MRP_UTIL.MRP_LOG (g_log_message);
3882: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
3883: MRP_UTIL.MRP_LOG (g_log_message);

Line 3881: MRP_UTIL.MRP_LOG (g_log_message);

3877: MRP_UTIL.MRP_LOG (g_log_message);
3878: g_log_message := 'from_category_id : ' || p_from_category;
3879: MRP_UTIL.MRP_LOG (g_log_message);
3880: g_log_message := 'to_category_id : ' || p_to_category;
3881: MRP_UTIL.MRP_LOG (g_log_message);
3882: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
3883: MRP_UTIL.MRP_LOG (g_log_message);
3884: g_log_message := 'start_date : ' || p_start_date;
3885: MRP_UTIL.MRP_LOG (g_log_message);

Line 3883: MRP_UTIL.MRP_LOG (g_log_message);

3879: MRP_UTIL.MRP_LOG (g_log_message);
3880: g_log_message := 'to_category_id : ' || p_to_category;
3881: MRP_UTIL.MRP_LOG (g_log_message);
3882: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
3883: MRP_UTIL.MRP_LOG (g_log_message);
3884: g_log_message := 'start_date : ' || p_start_date;
3885: MRP_UTIL.MRP_LOG (g_log_message);
3886: g_log_message := 'cutoff_date : ' || p_cutoff_date;
3887: MRP_UTIL.MRP_LOG (g_log_message);

Line 3885: MRP_UTIL.MRP_LOG (g_log_message);

3881: MRP_UTIL.MRP_LOG (g_log_message);
3882: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
3883: MRP_UTIL.MRP_LOG (g_log_message);
3884: g_log_message := 'start_date : ' || p_start_date;
3885: MRP_UTIL.MRP_LOG (g_log_message);
3886: g_log_message := 'cutoff_date : ' || p_cutoff_date;
3887: MRP_UTIL.MRP_LOG (g_log_message);
3888: g_log_message := 'replan_flag : ' || p_replan_flag;
3889: MRP_UTIL.MRP_LOG (g_log_message);

Line 3887: MRP_UTIL.MRP_LOG (g_log_message);

3883: MRP_UTIL.MRP_LOG (g_log_message);
3884: g_log_message := 'start_date : ' || p_start_date;
3885: MRP_UTIL.MRP_LOG (g_log_message);
3886: g_log_message := 'cutoff_date : ' || p_cutoff_date;
3887: MRP_UTIL.MRP_LOG (g_log_message);
3888: g_log_message := 'replan_flag : ' || p_replan_flag;
3889: MRP_UTIL.MRP_LOG (g_log_message);
3890: END IF;
3891:

Line 3889: MRP_UTIL.MRP_LOG (g_log_message);

3885: MRP_UTIL.MRP_LOG (g_log_message);
3886: g_log_message := 'cutoff_date : ' || p_cutoff_date;
3887: MRP_UTIL.MRP_LOG (g_log_message);
3888: g_log_message := 'replan_flag : ' || p_replan_flag;
3889: MRP_UTIL.MRP_LOG (g_log_message);
3890: END IF;
3891:
3892: -- call the start_kanban function
3893: IF NOT Start_Kanban_Plan THEN

Line 3895: MRP_UTIL.MRP_LOG (g_log_message);

3891:
3892: -- call the start_kanban function
3893: IF NOT Start_Kanban_Plan THEN
3894: g_log_message := 'Error in START_KANBAN_PLAN';
3895: MRP_UTIL.MRP_LOG (g_log_message);
3896: raise exc_error_condition;
3897: END IF;
3898:
3899: /*

Line 3913: MRP_UTIL.MRP_LOG (g_log_message);

3909: -- and then blow it down to the component item/locations
3910:
3911: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN
3912: g_log_message := 'Error in SNAPSHOT_ITEM_LOCATIONS';
3913: MRP_UTIL.MRP_LOG (g_log_message);
3914: raise exc_error_condition;
3915: END IF;
3916: */
3917: g_stmt_num := 150;

Line 3920: MRP_UTIL.MRP_LOG (g_log_message);

3916: */
3917: g_stmt_num := 150;
3918: IF g_debug THEN
3919: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3920: MRP_UTIL.MRP_LOG (g_log_message);
3921: END IF;
3922:
3923: -- now call the procedure to retrieve the kanban demand based on
3924: -- the input to the kanban plan and pass it down to the components

Line 3929: MRP_UTIL.MRP_LOG (g_log_message);

3925: -- as in the mrp_low_level_codes table
3926:
3927: IF NOT Retrieve_Kanban_Demand THEN
3928: g_log_message := 'Error in RETRIEVE_KANBAN_DEMAND';
3929: MRP_UTIL.MRP_LOG (g_log_message);
3930: raise exc_error_condition;
3931: END IF;
3932:
3933: -- We now have all the demand for this plan run stored in the

Line 3954: MRP_UTIL.MRP_LOG (g_log_message);

3950:
3951: g_stmt_num := 180;
3952: IF g_debug THEN
3953: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3954: MRP_UTIL.MRP_LOG (g_log_message);
3955: END IF;
3956:
3957: IF NOT (Calculate_Kanban_Quantity (l_total_workdays)) THEN
3958: g_log_message := 'Error in CALCULATE_KANBAN_QUANTITY';

Line 3959: MRP_UTIL.MRP_LOG (g_log_message);

3955: END IF;
3956:
3957: IF NOT (Calculate_Kanban_Quantity (l_total_workdays)) THEN
3958: g_log_message := 'Error in CALCULATE_KANBAN_QUANTITY';
3959: MRP_UTIL.MRP_LOG (g_log_message);
3960: raise exc_error_condition;
3961: END IF;
3962:
3963: g_stmt_num := 190;

Line 3966: MRP_UTIL.MRP_LOG (g_log_message);

3962:
3963: g_stmt_num := 190;
3964: IF g_debug THEN
3965: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3966: MRP_UTIL.MRP_LOG (g_log_message);
3967: END IF;
3968:
3969: -- if we come here then we are done with the planning and we can
3970: -- update the plan_completion_date

Line 3976: MRP_UTIL.MRP_LOG (g_log_message);

3972: l_ret_val := End_Kanban_Plan;
3973:
3974: IF NOT l_ret_val THEN
3975: g_log_message := 'Error in END_KANBAN_PLAN';
3976: MRP_UTIL.MRP_LOG (g_log_message);
3977: raise exc_error_condition;
3978: END IF;
3979:
3980: IF g_raise_warning THEN

Line 3998: MRP_UTIL.MRP_LOG (g_log_message);

3994: ROLLBACK;
3995: RETCODE := G_ERROR;
3996: ERRBUF := 'Program Completed with Error : ' || sqlerrm;
3997: g_log_message := 'Program encountered Error condition Exception';
3998: MRP_UTIL.MRP_LOG (g_log_message);
3999:
4000: WHEN OTHERS THEN
4001: ROLLBACK;
4002: RETCODE := G_ERROR;

Line 4005: MRP_UTIL.MRP_LOG (g_log_message);

4001: ROLLBACK;
4002: RETCODE := G_ERROR;
4003: ERRBUF := 'Program Completed with Error : ' || sqlerrm;
4004: g_log_message := 'PLAN_KANBAN Sql Error ';
4005: MRP_UTIL.MRP_LOG (g_log_message);
4006: g_log_message := sqlerrm;
4007: MRP_UTIL.MRP_LOG (g_log_message);
4008:
4009:

Line 4007: MRP_UTIL.MRP_LOG (g_log_message);

4003: ERRBUF := 'Program Completed with Error : ' || sqlerrm;
4004: g_log_message := 'PLAN_KANBAN Sql Error ';
4005: MRP_UTIL.MRP_LOG (g_log_message);
4006: g_log_message := sqlerrm;
4007: MRP_UTIL.MRP_LOG (g_log_message);
4008:
4009:
4010: END PLAN_KANBAN;
4011: