APPS.AR_BILLS_MAINTAIN_PUB dependencies on FND_API

Line 156: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

152:
153: -- ***** Standard API parameters *****
154:
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,

Line 157: p_commit IN VARCHAR2 := FND_API.G_FALSE,

153: -- ***** Standard API parameters *****
154:
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,

Line 158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

154:
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162:

Line 223: IF NOT FND_API.Compatible_API_Call( l_api_version ,

219: /*-----------------------------------------------+
220: | Standard call to check for call compatibility |
221: +-----------------------------------------------*/
222:
223: IF NOT FND_API.Compatible_API_Call( l_api_version ,
224: p_api_version ,
225: l_api_name ,
226: G_PKG_NAME )
227: THEN

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: p_api_version ,
225: l_api_name ,
226: G_PKG_NAME )
227: THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: END IF;
230:
231:
232: /*--------------------------------------------------------------+

Line 236: IF FND_API.to_Boolean( p_init_msg_list ) THEN

232: /*--------------------------------------------------------------+
233: | Initialize message list if p_init_msg_list is set to TRUE |
234: +--------------------------------------------------------------*/
235:
236: IF FND_API.to_Boolean( p_init_msg_list ) THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:
240:

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: /*-----------------------------------------------+
242: | Initialize return status to SUCCESS |
243: +-----------------------------------------------*/
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247:
248:
249: /*------------------------------------------------+

Line 315: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected

311: p_payment_channel => 'BILLS_RECEIVABLE',
312: p_instrument_assign_id => l_instr_id,
313: p_payment_trxn_extn_id => l_payment_trxn_extension_id);
314:
315: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected
316: IF x_return_status <> 'S'
317: THEN
318: FND_MESSAGE.set_name( 'AR' , 'AR_BR_CANNOT_COMPLETE' );
319: FND_MESSAGE.set_token( 'BRNUM' , l_trx_rec.trx_number);

Line 474: IF FND_API.To_Boolean( p_commit )

470: /*-----------------------------------------------+
471: | Standard check of p_commit |
472: +-----------------------------------------------*/
473:
474: IF FND_API.To_Boolean( p_commit )
475: THEN
476: IF PG_DEBUG in ('Y', 'C') THEN
477: arp_util.debug( 'committing');
478: END IF;

Line 488: WHEN FND_API.G_EXC_ERROR THEN

484: END IF;
485:
486:
487: EXCEPTION
488: WHEN FND_API.G_EXC_ERROR THEN
489: IF PG_DEBUG in ('Y', 'C') THEN
490: arp_util.debug( 'SQLCODE : ' || SQLCODE);
491: arp_util.debug( 'SQLERRM : ' || SQLERRM);
492: END IF;

Line 494: x_return_status := FND_API.G_RET_STS_ERROR ;

490: arp_util.debug( 'SQLCODE : ' || SQLCODE);
491: arp_util.debug( 'SQLERRM : ' || SQLERRM);
492: END IF;
493: ROLLBACK TO Complete_BR_PVT;
494: x_return_status := FND_API.G_RET_STS_ERROR ;
495: IF PG_DEBUG in ('Y', 'C') THEN
496: arp_util.debug( 'Exception Error');
497: END IF;
498: raise;

Line 501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

497: END IF;
498: raise;
499:
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502: IF PG_DEBUG in ('Y', 'C') THEN
503: arp_util.debug( 'SQLCODE : ' || SQLCODE);
504: arp_util.debug( 'SQLERRM : ' || SQLERRM);
505: END IF;

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

503: arp_util.debug( 'SQLCODE : ' || SQLCODE);
504: arp_util.debug( 'SQLERRM : ' || SQLERRM);
505: END IF;
506: ROLLBACK TO Complete_BR_PVT;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508: IF PG_DEBUG in ('Y', 'C') THEN
509: arp_util.debug( 'Exception Unexpected Error');
510: END IF;
511: RAISE;

Line 532: x_return_status := FND_API.G_RET_STS_ERROR ;

528: IF PG_DEBUG in ('Y', 'C') THEN
529: arp_util.debug( 'Exception Others -20001');
530: END IF;
531: ROLLBACK TO Complete_BR_PVT;
532: x_return_status := FND_API.G_RET_STS_ERROR ;
533: RAISE;
534:
535: ELSE
536: IF PG_DEBUG in ('Y', 'C') THEN

Line 543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

539: NULL;
540: END IF;
541:
542: ROLLBACK TO Complete_BR_PVT;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: RAISE;
545:
546: END Complete_BR;
547:

Line 564: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

560:
561: -- ***** Standard API parameters *****
562:
563: p_api_version IN NUMBER ,
564: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
565: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
566: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
567: x_return_status OUT NOCOPY VARCHAR2 ,
568: x_msg_count OUT NOCOPY NUMBER ,

Line 565: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

561: -- ***** Standard API parameters *****
562:
563: p_api_version IN NUMBER ,
564: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
565: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
566: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
567: x_return_status OUT NOCOPY VARCHAR2 ,
568: x_msg_count OUT NOCOPY NUMBER ,
569: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 566: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

562:
563: p_api_version IN NUMBER ,
564: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
565: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
566: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
567: x_return_status OUT NOCOPY VARCHAR2 ,
568: x_msg_count OUT NOCOPY NUMBER ,
569: x_msg_data OUT NOCOPY VARCHAR2 ,
570:

Line 609: IF NOT FND_API.Compatible_API_Call( l_api_version ,

605: /*-----------------------------------------------+
606: | Standard call to check for call compatibility |
607: +-----------------------------------------------*/
608:
609: IF NOT FND_API.Compatible_API_Call( l_api_version ,
610: p_api_version ,
611: l_api_name ,
612: G_PKG_NAME )
613: THEN

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: p_api_version ,
611: l_api_name ,
612: G_PKG_NAME )
613: THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617:
618: /*--------------------------------------------------------------+

Line 622: IF FND_API.to_Boolean( p_init_msg_list ) THEN

618: /*--------------------------------------------------------------+
619: | Initialize message list if p_init_msg_list is set to TRUE |
620: +--------------------------------------------------------------*/
621:
622: IF FND_API.to_Boolean( p_init_msg_list ) THEN
623: FND_MSG_PUB.initialize;
624: END IF;
625:
626:

Line 631: x_return_status := FND_API.G_RET_STS_SUCCESS;

627: /*-----------------------------------------------+
628: | Initialize return status to SUCCESS |
629: +-----------------------------------------------*/
630:
631: x_return_status := FND_API.G_RET_STS_SUCCESS;
632:
633:
634: /*-----------------------------------------------------------------------+
635: | ============ START OF API BODY - UNCOMPLETE BR ================= |

Line 773: IF FND_API.To_Boolean( p_commit )

769: /*-----------------------------------------------+
770: | Standard check of p_commit |
771: +-----------------------------------------------*/
772:
773: IF FND_API.To_Boolean( p_commit )
774: THEN
775: IF PG_DEBUG in ('Y', 'C') THEN
776: arp_util.debug( 'committing');
777: END IF;

Line 787: WHEN FND_API.G_EXC_ERROR THEN

783: END IF;
784:
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: IF PG_DEBUG in ('Y', 'C') THEN
789: arp_util.debug( 'SQLCODE : ' || SQLCODE);
790: arp_util.debug( 'SQLERRM : ' || SQLERRM);
791: END IF;

Line 793: x_return_status := FND_API.G_RET_STS_ERROR ;

789: arp_util.debug( 'SQLCODE : ' || SQLCODE);
790: arp_util.debug( 'SQLERRM : ' || SQLERRM);
791: END IF;
792: ROLLBACK TO UnComplete_BR_PVT;
793: x_return_status := FND_API.G_RET_STS_ERROR ;
794: IF PG_DEBUG in ('Y', 'C') THEN
795: arp_util.debug( 'Exception Error');
796: END IF;
797: raise;

Line 800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

796: END IF;
797: raise;
798:
799:
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801: IF PG_DEBUG in ('Y', 'C') THEN
802: arp_util.debug( 'SQLCODE : ' || SQLCODE);
803: arp_util.debug( 'SQLERRM : ' || SQLERRM);
804: END IF;

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

802: arp_util.debug( 'SQLCODE : ' || SQLCODE);
803: arp_util.debug( 'SQLERRM : ' || SQLERRM);
804: END IF;
805: ROLLBACK TO UnComplete_BR_PVT;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: IF PG_DEBUG in ('Y', 'C') THEN
808: arp_util.debug( 'Exception Unexpected Error');
809: END IF;
810: raise;

Line 831: x_return_status := FND_API.G_RET_STS_ERROR ;

827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_util.debug( 'Exception Others -20001');
829: END IF;
830: ROLLBACK TO UnComplete_BR_PVT;
831: x_return_status := FND_API.G_RET_STS_ERROR ;
832: RAISE;
833: ELSE
834: IF PG_DEBUG in ('Y', 'C') THEN
835: arp_util.debug( 'Exception Others');

Line 841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

837: NULL;
838: END IF;
839:
840: ROLLBACK TO UnComplete_BR_PVT;
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
842: RAISE;
843:
844: END UnComplete_BR;
845:

Line 863: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

859:
860: -- ***** Standard API parameters *****
861:
862: p_api_version IN NUMBER ,
863: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
864: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
865: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
866: x_return_status OUT NOCOPY VARCHAR2 ,
867: x_msg_count OUT NOCOPY NUMBER ,

Line 864: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

860: -- ***** Standard API parameters *****
861:
862: p_api_version IN NUMBER ,
863: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
864: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
865: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
866: x_return_status OUT NOCOPY VARCHAR2 ,
867: x_msg_count OUT NOCOPY NUMBER ,
868: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 865: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

861:
862: p_api_version IN NUMBER ,
863: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
864: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
865: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
866: x_return_status OUT NOCOPY VARCHAR2 ,
867: x_msg_count OUT NOCOPY NUMBER ,
868: x_msg_data OUT NOCOPY VARCHAR2 ,
869:

Line 914: IF NOT FND_API.Compatible_API_Call( l_api_version ,

910: /*-----------------------------------------------+
911: | Standard call to check for call compatibility |
912: +-----------------------------------------------*/
913:
914: IF NOT FND_API.Compatible_API_Call( l_api_version ,
915: p_api_version ,
916: l_api_name ,
917: G_PKG_NAME )
918: THEN

Line 919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

915: p_api_version ,
916: l_api_name ,
917: G_PKG_NAME )
918: THEN
919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
920: END IF;
921:
922:
923: /*--------------------------------------------------------------+

Line 927: IF FND_API.to_Boolean( p_init_msg_list ) THEN

923: /*--------------------------------------------------------------+
924: | Initialize message list if p_init_msg_list is set to TRUE |
925: +--------------------------------------------------------------*/
926:
927: IF FND_API.to_Boolean( p_init_msg_list ) THEN
928: FND_MSG_PUB.initialize;
929: END IF;
930:
931:

Line 936: x_return_status := FND_API.G_RET_STS_SUCCESS;

932: /*-----------------------------------------------+
933: | Initialize return status to SUCCESS |
934: +-----------------------------------------------*/
935:
936: x_return_status := FND_API.G_RET_STS_SUCCESS;
937:
938:
939: /*-----------------------------------------------------------------------+
940: | ============ START OF API BODY - ACCEPT BR =================== |

Line 1063: IF FND_API.To_Boolean( p_commit )

1059: /*-----------------------------------------------+
1060: | Standard check of p_commit |
1061: +-----------------------------------------------*/
1062:
1063: IF FND_API.To_Boolean( p_commit )
1064: THEN
1065: IF PG_DEBUG in ('Y', 'C') THEN
1066: arp_util.debug( 'committing');
1067: END IF;

Line 1077: WHEN FND_API.G_EXC_ERROR THEN

1073: END IF;
1074:
1075:
1076: EXCEPTION
1077: WHEN FND_API.G_EXC_ERROR THEN
1078: IF PG_DEBUG in ('Y', 'C') THEN
1079: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1080: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1081: END IF;

Line 1083: x_return_status := FND_API.G_RET_STS_ERROR ;

1079: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1080: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1081: END IF;
1082: ROLLBACK TO Accept_BR_PVT;
1083: x_return_status := FND_API.G_RET_STS_ERROR ;
1084: IF PG_DEBUG in ('Y', 'C') THEN
1085: arp_util.debug( 'Exception Error');
1086: END IF;
1087: RAISE;

Line 1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1086: END IF;
1087: RAISE;
1088:
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: IF PG_DEBUG in ('Y', 'C') THEN
1092: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1093: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1094: END IF;

Line 1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1092: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1093: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1094: END IF;
1095: ROLLBACK TO Accept_BR_PVT;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097: IF PG_DEBUG in ('Y', 'C') THEN
1098: arp_util.debug( 'Exception Unexpected Error');
1099: END IF;
1100: RAISE;

Line 1118: x_return_status := FND_API.G_RET_STS_ERROR ;

1114:
1115: IF (SQLCODE = -20001)
1116: THEN
1117: ROLLBACK TO Accept_BR_PVT;
1118: x_return_status := FND_API.G_RET_STS_ERROR ;
1119: RAISE;
1120: ELSE
1121: NULL;
1122: END IF;

Line 1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1121: NULL;
1122: END IF;
1123:
1124: ROLLBACK TO Accept_BR_PVT;
1125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1126: RAISE;
1127:
1128:
1129: END Accept_BR;

Line 1147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

1143:
1144: -- ***** Standard API parameters *****
1145:
1146: p_api_version IN NUMBER ,
1147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1148: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1150: x_return_status OUT NOCOPY VARCHAR2 ,
1151: x_msg_count OUT NOCOPY NUMBER ,

Line 1148: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

1144: -- ***** Standard API parameters *****
1145:
1146: p_api_version IN NUMBER ,
1147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1148: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1150: x_return_status OUT NOCOPY VARCHAR2 ,
1151: x_msg_count OUT NOCOPY NUMBER ,
1152: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

1145:
1146: p_api_version IN NUMBER ,
1147: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1148: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1150: x_return_status OUT NOCOPY VARCHAR2 ,
1151: x_msg_count OUT NOCOPY NUMBER ,
1152: x_msg_data OUT NOCOPY VARCHAR2 ,
1153:

Line 1191: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1187: /*-----------------------------------------------+
1188: | Standard call to check for call compatibility |
1189: +-----------------------------------------------*/
1190:
1191: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1192: p_api_version ,
1193: l_api_name ,
1194: G_PKG_NAME )
1195: THEN

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1192: p_api_version ,
1193: l_api_name ,
1194: G_PKG_NAME )
1195: THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199:
1200: /*--------------------------------------------------------------+

Line 1204: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1200: /*--------------------------------------------------------------+
1201: | Initialize message list if p_init_msg_list is set to TRUE |
1202: +--------------------------------------------------------------*/
1203:
1204: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1205: FND_MSG_PUB.initialize;
1206: END IF;
1207:
1208:

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: /*-----------------------------------------------+
1210: | Initialize return status to SUCCESS |
1211: +-----------------------------------------------*/
1212:
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215:
1216: /*-----------------------------------------------------------------------+
1217: | ============ START OF API BODY - HOLD BR =================== |

Line 1337: IF FND_API.To_Boolean( p_commit )

1333: /*-----------------------------------------------+
1334: | Standard check of p_commit |
1335: +-----------------------------------------------*/
1336:
1337: IF FND_API.To_Boolean( p_commit )
1338: THEN
1339: IF PG_DEBUG in ('Y', 'C') THEN
1340: arp_util.debug( 'committing');
1341: END IF;

Line 1351: WHEN FND_API.G_EXC_ERROR THEN

1347: END IF;
1348:
1349:
1350: EXCEPTION
1351: WHEN FND_API.G_EXC_ERROR THEN
1352: IF PG_DEBUG in ('Y', 'C') THEN
1353: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1354: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1355: END IF;

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR ;

1353: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1354: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1355: END IF;
1356: ROLLBACK TO Hold_BR_PVT;
1357: x_return_status := FND_API.G_RET_STS_ERROR ;
1358: IF PG_DEBUG in ('Y', 'C') THEN
1359: arp_util.debug( 'Exception Error');
1360: END IF;
1361: RAISE;

Line 1363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1359: arp_util.debug( 'Exception Error');
1360: END IF;
1361: RAISE;
1362:
1363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1364: IF PG_DEBUG in ('Y', 'C') THEN
1365: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1366: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1367: END IF;

Line 1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1365: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1366: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1367: END IF;
1368: ROLLBACK TO Hold_BR_PVT;
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF PG_DEBUG in ('Y', 'C') THEN
1371: arp_util.debug( 'Exception Unexpected Error');
1372: END IF;
1373: RAISE;

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR ;

1386:
1387: IF (SQLCODE = -20001)
1388: THEN
1389: ROLLBACK TO Hold_BR_PVT;
1390: x_return_status := FND_API.G_RET_STS_ERROR ;
1391: RAISE;
1392: ELSE
1393: NULL;
1394: END IF;

Line 1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1393: NULL;
1394: END IF;
1395:
1396: ROLLBACK TO Hold_BR_PVT;
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1398: RAISE;
1399:
1400: END Hold_BR;
1401:

Line 1418: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

1414:
1415: -- ***** Standard API parameters *****
1416:
1417: p_api_version IN NUMBER ,
1418: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1419: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1421: x_return_status OUT NOCOPY VARCHAR2 ,
1422: x_msg_count OUT NOCOPY NUMBER ,

Line 1419: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

1415: -- ***** Standard API parameters *****
1416:
1417: p_api_version IN NUMBER ,
1418: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1419: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1421: x_return_status OUT NOCOPY VARCHAR2 ,
1422: x_msg_count OUT NOCOPY NUMBER ,
1423: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

1416:
1417: p_api_version IN NUMBER ,
1418: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1419: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1420: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1421: x_return_status OUT NOCOPY VARCHAR2 ,
1422: x_msg_count OUT NOCOPY NUMBER ,
1423: x_msg_data OUT NOCOPY VARCHAR2 ,
1424:

Line 1462: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1458: /*-----------------------------------------------+
1459: | Standard call to check for call compatibility |
1460: +-----------------------------------------------*/
1461:
1462: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1463: p_api_version ,
1464: l_api_name ,
1465: G_PKG_NAME )
1466: THEN

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: p_api_version ,
1464: l_api_name ,
1465: G_PKG_NAME )
1466: THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469:
1470:
1471: /*--------------------------------------------------------------+

Line 1475: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1471: /*--------------------------------------------------------------+
1472: | Initialize message list if p_init_msg_list is set to TRUE |
1473: +--------------------------------------------------------------*/
1474:
1475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1476: FND_MSG_PUB.initialize;
1477: END IF;
1478:
1479:

Line 1484: x_return_status := FND_API.G_RET_STS_SUCCESS;

1480: /*-----------------------------------------------+
1481: | Initialize return status to SUCCESS |
1482: +-----------------------------------------------*/
1483:
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486:
1487: /*-----------------------------------------------------------------------+
1488: | ============ START OF API BODY - UNHOLD BR =================== |

Line 1603: IF FND_API.To_Boolean( p_commit )

1599: /*-----------------------------------------------+
1600: | Standard check of p_commit |
1601: +-----------------------------------------------*/
1602:
1603: IF FND_API.To_Boolean( p_commit )
1604: THEN
1605: IF PG_DEBUG in ('Y', 'C') THEN
1606: arp_util.debug( 'committing');
1607: END IF;

Line 1617: WHEN FND_API.G_EXC_ERROR THEN

1613: END IF;
1614:
1615:
1616: EXCEPTION
1617: WHEN FND_API.G_EXC_ERROR THEN
1618: IF PG_DEBUG in ('Y', 'C') THEN
1619: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1620: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1621: END IF;

Line 1623: x_return_status := FND_API.G_RET_STS_ERROR ;

1619: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1620: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1621: END IF;
1622: ROLLBACK TO UnHold_BR_PVT;
1623: x_return_status := FND_API.G_RET_STS_ERROR ;
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: arp_util.debug( 'Exception Error');
1626: END IF;
1627: RAISE;

Line 1629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1625: arp_util.debug( 'Exception Error');
1626: END IF;
1627: RAISE;
1628:
1629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1630: IF PG_DEBUG in ('Y', 'C') THEN
1631: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1632: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1633: END IF;

Line 1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1631: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1632: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1633: END IF;
1634: ROLLBACK TO UnHold_BR_PVT;
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_util.debug( 'Exception Unexpected Error');
1638: END IF;
1639: RAISE;

Line 1656: x_return_status := FND_API.G_RET_STS_ERROR ;

1652:
1653: IF (SQLCODE = -20001)
1654: THEN
1655: ROLLBACK TO UnHold_BR_PVT;
1656: x_return_status := FND_API.G_RET_STS_ERROR ;
1657: RAISE;
1658: ELSE
1659: NULL;
1660: END IF;

Line 1663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1659: NULL;
1660: END IF;
1661:
1662: ROLLBACK TO UnHold_BR_PVT;
1663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1664: RAISE;
1665:
1666: END UnHold_BR;
1667:

Line 2440: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

2436:
2437: -- ***** Standard API parameters *****
2438:
2439: p_api_version IN NUMBER ,
2440: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2441: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2443: x_return_status OUT NOCOPY VARCHAR2 ,
2444: x_msg_count OUT NOCOPY NUMBER ,

Line 2441: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2437: -- ***** Standard API parameters *****
2438:
2439: p_api_version IN NUMBER ,
2440: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2441: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2443: x_return_status OUT NOCOPY VARCHAR2 ,
2444: x_msg_count OUT NOCOPY NUMBER ,
2445: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 2442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

2438:
2439: p_api_version IN NUMBER ,
2440: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2441: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2443: x_return_status OUT NOCOPY VARCHAR2 ,
2444: x_msg_count OUT NOCOPY NUMBER ,
2445: x_msg_data OUT NOCOPY VARCHAR2 ,
2446:

Line 2497: IF NOT FND_API.Compatible_API_Call( l_api_version ,

2493: /*-----------------------------------------------+
2494: | Standard call to check for call compatibility |
2495: +-----------------------------------------------*/
2496:
2497: IF NOT FND_API.Compatible_API_Call( l_api_version ,
2498: p_api_version ,
2499: l_api_name ,
2500: G_PKG_NAME )
2501: THEN

Line 2502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2498: p_api_version ,
2499: l_api_name ,
2500: G_PKG_NAME )
2501: THEN
2502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2503: END IF;
2504:
2505:
2506: /*--------------------------------------------------------------+

Line 2510: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2506: /*--------------------------------------------------------------+
2507: | Initialize message list if p_init_msg_list is set to TRUE |
2508: +--------------------------------------------------------------*/
2509:
2510: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2511: FND_MSG_PUB.initialize;
2512: END IF;
2513:
2514:

Line 2519: x_return_status := FND_API.G_RET_STS_SUCCESS;

2515: /*-----------------------------------------------+
2516: | Initialize return status to SUCCESS |
2517: +-----------------------------------------------*/
2518:
2519: x_return_status := FND_API.G_RET_STS_SUCCESS;
2520:
2521:
2522: /*-----------------------------------------------------------------------+
2523: | ============ START OF API BODY - CANCEL BR =================== |

Line 2689: IF FND_API.To_Boolean( p_commit )

2685: /*-----------------------------------------------+
2686: | Standard check of p_commit |
2687: +-----------------------------------------------*/
2688:
2689: IF FND_API.To_Boolean( p_commit )
2690: THEN
2691: IF PG_DEBUG in ('Y', 'C') THEN
2692: arp_util.debug( 'committing');
2693: END IF;

Line 2703: WHEN FND_API.G_EXC_ERROR THEN

2699: END IF;
2700:
2701:
2702: EXCEPTION
2703: WHEN FND_API.G_EXC_ERROR THEN
2704: IF PG_DEBUG in ('Y', 'C') THEN
2705: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2706: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2707: END IF;

Line 2709: x_return_status := FND_API.G_RET_STS_ERROR ;

2705: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2706: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2707: END IF;
2708: ROLLBACK TO Cancel_BR_PVT;
2709: x_return_status := FND_API.G_RET_STS_ERROR ;
2710: IF PG_DEBUG in ('Y', 'C') THEN
2711: arp_util.debug( 'Exception Error');
2712: END IF;
2713: RAISE;

Line 2716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2712: END IF;
2713: RAISE;
2714:
2715:
2716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2717: IF PG_DEBUG in ('Y', 'C') THEN
2718: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2719: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2720: END IF;

Line 2722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2718: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2719: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2720: END IF;
2721: ROLLBACK TO Cancel_BR_PVT;
2722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2723: IF PG_DEBUG in ('Y', 'C') THEN
2724: arp_util.debug( 'Exception Unexpected Error');
2725: END IF;
2726: RAISE;

Line 2744: x_return_status := FND_API.G_RET_STS_ERROR ;

2740:
2741: IF (SQLCODE = -20001)
2742: THEN
2743: ROLLBACK TO Cancel_BR_PVT;
2744: x_return_status := FND_API.G_RET_STS_ERROR ;
2745: RAISE;
2746: ELSE
2747: NULL;
2748: END IF;

Line 2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2747: NULL;
2748: END IF;
2749:
2750: ROLLBACK TO Cancel_BR_PVT;
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2752: RAISE;
2753:
2754: END Cancel_BR;
2755:

Line 2772: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

2768:
2769: -- ***** Standard API parameters *****
2770:
2771: p_api_version IN NUMBER ,
2772: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2773: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2775: x_return_status OUT NOCOPY VARCHAR2 ,
2776: x_msg_count OUT NOCOPY NUMBER ,

Line 2773: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

2769: -- ***** Standard API parameters *****
2770:
2771: p_api_version IN NUMBER ,
2772: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2773: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2775: x_return_status OUT NOCOPY VARCHAR2 ,
2776: x_msg_count OUT NOCOPY NUMBER ,
2777: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 2774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

2770:
2771: p_api_version IN NUMBER ,
2772: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2773: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2774: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2775: x_return_status OUT NOCOPY VARCHAR2 ,
2776: x_msg_count OUT NOCOPY NUMBER ,
2777: x_msg_data OUT NOCOPY VARCHAR2 ,
2778:

Line 2824: IF NOT FND_API.Compatible_API_Call( l_api_version ,

2820: /*-----------------------------------------------+
2821: | Standard call to check for call compatibility |
2822: +-----------------------------------------------*/
2823:
2824: IF NOT FND_API.Compatible_API_Call( l_api_version ,
2825: p_api_version ,
2826: l_api_name ,
2827: G_PKG_NAME )
2828: THEN

Line 2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2825: p_api_version ,
2826: l_api_name ,
2827: G_PKG_NAME )
2828: THEN
2829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2830: END IF;
2831:
2832:
2833: /*--------------------------------------------------------------+

Line 2837: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2833: /*--------------------------------------------------------------+
2834: | Initialize message list if p_init_msg_list is set to TRUE |
2835: +--------------------------------------------------------------*/
2836:
2837: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2838: FND_MSG_PUB.initialize;
2839: END IF;
2840:
2841:

Line 2846: x_return_status := FND_API.G_RET_STS_SUCCESS;

2842: /*-----------------------------------------------+
2843: | Initialize return status to SUCCESS |
2844: +-----------------------------------------------*/
2845:
2846: x_return_status := FND_API.G_RET_STS_SUCCESS;
2847:
2848:
2849: /*-----------------------------------------------------------------------+
2850: | ============ START OF API BODY - UNPAID BR =================== |

Line 2990: IF FND_API.To_Boolean( p_commit )

2986: /*-----------------------------------------------+
2987: | Standard check of p_commit |
2988: +-----------------------------------------------*/
2989:
2990: IF FND_API.To_Boolean( p_commit )
2991: THEN
2992: IF PG_DEBUG in ('Y', 'C') THEN
2993: arp_util.debug( 'committing');
2994: END IF;

Line 3004: WHEN FND_API.G_EXC_ERROR THEN

3000: END IF;
3001:
3002:
3003: EXCEPTION
3004: WHEN FND_API.G_EXC_ERROR THEN
3005: IF PG_DEBUG in ('Y', 'C') THEN
3006: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3007: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3008: END IF;

Line 3010: x_return_status := FND_API.G_RET_STS_ERROR ;

3006: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3007: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3008: END IF;
3009: ROLLBACK TO Unpaid_BR_PVT;
3010: x_return_status := FND_API.G_RET_STS_ERROR ;
3011: IF PG_DEBUG in ('Y', 'C') THEN
3012: arp_util.debug( 'Exception Error');
3013: END IF;
3014: RAISE;

Line 3017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3013: END IF;
3014: RAISE;
3015:
3016:
3017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3018: IF PG_DEBUG in ('Y', 'C') THEN
3019: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3020: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3021: END IF;

Line 3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3019: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3020: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3021: END IF;
3022: ROLLBACK TO Unpaid_BR_PVT;
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3024: IF PG_DEBUG in ('Y', 'C') THEN
3025: arp_util.debug( 'Exception Unexpected Error');
3026: END IF;
3027: RAISE;

Line 3045: x_return_status := FND_API.G_RET_STS_ERROR ;

3041:
3042: IF (SQLCODE = -20001)
3043: THEN
3044: ROLLBACK TO Unpaid_BR_PVT;
3045: x_return_status := FND_API.G_RET_STS_ERROR ;
3046: RAISE;
3047: ELSE
3048: NULL;
3049: END IF;

Line 3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3048: NULL;
3049: END IF;
3050:
3051: ROLLBACK TO Unpaid_BR_PVT;
3052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3053: RAISE;
3054:
3055: END Unpaid_BR;
3056:

Line 3073: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

3069:
3070: -- ***** Standard API parameters *****
3071:
3072: p_api_version IN NUMBER ,
3073: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3074: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3076: x_return_status OUT NOCOPY VARCHAR2 ,
3077: x_msg_count OUT NOCOPY NUMBER ,

Line 3074: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

3070: -- ***** Standard API parameters *****
3071:
3072: p_api_version IN NUMBER ,
3073: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3074: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3076: x_return_status OUT NOCOPY VARCHAR2 ,
3077: x_msg_count OUT NOCOPY NUMBER ,
3078: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 3075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

3071:
3072: p_api_version IN NUMBER ,
3073: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3074: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3075: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3076: x_return_status OUT NOCOPY VARCHAR2 ,
3077: x_msg_count OUT NOCOPY NUMBER ,
3078: x_msg_data OUT NOCOPY VARCHAR2 ,
3079:

Line 3128: IF NOT FND_API.Compatible_API_Call( l_api_version ,

3124: /*-----------------------------------------------+
3125: | Standard call to check for call compatibility |
3126: +-----------------------------------------------*/
3127:
3128: IF NOT FND_API.Compatible_API_Call( l_api_version ,
3129: p_api_version ,
3130: l_api_name ,
3131: G_PKG_NAME )
3132: THEN

Line 3133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3129: p_api_version ,
3130: l_api_name ,
3131: G_PKG_NAME )
3132: THEN
3133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3134: END IF;
3135:
3136:
3137: /*--------------------------------------------------------------+

Line 3141: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3137: /*--------------------------------------------------------------+
3138: | Initialize message list if p_init_msg_list is set to TRUE |
3139: +--------------------------------------------------------------*/
3140:
3141: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3142: FND_MSG_PUB.initialize;
3143: END IF;
3144:
3145:

Line 3150: x_return_status := FND_API.G_RET_STS_SUCCESS;

3146: /*-----------------------------------------------+
3147: | Initialize return status to SUCCESS |
3148: +-----------------------------------------------*/
3149:
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151:
3152:
3153: /*-----------------------------------------------------------------------+
3154: | ============ START OF API BODY - ENDORSE BR =================== |

Line 3369: IF FND_API.To_Boolean( p_commit )

3365: /*-----------------------------------------------+
3366: | Standard check of p_commit |
3367: +-----------------------------------------------*/
3368:
3369: IF FND_API.To_Boolean( p_commit )
3370: THEN
3371: IF PG_DEBUG in ('Y', 'C') THEN
3372: arp_util.debug( 'committing');
3373: END IF;

Line 3383: WHEN FND_API.G_EXC_ERROR THEN

3379: END IF;
3380:
3381:
3382: EXCEPTION
3383: WHEN FND_API.G_EXC_ERROR THEN
3384: IF PG_DEBUG in ('Y', 'C') THEN
3385: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3386: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3387: END IF;

Line 3389: x_return_status := FND_API.G_RET_STS_ERROR ;

3385: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3386: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3387: END IF;
3388: ROLLBACK TO Endorse_BR_PVT;
3389: x_return_status := FND_API.G_RET_STS_ERROR ;
3390: IF PG_DEBUG in ('Y', 'C') THEN
3391: arp_util.debug( 'Exception Error');
3392: END IF;
3393: RAISE;

Line 3395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3391: arp_util.debug( 'Exception Error');
3392: END IF;
3393: RAISE;
3394:
3395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3396: IF PG_DEBUG in ('Y', 'C') THEN
3397: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3398: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3399: END IF;

Line 3401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3397: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3398: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3399: END IF;
3400: ROLLBACK TO Endorse_BR_PVT;
3401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3402: IF PG_DEBUG in ('Y', 'C') THEN
3403: arp_util.debug( 'Exception Unexpected Error');
3404: END IF;
3405: RAISE;

Line 3423: x_return_status := FND_API.G_RET_STS_ERROR ;

3419:
3420: IF (SQLCODE = -20001)
3421: THEN
3422: ROLLBACK TO Endorse_BR_PVT;
3423: x_return_status := FND_API.G_RET_STS_ERROR ;
3424: RAISE;
3425: ELSE
3426: NULL;
3427: END IF;

Line 3430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3426: NULL;
3427: END IF;
3428:
3429: ROLLBACK TO Endorse_BR_PVT;
3430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3431: RAISE;
3432:
3433:
3434: END Endorse_BR;

Line 3452: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

3448:
3449: -- ***** Standard API parameters *****
3450:
3451: p_api_version IN NUMBER ,
3452: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3453: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3455: x_return_status OUT NOCOPY VARCHAR2 ,
3456: x_msg_count OUT NOCOPY NUMBER ,

Line 3453: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

3449: -- ***** Standard API parameters *****
3450:
3451: p_api_version IN NUMBER ,
3452: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3453: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3455: x_return_status OUT NOCOPY VARCHAR2 ,
3456: x_msg_count OUT NOCOPY NUMBER ,
3457: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 3454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

3450:
3451: p_api_version IN NUMBER ,
3452: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3453: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3454: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3455: x_return_status OUT NOCOPY VARCHAR2 ,
3456: x_msg_count OUT NOCOPY NUMBER ,
3457: x_msg_data OUT NOCOPY VARCHAR2 ,
3458:

Line 3499: IF NOT FND_API.Compatible_API_Call( l_api_version ,

3495: /*-----------------------------------------------+
3496: | Standard call to check for call compatibility |
3497: +-----------------------------------------------*/
3498:
3499: IF NOT FND_API.Compatible_API_Call( l_api_version ,
3500: p_api_version ,
3501: l_api_name ,
3502: G_PKG_NAME )
3503: THEN

Line 3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3500: p_api_version ,
3501: l_api_name ,
3502: G_PKG_NAME )
3503: THEN
3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3505: END IF;
3506:
3507:
3508: /*--------------------------------------------------------------+

Line 3512: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3508: /*--------------------------------------------------------------+
3509: | Initialize message list if p_init_msg_list is set to TRUE |
3510: +--------------------------------------------------------------*/
3511:
3512: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3513: FND_MSG_PUB.initialize;
3514: END IF;
3515:
3516:

Line 3521: x_return_status := FND_API.G_RET_STS_SUCCESS;

3517: /*-----------------------------------------------+
3518: | Initialize return status to SUCCESS |
3519: +-----------------------------------------------*/
3520:
3521: x_return_status := FND_API.G_RET_STS_SUCCESS;
3522:
3523:
3524: /*-----------------------------------------------------------------------+
3525: | ============ START OF API BODY - PROTEST BR =================== |

Line 3629: IF FND_API.To_Boolean( p_commit )

3625: /*-----------------------------------------------+
3626: | Standard check of p_commit |
3627: +-----------------------------------------------*/
3628:
3629: IF FND_API.To_Boolean( p_commit )
3630: THEN
3631: IF PG_DEBUG in ('Y', 'C') THEN
3632: arp_util.debug( 'committing');
3633: END IF;

Line 3643: WHEN FND_API.G_EXC_ERROR THEN

3639: END IF;
3640:
3641:
3642: EXCEPTION
3643: WHEN FND_API.G_EXC_ERROR THEN
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3646: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3647: END IF;

Line 3649: x_return_status := FND_API.G_RET_STS_ERROR ;

3645: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3646: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3647: END IF;
3648: ROLLBACK TO Protest_BR_PVT;
3649: x_return_status := FND_API.G_RET_STS_ERROR ;
3650: IF PG_DEBUG in ('Y', 'C') THEN
3651: arp_util.debug( 'Exception Error');
3652: END IF;
3653: RAISE;

Line 3655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3651: arp_util.debug( 'Exception Error');
3652: END IF;
3653: RAISE;
3654:
3655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3656: IF PG_DEBUG in ('Y', 'C') THEN
3657: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3658: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3659: END IF;

Line 3661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3657: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3658: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3659: END IF;
3660: ROLLBACK TO Protest_BR_PVT;
3661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3662: IF PG_DEBUG in ('Y', 'C') THEN
3663: arp_util.debug( 'Exception Unexpected Error');
3664: END IF;
3665: RAISE;

Line 3683: x_return_status := FND_API.G_RET_STS_ERROR ;

3679:
3680: IF (SQLCODE = -20001)
3681: THEN
3682: ROLLBACK TO Protest_BR_PVT;
3683: x_return_status := FND_API.G_RET_STS_ERROR ;
3684: RAISE;
3685: ELSE
3686: NULL;
3687: END IF;

Line 3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3686: NULL;
3687: END IF;
3688:
3689: ROLLBACK TO Protest_BR_PVT;
3690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3691:
3692: RAISE;
3693:
3694: END Protest_BR;

Line 3712: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

3708:
3709: -- ***** Standard API parameters *****
3710:
3711: p_api_version IN NUMBER ,
3712: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3713: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3714: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3715: x_return_status OUT NOCOPY VARCHAR2 ,
3716: x_msg_count OUT NOCOPY NUMBER ,

Line 3713: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

3709: -- ***** Standard API parameters *****
3710:
3711: p_api_version IN NUMBER ,
3712: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3713: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3714: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3715: x_return_status OUT NOCOPY VARCHAR2 ,
3716: x_msg_count OUT NOCOPY NUMBER ,
3717: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 3714: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

3710:
3711: p_api_version IN NUMBER ,
3712: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3713: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3714: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3715: x_return_status OUT NOCOPY VARCHAR2 ,
3716: x_msg_count OUT NOCOPY NUMBER ,
3717: x_msg_data OUT NOCOPY VARCHAR2 ,
3718:

Line 3762: IF NOT FND_API.Compatible_API_Call( l_api_version ,

3758: /*-----------------------------------------------+
3759: | Standard call to check for call compatibility |
3760: +-----------------------------------------------*/
3761:
3762: IF NOT FND_API.Compatible_API_Call( l_api_version ,
3763: p_api_version ,
3764: l_api_name ,
3765: G_PKG_NAME )
3766: THEN

Line 3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3763: p_api_version ,
3764: l_api_name ,
3765: G_PKG_NAME )
3766: THEN
3767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3768: END IF;
3769:
3770:
3771: /*--------------------------------------------------------------+

Line 3775: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3771: /*--------------------------------------------------------------+
3772: | Initialize message list if p_init_msg_list is set to TRUE |
3773: +--------------------------------------------------------------*/
3774:
3775: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3776: FND_MSG_PUB.initialize;
3777: END IF;
3778:
3779:

Line 3784: x_return_status := FND_API.G_RET_STS_SUCCESS;

3780: /*-----------------------------------------------+
3781: | Initialize return status to SUCCESS |
3782: +-----------------------------------------------*/
3783:
3784: x_return_status := FND_API.G_RET_STS_SUCCESS;
3785:
3786:
3787: /*-----------------------------------------------------------------------+
3788: | ============ START OF API BODY - RESTATE BR =================== |

Line 3905: IF FND_API.To_Boolean( p_commit )

3901: /*-----------------------------------------------+
3902: | Standard check of p_commit |
3903: +-----------------------------------------------*/
3904:
3905: IF FND_API.To_Boolean( p_commit )
3906: THEN
3907: IF PG_DEBUG in ('Y', 'C') THEN
3908: arp_util.debug( 'committing');
3909: END IF;

Line 3919: WHEN FND_API.G_EXC_ERROR THEN

3915: END IF;
3916:
3917:
3918: EXCEPTION
3919: WHEN FND_API.G_EXC_ERROR THEN
3920: IF PG_DEBUG in ('Y', 'C') THEN
3921: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3922: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3923: END IF;

Line 3925: x_return_status := FND_API.G_RET_STS_ERROR ;

3921: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3922: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3923: END IF;
3924: ROLLBACK TO Restate_BR_PVT;
3925: x_return_status := FND_API.G_RET_STS_ERROR ;
3926: IF PG_DEBUG in ('Y', 'C') THEN
3927: arp_util.debug( 'Exception Error');
3928: END IF;
3929: RAISE;

Line 3931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3927: arp_util.debug( 'Exception Error');
3928: END IF;
3929: RAISE;
3930:
3931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3932: IF PG_DEBUG in ('Y', 'C') THEN
3933: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3934: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3935: END IF;

Line 3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3933: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3934: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3935: END IF;
3936: ROLLBACK TO Restate_BR_PVT;
3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3938: IF PG_DEBUG in ('Y', 'C') THEN
3939: arp_util.debug( 'Exception Unexpected Error');
3940: END IF;
3941: RAISE;

Line 3959: x_return_status := FND_API.G_RET_STS_ERROR ;

3955:
3956: IF (SQLCODE = -20001)
3957: THEN
3958: ROLLBACK TO Restate_BR_PVT;
3959: x_return_status := FND_API.G_RET_STS_ERROR ;
3960: RAISE;
3961: ELSE
3962: NULL;
3963: END IF;

Line 3966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3962: NULL;
3963: END IF;
3964:
3965: ROLLBACK TO Restate_BR_PVT;
3966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3967: RAISE;
3968:
3969:
3970: END Restate_BR;

Line 3988: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

3984:
3985: -- ***** Standard API parameters *****
3986:
3987: p_api_version IN NUMBER ,
3988: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3989: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3990: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3991: x_return_status OUT NOCOPY VARCHAR2 ,
3992: x_msg_count OUT NOCOPY NUMBER ,

Line 3989: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

3985: -- ***** Standard API parameters *****
3986:
3987: p_api_version IN NUMBER ,
3988: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3989: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3990: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3991: x_return_status OUT NOCOPY VARCHAR2 ,
3992: x_msg_count OUT NOCOPY NUMBER ,
3993: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 3990: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

3986:
3987: p_api_version IN NUMBER ,
3988: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3989: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3990: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3991: x_return_status OUT NOCOPY VARCHAR2 ,
3992: x_msg_count OUT NOCOPY NUMBER ,
3993: x_msg_data OUT NOCOPY VARCHAR2 ,
3994:

Line 4041: IF NOT FND_API.Compatible_API_Call( l_api_version ,

4037: /*-----------------------------------------------+
4038: | Standard call to check for call compatibility |
4039: +-----------------------------------------------*/
4040:
4041: IF NOT FND_API.Compatible_API_Call( l_api_version ,
4042: p_api_version ,
4043: l_api_name ,
4044: G_PKG_NAME )
4045: THEN

Line 4046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4042: p_api_version ,
4043: l_api_name ,
4044: G_PKG_NAME )
4045: THEN
4046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4047: END IF;
4048:
4049:
4050: /*--------------------------------------------------------------+

Line 4054: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4050: /*--------------------------------------------------------------+
4051: | Initialize message list if p_init_msg_list is set to TRUE |
4052: +--------------------------------------------------------------*/
4053:
4054: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4055: FND_MSG_PUB.initialize;
4056: END IF;
4057:
4058:

Line 4063: x_return_status := FND_API.G_RET_STS_SUCCESS;

4059: /*-----------------------------------------------+
4060: | Initialize return status to SUCCESS |
4061: +-----------------------------------------------*/
4062:
4063: x_return_status := FND_API.G_RET_STS_SUCCESS;
4064:
4065:
4066: /*-----------------------------------------------------------------------+
4067: | ============ START OF API BODY - RECALL BR =================== |

Line 4229: IF FND_API.To_Boolean( p_commit )

4225: /*-----------------------------------------------+
4226: | Standard check of p_commit |
4227: +-----------------------------------------------*/
4228:
4229: IF FND_API.To_Boolean( p_commit )
4230: THEN
4231: IF PG_DEBUG in ('Y', 'C') THEN
4232: arp_util.debug( 'committing');
4233: END IF;

Line 4243: WHEN FND_API.G_EXC_ERROR THEN

4239: END IF;
4240:
4241:
4242: EXCEPTION
4243: WHEN FND_API.G_EXC_ERROR THEN
4244: IF PG_DEBUG in ('Y', 'C') THEN
4245: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4246: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4247: END IF;

Line 4249: x_return_status := FND_API.G_RET_STS_ERROR ;

4245: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4246: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4247: END IF;
4248: ROLLBACK TO Recall_BR_PVT;
4249: x_return_status := FND_API.G_RET_STS_ERROR ;
4250: IF PG_DEBUG in ('Y', 'C') THEN
4251: arp_util.debug( 'Exception Error');
4252: END IF;
4253: RAISE;

Line 4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4251: arp_util.debug( 'Exception Error');
4252: END IF;
4253: RAISE;
4254:
4255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: IF PG_DEBUG in ('Y', 'C') THEN
4257: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4258: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4259: END IF;

Line 4261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4257: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4258: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4259: END IF;
4260: ROLLBACK TO Recall_BR_PVT;
4261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4262: IF PG_DEBUG in ('Y', 'C') THEN
4263: arp_util.debug( 'Exception Unexpected Error');
4264: END IF;
4265: RAISE;

Line 4283: x_return_status := FND_API.G_RET_STS_ERROR ;

4279:
4280: IF (SQLCODE = -20001)
4281: THEN
4282: ROLLBACK TO Recall_BR_PVT;
4283: x_return_status := FND_API.G_RET_STS_ERROR ;
4284: RAISE;
4285: ELSE
4286: NULL;
4287: END IF;

Line 4290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4286: NULL;
4287: END IF;
4288:
4289: ROLLBACK TO Recall_BR_PVT;
4290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4291: RAISE;
4292:
4293:
4294: END Recall_BR;

Line 4312: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

4308:
4309: -- ***** Standard API parameters *****
4310:
4311: p_api_version IN NUMBER ,
4312: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4313: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4315: x_return_status OUT NOCOPY VARCHAR2 ,
4316: x_msg_count OUT NOCOPY NUMBER ,

Line 4313: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

4309: -- ***** Standard API parameters *****
4310:
4311: p_api_version IN NUMBER ,
4312: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4313: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4315: x_return_status OUT NOCOPY VARCHAR2 ,
4316: x_msg_count OUT NOCOPY NUMBER ,
4317: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 4314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

4310:
4311: p_api_version IN NUMBER ,
4312: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4313: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4315: x_return_status OUT NOCOPY VARCHAR2 ,
4316: x_msg_count OUT NOCOPY NUMBER ,
4317: x_msg_data OUT NOCOPY VARCHAR2 ,
4318:

Line 4368: IF NOT FND_API.Compatible_API_Call( l_api_version ,

4364: /*-----------------------------------------------+
4365: | Standard call to check for call compatibility |
4366: +-----------------------------------------------*/
4367:
4368: IF NOT FND_API.Compatible_API_Call( l_api_version ,
4369: p_api_version ,
4370: l_api_name ,
4371: G_PKG_NAME )
4372: THEN

Line 4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4369: p_api_version ,
4370: l_api_name ,
4371: G_PKG_NAME )
4372: THEN
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END IF;
4375:
4376:
4377: /*--------------------------------------------------------------+

Line 4381: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4377: /*--------------------------------------------------------------+
4378: | Initialize message list if p_init_msg_list is set to TRUE |
4379: +--------------------------------------------------------------*/
4380:
4381: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4382: FND_MSG_PUB.initialize;
4383: END IF;
4384:
4385:

Line 4390: x_return_status := FND_API.G_RET_STS_SUCCESS;

4386: /*-----------------------------------------------+
4387: | Initialize return status to SUCCESS |
4388: +-----------------------------------------------*/
4389:
4390: x_return_status := FND_API.G_RET_STS_SUCCESS;
4391:
4392:
4393: /*-----------------------------------------------------------------------+
4394: | ============ START OF API BODY - ELIMINATE RISK BR ============ |

Line 4565: IF FND_API.To_Boolean( p_commit )

4561: /*-----------------------------------------------+
4562: | Standard check of p_commit |
4563: +-----------------------------------------------*/
4564:
4565: IF FND_API.To_Boolean( p_commit )
4566: THEN
4567: IF PG_DEBUG in ('Y', 'C') THEN
4568: arp_util.debug( 'committing');
4569: END IF;

Line 4579: WHEN FND_API.G_EXC_ERROR THEN

4575: END IF;
4576:
4577:
4578: EXCEPTION
4579: WHEN FND_API.G_EXC_ERROR THEN
4580: IF PG_DEBUG in ('Y', 'C') THEN
4581: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4582: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4583: END IF;

Line 4585: x_return_status := FND_API.G_RET_STS_ERROR ;

4581: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4582: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4583: END IF;
4584: ROLLBACK TO Eliminate_Risk_BR_PVT;
4585: x_return_status := FND_API.G_RET_STS_ERROR ;
4586: IF PG_DEBUG in ('Y', 'C') THEN
4587: arp_util.debug( 'Exception Error');
4588: END IF;
4589: RAISE;

Line 4591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4587: arp_util.debug( 'Exception Error');
4588: END IF;
4589: RAISE;
4590:
4591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4592: IF PG_DEBUG in ('Y', 'C') THEN
4593: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4594: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4595: END IF;

Line 4597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4593: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4594: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4595: END IF;
4596: ROLLBACK TO Eliminate_Risk_BR_PVT;
4597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4598: IF PG_DEBUG in ('Y', 'C') THEN
4599: arp_util.debug( 'Exception Unexpected Error');
4600: END IF;
4601: RAISE;

Line 4619: x_return_status := FND_API.G_RET_STS_ERROR ;

4615:
4616: IF (SQLCODE = -20001)
4617: THEN
4618: ROLLBACK TO Eliminate_Risk_BR_PVT;
4619: x_return_status := FND_API.G_RET_STS_ERROR ;
4620: RAISE;
4621: ELSE
4622: NULL;
4623: END IF;

Line 4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4622: NULL;
4623: END IF;
4624:
4625: ROLLBACK TO Eliminate_Risk_BR_PVT;
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4627:
4628: RAISE;
4629:
4630: END Eliminate_Risk_BR;

Line 4648: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

4644:
4645: -- ***** Standard API parameters *****
4646:
4647: p_api_version IN NUMBER ,
4648: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4649: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4651: x_return_status OUT NOCOPY VARCHAR2 ,
4652: x_msg_count OUT NOCOPY NUMBER ,

Line 4649: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

4645: -- ***** Standard API parameters *****
4646:
4647: p_api_version IN NUMBER ,
4648: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4649: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4651: x_return_status OUT NOCOPY VARCHAR2 ,
4652: x_msg_count OUT NOCOPY NUMBER ,
4653: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

4646:
4647: p_api_version IN NUMBER ,
4648: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4649: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4650: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4651: x_return_status OUT NOCOPY VARCHAR2 ,
4652: x_msg_count OUT NOCOPY NUMBER ,
4653: x_msg_data OUT NOCOPY VARCHAR2 ,
4654:

Line 4708: IF NOT FND_API.Compatible_API_Call( l_api_version ,

4704: /*-----------------------------------------------+
4705: | Standard call to check for call compatibility |
4706: +-----------------------------------------------*/
4707:
4708: IF NOT FND_API.Compatible_API_Call( l_api_version ,
4709: p_api_version ,
4710: l_api_name ,
4711: G_PKG_NAME )
4712: THEN

Line 4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4709: p_api_version ,
4710: l_api_name ,
4711: G_PKG_NAME )
4712: THEN
4713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4714: END IF;
4715:
4716:
4717: /*--------------------------------------------------------------+

Line 4721: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4717: /*--------------------------------------------------------------+
4718: | Initialize message list if p_init_msg_list is set to TRUE |
4719: +--------------------------------------------------------------*/
4720:
4721: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4722: FND_MSG_PUB.initialize;
4723: END IF;
4724:
4725:

Line 4730: x_return_status := FND_API.G_RET_STS_SUCCESS;

4726: /*-----------------------------------------------+
4727: | Initialize return status to SUCCESS |
4728: +-----------------------------------------------*/
4729:
4730: x_return_status := FND_API.G_RET_STS_SUCCESS;
4731:
4732:
4733: /*-----------------------------------------------------------------------+
4734: | ============ START OF API BODY - UNELIMINATE RISK BR =============|

Line 4932: IF FND_API.To_Boolean( p_commit )

4928: /*-----------------------------------------------+
4929: | Standard check of p_commit |
4930: +-----------------------------------------------*/
4931:
4932: IF FND_API.To_Boolean( p_commit )
4933: THEN
4934:
4935: IF PG_DEBUG in ('Y', 'C') THEN
4936: arp_util.debug( 'committing');

Line 4947: WHEN FND_API.G_EXC_ERROR THEN

4943: END IF;
4944:
4945:
4946: EXCEPTION
4947: WHEN FND_API.G_EXC_ERROR THEN
4948: IF PG_DEBUG in ('Y', 'C') THEN
4949: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4950: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4951: END IF;

Line 4953: x_return_status := FND_API.G_RET_STS_ERROR ;

4949: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4950: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4951: END IF;
4952: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4953: x_return_status := FND_API.G_RET_STS_ERROR ;
4954: IF PG_DEBUG in ('Y', 'C') THEN
4955: arp_util.debug( 'Exception Error');
4956: END IF;
4957: RAISE;

Line 4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4955: arp_util.debug( 'Exception Error');
4956: END IF;
4957: RAISE;
4958:
4959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4960: IF PG_DEBUG in ('Y', 'C') THEN
4961: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4962: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4963: END IF;

Line 4965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4961: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4962: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4963: END IF;
4964: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4966: IF PG_DEBUG in ('Y', 'C') THEN
4967: arp_util.debug( 'Exception Unexpected Error');
4968: END IF;
4969: RAISE;

Line 4987: x_return_status := FND_API.G_RET_STS_ERROR ;

4983:
4984: IF (SQLCODE = -20001)
4985: THEN
4986: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4987: x_return_status := FND_API.G_RET_STS_ERROR ;
4988: RAISE;
4989: ELSE
4990: NULL;
4991: END IF;

Line 4994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4990: NULL;
4991: END IF;
4992:
4993: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4995: RAISE;
4996:
4997:
4998: END UnEliminate_Risk_BR;

Line 5016: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

5012:
5013: -- ***** Standard API parameters *****
5014:
5015: p_api_version IN NUMBER ,
5016: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
5017: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5019: x_return_status OUT NOCOPY VARCHAR2 ,
5020: x_msg_count OUT NOCOPY NUMBER ,

Line 5017: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

5013: -- ***** Standard API parameters *****
5014:
5015: p_api_version IN NUMBER ,
5016: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
5017: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5019: x_return_status OUT NOCOPY VARCHAR2 ,
5020: x_msg_count OUT NOCOPY NUMBER ,
5021: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 5018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

5014:
5015: p_api_version IN NUMBER ,
5016: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
5017: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5018: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5019: x_return_status OUT NOCOPY VARCHAR2 ,
5020: x_msg_count OUT NOCOPY NUMBER ,
5021: x_msg_data OUT NOCOPY VARCHAR2 ,
5022:

Line 5072: IF NOT FND_API.Compatible_API_Call( l_api_version ,

5068: /*-----------------------------------------------+
5069: | Standard call to check for call compatibility |
5070: +-----------------------------------------------*/
5071:
5072: IF NOT FND_API.Compatible_API_Call( l_api_version ,
5073: p_api_version ,
5074: l_api_name ,
5075: G_PKG_NAME )
5076: THEN

Line 5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5073: p_api_version ,
5074: l_api_name ,
5075: G_PKG_NAME )
5076: THEN
5077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5078: END IF;
5079:
5080:
5081: /*--------------------------------------------------------------+

Line 5085: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5081: /*--------------------------------------------------------------+
5082: | Initialize message list if p_init_msg_list is set to TRUE |
5083: +--------------------------------------------------------------*/
5084:
5085: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5086: FND_MSG_PUB.initialize;
5087: END IF;
5088:
5089:

Line 5094: x_return_status := FND_API.G_RET_STS_SUCCESS;

5090: /*-----------------------------------------------+
5091: | Initialize return status to SUCCESS |
5092: +-----------------------------------------------*/
5093:
5094: x_return_status := FND_API.G_RET_STS_SUCCESS;
5095:
5096:
5097: /*-----------------------------------------------------------------------+
5098: | ============ START OF API BODY - EXCHANGE BR =================== |

Line 5170: p_init_msg_list => FND_API.G_TRUE ,

5166: AR_BILLS_CREATION_PUB.create_br_header (
5167:
5168: p_api_version => 1.0 ,
5169: x_return_status => l_return_status ,
5170: p_init_msg_list => FND_API.G_TRUE ,
5171: x_msg_count => l_msg_count ,
5172: x_msg_data => l_msg_data ,
5173:
5174: p_trx_number => NULL ,

Line 5235: p_init_msg_list => FND_API.G_TRUE ,

5231:
5232: AR_BILLS_CREATION_PUB.create_br_assignment (
5233:
5234: p_api_version => 1.0 ,
5235: p_init_msg_list => FND_API.G_TRUE ,
5236: p_commit => FND_API.G_FALSE ,
5237: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
5238: x_return_status => l_return_status ,
5239: x_msg_count => l_msg_count ,

Line 5236: p_commit => FND_API.G_FALSE ,

5232: AR_BILLS_CREATION_PUB.create_br_assignment (
5233:
5234: p_api_version => 1.0 ,
5235: p_init_msg_list => FND_API.G_TRUE ,
5236: p_commit => FND_API.G_FALSE ,
5237: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
5238: x_return_status => l_return_status ,
5239: x_msg_count => l_msg_count ,
5240: x_msg_data => l_msg_data ,

Line 5237: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

5233:
5234: p_api_version => 1.0 ,
5235: p_init_msg_list => FND_API.G_TRUE ,
5236: p_commit => FND_API.G_FALSE ,
5237: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
5238: x_return_status => l_return_status ,
5239: x_msg_count => l_msg_count ,
5240: x_msg_data => l_msg_data ,
5241:

Line 5292: IF FND_API.To_Boolean( p_commit )

5288: /*-----------------------------------------------+
5289: | Standard check of p_commit |
5290: +-----------------------------------------------*/
5291:
5292: IF FND_API.To_Boolean( p_commit )
5293: THEN
5294: IF PG_DEBUG in ('Y', 'C') THEN
5295: arp_util.debug( 'committing');
5296: END IF;

Line 5308: x_return_status := FND_API.G_RET_STS_ERROR ;

5304:
5305: EXCEPTION
5306: WHEN API_exception THEN
5307: ROLLBACK TO Exchange_BR_PVT;
5308: x_return_status := FND_API.G_RET_STS_ERROR ;
5309: IF PG_DEBUG in ('Y', 'C') THEN
5310: arp_util.debug ('API Exception : AR_BILLS_MAINTAIN_PUB.Exchange_BR : ' || SQLERRM);
5311: END IF;
5312: RAISE;

Line 5314: WHEN FND_API.G_EXC_ERROR THEN

5310: arp_util.debug ('API Exception : AR_BILLS_MAINTAIN_PUB.Exchange_BR : ' || SQLERRM);
5311: END IF;
5312: RAISE;
5313:
5314: WHEN FND_API.G_EXC_ERROR THEN
5315: IF PG_DEBUG in ('Y', 'C') THEN
5316: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5317: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5318: END IF;

Line 5320: x_return_status := FND_API.G_RET_STS_ERROR ;

5316: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5317: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5318: END IF;
5319: ROLLBACK TO Exchange_BR_PVT;
5320: x_return_status := FND_API.G_RET_STS_ERROR ;
5321: IF PG_DEBUG in ('Y', 'C') THEN
5322: arp_util.debug( 'Exception Error');
5323: END IF;
5324: RAISE;

Line 5327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5323: END IF;
5324: RAISE;
5325:
5326:
5327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5328: IF PG_DEBUG in ('Y', 'C') THEN
5329: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5330: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5331: END IF;

Line 5333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5329: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5330: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5331: END IF;
5332: ROLLBACK TO Exchange_BR_PVT;
5333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5334: IF PG_DEBUG in ('Y', 'C') THEN
5335: arp_util.debug( 'Exception Unexpected Error');
5336: END IF;
5337: RAISE;

Line 5355: x_return_status := FND_API.G_RET_STS_ERROR ;

5351:
5352: IF (SQLCODE = -20001)
5353: THEN
5354: ROLLBACK TO Exchange_BR_PVT;
5355: x_return_status := FND_API.G_RET_STS_ERROR ;
5356: RAISE;
5357: ELSE
5358: NULL;
5359: END IF;

Line 5362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5358: NULL;
5359: END IF;
5360:
5361: ROLLBACK TO Exchange_BR_PVT;
5362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5363: RAISE;
5364:
5365: END Exchange_BR;
5366: