DBA Data[Home] [Help]

APPS.GMI_RESERVATION_PVT dependencies on GMI_TRANS_ENGINE_PUB

Line 498: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

494: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
495: l_trans_id NUMBER;
496: X_ALLOCATED_QTY1 NUMBER;
497: X_ALLOCATED_QTY2 NUMBER;
498: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
499: i BINARY_INTEGER :=1;
500: -- added by fabdi 10/01/2001
501: -- fix for bug # 1574957
502: l_whse_ctl number;

Line 783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

779: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
780: THEN
781: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Update_Transaction() updating the default record.');
782: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
784: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
785: FND_MSG_PUB.Add;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;

Line 986: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

982:
983: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
984: l_ic_tran_row IC_TRAN_PND%ROWTYPE;
985:
986: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
987: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
988: l_default_lot_index BINARY_INTEGER;
989: l_original_tran_index BINARY_INTEGER;
990:

Line 987: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

983: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
984: l_ic_tran_row IC_TRAN_PND%ROWTYPE;
985:
986: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
987: l_original_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
988: l_default_lot_index BINARY_INTEGER;
989: l_original_tran_index BINARY_INTEGER;
990:
991: l_to_rsv_qty NUMBER;

Line 1235: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

1231: l_default_tran_rec.trans_qty2 := -1 * ABS(l_new_rsv_to_item_um_qty2);
1232: /* l_default_tran_rec.non_inv := 0;*/
1233: GMI_reservation_Util.PrintLn('(opm_dbg)in PVT u: Update PRIM default Lot to:' || l_default_tran_rec.trans_qty );
1234: GMI_reservation_Util.PrintLn('(opm_dbg)in PVT u: Update SECO default Lot to:' || l_default_tran_rec.trans_qty2 );
1235: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
1236: p_api_version => 1.0
1237: ,p_init_msg_list => fnd_api.g_false
1238: ,p_commit => l_commit
1239: ,p_validation_level => l_validation_level

Line 1247: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');

1243: ,x_msg_count => x_msg_count
1244: ,x_msg_data => x_msg_data);
1245:
1246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1247: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');
1248: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1249: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1250: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1251: FND_MSG_PUB.Add;

Line 1249: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

1245:
1246: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1247: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');
1248: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1249: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1250: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1251: FND_MSG_PUB.Add;
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;

Line 1268: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

1264: l_default_tran_rec.trans_qty2 := -1 * (ABS(l_default_tran_rec.trans_qty2) + ABS(l_new_rsv_to_item_um_qty2));
1265:
1266: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: New qty is More than old ');
1267: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Update default row trans_qty to '|| l_default_tran_rec.trans_qty);
1268: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
1269: p_api_version => 1.0
1270: ,p_init_msg_list => fnd_api.g_false
1271: ,p_commit => l_commit
1272: ,p_validation_level => l_validation_level

Line 1280: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');

1276: ,x_msg_count => x_msg_count
1277: ,x_msg_data => x_msg_data);
1278:
1279: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1280: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');
1281: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1282: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1283: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1284: FND_MSG_PUB.Add;

Line 1282: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

1278:
1279: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1280: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');
1281: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1282: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1283: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1284: FND_MSG_PUB.Add;
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;

Line 1302: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(

1298: /* Delete the record since it is not the default record*/
1299: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Deleting transaction record res_id='||p_original_rsv_rec.reservation_id);
1300: GMI_reservation_Util.PrintLn('(opm_dbg) trans_id='|| l_original_tran_rec.trans_id );
1301:
1302: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(
1303: p_api_version => 1.0
1304: ,p_init_msg_list => fnd_api.g_false
1305: ,p_commit => l_commit
1306: ,p_validation_level => l_validation_level

Line 1316: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');

1312:
1313: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1314: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: ERROR Returned by Delete_Transaction().');
1315: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1316: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
1317: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1318: FND_MSG_PUB.Add;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;

Line 1331: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

1327: l_default_tran_rec.trans_qty2:= -1 * (ABS(l_default_tran_rec.trans_qty2) + ABS(l_new_rsv_to_item_um_qty2));
1328:
1329:
1330: /* Using the modified copy update the default record by calling the transaction engine*/
1331: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
1332: p_api_version => 1.0
1333: ,p_init_msg_list => fnd_api.g_false
1334: ,p_commit => l_commit
1335: ,p_validation_level => l_validation_level

Line 1345: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

1341:
1342: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1343: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: ERROR Returned by Update_Pending_Transaction updating the default record.');
1344: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1345: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1346: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1347: FND_MSG_PUB.Add;
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;

Line 1475: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1471: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Reservation';
1472:
1473: l_commit VARCHAR2(5) := fnd_api.g_false;
1474: l_validation_level VARCHAR2(4) := fnd_api.g_valid_level_full;
1475: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1476: l_tran_to_delete_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1477: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
1478: l_default_lot_index BINARY_INTEGER;
1479: l_allocated_lot_index BINARY_INTEGER;

Line 1476: l_tran_to_delete_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1472:
1473: l_commit VARCHAR2(5) := fnd_api.g_false;
1474: l_validation_level VARCHAR2(4) := fnd_api.g_valid_level_full;
1475: l_default_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1476: l_tran_to_delete_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1477: l_temp_tran_row IC_TRAN_PND%ROWTYPE;
1478: l_default_lot_index BINARY_INTEGER;
1479: l_allocated_lot_index BINARY_INTEGER;
1480: l_default_lot_quantity1 NUMBER;

Line 1596: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(

1592: /* l_tran_to_delete_rec.non_inv := 0;*/
1593: /* Delete the record since it is not the default record*/
1594: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d: Deleting transaction record res_id='||p_rsv_rec.reservation_id||', trans_id='||GMI_Reservation_Util.ic_tran_rec_tbl(l_allocated_lot_index).trans_id );
1595:
1596: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION(
1597: p_api_version => 1.0
1598: ,p_init_msg_list => fnd_api.g_false
1599: ,p_commit => l_commit
1600: ,p_validation_level => l_validation_level

Line 1613: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');

1609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1610: THEN
1611: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
1612: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1613: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
1614: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1615: FND_MSG_PUB.Add;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;

Line 1634: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

1630: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1631: THEN
1632: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Update_Transaction() updating the default record.');
1633: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1634: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1635: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1636: FND_MSG_PUB.Add;
1637: RAISE FND_API.G_EXC_ERROR;
1638: END IF;

Line 1682: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(

1678: /* If the record is the default record then don't delete it just set the quantity to zero*/
1679: l_default_tran_rec.trans_qty := 0 ;
1680: l_default_tran_rec.trans_qty2 := 0 ;
1681: GMI_reservation_Util.PrintLn('updating to zero for the default transction ');
1682: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION(
1683: p_api_version => 1.0
1684: ,p_init_msg_list => fnd_api.g_false
1685: ,p_commit => l_commit
1686: ,p_validation_level => l_validation_level

Line 1696: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

1692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1693: THEN
1694: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Update_Transaction() updating the default record.');
1695: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1696: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1697: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1698: FND_MSG_PUB.Add;
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;