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

Line 2328: l_short_name := 'AMS' || FND_GLOBAL.LOGIN_ID || 'IMP' || p_import_list_header_id;

2324: -- For SQL*Loader programs, the executable file name is equivalent to the
2325: -- control file. The field "Executable" on the screen is the same as "program"
2326: -- in the API. We will use the short name for both program and program short name.
2327: --
2328: l_short_name := 'AMS' || FND_GLOBAL.LOGIN_ID || 'IMP' || p_import_list_header_id;
2329: x_import_list_header_id := p_import_list_header_id;
2330: x_hz_dup_check := fnd_profile.value('AMS_HZ_DEDUPE_RULE');
2331: if x_hz_dup_check <> 'Y' then
2332: x_hz_dup_check := 'N';

Line 7331: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

7327: )
7328: VALUES
7329: (
7330: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
7331: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7332: SYSDATE, -- LAST_UPDATE_DATE,
7333: SYSDATE, -- CREATION_DATE,
7334: FND_GLOBAL.User_ID, -- CREATED_BY,
7335: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 7334: FND_GLOBAL.User_ID, -- CREATED_BY,

7330: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
7331: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7332: SYSDATE, -- LAST_UPDATE_DATE,
7333: SYSDATE, -- CREATION_DATE,
7334: FND_GLOBAL.User_ID, -- CREATED_BY,
7335: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
7336: l_import_source_line_id(i),
7337: l_import_list_header_id(i),
7338: 'LEAD', -- IMPORT_TYPE,

Line 7335: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

7331: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7332: SYSDATE, -- LAST_UPDATE_DATE,
7333: SYSDATE, -- CREATION_DATE,
7334: FND_GLOBAL.User_ID, -- CREATED_BY,
7335: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
7336: l_import_source_line_id(i),
7337: l_import_list_header_id(i),
7338: 'LEAD', -- IMPORT_TYPE,
7339: 'E', -- ERROR_TYPE,

Line 7633: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

7629: )
7630: VALUES
7631: (
7632: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
7633: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7634: SYSDATE, -- LAST_UPDATE_DATE,
7635: SYSDATE, -- CREATION_DATE,
7636: FND_GLOBAL.User_ID, -- CREATED_BY,
7637: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 7636: FND_GLOBAL.User_ID, -- CREATED_BY,

7632: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
7633: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7634: SYSDATE, -- LAST_UPDATE_DATE,
7635: SYSDATE, -- CREATION_DATE,
7636: FND_GLOBAL.User_ID, -- CREATED_BY,
7637: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
7638: x_import_source_line_id,
7639: x_import_list_header_id,
7640: 'LEAD', -- IMPORT_TYPE,

Line 7637: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

7633: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7634: SYSDATE, -- LAST_UPDATE_DATE,
7635: SYSDATE, -- CREATION_DATE,
7636: FND_GLOBAL.User_ID, -- CREATED_BY,
7637: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
7638: x_import_source_line_id,
7639: x_import_list_header_id,
7640: 'LEAD', -- IMPORT_TYPE,
7641: 'E', -- ERROR_TYPE,

Line 8042: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

8038: )
8039: VALUES
8040: (
8041: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
8042: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8043: SYSDATE, -- LAST_UPDATE_DATE,
8044: SYSDATE, -- CREATION_DATE,
8045: FND_GLOBAL.User_ID, -- CREATED_BY,
8046: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 8045: FND_GLOBAL.User_ID, -- CREATED_BY,

8041: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
8042: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8043: SYSDATE, -- LAST_UPDATE_DATE,
8044: SYSDATE, -- CREATION_DATE,
8045: FND_GLOBAL.User_ID, -- CREATED_BY,
8046: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
8047: p_import_source_line_id,
8048: p_import_list_header_id,
8049: 'LEAD', -- IMPORT_TYPE,

Line 8046: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

8042: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8043: SYSDATE, -- LAST_UPDATE_DATE,
8044: SYSDATE, -- CREATION_DATE,
8045: FND_GLOBAL.User_ID, -- CREATED_BY,
8046: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
8047: p_import_source_line_id,
8048: p_import_list_header_id,
8049: 'LEAD', -- IMPORT_TYPE,
8050: 'E', -- ERROR_TYPE,

Line 8236: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

8232: )
8233: values
8234: (
8235: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
8236: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8237: SYSDATE, -- LAST_UPDATE_DATE,
8238: SYSDATE, -- CREATION_DATE,
8239: FND_GLOBAL.User_ID, -- CREATED_BY,
8240: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 8239: FND_GLOBAL.User_ID, -- CREATED_BY,

8235: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
8236: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8237: SYSDATE, -- LAST_UPDATE_DATE,
8238: SYSDATE, -- CREATION_DATE,
8239: FND_GLOBAL.User_ID, -- CREATED_BY,
8240: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
8241: 'E',
8242: l_batch_id,
8243: I_imp_list_header_id(i),

Line 8240: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

8236: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8237: SYSDATE, -- LAST_UPDATE_DATE,
8238: SYSDATE, -- CREATION_DATE,
8239: FND_GLOBAL.User_ID, -- CREATED_BY,
8240: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
8241: 'E',
8242: l_batch_id,
8243: I_imp_list_header_id(i),
8244: I_imp_source_line_id(i),

Line 10847: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

10843: )
10844: VALUES
10845: (
10846: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
10847: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
10848: SYSDATE, -- LAST_UPDATE_DATE,
10849: SYSDATE, -- CREATION_DATE,
10850: FND_GLOBAL.User_ID, -- CREATED_BY,
10851: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 10850: FND_GLOBAL.User_ID, -- CREATED_BY,

10846: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
10847: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
10848: SYSDATE, -- LAST_UPDATE_DATE,
10849: SYSDATE, -- CREATION_DATE,
10850: FND_GLOBAL.User_ID, -- CREATED_BY,
10851: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
10852: l_import_source_line_id(i),
10853: l_import_list_header_id(i),
10854: l_imp_type, -- 'CUSTOMER', -- IMPORT_TYPE,

Line 10851: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

10847: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
10848: SYSDATE, -- LAST_UPDATE_DATE,
10849: SYSDATE, -- CREATION_DATE,
10850: FND_GLOBAL.User_ID, -- CREATED_BY,
10851: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
10852: l_import_source_line_id(i),
10853: l_import_list_header_id(i),
10854: l_imp_type, -- 'CUSTOMER', -- IMPORT_TYPE,
10855: 'E', -- ERROR_TYPE,

Line 15685: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

15681: )
15682: VALUES
15683: (
15684: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
15685: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
15686: SYSDATE, -- LAST_UPDATE_DATE,
15687: SYSDATE, -- CREATION_DATE,
15688: FND_GLOBAL.User_ID, -- CREATED_BY,
15689: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 15688: FND_GLOBAL.User_ID, -- CREATED_BY,

15684: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
15685: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
15686: SYSDATE, -- LAST_UPDATE_DATE,
15687: SYSDATE, -- CREATION_DATE,
15688: FND_GLOBAL.User_ID, -- CREATED_BY,
15689: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
15690: l_import_source_line_id(i),
15691: l_import_list_header_id(i),
15692: 'EVENT', -- IMPORT_TYPE,

Line 15689: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

15685: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
15686: SYSDATE, -- LAST_UPDATE_DATE,
15687: SYSDATE, -- CREATION_DATE,
15688: FND_GLOBAL.User_ID, -- CREATED_BY,
15689: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
15690: l_import_source_line_id(i),
15691: l_import_list_header_id(i),
15692: 'EVENT', -- IMPORT_TYPE,
15693: 'E', -- ERROR_TYPE,

Line 17821: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

17817: )
17818: VALUES
17819: (
17820: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,
17821: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
17822: SYSDATE, -- LAST_UPDATE_DATE,
17823: SYSDATE, -- CREATION_DATE,
17824: FND_GLOBAL.User_ID, -- CREATED_BY,
17825: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 17824: FND_GLOBAL.User_ID, -- CREATED_BY,

17820: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,
17821: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
17822: SYSDATE, -- LAST_UPDATE_DATE,
17823: SYSDATE, -- CREATION_DATE,
17824: FND_GLOBAL.User_ID, -- CREATED_BY,
17825: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
17826: 'N',
17827: '1',
17828: p_import_list_header_id,

Line 17825: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

17821: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
17822: SYSDATE, -- LAST_UPDATE_DATE,
17823: SYSDATE, -- CREATION_DATE,
17824: FND_GLOBAL.User_ID, -- CREATED_BY,
17825: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
17826: 'N',
17827: '1',
17828: p_import_list_header_id,
17829: 'ACTIVE',

Line 18175: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

18171: )
18172: VALUES
18173: (
18174: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,
18175: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
18176: SYSDATE, -- LAST_UPDATE_DATE,
18177: SYSDATE, -- CREATION_DATE,
18178: FND_GLOBAL.User_ID, -- CREATED_BY,
18179: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

Line 18178: FND_GLOBAL.User_ID, -- CREATED_BY,

18174: ams_imp_source_lines_s.nextval, -- IMPORT_SOURCE_LINE_ID,
18175: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
18176: SYSDATE, -- LAST_UPDATE_DATE,
18177: SYSDATE, -- CREATION_DATE,
18178: FND_GLOBAL.User_ID, -- CREATED_BY,
18179: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
18180: 'N',
18181: '1',
18182: p_import_list_header_id,

Line 18179: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

18175: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
18176: SYSDATE, -- LAST_UPDATE_DATE,
18177: SYSDATE, -- CREATION_DATE,
18178: FND_GLOBAL.User_ID, -- CREATED_BY,
18179: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,
18180: 'N',
18181: '1',
18182: p_import_list_header_id,
18183: 'ACTIVE',

Line 18436: l_last_updated_by := FND_GLOBAL.user_id; --LEADS_US

18432: l_source_object_code := nvl(p_source_object_code,'PARTY');
18433: l_note_status := 'I';
18434: l_note_type := 'AS_USER';
18435: l_last_update_date := SYSDATE;
18436: l_last_updated_by := FND_GLOBAL.user_id; --LEADS_US
18437: l_last_update_login := FND_GLOBAL.conc_login_id; --LEADS_US
18438: l_jtf_note_id := null;
18439: --============================================================
18440: --== SET THE API VARIABLE VALUES ===

Line 18437: l_last_update_login := FND_GLOBAL.conc_login_id; --LEADS_US

18433: l_note_status := 'I';
18434: l_note_type := 'AS_USER';
18435: l_last_update_date := SYSDATE;
18436: l_last_updated_by := FND_GLOBAL.user_id; --LEADS_US
18437: l_last_update_login := FND_GLOBAL.conc_login_id; --LEADS_US
18438: l_jtf_note_id := null;
18439: --============================================================
18440: --== SET THE API VARIABLE VALUES ===
18441: --============================================================

Line 18446: l_created_by := FND_GLOBAL.user_id; --LEADS_US

18442: l_source_object_id := p_party_id;
18443: l_notes := p_note_text;
18444: l_notes_detail := p_note_text;
18445: l_creation_date := sysdate;
18446: l_created_by := FND_GLOBAL.user_id; --LEADS_US
18447: l_entered_date := sysdate;
18448: l_entered_by := FND_GLOBAL.user_id; --LEADS_US
18449:
18450:

Line 18448: l_entered_by := FND_GLOBAL.user_id; --LEADS_US

18444: l_notes_detail := p_note_text;
18445: l_creation_date := sysdate;
18446: l_created_by := FND_GLOBAL.user_id; --LEADS_US
18447: l_entered_date := sysdate;
18448: l_entered_by := FND_GLOBAL.user_id; --LEADS_US
18449:
18450:
18451: --============================================================
18452: --== CALL THE API to create a note ===

Line 21377: l_resp_id NUMBER := FND_GLOBAL.resp_id;

21373: l_import_type VARCHAR2(30);
21374: l_user_id NUMBER;
21375: l_vendor_id NUMBER;
21376: l_lang_encoding VARCHAR2(30);
21377: l_resp_id NUMBER := FND_GLOBAL.resp_id;
21378: l_error_code VARCHAR2(1);
21379: l_error_text VARCHAR2(4000);
21380: l_user_status_id NUMBER;
21381: