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.WMS_RULE_PVT dependencies on INV_DETAIL_UTIL_PVT

Line 636: and inv_detail_util_pvt.is_serial_trx_allowed(

632: and loc.inventory_location_id (+)= msn.current_locator_id
633: and lot.organization_id (+)= msn.current_organization_id
634: and lot.inventory_Item_id (+)= msn.inventory_item_id
635: and lot.lot_number (+)= msn.lot_number
636: and inv_detail_util_pvt.is_serial_trx_allowed(
637: g_transaction_type_id
638: ,msn.current_organization_id
639: ,msn.inventory_item_id
640: ,msn.status_id) = ''Y'' ';

Line 1057: --inv_detail_util_pvt.init_output_serial_rows;

1053: g_stmt_serial_detail_new := NULL;
1054: g_pick_base := NULL;
1055: -- clean up the serial number detailing table
1056: -- Commenting out for Bug 5251221
1057: --inv_detail_util_pvt.init_output_serial_rows;
1058: -- clean up the bind variables table
1059: inv_sql_binding_pvt.initbindtables;
1060: END freeglobals;
1061:

Line 1424: * 'Calling inv_detail_util_pvt.build_sql for base');

1420: *so that we only get one rec per rev/lot/sub/loc when we
1421: *aren't allocating LPNs
1422: *--build non-serial controlled pick base
1423: *log_statement(l_api_name, 'build_sql_no_serial',
1424: * 'Calling inv_detail_util_pvt.build_sql for base');
1425: *inv_detail_util_pvt.build_sql
1426: *( x_return_status => l_return_status ,
1427: * x_sql_statement => g_pick_base
1428: * );

Line 1425: *inv_detail_util_pvt.build_sql

1421: *aren't allocating LPNs
1422: *--build non-serial controlled pick base
1423: *log_statement(l_api_name, 'build_sql_no_serial',
1424: * 'Calling inv_detail_util_pvt.build_sql for base');
1425: *inv_detail_util_pvt.build_sql
1426: *( x_return_status => l_return_status ,
1427: * x_sql_statement => g_pick_base
1428: * );
1429: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1431: * 'Error in inv_detail_util_pvt.build_sql');

1427: * x_sql_statement => g_pick_base
1428: * );
1429: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1430: * log_statement(l_api_name, 'err_build_sql',
1431: * 'Error in inv_detail_util_pvt.build_sql');
1432: * RAISE fnd_api.g_exc_unexpected_error;
1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1434: * log_statement(l_api_name, 'unexp_err_build_sql',
1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');

Line 1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');

1431: * 'Error in inv_detail_util_pvt.build_sql');
1432: * RAISE fnd_api.g_exc_unexpected_error;
1433: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1434: * log_statement(l_api_name, 'unexp_err_build_sql',
1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1436: * RAISE fnd_api.g_exc_error;
1437: *END IF;
1438: *log_statement(l_api_name, 'success_build_sql',
1439: * 'Inv_detail_util_pvt.build_sql successful');

Line 1439: * 'Inv_detail_util_pvt.build_sql successful');

1435: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1436: * RAISE fnd_api.g_exc_error;
1437: *END IF;
1438: *log_statement(l_api_name, 'success_build_sql',
1439: * 'Inv_detail_util_pvt.build_sql successful');
1440:
1441: *-- replace the bind variables used in the base sql
1442: *-- with the global variables in the stored rule procedure
1443: *g_pick_base :=

Line 1531: || ' AND inv_detail_util_pvt.is_sub_loc_lot_trx_allowed('

1527: || ' AND sub.organization_id = x.organization_id '
1528: || g_line_feed
1529: || ' AND sub.secondary_inventory_name = x.subinventory_code '
1530: || g_line_feed; /*
1531: || ' AND inv_detail_util_pvt.is_sub_loc_lot_trx_allowed('
1532: || g_line_feed
1533: || ' g_transaction_type_id, '
1534: || g_line_feed
1535: || ' x.organization_id, '

Line 4535: inv_detail_util_pvt.search_serial_numbers(

4531: IF l_debug = 1 THEN
4532: log_statement(l_api_name, 'search_sn', 'Calling Search Serial Numbers');
4533: END IF;
4534:
4535: inv_detail_util_pvt.search_serial_numbers(
4536: p_organization_id => p_organization_id
4537: , p_inventory_item_id => p_inventory_item_id
4538: , p_serial_number => g_locs(p_record_id).serial_number
4539: , x_found => l_found

Line 4652: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);

4648: -- can use it.
4649: IF (g_locs(p_record_id).serial_number IS NOT NULL
4650: And g_locs(p_record_id).serial_number <> FND_API.G_MISS_CHAR)
4651: THEN
4652: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);
4653:
4654: IF l_found = FALSE THEN
4655: IF l_debug = 1 THEN
4656: log_statement(l_api_name, 'lock_sn', 'Could not lock Serial Number. Exiting.');

Line 4672: inv_detail_util_pvt.add_serial_number(p_inventory_item_id, p_organization_id, g_locs(p_record_id).serial_number, l_serial_index);

4668: RETURN;
4669: END IF;
4670:
4671: -- add serial number to pl/sql table of detailed serials
4672: inv_detail_util_pvt.add_serial_number(p_inventory_item_id, p_organization_id, g_locs(p_record_id).serial_number, l_serial_index);
4673: END IF;
4674:
4675: -- Update quantity tree for this suggested quantity
4676: IF l_debug = 1 THEN

Line 5169: inv_detail_util_pvt.search_serial_numbers(

5165: IF l_debug = 1 THEN
5166: log_statement(l_api_name, 'search_sn', 'Calling Search Serial Numbers');
5167: END IF;
5168:
5169: inv_detail_util_pvt.search_serial_numbers(
5170: p_organization_id => p_organization_id
5171: , p_inventory_item_id => p_inventory_item_id
5172: , p_serial_number => g_locs(p_record_id).serial_number
5173: , x_found => l_found

Line 5281: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);

5277:
5278: --Lock Serial number, so that no other detailing process
5279: -- can use it.
5280: IF g_locs(p_record_id).serial_number IS NOT NULL THEN
5281: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);
5282:
5283: IF l_found = FALSE THEN
5284: IF l_debug = 1 THEN
5285: log_statement(l_api_name, 'lock_sn', 'Could not lock Serial Number. Exiting.');

Line 5299: inv_detail_util_pvt.add_serial_number(p_inventory_item_id, p_organization_id, g_locs(p_record_id).serial_number, l_serial_index);

5295: RETURN;
5296: END IF;
5297:
5298: -- add serial number to pl/sql table of detailed serials
5299: inv_detail_util_pvt.add_serial_number(p_inventory_item_id, p_organization_id, g_locs(p_record_id).serial_number, l_serial_index);
5300: END IF;
5301:
5302: --If quantity remaining to allocate is greater than 0, update the
5303: --quantity tree and insert the record into WTT

Line 6701: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;

6697:
6698: l_return_value BOOLEAN; -- [ Added ]
6699: ---
6700: l_allocate_serial_flag VARCHAR2(1);
6701: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
6702: l_custom_serial_index NUMBER;
6703:
6704: -- [ Lot Indivisible Var
6705: l_indiv_lot_allowed VARCHAR2(1); -- [ Added ]

Line 7429: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

7425: where inventory_item_id = p_inventory_item_id
7426: and current_organization_id = p_organization_id
7427: and serial_number = l_serial_number;
7428:
7429: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
7430: p_transaction_type_id
7431: ,p_organization_id
7432: ,p_inventory_item_id
7433: ,l_serial_status_id) ;

Line 7437: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

7433: ,l_serial_status_id) ;
7434: END IF;
7435: -- Bug 4756156
7436: -- IF ((l_lot_number IS NOT NULL) AND (nvl(l_lot_status, 'Y') = 'Y')) THEN
7437: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
7438: p_transaction_type_id
7439: ,p_organization_id
7440: ,p_inventory_item_id
7441: ,l_subinventory_code

Line 7779: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

7775: where inventory_item_id = p_inventory_item_id
7776: and current_organization_id = p_organization_id
7777: and serial_number = v_current_row.serial_number;
7778:
7779: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
7780: p_transaction_type_id
7781: ,p_organization_id
7782: ,p_inventory_item_id
7783: ,l_serial_status_id) ;

Line 7807: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

7803: log_statement(l_api_name, 'before calling trx_allowed: ', l_sub_loc_lot_trx_allowed);
7804: END IF;
7805:
7806: l_onhand_status_trx_allowed := 'N';
7807: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
7808: p_transaction_type_id
7809: ,p_organization_id
7810: ,p_inventory_item_id
7811: ,v_current_row.subinventory_code

Line 7822: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

7818: ELSE -- IF l_default_status_id = -1 THEN
7819:
7820: l_sub_loc_lot_trx_allowed:='N';
7821: IF (inv_cache.item_rec.serial_number_control_code in (1,6)) THEN
7822: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
7823: p_transaction_type_id
7824: ,p_organization_id
7825: ,p_inventory_item_id
7826: ,v_current_row.subinventory_code

Line 8961: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

8957: where inventory_item_id = p_inventory_item_id
8958: and current_organization_id = p_organization_id
8959: and serial_number = v_current_row.serial_number;
8960:
8961: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
8962: p_transaction_type_id
8963: ,p_organization_id
8964: ,p_inventory_item_id
8965: ,l_serial_status_id) ;

Line 8984: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

8980: -- LPN Status Project
8981: l_onhand_status_trx_allowed := 'Y';
8982: IF l_default_status_id = -1 THEN
8983: l_onhand_status_trx_allowed := 'N';
8984: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
8985: p_transaction_type_id
8986: ,p_organization_id
8987: ,p_inventory_item_id
8988: ,v_current_row.subinventory_code

Line 8993: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

8989: ,v_current_row.locator_id
8990: ,v_current_row.lot_number);
8991:
8992: /*log_statement(l_api_name, 'Stasus', 'Before calling my method-Amrita);
8993: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
8994: p_transaction_type_id
8995: ,p_organization_id
8996: ,p_inventory_item_id
8997: ,v_current_row.subinventory_code

Line 9007: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

9003:
9004: ELSE
9005: l_sub_loc_lot_trx_allowed:='N';
9006: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
9007: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
9008: p_transaction_type_id
9009: ,p_organization_id
9010: ,p_inventory_item_id
9011: ,v_current_row.subinventory_code

Line 10283: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

10279:
10280: --Bug Number :3457530(cheking for a transaction_type_id)
10281:
10282: IF ( p_transaction_type_id <> 64) THEN
10283: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
10284: p_transaction_type_id => p_transaction_type_id
10285: , p_organization_id => p_organization_id
10286: , p_inventory_item_id => p_inventory_item_id
10287: , p_subinventory_code => l_osubinventory_code

Line 10654: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN

10650: inv_log_util.trace('Serial not found', 'delete_serial_numbers', 9);
10651: END IF;
10652: exit;
10653: ELSE
10654: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN
10655: IF l_debug = 1 THEN
10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);

Line 10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

10655: IF l_debug = 1 THEN
10656: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
10657: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;
10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP
10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND

Line 10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP

10658: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;
10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP
10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND
10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND
10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:

Line 10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND

10659: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10660: END IF;
10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP
10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND
10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND
10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN

Line 10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND

10660: END IF;
10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP
10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND
10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND
10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;

Line 10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN

10661:
10662: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP
10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND
10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND
10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;

Line 10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN

10663: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id) AND
10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND
10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
10671:

Line 10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;

10664: (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id) AND
10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);

Line 10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;

10665: (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number) THEN
10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;

Line 10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;

10666:
10667: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10674: IF l_debug = 1 THEN

Line 10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);

10668: inv_detail_util_pvt.g_output_serial_rows(i).organization_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10674: IF l_debug = 1 THEN
10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10676: END IF;

Line 10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;

10669: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
10670: inv_detail_util_pvt.g_output_serial_rows(i).serial_number := inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10674: IF l_debug = 1 THEN
10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10676: END IF;
10677:

Line 10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

10671:
10672: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
10673: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10674: IF l_debug = 1 THEN
10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10676: END IF;
10677:
10678: ELSE
10679: inv_detail_util_pvt.g_output_serial_rows.delete;

Line 10679: inv_detail_util_pvt.g_output_serial_rows.delete;

10675: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr ' || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
10676: END IF;
10677:
10678: ELSE
10679: inv_detail_util_pvt.g_output_serial_rows.delete;
10680: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10681: IF l_debug = 1 THEN
10682: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
10683: END IF;

Line 10680: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;

10676: END IF;
10677:
10678: ELSE
10679: inv_detail_util_pvt.g_output_serial_rows.delete;
10680: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
10681: IF l_debug = 1 THEN
10682: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
10683: END IF;
10684:

Line 10685: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)

10681: IF l_debug = 1 THEN
10682: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
10683: END IF;
10684:
10685: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
10686: exit; --if a serial has been deleted, needn't check other serials present in g_output_serial_rows
10687: END IF; --End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
10688: END LOOP; --End of FOR loop
10689: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0)

Line 10687: END IF; --End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)

10683: END IF;
10684:
10685: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
10686: exit; --if a serial has been deleted, needn't check other serials present in g_output_serial_rows
10687: END IF; --End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
10688: END LOOP; --End of FOR loop
10689: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0)
10690: END IF;-- End of IF l_get_serial%NOTFOUND
10691: END LOOP;--End of LOOP for CURSOR

Line 10689: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0)

10685: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
10686: exit; --if a serial has been deleted, needn't check other serials present in g_output_serial_rows
10687: END IF; --End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
10688: END LOOP; --End of FOR loop
10689: END IF;--End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0)
10690: END IF;-- End of IF l_get_serial%NOTFOUND
10691: END LOOP;--End of LOOP for CURSOR
10692: CLOSE l_get_serial;
10693: /*End of fix for Bug 5251221 */

Line 11752: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

11748: g_st_locator_id = l_olocator_id THEN
11749: l_allowed := g_allowed;
11750: ELSE
11751:
11752: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
11753: p_transaction_type_id => p_transaction_type_id
11754: ,p_organization_id => p_organization_id
11755: ,p_inventory_item_id => p_inventory_item_id
11756: ,p_subinventory_code => l_osubinventory_code

Line 15332: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

15328: IF l_default_status_id = -1 THEN
15329: l_onhand_status_trx_allowed:='N';
15330:
15331: -- Get sub/Locator /Lot / serial status allowed --
15332: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
15333: p_transaction_type_id => p_transaction_type_id
15334: , p_organization_id => p_organization_id
15335: , p_inventory_item_id => p_inventory_item_id
15336: , p_subinventory_code => l_from_subinventory_code

Line 15353: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

15349:
15350: ELSE
15351: l_allowed:='N';
15352: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
15353: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
15354: p_transaction_type_id
15355: ,p_organization_id
15356: ,p_inventory_item_id
15357: ,l_from_subinventory_code

Line 15386: 'Calling inv_detail_util_pvt.is_serial_trx_allowed');

15382: IF l_debug = 1 THEN
15383: log_statement(l_api_name, 'Quick Pick',
15384: 'inside If l_serial_status_enabled = y ') ;
15385: log_statement(l_api_name, 'Quick Pick',
15386: 'Calling inv_detail_util_pvt.is_serial_trx_allowed');
15387: END IF;
15388: --bug 7171840 changed the code to check the status at serial level rather than item defualt status
15389: FOR L_LPN_CUR IN lpn_serial_cur(l_lpn_id) LOOP
15390: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

Line 15390: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

15386: 'Calling inv_detail_util_pvt.is_serial_trx_allowed');
15387: END IF;
15388: --bug 7171840 changed the code to check the status at serial level rather than item defualt status
15389: FOR L_LPN_CUR IN lpn_serial_cur(l_lpn_id) LOOP
15390: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
15391: p_transaction_type_id => p_transaction_type_id
15392: ,p_organization_id => p_organization_id
15393: ,p_inventory_item_id => p_inventory_item_id
15394: ,p_serial_status => L_LPN_CUR.STATUS_ID ) ;

Line 15404: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

15400: END IF;
15401: L_SERIAL_ALLOWED := 'Y';
15402: END LOOP ;
15403: /* commented out for bug 7171840
15404: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
15405: p_transaction_type_id => p_transaction_type_id
15406: ,p_organization_id => p_organization_id
15407: ,p_inventory_item_id => p_inventory_item_id
15408: ,p_serial_status => l_default_serial_status_id ) ;