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_PPB_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_ppb_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_ppb_bus.g_pay_basis_id := p_pay_basis_id;
147: per_ppb_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 191: hr_utility.set_location('Entering:'||l_proc, 5);

187: l_api_updating boolean;
188: --
189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: l_api_updating := per_ppb_shd.api_updating
194: (p_pay_basis_id => p_pay_basis_id,
195: p_object_version_number => p_object_version_number

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

216: end if;
217: --
218: end if;
219: --
220: hr_utility.set_location('Leaving:'||l_proc, 10);
221: --
222: --
223: End chk_pay_basis_id;
224: --

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

265: from pay_rates
266: where rate_id = p_rate_id;
267: --
268: begin
269: hr_utility.set_location('Entering:'||l_proc, 1);
270: --
271: --
272: hr_utility.set_location(l_proc, 3);
273: --

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

268: begin
269: hr_utility.set_location('Entering:'||l_proc, 1);
270: --
271: --
272: hr_utility.set_location(l_proc, 3);
273: --
274: open csr_salary_basis;
275: fetch csr_salary_basis into l_exists;
276: if p_rate_id is not null then

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

282: close csr_salary_basis;
283: end if;
284: --
285: --
286: hr_utility.set_location('Leaving '||l_proc, 4);
287: --
288: end chk_rate_id;
289: --
290: --

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

336: ;
337: --
338: BEGIN
339: --
340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: hr_api.mandatory_arg_error
343: (p_api_name => l_proc,
344: p_argument => 'name',

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

343: (p_api_name => l_proc,
344: p_argument => 'name',
345: p_argument_value => p_name);
346: --
347: hr_utility.set_location(l_proc,10);
348: OPEN csr_name;
349: --
350: FETCH csr_name INTO l_exists;
351: hr_utility.set_location(l_proc,15);

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

347: hr_utility.set_location(l_proc,10);
348: OPEN csr_name;
349: --
350: FETCH csr_name INTO l_exists;
351: hr_utility.set_location(l_proc,15);
352: IF csr_name%FOUND THEN
353: fnd_message.set_name('PAY' ,'HR_13017_SAL_BASIS_DUP_NAME');
354: CLOSE csr_name;
355: fnd_message.raise_error;

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

356: END IF;
357: CLOSE csr_name;
358: --
359: --
360: hr_utility.set_location('Leaving:'||l_proc, 20);
361: --
362: end chk_name;
363: --
364: -- ----------------------------------------------------------------------------

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

398: --
399: Begin
400: --
401: --
402: hr_utility.set_location('Entering:'||l_proc, 10);
403:
404: hr_api.mandatory_arg_error
405: (p_api_name => l_proc,
406: p_argument => 'pay_basis',

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

411: -- there is a pay basis being passed
412: --
413: IF (p_pay_basis is not null) then
414: --
415: hr_utility.set_location(l_proc, 20);
416: --
417: -- Check that the reason type exists in HR_LOOKUPS
418: --
419: IF hr_api.not_exists_in_hr_lookups

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

420: (p_effective_date => sysdate
421: ,p_lookup_type => 'PAY_BASIS'
422: ,p_lookup_code => p_pay_basis) THEN
423: --
424: hr_utility.set_location(l_proc, 30);
425: --
426: fnd_message.set_name('PER', 'HR_PSF_INVALID_PAY_BASIS');
427: hr_utility.raise_error;
428: --

Line 427: hr_utility.raise_error;

423: --
424: hr_utility.set_location(l_proc, 30);
425: --
426: fnd_message.set_name('PER', 'HR_PSF_INVALID_PAY_BASIS');
427: hr_utility.raise_error;
428: --
429: END IF;
430: --
431: END IF;

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

429: END IF;
430: --
431: END IF;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 40);
434:
435: End chk_pay_basis;
436: --
437: --

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

475: --
476:
477: --
478: begin
479: hr_utility.set_location('Entering:'||l_proc, 1);
480: --
481: hr_utility.set_location(l_proc, 2);
482: --
483: --4154786

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

477: --
478: begin
479: hr_utility.set_location('Entering:'||l_proc, 1);
480: --
481: hr_utility.set_location(l_proc, 2);
482: --
483: --4154786
484: --if p_pay_basis = 'PERIOD' then
485: if p_pay_annualization_factor is not null then

Line 513: hr_utility.set_location('Leaving '||l_proc, 3);

509: p_argument_value => p_pay_annualization_factor);
510: end if;
511: end if;
512: --
513: hr_utility.set_location('Leaving '||l_proc, 3);
514: --
515: end chk_pay_annualization_factor;
516: --
517: --

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

554: --
555:
556: --
557: begin
558: hr_utility.set_location('Entering:'||l_proc, 1);
559: --
560: hr_utility.set_location(l_proc, 2);
561:
562: if p_rate_basis is not null then

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

556: --
557: begin
558: hr_utility.set_location('Entering:'||l_proc, 1);
559: --
560: hr_utility.set_location(l_proc, 2);
561:
562: if p_rate_basis is not null then
563: --
564: if p_rate_basis = 'PERIOD' then

Line 595: hr_utility.set_location('Leaving '||l_proc, 3);

591: end if;
592: --
593: end if;
594: --
595: hr_utility.set_location('Leaving '||l_proc, 3);
596: --
597: end chk_grade_annualization_factor;
598: --
599: --

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

653: l_api_updating boolean;
654: --
655: Begin
656: --
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659:
660: hr_api.mandatory_arg_error
661: (p_api_name => l_proc,

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

661: (p_api_name => l_proc,
662: p_argument => 'input_value_id',
663: p_argument_value => p_input_value_id);
664:
665: hr_utility.set_location(l_proc, 10);
666: --
667: open csr_input_value;
668: fetch csr_input_value into l_exists;
669:

Line 680: hr_utility.set_location('Leaving '||l_proc, 15);

676:
677: close csr_input_value;
678: --
679: --
680: hr_utility.set_location('Leaving '||l_proc, 15);
681:
682: --
683:
684: End chk_input_value_id;

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

720: --
721: Begin
722: --
723: --
724: hr_utility.set_location('Entering:'||l_proc, 10);
725:
726: hr_api.mandatory_arg_error
727: (p_api_name => l_proc,
728: p_argument => 'pay_basis',

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

732: -- there is a pay basis being passed
733: --
734: IF (p_pay_basis is not null) then
735: --
736: hr_utility.set_location(l_proc, 20);
737: --
738: -- Check that the reason type exists in HR_LOOKUPS
739: --
740: IF hr_api.not_exists_in_hr_lookups

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

741: (p_effective_date => sysdate
742: ,p_lookup_type => 'PAY_BASIS'
743: ,p_lookup_code => p_pay_basis) THEN
744: --
745: hr_utility.set_location(l_proc, 30);
746: --
747: fnd_message.set_name('PER', 'HR_PSF_INVALID_PAY_BASIS');
748: hr_utility.raise_error;
749: --

Line 748: hr_utility.raise_error;

744: --
745: hr_utility.set_location(l_proc, 30);
746: --
747: fnd_message.set_name('PER', 'HR_PSF_INVALID_PAY_BASIS');
748: hr_utility.raise_error;
749: --
750: END IF;
751: --
752: ELSIF p_rate_basis is not null then

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

754: (p_effective_date => sysdate
755: ,p_lookup_type => 'PAY_BASIS'
756: ,p_lookup_code => p_rate_basis) then
757:
758: hr_utility.set_location(l_proc, 40);
759: fnd_message.set_name('PER', 'PER_289917_INVALID_RATE_BASIS');
760: hr_utility.raise_error;
761: end if;
762: END IF;

Line 760: hr_utility.raise_error;

756: ,p_lookup_code => p_rate_basis) then
757:
758: hr_utility.set_location(l_proc, 40);
759: fnd_message.set_name('PER', 'PER_289917_INVALID_RATE_BASIS');
760: hr_utility.raise_error;
761: end if;
762: END IF;
763: hr_utility.set_location(' Leaving:'||l_proc, 50);
764:

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

759: fnd_message.set_name('PER', 'PER_289917_INVALID_RATE_BASIS');
760: hr_utility.raise_error;
761: end if;
762: END IF;
763: hr_utility.set_location(' Leaving:'||l_proc, 50);
764:
765: End chk_rate_basis;
766: --
767: -- ---------------------------------------------------------------------------

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

794: l_api_updating boolean;
795: --
796: Begin
797: --
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: -- Check there are no values in per_all_assignments_f,hr_all_positions_f
801: -- pay_elements_links_f
802: --

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

847: End If;
848: --
849: Close csr_elements;
850: --
851: hr_utility.set_location('Leaving:'||l_proc, 20);
852: --
853: --
854: end chk_delete;
855: --

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

900: where paa.pay_basis_id = p_rec.pay_basis_id;
901: --
902: begin
903: --
904: hr_utility.set_location('Entering:'||l_proc, 10);
905:
906: l_api_updating := per_ppb_shd.api_updating
907: (p_rec.pay_basis_id
908: ,p_rec.object_version_number

Line 914: hr_utility.set_location('Entering:'||l_proc, 15);

910:
911: if l_api_updating then
912:
913: --
914: hr_utility.set_location('Entering:'||l_proc, 15);
915: --
916: OPEN csr_sal_pay_in_asg;
917: --
918: FETCH csr_sal_pay_in_asg INTO l_exists;

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

915: --
916: OPEN csr_sal_pay_in_asg;
917: --
918: FETCH csr_sal_pay_in_asg INTO l_exists;
919: hr_utility.set_location(l_proc,15);
920: IF csr_sal_pay_in_asg%FOUND THEN
921: -- it belongs to an assignment
922: -- only name can be changed
923: if (p_rec.name

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

921: -- it belongs to an assignment
922: -- only name can be changed
923: if (p_rec.name
924: = per_ppb_shd.g_old_rec.name) then
925: hr_utility.set_location('Entering:'||l_proc, 20);
926: fnd_message.set_name('PER','HR_51268_PYP_CANT_UPD_RECORD');
927: fnd_message.raise_error;
928: else
929: hr_utility.set_location('Entering:'||l_proc, 25);

Line 929: hr_utility.set_location('Entering:'||l_proc, 25);

925: hr_utility.set_location('Entering:'||l_proc, 20);
926: fnd_message.set_name('PER','HR_51268_PYP_CANT_UPD_RECORD');
927: fnd_message.raise_error;
928: else
929: hr_utility.set_location('Entering:'||l_proc, 25);
930: IF (p_rec.input_value_id
931: <> per_ppb_shd.g_old_rec.input_value_id)
932: or (p_rec.rate_id
933: <> per_ppb_shd.g_old_rec.rate_id)

Line 1026: hr_utility.set_location('Entering:'||l_proc, 30);

1022: or (p_rec.information19
1023: <> per_ppb_shd.g_old_rec.information19)
1024: or (p_rec.information20
1025: <> per_ppb_shd.g_old_rec.information20) THEN
1026: hr_utility.set_location('Entering:'||l_proc, 30);
1027: fnd_message.set_name('PER','HR_51268_PYP_CANT_UPD_RECORD');
1028: fnd_message.raise_error;
1029: end if;
1030: --

Line 1038: -- hr_utility.set_location('Leaving:'||l_proc, 35);

1034: end if;
1035: end if;
1036:
1037: --
1038: -- hr_utility.set_location('Leaving:'||l_proc, 35);
1039: --
1040: End chk_sal_basis_asg_exists;
1041: -- ----------------------------------------------------------------------------
1042: -- |-----------------------------< chk_ddf >----------------------------------|

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

1072: --
1073: l_proc varchar2(72) := g_package || 'chk_ddf';
1074: --
1075: begin
1076: hr_utility.set_location('Entering:'||l_proc,10);
1077: --
1078: if ((p_rec.pay_basis_id is not null) and (
1079: nvl(per_ppb_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1080: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

1171: ,p_attribute20_value => p_rec.information20
1172: );
1173: end if;
1174: --
1175: hr_utility.set_location(' Leaving:'||l_proc,20);
1176: end chk_ddf;
1177: --
1178: -- ----------------------------------------------------------------------------
1179: -- |------------------------------< chk_df >----------------------------------|

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

1209: --
1210: l_proc varchar2(72) := g_package || 'chk_df';
1211: --
1212: begin
1213: hr_utility.set_location('Entering:'||l_proc,10);
1214: --
1215: if ((p_rec.pay_basis_id is not null) and (
1216: nvl(per_ppb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1217: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1308: ,p_attribute20_value => p_rec.attribute20
1309: );
1310: end if;
1311: --
1312: hr_utility.set_location(' Leaving:'||l_proc,20);
1313: end chk_df;
1314: --
1315: -- ----------------------------------------------------------------------------
1316: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1383: from per_business_groups_perf pbg
1384: where pbg.business_group_id = p_rec.business_group_id;
1385:
1386: --
1387: hr_utility.set_location('Entering:'||l_proc, 5);
1388: --
1389: -- Call all supporting business operations
1390: --
1391: hr_api.validate_bus_grp_id

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

1443: -- per_ppb_bus.chk_ddf(p_rec);
1444: --
1445: per_ppb_bus.chk_df(p_rec);
1446: --
1447: hr_utility.set_location(' Leaving:'||l_proc, 10);
1448: End insert_validate;
1449: --
1450: -- ----------------------------------------------------------------------------
1451: -- |---------------------------< update_validate >----------------------------|

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

1464: , per_pay_bases ppb
1465: where ppb.pay_basis_id = p_rec.pay_basis_id
1466: and pbg.business_group_id = ppb.business_group_id;
1467: --
1468: hr_utility.set_location('Entering:'||l_proc, 5);
1469: --
1470: -- Call all supporting business operations
1471: --
1472: hr_api.validate_bus_grp_id

Line 1512: hr_utility.set_location('pay annual'||p_rec.pay_annualization_factor||l_proc, 666);

1508: p_object_version_number => p_rec.object_version_number
1509: );
1510:
1511: --
1512: hr_utility.set_location('pay annual'||p_rec.pay_annualization_factor||l_proc, 666);
1513: chk_pay_annualization_factor
1514: (p_pay_annualization_factor => p_rec.pay_annualization_factor,
1515: p_pay_basis => p_rec.pay_basis
1516: );

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

1533: -- per_ppb_bus.chk_ddf(p_rec);
1534: --
1535: per_ppb_bus.chk_df(p_rec);
1536: --
1537: hr_utility.set_location(' Leaving:'||l_proc, 10);
1538: End update_validate;
1539: --
1540: -- ----------------------------------------------------------------------------
1541: -- |---------------------------< delete_validate >----------------------------|

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

1546: --
1547: l_proc varchar2(72) := g_package||'delete_validate';
1548: --
1549: Begin
1550: hr_utility.set_location('Entering:'||l_proc, 5);
1551: --
1552: -- Call all supporting business operations
1553: --
1554: chk_delete(p_pay_basis_id => p_rec.Pay_basis_id

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

1553: --
1554: chk_delete(p_pay_basis_id => p_rec.Pay_basis_id
1555: ,p_object_version_number => p_rec.object_version_number
1556: );
1557: hr_utility.set_location(' Leaving:'||l_proc, 10);
1558: End delete_validate;
1559: --
1560: end per_ppb_bus;