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 84: hr_utility.set_location('chk_ass_set'||substr(sqlerrm,1,200),99);

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

Line 221: hr_utility.trace(lv_buf);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

718: --
719: vXMLTable.DELETE;
720: vCtr := 0;
721: --
722: --hr_utility.set_location('Entering : ' || c_proc, 10);
723: hr_utility.trace('isdf_xml');
724: --
725: l_xml_begin := ''||EOL||'' || EOL;
726: vXMLTable(vCtr).xmlstring := l_xml_begin;

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

719: vXMLTable.DELETE;
720: vCtr := 0;
721: --
722: --hr_utility.set_location('Entering : ' || c_proc, 10);
723: hr_utility.trace('isdf_xml');
724: --
725: l_xml_begin := ''||EOL||'' || EOL;
726: vXMLTable(vCtr).xmlstring := l_xml_begin;
727: vCtr := vCtr + 1;

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

965: CLOSE cur_isdf_social;
966: --
967: i := 0;
968: --
969: hr_utility.set_location('NO. OF PAGES :', no_of_pages);
970: --
971: WHILE i < no_of_pages
972: LOOP
973: --

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

976: c := 3 * i + 3;
977: d := 2 * i + 1;
978: e := 2 * i + 2;
979: --
980: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
981: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
982: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
983: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
984: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);

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

977: d := 2 * i + 1;
978: e := 2 * i + 2;
979: --
980: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
981: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
982: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
983: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
984: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
985: --

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

978: e := 2 * i + 2;
979: --
980: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
981: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
982: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
983: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
984: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
985: --
986: IF (i = 0) THEN

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

979: --
980: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
981: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
982: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
983: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
984: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
985: --
986: IF (i = 0) THEN
987: l_xml := ''||EOL||l_common_xml_page1||EOL;

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

980: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML A:', a);
981: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML B:', b);
982: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML C:', c);
983: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML D:', d);
984: hr_utility.set_location('value of VARIABLES IN ISDF COMP XML E:', e);
985: --
986: IF (i = 0) THEN
987: l_xml := ''||EOL||l_common_xml_page1||EOL;
988: ELSE

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

1328: length(vXMLTable(ctr_table).xmlstring),
1329: vXMLTable(ctr_table).xmlstring );
1330: END LOOP;
1331: p_write_xml := l_xfdf_string;
1332: hr_utility.set_location('Out of loop ', 99);
1333: dbms_lob.close(l_xfdf_string);
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

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

1332: hr_utility.set_location('Out of loop ', 99);
1333: dbms_lob.close(l_xfdf_string);
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1337: HR_UTILITY.RAISE_ERROR;
1338: END WritetoCLOB;
1339: --
1340: /****************************************************************************

Line 1337: HR_UTILITY.RAISE_ERROR;

1333: dbms_lob.close(l_xfdf_string);
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1337: HR_UTILITY.RAISE_ERROR;
1338: END WritetoCLOB;
1339: --
1340: /****************************************************************************
1341: Name : get_cp_xml

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

1401: BEGIN
1402: --
1403: IF g_debug THEN
1404: l_proc_name := g_proc_name || 'GENERATE_XML';
1405: hr_utility.trace ('Entering '||l_proc_name);
1406: END IF ;
1407: --
1408: l_cur_assact := pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID' );
1409: l_cur_pact := pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID' );

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

1436: l_offset := l_offset + l_amount ;
1437: END LOOP;
1438: EXCEPTION
1439: WHEN no_data_found THEN
1440: hr_utility.trace ('exiting from loop');
1441: --
1442: IF g_debug THEN
1443: hr_utility.trace ('Leaving '||l_proc_name);
1444: END IF ;

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

1439: WHEN no_data_found THEN
1440: hr_utility.trace ('exiting from loop');
1441: --
1442: IF g_debug THEN
1443: hr_utility.trace ('Leaving '||l_proc_name);
1444: END IF ;
1445: END generate_xml;
1446: --
1447: /****************************************************************************

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

1455: --
1456: BEGIN
1457: if g_debug then
1458: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1459: hr_utility.trace ('Entering '||l_proc_name);
1460: end if ;
1461: --
1462: vXMLTable.DELETE; -- delete the pl/sql table
1463: --

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

1466: --
1467: pay_core_files.write_to_magtape_lob(l_buf);
1468: --
1469: if g_debug then
1470: hr_utility.trace ('CLOB contents after appending header information');
1471: hr_utility.trace ('Leaving '||l_proc_name);
1472: end if ;
1473: END gen_xml_header;
1474: --

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

1467: pay_core_files.write_to_magtape_lob(l_buf);
1468: --
1469: if g_debug then
1470: hr_utility.trace ('CLOB contents after appending header information');
1471: hr_utility.trace ('Leaving '||l_proc_name);
1472: end if ;
1473: END gen_xml_header;
1474: --
1475: /****************************************************************************

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

1482: BEGIN
1483: --
1484: if g_debug then
1485: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
1486: hr_utility.trace ('Entering '||l_proc_name);
1487: end if ;
1488: l_buf := '' ;
1489: --
1490: pay_core_files.write_to_magtape_lob(l_buf);

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

1489: --
1490: pay_core_files.write_to_magtape_lob(l_buf);
1491: --
1492: if g_debug then
1493: hr_utility.trace ('CLOB contents after appending footer information');
1494: hr_utility.trace ('Leaving '||l_proc_name);
1495: end if ;
1496: --
1497: END gen_xml_footer;

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

1490: pay_core_files.write_to_magtape_lob(l_buf);
1491: --
1492: if g_debug then
1493: hr_utility.trace ('CLOB contents after appending footer information');
1494: hr_utility.trace ('Leaving '||l_proc_name);
1495: end if ;
1496: --
1497: END gen_xml_footer;
1498: --