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

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

46: l_api_updating boolean;
47: --
48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := per_dpf_shd.api_updating
53: (p_deployment_factor_id => p_deployment_factor_id,
54: p_object_version_number => p_object_version_number);

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

74: end if;
75: --
76: end if;
77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: End chk_deployment_factor_id;
81: --
82: -- ----------------------------------------------------------------------------

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

124: and nvl(per.effective_end_date,hr_api.g_eot);
125: --
126: Begin
127: --
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: l_api_updating := per_dpf_shd.api_updating
131: (p_deployment_factor_id => p_deployment_factor_id,
132: p_object_version_number => p_object_version_number);

Line 140: hr_utility.set_message(801,'HR_52022_DPF_CHK_PERSON_UPD');

136: <> per_dpf_shd.g_old_rec.person_id) then
137: --
138: -- raise error as person_id has changed
139: --
140: hr_utility.set_message(801,'HR_52022_DPF_CHK_PERSON_UPD');
141: hr_utility.raise_error;
142: --
143: elsif not l_api_updating then
144: --

Line 141: hr_utility.raise_error;

137: --
138: -- raise error as person_id has changed
139: --
140: hr_utility.set_message(801,'HR_52022_DPF_CHK_PERSON_UPD');
141: hr_utility.raise_error;
142: --
143: elsif not l_api_updating then
144: --
145: -- check if person_id exists

Line 155: hr_utility.set_message(800,'HR_52250_DPF_CHK_PERSON_ID');

151: fetch c1 into l_dummy;
152: if c1%notfound then
153: --
154: close c1;
155: hr_utility.set_message(800,'HR_52250_DPF_CHK_PERSON_ID');
156: hr_utility.raise_error;
157: --
158: end if;
159: --

Line 156: hr_utility.raise_error;

152: if c1%notfound then
153: --
154: close c1;
155: hr_utility.set_message(800,'HR_52250_DPF_CHK_PERSON_ID');
156: hr_utility.raise_error;
157: --
158: end if;
159: --
160: close c1;

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

162: end if;
163: --
164: end if;
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: --
168: End chk_person_id;
169: --
170: -- ----------------------------------------------------------------------------

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

217: and nvl(per.date_end,hr_api.g_eot);
218: --
219: Begin
220: --
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: l_api_updating := per_dpf_shd.api_updating
224: (p_deployment_factor_id => p_deployment_factor_id,
225: p_object_version_number => p_object_version_number);

Line 233: hr_utility.set_message(801,'HR_52023_DPF_CHK_POSITION_UPD');

229: <> per_dpf_shd.g_old_rec.position_id) then
230: --
231: -- raise error as position_id has changed
232: --
233: hr_utility.set_message(801,'HR_52023_DPF_CHK_POSITION_UPD');
234: hr_utility.raise_error;
235: --
236: elsif not l_api_updating then
237: --

Line 234: hr_utility.raise_error;

230: --
231: -- raise error as position_id has changed
232: --
233: hr_utility.set_message(801,'HR_52023_DPF_CHK_POSITION_UPD');
234: hr_utility.raise_error;
235: --
236: elsif not l_api_updating then
237: --
238: -- check if position_id exists

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

254: end if;
255: --
256: end if;
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: --
260: end chk_position_id;
261: --
262: -- ----------------------------------------------------------------------------

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

303: and nvl(per.date_to,hr_api.g_eot);
304: --
305: Begin
306: --
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: l_api_updating := per_dpf_shd.api_updating
310: (p_deployment_factor_id => p_deployment_factor_id,
311: p_object_version_number => p_object_version_number);

Line 319: hr_utility.set_message(801,'HR_52025_DPF_CHK_JOB_UPD');

315: <> per_dpf_shd.g_old_rec.job_id) then
316: --
317: -- raise error as job_id has changed
318: --
319: hr_utility.set_message(801,'HR_52025_DPF_CHK_JOB_UPD');
320: hr_utility.raise_error;
321: --
322: elsif not l_api_updating then
323: --

Line 320: hr_utility.raise_error;

316: --
317: -- raise error as job_id has changed
318: --
319: hr_utility.set_message(801,'HR_52025_DPF_CHK_JOB_UPD');
320: hr_utility.raise_error;
321: --
322: elsif not l_api_updating then
323: --
324: -- check if position_id exists

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

340: end if;
341: --
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: --
346: end chk_job_id;
347: -- ----------------------------------------------------------------------------
348: -- |----------------------------< chk_mandatory_lookup >----------------------|

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

389: l_api_updating boolean;
390: --
391: Begin
392: --
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: l_api_updating := per_dpf_shd.api_updating
396: (p_deployment_factor_id => p_deployment_factor_id,
397: p_object_version_number => p_object_version_number);

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

469: end if;
470: --
471: end if;
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: --
475: end chk_mandatory_lookup;
476: --
477: -- ----------------------------------------------------------------------------

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

524: where per.territory_code = p_code;
525: --
526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: l_api_updating := per_dpf_shd.api_updating
531: (p_deployment_factor_id => p_deployment_factor_id,
532: p_object_version_number => p_object_version_number);

Line 565: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');

561: fetch c1 into l_dummy;
562: if c1%notfound then
563: --
564: close c1;
565: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
566: hr_utility.raise_error;
567: --
568: end if;
569: --

Line 566: hr_utility.raise_error;

562: if c1%notfound then
563: --
564: close c1;
565: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
566: hr_utility.raise_error;
567: --
568: end if;
569: --
570: close c1;

Line 590: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');

586: fetch c1 into l_dummy;
587: if c1%notfound then
588: --
589: close c1;
590: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
591: hr_utility.raise_error;
592: --
593: end if;
594: --

Line 591: hr_utility.raise_error;

587: if c1%notfound then
588: --
589: close c1;
590: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
591: hr_utility.raise_error;
592: --
593: end if;
594: --
595: close c1;

Line 615: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');

611: fetch c1 into l_dummy;
612: if c1%notfound then
613: --
614: close c1;
615: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
616: hr_utility.raise_error;
617: --
618: end if;
619: --

Line 616: hr_utility.raise_error;

612: if c1%notfound then
613: --
614: close c1;
615: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
616: hr_utility.raise_error;
617: --
618: end if;
619: --
620: close c1;

Line 640: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');

636: fetch c1 into l_dummy;
637: if c1%notfound then
638: --
639: close c1;
640: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
641: hr_utility.raise_error;
642: --
643: end if;
644: --

Line 641: hr_utility.raise_error;

637: if c1%notfound then
638: --
639: close c1;
640: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
641: hr_utility.raise_error;
642: --
643: end if;
644: --
645: close c1;

Line 665: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');

661: fetch c1 into l_dummy;
662: if c1%notfound then
663: --
664: close c1;
665: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
666: hr_utility.raise_error;
667: --
668: end if;
669: --

Line 666: hr_utility.raise_error;

662: if c1%notfound then
663: --
664: close c1;
665: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
666: hr_utility.raise_error;
667: --
668: end if;
669: --
670: close c1;

Line 690: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');

686: fetch c1 into l_dummy;
687: if c1%notfound then
688: --
689: close c1;
690: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
691: hr_utility.raise_error;
692: --
693: end if;
694: --

Line 691: hr_utility.raise_error;

687: if c1%notfound then
688: --
689: close c1;
690: hr_utility.set_message(801,'HR_52027_DPF_CHK_COUNTRY');
691: hr_utility.raise_error;
692: --
693: end if;
694: --
695: close c1;

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

699: end if;
700: --
701: end if;
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);
704: --
705: end chk_country;
706: -- ----------------------------------------------------------------------------
707: -- |----------------------------< chk_optional_lookup >-----------------------|

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

745: l_api_updating boolean;
746: --
747: Begin
748: --
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: l_api_updating := per_dpf_shd.api_updating
752: (p_deployment_factor_id => p_deployment_factor_id,
753: p_object_version_number => p_object_version_number);

Line 783: hr_utility.set_message(801,'HR_52028_DPF_CHK_WORK_DURATION');

779: (p_lookup_type => 'PER_TIME_SCALES',
780: p_lookup_code => p_work_duration,
781: p_effective_date => p_effective_date) then
782: --
783: hr_utility.set_message(801,'HR_52028_DPF_CHK_WORK_DURATION');
784: hr_utility.raise_error;
785: --
786: end if;
787: --

Line 784: hr_utility.raise_error;

780: p_lookup_code => p_work_duration,
781: p_effective_date => p_effective_date) then
782: --
783: hr_utility.set_message(801,'HR_52028_DPF_CHK_WORK_DURATION');
784: hr_utility.raise_error;
785: --
786: end if;
787: --
788: end if;

Line 807: hr_utility.set_message(801,'HR_52029_DPF_CHK_WORK_SCHEDULE');

803: (p_lookup_type => 'PER_WORK_SCHEDULE',
804: p_lookup_code => p_work_schedule,
805: p_effective_date => p_effective_date) then
806: --
807: hr_utility.set_message(801,'HR_52029_DPF_CHK_WORK_SCHEDULE');
808: hr_utility.raise_error;
809: --
810: end if;
811: --

Line 808: hr_utility.raise_error;

804: p_lookup_code => p_work_schedule,
805: p_effective_date => p_effective_date) then
806: --
807: hr_utility.set_message(801,'HR_52029_DPF_CHK_WORK_SCHEDULE');
808: hr_utility.raise_error;
809: --
810: end if;
811: --
812: end if;

Line 831: hr_utility.set_message(801,'HR_52030_DPF_CHK_WORK_HOURS');

827: (p_lookup_type => 'PER_WORK_HOURS',
828: p_lookup_code => p_work_hours,
829: p_effective_date => p_effective_date) then
830: --
831: hr_utility.set_message(801,'HR_52030_DPF_CHK_WORK_HOURS');
832: hr_utility.raise_error;
833: --
834: end if;
835: --

Line 832: hr_utility.raise_error;

828: p_lookup_code => p_work_hours,
829: p_effective_date => p_effective_date) then
830: --
831: hr_utility.set_message(801,'HR_52030_DPF_CHK_WORK_HOURS');
832: hr_utility.raise_error;
833: --
834: end if;
835: --
836: end if;

Line 855: hr_utility.set_message(801,'HR_52031_DPF_CHK_FTE_CAPACITY');

851: (p_lookup_type => 'PER_FTE_CAPACITY',
852: p_lookup_code => p_fte_capacity,
853: p_effective_date => p_effective_date) then
854: --
855: hr_utility.set_message(801,'HR_52031_DPF_CHK_FTE_CAPACITY');
856: hr_utility.raise_error;
857: --
858: end if;
859: --

Line 856: hr_utility.raise_error;

852: p_lookup_code => p_fte_capacity,
853: p_effective_date => p_effective_date) then
854: --
855: hr_utility.set_message(801,'HR_52031_DPF_CHK_FTE_CAPACITY');
856: hr_utility.raise_error;
857: --
858: end if;
859: --
860: end if;

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

862: end if;
863: --
864: end if;
865: --
866: hr_utility.set_location(' Leaving:'||l_proc, 10);
867: --
868: end chk_optional_lookup;
869: -- ----------------------------------------------------------------------------
870: -- |---------------------< chk_person_optional_lookup >-----------------------|

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

909: l_api_updating boolean;
910: --
911: Begin
912: --
913: hr_utility.set_location('Entering:'||l_proc, 5);
914: --
915: l_api_updating := per_dpf_shd.api_updating
916: (p_deployment_factor_id => p_deployment_factor_id,
917: p_object_version_number => p_object_version_number);

Line 1016: hr_utility.set_message(801,'HR_52032_DPF_CHK_RELOC_PREF');

1012: (p_lookup_type => 'PER_RELOCATION_PREFERENCES',
1013: p_lookup_code => p_relocation_preference,
1014: p_effective_date => p_effective_date) then
1015: --
1016: hr_utility.set_message(801,'HR_52032_DPF_CHK_RELOC_PREF');
1017: hr_utility.raise_error;
1018: --
1019: end if;
1020: --

Line 1017: hr_utility.raise_error;

1013: p_lookup_code => p_relocation_preference,
1014: p_effective_date => p_effective_date) then
1015: --
1016: hr_utility.set_message(801,'HR_52032_DPF_CHK_RELOC_PREF');
1017: hr_utility.raise_error;
1018: --
1019: end if;
1020: --
1021: end if;

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

1023: end if;
1024: --
1025: end if;
1026: --
1027: hr_utility.set_location(' Leaving:'||l_proc, 10);
1028: --
1029: end chk_person_optional_lookup;
1030: --
1031: -- ----------------------------------------------------------------------------

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

1069: l_api_updating boolean;
1070: --
1071: Begin
1072: --
1073: hr_utility.set_location('Entering:'||l_proc, 5);
1074: --
1075: l_api_updating := per_dpf_shd.api_updating
1076: (p_deployment_factor_id => p_deployment_factor_id,
1077: p_object_version_number => p_object_version_number);

Line 1151: hr_utility.set_message(801,'HR_52033_DPF_LENGTH_SERVICE');

1147: (p_lookup_type => 'PER_LENGTHS_OF_SERVICE',
1148: p_lookup_code => p_service_minimum,
1149: p_effective_date => p_effective_date) then
1150: --
1151: hr_utility.set_message(801,'HR_52033_DPF_LENGTH_SERVICE');
1152: hr_utility.raise_error;
1153: --
1154: end if;
1155: --

Line 1152: hr_utility.raise_error;

1148: p_lookup_code => p_service_minimum,
1149: p_effective_date => p_effective_date) then
1150: --
1151: hr_utility.set_message(801,'HR_52033_DPF_LENGTH_SERVICE');
1152: hr_utility.raise_error;
1153: --
1154: end if;
1155: --
1156: end if;

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

1158: end if;
1159: --
1160: end if;
1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 10);
1163: --
1164: end chk_job_pos_optional_lookup;
1165: -- ----------------------------------------------------------------------------
1166: -- |------------------------------< chk_location >----------------------------|

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

1207: where hr.location_id = p_location_id and hr.location_use = 'HR';
1208: --
1209: Begin
1210: --
1211: hr_utility.set_location('Entering:'||l_proc, 5);
1212: --
1213: l_api_updating := per_dpf_shd.api_updating
1214: (p_deployment_factor_id => p_deployment_factor_id,
1215: p_object_version_number => p_object_version_number);

Line 1240: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');

1236: fetch c1 into l_dummy;
1237: if c1%notfound then
1238: --
1239: close c1;
1240: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');
1241: hr_utility.raise_error;
1242: --
1243: end if;
1244: --

Line 1241: hr_utility.raise_error;

1237: if c1%notfound then
1238: --
1239: close c1;
1240: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');
1241: hr_utility.raise_error;
1242: --
1243: end if;
1244: --
1245: close c1;

Line 1263: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');

1259: fetch c1 into l_dummy;
1260: if c1%notfound then
1261: --
1262: close c1;
1263: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');
1264: hr_utility.raise_error;
1265: --
1266: end if;
1267: --

Line 1264: hr_utility.raise_error;

1260: if c1%notfound then
1261: --
1262: close c1;
1263: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');
1264: hr_utility.raise_error;
1265: --
1266: end if;
1267: --
1268: close c1;

Line 1286: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');

1282: fetch c1 into l_dummy;
1283: if c1%notfound then
1284: --
1285: close c1;
1286: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');
1287: hr_utility.raise_error;
1288: --
1289: end if;
1290: --

Line 1287: hr_utility.raise_error;

1283: if c1%notfound then
1284: --
1285: close c1;
1286: hr_utility.set_message(801,'HR_52034_DPF_LOCATION_EXIST');
1287: hr_utility.raise_error;
1288: --
1289: end if;
1290: --
1291: close c1;

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

1337: l_api_updating boolean;
1338: --
1339: Begin
1340: --
1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: --
1343: l_api_updating := per_dpf_shd.api_updating
1344: (p_deployment_factor_id => p_deployment_factor_id,
1345: p_object_version_number => p_object_version_number);

Line 1377: hr_utility.set_message(801,'HR_52035_DPF_CHK_ID_POPULATED');

1373: --
1374: -- Raise error as either no Id is populated or more than one Id is
1375: -- populated.
1376: --
1377: hr_utility.set_message(801,'HR_52035_DPF_CHK_ID_POPULATED');
1378: hr_utility.raise_error;
1379: --
1380: end if;
1381: --

Line 1378: hr_utility.raise_error;

1374: -- Raise error as either no Id is populated or more than one Id is
1375: -- populated.
1376: --
1377: hr_utility.set_message(801,'HR_52035_DPF_CHK_ID_POPULATED');
1378: hr_utility.raise_error;
1379: --
1380: end if;
1381: --
1382: end if;

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

1431: l_api_updating boolean;
1432: --
1433: Begin
1434: --
1435: hr_utility.set_location('Entering:'||l_proc, 5);
1436: --
1437: l_api_updating := per_dpf_shd.api_updating
1438: (p_deployment_factor_id => p_deployment_factor_id,
1439: p_object_version_number => p_object_version_number);

Line 1472: hr_utility.set_message(801,'HR_52036_DPF_PERSON_ATTRIBUTES');

1468: p_location3 is not null or
1469: p_other_requirements is not null or
1470: p_service_minimum is not null) then
1471: --
1472: hr_utility.set_message(801,'HR_52036_DPF_PERSON_ATTRIBUTES');
1473: hr_utility.raise_error;
1474: --
1475: end if;
1476: --

Line 1473: hr_utility.raise_error;

1469: p_other_requirements is not null or
1470: p_service_minimum is not null) then
1471: --
1472: hr_utility.set_message(801,'HR_52036_DPF_PERSON_ATTRIBUTES');
1473: hr_utility.raise_error;
1474: --
1475: end if;
1476: --
1477: end if;

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

1534: l_api_updating boolean;
1535: --
1536: Begin
1537: --
1538: hr_utility.set_location('Entering:'||l_proc, 5);
1539: --
1540: l_api_updating := per_dpf_shd.api_updating
1541: (p_deployment_factor_id => p_deployment_factor_id,
1542: p_object_version_number => p_object_version_number);

Line 1583: hr_utility.set_message(801,'HR_52037_DPF_JOBPOS_ATTRIBUTES');

1579: p_earliest_available_date is not null or
1580: p_available_for_transfer is not null or
1581: p_relocation_preference is not null) then
1582: --
1583: hr_utility.set_message(801,'HR_52037_DPF_JOBPOS_ATTRIBUTES');
1584: hr_utility.raise_error;
1585: --
1586: end if;
1587: --

Line 1584: hr_utility.raise_error;

1580: p_available_for_transfer is not null or
1581: p_relocation_preference is not null) then
1582: --
1583: hr_utility.set_message(801,'HR_52037_DPF_JOBPOS_ATTRIBUTES');
1584: hr_utility.raise_error;
1585: --
1586: end if;
1587: --
1588: end if;

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

1638: and nvl(per.person_id,-1) = nvl(p_person_id,-1);
1639: --
1640: Begin
1641: --
1642: hr_utility.set_location('Entering:'||l_proc, 5);
1643: --
1644: l_api_updating := per_dpf_shd.api_updating
1645: (p_deployment_factor_id => p_deployment_factor_id,
1646: p_object_version_number => p_object_version_number);

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

1736: and per.person_id = p_person_id;
1737: --
1738: Begin
1739: --
1740: hr_utility.set_location('Entering:'||l_proc, 5);
1741: --
1742: l_api_updating := per_dpf_shd.api_updating
1743: (p_deployment_factor_id => p_deployment_factor_id,
1744: p_object_version_number => p_object_version_number);

Line 1766: hr_utility.set_message(801,'HR_52042_DPF_PERSON_BG');

1762: fetch c_person into l_dummy;
1763: if c_person%notfound then
1764: --
1765: close c_person;
1766: hr_utility.set_message(801,'HR_52042_DPF_PERSON_BG');
1767: hr_utility.raise_error;
1768: --
1769: end if;
1770: --

Line 1767: hr_utility.raise_error;

1763: if c_person%notfound then
1764: --
1765: close c_person;
1766: hr_utility.set_message(801,'HR_52042_DPF_PERSON_BG');
1767: hr_utility.raise_error;
1768: --
1769: end if;
1770: --
1771: close c_person;

Line 1783: hr_utility.set_message(801,'HR_52039_DPF_JOB_BG');

1779: fetch c_jobs into l_dummy;
1780: if c_jobs%notfound then
1781: --
1782: close c_jobs;
1783: hr_utility.set_message(801,'HR_52039_DPF_JOB_BG');
1784: hr_utility.raise_error;
1785: --
1786: end if;
1787: --

Line 1784: hr_utility.raise_error;

1780: if c_jobs%notfound then
1781: --
1782: close c_jobs;
1783: hr_utility.set_message(801,'HR_52039_DPF_JOB_BG');
1784: hr_utility.raise_error;
1785: --
1786: end if;
1787: --
1788: close c_jobs;

Line 1800: hr_utility.set_message(801,'HR_52040_DPF_POSITION_BG');

1796: fetch c_positions into l_dummy;
1797: if c_positions%notfound then
1798: --
1799: close c_positions;
1800: hr_utility.set_message(801,'HR_52040_DPF_POSITION_BG');
1801: hr_utility.raise_error;
1802: --
1803: end if;
1804: --

Line 1801: hr_utility.raise_error;

1797: if c_positions%notfound then
1798: --
1799: close c_positions;
1800: hr_utility.set_message(801,'HR_52040_DPF_POSITION_BG');
1801: hr_utility.raise_error;
1802: --
1803: end if;
1804: --
1805: close c_positions;

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

1841: --
1842: l_proc varchar2(72) := g_package||'chk_df';
1843: --
1844: begin
1845: hr_utility.set_location('Entering:'||l_proc, 10);
1846: --
1847: if ((p_rec.deployment_factor_id is not null) and (
1848: nvl(per_dpf_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1849: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1941: ,p_attribute20_value => p_rec.attribute20
1942: );
1943: end if;
1944: --
1945: hr_utility.set_location(' Leaving:'||l_proc, 20);
1946: end chk_df;
1947: -- ----------------------------------------------------------------------------
1948: -- |---------------------------< insert_validate >----------------------------|
1949: -- ----------------------------------------------------------------------------

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

1952: --
1953: l_proc varchar2(72) := g_package||'insert_validate';
1954: --
1955: Begin
1956: hr_utility.set_location('Entering:'||l_proc, 5);
1957: --
1958: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1959: --
1960: -- Call all supporting business operations

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

2134: --
2135: per_dpf_bus.chk_df(p_rec => p_rec);
2136: --
2137: --
2138: hr_utility.set_location(' Leaving:'||l_proc, 10);
2139: End insert_validate;
2140: --
2141: -- ----------------------------------------------------------------------------
2142: -- |---------------------------< update_validate >----------------------------|

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

2146: --
2147: l_proc varchar2(72) := g_package||'update_validate';
2148: --
2149: Begin
2150: hr_utility.set_location('Entering:'||l_proc, 5);
2151: --
2152: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2153: --
2154: -- Call all supporting business operations

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

2326: -- ======================
2327: --
2328: per_dpf_bus.chk_df(p_rec => p_rec);
2329: --
2330: hr_utility.set_location(' Leaving:'||l_proc, 10);
2331: End update_validate;
2332: --
2333: -- ----------------------------------------------------------------------------
2334: -- |---------------------------< delete_validate >----------------------------|

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

2337: --
2338: l_proc varchar2(72) := g_package||'delete_validate';
2339: --
2340: Begin
2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: --
2343: -- Call all supporting business operations
2344: --
2345: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: --
2343: -- Call all supporting business operations
2344: --
2345: hr_utility.set_location(' Leaving:'||l_proc, 10);
2346: End delete_validate;
2347: --
2348: -- ---------------------------------------------------------------------------
2349: -- |---------------------< return_legislation_code >-------------------------|

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

2366: --
2367: l_legislation_code varchar2(150);
2368: l_proc varchar2(72) := g_package||'return_legislation_code';
2369: begin
2370: hr_utility.set_location('Entering:'|| l_proc, 10);
2371: --
2372: -- Ensure that all the mandatory parameter are not null
2373: --
2374: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2381: -- call to this function. Just return the value in the global
2382: -- variable.
2383: --
2384: l_legislation_code := g_legislation_code;
2385: hr_utility.set_location(l_proc, 20);
2386: else
2387: --
2388: -- The ID is different to the last call to this function
2389: -- or this is the first call to this function.

Line 2402: hr_utility.set_location(' Leaving:'|| l_proc, 30);

2398: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2399: fnd_message.raise_error;
2400: end if;
2401: --
2402: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2403: --
2404: -- Set the global variables so the vlaues are
2405: -- available for the next call to this function
2406: --

Line 2411: hr_utility.set_location('Entering:'|| l_proc, 40);

2407: close csr_leg_code;
2408: g_deployment_factor_id := p_deployment_factor_id;
2409: g_legislation_code := l_legislation_code;
2410: end if;
2411: hr_utility.set_location('Entering:'|| l_proc, 40);
2412: --
2413: return l_legislation_code;
2414: end return_legislation_code;
2415: end per_dpf_bus;