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_BATCH_OM_RES_PVT dependencies on GMI_RESERVATION_UTIL

Line 135: GMI_reservation_Util.PrintLn(' create_reservation_from_FPO ');

131: where batch_id = p_batch_id;
132:
133: BEGIN
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135: GMI_reservation_Util.PrintLn(' create_reservation_from_FPO ');
136: /* loop through all the product lines in the batch */
137: For batch_line in get_batch_line(p_FPO_batch_id) Loop
138: l_fpo_batch_line_id := batch_line.material_detail_id ;
139: l_item_id := batch_line.item_id ;

Line 140: GMI_reservation_Util.PrintLn(' FPO batch_line_id '||l_fpo_batch_line_id);

136: /* loop through all the product lines in the batch */
137: For batch_line in get_batch_line(p_FPO_batch_id) Loop
138: l_fpo_batch_line_id := batch_line.material_detail_id ;
139: l_item_id := batch_line.item_id ;
140: GMI_reservation_Util.PrintLn(' FPO batch_line_id '||l_fpo_batch_line_id);
141: /* check reservation exist or not */
142: IF NOT GML_BATCH_OM_UTIL.check_reservation
143: (
144: P_Batch_line_id => l_fpo_batch_line_id

Line 158: GMI_reservation_Util.PrintLn(' NEW batch_line_id '||l_batch_line_id);

154: Open get_new_batch_line(p_new_batch_id, l_item_id);
155: Fetch get_new_batch_line Into l_batch_line_id;
156: Close get_new_batch_line;
157:
158: GMI_reservation_Util.PrintLn(' NEW batch_line_id '||l_batch_line_id);
159: /* loop to see if different whse may have exist */
160: For each_whse in check_whse(l_fpo_batch_line_id) Loop
161: l_whse_code := each_whse.whse_code;
162: l_so_line_rec.whse_code := each_whse.whse_code;

Line 164: GMI_reservation_Util.PrintLn(' reservation whse '||l_whse_code);

160: For each_whse in check_whse(l_fpo_batch_line_id) Loop
161: l_whse_code := each_whse.whse_code;
162: l_so_line_rec.whse_code := each_whse.whse_code;
163: l_batch_line_rec.batch_line_id := l_fpo_batch_line_id;
164: GMI_reservation_Util.PrintLn(' reservation whse '||l_whse_code);
165:
166: GML_BATCH_OM_UTIL.get_rule
167: (
168: P_so_line_rec => l_so_line_rec

Line 182: GMI_reservation_Util.PrintLn(' NEW batch Planned qty '||l_planned_qty);

178: Into l_planned_qty
179: , l_planned_qty2
180: ;
181: Close get_planned_qty;
182: GMI_reservation_Util.PrintLn(' NEW batch Planned qty '||l_planned_qty);
183:
184: Open get_new_batch_cmpt_date (p_new_batch_id) ;
185: Fetch get_new_batch_cmpt_date Into l_plan_cmplt_date;
186: Close get_new_batch_cmpt_date;

Line 205: GMI_reservation_Util.PrintLn(' build res record for the new batch');

201: Loop
202: /* check the batch planned cplt date with the scheduled_ship_date
203: * if the date is out, skip this record
204: */
205: GMI_reservation_Util.PrintLn(' build res record for the new batch');
206: IF each_rec.scheduled_ship_date > l_plan_cmplt_date THEN
207: Goto next_res_line;
208: END IF;
209: EXIT WHEN l_remaining_qty <= 0 ;

Line 231: GMI_reservation_Util.PrintLn(' new reserved qty '||l_reserved_qty);

227: l_reserved_qty2 := l_avg_qty2 ;
228: END IF;
229: l_reservation_rec.reserved_qty := l_reserved_qty;
230: l_reservation_rec.reserved_qty2 := l_reserved_qty2;
231: GMI_reservation_Util.PrintLn(' new reserved qty '||l_reserved_qty);
232:
233: GML_BATCH_OM_UTIL.insert_reservation
234: (
235: P_Gme_om_reservation_rec => l_reservation_rec

Line 261: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');

257: FND_MSG_PUB.count_and_get
258: ( p_count => x_msg_cont
259: , p_data => x_msg_data
260: );
261: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264:
265: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 273: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');

269: FND_MSG_PUB.count_and_get
270: ( p_count => x_msg_cont
271: , p_data => x_msg_data
272: );
273: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');
274:
275: END create_reservation_from_FPO;
276:
277: PROCEDURE create_allocations

Line 363: and (lot_id <> 0 or location <> GMI_Reservation_Util.G_DEFAULT_LOCT)

359: From ic_Tran_pnd
360: Where line_id = p_so_line_id
361: and doc_type = 'OMSO'
362: and delete_mark = 0
363: and (lot_id <> 0 or location <> GMI_Reservation_Util.G_DEFAULT_LOCT)
364: and completed_ind = 0
365: ;
366: BEGIN
367: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 368: GMI_RESERVATION_UTIL.println('Create Allocations ');

364: and completed_ind = 0
365: ;
366: BEGIN
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368: GMI_RESERVATION_UTIL.println('Create Allocations ');
369: l_rule_rec := p_gme_om_rule_rec;
370: l_gme_trans_row := p_gme_trans_row;
371: l_prod_whse := l_gme_trans_row.whse_code;
372:

Line 373: GMI_RESERVATION_UTIL.println(' Production whse code is '|| l_prod_whse);

369: l_rule_rec := p_gme_om_rule_rec;
370: l_gme_trans_row := p_gme_trans_row;
371: l_prod_whse := l_gme_trans_row.whse_code;
372:
373: GMI_RESERVATION_UTIL.println(' Production whse code is '|| l_prod_whse);
374:
375: IF l_rule_rec.rule_id is null THEN
376: l_so_line_rec.whse_code := p_gme_trans_row.whse_code;
377: GML_BATCH_OM_UTIL.get_rule

Line 388: GMI_RESERVATION_UTIL.println('Create Allocations: distribute evenly');

384: , X_msg_data => x_msg_data
385: );
386: END IF;
387: IF l_rule_rec.allocation_priority = 2 THEN /* distribute evenly*/
388: GMI_RESERVATION_UTIL.println('Create Allocations: distribute evenly');
389: Select count(1)
390: Into l_res_count
391: From gml_batch_so_reservations
392: Where batch_line_id = p_batch_line_rec.batch_line_id

Line 424: GMI_RESERVATION_UTIL.find_default_lot

420: l_history_rec.rule_id := l_rule_rec.rule_id;
421:
422: l_go_ahead := 1;
423: /* check default lot */
424: GMI_RESERVATION_UTIL.find_default_lot
425: ( x_return_status => x_return_status,
426: x_msg_count => x_msg_cont,
427: x_msg_data => x_msg_data,
428: x_reservation_id => l_dft_trans_id,

Line 432: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

428: x_reservation_id => l_dft_trans_id,
429: p_line_id => res_rec.so_line_id
430: );
431: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
432: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
433: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');
434: l_history_rec.failure_reason := FND_MESSAGE.GET;
435: l_go_ahead := 0;
436: END IF;

Line 438: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

434: l_history_rec.failure_reason := FND_MESSAGE.GET;
435: l_go_ahead := 0;
436: END IF;
437: IF nvl(l_dft_trans_id,0) = 0 THEN
438: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
439: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');
440: l_history_rec.failure_reason := FND_MESSAGE.GET;
441: l_go_ahead := 0;
442: END IF;

Line 445: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

441: l_go_ahead := 0;
442: END IF;
443: l_dft_tran_rec.trans_id := l_dft_trans_id ;
444: IF NOT GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_dft_tran_rec, l_dft_tran_rec ) THEN
445: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
446: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');
447: l_history_rec.failure_reason := FND_MESSAGE.GET;
448: l_go_ahead := 0;
449: END IF;

Line 452: GMI_RESERVATION_UTIL.println('Create Allocations: building trans rec ');

448: l_go_ahead := 0;
449: END IF;
450: /* build the trans_rec */
451: IF l_go_ahead = 1 THEN
452: GMI_RESERVATION_UTIL.println('Create Allocations: building trans rec ');
453: l_tran_rec := l_dft_tran_rec;
454: GMI_RESERVATION_UTIL.println('Create Allocations: tran.line_id'||l_tran_rec.line_id);
455: PRINT_DEBUG (l_tran_rec,'before build Transaction');
456: build_trans_rec

Line 454: GMI_RESERVATION_UTIL.println('Create Allocations: tran.line_id'||l_tran_rec.line_id);

450: /* build the trans_rec */
451: IF l_go_ahead = 1 THEN
452: GMI_RESERVATION_UTIL.println('Create Allocations: building trans rec ');
453: l_tran_rec := l_dft_tran_rec;
454: GMI_RESERVATION_UTIL.println('Create Allocations: tran.line_id'||l_tran_rec.line_id);
455: PRINT_DEBUG (l_tran_rec,'before build Transaction');
456: build_trans_rec
457: (
458: p_trans_row => p_gme_trans_row

Line 485: GMI_RESERVATION_UTIL.println('Create alloc: over pick is not allowed, adjust qty');

481: Close check_alloc_qty;
482: l_total_req := l_total_alloc + abs(l_dft_tran_rec.trans_qty) ;
483: l_total_req2 := l_total_alloc2 + abs(l_dft_tran_rec.trans_qty2) ;
484: IF abs(l_tran_rec.trans_qty) > (l_total_req - l_total_alloc) THEN
485: GMI_RESERVATION_UTIL.println('Create alloc: over pick is not allowed, adjust qty');
486: /* allocate what is left in the dflt */
487: l_tran_rec.trans_qty := -1 * (l_total_req - l_total_alloc) ;
488: l_tran_rec.trans_qty2 := -1 * (l_total_req2 - l_total_alloc2) ;
489: l_over_alloc := 1;

Line 490: GMI_RESERVATION_UTIL.println('Create alloc: trans qty '||l_tran_rec.trans_qty);

486: /* allocate what is left in the dflt */
487: l_tran_rec.trans_qty := -1 * (l_total_req - l_total_alloc) ;
488: l_tran_rec.trans_qty2 := -1 * (l_total_req2 - l_total_alloc2) ;
489: l_over_alloc := 1;
490: GMI_RESERVATION_UTIL.println('Create alloc: trans qty '||l_tran_rec.trans_qty);
491: GMI_RESERVATION_UTIL.println('Create alloc: trans qty2 '||l_tran_rec.trans_qty2);
492: END IF;
493: IF l_tran_rec.trans_qty >= 0 THEN /* already fulfilled */
494: FND_MESSAGE.SET_NAME('GML', 'GML_OVER_ALLOC_NOT_ALLOWED');

Line 491: GMI_RESERVATION_UTIL.println('Create alloc: trans qty2 '||l_tran_rec.trans_qty2);

487: l_tran_rec.trans_qty := -1 * (l_total_req - l_total_alloc) ;
488: l_tran_rec.trans_qty2 := -1 * (l_total_req2 - l_total_alloc2) ;
489: l_over_alloc := 1;
490: GMI_RESERVATION_UTIL.println('Create alloc: trans qty '||l_tran_rec.trans_qty);
491: GMI_RESERVATION_UTIL.println('Create alloc: trans qty2 '||l_tran_rec.trans_qty2);
492: END IF;
493: IF l_tran_rec.trans_qty >= 0 THEN /* already fulfilled */
494: FND_MESSAGE.SET_NAME('GML', 'GML_OVER_ALLOC_NOT_ALLOWED');
495: l_history_rec.failure_reason := FND_MESSAGE.GET;

Line 512: GMI_RESERVATION_UTIL.println('Create alloc: Lot status ctl with gme trans status is null');

508: IF l_gme_trans_row.lot_status is null THEN
509: FND_MESSAGE.SET_NAME('GML', 'GML_PROD_NULL_STS');
510: --FND_MESSAGE.SET_TOKEN('LOT_STS', l_gme_trans_row.lot_status);
511: l_history_rec.failure_reason := FND_MESSAGE.GET;
512: GMI_RESERVATION_UTIL.println('Create alloc: Lot status ctl with gme trans status is null');
513: l_go_ahead := 0;
514: ELSE
515: l_lot_status := l_gme_trans_row.lot_status ;
516: IF nvl(p_batch_line_rec.release_type,0) = 20 THEN

Line 517: GMI_RESERVATION_UTIL.println('Create alloc: Regenerate allocations');

513: l_go_ahead := 0;
514: ELSE
515: l_lot_status := l_gme_trans_row.lot_status ;
516: IF nvl(p_batch_line_rec.release_type,0) = 20 THEN
517: GMI_RESERVATION_UTIL.println('Create alloc: Regenerate allocations');
518: -- It is a regenerate (set it to value of 20 in regenerate, internal use )
519: /* check the lot_status in ic_loct_inv, where the status may have been changed from original setting*/
520: Select lot_status
521: Into l_lot_status

Line 530: GMI_RESERVATION_UTIL.println('Create alloc: Lot status '|| l_lot_status);

526: AND item_id = l_gme_trans_row.item_id
527: And delete_mark = 0
528: ;
529: END IF;
530: GMI_RESERVATION_UTIL.println('Create alloc: Lot status '|| l_lot_status);
531: Select order_proc_ind
532: Into l_orderable
533: From ic_lots_sts
534: Where lot_status = l_lot_status;

Line 540: GMI_RESERVATION_UTIL.println('Create alloc: Lot status is NOT orderable, OMSO is not created');

536: FND_MESSAGE.SET_NAME('GML', 'GML_LOT_STS_NOT_ORD');
537: FND_MESSAGE.SET_TOKEN('LOT_STS', l_gme_trans_row.lot_status);
538: l_history_rec.failure_reason := FND_MESSAGE.GET;
539: l_go_ahead := 0;
540: GMI_RESERVATION_UTIL.println('Create alloc: Lot status is NOT orderable, OMSO is not created');
541: GML_GME_API_PVT.g_not_to_delete := 1;
542: GMI_RESERVATION_UTIL.println('Create alloc: global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);
543:
544: GML_GME_API_PVT.g_not_to_notify := 1;

Line 542: GMI_RESERVATION_UTIL.println('Create alloc: global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);

538: l_history_rec.failure_reason := FND_MESSAGE.GET;
539: l_go_ahead := 0;
540: GMI_RESERVATION_UTIL.println('Create alloc: Lot status is NOT orderable, OMSO is not created');
541: GML_GME_API_PVT.g_not_to_delete := 1;
542: GMI_RESERVATION_UTIL.println('Create alloc: global g_not_to_delete '||GML_GME_API_PVT.g_not_to_delete);
543:
544: GML_GME_API_PVT.g_not_to_notify := 1;
545:
546: ELSE

Line 571: GMI_reservation_Util.PrintLn('create_allocation, Success');

567: x_msg_count => x_msg_cont,
568: x_msg_data => x_msg_data
569: );
570: IF x_return_status = fnd_api.g_ret_sts_success Then
571: GMI_reservation_Util.PrintLn('create_allocation, Success');
572: l_history_rec.trans_id := l_tran_row.trans_id;
573: l_alloc_done := 1;
574: ELSE
575: GMI_reservation_Util.PrintLn('create_allocation, alloc creation error');

Line 575: GMI_reservation_Util.PrintLn('create_allocation, alloc creation error');

571: GMI_reservation_Util.PrintLn('create_allocation, Success');
572: l_history_rec.trans_id := l_tran_row.trans_id;
573: l_alloc_done := 1;
574: ELSE
575: GMI_reservation_Util.PrintLn('create_allocation, alloc creation error');
576: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
577: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
578: FND_MSG_PUB.ADD;
579: l_history_rec.failure_reason := 'all stack of msgs';

Line 581: GMI_RESERVATION_UTIL.balance_default_lot

577: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
578: FND_MSG_PUB.ADD;
579: l_history_rec.failure_reason := 'all stack of msgs';
580: END IF;
581: GMI_RESERVATION_UTIL.balance_default_lot
582: ( p_ic_default_rec => l_dft_tran_rec
583: , p_opm_item_id => l_dft_tran_rec.item_id
584: , x_return_status => x_return_status
585: , x_msg_count => x_msg_cont

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

586: , x_msg_data => x_msg_data
587: );
588: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
589: THEN
590: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
591: FND_MESSAGE.SET_NAME('GML', 'GML_CANNOT_BAL_DFLT_TRAN');
592: FND_MESSAGE.SET_TOKEN('LOT_STS', l_gme_trans_row.lot_status);
593: l_history_rec.failure_reason := FND_MESSAGE.GET;
594: END IF;

Line 639: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');

635: FND_MSG_PUB.count_and_get
636: ( p_count => x_msg_cont
637: , p_data => x_msg_data
638: );
639: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642:
643: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 651: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');

647: FND_MSG_PUB.count_and_get
648: ( p_count => x_msg_cont
649: , p_data => x_msg_data
650: );
651: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');
652:
653: END create_allocations;
654:
655: PROCEDURE cancel_alloc_for_trans

Line 683: GMI_RESERVATION_UTIL.PrintLn('Cancel_alloc_for_Trans ');

679:
680: BEGIN
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: /* this would remove all the un-staged trans */
683: GMI_RESERVATION_UTIL.PrintLn('Cancel_alloc_for_Trans ');
684: GMI_RESERVATION_UTIL.PrintLn(' Batch trans id '|| p_batch_trans_id);
685: IF p_batch_trans_id is not null THEN
686: /* find out the unstaged trans converted from this batch trans line */
687: for alloc_rec in find_nonstgd_alloc_for_trans(p_batch_trans_id) Loop

Line 684: GMI_RESERVATION_UTIL.PrintLn(' Batch trans id '|| p_batch_trans_id);

680: BEGIN
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: /* this would remove all the un-staged trans */
683: GMI_RESERVATION_UTIL.PrintLn('Cancel_alloc_for_Trans ');
684: GMI_RESERVATION_UTIL.PrintLn(' Batch trans id '|| p_batch_trans_id);
685: IF p_batch_trans_id is not null THEN
686: /* find out the unstaged trans converted from this batch trans line */
687: for alloc_rec in find_nonstgd_alloc_for_trans(p_batch_trans_id) Loop
688: /* call gmi api to delete this trans */

Line 691: GMI_RESERVATION_UTIL.PrintLn(' Deleting trans_id '||l_trans_id);

687: for alloc_rec in find_nonstgd_alloc_for_trans(p_batch_trans_id) Loop
688: /* call gmi api to delete this trans */
689: l_trans_id := alloc_rec.trans_id;
690: l_tran_rec.trans_id := l_trans_id;
691: GMI_RESERVATION_UTIL.PrintLn(' Deleting trans_id '||l_trans_id);
692: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_tran_rec, l_tran_rec ) THEN
693: GMI_TRANS_ENGINE_PUB.delete_pending_transaction
694: (p_api_version => 1.0,
695: p_init_msg_list => FND_API.G_TRUE,

Line 705: GMI_reservation_Util.PrintLn('Delete OMSO trans for Batch trans');

701: x_msg_count => x_msg_cont,
702: x_msg_data => x_msg_data
703: );
704: IF x_return_status <> fnd_api.g_ret_sts_success Then
705: GMI_reservation_Util.PrintLn('Delete OMSO trans for Batch trans');
706: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
707: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
708: FND_MSG_PUB.ADD;
709: END IF;

Line 713: GMI_RESERVATION_UTIL.find_default_lot

709: END IF;
710: END IF;
711: l_dft_tran_rec.line_id := l_tran_rec.line_id;
712: l_dft_tran_rec.trans_id := null;
713: GMI_RESERVATION_UTIL.find_default_lot
714: ( x_return_status => x_return_status,
715: x_msg_count => x_msg_cont,
716: x_msg_data => x_msg_data,
717: x_reservation_id => l_dft_tran_rec.trans_id,

Line 722: GMI_RESERVATION_UTIL.balance_default_lot

718: p_line_id => l_tran_rec.line_id
719: );
720:
721: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_dft_tran_rec, l_dft_tran_rec ) THEN
722: GMI_RESERVATION_UTIL.balance_default_lot
723: ( p_ic_default_rec => l_dft_tran_rec
724: , p_opm_item_id => l_dft_tran_rec.item_id
725: , x_return_status => x_return_status
726: , x_msg_count => x_msg_cont

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

727: , x_msg_data => x_msg_data
728: );
729: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
730: THEN
731: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
732: END IF;
733: END IF;
734: END loop;
735: END IF;

Line 781: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d After DELETE_PENDING_TRANSACTION.');

777: ,x_tran_row => l_tran_row
778: ,x_return_status => x_return_status
779: ,x_msg_count => x_msg_cont
780: ,x_msg_data => x_msg_data);
781: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d After DELETE_PENDING_TRANSACTION.');
782: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
783: THEN
784: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

Line 784: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');

780: ,x_msg_data => x_msg_data);
781: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d After DELETE_PENDING_TRANSACTION.');
782: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
783: THEN
784: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
786: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
787: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
788: FND_MSG_PUB.Add;

Line 859: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: batch_line_id '||p_batch_line_id);

855: l_batch_trans_id NUMBER;
856:
857: BEGIN
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: batch_line_id '||p_batch_line_id);
860: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: whse_code '||p_whse_code);
861: /* this would remove all the un-staged trans */
862: IF p_batch_line_id is not null and p_whse_code is null THEN
863: Update gml_batch_so_reservations

Line 860: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: whse_code '||p_whse_code);

856:
857: BEGIN
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: batch_line_id '||p_batch_line_id);
860: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: whse_code '||p_whse_code);
861: /* this would remove all the un-staged trans */
862: IF p_batch_line_id is not null and p_whse_code is null THEN
863: Update gml_batch_so_reservations
864: Set delete_mark = 1

Line 868: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: no reservations');

864: Set delete_mark = 1
865: Where batch_line_id = p_batch_line_id
866: and delete_mark = 0;
867: IF SQL%NOTFOUND THEN
868: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: no reservations');
869: END IF;
870: END IF;
871: IF p_batch_line_id is not null and p_whse_code is not null THEN
872: Update gml_batch_so_reservations

Line 878: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: no reservations');

874: Where batch_line_id = p_batch_line_id
875: and whse_code = p_whse_code
876: and delete_mark = 0;
877: IF SQL%NOTFOUND THEN
878: GMI_reservation_Util.PrintLn('cancel_res_for_batch_line: no reservations');
879: END IF;
880: END IF;
881: END cancel_res_for_batch_line;
882:

Line 895: GMI_reservation_Util.PrintLn('cancel_res_for_so_line: so_line_id '||p_so_line_id);

891: l_batch_trans_id NUMBER;
892:
893: BEGIN
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895: GMI_reservation_Util.PrintLn('cancel_res_for_so_line: so_line_id '||p_so_line_id);
896: /* this would remove all the un-staged trans */
897: IF p_so_line_id is not null THEN
898: Update gml_batch_so_reservations
899: Set delete_mark = 1

Line 903: GMI_reservation_Util.PrintLn('cancel_res_for_so_line: no reservations');

899: Set delete_mark = 1
900: Where so_line_id = p_so_line_id
901: and delete_mark = 0;
902: IF SQL%NOTFOUND THEN
903: GMI_reservation_Util.PrintLn('cancel_res_for_so_line: no reservations');
904: END IF;
905: END IF;
906: END cancel_res_for_so_line;
907:

Line 918: GMI_reservation_Util.PrintLn('cancel_res_for_batch: batch_id '||p_batch_id);

914: ) IS
915:
916: BEGIN
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: GMI_reservation_Util.PrintLn('cancel_res_for_batch: batch_id '||p_batch_id);
919: /* this would remove all the un-staged trans */
920: IF p_batch_id is not null THEN
921: Update gml_batch_so_reservations
922: Set delete_mark = 1

Line 926: GMI_reservation_Util.PrintLn('cancel_res_for_batch: no reservations');

922: Set delete_mark = 1
923: Where batch_id = p_batch_id
924: and delete_mark = 0;
925: IF SQL%NOTFOUND THEN
926: GMI_reservation_Util.PrintLn('cancel_res_for_batch: no reservations');
927: END IF;
928: END IF;
929: END cancel_res_for_batch;
930:

Line 1095: GMI_RESERVATION_UTIL.PrintLn('Entering Notify_ CSR ...........');

1091: l_batch_id := p_batch_id;
1092: l_whse_code := p_whse_code;
1093:
1094: /* will send the work flow */
1095: GMI_RESERVATION_UTIL.PrintLn('Entering Notify_ CSR ...........');
1096:
1097: IF p_batch_id is not null THEN
1098:
1099: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_id is'|| p_batch_id);

Line 1099: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_id is'|| p_batch_id);

1095: GMI_RESERVATION_UTIL.PrintLn('Entering Notify_ CSR ...........');
1096:
1097: IF p_batch_id is not null THEN
1098:
1099: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_id is'|| p_batch_id);
1100: OPEN so_line_id_for_batch(p_batch_id);
1101: FETCH so_line_id_for_batch INTO l_so_line_id;
1102: IF(so_line_id_for_batch%NOTFOUND) THEN
1103: CLOSE so_line_id_for_batch;

Line 1104: GMI_RESERVATION_UTIL.PrintLn(' so_line_id_for_batch%NOTFOUND, returning from Notify CSR');

1100: OPEN so_line_id_for_batch(p_batch_id);
1101: FETCH so_line_id_for_batch INTO l_so_line_id;
1102: IF(so_line_id_for_batch%NOTFOUND) THEN
1103: CLOSE so_line_id_for_batch;
1104: GMI_RESERVATION_UTIL.PrintLn(' so_line_id_for_batch%NOTFOUND, returning from Notify CSR');
1105: RETURN;
1106: END IF;
1107:
1108: CLOSE so_line_id_for_batch;

Line 1114: GMI_RESERVATION_UTIL.PrintLn(' get_batch_type%NOTFOUND, returning from Notify CSR');

1110: OPEN get_batch_type(p_batch_id);
1111: FETCH get_batch_type INTO l_batch_type;
1112: IF(get_batch_type%NOTFOUND) THEN
1113: CLOSE get_batch_type;
1114: GMI_RESERVATION_UTIL.PrintLn(' get_batch_type%NOTFOUND, returning from Notify CSR');
1115: RETURN;
1116: END IF;
1117:
1118: CLOSE get_batch_type;

Line 1123: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_line_id is '|| p_batch_line_id);

1119:
1120: END IF;
1121:
1122: IF p_batch_line_id is not null THEN
1123: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_line_id is '|| p_batch_line_id);
1124: OPEN so_line_id_for_batch_line(p_batch_line_id);
1125: FETCH so_line_id_for_batch_line INTO l_so_line_id;
1126: IF(so_line_id_for_batch_line%NOTFOUND) THEN
1127: CLOSE so_line_id_for_batch_line;

Line 1128: GMI_RESERVATION_UTIL.PrintLn(' so_line_id_for_batch_line%NOTFOUND, returning from Notify CSR');

1124: OPEN so_line_id_for_batch_line(p_batch_line_id);
1125: FETCH so_line_id_for_batch_line INTO l_so_line_id;
1126: IF(so_line_id_for_batch_line%NOTFOUND) THEN
1127: CLOSE so_line_id_for_batch_line;
1128: GMI_RESERVATION_UTIL.PrintLn(' so_line_id_for_batch_line%NOTFOUND, returning from Notify CSR');
1129: RETURN;
1130: END IF;
1131: CLOSE so_line_id_for_batch_line;
1132:

Line 1137: GMI_RESERVATION_UTIL.PrintLn(' get_batch_id_for_line%NOTFOUND, returning from Notify CSR');

1133: OPEN get_batch_id_for_line(p_batch_line_id);
1134: FETCH get_batch_id_for_line INTO l_batch_id,l_batch_type;
1135: IF(get_batch_id_for_line%NOTFOUND) THEN
1136: CLOSE get_batch_id_for_line;
1137: GMI_RESERVATION_UTIL.PrintLn(' get_batch_id_for_line%NOTFOUND, returning from Notify CSR');
1138: RETURN;
1139: END IF;
1140: CLOSE get_batch_id_for_line;
1141:

Line 1145: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_trans_id is '|| p_batch_trans_id);

1141:
1142: END IF;
1143: IF p_batch_trans_id is not null THEN
1144:
1145: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Batch_trans_id is '|| p_batch_trans_id);
1146:
1147: OPEN so_line_id_for_batch_trans(p_batch_trans_id);
1148: FETCH so_line_id_for_batch_trans INTO l_so_line_id;
1149: IF(so_line_id_for_batch_trans%NOTFOUND) THEN

Line 1151: GMI_RESERVATION_UTIL.PrintLn(' so_line_id_for_batch_trans%NOTFOUND, returning from Notify CSR');

1147: OPEN so_line_id_for_batch_trans(p_batch_trans_id);
1148: FETCH so_line_id_for_batch_trans INTO l_so_line_id;
1149: IF(so_line_id_for_batch_trans%NOTFOUND) THEN
1150: CLOSE so_line_id_for_batch_trans;
1151: GMI_RESERVATION_UTIL.PrintLn(' so_line_id_for_batch_trans%NOTFOUND, returning from Notify CSR');
1152: RETURN;
1153: END IF;
1154: CLOSE so_line_id_for_batch_trans;
1155:

Line 1160: GMI_RESERVATION_UTIL.PrintLn(' get_batch_id_for_trans%NOTFOUND, returning from Notify CSR');

1156: OPEN get_batch_id_for_trans(p_batch_trans_id);
1157: FETCH get_batch_id_for_trans INTO l_batch_id,l_batch_type, l_batch_line_id;
1158: IF(get_batch_id_for_trans%NOTFOUND) THEN
1159: CLOSE get_batch_id_for_trans;
1160: GMI_RESERVATION_UTIL.PrintLn(' get_batch_id_for_trans%NOTFOUND, returning from Notify CSR');
1161: RETURN;
1162: END IF;
1163:
1164: CLOSE get_batch_id_for_trans;

Line 1174: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : so_line_id is'|| l_so_line_id);

1170: null;
1171: END IF;
1172:
1173:
1174: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : so_line_id is'|| l_so_line_id);
1175: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_whse_code is'|| l_whse_code);
1176: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_action_code is'|| p_action_code);
1177:
1178: l_action_code := p_action_code;

Line 1175: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_whse_code is'|| l_whse_code);

1171: END IF;
1172:
1173:
1174: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : so_line_id is'|| l_so_line_id);
1175: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_whse_code is'|| l_whse_code);
1176: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_action_code is'|| p_action_code);
1177:
1178: l_action_code := p_action_code;
1179:

Line 1176: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_action_code is'|| p_action_code);

1172:
1173:
1174: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : so_line_id is'|| l_so_line_id);
1175: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_whse_code is'|| l_whse_code);
1176: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : p_action_code is'|| p_action_code);
1177:
1178: l_action_code := p_action_code;
1179:
1180: IF(p_action_code = 'CANCEL') THEN

Line 1199: GMI_RESERVATION_UTIL.PrintLn(' find_nonstgd_alloc_for_trans%NOTFOUND, returning from Notify CSR');

1195: OPEN find_nonstgd_alloc_for_trans(p_batch_trans_id);
1196: FETCH find_nonstgd_alloc_for_trans INTO l_no_of_unstaged_alloc;
1197: IF(find_nonstgd_alloc_for_trans%NOTFOUND) THEN
1198: CLOSE find_nonstgd_alloc_for_trans;
1199: GMI_RESERVATION_UTIL.PrintLn(' find_nonstgd_alloc_for_trans%NOTFOUND, returning from Notify CSR');
1200: RETURN;
1201: END IF;
1202: CLOSE find_nonstgd_alloc_for_trans;
1203:

Line 1211: GMI_RESERVATION_UTIL.PrintLn(' find_staged_alloc_for_trans%NOTFOUND, returning from Notify CSR');

1207: OPEN find_staged_alloc_for_trans(p_batch_trans_id);
1208: FETCH find_staged_alloc_for_trans INTO l_no_of_staged_alloc;
1209: IF(find_staged_alloc_for_trans%NOTFOUND) THEN
1210: CLOSE find_staged_alloc_for_trans;
1211: GMI_RESERVATION_UTIL.PrintLn(' find_staged_alloc_for_trans%NOTFOUND, returning from Notify CSR');
1212: RETURN;
1213: END IF;
1214:
1215: CLOSE find_nonstgd_alloc_for_trans;

Line 1226: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_action_code is'|| l_action_code);

1222:
1223: END IF;
1224:
1225:
1226: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_action_code is'|| l_action_code);
1227:
1228: OPEN CSR_for_so_line(l_so_line_id);
1229: FETCH CSR_for_so_line INTO l_last_updated_by,l_created_by, l_so_header_id;
1230: IF(CSR_for_so_line%NOTFOUND) THEN

Line 1232: GMI_RESERVATION_UTIL.PrintLn(' CSR_for_so_line%NOTFOUND, returning from Notify CSR');

1228: OPEN CSR_for_so_line(l_so_line_id);
1229: FETCH CSR_for_so_line INTO l_last_updated_by,l_created_by, l_so_header_id;
1230: IF(CSR_for_so_line%NOTFOUND) THEN
1231: CLOSE CSR_for_so_line;
1232: GMI_RESERVATION_UTIL.PrintLn(' CSR_for_so_line%NOTFOUND, returning from Notify CSR');
1233: RETURN;
1234: END IF;
1235: CLOSE CSR_for_so_line;
1236: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_last_updated_by is '||l_last_updated_by);

Line 1236: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_last_updated_by is '||l_last_updated_by);

1232: GMI_RESERVATION_UTIL.PrintLn(' CSR_for_so_line%NOTFOUND, returning from Notify CSR');
1233: RETURN;
1234: END IF;
1235: CLOSE CSR_for_so_line;
1236: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_last_updated_by is '||l_last_updated_by);
1237: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1238: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1239: , p_approver => l_last_updated_by
1240: , p_so_header_id=> l_so_header_id

Line 1237: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');

1233: RETURN;
1234: END IF;
1235: CLOSE CSR_for_so_line;
1236: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_last_updated_by is '||l_last_updated_by);
1237: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1238: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1239: , p_approver => l_last_updated_by
1240: , p_so_header_id=> l_so_header_id
1241: , p_so_line_id => l_so_line_id

Line 1249: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);

1245: , p_action_code => l_action_code );
1246:
1247: IF(l_last_updated_by <> l_created_by) THEN
1248:
1249: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);
1250: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1251:
1252: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1253: , p_approver => l_created_by

Line 1250: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');

1246:
1247: IF(l_last_updated_by <> l_created_by) THEN
1248:
1249: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);
1250: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1251:
1252: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1253: , p_approver => l_created_by
1254: , p_so_header_id=> l_so_header_id

Line 1276: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Multiple sales orders, header_id'||l_so_header_id);

1272: IF l_new_header_id <> l_old_header_id THEN
1273: l_so_header_id := l_new_header_id;
1274: l_old_header_id := l_new_header_id;
1275:
1276: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
1277: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1278: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1279: , p_approver => l_last_updated_by
1280: , p_so_header_id=> l_so_header_id

Line 1277: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');

1273: l_so_header_id := l_new_header_id;
1274: l_old_header_id := l_new_header_id;
1275:
1276: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
1277: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1278: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1279: , p_approver => l_last_updated_by
1280: , p_so_header_id=> l_so_header_id
1281: , p_so_line_id => l_so_line_id

Line 1289: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);

1285: , p_action_code => l_action_code );
1286:
1287: IF(l_last_updated_by <> l_created_by) THEN
1288:
1289: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);
1290: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1291:
1292: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1293: , p_approver => l_created_by

Line 1290: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');

1286:
1287: IF(l_last_updated_by <> l_created_by) THEN
1288:
1289: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);
1290: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1291:
1292: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1293: , p_approver => l_created_by
1294: , p_so_header_id=> l_so_header_id

Line 1314: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Multiple sales orders, header_id'||l_so_header_id);

1310: IF l_new_header_id <> l_old_header_id THEN
1311: l_so_header_id := l_new_header_id;
1312: l_old_header_id := l_new_header_id;
1313:
1314: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
1315: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1316: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1317: , p_approver => l_last_updated_by
1318: , p_so_header_id=> l_so_header_id

Line 1315: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');

1311: l_so_header_id := l_new_header_id;
1312: l_old_header_id := l_new_header_id;
1313:
1314: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
1315: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1316: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1317: , p_approver => l_last_updated_by
1318: , p_so_header_id=> l_so_header_id
1319: , p_so_line_id => l_so_line_id

Line 1327: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);

1323: , p_action_code => l_action_code );
1324:
1325: IF(l_last_updated_by <> l_created_by) THEN
1326:
1327: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);
1328: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1329:
1330: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1331: , p_approver => l_created_by

Line 1328: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');

1324:
1325: IF(l_last_updated_by <> l_created_by) THEN
1326:
1327: GMI_RESERVATION_UTIL.PrintLn('Notify CSR : l_created_by is '||l_created_by);
1328: GMI_RESERVATION_UTIL.PrintLn('Initiating the Workflow......');
1329:
1330: GML_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
1331: , p_approver => l_created_by
1332: , p_so_header_id=> l_so_header_id

Line 1344: GMI_RESERVATION_UTIL.PrintLn('Exiting Notify_CSR .............');

1340: END LOOP;
1341: END IF;
1342:
1343:
1344: GMI_RESERVATION_UTIL.PrintLn('Exiting Notify_CSR .............');
1345:
1346: EXCEPTION
1347:
1348: WHEN OTHERS THEN

Line 1349: GMI_RESERVATION_UTIL.PrintLn('WARNING.... In Others Exception in Notify CSR');

1345:
1346: EXCEPTION
1347:
1348: WHEN OTHERS THEN
1349: GMI_RESERVATION_UTIL.PrintLn('WARNING.... In Others Exception in Notify CSR');
1350: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1351:
1352: END notify_CSR;
1353:

Line 1350: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

1346: EXCEPTION
1347:
1348: WHEN OTHERS THEN
1349: GMI_RESERVATION_UTIL.PrintLn('WARNING.... In Others Exception in Notify CSR');
1350: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1351:
1352: END notify_CSR;
1353:
1354: PROCEDURE regenerate_alloc

Line 1374: GMI_reservation_Util.PrintLn('regenerate_alloc: no gme_trans');

1370: Into l_gme_trans_row
1371: From ic_tran_pnd
1372: Where trans_id = p_alloc_history_rec.batch_trans_id;
1373: IF SQL%NOTFOUND THEN
1374: GMI_reservation_Util.PrintLn('regenerate_alloc: no gme_trans');
1375: END IF;
1376: /* set release type = 20, internal use */
1377: l_batch_line_rec.release_type := 20;
1378: GML_BATCH_OM_RES_PVT.create_allocations

Line 1396: GMI_RESERVATION_UTIL.println('Allocation is successful. Pickconfirm');

1392: Where alloc_rec_id = p_alloc_history_rec.alloc_rec_id;
1393:
1394: /* NC Bug#3470056 Call pick confirm if the flag is set */
1395: IF l_gme_om_rule_rec.auto_pick_confirm = 'Y' THEN
1396: GMI_RESERVATION_UTIL.println('Allocation is successful. Pickconfirm');
1397: /* get the mo line id for the source line */
1398: GML_BATCH_OM_RES_PVT.pick_confirm
1399: (
1400: P_batch_line_rec => l_batch_line_rec

Line 1409: GMI_RESERVATION_UTIL.PrintLn('WARNING : Pick Confirm Returned error after re-generating the allocations');

1405: );
1406:
1407: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)
1408: THEN
1409: GMI_RESERVATION_UTIL.PrintLn('WARNING : Pick Confirm Returned error after re-generating the allocations');
1410: END IF;
1411:
1412: END IF;
1413:

Line 1415: GMI_reservation_Util.PrintLn('In Else part after GML_BATCH_OM_RES_PVT.create_allocations returned a status other than success In regenerate_alloc');

1411:
1412: END IF;
1413:
1414: ELSE
1415: GMI_reservation_Util.PrintLn('In Else part after GML_BATCH_OM_RES_PVT.create_allocations returned a status other than success In regenerate_alloc');
1416: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');
1417: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
1418: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
1419: FND_MSG_PUB.ADD;

Line 1416: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');

1412: END IF;
1413:
1414: ELSE
1415: GMI_reservation_Util.PrintLn('In Else part after GML_BATCH_OM_RES_PVT.create_allocations returned a status other than success In regenerate_alloc');
1416: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');
1417: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
1418: FND_MESSAGE.Set_Token('WHERE', 'Check rules');
1419: FND_MSG_PUB.ADD;
1420: RAISE FND_API.G_EXC_ERROR;

Line 1485: GMI_reservation_Util.PrintLn('Split Reservations for GME');

1481: res_rec c_reservations%rowtype;
1482:
1483: BEGIN
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485: GMI_reservation_Util.PrintLn('Split Reservations for GME');
1486: /* check the reservations, if non exists, exit */
1487: IF p_old_source_line_id is not null THEN
1488: IF NOT GML_BATCH_OM_UTIL.check_reservation
1489: (

Line 1496: GMI_reservation_Util.PrintLn('Split Reservations: No reservations found for so line ');

1492: , X_msg_cont => x_msg_count
1493: , X_msg_data => x_msg_data
1494: )
1495: THEN
1496: GMI_reservation_Util.PrintLn('Split Reservations: No reservations found for so line ');
1497: return;
1498: END IF;
1499: END IF;
1500: IF p_old_delivery_detail_id is not null THEN

Line 1509: GMI_reservation_Util.PrintLn('Split Reservations: No reservations found for wdd line ');

1505: , X_msg_cont => x_msg_count
1506: , X_msg_data => x_msg_data
1507: )
1508: THEN
1509: GMI_reservation_Util.PrintLn('Split Reservations: No reservations found for wdd line ');
1510: return;
1511: END IF;
1512: END IF;
1513: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);

Line 1513: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);

1509: GMI_reservation_Util.PrintLn('Split Reservations: No reservations found for wdd line ');
1510: return;
1511: END IF;
1512: END IF;
1513: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
1514: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
1515: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
1516: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
1517:

Line 1514: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);

1510: return;
1511: END IF;
1512: END IF;
1513: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
1514: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
1515: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
1516: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
1517:
1518: IF p_action = 'B' THEN -- Back ordering or staging

Line 1515: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);

1511: END IF;
1512: END IF;
1513: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
1514: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
1515: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
1516: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
1517:
1518: IF p_action = 'B' THEN -- Back ordering or staging
1519: Update gml_batch_so_reservations

Line 1516: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);

1512: END IF;
1513: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
1514: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
1515: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
1516: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
1517:
1518: IF p_action = 'B' THEN -- Back ordering or staging
1519: Update gml_batch_so_reservations
1520: Set so_line_id = p_new_source_line_id

Line 1536: GMI_RESERVATION_UTIL.PrintLn('Updated Here');

1532: Where so_line_id = p_old_source_line_id
1533: and delivery_detail_id = p_new_delivery_detail_id
1534: and delte_mark = 0
1535: and reserved_qty <> 0;
1536: GMI_RESERVATION_UTIL.PrintLn('Updated Here');
1537: END IF;*/
1538: -- all GME reservations now are for controlled items only
1539: l_fulfilled_qty := 0;
1540: l_qty_to_fulfil := p_orig_qty - p_qty_to_split;

Line 1545: GMI_RESERVATION_UTIL.Println('in split_res, qty to split '||p_qty_to_split);

1541: l_qty2_to_fulfil := p_orig_qty2 - p_qty2_to_split;
1542: --l_qty_to_fulfil := p_qty_to_split;
1543: --l_qty2_to_fulfil := p_qty2_to_split;
1544:
1545: GMI_RESERVATION_UTIL.Println('in split_res, qty to split '||p_qty_to_split);
1546: GMI_RESERVATION_UTIL.Println('in split_res, qty2 to split '||p_qty2_to_split);
1547: GMI_RESERVATION_UTIL.Println('in split_res, qty to fulfil '||l_qty_to_fulfil);
1548: IF p_old_delivery_detail_id is null THEN -- not booked
1549: Open c_reservations1;

Line 1546: GMI_RESERVATION_UTIL.Println('in split_res, qty2 to split '||p_qty2_to_split);

1542: --l_qty_to_fulfil := p_qty_to_split;
1543: --l_qty2_to_fulfil := p_qty2_to_split;
1544:
1545: GMI_RESERVATION_UTIL.Println('in split_res, qty to split '||p_qty_to_split);
1546: GMI_RESERVATION_UTIL.Println('in split_res, qty2 to split '||p_qty2_to_split);
1547: GMI_RESERVATION_UTIL.Println('in split_res, qty to fulfil '||l_qty_to_fulfil);
1548: IF p_old_delivery_detail_id is null THEN -- not booked
1549: Open c_reservations1;
1550: ELSE

Line 1547: GMI_RESERVATION_UTIL.Println('in split_res, qty to fulfil '||l_qty_to_fulfil);

1543: --l_qty2_to_fulfil := p_qty2_to_split;
1544:
1545: GMI_RESERVATION_UTIL.Println('in split_res, qty to split '||p_qty_to_split);
1546: GMI_RESERVATION_UTIL.Println('in split_res, qty2 to split '||p_qty2_to_split);
1547: GMI_RESERVATION_UTIL.Println('in split_res, qty to fulfil '||l_qty_to_fulfil);
1548: IF p_old_delivery_detail_id is null THEN -- not booked
1549: Open c_reservations1;
1550: ELSE
1551: Open c_reservations;

Line 1568: GMI_RESERVATION_UTIL.Println('in split_res, keep trans the same for batch_res_id '||res_rec.batch_res_id);

1564: EXIT WHEN c_reservations%NOTFOUND;
1565: END IF;
1566: IF abs(res_rec.reserved_qty) < l_qty_to_fulfil THEN
1567: /* do nothing for the res */
1568: GMI_RESERVATION_UTIL.Println('in split_res, keep trans the same for batch_res_id '||res_rec.batch_res_id);
1569: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);
1570: l_qty_to_fulfil := l_qty_to_fulfil - abs(res_rec.reserved_qty);
1571: l_qty2_to_fulfil := l_qty2_to_fulfil - abs(res_rec.reserved_qty2);
1572: ELSIF res_rec.reserved_qty > l_qty_to_fulfil AND l_qty_to_fulfil > 0 THEN

Line 1569: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);

1565: END IF;
1566: IF abs(res_rec.reserved_qty) < l_qty_to_fulfil THEN
1567: /* do nothing for the res */
1568: GMI_RESERVATION_UTIL.Println('in split_res, keep trans the same for batch_res_id '||res_rec.batch_res_id);
1569: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);
1570: l_qty_to_fulfil := l_qty_to_fulfil - abs(res_rec.reserved_qty);
1571: l_qty2_to_fulfil := l_qty2_to_fulfil - abs(res_rec.reserved_qty2);
1572: ELSIF res_rec.reserved_qty > l_qty_to_fulfil AND l_qty_to_fulfil > 0 THEN
1573: update gml_batch_so_reservations

Line 1578: GMI_RESERVATION_UTIL.Println('in split_res, split res '||res_rec.batch_res_id);

1574: set reserved_qty = l_qty_to_fulfil
1575: , reserved_qty2 = l_qty2_to_fulfil
1576: Where batch_res_id = res_rec.batch_res_id;
1577:
1578: GMI_RESERVATION_UTIL.Println('in split_res, split res '||res_rec.batch_res_id);
1579: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);
1580: l_so_line_rec.so_line_id := null;
1581: l_batch_line_rec.batch_line_id := null;
1582: l_reservation_rec.batch_res_id := res_rec.batch_res_id;

Line 1579: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);

1575: , reserved_qty2 = l_qty2_to_fulfil
1576: Where batch_res_id = res_rec.batch_res_id;
1577:
1578: GMI_RESERVATION_UTIL.Println('in split_res, split res '||res_rec.batch_res_id);
1579: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);
1580: l_so_line_rec.so_line_id := null;
1581: l_batch_line_rec.batch_line_id := null;
1582: l_reservation_rec.batch_res_id := res_rec.batch_res_id;
1583: /* create a new res for the new wdd, and new line_id if applicable */

Line 1609: GMI_RESERVATION_UTIL.Println('in split_res, update res '||res_rec.batch_res_id);

1605: /* qty filfilled*/
1606: l_qty_to_fulfil := 0;
1607: l_qty2_to_fulfil := 0;
1608: ELSIF l_qty_to_fulfil <= 0 THEN
1609: GMI_RESERVATION_UTIL.Println('in split_res, update res '||res_rec.batch_res_id);
1610: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);
1611: -- simply update the rest with the new wdd id and new line_id
1612: update gml_batch_so_reservations
1613: set delivery_detail_id = p_new_delivery_detail_id

Line 1610: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);

1606: l_qty_to_fulfil := 0;
1607: l_qty2_to_fulfil := 0;
1608: ELSIF l_qty_to_fulfil <= 0 THEN
1609: GMI_RESERVATION_UTIL.Println('in split_res, update res '||res_rec.batch_res_id);
1610: GMI_RESERVATION_UTIL.Println('in split_res, reserved_qty '||res_rec.reserved_qty);
1611: -- simply update the rest with the new wdd id and new line_id
1612: update gml_batch_so_reservations
1613: set delivery_detail_id = p_new_delivery_detail_id
1614: , so_line_id = p_new_source_line_id

Line 1633: GMI_reservation_Util.PrintLn('Split reservations: EXCEPTION: Expected');

1629: FND_MSG_PUB.count_and_get
1630: ( p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );
1633: GMI_reservation_Util.PrintLn('Split reservations: EXCEPTION: Expected');
1634: WHEN OTHERS THEN
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636:
1637: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 1645: GMI_reservation_Util.PrintLn('Split reservations EXCEPTION: Others');

1641: FND_MSG_PUB.count_and_get
1642: ( p_count => x_msg_count
1643: , p_data => x_msg_data
1644: );
1645: GMI_reservation_Util.PrintLn('Split reservations EXCEPTION: Others');
1646:
1647: END split_reservations;
1648:
1649: PROCEDURE split_reservations_from_om

Line 1753: GMI_RESERVATION_UTIL.println('Pick confirm move order line id '|| l_mo_line_id);

1749: l_mo_line_id := 0;
1750: /* get the move order line id */
1751: for mo_id_rec in get_mo_line_id(p_batch_line_rec.batch_line_id) loop
1752: l_mo_line_id := mo_id_rec.move_order_line_id;
1753: GMI_RESERVATION_UTIL.println('Pick confirm move order line id '|| l_mo_line_id);
1754: IF nvl(l_mo_line_id, 0) <> 0 THEN
1755: GMI_MOVE_ORDER_LINE_UTIL.Line_Pick_Confirm
1756: ( p_mo_line_id => l_mo_line_id
1757: , p_init_msg_list => 1

Line 1768: GMI_reservation_Util.PrintLn('pick confirm failed ');

1764: , x_msg_count => x_msg_cont
1765: , x_msg_data => x_msg_data
1766: );
1767: IF x_return_status <> fnd_api.g_ret_sts_success Then
1768: GMI_reservation_Util.PrintLn('pick confirm failed ');
1769: FND_MESSAGE.SET_NAME('GMI','GMI_PICK_CONFIRM');
1770: FND_MESSAGE.Set_Token('WHERE', 'pick confirm ');
1771: FND_MSG_PUB.ADD;
1772: --RAISE FND_API.G_EXC_ERROR;

Line 1829: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );

1825: )
1826: IS
1827: BEGIN
1828:
1829: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);

Line 1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);

1826: IS
1827: BEGIN
1828:
1829: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);

Line 1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);

1827: BEGIN
1828:
1829: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);

Line 1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);

1828:
1829: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);

Line 1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);

1829: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);

Line 1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);

1830: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);

Line 1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);

1831: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);

Line 1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);

1832: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);

Line 1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);

1833: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);

Line 1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);

1834: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);

Line 1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);

1835: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);

Line 1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);

1836: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);

Line 1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);

1837: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);

Line 1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);

1838: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);

Line 1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);

1839: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);

Line 1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);

1840: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);

Line 1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);

1841: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);

Line 1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);

1842: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);

Line 1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);

1843: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);

Line 1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);

1844: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);

Line 1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);

1845: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);

Line 1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);

1846: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
1854: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);

Line 1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);

1847: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
1854: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
1855:

Line 1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);

1848: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
1854: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
1855:
1856: END PRINT_DEBUG;

Line 1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);

1849: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
1854: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
1855:
1856: END PRINT_DEBUG;
1857:

Line 1854: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);

1850: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
1851: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
1852: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
1853: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
1854: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
1855:
1856: END PRINT_DEBUG;
1857:
1858: END GML_BATCH_OM_RES_PVT;