DBA Data[Home] [Help]

APPS.PER_ZA_WSP_XML_GEN_PKG dependencies on HR_UTILITY

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

180:
181: comp_sdf_det_rec csr_comp_sdf_det%rowtype;
182:
183: begin
184: hr_utility.set_location ('Entering ' || l_proc, 10);
185:
186: -- Update EMPLOYER DETAILS
187: open csr_comp_contacts;
188: fetch csr_comp_contacts into comp_contacts_rec;

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

234: update_dom('SDF_MOBILE', comp_sdf_det_rec.sdf_mobile, g_company_det_level);
235: update_dom('SDF_FAX' , comp_sdf_det_rec.sdf_fax , g_company_det_level);
236: update_dom('SDF_EMAIL' , comp_sdf_det_rec.sdf_email , g_company_det_level);
237: --
238: hr_utility.set_location('Leaving ' || l_proc, 10);
239:
240: end update_company_data;
241: --
242: /*--------------------------------------------------------------------------

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

369: 04 White
370: */
371:
372: begin
373: --hr_utility.trace_on(null,'ZAWSPG');
374: hr_utility.set_location ('Entering ' || l_proc, 10);
375:
376: -- WSP year
377: select legislative_parameters

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

370: */
371:
372: begin
373: --hr_utility.trace_on(null,'ZAWSPG');
374: hr_utility.set_location ('Entering ' || l_proc, 10);
375:
376: -- WSP year
377: select legislative_parameters
378: into l_leg_parameters

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

380: where payroll_action_id = p_payroll_action_id;
381: --
382: l_wsp_end_year := to_number(per_za_wsp_archive_pkg.get_parameter('PLAN_YEAR',l_leg_parameters));
383:
384: hr_utility.set_location ('l_wsp_end_year :'||l_wsp_end_year,10);
385:
386: if l_wsp_end_year is null then
387: l_wsp_end_year := 4712;
388: end if;

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

388: end if;
389:
390: -- Create parent node for WSP data
391: update_dom('WSP', null, g_wsp_level);
392: hr_utility.set_location ('WSP :',10);
393: update_dom('WSP_START_YEAR', l_wsp_end_year - 1, g_wsp_date_level);
394: update_dom('WSP_END_YEAR', l_wsp_end_year, g_wsp_date_level);
395:
396: -- Update WSP Training Details

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

542: update_dom('FEMALE_TOTALS' , l_ft, g_wsp_benf_det_level);
543: update_dom('DISABILED_TOTALS', l_dt, g_wsp_benf_det_level);
544: end loop;
545: --
546: hr_utility.set_location ('MALE_AFRICANS_TOT :',10);
547: update_dom('MALE_AFRICANS_TOT' , l_wsp_ma_sum, g_wsp_benf_level);
548: hr_utility.set_location ('MALE_AFRICANS_TOT :',20);
549: update_dom('FEMALE_AFRICANS_TOT' , l_wsp_fa_sum, g_wsp_benf_level);
550: update_dom('DISABILED_AFRICANS_TOT' , l_wsp_da_sum, g_wsp_benf_level);

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

544: end loop;
545: --
546: hr_utility.set_location ('MALE_AFRICANS_TOT :',10);
547: update_dom('MALE_AFRICANS_TOT' , l_wsp_ma_sum, g_wsp_benf_level);
548: hr_utility.set_location ('MALE_AFRICANS_TOT :',20);
549: update_dom('FEMALE_AFRICANS_TOT' , l_wsp_fa_sum, g_wsp_benf_level);
550: update_dom('DISABILED_AFRICANS_TOT' , l_wsp_da_sum, g_wsp_benf_level);
551:
552: update_dom('MALE_COLOUREDS_TOT' , l_wsp_mc_sum, g_wsp_benf_level);

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

565: update_dom('FEMALE_TOTALS_TOT' , l_wsp_ft_sum, g_wsp_benf_level);
566: update_dom('DISABILED_TOTALS_TOT' , l_wsp_dt_sum, g_wsp_benf_level);
567:
568:
569: hr_utility.set_location('Leaving ' || l_proc, 10);
570: -- hr_utility.trace_off;
571: end update_wsp_data;
572: --
573:

Line 570: -- hr_utility.trace_off;

566: update_dom('DISABILED_TOTALS_TOT' , l_wsp_dt_sum, g_wsp_benf_level);
567:
568:
569: hr_utility.set_location('Leaving ' || l_proc, 10);
570: -- hr_utility.trace_off;
571: end update_wsp_data;
572: --
573:
574: /*--------------------------------------------------------------------------

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

714:
715: l_sk_pr_num varchar2(2000);
716:
717: begin
718: hr_utility.set_location ('Entering ' || l_proc, 10);
719:
720:
721: -- Create parent node for ATR data
722: update_dom('ATR', null, g_atr_level);

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

987: update_dom('MALE_TOTALS_TOT' , l_mt_sum, g_atr_benf_level);
988: update_dom('FEMALE_TOTALS_TOT' , l_ft_sum, g_atr_benf_level);
989: update_dom('DISABILED_TOTALS_TOT' , l_dt_sum, g_atr_benf_level);
990:
991: hr_utility.set_location('Leaving ' || l_proc, 10);
992:
993: end update_atr_data;
994: --
995:

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

1024: and action_information_category = 'ZA WSP EMPLOYER DETAILS'
1025: and action_context_type = 'PA';
1026:
1027: begin
1028: -- hr_utility.trace_on(null, 'WSP_GEN');
1029: hr_utility.set_location ('Entering ' || l_proc, 10);
1030:
1031: -- Initialize g_xml_dom and create root node
1032: g_xml_dom := xmldom.newDOMDocument;

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

1025: and action_context_type = 'PA';
1026:
1027: begin
1028: -- hr_utility.trace_on(null, 'WSP_GEN');
1029: hr_utility.set_location ('Entering ' || l_proc, 10);
1030:
1031: -- Initialize g_xml_dom and create root node
1032: g_xml_dom := xmldom.newDOMDocument;
1033: main_node := xmldom.makeNode(g_xml_dom);

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

1056: -- open the file p_xml
1057: -- Why ? In the Core wrapper package(PAY_XML_GEN_PKG) this is being closed
1058: dbms_lob.open(p_xml, dbms_lob.lob_readonly);
1059:
1060: hr_utility.set_location('Leaving ' || l_proc, 10);
1061:
1062: -- hr_utility.trace_off;
1063:
1064: end populate_xml_data;

Line 1062: -- hr_utility.trace_off;

1058: dbms_lob.open(p_xml, dbms_lob.lob_readonly);
1059:
1060: hr_utility.set_location('Leaving ' || l_proc, 10);
1061:
1062: -- hr_utility.trace_off;
1063:
1064: end populate_xml_data;
1065:
1066: end PER_ZA_WSP_XML_GEN_PKG;