DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on FND_MESSAGE

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

231: trans_qty2 = -1 * p_shipping_line.cycle_count_quantity2
232: WHERE trans_id = l_old_transaction_rec.trans_id;
233:
234: IF SQL%NOTFOUND THEN
235: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
236: FND_MESSAGE.Set_Token('BY_PROC', 'Update default staged indicator');
237: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_Backorder_Txn');
238: FND_MSG_PUB.Add;
239: RAISE FND_API.G_EXC_ERROR;

Line 236: FND_MESSAGE.Set_Token('BY_PROC', 'Update default staged indicator');

232: WHERE trans_id = l_old_transaction_rec.trans_id;
233:
234: IF SQL%NOTFOUND THEN
235: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
236: FND_MESSAGE.Set_Token('BY_PROC', 'Update default staged indicator');
237: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_Backorder_Txn');
238: FND_MSG_PUB.Add;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;

Line 237: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_Backorder_Txn');

233:
234: IF SQL%NOTFOUND THEN
235: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
236: FND_MESSAGE.Set_Token('BY_PROC', 'Update default staged indicator');
237: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_Backorder_Txn');
238: FND_MSG_PUB.Add;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: /* BUG 1577035 END

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

1064: );
1065:
1066: IF (l_lock_status = FALSE) THEN
1067: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1068: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1069: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1070: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1071: FND_MSG_PUB.Add;
1072: RAISE FND_API.G_EXC_ERROR;

Line 1069: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');

1065:
1066: IF (l_lock_status = FALSE) THEN
1067: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1068: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1069: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1070: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1071: FND_MSG_PUB.Add;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;

Line 1070: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');

1066: IF (l_lock_status = FALSE) THEN
1067: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1068: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1069: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1070: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1071: FND_MSG_PUB.Add;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:

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

1703: );
1704:
1705: IF (l_lock_status = FALSE) THEN
1706: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1707: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1708: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1709: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1710: FND_MSG_PUB.Add;
1711: RAISE FND_API.G_EXC_ERROR;

Line 1708: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');

1704:
1705: IF (l_lock_status = FALSE) THEN
1706: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1707: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1708: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1709: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1710: FND_MSG_PUB.Add;
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;

Line 1709: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');

1705: IF (l_lock_status = FALSE) THEN
1706: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1707: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1708: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1709: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1710: FND_MSG_PUB.Add;
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:

Line 2496: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');

2492: IF get_default_loct%NOTFOUND THEN
2493: /* check to see the item is location ctl, if not, raise error */
2494: GMI_RESERVATION_UTIL.println('Item and the dest Org are location controlled,
2495: but no default location setup');
2496: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2497: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_LOC SETUP');
2498: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2499: FND_MSG_PUB.Add;
2500: Close get_default_loct; /* B2886561 close cursor before exception */

Line 2497: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_LOC SETUP');

2493: /* check to see the item is location ctl, if not, raise error */
2494: GMI_RESERVATION_UTIL.println('Item and the dest Org are location controlled,
2495: but no default location setup');
2496: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2497: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_LOC SETUP');
2498: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2499: FND_MSG_PUB.Add;
2500: Close get_default_loct; /* B2886561 close cursor before exception */
2501: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI

Line 2498: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');

2494: GMI_RESERVATION_UTIL.println('Item and the dest Org are location controlled,
2495: but no default location setup');
2496: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2497: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_LOC SETUP');
2498: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2499: FND_MSG_PUB.Add;
2500: Close get_default_loct; /* B2886561 close cursor before exception */
2501: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI
2502: RAISE FND_API.G_EXC_ERROR;

Line 2512: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');

2508: Fetch get_default_sub into l_subinventory;
2509: IF get_default_sub%NOTFOUND THEN
2510: /* check to see the item is location ctl, if not, raise error */
2511: GMI_RESERVATION_UTIL.println('no default subinventory setup for direct receipt');
2512: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2513: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_SUB SETUP');
2514: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2515: FND_MSG_PUB.Add;
2516: Close get_default_sub; /* B2886561 close cursor before exception */

Line 2513: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_SUB SETUP');

2509: IF get_default_sub%NOTFOUND THEN
2510: /* check to see the item is location ctl, if not, raise error */
2511: GMI_RESERVATION_UTIL.println('no default subinventory setup for direct receipt');
2512: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2513: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_SUB SETUP');
2514: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2515: FND_MSG_PUB.Add;
2516: Close get_default_sub; /* B2886561 close cursor before exception */
2517: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI

Line 2514: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');

2510: /* check to see the item is location ctl, if not, raise error */
2511: GMI_RESERVATION_UTIL.println('no default subinventory setup for direct receipt');
2512: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2513: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_SUB SETUP');
2514: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2515: FND_MSG_PUB.Add;
2516: Close get_default_sub; /* B2886561 close cursor before exception */
2517: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI
2518: RAISE FND_API.G_EXC_ERROR;

Line 3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');

3713: GMI_reservation_Util.PrintLn('created new default lot with line_detail_id '||l_new_transaction_row.line_detail_id);
3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3719: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3720: FND_MSG_PUB.Add;
3721: RAISE FND_API.G_EXC_ERROR;

Line 3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3719: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3720: FND_MSG_PUB.Add;
3721: RAISE FND_API.G_EXC_ERROR;
3722: END IF;

Line 3719: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');

3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3719: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3720: FND_MSG_PUB.Add;
3721: RAISE FND_API.G_EXC_ERROR;
3722: END IF;
3723: l_old_transaction_rec.trans_id := l_new_transaction_row.trans_id;