DBA Data[Home] [Help]

APPS.PAY_US_PPM_HOOK dependencies on HR_UTILITY

Line 70: hr_utility.trace('l_is_foreign_trans : ' || l_is_foreign_trans);

66: from pay_org_payment_methods_f where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
67: AND p_effective_date BETWEEN effective_start_date
68: AND effective_end_date;
69:
70: hr_utility.trace('l_is_foreign_trans : ' || l_is_foreign_trans);
71:
72: if l_is_foreign_trans <> 'Y' or l_is_foreign_trans is null then
73: --Not IAT transaction
74: if length(P_SEGMENT3) > 17 then

Line 75: hr_utility.trace('Test 1');

71:
72: if l_is_foreign_trans <> 'Y' or l_is_foreign_trans is null then
73: --Not IAT transaction
74: if length(P_SEGMENT3) > 17 then
75: hr_utility.trace('Test 1');
76: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');
77: hr_utility.raise_error;
78: end if;
79:

Line 76: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');

72: if l_is_foreign_trans <> 'Y' or l_is_foreign_trans is null then
73: --Not IAT transaction
74: if length(P_SEGMENT3) > 17 then
75: hr_utility.trace('Test 1');
76: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');
77: hr_utility.raise_error;
78: end if;
79:
80: else

Line 77: hr_utility.raise_error;

73: --Not IAT transaction
74: if length(P_SEGMENT3) > 17 then
75: hr_utility.trace('Test 1');
76: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');
77: hr_utility.raise_error;
78: end if;
79:
80: else
81: --IAT transaction

Line 84: hr_utility.set_message(801, 'PAY_US_IAT_INVALD_TRANSIT_CODE');

80: else
81: --IAT transaction
82: if P_SEGMENT4 <> '000000000' then
83:
84: hr_utility.set_message(801, 'PAY_US_IAT_INVALD_TRANSIT_CODE');
85: hr_utility.raise_error;
86:
87: end if;
88:

Line 85: hr_utility.raise_error;

81: --IAT transaction
82: if P_SEGMENT4 <> '000000000' then
83:
84: hr_utility.set_message(801, 'PAY_US_IAT_INVALD_TRANSIT_CODE');
85: hr_utility.raise_error;
86:
87: end if;
88:
89: if (p_ppm_information1 is null) or

Line 93: hr_utility.set_message(801, 'PAY_US_IAT_NO_TRANSIT_CODE');

89: if (p_ppm_information1 is null) or
90: (p_ppm_information2 is null) or
91: (p_ppm_information3 is null) then
92:
93: hr_utility.set_message(801, 'PAY_US_IAT_NO_TRANSIT_CODE');
94: hr_utility.raise_error;
95: end if;
96:
97: end if;

Line 94: hr_utility.raise_error;

90: (p_ppm_information2 is null) or
91: (p_ppm_information3 is null) then
92:
93: hr_utility.set_message(801, 'PAY_US_IAT_NO_TRANSIT_CODE');
94: hr_utility.raise_error;
95: end if;
96:
97: end if;
98:

Line 172: hr_utility.trace('Test 1');

168:
169: if l_is_foreign_trans <> 'Y' or l_is_foreign_trans is null then
170: --Not IAT transaction
171: if length(l_segment3) > 17 then
172: hr_utility.trace('Test 1');
173: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');
174: hr_utility.raise_error;
175: end if;
176:

Line 173: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');

169: if l_is_foreign_trans <> 'Y' or l_is_foreign_trans is null then
170: --Not IAT transaction
171: if length(l_segment3) > 17 then
172: hr_utility.trace('Test 1');
173: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');
174: hr_utility.raise_error;
175: end if;
176:
177: else

Line 174: hr_utility.raise_error;

170: --Not IAT transaction
171: if length(l_segment3) > 17 then
172: hr_utility.trace('Test 1');
173: hr_utility.set_message(801, 'PAY_US_NACHA_INVALD_BANK_ACCNT');
174: hr_utility.raise_error;
175: end if;
176:
177: else
178: --IAT transaction

Line 181: hr_utility.set_message(801, 'PAY_US_IAT_INVALD_TRANSIT_CODE');

177: else
178: --IAT transaction
179: if l_segment4 <> '000000000' then
180:
181: hr_utility.set_message(801, 'PAY_US_IAT_INVALD_TRANSIT_CODE');
182: hr_utility.raise_error;
183:
184: end if;
185:

Line 182: hr_utility.raise_error;

178: --IAT transaction
179: if l_segment4 <> '000000000' then
180:
181: hr_utility.set_message(801, 'PAY_US_IAT_INVALD_TRANSIT_CODE');
182: hr_utility.raise_error;
183:
184: end if;
185:
186: if (p_ppm_information1 = hr_api.g_varchar2) then

Line 200: hr_utility.set_message(801, 'PAY_US_IAT_NO_TRANSIT_CODE');

196: if (L_PPM_INFORMATION1 is null) or
197: (L_PPM_INFORMATION2 is null) or
198: (L_PPM_INFORMATION3 is null) then
199:
200: hr_utility.set_message(801, 'PAY_US_IAT_NO_TRANSIT_CODE');
201: hr_utility.raise_error;
202: end if;
203:
204: end if;

Line 201: hr_utility.raise_error;

197: (L_PPM_INFORMATION2 is null) or
198: (L_PPM_INFORMATION3 is null) then
199:
200: hr_utility.set_message(801, 'PAY_US_IAT_NO_TRANSIT_CODE');
201: hr_utility.raise_error;
202: end if;
203:
204: end if;
205: