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.GL_CRM_UTILITIES_PKG dependencies on FND_FILE

Line 22: fnd_file.put_line(fnd_file.output, ' ');

18: -------------------------------------------------------------------
19: PROCEDURE print_report_title IS
20: c_text_files VARCHAR2(200);
21: BEGIN
22: fnd_file.put_line(fnd_file.output, ' ');
23: fnd_message.set_name('SQLGL', 'CRM0023');
24: c_text_files :=
25: RPAD(fnd_message.get || ' '
26: || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MM:SS'),

Line 33: fnd_file.put_line(fnd_file.output, c_text_files);

29: c_text_files := c_text_files || LPAD(fnd_message.get, 48, ' ');
30: fnd_message.set_name('SQLGL', 'CRM0024');
31: c_text_files :=
32: c_text_files || LPAD(fnd_message.get || ' ' || page_count, 49, ' ');
33: fnd_file.put_line(fnd_file.output, c_text_files);
34: page_line_count := page_line_count + 2;
35: END print_report_title;
36:
37: -------------------------------------------------------------------

Line 41: fnd_file.put_line(fnd_file.output, ' ');

37: -------------------------------------------------------------------
38: PROCEDURE print_validation_failure IS
39: c_text_files VARCHAR2(200);
40: BEGIN
41: fnd_file.put_line(fnd_file.output, ' ');
42: fnd_file.put_line(fnd_file.output, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0026');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get

Line 42: fnd_file.put_line(fnd_file.output, ' ');

38: PROCEDURE print_validation_failure IS
39: c_text_files VARCHAR2(200);
40: BEGIN
41: fnd_file.put_line(fnd_file.output, ' ');
42: fnd_file.put_line(fnd_file.output, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0026');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));

Line 44: fnd_file.put_line(fnd_file.output,

40: BEGIN
41: fnd_file.put_line(fnd_file.output, ' ');
42: fnd_file.put_line(fnd_file.output, ' ');
43: fnd_message.set_name('SQLGL', 'CRM0026');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');

Line 47: fnd_file.put_line(fnd_file.output, ' ');

43: fnd_message.set_name('SQLGL', 'CRM0026');
44: fnd_file.put_line(fnd_file.output,
45: LPAD(' ', 45, '=') || fnd_message.get
46: || RPAD(' ', 45, '='));
47: fnd_file.put_line(fnd_file.output, ' ');
48: fnd_message.set_name('SQLGL', 'CRM0032');
49: c_text_files := RPAD(fnd_message.get, 31, ' ');
50: fnd_message.set_name('SQLGL', 'CRM0033');
51: c_text_files := c_text_files || RPAD(fnd_message.get, 15, ' ');

Line 64: fnd_file.put_line(fnd_file.output, c_text_files);

60: fnd_message.set_name('SQLGL', 'CRM0038');
61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
64: fnd_file.put_line(fnd_file.output, c_text_files);
65: fnd_file.put_line(fnd_file.output,
66: LPAD(' ', 31, '-') || LPAD(' ', 15, '-')
67: || LPAD(' ', 15, '-') || LPAD(' ', 16, '-')
68: || LPAD(' ', 16, '-') || LPAD(' ', 13, '-')

Line 65: fnd_file.put_line(fnd_file.output,

61: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
62: fnd_message.set_name('SQLGL', 'CRM0039');
63: c_text_files := c_text_files || RPAD(fnd_message.get, 14, ' ');
64: fnd_file.put_line(fnd_file.output, c_text_files);
65: fnd_file.put_line(fnd_file.output,
66: LPAD(' ', 31, '-') || LPAD(' ', 15, '-')
67: || LPAD(' ', 15, '-') || LPAD(' ', 16, '-')
68: || LPAD(' ', 16, '-') || LPAD(' ', 13, '-')
69: || LPAD(' ', 13, '-') || LPAD('-', 14, '-'));

Line 77: fnd_file.put_line(fnd_file.output, ' ');

73: -------------------------------------------------------------------
74: PROCEDURE print_delete_user_rate_warning IS
75: c_text_files VARCHAR2(200);
76: BEGIN
77: fnd_file.put_line(fnd_file.output, ' ');
78: fnd_file.put_line(fnd_file.output, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0027');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get

Line 78: fnd_file.put_line(fnd_file.output, ' ');

74: PROCEDURE print_delete_user_rate_warning IS
75: c_text_files VARCHAR2(200);
76: BEGIN
77: fnd_file.put_line(fnd_file.output, ' ');
78: fnd_file.put_line(fnd_file.output, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0027');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));

Line 80: fnd_file.put_line(fnd_file.output,

76: BEGIN
77: fnd_file.put_line(fnd_file.output, ' ');
78: fnd_file.put_line(fnd_file.output, ' ');
79: fnd_message.set_name('SQLGL', 'CRM0027');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');

Line 83: fnd_file.put_line(fnd_file.output, ' ');

79: fnd_message.set_name('SQLGL', 'CRM0027');
80: fnd_file.put_line(fnd_file.output,
81: LPAD(' ', 45, '=') || fnd_message.get
82: || RPAD(' ', 46, '='));
83: fnd_file.put_line(fnd_file.output, ' ');
84: fnd_message.set_name('SQLGL', 'CRM0032');
85: c_text_files := RPAD(fnd_message.get, 31, ' ');
86: fnd_message.set_name('SQLGL', 'CRM0040');
87: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');

Line 96: fnd_file.put_line(fnd_file.output, c_text_files);

92: fnd_message.set_name('SQLGL', 'CRM0037');
93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
96: fnd_file.put_line(fnd_file.output, c_text_files);
97: fnd_file.put_line(fnd_file.output,
98: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
99: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
100: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));

Line 97: fnd_file.put_line(fnd_file.output,

93: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
94: fnd_message.set_name('SQLGL', 'CRM0041');
95: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
96: fnd_file.put_line(fnd_file.output, c_text_files);
97: fnd_file.put_line(fnd_file.output,
98: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
99: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
100: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));
101: page_line_count := page_line_count + 6;

Line 108: fnd_file.put_line(fnd_file.output, ' ');

104: -------------------------------------------------------------------
105: PROCEDURE print_override_user_rate_warn IS
106: c_text_files VARCHAR2(200);
107: BEGIN
108: fnd_file.put_line(fnd_file.output, ' ');
109: fnd_file.put_line(fnd_file.output, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0028');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get

Line 109: fnd_file.put_line(fnd_file.output, ' ');

105: PROCEDURE print_override_user_rate_warn IS
106: c_text_files VARCHAR2(200);
107: BEGIN
108: fnd_file.put_line(fnd_file.output, ' ');
109: fnd_file.put_line(fnd_file.output, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0028');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));

Line 111: fnd_file.put_line(fnd_file.output,

107: BEGIN
108: fnd_file.put_line(fnd_file.output, ' ');
109: fnd_file.put_line(fnd_file.output, ' ');
110: fnd_message.set_name('SQLGL', 'CRM0028');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');

Line 114: fnd_file.put_line(fnd_file.output, ' ');

110: fnd_message.set_name('SQLGL', 'CRM0028');
111: fnd_file.put_line(fnd_file.output,
112: LPAD(' ', 45, '=') || fnd_message.get
113: || RPAD(' ', 46, '='));
114: fnd_file.put_line(fnd_file.output, ' ');
115: fnd_message.set_name('SQLGL', 'CRM0032');
116: c_text_files := RPAD(fnd_message.get, 31, ' ');
117: fnd_message.set_name('SQLGL', 'CRM0040');
118: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');

Line 127: fnd_file.put_line(fnd_file.output, c_text_files);

123: fnd_message.set_name('SQLGL', 'CRM0037');
124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
127: fnd_file.put_line(fnd_file.output, c_text_files);
128: fnd_file.put_line(fnd_file.output,
129: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
130: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
131: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));

Line 128: fnd_file.put_line(fnd_file.output,

124: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
125: fnd_message.set_name('SQLGL', 'CRM0041');
126: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
127: fnd_file.put_line(fnd_file.output, c_text_files);
128: fnd_file.put_line(fnd_file.output,
129: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
130: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
131: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));
132: page_line_count := page_line_count + 6;

Line 139: fnd_file.put_line(fnd_file.output, ' ');

135: -------------------------------------------------------------------
136: PROCEDURE print_delete_sys_rate_warning IS
137: c_text_files VARCHAR2(200);
138: BEGIN
139: fnd_file.put_line(fnd_file.output, ' ');
140: fnd_file.put_line(fnd_file.output, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0029');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get

Line 140: fnd_file.put_line(fnd_file.output, ' ');

136: PROCEDURE print_delete_sys_rate_warning IS
137: c_text_files VARCHAR2(200);
138: BEGIN
139: fnd_file.put_line(fnd_file.output, ' ');
140: fnd_file.put_line(fnd_file.output, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0029');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));

Line 142: fnd_file.put_line(fnd_file.output,

138: BEGIN
139: fnd_file.put_line(fnd_file.output, ' ');
140: fnd_file.put_line(fnd_file.output, ' ');
141: fnd_message.set_name('SQLGL', 'CRM0029');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');

Line 145: fnd_file.put_line(fnd_file.output, ' ');

141: fnd_message.set_name('SQLGL', 'CRM0029');
142: fnd_file.put_line(fnd_file.output,
143: LPAD(' ', 43, '=') || fnd_message.get
144: || RPAD(' ', 44, '='));
145: fnd_file.put_line(fnd_file.output, ' ');
146: fnd_message.set_name('SQLGL', 'CRM0032');
147: c_text_files := RPAD(fnd_message.get, 31, ' ');
148: fnd_message.set_name('SQLGL', 'CRM0040');
149: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');

Line 158: fnd_file.put_line(fnd_file.output, c_text_files);

154: fnd_message.set_name('SQLGL', 'CRM0037');
155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
158: fnd_file.put_line(fnd_file.output, c_text_files);
159: fnd_file.put_line(fnd_file.output,
160: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
161: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
162: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));

Line 159: fnd_file.put_line(fnd_file.output,

155: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
156: fnd_message.set_name('SQLGL', 'CRM0041');
157: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
158: fnd_file.put_line(fnd_file.output, c_text_files);
159: fnd_file.put_line(fnd_file.output,
160: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
161: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
162: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));
163: page_line_count := page_line_count + 6;

Line 170: fnd_file.put_line(fnd_file.output, ' ');

166: -------------------------------------------------------------------
167: PROCEDURE print_override_sys_rate_warn IS
168: c_text_files VARCHAR2(200);
169: BEGIN
170: fnd_file.put_line(fnd_file.output, ' ');
171: fnd_file.put_line(fnd_file.output, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0030');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get

Line 171: fnd_file.put_line(fnd_file.output, ' ');

167: PROCEDURE print_override_sys_rate_warn IS
168: c_text_files VARCHAR2(200);
169: BEGIN
170: fnd_file.put_line(fnd_file.output, ' ');
171: fnd_file.put_line(fnd_file.output, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0030');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));

Line 173: fnd_file.put_line(fnd_file.output,

169: BEGIN
170: fnd_file.put_line(fnd_file.output, ' ');
171: fnd_file.put_line(fnd_file.output, ' ');
172: fnd_message.set_name('SQLGL', 'CRM0030');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');

Line 176: fnd_file.put_line(fnd_file.output, ' ');

172: fnd_message.set_name('SQLGL', 'CRM0030');
173: fnd_file.put_line(fnd_file.output,
174: LPAD(' ', 43, '=') || fnd_message.get
175: || RPAD(' ', 44, '='));
176: fnd_file.put_line(fnd_file.output, ' ');
177: fnd_message.set_name('SQLGL', 'CRM0032');
178: c_text_files := RPAD(fnd_message.get, 31, ' ');
179: fnd_message.set_name('SQLGL', 'CRM0040');
180: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');

Line 189: fnd_file.put_line(fnd_file.output, c_text_files);

185: fnd_message.set_name('SQLGL', 'CRM0037');
186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
189: fnd_file.put_line(fnd_file.output, c_text_files);
190: fnd_file.put_line(fnd_file.output,
191: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
192: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
193: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));

Line 190: fnd_file.put_line(fnd_file.output,

186: c_text_files := c_text_files || LPAD(fnd_message.get || ' ', 13, ' ');
187: fnd_message.set_name('SQLGL', 'CRM0041');
188: c_text_files := c_text_files || RPAD(fnd_message.get, 26, ' ');
189: fnd_file.put_line(fnd_file.output, c_text_files);
190: fnd_file.put_line(fnd_file.output,
191: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
192: || LPAD(' ', 16, '-') || LPAD(' ', 16, '-')
193: || LPAD(' ', 13, '-') || LPAD('-', 26, '-'));
194: page_line_count := page_line_count + 6;

Line 201: fnd_file.put_line(fnd_file.output, ' ');

197: -------------------------------------------------------------------
198: PROCEDURE print_missing_pivot_rate IS
199: c_text_files VARCHAR2(200);
200: BEGIN
201: fnd_file.put_line(fnd_file.output, ' ');
202: fnd_file.put_line(fnd_file.output, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0031');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get

Line 202: fnd_file.put_line(fnd_file.output, ' ');

198: PROCEDURE print_missing_pivot_rate IS
199: c_text_files VARCHAR2(200);
200: BEGIN
201: fnd_file.put_line(fnd_file.output, ' ');
202: fnd_file.put_line(fnd_file.output, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0031');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));

Line 204: fnd_file.put_line(fnd_file.output,

200: BEGIN
201: fnd_file.put_line(fnd_file.output, ' ');
202: fnd_file.put_line(fnd_file.output, ' ');
203: fnd_message.set_name('SQLGL', 'CRM0031');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');

Line 207: fnd_file.put_line(fnd_file.output, ' ');

203: fnd_message.set_name('SQLGL', 'CRM0031');
204: fnd_file.put_line(fnd_file.output,
205: LPAD(' ', 51, '=') || fnd_message.get
206: || RPAD(' ', 51, '='));
207: fnd_file.put_line(fnd_file.output, ' ');
208: fnd_message.set_name('SQLGL', 'CRM0032');
209: c_text_files := RPAD(fnd_message.get, 31, ' ');
210: fnd_message.set_name('SQLGL', 'CRM0040');
211: c_text_files := c_text_files || RPAD(fnd_message.get, 30, ' ');

Line 216: fnd_file.put_line(fnd_file.output, c_text_files);

212: fnd_message.set_name('SQLGL', 'CRM0042');
213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
216: fnd_file.put_line(fnd_file.output, c_text_files);
217: fnd_file.put_line(fnd_file.output,
218: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
219: || LPAD(' ', 16, '-') || LPAD('-', 16, '-'));
220: page_line_count := page_line_count + 6;

Line 217: fnd_file.put_line(fnd_file.output,

213: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
214: fnd_message.set_name('SQLGL', 'CRM0043');
215: c_text_files := c_text_files || RPAD(fnd_message.get, 16, ' ');
216: fnd_file.put_line(fnd_file.output, c_text_files);
217: fnd_file.put_line(fnd_file.output,
218: LPAD(' ', 31, '-') || LPAD(' ', 30, '-')
219: || LPAD(' ', 16, '-') || LPAD('-', 16, '-'));
220: page_line_count := page_line_count + 6;
221: END print_missing_pivot_rate;

Line 226: fnd_file.put_line(fnd_file.output, ' ');

222:
223: -------------------------------------------------------------------
224: PROCEDURE print_validation_failure_codes IS
225: BEGIN
226: fnd_file.put_line(fnd_file.output, ' ');
227: fnd_file.put_line(fnd_file.output, ' ');
228: fnd_message.set_name('SQLGL', 'CRM0022');
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get

Line 227: fnd_file.put_line(fnd_file.output, ' ');

223: -------------------------------------------------------------------
224: PROCEDURE print_validation_failure_codes IS
225: BEGIN
226: fnd_file.put_line(fnd_file.output, ' ');
227: fnd_file.put_line(fnd_file.output, ' ');
228: fnd_message.set_name('SQLGL', 'CRM0022');
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));

Line 229: fnd_file.put_line(fnd_file.output,

225: BEGIN
226: fnd_file.put_line(fnd_file.output, ' ');
227: fnd_file.put_line(fnd_file.output, ' ');
228: fnd_message.set_name('SQLGL', 'CRM0022');
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');

Line 232: fnd_file.put_line(fnd_file.output, ' ');

228: fnd_message.set_name('SQLGL', 'CRM0022');
229: fnd_file.put_line(fnd_file.output,
230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');

Line 234: fnd_file.put_line(fnd_file.output, fnd_message.get);

230: LPAD(' ', 61, '=') || fnd_message.get
231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');

Line 235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));

231: || RPAD(' ', 61, '='));
232: fnd_file.put_line(fnd_file.output, ' ');
233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);

Line 237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);

233: fnd_message.set_name('SQLGL', 'CRM0021');
234: fnd_file.put_line(fnd_file.output, fnd_message.get);
235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);

Line 239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);

235: fnd_file.put_line(fnd_file.output, RPAD('-', 133, '-'));
236: fnd_message.set_name('SQLGL', 'CRM0007');
237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);

Line 241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);

237: fnd_file.put_line(fnd_file.output, ' VF01 ' || fnd_message.get);
238: fnd_message.set_name('SQLGL', 'CRM0008');
239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);

Line 243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);

239: fnd_file.put_line(fnd_file.output, ' VF02 ' || fnd_message.get);
240: fnd_message.set_name('SQLGL', 'CRM0009');
241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);

Line 245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);

241: fnd_file.put_line(fnd_file.output, ' VF03 ' || fnd_message.get);
242: fnd_message.set_name('SQLGL', 'CRM0010');
243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);

Line 247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);

243: fnd_file.put_line(fnd_file.output, ' VF04 ' || fnd_message.get);
244: fnd_message.set_name('SQLGL', 'CRM0011');
245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);

Line 249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);

245: fnd_file.put_line(fnd_file.output, ' VF05 ' || fnd_message.get);
246: fnd_message.set_name('SQLGL', 'CRM0012');
247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);

Line 251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);

247: fnd_file.put_line(fnd_file.output, ' VF06 ' || fnd_message.get);
248: fnd_message.set_name('SQLGL', 'CRM0013');
249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);

Line 253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);

249: fnd_file.put_line(fnd_file.output, ' VF07 ' || fnd_message.get);
250: fnd_message.set_name('SQLGL', 'CRM0014');
251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);

Line 255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);

251: fnd_file.put_line(fnd_file.output, ' VF08 ' || fnd_message.get);
252: fnd_message.set_name('SQLGL', 'CRM0015');
253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);

Line 257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);

253: fnd_file.put_line(fnd_file.output, ' VF09 ' || fnd_message.get);
254: fnd_message.set_name('SQLGL', 'CRM0016');
255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);

Line 259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);

255: fnd_file.put_line(fnd_file.output, ' VF10 ' || fnd_message.get);
256: fnd_message.set_name('SQLGL', 'CRM0017');
257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);

Line 261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);

257: fnd_file.put_line(fnd_file.output, ' VF11 ' || fnd_message.get);
258: fnd_message.set_name('SQLGL', 'CRM0018');
259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);

Line 263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);

259: fnd_file.put_line(fnd_file.output, ' VF12 ' || fnd_message.get);
260: fnd_message.set_name('SQLGL', 'CRM0019');
261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
266: END print_validation_failure_codes;
267:

Line 265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);

261: fnd_file.put_line(fnd_file.output, ' VF13 ' || fnd_message.get);
262: fnd_message.set_name('SQLGL', 'CRM0020');
263: fnd_file.put_line(fnd_file.output, ' VF14 ' || fnd_message.get);
264: fnd_message.set_name('SQLGL', 'CRM0044');
265: fnd_file.put_line(fnd_file.output, ' VF15 ' || fnd_message.get);
266: END print_validation_failure_codes;
267:
268: -------------------------------------------------------------------
269: PROCEDURE insert_cross_rate_set(

Line 816: fnd_file.put_line(fnd_file.LOG,

812: AND dr.conversion_date BETWEEN ri.from_conversion_date
813: AND ri.to_conversion_date)));
814:
815: IF DEBUG_MODE THEN
816: fnd_file.put_line(fnd_file.LOG,
817: SQL%ROWCOUNT || ' Error records');
818: END IF;
819:
820: BEGIN

Line 840: fnd_file.put_line

836: WHERE inverse_conversion_rate IS NULL AND conversion_rate > 0
837: AND batch_number = l_batch_number;
838:
839: IF DEBUG_MODE THEN
840: fnd_file.put_line
841: (fnd_file.LOG,
842: 'Finish Validation on GL_DAILY_RATES_INTERFACE table.');
843: END IF;
844:

Line 841: (fnd_file.LOG,

837: AND batch_number = l_batch_number;
838:
839: IF DEBUG_MODE THEN
840: fnd_file.put_line
841: (fnd_file.LOG,
842: 'Finish Validation on GL_DAILY_RATES_INTERFACE table.');
843: END IF;
844:
845: SELECT from_currency,

Line 888: fnd_file.put_line

884: gl_crm_utilities_pkg.print_validation_failure;
885: END IF;
886:
887: page_line_count := page_line_count + 1;
888: fnd_file.put_line
889: (fnd_file.output,
890: RPAD(daily_rate_validation_failure.r_type(i), 31, ' ')
891: || RPAD(daily_rate_validation_failure.r_from_date(i), 15,
892: ' ')

Line 889: (fnd_file.output,

885: END IF;
886:
887: page_line_count := page_line_count + 1;
888: fnd_file.put_line
889: (fnd_file.output,
890: RPAD(daily_rate_validation_failure.r_type(i), 31, ' ')
891: || RPAD(daily_rate_validation_failure.r_from_date(i), 15,
892: ' ')
893: || RPAD(daily_rate_validation_failure.r_to_date(i), 15,

Line 911: fnd_file.put_line(fnd_file.output, ' ');

907:
908: IF page_line_count >= page_line_numbers - 2 THEN
909: page_line_count := 1;
910: page_count := page_count + 1;
911: fnd_file.put_line(fnd_file.output, ' ');
912: fnd_file.put_line(fnd_file.output, ' ');
913: END IF;
914: END LOOP;
915:

Line 912: fnd_file.put_line(fnd_file.output, ' ');

908: IF page_line_count >= page_line_numbers - 2 THEN
909: page_line_count := 1;
910: page_count := page_count + 1;
911: fnd_file.put_line(fnd_file.output, ' ');
912: fnd_file.put_line(fnd_file.output, ' ');
913: END IF;
914: END LOOP;
915:
916: IF DEBUG_MODE THEN

Line 918: fnd_file.put_line(fnd_file.LOG, 'No Validation Failure.');

914: END LOOP;
915:
916: IF DEBUG_MODE THEN
917: IF page_count * page_line_count = 1 THEN
918: fnd_file.put_line(fnd_file.LOG, 'No Validation Failure.');
919: ELSE
920: fnd_file.put_line(fnd_file.LOG,
921: page_count * page_line_count - 1
922: || ' rows failed validation.');

Line 920: fnd_file.put_line(fnd_file.LOG,

916: IF DEBUG_MODE THEN
917: IF page_count * page_line_count = 1 THEN
918: fnd_file.put_line(fnd_file.LOG, 'No Validation Failure.');
919: ELSE
920: fnd_file.put_line(fnd_file.LOG,
921: page_count * page_line_count - 1
922: || ' rows failed validation.');
923: END IF;
924: END IF;

Line 941: fnd_file.put_line

937: END IF;
938:
939: IF (golden_rule_flag = 'SYSTEM') OR(golden_rule_flag = 'BOTH') THEN
940: IF DEBUG_MODE THEN
941: fnd_file.put_line
942: (fnd_file.LOG,
943: 'Searching system rates that cannot be override.');
944: END IF;
945:

Line 942: (fnd_file.LOG,

938:
939: IF (golden_rule_flag = 'SYSTEM') OR(golden_rule_flag = 'BOTH') THEN
940: IF DEBUG_MODE THEN
941: fnd_file.put_line
942: (fnd_file.LOG,
943: 'Searching system rates that cannot be override.');
944: END IF;
945:
946: /*********************************************************************************

Line 983: fnd_file.put_line

979: AND ri.batch_number = l_batch_number;
980:
981: IF DEBUG_MODE THEN
982: IF sys_daily_rate_cannot_delete.r_from_curr.COUNT > 0 THEN
983: fnd_file.put_line
984: (fnd_file.LOG,
985: sys_daily_rate_cannot_delete.r_from_curr.COUNT
986: || ' system rates found (which cannot be deleted)!');
987: ELSE

Line 984: (fnd_file.LOG,

980:
981: IF DEBUG_MODE THEN
982: IF sys_daily_rate_cannot_delete.r_from_curr.COUNT > 0 THEN
983: fnd_file.put_line
984: (fnd_file.LOG,
985: sys_daily_rate_cannot_delete.r_from_curr.COUNT
986: || ' system rates found (which cannot be deleted)!');
987: ELSE
988: fnd_file.put_line

Line 988: fnd_file.put_line

984: (fnd_file.LOG,
985: sys_daily_rate_cannot_delete.r_from_curr.COUNT
986: || ' system rates found (which cannot be deleted)!');
987: ELSE
988: fnd_file.put_line
989: (fnd_file.LOG,
990: 'No system rate found (which cannot be deleted)!');
991: END IF;
992: END IF;

Line 989: (fnd_file.LOG,

985: sys_daily_rate_cannot_delete.r_from_curr.COUNT
986: || ' system rates found (which cannot be deleted)!');
987: ELSE
988: fnd_file.put_line
989: (fnd_file.LOG,
990: 'No system rate found (which cannot be deleted)!');
991: END IF;
992: END IF;
993:

Line 1003: fnd_file.put_line

999: gl_crm_utilities_pkg.print_delete_user_rate_warning;
1000: END IF;
1001:
1002: page_line_count := page_line_count + 1;
1003: fnd_file.put_line
1004: (fnd_file.output,
1005: RPAD(sys_daily_rate_cannot_delete.r_type(i), 31, ' ')
1006: || RPAD
1007: (sys_daily_rate_cannot_delete.r_conversion_date(i),

Line 1004: (fnd_file.output,

1000: END IF;
1001:
1002: page_line_count := page_line_count + 1;
1003: fnd_file.put_line
1004: (fnd_file.output,
1005: RPAD(sys_daily_rate_cannot_delete.r_type(i), 31, ' ')
1006: || RPAD
1007: (sys_daily_rate_cannot_delete.r_conversion_date(i),
1008: 30, ' ')

Line 1022: fnd_file.put_line(fnd_file.output, ' ');

1018:
1019: IF page_line_count >= page_line_numbers - 2 THEN
1020: page_line_count := 1;
1021: page_count := page_count + 1;
1022: fnd_file.put_line(fnd_file.output, ' ');
1023: fnd_file.put_line(fnd_file.output, ' ');
1024: END IF;
1025: END LOOP;
1026:

Line 1023: fnd_file.put_line(fnd_file.output, ' ');

1019: IF page_line_count >= page_line_numbers - 2 THEN
1020: page_line_count := 1;
1021: page_count := page_count + 1;
1022: fnd_file.put_line(fnd_file.output, ' ');
1023: fnd_file.put_line(fnd_file.output, ' ');
1024: END IF;
1025: END LOOP;
1026:
1027: /*********************************************************************************

Line 1074: fnd_file.put_line

1070: gl_crm_utilities_pkg.print_override_user_rate_warn;
1071: END IF;
1072:
1073: page_line_count := page_line_count + 1;
1074: fnd_file.put_line
1075: (fnd_file.output,
1076: RPAD(sys_daily_rate_cannot_override.r_type(i), 31, ' ')
1077: || RPAD
1078: (sys_daily_rate_cannot_override.r_conversion_date(i),

Line 1075: (fnd_file.output,

1071: END IF;
1072:
1073: page_line_count := page_line_count + 1;
1074: fnd_file.put_line
1075: (fnd_file.output,
1076: RPAD(sys_daily_rate_cannot_override.r_type(i), 31, ' ')
1077: || RPAD
1078: (sys_daily_rate_cannot_override.r_conversion_date(i),
1079: 30, ' ')

Line 1093: fnd_file.put_line(fnd_file.output, ' ');

1089:
1090: IF page_line_count >= page_line_numbers - 2 THEN
1091: page_line_count := 1;
1092: page_count := page_count + 1;
1093: fnd_file.put_line(fnd_file.output, ' ');
1094: fnd_file.put_line(fnd_file.output, ' ');
1095: END IF;
1096: END LOOP;
1097:

Line 1094: fnd_file.put_line(fnd_file.output, ' ');

1090: IF page_line_count >= page_line_numbers - 2 THEN
1091: page_line_count := 1;
1092: page_count := page_count + 1;
1093: fnd_file.put_line(fnd_file.output, ' ');
1094: fnd_file.put_line(fnd_file.output, ' ');
1095: END IF;
1096: END LOOP;
1097:
1098: IF DEBUG_MODE THEN

Line 1099: fnd_file.put_line

1095: END IF;
1096: END LOOP;
1097:
1098: IF DEBUG_MODE THEN
1099: fnd_file.put_line
1100: (fnd_file.LOG,
1101: 'Ended finding system rates that cannot be override.');
1102: END IF;
1103: END IF;

Line 1100: (fnd_file.LOG,

1096: END LOOP;
1097:
1098: IF DEBUG_MODE THEN
1099: fnd_file.put_line
1100: (fnd_file.LOG,
1101: 'Ended finding system rates that cannot be override.');
1102: END IF;
1103: END IF;
1104:

Line 1146: fnd_file.put_line

1142:
1143: END;
1144:
1145: IF DEBUG_MODE THEN
1146: fnd_file.put_line
1147: (fnd_file.LOG,
1148: 'Marking D for rates meant to delete with types used for ab translation');
1149: END IF;
1150:

Line 1147: (fnd_file.LOG,

1143: END;
1144:
1145: IF DEBUG_MODE THEN
1146: fnd_file.put_line
1147: (fnd_file.LOG,
1148: 'Marking D for rates meant to delete with types used for ab translation');
1149: END IF;
1150:
1151: UPDATE gl_daily_rates dr

Line 1202: fnd_file.put_line(fnd_file.LOG,

1198: );
1199:
1200: -- Delete existing rows with conversion rate in GL_DAILY_RATES
1201: IF DEBUG_MODE THEN
1202: fnd_file.put_line(fnd_file.LOG,
1203: SQL%ROWCOUNT || ' rows marked');
1204: fnd_file.put_line
1205: (fnd_file.LOG,
1206: 'Deleting rates meant for insert and for deleted rates with types not used for ab translation');

Line 1204: fnd_file.put_line

1200: -- Delete existing rows with conversion rate in GL_DAILY_RATES
1201: IF DEBUG_MODE THEN
1202: fnd_file.put_line(fnd_file.LOG,
1203: SQL%ROWCOUNT || ' rows marked');
1204: fnd_file.put_line
1205: (fnd_file.LOG,
1206: 'Deleting rates meant for insert and for deleted rates with types not used for ab translation');
1207: END IF;
1208:

Line 1205: (fnd_file.LOG,

1201: IF DEBUG_MODE THEN
1202: fnd_file.put_line(fnd_file.LOG,
1203: SQL%ROWCOUNT || ' rows marked');
1204: fnd_file.put_line
1205: (fnd_file.LOG,
1206: 'Deleting rates meant for insert and for deleted rates with types not used for ab translation');
1207: END IF;
1208:
1209: DELETE gl_daily_rates dr

Line 1260: fnd_file.put_line(fnd_file.LOG,

1256: + 1
1257: );
1258:
1259: IF DEBUG_MODE THEN
1260: fnd_file.put_line(fnd_file.LOG,
1261: SQL%ROWCOUNT || ' rows deleted');
1262: END IF;
1263:
1264: BEGIN

Line 1267: fnd_file.put_line(fnd_file.LOG, 'Insert all rates.');

1263:
1264: BEGIN
1265: -- Insert all rows with conversion rate
1266: IF DEBUG_MODE THEN
1267: fnd_file.put_line(fnd_file.LOG, 'Insert all rates.');
1268: END IF;
1269:
1270: INSERT INTO gl_daily_rates
1271: (from_currency, to_currency, conversion_date,

Line 1346: fnd_file.put_line(fnd_file.LOG,

1342: TRUNC(ri.from_conversion_date)
1343: + rm.multiplier - 1);
1344:
1345: IF DEBUG_MODE THEN
1346: fnd_file.put_line(fnd_file.LOG,
1347: SQL%ROWCOUNT || ' rows inserted');
1348: END IF;
1349:
1350: EXCEPTION

Line 1371: fnd_file.put_line

1367: p_parameter_name3 => 'ERROR_MESSAGE',
1368: p_parameter_value3 => l_error_message
1369: );
1370:
1371: fnd_file.put_line
1372: (fnd_file.LOG,
1373: 'Error: Duplicate Row or Overlapping Date Range found.');
1374: fnd_file.put_line
1375: (fnd_file.output,

Line 1372: (fnd_file.LOG,

1368: p_parameter_value3 => l_error_message
1369: );
1370:
1371: fnd_file.put_line
1372: (fnd_file.LOG,
1373: 'Error: Duplicate Row or Overlapping Date Range found.');
1374: fnd_file.put_line
1375: (fnd_file.output,
1376: 'Error: Duplicate Row or Overlapping Date Range found.');

Line 1374: fnd_file.put_line

1370:
1371: fnd_file.put_line
1372: (fnd_file.LOG,
1373: 'Error: Duplicate Row or Overlapping Date Range found.');
1374: fnd_file.put_line
1375: (fnd_file.output,
1376: 'Error: Duplicate Row or Overlapping Date Range found.');
1377: set_completion_status_result :=
1378: fnd_concurrent.set_completion_status

Line 1375: (fnd_file.output,

1371: fnd_file.put_line
1372: (fnd_file.LOG,
1373: 'Error: Duplicate Row or Overlapping Date Range found.');
1374: fnd_file.put_line
1375: (fnd_file.output,
1376: 'Error: Duplicate Row or Overlapping Date Range found.');
1377: set_completion_status_result :=
1378: fnd_concurrent.set_completion_status
1379: ('ERROR',

Line 1385: fnd_file.put_line(fnd_file.LOG, 'Firing Business events');

1381: END;
1382:
1383: -- Bug 4758732 JVARKEY Call to raise Business Events
1384: IF DEBUG_MODE THEN
1385: fnd_file.put_line(fnd_file.LOG, 'Firing Business events');
1386: END IF;
1387:
1388: FOR dri_rec in raise_buz_events LOOP
1389:

Line 1412: fnd_file.put_line(fnd_file.LOG,

1408: AND rownum < 2;
1409:
1410: IF DEBUG_MODE THEN
1411: IF rows_need_calculation = 0 THEN
1412: fnd_file.put_line(fnd_file.LOG,
1413: 'NO need cross rate calculation.');
1414: ELSE
1415: fnd_file.put_line(fnd_file.LOG,
1416: 'Cross rates calculation needed.');

Line 1415: fnd_file.put_line(fnd_file.LOG,

1411: IF rows_need_calculation = 0 THEN
1412: fnd_file.put_line(fnd_file.LOG,
1413: 'NO need cross rate calculation.');
1414: ELSE
1415: fnd_file.put_line(fnd_file.LOG,
1416: 'Cross rates calculation needed.');
1417: END IF;
1418: END IF;
1419:

Line 1436: fnd_file.put_line(fnd_file.LOG, 'Clean gl_cross_rate_temp.');

1432: gl_message.func_ent('Cross Rates Calculation');
1433:
1434: -- select all the lines who can be calculate cross rate from the gl_daily_rates table
1435: IF DEBUG_MODE THEN
1436: fnd_file.put_line(fnd_file.LOG, 'Clean gl_cross_rate_temp.');
1437: END IF;
1438:
1439: DELETE FROM gl_cross_rate_temp;
1440:

Line 1442: fnd_file.put_line

1438:
1439: DELETE FROM gl_cross_rate_temp;
1440:
1441: IF DEBUG_MODE THEN
1442: fnd_file.put_line
1443: (fnd_file.LOG,
1444: 'Copy rows from interface table to gl_cross_rate_temp.');
1445: END IF;
1446:

Line 1443: (fnd_file.LOG,

1439: DELETE FROM gl_cross_rate_temp;
1440:
1441: IF DEBUG_MODE THEN
1442: fnd_file.put_line
1443: (fnd_file.LOG,
1444: 'Copy rows from interface table to gl_cross_rate_temp.');
1445: END IF;
1446:
1447: INSERT INTO gl_cross_rate_temp

Line 1507: fnd_file.put_line(fnd_file.LOG, 'Update the used for ab translation');

1503: AND glcrsd.to_currency <> glcrs.pivot_currency
1504: AND gldri.batch_number = l_batch_number;
1505:
1506: IF DEBUG_MODE THEN
1507: fnd_file.put_line(fnd_file.LOG, 'Update the used for ab translation');
1508: END IF;
1509:
1510: UPDATE gl_cross_rate_temp ri
1511: SET used_for_ab_translation =

Line 1553: fnd_file.put_line

1549:
1550: IF ((golden_rule_flag = 'USER') OR(golden_rule_flag = 'BOTH')) THEN
1551: -- user defined rates overrides, user defined rates rules
1552: IF DEBUG_MODE THEN
1553: fnd_file.put_line
1554: (fnd_file.LOG,
1555: 'User Rate Rule or Both Rule; Checking if any user-defined rates cannot been cross-deleted.');
1556: END IF;
1557:

Line 1554: (fnd_file.LOG,

1550: IF ((golden_rule_flag = 'USER') OR(golden_rule_flag = 'BOTH')) THEN
1551: -- user defined rates overrides, user defined rates rules
1552: IF DEBUG_MODE THEN
1553: fnd_file.put_line
1554: (fnd_file.LOG,
1555: 'User Rate Rule or Both Rule; Checking if any user-defined rates cannot been cross-deleted.');
1556: END IF;
1557:
1558: SELECT DISTINCT gldr.from_currency,

Line 1607: fnd_file.put_line

1603: gl_crm_utilities_pkg.print_delete_sys_rate_warning;
1604: END IF;
1605:
1606: page_line_count := page_line_count + 1;
1607: fnd_file.put_line
1608: (fnd_file.output,
1609: RPAD(usr_daily_rate_cannot_delete.r_type(i), 31, ' ')
1610: || RPAD
1611: (usr_daily_rate_cannot_delete.r_conversion_date(i),

Line 1608: (fnd_file.output,

1604: END IF;
1605:
1606: page_line_count := page_line_count + 1;
1607: fnd_file.put_line
1608: (fnd_file.output,
1609: RPAD(usr_daily_rate_cannot_delete.r_type(i), 31, ' ')
1610: || RPAD
1611: (usr_daily_rate_cannot_delete.r_conversion_date(i),
1612: 30, ' ')

Line 1626: fnd_file.put_line(fnd_file.output, ' ');

1622:
1623: IF page_line_count >= page_line_numbers - 2 THEN
1624: page_line_count := 1;
1625: page_count := page_count + 1;
1626: fnd_file.put_line(fnd_file.output, ' ');
1627: fnd_file.put_line(fnd_file.output, ' ');
1628: END IF;
1629: END LOOP;
1630:

Line 1627: fnd_file.put_line(fnd_file.output, ' ');

1623: IF page_line_count >= page_line_numbers - 2 THEN
1624: page_line_count := 1;
1625: page_count := page_count + 1;
1626: fnd_file.put_line(fnd_file.output, ' ');
1627: fnd_file.put_line(fnd_file.output, ' ');
1628: END IF;
1629: END LOOP;
1630:
1631: SELECT DISTINCT gldr.from_currency,

Line 1680: fnd_file.put_line

1676: gl_crm_utilities_pkg.print_override_sys_rate_warn;
1677: END IF;
1678:
1679: page_line_count := page_line_count + 1;
1680: fnd_file.put_line
1681: (fnd_file.output,
1682: RPAD(usr_daily_rate_cannot_override.r_type(i), 31, ' ')
1683: || RPAD
1684: (usr_daily_rate_cannot_override.r_conversion_date

Line 1681: (fnd_file.output,

1677: END IF;
1678:
1679: page_line_count := page_line_count + 1;
1680: fnd_file.put_line
1681: (fnd_file.output,
1682: RPAD(usr_daily_rate_cannot_override.r_type(i), 31, ' ')
1683: || RPAD
1684: (usr_daily_rate_cannot_override.r_conversion_date
1685: (i),

Line 1701: fnd_file.put_line(fnd_file.output, ' ');

1697:
1698: IF page_line_count >= page_line_numbers - 2 THEN
1699: page_line_count := 1;
1700: page_count := page_count + 1;
1701: fnd_file.put_line(fnd_file.output, ' ');
1702: fnd_file.put_line(fnd_file.output, ' ');
1703: END IF;
1704: END LOOP;
1705: END IF;

Line 1702: fnd_file.put_line(fnd_file.output, ' ');

1698: IF page_line_count >= page_line_numbers - 2 THEN
1699: page_line_count := 1;
1700: page_count := page_count + 1;
1701: fnd_file.put_line(fnd_file.output, ' ');
1702: fnd_file.put_line(fnd_file.output, ' ');
1703: END IF;
1704: END LOOP;
1705: END IF;
1706:

Line 1709: fnd_file.put_line

1705: END IF;
1706:
1707: -- if golden rule as user override, that's user rates rile, we can only delete SYSTEM rates
1708: IF DEBUG_MODE THEN
1709: fnd_file.put_line
1710: (fnd_file.LOG,
1711: 'Mark D for Cross Rates');
1712: END IF;
1713:

Line 1710: (fnd_file.LOG,

1706:
1707: -- if golden rule as user override, that's user rates rile, we can only delete SYSTEM rates
1708: IF DEBUG_MODE THEN
1709: fnd_file.put_line
1710: (fnd_file.LOG,
1711: 'Mark D for Cross Rates');
1712: END IF;
1713:
1714: -- For each row with conversion rate in

Line 1773: fnd_file.put_line(fnd_file.LOG,

1769: + 1
1770: );
1771:
1772: IF DEBUG_MODE THEN
1773: fnd_file.put_line(fnd_file.LOG,
1774: SQL%ROWCOUNT || ' rows marked.');
1775: fnd_file.put_line
1776: (fnd_file.LOG,
1777: 'Delete for Cross Rates');

Line 1775: fnd_file.put_line

1771:
1772: IF DEBUG_MODE THEN
1773: fnd_file.put_line(fnd_file.LOG,
1774: SQL%ROWCOUNT || ' rows marked.');
1775: fnd_file.put_line
1776: (fnd_file.LOG,
1777: 'Delete for Cross Rates');
1778: END IF;
1779:

Line 1776: (fnd_file.LOG,

1772: IF DEBUG_MODE THEN
1773: fnd_file.put_line(fnd_file.LOG,
1774: SQL%ROWCOUNT || ' rows marked.');
1775: fnd_file.put_line
1776: (fnd_file.LOG,
1777: 'Delete for Cross Rates');
1778: END IF;
1779:
1780: DELETE FROM gl_daily_rates gldr

Line 1841: fnd_file.put_line(fnd_file.LOG,

1837: + 1
1838: );
1839:
1840: IF DEBUG_MODE THEN
1841: fnd_file.put_line(fnd_file.LOG,
1842: SQL%ROWCOUNT || ' rows deleted.');
1843: END IF;
1844:
1845: UPDATE gl_cross_rate_temp rt

Line 1863: fnd_file.put_line(fnd_file.LOG,

1859: AND rt.to_conversion_date));
1860:
1861: BEGIN
1862: IF DEBUG_MODE THEN
1863: fnd_file.put_line(fnd_file.LOG,
1864: 'creating all cross rates ....');
1865: END IF;
1866:
1867: INSERT INTO gl_daily_rates

Line 1963: fnd_file.put_line(fnd_file.LOG,

1959: + glrm.multiplier - 1));
1960:
1961:
1962: IF DEBUG_MODE THEN
1963: fnd_file.put_line(fnd_file.LOG,
1964: SQL%ROWCOUNT || ' rows inserted.');
1965: END IF;
1966: EXCEPTION
1967: WHEN OTHERS THEN

Line 1988: fnd_file.put_line

1984: p_parameter_value3 => l_error_message
1985: );
1986:
1987: gl_message.write_log('CRM0002', 0);
1988: fnd_file.put_line
1989: (fnd_file.LOG,
1990: 'Error: Duplicate Row or Overlapping Date Range found.');
1991: fnd_file.put_line
1992: (fnd_file.output,

Line 1989: (fnd_file.LOG,

1985: );
1986:
1987: gl_message.write_log('CRM0002', 0);
1988: fnd_file.put_line
1989: (fnd_file.LOG,
1990: 'Error: Duplicate Row or Overlapping Date Range found.');
1991: fnd_file.put_line
1992: (fnd_file.output,
1993: 'Error: Duplicate Row or Overlapping Date Range found.');

Line 1991: fnd_file.put_line

1987: gl_message.write_log('CRM0002', 0);
1988: fnd_file.put_line
1989: (fnd_file.LOG,
1990: 'Error: Duplicate Row or Overlapping Date Range found.');
1991: fnd_file.put_line
1992: (fnd_file.output,
1993: 'Error: Duplicate Row or Overlapping Date Range found.');
1994: set_completion_status_result :=
1995: fnd_concurrent.set_completion_status

Line 1992: (fnd_file.output,

1988: fnd_file.put_line
1989: (fnd_file.LOG,
1990: 'Error: Duplicate Row or Overlapping Date Range found.');
1991: fnd_file.put_line
1992: (fnd_file.output,
1993: 'Error: Duplicate Row or Overlapping Date Range found.');
1994: set_completion_status_result :=
1995: fnd_concurrent.set_completion_status
1996: ('ERROR',

Line 2012: fnd_file.put_line(fnd_file.LOG,

2008:
2009: -- Launch the Rate Change Program if needed
2010: IF (l_launch_rate_change = 'Y') THEN
2011:
2012: fnd_file.put_line(fnd_file.LOG,
2013: 'Launching Rate Change Program');
2014:
2015:
2016: RESULT := fnd_request.set_mode(TRUE);