[Home] [Help]
37: l_formula_mismatch_warning boolean;
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Issue the savepoint.
44: --
45: savepoint create_status_process_rule;
69: ,p_hook_type => 'BP'
70: );
71: end;
72: --
73: hr_utility.set_location('Entering:'||l_proc, 20);
74: --
75: -- Process Logic
76: --
77: pay_ppr_ins.ins
91: ,p_formula_mismatch_warning => l_formula_mismatch_warning
92: );
93: --
94: -- Call After Process User Hook
95: hr_utility.set_location('Entering:'||l_proc, 30);
96: --
97: begin
98: pay_status_processing_rule_bk1.create_status_process_rule_a
99: (p_effective_date => l_effective_date
130: p_effective_end_date := l_effective_end_date;
131: p_object_version_number := l_object_version_number;
132: p_formula_mismatch_warning := l_formula_mismatch_warning;
133: --
134: hr_utility.set_location(' Leaving:'||l_proc, 40);
135: exception
136: --
137: when HR_Api.Validate_Enabled then
138: --
151: p_effective_end_date := null;
152: --
153: p_formula_mismatch_warning := l_formula_mismatch_warning ;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 50);
156: when others then
157: --
158: -- A validation or unexpected error has occured
159: --
157: --
158: -- A validation or unexpected error has occured
159: --
160: rollback to create_status_process_rule;
161: hr_utility.set_location(' Leaving:'||l_proc, 60);
162: raise;
163: end create_status_process_rule;
164:
165: -- ----------------------------------------------------------------------------
189: l_temp_ovn pay_status_processing_rules_f.object_version_number%type;
190: l_formula_mismatch_warning boolean;
191: --
192: begin
193: hr_utility.set_location('Entering:'|| l_proc, 10);
194: --
195: -- Issue the savepoint.
196: --
197: savepoint update_status_process_rule;
223: end;
224: --
225: -- call business process
226: --
227: hr_utility.set_location(l_proc, 20);
228: --
229: pay_ppr_upd.upd
230: ( p_effective_date => l_effective_date
231: ,p_datetrack_mode => p_datetrack_mode
239: );
240:
241: -- Call After Process User Hook
242: --
243: hr_utility.set_location(l_proc, 30);
244: --
245: begin
246: pay_status_processing_rule_bk2.update_status_process_rule_a
247: (p_effective_date => l_effective_date
262: );
263: end;
264: --
265:
266: hr_utility.set_location(l_proc, 40);
267: --
268: --
269: -- If we are validating then raise the Validate_Enabled exception
270: --
279: p_effective_start_date := l_effective_start_date;
280: p_effective_end_date := l_effective_end_date;
281: p_formula_mismatch_warning := l_formula_mismatch_warning ;
282: --
283: hr_utility.set_location('Leaving :'||l_proc, 50);
284: exception
285: WHEN hr_api.validate_enabled THEN
286: --
287: -- As the Validate_Enabled EXCEPTION has been raised
297: p_effective_end_date := l_effective_end_date;
298: p_object_version_number := l_temp_ovn;
299: p_formula_mismatch_warning := l_formula_mismatch_warning ;
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 60);
302: --
303: WHEN others THEN
304: --
305: -- A validation or unexpected error has occured
304: --
305: -- A validation or unexpected error has occured
306: --
307: ROLLBACK TO update_status_process_rule;
308: hr_utility.set_location(' Leaving:'||l_proc, 70);
309: RAISE;
310: --
311: end update_status_process_rule;
312: --
333: l_temp_ovn number := p_object_version_number;
334: --
335: BEGIN
336: --
337: hr_utility.set_location('Entering:'|| l_proc, 10);
338: --
339: -- Issue a SAVEPOINT IF operating in validation only mode
340: --
341: SAVEPOINT delete_status_process_rule;
341: SAVEPOINT delete_status_process_rule;
342: --
343: l_effective_date := TRUNC(p_effective_date);
344: --
345: hr_utility.set_location(l_proc, 20);
346: --
347: -- Process Logic
348: --
349: l_object_version_number := p_object_version_number;
364: ,p_hook_type => 'BP'
365: );
366: end;
367: --
368: hr_utility.set_location(l_proc, 20);
369: --
370: pay_ppr_del.del
371: ( p_effective_date => l_effective_date
372: ,p_datetrack_mode => p_datetrack_mode
376: ,p_effective_end_date => l_effective_end_date);
377: --
378: -- Call After Process User Hook
379: --
380: hr_utility.set_location(l_proc, 30);
381: --
382: begin
383: pay_status_processing_rule_bk3.delete_status_process_rule_a
384: (p_effective_date => l_effective_date
395: ,p_hook_type => 'AP'
396: );
397: end;
398: --
399: hr_utility.set_location(l_proc, 40);
400: --
401: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
402: --
403: IF p_validate THEN
411: p_object_version_number := l_object_version_number;
412: p_effective_start_date := l_effective_start_date;
413: p_effective_end_date := l_effective_end_date;
414: --
415: hr_utility.set_location(' Leaving:'||l_proc, 50);
416: --
417: EXCEPTION
418: --
419: WHEN hr_api.validate_enabled THEN
430: p_effective_start_date := null;
431: p_effective_end_date := null;
432: p_object_version_number := l_temp_ovn;
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 60);
435: --
436: WHEN others THEN
437: --
438: -- A validation or unexpected error has occured
438: -- A validation or unexpected error has occured
439: --
440: ROLLBACK TO delete_status_process_rule;
441: -- Reset IN OUT parameters and set OUT parameters.
442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: RAISE;
444: --
445: END delete_status_process_rule;
446: --