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;
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;
48: FETCH csr_api_name INTO l_api_name;
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
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',
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;
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;
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;
125: FETCH csr_process_order INTO l_process_order;
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
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',
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;
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;
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;
193: FETCH csr_api_file INTO l_file_name;
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:
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:
210: EXCEPTION
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',
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;
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;
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;
258: FETCH csr_user_key INTO l_user_key;
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
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',
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;
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:
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:
363: --
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
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',
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;
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;
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;
491: FETCH csr_starting_point INTO l_starting_point;
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
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
527: WHEN e_fatal_error THEN
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',
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;
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:
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:
576: OPEN csr_referencing;
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;
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;
614:
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',
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;
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);
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);
656: --
671: END IF;
672:
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: --
672:
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:
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
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
682: WHEN e_fatal_error THEN
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',
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;