APPS.GME_MAKE_TO_ORDER_PVT dependencies on GME_DEBUG

Line 180: IF (g_debug <= gme_debug.g_log_statement) THEN

176: /*Int variables
177: =========================================*/
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: IF (g_debug <= gme_debug.g_log_statement) THEN
181: gme_debug.log_initialize ('OPM_MaketoOrder');
182: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
183: -- gme_debug.log_initialize ('OPM_MaketoOrder');
184: END IF;

Line 181: gme_debug.log_initialize ('OPM_MaketoOrder');

177: =========================================*/
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: IF (g_debug <= gme_debug.g_log_statement) THEN
181: gme_debug.log_initialize ('OPM_MaketoOrder');
182: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
183: -- gme_debug.log_initialize ('OPM_MaketoOrder');
184: END IF;
185:

Line 182: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');

178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: IF (g_debug <= gme_debug.g_log_statement) THEN
181: gme_debug.log_initialize ('OPM_MaketoOrder');
182: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
183: -- gme_debug.log_initialize ('OPM_MaketoOrder');
184: END IF;
185:
186: /* Standard begin of API savepoint

Line 183: -- gme_debug.log_initialize ('OPM_MaketoOrder');

179:
180: IF (g_debug <= gme_debug.g_log_statement) THEN
181: gme_debug.log_initialize ('OPM_MaketoOrder');
182: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
183: -- gme_debug.log_initialize ('OPM_MaketoOrder');
184: END IF;
185:
186: /* Standard begin of API savepoint
187: ===========================================*/

Line 199: IF (g_debug <= gme_debug.g_log_statement) THEN

195: p_api_version,
196: l_api_name,
197: g_pkg_name)
198: THEN
199: IF (g_debug <= gme_debug.g_log_statement) THEN
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' compatability call failure ');
201: END IF;
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;

Line 200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' compatability call failure ');

196: l_api_name,
197: g_pkg_name)
198: THEN
199: IF (g_debug <= gme_debug.g_log_statement) THEN
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' compatability call failure ');
201: END IF;
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:

Line 214: IF (g_debug <= gme_debug.g_log_statement) THEN

210: FND_MSG_PUB.initialize;
211: END IF;
212:
213: FND_FILE.Put_Line(FND_FILE.LOG, 'After Initialize ');
214: IF (g_debug <= gme_debug.g_log_statement) THEN
215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' begin processing ');
216: END IF;
217:
218: IF( NVL(p_so_line_id,0) = 0 ) THEN

Line 215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' begin processing ');

211: END IF;
212:
213: FND_FILE.Put_Line(FND_FILE.LOG, 'After Initialize ');
214: IF (g_debug <= gme_debug.g_log_statement) THEN
215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' begin processing ');
216: END IF;
217:
218: IF( NVL(p_so_line_id,0) = 0 ) THEN
219: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 219: IF (g_debug <= gme_debug.g_log_statement) THEN

215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' begin processing ');
216: END IF;
217:
218: IF( NVL(p_so_line_id,0) = 0 ) THEN
219: IF (g_debug <= gme_debug.g_log_statement) THEN
220: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' sales order line id parameter is missing ');
221: END IF;
222: FND_MESSAGE.Set_Name('GMI','Missing');
223: FND_MESSAGE.Set_Token('MISSING', 'so_line_id');

Line 220: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' sales order line id parameter is missing ');

216: END IF;
217:
218: IF( NVL(p_so_line_id,0) = 0 ) THEN
219: IF (g_debug <= gme_debug.g_log_statement) THEN
220: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' sales order line id parameter is missing ');
221: END IF;
222: FND_MESSAGE.Set_Name('GMI','Missing');
223: FND_MESSAGE.Set_Token('MISSING', 'so_line_id');
224: FND_MSG_PUB.Add;

Line 228: IF (g_debug <= gme_debug.g_log_statement) THEN

224: FND_MSG_PUB.Add;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: /* ============ IF this line is already reserved to production supply do not process further =========== */
228: IF (g_debug <= gme_debug.g_log_statement) THEN
229: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check for existing reservations against GME PROD supply ');
230: END IF;
231: OPEN cur_prod_reservations(p_so_line_id);
232: FETCH cur_prod_reservations INTO l_count;

Line 229: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check for existing reservations against GME PROD supply ');

225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: /* ============ IF this line is already reserved to production supply do not process further =========== */
228: IF (g_debug <= gme_debug.g_log_statement) THEN
229: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check for existing reservations against GME PROD supply ');
230: END IF;
231: OPEN cur_prod_reservations(p_so_line_id);
232: FETCH cur_prod_reservations INTO l_count;
233: IF (cur_prod_reservations%NOTFOUND) or (l_count=0) THEN

Line 234: IF g_debug <= gme_debug.g_log_procedure THEN

230: END IF;
231: OPEN cur_prod_reservations(p_so_line_id);
232: FETCH cur_prod_reservations INTO l_count;
233: IF (cur_prod_reservations%NOTFOUND) or (l_count=0) THEN
234: IF g_debug <= gme_debug.g_log_procedure THEN
235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' No existing reservations against PRODUCTION supply');
236: END IF;
237: CLOSE cur_prod_reservations;
238: ELSE

Line 235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' No existing reservations against PRODUCTION supply');

231: OPEN cur_prod_reservations(p_so_line_id);
232: FETCH cur_prod_reservations INTO l_count;
233: IF (cur_prod_reservations%NOTFOUND) or (l_count=0) THEN
234: IF g_debug <= gme_debug.g_log_procedure THEN
235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' No existing reservations against PRODUCTION supply');
236: END IF;
237: CLOSE cur_prod_reservations;
238: ELSE
239: IF g_debug <= gme_debug.g_log_procedure THEN

Line 239: IF g_debug <= gme_debug.g_log_procedure THEN

235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' No existing reservations against PRODUCTION supply');
236: END IF;
237: CLOSE cur_prod_reservations;
238: ELSE
239: IF g_debug <= gme_debug.g_log_procedure THEN
240: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Reservations already against PRODUCTION supply so terminate here');
241: END IF;
242: CLOSE cur_prod_reservations;
243: RETURN;

Line 240: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Reservations already against PRODUCTION supply so terminate here');

236: END IF;
237: CLOSE cur_prod_reservations;
238: ELSE
239: IF g_debug <= gme_debug.g_log_procedure THEN
240: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Reservations already against PRODUCTION supply so terminate here');
241: END IF;
242: CLOSE cur_prod_reservations;
243: RETURN;
244: END IF;

Line 247: IF (g_debug <= gme_debug.g_log_statement) THEN

243: RETURN;
244: END IF;
245:
246: /* ============== Start of Order Line Processing ====================*/
247: IF (g_debug <= gme_debug.g_log_statement) THEN
248: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Retrieve the sales order line for line_id '||p_so_line_id);
249: END IF;
250:
251: OPEN get_so_line_rec(p_so_line_id);

Line 248: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Retrieve the sales order line for line_id '||p_so_line_id);

244: END IF;
245:
246: /* ============== Start of Order Line Processing ====================*/
247: IF (g_debug <= gme_debug.g_log_statement) THEN
248: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Retrieve the sales order line for line_id '||p_so_line_id);
249: END IF;
250:
251: OPEN get_so_line_rec(p_so_line_id);
252: FETCH get_so_line_rec INTO l_so_line_rec;

Line 256: IF (g_debug <= gme_debug.g_log_statement) THEN

252: FETCH get_so_line_rec INTO l_so_line_rec;
253:
254: IF(get_so_line_rec%NOTFOUND) THEN
255: CLOSE get_so_line_rec;
256: IF (g_debug <= gme_debug.g_log_statement) THEN
257: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'RETURNING - sales order not found for for line_id '||p_so_line_id);
258: END IF;
259: RAISE FND_API.G_EXC_ERROR;
260: END IF;

Line 257: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'RETURNING - sales order not found for for line_id '||p_so_line_id);

253:
254: IF(get_so_line_rec%NOTFOUND) THEN
255: CLOSE get_so_line_rec;
256: IF (g_debug <= gme_debug.g_log_statement) THEN
257: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'RETURNING - sales order not found for for line_id '||p_so_line_id);
258: END IF;
259: RAISE FND_API.G_EXC_ERROR;
260: END IF;
261: CLOSE get_so_line_rec;

Line 264: IF (g_debug <= gme_debug.g_log_statement) THEN

260: END IF;
261: CLOSE get_so_line_rec;
262:
263: /* ============== Establish Item Characteristics ====================*/
264: IF (g_debug <= gme_debug.g_log_statement) THEN
265: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_so_line_rec.ship_from_org_id);
266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_so_line_rec.inventory_item_id);
267: END IF;
268: OPEN cur_item (l_so_line_rec.ship_from_org_id, l_so_line_rec.inventory_item_id);

Line 265: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_so_line_rec.ship_from_org_id);

261: CLOSE get_so_line_rec;
262:
263: /* ============== Establish Item Characteristics ====================*/
264: IF (g_debug <= gme_debug.g_log_statement) THEN
265: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_so_line_rec.ship_from_org_id);
266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_so_line_rec.inventory_item_id);
267: END IF;
268: OPEN cur_item (l_so_line_rec.ship_from_org_id, l_so_line_rec.inventory_item_id);
269: FETCH cur_item INTO l_item_rec;

Line 266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_so_line_rec.inventory_item_id);

262:
263: /* ============== Establish Item Characteristics ====================*/
264: IF (g_debug <= gme_debug.g_log_statement) THEN
265: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_so_line_rec.ship_from_org_id);
266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_so_line_rec.inventory_item_id);
267: END IF;
268: OPEN cur_item (l_so_line_rec.ship_from_org_id, l_so_line_rec.inventory_item_id);
269: FETCH cur_item INTO l_item_rec;
270: IF(cur_item%NOTFOUND) THEN

Line 272: IF (g_debug <= gme_debug.g_log_statement) THEN

268: OPEN cur_item (l_so_line_rec.ship_from_org_id, l_so_line_rec.inventory_item_id);
269: FETCH cur_item INTO l_item_rec;
270: IF(cur_item%NOTFOUND) THEN
271: CLOSE cur_item;
272: IF (g_debug <= gme_debug.g_log_statement) THEN
273: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Failure to retrieve inventory item ');
274: END IF;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;

Line 273: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Failure to retrieve inventory item ');

269: FETCH cur_item INTO l_item_rec;
270: IF(cur_item%NOTFOUND) THEN
271: CLOSE cur_item;
272: IF (g_debug <= gme_debug.g_log_statement) THEN
273: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Failure to retrieve inventory item ');
274: END IF;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277: CLOSE cur_item;

Line 280: IF (g_debug <= gme_debug.g_log_statement) THEN

276: END IF;
277: CLOSE cur_item;
278:
279: /* ============== Determine whether Make to Order Rule exists ===============*/
280: IF (g_debug <= gme_debug.g_log_statement) THEN
281: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Determine whether make to order rule exists ');
282: END IF;
283:
284: l_in_assignments_rec.organization_id := l_so_line_rec.ship_from_org_id;

Line 281: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Determine whether make to order rule exists ');

277: CLOSE cur_item;
278:
279: /* ============== Determine whether Make to Order Rule exists ===============*/
280: IF (g_debug <= gme_debug.g_log_statement) THEN
281: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Determine whether make to order rule exists ');
282: END IF;
283:
284: l_in_assignments_rec.organization_id := l_so_line_rec.ship_from_org_id;
285: l_in_assignments_rec.inventory_item_id := l_so_line_rec.inventory_item_id;

Line 298: IF (g_debug <= gme_debug.g_log_statement) THEN

294: ,x_return_status => l_return_status
295: ,x_msg_data => l_msg_data
296: ,x_msg_count => l_msg_count);
297:
298: IF (g_debug <= gme_debug.g_log_statement) THEN
299: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
302: END IF;

Line 299: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);

295: ,x_msg_data => l_msg_data
296: ,x_msg_count => l_msg_count);
297:
298: IF (g_debug <= gme_debug.g_log_statement) THEN
299: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
302: END IF;
303:

Line 300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);

296: ,x_msg_count => l_msg_count);
297:
298: IF (g_debug <= gme_debug.g_log_statement) THEN
299: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
302: END IF;
303:
304: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);

297:
298: IF (g_debug <= gme_debug.g_log_statement) THEN
299: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
302: END IF;
303:
304: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
305: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure to Get_Rule so terminate processing for line '||p_so_line_id);

Line 305: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure to Get_Rule so terminate processing for line '||p_so_line_id);

301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
302: END IF;
303:
304: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
305: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure to Get_Rule so terminate processing for line '||p_so_line_id);
306: FND_MESSAGE.Set_Name('GMI','Missing');
307: FND_MESSAGE.Set_Token('MISSING', 'rule_id');
308: FND_MSG_PUB.Add;
309: RAISE FND_API.G_EXC_ERROR;

Line 313: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No MAKE to ORDER rule exists to cover order line '||p_so_line_id);

309: RAISE FND_API.G_EXC_ERROR;
310: END IF;
311:
312: IF (NVL(l_mto_rules_rec.rule_id,0) = 0) THEN
313: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No MAKE to ORDER rule exists to cover order line '||p_so_line_id);
314: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No Further Processing Required for order line '||p_so_line_id);
315: RETURN;
316: END IF;
317:

Line 314: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No Further Processing Required for order line '||p_so_line_id);

310: END IF;
311:
312: IF (NVL(l_mto_rules_rec.rule_id,0) = 0) THEN
313: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No MAKE to ORDER rule exists to cover order line '||p_so_line_id);
314: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No Further Processing Required for order line '||p_so_line_id);
315: RETURN;
316: END IF;
317:
318: /* ============== Start Processing Make to Order Rule ===============*/

Line 319: IF (g_debug <= gme_debug.g_log_statement) THEN

315: RETURN;
316: END IF;
317:
318: /* ============== Start Processing Make to Order Rule ===============*/
319: IF (g_debug <= gme_debug.g_log_statement) THEN
320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Start processing rule definition for '||l_mto_rules_rec.rule_name);
321: END IF;
322:
323: /* ================== Assess the rule for checking available inventory =================*/

Line 320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Start processing rule definition for '||l_mto_rules_rec.rule_name);

316: END IF;
317:
318: /* ============== Start Processing Make to Order Rule ===============*/
319: IF (g_debug <= gme_debug.g_log_statement) THEN
320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Start processing rule definition for '||l_mto_rules_rec.rule_name);
321: END IF;
322:
323: /* ================== Assess the rule for checking available inventory =================*/
324: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 324: IF (g_debug <= gme_debug.g_log_statement) THEN

320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Start processing rule definition for '||l_mto_rules_rec.rule_name);
321: END IF;
322:
323: /* ================== Assess the rule for checking available inventory =================*/
324: IF (g_debug <= gme_debug.g_log_statement) THEN
325: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check Availability set to '||l_mto_rules_rec.check_availability);
326: END IF;
327: IF NVL(l_mto_rules_rec.check_availability,'N') = 'N' THEN
328: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 325: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check Availability set to '||l_mto_rules_rec.check_availability);

321: END IF;
322:
323: /* ================== Assess the rule for checking available inventory =================*/
324: IF (g_debug <= gme_debug.g_log_statement) THEN
325: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check Availability set to '||l_mto_rules_rec.check_availability);
326: END IF;
327: IF NVL(l_mto_rules_rec.check_availability,'N') = 'N' THEN
328: IF (g_debug <= gme_debug.g_log_statement) THEN
329: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for Availabilty check create for full order qty');

Line 328: IF (g_debug <= gme_debug.g_log_statement) THEN

324: IF (g_debug <= gme_debug.g_log_statement) THEN
325: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check Availability set to '||l_mto_rules_rec.check_availability);
326: END IF;
327: IF NVL(l_mto_rules_rec.check_availability,'N') = 'N' THEN
328: IF (g_debug <= gme_debug.g_log_statement) THEN
329: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for Availabilty check create for full order qty');
330: END IF;
331: /* Create a batch for the full order line quantity regardless of onhand availability
332: - Relieve any reservations against inventory; must not duplicate demand

Line 329: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for Availabilty check create for full order qty');

325: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Check Availability set to '||l_mto_rules_rec.check_availability);
326: END IF;
327: IF NVL(l_mto_rules_rec.check_availability,'N') = 'N' THEN
328: IF (g_debug <= gme_debug.g_log_statement) THEN
329: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for Availabilty check create for full order qty');
330: END IF;
331: /* Create a batch for the full order line quantity regardless of onhand availability
332: - Relieve any reservations against inventory; must not duplicate demand
333: ==================================================================================*/

Line 336: IF (g_debug <= gme_debug.g_log_statement) THEN

332: - Relieve any reservations against inventory; must not duplicate demand
333: ==================================================================================*/
334: l_batch_qty := l_so_line_rec.ordered_quantity;
335: l_batch_qty2 := l_so_line_rec.ordered_quantity2;
336: IF (g_debug <= gme_debug.g_log_statement) THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch quantity needed is '||l_batch_qty);
338: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Secondary qty needed is '||l_batch_qty2);
339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve any existing inv reservations ');
340: END IF;

Line 337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch quantity needed is '||l_batch_qty);

333: ==================================================================================*/
334: l_batch_qty := l_so_line_rec.ordered_quantity;
335: l_batch_qty2 := l_so_line_rec.ordered_quantity2;
336: IF (g_debug <= gme_debug.g_log_statement) THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch quantity needed is '||l_batch_qty);
338: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Secondary qty needed is '||l_batch_qty2);
339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve any existing inv reservations ');
340: END IF;
341: OPEN cur_inv_reservations (l_so_line_id);

Line 338: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Secondary qty needed is '||l_batch_qty2);

334: l_batch_qty := l_so_line_rec.ordered_quantity;
335: l_batch_qty2 := l_so_line_rec.ordered_quantity2;
336: IF (g_debug <= gme_debug.g_log_statement) THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch quantity needed is '||l_batch_qty);
338: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Secondary qty needed is '||l_batch_qty2);
339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve any existing inv reservations ');
340: END IF;
341: OPEN cur_inv_reservations (l_so_line_id);
342:

Line 339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve any existing inv reservations ');

335: l_batch_qty2 := l_so_line_rec.ordered_quantity2;
336: IF (g_debug <= gme_debug.g_log_statement) THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch quantity needed is '||l_batch_qty);
338: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Secondary qty needed is '||l_batch_qty2);
339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve any existing inv reservations ');
340: END IF;
341: OPEN cur_inv_reservations (l_so_line_id);
342:
343: FETCH cur_inv_reservations

Line 348: IF (g_debug <= gme_debug.g_log_statement) THEN

344: BULK COLLECT INTO l_rsv_tbl;
345: CLOSE cur_inv_reservations;
346:
347: l_count := 1;
348: IF (g_debug <= gme_debug.g_log_statement) THEN
349: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Loop thru existing reservations for'||l_rsv_tbl.COUNT);
350: END IF;
351: WHILE l_count <= l_rsv_tbl.COUNT LOOP
352: l_rsv_row_rec := l_rsv_tbl(l_count);

Line 349: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Loop thru existing reservations for'||l_rsv_tbl.COUNT);

345: CLOSE cur_inv_reservations;
346:
347: l_count := 1;
348: IF (g_debug <= gme_debug.g_log_statement) THEN
349: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Loop thru existing reservations for'||l_rsv_tbl.COUNT);
350: END IF;
351: WHILE l_count <= l_rsv_tbl.COUNT LOOP
352: l_rsv_row_rec := l_rsv_tbl(l_count);
353: /* Relieve any reservations against INV */

Line 354: IF (g_debug <= gme_debug.g_log_statement) THEN

350: END IF;
351: WHILE l_count <= l_rsv_tbl.COUNT LOOP
352: l_rsv_row_rec := l_rsv_tbl(l_count);
353: /* Relieve any reservations against INV */
354: IF (g_debug <= gme_debug.g_log_statement) THEN
355: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Relieve Reservation here for ID '||l_rsv_row_rec.reservation_id);
356: END IF;
357: gme_reservations_pvt.relieve_reservation
358: (p_reservation_id => l_rsv_row_rec.reservation_id

Line 355: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Relieve Reservation here for ID '||l_rsv_row_rec.reservation_id);

351: WHILE l_count <= l_rsv_tbl.COUNT LOOP
352: l_rsv_row_rec := l_rsv_tbl(l_count);
353: /* Relieve any reservations against INV */
354: IF (g_debug <= gme_debug.g_log_statement) THEN
355: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Relieve Reservation here for ID '||l_rsv_row_rec.reservation_id);
356: END IF;
357: gme_reservations_pvt.relieve_reservation
358: (p_reservation_id => l_rsv_row_rec.reservation_id
359: ,p_prim_relieve_qty => l_rsv_row_rec.primary_reservation_quantity

Line 362: IF g_debug <= gme_debug.g_log_statement THEN

358: (p_reservation_id => l_rsv_row_rec.reservation_id
359: ,p_prim_relieve_qty => l_rsv_row_rec.primary_reservation_quantity
360: ,x_return_status => x_return_status);
361:
362: IF g_debug <= gme_debug.g_log_statement THEN
363: gme_debug.put_line
364: ( g_pkg_name
365: || '.'
366: || l_api_name

Line 363: gme_debug.put_line

359: ,p_prim_relieve_qty => l_rsv_row_rec.primary_reservation_quantity
360: ,x_return_status => x_return_status);
361:
362: IF g_debug <= gme_debug.g_log_statement THEN
363: gme_debug.put_line
364: ( g_pkg_name
365: || '.'
366: || l_api_name
367: || ' Return status from relieve_reservation is '

Line 381: IF (g_debug <= gme_debug.g_log_statement) THEN

377:
378: /* Deal with cases where check on availability is required
379: ========================================================= */
380: IF NVL(l_mto_rules_rec.check_availability,'N') = 'Y' THEN
381: IF (g_debug <= gme_debug.g_log_statement) THEN
382: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NEED to check Inventory Availabilty ahead of creating batch');
383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' start point is the order qty ' ||l_so_line_rec.ordered_quantity);
384: END IF;
385: /* Find out how much quantity needs to be manufactured to meet inventory shortfall */

Line 382: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NEED to check Inventory Availabilty ahead of creating batch');

378: /* Deal with cases where check on availability is required
379: ========================================================= */
380: IF NVL(l_mto_rules_rec.check_availability,'N') = 'Y' THEN
381: IF (g_debug <= gme_debug.g_log_statement) THEN
382: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NEED to check Inventory Availabilty ahead of creating batch');
383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' start point is the order qty ' ||l_so_line_rec.ordered_quantity);
384: END IF;
385: /* Find out how much quantity needs to be manufactured to meet inventory shortfall */
386: /* step 1 - what is the current unreserved quantity

Line 383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' start point is the order qty ' ||l_so_line_rec.ordered_quantity);

379: ========================================================= */
380: IF NVL(l_mto_rules_rec.check_availability,'N') = 'Y' THEN
381: IF (g_debug <= gme_debug.g_log_statement) THEN
382: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NEED to check Inventory Availabilty ahead of creating batch');
383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' start point is the order qty ' ||l_so_line_rec.ordered_quantity);
384: END IF;
385: /* Find out how much quantity needs to be manufactured to meet inventory shortfall */
386: /* step 1 - what is the current unreserved quantity
387: =======================================================*/

Line 421: IF (g_debug <= gme_debug.g_log_statement) THEN

417: exception when no_data_found then
418: null;
419: end;
420:
421: IF (g_debug <= gme_debug.g_log_statement) THEN
422: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Deduct qty already reserved, this is '||l_total_primary_rsv_qty);
423: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Now batch qty required stands at '||l_batch_qty);
424: END IF;
425: IF (l_batch_qty <= 0) THEN

Line 422: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Deduct qty already reserved, this is '||l_total_primary_rsv_qty);

418: null;
419: end;
420:
421: IF (g_debug <= gme_debug.g_log_statement) THEN
422: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Deduct qty already reserved, this is '||l_total_primary_rsv_qty);
423: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Now batch qty required stands at '||l_batch_qty);
424: END IF;
425: IF (l_batch_qty <= 0) THEN
426: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 423: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Now batch qty required stands at '||l_batch_qty);

419: end;
420:
421: IF (g_debug <= gme_debug.g_log_statement) THEN
422: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Deduct qty already reserved, this is '||l_total_primary_rsv_qty);
423: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Now batch qty required stands at '||l_batch_qty);
424: END IF;
425: IF (l_batch_qty <= 0) THEN
426: IF (g_debug <= gme_debug.g_log_statement) THEN
427: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Full Order Qty already reserved to INV');

Line 426: IF (g_debug <= gme_debug.g_log_statement) THEN

422: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Deduct qty already reserved, this is '||l_total_primary_rsv_qty);
423: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Now batch qty required stands at '||l_batch_qty);
424: END IF;
425: IF (l_batch_qty <= 0) THEN
426: IF (g_debug <= gme_debug.g_log_statement) THEN
427: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Full Order Qty already reserved to INV');
428: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for batch creation Return here');
429: END IF;
430: RETURN;

Line 427: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Full Order Qty already reserved to INV');

423: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Now batch qty required stands at '||l_batch_qty);
424: END IF;
425: IF (l_batch_qty <= 0) THEN
426: IF (g_debug <= gme_debug.g_log_statement) THEN
427: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Full Order Qty already reserved to INV');
428: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for batch creation Return here');
429: END IF;
430: RETURN;
431: END IF;

Line 428: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for batch creation Return here');

424: END IF;
425: IF (l_batch_qty <= 0) THEN
426: IF (g_debug <= gme_debug.g_log_statement) THEN
427: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Full Order Qty already reserved to INV');
428: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' No need for batch creation Return here');
429: END IF;
430: RETURN;
431: END IF;
432:

Line 441: IF (g_debug <= gme_debug.g_log_statement) THEN

437: l_is_lot_control := TRUE;
438: END IF;
439:
440: -- set controls for locator and serial
441: IF (g_debug <= gme_debug.g_log_statement) THEN
442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Need to assess ATR level so invoke create tree');
443: END IF;
444:
445: inv_quantity_tree_pvt.create_tree

Line 442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Need to assess ATR level so invoke create tree');

438: END IF;
439:
440: -- set controls for locator and serial
441: IF (g_debug <= gme_debug.g_log_statement) THEN
442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Need to assess ATR level so invoke create tree');
443: END IF;
444:
445: inv_quantity_tree_pvt.create_tree
446: (

Line 469: IF (g_debug <= gme_debug.g_log_statement) THEN

465: , p_lot_expiration_date => SYSDATE
466: , x_tree_id => l_tree_id
467: );
468:
469: IF (g_debug <= gme_debug.g_log_statement) THEN
470: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' After create tree status returned is '||l_return_status);
471: END IF;
472:
473: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 470: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' After create tree status returned is '||l_return_status);

466: , x_tree_id => l_tree_id
467: );
468:
469: IF (g_debug <= gme_debug.g_log_statement) THEN
470: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' After create tree status returned is '||l_return_status);
471: END IF;
472:
473: IF l_return_status = fnd_api.g_ret_sts_error THEN
474: RAISE fnd_api.g_exc_error;

Line 481: IF (g_debug <= gme_debug.g_log_statement) THEN

477: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;
480:
481: IF (g_debug <= gme_debug.g_log_statement) THEN
482: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Query tree for ATR next ');
483: END IF;
484: inv_quantity_tree_pvt.query_tree(
485: p_api_version_number => 1.0

Line 482: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Query tree for ATR next ');

478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;
480:
481: IF (g_debug <= gme_debug.g_log_statement) THEN
482: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Query tree for ATR next ');
483: END IF;
484: inv_quantity_tree_pvt.query_tree(
485: p_api_version_number => 1.0
486: , p_init_msg_lst => fnd_api.g_true

Line 510: IF (g_debug <= gme_debug.g_log_statement) THEN

506: , x_satr => l_satr
507: , p_lpn_id => l_lpn_id
508: );
509:
510: IF (g_debug <= gme_debug.g_log_statement) THEN
511: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' After Query tree return status is '||l_return_status);
512: END IF;
513: IF l_return_status = fnd_api.g_ret_sts_error THEN
514: RAISE fnd_api.g_exc_error;

Line 511: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' After Query tree return status is '||l_return_status);

507: , p_lpn_id => l_lpn_id
508: );
509:
510: IF (g_debug <= gme_debug.g_log_statement) THEN
511: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' After Query tree return status is '||l_return_status);
512: END IF;
513: IF l_return_status = fnd_api.g_ret_sts_error THEN
514: RAISE fnd_api.g_exc_error;
515: END IF;

Line 521: IF (g_debug <= gme_debug.g_log_statement) THEN

517: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
518: RAISE fnd_api.g_exc_unexpected_error;
519: END IF;
520:
521: IF (g_debug <= gme_debug.g_log_statement) THEN
522: gme_debug.put_line('l_atr ' || l_atr);
523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);

Line 522: gme_debug.put_line('l_atr ' || l_atr);

518: RAISE fnd_api.g_exc_unexpected_error;
519: END IF;
520:
521: IF (g_debug <= gme_debug.g_log_statement) THEN
522: gme_debug.put_line('l_atr ' || l_atr);
523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);

Line 523: gme_debug.put_line('l_att ' || l_att);

519: END IF;
520:
521: IF (g_debug <= gme_debug.g_log_statement) THEN
522: gme_debug.put_line('l_atr ' || l_atr);
523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);

Line 524: gme_debug.put_line('l_qoh ' || l_qoh);

520:
521: IF (g_debug <= gme_debug.g_log_statement) THEN
522: gme_debug.put_line('l_atr ' || l_atr);
523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);

Line 525: gme_debug.put_line('l_rqoh ' || l_rqoh);

521: IF (g_debug <= gme_debug.g_log_statement) THEN
522: gme_debug.put_line('l_atr ' || l_atr);
523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);

Line 526: gme_debug.put_line('l_qr ' || l_qr);

522: gme_debug.put_line('l_atr ' || l_atr);
523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);

Line 527: gme_debug.put_line('l_qs ' || l_qs);

523: gme_debug.put_line('l_att ' || l_att);
524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);

Line 528: gme_debug.put_line('l_satr ' || l_satr);

524: gme_debug.put_line('l_qoh ' || l_qoh);
525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);
532: gme_debug.put_line('l_sqr ' || l_sqr);

Line 529: gme_debug.put_line('l_satt ' || l_satt);

525: gme_debug.put_line('l_rqoh ' || l_rqoh);
526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);
532: gme_debug.put_line('l_sqr ' || l_sqr);
533: gme_debug.put_line('l_sqs ' || l_sqs);

Line 530: gme_debug.put_line('l_sqoh ' || l_sqoh);

526: gme_debug.put_line('l_qr ' || l_qr);
527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);
532: gme_debug.put_line('l_sqr ' || l_sqr);
533: gme_debug.put_line('l_sqs ' || l_sqs);
534: END IF;

Line 531: gme_debug.put_line('l_srqoh ' || l_srqoh);

527: gme_debug.put_line('l_qs ' || l_qs);
528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);
532: gme_debug.put_line('l_sqr ' || l_sqr);
533: gme_debug.put_line('l_sqs ' || l_sqs);
534: END IF;
535: /* Deduct any ATR from the manufacture qty */

Line 532: gme_debug.put_line('l_sqr ' || l_sqr);

528: gme_debug.put_line('l_satr ' || l_satr);
529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);
532: gme_debug.put_line('l_sqr ' || l_sqr);
533: gme_debug.put_line('l_sqs ' || l_sqs);
534: END IF;
535: /* Deduct any ATR from the manufacture qty */
536: /* Convert atr quantity into Orderline UOM */

Line 533: gme_debug.put_line('l_sqs ' || l_sqs);

529: gme_debug.put_line('l_satt ' || l_satt);
530: gme_debug.put_line('l_sqoh ' || l_sqoh);
531: gme_debug.put_line('l_srqoh ' || l_srqoh);
532: gme_debug.put_line('l_sqr ' || l_sqr);
533: gme_debug.put_line('l_sqs ' || l_sqs);
534: END IF;
535: /* Deduct any ATR from the manufacture qty */
536: /* Convert atr quantity into Orderline UOM */
537: IF l_so_line_rec.order_quantity_uom <> l_primary_uom_code THEN

Line 552: gme_debug.put_line('Stock is available to meet the demand so batch creation not necessary ');

548: END IF;
549: IF l_atr >= l_batch_qty THEN
550: /* Stock is available to reserve to meet the sales quantity so no further
551: * action required */
552: gme_debug.put_line('Stock is available to meet the demand so batch creation not necessary ');
553: END IF;
554: l_batch_qty := l_batch_qty - l_atr;
555: END IF; -- End of check availability
556:

Line 559: IF (g_debug <= gme_debug.g_log_statement) THEN

555: END IF; -- End of check availability
556:
557: FND_FILE.Put_Line(FND_FILE.LOG, 'END of section for MUST check availability ');
558: FND_FILE.Put_Line(FND_FILE.LOG, ' batch qty now stands at '||l_batch_qty );
559: IF (g_debug <= gme_debug.g_log_statement) THEN
560: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' End of availability checking and batch qty now '||l_batch_qty);
561: END IF;
562: /* Now set up data and invoke create_batch
563: ==========================================*/

Line 560: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' End of availability checking and batch qty now '||l_batch_qty);

556:
557: FND_FILE.Put_Line(FND_FILE.LOG, 'END of section for MUST check availability ');
558: FND_FILE.Put_Line(FND_FILE.LOG, ' batch qty now stands at '||l_batch_qty );
559: IF (g_debug <= gme_debug.g_log_statement) THEN
560: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' End of availability checking and batch qty now '||l_batch_qty);
561: END IF;
562: /* Now set up data and invoke create_batch
563: ==========================================*/
564: IF (l_batch_qty <= 0) THEN

Line 565: IF (g_debug <= gme_debug.g_log_statement) THEN

561: END IF;
562: /* Now set up data and invoke create_batch
563: ==========================================*/
564: IF (l_batch_qty <= 0) THEN
565: IF (g_debug <= gme_debug.g_log_statement) THEN
566: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Entire requested qty aviaable in inventory so Return now');
567: END IF;
568: RETURN;
569: END IF;

Line 566: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Entire requested qty aviaable in inventory so Return now');

562: /* Now set up data and invoke create_batch
563: ==========================================*/
564: IF (l_batch_qty <= 0) THEN
565: IF (g_debug <= gme_debug.g_log_statement) THEN
566: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Entire requested qty aviaable in inventory so Return now');
567: END IF;
568: RETURN;
569: END IF;
570:

Line 579: gme_debug.put_line('populate the batch record in readiness for create_batch API');

575: END IF;
576:
577: /* Now populate the batch record so you can call Create Batch API */
578:
579: gme_debug.put_line('populate the batch record in readiness for create_batch API');
580: l_batch_header_rec.batch_type := l_mto_rules_rec.batch_type_to_create;
581: l_batch_header_rec.organization_id := l_so_line_rec.ship_from_org_id;
582: l_batch_header_rec.plan_start_date := SYSDATE;
583: l_batch_header_rec.update_inventory_ind := 'Y';

Line 593: IF (g_debug <= gme_debug.g_log_statement) THEN

589: FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
590:
591: IF l_mto_rules_rec.batch_creation_user is not NULL THEN
592: IF (l_mto_rules_rec.batch_creation_user <> l_user_id) THEN
593: IF (g_debug <= gme_debug.g_log_statement) THEN
594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch creation user is '||l_mto_rules_rec.batch_creation_user);
595: END IF;
596: FND_GLOBAL.apps_initialize(l_mto_rules_rec.batch_creation_user,-1,-1);
597: END IF;

Line 594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch creation user is '||l_mto_rules_rec.batch_creation_user);

590:
591: IF l_mto_rules_rec.batch_creation_user is not NULL THEN
592: IF (l_mto_rules_rec.batch_creation_user <> l_user_id) THEN
593: IF (g_debug <= gme_debug.g_log_statement) THEN
594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch creation user is '||l_mto_rules_rec.batch_creation_user);
595: END IF;
596: FND_GLOBAL.apps_initialize(l_mto_rules_rec.batch_creation_user,-1,-1);
597: END IF;
598: END IF;

Line 600: gme_debug.put_line('Calling Create Batch API');

596: FND_GLOBAL.apps_initialize(l_mto_rules_rec.batch_creation_user,-1,-1);
597: END IF;
598: END IF;
599:
600: gme_debug.put_line('Calling Create Batch API');
601: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch API ');
602: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch qty needed is '||l_batch_qty);
603: IF (g_debug <= gme_debug.g_log_statement) THEN
604: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');

Line 603: IF (g_debug <= gme_debug.g_log_statement) THEN

599:
600: gme_debug.put_line('Calling Create Batch API');
601: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch API ');
602: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch qty needed is '||l_batch_qty);
603: IF (g_debug <= gme_debug.g_log_statement) THEN
604: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
605: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
606: END IF;
607: GME_API_PUB.create_batch(

Line 604: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');

600: gme_debug.put_line('Calling Create Batch API');
601: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch API ');
602: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch qty needed is '||l_batch_qty);
603: IF (g_debug <= gme_debug.g_log_statement) THEN
604: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
605: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
606: END IF;
607: GME_API_PUB.create_batch(
608: p_api_version => 2.0,

Line 605: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);

601: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch API ');
602: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch qty needed is '||l_batch_qty);
603: IF (g_debug <= gme_debug.g_log_statement) THEN
604: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
605: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
606: END IF;
607: GME_API_PUB.create_batch(
608: p_api_version => 2.0,
609: p_validation_level => 100,

Line 634: IF (g_debug <= gme_debug.g_log_statement) THEN

630: p_use_least_cost_validity_rule => fnd_api.g_false,
631: x_exception_material_tbl => l_exception_material_tbl
632: );
633:
634: IF (g_debug <= gme_debug.g_log_statement) THEN
635: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from Create_Batch API is '||l_return_status);
636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Message from Create_Batch API is '||l_msg_data );
637: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch No from Create_Batch API is '||
638: l_out_batch_header_rec.batch_no);

Line 635: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from Create_Batch API is '||l_return_status);

631: x_exception_material_tbl => l_exception_material_tbl
632: );
633:
634: IF (g_debug <= gme_debug.g_log_statement) THEN
635: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from Create_Batch API is '||l_return_status);
636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Message from Create_Batch API is '||l_msg_data );
637: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch No from Create_Batch API is '||
638: l_out_batch_header_rec.batch_no);
639: END IF;

Line 636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Message from Create_Batch API is '||l_msg_data );

632: );
633:
634: IF (g_debug <= gme_debug.g_log_statement) THEN
635: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from Create_Batch API is '||l_return_status);
636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Message from Create_Batch API is '||l_msg_data );
637: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch No from Create_Batch API is '||
638: l_out_batch_header_rec.batch_no);
639: END IF;
640: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 637: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch No from Create_Batch API is '||

633:
634: IF (g_debug <= gme_debug.g_log_statement) THEN
635: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from Create_Batch API is '||l_return_status);
636: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Message from Create_Batch API is '||l_msg_data );
637: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch No from Create_Batch API is '||
638: l_out_batch_header_rec.batch_no);
639: END IF;
640: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
641: j := to_number(NVL(l_msg_count,0));

Line 647: gme_debug.put_line(l_message);

643: LOOP
644:
645: l_message := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);
646: l_message := replace(l_message, chr(0), ' ');
647: gme_debug.put_line(l_message);
648: END LOOP;
649: RAISE fnd_api.g_exc_error;
650: END IF;
651:

Line 654: IF (g_debug <= gme_debug.g_log_statement) THEN

650: END IF;
651:
652: /* Now retrieve the batch product line - sales order line must reserve to this supply
653: ===================================================================================*/
654: IF (g_debug <= gme_debug.g_log_statement) THEN
655: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve product line - must reserve to this supply');
656: END IF;
657: OPEN get_batch_line(l_out_batch_header_rec.batch_id,l_so_line_rec.inventory_item_id);
658: FETCH get_batch_line INTO l_material_detail_rec;

Line 655: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve product line - must reserve to this supply');

651:
652: /* Now retrieve the batch product line - sales order line must reserve to this supply
653: ===================================================================================*/
654: IF (g_debug <= gme_debug.g_log_statement) THEN
655: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve product line - must reserve to this supply');
656: END IF;
657: OPEN get_batch_line(l_out_batch_header_rec.batch_id,l_so_line_rec.inventory_item_id);
658: FETCH get_batch_line INTO l_material_detail_rec;
659:

Line 662: IF (g_debug <= gme_debug.g_log_statement) THEN

658: FETCH get_batch_line INTO l_material_detail_rec;
659:
660: IF(get_batch_line%NOTFOUND) THEN
661: CLOSE get_batch_line;
662: IF (g_debug <= gme_debug.g_log_statement) THEN
663: gme_debug.put_line('get_batch_line%NOTFOUND, returning from create_batch_for_order_line');
664: END IF;
665: RAISE fnd_api.g_exc_error;
666: END IF;

Line 663: gme_debug.put_line('get_batch_line%NOTFOUND, returning from create_batch_for_order_line');

659:
660: IF(get_batch_line%NOTFOUND) THEN
661: CLOSE get_batch_line;
662: IF (g_debug <= gme_debug.g_log_statement) THEN
663: gme_debug.put_line('get_batch_line%NOTFOUND, returning from create_batch_for_order_line');
664: END IF;
665: RAISE fnd_api.g_exc_error;
666: END IF;
667: CLOSE get_batch_line;

Line 671: IF (g_debug <= gme_debug.g_log_statement) THEN

667: CLOSE get_batch_line;
668:
669: /* Copy Attachments if the rule says so
670: ===================================== */
671: IF (g_debug <= gme_debug.g_log_statement) THEN
672: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse copy attachments '||l_mto_rules_rec.copy_attachments);
673: END IF;
674: IF (NVL(l_mto_rules_rec.copy_attachments,'N') = 'Y') THEN
675: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 672: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse copy attachments '||l_mto_rules_rec.copy_attachments);

668:
669: /* Copy Attachments if the rule says so
670: ===================================== */
671: IF (g_debug <= gme_debug.g_log_statement) THEN
672: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse copy attachments '||l_mto_rules_rec.copy_attachments);
673: END IF;
674: IF (NVL(l_mto_rules_rec.copy_attachments,'N') = 'Y') THEN
675: IF (g_debug <= gme_debug.g_log_statement) THEN
676: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke copy attachments ');

Line 675: IF (g_debug <= gme_debug.g_log_statement) THEN

671: IF (g_debug <= gme_debug.g_log_statement) THEN
672: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse copy attachments '||l_mto_rules_rec.copy_attachments);
673: END IF;
674: IF (NVL(l_mto_rules_rec.copy_attachments,'N') = 'Y') THEN
675: IF (g_debug <= gme_debug.g_log_statement) THEN
676: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke copy attachments ');
677: END IF;
678: copy_attachments( p_so_line_id => l_so_line_id
679: , p_so_category_id => l_mto_rules_rec.sales_order_attachment

Line 676: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke copy attachments ');

672: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse copy attachments '||l_mto_rules_rec.copy_attachments);
673: END IF;
674: IF (NVL(l_mto_rules_rec.copy_attachments,'N') = 'Y') THEN
675: IF (g_debug <= gme_debug.g_log_statement) THEN
676: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke copy attachments ');
677: END IF;
678: copy_attachments( p_so_line_id => l_so_line_id
679: , p_so_category_id => l_mto_rules_rec.sales_order_attachment
680: , p_batch_id => l_out_batch_header_rec.batch_id

Line 684: IF (g_debug <= gme_debug.g_log_statement) THEN

680: , p_batch_id => l_out_batch_header_rec.batch_id
681: , p_batch_category_id => l_mto_rules_rec.batch_attachment
682: , x_return_status => l_return_status);
683:
684: IF (g_debug <= gme_debug.g_log_statement) THEN
685: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from copy attachments '||l_return_status);
686: END IF;
687: END IF;
688:

Line 685: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from copy attachments '||l_return_status);

681: , p_batch_category_id => l_mto_rules_rec.batch_attachment
682: , x_return_status => l_return_status);
683:
684: IF (g_debug <= gme_debug.g_log_statement) THEN
685: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from copy attachments '||l_return_status);
686: END IF;
687: END IF;
688:
689: /* Need to set up pending lots if the product is lot controlled and the rule requires lot generation

Line 691: IF (g_debug <= gme_debug.g_log_statement) THEN

687: END IF;
688:
689: /* Need to set up pending lots if the product is lot controlled and the rule requires lot generation
690: =======================================================================================================*/
691: IF (g_debug <= gme_debug.g_log_statement) THEN
692: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse auto lot generation'||l_mto_rules_rec.auto_lot_generation);
693: END IF;
694: IF l_item_rec.SECONDARY_UOM_CODE is not null then
695: l_batch_qty2 := inv_convert.inv_um_convert(l_so_line_rec.inventory_item_id,

Line 692: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse auto lot generation'||l_mto_rules_rec.auto_lot_generation);

688:
689: /* Need to set up pending lots if the product is lot controlled and the rule requires lot generation
690: =======================================================================================================*/
691: IF (g_debug <= gme_debug.g_log_statement) THEN
692: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' analyse auto lot generation'||l_mto_rules_rec.auto_lot_generation);
693: END IF;
694: IF l_item_rec.SECONDARY_UOM_CODE is not null then
695: l_batch_qty2 := inv_convert.inv_um_convert(l_so_line_rec.inventory_item_id,
696: null,

Line 714: IF (g_debug <= gme_debug.g_log_statement) THEN

710: l_pending_product_lots_rec.lot_number := null;
711: l_pending_product_lots_rec.quantity := l_batch_qty;
712: l_pending_product_lots_rec.secondary_quantity := l_batch_qty2;
713:
714: IF (g_debug <= gme_debug.g_log_statement) THEN
715: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
716: ' Invoke create_pending_product_lot for line_id '||l_material_detail_rec.material_detail_id);
717: END IF;
718:

Line 715: gme_debug.put_line(g_pkg_name||'.'||l_api_name||

711: l_pending_product_lots_rec.quantity := l_batch_qty;
712: l_pending_product_lots_rec.secondary_quantity := l_batch_qty2;
713:
714: IF (g_debug <= gme_debug.g_log_statement) THEN
715: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
716: ' Invoke create_pending_product_lot for line_id '||l_material_detail_rec.material_detail_id);
717: END IF;
718:
719: GME_API_PUB.create_pending_product_lot

Line 736: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FAILURE to generate pending lot ');

732: ,p_pending_product_lots_rec => l_pending_product_lots_rec
733: ,x_pending_product_lots_rec => l_out_pending_product_lots_rec);
734:
735: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
736: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FAILURE to generate pending lot ');
737: END IF;
738: END IF; -- End of pending lot generation
739:
740: gme_debug.put_line('Reserve the batch Quantity to this order line');

Line 740: gme_debug.put_line('Reserve the batch Quantity to this order line');

736: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FAILURE to generate pending lot ');
737: END IF;
738: END IF; -- End of pending lot generation
739:
740: gme_debug.put_line('Reserve the batch Quantity to this order line');
741: /* Establish a reservation between the order line (demand) and batch product (supply)
742: ====================================================================================*/
743: FND_FILE.Put_Line(FND_FILE.LOG, ' start of Reservation Processing ');
744: l_rsv_rec:= NULL;

Line 773: IF (g_debug <= gme_debug.g_log_statement) THEN

769: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
770: l_rsv_rec.supply_source_header_id := l_out_batch_header_rec.batch_id;
771: l_rsv_rec.supply_source_line_id := l_material_detail_rec.material_detail_id;
772:
773: IF (g_debug <= gme_debug.g_log_statement) THEN
774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke INV_RESERVATION_PUB.Create_Reservation ');
775: END IF;
776:
777: inv_reservation_pub.create_reservation

Line 774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke INV_RESERVATION_PUB.Create_Reservation ');

770: l_rsv_rec.supply_source_header_id := l_out_batch_header_rec.batch_id;
771: l_rsv_rec.supply_source_line_id := l_material_detail_rec.material_detail_id;
772:
773: IF (g_debug <= gme_debug.g_log_statement) THEN
774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke INV_RESERVATION_PUB.Create_Reservation ');
775: END IF;
776:
777: inv_reservation_pub.create_reservation
778: (p_api_version_number => 1.0

Line 792: IF (g_debug <= gme_debug.g_log_statement) THEN

788: ,x_quantity_reserved => l_reserved_qty
789: ,x_reservation_id => l_reservation_id
790: ,p_partial_rsv_exists => TRUE);
791:
792: IF (g_debug <= gme_debug.g_log_statement) THEN
793: gme_debug.put_line ( g_pkg_name
794: || '.'
795: || l_api_name
796: || ' inv_reservation_pub.create_reservation returns status of '

Line 793: gme_debug.put_line ( g_pkg_name

789: ,x_reservation_id => l_reservation_id
790: ,p_partial_rsv_exists => TRUE);
791:
792: IF (g_debug <= gme_debug.g_log_statement) THEN
793: gme_debug.put_line ( g_pkg_name
794: || '.'
795: || l_api_name
796: || ' inv_reservation_pub.create_reservation returns status of '
797: || l_return_status

Line 811: IF (g_debug <= gme_debug.g_log_statement) THEN

807: END IF;
808:
809: /* Notify the customer sales representative of the batch creation
810: ===============================================================*/
811: IF (g_debug <= gme_debug.g_log_statement) THEN
812: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);
813: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);
814: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for sales_line_id'||l_rsv_rec.demand_source_line_id);
815: END IF;

Line 812: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);

808:
809: /* Notify the customer sales representative of the batch creation
810: ===============================================================*/
811: IF (g_debug <= gme_debug.g_log_statement) THEN
812: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);
813: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);
814: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for sales_line_id'||l_rsv_rec.demand_source_line_id);
815: END IF;
816: --FND_GLOBAL.apps_initialize(l_user_id,-1,-1);

Line 813: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);

809: /* Notify the customer sales representative of the batch creation
810: ===============================================================*/
811: IF (g_debug <= gme_debug.g_log_statement) THEN
812: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);
813: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);
814: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for sales_line_id'||l_rsv_rec.demand_source_line_id);
815: END IF;
816: --FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
817: GME_SUPPLY_RES_PVT.notify_CSR

Line 814: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for sales_line_id'||l_rsv_rec.demand_source_line_id);

810: ===============================================================*/
811: IF (g_debug <= gme_debug.g_log_statement) THEN
812: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);
813: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);
814: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for sales_line_id'||l_rsv_rec.demand_source_line_id);
815: END IF;
816: --FND_GLOBAL.apps_initialize(l_user_id,-1,-1);
817: GME_SUPPLY_RES_PVT.notify_CSR
818: ( P_Batch_id => l_rsv_rec.supply_source_header_id

Line 828: IF g_debug <= gme_debug.g_log_procedure THEN

824: , X_return_status => l_return_status
825: , X_msg_cont => l_msg_count
826: , X_msg_data => l_msg_data );
827:
828: IF g_debug <= gme_debug.g_log_procedure THEN
829: gme_debug.put_line ( g_pkg_name || '.'
830: || l_api_name
831: || ' after calling notify_CSR for create reservation status is '
832: || l_return_status );

Line 829: gme_debug.put_line ( g_pkg_name || '.'

825: , X_msg_cont => l_msg_count
826: , X_msg_data => l_msg_data );
827:
828: IF g_debug <= gme_debug.g_log_procedure THEN
829: gme_debug.put_line ( g_pkg_name || '.'
830: || l_api_name
831: || ' after calling notify_CSR for create reservation status is '
832: || l_return_status );
833: END IF;

Line 836: IF g_debug <= gme_debug.g_log_procedure THEN

832: || l_return_status );
833: END IF;
834:
835: IF l_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) THEN
836: IF g_debug <= gme_debug.g_log_procedure THEN
837: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Exit after Notifications Failure ');
838: END IF;
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;

Line 837: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Exit after Notifications Failure ');

833: END IF;
834:
835: IF l_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) THEN
836: IF g_debug <= gme_debug.g_log_procedure THEN
837: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Exit after Notifications Failure ');
838: END IF;
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:

Line 852: IF g_debug <= gme_debug.g_log_procedure THEN

848: OPEN Get_order_info(p_so_line_id);
849: FETCH Get_order_info INTO l_so_line_no,l_item_no,
850: l_order_no;
851: IF(Get_order_info%NOTFOUND) THEN
852: IF g_debug <= gme_debug.g_log_procedure THEN
853: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');
854: END IF;
855: END IF;
856: CLOSE Get_order_info;

Line 853: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');

849: FETCH Get_order_info INTO l_so_line_no,l_item_no,
850: l_order_no;
851: IF(Get_order_info%NOTFOUND) THEN
852: IF g_debug <= gme_debug.g_log_procedure THEN
853: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');
854: END IF;
855: END IF;
856: CLOSE Get_order_info;
857: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');

Line 869: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));

865: ====================*/
866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: -- ROLLBACK TO SAVEPOINT create_batch_for_so_line_SP;
869: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));
870: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: -- errbuf := SUBSTRB(SQLERRM, 1, 150);
873: -- retcode := x_return_status;

Line 870: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));

866: EXCEPTION
867: WHEN FND_API.G_EXC_ERROR THEN
868: -- ROLLBACK TO SAVEPOINT create_batch_for_so_line_SP;
869: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));
870: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: -- errbuf := SUBSTRB(SQLERRM, 1, 150);
873: -- retcode := x_return_status;
874:

Line 885: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));

881: );
882:
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: -- ROLLBACK TO SAVEPOINT create_batch_for_so_line_SP;
885: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));
886: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
887:
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
889: -- errbuf := SUBSTRB(SQLERRM, 1, 150);

Line 886: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));

882:
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: -- ROLLBACK TO SAVEPOINT create_batch_for_so_line_SP;
885: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));
886: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
887:
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
889: -- errbuf := SUBSTRB(SQLERRM, 1, 150);
890: -- retcode := x_return_status;

Line 902: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));

898: , p_data => x_msg_data
899: );
900: WHEN OTHERS THEN
901: --ROLLBACK TO SAVEPOINT create_batch_for_so_line_SP;
902: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));
903: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
904:
905: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name
906: , l_api_name

Line 903: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));

899: );
900: WHEN OTHERS THEN
901: --ROLLBACK TO SAVEPOINT create_batch_for_so_line_SP;
902: gme_debug.put_line('sqlcode : ' ||to_char(sqlcode));
903: gme_debug.put_line('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
904:
905: FND_MSG_PUB.Add_Exc_Msg ( g_pkg_name
906: , l_api_name
907: );

Line 940: gme_debug.put_line('Entering copy_attachemnts routine..');

936: AND ((entity_name = 'OE_ORDER_LINES') AND (pk1_value = p_so_line_id ));
937:
938:
939: BEGIN
940: gme_debug.put_line('Entering copy_attachemnts routine..');
941: FOR so_attchments_row IN get_attachments(p_so_category_id,p_so_line_id) LOOP
942:
943: so_attchments_row.row_id := NULL;
944: so_attchments_row.document_id := NULL;

Line 1017: gme_debug.put_line('Exiting copy_attachments procedure without any errors');

1013: );
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015: END LOOP;
1016:
1017: gme_debug.put_line('Exiting copy_attachments procedure without any errors');
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: GMI_RESERVATION_UTIL.Println('In others exception in copy_attachments');
1021: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1051: IF (g_debug <= gme_debug.g_log_statement) THEN

1047: FROM mtl_system_items_b m
1048: WHERE m.inventory_item_id = p_inventory_item_id
1049: AND m.organization_id = p_organization_id;
1050: BEGIN
1051: IF (g_debug <= gme_debug.g_log_statement) THEN
1052: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER FUNCTION '||l_api_name||' for line '||p_line_id);
1053: gme_debug.put_line ( '*** function call to check if order line qualifies for OPM make to order ***' );
1054: END IF;
1055:

Line 1052: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER FUNCTION '||l_api_name||' for line '||p_line_id);

1048: WHERE m.inventory_item_id = p_inventory_item_id
1049: AND m.organization_id = p_organization_id;
1050: BEGIN
1051: IF (g_debug <= gme_debug.g_log_statement) THEN
1052: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER FUNCTION '||l_api_name||' for line '||p_line_id);
1053: gme_debug.put_line ( '*** function call to check if order line qualifies for OPM make to order ***' );
1054: END IF;
1055:
1056: /* ============== Retrieve Order line data ====================*/

Line 1053: gme_debug.put_line ( '*** function call to check if order line qualifies for OPM make to order ***' );

1049: AND m.organization_id = p_organization_id;
1050: BEGIN
1051: IF (g_debug <= gme_debug.g_log_statement) THEN
1052: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER FUNCTION '||l_api_name||' for line '||p_line_id);
1053: gme_debug.put_line ( '*** function call to check if order line qualifies for OPM make to order ***' );
1054: END IF;
1055:
1056: /* ============== Retrieve Order line data ====================*/
1057: OPEN get_order_line_rec(p_line_id);

Line 1063: IF (g_debug <= gme_debug.g_log_statement) THEN

1059:
1060:
1061: IF(get_order_line_rec%NOTFOUND) THEN
1062: CLOSE get_order_line_rec;
1063: IF (g_debug <= gme_debug.g_log_statement) THEN
1064: gme_debug.put_line('get_order_line_rec%NOTFOUND, RETURN now');
1065: END IF;
1066: Return FALSE;
1067: END IF;

Line 1064: gme_debug.put_line('get_order_line_rec%NOTFOUND, RETURN now');

1060:
1061: IF(get_order_line_rec%NOTFOUND) THEN
1062: CLOSE get_order_line_rec;
1063: IF (g_debug <= gme_debug.g_log_statement) THEN
1064: gme_debug.put_line('get_order_line_rec%NOTFOUND, RETURN now');
1065: END IF;
1066: Return FALSE;
1067: END IF;
1068: CLOSE get_order_line_rec;

Line 1071: IF (g_debug <= gme_debug.g_log_statement) THEN

1067: END IF;
1068: CLOSE get_order_line_rec;
1069:
1070: /* ============== Establish Item Characteristics ====================*/
1071: IF (g_debug <= gme_debug.g_log_statement) THEN
1072: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_order_line_rec.ship_from_org_id);
1073: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_order_line_rec.inventory_item_id);
1074: END IF;
1075: OPEN cur_item (l_order_line_rec.ship_from_org_id, l_order_line_rec.inventory_item_id);

Line 1072: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_order_line_rec.ship_from_org_id);

1068: CLOSE get_order_line_rec;
1069:
1070: /* ============== Establish Item Characteristics ====================*/
1071: IF (g_debug <= gme_debug.g_log_statement) THEN
1072: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_order_line_rec.ship_from_org_id);
1073: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_order_line_rec.inventory_item_id);
1074: END IF;
1075: OPEN cur_item (l_order_line_rec.ship_from_org_id, l_order_line_rec.inventory_item_id);
1076: FETCH cur_item INTO l_item_type;

Line 1073: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_order_line_rec.inventory_item_id);

1069:
1070: /* ============== Establish Item Characteristics ====================*/
1071: IF (g_debug <= gme_debug.g_log_statement) THEN
1072: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for organization_id '||l_order_line_rec.ship_from_org_id);
1073: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Retrieve Item for inventory_item_id '||l_order_line_rec.inventory_item_id);
1074: END IF;
1075: OPEN cur_item (l_order_line_rec.ship_from_org_id, l_order_line_rec.inventory_item_id);
1076: FETCH cur_item INTO l_item_type;
1077: IF(cur_item%NOTFOUND) THEN

Line 1079: IF (g_debug <= gme_debug.g_log_statement) THEN

1075: OPEN cur_item (l_order_line_rec.ship_from_org_id, l_order_line_rec.inventory_item_id);
1076: FETCH cur_item INTO l_item_type;
1077: IF(cur_item%NOTFOUND) THEN
1078: CLOSE cur_item;
1079: IF (g_debug <= gme_debug.g_log_statement) THEN
1080: gme_debug.put_line('Failure to retrieve item; terminate processing');
1081: END IF;
1082: Return FALSE;
1083: END IF;

Line 1080: gme_debug.put_line('Failure to retrieve item; terminate processing');

1076: FETCH cur_item INTO l_item_type;
1077: IF(cur_item%NOTFOUND) THEN
1078: CLOSE cur_item;
1079: IF (g_debug <= gme_debug.g_log_statement) THEN
1080: gme_debug.put_line('Failure to retrieve item; terminate processing');
1081: END IF;
1082: Return FALSE;
1083: END IF;
1084: CLOSE cur_item;

Line 1100: IF (g_debug <= gme_debug.g_log_statement) THEN

1096: ,x_return_status => l_return_status
1097: ,x_msg_data => l_msg_data
1098: ,x_msg_count => l_msg_count);
1099:
1100: IF (g_debug <= gme_debug.g_log_statement) THEN
1101: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
1102: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
1103: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
1104: END IF;

Line 1101: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);

1097: ,x_msg_data => l_msg_data
1098: ,x_msg_count => l_msg_count);
1099:
1100: IF (g_debug <= gme_debug.g_log_statement) THEN
1101: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
1102: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
1103: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
1104: END IF;
1105:

Line 1102: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);

1098: ,x_msg_count => l_msg_count);
1099:
1100: IF (g_debug <= gme_debug.g_log_statement) THEN
1101: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
1102: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
1103: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
1104: END IF;
1105:
1106: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) or (NVL(l_mto_assignments_rec.rule_id,0) = 0) THEN

Line 1103: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);

1099:
1100: IF (g_debug <= gme_debug.g_log_statement) THEN
1101: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return status from Retrieve_Rule is '||l_return_status);
1102: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule ID to work with is '||l_mto_assignments_rec.rule_id);
1103: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
1104: END IF;
1105:
1106: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) or (NVL(l_mto_assignments_rec.rule_id,0) = 0) THEN
1107: Return FALSE;

Line 1158: IF (g_debug <= gme_debug.g_log_statement) THEN

1154: From gme_mto_rules
1155: Where rule_id = l_mto_assignments_rec.rule_id;
1156:
1157: BEGIN
1158: IF (g_debug <= gme_debug.g_log_statement) THEN
1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);

Line 1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');

1155: Where rule_id = l_mto_assignments_rec.rule_id;
1156:
1157: BEGIN
1158: IF (g_debug <= gme_debug.g_log_statement) THEN
1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);
1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);

Line 1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);

1156:
1157: BEGIN
1158: IF (g_debug <= gme_debug.g_log_statement) THEN
1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);
1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);
1164: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' site_use_id '||p_mto_assignments_rec.site_use_id);

Line 1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);

1157: BEGIN
1158: IF (g_debug <= gme_debug.g_log_statement) THEN
1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);
1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);
1164: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' site_use_id '||p_mto_assignments_rec.site_use_id);
1165: END IF;

Line 1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);

1158: IF (g_debug <= gme_debug.g_log_statement) THEN
1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);
1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);
1164: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' site_use_id '||p_mto_assignments_rec.site_use_id);
1165: END IF;
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);

1159: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' ENTER API ');
1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);
1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);
1164: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' site_use_id '||p_mto_assignments_rec.site_use_id);
1165: END IF;
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167: /* get the most suitable rule first */

Line 1164: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' site_use_id '||p_mto_assignments_rec.site_use_id);

1160: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id '||p_mto_assignments_rec.organization_id);
1161: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id '||p_mto_assignments_rec.inventory_item_id);
1162: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' item_type '||p_mto_assignments_rec.item_type);
1163: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' customer_id '||p_mto_assignments_rec.customer_id);
1164: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' site_use_id '||p_mto_assignments_rec.site_use_id);
1165: END IF;
1166: x_return_status := FND_API.G_RET_STS_SUCCESS;
1167: /* get the most suitable rule first */
1168: GMI_reservation_Util.PrintLn('IN check Rule');

Line 1180: gme_debug.put_line('No rule assigment to match input criteria; returning from Retrieve Rule');

1176: , l_mto_assignments_rec.rule_id
1177: , l_mto_assignments_rec.organization_id;
1178: IF(get_assignment%NOTFOUND) THEN
1179: CLOSE get_assignment;
1180: gme_debug.put_line('No rule assigment to match input criteria; returning from Retrieve Rule');
1181: RETURN;
1182: END IF;
1183: Close get_assignment;
1184:

Line 1191: gme_debug.put_line('Error encountered on rule retrieval for Rule ID '||l_mto_assignments_rec.rule_id);

1187: Open get_rule;
1188: Fetch get_rule into l_mto_rules_rec;
1189: IF(get_rule%NOTFOUND) THEN
1190: CLOSE get_rule;
1191: gme_debug.put_line('Error encountered on rule retrieval for Rule ID '||l_mto_assignments_rec.rule_id);
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194: Close get_rule;
1195: