DBA Data[Home] [Help]

APPS.PQH_DE_INS_END_REASONS_API dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering:'|| l_proc, 10);

29: L_Effective_Date Date;
30: l_INS_end_reason_id PQH_DE_INS_END_REASONS.INS_end_reason_id%TYPE;
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint Insert_PENSION_END_REASONS;

Line 118: hr_utility.set_location(' Leaving:'||l_proc, 70);

114: p_InS_end_reason_id := l_INS_end_reason_id ;
115: p_object_version_number := l_object_version_number;
116:
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: exception
120: when hr_api.validate_enabled then
121: --
122: -- As the Validate_Enabled exception has been raised

Line 133: hr_utility.set_location(' Leaving:'||l_proc, 80);

129: -- when validation only mode is being used.)
130: --
131: p_InS_end_reason_id := null;
132: p_object_version_number := null;
133: hr_utility.set_location(' Leaving:'||l_proc, 80);
134:
135: when others then
136: p_InS_end_reason_id := null;
137: p_object_version_number := null;

Line 142: hr_utility.set_location(' Leaving:'||l_proc, 90);

138: --
139: -- A validation or unexpected error has occured
140: --
141: rollback to Insert_PENSION_END_REASONS;
142: hr_utility.set_location(' Leaving:'||l_proc, 90);
143: raise;
144: end Insert_PENSION_END_REASONS;
145:
146: --

Line 168: hr_utility.set_location('Entering:'|| l_proc, 10);

164: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
165: L_Effective_Date Date;
166:
167: Begin
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: --
170: -- Issue a savepoint
171: --
172: savepoint Update_PENSION_END_REASONS;

Line 253: hr_utility.set_location(' Leaving:'||l_proc, 70);

249:
250: p_object_version_number := l_object_version_number;
251:
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 70);
254: exception
255: when hr_api.validate_enabled then
256: --
257: -- As the Validate_Enabled exception has been raised

Line 266: hr_utility.set_location(' Leaving:'||l_proc, 80);

262: -- Only set output warning arguments
263: -- (Any key or derived arguments must be set to null
264: -- when validation only mode is being used.)
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 80);
267:
268: when others then
269: p_object_version_number := l_object_version_number;
270: --

Line 274: hr_utility.set_location(' Leaving:'||l_proc, 90);

270: --
271: -- A validation or unexpected error has occured
272: --
273: rollback to Update_PENSION_END_REASONS;
274: hr_utility.set_location(' Leaving:'||l_proc, 90);
275: raise;
276: end Update_PENSION_END_REASONS;
277:
278: --

Line 292: hr_utility.set_location('Entering:'|| l_proc, 10);

288: --
289: l_proc varchar2(72) := g_package||'delete_PENSION_END_REASONS';
290: --
291: begin
292: hr_utility.set_location('Entering:'|| l_proc, 10);
293: --
294: -- Issue a savepoint
295: --
296: savepoint delete_PENSION_END_REASONS;

Line 341: hr_utility.set_location(' Leaving:'||l_proc, 70);

337: end if;
338: --
339: -- Set all output arguments
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 70);
342: exception
343: when hr_api.validate_enabled then
344: --
345: -- As the Validate_Enabled exception has been raised

Line 354: hr_utility.set_location(' Leaving:'||l_proc, 80);

350: -- Only set output warning arguments
351: -- (Any key or derived arguments must be set to null
352: -- when validation only mode is being used.)
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 80);
355: when others then
356: --
357: -- A validation or unexpected error has occured
358: --

Line 360: hr_utility.set_location(' Leaving:'||l_proc, 90);

356: --
357: -- A validation or unexpected error has occured
358: --
359: rollback to delete_PENSION_END_REASONS;
360: hr_utility.set_location(' Leaving:'||l_proc, 90);
361: raise;
362: end delete_PENSION_END_REASONS;
363:
364: end PQH_DE_ins_END_REASONS_API;