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_RULES dependencies on HR_DU_RULES

Line 1: PACKAGE BODY HR_DU_RULES AS

1: PACKAGE BODY HR_DU_RULES AS
2: /* $Header: perdurul.pkb 120.0 2005/05/31 17:22:43 appldev noship $ */
3:
4:
5: -- ------------------------- API_PRESENT_AND_CORRECT -----------------------

Line 43: hr_du_utility.message('ROUT','entry:hr_du_rules.api_present_and_correct', 5);

39:
40:
41: BEGIN
42: --
43: hr_du_utility.message('ROUT','entry:hr_du_rules.api_present_and_correct', 5);
44: hr_du_utility.message('PARA', '(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
45: --
46:
47: OPEN csr_api_name;

Line 77: hr_du_utility.message('ROUT','exit:hr_du_rules.api_present_and_correct', 15);

73: END IF;
74: CLOSE csr_api_name;
75:
76: --
77: hr_du_utility.message('ROUT','exit:hr_du_rules.api_present_and_correct', 15);
78: --
79:
80: EXCEPTION
81: WHEN e_fatal_error THEN

Line 82: hr_du_utility.error(SQLCODE, 'hr_du_rules.api_present_and_correct',

78: --
79:
80: EXCEPTION
81: WHEN e_fatal_error THEN
82: hr_du_utility.error(SQLCODE, 'hr_du_rules.api_present_and_correct',
83: l_fatal_error_message, 'R');
84: RAISE;
85: WHEN OTHERS THEN
86: hr_du_utility.error(SQLCODE, 'hr_du_rules.api_present_and_correct',

Line 86: hr_du_utility.error(SQLCODE, 'hr_du_rules.api_present_and_correct',

82: hr_du_utility.error(SQLCODE, 'hr_du_rules.api_present_and_correct',
83: l_fatal_error_message, 'R');
84: RAISE;
85: WHEN OTHERS THEN
86: hr_du_utility.error(SQLCODE, 'hr_du_rules.api_present_and_correct',
87: '(none)', 'R');
88: RAISE;
89: --
90: END API_PRESENT_AND_CORRECT;

Line 120: hr_du_utility.message('ROUT','entry:hr_du_rules.PROCESS_ORDER_PRESENT', 5);

116:
117:
118: BEGIN
119: --
120: hr_du_utility.message('ROUT','entry:hr_du_rules.PROCESS_ORDER_PRESENT', 5);
121: hr_du_utility.message('PARA', '(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
122: --
123:
124: OPEN csr_process_order;

Line 137: hr_du_utility.message('ROUT','exit:hr_du_rules.process_order_present', 15);

133: END IF;
134: CLOSE csr_process_order;
135:
136: --
137: hr_du_utility.message('ROUT','exit:hr_du_rules.process_order_present', 15);
138: --
139:
140: EXCEPTION
141: WHEN e_fatal_error THEN

Line 142: hr_du_utility.error(SQLCODE, 'hr_du_rules.process_order_present',

138: --
139:
140: EXCEPTION
141: WHEN e_fatal_error THEN
142: hr_du_utility.error(SQLCODE, 'hr_du_rules.process_order_present',
143: l_fatal_error_message, 'R');
144: RAISE;
145: WHEN OTHERS THEN
146: hr_du_utility.error(SQLCODE, 'hr_du_rules.process_order_present',

Line 146: hr_du_utility.error(SQLCODE, 'hr_du_rules.process_order_present',

142: hr_du_utility.error(SQLCODE, 'hr_du_rules.process_order_present',
143: l_fatal_error_message, 'R');
144: RAISE;
145: WHEN OTHERS THEN
146: hr_du_utility.error(SQLCODE, 'hr_du_rules.process_order_present',
147: '(none)', 'R');
148: RAISE;
149: --
150: END PROCESS_ORDER_PRESENT;

Line 188: hr_du_utility.message('ROUT','entry:hr_du_rules.return_upload_header_file', 5);

184:
185:
186: BEGIN
187: --
188: hr_du_utility.message('ROUT','entry:hr_du_rules.return_upload_header_file', 5);
189: hr_du_utility.message('PARA', '(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
190: --
191:
192: OPEN csr_api_file;

Line 205: hr_du_utility.message('ROUT','exit:hr_du_rules.return_upload_header_file', 15);

201:
202: RETURN l_file_name;
203:
204: --
205: hr_du_utility.message('ROUT','exit:hr_du_rules.return_upload_header_file', 15);
206: hr_du_utility.message('PARA', '(l_file_name - ' || l_file_name || ')'
207: , 20);
208: --
209:

Line 212: hr_du_utility.error(SQLCODE, 'hr_du_rules.return_upload_header_file',

208: --
209:
210: EXCEPTION
211: WHEN e_fatal_error THEN
212: hr_du_utility.error(SQLCODE, 'hr_du_rules.return_upload_header_file',
213: l_fatal_error_message, 'R');
214: RAISE;
215: WHEN OTHERS THEN
216: hr_du_utility.error(SQLCODE, 'hr_du_rules.return_upload_header_file',

Line 216: hr_du_utility.error(SQLCODE, 'hr_du_rules.return_upload_header_file',

212: hr_du_utility.error(SQLCODE, 'hr_du_rules.return_upload_header_file',
213: l_fatal_error_message, 'R');
214: RAISE;
215: WHEN OTHERS THEN
216: hr_du_utility.error(SQLCODE, 'hr_du_rules.return_upload_header_file',
217: '(none)', 'R');
218: RAISE;
219: --
220: END RETURN_UPLOAD_HEADER_FILE;

Line 253: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_user_key_setup', 5);

249:
250:
251: BEGIN
252: --
253: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_user_key_setup', 5);
254: hr_du_utility.message('PARA', '(p_upload_header_id - ' || p_upload_header_id || ')' , 10);
255: --
256:
257: OPEN csr_user_key;

Line 286: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_user_key_setup', 15);

282: END IF;
283: CLOSE csr_user_key;
284:
285: --
286: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_user_key_setup', 15);
287: --
288:
289: EXCEPTION
290: WHEN e_fatal_error THEN

Line 291: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_user_key_setup',

287: --
288:
289: EXCEPTION
290: WHEN e_fatal_error THEN
291: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_user_key_setup',
292: l_fatal_error_message, 'R');
293: RAISE;
294: WHEN OTHERS THEN
295: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_user_key_setup',

Line 295: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_user_key_setup',

291: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_user_key_setup',
292: l_fatal_error_message, 'R');
293: RAISE;
294: WHEN OTHERS THEN
295: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_user_key_setup',
296: '(none)', 'R');
297: RAISE;
298: --
299: END VALIDATE_USER_KEY_SETUP;

Line 358: hr_du_utility.message('ROUT','entry:hr_du_rules.perform_user_key_checks', 5);

354: AND head.api_module_id = col.api_module_id;
355:
356: BEGIN
357: --
358: hr_du_utility.message('ROUT','entry:hr_du_rules.perform_user_key_checks', 5);
359: hr_du_utility.message('PARA', '(p_user_key - ' || p_user_key ||
360: ')(p_upload_header_id - ' || p_upload_header_id || ')'
361: , 10);
362:

Line 438: hr_du_utility.message('ROUT','exit:hr_du_rules.perform_user_key_checks', 15);

434: --
435: END IF;
436:
437: --
438: hr_du_utility.message('ROUT','exit:hr_du_rules.perform_user_key_checks', 15);
439: --
440:
441: EXCEPTION
442: WHEN e_fatal_error THEN

Line 443: hr_du_utility.error(SQLCODE, 'hr_du_rules.perform_user_key_checks',

439: --
440:
441: EXCEPTION
442: WHEN e_fatal_error THEN
443: hr_du_utility.error(SQLCODE, 'hr_du_rules.perform_user_key_checks',
444: l_fatal_error_message, 'R');
445: RAISE;
446: WHEN OTHERS THEN
447: hr_du_utility.error(SQLCODE, 'hr_du_rules.perform_user_key_checks',

Line 447: hr_du_utility.error(SQLCODE, 'hr_du_rules.perform_user_key_checks',

443: hr_du_utility.error(SQLCODE, 'hr_du_rules.perform_user_key_checks',
444: l_fatal_error_message, 'R');
445: RAISE;
446: WHEN OTHERS THEN
447: hr_du_utility.error(SQLCODE, 'hr_du_rules.perform_user_key_checks',
448: '(none)', 'R');
449: RAISE;
450: --
451: END PERFORM_USER_KEY_CHECKS;

Line 486: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_starting_point', 5);

482: l_file_name VARCHAR2(2000);
483:
484: BEGIN
485: --
486: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_starting_point', 5);
487: hr_du_utility.message('PARA', '(p_upload_header_id - ' ||
488: p_upload_header_id || ')', 10);
489: --
490: OPEN csr_starting_point;

Line 522: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_starting_point', 15);

518: END IF;
519: CLOSE csr_starting_point;
520:
521: --
522: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_starting_point', 15);
523: hr_du_utility.message('PARA','(none)', 30);
524: --
525:
526: EXCEPTION

Line 528: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_starting_point',

524: --
525:
526: EXCEPTION
527: WHEN e_fatal_error THEN
528: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_starting_point',
529: l_fatal_error_message, 'R');
530: RAISE;
531: WHEN OTHERS THEN
532: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_starting_point',

Line 532: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_starting_point',

528: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_starting_point',
529: l_fatal_error_message, 'R');
530: RAISE;
531: WHEN OTHERS THEN
532: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_starting_point',
533: '(none)', 'R');
534: RAISE;
535: --
536: END VALIDATE_STARTING_POINT;

Line 571: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_referencing', 5);

567: l_file_name VARCHAR2(2000);
568:
569: BEGIN
570: --
571: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_referencing', 5);
572: hr_du_utility.message('PARA', '(p_upload_header_id - ' ||
573: p_upload_header_id || ')', 10);
574: --
575:

Line 609: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_referencing', 15);

605: END IF;
606: CLOSE csr_referencing;
607:
608: --
609: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_referencing', 15);
610: hr_du_utility.message('PARA','(none)', 30);
611: --
612:
613: RETURN l_referencing;

Line 617: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_referencing',

613: RETURN l_referencing;
614:
615: EXCEPTION
616: WHEN e_fatal_error THEN
617: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_referencing',
618: l_fatal_error_message, 'R');
619: RAISE;
620: WHEN OTHERS THEN
621: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_referencing',

Line 621: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_referencing',

617: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_referencing',
618: l_fatal_error_message, 'R');
619: RAISE;
620: WHEN OTHERS THEN
621: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_referencing',
622: '(none)', 'R');
623: RAISE;
624: --
625: END VALIDATE_REFERENCING;

Line 651: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_business_group', 5);

647: l_fatal_error_message VARCHAR2(2000);
648:
649: BEGIN
650: --
651: hr_du_utility.message('ROUT','entry:hr_du_rules.validate_business_group', 5);
652: hr_du_utility.message('PARA', '(p_business_group_profile - ' ||
653: p_business_group_profile ||
654: ')(p_business_group_file - ' || p_business_group_file
655: || ')', 10);

Line 677: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_business_group', 15);

673:
674: --
675: hr_du_utility.message('INFO','Business group names validated', 15);
676: hr_du_utility.message('SUMM','Business group names validated', 20);
677: hr_du_utility.message('ROUT','exit:hr_du_rules.validate_business_group', 15);
678: hr_du_utility.message('PARA','(none)', 30);
679: --
680:
681: EXCEPTION

Line 683: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_business_group',

679: --
680:
681: EXCEPTION
682: WHEN e_fatal_error THEN
683: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_business_group',
684: l_fatal_error_message, 'R');
685: RAISE;
686: WHEN OTHERS THEN
687: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_business_group',

Line 687: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_business_group',

683: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_business_group',
684: l_fatal_error_message, 'R');
685: RAISE;
686: WHEN OTHERS THEN
687: hr_du_utility.error(SQLCODE, 'hr_du_rules.validate_business_group',
688: '(none)', 'R');
689: RAISE;
690: --
691: END VALIDATE_BUSINESS_GROUP;

Line 696: END HR_DU_RULES;

692: --
693:
694:
695:
696: END HR_DU_RULES;