DBA Data[Home] [Help]

APPS.HR_DE_UTILITY dependencies on HR_UTILITY

Line 136: hr_utility.set_location('IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no) ' || l_iban_ret_val,99);

132:
133: l_iban_ret_val NUMBER;
134: BEGIN
135: l_iban_ret_val := IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no);
136: hr_utility.set_location('IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no) ' || l_iban_ret_val,99);
137: /* IF IBAN_VALIDATION_PKG.validate_iban_acc(p_account_no) = 1 then
138: RETURN 1;
139: else
140: RETURN 0;

Line 156: -- hr_utility.trace_on(null,'DEACCVAL');

152: p_iban_acc in varchar2 default null) RETURN NUMBER IS
153: --
154: l_ret NUMBER ;
155: begin
156: -- hr_utility.trace_on(null,'DEACCVAL');
157: l_ret :=0;
158: hr_utility.set_location('p_account_number ' || p_acc_no,1);
159: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
160: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);

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

154: l_ret NUMBER ;
155: begin
156: -- hr_utility.trace_on(null,'DEACCVAL');
157: l_ret :=0;
158: hr_utility.set_location('p_account_number ' || p_acc_no,1);
159: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
160: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
161: -- hr_utility.set_location('p_bank_code ' || p_bank_code,1);
162:

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

155: begin
156: -- hr_utility.trace_on(null,'DEACCVAL');
157: l_ret :=0;
158: hr_utility.set_location('p_account_number ' || p_acc_no,1);
159: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
160: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
161: -- hr_utility.set_location('p_bank_code ' || p_bank_code,1);
162:
163: /* checking if either of the two account number are present , then return true*/

Line 160: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);

156: -- hr_utility.trace_on(null,'DEACCVAL');
157: l_ret :=0;
158: hr_utility.set_location('p_account_number ' || p_acc_no,1);
159: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
160: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
161: -- hr_utility.set_location('p_bank_code ' || p_bank_code,1);
162:
163: /* checking if either of the two account number are present , then return true*/
164:

Line 161: -- hr_utility.set_location('p_bank_code ' || p_bank_code,1);

157: l_ret :=0;
158: hr_utility.set_location('p_account_number ' || p_acc_no,1);
159: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
160: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
161: -- hr_utility.set_location('p_bank_code ' || p_bank_code,1);
162:
163: /* checking if either of the two account number are present , then return true*/
164:
165: IF p_is_iban_acc = 'C' and (p_acc_no is not null or p_iban_acc is not null) then

Line 166: hr_utility.set_location(' inside first if',1);

162:
163: /* checking if either of the two account number are present , then return true*/
164:
165: IF p_is_iban_acc = 'C' and (p_acc_no is not null or p_iban_acc is not null) then
166: hr_utility.set_location(' inside first if',1);
167: return 0;
168: end if;
169:
170: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then

Line 172: hr_utility.set_location('l_ret ' || l_ret,2);

168: end if;
169:
170: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
171: l_ret:= 0;
172: hr_utility.set_location('l_ret ' || l_ret,2);
173:
174: RETURN l_ret;
175:
176: ELSIF (p_iban_acc IS NOT NULL AND p_is_iban_acc = 'Y') then

Line 178: hr_utility.set_location('l_ret ' || l_ret,4);

174: RETURN l_ret;
175:
176: ELSIF (p_iban_acc IS NOT NULL AND p_is_iban_acc = 'Y') then
177: l_ret := validate_iban_acc(p_iban_acc);
178: hr_utility.set_location('l_ret ' || l_ret,4);
179: RETURN l_ret;
180:
181: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
182: hr_utility.set_location('Both Account Nos Null',5);

Line 182: hr_utility.set_location('Both Account Nos Null',5);

178: hr_utility.set_location('l_ret ' || l_ret,4);
179: RETURN l_ret;
180:
181: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
182: hr_utility.set_location('Both Account Nos Null',5);
183: RETURN 1;
184:
185: ELSE
186: hr_utility.set_location('l_ret: 3 ' ,6);

Line 186: hr_utility.set_location('l_ret: 3 ' ,6);

182: hr_utility.set_location('Both Account Nos Null',5);
183: RETURN 1;
184:
185: ELSE
186: hr_utility.set_location('l_ret: 3 ' ,6);
187: RETURN 3;
188: END if;
189: End validate_account_entered;
190: