DBA Data[Home] [Help]

APPS.GMIVDX dependencies on INV_VALIDATE

Line 233: l_org INV_Validate.org;

229: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;
230: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
231: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
232: l_check_qty NUMBER;
233: l_org INV_Validate.org;
234: l_item INV_Validate.item;
235: l_sub INV_Validate.sub;
236: l_locator INV_Validate.locator;
237: l_odm_lot INV_VALIDATE.lot;

Line 234: l_item INV_Validate.item;

230: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
231: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
232: l_check_qty NUMBER;
233: l_org INV_Validate.org;
234: l_item INV_Validate.item;
235: l_sub INV_Validate.sub;
236: l_locator INV_Validate.locator;
237: l_odm_lot INV_VALIDATE.lot;
238: l_is_revision_control BOOLEAN;

Line 235: l_sub INV_Validate.sub;

231: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
232: l_check_qty NUMBER;
233: l_org INV_Validate.org;
234: l_item INV_Validate.item;
235: l_sub INV_Validate.sub;
236: l_locator INV_Validate.locator;
237: l_odm_lot INV_VALIDATE.lot;
238: l_is_revision_control BOOLEAN;
239: l_is_lot_control BOOLEAN;

Line 236: l_locator INV_Validate.locator;

232: l_check_qty NUMBER;
233: l_org INV_Validate.org;
234: l_item INV_Validate.item;
235: l_sub INV_Validate.sub;
236: l_locator INV_Validate.locator;
237: l_odm_lot INV_VALIDATE.lot;
238: l_is_revision_control BOOLEAN;
239: l_is_lot_control BOOLEAN;
240: l_is_serial_control BOOLEAN;

Line 237: l_odm_lot INV_VALIDATE.lot;

233: l_org INV_Validate.org;
234: l_item INV_Validate.item;
235: l_sub INV_Validate.sub;
236: l_locator INV_Validate.locator;
237: l_odm_lot INV_VALIDATE.lot;
238: l_is_revision_control BOOLEAN;
239: l_is_lot_control BOOLEAN;
240: l_is_serial_control BOOLEAN;
241: l_qoh NUMBER;

Line 258: l_odm_txn_type_rec inv_validate.transaction;

254: l_lot_count pls_integer;
255: l_lot_rec_count pls_integer;
256: l_concat_segs VARCHAR2(4000);
257: l_check_flag VARCHAR2(1);
258: l_odm_txn_type_rec inv_validate.transaction;
259: l_opm_item_primary_uom_code VARCHAR2(3);
260: l_opm_item_secondary_uom_code VARCHAR2(3);
261:
262: Cursor Cur_get_assigment_type (Vorgn_code VARCHAR2) is

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

433: ELSIF (p_hdr_rec.transfer_type = 1 ) THEN
434: l_odm_txn_type_rec.transaction_type_id := 32;
435: END IF;
436:
437: IF (inv_validate.transaction_type (l_odm_txn_type_rec) = inv_validate.F) THEN
438: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
439: log_msg('Failed call to inv_validate.transaction_type.');
440: END IF;
441: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');

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

435: END IF;
436:
437: IF (inv_validate.transaction_type (l_odm_txn_type_rec) = inv_validate.F) THEN
438: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
439: log_msg('Failed call to inv_validate.transaction_type.');
440: END IF;
441: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','TRANSACTION'),FALSE);
443: FND_MSG_PUB.Add;

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

483: --check the odm inventory organization first for validity as we need it for
484: --validating item in ODM.
485: l_org.organization_id := p_line_rec_tbl(i).odm_inv_organization_id;
486:
487: IF (INV_Validate.Organization(l_org) = inv_validate.F) THEN
488: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
489: log_msg('failed call to INV_Validate.Organization');
490: END IF;
491: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');

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

485: l_org.organization_id := p_line_rec_tbl(i).odm_inv_organization_id;
486:
487: IF (INV_Validate.Organization(l_org) = inv_validate.F) THEN
488: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
489: log_msg('failed call to INV_Validate.Organization');
490: END IF;
491: FND_MESSAGE.SET_NAME('INV','INV_INT_ORGCODE');
492: FND_MSG_PUB.Add;
493: RAISE FND_API.G_EXC_ERROR;

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

518: END IF;
519:
520: --Validate the item in ODM
521: l_item.inventory_item_id := p_line_rec_tbl(i).odm_item_id;
522: IF (inv_validate.Inventory_Item (l_item, l_org) = inv_validate.F) THEN
523: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
524: log_msg('failed call to inv_validate.Inventory_Item');
525: END IF;
526: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');

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

520: --Validate the item in ODM
521: l_item.inventory_item_id := p_line_rec_tbl(i).odm_item_id;
522: IF (inv_validate.Inventory_Item (l_item, l_org) = inv_validate.F) THEN
523: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
524: log_msg('failed call to inv_validate.Inventory_Item');
525: END IF;
526: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_ITEM');
527: FND_MSG_PUB.Add;
528: RAISE FND_API.G_EXC_ERROR;

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

549: FND_MSG_PUB.Add;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552:
553: IF (inv_validate.revision (p_line_rec_tbl(i).odm_item_revision, l_org, l_item) = inv_validate.F) THEN
554: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
555: log_msg('failed call to inv_validate.revision');
556: END IF;
557: FND_MESSAGE.SET_NAME('INV', 'INV_INT_REVCODE');

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

551: END IF;
552:
553: IF (inv_validate.revision (p_line_rec_tbl(i).odm_item_revision, l_org, l_item) = inv_validate.F) THEN
554: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
555: log_msg('failed call to inv_validate.revision');
556: END IF;
557: FND_MESSAGE.SET_NAME('INV', 'INV_INT_REVCODE');
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_ERROR;

Line 654: IF (INV_VALIDATE.From_Subinventory

650: --p_acct_txn is 1 when transaction_action_id is 1 (Misc Issue)
651: --0 when any other transaction_action_id (27 for Misc receipt)
652:
653: l_sub.secondary_inventory_name := p_line_rec_tbl(i).odm_subinventory;
654: IF (INV_VALIDATE.From_Subinventory
655: ( p_sub => l_sub
656: ,p_org => l_org
657: ,p_item => l_item
658: ,p_acct_txn => p_hdr_rec.transfer_type

Line 659: ) = inv_validate.F

655: ( p_sub => l_sub
656: ,p_org => l_org
657: ,p_item => l_item
658: ,p_acct_txn => p_hdr_rec.transfer_type
659: ) = inv_validate.F
660: ) THEN
661: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
662: log_msg('failed call to INV_Validate.from_subinventory');
663: END IF;

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

658: ,p_acct_txn => p_hdr_rec.transfer_type
659: ) = inv_validate.F
660: ) THEN
661: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
662: log_msg('failed call to INV_Validate.from_subinventory');
663: END IF;
664: FND_MESSAGE.SET_NAME('INV','INV_INVALID_SUBINV');
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;

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

665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:
669: --need to call overloaded INV_Validate.validatelocator depending on whether the
670: --item is restricted locator controlled
671: l_locator.inventory_location_id := p_line_rec_tbl(i).odm_locator_id;
672: --{
673: IF ( (l_org.stock_locator_control_code = 1)

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

812:
813: --Validate the discrete reason id
814: --Entering the discrete reason id is optional.
815: IF (p_line_rec_tbl(i).odm_reason_id IS NOT NULL) THEN
816: IF (INV_Validate.Reason(p_line_rec_tbl(i).odm_reason_id) = inv_validate.F) THEN
817: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
818: log_msg('failed call to INV_Validate.Reason');
819: END IF;
820: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');

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

814: --Entering the discrete reason id is optional.
815: IF (p_line_rec_tbl(i).odm_reason_id IS NOT NULL) THEN
816: IF (INV_Validate.Reason(p_line_rec_tbl(i).odm_reason_id) = inv_validate.F) THEN
817: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
818: log_msg('failed call to INV_Validate.Reason');
819: END IF;
820: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;

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

863: CLOSE Cur_get_uom_code;
864:
865: /* Jalaj Srivastava Bug 3812701 */
866: /* Validate odm_quantity_uom_code in discrete */
867: IF (inv_validate.uom(p_line_rec_tbl(i).odm_quantity_uom_code,l_org,l_item) = inv_validate.F) THEN
868: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
869: log_msg('failed call to inv_validate.uom');
870: END IF;
871: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');

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

865: /* Jalaj Srivastava Bug 3812701 */
866: /* Validate odm_quantity_uom_code in discrete */
867: IF (inv_validate.uom(p_line_rec_tbl(i).odm_quantity_uom_code,l_org,l_item) = inv_validate.F) THEN
868: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
869: log_msg('failed call to inv_validate.uom');
870: END IF;
871: FND_MESSAGE.SET_NAME('INV','INV-NO ITEM UOM');
872: FND_MSG_PUB.Add;
873: RAISE FND_API.G_EXC_ERROR;

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

1225:
1226: l_odm_lot.lot_number := p_lot_rec_tbl(j).odm_lot_number;
1227:
1228: --{
1229: IF (INV_Validate.lot_number (p_lot => l_odm_lot,
1230: p_org => l_org,
1231: p_item => l_item
1232: ) = inv_validate.F) THEN
1233:

Line 1232: ) = inv_validate.F) THEN

1228: --{
1229: IF (INV_Validate.lot_number (p_lot => l_odm_lot,
1230: p_org => l_org,
1231: p_item => l_item
1232: ) = inv_validate.F) THEN
1233:
1234:
1235: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1236: log_msg('ODM lot does not previously exist when transfer type is 0');