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_US_RSRW_UPGREV dependencies on HR_UTILITY

Line 88: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');

84: l_old_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
85: l_new_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
86:
87: BEGIN
88: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
89: hr_utility.trace('Passed Parameter p_ele_name := ' || p_ele_name);
90: hr_utility.trace('Passed Parameter p_mode := ' || p_mode);
91:
92: -- Modification of Fast Formula Text of Regular_Salary

Line 89: hr_utility.trace('Passed Parameter p_ele_name := ' || p_ele_name);

85: l_new_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
86:
87: BEGIN
88: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
89: hr_utility.trace('Passed Parameter p_ele_name := ' || p_ele_name);
90: hr_utility.trace('Passed Parameter p_mode := ' || p_mode);
91:
92: -- Modification of Fast Formula Text of Regular_Salary
93:

Line 90: hr_utility.trace('Passed Parameter p_mode := ' || p_mode);

86:
87: BEGIN
88: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
89: hr_utility.trace('Passed Parameter p_ele_name := ' || p_ele_name);
90: hr_utility.trace('Passed Parameter p_mode := ' || p_mode);
91:
92: -- Modification of Fast Formula Text of Regular_Salary
93:
94: IF p_ele_name = 'Regular Salary' THEN

Line 96: hr_utility.trace('Modifying Formula ' || l_formula_name);

92: -- Modification of Fast Formula Text of Regular_Salary
93:
94: IF p_ele_name = 'Regular Salary' THEN
95: l_formula_name := 'REGULAR_SALARY';
96: hr_utility.trace('Modifying Formula ' || l_formula_name);
97:
98: open c_formula_id(l_formula_name);
99: fetch c_formula_id into l_formula_id ;
100: close c_formula_id;

Line 102: hr_utility.trace('l_formula_id := ' || l_formula_id);

98: open c_formula_id(l_formula_name);
99: fetch c_formula_id into l_formula_id ;
100: close c_formula_id;
101:
102: hr_utility.trace('l_formula_id := ' || l_formula_id);
103:
104: l_old_formula_text := NULL;
105: l_new_formula_text := NULL;
106:

Line 1095: hr_utility.trace('Modifying Formula ' || l_formula_name);

1091:
1092: ELSIF p_ele_name = 'Regular Wages' THEN
1093: l_formula_name := 'REGULAR_WAGES';
1094:
1095: hr_utility.trace('Modifying Formula ' || l_formula_name);
1096:
1097: open c_formula_id(l_formula_name);
1098: fetch c_formula_id into l_formula_id ;
1099: close c_formula_id;

Line 1101: hr_utility.trace('l_formula_id := ' || l_formula_id);

1097: open c_formula_id(l_formula_name);
1098: fetch c_formula_id into l_formula_id ;
1099: close c_formula_id;
1100:
1101: hr_utility.trace('l_formula_id := ' || l_formula_id);
1102:
1103: l_old_formula_text := NULL;
1104: l_new_formula_text := NULL;
1105:

Line 2035: hr_utility.trace('Updating Formula Text in Mode := ' || p_mode);

2031: END IF; -- Regular Salary / Regular Wages
2032:
2033: IF p_mode = 'NEW' THEN
2034:
2035: hr_utility.trace('Updating Formula Text in Mode := ' || p_mode);
2036:
2037: BEGIN
2038: update ff_formulas_f
2039: set formula_text = l_new_formula_text

Line 2044: hr_utility.trace('Formula Updated.');

2040: where formula_name = l_formula_name
2041: and business_group_id IS NULL
2042: and legislation_code = 'US';
2043:
2044: hr_utility.trace('Formula Updated.');
2045: COMMIT;
2046: hr_utility.trace('Formula Update Commited!');
2047: EXCEPTION
2048: WHEN OTHERS THEN

Line 2046: hr_utility.trace('Formula Update Commited!');

2042: and legislation_code = 'US';
2043:
2044: hr_utility.trace('Formula Updated.');
2045: COMMIT;
2046: hr_utility.trace('Formula Update Commited!');
2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2050: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

Line 2049: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));

2045: COMMIT;
2046: hr_utility.trace('Formula Update Commited!');
2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2050: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2051: END;
2052:
2053: ELSIF p_mode = 'OLD' THEN

Line 2050: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2046: hr_utility.trace('Formula Update Commited!');
2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2050: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2051: END;
2052:
2053: ELSIF p_mode = 'OLD' THEN
2054:

Line 2055: hr_utility.trace('Updating Formula Text in Mode := ' || p_mode);

2051: END;
2052:
2053: ELSIF p_mode = 'OLD' THEN
2054:
2055: hr_utility.trace('Updating Formula Text in Mode := ' || p_mode);
2056: BEGIN
2057: update ff_formulas_f
2058: set formula_text = l_old_formula_text
2059: where formula_name = l_formula_name

Line 2062: hr_utility.trace('Formula Updated.');

2058: set formula_text = l_old_formula_text
2059: where formula_name = l_formula_name
2060: and business_group_id IS NULL
2061: and legislation_code = 'US';
2062: hr_utility.trace('Formula Updated.');
2063: COMMIT;
2064: hr_utility.trace('Formula Update Commited!');
2065: EXCEPTION
2066: WHEN OTHERS THEN

Line 2064: hr_utility.trace('Formula Update Commited!');

2060: and business_group_id IS NULL
2061: and legislation_code = 'US';
2062: hr_utility.trace('Formula Updated.');
2063: COMMIT;
2064: hr_utility.trace('Formula Update Commited!');
2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2068: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

Line 2067: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));

2063: COMMIT;
2064: hr_utility.trace('Formula Update Commited!');
2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2068: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2069: END;
2070:
2071: END IF;

Line 2068: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2064: hr_utility.trace('Formula Update Commited!');
2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2068: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2069: END;
2070:
2071: END IF;
2072:

Line 2086: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');

2082: delete
2083: from ff_fdi_usages_f
2084: where formula_id = l_formula_id;
2085:
2086: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');
2087:
2088: END modify_formula_text;
2089:
2090: /*****************************************************************************

Line 2127: hr_utility.trace('Entering into create_proration_group.');

2123:
2124: ln_index NUMBER;
2125:
2126: BEGIN
2127: hr_utility.trace('Entering into create_proration_group.');
2128: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2129:
2130: IF col_name_tbl.count() > 0 THEN
2131: col_name_tbl.delete;

Line 2128: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());

2124: ln_index NUMBER;
2125:
2126: BEGIN
2127: hr_utility.trace('Entering into create_proration_group.');
2128: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2129:
2130: IF col_name_tbl.count() > 0 THEN
2131: col_name_tbl.delete;
2132: END IF;

Line 2134: hr_utility.trace('Before Event Group Creation.');

2130: IF col_name_tbl.count() > 0 THEN
2131: col_name_tbl.delete;
2132: END IF;
2133:
2134: hr_utility.trace('Before Event Group Creation.');
2135: pay_event_groups_api.create_event_group(FALSE
2136: ,fnd_date.canonical_to_date('0001/01/01')
2137: ,'Proration Group for Regular Salary'
2138: ,'P'

Line 2146: hr_utility.trace('After Event Group Creation.');

2142: ,ln_event_group_id
2143: ,ln_event_grp_ovn
2144: ,NULL);
2145:
2146: hr_utility.trace('After Event Group Creation.');
2147:
2148: OPEN get_dated_table_id(801, 'PAY_ELEMENT_ENTRIES_F');
2149: FETCH get_dated_table_id INTO ln_eef_dt_tbl_id;
2150: CLOSE get_dated_table_id;

Line 2151: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);

2147:
2148: OPEN get_dated_table_id(801, 'PAY_ELEMENT_ENTRIES_F');
2149: FETCH get_dated_table_id INTO ln_eef_dt_tbl_id;
2150: CLOSE get_dated_table_id;
2151: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);
2152:
2153: ln_index := 1;
2154: col_name_tbl(ln_index) := 'EFFECTIVE_START_DATE';
2155: ln_index := ln_index + 1;

Line 2162: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());

2158: col_name_tbl(ln_index) := 'ELEMENT_TYPE_ID';
2159: ln_index := ln_index + 1;
2160: col_name_tbl(ln_index) := 'EFFECTIVE_END_DATE';
2161:
2162: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2163: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRIES_F.');
2164:
2165: FOR i IN 1..col_name_tbl.count()
2166: LOOP

Line 2163: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRIES_F.');

2159: ln_index := ln_index + 1;
2160: col_name_tbl(ln_index) := 'EFFECTIVE_END_DATE';
2161:
2162: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2163: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRIES_F.');
2164:
2165: FOR i IN 1..col_name_tbl.count()
2166: LOOP
2167: hr_utility.trace('Within create_datetracked_event i := ' || i);

Line 2167: hr_utility.trace('Within create_datetracked_event i := ' || i);

2163: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRIES_F.');
2164:
2165: FOR i IN 1..col_name_tbl.count()
2166: LOOP
2167: hr_utility.trace('Within create_datetracked_event i := ' || i);
2168: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2169: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);
2170: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2171:

Line 2168: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);

2164:
2165: FOR i IN 1..col_name_tbl.count()
2166: LOOP
2167: hr_utility.trace('Within create_datetracked_event i := ' || i);
2168: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2169: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);
2170: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2171:
2172: pay_datetracked_events_api.create_datetracked_event(FALSE

Line 2169: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);

2165: FOR i IN 1..col_name_tbl.count()
2166: LOOP
2167: hr_utility.trace('Within create_datetracked_event i := ' || i);
2168: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2169: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);
2170: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2171:
2172: pay_datetracked_events_api.create_datetracked_event(FALSE
2173: ,fnd_date.canonical_to_date('0001/01/01')

Line 2170: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));

2166: LOOP
2167: hr_utility.trace('Within create_datetracked_event i := ' || i);
2168: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2169: hr_utility.trace('ln_eef_dt_tbl_id := ' || ln_eef_dt_tbl_id);
2170: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2171:
2172: pay_datetracked_events_api.create_datetracked_event(FALSE
2173: ,fnd_date.canonical_to_date('0001/01/01')
2174: ,ln_event_group_id

Line 2184: hr_utility.trace('After Creating Date-Tracked Events for PAY_ELEMENT_ENTRIES_F.');

2180: ,NULL
2181: ,ln_eef_dt_event_id
2182: ,ln_eef_dt_ovn);
2183: END LOOP;
2184: hr_utility.trace('After Creating Date-Tracked Events for PAY_ELEMENT_ENTRIES_F.');
2185:
2186: OPEN get_dated_table_id(801, 'PAY_ELEMENT_ENTRY_VALUES_F');
2187: FETCH get_dated_table_id INTO ln_eevf_dt_tbl_id;
2188: CLOSE get_dated_table_id;

Line 2190: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);

2186: OPEN get_dated_table_id(801, 'PAY_ELEMENT_ENTRY_VALUES_F');
2187: FETCH get_dated_table_id INTO ln_eevf_dt_tbl_id;
2188: CLOSE get_dated_table_id;
2189:
2190: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);
2191:
2192: col_name_tbl.delete;
2193: ln_index := 1;
2194: col_name_tbl(ln_index) := 'ELEMENT_ENTRY_VALUE_ID';

Line 2206: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());

2202: col_name_tbl(ln_index) := 'EFFECTIVE_START_DATE';
2203: ln_index := ln_index + 1;
2204: col_name_tbl(ln_index) := 'INPUT_VALUE_ID';
2205:
2206: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2207: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRY_VALUES_F.');
2208:
2209: FOR i IN 1..col_name_tbl.count()
2210: LOOP

Line 2207: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRY_VALUES_F.');

2203: ln_index := ln_index + 1;
2204: col_name_tbl(ln_index) := 'INPUT_VALUE_ID';
2205:
2206: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2207: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRY_VALUES_F.');
2208:
2209: FOR i IN 1..col_name_tbl.count()
2210: LOOP
2211: hr_utility.trace('Within create_datetracked_event i := ' || i);

Line 2211: hr_utility.trace('Within create_datetracked_event i := ' || i);

2207: hr_utility.trace('Before Creating Date-Tracked Events for PAY_ELEMENT_ENTRY_VALUES_F.');
2208:
2209: FOR i IN 1..col_name_tbl.count()
2210: LOOP
2211: hr_utility.trace('Within create_datetracked_event i := ' || i);
2212: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2213: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);
2214: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2215:

Line 2212: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);

2208:
2209: FOR i IN 1..col_name_tbl.count()
2210: LOOP
2211: hr_utility.trace('Within create_datetracked_event i := ' || i);
2212: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2213: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);
2214: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2215:
2216: pay_datetracked_events_api.create_datetracked_event(FALSE

Line 2213: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);

2209: FOR i IN 1..col_name_tbl.count()
2210: LOOP
2211: hr_utility.trace('Within create_datetracked_event i := ' || i);
2212: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2213: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);
2214: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2215:
2216: pay_datetracked_events_api.create_datetracked_event(FALSE
2217: ,fnd_date.canonical_to_date('0001/01/01')

Line 2214: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));

2210: LOOP
2211: hr_utility.trace('Within create_datetracked_event i := ' || i);
2212: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2213: hr_utility.trace('ln_eevf_dt_tbl_id := ' || ln_eevf_dt_tbl_id);
2214: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2215:
2216: pay_datetracked_events_api.create_datetracked_event(FALSE
2217: ,fnd_date.canonical_to_date('0001/01/01')
2218: ,ln_event_group_id

Line 2229: hr_utility.trace('After Creating Date-Tracked Events for PAY_ELEMENT_ENTRY_VALUES_F.');

2225: ,ln_eevf_dt_event_id
2226: ,ln_eevf_dt_ovn);
2227: END LOOP;
2228:
2229: hr_utility.trace('After Creating Date-Tracked Events for PAY_ELEMENT_ENTRY_VALUES_F.');
2230:
2231: OPEN get_dated_table_id(800, 'PER_ALL_ASSIGNMENTS_F');
2232: FETCH get_dated_table_id INTO ln_paaf_dt_tbl_id;
2233: CLOSE get_dated_table_id;

Line 2235: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);

2231: OPEN get_dated_table_id(800, 'PER_ALL_ASSIGNMENTS_F');
2232: FETCH get_dated_table_id INTO ln_paaf_dt_tbl_id;
2233: CLOSE get_dated_table_id;
2234:
2235: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2236: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F');
2237:
2238: col_name_tbl.delete;
2239: ln_index := 1;

Line 2236: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F');

2232: FETCH get_dated_table_id INTO ln_paaf_dt_tbl_id;
2233: CLOSE get_dated_table_id;
2234:
2235: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2236: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F');
2237:
2238: col_name_tbl.delete;
2239: ln_index := 1;
2240: col_name_tbl(ln_index) := 'PAY_BASIS_ID';

Line 2250: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());

2246: col_name_tbl(ln_index) := 'NORMAL_HOURS';
2247: ln_index := ln_index + 1;
2248: col_name_tbl(ln_index) := 'ASSIGNMENT_STATUS_TYPE_ID';
2249:
2250: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2251: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');
2252:
2253: FOR i IN 1..col_name_tbl.count()
2254: LOOP

Line 2251: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');

2247: ln_index := ln_index + 1;
2248: col_name_tbl(ln_index) := 'ASSIGNMENT_STATUS_TYPE_ID';
2249:
2250: hr_utility.trace('col_name_tbl.count() := ' || col_name_tbl.count());
2251: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');
2252:
2253: FOR i IN 1..col_name_tbl.count()
2254: LOOP
2255: hr_utility.trace('Within create_datetracked_event i := ' || i);

Line 2255: hr_utility.trace('Within create_datetracked_event i := ' || i);

2251: hr_utility.trace('Before Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');
2252:
2253: FOR i IN 1..col_name_tbl.count()
2254: LOOP
2255: hr_utility.trace('Within create_datetracked_event i := ' || i);
2256: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2257: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2258: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2259:

Line 2256: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);

2252:
2253: FOR i IN 1..col_name_tbl.count()
2254: LOOP
2255: hr_utility.trace('Within create_datetracked_event i := ' || i);
2256: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2257: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2258: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2259:
2260: pay_datetracked_events_api.create_datetracked_event(FALSE

Line 2257: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);

2253: FOR i IN 1..col_name_tbl.count()
2254: LOOP
2255: hr_utility.trace('Within create_datetracked_event i := ' || i);
2256: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2257: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2258: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2259:
2260: pay_datetracked_events_api.create_datetracked_event(FALSE
2261: ,fnd_date.canonical_to_date('0001/01/01')

Line 2258: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));

2254: LOOP
2255: hr_utility.trace('Within create_datetracked_event i := ' || i);
2256: hr_utility.trace('ln_event_group_id := ' || ln_event_group_id);
2257: hr_utility.trace('ln_paaf_dt_tbl_id := ' || ln_paaf_dt_tbl_id);
2258: hr_utility.trace('col_name_tbl(i) := ' || col_name_tbl(i));
2259:
2260: pay_datetracked_events_api.create_datetracked_event(FALSE
2261: ,fnd_date.canonical_to_date('0001/01/01')
2262: ,ln_event_group_id

Line 2272: hr_utility.trace('After Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');

2268: ,NULL
2269: ,ln_paaf_dt_event_id
2270: ,ln_paaf_dt_ovn);
2271: END LOOP;
2272: hr_utility.trace('After Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');
2273: COMMIT;
2274: hr_utility.trace('Returning ln_event_group_id := ' || ln_event_group_id);
2275: RETURN ln_event_group_id;
2276:

Line 2274: hr_utility.trace('Returning ln_event_group_id := ' || ln_event_group_id);

2270: ,ln_paaf_dt_ovn);
2271: END LOOP;
2272: hr_utility.trace('After Creating Date-Tracked Events for PER_ALL_ASSIGNMENTS_F.');
2273: COMMIT;
2274: hr_utility.trace('Returning ln_event_group_id := ' || ln_event_group_id);
2275: RETURN ln_event_group_id;
2276:
2277: END create_proration_group;
2278:

Line 2302: hr_utility.trace('Entered into pay_us_rsrw_upgrev.delete_proration_group');

2298: ln_obj_ver_num pay_event_groups.object_version_number%TYPE;
2299:
2300: BEGIN
2301:
2302: hr_utility.trace('Entered into pay_us_rsrw_upgrev.delete_proration_group');
2303:
2304: open get_proration_event_grp('Proration Group for Regular Salary');
2305: fetch get_proration_event_grp into ln_event_grp_id, ln_obj_ver_num;
2306: close get_proration_event_grp;

Line 2308: hr_utility.trace('ln_event_grp_id := ' || ln_event_grp_id);

2304: open get_proration_event_grp('Proration Group for Regular Salary');
2305: fetch get_proration_event_grp into ln_event_grp_id, ln_obj_ver_num;
2306: close get_proration_event_grp;
2307:
2308: hr_utility.trace('ln_event_grp_id := ' || ln_event_grp_id);
2309: hr_utility.trace('ln_obj_ver_num := ' || ln_obj_ver_num);
2310:
2311: delete from pay_datetracked_events
2312: where event_group_id = ln_event_grp_id;

Line 2309: hr_utility.trace('ln_obj_ver_num := ' || ln_obj_ver_num);

2305: fetch get_proration_event_grp into ln_event_grp_id, ln_obj_ver_num;
2306: close get_proration_event_grp;
2307:
2308: hr_utility.trace('ln_event_grp_id := ' || ln_event_grp_id);
2309: hr_utility.trace('ln_obj_ver_num := ' || ln_obj_ver_num);
2310:
2311: delete from pay_datetracked_events
2312: where event_group_id = ln_event_grp_id;
2313:

Line 2378: --hr_utility.trace_on(NULL, 'Oracle');

2374: ln_dbg_step number;
2375:
2376: begin
2377:
2378: --hr_utility.trace_on(NULL, 'Oracle');
2379:
2380: /*
2381: * Initialization Code
2382: */

Line 2390: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_regular_salary');

2386: /*
2387: * Initial Trace
2388: */
2389:
2390: hr_utility.trace('Entering ' || gv_package_name || '.upgrade_regular_salary');
2391:
2392: /*
2393: * Legislation Level Migration
2394: */

Line 2397: hr_utility.trace('Date of Migration ' || l_date_of_mig);

2393: * Legislation Level Migration
2394: */
2395:
2396: l_date_of_mig := fnd_date.canonical_to_date(trunc(sysdate));
2397: hr_utility.trace('Date of Migration ' || l_date_of_mig);
2398:
2399: /*
2400: * STEP 1
2401: */

Line 2411: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);

2407: open get_ele_typ_id('Regular Wages');
2408: fetch get_ele_typ_id into ln_rw_ele_typ_id, lv_rw_ele_name, ln_rw_proration_grp_id;
2409: close get_ele_typ_id;
2410:
2411: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2412: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2413: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2414: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2415:

Line 2412: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);

2408: fetch get_ele_typ_id into ln_rw_ele_typ_id, lv_rw_ele_name, ln_rw_proration_grp_id;
2409: close get_ele_typ_id;
2410:
2411: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2412: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2413: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2414: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2415:
2416: lv_upg_status := NULL;

Line 2413: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);

2409: close get_ele_typ_id;
2410:
2411: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2412: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2413: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2414: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2415:
2416: lv_upg_status := NULL;
2417:

Line 2414: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);

2410:
2411: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2412: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2413: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2414: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2415:
2416: lv_upg_status := NULL;
2417:
2418: open get_upg_status;

Line 2422: hr_utility.trace('lv_upg_status := ' || lv_upg_status);

2418: open get_upg_status;
2419: fetch get_upg_status into lv_upg_status;
2420: close get_upg_status;
2421:
2422: hr_utility.trace('lv_upg_status := ' || lv_upg_status);
2423:
2424: IF nvl(lv_upg_status, 'N') <> 'C' THEN
2425: /*
2426: * STEP 2

Line 2440: hr_utility.trace('ln_proration_event_grp_id := ' || ln_proration_event_grp_id);

2436:
2437: ln_proration_event_grp_id := create_proration_group();
2438: commit;
2439:
2440: hr_utility.trace('ln_proration_event_grp_id := ' || ln_proration_event_grp_id);
2441:
2442: /* Update Proration Group */
2443:
2444: BEGIN

Line 2508: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));

2504: ,'US' from sys.dual;
2505:
2506: EXCEPTION
2507: WHEN OTHERS THEN
2508: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2509: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2510: END;
2511: COMMIT;
2512: hr_utility.trace('Insertion Commited!');

Line 2509: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2505:
2506: EXCEPTION
2507: WHEN OTHERS THEN
2508: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2509: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2510: END;
2511: COMMIT;
2512: hr_utility.trace('Insertion Commited!');
2513:

Line 2512: hr_utility.trace('Insertion Commited!');

2508: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2509: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2510: END;
2511: COMMIT;
2512: hr_utility.trace('Insertion Commited!');
2513:
2514: ELSIF nvl(lv_upg_status, 'N') = 'C'
2515: AND (ln_rs_proration_grp_id IS NULL OR ln_rw_proration_grp_id IS NULL) THEN
2516:

Line 2530: hr_utility.trace('ln_proration_event_grp_id := ' || ln_proration_event_grp_id);

2526: COMMIT;
2527: END IF;
2528: CLOSE get_proration_event_grp;
2529:
2530: hr_utility.trace('ln_proration_event_grp_id := ' || ln_proration_event_grp_id);
2531:
2532: /* Update Proration Group */
2533:
2534: BEGIN

Line 2548: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));

2544: AND element_information1 = 'REG';
2545:
2546: EXCEPTION
2547: WHEN OTHERS THEN
2548: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2549: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2550: END;
2551: COMMIT;
2552: hr_utility.trace('Update of proration group Commited!');

Line 2549: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2545:
2546: EXCEPTION
2547: WHEN OTHERS THEN
2548: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2549: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2550: END;
2551: COMMIT;
2552: hr_utility.trace('Update of proration group Commited!');
2553:

Line 2552: hr_utility.trace('Update of proration group Commited!');

2548: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2549: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2550: END;
2551: COMMIT;
2552: hr_utility.trace('Update of proration group Commited!');
2553:
2554: ELSE
2555: fnd_file.put_line(FND_FILE.LOG,'Elements ''Regular Salary'' and ''Regular Wages'' have already been upgraded for Legislation ''US''.');
2556: hr_utility.trace('Elements ''Regular Salary'' and ''Regular Wages'' have already been upgraded for Legislation ''US''.');

Line 2556: hr_utility.trace('Elements ''Regular Salary'' and ''Regular Wages'' have already been upgraded for Legislation ''US''.');

2552: hr_utility.trace('Update of proration group Commited!');
2553:
2554: ELSE
2555: fnd_file.put_line(FND_FILE.LOG,'Elements ''Regular Salary'' and ''Regular Wages'' have already been upgraded for Legislation ''US''.');
2556: hr_utility.trace('Elements ''Regular Salary'' and ''Regular Wages'' have already been upgraded for Legislation ''US''.');
2557: END IF;
2558:
2559: fnd_file.put_line(FND_FILE.LOG, 'Regular Salary and Regular Wages have been successfully upgraded for ''US''.');
2560:

Line 2561: hr_utility.trace('Leaving ' || gv_package_name || '.upgrade_reg_salarywages');

2557: END IF;
2558:
2559: fnd_file.put_line(FND_FILE.LOG, 'Regular Salary and Regular Wages have been successfully upgraded for ''US''.');
2560:
2561: hr_utility.trace('Leaving ' || gv_package_name || '.upgrade_reg_salarywages');
2562:
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_file.put_line(FND_FILE.LOG, '''Regular Salary''/''Regular Wages'' Element upgradation failed for Legislation ''US''.');

Line 2566: hr_utility.raise_error;

2562:
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_file.put_line(FND_FILE.LOG, '''Regular Salary''/''Regular Wages'' Element upgradation failed for Legislation ''US''.');
2566: hr_utility.raise_error;
2567: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2568: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2569: end upgrade_reg_salarywages;
2570:

Line 2567: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));

2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_file.put_line(FND_FILE.LOG, '''Regular Salary''/''Regular Wages'' Element upgradation failed for Legislation ''US''.');
2566: hr_utility.raise_error;
2567: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2568: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2569: end upgrade_reg_salarywages;
2570:
2571: /*****************************************************************************

Line 2568: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2564: WHEN OTHERS THEN
2565: fnd_file.put_line(FND_FILE.LOG, '''Regular Salary''/''Regular Wages'' Element upgradation failed for Legislation ''US''.');
2566: hr_utility.raise_error;
2567: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2568: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2569: end upgrade_reg_salarywages;
2570:
2571: /*****************************************************************************
2572: Name : revert_upg_reg_salarywages

Line 2629: hr_utility.trace('Entering ' || gv_package_name || '.revert_upg_reg_salary');

2625:
2626: /*
2627: * Initial Trace
2628: */
2629: hr_utility.trace('Entering ' || gv_package_name || '.revert_upg_reg_salary');
2630:
2631: /*
2632: * Legislation Level Migration
2633: */

Line 2636: hr_utility.trace('Date of Migration ' || l_date_of_mig);

2632: * Legislation Level Migration
2633: */
2634:
2635: l_date_of_mig := fnd_date.canonical_to_date(trunc(sysdate));
2636: hr_utility.trace('Date of Migration ' || l_date_of_mig);
2637:
2638: /*
2639: * STEP 1
2640: */

Line 2650: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);

2646: open get_ele_typ_id('Regular Wages');
2647: fetch get_ele_typ_id into ln_rw_ele_typ_id, lv_rw_ele_name, ln_rw_proration_grp_id;
2648: close get_ele_typ_id;
2649:
2650: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2651: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2652: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2653: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2654:

Line 2651: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);

2647: fetch get_ele_typ_id into ln_rw_ele_typ_id, lv_rw_ele_name, ln_rw_proration_grp_id;
2648: close get_ele_typ_id;
2649:
2650: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2651: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2652: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2653: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2654:
2655: lv_upg_status := NULL;

Line 2652: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);

2648: close get_ele_typ_id;
2649:
2650: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2651: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2652: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2653: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2654:
2655: lv_upg_status := NULL;
2656:

Line 2653: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);

2649:
2650: hr_utility.trace('ln_rs_ele_typ_id := ' || ln_rs_ele_typ_id);
2651: hr_utility.trace('ln_rs_proration_grp_id := ' || ln_rs_proration_grp_id);
2652: hr_utility.trace('ln_rw_ele_typ_id := ' || ln_rw_ele_typ_id);
2653: hr_utility.trace('ln_rw_proration_grp_id := ' || ln_rw_proration_grp_id);
2654:
2655: lv_upg_status := NULL;
2656:
2657: open get_upg_status;

Line 2661: hr_utility.trace('lv_upg_status := ' || lv_upg_status);

2657: open get_upg_status;
2658: fetch get_upg_status into lv_upg_status, ln_upg_defn_id;
2659: close get_upg_status;
2660:
2661: hr_utility.trace('lv_upg_status := ' || lv_upg_status);
2662: hr_utility.trace('ln_upg_defn_id := ' || ln_upg_defn_id);
2663:
2664: IF nvl(lv_upg_status, 'N') = 'C' THEN
2665: /*

Line 2662: hr_utility.trace('ln_upg_defn_id := ' || ln_upg_defn_id);

2658: fetch get_upg_status into lv_upg_status, ln_upg_defn_id;
2659: close get_upg_status;
2660:
2661: hr_utility.trace('lv_upg_status := ' || lv_upg_status);
2662: hr_utility.trace('ln_upg_defn_id := ' || ln_upg_defn_id);
2663:
2664: IF nvl(lv_upg_status, 'N') = 'C' THEN
2665: /*
2666: * STEP 2

Line 2698: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));

2694:
2695:
2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2699: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2700: END;
2701:
2702: COMMIT;

Line 2699: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2695:
2696: EXCEPTION
2697: WHEN OTHERS THEN
2698: hr_utility.trace('Error Occured in Step = ' || ln_dbg_step || ', ' || 'SQLCODE := ' || TO_CHAR(SQLCODE));
2699: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2700: END;
2701:
2702: COMMIT;
2703: hr_utility.trace('Update/Delete Commited!');

Line 2703: hr_utility.trace('Update/Delete Commited!');

2699: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2700: END;
2701:
2702: COMMIT;
2703: hr_utility.trace('Update/Delete Commited!');
2704:
2705: ELSE
2706: fnd_file.put_line(FND_FILE.LOG, 'Elements Regular Salary and Regular Wages have not been upgraded for Legislation ''US''.');
2707: hr_utility.trace('Elements Regular Salary and Regular Wages have not been upgraded for Legislation ''US''.');

Line 2707: hr_utility.trace('Elements Regular Salary and Regular Wages have not been upgraded for Legislation ''US''.');

2703: hr_utility.trace('Update/Delete Commited!');
2704:
2705: ELSE
2706: fnd_file.put_line(FND_FILE.LOG, 'Elements Regular Salary and Regular Wages have not been upgraded for Legislation ''US''.');
2707: hr_utility.trace('Elements Regular Salary and Regular Wages have not been upgraded for Legislation ''US''.');
2708: END IF;
2709:
2710: fnd_file.put_line(FND_FILE.LOG, '''Regular Salary'' and ''Regular Wages'' has been successfully reverted back for ''US''.');
2711: hr_utility.trace('Leaving ' || gv_package_name || '.revert_upg_reg_salarywages');

Line 2711: hr_utility.trace('Leaving ' || gv_package_name || '.revert_upg_reg_salarywages');

2707: hr_utility.trace('Elements Regular Salary and Regular Wages have not been upgraded for Legislation ''US''.');
2708: END IF;
2709:
2710: fnd_file.put_line(FND_FILE.LOG, '''Regular Salary'' and ''Regular Wages'' has been successfully reverted back for ''US''.');
2711: hr_utility.trace('Leaving ' || gv_package_name || '.revert_upg_reg_salarywages');
2712:
2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: fnd_file.put_line(FND_FILE.LOG, 'Reverting back upgradation of ''Regular Salary''/''Regular Wages'' Element failed for Legislation ''US''.');

Line 2716: hr_utility.raise_error;

2712:
2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: fnd_file.put_line(FND_FILE.LOG, 'Reverting back upgradation of ''Regular Salary''/''Regular Wages'' Element failed for Legislation ''US''.');
2716: hr_utility.raise_error;
2717: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2718: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2719:
2720: END revert_upg_reg_salarywages;

Line 2717: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));

2713: EXCEPTION
2714: WHEN OTHERS THEN
2715: fnd_file.put_line(FND_FILE.LOG, 'Reverting back upgradation of ''Regular Salary''/''Regular Wages'' Element failed for Legislation ''US''.');
2716: hr_utility.raise_error;
2717: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2718: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2719:
2720: END revert_upg_reg_salarywages;
2721:

Line 2718: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));

2714: WHEN OTHERS THEN
2715: fnd_file.put_line(FND_FILE.LOG, 'Reverting back upgradation of ''Regular Salary''/''Regular Wages'' Element failed for Legislation ''US''.');
2716: hr_utility.raise_error;
2717: hr_utility.trace('SQLCODE := ' || TO_CHAR(SQLCODE));
2718: hr_utility.trace('SQLERRM := ' || SUBSTR(SQLERRM, 1, 200));
2719:
2720: END revert_upg_reg_salarywages;
2721:
2722: /*****************************************************************************

Line 2752: hr_utility.trace('Entered into pay_us_rsrw_upgrev.get_upgrade_flag');

2748: ln_upg_defn_id number;
2749:
2750: BEGIN
2751:
2752: hr_utility.trace('Entered into pay_us_rsrw_upgrev.get_upgrade_flag');
2753:
2754: lv_upg_status := NULL;
2755: ln_upg_defn_id := NULL;
2756:

Line 2761: hr_utility.trace('lv_upg_status := ' || lv_upg_status);

2757: open get_upg_status;
2758: fetch get_upg_status into lv_upg_status, ln_upg_defn_id;
2759: close get_upg_status;
2760:
2761: hr_utility.trace('lv_upg_status := ' || lv_upg_status);
2762: hr_utility.trace('ln_upg_defn_id := ' || ln_upg_defn_id);
2763:
2764: lv_upg_flag := 'N';
2765:

Line 2762: hr_utility.trace('ln_upg_defn_id := ' || ln_upg_defn_id);

2758: fetch get_upg_status into lv_upg_status, ln_upg_defn_id;
2759: close get_upg_status;
2760:
2761: hr_utility.trace('lv_upg_status := ' || lv_upg_status);
2762: hr_utility.trace('ln_upg_defn_id := ' || ln_upg_defn_id);
2763:
2764: lv_upg_flag := 'N';
2765:
2766: if NVL(lv_upg_status, 'N') = 'C' then

Line 2772: hr_utility.trace('Before returning lv_upg_flag := ' || lv_upg_flag);

2768: else
2769: lv_upg_flag := 'N';
2770: end if;
2771:
2772: hr_utility.trace('Before returning lv_upg_flag := ' || lv_upg_flag);
2773: return lv_upg_flag;
2774:
2775: END get_upgrade_flag;
2776:

Line 2829: hr_utility.trace('Entering into pay_us_rsrw_upgrev.get_payprd_per_fiscal_yr');

2825: lv_ele_xtra_info PAY_ELEMENT_TYPE_EXTRA_INFO.eei_information11%TYPE;
2826:
2827: BEGIN
2828:
2829: hr_utility.trace('Entering into pay_us_rsrw_upgrev.get_payprd_per_fiscal_yr');
2830:
2831: lv_ele_xtra_info := NULL;
2832:
2833: open csr_get_ele_xtra_info(cp_eletyp_ctx_id => p_eletyp_ctx_id);

Line 2842: hr_utility.trace('ln_period_num := ' || ln_period_num);

2838: ,ctx_payroll_id => p_ctx_payroll_id);
2839: fetch csr_get_num_prd into ln_period_num;
2840: close csr_get_num_prd;
2841:
2842: hr_utility.trace('ln_period_num := ' || ln_period_num);
2843:
2844: IF NVL(lv_ele_xtra_info, 'N') = 'N' THEN
2845: return ln_period_num;
2846: ELSE

Line 2854: hr_utility.trace('ln_max_period_num := ' || ln_max_period_num);

2850: ,period_end_date => p_period_end_date);
2851: fetch csr_get_prd_num into ln_max_period_num;
2852: close csr_get_prd_num;
2853:
2854: hr_utility.trace('ln_max_period_num := ' || ln_max_period_num);
2855:
2856: return GREATEST(ln_max_period_num, ln_period_num);
2857:
2858: END IF;

Line 2890: hr_utility.trace('lv_asg_status := ' || lv_asg_status);

2886: open csr_get_asg_status(p_ctx_asg_id, p_prorate_end_dt);
2887: fetch csr_get_asg_status into lv_asg_status;
2888: close csr_get_asg_status;
2889:
2890: hr_utility.trace('lv_asg_status := ' || lv_asg_status);
2891: return lv_asg_status;
2892:
2893: end get_assignment_status;
2894: