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.GML_GME_API_PVT dependencies on GMI_RESERVATION_UTIL

Line 148: GMI_RESERVATION_UTIL.println('--- Process_OM_reservations --- ');

144: x_return_status := fnd_api.g_ret_sts_success;
145: l_notify := 0;
146: l_update_history := 0;
147:
148: GMI_RESERVATION_UTIL.println('--- Process_OM_reservations --- ');
149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);
150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);

Line 149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);

145: l_notify := 0;
146: l_update_history := 0;
147:
148: GMI_RESERVATION_UTIL.println('--- Process_OM_reservations --- ');
149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);
150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);

Line 150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);

146: l_update_history := 0;
147:
148: GMI_RESERVATION_UTIL.println('--- Process_OM_reservations --- ');
149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);
150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);

Line 151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);

147:
148: GMI_RESERVATION_UTIL.println('--- Process_OM_reservations --- ');
149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);
150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);
155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);

Line 152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);

148: GMI_RESERVATION_UTIL.println('--- Process_OM_reservations --- ');
149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);
150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);
155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);
156: GMI_RESERVATION_UTIL.println('g_batch_line_id '||g_batch_line_id);

Line 153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);

149: GMI_RESERVATION_UTIL.println('Action code '||p_batch_action);
150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);
155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);
156: GMI_RESERVATION_UTIL.println('g_batch_line_id '||g_batch_line_id);
157: l_batch_line_rec := p_batch_line_rec;

Line 154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);

150: GMI_RESERVATION_UTIL.println('p_from_batch_id'||p_from_batch_id);
151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);
155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);
156: GMI_RESERVATION_UTIL.println('g_batch_line_id '||g_batch_line_id);
157: l_batch_line_rec := p_batch_line_rec;
158: l_batch_id := p_batch_line_rec.batch_id;

Line 155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);

151: GMI_RESERVATION_UTIL.println('p_batch_line.batch_id '||p_batch_line_rec.batch_id);
152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);
155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);
156: GMI_RESERVATION_UTIL.println('g_batch_line_id '||g_batch_line_id);
157: l_batch_line_rec := p_batch_line_rec;
158: l_batch_id := p_batch_line_rec.batch_id;
159: l_batch_line_id := p_batch_line_rec.batch_line_id;

Line 156: GMI_RESERVATION_UTIL.println('g_batch_line_id '||g_batch_line_id);

152: GMI_RESERVATION_UTIL.println('p_batch_line.batch_line_id '||p_batch_line_rec.batch_line_id);
153: GMI_RESERVATION_UTIL.println('p_batch_line.trans_id '||p_batch_line_rec.trans_id);
154: GMI_RESERVATION_UTIL.println('p_gme_trans_row.trans_id '||p_gme_trans_row.trans_id);
155: GMI_RESERVATION_UTIL.println('g_batch_id '||g_batch_id);
156: GMI_RESERVATION_UTIL.println('g_batch_line_id '||g_batch_line_id);
157: l_batch_line_rec := p_batch_line_rec;
158: l_batch_id := p_batch_line_rec.batch_id;
159: l_batch_line_id := p_batch_line_rec.batch_line_id;
160: l_batch_trans_id := p_batch_line_rec.trans_id;

Line 171: GMI_RESERVATION_UTIL.println('reset global ');

167: g_batch_line_id := l_batch_line_id ; -- initialize the gloable variable
168: END IF;
169:
170: IF l_batch_id <> g_batch_id OR l_batch_line_id <> g_batch_line_id THEN
171: GMI_RESERVATION_UTIL.println('reset global ');
172: g_batch_id := l_batch_id;
173: g_batch_line_id := l_batch_line_id;
174: g_prod_yielded := 0; -- Batch initiation
175: GML_GME_API_PVT.g_not_to_delete := 0; -- always delete reservation when availability is 0

Line 210: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: CONVERT');

206: END IF;
207:
208: -- Batch level actions
209: IF p_batch_action = 'CONVERT' THEN
210: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: CONVERT');
211: /* FPO convert to batches */
212: IF p_from_batch_id is null THEN
213: GMI_RESERVATION_UTIL.println('PRocess_om_reservations ...FPO batch_id is null');
214: return;

Line 213: GMI_RESERVATION_UTIL.println('PRocess_om_reservations ...FPO batch_id is null');

209: IF p_batch_action = 'CONVERT' THEN
210: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: CONVERT');
211: /* FPO convert to batches */
212: IF p_from_batch_id is null THEN
213: GMI_RESERVATION_UTIL.println('PRocess_om_reservations ...FPO batch_id is null');
214: return;
215: END IF;
216: GML_BATCH_OM_RES_PVT.create_reservation_from_FPO
217: (

Line 235: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: DELETE');

231: IF p_batch_line_rec.batch_id is not null
232: and p_batch_line_rec.batch_line_id is null
233: and p_batch_line_rec.trans_id is null
234: THEN
235: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: DELETE');
236: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_batch');
237: For res in get_lnid_for_batch(p_batch_line_rec.batch_id) Loop
238: l_batch_line_rec.batch_line_id := res.batch_line_id;
239: /* get the rule for the batch line */

Line 236: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_batch');

232: and p_batch_line_rec.batch_line_id is null
233: and p_batch_line_rec.trans_id is null
234: THEN
235: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: DELETE');
236: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_batch');
237: For res in get_lnid_for_batch(p_batch_line_rec.batch_id) Loop
238: l_batch_line_rec.batch_line_id := res.batch_line_id;
239: /* get the rule for the batch line */
240: GML_BATCH_OM_UTIL.get_rule

Line 250: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.notify_CSR');

246: , X_msg_cont => l_msg_cont
247: , X_msg_data => l_msg_data
248: );
249: IF l_rule_rec.order_notification = 'Y' THEN
250: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.notify_CSR');
251: GML_BATCH_OM_RES_PVT.notify_CSR
252: (
253: P_Batch_line_id => res.batch_line_id
254: , P_action_code => 'CANCEL'

Line 262: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....After GML_BATCH_OM_RES_PVT.cancel_batch');

258: );
259: END IF;
260: END LOOP;
261:
262: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....After GML_BATCH_OM_RES_PVT.cancel_batch');
263: GML_BATCH_OM_RES_PVT.cancel_batch
264: (
265: P_Batch_id => p_batch_line_rec.batch_id
266: , X_return_status => x_return_status

Line 277: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: NOTIFY_CSR');

273:
274: IF p_batch_line_rec.batch_id is not null
275: And p_batch_line_rec.batch_line_id is null THEN
276: IF p_batch_action = 'NOTIFY_CSR' THEN
277: GMI_RESERVATION_UTIL.PrintLn(' Batch level actions: NOTIFY_CSR');
278: /* check to see the planned complt date */
279: For res in get_lnid_for_batch(p_batch_line_rec.batch_id) Loop
280: l_batch_line_rec.batch_line_id := res.batch_line_id;
281: /* get the rule for the batch line */

Line 352: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations...... IF p_batch_action = DELETE');

348: /* actions at the batch side could be
349: * 1) cancel-terminate batch -- batch level, above
350: * 2) reserval batch at the trans level
351: */
352: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations...... IF p_batch_action = DELETE');
353: IF l_rule_rec.order_notification = 'Y' THEN
354: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.notify_CSR');
355: GML_BATCH_OM_RES_PVT.notify_CSR
356: (

Line 354: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.notify_CSR');

350: * 2) reserval batch at the trans level
351: */
352: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations...... IF p_batch_action = DELETE');
353: IF l_rule_rec.order_notification = 'Y' THEN
354: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.notify_CSR');
355: GML_BATCH_OM_RES_PVT.notify_CSR
356: (
357: P_Batch_trans_id => p_batch_line_rec.trans_id
358: , P_action_code => 'CANCEL'

Line 365: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....IF p_gme_trans_row.trans_id is not null');

361: , X_msg_data => l_msg_data
362: );
363: END IF;
364: IF p_batch_line_rec.trans_id is not null THEN
365: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....IF p_gme_trans_row.trans_id is not null');
366: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans');
367: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans
368: (
369: P_Batch_trans_id => p_batch_line_rec.trans_id

Line 366: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans');

362: );
363: END IF;
364: IF p_batch_line_rec.trans_id is not null THEN
365: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....IF p_gme_trans_row.trans_id is not null');
366: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Calling GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans');
367: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans
368: (
369: P_Batch_trans_id => p_batch_line_rec.trans_id
370: , X_return_status => x_return_status

Line 382: GMI_RESERVATION_UTIL.println('Fetch old gme trans '||p_batch_line_rec.trans_id);

378: /* p_batch_line_rec.trans_id will be passed as the from trans_id
379: * p_gme_trans_row.trans_id will be passed as the new (to be updated) trans_id
380: */
381: IF p_batch_line_rec.trans_id is not null THEN
382: GMI_RESERVATION_UTIL.println('Fetch old gme trans '||p_batch_line_rec.trans_id);
383: Open get_trans_row(p_batch_line_rec.trans_id);
384: Fetch get_trans_row
385: Into l_old_gme_trans_row;
386: Close get_trans_row;

Line 393: GMI_RESERVATION_UTIL.println('batch line level');

389: * 1) planned qty is changed
390: * 2) update pending to complete
391: */
392: IF p_batch_line_rec.batch_line_id is not null THEN
393: GMI_RESERVATION_UTIL.println('batch line level');
394: /* 1) Reduce planned qty or any pending transactions change
395: -- no actions for increasing qty
396: * the trans_row would be pending
397: */

Line 399: GMI_RESERVATION_UTIL.println('UPDP, pending trans is changed');

395: -- no actions for increasing qty
396: * the trans_row would be pending
397: */
398: IF p_gme_trans_row.trans_id is null THEN -- Pending transactions
399: GMI_RESERVATION_UTIL.println('UPDP, pending trans is changed');
400: For whse_rec in check_res_whse(p_batch_line_rec.batch_line_id) LOOP
401: l_whse_code := whse_rec.whse_code;
402: Open get_res_qty(l_batch_line_id, l_whse_code);
403: Fetch get_res_qty

Line 406: GMI_RESERVATION_UTIL.println('UPDP, total res qty '|| l_res_qty);

402: Open get_res_qty(l_batch_line_id, l_whse_code);
403: Fetch get_res_qty
404: Into l_res_qty, l_res_qty2;
405: Close get_res_qty;
406: GMI_RESERVATION_UTIL.println('UPDP, total res qty '|| l_res_qty);
407:
408: Open get_planned_qty(l_batch_line_id, l_whse_code);
409: Fetch get_planned_qty
410: Into l_planned_qty, l_planned_qty2;

Line 413: GMI_RESERVATION_UTIL.println('UPDP, total planned qty '|| nvl(l_planned_qty,0));

409: Fetch get_planned_qty
410: Into l_planned_qty, l_planned_qty2;
411: Close get_planned_qty;
412:
413: GMI_RESERVATION_UTIL.println('UPDP, total planned qty '|| nvl(l_planned_qty,0));
414: GMI_RESERVATION_UTIL.println(' global g_not_to_notify '||GML_GME_API_PVT.g_not_to_notify);
415: IF (l_res_qty > nvl(l_planned_qty,0) * (1+ l_rule_rec.allocation_tolerance/100))
416: and l_notify = 1
417: and GML_GME_API_PVT.g_not_to_notify <> 1

Line 414: GMI_RESERVATION_UTIL.println(' global g_not_to_notify '||GML_GME_API_PVT.g_not_to_notify);

410: Into l_planned_qty, l_planned_qty2;
411: Close get_planned_qty;
412:
413: GMI_RESERVATION_UTIL.println('UPDP, total planned qty '|| nvl(l_planned_qty,0));
414: GMI_RESERVATION_UTIL.println(' global g_not_to_notify '||GML_GME_API_PVT.g_not_to_notify);
415: IF (l_res_qty > nvl(l_planned_qty,0) * (1+ l_rule_rec.allocation_tolerance/100))
416: and l_notify = 1
417: and GML_GME_API_PVT.g_not_to_notify <> 1
418: THEN

Line 422: GMI_RESERVATION_UTIL.println('UPDP, planned qty is changed');

418: THEN
419: /* pending qty has been reduced
420: * check the tolerance
421: */
422: GMI_RESERVATION_UTIL.println('UPDP, planned qty is changed');
423: GMI_RESERVATION_UTIL.println('Process_om_reservations...UPDP Pending Qty is reduced');
424: GMI_RESERVATION_UTIL.println('Process_om_reservations...Pending Qty is reduced Calling GML_BATCH_OM_RES_PVT.notify_CSR');
425: GML_BATCH_OM_RES_PVT.notify_CSR
426: (

Line 423: GMI_RESERVATION_UTIL.println('Process_om_reservations...UPDP Pending Qty is reduced');

419: /* pending qty has been reduced
420: * check the tolerance
421: */
422: GMI_RESERVATION_UTIL.println('UPDP, planned qty is changed');
423: GMI_RESERVATION_UTIL.println('Process_om_reservations...UPDP Pending Qty is reduced');
424: GMI_RESERVATION_UTIL.println('Process_om_reservations...Pending Qty is reduced Calling GML_BATCH_OM_RES_PVT.notify_CSR');
425: GML_BATCH_OM_RES_PVT.notify_CSR
426: (
427: P_batch_line_id => p_batch_line_rec.batch_line_id

Line 424: GMI_RESERVATION_UTIL.println('Process_om_reservations...Pending Qty is reduced Calling GML_BATCH_OM_RES_PVT.notify_CSR');

420: * check the tolerance
421: */
422: GMI_RESERVATION_UTIL.println('UPDP, planned qty is changed');
423: GMI_RESERVATION_UTIL.println('Process_om_reservations...UPDP Pending Qty is reduced');
424: GMI_RESERVATION_UTIL.println('Process_om_reservations...Pending Qty is reduced Calling GML_BATCH_OM_RES_PVT.notify_CSR');
425: GML_BATCH_OM_RES_PVT.notify_CSR
426: (
427: P_batch_line_id => p_batch_line_rec.batch_line_id
428: , P_whse_code => l_whse_code

Line 435: GMI_RESERVATION_UTIL.println(' global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);

431: , X_msg_cont => l_msg_cont
432: , X_msg_data => l_msg_data
433: );
434: /* if planned qty becomes 0, delete all the res for this whse */
435: GMI_RESERVATION_UTIL.println(' global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);
436: IF (nvl(l_planned_qty,0) <= 0 AND GML_GME_API_PVT.g_not_to_delete = 0) THEN
437: GML_BATCH_OM_RES_PVT.cancel_res_for_batch_line
438: (
439: P_Batch_line_id => p_batch_line_rec.batch_line_id

Line 453: GMI_RESERVATION_UTIL.println('UPDP, update pending to complete');

449: IF p_gme_trans_row.trans_id is not null
450: and l_old_gme_trans_row.completed_ind = 0
451: and p_gme_trans_row.completed_ind = 1
452: THEN
453: GMI_RESERVATION_UTIL.println('UPDP, update pending to complete');
454: GML_BATCH_OM_RES_PVT.create_allocations
455: (
456: P_batch_line_rec => p_batch_line_rec
457: , P_gme_om_rule_rec => l_rule_rec

Line 468: GMI_RESERVATION_UTIL.println(' Global value g_prod_yielded '||g_prod_yielded);

464: g_prod_yielded := 1;
465:
466: END IF;
467:
468: GMI_RESERVATION_UTIL.println(' Global value g_prod_yielded '||g_prod_yielded);
469: /* Pick confirm is here after consolidation at GME side */
470: IF l_rule_rec.auto_pick_confirm = 'Y' AND g_prod_yielded = 1 THEN
471: GMI_RESERVATION_UTIL.println('Product yielded. Now Pickconfirm');
472: /* get the mo line id for the source line */

Line 471: GMI_RESERVATION_UTIL.println('Product yielded. Now Pickconfirm');

467:
468: GMI_RESERVATION_UTIL.println(' Global value g_prod_yielded '||g_prod_yielded);
469: /* Pick confirm is here after consolidation at GME side */
470: IF l_rule_rec.auto_pick_confirm = 'Y' AND g_prod_yielded = 1 THEN
471: GMI_RESERVATION_UTIL.println('Product yielded. Now Pickconfirm');
472: /* get the mo line id for the source line */
473: GML_BATCH_OM_RES_PVT.pick_confirm
474: (
475: P_batch_line_rec => p_batch_line_rec

Line 485: GMI_RESERVATION_UTIL.println('transaction level');

481: END IF;
482: END IF; -- batch line level
483: IF p_batch_line_rec.trans_id is not null
484: and p_gme_trans_row.trans_id is not null THEN
485: GMI_RESERVATION_UTIL.println('transaction level');
486: IF l_old_gme_trans_row.completed_ind = 1
487: and l_new_gme_trans_row.completed_ind = 1
488: THEN
489: GMI_RESERVATION_UTIL.println('UPDC, update the completed transaction');

Line 489: GMI_RESERVATION_UTIL.println('UPDC, update the completed transaction');

485: GMI_RESERVATION_UTIL.println('transaction level');
486: IF l_old_gme_trans_row.completed_ind = 1
487: and l_new_gme_trans_row.completed_ind = 1
488: THEN
489: GMI_RESERVATION_UTIL.println('UPDC, update the completed transaction');
490: /* 1) if qty is increased, new OMSO should be created for the newly added qty
491: */
492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);
493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);

Line 492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);

488: THEN
489: GMI_RESERVATION_UTIL.println('UPDC, update the completed transaction');
490: /* 1) if qty is increased, new OMSO should be created for the newly added qty
491: */
492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);
493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);
494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);

Line 493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);

489: GMI_RESERVATION_UTIL.println('UPDC, update the completed transaction');
490: /* 1) if qty is increased, new OMSO should be created for the newly added qty
491: */
492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);
493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);
494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);

Line 494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);

490: /* 1) if qty is increased, new OMSO should be created for the newly added qty
491: */
492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);
493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);
494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);

Line 495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);

491: */
492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);
493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);
494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);
499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);

Line 496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);

492: GMI_RESERVATION_UTIL.println('UPDC, old trans_qty '|| l_old_gme_trans_row.trans_qty);
493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);
494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);
499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);
500: IF abs(l_new_gme_trans_row.trans_qty) > abs(l_old_gme_trans_row.trans_qty) THEN

Line 497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);

493: GMI_RESERVATION_UTIL.println('UPDC, new trans_qty '|| l_new_gme_trans_row.trans_qty);
494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);
499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);
500: IF abs(l_new_gme_trans_row.trans_qty) > abs(l_old_gme_trans_row.trans_qty) THEN
501: GMI_RESERVATION_UTIL.println(' New qty added');

Line 498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);

494: GMI_RESERVATION_UTIL.println('UPDC, old lot_id '|| l_old_gme_trans_row.lot_id);
495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);
499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);
500: IF abs(l_new_gme_trans_row.trans_qty) > abs(l_old_gme_trans_row.trans_qty) THEN
501: GMI_RESERVATION_UTIL.println(' New qty added');
502: Open get_total_OMSO(l_old_gme_trans_row.trans_id);

Line 499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);

495: GMI_RESERVATION_UTIL.println('UPDC, new lot_id '|| l_new_gme_trans_row.lot_id);
496: GMI_RESERVATION_UTIL.println('UPDC, old location '|| l_old_gme_trans_row.location);
497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);
499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);
500: IF abs(l_new_gme_trans_row.trans_qty) > abs(l_old_gme_trans_row.trans_qty) THEN
501: GMI_RESERVATION_UTIL.println(' New qty added');
502: Open get_total_OMSO(l_old_gme_trans_row.trans_id);
503: Fetch get_total_OMSO Into l_trans_qty, l_trans_qty2;

Line 501: GMI_RESERVATION_UTIL.println(' New qty added');

497: GMI_RESERVATION_UTIL.println('UPDC, new location '|| l_new_gme_trans_row.location);
498: GMI_RESERVATION_UTIL.println('UPDC, old whse_code '|| l_old_gme_trans_row.whse_code);
499: GMI_RESERVATION_UTIL.println('UPDC, new whse_code '|| l_new_gme_trans_row.whse_code);
500: IF abs(l_new_gme_trans_row.trans_qty) > abs(l_old_gme_trans_row.trans_qty) THEN
501: GMI_RESERVATION_UTIL.println(' New qty added');
502: Open get_total_OMSO(l_old_gme_trans_row.trans_id);
503: Fetch get_total_OMSO Into l_trans_qty, l_trans_qty2;
504: Close get_total_OMSO;
505: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty '||l_trans_qty);

Line 505: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty '||l_trans_qty);

501: GMI_RESERVATION_UTIL.println(' New qty added');
502: Open get_total_OMSO(l_old_gme_trans_row.trans_id);
503: Fetch get_total_OMSO Into l_trans_qty, l_trans_qty2;
504: Close get_total_OMSO;
505: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty '||l_trans_qty);
506: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty2 '||l_trans_qty2);
507: l_new_gme_trans_row.trans_qty := -1 * (abs(l_new_gme_trans_row.trans_qty)
508: - abs(l_trans_qty));
509: l_new_gme_trans_row.trans_qty2 := -1 * (abs(l_new_gme_trans_row.trans_qty2)

Line 506: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty2 '||l_trans_qty2);

502: Open get_total_OMSO(l_old_gme_trans_row.trans_id);
503: Fetch get_total_OMSO Into l_trans_qty, l_trans_qty2;
504: Close get_total_OMSO;
505: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty '||l_trans_qty);
506: GMI_RESERVATION_UTIL.println(' Total OMSO trans_qty2 '||l_trans_qty2);
507: l_new_gme_trans_row.trans_qty := -1 * (abs(l_new_gme_trans_row.trans_qty)
508: - abs(l_trans_qty));
509: l_new_gme_trans_row.trans_qty2 := -1 * (abs(l_new_gme_trans_row.trans_qty2)
510: - abs(l_trans_qty2));

Line 527: GMI_RESERVATION_UTIL.println(' Process_om_reservations completed batch qty reduced');

523: g_prod_yielded := 1;
524:
525: ELSIF abs(l_new_gme_trans_row.trans_qty) < abs(l_old_gme_trans_row.trans_qty) THEN
526: /* qty is reduced, backflash */
527: GMI_RESERVATION_UTIL.println(' Process_om_reservations completed batch qty reduced');
528: /* notify CSR */
529: l_notify := 1;
530: GMI_RESERVATION_UTIL.println(' Process_om_reservations completed batch qty reduced calling GML_BATCH_OM_RES_PVT.notify_CSR');
531: GML_BATCH_OM_RES_PVT.notify_CSR

Line 530: GMI_RESERVATION_UTIL.println(' Process_om_reservations completed batch qty reduced calling GML_BATCH_OM_RES_PVT.notify_CSR');

526: /* qty is reduced, backflash */
527: GMI_RESERVATION_UTIL.println(' Process_om_reservations completed batch qty reduced');
528: /* notify CSR */
529: l_notify := 1;
530: GMI_RESERVATION_UTIL.println(' Process_om_reservations completed batch qty reduced calling GML_BATCH_OM_RES_PVT.notify_CSR');
531: GML_BATCH_OM_RES_PVT.notify_CSR
532: (
533: P_batch_trans_id => p_batch_line_rec.trans_id
534: , P_action_code => 'REDUCE_QTY_ON_COMPLETED_BATCH'

Line 547: GMI_RESERVATION_UTIL.println('Lot is changed from '|| l_old_gme_trans_row.lot_id);

543:
544: /* 2) lot_id is changed
545: */
546: IF l_new_gme_trans_row.lot_id <> l_old_gme_trans_row.lot_id THEN
547: GMI_RESERVATION_UTIL.println('Lot is changed from '|| l_old_gme_trans_row.lot_id);
548: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.lot_id);
549: For trans_rec in get_trans_id(l_batch_trans_id) LOOP
550: l_trans_id := trans_rec.trans_id;
551: l_tran_rec.trans_id := l_trans_id;

Line 548: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.lot_id);

544: /* 2) lot_id is changed
545: */
546: IF l_new_gme_trans_row.lot_id <> l_old_gme_trans_row.lot_id THEN
547: GMI_RESERVATION_UTIL.println('Lot is changed from '|| l_old_gme_trans_row.lot_id);
548: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.lot_id);
549: For trans_rec in get_trans_id(l_batch_trans_id) LOOP
550: l_trans_id := trans_rec.trans_id;
551: l_tran_rec.trans_id := l_trans_id;
552: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN

Line 554: GMI_RESERVATION_UTIL.println(' Changing lot_id for trans_id '|| l_trans_id);

550: l_trans_id := trans_rec.trans_id;
551: l_tran_rec.trans_id := l_trans_id;
552: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN
553: l_tran_rec.lot_id := l_new_gme_trans_row.lot_id;
554: GMI_RESERVATION_UTIL.println(' Changing lot_id for trans_id '|| l_trans_id);
555: GMI_TRANS_ENGINE_PUB.update_pending_transaction
556: (p_api_version => 1.0,
557: p_init_msg_list => FND_API.G_TRUE,
558: p_commit => FND_API.G_FALSE,

Line 567: GMI_reservation_Util.PrintLn('update complete trans, alloc creation error');

563: x_msg_count => l_msg_cont,
564: x_msg_data => l_msg_data
565: );
566: IF x_return_status <> fnd_api.g_ret_sts_success Then
567: GMI_reservation_Util.PrintLn('update complete trans, alloc creation error');
568: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
569: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
570: FND_MSG_PUB.ADD;
571: END IF;

Line 575: GMI_RESERVATION_UTIL.balance_default_lot

571: END IF;
572: /* no need
573: l_dft_tran_rec.line_id := l_tran_rec.line_id;
574: l_dft_tran_rec.trans_id := null;
575: GMI_RESERVATION_UTIL.balance_default_lot
576: ( p_ic_default_rec => l_dft_tran_rec
577: , p_opm_item_id => l_dft_tran_rec.item_id
578: , x_return_status => x_return_status
579: , x_msg_count => x_msg_cont

Line 584: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');

580: , x_msg_data => x_msg_data
581: );
582: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
583: THEN
584: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
585: END IF;
586: */
587: l_update_history := 1;
588: END IF;

Line 595: GMI_RESERVATION_UTIL.println('Location is changed from '|| l_old_gme_trans_row.location);

591: END IF;
592: /* 3) location is changed
593: */
594: IF l_new_gme_trans_row.location <> l_old_gme_trans_row.location THEN
595: GMI_RESERVATION_UTIL.println('Location is changed from '|| l_old_gme_trans_row.location);
596: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.location);
597: For trans_rec in get_trans_id(l_batch_trans_id) LOOP
598: l_trans_id := trans_rec.trans_id;
599: l_tran_rec.trans_id := l_trans_id;

Line 596: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.location);

592: /* 3) location is changed
593: */
594: IF l_new_gme_trans_row.location <> l_old_gme_trans_row.location THEN
595: GMI_RESERVATION_UTIL.println('Location is changed from '|| l_old_gme_trans_row.location);
596: GMI_RESERVATION_UTIL.println(' to '|| l_new_gme_trans_row.location);
597: For trans_rec in get_trans_id(l_batch_trans_id) LOOP
598: l_trans_id := trans_rec.trans_id;
599: l_tran_rec.trans_id := l_trans_id;
600: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN

Line 602: GMI_RESERVATION_UTIL.println(' Changing location for trans_id '|| l_trans_id);

598: l_trans_id := trans_rec.trans_id;
599: l_tran_rec.trans_id := l_trans_id;
600: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN
601: l_tran_rec.location := l_new_gme_trans_row.location;
602: GMI_RESERVATION_UTIL.println(' Changing location for trans_id '|| l_trans_id);
603: GMI_TRANS_ENGINE_PUB.update_pending_transaction
604: (p_api_version => 1.0,
605: p_init_msg_list => FND_API.G_TRUE,
606: p_commit => FND_API.G_FALSE,

Line 615: GMI_reservation_Util.PrintLn('update complete trans, alloc creation error');

611: x_msg_count => l_msg_cont,
612: x_msg_data => l_msg_data
613: );
614: IF x_return_status <> fnd_api.g_ret_sts_success Then
615: GMI_reservation_Util.PrintLn('update complete trans, alloc creation error');
616: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
617: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
618: FND_MSG_PUB.ADD;
619: END IF;

Line 628: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Whse is Changed');

624: END IF;
625: /* 4) whse_code is changed
626: */
627: IF l_new_gme_trans_row.whse_code <> l_old_gme_trans_row.whse_code THEN
628: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Whse is Changed');
629: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Completed batch tran is deleted');
630: GMI_RESERVATION_UTIL.println('Process_Om_reservations .........Before deleting OMSO trans');
631: GMI_RESERVATION_UTIL.println('Process_om_Reservations.... First Notify CSR');
632: l_notify := 1;

Line 629: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Completed batch tran is deleted');

625: /* 4) whse_code is changed
626: */
627: IF l_new_gme_trans_row.whse_code <> l_old_gme_trans_row.whse_code THEN
628: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Whse is Changed');
629: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Completed batch tran is deleted');
630: GMI_RESERVATION_UTIL.println('Process_Om_reservations .........Before deleting OMSO trans');
631: GMI_RESERVATION_UTIL.println('Process_om_Reservations.... First Notify CSR');
632: l_notify := 1;
633: /* Send a notification */

Line 630: GMI_RESERVATION_UTIL.println('Process_Om_reservations .........Before deleting OMSO trans');

626: */
627: IF l_new_gme_trans_row.whse_code <> l_old_gme_trans_row.whse_code THEN
628: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Whse is Changed');
629: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Completed batch tran is deleted');
630: GMI_RESERVATION_UTIL.println('Process_Om_reservations .........Before deleting OMSO trans');
631: GMI_RESERVATION_UTIL.println('Process_om_Reservations.... First Notify CSR');
632: l_notify := 1;
633: /* Send a notification */
634: GML_BATCH_OM_RES_PVT.notify_CSR

Line 631: GMI_RESERVATION_UTIL.println('Process_om_Reservations.... First Notify CSR');

627: IF l_new_gme_trans_row.whse_code <> l_old_gme_trans_row.whse_code THEN
628: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Whse is Changed');
629: GMI_RESERVATION_UTIL.println('Process_Om_reservations .....Completed batch tran is deleted');
630: GMI_RESERVATION_UTIL.println('Process_Om_reservations .........Before deleting OMSO trans');
631: GMI_RESERVATION_UTIL.println('Process_om_Reservations.... First Notify CSR');
632: l_notify := 1;
633: /* Send a notification */
634: GML_BATCH_OM_RES_PVT.notify_CSR
635: (

Line 643: GMI_RESERVATION_UTIL.println(' Deleting OMSO trans');

639: , X_msg_cont => l_msg_cont
640: , X_msg_data => l_msg_data
641: );
642:
643: GMI_RESERVATION_UTIL.println(' Deleting OMSO trans');
644: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans
645: (
646: P_Batch_trans_id => l_batch_trans_id
647: , X_return_status => X_return_status

Line 664: GMI_RESERVATION_UTIL.println('Notifications to CSR ');

660: /* balance the default lot */
661: /* notify the CSR */
662: /*
663: IF l_notify = 1 THEN
664: GMI_RESERVATION_UTIL.println('Notifications to CSR ');
665: GML_BATCH_OM_RES_PVT.notify_CSR
666: (
667: P_batch_trans_id => p_batch_line_rec.trans_id
668: , X_return_status => x_return_status

Line 693: GMI_RESERVATION_UTIL.println(' delete history.alloc_rec_id '||his_rec.alloc_rec_id);

689: update gml_batch_so_alloc_history
690: Set delete_mark = 1
691: Where alloc_rec_id = his_rec.alloc_rec_id
692: ;
693: GMI_RESERVATION_UTIL.println(' delete history.alloc_rec_id '||his_rec.alloc_rec_id);
694: GMI_RESERVATION_UTIL.println(' old batch_trans_id '||l_old_gme_trans_row.trans_id);
695: l_history_rec.alloc_rec_id := his_rec.alloc_rec_id;
696: GML_BATCH_OM_UTIL.query_alloc_history
697: (

Line 694: GMI_RESERVATION_UTIL.println(' old batch_trans_id '||l_old_gme_trans_row.trans_id);

690: Set delete_mark = 1
691: Where alloc_rec_id = his_rec.alloc_rec_id
692: ;
693: GMI_RESERVATION_UTIL.println(' delete history.alloc_rec_id '||his_rec.alloc_rec_id);
694: GMI_RESERVATION_UTIL.println(' old batch_trans_id '||l_old_gme_trans_row.trans_id);
695: l_history_rec.alloc_rec_id := his_rec.alloc_rec_id;
696: GML_BATCH_OM_UTIL.query_alloc_history
697: (
698: P_alloc_history_rec => l_history_rec

Line 703: GMI_RESERVATION_UTIL.println(' new history.batch_trans_id '||l_history_rec.batch_trans_id);

699: , X_return_status => x_return_status
700: , X_msg_cont => l_msg_cont
701: , X_msg_data => l_msg_data
702: ) ;
703: GMI_RESERVATION_UTIL.println(' new history.batch_trans_id '||l_history_rec.batch_trans_id);
704: l_history_rec.alloc_rec_id := null;
705: l_history_rec.batch_trans_id := l_new_gme_trans_row.trans_id;
706: l_history_rec.location := l_new_gme_trans_row.location;
707: l_history_rec.lot_id := l_new_gme_trans_row.lot_id;

Line 708: GMI_RESERVATION_UTIL.println(' for batch_res_id '||l_history_rec.batch_res_id);

704: l_history_rec.alloc_rec_id := null;
705: l_history_rec.batch_trans_id := l_new_gme_trans_row.trans_id;
706: l_history_rec.location := l_new_gme_trans_row.location;
707: l_history_rec.lot_id := l_new_gme_trans_row.lot_id;
708: GMI_RESERVATION_UTIL.println(' for batch_res_id '||l_history_rec.batch_res_id);
709: GML_BATCH_OM_UTIL.insert_alloc_history
710: (
711: P_alloc_history_rec => l_history_rec
712: , X_return_status => x_return_status

Line 723: GMI_RESERVATION_UTIL.println('UPDP, update complete to pending');

719: IF l_old_gme_trans_row.completed_ind = 1
720: and l_new_gme_trans_row.completed_ind = 0
721: THEN
722: /* uncomplete the completed trans */
723: GMI_RESERVATION_UTIL.println('UPDP, update complete to pending');
724: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans
725: (
726: P_Batch_trans_id => l_old_gme_trans_row.trans_id
727: , X_return_status => X_return_status

Line 732: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Canceling the PROD transaction');

728: , X_msg_cont => l_msg_cont
729: , X_msg_data => l_msg_data
730: );
731: IF l_rule_rec.order_notification = 'Y' THEN
732: GMI_RESERVATION_UTIL.PrintLn(' In Process_om_reservations....Canceling the PROD transaction');
733: GML_BATCH_OM_RES_PVT.notify_CSR
734: (
735: P_Batch_trans_id => p_batch_line_rec.trans_id
736: , P_action_code => 'CANCEL'