41: l_object_version_number ben_reporting.object_version_number%TYPE;
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Issue a savepoint if operating in validation only mode
48: --
49: savepoint create_reporting;
47: -- Issue a savepoint if operating in validation only mode
48: --
49: savepoint create_reporting;
50: --
51: hr_utility.set_location(l_proc, 20);
52: --
53: ben_bmn_ins.ins
54: (p_reporting_id => l_reporting_id
55: ,p_benefit_action_id => p_benefit_action_id
73: ,p_mo_num => p_mo_num
74: ,p_yr_num => p_yr_num
75: ,p_object_version_number => l_object_version_number);
76: --
77: hr_utility.set_location(l_proc, 60);
78: --
79: -- When in validation only mode raise the Validate_Enabled exception
80: --
81: if p_validate then
86: --
87: p_reporting_id := l_reporting_id;
88: p_object_version_number := l_object_version_number;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 70);
91: --
92: exception
93: --
94: when hr_api.validate_enabled then
103: -- when validation only mode is being used.)
104: --
105: p_reporting_id := null;
106: p_object_version_number := null;
107: hr_utility.set_location(' Leaving:'||l_proc, 80);
108: --
109: when others then
110: --
111: -- A validation or unexpected error has occured
153: l_object_version_number ben_reporting.object_version_number%TYPE;
154: --
155: begin
156: --
157: hr_utility.set_location('Entering:'|| l_proc, 10);
158: --
159: -- Issue a savepoint if operating in validation only mode
160: --
161: savepoint update_reporting;
159: -- Issue a savepoint if operating in validation only mode
160: --
161: savepoint update_reporting;
162: --
163: hr_utility.set_location(l_proc, 20);
164: --
165: -- Process Logic
166: --
167: l_object_version_number := p_object_version_number;
189: ,p_mo_num => p_mo_num
190: ,p_yr_num => p_yr_num
191: ,p_object_version_number => l_object_version_number);
192: --
193: hr_utility.set_location(l_proc, 60);
194: --
195: -- When in validation only mode raise the Validate_Enabled exception
196: --
197: if p_validate then
201: -- Set all output arguments
202: --
203: p_object_version_number := l_object_version_number;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 70);
206: --
207: exception
208: --
209: when hr_api.validate_enabled then
216: -- Only set output warning arguments
217: -- (Any key or derived arguments must be set to null
218: -- when validation only mode is being used.)
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 80);
221: --
222: when others then
223: --
224: -- A validation or unexpected error has occured
244: l_object_version_number ben_reporting.object_version_number%TYPE;
245: --
246: begin
247: --
248: hr_utility.set_location('Entering:'|| l_proc, 10);
249: --
250: -- Issue a savepoint if operating in validation only mode
251: --
252: savepoint delete_reporting;
250: -- Issue a savepoint if operating in validation only mode
251: --
252: savepoint delete_reporting;
253: --
254: hr_utility.set_location(l_proc, 20);
255: --
256: -- Process Logic
257: --
258: l_object_version_number := p_object_version_number;
261: ben_bmn_del.del
262: (p_reporting_id => p_reporting_id
263: ,p_object_version_number => l_object_version_number);
264: --
265: hr_utility.set_location(l_proc, 60);
266: --
267: -- When in validation only mode raise the Validate_Enabled exception
268: --
269: if p_validate then
269: if p_validate then
270: raise hr_api.validate_enabled;
271: end if;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 70);
274: --
275: exception
276: --
277: when hr_api.validate_enabled then
310: l_proc varchar2(72) := g_package||'lck';
311: --
312: begin
313: --
314: hr_utility.set_location('Entering:'|| l_proc, 10);
315: --
316: ben_bmn_shd.lck
317: (p_reporting_id => p_reporting_id
318: ,p_object_version_number => p_object_version_number);
316: ben_bmn_shd.lck
317: (p_reporting_id => p_reporting_id
318: ,p_object_version_number => p_object_version_number);
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 70);
321: --
322: end lck;
323: --
324: end ben_reporting_api;