DBA Data[Home] [Help]

APPS.PQH_DE_VLDDEF_API dependencies on HR_UTILITY

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

27: L_Effective_Date Date;
28: l_Wrkplc_vldtn_id PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID%TYPE;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint Insert_Vldtn_Defn;

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

100: p_wrkplc_vldtn_id := l_Wrkplc_vldtn_id;
101: p_object_version_number := l_object_version_number;
102:
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 70);
105: exception
106: when hr_api.validate_enabled then
107: --
108: -- As the Validate_Enabled exception has been raised

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

115: -- when validation only mode is being used.)
116: --
117: p_wrkplc_vldtn_id := null;
118: p_object_version_number := null;
119: hr_utility.set_location(' Leaving:'||l_proc, 80);
120:
121: when others then
122: p_wrkplc_vldtn_id := null;
123: p_object_version_number := null;

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

124: --
125: -- A validation or unexpected error has occured
126: --
127: rollback to Insert_Vldtn_Defn;
128: hr_utility.set_location(' Leaving:'||l_proc, 90);
129: raise;
130: end Insert_Vldtn_Defn;
131:
132: --

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

148: l_object_Version_Number PQH_DE_WRKPLC_VLDTNs.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
149: L_Effective_Date Date;
150:
151: Begin
152: hr_utility.set_location('Entering:'|| l_proc, 10);
153: --
154: -- Issue a savepoint
155: --
156: savepoint Update_Vldtn_Defn;

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

222:
223: p_object_version_number := l_object_version_number;
224:
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: exception
228: when hr_api.validate_enabled then
229: --
230: -- As the Validate_Enabled exception has been raised

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

235: -- Only set output warning arguments
236: -- (Any key or derived arguments must be set to null
237: -- when validation only mode is being used.)
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 80);
240:
241: when others then
242: p_object_version_number := l_object_version_number;
243: --

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

243: --
244: -- A validation or unexpected error has occured
245: --
246: rollback to Update_Vldtn_Defn;
247: hr_utility.set_location(' Leaving:'||l_proc, 90);
248: raise;
249: end Update_Vldtn_Defn;
250:
251: --

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

261: --
262: l_proc varchar2(72) := g_package||'delete_Vldtn_Defn';
263: --
264: begin
265: hr_utility.set_location('Entering:'|| l_proc, 10);
266: --
267: -- Issue a savepoint
268: --
269: savepoint delete_Vldtn_Defn;

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

309: end if;
310: --
311: -- Set all output arguments
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 70);
314: exception
315: when hr_api.validate_enabled then
316: --
317: -- As the Validate_Enabled exception has been raised

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

322: -- Only set output warning arguments
323: -- (Any key or derived arguments must be set to null
324: -- when validation only mode is being used.)
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 80);
327: when others then
328: --
329: -- A validation or unexpected error has occured
330: --

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

328: --
329: -- A validation or unexpected error has occured
330: --
331: rollback to delete_Vldtn_Defn;
332: hr_utility.set_location(' Leaving:'||l_proc, 90);
333: raise;
334: end delete_Vldtn_Defn;
335:
336: end PQH_DE_VLDDEF_API;