36: then
37: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
38: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.PAYMENT_TARGET failed validation');
39: END IF;
40: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
41: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
42: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.PAYMENT_TARGET');
43: FND_MSG_PUB.Add;
44: RAISE FND_API.G_EXC_ERROR;
37: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
38: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.PAYMENT_TARGET failed validation');
39: END IF;
40: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
41: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
42: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.PAYMENT_TARGET');
43: FND_MSG_PUB.Add;
44: RAISE FND_API.G_EXC_ERROR;
45: end if;
38: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.PAYMENT_TARGET failed validation');
39: END IF;
40: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
41: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
42: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.PAYMENT_TARGET');
43: FND_MSG_PUB.Add;
44: RAISE FND_API.G_EXC_ERROR;
45: end if;
46:
53: then
54: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
55: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.TOTAL_AMOUNT failed validation');
56: END IF;
57: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
58: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
59: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.TOTAL_AMOUNT');
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
54: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
55: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.TOTAL_AMOUNT failed validation');
56: END IF;
57: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
58: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
59: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.TOTAL_AMOUNT');
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
62: end if;
55: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.TOTAL_AMOUNT failed validation');
56: END IF;
57: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
58: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
59: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.TOTAL_AMOUNT');
60: FND_MSG_PUB.Add;
61: RAISE FND_API.G_EXC_ERROR;
62: end if;
63:
70: then
71: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
72: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.CURRENCY_CODE failed validation');
73: END IF;
74: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
75: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
76: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.CURRENCY_CODE');
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_ERROR;
71: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
72: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.CURRENCY_CODE failed validation');
73: END IF;
74: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
75: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
76: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.CURRENCY_CODE');
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_ERROR;
79: end if;
72: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.CURRENCY_CODE failed validation');
73: END IF;
74: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
75: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
76: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.CURRENCY_CODE');
77: FND_MSG_PUB.Add;
78: RAISE FND_API.G_EXC_ERROR;
79: end if;
80:
92: then
93: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
94: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.EXCHANGE_RATE_TYPE failed validation');
95: END IF;
96: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
97: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
98: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.EXCHANGE_RATE_TYPE');
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
93: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
94: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.EXCHANGE_RATE_TYPE failed validation');
95: END IF;
96: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
97: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
98: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.EXCHANGE_RATE_TYPE');
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: end if;
94: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.EXCHANGE_RATE_TYPE failed validation');
95: END IF;
96: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
97: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
98: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.EXCHANGE_RATE_TYPE');
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_ERROR;
101: end if;
102:
108: then
109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
110: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.EXCHANGE_DATE failed validation');
111: END IF;
112: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
113: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
114: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.EXCHANGE_DATE');
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
110: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.EXCHANGE_DATE failed validation');
111: END IF;
112: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
113: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
114: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.EXCHANGE_DATE');
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
117: end if;
110: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.EXCHANGE_DATE failed validation');
111: END IF;
112: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
113: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
114: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.EXCHANGE_DATE');
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
117: end if;
118: end if;
127: then
128: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
129: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.PAYEE_ID failed validation');
130: END IF;
131: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
132: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
133: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.PAYEE_ID');
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
128: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
129: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.PAYEE_ID failed validation');
130: END IF;
131: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
132: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
133: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.PAYEE_ID');
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
129: iex_debug_pub.LogMessage('validate_input: P_PMT_REC.PAYEE_ID failed validation');
130: END IF;
131: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
132: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
133: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.PAYEE_ID');
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137: end if;
144: if l_count = 0 then
145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
146: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL.COUNT failed validation');
147: END IF;
148: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
149: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
150: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL.COUNT');
151: FND_MSG_PUB.Add;
152: RAISE FND_API.G_EXC_ERROR;
145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
146: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL.COUNT failed validation');
147: END IF;
148: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
149: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
150: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL.COUNT');
151: FND_MSG_PUB.Add;
152: RAISE FND_API.G_EXC_ERROR;
153: end if;
146: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL.COUNT failed validation');
147: END IF;
148: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
149: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
150: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL.COUNT');
151: FND_MSG_PUB.Add;
152: RAISE FND_API.G_EXC_ERROR;
153: end if;
154:
164: if P_PMTDTLS_TBL(i).AMOUNT is null or P_PMTDTLS_TBL(i).AMOUNT <= 0 then
165: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
166: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).AMOUNT failed validation');
167: END IF;
168: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
169: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
170: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').AMOUNT');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
165: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
166: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).AMOUNT failed validation');
167: END IF;
168: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
169: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
170: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').AMOUNT');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: end if;
166: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).AMOUNT failed validation');
167: END IF;
168: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
169: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
170: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').AMOUNT');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: end if;
174: l_amount := l_amount + P_PMTDTLS_TBL(i).AMOUNT;
180: if P_PMTDTLS_TBL(i).CUST_ACCOUNT_ID is null then
181: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
182: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_ACCOUNT_ID failed validation');
183: END IF;
184: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
185: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
186: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_ACCOUNT_ID');
187: FND_MSG_PUB.Add;
188: RAISE FND_API.G_EXC_ERROR;
181: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
182: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_ACCOUNT_ID failed validation');
183: END IF;
184: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
185: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
186: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_ACCOUNT_ID');
187: FND_MSG_PUB.Add;
188: RAISE FND_API.G_EXC_ERROR;
189: end if;
182: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_ACCOUNT_ID failed validation');
183: END IF;
184: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
185: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
186: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_ACCOUNT_ID');
187: FND_MSG_PUB.Add;
188: RAISE FND_API.G_EXC_ERROR;
189: end if;
190:
196: if P_PMTDTLS_TBL(i).CUST_SITE_USE_ID is null then
197: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
198: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_SITE_USE_ID failed validation');
199: END IF;
200: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
201: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
202: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_SITE_USE_ID');
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
197: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
198: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_SITE_USE_ID failed validation');
199: END IF;
200: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
201: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
202: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_SITE_USE_ID');
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
205: end if;
198: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_SITE_USE_ID failed validation');
199: END IF;
200: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
201: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
202: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_SITE_USE_ID');
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
205: end if;
206: elsif P_PMT_REC.PAYMENT_TARGET = 'INVOICES' then
211: if P_PMTDTLS_TBL(i).CUST_SITE_USE_ID is null then
212: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
213: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_SITE_USE_ID failed validation');
214: END IF;
215: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
216: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
217: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_SITE_USE_ID');
218: FND_MSG_PUB.Add;
219: RAISE FND_API.G_EXC_ERROR;
212: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
213: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_SITE_USE_ID failed validation');
214: END IF;
215: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
216: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
217: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_SITE_USE_ID');
218: FND_MSG_PUB.Add;
219: RAISE FND_API.G_EXC_ERROR;
220: end if;
213: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CUST_SITE_USE_ID failed validation');
214: END IF;
215: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
216: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
217: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CUST_SITE_USE_ID');
218: FND_MSG_PUB.Add;
219: RAISE FND_API.G_EXC_ERROR;
220: end if;
221: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
225: if P_PMTDTLS_TBL(i).PAYMENT_SCHEDULE_ID is null then
226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
227: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).PAYMENT_SCHEDULE_ID failed validation');
228: END IF;
229: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
230: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
231: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').PAYMENT_SCHEDULE_ID');
232: FND_MSG_PUB.Add;
233: RAISE FND_API.G_EXC_ERROR;
226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
227: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).PAYMENT_SCHEDULE_ID failed validation');
228: END IF;
229: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
230: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
231: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').PAYMENT_SCHEDULE_ID');
232: FND_MSG_PUB.Add;
233: RAISE FND_API.G_EXC_ERROR;
234: end if;
227: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).PAYMENT_SCHEDULE_ID failed validation');
228: END IF;
229: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
230: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
231: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').PAYMENT_SCHEDULE_ID');
232: FND_MSG_PUB.Add;
233: RAISE FND_API.G_EXC_ERROR;
234: end if;
235: elsif P_PMT_REC.PAYMENT_TARGET = 'CNSLD' then
240: if P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID is null then
241: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
242: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID failed validation');
243: END IF;
244: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
245: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
246: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CNSLD_INVOICE_ID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
241: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
242: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID failed validation');
243: END IF;
244: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
245: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
246: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CNSLD_INVOICE_ID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: end if;
242: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CNSLD_INVOICE_ID failed validation');
243: END IF;
244: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
245: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
246: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CNSLD_INVOICE_ID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: end if;
250: elsif P_PMT_REC.PAYMENT_TARGET = 'CONTRACTS' then
255: if P_PMTDTLS_TBL(i).CONTRACT_ID is null then
256: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
257: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CONTRACT_ID failed validation');
258: END IF;
259: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
260: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
261: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CONTRACT_ID');
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
256: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
257: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CONTRACT_ID failed validation');
258: END IF;
259: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
260: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
261: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CONTRACT_ID');
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: end if;
257: iex_debug_pub.LogMessage('validate_input: P_PMTDTLS_TBL(i).CONTRACT_ID failed validation');
258: END IF;
259: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
260: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
261: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTDTLS_TBL(' || i || ').CONTRACT_ID');
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: end if;
265: end if;
272: if l_amount <> P_PMT_REC.TOTAL_AMOUNT then
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: iex_debug_pub.LogMessage('validate_input: l_amount <> P_PMT_REC.TOTAL_AMOUNT failed validation');
275: END IF;
276: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
277: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
278: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.TOTAL_AMOUNT');
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_ERROR;
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: iex_debug_pub.LogMessage('validate_input: l_amount <> P_PMT_REC.TOTAL_AMOUNT failed validation');
275: END IF;
276: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
277: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
278: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.TOTAL_AMOUNT');
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_ERROR;
281: end if;
274: iex_debug_pub.LogMessage('validate_input: l_amount <> P_PMT_REC.TOTAL_AMOUNT failed validation');
275: END IF;
276: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
277: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
278: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMT_REC.TOTAL_AMOUNT');
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_ERROR;
281: end if;
282:
291: then
292: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
293: iex_debug_pub.LogMessage('validate_input: P_PMTINSTR_REC.USE_INSTRUMENT failed validation');
294: END IF;
295: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
296: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
297: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.USE_INSTRUMENT');
298: FND_MSG_PUB.Add;
299: RAISE FND_API.G_EXC_ERROR;
292: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
293: iex_debug_pub.LogMessage('validate_input: P_PMTINSTR_REC.USE_INSTRUMENT failed validation');
294: END IF;
295: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
296: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
297: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.USE_INSTRUMENT');
298: FND_MSG_PUB.Add;
299: RAISE FND_API.G_EXC_ERROR;
300: end if;
293: iex_debug_pub.LogMessage('validate_input: P_PMTINSTR_REC.USE_INSTRUMENT failed validation');
294: END IF;
295: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
296: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
297: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.USE_INSTRUMENT');
298: FND_MSG_PUB.Add;
299: RAISE FND_API.G_EXC_ERROR;
300: end if;
301:
313: then
314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
315: iex_debug_pub.LogMessage('validate_input: CC instrument failed validation');
316: END IF;
317: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
318: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
319: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.CREDITCARDINSTR');
320: FND_MSG_PUB.Add;
321: RAISE FND_API.G_EXC_ERROR;
314: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
315: iex_debug_pub.LogMessage('validate_input: CC instrument failed validation');
316: END IF;
317: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
318: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
319: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.CREDITCARDINSTR');
320: FND_MSG_PUB.Add;
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
315: iex_debug_pub.LogMessage('validate_input: CC instrument failed validation');
316: END IF;
317: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
318: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
319: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.CREDITCARDINSTR');
320: FND_MSG_PUB.Add;
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
323: elsif P_PMTINSTR_REC.USE_INSTRUMENT = 'BA' then
335: then
336: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
337: iex_debug_pub.LogMessage('validate_input: BA instrument failed validation');
338: END IF;
339: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
340: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
341: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.BANKACCTINSTR');
342: FND_MSG_PUB.Add;
343: RAISE FND_API.G_EXC_ERROR;
336: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
337: iex_debug_pub.LogMessage('validate_input: BA instrument failed validation');
338: END IF;
339: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
340: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
341: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.BANKACCTINSTR');
342: FND_MSG_PUB.Add;
343: RAISE FND_API.G_EXC_ERROR;
344: end if;
337: iex_debug_pub.LogMessage('validate_input: BA instrument failed validation');
338: END IF;
339: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
340: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.CREATE_PAYMENT');
341: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PMTINSTR_REC.BANKACCTINSTR');
342: FND_MSG_PUB.Add;
343: RAISE FND_API.G_EXC_ERROR;
344: end if;
345: end if; */
430: else
431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
432: iex_debug_pub.LogMessage('GET_PAYER_INFO: Neither');
433: END IF;
434: FND_MESSAGE.SET_NAME('IEX','IEX_WRONG_PARTY');
435: FND_MSG_PUB.Add;
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438: end if;
453: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
454: iex_debug_pub.LogMessage('No party');
455: END IF;
456: CLOSE get_payer_name_crs;
457: FND_MESSAGE.SET_NAME('IEX','IEX_WRONG_PARTY');
458: FND_MSG_PUB.Add;
459: RAISE FND_API.G_EXC_ERROR;
460: end if;
461: CLOSE get_payer_name_crs;
484: if x_payment_method is null then
485: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
486: iex_debug_pub.LogMessage(l_api_name || ': failed to get CC remittance');
487: END IF;
488: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_CC_REMITTANCE');
489: FND_MSG_PUB.Add;
490: RAISE FND_API.G_EXC_ERROR;
491: end if;
492: x_payment_method_id := to_number(x_payment_method);
497: if x_payment_method is null then
498: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
499: iex_debug_pub.LogMessage(l_api_name || ': failed to get BA remittance');
500: END IF;
501: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_EFT_REMITTANCE');
502: FND_MSG_PUB.Add;
503: RAISE FND_API.G_EXC_ERROR;
504: end if;
505: x_payment_method_id := to_number(x_payment_method);
600: if ARP_BANK_DIRECTORY.is_routing_number_valid(p_routing_number => p_ba_routing_number) = 0 then
601: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
602: iex_debug_pub.LogMessage('Invalid routing number');
603: END IF;
604: FND_MESSAGE.SET_NAME('IEX', 'IEX_INVALID_ROUTING_NUM');
605: FND_MSG_PUB.Add;
606: RAISE FND_API.G_EXC_ERROR;
607: end if;
608: */
1035: x_return_status :=l_return_status;
1036: X_MSG_DATA:= L_MSG_DATA;
1037: X_MSG_COUNT := L_MSG_COUNT;
1038:
1039: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CREATE_CR');
1040: FND_MSG_PUB.Add;
1041: return; --RAISE FND_API.G_EXC_ERROR;
1042: END IF;
1043:
1066: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1067: iex_debug_pub.LogMessage(l_api_name || ': AR_RECEIPT_API_PUB.APPLY_ON_ACCOUNT failed');
1068: END IF;
1069:
1070: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_APPLY_ACC');
1071: FND_MSG_PUB.Add;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074: */
1346:
1347: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1348: iex_debug_pub.LogMessage(l_api_name || ': AR_RECEIPT_API_PUB.CREATE_CASH failed');
1349: END IF;
1350: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CREATE_CR');
1351: FND_MSG_PUB.Add;
1352: return;
1353: END IF;
1354:
1473:
1474: x_return_status :=l_return_status;
1475: X_MSG_DATA:= L_MSG_DATA;
1476:
1477: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_APPLY_APP');
1478: FND_MSG_PUB.Add;
1479: return; -- RAISE FND_API.G_EXC_ERROR;
1480: end if;
1481: end if;
1493: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1494: iex_debug_pub.LogMessage(l_api_name || ': AR_RECEIPT_API_PUB.APPLY failed');
1495: END IF;
1496:
1497: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_APPLY_APP');
1498: FND_MSG_PUB.Add;
1499: RAISE FND_API.G_EXC_ERROR;
1500: END IF;
1501: --*/
1581: COMMIT WORK;
1582:
1583:
1584:
1585: FND_MESSAGE.SET_NAME('IEX', 'IEX_AR_SUCCESS');
1586: FND_MSG_PUB.Add;
1587:
1588: x_return_status := FND_API.G_RET_STS_SUCCESS;
1589: commit;
1935: if l_ar_pay_method1 is null then
1936: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1937: iex_debug_pub.LogMessage(l_api_name || ': failed to get CC remittance');
1938: END IF;
1939: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_CC_REMITTANCE');
1940: FND_MSG_PUB.Add;
1941: RAISE FND_API.G_EXC_ERROR;
1942: end if;
1943: l_ar_pay_method := to_number(l_ar_pay_method1);
1989: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1990: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1991: iex_debug_pub.LogMessage(l_api_name || ': IBY_INSTRREG_PUB.ORAINSTRADD failed');
1992: END IF;
1993: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_INSERT_INSTR');
1994: FND_MSG_PUB.Add;
1995: RAISE FND_API.G_EXC_ERROR;
1996: END IF;
1997: else
2034: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2035: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2036: iex_debug_pub.LogMessage(l_api_name || ': IBY_INSTRREG_PUB.ORAINSTRMOD failed');
2037: END IF;
2038: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_UPDATE_INSTR');
2039: FND_MSG_PUB.Add;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;
2042: end if;
2066: if l_ar_pay_method1 is null then
2067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2068: iex_debug_pub.LogMessage(l_api_name || ': failed to get BA remittance');
2069: END IF;
2070: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_EFT_REMITTANCE');
2071: FND_MSG_PUB.Add;
2072: RAISE FND_API.G_EXC_ERROR;
2073: end if;
2074: l_ar_pay_method := to_number(l_ar_pay_method1);
2122: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2123: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2124: iex_debug_pub.LogMessage(l_api_name || ': IBY_INSTRREG_PUB.ORAINSTRADD failed');
2125: END IF;
2126: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_INSERT_INSTR');
2127: FND_MSG_PUB.Add;
2128: RAISE FND_API.G_EXC_ERROR;
2129: END IF;
2130: else
2219: IF l_return_status<>'S' THEN
2220: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2221: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtReq failed');
2222: END IF;
2223: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_AUTH_PAYMENT');
2224: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2220: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2221: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtReq failed');
2222: END IF;
2223: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_AUTH_PAYMENT');
2224: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2228: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2221: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtReq failed');
2222: END IF;
2223: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_AUTH_PAYMENT');
2224: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2228: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2229: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2222: END IF;
2223: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_AUTH_PAYMENT');
2224: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2228: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2229: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2230: FND_MSG_PUB.initialize;
2223: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_AUTH_PAYMENT');
2224: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2228: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2229: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2230: FND_MSG_PUB.initialize;
2231: FND_MSG_PUB.Add;
2224: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2228: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2229: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2230: FND_MSG_PUB.initialize;
2231: FND_MSG_PUB.Add;
2232: RAISE FND_API.G_EXC_ERROR;
2225: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2226: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2227: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2228: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2229: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2230: FND_MSG_PUB.initialize;
2231: FND_MSG_PUB.Add;
2232: RAISE FND_API.G_EXC_ERROR;
2233: END IF;
2271: IF l_return_status<>'S' THEN
2272: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2273: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtCapture failed');
2274: END IF;
2275: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2276: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2272: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2273: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtCapture failed');
2274: END IF;
2275: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2276: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2280: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2273: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtCapture failed');
2274: END IF;
2275: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2276: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2280: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2281: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2274: END IF;
2275: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2276: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2280: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2281: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2282: FND_MSG_PUB.initialize;
2275: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2276: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2280: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2281: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2282: FND_MSG_PUB.initialize;
2283: FND_MSG_PUB.Add;
2276: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2280: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2281: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2282: FND_MSG_PUB.initialize;
2283: FND_MSG_PUB.Add;
2284: RAISE FND_API.G_EXC_ERROR;
2277: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2278: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2279: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2280: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2281: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2282: FND_MSG_PUB.initialize;
2283: FND_MSG_PUB.Add;
2284: RAISE FND_API.G_EXC_ERROR;
2285: END IF;
2326: IF l_return_status<>'S' THEN
2327: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2328: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtReq failed');
2329: END IF;
2330: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2331: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2327: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2328: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtReq failed');
2329: END IF;
2330: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2331: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2335: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2328: iex_debug_pub.LogMessage(l_api_name || ': IBY_Payment_Adapter_Pub.OraPmtReq failed');
2329: END IF;
2330: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2331: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2335: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2336: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2329: END IF;
2330: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2331: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2335: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2336: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2337: FND_MSG_PUB.initialize;
2330: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_CAPTURE_PAYMENT');
2331: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2335: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2336: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2337: FND_MSG_PUB.initialize;
2338: FND_MSG_PUB.Add;
2331: FND_MESSAGE.SET_TOKEN('STATUS', l_reqresp_rec.response.status);
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2335: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2336: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2337: FND_MSG_PUB.initialize;
2338: FND_MSG_PUB.Add;
2339: RAISE FND_API.G_EXC_ERROR;
2332: FND_MESSAGE.SET_TOKEN('ERR_LOC', l_reqresp_rec.ErrorLocation);
2333: FND_MESSAGE.SET_TOKEN('ERR_CODE', l_capresp_rec.response.ErrCode);
2334: FND_MESSAGE.SET_TOKEN('ERR_MSG', l_reqresp_rec.response.ErrMessage);
2335: FND_MESSAGE.SET_TOKEN('BEP_ERR_CODE', l_reqresp_rec.BEPErrCode);
2336: FND_MESSAGE.SET_TOKEN('BEP_ERR_MSG', l_capresp_rec.BEPErrMessage);
2337: FND_MSG_PUB.initialize;
2338: FND_MSG_PUB.Add;
2339: RAISE FND_API.G_EXC_ERROR;
2340: END IF;
2463: END IF;
2464:
2465: -- commit first part of API: made iPayment money transfer and created IEX payment record with iPayment info
2466: COMMIT WORK;
2467: FND_MESSAGE.SET_NAME('IEX', 'IEX_IPAY_SUCCESS');
2468: FND_MSG_PUB.Add;
2469: x_return_status := FND_API.G_RET_STS_SUCCESS;
2470:
2471: EXCEPTION
2542: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2543: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2544: iex_debug_pub.LogMessage(l_api_name || ': OKL_PAYMENT_PUB.CREATE_INTERNAL_TRANS failed');
2545: END IF;
2546: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_PAY_OKL_CNSLD');
2547: FND_MSG_PUB.Add;
2548: RAISE FND_API.G_EXC_ERROR;
2549: END IF;
2550:
2616: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2617: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2618: iex_debug_pub.LogMessage(l_api_name || ': OKL_PAYMENT_PUB.CREATE_INTERNAL_TRANS failed');
2619: END IF;
2620: FND_MESSAGE.SET_NAME('IEX', 'IEX_FAILED_PAY_OKL_CONTRACT');
2621: FND_MSG_PUB.Add;
2622: RAISE FND_API.G_EXC_ERROR;
2623: END IF;
2624:
2657:
2658: -- commit second part of API: AR/OKL processing
2659: COMMIT WORK;
2660:
2661: FND_MESSAGE.SET_NAME('IEX', 'IEX_OKL_SUCCESS');
2662: FND_MSG_PUB.Add;
2663:
2664: x_return_status := FND_API.G_RET_STS_SUCCESS;
2665: