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

Line 1: PACKAGE BODY inv_lot_api_pub AS

1: PACKAGE BODY inv_lot_api_pub AS
2: /* $Header: INVPLOTB.pls 120.51.12020000.6 2013/01/31 08:19:42 alxue ship $ */
3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2 ( 30 ) := 'INV_LOT_API_PUB';

Line 5: g_pkg_name CONSTANT VARCHAR2 ( 30 ) := 'INV_LOT_API_PUB';

1: PACKAGE BODY inv_lot_api_pub AS
2: /* $Header: INVPLOTB.pls 120.51.12020000.6 2013/01/31 08:19:42 alxue ship $ */
3:
4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2 ( 30 ) := 'INV_LOT_API_PUB';
6:
7:
8: /*****************************************************************************
9: Bug - 2181558 Additions Starts

Line 58: p_module => 'INV_LOT_API_PUB',

54: BEGIN
55: IF (g_debug = 1) THEN
56: inv_mobile_helper_functions.tracelog (
57: p_err_msg => p_err_msg,
58: p_module => 'INV_LOT_API_PUB',
59: p_level => p_level
60: );
61: --DBMS_OUTPUT.PUT_LINE(p_err_msg);
62: END IF;

Line 455: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');

451: AND transaction_temp_id = p_trx_temp_id;
452: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
453: BEGIN
454: IF (l_debug = 1) THEN
455: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');
456: END IF;
457: -- Standard Start of API savepoint
458: SAVEPOINT apiinsertlot_apipub;
459:

Line 495: inv_pick_wave_pick_confirm_pub.tracelog ( 'Exception in LOT_CONTROL_CODE' , 'INV_LOT_API_PUB');

491: EXCEPTION
492: WHEN NO_DATA_FOUND
493: THEN
494: IF (l_debug = 1) THEN
495: inv_pick_wave_pick_confirm_pub.tracelog ( 'Exception in LOT_CONTROL_CODE' , 'INV_LOT_API_PUB');
496: END IF;
497: fnd_message.set_name ('INV' , 'INV_INVALID_ITEM' );
498: fnd_msg_pub.ADD;
499: x_return_status := fnd_api.g_ret_sts_error;

Line 533: inv_pick_wave_pick_confirm_pub.tracelog ( 'Exception in MTL_LOT_NUMBER' , 'INV_LOT_API_PUB');

529: fnd_msg_pub.ADD;
530: x_return_status := fnd_api.g_ret_sts_error;
531: RAISE fnd_api.g_exc_unexpected_error;
532: IF (l_debug = 1) THEN
533: inv_pick_wave_pick_confirm_pub.tracelog ( 'Exception in MTL_LOT_NUMBER' , 'INV_LOT_API_PUB');
534: END IF;
535: END IF;
536: END IF;
537:

Line 573: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling populateattributesColumn' , 'INV_LOT_API_PUB');

569: END IF;
570: END IF;
571:
572: IF (l_debug = 1) THEN
573: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling populateattributesColumn' , 'INV_LOT_API_PUB');
574: END IF;
575:
576: SELECT mtl_gen_object_id_s.NEXTVAL
577: INTO x_object_id

Line 582: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling populateattributesColumn' , 'INV_LOT_API_PUB');

578: FROM DUAL;
579:
580: populateattributescolumn ( );
581: IF (l_debug = 1) THEN
582: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling populateattributesColumn' , 'INV_LOT_API_PUB');
583: END IF;
584:
585: IF ( p_transaction_temp_id IS NOT NULL ) THEN
586: IF (l_debug = 1) THEN

Line 587: inv_pick_wave_pick_confirm_pub.tracelog ( 'p_transaction_temp_id' || p_transaction_temp_id, 'INV_LOT_API_PUB');

583: END IF;
584:
585: IF ( p_transaction_temp_id IS NOT NULL ) THEN
586: IF (l_debug = 1) THEN
587: inv_pick_wave_pick_confirm_pub.tracelog ( 'p_transaction_temp_id' || p_transaction_temp_id, 'INV_LOT_API_PUB');
588: END IF;
589: OPEN lot_temp_csr ( p_lot_number, p_transaction_temp_id );
590:
591: LOOP

Line 680: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before Insert action_id=3' , 'INV_LOT_API_PUB');

676:
677: IF (( p_transaction_action_id IS NOT NULL AND p_transaction_action_id = 3 AND g_firstscan = FALSE)
678: OR ( p_transaction_action_id is not null AND p_transaction_action_id = 12 )) THEN
679: IF (l_debug = 1) THEN
680: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before Insert action_id=3' , 'INV_LOT_API_PUB');
681: END IF;
682: BEGIN
683: select count(*)
684: into l_lotcount

Line 1088: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');

1084: EXCEPTION
1085: when no_data_found THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF (l_debug = 1) THEN
1088: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1089: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1090: END IF;
1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: when others then

Line 1089: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');

1085: when no_data_found THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: IF (l_debug = 1) THEN
1088: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1089: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1090: END IF;
1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: when others then
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1095: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');

1091: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1092: when others then
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF (l_debug = 1) THEN
1095: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1096: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1097: END IF;
1098: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099:

Line 1096: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');

1092: when others then
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF (l_debug = 1) THEN
1095: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
1096: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
1097: END IF;
1098: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1099:
1100: end;

Line 1112: inv_pick_wave_pick_confirm_pub.tracelog ( 'After Insert action_id=3' , 'INV_LOT_API_PUB');

1108: AND organization_id = p_organization_id
1109: AND inventory_item_id = p_inventory_item_id;
1110:
1111: IF (l_debug = 1) THEN
1112: inv_pick_wave_pick_confirm_pub.tracelog ( 'After Insert action_id=3' , 'INV_LOT_API_PUB');
1113: END IF;
1114: ELSE -- if transaction_action_id is not 3
1115: /* ---------------------------------------------------------
1116: * call inv_lot_sel_attr.get_default to get the default value

Line 1122: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_default' , 'INV_LOT_API_PUB');

1118: * ---------------------------------------------------------*/
1119: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE ) THEN
1120:
1121: IF (l_debug = 1) THEN
1122: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_default' , 'INV_LOT_API_PUB');
1123: END IF;
1124: inv_lot_sel_attr.get_default (
1125: x_attributes_default => l_attributes_default,
1126: x_attributes_default_count => l_attributes_default_count,

Line 1138: inv_pick_wave_pick_confirm_pub.tracelog ( 'After get_default' , 'INV_LOT_API_PUB');

1134: p_lot_serial_number => p_lot_number,
1135: p_attributes => l_attributes_in
1136: );
1137: IF (l_debug = 1) THEN
1138: inv_pick_wave_pick_confirm_pub.tracelog ( 'After get_default' , 'INV_LOT_API_PUB');
1139: END IF;
1140:
1141: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1142: IF (l_debug = 1) THEN

Line 1143: inv_pick_wave_pick_confirm_pub.tracelog ( 'exception of get_default' , 'INV_LOT_API_PUB');

1139: END IF;
1140:
1141: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1142: IF (l_debug = 1) THEN
1143: inv_pick_wave_pick_confirm_pub.tracelog ( 'exception of get_default' , 'INV_LOT_API_PUB');
1144: END IF;
1145: x_return_status := l_return_status;
1146: RAISE fnd_api.g_exc_unexpected_error;
1147: END IF;

Line 1175: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_lot_att_from_source' , 'INV_LOT_API_PUB');

1171: l_source_non_wms_lot_att_rec.attribute15 := NULL;
1172:
1173: IF p_transfer_organization_id IS NOT NULL THEN
1174: IF (l_debug = 1) THEN
1175: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_lot_att_from_source' , 'INV_LOT_API_PUB');
1176: END IF;
1177:
1178: get_lot_att_from_source
1179: (

Line 1200: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling get_lot_att_from_source' , 'INV_LOT_API_PUB');

1196: l_attributes_default := l_att_after_source_copy;
1197: l_attributes_default_count := l_num_wms_lot_att_copied;
1198:
1199: IF (l_debug = 1) THEN
1200: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling get_lot_att_from_source' , 'INV_LOT_API_PUB');
1201: END IF;
1202: END IF;
1203:
1204: /* Bug 2181558 - Code Ends */

Line 1237: inv_pick_wave_pick_confirm_pub.tracelog ( 'before calling get_lot_Serial_status_control' , 'INV_LOT_API_PUB');

1233: * g_lot_attributes_tbl(5).COLUMN_VALUE if OUT parameter
1234: * 'lot_status_enabled' is 'Y'.
1235: ***********************************************************************/
1236: IF (l_debug = 1) THEN
1237: inv_pick_wave_pick_confirm_pub.tracelog ( 'before calling get_lot_Serial_status_control' , 'INV_LOT_API_PUB');
1238: END IF;
1239: inv_material_status_grp.get_lot_serial_status_control (
1240: p_organization_id => p_organization_id,
1241: p_inventory_item_id => p_inventory_item_id,

Line 1251: inv_pick_wave_pick_confirm_pub.tracelog ( 'After get_lot_Serial_status_control' , 'INV_LOT_API_PUB');

1247: x_serial_status_enabled => l_serial_status_enabled,
1248: x_default_serial_status_id => l_default_serial_status_id
1249: );
1250: IF (l_debug = 1) THEN
1251: inv_pick_wave_pick_confirm_pub.tracelog ( 'After get_lot_Serial_status_control' , 'INV_LOT_API_PUB');
1252: END IF;
1253:
1254: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1255: x_return_status := l_return_status;

Line 1275: inv_pick_wave_pick_confirm_pub.tracelog ( 'before inserting into mtl_lot_numbers' , 'INV_LOT_API_PUB');

1271: p_inventory_item_id,
1272: 'Lot Attributes'
1273: );
1274: IF (l_debug = 1) THEN
1275: inv_pick_wave_pick_confirm_pub.tracelog ( 'before inserting into mtl_lot_numbers' , 'INV_LOT_API_PUB');
1276: END IF;
1277:
1278: --print_debug('after get_context_code 30', 4);
1279:

Line 1489: inv_pick_wave_pick_confirm_pub.tracelog ( 'After inserting the lot' , 'INV_LOT_API_PUB');

1485: p_origination_type -- bug 15896641 - inserting origination type
1486: );
1487:
1488: IF (l_debug = 1) THEN
1489: inv_pick_wave_pick_confirm_pub.tracelog ( 'After inserting the lot' , 'INV_LOT_API_PUB');
1490: END IF;
1491:
1492: END IF;
1493:

Line 1504: inv_pick_wave_pick_confirm_pub.tracelog ( 'after calling insert_status_history' , 'INV_LOT_API_PUB');

1500: l_status_rec.status_id := l_default_lot_status_id;
1501: l_status_rec.initial_status_flag := 'Y';
1502: inv_material_status_pkg.insert_status_history ( l_status_rec);
1503: IF (l_debug = 1) THEN
1504: inv_pick_wave_pick_confirm_pub.tracelog ( 'after calling insert_status_history' , 'INV_LOT_API_PUB');
1505: END IF;
1506: END IF;
1507:
1508: x_return_status := fnd_api.g_ret_sts_success;

Line 1511: inv_pick_wave_pick_confirm_pub.tracelog ( 'INV_LOT_EXISTS' , 'INV_LOT_API_PUB');

1507:
1508: x_return_status := fnd_api.g_ret_sts_success;
1509: ELSE
1510: IF (l_debug = 1) THEN
1511: inv_pick_wave_pick_confirm_pub.tracelog ( 'INV_LOT_EXISTS' , 'INV_LOT_API_PUB');
1512: END IF;
1513: fnd_message.set_name ('INV' , 'INV_LOT_EXISTS' );
1514: fnd_msg_pub.ADD;
1515: --l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1525: inv_pick_wave_pick_confirm_pub.tracelog ('Update the expiration date', 'INV_LOT_API_PUB');

1521: l_userid := fnd_global.user_id;
1522:
1523: --Lot exists, but now the user has entered the lot expiration date
1524: IF (l_debug = 1) THEN
1525: inv_pick_wave_pick_confirm_pub.tracelog ('Update the expiration date', 'INV_LOT_API_PUB');
1526: END IF;
1527:
1528: UPDATE mtl_lot_numbers
1529: SET expiration_date = p_expiration_date,

Line 1543: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inserted the Lot ' || p_lot_number, 'INV_LOT_API_PUB');

1539:
1540: -- End of API body.
1541: -- Standard check of p_commit.
1542: IF (l_debug = 1) THEN
1543: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inserted the Lot ' || p_lot_number, 'INV_LOT_API_PUB');
1544: END IF;
1545:
1546: IF fnd_api.to_boolean ( p_commit ) THEN
1547: COMMIT WORK;

Line 1559: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside the exception ' || p_lot_number, 'INV_LOT_API_PUB');

1555:
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: IF (l_debug = 1) THEN
1559: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside the exception ' || p_lot_number, 'INV_LOT_API_PUB');
1560: END IF;
1561: --print_debug('insertlot other exception', 4);
1562:
1563: ROLLBACK TO apiinsertlot_apipub;

Line 1566: fnd_msg_pub.add_exc_msg ('INV_LOT_API_PUB' , 'insertLot' );

1562:
1563: ROLLBACK TO apiinsertlot_apipub;
1564:
1565: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1566: fnd_msg_pub.add_exc_msg ('INV_LOT_API_PUB' , 'insertLot' );
1567: END IF;
1568:
1569: x_return_status := fnd_api.g_ret_sts_unexp_error;
1570: END insertlot;

Line 2407: fnd_msg_pub.add_exc_msg ('INV_LOT_API_PUB' , 'insertLot' );

2403: IF fnd_msg_pub.check_msg_level (
2404: fnd_msg_pub.g_msg_lvl_unexp_error
2405: )
2406: THEN
2407: fnd_msg_pub.add_exc_msg ('INV_LOT_API_PUB' , 'insertLot' );
2408: END IF;
2409:
2410: x_return_status := fnd_api.g_ret_sts_unexp_error;
2411: END inserttrxlot;

Line 2425: := 'INV_LOT_API_PUB.validate_unique_lot';

2421: l_lot_number NUMBER := 0;
2422: l_lot_uniqueness NUMBER := p_lot_uniqueness;
2423: l_count NUMBER := 0;
2424: l_api_name CONSTANT VARCHAR2 ( 50 )
2425: := 'INV_LOT_API_PUB.validate_unique_lot';
2426:
2427: CURSOR mln_cur_2
2428: IS
2429: SELECT lot_number

Line 2756: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';

2752: auto_lot_number VARCHAR2 ( 80 ) := NULL;
2753: l_unique_lot BOOLEAN := FALSE;
2754: l_lotcount NUMBER;
2755: l_api_version CONSTANT NUMBER := 1.0;
2756: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
2757: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2758: -- The following 2 variables are added as a part of bug fix for: Bug #3330855
2759: v_org_code VARCHAR2 ( 3 );
2760: v_item_name VARCHAR2 ( 80 );

Line 3123: x_parent_call := inv_lot_api_pub.auto_gen_lot (

3119: /*=========================================
3120: Recall this api with parent lot = NULL;
3121: *=========================================*/
3122: x_parent_lot_number := NULL;
3123: x_parent_call := inv_lot_api_pub.auto_gen_lot (
3124: p_org_id,
3125: p_inventory_item_id,
3126: p_lot_generation,
3127: p_lot_uniqueness,

Line 3211: x_parent_call := inv_lot_api_pub.auto_gen_lot (

3207: /*=========================================
3208: Recall this api with parent lot = NULL;
3209: *=========================================*/
3210: x_parent_lot_number := NULL;
3211: x_parent_call := inv_lot_api_pub.auto_gen_lot (
3212: p_org_id,
3213: p_inventory_item_id,
3214: p_lot_generation,
3215: p_lot_uniqueness,

Line 3523: IF inv_lot_api_pub.validate_unique_lot

3519:
3520:
3521: --RETURN (auto_lot_number);
3522: /*
3523: IF inv_lot_api_pub.validate_unique_lot
3524: ( p_org_id,
3525: p_inventory_item_id,
3526: lot_uniqueness,
3527: auto_lot_number)

Line 3557: inv_lot_api_pub.validate_unique_lot(

3553: ELSE
3554: l_unique_lot := FALSE;
3555: END IF; */
3556: l_unique_lot :=
3557: inv_lot_api_pub.validate_unique_lot(
3558: p_org_id
3559: , p_inventory_item_id
3560: , p_lot_uniqueness
3561: , auto_lot_number

Line 3634: := 'INV_LOT_API_PUB.validate_unique_lot';

3630: l_lot_number NUMBER := 0;
3631: l_lot_uniqueness NUMBER := p_lot_uniqueness;
3632: l_count NUMBER := 0;
3633: l_api_name CONSTANT VARCHAR2 ( 50 )
3634: := 'INV_LOT_API_PUB.validate_unique_lot';
3635:
3636: CURSOR mln_cur_1
3637: IS
3638: SELECT lot_number

Line 4012: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

4008: , p_attribute_category IN VARCHAR2
4009: , p_lot_attribute_category IN VARCHAR2
4010: , p_inventory_item_id IN NUMBER
4011: , p_organization_id IN NUMBER
4012: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4013: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4014: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4015: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4016: , p_disable_flag IN NUMBER

Line 4013: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

4009: , p_lot_attribute_category IN VARCHAR2
4010: , p_inventory_item_id IN NUMBER
4011: , p_organization_id IN NUMBER
4012: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4013: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4014: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4015: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4016: , p_disable_flag IN NUMBER
4017: , p_grade_code IN VARCHAR2

Line 4014: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

4010: , p_inventory_item_id IN NUMBER
4011: , p_organization_id IN NUMBER
4012: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4013: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4014: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4015: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4016: , p_disable_flag IN NUMBER
4017: , p_grade_code IN VARCHAR2
4018: , p_origination_date IN DATE

Line 4015: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

4011: , p_organization_id IN NUMBER
4012: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4013: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4014: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4015: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4016: , p_disable_flag IN NUMBER
4017: , p_grade_code IN VARCHAR2
4018: , p_origination_date IN DATE
4019: , p_date_code IN VARCHAR2

Line 4388: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

4384: , p_organization_id IN NUMBER
4385: , p_lot_number IN VARCHAR2
4386: , p_attribute_category IN VARCHAR2
4387: , p_lot_attribute_category IN VARCHAR2
4388: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4389: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4390: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4391: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4392: , p_wms_is_installed IN VARCHAR2

Line 4389: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

4385: , p_lot_number IN VARCHAR2
4386: , p_attribute_category IN VARCHAR2
4387: , p_lot_attribute_category IN VARCHAR2
4388: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4389: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4390: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4391: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4392: , p_wms_is_installed IN VARCHAR2
4393: , p_source IN NUMBER

Line 4390: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

4386: , p_attribute_category IN VARCHAR2
4387: , p_lot_attribute_category IN VARCHAR2
4388: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4389: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4390: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4391: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4392: , p_wms_is_installed IN VARCHAR2
4393: , p_source IN NUMBER
4394: , p_disable_flag IN NUMBER

Line 4391: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

4387: , p_lot_attribute_category IN VARCHAR2
4388: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4389: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4390: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4391: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4392: , p_wms_is_installed IN VARCHAR2
4393: , p_source IN NUMBER
4394: , p_disable_flag IN NUMBER
4395: , p_grade_code IN VARCHAR2

Line 4487: inv_lot_api_pub.validate_unique_lot(

4483: END;
4484:
4485: /* Call the function to check the Lot Uniqueness */
4486: l_chk_lot_uniqueness :=
4487: inv_lot_api_pub.validate_unique_lot(
4488: p_org_id => p_organization_id
4489: , p_inventory_item_id => p_inventory_item_id
4490: , p_lot_uniqueness => l_lot_number_uniqueness
4491: , p_auto_lot_number => p_lot_number

Line 4753: l_wms_named_attributes INV_LOT_API_PUB.wms_named_attributes;

4749: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4750: AND organization_id = p_lot_rec.organization_id
4751: AND lot_number = p_lot_rec.lot_number;
4752:
4753: l_wms_named_attributes INV_LOT_API_PUB.wms_named_attributes;
4754: l_wms_named_attr wms_named_attr%ROWTYPE;
4755: l_attr_category_cur attr_category_cur%ROWTYPE;
4756: l_c_attributes_cur c_attributes_cur%ROWTYPE;
4757: l_n_attributes_cur n_attributes_cur%ROWTYPE;

Line 4760: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;

4756: l_c_attributes_cur c_attributes_cur%ROWTYPE;
4757: l_n_attributes_cur n_attributes_cur%ROWTYPE;
4758: l_d_attributes_cur d_attributes_cur%ROWTYPE;
4759: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4760: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4761: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4762: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4763: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4764: /* Index variables for looping through the input tables*/

Line 4761: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

4757: l_n_attributes_cur n_attributes_cur%ROWTYPE;
4758: l_d_attributes_cur d_attributes_cur%ROWTYPE;
4759: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4760: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4761: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4762: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4763: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4764: /* Index variables for looping through the input tables*/
4765: l_attr_index NUMBER;

Line 4762: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

4758: l_d_attributes_cur d_attributes_cur%ROWTYPE;
4759: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4760: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4761: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4762: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4763: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4764: /* Index variables for looping through the input tables*/
4765: l_attr_index NUMBER;
4766: l_c_attr_index NUMBER;

Line 4763: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

4759: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4760: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4761: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4762: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4763: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4764: /* Index variables for looping through the input tables*/
4765: l_attr_index NUMBER;
4766: l_c_attr_index NUMBER;
4767: l_n_attr_index NUMBER;

Line 4784: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;

4780: inv_global_index NUMBER;
4781: inv_context_index NUMBER;
4782: wms_global_index NUMBER;
4783: wms_context_index NUMBER;
4784: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4785: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4786: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4787: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4788: /* Shelf life code constants */

Line 4785: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;

4781: inv_context_index NUMBER;
4782: wms_global_index NUMBER;
4783: wms_context_index NUMBER;
4784: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4785: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4786: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4787: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4788: /* Shelf life code constants */
4789: no_shelf_life_control CONSTANT NUMBER := 1;

Line 4786: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;

4782: wms_global_index NUMBER;
4783: wms_context_index NUMBER;
4784: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4785: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4786: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4787: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4788: /* Shelf life code constants */
4789: no_shelf_life_control CONSTANT NUMBER := 1;
4790: item_shelf_life_days CONSTANT NUMBER := 2;

Line 4787: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;

4783: wms_context_index NUMBER;
4784: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4785: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4786: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4787: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4788: /* Shelf life code constants */
4789: no_shelf_life_control CONSTANT NUMBER := 1;
4790: item_shelf_life_days CONSTANT NUMBER := 2;
4791: user_defined_exp_date CONSTANT NUMBER := 4;

Line 5874: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300

5870: END IF;
5871: IF g_debug = 1 THEN
5872: print_debug('Updating MTL_LOT_NUMBERS table ....' , 9);
5873: END IF;
5874: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300
5875:
5876: --Fixed for bug#7529468
5877: --added two column in update statement
5878: --LAST_UPDATE_DATE and LAST_UPDATED_BY

Line 6976: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

6972: , p_expiration_date IN DATE
6973: , p_disable_flag IN NUMBER
6974: , p_attribute_category IN VARCHAR2
6975: , p_lot_attribute_category IN VARCHAR2
6976: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6977: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6978: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6979: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6980: , p_grade_code IN VARCHAR2

Line 6977: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

6973: , p_disable_flag IN NUMBER
6974: , p_attribute_category IN VARCHAR2
6975: , p_lot_attribute_category IN VARCHAR2
6976: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6977: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6978: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6979: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6980: , p_grade_code IN VARCHAR2
6981: , p_origination_date IN DATE

Line 6978: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

6974: , p_attribute_category IN VARCHAR2
6975: , p_lot_attribute_category IN VARCHAR2
6976: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6977: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6978: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6979: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6980: , p_grade_code IN VARCHAR2
6981: , p_origination_date IN DATE
6982: , p_date_code IN VARCHAR2

Line 6979: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

6975: , p_lot_attribute_category IN VARCHAR2
6976: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6977: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6978: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6979: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6980: , p_grade_code IN VARCHAR2
6981: , p_origination_date IN DATE
6982: , p_date_code IN VARCHAR2
6983: , p_status_id IN NUMBER

Line 7443: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

7439: , p_inventory_item_id IN NUMBER
7440: , p_organization_id IN NUMBER
7441: , p_disable_flag IN NUMBER
7442: , p_lot_attribute_category IN VARCHAR2
7443: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
7444: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
7445: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
7446: , p_grade_code IN VARCHAR2
7447: , p_origination_date IN DATE

Line 7444: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

7440: , p_organization_id IN NUMBER
7441: , p_disable_flag IN NUMBER
7442: , p_lot_attribute_category IN VARCHAR2
7443: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
7444: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
7445: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
7446: , p_grade_code IN VARCHAR2
7447: , p_origination_date IN DATE
7448: , p_date_code IN VARCHAR2

Line 7445: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

7441: , p_disable_flag IN NUMBER
7442: , p_lot_attribute_category IN VARCHAR2
7443: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
7444: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
7445: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
7446: , p_grade_code IN VARCHAR2
7447: , p_origination_date IN DATE
7448: , p_date_code IN VARCHAR2
7449: , p_change_date IN DATE

Line 7504: x_return_status := inv_lot_api_pub.g_ret_sts_success;

7500: l_msg_data VARCHAR2(2000);
7501: l_enabled_attributes NUMBER;
7502: l_context_enabled BOOLEAN := false;
7503: BEGIN
7504: x_return_status := inv_lot_api_pub.g_ret_sts_success;
7505: SAVEPOINT wms_lot_dff_validate;
7506:
7507: IF g_debug = 1 THEN
7508: print_debug('In the beginning of the program lot_dff_validate', 9);

Line 8120: x_return_status := inv_lot_api_pub.g_ret_sts_error;

8116: end if;
8117: EXCEPTION
8118: WHEN g_exc_error THEN
8119: print_debug('Validation error', 9);
8120: x_return_status := inv_lot_api_pub.g_ret_sts_error;
8121: ROLLBACK TO wms_lot_dff_validate;
8122:
8123: IF g_debug = 1 THEN
8124: print_debug('Program LOT_DFF_VALIDATE has completed with validation errors', 9);

Line 8129: x_return_status := inv_lot_api_pub.g_ret_sts_error;

8125: END IF;
8126:
8127: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8128: WHEN errors_received THEN
8129: x_return_status := inv_lot_api_pub.g_ret_sts_error;
8130:
8131: IF g_debug = 1 THEN
8132: print_debug('Program LOT_DFF_VALIDATE has completed with errors_received', 9);
8133: END IF;

Line 8152: x_return_status := inv_lot_api_pub.g_ret_sts_unexp_error;

8148: END LOOP;
8149:
8150: ROLLBACK TO wms_lot_dff_validate;
8151: WHEN OTHERS THEN
8152: x_return_status := inv_lot_api_pub.g_ret_sts_unexp_error;
8153: ROLLBACK TO wms_lot_dff_validate;
8154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
8155:
8156: IF g_debug = 1 THEN

Line 8640: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_LOT_API_PUB';

8636:
8637:
8638: l_api_name CONSTANT VARCHAR2(30) := 'validate_lot_indivisible';
8639: l_api_version CONSTANT NUMBER := 1.0;
8640: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_LOT_API_PUB';
8641:
8642: l_return BOOLEAN;
8643: l_lot_divisible VARCHAR2(1);
8644: l_lot_control_code pls_integer;

Line 9239: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

9235: , p_expiration_date IN DATE
9236: , p_disable_flag IN NUMBER
9237: , p_attribute_category IN VARCHAR2
9238: , p_lot_attribute_category IN VARCHAR2
9239: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
9240: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
9241: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
9242: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
9243: , p_grade_code IN VARCHAR2

Line 9240: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

9236: , p_disable_flag IN NUMBER
9237: , p_attribute_category IN VARCHAR2
9238: , p_lot_attribute_category IN VARCHAR2
9239: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
9240: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
9241: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
9242: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
9243: , p_grade_code IN VARCHAR2
9244: , p_origination_date IN DATE

Line 9241: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

9237: , p_attribute_category IN VARCHAR2
9238: , p_lot_attribute_category IN VARCHAR2
9239: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
9240: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
9241: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
9242: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
9243: , p_grade_code IN VARCHAR2
9244: , p_origination_date IN DATE
9245: , p_date_code IN VARCHAR2

Line 9242: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

9238: , p_lot_attribute_category IN VARCHAR2
9239: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
9240: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
9241: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
9242: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
9243: , p_grade_code IN VARCHAR2
9244: , p_origination_date IN DATE
9245: , p_date_code IN VARCHAR2
9246: , p_status_id IN NUMBER

Line 10174: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';

10170: IS
10171: l_unique_lot BOOLEAN := FALSE;
10172: l_lotcount NUMBER;
10173: l_api_version CONSTANT NUMBER := 1.0;
10174: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
10175: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10176: v_org_code VARCHAR2 ( 3 );
10177: v_item_name VARCHAR2 ( 40 );
10178: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;

Line 10182: x_parent_call := inv_lot_api_pub.auto_gen_lot (

10178: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
10179: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
10180:
10181: BEGIN
10182: x_parent_call := inv_lot_api_pub.auto_gen_lot (
10183: p_org_id,
10184: p_inventory_item_id,
10185: p_lot_generation,
10186: p_lot_uniqueness,

Line 10331: 'inv_lot_api_pub'

10327: IF NOT fnd_api.compatible_api_call(
10328: l_api_version,
10329: p_api_version,
10330: l_api_name,
10331: 'inv_lot_api_pub'
10332: ) THEN
10333: IF (g_debug = 1) THEN
10334: print_debug('FND_API not compatible INV_LOT_API_PUB.CHECK_LOT_INDIVISIBILITY: '||l_progress, 1);
10335: END IF;

Line 10334: print_debug('FND_API not compatible INV_LOT_API_PUB.CHECK_LOT_INDIVISIBILITY: '||l_progress, 1);

10330: l_api_name,
10331: 'inv_lot_api_pub'
10332: ) THEN
10333: IF (g_debug = 1) THEN
10334: print_debug('FND_API not compatible INV_LOT_API_PUB.CHECK_LOT_INDIVISIBILITY: '||l_progress, 1);
10335: END IF;
10336: RAISE fnd_api.g_exc_unexpected_error;
10337: END IF;
10338:

Line 10384: print_debug('Before calling INV_LOT_API_PUB.validate_lot_indivisible ',1);

10380: print_debug('l_locator_id '|| l_locator_id, 1);
10381: print_debug('l_item_id '|| l_item_id , 1);
10382: print_debug('l_parent_trx_id '|| l_parent_trx_id, 1);
10383: print_debug('l_trx_unit_of_measure '|| l_trx_unit_of_measure, 1);
10384: print_debug('Before calling INV_LOT_API_PUB.validate_lot_indivisible ',1);
10385: END IF;
10386:
10387: l_progress := '004';
10388:

Line 10390: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

10386:
10387: l_progress := '004';
10388:
10389: ---call the indiv function
10390: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
10391: p_api_version =>1.0
10392: ,p_init_msg_list =>FND_API.G_FALSE
10393: ,p_commit =>FND_API.G_FALSE
10394: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL

Line 10411: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return FALSE ' || l_return_status || 'and '|| l_progress, 9);

10407: ,x_msg_data =>l_msg_data
10408: ))THEN
10409:
10410: IF g_debug = 1 THEN
10411: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return FALSE ' || l_return_status || 'and '|| l_progress, 9);
10412: END IF;
10413:
10414: l_progress := '005';
10415:

Line 10506: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);

10502: l_progress := '011';
10503:
10504: IF l_return_status = fnd_api.g_ret_sts_error THEN
10505: IF g_debug = 1 THEN
10506: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);
10507: END IF;
10508:
10509: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10510: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

Line 10510: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

10506: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);
10507: END IF;
10508:
10509: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10510: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
10511: fnd_msg_pub.ADD;
10512: RAISE g_exc_error;
10513:
10514: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 10518: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);

10514: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
10515: l_progress := '012' ;
10516:
10517: IF g_debug = 1 THEN
10518: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
10519: END IF;
10520:
10521: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10522: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

Line 10522: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

10518: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
10519: END IF;
10520:
10521: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10522: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
10523: fnd_msg_pub.ADD;
10524: RAISE g_exc_unexpected_error;
10525: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
10526:

Line 10528: END IF;--------IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

10524: RAISE g_exc_unexpected_error;
10525: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
10526:
10527:
10528: END IF;--------IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
10529:
10530: l_progress := '013';
10531:
10532: IF g_debug = 1 THEN

Line 10533: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE: ' || l_return_status || 'and '|| l_progress, 9);

10529:
10530: l_progress := '013';
10531:
10532: IF g_debug = 1 THEN
10533: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE: ' || l_return_status || 'and '|| l_progress, 9);
10534: print_debug('Exitting inv_lot_api_pub.check_lot_indivisibility :'|| l_progress, 9);
10535: END IF;
10536:
10537: ELSE ----------IF p_transaction_type_id IN

Line 10534: print_debug('Exitting inv_lot_api_pub.check_lot_indivisibility :'|| l_progress, 9);

10530: l_progress := '013';
10531:
10532: IF g_debug = 1 THEN
10533: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE: ' || l_return_status || 'and '|| l_progress, 9);
10534: print_debug('Exitting inv_lot_api_pub.check_lot_indivisibility :'|| l_progress, 9);
10535: END IF;
10536:
10537: ELSE ----------IF p_transaction_type_id IN
10538:

Line 10908: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE

10904:
10905: -- Lot Indivisible Validation:
10906: --{
10907: IF (l_lot_divisible_flag = 'N') THEN
10908: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE
10909: ( p_api_version => p_api_version
10910: , p_init_msg_list => p_init_msg_list
10911: , p_transaction_type_id => p_transaction_type_id
10912: , p_organization_id => p_organization_id

Line 10929: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (ERROR)', g_pkg_name, 9);

10925:
10926: IF (NOT l_lot_indiv_trx_valid) THEN
10927: -- the transaction is not valid regarding lot indivisible:
10928: IF (l_debug = 1) THEN
10929: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (ERROR)', g_pkg_name, 9);
10930: END IF;
10931: RAISE FND_API.G_EXC_ERROR;
10932: END IF;
10933: IF (l_debug = 1) THEN

Line 10934: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (PASS) ', g_pkg_name, 9);

10930: END IF;
10931: RAISE FND_API.G_EXC_ERROR;
10932: END IF;
10933: IF (l_debug = 1) THEN
10934: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (PASS) ', g_pkg_name, 9);
10935: END IF;
10936:
10937: END IF;--} -- l_lot_divisible_flag = 'N'
10938:

Line 11145: inv_lot_api_pub.insertlot(

11141: END;
11142: IF (l_debug = 1) THEN
11143: inv_log_util.trace('lot_UOM_conv_OrgTxf: 2' ||l_expiration_date, g_pkg_name,9);
11144: END IF;
11145: inv_lot_api_pub.insertlot(
11146: p_api_version => 1.0
11147: , p_init_msg_list => fnd_api.g_false
11148: , p_commit => fnd_api.g_false
11149: , p_validation_level => fnd_api.g_valid_level_full

Line 11327: END inv_lot_api_pub;

11323:
11324:
11325: END create_lot_UOM_conv_orgtxf;
11326:
11327: END inv_lot_api_pub;
11328:
11329: