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_EGO_REVISION_VALIDATE dependencies on FND_GLOBAL

Line 1749: l_user_id := FND_GLOBAL.user_id;

1745:
1746: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN
1747:
1748: IF l_user_id IS NULL OR l_user_id = -1 THEN
1749: l_user_id := FND_GLOBAL.user_id;
1750: END IF;
1751:
1752: OPEN c_get_party_id(l_user_id);
1753: FETCH c_get_party_id INTO l_party_name;

Line 1924: IF ((nvl(cur.created_by,FND_GLOBAL.user_id)) <> -99 ) THEN

1920:
1921: ELSIF cur.transaction_type ='UPDATE' THEN
1922: -- Bug 10243450 : Created_By had null value for some excel update cases and would fail this check causing security to be skipped
1923:
1924: IF ((nvl(cur.created_by,FND_GLOBAL.user_id)) <> -99 ) THEN
1925: l_has_privilege := check_data_security(
1926: p_function => 'EGO_EDIT_ITEM'
1927: ,p_object_name => 'EGO_ITEM'
1928: ,p_instance_pk1_value => cur.inventory_item_id

Line 2158: WHERE USER_ID = FND_GLOBAL.User_ID;

2154:
2155: --4932512 : Replacing ego_people with ego_user
2156: SELECT party_id INTO l_party_id
2157: FROM EGO_USER_V
2158: WHERE USER_ID = FND_GLOBAL.User_ID;
2159:
2160: FOR cur in c_get_processed_records(P_Set_id) LOOP
2161: IF cur.transaction_type ='CREATE' THEN
2162: IF l_inv_debug_level IN(101, 102) THEN

Line 2268: FND_GLOBAL.USER_ID,

2264: SET process_flag = 3
2265: WHERE rowid = cur.rowid;
2266: l_error_logged := INVPUOPI.mtl_log_interface_err(
2267: cur.organization_id,
2268: FND_GLOBAL.USER_ID,
2269: FND_GLOBAL.LOGIN_ID,
2270: FND_GLOBAL.PROG_APPL_ID,
2271: FND_GLOBAL.CONC_PROGRAM_ID,
2272: FND_GLOBAL.CONC_REQUEST_ID,

Line 2269: FND_GLOBAL.LOGIN_ID,

2265: WHERE rowid = cur.rowid;
2266: l_error_logged := INVPUOPI.mtl_log_interface_err(
2267: cur.organization_id,
2268: FND_GLOBAL.USER_ID,
2269: FND_GLOBAL.LOGIN_ID,
2270: FND_GLOBAL.PROG_APPL_ID,
2271: FND_GLOBAL.CONC_PROGRAM_ID,
2272: FND_GLOBAL.CONC_REQUEST_ID,
2273: cur.transaction_id,

Line 2270: FND_GLOBAL.PROG_APPL_ID,

2266: l_error_logged := INVPUOPI.mtl_log_interface_err(
2267: cur.organization_id,
2268: FND_GLOBAL.USER_ID,
2269: FND_GLOBAL.LOGIN_ID,
2270: FND_GLOBAL.PROG_APPL_ID,
2271: FND_GLOBAL.CONC_PROGRAM_ID,
2272: FND_GLOBAL.CONC_REQUEST_ID,
2273: cur.transaction_id,
2274: l_msg_data,

Line 2271: FND_GLOBAL.CONC_PROGRAM_ID,

2267: cur.organization_id,
2268: FND_GLOBAL.USER_ID,
2269: FND_GLOBAL.LOGIN_ID,
2270: FND_GLOBAL.PROG_APPL_ID,
2271: FND_GLOBAL.CONC_PROGRAM_ID,
2272: FND_GLOBAL.CONC_REQUEST_ID,
2273: cur.transaction_id,
2274: l_msg_data,
2275: 'TEMPLATE_ID',

Line 2272: FND_GLOBAL.CONC_REQUEST_ID,

2268: FND_GLOBAL.USER_ID,
2269: FND_GLOBAL.LOGIN_ID,
2270: FND_GLOBAL.PROG_APPL_ID,
2271: FND_GLOBAL.CONC_PROGRAM_ID,
2272: FND_GLOBAL.CONC_REQUEST_ID,
2273: cur.transaction_id,
2274: l_msg_data,
2275: 'TEMPLATE_ID',
2276: 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 2298: FND_MESSAGE.SET_TOKEN ('USER_ID', FND_GLOBAL.User_Id);

2294: IF (INSTR(NVL(G_PROCESS_CONTROL,'PLM_UI:N'),'PLM_UI:Y') <> 0 ) OR
2295: (INSTR(NVL(G_PROCESS_CONTROL,'PLM_UI:N'),'ENG_CALL:Y') <> 0 )
2296: THEN
2297: FND_MESSAGE.SET_NAME ( 'INV', 'INV_INVALID_USER');
2298: FND_MESSAGE.SET_TOKEN ('USER_ID', FND_GLOBAL.User_Id);
2299: l_msg_data := FND_MESSAGE.GET;
2300: For exc IN c_get_processed_records (P_Set_Id)
2301: LOOP
2302: UPDATE mtl_system_items_interface

Line 2307: FND_GLOBAL.USER_ID,

2303: SET process_flag = 3
2304: WHERE rowid = exc.rowid;
2305: l_error_logged := INVPUOPI.mtl_log_interface_err(
2306: exc.organization_id,
2307: FND_GLOBAL.USER_ID,
2308: FND_GLOBAL.LOGIN_ID,
2309: FND_GLOBAL.PROG_APPL_ID,
2310: FND_GLOBAL.CONC_PROGRAM_ID,
2311: FND_GLOBAL.CONC_REQUEST_ID,

Line 2308: FND_GLOBAL.LOGIN_ID,

2304: WHERE rowid = exc.rowid;
2305: l_error_logged := INVPUOPI.mtl_log_interface_err(
2306: exc.organization_id,
2307: FND_GLOBAL.USER_ID,
2308: FND_GLOBAL.LOGIN_ID,
2309: FND_GLOBAL.PROG_APPL_ID,
2310: FND_GLOBAL.CONC_PROGRAM_ID,
2311: FND_GLOBAL.CONC_REQUEST_ID,
2312: exc.transaction_id,

Line 2309: FND_GLOBAL.PROG_APPL_ID,

2305: l_error_logged := INVPUOPI.mtl_log_interface_err(
2306: exc.organization_id,
2307: FND_GLOBAL.USER_ID,
2308: FND_GLOBAL.LOGIN_ID,
2309: FND_GLOBAL.PROG_APPL_ID,
2310: FND_GLOBAL.CONC_PROGRAM_ID,
2311: FND_GLOBAL.CONC_REQUEST_ID,
2312: exc.transaction_id,
2313: l_msg_data,

Line 2310: FND_GLOBAL.CONC_PROGRAM_ID,

2306: exc.organization_id,
2307: FND_GLOBAL.USER_ID,
2308: FND_GLOBAL.LOGIN_ID,
2309: FND_GLOBAL.PROG_APPL_ID,
2310: FND_GLOBAL.CONC_PROGRAM_ID,
2311: FND_GLOBAL.CONC_REQUEST_ID,
2312: exc.transaction_id,
2313: l_msg_data,
2314: 'LOGIN_USER_ID',

Line 2311: FND_GLOBAL.CONC_REQUEST_ID,

2307: FND_GLOBAL.USER_ID,
2308: FND_GLOBAL.LOGIN_ID,
2309: FND_GLOBAL.PROG_APPL_ID,
2310: FND_GLOBAL.CONC_PROGRAM_ID,
2311: FND_GLOBAL.CONC_REQUEST_ID,
2312: exc.transaction_id,
2313: l_msg_data,
2314: 'LOGIN_USER_ID',
2315: 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 3255: ||' ,requestor_user_name => FND_GLOBAL.user_name '

3251: ||' ,change_name => :i.ITEM_NUMBER '
3252: ||' ,change_type_code => :l_type_name '
3253: ||' ,item_number => :i.ITEM_NUMBER '
3254: ||' ,organization_code => :i.ORGANIZATION_CODE '
3255: ||' ,requestor_user_name => FND_GLOBAL.user_name '
3256: ||' ,batch_id => :p_set_process_id '
3257: ||' ,X_CHANGE_ID => :l_change_id '
3258: ||' ,X_RETURN_STATUS => :l_return_status ); '
3259: ||' EXCEPTION '

Line 3279: FND_GLOBAL.USER_ID,

3275: WHERE rowid = i.rowid;
3276:
3277: dumm_status := INVPUOPI.mtl_log_interface_err(
3278: i.organization_id,
3279: FND_GLOBAL.USER_ID,
3280: FND_GLOBAL.LOGIN_ID,
3281: FND_GLOBAL.PROG_APPL_ID,
3282: FND_GLOBAL.CONC_PROGRAM_ID,
3283: FND_GLOBAL.CONC_REQUEST_ID

Line 3280: FND_GLOBAL.LOGIN_ID,

3276:
3277: dumm_status := INVPUOPI.mtl_log_interface_err(
3278: i.organization_id,
3279: FND_GLOBAL.USER_ID,
3280: FND_GLOBAL.LOGIN_ID,
3281: FND_GLOBAL.PROG_APPL_ID,
3282: FND_GLOBAL.CONC_PROGRAM_ID,
3283: FND_GLOBAL.CONC_REQUEST_ID
3284: ,i.transaction_id

Line 3281: FND_GLOBAL.PROG_APPL_ID,

3277: dumm_status := INVPUOPI.mtl_log_interface_err(
3278: i.organization_id,
3279: FND_GLOBAL.USER_ID,
3280: FND_GLOBAL.LOGIN_ID,
3281: FND_GLOBAL.PROG_APPL_ID,
3282: FND_GLOBAL.CONC_PROGRAM_ID,
3283: FND_GLOBAL.CONC_REQUEST_ID
3284: ,i.transaction_id
3285: ,err_text

Line 3282: FND_GLOBAL.CONC_PROGRAM_ID,

3278: i.organization_id,
3279: FND_GLOBAL.USER_ID,
3280: FND_GLOBAL.LOGIN_ID,
3281: FND_GLOBAL.PROG_APPL_ID,
3282: FND_GLOBAL.CONC_PROGRAM_ID,
3283: FND_GLOBAL.CONC_REQUEST_ID
3284: ,i.transaction_id
3285: ,err_text
3286: ,'ITEM_NUMBER'

Line 3283: FND_GLOBAL.CONC_REQUEST_ID

3279: FND_GLOBAL.USER_ID,
3280: FND_GLOBAL.LOGIN_ID,
3281: FND_GLOBAL.PROG_APPL_ID,
3282: FND_GLOBAL.CONC_PROGRAM_ID,
3283: FND_GLOBAL.CONC_REQUEST_ID
3284: ,i.transaction_id
3285: ,err_text
3286: ,'ITEM_NUMBER'
3287: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 3298: FND_GLOBAL.USER_ID,

3294: WHERE rowid = i.rowid;
3295:
3296: dumm_status := INVPUOPI.mtl_log_interface_err(
3297: i.organization_id,
3298: FND_GLOBAL.USER_ID,
3299: FND_GLOBAL.LOGIN_ID,
3300: FND_GLOBAL.PROG_APPL_ID,
3301: FND_GLOBAL.CONC_PROGRAM_ID,
3302: FND_GLOBAL.CONC_REQUEST_ID

Line 3299: FND_GLOBAL.LOGIN_ID,

3295:
3296: dumm_status := INVPUOPI.mtl_log_interface_err(
3297: i.organization_id,
3298: FND_GLOBAL.USER_ID,
3299: FND_GLOBAL.LOGIN_ID,
3300: FND_GLOBAL.PROG_APPL_ID,
3301: FND_GLOBAL.CONC_PROGRAM_ID,
3302: FND_GLOBAL.CONC_REQUEST_ID
3303: ,i.transaction_id

Line 3300: FND_GLOBAL.PROG_APPL_ID,

3296: dumm_status := INVPUOPI.mtl_log_interface_err(
3297: i.organization_id,
3298: FND_GLOBAL.USER_ID,
3299: FND_GLOBAL.LOGIN_ID,
3300: FND_GLOBAL.PROG_APPL_ID,
3301: FND_GLOBAL.CONC_PROGRAM_ID,
3302: FND_GLOBAL.CONC_REQUEST_ID
3303: ,i.transaction_id
3304: ,l_error_table(1).message_text

Line 3301: FND_GLOBAL.CONC_PROGRAM_ID,

3297: i.organization_id,
3298: FND_GLOBAL.USER_ID,
3299: FND_GLOBAL.LOGIN_ID,
3300: FND_GLOBAL.PROG_APPL_ID,
3301: FND_GLOBAL.CONC_PROGRAM_ID,
3302: FND_GLOBAL.CONC_REQUEST_ID
3303: ,i.transaction_id
3304: ,l_error_table(1).message_text
3305: ,'ITEM_CATALOG_GORUP_ID'

Line 3302: FND_GLOBAL.CONC_REQUEST_ID

3298: FND_GLOBAL.USER_ID,
3299: FND_GLOBAL.LOGIN_ID,
3300: FND_GLOBAL.PROG_APPL_ID,
3301: FND_GLOBAL.CONC_PROGRAM_ID,
3302: FND_GLOBAL.CONC_REQUEST_ID
3303: ,i.transaction_id
3304: ,l_error_table(1).message_text
3305: ,'ITEM_CATALOG_GORUP_ID'
3306: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 3333: FND_GLOBAL.USER_ID,

3329: END IF;
3330:
3331: dumm_status := INVPUOPI.mtl_log_interface_err(
3332: null,--i.organization_id,
3333: FND_GLOBAL.USER_ID,
3334: FND_GLOBAL.LOGIN_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: FND_GLOBAL.CONC_PROGRAM_ID,
3337: FND_GLOBAL.CONC_REQUEST_ID,

Line 3334: FND_GLOBAL.LOGIN_ID,

3330:
3331: dumm_status := INVPUOPI.mtl_log_interface_err(
3332: null,--i.organization_id,
3333: FND_GLOBAL.USER_ID,
3334: FND_GLOBAL.LOGIN_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: FND_GLOBAL.CONC_PROGRAM_ID,
3337: FND_GLOBAL.CONC_REQUEST_ID,
3338: p_set_process_id--i.transaction_id

Line 3335: FND_GLOBAL.PROG_APPL_ID,

3331: dumm_status := INVPUOPI.mtl_log_interface_err(
3332: null,--i.organization_id,
3333: FND_GLOBAL.USER_ID,
3334: FND_GLOBAL.LOGIN_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: FND_GLOBAL.CONC_PROGRAM_ID,
3337: FND_GLOBAL.CONC_REQUEST_ID,
3338: p_set_process_id--i.transaction_id
3339: ,'CO NIR is having problem for this set proecess id'||p_set_process_id

Line 3336: FND_GLOBAL.CONC_PROGRAM_ID,

3332: null,--i.organization_id,
3333: FND_GLOBAL.USER_ID,
3334: FND_GLOBAL.LOGIN_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: FND_GLOBAL.CONC_PROGRAM_ID,
3337: FND_GLOBAL.CONC_REQUEST_ID,
3338: p_set_process_id--i.transaction_id
3339: ,'CO NIR is having problem for this set proecess id'||p_set_process_id
3340: ,'ITEM_CATALOG_GORUP_ID'

Line 3337: FND_GLOBAL.CONC_REQUEST_ID,

3333: FND_GLOBAL.USER_ID,
3334: FND_GLOBAL.LOGIN_ID,
3335: FND_GLOBAL.PROG_APPL_ID,
3336: FND_GLOBAL.CONC_PROGRAM_ID,
3337: FND_GLOBAL.CONC_REQUEST_ID,
3338: p_set_process_id--i.transaction_id
3339: ,'CO NIR is having problem for this set proecess id'||p_set_process_id
3340: ,'ITEM_CATALOG_GORUP_ID'
3341: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 3846: ||' ,requestor_user_name => FND_GLOBAL.USER_NAME '

3842: ||' ,change_name => :p_item_number '
3843: ||' ,change_type_code => :l_type_code '
3844: ||' ,item_number => :p_item_number '
3845: ||' ,organization_code => :l_org_code '
3846: ||' ,requestor_user_name => FND_GLOBAL.USER_NAME '
3847: ||' ,X_RETURN_STATUS => :l_return_status ); '
3848: ||' EXCEPTION '
3849: ||' WHEN OTHERS THEN '
3850: ||' NULL; '

Line 4027: l_user_id NUMBER := FND_GLOBAL.User_Id;

4023: FROM mtl_system_items_b
4024: WHERE inventory_item_id = cp_inventory_item_id
4025: AND organization_id = cp_organization_id;
4026:
4027: l_user_id NUMBER := FND_GLOBAL.User_Id;
4028: l_login_id NUMBER := FND_GLOBAL.Login_Id;
4029: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
4030: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
4031:

Line 4028: l_login_id NUMBER := FND_GLOBAL.Login_Id;

4024: WHERE inventory_item_id = cp_inventory_item_id
4025: AND organization_id = cp_organization_id;
4026:
4027: l_user_id NUMBER := FND_GLOBAL.User_Id;
4028: l_login_id NUMBER := FND_GLOBAL.Login_Id;
4029: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
4030: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
4031:
4032: l_msii_icc_id NUMBER;

Line 4029: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;

4025: AND organization_id = cp_organization_id;
4026:
4027: l_user_id NUMBER := FND_GLOBAL.User_Id;
4028: l_login_id NUMBER := FND_GLOBAL.Login_Id;
4029: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
4030: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
4031:
4032: l_msii_icc_id NUMBER;
4033: l_msi_icc_id NUMBER;

Line 4030: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;

4026:
4027: l_user_id NUMBER := FND_GLOBAL.User_Id;
4028: l_login_id NUMBER := FND_GLOBAL.Login_Id;
4029: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
4030: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
4031:
4032: l_msii_icc_id NUMBER;
4033: l_msi_icc_id NUMBER;
4034: l_msii_style_item_flag VARCHAR2(1);

Line 4353: AND RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID

4349: CURSOR c_check_org_access (p_org_id IN NUMBER) IS
4350: SELECT 'X'
4351: FROM ORG_ACCESS_VIEW
4352: WHERE ORGANIZATION_ID = p_org_id
4353: AND RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
4354: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
4355:
4356: l_has_access VARCHAR2(1) := 'T';
4357: l_exists VARCHAR2(1);

Line 4354: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;

4350: SELECT 'X'
4351: FROM ORG_ACCESS_VIEW
4352: WHERE ORGANIZATION_ID = p_org_id
4353: AND RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
4354: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
4355:
4356: l_has_access VARCHAR2(1) := 'T';
4357: l_exists VARCHAR2(1);
4358: