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 656: and inv_detail_util_pvt.is_serial_trx_allowed(

652: and loc.inventory_location_id (+)= msn.current_locator_id
653: and lot.organization_id (+)= msn.current_organization_id
654: and lot.inventory_Item_id (+)= msn.inventory_item_id
655: and lot.lot_number (+)= msn.lot_number
656: and inv_detail_util_pvt.is_serial_trx_allowed(
657: g_transaction_type_id
658: ,msn.current_organization_id
659: ,msn.inventory_item_id
660: ,msn.status_id) = ''Y'' ';

Line 1140: --inv_detail_util_pvt.init_output_serial_rows;

1136: g_pickuom_serial_case := 0; -- Added for Bug 13448337
1137: g_pickuom_serial_flag := 0; -- Added for Bug 13448337
1138: -- clean up the serial number detailing table
1139: -- Commenting out for Bug 5251221
1140: --inv_detail_util_pvt.init_output_serial_rows;
1141: -- clean up the bind variables table
1142: inv_sql_binding_pvt.initbindtables;
1143: END freeglobals;
1144:

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

1503: *so that we only get one rec per rev/lot/sub/loc when we
1504: *aren't allocating LPNs
1505: *--build non-serial controlled pick base
1506: *log_statement(l_api_name, 'build_sql_no_serial',
1507: * 'Calling inv_detail_util_pvt.build_sql for base');
1508: *inv_detail_util_pvt.build_sql
1509: *( x_return_status => l_return_status ,
1510: * x_sql_statement => g_pick_base
1511: * );

Line 1508: *inv_detail_util_pvt.build_sql

1504: *aren't allocating LPNs
1505: *--build non-serial controlled pick base
1506: *log_statement(l_api_name, 'build_sql_no_serial',
1507: * 'Calling inv_detail_util_pvt.build_sql for base');
1508: *inv_detail_util_pvt.build_sql
1509: *( x_return_status => l_return_status ,
1510: * x_sql_statement => g_pick_base
1511: * );
1512: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

1510: * x_sql_statement => g_pick_base
1511: * );
1512: *IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1513: * log_statement(l_api_name, 'err_build_sql',
1514: * 'Error in inv_detail_util_pvt.build_sql');
1515: * RAISE fnd_api.g_exc_unexpected_error;
1516: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1517: * log_statement(l_api_name, 'unexp_err_build_sql',
1518: * 'Unexp. error in inv_detail_util_pvt.build_sql');

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

1514: * 'Error in inv_detail_util_pvt.build_sql');
1515: * RAISE fnd_api.g_exc_unexpected_error;
1516: *ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1517: * log_statement(l_api_name, 'unexp_err_build_sql',
1518: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1519: * RAISE fnd_api.g_exc_error;
1520: *END IF;
1521: *log_statement(l_api_name, 'success_build_sql',
1522: * 'Inv_detail_util_pvt.build_sql successful');

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

1518: * 'Unexp. error in inv_detail_util_pvt.build_sql');
1519: * RAISE fnd_api.g_exc_error;
1520: *END IF;
1521: *log_statement(l_api_name, 'success_build_sql',
1522: * 'Inv_detail_util_pvt.build_sql successful');
1523:
1524: *-- replace the bind variables used in the base sql
1525: *-- with the global variables in the stored rule procedure
1526: *g_pick_base :=

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

1610: || ' AND sub.organization_id = x.organization_id '
1611: || g_line_feed
1612: || ' AND sub.secondary_inventory_name = x.subinventory_code '
1613: || g_line_feed; /*
1614: || ' AND inv_detail_util_pvt.is_sub_loc_lot_trx_allowed('
1615: || g_line_feed
1616: || ' g_transaction_type_id, '
1617: || g_line_feed
1618: || ' x.organization_id, '

Line 5983: inv_detail_util_pvt.search_serial_numbers(

5979: IF l_debug = 1 THEN
5980: log_statement(l_api_name, 'search_sn', 'Calling Search Serial Numbers');
5981: END IF;
5982:
5983: inv_detail_util_pvt.search_serial_numbers(
5984: p_organization_id => p_organization_id
5985: , p_inventory_item_id => p_inventory_item_id
5986: , p_serial_number => g_locs(p_record_id).serial_number
5987: , x_found => l_found

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

6177: -- can use it.
6178: IF (g_locs(p_record_id).serial_number IS NOT NULL
6179: AND g_locs(p_record_id).serial_number <> FND_API.G_MISS_CHAR)
6180: THEN
6181: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);
6182:
6183: IF l_found = FALSE THEN
6184: IF l_debug = 1 THEN
6185: log_statement(l_api_name, 'lock_sn', 'Could not lock Serial Number. Exiting.');

Line 6201: inv_detail_util_pvt.add_serial_number(

6197: RETURN;
6198: END IF;
6199:
6200: -- add serial number to pl/sql table of detailed serials
6201: inv_detail_util_pvt.add_serial_number(
6202: p_inventory_item_id
6203: , p_organization_id
6204: , g_locs(p_record_id).serial_number
6205: , l_serial_index

Line 6900: inv_detail_util_pvt.search_serial_numbers(

6896: IF l_debug = 1 THEN
6897: log_statement(l_api_name, 'search_sn', 'Calling Search Serial Numbers');
6898: END IF;
6899:
6900: inv_detail_util_pvt.search_serial_numbers(
6901: p_organization_id => p_organization_id
6902: , p_inventory_item_id => p_inventory_item_id
6903: , p_serial_number => g_locs(p_record_id).serial_number
6904: , x_found => l_found

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

7008:
7009: --Lock Serial number, so that no other detailing process
7010: -- can use it.
7011: IF g_locs(p_record_id).serial_number IS NOT NULL THEN
7012: l_found := inv_detail_util_pvt.lock_serial_number(p_inventory_item_id, g_locs(p_record_id).serial_number);
7013:
7014: IF l_found = FALSE THEN
7015: IF l_debug = 1 THEN
7016: log_statement(l_api_name, 'lock_sn', 'Could not lock Serial Number. Exiting.');

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

7026: RETURN;
7027: END IF;
7028:
7029: -- add serial number to pl/sql table of detailed serials
7030: inv_detail_util_pvt.add_serial_number(p_inventory_item_id, p_organization_id, g_locs(p_record_id).serial_number, l_serial_index);
7031: END IF;
7032:
7033: --If quantity remaining to allocate is greater than 0, update the
7034: --quantity tree and insert the record into WTT

Line 8665: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;

8661:
8662: l_return_value BOOLEAN; -- [ Added ]
8663: ---
8664: l_allocate_serial_flag VARCHAR2(1);
8665: l_custom_select_serials INV_DETAIL_UTIL_PVT.g_serial_row_table_rec;
8666: l_custom_serial_index NUMBER;
8667:
8668: -- Lot Indivisible Var
8669: l_max_tolerance NUMBER;

Line 9367: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

9363: WHERE inventory_item_id = p_inventory_item_id
9364: AND current_organization_id = p_organization_id
9365: AND serial_number = l_serial_number;
9366:
9367: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
9368: p_transaction_type_id
9369: ,p_organization_id
9370: ,p_inventory_item_id
9371: ,l_serial_status_id) ;

Line 9400: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

9396: log_statement(l_api_name, 'before calling trx_allowed: ', l_sub_loc_lot_trx_allowed);
9397: END IF;
9398:
9399: l_onhand_status_trx_allowed := 'N';
9400: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
9401: p_transaction_type_id
9402: ,p_organization_id
9403: ,p_inventory_item_id
9404: ,l_subinventory_code

Line 9414: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

9410: END IF;
9411: ELSE -- IF l_default_status_id = -1 THEN
9412: l_sub_loc_lot_trx_allowed:='N';
9413: IF (inv_cache.item_rec.serial_number_control_code in (1,6)) THEN
9414: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
9415: p_transaction_type_id
9416: ,p_organization_id
9417: ,p_inventory_item_id
9418: ,l_subinventory_code

Line 9804: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

9800: WHERE inventory_item_id = p_inventory_item_id
9801: AND current_organization_id = p_organization_id
9802: AND serial_number = v_current_row.serial_number;
9803:
9804: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
9805: p_transaction_type_id
9806: ,p_organization_id
9807: ,p_inventory_item_id
9808: ,l_serial_status_id) ;

Line 9831: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

9827: log_statement(l_api_name, 'before calling trx_allowed: ', l_sub_loc_lot_trx_allowed);
9828: END IF;
9829:
9830: l_onhand_status_trx_allowed := 'N';
9831: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
9832: p_transaction_type_id
9833: ,p_organization_id
9834: ,p_inventory_item_id
9835: ,v_current_row.subinventory_code

Line 9845: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

9841: END IF;
9842: ELSE -- IF l_default_status_id = -1 THEN
9843: l_sub_loc_lot_trx_allowed:='N';
9844: IF (inv_cache.item_rec.serial_number_control_code in (1,6)) THEN
9845: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
9846: p_transaction_type_id
9847: ,p_organization_id
9848: ,p_inventory_item_id
9849: ,v_current_row.subinventory_code

Line 11313: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

11309: WHERE inventory_item_id = p_inventory_item_id
11310: AND current_organization_id = p_organization_id
11311: AND serial_number = v_current_row.serial_number;
11312:
11313: l_serial_trx_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
11314: p_transaction_type_id
11315: ,p_organization_id
11316: ,p_inventory_item_id
11317: ,l_serial_status_id) ;

Line 11334: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

11330: -- LPN Status Project
11331: l_onhand_status_trx_allowed := 'Y';
11332: IF l_default_status_id = -1 THEN
11333: l_onhand_status_trx_allowed := 'N';
11334: l_sub_loc_lot_trx_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
11335: p_transaction_type_id
11336: ,p_organization_id
11337: ,p_inventory_item_id
11338: ,v_current_row.subinventory_code

Line 11348: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

11344: END IF;
11345: ELSE
11346: l_sub_loc_lot_trx_allowed:='N';
11347: IF (inv_cache.item_rec.serial_number_control_code IN (1,6)) THEN
11348: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
11349: p_transaction_type_id
11350: ,p_organization_id
11351: ,p_inventory_item_id
11352: ,v_current_row.subinventory_code

Line 12766: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

12762:
12763: --Bug Number :3457530(cheking for a transaction_type_id)
12764:
12765: IF ( p_transaction_type_id <> 64) THEN
12766: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
12767: p_transaction_type_id => p_transaction_type_id
12768: , p_organization_id => p_organization_id
12769: , p_inventory_item_id => p_inventory_item_id
12770: , p_subinventory_code => l_osubinventory_code

Line 13181: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN --{

13177: inv_log_util.trace('Serial not found', 'delete_serial_numbers', 9);
13178: END IF;
13179: EXIT;
13180: ELSE --{
13181: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0) THEN --{
13182: IF l_debug = 1 THEN
13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);

Line 13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '

13182: IF l_debug = 1 THEN
13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;
13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{

Line 13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

13183: inv_log_util.trace('Org: ' || p_organization_id, 'delete_serial_numbers', 9);
13184: inv_log_util.trace('Item: ' || p_inventory_item_id, 'delete_serial_numbers', 9);
13185: inv_log_util.trace('Serial: ' || l_serial_number, 'delete_serial_numbers', 9);
13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;
13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{
13191: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)

Line 13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{

13186: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;
13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{
13191: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13192: AND (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id)
13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{

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

13187: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13188: END IF;
13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{
13191: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13192: AND (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id)
13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN

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

13188: END IF;
13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{
13191: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13192: AND (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id)
13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=

Line 13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)

13189:
13190: FOR i IN 1..inv_detail_util_pvt.g_serial_tbl_ptr LOOP --{
13191: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13192: AND (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id)
13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;

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

13191: IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13192: AND (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id)
13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;

Line 13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=

13192: AND (inv_detail_util_pvt.g_output_serial_rows(i).organization_id = p_organization_id)
13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=

Line 13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;

13193: AND (inv_detail_util_pvt.g_output_serial_rows(i).serial_number = l_serial_number)
13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;

Line 13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=

13194: THEN --{
13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
13202:

Line 13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;

13195: IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1) THEN
13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
13202:
13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);

Line 13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=

13196: inv_detail_util_pvt.g_output_serial_rows(i).organization_id :=
13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
13202:
13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;

Line 13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;

13197: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).organization_id;
13198: inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id :=
13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
13202:
13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13205:

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

13199: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).inventory_item_id;
13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
13202:
13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13205:
13206: IF l_debug = 1 THEN
13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '

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

13200: inv_detail_util_pvt.g_output_serial_rows(i).serial_number :=
13201: inv_detail_util_pvt.g_output_serial_rows(inv_detail_util_pvt.g_serial_tbl_ptr).serial_number;
13202:
13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13205:
13206: IF l_debug = 1 THEN
13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13208: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

Line 13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '

13203: inv_detail_util_pvt.g_output_serial_rows.DELETE(inv_detail_util_pvt.g_serial_tbl_ptr);
13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13205:
13206: IF l_debug = 1 THEN
13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13208: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13209: END IF;
13210:
13211: ELSE

Line 13208: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);

13204: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13205:
13206: IF l_debug = 1 THEN
13207: inv_log_util.trace('inv_detail_util_pvt.g_serial_tbl_ptr '
13208: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13209: END IF;
13210:
13211: ELSE
13212: inv_detail_util_pvt.g_output_serial_rows.DELETE;

Line 13212: inv_detail_util_pvt.g_output_serial_rows.DELETE;

13208: || inv_detail_util_pvt.g_serial_tbl_ptr, 'delete_serial_numbers', 9);
13209: END IF;
13210:
13211: ELSE
13212: inv_detail_util_pvt.g_output_serial_rows.DELETE;
13213: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13214:
13215: IF l_debug = 1 THEN
13216: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);

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

13209: END IF;
13210:
13211: ELSE
13212: inv_detail_util_pvt.g_output_serial_rows.DELETE;
13213: inv_detail_util_pvt.g_serial_tbl_ptr := inv_detail_util_pvt.g_serial_tbl_ptr-1;
13214:
13215: IF l_debug = 1 THEN
13216: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
13217: END IF;

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

13215: IF l_debug = 1 THEN
13216: inv_log_util.trace('Array cleared', 'delete_serial_numbers', 9);
13217: END IF;
13218:
13219: END IF; -- End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
13220:
13221: EXIT; -- if a serial has been deleted, needn't check other serials present in g_output_serial_rows
13222: END IF; --} End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13223: END LOOP; --} End of FOR loop

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

13218:
13219: END IF; -- End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 1)
13220:
13221: EXIT; -- if a serial has been deleted, needn't check other serials present in g_output_serial_rows
13222: END IF; --} End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13223: END LOOP; --} End of FOR loop
13224: END IF; --} End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0)
13225: END IF; --} End of IF l_get_serial%NOTFOUND
13226: END LOOP; --} End of LOOP for CURSOR

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

13220:
13221: EXIT; -- if a serial has been deleted, needn't check other serials present in g_output_serial_rows
13222: END IF; --} End of IF (inv_detail_util_pvt.g_output_serial_rows(i).inventory_item_id = p_inventory_item_id)
13223: END LOOP; --} End of FOR loop
13224: END IF; --} End of IF (inv_detail_util_pvt.g_serial_tbl_ptr > 0)
13225: END IF; --} End of IF l_get_serial%NOTFOUND
13226: END LOOP; --} End of LOOP for CURSOR
13227:
13228: CLOSE l_get_serial;

Line 14344: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

14340: g_st_locator_id = l_olocator_id THEN
14341: l_allowed := g_allowed;
14342: ELSE
14343:
14344: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
14345: p_transaction_type_id => p_transaction_type_id
14346: ,p_organization_id => p_organization_id
14347: ,p_inventory_item_id => p_inventory_item_id
14348: ,p_subinventory_code => l_osubinventory_code

Line 17990: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(

17986: IF l_default_status_id = -1 THEN
17987: l_onhand_status_trx_allowed:='N';
17988:
17989: -- Get sub/Locator /Lot / serial status allowed --
17990: l_allowed := inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(
17991: p_transaction_type_id => p_transaction_type_id
17992: , p_organization_id => p_organization_id
17993: , p_inventory_item_id => p_inventory_item_id
17994: , p_subinventory_code => l_from_subinventory_code

Line 18011: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(

18007:
18008: ELSE
18009: l_allowed:='N';
18010: if (inv_cache.item_rec.serial_number_control_code in (1,6)) then
18011: l_onhand_status_trx_allowed := inv_detail_util_pvt.is_onhand_status_trx_allowed(
18012: p_transaction_type_id
18013: ,p_organization_id
18014: ,p_inventory_item_id
18015: ,l_from_subinventory_code

Line 18044: 'Calling inv_detail_util_pvt.is_serial_trx_allowed');

18040: IF l_debug = 1 THEN
18041: log_statement(l_api_name, 'Quick Pick',
18042: 'inside If l_serial_status_enabled = y ') ;
18043: log_statement(l_api_name, 'Quick Pick',
18044: 'Calling inv_detail_util_pvt.is_serial_trx_allowed');
18045: END IF;
18046: --bug 7171840 changed the code to check the status at serial level rather than item defualt status
18047: FOR L_LPN_CUR IN lpn_serial_cur(l_lpn_id) LOOP
18048: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

Line 18048: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

18044: 'Calling inv_detail_util_pvt.is_serial_trx_allowed');
18045: END IF;
18046: --bug 7171840 changed the code to check the status at serial level rather than item defualt status
18047: FOR L_LPN_CUR IN lpn_serial_cur(l_lpn_id) LOOP
18048: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
18049: p_transaction_type_id => p_transaction_type_id
18050: ,p_organization_id => p_organization_id
18051: ,p_inventory_item_id => p_inventory_item_id
18052: ,p_serial_status => L_LPN_CUR.STATUS_ID ) ;

Line 18062: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(

18058: END IF;
18059: L_SERIAL_ALLOWED := 'Y';
18060: END LOOP ;
18061: /* commented out for bug 7171840
18062: l_serial_allowed := inv_detail_util_pvt.is_serial_trx_allowed(
18063: p_transaction_type_id => p_transaction_type_id
18064: ,p_organization_id => p_organization_id
18065: ,p_inventory_item_id => p_inventory_item_id
18066: ,p_serial_status => l_default_serial_status_id ) ;