DBA Data[Home] [Help]

APPS.HR_IE_UTILITY dependencies on HR_UTILITY

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

23: ) RETURN NUMBER IS
24: --
25: l_ret NUMBER ;
26: BEGIN
27: -- hr_utility.trace_on(null,'ACCVAL');
28: l_ret :=0;
29: hr_utility.set_location('p_account_number ' || p_acc_no,1);
30: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
31: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);

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

25: l_ret NUMBER ;
26: BEGIN
27: -- hr_utility.trace_on(null,'ACCVAL');
28: l_ret :=0;
29: hr_utility.set_location('p_account_number ' || p_acc_no,1);
30: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
31: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
32:
33:

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

26: BEGIN
27: -- hr_utility.trace_on(null,'ACCVAL');
28: l_ret :=0;
29: hr_utility.set_location('p_account_number ' || p_acc_no,1);
30: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
31: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
32:
33:
34: IF p_is_iban_acc = 'C' AND (p_acc_no IS NOT NULL OR p_iban_acc IS NOT NULL) THEN

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

27: -- hr_utility.trace_on(null,'ACCVAL');
28: l_ret :=0;
29: hr_utility.set_location('p_account_number ' || p_acc_no,1);
30: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
31: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
32:
33:
34: IF p_is_iban_acc = 'C' AND (p_acc_no IS NOT NULL OR p_iban_acc IS NOT NULL) THEN
35: hr_utility.set_location(' inside first if',1);

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

31: hr_utility.set_location('p_iban_acc ' || p_iban_acc,1);
32:
33:
34: IF p_is_iban_acc = 'C' AND (p_acc_no IS NOT NULL OR p_iban_acc IS NOT NULL) THEN
35: hr_utility.set_location(' inside first if',1);
36: RETURN 0;
37: END IF;
38:
39: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') THEN

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

37: END IF;
38:
39: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') THEN
40: l_ret:= 0;
41: hr_utility.set_location('l_ret ' || l_ret,2);
42: RETURN l_ret;
43: ELSIF (p_iban_acc IS NOT NULL AND p_is_iban_acc = 'Y') THEN
44: l_ret := validate_iban_acc(p_iban_acc);
45: hr_utility.set_location('l_ret ' || l_ret,3);

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

41: hr_utility.set_location('l_ret ' || l_ret,2);
42: RETURN l_ret;
43: ELSIF (p_iban_acc IS NOT NULL AND p_is_iban_acc = 'Y') THEN
44: l_ret := validate_iban_acc(p_iban_acc);
45: hr_utility.set_location('l_ret ' || l_ret,3);
46: RETURN l_ret;
47: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) THEN
48: hr_utility.set_location('Both Account Nos Null',4);
49: RETURN 1;

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

44: l_ret := validate_iban_acc(p_iban_acc);
45: hr_utility.set_location('l_ret ' || l_ret,3);
46: RETURN l_ret;
47: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) THEN
48: hr_utility.set_location('Both Account Nos Null',4);
49: RETURN 1;
50: ELSE
51: hr_utility.set_location('l_ret: 3 ' ,5);
52: RETURN 3;

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

47: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) THEN
48: hr_utility.set_location('Both Account Nos Null',4);
49: RETURN 1;
50: ELSE
51: hr_utility.set_location('l_ret: 3 ' ,5);
52: RETURN 3;
53: END IF;
54: END validate_account_entered;
55: