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 446: /* Validate naming convention for the child lot by calling Inv_lot_api_pub.VALIDATE_CHILD_LOT API */

442:
443:
444: END IF ;
445:
446: /* Validate naming convention for the child lot by calling Inv_lot_api_pub.VALIDATE_CHILD_LOT API */
447: IF (x_child_lot_rec.parent_lot_number IS NOT NULL) THEN
448: Inv_lot_api_pub.Validate_Child_Lot (
449: p_api_version => l_api_version
450: , p_init_msg_list => l_init_msg_list

Line 448: Inv_lot_api_pub.Validate_Child_Lot (

444: END IF ;
445:
446: /* Validate naming convention for the child lot by calling Inv_lot_api_pub.VALIDATE_CHILD_LOT API */
447: IF (x_child_lot_rec.parent_lot_number IS NOT NULL) THEN
448: Inv_lot_api_pub.Validate_Child_Lot (
449: p_api_version => l_api_version
450: , p_init_msg_list => l_init_msg_list
451: , p_commit => l_commit
452: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

462: , x_msg_data => l_msg_count */
463: ) ;
464:
465: IF g_debug = 1 THEN
466: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);
467: END IF;
468: IF l_return_status = fnd_api.g_ret_sts_error THEN
469: IF g_debug = 1 THEN
470: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a user defined exception', 9);

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

466: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);
467: END IF;
468: IF l_return_status = fnd_api.g_ret_sts_error THEN
469: IF g_debug = 1 THEN
470: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a user defined exception', 9);
471: END IF;
472: RAISE fnd_api.g_exc_error;
473: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: IF g_debug = 1 THEN

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

471: END IF;
472: RAISE fnd_api.g_exc_error;
473: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: IF g_debug = 1 THEN
475: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
476: END IF;
477: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
478: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
479: FND_MSG_PUB.ADD;

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

474: IF g_debug = 1 THEN
475: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
476: END IF;
477: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
478: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
479: FND_MSG_PUB.ADD;
480: RAISE fnd_api.g_exc_unexpected_error;
481: END IF;
482: END IF ; --parent lot check

Line 927: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;

923: l_msg_count NUMBER;
924: l_msg_data VARCHAR2(3000);
925: l_status NUMBER;
926: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
927: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
928: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
929: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
930: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
931:

Line 928: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

924: l_msg_data VARCHAR2(3000);
925: l_status NUMBER;
926: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
927: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
928: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
929: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
930: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
931:
932: /* Index variables for looping through the input tables*/

Line 929: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

925: l_status NUMBER;
926: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
927: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
928: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
929: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
930: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
931:
932: /* Index variables for looping through the input tables*/
933: l_attr_index NUMBER;

Line 930: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

926: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
927: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
928: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
929: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
930: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
931:
932: /* Index variables for looping through the input tables*/
933: l_attr_index NUMBER;
934: l_c_attr_index NUMBER;

Line 938: p_attributes_tbl inv_lot_api_pub.char_tbl ;

934: l_c_attr_index NUMBER;
935: l_n_attr_index NUMBER;
936: l_d_attr_index NUMBER;
937:
938: p_attributes_tbl inv_lot_api_pub.char_tbl ;
939: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:

Line 939: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;

935: l_n_attr_index NUMBER;
936: l_d_attr_index NUMBER;
937:
938: p_attributes_tbl inv_lot_api_pub.char_tbl ;
939: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;

Line 940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;

936: l_d_attr_index NUMBER;
937:
938: p_attributes_tbl inv_lot_api_pub.char_tbl ;
939: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;

Line 941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;

937:
938: p_attributes_tbl inv_lot_api_pub.char_tbl ;
939: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;

Line 1324: INV_LOT_API_PUB.VALIDATE_LOT_ATTR_IN_PARAM(

1320: END IF;
1321:
1322:
1323: /* If the call is from a valid source as osfm form, no need to validate the data*/
1324: INV_LOT_API_PUB.VALIDATE_LOT_ATTR_IN_PARAM(
1325: x_return_status => l_return_status
1326: , x_msg_count => l_msg_count
1327: , x_msg_data => l_msg_data
1328: , p_inventory_item_id => p_inventory_item_id

Line 1740: Inv_lot_api_pub.validate_child_lot (

1736: /* New child Lot*/
1737: CLOSE c_get_lot_record;
1738: /* Check Child Lot Naming convention */
1739: IF (p_parent_lot_number IS NOT NULL) THEN
1740: Inv_lot_api_pub.validate_child_lot (
1741: x_return_status => l_return_status
1742: , x_msg_count => l_msg_count
1743: , x_msg_data => l_msg_data
1744: , p_api_version => l_api_version

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

1750: , p_child_lot_number => p_lot_number
1751: ) ;
1752:
1753: IF g_debug = 1 THEN
1754: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT return ' || l_return_status, 9);
1755: END IF;
1756:
1757: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1758: IF g_debug = 1 THEN

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

1755: END IF;
1756:
1757: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1758: IF g_debug = 1 THEN
1759: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
1760: END IF;
1761: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1762: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
1763: fnd_msg_pub.ADD;

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

1758: IF g_debug = 1 THEN
1759: print_debug('Program Inv_lot_api_pub.VALIDATE_CHILD_LOT has failed with a Unexpected exception', 9);
1760: END IF;
1761: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1762: FND_MESSAGE.SET_TOKEN('PROG_NAME','Inv_lot_api_pub.VALIDATE_CHILD_LOT');
1763: fnd_msg_pub.ADD;
1764: RAISE fnd_api.g_exc_unexpected_error;
1765: END IF;
1766: