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

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

16: l_proc varchar2(72) := g_package||'chk_qualification_type_id';
17: l_api_updating boolean;
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: l_api_updating := per_eqt_shd.api_updating
23: (p_qualification_type_id => p_qualification_type_id,
24: p_object_version_number => p_object_version_number);

Line 54: hr_utility.set_location('Leaving:'||l_proc,5);

50: end if;
51: --
52: end if;
53: --
54: hr_utility.set_location('Leaving:'||l_proc,5);
55: --
56: end chk_qualification_type_id;
57: --
58: -- ----------------------------------------------------------------------------

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

91: l_api_updating boolean;
92: --
93: Begin
94: --
95: hr_utility.set_location('Entering:'||l_proc, 5);
96: --
97: l_api_updating := per_eqt_shd.api_updating
98: (p_qualification_type_id => p_qualification_type_id,
99: p_object_version_number => p_object_version_number);

Line 114: hr_utility.set_message(801,'HR_51880_EQT_CAT_LKP');

110: p_effective_date => p_effective_date) then
111: --
112: -- raise error as does not exist as lookup
113: --
114: hr_utility.set_message(801,'HR_51880_EQT_CAT_LKP');
115: hr_utility.raise_error;
116: --
117: end if;
118: --

Line 115: hr_utility.raise_error;

111: --
112: -- raise error as does not exist as lookup
113: --
114: hr_utility.set_message(801,'HR_51880_EQT_CAT_LKP');
115: hr_utility.raise_error;
116: --
117: end if;
118: --
119: end if;

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

117: end if;
118: --
119: end if;
120: --
121: hr_utility.set_location('Leaving:'||l_proc,10);
122: --
123: end chk_category;
124: -- ----------------------------------------------------------------------------
125: -- |-----------------------< chk_qualification_delete >-----------------------|

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

142: from per_competence_elements comp
143: where comp.qualification_type_id = p_qualification_type_id;
144: Begin
145: --
146: hr_utility.set_location('Entering:'||l_proc, 5);
147: --
148: open c1;
149: --
150: fetch c1 into l_dummy;

Line 158: hr_utility.set_message(801,'HR_51537_EQT_QUAL_TAB_REF');

154: -- error cannot delete qualification_type_id as it is used in the
155: -- per_qualifications table
156: --
157: close c1;
158: hr_utility.set_message(801,'HR_51537_EQT_QUAL_TAB_REF');
159: hr_utility.raise_error;
160: --
161: end if;
162: --

Line 159: hr_utility.raise_error;

155: -- per_qualifications table
156: --
157: close c1;
158: hr_utility.set_message(801,'HR_51537_EQT_QUAL_TAB_REF');
159: hr_utility.raise_error;
160: --
161: end if;
162: --
163: close c1;

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

161: end if;
162: --
163: close c1;
164: --
165: hr_utility.set_location(l_proc,10);
166: --
167: open c2;
168: --
169: fetch c2 into l_dummy;

Line 177: hr_utility.set_message(800,'HR_449133_QUA_FWK_EQT_TAB_REF');

173: -- error cannot delete qualification_type_id as it is used in the
174: -- per_competence_elements table
175: --
176: close c2;
177: hr_utility.set_message(800,'HR_449133_QUA_FWK_EQT_TAB_REF');
178: hr_utility.raise_error;
179: --
180: end if;
181: --

Line 178: hr_utility.raise_error;

174: -- per_competence_elements table
175: --
176: close c2;
177: hr_utility.set_message(800,'HR_449133_QUA_FWK_EQT_TAB_REF');
178: hr_utility.raise_error;
179: --
180: end if;
181: --
182: close c2;

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

179: --
180: end if;
181: --
182: close c2;
183: hr_utility.set_location('Leaving:'||l_proc,20);
184: --
185: end chk_qualification_delete;
186: --
187: -------------------------------------------------------------------------------

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

229: l_api_updating boolean;
230: l_exists varchar2(1);
231: --
232: begin
233: hr_utility.set_location('Entering:'|| l_proc, 10);
234: --
235: -- Only proceed with validation if :
236: -- a) The current g_old_rec is current and
237: -- b) The value for qualification_type type has changed

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

247: ) or
248: (NOT l_api_updating)
249: ) then
250: --
251: hr_utility.set_location(l_proc, 20);
252: open csr_qual_framework_id;
253: fetch csr_qual_framework_id into l_exists;
254: if csr_qual_framework_id%FOUND then
255: close csr_qual_framework_id;

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

253: fetch csr_qual_framework_id into l_exists;
254: if csr_qual_framework_id%FOUND then
255: close csr_qual_framework_id;
256: --
257: hr_utility.set_location(l_proc, 30);
258: --
259: hr_utility.set_message(800, 'HR_449144_QUA_FWK_ID_EXISTS');
260: hr_utility.raise_error;
261: --

Line 259: hr_utility.set_message(800, 'HR_449144_QUA_FWK_ID_EXISTS');

255: close csr_qual_framework_id;
256: --
257: hr_utility.set_location(l_proc, 30);
258: --
259: hr_utility.set_message(800, 'HR_449144_QUA_FWK_ID_EXISTS');
260: hr_utility.raise_error;
261: --
262: END IF;
263: close csr_qual_framework_id;

Line 260: hr_utility.raise_error;

256: --
257: hr_utility.set_location(l_proc, 30);
258: --
259: hr_utility.set_message(800, 'HR_449144_QUA_FWK_ID_EXISTS');
260: hr_utility.raise_error;
261: --
262: END IF;
263: close csr_qual_framework_id;
264: end if;

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

263: close csr_qual_framework_id;
264: end if;
265: end if;
266: --
267: hr_utility.set_location('Leaving: '|| l_proc, 40);
268: --
269: end chk_qual_framework_id;
270: --
271: --

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

308: l_proc varchar2(72) := g_package||'chk_qualification_type';
309: l_api_updating boolean;
310: --
311: begin
312: hr_utility.set_location('Entering:'|| l_proc, 10);
313: --
314: -- Only proceed with validation if :
315: -- a) The current g_old_rec is current and
316: -- b) The value for qualification_type type has changed

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

326: ) or
327: (NOT l_api_updating)
328: ) then
329: --
330: hr_utility.set_location(l_proc, 20);
331: --
332: -- Check that the category exists in HR_LOOKUPS
333: --
334: IF hr_api.not_exists_in_hr_lookups

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

335: (p_effective_date => p_effective_date
336: ,p_lookup_type => 'PER_QUAL_FWK_QUAL_TYPE'
337: ,p_lookup_code => p_qualification_type) THEN
338: --
339: hr_utility.set_location(l_proc, 30);
340: --
341: hr_utility.set_message(800, 'HR_449101_QUA_FWK_QUAL_TYP_LKP');
342: hr_utility.raise_error;
343: --

Line 341: hr_utility.set_message(800, 'HR_449101_QUA_FWK_QUAL_TYP_LKP');

337: ,p_lookup_code => p_qualification_type) THEN
338: --
339: hr_utility.set_location(l_proc, 30);
340: --
341: hr_utility.set_message(800, 'HR_449101_QUA_FWK_QUAL_TYP_LKP');
342: hr_utility.raise_error;
343: --
344: END IF;
345: end if;

Line 342: hr_utility.raise_error;

338: --
339: hr_utility.set_location(l_proc, 30);
340: --
341: hr_utility.set_message(800, 'HR_449101_QUA_FWK_QUAL_TYP_LKP');
342: hr_utility.raise_error;
343: --
344: END IF;
345: end if;
346: end if;

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

344: END IF;
345: end if;
346: end if;
347: --
348: hr_utility.set_location('Leaving: '|| l_proc, 40);
349: --
350: end chk_qualification_type;
351: --
352: -------------------------------------------------------------------------------

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

388: l_proc varchar2(72) := g_package||'chk_credit_type';
389: l_api_updating boolean;
390: --
391: begin
392: hr_utility.set_location('Entering:'|| l_proc, 10);
393: --
394: -- Only proceed with validation if :
395: -- a) The current g_old_rec is current and
396: -- b) The value for credit type has changed

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

406: ) or
407: (NOT l_api_updating)
408: ) then
409: --
410: hr_utility.set_location(l_proc, 20);
411: --
412: -- Check that the category exists in HR_LOOKUPS
413: --
414: IF hr_api.not_exists_in_hr_lookups

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

415: (p_effective_date => p_effective_date
416: ,p_lookup_type => 'PER_QUAL_FWK_CREDIT_TYPE'
417: ,p_lookup_code => p_credit_type) THEN
418: --
419: hr_utility.set_location(l_proc, 30);
420: --
421: hr_utility.set_message(800, 'HR_449092_QUA_FWK_CRDT_TYP_LKP');
422: hr_utility.raise_error;
423: --

Line 421: hr_utility.set_message(800, 'HR_449092_QUA_FWK_CRDT_TYP_LKP');

417: ,p_lookup_code => p_credit_type) THEN
418: --
419: hr_utility.set_location(l_proc, 30);
420: --
421: hr_utility.set_message(800, 'HR_449092_QUA_FWK_CRDT_TYP_LKP');
422: hr_utility.raise_error;
423: --
424: END IF;
425: end if;

Line 422: hr_utility.raise_error;

418: --
419: hr_utility.set_location(l_proc, 30);
420: --
421: hr_utility.set_message(800, 'HR_449092_QUA_FWK_CRDT_TYP_LKP');
422: hr_utility.raise_error;
423: --
424: END IF;
425: end if;
426: end if;

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

424: END IF;
425: end if;
426: end if;
427: --
428: hr_utility.set_location('Leaving: '|| l_proc, 40);
429: --
430: end chk_credit_type;
431: --
432: --

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

469: l_proc varchar2(72) := g_package||'chk_level_type';
470: l_api_updating boolean;
471: --
472: begin
473: hr_utility.set_location('Entering:'|| l_proc, 10);
474: --
475: -- Only proceed with validation if :
476: -- a) The current g_old_rec is current and
477: -- b) The value for level type has changed

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

487: ) or
488: (NOT l_api_updating)
489: ) then
490: --
491: hr_utility.set_location(l_proc, 20);
492: --
493: -- Check that the category exists in HR_LOOKUPS
494: --
495: IF hr_api.not_exists_in_hr_lookups

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

496: (p_effective_date => p_effective_date
497: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL_TYPE'
498: ,p_lookup_code => p_level_type) THEN
499: --
500: hr_utility.set_location(l_proc, 30);
501: --
502: hr_utility.set_message(800, 'HR_449090_QUA_FWK_LVL_TYPE_LKP');
503: hr_utility.raise_error;
504: --

Line 502: hr_utility.set_message(800, 'HR_449090_QUA_FWK_LVL_TYPE_LKP');

498: ,p_lookup_code => p_level_type) THEN
499: --
500: hr_utility.set_location(l_proc, 30);
501: --
502: hr_utility.set_message(800, 'HR_449090_QUA_FWK_LVL_TYPE_LKP');
503: hr_utility.raise_error;
504: --
505: END IF;
506: end if;

Line 503: hr_utility.raise_error;

499: --
500: hr_utility.set_location(l_proc, 30);
501: --
502: hr_utility.set_message(800, 'HR_449090_QUA_FWK_LVL_TYPE_LKP');
503: hr_utility.raise_error;
504: --
505: END IF;
506: end if;
507: end if;

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

505: END IF;
506: end if;
507: end if;
508: --
509: hr_utility.set_location('Leaving: '|| l_proc, 40);
510: --
511: end chk_level_type;
512: --
513: --

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

550: l_proc varchar2(72) := g_package||'chk_level_number';
551: l_api_updating boolean;
552: --
553: begin
554: hr_utility.set_location('Entering:'|| l_proc, 10);
555: --
556: -- Only proceed with validation if :
557: -- a) The current g_old_rec is current and
558: -- b) The value for level has changed

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

568: ) or
569: (NOT l_api_updating)
570: ) then
571: --
572: hr_utility.set_location(l_proc, 20);
573: --
574: -- Check that the category exists in HR_LOOKUPS
575: --
576: IF hr_api.not_exists_in_hr_lookups

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

577: (p_effective_date => p_effective_date
578: ,p_lookup_type => 'PER_QUAL_FWK_LEVEL'
579: ,p_lookup_code => p_level_number) THEN
580: --
581: hr_utility.set_location(l_proc, 30);
582: --
583: hr_utility.set_message(800, 'HR_449091_QUA_FWK_LEVEL_LKP');
584: hr_utility.raise_error;
585: --

Line 583: hr_utility.set_message(800, 'HR_449091_QUA_FWK_LEVEL_LKP');

579: ,p_lookup_code => p_level_number) THEN
580: --
581: hr_utility.set_location(l_proc, 30);
582: --
583: hr_utility.set_message(800, 'HR_449091_QUA_FWK_LEVEL_LKP');
584: hr_utility.raise_error;
585: --
586: END IF;
587: end if;

Line 584: hr_utility.raise_error;

580: --
581: hr_utility.set_location(l_proc, 30);
582: --
583: hr_utility.set_message(800, 'HR_449091_QUA_FWK_LEVEL_LKP');
584: hr_utility.raise_error;
585: --
586: END IF;
587: end if;
588: end if;

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

586: END IF;
587: end if;
588: end if;
589: --
590: hr_utility.set_location('Leaving: '|| l_proc, 40);
591: --
592: end chk_level_number;
593: --
594: --

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

631: l_proc varchar2(72) := g_package||'chk_field';
632: l_api_updating boolean;
633: --
634: begin
635: hr_utility.set_location('Entering:'|| l_proc, 10);
636: --
637: -- Only proceed with validation if :
638: -- a) The current g_old_rec is current and
639: -- b) The value for field has changed

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

649: ) or
650: (NOT l_api_updating)
651: ) then
652: --
653: hr_utility.set_location(l_proc, 20);
654: --
655: -- Check that the category exists in HR_LOOKUPS
656: --
657: IF hr_api.not_exists_in_hr_lookups

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

658: (p_effective_date => p_effective_date
659: ,p_lookup_type => 'PER_QUAL_FWK_FIELD'
660: ,p_lookup_code => p_field) THEN
661: --
662: hr_utility.set_location(l_proc, 30);
663: --
664: hr_utility.set_message(800, 'HR_449093_QUA_FWK_FIELD_LKP');
665: hr_utility.raise_error;
666: --

Line 664: hr_utility.set_message(800, 'HR_449093_QUA_FWK_FIELD_LKP');

660: ,p_lookup_code => p_field) THEN
661: --
662: hr_utility.set_location(l_proc, 30);
663: --
664: hr_utility.set_message(800, 'HR_449093_QUA_FWK_FIELD_LKP');
665: hr_utility.raise_error;
666: --
667: END IF;
668: end if;

Line 665: hr_utility.raise_error;

661: --
662: hr_utility.set_location(l_proc, 30);
663: --
664: hr_utility.set_message(800, 'HR_449093_QUA_FWK_FIELD_LKP');
665: hr_utility.raise_error;
666: --
667: END IF;
668: end if;
669: end if;

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

667: END IF;
668: end if;
669: end if;
670: --
671: hr_utility.set_location('Leaving: '|| l_proc, 40);
672: --
673: end chk_field;
674: --
675: --

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

712: l_proc varchar2(72) := g_package||'chk_sub_field';
713: l_api_updating boolean;
714: --
715: begin
716: hr_utility.set_location('Entering:'|| l_proc, 10);
717: --
718: -- Only proceed with validation if :
719: -- a) The current g_old_rec is current and
720: -- b) The value for sub field has changed

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

730: ) or
731: (NOT l_api_updating)
732: ) then
733: --
734: hr_utility.set_location(l_proc, 20);
735: --
736: -- Check that the category exists in HR_LOOKUPS
737: --
738: IF hr_api.not_exists_in_hr_lookups

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

739: (p_effective_date => p_effective_date
740: ,p_lookup_type => 'PER_QUAL_FWK_SUB_FIELD'
741: ,p_lookup_code => p_sub_field) THEN
742: --
743: hr_utility.set_location(l_proc, 30);
744: --
745: hr_utility.set_message(800, 'HR_449094_QUA_FWK_SUB_FLD_LKP');
746: hr_utility.raise_error;
747: --

Line 745: hr_utility.set_message(800, 'HR_449094_QUA_FWK_SUB_FLD_LKP');

741: ,p_lookup_code => p_sub_field) THEN
742: --
743: hr_utility.set_location(l_proc, 30);
744: --
745: hr_utility.set_message(800, 'HR_449094_QUA_FWK_SUB_FLD_LKP');
746: hr_utility.raise_error;
747: --
748: END IF;
749: end if;

Line 746: hr_utility.raise_error;

742: --
743: hr_utility.set_location(l_proc, 30);
744: --
745: hr_utility.set_message(800, 'HR_449094_QUA_FWK_SUB_FLD_LKP');
746: hr_utility.raise_error;
747: --
748: END IF;
749: end if;
750: end if;

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

748: END IF;
749: end if;
750: end if;
751: --
752: hr_utility.set_location('Leaving: '|| l_proc, 40);
753: --
754: end chk_sub_field;
755: --
756: --

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

793: l_proc varchar2(72) := g_package||'chk_provider';
794: l_api_updating boolean;
795: --
796: begin
797: hr_utility.set_location('Entering:'|| l_proc, 10);
798: --
799: -- Only proceed with validation if :
800: -- a) The current g_old_rec is current and
801: -- b) The value for provider has changed

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

811: ) or
812: (NOT l_api_updating)
813: ) then
814: --
815: hr_utility.set_location(l_proc, 20);
816: --
817: -- Check that the category exists in HR_LOOKUPS
818: --
819: IF hr_api.not_exists_in_hr_lookups

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

820: (p_effective_date => p_effective_date
821: ,p_lookup_type => 'PER_QUAL_FWK_PROVIDER'
822: ,p_lookup_code => p_provider) THEN
823: --
824: hr_utility.set_location(l_proc, 30);
825: --
826: hr_utility.set_message(800, 'HR_449095_QUA_FWK_PROVIDER_LKP');
827: hr_utility.raise_error;
828: --

Line 826: hr_utility.set_message(800, 'HR_449095_QUA_FWK_PROVIDER_LKP');

822: ,p_lookup_code => p_provider) THEN
823: --
824: hr_utility.set_location(l_proc, 30);
825: --
826: hr_utility.set_message(800, 'HR_449095_QUA_FWK_PROVIDER_LKP');
827: hr_utility.raise_error;
828: --
829: END IF;
830: end if;

Line 827: hr_utility.raise_error;

823: --
824: hr_utility.set_location(l_proc, 30);
825: --
826: hr_utility.set_message(800, 'HR_449095_QUA_FWK_PROVIDER_LKP');
827: hr_utility.raise_error;
828: --
829: END IF;
830: end if;
831: end if;

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

829: END IF;
830: end if;
831: end if;
832: --
833: hr_utility.set_location('Leaving: '|| l_proc, 40);
834: --
835: end chk_provider;
836: --
837: --

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

874: l_proc varchar2(72) := g_package||'chk_qa_organization';
875: l_api_updating boolean;
876: --
877: begin
878: hr_utility.set_location('Entering:'|| l_proc, 10);
879: --
880: -- Only proceed with validation if :
881: -- a) The current g_old_rec is current and
882: -- b) The value for qa organization has changed

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

892: ) or
893: (NOT l_api_updating)
894: ) then
895: --
896: hr_utility.set_location(l_proc, 20);
897: --
898: -- Check that the category exists in HR_LOOKUPS
899: --
900: IF hr_api.not_exists_in_hr_lookups

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

901: (p_effective_date => p_effective_date
902: ,p_lookup_type => 'PER_QUAL_FWK_QA_ORG'
903: ,p_lookup_code => p_qa_organization) THEN
904: --
905: hr_utility.set_location(l_proc, 30);
906: --
907: hr_utility.set_message(800, 'HR_449096_QUA_FWK_QA_ORG_LKP');
908: hr_utility.raise_error;
909: --

Line 907: hr_utility.set_message(800, 'HR_449096_QUA_FWK_QA_ORG_LKP');

903: ,p_lookup_code => p_qa_organization) THEN
904: --
905: hr_utility.set_location(l_proc, 30);
906: --
907: hr_utility.set_message(800, 'HR_449096_QUA_FWK_QA_ORG_LKP');
908: hr_utility.raise_error;
909: --
910: END IF;
911: end if;

Line 908: hr_utility.raise_error;

904: --
905: hr_utility.set_location(l_proc, 30);
906: --
907: hr_utility.set_message(800, 'HR_449096_QUA_FWK_QA_ORG_LKP');
908: hr_utility.raise_error;
909: --
910: END IF;
911: end if;
912: end if;

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

910: END IF;
911: end if;
912: end if;
913: --
914: hr_utility.set_location('Leaving: '|| l_proc, 40);
915: --
916: end chk_qa_organization;
917: --
918: -- -----------------------------------------------------------------------

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

947: --
948: l_proc varchar2(72) := g_package||'chk_df';
949: --
950: begin
951: hr_utility.set_location('Entering:'||l_proc, 10);
952: --
953: if ((p_rec.qualification_type_id is not null) and (
954: nvl(per_eqt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
955: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1047: ,p_attribute20_value => p_rec.attribute20
1048: );
1049: end if;
1050: --
1051: hr_utility.set_location(' Leaving:'||l_proc, 20);
1052:
1053: end chk_df;
1054:
1055: -- mvankada

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

1085: --
1086: l_proc varchar2(72) := g_package||'chk_ddf';
1087: --
1088: begin
1089: hr_utility.set_location('Entering:'||l_proc, 10);
1090: --
1091:
1092: if ((p_rec.qualification_type_id is not null) and (
1093: nvl(per_eqt_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

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

1226: ,p_attribute30_value => p_rec.information30
1227: );
1228: end if;
1229:
1230: hr_utility.set_location(' Leaving:'||l_proc, 20);
1231:
1232: end chk_ddf;
1233:
1234:

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

1241: l_proc varchar2(72) := g_package||'insert_validate';
1242: --
1243: Begin
1244: --
1245: hr_utility.set_location('Entering:'||l_proc, 5);
1246: --
1247: -- As this data is not within the context of a business group
1248: -- the set_security_group_id procedure has zero passed
1249: -- to it as the default security_group_id.

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

1251: -- Fix for bug 2723065
1252: -- Commented line which hardcodes security profile to '0'
1253: -- hr_api.set_security_group_id(p_security_group_id => 0);
1254: --
1255: hr_utility.set_location('Entering:'||l_proc, 7);
1256: --
1257: -- Call all supporting business operations
1258: --
1259: -- Business Rule Mapping

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

1283: ,p_qual_framework_id => p_rec.qual_framework_id
1284: ,p_object_version_number => p_rec.object_version_number
1285: );
1286:
1287: hr_utility.set_location(l_proc, 40);
1288: --
1289: -- Business Rule Mapping
1290: -- =====================
1291: -- CHK_QUALIFICATION_TYPE

Line 1299: hr_utility.set_location(l_proc, 50);

1295: ,p_qualification_type => p_rec.qualification_type
1296: ,p_object_version_number => p_rec.object_version_number
1297: ,p_effective_date => p_effective_date
1298: );
1299: hr_utility.set_location(l_proc, 50);
1300: --
1301: -- Business Rule Mapping
1302: -- =====================
1303: -- CHK_CREDIT_TYPE

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

1307: ,p_credit_type => p_rec.credit_type
1308: ,p_object_version_number => p_rec.object_version_number
1309: ,p_effective_date => p_effective_date
1310: );
1311: hr_utility.set_location(l_proc, 60);
1312: --
1313: -- Business Rule Mapping
1314: -- =====================
1315: -- CHK_LEVEL_TYPE

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

1319: ,p_level_type => p_rec.level_type
1320: ,p_object_version_number => p_rec.object_version_number
1321: ,p_effective_date => p_effective_date
1322: );
1323: hr_utility.set_location(l_proc, 70);
1324: --
1325: -- Business Rule Mapping
1326: -- =====================
1327: -- CHK_LEVEL_LEVEL

Line 1335: hr_utility.set_location(l_proc, 80);

1331: ,p_level_number => p_rec.level_number
1332: ,p_object_version_number => p_rec.object_version_number
1333: ,p_effective_date => p_effective_date
1334: );
1335: hr_utility.set_location(l_proc, 80);
1336: --
1337: -- Business Rule Mapping
1338: -- =====================
1339: -- CHK_FIELD

Line 1347: hr_utility.set_location(l_proc, 90);

1343: ,p_field => p_rec.field
1344: ,p_object_version_number => p_rec.object_version_number
1345: ,p_effective_date => p_effective_date
1346: );
1347: hr_utility.set_location(l_proc, 90);
1348: --
1349: -- Business Rule Mapping
1350: -- =====================
1351: -- CHK_SUB_FIELD

Line 1359: hr_utility.set_location(l_proc, 100);

1355: ,p_sub_field => p_rec.sub_field
1356: ,p_object_version_number => p_rec.object_version_number
1357: ,p_effective_date => p_effective_date
1358: );
1359: hr_utility.set_location(l_proc, 100);
1360: --
1361: -- Business Rule Mapping
1362: -- =====================
1363: -- CHK_PROVIDER

Line 1373: hr_utility.set_location(l_proc, 110);

1369: ,p_provider => p_rec.provider
1370: ,p_object_version_number => p_rec.object_version_number
1371: ,p_effective_date => p_effective_date
1372: );
1373: hr_utility.set_location(l_proc, 110);
1374: --
1375: -- Business Rule Mapping
1376: -- =====================
1377: -- CHK_QA_ORGANIZATION

Line 1385: hr_utility.set_location(l_proc, 120);

1381: ,p_qa_organization => p_rec.qa_organization
1382: ,p_object_version_number => p_rec.object_version_number
1383: ,p_effective_date => p_effective_date
1384: );
1385: hr_utility.set_location(l_proc, 120);
1386: --
1387: -- Descriptive Flex Check
1388: -- ======================
1389: --

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

1395: -- ================================
1396: --
1397: per_eqt_bus.chk_ddf(p_rec => p_rec);
1398: --
1399: hr_utility.set_location(' Leaving:'||l_proc, 10);
1400: --
1401: End insert_validate;
1402: --
1403: -- ----------------------------------------------------------------------------

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

1409: l_proc varchar2(72) := g_package||'update_validate';
1410: --
1411: Begin
1412: --
1413: hr_utility.set_location('Entering:'||l_proc, 5);
1414: --
1415: -- As this data is not within the context of a business group
1416: -- the set_security_group_id procedure has zero passed
1417: -- to it as the default security_group_id.

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

1449: (p_qualification_type_id => p_rec.qualification_type_id
1450: ,p_qual_framework_id => p_rec.qual_framework_id
1451: ,p_object_version_number => p_rec.object_version_number
1452: );
1453: hr_utility.set_location(l_proc, 40);
1454:
1455: --
1456: -- Business Rule Mapping
1457: -- =====================

Line 1466: hr_utility.set_location(l_proc, 50);

1462: ,p_qualification_type => p_rec.qualification_type
1463: ,p_object_version_number => p_rec.object_version_number
1464: ,p_effective_date => p_effective_date
1465: );
1466: hr_utility.set_location(l_proc, 50);
1467:
1468: --
1469: -- Business Rule Mapping
1470: -- =====================

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

1475: ,p_credit_type => p_rec.credit_type
1476: ,p_object_version_number => p_rec.object_version_number
1477: ,p_effective_date => p_effective_date
1478: );
1479: hr_utility.set_location(l_proc, 60);
1480:
1481: --
1482: -- Business Rule Mapping
1483: -- =====================

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

1488: ,p_level_type => p_rec.level_type
1489: ,p_object_version_number => p_rec.object_version_number
1490: ,p_effective_date => p_effective_date
1491: );
1492: hr_utility.set_location(l_proc, 70);
1493: --
1494: -- Business Rule Mapping
1495: -- =====================
1496: -- CHK_LEVEL_LEVEL

Line 1504: hr_utility.set_location(l_proc, 80);

1500: ,p_level_number => p_rec.level_number
1501: ,p_object_version_number => p_rec.object_version_number
1502: ,p_effective_date => p_effective_date
1503: );
1504: hr_utility.set_location(l_proc, 80);
1505: --
1506: -- Business Rule Mapping
1507: -- =====================
1508: -- CHK_FIELD

Line 1516: hr_utility.set_location(l_proc, 90);

1512: ,p_field => p_rec.field
1513: ,p_object_version_number => p_rec.object_version_number
1514: ,p_effective_date => p_effective_date
1515: );
1516: hr_utility.set_location(l_proc, 90);
1517: --
1518: -- Business Rule Mapping
1519: -- =====================
1520: -- CHK_SUB_FIELD

Line 1528: hr_utility.set_location(l_proc, 100);

1524: ,p_sub_field => p_rec.sub_field
1525: ,p_object_version_number => p_rec.object_version_number
1526: ,p_effective_date => p_effective_date
1527: );
1528: hr_utility.set_location(l_proc, 100);
1529: --
1530: -- Business Rule Mapping
1531: -- =====================
1532: -- CHK_PROVIDER

Line 1542: hr_utility.set_location(l_proc, 110);

1538: ,p_provider => p_rec.provider
1539: ,p_object_version_number => p_rec.object_version_number
1540: ,p_effective_date => p_effective_date
1541: );
1542: hr_utility.set_location(l_proc, 110);
1543: --
1544: -- Business Rule Mapping
1545: -- =====================
1546: -- CHK_QA_ORGANIZATION

Line 1554: hr_utility.set_location(l_proc, 120);

1550: ,p_qa_organization => p_rec.qa_organization
1551: ,p_object_version_number => p_rec.object_version_number
1552: ,p_effective_date => p_effective_date
1553: );
1554: hr_utility.set_location(l_proc, 120);
1555: --
1556: -- Descriptive Flex Check
1557: -- ======================
1558: --

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

1564: -- ======================
1565: --
1566: per_eqt_bus.chk_ddf(p_rec => p_rec);
1567: --
1568: hr_utility.set_location(' Leaving:'||l_proc, 10);
1569: --
1570: End update_validate;
1571: --
1572: -- ----------------------------------------------------------------------------

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

1576: --
1577: l_proc varchar2(72) := g_package||'delete_validate';
1578: --
1579: Begin
1580: hr_utility.set_location('Entering:'||l_proc, 5);
1581: --
1582: -- Call all supporting business operations
1583: --
1584: -- Business Rule Mapping

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

1586: -- CHK_QUALIFICATION_DELETE
1587: --
1588: chk_qualification_delete(p_rec.qualification_type_id);
1589: --
1590: hr_utility.set_location(' Leaving:'||l_proc, 10);
1591: End delete_validate;
1592: --
1593: end per_eqt_bus;