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 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.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.g_element_type_id := p_element_type_id;
147: pay_etp_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

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

184: --
185: l_proc varchar2(72) := g_package || 'chk_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.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>

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

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

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

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

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

421: ,p_attribute20_value => p_rec.attribute20
422: );
423: end if;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc,20);
426: end chk_df;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |-----------------------< chk_non_updateable_args >------------------------|

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

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

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

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

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

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

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

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

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

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

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

920: End If;
921: Close c_chk_formula_type;
922: End If;
923: --
924: hr_utility.set_location('Leaving:'||l_proc, 10);
925: End;
926: --
927: -- ----------------------------------------------------------------------------
928: -- |--------------------------< 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 2303: hr_utility.set_location('Entering:'||l_proc, 5);

2299: and nvl (legislation_code, nvl(p_legislation_code, '-1')) = nvl(p_legislation_code, '-1');
2300:
2301: Begin
2302: --
2303: hr_utility.set_location('Entering:'||l_proc, 5);
2304: If (p_time_definition_type <> hr_api.g_varchar2) AND
2305: -- The below check has been added because, we treat NULL and N as same for
2306: -- the table PAY_ELEMENT_TYPES_F for the column TIME_DEFINITION_TYPE.
2307: -- So no need to check if the value is NULL or N.

Line 2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);

2309: hr_api.not_exists_in_hr_lookups( p_effective_date
2310: ,'PAY_TIME_DEFINITION_TYPE'
2311: ,p_time_definition_type) Then
2312:
2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);
2314: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2315: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2316: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2317: fnd_message.raise_error;

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

2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');
2334: fnd_message.set_token('ARGUMENT','TIME_DEFINITION_ID');
2335: fnd_message.raise_error;
2336: END IF;
2337: hr_utility.set_location('Leaving:'||l_proc, 10);
2338: --
2339: End chk_time_definition;
2340: --
2341: -- ----------------------------------------------------------------------------

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

2390: l_d_count number;
2391: --
2392: Begin
2393: --
2394: hr_utility.set_location('Entering:'||l_proc, 5);
2395: -- Parameter Vaidation
2396: -- check if the flag is not set but the id is passed
2397: If ( p_advance_payable = 'N' OR p_advance_payable is Null) and p_advance_element_type_id is not null then
2398: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');

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

2564: end if;
2565: --
2566: end if;
2567: -- end of DELETE
2568: hr_utility.set_location('Leaving:'||l_proc, 10);
2569: --
2570: End chk_advance_element;
2571: --
2572: -- ----------------------------------------------------------------------------

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

2639: l_indirect_results boolean;
2640: l_run_results boolean;
2641: --
2642: Begin
2643: hr_utility.set_location('Entering:'||l_proc, 5);
2644: --
2645: If (
2646: (p_indirect_only_flag <> pay_etp_shd.g_old_rec.indirect_only_flag)
2647: or

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

2706: End If;
2707: --
2708: End If;
2709: --
2710: hr_utility.set_location('Leaving:'||l_proc, 10);
2711: End;
2712: --
2713: -- ----------------------------------------------------------------------------
2714: -- |------------------------< chk_delete_allowed >----------------------------|

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

2764: where accrual_plan_element_type_id = p_element_type_id;
2765: --
2766: begin
2767: --
2768: hr_utility.set_location (' ACCRUAL_PLAN_EXISTS',1);
2769: --
2770: open csr_accrual;
2771: fetch csr_accrual into l_dummy_number;
2772: l_accrual_exists := csr_accrual%found;

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

2797: and effective_end_date >= p_validation_start_date;
2798: --
2799: begin
2800: --
2801: hr_utility.set_location(' benefit_contributions_exist',1);
2802: --
2803: open csr_contribution;
2804: fetch csr_contribution into l_dummy_number;
2805: l_contribution_exists := csr_contribution%found;

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

2838: --
2839: end;
2840: --
2841: Begin
2842: hr_utility.set_location('Entering:'||l_proc, 5);
2843: --
2844: If p_datetrack_delete_mode = 'DELETE_NEXT_CHANGE' Then
2845: If pay_element_types_pkg.priority_result_rule_violated
2846: (p_element_type_id,

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

2946: --
2947: End If;
2948: End If;
2949: --
2950: hr_utility.set_location('Leaving:'||l_proc, 10);
2951: End;
2952: --
2953: -- ----------------------------------------------------------------------------
2954: -- |---------------------------< insert_validate >----------------------------|

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

2965: l_proc varchar2(72) := g_package||'insert_validate';
2966: l_processing_priority_warning boolean;
2967: --
2968: Begin
2969: hr_utility.set_location('Entering:'||l_proc, 5);
2970: --
2971: -- Call all supporting business operations
2972: --
2973: --

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

3132: pay_etp_bus.chk_ddf(p_rec);
3133: --
3134: pay_etp_bus.chk_df(p_rec);
3135: --
3136: hr_utility.set_location(' Leaving:'||l_proc, 10);
3137: End insert_validate;
3138: --
3139: -- ----------------------------------------------------------------------------
3140: -- |---------------------------< update_validate >----------------------------|

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

3151: l_proc varchar2(72) := g_package||'update_validate';
3152: l_processing_priority_warning boolean;
3153: --
3154: Begin
3155: hr_utility.set_location('Entering:'||l_proc, 5);
3156: --
3157: -- Call all supporting business operations
3158: --
3159: --

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

3334: pay_etp_bus.chk_ddf(p_rec);
3335: --
3336: pay_etp_bus.chk_df(p_rec);
3337: --
3338: hr_utility.set_location(' Leaving:'||l_proc, 10);
3339: End update_validate;
3340: --
3341: -- ----------------------------------------------------------------------------
3342: -- |---------------------------< delete_validate >----------------------------|

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

3351: --
3352: l_proc varchar2(72) := g_package||'delete_validate';
3353: --
3354: Begin
3355: hr_utility.set_location('Entering:'||l_proc, 5);
3356: --
3357: --
3358: chk_startup_action(false
3359: ,p_rec.business_group_id

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

3401: ,p_validation_end_date => p_validation_end_date
3402: ,p_element_type_id => p_rec.element_type_id
3403: );
3404: --
3405: hr_utility.set_location(' Leaving:'||l_proc, 10);
3406: End delete_validate;
3407: --
3408: end pay_etp_bus;