DBA Data[Home] [Help]

APPS.GML_GME_API_PVT dependencies on GML_BATCH_OM_RES_PVT

Line 216: GML_BATCH_OM_RES_PVT.create_reservation_from_FPO

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: (
218: P_FPO_batch_id => p_from_batch_id
219: , P_New_batch_id => p_batch_line_rec.batch_id
220: , X_return_status => x_return_status

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 251: GML_BATCH_OM_RES_PVT.notify_CSR

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'
255: , X_return_status => x_return_status

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 263: GML_BATCH_OM_RES_PVT.cancel_batch

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
267: , X_msg_cont => l_msg_cont

Line 294: GML_BATCH_OM_RES_PVT.notify_CSR

290: );
291: IF l_rule_rec.order_notification = 'Y' THEN
292: For res_line in get_res_for_batch_line(res.batch_line_id) Loop
293: IF p_batch_line_rec.cmplt_date > res_line.scheduled_ship_date THEN
294: GML_BATCH_OM_RES_PVT.notify_CSR
295: (
296: P_batch_id => p_batch_line_rec.batch_id
297: , P_action_code => 'CMPLT_DATE_CHANGE'
298: , X_return_status => x_return_status

Line 331: GML_BATCH_OM_RES_PVT.create_allocations

327: /* based on the p_batch_action code, do the appropriate calls */
328: IF p_batch_action = 'COMPLETE' THEN
329: /* action at batch side is either ADDC or UPDP with completed_ind = 1
330: * We will create OMSO allocations based on the reservations */
331: GML_BATCH_OM_RES_PVT.create_allocations
332: (
333: P_batch_line_rec => p_batch_line_rec
334: , P_gme_om_rule_rec => l_rule_rec
335: , P_Gme_trans_row => p_gme_trans_row

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 355: GML_BATCH_OM_RES_PVT.notify_CSR

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'
359: , X_return_status => x_return_status

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 367: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans

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
371: , X_msg_cont => l_msg_cont

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 425: GML_BATCH_OM_RES_PVT.notify_CSR

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
429: , P_action_code => 'REDUCE_PLANNED_QTY'

Line 437: GML_BATCH_OM_RES_PVT.cancel_res_for_batch_line

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
440: , P_whse_code => l_whse_code
441: , X_return_status => x_return_status

Line 454: GML_BATCH_OM_RES_PVT.create_allocations

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
458: , P_Gme_trans_row => p_gme_trans_row

Line 473: GML_BATCH_OM_RES_PVT.pick_confirm

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
476: , P_Gme_trans_row => p_gme_trans_row
477: , X_return_status => x_return_status

Line 511: GML_BATCH_OM_RES_PVT.create_allocations

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));
511: GML_BATCH_OM_RES_PVT.create_allocations
512: (
513: P_batch_line_rec => p_batch_line_rec
514: , P_gme_om_rule_rec => l_rule_rec
515: , P_Gme_trans_row => l_new_gme_trans_row

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 531: GML_BATCH_OM_RES_PVT.notify_CSR

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'
535: , X_return_status => l_return_status

Line 634: GML_BATCH_OM_RES_PVT.notify_CSR

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: (
636: P_batch_trans_id => l_batch_trans_id
637: , P_action_code => 'WHSE_CHANGED'
638: , X_return_status => x_return_status

Line 644: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans

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
648: , X_msg_cont => l_msg_cont

Line 665: GML_BATCH_OM_RES_PVT.notify_CSR

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
669: , X_msg_cont => l_msg_cont

Line 724: GML_BATCH_OM_RES_PVT.cancel_alloc_for_trans

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
728: , X_msg_cont => l_msg_cont

Line 733: GML_BATCH_OM_RES_PVT.notify_CSR

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'
737: , X_return_status => x_return_status