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

Line 85: hr_utility.set_location('chk_ass_set'||substr(sqlerrm,1,200),99);

81: RETURN l_result;
82: --
83: EXCEPTION
84: WHEN OTHERS THEN
85: hr_utility.set_location('chk_ass_set'||substr(sqlerrm,1,200),99);
86: RETURN FALSE;
87: END chk_ass_set;
88: --
89: /****************************************************************************

Line 222: hr_utility.trace(lv_buf);

218: ln_chars,
219: ln_offset,
220: lv_buf
221: );
222: hr_utility.trace(lv_buf);
223: ln_offset := ln_offset + ln_chars;
224: END LOOP;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN

Line 227: hr_utility.trace ('CLOB contents end.');

223: ln_offset := ln_offset + ln_chars;
224: END LOOP;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: hr_utility.trace ('CLOB contents end.');
228: END PRINT_CLOB;
229: --
230: /****************************************************************************
231: Name : range_cursor

Line 247: hr_utility.trace ('Entering '||l_proc_name);

243: ) AS
244: l_proc_name varchar2(100);
245: BEGIN
246: l_proc_name := g_proc_name || 'RANGE_CURSOR';
247: hr_utility.trace ('Entering '||l_proc_name);
248: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
249: p_sqlstr := ' select distinct p.person_id'||
250: ' from per_people_f p,'||
251: ' pay_payroll_actions pa'||

Line 248: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

244: l_proc_name varchar2(100);
245: BEGIN
246: l_proc_name := g_proc_name || 'RANGE_CURSOR';
247: hr_utility.trace ('Entering '||l_proc_name);
248: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
249: p_sqlstr := ' select distinct p.person_id'||
250: ' from per_people_f p,'||
251: ' pay_payroll_actions pa'||
252: ' where pa.payroll_action_id = :payroll_action_id'||

Line 255: hr_utility.trace ('Range cursor query : ' || p_sqlstr);

251: ' pay_payroll_actions pa'||
252: ' where pa.payroll_action_id = :payroll_action_id'||
253: ' and p.business_group_id = pa.business_group_id'||
254: ' order by p.person_id ';
255: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
256: hr_utility.trace ('Leaving '||l_proc_name);
257: END range_cursor;
258: --
259: /****************************************************************************

Line 256: hr_utility.trace ('Leaving '||l_proc_name);

252: ' where pa.payroll_action_id = :payroll_action_id'||
253: ' and p.business_group_id = pa.business_group_id'||
254: ' order by p.person_id ';
255: hr_utility.trace ('Range cursor query : ' || p_sqlstr);
256: hr_utility.trace ('Leaving '||l_proc_name);
257: END range_cursor;
258: --
259: /****************************************************************************
260: Name : action_creation

Line 320: hr_utility.trace ('Entering '||l_proc_name);

316: l_prn_app_opt:= pay_core_utils.get_parameter('PUBLISH_CRITERION',l_legislative_parameters); --Bug Fix:5487428
317: --
318: IF g_debug THEN
319: l_proc_name := g_proc_name || 'ACTION_CREATION';
320: hr_utility.trace ('Entering '||l_proc_name);
321: hr_utility.trace ('Parameters ....');
322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

Line 321: hr_utility.trace ('Parameters ....');

317: --
318: IF g_debug THEN
319: l_proc_name := g_proc_name || 'ACTION_CREATION';
320: hr_utility.trace ('Entering '||l_proc_name);
321: hr_utility.trace ('Parameters ....');
322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);

Line 322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);

318: IF g_debug THEN
319: l_proc_name := g_proc_name || 'ACTION_CREATION';
320: hr_utility.trace ('Entering '||l_proc_name);
321: hr_utility.trace ('Parameters ....');
322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);

Line 323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);

319: l_proc_name := g_proc_name || 'ACTION_CREATION';
320: hr_utility.trace ('Entering '||l_proc_name);
321: hr_utility.trace ('Parameters ....');
322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);

Line 324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

320: hr_utility.trace ('Entering '||l_proc_name);
321: hr_utility.trace ('Parameters ....');
322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);
328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);

Line 325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);

321: hr_utility.trace ('Parameters ....');
322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);
328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);
329: hr_utility.trace ('PUBLISH_CRITERION = '||l_prn_app_opt);

Line 326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);

322: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);
328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);
329: hr_utility.trace ('PUBLISH_CRITERION = '||l_prn_app_opt);
330: END IF;

Line 327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);

323: hr_utility.trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);
328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);
329: hr_utility.trace ('PUBLISH_CRITERION = '||l_prn_app_opt);
330: END IF;
331: --

Line 328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);

324: hr_utility.trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);
328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);
329: hr_utility.trace ('PUBLISH_CRITERION = '||l_prn_app_opt);
330: END IF;
331: --
332: if g_bg_id is null then

Line 329: hr_utility.trace ('PUBLISH_CRITERION = '||l_prn_app_opt);

325: hr_utility.trace ('P_CHUNK = '|| P_CHUNK);
326: hr_utility.trace ('P_OLD_PAYROLL_ACTION-ID = '||l_old_pact_id);
327: hr_utility.trace ('P_ASS_SET_ID = '||l_ass_set_id);
328: hr_utility.trace ('PRN_EMP_NO = '||l_emp_no_opt);
329: hr_utility.trace ('PUBLISH_CRITERION = '||l_prn_app_opt);
330: END IF;
331: --
332: if g_bg_id is null then
333: Select p.business_group_id into g_bg_id

Line 414: hr_utility.trace ('inside INIT_CODE ');

410: Description : None
411: *****************************************************************************/
412: PROCEDURE INIT_CODE ( P_PAYROLL_ACTION_ID IN NUMBER) IS
413: BEGIN
414: hr_utility.trace ('inside INIT_CODE ');
415: NULL;
416: END;
417: --
418: /****************************************************************************

Line 425: hr_utility.trace ('inside ARCHIVE_CODE ');

421: *****************************************************************************/
422: PROCEDURE ARCHIVE_CODE ( P_ASSIGNMENT_ACTION_ID IN NUMBER,
423: P_EFFECTIVE_DATE IN DATE ) IS
424: BEGIN
425: hr_utility.trace ('inside ARCHIVE_CODE ');
426: NULL;
427: END ;
428: --
429: /****************************************************************************

Line 806: --hr_utility.set_location('Entering : ' || c_proc, 10);

802: --
803: vXMLTable.DELETE;
804: vCtr := 0;
805: --
806: --hr_utility.set_location('Entering : ' || c_proc, 10);
807: hr_utility.trace('isdf_xml');
808: --
809: l_xml_begin := ''||EOL||'' || EOL;
810: vXMLTable(vCtr).xmlstring := l_xml_begin;

Line 807: hr_utility.trace('isdf_xml');

803: vXMLTable.DELETE;
804: vCtr := 0;
805: --
806: --hr_utility.set_location('Entering : ' || c_proc, 10);
807: hr_utility.trace('isdf_xml');
808: --
809: l_xml_begin := ''||EOL||'' || EOL;
810: vXMLTable(vCtr).xmlstring := l_xml_begin;
811: vCtr := vCtr + 1;

Line 1155: hr_utility.set_location('NO. OF PAGES :', no_of_pages);

1151: CLOSE cur_isdf_social;
1152: --
1153: i := 0;
1154: --
1155: hr_utility.set_location('NO. OF PAGES :', no_of_pages);
1156: --
1157: WHILE i < no_of_pages
1158: LOOP
1159: --

Line 1179: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);

1175: e := 2 * i + 2;
1176:
1177: END IF;
1178: --
1179: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);

Line 1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);

1176:
1177: END IF;
1178: --
1179: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);

Line 1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);

1177: END IF;
1178: --
1179: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);

Line 1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);

1178: --
1179: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);

Line 1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);

1179: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);
1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);

Line 1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);

1180: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);
1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);
1188: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML j:', j);

Line 1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);

1181: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);
1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);
1188: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML j:', j);
1189:

Line 1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);

1182: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);
1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);
1188: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML j:', j);
1189:
1190: --

Line 1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);

1183: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);
1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);
1188: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML j:', j);
1189:
1190: --
1191: IF (i = 0) THEN

Line 1188: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML j:', j);

1184: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML f:', f);
1185: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML g:', g);
1186: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML h:', h);
1187: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML i:', i);
1188: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML j:', j);
1189:
1190: --
1191: IF (i = 0) THEN
1192: l_xml := ''||EOL||l_common_xml_page1||EOL;

Line 1237: -- hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', to_char(class_new_old_lg(a)));

1233: --
1234: l_t131b := g_msg_circle;
1235: --
1236: end if;
1237: -- hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', to_char(class_new_old_lg(a)));
1238: l_xml := ''||htmlspchar(cnv_str(ins_company_name_lg(a))) ||''||EOL; --ins_company_name_lg1
1239: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_lg(a))) ||''||EOL; --ins_type_lg1
1240: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lg(a))) ||''||EOL; --ins_period_lg1
1241: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lg(a))) ||''||EOL; --contractor_name_lg1

Line 1862: hr_utility.set_location('Out of loop ', 99);

1858: length(vXMLTable(ctr_table).xmlstring),
1859: vXMLTable(ctr_table).xmlstring );
1860: END LOOP;
1861: p_write_xml := l_xfdf_string;
1862: hr_utility.set_location('Out of loop ', 99);
1863: dbms_lob.close(l_xfdf_string);
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

Line 1866: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1862: hr_utility.set_location('Out of loop ', 99);
1863: dbms_lob.close(l_xfdf_string);
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1867: HR_UTILITY.RAISE_ERROR;
1868: END WritetoCLOB;
1869: --
1870: /****************************************************************************

Line 1867: HR_UTILITY.RAISE_ERROR;

1863: dbms_lob.close(l_xfdf_string);
1864: EXCEPTION
1865: WHEN OTHERS THEN
1866: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1867: HR_UTILITY.RAISE_ERROR;
1868: END WritetoCLOB;
1869: --
1870: /****************************************************************************
1871: Name : get_cp_xml

Line 1935: hr_utility.trace ('Entering '||l_proc_name);

1931: BEGIN
1932: --
1933: IF g_debug THEN
1934: l_proc_name := g_proc_name || 'GENERATE_XML';
1935: hr_utility.trace ('Entering '||l_proc_name);
1936: END IF ;
1937: --
1938: l_cur_assact := pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID' );
1939: l_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );

Line 1970: hr_utility.trace ('exiting from loop');

1966: l_offset := l_offset + l_amount ;
1967: END LOOP;
1968: EXCEPTION
1969: WHEN no_data_found THEN
1970: hr_utility.trace ('exiting from loop');
1971: --
1972: IF g_debug THEN
1973: hr_utility.trace ('Leaving '||l_proc_name);
1974: END IF ;

Line 1973: hr_utility.trace ('Leaving '||l_proc_name);

1969: WHEN no_data_found THEN
1970: hr_utility.trace ('exiting from loop');
1971: --
1972: IF g_debug THEN
1973: hr_utility.trace ('Leaving '||l_proc_name);
1974: END IF ;
1975: END generate_xml;
1976: --
1977: /****************************************************************************

Line 1989: hr_utility.trace ('Entering '||l_proc_name);

1985: --
1986: BEGIN
1987: if g_debug then
1988: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1989: hr_utility.trace ('Entering '||l_proc_name);
1990: end if ;
1991: --
1992: vXMLTable.DELETE; -- delete the pl/sql table
1993: --

Line 2000: hr_utility.trace ('CLOB contents after appending header information');

1996: --
1997: pay_core_files.write_to_magtape_lob(l_buf);
1998: --
1999: if g_debug then
2000: hr_utility.trace ('CLOB contents after appending header information');
2001: hr_utility.trace ('Leaving '||l_proc_name);
2002: end if ;
2003: END gen_xml_header;
2004: --

Line 2001: hr_utility.trace ('Leaving '||l_proc_name);

1997: pay_core_files.write_to_magtape_lob(l_buf);
1998: --
1999: if g_debug then
2000: hr_utility.trace ('CLOB contents after appending header information');
2001: hr_utility.trace ('Leaving '||l_proc_name);
2002: end if ;
2003: END gen_xml_header;
2004: --
2005: /****************************************************************************

Line 2016: hr_utility.trace ('Entering '||l_proc_name);

2012: BEGIN
2013: --
2014: if g_debug then
2015: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
2016: hr_utility.trace ('Entering '||l_proc_name);
2017: end if ;
2018: l_buf := '' ;
2019: --
2020: pay_core_files.write_to_magtape_lob(l_buf);

Line 2023: hr_utility.trace ('CLOB contents after appending footer information');

2019: --
2020: pay_core_files.write_to_magtape_lob(l_buf);
2021: --
2022: if g_debug then
2023: hr_utility.trace ('CLOB contents after appending footer information');
2024: hr_utility.trace ('Leaving '||l_proc_name);
2025: end if ;
2026: --
2027: END gen_xml_footer;

Line 2024: hr_utility.trace ('Leaving '||l_proc_name);

2020: pay_core_files.write_to_magtape_lob(l_buf);
2021: --
2022: if g_debug then
2023: hr_utility.trace ('CLOB contents after appending footer information');
2024: hr_utility.trace ('Leaving '||l_proc_name);
2025: end if ;
2026: --
2027: END gen_xml_footer;
2028: --