129: p_is_iban_acc IN varchar2 ) RETURN NUMBER IS
130: --
131: l_ret NUMBER ;
132: begin
133: -- hr_utility.trace_on(null,'ACCVAL');
134: l_ret :=0;
135: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
136: hr_utility.set_location('p_account_number ' || p_acc_no,1);
137:
131: l_ret NUMBER ;
132: begin
133: -- hr_utility.trace_on(null,'ACCVAL');
134: l_ret :=0;
135: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
136: hr_utility.set_location('p_account_number ' || p_acc_no,1);
137:
138: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
139: l_ret := validate_account_number(p_acc_no);
132: begin
133: -- hr_utility.trace_on(null,'ACCVAL');
134: l_ret :=0;
135: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
136: hr_utility.set_location('p_account_number ' || p_acc_no,1);
137:
138: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
139: l_ret := validate_account_number(p_acc_no);
140: hr_utility.set_location('l_ret ' || l_ret,1);
136: hr_utility.set_location('p_account_number ' || p_acc_no,1);
137:
138: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
139: l_ret := validate_account_number(p_acc_no);
140: hr_utility.set_location('l_ret ' || l_ret,1);
141: RETURN l_ret;
142: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
143: l_ret := validate_iban_acc(p_acc_no);
144: hr_utility.set_location('l_ret ' || l_ret,3);
140: hr_utility.set_location('l_ret ' || l_ret,1);
141: RETURN l_ret;
142: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
143: l_ret := validate_iban_acc(p_acc_no);
144: hr_utility.set_location('l_ret ' || l_ret,3);
145: RETURN l_ret;
146: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
147: hr_utility.set_location('Both Account Nos Null',4);
148: RETURN 1;
143: l_ret := validate_iban_acc(p_acc_no);
144: hr_utility.set_location('l_ret ' || l_ret,3);
145: RETURN l_ret;
146: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
147: hr_utility.set_location('Both Account Nos Null',4);
148: RETURN 1;
149: ELSE
150: hr_utility.set_location('l_ret: 3 ' ,5);
151: RETURN 3;
146: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
147: hr_utility.set_location('Both Account Nos Null',4);
148: RETURN 1;
149: ELSE
150: hr_utility.set_location('l_ret: 3 ' ,5);
151: RETURN 3;
152: END if;
153: End validate_account_entered;
154: