DBA Data[Home] [Help]

APPS.PQH_WORKSHEET_BDGT_ELMNTS_API dependencies on HR_UTILITY

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

25: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
26: --
27: begin
28: --
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: -- Issue a savepoint if operating in validation only mode
32: --
33: savepoint create_WORKSHEET_BDGT_ELMNT;

Line 35: hr_utility.set_location(l_proc, 20);

31: -- Issue a savepoint if operating in validation only mode
32: --
33: savepoint create_WORKSHEET_BDGT_ELMNT;
34: --
35: hr_utility.set_location(l_proc, 20);
36: --
37: -- Process Logic
38: --
39: begin

Line 93: hr_utility.set_location(l_proc, 60);

89: -- End of API User Hook for the after hook of create_WORKSHEET_BDGT_ELMNT
90: --
91: end;
92: --
93: hr_utility.set_location(l_proc, 60);
94: --
95: -- When in validation only mode raise the Validate_Enabled exception
96: --
97: if p_validate then

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

102: --
103: p_worksheet_bdgt_elmnt_id := l_worksheet_bdgt_elmnt_id;
104: p_object_version_number := l_object_version_number;
105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: --
108: exception
109: --
110: when hr_api.validate_enabled then

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

119: -- when validation only mode is being used.)
120: --
121: p_worksheet_bdgt_elmnt_id := null;
122: p_object_version_number := null;
123: hr_utility.set_location(' Leaving:'||l_proc, 80);
124: --
125: when others then
126: p_worksheet_bdgt_elmnt_id := null;
127: p_object_version_number := null;

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

151: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
152: --
153: begin
154: --
155: hr_utility.set_location('Entering:'|| l_proc, 10);
156: --
157: -- Issue a savepoint if operating in validation only mode
158: --
159: savepoint update_WORKSHEET_BDGT_ELMNT;

Line 161: hr_utility.set_location(l_proc, 20);

157: -- Issue a savepoint if operating in validation only mode
158: --
159: savepoint update_WORKSHEET_BDGT_ELMNT;
160: --
161: hr_utility.set_location(l_proc, 20);
162: --
163: -- Process Logic
164: --
165: l_object_version_number := p_object_version_number;

Line 222: hr_utility.set_location(l_proc, 60);

218: -- End of API User Hook for the after hook of update_WORKSHEET_BDGT_ELMNT
219: --
220: end;
221: --
222: hr_utility.set_location(l_proc, 60);
223: --
224: -- When in validation only mode raise the Validate_Enabled exception
225: --
226: if p_validate then

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

230: -- Set all output arguments
231: --
232: p_object_version_number := l_object_version_number;
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: --
236: exception
237: --
238: when hr_api.validate_enabled then

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

245: -- Only set output warning arguments
246: -- (Any key or derived arguments must be set to null
247: -- when validation only mode is being used.)
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 80);
250: --
251: when others then
252:
253: p_object_version_number := l_object_version_number;

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

274: l_object_version_number pqh_worksheet_bdgt_elmnts.object_version_number%TYPE;
275: --
276: begin
277: --
278: hr_utility.set_location('Entering:'|| l_proc, 10);
279: --
280: -- Issue a savepoint if operating in validation only mode
281: --
282: savepoint delete_WORKSHEET_BDGT_ELMNT;

Line 284: hr_utility.set_location(l_proc, 20);

280: -- Issue a savepoint if operating in validation only mode
281: --
282: savepoint delete_WORKSHEET_BDGT_ELMNT;
283: --
284: hr_utility.set_location(l_proc, 20);
285: --
286: -- Process Logic
287: --
288: l_object_version_number := p_object_version_number;

Line 337: hr_utility.set_location(l_proc, 60);

333: -- End of API User Hook for the after hook of delete_WORKSHEET_BDGT_ELMNT
334: --
335: end;
336: --
337: hr_utility.set_location(l_proc, 60);
338: --
339: -- When in validation only mode raise the Validate_Enabled exception
340: --
341: if p_validate then

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

341: if p_validate then
342: raise hr_api.validate_enabled;
343: end if;
344: --
345: hr_utility.set_location(' Leaving:'||l_proc, 70);
346: --
347: exception
348: --
349: when hr_api.validate_enabled then

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

383: l_proc varchar2(72) := g_package||'lck';
384: --
385: begin
386: --
387: hr_utility.set_location('Entering:'|| l_proc, 10);
388: --
389: PQH_WEL_shd.lck
390: (
391: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id

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

391: p_worksheet_bdgt_elmnt_id => p_worksheet_bdgt_elmnt_id
392: ,p_object_version_number => p_object_version_number
393: );
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 70);
396: --
397: end lck;
398: --
399: end pqh_WORKSHEET_BDGT_ELMNTS_api;