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.

[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_GLOBAL

Line 247: l_userid := fnd_global.user_id;

243: SELECT mtl_gen_object_id_s.NEXTVAL
244: INTO x_object_id
245: FROM DUAL;
246:
247: l_userid := fnd_global.user_id;
248: l_loginid := fnd_global.login_id;
249: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);
250:
251: IF (isunique = 0) THEN

Line 248: l_loginid := fnd_global.login_id;

244: INTO x_object_id
245: FROM DUAL;
246:
247: l_userid := fnd_global.user_id;
248: l_loginid := fnd_global.login_id;
249: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);
250:
251: IF (isunique = 0) THEN
252: INSERT INTO mtl_serial_numbers

Line 618: l_userid := fnd_global.user_id;

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;
620:
621: -- invtrace('transaction_action_id is ' || p_transaction_action_id);
622: IF (p_transaction_action_id = 3

Line 619: l_loginid := fnd_global.login_id;

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;
620:
621: -- invtrace('transaction_action_id is ' || p_transaction_action_id);
622: IF (p_transaction_action_id = 3
623: AND g_firstscan = FALSE) THEN

Line 1709: l_userid := fnd_global.user_id;

1705: inv_cost_group_pub.g_cost_group_id || ',lastStat=' ||
1706: p_last_status || 'p_wip_entity_id = ' || p_wip_entity_id ||
1707: 'SerialNumber = ' || p_serial_number);
1708: END IF;
1709: l_userid := fnd_global.user_id;
1710: l_loginid := fnd_global.login_id;
1711:
1712: -- Get serial-attributes only if the last-state of serialNumber
1713: -- is 'Defined But Not Used' (1) or 'Dynamically generated' (6)

Line 1710: l_loginid := fnd_global.login_id;

1706: p_last_status || 'p_wip_entity_id = ' || p_wip_entity_id ||
1707: 'SerialNumber = ' || p_serial_number);
1708: END IF;
1709: l_userid := fnd_global.user_id;
1710: l_loginid := fnd_global.login_id;
1711:
1712: -- Get serial-attributes only if the last-state of serialNumber
1713: -- is 'Defined But Not Used' (1) or 'Dynamically generated' (6)
1714: IF p_wip_entity_id IS NOT NULL THEN

Line 2307: l_userid := fnd_global.user_id;

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

Line 2308: l_loginid := fnd_global.login_id;

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;
2310:
2311: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
2312: INSERT INTO mtl_unit_transactions

Line 5077: l_userid := fnd_global.user_id;

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

Line 5078: l_loginid := fnd_global.login_id;

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;
5080:
5081: IF (p_transaction_action_id = 3 AND g_firstscan = FALSE) THEN
5082: IF (l_debug = 1) THEN