11: ) is
12: p_var number;
13: begin
14: /* Added for GSI Bug 5472781 */
15: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'PL') THEN
16: hr_utility.trace('PL not installed.Leaving CREATE_PL_PERSONAL_PAY_METHOD');
17: return;
18: END IF;
19: p_var:=hr_pl_utility.validate_bank_id(p_segment2);
12: p_var number;
13: begin
14: /* Added for GSI Bug 5472781 */
15: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'PL') THEN
16: hr_utility.trace('PL not installed.Leaving CREATE_PL_PERSONAL_PAY_METHOD');
17: return;
18: END IF;
19: p_var:=hr_pl_utility.validate_bank_id(p_segment2);
20:
33:
34: /* 9226630 */
35: IF p_segment12 is NOT NULL THEN -- 9226630
36: p_var:=hr_pl_utility.validate_iban_acc(p_segment12);
37: hr_utility.set_location('p_var :'|| p_var,1);
38: --hr_utility.trace_off;
39: if p_var=1 then
40: hr_utility.set_location('p_var :'|| p_var,2);
41: fnd_message.set_name('PAY','HR_PL_INVALID_IBAN_NO');
34: /* 9226630 */
35: IF p_segment12 is NOT NULL THEN -- 9226630
36: p_var:=hr_pl_utility.validate_iban_acc(p_segment12);
37: hr_utility.set_location('p_var :'|| p_var,1);
38: --hr_utility.trace_off;
39: if p_var=1 then
40: hr_utility.set_location('p_var :'|| p_var,2);
41: fnd_message.set_name('PAY','HR_PL_INVALID_IBAN_NO');
42: fnd_message.raise_error;
36: p_var:=hr_pl_utility.validate_iban_acc(p_segment12);
37: hr_utility.set_location('p_var :'|| p_var,1);
38: --hr_utility.trace_off;
39: if p_var=1 then
40: hr_utility.set_location('p_var :'|| p_var,2);
41: fnd_message.set_name('PAY','HR_PL_INVALID_IBAN_NO');
42: fnd_message.raise_error;
43: end if;
44: end if;
69:
70: begin
71:
72: /* Added for GSI Bug 5472781 */
73: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'PL') THEN
74: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSONAL_PAY_METHOD');
75: return;
76: END IF;
77:
70: begin
71:
72: /* Added for GSI Bug 5472781 */
73: IF NOT hr_utility.chk_product_install('Oracle Payroll', 'PL') THEN
74: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSONAL_PAY_METHOD');
75: return;
76: END IF;
77:
78: l_var1:=p_segment1;
107:
108: /* added by 9226630 */
109: if p_segment12 = hr_api.g_varchar2 then
110: l_var12 := l_seg12;
111: hr_utility.set_location('l_var12 :'|| l_var12,2);
112: end if;
113: /* end */
114:
115: if l_var3 is NOT NULL then --9226630