DBA Data[Home] [Help]

APPS.IBY_FNDCPT_VLD_PUB dependencies on FND_MESSAGE

Line 157: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

153: where mbatchid = P_MBATCH_ID;
154:
155: if l_batchid_size > 8 then
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
158: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
159: FND_MSG_PUB.add;
160: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
161: return;

Line 158: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

154:
155: if l_batchid_size > 8 then
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
158: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
159: FND_MSG_PUB.add;
160: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
161: return;
162: end if;

Line 178: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

174: l_validzip );
175:
176: if l_validzip = 'N' then
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
179: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
180: FND_MSG_PUB.add;
181: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
182: return;

Line 179: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

175:
176: if l_validzip = 'N' then
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
179: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
180: FND_MSG_PUB.add;
181: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
182: return;
183: end if;

Line 195: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

191: l_validzip );
192:
193: if l_validzip = 'N' then
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
196: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
197: FND_MSG_PUB.add;
198: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
199: return;

Line 196: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

192:
193: if l_validzip = 'N' then
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
196: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
197: FND_MSG_PUB.add;
198: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
199: return;
200: end if;

Line 212: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

208: l_validzip );
209:
210: if l_validzip = 'N' then
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
213: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
214: FND_MSG_PUB.add;
215: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
216: return;

Line 213: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

209:
210: if l_validzip = 'N' then
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
213: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
214: FND_MSG_PUB.add;
215: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
216: return;
217: end if;

Line 226: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

222: l_validzip );
223:
224: if l_validzip = 'N' then
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
227: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
228: FND_MSG_PUB.add;
229: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
230: return;

Line 227: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

223:
224: if l_validzip = 'N' then
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
227: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
228: FND_MSG_PUB.add;
229: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
230: return;
231: end if;

Line 413: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

409: TRUNC(batchclosedate) = l_batch_close_date;
410:
411: if l_batch_count > 9 then
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
414: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');
415: FND_MSG_PUB.add;
416: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
417: return;

Line 414: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');

410:
411: if l_batch_count > 9 then
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
414: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch count per merchant security code');
415: FND_MSG_PUB.add;
416: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
417: return;
418: end if;

Line 442: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

438: */
439: if l_trxn_rec.reqtype not in ('ORAPMTCAPTURE', 'ORAPMTCREDIT',
440: 'ORAPMTRETURN') then
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
443: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');
444: FND_MSG_PUB.add;
445: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
446: return;

Line 443: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');

439: if l_trxn_rec.reqtype not in ('ORAPMTCAPTURE', 'ORAPMTCREDIT',
440: 'ORAPMTRETURN') then
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
443: FND_MESSAGE.set_token('ERR_OBJECT', 'Transaction type');
444: FND_MSG_PUB.add;
445: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
446: return;
447:

Line 457: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

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;

Line 458: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

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;

Line 475: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

471: l_validzip );
472:
473: if l_validzip = 'N' then
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
476: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
477: FND_MSG_PUB.add;
478: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
479: return;

Line 476: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

472:
473: if l_validzip = 'N' then
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
476: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
477: FND_MSG_PUB.add;
478: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
479: return;
480: end if;

Line 490: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

486: l_validzip );
487:
488: if l_validzip = 'N' then
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
491: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
492: FND_MSG_PUB.add;
493: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
494: return;

Line 491: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

487:
488: if l_validzip = 'N' then
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
491: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
492: FND_MSG_PUB.add;
493: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
494: return;
495: end if;

Line 504: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

500: l_validzip );
501:
502: if l_validzip = 'N' then
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
505: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
506: FND_MSG_PUB.add;
507: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
508: return;

Line 505: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

501:
502: if l_validzip = 'N' then
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
505: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
506: FND_MSG_PUB.add;
507: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
508: return;
509: end if;

Line 521: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

517: l_validzip );
518:
519: if l_validzip = 'N' then
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
522: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
523: FND_MSG_PUB.add;
524: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
525: return;

Line 522: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

518:
519: if l_validzip = 'N' then
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
522: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
523: FND_MSG_PUB.add;
524: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
525: return;
526: end if;

Line 549: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

545: where customer_trx_id = l_cust_trx_id;
546:
547: if l_doc_line_count > 98 then
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
550: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');
551: FND_MSG_PUB.add;
552: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
553: return;

Line 550: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');

546:
547: if l_doc_line_count > 98 then
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
550: FND_MESSAGE.set_token('ERR_OBJECT', 'Invoice line count for Visa purchase card');
551: FND_MSG_PUB.add;
552: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
553: return;
554: end if;

Line 580: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

576: l_validzip );
577:
578: if l_validzip = 'N' then
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
581: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
582: FND_MSG_PUB.add;
583: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
584: return;

Line 581: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

577:
578: if l_validzip = 'N' then
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
581: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
582: FND_MSG_PUB.add;
583: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
584: return;
585: end if;

Line 683: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

679: where mbatchid = P_MBATCH_ID;
680:
681: if l_batchid_size > 8 then
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
684: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
685: FND_MSG_PUB.add;
686: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
687: return;

Line 684: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

680:
681: if l_batchid_size > 8 then
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
684: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
685: FND_MSG_PUB.add;
686: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
687: return;
688: end if;

Line 703: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

699: l_validzip );
700:
701: if l_validzip = 'N' then
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
704: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
705: FND_MSG_PUB.add;
706: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
707: return;

Line 704: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

700:
701: if l_validzip = 'N' then
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
704: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
705: FND_MSG_PUB.add;
706: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
707: return;
708: end if;

Line 721: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

717: l_validzip );
718:
719: if l_validzip = 'N' then
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
722: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
723: FND_MSG_PUB.add;
724: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
725: return;

Line 722: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

718:
719: if l_validzip = 'N' then
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
722: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
723: FND_MSG_PUB.add;
724: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
725: return;
726: end if;

Line 736: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

732: l_validzip );
733:
734: if l_validzip = 'N' then
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
737: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
738: FND_MSG_PUB.add;
739: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
740: return;

Line 737: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

733:
734: if l_validzip = 'N' then
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
737: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
738: FND_MSG_PUB.add;
739: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
740: return;
741: end if;

Line 750: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

746: l_validzip );
747:
748: if l_validzip = 'N' then
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
751: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
752: FND_MSG_PUB.add;
753: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
754: return;

Line 751: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

747:
748: if l_validzip = 'N' then
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
751: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
752: FND_MSG_PUB.add;
753: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
754: return;
755: end if;

Line 767: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

763: l_validzip );
764:
765: if l_validzip = 'N' then
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
768: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
769: FND_MSG_PUB.add;
770: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
771: return;

Line 768: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

764:
765: if l_validzip = 'N' then
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
768: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
769: FND_MSG_PUB.add;
770: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
771: return;
772: end if;

Line 811: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');

807: l_validzip );
808:
809: if l_validzip = 'N' then
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
812: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
813: FND_MSG_PUB.add;
814: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
815: return;

Line 812: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');

808:
809: if l_validzip = 'N' then
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: FND_MESSAGE.set_name('IBY','IBY_VALID_IS_INCORRECT');
812: FND_MESSAGE.set_token('ERR_OBJECT', 'Postal code');
813: FND_MSG_PUB.add;
814: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
815: return;
816: end if;

Line 1125: FND_MESSAGE.set_name('IBY','Active Debit Authorization is required');

1121: END IF;
1122:
1123: IF (c_mandate%NOTFOUND) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MESSAGE.set_name('IBY','Active Debit Authorization is required');
1126: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1127: FND_MSG_PUB.add;
1128: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1129:

Line 1126: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1122:
1123: IF (c_mandate%NOTFOUND) THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MESSAGE.set_name('IBY','Active Debit Authorization is required');
1126: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1127: FND_MSG_PUB.add;
1128: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1129:
1130: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1151: FND_MESSAGE.set_name('IBY','iban and BIC name is required on Debit Authorization');

1147: AND eb.branch_id = bbv.branch_party_id
1148: AND uses.instrument_payment_use_id = l_external_bank_account_use_id;
1149: EXCEPTION WHEN OTHERS THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MESSAGE.set_name('IBY','iban and BIC name is required on Debit Authorization');
1152: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1153: FND_MSG_PUB.add;
1154: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1155: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1152: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1148: AND uses.instrument_payment_use_id = l_external_bank_account_use_id;
1149: EXCEPTION WHEN OTHERS THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MESSAGE.set_name('IBY','iban and BIC name is required on Debit Authorization');
1152: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1153: FND_MSG_PUB.add;
1154: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1155: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1156: print_debuginfo(G_DEBUG_MODULE, 'Checking Payee iban and BIC');

Line 1175: FND_MESSAGE.set_name('IBY','LE name and payee address required on Debit Authorization');

1171: FROM xle_firstparty_information_v
1172: WHERE legal_entity_id = l_creditor_legal_entity_id ;
1173: EXCEPTION WHEN OTHERS THEN
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.set_name('IBY','LE name and payee address required on Debit Authorization');
1176: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1177: FND_MSG_PUB.add;
1178: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1176: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1172: WHERE legal_entity_id = l_creditor_legal_entity_id ;
1173: EXCEPTION WHEN OTHERS THEN
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.set_name('IBY','LE name and payee address required on Debit Authorization');
1176: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1177: FND_MSG_PUB.add;
1178: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1180: print_debuginfo(G_DEBUG_MODULE, 'Checking Payee address and LE name');

Line 1189: FND_MESSAGE.set_name('IBY','Unique Authorization Reference ID is required on Enter Debit Authorization');

1185: /* checking the mandate attributes */
1186: IF(l_auth_reference_number IS NULL )
1187: THEN
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: FND_MESSAGE.set_name('IBY','Unique Authorization Reference ID is required on Enter Debit Authorization');
1190: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1191: FND_MSG_PUB.add;
1192: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1193: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1190: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1186: IF(l_auth_reference_number IS NULL )
1187: THEN
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189: FND_MESSAGE.set_name('IBY','Unique Authorization Reference ID is required on Enter Debit Authorization');
1190: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1191: FND_MSG_PUB.add;
1192: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1193: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1194: print_debuginfo(G_DEBUG_MODULE, 'Checking auth ref id ');

Line 1199: FND_MESSAGE.set_name('IBY','Authorization Signing Date is required on Enter Debit Authorization');

1195: END IF;
1196: ELSIF (l_auth_sign_date IS NULL )
1197: THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MESSAGE.set_name('IBY','Authorization Signing Date is required on Enter Debit Authorization');
1200: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1201: FND_MSG_PUB.add;
1202: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1203: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1200: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1196: ELSIF (l_auth_sign_date IS NULL )
1197: THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MESSAGE.set_name('IBY','Authorization Signing Date is required on Enter Debit Authorization');
1200: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1201: FND_MSG_PUB.add;
1202: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1203: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1204: print_debuginfo(G_DEBUG_MODULE, 'Authsign date');

Line 1209: FND_MESSAGE.set_name('IBY','Payee Legal Entity is required on Enter Debit Authorization');

1205: END IF;
1206: ELSIF (l_creditor_legal_entity_id IS NULL )
1207: THEN
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: FND_MESSAGE.set_name('IBY','Payee Legal Entity is required on Enter Debit Authorization');
1210: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1211: FND_MSG_PUB.add;
1212: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1210: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1206: ELSIF (l_creditor_legal_entity_id IS NULL )
1207: THEN
1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: FND_MESSAGE.set_name('IBY','Payee Legal Entity is required on Enter Debit Authorization');
1210: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1211: FND_MSG_PUB.add;
1212: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1213: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1214: print_debuginfo(G_DEBUG_MODULE, 'Payee legal entity ');

Line 1219: FND_MESSAGE.set_name('IBY','Payee Address is required on Enter Debit Authorization');

1215: END IF;
1216: ELSIF (l_payee_address IS NULL )
1217: THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MESSAGE.set_name('IBY','Payee Address is required on Enter Debit Authorization');
1220: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1221: FND_MSG_PUB.add;
1222: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1220: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1216: ELSIF (l_payee_address IS NULL )
1217: THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MESSAGE.set_name('IBY','Payee Address is required on Enter Debit Authorization');
1220: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1221: FND_MSG_PUB.add;
1222: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1224: print_debuginfo(G_DEBUG_MODULE, 'Payee Address ');

Line 1229: FND_MESSAGE.set_name('IBY','Payee Identifier is required on Enter Debit Authorization');

1225: END IF;
1226: ELSIF (l_creditor_identifier IS NULL )
1227: THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: FND_MESSAGE.set_name('IBY','Payee Identifier is required on Enter Debit Authorization');
1230: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1231: FND_MSG_PUB.add;
1232: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1230: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1226: ELSIF (l_creditor_identifier IS NULL )
1227: THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: FND_MESSAGE.set_name('IBY','Payee Identifier is required on Enter Debit Authorization');
1230: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1231: FND_MSG_PUB.add;
1232: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1233: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1234: print_debuginfo(G_DEBUG_MODULE, 'Payee identifier');

Line 1239: FND_MESSAGE.set_name('IBY','Customer Address is required on Enter Debit Authorizationd');

1235: END IF;
1236: ELSIF (l_cust_addr_id IS NULL )
1237: THEN
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: FND_MESSAGE.set_name('IBY','Customer Address is required on Enter Debit Authorizationd');
1240: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1241: FND_MSG_PUB.add;
1242: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1243: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1240: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1236: ELSIF (l_cust_addr_id IS NULL )
1237: THEN
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: FND_MESSAGE.set_name('IBY','Customer Address is required on Enter Debit Authorizationd');
1240: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1241: FND_MSG_PUB.add;
1242: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1243: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1244: print_debuginfo(G_DEBUG_MODULE, 'Customer address');

Line 1249: FND_MESSAGE.set_name('IBY','Payee LegalEntity Name is Invalid');

1245: END IF;
1246: ELSIF (l_creditor_le_name <> l_le_name)
1247: THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: FND_MESSAGE.set_name('IBY','Payee LegalEntity Name is Invalid');
1250: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1251: FND_MSG_PUB.add;
1252: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1253: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1250: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1246: ELSIF (l_creditor_le_name <> l_le_name)
1247: THEN
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: FND_MESSAGE.set_name('IBY','Payee LegalEntity Name is Invalid');
1250: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1251: FND_MSG_PUB.add;
1252: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1253: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1254: print_debuginfo(G_DEBUG_MODULE, 'Payee LE Name');

Line 1259: FND_MESSAGE.set_name('IBY','IBAN is required on Enter Debit Authorizationd');

1255: END IF;
1256: ELSIF (l_iban IS NULL )
1257: THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: FND_MESSAGE.set_name('IBY','IBAN is required on Enter Debit Authorizationd');
1260: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1261: FND_MSG_PUB.add;
1262: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1263: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1260: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1256: ELSIF (l_iban IS NULL )
1257: THEN
1258: x_return_status := FND_API.G_RET_STS_ERROR;
1259: FND_MESSAGE.set_name('IBY','IBAN is required on Enter Debit Authorizationd');
1260: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1261: FND_MSG_PUB.add;
1262: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1263: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1264: print_debuginfo(G_DEBUG_MODULE, 'IBAN');

Line 1269: FND_MESSAGE.set_name('IBY','BIC is required on Enter Debit Authorizationd');

1265: END IF;
1266: ELSIF (l_swift_code IS NULL )
1267: THEN
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: FND_MESSAGE.set_name('IBY','BIC is required on Enter Debit Authorizationd');
1270: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1271: FND_MSG_PUB.add;
1272: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1273: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1270: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1266: ELSIF (l_swift_code IS NULL )
1267: THEN
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: FND_MESSAGE.set_name('IBY','BIC is required on Enter Debit Authorizationd');
1270: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1271: FND_MSG_PUB.add;
1272: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1273: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1274: print_debuginfo(G_DEBUG_MODULE, 'BIC');

Line 1314: FND_MESSAGE.set_name('IBY','Initiating Party ID is required');

1310:
1311: IF (l_ini_party_id IS NULL)
1312: THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: FND_MESSAGE.set_name('IBY','Initiating Party ID is required');
1315: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1316: FND_MSG_PUB.add;
1317: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1318: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1315: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1311: IF (l_ini_party_id IS NULL)
1312: THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: FND_MESSAGE.set_name('IBY','Initiating Party ID is required');
1315: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1316: FND_MSG_PUB.add;
1317: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1318: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1319: print_debuginfo(G_DEBUG_MODULE, 'Initaiting party id');

Line 1324: FND_MESSAGE.set_name('IBY','Initiating Party ID Issuer is required');

1320: END IF;
1321: ELSIF (l_ini_party_id_issuer IS NULL)
1322: THEN
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: FND_MESSAGE.set_name('IBY','Initiating Party ID Issuer is required');
1325: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1326: FND_MSG_PUB.add;
1327: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1328: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1325: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1321: ELSIF (l_ini_party_id_issuer IS NULL)
1322: THEN
1323: x_return_status := FND_API.G_RET_STS_ERROR;
1324: FND_MESSAGE.set_name('IBY','Initiating Party ID Issuer is required');
1325: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1326: FND_MSG_PUB.add;
1327: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1328: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1329: print_debuginfo(G_DEBUG_MODULE, 'Init Party Id issr ');

Line 1334: FND_MESSAGE.set_name('IBY','Initiating Party Name is required');

1330: END IF;
1331: ELSIF (l_ini_party_name IS NULL)
1332: THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MESSAGE.set_name('IBY','Initiating Party Name is required');
1335: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1336: FND_MSG_PUB.add;
1337: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1338: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1335: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1331: ELSIF (l_ini_party_name IS NULL)
1332: THEN
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: FND_MESSAGE.set_name('IBY','Initiating Party Name is required');
1335: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1336: FND_MSG_PUB.add;
1337: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1338: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1339: print_debuginfo(G_DEBUG_MODULE, 'Ini Party Name');

Line 1344: FND_MESSAGE.set_name('IBY','Batch Booking is required');

1340: END IF;
1341: ELSIF (l_batch_booking_flag IS NULL)
1342: THEN
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: FND_MESSAGE.set_name('IBY','Batch Booking is required');
1345: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1346: FND_MSG_PUB.add;
1347: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1348: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1345: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1341: ELSIF (l_batch_booking_flag IS NULL)
1342: THEN
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: FND_MESSAGE.set_name('IBY','Batch Booking is required');
1345: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1346: FND_MSG_PUB.add;
1347: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1348: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1349: print_debuginfo(G_DEBUG_MODULE, 'batch booking');

Line 1354: FND_MESSAGE.set_name('IBY','Batch Booking is Invalid');

1350: END IF;
1351: ELSIF ((l_batch_booking_flag <> 'TRUE') AND (l_batch_booking_flag <> 'FALSE' ))
1352: THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MESSAGE.set_name('IBY','Batch Booking is Invalid');
1355: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1356: FND_MSG_PUB.add;
1357: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1358: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1355: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');

1351: ELSIF ((l_batch_booking_flag <> 'TRUE') AND (l_batch_booking_flag <> 'FALSE' ))
1352: THEN
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: FND_MESSAGE.set_name('IBY','Batch Booking is Invalid');
1355: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch name');
1356: FND_MSG_PUB.add;
1357: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1358: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1359: print_debuginfo(G_DEBUG_MODULE, 'Batch booking values');

Line 1457: FND_MESSAGE.set_name('IBY','No active mandate');

1453: print_debuginfo(G_DEBUG_MODULE, 'Active mandate Reference:' || l_auth_reference_number);
1454: END IF;
1455: IF (c_mandate%NOTFOUND) THEN
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: FND_MESSAGE.set_name('IBY','No active mandate');
1458: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch:'||P_MBATCH_ID ||' Trxnmid : ' || l_trxnmid);
1459: FND_MSG_PUB.add;
1460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1461: RETURN;

Line 1458: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch:'||P_MBATCH_ID ||' Trxnmid : ' || l_trxnmid);

1454: END IF;
1455: IF (c_mandate%NOTFOUND) THEN
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: FND_MESSAGE.set_name('IBY','No active mandate');
1458: FND_MESSAGE.set_token('ERR_OBJECT', 'Batch:'||P_MBATCH_ID ||' Trxnmid : ' || l_trxnmid);
1459: FND_MSG_PUB.add;
1460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1461: RETURN;
1462: END IF;