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_SNAPSHOT_PK dependencies on MRP_KANBAN_PLAN_PK

Line 19: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

15: -- only if debug is turned on.
16: CURSOR cur_debug is
17: SELECT distinct msi.concatenated_segments
18: FROM mtl_system_items_kfv msi, mrp_low_level_codes mllc
19: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
20: AND mllc.organization_id =
21: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
22: AND mllc.from_subinventory IS NULL
23: AND mllc.from_locator_id IS NULL

Line 21: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

17: SELECT distinct msi.concatenated_segments
18: FROM mtl_system_items_kfv msi, mrp_low_level_codes mllc
19: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
20: AND mllc.organization_id =
21: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
22: AND mllc.from_subinventory IS NULL
23: AND mllc.from_locator_id IS NULL
24: AND mllc.kanban_item_flag = 'Y'
25: AND mllc.assembly_item_id <> mllc.component_item_id

Line 32: mrp_kanban_plan_pk.g_stmt_num := 120;

28:
29:
30: BEGIN
31:
32: mrp_kanban_plan_pk.g_stmt_num := 120;
33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 33: IF mrp_kanban_plan_pk.g_debug THEN

29:
30: BEGIN
31:
32: mrp_kanban_plan_pk.g_stmt_num := 120;
33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';

Line 34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

30: BEGIN
31:
32: mrp_kanban_plan_pk.g_stmt_num := 120;
33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 35: || to_char (mrp_kanban_plan_pk.g_stmt_num);

31:
32: mrp_kanban_plan_pk.g_stmt_num := 120;
33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
39: END IF;

Line 36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

32: mrp_kanban_plan_pk.g_stmt_num := 120;
33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
39: END IF;
40:

Line 37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';

33: IF mrp_kanban_plan_pk.g_debug THEN
34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
39: END IF;
40:
41:

Line 38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

34: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
35: || to_char (mrp_kanban_plan_pk.g_stmt_num);
36: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
37: mrp_kanban_plan_pk.g_log_message := 'Entering Check_Item_Locations Procedure';
38: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
39: END IF;
40:
41:
42: -- first check if any of the kanban items have null locations

Line 46: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

42: -- first check if any of the kanban items have null locations
43: SELECT count(*)
44: INTO l_count
45: FROM mrp_low_level_codes
46: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
47: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
48: AND from_subinventory IS NULL
49: AND from_locator_id IS NULL
50: AND kanban_item_flag = 'Y'

Line 47: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

43: SELECT count(*)
44: INTO l_count
45: FROM mrp_low_level_codes
46: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
47: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
48: AND from_subinventory IS NULL
49: AND from_locator_id IS NULL
50: AND kanban_item_flag = 'Y'
51: AND assembly_item_id <> component_item_id;

Line 68: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

64: FROM bom_inventory_backflush_subinv bibs
65: AND bibs.inventory_item_id = mllc.component_item_id
66: AND bibs.organization_id = mllc.organization_id
67: AND bibs.location_type = 1) -- ??
68: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
69: AND mllc.organization_id =
70: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
71: AND mllc.from_subinventory IS NULL
72: AND mllc.from_locator_id IS NULL

Line 70: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

66: AND bibs.organization_id = mllc.organization_id
67: AND bibs.location_type = 1) -- ??
68: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
69: AND mllc.organization_id =
70: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
71: AND mllc.from_subinventory IS NULL
72: AND mllc.from_locator_id IS NULL
73: AND mllc.kanban_item_flag = 'Y'
74: AND mllc.assembly_item_id <> mllc.component_item_id;

Line 83: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

79: -- now check again to see if we have any kanban items with null locations
80: SELECT count(*)
81: INTO l_count
82: FROM mrp_low_level_codes
83: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
84: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
85: AND from_subinventory IS NULL
86: AND from_locator_id IS NULL
87: AND kanban_item_flag = 'Y'

Line 84: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

80: SELECT count(*)
81: INTO l_count
82: FROM mrp_low_level_codes
83: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
84: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
85: AND from_subinventory IS NULL
86: AND from_locator_id IS NULL
87: AND kanban_item_flag = 'Y'
88: AND assembly_item_id <> component_item_id;

Line 105: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

101: FROM mtl_system_items msi
102: WHERE msi.organization_id = mllc.organization_id
103: AND msi.inventory_item_id = mllc.component_item_id)
104: WHERE mllc.plan_id =
105: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
106: AND mllc.organization_id =
107: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
108: AND mllc.from_subinventory IS NULL
109: AND mllc.from_locator_id IS NULL

Line 107: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

103: AND msi.inventory_item_id = mllc.component_item_id)
104: WHERE mllc.plan_id =
105: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
106: AND mllc.organization_id =
107: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
108: AND mllc.from_subinventory IS NULL
109: AND mllc.from_locator_id IS NULL
110: AND mllc.kanban_item_flag = 'Y'
111: AND mllc.assembly_item_id <> mllc.component_item_id;

Line 120: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

116: -- location information. If so error out
117: SELECT count(*)
118: INTO l_count
119: FROM mrp_low_level_codes
120: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
121: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
122: AND from_subinventory IS NULL
123: AND from_locator_id IS NULL
124: AND kanban_item_flag = 'Y'

Line 121: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

117: SELECT count(*)
118: INTO l_count
119: FROM mrp_low_level_codes
120: WHERE plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
121: AND organization_id = mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
122: AND from_subinventory IS NULL
123: AND from_locator_id IS NULL
124: AND kanban_item_flag = 'Y'
125: AND assembly_item_id <> component_item_id;

Line 128: IF mrp_kanban_plan_pk.g_debug THEN

124: AND kanban_item_flag = 'Y'
125: AND assembly_item_id <> component_item_id;
126:
127: IF l_count > 0 THEN
128: IF mrp_kanban_plan_pk.g_debug THEN
129: mrp_kanban_plan_pk.g_log_message := 'End of CHECK_ITEM_LOCATIONS function';
130: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
131: END IF;
132:

Line 129: mrp_kanban_plan_pk.g_log_message := 'End of CHECK_ITEM_LOCATIONS function';

125: AND assembly_item_id <> component_item_id;
126:
127: IF l_count > 0 THEN
128: IF mrp_kanban_plan_pk.g_debug THEN
129: mrp_kanban_plan_pk.g_log_message := 'End of CHECK_ITEM_LOCATIONS function';
130: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
131: END IF;
132:
133: l_count := 0;

Line 130: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

126:
127: IF l_count > 0 THEN
128: IF mrp_kanban_plan_pk.g_debug THEN
129: mrp_kanban_plan_pk.g_log_message := 'End of CHECK_ITEM_LOCATIONS function';
130: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
131: END IF;
132:
133: l_count := 0;
134: OPEN cur_debug;

Line 142: IF mrp_kanban_plan_pk.g_debug THEN

138: FETCH cur_debug INTO l_item;
139:
140: EXIT WHEN cur_debug%NOTFOUND;
141:
142: IF mrp_kanban_plan_pk.g_debug THEN
143: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_ITEM_INCOMP_LOC');
144: FND_MESSAGE.SET_TOKEN ('ITEMNAME', l_item);
145: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
146: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 145: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

141:
142: IF mrp_kanban_plan_pk.g_debug THEN
143: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_ITEM_INCOMP_LOC');
144: FND_MESSAGE.SET_TOKEN ('ITEMNAME', l_item);
145: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
146: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
147: END IF;
148:
149: l_count := l_count + 1;

Line 146: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

142: IF mrp_kanban_plan_pk.g_debug THEN
143: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_ITEM_INCOMP_LOC');
144: FND_MESSAGE.SET_TOKEN ('ITEMNAME', l_item);
145: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
146: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
147: END IF;
148:
149: l_count := l_count + 1;
150:

Line 153: IF mrp_kanban_plan_pk.g_debug THEN

149: l_count := l_count + 1;
150:
151: END LOOP;
152:
153: IF mrp_kanban_plan_pk.g_debug THEN
154: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_INCOMP_LOC');
155: FND_MESSAGE.SET_TOKEN ('NUMITEMS', to_char(l_count));
156: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 156: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

152:
153: IF mrp_kanban_plan_pk.g_debug THEN
154: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_INCOMP_LOC');
155: FND_MESSAGE.SET_TOKEN ('NUMITEMS', to_char(l_count));
156: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
158: END IF;
159:
160: --set the flag to return warning here

Line 157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

153: IF mrp_kanban_plan_pk.g_debug THEN
154: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_INCOMP_LOC');
155: FND_MESSAGE.SET_TOKEN ('NUMITEMS', to_char(l_count));
156: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
158: END IF;
159:
160: --set the flag to return warning here
161: MRP_KANBAN_PLAN_PK.g_raise_warning := TRUE;

Line 161: MRP_KANBAN_PLAN_PK.g_raise_warning := TRUE;

157: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
158: END IF;
159:
160: --set the flag to return warning here
161: MRP_KANBAN_PLAN_PK.g_raise_warning := TRUE;
162:
163: END IF;
164:
165: RETURN TRUE;

Line 171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';

167: --Exception handling
168: EXCEPTION
169:
170: WHEN OTHERS THEN
171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';
172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
173: mrp_kanban_plan_pk.g_log_message := sqlerrm;
174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
175: RETURN FALSE;

Line 172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

168: EXCEPTION
169:
170: WHEN OTHERS THEN
171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';
172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
173: mrp_kanban_plan_pk.g_log_message := sqlerrm;
174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
175: RETURN FALSE;
176:

Line 173: mrp_kanban_plan_pk.g_log_message := sqlerrm;

169:
170: WHEN OTHERS THEN
171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';
172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
173: mrp_kanban_plan_pk.g_log_message := sqlerrm;
174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
175: RETURN FALSE;
176:
177: END CHECK_ITEM_LOCATIONS;

Line 174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

170: WHEN OTHERS THEN
171: mrp_kanban_plan_pk.g_log_message := 'CHECK_ITEM_LOCATIONS Sql Error ';
172: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
173: mrp_kanban_plan_pk.g_log_message := sqlerrm;
174: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
175: RETURN FALSE;
176:
177: END CHECK_ITEM_LOCATIONS;
178:

Line 214: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

210: mtl_item_locations child_loc,
211: mtl_system_items_kfv parent,
212: mtl_system_items_kfv child,
213: mrp_low_level_codes mllc
214: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
215: AND mllc.organization_id =
216: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
217: AND mllc.low_level_code IS NULL
218: AND parent.inventory_item_id = mllc.assembly_item_id

Line 216: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

212: mtl_system_items_kfv child,
213: mrp_low_level_codes mllc
214: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
215: AND mllc.organization_id =
216: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
217: AND mllc.low_level_code IS NULL
218: AND parent.inventory_item_id = mllc.assembly_item_id
219: AND parent.organization_id = mllc.organization_id
220: AND child.inventory_item_id = mllc.component_item_id

Line 232: IF mrp_kanban_plan_pk.g_debug THEN

228: component_item;
229:
230: BEGIN
231:
232: IF mrp_kanban_plan_pk.g_debug THEN
233: mrp_kanban_plan_pk.g_log_message := 'In Check_For_Loops Procedure';
234: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);
235: END IF;
236:

Line 233: mrp_kanban_plan_pk.g_log_message := 'In Check_For_Loops Procedure';

229:
230: BEGIN
231:
232: IF mrp_kanban_plan_pk.g_debug THEN
233: mrp_kanban_plan_pk.g_log_message := 'In Check_For_Loops Procedure';
234: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);
235: END IF;
236:
237: -- We just go and check if we have assigned a low level code value

Line 234: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);

230: BEGIN
231:
232: IF mrp_kanban_plan_pk.g_debug THEN
233: mrp_kanban_plan_pk.g_log_message := 'In Check_For_Loops Procedure';
234: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);
235: END IF;
236:
237: -- We just go and check if we have assigned a low level code value
238: -- to every entry for the current plan. If we have at least one

Line 261: IF mrp_kanban_plan_pk.g_debug THEN

257:
258: l_loop_found := TRUE;
259:
260: IF not l_logged_loop_err_msg THEN
261: IF mrp_kanban_plan_pk.g_debug THEN
262: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_ERROR');
263: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:

Line 263: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

259:
260: IF not l_logged_loop_err_msg THEN
261: IF mrp_kanban_plan_pk.g_debug THEN
262: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_ERROR');
263: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:
266: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_START');
267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

Line 264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

260: IF not l_logged_loop_err_msg THEN
261: IF mrp_kanban_plan_pk.g_debug THEN
262: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_ERROR');
263: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:
266: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_START');
267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

263: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:
266: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_START');
267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
269: END IF;
270:
271: l_logged_loop_err_msg := TRUE;

Line 268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

264: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
265:
266: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_START');
267: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
268: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
269: END IF;
270:
271: l_logged_loop_err_msg := TRUE;
272:

Line 277: IF mrp_kanban_plan_pk.g_debug THEN

273: END IF;
274:
275: -- now go ahead and log messages giving details of the loop found
276:
277: IF mrp_kanban_plan_pk.g_debug THEN
278: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO');
279: FND_MESSAGE.SET_TOKEN ('PARENT_ITEM', l_parent_item);
280: FND_MESSAGE.SET_TOKEN ('PARENT_SUB', l_to_subinventory);
281: FND_MESSAGE.SET_TOKEN ('PARENT_LOC', to_char(l_parent_loc));

Line 285: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

281: FND_MESSAGE.SET_TOKEN ('PARENT_LOC', to_char(l_parent_loc));
282: FND_MESSAGE.SET_TOKEN ('CHILD_ITEM', l_child_item);
283: FND_MESSAGE.SET_TOKEN ('CHILD_SUB', l_from_subinventory);
284: FND_MESSAGE.SET_TOKEN ('CHILD_LOC', to_char(l_child_loc));
285: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
286: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
287: END IF;
288:
289: END LOOP;

Line 286: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

282: FND_MESSAGE.SET_TOKEN ('CHILD_ITEM', l_child_item);
283: FND_MESSAGE.SET_TOKEN ('CHILD_SUB', l_from_subinventory);
284: FND_MESSAGE.SET_TOKEN ('CHILD_LOC', to_char(l_child_loc));
285: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
286: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
287: END IF;
288:
289: END LOOP;
290:

Line 295: IF mrp_kanban_plan_pk.g_debug THEN

291: CLOSE cur_loop_check;
292:
293: IF l_loop_found THEN
294:
295: IF mrp_kanban_plan_pk.g_debug THEN
296: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_END');
297: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
298: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
299: END IF;

Line 297: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;

293: IF l_loop_found THEN
294:
295: IF mrp_kanban_plan_pk.g_debug THEN
296: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_END');
297: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
298: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
299: END IF;
300:
301: raise exc_loop_error;

Line 298: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

294:
295: IF mrp_kanban_plan_pk.g_debug THEN
296: FND_MESSAGE.SET_NAME ('MRP','MRP_KANBAN_LOOP_INFO_END');
297: mrp_kanban_plan_pk.g_log_message := FND_MESSAGE.GET;
298: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
299: END IF;
300:
301: raise exc_loop_error;
302: END IF;

Line 311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';

307: WHEN exc_loop_error THEN
308: RETURN FALSE;
309:
310: WHEN OTHERS THEN
311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';
312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
313: mrp_kanban_plan_pk.g_log_message := sqlerrm;
314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
315: RETURN FALSE;

Line 312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

308: RETURN FALSE;
309:
310: WHEN OTHERS THEN
311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';
312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
313: mrp_kanban_plan_pk.g_log_message := sqlerrm;
314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
315: RETURN FALSE;
316:

Line 313: mrp_kanban_plan_pk.g_log_message := sqlerrm;

309:
310: WHEN OTHERS THEN
311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';
312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
313: mrp_kanban_plan_pk.g_log_message := sqlerrm;
314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
315: RETURN FALSE;
316:
317:

Line 314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

310: WHEN OTHERS THEN
311: mrp_kanban_plan_pk.g_log_message := 'CHECK_FOR_LOOPS Sql Error ';
312: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
313: mrp_kanban_plan_pk.g_log_message := sqlerrm;
314: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
315: RETURN FALSE;
316:
317:
318: END CHECK_FOR_LOOPS;

Line 331: IF mrp_kanban_plan_pk.g_debug THEN

327: l_low_level_code number;
328:
329: BEGIN
330:
331: IF mrp_kanban_plan_pk.g_debug THEN
332: mrp_kanban_plan_pk.g_log_message := 'In Calc_Low_Level_Codes Procedure';
333: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);
334: END IF;
335:

Line 332: mrp_kanban_plan_pk.g_log_message := 'In Calc_Low_Level_Codes Procedure';

328:
329: BEGIN
330:
331: IF mrp_kanban_plan_pk.g_debug THEN
332: mrp_kanban_plan_pk.g_log_message := 'In Calc_Low_Level_Codes Procedure';
333: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);
334: END IF;
335:
336: -- start calculating the low level codes

Line 333: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);

329: BEGIN
330:
331: IF mrp_kanban_plan_pk.g_debug THEN
332: mrp_kanban_plan_pk.g_log_message := 'In Calc_Low_Level_Codes Procedure';
333: fnd_file.put_line (fnd_file.log, mrp_kanban_plan_pk.g_log_message);
334: END IF;
335:
336: -- start calculating the low level codes
337: -- we start by assigning a low_level_code of 1000 to the lowest level

Line 349: WHERE mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

345: WHILE TRUE LOOP
346:
347: UPDATE mrp_low_level_codes mllc1
348: SET mllc1.low_level_code = l_low_level_code
349: WHERE mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
350: AND mllc1.organization_id =
351: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
352: AND mllc1.low_level_code IS NULL
353: AND NOT EXISTS

Line 351: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

347: UPDATE mrp_low_level_codes mllc1
348: SET mllc1.low_level_code = l_low_level_code
349: WHERE mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
350: AND mllc1.organization_id =
351: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
352: AND mllc1.low_level_code IS NULL
353: AND NOT EXISTS
354: (SELECT /*+index(mllc2 MRP_LOW_LEVEL_CODES_N1)*/ 'Exists as parent' /* Bug 4608294 - added hint*/
355: FROM mrp_low_level_codes mllc2

Line 380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';

376:
377: -- exception handling
378: EXCEPTION
379: WHEN OTHERS THEN
380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';
381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
382: mrp_kanban_plan_pk.g_log_message := sqlerrm;
383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
384: RETURN FALSE;

Line 381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

377: -- exception handling
378: EXCEPTION
379: WHEN OTHERS THEN
380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';
381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
382: mrp_kanban_plan_pk.g_log_message := sqlerrm;
383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
384: RETURN FALSE;
385:

Line 382: mrp_kanban_plan_pk.g_log_message := sqlerrm;

378: EXCEPTION
379: WHEN OTHERS THEN
380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';
381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
382: mrp_kanban_plan_pk.g_log_message := sqlerrm;
383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
384: RETURN FALSE;
385:
386: END CALC_LOW_LEVEL_CODE;

Line 383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

379: WHEN OTHERS THEN
380: mrp_kanban_plan_pk.g_log_message := 'CALC_LOW_LEVEL_CODE Sql Error ';
381: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
382: mrp_kanban_plan_pk.g_log_message := sqlerrm;
383: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
384: RETURN FALSE;
385:
386: END CALC_LOW_LEVEL_CODE;
387:

Line 611: mrp_kanban_plan_pk.g_stmt_num := 30;

607: l_error_buf varchar2(2000);
608:
609: BEGIN
610:
611: mrp_kanban_plan_pk.g_stmt_num := 30;
612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 612: IF mrp_kanban_plan_pk.g_debug THEN

608:
609: BEGIN
610:
611: mrp_kanban_plan_pk.g_stmt_num := 30;
612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=

Line 613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

609: BEGIN
610:
611: mrp_kanban_plan_pk.g_stmt_num := 30;
612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';

Line 614: || to_char (mrp_kanban_plan_pk.g_stmt_num);

610:
611: mrp_kanban_plan_pk.g_stmt_num := 30;
612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';
618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

611: mrp_kanban_plan_pk.g_stmt_num := 30;
612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';
618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
619: END IF;

Line 616: mrp_kanban_plan_pk.g_log_message :=

612: IF mrp_kanban_plan_pk.g_debug THEN
613: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';
618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
619: END IF;
620:

Line 618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

614: || to_char (mrp_kanban_plan_pk.g_stmt_num);
615: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
616: mrp_kanban_plan_pk.g_log_message :=
617: 'Entering Snapshot_Item_Locations function';
618: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
619: END IF;
620:
621:
622: l_eco_profile := FND_PROFILE.VALUE('FLM_KANBAN_ECO') = 'Y';

Line 634: IF nvl(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag, 2 ) = 2 THEN

630: -- if we are not replanning, then go ahead and get the initial set of items
631: -- based on the parameters passed to the concurrent program
632: -- ------------------------------------------------------------------------
633:
634: IF nvl(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag, 2 ) = 2 THEN
635:
636: -- now lets go ahead and build our dynamic sql statement based on
637: -- the item/category range and category set parameter values
638:

Line 651: mrp_kanban_plan_pk.g_stmt_num := 40;

647:
648: -- now check if item range has been specified and add the extra condition
649: -- if necessary
650:
651: mrp_kanban_plan_pk.g_stmt_num := 40;
652: IF mrp_kanban_plan_pk.g_debug THEN
653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 652: IF mrp_kanban_plan_pk.g_debug THEN

648: -- now check if item range has been specified and add the extra condition
649: -- if necessary
650:
651: mrp_kanban_plan_pk.g_stmt_num := 40;
652: IF mrp_kanban_plan_pk.g_debug THEN
653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;

Line 653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

649: -- if necessary
650:
651: mrp_kanban_plan_pk.g_stmt_num := 40;
652: IF mrp_kanban_plan_pk.g_debug THEN
653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;
657:

Line 654: || to_char (mrp_kanban_plan_pk.g_stmt_num);

650:
651: mrp_kanban_plan_pk.g_stmt_num := 40;
652: IF mrp_kanban_plan_pk.g_debug THEN
653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;
657:
658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR

Line 655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

651: mrp_kanban_plan_pk.g_stmt_num := 40;
652: IF mrp_kanban_plan_pk.g_debug THEN
653: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;
657:
658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR
659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN

Line 658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR

654: || to_char (mrp_kanban_plan_pk.g_stmt_num);
655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;
657:
658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR
659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN
660:
661: -- call the function that builds the item where clause
662: l_ret_val := flm_util.Item_Where_Clause(

Line 659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN

655: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
656: END IF;
657:
658: IF mrp_kanban_plan_pk.g_kanban_info_rec.from_item IS NOT NULL OR
659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN
660:
661: -- call the function that builds the item where clause
662: l_ret_val := flm_util.Item_Where_Clause(
663: mrp_kanban_plan_pk.g_kanban_info_rec.from_item,

Line 663: mrp_kanban_plan_pk.g_kanban_info_rec.from_item,

659: mrp_kanban_plan_pk.g_kanban_info_rec.to_item IS NOT NULL THEN
660:
661: -- call the function that builds the item where clause
662: l_ret_val := flm_util.Item_Where_Clause(
663: mrp_kanban_plan_pk.g_kanban_info_rec.from_item,
664: mrp_kanban_plan_pk.g_kanban_info_rec.to_item,
665: 'msi',
666: l_item_where_clause,
667: l_error_buf);

Line 664: mrp_kanban_plan_pk.g_kanban_info_rec.to_item,

660:
661: -- call the function that builds the item where clause
662: l_ret_val := flm_util.Item_Where_Clause(
663: mrp_kanban_plan_pk.g_kanban_info_rec.from_item,
664: mrp_kanban_plan_pk.g_kanban_info_rec.to_item,
665: 'msi',
666: l_item_where_clause,
667: l_error_buf);
668:

Line 677: IF mrp_kanban_plan_pk.g_debug THEN

673: IF l_item_where_clause IS NOT NULL THEN
674: l_additional_where := ' AND ' || l_item_where_clause ||
675: l_additional_where;
676:
677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';

674: l_additional_where := ' AND ' || l_item_where_clause ||
675: l_additional_where;
676:
677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
682: END IF;

Line 679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

675: l_additional_where;
676:
677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
682: END IF;
683: END IF;

Line 680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);

676:
677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
682: END IF;
683: END IF;
684:

Line 681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

677: IF mrp_kanban_plan_pk.g_debug THEN
678: mrp_kanban_plan_pk.g_log_message := 'Item Where Clause is : ';
679: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
680: mrp_kanban_plan_pk.g_log_message := substr(l_item_where_clause,1,2000);
681: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
682: END IF;
683: END IF;
684:
685: END IF;

Line 690: mrp_kanban_plan_pk.g_stmt_num := 50;

686:
687: -- similarly check if category range has been specified and add the extra
688: -- condition if necessary
689:
690: mrp_kanban_plan_pk.g_stmt_num := 50;
691: IF mrp_kanban_plan_pk.g_debug THEN
692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 691: IF mrp_kanban_plan_pk.g_debug THEN

687: -- similarly check if category range has been specified and add the extra
688: -- condition if necessary
689:
690: mrp_kanban_plan_pk.g_stmt_num := 50;
691: IF mrp_kanban_plan_pk.g_debug THEN
692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;

Line 692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

688: -- condition if necessary
689:
690: mrp_kanban_plan_pk.g_stmt_num := 50;
691: IF mrp_kanban_plan_pk.g_debug THEN
692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;
696:

Line 693: || to_char (mrp_kanban_plan_pk.g_stmt_num);

689:
690: mrp_kanban_plan_pk.g_stmt_num := 50;
691: IF mrp_kanban_plan_pk.g_debug THEN
692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;
696:
697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR

Line 694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

690: mrp_kanban_plan_pk.g_stmt_num := 50;
691: IF mrp_kanban_plan_pk.g_debug THEN
692: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;
696:
697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR
698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND

Line 697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR

693: || to_char (mrp_kanban_plan_pk.g_stmt_num);
694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;
696:
697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR
698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND
699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN
700:
701: l_ret_val := flm_util.Category_Where_Clause(

Line 698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND

694: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
695: END IF;
696:
697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR
698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND
699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN
700:
701: l_ret_val := flm_util.Category_Where_Clause(
702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,

Line 699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN

695: END IF;
696:
697: IF (mrp_kanban_plan_pk.g_kanban_info_rec.from_category IS NOT NULL OR
698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND
699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN
700:
701: l_ret_val := flm_util.Category_Where_Clause(
702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,
703: mrp_kanban_plan_pk.g_kanban_info_rec.to_category,

Line 702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,

698: mrp_kanban_plan_pk.g_kanban_info_rec.to_category IS NOT NULL) AND
699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN
700:
701: l_ret_val := flm_util.Category_Where_Clause(
702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,
703: mrp_kanban_plan_pk.g_kanban_info_rec.to_category,
704: 'mcat',
705: mrp_kanban_plan_pk.g_kanban_info_rec.category_structure_id,
706: l_cat_where_clause,

Line 703: mrp_kanban_plan_pk.g_kanban_info_rec.to_category,

699: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id IS NOT NULL THEN
700:
701: l_ret_val := flm_util.Category_Where_Clause(
702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,
703: mrp_kanban_plan_pk.g_kanban_info_rec.to_category,
704: 'mcat',
705: mrp_kanban_plan_pk.g_kanban_info_rec.category_structure_id,
706: l_cat_where_clause,
707: l_error_buf);

Line 705: mrp_kanban_plan_pk.g_kanban_info_rec.category_structure_id,

701: l_ret_val := flm_util.Category_Where_Clause(
702: mrp_kanban_plan_pk.g_kanban_info_rec.from_category,
703: mrp_kanban_plan_pk.g_kanban_info_rec.to_category,
704: 'mcat',
705: mrp_kanban_plan_pk.g_kanban_info_rec.category_structure_id,
706: l_cat_where_clause,
707: l_error_buf);
708:
709: IF NOT l_ret_val THEN

Line 718: IF mrp_kanban_plan_pk.g_debug THEN

714: l_additional_tables := 'mtl_categories mcat, ' || l_additional_tables;
715: l_additional_where := l_additional_where || ' AND ' ||
716: ' mcat.category_id = mic.category_id AND ' ||
717: l_cat_where_clause||' ';
718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';

715: l_additional_where := l_additional_where || ' AND ' ||
716: ' mcat.category_id = mic.category_id AND ' ||
717: l_cat_where_clause||' ';
718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
723: END IF;

Line 720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

716: ' mcat.category_id = mic.category_id AND ' ||
717: l_cat_where_clause||' ';
718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
723: END IF;
724: END IF;

Line 721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);

717: l_cat_where_clause||' ';
718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
723: END IF;
724: END IF;
725:

Line 722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

718: IF mrp_kanban_plan_pk.g_debug THEN
719: mrp_kanban_plan_pk.g_log_message := 'Category Where Clause is : ';
720: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
721: mrp_kanban_plan_pk.g_log_message := substr(l_cat_where_clause,1,2000);
722: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
723: END IF;
724: END IF;
725:
726: END IF;

Line 748: mrp_kanban_plan_pk.g_stmt_num := 60;

744: -- in the replenishment chain we specify a line for the source. We want
745: -- this to be the line that's specified in the CFM routing with priority = 1
746: -- so we end up joining bom_operational_routings table also.
747:
748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
751: || to_char (mrp_kanban_plan_pk.g_stmt_num);
752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 749: IF mrp_kanban_plan_pk.g_debug THEN

745: -- this to be the line that's specified in the CFM routing with priority = 1
746: -- so we end up joining bom_operational_routings table also.
747:
748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
751: || to_char (mrp_kanban_plan_pk.g_stmt_num);
752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
753: END IF;

Line 750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

746: -- so we end up joining bom_operational_routings table also.
747:
748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
751: || to_char (mrp_kanban_plan_pk.g_stmt_num);
752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
753: END IF;
754:

Line 751: || to_char (mrp_kanban_plan_pk.g_stmt_num);

747:
748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
751: || to_char (mrp_kanban_plan_pk.g_stmt_num);
752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
753: END IF;
754:
755: l_sql_stmt :=

Line 752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

748: mrp_kanban_plan_pk.g_stmt_num := 60;
749: IF mrp_kanban_plan_pk.g_debug THEN
750: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
751: || to_char (mrp_kanban_plan_pk.g_stmt_num);
752: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
753: END IF;
754:
755: l_sql_stmt :=
756: 'INSERT INTO mrp_low_level_codes ( ' ||

Line 901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);

897: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
898:
899: -- put values into all the bind variables
900: flm_util.add_bind (':b_kanban_plan_id',
901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);
902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);

Line 903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);

899: -- put values into all the bind variables
900: flm_util.add_bind (':b_kanban_plan_id',
901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);
902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);

Line 905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);

901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);
902: flm_util.add_bind (':b_organization_id',
903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);

Line 907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);

903: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id);
904: flm_util.add_bind (':b_bom_effectivity',
905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',
911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);

Line 909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);

905: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity);
906: flm_util.add_bind (':b_PRODUCTION_KANBAN',
907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',
911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);
912: flm_util.do_binds(l_cursor);
913:

Line 911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);

907: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN);
908: flm_util.add_bind (':b_PRODUCTION_SOURCE_TYPE',
909: mrp_kanban_plan_pk.G_PRODUCTION_SOURCE_TYPE);
910: flm_util.add_bind (':b_category_set_id',
911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);
912: flm_util.do_binds(l_cursor);
913:
914: -- now execute the sql stmt
915: l_rows_processed := dbms_sql.execute(l_cursor);

Line 920: IF mrp_kanban_plan_pk.g_debug THEN

916:
917: -- close the cursor
918: dbms_sql.close_cursor (l_cursor);
919:
920: IF mrp_kanban_plan_pk.g_debug THEN
921: mrp_kanban_plan_pk.g_log_message :=
922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=

Line 921: mrp_kanban_plan_pk.g_log_message :=

917: -- close the cursor
918: dbms_sql.close_cursor (l_cursor);
919:
920: IF mrp_kanban_plan_pk.g_debug THEN
921: mrp_kanban_plan_pk.g_log_message :=
922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';

Line 923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

919:
920: IF mrp_kanban_plan_pk.g_debug THEN
921: mrp_kanban_plan_pk.g_log_message :=
922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||

Line 924: mrp_kanban_plan_pk.g_log_message :=

920: IF mrp_kanban_plan_pk.g_debug THEN
921: mrp_kanban_plan_pk.g_log_message :=
922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||
928: to_char(l_rows_processed) || ' into mrp_low_level_codes table';

Line 926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

922: '----------------------------------------------';
923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||
928: to_char(l_rows_processed) || ' into mrp_low_level_codes table';
929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
930: END IF;

Line 927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||

923: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
924: mrp_kanban_plan_pk.g_log_message :=
925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||
928: to_char(l_rows_processed) || ' into mrp_low_level_codes table';
929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
930: END IF;
931:

Line 929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

925: 'Successfully executed the Dynamic Sql Statement';
926: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
927: mrp_kanban_plan_pk.g_log_message := 'Inserted ' ||
928: to_char(l_rows_processed) || ' into mrp_low_level_codes table';
929: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
930: END IF;
931:
932: END IF; -- so we basically did all the above only if we are not replanning
933:

Line 939: IF mrp_kanban_plan_pk.g_debug THEN

935: -- Now go ahead and get all the other items that are required for planning
936: -- from the bill structure
937: -- ------------------------------------------------------------------------
938:
939: IF mrp_kanban_plan_pk.g_debug THEN
940: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
941: || to_char (mrp_kanban_plan_pk.g_stmt_num);
942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
943: END IF;

Line 940: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

936: -- from the bill structure
937: -- ------------------------------------------------------------------------
938:
939: IF mrp_kanban_plan_pk.g_debug THEN
940: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
941: || to_char (mrp_kanban_plan_pk.g_stmt_num);
942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
943: END IF;
944:

Line 941: || to_char (mrp_kanban_plan_pk.g_stmt_num);

937: -- ------------------------------------------------------------------------
938:
939: IF mrp_kanban_plan_pk.g_debug THEN
940: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
941: || to_char (mrp_kanban_plan_pk.g_stmt_num);
942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
943: END IF;
944:
945: l_level_count := 1;

Line 942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

938:
939: IF mrp_kanban_plan_pk.g_debug THEN
940: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
941: || to_char (mrp_kanban_plan_pk.g_stmt_num);
942: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
943: END IF;
944:
945: l_level_count := 1;
946:

Line 1032: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1028: mtl_item_categories mic,
1029: bom_inventory_components mrp_bic,
1030: mrp_low_level_codes mllc
1031: WHERE mllc.plan_id =
1032: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1033: AND mllc.organization_id =
1034: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1035: AND mllc.levels_below = l_level_count
1036: AND mrp_bic.component_item_id = mllc.assembly_item_id

Line 1034: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1030: mrp_low_level_codes mllc
1031: WHERE mllc.plan_id =
1032: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1033: AND mllc.organization_id =
1034: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1035: AND mllc.levels_below = l_level_count
1036: AND mrp_bic.component_item_id = mllc.assembly_item_id
1037: AND (nvl(mrp_bic.disable_date,
1038: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=

Line 1038: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=

1034: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1035: AND mllc.levels_below = l_level_count
1036: AND mrp_bic.component_item_id = mllc.assembly_item_id
1037: AND (nvl(mrp_bic.disable_date,
1038: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=
1039: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1040: AND mrp_bic.effectivity_date <=
1041: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1042: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id

Line 1039: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1035: AND mllc.levels_below = l_level_count
1036: AND mrp_bic.component_item_id = mllc.assembly_item_id
1037: AND (nvl(mrp_bic.disable_date,
1038: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=
1039: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1040: AND mrp_bic.effectivity_date <=
1041: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1042: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id
1043: AND bbom.organization_id = mllc.organization_id

Line 1041: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1037: AND (nvl(mrp_bic.disable_date,
1038: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=
1039: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1040: AND mrp_bic.effectivity_date <=
1041: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1042: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id
1043: AND bbom.organization_id = mllc.organization_id
1044: AND ps.kanban_plan_id (+) =
1045: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,

Line 1045: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,

1041: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1042: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id
1043: AND bbom.organization_id = mllc.organization_id
1044: AND ps.kanban_plan_id (+) =
1045: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1046: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1047: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1048: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1049: AND ps.organization_id (+) = bbom.organization_id

Line 1046: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,

1042: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id
1043: AND bbom.organization_id = mllc.organization_id
1044: AND ps.kanban_plan_id (+) =
1045: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1046: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1047: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1048: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1049: AND ps.organization_id (+) = bbom.organization_id
1050: AND ps.inventory_item_id (+) = bbom.assembly_item_id

Line 1047: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,

1043: AND bbom.organization_id = mllc.organization_id
1044: AND ps.kanban_plan_id (+) =
1045: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1046: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1047: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1048: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1049: AND ps.organization_id (+) = bbom.organization_id
1050: AND ps.inventory_item_id (+) = bbom.assembly_item_id
1051: AND ps.source_type (+) = 4 /* KANBAN_PRODUCTION */

Line 1048: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)

1044: AND ps.kanban_plan_id (+) =
1045: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1046: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1047: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1048: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1049: AND ps.organization_id (+) = bbom.organization_id
1050: AND ps.inventory_item_id (+) = bbom.assembly_item_id
1051: AND ps.source_type (+) = 4 /* KANBAN_PRODUCTION */
1052: /* Fix bug 2090054

Line 1060: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1056: ps.wip_line_id,
1057: bbom.alternate_bom_designator)
1058: */
1059: AND mic.organization_id (+) =
1060: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1061: AND mic.inventory_item_id (+) = mllc.assembly_item_id
1062: AND mic.category_set_id (+) =
1063: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id
1064: /* Avoid re-selecting items already in mrp_low_level_codes */

Line 1063: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id

1059: AND mic.organization_id (+) =
1060: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1061: AND mic.inventory_item_id (+) = mllc.assembly_item_id
1062: AND mic.category_set_id (+) =
1063: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id
1064: /* Avoid re-selecting items already in mrp_low_level_codes */
1065: AND NOT EXISTS
1066: ( SELECT 'Exists'
1067: FROM mrp_low_level_codes mllc2

Line 1069: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1065: AND NOT EXISTS
1066: ( SELECT 'Exists'
1067: FROM mrp_low_level_codes mllc2
1068: WHERE mllc2.plan_id =
1069: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1070: AND mllc2.organization_id =
1071: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1072: AND mllc2.component_item_id = mrp_bic.component_item_id )
1073: AND EXISTS(

Line 1071: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1067: FROM mrp_low_level_codes mllc2
1068: WHERE mllc2.plan_id =
1069: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1070: AND mllc2.organization_id =
1071: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1072: AND mllc2.component_item_id = mrp_bic.component_item_id )
1073: AND EXISTS(
1074: SELECT /*+no_unnest*/ 1
1075: FROM mtl_system_items msi

Line 1149: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1145: mtl_item_categories mic,
1146: bom_inventory_components mrp_bic,
1147: mrp_low_level_codes mllc
1148: WHERE mllc.plan_id =
1149: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1150: AND mllc.organization_id =
1151: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1152: AND mllc.levels_below = l_level_count
1153: AND mrp_bic.component_item_id = mllc.assembly_item_id

Line 1151: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1147: mrp_low_level_codes mllc
1148: WHERE mllc.plan_id =
1149: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1150: AND mllc.organization_id =
1151: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1152: AND mllc.levels_below = l_level_count
1153: AND mrp_bic.component_item_id = mllc.assembly_item_id
1154: AND (nvl(mrp_bic.disable_date,
1155: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=

Line 1155: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=

1151: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1152: AND mllc.levels_below = l_level_count
1153: AND mrp_bic.component_item_id = mllc.assembly_item_id
1154: AND (nvl(mrp_bic.disable_date,
1155: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=
1156: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1157: AND mrp_bic.effectivity_date <=
1158: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1159: AND NOT EXISTS (

Line 1156: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1152: AND mllc.levels_below = l_level_count
1153: AND mrp_bic.component_item_id = mllc.assembly_item_id
1154: AND (nvl(mrp_bic.disable_date,
1155: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=
1156: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1157: AND mrp_bic.effectivity_date <=
1158: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1159: AND NOT EXISTS (
1160: SELECT /*+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) */

Line 1158: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1154: AND (nvl(mrp_bic.disable_date,
1155: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)) +1 >=
1156: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1157: AND mrp_bic.effectivity_date <=
1158: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1159: AND NOT EXISTS (
1160: SELECT /*+ INDEX(bic2 BOM_INVENTORY_COMPONENTS_N1) */
1161: NULL
1162: FROM bom_inventory_components bic2

Line 1173: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1169: mrp_bic.old_component_sequence_id,
1170: mrp_bic.component_sequence_id)
1171: OR bic2.operation_seq_num = mrp_bic.operation_seq_num)
1172: AND bic2.effectivity_date <=
1173: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1174: AND bic2.effectivity_date > mrp_bic.effectivity_date
1175: AND (bic2.implementation_date is not null OR
1176: (bic2.implementation_date is null AND EXISTS
1177: (SELECT NULL

Line 1192: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,

1188: AND eri.mrp_active = 1 )))
1189: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id
1190: AND bbom.organization_id = mllc.organization_id
1191: AND ps.kanban_plan_id (+) =
1192: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1193: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1194: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1195: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1196: AND ps.organization_id (+) = bbom.organization_id

Line 1193: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,

1189: AND bbom.common_bill_sequence_id = mrp_bic.bill_sequence_id
1190: AND bbom.organization_id = mllc.organization_id
1191: AND ps.kanban_plan_id (+) =
1192: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1193: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1194: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1195: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1196: AND ps.organization_id (+) = bbom.organization_id
1197: AND ps.inventory_item_id (+) = bbom.assembly_item_id

Line 1194: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,

1190: AND bbom.organization_id = mllc.organization_id
1191: AND ps.kanban_plan_id (+) =
1192: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1193: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1194: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1195: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1196: AND ps.organization_id (+) = bbom.organization_id
1197: AND ps.inventory_item_id (+) = bbom.assembly_item_id
1198: AND ps.source_type (+) = 4 /* KANBAN_PRODUCTION */

Line 1195: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)

1191: AND ps.kanban_plan_id (+) =
1192: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1193: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1194: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1195: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1196: AND ps.organization_id (+) = bbom.organization_id
1197: AND ps.inventory_item_id (+) = bbom.assembly_item_id
1198: AND ps.source_type (+) = 4 /* KANBAN_PRODUCTION */
1199: /* Fix bug 2090054

Line 1207: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1203: ps.wip_line_id,
1204: bbom.alternate_bom_designator)
1205: */
1206: AND mic.organization_id (+) =
1207: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1208: AND mic.inventory_item_id (+) = mllc.assembly_item_id
1209: AND mic.category_set_id (+) =
1210: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id
1211: /* Avoid re-selecting items already in mrp_low_level_codes */

Line 1210: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id

1206: AND mic.organization_id (+) =
1207: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1208: AND mic.inventory_item_id (+) = mllc.assembly_item_id
1209: AND mic.category_set_id (+) =
1210: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id
1211: /* Avoid re-selecting items already in mrp_low_level_codes */
1212: AND NOT EXISTS
1213: ( SELECT 'Exists'
1214: FROM mrp_low_level_codes mllc2

Line 1216: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1212: AND NOT EXISTS
1213: ( SELECT 'Exists'
1214: FROM mrp_low_level_codes mllc2
1215: WHERE mllc2.plan_id =
1216: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1217: AND mllc2.organization_id =
1218: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1219: AND mllc2.component_item_id = mrp_bic.component_item_id )
1220: AND EXISTS(

Line 1218: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1214: FROM mrp_low_level_codes mllc2
1215: WHERE mllc2.plan_id =
1216: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1217: AND mllc2.organization_id =
1218: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1219: AND mllc2.component_item_id = mrp_bic.component_item_id )
1220: AND EXISTS(
1221: SELECT /*+no_unnest*/ 1
1222: FROM mtl_system_items msi

Line 1246: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1242: SET (mllc.kanban_item_flag) =
1243: (select nvl(max(decode(kbn_items.release_kanban_flag, 1, 'Y', 'Y')), 'N')
1244: from mtl_kanban_pull_sequences kbn_items
1245: where kbn_items.kanban_plan_id =
1246: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1247: and kbn_items.organization_id =
1248: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1249: and kbn_items.inventory_item_id = mllc.assembly_item_id)
1250: WHERE mllc.plan_id =

Line 1248: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1244: from mtl_kanban_pull_sequences kbn_items
1245: where kbn_items.kanban_plan_id =
1246: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1247: and kbn_items.organization_id =
1248: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1249: and kbn_items.inventory_item_id = mllc.assembly_item_id)
1250: WHERE mllc.plan_id =
1251: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1252: AND mllc.organization_id =

Line 1251: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1247: and kbn_items.organization_id =
1248: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1249: and kbn_items.inventory_item_id = mllc.assembly_item_id)
1250: WHERE mllc.plan_id =
1251: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1252: AND mllc.organization_id =
1253: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1254: AND mllc.kanban_item_flag is null;
1255:

Line 1253: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1249: and kbn_items.inventory_item_id = mllc.assembly_item_id)
1250: WHERE mllc.plan_id =
1251: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1252: AND mllc.organization_id =
1253: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1254: AND mllc.kanban_item_flag is null;
1255:
1256:
1257: mrp_kanban_plan_pk.g_stmt_num := 80;

Line 1257: mrp_kanban_plan_pk.g_stmt_num := 80;

1253: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1254: AND mllc.kanban_item_flag is null;
1255:
1256:
1257: mrp_kanban_plan_pk.g_stmt_num := 80;
1258: IF mrp_kanban_plan_pk.g_debug THEN
1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1258: IF mrp_kanban_plan_pk.g_debug THEN

1254: AND mllc.kanban_item_flag is null;
1255:
1256:
1257: mrp_kanban_plan_pk.g_stmt_num := 80;
1258: IF mrp_kanban_plan_pk.g_debug THEN
1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1262: END IF;

Line 1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

1255:
1256:
1257: mrp_kanban_plan_pk.g_stmt_num := 80;
1258: IF mrp_kanban_plan_pk.g_debug THEN
1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1262: END IF;
1263:

Line 1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);

1256:
1257: mrp_kanban_plan_pk.g_stmt_num := 80;
1258: IF mrp_kanban_plan_pk.g_debug THEN
1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1262: END IF;
1263:
1264: -- now update the mrp_low_level_codes table with operation_yield

Line 1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1257: mrp_kanban_plan_pk.g_stmt_num := 80;
1258: IF mrp_kanban_plan_pk.g_debug THEN
1259: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1260: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1261: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1262: END IF;
1263:
1264: -- now update the mrp_low_level_codes table with operation_yield
1265: -- and net_planning_percent from the bom_operation_sequences table.

Line 1292: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) +1) >=

1288: nvl(mllc.alternate_designator, 'xxx')
1289: AND mrp_bic.bill_sequence_id = bbom.common_bill_sequence_id
1290: AND mrp_bic.component_item_id = mllc.component_item_id
1291: AND (nvl(mrp_bic.disable_date,
1292: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) +1) >=
1293: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1294: AND mrp_bic.effectivity_date <=
1295: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1296: AND NOT EXISTS (

Line 1293: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1289: AND mrp_bic.bill_sequence_id = bbom.common_bill_sequence_id
1290: AND mrp_bic.component_item_id = mllc.component_item_id
1291: AND (nvl(mrp_bic.disable_date,
1292: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) +1) >=
1293: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1294: AND mrp_bic.effectivity_date <=
1295: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1296: AND NOT EXISTS (
1297: SELECT NULL

Line 1295: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1291: AND (nvl(mrp_bic.disable_date,
1292: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) +1) >=
1293: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1294: AND mrp_bic.effectivity_date <=
1295: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1296: AND NOT EXISTS (
1297: SELECT NULL
1298: FROM bom_inventory_components bic2
1299: WHERE bic2.bill_sequence_id = mrp_bic.bill_sequence_id

Line 1309: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1305: mrp_bic.old_component_sequence_id,
1306: mrp_bic.component_sequence_id)
1307: OR bic2.operation_seq_num = mrp_bic.operation_seq_num)
1308: AND bic2.effectivity_date <=
1309: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1310: AND bic2.effectivity_date > mrp_bic.effectivity_date
1311: AND (bic2.implementation_date is not null OR
1312: (bic2.implementation_date is null AND EXISTS
1313: (SELECT NULL

Line 1333: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) + 1

1329: AND bos.routing_sequence_id = bor.routing_sequence_id
1330: AND bos.operation_seq_num = mrp_bic.operation_seq_num
1331: AND nvl(bos.operation_type, 1) = 1
1332: AND nvl(bos.disable_date,
1333: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) + 1
1334: >= mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1335: AND bos.effectivity_date <=
1336: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)
1337: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id;

Line 1334: >= mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity

1330: AND bos.operation_seq_num = mrp_bic.operation_seq_num
1331: AND nvl(bos.operation_type, 1) = 1
1332: AND nvl(bos.disable_date,
1333: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) + 1
1334: >= mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1335: AND bos.effectivity_date <=
1336: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)
1337: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id;
1338:

Line 1336: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)

1332: AND nvl(bos.disable_date,
1333: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) + 1
1334: >= mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1335: AND bos.effectivity_date <=
1336: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)
1337: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id;
1338:
1339: mrp_kanban_plan_pk.g_stmt_num := 90;
1340:

Line 1337: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id;

1333: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity) + 1
1334: >= mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity
1335: AND bos.effectivity_date <=
1336: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)
1337: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id;
1338:
1339: mrp_kanban_plan_pk.g_stmt_num := 90;
1340:
1341:

Line 1339: mrp_kanban_plan_pk.g_stmt_num := 90;

1335: AND bos.effectivity_date <=
1336: mrp_kanban_plan_pk.g_kanban_info_rec.bom_effectivity)
1337: WHERE mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id;
1338:
1339: mrp_kanban_plan_pk.g_stmt_num := 90;
1340:
1341:
1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

Line 1342: IF mrp_kanban_plan_pk.g_debug THEN

1338:
1339: mrp_kanban_plan_pk.g_stmt_num := 90;
1340:
1341:
1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||

Line 1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

1339: mrp_kanban_plan_pk.g_stmt_num := 90;
1340:
1341:
1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';

Line 1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);

1340:
1341:
1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';
1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1341:
1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';
1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1349: END IF;

Line 1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||

1342: IF mrp_kanban_plan_pk.g_debug THEN
1343: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';
1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1349: END IF;
1350:

Line 1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1344: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1345: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1346: mrp_kanban_plan_pk.g_log_message := 'Updated mrp_low_level_codes ' ||
1347: 'with net planning percent and yield information';
1348: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1349: END IF;
1350:
1351:
1352: -- ------------------------------------------------------------------------

Line 1401: mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id AND

1397: mtl_item_categories mic,
1398: mtl_kanban_pull_sequences kbn_items,
1399: mrp_low_level_codes mllc1
1400: WHERE
1401: mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id AND
1402: mllc1.organization_id =
1403: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id AND
1404: kbn_items.inventory_item_id (+) =
1405: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN AND

Line 1403: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id AND

1399: mrp_low_level_codes mllc1
1400: WHERE
1401: mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id AND
1402: mllc1.organization_id =
1403: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id AND
1404: kbn_items.inventory_item_id (+) =
1405: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN AND
1406: kbn_items.inventory_item_id (+) = mllc1.assembly_item_id AND
1407: kbn_items.organization_id (+) = mllc1.organization_id AND

Line 1405: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN AND

1401: mllc1.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id AND
1402: mllc1.organization_id =
1403: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id AND
1404: kbn_items.inventory_item_id (+) =
1405: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN AND
1406: kbn_items.inventory_item_id (+) = mllc1.assembly_item_id AND
1407: kbn_items.organization_id (+) = mllc1.organization_id AND
1408: mic.inventory_item_id (+) = mllc1.assembly_item_id AND
1409: mic.organization_id (+) = mllc1.organization_id AND

Line 1411: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id AND

1407: kbn_items.organization_id (+) = mllc1.organization_id AND
1408: mic.inventory_item_id (+) = mllc1.assembly_item_id AND
1409: mic.organization_id (+) = mllc1.organization_id AND
1410: mic.category_set_id (+) =
1411: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id AND
1412: --select only the assembly items that do not exist as components
1413: NOT EXISTS
1414: (SELECT 'Exists'
1415: FROM mrp_low_level_codes mllc2

Line 1422: mrp_kanban_plan_pk.g_stmt_num := 100;

1418: mllc2.component_item_id = mllc1.assembly_item_id );
1419:
1420:
1421:
1422: mrp_kanban_plan_pk.g_stmt_num := 100;
1423: IF mrp_kanban_plan_pk.g_debug THEN
1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1423: IF mrp_kanban_plan_pk.g_debug THEN

1419:
1420:
1421:
1422: mrp_kanban_plan_pk.g_stmt_num := 100;
1423: IF mrp_kanban_plan_pk.g_debug THEN
1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1427: END IF;

Line 1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

1420:
1421:
1422: mrp_kanban_plan_pk.g_stmt_num := 100;
1423: IF mrp_kanban_plan_pk.g_debug THEN
1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1427: END IF;
1428:

Line 1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);

1421:
1422: mrp_kanban_plan_pk.g_stmt_num := 100;
1423: IF mrp_kanban_plan_pk.g_debug THEN
1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1427: END IF;
1428:
1429: -- ------------------------------------------------------------------------

Line 1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1422: mrp_kanban_plan_pk.g_stmt_num := 100;
1423: IF mrp_kanban_plan_pk.g_debug THEN
1424: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1425: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1426: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1427: END IF;
1428:
1429: -- ------------------------------------------------------------------------
1430: -- Now find information in mtl_kanban_pull_sequences about inter-org and

Line 1465: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,

1461: last_update_date,
1462: created_by,
1463: creation_date )
1464: SELECT DISTINCT
1465: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1466: ps.organization_id,
1467: ps.inventory_item_id,
1468: ps.subinventory_name,
1469: ps.locator_id,

Line 1491: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,

1487: FROM mtl_kanban_pull_sequences ps,
1488: mrp_low_level_codes mllc
1489: WHERE ps.source_type = 3 -- only intra org replenishments
1490: AND ps.kanban_plan_id =
1491: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1492: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1493: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1494: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1495: AND ps.organization_id = mllc.organization_id

Line 1492: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,

1488: mrp_low_level_codes mllc
1489: WHERE ps.source_type = 3 -- only intra org replenishments
1490: AND ps.kanban_plan_id =
1491: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1492: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1493: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1494: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1495: AND ps.organization_id = mllc.organization_id
1496: AND ps.inventory_item_id = mllc.component_item_id

Line 1493: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,

1489: WHERE ps.source_type = 3 -- only intra org replenishments
1490: AND ps.kanban_plan_id =
1491: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1492: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1493: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1494: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1495: AND ps.organization_id = mllc.organization_id
1496: AND ps.inventory_item_id = mllc.component_item_id
1497: AND mllc.organization_id =

Line 1494: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)

1490: AND ps.kanban_plan_id =
1491: decode(mrp_kanban_plan_pk.g_kanban_info_rec.replan_flag,
1492: 2, mrp_kanban_plan_pk.G_PRODUCTION_KANBAN,
1493: 1, mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id,
1494: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1495: AND ps.organization_id = mllc.organization_id
1496: AND ps.inventory_item_id = mllc.component_item_id
1497: AND mllc.organization_id =
1498: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

Line 1498: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id

1494: mrp_kanban_plan_pk.G_PRODUCTION_KANBAN)
1495: AND ps.organization_id = mllc.organization_id
1496: AND ps.inventory_item_id = mllc.component_item_id
1497: AND mllc.organization_id =
1498: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1499: AND mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1500: AND mllc.kanban_item_flag = 'Y';
1501:
1502:

Line 1499: AND mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id

1495: AND ps.organization_id = mllc.organization_id
1496: AND ps.inventory_item_id = mllc.component_item_id
1497: AND mllc.organization_id =
1498: mrp_kanban_plan_pk.g_kanban_info_rec.organization_id
1499: AND mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1500: AND mllc.kanban_item_flag = 'Y';
1501:
1502:
1503: IF mrp_kanban_plan_pk.g_debug THEN

Line 1503: IF mrp_kanban_plan_pk.g_debug THEN

1499: AND mllc.plan_id = mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id
1500: AND mllc.kanban_item_flag = 'Y';
1501:
1502:
1503: IF mrp_kanban_plan_pk.g_debug THEN
1504: mrp_kanban_plan_pk.g_log_message :=
1505: 'Completed inserting into mrp_low_level_codes table';
1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;

Line 1504: mrp_kanban_plan_pk.g_log_message :=

1500: AND mllc.kanban_item_flag = 'Y';
1501:
1502:
1503: IF mrp_kanban_plan_pk.g_debug THEN
1504: mrp_kanban_plan_pk.g_log_message :=
1505: 'Completed inserting into mrp_low_level_codes table';
1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;

Line 1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1502:
1503: IF mrp_kanban_plan_pk.g_debug THEN
1504: mrp_kanban_plan_pk.g_log_message :=
1505: 'Completed inserting into mrp_low_level_codes table';
1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

Line 1508: mrp_kanban_plan_pk.g_stmt_num := 110;

1504: mrp_kanban_plan_pk.g_log_message :=
1505: 'Completed inserting into mrp_low_level_codes table';
1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1509: IF mrp_kanban_plan_pk.g_debug THEN

1505: 'Completed inserting into mrp_low_level_codes table';
1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1513: END IF;

Line 1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

1506: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1513: END IF;
1514:

Line 1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);

1507: END IF;
1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1513: END IF;
1514:
1515: -- call the check_item_locations procedure to ensure that

Line 1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1508: mrp_kanban_plan_pk.g_stmt_num := 110;
1509: IF mrp_kanban_plan_pk.g_debug THEN
1510: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1511: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1512: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1513: END IF;
1514:
1515: -- call the check_item_locations procedure to ensure that
1516: -- kanban items have the from-locations populated in the

Line 1525: mrp_kanban_plan_pk.g_stmt_num := 130;

1521: IF NOT Check_Item_Locations THEN
1522: RETURN FALSE;
1523: END IF;
1524:
1525: mrp_kanban_plan_pk.g_stmt_num := 130;
1526: IF mrp_kanban_plan_pk.g_debug THEN
1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1526: IF mrp_kanban_plan_pk.g_debug THEN

1522: RETURN FALSE;
1523: END IF;
1524:
1525: mrp_kanban_plan_pk.g_stmt_num := 130;
1526: IF mrp_kanban_plan_pk.g_debug THEN
1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1530: END IF;

Line 1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '

1523: END IF;
1524:
1525: mrp_kanban_plan_pk.g_stmt_num := 130;
1526: IF mrp_kanban_plan_pk.g_debug THEN
1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1530: END IF;
1531:

Line 1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);

1524:
1525: mrp_kanban_plan_pk.g_stmt_num := 130;
1526: IF mrp_kanban_plan_pk.g_debug THEN
1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1530: END IF;
1531:
1532: -- now we are ready for our low level code calculation

Line 1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1525: mrp_kanban_plan_pk.g_stmt_num := 130;
1526: IF mrp_kanban_plan_pk.g_debug THEN
1527: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : '
1528: || to_char (mrp_kanban_plan_pk.g_stmt_num);
1529: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1530: END IF;
1531:
1532: -- now we are ready for our low level code calculation
1533: -- so call that procedure

Line 1535: IF mrp_kanban_plan_pk.g_debug THEN

1531:
1532: -- now we are ready for our low level code calculation
1533: -- so call that procedure
1534:
1535: IF mrp_kanban_plan_pk.g_debug THEN
1536: mrp_kanban_plan_pk.g_log_message := 'Calling CALC_LOW_LEVEL_code function';
1537: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1538: END IF;
1539:

Line 1536: mrp_kanban_plan_pk.g_log_message := 'Calling CALC_LOW_LEVEL_code function';

1532: -- now we are ready for our low level code calculation
1533: -- so call that procedure
1534:
1535: IF mrp_kanban_plan_pk.g_debug THEN
1536: mrp_kanban_plan_pk.g_log_message := 'Calling CALC_LOW_LEVEL_code function';
1537: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1538: END IF;
1539:
1540: IF NOT Calc_Low_Level_code THEN

Line 1537: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1533: -- so call that procedure
1534:
1535: IF mrp_kanban_plan_pk.g_debug THEN
1536: mrp_kanban_plan_pk.g_log_message := 'Calling CALC_LOW_LEVEL_code function';
1537: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1538: END IF;
1539:
1540: IF NOT Calc_Low_Level_code THEN
1541: RETURN FALSE;

Line 1544: mrp_kanban_plan_pk.g_stmt_num := 140;

1540: IF NOT Calc_Low_Level_code THEN
1541: RETURN FALSE;
1542: END IF;
1543:
1544: mrp_kanban_plan_pk.g_stmt_num := 140;
1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1545: IF mrp_kanban_plan_pk.g_debug THEN

1541: RETURN FALSE;
1542: END IF;
1543:
1544: mrp_kanban_plan_pk.g_stmt_num := 140;
1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';

Line 1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||

1542: END IF;
1543:
1544: mrp_kanban_plan_pk.g_stmt_num := 140;
1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

Line 1547: to_char (mrp_kanban_plan_pk.g_stmt_num);

1543:
1544: mrp_kanban_plan_pk.g_stmt_num := 140;
1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1551: END IF;

Line 1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1544: mrp_kanban_plan_pk.g_stmt_num := 140;
1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1551: END IF;
1552:

Line 1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';

1545: IF mrp_kanban_plan_pk.g_debug THEN
1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1551: END IF;
1552:
1553:

Line 1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1546: mrp_kanban_plan_pk.g_log_message := 'Debug Statement Number : ' ||
1547: to_char (mrp_kanban_plan_pk.g_stmt_num);
1548: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1549: mrp_kanban_plan_pk.g_log_message := 'Calling CHECK_FOR_LOOPS function';
1550: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1551: END IF;
1552:
1553:
1554: -- after low level code calculation, if we have component items

Line 1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';

1563:
1564: EXCEPTION
1565:
1566: WHEN OTHERS THEN
1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';
1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;
1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1571: RETURN FALSE;

Line 1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1564: EXCEPTION
1565:
1566: WHEN OTHERS THEN
1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';
1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;
1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1571: RETURN FALSE;
1572:

Line 1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;

1565:
1566: WHEN OTHERS THEN
1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';
1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;
1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1571: RETURN FALSE;
1572:
1573: END SNAPSHOT_ITEM_LOCATIONS;

Line 1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);

1566: WHEN OTHERS THEN
1567: mrp_kanban_plan_pk.g_log_message := 'SNAPSHOT_ITEM_LOCATIONS Sql Error ';
1568: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1569: mrp_kanban_plan_pk.g_log_message := sqlerrm;
1570: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1571: RETURN FALSE;
1572:
1573: END SNAPSHOT_ITEM_LOCATIONS;
1574: