DBA Data[Home] [Help]

APPS.PAY_OPM_BUS dependencies on HR_UTILITY

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

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

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := pay_opm_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: pay_opm_bus.g_org_payment_method_id:= p_org_payment_method_id;
142: pay_opm_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

179: --
180: l_proc varchar2(72) := g_package || 'chk_ddf';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or

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

278: ,p_attribute20_value => p_rec.pmeth_information20
279: );
280: end if;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc,20);
283: end chk_ddf;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |------------------------------< chk_df >----------------------------------|

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

316: --
317: l_proc varchar2(72) := g_package || 'chk_df';
318: --
319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

415: ,p_attribute20_value => p_rec.attribute20
416: );
417: end if;
418: --
419: hr_utility.set_location(' Leaving:'||l_proc,20);
420: end chk_df;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |-----------------------< chk_non_updateable_args >------------------------|

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

456: l_argument varchar2(30);
457: --
458: Begin
459: --
460: hr_utility.set_location(l_proc, 5);
461: --
462: -- Only proceed with the validation if a row exists for the current
463: -- record in the HR Schema.
464: --

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

472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: hr_utility.set_location(l_proc, 10);
477: --
478: if nvl(p_rec.business_group_id, hr_api.g_number) <>
479: pay_opm_shd.g_old_rec.business_group_id then
480: l_argument := 'business_group_id';

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

480: l_argument := 'business_group_id';
481: raise l_error;
482: end if;
483: --
484: hr_utility.set_location(l_proc, 20);
485: --
486: if nvl(p_rec.payment_type_id, hr_api.g_number) <>
487: pay_opm_shd.g_old_rec.payment_type_id then
488: l_argument := 'payment_type_id';

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

488: l_argument := 'payment_type_id';
489: raise l_error;
490: end if;
491: --
492: hr_utility.set_location(l_proc, 30);
493: --
494: if nvl(p_rec.defined_balance_id, hr_api.g_number) <>
495: nvl(pay_opm_shd.g_old_rec.defined_balance_id, hr_api.g_number) then
496: l_argument := 'defined_balance_id';

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

496: l_argument := 'defined_balance_id';
497: raise l_error;
498: end if;
499: --
500: hr_utility.set_location(l_proc, 35);
501: --
502: if nvl(p_rec.org_payment_method_name, hr_api.g_varchar2) <>
503: nvl(pay_opm_shd.g_old_rec.org_payment_method_name, hr_api.g_varchar2) then
504: l_argument := 'org_payment_method_name';

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

504: l_argument := 'org_payment_method_name';
505: raise l_error;
506: end if;
507: --
508: hr_utility.set_location(l_proc, 40);
509: --
510: EXCEPTION
511: WHEN l_error THEN
512: hr_api.argument_changed_error

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

828: and p_effective_date between pop.effective_start_date and pop.effective_end_date
829: and pop.business_group_id = p_business_group_id;
830: --
831: Begin
832: hr_utility.set_location('Entering:'||l_proc, 5);
833: --
834: -- Check mandatory external_account_id exists
835: --
836: --

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

871: p_org_payment_method_id => p_org_payment_method_id,
872: p_object_version_number => p_object_version_number
873: );
874: --
875: hr_utility.set_location(l_proc,10);
876: --
877: -- Only proceed with SQL validation if absolutely necessary
878: --
879: if ((l_api_updating and

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

880: nvl(pay_opm_shd.g_old_rec.external_account_id,hr_api.g_number) <>
881: nvl(p_external_account_id,hr_api.g_number))
882: or (NOT l_api_updating)) then
883: --
884: hr_utility.set_location(l_proc,20);
885: --
886: -- Check external_account_id exists within PAY_EXTERNAL_ACCOUNTS.
887: -- Also it check the territory_code of the PAY_EXTERNAL_ACCOUNTS.
888: --

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

893: pay_opm_shd.constraint_error('PAY_ORG_PAYMENT_METHODS_F_FK2');
894: end if;
895: close csr_ext_acc_id_exists;
896: --
897: hr_utility.set_location(l_proc,30);
898: --
899: end if;
900: --
901: --

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

898: --
899: end if;
900: --
901: --
902: hr_utility.set_location(' Leaving:'||l_proc, 100);
903: End chk_external_account_id;
904: --
905: -- ----------------------------------------------------------------------------
906: -- |-------------------------< chk_currency_code >----------------------------|

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

959: and pty.currency_code = p_currency_code)));
960: --
961: --
962: Begin
963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: -- Check mandatory currency_code exists
966: --
967: hr_api.mandatory_arg_error

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

987: p_org_payment_method_id => p_org_payment_method_id,
988: p_object_version_number => p_object_version_number
989: );
990: --
991: hr_utility.set_location(l_proc,10);
992: --
993: -- Only proceed with SQL validation if absolutely necessary
994: --
995: if ((l_api_updating and

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

996: nvl(pay_opm_shd.g_old_rec.currency_code,hr_api.g_varchar2) <>
997: nvl(p_currency_code,hr_api.g_varchar2))
998: or (NOT l_api_updating)) then
999: --
1000: hr_utility.set_location(l_proc,20);
1001: --
1002: -- Check currency_code exists within FND_CURRENCIES_VL.
1003: -- Also checks whether Paymen Type's
1004: --

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

1012: fnd_message.raise_error;
1013: end if;
1014: close csr_currency_code_exists;
1015: --
1016: hr_utility.set_location(l_proc,30);
1017: --
1018: end if;
1019: --
1020: --

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

1017: --
1018: end if;
1019: --
1020: --
1021: hr_utility.set_location(' Leaving:'||l_proc, 100);
1022: End chk_currency_code;
1023: --
1024: -- ----------------------------------------------------------------------------
1025: -- |------------------------< chk_payment_type_id >---------------------------|

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

1079: and pyt2.payment_type_id <> pyt.payment_type_id);
1080: --
1081: --
1082: Begin
1083: hr_utility.set_location('Entering:'||l_proc, 5);
1084: --
1085: -- Check mandatory payment_type_id exists
1086: --
1087: hr_api.mandatory_arg_error

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

1096: ,p_argument_value => p_business_group_id
1097: );
1098: --
1099: --
1100: hr_utility.set_location(l_proc,10);
1101: --
1102: -- Only proceed with SQL validation if absolutely necessary
1103: --
1104: if (p_org_payment_method_id is null) then

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

1102: -- Only proceed with SQL validation if absolutely necessary
1103: --
1104: if (p_org_payment_method_id is null) then
1105: --
1106: hr_utility.set_location(l_proc,20);
1107: --
1108: -- Check payment_type_id is a valid entry within PAY_PAYMENT_TYPES.
1109: --
1110: open csr_pay_type_id_exists;

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

1117: fnd_message.raise_error;
1118: end if;
1119: close csr_pay_type_id_exists;
1120: --
1121: hr_utility.set_location(l_proc,30);
1122: --
1123: end if;
1124: --
1125: --

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

1122: --
1123: end if;
1124: --
1125: --
1126: hr_utility.set_location(' Leaving:'||l_proc, 100);
1127: End chk_payment_type_id;
1128: --
1129: -- ----------------------------------------------------------------------------
1130: -- |----------------------< chk_defined_balance_id >--------------------------|

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

1180: order by db.business_group_id,db.legislation_code;
1181: --
1182: --
1183: Begin
1184: hr_utility.set_location('Entering:'||l_proc, 5);
1185: --
1186: -- Check mandatory defined_balance_id exists
1187: --
1188: -- hr_api.mandatory_arg_error

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

1197: ,p_argument_value => p_business_group_id
1198: );
1199: --
1200: --
1201: hr_utility.set_location(l_proc,10);
1202: --
1203: -- Only proceed with SQL validation if absolutely necessary
1204: --
1205: if (p_org_payment_method_id is null and p_defined_balance_id is not null) then

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

1203: -- Only proceed with SQL validation if absolutely necessary
1204: --
1205: if (p_org_payment_method_id is null and p_defined_balance_id is not null) then
1206: --
1207: hr_utility.set_location(l_proc,20);
1208: --
1209: -- Check payment_type_id is a valid entry within PAY_DEFINED_BALANCES.
1210: --
1211: open csr_def_bal_id_exists;

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

1218: fnd_message.raise_error;
1219: end if;
1220: close csr_def_bal_id_exists;
1221: --
1222: hr_utility.set_location(l_proc,30);
1223: --
1224: end if;
1225: --
1226: --

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

1223: --
1224: end if;
1225: --
1226: --
1227: hr_utility.set_location(' Leaving:'||l_proc, 100);
1228: End chk_defined_balance_id;
1229: --
1230: -- ----------------------------------------------------------------------------
1231: -- |--------------------< chk_org_payment_method_name >-----------------------|

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

1271: and opm.business_group_id = p_business_group_id;
1272: --
1273: --
1274: Begin
1275: hr_utility.set_location('Entering:'||l_proc, 5);
1276: --
1277: -- Check mandatory org_payment_method_name exists
1278: --
1279: hr_api.mandatory_arg_error

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

1287: ,p_argument => 'business_group_id'
1288: ,p_argument_value => p_business_group_id
1289: );
1290: --
1291: hr_utility.set_location(l_proc,10);
1292: --
1293: -- Only proceed with SQL validation if absolutely necessary
1294: --
1295: if (p_org_payment_method_id is null) then

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

1293: -- Only proceed with SQL validation if absolutely necessary
1294: --
1295: if (p_org_payment_method_id is null) then
1296: --
1297: hr_utility.set_location(l_proc,20);
1298: --
1299: --
1300: open csr_org_pay_meth_name_exists;
1301: fetch csr_org_pay_meth_name_exists into l_dummy;

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

1307: fnd_message.raise_error;
1308: end if;
1309: close csr_org_pay_meth_name_exists;
1310: --
1311: hr_utility.set_location(l_proc,30);
1312: --
1313: end if;
1314: --
1315: --

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

1312: --
1313: end if;
1314: --
1315: --
1316: hr_utility.set_location(' Leaving:'||l_proc, 100);
1317: End chk_org_payment_method_name;
1318: --
1319: -- ----------------------------------------------------------------------------
1320: -- |--------------------------< chk_pre_payment >-----------------------------|

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

1362: and ppa.effective_date >= p_validation_start_date;
1363: --
1364: --
1365: Begin
1366: hr_utility.set_location('Entering:'||l_proc, 5);
1367: --
1368: --
1369: hr_api.mandatory_arg_error
1370: (p_api_name => l_proc

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

1371: ,p_argument => 'validation_start_date'
1372: ,p_argument_value => p_validation_start_date
1373: );
1374: --
1375: hr_utility.set_location(l_proc,10);
1376: --
1377: --
1378: --
1379: --

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

1389: --
1390: --
1391: --
1392: --
1393: hr_utility.set_location(' Leaving:'||l_proc, 100);
1394: End chk_pre_payment;
1395: -- ----------------------------------------------------------------------------
1396: -- |---------------------< chk_costing_enabled >------------------------------|
1397: -- ----------------------------------------------------------------------------

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

1423: and lfi.field_name = 'COSTING_TAB'
1424: and lfi.target_location = 'PAYWSDPM'
1425: and lfi.legislation_code = l_legislation_code;
1426: begin
1427: hr_utility.set_location(l_proc,10);
1428: --
1429: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
1430: --
1431: open csr_chk_leg_field_info;

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

1749: where ppa.default_payment_method_id = p_org_payment_method_id
1750: and ppa.business_group_id = p_business_group_id;
1751: --
1752: begin
1753: hr_utility.set_location('Entering:'||l_proc, 1);
1754: --
1755: -- Ensure that the p_datetrack_mode argument is not null
1756: --
1757: hr_api.mandatory_arg_error

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

1796: End If;
1797: --
1798: close csr_pre_payment_exists;
1799: --
1800: hr_utility.set_location(l_proc, 10);
1801: --
1802: --
1803: open csr_org_pay_methods_tl_exists;
1804: --

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

1815: End If;
1816: --
1817: close csr_org_pay_methods_tl_exists;
1818: --
1819: hr_utility.set_location(l_proc, 20);
1820: --
1821: --
1822: open csr_payroll_actions_exists;
1823: --

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

1834: End If;
1835: --
1836: close csr_payroll_actions_exists;
1837: --
1838: hr_utility.set_location(l_proc, 30);
1839: --
1840: --
1841: End If;
1842: --

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

1860: End If;
1861: --
1862: close csr_payrolls_exists;
1863: --
1864: hr_utility.set_location(l_proc, 35);
1865: --
1866: --Bug No. 4644827
1867: If ( pay_maintain_bank_acct.chk_account_exists(
1868: p_org_payment_method_id =>p_org_payment_method_id,

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

1874: fnd_message.raise_error;
1875: --
1876: End If;
1877: --
1878: hr_utility.set_location(' Leaving:'||l_proc, 40);
1879: --
1880: end chk_delete;
1881: --
1882: -- ----------------------------------------------------------------------------

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

1892: --
1893: l_proc varchar2(72) := g_package||'insert_validate';
1894: --
1895: Begin
1896: hr_utility.set_location('Entering:'||l_proc, 5);
1897: --
1898: -- Call all supporting business operations
1899: --
1900: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1898: -- Call all supporting business operations
1899: --
1900: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1901: --
1902: hr_utility.set_location(l_proc,10);
1903: --
1904: pay_opm_bus.chk_external_account_id(p_external_account_id => p_rec.external_account_id
1905: ,p_payment_type_id => p_rec.payment_type_id
1906: ,p_business_group_id => p_rec.business_group_id

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

1907: ,p_effective_date => p_effective_date
1908: ,p_org_payment_method_id => p_rec.org_payment_method_id
1909: ,p_object_version_number => p_rec.object_version_number);
1910: --
1911: hr_utility.set_location(l_proc,15);
1912: --
1913: pay_opm_bus.chk_currency_code(p_currency_code => p_rec.currency_code
1914: ,p_payment_type_id => p_rec.payment_type_id
1915: ,p_effective_date => p_effective_date

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

1915: ,p_effective_date => p_effective_date
1916: ,p_org_payment_method_id => p_rec.org_payment_method_id
1917: ,p_object_version_number => p_rec.object_version_number);
1918: --
1919: hr_utility.set_location(l_proc,20);
1920: --
1921: pay_opm_bus.chk_payment_type_id(p_payment_type_id => p_rec.payment_type_id
1922: ,p_business_group_id => p_rec.business_group_id
1923: ,p_org_payment_method_id => p_rec.org_payment_method_id);

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

1921: pay_opm_bus.chk_payment_type_id(p_payment_type_id => p_rec.payment_type_id
1922: ,p_business_group_id => p_rec.business_group_id
1923: ,p_org_payment_method_id => p_rec.org_payment_method_id);
1924: --
1925: hr_utility.set_location(l_proc,25);
1926: --
1927: pay_opm_bus.chk_defined_balance_id(p_defined_balance_id => p_rec.defined_balance_id
1928: ,p_business_group_id => p_rec.business_group_id
1929: ,p_org_payment_method_id => p_rec.org_payment_method_id);

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

1927: pay_opm_bus.chk_defined_balance_id(p_defined_balance_id => p_rec.defined_balance_id
1928: ,p_business_group_id => p_rec.business_group_id
1929: ,p_org_payment_method_id => p_rec.org_payment_method_id);
1930: --
1931: hr_utility.set_location(l_proc,30);
1932: --
1933: pay_opm_bus.chk_org_payment_method_name(p_org_payment_method_name => p_rec.org_payment_method_name
1934: ,p_business_group_id => p_rec.business_group_id
1935: ,p_org_payment_method_id => p_rec.org_payment_method_id);

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

1933: pay_opm_bus.chk_org_payment_method_name(p_org_payment_method_name => p_rec.org_payment_method_name
1934: ,p_business_group_id => p_rec.business_group_id
1935: ,p_org_payment_method_id => p_rec.org_payment_method_id);
1936: --
1937: hr_utility.set_location(l_proc,35);
1938: --
1939: pay_opm_bus.chk_costing_enabled(p_business_group_id => p_rec.business_group_id
1940: ,p_transfer_to_gl_flag => p_rec.transfer_to_gl_flag
1941: ,p_cost_payment => p_rec.cost_payment

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

1942: ,p_cost_cleared_payment => p_rec.cost_cleared_payment
1943: ,p_cost_cleared_void_payment => p_rec.cost_cleared_void_payment
1944: ,p_exclude_manual_payment => p_rec.exclude_manual_payment);
1945: --
1946: hr_utility.set_location(l_proc,40);
1947: --
1948: pay_opm_bus.chk_cost_payment(p_effective_date => p_effective_date
1949: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
1950: --

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

1947: --
1948: pay_opm_bus.chk_cost_payment(p_effective_date => p_effective_date
1949: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
1950: --
1951: hr_utility.set_location(l_proc,45);
1952: --
1953: pay_opm_bus.chk_cost_cleared_payment(p_effective_date => p_effective_date
1954: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment, 'N')
1955: ,p_cost_payment => NVL(p_rec.cost_payment,'N'));

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

1953: pay_opm_bus.chk_cost_cleared_payment(p_effective_date => p_effective_date
1954: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment, 'N')
1955: ,p_cost_payment => NVL(p_rec.cost_payment,'N'));
1956: --
1957: hr_utility.set_location(l_proc,50);
1958: --
1959: pay_opm_bus.chk_cost_cleared_void_payment(p_effective_date => p_effective_date
1960: ,p_cost_cleared_void_payment => NVL(p_rec.cost_cleared_void_payment, 'N')
1961: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment,'N'));

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

1959: pay_opm_bus.chk_cost_cleared_void_payment(p_effective_date => p_effective_date
1960: ,p_cost_cleared_void_payment => NVL(p_rec.cost_cleared_void_payment, 'N')
1961: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment,'N'));
1962: --
1963: hr_utility.set_location(l_proc,55);
1964: --
1965: pay_opm_bus.chk_exclude_manual_payment(p_effective_date => p_effective_date
1966: ,p_exclude_manual_payment => NVL(p_rec.exclude_manual_payment, 'N')
1967: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));

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

1965: pay_opm_bus.chk_exclude_manual_payment(p_effective_date => p_effective_date
1966: ,p_exclude_manual_payment => NVL(p_rec.exclude_manual_payment, 'N')
1967: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
1968: --
1969: hr_utility.set_location(l_proc,60);
1970: --
1971: pay_opm_bus.chk_transfer_to_gl_flag(p_effective_date => p_effective_date
1972: ,p_transfer_to_gl_flag => NVL(p_rec.transfer_to_gl_flag,'N')
1973: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));

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

1973: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
1974: --
1975: pay_opm_bus.chk_ddf(p_rec);
1976: --
1977: hr_utility.set_location(l_proc,70);
1978: --
1979: pay_opm_bus.chk_df(p_rec);
1980: --
1981: hr_utility.set_location(l_proc,75);

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

1977: hr_utility.set_location(l_proc,70);
1978: --
1979: pay_opm_bus.chk_df(p_rec);
1980: --
1981: hr_utility.set_location(l_proc,75);
1982: --
1983: hr_utility.set_location(' Leaving:'||l_proc, 100);
1984: End insert_validate;
1985: --

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

1979: pay_opm_bus.chk_df(p_rec);
1980: --
1981: hr_utility.set_location(l_proc,75);
1982: --
1983: hr_utility.set_location(' Leaving:'||l_proc, 100);
1984: End insert_validate;
1985: --
1986: -- ----------------------------------------------------------------------------
1987: -- |---------------------------< update_validate >----------------------------|

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

1996: --
1997: l_proc varchar2(72) := g_package||'update_validate';
1998: --
1999: Begin
2000: hr_utility.set_location('Entering:'||l_proc, 5);
2001: --
2002: -- Call all supporting business operations
2003: --
2004: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

2016: ,p_rec => p_rec
2017: );
2018: --
2019: --
2020: hr_utility.set_location(l_proc,10);
2021: --
2022: pay_opm_bus.chk_external_account_id(p_external_account_id => p_rec.external_account_id
2023: ,p_payment_type_id => p_rec.payment_type_id
2024: ,p_business_group_id => p_rec.business_group_id

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

2025: ,p_effective_date => p_effective_date
2026: ,p_org_payment_method_id => p_rec.org_payment_method_id
2027: ,p_object_version_number => p_rec.object_version_number);
2028: --
2029: hr_utility.set_location(l_proc,15);
2030: --
2031: pay_opm_bus.chk_currency_code(p_currency_code => p_rec.currency_code
2032: ,p_payment_type_id => p_rec.payment_type_id
2033: ,p_effective_date => p_effective_date

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

2033: ,p_effective_date => p_effective_date
2034: ,p_org_payment_method_id => p_rec.org_payment_method_id
2035: ,p_object_version_number => p_rec.object_version_number);
2036: --
2037: hr_utility.set_location(l_proc,20);
2038: --
2039: pay_opm_bus.chk_pre_payment(p_validation_start_date => p_validation_start_date
2040: ,p_org_payment_method_id => p_rec.org_payment_method_id);
2041: --

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

2039: pay_opm_bus.chk_pre_payment(p_validation_start_date => p_validation_start_date
2040: ,p_org_payment_method_id => p_rec.org_payment_method_id);
2041: --
2042: --
2043: hr_utility.set_location(l_proc,25);
2044: --
2045: pay_opm_bus.chk_costing_enabled(p_business_group_id => p_rec.business_group_id
2046: ,p_transfer_to_gl_flag => p_rec.transfer_to_gl_flag
2047: ,p_cost_payment => p_rec.cost_payment

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

2048: ,p_cost_cleared_payment => p_rec.cost_cleared_payment
2049: ,p_cost_cleared_void_payment => p_rec.cost_cleared_void_payment
2050: ,p_exclude_manual_payment => p_rec.exclude_manual_payment);
2051: --
2052: hr_utility.set_location(l_proc,30);
2053: --
2054: pay_opm_bus.chk_cost_payment(p_effective_date => p_effective_date
2055: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
2056: --

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

2053: --
2054: pay_opm_bus.chk_cost_payment(p_effective_date => p_effective_date
2055: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
2056: --
2057: hr_utility.set_location(l_proc,45);
2058: --
2059: pay_opm_bus.chk_cost_cleared_payment(p_effective_date => p_effective_date
2060: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment, 'N')
2061: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));

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

2059: pay_opm_bus.chk_cost_cleared_payment(p_effective_date => p_effective_date
2060: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment, 'N')
2061: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
2062: --
2063: hr_utility.set_location(l_proc,50);
2064: --
2065: pay_opm_bus.chk_cost_cleared_void_payment(p_effective_date => p_effective_date
2066: ,p_cost_cleared_void_payment => NVL(p_rec.cost_cleared_void_payment, 'N')
2067: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment, 'N'));

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

2065: pay_opm_bus.chk_cost_cleared_void_payment(p_effective_date => p_effective_date
2066: ,p_cost_cleared_void_payment => NVL(p_rec.cost_cleared_void_payment, 'N')
2067: ,p_cost_cleared_payment => NVL(p_rec.cost_cleared_payment, 'N'));
2068: --
2069: hr_utility.set_location(l_proc,55);
2070: --
2071: pay_opm_bus.chk_exclude_manual_payment(p_effective_date => p_effective_date
2072: ,p_exclude_manual_payment => NVL(p_rec.exclude_manual_payment, 'N')
2073: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));

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

2071: pay_opm_bus.chk_exclude_manual_payment(p_effective_date => p_effective_date
2072: ,p_exclude_manual_payment => NVL(p_rec.exclude_manual_payment, 'N')
2073: ,p_cost_payment => NVL(p_rec.cost_payment, 'N'));
2074: --
2075: hr_utility.set_location(l_proc,60);
2076: --
2077: pay_opm_bus.chk_transfer_to_gl_flag(p_effective_date => p_effective_date
2078: ,p_transfer_to_gl_flag => NVL(p_rec.transfer_to_gl_flag, 'N')
2079: ,p_cost_payment => NVL(p_rec.cost_payment,'N'));

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

2077: pay_opm_bus.chk_transfer_to_gl_flag(p_effective_date => p_effective_date
2078: ,p_transfer_to_gl_flag => NVL(p_rec.transfer_to_gl_flag, 'N')
2079: ,p_cost_payment => NVL(p_rec.cost_payment,'N'));
2080: --
2081: hr_utility.set_location(l_proc,65);
2082: --
2083: pay_opm_bus.chk_ddf(p_rec);
2084: --
2085: hr_utility.set_location(l_proc,70);

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

2081: hr_utility.set_location(l_proc,65);
2082: --
2083: pay_opm_bus.chk_ddf(p_rec);
2084: --
2085: hr_utility.set_location(l_proc,70);
2086: --
2087: pay_opm_bus.chk_df(p_rec);
2088: --
2089: hr_utility.set_location(' Leaving:'||l_proc, 100);

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

2085: hr_utility.set_location(l_proc,70);
2086: --
2087: pay_opm_bus.chk_df(p_rec);
2088: --
2089: hr_utility.set_location(' Leaving:'||l_proc, 100);
2090: End update_validate;
2091: --
2092: -- ----------------------------------------------------------------------------
2093: -- |---------------------------< delete_validate >----------------------------|

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

2102: --
2103: l_proc varchar2(72) := g_package||'delete_validate';
2104: --
2105: Begin
2106: hr_utility.set_location('Entering:'||l_proc, 5);
2107: --
2108: -- Call all supporting business operations
2109: --
2110: dt_delete_validate

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

2123: --
2124: pay_opm_bus.chk_pre_payment(p_validation_start_date => p_validation_start_date
2125: ,p_org_payment_method_id => p_rec.org_payment_method_id);
2126: --
2127: hr_utility.set_location(l_proc,30);
2128: --
2129: hr_utility.set_location(' Leaving:'||l_proc, 10);
2130: End delete_validate;
2131: --

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

2125: ,p_org_payment_method_id => p_rec.org_payment_method_id);
2126: --
2127: hr_utility.set_location(l_proc,30);
2128: --
2129: hr_utility.set_location(' Leaving:'||l_proc, 10);
2130: End delete_validate;
2131: --
2132: end pay_opm_bus;