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

Line 969: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

965: fetch party_mapped into G_PARTY_MAPPED;
966: close party_mapped;
967:
968: -- FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
969: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
970: AMS_Utility_PVT.Create_Log (
971: x_return_status => l_return_status,
972: p_arc_log_used_by => G_ARC_IMPORT_HEADER,
973: p_log_used_by_id => p_import_list_header_id,

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

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

Line 7332: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 7335: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 7336: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 7634: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 7637: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 7638: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 8043: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 8046: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 8047: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 8237: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 8240: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 8241: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 10848: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 10851: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 10852: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 15686: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 15689: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 15690: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 17822: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 17825: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 17826: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

Line 18176: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,

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

Line 18179: FND_GLOBAL.User_ID, -- CREATED_BY,

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

Line 18180: FND_GLOBAL.Conc_Login_ID, -- LAST_UPDATE_LOGIN,

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

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

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

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

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

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

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

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

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

Line 21378: l_resp_id NUMBER := FND_GLOBAL.resp_id;

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