90: raise FND_API.G_EXC_UNEXPECTED_ERROR;
91: end if;
92:
93: if FND_API.To_Boolean(p_init_msg_list) then
94: FND_MSG_PUB.initialize;
95: end if;
96:
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
109: if l_batchid_size > 8 then
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
112: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
113: FND_MSG_PUB.add;
114: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
115: return;
116: end if;
117:
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
112: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
113: FND_MSG_PUB.add;
114: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
115: return;
116: end if;
117:
118: -- Validate POSTAL CODE's
130: if l_validzip = 'N' then
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
133: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
134: FND_MSG_PUB.add;
135: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
136: return;
137: end if;
138:
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
133: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
134: FND_MSG_PUB.add;
135: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
136: return;
137: end if;
138:
139: -- PENDING: MERCHANT_POSTAL_CODE
147: if l_validzip = 'N' then
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
150: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
151: FND_MSG_PUB.add;
152: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
153: return;
154: end if;
155:
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
150: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
151: FND_MSG_PUB.add;
152: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
153: return;
154: end if;
155:
156: -- PENDING: MERCHANT_POSTAL_CODE
164: if l_validzip = 'N' then
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
167: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
168: FND_MSG_PUB.add;
169: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
170: return;
171: end if;
172:
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
167: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
168: FND_MSG_PUB.add;
169: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
170: return;
171: end if;
172:
173: -- Shipping destination postal code: invoiceHeader.buyerPartner.address.postalCode
178: if l_validzip = 'N' then
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
181: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
182: FND_MSG_PUB.add;
183: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
184: return;
185: end if;
186: */
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
181: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
182: FND_MSG_PUB.add;
183: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
184: return;
185: end if;
186: */
187:
191:
192: end loop;
193: close level2_trxn;
194:
195: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
196:
197: END; -- procedure Validate_Citibank_Batch
198:
199:
252: raise FND_API.G_EXC_UNEXPECTED_ERROR;
253: end if;
254:
255: if FND_API.To_Boolean(p_init_msg_list) then
256: FND_MSG_PUB.initialize;
257: end if;
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
347: if l_batch_count > 9 then
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
350: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');
351: FND_MSG_PUB.add;
352: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
353: return;
354: end if;
355:
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
350: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');
351: FND_MSG_PUB.add;
352: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
353: return;
354: end if;
355:
356: -- Validate TRANSACTION TYPE
376: 'ORAPMTRETURN') then
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
379: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');
380: FND_MSG_PUB.add;
381: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
382: return;
383:
384: end if;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
379: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');
380: FND_MSG_PUB.add;
381: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
382: return;
383:
384: end if;
385:
391: if l_validzip = 'N' then
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
394: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
395: FND_MSG_PUB.add;
396: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
397: return;
398: end if;
399:
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
394: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
395: FND_MSG_PUB.add;
396: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
397: return;
398: end if;
399:
400: elsif l_trxn_rec.instrtype = 'PURCHASECARD' then
409: if l_validzip = 'N' then
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
412: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
413: FND_MSG_PUB.add;
414: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
415: return;
416: end if;
417:
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
412: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
413: FND_MSG_PUB.add;
414: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
415: return;
416: end if;
417:
418: /*
424: if l_validzip = 'N' then
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
427: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
428: FND_MSG_PUB.add;
429: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
430: return;
431: end if;
432:
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
427: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
428: FND_MSG_PUB.add;
429: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
430: return;
431: end if;
432:
433: -- Shipping destination postal code
438: if l_validzip = 'N' then
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
441: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
442: FND_MSG_PUB.add;
443: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
444: return;
445: end if;
446: */
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
441: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
442: FND_MSG_PUB.add;
443: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
444: return;
445: end if;
446: */
447:
455: if l_validzip = 'N' then
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
458: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
459: FND_MSG_PUB.add;
460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
461: return;
462: end if;
463:
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
458: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
459: FND_MSG_PUB.add;
460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
461: return;
462: end if;
463:
464: -- Shipping-to postal code
469: x_msg_data);
470: /*
471: if l_cust_trx_id = 0 then
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
474: return;
475: else
476: begin
477: -- Validate DOCUMENT LINE COUNT for Visa purchase card
483: if l_doc_line_count > 98 then
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
486: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');
487: FND_MSG_PUB.add;
488: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
489: return;
490: end if;
491:
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
486: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');
487: FND_MSG_PUB.add;
488: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
489: return;
490: end if;
491:
492: select hl.postal_code, hl.country
514: if l_validzip = 'N' then
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
517: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
518: FND_MSG_PUB.add;
519: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
520: return;
521: end if;
522:
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
517: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
518: FND_MSG_PUB.add;
519: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
520: return;
521: end if;
522:
523: end; -- l_cust_trx_id has a value
542: set SENTCOUNTERDAILY = l_batch_count
543: where mbatchid = P_MBATCH_ID;
544: end if;
545:
546: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
547:
548: END; -- procedure Validate_FDCNorth_Batch
549:
550: -- Validate Paymentech credit card batch
597: raise FND_API.G_EXC_UNEXPECTED_ERROR;
598: end if;
599:
600: if FND_API.To_Boolean(p_init_msg_list) then
601: FND_MSG_PUB.initialize;
602: end if;
603:
604: x_return_status := FND_API.G_RET_STS_SUCCESS;
605:
616: if l_batchid_size > 8 then
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
619: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
620: FND_MSG_PUB.add;
621: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
622: return;
623: end if;
624:
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
619: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
620: FND_MSG_PUB.add;
621: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
622: return;
623: end if;
624:
625: -- Validate POSTAL CODE's
636: if l_validzip = 'N' then
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
639: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
640: FND_MSG_PUB.add;
641: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
642: return;
643: end if;
644:
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
639: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
640: FND_MSG_PUB.add;
641: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
642: return;
643: end if;
644:
645: elsif l_trxn_rec.instrtype = 'PURCHASECARD' then
654: if l_validzip = 'N' then
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
657: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
658: FND_MSG_PUB.add;
659: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
660: return;
661: end if;
662:
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
657: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
658: FND_MSG_PUB.add;
659: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
660: return;
661: end if;
662:
663: /*
669: if l_validzip = 'N' then
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
672: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
673: FND_MSG_PUB.add;
674: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
675: return;
676: end if;
677:
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
672: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
673: FND_MSG_PUB.add;
674: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
675: return;
676: end if;
677:
678: -- Shipping destination postal code
683: if l_validzip = 'N' then
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
686: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
687: FND_MSG_PUB.add;
688: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
689: return;
690: end if;
691: */
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
686: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
687: FND_MSG_PUB.add;
688: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
689: return;
690: end if;
691: */
692:
700: if l_validzip = 'N' then
701: x_return_status := FND_API.G_RET_STS_ERROR;
702: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
703: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
704: FND_MSG_PUB.add;
705: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
706: return;
707: end if;
708:
701: x_return_status := FND_API.G_RET_STS_ERROR;
702: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
703: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
704: FND_MSG_PUB.add;
705: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
706: return;
707: end if;
708:
709: -- Shipping-to postal code
714: x_msg_data);
715: /*
716: if l_cust_trx_id = 0 then
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
719: return;
720: else
721: begin
722: select hl.postal_code, hl.country
744: if l_validzip = 'N' then
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
747: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
748: FND_MSG_PUB.add;
749: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
750: return;
751: end if;
752:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
747: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
748: FND_MSG_PUB.add;
749: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
750: return;
751: end if;
752:
753:
766:
767: end loop;
768: close level2_trxn;
769:
770: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
771:
772: END; -- procedure Validate_Paymentech_Batch
773:
774: END IBY_FNDCPT_VLD_PUB;