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

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

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

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

30: if not hr_ahc_shd.api_updating
31: (p_api_hook_call_id => p_rec.api_hook_call_id,
32: p_object_version_number => p_rec.object_version_number
33: ) then
34: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE', l_proc);
36: hr_utility.set_message_token('STEP', '20');
37: end if;
38: hr_utility.set_location(l_proc, 30);

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

31: (p_api_hook_call_id => p_rec.api_hook_call_id,
32: p_object_version_number => p_rec.object_version_number
33: ) then
34: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE', l_proc);
36: hr_utility.set_message_token('STEP', '20');
37: end if;
38: hr_utility.set_location(l_proc, 30);
39: --

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

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

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

34: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE', l_proc);
36: hr_utility.set_message_token('STEP', '20');
37: end if;
38: hr_utility.set_location(l_proc, 30);
39: --
40: if nvl(p_rec.api_hook_id, hr_api.g_number) <>
41: nvl(hr_ahc_shd.g_old_rec.api_hook_id
42: ,hr_api.g_number

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

68: l_argument := 'application_id';
69: raise l_error;
70: end if;
71: --
72: hr_utility.set_location(l_proc, 40);
73: exception
74: when l_error then
75: hr_api.argument_changed_error
76: (p_api_name => l_proc

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

77: ,p_argument => l_argument
78: );
79: when others then
80: raise;
81: hr_utility.set_location(' Leaving:'||l_proc, 50);
82: end chk_non_updateable_args;
83: --
84: -- -----------------------------------------------------------------
85: -- |-----------------------< chk_api_hook_id >-------------------------|

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

121: where api_hook_id = p_api_hook_id;
122:
123: --
124: begin
125: hr_utility.set_location('Entering: '||l_proc,5);
126: --
127: --------------------------------
128: -- Check hook id not null --
129: --------------------------------

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

142: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_FK1');
143: end if;
144: close csr_valid_hook_id;
145:
146: hr_utility.set_location('Leaving: '||l_proc,10);
147: end chk_api_hook_id;
148: --
149: --
150: -- -----------------------------------------------------------------

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

184: l_lookup_code hr_lookups.lookup_code%TYPE;
185: --
186: --
187: begin
188: hr_utility.set_location('Entering: '||l_proc,5);
189: --
190: --------------------------------
191: -- Check hook call type not null --
192: --------------------------------

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

204: p_lookup_code => p_api_hook_call_type) then
205: hr_ahc_shd.constraint_error('HR_API_HOOK_CALLS_CK1');
206: end if;
207:
208: hr_utility.set_location('Leaving: '||l_proc,10);
209: end chk_api_hook_call_type;
210: --
211: --
212: -- -----------------------------------------------------------------

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

249: where ft.territory_code = p_legislation_code;
250: --
251: --
252: begin
253: hr_utility.set_location('Entering: '||l_proc,5);
254: --------------------------------
255: -- Check legislation code is valid --
256: --------------------------------
257: if p_legislation_code is not null then

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

259: fetch csr_valid_legislation_code into l_territory_code;
260:
261: if csr_valid_legislation_code%notfound then
262: close csr_valid_legislation_code;
263: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
264: hr_utility.raise_error;
265: end if; -- End cursor if
266:
267: close csr_valid_legislation_code;

Line 264: hr_utility.raise_error;

260:
261: if csr_valid_legislation_code%notfound then
262: close csr_valid_legislation_code;
263: hr_utility.set_message(800,'PER_52123_AMD_LEG_CODE_INV');
264: hr_utility.raise_error;
265: end if; -- End cursor if
266:
267: close csr_valid_legislation_code;
268: end if; -- end check

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

266:
267: close csr_valid_legislation_code;
268: end if; -- end check
269:
270: hr_utility.set_location('Leaving: '||l_proc,10);
271: end chk_legislation_code;
272: --
273: --
274: -- -----------------------------------------------------------------

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

312: l_api_updating boolean;
313:
314: --
315: begin
316: hr_utility.set_location('Entering: '||l_proc,5);
317:
318: -- Check if hook is being updated
319: l_api_updating := hr_ahc_shd.api_updating
320: (p_api_hook_call_id => p_api_hook_call_id,

Line 331: hr_utility.set_message(800,'PER_52145_AHC_INVALID_SEQ1');

327:
328:
329: if ( p_legislation_code is not null and
330: (p_sequence < 1500 or p_sequence > 1999) ) then
331: hr_utility.set_message(800,'PER_52145_AHC_INVALID_SEQ1');
332: hr_utility.raise_error;
333: elsif( p_legislation_code is null) then
334: if (p_application_id is null and
335: (p_sequence >= 1000 and p_sequence <= 1999) )then

Line 332: hr_utility.raise_error;

328:
329: if ( p_legislation_code is not null and
330: (p_sequence < 1500 or p_sequence > 1999) ) then
331: hr_utility.set_message(800,'PER_52145_AHC_INVALID_SEQ1');
332: hr_utility.raise_error;
333: elsif( p_legislation_code is null) then
334: if (p_application_id is null and
335: (p_sequence >= 1000 and p_sequence <= 1999) )then
336: hr_utility.set_message(800,'PER_52146_AHC_INVALID_SEQ2');

Line 336: hr_utility.set_message(800,'PER_52146_AHC_INVALID_SEQ2');

332: hr_utility.raise_error;
333: elsif( p_legislation_code is null) then
334: if (p_application_id is null and
335: (p_sequence >= 1000 and p_sequence <= 1999) )then
336: hr_utility.set_message(800,'PER_52146_AHC_INVALID_SEQ2');
337: hr_utility.raise_error;
338: elsif (p_application_id is not null and
339: (p_sequence < 1000 or p_sequence > 1499)) then
340: hr_utility.set_message(800,'PER_289089_AHC_INVALID_SEQ3');

Line 337: hr_utility.raise_error;

333: elsif( p_legislation_code is null) then
334: if (p_application_id is null and
335: (p_sequence >= 1000 and p_sequence <= 1999) )then
336: hr_utility.set_message(800,'PER_52146_AHC_INVALID_SEQ2');
337: hr_utility.raise_error;
338: elsif (p_application_id is not null and
339: (p_sequence < 1000 or p_sequence > 1499)) then
340: hr_utility.set_message(800,'PER_289089_AHC_INVALID_SEQ3');
341: hr_utility.raise_error;

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

336: hr_utility.set_message(800,'PER_52146_AHC_INVALID_SEQ2');
337: hr_utility.raise_error;
338: elsif (p_application_id is not null and
339: (p_sequence < 1000 or p_sequence > 1499)) then
340: hr_utility.set_message(800,'PER_289089_AHC_INVALID_SEQ3');
341: hr_utility.raise_error;
342: end if;
343: end if;
344: end if;

Line 341: hr_utility.raise_error;

337: hr_utility.raise_error;
338: elsif (p_application_id is not null and
339: (p_sequence < 1000 or p_sequence > 1499)) then
340: hr_utility.set_message(800,'PER_289089_AHC_INVALID_SEQ3');
341: hr_utility.raise_error;
342: end if;
343: end if;
344: end if;
345:

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

342: end if;
343: end if;
344: end if;
345:
346: hr_utility.set_location('Leaving: '||l_proc,10);
347: end chk_sequence;
348: --
349: --
350: -- -----------------------------------------------------------------

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

386: l_api_updating boolean;
387: --
388: --
389: begin
390: hr_utility.set_location('Entering: '||l_proc,5);
391:
392: --------------------------------
393: -- Check enabled flag type not null --
394: --------------------------------

Line 417: hr_utility.set_message(800,'PER_52136_AHC_ENAB_FLAG_INV');

413: if hr_api.not_exists_in_hr_lookups
414: (p_effective_date => p_effective_date,
415: p_lookup_type => 'YES_NO',
416: p_lookup_code => p_enabled_flag) then
417: hr_utility.set_message(800,'PER_52136_AHC_ENAB_FLAG_INV');
418: hr_utility.raise_error;
419: end if;
420:
421: end if;

Line 418: hr_utility.raise_error;

414: (p_effective_date => p_effective_date,
415: p_lookup_type => 'YES_NO',
416: p_lookup_code => p_enabled_flag) then
417: hr_utility.set_message(800,'PER_52136_AHC_ENAB_FLAG_INV');
418: hr_utility.raise_error;
419: end if;
420:
421: end if;
422: hr_utility.set_location('Leaving: '||l_proc,10);

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

418: hr_utility.raise_error;
419: end if;
420:
421: end if;
422: hr_utility.set_location('Leaving: '||l_proc,10);
423: end chk_enabled_flag;
424: --
425: --
426: -- -----------------------------------------------------------------

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

460: l_proc varchar2(72) := g_package||'chk_call_package';
461: l_api_updating boolean;
462: --
463: begin
464: hr_utility.set_location('Entering: '||l_proc,5);
465:
466: -- Check if hook is being updated
467: l_api_updating := hr_ahc_shd.api_updating
468: (p_api_hook_call_id => p_api_hook_call_id,

Line 480: hr_utility.set_message(800,'PER_52137_AHC_CALL_PACK_INV');

476:
477: if (p_api_hook_call_type = 'PP' and p_call_package is null) OR
478: (p_api_hook_call_type = 'FF' and p_call_package is not null)
479: then
480: hr_utility.set_message(800,'PER_52137_AHC_CALL_PACK_INV');
481: hr_utility.raise_error;
482: end if;
483: end if;
484:

Line 481: hr_utility.raise_error;

477: if (p_api_hook_call_type = 'PP' and p_call_package is null) OR
478: (p_api_hook_call_type = 'FF' and p_call_package is not null)
479: then
480: hr_utility.set_message(800,'PER_52137_AHC_CALL_PACK_INV');
481: hr_utility.raise_error;
482: end if;
483: end if;
484:
485: hr_utility.set_location('Leaving: '||l_proc,10);

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

481: hr_utility.raise_error;
482: end if;
483: end if;
484:
485: hr_utility.set_location('Leaving: '||l_proc,10);
486: end chk_call_package;
487: --
488: --
489: -- -----------------------------------------------------------------

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

523: l_proc varchar2(72) := g_package||'chk_call_procedure';
524: l_api_updating boolean;
525: --
526: begin
527: hr_utility.set_location('Entering: '||l_proc,5);
528:
529: -- Check if hook is being updated
530: l_api_updating := hr_ahc_shd.api_updating
531: (p_api_hook_call_id => p_api_hook_call_id,

Line 543: hr_utility.set_message(800,'PER_52138_AHC_CALL_PROC_INV');

539:
540: if (p_api_hook_call_type = 'PP' and p_call_procedure is null) OR
541: (p_api_hook_call_type = 'FF' and p_call_procedure is not null)
542: then
543: hr_utility.set_message(800,'PER_52138_AHC_CALL_PROC_INV');
544: hr_utility.raise_error;
545: end if;
546:
547: end if;

Line 544: hr_utility.raise_error;

540: if (p_api_hook_call_type = 'PP' and p_call_procedure is null) OR
541: (p_api_hook_call_type = 'FF' and p_call_procedure is not null)
542: then
543: hr_utility.set_message(800,'PER_52138_AHC_CALL_PROC_INV');
544: hr_utility.raise_error;
545: end if;
546:
547: end if;
548:

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

545: end if;
546:
547: end if;
548:
549: hr_utility.set_location('Leaving: '||l_proc,10);
550: end chk_call_procedure;
551: --
552: --
553: -- -----------------------------------------------------------------

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

614: = nvl(p_call_procedure, 'X');
615:
616: --
617: begin
618: hr_utility.set_location('Entering: '||l_proc,5);
619: -- Check if hook call is being updated
620: l_api_updating := hr_ahc_shd.api_updating
621: (p_api_hook_call_id => p_api_hook_call_id,
622: p_object_version_number => p_object_version_number);

Line 631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);

627: hr_ahc_shd.g_old_rec.call_procedure <> p_call_procedure)
628: )
629: or
630: (not l_api_updating) ) then
631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);
632: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_procedure,99);
633:
634: if p_api_hook_call_type = 'PP' then
635: ----------------------------------------------------------------------------

Line 632: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_procedure,99);

628: )
629: or
630: (not l_api_updating) ) then
631: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_package,99);
632: hr_utility.set_location('**'||hr_ahc_shd.g_old_rec.call_procedure,99);
633:
634: if p_api_hook_call_type = 'PP' then
635: ----------------------------------------------------------------------------
636: -- Check for combination of hook call id, leg code, call pack, call proc --

Line 638: hr_utility.set_location('App_id:'||to_char(p_application_id),1);

634: if p_api_hook_call_type = 'PP' then
635: ----------------------------------------------------------------------------
636: -- Check for combination of hook call id, leg code, call pack, call proc --
637: ----------------------------------------------------------------------------
638: hr_utility.set_location('App_id:'||to_char(p_application_id),1);
639: hr_utility.set_location('Leg:'||p_legislation_code,2);
640: hr_utility.set_location('Pkg:'||p_call_package,3);
641: hr_utility.set_location('prc:'||p_call_procedure,4);
642: open csr_valid_combo;

Line 639: hr_utility.set_location('Leg:'||p_legislation_code,2);

635: ----------------------------------------------------------------------------
636: -- Check for combination of hook call id, leg code, call pack, call proc --
637: ----------------------------------------------------------------------------
638: hr_utility.set_location('App_id:'||to_char(p_application_id),1);
639: hr_utility.set_location('Leg:'||p_legislation_code,2);
640: hr_utility.set_location('Pkg:'||p_call_package,3);
641: hr_utility.set_location('prc:'||p_call_procedure,4);
642: open csr_valid_combo;
643: fetch csr_valid_combo into l_api_hook_call_id;

Line 640: hr_utility.set_location('Pkg:'||p_call_package,3);

636: -- Check for combination of hook call id, leg code, call pack, call proc --
637: ----------------------------------------------------------------------------
638: hr_utility.set_location('App_id:'||to_char(p_application_id),1);
639: hr_utility.set_location('Leg:'||p_legislation_code,2);
640: hr_utility.set_location('Pkg:'||p_call_package,3);
641: hr_utility.set_location('prc:'||p_call_procedure,4);
642: open csr_valid_combo;
643: fetch csr_valid_combo into l_api_hook_call_id;
644:

Line 641: hr_utility.set_location('prc:'||p_call_procedure,4);

637: ----------------------------------------------------------------------------
638: hr_utility.set_location('App_id:'||to_char(p_application_id),1);
639: hr_utility.set_location('Leg:'||p_legislation_code,2);
640: hr_utility.set_location('Pkg:'||p_call_package,3);
641: hr_utility.set_location('prc:'||p_call_procedure,4);
642: open csr_valid_combo;
643: fetch csr_valid_combo into l_api_hook_call_id;
644:
645: if csr_valid_combo%found then

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

650: close csr_valid_combo;
651: end if;
652:
653: end if;
654: hr_utility.set_location('Leaving: '||l_proc,10);
655: end chk_call_pp_combination;
656: --
657: --
658: -- -----------------------------------------------------------------

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

685: l_proc varchar2(72) := g_package||'chk_formula_id';
686:
687: --
688: begin
689: hr_utility.set_location('Entering: '||l_proc,5);
690:
691: -- There is no formula id in the table for the first version.
692: -- It will be added when FORMULA calls are possible.
693:

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

691: -- There is no formula id in the table for the first version.
692: -- It will be added when FORMULA calls are possible.
693:
694:
695: hr_utility.set_location('Leaving: '||l_proc,10);
696: end chk_formula_id;
697: --
698: --
699: -- -----------------------------------------------------------------

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

726: l_proc varchar2(72) := g_package||'chk_call_ff_combination';
727:
728: --
729: begin
730: hr_utility.set_location('Entering: '||l_proc,5);
731:
732: -- There is no formula id in the table for the first version.
733: -- It will be added when FORMULA calls are possible.
734:

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

731:
732: -- There is no formula id in the table for the first version.
733: -- It will be added when FORMULA calls are possible.
734:
735: hr_utility.set_location('Leaving: '||l_proc,10);
736: end chk_call_ff_combination;
737: --
738: --
739: -- -----------------------------------------------------------------

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

771: l_proc varchar2(72) := g_package||'chk_pre_processor_date';
772: l_api_updating boolean;
773: --
774: begin
775: hr_utility.set_location('Entering: '||l_proc,5);
776:
777: -- Check if hook is being updated
778: l_api_updating := hr_ahc_shd.api_updating
779: (p_api_hook_call_id => p_api_hook_call_id,

Line 783: hr_utility.set_message(800,'PER_52144_AHC_PP_DATE_NOT_NULL');

779: (p_api_hook_call_id => p_api_hook_call_id,
780: p_object_version_number => p_object_version_number);
781:
782: if (not l_api_updating and p_pre_processor_date is not null) then
783: hr_utility.set_message(800,'PER_52144_AHC_PP_DATE_NOT_NULL');
784: hr_utility.raise_error;
785: end if;
786:
787: hr_utility.set_location('Leaving: '||l_proc,10);

Line 784: hr_utility.raise_error;

780: p_object_version_number => p_object_version_number);
781:
782: if (not l_api_updating and p_pre_processor_date is not null) then
783: hr_utility.set_message(800,'PER_52144_AHC_PP_DATE_NOT_NULL');
784: hr_utility.raise_error;
785: end if;
786:
787: hr_utility.set_location('Leaving: '||l_proc,10);
788: end chk_pre_processor_date;

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

783: hr_utility.set_message(800,'PER_52144_AHC_PP_DATE_NOT_NULL');
784: hr_utility.raise_error;
785: end if;
786:
787: hr_utility.set_location('Leaving: '||l_proc,10);
788: end chk_pre_processor_date;
789: --
790: --
791: -- -----------------------------------------------------------------

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

826: l_proc varchar2(72) := g_package||'chk_encoded_error';
827: l_api_updating boolean;
828: --
829: begin
830: hr_utility.set_location('Entering: '||l_proc,5);
831:
832: -- Check if hook is being updated
833: l_api_updating := hr_ahc_shd.api_updating
834: (p_api_hook_call_id => p_api_hook_call_id,

Line 840: hr_utility.set_message(800,'PER_52142_AHC_ENC_ERR_NOT_NULL');

836:
837: -- Proceed with validation based on outcome of api_updating call.
838: if (not l_api_updating and p_encoded_error is not null)
839: then
840: hr_utility.set_message(800,'PER_52142_AHC_ENC_ERR_NOT_NULL');
841: hr_utility.raise_error;
842: elsif
843: (l_api_updating and
844: (p_status = 'N' or p_status = 'V') and

Line 841: hr_utility.raise_error;

837: -- Proceed with validation based on outcome of api_updating call.
838: if (not l_api_updating and p_encoded_error is not null)
839: then
840: hr_utility.set_message(800,'PER_52142_AHC_ENC_ERR_NOT_NULL');
841: hr_utility.raise_error;
842: elsif
843: (l_api_updating and
844: (p_status = 'N' or p_status = 'V') and
845: p_encoded_error is not null)

Line 847: hr_utility.set_message(800,'PER_52143_AHC_E_ERR_NOT_NULL2');

843: (l_api_updating and
844: (p_status = 'N' or p_status = 'V') and
845: p_encoded_error is not null)
846: then
847: hr_utility.set_message(800,'PER_52143_AHC_E_ERR_NOT_NULL2');
848: hr_utility.raise_error;
849: end if;
850:
851: hr_utility.set_location('Leaving: '||l_proc,10);

Line 848: hr_utility.raise_error;

844: (p_status = 'N' or p_status = 'V') and
845: p_encoded_error is not null)
846: then
847: hr_utility.set_message(800,'PER_52143_AHC_E_ERR_NOT_NULL2');
848: hr_utility.raise_error;
849: end if;
850:
851: hr_utility.set_location('Leaving: '||l_proc,10);
852: end chk_encoded_error;

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

847: hr_utility.set_message(800,'PER_52143_AHC_E_ERR_NOT_NULL2');
848: hr_utility.raise_error;
849: end if;
850:
851: hr_utility.set_location('Leaving: '||l_proc,10);
852: end chk_encoded_error;
853: --
854: --
855: -- -----------------------------------------------------------------

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

892: l_api_updating boolean;
893: --
894: --
895: begin
896: hr_utility.set_location('Entering: '||l_proc,5);
897:
898: --------------------------------
899: -- Check status not null --
900: --------------------------------

Line 923: hr_utility.set_message(800,'PER_52140_AHC_STATUS_INV');

919: if hr_api.not_exists_in_hr_lookups
920: (p_effective_date => p_effective_date,
921: p_lookup_type => 'API_HOOK_CALL_STATUS',
922: p_lookup_code => p_status) then
923: hr_utility.set_message(800,'PER_52140_AHC_STATUS_INV');
924: hr_utility.raise_error;
925: end if;
926:
927: --------------------------------------

Line 924: hr_utility.raise_error;

920: (p_effective_date => p_effective_date,
921: p_lookup_type => 'API_HOOK_CALL_STATUS',
922: p_lookup_code => p_status) then
923: hr_utility.set_message(800,'PER_52140_AHC_STATUS_INV');
924: hr_utility.raise_error;
925: end if;
926:
927: --------------------------------------
928: -- Status must be 'N' during insert --

Line 931: hr_utility.set_message(800,'PER_52141_AHC_INV_STA_ON_INS');

927: --------------------------------------
928: -- Status must be 'N' during insert --
929: --------------------------------------
930: if (not l_api_updating and p_status <> 'N') then
931: hr_utility.set_message(800,'PER_52141_AHC_INV_STA_ON_INS');
932: hr_utility.raise_error;
933: end if;
934:
935: end if;

Line 932: hr_utility.raise_error;

928: -- Status must be 'N' during insert --
929: --------------------------------------
930: if (not l_api_updating and p_status <> 'N') then
931: hr_utility.set_message(800,'PER_52141_AHC_INV_STA_ON_INS');
932: hr_utility.raise_error;
933: end if;
934:
935: end if;
936: hr_utility.set_location('Leaving: '||l_proc,10);

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

932: hr_utility.raise_error;
933: end if;
934:
935: end if;
936: hr_utility.set_location('Leaving: '||l_proc,10);
937: end chk_status;
938: --
939: -- ----------------------------------------------------------------------------
940: -- |-----------------------< chk_application_id >-----------------------------|

Line 983: hr_utility.set_message(800,'PER_289085_AHC_INVALID_APPL');

979: --
980: IF csr_check_app_id%NOTFOUND THEN
981: -- Application does not exist
982: CLOSE csr_check_app_id;
983: hr_utility.set_message(800,'PER_289085_AHC_INVALID_APPL');
984: hr_utility.raise_error;
985: END IF;
986: CLOSE csr_check_app_id;
987: --

Line 984: hr_utility.raise_error;

980: IF csr_check_app_id%NOTFOUND THEN
981: -- Application does not exist
982: CLOSE csr_check_app_id;
983: hr_utility.set_message(800,'PER_289085_AHC_INVALID_APPL');
984: hr_utility.raise_error;
985: END IF;
986: CLOSE csr_check_app_id;
987: --
988: END IF;

Line 1027: hr_utility.set_message(800,'PER_289086_AHC_INST_STAT_NULL');

1023: --
1024: IF ((p_application_id IS NULL) and (p_app_install_status IS NOT NULL)) THEN
1025: --
1026: -- Error - app_install_status must be null when app_id is null
1027: hr_utility.set_message(800,'PER_289086_AHC_INST_STAT_NULL');
1028: hr_utility.raise_error;
1029: --
1030: ELSIF ((p_application_id IS NOT NULL) and (p_app_install_status IS NULL)) THEN
1031: --

Line 1028: hr_utility.raise_error;

1024: IF ((p_application_id IS NULL) and (p_app_install_status IS NOT NULL)) THEN
1025: --
1026: -- Error - app_install_status must be null when app_id is null
1027: hr_utility.set_message(800,'PER_289086_AHC_INST_STAT_NULL');
1028: hr_utility.raise_error;
1029: --
1030: ELSIF ((p_application_id IS NOT NULL) and (p_app_install_status IS NULL)) THEN
1031: --
1032: -- Error - app_install_status is mandatory when app_id is not null

Line 1033: hr_utility.set_message(800,'PER_289087_AHC_MAND_INSTALL_ST');

1029: --
1030: ELSIF ((p_application_id IS NOT NULL) and (p_app_install_status IS NULL)) THEN
1031: --
1032: -- Error - app_install_status is mandatory when app_id is not null
1033: hr_utility.set_message(800,'PER_289087_AHC_MAND_INSTALL_ST');
1034: hr_utility.raise_error;
1035: ELSE
1036: -- combination of application_id and app_install_status is ok
1037: IF p_app_install_status IS NOT NULL THEN

Line 1034: hr_utility.raise_error;

1030: ELSIF ((p_application_id IS NOT NULL) and (p_app_install_status IS NULL)) THEN
1031: --
1032: -- Error - app_install_status is mandatory when app_id is not null
1033: hr_utility.set_message(800,'PER_289087_AHC_MAND_INSTALL_ST');
1034: hr_utility.raise_error;
1035: ELSE
1036: -- combination of application_id and app_install_status is ok
1037: IF p_app_install_status IS NOT NULL THEN
1038: -- validate against HR_LOOKUPS

Line 1043: hr_utility.set_message(800,'PER_289088_AHC_INST_STATUS_ERR');

1039: if hr_api.not_exists_in_hr_lookups
1040: (p_effective_date => p_effective_date,
1041: p_lookup_type => 'APP_INSTALL_STATUS',
1042: p_lookup_code => p_app_install_status) then
1043: hr_utility.set_message(800,'PER_289088_AHC_INST_STATUS_ERR');
1044: hr_utility.raise_error;
1045: end if;
1046: END IF;
1047: END IF;

Line 1044: hr_utility.raise_error;

1040: (p_effective_date => p_effective_date,
1041: p_lookup_type => 'APP_INSTALL_STATUS',
1042: p_lookup_code => p_app_install_status) then
1043: hr_utility.set_message(800,'PER_289088_AHC_INST_STATUS_ERR');
1044: hr_utility.raise_error;
1045: end if;
1046: END IF;
1047: END IF;
1048: --

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

1056: --
1057: l_proc varchar2(72) := g_package||'insert_validate';
1058: --
1059: Begin
1060: hr_utility.set_location('Entering:'||l_proc, 5);
1061: --
1062: -- As this data is not within the context of a business group
1063: -- the set_security_group_id procedure has zero passed
1064: -- to it as the default security_group_id.

Line 1068: hr_utility.set_location('Entering:'||l_proc, 6);

1064: -- to it as the default security_group_id.
1065: --
1066: hr_api.set_security_group_id(p_security_group_id => 0);
1067: --
1068: hr_utility.set_location('Entering:'||l_proc, 6);
1069: --
1070: -- Call all supporting business operations
1071: --
1072: -- Validate the api_hook_id

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

1171: p_encoded_error => p_rec.encoded_error,
1172: p_status => p_rec.status,
1173: p_object_version_number => p_rec.object_version_number);
1174: --
1175: hr_utility.set_location(' Leaving:'||l_proc, 10);
1176: End insert_validate;
1177: --
1178: -- ----------------------------------------------------------------------------
1179: -- |---------------------------< update_validate >----------------------------|

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

1183: --
1184: l_proc varchar2(72) := g_package||'update_validate';
1185: --
1186: Begin
1187: hr_utility.set_location('Entering:'||l_proc, 5);
1188: --
1189: -- As this data is not within the context of a business group
1190: -- the set_security_group_id procedure has zero passed
1191: -- to it as the default security_group_id.

Line 1195: hr_utility.set_location('Entering:'||l_proc, 6);

1191: -- to it as the default security_group_id.
1192: --
1193: hr_api.set_security_group_id(p_security_group_id => 0);
1194: --
1195: hr_utility.set_location('Entering:'||l_proc, 6);
1196: --
1197: -- Check that non-updateable columns have not been updated
1198: chk_non_updateable_args
1199: (p_effective_date => p_effective_date

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

1283: p_encoded_error => p_rec.encoded_error,
1284: p_status => p_rec.status,
1285: p_object_version_number => p_rec.object_version_number);
1286: --
1287: hr_utility.set_location(' Leaving:'||l_proc, 10);
1288: End update_validate;
1289: --
1290: -- ----------------------------------------------------------------------------
1291: -- |---------------------------< delete_validate >----------------------------|

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

1294: --
1295: l_proc varchar2(72) := g_package||'delete_validate';
1296: --
1297: Begin
1298: hr_utility.set_location('Entering:'||l_proc, 5);
1299: --
1300: -- Call all supporting business operations
1301: --
1302: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1298: hr_utility.set_location('Entering:'||l_proc, 5);
1299: --
1300: -- Call all supporting business operations
1301: --
1302: hr_utility.set_location(' Leaving:'||l_proc, 10);
1303: End delete_validate;
1304: --
1305: end hr_ahc_bus;