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

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

178: l_benefit_end_date VARCHAR2(20);
179: l_token_value VARCHAR2(50);
180: l_proc VARCHAR2(50) := g_package || 'get_parameters';
181: BEGIN
182: hr_utility.set_location('Entering '|| l_proc, 10);
183: hr_utility.set_location('Step '|| l_proc, 20);
184: hr_utility.set_location('p_token_name = '|| p_token_name, 20);
185: OPEN csr_parameter_info(p_payroll_action_id, p_token_name);
186: FETCH csr_parameter_info INTO l_token_value, l_business_group_id, l_benefit_start_date, l_benefit_end_date;

Line 183: hr_utility.set_location('Step '|| l_proc, 20);

179: l_token_value VARCHAR2(50);
180: l_proc VARCHAR2(50) := g_package || 'get_parameters';
181: BEGIN
182: hr_utility.set_location('Entering '|| l_proc, 10);
183: hr_utility.set_location('Step '|| l_proc, 20);
184: hr_utility.set_location('p_token_name = '|| p_token_name, 20);
185: OPEN csr_parameter_info(p_payroll_action_id, p_token_name);
186: FETCH csr_parameter_info INTO l_token_value, l_business_group_id, l_benefit_start_date, l_benefit_end_date;
187: CLOSE csr_parameter_info;

Line 184: hr_utility.set_location('p_token_name = '|| p_token_name, 20);

180: l_proc VARCHAR2(50) := g_package || 'get_parameters';
181: BEGIN
182: hr_utility.set_location('Entering '|| l_proc, 10);
183: hr_utility.set_location('Step '|| l_proc, 20);
184: hr_utility.set_location('p_token_name = '|| p_token_name, 20);
185: OPEN csr_parameter_info(p_payroll_action_id, p_token_name);
186: FETCH csr_parameter_info INTO l_token_value, l_business_group_id, l_benefit_start_date, l_benefit_end_date;
187: CLOSE csr_parameter_info;
188:

Line 202: hr_utility.set_location('p_token_value = '|| p_token_value, 60);

198: ELSE
199: p_token_value := l_token_value;
200: END IF;
201:
202: hr_utility.set_location('p_token_value = '|| p_token_value, 60);
203: hr_utility.set_location('Leaving '|| l_proc, 70);
204: END get_parameters;
205:
206: FUNCTION check_assignment_tax_ref(p_assignment_id number,

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

199: p_token_value := l_token_value;
200: END IF;
201:
202: hr_utility.set_location('p_token_value = '|| p_token_value, 60);
203: hr_utility.set_location('Leaving '|| l_proc, 70);
204: END get_parameters;
205:
206: FUNCTION check_assignment_tax_ref(p_assignment_id number,
207: p_tax_ref varchar2,

Line 267: hr_utility.TRACE('.. MATCHED..');

263:
264: IF g_val_ff_tab(l_check_item).l_row_name = p_element_name
265: THEN
266: l_match := TRUE;
267: hr_utility.TRACE('.. MATCHED..');
268: EXIT;
269: ELSIF p_element_name < g_val_ff_tab(l_check_item).l_row_name
270: THEN
271: -- search below this

Line 304: hr_utility.TRACE(' Returning l_first_matching_item '|| l_first_matching_item);

300: END LOOP;
301: END IF;
302: END IF;
303:
304: hr_utility.TRACE(' Returning l_first_matching_item '|| l_first_matching_item);
305: RETURN l_first_matching_item;
306: END;
307: BEGIN
308: hr_utility.TRACE('inside find_exec_formula');

Line 308: hr_utility.TRACE('inside find_exec_formula');

304: hr_utility.TRACE(' Returning l_first_matching_item '|| l_first_matching_item);
305: RETURN l_first_matching_item;
306: END;
307: BEGIN
308: hr_utility.TRACE('inside find_exec_formula');
309: hr_utility.TRACE('g_val_ff_tab.count '|| g_val_ff_tab.COUNT);
310: hr_utility.TRACE('p_element_name '|| p_element_name);
311: hr_utility.TRACE('p_element_name '|| p_element_name);
312: hr_utility.TRACE('p_effective_date '|| TO_DATE(p_effective_date, 'DD/MM/YYYY') );

Line 309: hr_utility.TRACE('g_val_ff_tab.count '|| g_val_ff_tab.COUNT);

305: RETURN l_first_matching_item;
306: END;
307: BEGIN
308: hr_utility.TRACE('inside find_exec_formula');
309: hr_utility.TRACE('g_val_ff_tab.count '|| g_val_ff_tab.COUNT);
310: hr_utility.TRACE('p_element_name '|| p_element_name);
311: hr_utility.TRACE('p_element_name '|| p_element_name);
312: hr_utility.TRACE('p_effective_date '|| TO_DATE(p_effective_date, 'DD/MM/YYYY') );
313: l_search_from := find_first_entry;

Line 310: hr_utility.TRACE('p_element_name '|| p_element_name);

306: END;
307: BEGIN
308: hr_utility.TRACE('inside find_exec_formula');
309: hr_utility.TRACE('g_val_ff_tab.count '|| g_val_ff_tab.COUNT);
310: hr_utility.TRACE('p_element_name '|| p_element_name);
311: hr_utility.TRACE('p_element_name '|| p_element_name);
312: hr_utility.TRACE('p_effective_date '|| TO_DATE(p_effective_date, 'DD/MM/YYYY') );
313: l_search_from := find_first_entry;
314:

Line 311: hr_utility.TRACE('p_element_name '|| p_element_name);

307: BEGIN
308: hr_utility.TRACE('inside find_exec_formula');
309: hr_utility.TRACE('g_val_ff_tab.count '|| g_val_ff_tab.COUNT);
310: hr_utility.TRACE('p_element_name '|| p_element_name);
311: hr_utility.TRACE('p_element_name '|| p_element_name);
312: hr_utility.TRACE('p_effective_date '|| TO_DATE(p_effective_date, 'DD/MM/YYYY') );
313: l_search_from := find_first_entry;
314:
315: IF l_search_from <> 0

Line 312: hr_utility.TRACE('p_effective_date '|| TO_DATE(p_effective_date, 'DD/MM/YYYY') );

308: hr_utility.TRACE('inside find_exec_formula');
309: hr_utility.TRACE('g_val_ff_tab.count '|| g_val_ff_tab.COUNT);
310: hr_utility.TRACE('p_element_name '|| p_element_name);
311: hr_utility.TRACE('p_element_name '|| p_element_name);
312: hr_utility.TRACE('p_effective_date '|| TO_DATE(p_effective_date, 'DD/MM/YYYY') );
313: l_search_from := find_first_entry;
314:
315: IF l_search_from <> 0
316: THEN

Line 317: hr_utility.TRACE('l_search_from '|| l_search_from);

313: l_search_from := find_first_entry;
314:
315: IF l_search_from <> 0
316: THEN
317: hr_utility.TRACE('l_search_from '|| l_search_from);
318:
319: FOR l_counter IN l_search_from .. g_val_ff_tab.COUNT
320: LOOP
321: hr_utility.TRACE(

Line 321: hr_utility.TRACE(

317: hr_utility.TRACE('l_search_from '|| l_search_from);
318:
319: FOR l_counter IN l_search_from .. g_val_ff_tab.COUNT
320: LOOP
321: hr_utility.TRACE(
322: 'g_val_ff_tab(l_counter).l_row_effective_start_date '
323: || TO_DATE(g_val_ff_tab(l_counter).l_row_effective_start_date, 'DD/MM/YYYY') );
324: hr_utility.TRACE(
325: 'g_val_ff_tab(l_counter).l_row_effective_end_date '

Line 324: hr_utility.TRACE(

320: LOOP
321: hr_utility.TRACE(
322: 'g_val_ff_tab(l_counter).l_row_effective_start_date '
323: || TO_DATE(g_val_ff_tab(l_counter).l_row_effective_start_date, 'DD/MM/YYYY') );
324: hr_utility.TRACE(
325: 'g_val_ff_tab(l_counter).l_row_effective_end_date '
326: || TO_DATE(g_val_ff_tab(l_counter).l_row_effective_end_date, 'DD/MM/YYYY') );
327: hr_utility.TRACE(
328: 'l_val_effective_start_date '|| TO_DATE(

Line 327: hr_utility.TRACE(

323: || TO_DATE(g_val_ff_tab(l_counter).l_row_effective_start_date, 'DD/MM/YYYY') );
324: hr_utility.TRACE(
325: 'g_val_ff_tab(l_counter).l_row_effective_end_date '
326: || TO_DATE(g_val_ff_tab(l_counter).l_row_effective_end_date, 'DD/MM/YYYY') );
327: hr_utility.TRACE(
328: 'l_val_effective_start_date '|| TO_DATE(
329: g_val_ff_tab(l_counter).l_val_effective_start_date,
330: 'DD/MM/YYYY') );
331: hr_utility.TRACE(

Line 331: hr_utility.TRACE(

327: hr_utility.TRACE(
328: 'l_val_effective_start_date '|| TO_DATE(
329: g_val_ff_tab(l_counter).l_val_effective_start_date,
330: 'DD/MM/YYYY') );
331: hr_utility.TRACE(
332: 'g_val_ff_tab(l_counter).l_val_effective_end_date '
333: || TO_DATE(g_val_ff_tab(l_counter).l_val_effective_end_date, 'DD/MM/YYYY') );
334: hr_utility.TRACE(
335: 'l_ff_effective_start_date '|| TO_DATE(g_val_ff_tab(l_counter).l_ff_effective_start_date, 'DD/MM/YYYY') );

Line 334: hr_utility.TRACE(

330: 'DD/MM/YYYY') );
331: hr_utility.TRACE(
332: 'g_val_ff_tab(l_counter).l_val_effective_end_date '
333: || TO_DATE(g_val_ff_tab(l_counter).l_val_effective_end_date, 'DD/MM/YYYY') );
334: hr_utility.TRACE(
335: 'l_ff_effective_start_date '|| TO_DATE(g_val_ff_tab(l_counter).l_ff_effective_start_date, 'DD/MM/YYYY') );
336: hr_utility.TRACE(
337: 'l_ff_effective_end_date '|| TO_DATE(g_val_ff_tab(l_counter).l_ff_effective_end_date, 'DD/MM/YYYY') );
338:

Line 336: hr_utility.TRACE(

332: 'g_val_ff_tab(l_counter).l_val_effective_end_date '
333: || TO_DATE(g_val_ff_tab(l_counter).l_val_effective_end_date, 'DD/MM/YYYY') );
334: hr_utility.TRACE(
335: 'l_ff_effective_start_date '|| TO_DATE(g_val_ff_tab(l_counter).l_ff_effective_start_date, 'DD/MM/YYYY') );
336: hr_utility.TRACE(
337: 'l_ff_effective_end_date '|| TO_DATE(g_val_ff_tab(l_counter).l_ff_effective_end_date, 'DD/MM/YYYY') );
338:
339: IF g_val_ff_tab(l_counter).l_row_name = p_element_name
340: AND p_effective_date BETWEEN g_val_ff_tab(l_counter).l_row_effective_start_date

Line 427: -- -- hr_utility.trace_on(null,'ARCH');

423: END LOOP;
424: END;
425: BEGIN
426:
427: -- -- hr_utility.trace_on(null,'ARCH');
428: hr_utility.set_location('Entering '|| l_proc, 10);
429: g_pactid := p_payroll_action_id;
430: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
431: p_payroll_action_id => p_payroll_action_id,

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

424: END;
425: BEGIN
426:
427: -- -- hr_utility.trace_on(null,'ARCH');
428: hr_utility.set_location('Entering '|| l_proc, 10);
429: g_pactid := p_payroll_action_id;
430: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
431: p_payroll_action_id => p_payroll_action_id,
432: p_token_name => 'PAYROLL',

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

466: p_token_value => g_param_rep_run);
467:
468: l_table_id := fetch_validation_table_id('VALIDATION_FORMULA_NAME');
469: populate_table_value(g_param_business_group_id, l_table_id, 'FORMULA_NAME');
470: hr_utility.set_location('Leaving '|| l_proc, 10);
471: END archinit;
472:
473: PROCEDURE range_cursor(pactid IN NUMBER, sqlstr OUT NOCOPY VARCHAR2)
474: IS

Line 479: -- hr_utility.trace_on(null,'ARCH');

475: l_proc CONSTANT VARCHAR2(50) := g_package || ' range_cursor';
476: l_person_id number;
477: BEGIN
478:
479: -- hr_utility.trace_on(null,'ARCH');
480:
481: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
482: p_payroll_action_id => pactid,
483: p_token_name => 'PERSON',

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

482: p_payroll_action_id => pactid,
483: p_token_name => 'PERSON',
484: p_token_value => l_person_id);
485:
486: hr_utility.set_location('Entering '|| l_proc, 10);
487:
488: if l_person_id is not null then
489: sqlstr :=
490: 'SELECT DISTINCT person_id

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

501: WHERE ppa.payroll_action_id = :payroll_action_id
502: AND ppa.business_group_id +0= ppf.business_group_id
503: ORDER BY ppf.person_id';
504: end if;
505: hr_utility.set_location('Leaving '|| l_proc, 20);
506: END range_cursor;
507:
508: PROCEDURE action_creation(pactid IN NUMBER, stperson IN NUMBER, endperson IN NUMBER, CHUNK IN NUMBER)
509: IS

Line 763: -- hr_utility.trace_on(null,'ARCH');

759: return SUBSTR(l_leg_param, X + Y + 1, Z);
760: end;
761:
762: BEGIN
763: -- hr_utility.trace_on(null,'ARCH');
764: hr_utility.set_location('Entering '|| l_proc, 10);
765:
766: -- could not use the param parameters initialised in init procedure
767: -- as the action creation does not get called at all if i use them

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

760: end;
761:
762: BEGIN
763: -- hr_utility.trace_on(null,'ARCH');
764: hr_utility.set_location('Entering '|| l_proc, 10);
765:
766: -- could not use the param parameters initialised in init procedure
767: -- as the action creation does not get called at all if i use them
768: select legislative_parameters,

Line 800: hr_utility.raise_error;

796: fnd_message.set_token('NAME', 'Benefit Start Date');
797: fnd_message.set_token('VAL1', '06-04-' ||to_char(to_number(l_rep_run)-1));
798: fnd_message.set_token('VAL2', '05-04-' ||l_rep_run);
799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
800: hr_utility.raise_error;
801: End if;
802:
803: If fnd_date.canonical_to_date(l_benefit_end_date) <
804: to_date('06-04-' ||to_char(to_number(l_rep_run)-1),'dd-mm-yyyy') or

Line 818: hr_utility.raise_error;

814: fnd_message.set_token('NAME', 'Benefit End Date');
815: fnd_message.set_token('VAL1', '06-04-' ||to_char(to_number(l_rep_run)-1));
816: fnd_message.set_token('VAL2', '05-04-' ||l_rep_run);
817: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
818: hr_utility.raise_error;
819: End if;
820: hr_utility.set_location('Step '|| l_proc, 20);
821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);

Line 820: hr_utility.set_location('Step '|| l_proc, 20);

816: fnd_message.set_token('VAL2', '05-04-' ||l_rep_run);
817: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
818: hr_utility.raise_error;
819: End if;
820: hr_utility.set_location('Step '|| l_proc, 20);
821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);

Line 821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);

817: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
818: hr_utility.raise_error;
819: End if;
820: hr_utility.set_location('Step '|| l_proc, 20);
821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);

Line 822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);

818: hr_utility.raise_error;
819: End if;
820: hr_utility.set_location('Step '|| l_proc, 20);
821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);

Line 823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);

819: End if;
820: hr_utility.set_location('Step '|| l_proc, 20);
821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);

Line 824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);

820: hr_utility.set_location('Step '|| l_proc, 20);
821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);
828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);

Line 825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);

821: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);
822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);
828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);
829: hr_utility.set_location('Before the cursor assignment id ', 30);

Line 826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);

822: hr_utility.set_location('l_benefit_end_date = '|| l_benefit_end_date, 20);
823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);
828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);
829: hr_utility.set_location('Before the cursor assignment id ', 30);
830: -- removed for bug 6278134

Line 827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);

823: hr_utility.set_location('l_business_group_id = '|| l_business_group_id, 20);
824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);
828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);
829: hr_utility.set_location('Before the cursor assignment id ', 30);
830: -- removed for bug 6278134
831: /* open csr_flex_id(l_tax_reference);

Line 828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);

824: hr_utility.set_location('l_tax_reference = '|| l_tax_reference, 20);
825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);
828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);
829: hr_utility.set_location('Before the cursor assignment id ', 30);
830: -- removed for bug 6278134
831: /* open csr_flex_id(l_tax_reference);
832: fetch csr_flex_id into l_flex_id;

Line 829: hr_utility.set_location('Before the cursor assignment id ', 30);

825: hr_utility.set_location('l_consolidation_set_id = '|| l_consolidation_set_id, 20);
826: hr_utility.set_location('l_payroll_id = '|| l_payroll_id, 20);
827: hr_utility.set_location('l_person_id = '|| l_person_id, 20);
828: hr_utility.set_location('l_assignment_set_id = '|| l_assignment_set_id, 20);
829: hr_utility.set_location('Before the cursor assignment id ', 30);
830: -- removed for bug 6278134
831: /* open csr_flex_id(l_tax_reference);
832: fetch csr_flex_id into l_flex_id;
833: close csr_flex_id; */

Line 879: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);

875: --bug 6278134 added check for Include and Exclude conditions
876: IF l_set_type = 'I' then
877: FOR csr_rec IN csr_assign_set_X
878: LOOP
879: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);
880: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
881: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
882: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
883: THEN

Line 880: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

876: IF l_set_type = 'I' then
877: FOR csr_rec IN csr_assign_set_X
878: LOOP
879: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);
880: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
881: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
882: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
883: THEN
884: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 889: hr_utility.set_location('Archive assignment Action ', 30);

885: SELECT pay_assignment_actions_s.NEXTVAL
886: INTO l_actid
887: FROM DUAL;
888:
889: hr_utility.set_location('Archive assignment Action ', 30);
890: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
891: l_prev_assignment_id := csr_rec.assignment_id;
892: hr_utility.TRACE(' Created Assignment action ');
893: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

Line 892: hr_utility.TRACE(' Created Assignment action ');

888:
889: hr_utility.set_location('Archive assignment Action ', 30);
890: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
891: l_prev_assignment_id := csr_rec.assignment_id;
892: hr_utility.TRACE(' Created Assignment action ');
893: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
894: END IF;
895:
896: g_ben_asg_count := g_ben_asg_count + 1;

Line 893: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

889: hr_utility.set_location('Archive assignment Action ', 30);
890: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
891: l_prev_assignment_id := csr_rec.assignment_id;
892: hr_utility.TRACE(' Created Assignment action ');
893: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
894: END IF;
895:
896: g_ben_asg_count := g_ben_asg_count + 1;
897: hr_utility.set_location('Inside the cursor assignment id ', 30);

Line 897: hr_utility.set_location('Inside the cursor assignment id ', 30);

893: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
894: END IF;
895:
896: g_ben_asg_count := g_ben_asg_count + 1;
897: hr_utility.set_location('Inside the cursor assignment id ', 30);
898: g_tab_ben_detail(g_ben_asg_count).assignment_action_id := l_actid;
899: g_tab_ben_detail(g_ben_asg_count).element_type_id := csr_rec.element_type_id;
900: g_tab_ben_detail(g_ben_asg_count).element_entry_id := csr_rec.element_entry_id;
901: g_tab_ben_detail(g_ben_asg_count).element_name := csr_rec.element_name;

Line 911: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);

907: END LOOP;
908: ELSIF l_set_type = 'E' then
909: FOR csr_rec IN csr_assign_set_EX
910: LOOP
911: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);
912: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
913: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
914: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
915: THEN

Line 912: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

908: ELSIF l_set_type = 'E' then
909: FOR csr_rec IN csr_assign_set_EX
910: LOOP
911: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);
912: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
913: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
914: if l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
915: THEN
916: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 921: hr_utility.set_location('Archive assignment Action ', 30);

917: SELECT pay_assignment_actions_s.NEXTVAL
918: INTO l_actid
919: FROM DUAL;
920:
921: hr_utility.set_location('Archive assignment Action ', 30);
922: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
923: l_prev_assignment_id := csr_rec.assignment_id;
924: hr_utility.TRACE(' Created Assignment action ');
925: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

Line 924: hr_utility.TRACE(' Created Assignment action ');

920:
921: hr_utility.set_location('Archive assignment Action ', 30);
922: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
923: l_prev_assignment_id := csr_rec.assignment_id;
924: hr_utility.TRACE(' Created Assignment action ');
925: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
926: END IF;
927:
928: g_ben_asg_count := g_ben_asg_count + 1;

Line 925: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

921: hr_utility.set_location('Archive assignment Action ', 30);
922: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
923: l_prev_assignment_id := csr_rec.assignment_id;
924: hr_utility.TRACE(' Created Assignment action ');
925: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
926: END IF;
927:
928: g_ben_asg_count := g_ben_asg_count + 1;
929: hr_utility.set_location('Inside the cursor assignment id ', 30);

Line 929: hr_utility.set_location('Inside the cursor assignment id ', 30);

925: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
926: END IF;
927:
928: g_ben_asg_count := g_ben_asg_count + 1;
929: hr_utility.set_location('Inside the cursor assignment id ', 30);
930: g_tab_ben_detail(g_ben_asg_count).assignment_action_id := l_actid;
931: g_tab_ben_detail(g_ben_asg_count).element_type_id := csr_rec.element_type_id;
932: g_tab_ben_detail(g_ben_asg_count).element_entry_id := csr_rec.element_entry_id;
933: g_tab_ben_detail(g_ben_asg_count).element_name := csr_rec.element_name;

Line 944: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);

940: END IF;
941: else
942: FOR csr_rec in csr_noassign_set
943: LOOP
944: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);
945: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
946: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
947: IF l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
948: THEN

Line 945: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

941: else
942: FOR csr_rec in csr_noassign_set
943: LOOP
944: hr_utility.TRACE(' l_prev_assignment_id '|| l_prev_assignment_id);
945: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
946: if check_assignment_tax_ref(csr_rec.assignment_id,l_tax_reference,l_benefit_end_date) then
947: IF l_prev_assignment_id IS NULL OR l_prev_assignment_id <> csr_rec.assignment_id
948: THEN
949: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 953: hr_utility.set_location('Archive assignment Action ', 30);

949: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
950: SELECT pay_assignment_actions_s.NEXTVAL
951: INTO l_actid
952: FROM DUAL;
953: hr_utility.set_location('Archive assignment Action ', 30);
954: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
955: l_prev_assignment_id := csr_rec.assignment_id;
956: hr_utility.TRACE(' Created Assignment action ');
957: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

Line 956: hr_utility.TRACE(' Created Assignment action ');

952: FROM DUAL;
953: hr_utility.set_location('Archive assignment Action ', 30);
954: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
955: l_prev_assignment_id := csr_rec.assignment_id;
956: hr_utility.TRACE(' Created Assignment action ');
957: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
958: END IF;
959:
960: g_ben_asg_count := g_ben_asg_count + 1;

Line 957: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);

953: hr_utility.set_location('Archive assignment Action ', 30);
954: hr_nonrun_asact.insact(l_actid, csr_rec.assignment_id, pactid, CHUNK, NULL);
955: l_prev_assignment_id := csr_rec.assignment_id;
956: hr_utility.TRACE(' Created Assignment action ');
957: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
958: END IF;
959:
960: g_ben_asg_count := g_ben_asg_count + 1;
961: hr_utility.set_location('Inside the cursor assignment id ', 30);

Line 961: hr_utility.set_location('Inside the cursor assignment id ', 30);

957: hr_utility.TRACE(' csr_rec.assignment_id '|| csr_rec.assignment_id);
958: END IF;
959:
960: g_ben_asg_count := g_ben_asg_count + 1;
961: hr_utility.set_location('Inside the cursor assignment id ', 30);
962: g_tab_ben_detail(g_ben_asg_count).assignment_action_id := l_actid;
963: g_tab_ben_detail(g_ben_asg_count).element_type_id := csr_rec.element_type_id;
964: g_tab_ben_detail(g_ben_asg_count).element_entry_id := csr_rec.element_entry_id;
965: g_tab_ben_detail(g_ben_asg_count).element_name := csr_rec.element_name;

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

972: end if;
973: -- END LOOP;
974: --end of bug 6278134
975: end if; -- end l_archive
976: hr_utility.set_location('Leaving '|| l_proc, 20);
977: END action_creation;
978:
979: PROCEDURE archive_code(p_assactid IN NUMBER, p_effective_date IN DATE)
980: IS

Line 1283: hr_utility.trace('Inside find_lowest_matching_index ');

1279: l_check_item INTEGER;
1280: l_first_matching_item INTEGER := 0;
1281: l_match BOOLEAN := FALSE;
1282: BEGIN
1283: hr_utility.trace('Inside find_lowest_matching_index ');
1284:
1285: l_lower := 1;
1286: l_upper := g_tab_ben_detail.COUNT;
1287:

Line 1295: hr_utility.TRACE('.. MATCHED..');

1291:
1292: IF g_tab_ben_detail(l_check_item).assignment_action_id = p_assactid
1293: THEN
1294: l_match := TRUE;
1295: hr_utility.TRACE('.. MATCHED..');
1296: EXIT;
1297: ELSIF p_assactid < g_tab_ben_detail(l_check_item).assignment_action_id
1298: THEN
1299: -- search below this

Line 1331: hr_utility.TRACE(' Returning l_first_matching_item '|| l_first_matching_item);

1327: END IF;
1328: END LOOP;
1329: END IF; -- end of l_check_item = 1
1330: END IF;-- end of l_match
1331: hr_utility.TRACE(' Returning l_first_matching_item '|| l_first_matching_item);
1332: RETURN l_first_matching_item;
1333: Exception
1334: when others then
1335: l_first_matching_item := 0;

Line 1343: hr_utility.TRACE('InsidePopulate_Payroll_info');

1339: --
1340: PROCEDURE populate_payroll_info(p_end_date VARCHAR2, p_payroll_id NUMBER)
1341: AS
1342: BEGIN
1343: hr_utility.TRACE('InsidePopulate_Payroll_info');
1344: hr_utility.TRACE('p_payroll_id '|| p_payroll_id);
1345: hr_utility.TRACE('p_end_date '|| p_end_date);
1346: -- end date is constant in the Archiver run
1347: -- hence we do nt need to worry about

Line 1344: hr_utility.TRACE('p_payroll_id '|| p_payroll_id);

1340: PROCEDURE populate_payroll_info(p_end_date VARCHAR2, p_payroll_id NUMBER)
1341: AS
1342: BEGIN
1343: hr_utility.TRACE('InsidePopulate_Payroll_info');
1344: hr_utility.TRACE('p_payroll_id '|| p_payroll_id);
1345: hr_utility.TRACE('p_end_date '|| p_end_date);
1346: -- end date is constant in the Archiver run
1347: -- hence we do nt need to worry about
1348: -- multiple recrds for a payroll id as date is fixed!

Line 1345: hr_utility.TRACE('p_end_date '|| p_end_date);

1341: AS
1342: BEGIN
1343: hr_utility.TRACE('InsidePopulate_Payroll_info');
1344: hr_utility.TRACE('p_payroll_id '|| p_payroll_id);
1345: hr_utility.TRACE('p_end_date '|| p_end_date);
1346: -- end date is constant in the Archiver run
1347: -- hence we do nt need to worry about
1348: -- multiple recrds for a payroll id as date is fixed!
1349:

Line 1361: hr_utility.set_location('payroll info not found: ', 30);

1357: l_pay_info_tab(p_payroll_id).l_employer_address;
1358:
1359: IF csr_payroll_info%NOTFOUND
1360: THEN
1361: hr_utility.set_location('payroll info not found: ', 30);
1362: CLOSE csr_payroll_info;
1363: RAISE payroll_not_found;
1364: ELSE
1365: CLOSE csr_payroll_info;

Line 1366: hr_utility.set_location('Archiving Payroll info', 35);

1362: CLOSE csr_payroll_info;
1363: RAISE payroll_not_found;
1364: ELSE
1365: CLOSE csr_payroll_info;
1366: hr_utility.set_location('Archiving Payroll info', 35);
1367: hr_utility.TRACE(' Found InsidePopulate_Payroll_info');
1368:
1369: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_tax_office_name) ) > 0
1370: THEN

Line 1367: hr_utility.TRACE(' Found InsidePopulate_Payroll_info');

1363: RAISE payroll_not_found;
1364: ELSE
1365: CLOSE csr_payroll_info;
1366: hr_utility.set_location('Archiving Payroll info', 35);
1367: hr_utility.TRACE(' Found InsidePopulate_Payroll_info');
1368:
1369: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_tax_office_name) ) > 0
1370: THEN
1371: -- fnd_file.put_line(fnd_file.output,'Tax Office Name contains illegal character(s) :' || l_tax_office_name );

Line 1434: -- hr_utility.trace_on(null,'AMAP');

1430: l_m_taxable_payment Number;
1431: l_taxable_pass_payment Number;
1432: l_ce Number;
1433: begin
1434: -- hr_utility.trace_on(null,'AMAP');
1435: l_C_BUS_MILES := nvl(per_formula_functions.get_number('C_BUS_MILES'),0);
1436: l_M_BUS_MILES := nvl(per_formula_functions.get_number('M_BUS_MILES'),0);
1437: l_B_BUS_MILES := nvl(per_formula_functions.get_number('B_BUS_MILES'),0);
1438: l_C_RATE1 := nvl(per_formula_functions.get_number('C_RATE1'),0);

Line 1459: hr_utility.trace(' l_c_net_allowance ' || l_c_net_allowance);

1455: if l_c_net_allowance < 0
1456: then
1457: l_c_net_allowance := 0;
1458: end if;
1459: hr_utility.trace(' l_c_net_allowance ' || l_c_net_allowance);
1460:
1461: if l_C_BUS_MILES > 10000 then
1462: l_c_tot_approved_payments := (10000 * l_C_RATE1) +
1463: (

Line 1474: hr_utility.trace(' l_c_taxable_payment ' || l_c_taxable_payment);

1470: if l_c_taxable_payment < 0 then
1471: l_c_taxable_payment := 0;
1472: end if;
1473:
1474: hr_utility.trace(' l_c_taxable_payment ' || l_c_taxable_payment);
1475:
1476: l_b_net_allowance := l_B_MILEAGE_PAYMENTS - l_B_TAX_DEDUCTED;
1477: if l_b_net_allowance < 0
1478: then

Line 1520: hr_utility.trace(' *l_ce ' || l_ce);

1516: /* bug 7201761 rounded to 2 decimals to avoid HRMC rejection */
1517: l_ce := round(l_taxable_pass_payment + l_c_taxable_payment +
1518: l_b_taxable_payment + l_m_taxable_payment,2);
1519: --
1520: hr_utility.trace(' *************l_ce ************' || l_ce);
1521: -- hr_utility.trace_off;
1522:
1523: return l_ce;
1524: end;

Line 1521: -- hr_utility.trace_off;

1517: l_ce := round(l_taxable_pass_payment + l_c_taxable_payment +
1518: l_b_taxable_payment + l_m_taxable_payment,2);
1519: --
1520: hr_utility.trace(' *************l_ce ************' || l_ce);
1521: -- hr_utility.trace_off;
1522:
1523: return l_ce;
1524: end;
1525:

Line 1687: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));

1683: p_action_information28 => per_formula_functions.get_number('H_CE1'),
1684: p_action_information29 => per_formula_functions.get_number('H_COUNT'),
1685: p_action_information30 => per_formula_functions.get_number('F_COUNT') );
1686:
1687: hr_utility.trace('FFFFFF Count : ' || per_formula_functions.get_number('F_COUNT'));
1688: --
1689: pay_action_information_api.create_action_information(
1690: p_action_information_id => l_action_info_id,
1691: p_action_context_id => p_assactid,

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

2817:
2818: BEGIN
2819:
2820: l_warn := 0;
2821: hr_utility.set_location('Entering '|| l_proc, 10);
2822: hr_utility.set_location('step '|| l_proc, 20);
2823: hr_utility.set_location('finding assignment id '|| l_proc, 20);
2824: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2825: p_payroll_action_id => g_pactid,

Line 2822: hr_utility.set_location('step '|| l_proc, 20);

2818: BEGIN
2819:
2820: l_warn := 0;
2821: hr_utility.set_location('Entering '|| l_proc, 10);
2822: hr_utility.set_location('step '|| l_proc, 20);
2823: hr_utility.set_location('finding assignment id '|| l_proc, 20);
2824: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2825: p_payroll_action_id => g_pactid,
2826: p_token_name => 'EDI_VALIDATION',

Line 2823: hr_utility.set_location('finding assignment id '|| l_proc, 20);

2819:
2820: l_warn := 0;
2821: hr_utility.set_location('Entering '|| l_proc, 10);
2822: hr_utility.set_location('step '|| l_proc, 20);
2823: hr_utility.set_location('finding assignment id '|| l_proc, 20);
2824: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2825: p_payroll_action_id => g_pactid,
2826: p_token_name => 'EDI_VALIDATION',
2827: p_token_value => l_edi_validation);

Line 2848: hr_utility.set_location('Inside the cursor val_elememt_entry_id ', 30);

2844: l_first_index_set := true;
2845: end if;
2846:
2847: g_ben_asg_count := g_ben_asg_count + 1;
2848: hr_utility.set_location('Inside the cursor val_elememt_entry_id ', 30);
2849: g_tab_ben_detail(g_ben_asg_count).assignment_action_id := p_assactid;
2850: g_tab_ben_detail(g_ben_asg_count).element_type_id := val_elememt_entry_id.element_type_id;
2851: g_tab_ben_detail(g_ben_asg_count).element_entry_id := val_elememt_entry_id.element_entry_id;
2852: g_tab_ben_detail(g_ben_asg_count).element_name := val_elememt_entry_id.element_name;

Line 2868: hr_utility.set_location('Calling pay_emp_action_arch', 20);

2864: l_assignment_id := g_tab_ben_detail(l_index).assignment_id;
2865: l_error_assignment := FALSE;
2866: l_error := '0';
2867: -- call generic procedure to retrieve and archive all data for EMPLOYEE DETAILS, ADDRESS DETAILS
2868: hr_utility.set_location('Calling pay_emp_action_arch', 20);
2869:
2870: open csr_get_term_date(l_assignment_id);
2871: fetch csr_get_term_date into l_actual_termination_date;
2872: close csr_get_term_date;

Line 2886: hr_utility.trace('before get_asg_end_date');

2882: if l_loan_threshold is null then
2883: l_loan_threshold := 5000;
2884: end if;
2885:
2886: hr_utility.trace('before get_asg_end_date');
2887: if (l_actual_termination_date is null) or
2888: (l_actual_termination_date > l_asg_max_end_date) then
2889: l_actual_termination_date := l_asg_max_end_date;
2890: end if;

Line 2892: -- hr_utility.trace('inside if');

2888: (l_actual_termination_date > l_asg_max_end_date) then
2889: l_actual_termination_date := l_asg_max_end_date;
2890: end if;
2891: --if l_actual_termination_date is null then
2892: -- hr_utility.trace('inside if');
2893: -- open csr_get_asg_end_date(l_assignment_id);
2894: -- fetch csr_get_asg_end_date into l_actual_termination_date;
2895: -- close csr_get_asg_end_date;
2896: --end if;

Line 2897: hr_utility.trace('after get_asg_end_date');

2893: -- open csr_get_asg_end_date(l_assignment_id);
2894: -- fetch csr_get_asg_end_date into l_actual_termination_date;
2895: -- close csr_get_asg_end_date;
2896: --end if;
2897: hr_utility.trace('after get_asg_end_date');
2898:
2899: pay_emp_action_arch.get_personal_information(
2900: p_payroll_action_id => g_pactid, -- archive payroll_action_id
2901: p_assactid => p_assactid, -- archive assignment_action_id

Line 2922: hr_utility.set_location('Returned from pay_emp_action_arch', 30);

2918: ), -- prepayment effective_date
2919: p_tax_unit_id => NULL, -- only required for US
2920: p_time_period_id => NULL, -- payroll time_period_id
2921: p_ppp_source_action_id => NULL);
2922: hr_utility.set_location('Returned from pay_emp_action_arch', 30);
2923:
2924: /* Perform NI Validation */
2925: validate_ni(
2926: p_assactid => p_assactid,

Line 2932: hr_utility.set_location('Returned from NI Validation',30);

2928: p_eff_date => least(nvl(l_actual_termination_date,
2929: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2930: fnd_date.canonical_to_date(g_param_benefit_end_date)));
2931:
2932: hr_utility.set_location('Returned from NI Validation',30);
2933: open csr_assignment_det(l_assignment_id, g_param_tax_reference);
2934: fetch csr_assignment_det into
2935: l_assignment_name, l_payroll_id, l_director_flag, l_first_name,
2936: l_middle_name, l_last_name, l_assignment_number, l_person_id, l_ni_number, l_sex, l_date_of_birth;

Line 2939: hr_utility.set_location('finding payroll info: ', 25);

2935: l_assignment_name, l_payroll_id, l_director_flag, l_first_name,
2936: l_middle_name, l_last_name, l_assignment_number, l_person_id, l_ni_number, l_sex, l_date_of_birth;
2937: close csr_assignment_det;
2938:
2939: hr_utility.set_location('finding payroll info: ', 25);
2940: hr_utility.set_location('payroll id: '|| l_payroll_id, 25);
2941: --set_payroll_info
2942: Begin
2943: IF l_pay_info_tab.EXISTS(l_payroll_id)

Line 2940: hr_utility.set_location('payroll id: '|| l_payroll_id, 25);

2936: l_middle_name, l_last_name, l_assignment_number, l_person_id, l_ni_number, l_sex, l_date_of_birth;
2937: close csr_assignment_det;
2938:
2939: hr_utility.set_location('finding payroll info: ', 25);
2940: hr_utility.set_location('payroll id: '|| l_payroll_id, 25);
2941: --set_payroll_info
2942: Begin
2943: IF l_pay_info_tab.EXISTS(l_payroll_id)
2944: THEN

Line 3008: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS', 50);

3004: p_action_information7 => l_pay_info_tab(l_payroll_id).l_employer_name,
3005: p_action_information8 => l_pay_info_tab(l_payroll_id).l_employer_address);
3006: END IF;
3007:
3008: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS', 50);
3009:
3010: IF pay_gb_eoy_magtape.validate_input(UPPER(l_first_name), 'P11D_EDI') > 0
3011: THEN
3012: l_error_assignment := TRUE;

Line 3103: -- hr_utility.trace_on(null,'ARCH');

3099:
3100: -- loop thru all the benefits
3101: -- resetting globals as earlier values should not be used!
3102: l_ret := per_formula_functions.remove_globals;
3103: -- hr_utility.trace_on(null,'ARCH');
3104:
3105: WHILE l_index <= g_tab_ben_detail.LAST
3106: LOOP
3107:

Line 3108: -- hr_utility.TRACE_on(null,'ERR');

3104:
3105: WHILE l_index <= g_tab_ben_detail.LAST
3106: LOOP
3107:
3108: -- hr_utility.TRACE_on(null,'ERR');
3109: l_element_name := g_tab_ben_detail(l_index).element_name;
3110: hr_utility.set_location('Element Name '|| l_element_name, 20);
3111: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3112: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);

Line 3110: hr_utility.set_location('Element Name '|| l_element_name, 20);

3106: LOOP
3107:
3108: -- hr_utility.TRACE_on(null,'ERR');
3109: l_element_name := g_tab_ben_detail(l_index).element_name;
3110: hr_utility.set_location('Element Name '|| l_element_name, 20);
3111: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3112: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);
3113: l_counter := 0;
3114:

Line 3111: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);

3107:
3108: -- hr_utility.TRACE_on(null,'ERR');
3109: l_element_name := g_tab_ben_detail(l_index).element_name;
3110: hr_utility.set_location('Element Name '|| l_element_name, 20);
3111: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3112: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);
3113: l_counter := 0;
3114:
3115: -- Setting the array l_user_inputs with the input values from

Line 3112: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);

3108: -- hr_utility.TRACE_on(null,'ERR');
3109: l_element_name := g_tab_ben_detail(l_index).element_name;
3110: hr_utility.set_location('Element Name '|| l_element_name, 20);
3111: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3112: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);
3113: l_counter := 0;
3114:
3115: -- Setting the array l_user_inputs with the input values from
3116: -- element entry value

Line 3117: hr_utility.set_location('Setting the input values ', 30);

3113: l_counter := 0;
3114:
3115: -- Setting the array l_user_inputs with the input values from
3116: -- element entry value
3117: hr_utility.set_location('Setting the input values ', 30);
3118:
3119:
3120: FOR entry_values IN csr_element_entry_values(
3121: g_tab_ben_detail(l_index).element_entry_id,

Line 3125: hr_utility.trace('entry_values.NAME ' || entry_values.NAME);

3121: g_tab_ben_detail(l_index).element_entry_id,
3122: g_tab_ben_detail(l_index).element_type_id,
3123: g_tab_ben_detail(l_index).effective_start_date)
3124: LOOP
3125: hr_utility.trace('entry_values.NAME ' || entry_values.NAME);
3126: l_counter := l_counter + 1;
3127: l_user_inputs(l_counter).NAME := TRIM(entry_values.NAME);
3128: l_user_inputs(l_counter).VALUE := TRIM(entry_values.screen_entry_value);
3129:

Line 3171: hr_utility.trace(' classification_name ' ||g_tab_ben_detail(l_index).classification_name);

3167: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3168: End if;
3169: -- Setting the array l_user_inputs with the input values from
3170: -- element entry flexfield
3171: hr_utility.trace(' classification_name ' ||g_tab_ben_detail(l_index).classification_name);
3172: hr_utility.trace('l_counter b4 entry flex values ' || l_counter);
3173:
3174: FOR entry_flex_values IN csr_element_entry_flex_values(g_tab_ben_detail(l_index).classification_name)
3175: LOOP

Line 3172: hr_utility.trace('l_counter b4 entry flex values ' || l_counter);

3168: End if;
3169: -- Setting the array l_user_inputs with the input values from
3170: -- element entry flexfield
3171: hr_utility.trace(' classification_name ' ||g_tab_ben_detail(l_index).classification_name);
3172: hr_utility.trace('l_counter b4 entry flex values ' || l_counter);
3173:
3174: FOR entry_flex_values IN csr_element_entry_flex_values(g_tab_ben_detail(l_index).classification_name)
3175: LOOP
3176: l_counter := l_counter + 1;

Line 3185: hr_utility.trace(' l_counter ' || l_counter);

3181: l_sql_stmt := l_sql_stmt || ' AND EFFECTIVE_START_DATE = :effec_st_date ';
3182: EXECUTE IMMEDIATE l_sql_stmt
3183: INTO l_user_inputs(l_counter).VALUE
3184: USING IN g_tab_ben_detail(l_index).element_entry_id, g_tab_ben_detail(l_index).effective_start_date;
3185: hr_utility.trace(' l_counter ' || l_counter);
3186: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3187: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3188: END LOOP;
3189:

Line 3186: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');

3182: EXECUTE IMMEDIATE l_sql_stmt
3183: INTO l_user_inputs(l_counter).VALUE
3184: USING IN g_tab_ben_detail(l_index).element_entry_id, g_tab_ben_detail(l_index).effective_start_date;
3185: hr_utility.trace(' l_counter ' || l_counter);
3186: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3187: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3188: END LOOP;
3189:
3190: -- hr_utility.trace_on(null,'NONIV');

Line 3187: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);

3183: INTO l_user_inputs(l_counter).VALUE
3184: USING IN g_tab_ben_detail(l_index).element_entry_id, g_tab_ben_detail(l_index).effective_start_date;
3185: hr_utility.trace(' l_counter ' || l_counter);
3186: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3187: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3188: END LOOP;
3189:
3190: -- hr_utility.trace_on(null,'NONIV');
3191: hr_utility.trace(' Out of loop');

Line 3190: -- hr_utility.trace_on(null,'NONIV');

3186: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3187: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3188: END LOOP;
3189:
3190: -- hr_utility.trace_on(null,'NONIV');
3191: hr_utility.trace(' Out of loop');
3192: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);
3193:
3194: For extra_archive_items in csr_non_iv_action_info_items (

Line 3191: hr_utility.trace(' Out of loop');

3187: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3188: END LOOP;
3189:
3190: -- hr_utility.trace_on(null,'NONIV');
3191: hr_utility.trace(' Out of loop');
3192: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);
3193:
3194: For extra_archive_items in csr_non_iv_action_info_items (
3195: g_tab_ben_detail(l_index).element_entry_id,

Line 3192: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);

3188: END LOOP;
3189:
3190: -- hr_utility.trace_on(null,'NONIV');
3191: hr_utility.trace(' Out of loop');
3192: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);
3193:
3194: For extra_archive_items in csr_non_iv_action_info_items (
3195: g_tab_ben_detail(l_index).element_entry_id,
3196: g_tab_ben_detail(l_index).element_type_id,

Line 3205: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);

3201: loop
3202: l_counter := l_counter + 1;
3203: l_user_inputs(l_counter).NAME := TRIM(extra_archive_items.NAME);
3204: l_user_inputs(l_counter).VALUE := null;
3205: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);
3206: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);
3207: end loop;
3208:
3209: hr_utility.trace('After Using pl/sql table');

Line 3206: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);

3202: l_counter := l_counter + 1;
3203: l_user_inputs(l_counter).NAME := TRIM(extra_archive_items.NAME);
3204: l_user_inputs(l_counter).VALUE := null;
3205: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);
3206: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);
3207: end loop;
3208:
3209: hr_utility.trace('After Using pl/sql table');
3210:

Line 3209: hr_utility.trace('After Using pl/sql table');

3205: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);
3206: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);
3207: end loop;
3208:
3209: hr_utility.trace('After Using pl/sql table');
3210:
3211: hr_utility.trace('l_counter after extra arch items ' || l_counter);
3212: -- hr_utility.trace_off;
3213: -- Setting the Business group id as this is needed for Car Validation!

Line 3211: hr_utility.trace('l_counter after extra arch items ' || l_counter);

3207: end loop;
3208:
3209: hr_utility.trace('After Using pl/sql table');
3210:
3211: hr_utility.trace('l_counter after extra arch items ' || l_counter);
3212: -- hr_utility.trace_off;
3213: -- Setting the Business group id as this is needed for Car Validation!
3214: l_counter := l_counter + 1;
3215: l_user_inputs(l_counter).NAME := 'BUSINESS_GROUP_ID';

Line 3212: -- hr_utility.trace_off;

3208:
3209: hr_utility.trace('After Using pl/sql table');
3210:
3211: hr_utility.trace('l_counter after extra arch items ' || l_counter);
3212: -- hr_utility.trace_off;
3213: -- Setting the Business group id as this is needed for Car Validation!
3214: l_counter := l_counter + 1;
3215: l_user_inputs(l_counter).NAME := 'BUSINESS_GROUP_ID';
3216: l_user_inputs(l_counter).VALUE := TO_CHAR(g_param_business_group_id);

Line 3223: hr_utility.set_location('Formula id '|| l_formula_id, 25);

3219: l_formula_id := find_exec_formula(
3220: l_element_name,
3221: fnd_date.canonical_to_date(l_benefit_end_date),
3222: l_formula_effective_start_date);
3223: hr_utility.set_location('Formula id '|| l_formula_id, 25);
3224:
3225: IF l_formula_id IS NOT NULL
3226: THEN
3227: hr_utility.set_location('Initializing the formula ', 40);

Line 3227: hr_utility.set_location('Initializing the formula ', 40);

3223: hr_utility.set_location('Formula id '|| l_formula_id, 25);
3224:
3225: IF l_formula_id IS NOT NULL
3226: THEN
3227: hr_utility.set_location('Initializing the formula ', 40);
3228: Begin
3229: ff_exec.init_formula(l_formula_id, l_formula_effective_start_date, l_inputs, l_outputs);
3230: Exception
3231: when OTHERS then

Line 3236: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);

3232: l_error_assignment := TRUE;
3233: l_error := '1';
3234: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3235: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3236: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3237: -- Remove ALL GLOBALS
3238: l_ret := per_formula_functions.remove_globals;
3239: RAISE error_found;
3240: End;

Line 3251: hr_utility.TRACE('l_outer ' || l_outer);

3247: LOOP
3248: IF l_inputs(l_outer).NAME = l_user_inputs(l_inner).NAME
3249: AND (l_user_inputs(l_inner).NAME IS NOT NULL OR l_user_inputs(l_inner).NAME <> '')
3250: THEN
3251: hr_utility.TRACE('l_outer ' || l_outer);
3252: hr_utility.TRACE('l_inner ' || l_inner);
3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);

Line 3252: hr_utility.TRACE('l_inner ' || l_inner);

3248: IF l_inputs(l_outer).NAME = l_user_inputs(l_inner).NAME
3249: AND (l_user_inputs(l_inner).NAME IS NOT NULL OR l_user_inputs(l_inner).NAME <> '')
3250: THEN
3251: hr_utility.TRACE('l_outer ' || l_outer);
3252: hr_utility.TRACE('l_inner ' || l_inner);
3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3256: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;

Line 3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');

3249: AND (l_user_inputs(l_inner).NAME IS NOT NULL OR l_user_inputs(l_inner).NAME <> '')
3250: THEN
3251: hr_utility.TRACE('l_outer ' || l_outer);
3252: hr_utility.TRACE('l_inner ' || l_inner);
3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3256: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3257: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);

Line 3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');

3250: THEN
3251: hr_utility.TRACE('l_outer ' || l_outer);
3252: hr_utility.TRACE('l_inner ' || l_inner);
3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3256: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3257: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);
3258: EXIT;

Line 3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);

3251: hr_utility.TRACE('l_outer ' || l_outer);
3252: hr_utility.TRACE('l_inner ' || l_inner);
3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3256: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3257: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);
3258: EXIT;
3259: END IF;

Line 3257: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);

3253: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3254: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3255: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3256: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3257: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);
3258: EXIT;
3259: END IF;
3260: if l_inputs(l_outer).NAME = 'EDI_VALIDATION' then
3261: l_inputs(l_outer).VALUE := l_edi_validation;

Line 3266: -- hr_utility.trace_on(null,'CAR');

3262: end if;
3263: END LOOP;
3264: END LOOP;
3265: END IF; -- end if for setting user inputs
3266: -- hr_utility.trace_on(null,'CAR');
3267: hr_utility.set_location('Running the formula ', 20);
3268: ff_exec.run_formula(l_inputs, l_outputs);
3269:
3270: -- Tapping the output from the formula using the l_outputs array

Line 3267: hr_utility.set_location('Running the formula ', 20);

3263: END LOOP;
3264: END LOOP;
3265: END IF; -- end if for setting user inputs
3266: -- hr_utility.trace_on(null,'CAR');
3267: hr_utility.set_location('Running the formula ', 20);
3268: ff_exec.run_formula(l_inputs, l_outputs);
3269:
3270: -- Tapping the output from the formula using the l_outputs array
3271: hr_utility.set_location('After Running the formula ', 20);

Line 3271: hr_utility.set_location('After Running the formula ', 20);

3267: hr_utility.set_location('Running the formula ', 20);
3268: ff_exec.run_formula(l_inputs, l_outputs);
3269:
3270: -- Tapping the output from the formula using the l_outputs array
3271: hr_utility.set_location('After Running the formula ', 20);
3272: FOR l_counter IN l_outputs.FIRST .. l_outputs.LAST
3273: LOOP
3274: IF l_outputs(l_counter).NAME = 'L_ERROR' AND l_outputs(l_counter).VALUE = '1'
3275: THEN

Line 3276: hr_utility.set_location('Error in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),65);

3272: FOR l_counter IN l_outputs.FIRST .. l_outputs.LAST
3273: LOOP
3274: IF l_outputs(l_counter).NAME = 'L_ERROR' AND l_outputs(l_counter).VALUE = '1'
3275: THEN
3276: hr_utility.set_location('Error in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),65);
3277: l_error := '1';
3278: ELSIF l_outputs(l_counter).NAME = 'L_WARN' AND l_outputs(l_counter).VALUE = '1'
3279: THEN
3280: hr_utility.set_location('Warning in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),66);

Line 3280: hr_utility.set_location('Warning in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),66);

3276: hr_utility.set_location('Error in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),65);
3277: l_error := '1';
3278: ELSIF l_outputs(l_counter).NAME = 'L_WARN' AND l_outputs(l_counter).VALUE = '1'
3279: THEN
3280: hr_utility.set_location('Warning in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),66);
3281: l_warn := '1';
3282: ELSIF (INSTR(UPPER(l_outputs(l_counter).NAME), 'MSG') > 0
3283: OR INSTR(UPPER(l_outputs(l_counter).NAME), 'MESSAGE') > 0
3284: OR (INSTR(UPPER(l_outputs(l_counter).NAME), 'ERR') > 0

Line 3303: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);

3299: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3300: pay_core_utils.push_token('TEXT', l_element_name ||': ' || SUBSTR(l_outputs(l_counter).VALUE, 2, 100) );
3301: end if;
3302: */
3303: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);
3304: END IF;
3305: hr_utility.TRACE(l_outputs(l_counter).NAME || ': ' || l_outputs(l_counter).VALUE);
3306: END LOOP;
3307: -- if the values of input values have changed within the formula

Line 3305: hr_utility.TRACE(l_outputs(l_counter).NAME || ': ' || l_outputs(l_counter).VALUE);

3301: end if;
3302: */
3303: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);
3304: END IF;
3305: hr_utility.TRACE(l_outputs(l_counter).NAME || ': ' || l_outputs(l_counter).VALUE);
3306: END LOOP;
3307: -- if the values of input values have changed within the formula
3308: -- then they are passed as items of table l_output
3309:

Line 3314: -- hr_utility.tracE_on(null,'ARCH');

3310: -- this loop checks if the name of l_output is same as that
3311: -- of l_inputs, if they are the same then it means that
3312: -- a new value has been returned from the formula
3313:
3314: -- hr_utility.tracE_on(null,'ARCH');
3315: hr_utility.set_location('Checking input values with that of values returned by ff', 30);
3316:
3317: FOR l_outer IN l_user_inputs.FIRST .. l_user_inputs.LAST
3318: LOOP

Line 3315: hr_utility.set_location('Checking input values with that of values returned by ff', 30);

3311: -- of l_inputs, if they are the same then it means that
3312: -- a new value has been returned from the formula
3313:
3314: -- hr_utility.tracE_on(null,'ARCH');
3315: hr_utility.set_location('Checking input values with that of values returned by ff', 30);
3316:
3317: FOR l_outer IN l_user_inputs.FIRST .. l_user_inputs.LAST
3318: LOOP
3319: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST

Line 3321: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);

3317: FOR l_outer IN l_user_inputs.FIRST .. l_user_inputs.LAST
3318: LOOP
3319: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST
3320: LOOP
3321: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);
3322: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);
3323: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);
3324: IF l_user_inputs(l_outer).NAME = l_outputs(l_inner).NAME
3325: THEN

Line 3322: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);

3318: LOOP
3319: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST
3320: LOOP
3321: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);
3322: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);
3323: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);
3324: IF l_user_inputs(l_outer).NAME = l_outputs(l_inner).NAME
3325: THEN
3326: l_user_inputs(l_outer).VALUE := l_outputs(l_inner).VALUE;

Line 3323: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);

3319: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST
3320: LOOP
3321: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);
3322: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);
3323: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);
3324: IF l_user_inputs(l_outer).NAME = l_outputs(l_inner).NAME
3325: THEN
3326: l_user_inputs(l_outer).VALUE := l_outputs(l_inner).VALUE;
3327: EXIT;

Line 3332: hr_utility.set_location('Checking Magtape Validation', 35);

3328: END IF;
3329: END LOOP;
3330: END LOOP;
3331:
3332: hr_utility.set_location('Checking Magtape Validation', 35);
3333: -- hr_utility.tracE_off;
3334: -- check_magtape_validation;
3335: FOR l_inner IN l_user_inputs.FIRST .. l_user_inputs.LAST
3336: LOOP

Line 3333: -- hr_utility.tracE_off;

3329: END LOOP;
3330: END LOOP;
3331:
3332: hr_utility.set_location('Checking Magtape Validation', 35);
3333: -- hr_utility.tracE_off;
3334: -- check_magtape_validation;
3335: FOR l_inner IN l_user_inputs.FIRST .. l_user_inputs.LAST
3336: LOOP
3337: IF pay_gb_eoy_magtape.validate_input(UPPER(l_user_inputs(l_inner).VALUE) ) > 0

Line 3364: hr_utility.set_location('Magtape Validation failure', 35);

3360: -- because of this
3361: THEN
3362: NULL;
3363: ELSE
3364: hr_utility.set_location('Magtape Validation failure', 35);
3365: l_error_assignment := TRUE;
3366: l_error := '1';
3367: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3368: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for '

Line 3378: hr_utility.set_location('Creating archive = '|| p_assactid, 20);

3374: l_action_context_id := p_assactid;
3375:
3376: IF l_error = '0'
3377: THEN
3378: hr_utility.set_location('Creating archive = '|| p_assactid, 20);
3379: hr_utility.set_location('p_assactid = '|| p_assactid, 20);
3380: l_col1_val := NULL; l_col2_val := NULL;
3381: l_col3_val := NULL; l_col4_val := NULL;
3382: l_col5_val := NULL; l_col6_val := NULL;

Line 3379: hr_utility.set_location('p_assactid = '|| p_assactid, 20);

3375:
3376: IF l_error = '0'
3377: THEN
3378: hr_utility.set_location('Creating archive = '|| p_assactid, 20);
3379: hr_utility.set_location('p_assactid = '|| p_assactid, 20);
3380: l_col1_val := NULL; l_col2_val := NULL;
3381: l_col3_val := NULL; l_col4_val := NULL;
3382: l_col5_val := NULL; l_col6_val := NULL;
3383: l_col7_val := NULL; l_col8_val := NULL;

Line 3404: hr_utility.trace(l_user_inputs(l_inner).NAME || ' : ' || l_user_inputs(l_inner).VALUE);

3400: -- can be max fo size 30 and we are comapring the END_USER_COLUMN_NAME
3401: -- filed with the input value name , we should trim it dowjn to 30
3402: -- so that then first 30 will now becoem the matching
3403: -- criteria.
3404: hr_utility.trace(l_user_inputs(l_inner).NAME || ' : ' || l_user_inputs(l_inner).VALUE);
3405: IF action_info.NAME = SUBSTR(l_user_inputs(l_inner).NAME, 1, 30)
3406: THEN
3407: IF action_info.application_column_name = 'ACTION_INFORMATION3'
3408: THEN

Line 3566: hr_utility.set_location('calling the create api', 20);

3562: EXIT;
3563: END IF;
3564: END LOOP;
3565: END LOOP;
3566: hr_utility.set_location('calling the create api', 20);
3567: pay_action_information_api.create_action_information(
3568: p_action_information_id => l_action_info_id,
3569: p_action_context_id => l_action_context_id,
3570: p_action_context_type => 'AAP',

Line 3606: hr_utility.trace('After calling Create api');

3602: p_action_information27 => l_col27_val,
3603: p_action_information28 => l_col28_val,
3604: p_action_information29 => l_col29_val,
3605: p_action_information30 => l_col30_val);
3606: hr_utility.trace('After calling Create api');
3607: ELSE -- error is non 0
3608: l_error_assignment := TRUE;
3609: END IF;
3610: ELSE -- formual id is null

Line 3615: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);

3611: l_error_assignment := TRUE;
3612: l_error := '1';
3613: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3614: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3615: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3616: END IF;
3617:
3618: hr_utility.trace('Looking at Next value!');
3619:

Line 3618: hr_utility.trace('Looking at Next value!');

3614: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3615: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3616: END IF;
3617:
3618: hr_utility.trace('Looking at Next value!');
3619:
3620: l_index := g_tab_ben_detail.NEXT(l_index);
3621:
3622: hr_utility.trace('l_index=' || l_index);

Line 3622: hr_utility.trace('l_index=' || l_index);

3618: hr_utility.trace('Looking at Next value!');
3619:
3620: l_index := g_tab_ben_detail.NEXT(l_index);
3621:
3622: hr_utility.trace('l_index=' || l_index);
3623:
3624: if g_tab_ben_detail.EXISTS(l_index) then
3625: hr_utility.trace('Next item exists');
3626: if g_tab_ben_detail(l_index).assignment_action_id <> p_assactid

Line 3625: hr_utility.trace('Next item exists');

3621:
3622: hr_utility.trace('l_index=' || l_index);
3623:
3624: if g_tab_ben_detail.EXISTS(l_index) then
3625: hr_utility.trace('Next item exists');
3626: if g_tab_ben_detail(l_index).assignment_action_id <> p_assactid
3627: then
3628: hr_utility.trace('Next item does not match');
3629: exit; -- come out of the loop

Line 3628: hr_utility.trace('Next item does not match');

3624: if g_tab_ben_detail.EXISTS(l_index) then
3625: hr_utility.trace('Next item exists');
3626: if g_tab_ben_detail(l_index).assignment_action_id <> p_assactid
3627: then
3628: hr_utility.trace('Next item does not match');
3629: exit; -- come out of the loop
3630: end if;
3631: else
3632: hr_utility.trace('Next item does not exist');

Line 3632: hr_utility.trace('Next item does not exist');

3628: hr_utility.trace('Next item does not match');
3629: exit; -- come out of the loop
3630: end if;
3631: else
3632: hr_utility.trace('Next item does not exist');
3633: hr_utility.trace('Coming out loop for all benefits');
3634: exit;
3635: end if;
3636: END LOOP; -- loop for all benefits

Line 3633: hr_utility.trace('Coming out loop for all benefits');

3629: exit; -- come out of the loop
3630: end if;
3631: else
3632: hr_utility.trace('Next item does not exist');
3633: hr_utility.trace('Coming out loop for all benefits');
3634: exit;
3635: end if;
3636: END LOOP; -- loop for all benefits
3637:

Line 3639: hr_utility.trace('Calling validate_values ');

3635: end if;
3636: END LOOP; -- loop for all benefits
3637:
3638: -- this validates the sum within the assignment
3639: hr_utility.trace('Calling validate_values ');
3640:
3641: validate_values;
3642: IF l_error_assignment
3643: THEN

Line 3644: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 70);

3640:
3641: validate_values;
3642: IF l_error_assignment
3643: THEN
3644: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 70);
3645: --log_message;
3646: -- Remove ALL GLOBALS
3647: l_ret := per_formula_functions.remove_globals;
3648: RAISE error_found;

Line 3651: hr_utility.trace('Inserting summed records ');

3647: l_ret := per_formula_functions.remove_globals;
3648: RAISE error_found;
3649: ELSE
3650: -- insert rows which are sums for all values in ffs
3651: hr_utility.trace('Inserting summed records ');
3652: insert_sum_records(p_assactid);
3653: -- Remove ALL GLOBALS
3654: l_ret := per_formula_functions.remove_globals;
3655: /* bug fix for 3485256

Line 3662: hr_utility.trace('Checing if multiple assign exists');

3658: l_index := l_first_index;
3659: l_tab_counter := 0;
3660: l_processed_assign_actions := c_proc_assign_actions_null;
3661: --check if multiple assignments exist
3662: hr_utility.trace('Checing if multiple assign exists');
3663: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3664: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3665: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3666:

Line 3663: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);

3659: l_tab_counter := 0;
3660: l_processed_assign_actions := c_proc_assign_actions_null;
3661: --check if multiple assignments exist
3662: hr_utility.trace('Checing if multiple assign exists');
3663: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3664: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3665: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3666:
3667: FOR assignment_list IN assignments_to_sum(

Line 3664: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);

3660: l_processed_assign_actions := c_proc_assign_actions_null;
3661: --check if multiple assignments exist
3662: hr_utility.trace('Checing if multiple assign exists');
3663: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3664: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3665: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3666:
3667: FOR assignment_list IN assignments_to_sum(
3668: g_tab_ben_detail(l_index).person_id,

Line 3665: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);

3661: --check if multiple assignments exist
3662: hr_utility.trace('Checing if multiple assign exists');
3663: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3664: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3665: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3666:
3667: FOR assignment_list IN assignments_to_sum(
3668: g_tab_ben_detail(l_index).person_id,
3669: l_pay_info_tab(l_payroll_id).l_employers_ref_no,

Line 3673: hr_utility.trace('multiple assign exists.....');

3669: l_pay_info_tab(l_payroll_id).l_employers_ref_no,
3670: l_pay_info_tab(l_payroll_id).l_employer_name)
3671: LOOP
3672: -- if yes sum them
3673: hr_utility.trace('multiple assign exists.....');
3674: hr_utility.trace('Assign act id ' || assignment_list.assignment_action_id );
3675: fetch_values_and_set_globals(assignment_list.assignment_action_id);
3676: l_tab_counter := l_tab_counter + 1;
3677: l_processed_assign_actions(l_tab_counter) := assignment_list.assignment_action_id;

Line 3674: hr_utility.trace('Assign act id ' || assignment_list.assignment_action_id );

3670: l_pay_info_tab(l_payroll_id).l_employer_name)
3671: LOOP
3672: -- if yes sum them
3673: hr_utility.trace('multiple assign exists.....');
3674: hr_utility.trace('Assign act id ' || assignment_list.assignment_action_id );
3675: fetch_values_and_set_globals(assignment_list.assignment_action_id);
3676: l_tab_counter := l_tab_counter + 1;
3677: l_processed_assign_actions(l_tab_counter) := assignment_list.assignment_action_id;
3678: END LOOP;

Line 3684: hr_utility.trace('Calling val values for multiple assign ..');

3680: IF l_tab_counter > 1
3681: THEN
3682: -- miltiple assignmenst exists validate and update all of them
3683: -- if validation fails then write log and raise error
3684: hr_utility.trace('Calling val values for multiple assign ..');
3685: validate_values;
3686: IF l_error = '1'
3687: THEN
3688: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);

Line 3688: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);

3684: hr_utility.trace('Calling val values for multiple assign ..');
3685: validate_values;
3686: IF l_error = '1'
3687: THEN
3688: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);
3689: -- Remove ALL GLOBALS
3690: l_ret := per_formula_functions.remove_globals;
3691: RAISE error_found;
3692: ELSE

Line 3694: hr_utility.trace('Calling Update values..');

3690: l_ret := per_formula_functions.remove_globals;
3691: RAISE error_found;
3692: ELSE
3693: l_tab_counter := l_processed_assign_actions.FIRST;
3694: hr_utility.trace('Calling Update values..');
3695: WHILE l_tab_counter <= l_processed_assign_actions.LAST
3696: LOOP
3697: hr_utility.trace('Update values ' || l_processed_assign_actions(l_tab_counter) );
3698: update_values(l_processed_assign_actions(l_tab_counter) );

Line 3697: hr_utility.trace('Update values ' || l_processed_assign_actions(l_tab_counter) );

3693: l_tab_counter := l_processed_assign_actions.FIRST;
3694: hr_utility.trace('Calling Update values..');
3695: WHILE l_tab_counter <= l_processed_assign_actions.LAST
3696: LOOP
3697: hr_utility.trace('Update values ' || l_processed_assign_actions(l_tab_counter) );
3698: update_values(l_processed_assign_actions(l_tab_counter) );
3699: l_tab_counter := l_processed_assign_actions.NEXT(l_tab_counter);
3700: END LOOP;
3701: END IF;

Line 3705: hr_utility.trace('nearing end');

3701: END IF;
3702: END IF;
3703: END IF;
3704: l_ret := per_formula_functions.remove_globals;
3705: hr_utility.trace('nearing end');
3706: EXCEPTION
3707: WHEN error_found
3708: THEN
3709: l_ret := per_formula_functions.remove_globals;

Line 3713: hr_utility.raise_error;

3709: l_ret := per_formula_functions.remove_globals;
3710: -- the error will be reported in Deinitialization proc
3711: -- write_error_to_log;
3712: g_set_warning := TRUE;
3713: hr_utility.raise_error;
3714: END archive_code;
3715:
3716: PROCEDURE write_log(employers_name VARCHAR2, person_name VARCHAR2, employee_num VARCHAR2, err_text VARCHAR2)
3717: IS

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

4361: write_footer('W',l_warn_count);
4362: END write_error_log;
4363:
4364: BEGIN
4365: hr_utility.set_location('Entering '|| l_proc, 10);
4366: hr_utility.trace('Checking incorrect NI ');
4367: FOR incorrect_ni_num IN csr_incorrect_ni_num
4368: LOOP
4369: FOR total_num IN csr_total_num(incorrect_ni_num.action_information7)

Line 4366: hr_utility.trace('Checking incorrect NI ');

4362: END write_error_log;
4363:
4364: BEGIN
4365: hr_utility.set_location('Entering '|| l_proc, 10);
4366: hr_utility.trace('Checking incorrect NI ');
4367: FOR incorrect_ni_num IN csr_incorrect_ni_num
4368: LOOP
4369: FOR total_num IN csr_total_num(incorrect_ni_num.action_information7)
4370: LOOP

Line 4387: hr_utility.trace('Checking duplicate NI ');

4383: -- dup_ni_num.person_name,
4384: -- dup_ni_num.employee_num,
4385: -- 'This employee has a duplicate NI number ' || dup_ni_num.ni_num);
4386: -- END LOOP;
4387: hr_utility.trace('Checking duplicate NI ');
4388: check_duplicate;
4389:
4390: write_summary(pactid);
4391:

Line 4392: hr_utility.trace('Summing expenses payments ');

4388: check_duplicate;
4389:
4390: write_summary(pactid);
4391:
4392: hr_utility.trace('Summing expenses payments ');
4393: FOR expenses_payment_chk IN csr_expenses_payment_chk
4394: LOOP
4395: fnd_file.put_line(fnd_file.output,
4396: 'For Expenses Payments benefit, the Trading Orgainization Indicator has different values for different employees. ');

Line 4402: --hr_utility.trace('Summing P11D value ');

4398: 'All employees in your Business Group must have the same Trading Orgainization Indicator. ');
4399: END LOOP;
4400:
4401: write_error_log(pactid);
4402: --hr_utility.trace('Summing P11D value ');
4403: --FOR p11db_value IN csr_p11db_value
4404: --LOOP
4405: -- write_log(p11db_value.employers_name,
4406: -- NULL, NULL,

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

4406: -- NULL, NULL,
4407: -- 'The figure for you to include in P11D(b) report is ' || ROUND(p11db_value.p11db_value, 2) );
4408: --END LOOP;
4409:
4410: hr_utility.set_location('Leaving '|| l_proc, 10);
4411: END;
4412:
4413: Function is_p11d_benefit_allowed
4414: (p_effective_date date,