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_RETRO_SETUP_REPORT dependencies on PAY_NL_RETRO_SETUP_REPORT

Line 1: PACKAGE BODY pay_nl_retro_setup_report AS

1: PACKAGE BODY pay_nl_retro_setup_report AS
2: /* $Header: pynlersr.pkb 120.1 2008/02/19 11:57:33 abhgangu noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- get_IANA_charset

Line 160: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : Parameters',100);

156:
157: BEGIN
158:
159: --hr_utility.trace_on(NULL,'ERSR');
160: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : Parameters',100);
161: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_eff_date'||p_eff_date,140);
162: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_ele_records'||p_ele_records,160);
163: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_business_group_id'||p_business_group_id,180);
164:

Line 161: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_eff_date'||p_eff_date,140);

157: BEGIN
158:
159: --hr_utility.trace_on(NULL,'ERSR');
160: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : Parameters',100);
161: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_eff_date'||p_eff_date,140);
162: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_ele_records'||p_ele_records,160);
163: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_business_group_id'||p_business_group_id,180);
164:
165:

Line 162: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_ele_records'||p_ele_records,160);

158:
159: --hr_utility.trace_on(NULL,'ERSR');
160: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : Parameters',100);
161: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_eff_date'||p_eff_date,140);
162: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_ele_records'||p_ele_records,160);
163: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_business_group_id'||p_business_group_id,180);
164:
165:
166: l_effec_date := fnd_date.canonical_to_date(p_eff_date);

Line 163: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_business_group_id'||p_business_group_id,180);

159: --hr_utility.trace_on(NULL,'ERSR');
160: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : Parameters',100);
161: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_eff_date'||p_eff_date,140);
162: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_ele_records'||p_ele_records,160);
163: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : p_business_group_id'||p_business_group_id,180);
164:
165:
166: l_effec_date := fnd_date.canonical_to_date(p_eff_date);
167:

Line 185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);

181: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_RECORDS';
182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);
183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);
186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);
187: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records),640);
188:
189: -- Setting PL/SQL table for tags and values of the xml data for all the element records

Line 186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);

182: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records);
183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);
186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);
187: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records),640);
188:
189: -- Setting PL/SQL table for tags and values of the xml data for all the element records
190:

Line 187: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records),640);

183: vCtr := vCtr + 1;
184:
185: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||to_char(l_effec_date),600);
186: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||l_bg_name.name,620);
187: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||hr_general.decode_lookup('HR_NL_ESR_ELE_REC',p_ele_records),640);
188:
189: -- Setting PL/SQL table for tags and values of the xml data for all the element records
190:
191: FOR v_get_ele_class IN csr_get_ele_class(p_business_group_id,p_ele_records)

Line 202: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',660);

198: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'ELE_CLASS';
199: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_class.classification_name ;
200: vCtr := vCtr + 1;
201:
202: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',660);
203: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_class.classification_name,'NULL'),680);
204: FOR v_get_element_record
205: IN csr_get_element_record(p_business_group_id,l_effec_date,v_get_ele_class.classification_id)
206: LOOP

Line 203: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_class.classification_name,'NULL'),680);

199: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := v_get_ele_class.classification_name ;
200: vCtr := vCtr + 1;
201:
202: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',660);
203: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_class.classification_name,'NULL'),680);
204: FOR v_get_element_record
205: IN csr_get_element_record(p_business_group_id,l_effec_date,v_get_ele_class.classification_id)
206: LOOP
207: -- Donot repeat the element name if same.

Line 275: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',700);

271: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
273: vCtr := vCtr + 1;
274:
275: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',700);
276: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_element_record.element_name,'NULL'),720);
277:
278: END LOOP;
279:

Line 276: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_element_record.element_name,'NULL'),720);

272: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
273: vCtr := vCtr + 1;
274:
275: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',700);
276: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_element_record.element_name,'NULL'),720);
277:
278: END LOOP;
279:
280: IF p_ele_records = 'A' THEN

Line 296: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',740);

292: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_ELEMENT';
293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
294: vCtr := vCtr + 1;
295:
296: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',740);
297: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_without_ret.element_name,'NULL'),760);
298: END LOOP;
299: END IF;
300:

Line 297: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_without_ret.element_name,'NULL'),760);

293: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagValue := 'END';
294: vCtr := vCtr + 1;
295:
296: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : ',740);
297: hr_utility.set_location('Inside pay_nl_retro_setup_report.generate : '||NVL(v_get_ele_without_ret.element_name,'NULL'),760);
298: END LOOP;
299: END IF;
300:
301: PAY_NL_XDO_REPORT.vXMLTable(vCtr).TagName := 'G_CONTAINER_CLASS';

Line 392: END pay_nl_retro_setup_report;

388: HR_UTILITY.RAISE_ERROR;
389:
390: END generate;
391:
392: END pay_nl_retro_setup_report;