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

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

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

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

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

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

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

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

145: close csr_leg_code;
146: pay_pel_bus.g_element_link_id := p_element_link_id;
147: pay_pel_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 188: hr_utility.set_location('Entering:'||l_proc,10);

184: --
185: l_proc varchar2(72) := g_package || 'chk_df';
186: --
187: begin
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_link_id is not null) and (
191: nvl(pay_pel_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
192: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

283: ,p_attribute20_value => p_rec.attribute20
284: );
285: end if;
286: --
287: hr_utility.set_location(' Leaving:'||l_proc,20);
288: end chk_df;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |-----------------------< chk_non_updateable_args >------------------------|

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

574: --
575: l_proc varchar2(72) := g_package || 'chk_asg_link_usages';
576: --
577: begin
578: hr_utility.set_location('Entering:'||l_proc,10);
579: --
580: pay_asg_link_usages_pkg.insert_alu
581: (p_business_group_id,
582: p_people_group_id,

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

583: p_element_link_id,
584: p_effective_start_date,
585: p_effective_end_date);
586: --
587: hr_utility.set_location(' Leaving:'||l_proc,20);
588: end chk_asg_link_usages;
589:
590: --
591: -- ---------------------------------------------------------------------------

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

610: from pay_element_types_f
611: where element_type_id = p_element_type_id;
612: --
613: begin
614: hr_utility.set_location('Entering:'||l_proc,10);
615: --
616: if p_qualifying_age is not null and
617: (p_qualifying_age < 0 or length(p_qualifying_age) > 2) then
618: fnd_message.set_name('PAY', 'PAY_33096_QUALI_AGE_CHECK');

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

657: p_standard_link_flag := nvl(p_standard_link_flag,rec.standard_link_flag);
658: end loop;
659:
660: --
661: hr_utility.set_location(' Leaving:'||l_proc,20);
662: end chk_defaults;
663:
664: --
665: -- ---------------------------------------------------------------------------

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

689: l_object_version_number number;
690: l_pay_basis_warning boolean;
691: --
692: begin
693: hr_utility.set_location('Entering:'||l_proc,10);
694: --
695: for rec in csr_InputValues
696: loop
697: pay_link_input_values_api.create_liv_internal

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

710: ,p_pay_basis_warning => l_pay_basis_warning
711: );
712: end loop;
713: --
714: hr_utility.set_location(' Leaving:'||l_proc,20);
715: end chk_link_input_values;
716:
717: --
718: -- ---------------------------------------------------------------------------

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

738: --
739: l_proc varchar2(72) := g_package || 'chk_end_date';
740: --
741: begin
742: hr_utility.set_location('Entering:'||l_proc,10);
743: --
744: p_effective_end_date := pay_element_links_pkg.max_end_date
745: (p_element_type_id,
746: p_element_link_id,

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

757: p_employment_category,
758: p_pay_basis_id,
759: p_business_group_id);
760: --
761: hr_utility.set_location(' Leaving:'||l_proc,20);
762: end chk_end_date;
763:
764: --
765: -- ---------------------------------------------------------------------------

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

786: --
787: l_proc varchar2(72) := g_package || 'chk_standard_entries';
788: --
789: begin
790: hr_utility.set_location('Entering:'||l_proc,10);
791: --
792: hrentmnt.maintain_entries_el
793: (p_business_group_id,
794: p_element_link_id,

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

805: p_pay_basis_id,
806: p_employment_category,
807: p_people_group_id);
808: --
809: hr_utility.set_location(' Leaving:'||l_proc,20);
810: end chk_standard_entries;
811:
812: --
813: -- ---------------------------------------------------------------------------

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

857: l_proc varchar2(72) := g_package || 'chk_ben_contri';
858: l_exists varchar2(1);
859: --
860: begin
861: hr_utility.set_location('Entering:'||l_proc,10);
862: --
863: Open csr_ben_contri_used;
864: Fetch csr_ben_contri_used into l_exists;
865: If csr_ben_contri_used%found then

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

876: --
877: End If;
878: Close csr_ben_contri_used;
879: --
880: hr_utility.set_location(' Leaving:'||l_proc,20);
881: end chk_ben_contri;
882:
883: -- ---------------------------------------------------------------------------
884: -- |------------------------------------------------------------|

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

909: l_proc varchar2(72) := g_package || 'chk_emp_cat';
910: l_dummy varchar(1);
911: --
912: begin
913: hr_utility.set_location('Entering:'||l_proc,10);
914: --
915: If p_employment_category is not null Then
916: If hr_api.not_exists_in_hr_lookups
917: (p_effective_date

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

925: --
926: End If;
927: End If;
928: --
929: hr_utility.set_location(' Leaving:'||l_proc,20);
930: end chk_emp_cat;
931: --
932: -- ---------------------------------------------------------------------------
933: -- |-----------------------------------------------------------|

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

952: and p_effective_date
953: between date_from and nvl(date_to, g_eot) ;
954: --
955: begin
956: hr_utility.set_location('Entering:'||l_proc,10);
957: --
958: open csr_OrgUnit;
959: fetch csr_OrgUnit into l_dummy;
960: if csr_OrgUnit%notfound then

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

965: close csr_OrgUnit;
966:
967: --p_location_id := nvl(p_location_id,l_dummy);
968: --
969: hr_utility.set_location(' Leaving:'||l_proc,20);
970:
971: end chk_org_unit;
972:
973: -- ---------------------------------------------------------------------------

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

1017: and (p_organization_id is null or p_organization_id =pos.organization_id)
1018: and (p_job_id is null or p_job_id = pos.job_id);
1019: --
1020: begin
1021: hr_utility.set_location('Entering:'||l_proc,10);
1022: --
1023: open csr_position;
1024: fetch csr_position into l_dummy;
1025: if csr_position%notfound then

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

1028: fnd_message.raise_error;
1029: end if;
1030: close csr_position;
1031: --
1032: hr_utility.set_location(' Leaving:'||l_proc,20);
1033:
1034: end chk_position;
1035:
1036: -- ---------------------------------------------------------------------------

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

1074: and p_effective_date between job.date_from and nvl(job.date_to, g_eot)
1075: and job.job_id = p_job_id;
1076: --
1077: begin
1078: hr_utility.set_location('Entering:'||l_proc,10);
1079: --
1080: open csr_jobs;
1081: fetch csr_jobs into l_dummy;
1082: if csr_jobs%notfound then

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

1088: fnd_message.raise_error;
1089: end if;
1090: close csr_jobs;
1091: --
1092: hr_utility.set_location(' Leaving:'||l_proc,20);
1093:
1094: end chk_job_id;
1095: --
1096: --

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

1135: and p_effective_date
1136: between grade.date_from and nvl (grade.date_to,g_eot);
1137: --
1138: begin
1139: hr_utility.set_location('Entering:'||l_proc,10);
1140: --
1141: open csr_grades;
1142: fetch csr_grades into l_dummy;
1143: if csr_grades%notfound then

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

1149: fnd_message.raise_error;
1150: end if;
1151: close csr_grades;
1152: --
1153: hr_utility.set_location(' Leaving:'||l_proc,20);
1154:
1155: end chk_grade_id;
1156:
1157: -- ---------------------------------------------------------------------------

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

1191: and p_effective_date between nvl(ppg.start_date_active,p_effective_date)
1192: and nvl(ppg.end_date_active, g_eot);
1193: --
1194: begin
1195: hr_utility.set_location('Entering:'||l_proc,10);
1196: --
1197: open csr_people_group_id;
1198: fetch csr_people_group_id into l_dummy;
1199: if csr_people_group_id%notfound then

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

1205: fnd_message.raise_error;
1206: end if;
1207: close csr_people_group_id;
1208: --
1209: hr_utility.set_location(' Leaving:'||l_proc,20);
1210:
1211: end chk_people_group_id;
1212:
1213: --

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

1240: --
1241: l_proc varchar2(72) := g_package || 'chk_linktoallpr';
1242: --
1243: begin
1244: hr_utility.set_location('Entering:'||l_proc,10);
1245: --
1246: if p_link_to_all_payrolls_flag = 'Y' and p_payroll_id is not null then
1247: fnd_message.set_name('PAY', 'PAY_33088_LINK_ALL_PAYROLLS');
1248: fnd_message.raise_error;

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

1247: fnd_message.set_name('PAY', 'PAY_33088_LINK_ALL_PAYROLLS');
1248: fnd_message.raise_error;
1249: end if;
1250: --
1251: hr_utility.set_location(' Leaving:'||l_proc,20);
1252:
1253: end chk_linktoallpr;
1254:
1255: --

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

1412: and p_effective_date between type3.effective_start_date
1413: and type3.effective_end_date );
1414: --
1415: begin
1416: hr_utility.set_location('Entering:'||l_proc,10);
1417: --
1418: open csr_CostableFlag;
1419: Fetch csr_CostableFlag into l_costable_flag;
1420: close csr_CostableFlag;

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

1470: close csr_cr_db_class;
1471: end if;
1472: end if;
1473: --
1474: hr_utility.set_location(' Leaving:'||l_proc,20);
1475:
1476: end chk_costable_type;
1477:
1478: --

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

1504: p_datetrack_mode in varchar2)
1505: is
1506: l_proc varchar2(72) := g_package || 'chk_costable_type_for_upd';
1507: begin
1508: hr_utility.set_location('Entering:'||l_proc,10);
1509: if pay_pel_shd.g_old_rec.costable_type <> p_costable_type
1510: and p_datetrack_mode = hr_api.g_update then
1511: fnd_message.set_name('PAY', 'PAY_6466_LINK_NO_COST_UPD2');
1512: fnd_message.raise_error;

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

1510: and p_datetrack_mode = hr_api.g_update then
1511: fnd_message.set_name('PAY', 'PAY_6466_LINK_NO_COST_UPD2');
1512: fnd_message.raise_error;
1513: end if;
1514: hr_utility.set_location(' Leaving:'||l_proc,20);
1515: end;
1516:
1517: --
1518: -- ---------------------------------------------------------------------------

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

1588:
1589: */
1590: --
1591: begin
1592: hr_utility.set_location('Entering:'||l_proc,10);
1593: --
1594: -- Only check for change of standard link flag if not inserting
1595: if (p_datetrack_mode <> hr_api.g_insert)
1596: then

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

1595: if (p_datetrack_mode <> hr_api.g_insert)
1596: then
1597: if pay_pel_shd.g_old_rec.standard_link_flag = 'N'
1598: and p_standard_link_flag = 'Y' then
1599: hr_utility.set_location(l_proc,20);
1600: open csr_DateEffRecs;
1601: fetch csr_DateEffRecs into l_dummy;
1602: if (csr_DateEffRecs%found or p_datetrack_mode = hr_api.g_update) then
1603: close csr_DateEffRecs;

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

1610: --
1611: -- Bugfix 5012412
1612: -- Match standard link flag against processing type
1613: if (p_standard_link_flag = 'Y') then
1614: hr_utility.set_location(l_proc,30);
1615: --
1616: open csr_ProcessingType;
1617: fetch csr_ProcessingType into l_processing_type;
1618: close csr_ProcessingType;

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

1618: close csr_ProcessingType;
1619: --
1620: if (l_processing_type = 'N')
1621: then
1622: hr_utility.set_location(l_proc,40);
1623: -- Standard link flag can only be 'Y' if processing type is 'R', i.e. recurring
1624: fnd_message.set_name('PAY', 'PAY_33296_INVLD_STD_LINK_FLAG');
1625: fnd_message.raise_error;
1626: end if;

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

1624: fnd_message.set_name('PAY', 'PAY_33296_INVLD_STD_LINK_FLAG');
1625: fnd_message.raise_error;
1626: end if;
1627: --
1628: hr_utility.set_location(l_proc,40);
1629: --
1630: -- #5512101.
1631: -- Check to see if salary basis exists for this element type.
1632:

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

1643:
1644: */
1645: end if;
1646: --
1647: hr_utility.set_location(' Leaving:'||l_proc,50);
1648:
1649: end chk_standard_link_flag;
1650:
1651: --

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

1661: --
1662: l_proc varchar2(72) := g_package || 'chk_date_eff_delete';
1663: --
1664: begin
1665: hr_utility.set_location('Entering:'||l_proc,10);
1666: --
1667: pay_element_links_pkg.check_deletion_allowed(p_element_link_id,p_delete_mode,
1668: p_validation_start_date);
1669:

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

1666: --
1667: pay_element_links_pkg.check_deletion_allowed(p_element_link_id,p_delete_mode,
1668: p_validation_start_date);
1669:
1670: hr_utility.set_location(' Leaving:'||l_proc,20);
1671: end chk_date_eff_delete;
1672:
1673: -- ----------------------------------------------------------------------------
1674: -- |---------------------------< insert_validate >----------------------------|

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

1683: --
1684: l_proc varchar2(72) := g_package||'insert_validate';
1685: --
1686: Begin
1687: hr_utility.set_location('Entering:'||l_proc, 5);
1688: --
1689: -- Call all supporting business operations
1690: --
1691: hr_api.validate_bus_grp_id

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

1811:
1812:
1813: --
1814: Begin
1815: hr_utility.set_location('Entering:'||l_proc, 5);
1816: --
1817: -- Call all supporting business operations
1818: --
1819: hr_api.validate_bus_grp_id

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

1899: p_transfer_to_gl => p_rec.transfer_to_gl_flag ,
1900: p_balancing_keyflex_id => p_rec.balancing_keyflex_id ,
1901: p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id
1902: );
1903: hr_utility.set_location(' Leaving:'||l_proc, 10);
1904: End update_validate;
1905: --
1906: -- ----------------------------------------------------------------------------
1907: -- |---------------------------< delete_validate >----------------------------|

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

1916: --
1917: l_proc varchar2(72) := g_package||'delete_validate';
1918: --
1919: Begin
1920: hr_utility.set_location('Entering:'||l_proc, 5);
1921: --
1922: -- Call all supporting business operations
1923: --
1924: dt_delete_validate

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

1928: ,p_element_link_id => p_rec.element_link_id
1929: );
1930:
1931: --
1932: hr_utility.set_location(' Leaving:'||l_proc, 10);
1933: End delete_validate;
1934: --
1935: end pay_pel_bus;