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 3349: hr_utility.set_location('Entering:'||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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