DBA Data[Home] [Help]

APPS.PER_NL_BANK_DETAILS_PKG dependencies on HR_UTILITY

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

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:

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

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);

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

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);

Line 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);

Line 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;

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

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;

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

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: