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.HR_DU_UTILITY dependencies on HR_DU_UTILITY

Line 1: PACKAGE BODY hr_du_utility AS

1: PACKAGE BODY hr_du_utility AS
2: /* $Header: perdutil.pkb 115.6 2002/11/28 17:05:05 apholt noship $ */
3:
4: /*--------------------------- GLOBAL VARIABLES ----------------------------*/
5:

Line 58: error(SQLCODE,'hr_du_utility.local_chr','(none)','R');

54:
55: -- error handling
56: EXCEPTION
57: WHEN OTHERS THEN
58: error(SQLCODE,'hr_du_utility.local_chr','(none)','R');
59: RAISE;
60:
61: --
62: END local_chr;

Line 113: error(SQLCODE,'hr_du_utility.dynamic_sql','(none)','R');

109:
110: -- error handling
111: EXCEPTION
112: WHEN OTHERS THEN
113: error(SQLCODE,'hr_du_utility.dynamic_sql','(none)','R');
114: RAISE;
115:
116: --
117: END dynamic_sql;

Line 183: error(SQLCODE,'hr_du_utility.dynamic_sql_num','(none)','R');

179:
180: -- error handling
181: EXCEPTION
182: WHEN OTHERS THEN
183: error(SQLCODE,'hr_du_utility.dynamic_sql_num','(none)','R');
184: RAISE;
185:
186: --
187: END dynamic_sql_num;

Line 275: error(SQLCODE,'hr_du_utility.dynamic_sql_num_user_key',' Unable to fine ID '

271: FETCH csr_module_name INTO l_api_module_name;
272: --
273: CLOSE csr_module_name;
274: --
275: error(SQLCODE,'hr_du_utility.dynamic_sql_num_user_key',' Unable to fine ID '
276: || p_column_id || ' in API ' || l_api_module_name || '. Referencing '
277: || 'column in other file has this invalid reference. ' ,'R');
278: RAISE;
279:

Line 349: error(SQLCODE,'hr_du_utility.dynamic_sql_str','(none)','R');

345:
346: -- error handling
347: EXCEPTION
348: WHEN OTHERS THEN
349: error(SQLCODE,'hr_du_utility.dynamic_sql_str','(none)','R');
350: RAISE;
351:
352: --
353: END dynamic_sql_str;

Line 372: message('ROUT','entry:hr_du_utility.error', 5);

368: --
369: BEGIN
370: --
371:
372: message('ROUT','entry:hr_du_utility.error', 5);
373: message('PARA','(p_sqlcode - ' || p_sqlcode ||
374: ')(p_procedure - ' || p_procedure || ')', 10);
375:
376: message('FAIL',p_sqlcode || ':' || SQLERRM(p_sqlcode) || ':'

Line 388: message('ROUT','exit:hr_du_utility.error', 30);

384: END IF;
385:
386: message('INFO','Error Handler - ' || p_procedure, 20);
387: message('SUMM','Error Handler - ' || p_procedure, 25);
388: message('ROUT','exit:hr_du_utility.error', 30);
389: message('PARA','(none)', 35);
390:
391: -- error handling
392: EXCEPTION

Line 394: error(SQLCODE,'hr_du_utility.error','(none)','R');

390:
391: -- error handling
392: EXCEPTION
393: WHEN OTHERS THEN
394: error(SQLCODE,'hr_du_utility.error','(none)','R');
395: RAISE;
396:
397:
398: --

Line 445: error(SQLCODE,'hr_du_utility.message_init','(none)','R');

441:
442: -- error handling
443: EXCEPTION
444: WHEN OTHERS THEN
445: error(SQLCODE,'hr_du_utility.message_init','(none)','R');
446: RAISE;
447:
448: --
449: END message_init;

Line 524: error(SQLCODE,'hr_du_utility.message','(none)','R');

520:
521: -- error handling
522: EXCEPTION
523: WHEN OTHERS THEN
524: error(SQLCODE,'hr_du_utility.message','(none)','R');
525: RAISE;
526:
527: --
528: END message;

Line 565: message('ROUT','entry:hr_du_utility.get_uploads_status', 5);

561: --
562: BEGIN
563: --
564:
565: message('ROUT','entry:hr_du_utility.get_uploads_status', 5);
566: message('PARA','(p_upload_id - ' || p_upload_id || ')', 10);
567:
568: OPEN csr_status;
569: LOOP

Line 581: message('ROUT','exit:hr_du_utility.get_phase_status', 25);

577:
578:
579: message('INFO','Find Phase Status', 15);
580: message('SUMM','Find Phase Status', 20);
581: message('ROUT','exit:hr_du_utility.get_phase_status', 25);
582: message('PARA','(l_phase_status - ' || l_phase_status || ')', 30);
583:
584: RETURN(l_phase_status);
585:

Line 589: error(SQLCODE,'hr_du_utility.get_uploads_status','(none)','R');

585:
586: -- error handling
587: EXCEPTION
588: WHEN OTHERS THEN
589: error(SQLCODE,'hr_du_utility.get_uploads_status','(none)','R');
590: RAISE;
591:
592: --
593: END get_uploads_status;

Line 632: message('ROUT','entry:hr_du_utility.get_upload_headers_status', 5);

628: --
629: BEGIN
630: --
631:
632: message('ROUT','entry:hr_du_utility.get_upload_headers_status', 5);
633: message('PARA','(p_upload_header_id - ' || p_upload_header_id || ')', 10);
634:
635: OPEN csr_status;
636: LOOP

Line 648: message('ROUT','exit:hr_du_utility.get_upload_headers_status', 25);

644:
645:
646: message('INFO','Find Phase Status', 15);
647: message('SUMM','Find Phase Status', 20);
648: message('ROUT','exit:hr_du_utility.get_upload_headers_status', 25);
649: message('PARA','(l_phase_status - ' || l_phase_status || ')', 30);
650:
651: RETURN(l_phase_status);
652:

Line 656: error(SQLCODE,'hr_du_utility.get_upload_headers_status','(none)','R');

652:
653: -- error handling
654: EXCEPTION
655: WHEN OTHERS THEN
656: error(SQLCODE,'hr_du_utility.get_upload_headers_status','(none)','R');
657: RAISE;
658:
659: --
660: END get_upload_headers_status;

Line 695: message('ROUT','entry:hr_du_utility.get_upload_lines_status', 5);

691: --
692: BEGIN
693: --
694:
695: message('ROUT','entry:hr_du_utility.get_upload_lines_status', 5);
696: message('PARA','(p_upload_lines_id - ' || p_upload_lines_id || ')', 10);
697:
698: OPEN csr_status;
699: LOOP

Line 711: message('ROUT','exit:hr_du_utility.get_upload_lines_status', 25);

707:
708:
709: message('INFO','Find Phase Status', 15);
710: message('SUMM','Find Phase Status', 20);
711: message('ROUT','exit:hr_du_utility.get_upload_lines_status', 25);
712: message('PARA','(l_phase_status - ' || l_phase_status || ')', 30);
713:
714: RETURN(l_phase_status);
715:

Line 719: error(SQLCODE,'hr_du_utility.get_upload_lines_status','(none)','R');

715:
716: -- error handling
717: EXCEPTION
718: WHEN OTHERS THEN
719: error(SQLCODE,'hr_du_utility.get_upload_lines_status','(none)','R');
720: RAISE;
721:
722: --
723: END get_upload_lines_status;

Line 763: message('ROUT','entry:hr_du_utility.update_uploads', 5);

759:
760: --
761: BEGIN
762: --
763: message('ROUT','entry:hr_du_utility.update_uploads', 5);
764: message('PARA','(p_new_status - ' || p_new_status ||
765: ')(p_id - ' || p_id || ')', 10);
766:
767: -- non-complete

Line 796: message('ROUT','exit:hr_du_utility.update_uploads', 25);

792: END IF;
793:
794: message('INFO','Update status - update_uploads', 15);
795: message('SUMM','Update status - update_uploads', 20);
796: message('ROUT','exit:hr_du_utility.update_uploads', 25);
797: message('PARA','(none)', 30);
798:
799: -- error handling
800: EXCEPTION

Line 802: error(SQLCODE,'hr_du_utility.update_uploads','(none)','R');

798:
799: -- error handling
800: EXCEPTION
801: WHEN OTHERS THEN
802: error(SQLCODE,'hr_du_utility.update_uploads','(none)','R');
803: RAISE;
804:
805: --
806: END update_uploads;

Line 845: message('ROUT','entry:hr_du_utility.update_upload_lines', 5);

841: --
842: BEGIN
843: --
844:
845: message('ROUT','entry:hr_du_utility.update_upload_lines', 5);
846: message('PARA','(p_new_status - ' || p_new_status ||
847: ')(p_id - ' || p_id || ')', 10);
848:
849: -- update the status for this row

Line 865: message('ROUT','exit:hr_du_utility.update_upload_lines', 25);

861: END IF;
862:
863: message('INFO','Update status - update_upload_lines', 15);
864: message('SUMM','Update status - update_upload_lines', 20);
865: message('ROUT','exit:hr_du_utility.update_upload_lines', 25);
866: message('PARA','(none)', 30);
867:
868: -- error handling
869: EXCEPTION

Line 871: error(SQLCODE,'hr_du_utility.update_upload_lines','(none)','R');

867:
868: -- error handling
869: EXCEPTION
870: WHEN OTHERS THEN
871: error(SQLCODE,'hr_du_utility.update_upload_lines','(none)','R');
872: RAISE;
873:
874: --
875: END update_upload_lines;

Line 924: message('ROUT','entry:hr_du_utility.update_upload_headers', 5);

920: --
921: BEGIN
922: --
923:
924: message('ROUT','entry:hr_du_utility.update_upload_headers', 5);
925: message('PARA','(p_new_status - ' || p_new_status ||
926: ')(p_id - ' || p_id || ')', 10);
927:
928: l_new_status := p_new_status;

Line 1047: hr_du_utility.error(SQLCODE, 'hr_du_utility.return_spreadsheet_row','(none)', 'R');

1043:
1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: hr_du_utility.error(SQLCODE, 'hr_du_utility.return_spreadsheet_row','(none)', 'R');
1048: RAISE;
1049: --
1050:
1051: END Return_Spreadsheet_row;

Line 1076: message('ROUT','entry:hr_du_utility.chunk_size', 5);

1072:
1073: --
1074: BEGIN
1075: --
1076: message('ROUT','entry:hr_du_utility.chunk_size', 5);
1077:
1078: OPEN csr_chunk_size;
1079: FETCH csr_chunk_size INTO l_chunk_size;
1080: IF csr_chunk_size%NOTFOUND THEN

Line 1095: error(SQLCODE,'hr_du_utility.chunk_size','(none)','R');

1091:
1092: -- error handling
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: error(SQLCODE,'hr_du_utility.chunk_size','(none)','R');
1096: RAISE;
1097:
1098: --
1099: END CHUNK_SIZE;

Line 1101: end hr_du_utility;

1097:
1098: --
1099: END CHUNK_SIZE;
1100:
1101: end hr_du_utility;