DBA Data[Home] [Help]

APPS.GML_BATCH_OM_RES_PVT dependencies on FND_MESSAGE

Line 433: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');

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;
437: IF nvl(l_dft_trans_id,0) = 0 THEN

Line 434: l_history_rec.failure_reason := FND_MESSAGE.GET;

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;
437: IF nvl(l_dft_trans_id,0) = 0 THEN
438: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

Line 439: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');

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;
443: l_dft_tran_rec.trans_id := l_dft_trans_id ;

Line 440: l_history_rec.failure_reason := FND_MESSAGE.GET;

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;
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

Line 446: FND_MESSAGE.SET_NAME('GML', 'GML_NO_DFLT_TRAN');

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;
450: /* build the trans_rec */

Line 447: l_history_rec.failure_reason := FND_MESSAGE.GET;

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;
450: /* build the trans_rec */
451: IF l_go_ahead = 1 THEN

Line 494: FND_MESSAGE.SET_NAME('GML', 'GML_OVER_ALLOC_NOT_ALLOWED');

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;
496: l_go_ahead := 0;
497: END IF;
498: END IF;

Line 495: l_history_rec.failure_reason := FND_MESSAGE.GET;

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;
496: l_go_ahead := 0;
497: END IF;
498: END IF;
499: END IF;

Line 509: FND_MESSAGE.SET_NAME('GML', 'GML_PROD_NULL_STS');

505: Fetch check_status_ctl Into l_status_ctl;
506: Close check_status_ctl;
507: IF l_status_ctl <> 0 THEN
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;

Line 510: --FND_MESSAGE.SET_TOKEN('LOT_STS', l_gme_trans_row.lot_status);

506: Close check_status_ctl;
507: IF l_status_ctl <> 0 THEN
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

Line 511: l_history_rec.failure_reason := FND_MESSAGE.GET;

507: IF l_status_ctl <> 0 THEN
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 ;

Line 536: FND_MESSAGE.SET_NAME('GML', 'GML_LOT_STS_NOT_ORD');

532: Into l_orderable
533: From ic_lots_sts
534: Where lot_status = l_lot_status;
535: IF l_orderable = 0 THEN
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');

Line 537: FND_MESSAGE.SET_TOKEN('LOT_STS', l_gme_trans_row.lot_status);

533: From ic_lots_sts
534: Where lot_status = l_lot_status;
535: IF l_orderable = 0 THEN
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;

Line 538: l_history_rec.failure_reason := FND_MESSAGE.GET;

534: Where lot_status = l_lot_status;
535: IF l_orderable = 0 THEN
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);

Line 576: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');

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';
580: END IF;

Line 577: FND_MESSAGE.Set_Token('WHERE', 'Check rules');

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';
580: END IF;
581: GMI_RESERVATION_UTIL.balance_default_lot

Line 591: FND_MESSAGE.SET_NAME('GML', 'GML_CANNOT_BAL_DFLT_TRAN');

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;
595: END IF;

Line 592: FND_MESSAGE.SET_TOKEN('LOT_STS', l_gme_trans_row.lot_status);

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;
595: END IF;
596: IF nvl(p_batch_line_rec.release_type,0) = 20 THEN

Line 593: l_history_rec.failure_reason := FND_MESSAGE.GET;

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;
595: END IF;
596: IF nvl(p_batch_line_rec.release_type,0) = 20 THEN
597: /* IF regenerate, set the current history to delete */

Line 706: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');

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;
710: END IF;

Line 707: FND_MESSAGE.Set_Token('WHERE', 'Check rules');

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;
710: END IF;
711: l_dft_tran_rec.line_id := l_tran_rec.line_id;

Line 785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');

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;
789: RAISE FND_API.G_EXC_ERROR;

Line 786: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.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;
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;

Line 787: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');

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;
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:

Line 1417: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');

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;
1421: END IF;

Line 1418: FND_MESSAGE.Set_Token('WHERE', 'Check rules');

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;
1421: END IF;
1422:

Line 1769: FND_MESSAGE.SET_NAME('GMI','GMI_PICK_CONFIRM');

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;
1773: END IF;

Line 1770: FND_MESSAGE.Set_Token('WHERE', 'pick confirm ');

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;
1773: END IF;
1774: END IF;