DBA Data[Home] [Help]

APPS.BEN_ELIG_CBR_QUALD_BNF_API dependencies on HR_UTILITY

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

66: l_object_version_number ben_elig_cbr_quald_bnf_f.object_version_number%TYPE;
67: --
68: begin
69: --
70: hr_utility.set_location('Entering:'|| l_proc, 10);
71: --
72: -- Issue a savepoint if operating in validation only mode
73: --
74: savepoint create_ELIG_CBR_QUALD_BNF;

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

72: -- Issue a savepoint if operating in validation only mode
73: --
74: savepoint create_ELIG_CBR_QUALD_BNF;
75: --
76: hr_utility.set_location(l_proc, 20);
77: --
78: -- Process Logic
79: --
80: begin

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

254: p_base_table_reference_column => 'ELIG_CBR_QUALD_BNF_FLAG',
255: p_reference_table => 'BEN_ELIG_CBR_QUALD_BNF_F',
256: p_reference_table_column => 'ELIGY_PRFL_ID');
257: --
258: hr_utility.set_location(l_proc, 60);
259: --
260: -- When in validation only mode raise the Validate_Enabled exception
261: --
262: if p_validate then

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

269: p_effective_start_date := l_effective_start_date;
270: p_effective_end_date := l_effective_end_date;
271: p_object_version_number := l_object_version_number;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 70);
274: --
275: exception
276: --
277: when hr_api.validate_enabled then

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

288: p_elig_cbr_quald_bnf_id := null;
289: p_effective_start_date := null;
290: p_effective_end_date := null;
291: p_object_version_number := null;
292: hr_utility.set_location(' Leaving:'||l_proc, 80);
293: --
294: when others then
295: --
296: -- A validation or unexpected error has occured

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

298: p_elig_cbr_quald_bnf_id := null;
299: p_effective_start_date := null;
300: p_effective_end_date := null;
301: p_object_version_number := null;
302: hr_utility.set_location(' Leaving:'||l_proc, 80);
303: --
304: ROLLBACK TO create_ELIG_CBR_QUALD_BNF;
305: raise;
306: --

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

366: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
367: --
368: begin
369: --
370: hr_utility.set_location('Entering:'|| l_proc, 10);
371: --
372: -- Issue a savepoint if operating in validation only mode
373: --
374: savepoint update_ELIG_CBR_QUALD_BNF;

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

372: -- Issue a savepoint if operating in validation only mode
373: --
374: savepoint update_ELIG_CBR_QUALD_BNF;
375: --
376: hr_utility.set_location(l_proc, 20);
377: --
378: -- Process Logic
379: --
380: l_object_version_number := p_object_version_number;

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

551: -- End of API User Hook for the after hook of update_ELIG_CBR_QUALD_BNF
552: --
553: end;
554: --
555: hr_utility.set_location(l_proc, 60);
556: --
557: -- When in validation only mode raise the Validate_Enabled exception
558: --
559: if p_validate then

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

565: p_object_version_number := l_object_version_number;
566: p_effective_start_date := l_effective_start_date;
567: p_effective_end_date := l_effective_end_date;
568: --
569: hr_utility.set_location(' Leaving:'||l_proc, 70);
570: --
571: exception
572: --
573: when hr_api.validate_enabled then

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

580: -- Only set output warning arguments
581: -- (Any key or derived arguments must be set to null
582: -- when validation only mode is being used.)
583: --
584: hr_utility.set_location(' Leaving:'||l_proc, 80);
585: --
586: when others then
587: --
588: -- A validation or unexpected error has occured

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

589: --
590: p_effective_start_date := null;
591: p_effective_end_date := null;
592: p_object_version_number := l_object_version_number;
593: hr_utility.set_location(' Leaving:'||l_proc, 80);
594: --
595: ROLLBACK TO update_ELIG_CBR_QUALD_BNF;
596: raise;
597: --

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

618: l_effective_end_date ben_elig_cbr_quald_bnf_f.effective_end_date%TYPE;
619: --
620: begin
621: --
622: hr_utility.set_location('Entering:'|| l_proc, 10);
623: --
624: -- Issue a savepoint if operating in validation only mode
625: --
626: savepoint delete_ELIG_CBR_QUALD_BNF;

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

624: -- Issue a savepoint if operating in validation only mode
625: --
626: savepoint delete_ELIG_CBR_QUALD_BNF;
627: --
628: hr_utility.set_location(l_proc, 20);
629: --
630: -- Process Logic
631: --
632: l_object_version_number := p_object_version_number;

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

696: p_base_table_reference_column => 'ELIG_CBR_QUALD_BNF_FLAG',
697: p_reference_table => 'BEN_ELIG_CBR_QUALD_BNF_F',
698: p_reference_table_column => 'ELIGY_PRFL_ID');
699: --
700: hr_utility.set_location(l_proc, 60);
701: --
702: -- When in validation only mode raise the Validate_Enabled exception
703: --
704: if p_validate then

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

704: if p_validate then
705: raise hr_api.validate_enabled;
706: end if;
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 70);
709: --
710: exception
711: --
712: when hr_api.validate_enabled then

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

729: --
730: p_effective_start_date := null;
731: p_effective_end_date := null;
732: p_object_version_number := l_object_version_number;
733: hr_utility.set_location(' Leaving:'||l_proc, 80);
734: --
735: ROLLBACK TO delete_ELIG_CBR_QUALD_BNF;
736: raise;
737: --

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

759: l_validation_end_date date;
760: --
761: begin
762: --
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: --
765: ben_ecq_shd.lck
766: (
767: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id

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

771: ,p_effective_date => p_effective_date
772: ,p_datetrack_mode => p_datetrack_mode
773: );
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 70);
776: --
777: end lck;
778: --
779: end ben_ELIG_CBR_QUALD_BNF_api;