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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_tem_shd.api_updating
47: (p_template_id => p_template_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_template_id;
75: --
76: -- ----------------------------------------------------------------------------

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

105: l_proc varchar2(72) := g_package||'chk_tem_dml_allowed';
106: l_api_updating boolean;
107: Begin
108: --
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: l_api_updating := pqh_tem_shd.api_updating
112: (p_template_id => p_template_id,
113: p_object_version_number => p_object_version_number);

Line 123: hr_utility.set_message(8302,'PQH_NO_UPD_FROZEN_TEM');

119: = nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)) then
120: --
121: if nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
122: = 'FREEZE_TEMPLATE' then
123: hr_utility.set_message(8302,'PQH_NO_UPD_FROZEN_TEM');
124: hr_utility.raise_error;
125: End if;
126: --
127: end if;

Line 124: hr_utility.raise_error;

120: --
121: if nvl(pqh_tem_shd.g_old_rec.freeze_status_cd,hr_api.g_varchar2)
122: = 'FREEZE_TEMPLATE' then
123: hr_utility.set_message(8302,'PQH_NO_UPD_FROZEN_TEM');
124: hr_utility.raise_error;
125: End if;
126: --
127: end if;
128: --

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

125: End if;
126: --
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 10);
130: --
131: End chk_tem_dml_allowed;
132: --
133: -- ----------------------------------------------------------------------------

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

175: where a.base_template_id = p_template_id;
176: --
177: Begin
178: --
179: hr_utility.set_location('Entering:'||l_proc,5);
180: --
181:
182: l_api_updating := pqh_tem_shd.api_updating
183: (p_template_id => p_template_id,

Line 194: hr_utility.set_message(8302,'PQH_TEM_DETAILS_EXIST');

190: open c1;
191: Fetch c1 into l_dummy1;
192: if c1%found then
193: close c1;
194: hr_utility.set_message(8302,'PQH_TEM_DETAILS_EXIST');
195: hr_utility.raise_error;
196: End if;
197: close c1;
198:

Line 195: hr_utility.raise_error;

191: Fetch c1 into l_dummy1;
192: if c1%found then
193: close c1;
194: hr_utility.set_message(8302,'PQH_TEM_DETAILS_EXIST');
195: hr_utility.raise_error;
196: End if;
197: close c1;
198:
199: open c2;

Line 203: hr_utility.set_message(8302,'PQH_TEM_DETAILS_EXIST');

199: open c2;
200: Fetch c2 into l_dummy2;
201: if c2%found then
202: close c2;
203: hr_utility.set_message(8302,'PQH_TEM_DETAILS_EXIST');
204: hr_utility.raise_error;
205: End if;
206: close c2;
207:

Line 204: hr_utility.raise_error;

200: Fetch c2 into l_dummy2;
201: if c2%found then
202: close c2;
203: hr_utility.set_message(8302,'PQH_TEM_DETAILS_EXIST');
204: hr_utility.raise_error;
205: End if;
206: close c2;
207:
208: End if;

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

206: close c2;
207:
208: End if;
209: --
210: hr_utility.set_location('Leaving:'||l_proc,10);
211: --
212: End chk_tct_upd_allowed;
213:
214: -- ----------------------------------------------------------------------------

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

251: where a.transaction_category_id = p_transaction_category_id;
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc,5);
256: --
257:
258: l_api_updating := pqh_tem_shd.api_updating
259: (p_template_id => p_template_id,

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

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

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

339: and att.legislation_code is not null;
340: --
341: Begin
342: --
343: hr_utility.set_location('Entering:'||l_proc,5);
344: --
345:
346: l_api_updating := pqh_tem_shd.api_updating
347: (p_template_id => p_template_id,

Line 382: hr_utility.set_message(8302,'PQH_CANT_CHG_TEM_LEG_NULL');

378: fetch c2 into l_tat_leg_code;
379: if c2%found then
380: close c2;
381: if p_legislation_code is null then
382: hr_utility.set_message(8302,'PQH_CANT_CHG_TEM_LEG_NULL');
383: hr_utility.raise_error;
384: end if;
385: end if;
386: --

Line 383: hr_utility.raise_error;

379: if c2%found then
380: close c2;
381: if p_legislation_code is null then
382: hr_utility.set_message(8302,'PQH_CANT_CHG_TEM_LEG_NULL');
383: hr_utility.raise_error;
384: end if;
385: end if;
386: --
387: end if;

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

385: end if;
386: --
387: end if;
388: --
389: hr_utility.set_location('Leaving:'||l_proc,10);
390: --
391: End chk_legislation_code;
392: --
393: --

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

425: l_api_updating boolean;
426: --
427: Begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: l_api_updating := pqh_tem_shd.api_updating
432: (p_template_id => p_template_id,
433: p_object_version_number => p_object_version_number);

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

443: p_transaction_category_id => p_transaction_category_id);
444: --
445: End if;
446: --
447: hr_utility.set_location('Leaving:'||l_proc, 10);
448: --
449: End chk_template_name;
450: --
451: --

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

467: l_api_updating boolean;
468: --
469: Begin
470: --
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: Open csr_tem_name;
474: Fetch csr_tem_name into l_dummy;
475: --

Line 478: hr_utility.set_message(8302,'PQH_DUPLICATE_TEM_NAME');

474: Fetch csr_tem_name into l_dummy;
475: --
476: If csr_tem_name%found then
477: Close csr_tem_name;
478: hr_utility.set_message(8302,'PQH_DUPLICATE_TEM_NAME');
479: hr_utility.raise_error;
480: End if;
481: --
482: Close csr_tem_name;

Line 479: hr_utility.raise_error;

475: --
476: If csr_tem_name%found then
477: Close csr_tem_name;
478: hr_utility.set_message(8302,'PQH_DUPLICATE_TEM_NAME');
479: hr_utility.raise_error;
480: End if;
481: --
482: Close csr_tem_name;
483: --

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

480: End if;
481: --
482: Close csr_tem_name;
483: --
484: hr_utility.set_location('Leaving:'||l_proc, 10);
485: --
486: End chk_template_name_unique;
487: --
488:

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

523: l_api_updating boolean;
524: --
525: Begin
526: --
527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: l_api_updating := pqh_tem_shd.api_updating
530: (p_template_id => p_template_id,
531: p_object_version_number => p_object_version_number);

Line 548: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

544: p_effective_date => p_effective_date) then
545: --
546: -- raise error as does not exist as lookup
547: --
548: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
549: hr_utility.raise_error;
550: --
551: end if;
552: --

Line 549: hr_utility.raise_error;

545: --
546: -- raise error as does not exist as lookup
547: --
548: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
549: hr_utility.raise_error;
550: --
551: end if;
552: --
553: end if;

Line 559: hr_utility.set_message(8302,'PQH_NO_REVIEW_FOR_DOMAIN_TEM');

555: If p_under_review_flag = 'Y' then
556: --
557: if p_template_type_cd = 'DOMAIN' then
558: --
559: hr_utility.set_message(8302,'PQH_NO_REVIEW_FOR_DOMAIN_TEM');
560: hr_utility.raise_error;
561: --
562: End if;
563: --

Line 560: hr_utility.raise_error;

556: --
557: if p_template_type_cd = 'DOMAIN' then
558: --
559: hr_utility.set_message(8302,'PQH_NO_REVIEW_FOR_DOMAIN_TEM');
560: hr_utility.raise_error;
561: --
562: End if;
563: --
564: If p_create_flag = 'Y' then

Line 566: hr_utility.set_message(8302,'PQH_NO_REVIEW_FOR_CREATE_TEM');

562: End if;
563: --
564: If p_create_flag = 'Y' then
565: --
566: hr_utility.set_message(8302,'PQH_NO_REVIEW_FOR_CREATE_TEM');
567: hr_utility.raise_error;
568: --
569: End if;
570: --

Line 567: hr_utility.raise_error;

563: --
564: If p_create_flag = 'Y' then
565: --
566: hr_utility.set_message(8302,'PQH_NO_REVIEW_FOR_CREATE_TEM');
567: hr_utility.raise_error;
568: --
569: End if;
570: --
571: End if;

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

570: --
571: End if;
572: --
573: --
574: hr_utility.set_location('Leaving:'||l_proc,10);
575: --
576: end chk_under_review_flag;
577: --
578: -- ----------------------------------------------------------------------------

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

591: Where template_id = p_template_id;
592: --
593: Begin
594: --
595: hr_utility.set_location('Entering:'||l_proc,5);
596: --
597: Open csr_tem_appl;
598: Fetch csr_tem_appl into l_dummy;
599: --

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

605: Close csr_tem_appl;
606: --
607: RETURN 'Y';
608: --
609: hr_utility.set_location('Leaving:'||l_proc,10);
610: --
611: End;
612: --
613: -- ----------------------------------------------------------------------------

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

647: l_applied_flag varchar2(10);
648: --
649: Begin
650: --
651: hr_utility.set_location('Entering:'||l_proc, 5);
652: --
653: l_api_updating := pqh_tem_shd.api_updating
654: (p_template_id => p_template_id,
655: p_object_version_number => p_object_version_number);

Line 672: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

668: p_effective_date => p_effective_date) then
669: --
670: -- raise error as does not exist as lookup
671: --
672: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
673: hr_utility.raise_error;
674: --
675: end if;
676: --

Line 673: hr_utility.raise_error;

669: --
670: -- raise error as does not exist as lookup
671: --
672: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
673: hr_utility.raise_error;
674: --
675: end if;
676: --
677: End if; /* If update or insert */

Line 690: hr_utility.set_message(8302,'PQH_NO_UPD_TEM_TASK_TYPE');

686: l_applied_flag := chk_if_template_applied(p_template_id => p_template_id);
687: --
688: If l_applied_flag = 'Y' then
689: --
690: hr_utility.set_message(8302,'PQH_NO_UPD_TEM_TASK_TYPE');
691: hr_utility.raise_error;
692: --
693: End if;
694: --

Line 691: hr_utility.raise_error;

687: --
688: If l_applied_flag = 'Y' then
689: --
690: hr_utility.set_message(8302,'PQH_NO_UPD_TEM_TASK_TYPE');
691: hr_utility.raise_error;
692: --
693: End if;
694: --
695: End if;

Line 704: hr_utility.set_message(8302,'PQH_NO_TASK_FOR_DOMAIN_TEM');

700: -- Raise error if create flag has a value for a domain template
701: --
702: If p_template_type_cd = 'DOMAIN' then
703: --
704: hr_utility.set_message(8302,'PQH_NO_TASK_FOR_DOMAIN_TEM');
705: hr_utility.raise_error;
706: --
707: End if;
708: --

Line 705: hr_utility.raise_error;

701: --
702: If p_template_type_cd = 'DOMAIN' then
703: --
704: hr_utility.set_message(8302,'PQH_NO_TASK_FOR_DOMAIN_TEM');
705: hr_utility.raise_error;
706: --
707: End if;
708: --
709: Else

Line 715: hr_utility.set_message(8302,'PQH_INVALID_TEMPLATE_TASK');

711: -- Raise error if create flag has no value for a task template
712: --
713: if p_template_type_cd = 'TASK' then
714: --
715: hr_utility.set_message(8302,'PQH_INVALID_TEMPLATE_TASK');
716: hr_utility.raise_error;
717: --
718: End if;
719: --

Line 716: hr_utility.raise_error;

712: --
713: if p_template_type_cd = 'TASK' then
714: --
715: hr_utility.set_message(8302,'PQH_INVALID_TEMPLATE_TASK');
716: hr_utility.raise_error;
717: --
718: End if;
719: --
720: End if; /*If p_create_flag is not null*/

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

719: --
720: End if; /*If p_create_flag is not null*/
721: --
722: --
723: hr_utility.set_location('Leaving:'||l_proc,10);
724: --
725: end chk_create_flag;
726: --
727: -- ----------------------------------------------------------------------------

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

759: l_api_updating boolean;
760: --
761: Begin
762: --
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: l_api_updating := pqh_tem_shd.api_updating
766: (p_template_id => p_template_id,
767: p_object_version_number => p_object_version_number);

Line 784: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

780: p_effective_date => p_effective_date) then
781: --
782: -- raise error as does not exist as lookup
783: --
784: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
785: hr_utility.raise_error;
786: --
787: end if;
788: --

Line 785: hr_utility.raise_error;

781: --
782: -- raise error as does not exist as lookup
783: --
784: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
785: hr_utility.raise_error;
786: --
787: end if;
788: --
789: If p_enable_flag = 'N' then

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

793: End if;
794: --
795: End if;
796: --
797: hr_utility.set_location('Leaving:'||l_proc,10);
798: --
799: end chk_enable_flag;
800: --
801: --

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

811: l_object_version_number pqh_role_templates.object_version_number%type;
812: --
813: Begin
814: --
815: hr_utility.set_location('Entering:'||l_proc, 5);
816: --
817: For rec in csr_role_templates loop
818: --
819: l_object_version_number := rec.object_version_number;

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

826: ,p_effective_date => sysdate );
827: --
828: End loop;
829: --
830: hr_utility.set_location('Leaving:'||l_proc,10);
831: --
832: End disable_role_templates;
833: --
834: --

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

873: where a.parent_template_id = p_template_id
874: and a.reference_type_cd = 'REFERENCE';
875: Begin
876: --
877: hr_utility.set_location('Entering:'||l_proc, 5);
878: --
879: l_api_updating := pqh_tem_shd.api_updating
880: (p_template_id => p_template_id,
881: p_object_version_number => p_object_version_number);

Line 898: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

894: p_effective_date => p_effective_date) then
895: --
896: -- raise error as does not exist as lookup
897: --
898: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
899: hr_utility.raise_error;
900: --
901: end if;
902: --

Line 899: hr_utility.raise_error;

895: --
896: -- raise error as does not exist as lookup
897: --
898: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
899: hr_utility.raise_error;
900: --
901: end if;
902: --
903: end if;

Line 919: hr_utility.set_message(8302,'PQH_REF_TEMPLATES_EXIST');

915: open c1;
916: fetch c1 into l_dummy;
917: if c1%found then
918: Close c1;
919: hr_utility.set_message(8302,'PQH_REF_TEMPLATES_EXIST');
920: hr_utility.raise_error;
921: End if;
922: close c1;
923: -- Raise error if reference records exist in pqh_ref_templates

Line 920: hr_utility.raise_error;

916: fetch c1 into l_dummy;
917: if c1%found then
918: Close c1;
919: hr_utility.set_message(8302,'PQH_REF_TEMPLATES_EXIST');
920: hr_utility.raise_error;
921: End if;
922: close c1;
923: -- Raise error if reference records exist in pqh_ref_templates
924: --

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

926: End if;
927: --
928: End if;
929: --
930: hr_utility.set_location('Leaving:'||l_proc,10);
931: --
932: end chk_attribute_only_flag;
933: --
934: -- ----------------------------------------------------------------------------

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

966: l_api_updating boolean;
967: --
968: Begin
969: --
970: hr_utility.set_location('Entering:'||l_proc, 5);
971: --
972: l_api_updating := pqh_tem_shd.api_updating
973: (p_template_id => p_template_id,
974: p_object_version_number => p_object_version_number);

Line 991: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

987: p_effective_date => p_effective_date) then
988: --
989: -- raise error as does not exist as lookup
990: --
991: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
992: hr_utility.raise_error;
993: --
994: end if;
995: --

Line 992: hr_utility.raise_error;

988: --
989: -- raise error as does not exist as lookup
990: --
991: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
992: hr_utility.raise_error;
993: --
994: end if;
995: --
996: end if;

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

994: end if;
995: --
996: end if;
997: --
998: hr_utility.set_location('Leaving:'||l_proc,10);
999: --
1000: end chk_freeze_status_cd;
1001: --
1002: -- ADDITIONAL CHKS

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

1037: l_applied_flag varchar2(10);
1038: --
1039: Begin
1040: --
1041: hr_utility.set_location('Entering:'||l_proc, 5);
1042: --
1043: l_api_updating := pqh_tem_shd.api_updating
1044: (p_template_id => p_template_id,
1045: p_object_version_number => p_object_version_number);

Line 1062: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1058: p_effective_date => p_effective_date) then
1059: --
1060: -- raise error as does not exist as lookup
1061: --
1062: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1063: hr_utility.raise_error;
1064: --
1065: end if;
1066: --

Line 1063: hr_utility.raise_error;

1059: --
1060: -- raise error as does not exist as lookup
1061: --
1062: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1063: hr_utility.raise_error;
1064: --
1065: end if;
1066: --
1067: end if;

Line 1081: hr_utility.set_message(8302,'PQH_NO_UPD_TEMPLATE_TYPE');

1077: l_applied_flag := chk_if_template_applied(p_template_id => p_template_id);
1078: --
1079: If l_applied_flag = 'Y' then
1080: --
1081: hr_utility.set_message(8302,'PQH_NO_UPD_TEMPLATE_TYPE');
1082: hr_utility.raise_error;
1083: --
1084: End if;
1085: --

Line 1082: hr_utility.raise_error;

1078: --
1079: If l_applied_flag = 'Y' then
1080: --
1081: hr_utility.set_message(8302,'PQH_NO_UPD_TEMPLATE_TYPE');
1082: hr_utility.raise_error;
1083: --
1084: End if;
1085: --
1086: End if;

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

1085: --
1086: End if;
1087: --
1088: --
1089: hr_utility.set_location('Leaving:'||l_proc,10);
1090: --
1091: end chk_template_type_cd;
1092: --
1093: --

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

1170: l_proc varchar2(72) := g_package||'chk_master_child_attributes';
1171: --
1172: Begin
1173: --
1174: hr_utility.set_location('Entering:'||l_proc, 5);
1175: --
1176: Open c1;
1177: loop
1178: --

Line 1205: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');

1201: if match > 0 and no_match > 0 then
1202: --
1203: If master_attached = 'N' then
1204: --
1205: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');
1206: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);
1207: hr_utility.raise_error;
1208: --
1209: Else

Line 1206: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);

1202: --
1203: If master_attached = 'N' then
1204: --
1205: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');
1206: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);
1207: hr_utility.raise_error;
1208: --
1209: Else
1210: --

Line 1207: hr_utility.raise_error;

1203: If master_attached = 'N' then
1204: --
1205: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');
1206: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);
1207: hr_utility.raise_error;
1208: --
1209: Else
1210: --
1211: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');

Line 1211: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');

1207: hr_utility.raise_error;
1208: --
1209: Else
1210: --
1211: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1212: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1213: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1214: hr_utility.raise_error;
1215: --

Line 1212: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));

1208: --
1209: Else
1210: --
1211: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1212: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1213: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1214: hr_utility.raise_error;
1215: --
1216: End if; /* If master_attached = 'N'*/

Line 1213: hr_utility.set_message_token('MASTER',l_master_attribute_name);

1209: Else
1210: --
1211: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1212: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1213: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1214: hr_utility.raise_error;
1215: --
1216: End if; /* If master_attached = 'N'*/
1217: --

Line 1214: hr_utility.raise_error;

1210: --
1211: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1212: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1213: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1214: hr_utility.raise_error;
1215: --
1216: End if; /* If master_attached = 'N'*/
1217: --
1218: End if; /* if match > 0 and no_match > 0 */

Line 1222: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');

1218: End if; /* if match > 0 and no_match > 0 */
1219: --
1220: If view_flag_mismatch = 'Y' then
1221: --
1222: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');
1223: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1224: hr_utility.raise_error;
1225: --
1226: end if;

Line 1223: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));

1219: --
1220: If view_flag_mismatch = 'Y' then
1221: --
1222: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');
1223: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1224: hr_utility.raise_error;
1225: --
1226: end if;
1227: --

Line 1224: hr_utility.raise_error;

1220: If view_flag_mismatch = 'Y' then
1221: --
1222: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');
1223: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1224: hr_utility.raise_error;
1225: --
1226: end if;
1227: --
1228: If edit_flag_mismatch = 'Y' then

Line 1230: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');

1226: end if;
1227: --
1228: If edit_flag_mismatch = 'Y' then
1229: --
1230: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');
1231: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1232: hr_utility.raise_error;
1233: --
1234: end if; /* edit_flag_mismatch = 'Y' */

Line 1231: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));

1227: --
1228: If edit_flag_mismatch = 'Y' then
1229: --
1230: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');
1231: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1232: hr_utility.raise_error;
1233: --
1234: end if; /* edit_flag_mismatch = 'Y' */
1235: --

Line 1232: hr_utility.raise_error;

1228: If edit_flag_mismatch = 'Y' then
1229: --
1230: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');
1231: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1232: hr_utility.raise_error;
1233: --
1234: end if; /* edit_flag_mismatch = 'Y' */
1235: --
1236: End if; /* check_reqd_flag = 'Y'*/

Line 1254: hr_utility.set_location('Master is '||to_char(master_id),101);

1250: -- The current record has the master for the next set of attributes
1251: -- and all validations should be made against the master values
1252: --
1253: master_id := attr_rec.master_attribute_id;
1254: hr_utility.set_location('Master is '||to_char(master_id),101);
1255: master_view_flag := attr_rec.view_flag;
1256: master_edit_flag := attr_rec.edit_flag;
1257: --
1258: Else

Line 1269: hr_utility.set_location('Child is '||to_char(attr_rec.attribute_id),102);

1265: --
1266: End if;
1267: --
1268: --
1269: hr_utility.set_location('Child is '||to_char(attr_rec.attribute_id),102);
1270: if master_view_flag <> attr_rec.view_flag then
1271: --
1272: view_flag_mismatch := 'Y';
1273: --

Line 1292: hr_utility.set_location('Added Child is '||to_char(attr_rec.tat_attribute_id),103);

1288: -- Check if the attribute has been added to the template
1289: --
1290: if attr_rec.attribute_id = attr_rec.tat_attribute_id then
1291: --
1292: hr_utility.set_location('Added Child is '||to_char(attr_rec.tat_attribute_id),103);
1293: -- attribute has been added to the template
1294: match := match + 1;
1295: --
1296: else

Line 1300: hr_utility.set_location('Not Added Master is '||to_char(attr_rec.master_attribute_id),104);

1296: else
1297: --
1298: If attr_rec.attribute_id = attr_rec.master_attribute_id then
1299: --
1300: hr_utility.set_location('Not Added Master is '||to_char(attr_rec.master_attribute_id),104);
1301: -- master attribute has NOT been added to the template
1302: --
1303: master_attached := 'N';
1304: no_match := no_match + 1;

Line 1316: hr_utility.set_location('Not Added Child is '||attr_rec.attribute_name,105);

1312: <= 500 then
1313: --
1314: child_attr_list:=child_attr_list||attr_rec.attribute_name||',';
1315: --
1316: hr_utility.set_location('Not Added Child is '||attr_rec.attribute_name,105);
1317: End if;
1318: --
1319: no_match := no_match + 1;
1320: --

Line 1351: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');

1347: if match > 0 and no_match > 0 then
1348: --
1349: If master_attached = 'N' then
1350: --
1351: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');
1352: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);
1353: hr_utility.raise_error;
1354: --
1355: Else

Line 1352: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);

1348: --
1349: If master_attached = 'N' then
1350: --
1351: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');
1352: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);
1353: hr_utility.raise_error;
1354: --
1355: Else
1356: --

Line 1353: hr_utility.raise_error;

1349: If master_attached = 'N' then
1350: --
1351: hr_utility.set_message(8302,'PQH_ATTACH_MASTER_ATTRIBUTE');
1352: hr_utility.set_message_token('ATTRIBUTE_NAME',l_master_attribute_name);
1353: hr_utility.raise_error;
1354: --
1355: Else
1356: --
1357: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');

Line 1357: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');

1353: hr_utility.raise_error;
1354: --
1355: Else
1356: --
1357: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1358: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1359: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1360: hr_utility.raise_error;
1361: --

Line 1358: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));

1354: --
1355: Else
1356: --
1357: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1358: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1359: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1360: hr_utility.raise_error;
1361: --
1362: End if; /* If master_attached = 'N */

Line 1359: hr_utility.set_message_token('MASTER',l_master_attribute_name);

1355: Else
1356: --
1357: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1358: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1359: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1360: hr_utility.raise_error;
1361: --
1362: End if; /* If master_attached = 'N */
1363: --

Line 1360: hr_utility.raise_error;

1356: --
1357: hr_utility.set_message(8302,'PQH_MISMATCH_MASTER_CHILD_ATTR');
1358: hr_utility.set_message_token('CHILD',substr(child_attr_list,1,lengthb(child_attr_list)-1));
1359: hr_utility.set_message_token('MASTER',l_master_attribute_name);
1360: hr_utility.raise_error;
1361: --
1362: End if; /* If master_attached = 'N */
1363: --
1364: End if; /* if match > 0 and no_match > 0 */

Line 1368: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');

1364: End if; /* if match > 0 and no_match > 0 */
1365: --
1366: If view_flag_mismatch = 'Y' then
1367: --
1368: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');
1369: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1370: hr_utility.raise_error;
1371: --
1372: End if;

Line 1369: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));

1365: --
1366: If view_flag_mismatch = 'Y' then
1367: --
1368: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');
1369: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1370: hr_utility.raise_error;
1371: --
1372: End if;
1373: --

Line 1370: hr_utility.raise_error;

1366: If view_flag_mismatch = 'Y' then
1367: --
1368: hr_utility.set_message(8302,'PQH_ATTR_VIEW_FLAG_MISMATCH');
1369: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1370: hr_utility.raise_error;
1371: --
1372: End if;
1373: --
1374: If edit_flag_mismatch = 'Y' then

Line 1376: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');

1372: End if;
1373: --
1374: If edit_flag_mismatch = 'Y' then
1375: --
1376: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');
1377: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1378: hr_utility.raise_error;
1379: --
1380: End if;

Line 1377: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));

1373: --
1374: If edit_flag_mismatch = 'Y' then
1375: --
1376: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');
1377: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1378: hr_utility.raise_error;
1379: --
1380: End if;
1381: --

Line 1378: hr_utility.raise_error;

1374: If edit_flag_mismatch = 'Y' then
1375: --
1376: hr_utility.set_message(8302,'PQH_ATTR_EDIT_FLAG_MISMATCH');
1377: hr_utility.set_message_token('CHILD',substr(view_edit_list,1,lengthb(view_edit_list)-1));
1378: hr_utility.raise_error;
1379: --
1380: End if;
1381: --
1382: End if;

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

1381: --
1382: End if;
1383: --
1384: --
1385: hr_utility.set_location('Leaving:'||l_proc, 10);
1386: --
1387: End;
1388: --
1389: --

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

1427: l_proc varchar2(72) := g_package||'chk_rout_hist_exist';
1428: --
1429: Begin
1430: --
1431: hr_utility.set_location('Entering:'||l_proc, 5);
1432: --
1433: Open c1(p_template_id => p_template_id);
1434: --
1435: Fetch c1 into l_dummy;

Line 1440: hr_utility.set_message(8302,'PQH_TEMPLATE_ROUT_HIST_EXISTS');

1436: --
1437: If c1%found then
1438: --
1439: Close c1;
1440: hr_utility.set_message(8302,'PQH_TEMPLATE_ROUT_HIST_EXISTS');
1441: hr_utility.raise_error;
1442: --
1443: End if;
1444: --

Line 1441: hr_utility.raise_error;

1437: If c1%found then
1438: --
1439: Close c1;
1440: hr_utility.set_message(8302,'PQH_TEMPLATE_ROUT_HIST_EXISTS');
1441: hr_utility.raise_error;
1442: --
1443: End if;
1444: --
1445: Close c1;

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

1443: End if;
1444: --
1445: Close c1;
1446: --
1447: hr_utility.set_location('Leaving:'||l_proc,10);
1448: --
1449: End chk_rout_hist_exist;
1450: --
1451: --

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

1481: l_proc varchar2(72) := g_package||'chk_attr_or_reference_exists';
1482: --
1483: Begin
1484: --
1485: hr_utility.set_location('Entering:'||l_proc, 5);
1486: --
1487: Open csr_attr_exist;
1488: Fetch csr_attr_exist into l_dummy;
1489: --

Line 1505: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_REF');

1501: --
1502: Close csr_attr_exist;
1503: Close csr_ref_exist;
1504: --
1505: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_REF');
1506: hr_utility.raise_error;
1507: --
1508: End if;
1509: Close csr_ref_exist;

Line 1506: hr_utility.raise_error;

1502: Close csr_attr_exist;
1503: Close csr_ref_exist;
1504: --
1505: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_REF');
1506: hr_utility.raise_error;
1507: --
1508: End if;
1509: Close csr_ref_exist;
1510: --

Line 1515: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_COPY');

1511: Else
1512: --
1513: -- If copy mode and no attributes exist for template raise error.
1514: --
1515: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_COPY');
1516: hr_utility.raise_error;
1517: --
1518: /**
1519: Open csr_copy_exist;

Line 1516: hr_utility.raise_error;

1512: --
1513: -- If copy mode and no attributes exist for template raise error.
1514: --
1515: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_COPY');
1516: hr_utility.raise_error;
1517: --
1518: /**
1519: Open csr_copy_exist;
1520: Fetch csr_copy_exist into l_dummy;

Line 1526: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_COPY');

1522: --
1523: Close csr_attr_exist;
1524: Close csr_copy_exist;
1525: --
1526: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_COPY');
1527: hr_utility.raise_error;
1528: --
1529: End if;
1530: Close csr_copy_exist;

Line 1527: hr_utility.raise_error;

1523: Close csr_attr_exist;
1524: Close csr_copy_exist;
1525: --
1526: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_OR_COPY');
1527: hr_utility.raise_error;
1528: --
1529: End if;
1530: Close csr_copy_exist;
1531: --

Line 1551: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_WITH_REQ');

1547: --
1548: Close csr_attr_exist;
1549: Close csr_attr_with_req;
1550: --
1551: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_WITH_REQ');
1552: hr_utility.raise_error;
1553: --
1554: End if;
1555: Close csr_attr_with_req;

Line 1552: hr_utility.raise_error;

1548: Close csr_attr_exist;
1549: Close csr_attr_with_req;
1550: --
1551: hr_utility.set_message(8302,'PQH_NO_TEMP_ATTR_WITH_REQ');
1552: hr_utility.raise_error;
1553: --
1554: End if;
1555: Close csr_attr_with_req;
1556: --

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

1560: --
1561: --
1562: Close csr_attr_exist;
1563: --
1564: hr_utility.set_location('Leaving:'||l_proc,10);
1565: --
1566: end chk_attr_or_reference_exists;
1567: --
1568: -- ----------------------------------------------------------------------------

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

1603: l_api_updating boolean;
1604: --
1605: Begin
1606: --
1607: hr_utility.set_location('Entering:'||l_proc, 5);
1608: --
1609: l_api_updating := pqh_tem_shd.api_updating
1610: (p_template_id => p_template_id,
1611: p_object_version_number => p_object_version_number);

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

1642: --
1643: --
1644: End if;
1645: --
1646: hr_utility.set_location('Leaving:'||l_proc,10);
1647: --
1648: end chk_invalid_freeze;
1649: --
1650: --

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

1658: --
1659: l_proc varchar2(72) := g_package||'insert_validate';
1660: --
1661: Begin
1662: hr_utility.set_location('Entering:'||l_proc, 5);
1663: --
1664: -- Call all supporting business operations
1665: --
1666: chk_template_id

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

1724: --
1725: --
1726: --
1727: --
1728: hr_utility.set_location(' Leaving:'||l_proc, 10);
1729: End insert_validate;
1730: --
1731: -- ----------------------------------------------------------------------------
1732: -- |---------------------------< update_validate >----------------------------|

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

1736: --
1737: l_proc varchar2(72) := g_package||'update_validate';
1738: --
1739: Begin
1740: hr_utility.set_location('Entering:'||l_proc, 5);
1741: --
1742: -- Call all supporting business operations
1743: --
1744: chk_template_id

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

1817: p_template_name => p_rec.template_name,
1818: p_object_version_number => p_rec.object_version_number);
1819: --
1820: --
1821: hr_utility.set_location(' Leaving:'||l_proc, 10);
1822: End update_validate;
1823: --
1824: -- ----------------------------------------------------------------------------
1825: -- |---------------------------< delete_validate >----------------------------|

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

1829: --
1830: l_proc varchar2(72) := g_package||'delete_validate';
1831: --
1832: Begin
1833: hr_utility.set_location('Entering:'||l_proc, 5);
1834: --
1835: -- Call all supporting business operations
1836: --
1837: --

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

1834: --
1835: -- Call all supporting business operations
1836: --
1837: --
1838: hr_utility.set_location(' Leaving:'||l_proc, 10);
1839: End delete_validate;
1840: --
1841: end pqh_tem_bus;