42: ,p_transaction_category_id => p_transaction_category_id
43: ,p_type_code => p_type_code
44: );
45: exception
46: when hr_api.cannot_find_prog_unit then
47: hr_api.cannot_find_prog_unit_error
48: (p_module_name => 'create_txn_cat_document'
49: ,p_hook_type => 'BP'
50: );
43: ,p_type_code => p_type_code
44: );
45: exception
46: when hr_api.cannot_find_prog_unit then
47: hr_api.cannot_find_prog_unit_error
48: (p_module_name => 'create_txn_cat_document'
49: ,p_hook_type => 'BP'
50: );
51: end;
77: ,p_type_code => p_type_code
78: ,p_object_version_number => p_object_version_number
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_txn_cat_document'
84: ,p_hook_type => 'AP'
85: );
78: ,p_object_version_number => p_object_version_number
79: );
80: exception
81: when hr_api.cannot_find_prog_unit then
82: hr_api.cannot_find_prog_unit_error
83: (p_module_name => 'create_txn_cat_document'
84: ,p_hook_type => 'AP'
85: );
86: end;
87: --
88: -- When in validation only mode raise the Validate_Enabled exception
89: --
90: if p_validate then
91: raise hr_api.validate_enabled;
92: end if;
93: --
94: -- Set all IN OUT and OUT parameters with out values
95: --
96: p_object_version_number := p_object_version_number;
97: --
98: hr_utility.set_location(' Leaving:'||l_proc, 70);
99: exception
100: when hr_api.validate_enabled then
101: --
102: -- As the Validate_Enabled exception has been raised
103: -- we must rollback to the savepoint
104: --
132: (p_validate in boolean default false
133: ,p_effective_date in date
134: ,p_document_id in number
135: ,p_transaction_category_id in number
136: ,p_type_code in varchar2 default hr_api.g_varchar2
137: ,p_object_version_number in out nocopy number
138: ) is
139: --
140: -- Declare cursors and local variables
167: ,p_type_code => p_type_code
168: ,p_object_version_number => p_object_version_number
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'update_txn_cat_document'
174: ,p_hook_type => 'BP'
175: );
168: ,p_object_version_number => p_object_version_number
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'update_txn_cat_document'
174: ,p_hook_type => 'BP'
175: );
176: end;
198: ,p_type_code => p_type_code
199: ,p_object_version_number => l_object_version_number
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'update_txn_cat_document'
205: ,p_hook_type => 'AP'
206: );
199: ,p_object_version_number => l_object_version_number
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'update_txn_cat_document'
205: ,p_hook_type => 'AP'
206: );
207: end;
208: --
209: -- When in validation only mode raise the Validate_Enabled exception
210: --
211: if p_validate then
212: raise hr_api.validate_enabled;
213: end if;
214: --
215: -- Set all IN OUT and OUT parameters with out values
216: --
217: p_object_version_number := l_object_version_number;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised
224: -- we must rollback to the savepoint
225: --
277: ,p_transaction_category_id => p_transaction_category_id
278: ,p_object_version_number => p_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'delete_txn_cat_document'
284: ,p_hook_type => 'BP'
285: );
278: ,p_object_version_number => p_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'delete_txn_cat_document'
284: ,p_hook_type => 'BP'
285: );
286: end;
304: ,p_transaction_category_id => p_transaction_category_id
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'delete_txn_cat_document'
311: ,p_hook_type => 'AP'
312: );
305: ,p_object_version_number => p_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'delete_txn_cat_document'
311: ,p_hook_type => 'AP'
312: );
313: end;
314: --
315: -- When in validation only mode raise the Validate_Enabled exception
316: --
317: if p_validate then
318: raise hr_api.validate_enabled;
319: end if;
320: --
321: -- Set all IN OUT and OUT parameters with out values
322: --
322: --
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 70);
325: exception
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --