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_NO_POSTALCODE_UPLOAD dependencies on HR_UTILITY

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

56: THEN
57: -- error : I/O directory not defined
58: RAISE e_fatal_error;
59: END IF;
60: hr_utility.set_location(l_location,4);
61: l_file_extension := substr(l_file_name,-4);
62: IF l_file_extension <> '.txt' THEN
63: RAISE UTL_FILE.invalid_filehandle;
64: END IF;

Line 65: hr_utility.set_location('file type ok',4);

61: l_file_extension := substr(l_file_name,-4);
62: IF l_file_extension <> '.txt' THEN
63: RAISE UTL_FILE.invalid_filehandle;
64: END IF;
65: hr_utility.set_location('file type ok',4);
66: -- Open flat file
67: l_file_type := UTL_FILE.fopen (l_location, l_file_name, c_read_file, c_max_linesize);
68:
69: LOOP

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

69: LOOP
70: BEGIN
71:
72: UTL_FILE.get_line (l_file_type, l_line_read);
73: hr_utility.set_location ( ' line ' || l_line_read, 10);
74: l_batch_seq := l_batch_seq + 1;
75: hr_utility.set_location('call read record',4);
76: read_record(l_line_read);
77: hr_utility.set_location('read record done',4);

Line 75: hr_utility.set_location('call read record',4);

71:
72: UTL_FILE.get_line (l_file_type, l_line_read);
73: hr_utility.set_location ( ' line ' || l_line_read, 10);
74: l_batch_seq := l_batch_seq + 1;
75: hr_utility.set_location('call read record',4);
76: read_record(l_line_read);
77: hr_utility.set_location('read record done',4);
78:
79: IF MOD (l_batch_seq, c_commit_point) = 0 THEN

Line 77: hr_utility.set_location('read record done',4);

73: hr_utility.set_location ( ' line ' || l_line_read, 10);
74: l_batch_seq := l_batch_seq + 1;
75: hr_utility.set_location('call read record',4);
76: read_record(l_line_read);
77: hr_utility.set_location('read record done',4);
78:
79: IF MOD (l_batch_seq, c_commit_point) = 0 THEN
80: COMMIT;
81: END IF;

Line 93: hr_utility.set_message (800, 'HR_376829_NO_INVALID_RECORD');

89: retcode := c_warning;
90:
91: -- Set the application error
92:
93: hr_utility.set_message (800, 'HR_376829_NO_INVALID_RECORD');
94: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
95: hr_utility.set_message_token (800, 'LINE', l_line_read);
96:
97: -- Write the message to log file, do not raise an application error but continue

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

90:
91: -- Set the application error
92:
93: hr_utility.set_message (800, 'HR_376829_NO_INVALID_RECORD');
94: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
95: hr_utility.set_message_token (800, 'LINE', l_line_read);
96:
97: -- Write the message to log file, do not raise an application error but continue
98: -- (with next line)

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

91: -- Set the application error
92:
93: hr_utility.set_message (800, 'HR_376829_NO_INVALID_RECORD');
94: hr_utility.set_message_token (800, 'LINE_NO', l_batch_seq);
95: hr_utility.set_message_token (800, 'LINE', l_line_read);
96:
97: -- Write the message to log file, do not raise an application error but continue
98: -- (with next line)
99:

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

96:
97: -- Write the message to log file, do not raise an application error but continue
98: -- (with next line)
99:
100: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
101:
102: END;
103:
104: END LOOP ;

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

119: -- Set retcode to 2, indicating an ERROR to the ConcMgr
120: retcode := c_error;
121:
122: -- Set the application error
123: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
124:
125: -- Return the message to the ConcMgr (This msg will appear in the log file)
126: errbuf := hr_utility.get_message;
127:

Line 126: errbuf := hr_utility.get_message;

122: -- Set the application error
123: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
124:
125: -- Return the message to the ConcMgr (This msg will appear in the log file)
126: errbuf := hr_utility.get_message;
127:
128:
129: WHEN UTL_FILE.invalid_operation
130: -- File could not be opened as requested, perhaps because of operating system permissions

Line 140: hr_utility.set_location (l_proc, 220);

136: THEN
137: UTL_FILE.fclose (l_file_type);
138: END IF;
139:
140: hr_utility.set_location (l_proc, 220);
141: retcode := c_error;
142: errbuf := 'Reading File ('||l_location ||' -> '
143: || l_file_name
144: || ') - Invalid Operation.';

Line 153: hr_utility.set_location (l_proc, 230);

149: THEN
150: UTL_FILE.fclose (l_file_type);
151: END IF;
152:
153: hr_utility.set_location (l_proc, 230);
154: retcode := c_error;
155: errbuf := 'Reading File ('
156: || l_location
157: || ' -> '

Line 169: hr_utility.set_location (l_proc, 240);

165: THEN
166: UTL_FILE.fclose (l_file_type);
167: END IF;
168:
169: hr_utility.set_location (l_proc, 240);
170: retcode := c_error;
171: errbuf := 'Reading File ('
172: || l_location
173: || ' -> '

Line 191: hr_utility.set_location (l_proc, 250);

187: || l_location
188: || ' -> '
189: || l_file_name
190: || ') - Invalid Path or Filename.';
191: hr_utility.set_location (l_proc, 250);
192:
193: WHEN UTL_FILE.invalid_filehandle
194: -- File type does not specify an open file
195: THEN

Line 201: hr_utility.set_location (l_proc, 260);

197: THEN
198: UTL_FILE.fclose (l_file_type);
199: END IF;
200:
201: hr_utility.set_location (l_proc, 260);
202: retcode := c_error;
203: errbuf := 'Reading File ('
204: || l_location
205: || ' -> '

Line 217: hr_utility.set_location (l_proc, 270);

213: THEN
214: UTL_FILE.fclose (l_file_type);
215: END IF;
216:
217: hr_utility.set_location (l_proc, 270);
218: retcode := c_error;
219: errbuf := 'Reading File ('
220: || l_location
221: || ' -> '

Line 242: hr_utility.set_location ( ' bg id '||g_bg_id, 20);

238: l_view_application_id := 3;
239: update_flag :='N';
240: l_line := rtrim(p_line);
241:
242: hr_utility.set_location ( ' bg id '||g_bg_id, 20);
243: begin
244: select SECURITY_GROUP_ID into l_security_group_id from per_business_groups where business_group_id = g_bg_id;
245: exception
246: when others then

Line 251: hr_utility.set_location ( ' l_line '||l_line , 20);

247: l_security_group_id := 0;
248: end;
249:
250:
251: hr_utility.set_location ( ' l_line '||l_line , 20);
252: if l_line is NULL then
253: null;
254: else
255: l_line := p_line;

Line 258: hr_utility.set_location ( ' l_lookup_code '||l_lookup_code , 20);

254: else
255: l_line := p_line;
256: l_lookup_code:= substr(l_line,1,4);
257: l_meaning := rtrim(substr(l_line,5,30));
258: hr_utility.set_location ( ' l_lookup_code '||l_lookup_code , 20);
259: if to_number(l_lookup_code) < 1 OR to_number(l_lookup_code) > 9999 OR l_meaning is NULL then
260: raise e_invalid_record;
261: else
262:

Line 269: hr_utility.set_location ( ' code '||l_lookup_code , 20);

265: raise e_invalid_record;
266: else
267: l_meaning:=l_lookup_code ||' ' || rtrim(substr(l_line,5,30));
268: l_description:=NULL;
269: hr_utility.set_location ( ' code '||l_lookup_code , 20);
270: hr_utility.set_location ( ' meaning '||l_meaning , 30);
271: hr_utility.set_location ( ' desc '||l_description , 40);
272:
273:

Line 270: hr_utility.set_location ( ' meaning '||l_meaning , 30);

266: else
267: l_meaning:=l_lookup_code ||' ' || rtrim(substr(l_line,5,30));
268: l_description:=NULL;
269: hr_utility.set_location ( ' code '||l_lookup_code , 20);
270: hr_utility.set_location ( ' meaning '||l_meaning , 30);
271: hr_utility.set_location ( ' desc '||l_description , 40);
272:
273:
274: begin

Line 271: hr_utility.set_location ( ' desc '||l_description , 40);

267: l_meaning:=l_lookup_code ||' ' || rtrim(substr(l_line,5,30));
268: l_description:=NULL;
269: hr_utility.set_location ( ' code '||l_lookup_code , 20);
270: hr_utility.set_location ( ' meaning '||l_meaning , 30);
271: hr_utility.set_location ( ' desc '||l_description , 40);
272:
273:
274: begin
275: select 'Y' INTO update_flag

Line 283: hr_utility.set_location ( ' flag '||update_flag , 40);

279: security_group_id = l_security_group_id and
280: view_application_id = l_view_application_id and
281: language = userenv('LANG');
282:
283: hr_utility.set_location ( ' flag '||update_flag , 40);
284: Exception
285: when NO_DATA_FOUND then
286: null;
287: end;

Line 357: hr_utility.set_location ( ' insert row done', 30);

353: X_LAST_UPDATE_DATE => SYSDATE,
354: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
355: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
356:
357: hr_utility.set_location ( ' insert row done', 30);
358:
359: end insert_row;
360:
361: PROCEDURE update_row

Line 405: hr_utility.set_location ( ' update row done ', 30);

401: X_LAST_UPDATE_DATE => SYSDATE,
402: X_LAST_UPDATED_BY => TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
403: X_LAST_UPDATE_LOGIN => TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')));
404:
405: hr_utility.set_location ( ' update row done ', 30);
406: end update_row;
407:
408: end PER_NO_POSTALCODE_UPLOAD;
409: