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

Line 1651: l_user_id := FND_GLOBAL.user_id;

1647:
1648: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN
1649:
1650: IF l_user_id IS NULL OR l_user_id = -1 THEN
1651: l_user_id := FND_GLOBAL.user_id;
1652: END IF;
1653:
1654: OPEN c_get_party_id(l_user_id);
1655: FETCH c_get_party_id INTO l_party_name;

Line 2027: WHERE USER_ID = FND_GLOBAL.User_ID;

2023:
2024: --4932512 : Replacing ego_people with ego_user
2025: SELECT party_id INTO l_party_id
2026: FROM EGO_USER_V
2027: WHERE USER_ID = FND_GLOBAL.User_ID;
2028:
2029: FOR cur in c_get_processed_records(P_Set_id) LOOP
2030: IF cur.transaction_type ='CREATE' THEN
2031: IF l_inv_debug_level IN(101, 102) THEN

Line 2116: FND_GLOBAL.USER_ID,

2112: SET process_flag = 3
2113: WHERE rowid = cur.rowid;
2114: l_error_logged := INVPUOPI.mtl_log_interface_err(
2115: cur.organization_id,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.LOGIN_ID,
2118: FND_GLOBAL.PROG_APPL_ID,
2119: FND_GLOBAL.CONC_PROGRAM_ID,
2120: FND_GLOBAL.CONC_REQUEST_ID,

Line 2117: FND_GLOBAL.LOGIN_ID,

2113: WHERE rowid = cur.rowid;
2114: l_error_logged := INVPUOPI.mtl_log_interface_err(
2115: cur.organization_id,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.LOGIN_ID,
2118: FND_GLOBAL.PROG_APPL_ID,
2119: FND_GLOBAL.CONC_PROGRAM_ID,
2120: FND_GLOBAL.CONC_REQUEST_ID,
2121: cur.transaction_id,

Line 2118: FND_GLOBAL.PROG_APPL_ID,

2114: l_error_logged := INVPUOPI.mtl_log_interface_err(
2115: cur.organization_id,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.LOGIN_ID,
2118: FND_GLOBAL.PROG_APPL_ID,
2119: FND_GLOBAL.CONC_PROGRAM_ID,
2120: FND_GLOBAL.CONC_REQUEST_ID,
2121: cur.transaction_id,
2122: l_msg_data,

Line 2119: FND_GLOBAL.CONC_PROGRAM_ID,

2115: cur.organization_id,
2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.LOGIN_ID,
2118: FND_GLOBAL.PROG_APPL_ID,
2119: FND_GLOBAL.CONC_PROGRAM_ID,
2120: FND_GLOBAL.CONC_REQUEST_ID,
2121: cur.transaction_id,
2122: l_msg_data,
2123: 'TEMPLATE_ID',

Line 2120: FND_GLOBAL.CONC_REQUEST_ID,

2116: FND_GLOBAL.USER_ID,
2117: FND_GLOBAL.LOGIN_ID,
2118: FND_GLOBAL.PROG_APPL_ID,
2119: FND_GLOBAL.CONC_PROGRAM_ID,
2120: FND_GLOBAL.CONC_REQUEST_ID,
2121: cur.transaction_id,
2122: l_msg_data,
2123: 'TEMPLATE_ID',
2124: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

2142: IF (INSTR(NVL(G_PROCESS_CONTROL,'PLM_UI:N'),'PLM_UI:Y') <> 0 ) OR
2143: (INSTR(NVL(G_PROCESS_CONTROL,'PLM_UI:N'),'ENG_CALL:Y') <> 0 )
2144: THEN
2145: FND_MESSAGE.SET_NAME ( 'INV', 'INV_INVALID_USER');
2146: FND_MESSAGE.SET_TOKEN ('USER_ID', FND_GLOBAL.User_Id);
2147: l_msg_data := FND_MESSAGE.GET;
2148: For exc IN c_get_processed_records (P_Set_Id)
2149: LOOP
2150: UPDATE mtl_system_items_interface

Line 2155: FND_GLOBAL.USER_ID,

2151: SET process_flag = 3
2152: WHERE rowid = exc.rowid;
2153: l_error_logged := INVPUOPI.mtl_log_interface_err(
2154: exc.organization_id,
2155: FND_GLOBAL.USER_ID,
2156: FND_GLOBAL.LOGIN_ID,
2157: FND_GLOBAL.PROG_APPL_ID,
2158: FND_GLOBAL.CONC_PROGRAM_ID,
2159: FND_GLOBAL.CONC_REQUEST_ID,

Line 2156: FND_GLOBAL.LOGIN_ID,

2152: WHERE rowid = exc.rowid;
2153: l_error_logged := INVPUOPI.mtl_log_interface_err(
2154: exc.organization_id,
2155: FND_GLOBAL.USER_ID,
2156: FND_GLOBAL.LOGIN_ID,
2157: FND_GLOBAL.PROG_APPL_ID,
2158: FND_GLOBAL.CONC_PROGRAM_ID,
2159: FND_GLOBAL.CONC_REQUEST_ID,
2160: exc.transaction_id,

Line 2157: FND_GLOBAL.PROG_APPL_ID,

2153: l_error_logged := INVPUOPI.mtl_log_interface_err(
2154: exc.organization_id,
2155: FND_GLOBAL.USER_ID,
2156: FND_GLOBAL.LOGIN_ID,
2157: FND_GLOBAL.PROG_APPL_ID,
2158: FND_GLOBAL.CONC_PROGRAM_ID,
2159: FND_GLOBAL.CONC_REQUEST_ID,
2160: exc.transaction_id,
2161: l_msg_data,

Line 2158: FND_GLOBAL.CONC_PROGRAM_ID,

2154: exc.organization_id,
2155: FND_GLOBAL.USER_ID,
2156: FND_GLOBAL.LOGIN_ID,
2157: FND_GLOBAL.PROG_APPL_ID,
2158: FND_GLOBAL.CONC_PROGRAM_ID,
2159: FND_GLOBAL.CONC_REQUEST_ID,
2160: exc.transaction_id,
2161: l_msg_data,
2162: 'LOGIN_USER_ID',

Line 2159: FND_GLOBAL.CONC_REQUEST_ID,

2155: FND_GLOBAL.USER_ID,
2156: FND_GLOBAL.LOGIN_ID,
2157: FND_GLOBAL.PROG_APPL_ID,
2158: FND_GLOBAL.CONC_PROGRAM_ID,
2159: FND_GLOBAL.CONC_REQUEST_ID,
2160: exc.transaction_id,
2161: l_msg_data,
2162: 'LOGIN_USER_ID',
2163: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

3041: ||' ,change_name => :i.ITEM_NUMBER '
3042: ||' ,change_type_code => :l_type_name '
3043: ||' ,item_number => :i.ITEM_NUMBER '
3044: ||' ,organization_code => :i.ORGANIZATION_CODE '
3045: ||' ,requestor_user_name => FND_GLOBAL.user_name '
3046: ||' ,batch_id => :p_set_process_id '
3047: ||' ,X_CHANGE_ID => :l_change_id '
3048: ||' ,X_RETURN_STATUS => :l_return_status ); '
3049: ||' EXCEPTION '

Line 3069: FND_GLOBAL.USER_ID,

3065: WHERE rowid = i.rowid;
3066:
3067: dumm_status := INVPUOPI.mtl_log_interface_err(
3068: i.organization_id,
3069: FND_GLOBAL.USER_ID,
3070: FND_GLOBAL.LOGIN_ID,
3071: FND_GLOBAL.PROG_APPL_ID,
3072: FND_GLOBAL.CONC_PROGRAM_ID,
3073: FND_GLOBAL.CONC_REQUEST_ID

Line 3070: FND_GLOBAL.LOGIN_ID,

3066:
3067: dumm_status := INVPUOPI.mtl_log_interface_err(
3068: i.organization_id,
3069: FND_GLOBAL.USER_ID,
3070: FND_GLOBAL.LOGIN_ID,
3071: FND_GLOBAL.PROG_APPL_ID,
3072: FND_GLOBAL.CONC_PROGRAM_ID,
3073: FND_GLOBAL.CONC_REQUEST_ID
3074: ,i.transaction_id

Line 3071: FND_GLOBAL.PROG_APPL_ID,

3067: dumm_status := INVPUOPI.mtl_log_interface_err(
3068: i.organization_id,
3069: FND_GLOBAL.USER_ID,
3070: FND_GLOBAL.LOGIN_ID,
3071: FND_GLOBAL.PROG_APPL_ID,
3072: FND_GLOBAL.CONC_PROGRAM_ID,
3073: FND_GLOBAL.CONC_REQUEST_ID
3074: ,i.transaction_id
3075: ,err_text

Line 3072: FND_GLOBAL.CONC_PROGRAM_ID,

3068: i.organization_id,
3069: FND_GLOBAL.USER_ID,
3070: FND_GLOBAL.LOGIN_ID,
3071: FND_GLOBAL.PROG_APPL_ID,
3072: FND_GLOBAL.CONC_PROGRAM_ID,
3073: FND_GLOBAL.CONC_REQUEST_ID
3074: ,i.transaction_id
3075: ,err_text
3076: ,'ITEM_NUMBER'

Line 3073: FND_GLOBAL.CONC_REQUEST_ID

3069: FND_GLOBAL.USER_ID,
3070: FND_GLOBAL.LOGIN_ID,
3071: FND_GLOBAL.PROG_APPL_ID,
3072: FND_GLOBAL.CONC_PROGRAM_ID,
3073: FND_GLOBAL.CONC_REQUEST_ID
3074: ,i.transaction_id
3075: ,err_text
3076: ,'ITEM_NUMBER'
3077: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 3088: FND_GLOBAL.USER_ID,

3084: WHERE rowid = i.rowid;
3085:
3086: dumm_status := INVPUOPI.mtl_log_interface_err(
3087: i.organization_id,
3088: FND_GLOBAL.USER_ID,
3089: FND_GLOBAL.LOGIN_ID,
3090: FND_GLOBAL.PROG_APPL_ID,
3091: FND_GLOBAL.CONC_PROGRAM_ID,
3092: FND_GLOBAL.CONC_REQUEST_ID

Line 3089: FND_GLOBAL.LOGIN_ID,

3085:
3086: dumm_status := INVPUOPI.mtl_log_interface_err(
3087: i.organization_id,
3088: FND_GLOBAL.USER_ID,
3089: FND_GLOBAL.LOGIN_ID,
3090: FND_GLOBAL.PROG_APPL_ID,
3091: FND_GLOBAL.CONC_PROGRAM_ID,
3092: FND_GLOBAL.CONC_REQUEST_ID
3093: ,i.transaction_id

Line 3090: FND_GLOBAL.PROG_APPL_ID,

3086: dumm_status := INVPUOPI.mtl_log_interface_err(
3087: i.organization_id,
3088: FND_GLOBAL.USER_ID,
3089: FND_GLOBAL.LOGIN_ID,
3090: FND_GLOBAL.PROG_APPL_ID,
3091: FND_GLOBAL.CONC_PROGRAM_ID,
3092: FND_GLOBAL.CONC_REQUEST_ID
3093: ,i.transaction_id
3094: ,l_error_table(1).message_text

Line 3091: FND_GLOBAL.CONC_PROGRAM_ID,

3087: i.organization_id,
3088: FND_GLOBAL.USER_ID,
3089: FND_GLOBAL.LOGIN_ID,
3090: FND_GLOBAL.PROG_APPL_ID,
3091: FND_GLOBAL.CONC_PROGRAM_ID,
3092: FND_GLOBAL.CONC_REQUEST_ID
3093: ,i.transaction_id
3094: ,l_error_table(1).message_text
3095: ,'ITEM_CATALOG_GORUP_ID'

Line 3092: FND_GLOBAL.CONC_REQUEST_ID

3088: FND_GLOBAL.USER_ID,
3089: FND_GLOBAL.LOGIN_ID,
3090: FND_GLOBAL.PROG_APPL_ID,
3091: FND_GLOBAL.CONC_PROGRAM_ID,
3092: FND_GLOBAL.CONC_REQUEST_ID
3093: ,i.transaction_id
3094: ,l_error_table(1).message_text
3095: ,'ITEM_CATALOG_GORUP_ID'
3096: ,'MTL_SYSTEM_ITEMS_INTERFACE'

Line 3123: FND_GLOBAL.USER_ID,

3119: END IF;
3120:
3121: dumm_status := INVPUOPI.mtl_log_interface_err(
3122: null,--i.organization_id,
3123: FND_GLOBAL.USER_ID,
3124: FND_GLOBAL.LOGIN_ID,
3125: FND_GLOBAL.PROG_APPL_ID,
3126: FND_GLOBAL.CONC_PROGRAM_ID,
3127: FND_GLOBAL.CONC_REQUEST_ID,

Line 3124: FND_GLOBAL.LOGIN_ID,

3120:
3121: dumm_status := INVPUOPI.mtl_log_interface_err(
3122: null,--i.organization_id,
3123: FND_GLOBAL.USER_ID,
3124: FND_GLOBAL.LOGIN_ID,
3125: FND_GLOBAL.PROG_APPL_ID,
3126: FND_GLOBAL.CONC_PROGRAM_ID,
3127: FND_GLOBAL.CONC_REQUEST_ID,
3128: p_set_process_id--i.transaction_id

Line 3125: FND_GLOBAL.PROG_APPL_ID,

3121: dumm_status := INVPUOPI.mtl_log_interface_err(
3122: null,--i.organization_id,
3123: FND_GLOBAL.USER_ID,
3124: FND_GLOBAL.LOGIN_ID,
3125: FND_GLOBAL.PROG_APPL_ID,
3126: FND_GLOBAL.CONC_PROGRAM_ID,
3127: FND_GLOBAL.CONC_REQUEST_ID,
3128: p_set_process_id--i.transaction_id
3129: ,'CO NIR is having problem for this set proecess id'||p_set_process_id

Line 3126: FND_GLOBAL.CONC_PROGRAM_ID,

3122: null,--i.organization_id,
3123: FND_GLOBAL.USER_ID,
3124: FND_GLOBAL.LOGIN_ID,
3125: FND_GLOBAL.PROG_APPL_ID,
3126: FND_GLOBAL.CONC_PROGRAM_ID,
3127: FND_GLOBAL.CONC_REQUEST_ID,
3128: p_set_process_id--i.transaction_id
3129: ,'CO NIR is having problem for this set proecess id'||p_set_process_id
3130: ,'ITEM_CATALOG_GORUP_ID'

Line 3127: FND_GLOBAL.CONC_REQUEST_ID,

3123: FND_GLOBAL.USER_ID,
3124: FND_GLOBAL.LOGIN_ID,
3125: FND_GLOBAL.PROG_APPL_ID,
3126: FND_GLOBAL.CONC_PROGRAM_ID,
3127: FND_GLOBAL.CONC_REQUEST_ID,
3128: p_set_process_id--i.transaction_id
3129: ,'CO NIR is having problem for this set proecess id'||p_set_process_id
3130: ,'ITEM_CATALOG_GORUP_ID'
3131: ,'MTL_SYSTEM_ITEMS_INTERFACE'

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

3621: ||' ,change_name => :p_item_number '
3622: ||' ,change_type_code => :l_type_code '
3623: ||' ,item_number => :p_item_number '
3624: ||' ,organization_code => :l_org_code '
3625: ||' ,requestor_user_name => FND_GLOBAL.USER_NAME '
3626: ||' ,X_RETURN_STATUS => :l_return_status ); '
3627: ||' EXCEPTION '
3628: ||' WHEN OTHERS THEN '
3629: ||' NULL; '

Line 3767: l_user_id NUMBER := FND_GLOBAL.User_Id;

3763: FROM mtl_system_items_b
3764: WHERE inventory_item_id = cp_inventory_item_id
3765: AND organization_id = cp_organization_id;
3766:
3767: l_user_id NUMBER := FND_GLOBAL.User_Id;
3768: l_login_id NUMBER := FND_GLOBAL.Login_Id;
3769: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
3770: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
3771:

Line 3768: l_login_id NUMBER := FND_GLOBAL.Login_Id;

3764: WHERE inventory_item_id = cp_inventory_item_id
3765: AND organization_id = cp_organization_id;
3766:
3767: l_user_id NUMBER := FND_GLOBAL.User_Id;
3768: l_login_id NUMBER := FND_GLOBAL.Login_Id;
3769: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
3770: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
3771:
3772: l_msii_icc_id NUMBER;

Line 3769: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;

3765: AND organization_id = cp_organization_id;
3766:
3767: l_user_id NUMBER := FND_GLOBAL.User_Id;
3768: l_login_id NUMBER := FND_GLOBAL.Login_Id;
3769: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
3770: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
3771:
3772: l_msii_icc_id NUMBER;
3773: l_msi_icc_id NUMBER;

Line 3770: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;

3766:
3767: l_user_id NUMBER := FND_GLOBAL.User_Id;
3768: l_login_id NUMBER := FND_GLOBAL.Login_Id;
3769: l_Prog_Appl_Id NUMBER := FND_GLOBAL.Prog_Appl_Id;
3770: l_conc_prog_id NUMBER := FND_GLOBAL.Conc_program_id;
3771:
3772: l_msii_icc_id NUMBER;
3773: l_msi_icc_id NUMBER;
3774: l_msii_style_item_flag VARCHAR2(1);

Line 4093: AND RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID

4089: CURSOR c_check_org_access (p_org_id IN NUMBER) IS
4090: SELECT 'X'
4091: FROM ORG_ACCESS_VIEW
4092: WHERE ORGANIZATION_ID = p_org_id
4093: AND RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
4094: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
4095:
4096: l_has_access VARCHAR2(1) := 'T';
4097: l_exists VARCHAR2(1);

Line 4094: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;

4090: SELECT 'X'
4091: FROM ORG_ACCESS_VIEW
4092: WHERE ORGANIZATION_ID = p_org_id
4093: AND RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID
4094: AND RESP_APPLICATION_ID = FND_GLOBAL.RESP_APPL_ID;
4095:
4096: l_has_access VARCHAR2(1) := 'T';
4097: l_exists VARCHAR2(1);
4098: