APPS.GL_CI_DATA_TRANSFER_PKG dependencies on FND_GLOBAL

Line 7: nl CONSTANT varchar2(1) := fnd_global.local_chr(10);

3: own CONSTANT varchar2(30) := 'GL';
4: appSchema CONSTANT varchar2(30) := 'APPS';
5: EMAIL_CONTACT_NOT_SET number := -5;
6: CONTACT_INFO_NOT_FOUND Number := -4;
7: nl CONSTANT varchar2(1) := fnd_global.local_chr(10);
8: j_import_menu_name varchar2(30) := 'GL_SU_J_IMPORT';
9: j_post_menu_name varchar2(30) := 'GL_SU_JOURNAL';
10: i_parallel_name varchar2(30) := 'GL_CONS_INTERFACE_';
11: TYPE t_RefCur IS REF CURSOR;

Line 38: if message_string = fnd_global.local_chr(10) then

34: begin
35: msg_text := substr(message_string, 1, 32000);
36: new_line := 0;
37: if verbose_mode then
38: if message_string = fnd_global.local_chr(10) then
39: FND_FILE.put(which_file, message_string);
40: else
41: while msg_text is not null loop
42: new_line := instr(msg_text, fnd_global.local_chr(10));

Line 42: new_line := instr(msg_text, fnd_global.local_chr(10));

38: if message_string = fnd_global.local_chr(10) then
39: FND_FILE.put(which_file, message_string);
40: else
41: while msg_text is not null loop
42: new_line := instr(msg_text, fnd_global.local_chr(10));
43: if new_line = 0 then new_line := line_size;
44: elsif new_line > line_size then new_line := line_size;
45: end if;
46: --DBMS_OUTPUT.put_line( substr(msg_text, 1, new_line-1) );

Line 60: new_line := instr(msg_text, fnd_global.local_chr(10));

56: --+ without initializing user_id, resp_id, login_resp_id.
57: --+ dbms_output.enable(1000000);
58: while msg_text is not null loop
59: --+can not use chr(10) any more, can not use dbms_output any more
60: new_line := instr(msg_text, fnd_global.local_chr(10));
61: if new_line = 0 then new_line := line_size;
62: elsif new_line > line_size then new_line := line_size;
63: end if;
64: raise_application_error(-20000, substr(msg_text, 1, new_line-1));

Line 87: if message_string = fnd_global.local_chr(10) then

83: begin
84: msg_text := substr(message_string, 1, 32000);
85: new_line := 0;
86: if verbose_mode then
87: if message_string = fnd_global.local_chr(10) then
88: FND_FILE.put(which_file, message_string);
89: else
90: while msg_text is not null loop
91: new_line := instr(msg_text, fnd_global.local_chr(10));

Line 91: new_line := instr(msg_text, fnd_global.local_chr(10));

87: if message_string = fnd_global.local_chr(10) then
88: FND_FILE.put(which_file, message_string);
89: else
90: while msg_text is not null loop
91: new_line := instr(msg_text, fnd_global.local_chr(10));
92: if new_line = 0 then new_line := line_size;
93: elsif new_line > line_size then new_line := line_size;
94: end if;
95: --DBMS_OUTPUT.put_line( substr(msg_text, 1, new_line-1) );

Line 109: new_line := instr(msg_text, fnd_global.local_chr(10));

105: --+ without initializing user_id, resp_id, login_resp_id.
106: --+ dbms_output.enable(1000000);
107: while msg_text is not null loop
108: --+can not use chr(10) any more, can not use dbms_output any more
109: new_line := instr(msg_text, fnd_global.local_chr(10));
110: if new_line = 0 then new_line := line_size;
111: elsif new_line > line_size then new_line := line_size;
112: end if;
113: raise_application_error(-20000, substr(msg_text, 1, new_line-1));

Line 885: -- l_user_name := fnd_global.USER_NAME; --bug#2543150, remove username from input

881: end if;
882: --make sure the same user exists in the target db
883: l_app_id := 101;
884: l_user_name := 'LEDGER';
885: -- l_user_name := fnd_global.USER_NAME; --bug#2543150, remove username from input
886: v_SQL1 := 'BEGIN ' || ':num := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_Login_Ids@' || l_temp_db ||
887: '(:1, :2, :3, :4);' || ' END;';
888: EXECUTE IMMEDIATE v_SQL1 USING OUT l_error_code, IN l_user_name, IN p_resp_name, OUT l_user_id, OUT l_resp_id;
889: if l_error_code = 1 then

Line 1100: l_user_name := fnd_global.USER_NAME; --bug#2543150, remove username

1096: debug_message('Section number is ' || section_number,TRUE);
1097: -- Turn trace on if process is run in debug mode
1098: EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';
1099: end if;
1100: l_user_name := fnd_global.USER_NAME; --bug#2543150, remove username
1101: --from Remote Option form
1102: v_SQL1 := 'BEGIN '||' :a := ' || applSysSchema ||'.GL_CI_REMOTE_INVOKE_PKG.Get_User_ID@' || dblink
1103: || '(:user_name)' ||';'||' END;';
1104: EXECUTE IMMEDIATE v_SQL1 USING OUT l_user_id, IN l_user_name;