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.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 355: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

575: -- delete pl/sql tables
576: l_api_details.delete;
577: l_mapping_table.delete;
578:
579: hr_utility.set_location('Leaving:'||l_proc, 5);
580: END call_ASG_api;
581:
582: -- ================================================================================================
583: -- == **************** CALL_PYS_API ***************** ==

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

628: l_effective_start_date DATE;
629: l_effective_end_date DATE;
630:
631: BEGIN
632: hr_utility.set_location('Entering:'||l_proc, 5);
633:
634: -- first check if we need to call update or create api
635:
636: open csr_placement_id;

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

746: l_api_details.delete;
747: l_mapping_table.delete;
748:
749:
750: hr_utility.set_location('Leaving:'||l_proc, 5);
751: END call_PYS_api;
752:
753:
754: -- ================================================================================================

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

882: l_too_many_entries VARCHAR2(1) := NULL;
883: l_legislation_code VARCHAR2(2) := NULL;
884:
885: BEGIN
886: hr_utility.set_location('Entering:'||l_proc, 5);
887:
888:
889: -- get the leg_code
890: open csr_bg;

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

1215: END loop;
1216: CLOSE csr_ineligible_entitlements;
1217: -- fix for bug 6645756 ends here.
1218:
1219: hr_utility.set_location('Leaving:'||l_proc, 5);
1220: END call_PAY_api;
1221:
1222: -- ================================================================================================
1223: -- == **************** do_apply_for_assignment ***************** ==

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

1320:
1321:
1322: BEGIN
1323:
1324: hr_utility.set_location('Entering:'||l_proc, 5);
1325:
1326: if p_params.category is null or p_params.category = 'ASG' then
1327: per_cagr_utility_pkg.put_log(' Starting ASSIGNMENT category items...',1);
1328:

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

1424: per_cagr_utility_pkg.put_log(' Completed PAYROLL category items.',1);
1425: per_cagr_utility_pkg.put_log(' ');
1426: end if;
1427:
1428: hr_utility.set_location('Leaving:'||l_proc, 100);
1429:
1430:
1431: EXCEPTION
1432: when others then

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

1441: -- ================================================================================================
1442:
1443: BEGIN
1444:
1445: hr_utility.set_location('Entering:'||l_proc, 5);
1446: --
1447: if not(g_done_header) then
1448: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_head_separator,1);
1449: per_cagr_utility_pkg.put_log('-------- Result Population Process Log ('||fnd_date.date_to_canonical(sysdate)||') --------',1);

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

1589:
1590: per_cagr_utility_pkg.put_log('Completed Result Population Process ('
1591: ||fnd_date.date_to_canonical(sysdate)||')',1);
1592: per_cagr_utility_pkg.write_log_file(p_params.cagr_request_id);
1593: hr_utility.set_location('Leaving:'||l_proc, 100);
1594:
1595:
1596: EXCEPTION
1597: when others then

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

1642: l_params per_cagr_evaluation_pkg.control_structure;
1643:
1644: BEGIN
1645:
1646: hr_utility.set_location('Entering:'||l_proc, 5);
1647:
1648: if p_cagr_request_id is null then
1649: --
1650: -- generate a new request for use in this run, if called from SRS or pl/sql module directly

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

1785: -- complete logging
1786: per_cagr_utility_pkg.put_log(per_cagr_evaluation_pkg.g_separator,1);
1787: per_cagr_utility_pkg.write_log_file(l_params.cagr_request_id);
1788:
1789: hr_utility.set_location('Leaving:'||l_proc, 50);
1790:
1791: END;
1792:
1793: END per_cagr_apply_results_pkg;