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 764: -- hr_utility.trace_on(null,'ARCH');

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

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

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

Line 801: hr_utility.raise_error;

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

Line 819: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1522: -- hr_utility.trace_off;

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

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

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

Line 1839: hr_utility.TRACE('Entering update_flag_var procedure');

1835: and pai.action_information24 = 'Y'
1836: );
1837:
1838: BEGIN
1839: hr_utility.TRACE('Entering update_flag_var procedure');
1840: hr_utility.TRACE('Value of p_ass_act_id: '||p_ass_act_id);
1841: --l_updated := 'N'
1842: open c_get_per_det;
1843: fetch c_get_per_det into l_payroll_action_id, l_person_id;

Line 1840: hr_utility.TRACE('Value of p_ass_act_id: '||p_ass_act_id);

1836: );
1837:
1838: BEGIN
1839: hr_utility.TRACE('Entering update_flag_var procedure');
1840: hr_utility.TRACE('Value of p_ass_act_id: '||p_ass_act_id);
1841: --l_updated := 'N'
1842: open c_get_per_det;
1843: fetch c_get_per_det into l_payroll_action_id, l_person_id;
1844: hr_utility.TRACE('Value of l_payroll_action_id: '||l_payroll_action_id);

Line 1844: hr_utility.TRACE('Value of l_payroll_action_id: '||l_payroll_action_id);

1840: hr_utility.TRACE('Value of p_ass_act_id: '||p_ass_act_id);
1841: --l_updated := 'N'
1842: open c_get_per_det;
1843: fetch c_get_per_det into l_payroll_action_id, l_person_id;
1844: hr_utility.TRACE('Value of l_payroll_action_id: '||l_payroll_action_id);
1845: hr_utility.TRACE('Value of l_person_id: '||l_person_id);
1846: close c_get_per_det;
1847:
1848: open c_get_updated_status (l_person_id, l_payroll_action_id);

Line 1845: hr_utility.TRACE('Value of l_person_id: '||l_person_id);

1841: --l_updated := 'N'
1842: open c_get_per_det;
1843: fetch c_get_per_det into l_payroll_action_id, l_person_id;
1844: hr_utility.TRACE('Value of l_payroll_action_id: '||l_payroll_action_id);
1845: hr_utility.TRACE('Value of l_person_id: '||l_person_id);
1846: close c_get_per_det;
1847:
1848: open c_get_updated_status (l_person_id, l_payroll_action_id);
1849: fetch c_get_updated_status into l_updated;

Line 1850: hr_utility.TRACE('Value of l_updated: '||l_updated);

1846: close c_get_per_det;
1847:
1848: open c_get_updated_status (l_person_id, l_payroll_action_id);
1849: fetch c_get_updated_status into l_updated;
1850: hr_utility.TRACE('Value of l_updated: '||l_updated);
1851: close c_get_updated_status;
1852:
1853: if l_updated = 'Y' then
1854: hr_utility.TRACE('Inside if condition');

Line 1854: hr_utility.TRACE('Inside if condition');

1850: hr_utility.TRACE('Value of l_updated: '||l_updated);
1851: close c_get_updated_status;
1852:
1853: if l_updated = 'Y' then
1854: hr_utility.TRACE('Inside if condition');
1855: g_updated_flag := 'Y';
1856: end if;
1857: hr_utility.TRACE('Leaving update_flag_var procedure');
1858: END update_flag_var;

Line 1857: hr_utility.TRACE('Leaving update_flag_var procedure');

1853: if l_updated = 'Y' then
1854: hr_utility.TRACE('Inside if condition');
1855: g_updated_flag := 'Y';
1856: end if;
1857: hr_utility.TRACE('Leaving update_flag_var procedure');
1858: END update_flag_var;
1859:
1860: BEGIN
1861: /* The code below can be removed when do P11D for year 05/06 */

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

2883:
2884: BEGIN
2885:
2886: l_warn := 0;
2887: hr_utility.set_location('Entering '|| l_proc, 10);
2888: hr_utility.set_location('step '|| l_proc, 20);
2889: hr_utility.set_location('finding assignment id '|| l_proc, 20);
2890: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2891: p_payroll_action_id => g_pactid,

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

2884: BEGIN
2885:
2886: l_warn := 0;
2887: hr_utility.set_location('Entering '|| l_proc, 10);
2888: hr_utility.set_location('step '|| l_proc, 20);
2889: hr_utility.set_location('finding assignment id '|| l_proc, 20);
2890: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2891: p_payroll_action_id => g_pactid,
2892: p_token_name => 'EDI_VALIDATION',

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

2885:
2886: l_warn := 0;
2887: hr_utility.set_location('Entering '|| l_proc, 10);
2888: hr_utility.set_location('step '|| l_proc, 20);
2889: hr_utility.set_location('finding assignment id '|| l_proc, 20);
2890: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2891: p_payroll_action_id => g_pactid,
2892: p_token_name => 'EDI_VALIDATION',
2893: p_token_value => l_edi_validation);

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

2910: l_first_index_set := true;
2911: end if;
2912:
2913: g_ben_asg_count := g_ben_asg_count + 1;
2914: hr_utility.set_location('Inside the cursor val_elememt_entry_id ', 30);
2915: g_tab_ben_detail(g_ben_asg_count).assignment_action_id := p_assactid;
2916: g_tab_ben_detail(g_ben_asg_count).element_type_id := val_elememt_entry_id.element_type_id;
2917: g_tab_ben_detail(g_ben_asg_count).element_entry_id := val_elememt_entry_id.element_entry_id;
2918: g_tab_ben_detail(g_ben_asg_count).element_name := val_elememt_entry_id.element_name;

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

2930: l_assignment_id := g_tab_ben_detail(l_index).assignment_id;
2931: l_error_assignment := FALSE;
2932: l_error := '0';
2933: -- call generic procedure to retrieve and archive all data for EMPLOYEE DETAILS, ADDRESS DETAILS
2934: hr_utility.set_location('Calling pay_emp_action_arch', 20);
2935:
2936: open csr_get_term_date(l_assignment_id);
2937: fetch csr_get_term_date into l_actual_termination_date;
2938: close csr_get_term_date;

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

2948: if l_loan_threshold is null then
2949: l_loan_threshold := 5000;
2950: end if;
2951:
2952: hr_utility.trace('before get_asg_end_date');
2953: if (l_actual_termination_date is null) or
2954: (l_actual_termination_date > l_asg_max_end_date) then
2955: l_actual_termination_date := l_asg_max_end_date;
2956: end if;

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

2954: (l_actual_termination_date > l_asg_max_end_date) then
2955: l_actual_termination_date := l_asg_max_end_date;
2956: end if;
2957: --if l_actual_termination_date is null then
2958: -- hr_utility.trace('inside if');
2959: -- open csr_get_asg_end_date(l_assignment_id);
2960: -- fetch csr_get_asg_end_date into l_actual_termination_date;
2961: -- close csr_get_asg_end_date;
2962: --end if;

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

2959: -- open csr_get_asg_end_date(l_assignment_id);
2960: -- fetch csr_get_asg_end_date into l_actual_termination_date;
2961: -- close csr_get_asg_end_date;
2962: --end if;
2963: hr_utility.trace('after get_asg_end_date');
2964:
2965: pay_emp_action_arch.get_personal_information(
2966: p_payroll_action_id => g_pactid, -- archive payroll_action_id
2967: p_assactid => p_assactid, -- archive assignment_action_id

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

2984: ), -- prepayment effective_date
2985: p_tax_unit_id => NULL, -- only required for US
2986: p_time_period_id => NULL, -- payroll time_period_id
2987: p_ppp_source_action_id => NULL);
2988: hr_utility.set_location('Returned from pay_emp_action_arch', 30);
2989:
2990: /* Perform NI Validation */
2991: validate_ni(
2992: p_assactid => p_assactid,

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

2994: p_eff_date => least(nvl(l_actual_termination_date,
2995: fnd_date.canonical_to_date(g_param_benefit_end_date)),
2996: fnd_date.canonical_to_date(g_param_benefit_end_date)));
2997:
2998: hr_utility.set_location('Returned from NI Validation',30);
2999: open csr_assignment_det(l_assignment_id, g_param_tax_reference);
3000: fetch csr_assignment_det into
3001: l_assignment_name, l_payroll_id, l_director_flag, l_first_name,
3002: l_middle_name, l_last_name, l_assignment_number, l_person_id, l_ni_number, l_sex, l_date_of_birth;

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

3001: l_assignment_name, l_payroll_id, l_director_flag, l_first_name,
3002: l_middle_name, l_last_name, l_assignment_number, l_person_id, l_ni_number, l_sex, l_date_of_birth;
3003: close csr_assignment_det;
3004:
3005: hr_utility.set_location('finding payroll info: ', 25);
3006: hr_utility.set_location('payroll id: '|| l_payroll_id, 25);
3007: --set_payroll_info
3008: Begin
3009: IF l_pay_info_tab.EXISTS(l_payroll_id)

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

3002: l_middle_name, l_last_name, l_assignment_number, l_person_id, l_ni_number, l_sex, l_date_of_birth;
3003: close csr_assignment_det;
3004:
3005: hr_utility.set_location('finding payroll info: ', 25);
3006: hr_utility.set_location('payroll id: '|| l_payroll_id, 25);
3007: --set_payroll_info
3008: Begin
3009: IF l_pay_info_tab.EXISTS(l_payroll_id)
3010: THEN

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

3070: p_action_information7 => l_pay_info_tab(l_payroll_id).l_employer_name,
3071: p_action_information8 => l_pay_info_tab(l_payroll_id).l_employer_address);
3072: END IF;
3073:
3074: hr_utility.set_location('Archiving GB EMPLOYEE DETAILS', 50);
3075:
3076: IF pay_gb_eoy_magtape.validate_input(UPPER(l_first_name), 'P11D_EDI') > 0
3077: THEN
3078: l_error_assignment := TRUE;

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

3165:
3166: -- loop thru all the benefits
3167: -- resetting globals as earlier values should not be used!
3168: l_ret := per_formula_functions.remove_globals;
3169: -- hr_utility.trace_on(null,'ARCH');
3170:
3171: WHILE l_index <= g_tab_ben_detail.LAST
3172: LOOP
3173:

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

3170:
3171: WHILE l_index <= g_tab_ben_detail.LAST
3172: LOOP
3173:
3174: -- hr_utility.TRACE_on(null,'ERR');
3175: l_element_name := g_tab_ben_detail(l_index).element_name;
3176: hr_utility.set_location('Element Name '|| l_element_name, 20);
3177: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3178: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);

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

3172: LOOP
3173:
3174: -- hr_utility.TRACE_on(null,'ERR');
3175: l_element_name := g_tab_ben_detail(l_index).element_name;
3176: hr_utility.set_location('Element Name '|| l_element_name, 20);
3177: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3178: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);
3179: l_counter := 0;
3180:

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

3173:
3174: -- hr_utility.TRACE_on(null,'ERR');
3175: l_element_name := g_tab_ben_detail(l_index).element_name;
3176: hr_utility.set_location('Element Name '|| l_element_name, 20);
3177: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3178: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);
3179: l_counter := 0;
3180:
3181: -- Setting the array l_user_inputs with the input values from

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

3174: -- hr_utility.TRACE_on(null,'ERR');
3175: l_element_name := g_tab_ben_detail(l_index).element_name;
3176: hr_utility.set_location('Element Name '|| l_element_name, 20);
3177: hr_utility.set_location('Element Entry id :'|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id), 20);
3178: hr_utility.TRACE('Inside assignment id '|| g_tab_ben_detail(l_index).assignment_id);
3179: l_counter := 0;
3180:
3181: -- Setting the array l_user_inputs with the input values from
3182: -- element entry value

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

3179: l_counter := 0;
3180:
3181: -- Setting the array l_user_inputs with the input values from
3182: -- element entry value
3183: hr_utility.set_location('Setting the input values ', 30);
3184:
3185:
3186: FOR entry_values IN csr_element_entry_values(
3187: g_tab_ben_detail(l_index).element_entry_id,

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

3187: g_tab_ben_detail(l_index).element_entry_id,
3188: g_tab_ben_detail(l_index).element_type_id,
3189: g_tab_ben_detail(l_index).effective_start_date)
3190: LOOP
3191: hr_utility.trace('entry_values.NAME ' || entry_values.NAME);
3192: l_counter := l_counter + 1;
3193: l_user_inputs(l_counter).NAME := TRIM(entry_values.NAME);
3194: l_user_inputs(l_counter).VALUE := TRIM(entry_values.screen_entry_value);
3195:

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

3233: pay_core_utils.push_token('VAl2', '05-APR-' ||g_param_rep_run);
3234: End if;
3235: -- Setting the array l_user_inputs with the input values from
3236: -- element entry flexfield
3237: hr_utility.trace(' classification_name ' ||g_tab_ben_detail(l_index).classification_name);
3238: hr_utility.trace('l_counter b4 entry flex values ' || l_counter);
3239:
3240: FOR entry_flex_values IN csr_element_entry_flex_values(g_tab_ben_detail(l_index).classification_name)
3241: LOOP

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

3234: End if;
3235: -- Setting the array l_user_inputs with the input values from
3236: -- element entry flexfield
3237: hr_utility.trace(' classification_name ' ||g_tab_ben_detail(l_index).classification_name);
3238: hr_utility.trace('l_counter b4 entry flex values ' || l_counter);
3239:
3240: FOR entry_flex_values IN csr_element_entry_flex_values(g_tab_ben_detail(l_index).classification_name)
3241: LOOP
3242: l_counter := l_counter + 1;

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

3247: l_sql_stmt := l_sql_stmt || ' AND EFFECTIVE_START_DATE = :effec_st_date ';
3248: EXECUTE IMMEDIATE l_sql_stmt
3249: INTO l_user_inputs(l_counter).VALUE
3250: USING IN g_tab_ben_detail(l_index).element_entry_id, g_tab_ben_detail(l_index).effective_start_date;
3251: hr_utility.trace(' l_counter ' || l_counter);
3252: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3253: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3254: END LOOP;
3255:

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

3248: EXECUTE IMMEDIATE l_sql_stmt
3249: INTO l_user_inputs(l_counter).VALUE
3250: USING IN g_tab_ben_detail(l_index).element_entry_id, g_tab_ben_detail(l_index).effective_start_date;
3251: hr_utility.trace(' l_counter ' || l_counter);
3252: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3253: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3254: END LOOP;
3255:
3256: -- hr_utility.trace_on(null,'NONIV');

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

3249: INTO l_user_inputs(l_counter).VALUE
3250: USING IN g_tab_ben_detail(l_index).element_entry_id, g_tab_ben_detail(l_index).effective_start_date;
3251: hr_utility.trace(' l_counter ' || l_counter);
3252: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3253: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3254: END LOOP;
3255:
3256: -- hr_utility.trace_on(null,'NONIV');
3257: hr_utility.trace(' Out of loop');

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

3252: hr_utility.trace(' Name --' ||l_user_inputs(l_counter).name || '--');
3253: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3254: END LOOP;
3255:
3256: -- hr_utility.trace_on(null,'NONIV');
3257: hr_utility.trace(' Out of loop');
3258: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);
3259:
3260: For extra_archive_items in csr_non_iv_action_info_items (

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

3253: hr_utility.trace(' Value ' ||l_user_inputs(l_counter).VALUE);
3254: END LOOP;
3255:
3256: -- hr_utility.trace_on(null,'NONIV');
3257: hr_utility.trace(' Out of loop');
3258: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);
3259:
3260: For extra_archive_items in csr_non_iv_action_info_items (
3261: g_tab_ben_detail(l_index).element_entry_id,

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

3254: END LOOP;
3255:
3256: -- hr_utility.trace_on(null,'NONIV');
3257: hr_utility.trace(' Out of loop');
3258: hr_utility.trace('l_counter at b4 extra arch items ' || l_counter);
3259:
3260: For extra_archive_items in csr_non_iv_action_info_items (
3261: g_tab_ben_detail(l_index).element_entry_id,
3262: g_tab_ben_detail(l_index).element_type_id,

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

3267: loop
3268: l_counter := l_counter + 1;
3269: l_user_inputs(l_counter).NAME := TRIM(extra_archive_items.NAME);
3270: l_user_inputs(l_counter).VALUE := null;
3271: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);
3272: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);
3273: end loop;
3274:
3275: hr_utility.trace('After Using pl/sql table');

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

3268: l_counter := l_counter + 1;
3269: l_user_inputs(l_counter).NAME := TRIM(extra_archive_items.NAME);
3270: l_user_inputs(l_counter).VALUE := null;
3271: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);
3272: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);
3273: end loop;
3274:
3275: hr_utility.trace('After Using pl/sql table');
3276:

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

3271: hr_utility.trace('extra arch NAME ' || extra_archive_items.NAME);
3272: hr_utility.trace('user NAME ' ||l_user_inputs(l_counter).NAME);
3273: end loop;
3274:
3275: hr_utility.trace('After Using pl/sql table');
3276:
3277: hr_utility.trace('l_counter after extra arch items ' || l_counter);
3278: -- hr_utility.trace_off;
3279: -- Setting the Business group id as this is needed for Car Validation!

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

3273: end loop;
3274:
3275: hr_utility.trace('After Using pl/sql table');
3276:
3277: hr_utility.trace('l_counter after extra arch items ' || l_counter);
3278: -- hr_utility.trace_off;
3279: -- Setting the Business group id as this is needed for Car Validation!
3280: l_counter := l_counter + 1;
3281: l_user_inputs(l_counter).NAME := 'BUSINESS_GROUP_ID';

Line 3278: -- hr_utility.trace_off;

3274:
3275: hr_utility.trace('After Using pl/sql table');
3276:
3277: hr_utility.trace('l_counter after extra arch items ' || l_counter);
3278: -- hr_utility.trace_off;
3279: -- Setting the Business group id as this is needed for Car Validation!
3280: l_counter := l_counter + 1;
3281: l_user_inputs(l_counter).NAME := 'BUSINESS_GROUP_ID';
3282: l_user_inputs(l_counter).VALUE := TO_CHAR(g_param_business_group_id);

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

3285: l_formula_id := find_exec_formula(
3286: l_element_name,
3287: fnd_date.canonical_to_date(l_benefit_end_date),
3288: l_formula_effective_start_date);
3289: hr_utility.set_location('Formula id '|| l_formula_id, 25);
3290:
3291: IF l_formula_id IS NOT NULL
3292: THEN
3293: hr_utility.set_location('Initializing the formula ', 40);

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

3289: hr_utility.set_location('Formula id '|| l_formula_id, 25);
3290:
3291: IF l_formula_id IS NOT NULL
3292: THEN
3293: hr_utility.set_location('Initializing the formula ', 40);
3294: Begin
3295: ff_exec.init_formula(l_formula_id, l_formula_effective_start_date, l_inputs, l_outputs);
3296: Exception
3297: when OTHERS then

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

3298: l_error_assignment := TRUE;
3299: l_error := '1';
3300: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3301: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3302: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3303: -- Remove ALL GLOBALS
3304: l_ret := per_formula_functions.remove_globals;
3305: RAISE error_found;
3306: End;

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

3313: LOOP
3314: IF l_inputs(l_outer).NAME = l_user_inputs(l_inner).NAME
3315: AND (l_user_inputs(l_inner).NAME IS NOT NULL OR l_user_inputs(l_inner).NAME <> '')
3316: THEN
3317: hr_utility.TRACE('l_outer ' || l_outer);
3318: hr_utility.TRACE('l_inner ' || l_inner);
3319: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3320: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3321: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);

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

3314: IF l_inputs(l_outer).NAME = l_user_inputs(l_inner).NAME
3315: AND (l_user_inputs(l_inner).NAME IS NOT NULL OR l_user_inputs(l_inner).NAME <> '')
3316: THEN
3317: hr_utility.TRACE('l_outer ' || l_outer);
3318: hr_utility.TRACE('l_inner ' || l_inner);
3319: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3320: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3321: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3322: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;

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

3315: AND (l_user_inputs(l_inner).NAME IS NOT NULL OR l_user_inputs(l_inner).NAME <> '')
3316: THEN
3317: hr_utility.TRACE('l_outer ' || l_outer);
3318: hr_utility.TRACE('l_inner ' || l_inner);
3319: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3320: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3321: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3322: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3323: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);

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

3316: THEN
3317: hr_utility.TRACE('l_outer ' || l_outer);
3318: hr_utility.TRACE('l_inner ' || l_inner);
3319: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3320: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3321: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3322: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3323: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);
3324: EXIT;

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

3317: hr_utility.TRACE('l_outer ' || l_outer);
3318: hr_utility.TRACE('l_inner ' || l_inner);
3319: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3320: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3321: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3322: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3323: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);
3324: EXIT;
3325: END IF;

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

3319: hr_utility.TRACE(' l_inputs(l_outer).NAME --' || l_inputs(l_outer).NAME || '--');
3320: hr_utility.TRACE(' l_user_inputs(l_inner).NAME -' || l_user_inputs(l_inner).NAME || '-');
3321: hr_utility.TRACE(' l_user_inputs(l_inner).VALUE ' || l_user_inputs(l_inner).VALUE);
3322: l_inputs(l_outer).VALUE := l_user_inputs(l_inner).VALUE;
3323: hr_utility.TRACE(' Name : '|| l_inputs(l_outer).NAME || ' Value: ' || l_inputs(l_outer).VALUE);
3324: EXIT;
3325: END IF;
3326: if l_inputs(l_outer).NAME = 'EDI_VALIDATION' then
3327: l_inputs(l_outer).VALUE := l_edi_validation;

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

3328: end if;
3329: END LOOP;
3330: END LOOP;
3331: END IF; -- end if for setting user inputs
3332: -- hr_utility.trace_on(null,'CAR');
3333: hr_utility.set_location('Running the formula ', 20);
3334: ff_exec.run_formula(l_inputs, l_outputs);
3335:
3336: -- Tapping the output from the formula using the l_outputs array

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

3329: END LOOP;
3330: END LOOP;
3331: END IF; -- end if for setting user inputs
3332: -- hr_utility.trace_on(null,'CAR');
3333: hr_utility.set_location('Running the formula ', 20);
3334: ff_exec.run_formula(l_inputs, l_outputs);
3335:
3336: -- Tapping the output from the formula using the l_outputs array
3337: hr_utility.set_location('After Running the formula ', 20);

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

3333: hr_utility.set_location('Running the formula ', 20);
3334: ff_exec.run_formula(l_inputs, l_outputs);
3335:
3336: -- Tapping the output from the formula using the l_outputs array
3337: hr_utility.set_location('After Running the formula ', 20);
3338: FOR l_counter IN l_outputs.FIRST .. l_outputs.LAST
3339: LOOP
3340: IF l_outputs(l_counter).NAME = 'L_ERROR' AND l_outputs(l_counter).VALUE = '1'
3341: THEN

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

3338: FOR l_counter IN l_outputs.FIRST .. l_outputs.LAST
3339: LOOP
3340: IF l_outputs(l_counter).NAME = 'L_ERROR' AND l_outputs(l_counter).VALUE = '1'
3341: THEN
3342: hr_utility.set_location('Error in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),65);
3343: l_error := '1';
3344: ELSIF l_outputs(l_counter).NAME = 'L_WARN' AND l_outputs(l_counter).VALUE = '1'
3345: THEN
3346: hr_utility.set_location('Warning in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),66);

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

3342: hr_utility.set_location('Error in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),65);
3343: l_error := '1';
3344: ELSIF l_outputs(l_counter).NAME = 'L_WARN' AND l_outputs(l_counter).VALUE = '1'
3345: THEN
3346: hr_utility.set_location('Warning in Element Entry id value '|| TO_CHAR(g_tab_ben_detail(l_index).element_entry_id),66);
3347: l_warn := '1';
3348: ELSIF (INSTR(UPPER(l_outputs(l_counter).NAME), 'MSG') > 0
3349: OR INSTR(UPPER(l_outputs(l_counter).NAME), 'MESSAGE') > 0
3350: OR (INSTR(UPPER(l_outputs(l_counter).NAME), 'ERR') > 0

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

3365: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3366: pay_core_utils.push_token('TEXT', l_element_name ||': ' || SUBSTR(l_outputs(l_counter).VALUE, 2, 100) );
3367: end if;
3368: */
3369: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);
3370: END IF;
3371: hr_utility.TRACE(l_outputs(l_counter).NAME || ': ' || l_outputs(l_counter).VALUE);
3372: END LOOP;
3373: -- if the values of input values have changed within the formula

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

3367: end if;
3368: */
3369: hr_utility.TRACE('Error'|| l_outputs(l_counter).VALUE);
3370: END IF;
3371: hr_utility.TRACE(l_outputs(l_counter).NAME || ': ' || l_outputs(l_counter).VALUE);
3372: END LOOP;
3373: -- if the values of input values have changed within the formula
3374: -- then they are passed as items of table l_output
3375:

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

3376: -- this loop checks if the name of l_output is same as that
3377: -- of l_inputs, if they are the same then it means that
3378: -- a new value has been returned from the formula
3379:
3380: -- hr_utility.tracE_on(null,'ARCH');
3381: hr_utility.set_location('Checking input values with that of values returned by ff', 30);
3382:
3383: FOR l_outer IN l_user_inputs.FIRST .. l_user_inputs.LAST
3384: LOOP

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

3377: -- of l_inputs, if they are the same then it means that
3378: -- a new value has been returned from the formula
3379:
3380: -- hr_utility.tracE_on(null,'ARCH');
3381: hr_utility.set_location('Checking input values with that of values returned by ff', 30);
3382:
3383: FOR l_outer IN l_user_inputs.FIRST .. l_user_inputs.LAST
3384: LOOP
3385: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST

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

3383: FOR l_outer IN l_user_inputs.FIRST .. l_user_inputs.LAST
3384: LOOP
3385: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST
3386: LOOP
3387: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);
3388: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);
3389: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);
3390: IF l_user_inputs(l_outer).NAME = l_outputs(l_inner).NAME
3391: THEN

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

3384: LOOP
3385: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST
3386: LOOP
3387: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);
3388: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);
3389: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);
3390: IF l_user_inputs(l_outer).NAME = l_outputs(l_inner).NAME
3391: THEN
3392: l_user_inputs(l_outer).VALUE := l_outputs(l_inner).VALUE;

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

3385: FOR l_inner IN l_outputs.FIRST .. l_outputs.LAST
3386: LOOP
3387: -- hr_utility.trace('l_outputs(l_inner).NAME ' || l_outputs(l_inner).NAME);
3388: -- hr_utility.trace('l_outputs(l_inner).VALUE ' || l_outputs(l_inner).VALUE);
3389: -- hr_utility.trace('l_user_inputs(l_outer).NAME ' ||l_user_inputs(l_outer).NAME);
3390: IF l_user_inputs(l_outer).NAME = l_outputs(l_inner).NAME
3391: THEN
3392: l_user_inputs(l_outer).VALUE := l_outputs(l_inner).VALUE;
3393: EXIT;

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

3394: END IF;
3395: END LOOP;
3396: END LOOP;
3397:
3398: hr_utility.set_location('Checking Magtape Validation', 35);
3399: -- hr_utility.tracE_off;
3400: -- check_magtape_validation;
3401: FOR l_inner IN l_user_inputs.FIRST .. l_user_inputs.LAST
3402: LOOP

Line 3399: -- hr_utility.tracE_off;

3395: END LOOP;
3396: END LOOP;
3397:
3398: hr_utility.set_location('Checking Magtape Validation', 35);
3399: -- hr_utility.tracE_off;
3400: -- check_magtape_validation;
3401: FOR l_inner IN l_user_inputs.FIRST .. l_user_inputs.LAST
3402: LOOP
3403: IF pay_gb_eoy_magtape.validate_input(UPPER(l_user_inputs(l_inner).VALUE) ) > 0

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

3426: -- because of this
3427: THEN
3428: NULL;
3429: ELSE
3430: hr_utility.set_location('Magtape Validation failure', 35);
3431: l_error_assignment := TRUE;
3432: l_error := '1';
3433: pay_core_utils.push_message(800, 'PER_GB_P11D_78058_ASG_ERR_MSG', 'F');
3434: pay_core_utils.push_token('TEXT', ': Magtape Character Validation has failed for '

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

3440: l_action_context_id := p_assactid;
3441:
3442: IF l_error = '0'
3443: THEN
3444: hr_utility.set_location('Creating archive = '|| p_assactid, 20);
3445: hr_utility.set_location('p_assactid = '|| p_assactid, 20);
3446: l_col1_val := NULL; l_col2_val := NULL;
3447: l_col3_val := NULL; l_col4_val := NULL;
3448: l_col5_val := NULL; l_col6_val := NULL;

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

3441:
3442: IF l_error = '0'
3443: THEN
3444: hr_utility.set_location('Creating archive = '|| p_assactid, 20);
3445: hr_utility.set_location('p_assactid = '|| p_assactid, 20);
3446: l_col1_val := NULL; l_col2_val := NULL;
3447: l_col3_val := NULL; l_col4_val := NULL;
3448: l_col5_val := NULL; l_col6_val := NULL;
3449: l_col7_val := NULL; l_col8_val := NULL;

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

3466: -- can be max fo size 30 and we are comapring the END_USER_COLUMN_NAME
3467: -- filed with the input value name , we should trim it dowjn to 30
3468: -- so that then first 30 will now becoem the matching
3469: -- criteria.
3470: hr_utility.trace(l_user_inputs(l_inner).NAME || ' : ' || l_user_inputs(l_inner).VALUE);
3471: IF action_info.NAME = SUBSTR(l_user_inputs(l_inner).NAME, 1, 30)
3472: THEN
3473: IF action_info.application_column_name = 'ACTION_INFORMATION3'
3474: THEN

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

3628: EXIT;
3629: END IF;
3630: END LOOP;
3631: END LOOP;
3632: hr_utility.set_location('calling the create api', 20);
3633: pay_action_information_api.create_action_information(
3634: p_action_information_id => l_action_info_id,
3635: p_action_context_id => l_action_context_id,
3636: p_action_context_type => 'AAP',

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

3668: p_action_information27 => l_col27_val,
3669: p_action_information28 => l_col28_val,
3670: p_action_information29 => l_col29_val,
3671: p_action_information30 => l_col30_val);
3672: hr_utility.trace('After calling Create api');
3673: ELSE -- error is non 0
3674: l_error_assignment := TRUE;
3675: END IF;
3676: ELSE -- formual id is null

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

3677: l_error_assignment := TRUE;
3678: l_error := '1';
3679: pay_core_utils.push_message(800, 'HR_78055_GB_P11D_FORMULA_ERR', 'F');
3680: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3681: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3682: END IF;
3683:
3684: hr_utility.trace('Looking at Next value!');
3685:

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

3680: pay_core_utils.push_token('ELEMENT_NAME', l_element_name);
3681: hr_utility.set_location('Nothing to execute ! '|| ' :' || l_proc, 70);
3682: END IF;
3683:
3684: hr_utility.trace('Looking at Next value!');
3685:
3686: l_index := g_tab_ben_detail.NEXT(l_index);
3687:
3688: hr_utility.trace('l_index=' || l_index);

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

3684: hr_utility.trace('Looking at Next value!');
3685:
3686: l_index := g_tab_ben_detail.NEXT(l_index);
3687:
3688: hr_utility.trace('l_index=' || l_index);
3689:
3690: if g_tab_ben_detail.EXISTS(l_index) then
3691: hr_utility.trace('Next item exists');
3692: if g_tab_ben_detail(l_index).assignment_action_id <> p_assactid

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

3687:
3688: hr_utility.trace('l_index=' || l_index);
3689:
3690: if g_tab_ben_detail.EXISTS(l_index) then
3691: hr_utility.trace('Next item exists');
3692: if g_tab_ben_detail(l_index).assignment_action_id <> p_assactid
3693: then
3694: hr_utility.trace('Next item does not match');
3695: exit; -- come out of the loop

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

3690: if g_tab_ben_detail.EXISTS(l_index) then
3691: hr_utility.trace('Next item exists');
3692: if g_tab_ben_detail(l_index).assignment_action_id <> p_assactid
3693: then
3694: hr_utility.trace('Next item does not match');
3695: exit; -- come out of the loop
3696: end if;
3697: else
3698: hr_utility.trace('Next item does not exist');

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

3694: hr_utility.trace('Next item does not match');
3695: exit; -- come out of the loop
3696: end if;
3697: else
3698: hr_utility.trace('Next item does not exist');
3699: hr_utility.trace('Coming out loop for all benefits');
3700: exit;
3701: end if;
3702: END LOOP; -- loop for all benefits

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

3695: exit; -- come out of the loop
3696: end if;
3697: else
3698: hr_utility.trace('Next item does not exist');
3699: hr_utility.trace('Coming out loop for all benefits');
3700: exit;
3701: end if;
3702: END LOOP; -- loop for all benefits
3703:

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

3701: end if;
3702: END LOOP; -- loop for all benefits
3703:
3704: -- this validates the sum within the assignment
3705: hr_utility.trace('Calling validate_values ');
3706:
3707: validate_values;
3708: IF l_error_assignment
3709: THEN

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

3706:
3707: validate_values;
3708: IF l_error_assignment
3709: THEN
3710: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 70);
3711: --log_message;
3712: -- Remove ALL GLOBALS
3713: l_ret := per_formula_functions.remove_globals;
3714: RAISE error_found;

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

3713: l_ret := per_formula_functions.remove_globals;
3714: RAISE error_found;
3715: ELSE
3716: -- insert rows which are sums for all values in ffs
3717: hr_utility.trace('Inserting summed records ');
3718: insert_sum_records(p_assactid);
3719: -- Remove ALL GLOBALS
3720: l_ret := per_formula_functions.remove_globals;
3721: /* bug fix for 3485256

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

3724: l_index := l_first_index;
3725: l_tab_counter := 0;
3726: l_processed_assign_actions := c_proc_assign_actions_null;
3727: --check if multiple assignments exist
3728: hr_utility.trace('Checing if multiple assign exists');
3729: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3730: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3731: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3732:

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

3725: l_tab_counter := 0;
3726: l_processed_assign_actions := c_proc_assign_actions_null;
3727: --check if multiple assignments exist
3728: hr_utility.trace('Checing if multiple assign exists');
3729: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3730: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3731: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3732:
3733: FOR assignment_list IN assignments_to_sum(

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

3726: l_processed_assign_actions := c_proc_assign_actions_null;
3727: --check if multiple assignments exist
3728: hr_utility.trace('Checing if multiple assign exists');
3729: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3730: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3731: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3732:
3733: FOR assignment_list IN assignments_to_sum(
3734: g_tab_ben_detail(l_index).person_id,

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

3727: --check if multiple assignments exist
3728: hr_utility.trace('Checing if multiple assign exists');
3729: hr_utility.trace('person_id ' || g_tab_ben_detail(l_index).person_id);
3730: hr_utility.trace('l_employers_ref_no ' || l_pay_info_tab(l_payroll_id).l_employers_ref_no);
3731: hr_utility.trace('l_employer_name ' || l_pay_info_tab(l_payroll_id).l_employer_name);
3732:
3733: FOR assignment_list IN assignments_to_sum(
3734: g_tab_ben_detail(l_index).person_id,
3735: l_pay_info_tab(l_payroll_id).l_employers_ref_no,

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

3735: l_pay_info_tab(l_payroll_id).l_employers_ref_no,
3736: l_pay_info_tab(l_payroll_id).l_employer_name)
3737: LOOP
3738: -- if yes sum them
3739: hr_utility.trace('multiple assign exists.....');
3740: hr_utility.trace('Assign act id ' || assignment_list.assignment_action_id );
3741: fetch_values_and_set_globals(assignment_list.assignment_action_id);
3742: l_tab_counter := l_tab_counter + 1;
3743: l_processed_assign_actions(l_tab_counter) := assignment_list.assignment_action_id;

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

3736: l_pay_info_tab(l_payroll_id).l_employer_name)
3737: LOOP
3738: -- if yes sum them
3739: hr_utility.trace('multiple assign exists.....');
3740: hr_utility.trace('Assign act id ' || assignment_list.assignment_action_id );
3741: fetch_values_and_set_globals(assignment_list.assignment_action_id);
3742: l_tab_counter := l_tab_counter + 1;
3743: l_processed_assign_actions(l_tab_counter) := assignment_list.assignment_action_id;
3744: END LOOP;

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

3746: IF l_tab_counter > 1
3747: THEN
3748: -- miltiple assignmenst exists validate and update all of them
3749: -- if validation fails then write log and raise error
3750: hr_utility.trace('Calling val values for multiple assign ..');
3751: validate_values;
3752: IF l_error = '1'
3753: THEN
3754: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);

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

3750: hr_utility.trace('Calling val values for multiple assign ..');
3751: validate_values;
3752: IF l_error = '1'
3753: THEN
3754: hr_utility.set_location('Failing Assignment '|| ' :' || l_proc, 90);
3755: -- Remove ALL GLOBALS
3756: l_ret := per_formula_functions.remove_globals;
3757: RAISE error_found;
3758: ELSE

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

3756: l_ret := per_formula_functions.remove_globals;
3757: RAISE error_found;
3758: ELSE
3759: l_tab_counter := l_processed_assign_actions.FIRST;
3760: hr_utility.trace('Calling Update values..');
3761: WHILE l_tab_counter <= l_processed_assign_actions.LAST
3762: LOOP
3763: hr_utility.trace('Update values ' || l_processed_assign_actions(l_tab_counter) );
3764: update_values(l_processed_assign_actions(l_tab_counter) );

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

3759: l_tab_counter := l_processed_assign_actions.FIRST;
3760: hr_utility.trace('Calling Update values..');
3761: WHILE l_tab_counter <= l_processed_assign_actions.LAST
3762: LOOP
3763: hr_utility.trace('Update values ' || l_processed_assign_actions(l_tab_counter) );
3764: update_values(l_processed_assign_actions(l_tab_counter) );
3765: l_tab_counter := l_processed_assign_actions.NEXT(l_tab_counter);
3766: END LOOP;
3767: END IF;

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

3767: END IF;
3768: END IF;
3769: END IF;
3770: l_ret := per_formula_functions.remove_globals;
3771: hr_utility.trace('nearing end');
3772: EXCEPTION
3773: WHEN error_found
3774: THEN
3775: l_ret := per_formula_functions.remove_globals;

Line 3779: hr_utility.raise_error;

3775: l_ret := per_formula_functions.remove_globals;
3776: -- the error will be reported in Deinitialization proc
3777: -- write_error_to_log;
3778: g_set_warning := TRUE;
3779: hr_utility.raise_error;
3780: END archive_code;
3781:
3782: PROCEDURE write_log(employers_name VARCHAR2, person_name VARCHAR2, employee_num VARCHAR2, err_text VARCHAR2)
3783: IS

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

4481: write_footer('W',l_warn_count);
4482: END write_error_log;
4483:
4484: BEGIN
4485: hr_utility.set_location('Entering '|| l_proc, 10);
4486: hr_utility.trace('Checking incorrect NI ');
4487: FOR incorrect_ni_num IN csr_incorrect_ni_num
4488: LOOP
4489: FOR total_num IN csr_total_num(incorrect_ni_num.action_information7)

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

4482: END write_error_log;
4483:
4484: BEGIN
4485: hr_utility.set_location('Entering '|| l_proc, 10);
4486: hr_utility.trace('Checking incorrect NI ');
4487: FOR incorrect_ni_num IN csr_incorrect_ni_num
4488: LOOP
4489: FOR total_num IN csr_total_num(incorrect_ni_num.action_information7)
4490: LOOP

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

4503: -- dup_ni_num.person_name,
4504: -- dup_ni_num.employee_num,
4505: -- 'This employee has a duplicate NI number ' || dup_ni_num.ni_num);
4506: -- END LOOP;
4507: hr_utility.trace('Checking duplicate NI ');
4508: check_duplicate;
4509:
4510: write_summary(pactid);
4511:

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

4508: check_duplicate;
4509:
4510: write_summary(pactid);
4511:
4512: hr_utility.trace('Summing expenses payments ');
4513: FOR expenses_payment_chk IN csr_expenses_payment_chk
4514: LOOP
4515: fnd_file.put_line(fnd_file.output,
4516: 'For Expenses Payments benefit, the Trading Orgainization Indicator has different values for different employees. ');

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

4518: 'All employees in your Business Group must have the same Trading Orgainization Indicator. ');
4519: END LOOP;
4520:
4521: write_error_log(pactid);
4522: --hr_utility.trace('Summing P11D value ');
4523: --FOR p11db_value IN csr_p11db_value
4524: --LOOP
4525: -- write_log(p11db_value.employers_name,
4526: -- NULL, NULL,

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

4526: -- NULL, NULL,
4527: -- 'The figure for you to include in P11D(b) report is ' || ROUND(p11db_value.p11db_value, 2) );
4528: --END LOOP;
4529:
4530: hr_utility.set_location('Leaving '|| l_proc, 10);
4531: END;
4532:
4533: Function is_p11d_benefit_allowed
4534: (p_effective_date date,