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 1116: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);

1112: l_org_id_table num_type;
1113: l_ss_record_table var_type;
1114: l_count NUMBER;
1115: l_item_num_table var_type;
1116: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1117: CURSOR Process_Header
1118: IS
1119: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

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

1632: l_comp_table bom_intf_comp;
1633: l_header_count NUMBER;
1634: l_comp_count NUMBER;
1635: l_dummy VARCHAR2(10);
1636: l_user_name FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
1637: l_user_id NUMBER;
1638: l_language VARCHAR2(100);
1639: l_resp_id NUMBER;
1640: l_request_id NUMBER;

Line 1813: l_user_id := FND_GLOBAL.USER_ID;

1809: SELECT userenv('LANG')
1810: INTO l_language
1811: FROM dual;
1812:
1813: l_user_id := FND_GLOBAL.USER_ID;
1814: l_resp_id := FND_GLOBAL.RESP_ID;
1815: l_app_id := FND_GLOBAL.RESP_APPL_ID;
1816:
1817: IF (NVL(l_user_id,-1)=-1 OR NVL(l_resp_id,-1)=-1 OR NVL(l_app_id,-1)=-1)

Line 1814: l_resp_id := FND_GLOBAL.RESP_ID;

1810: INTO l_language
1811: FROM dual;
1812:
1813: l_user_id := FND_GLOBAL.USER_ID;
1814: l_resp_id := FND_GLOBAL.RESP_ID;
1815: l_app_id := FND_GLOBAL.RESP_APPL_ID;
1816:
1817: IF (NVL(l_user_id,-1)=-1 OR NVL(l_resp_id,-1)=-1 OR NVL(l_app_id,-1)=-1)
1818: THEN

Line 1815: l_app_id := FND_GLOBAL.RESP_APPL_ID;

1811: FROM dual;
1812:
1813: l_user_id := FND_GLOBAL.USER_ID;
1814: l_resp_id := FND_GLOBAL.RESP_ID;
1815: l_app_id := FND_GLOBAL.RESP_APPL_ID;
1816:
1817: IF (NVL(l_user_id,-1)=-1 OR NVL(l_resp_id,-1)=-1 OR NVL(l_app_id,-1)=-1)
1818: THEN
1819: Error_Handler.Add_Error_Token

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

2914: l_count NUMBER;
2915: l_comp_seq_id NUMBER := p_comp_seq_id;
2916: l_err_code NUMBER;
2917: l_msg_count NUMBER;
2918: l_user_name FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;
2919: l_gz_party_id VARCHAR2(30);
2920: l_bill_seq_id NUMBER := p_bill_seq_id;
2921: l_comp_name VARCHAR2(100);
2922: l_parent_name VARCHAR2(100);

Line 3559: prog_appid => FND_GLOBAL.prog_appl_id,

3555: val_bom_flag => p_import_bills,
3556: pro_rtg_flag => p_import_routings,
3557: pro_bom_flag => p_import_bills,
3558: del_rec_flag => p_delete_rows,
3559: prog_appid => FND_GLOBAL.prog_appl_id,
3560: prog_id => FND_GLOBAL.conc_program_id,
3561: request_id => FND_GLOBAL.conc_request_id,
3562: user_id => FND_GLOBAL.login_id,
3563: login_id => FND_GLOBAL.login_id,

Line 3560: prog_id => FND_GLOBAL.conc_program_id,

3556: pro_rtg_flag => p_import_routings,
3557: pro_bom_flag => p_import_bills,
3558: del_rec_flag => p_delete_rows,
3559: prog_appid => FND_GLOBAL.prog_appl_id,
3560: prog_id => FND_GLOBAL.conc_program_id,
3561: request_id => FND_GLOBAL.conc_request_id,
3562: user_id => FND_GLOBAL.login_id,
3563: login_id => FND_GLOBAL.login_id,
3564: p_batch_id => p_batch_id,

Line 3561: request_id => FND_GLOBAL.conc_request_id,

3557: pro_bom_flag => p_import_bills,
3558: del_rec_flag => p_delete_rows,
3559: prog_appid => FND_GLOBAL.prog_appl_id,
3560: prog_id => FND_GLOBAL.conc_program_id,
3561: request_id => FND_GLOBAL.conc_request_id,
3562: user_id => FND_GLOBAL.login_id,
3563: login_id => FND_GLOBAL.login_id,
3564: p_batch_id => p_batch_id,
3565: err_text => x_err_buffer);

Line 3562: user_id => FND_GLOBAL.login_id,

3558: del_rec_flag => p_delete_rows,
3559: prog_appid => FND_GLOBAL.prog_appl_id,
3560: prog_id => FND_GLOBAL.conc_program_id,
3561: request_id => FND_GLOBAL.conc_request_id,
3562: user_id => FND_GLOBAL.login_id,
3563: login_id => FND_GLOBAL.login_id,
3564: p_batch_id => p_batch_id,
3565: err_text => x_err_buffer);
3566: --logMessage_forsnell('after import' || l_return_code );

Line 3563: login_id => FND_GLOBAL.login_id,

3559: prog_appid => FND_GLOBAL.prog_appl_id,
3560: prog_id => FND_GLOBAL.conc_program_id,
3561: request_id => FND_GLOBAL.conc_request_id,
3562: user_id => FND_GLOBAL.login_id,
3563: login_id => FND_GLOBAL.login_id,
3564: p_batch_id => p_batch_id,
3565: err_text => x_err_buffer);
3566: --logMessage_forsnell('after import' || l_return_code );
3567:

Line 3592: prog_appid => FND_GLOBAL.prog_appl_id,

3588: val_bom_flag => p_import_bills,
3589: pro_rtg_flag => p_import_routings,
3590: pro_bom_flag => p_import_bills,
3591: del_rec_flag => p_delete_rows,
3592: prog_appid => FND_GLOBAL.prog_appl_id,
3593: prog_id => FND_GLOBAL.conc_program_id,
3594: request_id => FND_GLOBAL.conc_request_id,
3595: user_id => FND_GLOBAL.login_id,
3596: login_id => FND_GLOBAL.login_id,

Line 3593: prog_id => FND_GLOBAL.conc_program_id,

3589: pro_rtg_flag => p_import_routings,
3590: pro_bom_flag => p_import_bills,
3591: del_rec_flag => p_delete_rows,
3592: prog_appid => FND_GLOBAL.prog_appl_id,
3593: prog_id => FND_GLOBAL.conc_program_id,
3594: request_id => FND_GLOBAL.conc_request_id,
3595: user_id => FND_GLOBAL.login_id,
3596: login_id => FND_GLOBAL.login_id,
3597: p_batch_id => p_batch_id,

Line 3594: request_id => FND_GLOBAL.conc_request_id,

3590: pro_bom_flag => p_import_bills,
3591: del_rec_flag => p_delete_rows,
3592: prog_appid => FND_GLOBAL.prog_appl_id,
3593: prog_id => FND_GLOBAL.conc_program_id,
3594: request_id => FND_GLOBAL.conc_request_id,
3595: user_id => FND_GLOBAL.login_id,
3596: login_id => FND_GLOBAL.login_id,
3597: p_batch_id => p_batch_id,
3598: err_text => x_err_buffer);

Line 3595: user_id => FND_GLOBAL.login_id,

3591: del_rec_flag => p_delete_rows,
3592: prog_appid => FND_GLOBAL.prog_appl_id,
3593: prog_id => FND_GLOBAL.conc_program_id,
3594: request_id => FND_GLOBAL.conc_request_id,
3595: user_id => FND_GLOBAL.login_id,
3596: login_id => FND_GLOBAL.login_id,
3597: p_batch_id => p_batch_id,
3598: err_text => x_err_buffer);
3599:

Line 3596: login_id => FND_GLOBAL.login_id,

3592: prog_appid => FND_GLOBAL.prog_appl_id,
3593: prog_id => FND_GLOBAL.conc_program_id,
3594: request_id => FND_GLOBAL.conc_request_id,
3595: user_id => FND_GLOBAL.login_id,
3596: login_id => FND_GLOBAL.login_id,
3597: p_batch_id => p_batch_id,
3598: err_text => x_err_buffer);
3599:
3600: IF ( l_return_code = 0 ) THEN