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

Line 52: hr_utility.set_location('Entered canonical_to_number',20);

48: return varchar2 is
49: decimal_char varchar2(1);
50: dummy varchar2(20);
51: begin
52: hr_utility.set_location('Entered canonical_to_number',20);
53: decimal_char := substr(ltrim(to_char(.3,'0D0')),2,1);
54: hr_utility.set_location('Done with decimal_char',20);
55: hr_utility.set_location('decimal_char:'||decimal_char,20);
56: return rtrim(ltrim(to_char(translate(canonical, '.', decimal_char),'999999999999999990D99')));

Line 54: hr_utility.set_location('Done with decimal_char',20);

50: dummy varchar2(20);
51: begin
52: hr_utility.set_location('Entered canonical_to_number',20);
53: decimal_char := substr(ltrim(to_char(.3,'0D0')),2,1);
54: hr_utility.set_location('Done with decimal_char',20);
55: hr_utility.set_location('decimal_char:'||decimal_char,20);
56: return rtrim(ltrim(to_char(translate(canonical, '.', decimal_char),'999999999999999990D99')));
57: --return canonical;
58: end formatted_canonical;

Line 55: hr_utility.set_location('decimal_char:'||decimal_char,20);

51: begin
52: hr_utility.set_location('Entered canonical_to_number',20);
53: decimal_char := substr(ltrim(to_char(.3,'0D0')),2,1);
54: hr_utility.set_location('Done with decimal_char',20);
55: hr_utility.set_location('decimal_char:'||decimal_char,20);
56: return rtrim(ltrim(to_char(translate(canonical, '.', decimal_char),'999999999999999990D99')));
57: --return canonical;
58: end formatted_canonical;
59:

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

108: l_proc varchar2(50) := g_package || 'get_parameters';
109:
110: begin
111:
112: hr_utility.set_location('Entering ' || l_proc, 10);
113:
114: hr_utility.set_location('Step ' || l_proc, 20);
115: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
116:

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

110: begin
111:
112: hr_utility.set_location('Entering ' || l_proc, 10);
113:
114: hr_utility.set_location('Step ' || l_proc, 20);
115: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
116:
117: open csr_parameter_info
118: (

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

111:
112: hr_utility.set_location('Entering ' || l_proc, 10);
113:
114: hr_utility.set_location('Step ' || l_proc, 20);
115: hr_utility.set_location('p_token_name = ' || p_token_name, 20);
116:
117: open csr_parameter_info
118: (
119: p_payroll_action_id,

Line 129: hr_utility.set_location('p_token_value = ' || p_token_value, 20);

125: if p_token_name = 'BG_ID' then
126: p_token_value := l_business_group_id;
127: end if ;
128:
129: hr_utility.set_location('p_token_value = ' || p_token_value, 20);
130: hr_utility.set_location('Leaving ' || l_proc, 30);
131: --
132: exception
133: when others then

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

126: p_token_value := l_business_group_id;
127: end if ;
128:
129: hr_utility.set_location('p_token_value = ' || p_token_value, 20);
130: hr_utility.set_location('Leaving ' || l_proc, 30);
131: --
132: exception
133: when others then
134: p_token_value := null;

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

186: l_legal_entity_id number;
187: l_proc varchar2(50) := g_package || 'range_cursor';
188:
189: begin
190: hr_utility.set_location('Entering ' || l_proc, 10);
191:
192: -- Bug 16174886
193: -- Leg Entity param added to CP
194:

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

246: order by paf.person_id';
247:
248:
249: -- Bug 16174886
250: hr_utility.set_location('Leaving ' || l_proc, 10);
251:
252: --hr_utility.trace_off;
253: --
254: exception

Line 252: --hr_utility.trace_off;

248:
249: -- Bug 16174886
250: hr_utility.set_location('Leaving ' || l_proc, 10);
251:
252: --hr_utility.trace_off;
253: --
254: exception
255: when others then
256: sqlstr := null;

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

309: l_legal_entity_name varchar2(240);
310: l_proc varchar2(50) := g_package || 'arch_init';
311:
312: begin
313: hr_utility.set_location('Entering ' || l_proc, 10);
314:
315: -- Get the effective date of the payroll action
316: open csr_archive_effective_date(p_payroll_action_id); -- Payroll Action of the Archiver
317: fetch csr_archive_effective_date

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

377: p_action_information1 => l_legal_entity_id,
378: p_action_information2 => l_legal_entity_name,
379: p_action_information3 => l_payroll_prd
380: );
381: hr_utility.set_location('Leaving ' || l_proc, 10);
382: end archinit;
383:
384:
385: --

Line 481: hr_utility.set_location('pactid '||to_char(pactid), 10);

477:
478: l_proc varchar2(50) := g_package || 'action_creation';
479: begin
480: -- Retrieve the Calendar Month from legislative parameters from the payroll action
481: hr_utility.set_location('pactid '||to_char(pactid), 10);
482:
483: hr_utility.set_location('stperson '||to_char(stperson), 10);
484: hr_utility.set_location('endperson '||to_char(endperson), 10);
485:

Line 483: hr_utility.set_location('stperson '||to_char(stperson), 10);

479: begin
480: -- Retrieve the Calendar Month from legislative parameters from the payroll action
481: hr_utility.set_location('pactid '||to_char(pactid), 10);
482:
483: hr_utility.set_location('stperson '||to_char(stperson), 10);
484: hr_utility.set_location('endperson '||to_char(endperson), 10);
485:
486: get_parameters
487: (

Line 484: hr_utility.set_location('endperson '||to_char(endperson), 10);

480: -- Retrieve the Calendar Month from legislative parameters from the payroll action
481: hr_utility.set_location('pactid '||to_char(pactid), 10);
482:
483: hr_utility.set_location('stperson '||to_char(stperson), 10);
484: hr_utility.set_location('endperson '||to_char(endperson), 10);
485:
486: get_parameters
487: (
488: p_payroll_action_id => pactid, -- Payroll Action of the Archiver

Line 493: hr_utility.set_location('l_calendar_month '||l_calendar_month, 10);

489: p_token_name => 'CALENDAR_MONTH',
490: p_token_value => l_calendar_month
491: );
492:
493: hr_utility.set_location('l_calendar_month '||l_calendar_month, 10);
494:
495: l_month_start := add_months(fnd_date.canonical_to_date(l_calendar_month), -1)+1;
496: l_month_end := fnd_date.canonical_to_date(l_calendar_month) ;
497:

Line 498: hr_utility.set_location('l_month_start '||to_char(l_month_start, 'dd/mm/yyyy'), 10);

494:
495: l_month_start := add_months(fnd_date.canonical_to_date(l_calendar_month), -1)+1;
496: l_month_end := fnd_date.canonical_to_date(l_calendar_month) ;
497:
498: hr_utility.set_location('l_month_start '||to_char(l_month_start, 'dd/mm/yyyy'), 10);
499: hr_utility.set_location('l_month_end '||to_char(l_month_end, 'dd/mm/yyyy'), 10);
500:
501: -- Retrieve the Calendar Month from legislative parameters from the payroll action
502: get_parameters

Line 499: hr_utility.set_location('l_month_end '||to_char(l_month_end, 'dd/mm/yyyy'), 10);

495: l_month_start := add_months(fnd_date.canonical_to_date(l_calendar_month), -1)+1;
496: l_month_end := fnd_date.canonical_to_date(l_calendar_month) ;
497:
498: hr_utility.set_location('l_month_start '||to_char(l_month_start, 'dd/mm/yyyy'), 10);
499: hr_utility.set_location('l_month_end '||to_char(l_month_end, 'dd/mm/yyyy'), 10);
500:
501: -- Retrieve the Calendar Month from legislative parameters from the payroll action
502: get_parameters
503: (

Line 509: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);

505: p_token_name => 'ASG_SET_ID',
506: p_token_value => l_asg_set_id
507: );
508:
509: hr_utility.set_location('l_asg_set_id '||to_char(l_asg_set_id), 10);
510:
511: -- Bug 16174886
512:
513: -- Retrieve the Payroll_ID from legislative parameters from the payroll action

Line 531: hr_utility.set_location('l_legal_entity_id '||to_char(l_legal_entity_id), 10);

527: );
528:
529: -- Bug 16174886
530:
531: hr_utility.set_location('l_legal_entity_id '||to_char(l_legal_entity_id), 10);
532: hr_utility.set_location('l_payroll_id '||to_char(l_payroll_id), 10);
533:
534: if l_asg_set_id is not null then
535: -- find out if assignments in assignment-set are set to Include or Exclude.

Line 532: hr_utility.set_location('l_payroll_id '||to_char(l_payroll_id), 10);

528:
529: -- Bug 16174886
530:
531: hr_utility.set_location('l_legal_entity_id '||to_char(l_legal_entity_id), 10);
532: hr_utility.set_location('l_payroll_id '||to_char(l_payroll_id), 10);
533:
534: if l_asg_set_id is not null then
535: -- find out if assignments in assignment-set are set to Include or Exclude.
536: begin

Line 548: hr_utility.set_location('Before csr_get_asg', 20);

544: v_incl_sw := 'I';
545: end;
546: end if;
547:
548: hr_utility.set_location('Before csr_get_asg', 20);
549:
550: for asgrec in csr_get_asg ( pactid, stperson, endperson, l_month_start, l_month_end, l_legal_entity_id, l_payroll_id)
551: loop
552: hr_utility.set_location('ASS_ID: ' || to_char(asgrec.assignment_id), 30);

Line 552: hr_utility.set_location('ASS_ID: ' || to_char(asgrec.assignment_id), 30);

548: hr_utility.set_location('Before csr_get_asg', 20);
549:
550: for asgrec in csr_get_asg ( pactid, stperson, endperson, l_month_start, l_month_end, l_legal_entity_id, l_payroll_id)
551: loop
552: hr_utility.set_location('ASS_ID: ' || to_char(asgrec.assignment_id), 30);
553: asg_include := TRUE;
554:
555: -- Remove duplicate assignments
556: if prev_asg_id <> asgrec.assignment_id then

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

597: end if; --end of if asg_include = TRUE
598: end if; -- end of ( if not duplicate assignment )
599: end loop ;
600:
601: hr_utility.set_location('Leaving ' || l_proc, 30);
602:
603: --hr_utility.trace_off;
604:
605: end action_creation;

Line 603: --hr_utility.trace_off;

599: end loop ;
600:
601: hr_utility.set_location('Leaving ' || l_proc, 30);
602:
603: --hr_utility.trace_off;
604:
605: end action_creation;
606:
607: --

Line 945: -- hr_utility.trace_on(null, 'ZA_EMP201');

941: l_bal_name_table t_bal_name_table;
942: -- Bug 14081001
943:
944: begin
945: -- hr_utility.trace_on(null, 'ZA_EMP201');
946: -- Bug 14081001
947: l_bal_name_table.delete;
948: l_net_bal_table.delete;
949: l_asg_act_id_table.delete;

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

950: l_context_lst.delete;
951: l_output_table.delete;
952: l_defined_balance_lst.delete;
953: -- Bug 14081001
954: hr_utility.set_location('Entering ' || l_proc, 10);
955:
956: --get the Archive Effective Date
957: select ppa.payroll_action_id
958: into l_pactid_archive

Line 985: hr_utility.set_location('csr_asg_details not found',10);

981: , l_period_of_service_id
982: , l_assignment_no
983: , l_ass_payroll_id;
984: if csr_asg_details%NOTFOUND then
985: hr_utility.set_location('csr_asg_details not found',10);
986: select max(effective_end_date)
987: into l_asg_end_date
988: from per_all_assignments_f paf,
989: pay_assignment_actions paa

Line 994: -- hr_utility.set_location('l_asg_end_date: '||to_char('l_asg_end_date','dd-mon-yyyy'),10);

990: where effective_end_date <= l_month_end
991: and paa.assignment_id = paf.assignment_id
992: and paa.assignment_action_id = p_assactid;
993:
994: -- hr_utility.set_location('l_asg_end_date: '||to_char('l_asg_end_date','dd-mon-yyyy'),10);
995: hr_utility.set_location('Found csr_asg_details',10);
996:
997: close csr_asg_details ;
998:

Line 995: hr_utility.set_location('Found csr_asg_details',10);

991: and paa.assignment_id = paf.assignment_id
992: and paa.assignment_action_id = p_assactid;
993:
994: -- hr_utility.set_location('l_asg_end_date: '||to_char('l_asg_end_date','dd-mon-yyyy'),10);
995: hr_utility.set_location('Found csr_asg_details',10);
996:
997: close csr_asg_details ;
998:
999: open csr_asg_details (l_asg_end_date);

Line 1009: hr_utility.set_location(l_proc, 20);

1005: , l_ass_payroll_id;
1006: end if ;
1007: close csr_asg_details ;
1008:
1009: hr_utility.set_location(l_proc, 20);
1010:
1011: --Retrieve the ZA_SPECIFIC_INFO details
1012: open csr_asg_specific_info_dtls (l_assignment_id, nvl(l_asg_end_date,l_effective_date), l_period_of_service_id);
1013: fetch csr_asg_specific_info_dtls into l_nature_of_person

Line 1018: hr_utility.set_location(l_proc, 30);

1014: , l_independent_contractor
1015: , l_labour_broker
1016: , l_EMP201_status ;
1017: if csr_asg_specific_info_dtls%NOTFOUND then
1018: hr_utility.set_location(l_proc, 30);
1019: l_nature_of_person := 'A' ;
1020: l_independent_contractor := 'N' ;
1021: l_labour_broker := 'N';
1022: l_EMP201_status := per_za_employment_equity_pkg.get_ee_employment_type_name(l_effective_date, l_period_of_service_id);

Line 1026: hr_utility.set_location(l_proc, 40);

1022: l_EMP201_status := per_za_employment_equity_pkg.get_ee_employment_type_name(l_effective_date, l_period_of_service_id);
1023: end if ;
1024: close csr_asg_specific_info_dtls ;
1025:
1026: hr_utility.set_location(l_proc, 40);
1027:
1028: --Retrieve the UIF details
1029: open csr_asg_uif_info_dtls(l_assignment_id) ;
1030: fetch csr_asg_uif_info_dtls into l_reason_for_uif_non_contrib ;

Line 1033: hr_utility.set_location(l_proc, 50);

1029: open csr_asg_uif_info_dtls(l_assignment_id) ;
1030: fetch csr_asg_uif_info_dtls into l_reason_for_uif_non_contrib ;
1031: close csr_asg_uif_info_dtls ;
1032:
1033: hr_utility.set_location(l_proc, 50);
1034:
1035: --Retrieve the last payroll run for this employee in the current Month (Month for which archival is run)
1036: open csr_payroll_action (l_assignment_id, l_effective_date);
1037: fetch csr_payroll_action into l_last_run_payroll_action_id

Line 1041: hr_utility.trace('Payroll Not Run this month');

1037: fetch csr_payroll_action into l_last_run_payroll_action_id
1038: , l_payroll_id
1039: , l_pay_effective_date;
1040: if csr_payroll_action%NOTFOUND then
1041: hr_utility.trace('Payroll Not Run this month');
1042: hr_utility.set_location(l_proc, 60);
1043: l_last_run_payroll_action_id := null ;
1044: end if ;
1045: close csr_payroll_action ;

Line 1042: hr_utility.set_location(l_proc, 60);

1038: , l_payroll_id
1039: , l_pay_effective_date;
1040: if csr_payroll_action%NOTFOUND then
1041: hr_utility.trace('Payroll Not Run this month');
1042: hr_utility.set_location(l_proc, 60);
1043: l_last_run_payroll_action_id := null ;
1044: end if ;
1045: close csr_payroll_action ;
1046:

Line 1047: hr_utility.set_location(l_proc, 70);

1043: l_last_run_payroll_action_id := null ;
1044: end if ;
1045: close csr_payroll_action ;
1046:
1047: hr_utility.set_location(l_proc, 70);
1048:
1049: hr_utility.trace('Assignment_id : '||l_assignment_id);
1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);

Line 1049: hr_utility.trace('Assignment_id : '||l_assignment_id);

1045: close csr_payroll_action ;
1046:
1047: hr_utility.set_location(l_proc, 70);
1048:
1049: hr_utility.trace('Assignment_id : '||l_assignment_id);
1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);

Line 1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);

1046:
1047: hr_utility.set_location(l_proc, 70);
1048:
1049: hr_utility.trace('Assignment_id : '||l_assignment_id);
1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);

Line 1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);

1047: hr_utility.set_location(l_proc, 70);
1048:
1049: hr_utility.trace('Assignment_id : '||l_assignment_id);
1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);

Line 1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);

1048:
1049: hr_utility.trace('Assignment_id : '||l_assignment_id);
1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);
1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);

Line 1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);

1049: hr_utility.trace('Assignment_id : '||l_assignment_id);
1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);
1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);
1057: hr_utility.trace('l_month_end : '||l_month_end);

Line 1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);

1050: hr_utility.trace('l_nature_of_person : '||l_nature_of_person);
1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);
1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);
1057: hr_utility.trace('l_month_end : '||l_month_end);
1058:

Line 1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);

1051: hr_utility.trace('l_independent_contractor : '||l_independent_contractor);
1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);
1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);
1057: hr_utility.trace('l_month_end : '||l_month_end);
1058:
1059: -- Bug 14081001

Line 1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);

1052: hr_utility.trace('l_labour_broker : '||l_labour_broker);
1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);
1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);
1057: hr_utility.trace('l_month_end : '||l_month_end);
1058:
1059: -- Bug 14081001
1060: l_loop_count := 0;

Line 1057: hr_utility.trace('l_month_end : '||l_month_end);

1053: hr_utility.trace('l_EMP201_status : '||l_EMP201_status);
1054: hr_utility.trace('l_reason_for_non_contrib : '||l_reason_for_uif_non_contrib);
1055: hr_utility.trace('l_last_run_payroll_action_id : '||l_last_run_payroll_action_id);
1056: hr_utility.trace('l_payroll_id : '||l_payroll_id);
1057: hr_utility.trace('l_month_end : '||l_month_end);
1058:
1059: -- Bug 14081001
1060: l_loop_count := 0;
1061: for ass_act_id in csr_get_rr_aa_id (p_assignment_id=> l_assignment_id,

Line 1065: hr_utility.set_location(l_proc, 71);

1061: for ass_act_id in csr_get_rr_aa_id (p_assignment_id=> l_assignment_id,
1062: p_month_end => l_month_end,
1063: p_payroll_id=> l_payroll_id)
1064: loop
1065: hr_utility.set_location(l_proc, 71);
1066: l_loop_count := l_loop_count + 1;
1067: hr_utility.trace('assignment_action_id : '||ass_act_id.assignment_action_id);
1068: l_asg_act_id_table(l_loop_count) := ass_act_id.assignment_action_id;
1069: end loop;

Line 1067: hr_utility.trace('assignment_action_id : '||ass_act_id.assignment_action_id);

1063: p_payroll_id=> l_payroll_id)
1064: loop
1065: hr_utility.set_location(l_proc, 71);
1066: l_loop_count := l_loop_count + 1;
1067: hr_utility.trace('assignment_action_id : '||ass_act_id.assignment_action_id);
1068: l_asg_act_id_table(l_loop_count) := ass_act_id.assignment_action_id;
1069: end loop;
1070: l_loop_count := 0;
1071: if l_asg_act_id_table.COUNT > 0 then

Line 1072: hr_utility.set_location(l_proc, 72);

1068: l_asg_act_id_table(l_loop_count) := ass_act_id.assignment_action_id;
1069: end loop;
1070: l_loop_count := 0;
1071: if l_asg_act_id_table.COUNT > 0 then
1072: hr_utility.set_location(l_proc, 72);
1073: -- to get data for batch balance retrieval
1074: for balance in csr_get_balance_data
1075: loop
1076: hr_utility.set_location(l_proc, 73);

Line 1076: hr_utility.set_location(l_proc, 73);

1072: hr_utility.set_location(l_proc, 72);
1073: -- to get data for batch balance retrieval
1074: for balance in csr_get_balance_data
1075: loop
1076: hr_utility.set_location(l_proc, 73);
1077: l_loop_count := l_loop_count + 1;
1078: hr_utility.trace('l_loop_count : '||l_loop_count);
1079:
1080: l_defined_balance_lst(l_loop_count).defined_balance_id := pay_za_payroll_action_pkg.defined_balance_id(balance.balance_name, '_ASG_RUN');

Line 1078: hr_utility.trace('l_loop_count : '||l_loop_count);

1074: for balance in csr_get_balance_data
1075: loop
1076: hr_utility.set_location(l_proc, 73);
1077: l_loop_count := l_loop_count + 1;
1078: hr_utility.trace('l_loop_count : '||l_loop_count);
1079:
1080: l_defined_balance_lst(l_loop_count).defined_balance_id := pay_za_payroll_action_pkg.defined_balance_id(balance.balance_name, '_ASG_RUN');
1081: hr_utility.trace(' balance.balance_name : '|| balance.balance_name);
1082: hr_utility.trace(' l_defined_balance_lst(l_loop_count).defined_balance_id : '|| l_defined_balance_lst(l_loop_count).defined_balance_id);

Line 1081: hr_utility.trace(' balance.balance_name : '|| balance.balance_name);

1077: l_loop_count := l_loop_count + 1;
1078: hr_utility.trace('l_loop_count : '||l_loop_count);
1079:
1080: l_defined_balance_lst(l_loop_count).defined_balance_id := pay_za_payroll_action_pkg.defined_balance_id(balance.balance_name, '_ASG_RUN');
1081: hr_utility.trace(' balance.balance_name : '|| balance.balance_name);
1082: hr_utility.trace(' l_defined_balance_lst(l_loop_count).defined_balance_id : '|| l_defined_balance_lst(l_loop_count).defined_balance_id);
1083:
1084: -- Initializing the l_net_bal_table to Zero
1085: l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id) := balance.balance_name;

Line 1082: hr_utility.trace(' l_defined_balance_lst(l_loop_count).defined_balance_id : '|| l_defined_balance_lst(l_loop_count).defined_balance_id);

1078: hr_utility.trace('l_loop_count : '||l_loop_count);
1079:
1080: l_defined_balance_lst(l_loop_count).defined_balance_id := pay_za_payroll_action_pkg.defined_balance_id(balance.balance_name, '_ASG_RUN');
1081: hr_utility.trace(' balance.balance_name : '|| balance.balance_name);
1082: hr_utility.trace(' l_defined_balance_lst(l_loop_count).defined_balance_id : '|| l_defined_balance_lst(l_loop_count).defined_balance_id);
1083:
1084: -- Initializing the l_net_bal_table to Zero
1085: l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id) := balance.balance_name;
1086: hr_utility.trace(' l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id) : '|| l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id));

Line 1086: hr_utility.trace(' l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id) : '|| l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id));

1082: hr_utility.trace(' l_defined_balance_lst(l_loop_count).defined_balance_id : '|| l_defined_balance_lst(l_loop_count).defined_balance_id);
1083:
1084: -- Initializing the l_net_bal_table to Zero
1085: l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id) := balance.balance_name;
1086: hr_utility.trace(' l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id) : '|| l_bal_name_table(l_defined_balance_lst(l_loop_count).defined_balance_id));
1087:
1088: l_net_bal_table(balance.balance_name).bal_value := 0;
1089: l_net_bal_table(balance.balance_name).defined_balance_id := l_defined_balance_lst(l_loop_count).defined_balance_id;
1090:

Line 1093: hr_utility.set_location(l_proc, 74);

1089: l_net_bal_table(balance.balance_name).defined_balance_id := l_defined_balance_lst(l_loop_count).defined_balance_id;
1090:
1091: end loop;
1092:
1093: hr_utility.set_location(l_proc, 74);
1094: -- to get data for batch balance retrieval
1095:
1096: l_context_lst(1).tax_unit_id :=null;
1097: l_context_lst(1).jurisdiction_code :=null;

Line 1110: hr_utility.set_location(l_proc, 75);

1106: l_context_lst(1).organization_id :=null;
1107:
1108: for i in l_asg_act_id_table.first .. l_asg_act_id_table.last
1109: loop
1110: hr_utility.set_location(l_proc, 75);
1111: hr_utility.trace(' l_asg_act_id_table(i) : '|| l_asg_act_id_table(i));
1112: pay_balance_pkg.get_value(p_assignment_action_id => l_asg_act_id_table(i)
1113: , p_defined_balance_lst => l_defined_balance_lst
1114: , p_context_lst => l_context_lst

Line 1111: hr_utility.trace(' l_asg_act_id_table(i) : '|| l_asg_act_id_table(i));

1107:
1108: for i in l_asg_act_id_table.first .. l_asg_act_id_table.last
1109: loop
1110: hr_utility.set_location(l_proc, 75);
1111: hr_utility.trace(' l_asg_act_id_table(i) : '|| l_asg_act_id_table(i));
1112: pay_balance_pkg.get_value(p_assignment_action_id => l_asg_act_id_table(i)
1113: , p_defined_balance_lst => l_defined_balance_lst
1114: , p_context_lst => l_context_lst
1115: , p_output_table => l_output_table

Line 1118: hr_utility.set_location(l_proc, 76);

1114: , p_context_lst => l_context_lst
1115: , p_output_table => l_output_table
1116: );
1117:
1118: hr_utility.set_location(l_proc, 76);
1119: hr_utility.trace(' l_output_table.COUNT : '|| l_output_table.COUNT);
1120: for j in l_output_table.first .. l_output_table.last
1121: loop
1122: hr_utility.set_location(l_proc, 77);

Line 1119: hr_utility.trace(' l_output_table.COUNT : '|| l_output_table.COUNT);

1115: , p_output_table => l_output_table
1116: );
1117:
1118: hr_utility.set_location(l_proc, 76);
1119: hr_utility.trace(' l_output_table.COUNT : '|| l_output_table.COUNT);
1120: for j in l_output_table.first .. l_output_table.last
1121: loop
1122: hr_utility.set_location(l_proc, 77);
1123: l_net_bal_table(l_bal_name_table(l_output_table(j).defined_balance_id)).bal_value := l_net_bal_table(l_bal_name_table(l_output_table(j).defined_balance_id)).bal_value

Line 1122: hr_utility.set_location(l_proc, 77);

1118: hr_utility.set_location(l_proc, 76);
1119: hr_utility.trace(' l_output_table.COUNT : '|| l_output_table.COUNT);
1120: for j in l_output_table.first .. l_output_table.last
1121: loop
1122: hr_utility.set_location(l_proc, 77);
1123: l_net_bal_table(l_bal_name_table(l_output_table(j).defined_balance_id)).bal_value := l_net_bal_table(l_bal_name_table(l_output_table(j).defined_balance_id)).bal_value
1124: + nvl(l_output_table(j).balance_value,0);
1125: end loop;
1126:

Line 1146: hr_utility.set_location(l_proc, 80);

1142: l_paye_remuneration := l_paye_remuneration + l_net_bal_table('Net PAYE Taxable Income').bal_value ;
1143: end if;
1144: -- Bug 14081001
1145:
1146: hr_utility.set_location(l_proc, 80);
1147: -- Get SDL Data
1148: open get_sdl_exemption (l_assignment_id, nvl(l_asg_end_date,l_effective_date));
1149: fetch get_sdl_exemption into l_sdl_exemption ;
1150: close get_sdl_exemption ;

Line 1156: hr_utility.set_location(l_proc, 90);

1152:
1153: -- exclude Exempt employees
1154: if l_sdl_exemption = 'N' then
1155:
1156: hr_utility.set_location(l_proc, 90);
1157:
1158: l_net_taxable_inc_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Net Taxable Income', '_ASG_TAX_MTD');
1159: l_skills_levy_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Skills Levy', '_ASG_TAX_MTD');
1160:

Line 1175: hr_utility.set_location(l_proc, 100);

1171: if l_leviable_amt < 0 then
1172: l_leviable_amt := 0 ;
1173: end if ;
1174: else
1175: hr_utility.set_location(l_proc, 100);
1176: l_leviable_amt := 0 ;
1177: l_sdl_amt := 0 ;
1178: end if ;
1179:

Line 1189: hr_utility.set_location(l_proc, 110);

1185: l_temp_emp_hours_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('ZA_TEMPORARY_EMPLOYEE_HOURS', '_ASG_TAX_MTD');
1186: l_temp_emp_hours := nvl(pay_balance_pkg.get_value(l_temp_emp_hours_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1187:
1188: if l_last_run_payroll_action_id is null then -- No payroll run for this calendar month
1189: hr_utility.set_location(l_proc, 110);
1190: l_uif_amt := 0 ;
1191: l_uif_remuneration := 0 ;
1192: elsif (l_nature_of_person in ('D','E','F','G','H','K') or
1193: l_independent_contractor = 'Y' or

Line 1200: hr_utility.set_location(l_proc, 120);

1196: and
1197: l_temp_emp_hours < 24.0
1198: )
1199: ) then
1200: hr_utility.set_location(l_proc, 120);
1201: l_uif_amt := 0 ;
1202: l_uif_remuneration := 0 ;
1203: else
1204: hr_utility.set_location(l_proc, 130);

Line 1204: hr_utility.set_location(l_proc, 130);

1200: hr_utility.set_location(l_proc, 120);
1201: l_uif_amt := 0 ;
1202: l_uif_remuneration := 0 ;
1203: else
1204: hr_utility.set_location(l_proc, 130);
1205: -- get UIF amount and Remuneration
1206: l_uif_ee_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employee Contribution', '_ASG_TAX_MTD');
1207: l_uif_er_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('UIF Employer Contribution', '_ASG_TAX_MTD');
1208: l_uifable_income_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Total UIFable Income', '_ASG_TAX_MTD');

Line 1249: hr_utility.set_location(l_proc, 140);

1245: l_UIF_period_limit := round(l_za_pay_mnth_prd_num * l_UIF_Annual_Limit / l_pay_prd_per_yr ,2) ;
1246:
1247: -- if UIF Remuneration > period_limit, then truncate it to period_limit
1248: if l_uif_remuneration > l_UIF_period_limit then
1249: hr_utility.set_location(l_proc, 140);
1250: l_uif_remuneration := l_UIF_period_limit ;
1251: end if ;
1252: end if ;
1253:

Line 1254: hr_utility.set_location(l_proc, 150);

1250: l_uif_remuneration := l_UIF_period_limit ;
1251: end if ;
1252: end if ;
1253:
1254: hr_utility.set_location(l_proc, 150);
1255:
1256: -- whether to count the employee in Permanent or Non-Permanent or None
1257: if (l_nature_of_person not in ('D','E','F','G','H','K') and
1258: l_independent_contractor <> 'Y' and

Line 1261: hr_utility.set_location(l_proc, 160);

1257: if (l_nature_of_person not in ('D','E','F','G','H','K') and
1258: l_independent_contractor <> 'Y' and
1259: l_labour_broker <> 'Y') then
1260:
1261: hr_utility.set_location(l_proc, 160);
1262:
1263: -- get tax_status from run results
1264: if l_last_run_payroll_action_id is not null then
1265: hr_utility.set_location(l_proc, 170);

Line 1265: hr_utility.set_location(l_proc, 170);

1261: hr_utility.set_location(l_proc, 160);
1262:
1263: -- get tax_status from run results
1264: if l_last_run_payroll_action_id is not null then
1265: hr_utility.set_location(l_proc, 170);
1266: open csr_tax_status(l_last_run_payroll_action_id);
1267: fetch csr_tax_status into l_tax_status ;
1268: close csr_tax_status ;
1269: else

Line 1271: hr_utility.set_location(l_proc, 180);

1267: fetch csr_tax_status into l_tax_status ;
1268: close csr_tax_status ;
1269: else
1270: -- get tax status from element entry screen values
1271: hr_utility.set_location(l_proc, 180);
1272: -- tax status effective as on month_end_date / assignment_end_date
1273: open csr_tax_status_from_ele_entry (l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)) ;
1274: fetch csr_tax_status_from_ele_entry into l_tax_status ;
1275: if csr_tax_status_from_ele_entry%NOTFOUND then

Line 1276: hr_utility.set_location(l_proc, 190);

1272: -- tax status effective as on month_end_date / assignment_end_date
1273: open csr_tax_status_from_ele_entry (l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)) ;
1274: fetch csr_tax_status_from_ele_entry into l_tax_status ;
1275: if csr_tax_status_from_ele_entry%NOTFOUND then
1276: hr_utility.set_location(l_proc, 190);
1277: -- if tax status not specified, assume to be non-seasonal worker
1278: l_tax_status := 'A' ;
1279: end if ;
1280: close csr_tax_status_from_ele_entry;

Line 1283: hr_utility.trace('tax_status :'||l_tax_status);

1279: end if ;
1280: close csr_tax_status_from_ele_entry;
1281: end if ;
1282:
1283: hr_utility.trace('tax_status :'||l_tax_status);
1284:
1285: l_gross_remun_dim_mtd := pay_za_payroll_action_pkg.defined_balance_id('Gross Remuneration', '_ASG_CAL_MTD');
1286: l_gross_remun := nvl(pay_balance_pkg.get_value(l_gross_remun_dim_mtd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0) ;
1287:

Line 1297: hr_utility.set_location(l_proc, 200);

1293:
1294: if l_tax_status = 'G' and l_gross_remun = 0 then
1295: -- Seasonal worker and no remuneration in this month
1296: -- Hence don't count this employee
1297: hr_utility.set_location(l_proc, 200);
1298: l_seasonal_not_paid_flag := true ;
1299: end if ;
1300:
1301: -- Do not count if employee is a seasonal worker

Line 1304: hr_utility.set_location(l_proc, 210);

1300:
1301: -- Do not count if employee is a seasonal worker
1302: -- and has not been paid any remuneration this month
1303: if l_seasonal_not_paid_flag = false then
1304: hr_utility.set_location(l_proc, 210);
1305: if l_EMP201_status = 'Permanent' then
1306: hr_utility.set_location(l_proc, 220);
1307: l_cnt_paye_perm := 'Y' ;
1308: else

Line 1306: hr_utility.set_location(l_proc, 220);

1302: -- and has not been paid any remuneration this month
1303: if l_seasonal_not_paid_flag = false then
1304: hr_utility.set_location(l_proc, 210);
1305: if l_EMP201_status = 'Permanent' then
1306: hr_utility.set_location(l_proc, 220);
1307: l_cnt_paye_perm := 'Y' ;
1308: else
1309: hr_utility.set_location(l_proc, 230);
1310: if l_gross_remun > 0 then

Line 1309: hr_utility.set_location(l_proc, 230);

1305: if l_EMP201_status = 'Permanent' then
1306: hr_utility.set_location(l_proc, 220);
1307: l_cnt_paye_perm := 'Y' ;
1308: else
1309: hr_utility.set_location(l_proc, 230);
1310: if l_gross_remun > 0 then
1311: hr_utility.set_location(l_proc, 240);
1312: -- Count non-permanent employees only if
1313: -- remuneration was paid / accrued to them during

Line 1311: hr_utility.set_location(l_proc, 240);

1307: l_cnt_paye_perm := 'Y' ;
1308: else
1309: hr_utility.set_location(l_proc, 230);
1310: if l_gross_remun > 0 then
1311: hr_utility.set_location(l_proc, 240);
1312: -- Count non-permanent employees only if
1313: -- remuneration was paid / accrued to them during
1314: -- the relevant month
1315: l_cnt_paye_non_perm := 'Y';

Line 1324: hr_utility.set_location(l_proc, 220);

1320: l_cnt_paye_perm := 'N' ;
1321: end if ;
1322: end if ;
1323:
1324: hr_utility.set_location(l_proc, 220);
1325:
1326: -------WARNING PAGE ------------------------------
1327:
1328: -- Check each employee processed to see if they are terminated or not.

Line 1339: hr_utility.set_location(l_proc, 245);

1335: -- check if assignment is terminated
1336: open csr_check_asg_termination(l_assignment_id, l_effective_date);
1337: fetch csr_check_asg_termination into l_asg_terminated ;
1338: if csr_check_asg_termination%NOTFOUND then
1339: hr_utility.set_location(l_proc, 245);
1340: l_asg_terminated := 'Y' ;
1341: end if ;
1342: close csr_check_asg_termination ;
1343:

Line 1345: hr_utility.set_location(l_proc, 250);

1341: end if ;
1342: close csr_check_asg_termination ;
1343:
1344: if l_asg_terminated = 'Y' then -- assignment is terminated
1345: hr_utility.set_location(l_proc, 250);
1346: l_tax_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('Tax', '_ASG_TAX_YTD');
1347: l_tax_ytd := nvl(pay_balance_pkg.get_value(l_tax_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1348:
1349: l_site_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('SITE', '_ASG_TAX_YTD');

Line 1356: hr_utility.set_location(l_proc, 255);

1352: l_paye_dim_ytd := pay_za_payroll_action_pkg.defined_balance_id('PAYE', '_ASG_TAX_YTD');
1353: l_paye := nvl(pay_balance_pkg.get_value(l_paye_dim_ytd, l_assignment_id,nvl(l_asg_end_date,l_pay_effective_date)),0);
1354:
1355: if l_tax_ytd <> 0 and l_site = 0 and l_paye = 0 then -- SITE/PAYE split not calculated
1356: hr_utility.set_location(l_proc, 255);
1357: l_raise_warning := 'Y' ;
1358: end if ; -- end of SITE/PAYE split not calculated for the assignment
1359: end if ; -- end of Assignment Terminated
1360:

Line 1361: hr_utility.set_location(l_proc, 260);

1357: l_raise_warning := 'Y' ;
1358: end if ; -- end of SITE/PAYE split not calculated for the assignment
1359: end if ; -- end of Assignment Terminated
1360:
1361: hr_utility.set_location(l_proc, 260);
1362:
1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);

Line 1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);

1359: end if ; -- end of Assignment Terminated
1360:
1361: hr_utility.set_location(l_proc, 260);
1362:
1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);

Line 1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);

1360:
1361: hr_utility.set_location(l_proc, 260);
1362:
1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);

Line 1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);

1361: hr_utility.set_location(l_proc, 260);
1362:
1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);

Line 1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);

1362:
1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);

Line 1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);

1363: hr_utility.set_location('p_action_context_id => '|| to_char(p_assactid), 60);
1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);

Line 1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);

1364: hr_utility.set_location('p_action_context_type => '|| 'AAP', 60);
1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);

Line 1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);

1365: hr_utility.set_location('p_assignment_id => '|| l_assignment_id, 60);
1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);

Line 1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);

1366: hr_utility.set_location('p_effective_date => '|| to_char(l_effective_date, 'dd/mm/yyyy'), 60);
1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);

Line 1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);

1367: hr_utility.set_location('p_action_information_category => '|| 'ZA EMP201 ASSIGNMENT DATA', 60);
1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);

Line 1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);

1368: hr_utility.set_location('p_action_information1 => '|| l_assignment_id, 60);
1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);

Line 1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);

1369: hr_utility.set_location('p_action_information2 => '|| to_char(l_effective_date, 'YYYYMM'), 60);
1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);

Line 1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);

1370: hr_utility.set_location('p_action_information3 => '|| l_employee_number, 60);
1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);

Line 1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);

1371: hr_utility.set_location('p_action_information4 => '|| l_emp_name, 60);
1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);

Line 1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);

1372: hr_utility.set_location('p_action_information5 => '|| l_paye_remuneration, 60);
1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);

Line 1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);

1373: hr_utility.set_location('p_action_information6 => '|| l_tax, 60);
1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);

Line 1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);

1374: hr_utility.set_location('p_action_information7 => '|| l_leviable_amt, 60);
1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);

Line 1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);

1375: hr_utility.set_location('p_action_information8 => '|| l_sdl_amt, 60);
1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);

Line 1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);

1376: hr_utility.set_location('p_action_information9 => '|| l_uif_remuneration, 60);
1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);
1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);

Line 1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);

1377: hr_utility.set_location('p_action_information10 => '|| l_uif_amt, 60);
1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);
1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);
1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);

Line 1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);

1378: hr_utility.set_location('p_action_information11 => '|| l_EMP201_status, 60);
1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);
1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);
1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);
1386:

Line 1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);

1379: hr_utility.set_location('p_action_information12 => '|| l_cnt_paye_perm, 60);
1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);
1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);
1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);
1386:
1387:

Line 1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);

1380: hr_utility.set_location('p_action_information13 => '|| l_cnt_paye_non_perm, 60);
1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);
1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);
1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);
1386:
1387:
1388: -- Archive the ZA EMP201 ASSIGNMENT DETAILS

Line 1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);

1381: hr_utility.set_location('p_action_information14 => '|| l_raise_warning, 60);
1382: hr_utility.set_location('p_action_information15 => '|| l_asg_terminated, 60);
1383: hr_utility.set_location('p_action_information16 => '|| l_assignment_no, 60);
1384: hr_utility.set_location('p_action_information17 => '|| l_pactid_archive, 60);
1385: hr_utility.set_location('p_action_information18 => '|| l_ass_payroll_id, 60);
1386:
1387:
1388: -- Archive the ZA EMP201 ASSIGNMENT DETAILS
1389: pay_action_information_api.create_action_information

Line 1420: hr_utility.set_location('Leaving ' || l_proc, 270);

1416: p_action_information17 => l_pactid_archive,
1417: p_action_information18 => l_ass_payroll_id
1418: );
1419:
1420: hr_utility.set_location('Leaving ' || l_proc, 270);
1421: --hr_utility.trace_off ;
1422: end archive_data;
1423:
1424: -- Bug 16174886

Line 1421: --hr_utility.trace_off ;

1417: p_action_information18 => l_ass_payroll_id
1418: );
1419:
1420: hr_utility.set_location('Leaving ' || l_proc, 270);
1421: --hr_utility.trace_off ;
1422: end archive_data;
1423:
1424: -- Bug 16174886
1425: --

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

1457: l_proc varchar2(50) := g_package || 'arch_dinit';
1458:
1459: begin
1460:
1461: hr_utility.set_location('Entering ' || l_proc, 10);
1462:
1463: for ass_pay_id in csr_distinct_payroll_names_rec
1464: loop
1465: hr_utility.set_location(l_proc, 20);

Line 1465: hr_utility.set_location(l_proc, 20);

1461: hr_utility.set_location('Entering ' || l_proc, 10);
1462:
1463: for ass_pay_id in csr_distinct_payroll_names_rec
1464: loop
1465: hr_utility.set_location(l_proc, 20);
1466:
1467: -- Archive 'ZA EMP201 PAYROLL DETAILS'
1468: pay_action_information_api.create_action_information
1469: (

Line 1480: hr_utility.set_location(l_proc, 30);

1476: p_action_information1 => ass_pay_id.payroll_id,
1477: p_action_information2 => ass_pay_id.payroll_name
1478: );
1479:
1480: hr_utility.set_location(l_proc, 30);
1481: end loop;
1482: hr_utility.set_location('Leaving ' || l_proc, 40);
1483:
1484: end archdinit;

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

1478: );
1479:
1480: hr_utility.set_location(l_proc, 30);
1481: end loop;
1482: hr_utility.set_location('Leaving ' || l_proc, 40);
1483:
1484: end archdinit;
1485:
1486: -- Bug 16174886

Line 1570: hr_utility.set_location(sqlerrm(sqlcode),110);

1566: --
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: --Fnd_file.put_line(FND_FILE.LOG,'## SQLERR ' || sqlerrm(sqlcode));
1570: hr_utility.set_location(sqlerrm(sqlcode),110);
1571: --
1572: END write_to_clob;
1573:
1574: --

Line 1685: -- hr_utility.trace_on(null,'ZAEMP201');

1681: l_payroll_id number;
1682: l_payroll_open number;
1683:
1684: BEGIN
1685: -- hr_utility.trace_on(null,'ZAEMP201');
1686: hr_utility.set_location('Entering ' || l_proc_name, 10);
1687: g_xml_element_table.DELETE;
1688: ---
1689: -- Start XML

Line 1686: hr_utility.set_location('Entering ' || l_proc_name, 10);

1682: l_payroll_open number;
1683:
1684: BEGIN
1685: -- hr_utility.trace_on(null,'ZAEMP201');
1686: hr_utility.set_location('Entering ' || l_proc_name, 10);
1687: g_xml_element_table.DELETE;
1688: ---
1689: -- Start XML
1690: ---

Line 1707: hr_utility.set_location(l_proc_name, 20);

1703: , l_legal_entity_name
1704: , l_payroll_prd;
1705: close csr_get_emp201_le_data ;
1706:
1707: hr_utility.set_location(l_proc_name, 20);
1708:
1709: g_xml_element_table(l_xml_element_count).tagname := 'Legal Entity Information';
1710: g_xml_element_table(l_xml_element_count).tagvalue := '_COMMENT_';
1711: l_xml_element_count := l_xml_element_count + 1;

Line 1731: hr_utility.set_location(l_proc_name, 30);

1727: g_xml_element_table(l_xml_element_count).tagname := 'DETAIL_FLAG';
1728: g_xml_element_table(l_xml_element_count).tagvalue := p_detail_flag;
1729: l_xml_element_count := l_xml_element_count + 1;
1730:
1731: hr_utility.set_location(l_proc_name, 30);
1732:
1733:
1734: ---
1735: -- Payroll Data

Line 1739: hr_utility.trace('Payroll_id : '||pay.payroll_id);

1735: -- Payroll Data
1736: ---
1737: for pay in csr_get_emp201_payroll_data(l_archive_pact)
1738: loop
1739: hr_utility.trace('Payroll_id : '||pay.payroll_id);
1740: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1741:
1742: g_xml_element_table(l_xml_element_count).tagname := 'PAYROLL';
1743: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';

Line 1740: hr_utility.trace('Payroll_name : '||pay.payroll_name);

1736: ---
1737: for pay in csr_get_emp201_payroll_data(l_archive_pact)
1738: loop
1739: hr_utility.trace('Payroll_id : '||pay.payroll_id);
1740: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1741:
1742: g_xml_element_table(l_xml_element_count).tagname := 'PAYROLL';
1743: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';
1744: l_xml_element_count := l_xml_element_count + 1;

Line 1769: hr_utility.trace('Payroll_name : '||pay.payroll_name);

1765: l_cnt_sdl := 0 ;
1766: l_cnt_uif := 0 ;
1767: l_control_tot := 0 ;
1768:
1769: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);
1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);

Line 1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);

1766: l_cnt_uif := 0 ;
1767: l_control_tot := 0 ;
1768:
1769: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);
1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);

Line 1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);

1767: l_control_tot := 0 ;
1768:
1769: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);
1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);

Line 1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);

1768:
1769: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);
1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);

Line 1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);

1769: hr_utility.trace('Payroll_name : '||pay.payroll_name);
1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);
1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);

Line 1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);

1770: hr_utility.trace('l_tot_paye_rem : '||l_tot_paye_rem);
1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);

Line 1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);

1771: hr_utility.trace('l_tot_paye : '||l_tot_paye);
1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);
1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);

Line 1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);

1772: hr_utility.trace('l_tot_leviable_amt: '||l_tot_leviable_amt);
1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);
1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);
1780: hr_utility.trace('l_control_tot : '||l_control_tot);

Line 1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);

1773: hr_utility.trace('l_tot_sdl_amt : '||l_tot_sdl_amt);
1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);
1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);
1780: hr_utility.trace('l_control_tot : '||l_control_tot);
1781:

Line 1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);

1774: hr_utility.trace('l_tot_uif_rem : '||l_tot_uif_rem);
1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);
1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);
1780: hr_utility.trace('l_control_tot : '||l_control_tot);
1781:
1782: ---

Line 1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);

1775: hr_utility.trace('l_tot_uif_amt : '||l_tot_uif_amt);
1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);
1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);
1780: hr_utility.trace('l_control_tot : '||l_control_tot);
1781:
1782: ---
1783: -- Employees Data

Line 1780: hr_utility.trace('l_control_tot : '||l_control_tot);

1776: hr_utility.trace('l_cnt_paye_perm: '||l_cnt_paye_perm);
1777: hr_utility.trace('l_cnt_paye_non_perm: '||l_cnt_paye_non_perm);
1778: hr_utility.trace('l_cnt_sdl : '||l_cnt_sdl);
1779: hr_utility.trace('l_cnt_uif : '||l_cnt_uif);
1780: hr_utility.trace('l_control_tot : '||l_control_tot);
1781:
1782: ---
1783: -- Employees Data
1784: ---

Line 1788: hr_utility.trace('Assignment_id : '||ass.assignment_id);

1784: ---
1785:
1786: for ass in csr_get_emp201_asg_data (l_archive_pact,pay.payroll_id )
1787: loop
1788: hr_utility.trace('Assignment_id : '||ass.assignment_id);
1789:
1790: /* 1. Dont display employee records if the employee is terminated and has not earned any
1791: late payment, and hence dont count them in permanent/non-permanent.
1792: 2. In case of non-permanent employees with no remuneration, dont display in the report

Line 1801: hr_utility.set_location(l_proc_name, 100);

1797: then
1798: null;
1799: else
1800: if p_detail_flag = 'Y' then
1801: hr_utility.set_location(l_proc_name, 100);
1802: if l_first_asgn_rec then
1803: -- Add start tag before the first assignment
1804: g_xml_element_table(l_xml_element_count).tagname := 'Employees Information';
1805: g_xml_element_table(l_xml_element_count).tagvalue := '_COMMENT_';

Line 1816: hr_utility.set_location(l_proc_name, 110);

1812: l_first_asgn_rec := false;
1813: l_emp_rec_printed := true ;
1814: end if ;
1815:
1816: hr_utility.set_location(l_proc_name, 110);
1817:
1818: -- Employees Data will come here
1819: hr_utility.set_location(l_proc_name, 130);
1820: g_xml_element_table(l_xml_element_count).tagname := 'EMP';

Line 1819: hr_utility.set_location(l_proc_name, 130);

1815:
1816: hr_utility.set_location(l_proc_name, 110);
1817:
1818: -- Employees Data will come here
1819: hr_utility.set_location(l_proc_name, 130);
1820: g_xml_element_table(l_xml_element_count).tagname := 'EMP';
1821: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';
1822: l_xml_element_count := l_xml_element_count + 1;
1823:

Line 1872: hr_utility.set_location(l_proc_name, 140);

1868: l_tot_sdl_amt := l_tot_sdl_amt + ass.sdl_amt ;
1869: l_tot_uif_rem := l_tot_uif_rem + ass.uif_remuneration ;
1870: l_tot_uif_amt := l_tot_uif_amt + ass.uif_amt ;
1871:
1872: hr_utility.set_location(l_proc_name, 140);
1873: if ass.cnt_paye_perm = 'Y' then
1874: l_cnt_paye_perm := l_cnt_paye_perm + 1 ;
1875: end if ;
1876:

Line 1891: hr_utility.set_location(l_proc_name, 150);

1887: end if ;
1888:
1889: end if ; -- end of rem and amt <>0 */
1890:
1891: hr_utility.set_location(l_proc_name, 150);
1892: if ass.raise_warning = 'Y' then
1893: defaulting_asg_count := defaulting_asg_count + 1;
1894: defaulting_emp_rec(defaulting_asg_count).employee_number := ass.employee_number ;
1895: defaulting_emp_rec(defaulting_asg_count).asg_no := ass.assignment_no;

Line 1899: hr_utility.set_location(l_proc_name, 160);

1895: defaulting_emp_rec(defaulting_asg_count).asg_no := ass.assignment_no;
1896: defaulting_emp_rec(defaulting_asg_count).emp_name := ass.emp_name ;
1897: defaulting_emp_rec(defaulting_asg_count).payroll_id := pay.payroll_id;
1898: defaulting_emp_rec(defaulting_asg_count).payroll_name := pay.payroll_name;
1899: hr_utility.set_location(l_proc_name, 160);
1900: end if ;
1901:
1902: end loop ;
1903:

Line 1910: hr_utility.set_location(l_proc_name, 170);

1906: -- data has been printed
1907: g_xml_element_table(l_xml_element_count).tagname := 'ALL_EMP';
1908: g_xml_element_table(l_xml_element_count).tagvalue := '_END_';
1909: l_xml_element_count := l_xml_element_count + 1;
1910: hr_utility.set_location(l_proc_name, 170);
1911: end if;
1912:
1913: l_control_tot := l_tot_paye + l_tot_sdl_amt + l_tot_uif_amt ;
1914:

Line 1978: hr_utility.set_location(l_proc_name, 180);

1974: l_xml_element_count := l_xml_element_count + 1;
1975:
1976: end loop; -- for pay loop
1977:
1978: hr_utility.set_location(l_proc_name, 180);
1979:
1980: -------WARNING PAGE ------------------------------
1981: if defaulting_asg_count > 0 then
1982: hr_utility.set_location(l_proc_name, 190);

Line 1982: hr_utility.set_location(l_proc_name, 190);

1978: hr_utility.set_location(l_proc_name, 180);
1979:
1980: -------WARNING PAGE ------------------------------
1981: if defaulting_asg_count > 0 then
1982: hr_utility.set_location(l_proc_name, 190);
1983: g_xml_element_table(l_xml_element_count).tagname := 'Warning Page';
1984: g_xml_element_table(l_xml_element_count).tagvalue := '_COMMENT_';
1985: l_xml_element_count := l_xml_element_count + 1;
1986:

Line 2002: hr_utility.set_location(l_proc_name, 200);

1998: 'a tax balance adjustment for these employees to ensure correct Tax Year End reporting:';
1999: l_xml_element_count := l_xml_element_count + 1;
2000: end if ;
2001:
2002: hr_utility.set_location(l_proc_name, 200);
2003:
2004: l_payroll_id := 0;
2005: l_payroll_open := 0;
2006:

Line 2060: hr_utility.set_location(l_proc_name,220);

2056: l_xml_element_count := l_xml_element_count + 1;
2057: l_payroll_open := 0;
2058: end if;
2059:
2060: hr_utility.set_location(l_proc_name,220);
2061:
2062: if defaulting_asg_count > 0 then
2063: g_xml_element_table(l_xml_element_count).tagname := 'WARN';
2064: g_xml_element_table(l_xml_element_count).tagvalue := '_END_';

Line 2077: hr_utility.set_location(l_proc_name, 999);

2073: l_xml_element_count := l_xml_element_count + 1;
2074: --
2075: write_to_clob(p_xml);
2076: --
2077: hr_utility.set_location(l_proc_name, 999);
2078: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2079:
2080: END get_emp201_xml ;
2081:

Line 2078: hr_utility.set_location('Leaving ' || l_proc_name, 1000);

2074: --
2075: write_to_clob(p_xml);
2076: --
2077: hr_utility.set_location(l_proc_name, 999);
2078: hr_utility.set_location('Leaving ' || l_proc_name, 1000);
2079:
2080: END get_emp201_xml ;
2081:
2082: END PAY_ZA_EMP201 ;