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.17.12010000.5 2008/11/18 08:44:41 mporecha 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.17.12010000.5 2008/11/18 08:44:41 mporecha 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 344: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');

340: AND transaction_temp_id = p_trx_temp_id;
341: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
342: BEGIN
343: IF (l_debug = 1) THEN
344: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside InsertLot API' , 'INV_LOT_API_PUB');
345: END IF;
346: -- Standard Start of API savepoint
347: SAVEPOINT apiinsertlot_apipub;
348:

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

380: EXCEPTION
381: WHEN NO_DATA_FOUND
382: THEN
383: IF (l_debug = 1) THEN
384: inv_pick_wave_pick_confirm_pub.tracelog ( 'Exception in LOT_CONTROL_CODE' , 'INV_LOT_API_PUB');
385: END IF;
386: fnd_message.set_name ('INV' , 'INV_INVALID_ITEM' );
387: fnd_msg_pub.ADD;
388: x_return_status := fnd_api.g_ret_sts_error;

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

418: fnd_msg_pub.ADD;
419: x_return_status := fnd_api.g_ret_sts_error;
420: RAISE fnd_api.g_exc_unexpected_error;
421: IF (l_debug = 1) THEN
422: inv_pick_wave_pick_confirm_pub.tracelog ( 'Exception in MTL_LOT_NUMBER' , 'INV_LOT_API_PUB');
423: END IF;
424: END IF;
425: END IF;
426:

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

458: END IF;
459: END IF;
460:
461: IF (l_debug = 1) THEN
462: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling populateattributesColumn' , 'INV_LOT_API_PUB');
463: END IF;
464:
465: SELECT mtl_gen_object_id_s.NEXTVAL
466: INTO x_object_id

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

467: FROM DUAL;
468:
469: populateattributescolumn ( );
470: IF (l_debug = 1) THEN
471: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling populateattributesColumn' , 'INV_LOT_API_PUB');
472: END IF;
473:
474: IF ( p_transaction_temp_id IS NOT NULL ) THEN
475: IF (l_debug = 1) THEN

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

472: END IF;
473:
474: IF ( p_transaction_temp_id IS NOT NULL ) THEN
475: IF (l_debug = 1) THEN
476: inv_pick_wave_pick_confirm_pub.tracelog ( 'p_transaction_temp_id' || p_transaction_temp_id, 'INV_LOT_API_PUB');
477: END IF;
478: OPEN lot_temp_csr ( p_lot_number, p_transaction_temp_id );
479:
480: LOOP

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

565:
566: IF (( p_transaction_action_id IS NOT NULL AND p_transaction_action_id = 3 AND g_firstscan = FALSE)
567: OR ( p_transaction_action_id is not null AND p_transaction_action_id = 12 )) THEN
568: IF (l_debug = 1) THEN
569: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before Insert action_id=3' , 'INV_LOT_API_PUB');
570: END IF;
571: BEGIN
572: select count(*)
573: into l_lotcount

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

969: EXCEPTION
970: when no_data_found THEN
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: IF (l_debug = 1) THEN
973: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
974: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
975: END IF;
976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
977: when others then

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

970: when no_data_found THEN
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: IF (l_debug = 1) THEN
973: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
974: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
975: END IF;
976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
977: when others then
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

976: raise FND_API.G_EXC_UNEXPECTED_ERROR;
977: when others then
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: IF (l_debug = 1) THEN
980: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
981: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
982: END IF;
983: raise FND_API.G_EXC_UNEXPECTED_ERROR;
984:

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

977: when others then
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: IF (l_debug = 1) THEN
980: inv_log_util.trace('SQL : ' || substr(sqlerrm, 1, 200), 'INV_LOT_API_PUB','9');
981: inv_log_util.trace('Error in insertLot : ', 'INV_LOT_API_PUB','9');
982: END IF;
983: raise FND_API.G_EXC_UNEXPECTED_ERROR;
984:
985: end;

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

993: AND organization_id = p_organization_id
994: AND inventory_item_id = p_inventory_item_id;
995:
996: IF (l_debug = 1) THEN
997: inv_pick_wave_pick_confirm_pub.tracelog ( 'After Insert action_id=3' , 'INV_LOT_API_PUB');
998: END IF;
999: ELSE -- if transaction_action_id is not 3
1000: /* ---------------------------------------------------------
1001: * call inv_lot_sel_attr.get_default to get the default value

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

1003: * ---------------------------------------------------------*/
1004: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE ) THEN
1005:
1006: IF (l_debug = 1) THEN
1007: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_default' , 'INV_LOT_API_PUB');
1008: END IF;
1009: inv_lot_sel_attr.get_default (
1010: x_attributes_default => l_attributes_default,
1011: x_attributes_default_count => l_attributes_default_count,

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

1019: p_lot_serial_number => p_lot_number,
1020: p_attributes => l_attributes_in
1021: );
1022: IF (l_debug = 1) THEN
1023: inv_pick_wave_pick_confirm_pub.tracelog ( 'After get_default' , 'INV_LOT_API_PUB');
1024: END IF;
1025:
1026: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1027: IF (l_debug = 1) THEN

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

1024: END IF;
1025:
1026: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1027: IF (l_debug = 1) THEN
1028: inv_pick_wave_pick_confirm_pub.tracelog ( 'exception of get_default' , 'INV_LOT_API_PUB');
1029: END IF;
1030: x_return_status := l_return_status;
1031: RAISE fnd_api.g_exc_unexpected_error;
1032: END IF;

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

1056: l_source_non_wms_lot_att_rec.attribute15 := NULL;
1057:
1058: IF p_transfer_organization_id IS NOT NULL THEN
1059: IF (l_debug = 1) THEN
1060: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_lot_att_from_source' , 'INV_LOT_API_PUB');
1061: END IF;
1062:
1063: get_lot_att_from_source
1064: (

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

1081: l_attributes_default := l_att_after_source_copy;
1082: l_attributes_default_count := l_num_wms_lot_att_copied;
1083:
1084: IF (l_debug = 1) THEN
1085: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling get_lot_att_from_source' , 'INV_LOT_API_PUB');
1086: END IF;
1087: END IF;
1088:
1089: /* Bug 2181558 - Code Ends */

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

1118: * g_lot_attributes_tbl(5).COLUMN_VALUE if OUT parameter
1119: * 'lot_status_enabled' is 'Y'.
1120: ***********************************************************************/
1121: IF (l_debug = 1) THEN
1122: inv_pick_wave_pick_confirm_pub.tracelog ( 'before calling get_lot_Serial_status_control' , 'INV_LOT_API_PUB');
1123: END IF;
1124: inv_material_status_grp.get_lot_serial_status_control (
1125: p_organization_id => p_organization_id,
1126: p_inventory_item_id => p_inventory_item_id,

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

1132: x_serial_status_enabled => l_serial_status_enabled,
1133: x_default_serial_status_id => l_default_serial_status_id
1134: );
1135: IF (l_debug = 1) THEN
1136: inv_pick_wave_pick_confirm_pub.tracelog ( 'After get_lot_Serial_status_control' , 'INV_LOT_API_PUB');
1137: END IF;
1138:
1139: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1140: x_return_status := l_return_status;

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

1156: p_inventory_item_id,
1157: 'Lot Attributes'
1158: );
1159: IF (l_debug = 1) THEN
1160: inv_pick_wave_pick_confirm_pub.tracelog ( 'before inserting into mtl_lot_numbers' , 'INV_LOT_API_PUB');
1161: END IF;
1162:
1163: --print_debug('after get_context_code 30', 4);
1164:

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

1366: g_lot_attributes_tbl(67).column_value
1367: );
1368:
1369: IF (l_debug = 1) THEN
1370: inv_pick_wave_pick_confirm_pub.tracelog ( 'After inserting the lot' , 'INV_LOT_API_PUB');
1371: END IF;
1372:
1373: END IF;
1374:

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

1381: l_status_rec.status_id := l_default_lot_status_id;
1382: l_status_rec.initial_status_flag := 'Y';
1383: inv_material_status_pkg.insert_status_history ( l_status_rec);
1384: IF (l_debug = 1) THEN
1385: inv_pick_wave_pick_confirm_pub.tracelog ( 'after calling insert_status_history' , 'INV_LOT_API_PUB');
1386: END IF;
1387: END IF;
1388:
1389: x_return_status := fnd_api.g_ret_sts_success;

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

1388:
1389: x_return_status := fnd_api.g_ret_sts_success;
1390: ELSE
1391: IF (l_debug = 1) THEN
1392: inv_pick_wave_pick_confirm_pub.tracelog ( 'INV_LOT_EXISTS' , 'INV_LOT_API_PUB');
1393: END IF;
1394: fnd_message.set_name ('INV' , 'INV_LOT_EXISTS' );
1395: fnd_msg_pub.ADD;
1396: --l_return_status := FND_API.G_RET_STS_SUCCESS;

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

1402: l_userid := fnd_global.user_id;
1403:
1404: --Lot exists, but now the user has entered the lot expiration date
1405: IF (l_debug = 1) THEN
1406: inv_pick_wave_pick_confirm_pub.tracelog ('Update the expiration date', 'INV_LOT_API_PUB');
1407: END IF;
1408:
1409: UPDATE mtl_lot_numbers
1410: SET expiration_date = p_expiration_date,

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

1420:
1421: -- End of API body.
1422: -- Standard check of p_commit.
1423: IF (l_debug = 1) THEN
1424: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inserted the Lot ' || p_lot_number, 'INV_LOT_API_PUB');
1425: END IF;
1426:
1427: IF fnd_api.to_boolean ( p_commit ) THEN
1428: COMMIT WORK;

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

1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: IF (l_debug = 1) THEN
1440: inv_pick_wave_pick_confirm_pub.tracelog ( 'Inside the exception ' || p_lot_number, 'INV_LOT_API_PUB');
1441: END IF;
1442: --print_debug('insertlot other exception', 4);
1443:
1444: ROLLBACK TO apiinsertlot_apipub;

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

1443:
1444: ROLLBACK TO apiinsertlot_apipub;
1445:
1446: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1447: fnd_msg_pub.add_exc_msg ('INV_LOT_API_PUB' , 'insertLot' );
1448: END IF;
1449:
1450: x_return_status := fnd_api.g_ret_sts_unexp_error;
1451: END insertlot;

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

2284: IF fnd_msg_pub.check_msg_level (
2285: fnd_msg_pub.g_msg_lvl_unexp_error
2286: )
2287: THEN
2288: fnd_msg_pub.add_exc_msg ('INV_LOT_API_PUB' , 'insertLot' );
2289: END IF;
2290:
2291: x_return_status := fnd_api.g_ret_sts_unexp_error;
2292: END inserttrxlot;

Line 2306: := 'INV_LOT_API_PUB.validate_unique_lot';

2302: l_lot_number NUMBER := 0;
2303: l_lot_uniqueness NUMBER := p_lot_uniqueness;
2304: l_count NUMBER := 0;
2305: l_api_name CONSTANT VARCHAR2 ( 50 )
2306: := 'INV_LOT_API_PUB.validate_unique_lot';
2307:
2308: CURSOR mln_cur_2
2309: IS
2310: SELECT lot_number

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

2605: auto_lot_number VARCHAR2 ( 80 ) := NULL;
2606: l_unique_lot BOOLEAN := FALSE;
2607: l_lotcount NUMBER;
2608: l_api_version CONSTANT NUMBER := 1.0;
2609: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
2610: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2611: -- The following 2 variables are added as a part of bug fix for: Bug #3330855
2612: v_org_code VARCHAR2 ( 3 );
2613: v_item_name VARCHAR2 ( 80 );

Line 2974: x_parent_call := inv_lot_api_pub.auto_gen_lot (

2970: /*=========================================
2971: Recall this api with parent lot = NULL;
2972: *=========================================*/
2973: x_parent_lot_number := NULL;
2974: x_parent_call := inv_lot_api_pub.auto_gen_lot (
2975: p_org_id,
2976: p_inventory_item_id,
2977: p_lot_generation,
2978: p_lot_uniqueness,

Line 3060: x_parent_call := inv_lot_api_pub.auto_gen_lot (

3056: /*=========================================
3057: Recall this api with parent lot = NULL;
3058: *=========================================*/
3059: x_parent_lot_number := NULL;
3060: x_parent_call := inv_lot_api_pub.auto_gen_lot (
3061: p_org_id,
3062: p_inventory_item_id,
3063: p_lot_generation,
3064: p_lot_uniqueness,

Line 3364: IF inv_lot_api_pub.validate_unique_lot

3360:
3361:
3362: --RETURN (auto_lot_number);
3363: /*
3364: IF inv_lot_api_pub.validate_unique_lot
3365: ( p_org_id,
3366: p_inventory_item_id,
3367: lot_uniqueness,
3368: auto_lot_number)

Line 3398: inv_lot_api_pub.validate_unique_lot(

3394: ELSE
3395: l_unique_lot := FALSE;
3396: END IF; */
3397: l_unique_lot :=
3398: inv_lot_api_pub.validate_unique_lot(
3399: p_org_id
3400: , p_inventory_item_id
3401: , p_lot_uniqueness
3402: , auto_lot_number

Line 3475: := 'INV_LOT_API_PUB.validate_unique_lot';

3471: l_lot_number NUMBER := 0;
3472: l_lot_uniqueness NUMBER := p_lot_uniqueness;
3473: l_count NUMBER := 0;
3474: l_api_name CONSTANT VARCHAR2 ( 50 )
3475: := 'INV_LOT_API_PUB.validate_unique_lot';
3476:
3477: CURSOR mln_cur_1
3478: IS
3479: SELECT lot_number

Line 3853: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

3849: , p_attribute_category IN VARCHAR2
3850: , p_lot_attribute_category IN VARCHAR2
3851: , p_inventory_item_id IN NUMBER
3852: , p_organization_id IN NUMBER
3853: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
3854: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
3855: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
3856: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
3857: , p_disable_flag IN NUMBER

Line 3854: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

3850: , p_lot_attribute_category IN VARCHAR2
3851: , p_inventory_item_id IN NUMBER
3852: , p_organization_id IN NUMBER
3853: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
3854: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
3855: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
3856: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
3857: , p_disable_flag IN NUMBER
3858: , p_grade_code IN VARCHAR2

Line 3855: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

3851: , p_inventory_item_id IN NUMBER
3852: , p_organization_id IN NUMBER
3853: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
3854: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
3855: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
3856: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
3857: , p_disable_flag IN NUMBER
3858: , p_grade_code IN VARCHAR2
3859: , p_origination_date IN DATE

Line 3856: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

3852: , p_organization_id IN NUMBER
3853: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
3854: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
3855: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
3856: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
3857: , p_disable_flag IN NUMBER
3858: , p_grade_code IN VARCHAR2
3859: , p_origination_date IN DATE
3860: , p_date_code IN VARCHAR2

Line 4229: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

4225: , p_organization_id IN NUMBER
4226: , p_lot_number IN VARCHAR2
4227: , p_attribute_category IN VARCHAR2
4228: , p_lot_attribute_category IN VARCHAR2
4229: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4230: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4231: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4232: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4233: , p_wms_is_installed IN VARCHAR2

Line 4230: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

4226: , p_lot_number IN VARCHAR2
4227: , p_attribute_category IN VARCHAR2
4228: , p_lot_attribute_category IN VARCHAR2
4229: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4230: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4231: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4232: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4233: , p_wms_is_installed IN VARCHAR2
4234: , p_source IN NUMBER

Line 4231: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

4227: , p_attribute_category IN VARCHAR2
4228: , p_lot_attribute_category IN VARCHAR2
4229: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4230: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4231: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4232: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4233: , p_wms_is_installed IN VARCHAR2
4234: , p_source IN NUMBER
4235: , p_disable_flag IN NUMBER

Line 4232: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

4228: , p_lot_attribute_category IN VARCHAR2
4229: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
4230: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
4231: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
4232: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
4233: , p_wms_is_installed IN VARCHAR2
4234: , p_source IN NUMBER
4235: , p_disable_flag IN NUMBER
4236: , p_grade_code IN VARCHAR2

Line 4328: inv_lot_api_pub.validate_unique_lot(

4324: END;
4325:
4326: /* Call the function to check the Lot Uniqueness */
4327: l_chk_lot_uniqueness :=
4328: inv_lot_api_pub.validate_unique_lot(
4329: p_org_id => p_organization_id
4330: , p_inventory_item_id => p_inventory_item_id
4331: , p_lot_uniqueness => l_lot_number_uniqueness
4332: , p_auto_lot_number => p_lot_number

Line 4594: l_wms_named_attributes INV_LOT_API_PUB.wms_named_attributes;

4590: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4591: AND organization_id = p_lot_rec.organization_id
4592: AND lot_number = p_lot_rec.lot_number;
4593:
4594: l_wms_named_attributes INV_LOT_API_PUB.wms_named_attributes;
4595: l_wms_named_attr wms_named_attr%ROWTYPE;
4596: l_attr_category_cur attr_category_cur%ROWTYPE;
4597: l_c_attributes_cur c_attributes_cur%ROWTYPE;
4598: l_n_attributes_cur n_attributes_cur%ROWTYPE;

Line 4601: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;

4597: l_c_attributes_cur c_attributes_cur%ROWTYPE;
4598: l_n_attributes_cur n_attributes_cur%ROWTYPE;
4599: l_d_attributes_cur d_attributes_cur%ROWTYPE;
4600: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4601: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4602: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4603: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4604: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4605: /* Index variables for looping through the input tables*/

Line 4602: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

4598: l_n_attributes_cur n_attributes_cur%ROWTYPE;
4599: l_d_attributes_cur d_attributes_cur%ROWTYPE;
4600: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4601: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4602: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4603: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4604: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4605: /* Index variables for looping through the input tables*/
4606: l_attr_index NUMBER;

Line 4603: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

4599: l_d_attributes_cur d_attributes_cur%ROWTYPE;
4600: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4601: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4602: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4603: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4604: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4605: /* Index variables for looping through the input tables*/
4606: l_attr_index NUMBER;
4607: l_c_attr_index NUMBER;

Line 4604: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

4600: l_inv_attributes_cur inv_attributes_cur%ROWTYPE;
4601: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4602: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
4603: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
4604: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
4605: /* Index variables for looping through the input tables*/
4606: l_attr_index NUMBER;
4607: l_c_attr_index NUMBER;
4608: l_n_attr_index NUMBER;

Line 4625: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;

4621: inv_global_index NUMBER;
4622: inv_context_index NUMBER;
4623: wms_global_index NUMBER;
4624: wms_context_index NUMBER;
4625: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4626: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4627: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4628: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4629: /* Shelf life code constants */

Line 4626: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;

4622: inv_context_index NUMBER;
4623: wms_global_index NUMBER;
4624: wms_context_index NUMBER;
4625: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4626: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4627: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4628: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4629: /* Shelf life code constants */
4630: no_shelf_life_control CONSTANT NUMBER := 1;

Line 4627: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;

4623: wms_global_index NUMBER;
4624: wms_context_index NUMBER;
4625: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4626: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4627: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4628: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4629: /* Shelf life code constants */
4630: no_shelf_life_control CONSTANT NUMBER := 1;
4631: item_shelf_life_days CONSTANT NUMBER := 2;

Line 4628: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;

4624: wms_context_index NUMBER;
4625: l_res_inv_attributes_tbl inv_lot_api_pub.char_tbl;
4626: l_res_c_attributes_tbl inv_lot_api_pub.char_tbl;
4627: l_res_n_attributes_tbl inv_lot_api_pub.number_tbl;
4628: l_res_d_attributes_tbl inv_lot_api_pub.date_tbl;
4629: /* Shelf life code constants */
4630: no_shelf_life_control CONSTANT NUMBER := 1;
4631: item_shelf_life_days CONSTANT NUMBER := 2;
4632: user_defined_exp_date CONSTANT NUMBER := 4;

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

5708: END IF;
5709: IF g_debug = 1 THEN
5710: print_debug('Updating MTL_LOT_NUMBERS table ....' , 9);
5711: END IF;
5712: inv_log_util.trace('l_expiration_date is:'||l_expiration_date, 'INV_LOT_API_PUB','9'); --For bug 4888300
5713:
5714: IF l_wms_installed = 'TRUE' THEN
5715: UPDATE mtl_lot_numbers
5716: SET expiration_date =

Line 6759: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

6755: , p_expiration_date IN DATE
6756: , p_disable_flag IN NUMBER
6757: , p_attribute_category IN VARCHAR2
6758: , p_lot_attribute_category IN VARCHAR2
6759: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6760: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6761: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6762: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6763: , p_grade_code IN VARCHAR2

Line 6760: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

6756: , p_disable_flag IN NUMBER
6757: , p_attribute_category IN VARCHAR2
6758: , p_lot_attribute_category IN VARCHAR2
6759: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6760: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6761: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6762: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6763: , p_grade_code IN VARCHAR2
6764: , p_origination_date IN DATE

Line 6761: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

6757: , p_attribute_category IN VARCHAR2
6758: , p_lot_attribute_category IN VARCHAR2
6759: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6760: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6761: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6762: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6763: , p_grade_code IN VARCHAR2
6764: , p_origination_date IN DATE
6765: , p_date_code IN VARCHAR2

Line 6762: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

6758: , p_lot_attribute_category IN VARCHAR2
6759: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
6760: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
6761: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
6762: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
6763: , p_grade_code IN VARCHAR2
6764: , p_origination_date IN DATE
6765: , p_date_code IN VARCHAR2
6766: , p_status_id IN NUMBER

Line 7090: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

7086: , p_inventory_item_id IN NUMBER
7087: , p_organization_id IN NUMBER
7088: , p_disable_flag IN NUMBER
7089: , p_lot_attribute_category IN VARCHAR2
7090: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
7091: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
7092: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
7093: , p_grade_code IN VARCHAR2
7094: , p_origination_date IN DATE

Line 7091: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

7087: , p_organization_id IN NUMBER
7088: , p_disable_flag IN NUMBER
7089: , p_lot_attribute_category IN VARCHAR2
7090: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
7091: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
7092: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
7093: , p_grade_code IN VARCHAR2
7094: , p_origination_date IN DATE
7095: , p_date_code IN VARCHAR2

Line 7092: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

7088: , p_disable_flag IN NUMBER
7089: , p_lot_attribute_category IN VARCHAR2
7090: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
7091: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
7092: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
7093: , p_grade_code IN VARCHAR2
7094: , p_origination_date IN DATE
7095: , p_date_code IN VARCHAR2
7096: , p_change_date IN DATE

Line 7151: x_return_status := inv_lot_api_pub.g_ret_sts_success;

7147: l_msg_data VARCHAR2(2000);
7148: l_enabled_attributes NUMBER;
7149: l_context_enabled BOOLEAN := false;
7150: BEGIN
7151: x_return_status := inv_lot_api_pub.g_ret_sts_success;
7152: SAVEPOINT wms_lot_dff_validate;
7153:
7154: IF g_debug = 1 THEN
7155: print_debug('In the beginning of the program lot_dff_validate', 9);

Line 7767: x_return_status := inv_lot_api_pub.g_ret_sts_error;

7763: end if;
7764: EXCEPTION
7765: WHEN g_exc_error THEN
7766: print_debug('Validation error', 9);
7767: x_return_status := inv_lot_api_pub.g_ret_sts_error;
7768: ROLLBACK TO wms_lot_dff_validate;
7769:
7770: IF g_debug = 1 THEN
7771: print_debug('Program LOT_DFF_VALIDATE has completed with validation errors', 9);

Line 7776: x_return_status := inv_lot_api_pub.g_ret_sts_error;

7772: END IF;
7773:
7774: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7775: WHEN errors_received THEN
7776: x_return_status := inv_lot_api_pub.g_ret_sts_error;
7777:
7778: IF g_debug = 1 THEN
7779: print_debug('Program LOT_DFF_VALIDATE has completed with errors_received', 9);
7780: END IF;

Line 7799: x_return_status := inv_lot_api_pub.g_ret_sts_unexp_error;

7795: END LOOP;
7796:
7797: ROLLBACK TO wms_lot_dff_validate;
7798: WHEN OTHERS THEN
7799: x_return_status := inv_lot_api_pub.g_ret_sts_unexp_error;
7800: ROLLBACK TO wms_lot_dff_validate;
7801: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
7802:
7803: IF g_debug = 1 THEN

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

8274:
8275:
8276: l_api_name CONSTANT VARCHAR2(30) := 'validate_lot_indivisible';
8277: l_api_version CONSTANT NUMBER := 1.0;
8278: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_LOT_API_PUB';
8279:
8280: l_return BOOLEAN;
8281: l_lot_divisible VARCHAR2(1);
8282: l_lot_control_code pls_integer;

Line 8815: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

8811: , p_expiration_date IN DATE
8812: , p_disable_flag IN NUMBER
8813: , p_attribute_category IN VARCHAR2
8814: , p_lot_attribute_category IN VARCHAR2
8815: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
8816: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
8817: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
8818: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
8819: , p_grade_code IN VARCHAR2

Line 8816: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

8812: , p_disable_flag IN NUMBER
8813: , p_attribute_category IN VARCHAR2
8814: , p_lot_attribute_category IN VARCHAR2
8815: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
8816: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
8817: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
8818: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
8819: , p_grade_code IN VARCHAR2
8820: , p_origination_date IN DATE

Line 8817: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

8813: , p_attribute_category IN VARCHAR2
8814: , p_lot_attribute_category IN VARCHAR2
8815: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
8816: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
8817: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
8818: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
8819: , p_grade_code IN VARCHAR2
8820: , p_origination_date IN DATE
8821: , p_date_code IN VARCHAR2

Line 8818: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

8814: , p_lot_attribute_category IN VARCHAR2
8815: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
8816: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
8817: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
8818: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
8819: , p_grade_code IN VARCHAR2
8820: , p_origination_date IN DATE
8821: , p_date_code IN VARCHAR2
8822: , p_status_id IN NUMBER

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

9695: IS
9696: l_unique_lot BOOLEAN := FALSE;
9697: l_lotcount NUMBER;
9698: l_api_version CONSTANT NUMBER := 1.0;
9699: l_api_name CONSTANT VARCHAR2 ( 50 ) := 'INV_LOT_API_PUB.auto_gen_lot';
9700: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9701: v_org_code VARCHAR2 ( 3 );
9702: v_item_name VARCHAR2 ( 40 );
9703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;

Line 9707: x_parent_call := inv_lot_api_pub.auto_gen_lot (

9703: x_parent_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE := NULL;
9704: x_parent_call MTL_LOT_NUMBERS.LOT_NUMBER%TYPE;
9705:
9706: BEGIN
9707: x_parent_call := inv_lot_api_pub.auto_gen_lot (
9708: p_org_id,
9709: p_inventory_item_id,
9710: p_lot_generation,
9711: p_lot_uniqueness,

Line 9854: 'inv_lot_api_pub'

9850: IF NOT fnd_api.compatible_api_call(
9851: l_api_version,
9852: p_api_version,
9853: l_api_name,
9854: 'inv_lot_api_pub'
9855: ) THEN
9856: IF (g_debug = 1) THEN
9857: print_debug('FND_API not compatible INV_LOT_API_PUB.CHECK_LOT_INDIVISIBILITY: '||l_progress, 1);
9858: END IF;

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

9853: l_api_name,
9854: 'inv_lot_api_pub'
9855: ) THEN
9856: IF (g_debug = 1) THEN
9857: print_debug('FND_API not compatible INV_LOT_API_PUB.CHECK_LOT_INDIVISIBILITY: '||l_progress, 1);
9858: END IF;
9859: RAISE fnd_api.g_exc_unexpected_error;
9860: END IF;
9861:

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

9903: print_debug('l_locator_id '|| l_locator_id, 1);
9904: print_debug('l_item_id '|| l_item_id , 1);
9905: print_debug('l_parent_trx_id '|| l_parent_trx_id, 1);
9906: print_debug('l_trx_unit_of_measure '|| l_trx_unit_of_measure, 1);
9907: print_debug('Before calling INV_LOT_API_PUB.validate_lot_indivisible ',1);
9908: END IF;
9909:
9910: l_progress := '004';
9911:

Line 9913: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

9909:
9910: l_progress := '004';
9911:
9912: ---call the indiv function
9913: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
9914: p_api_version =>1.0
9915: ,p_init_msg_list =>FND_API.G_FALSE
9916: ,p_commit =>FND_API.G_FALSE
9917: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL

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

9930: ,x_msg_data =>l_msg_data
9931: ))THEN
9932:
9933: IF g_debug = 1 THEN
9934: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return FALSE ' || l_return_status || 'and '|| l_progress, 9);
9935: END IF;
9936:
9937: l_progress := '005';
9938:

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

10025: l_progress := '011';
10026:
10027: IF l_return_status = fnd_api.g_ret_sts_error THEN
10028: IF g_debug = 1 THEN
10029: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);
10030: END IF;
10031:
10032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

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

10029: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a user defined exception '|| l_progress, 9);
10030: END IF;
10031:
10032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
10034: fnd_msg_pub.ADD;
10035: RAISE g_exc_error;
10036:
10037: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

10037: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
10038: l_progress := '012' ;
10039:
10040: IF g_debug = 1 THEN
10041: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
10042: END IF;
10043:
10044: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10045: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');

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

10041: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible has failed with a Unexpected exception' || l_progress, 9);
10042: END IF;
10043:
10044: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
10045: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
10046: fnd_msg_pub.ADD;
10047: RAISE g_exc_unexpected_error;
10048: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
10049:

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

10047: RAISE g_exc_unexpected_error;
10048: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
10049:
10050:
10051: END IF;--------IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
10052:
10053: l_progress := '013';
10054:
10055: IF g_debug = 1 THEN

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

10052:
10053: l_progress := '013';
10054:
10055: IF g_debug = 1 THEN
10056: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE: ' || l_return_status || 'and '|| l_progress, 9);
10057: print_debug('Exitting inv_lot_api_pub.check_lot_indivisibility :'|| l_progress, 9);
10058: END IF;
10059:
10060: ELSE ----------IF p_transaction_type_id IN

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

10053: l_progress := '013';
10054:
10055: IF g_debug = 1 THEN
10056: print_debug('Program INV_LOT_API_PUB.validate_lot_indivisible return TRUE: ' || l_return_status || 'and '|| l_progress, 9);
10057: print_debug('Exitting inv_lot_api_pub.check_lot_indivisibility :'|| l_progress, 9);
10058: END IF;
10059:
10060: ELSE ----------IF p_transaction_type_id IN
10061:

Line 10431: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE

10427:
10428: -- Lot Indivisible Validation:
10429: --{
10430: IF (l_lot_divisible_flag = 'N') THEN
10431: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE
10432: ( p_api_version => p_api_version
10433: , p_init_msg_list => p_init_msg_list
10434: , p_transaction_type_id => p_transaction_type_id
10435: , p_organization_id => p_organization_id

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

10448:
10449: IF (NOT l_lot_indiv_trx_valid) THEN
10450: -- the transaction is not valid regarding lot indivisible:
10451: IF (l_debug = 1) THEN
10452: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (ERROR)', g_pkg_name, 9);
10453: END IF;
10454: RAISE FND_API.G_EXC_ERROR;
10455: END IF;
10456: IF (l_debug = 1) THEN

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

10453: END IF;
10454: RAISE FND_API.G_EXC_ERROR;
10455: END IF;
10456: IF (l_debug = 1) THEN
10457: inv_log_util.trace('validate_quantities: INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE (PASS) ', g_pkg_name, 9);
10458: END IF;
10459:
10460: END IF;--} -- l_lot_divisible_flag = 'N'
10461:

Line 10495: END inv_lot_api_pub;

10491: RETURN FALSE;
10492:
10493: END validate_quantities;
10494:
10495: END inv_lot_api_pub;
10496:
10497: