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

Line 202: hr_utility.set_location('p_asg_sct_id-'||to_char(p_asg_act_id)||' p_element_type_id-'||to_char(p_element_type_id)||' p_retro_date-'||to_char(p_retro_date,'DD-MON-RRRR'),999);

198: v_csr_get_retro_wts csr_get_retro_wts%ROWTYPE;
199:
200: BEGIN
201:
202: hr_utility.set_location('p_asg_sct_id-'||to_char(p_asg_act_id)||' p_element_type_id-'||to_char(p_element_type_id)||' p_retro_date-'||to_char(p_retro_date,'DD-MON-RRRR'),999);
203:
204: FOR v_csr_get_retro_wts IN csr_get_retro_wts(p_asg_act_id, p_element_type_id, p_retro_date)
205: LOOP
206:

Line 527: --hr_utility.trace_on(null,'WTS_bug');

523: execute immediate ('alter session set nls_numeric_characters =''.,''');
524: END IF;
525: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
526: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
527: --hr_utility.trace_on(null,'WTS_bug');
528: hr_utility.set_location('Inside populate_wts_report_data',2000);
529:
530: OPEN csr_get_bg_name(p_bg_id);
531: FETCH csr_get_bg_name INTO l_bg_name;

Line 528: hr_utility.set_location('Inside populate_wts_report_data',2000);

524: END IF;
525: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
526: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
527: --hr_utility.trace_on(null,'WTS_bug');
528: hr_utility.set_location('Inside populate_wts_report_data',2000);
529:
530: OPEN csr_get_bg_name(p_bg_id);
531: FETCH csr_get_bg_name INTO l_bg_name;
532: CLOSE csr_get_bg_name;

Line 533: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);

529:
530: OPEN csr_get_bg_name(p_bg_id);
531: FETCH csr_get_bg_name INTO l_bg_name;
532: CLOSE csr_get_bg_name;
533: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
534:
535: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
536: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
537: vCtr := vCtr + 1;

Line 575: hr_utility.set_location('Inside populate_wts_report_data: Each Record: Employer: '||v_csr_get_record_details.employer_name,2050);

571: l_emp_total_subsidy := 0;
572:
573: FOR v_csr_get_record_details IN csr_get_record_details
574: LOOP
575: hr_utility.set_location('Inside populate_wts_report_data: Each Record: Employer: '||v_csr_get_record_details.employer_name,2050);
576: IF ((NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
577: AND l_payroll_id IS NOT NULL )
578: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
579: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN

Line 789: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);

785: vCtr := vCtr + 1;
786: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
787: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
788:
789: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
790: vCtr := vCtr + 1;
791: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
792: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
793: END IF;

Line 807: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);

803: vCtr := vCtr + 1;
804: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
805: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
806:
807: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
808: pay_nl_xdo_Report.WritetoCLOB_rtf(p_xfdf_blob );
809:
810: END populate_wts_report_data;
811:

Line 1142: --hr_utility.trace_on(null,'WTS_bug');

1138: execute immediate ('alter session set nls_numeric_characters =''.,''');
1139: END IF;
1140: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
1141: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
1142: --hr_utility.trace_on(null,'WTS_bug');
1143: hr_utility.set_location('Inside populate_wts_report_data',2000);
1144:
1145: OPEN csr_get_bg_name(p_bg_id);
1146: FETCH csr_get_bg_name INTO l_bg_name;

Line 1143: hr_utility.set_location('Inside populate_wts_report_data',2000);

1139: END IF;
1140: l_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
1141: execute immediate 'alter session set nls_date_format = ''' ||l_format ||'''';
1142: --hr_utility.trace_on(null,'WTS_bug');
1143: hr_utility.set_location('Inside populate_wts_report_data',2000);
1144:
1145: OPEN csr_get_bg_name(p_bg_id);
1146: FETCH csr_get_bg_name INTO l_bg_name;
1147: CLOSE csr_get_bg_name;

Line 1148: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);

1144:
1145: OPEN csr_get_bg_name(p_bg_id);
1146: FETCH csr_get_bg_name INTO l_bg_name;
1147: CLOSE csr_get_bg_name;
1148: hr_utility.set_location('Inside populate_wts_report_data: l_bg_name'||l_bg_name,2040);
1149:
1150: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'BG_NAME';
1151: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := l_bg_name;
1152: vCtr := vCtr + 1;

Line 1190: hr_utility.set_location('Inside populate_wts_report_data: Each Record: Employer: '||v_csr_get_record_details.employer_name,2050);

1186: l_emp_total_subsidy := 0;
1187:
1188: FOR v_csr_get_record_details IN csr_get_record_details
1189: LOOP
1190: hr_utility.set_location('Inside populate_wts_report_data: Each Record: Employer: '||v_csr_get_record_details.employer_name,2050);
1191: IF ((NVL(l_payroll_id,-1) <> v_csr_get_record_details.payroll_id
1192: AND l_payroll_id IS NOT NULL )
1193: OR (NVL(l_person_id,-1)<> v_csr_get_record_details.person_id
1194: AND l_person_id IS NOT NULL)) AND l_flag = FALSE THEN

Line 1405: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);

1401: vCtr := vCtr + 1;
1402: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYEE';
1403: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1404:
1405: hr_utility.set_location('Outside populate_wts_report_data: Employer Loop',2100);
1406: vCtr := vCtr + 1;
1407: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_EMPLOYER';
1408: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
1409: END IF;

Line 1423: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);

1419: vCtr := vCtr + 1;
1420: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'REP_TOT_PARENTAL';
1421: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := TO_CHAR(ROUND(l_rp_tot_ppl_subsidy,2),'99G999G999G999D90MI');
1422:
1423: hr_utility.set_location('Outside populate_wts_report_data: WritetoCLOB_rtf',2150);
1424: pay_nl_xdo_Report.WritetoCLOB_rtf_1(p_xml);
1425:
1426: END populate_wts_report_data_1;
1427: