66: ,p_housing_indemnity_rate => p_housing_indemnity_rate
67: ,p_currency_code => p_currency_code
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'CREATE_INDEMNITY_RATE'
73: ,p_hook_type => 'BP'
74: );
67: ,p_currency_code => p_currency_code
68: );
69: exception
70: when hr_api.cannot_find_prog_unit then
71: hr_api.cannot_find_prog_unit_error
72: (p_module_name => 'CREATE_INDEMNITY_RATE'
73: ,p_hook_type => 'BP'
74: );
75: end;
103: ,p_effective_start_date => l_effective_start_date
104: ,p_effective_end_date => l_effective_end_date
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_INDEMNITY_RATE'
110: ,p_hook_type => 'AP'
111: );
104: ,p_effective_end_date => l_effective_end_date
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'CREATE_INDEMNITY_RATE'
110: ,p_hook_type => 'AP'
111: );
112: end;
113: --
114: -- When in validation only mode raise the Validate_Enabled exception
115: --
116: if p_validate then
117: raise hr_api.validate_enabled;
118: end if;
119: --
120: -- Set all IN OUT and OUT parameters with out values
121: --
130: --
131: End if;
132:
133: exception
134: when hr_api.validate_enabled then
135: --
136: -- As the Validate_Enabled exception has been raised
137: -- we must rollback to the savepoint
138: --
229: ,p_gross_index => p_gross_index
230: ,p_increased_index => p_increased_index
231: );
232: exception
233: when hr_api.cannot_find_prog_unit then
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'CREATE_GLOBAL_INDEX'
236: ,p_hook_type => 'BP'
237: );
230: ,p_increased_index => p_increased_index
231: );
232: exception
233: when hr_api.cannot_find_prog_unit then
234: hr_api.cannot_find_prog_unit_error
235: (p_module_name => 'CREATE_GLOBAL_INDEX'
236: ,p_hook_type => 'BP'
237: );
238: end;
269: ,p_effective_start_date => l_effective_start_date
270: ,p_effective_end_date => l_effective_end_date
271: );
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'CREATE_GLOBAL_INDEX'
276: ,p_hook_type => 'AP'
277: );
270: ,p_effective_end_date => l_effective_end_date
271: );
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: (p_module_name => 'CREATE_GLOBAL_INDEX'
276: ,p_hook_type => 'AP'
277: );
278: end;
281: hr_utility.set_location('After After Hook:'|| l_proc, 13);
282: -- When in validation only mode raise the Validate_Enabled exception
283: --
284: if p_validate then
285: raise hr_api.validate_enabled;
286: end if;
287: --
288: -- Set all IN OUT and OUT parameters with out values
289: --
298: --
299: End if;
300:
301: exception
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --
348: ,p_effective_date in date
349: ,p_datetrack_mode in varchar2
350: ,p_global_index_id in number
351: ,p_object_version_number in out nocopy number
352: ,p_basic_salary_rate in number default hr_api.g_number
353: ,p_housing_indemnity_rate in number default hr_api.g_number
354: ,p_currency_code in varchar2
355: ,p_effective_start_date out nocopy date
356: ,p_effective_end_date out nocopy date
349: ,p_datetrack_mode in varchar2
350: ,p_global_index_id in number
351: ,p_object_version_number in out nocopy number
352: ,p_basic_salary_rate in number default hr_api.g_number
353: ,p_housing_indemnity_rate in number default hr_api.g_number
354: ,p_currency_code in varchar2
355: ,p_effective_start_date out nocopy date
356: ,p_effective_end_date out nocopy date
357: ) is
409: ,p_currency_code => p_currency_code
410: );
411:
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'UPDATE_INDEMNITY_RATE'
416: ,p_hook_type => 'BP'
417: );
410: );
411:
412: exception
413: when hr_api.cannot_find_prog_unit then
414: hr_api.cannot_find_prog_unit_error
415: (p_module_name => 'UPDATE_INDEMNITY_RATE'
416: ,p_hook_type => 'BP'
417: );
418: end;
449: ,p_effective_end_date => l_effective_end_date
450:
451: );
452: exception
453: when hr_api.cannot_find_prog_unit then
454: hr_api.cannot_find_prog_unit_error
455: (p_module_name => 'UPDATE_INDEMNITY_RATE'
456: ,p_hook_type => 'AP'
457: );
450:
451: );
452: exception
453: when hr_api.cannot_find_prog_unit then
454: hr_api.cannot_find_prog_unit_error
455: (p_module_name => 'UPDATE_INDEMNITY_RATE'
456: ,p_hook_type => 'AP'
457: );
458: end;
459: --
460: -- When in validation only mode raise the Validate_Enabled exception
461: --
462: if p_validate then
463: raise hr_api.validate_enabled;
464: end if;
465: --
466: -- Set all IN OUT and OUT parameters with out values
467: --
473: --
474: End if;
475:
476: exception
477: when hr_api.validate_enabled then
478: --
479: -- As the Validate_Enabled exception has been raised
480: -- we must rollback to the savepoint
481: --
519: ,p_effective_date in date
520: ,p_datetrack_mode in varchar2
521: ,p_global_index_id in number
522: ,p_object_version_number in out nocopy number
523: ,p_gross_index in number default hr_api.g_number
524: ,p_increased_index in number default hr_api.g_number
525: ,p_effective_start_date out nocopy date
526: ,p_effective_end_date out nocopy date
527: ) is
520: ,p_datetrack_mode in varchar2
521: ,p_global_index_id in number
522: ,p_object_version_number in out nocopy number
523: ,p_gross_index in number default hr_api.g_number
524: ,p_increased_index in number default hr_api.g_number
525: ,p_effective_start_date out nocopy date
526: ,p_effective_end_date out nocopy date
527: ) is
528:
576:
577: );
578:
579: exception
580: when hr_api.cannot_find_prog_unit then
581: hr_api.cannot_find_prog_unit_error
582: (p_module_name => 'UPDATE_GLOBAL_INDEX'
583: ,p_hook_type => 'BP'
584: );
577: );
578:
579: exception
580: when hr_api.cannot_find_prog_unit then
581: hr_api.cannot_find_prog_unit_error
582: (p_module_name => 'UPDATE_GLOBAL_INDEX'
583: ,p_hook_type => 'BP'
584: );
585: end;
615: ,p_effective_start_date => p_effective_start_date
616: ,p_effective_end_date => p_effective_end_date
617: );
618: exception
619: when hr_api.cannot_find_prog_unit then
620: hr_api.cannot_find_prog_unit_error
621: (p_module_name => 'UPDATE_GLOBAL_INDEX'
622: ,p_hook_type => 'AP'
623: );
616: ,p_effective_end_date => p_effective_end_date
617: );
618: exception
619: when hr_api.cannot_find_prog_unit then
620: hr_api.cannot_find_prog_unit_error
621: (p_module_name => 'UPDATE_GLOBAL_INDEX'
622: ,p_hook_type => 'AP'
623: );
624: end;
626: --
627: -- When in validation only mode raise the Validate_Enabled exception
628: --
629: if p_validate then
630: raise hr_api.validate_enabled;
631: end if;
632: --
633: -- Set all IN OUT and OUT parameters with out values
634: --
642: --
643: End if;
644:
645: exception
646: when hr_api.validate_enabled then
647: --
648: -- As the Validate_Enabled exception has been raised
649: -- we must rollback to the savepoint
650: --
742: ,p_object_version_number => p_object_version_number
743: );
744:
745: exception
746: when hr_api.cannot_find_prog_unit then
747: hr_api.cannot_find_prog_unit_error
748: (p_module_name => 'DELETE_INDEMNITY_RATE'
749: ,p_hook_type => 'BP'
750: );
743: );
744:
745: exception
746: when hr_api.cannot_find_prog_unit then
747: hr_api.cannot_find_prog_unit_error
748: (p_module_name => 'DELETE_INDEMNITY_RATE'
749: ,p_hook_type => 'BP'
750: );
751: end;
775: ,p_effective_end_date => p_effective_end_date
776:
777: );
778: exception
779: when hr_api.cannot_find_prog_unit then
780: hr_api.cannot_find_prog_unit_error
781: (p_module_name => 'DELETE_INDEMNITY_RATE'
782: ,p_hook_type => 'AP'
783: );
776:
777: );
778: exception
779: when hr_api.cannot_find_prog_unit then
780: hr_api.cannot_find_prog_unit_error
781: (p_module_name => 'DELETE_INDEMNITY_RATE'
782: ,p_hook_type => 'AP'
783: );
784: end;
785: --
786: -- When in validation only mode raise the Validate_Enabled exception
787: --
788: if p_validate then
789: raise hr_api.validate_enabled;
790: end if;
791: --
792: -- Set all IN OUT and OUT parameters with out values
793: --
799: --
800: End if;
801:
802: exception
803: when hr_api.validate_enabled then
804: --
805: -- As the Validate_Enabled exception has been raised
806: -- we must rollback to the savepoint
807: --
889: ,p_global_index_id => p_global_index_id
890: ,p_object_version_number => p_object_version_number
891: );
892: exception
893: when hr_api.cannot_find_prog_unit then
894: hr_api.cannot_find_prog_unit_error
895: (p_module_name => 'DELETE_GLOBAL_INDEX'
896: ,p_hook_type => 'BP'
897: );
890: ,p_object_version_number => p_object_version_number
891: );
892: exception
893: when hr_api.cannot_find_prog_unit then
894: hr_api.cannot_find_prog_unit_error
895: (p_module_name => 'DELETE_GLOBAL_INDEX'
896: ,p_hook_type => 'BP'
897: );
898: end;
920: ,p_effective_start_date => p_effective_start_date
921: ,p_effective_end_date => p_effective_end_date
922: );
923: exception
924: when hr_api.cannot_find_prog_unit then
925: hr_api.cannot_find_prog_unit_error
926: (p_module_name => 'DELETE_GLOBAL_INDEX'
927: ,p_hook_type => 'AP'
928: );
921: ,p_effective_end_date => p_effective_end_date
922: );
923: exception
924: when hr_api.cannot_find_prog_unit then
925: hr_api.cannot_find_prog_unit_error
926: (p_module_name => 'DELETE_GLOBAL_INDEX'
927: ,p_hook_type => 'AP'
928: );
929: end;
930: --
931: -- When in validation only mode raise the Validate_Enabled exception
932: --
933: if p_validate then
934: raise hr_api.validate_enabled;
935: end if;
936: --
937: -- Set all IN OUT and OUT parameters with out values
938: --
942: --
943: End if;
944:
945: exception
946: when hr_api.validate_enabled then
947: --
948: -- As the Validate_Enabled exception has been raised
949: -- we must rollback to the savepoint
950: --