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_SERIAL_NUMBER_PUB dependencies on WMS_INSTALL

Line 392: l_wms_installed BOOLEAN;

388: l_lot_status_enabled VARCHAR2(1);
389: l_default_lot_status_id NUMBER := NULL;
390: l_serial_status_enabled VARCHAR2(1);
391: l_default_serial_status_id NUMBER;
392: l_wms_installed BOOLEAN;
393:
394: CURSOR serial_temp_csr(p_transaction_temp_id NUMBER) IS
395: SELECT serial_attribute_category
396: , fnd_date.date_to_canonical(origination_date)

Line 496: l_wms_installed :=

492: INTO x_object_id
493: FROM DUAL;
494:
495: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
496: l_wms_installed :=
497: wms_install.check_install(
498: x_return_status => l_return_status
499: , x_msg_count => l_msg_count
500: , x_msg_data => l_msg_data

Line 497: wms_install.check_install(

493: FROM DUAL;
494:
495: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
496: l_wms_installed :=
497: wms_install.check_install(
498: x_return_status => l_return_status
499: , x_msg_count => l_msg_count
500: , x_msg_data => l_msg_data
501: , p_organization_id => NULL --p_organization_id

Line 508: -- invtrace('wms is installed?' || l_wms_installed);

504: -- Moved this line before the if statement so that this code is
505: -- called for the else part of the if statement too.
506: populateattributescolumn();
507:
508: -- invtrace('wms is installed?' || l_wms_installed);
509: IF (p_transaction_temp_id IS NOT NULL) THEN
510: -- invtrace('transaction_temp_id is not null. It is ' || p_transaction_temp_id);
511: OPEN serial_temp_csr(p_transaction_temp_id);
512:

Line 562: IF l_wms_installed THEN

558: , g_serial_attributes_tbl(44).column_value;
559:
560: CLOSE serial_temp_csr;
561:
562: IF l_wms_installed THEN
563: -- invtrace('wms is installed ');
564: l_input_idx := 0;
565:
566: FOR x IN 1 .. 44 LOOP

Line 578: END IF; -- if wms installed is true

574: l_attributes_in(l_input_idx).column_value := g_serial_attributes_tbl(x).column_value;
575: -- invtrace('l_attributes_in(l_input_idx).column_value is ' || l_attributes_in(l_input_idx).column_value);
576: END IF;
577: END LOOP;
578: END IF; -- if wms installed is true
579: END IF; -- if transaction_Temp_id is not null
580:
581: ----------------------------------------------------------
582: -- call inv_lot_sel_attr.get_default to get the default value

Line 586: IF l_wms_installed THEN

582: -- call inv_lot_sel_attr.get_default to get the default value
583: -- of the lot attributes
584: ---------------------------------------------------------
585: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
586: IF l_wms_installed THEN
587: inv_lot_sel_attr.get_default(
588: x_attributes_default => l_attributes_default
589: , x_attributes_default_count => l_attributes_default_count
590: , x_return_status => l_return_status

Line 615: END IF; -- end if of wms install is true

611: END IF;
612: END LOOP;
613: END LOOP;
614: END IF;
615: END IF; -- end if of wms install is true
616:
617: --END IF; -- delete this since we don't need the if condition to set the l_return_status
618: l_userid := fnd_global.user_id;
619: l_loginid := fnd_global.login_id;

Line 867: IF (l_wms_installed) THEN

863: AND inventory_item_id = p_inventory_item_id;
864: -- invtrace('l_status_id from MSN when serial_number = ' || p_serial_number || ' current_organization_id = ' || p_organization_id || 'inventory_item_id = ' || p_inventory_item_id);
865: ELSE
866: /** Populate Serial Attribute Category info. **/
867: IF (l_wms_installed) THEN
868: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');
869: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
870: , 'Serial Attributes');
871: ELSE

Line 1626: l_wms_installed BOOLEAN;

1622: l_n_attribute8 NUMBER;
1623: l_n_attribute9 NUMBER;
1624: l_n_attribute10 NUMBER;
1625: l_territory_code VARCHAR2(150);
1626: l_wms_installed BOOLEAN;
1627: l_return_status VARCHAR2(1);
1628: l_msg_data VARCHAR2(2000);
1629: l_msg_count NUMBER;
1630: l_group_mark_id NUMBER;

Line 1722: l_wms_installed :=

1718: END IF;
1719:
1720: IF (p_last_status = 1)
1721: OR(p_last_status = 6) THEN
1722: l_wms_installed :=
1723: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
1724: , p_organization_id => p_organization_id);
1725:
1726: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN

Line 1723: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data

1719:
1720: IF (p_last_status = 1)
1721: OR(p_last_status = 6) THEN
1722: l_wms_installed :=
1723: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
1724: , p_organization_id => p_organization_id);
1725:
1726: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN
1727: -- invtrace('wms is installed... opening l_serial_attr_csr with serial_temp_id as '|| p_serial_temp_id);

Line 1726: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN

1722: l_wms_installed :=
1723: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
1724: , p_organization_id => p_organization_id);
1725:
1726: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN
1727: -- invtrace('wms is installed... opening l_serial_attr_csr with serial_temp_id as '|| p_serial_temp_id);
1728: OPEN l_serial_attr_csr(p_serial_temp_id);
1729:
1730: FETCH l_serial_attr_csr

Line 1970: END IF; -- !wms_installed OR p_serial_temp_id is NULL. --Bug4535887

1966: , intraoperation_step_type = p_intraoperation_step_type
1967: WHERE inventory_item_id = p_inventory_item_id
1968: AND serial_number = p_serial_number
1969: AND DECODE(current_status, 6, 1, current_status) = DECODE(p_last_status, 6, 1, p_last_status);
1970: END IF; -- !wms_installed OR p_serial_temp_id is NULL. --Bug4535887
1971: ELSE
1972: -- invtrace('last status is neither 1 nor 6');
1973: -- invtrace('updating MSN WITH values ');
1974: -- invtrace('current_status ' || p_current_status);

Line 2094: l_wms_installed BOOLEAN;

2090: l_column_idx BINARY_INTEGER := 44;
2091: l_return_status VARCHAR2(1);
2092: l_msg_data VARCHAR2(2000);
2093: l_msg_count NUMBER;
2094: l_wms_installed BOOLEAN;
2095:
2096: l_sys_date date := NULL;
2097: l_date2 date := NULL;
2098: l_date23 date := NULL;

Line 2192: l_wms_installed :=

2188: /**IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
2189: x_return_status := fnd_api.g_ret_sts_success;
2190: ELSE**/
2191: x_return_status := fnd_api.g_ret_sts_success;
2192: l_wms_installed :=
2193: wms_install.check_install(
2194: x_return_status => l_return_status
2195: , x_msg_count => l_msg_count
2196: , x_msg_data => l_msg_data

Line 2193: wms_install.check_install(

2189: x_return_status := fnd_api.g_ret_sts_success;
2190: ELSE**/
2191: x_return_status := fnd_api.g_ret_sts_success;
2192: l_wms_installed :=
2193: wms_install.check_install(
2194: x_return_status => l_return_status
2195: , x_msg_count => l_msg_count
2196: , x_msg_data => l_msg_data
2197: , p_organization_id => NULL --p_organization_id

Line 2255: IF l_wms_installed THEN

2251: CLOSE serial_temp_csr;
2252:
2253: l_input_idx := 0;
2254:
2255: IF l_wms_installed THEN
2256: FOR x IN 1 .. 44 LOOP
2257: IF (g_serial_attributes_tbl(x).column_value IS NOT NULL) THEN
2258: l_input_idx := l_input_idx + 1;
2259: l_attributes_in(l_input_idx).column_name := g_serial_attributes_tbl(x).column_name;

Line 2264: END IF; -- if wms_installed is true

2260: l_attributes_in(l_input_idx).column_type := g_serial_attributes_tbl(x).column_type;
2261: l_attributes_in(l_input_idx).column_value := g_serial_attributes_tbl(x).column_value;
2262: END IF;
2263: END LOOP;
2264: END IF; -- if wms_installed is true
2265: END IF; -- if transaction_temp_id is not null
2266:
2267: ----------------------------------------------------------
2268: -- call inv_lot_sel_attr.get_default to get the default value

Line 2271: IF l_wms_installed THEN

2267: ----------------------------------------------------------
2268: -- call inv_lot_sel_attr.get_default to get the default value
2269: -- of the lot attributes
2270: ---------------------------------------------------------
2271: IF l_wms_installed THEN
2272: inv_lot_sel_attr.get_default(
2273: x_attributes_default => l_attributes_default
2274: , x_attributes_default_count => l_attributes_default_count
2275: , x_return_status => l_return_status

Line 2305: END IF; -- if wms install is true

2301: END IF;
2302: END LOOP;
2303: END LOOP;
2304: END IF;
2305: END IF; -- if wms install is true
2306:
2307: l_userid := fnd_global.user_id;
2308: l_loginid := fnd_global.login_id;
2309: l_sys_date := SYSDATE;

Line 2484: IF l_wms_installed THEN

2480: -- where sn.serial_number = p_serial_number
2481: -- and sn.current_organization_id = p_organization_id
2482: -- and sn.inventory_item_id = p_inventory_item_id);
2483: ELSE
2484: IF l_wms_installed THEN
2485: /** 2756040 - Populate Serial Attribute Category info when it is not
2486: ** a receiving transaction **/
2487: IF ((g_serial_attributes_tbl(1).column_value = NULL)
2488: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN

Line 4901: l_wms_installed BOOLEAN;

4897: l_input_idx BINARY_INTEGER;
4898:
4899: l_fm_serial_number VARCHAR2(30) := lpad(p_fm_serial_number, 30);
4900: l_to_serial_number VARCHAR2(30) := lpad(p_to_serial_number, 30);
4901: l_wms_installed BOOLEAN;
4902: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4903: BEGIN
4904: IF (l_debug = 1) THEN
4905: invtrace('Inside InsertRangeUnitTrx');

Line 4955: l_wms_installed :=

4951: /**IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
4952: x_return_status := fnd_api.g_ret_sts_success;
4953: ELSE**/
4954: x_return_status := fnd_api.g_ret_sts_success;
4955: l_wms_installed :=
4956: wms_install.check_install(
4957: x_return_status => l_return_status
4958: , x_msg_count => l_msg_count
4959: , x_msg_data => l_msg_data

Line 4956: wms_install.check_install(

4952: x_return_status := fnd_api.g_ret_sts_success;
4953: ELSE**/
4954: x_return_status := fnd_api.g_ret_sts_success;
4955: l_wms_installed :=
4956: wms_install.check_install(
4957: x_return_status => l_return_status
4958: , x_msg_count => l_msg_count
4959: , x_msg_data => l_msg_data
4960: , p_organization_id => NULL --p_organization_id

Line 5025: IF l_wms_installed THEN

5021: CLOSE serial_temp_csr;
5022:
5023: l_input_idx := 0;
5024:
5025: IF l_wms_installed THEN
5026: FOR x IN 1 .. 44 LOOP
5027: IF (g_serial_attributes_tbl(x).column_value IS NOT NULL) THEN
5028: l_input_idx := l_input_idx + 1;
5029: l_attributes_in(l_input_idx).column_name := g_serial_attributes_tbl(x).column_name;

Line 5034: END IF; -- if wms_installed is true

5030: l_attributes_in(l_input_idx).column_type := g_serial_attributes_tbl(x).column_type;
5031: l_attributes_in(l_input_idx).column_value := g_serial_attributes_tbl(x).column_value;
5032: END IF;
5033: END LOOP;
5034: END IF; -- if wms_installed is true
5035: END IF; -- if transaction_temp_id is not null
5036:
5037: ----------------------------------------------------------
5038: -- call inv_lot_sel_attr.get_default to get the default value

Line 5041: IF l_wms_installed THEN

5037: ----------------------------------------------------------
5038: -- call inv_lot_sel_attr.get_default to get the default value
5039: -- of the lot attributes
5040: ---------------------------------------------------------
5041: IF l_wms_installed THEN
5042: inv_lot_sel_attr.get_default(
5043: x_attributes_default => l_attributes_default
5044: , x_attributes_default_count => l_attributes_default_count
5045: , x_return_status => l_return_status

Line 5075: END IF; -- if wms install is true

5071: END IF;
5072: END LOOP;
5073: END LOOP;
5074: END IF;
5075: END IF; -- if wms install is true
5076:
5077: l_userid := fnd_global.user_id;
5078: l_loginid := fnd_global.login_id;
5079: l_sys_date := SYSDATE;

Line 5260: IF l_wms_installed THEN

5256: ELSE
5257: IF (l_debug = 1) THEN
5258: invtrace('not org transfer');
5259: END IF;
5260: IF l_wms_installed THEN
5261: /** 2756040 - Populate Serial Attribute Category info when it is not
5262: ** a receiving transaction **/
5263: IF ((g_serial_attributes_tbl(1).column_value = NULL)
5264: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN