DBA Data[Home] [Help]

APPS.GMIVDX dependencies on INV_VALIDATE

Line 240: l_org INV_Validate.org;

236: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;
237: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
238: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
239: l_check_qty NUMBER;
240: l_org INV_Validate.org;
241: l_item INV_Validate.item;
242: l_sub INV_Validate.sub;
243: l_locator INV_Validate.locator;
244: l_odm_lot INV_VALIDATE.lot;

Line 241: l_item INV_Validate.item;

237: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
238: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
239: l_check_qty NUMBER;
240: l_org INV_Validate.org;
241: l_item INV_Validate.item;
242: l_sub INV_Validate.sub;
243: l_locator INV_Validate.locator;
244: l_odm_lot INV_VALIDATE.lot;
245: l_is_revision_control BOOLEAN;

Line 242: l_sub INV_Validate.sub;

238: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
239: l_check_qty NUMBER;
240: l_org INV_Validate.org;
241: l_item INV_Validate.item;
242: l_sub INV_Validate.sub;
243: l_locator INV_Validate.locator;
244: l_odm_lot INV_VALIDATE.lot;
245: l_is_revision_control BOOLEAN;
246: l_is_lot_control BOOLEAN;

Line 243: l_locator INV_Validate.locator;

239: l_check_qty NUMBER;
240: l_org INV_Validate.org;
241: l_item INV_Validate.item;
242: l_sub INV_Validate.sub;
243: l_locator INV_Validate.locator;
244: l_odm_lot INV_VALIDATE.lot;
245: l_is_revision_control BOOLEAN;
246: l_is_lot_control BOOLEAN;
247: l_is_serial_control BOOLEAN;

Line 244: l_odm_lot INV_VALIDATE.lot;

240: l_org INV_Validate.org;
241: l_item INV_Validate.item;
242: l_sub INV_Validate.sub;
243: l_locator INV_Validate.locator;
244: l_odm_lot INV_VALIDATE.lot;
245: l_is_revision_control BOOLEAN;
246: l_is_lot_control BOOLEAN;
247: l_is_serial_control BOOLEAN;
248: l_qoh NUMBER;

Line 265: l_odm_txn_type_rec inv_validate.transaction;

261: l_lot_count pls_integer;
262: l_lot_rec_count pls_integer;
263: l_concat_segs VARCHAR2(4000);
264: l_check_flag VARCHAR2(1);
265: l_odm_txn_type_rec inv_validate.transaction;
266: l_opm_item_primary_uom_code VARCHAR2(3);
267: l_opm_item_secondary_uom_code VARCHAR2(3);
268:
269: Cursor Cur_get_assigment_type (Vorgn_code VARCHAR2) is

Line 444: IF (inv_validate.transaction_type (l_odm_txn_type_rec) = inv_validate.F) THEN

440: ELSIF (p_hdr_rec.transfer_type = 1 ) THEN
441: l_odm_txn_type_rec.transaction_type_id := 32;
442: END IF;
443:
444: IF (inv_validate.transaction_type (l_odm_txn_type_rec) = inv_validate.F) THEN
445: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
446: log_msg('Failed call to inv_validate.transaction_type.');
447: END IF;
448: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');

Line 446: log_msg('Failed call to inv_validate.transaction_type.');

442: END IF;
443:
444: IF (inv_validate.transaction_type (l_odm_txn_type_rec) = inv_validate.F) THEN
445: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
446: log_msg('Failed call to inv_validate.transaction_type.');
447: END IF;
448: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
449: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','TRANSACTION'),FALSE);
450: FND_MSG_PUB.Add;

Line 494: IF (INV_Validate.Organization(l_org) = inv_validate.F) THEN

490: --check the odm inventory organization first for validity as we need it for
491: --validating item in ODM.
492: l_org.organization_id := p_line_rec_tbl(i).odm_inv_organization_id;
493:
494: IF (INV_Validate.Organization(l_org) = inv_validate.F) THEN
495: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
496: log_msg('failed call to INV_Validate.Organization');
497: END IF;
498: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');

Line 496: log_msg('failed call to INV_Validate.Organization');

492: l_org.organization_id := p_line_rec_tbl(i).odm_inv_organization_id;
493:
494: IF (INV_Validate.Organization(l_org) = inv_validate.F) THEN
495: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
496: log_msg('failed call to INV_Validate.Organization');
497: END IF;
498: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');
499: FND_MSG_PUB.Add;
500: RAISE FND_API.G_EXC_ERROR;

Line 529: IF (inv_validate.Inventory_Item (l_item, l_org) = inv_validate.F) THEN

525: END IF;
526:
527: --Validate the item in ODM
528: l_item.inventory_item_id := p_line_rec_tbl(i).odm_item_id;
529: IF (inv_validate.Inventory_Item (l_item, l_org) = inv_validate.F) THEN
530: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
531: log_msg('failed call to inv_validate.Inventory_Item');
532: END IF;
533: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');

Line 531: log_msg('failed call to inv_validate.Inventory_Item');

527: --Validate the item in ODM
528: l_item.inventory_item_id := p_line_rec_tbl(i).odm_item_id;
529: IF (inv_validate.Inventory_Item (l_item, l_org) = inv_validate.F) THEN
530: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
531: log_msg('failed call to inv_validate.Inventory_Item');
532: END IF;
533: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_ERROR;

Line 560: IF (inv_validate.revision (p_line_rec_tbl(i).odm_item_revision, l_org, l_item) = inv_validate.F) THEN

556: FND_MSG_PUB.Add;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: IF (inv_validate.revision (p_line_rec_tbl(i).odm_item_revision, l_org, l_item) = inv_validate.F) THEN
561: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
562: log_msg('failed call to inv_validate.revision');
563: END IF;
564: FND_MESSAGE.SET_NAME('INV', 'INV_INT_REVCODE');

Line 562: log_msg('failed call to inv_validate.revision');

558: END IF;
559:
560: IF (inv_validate.revision (p_line_rec_tbl(i).odm_item_revision, l_org, l_item) = inv_validate.F) THEN
561: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
562: log_msg('failed call to inv_validate.revision');
563: END IF;
564: FND_MESSAGE.SET_NAME('INV', 'INV_INT_REVCODE');
565: FND_MSG_PUB.Add;
566: RAISE FND_API.G_EXC_ERROR;

Line 661: IF (INV_VALIDATE.From_Subinventory

657: --p_acct_txn is 1 when transaction_action_id is 1 (Misc Issue)
658: --0 when any other transaction_action_id (27 for Misc receipt)
659:
660: l_sub.secondary_inventory_name := p_line_rec_tbl(i).odm_subinventory;
661: IF (INV_VALIDATE.From_Subinventory
662: ( p_sub => l_sub
663: ,p_org => l_org
664: ,p_item => l_item
665: ,p_acct_txn => p_hdr_rec.transfer_type

Line 666: ) = inv_validate.F

662: ( p_sub => l_sub
663: ,p_org => l_org
664: ,p_item => l_item
665: ,p_acct_txn => p_hdr_rec.transfer_type
666: ) = inv_validate.F
667: ) THEN
668: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
669: log_msg('failed call to INV_Validate.from_subinventory');
670: END IF;

Line 669: log_msg('failed call to INV_Validate.from_subinventory');

665: ,p_acct_txn => p_hdr_rec.transfer_type
666: ) = inv_validate.F
667: ) THEN
668: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
669: log_msg('failed call to INV_Validate.from_subinventory');
670: END IF;
671: FND_MESSAGE.SET_NAME('INV','INV_INVALID_SUBINV');
672: FND_MSG_PUB.Add;
673: RAISE FND_API.G_EXC_ERROR;

Line 676: --need to call overloaded INV_Validate.validatelocator depending on whether the

672: FND_MSG_PUB.Add;
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;
675:
676: --need to call overloaded INV_Validate.validatelocator depending on whether the
677: --item is restricted locator controlled
678: l_locator.inventory_location_id := p_line_rec_tbl(i).odm_locator_id;
679: --{
680: IF ( (l_org.stock_locator_control_code = 1)

Line 823: IF (INV_Validate.Reason(p_line_rec_tbl(i).odm_reason_id) = inv_validate.F) THEN

819:
820: --Validate the discrete reason id
821: --Entering the discrete reason id is optional.
822: IF (p_line_rec_tbl(i).odm_reason_id IS NOT NULL) THEN
823: IF (INV_Validate.Reason(p_line_rec_tbl(i).odm_reason_id) = inv_validate.F) THEN
824: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
825: log_msg('failed call to INV_Validate.Reason');
826: END IF;
827: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');

Line 825: log_msg('failed call to INV_Validate.Reason');

821: --Entering the discrete reason id is optional.
822: IF (p_line_rec_tbl(i).odm_reason_id IS NOT NULL) THEN
823: IF (INV_Validate.Reason(p_line_rec_tbl(i).odm_reason_id) = inv_validate.F) THEN
824: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
825: log_msg('failed call to INV_Validate.Reason');
826: END IF;
827: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
828: FND_MSG_PUB.Add;
829: RAISE FND_API.G_EXC_ERROR;

Line 874: IF (inv_validate.uom(p_line_rec_tbl(i).odm_quantity_uom_code,l_org,l_item) = inv_validate.F) THEN

870: CLOSE Cur_get_uom_code;
871:
872: /* Jalaj Srivastava Bug 3812701 */
873: /* Validate odm_quantity_uom_code in discrete */
874: IF (inv_validate.uom(p_line_rec_tbl(i).odm_quantity_uom_code,l_org,l_item) = inv_validate.F) THEN
875: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
876: log_msg('failed call to inv_validate.uom');
877: END IF;
878: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');

Line 876: log_msg('failed call to inv_validate.uom');

872: /* Jalaj Srivastava Bug 3812701 */
873: /* Validate odm_quantity_uom_code in discrete */
874: IF (inv_validate.uom(p_line_rec_tbl(i).odm_quantity_uom_code,l_org,l_item) = inv_validate.F) THEN
875: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
876: log_msg('failed call to inv_validate.uom');
877: END IF;
878: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');
879: FND_MSG_PUB.Add;
880: RAISE FND_API.G_EXC_ERROR;

Line 1236: IF (INV_Validate.lot_number (p_lot => l_odm_lot,

1232:
1233: l_odm_lot.lot_number := p_lot_rec_tbl(j).odm_lot_number;
1234:
1235: --{
1236: IF (INV_Validate.lot_number (p_lot => l_odm_lot,
1237: p_org => l_org,
1238: p_item => l_item
1239: ) = inv_validate.F) THEN
1240:

Line 1239: ) = inv_validate.F) THEN

1235: --{
1236: IF (INV_Validate.lot_number (p_lot => l_odm_lot,
1237: p_org => l_org,
1238: p_item => l_item
1239: ) = inv_validate.F) THEN
1240:
1241:
1242: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1243: log_msg('ODM lot does not previously exist when transfer type is 0');