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.PQH_GSP_GRD_STEP_REMOVE dependencies on HR_UTILITY

Line 18: hr_utility.set_location ('Entering get_ovn', 10);

14: SELECT object_version_number
15: FROM ben_copy_entity_results
16: WHERE copy_entity_result_id = p_copy_entity_result_id;
17: BEGIN
18: hr_utility.set_location ('Entering get_ovn', 10);
19: OPEN csr_ovn;
20: FETCH csr_ovn INTO l_ovn;
21: CLOSE csr_ovn;
22: hr_utility.set_location ('Leaving get_ovn'||l_ovn, 100);

Line 22: hr_utility.set_location ('Leaving get_ovn'||l_ovn, 100);

18: hr_utility.set_location ('Entering get_ovn', 10);
19: OPEN csr_ovn;
20: FETCH csr_ovn INTO l_ovn;
21: CLOSE csr_ovn;
22: hr_utility.set_location ('Leaving get_ovn'||l_ovn, 100);
23: RETURN l_ovn;
24: END get_ovn;
25: --
26: --------------------------- get_dml_operation -----------------------------

Line 39: hr_utility.set_location ('Entering get_dml_operation', 10);

35: SELECT dml_operation
36: FROM ben_copy_entity_results
37: WHERE copy_entity_result_id = p_copy_entity_result_id;
38: BEGIN
39: hr_utility.set_location ('Entering get_dml_operation', 10);
40: OPEN csr_dml_operation;
41: FETCH csr_dml_operation INTO l_dml_operation;
42: CLOSE csr_dml_operation;
43: hr_utility.set_location ('Leaving get_dml_operation '||l_dml_operation, 100);

Line 43: hr_utility.set_location ('Leaving get_dml_operation '||l_dml_operation, 100);

39: hr_utility.set_location ('Entering get_dml_operation', 10);
40: OPEN csr_dml_operation;
41: FETCH csr_dml_operation INTO l_dml_operation;
42: CLOSE csr_dml_operation;
43: hr_utility.set_location ('Leaving get_dml_operation '||l_dml_operation, 100);
44: RETURN l_dml_operation;
45: END get_dml_operation;
46:
47: --

Line 59: hr_utility.set_location ('Entering delete_rec', 10);

55: )
56: IS
57: l_ovn NUMBER;
58: BEGIN
59: hr_utility.set_location ('Entering delete_rec', 10);
60: if p_object_version_number is null then
61: l_ovn := get_ovn (p_copy_entity_result_id => p_copy_entity_result_id);
62: else
63: l_ovn := p_object_version_number;

Line 70: hr_utility.set_location ('Purged the record Sucessfully... :', 90);

66: p_copy_entity_result_id => p_copy_entity_result_id,
67: p_effective_date => p_effective_date,
68: p_object_version_number => l_ovn
69: );
70: hr_utility.set_location ('Purged the record Sucessfully... :', 90);
71: hr_utility.set_location ('Leaving delete_rec', 100);
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_location ('Errors in delete_rec ...', 100);

Line 71: hr_utility.set_location ('Leaving delete_rec', 100);

67: p_effective_date => p_effective_date,
68: p_object_version_number => l_ovn
69: );
70: hr_utility.set_location ('Purged the record Sucessfully... :', 90);
71: hr_utility.set_location ('Leaving delete_rec', 100);
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_location ('Errors in delete_rec ...', 100);
75: raise;

Line 74: hr_utility.set_location ('Errors in delete_rec ...', 100);

70: hr_utility.set_location ('Purged the record Sucessfully... :', 90);
71: hr_utility.set_location ('Leaving delete_rec', 100);
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_location ('Errors in delete_rec ...', 100);
75: raise;
76: END delete_rec;
77:
78: --

Line 89: hr_utility.set_location ('Entering update_rec', 10);

85: )
86: IS
87: l_ovn NUMBER;
88: BEGIN
89: hr_utility.set_location ('Entering update_rec', 10);
90: l_ovn := get_ovn (p_copy_entity_result_id => p_copy_entity_result_id);
91: ben_copy_entity_results_api.update_copy_entity_results (
92: p_copy_entity_result_id => p_copy_entity_result_id,
93: p_effective_date => p_effective_date,

Line 98: hr_utility.set_location ('Marked for Deletion Sucessfully... :', 90);

94: p_information104 => 'UNLINK',
95: p_object_version_number => l_ovn,
96: p_information323 => NULL
97: );
98: hr_utility.set_location ('Marked for Deletion Sucessfully... :', 90);
99: hr_utility.set_location ('Leaving update_rec', 100);
100: EXCEPTION
101: WHEN OTHERS THEN
102: hr_utility.set_location ('Errors in update_rec ...', 150);

Line 99: hr_utility.set_location ('Leaving update_rec', 100);

95: p_object_version_number => l_ovn,
96: p_information323 => NULL
97: );
98: hr_utility.set_location ('Marked for Deletion Sucessfully... :', 90);
99: hr_utility.set_location ('Leaving update_rec', 100);
100: EXCEPTION
101: WHEN OTHERS THEN
102: hr_utility.set_location ('Errors in update_rec ...', 150);
103: END update_rec;

Line 102: hr_utility.set_location ('Errors in update_rec ...', 150);

98: hr_utility.set_location ('Marked for Deletion Sucessfully... :', 90);
99: hr_utility.set_location ('Leaving update_rec', 100);
100: EXCEPTION
101: WHEN OTHERS THEN
102: hr_utility.set_location ('Errors in update_rec ...', 150);
103: END update_rec;
104: --
105: --------------------------- purge_pay_scale-----------------------------
106: --

Line 142: hr_utility.set_location ('Entering purge_pay_scale', 10);

138: FROM ben_copy_entity_results
139: WHERE information258 = p_scale_cer_id
140: AND copy_entity_txn_id = l_cet_id;
141: BEGIN
142: hr_utility.set_location ('Entering purge_pay_scale', 10);
143: -- Get Pay Scale CER Id;
144: OPEN csr_scale_cer_id;
145: FETCH csr_scale_cer_id INTO l_cet_id,l_scale_cer_id;
146: CLOSE csr_scale_cer_id;

Line 147: hr_utility.set_location ('Pay Scale CER ID ' || l_scale_cer_id, 10);

143: -- Get Pay Scale CER Id;
144: OPEN csr_scale_cer_id;
145: FETCH csr_scale_cer_id INTO l_cet_id,l_scale_cer_id;
146: CLOSE csr_scale_cer_id;
147: hr_utility.set_location ('Pay Scale CER ID ' || l_scale_cer_id, 10);
148: hr_utility.set_location ('cet ID ' || l_cet_id, 10);
149: IF (l_scale_cer_id IS NOT NULL and l_cet_id is not null) THEN
150: OPEN csr_num_opts (l_scale_cer_id);
151: FETCH csr_num_opts INTO l_count;

Line 148: hr_utility.set_location ('cet ID ' || l_cet_id, 10);

144: OPEN csr_scale_cer_id;
145: FETCH csr_scale_cer_id INTO l_cet_id,l_scale_cer_id;
146: CLOSE csr_scale_cer_id;
147: hr_utility.set_location ('Pay Scale CER ID ' || l_scale_cer_id, 10);
148: hr_utility.set_location ('cet ID ' || l_cet_id, 10);
149: IF (l_scale_cer_id IS NOT NULL and l_cet_id is not null) THEN
150: OPEN csr_num_opts (l_scale_cer_id);
151: FETCH csr_num_opts INTO l_count;
152: CLOSE csr_num_opts;

Line 157: hr_utility.set_location ( 'Plip Cer Id ' || rec_plip_cer_id.copy_entity_result_id, 10);

153: IF (l_count = 1) THEN
154: delete_rec ( p_copy_entity_result_id => l_scale_cer_id,
155: p_effective_date => p_effective_date);
156: FOR rec_plip_cer_id IN csr_plip_cer_id (l_scale_cer_id) LOOP
157: hr_utility.set_location ( 'Plip Cer Id ' || rec_plip_cer_id.copy_entity_result_id, 10);
158: UPDATE ben_copy_entity_results
159: SET information98 = NULL,
160: information255 = NULL,
161: information258 = NULL,

Line 165: hr_utility.set_location ('Plip updated successfully', 40);

161: information258 = NULL,
162: information259 = NULL,
163: information262 = NULL
164: WHERE copy_entity_result_id = rec_plip_cer_id.copy_entity_result_id;
165: hr_utility.set_location ('Plip updated successfully', 40);
166: END LOOP;
167: END IF;
168: else
169: hr_utility.set_location ('null data found ', 40);

Line 169: hr_utility.set_location ('null data found ', 40);

165: hr_utility.set_location ('Plip updated successfully', 40);
166: END LOOP;
167: END IF;
168: else
169: hr_utility.set_location ('null data found ', 40);
170: END IF;
171: hr_utility.set_location ('Leaving purge_pay_scale', 100);
172: EXCEPTION
173: WHEN OTHERS THEN

Line 171: hr_utility.set_location ('Leaving purge_pay_scale', 100);

167: END IF;
168: else
169: hr_utility.set_location ('null data found ', 40);
170: END IF;
171: hr_utility.set_location ('Leaving purge_pay_scale', 100);
172: EXCEPTION
173: WHEN OTHERS THEN
174: hr_utility.set_location ('Errors in purge_pay_scale ...', 100);
175: END purge_pay_scale;

Line 174: hr_utility.set_location ('Errors in purge_pay_scale ...', 100);

170: END IF;
171: hr_utility.set_location ('Leaving purge_pay_scale', 100);
172: EXCEPTION
173: WHEN OTHERS THEN
174: hr_utility.set_location ('Errors in purge_pay_scale ...', 100);
175: END purge_pay_scale;
176: --
177: --------------------------- purge_opt_abr_hrrate_crrate -----------------------------
178: --

Line 202: hr_utility.set_location ('Entering purge_opt_abr_hrrate_crrate', 10);

198: WHERE crrate.copy_entity_txn_id = p_copy_entity_txn_id
199: AND crrate.table_alias = 'CRRATE'
200: AND crrate.information169 = p_opt_result_id;
201: BEGIN
202: hr_utility.set_location ('Entering purge_opt_abr_hrrate_crrate', 10);
203: -- purge HRRATE, ABR Records
204: FOR rec_std_rates IN csr_std_rates LOOP
205: delete_rec ( p_copy_entity_result_id => rec_std_rates.copy_entity_result_id,
206: p_effective_date => p_effective_date,

Line 210: hr_utility.set_location ('Purged HRRATE, ABR Recs sucessully ', 40);

206: p_effective_date => p_effective_date,
207: p_object_version_number => rec_std_rates.object_version_number);
208: END LOOP;
209:
210: hr_utility.set_location ('Purged HRRATE, ABR Recs sucessully ', 40);
211:
212: -- purge CRRATE Records
213: FOR rec_crrates IN csr_crrate LOOP
214: delete_rec ( p_copy_entity_result_id => rec_crrates.copy_entity_result_id,

Line 220: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);

216: p_object_version_number => rec_crrates.object_version_number
217: );
218: END LOOP;
219:
220: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);
221: hr_utility.set_location ('Leaving purge_opt_abr_hrrate_crrate', 100);
222: EXCEPTION
223: WHEN OTHERS THEN
224: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);

Line 221: hr_utility.set_location ('Leaving purge_opt_abr_hrrate_crrate', 100);

217: );
218: END LOOP;
219:
220: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);
221: hr_utility.set_location ('Leaving purge_opt_abr_hrrate_crrate', 100);
222: EXCEPTION
223: WHEN OTHERS THEN
224: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);
225: END purge_opt_abr_hrrate_crrate;

Line 224: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);

220: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);
221: hr_utility.set_location ('Leaving purge_opt_abr_hrrate_crrate', 100);
222: EXCEPTION
223: WHEN OTHERS THEN
224: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);
225: END purge_opt_abr_hrrate_crrate;
226:
227: --
228: --------------------------- remove_opt -----------------------------

Line 248: hr_utility.set_location ('Entering remove_opt', 100);

244: IS
245: l_point_or_step VARCHAR2 (20);
246: l_dml_operation VARCHAR2 (40);
247: BEGIN
248: hr_utility.set_location ('Entering remove_opt', 100);
249: l_point_or_step :=
250: pqh_gsp_utility.use_point_or_step (
251: p_copy_entity_txn_id => p_copy_entity_txn_id
252: );

Line 257: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);

253: l_dml_operation :=
254: get_dml_operation (
255: p_copy_entity_result_id => p_copy_entity_result_id
256: );
257: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
258: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
259:
260: -- If GL Using Direct Steps
261: -- if l_point_or_step= 'STEP' Then

Line 258: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);

254: get_dml_operation (
255: p_copy_entity_result_id => p_copy_entity_result_id
256: );
257: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
258: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
259:
260: -- If GL Using Direct Steps
261: -- if l_point_or_step= 'STEP' Then
262:

Line 265: hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate... :', 30);

261: -- if l_point_or_step= 'STEP' Then
262:
263: IF l_dml_operation = 'INSERT' THEN
264: -- 1) Purge ABR,HRRATE, CRRATE
265: hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate... :', 30);
266: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (
267: p_opt_result_id => p_copy_entity_result_id,
268: p_copy_entity_txn_id => p_copy_entity_txn_id,
269: p_effective_date => p_effective_date

Line 273: hr_utility.set_location ('Calling purge_pay_scale... :', 40);

269: p_effective_date => p_effective_date
270: );
271: -- 2) Get The Number of Options attached to this Pay Scale Cer Id
272: -- suppose only one then purge Pay Scale record.
273: hr_utility.set_location ('Calling purge_pay_scale... :', 40);
274:
275: IF l_point_or_step = 'STEP'
276: THEN
277: pqh_gsp_grd_step_remove.purge_pay_scale (

Line 284: hr_utility.set_location ('Purge OPT ... :', 50);

280: p_effective_date => p_effective_date
281: );
282: END IF; -- end of STEP
283: -- 3) purge OPT Rec
284: hr_utility.set_location ('Purge OPT ... :', 50);
285: delete_rec (
286: p_copy_entity_result_id => p_copy_entity_result_id,
287: p_effective_date => p_effective_date
288: );

Line 303: hr_utility.set_location ('Leaving remove_opt', 100);

299: p_effective_date => p_effective_date
300: );
301: END IF; -- end of dml_operation
302: -- end if; -- end of STEP
303: hr_utility.set_location ('Leaving remove_opt', 100);
304: END remove_opt;
305: --
306: ---------------------------remove_elig_profile-----------------------------
307: --

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

323: WHERE elp.copy_entity_txn_id = p_copy_entity_txn_id
324: AND elp.gs_parent_entity_result_id = p_copy_entity_result_id
325: AND elp.table_alias = 'ELP';
326: BEGIN
327: hr_utility.set_location ('Entering remove_elig_profile', 10);
328: -- Check Eligibility Profiles Exists for OIPL Rec
329: l_exits := pqh_gsp_utility.chk_profile_exists ( p_copy_entity_result_id => p_copy_entity_result_id,
330: p_copy_entity_txn_id => p_copy_entity_txn_id);
331:

Line 332: hr_utility.set_location ( 'Eligibility Profiles Exists (Y/N) :' || l_exits, 50);

328: -- Check Eligibility Profiles Exists for OIPL Rec
329: l_exits := pqh_gsp_utility.chk_profile_exists ( p_copy_entity_result_id => p_copy_entity_result_id,
330: p_copy_entity_txn_id => p_copy_entity_txn_id);
331:
332: hr_utility.set_location ( 'Eligibility Profiles Exists (Y/N) :' || l_exits, 50);
333: IF (l_exits = 'Y') THEN
334: FOR elp_recs IN csr_elp_cer_ids LOOP
335: pqh_gsp_prgrules.delete_eligibility (
336: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 342: hr_utility.set_location ('Removed Elig Profiles sucessfully ... ', 60);

338: );
339: END LOOP;
340: END IF;
341:
342: hr_utility.set_location ('Removed Elig Profiles sucessfully ... ', 60);
343: hr_utility.set_location ('Leaving remove_elig_profile', 100);
344: EXCEPTION
345: WHEN OTHERS THEN
346: hr_utility.set_location ( 'Error in Removing Elig Profiles ... ', 100);

Line 343: hr_utility.set_location ('Leaving remove_elig_profile', 100);

339: END LOOP;
340: END IF;
341:
342: hr_utility.set_location ('Removed Elig Profiles sucessfully ... ', 60);
343: hr_utility.set_location ('Leaving remove_elig_profile', 100);
344: EXCEPTION
345: WHEN OTHERS THEN
346: hr_utility.set_location ( 'Error in Removing Elig Profiles ... ', 100);
347: END remove_elig_profile;

Line 346: hr_utility.set_location ( 'Error in Removing Elig Profiles ... ', 100);

342: hr_utility.set_location ('Removed Elig Profiles sucessfully ... ', 60);
343: hr_utility.set_location ('Leaving remove_elig_profile', 100);
344: EXCEPTION
345: WHEN OTHERS THEN
346: hr_utility.set_location ( 'Error in Removing Elig Profiles ... ', 100);
347: END remove_elig_profile;
348: --
349: ---------------------------remove_oipl_STEP_flavour -----------------------------
350: --

Line 383: hr_utility.set_location ('Entering remove_oipl_STEP_flavour', 10);

379: WHERE oipl.copy_entity_txn_id = p_copy_entity_txn_id
380: AND oipl.table_alias = 'COP'
381: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
382: BEGIN
383: hr_utility.set_location ('Entering remove_oipl_STEP_flavour', 10);
384: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
385: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
386:
387: -- Get OPT Cer ID

Line 391: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);

387: -- Get OPT Cer ID
388: OPEN csr_opt_result_id;
389: FETCH csr_opt_result_id INTO l_opt_result_id;
390: CLOSE csr_opt_result_id;
391: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
392: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
393: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
394: hr_utility.set_location ('remove_opt value:' || p_remove_opt, 46);
395:

Line 392: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);

388: OPEN csr_opt_result_id;
389: FETCH csr_opt_result_id INTO l_opt_result_id;
390: CLOSE csr_opt_result_id;
391: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
392: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
393: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
394: hr_utility.set_location ('remove_opt value:' || p_remove_opt, 46);
395:
396: IF l_point_or_step = 'STEP' THEN

Line 393: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);

389: FETCH csr_opt_result_id INTO l_opt_result_id;
390: CLOSE csr_opt_result_id;
391: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
392: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
393: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
394: hr_utility.set_location ('remove_opt value:' || p_remove_opt, 46);
395:
396: IF l_point_or_step = 'STEP' THEN
397:

Line 394: hr_utility.set_location ('remove_opt value:' || p_remove_opt, 46);

390: CLOSE csr_opt_result_id;
391: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
392: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
393: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
394: hr_utility.set_location ('remove_opt value:' || p_remove_opt, 46);
395:
396: IF l_point_or_step = 'STEP' THEN
397:
398: /*IF l_dml_operation = 'INSERT' OR l_dml_operation ='COPIED' OR l_dml_operation = 'UPD_INS' THEN */

Line 406: hr_utility.set_location ('Calling remove_opt... :', 60);

402:
403: IF l_dml_operation = 'INSERT' OR l_dml_operation = 'UPD_INS' THEN
404: -- 1) Call Pqh_Gsp_Grd_Step_Remove.remove_opt
405: IF p_remove_opt = 'Y' THEN
406: hr_utility.set_location ('Calling remove_opt... :', 60);
407: pqh_gsp_grd_step_remove.remove_opt (
408: p_copy_entity_txn_id => p_copy_entity_txn_id,
409: p_copy_entity_result_id => l_opt_result_id,
410: p_effective_date => p_effective_date);

Line 412: hr_utility.set_location ('Not calling remove_opt ', 60);

408: p_copy_entity_txn_id => p_copy_entity_txn_id,
409: p_copy_entity_result_id => l_opt_result_id,
410: p_effective_date => p_effective_date);
411: ELSE
412: hr_utility.set_location ('Not calling remove_opt ', 60);
413: END IF;
414:
415: -- 2) Purge Elig Profile call procedure remove_elig_profile
416: hr_utility.set_location ('Calling remove_elig_profile... :', 70);

Line 416: hr_utility.set_location ('Calling remove_elig_profile... :', 70);

412: hr_utility.set_location ('Not calling remove_opt ', 60);
413: END IF;
414:
415: -- 2) Purge Elig Profile call procedure remove_elig_profile
416: hr_utility.set_location ('Calling remove_elig_profile... :', 70);
417: pqh_gsp_grd_step_remove.remove_elig_profile (
418: p_copy_entity_txn_id => p_copy_entity_txn_id,
419: p_copy_entity_result_id => p_copy_entity_result_id
420: );

Line 422: hr_utility.set_location ('Purge OIPL... :', 80);

418: p_copy_entity_txn_id => p_copy_entity_txn_id,
419: p_copy_entity_result_id => p_copy_entity_result_id
420: );
421: -- 3) purge OIPL
422: hr_utility.set_location ('Purge OIPL... :', 80);
423: delete_rec (
424: p_copy_entity_result_id => p_copy_entity_result_id,
425: p_effective_date => p_effective_date
426: );

Line 449: hr_utility.set_location ('Leaving remove_oipl_STEP_flavour', 100);

445: p_effective_date => p_effective_date
446: );
447: END IF; -- end of dml_operation
448: END IF; -- end of STEP
449: hr_utility.set_location ('Leaving remove_oipl_STEP_flavour', 100);
450: END remove_oipl_step_flavour;
451: --
452: --------------------------- remove_oipl_POINT_flavour-----------------------------
453: --

Line 484: hr_utility.set_location ('Entering remove_oipl_POINT_flavour', 10);

480: WHERE oipl.copy_entity_txn_id = p_copy_entity_txn_id
481: AND oipl.table_alias = 'COP'
482: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
483: BEGIN
484: hr_utility.set_location ('Entering remove_oipl_POINT_flavour', 10);
485: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
486: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
487:
488: -- Get OPT Cer ID

Line 492: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);

488: -- Get OPT Cer ID
489: OPEN csr_opt_result_id;
490: FETCH csr_opt_result_id INTO l_opt_result_id;
491: CLOSE csr_opt_result_id;
492: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
493: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
494: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
495:
496: IF l_point_or_step = 'POINT' THEN

Line 493: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);

489: OPEN csr_opt_result_id;
490: FETCH csr_opt_result_id INTO l_opt_result_id;
491: CLOSE csr_opt_result_id;
492: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
493: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
494: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
495:
496: IF l_point_or_step = 'POINT' THEN
497:

Line 494: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);

490: FETCH csr_opt_result_id INTO l_opt_result_id;
491: CLOSE csr_opt_result_id;
492: hr_utility.set_location ('l_point_or_step :' || l_point_or_step, 40);
493: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
494: hr_utility.set_location ('OPT Result Id:' || l_opt_result_id, 46);
495:
496: IF l_point_or_step = 'POINT' THEN
497:
498: /* IF l_dml_operation = 'INSERT' OR l_dml_operation ='COPIED' OR l_dml_operation = 'UPD_INS' THEN */

Line 505: /* hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate ... :', 70);

501: -- In create mode dml_operation of the points is COPIED
502:
503: IF l_dml_operation = 'INSERT' OR l_dml_operation = 'UPD_INS' THEN
504: -- 1) Purge Standard Rates : ABR, HRRATE and Criteria Rates : CRRATE
505: /* hr_utility.set_location ( 'Calling purge_opt_abr_hrrate_crrate ... :', 70);
506: pqh_gsp_grd_step_remove.purge_opt_abr_hrrate_crrate (
507: p_opt_result_id => l_opt_result_id,
508: p_copy_entity_txn_id => p_copy_entity_txn_id,
509: p_effective_date => p_effective_date

Line 513: hr_utility.set_location ( 'Calling Pqh_Gsp_Grd_Step_Remove.remove_elig_profile... :', 75);

509: p_effective_date => p_effective_date
510: );
511: */
512: -- 2) Purge Elig Profile call procedure Pqh_Gsp_Grd_Step_Remove.remove_elig_profile
513: hr_utility.set_location ( 'Calling Pqh_Gsp_Grd_Step_Remove.remove_elig_profile... :', 75);
514: pqh_gsp_grd_step_remove.remove_elig_profile (
515: p_copy_entity_txn_id => p_copy_entity_txn_id,
516: p_copy_entity_result_id => p_copy_entity_result_id
517: );

Line 519: hr_utility.set_location ('Purge OIPL ... :', 80);

515: p_copy_entity_txn_id => p_copy_entity_txn_id,
516: p_copy_entity_result_id => p_copy_entity_result_id
517: );
518: -- 3) purge OIPL
519: hr_utility.set_location ('Purge OIPL ... :', 80);
520: delete_rec (
521: p_copy_entity_result_id => p_copy_entity_result_id,
522: p_effective_date => p_effective_date
523: );

Line 537: hr_utility.set_location ('Leaving remove_oipl_POINT_flavour', 100);

533: p_effective_date => p_effective_date
534: );
535: END IF; -- end of dml_operation
536: END IF; -- end of POINT
537: hr_utility.set_location ('Leaving remove_oipl_POINT_flavour', 100);
538: END remove_oipl_point_flavour;
539: --
540: --------------------------- remove_oipl -----------------------------
541: --

Line 554: hr_utility.set_location ('Entering remove_oipl', 10);

550: IS
551: l_which_flavour VARCHAR2 (20);
552: BEGIN
553: hr_multi_message.enable_message_list;
554: hr_utility.set_location ('Entering remove_oipl', 10);
555: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
556: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
557: IF (l_which_flavour = 'POINT') THEN
558: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (

Line 556: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);

552: BEGIN
553: hr_multi_message.enable_message_list;
554: hr_utility.set_location ('Entering remove_oipl', 10);
555: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
556: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
557: IF (l_which_flavour = 'POINT') THEN
558: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (
559: p_copy_entity_txn_id => p_copy_entity_txn_id,
560: p_copy_entity_result_id => p_copy_entity_result_id,

Line 572: hr_utility.set_location ('Leaving remove_oipl', 100);

568: p_effective_date => p_effective_date,
569: p_remove_opt => p_remove_opt
570: );
571: END IF;
572: hr_utility.set_location ('Leaving remove_oipl', 100);
573: Exception
574: when others then
575: hr_utility.set_location ('Caught an Exception', 100);
576: hr_multi_message.add;

Line 575: hr_utility.set_location ('Caught an Exception', 100);

571: END IF;
572: hr_utility.set_location ('Leaving remove_oipl', 100);
573: Exception
574: when others then
575: hr_utility.set_location ('Caught an Exception', 100);
576: hr_multi_message.add;
577: END remove_oipl;
578: --
579: --------------------------- remove_plip -----------------------------

Line 608: hr_utility.set_location ('Entering remove_plip', 10);

604: AND oipl.table_alias = 'COP'
605: AND oipl.copy_entity_txn_id = p_copy_entity_txn_id;
606:
607: BEGIN
608: hr_utility.set_location ('Entering remove_plip', 10);
609:
610: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
611: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
612: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);

Line 612: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);

608: hr_utility.set_location ('Entering remove_plip', 10);
609:
610: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
611: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
612: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
613: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
614:
615: -- Remove Rates, Elig Profiles attahced to OIPL
616: -- Remove OIPL

Line 613: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);

609:
610: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
611: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
612: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
613: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
614:
615: -- Remove Rates, Elig Profiles attahced to OIPL
616: -- Remove OIPL
617: FOR rec_oipls IN csr_oipl_ids LOOP

Line 637: hr_utility.set_location ('Calling remove_elig_profile... :', 70);

633: END LOOP;
634:
635: IF l_dml_operation = 'INSERT' THEN
636: -- 1) Purge Elig Profile call procedure remove_elig_profile
637: hr_utility.set_location ('Calling remove_elig_profile... :', 70);
638: pqh_gsp_grd_step_remove.remove_elig_profile (
639: p_copy_entity_txn_id => p_copy_entity_txn_id,
640: p_copy_entity_result_id => p_copy_entity_result_id
641: );

Line 656: hr_utility.set_location ('Purged PLIP Rec Sucessfully... :', 85);

652:
653: delete_rec ( p_copy_entity_result_id => p_copy_entity_result_id,
654: p_effective_date => p_effective_date);
655:
656: hr_utility.set_location ('Purged PLIP Rec Sucessfully... :', 85);
657: ELSE -- dml_operation = UPDATE/COPIED/UPD_INS
658: -- Mark PLIP for Deletion
659: update_rec (
660: p_copy_entity_result_id => p_copy_entity_result_id,

Line 663: hr_utility.set_location ('Marked for Deletion PLIP Rec Sucessfully... :',90);

659: update_rec (
660: p_copy_entity_result_id => p_copy_entity_result_id,
661: p_effective_date => p_effective_date
662: );
663: hr_utility.set_location ('Marked for Deletion PLIP Rec Sucessfully... :',90);
664: END IF; -- DML Operation
665: hr_utility.set_location ('Leaving remove_plip', 100);
666: END remove_plip;
667: PROCEDURE unlink_opt_abr_hrrate_crrate (

Line 665: hr_utility.set_location ('Leaving remove_plip', 100);

661: p_effective_date => p_effective_date
662: );
663: hr_utility.set_location ('Marked for Deletion PLIP Rec Sucessfully... :',90);
664: END IF; -- DML Operation
665: hr_utility.set_location ('Leaving remove_plip', 100);
666: END remove_plip;
667: PROCEDURE unlink_opt_abr_hrrate_crrate (
668: p_opt_result_id IN NUMBER,
669: p_copy_entity_txn_id IN NUMBER,

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

689: WHERE crrate.copy_entity_txn_id = p_copy_entity_txn_id
690: AND crrate.table_alias = 'CRRATE'
691: AND crrate.information169 = p_opt_result_id;
692: BEGIN
693: hr_utility.set_location ('Entering ' || l_proc, 10);
694:
695: -- purge HRRATE, ABR Records
696: FOR rec_std_rates IN csr_std_rates
697: LOOP

Line 704: hr_utility.set_location ('Purged HRRATE, ABR Recs sucessully ', 40);

700: p_effective_date => p_effective_date
701: );
702: END LOOP;
703:
704: hr_utility.set_location ('Purged HRRATE, ABR Recs sucessully ', 40);
705:
706: -- purge CRRATE Records
707: FOR rec_crrates IN csr_crrate
708: LOOP

Line 715: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);

711: p_effective_date => p_effective_date
712: );
713: END LOOP;
714:
715: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);
716: hr_utility.set_location ('Leaving ' || l_proc, 100);
717: EXCEPTION
718: WHEN OTHERS
719: THEN

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

712: );
713: END LOOP;
714:
715: hr_utility.set_location ('Purged CRRATE Recs sucessully ', 55);
716: hr_utility.set_location ('Leaving ' || l_proc, 100);
717: EXCEPTION
718: WHEN OTHERS
719: THEN
720: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);

Line 720: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);

716: hr_utility.set_location ('Leaving ' || l_proc, 100);
717: EXCEPTION
718: WHEN OTHERS
719: THEN
720: hr_utility.set_location ('purge_opt_abr_hrrate_crrate ', 110);
721: END unlink_opt_abr_hrrate_crrate;
722:
723: END pqh_gsp_grd_step_remove;