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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hr_pdt_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

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 80: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

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

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

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

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

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

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

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

149: close csr_leg_code;
150: hr_pdt_bus.g_person_deployment_id := p_person_deployment_id;
151: hr_pdt_bus.g_legislation_code := l_legislation_code;
152: end if;
153: hr_utility.set_location(' Leaving:'|| l_proc, 40);
154: return l_legislation_code;
155: end return_legislation_code;
156: --
157: -- ----------------------------------------------------------------------------

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

188: --
189: l_proc varchar2(72) := g_package || 'chk_ddf';
190: --
191: begin
192: hr_utility.set_location('Entering:'||l_proc,10);
193: --
194: if ((p_rec.person_deployment_id is not null) and (
195: nvl(hr_pdt_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
196: nvl(p_rec.per_information_category, hr_api.g_varchar2) or

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

327: ,p_attribute30_value => p_rec.per_information30
328: );
329: end if;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc,20);
332: end chk_ddf;
333: --
334: -- ----------------------------------------------------------------------------
335: -- |-----------------------< chk_non_updateable_args >------------------------|

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

367: l_argument varchar2(30);
368: --
369: Begin
370: --
371: hr_utility.set_location('Entering:'|| l_proc,10);
372: --
373: -- Only proceed with the validation if a row exists for the current
374: -- record in the HR Schema.
375: --

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

407: raise l_error;
408: end if;
409: --
410: --
411: hr_utility.set_location(' Leaving : '|| l_proc, 30);
412: --
413: exception
414: when l_error then
415: hr_api.argument_changed_error

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

459: select 1
460: from per_business_groups_perf
461: where business_group_id = p_bg_id;
462: begin
463: hr_utility.set_location('Entering:'||l_proc, 10);
464: --
465: hr_api.mandatory_arg_error
466: (p_api_name => l_proc
467: ,p_argument => 'from_business_group_id'

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

495: else
496: close csr_bg_exists;
497: end if;
498: --
499: hr_utility.set_location('Leaving:'||l_proc, 20);
500: --
501: end chk_business_groups;
502: --
503: -- ---------------------------------------------------------------------------

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

553: and p_start_date between
554: pds.date_start and nvl(pds.actual_termination_date,hr_api.g_eot);
555: --
556: begin
557: hr_utility.set_location('Entering:'||l_proc, 10);
558: --
559: -- Check mandatory parameters have been set
560: --
561: hr_api.mandatory_arg_error

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

605: --
606: end if;
607: end if;
608: --
609: hr_utility.set_location('Leaving:'||l_proc, 20);
610: --
611: exception
612: when app_exception.application_exception then
613: if hr_multi_message.exception_add

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

612: when app_exception.application_exception then
613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'
615: ) then
616: hr_utility.set_location(' Leaving:'||l_proc, 50);
617: raise;
618: end if;
619: hr_utility.set_location(' Leaving:'||l_proc,60);
620: end chk_from_person_id;

Line 619: hr_utility.set_location(' Leaving:'||l_proc,60);

615: ) then
616: hr_utility.set_location(' Leaving:'||l_proc, 50);
617: raise;
618: end if;
619: hr_utility.set_location(' Leaving:'||l_proc,60);
620: end chk_from_person_id;
621: --
622: -- ---------------------------------------------------------------------------
623: -- |------------------------< chk_to_person_id >-----------------------------|

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

696: and ppt1.system_person_type in ('EMP','CWK','APL')
697: and ptu1.effective_start_date = p_start_date);
698: --
699: begin
700: hr_utility.set_location('Entering:'||l_proc, 10);
701: --
702: -- Check mandatory parameters have been set
703: --
704: hr_api.mandatory_arg_error

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

789: --
790: end if; --api updating
791: end if; --multi message
792: --
793: hr_utility.set_location('Leaving:'||l_proc, 20);
794: --
795: exception
796: when app_exception.application_exception then
797: if hr_multi_message.exception_add

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

796: when app_exception.application_exception then
797: if hr_multi_message.exception_add
798: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'
799: ) then
800: hr_utility.set_location(' Leaving:'||l_proc, 50);
801: raise;
802: end if;
803: hr_utility.set_location(' Leaving:'||l_proc,60);
804: end chk_to_person_id;

Line 803: hr_utility.set_location(' Leaving:'||l_proc,60);

799: ) then
800: hr_utility.set_location(' Leaving:'||l_proc, 50);
801: raise;
802: end if;
803: hr_utility.set_location(' Leaving:'||l_proc,60);
804: end chk_to_person_id;
805: --
806: -- ---------------------------------------------------------------------------
807: -- |------------------------< chk_person_type_id >----------------------------|

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

849: from per_person_types
850: where person_type_id = p_person_type_id;
851: --
852: begin
853: hr_utility.set_location('Entering:'||l_proc, 10);
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc
857: ,p_argument => 'to_business_group_id'

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

897:
898: end if; --api updating
899: end if; --multi message
900: --
901: hr_utility.set_location('Leaving:'||l_proc, 20);
902: --
903: exception
904: when app_exception.application_exception then
905: if hr_multi_message.exception_add

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

904: when app_exception.application_exception then
905: if hr_multi_message.exception_add
906: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PERSON_TYPE_ID'
907: ) then
908: hr_utility.set_location(' Leaving:'||l_proc, 50);
909: raise;
910: end if;
911: hr_utility.set_location(' Leaving:'||l_proc,60);
912: end chk_person_type_id;

Line 911: hr_utility.set_location(' Leaving:'||l_proc,60);

907: ) then
908: hr_utility.set_location(' Leaving:'||l_proc, 50);
909: raise;
910: end if;
911: hr_utility.set_location(' Leaving:'||l_proc,60);
912: end chk_person_type_id;
913: --
914: -- ---------------------------------------------------------------------------
915: -- |------------------------< chk_start_end_date >---------------------------|

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

949: l_proc varchar2(72) := g_package||'chk_start_end_date';
950: l_api_updating boolean;
951: --
952: begin
953: hr_utility.set_location('Entering:'||l_proc, 10);
954: --
955: hr_api.mandatory_arg_error
956: (p_api_name => l_proc
957: ,p_argument => 'start_date'

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

1002: -- End of Additions
1003: end if;
1004: end if;
1005: --
1006: hr_utility.set_location('Leaving:'||l_proc, 20);
1007: --
1008: exception
1009: when app_exception.application_exception then
1010: if hr_multi_message.exception_add

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

1010: if hr_multi_message.exception_add
1011: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1012: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
1013: ) then
1014: hr_utility.set_location(' Leaving:'||l_proc, 50);
1015: raise;
1016: end if;
1017: hr_utility.set_location(' Leaving:'||l_proc,60);
1018: end chk_start_end_date;

Line 1017: hr_utility.set_location(' Leaving:'||l_proc,60);

1013: ) then
1014: hr_utility.set_location(' Leaving:'||l_proc, 50);
1015: raise;
1016: end if;
1017: hr_utility.set_location(' Leaving:'||l_proc,60);
1018: end chk_start_end_date;
1019: --
1020: --
1021: -- ---------------------------------------------------------------------------

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

1132: where person_id = p_from_person_id
1133: and effective_start_date > nvl(p_end_date,hr_api.g_eot);
1134: --
1135: begin
1136: hr_utility.set_location('Entering:'||l_proc, 10);
1137: --
1138: hr_api.mandatory_arg_error
1139: (p_api_name => l_proc
1140: ,p_argument => 'from_person_id'

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

1176: --
1177: end if; --api updating
1178: end if; --multi mesage
1179: --
1180: hr_utility.set_location('Leaving:'||l_proc, 20);
1181: --
1182: exception
1183: when app_exception.application_exception then
1184: if hr_multi_message.exception_add

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

1183: when app_exception.application_exception then
1184: if hr_multi_message.exception_add
1185: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PERMANENT'
1186: ) then
1187: hr_utility.set_location(' Leaving:'||l_proc, 50);
1188: raise;
1189: end if;
1190: hr_utility.set_location(' Leaving:'||l_proc,60);
1191: end chk_permanent;

Line 1190: hr_utility.set_location(' Leaving:'||l_proc,60);

1186: ) then
1187: hr_utility.set_location(' Leaving:'||l_proc, 50);
1188: raise;
1189: end if;
1190: hr_utility.set_location(' Leaving:'||l_proc,60);
1191: end chk_permanent;
1192: --
1193: -- ---------------------------------------------------------------------------
1194: -- |------------------------< chk_deployment_reason >------------------------|

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

1230: l_proc varchar2(72) := g_package||'chk_deployment_reason';
1231: l_api_updating boolean;
1232: --
1233: begin
1234: hr_utility.set_location('Entering:'||l_proc, 10);
1235: --
1236: hr_api.mandatory_arg_error
1237: (p_api_name => l_proc
1238: ,p_argument => 'start_date'

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

1265: end if;
1266: end if; --api updating
1267: end if; --multi message
1268: --
1269: hr_utility.set_location('Leaving:'||l_proc, 20);
1270: --
1271: exception
1272: when app_exception.application_exception then
1273: if hr_multi_message.exception_add

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

1272: when app_exception.application_exception then
1273: if hr_multi_message.exception_add
1274: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.DEPLOYMENT_REASON'
1275: ) then
1276: hr_utility.set_location(' Leaving:'||l_proc, 50);
1277: raise;
1278: end if;
1279: hr_utility.set_location(' Leaving:'||l_proc,60);
1280: end chk_deployment_reason;

Line 1279: hr_utility.set_location(' Leaving:'||l_proc,60);

1275: ) then
1276: hr_utility.set_location(' Leaving:'||l_proc, 50);
1277: raise;
1278: end if;
1279: hr_utility.set_location(' Leaving:'||l_proc,60);
1280: end chk_deployment_reason;
1281: --
1282: -- ---------------------------------------------------------------------------
1283: -- |------------------------< chk_employee_number >--------------------------|

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

1344: and employee_number=p_employee_number
1345: and business_group_id = p_to_business_group_id;
1346: --
1347: begin
1348: hr_utility.set_location('Entering:'||l_proc, 10);
1349: --
1350: hr_api.mandatory_arg_error
1351: (p_api_name => l_proc
1352: ,p_argument => 'to_business_group_id'

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

1408: end if; --p_employee_number not null
1409: end if; --api updating
1410: end if; --multi message
1411: --
1412: hr_utility.set_location('Leaving:'||l_proc, 20);
1413: --
1414: exception
1415: when app_exception.application_exception then
1416: if hr_multi_message.exception_add

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

1415: when app_exception.application_exception then
1416: if hr_multi_message.exception_add
1417: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.EMPLOYEE_NUMBER'
1418: ) then
1419: hr_utility.set_location(' Leaving:'||l_proc, 50);
1420: raise;
1421: end if;
1422: hr_utility.set_location(' Leaving:'||l_proc,60);
1423: end chk_employee_number;

Line 1422: hr_utility.set_location(' Leaving:'||l_proc,60);

1418: ) then
1419: hr_utility.set_location(' Leaving:'||l_proc, 50);
1420: raise;
1421: end if;
1422: hr_utility.set_location(' Leaving:'||l_proc,60);
1423: end chk_employee_number;
1424: --
1425: -- ---------------------------------------------------------------------------
1426: -- |------------------------< chk_leaving_reason >---------------------------|

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

1465: l_proc varchar2(72) := g_package||'chk_leaving_reason';
1466: l_api_updating boolean;
1467: --
1468: begin
1469: hr_utility.set_location('Entering:'||l_proc, 10);
1470: --
1471: hr_api.mandatory_arg_error
1472: (p_api_name => l_proc
1473: ,p_argument => 'start_date'

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

1504: end if; --leaving reason not null
1505: end if; --api updating
1506: end if; --multi message
1507: --
1508: hr_utility.set_location('Leaving:'||l_proc, 20);
1509: --
1510: exception
1511: when app_exception.application_exception then
1512: if hr_multi_message.exception_add

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

1511: when app_exception.application_exception then
1512: if hr_multi_message.exception_add
1513: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LEAVING_REASON'
1514: ) then
1515: hr_utility.set_location(' Leaving:'||l_proc, 50);
1516: raise;
1517: end if;
1518: hr_utility.set_location(' Leaving:'||l_proc,60);
1519: end chk_leaving_reason;

Line 1518: hr_utility.set_location(' Leaving:'||l_proc,60);

1514: ) then
1515: hr_utility.set_location(' Leaving:'||l_proc, 50);
1516: raise;
1517: end if;
1518: hr_utility.set_location(' Leaving:'||l_proc,60);
1519: end chk_leaving_reason;
1520: --
1521: -- ---------------------------------------------------------------------------
1522: -- |------------------------< chk_leaving_person_type_id >-------------------|

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

1567: from per_person_types
1568: where person_type_id = p_leaving_person_type_id;
1569: --
1570: begin
1571: hr_utility.set_location('Entering:'||l_proc, 10);
1572: --
1573: hr_api.mandatory_arg_error
1574: (p_api_name => l_proc
1575: ,p_argument => 'to_business_group_id'

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

1620:
1621: end if; --api updating
1622: end if; --multi message
1623: --
1624: hr_utility.set_location('Leaving:'||l_proc, 20);
1625: --
1626: exception
1627: when app_exception.application_exception then
1628: if hr_multi_message.exception_add

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

1627: when app_exception.application_exception then
1628: if hr_multi_message.exception_add
1629: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LEAVING_PERSON_TYPE_ID'
1630: ) then
1631: hr_utility.set_location(' Leaving:'||l_proc, 50);
1632: raise;
1633: end if;
1634: hr_utility.set_location(' Leaving:'||l_proc,60);
1635: end chk_leaving_person_type_id;

Line 1634: hr_utility.set_location(' Leaving:'||l_proc,60);

1630: ) then
1631: hr_utility.set_location(' Leaving:'||l_proc, 50);
1632: raise;
1633: end if;
1634: hr_utility.set_location(' Leaving:'||l_proc,60);
1635: end chk_leaving_person_type_id;
1636: --
1637: -- ---------------------------------------------------------------------------
1638: -- |------------------------< chk_status >-----------------------------------|

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

1674: l_proc varchar2(72) := g_package||'chk_status';
1675: l_api_updating boolean;
1676: --
1677: begin
1678: hr_utility.set_location('Entering:'||l_proc, 10);
1679: --
1680: hr_api.mandatory_arg_error
1681: (p_api_name => l_proc
1682: ,p_argument => 'status'

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

1717:
1718: end if; --api updating
1719: end if; --multi message
1720: --
1721: hr_utility.set_location('Leaving:'||l_proc, 20);
1722: --
1723: exception
1724: when app_exception.application_exception then
1725: if hr_multi_message.exception_add

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

1724: when app_exception.application_exception then
1725: if hr_multi_message.exception_add
1726: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.STATUS'
1727: ) then
1728: hr_utility.set_location(' Leaving:'||l_proc, 50);
1729: raise;
1730: end if;
1731: hr_utility.set_location(' Leaving:'||l_proc,60);
1732: end chk_status;

Line 1731: hr_utility.set_location(' Leaving:'||l_proc,60);

1727: ) then
1728: hr_utility.set_location(' Leaving:'||l_proc, 50);
1729: raise;
1730: end if;
1731: hr_utility.set_location(' Leaving:'||l_proc,60);
1732: end chk_status;
1733: --
1734: -- ---------------------------------------------------------------------------
1735: -- |------------------------< chk_deplymt_policy_id >------------------------|

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

1765: l_proc varchar2(72) := g_package||'chk_deplymt_policy_id';
1766: l_api_updating boolean;
1767: --
1768: begin
1769: hr_utility.set_location('Entering:'||l_proc, 10);
1770: --
1771: if p_deplymt_policy_id is not null then
1772: fnd_message.set_name('PER','HR_449643_PDT_INV_POLICY');
1773: fnd_message.raise_error;

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

1772: fnd_message.set_name('PER','HR_449643_PDT_INV_POLICY');
1773: fnd_message.raise_error;
1774: end if;
1775: --
1776: hr_utility.set_location('Leaving:'||l_proc, 20);
1777: --
1778: exception
1779: when app_exception.application_exception then
1780: if hr_multi_message.exception_add

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

1779: when app_exception.application_exception then
1780: if hr_multi_message.exception_add
1781: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.DEPLYMT_POLICY_ID'
1782: ) then
1783: hr_utility.set_location(' Leaving:'||l_proc, 50);
1784: raise;
1785: end if;
1786: hr_utility.set_location(' Leaving:'||l_proc,60);
1787: end chk_deplymt_policy_id;

Line 1786: hr_utility.set_location(' Leaving:'||l_proc,60);

1782: ) then
1783: hr_utility.set_location(' Leaving:'||l_proc, 50);
1784: raise;
1785: end if;
1786: hr_utility.set_location(' Leaving:'||l_proc,60);
1787: end chk_deplymt_policy_id;
1788: --
1789: -- ---------------------------------------------------------------------------
1790: -- |------------------------< chk_retain_direct_reports >--------------------|

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

1837: where supervisor_id = p_person_id
1838: and p_start_date between effective_start_date and effective_end_date;
1839: --
1840: begin
1841: hr_utility.set_location('Entering:'||l_proc, 10);
1842: --
1843: hr_api.mandatory_arg_error
1844: (p_api_name => l_proc
1845: ,p_argument => 'from_person_id'

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

1881: --
1882: end if; --api updating
1883: end if; --multi mesage
1884: --
1885: hr_utility.set_location('Leaving:'||l_proc, 20);
1886: --
1887: exception
1888: when app_exception.application_exception then
1889: if hr_multi_message.exception_add

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

1888: when app_exception.application_exception then
1889: if hr_multi_message.exception_add
1890: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.RETAIN_DIRECT_REPORTS'
1891: ) then
1892: hr_utility.set_location(' Leaving:'||l_proc, 50);
1893: raise;
1894: end if;
1895: hr_utility.set_location(' Leaving:'||l_proc,60);
1896: end chk_retain_direct_reports;

Line 1895: hr_utility.set_location(' Leaving:'||l_proc,60);

1891: ) then
1892: hr_utility.set_location(' Leaving:'||l_proc, 50);
1893: raise;
1894: end if;
1895: hr_utility.set_location(' Leaving:'||l_proc,60);
1896: end chk_retain_direct_reports;
1897: --
1898: -- ---------------------------------------------------------------------------
1899: -- |------------------------< chk_organization_id >--------------------------|

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

1951: from per_business_groups_perf
1952: where business_group_id = p_to_business_group_id;
1953: --
1954: begin
1955: hr_utility.set_location('Entering:'||l_proc, 10);
1956: --
1957: hr_api.mandatory_arg_error
1958: (p_api_name => l_proc
1959: ,p_argument => 'organization_id'

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

1994: close csr_check_hr_org;
1995: end if;
1996: end if; --api updating
1997: --
1998: hr_utility.set_location('Leaving:'||l_proc, 20);
1999: --
2000: exception
2001: when app_exception.application_exception then
2002: if hr_multi_message.exception_add

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

2001: when app_exception.application_exception then
2002: if hr_multi_message.exception_add
2003: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2004: ) then
2005: hr_utility.set_location(' Leaving:'||l_proc, 50);
2006: raise;
2007: end if;
2008: hr_utility.set_location(' Leaving:'||l_proc,60);
2009: end chk_organization_id;

Line 2008: hr_utility.set_location(' Leaving:'||l_proc,60);

2004: ) then
2005: hr_utility.set_location(' Leaving:'||l_proc, 50);
2006: raise;
2007: end if;
2008: hr_utility.set_location(' Leaving:'||l_proc,60);
2009: end chk_organization_id;
2010: --
2011: -- ---------------------------------------------------------------------------
2012: -- |------------------------< chk_location_id >------------------------------|

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

2054: where location_id = p_location_id
2055: and nvl(business_group_id,p_to_business_group_id)=p_to_business_group_id;
2056: --
2057: begin
2058: hr_utility.set_location('Entering:'||l_proc, 10);
2059: --
2060: hr_api.mandatory_arg_error
2061: (p_api_name => l_proc
2062: ,p_argument => 'start_date'

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

2102: end if; --location not null
2103: end if; --api updating
2104: end if; --multi message
2105: --
2106: hr_utility.set_location('Leaving:'||l_proc, 20);
2107: --
2108: exception
2109: when app_exception.application_exception then
2110: if hr_multi_message.exception_add

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

2110: if hr_multi_message.exception_add
2111: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LOCATION_ID'
2112: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2113: ) then
2114: hr_utility.set_location(' Leaving:'||l_proc, 50);
2115: raise;
2116: end if;
2117: hr_utility.set_location(' Leaving:'||l_proc,60);
2118: end chk_location_id;

Line 2117: hr_utility.set_location(' Leaving:'||l_proc,60);

2113: ) then
2114: hr_utility.set_location(' Leaving:'||l_proc, 50);
2115: raise;
2116: end if;
2117: hr_utility.set_location(' Leaving:'||l_proc,60);
2118: end chk_location_id;
2119: --
2120: -- ---------------------------------------------------------------------------
2121: -- |------------------------< chk_job_id >-----------------------------------|

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

2170: or jgr.business_group_id is null)
2171: and job.business_group_id = p_to_business_group_id;
2172: --
2173: begin
2174: hr_utility.set_location('Entering:'||l_proc, 10);
2175: --
2176: hr_api.mandatory_arg_error
2177: (p_api_name => l_proc
2178: ,p_argument => 'start_date'

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

2213: end if; --job not null
2214: end if; --api updating
2215: end if; --multi message
2216: --
2217: hr_utility.set_location('Leaving:'||l_proc, 20);
2218: --
2219: exception
2220: when app_exception.application_exception then
2221: if hr_multi_message.exception_add

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

2221: if hr_multi_message.exception_add
2222: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2223: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2224: ) then
2225: hr_utility.set_location(' Leaving:'||l_proc, 50);
2226: raise;
2227: end if;
2228: hr_utility.set_location(' Leaving:'||l_proc,60);
2229: end chk_job_id;

Line 2228: hr_utility.set_location(' Leaving:'||l_proc,60);

2224: ) then
2225: hr_utility.set_location(' Leaving:'||l_proc, 50);
2226: raise;
2227: end if;
2228: hr_utility.set_location(' Leaving:'||l_proc,60);
2229: end chk_job_id;
2230: --
2231: -- ---------------------------------------------------------------------------
2232: -- |------------------------< chk_position_id >------------------------------|

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

2282: and ps.shared_type_id = hp.availability_status_id
2283: and ps.system_type_cd = 'ACTIVE';
2284: --
2285: begin
2286: hr_utility.set_location('Entering:'||l_proc, 10);
2287: --
2288: hr_api.mandatory_arg_error
2289: (p_api_name => l_proc
2290: ,p_argument => 'start_date'

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

2325: end if; --position not null
2326: end if; --api updating
2327: end if; --multi message
2328: --
2329: hr_utility.set_location('Leaving:'||l_proc, 20);
2330: --
2331: exception
2332: when app_exception.application_exception then
2333: if hr_multi_message.exception_add

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

2333: if hr_multi_message.exception_add
2334: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2335: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2336: ) then
2337: hr_utility.set_location(' Leaving:'||l_proc, 50);
2338: raise;
2339: end if;
2340: hr_utility.set_location(' Leaving:'||l_proc,60);
2341: end chk_position_id;

Line 2340: hr_utility.set_location(' Leaving:'||l_proc,60);

2336: ) then
2337: hr_utility.set_location(' Leaving:'||l_proc, 50);
2338: raise;
2339: end if;
2340: hr_utility.set_location(' Leaving:'||l_proc,60);
2341: end chk_position_id;
2342: --
2343: -- ---------------------------------------------------------------------------
2344: -- |------------------------< chk_grade_id >---------------------------------|

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

2389: and p_start_date between
2390: grade.date_from and nvl(grade.date_to,hr_api.g_eot);
2391: --
2392: begin
2393: hr_utility.set_location('Entering:'||l_proc, 10);
2394: --
2395: hr_api.mandatory_arg_error
2396: (p_api_name => l_proc
2397: ,p_argument => 'start_date'

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

2432: end if; --grade not null
2433: end if; --api updating
2434: end if; --multi message
2435: --
2436: hr_utility.set_location('Leaving:'||l_proc, 20);
2437: --
2438: exception
2439: when app_exception.application_exception then
2440: if hr_multi_message.exception_add

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

2440: if hr_multi_message.exception_add
2441: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2442: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2443: ) then
2444: hr_utility.set_location(' Leaving:'||l_proc, 50);
2445: raise;
2446: end if;
2447: hr_utility.set_location(' Leaving:'||l_proc,60);
2448: end chk_grade_id;

Line 2447: hr_utility.set_location(' Leaving:'||l_proc,60);

2443: ) then
2444: hr_utility.set_location(' Leaving:'||l_proc, 50);
2445: raise;
2446: end if;
2447: hr_utility.set_location(' Leaving:'||l_proc,60);
2448: end chk_grade_id;
2449: --
2450: -- ---------------------------------------------------------------------------
2451: -- |------------------------< chk_position_id_job_id >------------------------|

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

2500: and ps.shared_type_id = hp.availability_status_id
2501: and ps.system_type_cd = 'ACTIVE' ;
2502: --
2503: begin
2504: hr_utility.set_location('Entering:'||l_proc, 10);
2505: --
2506: hr_api.mandatory_arg_error
2507: (p_api_name => l_proc
2508: ,p_argument => 'start_date'

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

2539: end if; --pos and job not null
2540: end if; --api updating
2541: end if; --multi message
2542: --
2543: hr_utility.set_location('Leaving:'||l_proc, 20);
2544: --
2545: exception
2546: when app_exception.application_exception then
2547: if hr_multi_message.exception_add

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

2547: if hr_multi_message.exception_add
2548: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2549: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2550: ) then
2551: hr_utility.set_location(' Leaving:'||l_proc, 50);
2552: raise;
2553: end if;
2554: hr_utility.set_location(' Leaving:'||l_proc,60);
2555: end chk_position_id_job_id;

Line 2554: hr_utility.set_location(' Leaving:'||l_proc,60);

2550: ) then
2551: hr_utility.set_location(' Leaving:'||l_proc, 50);
2552: raise;
2553: end if;
2554: hr_utility.set_location(' Leaving:'||l_proc,60);
2555: end chk_position_id_job_id;
2556: --
2557: -- ---------------------------------------------------------------------------
2558: -- |------------------------< chk_position_id_grade_id >---------------------|

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

2609: and p_start_date between
2610: date_from and nvl(date_to,hr_api.g_eot);
2611: --
2612: begin
2613: hr_utility.set_location('Entering:'||l_proc, 10);
2614: --
2615: hr_api.mandatory_arg_error
2616: (p_api_name => l_proc
2617: ,p_argument => 'start_date'

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

2655: end if; --pos and grade not null
2656: end if; --api updating
2657: end if; --multi message
2658: --
2659: hr_utility.set_location('Leaving:'||l_proc, 20);
2660: --
2661: exception
2662: when app_exception.application_exception then
2663: if hr_multi_message.exception_add

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

2663: if hr_multi_message.exception_add
2664: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2665: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2666: ) then
2667: hr_utility.set_location(' Leaving:'||l_proc, 50);
2668: raise;
2669: end if;
2670: hr_utility.set_location(' Leaving:'||l_proc,60);
2671: end chk_position_id_grade_id;

Line 2670: hr_utility.set_location(' Leaving:'||l_proc,60);

2666: ) then
2667: hr_utility.set_location(' Leaving:'||l_proc, 50);
2668: raise;
2669: end if;
2670: hr_utility.set_location(' Leaving:'||l_proc,60);
2671: end chk_position_id_grade_id;
2672: --
2673: -- ---------------------------------------------------------------------------
2674: -- |------------------------< chk_job_id_grade_id >--------------------------|

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

2725: and p_start_date between
2726: date_from and nvl(date_to,hr_api.g_eot);
2727: --
2728: begin
2729: hr_utility.set_location('Entering:'||l_proc, 10);
2730: --
2731: hr_api.mandatory_arg_error
2732: (p_api_name => l_proc
2733: ,p_argument => 'start_date'

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

2771: end if; --job and grade not null
2772: end if; --api updating
2773: end if; --multi message
2774: --
2775: hr_utility.set_location('Leaving:'||l_proc, 20);
2776: --
2777: exception
2778: when app_exception.application_exception then
2779: if hr_multi_message.exception_add

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

2779: if hr_multi_message.exception_add
2780: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2781: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2782: ) then
2783: hr_utility.set_location(' Leaving:'||l_proc, 50);
2784: raise;
2785: end if;
2786: hr_utility.set_location(' Leaving:'||l_proc,60);
2787: end chk_job_id_grade_id;

Line 2786: hr_utility.set_location(' Leaving:'||l_proc,60);

2782: ) then
2783: hr_utility.set_location(' Leaving:'||l_proc, 50);
2784: raise;
2785: end if;
2786: hr_utility.set_location(' Leaving:'||l_proc,60);
2787: end chk_job_id_grade_id;
2788: --
2789: -- ---------------------------------------------------------------------------
2790: -- |------------------------< chk_position_id_org_id >------------------------|

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

2839: and ps.shared_type_id = hp.availability_status_id
2840: and ps.system_type_cd = 'ACTIVE' ;
2841: --
2842: begin
2843: hr_utility.set_location('Entering:'||l_proc, 10);
2844: --
2845: hr_api.mandatory_arg_error
2846: (p_api_name => l_proc
2847: ,p_argument => 'start_date'

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

2877: end if; --pos and org not null
2878: end if; --api updating
2879: end if; --multi message
2880: --
2881: hr_utility.set_location('Leaving:'||l_proc, 20);
2882: --
2883: exception
2884: when app_exception.application_exception then
2885: if hr_multi_message.exception_add

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

2885: if hr_multi_message.exception_add
2886: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2887: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2888: ) then
2889: hr_utility.set_location(' Leaving:'||l_proc, 50);
2890: raise;
2891: end if;
2892: hr_utility.set_location(' Leaving:'||l_proc,60);
2893: end chk_position_id_org_id;

Line 2892: hr_utility.set_location(' Leaving:'||l_proc,60);

2888: ) then
2889: hr_utility.set_location(' Leaving:'||l_proc, 50);
2890: raise;
2891: end if;
2892: hr_utility.set_location(' Leaving:'||l_proc,60);
2893: end chk_position_id_org_id;
2894: --
2895: -- ---------------------------------------------------------------------------
2896: -- |------------------------< chk_payroll_id >-------------------------------|

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

2949: and payroll_id = p_payroll_id
2950: and business_group_id = p_to_business_group_id;
2951: --
2952: begin
2953: hr_utility.set_location('Entering:'||l_proc, 10);
2954: --
2955: hr_api.mandatory_arg_error
2956: (p_api_name => l_proc
2957: ,p_argument => 'start_date'

Line 2999: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',

2995: close csr_get_leg_code;
2996: --
2997: if hr_general.chk_geocodes_installed = 'Y'
2998: and ( ( l_legislation_code = 'CA'
2999: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
3000: p_legislation => 'CA'))
3001: OR ( l_legislation_code = 'US'
3002: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
3003: p_legislation => 'US')))

Line 3002: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',

2998: and ( ( l_legislation_code = 'CA'
2999: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
3000: p_legislation => 'CA'))
3001: OR ( l_legislation_code = 'US'
3002: and hr_utility.chk_product_install(p_product => 'Oracle Payroll',
3003: p_legislation => 'US')))
3004: then
3005: fnd_message.set_name('PER','HR_449646_PDT_NO_PAYROLL');
3006: fnd_message.raise_error;

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

3008: end if; --payroll not null
3009: end if; --api updating
3010: end if; --multi message
3011: --
3012: hr_utility.set_location('Leaving:'||l_proc, 20);
3013: --
3014: exception
3015: when app_exception.application_exception then
3016: if hr_multi_message.exception_add

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

3016: if hr_multi_message.exception_add
3017: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID'
3018: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3019: ) then
3020: hr_utility.set_location(' Leaving:'||l_proc, 50);
3021: raise;
3022: end if;
3023: hr_utility.set_location(' Leaving:'||l_proc,60);
3024: end chk_payroll_id;

Line 3023: hr_utility.set_location(' Leaving:'||l_proc,60);

3019: ) then
3020: hr_utility.set_location(' Leaving:'||l_proc, 50);
3021: raise;
3022: end if;
3023: hr_utility.set_location(' Leaving:'||l_proc,60);
3024: end chk_payroll_id;
3025: --
3026: -- ---------------------------------------------------------------------------
3027: -- |------------------------< chk_assignment_status_type_id >----------------|

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

3088: and legislation_code= p_legislation_code));
3089: */
3090: --
3091: begin
3092: hr_utility.set_location('Entering:'||l_proc, 10);
3093: --
3094: hr_api.mandatory_arg_error
3095: (p_api_name => l_proc
3096: ,p_argument => 'to_business_group_id'

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

3144: end if;
3145: end if; --api updating
3146: end if; --multi message
3147: --
3148: hr_utility.set_location('Leaving:'||l_proc, 20);
3149: --
3150: exception
3151: when app_exception.application_exception then
3152: if hr_multi_message.exception_add

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

3151: when app_exception.application_exception then
3152: if hr_multi_message.exception_add
3153: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_STATUS_TYPE_ID'
3154: ) then
3155: hr_utility.set_location(' Leaving:'||l_proc, 50);
3156: raise;
3157: end if;
3158: hr_utility.set_location(' Leaving:'||l_proc,60);
3159: end chk_assignment_status_type_id;

Line 3158: hr_utility.set_location(' Leaving:'||l_proc,60);

3154: ) then
3155: hr_utility.set_location(' Leaving:'||l_proc, 50);
3156: raise;
3157: end if;
3158: hr_utility.set_location(' Leaving:'||l_proc,60);
3159: end chk_assignment_status_type_id;
3160: --
3161: -- ---------------------------------------------------------------------------
3162: -- |------------------------< chk_supervisor_id >----------------------------|

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

3220: effective_start_date and effective_end_date
3221: and nvl(current_employee_flag,'N') = 'Y';
3222: --
3223: begin
3224: hr_utility.set_location('Entering:'||l_proc, 10);
3225: --
3226: hr_api.mandatory_arg_error
3227: (p_api_name => l_proc
3228: ,p_argument => 'start_date'

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

3281: end if; --supervisor id not null
3282: end if; --api updating
3283: end if; -- muti message
3284: --
3285: hr_utility.set_location('Leaving:'||l_proc, 20);
3286: --
3287: exception
3288: when app_exception.application_exception then
3289: if hr_multi_message.exception_add

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

3289: if hr_multi_message.exception_add
3290: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ID'
3291: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3292: ) then
3293: hr_utility.set_location(' Leaving:'||l_proc, 50);
3294: raise;
3295: end if;
3296: hr_utility.set_location(' Leaving:'||l_proc,60);
3297: end chk_supervisor_id;

Line 3296: hr_utility.set_location(' Leaving:'||l_proc,60);

3292: ) then
3293: hr_utility.set_location(' Leaving:'||l_proc, 50);
3294: raise;
3295: end if;
3296: hr_utility.set_location(' Leaving:'||l_proc,60);
3297: end chk_supervisor_id;
3298: --
3299: -- ---------------------------------------------------------------------------
3300: -- |------------------------< chk_supervisor_assignment_id >-----------------|

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

3344: and p_start_date between
3345: effective_start_date and effective_end_date;
3346: --
3347: begin
3348: hr_utility.set_location('Entering:'||l_proc, 10);
3349: --
3350: hr_api.mandatory_arg_error
3351: (p_api_name => l_proc
3352: ,p_argument => 'start_date'

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

3396: end if;
3397: end if; --api updating
3398: end if; --multi message
3399: --
3400: hr_utility.set_location('Leaving:'||l_proc, 20);
3401: --
3402: exception
3403: when app_exception.application_exception then
3404: if hr_multi_message.exception_add

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

3403: when app_exception.application_exception then
3404: if hr_multi_message.exception_add
3405: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ASSIGNMENT_ID'
3406: ) then
3407: hr_utility.set_location(' Leaving:'||l_proc, 50);
3408: raise;
3409: end if;
3410: hr_utility.set_location(' Leaving:'||l_proc,60);
3411: end chk_supervisor_assignment_id;

Line 3410: hr_utility.set_location(' Leaving:'||l_proc,60);

3406: ) then
3407: hr_utility.set_location(' Leaving:'||l_proc, 50);
3408: raise;
3409: end if;
3410: hr_utility.set_location(' Leaving:'||l_proc,60);
3411: end chk_supervisor_assignment_id;
3412: --
3413: -- ---------------------------------------------------------------------------
3414: -- |------------------------< chk_pay_basis_id >-----------------------------|

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

3453: from per_pay_bases
3454: where pay_basis_id = p_pay_basis_id;
3455: --
3456: begin
3457: hr_utility.set_location('Entering:'||l_proc, 10);
3458: --
3459: l_api_updating := hr_pdt_shd.api_updating
3460: (p_person_deployment_id => p_person_deployment_id
3461: ,p_object_version_number => p_object_version_number);

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

3481: end if;
3482: end if; -- pay basis not null
3483: end if; --api updating
3484: --
3485: hr_utility.set_location('Leaving:'||l_proc, 20);
3486: --
3487: exception
3488: when app_exception.application_exception then
3489: if hr_multi_message.exception_add

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

3488: when app_exception.application_exception then
3489: if hr_multi_message.exception_add
3490: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAY_BASIS_ID'
3491: ) then
3492: hr_utility.set_location(' Leaving:'||l_proc, 50);
3493: raise;
3494: end if;
3495: hr_utility.set_location(' Leaving:'||l_proc,60);
3496: end chk_pay_basis_id;

Line 3495: hr_utility.set_location(' Leaving:'||l_proc,60);

3491: ) then
3492: hr_utility.set_location(' Leaving:'||l_proc, 50);
3493: raise;
3494: end if;
3495: hr_utility.set_location(' Leaving:'||l_proc,60);
3496: end chk_pay_basis_id;
3497: --
3498: -- ---------------------------------------------------------------------------
3499: -- |------------------------< chk_people_group_id >--------------------------|

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

3550: from per_business_groups_perf
3551: where business_group_id = p_to_business_group_id;
3552: --
3553: begin
3554: hr_utility.set_location('Entering:'||l_proc, 10);
3555: --
3556: hr_api.mandatory_arg_error
3557: (p_api_name => l_proc
3558: ,p_argument => 'start_date'

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

3607: end if; --people group not null
3608: end if; --api updating
3609: end if; --multi message
3610: --
3611: hr_utility.set_location('Leaving:'||l_proc, 20);
3612: --
3613: exception
3614: when app_exception.application_exception then
3615: if hr_multi_message.exception_add

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

3614: when app_exception.application_exception then
3615: if hr_multi_message.exception_add
3616: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PEOPLE_GROUP_ID'
3617: ) then
3618: hr_utility.set_location(' Leaving:'||l_proc, 50);
3619: raise;
3620: end if;
3621: hr_utility.set_location(' Leaving:'||l_proc,60);
3622: end chk_people_group_id;

Line 3621: hr_utility.set_location(' Leaving:'||l_proc,60);

3617: ) then
3618: hr_utility.set_location(' Leaving:'||l_proc, 50);
3619: raise;
3620: end if;
3621: hr_utility.set_location(' Leaving:'||l_proc,60);
3622: end chk_people_group_id;
3623: --
3624: -- ---------------------------------------------------------------------------
3625: -- |------------------------< chk_soft_coding_keyflex_id >-------------------|

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

3690: where message_name = p_message_name
3691: and application_id = 801;
3692: --
3693: begin
3694: hr_utility.set_location('Entering:'||l_proc, 10);
3695: --
3696: hr_api.mandatory_arg_error
3697: (p_api_name => l_proc
3698: ,p_argument => 'start_date'

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

3769: end if; --soft coding keyflex not null
3770: end if; --api updating
3771: end if; --multi message
3772: --
3773: hr_utility.set_location('Leaving:'||l_proc, 20);
3774: --
3775: exception
3776: when app_exception.application_exception then
3777: if hr_multi_message.exception_add

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

3776: when app_exception.application_exception then
3777: if hr_multi_message.exception_add
3778: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SOFT_CODING_KEYFLEX_ID'
3779: ) then
3780: hr_utility.set_location(' Leaving:'||l_proc, 50);
3781: raise;
3782: end if;
3783: hr_utility.set_location(' Leaving:'||l_proc,60);
3784: end chk_soft_coding_keyflex_id;

Line 3783: hr_utility.set_location(' Leaving:'||l_proc,60);

3779: ) then
3780: hr_utility.set_location(' Leaving:'||l_proc, 50);
3781: raise;
3782: end if;
3783: hr_utility.set_location(' Leaving:'||l_proc,60);
3784: end chk_soft_coding_keyflex_id;
3785: --
3786: -- ---------------------------------------------------------------------------
3787: -- |------------------------< chk_assignment_category >----------------------|

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

3820: l_proc varchar2(72) := g_package||'chk_assignment_category';
3821: l_api_updating boolean;
3822: --
3823: begin
3824: hr_utility.set_location('Entering:'||l_proc, 10);
3825: --
3826: hr_api.mandatory_arg_error
3827: (p_api_name => l_proc
3828: ,p_argument => 'start_date'

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

3854: end if; --assignment category not null
3855: end if; --api updating
3856: end if; --multi message
3857: --
3858: hr_utility.set_location('Leaving:'||l_proc, 20);
3859: --
3860: exception
3861: when app_exception.application_exception then
3862: if hr_multi_message.exception_add

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

3862: if hr_multi_message.exception_add
3863: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_CATEGORY'
3864: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3865: ) then
3866: hr_utility.set_location(' Leaving:'||l_proc, 50);
3867: raise;
3868: end if;
3869: hr_utility.set_location(' Leaving:'||l_proc,60);
3870: end chk_assignment_category;

Line 3869: hr_utility.set_location(' Leaving:'||l_proc,60);

3865: ) then
3866: hr_utility.set_location(' Leaving:'||l_proc, 50);
3867: raise;
3868: end if;
3869: hr_utility.set_location(' Leaving:'||l_proc,60);
3870: end chk_assignment_category;
3871: --
3872: -- ---------------------------------------------------------------------------
3873: -- |------------------------< chk_delete >-----------------------------------|

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

3909: from hr_person_deployments
3910: where person_deployment_id = p_person_deployment_id;
3911: --
3912: begin
3913: hr_utility.set_location('Entering:'||l_proc, 10);
3914: --
3915: open csr_deployment;
3916: fetch csr_deployment into l_start_date,l_status;
3917: if csr_deployment%notfound then

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

3925: fnd_message.raise_error;
3926: end if;
3927: end if;
3928: --
3929: hr_utility.set_location('Leaving:'||l_proc, 20);
3930: --
3931: end chk_delete;
3932: --
3933: -- ----------------------------------------------------------------------------

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

3941: l_inv_pos_grade_warning boolean;
3942: l_inv_job_grade_warning boolean;
3943: --
3944: Begin
3945: hr_utility.set_location('Entering:'||l_proc, 5);
3946: --
3947: -- Call all supporting business operations
3948: --
3949: --

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

3954: --
3955: -- Validate Dependent Attributes
3956: --
3957: if g_debug then
3958: hr_utility.set_location(l_proc, 10);
3959: end if;
3960: --
3961: hr_pdt_bus.chk_business_groups
3962: (p_from_business_group_id => p_rec.from_business_group_id

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

3963: ,p_to_business_group_id => p_rec.to_business_group_id
3964: );
3965: --
3966: if g_debug then
3967: hr_utility.set_location(l_proc, 15);
3968: end if;
3969: --
3970: hr_pdt_bus.chk_from_person_id
3971: (p_person_deployment_id => p_rec.person_deployment_id

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

3975: ,p_start_date => p_rec.start_date
3976: );
3977: --
3978: if g_debug then
3979: hr_utility.set_location(l_proc, 20);
3980: end if;
3981: --
3982: hr_pdt_bus.chk_to_person_id
3983: (p_person_deployment_id => p_rec.person_deployment_id

Line 3992: hr_utility.set_location(l_proc, 25);

3988: ,p_status => p_rec.status
3989: );
3990: --
3991: if g_debug then
3992: hr_utility.set_location(l_proc, 25);
3993: end if;
3994: --
3995: hr_pdt_bus.chk_person_type_id
3996: (p_person_type_id => p_rec.person_type_id

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

3999: ,p_object_version_number => p_rec.object_version_number
4000: );
4001: --
4002: if g_debug then
4003: hr_utility.set_location(l_proc,30 );
4004: end if;
4005: --
4006: hr_pdt_bus.chk_start_end_date
4007: (p_start_date => p_rec.start_date

Line 4015: hr_utility.set_location(l_proc, 35);

4011: ,p_status => p_rec.status
4012: );
4013: --
4014: if g_debug then
4015: hr_utility.set_location(l_proc, 35);
4016: end if;
4017: --
4018: hr_pdt_bus.chk_permanent
4019: (p_permanent => p_rec.permanent

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

4023: ,p_object_version_number => p_rec.object_version_number
4024: );
4025: --
4026: if g_debug then
4027: hr_utility.set_location(l_proc, 40);
4028: end if;
4029: --
4030: hr_pdt_bus.chk_deployment_reason
4031: (p_deployment_reason => p_rec.deployment_reason

Line 4038: hr_utility.set_location(l_proc, 45);

4034: ,p_object_version_number => p_rec.object_version_number
4035: );
4036: --
4037: if g_debug then
4038: hr_utility.set_location(l_proc, 45);
4039: end if;
4040: --
4041: hr_pdt_bus.chk_employee_number
4042: (p_employee_number => p_rec.employee_number

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

4046: ,p_object_version_number => p_rec.object_version_number
4047: );
4048: --
4049: if g_debug then
4050: hr_utility.set_location(l_proc,50 );
4051: end if;
4052: --
4053: hr_pdt_bus.chk_leaving_reason
4054: (p_leaving_reason => p_rec.leaving_reason

Line 4062: hr_utility.set_location(l_proc, 55);

4058: ,p_object_version_number => p_rec.object_version_number
4059: );
4060: --
4061: if g_debug then
4062: hr_utility.set_location(l_proc, 55);
4063: end if;
4064: --
4065: hr_pdt_bus.chk_leaving_person_type_id
4066: (p_leaving_person_type_id => p_rec.leaving_person_type_id

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

4070: ,p_object_version_number => p_rec.object_version_number
4071: );
4072: --
4073: if g_debug then
4074: hr_utility.set_location(l_proc, 60);
4075: end if;
4076: --
4077: hr_pdt_bus.chk_status
4078: (p_status => p_rec.status

Line 4085: hr_utility.set_location(l_proc,65 );

4081: ,p_object_version_number => p_rec.object_version_number
4082: );
4083: --
4084: if g_debug then
4085: hr_utility.set_location(l_proc,65 );
4086: end if;
4087: --
4088: hr_pdt_bus.chk_deplymt_policy_id
4089: (p_deplymt_policy_id => p_rec.deplymt_policy_id

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

4089: (p_deplymt_policy_id => p_rec.deplymt_policy_id
4090: );
4091: --
4092: if g_debug then
4093: hr_utility.set_location(l_proc, 70);
4094: end if;
4095: --
4096: hr_pdt_bus.chk_retain_direct_reports
4097: (p_retain_direct_reports => p_rec.retain_direct_reports

Line 4107: hr_utility.set_location(l_proc, 75);

4103: ,p_object_version_number => p_rec.object_version_number
4104: );
4105: --
4106: if g_debug then
4107: hr_utility.set_location(l_proc, 75);
4108: end if;
4109: --
4110: hr_pdt_bus.chk_organization_id
4111: (p_organization_id => p_rec.organization_id

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

4114: ,p_object_version_number => p_rec.object_version_number
4115: );
4116: --
4117: if g_debug then
4118: hr_utility.set_location(l_proc, 80);
4119: end if;
4120: --
4121: hr_pdt_bus.chk_location_id
4122: (p_location_id => p_rec.location_id

Line 4130: hr_utility.set_location(l_proc, 85);

4126: ,p_object_version_number => p_rec.object_version_number
4127: );
4128: --
4129: if g_debug then
4130: hr_utility.set_location(l_proc, 85);
4131: end if;
4132: --
4133: hr_pdt_bus.chk_job_id
4134: (p_job_id => p_rec.job_id

Line 4142: hr_utility.set_location(l_proc,90 );

4138: ,p_object_version_number => p_rec.object_version_number
4139: );
4140: --
4141: if g_debug then
4142: hr_utility.set_location(l_proc,90 );
4143: end if;
4144: --
4145: hr_pdt_bus.chk_position_id
4146: (p_position_id => p_rec.position_id

Line 4154: hr_utility.set_location(l_proc, 95);

4150: ,p_object_version_number => p_rec.object_version_number
4151: );
4152: --
4153: if g_debug then
4154: hr_utility.set_location(l_proc, 95);
4155: end if;
4156: --
4157: hr_pdt_bus.chk_grade_id
4158: (p_grade_id => p_rec.grade_id

Line 4166: hr_utility.set_location(l_proc, 100);

4162: ,p_object_version_number => p_rec.object_version_number
4163: );
4164: --
4165: if g_debug then
4166: hr_utility.set_location(l_proc, 100);
4167: end if;
4168: --
4169: hr_pdt_bus.chk_position_id_job_id
4170: (p_position_id => p_rec.position_id

Line 4178: hr_utility.set_location(l_proc, 105);

4174: ,p_object_version_number => p_rec.object_version_number
4175: );
4176: --
4177: if g_debug then
4178: hr_utility.set_location(l_proc, 105);
4179: end if;
4180: --
4181: hr_pdt_bus.chk_position_id_grade_id
4182: (p_position_id => p_rec.position_id

Line 4191: hr_utility.set_location(l_proc, 110);

4187: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
4188: );
4189: --
4190: if g_debug then
4191: hr_utility.set_location(l_proc, 110);
4192: end if;
4193: --
4194: hr_pdt_bus.chk_job_id_grade_id
4195: (p_job_id => p_rec.job_id

Line 4204: hr_utility.set_location(l_proc, 115);

4200: ,p_inv_job_grade_warning => l_inv_job_grade_warning
4201: );
4202: --
4203: if g_debug then
4204: hr_utility.set_location(l_proc, 115);
4205: end if;
4206: --
4207: hr_pdt_bus.chk_position_id_org_id
4208: (p_position_id => p_rec.position_id

Line 4216: hr_utility.set_location(l_proc, 120);

4212: ,p_object_version_number => p_rec.object_version_number
4213: );
4214: --
4215: if g_debug then
4216: hr_utility.set_location(l_proc, 120);
4217: end if;
4218: --
4219: hr_pdt_bus.chk_payroll_id
4220: (p_payroll_id => p_rec.payroll_id

Line 4228: hr_utility.set_location(l_proc, 125);

4224: ,p_object_version_number => p_rec.object_version_number
4225: );
4226: --
4227: if g_debug then
4228: hr_utility.set_location(l_proc, 125);
4229: end if;
4230: --
4231: hr_pdt_bus.chk_assignment_status_type_id
4232: (p_assignment_status_type_id => p_rec.assignment_status_type_id

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

4235: ,p_object_version_number => p_rec.object_version_number
4236: );
4237: --
4238: if g_debug then
4239: hr_utility.set_location(l_proc, 130);
4240: end if;
4241: --
4242: hr_pdt_bus.chk_supervisor_id
4243: (p_supervisor_id => p_rec.supervisor_id

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

4249: ,p_object_version_number => p_rec.object_version_number
4250: );
4251: --
4252: if g_debug then
4253: hr_utility.set_location(l_proc, 140);
4254: end if;
4255: --
4256: hr_pdt_bus.chk_supervisor_assignment_id
4257: (p_supervisor_assignment_id => p_rec.supervisor_assignment_id

Line 4265: hr_utility.set_location(l_proc, 145);

4261: ,p_object_version_number => p_rec.object_version_number
4262: );
4263: --
4264: if g_debug then
4265: hr_utility.set_location(l_proc, 145);
4266: end if;
4267: --
4268: hr_pdt_bus.chk_pay_basis_id
4269: (p_pay_basis_id => p_rec.pay_basis_id

Line 4276: hr_utility.set_location(l_proc, 150);

4272: ,p_object_version_number => p_rec.object_version_number
4273: );
4274: --
4275: if g_debug then
4276: hr_utility.set_location(l_proc, 150);
4277: end if;
4278: --
4279: hr_pdt_bus.chk_people_group_id
4280: (p_people_group_id => p_rec.people_group_id

Line 4288: hr_utility.set_location(l_proc, 155);

4284: ,p_object_version_number => p_rec.object_version_number
4285: );
4286: --
4287: if g_debug then
4288: hr_utility.set_location(l_proc, 155);
4289: end if;
4290: --
4291: hr_pdt_bus.chk_soft_coding_keyflex_id
4292: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id

Line 4301: hr_utility.set_location(l_proc, 160);

4297: ,p_object_version_number => p_rec.object_version_number
4298: );
4299: --
4300: if g_debug then
4301: hr_utility.set_location(l_proc, 160);
4302: end if;
4303: --
4304: hr_pdt_bus.chk_assignment_category
4305: (p_assignment_category => p_rec.assignment_category

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

4309: );
4310: --
4311: hr_pdt_bus.chk_ddf(p_rec);
4312: --
4313: hr_utility.set_location(' Leaving:'||l_proc, 10);
4314: End insert_validate;
4315: --
4316: -- ----------------------------------------------------------------------------
4317: -- |---------------------------< update_validate >----------------------------|

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

4324: l_inv_pos_grade_warning boolean;
4325: l_inv_job_grade_warning boolean;
4326: --
4327: Begin
4328: hr_utility.set_location('Entering:'||l_proc, 5);
4329: --
4330: -- Call all supporting business operations
4331: --
4332: --

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

4341: (p_rec => p_rec
4342: );
4343: --
4344: if g_debug then
4345: hr_utility.set_location(l_proc, 20);
4346: end if;
4347: --
4348: hr_pdt_bus.chk_to_person_id
4349: (p_person_deployment_id => p_rec.person_deployment_id

Line 4358: hr_utility.set_location(l_proc, 25);

4354: ,p_status => p_rec.status
4355: );
4356: --
4357: if g_debug then
4358: hr_utility.set_location(l_proc, 25);
4359: end if;
4360: --
4361: hr_pdt_bus.chk_person_type_id
4362: (p_person_type_id => p_rec.person_type_id

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

4365: ,p_object_version_number => p_rec.object_version_number
4366: );
4367: --
4368: if g_debug then
4369: hr_utility.set_location(l_proc,30 );
4370: end if;
4371: --
4372: hr_pdt_bus.chk_start_end_date
4373: (p_start_date => p_rec.start_date

Line 4381: hr_utility.set_location(l_proc, 35);

4377: ,p_status => p_rec.status
4378: );
4379: --
4380: if g_debug then
4381: hr_utility.set_location(l_proc, 35);
4382: end if;
4383: --
4384: hr_pdt_bus.chk_deployment_reason
4385: (p_deployment_reason => p_rec.deployment_reason

Line 4392: hr_utility.set_location(l_proc, 45);

4388: ,p_object_version_number => p_rec.object_version_number
4389: );
4390: --
4391: if g_debug then
4392: hr_utility.set_location(l_proc, 45);
4393: end if;
4394: --
4395: hr_pdt_bus.chk_employee_number
4396: (p_employee_number => p_rec.employee_number

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

4400: ,p_object_version_number => p_rec.object_version_number
4401: );
4402: --
4403: if g_debug then
4404: hr_utility.set_location(l_proc,50 );
4405: end if;
4406: --
4407: hr_pdt_bus.chk_leaving_reason
4408: (p_leaving_reason => p_rec.leaving_reason

Line 4416: hr_utility.set_location(l_proc, 55);

4412: ,p_object_version_number => p_rec.object_version_number
4413: );
4414: --
4415: if g_debug then
4416: hr_utility.set_location(l_proc, 55);
4417: end if;
4418: --
4419: hr_pdt_bus.chk_leaving_person_type_id
4420: (p_leaving_person_type_id => p_rec.leaving_person_type_id

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

4424: ,p_object_version_number => p_rec.object_version_number
4425: );
4426: --
4427: if g_debug then
4428: hr_utility.set_location(l_proc, 60);
4429: end if;
4430: --
4431: hr_pdt_bus.chk_status
4432: (p_status => p_rec.status

Line 4439: hr_utility.set_location(l_proc,65 );

4435: ,p_object_version_number => p_rec.object_version_number
4436: );
4437: --
4438: if g_debug then
4439: hr_utility.set_location(l_proc,65 );
4440: end if;
4441: --
4442: hr_pdt_bus.chk_deplymt_policy_id
4443: (p_deplymt_policy_id => p_rec.deplymt_policy_id

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

4443: (p_deplymt_policy_id => p_rec.deplymt_policy_id
4444: );
4445: --
4446: if g_debug then
4447: hr_utility.set_location(l_proc, 70);
4448: end if;
4449: --
4450: hr_pdt_bus.chk_retain_direct_reports
4451: (p_retain_direct_reports => p_rec.retain_direct_reports

Line 4461: hr_utility.set_location(l_proc, 75);

4457: ,p_object_version_number => p_rec.object_version_number
4458: );
4459: --
4460: if g_debug then
4461: hr_utility.set_location(l_proc, 75);
4462: end if;
4463: --
4464: hr_pdt_bus.chk_organization_id
4465: (p_organization_id => p_rec.organization_id

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

4468: ,p_object_version_number => p_rec.object_version_number
4469: );
4470: --
4471: if g_debug then
4472: hr_utility.set_location(l_proc, 80);
4473: end if;
4474: --
4475: hr_pdt_bus.chk_location_id
4476: (p_location_id => p_rec.location_id

Line 4484: hr_utility.set_location(l_proc, 85);

4480: ,p_object_version_number => p_rec.object_version_number
4481: );
4482: --
4483: if g_debug then
4484: hr_utility.set_location(l_proc, 85);
4485: end if;
4486: --
4487: hr_pdt_bus.chk_job_id
4488: (p_job_id => p_rec.job_id

Line 4496: hr_utility.set_location(l_proc,90 );

4492: ,p_object_version_number => p_rec.object_version_number
4493: );
4494: --
4495: if g_debug then
4496: hr_utility.set_location(l_proc,90 );
4497: end if;
4498: --
4499: hr_pdt_bus.chk_position_id
4500: (p_position_id => p_rec.position_id

Line 4508: hr_utility.set_location(l_proc, 95);

4504: ,p_object_version_number => p_rec.object_version_number
4505: );
4506: --
4507: if g_debug then
4508: hr_utility.set_location(l_proc, 95);
4509: end if;
4510: --
4511: hr_pdt_bus.chk_grade_id
4512: (p_grade_id => p_rec.grade_id

Line 4520: hr_utility.set_location(l_proc, 100);

4516: ,p_object_version_number => p_rec.object_version_number
4517: );
4518: --
4519: if g_debug then
4520: hr_utility.set_location(l_proc, 100);
4521: end if;
4522: --
4523: hr_pdt_bus.chk_position_id_job_id
4524: (p_position_id => p_rec.position_id

Line 4532: hr_utility.set_location(l_proc, 105);

4528: ,p_object_version_number => p_rec.object_version_number
4529: );
4530: --
4531: if g_debug then
4532: hr_utility.set_location(l_proc, 105);
4533: end if;
4534: --
4535: hr_pdt_bus.chk_position_id_grade_id
4536: (p_position_id => p_rec.position_id

Line 4545: hr_utility.set_location(l_proc, 110);

4541: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
4542: );
4543: --
4544: if g_debug then
4545: hr_utility.set_location(l_proc, 110);
4546: end if;
4547: --
4548: hr_pdt_bus.chk_job_id_grade_id
4549: (p_job_id => p_rec.job_id

Line 4558: hr_utility.set_location(l_proc, 115);

4554: ,p_inv_job_grade_warning => l_inv_job_grade_warning
4555: );
4556: --
4557: if g_debug then
4558: hr_utility.set_location(l_proc, 115);
4559: end if;
4560: --
4561: hr_pdt_bus.chk_position_id_org_id
4562: (p_position_id => p_rec.position_id

Line 4570: hr_utility.set_location(l_proc, 120);

4566: ,p_object_version_number => p_rec.object_version_number
4567: );
4568: --
4569: if g_debug then
4570: hr_utility.set_location(l_proc, 120);
4571: end if;
4572: --
4573: hr_pdt_bus.chk_payroll_id
4574: (p_payroll_id => p_rec.payroll_id

Line 4582: hr_utility.set_location(l_proc, 125);

4578: ,p_object_version_number => p_rec.object_version_number
4579: );
4580: --
4581: if g_debug then
4582: hr_utility.set_location(l_proc, 125);
4583: end if;
4584: --
4585: hr_pdt_bus.chk_assignment_status_type_id
4586: (p_assignment_status_type_id => p_rec.assignment_status_type_id

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

4589: ,p_object_version_number => p_rec.object_version_number
4590: );
4591: --
4592: if g_debug then
4593: hr_utility.set_location(l_proc, 130);
4594: end if;
4595: --
4596: hr_pdt_bus.chk_supervisor_id
4597: (p_supervisor_id => p_rec.supervisor_id

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

4603: ,p_object_version_number => p_rec.object_version_number
4604: );
4605: --
4606: if g_debug then
4607: hr_utility.set_location(l_proc, 140);
4608: end if;
4609: --
4610: hr_pdt_bus.chk_supervisor_assignment_id
4611: (p_supervisor_assignment_id => p_rec.supervisor_assignment_id

Line 4619: hr_utility.set_location(l_proc, 145);

4615: ,p_object_version_number => p_rec.object_version_number
4616: );
4617: --
4618: if g_debug then
4619: hr_utility.set_location(l_proc, 145);
4620: end if;
4621: --
4622: hr_pdt_bus.chk_pay_basis_id
4623: (p_pay_basis_id => p_rec.pay_basis_id

Line 4630: hr_utility.set_location(l_proc, 150);

4626: ,p_object_version_number => p_rec.object_version_number
4627: );
4628: --
4629: if g_debug then
4630: hr_utility.set_location(l_proc, 150);
4631: end if;
4632: --
4633: hr_pdt_bus.chk_people_group_id
4634: (p_people_group_id => p_rec.people_group_id

Line 4642: hr_utility.set_location(l_proc, 155);

4638: ,p_object_version_number => p_rec.object_version_number
4639: );
4640: --
4641: if g_debug then
4642: hr_utility.set_location(l_proc, 155);
4643: end if;
4644: --
4645: hr_pdt_bus.chk_soft_coding_keyflex_id
4646: (p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id

Line 4655: hr_utility.set_location(l_proc, 160);

4651: ,p_object_version_number => p_rec.object_version_number
4652: );
4653: --
4654: if g_debug then
4655: hr_utility.set_location(l_proc, 160);
4656: end if;
4657: --
4658: hr_pdt_bus.chk_assignment_category
4659: (p_assignment_category => p_rec.assignment_category

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

4663: );
4664: --
4665: hr_pdt_bus.chk_ddf(p_rec);
4666: --
4667: hr_utility.set_location(' Leaving:'||l_proc, 10);
4668: End update_validate;
4669: --
4670: -- ----------------------------------------------------------------------------
4671: -- |---------------------------< delete_validate >----------------------------|

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

4676: --
4677: l_proc varchar2(72) := g_package||'delete_validate';
4678: --
4679: Begin
4680: hr_utility.set_location('Entering:'||l_proc, 5);
4681: --
4682: -- Call all supporting business operations
4683: --
4684: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

4680: hr_utility.set_location('Entering:'||l_proc, 5);
4681: --
4682: -- Call all supporting business operations
4683: --
4684: hr_utility.set_location(' Leaving:'||l_proc, 10);
4685: End delete_validate;
4686: --
4687: end hr_pdt_bus;