41: l_cancel_type VARCHAR2(10) := 'APL';
42: l_where VARCHAR2(10) := 'BEGIN';
43: --
44: begin
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Issue a savepoint
48: --
49: savepoint cancel_application;
55: --
56: open date_received;
57: fetch date_received into l_date_received;
58: if date_received%notfound then
59: hr_utility.set_message(800,'PER_289080_APL_NON_EXIST');
60: hr_utility.raise_error;
61: end if;
62: close date_received;
63: --
56: open date_received;
57: fetch date_received into l_date_received;
58: if date_received%notfound then
59: hr_utility.set_message(800,'PER_289080_APL_NON_EXIST');
60: hr_utility.raise_error;
61: end if;
62: close date_received;
63: --
64: open get_person_type(l_date_received);
133: --
134: -- Set all output arguments
135: --
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 70);
138: exception
139: when hr_api.validate_enabled then
140: --
141: -- As the Validate_Enabled exception has been raised
146: -- Only set output warning arguments
147: -- (Any key or derived arguments must be set to null
148: -- when validation only mode is being used.)
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 80);
151: when others then
152: --
153: -- A validation or unexpected error has occured
154: --
152: --
153: -- A validation or unexpected error has occured
154: --
155: rollback to cancel_application;
156: hr_utility.set_location(' Leaving:'||l_proc, 90);
157: raise;
158: end cancel_application;
159: --
160: end per_cancel_application_api;