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

Line 48: hr_utility.set_location('Entering:'|| l_proc, 10);

44: l_proc varchar2(72) := g_package||'return_legislation_code';
45: --
46: Begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Ensure that all the mandatory parameter are not null
51: --
52: hr_api.mandatory_arg_error

Line 66: hr_utility.set_location(l_proc, 20);

62: -- call to this function. Just return the value in the global
63: -- variable.
64: --
65: l_legislation_code := pe_jei_bus.g_legislation_code;
66: hr_utility.set_location(l_proc, 20);
67: else
68: --
69: -- The ID is different to the last call to this function
70: -- or this is the first call to this function.

Line 83: hr_utility.set_location(l_proc,30);

79: close csr_leg_code;
80: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
81: fnd_message.raise_error;
82: end if;
83: hr_utility.set_location(l_proc,30);
84: --
85: --
86: -- Set the global variables so the values are
87: -- available for the next call to this function.

Line 93: hr_utility.set_location(' Leaving:'|| l_proc, 40);

89: close csr_leg_code;
90: pe_jei_bus.g_job_extra_info_id := p_job_extra_info_id;
91: pe_jei_bus.g_legislation_code := l_legislation_code;
92: end if;
93: hr_utility.set_location(' Leaving:'|| l_proc, 40);
94: return l_legislation_code;
95: end return_legislation_code;
96: --
97:

Line 144: hr_utility.set_location('Entering:'||l_proc, 1);

140: from per_job_info_types jeit
141: where jeit.information_type = code;
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 1);
145: --
146: -- Check mandatory parameters have been set
147: --
148: hr_api.mandatory_arg_error

Line 155: hr_utility.set_location(l_proc, 2);

151: p_argument => 'information_type',
152: p_argument_value => p_information_type
153: );
154: --
155: hr_utility.set_location(l_proc, 2);
156: --
157: -- Check that the ACTIVE_INACTIVE_FLAG of job
158: -- Information type is active.
159: --

Line 164: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

160: open c_job_info_type (p_information_type);
161: fetch c_job_info_type into l_flag;
162: if c_job_info_type%notfound then
163: close c_job_info_type;
164: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
165: hr_utility.raise_error;
166: end if;
167: close c_job_info_type;
168: --

Line 165: hr_utility.raise_error;

161: fetch c_job_info_type into l_flag;
162: if c_job_info_type%notfound then
163: close c_job_info_type;
164: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
165: hr_utility.raise_error;
166: end if;
167: close c_job_info_type;
168: --
169: if l_flag = 'N' then

Line 170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');

166: end if;
167: close c_job_info_type;
168: --
169: if l_flag = 'N' then
170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
171: hr_utility.raise_error;
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 171: hr_utility.raise_error;

167: close c_job_info_type;
168: --
169: if l_flag = 'N' then
170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
171: hr_utility.raise_error;
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 3);
175: --

Line 174: hr_utility.set_location(' Leaving:'||l_proc, 3);

170: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
171: hr_utility.raise_error;
172: end if;
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 3);
175: --
176: End chk_job_info_type;
177: --
178: -- ----------------------------------------------------------------------------

Line 231: hr_utility.set_location('Entering:'||l_proc, 1);

227: -- Bug 2173007, End.
228:
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 1);
232: --
233: -- Check mandatory parameters have been set
234: --
235: hr_api.mandatory_arg_error

Line 241: hr_utility.set_location(l_proc, 2);

237: p_api_name => l_proc,
238: p_argument => 'job_id',
239: p_argument_value => p_job_id
240: );
241: hr_utility.set_location(l_proc, 2);
242: --
243: -- Check that the job_id is in the per_jobs table.
244: --
245: open c_valid_job (p_job_id);

Line 249: hr_utility.set_message(800, 'HR_INV_JOB_ID');

245: open c_valid_job (p_job_id);
246: fetch c_valid_job into l_dummy;
247: if c_valid_job%notfound then
248: close c_valid_job;
249: hr_utility.set_message(800, 'HR_INV_JOB_ID');
250: hr_utility.raise_error;
251: end if;
252: close c_valid_job;
253: --

Line 250: hr_utility.raise_error;

246: fetch c_valid_job into l_dummy;
247: if c_valid_job%notfound then
248: close c_valid_job;
249: hr_utility.set_message(800, 'HR_INV_JOB_ID');
250: hr_utility.raise_error;
251: end if;
252: close c_valid_job;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 254: hr_utility.set_location(' Leaving:'||l_proc, 3);

250: hr_utility.raise_error;
251: end if;
252: close c_valid_job;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 3);
255: --
256: End chk_job_id;
257: --
258: -- ----------------------------------------------------------------------------

Line 312: hr_utility.set_location('Entering:'||l_proc, 5);

308: where information_type = code
309: and job_id = id;
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: open c_multi_occur_flag (p_information_type);
315: fetch c_multi_occur_flag into l_multi_occur_flag;
316: --

Line 322: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');

318: -- chk_information_type should capture this error.
319: --
320: if c_multi_occur_flag%notfound then
321: close c_multi_occur_flag;
322: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
323: hr_utility.raise_error;
324: end if;
325: --
326: close c_multi_occur_flag;

Line 323: hr_utility.raise_error;

319: --
320: if c_multi_occur_flag%notfound then
321: close c_multi_occur_flag;
322: hr_utility.set_message(800, 'HR_INV_INFO_TYPE');
323: hr_utility.raise_error;
324: end if;
325: --
326: close c_multi_occur_flag;
327: --

Line 328: hr_utility.set_location(l_proc, 10);

324: end if;
325: --
326: close c_multi_occur_flag;
327: --
328: hr_utility.set_location(l_proc, 10);
329: --
330: open c_get_row(p_information_type, p_job_id);
331: fetch c_get_row into l_dummy;
332: if c_get_row%notfound then

Line 340: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');

336: end if;
337: close c_get_row;
338: --
339: if l_found_jei and l_multi_occur_flag = 'N' then
340: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
341: hr_utility.raise_error;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 341: hr_utility.raise_error;

337: close c_get_row;
338: --
339: if l_found_jei and l_multi_occur_flag = 'N' then
340: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
341: hr_utility.raise_error;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 15);
345: --

Line 344: hr_utility.set_location(' Leaving:'||l_proc, 15);

340: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
341: hr_utility.raise_error;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 15);
345: --
346: End chk_multiple_occurences_flag;
347: --
348: -- ----------------------------------------------------------------------------

Line 385: hr_utility.set_location('Entering:'||l_proc, 10);

381: l_error exception;
382: l_argument varchar2(30);
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 10);
386: --
387: -- Only proceed with validation if a row exists for
388: -- the current record in the HR Schema
389: --

Line 393: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

389: --
390: if not pe_jei_shd.api_updating
391: (p_job_extra_info_id => p_rec.job_extra_info_id
392: ,p_object_version_number => p_rec.object_version_number) then
393: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
394: hr_utility.set_message_token('PROCEDURE', l_proc);
395: hr_utility.set_message_token('STEP', '20');
396: end if;
397: --

Line 394: hr_utility.set_message_token('PROCEDURE', l_proc);

390: if not pe_jei_shd.api_updating
391: (p_job_extra_info_id => p_rec.job_extra_info_id
392: ,p_object_version_number => p_rec.object_version_number) then
393: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
394: hr_utility.set_message_token('PROCEDURE', l_proc);
395: hr_utility.set_message_token('STEP', '20');
396: end if;
397: --
398: hr_utility.set_location(l_proc, 30);

Line 395: hr_utility.set_message_token('STEP', '20');

391: (p_job_extra_info_id => p_rec.job_extra_info_id
392: ,p_object_version_number => p_rec.object_version_number) then
393: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
394: hr_utility.set_message_token('PROCEDURE', l_proc);
395: hr_utility.set_message_token('STEP', '20');
396: end if;
397: --
398: hr_utility.set_location(l_proc, 30);
399: --

Line 398: hr_utility.set_location(l_proc, 30);

394: hr_utility.set_message_token('PROCEDURE', l_proc);
395: hr_utility.set_message_token('STEP', '20');
396: end if;
397: --
398: hr_utility.set_location(l_proc, 30);
399: --
400: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
401: nvl(pe_jei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
402: l_argument := 'information_type';

Line 406: hr_utility.set_location(l_proc, 40);

402: l_argument := 'information_type';
403: raise l_error;
404: end if;
405: --
406: hr_utility.set_location(l_proc, 40);
407: --
408: if nvl(p_rec.job_id, hr_api.g_number) <>
409: nvl(pe_jei_shd.g_old_rec.job_id, hr_api.g_number) then
410: l_argument := 'job_id';

Line 414: hr_utility.set_location(' Leaving:'||l_proc, 50);

410: l_argument := 'job_id';
411: raise l_error;
412: end if;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 50);
415: exception
416: when l_error then
417: hr_api.argument_changed_error
418: (p_api_name => l_proc

Line 421: hr_utility.set_location(l_proc, 60);

417: hr_api.argument_changed_error
418: (p_api_name => l_proc
419: ,p_argument => l_argument
420: );
421: hr_utility.set_location(l_proc, 60);
422: when others then
423: hr_utility.set_location(l_proc, 70);
424: raise;
425: end chk_non_updateable_args;

Line 423: hr_utility.set_location(l_proc, 70);

419: ,p_argument => l_argument
420: );
421: hr_utility.set_location(l_proc, 60);
422: when others then
423: hr_utility.set_location(l_proc, 70);
424: raise;
425: end chk_non_updateable_args;
426:
427: -- |---------------------------< insert_validate >----------------------------|

Line 435: hr_utility.set_location('Entering:'||l_proc, 5);

431: --
432: l_proc varchar2(72) := g_package||'insert_validate';
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- Validate Job ID
438: --
439: chk_job_id

Line 581: hr_utility.set_location(' Leaving:'||l_proc, 30);

577: );
578: --
579:
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 30);
582: --
583: End insert_validate;
584: --
585: -- ----------------------------------------------------------------------------

Line 593: hr_utility.set_location('Entering:'||l_proc, 5);

589: --
590: l_proc varchar2(72) := g_package||'update_validate';
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Validate Non-Updateable Fields
596: --
597: chk_non_updateable_args (p_rec => p_rec);

Line 598: hr_utility.set_location(' Leaving:'||l_proc, 10);

594: --
595: -- Validate Non-Updateable Fields
596: --
597: chk_non_updateable_args (p_rec => p_rec);
598: hr_utility.set_location(' Leaving:'||l_proc, 10);
599: --
600: -- Call df procedure to validation Descriptive Flexfields
601: --
602: /* Replace this call with another */

Line 728: hr_utility.set_location(' Leaving:'||l_proc, 30);

724: ,p_attribute30_value => p_rec.JEI_INFORMATION30
725: );
726:
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 30);
729: --
730: End update_validate;
731: --
732: -- ----------------------------------------------------------------------------

Line 740: hr_utility.set_location('Entering:'||l_proc, 5);

736: --
737: l_proc varchar2(72) := g_package||'delete_validate';
738: --
739: Begin
740: hr_utility.set_location('Entering:'||l_proc, 5);
741: --
742: -- Call all supporting business operations
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 744: hr_utility.set_location(' Leaving:'||l_proc, 10);

740: hr_utility.set_location('Entering:'||l_proc, 5);
741: --
742: -- Call all supporting business operations
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 10);
745: End delete_validate;
746: --
747: end pe_jei_bus;