DBA Data[Home] [Help]

APPS.HR_FORM_DATA_GROUPS_API dependencies on HR_UTILITY

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

29: l_proc varchar2(72) := g_package||'create_form_data_group';
30: l_form_data_group_id number;
31: l_object_version_number number;
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_form_data_group;

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

46: --
47: l_language_code := p_language_code;
48: hr_api.validate_language_code(p_language_code => l_language_code);
49: --
50: hr_utility.set_location(l_proc, 20);
51: --
52: --
53: -- Call Before Process User Hook
54: --

Line 76: hr_utility.set_location('At:'|| l_proc, 15);

72:
73: --
74: -- Process Logic
75: --
76: hr_utility.set_location('At:'|| l_proc, 15);
77:
78: hr_fdg_ins.ins(p_application_id => p_application_id
79: ,p_form_id => p_form_id
80: ,p_data_group_name => p_data_group_name

Line 84: hr_utility.set_location('At:'|| l_proc, 20);

80: ,p_data_group_name => p_data_group_name
81: ,p_form_data_group_id => l_form_data_group_id
82: ,p_object_version_number => l_object_version_number);
83:
84: hr_utility.set_location('At:'|| l_proc, 20);
85:
86: hr_fgt_ins.ins_tl( p_language_code => l_language_code
87: ,p_form_data_group_id => l_form_data_group_id
88: ,p_user_data_group_name => p_user_data_group_name

Line 91: hr_utility.set_location('At:'|| l_proc, 25);

87: ,p_form_data_group_id => l_form_data_group_id
88: ,p_user_data_group_name => p_user_data_group_name
89: ,p_description => p_description);
90:
91: hr_utility.set_location('At:'|| l_proc, 25);
92:
93: --
94: -- Call After Process User Hook
95: --

Line 118: hr_utility.set_location('At:'|| l_proc, 30);

114: end;
115: --
116: -- When in validation only mode raise the Validate_Enabled exception
117: --
118: hr_utility.set_location('At:'|| l_proc, 30);
119:
120: if p_validate then
121: raise hr_api.validate_enabled;
122: end if;

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

125: --
126: p_form_data_group_id := l_form_data_group_id;
127: p_object_version_number := l_object_version_number;
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 70);
130: exception
131: when hr_api.validate_enabled then
132: --
133: -- As the Validate_Enabled exception has been raised

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

140: -- when validation only mode is being used.)
141: --
142: p_form_data_group_id := null;
143: p_object_version_number := null;
144: hr_utility.set_location(' Leaving:'||l_proc, 80);
145: when others then
146: --
147: -- A validation or unexpected error has occured
148: --

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

149: rollback to create_form_data_group;
150: -- Reset out parameters.
151: p_form_data_group_id := null;
152: p_object_version_number := null;
153: hr_utility.set_location(' Leaving:'||l_proc, 90);
154: raise;
155: end create_form_data_group;
156: --
157: -- ----------------------------------------------------------------------------

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

174: WHERE form_data_group_id = p_form_data_group_id;
175:
176: l_proc varchar2(72) := g_package||'delete_form_data_group';
177: begin
178: hr_utility.set_location('Entering:'|| l_proc, 10);
179: --
180: -- Issue a savepoint
181: --
182: savepoint delete_form_data_group;

Line 201: hr_utility.set_location('At:'|| l_proc, 15);

197: end;
198: --
199: -- Process Logic
200: --
201: hr_utility.set_location('At:'|| l_proc, 15);
202:
203: hr_fdg_shd.lck( p_form_data_group_id => p_form_data_group_id
204: ,p_object_version_number => p_object_version_number);
205:

Line 206: hr_utility.set_location('At:'|| l_proc, 20);

202:
203: hr_fdg_shd.lck( p_form_data_group_id => p_form_data_group_id
204: ,p_object_version_number => p_object_version_number);
205:
206: hr_utility.set_location('At:'|| l_proc, 20);
207:
208: FOR cur_rec IN cur_data_group_item LOOP
209:
210: hr_form_data_group_items_api.delete_form_data_group_item(

Line 216: hr_utility.set_location('At:'|| l_proc, 30);

212: ,p_object_version_number => cur_rec.object_version_number);
213:
214: END LOOP;
215:
216: hr_utility.set_location('At:'|| l_proc, 30);
217:
218: hr_fgt_del.del_tl( p_form_data_group_id => p_form_data_group_id);
219:
220: hr_utility.set_location('At:'|| l_proc, 40);

Line 220: hr_utility.set_location('At:'|| l_proc, 40);

216: hr_utility.set_location('At:'|| l_proc, 30);
217:
218: hr_fgt_del.del_tl( p_form_data_group_id => p_form_data_group_id);
219:
220: hr_utility.set_location('At:'|| l_proc, 40);
221:
222: hr_fdg_del.del( p_form_data_group_id => p_form_data_group_id
223: ,p_object_version_number => p_object_version_number);
224:

Line 225: hr_utility.set_location('At:'|| l_proc, 50);

221:
222: hr_fdg_del.del( p_form_data_group_id => p_form_data_group_id
223: ,p_object_version_number => p_object_version_number);
224:
225: hr_utility.set_location('At:'|| l_proc, 50);
226:
227: --
228: -- Call After Process User Hook
229: --

Line 245: hr_utility.set_location('At:'|| l_proc, 60);

241: end;
242: --
243: -- When in validation only mode raise the Validate_Enabled exception
244: --
245: hr_utility.set_location('At:'|| l_proc, 60);
246:
247: if p_validate then
248: raise hr_api.validate_enabled;
249: end if;

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

247: if p_validate then
248: raise hr_api.validate_enabled;
249: end if;
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 70);
252: exception
253: when hr_api.validate_enabled then
254: --
255: -- As the Validate_Enabled exception has been raised

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

260: -- Only set output warning arguments
261: -- (Any key or derived arguments must be set to null
262: -- when validation only mode is being used.)
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 80);
265: when others then
266: --
267: -- A validation or unexpected error has occured
268: --

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

266: --
267: -- A validation or unexpected error has occured
268: --
269: rollback to delete_form_data_group;
270: hr_utility.set_location(' Leaving:'||l_proc, 90);
271: raise;
272: end delete_form_data_group;
273: --
274: -- ----------------------------------------------------------------------------

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

296: l_proc varchar2(72) := g_package||'update_form_data_group';
297: l_object_version_number number;
298: l_temp_ovn number := p_object_version_number;
299: begin
300: hr_utility.set_location('Entering:'|| l_proc, 10);
301: --
302: -- Issue a savepoint
303: --
304: savepoint update_form_data_group;

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

314: --
315: l_language_code := p_language_code;
316: hr_api.validate_language_code(p_language_code => l_language_code);
317: --
318: hr_utility.set_location(l_proc, 20);
319: --
320: --
321: -- Call Before Process User Hook
322: --

Line 346: hr_utility.set_location('At:'|| l_proc, 15);

342:
343: --
344: -- Process Logic
345: --
346: hr_utility.set_location('At:'|| l_proc, 15);
347:
348: hr_fdg_upd.upd( p_form_data_group_id => p_form_data_group_id
349: --,p_application_id => p_application_id
350: --,p_form_id => p_form_id

Line 354: hr_utility.set_location('At:'|| l_proc, 20);

350: --,p_form_id => p_form_id
351: ,p_data_group_name => p_data_group_name
352: ,p_object_version_number => l_object_version_number);
353:
354: hr_utility.set_location('At:'|| l_proc, 20);
355:
356: hr_fgt_upd.upd_tl( p_language_code => l_language_code
357: ,p_form_data_group_id => p_form_data_group_id
358: ,p_user_data_group_name => p_user_data_group_name

Line 361: hr_utility.set_location('At:'|| l_proc, 30);

357: ,p_form_data_group_id => p_form_data_group_id
358: ,p_user_data_group_name => p_user_data_group_name
359: ,p_description => p_description);
360:
361: hr_utility.set_location('At:'|| l_proc, 30);
362:
363: --
364: -- Call After Process User Hook
365: --

Line 388: hr_utility.set_location('At:'|| l_proc, 40);

384: end;
385: --
386: -- When in validation only mode raise the Validate_Enabled exception
387: --
388: hr_utility.set_location('At:'|| l_proc, 40);
389:
390: if p_validate then
391: raise hr_api.validate_enabled;
392: end if;

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

394: -- Set all output arguments
395: --
396: p_object_version_number := l_object_version_number;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 70);
399: exception
400: when hr_api.validate_enabled then
401: --
402: -- As the Validate_Enabled exception has been raised

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

410: --
411: -- Reset all in out arguments
412: --
413: p_object_version_number := l_object_version_number;
414: hr_utility.set_location(' Leaving:'||l_proc, 80);
415: when others then
416: --
417: -- A validation or unexpected error has occured
418: --

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

419: rollback to update_form_data_group;
420: -- Reset all in out arguments
421: --
422: p_object_version_number := l_temp_ovn;
423: hr_utility.set_location(' Leaving:'||l_proc, 90);
424: raise;
425: end update_form_data_group;
426: --
427: end hr_form_data_groups_api;