eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_VLD_PUB dependencies on FND_MSG_PUB

Line 140: FND_MSG_PUB.initialize;

136: raise FND_API.G_EXC_UNEXPECTED_ERROR;
137: end if;
138:
139: if FND_API.To_Boolean(p_init_msg_list) then
140: FND_MSG_PUB.initialize;
141: end if;
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:

Line 159: FND_MSG_PUB.add;

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;
163:

Line 160: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
163:
164: -- Validate POSTAL CODE's

Line 180: FND_MSG_PUB.add;

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;
184:

Line 181: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
184:
185: -- PENDING: MERCHANT_POSTAL_CODE

Line 197: FND_MSG_PUB.add;

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;
201:

Line 198: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
201:
202: -- PENDING: MERCHANT_POSTAL_CODE

Line 214: FND_MSG_PUB.add;

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;
218:

Line 215: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
218:
219: -- Shipping destination postal code: invoiceHeader.buyerPartner.address.postalCode

Line 228: FND_MSG_PUB.add;

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;
232: */

Line 229: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
232: */
233:

Line 241: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

237:
238: end loop;
239: close level2_trxn;
240:
241: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
242:
243: END; -- procedure Validate_Citibank_Batch
244:
245:

Line 303: FND_MSG_PUB.initialize;

299: raise FND_API.G_EXC_UNEXPECTED_ERROR;
300: end if;
301:
302: if FND_API.To_Boolean(p_init_msg_list) then
303: FND_MSG_PUB.initialize;
304: end if;
305:
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:

Line 415: FND_MSG_PUB.add;

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;
419:

Line 416: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
419:
420: -- Validate TRANSACTION TYPE

Line 444: FND_MSG_PUB.add;

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:
448: end if;

Line 445: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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:
448: end if;
449:

Line 459: FND_MSG_PUB.add;

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:

Line 460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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: elsif l_trxn_rec.instrtype = 'PURCHASECARD' then

Line 477: FND_MSG_PUB.add;

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;
481:

Line 478: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
481:
482: /*

Line 492: FND_MSG_PUB.add;

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;
496:

Line 493: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
496:
497: -- Shipping destination postal code

Line 506: FND_MSG_PUB.add;

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;
510: */

Line 507: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
510: */
511:

Line 523: FND_MSG_PUB.add;

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;
527:

Line 524: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
527:
528: -- Shipping-to postal code

Line 537: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

533: x_msg_data);
534: /*
535: if l_cust_trx_id = 0 then
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
538: return;
539: else
540: begin
541: -- Validate DOCUMENT LINE COUNT for Visa purchase card

Line 551: FND_MSG_PUB.add;

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;
555:

Line 552: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
555:
556: select hl.postal_code, hl.country

Line 582: FND_MSG_PUB.add;

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;
586:

Line 583: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
586:
587: end; -- l_cust_trx_id has a value

Line 610: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

606: set SENTCOUNTERDAILY = l_batch_count
607: where mbatchid = P_MBATCH_ID;
608: end if;
609:
610: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
611:
612: END; -- procedure Validate_FDCNorth_Batch
613:
614: -- Validate Paymentech credit card batch

Line 666: FND_MSG_PUB.initialize;

662: raise FND_API.G_EXC_UNEXPECTED_ERROR;
663: end if;
664:
665: if FND_API.To_Boolean(p_init_msg_list) then
666: FND_MSG_PUB.initialize;
667: end if;
668:
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:

Line 685: FND_MSG_PUB.add;

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;
689:

Line 686: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
689:
690: -- Validate POSTAL CODE's

Line 705: FND_MSG_PUB.add;

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;
709:

Line 706: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
709:
710: elsif l_trxn_rec.instrtype = 'PURCHASECARD' then

Line 723: FND_MSG_PUB.add;

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;
727:

Line 724: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
727:
728: /*

Line 738: FND_MSG_PUB.add;

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;
742:

Line 739: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
742:
743: -- Shipping destination postal code

Line 752: FND_MSG_PUB.add;

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;
756: */

Line 753: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
756: */
757:

Line 769: FND_MSG_PUB.add;

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;
773:

Line 770: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
773:
774: -- Shipping-to postal code

Line 783: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

779: x_msg_data);
780: /*
781: if l_cust_trx_id = 0 then
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
784: return;
785: else
786: begin
787: select hl.postal_code, hl.country

Line 813: FND_MSG_PUB.add;

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;
817:

Line 814: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
817:
818:

Line 835: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

831:
832: end loop;
833: close level2_trxn;
834:
835: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
836:
837: END; -- procedure Validate_Paymentech_Batch
838:
839:

Line 1103: FND_MSG_PUB.initialize;

1099: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1100: end if;
1101:
1102: if FND_API.To_Boolean(p_init_msg_list) then
1103: FND_MSG_PUB.initialize;
1104: end if;
1105:
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107:

Line 1127: FND_MSG_PUB.add;

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
1131: print_debuginfo(G_DEBUG_MODULE, 'Checking Active Debit Authorization');

Line 1128: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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
1131: print_debuginfo(G_DEBUG_MODULE, 'Checking Active Debit Authorization');
1132: END IF;

Line 1153: FND_MSG_PUB.add;

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');
1157: END IF;

Line 1154: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1157: END IF;
1158: END;

Line 1177: FND_MSG_PUB.add;

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');
1181: END IF;

Line 1178: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1181: END IF;
1182: END;

Line 1191: FND_MSG_PUB.add;

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 ');
1195: END IF;

Line 1192: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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 ');
1195: END IF;
1196: ELSIF (l_auth_sign_date IS NULL )

Line 1201: FND_MSG_PUB.add;

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');
1205: END IF;

Line 1202: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1205: END IF;
1206: ELSIF (l_creditor_legal_entity_id IS NULL )

Line 1211: FND_MSG_PUB.add;

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 ');
1215: END IF;

Line 1212: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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 ');
1215: END IF;
1216: ELSIF (l_payee_address IS NULL )

Line 1221: FND_MSG_PUB.add;

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 ');
1225: END IF;

Line 1222: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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 ');
1225: END IF;
1226: ELSIF (l_creditor_identifier IS NULL )

Line 1231: FND_MSG_PUB.add;

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');
1235: END IF;

Line 1232: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1235: END IF;
1236: ELSIF (l_cust_addr_id IS NULL )

Line 1241: FND_MSG_PUB.add;

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');
1245: END IF;

Line 1242: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1245: END IF;
1246: ELSIF (l_creditor_le_name <> l_le_name)

Line 1251: FND_MSG_PUB.add;

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');
1255: END IF;

Line 1252: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1255: END IF;
1256: ELSIF (l_iban IS NULL )

Line 1261: FND_MSG_PUB.add;

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');
1265: END IF;

Line 1262: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1265: END IF;
1266: ELSIF (l_swift_code IS NULL )

Line 1271: FND_MSG_PUB.add;

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');
1275: END IF;

Line 1272: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1275: END IF;
1276: END IF;

Line 1316: FND_MSG_PUB.add;

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');
1320: END IF;

Line 1317: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1320: END IF;
1321: ELSIF (l_ini_party_id_issuer IS NULL)

Line 1326: FND_MSG_PUB.add;

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 ');
1330: END IF;

Line 1327: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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 ');
1330: END IF;
1331: ELSIF (l_ini_party_name IS NULL)

Line 1336: FND_MSG_PUB.add;

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');
1340: END IF;

Line 1337: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1340: END IF;
1341: ELSIF (l_batch_booking_flag IS NULL)

Line 1346: FND_MSG_PUB.add;

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');
1350: END IF;

Line 1347: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1350: END IF;
1351: ELSIF ((l_batch_booking_flag <> 'TRUE') AND (l_batch_booking_flag <> 'FALSE' ))

Line 1356: FND_MSG_PUB.add;

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');
1360: END IF;

Line 1357: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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');
1360: END IF;
1361: END IF;

Line 1387: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

1383: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1384: print_debuginfo(G_DEBUG_MODULE, 'After inactivating ... ');
1385: END IF;
1386:
1387: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1388:
1389: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1390: print_debuginfo(G_DEBUG_MODULE, 'Exiting ... ');
1391: END IF;

Line 1439: FND_MSG_PUB.initialize;

1435: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME ) THEN
1436: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1437: END IF;
1438: IF FND_API.To_Boolean(p_init_msg_list) THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: OPEN c_settle_trxns;
1443: LOOP

Line 1459: FND_MSG_PUB.add;

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;
1463: CLOSE c_mandate;

Line 1460: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

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;
1463: CLOSE c_mandate;
1464: END LOOP;

Line 1466: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);

1462: END IF;
1463: CLOSE c_mandate;
1464: END LOOP;
1465: CLOSE c_settle_trxns;
1466: FND_MSG_PUB.Count_And_Get('T',x_msg_count,x_msg_data);
1467: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1468: print_debuginfo(G_DEBUG_MODULE, 'Exiting ... ');
1469: END IF;
1470: END; -- End Validate_NonSEPA_Active_Mandate