DBA Data[Home] [Help]

APPS.GHR_DUTY_STATION_API dependencies on HR_UTILITY

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

39: l_effective_end_date date;
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Issue a savepoint if operating in validation only mode
46: --
47: savepoint create_duty_stations;

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

45: -- Issue a savepoint if operating in validation only mode
46: --
47: savepoint create_duty_stations;
48: --
49: hr_utility.set_location(l_proc, 20);
50: --
51: -- Process Logic
52: --
53: -- Truncate the time portion from all IN date parameters

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

136: -- End of API User Hook for the after hook of create_noac_remarks
137: --
138: end;
139: --
140: hr_utility.set_location(l_proc, 60);
141: --
142: -- When in validation only mode raise the Validate_Enabled exception
143: --
144: if p_validate then

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

151: p_effective_start_date := l_effective_start_date;
152: p_effective_end_date := l_effective_end_date;
153: p_object_version_number := l_object_version_number;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 70);
156: --
157: exception
158: --
159: when hr_api.validate_enabled then

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

168: -- when validation only mode is being used.)
169: --
170: p_duty_station_id := l_duty_station_id;
171: p_object_version_number := l_object_version_number;
172: hr_utility.set_location(' Leaving:'||l_proc, 80);
173: --
174: when others then
175: --
176: -- A validation or unexpected error has occured

Line 181: hr_utility.set_location(' Leaving:'||l_proc, 12);

177: --
178: ROLLBACK TO create_duty_stations;
179: raise;
180:
181: hr_utility.set_location(' Leaving:'||l_proc, 12);
182:
183: end create_duty_station;
184: --
185:

Line 219: hr_utility.set_location('Entering:'|| l_proc, 5);

215: l_object_version_number ghr_duty_stations_f.object_version_number%TYPE;
216:
217: begin
218:
219: hr_utility.set_location('Entering:'|| l_proc, 5);
220: --
221: savepoint update_duty_stations;
222: --
223: -- Call Before Process User Hook

Line 255: hr_utility.set_location(l_proc, 6);

251: -- Store the original ovn in case we rollback when p_validate is true
252: --
253: -- l_object_version_number := p_object_version_number;
254:
255: hr_utility.set_location(l_proc, 6);
256: ghr_dut_upd.upd (
257: p_duty_station_id => p_duty_station_id
258: ,p_effective_start_date => l_effective_start_date
259: ,p_effective_end_date => l_effective_end_date

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

309: p_effective_start_date := l_effective_start_date;
310: p_effective_end_date := l_effective_end_date;
311: p_object_version_number := l_object_version_number;
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 11);
314: exception
315: when hr_api.validate_enabled then
316: --
317: -- As the Validate_Enabled exception has been raised

Line 331: hr_utility.set_location(' Leaving:'||l_proc, 12);

327: When Others then
328: ROLLBACK TO update_duty_stations;
329: raise;
330:
331: hr_utility.set_location(' Leaving:'||l_proc, 12);
332: end update_duty_station;
333:
334: --
335: --

Line 359: hr_utility.set_location('Entering:'|| l_proc, 5);

355: l_effective_end_date date;
356: --
357:
358: begin
359: hr_utility.set_location('Entering:'|| l_proc, 5);
360: --
361: --
362: savepoint delete_duty_station;
363: --

Line 368: hr_utility.set_location('1.p_validate is true',10);

364: --
365: -- Call Before Process User Hook
366: --
367: IF p_validate then
368: hr_utility.set_location('1.p_validate is true',10);
369: else
370: hr_utility.set_location('1.p_validate is false',20);
371: End If;
372:

Line 370: hr_utility.set_location('1.p_validate is false',20);

366: --
367: IF p_validate then
368: hr_utility.set_location('1.p_validate is true',10);
369: else
370: hr_utility.set_location('1.p_validate is false',20);
371: End If;
372:
373: begin
374: ghr_duty_station_bk3.delete_duty_station_b (

Line 379: hr_utility.set_location('2.p_validate is true',10);

375: p_duty_station_id => p_duty_station_id
376: ,p_object_version_number => p_object_version_number
377: );
378: IF p_validate then
379: hr_utility.set_location('2.p_validate is true',10);
380: else
381: hr_utility.set_location('2.p_validate is false',20);
382: End If;
383: exception

Line 381: hr_utility.set_location('2.p_validate is false',20);

377: );
378: IF p_validate then
379: hr_utility.set_location('2.p_validate is true',10);
380: else
381: hr_utility.set_location('2.p_validate is false',20);
382: End If;
383: exception
384: when hr_api.cannot_find_prog_unit then
385: hr_api.cannot_find_prog_unit_error

Line 393: hr_utility.set_location(l_proc, 7);

389: end;
390: --
391: -- End of Before Process User Hook call
392: --
393: hr_utility.set_location(l_proc, 7);
394:
395: --
396: -- Process Logic - Delete duty_station details if the specific duty_station_id is not required
397: -- for the first_noa_id specified for the pa_request_id

Line 400: hr_utility.set_location('3.p_validate is true',10);

396: -- Process Logic - Delete duty_station details if the specific duty_station_id is not required
397: -- for the first_noa_id specified for the pa_request_id
398: -- and for the second_noa_id
399: IF p_validate then
400: hr_utility.set_location('3.p_validate is true',10);
401: else
402: hr_utility.set_location('3.p_validate is false',20);
403: End If;
404:

Line 402: hr_utility.set_location('3.p_validate is false',20);

398: -- and for the second_noa_id
399: IF p_validate then
400: hr_utility.set_location('3.p_validate is true',10);
401: else
402: hr_utility.set_location('3.p_validate is false',20);
403: End If;
404:
405: ghr_dut_del.del
406: (p_duty_station_id => p_duty_station_id

Line 415: hr_utility.set_location('4.p_validate is true',10);

411: ,p_datetrack_mode => p_datetrack_mode
412: );
413:
414: IF p_validate then
415: hr_utility.set_location('4.p_validate is true',10);
416: else
417: hr_utility.set_location('4.p_validate is false',20);
418: End If;
419:

Line 417: hr_utility.set_location('4.p_validate is false',20);

413:
414: IF p_validate then
415: hr_utility.set_location('4.p_validate is true',10);
416: else
417: hr_utility.set_location('4.p_validate is false',20);
418: End If;
419:
420: --
421: hr_utility.set_location(l_proc, 8);

Line 421: hr_utility.set_location(l_proc, 8);

417: hr_utility.set_location('4.p_validate is false',20);
418: End If;
419:
420: --
421: hr_utility.set_location(l_proc, 8);
422: --
423: --
424: -- Call After Process User Hook
425: --

Line 428: hr_utility.set_location('5.p_validate is true',10);

424: -- Call After Process User Hook
425: --
426: begin
427: IF p_validate then
428: hr_utility.set_location('5.p_validate is true',10);
429: else
430: hr_utility.set_location('5.p_validate is false',20);
431: End If;
432: ghr_duty_station_bk3.delete_duty_station_a (

Line 430: hr_utility.set_location('5.p_validate is false',20);

426: begin
427: IF p_validate then
428: hr_utility.set_location('5.p_validate is true',10);
429: else
430: hr_utility.set_location('5.p_validate is false',20);
431: End If;
432: ghr_duty_station_bk3.delete_duty_station_a (
433: p_duty_station_id => p_duty_station_id
434: ,p_object_version_number => p_object_version_number

Line 437: hr_utility.set_location('6.p_validate is true',10);

433: p_duty_station_id => p_duty_station_id
434: ,p_object_version_number => p_object_version_number
435: );
436: IF p_validate then
437: hr_utility.set_location('6.p_validate is true',10);
438: else
439: hr_utility.set_location('6.p_validate is false',20);
440: End If;
441: exception

Line 439: hr_utility.set_location('6.p_validate is false',20);

435: );
436: IF p_validate then
437: hr_utility.set_location('6.p_validate is true',10);
438: else
439: hr_utility.set_location('6.p_validate is false',20);
440: End If;
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error

Line 454: hr_utility.set_location('inside validate',10);

450: --
451: -- When in validation only mode raise the Validate_Enabled exception
452: --
453: if p_validate then
454: hr_utility.set_location('inside validate',10);
455: raise hr_api.validate_enabled;
456: end if;
457: P_effective_start_date := l_effective_start_date;
458: p_effective_end_date := l_effective_end_date;

Line 460: hr_utility.set_location(' Leaving:'||l_proc, 11);

456: end if;
457: P_effective_start_date := l_effective_start_date;
458: p_effective_end_date := l_effective_end_date;
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 11);
461: exception
462: when hr_api.validate_enabled then
463: --
464: -- As the Validate_Enabled exception has been raised

Line 467: hr_utility.set_location('inside validate exception',20);

463: --
464: -- As the Validate_Enabled exception has been raised
465: -- we must rollback to the savepoint
466: --
467: hr_utility.set_location('inside validate exception',20);
468: ROLLBACK TO delete_duty_station;
469: p_effective_start_date := l_effective_start_date;
470: p_effective_end_date := l_effective_end_date;
471: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 471: hr_utility.set_location(' Leaving:'||l_proc, 25);

467: hr_utility.set_location('inside validate exception',20);
468: ROLLBACK TO delete_duty_station;
469: p_effective_start_date := l_effective_start_date;
470: p_effective_end_date := l_effective_end_date;
471: hr_utility.set_location(' Leaving:'||l_proc, 25);
472: --
473: When Others then
474: ROLLBACK TO delete_duty_station;
475: raise;

Line 476: hr_utility.set_location(' Leaving:'||l_proc, 12);

472: --
473: When Others then
474: ROLLBACK TO delete_duty_station;
475: raise;
476: hr_utility.set_location(' Leaving:'||l_proc, 12);
477: end delete_duty_station;
478: --
479: --
480: end ghr_duty_station_api;