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 114: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 138: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 143: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 148: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 153: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 155: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 190: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 192: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 263: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 265: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 268: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 271: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 273: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 414: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 416: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 418: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 420: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 422: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 430: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 432: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 505: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 531: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 573: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 584: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 621: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 623: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 625: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 627: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 629: MRP_UTIL.MRP_LOG (g_log_message);

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

Line 823: MRP_UTIL.MRP_LOG (g_log_message);

819: --exception handling
820: EXCEPTION
821: WHEN OTHERS THEN
822: g_log_message := 'EXPLODE_REPETITIVE_FORECAST Sql Error ';
823: MRP_UTIL.MRP_LOG (g_log_message);
824: g_log_message := sqlerrm;
825: MRP_UTIL.MRP_LOG (g_log_message);
826: RETURN FALSE;
827: END Explode_Repetitive_Forecast;

Line 825: MRP_UTIL.MRP_LOG (g_log_message);

821: WHEN OTHERS THEN
822: g_log_message := 'EXPLODE_REPETITIVE_FORECAST Sql Error ';
823: MRP_UTIL.MRP_LOG (g_log_message);
824: g_log_message := sqlerrm;
825: MRP_UTIL.MRP_LOG (g_log_message);
826: RETURN FALSE;
827: END Explode_Repetitive_Forecast;
828:
829: -- ========================================================================

Line 1057: MRP_UTIL.MRP_LOG (g_log_message);

1053:
1054: IF g_debug THEN
1055:
1056: g_log_message := 'Entering Cascade_Fcst_Demand function';
1057: MRP_UTIL.MRP_LOG (g_log_message);
1058: g_log_message := 'Cascading Demand For : ';
1059: MRP_UTIL.MRP_LOG (g_log_message);
1060: g_log_message := 'Line : ' || to_char(p_line_id);
1061: MRP_UTIL.MRP_LOG (g_log_message);

Line 1059: MRP_UTIL.MRP_LOG (g_log_message);

1055:
1056: g_log_message := 'Entering Cascade_Fcst_Demand function';
1057: MRP_UTIL.MRP_LOG (g_log_message);
1058: g_log_message := 'Cascading Demand For : ';
1059: MRP_UTIL.MRP_LOG (g_log_message);
1060: g_log_message := 'Line : ' || to_char(p_line_id);
1061: MRP_UTIL.MRP_LOG (g_log_message);
1062: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1063: MRP_UTIL.MRP_LOG (g_log_message);

Line 1061: MRP_UTIL.MRP_LOG (g_log_message);

1057: MRP_UTIL.MRP_LOG (g_log_message);
1058: g_log_message := 'Cascading Demand For : ';
1059: MRP_UTIL.MRP_LOG (g_log_message);
1060: g_log_message := 'Line : ' || to_char(p_line_id);
1061: MRP_UTIL.MRP_LOG (g_log_message);
1062: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1063: MRP_UTIL.MRP_LOG (g_log_message);
1064: g_log_message := 'Sub : ' || p_subinventory;
1065: MRP_UTIL.MRP_LOG (g_log_message);

Line 1063: MRP_UTIL.MRP_LOG (g_log_message);

1059: MRP_UTIL.MRP_LOG (g_log_message);
1060: g_log_message := 'Line : ' || to_char(p_line_id);
1061: MRP_UTIL.MRP_LOG (g_log_message);
1062: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1063: MRP_UTIL.MRP_LOG (g_log_message);
1064: g_log_message := 'Sub : ' || p_subinventory;
1065: MRP_UTIL.MRP_LOG (g_log_message);
1066: g_log_message := 'Loc : ' || p_locator_id;
1067: MRP_UTIL.MRP_LOG (g_log_message);

Line 1065: MRP_UTIL.MRP_LOG (g_log_message);

1061: MRP_UTIL.MRP_LOG (g_log_message);
1062: g_log_message := 'Item : ' || to_char(p_assembly_item_id);
1063: MRP_UTIL.MRP_LOG (g_log_message);
1064: g_log_message := 'Sub : ' || p_subinventory;
1065: MRP_UTIL.MRP_LOG (g_log_message);
1066: g_log_message := 'Loc : ' || p_locator_id;
1067: MRP_UTIL.MRP_LOG (g_log_message);
1068: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
1069: MRP_UTIL.MRP_LOG (g_log_message);

Line 1067: MRP_UTIL.MRP_LOG (g_log_message);

1063: MRP_UTIL.MRP_LOG (g_log_message);
1064: g_log_message := 'Sub : ' || p_subinventory;
1065: MRP_UTIL.MRP_LOG (g_log_message);
1066: g_log_message := 'Loc : ' || p_locator_id;
1067: MRP_UTIL.MRP_LOG (g_log_message);
1068: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
1069: MRP_UTIL.MRP_LOG (g_log_message);
1070: IF NOT p_recursive THEN
1071: g_log_message := ' Recursive : False ';

Line 1069: MRP_UTIL.MRP_LOG (g_log_message);

1065: MRP_UTIL.MRP_LOG (g_log_message);
1066: g_log_message := 'Loc : ' || p_locator_id;
1067: MRP_UTIL.MRP_LOG (g_log_message);
1068: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
1069: MRP_UTIL.MRP_LOG (g_log_message);
1070: IF NOT p_recursive THEN
1071: g_log_message := ' Recursive : False ';
1072: ELSE
1073: g_log_message := ' Recursive : True ';

Line 1075: MRP_UTIL.MRP_LOG (g_log_message);

1071: g_log_message := ' Recursive : False ';
1072: ELSE
1073: g_log_message := ' Recursive : True ';
1074: END IF;
1075: MRP_UTIL.MRP_LOG (g_log_message);
1076: END IF;
1077:
1078: -- Depending on the boolean flag p_recursive, we decide what cursor
1079: -- we want to go after. We know that we will have a line reference

Line 1146: MRP_UTIL.MRP_LOG (g_log_message);

1142: END IF;
1143:
1144: IF g_debug THEN
1145: g_log_message := 'component is : ' || to_char (l_component_id);
1146: MRP_UTIL.MRP_LOG (g_log_message);
1147: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1148: MRP_UTIL.MRP_LOG (g_log_message);
1149: g_log_message := 'Net_Planning_Percent is : ' ||
1150: to_char (l_net_planning_percent);

Line 1148: MRP_UTIL.MRP_LOG (g_log_message);

1144: IF g_debug THEN
1145: g_log_message := 'component is : ' || to_char (l_component_id);
1146: MRP_UTIL.MRP_LOG (g_log_message);
1147: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1148: MRP_UTIL.MRP_LOG (g_log_message);
1149: g_log_message := 'Net_Planning_Percent is : ' ||
1150: to_char (l_net_planning_percent);
1151: MRP_UTIL.MRP_LOG (g_log_message);
1152: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);

Line 1151: MRP_UTIL.MRP_LOG (g_log_message);

1147: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1148: MRP_UTIL.MRP_LOG (g_log_message);
1149: g_log_message := 'Net_Planning_Percent is : ' ||
1150: to_char (l_net_planning_percent);
1151: MRP_UTIL.MRP_LOG (g_log_message);
1152: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1153: MRP_UTIL.MRP_LOG (g_log_message);
1154: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1155: MRP_UTIL.MRP_LOG (g_log_message);

Line 1153: MRP_UTIL.MRP_LOG (g_log_message);

1149: g_log_message := 'Net_Planning_Percent is : ' ||
1150: to_char (l_net_planning_percent);
1151: MRP_UTIL.MRP_LOG (g_log_message);
1152: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1153: MRP_UTIL.MRP_LOG (g_log_message);
1154: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1155: MRP_UTIL.MRP_LOG (g_log_message);
1156:
1157: g_log_message := 'Sub: ' || l_subinventory;

Line 1155: MRP_UTIL.MRP_LOG (g_log_message);

1151: MRP_UTIL.MRP_LOG (g_log_message);
1152: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1153: MRP_UTIL.MRP_LOG (g_log_message);
1154: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1155: MRP_UTIL.MRP_LOG (g_log_message);
1156:
1157: g_log_message := 'Sub: ' || l_subinventory;
1158: MRP_UTIL.MRP_LOG (g_log_message);
1159: END IF;

Line 1158: MRP_UTIL.MRP_LOG (g_log_message);

1154: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1155: MRP_UTIL.MRP_LOG (g_log_message);
1156:
1157: g_log_message := 'Sub: ' || l_subinventory;
1158: MRP_UTIL.MRP_LOG (g_log_message);
1159: END IF;
1160:
1161:
1162: -- calculate the demand quantity to be passed down using all the

Line 1220: MRP_UTIL.MRP_LOG (g_log_message);

1216: /* End of Update */
1217:
1218: IF g_debug THEN
1219: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
1220: MRP_UTIL.MRP_LOG (g_log_message);
1221: END IF;
1222:
1223: -- now insert the demand into the kanban demand table if its > 0
1224:

Line 1303: MRP_UTIL.MRP_LOG (g_log_message);

1299: /* End of Update */
1300:
1301: IF g_debug THEN
1302: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
1303: MRP_UTIL.MRP_LOG (g_log_message);
1304: END IF;
1305:
1306: -- call the function that explodes repetitive foreast demand
1307:

Line 1344: MRP_UTIL.MRP_LOG (g_log_message);

1340:
1341: IF ( l_running_total_quantity > 0) THEN
1342: IF g_debug THEN
1343: g_log_message := 'Calling Cascade_Forecast_Demand in recursive mode';
1344: MRP_UTIL.MRP_LOG (g_log_message);
1345: END IF;
1346:
1347: if (p_assembly_item_id = l_component_id) then
1348: l_bill_or_ps := 2;

Line 1379: MRP_UTIL.MRP_LOG (g_log_message);

1375: l_comp_foq);
1376:
1377: IF g_debug THEN
1378: g_log_message := 'returned from the Cascade_Fcst_Demand call';
1379: MRP_UTIL.MRP_LOG (g_log_message);
1380: END IF;
1381:
1382: IF NOT l_ret_val THEN
1383: RETURN FALSE;

Line 1398: MRP_UTIL.MRP_LOG (g_log_message);

1394: CLOSE component_cursor2;
1395: END IF;
1396: IF g_debug THEN
1397: g_log_message := 'returning from Cascade_Fcst_Demand';
1398: MRP_UTIL.MRP_LOG (g_log_message);
1399: END IF;
1400:
1401: RETURN TRUE;
1402:

Line 1408: MRP_UTIL.MRP_LOG (g_log_message);

1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: g_log_message := 'Cascade_Fcst_Demand Sql Error ';
1408: MRP_UTIL.MRP_LOG (g_log_message);
1409: g_log_message := sqlerrm;
1410: MRP_UTIL.MRP_LOG (g_log_message);
1411: RETURN FALSE;
1412:

Line 1410: MRP_UTIL.MRP_LOG (g_log_message);

1406: WHEN OTHERS THEN
1407: g_log_message := 'Cascade_Fcst_Demand Sql Error ';
1408: MRP_UTIL.MRP_LOG (g_log_message);
1409: g_log_message := sqlerrm;
1410: MRP_UTIL.MRP_LOG (g_log_message);
1411: RETURN FALSE;
1412:
1413: END Cascade_Fcst_Demand;
1414:

Line 1628: MRP_UTIL.MRP_LOG (g_log_message);

1624:
1625: IF g_debug THEN
1626:
1627: g_log_message := 'Entering Cascade_Ap_Demand function';
1628: MRP_UTIL.MRP_LOG (g_log_message);
1629: g_log_message := 'Cascading Demand For : ';
1630: MRP_UTIL.MRP_LOG (g_log_message);
1631: g_log_message := 'Line : ' || to_char(p_line_id);
1632: MRP_UTIL.MRP_LOG (g_log_message);

Line 1630: MRP_UTIL.MRP_LOG (g_log_message);

1626:
1627: g_log_message := 'Entering Cascade_Ap_Demand function';
1628: MRP_UTIL.MRP_LOG (g_log_message);
1629: g_log_message := 'Cascading Demand For : ';
1630: MRP_UTIL.MRP_LOG (g_log_message);
1631: g_log_message := 'Line : ' || to_char(p_line_id);
1632: MRP_UTIL.MRP_LOG (g_log_message);
1633: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
1634: MRP_UTIL.MRP_LOG (g_log_message);

Line 1632: MRP_UTIL.MRP_LOG (g_log_message);

1628: MRP_UTIL.MRP_LOG (g_log_message);
1629: g_log_message := 'Cascading Demand For : ';
1630: MRP_UTIL.MRP_LOG (g_log_message);
1631: g_log_message := 'Line : ' || to_char(p_line_id);
1632: MRP_UTIL.MRP_LOG (g_log_message);
1633: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
1634: MRP_UTIL.MRP_LOG (g_log_message);
1635: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
1636: MRP_UTIL.MRP_LOG (g_log_message);

Line 1634: MRP_UTIL.MRP_LOG (g_log_message);

1630: MRP_UTIL.MRP_LOG (g_log_message);
1631: g_log_message := 'Line : ' || to_char(p_line_id);
1632: MRP_UTIL.MRP_LOG (g_log_message);
1633: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
1634: MRP_UTIL.MRP_LOG (g_log_message);
1635: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
1636: MRP_UTIL.MRP_LOG (g_log_message);
1637: g_log_message := 'Sub : ' || p_subinventory;
1638: MRP_UTIL.MRP_LOG (g_log_message);

Line 1636: MRP_UTIL.MRP_LOG (g_log_message);

1632: MRP_UTIL.MRP_LOG (g_log_message);
1633: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
1634: MRP_UTIL.MRP_LOG (g_log_message);
1635: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
1636: MRP_UTIL.MRP_LOG (g_log_message);
1637: g_log_message := 'Sub : ' || p_subinventory;
1638: MRP_UTIL.MRP_LOG (g_log_message);
1639: g_log_message := 'Loc : ' || p_locator_id;
1640: MRP_UTIL.MRP_LOG (g_log_message);

Line 1638: MRP_UTIL.MRP_LOG (g_log_message);

1634: MRP_UTIL.MRP_LOG (g_log_message);
1635: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
1636: MRP_UTIL.MRP_LOG (g_log_message);
1637: g_log_message := 'Sub : ' || p_subinventory;
1638: MRP_UTIL.MRP_LOG (g_log_message);
1639: g_log_message := 'Loc : ' || p_locator_id;
1640: MRP_UTIL.MRP_LOG (g_log_message);
1641: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
1642: MRP_UTIL.MRP_LOG (g_log_message);

Line 1640: MRP_UTIL.MRP_LOG (g_log_message);

1636: MRP_UTIL.MRP_LOG (g_log_message);
1637: g_log_message := 'Sub : ' || p_subinventory;
1638: MRP_UTIL.MRP_LOG (g_log_message);
1639: g_log_message := 'Loc : ' || p_locator_id;
1640: MRP_UTIL.MRP_LOG (g_log_message);
1641: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
1642: MRP_UTIL.MRP_LOG (g_log_message);
1643: IF NOT p_recursive THEN
1644: g_log_message := ' Recursive : False ';

Line 1642: MRP_UTIL.MRP_LOG (g_log_message);

1638: MRP_UTIL.MRP_LOG (g_log_message);
1639: g_log_message := 'Loc : ' || p_locator_id;
1640: MRP_UTIL.MRP_LOG (g_log_message);
1641: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
1642: MRP_UTIL.MRP_LOG (g_log_message);
1643: IF NOT p_recursive THEN
1644: g_log_message := ' Recursive : False ';
1645: ELSE
1646: g_log_message := ' Recursive : True ';

Line 1648: MRP_UTIL.MRP_LOG (g_log_message);

1644: g_log_message := ' Recursive : False ';
1645: ELSE
1646: g_log_message := ' Recursive : True ';
1647: END IF;
1648: MRP_UTIL.MRP_LOG (g_log_message);
1649: END IF;
1650:
1651:
1652: -- Depending on the boolean flag p_recursive, we decide what cursor

Line 1722: MRP_UTIL.MRP_LOG (g_log_message);

1718: END IF;
1719:
1720: IF g_debug THEN
1721: g_log_message := 'component is : ' || to_char (l_component_id);
1722: MRP_UTIL.MRP_LOG (g_log_message);
1723: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1724: MRP_UTIL.MRP_LOG (g_log_message);
1725: g_log_message := 'Net_Planning_Percent is : ' ||
1726: to_char (l_net_planning_percent);

Line 1724: MRP_UTIL.MRP_LOG (g_log_message);

1720: IF g_debug THEN
1721: g_log_message := 'component is : ' || to_char (l_component_id);
1722: MRP_UTIL.MRP_LOG (g_log_message);
1723: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1724: MRP_UTIL.MRP_LOG (g_log_message);
1725: g_log_message := 'Net_Planning_Percent is : ' ||
1726: to_char (l_net_planning_percent);
1727: MRP_UTIL.MRP_LOG (g_log_message);
1728: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);

Line 1727: MRP_UTIL.MRP_LOG (g_log_message);

1723: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
1724: MRP_UTIL.MRP_LOG (g_log_message);
1725: g_log_message := 'Net_Planning_Percent is : ' ||
1726: to_char (l_net_planning_percent);
1727: MRP_UTIL.MRP_LOG (g_log_message);
1728: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1729: MRP_UTIL.MRP_LOG (g_log_message);
1730: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1731: MRP_UTIL.MRP_LOG (g_log_message);

Line 1729: MRP_UTIL.MRP_LOG (g_log_message);

1725: g_log_message := 'Net_Planning_Percent is : ' ||
1726: to_char (l_net_planning_percent);
1727: MRP_UTIL.MRP_LOG (g_log_message);
1728: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1729: MRP_UTIL.MRP_LOG (g_log_message);
1730: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1731: MRP_UTIL.MRP_LOG (g_log_message);
1732: END IF;
1733:

Line 1731: MRP_UTIL.MRP_LOG (g_log_message);

1727: MRP_UTIL.MRP_LOG (g_log_message);
1728: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
1729: MRP_UTIL.MRP_LOG (g_log_message);
1730: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
1731: MRP_UTIL.MRP_LOG (g_log_message);
1732: END IF;
1733:
1734: -- calculate the demand quantity to be passed down using all the
1735: -- percentages and yields stuff that we've got

Line 1774: MRP_UTIL.MRP_LOG (g_log_message);

1770: /* End of Update */
1771:
1772: IF g_debug THEN
1773: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
1774: MRP_UTIL.MRP_LOG (g_log_message);
1775: END IF;
1776:
1777: -- now insert the demand into the kanban demand table if its > 0
1778:

Line 1846: MRP_UTIL.MRP_LOG (g_log_message);

1842:
1843: IF ( l_running_total_quantity > 0) THEN
1844: IF g_debug THEN
1845: g_log_message := 'Calling Cascade_Ap_Demand in recursive mode';
1846: MRP_UTIL.MRP_LOG (g_log_message);
1847: END IF;
1848:
1849: if (p_assembly_item_id = l_component_id) then
1850: l_bill_or_ps := 2;

Line 1883: MRP_UTIL.MRP_LOG (g_log_message);

1879: l_comp_foq);
1880:
1881: IF g_debug THEN
1882: g_log_message := 'returned from the cascade call';
1883: MRP_UTIL.MRP_LOG (g_log_message);
1884: END IF;
1885:
1886:
1887: IF NOT l_ret_val THEN

Line 1903: MRP_UTIL.MRP_LOG (g_log_message);

1899: CLOSE component_cursor2;
1900: END IF;
1901: IF g_debug THEN
1902: g_log_message := 'returning from Cascade_Ap_Demand';
1903: MRP_UTIL.MRP_LOG (g_log_message);
1904: END IF;
1905: RETURN TRUE;
1906:
1907: --exception handling

Line 1911: MRP_UTIL.MRP_LOG (g_log_message);

1907: --exception handling
1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: g_log_message := 'Cascade_Ap_Demand Sql Error ';
1911: MRP_UTIL.MRP_LOG (g_log_message);
1912: g_log_message := sqlerrm;
1913: MRP_UTIL.MRP_LOG (g_log_message);
1914: RETURN FALSE;
1915:

Line 1913: MRP_UTIL.MRP_LOG (g_log_message);

1909: WHEN OTHERS THEN
1910: g_log_message := 'Cascade_Ap_Demand Sql Error ';
1911: MRP_UTIL.MRP_LOG (g_log_message);
1912: g_log_message := sqlerrm;
1913: MRP_UTIL.MRP_LOG (g_log_message);
1914: RETURN FALSE;
1915:
1916: END Cascade_Ap_Demand;
1917:

Line 2131: MRP_UTIL.MRP_LOG (g_log_message);

2127:
2128: IF g_debug THEN
2129:
2130: g_log_message := 'Entering Cascade_Mds_Mps_Demand function';
2131: MRP_UTIL.MRP_LOG (g_log_message);
2132: g_log_message := 'Cascading Demand For : ';
2133: MRP_UTIL.MRP_LOG (g_log_message);
2134: g_log_message := 'Line : ' || to_char(p_line_id);
2135: MRP_UTIL.MRP_LOG (g_log_message);

Line 2133: MRP_UTIL.MRP_LOG (g_log_message);

2129:
2130: g_log_message := 'Entering Cascade_Mds_Mps_Demand function';
2131: MRP_UTIL.MRP_LOG (g_log_message);
2132: g_log_message := 'Cascading Demand For : ';
2133: MRP_UTIL.MRP_LOG (g_log_message);
2134: g_log_message := 'Line : ' || to_char(p_line_id);
2135: MRP_UTIL.MRP_LOG (g_log_message);
2136: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
2137: MRP_UTIL.MRP_LOG (g_log_message);

Line 2135: MRP_UTIL.MRP_LOG (g_log_message);

2131: MRP_UTIL.MRP_LOG (g_log_message);
2132: g_log_message := 'Cascading Demand For : ';
2133: MRP_UTIL.MRP_LOG (g_log_message);
2134: g_log_message := 'Line : ' || to_char(p_line_id);
2135: MRP_UTIL.MRP_LOG (g_log_message);
2136: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
2137: MRP_UTIL.MRP_LOG (g_log_message);
2138: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
2139: MRP_UTIL.MRP_LOG (g_log_message);

Line 2137: MRP_UTIL.MRP_LOG (g_log_message);

2133: MRP_UTIL.MRP_LOG (g_log_message);
2134: g_log_message := 'Line : ' || to_char(p_line_id);
2135: MRP_UTIL.MRP_LOG (g_log_message);
2136: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
2137: MRP_UTIL.MRP_LOG (g_log_message);
2138: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
2139: MRP_UTIL.MRP_LOG (g_log_message);
2140: g_log_message := 'Sub : ' || p_subinventory;
2141: MRP_UTIL.MRP_LOG (g_log_message);

Line 2139: MRP_UTIL.MRP_LOG (g_log_message);

2135: MRP_UTIL.MRP_LOG (g_log_message);
2136: g_log_message := 'Top Item : ' || to_char(p_top_item_id);
2137: MRP_UTIL.MRP_LOG (g_log_message);
2138: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
2139: MRP_UTIL.MRP_LOG (g_log_message);
2140: g_log_message := 'Sub : ' || p_subinventory;
2141: MRP_UTIL.MRP_LOG (g_log_message);
2142: g_log_message := 'Loc : ' || p_locator_id;
2143: MRP_UTIL.MRP_LOG (g_log_message);

Line 2141: MRP_UTIL.MRP_LOG (g_log_message);

2137: MRP_UTIL.MRP_LOG (g_log_message);
2138: g_log_message := 'Assembly Item : ' || to_char(p_assembly_item_id);
2139: MRP_UTIL.MRP_LOG (g_log_message);
2140: g_log_message := 'Sub : ' || p_subinventory;
2141: MRP_UTIL.MRP_LOG (g_log_message);
2142: g_log_message := 'Loc : ' || p_locator_id;
2143: MRP_UTIL.MRP_LOG (g_log_message);
2144: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
2145: MRP_UTIL.MRP_LOG (g_log_message);

Line 2143: MRP_UTIL.MRP_LOG (g_log_message);

2139: MRP_UTIL.MRP_LOG (g_log_message);
2140: g_log_message := 'Sub : ' || p_subinventory;
2141: MRP_UTIL.MRP_LOG (g_log_message);
2142: g_log_message := 'Loc : ' || p_locator_id;
2143: MRP_UTIL.MRP_LOG (g_log_message);
2144: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
2145: MRP_UTIL.MRP_LOG (g_log_message);
2146: IF NOT p_recursive THEN
2147: g_log_message := ' Recursive : False ';

Line 2145: MRP_UTIL.MRP_LOG (g_log_message);

2141: MRP_UTIL.MRP_LOG (g_log_message);
2142: g_log_message := 'Loc : ' || p_locator_id;
2143: MRP_UTIL.MRP_LOG (g_log_message);
2144: g_log_message := 'p_cumulative_usage : ' || p_cumulative_usage;
2145: MRP_UTIL.MRP_LOG (g_log_message);
2146: IF NOT p_recursive THEN
2147: g_log_message := ' Recursive : False ';
2148: ELSE
2149: g_log_message := ' Recursive : True ';

Line 2151: MRP_UTIL.MRP_LOG (g_log_message);

2147: g_log_message := ' Recursive : False ';
2148: ELSE
2149: g_log_message := ' Recursive : True ';
2150: END IF;
2151: MRP_UTIL.MRP_LOG (g_log_message);
2152: END IF;
2153:
2154:
2155: -- Depending on the boolean flag p_recursive, we decide what cursor

Line 2225: MRP_UTIL.MRP_LOG (g_log_message);

2221: END IF;
2222:
2223: IF g_debug THEN
2224: g_log_message := 'component is : ' || to_char (l_component_id);
2225: MRP_UTIL.MRP_LOG (g_log_message);
2226: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
2227: MRP_UTIL.MRP_LOG (g_log_message);
2228: g_log_message := 'Net_Planning_Percent is : ' ||
2229: to_char (l_net_planning_percent);

Line 2227: MRP_UTIL.MRP_LOG (g_log_message);

2223: IF g_debug THEN
2224: g_log_message := 'component is : ' || to_char (l_component_id);
2225: MRP_UTIL.MRP_LOG (g_log_message);
2226: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
2227: MRP_UTIL.MRP_LOG (g_log_message);
2228: g_log_message := 'Net_Planning_Percent is : ' ||
2229: to_char (l_net_planning_percent);
2230: MRP_UTIL.MRP_LOG (g_log_message);
2231: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);

Line 2230: MRP_UTIL.MRP_LOG (g_log_message);

2226: g_log_message := 'component_usage is : ' || to_char (l_component_usage);
2227: MRP_UTIL.MRP_LOG (g_log_message);
2228: g_log_message := 'Net_Planning_Percent is : ' ||
2229: to_char (l_net_planning_percent);
2230: MRP_UTIL.MRP_LOG (g_log_message);
2231: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
2232: MRP_UTIL.MRP_LOG (g_log_message);
2233: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
2234: MRP_UTIL.MRP_LOG (g_log_message);

Line 2232: MRP_UTIL.MRP_LOG (g_log_message);

2228: g_log_message := 'Net_Planning_Percent is : ' ||
2229: to_char (l_net_planning_percent);
2230: MRP_UTIL.MRP_LOG (g_log_message);
2231: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
2232: MRP_UTIL.MRP_LOG (g_log_message);
2233: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
2234: MRP_UTIL.MRP_LOG (g_log_message);
2235: END IF;
2236:

Line 2234: MRP_UTIL.MRP_LOG (g_log_message);

2230: MRP_UTIL.MRP_LOG (g_log_message);
2231: g_log_message := 'Operation_Yield is : ' || to_char (l_operation_yield);
2232: MRP_UTIL.MRP_LOG (g_log_message);
2233: g_log_message := 'Component_Yield is : ' || to_char (l_component_yield);
2234: MRP_UTIL.MRP_LOG (g_log_message);
2235: END IF;
2236:
2237: -- calculate the demand quantity to be passed down using all the
2238: -- percentages and yields stuff that we've got

Line 2277: MRP_UTIL.MRP_LOG (g_log_message);

2273: /* End of Update */
2274:
2275: IF g_debug THEN
2276: g_log_message := 'Deamnd Quantity:'||to_char(l_demand_quantity);
2277: MRP_UTIL.MRP_LOG (g_log_message);
2278: END IF;
2279:
2280: -- now insert the demand into the kanban demand table if its > 0
2281:

Line 2349: MRP_UTIL.MRP_LOG (g_log_message);

2345:
2346: IF ( l_running_total_quantity > 0) THEN
2347: IF g_debug THEN
2348: g_log_message := 'Calling Cascade_Mds_Mps_Demand in recursive mode';
2349: MRP_UTIL.MRP_LOG (g_log_message);
2350: END IF;
2351:
2352: if (p_assembly_item_id = l_component_id) then
2353: l_bill_or_ps := 2;

Line 2384: MRP_UTIL.MRP_LOG (g_log_message);

2380: l_comp_foq);
2381:
2382: IF g_debug THEN
2383: g_log_message := 'returned from the cascade call';
2384: MRP_UTIL.MRP_LOG (g_log_message);
2385: END IF;
2386:
2387:
2388: IF NOT l_ret_val THEN

Line 2404: MRP_UTIL.MRP_LOG (g_log_message);

2400: CLOSE component_cursor2;
2401: END IF;
2402: IF g_debug THEN
2403: g_log_message := 'returning from Cascade_Mds_Mps_Demand';
2404: MRP_UTIL.MRP_LOG (g_log_message);
2405: END IF;
2406: RETURN TRUE;
2407:
2408: --exception handling

Line 2412: MRP_UTIL.MRP_LOG (g_log_message);

2408: --exception handling
2409: EXCEPTION
2410: WHEN OTHERS THEN
2411: g_log_message := 'Cascade_Mds_Mps_Demand Sql Error ';
2412: MRP_UTIL.MRP_LOG (g_log_message);
2413: g_log_message := sqlerrm;
2414: MRP_UTIL.MRP_LOG (g_log_message);
2415: RETURN FALSE;
2416:

Line 2414: MRP_UTIL.MRP_LOG (g_log_message);

2410: WHEN OTHERS THEN
2411: g_log_message := 'Cascade_Mds_Mps_Demand Sql Error ';
2412: MRP_UTIL.MRP_LOG (g_log_message);
2413: g_log_message := sqlerrm;
2414: MRP_UTIL.MRP_LOG (g_log_message);
2415: RETURN FALSE;
2416:
2417: END Cascade_Mds_Mps_Demand;
2418:

Line 2488: MRP_UTIL.MRP_LOG (g_log_message);

2484: BEGIN
2485:
2486: IF g_debug THEN
2487: g_log_message := 'Insert_Fcst_Demand: Inserting Demand For :';
2488: MRP_UTIL.MRP_LOG (g_log_message);
2489: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2490: MRP_UTIL.MRP_LOG (g_log_message);
2491: g_log_message := 'Line Reference :' || to_char(p_line_id);
2492: MRP_UTIL.MRP_LOG (g_log_message);

Line 2490: MRP_UTIL.MRP_LOG (g_log_message);

2486: IF g_debug THEN
2487: g_log_message := 'Insert_Fcst_Demand: Inserting Demand For :';
2488: MRP_UTIL.MRP_LOG (g_log_message);
2489: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2490: MRP_UTIL.MRP_LOG (g_log_message);
2491: g_log_message := 'Line Reference :' || to_char(p_line_id);
2492: MRP_UTIL.MRP_LOG (g_log_message);
2493: END IF;
2494:

Line 2492: MRP_UTIL.MRP_LOG (g_log_message);

2488: MRP_UTIL.MRP_LOG (g_log_message);
2489: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2490: MRP_UTIL.MRP_LOG (g_log_message);
2491: g_log_message := 'Line Reference :' || to_char(p_line_id);
2492: MRP_UTIL.MRP_LOG (g_log_message);
2493: END IF;
2494:
2495: g_stmt_num := 170;
2496: IF g_debug THEN

Line 2498: MRP_UTIL.MRP_LOG (g_log_message);

2494:
2495: g_stmt_num := 170;
2496: IF g_debug THEN
2497: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2498: MRP_UTIL.MRP_LOG (g_log_message);
2499: END IF;
2500:
2501: -- the first insert here is for the item for which we have
2502: -- foreacast based on the allocation percentages mentioned

Line 2535: MRP_UTIL.MRP_LOG (g_log_message);

2531: End;
2532: END IF;
2533: IF g_debug THEN
2534: g_log_message := 'demand quantity:'||to_char(l_forecast_quantity);
2535: MRP_UTIL.MRP_LOG (g_log_message);
2536: g_log_message := 'demand date:'||to_char(l_forecast_date);
2537: MRP_UTIL.MRP_LOG (g_log_message);
2538: END IF;
2539:

Line 2537: MRP_UTIL.MRP_LOG (g_log_message);

2533: IF g_debug THEN
2534: g_log_message := 'demand quantity:'||to_char(l_forecast_quantity);
2535: MRP_UTIL.MRP_LOG (g_log_message);
2536: g_log_message := 'demand date:'||to_char(l_forecast_date);
2537: MRP_UTIL.MRP_LOG (g_log_message);
2538: END IF;
2539:
2540: IF l_rate_end_date IS NULL THEN
2541: -- not a repetitive forecast - simple processing

Line 2726: MRP_UTIL.MRP_LOG (g_log_message);

2722:
2723: g_stmt_num := 175;
2724: IF g_debug THEN
2725: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2726: MRP_UTIL.MRP_LOG (g_log_message);
2727: g_log_message := 'Calling Cascade_Fcst_Demand in NON Recursive Mode';
2728: MRP_UTIL.MRP_LOG (g_log_message);
2729: END IF;
2730:

Line 2728: MRP_UTIL.MRP_LOG (g_log_message);

2724: IF g_debug THEN
2725: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2726: MRP_UTIL.MRP_LOG (g_log_message);
2727: g_log_message := 'Calling Cascade_Fcst_Demand in NON Recursive Mode';
2728: MRP_UTIL.MRP_LOG (g_log_message);
2729: END IF;
2730:
2731: -- Before we call the function Cascade_Fcst_Demand,
2732: -- we need to set the flags

Line 2771: MRP_UTIL.MRP_LOG (g_log_message);

2767: l_sales_order_demand,
2768: l_foq);
2769: IF g_debug THEN
2770: g_log_message := 'Returning from Insert_Fcst_Demand';
2771: MRP_UTIL.MRP_LOG (g_log_message);
2772: END IF;
2773:
2774: IF NOT l_ret_val THEN
2775: RETURN FALSE;

Line 2784: MRP_UTIL.MRP_LOG (g_log_message);

2780: --exception handling
2781: EXCEPTION
2782: WHEN OTHERS THEN
2783: g_log_message := 'INSERT_FCST_DEMAND Sql Error ';
2784: MRP_UTIL.MRP_LOG (g_log_message);
2785: g_log_message := sqlerrm;
2786: MRP_UTIL.MRP_LOG (g_log_message);
2787: RETURN FALSE;
2788:

Line 2786: MRP_UTIL.MRP_LOG (g_log_message);

2782: WHEN OTHERS THEN
2783: g_log_message := 'INSERT_FCST_DEMAND Sql Error ';
2784: MRP_UTIL.MRP_LOG (g_log_message);
2785: g_log_message := sqlerrm;
2786: MRP_UTIL.MRP_LOG (g_log_message);
2787: RETURN FALSE;
2788:
2789: END Insert_Fcst_Demand;
2790:

Line 2845: MRP_UTIL.MRP_LOG (g_log_message);

2841: -- ---------------------------------------------
2842:
2843: IF g_debug THEN
2844: g_log_message := 'Insert_Ap_Demand: Inserting Demand For :';
2845: MRP_UTIL.MRP_LOG (g_log_message);
2846: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2847: MRP_UTIL.MRP_LOG (g_log_message);
2848: g_log_message := 'Alternate : ' || p_alt_bom ;
2849: MRP_UTIL.MRP_LOG (g_log_message);

Line 2847: MRP_UTIL.MRP_LOG (g_log_message);

2843: IF g_debug THEN
2844: g_log_message := 'Insert_Ap_Demand: Inserting Demand For :';
2845: MRP_UTIL.MRP_LOG (g_log_message);
2846: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2847: MRP_UTIL.MRP_LOG (g_log_message);
2848: g_log_message := 'Alternate : ' || p_alt_bom ;
2849: MRP_UTIL.MRP_LOG (g_log_message);
2850: g_log_message := 'Line Reference :' || to_char(p_line_id);
2851: MRP_UTIL.MRP_LOG (g_log_message);

Line 2849: MRP_UTIL.MRP_LOG (g_log_message);

2845: MRP_UTIL.MRP_LOG (g_log_message);
2846: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
2847: MRP_UTIL.MRP_LOG (g_log_message);
2848: g_log_message := 'Alternate : ' || p_alt_bom ;
2849: MRP_UTIL.MRP_LOG (g_log_message);
2850: g_log_message := 'Line Reference :' || to_char(p_line_id);
2851: MRP_UTIL.MRP_LOG (g_log_message);
2852: END IF;
2853:

Line 2851: MRP_UTIL.MRP_LOG (g_log_message);

2847: MRP_UTIL.MRP_LOG (g_log_message);
2848: g_log_message := 'Alternate : ' || p_alt_bom ;
2849: MRP_UTIL.MRP_LOG (g_log_message);
2850: g_log_message := 'Line Reference :' || to_char(p_line_id);
2851: MRP_UTIL.MRP_LOG (g_log_message);
2852: END IF;
2853:
2854: g_stmt_num := 170;
2855: IF g_debug THEN

Line 2857: MRP_UTIL.MRP_LOG (g_log_message);

2853:
2854: g_stmt_num := 170;
2855: IF g_debug THEN
2856: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
2857: MRP_UTIL.MRP_LOG (g_log_message);
2858: END IF;
2859:
2860: -- the first insert here is for the item for which we have
2861: -- mds/mps based on the allocation percentages mentioned

Line 2880: MRP_UTIL.MRP_LOG (g_log_message);

2876: EXIT WHEN item_schedule_entries%NOTFOUND;
2877:
2878: IF g_debug THEN
2879: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
2880: MRP_UTIL.MRP_LOG (g_log_message);
2881: g_log_message := 'demand date:'||to_char(l_schedule_date);
2882: MRP_UTIL.MRP_LOG (g_log_message);
2883: END IF;
2884:

Line 2882: MRP_UTIL.MRP_LOG (g_log_message);

2878: IF g_debug THEN
2879: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
2880: MRP_UTIL.MRP_LOG (g_log_message);
2881: g_log_message := 'demand date:'||to_char(l_schedule_date);
2882: MRP_UTIL.MRP_LOG (g_log_message);
2883: END IF;
2884:
2885: /* Bug 2279877, we allow null-line for discrete and not get line from primary rtg
2886: IF (l_line_id is NULL) THEN

Line 3044: MRP_UTIL.MRP_LOG (g_log_message);

3040:
3041: g_stmt_num := 175;
3042: IF g_debug THEN
3043: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3044: MRP_UTIL.MRP_LOG (g_log_message);
3045: g_log_message := 'Calling Cascade_Ap_Demand in NON Recursive Mode';
3046: MRP_UTIL.MRP_LOG (g_log_message);
3047: END IF;
3048:

Line 3046: MRP_UTIL.MRP_LOG (g_log_message);

3042: IF g_debug THEN
3043: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3044: MRP_UTIL.MRP_LOG (g_log_message);
3045: g_log_message := 'Calling Cascade_Ap_Demand in NON Recursive Mode';
3046: MRP_UTIL.MRP_LOG (g_log_message);
3047: END IF;
3048:
3049: -- Before we call the function Cascade_Ap_Demand,
3050: -- we need to set the flags

Line 3086: MRP_UTIL.MRP_LOG (g_log_message);

3082: l_foq);
3083:
3084: IF g_debug THEN
3085: g_log_message := 'Returning from Insert_Ap_Demand';
3086: MRP_UTIL.MRP_LOG (g_log_message);
3087: END IF;
3088:
3089: IF NOT l_ret_val THEN
3090: RETURN FALSE;

Line 3099: MRP_UTIL.MRP_LOG (g_log_message);

3095: --exception handling
3096: EXCEPTION
3097: WHEN OTHERS THEN
3098: g_log_message := 'INSERT_AP_DEMAND Sql Error ';
3099: MRP_UTIL.MRP_LOG (g_log_message);
3100: g_log_message := sqlerrm;
3101: MRP_UTIL.MRP_LOG (g_log_message);
3102: RETURN FALSE;
3103:

Line 3101: MRP_UTIL.MRP_LOG (g_log_message);

3097: WHEN OTHERS THEN
3098: g_log_message := 'INSERT_AP_DEMAND Sql Error ';
3099: MRP_UTIL.MRP_LOG (g_log_message);
3100: g_log_message := sqlerrm;
3101: MRP_UTIL.MRP_LOG (g_log_message);
3102: RETURN FALSE;
3103:
3104: END Insert_Ap_Demand;
3105:

Line 3159: MRP_UTIL.MRP_LOG (g_log_message);

3155: -- ---------------------------------------------
3156:
3157: IF g_debug THEN
3158: g_log_message := 'Insert_Mds_Mps_Demand : Inserting Demand For :';
3159: MRP_UTIL.MRP_LOG (g_log_message);
3160: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
3161: MRP_UTIL.MRP_LOG (g_log_message);
3162: g_log_message := 'Line Reference :' || to_char(p_line_id);
3163: MRP_UTIL.MRP_LOG (g_log_message);

Line 3161: MRP_UTIL.MRP_LOG (g_log_message);

3157: IF g_debug THEN
3158: g_log_message := 'Insert_Mds_Mps_Demand : Inserting Demand For :';
3159: MRP_UTIL.MRP_LOG (g_log_message);
3160: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
3161: MRP_UTIL.MRP_LOG (g_log_message);
3162: g_log_message := 'Line Reference :' || to_char(p_line_id);
3163: MRP_UTIL.MRP_LOG (g_log_message);
3164: END IF;
3165:

Line 3163: MRP_UTIL.MRP_LOG (g_log_message);

3159: MRP_UTIL.MRP_LOG (g_log_message);
3160: g_log_message := 'Item : ' || to_char(p_inventory_item_id) ;
3161: MRP_UTIL.MRP_LOG (g_log_message);
3162: g_log_message := 'Line Reference :' || to_char(p_line_id);
3163: MRP_UTIL.MRP_LOG (g_log_message);
3164: END IF;
3165:
3166: g_stmt_num := 170;
3167: IF g_debug THEN

Line 3169: MRP_UTIL.MRP_LOG (g_log_message);

3165:
3166: g_stmt_num := 170;
3167: IF g_debug THEN
3168: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3169: MRP_UTIL.MRP_LOG (g_log_message);
3170: END IF;
3171:
3172: -- the first insert here is for the item for which we have
3173: -- mds/mps based on the allocation percentages mentioned

Line 3192: MRP_UTIL.MRP_LOG (g_log_message);

3188: EXIT WHEN item_schedule_entries%NOTFOUND;
3189:
3190: IF g_debug THEN
3191: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
3192: MRP_UTIL.MRP_LOG (g_log_message);
3193: g_log_message := 'demand date:'||to_char(l_schedule_date);
3194: MRP_UTIL.MRP_LOG (g_log_message);
3195: END IF;
3196:

Line 3194: MRP_UTIL.MRP_LOG (g_log_message);

3190: IF g_debug THEN
3191: g_log_message := 'demand quantity:'||to_char(l_schedule_quantity);
3192: MRP_UTIL.MRP_LOG (g_log_message);
3193: g_log_message := 'demand date:'||to_char(l_schedule_date);
3194: MRP_UTIL.MRP_LOG (g_log_message);
3195: END IF;
3196:
3197: IF (l_line_id is NULL) THEN
3198: Begin

Line 3355: MRP_UTIL.MRP_LOG (g_log_message);

3351:
3352: g_stmt_num := 175;
3353: IF g_debug THEN
3354: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3355: MRP_UTIL.MRP_LOG (g_log_message);
3356: g_log_message := 'Calling Cascade_Mds_Mps_Demand in NON Recursive Mode';
3357: MRP_UTIL.MRP_LOG (g_log_message);
3358: END IF;
3359:

Line 3357: MRP_UTIL.MRP_LOG (g_log_message);

3353: IF g_debug THEN
3354: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3355: MRP_UTIL.MRP_LOG (g_log_message);
3356: g_log_message := 'Calling Cascade_Mds_Mps_Demand in NON Recursive Mode';
3357: MRP_UTIL.MRP_LOG (g_log_message);
3358: END IF;
3359:
3360: -- Before we call the function Cascade_Mds_Mps_Demand,
3361: -- we need to set the flags

Line 3390: MRP_UTIL.MRP_LOG (g_log_message);

3386: l_explode_always := 'N';
3387: END IF;
3388: IF g_debug THEN
3389: g_log_message := 'calling Cascade_Mds_Mps_Demand : ' || l_explode_always;
3390: MRP_UTIL.MRP_LOG (g_log_message);
3391: END IF;
3392: l_ret_val := Cascade_Mds_Mps_Demand(
3393: 1,
3394: FALSE,

Line 3408: MRP_UTIL.MRP_LOG (g_log_message);

3404: l_sales_order_demand,
3405: l_foq);
3406: IF g_debug THEN
3407: g_log_message := 'Returning from Insert_Mds_Mps_Demand';
3408: MRP_UTIL.MRP_LOG (g_log_message);
3409: END IF;
3410: IF NOT l_ret_val THEN
3411: RETURN FALSE;
3412: END IF;

Line 3420: MRP_UTIL.MRP_LOG (g_log_message);

3416: --exception handling
3417: EXCEPTION
3418: WHEN OTHERS THEN
3419: g_log_message := 'INSERT_DEMAND Sql Error ';
3420: MRP_UTIL.MRP_LOG (g_log_message);
3421: g_log_message := sqlerrm;
3422: MRP_UTIL.MRP_LOG (g_log_message);
3423: RETURN FALSE;
3424:

Line 3422: MRP_UTIL.MRP_LOG (g_log_message);

3418: WHEN OTHERS THEN
3419: g_log_message := 'INSERT_DEMAND Sql Error ';
3420: MRP_UTIL.MRP_LOG (g_log_message);
3421: g_log_message := sqlerrm;
3422: MRP_UTIL.MRP_LOG (g_log_message);
3423: RETURN FALSE;
3424:
3425: END Insert_Mds_Mps_Demand;
3426:

Line 3587: MRP_UTIL.MRP_LOG (g_log_message);

3583: EXIT WHEN cur_forecast_entries%NOTFOUND;
3584:
3585: IF g_debug THEN
3586: g_log_message := 'Forecast Entry Details : ' ;
3587: MRP_UTIL.MRP_LOG (g_log_message);
3588: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3589: MRP_UTIL.MRP_LOG (g_log_message);
3590: END IF;
3591:

Line 3589: MRP_UTIL.MRP_LOG (g_log_message);

3585: IF g_debug THEN
3586: g_log_message := 'Forecast Entry Details : ' ;
3587: MRP_UTIL.MRP_LOG (g_log_message);
3588: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3589: MRP_UTIL.MRP_LOG (g_log_message);
3590: END IF;
3591:
3592: ELSIF ( g_kanban_info_rec.input_type = 2 OR
3593: g_kanban_info_rec.input_type = 3 ) THEN

Line 3609: MRP_UTIL.MRP_LOG (g_log_message);

3605: EXIT WHEN cur_schedule_entries%NOTFOUND;
3606:
3607: IF g_debug THEN
3608: g_log_message := 'Schedule Entry Details : ' ;
3609: MRP_UTIL.MRP_LOG (g_log_message);
3610: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3611: MRP_UTIL.MRP_LOG (g_log_message);
3612: g_log_message := 'Line Reference :' || to_char(l_line_id);
3613: MRP_UTIL.MRP_LOG (g_log_message);

Line 3611: MRP_UTIL.MRP_LOG (g_log_message);

3607: IF g_debug THEN
3608: g_log_message := 'Schedule Entry Details : ' ;
3609: MRP_UTIL.MRP_LOG (g_log_message);
3610: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3611: MRP_UTIL.MRP_LOG (g_log_message);
3612: g_log_message := 'Line Reference :' || to_char(l_line_id);
3613: MRP_UTIL.MRP_LOG (g_log_message);
3614: END IF;
3615: ELSIF ( g_kanban_info_rec.input_type = 4) THEN

Line 3613: MRP_UTIL.MRP_LOG (g_log_message);

3609: MRP_UTIL.MRP_LOG (g_log_message);
3610: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3611: MRP_UTIL.MRP_LOG (g_log_message);
3612: g_log_message := 'Line Reference :' || to_char(l_line_id);
3613: MRP_UTIL.MRP_LOG (g_log_message);
3614: END IF;
3615: ELSIF ( g_kanban_info_rec.input_type = 4) THEN
3616: -- input is Actual Production (type = 4)
3617:

Line 3631: MRP_UTIL.MRP_LOG (g_log_message);

3627: EXIT WHEN GetActualProductionDemand%NOTFOUND;
3628:
3629: IF g_debug THEN
3630: g_log_message := 'Schedule Entry Details : ' ;
3631: MRP_UTIL.MRP_LOG (g_log_message);
3632: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3633: MRP_UTIL.MRP_LOG (g_log_message);
3634: g_log_message := 'Alternate : ' || l_alt_bom;
3635: MRP_UTIL.MRP_LOG (g_log_message);

Line 3633: MRP_UTIL.MRP_LOG (g_log_message);

3629: IF g_debug THEN
3630: g_log_message := 'Schedule Entry Details : ' ;
3631: MRP_UTIL.MRP_LOG (g_log_message);
3632: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3633: MRP_UTIL.MRP_LOG (g_log_message);
3634: g_log_message := 'Alternate : ' || l_alt_bom;
3635: MRP_UTIL.MRP_LOG (g_log_message);
3636: g_log_message := 'Line Reference :' || to_char(l_line_id);
3637: MRP_UTIL.MRP_LOG (g_log_message);

Line 3635: MRP_UTIL.MRP_LOG (g_log_message);

3631: MRP_UTIL.MRP_LOG (g_log_message);
3632: g_log_message := 'Item : ' || to_char(l_demand_rec.inventory_item_id) ;
3633: MRP_UTIL.MRP_LOG (g_log_message);
3634: g_log_message := 'Alternate : ' || l_alt_bom;
3635: MRP_UTIL.MRP_LOG (g_log_message);
3636: g_log_message := 'Line Reference :' || to_char(l_line_id);
3637: MRP_UTIL.MRP_LOG (g_log_message);
3638: END IF;
3639: END IF;

Line 3637: MRP_UTIL.MRP_LOG (g_log_message);

3633: MRP_UTIL.MRP_LOG (g_log_message);
3634: g_log_message := 'Alternate : ' || l_alt_bom;
3635: MRP_UTIL.MRP_LOG (g_log_message);
3636: g_log_message := 'Line Reference :' || to_char(l_line_id);
3637: MRP_UTIL.MRP_LOG (g_log_message);
3638: END IF;
3639: END IF;
3640:
3641: g_stmt_num := 160;

Line 3644: MRP_UTIL.MRP_LOG (g_log_message);

3640:
3641: g_stmt_num := 160;
3642: IF g_debug THEN
3643: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3644: MRP_UTIL.MRP_LOG (g_log_message);
3645: g_log_message := 'Calling Insert Demand function';
3646: MRP_UTIL.MRP_LOG (g_log_message);
3647: END IF;
3648:

Line 3646: MRP_UTIL.MRP_LOG (g_log_message);

3642: IF g_debug THEN
3643: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
3644: MRP_UTIL.MRP_LOG (g_log_message);
3645: g_log_message := 'Calling Insert Demand function';
3646: MRP_UTIL.MRP_LOG (g_log_message);
3647: END IF;
3648:
3649: -- call the function to insert demand and explode it through
3650: -- to the bottom of the bill

Line 3690: MRP_UTIL.MRP_LOG (g_log_message);

3686: --exception handling
3687: EXCEPTION
3688: WHEN OTHERS THEN
3689: g_log_message := 'RETRIEVE_KANBAN_DEMAND Sql Error ';
3690: MRP_UTIL.MRP_LOG (g_log_message);
3691: g_log_message := sqlerrm;
3692: MRP_UTIL.MRP_LOG (g_log_message);
3693: RETURN FALSE;
3694:

Line 3692: MRP_UTIL.MRP_LOG (g_log_message);

3688: WHEN OTHERS THEN
3689: g_log_message := 'RETRIEVE_KANBAN_DEMAND Sql Error ';
3690: MRP_UTIL.MRP_LOG (g_log_message);
3691: g_log_message := sqlerrm;
3692: MRP_UTIL.MRP_LOG (g_log_message);
3693: RETURN FALSE;
3694:
3695: END Retrieve_Kanban_Demand;
3696:

Line 3789: MRP_UTIL.MRP_LOG (g_log_message);

3785:
3786: Exception
3787: WHEN OTHERS THEN
3788: g_log_message := 'KANBAN_CALCULATION_PVT Sql Error ';
3789: MRP_UTIL.MRP_LOG (g_log_message);
3790: g_log_message := sqlerrm;
3791: MRP_UTIL.MRP_LOG (g_log_message);
3792: RETURN FALSE;
3793:

Line 3791: MRP_UTIL.MRP_LOG (g_log_message);

3787: WHEN OTHERS THEN
3788: g_log_message := 'KANBAN_CALCULATION_PVT Sql Error ';
3789: MRP_UTIL.MRP_LOG (g_log_message);
3790: g_log_message := sqlerrm;
3791: MRP_UTIL.MRP_LOG (g_log_message);
3792: RETURN FALSE;
3793:
3794: END Kanban_Calculation_Pvt;
3795:

Line 3893: MRP_UTIL.MRP_LOG (g_log_message);

3889:
3890: Exception
3891: WHEN OTHERS THEN
3892: g_log_message := 'KANBAN_CALCULATION_PVT Sql Error ';
3893: MRP_UTIL.MRP_LOG (g_log_message);
3894: g_log_message := sqlerrm;
3895: MRP_UTIL.MRP_LOG (g_log_message);
3896: RETURN FALSE;
3897:

Line 3895: MRP_UTIL.MRP_LOG (g_log_message);

3891: WHEN OTHERS THEN
3892: g_log_message := 'KANBAN_CALCULATION_PVT Sql Error ';
3893: MRP_UTIL.MRP_LOG (g_log_message);
3894: g_log_message := sqlerrm;
3895: MRP_UTIL.MRP_LOG (g_log_message);
3896: RETURN FALSE;
3897:
3898: END Kanban_Calculation_Pvt;
3899: -- ========================================================================

Line 3993: MRP_UTIL.MRP_LOG (g_log_message);

3989: BEGIN
3990:
3991: IF g_debug THEN
3992: g_log_message := 'Entering Calculate_Kanban_Quantity Function';
3993: MRP_UTIL.MRP_LOG (g_log_message);
3994: END IF;
3995:
3996: OPEN cur_kanban_demand;
3997:

Line 4007: MRP_UTIL.MRP_LOG (g_log_message);

4003: l_locator_id;
4004:
4005: IF g_debug THEN
4006: g_log_message := 'Item Id : ' || to_char (l_item_id);
4007: MRP_UTIL.MRP_LOG (g_log_message);
4008: g_log_message := 'SubInventory : ' || l_subinventory;
4009: MRP_UTIL.MRP_LOG (g_log_message);
4010: g_log_message := 'Locator : ' || to_char(l_locator_id);
4011: MRP_UTIL.MRP_LOG (g_log_message);

Line 4009: MRP_UTIL.MRP_LOG (g_log_message);

4005: IF g_debug THEN
4006: g_log_message := 'Item Id : ' || to_char (l_item_id);
4007: MRP_UTIL.MRP_LOG (g_log_message);
4008: g_log_message := 'SubInventory : ' || l_subinventory;
4009: MRP_UTIL.MRP_LOG (g_log_message);
4010: g_log_message := 'Locator : ' || to_char(l_locator_id);
4011: MRP_UTIL.MRP_LOG (g_log_message);
4012: END IF;
4013:

Line 4011: MRP_UTIL.MRP_LOG (g_log_message);

4007: MRP_UTIL.MRP_LOG (g_log_message);
4008: g_log_message := 'SubInventory : ' || l_subinventory;
4009: MRP_UTIL.MRP_LOG (g_log_message);
4010: g_log_message := 'Locator : ' || to_char(l_locator_id);
4011: MRP_UTIL.MRP_LOG (g_log_message);
4012: END IF;
4013:
4014:
4015: EXIT WHEN cur_kanban_demand%NOTFOUND;

Line 4082: MRP_UTIL.MRP_LOG (g_log_message);

4078: l_pull_sequence_rec.plan_end_date := g_kanban_info_rec.cutoff_date;
4079:
4080: IF g_debug THEN
4081: g_log_message := 'Calling Kanban Qty Calc API';
4082: MRP_UTIL.MRP_LOG (g_log_message);
4083: g_log_message := 'Parameters Passed to the Kanban Qty Calc API : ';
4084: MRP_UTIL.MRP_LOG (g_log_message);
4085: g_log_message := 'Pull Sequence :' || to_char (l_pull_sequence_rec.pull_sequence_id);
4086: MRP_UTIL.MRP_LOG (g_log_message);

Line 4084: MRP_UTIL.MRP_LOG (g_log_message);

4080: IF g_debug THEN
4081: g_log_message := 'Calling Kanban Qty Calc API';
4082: MRP_UTIL.MRP_LOG (g_log_message);
4083: g_log_message := 'Parameters Passed to the Kanban Qty Calc API : ';
4084: MRP_UTIL.MRP_LOG (g_log_message);
4085: g_log_message := 'Pull Sequence :' || to_char (l_pull_sequence_rec.pull_sequence_id);
4086: MRP_UTIL.MRP_LOG (g_log_message);
4087: g_log_message := 'Demand :' || to_char (l_average_demand);
4088: MRP_UTIL.MRP_LOG (g_log_message);

Line 4086: MRP_UTIL.MRP_LOG (g_log_message);

4082: MRP_UTIL.MRP_LOG (g_log_message);
4083: g_log_message := 'Parameters Passed to the Kanban Qty Calc API : ';
4084: MRP_UTIL.MRP_LOG (g_log_message);
4085: g_log_message := 'Pull Sequence :' || to_char (l_pull_sequence_rec.pull_sequence_id);
4086: MRP_UTIL.MRP_LOG (g_log_message);
4087: g_log_message := 'Demand :' || to_char (l_average_demand);
4088: MRP_UTIL.MRP_LOG (g_log_message);
4089: g_log_message := 'Min Order Qty :' || to_char (l_pull_sequence_rec.minimum_order_quantity);
4090: MRP_UTIL.MRP_LOG (g_log_message);

Line 4088: MRP_UTIL.MRP_LOG (g_log_message);

4084: MRP_UTIL.MRP_LOG (g_log_message);
4085: g_log_message := 'Pull Sequence :' || to_char (l_pull_sequence_rec.pull_sequence_id);
4086: MRP_UTIL.MRP_LOG (g_log_message);
4087: g_log_message := 'Demand :' || to_char (l_average_demand);
4088: MRP_UTIL.MRP_LOG (g_log_message);
4089: g_log_message := 'Min Order Qty :' || to_char (l_pull_sequence_rec.minimum_order_quantity);
4090: MRP_UTIL.MRP_LOG (g_log_message);
4091: g_log_message := 'Fixed Lot Multiplier : ' || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
4092: MRP_UTIL.MRP_LOG (g_log_message);

Line 4090: MRP_UTIL.MRP_LOG (g_log_message);

4086: MRP_UTIL.MRP_LOG (g_log_message);
4087: g_log_message := 'Demand :' || to_char (l_average_demand);
4088: MRP_UTIL.MRP_LOG (g_log_message);
4089: g_log_message := 'Min Order Qty :' || to_char (l_pull_sequence_rec.minimum_order_quantity);
4090: MRP_UTIL.MRP_LOG (g_log_message);
4091: g_log_message := 'Fixed Lot Multiplier : ' || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
4092: MRP_UTIL.MRP_LOG (g_log_message);
4093: g_log_message := 'Fixed Days Supply :' || to_char (l_pull_sequence_rec.safety_stock_days);
4094: MRP_UTIL.MRP_LOG (g_log_message);

Line 4092: MRP_UTIL.MRP_LOG (g_log_message);

4088: MRP_UTIL.MRP_LOG (g_log_message);
4089: g_log_message := 'Min Order Qty :' || to_char (l_pull_sequence_rec.minimum_order_quantity);
4090: MRP_UTIL.MRP_LOG (g_log_message);
4091: g_log_message := 'Fixed Lot Multiplier : ' || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
4092: MRP_UTIL.MRP_LOG (g_log_message);
4093: g_log_message := 'Fixed Days Supply :' || to_char (l_pull_sequence_rec.safety_stock_days);
4094: MRP_UTIL.MRP_LOG (g_log_message);
4095: g_log_message := 'Replenishment Lead Time :' || to_char (l_pull_sequence_rec.replenishment_lead_time);
4096: MRP_UTIL.MRP_LOG (g_log_message);

Line 4094: MRP_UTIL.MRP_LOG (g_log_message);

4090: MRP_UTIL.MRP_LOG (g_log_message);
4091: g_log_message := 'Fixed Lot Multiplier : ' || to_char (l_pull_sequence_rec.fixed_lot_multiplier);
4092: MRP_UTIL.MRP_LOG (g_log_message);
4093: g_log_message := 'Fixed Days Supply :' || to_char (l_pull_sequence_rec.safety_stock_days);
4094: MRP_UTIL.MRP_LOG (g_log_message);
4095: g_log_message := 'Replenishment Lead Time :' || to_char (l_pull_sequence_rec.replenishment_lead_time);
4096: MRP_UTIL.MRP_LOG (g_log_message);
4097: g_log_message := 'Calculate Kanban Flag :' || to_char (l_pull_sequence_rec.calculate_kanban_flag);
4098: MRP_UTIL.MRP_LOG (g_log_message);

Line 4096: MRP_UTIL.MRP_LOG (g_log_message);

4092: MRP_UTIL.MRP_LOG (g_log_message);
4093: g_log_message := 'Fixed Days Supply :' || to_char (l_pull_sequence_rec.safety_stock_days);
4094: MRP_UTIL.MRP_LOG (g_log_message);
4095: g_log_message := 'Replenishment Lead Time :' || to_char (l_pull_sequence_rec.replenishment_lead_time);
4096: MRP_UTIL.MRP_LOG (g_log_message);
4097: g_log_message := 'Calculate Kanban Flag :' || to_char (l_pull_sequence_rec.calculate_kanban_flag);
4098: MRP_UTIL.MRP_LOG (g_log_message);
4099: g_log_message := 'Kanban Size :' || to_char (l_pull_sequence_rec.kanban_size);
4100: MRP_UTIL.MRP_LOG (g_log_message);

Line 4098: MRP_UTIL.MRP_LOG (g_log_message);

4094: MRP_UTIL.MRP_LOG (g_log_message);
4095: g_log_message := 'Replenishment Lead Time :' || to_char (l_pull_sequence_rec.replenishment_lead_time);
4096: MRP_UTIL.MRP_LOG (g_log_message);
4097: g_log_message := 'Calculate Kanban Flag :' || to_char (l_pull_sequence_rec.calculate_kanban_flag);
4098: MRP_UTIL.MRP_LOG (g_log_message);
4099: g_log_message := 'Kanban Size :' || to_char (l_pull_sequence_rec.kanban_size);
4100: MRP_UTIL.MRP_LOG (g_log_message);
4101: g_log_message := 'Number of Cards :' || to_char (l_pull_sequence_rec.number_of_cards);
4102: MRP_UTIL.MRP_LOG (g_log_message);

Line 4100: MRP_UTIL.MRP_LOG (g_log_message);

4096: MRP_UTIL.MRP_LOG (g_log_message);
4097: g_log_message := 'Calculate Kanban Flag :' || to_char (l_pull_sequence_rec.calculate_kanban_flag);
4098: MRP_UTIL.MRP_LOG (g_log_message);
4099: g_log_message := 'Kanban Size :' || to_char (l_pull_sequence_rec.kanban_size);
4100: MRP_UTIL.MRP_LOG (g_log_message);
4101: g_log_message := 'Number of Cards :' || to_char (l_pull_sequence_rec.number_of_cards);
4102: MRP_UTIL.MRP_LOG (g_log_message);
4103: END IF;
4104:

Line 4102: MRP_UTIL.MRP_LOG (g_log_message);

4098: MRP_UTIL.MRP_LOG (g_log_message);
4099: g_log_message := 'Kanban Size :' || to_char (l_pull_sequence_rec.kanban_size);
4100: MRP_UTIL.MRP_LOG (g_log_message);
4101: g_log_message := 'Number of Cards :' || to_char (l_pull_sequence_rec.number_of_cards);
4102: MRP_UTIL.MRP_LOG (g_log_message);
4103: END IF;
4104:
4105: -- specify the version of the API we want to call
4106: l_api_version := 1.0;

Line 4126: MRP_UTIL.MRP_LOG (g_log_message);

4122:
4123: IF l_return_status <> 'S' THEN
4124: IF g_debug THEN
4125: g_log_message := 'Error in Kanban Quantity Calculation API';
4126: MRP_UTIL.MRP_LOG (g_log_message);
4127: END IF;
4128: RETURN FALSE;
4129: END IF;
4130:

Line 4149: MRP_UTIL.MRP_LOG (g_log_message);

4145: l_pull_sequence_rec.number_of_cards ) THEN
4146:
4147: IF g_debug THEN
4148: g_log_message := 'Error in Kanban Calculation function';
4149: MRP_UTIL.MRP_LOG (g_log_message);
4150: END IF;
4151: RETURN FALSE;
4152:
4153: END IF;

Line 4167: MRP_UTIL.MRP_LOG (g_log_message);

4163: l_pull_sequence_rec.number_of_cards ) THEN
4164:
4165: IF g_debug THEN
4166: g_log_message := 'Error in Kanban Calculation function';
4167: MRP_UTIL.MRP_LOG (g_log_message);
4168: END IF;
4169: RETURN FALSE;
4170:
4171: END IF;

Line 4210: MRP_UTIL.MRP_LOG (g_log_message);

4206:
4207: IF g_debug THEN
4208: g_log_message := 'Kanban Size after Calculation : '
4209: || to_char(l_pull_sequence_rec.kanban_size);
4210: MRP_UTIL.MRP_LOG (g_log_message);
4211: g_log_message := 'Kanban Number after Calculation : '
4212: || to_char(l_pull_sequence_rec.number_of_cards);
4213: MRP_UTIL.MRP_LOG (g_log_message);
4214: END IF;

Line 4213: MRP_UTIL.MRP_LOG (g_log_message);

4209: || to_char(l_pull_sequence_rec.kanban_size);
4210: MRP_UTIL.MRP_LOG (g_log_message);
4211: g_log_message := 'Kanban Number after Calculation : '
4212: || to_char(l_pull_sequence_rec.number_of_cards);
4213: MRP_UTIL.MRP_LOG (g_log_message);
4214: END IF;
4215: l_pull_sequence_rec.future_card_size := l_pull_sequence_rec.kanban_size;
4216: l_pull_sequence_rec.future_no_of_cards := l_pull_sequence_rec.number_of_cards;
4217: -- call the inventory api for inserting into mtl_pull_sequences

Line 4234: MRP_UTIL.MRP_LOG (g_log_message);

4230:
4231: IF l_return_status <> 'S' THEN
4232: IF g_debug THEN
4233: g_log_message := 'Error in Inventory Insert/Update API';
4234: MRP_UTIL.MRP_LOG (g_log_message);
4235: g_log_message := 'Return Code : ' || l_return_status;
4236: MRP_UTIL.MRP_LOG (g_log_message);
4237: END IF;
4238: RETURN FALSE;

Line 4236: MRP_UTIL.MRP_LOG (g_log_message);

4232: IF g_debug THEN
4233: g_log_message := 'Error in Inventory Insert/Update API';
4234: MRP_UTIL.MRP_LOG (g_log_message);
4235: g_log_message := 'Return Code : ' || l_return_status;
4236: MRP_UTIL.MRP_LOG (g_log_message);
4237: END IF;
4238: RETURN FALSE;
4239: END IF;
4240:

Line 4256: MRP_UTIL.MRP_LOG (g_log_message);

4252: --exception handling
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: g_log_message := 'CALCULATE_KANBAN_QUANTITY Sql Error ';
4256: MRP_UTIL.MRP_LOG (g_log_message);
4257: g_log_message := sqlerrm;
4258: MRP_UTIL.MRP_LOG (g_log_message);
4259: RETURN FALSE;
4260:

Line 4258: MRP_UTIL.MRP_LOG (g_log_message);

4254: WHEN OTHERS THEN
4255: g_log_message := 'CALCULATE_KANBAN_QUANTITY Sql Error ';
4256: MRP_UTIL.MRP_LOG (g_log_message);
4257: g_log_message := sqlerrm;
4258: MRP_UTIL.MRP_LOG (g_log_message);
4259: RETURN FALSE;
4260:
4261: END Calculate_Kanban_Quantity;
4262:

Line 4313: MRP_UTIL.MRP_LOG (g_log_message);

4309:
4310: g_stmt_num := 10;
4311: IF g_debug THEN
4312: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
4313: MRP_UTIL.MRP_LOG (g_log_message);
4314: END IF;
4315:
4316: -- check for mandatory parameters
4317: -- and issue appropriate error messages

Line 4335: MRP_UTIL.MRP_LOG (g_log_message);

4331:
4332: IF p_organization_id IS NULL OR p_kanban_plan_id IS NULL OR
4333: ((p_bom_effectivity IS NULL OR p_cutoff_date IS NULL) AND
4334: p_replan_flag = 2) THEN
4335: MRP_UTIL.MRP_LOG (g_log_message);
4336: raise exc_error_condition;
4337: END IF;
4338:
4339: -- get all the parameters passed to this concurrent program into

Line 4359: MRP_UTIL.MRP_LOG (g_log_message);

4355: g_kanban_info_rec.replan_flag := p_replan_flag;
4356:
4357: IF g_debug THEN
4358: g_log_message := 'Parameters passed to the program :';
4359: MRP_UTIL.MRP_LOG (g_log_message);
4360: g_log_message := 'organization_id : ' || p_organization_id;
4361: MRP_UTIL.MRP_LOG (g_log_message);
4362: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
4363: MRP_UTIL.MRP_LOG (g_log_message);

Line 4361: MRP_UTIL.MRP_LOG (g_log_message);

4357: IF g_debug THEN
4358: g_log_message := 'Parameters passed to the program :';
4359: MRP_UTIL.MRP_LOG (g_log_message);
4360: g_log_message := 'organization_id : ' || p_organization_id;
4361: MRP_UTIL.MRP_LOG (g_log_message);
4362: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
4363: MRP_UTIL.MRP_LOG (g_log_message);
4364: g_log_message := 'from_item_id : ' || p_from_item;
4365: MRP_UTIL.MRP_LOG (g_log_message);

Line 4363: MRP_UTIL.MRP_LOG (g_log_message);

4359: MRP_UTIL.MRP_LOG (g_log_message);
4360: g_log_message := 'organization_id : ' || p_organization_id;
4361: MRP_UTIL.MRP_LOG (g_log_message);
4362: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
4363: MRP_UTIL.MRP_LOG (g_log_message);
4364: g_log_message := 'from_item_id : ' || p_from_item;
4365: MRP_UTIL.MRP_LOG (g_log_message);
4366: g_log_message := 'to_item_id : ' || p_to_item;
4367: MRP_UTIL.MRP_LOG (g_log_message);

Line 4365: MRP_UTIL.MRP_LOG (g_log_message);

4361: MRP_UTIL.MRP_LOG (g_log_message);
4362: g_log_message := 'kanban_plan_id : ' || p_kanban_plan_id;
4363: MRP_UTIL.MRP_LOG (g_log_message);
4364: g_log_message := 'from_item_id : ' || p_from_item;
4365: MRP_UTIL.MRP_LOG (g_log_message);
4366: g_log_message := 'to_item_id : ' || p_to_item;
4367: MRP_UTIL.MRP_LOG (g_log_message);
4368: g_log_message := 'category_set_id : ' || p_category_set_id;
4369: MRP_UTIL.MRP_LOG (g_log_message);

Line 4367: MRP_UTIL.MRP_LOG (g_log_message);

4363: MRP_UTIL.MRP_LOG (g_log_message);
4364: g_log_message := 'from_item_id : ' || p_from_item;
4365: MRP_UTIL.MRP_LOG (g_log_message);
4366: g_log_message := 'to_item_id : ' || p_to_item;
4367: MRP_UTIL.MRP_LOG (g_log_message);
4368: g_log_message := 'category_set_id : ' || p_category_set_id;
4369: MRP_UTIL.MRP_LOG (g_log_message);
4370: g_log_message := 'category_structure_id : ' || p_category_structure_id;
4371: MRP_UTIL.MRP_LOG (g_log_message);

Line 4369: MRP_UTIL.MRP_LOG (g_log_message);

4365: MRP_UTIL.MRP_LOG (g_log_message);
4366: g_log_message := 'to_item_id : ' || p_to_item;
4367: MRP_UTIL.MRP_LOG (g_log_message);
4368: g_log_message := 'category_set_id : ' || p_category_set_id;
4369: MRP_UTIL.MRP_LOG (g_log_message);
4370: g_log_message := 'category_structure_id : ' || p_category_structure_id;
4371: MRP_UTIL.MRP_LOG (g_log_message);
4372: g_log_message := 'from_category_id : ' || p_from_category;
4373: MRP_UTIL.MRP_LOG (g_log_message);

Line 4371: MRP_UTIL.MRP_LOG (g_log_message);

4367: MRP_UTIL.MRP_LOG (g_log_message);
4368: g_log_message := 'category_set_id : ' || p_category_set_id;
4369: MRP_UTIL.MRP_LOG (g_log_message);
4370: g_log_message := 'category_structure_id : ' || p_category_structure_id;
4371: MRP_UTIL.MRP_LOG (g_log_message);
4372: g_log_message := 'from_category_id : ' || p_from_category;
4373: MRP_UTIL.MRP_LOG (g_log_message);
4374: g_log_message := 'to_category_id : ' || p_to_category;
4375: MRP_UTIL.MRP_LOG (g_log_message);

Line 4373: MRP_UTIL.MRP_LOG (g_log_message);

4369: MRP_UTIL.MRP_LOG (g_log_message);
4370: g_log_message := 'category_structure_id : ' || p_category_structure_id;
4371: MRP_UTIL.MRP_LOG (g_log_message);
4372: g_log_message := 'from_category_id : ' || p_from_category;
4373: MRP_UTIL.MRP_LOG (g_log_message);
4374: g_log_message := 'to_category_id : ' || p_to_category;
4375: MRP_UTIL.MRP_LOG (g_log_message);
4376: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
4377: MRP_UTIL.MRP_LOG (g_log_message);

Line 4375: MRP_UTIL.MRP_LOG (g_log_message);

4371: MRP_UTIL.MRP_LOG (g_log_message);
4372: g_log_message := 'from_category_id : ' || p_from_category;
4373: MRP_UTIL.MRP_LOG (g_log_message);
4374: g_log_message := 'to_category_id : ' || p_to_category;
4375: MRP_UTIL.MRP_LOG (g_log_message);
4376: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
4377: MRP_UTIL.MRP_LOG (g_log_message);
4378: g_log_message := 'start_date : ' || p_start_date;
4379: MRP_UTIL.MRP_LOG (g_log_message);

Line 4377: MRP_UTIL.MRP_LOG (g_log_message);

4373: MRP_UTIL.MRP_LOG (g_log_message);
4374: g_log_message := 'to_category_id : ' || p_to_category;
4375: MRP_UTIL.MRP_LOG (g_log_message);
4376: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
4377: MRP_UTIL.MRP_LOG (g_log_message);
4378: g_log_message := 'start_date : ' || p_start_date;
4379: MRP_UTIL.MRP_LOG (g_log_message);
4380: g_log_message := 'cutoff_date : ' || p_cutoff_date;
4381: MRP_UTIL.MRP_LOG (g_log_message);

Line 4379: MRP_UTIL.MRP_LOG (g_log_message);

4375: MRP_UTIL.MRP_LOG (g_log_message);
4376: g_log_message := 'bom_effectivity : ' || p_bom_effectivity;
4377: MRP_UTIL.MRP_LOG (g_log_message);
4378: g_log_message := 'start_date : ' || p_start_date;
4379: MRP_UTIL.MRP_LOG (g_log_message);
4380: g_log_message := 'cutoff_date : ' || p_cutoff_date;
4381: MRP_UTIL.MRP_LOG (g_log_message);
4382: g_log_message := 'replan_flag : ' || p_replan_flag;
4383: MRP_UTIL.MRP_LOG (g_log_message);

Line 4381: MRP_UTIL.MRP_LOG (g_log_message);

4377: MRP_UTIL.MRP_LOG (g_log_message);
4378: g_log_message := 'start_date : ' || p_start_date;
4379: MRP_UTIL.MRP_LOG (g_log_message);
4380: g_log_message := 'cutoff_date : ' || p_cutoff_date;
4381: MRP_UTIL.MRP_LOG (g_log_message);
4382: g_log_message := 'replan_flag : ' || p_replan_flag;
4383: MRP_UTIL.MRP_LOG (g_log_message);
4384: END IF;
4385:

Line 4383: MRP_UTIL.MRP_LOG (g_log_message);

4379: MRP_UTIL.MRP_LOG (g_log_message);
4380: g_log_message := 'cutoff_date : ' || p_cutoff_date;
4381: MRP_UTIL.MRP_LOG (g_log_message);
4382: g_log_message := 'replan_flag : ' || p_replan_flag;
4383: MRP_UTIL.MRP_LOG (g_log_message);
4384: END IF;
4385:
4386: -- call the start_kanban function
4387: IF NOT Start_Kanban_Plan THEN

Line 4389: MRP_UTIL.MRP_LOG (g_log_message);

4385:
4386: -- call the start_kanban function
4387: IF NOT Start_Kanban_Plan THEN
4388: g_log_message := 'Error in START_KANBAN_PLAN';
4389: MRP_UTIL.MRP_LOG (g_log_message);
4390: raise exc_error_condition;
4391: END IF;
4392:
4393: /*

Line 4407: MRP_UTIL.MRP_LOG (g_log_message);

4403: -- and then blow it down to the component item/locations
4404:
4405: IF NOT mrp_kanban_snapshot_pk.snapshot_item_locations THEN
4406: g_log_message := 'Error in SNAPSHOT_ITEM_LOCATIONS';
4407: MRP_UTIL.MRP_LOG (g_log_message);
4408: raise exc_error_condition;
4409: END IF;
4410: */
4411: g_stmt_num := 150;

Line 4414: MRP_UTIL.MRP_LOG (g_log_message);

4410: */
4411: g_stmt_num := 150;
4412: IF g_debug THEN
4413: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
4414: MRP_UTIL.MRP_LOG (g_log_message);
4415: END IF;
4416:
4417: -- now call the procedure to retrieve the kanban demand based on
4418: -- the input to the kanban plan and pass it down to the components

Line 4423: MRP_UTIL.MRP_LOG (g_log_message);

4419: -- as in the mrp_low_level_codes table
4420:
4421: IF NOT Retrieve_Kanban_Demand THEN
4422: g_log_message := 'Error in RETRIEVE_KANBAN_DEMAND';
4423: MRP_UTIL.MRP_LOG (g_log_message);
4424: raise exc_error_condition;
4425: END IF;
4426:
4427: -- We now have all the demand for this plan run stored in the

Line 4448: MRP_UTIL.MRP_LOG (g_log_message);

4444:
4445: g_stmt_num := 180;
4446: IF g_debug THEN
4447: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
4448: MRP_UTIL.MRP_LOG (g_log_message);
4449: END IF;
4450:
4451: IF NOT (Calculate_Kanban_Quantity (l_total_workdays)) THEN
4452: g_log_message := 'Error in CALCULATE_KANBAN_QUANTITY';

Line 4453: MRP_UTIL.MRP_LOG (g_log_message);

4449: END IF;
4450:
4451: IF NOT (Calculate_Kanban_Quantity (l_total_workdays)) THEN
4452: g_log_message := 'Error in CALCULATE_KANBAN_QUANTITY';
4453: MRP_UTIL.MRP_LOG (g_log_message);
4454: raise exc_error_condition;
4455: END IF;
4456:
4457: g_stmt_num := 190;

Line 4460: MRP_UTIL.MRP_LOG (g_log_message);

4456:
4457: g_stmt_num := 190;
4458: IF g_debug THEN
4459: g_log_message := 'Debug Statement Number : ' || to_char (g_stmt_num);
4460: MRP_UTIL.MRP_LOG (g_log_message);
4461: END IF;
4462:
4463: -- if we come here then we are done with the planning and we can
4464: -- update the plan_completion_date

Line 4470: MRP_UTIL.MRP_LOG (g_log_message);

4466: l_ret_val := End_Kanban_Plan;
4467:
4468: IF NOT l_ret_val THEN
4469: g_log_message := 'Error in END_KANBAN_PLAN';
4470: MRP_UTIL.MRP_LOG (g_log_message);
4471: raise exc_error_condition;
4472: END IF;
4473:
4474: IF g_raise_warning THEN

Line 4492: MRP_UTIL.MRP_LOG (g_log_message);

4488: ROLLBACK;
4489: RETCODE := G_ERROR;
4490: ERRBUF := 'Program Completed with Error : ' || sqlerrm;
4491: g_log_message := 'Program encountered Error condition Exception';
4492: MRP_UTIL.MRP_LOG (g_log_message);
4493:
4494: WHEN OTHERS THEN
4495: ROLLBACK;
4496: RETCODE := G_ERROR;

Line 4499: MRP_UTIL.MRP_LOG (g_log_message);

4495: ROLLBACK;
4496: RETCODE := G_ERROR;
4497: ERRBUF := 'Program Completed with Error : ' || sqlerrm;
4498: g_log_message := 'PLAN_KANBAN Sql Error ';
4499: MRP_UTIL.MRP_LOG (g_log_message);
4500: g_log_message := sqlerrm;
4501: MRP_UTIL.MRP_LOG (g_log_message);
4502:
4503:

Line 4501: MRP_UTIL.MRP_LOG (g_log_message);

4497: ERRBUF := 'Program Completed with Error : ' || sqlerrm;
4498: g_log_message := 'PLAN_KANBAN Sql Error ';
4499: MRP_UTIL.MRP_LOG (g_log_message);
4500: g_log_message := sqlerrm;
4501: MRP_UTIL.MRP_LOG (g_log_message);
4502:
4503:
4504: END PLAN_KANBAN;
4505: