DBA Data[Home] [Help]

APPS.PER_ZA_WSP_XML_GEN_PKG dependencies on HR_UTILITY

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

175:
176: comp_sdf_det_rec csr_comp_sdf_det%rowtype;
177:
178: begin
179: hr_utility.set_location ('Entering ' || l_proc, 10);
180:
181: -- Update EMPLOYER DETAILS
182: open csr_comp_contacts;
183: fetch csr_comp_contacts into comp_contacts_rec;

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

227: update_dom('SDF_MOBILE', comp_sdf_det_rec.sdf_mobile, g_company_det_level);
228: update_dom('SDF_FAX' , comp_sdf_det_rec.sdf_fax , g_company_det_level);
229: update_dom('SDF_EMAIL' , comp_sdf_det_rec.sdf_email , g_company_det_level);
230: --
231: hr_utility.set_location('Leaving ' || l_proc, 10);
232:
233: end update_company_data;
234: --
235: /*--------------------------------------------------------------------------

Line 366: --hr_utility.trace_on(null,'ZAWSPG');

362: 04 White
363: */
364:
365: begin
366: --hr_utility.trace_on(null,'ZAWSPG');
367: hr_utility.set_location ('Entering ' || l_proc, 10);
368:
369: -- WSP year
370: select legislative_parameters

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

363: */
364:
365: begin
366: --hr_utility.trace_on(null,'ZAWSPG');
367: hr_utility.set_location ('Entering ' || l_proc, 10);
368:
369: -- WSP year
370: select legislative_parameters
371: into l_leg_parameters

Line 377: hr_utility.set_location ('l_wsp_end_year :'||l_wsp_end_year,10);

373: where payroll_action_id = p_payroll_action_id;
374: --
375: l_wsp_end_year := to_number(per_za_wsp_archive_pkg.get_parameter('PLAN_YEAR',l_leg_parameters));
376:
377: hr_utility.set_location ('l_wsp_end_year :'||l_wsp_end_year,10);
378:
379: if l_wsp_end_year is null then
380: l_wsp_end_year := 4712;
381: end if;

Line 385: hr_utility.set_location ('WSP :',10);

381: end if;
382:
383: -- Create parent node for WSP data
384: update_dom('WSP', null, g_wsp_level);
385: hr_utility.set_location ('WSP :',10);
386: update_dom('WSP_START_YEAR', l_wsp_end_year - 1, g_wsp_date_level);
387: update_dom('WSP_END_YEAR', l_wsp_end_year, g_wsp_date_level);
388:
389: -- Update WSP Training Details

Line 539: hr_utility.set_location ('MALE_AFRICANS_TOT :',10);

535: update_dom('FEMALE_TOTALS' , l_ft, g_wsp_benf_det_level);
536: update_dom('DISABILED_TOTALS', l_dt, g_wsp_benf_det_level);
537: end loop;
538: --
539: hr_utility.set_location ('MALE_AFRICANS_TOT :',10);
540: update_dom('MALE_AFRICANS_TOT' , l_wsp_ma_sum, g_wsp_benf_level);
541: hr_utility.set_location ('MALE_AFRICANS_TOT :',20);
542: update_dom('FEMALE_AFRICANS_TOT' , l_wsp_fa_sum, g_wsp_benf_level);
543: update_dom('DISABILED_AFRICANS_TOT' , l_wsp_da_sum, g_wsp_benf_level);

Line 541: hr_utility.set_location ('MALE_AFRICANS_TOT :',20);

537: end loop;
538: --
539: hr_utility.set_location ('MALE_AFRICANS_TOT :',10);
540: update_dom('MALE_AFRICANS_TOT' , l_wsp_ma_sum, g_wsp_benf_level);
541: hr_utility.set_location ('MALE_AFRICANS_TOT :',20);
542: update_dom('FEMALE_AFRICANS_TOT' , l_wsp_fa_sum, g_wsp_benf_level);
543: update_dom('DISABILED_AFRICANS_TOT' , l_wsp_da_sum, g_wsp_benf_level);
544:
545: update_dom('MALE_COLOUREDS_TOT' , l_wsp_mc_sum, g_wsp_benf_level);

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

558: update_dom('FEMALE_TOTALS_TOT' , l_wsp_ft_sum, g_wsp_benf_level);
559: update_dom('DISABILED_TOTALS_TOT' , l_wsp_dt_sum, g_wsp_benf_level);
560:
561:
562: hr_utility.set_location('Leaving ' || l_proc, 10);
563: -- hr_utility.trace_off;
564: end update_wsp_data;
565: --
566:

Line 563: -- hr_utility.trace_off;

559: update_dom('DISABILED_TOTALS_TOT' , l_wsp_dt_sum, g_wsp_benf_level);
560:
561:
562: hr_utility.set_location('Leaving ' || l_proc, 10);
563: -- hr_utility.trace_off;
564: end update_wsp_data;
565: --
566:
567: /*--------------------------------------------------------------------------

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

707:
708: l_sk_pr_num varchar2(2000);
709:
710: begin
711: hr_utility.set_location ('Entering ' || l_proc, 10);
712:
713:
714: -- Create parent node for ATR data
715: update_dom('ATR', null, g_atr_level);

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

980: update_dom('MALE_TOTALS_TOT' , l_mt_sum, g_atr_benf_level);
981: update_dom('FEMALE_TOTALS_TOT' , l_ft_sum, g_atr_benf_level);
982: update_dom('DISABILED_TOTALS_TOT' , l_dt_sum, g_atr_benf_level);
983:
984: hr_utility.set_location('Leaving ' || l_proc, 10);
985:
986: end update_atr_data;
987: --
988:

Line 1021: -- hr_utility.trace_on(null, 'WSP_GEN');

1017: and action_information_category = 'ZA WSP EMPLOYER DETAILS'
1018: and action_context_type = 'PA';
1019:
1020: begin
1021: -- hr_utility.trace_on(null, 'WSP_GEN');
1022: hr_utility.set_location ('Entering ' || l_proc, 10);
1023:
1024: -- Initialize g_xml_dom and create root node
1025: g_xml_dom := xmldom.newDOMDocument;

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

1018: and action_context_type = 'PA';
1019:
1020: begin
1021: -- hr_utility.trace_on(null, 'WSP_GEN');
1022: hr_utility.set_location ('Entering ' || l_proc, 10);
1023:
1024: -- Initialize g_xml_dom and create root node
1025: g_xml_dom := xmldom.newDOMDocument;
1026: main_node := xmldom.makeNode(g_xml_dom);

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

1049: -- open the file p_xml
1050: -- Why ? In the Core wrapper package(PAY_XML_GEN_PKG) this is being closed
1051: dbms_lob.open(p_xml, dbms_lob.lob_readonly);
1052:
1053: hr_utility.set_location('Leaving ' || l_proc, 10);
1054:
1055: -- hr_utility.trace_off;
1056:
1057: end populate_xml_data;

Line 1055: -- hr_utility.trace_off;

1051: dbms_lob.open(p_xml, dbms_lob.lob_readonly);
1052:
1053: hr_utility.set_location('Leaving ' || l_proc, 10);
1054:
1055: -- hr_utility.trace_off;
1056:
1057: end populate_xml_data;
1058:
1059: end PER_ZA_WSP_XML_GEN_PKG;