eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ETP_BUS_ND dependencies on HR_UTILITY

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

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

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

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

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

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

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pay_etp_bus_nd.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

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

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

145: close csr_leg_code;
146: pay_etp_bus_nd.g_element_type_id := p_element_type_id;
147: pay_etp_bus_nd.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

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

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

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

285: ); */
286: null;
287: end if;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc,20);
290: end chk_ddf;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |------------------------------< chk_df >----------------------------------|

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

323: --
324: l_proc varchar2(72) := g_package || 'chk_df';
325: --
326: begin
327: hr_utility.set_location('Entering:'||l_proc,10);
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

423: ); */
424: null;
425: end if;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc,20);
428: end chk_df;
429: --
430: -- ----------------------------------------------------------------------------
431: -- |-----------------------< chk_non_updateable_args >------------------------|

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

762: -- and p_effective_date between date_from
763: -- and nvl(date_to, hr_api.g_eot);
764: --
765: Begin
766: hr_utility.set_location('Entering:'||l_proc, 5);
767: --
768: Open c_chk_bg_id;
769: Fetch c_chk_bg_id into l_exists;
770: If c_chk_bg_id%notfound Then

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

777: --
778: End If;
779: Close c_chk_bg_id;
780: --
781: hr_utility.set_location('Leaving:'||l_proc, 10);
782: End;
783: --
784: -- ----------------------------------------------------------------------------
785: -- |------------------------< chk_legislation_code >--------------------------|

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

802: from fnd_territories
803: where territory_code = p_legislation_code;
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
807: --
808: If p_legislation_code is not null then
809:
810: Open c_chk_leg_code;

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

821: Close c_chk_leg_code;
822:
823: End If;
824: --
825: hr_utility.set_location('Leaving:'||l_proc, 10);
826: End;
827: --
828: -- ----------------------------------------------------------------------------
829: -- |--------------------------< chk_formula_id >------------------------------|

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

883: and ftp.formula_type_id = fml.formula_type_id
884: and upper(ftp.formula_type_name) = 'ELEMENT SKIP';
885: --
886: Begin
887: hr_utility.set_location('Entering:'||l_proc, 5);
888: --
889: If p_formula_id is not null Then
890: If not (dt_api.rows_exist
891: (p_base_table_name => 'FF_FORMULAS_F'

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

922: End If;
923: Close c_chk_formula_type;
924: End If;
925: --
926: hr_utility.set_location('Leaving:'||l_proc, 10);
927: End;
928: --
929: -- ----------------------------------------------------------------------------
930: -- |--------------------------< chk_currency_codes >--------------------------|

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

998: (p_business_group_id)
999: and rule_type = 'DC';
1000: --
1001: Begin
1002: hr_utility.set_location('Entering:'||l_proc, 5);
1003: --
1004: Open c_non_payments;
1005: Fetch c_non_payments into l_non_payments_flag;
1006: Close c_non_payments;

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

1067: Close c_leg_rule_currency;
1068: --
1069: End If;
1070: --
1071: hr_utility.set_location('Leaving:'||l_proc, 10);
1072: End;
1073: --
1074: -- ----------------------------------------------------------------------------
1075: -- |------------------------< chk_classification_id >-------------------------|

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

1121: where classification_id = p_classification_id
1122: and nvl(balance_initialization_flag,'N') = 'Y';
1123: --
1124: Begin
1125: hr_utility.set_location('Entering:'||l_proc, 5);
1126: --
1127: Open c_get_class_bal_init;
1128: Fetch c_get_class_bal_init into l_exists;
1129: If c_get_class_bal_init%found then

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

1140: End If;
1141: End If;
1142: Close c_get_class_bal_init;
1143: --
1144: hr_utility.set_location('Leaving:'||l_proc, 10);
1145: End;
1146: --
1147: -- ----------------------------------------------------------------------------
1148: -- |------------------------< chk_addl_entry_allowed >------------------------|

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

1181: --
1182: l_proc varchar2(72) := g_package||'chk_addl_entry_alld';
1183: --
1184: Begin
1185: hr_utility.set_location('Entering:'||l_proc, 5);
1186: --
1187: If hr_api.not_exists_in_hr_lookups
1188: (p_effective_date
1189: ,'YES_NO'

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

1202: fnd_message.raise_error;
1203: --
1204: End If;
1205: --
1206: hr_utility.set_location('Leaving:'||l_proc, 10);
1207: End;
1208: --
1209: -- ----------------------------------------------------------------------------
1210: -- |------------------------< chk_adjustment_only_flag >----------------------|

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

1248: --
1249: l_proc varchar2(72) := g_package||'chk_adj_only_flag';
1250: --
1251: Begin
1252: hr_utility.set_location('Entering:'||l_proc, 5);
1253: --
1254: If hr_api.not_exists_in_hr_lookups
1255: (p_effective_date
1256: ,'YES_NO'

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

1295: fnd_message.raise_error;
1296: --
1297: End If;
1298: --
1299: hr_utility.set_location('Leaving:'||l_proc, 10);
1300: End;
1301: --
1302: -- ----------------------------------------------------------------------------
1303: -- |------------------------< chk_element_name >------------------------------|

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

1342: l_checkformat_error boolean;
1343: l_unformatted_value varchar2(255) := p_element_name;
1344: --
1345: Begin
1346: hr_utility.set_location('Entering:'||l_proc, 5);
1347: --
1348: If p_element_name is not null and
1349: pay_element_types_pkg.name_is_not_unique
1350: (p_element_name => p_element_name

Line 1372: when hr_utility.hr_error then

1368: 'N',
1369: l_dummy,
1370: null);
1371: Exception
1372: when hr_utility.hr_error then
1373: l_checkformat_error := True;
1374: End;
1375: If (l_checkformat_error) then
1376: --

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

1378: fnd_message.raise_error;
1379: --
1380: End If;
1381: --
1382: hr_utility.set_location('Leaving:'||l_proc, 10);
1383: End;
1384: --
1385: -- ----------------------------------------------------------------------------
1386: -- |---------------------< chk_multiple_entries_allowed >---------------------|

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

1439: where benefit_classification_id = p_benefit_classification_id
1440: and cobra_flag = 'Y';
1441: --
1442: Begin
1443: hr_utility.set_location('Entering:'||l_proc, 5);
1444: --
1445: If hr_api.not_exists_in_hr_lookups
1446: (p_effective_date
1447: ,'YES_NO'

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

1487: --
1488: End If;
1489: End If;
1490: --
1491: hr_utility.set_location('Leaving:'||l_proc, 10);
1492: End;
1493: --
1494: -- ----------------------------------------------------------------------------
1495: -- |---------------------< chk_process_in_run_flag >--------------------------|

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

1536: --
1537: l_proc varchar2(72) := g_package||'chk_proc_in_run';
1538: --
1539: Begin
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: If hr_api.not_exists_in_hr_lookups
1543: (p_effective_date
1544: ,'YES_NO'

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

1608: fnd_message.raise_error;
1609: --
1610: End If;
1611: --
1612: hr_utility.set_location('Leaving:'||l_proc, 10);
1613: End;
1614: --
1615: -- ----------------------------------------------------------------------------
1616: -- |---------------------< chk_processing_priority >--------------------------|

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

1665: from pay_element_classifications
1666: where classification_id = p_classification_id;
1667: --
1668: Begin
1669: hr_utility.set_location('Entering:'||l_proc, 5);
1670: --
1671: Open c_get_ele_class_priority;
1672: Fetch c_get_ele_class_priority into l_high_priority, l_low_priority;
1673: Close c_get_ele_class_priority;

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

1690: --
1691: End If;
1692: End If;
1693: --
1694: hr_utility.set_location('Leaving:'||l_proc, 10);
1695: End;
1696: --
1697: -- ----------------------------------------------------------------------------
1698: -- |---------------------< chk_processing_type >------------------------------|

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

1731: --
1732: l_proc varchar2(72) := g_package||'chk_processing_type';
1733: --
1734: Begin
1735: hr_utility.set_location('Entering:'||l_proc, 5);
1736: --
1737: If hr_api.not_exists_in_hr_lookups
1738: (p_effective_date
1739: ,'PROCESSING_TYPE'

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

1752: fnd_message.raise_error;
1753: --
1754: End If;
1755: --
1756: hr_utility.set_location('Leaving:'||l_proc, 10);
1757: End;
1758: --
1759: -- ----------------------------------------------------------------------------
1760: -- |-----------------------< chk_standard_link_flag >-------------------------|

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

1795: --
1796: l_proc varchar2(72) := g_package||'chk_standard_link';
1797: --
1798: Begin
1799: hr_utility.set_location('Entering:'||l_proc, 5);
1800: --
1801: If hr_api.not_exists_in_hr_lookups
1802: (p_effective_date
1803: ,'YES_NO'

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

1822: fnd_message.raise_error;
1823: --
1824: End If;
1825: --
1826: hr_utility.set_location('Leaving:'||l_proc, 10);
1827: End;
1828: --
1829: -- ----------------------------------------------------------------------------
1830: -- |-----------------------< chk_qualifying_factors >-------------------------|

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

1869: --
1870: l_proc varchar2(72) := g_package||'chk_qual_factors';
1871: --
1872: Begin
1873: hr_utility.set_location('Entering:'||l_proc, 5);
1874: --
1875: If nvl(p_qualifying_age,hr_api.g_number) <> hr_api.g_number Then
1876: If (sign(p_qualifying_age) = -1) or (p_qualifying_age not between 0 and 99)
1877: then

Line 1914: hr_utility.set_location('Leaving:'||l_proc, 5);

1910: --
1911: End If;
1912: End If;
1913: --
1914: hr_utility.set_location('Leaving:'||l_proc, 5);
1915: End;
1916: --
1917: -- ----------------------------------------------------------------------------
1918: -- |----------------------< chk_third_party_pay_only_flag >-------------------|

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

1955: l_proc varchar2(72) := g_package||'chk_third_party_pay';
1956: l_exists varchar2(1);
1957: --
1958: Begin
1959: hr_utility.set_location('Entering:'||l_proc, 5);
1960: --
1961: If hr_api.not_exists_in_hr_lookups
1962: (p_effective_date
1963: ,'YES_NO'

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

1983: --
1984: End If;
1985: End If;
1986: --
1987: hr_utility.set_location('Leaving:'||l_proc, 10);
1988: End;
1989: --
1990: -- ----------------------------------------------------------------------------
1991: -- |------------------------< chk_iterative_rules >---------------------------|

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

2044: and fml.effective_end_date
2045: and ftp.formula_type_id = fml.formula_type_id;
2046: --
2047: Begin
2048: hr_utility.set_location('Entering:'||l_proc, 5);
2049: --
2050: If nvl(p_iterative_formula_id,hr_api.g_number) <> hr_api.g_number Then
2051: If not (dt_api.rows_exist
2052: (p_base_table_name => 'FF_FORMULAS_F'

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

2128: fnd_message.raise_error;
2129: --
2130: End If;
2131: --
2132: hr_utility.set_location('Leaving:'||l_proc, 10);
2133: End;
2134: --
2135: -- ----------------------------------------------------------------------------
2136: -- |------------------------< chk_proration_values >--------------------------|

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

2165: from pay_event_groups
2166: where event_group_id = p_event_group_id;
2167: --
2168: Begin
2169: hr_utility.set_location('Entering:'||l_proc, 5);
2170: --
2171: If nvl(p_retro_summ_ele_id,hr_api.g_number) <> hr_api.g_number Then
2172: If not (dt_api.rows_exist
2173: (p_base_table_name => 'PAY_ELEMENT_TYPES_F'

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

2247: Close c_chk_event_group_id;
2248: --
2249: End If;
2250: --
2251: hr_utility.set_location('Leaving:'||l_proc, 10);
2252: End;
2253: --
2254: -- ----------------------------------------------------------------------------
2255: -- |------------------------< chk_time_definition>----------------------------|

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

2281: where time_definition_id = p_time_definition_id;
2282:
2283: Begin
2284: --
2285: hr_utility.set_location('Entering:'||l_proc, 5);
2286: open csr_time_definition;
2287: fetch csr_time_definition into l_flag;
2288: If (csr_time_definition%notfound) then
2289: close csr_time_definition;

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

2292: fnd_message.set_token('TABLE','PAY_TIME_DEFINITIONS');
2293: fnd_message.raise_error;
2294: end if;
2295: close csr_time_definition;
2296: hr_utility.set_location('Leaving:'||l_proc, 10);
2297: --
2298: End chk_time_definition;
2299: --
2300: -- ----------------------------------------------------------------------------

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

2322: l_proc varchar2(72) := g_package||'chk_time_definition_type';
2323: --
2324: Begin
2325: --
2326: hr_utility.set_location('Entering:'||l_proc, 5);
2327: /* If hr_api.not_exists_in_hr_lookups
2328: (p_effective_date
2329: ,'PAY_TIME_DEFINITION_TYPE'
2330: ,p_time_definition_type) Then

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

2334: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2335: fnd_message.raise_error;
2336: --
2337: End If; */
2338: hr_utility.set_location('Leaving:'||l_proc, 10);
2339: --
2340: End chk_time_definition_type;
2341: --
2342: -- ----------------------------------------------------------------------------

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

2409: l_indirect_results boolean;
2410: l_run_results boolean;
2411: --
2412: Begin
2413: hr_utility.set_location('Entering:'||l_proc, 5);
2414: --
2415: If (
2416: (p_indirect_only_flag <> pay_etp_shd_nd.g_old_rec.indirect_only_flag)
2417: or

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

2476: End If;
2477: --
2478: End If;
2479: --
2480: hr_utility.set_location('Leaving:'||l_proc, 10);
2481: End;
2482: --
2483: -- ----------------------------------------------------------------------------
2484: -- |------------------------< chk_delete_allowed >----------------------------|

Line 2538: hr_utility.set_location (' ACCRUAL_PLAN_EXISTS',1);

2534: where accrual_plan_element_type_id = p_element_type_id;
2535: --
2536: begin
2537: --
2538: hr_utility.set_location (' ACCRUAL_PLAN_EXISTS',1);
2539: --
2540: open csr_accrual;
2541: fetch csr_accrual into l_dummy_number;
2542: l_accrual_exists := csr_accrual%found;

Line 2571: hr_utility.set_location(' benefit_contributions_exist',1);

2567: and effective_end_date >= p_validation_start_date;
2568: --
2569: begin
2570: --
2571: hr_utility.set_location(' benefit_contributions_exist',1);
2572: --
2573: open csr_contribution;
2574: fetch csr_contribution into l_dummy_number;
2575: l_contribution_exists := csr_contribution%found;

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

2608: --
2609: end;
2610: --
2611: Begin
2612: hr_utility.set_location('Entering:'||l_proc, 5);
2613: --
2614: If p_datetrack_delete_mode = 'DELETE_NEXT_CHANGE' Then
2615: If pay_element_types_pkg.priority_result_rule_violated
2616: (p_element_type_id,

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

2716: --
2717: End If;
2718: End If;
2719: --
2720: hr_utility.set_location('Leaving:'||l_proc, 10);
2721: End;
2722: --
2723: -- ----------------------------------------------------------------------------
2724: -- |---------------------------< insert_validate >----------------------------|

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

2735: l_proc varchar2(72) := g_package||'insert_validate';
2736: l_processing_priority_warning boolean;
2737: --
2738: Begin
2739: hr_utility.set_location('Entering:'||l_proc, 5);
2740: --
2741: -- Call all supporting business operations
2742: --
2743: --

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

2891: pay_etp_bus_nd.chk_ddf(p_rec);
2892: --
2893: pay_etp_bus_nd.chk_df(p_rec);
2894: --
2895: hr_utility.set_location(' Leaving:'||l_proc, 10);
2896: End insert_validate;
2897: --
2898: -- ----------------------------------------------------------------------------
2899: -- |---------------------------< update_validate >----------------------------|

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

2910: l_proc varchar2(72) := g_package||'update_validate';
2911: l_processing_priority_warning boolean;
2912: --
2913: Begin
2914: hr_utility.set_location('Entering:'||l_proc, 5);
2915: --
2916: -- Call all supporting business operations
2917: --
2918: --

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

3082: pay_etp_bus_nd.chk_ddf(p_rec);
3083: --
3084: pay_etp_bus_nd.chk_df(p_rec);
3085: --
3086: hr_utility.set_location(' Leaving:'||l_proc, 10);
3087: End update_validate;
3088: --
3089: -- ----------------------------------------------------------------------------
3090: -- |---------------------------< delete_validate >----------------------------|

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

3099: --
3100: l_proc varchar2(72) := g_package||'delete_validate';
3101: --
3102: Begin
3103: hr_utility.set_location('Entering:'||l_proc, 5);
3104: --
3105: --
3106: chk_startup_action(false
3107: ,p_rec.business_group_id

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

3135: ,p_validation_end_date => p_validation_end_date
3136: ,p_element_type_id => p_rec.element_type_id
3137: );
3138: --
3139: hr_utility.set_location(' Leaving:'||l_proc, 10);
3140: End delete_validate;
3141: --
3142: end pay_etp_bus_nd;