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.PER_FI_POSTALCODE_UPLOAD dependencies on HR_UTILITY

Line 87: hr_utility.set_location(l_location,4);

83: THEN
84: -- error : I/O directory not defined
85: RAISE e_fatal_error;
86: END IF;
87: hr_utility.set_location(l_location,4);
88: -- Open flat file
89: l_file_type := UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
90:
91: LOOP

Line 95: hr_utility.set_location ( ' line ' || l_line_read, 10);

91: LOOP
92: BEGIN
93:
94: UTL_FILE.get_line (l_file_type, l_line_read);
95: hr_utility.set_location ( ' line ' || l_line_read, 10);
96: l_batch_seq := l_batch_seq + 1;
97: READ_RECORD(l_line_read);
98:
99: IF MOD (l_batch_seq, c_commit_point) = 0

Line 114: hr_utility.set_message (800, 'HR_376627_FI_INVALID_RECORD');

110: retcode := c_warning;
111:
112: -- Set the application error
113:
114: hr_utility.set_message (800, 'HR_376627_FI_INVALID_RECORD');
115: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
116: hr_utility.set_message_token (800, 'LINE', l_line_read);
117:
118: -- Write the message to log file, do not raise an application error but continue

Line 115: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);

111:
112: -- Set the application error
113:
114: hr_utility.set_message (800, 'HR_376627_FI_INVALID_RECORD');
115: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
116: hr_utility.set_message_token (800, 'LINE', l_line_read);
117:
118: -- Write the message to log file, do not raise an application error but continue
119: -- (with next line)

Line 116: hr_utility.set_message_token (800, 'LINE', l_line_read);

112: -- Set the application error
113:
114: hr_utility.set_message (800, 'HR_376627_FI_INVALID_RECORD');
115: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
116: hr_utility.set_message_token (800, 'LINE', l_line_read);
117:
118: -- Write the message to log file, do not raise an application error but continue
119: -- (with next line)
120:

Line 121: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

117:
118: -- Write the message to log file, do not raise an application error but continue
119: -- (with next line)
120:
121: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
122:
123:
124: WHEN e_empty_line THEN
125: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 130: hr_utility.set_message (800, 'HR_376626_FI_EMPTY_LINE');

126: retcode := c_warning;
127:
128: -- Set the application error
129:
130: hr_utility.set_message (800, 'HR_376626_FI_EMPTY_LINE');
131: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
132:
133:
134: -- Write the message to log file, do not raise an application error but continue

Line 131: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);

127:
128: -- Set the application error
129:
130: hr_utility.set_message (800, 'HR_376626_FI_EMPTY_LINE');
131: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
132:
133:
134: -- Write the message to log file, do not raise an application error but continue
135: -- (with next line)

Line 137: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

133:
134: -- Write the message to log file, do not raise an application error but continue
135: -- (with next line)
136:
137: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
138:
139:
140: END;
141:

Line 156: hr_utility.set_location (g_proc, 270);

152: THEN
153: UTL_FILE.fclose (l_file_type);
154: END IF;
155:
156: hr_utility.set_location (g_proc, 270);
157:
158: -- Set retcode to 2, indicating an ERROR to the ConcMgr
159: retcode := c_error;
160:

Line 162: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');

158: -- Set retcode to 2, indicating an ERROR to the ConcMgr
159: retcode := c_error;
160:
161: -- Set the application error
162: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
163:
164: -- Return the message to the ConcMgr (This msg will appear in the log file)
165: errbuf := hr_utility.get_message;
166:

Line 165: errbuf := hr_utility.get_message;

161: -- Set the application error
162: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
163:
164: -- Return the message to the ConcMgr (This msg will appear in the log file)
165: errbuf := hr_utility.get_message;
166:
167: WHEN UTL_FILE.invalid_operation
168: -- File could not be opened as requested, because of operating system permissions
169: -- Also raised when attempting a write operation on a file opened for read.

Line 177: hr_utility.set_location (g_proc, 280);

173: THEN
174: UTL_FILE.fclose (l_file_type);
175: END IF;
176:
177: hr_utility.set_location (g_proc, 280);
178: retcode := c_error;
179: errbuf := 'Reading File ('||l_location ||' -> ' || l_filename || ') - Invalid Operation.';
180: WHEN UTL_FILE.internal_error
181: -- Unspecified internal error

Line 188: hr_utility.set_location (g_proc, 290);

184: THEN
185: UTL_FILE.fclose (l_file_type);
186: END IF;
187:
188: hr_utility.set_location (g_proc, 290);
189: retcode := c_error;
190: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Internal Error.';
191:
192: WHEN UTL_FILE.invalid_mode

Line 200: hr_utility.set_location (g_proc, 300);

196: THEN
197: UTL_FILE.fclose (l_file_type);
198: END IF;
199:
200: hr_utility.set_location (g_proc, 300);
201: retcode := c_error;
202: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Invalid Mode.';
203:
204: WHEN UTL_FILE.invalid_path

Line 214: hr_utility.set_location (g_proc, 310);

210: END IF;
211:
212: retcode := c_error;
213: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Invalid Path or Filename.';
214: hr_utility.set_location (g_proc, 310);
215:
216: WHEN UTL_FILE.invalid_filehandle
217: -- File type does not specify an open file
218: THEN

Line 224: hr_utility.set_location (g_proc, 320);

220: THEN
221: UTL_FILE.fclose (l_file_type);
222: END IF;
223:
224: hr_utility.set_location (g_proc, 320);
225: retcode := c_error;
226: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Invalid File Type.';
227: WHEN UTL_FILE.read_error
228:

Line 236: hr_utility.set_location (g_proc, 330);

232: THEN
233: UTL_FILE.fclose (l_file_type);
234: END IF;
235:
236: hr_utility.set_location (g_proc, 330);
237: retcode := c_error;
238: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Read Error.';
239:
240:

Line 288: hr_utility.set_location ( ' code '||l_code , 20);

284:
285: g_meaning:=rtrim(substr(p_line,19,30))||' '||'/'||' '||rtrim(substr(p_line,49,30));
286:
287: /* if Trace switched ON this wud give us the value read */
288: hr_utility.set_location ( ' code '||l_code , 20);
289: hr_utility.set_location ( ' desc '||l_description , 30);
290: end if;
291:
292: END IF;

Line 289: hr_utility.set_location ( ' desc '||l_description , 30);

285: g_meaning:=rtrim(substr(p_line,19,30))||' '||'/'||' '||rtrim(substr(p_line,49,30));
286:
287: /* if Trace switched ON this wud give us the value read */
288: hr_utility.set_location ( ' code '||l_code , 20);
289: hr_utility.set_location ( ' desc '||l_description , 30);
290: end if;
291:
292: END IF;
293: