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

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

28: l_proc varchar2(72) := g_package||'set_security_group_id';
29: --
30: begin
31: --
32: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: -- Ensure that all the mandatory parameter are not null
35: --
36: hr_api.mandatory_arg_error

Line 44: hr_utility.set_location(' Leaving:'|| l_proc, 20);

40: );
41: --
42: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.
43: --
44: hr_utility.set_location(' Leaving:'|| l_proc, 20);
45: --
46: end set_security_group_id;
47: --
48: --

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

138: from ben_pl_f
139: where pl_id = p_pl_id;
140: --
141: begin
142: hr_utility.set_location('Entering: '|| l_proc, 1);
143: --
144: -- Check mandatory parameters have been set
145: --
146: hr_api.mandatory_arg_error

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

148: p_argument => 'pl_id',
149: p_argument_value => p_pl_id
150: );
151: --
152: hr_utility.set_location(l_proc, 2);
153: --
154: -- Check that the pl_id is in ben_pl_f
155: --
156: open csr_valid_plan;

Line 160: hr_utility.set_message(801, 'HR_nnn_PLAN_NOT_EXIST');

156: open csr_valid_plan;
157: fetch csr_valid_plan into l_exists;
158: if csr_valid_plan%notfound then
159: close csr_valid_plan;
160: hr_utility.set_message(801, 'HR_nnn_PLAN_NOT_EXIST');
161: hr_utility.raise_error;
162: end if;
163: close csr_valid_plan;
164: --

Line 161: hr_utility.raise_error;

157: fetch csr_valid_plan into l_exists;
158: if csr_valid_plan%notfound then
159: close csr_valid_plan;
160: hr_utility.set_message(801, 'HR_nnn_PLAN_NOT_EXIST');
161: hr_utility.raise_error;
162: end if;
163: close csr_valid_plan;
164: --
165: hr_utility.set_location(l_proc, 3);

Line 165: hr_utility.set_location(l_proc, 3);

161: hr_utility.raise_error;
162: end if;
163: close csr_valid_plan;
164: --
165: hr_utility.set_location(l_proc, 3);
166: --
167: hr_utility.set_location(' Leaving: '|| l_proc, 4);
168: end chk_pl_id;
169: --

Line 167: hr_utility.set_location(' Leaving: '|| l_proc, 4);

163: close csr_valid_plan;
164: --
165: hr_utility.set_location(l_proc, 3);
166: --
167: hr_utility.set_location(' Leaving: '|| l_proc, 4);
168: end chk_pl_id;
169: --
170: --
171: -- ----------------------------------------------------------------------------

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

205: from ben_plip_f
206: where plip_id = p_plip_id;
207: --
208: begin
209: hr_utility.set_location('Entering: '|| l_proc, 1);
210: --
211: --
212: hr_utility.set_location(l_proc, 2);
213: --

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

208: begin
209: hr_utility.set_location('Entering: '|| l_proc, 1);
210: --
211: --
212: hr_utility.set_location(l_proc, 2);
213: --
214: -- Check that the plip_id is in ben_pgm_f
215: -- unless the plip_id is null
216: --

Line 222: hr_utility.set_message(801, 'HR_nnn_PROGRAM_NOT_EXIST');

218: open csr_valid_program;
219: fetch csr_valid_program into l_exists;
220: if csr_valid_program%notfound then
221: close csr_valid_program;
222: hr_utility.set_message(801, 'HR_nnn_PROGRAM_NOT_EXIST');
223: hr_utility.raise_error;
224: end if;
225: close csr_valid_program;
226: end if;

Line 223: hr_utility.raise_error;

219: fetch csr_valid_program into l_exists;
220: if csr_valid_program%notfound then
221: close csr_valid_program;
222: hr_utility.set_message(801, 'HR_nnn_PROGRAM_NOT_EXIST');
223: hr_utility.raise_error;
224: end if;
225: close csr_valid_program;
226: end if;
227: --

Line 228: hr_utility.set_location(l_proc, 3);

224: end if;
225: close csr_valid_program;
226: end if;
227: --
228: hr_utility.set_location(l_proc, 3);
229: --
230: hr_utility.set_location(' Leaving: '|| l_proc, 4);
231: end chk_plip_id;
232: --

Line 230: hr_utility.set_location(' Leaving: '|| l_proc, 4);

226: end if;
227: --
228: hr_utility.set_location(l_proc, 3);
229: --
230: hr_utility.set_location(' Leaving: '|| l_proc, 4);
231: end chk_plip_id;
232: --
233:
234: --

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

264: l_exists varchar2(1);
265: l_proc varchar2(72) := g_package||'chk_open_enrollment_flag';
266: --
267: begin
268: hr_utility.set_location('Entering: '|| l_proc, 1);
269: --
270: -- Check mandatory parameters have been set
271: --
272: hr_api.mandatory_arg_error

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

274: p_argument => 'open_enrollment_flag',
275: p_argument_value => p_open_enrollment_flag
276: );
277: --
278: hr_utility.set_location(l_proc, 2);
279: --
280: -- Check that the open_enrollment_flag is either Y or N
281: --
282: if not (p_open_enrollment_flag = 'Y'

Line 285: hr_utility.set_message(801, 'HR_nnn_FLAG_NOT_SET');

281: --
282: if not (p_open_enrollment_flag = 'Y'
283: or
284: p_open_enrollment_flag = 'N') then
285: hr_utility.set_message(801, 'HR_nnn_FLAG_NOT_SET');
286: hr_utility.raise_error;
287: end if;
288: --
289: hr_utility.set_location(l_proc, 3);

Line 286: hr_utility.raise_error;

282: if not (p_open_enrollment_flag = 'Y'
283: or
284: p_open_enrollment_flag = 'N') then
285: hr_utility.set_message(801, 'HR_nnn_FLAG_NOT_SET');
286: hr_utility.raise_error;
287: end if;
288: --
289: hr_utility.set_location(l_proc, 3);
290: --

Line 289: hr_utility.set_location(l_proc, 3);

285: hr_utility.set_message(801, 'HR_nnn_FLAG_NOT_SET');
286: hr_utility.raise_error;
287: end if;
288: --
289: hr_utility.set_location(l_proc, 3);
290: --
291: hr_utility.set_location(' Leaving: '|| l_proc, 4);
292: end chk_open_enrollment_flag;
293: --

Line 291: hr_utility.set_location(' Leaving: '|| l_proc, 4);

287: end if;
288: --
289: hr_utility.set_location(l_proc, 3);
290: --
291: hr_utility.set_location(' Leaving: '|| l_proc, 4);
292: end chk_open_enrollment_flag;
293: --
294:
295: --

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

325: l_exists varchar2(1);
326: l_proc varchar2(72) := g_package||'chk_target_page';
327: --
328: begin
329: hr_utility.set_location('Entering: '|| l_proc, 1);
330: --
331: -- Check mandatory parameters have been set
332: --
333: hr_api.mandatory_arg_error

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

335: p_argument => 'target_page',
336: p_argument_value => p_target_page
337: );
338: --
339: hr_utility.set_location(l_proc, 2);
340: --
341: --
342: hr_utility.set_location(l_proc, 3);
343: --

Line 342: hr_utility.set_location(l_proc, 3);

338: --
339: hr_utility.set_location(l_proc, 2);
340: --
341: --
342: hr_utility.set_location(l_proc, 3);
343: --
344: hr_utility.set_location(' Leaving: '|| l_proc, 4);
345: end chk_target_page;
346: --

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

340: --
341: --
342: hr_utility.set_location(l_proc, 3);
343: --
344: hr_utility.set_location(' Leaving: '|| l_proc, 4);
345: end chk_target_page;
346: --
347:
348: --

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

394: and open_enrollment_flag = p_open_enrollment_flag;
395:
396: --
397: begin
398: hr_utility.set_location('Entering: '|| l_proc, 1);
399: --
400: open csr_chk_unique;
401: fetch csr_chk_unique into l_exists;
402: if csr_chk_unique%found then

Line 404: hr_utility.set_message(801, 'HR_nnn_MAPPING_EXISTS');

400: open csr_chk_unique;
401: fetch csr_chk_unique into l_exists;
402: if csr_chk_unique%found then
403: close csr_chk_unique;
404: hr_utility.set_message(801, 'HR_nnn_MAPPING_EXISTS');
405: hr_utility.raise_error;
406: end if;
407: close csr_chk_unique;
408: --

Line 405: hr_utility.raise_error;

401: fetch csr_chk_unique into l_exists;
402: if csr_chk_unique%found then
403: close csr_chk_unique;
404: hr_utility.set_message(801, 'HR_nnn_MAPPING_EXISTS');
405: hr_utility.raise_error;
406: end if;
407: close csr_chk_unique;
408: --
409: hr_utility.set_location(l_proc, 2);

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

405: hr_utility.raise_error;
406: end if;
407: close csr_chk_unique;
408: --
409: hr_utility.set_location(l_proc, 2);
410: --
411: --
412: hr_utility.set_location(l_proc, 3);
413: --

Line 412: hr_utility.set_location(l_proc, 3);

408: --
409: hr_utility.set_location(l_proc, 2);
410: --
411: --
412: hr_utility.set_location(l_proc, 3);
413: --
414: hr_utility.set_location(' Leaving: '|| l_proc, 4);
415: end chk_unique_ins;
416: --

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

410: --
411: --
412: hr_utility.set_location(l_proc, 3);
413: --
414: hr_utility.set_location(' Leaving: '|| l_proc, 4);
415: end chk_unique_ins;
416: --
417:
418: --

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

465: and open_enrollment_flag = p_open_enrollment_flag
466: and authoria_mapping_id <> p_authoria_mapping_id;
467: --
468: begin
469: hr_utility.set_location('Entering: '|| l_proc, 1);
470: --
471: open csr_chk_unique;
472: fetch csr_chk_unique into l_exists;
473: if csr_chk_unique%found then

Line 475: hr_utility.set_message(801, 'HR_nnn_MAPPING_EXISTS');

471: open csr_chk_unique;
472: fetch csr_chk_unique into l_exists;
473: if csr_chk_unique%found then
474: close csr_chk_unique;
475: hr_utility.set_message(801, 'HR_nnn_MAPPING_EXISTS');
476: hr_utility.raise_error;
477: end if;
478: close csr_chk_unique;
479: --

Line 476: hr_utility.raise_error;

472: fetch csr_chk_unique into l_exists;
473: if csr_chk_unique%found then
474: close csr_chk_unique;
475: hr_utility.set_message(801, 'HR_nnn_MAPPING_EXISTS');
476: hr_utility.raise_error;
477: end if;
478: close csr_chk_unique;
479: --
480: hr_utility.set_location(l_proc, 2);

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

476: hr_utility.raise_error;
477: end if;
478: close csr_chk_unique;
479: --
480: hr_utility.set_location(l_proc, 2);
481: --
482: --
483: hr_utility.set_location(l_proc, 3);
484: --

Line 483: hr_utility.set_location(l_proc, 3);

479: --
480: hr_utility.set_location(l_proc, 2);
481: --
482: --
483: hr_utility.set_location(l_proc, 3);
484: --
485: hr_utility.set_location(' Leaving: '|| l_proc, 4);
486: end chk_unique_upd;
487: --

Line 485: hr_utility.set_location(' Leaving: '|| l_proc, 4);

481: --
482: --
483: hr_utility.set_location(l_proc, 3);
484: --
485: hr_utility.set_location(' Leaving: '|| l_proc, 4);
486: end chk_unique_upd;
487: --
488:
489: --

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

496: --
497: l_proc varchar2(72) := g_package||'insert_validate';
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Call all supporting business operations
503:
504: -- validate pl_id

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

530: --
531: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.
532: --
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535: End insert_validate;
536: --
537: -- ----------------------------------------------------------------------------
538: -- |---------------------------< update_validate >----------------------------|

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

543: --
544: l_proc varchar2(72) := g_package||'update_validate';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call all supporting business operations
550:
551: -- validate pl_id

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

582: (p_rec => p_rec
583: );
584: --
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 10);
587: End update_validate;
588: --
589: -- ----------------------------------------------------------------------------
590: -- |---------------------------< delete_validate >----------------------------|

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

595: --
596: l_proc varchar2(72) := g_package||'delete_validate';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call all supporting business operations
602: --
603: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call all supporting business operations
602: --
603: hr_utility.set_location(' Leaving:'||l_proc, 10);
604: End delete_validate;
605: --
606: end hr_amm_bus;