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.BOM_IMPORT_PUB dependencies on FND_GLOBAL

Line 1257: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);

1253: l_org_id_table num_type;
1254: l_ss_record_table var_type;
1255: l_count NUMBER;
1256: l_item_num_table var_type;
1257: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1258: CURSOR Process_Header
1259: IS
1260: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

Line 1779: l_user_name FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;

1775: l_comp_table bom_intf_comp;
1776: l_header_count NUMBER;
1777: l_comp_count NUMBER;
1778: l_dummy VARCHAR2(10);
1779: l_user_name FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
1780: l_user_id NUMBER;
1781: l_language VARCHAR2(100);
1782: l_resp_id NUMBER;
1783: l_request_id NUMBER;

Line 1956: l_user_id := FND_GLOBAL.USER_ID;

1952: SELECT userenv('LANG')
1953: INTO l_language
1954: FROM dual;
1955:
1956: l_user_id := FND_GLOBAL.USER_ID;
1957: l_resp_id := FND_GLOBAL.RESP_ID;
1958: l_app_id := FND_GLOBAL.RESP_APPL_ID;
1959:
1960: IF (NVL(l_user_id,-1)=-1 OR NVL(l_resp_id,-1)=-1 OR NVL(l_app_id,-1)=-1)

Line 1957: l_resp_id := FND_GLOBAL.RESP_ID;

1953: INTO l_language
1954: FROM dual;
1955:
1956: l_user_id := FND_GLOBAL.USER_ID;
1957: l_resp_id := FND_GLOBAL.RESP_ID;
1958: l_app_id := FND_GLOBAL.RESP_APPL_ID;
1959:
1960: IF (NVL(l_user_id,-1)=-1 OR NVL(l_resp_id,-1)=-1 OR NVL(l_app_id,-1)=-1)
1961: THEN

Line 1958: l_app_id := FND_GLOBAL.RESP_APPL_ID;

1954: FROM dual;
1955:
1956: l_user_id := FND_GLOBAL.USER_ID;
1957: l_resp_id := FND_GLOBAL.RESP_ID;
1958: l_app_id := FND_GLOBAL.RESP_APPL_ID;
1959:
1960: IF (NVL(l_user_id,-1)=-1 OR NVL(l_resp_id,-1)=-1 OR NVL(l_app_id,-1)=-1)
1961: THEN
1962: Error_Handler.Add_Error_Token

Line 3071: l_user_name FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;

3067: l_count NUMBER;
3068: l_comp_seq_id NUMBER := p_comp_seq_id;
3069: l_err_code NUMBER;
3070: l_msg_count NUMBER;
3071: l_user_name FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
3072: l_gz_party_id VARCHAR2(30);
3073: l_bill_seq_id NUMBER := p_bill_seq_id;
3074: l_comp_name VARCHAR2(100);
3075: l_parent_name VARCHAR2(100);

Line 3951: prog_appid => FND_GLOBAL.prog_appl_id,

3947: val_bom_flag => p_import_bills,
3948: pro_rtg_flag => p_import_routings,
3949: pro_bom_flag => p_import_bills,
3950: del_rec_flag => p_delete_rows,
3951: prog_appid => FND_GLOBAL.prog_appl_id,
3952: prog_id => FND_GLOBAL.conc_program_id,
3953: request_id => FND_GLOBAL.conc_request_id,
3954: user_id => FND_GLOBAL.login_id,
3955: login_id => FND_GLOBAL.login_id,

Line 3952: prog_id => FND_GLOBAL.conc_program_id,

3948: pro_rtg_flag => p_import_routings,
3949: pro_bom_flag => p_import_bills,
3950: del_rec_flag => p_delete_rows,
3951: prog_appid => FND_GLOBAL.prog_appl_id,
3952: prog_id => FND_GLOBAL.conc_program_id,
3953: request_id => FND_GLOBAL.conc_request_id,
3954: user_id => FND_GLOBAL.login_id,
3955: login_id => FND_GLOBAL.login_id,
3956: p_batch_id => p_batch_id,

Line 3953: request_id => FND_GLOBAL.conc_request_id,

3949: pro_bom_flag => p_import_bills,
3950: del_rec_flag => p_delete_rows,
3951: prog_appid => FND_GLOBAL.prog_appl_id,
3952: prog_id => FND_GLOBAL.conc_program_id,
3953: request_id => FND_GLOBAL.conc_request_id,
3954: user_id => FND_GLOBAL.login_id,
3955: login_id => FND_GLOBAL.login_id,
3956: p_batch_id => p_batch_id,
3957: err_text => x_err_buffer);

Line 3954: user_id => FND_GLOBAL.login_id,

3950: del_rec_flag => p_delete_rows,
3951: prog_appid => FND_GLOBAL.prog_appl_id,
3952: prog_id => FND_GLOBAL.conc_program_id,
3953: request_id => FND_GLOBAL.conc_request_id,
3954: user_id => FND_GLOBAL.login_id,
3955: login_id => FND_GLOBAL.login_id,
3956: p_batch_id => p_batch_id,
3957: err_text => x_err_buffer);
3958: --logMessage_forsnell('after import' || l_return_code );

Line 3955: login_id => FND_GLOBAL.login_id,

3951: prog_appid => FND_GLOBAL.prog_appl_id,
3952: prog_id => FND_GLOBAL.conc_program_id,
3953: request_id => FND_GLOBAL.conc_request_id,
3954: user_id => FND_GLOBAL.login_id,
3955: login_id => FND_GLOBAL.login_id,
3956: p_batch_id => p_batch_id,
3957: err_text => x_err_buffer);
3958: --logMessage_forsnell('after import' || l_return_code );
3959:

Line 3984: prog_appid => FND_GLOBAL.prog_appl_id,

3980: val_bom_flag => p_import_bills,
3981: pro_rtg_flag => p_import_routings,
3982: pro_bom_flag => p_import_bills,
3983: del_rec_flag => p_delete_rows,
3984: prog_appid => FND_GLOBAL.prog_appl_id,
3985: prog_id => FND_GLOBAL.conc_program_id,
3986: request_id => FND_GLOBAL.conc_request_id,
3987: user_id => FND_GLOBAL.login_id,
3988: login_id => FND_GLOBAL.login_id,

Line 3985: prog_id => FND_GLOBAL.conc_program_id,

3981: pro_rtg_flag => p_import_routings,
3982: pro_bom_flag => p_import_bills,
3983: del_rec_flag => p_delete_rows,
3984: prog_appid => FND_GLOBAL.prog_appl_id,
3985: prog_id => FND_GLOBAL.conc_program_id,
3986: request_id => FND_GLOBAL.conc_request_id,
3987: user_id => FND_GLOBAL.login_id,
3988: login_id => FND_GLOBAL.login_id,
3989: p_batch_id => p_batch_id,

Line 3986: request_id => FND_GLOBAL.conc_request_id,

3982: pro_bom_flag => p_import_bills,
3983: del_rec_flag => p_delete_rows,
3984: prog_appid => FND_GLOBAL.prog_appl_id,
3985: prog_id => FND_GLOBAL.conc_program_id,
3986: request_id => FND_GLOBAL.conc_request_id,
3987: user_id => FND_GLOBAL.login_id,
3988: login_id => FND_GLOBAL.login_id,
3989: p_batch_id => p_batch_id,
3990: err_text => x_err_buffer);

Line 3987: user_id => FND_GLOBAL.login_id,

3983: del_rec_flag => p_delete_rows,
3984: prog_appid => FND_GLOBAL.prog_appl_id,
3985: prog_id => FND_GLOBAL.conc_program_id,
3986: request_id => FND_GLOBAL.conc_request_id,
3987: user_id => FND_GLOBAL.login_id,
3988: login_id => FND_GLOBAL.login_id,
3989: p_batch_id => p_batch_id,
3990: err_text => x_err_buffer);
3991:

Line 3988: login_id => FND_GLOBAL.login_id,

3984: prog_appid => FND_GLOBAL.prog_appl_id,
3985: prog_id => FND_GLOBAL.conc_program_id,
3986: request_id => FND_GLOBAL.conc_request_id,
3987: user_id => FND_GLOBAL.login_id,
3988: login_id => FND_GLOBAL.login_id,
3989: p_batch_id => p_batch_id,
3990: err_text => x_err_buffer);
3991:
3992: IF ( l_return_code = 0 ) THEN