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

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

12:
13: procedure delete_rows is
14: l_proc varchar2(60) := g_package||'delete_rows';
15: begin
16: hr_utility.set_location('Entering into '||l_proc,10);
17: g_period_table.delete;
18: hr_utility.set_location('Leaving '||l_proc,10);
19: end delete_rows;
20:

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

14: l_proc varchar2(60) := g_package||'delete_rows';
15: begin
16: hr_utility.set_location('Entering into '||l_proc,10);
17: g_period_table.delete;
18: hr_utility.set_location('Leaving '||l_proc,10);
19: end delete_rows;
20:
21: Procedure Insert_period( p_period_start_date in date,
22: p_period_end_date in date

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

26: l_flag varchar2(1);
27: l_next_row number;
28: l_proc varchar2(60) := g_package||'Insert_period';
29: Begin
30: hr_utility.set_location('Entering into '||l_proc,10);
31:
32: l_next_row := NVL(g_period_table.LAST, 0) + 1;
33: g_period_table(l_next_row).start_date := p_period_start_date;
34: g_period_table(l_next_row).end_date := p_period_end_date;

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

32: l_next_row := NVL(g_period_table.LAST, 0) + 1;
33: g_period_table(l_next_row).start_date := p_period_start_date;
34: g_period_table(l_next_row).end_date := p_period_end_date;
35:
36: hr_utility.set_location('Leaving '||l_proc,10);
37: end Insert_period;
38:
39: procedure get_salary_basis_details ( p_input_value_id in number,
40: p_effective_date in date,

Line 68: hr_utility.set_location('Entering: '||l_proc,30);

64:
65: l_salary_rec csr_salary_basis_details%ROWTYPE;
66:
67: begin
68: hr_utility.set_location('Entering: '||l_proc,30);
69:
70: open csr_salary_basis_details;
71: fetch csr_salary_basis_details into l_salary_rec;
72: if csr_salary_basis_details%notfound then

Line 74: hr_utility.set_location('No Salary basis linked to input value id passed ', 40);

70: open csr_salary_basis_details;
71: fetch csr_salary_basis_details into l_salary_rec;
72: if csr_salary_basis_details%notfound then
73: g_status := '1B';
74: hr_utility.set_location('No Salary basis linked to input value id passed ', 40);
75: end if;
76: close csr_salary_basis_details;
77: p_pay_basis_id := l_salary_rec.pay_basis_id;
78: p_rate_basis := l_salary_rec.pay_basis;

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

78: p_rate_basis := l_salary_rec.pay_basis;
79: p_PAY_ANN_FACTOR :=l_salary_rec.PAY_ANNUALIZATION_FACTOR;
80: p_name :=l_salary_rec.name ;
81:
82: hr_utility.set_location('Leaving: '||l_proc,30);
83: exception
84: when no_data_found then
85: g_status := '1B';
86: hr_utility.set_location('No Salary basis linked to input value id passed ', 40);

Line 86: hr_utility.set_location('No Salary basis linked to input value id passed ', 40);

82: hr_utility.set_location('Leaving: '||l_proc,30);
83: exception
84: when no_data_found then
85: g_status := '1B';
86: hr_utility.set_location('No Salary basis linked to input value id passed ', 40);
87: end get_salary_basis_details;
88:
89:
90: procedure element_entry(p_assignment_id in number,

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

118:
119: i integer;
120: l_proc varchar2(60) := g_package||'element_entry';
121: begin
122: hr_utility.set_location('Entering'||l_proc,10);
123: hr_utility.set_location('Elmnt_id'||p_element_type_id,10);
124: hr_utility.set_location('iv_id'||p_input_value_id,10);
125: i := 0;
126: for elmnt_entry_row in csr_elmnt_entry loop

Line 123: hr_utility.set_location('Elmnt_id'||p_element_type_id,10);

119: i integer;
120: l_proc varchar2(60) := g_package||'element_entry';
121: begin
122: hr_utility.set_location('Entering'||l_proc,10);
123: hr_utility.set_location('Elmnt_id'||p_element_type_id,10);
124: hr_utility.set_location('iv_id'||p_input_value_id,10);
125: i := 0;
126: for elmnt_entry_row in csr_elmnt_entry loop
127: i := i + 1;

Line 124: hr_utility.set_location('iv_id'||p_input_value_id,10);

120: l_proc varchar2(60) := g_package||'element_entry';
121: begin
122: hr_utility.set_location('Entering'||l_proc,10);
123: hr_utility.set_location('Elmnt_id'||p_element_type_id,10);
124: hr_utility.set_location('iv_id'||p_input_value_id,10);
125: i := 0;
126: for elmnt_entry_row in csr_elmnt_entry loop
127: i := i + 1;
128: hr_utility.set_location('ee being recorded :'||elmnt_entry_row.eev_amt,10);

Line 128: hr_utility.set_location('ee being recorded :'||elmnt_entry_row.eev_amt,10);

124: hr_utility.set_location('iv_id'||p_input_value_id,10);
125: i := 0;
126: for elmnt_entry_row in csr_elmnt_entry loop
127: i := i + 1;
128: hr_utility.set_location('ee being recorded :'||elmnt_entry_row.eev_amt,10);
129:
130: p_summary(i).start_date := elmnt_entry_row.ee_esd;
131: p_summary(i).end_date := elmnt_entry_row.ee_eed;
132: if p_value_set_id is null and p_lookup_type is null then

Line 151: hr_utility.set_location('p summary count '||p_summary.count,45);

147: p_summary(i).creator_type := elmnt_entry_row.creator_type;
148: p_summary(i).output_key := elmnt_entry_row.eev_id;
149:
150: end loop;
151: hr_utility.set_location('p summary count '||p_summary.count,45);
152: hr_utility.set_location('# of entries'||to_char(i),20);
153: hr_utility.set_location('Leaving'||l_proc,10);
154: end element_entry;
155:

Line 152: hr_utility.set_location('# of entries'||to_char(i),20);

148: p_summary(i).output_key := elmnt_entry_row.eev_id;
149:
150: end loop;
151: hr_utility.set_location('p summary count '||p_summary.count,45);
152: hr_utility.set_location('# of entries'||to_char(i),20);
153: hr_utility.set_location('Leaving'||l_proc,10);
154: end element_entry;
155:
156: procedure bnfts_entries (p_person_id in number,

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

149:
150: end loop;
151: hr_utility.set_location('p summary count '||p_summary.count,45);
152: hr_utility.set_location('# of entries'||to_char(i),20);
153: hr_utility.set_location('Leaving'||l_proc,10);
154: end element_entry;
155:
156: procedure bnfts_entries (p_person_id in number,
157: p_perd_st_dt in date,

Line 184: hr_utility.set_location('Entering '||l_proc,20);

180: and pbb.val is not null;
181: l_proc varchar2(1000) := g_package||'bnfts_entries';
182: i integer := 0;
183: Begin
184: hr_utility.set_location('Entering '||l_proc,20);
185: for bnfts_rec in bnfts_rows loop
186: i := i + 1;
187: p_bnfts_table(i).start_date := bnfts_rec.effective_start_date;
188: p_bnfts_table(i).end_date := bnfts_rec.effective_end_date;

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

199: exception
200: when others then
201: g_status := '3';
202:
203: hr_utility.set_location('Leaving '||l_proc,20);
204: end bnfts_entries;
205:
206: procedure rule_entries (p_assignment_id in number,
207: p_perd_start_date in date,

Line 244: hr_utility.set_location ('Entering: '||l_proc,05);

240: l_comp_dates3 varchar2(1000);
241: l_comp_values3 varchar2(1000);
242:
243: begin
244: hr_utility.set_location ('Entering: '||l_proc,05);
245: --
246: -- Initialise the formula .
247: --
248:

Line 256: hr_utility.set_location ('Set Context '||l_proc,10);

252: p_effective_date => p_date_earned,
253: p_inputs => l_inputs,
254: p_outputs => l_outputs);
255:
256: hr_utility.set_location ('Set Context '||l_proc,10);
257: hr_utility.set_location ('Set Context :'||l_inputs.first|| ' : ' || l_inputs.last,10);
258: --
259: for l_count in nvl(l_inputs.first,0)..nvl(l_inputs.last,-1) loop
260: --

Line 257: hr_utility.set_location ('Set Context :'||l_inputs.first|| ' : ' || l_inputs.last,10);

253: p_inputs => l_inputs,
254: p_outputs => l_outputs);
255:
256: hr_utility.set_location ('Set Context '||l_proc,10);
257: hr_utility.set_location ('Set Context :'||l_inputs.first|| ' : ' || l_inputs.last,10);
258: --
259: for l_count in nvl(l_inputs.first,0)..nvl(l_inputs.last,-1) loop
260: --
261: if l_inputs(l_count).name = 'ASSIGNMENT_ID' then

Line 282: hr_utility.set_location ('Run formula: '||l_proc,15);

278: end if;
279: --
280: end loop;
281:
282: hr_utility.set_location ('Run formula: '||l_proc,15);
283: --
284: -- We have loaded the input record . Now run the formula.
285: --
286: ff_exec.run_formula(p_inputs => l_inputs,

Line 289: hr_utility.set_location ('After Run formula: '||l_outputs.first || ' : ' ||l_outputs.last ,15);

285: --
286: ff_exec.run_formula(p_inputs => l_inputs,
287: p_outputs => l_outputs);
288:
289: hr_utility.set_location ('After Run formula: '||l_outputs.first || ' : ' ||l_outputs.last ,15);
290: --
291: --
292: -- Loop through the returned table and make sure that the returned
293: -- values have been found

Line 299: hr_utility.set_location ('After Run formula:'||l_outputs(l_count).name ,15);

295: --
296: for l_count in l_outputs.first..l_outputs.last loop
297: --
298: --
299: hr_utility.set_location ('After Run formula:'||l_outputs(l_count).name ,15);
300: --
301: if l_outputs(l_count).name = 'COMPENSATION_DATES' then
302: --
303: l_comp_dates := l_outputs(l_count).value;

Line 340: hr_utility.set_location ('Dates from Additional variable 1 appended.',17);

336: -- vkodedal Bug 6992595 -- new changes
337: if(length(l_comp_dates1) > 0 and length(l_comp_values1) > 0 ) then
338: l_comp_dates :=l_comp_dates||';'||l_comp_dates1;
339: l_comp_values :=l_comp_values||';'||l_comp_values1;
340: hr_utility.set_location ('Dates from Additional variable 1 appended.',17);
341: end if;
342:
343: if(length(l_comp_dates2) > 0 and length(l_comp_values2) > 0 ) then
344: l_comp_dates :=l_comp_dates||';'||l_comp_dates2;

Line 346: hr_utility.set_location ('Dates from Additional variable 2 appended.',18);

342:
343: if(length(l_comp_dates2) > 0 and length(l_comp_values2) > 0 ) then
344: l_comp_dates :=l_comp_dates||';'||l_comp_dates2;
345: l_comp_values :=l_comp_values||';'||l_comp_values2;
346: hr_utility.set_location ('Dates from Additional variable 2 appended.',18);
347: end if;
348:
349: if(length(l_comp_dates3) > 0 and length(l_comp_values3) > 0 ) then
350: l_comp_dates :=l_comp_dates||';'||l_comp_dates3;

Line 352: hr_utility.set_location ('Dates from Additional variable 3 appended.',19);

348:
349: if(length(l_comp_dates3) > 0 and length(l_comp_values3) > 0 ) then
350: l_comp_dates :=l_comp_dates||';'||l_comp_dates3;
351: l_comp_values :=l_comp_values||';'||l_comp_values3;
352: hr_utility.set_location ('Dates from Additional variable 3 appended.',19);
353: end if;
354: ---------------------end of new changes
355: if(length(l_comp_dates) > 0 and length(l_comp_values) > 0 ) then
356: loop

Line 393: hr_utility.set_location('value of l_date '||l_date, 30);

389: p_rule_table(z).uom := p_uom;
390: end if;
391: z := z +1;
392: END IF;
393: hr_utility.set_location('value of l_date '||l_date, 30);
394: hr_utility.set_location('value of j_dt '||j_dt, 30);
395: hr_utility.set_location('new value of i_dt '||i_dt, 30);
396: hr_utility.set_location('value of l_value '||l_value, 30);
397: hr_utility.set_location('value of j_vl '||j_vl, 30);

Line 394: hr_utility.set_location('value of j_dt '||j_dt, 30);

390: end if;
391: z := z +1;
392: END IF;
393: hr_utility.set_location('value of l_date '||l_date, 30);
394: hr_utility.set_location('value of j_dt '||j_dt, 30);
395: hr_utility.set_location('new value of i_dt '||i_dt, 30);
396: hr_utility.set_location('value of l_value '||l_value, 30);
397: hr_utility.set_location('value of j_vl '||j_vl, 30);
398: hr_utility.set_location('new value of i_vl '||i_vl, 30);

Line 395: hr_utility.set_location('new value of i_dt '||i_dt, 30);

391: z := z +1;
392: END IF;
393: hr_utility.set_location('value of l_date '||l_date, 30);
394: hr_utility.set_location('value of j_dt '||j_dt, 30);
395: hr_utility.set_location('new value of i_dt '||i_dt, 30);
396: hr_utility.set_location('value of l_value '||l_value, 30);
397: hr_utility.set_location('value of j_vl '||j_vl, 30);
398: hr_utility.set_location('new value of i_vl '||i_vl, 30);
399:

Line 396: hr_utility.set_location('value of l_value '||l_value, 30);

392: END IF;
393: hr_utility.set_location('value of l_date '||l_date, 30);
394: hr_utility.set_location('value of j_dt '||j_dt, 30);
395: hr_utility.set_location('new value of i_dt '||i_dt, 30);
396: hr_utility.set_location('value of l_value '||l_value, 30);
397: hr_utility.set_location('value of j_vl '||j_vl, 30);
398: hr_utility.set_location('new value of i_vl '||i_vl, 30);
399:
400: /* write('value of l_date '||l_date);

Line 397: hr_utility.set_location('value of j_vl '||j_vl, 30);

393: hr_utility.set_location('value of l_date '||l_date, 30);
394: hr_utility.set_location('value of j_dt '||j_dt, 30);
395: hr_utility.set_location('new value of i_dt '||i_dt, 30);
396: hr_utility.set_location('value of l_value '||l_value, 30);
397: hr_utility.set_location('value of j_vl '||j_vl, 30);
398: hr_utility.set_location('new value of i_vl '||i_vl, 30);
399:
400: /* write('value of l_date '||l_date);
401: write('value of j_dt '||j_dt);

Line 398: hr_utility.set_location('new value of i_vl '||i_vl, 30);

394: hr_utility.set_location('value of j_dt '||j_dt, 30);
395: hr_utility.set_location('new value of i_dt '||i_dt, 30);
396: hr_utility.set_location('value of l_value '||l_value, 30);
397: hr_utility.set_location('value of j_vl '||j_vl, 30);
398: hr_utility.set_location('new value of i_vl '||i_vl, 30);
399:
400: /* write('value of l_date '||l_date);
401: write('value of j_dt '||j_dt);
402: write('new value of i_dt '||i_dt);

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

409: exit when i_vl > length(l_comp_values);
410: exit when i_dt > length(l_comp_dates);
411: end loop;
412: end if ;
413: hr_utility.set_location('Leaving '||l_proc,20);
414: exception
415: when others then
416: g_status := '5';
417: WRITE('error in date format:' || sqlerrm);

Line 418: hr_utility.set_location('exception '||sqlerrm,20);

414: exception
415: when others then
416: g_status := '5';
417: WRITE('error in date format:' || sqlerrm);
418: hr_utility.set_location('exception '||sqlerrm,20);
419: end rule_entries;
420:
421: procedure thrd_pty_entries (p_assignment_id in number,
422: p_perd_start_date in date,

Line 464: hr_utility.set_location('entering '||l_proc,10);

460:
461: i integer := 1;
462: l_proc varchar2(1000) := g_package||'thrd_pty_entries';
463: begin
464: hr_utility.set_location('entering '||l_proc,10);
465: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
466: hr_utility.set_location('asg id'||p_assignment_id,11);
467: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
468: for thrd_pty_rec in thrd_pty_rows loop

Line 465: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);

461: i integer := 1;
462: l_proc varchar2(1000) := g_package||'thrd_pty_entries';
463: begin
464: hr_utility.set_location('entering '||l_proc,10);
465: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
466: hr_utility.set_location('asg id'||p_assignment_id,11);
467: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
468: for thrd_pty_rec in thrd_pty_rows loop
469: p_thrd_pty_table(i).start_date := thrd_pty_rec.period_start_date;

Line 466: hr_utility.set_location('asg id'||p_assignment_id,11);

462: l_proc varchar2(1000) := g_package||'thrd_pty_entries';
463: begin
464: hr_utility.set_location('entering '||l_proc,10);
465: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
466: hr_utility.set_location('asg id'||p_assignment_id,11);
467: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
468: for thrd_pty_rec in thrd_pty_rows loop
469: p_thrd_pty_table(i).start_date := thrd_pty_rec.period_start_date;
470: p_thrd_pty_table(i).end_date := thrd_pty_rec.period_end_date;

Line 467: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);

463: begin
464: hr_utility.set_location('entering '||l_proc,10);
465: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
466: hr_utility.set_location('asg id'||p_assignment_id,11);
467: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
468: for thrd_pty_rec in thrd_pty_rows loop
469: p_thrd_pty_table(i).start_date := thrd_pty_rec.period_start_date;
470: p_thrd_pty_table(i).end_date := thrd_pty_rec.period_end_date;
471: p_thrd_pty_table(i).value := fnd_number.number_to_canonical(thrd_pty_rec.amount);

Line 477: hr_utility.set_location('Back feed : '||thrd_pty_rec.displayed_name||': Currency '||p_thrd_pty_table(i).currency_cd,15);

473: if p_comp_typ_cd = 'MNTRY' then
474: --- vkodedal 6945274 - currency issue -3rd party payroll
475: ---p_thrd_pty_table(i).currency_cd := nvl(p_currency_cd,thrd_pty_rec.currency);
476: p_thrd_pty_table(i).currency_cd := nvl(p_currency_cd,nvl(thrd_pty_rec.currency,thrd_pty_rec.input_currency_code));
477: hr_utility.set_location('Back feed : '||thrd_pty_rec.displayed_name||': Currency '||p_thrd_pty_table(i).currency_cd,15);
478:
479: elsif p_comp_typ_cd = 'NNMNTRY' then
480: p_thrd_pty_table(i).uom := nvl(p_uom,nvl(thrd_pty_rec.uom,thrd_pty_rec.input_value_uom));
481: hr_utility.set_location('UOM '||p_thrd_pty_table(i).uom,16);

Line 481: hr_utility.set_location('UOM '||p_thrd_pty_table(i).uom,16);

477: hr_utility.set_location('Back feed : '||thrd_pty_rec.displayed_name||': Currency '||p_thrd_pty_table(i).currency_cd,15);
478:
479: elsif p_comp_typ_cd = 'NNMNTRY' then
480: p_thrd_pty_table(i).uom := nvl(p_uom,nvl(thrd_pty_rec.uom,thrd_pty_rec.input_value_uom));
481: hr_utility.set_location('UOM '||p_thrd_pty_table(i).uom,16);
482: end if;
483: p_thrd_pty_table(i).output_key := thrd_pty_rec.balance_amount_id;
484: p_thrd_pty_table(i).actual_uom := thrd_pty_rec.uom;
485: i := i + 1;

Line 487: hr_utility.set_location('# of entries'||i,30);

483: p_thrd_pty_table(i).output_key := thrd_pty_rec.balance_amount_id;
484: p_thrd_pty_table(i).actual_uom := thrd_pty_rec.uom;
485: i := i + 1;
486: end loop;
487: hr_utility.set_location('# of entries'||i,30);
488: hr_utility.set_location('Leaving '||l_proc,10);
489: exception
490: when others then
491: g_status := '4';

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

484: p_thrd_pty_table(i).actual_uom := thrd_pty_rec.uom;
485: i := i + 1;
486: end loop;
487: hr_utility.set_location('# of entries'||i,30);
488: hr_utility.set_location('Leaving '||l_proc,10);
489: exception
490: when others then
491: g_status := '4';
492: end thrd_pty_entries;

Line 546: hr_utility.set_location('entering '||l_proc,10);

542: i integer := 0;
543: l_amt number;
544: l_proc varchar2(1000) := g_package||' cost_entries';
545: begin
546: hr_utility.set_location('entering '||l_proc,10);
547: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
548: hr_utility.set_location('asg id'||p_assignment_id,11);
549: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
550: for cost_rec in cost_rows loop

Line 547: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);

543: l_amt number;
544: l_proc varchar2(1000) := g_package||' cost_entries';
545: begin
546: hr_utility.set_location('entering '||l_proc,10);
547: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
548: hr_utility.set_location('asg id'||p_assignment_id,11);
549: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
550: for cost_rec in cost_rows loop
551: i := i + 1;

Line 548: hr_utility.set_location('asg id'||p_assignment_id,11);

544: l_proc varchar2(1000) := g_package||' cost_entries';
545: begin
546: hr_utility.set_location('entering '||l_proc,10);
547: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
548: hr_utility.set_location('asg id'||p_assignment_id,11);
549: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
550: for cost_rec in cost_rows loop
551: i := i + 1;
552: p_cost_table(i).start_date := cost_rec.effective_date;

Line 549: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);

545: begin
546: hr_utility.set_location('entering '||l_proc,10);
547: hr_utility.set_location('inside cost entries with iv'||p_input_value_id,10);
548: hr_utility.set_location('asg id'||p_assignment_id,11);
549: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
550: for cost_rec in cost_rows loop
551: i := i + 1;
552: p_cost_table(i).start_date := cost_rec.effective_date;
553: p_cost_table(i).end_date := cost_rec.effective_date;

Line 570: hr_utility.set_location('# of entries'||i,30);

566:
567: p_cost_table(i).output_key := cost_rec.cost_id;
568:
569: end loop;
570: hr_utility.set_location('# of entries'||i,30);
571: hr_utility.set_location('Leaving '||l_proc,10);
572: exception
573: when others then
574: g_status := '2';

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

567: p_cost_table(i).output_key := cost_rec.cost_id;
568:
569: end loop;
570: hr_utility.set_location('# of entries'||i,30);
571: hr_utility.set_location('Leaving '||l_proc,10);
572: exception
573: when others then
574: g_status := '2';
575: end cost_entries;

Line 617: hr_utility.set_location('entering '||l_proc,10);

613: AND ppa.effective_date BETWEEN p_perd_start_date AND p_perd_end_date;
614: i integer := 0;
615: l_proc varchar2(1000) := g_package||' run_results';
616: begin
617: hr_utility.set_location('entering '||l_proc,10);
618: hr_utility.set_location('inside run results with iv'||p_input_value_id,10);
619: hr_utility.set_location('asg id'||p_assignment_id,11);
620: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
621: for run_rec in run_results loop

Line 618: hr_utility.set_location('inside run results with iv'||p_input_value_id,10);

614: i integer := 0;
615: l_proc varchar2(1000) := g_package||' run_results';
616: begin
617: hr_utility.set_location('entering '||l_proc,10);
618: hr_utility.set_location('inside run results with iv'||p_input_value_id,10);
619: hr_utility.set_location('asg id'||p_assignment_id,11);
620: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
621: for run_rec in run_results loop
622: i := i + 1;

Line 619: hr_utility.set_location('asg id'||p_assignment_id,11);

615: l_proc varchar2(1000) := g_package||' run_results';
616: begin
617: hr_utility.set_location('entering '||l_proc,10);
618: hr_utility.set_location('inside run results with iv'||p_input_value_id,10);
619: hr_utility.set_location('asg id'||p_assignment_id,11);
620: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
621: for run_rec in run_results loop
622: i := i + 1;
623: p_result_table(i).start_date := run_rec.effective_date;

Line 620: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);

616: begin
617: hr_utility.set_location('entering '||l_proc,10);
618: hr_utility.set_location('inside run results with iv'||p_input_value_id,10);
619: hr_utility.set_location('asg id'||p_assignment_id,11);
620: hr_utility.set_location('date range is '||to_char(p_perd_start_date,'dd/mm/yyyy')||' - '||to_char(p_perd_end_date,'dd/mm/yyyy'),12);
621: for run_rec in run_results loop
622: i := i + 1;
623: p_result_table(i).start_date := run_rec.effective_date;
624: p_result_table(i).end_date := run_rec.effective_date;

Line 635: hr_utility.set_location('# of entries'||i,30);

631:
632: p_result_table(i).output_key := run_rec.run_result_id;
633:
634: end loop;
635: hr_utility.set_location('# of entries'||i,30);
636: hr_utility.set_location('Leaving '||l_proc,10);
637: exception
638: when others then
639: g_status := '7';

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

632: p_result_table(i).output_key := run_rec.run_result_id;
633:
634: end loop;
635: hr_utility.set_location('# of entries'||i,30);
636: hr_utility.set_location('Leaving '||l_proc,10);
637: exception
638: when others then
639: g_status := '7';
640: end run_results;

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

654:
655: l_assignment_rec csr_assignment_details%rowtype;
656: l_proc varchar2(60) := g_package||'get_person_details';
657: Begin
658: hr_utility.set_location('Entering'||l_proc,10);
659:
660: open csr_assignment_details;
661: fetch csr_assignment_details into l_assignment_rec;
662: if csr_assignment_details%notfound then

Line 663: hr_utility.set_location('invalid Person id passed',10);

659:
660: open csr_assignment_details;
661: fetch csr_assignment_details into l_assignment_rec;
662: if csr_assignment_details%notfound then
663: hr_utility.set_location('invalid Person id passed',10);
664:
665: end if;
666: close csr_assignment_details;
667:

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

666: close csr_assignment_details;
667:
668: p_payroll_id := l_assignment_rec.payroll_id;
669: p_salary_basis_id:= l_assignment_rec.pay_basis_id;
670: hr_utility.set_location('Leaving'||l_proc,10);
671: end get_assignment_details;
672:
673:
674: procedure get_element_details(p_item_key in number,

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

703: l_element_rec csr_element_details%rowtype;
704: l_proc varchar2(60) := g_package||'get_element_details';
705: Begin
706:
707: hr_utility.set_location('Entering'||l_proc,10);
708: hr_utility.set_location('date'||p_effective_date,1900);
709: hr_utility.set_location('item'||p_item_key,190);
710:
711: open csr_element_details;

Line 708: hr_utility.set_location('date'||p_effective_date,1900);

704: l_proc varchar2(60) := g_package||'get_element_details';
705: Begin
706:
707: hr_utility.set_location('Entering'||l_proc,10);
708: hr_utility.set_location('date'||p_effective_date,1900);
709: hr_utility.set_location('item'||p_item_key,190);
710:
711: open csr_element_details;
712: fetch csr_element_details into l_element_rec;

Line 709: hr_utility.set_location('item'||p_item_key,190);

705: Begin
706:
707: hr_utility.set_location('Entering'||l_proc,10);
708: hr_utility.set_location('date'||p_effective_date,1900);
709: hr_utility.set_location('item'||p_item_key,190);
710:
711: open csr_element_details;
712: fetch csr_element_details into l_element_rec;
713: if csr_element_details%notfound then

Line 715: hr_utility.set_location('Wrong input_value_id passed for Element Entry ', 40);

711: open csr_element_details;
712: fetch csr_element_details into l_element_rec;
713: if csr_element_details%notfound then
714: g_status := '1A';
715: hr_utility.set_location('Wrong input_value_id passed for Element Entry ', 40);
716: end if;
717: close csr_element_details;
718:
719: p_element_type_id := l_element_rec.element_type_id;

Line 733: hr_utility.set_location('p_actual_uom'||p_actual_uom,10);

729: end if;
730:
731: p_actual_uom := l_element_rec.uom;
732:
733: hr_utility.set_location('p_actual_uom'||p_actual_uom,10);
734:
735: hr_utility.set_location('Leaving'||l_proc,10);
736: end get_element_details;
737:

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

731: p_actual_uom := l_element_rec.uom;
732:
733: hr_utility.set_location('p_actual_uom'||p_actual_uom,10);
734:
735: hr_utility.set_location('Leaving'||l_proc,10);
736: end get_element_details;
737:
738: procedure get_pay_periods( p_perd_st_dt in date,
739: p_perd_en_dt in date,

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

743: period_end_Date date;
744: flag varchar2(1) := 'Y' ;
745: l_proc varchar2(60) := g_package||'get_pay_periods';
746: begin
747: hr_utility.set_location('Entering'||l_proc,10);
748: period_start_date := p_perd_st_dt;
749: period_end_date := p_perd_en_dt;
750: hr_utility.set_location('freq_cd'||p_frequency,10);
751: if p_frequency = 'ANN' then

Line 750: hr_utility.set_location('freq_cd'||p_frequency,10);

746: begin
747: hr_utility.set_location('Entering'||l_proc,10);
748: period_start_date := p_perd_st_dt;
749: period_end_date := p_perd_en_dt;
750: hr_utility.set_location('freq_cd'||p_frequency,10);
751: if p_frequency = 'ANN' then
752: while flag = 'Y'
753: loop
754: if months_between(p_perd_en_dt,period_start_date) < 12 then

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

796: period_start_date := period_end_date + 1;
797: end if;
798: end loop;
799: end if;
800: hr_utility.set_location('Leaving'||l_proc,10);
801: end get_pay_periods;
802:
803:
804: procedure get_payroll_periods(p_assignment_id in number,

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

855: l_proc varchar2(60) := g_package||'get_payroll_periods';
856: l_asg_pay varchar2(1) := 'N';
857: l_value varchar2(240);
858: begin
859: hr_utility.set_location('Entering'||l_proc,10);
860: hr_utility.set_location(l_proc||' '||p_perd_st_dt,10);
861: hr_utility.set_location(l_proc||' '||p_perd_en_dt,10);
862: hr_utility.set_location(l_proc||' '||p_value,10);
863: hr_utility.set_location('Entering'||l_proc,10);

Line 860: hr_utility.set_location(l_proc||' '||p_perd_st_dt,10);

856: l_asg_pay varchar2(1) := 'N';
857: l_value varchar2(240);
858: begin
859: hr_utility.set_location('Entering'||l_proc,10);
860: hr_utility.set_location(l_proc||' '||p_perd_st_dt,10);
861: hr_utility.set_location(l_proc||' '||p_perd_en_dt,10);
862: hr_utility.set_location(l_proc||' '||p_value,10);
863: hr_utility.set_location('Entering'||l_proc,10);
864: open csr_asg_payroll;

Line 861: hr_utility.set_location(l_proc||' '||p_perd_en_dt,10);

857: l_value varchar2(240);
858: begin
859: hr_utility.set_location('Entering'||l_proc,10);
860: hr_utility.set_location(l_proc||' '||p_perd_st_dt,10);
861: hr_utility.set_location(l_proc||' '||p_perd_en_dt,10);
862: hr_utility.set_location(l_proc||' '||p_value,10);
863: hr_utility.set_location('Entering'||l_proc,10);
864: open csr_asg_payroll;
865: loop

Line 862: hr_utility.set_location(l_proc||' '||p_value,10);

858: begin
859: hr_utility.set_location('Entering'||l_proc,10);
860: hr_utility.set_location(l_proc||' '||p_perd_st_dt,10);
861: hr_utility.set_location(l_proc||' '||p_perd_en_dt,10);
862: hr_utility.set_location(l_proc||' '||p_value,10);
863: hr_utility.set_location('Entering'||l_proc,10);
864: open csr_asg_payroll;
865: loop
866: fetch csr_asg_payroll into l_asg_payroll;

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

859: hr_utility.set_location('Entering'||l_proc,10);
860: hr_utility.set_location(l_proc||' '||p_perd_st_dt,10);
861: hr_utility.set_location(l_proc||' '||p_perd_en_dt,10);
862: hr_utility.set_location(l_proc||' '||p_value,10);
863: hr_utility.set_location('Entering'||l_proc,10);
864: open csr_asg_payroll;
865: loop
866: fetch csr_asg_payroll into l_asg_payroll;
867: exit when csr_asg_payroll%notfound;

Line 889: hr_utility.set_location('l_start_date '||l_start_date, 57);

885: l_value := fnd_number.number_to_canonical(fnd_number.canonical_to_number(p_value)/l_asg_payroll.number_per_fiscal_year );
886: else
887: l_value := p_value;
888: end if;
889: hr_utility.set_location('l_start_date '||l_start_date, 57);
890: hr_utility.set_location('l_end_date '||l_end_date, 57);
891: hr_utility.set_location('payroll_id '||l_asg_payroll.payroll_id, 57);
892: open csr_payroll_periods(l_asg_payroll.payroll_id, l_start_date, l_end_date);
893: loop

Line 890: hr_utility.set_location('l_end_date '||l_end_date, 57);

886: else
887: l_value := p_value;
888: end if;
889: hr_utility.set_location('l_start_date '||l_start_date, 57);
890: hr_utility.set_location('l_end_date '||l_end_date, 57);
891: hr_utility.set_location('payroll_id '||l_asg_payroll.payroll_id, 57);
892: open csr_payroll_periods(l_asg_payroll.payroll_id, l_start_date, l_end_date);
893: loop
894: fetch csr_payroll_periods into l_payroll_periods;

Line 891: hr_utility.set_location('payroll_id '||l_asg_payroll.payroll_id, 57);

887: l_value := p_value;
888: end if;
889: hr_utility.set_location('l_start_date '||l_start_date, 57);
890: hr_utility.set_location('l_end_date '||l_end_date, 57);
891: hr_utility.set_location('payroll_id '||l_asg_payroll.payroll_id, 57);
892: open csr_payroll_periods(l_asg_payroll.payroll_id, l_start_date, l_end_date);
893: loop
894: fetch csr_payroll_periods into l_payroll_periods;
895: exit when csr_payroll_periods%notfound;

Line 898: hr_utility.set_location('Entry already created for this period '||l_payroll_periods.end_date ,10);

894: fetch csr_payroll_periods into l_payroll_periods;
895: exit when csr_payroll_periods%notfound;
896: if l_payroll_periods.end_date <= p_perd_en_dt then
897: if( NVL(g_period_table.LAST, 0) > 0 and l_payroll_periods.end_date = g_period_table(NVL(g_period_table.LAST, 0)).end_date) then
898: hr_utility.set_location('Entry already created for this period '||l_payroll_periods.end_date ,10);
899: else
900: -- if l_payroll_periods.end_date <= l_end_date then
901: hr_utility.set_location('into the if statment '||p_value,10);
902: l_next_row := NVL(g_period_table.LAST, 0) + 1;

Line 901: hr_utility.set_location('into the if statment '||p_value,10);

897: if( NVL(g_period_table.LAST, 0) > 0 and l_payroll_periods.end_date = g_period_table(NVL(g_period_table.LAST, 0)).end_date) then
898: hr_utility.set_location('Entry already created for this period '||l_payroll_periods.end_date ,10);
899: else
900: -- if l_payroll_periods.end_date <= l_end_date then
901: hr_utility.set_location('into the if statment '||p_value,10);
902: l_next_row := NVL(g_period_table.LAST, 0) + 1;
903: g_period_table(l_next_row).start_date := l_payroll_periods.start_date;
904: g_period_table(l_next_row).end_date := l_payroll_periods.end_date;
905: g_period_table(l_next_row).value := l_value;

Line 922: hr_utility.set_location('No payroll attached to the assignment',10);

918: end loop;
919:
920: if l_asg_pay = 'N' then
921: g_status := '1C';
922: hr_utility.set_location('No payroll attached to the assignment',10);
923: end if;
924:
925: close csr_asg_payroll;
926: hr_utility.set_location('Leaving'||l_proc,10);

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

922: hr_utility.set_location('No payroll attached to the assignment',10);
923: end if;
924:
925: close csr_asg_payroll;
926: hr_utility.set_location('Leaving'||l_proc,10);
927: end get_payroll_periods;
928:
929:
930: procedure pay_details (p_elm_table in period_table,

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

953: l_next_row number;
954: l_salary_basis varchar2(1);
955:
956: Begin
957: hr_utility.set_location('Entering'||l_proc,10);
958: l_number_of_rows := p_elm_table.count;
959: for ee_row in 1..l_number_of_rows
960: loop
961: if p_elm_table(ee_row).end_date > p_perd_en_dt then

Line 973: hr_utility.set_location('value'||p_elm_table(ee_row).value, 40);

969: else
970: l_esd := p_elm_table(ee_row).start_date;
971: end if;
972:
973: hr_utility.set_location('value'||p_elm_table(ee_row).value, 40);
974: hr_utility.set_location('stend1'||l_eed, 40);
975: hr_utility.set_location('start1'||l_esd, 40);
976: if p_elm_table(ee_row).creator_type = 'SP' then
977: /* Get the pay basis id, pay annulization factor and rate basis from

Line 974: hr_utility.set_location('stend1'||l_eed, 40);

970: l_esd := p_elm_table(ee_row).start_date;
971: end if;
972:
973: hr_utility.set_location('value'||p_elm_table(ee_row).value, 40);
974: hr_utility.set_location('stend1'||l_eed, 40);
975: hr_utility.set_location('start1'||l_esd, 40);
976: if p_elm_table(ee_row).creator_type = 'SP' then
977: /* Get the pay basis id, pay annulization factor and rate basis from
978: per pay bases depending on input_value_id */

Line 975: hr_utility.set_location('start1'||l_esd, 40);

971: end if;
972:
973: hr_utility.set_location('value'||p_elm_table(ee_row).value, 40);
974: hr_utility.set_location('stend1'||l_eed, 40);
975: hr_utility.set_location('start1'||l_esd, 40);
976: if p_elm_table(ee_row).creator_type = 'SP' then
977: /* Get the pay basis id, pay annulization factor and rate basis from
978: per pay bases depending on input_value_id */
979: hr_utility.set_location('Creator for element_entry is salary proposal', 40);

Line 979: hr_utility.set_location('Creator for element_entry is salary proposal', 40);

975: hr_utility.set_location('start1'||l_esd, 40);
976: if p_elm_table(ee_row).creator_type = 'SP' then
977: /* Get the pay basis id, pay annulization factor and rate basis from
978: per pay bases depending on input_value_id */
979: hr_utility.set_location('Creator for element_entry is salary proposal', 40);
980: get_salary_basis_details ( p_input_value_id => p_source_key,
981: p_effective_date => p_effective_date,
982: p_period_start_date => p_perd_st_dt ,
983: p_assignment_id => p_assignment_id,

Line 992: hr_utility.set_location('Annulization factor is not null', 30);

988: );
989:
990: if g_status = '0' then
991: if l_pay_ann_factor is not null then
992: hr_utility.set_location('Annulization factor is not null', 30);
993: l_salary_basis := 'Y';
994: if l_pay_ann_factor <= 0 then
995: l_pay_ann_factor := 1;
996: end if;

Line 1006: hr_utility.set_location('Annulization factor is null', 30);

1002: else
1003: l_value := p_elm_table(ee_row).value;
1004: l_salary_basis := 'N';
1005: end if ;
1006: hr_utility.set_location('Annulization factor is null', 30);
1007: get_payroll_periods(p_assignment_id => p_assignment_id,
1008: p_perd_st_dt => l_esd,
1009: p_perd_en_dt => l_eed,
1010: p_value => fnd_number.number_to_canonical(l_value),

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

1033: end if;
1034:
1035: end loop;
1036:
1037: hr_utility.set_location('Leaving'||l_proc,10);
1038:
1039: End pay_details;
1040:
1041: procedure populate_result_table(p_elm_table in period_table,

Line 1050: hr_utility.set_location('number of rows in p_elm_table '||p_elm_table.count,46);

1046: l_number_of_rows number;
1047: l_next_row number;
1048: Begin
1049: l_number_of_rows := p_elm_table.count;
1050: hr_utility.set_location('number of rows in p_elm_table '||p_elm_table.count,46);
1051: for ee_row in 1..l_number_of_rows
1052: loop
1053:
1054: l_next_row := NVL(g_period_table.LAST, 0) + 1;

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

1093: l_proc varchar2(60) := g_package||'get_value_for_item';
1094: l_actual_uom pay_input_values_f.uom%type;
1095:
1096: begin
1097: hr_utility.set_location('Entering'||l_proc,10);
1098: hr_utility.set_location('For Person '||p_person_id,499);
1099: hr_utility.set_location('For Assignment id'||p_assignment_id,499);
1100: hr_utility.set_location('For p_perd_en_dt '||p_perd_en_dt,499);
1101:

Line 1098: hr_utility.set_location('For Person '||p_person_id,499);

1094: l_actual_uom pay_input_values_f.uom%type;
1095:
1096: begin
1097: hr_utility.set_location('Entering'||l_proc,10);
1098: hr_utility.set_location('For Person '||p_person_id,499);
1099: hr_utility.set_location('For Assignment id'||p_assignment_id,499);
1100: hr_utility.set_location('For p_perd_en_dt '||p_perd_en_dt,499);
1101:
1102: g_status := '0';

Line 1099: hr_utility.set_location('For Assignment id'||p_assignment_id,499);

1095:
1096: begin
1097: hr_utility.set_location('Entering'||l_proc,10);
1098: hr_utility.set_location('For Person '||p_person_id,499);
1099: hr_utility.set_location('For Assignment id'||p_assignment_id,499);
1100: hr_utility.set_location('For p_perd_en_dt '||p_perd_en_dt,499);
1101:
1102: g_status := '0';
1103: l_el_curr_cd := p_currency_cd;

Line 1100: hr_utility.set_location('For p_perd_en_dt '||p_perd_en_dt,499);

1096: begin
1097: hr_utility.set_location('Entering'||l_proc,10);
1098: hr_utility.set_location('For Person '||p_person_id,499);
1099: hr_utility.set_location('For Assignment id'||p_assignment_id,499);
1100: hr_utility.set_location('For p_perd_en_dt '||p_perd_en_dt,499);
1101:
1102: g_status := '0';
1103: l_el_curr_cd := p_currency_cd;
1104: l_uom := p_uom;

Line 1107: hr_utility.set_location('source is element entry',20);

1103: l_el_curr_cd := p_currency_cd;
1104: l_uom := p_uom;
1105: if p_source_cd = 'EE' then
1106:
1107: hr_utility.set_location('source is element entry',20);
1108:
1109: get_element_details(p_item_key => p_source_key,
1110: p_effective_date => p_effective_date,
1111: p_comp_type_cd => p_comp_typ_cd,

Line 1124: hr_utility.set_location('element processing type is '||l_proc_type,31);

1120: p_period_start_date => p_perd_st_dt
1121: );
1122:
1123:
1124: hr_utility.set_location('element processing type is '||l_proc_type,31);
1125: hr_utility.set_location('element uom is '||l_uom,31);
1126: hr_utility.set_location('element input currency code is '||l_el_curr_cd,31);
1127:
1128: IF (g_status = '1A' )THEN

Line 1125: hr_utility.set_location('element uom is '||l_uom,31);

1121: );
1122:
1123:
1124: hr_utility.set_location('element processing type is '||l_proc_type,31);
1125: hr_utility.set_location('element uom is '||l_uom,31);
1126: hr_utility.set_location('element input currency code is '||l_el_curr_cd,31);
1127:
1128: IF (g_status = '1A' )THEN
1129: WRITE(' The Input Value is not valid as of the Period End Date');

Line 1126: hr_utility.set_location('element input currency code is '||l_el_curr_cd,31);

1122:
1123:
1124: hr_utility.set_location('element processing type is '||l_proc_type,31);
1125: hr_utility.set_location('element uom is '||l_uom,31);
1126: hr_utility.set_location('element input currency code is '||l_el_curr_cd,31);
1127:
1128: IF (g_status = '1A' )THEN
1129: WRITE(' The Input Value is not valid as of the Period End Date');
1130: hr_utility.set_location('1a' ,99);

Line 1130: hr_utility.set_location('1a' ,99);

1126: hr_utility.set_location('element input currency code is '||l_el_curr_cd,31);
1127:
1128: IF (g_status = '1A' )THEN
1129: WRITE(' The Input Value is not valid as of the Period End Date');
1130: hr_utility.set_location('1a' ,99);
1131: END IF;
1132:
1133:
1134: if g_status = '0' then

Line 1147: hr_utility.set_location('summary table count '||l_summary.count, 30);

1143: p_lookup_type => l_lookup_type,
1144: p_value_set_id => l_value_set_id ,
1145: p_actual_currency_code=> l_actual_currency_code );
1146:
1147: hr_utility.set_location('summary table count '||l_summary.count, 30);
1148: hr_utility.set_location('l_proc_type '||l_proc_type, 30);
1149: hr_utility.set_location('l_uom '||l_uom, 30);
1150:
1151: --commented for Bug#5098869

Line 1148: hr_utility.set_location('l_proc_type '||l_proc_type, 30);

1144: p_value_set_id => l_value_set_id ,
1145: p_actual_currency_code=> l_actual_currency_code );
1146:
1147: hr_utility.set_location('summary table count '||l_summary.count, 30);
1148: hr_utility.set_location('l_proc_type '||l_proc_type, 30);
1149: hr_utility.set_location('l_uom '||l_uom, 30);
1150:
1151: --commented for Bug#5098869
1152: -- if l_proc_type ='R' and l_uom is null then

Line 1149: hr_utility.set_location('l_uom '||l_uom, 30);

1145: p_actual_currency_code=> l_actual_currency_code );
1146:
1147: hr_utility.set_location('summary table count '||l_summary.count, 30);
1148: hr_utility.set_location('l_proc_type '||l_proc_type, 30);
1149: hr_utility.set_location('l_uom '||l_uom, 30);
1150:
1151: --commented for Bug#5098869
1152: -- if l_proc_type ='R' and l_uom is null then
1153: -- added for for Bug#5098869

Line 1157: hr_utility.set_location('Processing type is Recurring ', 30);

1153: -- added for for Bug#5098869
1154:
1155: if ( l_summary.count > 0) then
1156: if l_proc_type ='R' then
1157: hr_utility.set_location('Processing type is Recurring ', 30);
1158: hr_utility.set_location('st'||p_perd_st_dt ||'end'||p_perd_en_dt,40);
1159:
1160: pay_details ( p_elm_table => l_summary,
1161: p_source_key => p_source_key,

Line 1158: hr_utility.set_location('st'||p_perd_st_dt ||'end'||p_perd_en_dt,40);

1154:
1155: if ( l_summary.count > 0) then
1156: if l_proc_type ='R' then
1157: hr_utility.set_location('Processing type is Recurring ', 30);
1158: hr_utility.set_location('st'||p_perd_st_dt ||'end'||p_perd_en_dt,40);
1159:
1160: pay_details ( p_elm_table => l_summary,
1161: p_source_key => p_source_key,
1162: p_assignment_id => p_assignment_id,

Line 1172: hr_utility.set_location('Processing tye is N '||l_summary.count, 30);

1168: p_actual_uom => l_actual_uom
1169: );
1170: elsif l_proc_type ='N' then
1171:
1172: hr_utility.set_location('Processing tye is N '||l_summary.count, 30);
1173:
1174: populate_result_table(p_elm_table => l_summary,
1175: p_currency_cd => l_el_curr_cd,
1176: p_uom => l_uom,

Line 1190: hr_utility.set_location('source is Payroll Costing',20);

1186: end if;
1187:
1188: elsif p_source_cd = 'PAYCOSTG' then
1189:
1190: hr_utility.set_location('source is Payroll Costing',20);
1191:
1192: cost_entries (p_assignment_id => p_assignment_id,
1193: p_perd_start_date => p_perd_st_dt,
1194: p_perd_end_date => p_perd_en_dt,

Line 1203: hr_utility.set_location('source is Benefit balances',20);

1199: p_cost_table => p_result);
1200:
1201: elsif p_source_cd = 'BB' then
1202:
1203: hr_utility.set_location('source is Benefit balances',20);
1204:
1205: bnfts_entries(p_person_id => p_person_id,
1206: p_perd_st_dt => p_perd_st_dt,
1207: p_perd_en_dt => p_perd_en_dt,

Line 1217: hr_utility.set_location('source is Third Party payroll',20);

1213: );
1214:
1215: elsif p_source_cd = 'THRDPTYPAY' then
1216:
1217: hr_utility.set_location('source is Third Party payroll',20);
1218:
1219: thrd_pty_entries(p_assignment_id => p_assignment_id,
1220: p_perd_start_date => p_perd_st_dt,
1221: p_perd_end_date => p_perd_en_dt,

Line 1230: hr_utility.set_location('source is Rule',20);

1226: p_thrd_pty_table => p_result);
1227:
1228: elsif p_source_cd = 'RULE' then
1229:
1230: hr_utility.set_location('source is Rule',20);
1231:
1232: rule_entries(p_assignment_id => p_assignment_id,
1233: p_perd_start_date => p_perd_st_dt,
1234: p_perd_end_date => p_perd_en_dt,

Line 1245: hr_utility.set_location('source is Run Results',20);

1241: --VKODEDAL 7012521 RUN RESULT ER
1242: ----------------------------------------------------------------
1243: elsif p_source_cd = 'RR' then
1244:
1245: hr_utility.set_location('source is Run Results',20);
1246:
1247: run_results (p_assignment_id => p_assignment_id,
1248: p_perd_start_date => p_perd_st_dt,
1249: p_perd_end_date => p_perd_en_dt,

Line 1257: hr_utility.set_location('Invalid Source Code '||p_source_cd, 200);

1253: p_uom => p_uom,
1254: p_result_table => p_result);
1255: -----------------------------------------------------------------------
1256: else
1257: hr_utility.set_location('Invalid Source Code '||p_source_cd, 200);
1258: g_status := '6';
1259:
1260: end if;
1261:

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

1264: ELSE
1265: p_status := g_status;
1266: END IF;
1267:
1268: hr_utility.set_location('Leaving'||l_proc,10);
1269:
1270: end get_value_for_item;
1271: end BEN_TCS_COMPENSATION;