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 425: l_wms_installed BOOLEAN;

421: l_lot_status_enabled VARCHAR2(1);
422: l_default_lot_status_id NUMBER := NULL;
423: l_serial_status_enabled VARCHAR2(1);
424: l_default_serial_status_id NUMBER;
425: l_wms_installed BOOLEAN;
426:
427: CURSOR serial_temp_csr(p_transaction_temp_id NUMBER) IS
428: SELECT serial_attribute_category
429: , fnd_date.date_to_canonical(origination_date)

Line 530: l_wms_installed :=

526: INTO x_object_id
527: FROM DUAL;
528:
529: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
530: l_wms_installed :=
531: wms_install.check_install(
532: x_return_status => l_return_status
533: , x_msg_count => l_msg_count
534: , x_msg_data => l_msg_data

Line 531: wms_install.check_install(

527: FROM DUAL;
528:
529: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
530: l_wms_installed :=
531: wms_install.check_install(
532: x_return_status => l_return_status
533: , x_msg_count => l_msg_count
534: , x_msg_data => l_msg_data
535: , p_organization_id => NULL --p_organization_id

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

538: -- Moved this line before the if statement so that this code is
539: -- called for the else part of the if statement too.
540: populateattributescolumn();
541:
542: -- invtrace('wms is installed?' || l_wms_installed);
543: IF (p_transaction_temp_id IS NOT NULL) THEN
544: -- invtrace('transaction_temp_id is not null. It is ' || p_transaction_temp_id);
545: OPEN serial_temp_csr(p_transaction_temp_id);
546:

Line 596: IF l_wms_installed THEN

592: , g_serial_attributes_tbl(44).column_value;
593:
594: CLOSE serial_temp_csr;
595:
596: IF l_wms_installed THEN
597: -- invtrace('wms is installed ');
598: l_input_idx := 0;
599:
600: FOR x IN 1 .. 44 LOOP

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

608: l_attributes_in(l_input_idx).column_value := g_serial_attributes_tbl(x).column_value;
609: -- invtrace('l_attributes_in(l_input_idx).column_value is ' || l_attributes_in(l_input_idx).column_value);
610: END IF;
611: END LOOP;
612: END IF; -- if wms installed is true
613: END IF; -- if transaction_Temp_id is not null
614:
615: ----------------------------------------------------------
616: -- call inv_lot_sel_attr.get_default to get the default value

Line 620: IF l_wms_installed THEN

616: -- call inv_lot_sel_attr.get_default to get the default value
617: -- of the lot attributes
618: ---------------------------------------------------------
619: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
620: IF l_wms_installed THEN
621: inv_lot_sel_attr.get_default(
622: x_attributes_default => l_attributes_default
623: , x_attributes_default_count => l_attributes_default_count
624: , x_return_status => l_return_status

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

645: END IF;
646: END LOOP;
647: END LOOP;
648: END IF;
649: END IF; -- end if of wms install is true
650:
651: --END IF; -- delete this since we don't need the if condition to set the l_return_status
652: l_userid := fnd_global.user_id;
653: l_loginid := fnd_global.login_id;

Line 901: IF (l_wms_installed) THEN

897: AND inventory_item_id = p_inventory_item_id;
898: -- 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);
899: ELSE
900: /** Populate Serial Attribute Category info. **/
901: IF (l_wms_installed) THEN
902: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');
903: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
904: , 'Serial Attributes');
905: ELSE

Line 1957: l_wms_installed BOOLEAN;

1953: l_n_attribute8 NUMBER;
1954: l_n_attribute9 NUMBER;
1955: l_n_attribute10 NUMBER;
1956: l_territory_code VARCHAR2(150);
1957: l_wms_installed BOOLEAN;
1958: l_return_status VARCHAR2(1);
1959: l_msg_data VARCHAR2(2000);
1960: l_msg_count NUMBER;
1961: l_group_mark_id NUMBER;

Line 2053: l_wms_installed :=

2049: END IF;
2050:
2051: IF (p_last_status = 1)
2052: OR(p_last_status = 6) THEN
2053: l_wms_installed :=
2054: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
2055: , p_organization_id => p_organization_id);
2056:
2057: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN

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

2050:
2051: IF (p_last_status = 1)
2052: OR(p_last_status = 6) THEN
2053: l_wms_installed :=
2054: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
2055: , p_organization_id => p_organization_id);
2056:
2057: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN
2058: -- invtrace('wms is installed... opening l_serial_attr_csr with serial_temp_id as '|| p_serial_temp_id);

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

2053: l_wms_installed :=
2054: wms_install.check_install(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
2055: , p_organization_id => p_organization_id);
2056:
2057: IF (l_wms_installed AND p_serial_temp_id IS NOT NULL) THEN
2058: -- invtrace('wms is installed... opening l_serial_attr_csr with serial_temp_id as '|| p_serial_temp_id);
2059: OPEN l_serial_attr_csr(p_serial_temp_id);
2060:
2061: FETCH l_serial_attr_csr

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

2297: , intraoperation_step_type = p_intraoperation_step_type
2298: WHERE inventory_item_id = p_inventory_item_id
2299: AND serial_number = p_serial_number
2300: AND DECODE(current_status, 6, 1, current_status) = DECODE(p_last_status, 6, 1, p_last_status);
2301: END IF; -- !wms_installed OR p_serial_temp_id is NULL. --Bug4535887
2302: ELSE
2303: -- invtrace('last status is neither 1 nor 6');
2304: -- invtrace('updating MSN WITH values ');
2305: -- invtrace('current_status ' || p_current_status);

Line 2425: l_wms_installed BOOLEAN;

2421: l_column_idx BINARY_INTEGER := 44;
2422: l_return_status VARCHAR2(1);
2423: l_msg_data VARCHAR2(2000);
2424: l_msg_count NUMBER;
2425: l_wms_installed BOOLEAN;
2426:
2427: l_sys_date date := NULL;
2428: l_date2 date := NULL;
2429: l_date23 date := NULL;

Line 2523: l_wms_installed :=

2519: /**IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
2520: x_return_status := fnd_api.g_ret_sts_success;
2521: ELSE**/
2522: x_return_status := fnd_api.g_ret_sts_success;
2523: l_wms_installed :=
2524: wms_install.check_install(
2525: x_return_status => l_return_status
2526: , x_msg_count => l_msg_count
2527: , x_msg_data => l_msg_data

Line 2524: wms_install.check_install(

2520: x_return_status := fnd_api.g_ret_sts_success;
2521: ELSE**/
2522: x_return_status := fnd_api.g_ret_sts_success;
2523: l_wms_installed :=
2524: wms_install.check_install(
2525: x_return_status => l_return_status
2526: , x_msg_count => l_msg_count
2527: , x_msg_data => l_msg_data
2528: , p_organization_id => NULL --p_organization_id

Line 2586: IF l_wms_installed THEN

2582: CLOSE serial_temp_csr;
2583:
2584: l_input_idx := 0;
2585:
2586: IF l_wms_installed THEN
2587: FOR x IN 1 .. 44 LOOP
2588: IF (g_serial_attributes_tbl(x).column_value IS NOT NULL) THEN
2589: l_input_idx := l_input_idx + 1;
2590: l_attributes_in(l_input_idx).column_name := g_serial_attributes_tbl(x).column_name;

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

2591: l_attributes_in(l_input_idx).column_type := g_serial_attributes_tbl(x).column_type;
2592: l_attributes_in(l_input_idx).column_value := g_serial_attributes_tbl(x).column_value;
2593: END IF;
2594: END LOOP;
2595: END IF; -- if wms_installed is true
2596: END IF; -- if transaction_temp_id is not null
2597:
2598: ----------------------------------------------------------
2599: -- call inv_lot_sel_attr.get_default to get the default value

Line 2602: IF l_wms_installed THEN

2598: ----------------------------------------------------------
2599: -- call inv_lot_sel_attr.get_default to get the default value
2600: -- of the lot attributes
2601: ---------------------------------------------------------
2602: IF l_wms_installed THEN
2603: inv_lot_sel_attr.get_default(
2604: x_attributes_default => l_attributes_default
2605: , x_attributes_default_count => l_attributes_default_count
2606: , x_return_status => l_return_status

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

2632: END IF;
2633: END LOOP;
2634: END LOOP;
2635: END IF;
2636: END IF; -- if wms install is true
2637:
2638: l_userid := fnd_global.user_id;
2639: l_loginid := fnd_global.login_id;
2640: l_sys_date := SYSDATE;

Line 2815: IF l_wms_installed THEN

2811: -- where sn.serial_number = p_serial_number
2812: -- and sn.current_organization_id = p_organization_id
2813: -- and sn.inventory_item_id = p_inventory_item_id);
2814: ELSE
2815: IF l_wms_installed THEN
2816: /** 2756040 - Populate Serial Attribute Category info when it is not
2817: ** a receiving transaction **/
2818: IF ((g_serial_attributes_tbl(1).column_value = NULL)
2819: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN

Line 5288: l_wms_installed BOOLEAN;

5284: l_input_idx BINARY_INTEGER;
5285:
5286: l_fm_serial_number VARCHAR2(30) := lpad(p_fm_serial_number, 30);
5287: l_to_serial_number VARCHAR2(30) := lpad(p_to_serial_number, 30);
5288: l_wms_installed BOOLEAN;
5289: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5290: BEGIN
5291: IF (l_debug = 1) THEN
5292: invtrace('Inside InsertRangeUnitTrx');

Line 5342: l_wms_installed :=

5338: /**IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
5339: x_return_status := fnd_api.g_ret_sts_success;
5340: ELSE**/
5341: x_return_status := fnd_api.g_ret_sts_success;
5342: l_wms_installed :=
5343: wms_install.check_install(
5344: x_return_status => l_return_status
5345: , x_msg_count => l_msg_count
5346: , x_msg_data => l_msg_data

Line 5343: wms_install.check_install(

5339: x_return_status := fnd_api.g_ret_sts_success;
5340: ELSE**/
5341: x_return_status := fnd_api.g_ret_sts_success;
5342: l_wms_installed :=
5343: wms_install.check_install(
5344: x_return_status => l_return_status
5345: , x_msg_count => l_msg_count
5346: , x_msg_data => l_msg_data
5347: , p_organization_id => NULL --p_organization_id

Line 5412: IF l_wms_installed THEN

5408: CLOSE serial_temp_csr;
5409:
5410: l_input_idx := 0;
5411:
5412: IF l_wms_installed THEN
5413: FOR x IN 1 .. 44 LOOP
5414: IF (g_serial_attributes_tbl(x).column_value IS NOT NULL) THEN
5415: l_input_idx := l_input_idx + 1;
5416: l_attributes_in(l_input_idx).column_name := g_serial_attributes_tbl(x).column_name;

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

5417: l_attributes_in(l_input_idx).column_type := g_serial_attributes_tbl(x).column_type;
5418: l_attributes_in(l_input_idx).column_value := g_serial_attributes_tbl(x).column_value;
5419: END IF;
5420: END LOOP;
5421: END IF; -- if wms_installed is true
5422: END IF; -- if transaction_temp_id is not null
5423:
5424: ----------------------------------------------------------
5425: -- call inv_lot_sel_attr.get_default to get the default value

Line 5428: IF l_wms_installed THEN

5424: ----------------------------------------------------------
5425: -- call inv_lot_sel_attr.get_default to get the default value
5426: -- of the lot attributes
5427: ---------------------------------------------------------
5428: IF l_wms_installed THEN
5429: inv_lot_sel_attr.get_default(
5430: x_attributes_default => l_attributes_default
5431: , x_attributes_default_count => l_attributes_default_count
5432: , x_return_status => l_return_status

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

5458: END IF;
5459: END LOOP;
5460: END LOOP;
5461: END IF;
5462: END IF; -- if wms install is true
5463:
5464: l_userid := fnd_global.user_id;
5465: l_loginid := fnd_global.login_id;
5466: l_sys_date := SYSDATE;

Line 5647: IF l_wms_installed THEN

5643: ELSE
5644: IF (l_debug = 1) THEN
5645: invtrace('not org transfer');
5646: END IF;
5647: IF l_wms_installed THEN
5648: /** 2756040 - Populate Serial Attribute Category info when it is not
5649: ** a receiving transaction **/
5650: IF ((g_serial_attributes_tbl(1).column_value = NULL)
5651: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN