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.

[Home] [Help]

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on HR_UTILITY

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

124: l_proc constant VARCHAR2(80) := g_pkg || 'get_request_id';
125: l_request per_cagr_requests.cagr_request_id%type;
126:
127: BEGIN
128: hr_utility.set_location('Entering: '||l_proc,10);
129:
130: open csr_request;
131: fetch csr_request into l_request;
132: close csr_request;

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

130: open csr_request;
131: fetch csr_request into l_request;
132: close csr_request;
133:
134: hr_utility.set_location('Leaving: '||l_proc,40);
135: RETURN l_request;
136:
137: END get_request_id;
138:

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

148: l_proc constant VARCHAR2(80) := g_pkg || 'get_num_val';
149: l_return NUMBER := NULL;
150:
151: BEGIN
152: hr_utility.set_location('Entering: '||l_proc,10);
153: FOR i in p_mapping_table.first..p_mapping_table.last LOOP
154: IF p_mapping_table(i).parameter_name = p_column_name THEN
155: -- found the correct column, so return the value
156: l_return := to_number(p_mapping_table(i).value);

Line 163: hr_utility.set_location('Leaving:'||l_proc, 30);

159: END LOOP;
160: IF l_return IS NULL THEN
161: l_return := hr_api.g_number;
162: END IF;
163: hr_utility.set_location('Leaving:'||l_proc, 30);
164: RETURN l_return;
165:
166: END get_num_val;
167:

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

176: l_proc constant VARCHAR2(80) := g_pkg || 'get_char_val';
177: l_return VARCHAR2(240) := NULL;
178:
179: BEGIN
180: hr_utility.set_location('Entering: '||l_proc,10);
181: FOR i in p_mapping_table.first..p_mapping_table.last LOOP
182: IF p_mapping_table(i).parameter_name = p_column_name THEN
183: -- found the correct column, so return the value
184: l_return := p_mapping_table(i).value;

Line 191: hr_utility.set_location('Leaving: '||l_proc,30);

187: END LOOP;
188: IF l_return IS NULL THEN
189: l_return := hr_api.g_varchar2;
190: END IF;
191: hr_utility.set_location('Leaving: '||l_proc,30);
192: RETURN l_return;
193:
194: END get_char_val;
195:

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

203: -- column_name supplied, and deletes the rec.
204: l_proc constant VARCHAR2(80) := g_pkg || 'get_date_val';
205: l_return DATE := NULL;
206: BEGIN
207: hr_utility.set_location('Entering: '||l_proc,10);
208: FOR i in p_mapping_table.first..p_mapping_table.last LOOP
209: IF p_mapping_table(i).parameter_name = p_column_name THEN
210: -- found the correct column, so return the value
211: l_return := fnd_date.canonical_to_date(p_mapping_table(i).value);

Line 218: hr_utility.set_location('Leaving: '||l_proc,30);

214: END LOOP;
215: IF l_return IS NULL THEN
216: l_return := hr_api.g_date;
217: END IF;
218: hr_utility.set_location('Leaving: '||l_proc,30);
219: RETURN l_return;
220:
221: END get_date_val;
222:

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

250: l_dummy VARCHAR2(1);
251: l_proc constant VARCHAR2(80) := g_pkg || 'get_ovn_and_mode';
252:
253: BEGIN
254: hr_utility.set_location('Entering:'||l_proc, 5);
255:
256: if p_dt_flag = 'Y' then
257: l_sql := 'SELECT object_version_number, effective_start_date FROM '||p_table_name||' WHERE '||p_pk||' = :1 ';
258: l_sql := l_sql ||'AND :2 BETWEEN effective_start_date AND nvl(effective_end_date,hr_general.end_of_time)';

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

255:
256: if p_dt_flag = 'Y' then
257: l_sql := 'SELECT object_version_number, effective_start_date FROM '||p_table_name||' WHERE '||p_pk||' = :1 ';
258: l_sql := l_sql ||'AND :2 BETWEEN effective_start_date AND nvl(effective_end_date,hr_general.end_of_time)';
259: hr_utility.set_location(l_proc, 10);
260: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
261: fetch l_dyn_csr into p_ovn, l_start_date;
262: close l_dyn_csr;
263: if l_start_date is null or p_ovn is null then

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

262: close l_dyn_csr;
263: if l_start_date is null or p_ovn is null then
264: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN or START_DATE',1);
265: else
266: hr_utility.set_location(l_proc, 20);
267: p_mode := 'UPDATE'; -- default to this mode
268: if p_effective_date = l_start_date then
269: -- switch to correction if record started today
270: -- irrespective of any future changes

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

269: -- switch to correction if record started today
270: -- irrespective of any future changes
271: p_mode := 'CORRECTION';
272: else
273: hr_utility.set_location(l_proc, 30);
274: -- check for future updates
275: l_sql := 'SELECT null FROM '||p_table_name||' WHERE '||p_pk||' = :1 and :2 < effective_start_date';
276: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
277: fetch l_dyn_csr into l_dummy;

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

281: close l_dyn_csr;
282: end if;
283: end if;
284: else -- not date tracked
285: hr_utility.set_location(l_proc, 40);
286: l_sql := 'SELECT object_version_number FROM '||p_table_name||' WHERE '||p_pk||' = :1 ';
287: l_sql := l_sql || 'AND :2 BETWEEN start_date and nvl(end_date,hr_general.end_of_time)';
288: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
289: fetch l_dyn_csr into p_ovn;

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

287: l_sql := l_sql || 'AND :2 BETWEEN start_date and nvl(end_date,hr_general.end_of_time)';
288: open l_dyn_csr for l_sql using p_pk_id, p_effective_date;
289: fetch l_dyn_csr into p_ovn;
290: close l_dyn_csr;
291: hr_utility.set_location(l_proc, 50);
292: if p_ovn is null then
293: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN',1);
294: end if;
295: end if;

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

293: per_cagr_utility_pkg.put_log('ERROR: dynamic sql failed to return a value for OVN',1);
294: end if;
295: end if;
296:
297: hr_utility.set_location('Leaving:'||l_proc, 50);
298:
299: END get_ovn_and_mode;
300:
301:

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

350: l_special_ceiling_step_id NUMBER;
351: l_warn_message VARCHAR2(2000);
352:
353: BEGIN
354: hr_utility.set_location('Entering:'||l_proc, 5);
355:
356: -- build pl/sql table of all seeded api column names for the API id
357: for v_api_details in csr_api(p_ASG_results(1).cagr_api_id) loop
358: l_count := l_count+1;

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

567: -- delete pl/sql tables
568: l_api_details.delete;
569: l_mapping_table.delete;
570:
571: hr_utility.set_location('Leaving:'||l_proc, 5);
572: END call_ASG_api;
573:
574: -- ================================================================================================
575: -- == **************** CALL_PYS_API ***************** ==

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

620: l_effective_start_date DATE;
621: l_effective_end_date DATE;
622:
623: BEGIN
624: hr_utility.set_location('Entering:'||l_proc, 5);
625:
626: -- first check if we need to call update or create api
627:
628: open csr_placement_id;

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

738: l_api_details.delete;
739: l_mapping_table.delete;
740:
741:
742: hr_utility.set_location('Leaving:'||l_proc, 5);
743: END call_PYS_api;
744:
745:
746: -- ================================================================================================

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

872: l_too_many_entries VARCHAR2(1) := NULL;
873: l_legislation_code VARCHAR2(2) := NULL;
874:
875: BEGIN
876: hr_utility.set_location('Entering:'||l_proc, 5);
877:
878:
879: -- get the leg_code
880: open csr_bg;

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

1205: END loop;
1206: CLOSE csr_ineligible_entitlements;
1207: -- fix for bug 6645756 ends here.
1208:
1209: hr_utility.set_location('Leaving:'||l_proc, 5);
1210: END call_PAY_api;
1211:
1212: -- ================================================================================================
1213: -- == **************** do_apply_for_assignment ***************** ==

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

1309:
1310:
1311: BEGIN
1312:
1313: hr_utility.set_location('Entering:'||l_proc, 5);
1314:
1315: if p_params.category is null or p_params.category = 'ASG' then
1316: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);
1317:

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

1413: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);
1414: per_cagr_utility_pkg.put_log(' ');
1415: end if;
1416:
1417: hr_utility.set_location('Leaving:'||l_proc, 100);
1418:
1419:
1420: EXCEPTION
1421: when others then

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

1430: -- ================================================================================================
1431:
1432: BEGIN
1433:
1434: hr_utility.set_location('Entering:'||l_proc, 5);
1435: --
1436: if not(g_done_header) then
1437: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1438: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);

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

1578:
1579: per_cagr_utility_pkg.put_log('Completed Result Population Process ('
1580: ||fnd_date.date_to_canonical(sysdate)||')',1);
1581: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1582: hr_utility.set_location('Leaving:'||l_proc, 100);
1583:
1584:
1585: EXCEPTION
1586: when others then

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

1631: l_params per_cagr_evaluation_pkg.control_structure;
1632:
1633: BEGIN
1634:
1635: hr_utility.set_location('Entering:'||l_proc, 5);
1636:
1637: if p_cagr_request_id is null then
1638: --
1639: -- generate a new request for use in this run, if called from SRS or pl/sql module directly

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

1774: -- complete logging
1775: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);
1776: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1777:
1778: hr_utility.set_location('Leaving:'||l_proc, 50);
1779:
1780: END;
1781:
1782: END per_cagr_apply_results_pkg;