DBA Data[Home] [Help]

APPS.IT_BANK_DETAILS_PKG dependencies on HR_UTILITY

Line 243: -- hr_utility.trace_on(null,'ITACCVAL');

239: , p_is_iban_acc IN varchar2) RETURN NUMBER IS
240: --
241: l_ret NUMBER ;
242: begin
243: -- hr_utility.trace_on(null,'ITACCVAL');
244: l_ret :=0;
245: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
246: hr_utility.set_location('p_account_number ' || p_account_number,1);
247:

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

241: l_ret NUMBER ;
242: begin
243: -- hr_utility.trace_on(null,'ITACCVAL');
244: l_ret :=0;
245: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
246: hr_utility.set_location('p_account_number ' || p_account_number,1);
247:
248: IF (p_account_number IS NOT NULL AND p_is_iban_acc = 'N') then
249: l_ret := validate_non_iban_acc(p_account_number);

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

242: begin
243: -- hr_utility.trace_on(null,'ITACCVAL');
244: l_ret :=0;
245: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
246: hr_utility.set_location('p_account_number ' || p_account_number,1);
247:
248: IF (p_account_number IS NOT NULL AND p_is_iban_acc = 'N') then
249: l_ret := validate_non_iban_acc(p_account_number);
250: hr_utility.set_location('l_ret ' || l_ret,1);

Line 250: hr_utility.set_location('l_ret ' || l_ret,1);

246: hr_utility.set_location('p_account_number ' || p_account_number,1);
247:
248: IF (p_account_number IS NOT NULL AND p_is_iban_acc = 'N') then
249: l_ret := validate_non_iban_acc(p_account_number);
250: hr_utility.set_location('l_ret ' || l_ret,1);
251: RETURN l_ret;
252: ELSIF (p_account_number IS NOT NULL AND p_is_iban_acc = 'Y') then
253: l_ret := validate_iban_acc(p_account_number);
254: hr_utility.set_location('l_ret ' || l_ret,3);

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

250: hr_utility.set_location('l_ret ' || l_ret,1);
251: RETURN l_ret;
252: ELSIF (p_account_number IS NOT NULL AND p_is_iban_acc = 'Y') then
253: l_ret := validate_iban_acc(p_account_number);
254: hr_utility.set_location('l_ret ' || l_ret,3);
255: RETURN l_ret;
256: ELSIF (p_account_number IS NULL AND p_is_iban_acc IS NULL) then
257: hr_utility.set_location('Both Account Nos Null',4);
258: RETURN 1;

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

253: l_ret := validate_iban_acc(p_account_number);
254: hr_utility.set_location('l_ret ' || l_ret,3);
255: RETURN l_ret;
256: ELSIF (p_account_number IS NULL AND p_is_iban_acc IS NULL) then
257: hr_utility.set_location('Both Account Nos Null',4);
258: RETURN 1;
259: ELSE
260: hr_utility.set_location('l_ret: 3 ' ,5);
261: RETURN 3;

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

256: ELSIF (p_account_number IS NULL AND p_is_iban_acc IS NULL) then
257: hr_utility.set_location('Both Account Nos Null',4);
258: RETURN 1;
259: ELSE
260: hr_utility.set_location('l_ret: 3 ' ,5);
261: RETURN 3;
262: /*Changed for Bug 7028494 as changes done in default value of segments so that cross
263: validation rules are fired properly in self service pages */
264: END if;