DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on FND_MSG_PUB

Line 256: FND_MSG_PUB.Add;

252: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
253: debug_level => FND_LOG.LEVEL_ERROR,
254: module => G_DEBUG_MODULE || l_module);
255: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 261: FND_MSG_PUB.initialize;

257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
264:
265: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 263: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

259:
260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
264:
265: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
266: l_payer_level,x_payer_attribs_id,l_payer_attribs);
267:

Line 327: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

323: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
324: debug_level => FND_LOG.LEVEL_ERROR,
325: module => G_DEBUG_MODULE || l_module);
326: x_return_status := FND_API.G_RET_STS_ERROR ;
327: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331:

Line 336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

332: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
333: debug_level => FND_LOG.LEVEL_UNEXPECTED,
334: module => G_DEBUG_MODULE || l_module);
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339: WHEN OTHERS THEN
340:

Line 348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

344:
345: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
350: END IF;
351:
352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

345: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
350: END IF;
351:
352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
353: p_data => x_msg_data

Line 352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
350: END IF;
351:
352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355: END Set_Payer_Attributes;
356:

Line 386: FND_MSG_PUB.Add;

382: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
383: debug_level => FND_LOG.LEVEL_ERROR,
384: module => G_DEBUG_MODULE || l_module);
385: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
386: FND_MSG_PUB.Add;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 391: FND_MSG_PUB.initialize;

387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
394:
395: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 393: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

389:
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
394:
395: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
396: l_payer_level,x_payer_attribs_id,x_payer_attributes);
397: IF (x_payer_attribs_id IS NULL) THEN

Line 414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

410: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
411: debug_level => FND_LOG.LEVEL_ERROR,
412: module => G_DEBUG_MODULE || l_module);
413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
415: p_data => x_msg_data
416: );
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418:

Line 423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

419: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
420: debug_level => FND_LOG.LEVEL_UNEXPECTED,
421: module => G_DEBUG_MODULE || l_module);
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426: WHEN OTHERS THEN
427:

Line 432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

428: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
429: debug_level => FND_LOG.LEVEL_UNEXPECTED,
430: module => G_DEBUG_MODULE || l_module);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
433: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
434: END IF;
435:
436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 433: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);

429: debug_level => FND_LOG.LEVEL_UNEXPECTED,
430: module => G_DEBUG_MODULE || l_module);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
433: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
434: END IF;
435:
436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
437: p_data => x_msg_data

Line 436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
433: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
434: END IF;
435:
436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
437: p_data => x_msg_data
438: );
439: END Get_Payer_Attributes;
440:

Line 520: FND_MSG_PUB.Add;

516: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
517: debug_level => FND_LOG.LEVEL_ERROR,
518: module => G_DEBUG_MODULE || l_module);
519: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
520: FND_MSG_PUB.Add;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 525: FND_MSG_PUB.initialize;

521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: IF FND_API.to_Boolean( p_init_msg_list ) THEN
525: FND_MSG_PUB.initialize;
526: END IF;
527: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
528:
529: OPEN c_appl_attribs(p_channel_code);

Line 527: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

523:
524: IF FND_API.to_Boolean( p_init_msg_list ) THEN
525: FND_MSG_PUB.initialize;
526: END IF;
527: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
528:
529: OPEN c_appl_attribs(p_channel_code);
530: FETCH c_appl_attribs INTO
531: x_channel_attrib_uses.Instr_SecCode_Use,

Line 559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

555: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
556: debug_level => FND_LOG.LEVEL_ERROR,
557: module => G_DEBUG_MODULE || l_module);
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563:

Line 568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

564: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
565: debug_level => FND_LOG.LEVEL_UNEXPECTED,
566: module => G_DEBUG_MODULE || l_module);
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
569: p_data => x_msg_data
570: );
571: WHEN OTHERS THEN
572:

Line 580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

576:
577: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
578:
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
582: END IF;
583:
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

577: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
578:
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
582: END IF;
583:
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
585: p_data => x_msg_data

Line 584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
582: END IF;
583:
584: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587: END Get_Payment_Channel_Attribs;
588:

Line 636: FND_MSG_PUB.Add;

632: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
633: debug_level => FND_LOG.LEVEL_ERROR,
634: module => G_DEBUG_MODULE || l_module);
635: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
636: FND_MSG_PUB.Add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 641: FND_MSG_PUB.initialize;

637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
644:
645: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,l_payer_level,

Line 643: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

639:
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
644:
645: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,l_payer_level,
646: l_payer_id,l_payer_attribs);
647:

Line 730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

726: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
727: debug_level => FND_LOG.LEVEL_ERROR,
728: module => G_DEBUG_MODULE || l_module);
729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO Set_Payer_Default_Pmt_Channel;

Line 739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

735: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
736: debug_level => FND_LOG.LEVEL_UNEXPECTED,
737: module => G_DEBUG_MODULE || l_module);
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
740: p_data => x_msg_data
741: );
742: WHEN OTHERS THEN
743: ROLLBACK TO Set_Payer_Default_Pmt_Channel;

Line 752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

748:
749: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
754: END IF;
755:
756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

749: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
754: END IF;
755:
756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
757: p_data => x_msg_data

Line 756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
754: END IF;
755:
756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
757: p_data => x_msg_data
758: );
759: END Set_Payer_Default_Pmt_Channel;
760:

Line 805: FND_MSG_PUB.Add;

801: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
802: debug_level => FND_LOG.LEVEL_ERROR,
803: module => G_DEBUG_MODULE || l_module);
804: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
805: FND_MSG_PUB.Add;
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808:
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 810: FND_MSG_PUB.initialize;

806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808:
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
813:
814: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 812: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

808:
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
813:
814: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
815: l_payer_level,l_payer_id,l_payer_attribs);
816:

Line 842: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

838: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
839: debug_level => FND_LOG.LEVEL_ERROR,
840: module => G_DEBUG_MODULE || l_module);
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846:

Line 851: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

847: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
848: debug_level => FND_LOG.LEVEL_UNEXPECTED,
849: module => G_DEBUG_MODULE || l_module);
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: WHEN OTHERS THEN
855:

Line 863: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

859:
860: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
861:
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
863: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
864: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
865: END IF;
866:
867: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 864: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

860: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
861:
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
863: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
864: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
865: END IF;
866:
867: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
868: p_data => x_msg_data

Line 867: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

863: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
864: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
865: END IF;
866:
867: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
868: p_data => x_msg_data
869: );
870: END Get_Payer_Default_Pmt_Channel;
871:

Line 939: FND_MSG_PUB.Add;

935: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
936: debug_level => FND_LOG.LEVEL_ERROR,
937: module => G_DEBUG_MODULE || l_module);
938: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
939: FND_MSG_PUB.Add;
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 944: FND_MSG_PUB.initialize;

940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF FND_API.to_Boolean( p_init_msg_list ) THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
947:
948: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 946: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

942:
943: IF FND_API.to_Boolean( p_init_msg_list ) THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
947:
948: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
949: l_payer_level,l_payer_id,l_payer_attribs);
950:

Line 979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

975: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
976: debug_level => FND_LOG.LEVEL_ERROR,
977: module => G_DEBUG_MODULE || l_module);
978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
983:

Line 988: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

984: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
985: debug_level => FND_LOG.LEVEL_UNEXPECTED,
986: module => G_DEBUG_MODULE || l_module);
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
988: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
989: p_data => x_msg_data
990: );
991: WHEN OTHERS THEN
992:

Line 1000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

996:
997: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
998:
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1002: END IF;
1003:
1004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

997: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
998:
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1002: END IF;
1003:
1004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1005: p_data => x_msg_data

Line 1004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1002: END IF;
1003:
1004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1007: END Get_Trxn_Appl_Pmt_Channels;
1008:

Line 1078: FND_MSG_PUB.Add;

1074: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1075: debug_level => FND_LOG.LEVEL_ERROR,
1076: module => G_DEBUG_MODULE || l_module);
1077: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1078: FND_MSG_PUB.Add;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:
1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1083: FND_MSG_PUB.initialize;

1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:
1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1086:
1087: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 1085: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1081:
1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1086:
1087: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1088: l_payer_level,l_payer_id,l_payer_attribs);
1089:

Line 1281: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1277: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1278: debug_level => FND_LOG.LEVEL_ERROR,
1279: module => G_DEBUG_MODULE || l_module);
1280: x_return_status := FND_API.G_RET_STS_ERROR ;
1281: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285: ROLLBACK TO Set_Payer_Instr_Assignment;

Line 1290: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1286: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1287: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1288: module => G_DEBUG_MODULE || l_module);
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1291: p_data => x_msg_data
1292: );
1293: WHEN OTHERS THEN
1294: ROLLBACK TO Set_Payer_Instr_Assignment;

Line 1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1298:
1299: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1300:
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1304: END IF;
1305:
1306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

1299: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1300:
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1304: END IF;
1305:
1306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1307: p_data => x_msg_data

Line 1306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1304: END IF;
1305:
1306: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1307: p_data => x_msg_data
1308: );
1309: END Set_Payer_Instr_Assignment;
1310:

Line 1356: FND_MSG_PUB.Add;

1352: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1353: debug_level => FND_LOG.LEVEL_ERROR,
1354: module => G_DEBUG_MODULE || l_module);
1355: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1356: FND_MSG_PUB.Add;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359:
1360: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1361: FND_MSG_PUB.initialize;

1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359:
1360: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1361: FND_MSG_PUB.initialize;
1362: END IF;
1363: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1364:
1365: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 1363: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1359:
1360: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1361: FND_MSG_PUB.initialize;
1362: END IF;
1363: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1364:
1365: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1366: l_payer_level,l_payer_id,l_payer_attribs);
1367:

Line 1401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1397: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1398: debug_level => FND_LOG.LEVEL_ERROR,
1399: module => G_DEBUG_MODULE || l_module);
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405:

Line 1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1406: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1407: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1408: module => G_DEBUG_MODULE || l_module);
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN OTHERS THEN
1414:

Line 1422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1418:
1419: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1420:
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1423: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1424: END IF;
1425:
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1423: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

1419: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1420:
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1423: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1424: END IF;
1425:
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1427: p_data => x_msg_data

Line 1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1423: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1424: END IF;
1425:
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1427: p_data => x_msg_data
1428: );
1429: END Get_Payer_Instr_Assignments;
1430:

Line 1474: FND_MSG_PUB.Add;

1470: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1471: debug_level => FND_LOG.LEVEL_ERROR,
1472: module => G_DEBUG_MODULE || l_module);
1473: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1474: FND_MSG_PUB.Add;
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1479: FND_MSG_PUB.initialize;

1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1482:
1483: l_instr_count := 0;

Line 1481: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1477:
1478: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1482:
1483: l_instr_count := 0;
1484: FOR assign_rec IN c_instr_assignments(p_party_id) LOOP
1485: l_instr_count := l_instr_count + 1;

Line 1506: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1502: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1503: debug_level => FND_LOG.LEVEL_ERROR,
1504: module => G_DEBUG_MODULE || l_module);
1505: x_return_status := FND_API.G_RET_STS_ERROR ;
1506: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510:

Line 1515: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1511: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1512: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1513: module => G_DEBUG_MODULE || l_module);
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: WHEN OTHERS THEN
1519:

Line 1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1523:
1524: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1525:
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1529: END IF;
1530:
1531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

1524: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1525:
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1529: END IF;
1530:
1531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1532: p_data => x_msg_data

Line 1531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1529: END IF;
1530:
1531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1532: p_data => x_msg_data
1533: );
1534:
1535: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 1615: FND_MSG_PUB.Add;

1611: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1612: debug_level => FND_LOG.LEVEL_ERROR,
1613: module => G_DEBUG_MODULE || l_module);
1614: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1615: FND_MSG_PUB.Add;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618:
1619: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1620: FND_MSG_PUB.initialize;

1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618:
1619: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1620: FND_MSG_PUB.initialize;
1621: END IF;
1622: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1623:
1624: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

Line 1622: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1618:
1619: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1620: FND_MSG_PUB.initialize;
1621: END IF;
1622: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1623:
1624: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1625: l_payer_level,l_payer_id,l_payer_attribs);
1626:

Line 1658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1654: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1655: debug_level => FND_LOG.LEVEL_ERROR,
1656: module => G_DEBUG_MODULE || l_module);
1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1662:

Line 1667: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1663: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1664: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1665: module => G_DEBUG_MODULE || l_module);
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1667: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1668: p_data => x_msg_data
1669: );
1670: WHEN OTHERS THEN
1671:

Line 1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1675:
1676: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1677:
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1681: END IF;
1682:
1683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

1676: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1677:
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1681: END IF;
1682:
1683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1684: p_data => x_msg_data

Line 1683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1681: END IF;
1682:
1683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1684: p_data => x_msg_data
1685: );
1686:
1687: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 1874: FND_MSG_PUB.Add;

1870: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1871: debug_level => FND_LOG.LEVEL_ERROR,
1872: module => G_DEBUG_MODULE || l_module);
1873: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1874: FND_MSG_PUB.Add;
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;
1877:
1878: IF (c_sec_mode%ISOPEN) THEN CLOSE c_sec_mode; END IF;

Line 1881: FND_MSG_PUB.initialize;

1877:
1878: IF (c_sec_mode%ISOPEN) THEN CLOSE c_sec_mode; END IF;
1879:
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;
1882: END IF;
1883: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1884:
1885: --SAVEPOINT Create_Card;

Line 1883: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1879:
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;
1882: END IF;
1883: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1884:
1885: --SAVEPOINT Create_Card;
1886:
1887: IBY_FNDCPT_SETUP_PUB.Card_Exists

Line 2100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2096: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2097: debug_level => FND_LOG.LEVEL_ERROR,
2098: module => G_DEBUG_MODULE || l_module);
2099: x_return_status := FND_API.G_RET_STS_ERROR ;
2100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: --ROLLBACK TO Create_Card;

Line 2109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2105: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2106: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2107: module => G_DEBUG_MODULE || l_module);
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2110: p_data => x_msg_data
2111: );
2112: WHEN OTHERS THEN
2113: --ROLLBACK TO Create_Card;

Line 2121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2117:
2118: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2119:
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2123: END IF;
2124:
2125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

2118: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2119:
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2123: END IF;
2124:
2125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2126: p_data => x_msg_data

Line 2125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2123: END IF;
2124:
2125: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2126: p_data => x_msg_data
2127: );
2128:
2129: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 2296: FND_MSG_PUB.Add;

2292: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2293: debug_level => FND_LOG.LEVEL_ERROR,
2294: module => G_DEBUG_MODULE || l_module);
2295: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2296: FND_MSG_PUB.Add;
2297: RAISE FND_API.G_EXC_ERROR;
2298: END IF;
2299:
2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2301: FND_MSG_PUB.initialize;

2297: RAISE FND_API.G_EXC_ERROR;
2298: END IF;
2299:
2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2301: FND_MSG_PUB.initialize;
2302: END IF;
2303: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2304:
2305: SAVEPOINT Update_Card;

Line 2303: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

2299:
2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2301: FND_MSG_PUB.initialize;
2302: END IF;
2303: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2304:
2305: SAVEPOINT Update_Card;
2306:
2307: -- card cannot become info only once this flag is turned off

Line 2368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2364: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2365: debug_level => FND_LOG.LEVEL_ERROR,
2366: module => G_DEBUG_MODULE || l_module);
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2369: p_data => x_msg_data
2370: );
2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2372: ROLLBACK TO Update_Card;

Line 2377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2373: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2374: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2375: module => G_DEBUG_MODULE || l_module);
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2378: p_data => x_msg_data
2379: );
2380: WHEN OTHERS THEN
2381: ROLLBACK TO Update_Card;

Line 2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2385:
2386: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2387:
2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2391: END IF;
2392:
2393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

2386: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2387:
2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2391: END IF;
2392:
2393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2394: p_data => x_msg_data

Line 2393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2391: END IF;
2392:
2393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2394: p_data => x_msg_data
2395: );
2396:
2397: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 2446: FND_MSG_PUB.Add;

2442: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2443: debug_level => FND_LOG.LEVEL_ERROR,
2444: module => G_DEBUG_MODULE || l_module);
2445: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2446: FND_MSG_PUB.Add;
2447: RAISE FND_API.G_EXC_ERROR;
2448: END IF;
2449:
2450: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2451: FND_MSG_PUB.initialize;

2447: RAISE FND_API.G_EXC_ERROR;
2448: END IF;
2449:
2450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2451: FND_MSG_PUB.initialize;
2452: END IF;
2453: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2454:
2455: OPEN c_card(p_card_id);

Line 2453: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

2449:
2450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2451: FND_MSG_PUB.initialize;
2452: END IF;
2453: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2454:
2455: OPEN c_card(p_card_id);
2456: FETCH c_card INTO x_card_instrument.Owner_Id, x_card_instrument.Card_Holder_Name,
2457: x_card_instrument.Billing_Address_Id, x_card_instrument.Card_Number,

Line 2482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2478: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2479: debug_level => FND_LOG.LEVEL_ERROR,
2480: module => G_DEBUG_MODULE || l_module);
2481: x_return_status := FND_API.G_RET_STS_ERROR ;
2482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2483: p_data => x_msg_data
2484: );
2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2486:

Line 2491: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2487: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2488: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2489: module => G_DEBUG_MODULE || l_module);
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2491: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2492: p_data => x_msg_data
2493: );
2494: WHEN OTHERS THEN
2495:

Line 2503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2499:
2500: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2501:
2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2505: END IF;
2506:
2507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

2500: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2501:
2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2505: END IF;
2506:
2507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2508: p_data => x_msg_data

Line 2507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2505: END IF;
2506:
2507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2508: p_data => x_msg_data
2509: );
2510:
2511: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 2575: FND_MSG_PUB.Add;

2571: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2572: debug_level => FND_LOG.LEVEL_ERROR,
2573: module => G_DEBUG_MODULE || l_module);
2574: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2575: FND_MSG_PUB.Add;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578:
2579: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2580: FND_MSG_PUB.initialize;

2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578:
2579: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2580: FND_MSG_PUB.initialize;
2581: END IF;
2582: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2583: IF (nvl(p_card_instr_type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD ) = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_PAYMENTCARD) THEN
2584: l_char_allowed := 'Y';

Line 2582: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

2578:
2579: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2580: FND_MSG_PUB.initialize;
2581: END IF;
2582: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2583: IF (nvl(p_card_instr_type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD ) = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_PAYMENTCARD) THEN
2584: l_char_allowed := 'Y';
2585: END IF;
2586:

Line 2633: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2629: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2630: debug_level => FND_LOG.LEVEL_ERROR,
2631: module => G_DEBUG_MODULE || l_module);
2632: x_return_status := FND_API.G_RET_STS_ERROR ;
2633: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637:

Line 2642: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2638: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2639: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2640: module => G_DEBUG_MODULE || l_module);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2642: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2643: p_data => x_msg_data
2644: );
2645: WHEN OTHERS THEN
2646:

Line 2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2650:
2651: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2652:
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2655: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2656: END IF;
2657:
2658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2655: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

2651: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2652:
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2655: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2656: END IF;
2657:
2658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2659: p_data => x_msg_data

Line 2658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2655: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2656: END IF;
2657:
2658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2659: p_data => x_msg_data
2660: );
2661:
2662: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 2710: FND_MSG_PUB.Add;

2706: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
2707: debug_level => FND_LOG.LEVEL_ERROR,
2708: module => G_DEBUG_MODULE || l_module);
2709: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2710: FND_MSG_PUB.Add;
2711: RAISE FND_API.G_EXC_ERROR;
2712: END IF;
2713:
2714: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2715: FND_MSG_PUB.initialize;

2711: RAISE FND_API.G_EXC_ERROR;
2712: END IF;
2713:
2714: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2715: FND_MSG_PUB.initialize;
2716: END IF;
2717: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2718:
2719: l_existing_msgs := NVL(x_msg_count,0);

Line 2717: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

2713:
2714: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2715: FND_MSG_PUB.initialize;
2716: END IF;
2717: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2718:
2719: l_existing_msgs := NVL(x_msg_count,0);
2720:
2721: SAVEPOINT Process_Credit_Card;

Line 2765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2761: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2762: debug_level => FND_LOG.LEVEL_ERROR,
2763: module => G_DEBUG_MODULE || l_module);
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2769: ROLLBACK TO Process_Credit_Card;

Line 2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2770: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2772: module => G_DEBUG_MODULE || l_module);
2773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2775: p_data => x_msg_data
2776: );
2777: WHEN OTHERS THEN
2778: ROLLBACK TO Process_Credit_Card;

Line 2786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2782:
2783: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2784:
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2787: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2788: END IF;
2789:
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2787: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));

2783: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2784:
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2787: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2788: END IF;
2789:
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2791: p_data => x_msg_data

Line 2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

2786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2787: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2788: END IF;
2789:
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2791: p_data => x_msg_data
2792: );
2793:
2794: END Process_Credit_Card;