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

Line 14: hr_utility.set_location('Into get_parent_rmn',210);

10: is
11:
12: l_parent_id number;
13: Begin
14: hr_utility.set_location('Into get_parent_rmn',210);
15:
16: hr_utility.set_location('Into get_parent_rmn copy_entity_txn_id'||p_copy_entity_txn_id,210);
17: hr_utility.set_location('Into get_parent_rmn copy_entity_result_id'||p_copy_entity_result_id,210);
18:

Line 16: hr_utility.set_location('Into get_parent_rmn copy_entity_txn_id'||p_copy_entity_txn_id,210);

12: l_parent_id number;
13: Begin
14: hr_utility.set_location('Into get_parent_rmn',210);
15:
16: hr_utility.set_location('Into get_parent_rmn copy_entity_txn_id'||p_copy_entity_txn_id,210);
17: hr_utility.set_location('Into get_parent_rmn copy_entity_result_id'||p_copy_entity_result_id,210);
18:
19: select information1
20: into l_parent_id

Line 17: hr_utility.set_location('Into get_parent_rmn copy_entity_result_id'||p_copy_entity_result_id,210);

13: Begin
14: hr_utility.set_location('Into get_parent_rmn',210);
15:
16: hr_utility.set_location('Into get_parent_rmn copy_entity_txn_id'||p_copy_entity_txn_id,210);
17: hr_utility.set_location('Into get_parent_rmn copy_entity_result_id'||p_copy_entity_result_id,210);
18:
19: select information1
20: into l_parent_id
21: from ben_copy_entity_results

Line 26: hr_utility.set_location('Into get_parent_rmn parent_id'||l_parent_id,210);

22: where copy_entity_txn_id = p_copy_entity_txn_id
23: and copy_entity_result_id = p_copy_entity_result_id
24: and table_alias = 'RMN';
25:
26: hr_utility.set_location('Into get_parent_rmn parent_id'||l_parent_id,210);
27:
28: hr_utility.set_location('leaving get_parent_rmn',1);
29: return l_parent_id;
30:

Line 28: hr_utility.set_location('leaving get_parent_rmn',1);

24: and table_alias = 'RMN';
25:
26: hr_utility.set_location('Into get_parent_rmn parent_id'||l_parent_id,210);
27:
28: hr_utility.set_location('leaving get_parent_rmn',1);
29: return l_parent_id;
30:
31: exception
32: when no_data_found then

Line 33: hr_utility.set_location('Into get_parent_rmn exception',210);

29: return l_parent_id;
30:
31: exception
32: when no_data_found then
33: hr_utility.set_location('Into get_parent_rmn exception',210);
34: return null;
35:
36: End get_parent_rmn;
37:

Line 73: hr_utility.set_location('Entering get_elig_det_for_rmn',1);

69: p_elig_prfl_id out nocopy number,
70: p_criteria_short_code out nocopy varchar2)
71: is
72: Begin
73: hr_utility.set_location('Entering get_elig_det_for_rmn',1);
74:
75: select CRITERIA_SHORT_CODE, ELIGY_PRFL_ID
76: into p_criteria_short_code, p_elig_prfl_id
77: from pqh_rate_matrix_nodes

Line 81: hr_utility.set_location('leaving get_elig_det_for_rmn',1);

77: from pqh_rate_matrix_nodes
78: where rate_matrix_node_id = p_rmn_id
79: and business_group_id = p_business_group_id;
80:
81: hr_utility.set_location('leaving get_elig_det_for_rmn',1);
82: End get_elig_det_for_rmn;
83:
84: procedure rmn_writeback(p_copy_entity_result_id in number,
85: p_rmn_id in number,

Line 89: hr_utility.set_location('inside rmn_writeback ',210);

85: p_rmn_id in number,
86: p_copy_entity_txn_id in number) is
87:
88: Begin
89: hr_utility.set_location('inside rmn_writeback ',210);
90:
91: hr_utility.set_location('writing back on ben_copy_entity results ',210);
92: hr_utility.set_location('writing back parent_id '||p_rmn_id,210);
93:

Line 91: hr_utility.set_location('writing back on ben_copy_entity results ',210);

87:
88: Begin
89: hr_utility.set_location('inside rmn_writeback ',210);
90:
91: hr_utility.set_location('writing back on ben_copy_entity results ',210);
92: hr_utility.set_location('writing back parent_id '||p_rmn_id,210);
93:
94: update ben_copy_entity_results
95: set information1 = p_rmn_id

Line 92: hr_utility.set_location('writing back parent_id '||p_rmn_id,210);

88: Begin
89: hr_utility.set_location('inside rmn_writeback ',210);
90:
91: hr_utility.set_location('writing back on ben_copy_entity results ',210);
92: hr_utility.set_location('writing back parent_id '||p_rmn_id,210);
93:
94: update ben_copy_entity_results
95: set information1 = p_rmn_id
96: where COPY_ENTITY_RESULT_ID = p_copy_entity_result_id

Line 111: hr_utility.set_location('leaving rmn_writeback ',210);

107: where PARENT_ENTITY_RESULT_ID = p_copy_entity_result_id
108: and copy_entity_txn_id = p_copy_entity_txn_id
109: and table_alias in ('RMR');
110:
111: hr_utility.set_location('leaving rmn_writeback ',210);
112: End rmn_writeback;
113:
114:
115: function get_pl_typ_name return varchar2 is

Line 119: hr_utility.set_location(' Inside '||l_proc,210);

115: function get_pl_typ_name return varchar2 is
116: l_proc varchar2(72) := g_package||'get_pl_typ_name';
117: l_name varchar2(80) ;
118: begin
119: hr_utility.set_location(' Inside '||l_proc,210);
120:
121: select meaning into l_name
122: from hr_lookups
123: where lookup_type = 'PQH_GSP_LE_PT_NAME'

Line 126: hr_utility.set_location(' Leaving '||l_proc,210);

122: from hr_lookups
123: where lookup_type = 'PQH_GSP_LE_PT_NAME'
124: and lookup_code = 'RBC_PT';
125:
126: hr_utility.set_location(' Leaving '||l_proc,210);
127: return l_name ;
128: exception
129: when others then
130: hr_utility.set_location('issue in lookup ',10);

Line 130: hr_utility.set_location('issue in lookup ',10);

126: hr_utility.set_location(' Leaving '||l_proc,210);
127: return l_name ;
128: exception
129: when others then
130: hr_utility.set_location('issue in lookup ',10);
131: raise;
132: end get_pl_typ_name;
133:
134: function get_short_code (p_table_alias in varchar2)return varchar2 is

Line 142: hr_utility.set_location(' Inside get_short_code ',210);

138: l_seq varchar2(1000);
139: l_seq_no number;
140:
141: begin
142: hr_utility.set_location(' Inside get_short_code ',210);
143:
144: if p_table_alias = 'RMN' then
145: l_seq := 'PQH_RATE_MATRIX_NODES_S.NEXTVAL';
146: elsif p_table_alias = 'RMV' then

Line 156: hr_utility.set_location('l_sql is '||substr(l_sql,1,50),20);

152: l_code := g_pln_short_code;
153:
154: l_sql := 'select '||l_seq||' from dual';
155:
156: hr_utility.set_location('l_sql is '||substr(l_sql,1,50),20);
157: hr_utility.set_location('l_sql is '||substr(l_sql,51,50),20);
158: hr_utility.set_location('l_sql is '||substr(l_sql,101,50),20);
159:
160: EXECUTE IMMEDIATE l_sql

Line 157: hr_utility.set_location('l_sql is '||substr(l_sql,51,50),20);

153:
154: l_sql := 'select '||l_seq||' from dual';
155:
156: hr_utility.set_location('l_sql is '||substr(l_sql,1,50),20);
157: hr_utility.set_location('l_sql is '||substr(l_sql,51,50),20);
158: hr_utility.set_location('l_sql is '||substr(l_sql,101,50),20);
159:
160: EXECUTE IMMEDIATE l_sql
161: INTO l_seq_no;

Line 158: hr_utility.set_location('l_sql is '||substr(l_sql,101,50),20);

154: l_sql := 'select '||l_seq||' from dual';
155:
156: hr_utility.set_location('l_sql is '||substr(l_sql,1,50),20);
157: hr_utility.set_location('l_sql is '||substr(l_sql,51,50),20);
158: hr_utility.set_location('l_sql is '||substr(l_sql,101,50),20);
159:
160: EXECUTE IMMEDIATE l_sql
161: INTO l_seq_no;
162:

Line 165: hr_utility.set_location('For '||p_table_alias||' short_code is '||l_code,210);

161: INTO l_seq_no;
162:
163: l_code := l_code||to_char(l_seq_no);
164:
165: hr_utility.set_location('For '||p_table_alias||' short_code is '||l_code,210);
166:
167: hr_utility.set_location(' Leaving get_short_code ',210);
168:
169: return l_code;

Line 167: hr_utility.set_location(' Leaving get_short_code ',210);

163: l_code := l_code||to_char(l_seq_no);
164:
165: hr_utility.set_location('For '||p_table_alias||' short_code is '||l_code,210);
166:
167: hr_utility.set_location(' Leaving get_short_code ',210);
168:
169: return l_code;
170:
171: exception

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

184: l_effective_start_date date;
185: l_effective_end_date date;
186: l_object_version_number number;
187: begin
188: hr_utility.set_location('Entering:'|| l_proc, 10);
189:
190: ben_plan_type_api.create_plan_type(
191: p_pl_typ_id => l_pl_typ_id
192: ,p_effective_start_date => l_effective_start_date

Line 204: hr_utility.set_location('Leaving:'|| l_proc, 10);

200: ,p_no_mx_enrl_num_dfnd_flag => 'N'
201: ,p_no_mn_enrl_num_dfnd_flag => 'N'
202: );
203:
204: hr_utility.set_location('Leaving:'|| l_proc, 10);
205:
206: return l_pl_typ_id;
207: end create_plan_type;
208: --

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

212: return date is
213: l_proc varchar2(72) := g_package||'get_rbc_plntyp_str_date';
214: l_plan_type_date DATE := null;
215: begin
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: select min(effective_start_date)
218: into l_plan_type_date
219: from ben_pl_typ_f
220: where business_group_id = p_business_group_id

Line 223: hr_utility.set_location('Plan Type date is :'|| l_plan_type_date, 20);

219: from ben_pl_typ_f
220: where business_group_id = p_business_group_id
221: and opt_typ_cd ='RBC'
222: and pl_typ_stat_cd ='A';
223: hr_utility.set_location('Plan Type date is :'|| l_plan_type_date, 20);
224: return l_plan_type_date ;
225: exception
226: when others then
227: hr_utility.set_location('Problem in determining Plan Type date ',40);

Line 227: hr_utility.set_location('Problem in determining Plan Type date ',40);

223: hr_utility.set_location('Plan Type date is :'|| l_plan_type_date, 20);
224: return l_plan_type_date ;
225: exception
226: when others then
227: hr_utility.set_location('Problem in determining Plan Type date ',40);
228: raise;
229: end get_rbc_plntyp_str_date ;
230: --
231: procedure setup_check(p_copy_entity_txn_id in number

Line 247: hr_utility.set_location('Entering: setup_check', 10);

243: l_pl_typ_name varchar2(80) ;
244:
245: begin
246:
247: hr_utility.set_location('Entering: setup_check', 10);
248: if l_status is null then
249: begin
250: select pl_typ_id,name,effective_start_date
251: into l_pt_id,l_pt_name,l_effective_start_date

Line 257: hr_utility.set_location('pl_typ name '||substr(l_pt_name,1,40),10);

253: where trunc(effective_end_date) = hr_general.end_of_time
254: and business_group_id = p_business_group_id
255: and opt_typ_cd ='RBC';
256:
257: hr_utility.set_location('pl_typ name '||substr(l_pt_name,1,40),10);
258:
259: if l_effective_start_date <> l_start_of_time then
260: l_status := 'WRONG-DATE-PT' ;
261: end if ;

Line 265: hr_utility.set_location('No PT of RBC ',20);

261: end if ;
262:
263: exception
264: when no_data_found then
265: hr_utility.set_location('No PT of RBC ',20);
266: l_pl_typ_name := get_pl_typ_name();
267: l_pt_id := create_plan_type (p_business_group_id,p_copy_entity_txn_id,l_pl_typ_name);
268: when too_many_rows then
269: hr_utility.set_location('many PT of RBC ',20);

Line 269: hr_utility.set_location('many PT of RBC ',20);

265: hr_utility.set_location('No PT of RBC ',20);
266: l_pl_typ_name := get_pl_typ_name();
267: l_pt_id := create_plan_type (p_business_group_id,p_copy_entity_txn_id,l_pl_typ_name);
268: when too_many_rows then
269: hr_utility.set_location('many PT of RBC ',20);
270: l_status := 'MANY-PT';
271: when others then
272: hr_utility.set_location('issue in Getting RBC PT ',20);
273: l_status := 'PT-ERR';

Line 272: hr_utility.set_location('issue in Getting RBC PT ',20);

268: when too_many_rows then
269: hr_utility.set_location('many PT of RBC ',20);
270: l_status := 'MANY-PT';
271: when others then
272: hr_utility.set_location('issue in Getting RBC PT ',20);
273: l_status := 'PT-ERR';
274: end;
275: end if;
276:

Line 278: hr_utility.set_location('setup is fine, update staging area',10);

274: end;
275: end if;
276:
277: if l_status is null then
278: hr_utility.set_location('setup is fine, update staging area',10);
279: -- p_plan_tp_created_flag := l_plan_tp_created_flag;
280: p_status := 'Y';
281: else
282: p_status := l_status;

Line 283: hr_utility.set_location('control goes back with status'||l_status,10);

279: -- p_plan_tp_created_flag := l_plan_tp_created_flag;
280: p_status := 'Y';
281: else
282: p_status := l_status;
283: hr_utility.set_location('control goes back with status'||l_status,10);
284: end if;
285:
286: hr_utility.set_location('Leaving: setup_check', 10);
287:

Line 286: hr_utility.set_location('Leaving: setup_check', 10);

282: p_status := l_status;
283: hr_utility.set_location('control goes back with status'||l_status,10);
284: end if;
285:
286: hr_utility.set_location('Leaving: setup_check', 10);
287:
288: end setup_check;
289:
290:

Line 309: hr_utility.set_location('Entering: Delete_RMR', 10);

305: l_effective_start_date date;
306: l_effective_end_date date;
307: Begin
308:
309: hr_utility.set_location('Entering: Delete_RMR', 10);
310:
311: for del_rec in del_rmr loop
312: l_ovn := del_rec.Information265;
313:

Line 324: hr_utility.set_location('Leaving: Delete_RMR', 10);

320: ,p_datetrack_mode => p_Date_Track_Mode);
321:
322: end loop;
323:
324: hr_utility.set_location('Leaving: Delete_RMR', 10);
325: End Delete_RMR;
326:
327: procedure Delete_RMV(p_copy_entity_txn_id in number,
328: p_effective_date in date,

Line 339: hr_utility.set_location('Entering: Delete_RMV', 10);

335: and table_alias = 'RMV'
336: and dml_operation = 'DELETE';
337: Begin
338:
339: hr_utility.set_location('Entering: Delete_RMV', 10);
340:
341: for del_rec in del_rmv loop
342: PQH_RT_MATRIX_NODE_VALUES_API.delete_rt_matrix_node_value
343: (p_effective_date => p_effective_date

Line 355: hr_utility.set_location('Leaving: Delete_RMV', 10);

351: )*/
352:
353: end loop;
354:
355: hr_utility.set_location('Leaving: Delete_RMV', 10);
356: End Delete_RMV;
357:
358: procedure Delete_RMN(p_copy_entity_txn_id in number,
359: p_effective_date in date,

Line 371: hr_utility.set_location('Entering: Delete_RMN', 10);

367: and dml_operation = 'DELETE';
368:
369: Begin
370:
371: hr_utility.set_location('Entering: Delete_RMN', 10);
372: for del_rec in del_rmn loop
373:
374: PQH_RATE_MATRIX_NODES_API.delete_rate_matrix_node
375: (p_effective_date => p_effective_date

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

379:
380:
381: end loop;
382:
383: hr_utility.set_location('Entering: Delete_RMN', 10);
384:
385: End Delete_RMN;
386:
387: procedure Delete_plan(p_copy_entity_txn_id in number,

Line 404: hr_utility.set_location('inside delete_plan',1);

400: l_effective_start_date date;
401: l_effective_end_date date;
402:
403: Begin
404: hr_utility.set_location('inside delete_plan',1);
405: for del_rec in del_plan loop
406: l_ovn := del_rec.information265;
407:
408: ben_Plan_api.delete_Plan

Line 419: hr_utility.set_location('leaving delete_plan',1);

415: );
416:
417:
418: end loop;
419: hr_utility.set_location('leaving delete_plan',1);
420: End Delete_plan;
421:
422:
423: procedure pre_push_data(p_copy_entity_txn_id in number,

Line 435: hr_utility.set_location('inside pre-push',1);

431: l_Del_Dt_Mode Varchar2(30);
432: l_status varchar2(30);
433:
434: begin
435: hr_utility.set_location('inside pre-push',1);
436:
437: If P_Date_Track_Mode = 'UPDATE_OVERRIDE' Then
438: l_Del_Dt_Mode := 'DELETE';
439: Else

Line 469: hr_utility.set_message(8302,'PQH_RBC_WRONG_ST_DT_PT');

465: p_status => l_status);
466:
467: if l_status <> 'Y' then
468: if l_status = 'WRONG-DATE-PT' then
469: hr_utility.set_message(8302,'PQH_RBC_WRONG_ST_DT_PT');
470: hr_multi_message.add;
471: elsif l_status = 'MANY-PT' then
472: hr_utility.set_message(8302,'PQH_RBC_MANY_PT');
473: hr_multi_message.add;

Line 472: hr_utility.set_message(8302,'PQH_RBC_MANY_PT');

468: if l_status = 'WRONG-DATE-PT' then
469: hr_utility.set_message(8302,'PQH_RBC_WRONG_ST_DT_PT');
470: hr_multi_message.add;
471: elsif l_status = 'MANY-PT' then
472: hr_utility.set_message(8302,'PQH_RBC_MANY_PT');
473: hr_multi_message.add;
474: end if;
475: l_return := 'NO';
476: end if;

Line 479: hr_utility.set_location('leaving pre-push',100);

475: l_return := 'NO';
476: end if;
477:
478: p_status := l_return;
479: hr_utility.set_location('leaving pre-push',100);
480:
481: exception
482: when others then
483: l_return := 'NO';

Line 515: hr_utility.set_location('inside'||l_proc,10);

511: and dml_operation in ('CREATE','UPDATE')
512: and information161 = p_rmn_id;
513: begin
514:
515: hr_utility.set_location('inside'||l_proc,10);
516:
517: for rmv_rec in csr_rmv loop
518: l_ovn := rmv_rec.Information265;
519: l_rmv_id := rmv_rec.Information1;

Line 521: hr_utility.set_location('new node value is being created'||l_proc,20);

517: for rmv_rec in csr_rmv loop
518: l_ovn := rmv_rec.Information265;
519: l_rmv_id := rmv_rec.Information1;
520: if rmv_rec.dml_operation = 'CREATE' then
521: hr_utility.set_location('new node value is being created'||l_proc,20);
522: l_short_code := rmv_rec.INFORMATION12;
523: hr_utility.set_location('Short_code is '||l_short_code,20);
524: /* Short code genration for the rows witout short code */
525:

Line 523: hr_utility.set_location('Short_code is '||l_short_code,20);

519: l_rmv_id := rmv_rec.Information1;
520: if rmv_rec.dml_operation = 'CREATE' then
521: hr_utility.set_location('new node value is being created'||l_proc,20);
522: l_short_code := rmv_rec.INFORMATION12;
523: hr_utility.set_location('Short_code is '||l_short_code,20);
524: /* Short code genration for the rows witout short code */
525:
526: if l_short_code is null then
527: hr_utility.set_location('Short_code is null',20);

Line 527: hr_utility.set_location('Short_code is null',20);

523: hr_utility.set_location('Short_code is '||l_short_code,20);
524: /* Short code genration for the rows witout short code */
525:
526: if l_short_code is null then
527: hr_utility.set_location('Short_code is null',20);
528: l_short_code := get_short_code('RMV');
529: hr_utility.set_location('Short_code generated'||l_short_code,20);
530: end if;
531: /*

Line 529: hr_utility.set_location('Short_code generated'||l_short_code,20);

525:
526: if l_short_code is null then
527: hr_utility.set_location('Short_code is null',20);
528: l_short_code := get_short_code('RMV');
529: hr_utility.set_location('Short_code generated'||l_short_code,20);
530: end if;
531: /*
532:
533: Assigning number values depending upon the criteria selected.

Line 557: hr_utility.set_location('Node value id'||l_rmv_id,20);

553: l_number_value2 := rmv_rec.information174;
554: end if;
555:
556: begin
557: hr_utility.set_location('Node value id'||l_rmv_id,20);
558: PQH_RT_MATRIX_NODE_VALUES_API.create_rt_matrix_node_value
559: (p_effective_date => p_effective_date
560: ,p_NODE_VALUE_ID => l_rmv_id
561: ,p_RATE_MATRIX_NODE_ID => rmv_rec.INFORMATION161

Line 602: hr_utility.set_location('rmv id'||l_rmv_id,20);

598: ,p_effective_date => p_effective_date
599: ,p_elig_prfl_id => l_elig_prfl_id
600: );
601:
602: hr_utility.set_location('rmv id'||l_rmv_id,20);
603: exception
604: when others then
605: hr_utility.set_location('issues in creating rmv'||rmv_rec.information5,30);
606: raise;

Line 605: hr_utility.set_location('issues in creating rmv'||rmv_rec.information5,30);

601:
602: hr_utility.set_location('rmv id'||l_rmv_id,20);
603: exception
604: when others then
605: hr_utility.set_location('issues in creating rmv'||rmv_rec.information5,30);
606: raise;
607: end;
608: hr_utility.set_location('rmv id is '||l_rmv_id,30);
609: elsif rmv_rec.dml_operation in ('UPDATE')

Line 608: hr_utility.set_location('rmv id is '||l_rmv_id,30);

604: when others then
605: hr_utility.set_location('issues in creating rmv'||rmv_rec.information5,30);
606: raise;
607: end;
608: hr_utility.set_location('rmv id is '||l_rmv_id,30);
609: elsif rmv_rec.dml_operation in ('UPDATE')
610: and l_ovn is not null
611: and l_rmv_id is not null then
612: hr_utility.set_location('Rate Node Value is being updated'||l_rmv_id,60);

Line 612: hr_utility.set_location('Rate Node Value is being updated'||l_rmv_id,60);

608: hr_utility.set_location('rmv id is '||l_rmv_id,30);
609: elsif rmv_rec.dml_operation in ('UPDATE')
610: and l_ovn is not null
611: and l_rmv_id is not null then
612: hr_utility.set_location('Rate Node Value is being updated'||l_rmv_id,60);
613: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
614:
615: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RT_MATRIX_NODE_VALUES',
616: p_key_column_name => 'NODE_VALUE_ID',

Line 613: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);

609: elsif rmv_rec.dml_operation in ('UPDATE')
610: and l_ovn is not null
611: and l_rmv_id is not null then
612: hr_utility.set_location('Rate Node Value is being updated'||l_rmv_id,60);
613: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
614:
615: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RT_MATRIX_NODE_VALUES',
616: p_key_column_name => 'NODE_VALUE_ID',
617: p_key_column_value => l_rmv_id);

Line 619: hr_utility.set_location(' ovn is '||l_db_ovn,30);

615: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RT_MATRIX_NODE_VALUES',
616: p_key_column_name => 'NODE_VALUE_ID',
617: p_key_column_value => l_rmv_id);
618:
619: hr_utility.set_location(' ovn is '||l_db_ovn,30);
620:
621: if l_db_ovn <> l_ovn then
622:
623: hr_utility.set_location('Invalid ovn no ', 20);

Line 623: hr_utility.set_location('Invalid ovn no ', 20);

619: hr_utility.set_location(' ovn is '||l_db_ovn,30);
620:
621: if l_db_ovn <> l_ovn then
622:
623: hr_utility.set_location('Invalid ovn no ', 20);
624: else
625: begin
626: PQH_RT_MATRIX_NODE_VALUES_API.update_rt_matrix_node_value
627: (p_effective_date => p_effective_date

Line 647: hr_utility.set_location('issues in updating Node lalues'||l_rmv_id,70);

643: ,p_BUSINESS_GROUP_ID => rmv_rec.INFORMATION4
644: ,p_object_version_number => l_ovn );
645: exception
646: when others then
647: hr_utility.set_location('issues in updating Node lalues'||l_rmv_id,70);
648: hr_utility.set_location('rmv ovn'||l_ovn,75);
649: hr_utility.set_location('rmv name'||substr(rmv_rec.information5,1,45),78);
650: raise;
651: end;

Line 648: hr_utility.set_location('rmv ovn'||l_ovn,75);

644: ,p_object_version_number => l_ovn );
645: exception
646: when others then
647: hr_utility.set_location('issues in updating Node lalues'||l_rmv_id,70);
648: hr_utility.set_location('rmv ovn'||l_ovn,75);
649: hr_utility.set_location('rmv name'||substr(rmv_rec.information5,1,45),78);
650: raise;
651: end;
652: end if;

Line 649: hr_utility.set_location('rmv name'||substr(rmv_rec.information5,1,45),78);

645: exception
646: when others then
647: hr_utility.set_location('issues in updating Node lalues'||l_rmv_id,70);
648: hr_utility.set_location('rmv ovn'||l_ovn,75);
649: hr_utility.set_location('rmv name'||substr(rmv_rec.information5,1,45),78);
650: raise;
651: end;
652: end if;
653: else

Line 662: hr_utility.set_location('leaving '||l_proc,100);

658:
659:
660: end if;
661: end loop;
662: hr_utility.set_location('leaving '||l_proc,100);
663: exception
664: when others then
665: raise;
666:

Line 676: hr_utility.set_location('Entering get_plan_name_for_rmn ',100);

672: p_pl_id out nocopy ben_pl_f.pl_id%type,
673: p_pl_name out nocopy ben_pl_f.name%type)
674: is
675: begin
676: hr_utility.set_location('Entering get_plan_name_for_rmn ',100);
677:
678: select pl.pl_id pl_id, pl.name pl_name
679: into p_pl_id, p_pl_name
680: from ben_pl_f pl,

Line 690: hr_utility.set_location('leaving get_plan_name_for_rmn',100);

686: and pl.business_group_id = p_business_group_id
687: and rmn.business_group_id = pl.business_group_id;
688:
689:
690: hr_utility.set_location('leaving get_plan_name_for_rmn',100);
691:
692: exception
693: when others then
694: hr_utility.set_location('Issues in getting plan details',100);

Line 694: hr_utility.set_location('Issues in getting plan details',100);

690: hr_utility.set_location('leaving get_plan_name_for_rmn',100);
691:
692: exception
693: when others then
694: hr_utility.set_location('Issues in getting plan details',100);
695: raise;
696: End get_plan_det_for_rmn;
697:
698: Function get_crit_rate_def_name (p_crd_id in number,

Line 704: hr_utility.set_location('Entering get_crit_rate_def_name',100);

700: return varchar2
701: is
702: l_crd_name varchar2(1000);
703: Begin
704: hr_utility.set_location('Entering get_crit_rate_def_name',100);
705:
706: select name crd_name
707: into l_crd_name
708: from pqh_criteria_rate_defn_vl

Line 712: hr_utility.set_location('leaving get_crit_rate_def_name',100);

708: from pqh_criteria_rate_defn_vl
709: where CRITERIA_RATE_DEFN_ID = p_crd_id
710: and business_group_id = p_business_group_id;
711:
712: hr_utility.set_location('leaving get_crit_rate_def_name',100);
713:
714: return l_crd_name;
715:
716: End get_crit_rate_def_name;

Line 724: hr_utility.set_location('Entering get_rmn_short_code',100);

720: p_business_group_id in number)
721: return varchar2 is
722: l_rmn_short_code varchar2(1000);
723: Begin
724: hr_utility.set_location('Entering get_rmn_short_code',100);
725:
726: Select short_code
727: into l_rmn_short_code
728: from pqh_rate_matrix_nodes

Line 732: hr_utility.set_location('leaving get_rmn_short_code',100);

728: from pqh_rate_matrix_nodes
729: where rate_matrix_node_id = p_rmn_id
730: and business_group_id = p_business_group_id;
731:
732: hr_utility.set_location('leaving get_rmn_short_code',100);
733: return l_rmn_short_code;
734:
735:
736: End get_rmn_short_code;

Line 776: hr_utility.set_location('inside'||l_proc,10);

772: and dml_operation in ('CREATE','UPDATE')
773: and information161 = p_rmn_id;
774:
775: begin
776: hr_utility.set_location('inside'||l_proc,10);
777: for rmr_rec in csr_rmr loop
778: l_ovn := rmr_rec.Information265;
779: l_rmr_id := rmr_rec.Information1;
780: if rmr_rec.dml_operation = 'CREATE' then

Line 781: hr_utility.set_location('new plan is being created'||l_proc,20);

777: for rmr_rec in csr_rmr loop
778: l_ovn := rmr_rec.Information265;
779: l_rmr_id := rmr_rec.Information1;
780: if rmr_rec.dml_operation = 'CREATE' then
781: hr_utility.set_location('new plan is being created'||l_proc,20);
782: begin
783: hr_utility.set_location('rmr id'||l_rmr_id,20);
784:
785: select min(effective_start_date)

Line 783: hr_utility.set_location('rmr id'||l_rmr_id,20);

779: l_rmr_id := rmr_rec.Information1;
780: if rmr_rec.dml_operation = 'CREATE' then
781: hr_utility.set_location('new plan is being created'||l_proc,20);
782: begin
783: hr_utility.set_location('rmr id'||l_rmr_id,20);
784:
785: select min(effective_start_date)
786: into l_esd
787: from ben_pl_f pl, pqh_rate_matrix_nodes rmn

Line 811: hr_utility.set_location('rmr id'||l_rmr_id,20);

807: ,p_RATE_VALUE => nvl(rmr_rec.Information297,0)
808: ,p_BUSINESS_GROUP_ID => rmr_rec.Information4
809: ,p_object_version_number => l_ovn
810: );
811: hr_utility.set_location('rmr id'||l_rmr_id,20);
812:
813: get_plan_det_for_rmn(p_rmn_id => p_rmn_id,
814: p_business_group_id => rmr_rec.Information4,
815: p_effective_date => l_effective_date,

Line 819: hr_utility.set_location('Plan id and name are '||l_pl_id||' '||l_pl_name,20);

815: p_effective_date => l_effective_date,
816: p_pl_id => l_pl_id,
817: p_pl_name => l_pl_name);
818:
819: hr_utility.set_location('Plan id and name are '||l_pl_id||' '||l_pl_name,20);
820:
821: l_crd_name := get_crit_rate_def_name (p_crd_id => rmr_rec.Information162,
822: p_business_group_id => rmr_rec.Information4);
823:

Line 825: hr_utility.set_location('Criteria rate definition name is '||l_crd_name,20);

821: l_crd_name := get_crit_rate_def_name (p_crd_id => rmr_rec.Information162,
822: p_business_group_id => rmr_rec.Information4);
823:
824:
825: hr_utility.set_location('Criteria rate definition name is '||l_crd_name,20);
826:
827: l_short_code_rmn := get_rmn_short_code(p_rmn_id => p_rmn_id,
828: p_business_group_id => rmr_rec.Information4);
829:

Line 831: hr_utility.set_location('Rate Matrix Node short code is '||l_short_code_rmn,20);

827: l_short_code_rmn := get_rmn_short_code(p_rmn_id => p_rmn_id,
828: p_business_group_id => rmr_rec.Information4);
829:
830:
831: hr_utility.set_location('Rate Matrix Node short code is '||l_short_code_rmn,20);
832:
833: l_base_rt_exist := chk_acty_base_rate_exist(
834: p_pl_id => l_pl_id,
835: p_effective_date => l_effective_date,

Line 856: hr_utility.set_location('Base rate id and name is '||l_abr_id||' '||l_pl_name||' - '||l_crd_name,20);

852: ,P_MAPPING_TABLE_NAME => 'PQH_CRITERIA_RATE_DEFN'
853: ,P_MAPPING_TABLE_PK_ID => rmr_rec.Information162
854: ,p_object_version_number => l_ovn_abr
855: );
856: hr_utility.set_location('Base rate id and name is '||l_abr_id||' '||l_pl_name||' - '||l_crd_name,20);
857: else
858: hr_utility.set_location('Base rate already exist',20);
859: end if;
860:

Line 858: hr_utility.set_location('Base rate already exist',20);

854: ,p_object_version_number => l_ovn_abr
855: );
856: hr_utility.set_location('Base rate id and name is '||l_abr_id||' '||l_pl_name||' - '||l_crd_name,20);
857: else
858: hr_utility.set_location('Base rate already exist',20);
859: end if;
860:
861: exception
862: when others then

Line 863: hr_utility.set_location('issues in creating Rate_matrix node'||l_rmr_id,30);

859: end if;
860:
861: exception
862: when others then
863: hr_utility.set_location('issues in creating Rate_matrix node'||l_rmr_id,30);
864: raise;
865: end;
866: hr_utility.set_location('rmr id is '||l_rmr_id,30);
867: elsif rmr_rec.dml_operation in ('UPDATE')

Line 866: hr_utility.set_location('rmr id is '||l_rmr_id,30);

862: when others then
863: hr_utility.set_location('issues in creating Rate_matrix node'||l_rmr_id,30);
864: raise;
865: end;
866: hr_utility.set_location('rmr id is '||l_rmr_id,30);
867: elsif rmr_rec.dml_operation in ('UPDATE')
868: and l_ovn is not null
869: and l_rmr_id is not null then
870: hr_utility.set_location('Rate Matrix node is being updated'||l_rmr_id,60);

Line 870: hr_utility.set_location('Rate Matrix node is being updated'||l_rmr_id,60);

866: hr_utility.set_location('rmr id is '||l_rmr_id,30);
867: elsif rmr_rec.dml_operation in ('UPDATE')
868: and l_ovn is not null
869: and l_rmr_id is not null then
870: hr_utility.set_location('Rate Matrix node is being updated'||l_rmr_id,60);
871: hr_utility.set_location('Rate Matrix rate dt mode '||p_datetrack_mode,60);
872: if p_datetrack_mode <> 'CORRECTION' then
873: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
874: p_key_column_name => 'RATE_MATRIX_RATE_ID',

Line 871: hr_utility.set_location('Rate Matrix rate dt mode '||p_datetrack_mode,60);

867: elsif rmr_rec.dml_operation in ('UPDATE')
868: and l_ovn is not null
869: and l_rmr_id is not null then
870: hr_utility.set_location('Rate Matrix node is being updated'||l_rmr_id,60);
871: hr_utility.set_location('Rate Matrix rate dt mode '||p_datetrack_mode,60);
872: if p_datetrack_mode <> 'CORRECTION' then
873: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
874: p_key_column_name => 'RATE_MATRIX_RATE_ID',
875: p_key_column_value => l_rmr_id,

Line 877: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

873: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
874: p_key_column_name => 'RATE_MATRIX_RATE_ID',
875: p_key_column_value => l_rmr_id,
876: p_effective_date => p_effective_date);
877: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
878: else
879: l_dt_mode := p_datetrack_mode;
880: end if;
881: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);

Line 881: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);

877: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
878: else
879: l_dt_mode := p_datetrack_mode;
880: end if;
881: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
883: p_key_column_name => 'RATE_MATRIX_RATE_ID',
884: p_key_column_value => l_rmr_id,
885: p_effective_date => p_effective_date);

Line 886: hr_utility.set_location(' ovn is '||l_db_ovn,30);

882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
883: p_key_column_name => 'RATE_MATRIX_RATE_ID',
884: p_key_column_value => l_rmr_id,
885: p_effective_date => p_effective_date);
886: hr_utility.set_location(' ovn is '||l_db_ovn,30);
887: if l_db_ovn <> l_ovn then
888: hr_utility.set_location('object verson not same ', 20);
889: else
890: begin

Line 888: hr_utility.set_location('object verson not same ', 20);

884: p_key_column_value => l_rmr_id,
885: p_effective_date => p_effective_date);
886: hr_utility.set_location(' ovn is '||l_db_ovn,30);
887: if l_db_ovn <> l_ovn then
888: hr_utility.set_location('object verson not same ', 20);
889: else
890: begin
891: PQH_RATE_MATRIX_RATES_API.update_rate_matrix_rate
892: (p_effective_date => p_effective_date

Line 907: hr_utility.set_location('issues in updating rate matrix rate'||l_rmr_id,70);

903: ,p_BUSINESS_GROUP_ID => rmr_rec.Information4
904: ,p_object_version_number => l_ovn);
905: exception
906: when others then
907: hr_utility.set_location('issues in updating rate matrix rate'||l_rmr_id,70);
908: hr_utility.set_location('rmr ovn'||l_ovn,75);
909: raise;
910: end;
911: end if;

Line 908: hr_utility.set_location('rmr ovn'||l_ovn,75);

904: ,p_object_version_number => l_ovn);
905: exception
906: when others then
907: hr_utility.set_location('issues in updating rate matrix rate'||l_rmr_id,70);
908: hr_utility.set_location('rmr ovn'||l_ovn,75);
909: raise;
910: end;
911: end if;
912: else

Line 918: hr_utility.set_location('leaving '||l_proc,100);

914: ||' rmr_id'||l_rmr_id
915: ||' rmr_ovn'||l_ovn;
916: end if;
917: end loop;
918: hr_utility.set_location('leaving '||l_proc,100);
919: exception
920: when others then
921: raise;
922: End stage_to_rmr;

Line 936: -- hr_utility.trace_on(NULL,'SJRBC');

932: l_continue varchar2(30) := 'Y';
933: l_status varchar2(30) := 'YES';
934: begin
935:
936: -- hr_utility.trace_on(NULL,'SJRBC');
937:
938: hr_utility.set_location('inside rbc_data_push',10);
939: if p_datetrack_mode = 'OVERWRITE' then
940: l_datetrack_mode := 'CORRECTION';

Line 938: hr_utility.set_location('inside rbc_data_push',10);

934: begin
935:
936: -- hr_utility.trace_on(NULL,'SJRBC');
937:
938: hr_utility.set_location('inside rbc_data_push',10);
939: if p_datetrack_mode = 'OVERWRITE' then
940: l_datetrack_mode := 'CORRECTION';
941: elsif p_datetrack_mode = 'DATETRACK' then
942: l_datetrack_mode := 'UPDATE_OVERRIDE';

Line 944: hr_utility.set_location('invalid dt mode passed'||p_datetrack_mode,10);

940: l_datetrack_mode := 'CORRECTION';
941: elsif p_datetrack_mode = 'DATETRACK' then
942: l_datetrack_mode := 'UPDATE_OVERRIDE';
943: else
944: hr_utility.set_location('invalid dt mode passed'||p_datetrack_mode,10);
945: l_continue := 'N';
946: end if;
947: if l_continue = 'Y' then
948: begin

Line 958: hr_utility.set_location('pre push done ',20);

954: p_status => l_status );
955:
956:
957: if l_status = 'YES' then
958: hr_utility.set_location('pre push done ',20);
959: rbc_stage_to_hr(p_copy_entity_txn_id => p_copy_entity_txn_id,
960: p_effective_date => p_effective_date,
961: p_business_group_id => p_business_group_id,
962: p_datetrack_mode => l_datetrack_mode,

Line 967: hr_utility.set_location('data pushed to hr ',20);

963: p_status => l_status);
964: end if;
965:
966: if l_status = 'YES' then
967: hr_utility.set_location('data pushed to hr ',20);
968:
969: begin
970:
971: update pqh_copy_entity_txns

Line 982: hr_utility.set_location('txn stat chg to comp',40);

978: where Copy_Entity_Txn_Id = p_copy_entity_txn_id;
979: -- and table_alias in ('PLN','RMN','RMV','RMR','RBR',');
980:
981:
982: hr_utility.set_location('txn stat chg to comp',40);
983: exception
984: when others then
985: hr_utility.set_location('issues in updating cet row ',10);
986: l_status := 'NO';

Line 985: hr_utility.set_location('issues in updating cet row ',10);

981:
982: hr_utility.set_location('txn stat chg to comp',40);
983: exception
984: when others then
985: hr_utility.set_location('issues in updating cet row ',10);
986: l_status := 'NO';
987: raise;
988: end;
989:

Line 994: hr_utility.set_location('issues in writing data ',10);

990: end if;
991:
992: exception
993: when others then
994: hr_utility.set_location('issues in writing data ',10);
995: l_status := 'NO';
996: raise;
997: end;
998: end if;

Line 1003: hr_utility.set_location('Leaving: rbc_data_push', 10);

999:
1000: p_status := l_status ;
1001:
1002:
1003: hr_utility.set_location('Leaving: rbc_data_push', 10);
1004: -- hr_utility.trace_off;
1005: end rbc_data_push;
1006:
1007: function get_pl_typ_id (p_effective_date in date,

Line 1004: -- hr_utility.trace_off;

1000: p_status := l_status ;
1001:
1002:
1003: hr_utility.set_location('Leaving: rbc_data_push', 10);
1004: -- hr_utility.trace_off;
1005: end rbc_data_push;
1006:
1007: function get_pl_typ_id (p_effective_date in date,
1008: p_business_group_id in number)

Line 1014: hr_utility.set_location('Entering: get_pl_typ_id', 10);

1010: is
1011: l_pl_typ_id number;
1012: begin
1013:
1014: hr_utility.set_location('Entering: get_pl_typ_id', 10);
1015:
1016: select PL_TYP_ID
1017: into l_pl_typ_id
1018: from ben_pl_typ_f

Line 1023: hr_utility.set_location('Leaving: get_pl_typ_id', 10);

1019: where p_effective_date between effective_start_date and effective_end_date
1020: and business_group_id = p_business_group_id
1021: and opt_typ_cd = 'RBC';
1022:
1023: hr_utility.set_location('Leaving: get_pl_typ_id', 10);
1024:
1025: return l_pl_typ_id;
1026: exception
1027: when too_many_rows then

Line 1028: hr_utility.set_location('more than onr rows returned', 20);

1024:
1025: return l_pl_typ_id;
1026: exception
1027: when too_many_rows then
1028: hr_utility.set_location('more than onr rows returned', 20);
1029: when others then
1030: hr_utility.set_location('Problem in getting pl_typ_id ', 20);
1031:
1032: End get_pl_typ_id;

Line 1030: hr_utility.set_location('Problem in getting pl_typ_id ', 20);

1026: exception
1027: when too_many_rows then
1028: hr_utility.set_location('more than onr rows returned', 20);
1029: when others then
1030: hr_utility.set_location('Problem in getting pl_typ_id ', 20);
1031:
1032: End get_pl_typ_id;
1033:
1034:

Line 1058: hr_utility.set_location('inside'||l_proc,10);

1054: where copy_entity_txn_id = p_copy_entity_txn_id
1055: and table_alias = 'PLN'
1056: and dml_operation in ('CREATE','UPDATE');
1057: begin
1058: hr_utility.set_location('inside'||l_proc,10);
1059: for plan_rec in csr_plan loop
1060: l_ovn := plan_rec.Information265;
1061: l_plan_id := plan_rec.Information1;
1062: if plan_rec.dml_operation = 'CREATE' then

Line 1063: hr_utility.set_location('new plan is being created'||l_proc,20);

1059: for plan_rec in csr_plan loop
1060: l_ovn := plan_rec.Information265;
1061: l_plan_id := plan_rec.Information1;
1062: if plan_rec.dml_operation = 'CREATE' then
1063: hr_utility.set_location('new plan is being created'||l_proc,20);
1064: begin
1065: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),20);
1066: hr_utility.set_location('plan id'||l_plan_id,20);
1067: l_pl_typ_id := get_pl_typ_id(p_effective_date,plan_rec.Information4);

Line 1065: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),20);

1061: l_plan_id := plan_rec.Information1;
1062: if plan_rec.dml_operation = 'CREATE' then
1063: hr_utility.set_location('new plan is being created'||l_proc,20);
1064: begin
1065: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),20);
1066: hr_utility.set_location('plan id'||l_plan_id,20);
1067: l_pl_typ_id := get_pl_typ_id(p_effective_date,plan_rec.Information4);
1068: hr_utility.set_location('plan typ id'||l_pl_typ_id,20);
1069: ben_plan_api.create_Plan(

Line 1066: hr_utility.set_location('plan id'||l_plan_id,20);

1062: if plan_rec.dml_operation = 'CREATE' then
1063: hr_utility.set_location('new plan is being created'||l_proc,20);
1064: begin
1065: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),20);
1066: hr_utility.set_location('plan id'||l_plan_id,20);
1067: l_pl_typ_id := get_pl_typ_id(p_effective_date,plan_rec.Information4);
1068: hr_utility.set_location('plan typ id'||l_pl_typ_id,20);
1069: ben_plan_api.create_Plan(
1070: p_pl_id => l_plan_id

Line 1068: hr_utility.set_location('plan typ id'||l_pl_typ_id,20);

1064: begin
1065: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),20);
1066: hr_utility.set_location('plan id'||l_plan_id,20);
1067: l_pl_typ_id := get_pl_typ_id(p_effective_date,plan_rec.Information4);
1068: hr_utility.set_location('plan typ id'||l_pl_typ_id,20);
1069: ben_plan_api.create_Plan(
1070: p_pl_id => l_plan_id
1071: ,p_effective_start_date => l_effective_start_date
1072: ,p_effective_end_date => l_effective_end_date

Line 1084: hr_utility.set_location('paln id'||l_plan_id,20);

1080: ,p_pl_cd => 'MYNTBPGM'
1081: ,p_pl_typ_id => l_pl_typ_id
1082: ,p_vrfy_fmly_mmbr_cd => null
1083: );
1084: hr_utility.set_location('paln id'||l_plan_id,20);
1085:
1086: exception
1087: when others then
1088: hr_utility.set_location('issues in creating plan'||plan_rec.information170,30);

Line 1088: hr_utility.set_location('issues in creating plan'||plan_rec.information170,30);

1084: hr_utility.set_location('paln id'||l_plan_id,20);
1085:
1086: exception
1087: when others then
1088: hr_utility.set_location('issues in creating plan'||plan_rec.information170,30);
1089: raise;
1090: end;
1091: hr_utility.set_location('plan id is '||l_plan_id,30);
1092: elsif plan_rec.dml_operation in ('UPDATE')

Line 1091: hr_utility.set_location('plan id is '||l_plan_id,30);

1087: when others then
1088: hr_utility.set_location('issues in creating plan'||plan_rec.information170,30);
1089: raise;
1090: end;
1091: hr_utility.set_location('plan id is '||l_plan_id,30);
1092: elsif plan_rec.dml_operation in ('UPDATE')
1093: and l_ovn is not null
1094: and l_plan_id is not null then
1095: hr_utility.set_location('Plan is being updated'||l_plan_id,60);

Line 1095: hr_utility.set_location('Plan is being updated'||l_plan_id,60);

1091: hr_utility.set_location('plan id is '||l_plan_id,30);
1092: elsif plan_rec.dml_operation in ('UPDATE')
1093: and l_ovn is not null
1094: and l_plan_id is not null then
1095: hr_utility.set_location('Plan is being updated'||l_plan_id,60);
1096: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
1097: if p_datetrack_mode <> 'CORRECTION' then
1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',
1099: p_key_column_name => 'PL_ID',

Line 1096: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);

1092: elsif plan_rec.dml_operation in ('UPDATE')
1093: and l_ovn is not null
1094: and l_plan_id is not null then
1095: hr_utility.set_location('Plan is being updated'||l_plan_id,60);
1096: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
1097: if p_datetrack_mode <> 'CORRECTION' then
1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',
1099: p_key_column_name => 'PL_ID',
1100: p_key_column_value => l_plan_id,

Line 1102: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',
1099: p_key_column_name => 'PL_ID',
1100: p_key_column_value => l_plan_id,
1101: p_effective_date => p_effective_date);
1102: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1103: else
1104: l_dt_mode := p_datetrack_mode;
1105: end if;
1106: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PL_F',

Line 1110: hr_utility.set_location(' ovn is '||l_db_ovn,30);

1106: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PL_F',
1107: p_key_column_name => 'PL_ID',
1108: p_key_column_value => l_plan_id,
1109: p_effective_date => p_effective_date);
1110: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1111: if l_db_ovn <> l_ovn then
1112: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');
1113: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1114: fnd_message.set_token('OBJECT ',l_object);

Line 1134: hr_utility.set_location('issues in updating plan'||l_plan_id,70);

1130: ,p_short_code => plan_rec.Information93
1131: ,p_vrfy_fmly_mmbr_cd => null);
1132: exception
1133: when others then
1134: hr_utility.set_location('issues in updating plan'||l_plan_id,70);
1135: hr_utility.set_location('paln ovn'||l_ovn,75);
1136: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),78);
1137: raise;
1138: end;

Line 1135: hr_utility.set_location('paln ovn'||l_ovn,75);

1131: ,p_vrfy_fmly_mmbr_cd => null);
1132: exception
1133: when others then
1134: hr_utility.set_location('issues in updating plan'||l_plan_id,70);
1135: hr_utility.set_location('paln ovn'||l_ovn,75);
1136: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),78);
1137: raise;
1138: end;
1139: end if;

Line 1136: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),78);

1132: exception
1133: when others then
1134: hr_utility.set_location('issues in updating plan'||l_plan_id,70);
1135: hr_utility.set_location('paln ovn'||l_ovn,75);
1136: hr_utility.set_location('plan name'||substr(plan_rec.information170,1,45),78);
1137: raise;
1138: end;
1139: end if;
1140: else

Line 1158: hr_utility.set_location('Rate_matrix_node row updated',40);

1154: p_plan_id => l_plan_id,
1155: p_datetrack_mode => p_datetrack_mode);
1156:
1157: g_pln_short_code := null;
1158: hr_utility.set_location('Rate_matrix_node row updated',40);
1159:
1160: end loop;
1161:
1162: hr_utility.set_location('leaving '||l_proc,100);

Line 1162: hr_utility.set_location('leaving '||l_proc,100);

1158: hr_utility.set_location('Rate_matrix_node row updated',40);
1159:
1160: end loop;
1161:
1162: hr_utility.set_location('leaving '||l_proc,100);
1163:
1164: exception
1165: when others then
1166: raise;

Line 1193: hr_utility.set_location('inside'||l_proc,10);

1189: and table_alias = 'RMN'
1190: and dml_operation in ('CREATE','UPDATE')
1191: order by information160;
1192: begin
1193: hr_utility.set_location('inside'||l_proc,10);
1194: for rmn_rec in csr_rmn loop
1195: l_ovn := rmn_rec.Information265;
1196: l_rmn_id := rmn_rec.Information1;
1197:

Line 1202: hr_utility.set_location('new Rate matrix node is being created'||l_proc,20);

1198: l_parent_rmn_id := get_parent_rmn(p_copy_entity_txn_id => p_copy_entity_txn_id,
1199: p_copy_entity_result_id => rmn_rec.GS_PARENT_ENTITY_RESULT_ID);
1200:
1201: if rmn_rec.dml_operation = 'CREATE' then
1202: hr_utility.set_location('new Rate matrix node is being created'||l_proc,20);
1203: begin
1204: hr_utility.set_location('Rate Matrix Node name'||substr(rmn_rec.information219,1,45),20);
1205: l_short_code := rmn_rec.INFORMATION12;
1206: hr_utility.set_location('Short_code is '||l_short_code,20);

Line 1204: hr_utility.set_location('Rate Matrix Node name'||substr(rmn_rec.information219,1,45),20);

1200:
1201: if rmn_rec.dml_operation = 'CREATE' then
1202: hr_utility.set_location('new Rate matrix node is being created'||l_proc,20);
1203: begin
1204: hr_utility.set_location('Rate Matrix Node name'||substr(rmn_rec.information219,1,45),20);
1205: l_short_code := rmn_rec.INFORMATION12;
1206: hr_utility.set_location('Short_code is '||l_short_code,20);
1207: if l_short_code is null then
1208: hr_utility.set_location('Short_code is null',20);

Line 1206: hr_utility.set_location('Short_code is '||l_short_code,20);

1202: hr_utility.set_location('new Rate matrix node is being created'||l_proc,20);
1203: begin
1204: hr_utility.set_location('Rate Matrix Node name'||substr(rmn_rec.information219,1,45),20);
1205: l_short_code := rmn_rec.INFORMATION12;
1206: hr_utility.set_location('Short_code is '||l_short_code,20);
1207: if l_short_code is null then
1208: hr_utility.set_location('Short_code is null',20);
1209: l_short_code := get_short_code('RMN');
1210: hr_utility.set_location('Short_code generated'||l_short_code,20);

Line 1208: hr_utility.set_location('Short_code is null',20);

1204: hr_utility.set_location('Rate Matrix Node name'||substr(rmn_rec.information219,1,45),20);
1205: l_short_code := rmn_rec.INFORMATION12;
1206: hr_utility.set_location('Short_code is '||l_short_code,20);
1207: if l_short_code is null then
1208: hr_utility.set_location('Short_code is null',20);
1209: l_short_code := get_short_code('RMN');
1210: hr_utility.set_location('Short_code generated'||l_short_code,20);
1211: end if;
1212: hr_utility.set_location('RMN id'||l_rmn_id,20);

Line 1210: hr_utility.set_location('Short_code generated'||l_short_code,20);

1206: hr_utility.set_location('Short_code is '||l_short_code,20);
1207: if l_short_code is null then
1208: hr_utility.set_location('Short_code is null',20);
1209: l_short_code := get_short_code('RMN');
1210: hr_utility.set_location('Short_code generated'||l_short_code,20);
1211: end if;
1212: hr_utility.set_location('RMN id'||l_rmn_id,20);
1213:
1214: -- Creating Eligibilty profile for each node

Line 1212: hr_utility.set_location('RMN id'||l_rmn_id,20);

1208: hr_utility.set_location('Short_code is null',20);
1209: l_short_code := get_short_code('RMN');
1210: hr_utility.set_location('Short_code generated'||l_short_code,20);
1211: end if;
1212: hr_utility.set_location('RMN id'||l_rmn_id,20);
1213:
1214: -- Creating Eligibilty profile for each node
1215: if rmn_rec.Information160 > 1 then
1216: pqh_rbc_elpro.create_elpro(p_name => l_short_code,

Line 1238: hr_utility.set_location('rmn id'||l_rmn_id,20);

1234: ,p_eligy_prfl_id => l_elp_id
1235: ,p_business_group_id => rmn_rec.Information4
1236: ,p_object_version_number => l_ovn
1237: );
1238: hr_utility.set_location('rmn id'||l_rmn_id,20);
1239: exception
1240: when others then
1241: hr_utility.set_location('issues in creating rmn'||rmn_rec.information219,30);
1242: raise;

Line 1241: hr_utility.set_location('issues in creating rmn'||rmn_rec.information219,30);

1237: );
1238: hr_utility.set_location('rmn id'||l_rmn_id,20);
1239: exception
1240: when others then
1241: hr_utility.set_location('issues in creating rmn'||rmn_rec.information219,30);
1242: raise;
1243: end;
1244: hr_utility.set_location('rmn id is '||l_rmn_id,30);
1245: elsif rmn_rec.dml_operation in ('UPDATE')

Line 1244: hr_utility.set_location('rmn id is '||l_rmn_id,30);

1240: when others then
1241: hr_utility.set_location('issues in creating rmn'||rmn_rec.information219,30);
1242: raise;
1243: end;
1244: hr_utility.set_location('rmn id is '||l_rmn_id,30);
1245: elsif rmn_rec.dml_operation in ('UPDATE')
1246: and l_ovn is not null
1247: and l_rmn_id is not null then
1248: hr_utility.set_location('Rate Matrix Node is being updated'||l_rmn_id,60);

Line 1248: hr_utility.set_location('Rate Matrix Node is being updated'||l_rmn_id,60);

1244: hr_utility.set_location('rmn id is '||l_rmn_id,30);
1245: elsif rmn_rec.dml_operation in ('UPDATE')
1246: and l_ovn is not null
1247: and l_rmn_id is not null then
1248: hr_utility.set_location('Rate Matrix Node is being updated'||l_rmn_id,60);
1249: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_NODES',
1250: p_key_column_name => 'RATE_MATRIX_NODE_ID',
1251: p_key_column_value => l_rmn_id
1252: );

Line 1253: hr_utility.set_location(' ovn is '||l_db_ovn,30);

1249: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_NODES',
1250: p_key_column_name => 'RATE_MATRIX_NODE_ID',
1251: p_key_column_value => l_rmn_id
1252: );
1253: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1254: if l_db_ovn <> l_ovn then
1255: fnd_message.set_name('PQH','PQH_RBC_OBJ_OVN_INVALID');
1256: fnd_message.raise_error;
1257: else

Line 1274: hr_utility.set_location('issues in updating Rate Matrix node'||l_rmn_id,70);

1270: ,p_object_version_number => l_ovn
1271: );
1272: exception
1273: when others then
1274: hr_utility.set_location('issues in updating Rate Matrix node'||l_rmn_id,70);
1275: hr_utility.set_location('rmn ovn'||l_ovn,75);
1276: hr_utility.set_location('rate Matix Node name'||substr(rmn_rec.information170,1,45),78);
1277: raise;
1278: end;

Line 1275: hr_utility.set_location('rmn ovn'||l_ovn,75);

1271: );
1272: exception
1273: when others then
1274: hr_utility.set_location('issues in updating Rate Matrix node'||l_rmn_id,70);
1275: hr_utility.set_location('rmn ovn'||l_ovn,75);
1276: hr_utility.set_location('rate Matix Node name'||substr(rmn_rec.information170,1,45),78);
1277: raise;
1278: end;
1279: end if;

Line 1276: hr_utility.set_location('rate Matix Node name'||substr(rmn_rec.information170,1,45),78);

1272: exception
1273: when others then
1274: hr_utility.set_location('issues in updating Rate Matrix node'||l_rmn_id,70);
1275: hr_utility.set_location('rmn ovn'||l_ovn,75);
1276: hr_utility.set_location('rate Matix Node name'||substr(rmn_rec.information170,1,45),78);
1277: raise;
1278: end;
1279: end if;
1280: else

Line 1288: hr_utility.set_location('IN RMN COPY ENTITY RESULT ID '||to_char(rmn_rec.copy_entity_result_id),201);

1284: ||' rmn_name'||rmn_rec.information170;
1285:
1286: end if;
1287:
1288: hr_utility.set_location('IN RMN COPY ENTITY RESULT ID '||to_char(rmn_rec.copy_entity_result_id),201);
1289: hr_utility.set_location('IN RMN rmn id is'||to_char(l_rmn_id),202);
1290: hr_utility.set_location('IN RMN copy entity txn id '||p_copy_entity_txn_id,203);
1291:
1292: rmn_writeback(p_copy_entity_result_id => rmn_rec.copy_entity_result_id,

Line 1289: hr_utility.set_location('IN RMN rmn id is'||to_char(l_rmn_id),202);

1285:
1286: end if;
1287:
1288: hr_utility.set_location('IN RMN COPY ENTITY RESULT ID '||to_char(rmn_rec.copy_entity_result_id),201);
1289: hr_utility.set_location('IN RMN rmn id is'||to_char(l_rmn_id),202);
1290: hr_utility.set_location('IN RMN copy entity txn id '||p_copy_entity_txn_id,203);
1291:
1292: rmn_writeback(p_copy_entity_result_id => rmn_rec.copy_entity_result_id,
1293: p_rmn_id => l_rmn_id,

Line 1290: hr_utility.set_location('IN RMN copy entity txn id '||p_copy_entity_txn_id,203);

1286: end if;
1287:
1288: hr_utility.set_location('IN RMN COPY ENTITY RESULT ID '||to_char(rmn_rec.copy_entity_result_id),201);
1289: hr_utility.set_location('IN RMN rmn id is'||to_char(l_rmn_id),202);
1290: hr_utility.set_location('IN RMN copy entity txn id '||p_copy_entity_txn_id,203);
1291:
1292: rmn_writeback(p_copy_entity_result_id => rmn_rec.copy_entity_result_id,
1293: p_rmn_id => l_rmn_id,
1294: p_copy_entity_txn_id => p_copy_entity_txn_id);

Line 1307: hr_utility.set_location('Rate_matrix_rates row updated',40);

1303: p_business_group_id => p_business_group_id,
1304: p_datetrack_mode => p_datetrack_mode,
1305: p_rmn_id => l_rmn_id );
1306:
1307: hr_utility.set_location('Rate_matrix_rates row updated',40);
1308: hr_utility.set_location('Rate_matrix_node_values created if any reqd',41);
1309:
1310: end loop;
1311: hr_utility.set_location('leaving '||l_proc,100);

Line 1308: hr_utility.set_location('Rate_matrix_node_values created if any reqd',41);

1304: p_datetrack_mode => p_datetrack_mode,
1305: p_rmn_id => l_rmn_id );
1306:
1307: hr_utility.set_location('Rate_matrix_rates row updated',40);
1308: hr_utility.set_location('Rate_matrix_node_values created if any reqd',41);
1309:
1310: end loop;
1311: hr_utility.set_location('leaving '||l_proc,100);
1312: exception

Line 1311: hr_utility.set_location('leaving '||l_proc,100);

1307: hr_utility.set_location('Rate_matrix_rates row updated',40);
1308: hr_utility.set_location('Rate_matrix_node_values created if any reqd',41);
1309:
1310: end loop;
1311: hr_utility.set_location('leaving '||l_proc,100);
1312: exception
1313: when others then
1314: raise;
1315: end stage_to_rmn;

Line 1341: hr_utility.set_location('inside '||l_proc,10);

1337: l_proc varchar2(61) := 'rbc_stage_to_hr' ;
1338: l_effective_date date := p_effective_date;
1339: l_return varchar2(3) := 'YES';
1340: begin
1341: hr_utility.set_location('inside '||l_proc,10);
1342: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1343: hr_utility.set_location('bg is '||p_business_group_id,2);
1344: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1345:

Line 1342: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);

1338: l_effective_date date := p_effective_date;
1339: l_return varchar2(3) := 'YES';
1340: begin
1341: hr_utility.set_location('inside '||l_proc,10);
1342: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1343: hr_utility.set_location('bg is '||p_business_group_id,2);
1344: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1345:
1346: stage_to_plan(p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 1343: hr_utility.set_location('bg is '||p_business_group_id,2);

1339: l_return varchar2(3) := 'YES';
1340: begin
1341: hr_utility.set_location('inside '||l_proc,10);
1342: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1343: hr_utility.set_location('bg is '||p_business_group_id,2);
1344: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1345:
1346: stage_to_plan(p_copy_entity_txn_id => p_copy_entity_txn_id,
1347: p_effective_date => l_effective_date,

Line 1344: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);

1340: begin
1341: hr_utility.set_location('inside '||l_proc,10);
1342: hr_utility.set_location('cet is '||p_copy_entity_txn_id,1);
1343: hr_utility.set_location('bg is '||p_business_group_id,2);
1344: hr_utility.set_location('dt mode is '||p_datetrack_mode,4);
1345:
1346: stage_to_plan(p_copy_entity_txn_id => p_copy_entity_txn_id,
1347: p_effective_date => l_effective_date,
1348: p_business_group_id => p_business_group_id,

Line 1351: hr_utility.set_location('plan row checked for update',30);

1347: p_effective_date => l_effective_date,
1348: p_business_group_id => p_business_group_id,
1349: p_datetrack_mode => p_datetrack_mode);
1350:
1351: hr_utility.set_location('plan row checked for update',30);
1352:
1353:
1354:
1355: p_status := l_return ;

Line 1356: hr_utility.set_location('Leaving '||l_proc,10);

1352:
1353:
1354:
1355: p_status := l_return ;
1356: hr_utility.set_location('Leaving '||l_proc,10);
1357: exception
1358: when others then
1359: hr_utility.set_location('error encountered',420);
1360: p_status := 'NO';

Line 1359: hr_utility.set_location('error encountered',420);

1355: p_status := l_return ;
1356: hr_utility.set_location('Leaving '||l_proc,10);
1357: exception
1358: when others then
1359: hr_utility.set_location('error encountered',420);
1360: p_status := 'NO';
1361: raise;
1362: end rbc_stage_to_hr;
1363: