DBA Data[Home] [Help]

APPS.HR_BE_VALIDATION dependencies on HR_UTILITY

Line 96: -- hr_utility.trace_on(null,'ACCVAL');

92: --
93: l_ret1 varchar2(20) ;
94: l_ret number;
95: begin
96: -- hr_utility.trace_on(null,'ACCVAL');
97: l_ret :=0;
98: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
99: hr_utility.set_location('p_account_number ' || p_acc_no,1);
100:

Line 98: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);

94: l_ret number;
95: begin
96: -- hr_utility.trace_on(null,'ACCVAL');
97: l_ret :=0;
98: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
99: hr_utility.set_location('p_account_number ' || p_acc_no,1);
100:
101: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
102: l_ret1 := bank_account_no(p_acc_no);

Line 99: hr_utility.set_location('p_account_number ' || p_acc_no,1);

95: begin
96: -- hr_utility.trace_on(null,'ACCVAL');
97: l_ret :=0;
98: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
99: hr_utility.set_location('p_account_number ' || p_acc_no,1);
100:
101: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
102: l_ret1 := bank_account_no(p_acc_no);
103: hr_utility.set_location('l_ret1 ' || l_ret1,1);

Line 103: hr_utility.set_location('l_ret1 ' || l_ret1,1);

99: hr_utility.set_location('p_account_number ' || p_acc_no,1);
100:
101: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
102: l_ret1 := bank_account_no(p_acc_no);
103: hr_utility.set_location('l_ret1 ' || l_ret1,1);
104: if l_ret1 = 'SUCCESS' then
105: return 0;
106: else
107: RETURN 1;

Line 111: hr_utility.set_location('l_ret ' || l_ret,3);

107: RETURN 1;
108: end if;
109: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
110: l_ret := validate_iban_acc(p_acc_no);
111: hr_utility.set_location('l_ret ' || l_ret,3);
112: RETURN l_ret;
113: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
114: hr_utility.set_location('Both Account Nos Null',4);
115: RETURN 1;

Line 114: hr_utility.set_location('Both Account Nos Null',4);

110: l_ret := validate_iban_acc(p_acc_no);
111: hr_utility.set_location('l_ret ' || l_ret,3);
112: RETURN l_ret;
113: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
114: hr_utility.set_location('Both Account Nos Null',4);
115: RETURN 1;
116: ELSE
117: hr_utility.set_location('l_ret: 3 ' ,5);
118: RETURN 3;

Line 117: hr_utility.set_location('l_ret: 3 ' ,5);

113: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
114: hr_utility.set_location('Both Account Nos Null',4);
115: RETURN 1;
116: ELSE
117: hr_utility.set_location('l_ret: 3 ' ,5);
118: RETURN 3;
119: END if;
120: End validate_account_entered;
121: --