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

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := per_pps_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: per_pps_bus.g_parent_spine_id := p_parent_spine_id;
154: per_pps_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

194: l_proc varchar2(72) := g_package||'chk_parent_spine_id';
195: l_api_updating boolean;
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: l_api_updating := per_pps_shd.api_updating
201: (p_parent_spine_id => p_parent_spine_id
202: ,p_object_version_number => p_object_version_number

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

223: end if;
224: --
225: end if;
226: --
227: hr_utility.set_location('Leaving:'||l_proc, 10);
228: --
229: End chk_parent_spine_id;
230: --
231: --

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

282: -- End of 3312706
283: --
284: Begin
285: --
286: hr_utility.set_location('Entering:'||l_proc, 10);
287: --
288: -- Check mandatory parameters have been set
289: --
290: hr_api.mandatory_arg_error

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

302: ,p_object_version_number => p_object_version_number);
303: --
304: if ((l_api_updating and upper(per_pps_shd.g_old_rec.name) <> upper(p_name))
305: or (NOT l_api_updating)) then
306: hr_utility.set_location(l_proc, 20);
307: --
308: open csr_unique_name;
309: fetch csr_unique_name into l_exists;
310: if csr_unique_name%found then

Line 312: hr_utility.set_message(801, 'PER_7920_PAR_SPN_EXISTS');

308: open csr_unique_name;
309: fetch csr_unique_name into l_exists;
310: if csr_unique_name%found then
311: close csr_unique_name;
312: hr_utility.set_message(801, 'PER_7920_PAR_SPN_EXISTS');
313: hr_utility.raise_error;
314: end if;
315: close csr_unique_name;
316: --

Line 313: hr_utility.raise_error;

309: fetch csr_unique_name into l_exists;
310: if csr_unique_name%found then
311: close csr_unique_name;
312: hr_utility.set_message(801, 'PER_7920_PAR_SPN_EXISTS');
313: hr_utility.raise_error;
314: end if;
315: close csr_unique_name;
316: --
317: end if;

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

315: close csr_unique_name;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 30);
320: exception
321: when app_exception.application_exception then
322: if hr_multi_message.exception_add
323: (p_associated_column1 => 'PER_PARENT_SPINES.NAME'

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

321: when app_exception.application_exception then
322: if hr_multi_message.exception_add
323: (p_associated_column1 => 'PER_PARENT_SPINES.NAME'
324: ) then
325: hr_utility.set_location(' Leaving:'||l_proc,40);
326: raise;
327: end if;
328: --
329: End chk_name;

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

370: --
371: --
372: Begin
373: --
374: hr_utility.set_location('Entering:'||l_proc, 10);
375: --
376: l_api_updating := per_pps_shd.api_updating
377: ( p_parent_spine_id => p_parent_spine_id
378: ,p_object_version_number => p_object_version_number

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

383: <> per_pps_shd.g_old_rec.increment_frequency) then
384: --
385: -- Check mandatory parameters have been set
386: --
387: hr_utility.set_location(l_proc,20);
388: if (p_increment_period is not null and p_increment_frequency is null) then
389: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');
390: hr_utility.raise_error;
391: end if;

Line 389: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');

385: -- Check mandatory parameters have been set
386: --
387: hr_utility.set_location(l_proc,20);
388: if (p_increment_period is not null and p_increment_frequency is null) then
389: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');
390: hr_utility.raise_error;
391: end if;
392: elsif not l_api_updating then
393: --

Line 390: hr_utility.raise_error;

386: --
387: hr_utility.set_location(l_proc,20);
388: if (p_increment_period is not null and p_increment_frequency is null) then
389: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');
390: hr_utility.raise_error;
391: end if;
392: elsif not l_api_updating then
393: --
394: if p_increment_frequency is null then

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

391: end if;
392: elsif not l_api_updating then
393: --
394: if p_increment_frequency is null then
395: hr_utility.set_location(l_proc,30);
396: -- p_increment_frequency := 1;
397: end if;
398: --
399: end if;

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

397: end if;
398: --
399: end if;
400: --
401: hr_utility.set_location('Leaving:'||l_proc, 40);
402: --
403: end chk_increment_frequency;
404: --
405: --

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

441: l_proc varchar2(72) := g_package||'chk_increment_period';
442: --
443: Begin
444: --
445: hr_utility.set_location('Entering:'||l_proc, 10);
446: --
447: -- Check mandatory parameters have been set
448: --
449: if (p_increment_frequency is not null and p_increment_period is null) then

Line 450: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');

446: --
447: -- Check mandatory parameters have been set
448: --
449: if (p_increment_frequency is not null and p_increment_period is null) then
450: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');
451: hr_utility.raise_error;
452: end if;
453: --
454: hr_utility.set_location(l_proc, 20);

Line 451: hr_utility.raise_error;

447: -- Check mandatory parameters have been set
448: --
449: if (p_increment_frequency is not null and p_increment_period is null) then
450: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');
451: hr_utility.raise_error;
452: end if;
453: --
454: hr_utility.set_location(l_proc, 20);
455: --

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

450: hr_utility.set_message(801,'HR_6919_SPINE_ENTER_INC');
451: hr_utility.raise_error;
452: end if;
453: --
454: hr_utility.set_location(l_proc, 20);
455: --
456: if p_increment_period is not null then
457: --
458: -- Check that the frequency exists in hr_lookups for the lookup

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

457: --
458: -- Check that the frequency exists in hr_lookups for the lookup
459: -- type 'FREQUENCY' with an enabled flag set to 'Y'
460: --
461: hr_utility.set_location(l_proc, 30);
462: if hr_api.not_exists_in_hr_lookups
463: (p_effective_date => p_effective_date
464: ,p_lookup_type => 'FREQUENCY'
465: ,p_lookup_code => p_increment_period

Line 469: hr_utility.set_message(801, 'HR_289564_INVALID_INCR_PERIOD');

465: ,p_lookup_code => p_increment_period
466: )
467: then
468: --
469: hr_utility.set_message(801, 'HR_289564_INVALID_INCR_PERIOD');
470: hr_utility.raise_error;
471: --
472: end if;
473: end if;

Line 470: hr_utility.raise_error;

466: )
467: then
468: --
469: hr_utility.set_message(801, 'HR_289564_INVALID_INCR_PERIOD');
470: hr_utility.raise_error;
471: --
472: end if;
473: end if;
474: hr_utility.set_location('Leaving:'||l_proc, 40);

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

470: hr_utility.raise_error;
471: --
472: end if;
473: end if;
474: hr_utility.set_location('Leaving:'||l_proc, 40);
475: --
476: end chk_increment_period;
477: --
478: -- ----------------------------------------------------------------------------

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

508: l_proc varchar2(72) := g_package||'chk_last_aut_inc_date';
509: --
510: Begin
511: --
512: hr_utility.set_location('Entering:'||l_proc, 10);
513: --
514: -- Check the parameters is not inserted
515: --
516: if (p_last_automatic_increment_dat is not null) then

Line 517: hr_utility.set_message(800,'HR_289565_ERR_LST_AUT_INC_DATE');

513: --
514: -- Check the parameters is not inserted
515: --
516: if (p_last_automatic_increment_dat is not null) then
517: hr_utility.set_message(800,'HR_289565_ERR_LST_AUT_INC_DATE');
518: hr_utility.raise_error;
519: end if;
520: --
521: hr_utility.set_location('Leaving:'||l_proc, 20);

Line 518: hr_utility.raise_error;

514: -- Check the parameters is not inserted
515: --
516: if (p_last_automatic_increment_dat is not null) then
517: hr_utility.set_message(800,'HR_289565_ERR_LST_AUT_INC_DATE');
518: hr_utility.raise_error;
519: end if;
520: --
521: hr_utility.set_location('Leaving:'||l_proc, 20);
522: --

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

517: hr_utility.set_message(800,'HR_289565_ERR_LST_AUT_INC_DATE');
518: hr_utility.raise_error;
519: end if;
520: --
521: hr_utility.set_location('Leaving:'||l_proc, 20);
522: --
523: end chk_last_aut_inc_date;
524: --
525: --

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

574: --
575: --
576: Begin
577: --
578: hr_utility.set_location('Entering:'||l_proc, 10);
579: --
580: -- Check there are no values in per_spinal_points, per_grade_spines_f
581: -- and pay_rates
582: --

Line 591: hr_utility.set_message(801, 'PER_7921_DEL_PAR_SPN_POINT');

587: If csr_spinal_points%found Then
588: --
589: close csr_spinal_points;
590: --
591: hr_utility.set_message(801, 'PER_7921_DEL_PAR_SPN_POINT');
592: fnd_message.raise_error;
593: --
594: End If;
595: --

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

594: End If;
595: --
596: close csr_spinal_points;
597: --
598: hr_utility.set_location(l_proc, 20);
599:
600: --
601: -- Check there are no values in per_grade_spines_f
602: --

Line 611: hr_utility.set_message(801, 'PER_7922_DEL_PAR_SPN_GRDSPN');

607: If csr_grade_spines%found Then
608: --
609: close csr_grade_spines;
610: --
611: hr_utility.set_message(801, 'PER_7922_DEL_PAR_SPN_GRDSPN');
612: fnd_message.raise_error;
613: --
614: End If;
615: --

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

614: End If;
615: --
616: close csr_grade_spines;
617: --
618: hr_utility.set_location(l_proc, 30);
619:
620: --
621: -- Check there are no values in pay_rates
622: --

Line 631: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');

627: If csr_pay_rates%found Then
628: --
629: close csr_pay_rates;
630: --
631: hr_utility.set_message(801, 'PER_7923_DEL_PAR_SPN_RATE');
632: fnd_message.raise_error;
633: --
634: End If;
635: --

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

633: --
634: End If;
635: --
636: close csr_pay_rates;
637: hr_utility.set_location('Leaving:' || l_proc, 40);
638: --
639: end chk_delete;
640: --
641: -- ----------------------------------------------------------------------------

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

672: --
673: l_proc varchar2(72) := g_package || 'chk_df';
674: --
675: begin
676: hr_utility.set_location('Entering:'||l_proc,10);
677: --
678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

771: ,p_attribute20_value => p_rec.attribute20
772: );
773: end if;
774: --
775: hr_utility.set_location(' Leaving:'||l_proc,20);
776: end chk_df;
777: --
778: --
779: -- ----------------------------------------------------------------------------

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

810: --
811: l_proc varchar2(72) := g_package || 'chk_ddf';
812: --
813: begin
814: hr_utility.set_location('Entering:'||l_proc,10);
815: --
816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

882: -- a) During update, the structure column value or any
883: -- of the attribute values have actually changed.
884: -- b) During insert.
885: --
886: hr_utility.set_location('Entering:'||l_proc,20);
887:
888: hr_dflex_utility.ins_or_upd_descflex_attribs
889: (p_appl_short_name => 'PER'
890: ,p_descflex_name => 'Further Parent Spine DF'

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

951: ,p_attribute30_value => p_rec.information30
952: );
953: end if;
954: --
955: hr_utility.set_location(' Leaving:'||l_proc,30);
956: end chk_ddf;
957: --
958: -- ----------------------------------------------------------------------------
959: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1026: --
1027: l_proc varchar2(72) := g_package||'insert_validate';
1028: --
1029: Begin
1030: hr_utility.set_location('Entering:'||l_proc, 10);
1031:
1032: --
1033: -- Call all supporting business operations
1034: --

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

1045: ,p_object_version_number => p_rec.object_version_number
1046: );
1047:
1048:
1049: hr_utility.set_location(l_proc, 20);
1050:
1051: --
1052: -- Validate name
1053: --

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

1057: ,p_business_group_id => p_rec.business_group_id
1058: ,p_object_version_number => p_rec.object_version_number
1059: );
1060:
1061: hr_utility.set_location(l_proc, 30);
1062:
1063: --
1064: -- Validate increment frequency
1065: --

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

1069: ,p_increment_period => p_rec.increment_period
1070: ,p_object_version_number => p_rec.object_version_number
1071: );
1072:
1073: hr_utility.set_location(l_proc, 40);
1074:
1075: --
1076: -- Validate increment period
1077: --

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

1080: ,p_increment_frequency => p_rec.increment_frequency
1081: ,p_effective_date => p_effective_date
1082: );
1083:
1084: hr_utility.set_location(l_proc, 50);
1085:
1086: --
1087: -- Validate last automatic increment date
1088: --

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

1089: chk_last_aut_inc_date
1090: (p_last_automatic_increment_dat => p_rec.last_automatic_increment_date
1091: );
1092:
1093: hr_utility.set_location(l_proc, 60);
1094:
1095: -- After validating the set of important attributes,
1096: -- if Multiple Message detection is enabled and at least
1097: -- one error has been found then abort further validation.

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

1097: -- one error has been found then abort further validation.
1098: --
1099: hr_multi_message.end_validation_set;
1100:
1101: hr_utility.set_location(l_proc, 70);
1102:
1103: --
1104: -- Flexfield Validation
1105: --

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

1104: -- Flexfield Validation
1105: --
1106: per_pps_bus.chk_df(p_rec);
1107:
1108: hr_utility.set_location(l_proc, 80);
1109:
1110: --
1111: -- Developer Descriptive Flexfield Validation
1112: --

Line 1115: hr_utility.set_location(' Leaving:'||l_proc, 100);

1111: -- Developer Descriptive Flexfield Validation
1112: --
1113: per_pps_bus.chk_ddf(p_rec);
1114:
1115: hr_utility.set_location(' Leaving:'||l_proc, 100);
1116:
1117: End insert_validate;
1118: --
1119: -- ----------------------------------------------------------------------------

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

1126: --
1127: l_proc varchar2(72) := g_package||'update_validate';
1128: --
1129: Begin
1130: hr_utility.set_location('Entering:'||l_proc, 10);
1131: --
1132: -- Call all supporting business operations
1133: --
1134: hr_api.validate_bus_grp_id

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

1143: (p_parent_spine_id => p_rec.parent_spine_id
1144: ,p_object_version_number => p_rec.object_version_number
1145: );
1146:
1147: hr_utility.set_location(l_proc, 20);
1148:
1149: --
1150: -- After validating the set of important attributes,
1151: -- if Multiple Message detection is enabled and at least

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

1160: (p_effective_date => p_effective_date
1161: ,p_rec => p_rec
1162: );
1163:
1164: hr_utility.set_location(l_proc, 30);
1165:
1166: --
1167: -- Validate name
1168: --

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

1172: ,p_business_group_id => p_rec.business_group_id
1173: ,p_object_version_number => p_rec.object_version_number
1174: );
1175:
1176: hr_utility.set_location(l_proc, 40);
1177:
1178: --
1179: -- Validate increment frequency
1180: --

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

1184: ,p_increment_period => p_rec.increment_period
1185: ,p_object_version_number => p_rec.object_version_number
1186: );
1187:
1188: hr_utility.set_location(l_proc, 50);
1189:
1190: --
1191: -- Validate increment period
1192: --

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

1195: ,p_increment_frequency => p_rec.increment_frequency
1196: ,p_effective_date => p_effective_date
1197: );
1198:
1199: hr_utility.set_location(l_proc, 60);
1200:
1201: --
1202: -- Flexfield Validation
1203: --

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

1202: -- Flexfield Validation
1203: --
1204: per_pps_bus.chk_df(p_rec);
1205:
1206: hr_utility.set_location(l_proc, 70);
1207: --
1208: -- Developer Descriptive Flexfield Validation
1209: --
1210: per_pps_bus.chk_ddf(p_rec);

Line 1213: hr_utility.set_location(' Leaving:'||l_proc, 100);

1209: --
1210: per_pps_bus.chk_ddf(p_rec);
1211:
1212: --
1213: hr_utility.set_location(' Leaving:'||l_proc, 100);
1214:
1215: End update_validate;
1216: --
1217: -- ----------------------------------------------------------------------------

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

1223: --
1224: l_proc varchar2(72) := g_package||'delete_validate';
1225: --
1226: Begin
1227: hr_utility.set_location('Entering:'||l_proc, 10);
1228:
1229: --
1230: -- Call all supporting business operations
1231: --

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

1230: -- Call all supporting business operations
1231: --
1232: chk_delete(p_parent_spine_id => p_rec.parent_spine_id);
1233: --
1234: hr_utility.set_location(' Leaving:'||l_proc, 20);
1235: End delete_validate;
1236: --
1237: end per_pps_bus;