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 FND_GLOBAL

Line 280: l_userid := fnd_global.user_id;

276: SELECT mtl_gen_object_id_s.NEXTVAL
277: INTO x_object_id
278: FROM DUAL;
279:
280: l_userid := fnd_global.user_id;
281: l_loginid := fnd_global.login_id;
282: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);
283:
284: IF (isunique = 0) THEN

Line 281: l_loginid := fnd_global.login_id;

277: INTO x_object_id
278: FROM DUAL;
279:
280: l_userid := fnd_global.user_id;
281: l_loginid := fnd_global.login_id;
282: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);
283:
284: IF (isunique = 0) THEN
285: INSERT INTO mtl_serial_numbers

Line 652: l_userid := fnd_global.user_id;

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;
654:
655: -- invtrace('transaction_action_id is ' || p_transaction_action_id);
656: IF (p_transaction_action_id = 3

Line 653: l_loginid := fnd_global.login_id;

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;
654:
655: -- invtrace('transaction_action_id is ' || p_transaction_action_id);
656: IF (p_transaction_action_id = 3
657: AND g_firstscan = FALSE) THEN

Line 1504: l_userid := fnd_global.user_id;

1500: ELSE
1501: l_cur_serial_number := SUBSTR(p_fm_serial_number, 1, LENGTH(p_fm_serial_number) - LENGTH(l_cur_ser_number))
1502: || l_cur_ser_number;
1503: END IF;
1504: l_userid := fnd_global.user_id;
1505: l_loginid := fnd_global.login_id;
1506: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, l_cur_serial_number, x_msg_data);
1507: IF (isunique = 0) THEN
1508: SELECT mtl_gen_object_id_s.NEXTVAL

Line 1505: l_loginid := fnd_global.login_id;

1501: l_cur_serial_number := SUBSTR(p_fm_serial_number, 1, LENGTH(p_fm_serial_number) - LENGTH(l_cur_ser_number))
1502: || l_cur_ser_number;
1503: END IF;
1504: l_userid := fnd_global.user_id;
1505: l_loginid := fnd_global.login_id;
1506: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, l_cur_serial_number, x_msg_data);
1507: IF (isunique = 0) THEN
1508: SELECT mtl_gen_object_id_s.NEXTVAL
1509: INTO x_object_id

Line 1720: , last_updated_by = fnd_global.user_id -- 13564609

1716: SET current_status = p_current_status
1717: , inspection_status = p_inspection_status
1718: , lpn_id = null --bug 5152103
1719: , current_organization_id = p_organization_id
1720: , last_updated_by = fnd_global.user_id -- 13564609
1721: , last_update_date = sysdate -- 13564609
1722: , previous_status = l_current_status -- 13564609
1723: WHERE serial_number = l_cur_serial_number
1724: AND inventory_item_id = p_inventory_item_id;

Line 1731: , last_updated_by = fnd_global.user_id -- 13564609

1727: UPDATE mtl_serial_numbers
1728: SET current_status = p_current_status
1729: , inspection_status = p_inspection_status
1730: -- , lpn_id = decode(p_current_status,1,decode(current_status,4,null,lpn_id),lpn_id) --bug 5152103
1731: , last_updated_by = fnd_global.user_id -- 13564609
1732: , last_update_date = sysdate -- 13564609
1733: , previous_status = l_current_status -- 13564609
1734: WHERE serial_number = l_cur_serial_number
1735: AND inventory_item_id = p_inventory_item_id;

Line 2040: l_userid := fnd_global.user_id;

2036: inv_cost_group_pub.g_cost_group_id || ',lastStat=' ||
2037: p_last_status || 'p_wip_entity_id = ' || p_wip_entity_id ||
2038: 'SerialNumber = ' || p_serial_number);
2039: END IF;
2040: l_userid := fnd_global.user_id;
2041: l_loginid := fnd_global.login_id;
2042:
2043: -- Get serial-attributes only if the last-state of serialNumber
2044: -- is 'Defined But Not Used' (1) or 'Dynamically generated' (6)

Line 2041: l_loginid := fnd_global.login_id;

2037: p_last_status || 'p_wip_entity_id = ' || p_wip_entity_id ||
2038: 'SerialNumber = ' || p_serial_number);
2039: END IF;
2040: l_userid := fnd_global.user_id;
2041: l_loginid := fnd_global.login_id;
2042:
2043: -- Get serial-attributes only if the last-state of serialNumber
2044: -- is 'Defined But Not Used' (1) or 'Dynamically generated' (6)
2045: IF p_wip_entity_id IS NOT NULL THEN

Line 2638: l_userid := fnd_global.user_id;

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;
2641:
2642: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN

Line 2639: l_loginid := fnd_global.login_id;

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;
2641:
2642: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
2643: INSERT INTO mtl_unit_transactions

Line 5464: l_userid := fnd_global.user_id;

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;
5467:
5468: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN

Line 5465: l_loginid := fnd_global.login_id;

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;
5467:
5468: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
5469: IF (l_debug = 1) THEN

Line 6634: l_userid NUMBER := fnd_global.user_id;

6630: p_to_template_id IN NUMBER DEFAULT NULL,
6631: x_return_status OUT NOCOPY VARCHAR2)
6632: IS
6633: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6634: l_userid NUMBER := fnd_global.user_id;
6635: l_loginid NUMBER := fnd_global.login_id;
6636: BEGIN
6637:
6638: x_return_status := fnd_api.g_ret_sts_success;

Line 6635: l_loginid NUMBER := fnd_global.login_id;

6631: x_return_status OUT NOCOPY VARCHAR2)
6632: IS
6633: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6634: l_userid NUMBER := fnd_global.user_id;
6635: l_loginid NUMBER := fnd_global.login_id;
6636: BEGIN
6637:
6638: x_return_status := fnd_api.g_ret_sts_success;
6639: