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;
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;
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
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;
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;
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:
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;
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;
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:
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 */
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
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;
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 */
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
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;
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;
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;
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;