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

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

20: l_error exception;
21: l_argument varchar2(30);
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: -- Only proceed with validation if a row exists for
27: -- the current record in the HR Schema
28: --

Line 32: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

28: --
29: if not hr_ahk_shd.api_updating
30: (p_api_hook_id => p_rec.api_hook_id
31: ) then
32: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP', '20');
35: end if;
36: hr_utility.set_location(l_proc, 30);

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

29: if not hr_ahk_shd.api_updating
30: (p_api_hook_id => p_rec.api_hook_id
31: ) then
32: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP', '20');
35: end if;
36: hr_utility.set_location(l_proc, 30);
37: --

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

30: (p_api_hook_id => p_rec.api_hook_id
31: ) then
32: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP', '20');
35: end if;
36: hr_utility.set_location(l_proc, 30);
37: --
38: if nvl(p_rec.api_module_id, hr_api.g_varchar2) <>

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

32: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP', '20');
35: end if;
36: hr_utility.set_location(l_proc, 30);
37: --
38: if nvl(p_rec.api_module_id, hr_api.g_varchar2) <>
39: nvl(hr_ahk_shd.g_old_rec.api_module_id
40: ,hr_api.g_varchar2

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

50: l_argument := 'legislation_code';
51: raise l_error;
52: end if;
53: --
54: hr_utility.set_location(l_proc, 40);
55: exception
56: when l_error then
57: hr_api.argument_changed_error
58: (p_api_name => l_proc

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

59: ,p_argument => l_argument
60: );
61: when others then
62: raise;
63: hr_utility.set_location(' Leaving:'||l_proc, 50);
64: end chk_non_updateable_args;
65: --
66: -- -----------------------------------------------------------------
67: -- |-----------------------< chk_api_module_id >-------------------------|

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

104: from hr_api_modules
105: where api_module_id = p_api_module_id;
106: --
107: begin
108: hr_utility.set_location('Entering: '||l_proc,5);
109: --
110: --------------------------------
111: -- Check module id not null --
112: --------------------------------

Line 130: hr_utility.set_message(800,

126: end if;
127: -- #661588:-
128: if l_api_module_type = 'AI' then
129: close csr_valid_module_type;
130: hr_utility.set_message(800,
131: 'PER_50041_TYPE_AI_NOT_ALLOWED');
132: hr_utility.raise_error;
133: end if;
134: --

Line 132: hr_utility.raise_error;

128: if l_api_module_type = 'AI' then
129: close csr_valid_module_type;
130: hr_utility.set_message(800,
131: 'PER_50041_TYPE_AI_NOT_ALLOWED');
132: hr_utility.raise_error;
133: end if;
134: --
135: close csr_valid_module_type;
136:

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

133: end if;
134: --
135: close csr_valid_module_type;
136:
137: hr_utility.set_location('Leaving: '||l_proc,10);
138: end chk_api_module_id;
139: --
140: --
141: -- -----------------------------------------------------------------

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

195:
196: --
197: --
198: begin
199: hr_utility.set_location('Entering: '||l_proc,5);
200:
201: ----------------------------------
202: -- Check api hook type not null --
203: ----------------------------------

Line 258: hr_utility.set_message(800,'PER_52129_AHK_WRONG_HOOK_TYPE');

254: (p_api_hook_type in ('BP', 'AP') and l_api_module_type <> 'BP'))
255:
256: THEN
257: close csr_get_module_type;
258: hr_utility.set_message(800,'PER_52129_AHK_WRONG_HOOK_TYPE');
259: hr_utility.raise_error;
260: end if;
261:
262: close csr_get_module_type;

Line 259: hr_utility.raise_error;

255:
256: THEN
257: close csr_get_module_type;
258: hr_utility.set_message(800,'PER_52129_AHK_WRONG_HOOK_TYPE');
259: hr_utility.raise_error;
260: end if;
261:
262: close csr_get_module_type;
263:

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

261:
262: close csr_get_module_type;
263:
264: end if; -- end of api_updating? if
265: hr_utility.set_location('Leaving: '||l_proc,10);
266: end chk_api_hook_type;
267: --
268: --
269: -- -----------------------------------------------------------------

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

307:
308: --
309: --
310: begin
311: hr_utility.set_location('Entering: '||l_proc,5);
312:
313: --------------------------------
314: -- Check legislation code is valid --
315: --------------------------------

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

318: fetch csr_valid_legislation_code into l_territory_code;
319:
320: if csr_valid_legislation_code%notfound then
321: close csr_valid_legislation_code;
322: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
323: hr_utility.raise_error;
324: end if; -- End cursor if
325:
326: close csr_valid_legislation_code;

Line 323: hr_utility.raise_error;

319:
320: if csr_valid_legislation_code%notfound then
321: close csr_valid_legislation_code;
322: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
323: hr_utility.raise_error;
324: end if; -- End cursor if
325:
326: close csr_valid_legislation_code;
327: end if; -- end check

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

325:
326: close csr_valid_legislation_code;
327: end if; -- end check
328:
329: hr_utility.set_location('Leaving: '||l_proc,10);
330: end chk_legislation_code;
331: --
332: --
333: -- -----------------------------------------------------------------

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

364: l_api_updating boolean;
365: --
366: --
367: begin
368: hr_utility.set_location('Entering: '||l_proc,5);
369:
370: --------------------------------
371: -- Check hook package not null --
372: --------------------------------

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

374: (p_api_name => l_proc,
375: p_argument => 'p_hook_package',
376: p_argument_value => p_hook_package);
377:
378: hr_utility.set_location('Leaving: '||l_proc,10);
379:
380: end chk_hook_package;
381: --
382: --

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

415: --
416:
417: --
418: begin
419: hr_utility.set_location('Entering: '||l_proc,5);
420:
421: --------------------------------
422: -- Check hook procedure not null --
423: --------------------------------

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

425: (p_api_name => l_proc,
426: p_argument => 'p_hook_procedure',
427: p_argument_value => p_hook_procedure);
428:
429: hr_utility.set_location('Leaving: '||l_proc,10);
430: end chk_hook_procedure;
431: --
432: -- -----------------------------------------------------------------
433: -- |-----------------------< chk_hook_package_procedure >----------|

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

471: and hah.hook_procedure = p_hook_procedure;
472:
473: --
474: begin
475: hr_utility.set_location('Entering: '||l_proc,5);
476:
477: -- Check if hook is being updated
478: l_api_updating := hr_ahk_shd.api_updating
479: (p_api_hook_id => p_api_hook_id);

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

499: close csr_valid_combo;
500:
501: end if;
502:
503: hr_utility.set_location('Leaving: '||l_proc,10);
504: end chk_hook_package_procedure;
505: --
506: --
507: -- -----------------------------------------------------------------

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

548: where api_module_id = p_api_module_id;
549: --
550: --
551: begin
552: hr_utility.set_location('Entering: '||l_proc,5);
553:
554: -- Check if hook is being updated
555: l_api_updating := hr_ahk_shd.api_updating
556: (p_api_hook_id => p_api_hook_id);

Line 573: hr_utility.set_message(800,'PER_52131_AHK_LEG_PACK_INV');

569: fetch csr_get_data_within_bus_group into l_data_within_business_group;
570:
571: if l_data_within_business_group = 'N' THEN
572: close csr_get_data_within_bus_group;
573: hr_utility.set_message(800,'PER_52131_AHK_LEG_PACK_INV');
574: hr_utility.raise_error;
575: end if;
576:
577: close csr_get_data_within_bus_group;

Line 574: hr_utility.raise_error;

570:
571: if l_data_within_business_group = 'N' THEN
572: close csr_get_data_within_bus_group;
573: hr_utility.set_message(800,'PER_52131_AHK_LEG_PACK_INV');
574: hr_utility.raise_error;
575: end if;
576:
577: close csr_get_data_within_bus_group;
578: end if;

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

577: close csr_get_data_within_bus_group;
578: end if;
579:
580: end if;
581: hr_utility.set_location('Leaving: '||l_proc,10);
582: end chk_legislation_package;
583: --
584: --
585: --

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

627: where api_module_id = p_api_module_id;
628: --
629: --
630: begin
631: hr_utility.set_location('Entering: '||l_proc,5);
632:
633: -- Check if hook is being updated
634: l_api_updating := hr_ahk_shd.api_updating
635: (p_api_hook_id => p_api_hook_id);

Line 653: hr_utility.set_message(800,'PER_52132_AHK_LEG_FUNC_INV');

649:
650: if (l_data_within_business_group = 'N' AND
651: p_legislation_function is not null) THEN
652: close csr_get_data_within_bus_group;
653: hr_utility.set_message(800,'PER_52132_AHK_LEG_FUNC_INV');
654: hr_utility.raise_error;
655: end if;
656:
657: close csr_get_data_within_bus_group;

Line 654: hr_utility.raise_error;

650: if (l_data_within_business_group = 'N' AND
651: p_legislation_function is not null) THEN
652: close csr_get_data_within_bus_group;
653: hr_utility.set_message(800,'PER_52132_AHK_LEG_FUNC_INV');
654: hr_utility.raise_error;
655: end if;
656:
657: close csr_get_data_within_bus_group;
658: end if;

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

657: close csr_get_data_within_bus_group;
658: end if;
659:
660: end if;
661: hr_utility.set_location('Leaving: '||l_proc,10);
662: end chk_legislation_function;
663: --
664: --
665: -- -----------------------------------------------------------------

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

700: l_proc varchar2(72) := g_package||'chk_legislation_function';
701: --
702: --
703: begin
704: hr_utility.set_location('Entering: '||l_proc,5);
705:
706: --------------------------------------------------
707: -- Check Legislation Function and Package Combo --
708: --------------------------------------------------

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

712: then
713: hr_ahk_shd.constraint_error('HR_API_HOOKS_CK2');
714: end if;
715:
716: hr_utility.set_location('Leaving: '||l_proc,10);
717: end chk_leg_package_function;
718: --
719: -- -----------------------------------------------------------------
720: -- |-----------------------< chk_delete >-------------------------|

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

754: where hahc.api_hook_id = p_api_hook_id;
755: --
756: --
757: begin
758: hr_utility.set_location('Entering: '||l_proc,5);
759:
760: -- We don't have to check for valid hook id as this is done by the lck proc
761: --------------------------------------
762: -- Check if hook has any children --

Line 770: hr_utility.set_message(800,'PER_52148_AHK_CANNOT_DEL_ROW');

766: fetch csr_check_for_child into l_api_hook_id;
767:
768: if csr_check_for_child%found then
769: close csr_check_for_child;
770: hr_utility.set_message(800,'PER_52148_AHK_CANNOT_DEL_ROW');
771: hr_utility.raise_error;
772: end if;
773:
774: close csr_check_for_child;

Line 771: hr_utility.raise_error;

767:
768: if csr_check_for_child%found then
769: close csr_check_for_child;
770: hr_utility.set_message(800,'PER_52148_AHK_CANNOT_DEL_ROW');
771: hr_utility.raise_error;
772: end if;
773:
774: close csr_check_for_child;
775:

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

772: end if;
773:
774: close csr_check_for_child;
775:
776: hr_utility.set_location('Leaving: '||l_proc,10);
777: end chk_delete;
778: --
779: --
780: --

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

786: --
787: l_proc varchar2(72) := g_package||'insert_validate';
788: --
789: Begin
790: hr_utility.set_location('Entering:'||l_proc, 5);
791: --
792: --
793: -- As this data is not within the context of a business group
794: -- the set_security_group_id procedure has zero passed

Line 799: hr_utility.set_location('Entering:'||l_proc, 7);

795: -- to it as the default security_group_id.
796: --
797: hr_api.set_security_group_id(p_security_group_id => 0);
798: --
799: hr_utility.set_location('Entering:'||l_proc, 7);
800: --
801: -- Call all supporting business operations
802: --
803: -- Validate the Module Id

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

856: p_legislation_function => p_rec.legislation_function
857: );
858:
859: --
860: hr_utility.set_location(' Leaving:'||l_proc, 10);
861: End insert_validate;
862: --
863: -- ----------------------------------------------------------------------------
864: -- |---------------------------< update_validate >----------------------------|

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

868: --
869: l_proc varchar2(72) := g_package||'update_validate';
870: --
871: Begin
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: -- As this data is not within the context of a business group
875: -- the set_security_group_id procedure has zero passed
876: -- to it as the default security_group_id.

Line 880: hr_utility.set_location('Entering:'||l_proc, 7);

876: -- to it as the default security_group_id.
877: --
878: hr_api.set_security_group_id(p_security_group_id => 0);
879: --
880: hr_utility.set_location('Entering:'||l_proc, 7);
881: --
882: -- Call all supporting business operations
883: --
884: -- Validate the API Hook Type

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

926: p_legislation_function => p_rec.legislation_function
927: );
928: --
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 10);
931: End update_validate;
932: --
933: -- ----------------------------------------------------------------------------
934: -- |---------------------------< delete_validate >----------------------------|

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

937: --
938: l_proc varchar2(72) := g_package||'delete_validate';
939: --
940: Begin
941: hr_utility.set_location('Entering:'||l_proc, 5);
942: --
943: -- Call all supporting business operations
944: chk_delete(p_api_hook_id => p_rec.api_hook_id);
945: --

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

942: --
943: -- Call all supporting business operations
944: chk_delete(p_api_hook_id => p_rec.api_hook_id);
945: --
946: hr_utility.set_location(' Leaving:'||l_proc, 10);
947: End delete_validate;
948: --
949: end hr_ahk_bus;