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.INV_VALIDATE_TROLIN dependencies on INV_GLOBALS

Line 170: , p_move_order_type IN NUMBER DEFAULT INV_GLOBALS.G_MOVE_ORDER_REQUISITION

166: ( x_return_status OUT NOCOPY VARCHAR2
167: , p_trolin_rec IN INV_Move_Order_PUB.Trolin_Rec_Type
168: , p_old_trolin_rec IN INV_Move_Order_PUB.Trolin_Rec_Type :=
169: INV_Move_Order_PUB.G_MISS_TROLIN_REC
170: , p_move_order_type IN NUMBER DEFAULT INV_GLOBALS.G_MOVE_ORDER_REQUISITION
171: )
172: IS
173:
174: CURSOR c_get_jobsch_name

Line 241: if( p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then

237: -- Check rest of required attributes here.
238: -- Return Error if a required attribute is missing.
239:
240: IF p_trolin_rec.inventory_item_id IS NULL THEN
241: if( p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
242: l_return_status := FND_API.G_RET_STS_ERROR;
243:
244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
245: FND_MESSAGE.SET_NAME('INV','INV_ENTER_ITEM');

Line 248: elsif( p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY AND p_trolin_rec.lpn_id is NULL) then

244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
245: FND_MESSAGE.SET_NAME('INV','INV_ENTER_ITEM');
246: FND_MSG_PUB.Add;
247: END IF;
248: elsif( p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY AND p_trolin_rec.lpn_id is NULL) then
249: l_return_status := FND_API.G_RET_STS_ERROR;
250: if( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) then
251: FND_MESSAGE.SET_NAME('INV', 'INV_ENTER_ITEM_LPN');
252: FND_MSG_PUB.Add;

Line 268: if( p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then

264: END IF;
265: END IF;
266:
267: IF p_trolin_rec.quantity IS NULL THEN
268: if( p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
269: l_return_status := FND_API.G_RET_STS_ERROR;
270:
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');

Line 279: if( p_trolin_rec.inventory_item_id is not null and p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then

275: end if;
276: END IF;
277:
278: IF p_trolin_rec.uom_code IS NULL THEN
279: if( p_trolin_rec.inventory_item_id is not null and p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
280: l_return_status := FND_API.G_RET_STS_ERROR;
281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
282: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','UOM'),FALSE);

Line 290: if p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY and p_trolin_rec.inventory_item_id is null then

286: end if;
287: END IF;
288:
289: IF p_trolin_rec.lpn_id IS NULL THEN
290: if p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY and p_trolin_rec.inventory_item_id is null then
291: if( fnd_msg_pub.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)) then
292: FND_MESSAGE.SET_NAME('INV', 'INV_ENTER_ITEM_LPN');
293: FND_MSG_PUB.Add;
294: end if;

Line 300: p_trolin_rec.transaction_type_id <> INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE

296: END IF;
297:
298: IF g_transaction_l.transaction_action_id = 1 THEN
299: IF p_trolin_rec.to_account_id IS NULL AND
300: p_trolin_rec.transaction_type_id <> INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE
301: AND g_item.inventory_asset_flag = 'Y' THEN
302: -- Added the last condition for bug 2519579
303: l_return_status := FND_API.G_RET_STS_ERROR;
304:

Line 328: (INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY, INV_GLOBALS.G_MOVE_ORDER_SYSTEM)) THEN

324: --Bug #4347016
325: --For the Move Order types Putaway and Subinventory, destination subinventory
326: --is not required. Hence Bypass the validation
327: IF (p_move_order_type NOT IN
328: (INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY, INV_GLOBALS.G_MOVE_ORDER_SYSTEM)) THEN
329: l_return_status := FND_API.G_RET_STS_ERROR;
330:
331: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

Line 403: = inv_globals.g_sourcetype_inventory

399: --Bug #4438410, adding validations for WIP component pick release.
400: IF inv_wip_picking_pvt.g_wip_patch_level >= 1159
401: THEN
402: IF p_trolin_rec.transaction_source_type_id
403: = inv_globals.g_sourcetype_inventory
404: AND p_move_order_type = inv_globals.g_move_order_mfg_pick
405: AND p_trolin_rec.to_subinventory_code is not null
406: THEN
407: SELECT NVL(lpn_controlled_flag, 0), reservable_type

Line 404: AND p_move_order_type = inv_globals.g_move_order_mfg_pick

400: IF inv_wip_picking_pvt.g_wip_patch_level >= 1159
401: THEN
402: IF p_trolin_rec.transaction_source_type_id
403: = inv_globals.g_sourcetype_inventory
404: AND p_move_order_type = inv_globals.g_move_order_mfg_pick
405: AND p_trolin_rec.to_subinventory_code is not null
406: THEN
407: SELECT NVL(lpn_controlled_flag, 0), reservable_type
408: INTO l_sub_lpn_controlled, l_sub_reservable

Line 413: IF l_sub_reservable = inv_globals.g_subinventory_reservable

409: FROM mtl_secondary_inventories
410: WHERE organization_id = p_trolin_rec.organization_id
411: AND secondary_inventory_name = p_trolin_rec.to_subinventory_code;
412:
413: IF l_sub_reservable = inv_globals.g_subinventory_reservable
414: THEN
415: -- Get the job or schedule number
416: OPEN c_get_jobsch_name( p_trolin_rec.txn_source_id
417: , p_trolin_rec.organization_id);

Line 436: AND l_sub_lpn_controlled = inv_globals.g_subinventory_lpn_controlled

432: l_return_status := FND_API.G_RET_STS_ERROR;
433: END IF;
434:
435: IF g_wms_org_flag
436: AND l_sub_lpn_controlled = inv_globals.g_subinventory_lpn_controlled
437: THEN
438: -- Get the job or schedule number
439: OPEN c_get_jobsch_name( p_trolin_rec.txn_source_id
440: , p_trolin_rec.organization_id);

Line 1128: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away

1124: FROM mtl_txn_request_headers
1125: WHERE header_id=p_trolin_rec.header_id;
1126:
1127:
1128: IF l_mov_order_type=INV_GLOBALS.g_move_order_put_away
1129: THEN
1130:
1131: IF INV_Validate.Lot_Number(g_lot, inv_validate_trohdr.g_org, g_item) = inv_validate.F THEN
1132: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1312: INV_Globals.Locator_control(

1308: IF p_trolin_rec.to_locator_id IS NULL
1309: AND p_trolin_val_rec.to_locator IS NOT NULL
1310: THEN
1311: v_locator_control :=
1312: INV_Globals.Locator_control(
1313: l_return_status,
1314: l_msg_count,
1315: l_msg_data,
1316: inv_validate_trohdr.g_org.stock_locator_control_code,