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

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := per_grd_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: per_grd_bus.g_grade_id := p_grade_id;
147: per_grd_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ---------------------------------------------------------------------------

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

213: l_message varchar2(2000) := null;
214: --
215: Begin
216: --
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: -- Check there are no values in per_all_assignments_f, per_valid_grades
220: -- per_vacancies, pay_element_links, per_budget_elements, per_grade_spines
221: -- per_salary_survey_mappings, hr_all_positions_f, pay_grade_rules

Line 382: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_plan_for_grade return => ' || l_delete_plan);

378: l_delete_plan := pqh_gsp_sync_compensation_obj.delete_plan_for_grade
379: (p_grade_id => p_grade_id
380: );
381: --
382: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_plan_for_grade return => ' || l_delete_plan);
383: --
384: if l_delete_plan <> 'SUCCESS' Then
385: l_message := fnd_message.get;
386: fnd_message.set_name('PER','HR_289563_DEL_PLAN_FOR_GRADE');

Line 388: hr_utility.trace('error message : ' || l_message);

384: if l_delete_plan <> 'SUCCESS' Then
385: l_message := fnd_message.get;
386: fnd_message.set_name('PER','HR_289563_DEL_PLAN_FOR_GRADE');
387: if l_message is not null then
388: hr_utility.trace('error message : ' || l_message);
389: fnd_message.set_token('ERR_CODE',l_message);
390: else
391: fnd_message.set_token('ERR_CODE','-1');
392: end if;

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

395: --
396: End if;
397:
398: --
399: hr_utility.set_location('Leaving:'||l_proc, 20);
400: --
401: --
402: end chk_delete;
403: --

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

439: l_api_updating boolean;
440: --
441: Begin
442: --
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: l_api_updating := per_grd_shd.api_updating
446: (p_grade_id => p_grade_id,
447: p_object_version_number => p_object_version_number

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

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

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

531:
532: --
533: Begin
534: --
535: hr_utility.set_location('Entering:'||l_proc, 10);
536: --
537: -- Check GSP implementation exists
538: --
539: -- If Grade Ladder implementation exists and short_name

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

543: (p_grade_id => p_grade_id,
544: p_object_version_number => p_object_version_number
545: );
546: --
547: hr_utility.set_location(l_proc, 20);
548: --
549: if (l_api_updating and
550: ((p_short_name is not null and per_grd_shd.g_old_rec.short_name is null)
551: or (per_grd_shd.g_old_rec.short_name <> p_short_name))) then

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

549: if (l_api_updating and
550: ((p_short_name is not null and per_grd_shd.g_old_rec.short_name is null)
551: or (per_grd_shd.g_old_rec.short_name <> p_short_name))) then
552:
553: hr_utility.set_location(l_proc, 30);
554: --
555: open csr_update_short_name;
556: fetch csr_update_short_name into l_exists;
557: if csr_update_short_name%found then

Line 559: hr_utility.set_message(800,'HR_289555_NON_UNIQ_SHORT_NAME');

555: open csr_update_short_name;
556: fetch csr_update_short_name into l_exists;
557: if csr_update_short_name%found then
558: close csr_update_short_name;
559: hr_utility.set_message(800,'HR_289555_NON_UNIQ_SHORT_NAME');
560: hr_utility.raise_error;
561: end if;
562: close csr_update_short_name;
563: --

Line 560: hr_utility.raise_error;

556: fetch csr_update_short_name into l_exists;
557: if csr_update_short_name%found then
558: close csr_update_short_name;
559: hr_utility.set_message(800,'HR_289555_NON_UNIQ_SHORT_NAME');
560: hr_utility.raise_error;
561: end if;
562: close csr_update_short_name;
563: --
564: elsif (NOT l_api_updating) then

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

562: close csr_update_short_name;
563: --
564: elsif (NOT l_api_updating) then
565: --
566: hr_utility.set_location(l_proc, 40);
567: --
568: open csr_unique_short_name;
569: fetch csr_unique_short_name into l_exists;
570: if csr_unique_short_name%found then

Line 572: hr_utility.set_message(800,'HR_289555_NON_UNIQ_SHORT_NAME');

568: open csr_unique_short_name;
569: fetch csr_unique_short_name into l_exists;
570: if csr_unique_short_name%found then
571: close csr_unique_short_name;
572: hr_utility.set_message(800,'HR_289555_NON_UNIQ_SHORT_NAME');
573: hr_utility.raise_error;
574: end if;
575: close csr_unique_short_name;
576: --

Line 573: hr_utility.raise_error;

569: fetch csr_unique_short_name into l_exists;
570: if csr_unique_short_name%found then
571: close csr_unique_short_name;
572: hr_utility.set_message(800,'HR_289555_NON_UNIQ_SHORT_NAME');
573: hr_utility.raise_error;
574: end if;
575: close csr_unique_short_name;
576: --
577: end if;

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

575: close csr_unique_short_name;
576: --
577: end if;
578: --
579: hr_utility.set_location('Leaving:'||l_proc, 50);
580: --
581: End chk_short_name;
582: --
583: -- ---------------------------------------------------------------------------

Line 639: hr_utility.set_location('Entering:'||l_proc, 1);

635: where grade_definition_id = p_grade_definition_id
636: and business_group_id + 0 = p_business_group_id;
637: --
638: begin
639: hr_utility.set_location('Entering:'||l_proc, 1);
640: --
641: -- Check mandatory parameters have been set
642: --
643: hr_api.mandatory_arg_error

Line 649: hr_utility.set_location(l_proc, 2);

645: ,p_argument => 'grade_definition_id'
646: ,p_argument_value => p_grade_definition_id
647: );
648: --
649: hr_utility.set_location(l_proc, 2);
650: --
651: l_api_updating := per_grd_shd.api_updating
652: (p_grade_id => p_grade_id
653: ,p_object_version_number => p_object_version_number);

Line 655: hr_utility.set_location(l_proc, 3);

651: l_api_updating := per_grd_shd.api_updating
652: (p_grade_id => p_grade_id
653: ,p_object_version_number => p_object_version_number);
654: --
655: hr_utility.set_location(l_proc, 3);
656: --
657: if ((l_api_updating and
658: (per_grd_shd.g_old_rec.grade_definition_id <>
659: p_grade_definition_id)) or (NOT l_api_updating)) then

Line 661: hr_utility.set_location(l_proc, 4);

657: if ((l_api_updating and
658: (per_grd_shd.g_old_rec.grade_definition_id <>
659: p_grade_definition_id)) or (NOT l_api_updating)) then
660: --
661: hr_utility.set_location(l_proc, 4);
662: --
663: open csr_grade_def;
664: fetch csr_grade_def into l_exists;
665: if csr_grade_def%notfound then

Line 671: hr_utility.set_location(l_proc, 5);

667: per_grd_shd.constraint_error(p_constraint_name => 'PER_GRADES_FK2');
668: end if;
669: close csr_grade_def;
670: --
671: hr_utility.set_location(l_proc, 5);
672: --
673: open csr_unique_grade_def;
674: fetch csr_unique_grade_def into l_exists;
675: if csr_unique_grade_def%found then

Line 677: hr_utility.set_message(801,'PER_7830_DEF_GRADE_EXISTS');

673: open csr_unique_grade_def;
674: fetch csr_unique_grade_def into l_exists;
675: if csr_unique_grade_def%found then
676: close csr_unique_grade_def;
677: hr_utility.set_message(801,'PER_7830_DEF_GRADE_EXISTS');
678: hr_utility.raise_error;
679: end if;
680: close csr_unique_grade_def;
681: --

Line 678: hr_utility.raise_error;

674: fetch csr_unique_grade_def into l_exists;
675: if csr_unique_grade_def%found then
676: close csr_unique_grade_def;
677: hr_utility.set_message(801,'PER_7830_DEF_GRADE_EXISTS');
678: hr_utility.raise_error;
679: end if;
680: close csr_unique_grade_def;
681: --
682: end if;

Line 683: hr_utility.set_location('Leaving '||l_proc, 6);

679: end if;
680: close csr_unique_grade_def;
681: --
682: end if;
683: hr_utility.set_location('Leaving '||l_proc, 6);
684: --
685: end chk_grade_definition_id;
686: --
687: -- ---------------------------------------------------------------------------

Line 731: hr_utility.set_location('Entering:'||l_proc, 1);

727: l_proc varchar2(72) := g_package||'chk_dates';
728: l_api_updating boolean;
729: --
730: begin
731: hr_utility.set_location('Entering:'||l_proc, 1);
732: --
733: -- Check mandatory parameters have been set
734: --
735:

Line 741: hr_utility.set_location(l_proc, 2);

737: (p_api_name => l_proc
738: ,p_argument => 'date_from'
739: ,p_argument_value => p_date_from
740: );
741: hr_utility.set_location(l_proc, 2);
742: --
743: -- Only proceed with validation if :
744: -- a) The current g_old_rec is current and
745: -- b) The date_end value has changed

Line 759: hr_utility.set_location(l_proc, 3);

755: (NOT l_api_updating))) then
756: --
757: -- Check that date_from <= date_to
758: --
759: hr_utility.set_location(l_proc, 3);
760: --
761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

758: --
759: hr_utility.set_location(l_proc, 3);
760: --
761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('PROCEDURE', l_proc);
764: hr_utility.set_message_token('STEP', '3');
765: hr_utility.raise_error;
766: end if;

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

759: hr_utility.set_location(l_proc, 3);
760: --
761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('PROCEDURE', l_proc);
764: hr_utility.set_message_token('STEP', '3');
765: hr_utility.raise_error;
766: end if;
767: --

Line 764: hr_utility.set_message_token('STEP', '3');

760: --
761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('PROCEDURE', l_proc);
764: hr_utility.set_message_token('STEP', '3');
765: hr_utility.raise_error;
766: end if;
767: --
768: end if;

Line 765: hr_utility.raise_error;

761: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
762: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
763: hr_utility.set_message_token('PROCEDURE', l_proc);
764: hr_utility.set_message_token('STEP', '3');
765: hr_utility.raise_error;
766: end if;
767: --
768: end if;
769: --

Line 770: hr_utility.set_location(' Leaving:'||l_proc, 4);

766: end if;
767: --
768: end if;
769: --
770: hr_utility.set_location(' Leaving:'||l_proc, 4);
771: end chk_dates;
772: --
773: -- ---------------------------------------------------------------------------
774: -- |-------------------------< chk_sequence >-------------------------------|

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

816: l_proc varchar2(72) := g_package||'chk_sequence';
817: --
818: BEGIN
819: --
820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: hr_api.mandatory_arg_error
823: (p_api_name => l_proc,
824: p_argument => 'sequence',

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

823: (p_api_name => l_proc,
824: p_argument => 'sequence',
825: p_argument_value => p_sequence);
826: --
827: hr_utility.set_location(l_proc,10);
828: --
829: OPEN c_all_seq;
830: --
831: FETCH c_all_seq INTO l_exists;

Line 832: hr_utility.set_location(l_proc,15);

828: --
829: OPEN c_all_seq;
830: --
831: FETCH c_all_seq INTO l_exists;
832: hr_utility.set_location(l_proc,15);
833: IF c_all_seq%FOUND THEN
834: fnd_message.set_name('PAY','HR_7127_GRADE_DUP_SEQ');
835: CLOSE c_all_seq;
836: fnd_message.raise_error;

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

841: fnd_message.set_name('PAY','PER_7833_DEF_GRADE_SEQUENCE');
842: fnd_message.raise_error;
843: end if;
844: --
845: hr_utility.set_location('Leaving:'||l_proc, 20);
846: --
847: end chk_sequence;
848: --
849: -- ----------------------------------------------------------------------------

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

880: --
881: l_proc varchar2(72) := g_package || 'chk_ddf';
882: --
883: begin
884: hr_utility.set_location('Entering:'||l_proc,10);
885: --
886: if ((p_rec.grade_id is not null) and (
887: nvl(per_grd_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
888: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

979: ,p_attribute20_value => p_rec.information20
980: );
981: end if;
982: --
983: hr_utility.set_location(' Leaving:'||l_proc,20);
984: end chk_ddf;
985: --
986: -- ----------------------------------------------------------------------------
987: -- |------------------------------< chk_df >----------------------------------|

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

1017: --
1018: l_proc varchar2(72) := g_package || 'chk_df';
1019: --
1020: begin
1021: hr_utility.set_location('Entering:'||l_proc,10);
1022: --
1023: if ((p_rec.grade_id is not null) and (
1024: nvl(per_grd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1025: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1116: ,p_attribute20_value => p_rec.attribute20
1117: );
1118: end if;
1119: --
1120: hr_utility.set_location(' Leaving:'||l_proc,20);
1121: end chk_df;
1122: --
1123: -- ----------------------------------------------------------------------------
1124: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1184: --
1185: l_proc varchar2(72) := g_package||'insert_validate';
1186: --
1187: Begin
1188: hr_utility.set_location('Entering:'||l_proc, 5);
1189: --
1190: -- Call all supporting business operations
1191: --
1192: hr_api.validate_bus_grp_id

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

1199: ,p_object_version_number => p_rec.object_version_number
1200: ,p_effective_date => p_effective_date
1201: );
1202: --
1203: hr_utility.set_location(l_proc, 10);
1204: --
1205: -- After validating the set of important attributes,
1206: -- if Multiple Message detection is enabled and at least
1207: -- one error has been found then abort further validation.

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

1216: (p_date_from => p_rec.date_from,
1217: p_date_to => p_rec.date_to
1218: );
1219: --
1220: hr_utility.set_location(l_proc, 20);
1221: --
1222: -- Validate grade definition id
1223: --
1224: chk_grade_definition_id

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

1225: (p_grade_definition_id => p_rec.grade_definition_id
1226: ,p_business_group_id => p_rec.business_group_id
1227: );
1228: --
1229: hr_utility.set_location(l_proc, 30);
1230: --
1231: -- Validate sequence
1232: --
1233: chk_sequence

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

1233: chk_sequence
1234: (p_sequence => p_rec.sequence,
1235: p_business_group_id => p_rec.business_group_id
1236: );
1237: hr_utility.set_location(l_proc, 40);
1238: --
1239: -- Validate short_name
1240: --
1241: chk_short_name

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

1241: chk_short_name
1242: (p_short_name => p_rec.short_name
1243: ,p_business_group_id => p_rec.business_group_id
1244: );
1245: hr_utility.set_location(l_proc, 50);
1246: --
1247: -- Flexfield Validation
1248: --
1249: per_grd_bus.chk_ddf(p_rec);

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

1249: per_grd_bus.chk_ddf(p_rec);
1250: --
1251: per_grd_bus.chk_df(p_rec);
1252: --
1253: hr_utility.set_location(' Leaving:'||l_proc, 100);
1254: End insert_validate;
1255: --
1256: -- ----------------------------------------------------------------------------
1257: -- |---------------------------< update_validate >----------------------------|

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

1263: --
1264: l_proc varchar2(72) := g_package||'update_validate';
1265: --
1266: Begin
1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268: --
1269: -- Call all supporting business operations
1270: --
1271: -- hr_api.validate_bus_grp_id

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

1278: ,p_object_version_number => p_rec.object_version_number
1279: ,p_effective_date => p_effective_date
1280: );
1281: --
1282: hr_utility.set_location(l_proc, 10);
1283: --
1284: -- After validating the set of important attributes,
1285: -- if Multiple Message detection is enabled and at least
1286: -- one error has been found then abort further validation.

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

1292: chk_non_updateable_args
1293: (p_effective_date => p_effective_date
1294: ,p_rec => p_rec
1295: );
1296: hr_utility.set_location(l_proc, 20);
1297: --
1298: -- Validate sequence
1299: --
1300: chk_sequence

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

1300: chk_sequence
1301: (p_sequence => p_rec.sequence,
1302: p_business_group_id => p_rec.business_group_id
1303: );
1304: hr_utility.set_location(l_proc, 30);
1305: --
1306: -- Validate date effective
1307: --
1308: chk_dates

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

1311: p_date_to => p_rec.date_to,
1312: p_object_version_number => p_rec.object_version_number
1313: );
1314: --
1315: hr_utility.set_location(l_proc, 40);
1316: --
1317: -- Validate grade definition id
1318: --
1319: chk_grade_definition_id

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

1321: p_business_group_id => p_rec.business_group_id,
1322: p_grade_id => p_rec.grade_id,
1323: p_object_version_number => p_rec.object_version_number
1324: );
1325: hr_utility.set_location(l_proc, 50);
1326: --
1327: -- Validate short_name
1328: --
1329: chk_short_name

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

1331: ,p_business_group_id => p_rec.business_group_id
1332: ,p_grade_id => p_rec.grade_id
1333: ,p_object_version_number => p_rec.object_version_number
1334: );
1335: hr_utility.set_location(l_proc, 60);
1336: --
1337: -- Flexfield Validation
1338: --
1339: per_grd_bus.chk_ddf(p_rec);

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

1337: -- Flexfield Validation
1338: --
1339: per_grd_bus.chk_ddf(p_rec);
1340: --
1341: hr_utility.set_location(l_proc, 70);
1342: --
1343: per_grd_bus.chk_df(p_rec);
1344: --
1345: hr_utility.set_location(' Leaving:'||l_proc, 100);

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

1341: hr_utility.set_location(l_proc, 70);
1342: --
1343: per_grd_bus.chk_df(p_rec);
1344: --
1345: hr_utility.set_location(' Leaving:'||l_proc, 100);
1346: End update_validate;
1347: --
1348: -- ----------------------------------------------------------------------------
1349: -- |---------------------------< delete_validate >----------------------------|

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

1354: --
1355: l_proc varchar2(72) := g_package||'delete_validate';
1356: --
1357: Begin
1358: hr_utility.set_location('Entering:'||l_proc, 5);
1359: --
1360: -- Call all supporting business operations
1361: --
1362: -- CHK_DELETE

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

1364: (p_grade_id => p_rec.grade_id
1365: ,p_object_version_number => p_rec.object_version_number
1366: );
1367:
1368: hr_utility.set_location(' Leaving:'||l_proc, 10);
1369: End delete_validate;
1370: --
1371: end per_grd_bus;