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_LOT_API_PKG dependencies on INV_LOT_API_PUB

Line 486: /* Validate naming convention for the child lot by calling Inv_lot_api_pub.VALIDATE_CHILD_LOT API */

482: END IF;
483:
484: END IF ;
485:
486: /* Validate naming convention for the child lot by calling Inv_lot_api_pub.VALIDATE_CHILD_LOT API */
487: IF (x_child_lot_rec.parent_lot_number IS NOT NULL) THEN
488: Inv_lot_api_pub.Validate_Child_Lot (
489: p_api_version => l_api_version
490: , p_init_msg_list => l_init_msg_list

Line 488: Inv_lot_api_pub.Validate_Child_Lot (

484: END IF ;
485:
486: /* Validate naming convention for the child lot by calling Inv_lot_api_pub.VALIDATE_CHILD_LOT API */
487: IF (x_child_lot_rec.parent_lot_number IS NOT NULL) THEN
488: Inv_lot_api_pub.Validate_Child_Lot (
489: p_api_version => l_api_version
490: , p_init_msg_list => l_init_msg_list
491: , p_commit => l_commit
492: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 506: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);

502: , x_msg_data => l_msg_count */
503: ) ;
504:
505: IF g_debug = 1 THEN
506: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);
507: END IF;
508: IF l_return_status = fnd_api.g_ret_sts_error THEN
509: IF g_debug = 1 THEN
510: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a user defined exception', 9);

Line 510: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a user defined exception', 9);

506: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);
507: END IF;
508: IF l_return_status = fnd_api.g_ret_sts_error THEN
509: IF g_debug = 1 THEN
510: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a user defined exception', 9);
511: END IF;
512: RAISE fnd_api.g_exc_error;
513: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
514: IF g_debug = 1 THEN

Line 515: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);

511: END IF;
512: RAISE fnd_api.g_exc_error;
513: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
514: IF g_debug = 1 THEN
515: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
516: END IF;
517: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
518: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
519: FND_MSG_PUB.ADD;

Line 518: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');

514: IF g_debug = 1 THEN
515: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
516: END IF;
517: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
518: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
519: FND_MSG_PUB.ADD;
520: RAISE fnd_api.g_exc_unexpected_error;
521: END IF;
522: END IF ; --parent lot check

Line 983: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;

979: l_msg_count NUMBER;
980: l_msg_data VARCHAR2(3000);
981: l_status NUMBER;
982: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
983: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
984: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
985: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
986: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
987:

Line 984: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

980: l_msg_data VARCHAR2(3000);
981: l_status NUMBER;
982: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
983: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
984: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
985: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
986: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
987:
988: /* Index variables for looping through the input tables*/

Line 985: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

981: l_status NUMBER;
982: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
983: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
984: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
985: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
986: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
987:
988: /* Index variables for looping through the input tables*/
989: l_attr_index NUMBER;

Line 986: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

982: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
983: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
984: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
985: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
986: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
987:
988: /* Index variables for looping through the input tables*/
989: l_attr_index NUMBER;
990: l_c_attr_index NUMBER;

Line 994: p_attributes_tbl inv_lot_api_pub.char_tbl ;

990: l_c_attr_index NUMBER;
991: l_n_attr_index NUMBER;
992: l_d_attr_index NUMBER;
993:
994: p_attributes_tbl inv_lot_api_pub.char_tbl ;
995: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:

Line 995: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;

991: l_n_attr_index NUMBER;
992: l_d_attr_index NUMBER;
993:
994: p_attributes_tbl inv_lot_api_pub.char_tbl ;
995: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;

Line 996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;

992: l_d_attr_index NUMBER;
993:
994: p_attributes_tbl inv_lot_api_pub.char_tbl ;
995: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;

Line 997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;

993:
994: p_attributes_tbl inv_lot_api_pub.char_tbl ;
995: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;

Line 1380: INV_LOT_API_PUB.VALIDATE_LOT_ATTR_IN_PARAM(

1376: END IF;
1377:
1378:
1379: /* If the call is from a valid source as osfm form, no need to validate the data*/
1380: INV_LOT_API_PUB.VALIDATE_LOT_ATTR_IN_PARAM(
1381: x_return_status => l_return_status
1382: , x_msg_count => l_msg_count
1383: , x_msg_data => l_msg_data
1384: , p_inventory_item_id => p_inventory_item_id

Line 1796: Inv_lot_api_pub.validate_child_lot (

1792: /* New child Lot*/
1793: CLOSE c_get_lot_record;
1794: /* Check Child Lot Naming convention */
1795: IF (p_parent_lot_number IS NOT NULL) THEN
1796: Inv_lot_api_pub.validate_child_lot (
1797: x_return_status => l_return_status
1798: , x_msg_count => l_msg_count
1799: , x_msg_data => l_msg_data
1800: , p_api_version => l_api_version

Line 1810: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);

1806: , p_child_lot_number => p_lot_number
1807: ) ;
1808:
1809: IF g_debug = 1 THEN
1810: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);
1811: END IF;
1812:
1813: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1814: IF g_debug = 1 THEN

Line 1815: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);

1811: END IF;
1812:
1813: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1814: IF g_debug = 1 THEN
1815: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
1816: END IF;
1817: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1818: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
1819: fnd_msg_pub.ADD;

Line 1818: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');

1814: IF g_debug = 1 THEN
1815: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
1816: END IF;
1817: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1818: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
1819: fnd_msg_pub.ADD;
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;
1822: