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

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: TYPE hierarchy_tab IS TABLE OF pqh_pa_whatif_results%ROWTYPE INDEX BY BINARY_INTEGER;
5:
6: g_hierarchy hierarchy_tab;
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: g_package varchar2(72) := 'pqh_pa_whatif_process';
10: g_role_id number :=-1;
11: g_effective_date DATE;
12: -----------------------------------------------------------------------------------------------

Line 38: g_debug := hr_utility.debug_enabled;

34: l_uom_name fnd_currencies_tl.name%TYPE;
35: --
36: BEGIN
37: --
38: g_debug := hr_utility.debug_enabled;
39:
40: if g_debug then
41: l_proc := g_package || 'get_uom';
42: hr_utility.set_location('Entering: ' || l_proc,10);

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

38: g_debug := hr_utility.debug_enabled;
39:
40: if g_debug then
41: l_proc := g_package || 'get_uom';
42: hr_utility.set_location('Entering: ' || l_proc,10);
43: end if;
44: IF p_nnmntry_uom is not null THEN
45: OPEN csr_get_nnmntry_uom(p_nnmntry_uom => p_nnmntry_uom, p_effective_date => p_effective_date);
46: FETCH csr_get_nnmntry_uom INTO l_uom_name;

Line 49: hr_utility.set_location('Non Monetary UOM: ' || l_uom_name,15);

45: OPEN csr_get_nnmntry_uom(p_nnmntry_uom => p_nnmntry_uom, p_effective_date => p_effective_date);
46: FETCH csr_get_nnmntry_uom INTO l_uom_name;
47: CLOSE csr_get_nnmntry_uom;
48: if g_debug then
49: hr_utility.set_location('Non Monetary UOM: ' || l_uom_name,15);
50: end if;
51: ELSE
52: OPEN csr_get_uom(p_uom => p_uom, p_effective_date => p_effective_date);
53: FETCH csr_get_uom INTO l_uom_name;

Line 56: hr_utility.set_location('Monetary UOM: ' || l_uom_name,15);

52: OPEN csr_get_uom(p_uom => p_uom, p_effective_date => p_effective_date);
53: FETCH csr_get_uom INTO l_uom_name;
54: CLOSE csr_get_uom;
55: if g_debug then
56: hr_utility.set_location('Monetary UOM: ' || l_uom_name,15);
57: end if;
58: END IF;
59: if g_debug then
60: hr_utility.set_location('Leaving: ' || l_proc,20);

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

56: hr_utility.set_location('Monetary UOM: ' || l_uom_name,15);
57: end if;
58: END IF;
59: if g_debug then
60: hr_utility.set_location('Leaving: ' || l_proc,20);
61: end if;
62:
63: RETURN l_uom_name;
64:

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

86: BEGIN
87: --
88: if g_debug then
89: l_proc := g_package || 'chk_potential_life_events';
90: hr_utility.set_location('Entering: ' || l_proc,10);
91: end if;
92:
93: OPEN csr_chk_ptnl_ler(p_person_id => p_person_id, p_business_group_id => p_business_group_id);
94: FETCH csr_chk_ptnl_ler INTO l_lf_evt_ocrd_dt;

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

99: l_exists := 'Y';
100: END IF;
101:
102: if g_debug then
103: hr_utility.set_location('Leaving: ' || l_proc,20);
104: end if;
105:
106: RETURN l_exists;
107: --

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

135: BEGIN
136: --
137: if g_debug then
138: l_proc := g_package || '.chk_conflict_life_events';
139: hr_utility.set_location('Entering: ' || l_proc,10);
140: end if;
141: g_hierarchy.DELETE;
142:
143: FOR ler_rec IN csr_chk_cnflt_ler LOOP

Line 145: hr_utility.set_location('Detected Le :' ||ler_rec.name|| to_char(ler_rec.ler_id)||ler_rec.ovridg_le_flag,20);

141: g_hierarchy.DELETE;
142:
143: FOR ler_rec IN csr_chk_cnflt_ler LOOP
144: if g_debug then
145: hr_utility.set_location('Detected Le :' ||ler_rec.name|| to_char(ler_rec.ler_id)||ler_rec.ovridg_le_flag,20);
146:
147: end if;
148: g_hierarchy(l_counter).ler_id := ler_rec.ler_id;
149: g_hierarchy(l_counter).name := ler_rec.name;

Line 158: hr_utility.set_location('Number of OVERRDG LE triggered: ' || to_char(l_ovridg_le_count),30);

154: END IF;
155: END LOOP;
156:
157: if g_debug then
158: hr_utility.set_location('Number of OVERRDG LE triggered: ' || to_char(l_ovridg_le_count),30);
159: hr_utility.set_location('Number of non OVERRDG LE triggered: ' || to_char(l_non_ovridg_le_count),35);
160: hr_utility.set_location('Leaving: ' || l_proc,40);
161: end if;
162: IF l_ovridg_le_count+l_non_ovridg_le_count=0 THEN

Line 159: hr_utility.set_location('Number of non OVERRDG LE triggered: ' || to_char(l_non_ovridg_le_count),35);

155: END LOOP;
156:
157: if g_debug then
158: hr_utility.set_location('Number of OVERRDG LE triggered: ' || to_char(l_ovridg_le_count),30);
159: hr_utility.set_location('Number of non OVERRDG LE triggered: ' || to_char(l_non_ovridg_le_count),35);
160: hr_utility.set_location('Leaving: ' || l_proc,40);
161: end if;
162: IF l_ovridg_le_count+l_non_ovridg_le_count=0 THEN
163: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');

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

156:
157: if g_debug then
158: hr_utility.set_location('Number of OVERRDG LE triggered: ' || to_char(l_ovridg_le_count),30);
159: hr_utility.set_location('Number of non OVERRDG LE triggered: ' || to_char(l_non_ovridg_le_count),35);
160: hr_utility.set_location('Leaving: ' || l_proc,40);
161: end if;
162: IF l_ovridg_le_count+l_non_ovridg_le_count=0 THEN
163: fnd_message.set_name('BEN','BEN_92540_NOONE_TO_PROCESS_CM');
164: fnd_message.raise_error;

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

182: BEGIN
183: --
184: if g_debug then
185: l_proc := g_package || 'void_potential_life_events';
186: hr_utility.set_location('Entering: ' || l_proc,10);
187: end if;
188:
189: UPDATE ben_ptnl_ler_for_per
190: SET ptnl_ler_for_per_stat_cd = 'VOIDD'

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

194: AND lf_evt_ocrd_dt <= p_effective_date
195: AND ptnl_ler_for_per_stat_cd IN ('UNPROCD', 'DTCTD'); -- 5763776 Removed 'PROCD'. Should not require this.
196:
197: if g_debug then
198: hr_utility.set_location('Leaving: ' || l_proc,20);
199: end if;
200: --
201: END void_potential_life_events;
202: -----------------------------------------------------------------------------------------------

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

211: BEGIN
212: --
213: if g_debug then
214: l_proc := g_package || 'void_active_life_events';
215: hr_utility.set_location('Entering: ' || l_proc,10);
216: end if;
217:
218: UPDATE ben_per_in_ler
219: SET per_in_ler_stat_cd = 'VOIDD'

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

223: AND ler_id in ( select ler_id from ben_ler_f ler where ler.typ_cd NOT IN ('COMP','SCHEDDU','SCHEDDO'))
224: AND per_in_ler_stat_cd = 'STRTD';
225:
226: if g_debug then
227: hr_utility.set_location('Leaving: ' || l_proc,20);
228: end if;
229: --
230: END void_active_life_events;
231: -----------------------------------------------------------------------------------------------

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

242: BEGIN
243: --
244: if g_debug then
245: l_proc := g_package || '.void_conflict_life_events';
246: hr_utility.set_location('Entering: ' || l_proc,10);
247: end if;
248:
249: UPDATE ben_ptnl_ler_for_per
250: SET ptnl_ler_for_per_stat_cd = 'VOIDD'

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

255: AND lf_evt_ocrd_dt <= p_effective_date
256: AND ptnl_ler_for_per_stat_cd IN ('UNPROCD', 'DTCTD');
257:
258: if g_debug then
259: hr_utility.set_location('Leaving: ' || l_proc,20);
260: end if;
261: --
262: END void_conflict_life_events;
263: -----------------------------------------------------------------------------------------------

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

271: BEGIN
272: --
273: if g_debug then
274: l_proc := g_package || 'process_api_call';
275: hr_utility.set_location('Entering: ' || l_proc,10);
276: end if;
277:
278: l_sqlstr := 'BEGIN '||
279: p_api_name ||

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

281: 'END;';
282: EXECUTE IMMEDIATE l_sqlstr USING p_transaction_step_id;
283:
284: if g_debug then
285: hr_utility.set_location('Leaving: ' || l_proc,20);
286: end if;
287: --
288: END process_api_call;
289:

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

310: BEGIN
311: --
312: if g_debug then
313: l_proc := g_package || 'post_data_changes';
314: hr_utility.set_location('Entering: ' || l_proc,10);
315: end if;
316:
317: -- select each transaction steps to process
318:

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

341:
342: END LOOP;
343:
344: if g_debug then
345: hr_utility.set_location('Leaving: ' || l_proc,20);
346: end if;
347: --
348: END post_data_changes;
349: -----------------------------------------------------------------------------------------------

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

771:
772: BEGIN
773: if g_debug then
774: l_proc := g_package || '.post_ben_changes';
775: hr_utility.set_location('Entering: ' || l_proc,10);
776: end if;
777: p_lf_evt_ocrd_dt := p_effective_date; -- lf_evt_ocrd_dt will be different only for DRVDAGE ,DRVDLOS,DRVDCAL
778: FOR C1 in csr_trs
779: LOOP

Line 790: hr_utility.set_location('Table and Column: ' ||C1.api_name|| C2.name || l_field_val,15);

786: ELSIF C2.datatype='VARCHAR2' THEN
787: l_field_val :=C2.varchar2_value;
788: END IF;
789: if g_debug then
790: hr_utility.set_location('Table and Column: ' ||C1.api_name|| C2.name || l_field_val,15);
791: end if;
792:
793: IF C1.api_name = 'PER_ABSENCE_ATTENDANCES' and
794: C2.name = 'ABSENCE_ATTENDANCE_TYPE_ID' then

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

2235: );
2236: END IF; --if else ladder
2237: END LOOP;
2238: if g_debug then
2239: hr_utility.set_location('Leaving: ' || l_proc,100);
2240: end if;
2241: END post_ben_changes;
2242: -----------------------------------------------------------------------------------------------
2243:

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

2257: BEGIN
2258: --
2259: if g_debug then
2260: l_proc := g_package || 'get_coverage_amt';
2261: hr_utility.set_location('Entering: ' || l_proc,10);
2262: end if;
2263:
2264: OPEN csr_get_cvg_amt;
2265: FETCH csr_get_cvg_amt INTO l_coverage_amount;

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

2265: FETCH csr_get_cvg_amt INTO l_coverage_amount;
2266: CLOSE csr_get_cvg_amt;
2267:
2268: if g_debug then
2269: hr_utility.set_location('Leaving: ' || l_proc,20);
2270: end if;
2271:
2272: RETURN l_coverage_amount;
2273: --

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

2452: BEGIN
2453: --
2454: if g_debug then
2455: l_proc := g_package || '.populate_hierarchy';
2456: hr_utility.set_location('Entering: ' || l_proc,10);
2457: end if;
2458:
2459:
2460: OPEN csr_ler ;

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

2635: END LOOP; -- plan not in program
2636: END LOOP; -- plan type not in program
2637:
2638: if g_debug then
2639: hr_utility.set_location('Leaving: ' || l_proc,20);
2640: end if;
2641: --
2642: END populate_hierarchy;
2643: -----------------------------------------------------------------------------------------------

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

2648: BEGIN
2649: --
2650: if g_debug then
2651: l_proc := g_package || 'get_ler_index';
2652: hr_utility.set_location('Entering: ' || l_proc,10);
2653: end if;
2654:
2655: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2656: IF g_hierarchy(i).hierarchy_type = 'LE' THEN

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

2659: END IF;
2660: END LOOP;
2661:
2662: if g_debug then
2663: hr_utility.set_location('Leaving: ' || l_proc,20);
2664: end if;
2665:
2666: RETURN l_index;
2667: END;

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

2674: BEGIN
2675: --
2676: if g_debug then
2677: l_proc := g_package || 'chk_pl_typ_exists';
2678: hr_utility.set_location('Entering: ' || l_proc,10);
2679: end if;
2680:
2681: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2682: IF g_hierarchy(i).hierarchy_id = p_pl_typ_id AND g_hierarchy(i).hierarchy_type = 'PT'

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

2686: END IF;
2687: END LOOP;
2688:
2689: if g_debug then
2690: hr_utility.set_location('Leaving: ' || l_proc,20);
2691: end if;
2692:
2693: RETURN l_index;
2694: END;

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

2702: BEGIN
2703: --
2704: if g_debug then
2705: l_proc := g_package || 'chk_pgm_exists';
2706: hr_utility.set_location('Entering: ' || l_proc,10);
2707: end if;
2708:
2709: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2710: IF g_hierarchy(i).parent_hierarchy_type = 'LE'

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

2714: END IF;
2715: END LOOP;
2716:
2717: if g_debug then
2718: hr_utility.set_location('Leaving: ' || l_proc,20);
2719: end if;
2720:
2721: RETURN l_index;
2722: END;

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

2731: BEGIN
2732: --
2733: if g_debug then
2734: l_proc := g_package || '.chk_pt_in_pgm_exists';
2735: hr_utility.set_location('Entering: ' || l_proc,10);
2736: end if;
2737:
2738: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2739: IF g_hierarchy(i).hierarchy_id = p_ptip_id AND g_hierarchy(i).hierarchy_type = 'PTIP'

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

2743: END IF;
2744: END LOOP;
2745:
2746: if g_debug then
2747: hr_utility.set_location('Leaving: ' || l_proc,20);
2748: end if;
2749:
2750: RETURN l_index;
2751: END;

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

2760: BEGIN
2761: --
2762: if g_debug then
2763: l_proc := g_package || 'chk_plip_exists';
2764: hr_utility.set_location('Entering: ' || l_proc,10);
2765: end if;
2766:
2767: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2768: IF g_hierarchy(i).parent_hierarchy_id = p_ptip_id AND g_hierarchy(i).parent_hierarchy_type = 'PTIP'

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

2772: END IF;
2773: END LOOP;
2774:
2775: if g_debug then
2776: hr_utility.set_location('Leaving: ' || l_proc,20);
2777: end if;
2778:
2779: RETURN l_index;
2780: END;

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

2789: BEGIN
2790: --
2791: if g_debug then
2792: l_proc := g_package || 'chk_pnip_exists';
2793: hr_utility.set_location('Entering: ' || l_proc,10);
2794: end if;
2795:
2796: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2797: IF g_hierarchy(i).parent_hierarchy_id = p_pl_typ_id AND g_hierarchy(i).parent_hierarchy_type = 'PT'

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

2801: END IF;
2802: END LOOP;
2803:
2804: if g_debug then
2805: hr_utility.set_location('Leaving: ' || l_proc,20);
2806: end if;
2807:
2808: RETURN l_index;
2809: END;

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

2819: BEGIN
2820: --
2821: if g_debug then
2822: l_proc := g_package || 'chk_opt_in_plip_exists';
2823: hr_utility.set_location('Entering: ' || l_proc,10);
2824: end if;
2825:
2826: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2827: IF g_hierarchy(i).parent_hierarchy_id = p_pl_id AND g_hierarchy(i).parent_hierarchy_type = 'PLIP'

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

2831: END IF;
2832: END LOOP;
2833:
2834: if g_debug then
2835: hr_utility.set_location('Leaving: ' || l_proc,20);
2836: end if;
2837:
2838: RETURN l_index;
2839: END;

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

2849: BEGIN
2850: --
2851: if g_debug then
2852: l_proc := g_package || 'chk_opt_in_pnip_exists';
2853: hr_utility.set_location('Entering: ' || l_proc,10);
2854: end if;
2855:
2856: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2857: IF g_hierarchy(i).parent_hierarchy_id = p_pl_id AND g_hierarchy(i).parent_hierarchy_type = 'PNIP'

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

2861: END IF;
2862: END LOOP;
2863:
2864: if g_debug then
2865: hr_utility.set_location('Leaving: ' || l_proc,20);
2866: end if;
2867:
2868: RETURN l_index;
2869: END;

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

2879: BEGIN
2880: --
2881: if g_debug then
2882: l_proc := g_package || 'chk_rate_exists';
2883: hr_utility.set_location('Entering: ' || l_proc,10);
2884: end if;
2885:
2886: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2887: IF g_hierarchy(i).parent_hierarchy_id = p_opt_id AND (g_hierarchy(i).parent_hierarchy_type = 'OIPLIP' OR g_hierarchy(i).parent_hierarchy_type = 'OIPNIP')

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

2891: END IF;
2892: END LOOP;
2893:
2894: if g_debug then
2895: hr_utility.set_location('Leaving: ' || l_proc,20);
2896: end if;
2897:
2898: RETURN l_index;
2899: END;

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

2909: BEGIN
2910: --
2911: if g_debug then
2912: l_proc := g_package || 'chk_pl_rate_exists';
2913: hr_utility.set_location('Entering: ' || l_proc,10);
2914: end if;
2915:
2916: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST LOOP
2917: IF g_hierarchy(i).parent_hierarchy_id = p_pl_id AND (g_hierarchy(i).parent_hierarchy_type = 'PLIP' OR g_hierarchy(i).parent_hierarchy_type = 'PNIP')

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

2921: END IF;
2922: END LOOP;
2923:
2924: if g_debug then
2925: hr_utility.set_location('Leaving: ' || l_proc,20);
2926: end if;
2927:
2928: RETURN l_index;
2929: END;

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

3112: BEGIN
3113: --
3114: if g_debug then
3115: l_proc := g_package || 'populate_proposed_hierarchy';
3116: hr_utility.set_location('Entering: ' || l_proc,10);
3117: end if;
3118:
3119: OPEN csr_ler ;
3120: FETCH csr_ler INTO l_per_in_ler_id

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

3394: END LOOP; --- plan in plan type not in prog
3395: END LOOP;-- Plan type not in prog
3396:
3397: if g_debug then
3398: hr_utility.set_location('Leaving: ' || l_proc,20);
3399: end if;
3400: --
3401: END populate_proposed_hierarchy;
3402: -----------------------------------------------------------------------------------------------

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

3747: BEGIN
3748: --
3749: if g_debug then
3750: l_proc := g_package || 'populate_table';
3751: hr_utility.set_location('Entering: ' || l_proc,10);
3752: end if;
3753:
3754: OPEN csr_sequence_val;
3755: FETCH csr_sequence_val INTO p_whatif_results_batch_id;

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

3815:
3816: COMMIT;
3817:
3818: if g_debug then
3819: hr_utility.set_location('Leaving: ' || l_proc,20);
3820: end if;
3821: --
3822: END populate_table;
3823: ----------------------------------------------------------------------------------------------

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

3835: BEGIN
3836: --
3837: if g_debug then
3838: l_proc := g_package || 'purge_table_data';
3839: hr_utility.set_location('Entering: ' || l_proc,10);
3840: end if;
3841:
3842: FOR csr_purge_data_rec IN csr_purge_data LOOP
3843: DELETE PQH_PA_WHATIF_RESULTS

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

3845: END LOOP;
3846: COMMIT;
3847:
3848: if g_debug then
3849: hr_utility.set_location('Leaving: ' || l_proc,20);
3850: end if;
3851: --
3852: EXCEPTION
3853: WHEN OTHERS THEN ROLLBACK;

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

3882: l_proc VARCHAR2(72);
3883: BEGIN
3884: if g_debug then
3885: l_proc := g_package || '.get_user_role';
3886: hr_utility.set_location('Entering: ' || l_proc,10);
3887: hr_utility.set_location('p_user_type : ' || p_user_type,15);
3888: hr_utility.set_location('p_user_id : ' || to_char(p_user_id),20);
3889: end if;
3890:

Line 3887: hr_utility.set_location('p_user_type : ' || p_user_type,15);

3883: BEGIN
3884: if g_debug then
3885: l_proc := g_package || '.get_user_role';
3886: hr_utility.set_location('Entering: ' || l_proc,10);
3887: hr_utility.set_location('p_user_type : ' || p_user_type,15);
3888: hr_utility.set_location('p_user_id : ' || to_char(p_user_id),20);
3889: end if;
3890:
3891: OPEN csr_user_role;

Line 3888: hr_utility.set_location('p_user_id : ' || to_char(p_user_id),20);

3884: if g_debug then
3885: l_proc := g_package || '.get_user_role';
3886: hr_utility.set_location('Entering: ' || l_proc,10);
3887: hr_utility.set_location('p_user_type : ' || p_user_type,15);
3888: hr_utility.set_location('p_user_id : ' || to_char(p_user_id),20);
3889: end if;
3890:
3891: OPEN csr_user_role;
3892: FETCH csr_user_role into p_role_id;

Line 3896: hr_utility.set_location('Using default role....',25);

3892: FETCH csr_user_role into p_role_id;
3893: /*IF csr_user_role%NOTFOUND
3894: THEN
3895: if g_debug then
3896: hr_utility.set_location('Using default role....',25);
3897: end if;
3898: OPEN csr_default_role;
3899: FETCH csr_default_role into p_role_id;
3900: CLOSE csr_default_role;

Line 3904: hr_utility.set_location('p_role_id : ' || to_char(p_role_id),40);

3900: CLOSE csr_default_role;
3901: END IF;*/
3902: CLOSE csr_user_role;
3903: if g_debug then
3904: hr_utility.set_location('p_role_id : ' || to_char(p_role_id),40);
3905: hr_utility.set_location('Leaving: ' || l_proc,50);
3906: end if;
3907: END get_user_role;
3908:

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

3901: END IF;*/
3902: CLOSE csr_user_role;
3903: if g_debug then
3904: hr_utility.set_location('p_role_id : ' || to_char(p_role_id),40);
3905: hr_utility.set_location('Leaving: ' || l_proc,50);
3906: end if;
3907: END get_user_role;
3908:
3909: -----------------------------------------------------------------------------------------------

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

3963: --
3964: --
3965: if g_debug then
3966: l_proc := g_package || '.ss_whatif_process';
3967: hr_utility.set_location('Entering: ' || l_proc,10);
3968: hr_utility.set_location('p_called_from : ' || p_called_from,15);
3969: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),20);
3970: end if;
3971: -- Date used for role based restriction;

Line 3968: hr_utility.set_location('p_called_from : ' || p_called_from,15);

3964: --
3965: if g_debug then
3966: l_proc := g_package || '.ss_whatif_process';
3967: hr_utility.set_location('Entering: ' || l_proc,10);
3968: hr_utility.set_location('p_called_from : ' || p_called_from,15);
3969: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),20);
3970: end if;
3971: -- Date used for role based restriction;
3972: g_effective_date := p_effective_date;

Line 3969: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),20);

3965: if g_debug then
3966: l_proc := g_package || '.ss_whatif_process';
3967: hr_utility.set_location('Entering: ' || l_proc,10);
3968: hr_utility.set_location('p_called_from : ' || p_called_from,15);
3969: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),20);
3970: end if;
3971: -- Date used for role based restriction;
3972: g_effective_date := p_effective_date;
3973: -- Populate Current Benefits

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

3970: end if;
3971: -- Date used for role based restriction;
3972: g_effective_date := p_effective_date;
3973: -- Populate Current Benefits
3974: hr_utility.set_location('BKKKKK Entering '|| l_proc,10);
3975:
3976: hr_utility.set_location('BKKKKK populate_hierarchy ',10);
3977:
3978: populate_hierarchy(p_person_id => p_person_id

Line 3976: hr_utility.set_location('BKKKKK populate_hierarchy ',10);

3972: g_effective_date := p_effective_date;
3973: -- Populate Current Benefits
3974: hr_utility.set_location('BKKKKK Entering '|| l_proc,10);
3975:
3976: hr_utility.set_location('BKKKKK populate_hierarchy ',10);
3977:
3978: populate_hierarchy(p_person_id => p_person_id
3979: ,p_effective_date => p_effective_date
3980: ,p_business_group_id => p_business_group_id

Line 3983: hr_utility.set_location('BKKKKK set current_ben ',10);

3979: ,p_effective_date => p_effective_date
3980: ,p_business_group_id => p_business_group_id
3981: ,p_ler_id => NULL);
3982:
3983: hr_utility.set_location('BKKKKK set current_ben ',10);
3984:
3985: savepoint current_benefits;
3986:
3987: BEGIN

Line 3992: hr_utility.set_location('BKKKKK void potential ',10);

3988: --
3989: fnd_msg_pub.initialize;
3990:
3991: -- Ignore the already detected/unprocessed life event for the person as of the effective date
3992: hr_utility.set_location('BKKKKK void potential ',10);
3993: void_potential_life_events(p_person_id => p_person_id
3994: ,p_business_group_id => p_business_group_id
3995: ,p_effective_date => p_effective_date
3996: );

Line 3999: hr_utility.set_location('BKKKKK set current_ben ',10);

3995: ,p_effective_date => p_effective_date
3996: );
3997:
3998: -- Ignore the already active life events for the person
3999: hr_utility.set_location('BKKKKK set current_ben ',10);
4000: void_active_life_events(p_person_id => p_person_id
4001: ,p_business_group_id => p_business_group_id
4002: ,p_effective_date => p_effective_date
4003: );

Line 4006: hr_utility.set_location('BKKKKK p_called_from '||p_called_from,10);

4002: ,p_effective_date => p_effective_date
4003: );
4004:
4005: -- Post the data changes for the particular transaction
4006: hr_utility.set_location('BKKKKK p_called_from '||p_called_from,10);
4007: IF p_called_from='SSHR' THEN
4008: --
4009: post_data_changes(p_transaction_id => p_transaction_id
4010: ,p_effective_date => p_effective_date

Line 4033: hr_utility.set_location('BKKKKK void_conflict_life_events ',10);

4029: close c_ptnl_le;
4030:
4031: -- p_effective_date:= l_lf_evt_ocrd_dt ;
4032: IF p_ler_id <>0 THEN
4033: hr_utility.set_location('BKKKKK void_conflict_life_events ',10);
4034: void_conflict_life_events(
4035: p_person_id => p_person_id
4036: ,p_business_group_id => p_business_group_id
4037: ,p_winning_ler_id => p_ler_id

Line 4045: hr_utility.set_location('BKKKKK chk_potential_life_events ',10);

4041: END IF;
4042: END IF;
4043:
4044: -- Check whether potential life events have been detected
4045: hr_utility.set_location('BKKKKK chk_potential_life_events ',10);
4046: l_lf_evt_exists := chk_potential_life_events(p_person_id => nvl(l_new_person_id,p_person_id)
4047: ,p_business_group_id => nvl(l_new_business_group_id,p_business_group_id)
4048: ,p_lf_evt_ocrd_dt => l_life_evt_ocrd_dt);
4049:

Line 4059: hr_utility.set_location('BKKKKK p_watif_manage_life_events ',10);

4055: END IF;
4056:
4057: -- Call the benmngle
4058: ben_manage_life_events.g_modified_mode := null;
4059: hr_utility.set_location('BKKKKK p_watif_manage_life_events ',10);
4060: ben_on_line_lf_evt.p_watif_manage_life_events(
4061: p_person_id => nvl(l_new_person_id,p_person_id)
4062: ,p_effective_date => nvl(l_lf_evt_ocrd_dt,p_effective_date)
4063: ,p_business_group_id => nvl(l_new_business_group_id,p_business_group_id)

Line 4097: hr_utility.set_location('BKKKKK rollback current_benefits ',10);

4093:
4094: END;
4095:
4096: -- Rollback Posting to APIs and BENMNGLE run
4097: hr_utility.set_location('BKKKKK rollback current_benefits ',10);
4098:
4099: rollback to current_benefits;
4100:
4101: -- Purge Data from the table

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

4121:
4122: g_hierarchy.DELETE;
4123:
4124: if g_debug then
4125: hr_utility.set_location('Leaving: ' || l_proc,20);
4126: end if;
4127: --
4128: EXCEPTION
4129: --

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

4153: l_lf_evt_ocrd_dt DATE;
4154: BEGIN
4155: if g_debug then
4156: l_proc := g_package || '.validate_data_changes';
4157: hr_utility.set_location('Entering: ' || l_proc,10);
4158: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),15);
4159: end if;
4160:
4161: savepoint current_life_events;

Line 4158: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),15);

4154: BEGIN
4155: if g_debug then
4156: l_proc := g_package || '.validate_data_changes';
4157: hr_utility.set_location('Entering: ' || l_proc,10);
4158: hr_utility.set_location('p_person_id : ' || to_char(p_person_id),15);
4159: end if;
4160:
4161: savepoint current_life_events;
4162:

Line 4167: hr_utility.set_location('Call to void Potential LE',20);

4163: fnd_msg_pub.initialize;
4164:
4165: -- Ignore the already detected/unprocessed life event for the person as of the effective date
4166: if g_debug then
4167: hr_utility.set_location('Call to void Potential LE',20);
4168: end if;
4169: void_potential_life_events(p_person_id => p_person_id
4170: ,p_business_group_id => p_business_group_id
4171: ,p_effective_date => p_effective_date

Line 4175: hr_utility.set_location('Call to post ben changes ' ,25);

4171: ,p_effective_date => p_effective_date
4172: );
4173: -- Post the data changes for the particular transaction
4174: if g_debug then
4175: hr_utility.set_location('Call to post ben changes ' ,25);
4176: end if;
4177: post_ben_changes(p_transaction_id => p_transaction_id
4178: ,p_person_id => p_person_id
4179: ,p_business_group_id => p_business_group_id

Line 4188: hr_utility.set_location('Call to Check conflict LE ' || l_proc,30);

4184:
4185:
4186: -- Check whether potential life events have been detected
4187: if g_debug then
4188: hr_utility.set_location('Call to Check conflict LE ' || l_proc,30);
4189: end if;
4190: l_conflict_life_events :=chk_conflict_life_events( p_person_id =>p_person_id
4191: ,p_business_group_id =>p_business_group_id
4192: ,p_effective_date =>p_effective_date

Line 4196: hr_utility.set_location('cnflt le detected ' ,25);

4192: ,p_effective_date =>p_effective_date
4193: ,p_flag =>l_flag);
4194: if g_debug and l_conflict_life_events then
4195:
4196: hr_utility.set_location('cnflt le detected ' ,25);
4197: end if;
4198:
4199: -- Rollback Posting to APIs
4200:

Line 4210: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

4206: BEGIN
4207: SELECT pqh_pa_whatif_results_s.nextval INTO p_whatif_results_batch_id from dual;
4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
4211: hr_utility.set_message_token('ROUTINE', l_proc);
4212: hr_utility.set_message_token('REASON', SQLERRM);
4213: raise;
4214: END;

Line 4211: hr_utility.set_message_token('ROUTINE', l_proc);

4207: SELECT pqh_pa_whatif_results_s.nextval INTO p_whatif_results_batch_id from dual;
4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
4211: hr_utility.set_message_token('ROUTINE', l_proc);
4212: hr_utility.set_message_token('REASON', SQLERRM);
4213: raise;
4214: END;
4215: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST

Line 4212: hr_utility.set_message_token('REASON', SQLERRM);

4208: EXCEPTION
4209: WHEN OTHERS THEN
4210: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
4211: hr_utility.set_message_token('ROUTINE', l_proc);
4212: hr_utility.set_message_token('REASON', SQLERRM);
4213: raise;
4214: END;
4215: FOR i IN g_hierarchy.FIRST .. g_hierarchy.LAST
4216: LOOP

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

4239:
4240: g_hierarchy.DELETE;
4241:
4242: if g_debug then
4243: hr_utility.set_location('Leaving: ' || l_proc,100);
4244: end if;
4245: --
4246:
4247: EXCEPTION

Line 4250: hr_utility.set_location('Exception: ' ,50);

4246:
4247: EXCEPTION
4248: WHEN OTHERS THEN
4249: if g_debug then
4250: hr_utility.set_location('Exception: ' ,50);
4251: end if;
4252: g_hierarchy.DELETE;
4253: p_whatif_results_batch_id :=-2;
4254: fnd_msg_pub.add;

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

4267: BEGIN
4268:
4269: if g_debug then
4270: l_proc := g_package || '.prepare_transaction';
4271: hr_utility.set_location('Entering: ' || l_proc,10);
4272: hr_utility.set_location('p_txn_id : ' || to_char(p_txn_id),15);
4273: end if;
4274: if (p_txn_id=0) THEN
4275: hr_transaction_api.create_transaction (

Line 4272: hr_utility.set_location('p_txn_id : ' || to_char(p_txn_id),15);

4268:
4269: if g_debug then
4270: l_proc := g_package || '.prepare_transaction';
4271: hr_utility.set_location('Entering: ' || l_proc,10);
4272: hr_utility.set_location('p_txn_id : ' || to_char(p_txn_id),15);
4273: end if;
4274: if (p_txn_id=0) THEN
4275: hr_transaction_api.create_transaction (
4276: p_creator_person_id =>p_person_id

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

4290: DELETE FROM hr_api_transaction_steps
4291: WHERE transaction_id=p_txn_id;
4292: END IF;
4293: if g_debug then
4294: hr_utility.set_location('Leaving: ' || l_proc,50);
4295: end if;
4296: END prepare_transaction;
4297: -------------------------------------------------------------------------------------------------------------
4298: FUNCTION get_first_label(