DBA Data[Home] [Help]

APPS.BEN_PRTT_CLM_GD_R_SVC_TYP_API dependencies on HR_UTILITY

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

39:
40: l_dummy_var varchar2(1) ;
41:
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: p_ctfn_rqd_flag := 'N' ;
45: if p_prtt_reimbmt_rqst_id is not null then
46: open c_pct_remb ;
47: fetch c_pct_remb into l_dummy_var ;

Line 62: hr_utility.set_location('Result:'|| p_ctfn_rqd_flag, 15);

58: close c_pct_gdsvc ;
59:
60: end if;
61:
62: hr_utility.set_location('Result:'|| p_ctfn_rqd_flag, 15);
63: hr_utility.set_location('Exiting:'|| l_proc, 10);
64: end check_remb_rqst_ctfn_rqs ;
65:
66:

Line 63: hr_utility.set_location('Exiting:'|| l_proc, 10);

59:
60: end if;
61:
62: hr_utility.set_location('Result:'|| p_ctfn_rqd_flag, 15);
63: hr_utility.set_location('Exiting:'|| l_proc, 10);
64: end check_remb_rqst_ctfn_rqs ;
65:
66:
67: -- ----------------------------------------------------------------------------

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

97:
98: l_dummy_var varchar2(1) ;
99:
100: begin
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: p_ctfn_pending_flag := 'N' ;
103: if p_prtt_reimbmt_rqst_id is not null then
104: open c_pqc_prc ;
105: fetch c_pqc_prc into l_dummy_var ;

Line 120: hr_utility.set_location('Result:'|| p_ctfn_pending_flag , 15);

116: close c_pqc_gdsvc ;
117:
118: end if;
119:
120: hr_utility.set_location('Result:'|| p_ctfn_pending_flag , 15);
121: hr_utility.set_location('Exiting:'|| l_proc, 10);
122: end check_remb_rqst_ctfn_prvdd ;
123:
124:

Line 121: hr_utility.set_location('Exiting:'|| l_proc, 10);

117:
118: end if;
119:
120: hr_utility.set_location('Result:'|| p_ctfn_pending_flag , 15);
121: hr_utility.set_location('Exiting:'|| l_proc, 10);
122: end check_remb_rqst_ctfn_prvdd ;
123:
124:
125: -- ----------------------------------------------------------------------------

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

171: l_effective_start_date date ;
172: l_effective_end_date date ;
173: l_object_version_number number(9);
174: Begin
175: hr_utility.set_location ('Entering '||l_proc,10);
176: open c_pqc ;
177: fetch c_pqc into l_dummy_var ;
178: if c_pqc%found then
179: l_write_ctfn := FALSE ;

Line 180: hr_utility.set_location('certifacte eixist ' , 11);

176: open c_pqc ;
177: fetch c_pqc into l_dummy_var ;
178: if c_pqc%found then
179: l_write_ctfn := FALSE ;
180: hr_utility.set_location('certifacte eixist ' , 11);
181: end if ;
182: close c_pqc ;
183: ---validate rule
184: hr_utility.set_location('formula'|| p_ctfn_rqd_when_rl , 11);

Line 184: hr_utility.set_location('formula'|| p_ctfn_rqd_when_rl , 11);

180: hr_utility.set_location('certifacte eixist ' , 11);
181: end if ;
182: close c_pqc ;
183: ---validate rule
184: hr_utility.set_location('formula'|| p_ctfn_rqd_when_rl , 11);
185:
186: if l_write_ctfn and p_ctfn_rqd_when_rl is not null then
187: --pl id and assg id
188: open c_Asg ;

Line 191: hr_utility.set_location('calling formula' , 11);

187: --pl id and assg id
188: open c_Asg ;
189: fetch c_asg into l_asg ;
190: close c_asg ;
191: hr_utility.set_location('calling formula' , 11);
192: --
193: l_outputs := benutils.formula
194: (p_formula_id => p_ctfn_rqd_when_rl
195: ,p_pl_id => l_asg.pl_id

Line 224: hr_utility.set_location ('Leaving ' ||l_proc,10);

220: );
221:
222:
223: end if ;
224: hr_utility.set_location ('Leaving ' ||l_proc,10);
225:
226: End write_remb_rqst_ctfn ;
227:
228:

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

290: effective_end_date ;
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);
295: --
296: -- Issue a savepoint if operating in validation only mode
297: --
298: savepoint create_PRTT_CLM_GD_R_SVC_TYP;

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

296: -- Issue a savepoint if operating in validation only mode
297: --
298: savepoint create_PRTT_CLM_GD_R_SVC_TYP;
299: --
300: hr_utility.set_location(l_proc, 20);
301: --
302: -- Process Logic
303: --
304: begin

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

477: -- End of API User Hook for the after hook of create_PRTT_CLM_GD_R_SVC_TYP
478: --
479: end;
480: --
481: hr_utility.set_location(l_proc, 60);
482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: if p_validate then

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

490: --
491: p_prtt_clm_gd_or_svc_typ_id := l_prtt_clm_gd_or_svc_typ_id;
492: p_object_version_number := l_object_version_number;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --
496: exception
497: --
498: when hr_api.validate_enabled then

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

507: -- when validation only mode is being used.)
508: --
509: p_prtt_clm_gd_or_svc_typ_id := null;
510: p_object_version_number := null;
511: hr_utility.set_location(' Leaving:'||l_proc, 80);
512: --
513: when others then
514: --
515: -- A validation or unexpected error has occured

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

516: --
517: ROLLBACK TO create_PRTT_CLM_GD_R_SVC_TYP;
518: p_prtt_clm_gd_or_svc_typ_id := null;
519: p_object_version_number := null;
520: hr_utility.set_location(' Leaving:'||l_proc, 90);
521: raise;
522: --
523: end create_PRTT_CLM_GD_R_SVC_TYP;
524: -- ----------------------------------------------------------------------------

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

585:
586: --
587: begin
588: --
589: hr_utility.set_location('Entering:'|| l_proc, 10);
590: --
591: -- Issue a savepoint if operating in validation only mode
592: --
593: savepoint update_PRTT_CLM_GD_R_SVC_TYP;

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

591: -- Issue a savepoint if operating in validation only mode
592: --
593: savepoint update_PRTT_CLM_GD_R_SVC_TYP;
594: --
595: hr_utility.set_location(l_proc, 20);
596: --
597: -- Process Logic
598: --
599: l_object_version_number := p_object_version_number;

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

776: -- End of API User Hook for the after hook of update_PRTT_CLM_GD_R_SVC_TYP
777: --
778: end;
779: --
780: hr_utility.set_location(l_proc, 60);
781: --
782: -- When in validation only mode raise the Validate_Enabled exception
783: --
784: if p_validate then

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

788: -- Set all output arguments
789: --
790: p_object_version_number := l_object_version_number;
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: --
794: exception
795: --
796: when hr_api.validate_enabled then

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

803: -- Only set output warning arguments
804: -- (Any key or derived arguments must be set to null
805: -- when validation only mode is being used.)
806: --
807: hr_utility.set_location(' Leaving:'||l_proc, 80);
808: --
809: when others then
810: --
811: -- A validation or unexpected error has occured

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

810: --
811: -- A validation or unexpected error has occured
812: --
813: ROLLBACK TO update_PRTT_CLM_GD_R_SVC_TYP;
814: hr_utility.set_location(' Leaving:'||l_proc, 90);
815: raise;
816: --
817: end update_PRTT_CLM_GD_R_SVC_TYP;
818: -- ----------------------------------------------------------------------------

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

832: l_object_version_number ben_prtt_clm_gd_or_svc_typ.object_version_number%TYPE;
833: --
834: begin
835: --
836: hr_utility.set_location('Entering:'|| l_proc, 10);
837: --
838: -- Issue a savepoint if operating in validation only mode
839: --
840: savepoint delete_PRTT_CLM_GD_R_SVC_TYP;

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

838: -- Issue a savepoint if operating in validation only mode
839: --
840: savepoint delete_PRTT_CLM_GD_R_SVC_TYP;
841: --
842: hr_utility.set_location(l_proc, 20);
843: --
844: -- Process Logic
845: --
846: l_object_version_number := p_object_version_number;

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

894: -- End of API User Hook for the after hook of delete_PRTT_CLM_GD_R_SVC_TYP
895: --
896: end;
897: --
898: hr_utility.set_location(l_proc, 60);
899: --
900: -- When in validation only mode raise the Validate_Enabled exception
901: --
902: if p_validate then

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

902: if p_validate then
903: raise hr_api.validate_enabled;
904: end if;
905: --
906: hr_utility.set_location(' Leaving:'||l_proc, 70);
907: --
908: exception
909: --
910: when hr_api.validate_enabled then

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

923: --
924: -- A validation or unexpected error has occured
925: --
926: ROLLBACK TO delete_PRTT_CLM_GD_R_SVC_TYP;
927: hr_utility.set_location(' Leaving:'||l_proc, 90);
928: raise;
929: --
930: end delete_PRTT_CLM_GD_R_SVC_TYP;
931: --

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

945: l_proc varchar2(72) := g_package||'lck';
946: --
947: begin
948: --
949: hr_utility.set_location('Entering:'|| l_proc, 10);
950: --
951: ben_pcg_shd.lck
952: (
953: p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id

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

953: p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id
954: ,p_object_version_number => p_object_version_number
955: );
956: --
957: hr_utility.set_location(' Leaving:'||l_proc, 70);
958: --
959: end lck;
960: --
961: end ben_PRTT_CLM_GD_R_SVC_TYP_api;