52: );
53:
54:
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (p_module_name => 'CREATE_PAY_SECURITY_PAYROLL'
59: ,p_hook_type => 'BP'
60: );
53:
54:
55: exception
56: when hr_api.cannot_find_prog_unit then
57: hr_api.cannot_find_prog_unit_error
58: (p_module_name => 'CREATE_PAY_SECURITY_PAYROLL'
59: ,p_hook_type => 'BP'
60: );
61: end;
90:
91:
92:
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (p_module_name => 'CREATE_PAY_SECURITY_PAYROLL'
97: ,p_hook_type => 'AP'
98: );
91:
92:
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (p_module_name => 'CREATE_PAY_SECURITY_PAYROLL'
97: ,p_hook_type => 'AP'
98: );
99: end;
100: --
101: -- When in validation only mode raise the Validate_Enabled exception
102: --
103: if p_validate then
104: raise hr_api.validate_enabled;
105: end if;
106: --
107: -- Set all output arguments
108: --
107: -- Set all output arguments
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 70);
110: exception
111: when hr_api.validate_enabled then
112: --
113: -- As the Validate_Enabled exception has been raised
114: -- we must rollback to the savepoint
115: --
168: (p_security_profile_id => p_security_profile_id
169: ,p_payroll_id => p_payroll_id
170: );
171: exception
172: when hr_api.cannot_find_prog_unit then
173: hr_api.cannot_find_prog_unit_error
174: (p_module_name => 'DELETE_PAY_SECURITY_PAYROLL'
175: ,p_hook_type => 'BP'
176: );
169: ,p_payroll_id => p_payroll_id
170: );
171: exception
172: when hr_api.cannot_find_prog_unit then
173: hr_api.cannot_find_prog_unit_error
174: (p_module_name => 'DELETE_PAY_SECURITY_PAYROLL'
175: ,p_hook_type => 'BP'
176: );
177: end;
199: );
200:
201:
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'DELETE_PAY_SECURITY_PAYROLL'
206: ,p_hook_type => 'AP'
207: );
200:
201:
202: exception
203: when hr_api.cannot_find_prog_unit then
204: hr_api.cannot_find_prog_unit_error
205: (p_module_name => 'DELETE_PAY_SECURITY_PAYROLL'
206: ,p_hook_type => 'AP'
207: );
208: end;
209: --
210: -- When in validation only mode raise the Validate_Enabled exception
211: --
212: if p_validate then
213: raise hr_api.validate_enabled;
214: end if;
215: --
216: -- Set all output arguments
217: --
216: -- Set all output arguments
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 70);
219: exception
220: when hr_api.validate_enabled then
221: --
222: -- As the Validate_Enabled exception has been raised
223: -- we must rollback to the savepoint
224: --