107: where mbatchid = P_MBATCH_ID;
108:
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;
108:
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;
128: l_validzip );
129:
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;
129:
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;
145: l_validzip );
146:
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;
146:
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;
162: l_validzip );
163:
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;
163:
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;
176: l_validzip );
177:
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;
177:
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;
345: ;
346:
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;
346:
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;
374: */
375: if l_trxn_rec.reqtype not in ('ORAPMTCAPTURE', 'ORAPMTCREDIT',
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;
375: if l_trxn_rec.reqtype not in ('ORAPMTCAPTURE', 'ORAPMTCREDIT',
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:
389: l_validzip );
390:
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;
390:
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;
407: l_validzip );
408:
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;
408:
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;
422: l_validzip );
423:
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;
423:
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;
436: l_validzip );
437:
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;
437:
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;
453: l_validzip );
454:
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;
454:
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;
481: where customer_trx_id = l_cust_trx_id;
482:
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;
482:
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;
512: l_validzip );
513:
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;
513:
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;
614: where mbatchid = P_MBATCH_ID;
615:
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;
615:
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;
634: l_validzip );
635:
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;
635:
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;
652: l_validzip );
653:
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;
653:
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;
667: l_validzip );
668:
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;
668:
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;
681: l_validzip );
682:
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;
682:
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;
698: l_validzip );
699:
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;
699:
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;
742: l_validzip );
743:
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;
743:
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;