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.GMI_SHIPPING_UTIL dependencies on GMI_TRANS_ENGINE_PUB

Line 69: FUNCTION INVENTORY_GOING_NEG(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) return BOOLEAN;

65: );
66:
67: FUNCTION GMI_TRANS_DATE(p_trans_date date, p_orgn_code VARCHAR2, p_whse_code VARCHAR2) RETURN DATE;
68:
69: FUNCTION INVENTORY_GOING_NEG(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) return BOOLEAN;
70:
71: procedure check_loct_ctl (
72: p_inventory_item_id IN NUMBER
73: ,p_mtl_organization_id IN NUMBER

Line 122: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

118: AND completed_ind = 0
119: AND staged_ind = 1
120: AND delete_mark = 0
121: ORDER BY trans_id;
122: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
123: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
124:
125:
126: BEGIN

Line 123: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

119: AND staged_ind = 1
120: AND delete_mark = 0
121: ORDER BY trans_id;
122: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
123: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
124:
125:
126: BEGIN
127:

Line 261: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

257: /* Delete Original Tranaction */
258:
259: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
260:
261: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
262: ( 1
263: , FND_API.G_FALSE
264: , FND_API.G_FALSE
265: , FND_API.G_VALID_LEVEL_FULL

Line 312: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

308: l_new_transaction_rec.trans_qty2 := -1 * (p_shipping_line.cycle_count_quantity2 + ABS(l_old_transaction_rec.trans_qty2));
309:
310: PRINT_DEBUG (l_new_transaction_rec,' Update Default Transaction');
311:
312: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
313: ( 1
314: , FND_API.G_FALSE
315: , FND_API.G_FALSE
316: , FND_API.G_VALID_LEVEL_FULL

Line 344: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

340:
341:
342: GMI_RESERVATION_UTIL.println('Backout Original Staged Qty ' || l_old_transaction_rec.trans_qty);
343:
344: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
345: ( 1
346: , FND_API.G_FALSE
347: , FND_API.G_FALSE
348: , FND_API.G_VALID_LEVEL_FULL

Line 391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

387: GMI_RESERVATION_UTIL.println('Back Qty2 ' || p_shipping_line.cycle_count_quantity2);
388: GMI_RESERVATION_UTIL.println('Write New Staged Qty ' || l_new_transaction_rec.trans_qty);
389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
390:
391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
392: ( 1
393: , FND_API.G_FALSE
394: , FND_API.G_FALSE
395: , FND_API.G_VALID_LEVEL_FULL

Line 447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

443: l_new_transaction_rec.staged_ind := 0;
444:
445: PRINT_DEBUG (l_old_transaction_rec,'Create Default Back Order');
446:
447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
448: ( 1
449: , FND_API.G_FALSE
450: , FND_API.G_FALSE
451: , FND_API.G_VALID_LEVEL_FULL

Line 482: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

478: l_old_transaction_rec.trans_qty2 := -1 * (ABS(l_old_transaction_rec.trans_qty2) + p_shipping_line.cycle_count_quantity2);
479:
480: PRINT_DEBUG (l_old_transaction_rec,'Update Default Back Order');
481:
482: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
483: ( 1
484: , FND_API.G_FALSE
485: , FND_API.G_FALSE
486: , FND_API.G_VALID_LEVEL_FULL

Line 540: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

536: l_delta_trans_qty2 NUMBER;
537: l_trans_id NUMBER;
538: l_staged_ind NUMBER;
539: l_lock_status BOOLEAN;
540: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
541: l_default_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
542: l_msg_count number;
543: l_msg_data varchar2(3000);
544:

Line 541: l_default_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

537: l_trans_id NUMBER;
538: l_staged_ind NUMBER;
539: l_lock_status BOOLEAN;
540: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
541: l_default_trans_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
542: l_msg_count number;
543: l_msg_data varchar2(3000);
544:
545: CURSOR default_transaction_c IS

Line 580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

576: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
577:
578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
579:
580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
581: ( 1
582: , FND_API.G_FALSE
583: , FND_API.G_FALSE
584: , FND_API.G_VALID_LEVEL_FULL

Line 620: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

616: l_transaction_rec.trans_qty := 0;
617: l_transaction_rec.trans_qty2 := 0;
618: l_transaction_rec.staged_ind := 0;
619: l_transaction_rec.line_detail_id := null;
620: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
621: ( p_api_version => 1.0
622: , p_init_msg_list => FND_API.G_FALSE
623: , p_commit => FND_API.G_FALSE
624: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 677: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

673: , x_msg_data OUT NOCOPY VARCHAR2
674: )
675: IS
676:
677: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;

Line 678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

674: )
675: IS
676:
677: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
678: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
679: l_old_transaction_row ic_tran_pnd%ROWTYPE;
680: l_new_transaction_row ic_tran_pnd%ROWTYPE;
681: l_line_id ic_tran_pnd.line_id%TYPE;
682: l_item_id ic_tran_pnd.item_id%TYPE;

Line 1075: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

1071: FND_MSG_PUB.Add;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1075: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1076: ( 1
1077: , FND_API.G_FALSE
1078: , FND_API.G_FALSE
1079: , FND_API.G_VALID_LEVEL_FULL

Line 1105: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

1101:
1102: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
1103: PRINT_DEBUG (l_old_transaction_rec, 'DELETE RECORD');
1104:
1105: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1106: ( 1
1107: , FND_API.G_FALSE
1108: , FND_API.G_FALSE
1109: , FND_API.G_VALID_LEVEL_FULL

Line 1135: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

1131:
1132: GMI_RESERVATION_UTIL.println('Write New Transaction');
1133: PRINT_DEBUG (l_new_transaction_rec,'CREATE NEW');
1134:
1135: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1136: ( 1
1137: , FND_API.G_FALSE
1138: , FND_API.G_FALSE
1139: , FND_API.G_VALID_LEVEL_FULL

Line 1177: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

1173: GMI_RESERVATION_UTIL.println('Update New Transaction => Completed');
1174:
1175: PRINT_DEBUG (l_new_transaction_rec,'UPDATE TO COMPLETE');
1176:
1177: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1178: ( 1
1179: , FND_API.G_FALSE
1180: , FND_API.G_FALSE
1181: , FND_API.G_VALID_LEVEL_FULL

Line 1213: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

1209:
1210: GMI_RESERVATION_UTIL.println('shipping within tolerance ');
1211: PRINT_DEBUG (l_new_transaction_rec,' 0 out Default Transaction');
1212:
1213: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1214: ( 1
1215: , FND_API.G_FALSE
1216: , FND_API.G_FALSE
1217: , FND_API.G_VALID_LEVEL_FULL

Line 1247: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION

1243:
1244: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
1245: PRINT_DEBUG (l_old_transaction_rec,'Delete Original');
1246:
1247: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1248: ( 1
1249: , FND_API.G_FALSE
1250: , FND_API.G_FALSE
1251: , FND_API.G_VALID_LEVEL_FULL

Line 1281: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

1277:
1278: GMI_RESERVATION_UTIL.println('Create New Transaction For Shipped Qty');
1279: PRINT_DEBUG (l_new_transaction_rec,'Create NEW');
1280:
1281: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1282: ( 1
1283: , FND_API.G_FALSE
1284: , FND_API.G_FALSE
1285: , FND_API.G_VALID_LEVEL_FULL

Line 1320: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

1316:
1317: GMI_RESERVATION_UTIL.println('Update New Transaction to Completed');
1318: PRINT_DEBUG (l_new_transaction_rec,'UPDATE NEW');
1319:
1320: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1321: ( 1
1322: , FND_API.G_FALSE
1323: , FND_API.G_FALSE
1324: , FND_API.G_VALID_LEVEL_FULL

Line 1394: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

1390:
1391:
1392: PRINT_DEBUG (l_new_transaction_rec,'CREATE NEW Staged');
1393:
1394: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1395: ( 1
1396: , FND_API.G_FALSE
1397: , FND_API.G_FALSE
1398: , FND_API.G_VALID_LEVEL_FULL

Line 1431: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

1427: l_delta_trans_qty2;
1428:
1429: GMI_RESERVATION_UTIL.println('Update Default For Staged');
1430:
1431: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1432: ( 1
1433: , FND_API.G_FALSE
1434: , FND_API.G_FALSE
1435: , FND_API.G_VALID_LEVEL_FULL

Line 1475: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

1471: RAISE INVENTORY_NEG_WARNING;
1472: END IF;
1473: END IF;
1474:
1475: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1476: ( 1
1477: , FND_API.G_FALSE
1478: , FND_API.G_FALSE
1479: , FND_API.G_VALID_LEVEL_FULL

Line 1556: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1552: , x_msg_data OUT NOCOPY VARCHAR2
1553: )
1554: IS
1555:
1556: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;

Line 1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1553: )
1554: IS
1555:
1556: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;

Line 1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1554: IS
1555:
1556: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1557: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1558: l_def_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
1559: l_old_transaction_row ic_tran_pnd%ROWTYPE;
1560: l_new_transaction_row ic_tran_pnd%ROWTYPE;
1561: l_line_id ic_tran_pnd.line_id%TYPE;
1562: l_item_id ic_tran_pnd.item_id%TYPE;

Line 1716: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED

1712: END IF;
1713:
1714: PRINT_DEBUG (l_new_transaction_rec,'COMPLETE RECORD');
1715:
1716: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1717: ( 1
1718: , FND_API.G_FALSE
1719: , FND_API.G_FALSE
1720: , FND_API.G_VALID_LEVEL_FULL

Line 1768: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

1764:
1765: GMI_RESERVATION_UTIL.println('shipping within tolerance ');
1766: PRINT_DEBUG (l_new_transaction_rec,' 0 out Default Transaction');
1767:
1768: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1769: ( 1
1770: , FND_API.G_FALSE
1771: , FND_API.G_FALSE
1772: , FND_API.G_VALID_LEVEL_FULL

Line 2001: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1997: x_return_status OUT NOCOPY VARCHAR2,
1998: x_msg_count OUT NOCOPY NUMBER,
1999: x_msg_data OUT NOCOPY VARCHAR2)
2000: IS
2001: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;

Line 2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

1998: x_msg_count OUT NOCOPY NUMBER,
1999: x_msg_data OUT NOCOPY VARCHAR2)
2000: IS
2001: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2002: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
2003: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
2004: l_new_transaction_row ic_tran_pnd%ROWTYPE;
2005: l_line_id ic_tran_pnd.line_id%TYPE;
2006: l_item_id ic_tran_pnd.item_id%TYPE;

Line 2157: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION

2153:
2154: l_old_transaction_rec.trans_qty := -1 * (p_old_req_quantity - p_req_quantity);
2155: l_old_transaction_rec.trans_qty2 := -1 * (p_old_req_quantity2 - p_req_quantity2);
2156:
2157: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
2158: ( 1
2159: , FND_API.G_FALSE
2160: , FND_API.G_FALSE
2161: , FND_API.G_VALID_LEVEL_FULL

Line 2181: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

2177: l_new_transaction_rec.trans_id := NULL;
2178: l_new_transaction_rec.trans_qty := -1 * (p_req_quantity);
2179: l_new_transaction_rec.trans_qty2 := -1 * (p_req_quantity2);
2180:
2181: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2182: ( 1
2183: , FND_API.G_FALSE
2184: , FND_API.G_FALSE
2185: , FND_API.G_VALID_LEVEL_FULL

Line 2243: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec

2239: END UPDATE_OPM_IC_TRAN_PND;
2240:
2241: PROCEDURE PRINT_DEBUG
2242: (
2243: p_tran_rec IN GMI_TRANS_ENGINE_PUB.ictran_rec
2244: ,p_routine IN VARCHAR2
2245: )
2246: IS
2247: BEGIN

Line 3502: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3498: x_return_status OUT NOCOPY VARCHAR2,
3499: x_msg_count OUT NOCOPY NUMBER,
3500: x_msg_data OUT NOCOPY VARCHAR2)
3501: IS
3502: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;

Line 3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3499: x_msg_count OUT NOCOPY NUMBER,
3500: x_msg_data OUT NOCOPY VARCHAR2)
3501: IS
3502: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3503: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
3504: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
3505: l_new_transaction_row ic_tran_pnd%ROWTYPE;
3506: l_trans_id ic_tran_pnd.trans_id%TYPE;
3507: l_item_id ic_tran_pnd.item_id%TYPE;

Line 3701: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(

3697: l_old_transaction_rec.trans_id := null;
3698: l_old_transaction_rec.line_id := p_new_source_line_id;
3699: l_old_transaction_rec.line_detail_id := null;
3700: -- create a new default
3701: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3702: p_api_version => 1.0
3703: ,p_init_msg_list => FND_API.G_FALSE
3704: ,p_commit => FND_API.G_FALSE
3705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');

3712: GMI_reservation_Util.PrintLn('created new default lot with trans_id '||l_new_transaction_row.trans_id);
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;

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 3813: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

3809: l_new_transaction_rec.trans_qty2 := -1 * (abs(l_new_transaction_rec.trans_qty2)
3810: - l_qty2_to_fulfil);
3811: l_new_transaction_rec.line_id := p_new_source_line_id;
3812:
3813: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3814: ( 1
3815: , FND_API.G_FALSE
3816: , FND_API.G_FALSE
3817: , FND_API.G_VALID_LEVEL_FULL

Line 3913: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

3909: l_new_transaction_rec.trans_qty := -1 * (abs(p_qty_to_split));
3910: l_new_transaction_rec.trans_qty2 := -1 * (abs(p_qty2_to_split));
3911: l_new_transaction_rec.line_id := p_new_source_line_id;
3912:
3913: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3914: ( 1
3915: , FND_API.G_FALSE
3916: , FND_API.G_FALSE
3917: , FND_API.G_VALID_LEVEL_FULL

Line 3999: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3995: ,p_shipped_quantity2 IN NUMBER
3996: ,x_return_status OUT NOCOPY VARCHAR2
3997: )
3998: IS
3999: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;

Line 4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

3996: ,x_return_status OUT NOCOPY VARCHAR2
3997: )
3998: IS
3999: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4000: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4001: l_old_transaction_row ic_tran_pnd%ROWTYPE ;
4002: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4003: l_trans_id ic_tran_pnd.trans_id%TYPE;
4004: l_item_id ic_tran_pnd.item_id%TYPE;

Line 4143: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION

4139: - p_shipped_quantity2);
4140: l_new_transaction_rec.line_detail_id := null;
4141:
4142: GMI_RESERVATION_UTIL.println('create trans '||l_trans_id );
4143: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4144: ( 1
4145: , FND_API.G_FALSE
4146: , FND_API.G_FALSE
4147: , FND_API.G_VALID_LEVEL_FULL

Line 4174: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4170: , p_unreserve_mode IN VARCHAR2
4171: , x_return_status OUT NOCOPY VARCHAR2
4172: ) IS
4173: l_trans_id NUMBER;
4174: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4175: l_transaction_row ic_tran_pnd%ROWTYPE;
4176: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4177: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4178: x_msg_count NUMBER;

Line 4177: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

4173: l_trans_id NUMBER;
4174: l_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4175: l_transaction_row ic_tran_pnd%ROWTYPE;
4176: l_new_transaction_row ic_tran_pnd%ROWTYPE;
4177: l_new_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
4178: x_msg_count NUMBER;
4179: x_msg_data VARCHAR2(3000);
4180: l_trans_qty NUMBER;
4181: l_trans_qty2 NUMBER;

Line 4270: FUNCTION INVENTORY_GOING_NEG(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) return BOOLEAN IS

4266:
4267:
4268: /* Bug 2775197. Function to check if inventory is going negative. Returns TRUE if inventory is going negative */
4269:
4270: FUNCTION INVENTORY_GOING_NEG(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) return BOOLEAN IS
4271: l_retval BOOLEAN := FALSE;
4272: l_noninv_ind NUMBER;
4273: l_onhand_qty NUMBER;
4274: l_allow_negative_inv NUMBER ;

Line 4281: CURSOR Cur_get_onhand_qty(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) IS

4277: SELECT noninv_ind
4278: FROM ic_item_mst
4279: WHERE item_id = p_tran_rec.item_id;
4280:
4281: CURSOR Cur_get_onhand_qty(p_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec) IS
4282: SELECT loct_onhand as qty
4283: FROM ic_loct_inv
4284: WHERE item_id = p_tran_rec.item_id
4285: AND whse_code = p_tran_rec.whse_code