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 304: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected

300: p_payment_channel => 'BILLS_RECEIVABLE',
301: p_instrument_assign_id => l_instr_id,
302: p_payment_trxn_extn_id => l_payment_trxn_extension_id);
303:
304: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected
305: IF x_return_status <> 'S'
306: THEN
307: FND_MESSAGE.set_name( 'AR' , 'AR_BR_CANNOT_COMPLETE' );
308: FND_MESSAGE.set_token( 'BRNUM' , l_trx_rec.trx_number);

Line 463: IF FND_API.To_Boolean( p_commit )

459: /*-----------------------------------------------+
460: | Standard check of p_commit |
461: +-----------------------------------------------*/
462:
463: IF FND_API.To_Boolean( p_commit )
464: THEN
465: IF PG_DEBUG in ('Y', 'C') THEN
466: arp_util.debug( 'committing');
467: END IF;

Line 477: WHEN FND_API.G_EXC_ERROR THEN

473: END IF;
474:
475:
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: IF PG_DEBUG in ('Y', 'C') THEN
479: arp_util.debug( 'SQLCODE : ' || SQLCODE);
480: arp_util.debug( 'SQLERRM : ' || SQLERRM);
481: END IF;

Line 483: x_return_status := FND_API.G_RET_STS_ERROR ;

479: arp_util.debug( 'SQLCODE : ' || SQLCODE);
480: arp_util.debug( 'SQLERRM : ' || SQLERRM);
481: END IF;
482: ROLLBACK TO Complete_BR_PVT;
483: x_return_status := FND_API.G_RET_STS_ERROR ;
484: IF PG_DEBUG in ('Y', 'C') THEN
485: arp_util.debug( 'Exception Error');
486: END IF;
487: raise;

Line 490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

486: END IF;
487: raise;
488:
489:
490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
491: IF PG_DEBUG in ('Y', 'C') THEN
492: arp_util.debug( 'SQLCODE : ' || SQLCODE);
493: arp_util.debug( 'SQLERRM : ' || SQLERRM);
494: END IF;

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

492: arp_util.debug( 'SQLCODE : ' || SQLCODE);
493: arp_util.debug( 'SQLERRM : ' || SQLERRM);
494: END IF;
495: ROLLBACK TO Complete_BR_PVT;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: IF PG_DEBUG in ('Y', 'C') THEN
498: arp_util.debug( 'Exception Unexpected Error');
499: END IF;
500: RAISE;

Line 521: x_return_status := FND_API.G_RET_STS_ERROR ;

517: IF PG_DEBUG in ('Y', 'C') THEN
518: arp_util.debug( 'Exception Others -20001');
519: END IF;
520: ROLLBACK TO Complete_BR_PVT;
521: x_return_status := FND_API.G_RET_STS_ERROR ;
522: RAISE;
523:
524: ELSE
525: IF PG_DEBUG in ('Y', 'C') THEN

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

528: NULL;
529: END IF;
530:
531: ROLLBACK TO Complete_BR_PVT;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: RAISE;
534:
535: END Complete_BR;
536:

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

549:
550: -- ***** Standard API parameters *****
551:
552: p_api_version IN NUMBER ,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
556: x_return_status OUT NOCOPY VARCHAR2 ,
557: x_msg_count OUT NOCOPY NUMBER ,

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

550: -- ***** Standard API parameters *****
551:
552: p_api_version IN NUMBER ,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
556: x_return_status OUT NOCOPY VARCHAR2 ,
557: x_msg_count OUT NOCOPY NUMBER ,
558: x_msg_data OUT NOCOPY VARCHAR2 ,

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

551:
552: p_api_version IN NUMBER ,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
556: x_return_status OUT NOCOPY VARCHAR2 ,
557: x_msg_count OUT NOCOPY NUMBER ,
558: x_msg_data OUT NOCOPY VARCHAR2 ,
559:

Line 598: IF NOT FND_API.Compatible_API_Call( l_api_version ,

594: /*-----------------------------------------------+
595: | Standard call to check for call compatibility |
596: +-----------------------------------------------*/
597:
598: IF NOT FND_API.Compatible_API_Call( l_api_version ,
599: p_api_version ,
600: l_api_name ,
601: G_PKG_NAME )
602: THEN

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

599: p_api_version ,
600: l_api_name ,
601: G_PKG_NAME )
602: THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606:
607: /*--------------------------------------------------------------+

Line 611: IF FND_API.to_Boolean( p_init_msg_list ) THEN

607: /*--------------------------------------------------------------+
608: | Initialize message list if p_init_msg_list is set to TRUE |
609: +--------------------------------------------------------------*/
610:
611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
612: FND_MSG_PUB.initialize;
613: END IF;
614:
615:

Line 620: x_return_status := FND_API.G_RET_STS_SUCCESS;

616: /*-----------------------------------------------+
617: | Initialize return status to SUCCESS |
618: +-----------------------------------------------*/
619:
620: x_return_status := FND_API.G_RET_STS_SUCCESS;
621:
622:
623: /*-----------------------------------------------------------------------+
624: | ============ START OF API BODY - UNCOMPLETE BR ================= |

Line 762: IF FND_API.To_Boolean( p_commit )

758: /*-----------------------------------------------+
759: | Standard check of p_commit |
760: +-----------------------------------------------*/
761:
762: IF FND_API.To_Boolean( p_commit )
763: THEN
764: IF PG_DEBUG in ('Y', 'C') THEN
765: arp_util.debug( 'committing');
766: END IF;

Line 776: WHEN FND_API.G_EXC_ERROR THEN

772: END IF;
773:
774:
775: EXCEPTION
776: WHEN FND_API.G_EXC_ERROR THEN
777: IF PG_DEBUG in ('Y', 'C') THEN
778: arp_util.debug( 'SQLCODE : ' || SQLCODE);
779: arp_util.debug( 'SQLERRM : ' || SQLERRM);
780: END IF;

Line 782: x_return_status := FND_API.G_RET_STS_ERROR ;

778: arp_util.debug( 'SQLCODE : ' || SQLCODE);
779: arp_util.debug( 'SQLERRM : ' || SQLERRM);
780: END IF;
781: ROLLBACK TO UnComplete_BR_PVT;
782: x_return_status := FND_API.G_RET_STS_ERROR ;
783: IF PG_DEBUG in ('Y', 'C') THEN
784: arp_util.debug( 'Exception Error');
785: END IF;
786: raise;

Line 789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

785: END IF;
786: raise;
787:
788:
789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
790: IF PG_DEBUG in ('Y', 'C') THEN
791: arp_util.debug( 'SQLCODE : ' || SQLCODE);
792: arp_util.debug( 'SQLERRM : ' || SQLERRM);
793: END IF;

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 820: x_return_status := FND_API.G_RET_STS_ERROR ;

816: IF PG_DEBUG in ('Y', 'C') THEN
817: arp_util.debug( 'Exception Others -20001');
818: END IF;
819: ROLLBACK TO UnComplete_BR_PVT;
820: x_return_status := FND_API.G_RET_STS_ERROR ;
821: RAISE;
822: ELSE
823: IF PG_DEBUG in ('Y', 'C') THEN
824: arp_util.debug( 'Exception Others');

Line 830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

826: NULL;
827: END IF;
828:
829: ROLLBACK TO UnComplete_BR_PVT;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
831: RAISE;
832:
833: END UnComplete_BR;
834:

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

848:
849: -- ***** Standard API parameters *****
850:
851: p_api_version IN NUMBER ,
852: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
853: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
855: x_return_status OUT NOCOPY VARCHAR2 ,
856: x_msg_count OUT NOCOPY NUMBER ,

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

849: -- ***** Standard API parameters *****
850:
851: p_api_version IN NUMBER ,
852: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
853: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
855: x_return_status OUT NOCOPY VARCHAR2 ,
856: x_msg_count OUT NOCOPY NUMBER ,
857: x_msg_data OUT NOCOPY VARCHAR2 ,

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

850:
851: p_api_version IN NUMBER ,
852: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
853: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
854: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
855: x_return_status OUT NOCOPY VARCHAR2 ,
856: x_msg_count OUT NOCOPY NUMBER ,
857: x_msg_data OUT NOCOPY VARCHAR2 ,
858:

Line 903: IF NOT FND_API.Compatible_API_Call( l_api_version ,

899: /*-----------------------------------------------+
900: | Standard call to check for call compatibility |
901: +-----------------------------------------------*/
902:
903: IF NOT FND_API.Compatible_API_Call( l_api_version ,
904: p_api_version ,
905: l_api_name ,
906: G_PKG_NAME )
907: THEN

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: p_api_version ,
905: l_api_name ,
906: G_PKG_NAME )
907: THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910:
911:
912: /*--------------------------------------------------------------+

Line 916: IF FND_API.to_Boolean( p_init_msg_list ) THEN

912: /*--------------------------------------------------------------+
913: | Initialize message list if p_init_msg_list is set to TRUE |
914: +--------------------------------------------------------------*/
915:
916: IF FND_API.to_Boolean( p_init_msg_list ) THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919:
920:

Line 925: x_return_status := FND_API.G_RET_STS_SUCCESS;

921: /*-----------------------------------------------+
922: | Initialize return status to SUCCESS |
923: +-----------------------------------------------*/
924:
925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926:
927:
928: /*-----------------------------------------------------------------------+
929: | ============ START OF API BODY - ACCEPT BR =================== |

Line 1052: IF FND_API.To_Boolean( p_commit )

1048: /*-----------------------------------------------+
1049: | Standard check of p_commit |
1050: +-----------------------------------------------*/
1051:
1052: IF FND_API.To_Boolean( p_commit )
1053: THEN
1054: IF PG_DEBUG in ('Y', 'C') THEN
1055: arp_util.debug( 'committing');
1056: END IF;

Line 1066: WHEN FND_API.G_EXC_ERROR THEN

1062: END IF;
1063:
1064:
1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: IF PG_DEBUG in ('Y', 'C') THEN
1068: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1069: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1070: END IF;

Line 1072: x_return_status := FND_API.G_RET_STS_ERROR ;

1068: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1069: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1070: END IF;
1071: ROLLBACK TO Accept_BR_PVT;
1072: x_return_status := FND_API.G_RET_STS_ERROR ;
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_util.debug( 'Exception Error');
1075: END IF;
1076: RAISE;

Line 1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1075: END IF;
1076: RAISE;
1077:
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: IF PG_DEBUG in ('Y', 'C') THEN
1081: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1082: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1083: END IF;

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1107: x_return_status := FND_API.G_RET_STS_ERROR ;

1103:
1104: IF (SQLCODE = -20001)
1105: THEN
1106: ROLLBACK TO Accept_BR_PVT;
1107: x_return_status := FND_API.G_RET_STS_ERROR ;
1108: RAISE;
1109: ELSE
1110: NULL;
1111: END IF;

Line 1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1110: NULL;
1111: END IF;
1112:
1113: ROLLBACK TO Accept_BR_PVT;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1115: RAISE;
1116:
1117:
1118: END Accept_BR;

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

1132:
1133: -- ***** Standard API parameters *****
1134:
1135: p_api_version IN NUMBER ,
1136: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1139: x_return_status OUT NOCOPY VARCHAR2 ,
1140: x_msg_count OUT NOCOPY NUMBER ,

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

1133: -- ***** Standard API parameters *****
1134:
1135: p_api_version IN NUMBER ,
1136: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1139: x_return_status OUT NOCOPY VARCHAR2 ,
1140: x_msg_count OUT NOCOPY NUMBER ,
1141: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1134:
1135: p_api_version IN NUMBER ,
1136: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1137: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1139: x_return_status OUT NOCOPY VARCHAR2 ,
1140: x_msg_count OUT NOCOPY NUMBER ,
1141: x_msg_data OUT NOCOPY VARCHAR2 ,
1142:

Line 1180: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1176: /*-----------------------------------------------+
1177: | Standard call to check for call compatibility |
1178: +-----------------------------------------------*/
1179:
1180: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1181: p_api_version ,
1182: l_api_name ,
1183: G_PKG_NAME )
1184: THEN

Line 1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1181: p_api_version ,
1182: l_api_name ,
1183: G_PKG_NAME )
1184: THEN
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1186: END IF;
1187:
1188:
1189: /*--------------------------------------------------------------+

Line 1193: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1189: /*--------------------------------------------------------------+
1190: | Initialize message list if p_init_msg_list is set to TRUE |
1191: +--------------------------------------------------------------*/
1192:
1193: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1194: FND_MSG_PUB.initialize;
1195: END IF;
1196:
1197:

Line 1202: x_return_status := FND_API.G_RET_STS_SUCCESS;

1198: /*-----------------------------------------------+
1199: | Initialize return status to SUCCESS |
1200: +-----------------------------------------------*/
1201:
1202: x_return_status := FND_API.G_RET_STS_SUCCESS;
1203:
1204:
1205: /*-----------------------------------------------------------------------+
1206: | ============ START OF API BODY - HOLD BR =================== |

Line 1326: IF FND_API.To_Boolean( p_commit )

1322: /*-----------------------------------------------+
1323: | Standard check of p_commit |
1324: +-----------------------------------------------*/
1325:
1326: IF FND_API.To_Boolean( p_commit )
1327: THEN
1328: IF PG_DEBUG in ('Y', 'C') THEN
1329: arp_util.debug( 'committing');
1330: END IF;

Line 1340: WHEN FND_API.G_EXC_ERROR THEN

1336: END IF;
1337:
1338:
1339: EXCEPTION
1340: WHEN FND_API.G_EXC_ERROR THEN
1341: IF PG_DEBUG in ('Y', 'C') THEN
1342: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1343: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1344: END IF;

Line 1346: x_return_status := FND_API.G_RET_STS_ERROR ;

1342: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1343: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1344: END IF;
1345: ROLLBACK TO Hold_BR_PVT;
1346: x_return_status := FND_API.G_RET_STS_ERROR ;
1347: IF PG_DEBUG in ('Y', 'C') THEN
1348: arp_util.debug( 'Exception Error');
1349: END IF;
1350: RAISE;

Line 1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1348: arp_util.debug( 'Exception Error');
1349: END IF;
1350: RAISE;
1351:
1352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1353: IF PG_DEBUG in ('Y', 'C') THEN
1354: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1355: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1356: END IF;

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1379: x_return_status := FND_API.G_RET_STS_ERROR ;

1375:
1376: IF (SQLCODE = -20001)
1377: THEN
1378: ROLLBACK TO Hold_BR_PVT;
1379: x_return_status := FND_API.G_RET_STS_ERROR ;
1380: RAISE;
1381: ELSE
1382: NULL;
1383: END IF;

Line 1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1382: NULL;
1383: END IF;
1384:
1385: ROLLBACK TO Hold_BR_PVT;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1387: RAISE;
1388:
1389: END Hold_BR;
1390:

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

1403:
1404: -- ***** Standard API parameters *****
1405:
1406: p_api_version IN NUMBER ,
1407: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1410: x_return_status OUT NOCOPY VARCHAR2 ,
1411: x_msg_count OUT NOCOPY NUMBER ,

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

1404: -- ***** Standard API parameters *****
1405:
1406: p_api_version IN NUMBER ,
1407: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1410: x_return_status OUT NOCOPY VARCHAR2 ,
1411: x_msg_count OUT NOCOPY NUMBER ,
1412: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1405:
1406: p_api_version IN NUMBER ,
1407: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1408: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1409: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1410: x_return_status OUT NOCOPY VARCHAR2 ,
1411: x_msg_count OUT NOCOPY NUMBER ,
1412: x_msg_data OUT NOCOPY VARCHAR2 ,
1413:

Line 1451: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1447: /*-----------------------------------------------+
1448: | Standard call to check for call compatibility |
1449: +-----------------------------------------------*/
1450:
1451: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1452: p_api_version ,
1453: l_api_name ,
1454: G_PKG_NAME )
1455: THEN

Line 1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1452: p_api_version ,
1453: l_api_name ,
1454: G_PKG_NAME )
1455: THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458:
1459:
1460: /*--------------------------------------------------------------+

Line 1464: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1460: /*--------------------------------------------------------------+
1461: | Initialize message list if p_init_msg_list is set to TRUE |
1462: +--------------------------------------------------------------*/
1463:
1464: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1465: FND_MSG_PUB.initialize;
1466: END IF;
1467:
1468:

Line 1473: x_return_status := FND_API.G_RET_STS_SUCCESS;

1469: /*-----------------------------------------------+
1470: | Initialize return status to SUCCESS |
1471: +-----------------------------------------------*/
1472:
1473: x_return_status := FND_API.G_RET_STS_SUCCESS;
1474:
1475:
1476: /*-----------------------------------------------------------------------+
1477: | ============ START OF API BODY - UNHOLD BR =================== |

Line 1592: IF FND_API.To_Boolean( p_commit )

1588: /*-----------------------------------------------+
1589: | Standard check of p_commit |
1590: +-----------------------------------------------*/
1591:
1592: IF FND_API.To_Boolean( p_commit )
1593: THEN
1594: IF PG_DEBUG in ('Y', 'C') THEN
1595: arp_util.debug( 'committing');
1596: END IF;

Line 1606: WHEN FND_API.G_EXC_ERROR THEN

1602: END IF;
1603:
1604:
1605: EXCEPTION
1606: WHEN FND_API.G_EXC_ERROR THEN
1607: IF PG_DEBUG in ('Y', 'C') THEN
1608: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1609: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1610: END IF;

Line 1612: x_return_status := FND_API.G_RET_STS_ERROR ;

1608: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1609: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1610: END IF;
1611: ROLLBACK TO UnHold_BR_PVT;
1612: x_return_status := FND_API.G_RET_STS_ERROR ;
1613: IF PG_DEBUG in ('Y', 'C') THEN
1614: arp_util.debug( 'Exception Error');
1615: END IF;
1616: RAISE;

Line 1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1614: arp_util.debug( 'Exception Error');
1615: END IF;
1616: RAISE;
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: IF PG_DEBUG in ('Y', 'C') THEN
1620: arp_util.debug( 'SQLCODE : ' || SQLCODE);
1621: arp_util.debug( 'SQLERRM : ' || SQLERRM);
1622: END IF;

Line 1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1645: x_return_status := FND_API.G_RET_STS_ERROR ;

1641:
1642: IF (SQLCODE = -20001)
1643: THEN
1644: ROLLBACK TO UnHold_BR_PVT;
1645: x_return_status := FND_API.G_RET_STS_ERROR ;
1646: RAISE;
1647: ELSE
1648: NULL;
1649: END IF;

Line 1652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1648: NULL;
1649: END IF;
1650:
1651: ROLLBACK TO UnHold_BR_PVT;
1652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1653: RAISE;
1654:
1655: END UnHold_BR;
1656:

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

2425:
2426: -- ***** Standard API parameters *****
2427:
2428: p_api_version IN NUMBER ,
2429: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2430: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2432: x_return_status OUT NOCOPY VARCHAR2 ,
2433: x_msg_count OUT NOCOPY NUMBER ,

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

2426: -- ***** Standard API parameters *****
2427:
2428: p_api_version IN NUMBER ,
2429: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2430: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2432: x_return_status OUT NOCOPY VARCHAR2 ,
2433: x_msg_count OUT NOCOPY NUMBER ,
2434: x_msg_data OUT NOCOPY VARCHAR2 ,

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

2427:
2428: p_api_version IN NUMBER ,
2429: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2430: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2432: x_return_status OUT NOCOPY VARCHAR2 ,
2433: x_msg_count OUT NOCOPY NUMBER ,
2434: x_msg_data OUT NOCOPY VARCHAR2 ,
2435:

Line 2486: IF NOT FND_API.Compatible_API_Call( l_api_version ,

2482: /*-----------------------------------------------+
2483: | Standard call to check for call compatibility |
2484: +-----------------------------------------------*/
2485:
2486: IF NOT FND_API.Compatible_API_Call( l_api_version ,
2487: p_api_version ,
2488: l_api_name ,
2489: G_PKG_NAME )
2490: THEN

Line 2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2487: p_api_version ,
2488: l_api_name ,
2489: G_PKG_NAME )
2490: THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: END IF;
2493:
2494:
2495: /*--------------------------------------------------------------+

Line 2499: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2495: /*--------------------------------------------------------------+
2496: | Initialize message list if p_init_msg_list is set to TRUE |
2497: +--------------------------------------------------------------*/
2498:
2499: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2500: FND_MSG_PUB.initialize;
2501: END IF;
2502:
2503:

Line 2508: x_return_status := FND_API.G_RET_STS_SUCCESS;

2504: /*-----------------------------------------------+
2505: | Initialize return status to SUCCESS |
2506: +-----------------------------------------------*/
2507:
2508: x_return_status := FND_API.G_RET_STS_SUCCESS;
2509:
2510:
2511: /*-----------------------------------------------------------------------+
2512: | ============ START OF API BODY - CANCEL BR =================== |

Line 2678: IF FND_API.To_Boolean( p_commit )

2674: /*-----------------------------------------------+
2675: | Standard check of p_commit |
2676: +-----------------------------------------------*/
2677:
2678: IF FND_API.To_Boolean( p_commit )
2679: THEN
2680: IF PG_DEBUG in ('Y', 'C') THEN
2681: arp_util.debug( 'committing');
2682: END IF;

Line 2692: WHEN FND_API.G_EXC_ERROR THEN

2688: END IF;
2689:
2690:
2691: EXCEPTION
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: IF PG_DEBUG in ('Y', 'C') THEN
2694: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2695: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2696: END IF;

Line 2698: x_return_status := FND_API.G_RET_STS_ERROR ;

2694: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2695: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2696: END IF;
2697: ROLLBACK TO Cancel_BR_PVT;
2698: x_return_status := FND_API.G_RET_STS_ERROR ;
2699: IF PG_DEBUG in ('Y', 'C') THEN
2700: arp_util.debug( 'Exception Error');
2701: END IF;
2702: RAISE;

Line 2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2701: END IF;
2702: RAISE;
2703:
2704:
2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2706: IF PG_DEBUG in ('Y', 'C') THEN
2707: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2708: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2709: END IF;

Line 2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2733: x_return_status := FND_API.G_RET_STS_ERROR ;

2729:
2730: IF (SQLCODE = -20001)
2731: THEN
2732: ROLLBACK TO Cancel_BR_PVT;
2733: x_return_status := FND_API.G_RET_STS_ERROR ;
2734: RAISE;
2735: ELSE
2736: NULL;
2737: END IF;

Line 2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2736: NULL;
2737: END IF;
2738:
2739: ROLLBACK TO Cancel_BR_PVT;
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2741: RAISE;
2742:
2743: END Cancel_BR;
2744:

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

2757:
2758: -- ***** Standard API parameters *****
2759:
2760: p_api_version IN NUMBER ,
2761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2762: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2763: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2764: x_return_status OUT NOCOPY VARCHAR2 ,
2765: x_msg_count OUT NOCOPY NUMBER ,

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

2758: -- ***** Standard API parameters *****
2759:
2760: p_api_version IN NUMBER ,
2761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2762: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2763: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2764: x_return_status OUT NOCOPY VARCHAR2 ,
2765: x_msg_count OUT NOCOPY NUMBER ,
2766: x_msg_data OUT NOCOPY VARCHAR2 ,

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

2759:
2760: p_api_version IN NUMBER ,
2761: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2762: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2763: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
2764: x_return_status OUT NOCOPY VARCHAR2 ,
2765: x_msg_count OUT NOCOPY NUMBER ,
2766: x_msg_data OUT NOCOPY VARCHAR2 ,
2767:

Line 2813: IF NOT FND_API.Compatible_API_Call( l_api_version ,

2809: /*-----------------------------------------------+
2810: | Standard call to check for call compatibility |
2811: +-----------------------------------------------*/
2812:
2813: IF NOT FND_API.Compatible_API_Call( l_api_version ,
2814: p_api_version ,
2815: l_api_name ,
2816: G_PKG_NAME )
2817: THEN

Line 2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2814: p_api_version ,
2815: l_api_name ,
2816: G_PKG_NAME )
2817: THEN
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2819: END IF;
2820:
2821:
2822: /*--------------------------------------------------------------+

Line 2826: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2822: /*--------------------------------------------------------------+
2823: | Initialize message list if p_init_msg_list is set to TRUE |
2824: +--------------------------------------------------------------*/
2825:
2826: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2827: FND_MSG_PUB.initialize;
2828: END IF;
2829:
2830:

Line 2835: x_return_status := FND_API.G_RET_STS_SUCCESS;

2831: /*-----------------------------------------------+
2832: | Initialize return status to SUCCESS |
2833: +-----------------------------------------------*/
2834:
2835: x_return_status := FND_API.G_RET_STS_SUCCESS;
2836:
2837:
2838: /*-----------------------------------------------------------------------+
2839: | ============ START OF API BODY - UNPAID BR =================== |

Line 2979: IF FND_API.To_Boolean( p_commit )

2975: /*-----------------------------------------------+
2976: | Standard check of p_commit |
2977: +-----------------------------------------------*/
2978:
2979: IF FND_API.To_Boolean( p_commit )
2980: THEN
2981: IF PG_DEBUG in ('Y', 'C') THEN
2982: arp_util.debug( 'committing');
2983: END IF;

Line 2993: WHEN FND_API.G_EXC_ERROR THEN

2989: END IF;
2990:
2991:
2992: EXCEPTION
2993: WHEN FND_API.G_EXC_ERROR THEN
2994: IF PG_DEBUG in ('Y', 'C') THEN
2995: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2996: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2997: END IF;

Line 2999: x_return_status := FND_API.G_RET_STS_ERROR ;

2995: arp_util.debug( 'SQLCODE : ' || SQLCODE);
2996: arp_util.debug( 'SQLERRM : ' || SQLERRM);
2997: END IF;
2998: ROLLBACK TO Unpaid_BR_PVT;
2999: x_return_status := FND_API.G_RET_STS_ERROR ;
3000: IF PG_DEBUG in ('Y', 'C') THEN
3001: arp_util.debug( 'Exception Error');
3002: END IF;
3003: RAISE;

Line 3006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3002: END IF;
3003: RAISE;
3004:
3005:
3006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3007: IF PG_DEBUG in ('Y', 'C') THEN
3008: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3009: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3010: END IF;

Line 3012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3034: x_return_status := FND_API.G_RET_STS_ERROR ;

3030:
3031: IF (SQLCODE = -20001)
3032: THEN
3033: ROLLBACK TO Unpaid_BR_PVT;
3034: x_return_status := FND_API.G_RET_STS_ERROR ;
3035: RAISE;
3036: ELSE
3037: NULL;
3038: END IF;

Line 3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3037: NULL;
3038: END IF;
3039:
3040: ROLLBACK TO Unpaid_BR_PVT;
3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3042: RAISE;
3043:
3044: END Unpaid_BR;
3045:

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

3058:
3059: -- ***** Standard API parameters *****
3060:
3061: p_api_version IN NUMBER ,
3062: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3063: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3064: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3065: x_return_status OUT NOCOPY VARCHAR2 ,
3066: x_msg_count OUT NOCOPY NUMBER ,

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

3059: -- ***** Standard API parameters *****
3060:
3061: p_api_version IN NUMBER ,
3062: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3063: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3064: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3065: x_return_status OUT NOCOPY VARCHAR2 ,
3066: x_msg_count OUT NOCOPY NUMBER ,
3067: x_msg_data OUT NOCOPY VARCHAR2 ,

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

3060:
3061: p_api_version IN NUMBER ,
3062: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3063: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3064: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3065: x_return_status OUT NOCOPY VARCHAR2 ,
3066: x_msg_count OUT NOCOPY NUMBER ,
3067: x_msg_data OUT NOCOPY VARCHAR2 ,
3068:

Line 3117: IF NOT FND_API.Compatible_API_Call( l_api_version ,

3113: /*-----------------------------------------------+
3114: | Standard call to check for call compatibility |
3115: +-----------------------------------------------*/
3116:
3117: IF NOT FND_API.Compatible_API_Call( l_api_version ,
3118: p_api_version ,
3119: l_api_name ,
3120: G_PKG_NAME )
3121: THEN

Line 3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3118: p_api_version ,
3119: l_api_name ,
3120: G_PKG_NAME )
3121: THEN
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: END IF;
3124:
3125:
3126: /*--------------------------------------------------------------+

Line 3130: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3126: /*--------------------------------------------------------------+
3127: | Initialize message list if p_init_msg_list is set to TRUE |
3128: +--------------------------------------------------------------*/
3129:
3130: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3131: FND_MSG_PUB.initialize;
3132: END IF;
3133:
3134:

Line 3139: x_return_status := FND_API.G_RET_STS_SUCCESS;

3135: /*-----------------------------------------------+
3136: | Initialize return status to SUCCESS |
3137: +-----------------------------------------------*/
3138:
3139: x_return_status := FND_API.G_RET_STS_SUCCESS;
3140:
3141:
3142: /*-----------------------------------------------------------------------+
3143: | ============ START OF API BODY - ENDORSE BR =================== |

Line 3358: IF FND_API.To_Boolean( p_commit )

3354: /*-----------------------------------------------+
3355: | Standard check of p_commit |
3356: +-----------------------------------------------*/
3357:
3358: IF FND_API.To_Boolean( p_commit )
3359: THEN
3360: IF PG_DEBUG in ('Y', 'C') THEN
3361: arp_util.debug( 'committing');
3362: END IF;

Line 3372: WHEN FND_API.G_EXC_ERROR THEN

3368: END IF;
3369:
3370:
3371: EXCEPTION
3372: WHEN FND_API.G_EXC_ERROR THEN
3373: IF PG_DEBUG in ('Y', 'C') THEN
3374: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3375: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3376: END IF;

Line 3378: x_return_status := FND_API.G_RET_STS_ERROR ;

3374: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3375: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3376: END IF;
3377: ROLLBACK TO Endorse_BR_PVT;
3378: x_return_status := FND_API.G_RET_STS_ERROR ;
3379: IF PG_DEBUG in ('Y', 'C') THEN
3380: arp_util.debug( 'Exception Error');
3381: END IF;
3382: RAISE;

Line 3384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3380: arp_util.debug( 'Exception Error');
3381: END IF;
3382: RAISE;
3383:
3384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3385: IF PG_DEBUG in ('Y', 'C') THEN
3386: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3387: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3388: END IF;

Line 3390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3412: x_return_status := FND_API.G_RET_STS_ERROR ;

3408:
3409: IF (SQLCODE = -20001)
3410: THEN
3411: ROLLBACK TO Endorse_BR_PVT;
3412: x_return_status := FND_API.G_RET_STS_ERROR ;
3413: RAISE;
3414: ELSE
3415: NULL;
3416: END IF;

Line 3419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3415: NULL;
3416: END IF;
3417:
3418: ROLLBACK TO Endorse_BR_PVT;
3419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3420: RAISE;
3421:
3422:
3423: END Endorse_BR;

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

3437:
3438: -- ***** Standard API parameters *****
3439:
3440: p_api_version IN NUMBER ,
3441: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3442: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3444: x_return_status OUT NOCOPY VARCHAR2 ,
3445: x_msg_count OUT NOCOPY NUMBER ,

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

3438: -- ***** Standard API parameters *****
3439:
3440: p_api_version IN NUMBER ,
3441: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3442: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3444: x_return_status OUT NOCOPY VARCHAR2 ,
3445: x_msg_count OUT NOCOPY NUMBER ,
3446: x_msg_data OUT NOCOPY VARCHAR2 ,

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

3439:
3440: p_api_version IN NUMBER ,
3441: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3442: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3444: x_return_status OUT NOCOPY VARCHAR2 ,
3445: x_msg_count OUT NOCOPY NUMBER ,
3446: x_msg_data OUT NOCOPY VARCHAR2 ,
3447:

Line 3488: IF NOT FND_API.Compatible_API_Call( l_api_version ,

3484: /*-----------------------------------------------+
3485: | Standard call to check for call compatibility |
3486: +-----------------------------------------------*/
3487:
3488: IF NOT FND_API.Compatible_API_Call( l_api_version ,
3489: p_api_version ,
3490: l_api_name ,
3491: G_PKG_NAME )
3492: THEN

Line 3493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3489: p_api_version ,
3490: l_api_name ,
3491: G_PKG_NAME )
3492: THEN
3493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3494: END IF;
3495:
3496:
3497: /*--------------------------------------------------------------+

Line 3501: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3497: /*--------------------------------------------------------------+
3498: | Initialize message list if p_init_msg_list is set to TRUE |
3499: +--------------------------------------------------------------*/
3500:
3501: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3502: FND_MSG_PUB.initialize;
3503: END IF;
3504:
3505:

Line 3510: x_return_status := FND_API.G_RET_STS_SUCCESS;

3506: /*-----------------------------------------------+
3507: | Initialize return status to SUCCESS |
3508: +-----------------------------------------------*/
3509:
3510: x_return_status := FND_API.G_RET_STS_SUCCESS;
3511:
3512:
3513: /*-----------------------------------------------------------------------+
3514: | ============ START OF API BODY - PROTEST BR =================== |

Line 3618: IF FND_API.To_Boolean( p_commit )

3614: /*-----------------------------------------------+
3615: | Standard check of p_commit |
3616: +-----------------------------------------------*/
3617:
3618: IF FND_API.To_Boolean( p_commit )
3619: THEN
3620: IF PG_DEBUG in ('Y', 'C') THEN
3621: arp_util.debug( 'committing');
3622: END IF;

Line 3632: WHEN FND_API.G_EXC_ERROR THEN

3628: END IF;
3629:
3630:
3631: EXCEPTION
3632: WHEN FND_API.G_EXC_ERROR THEN
3633: IF PG_DEBUG in ('Y', 'C') THEN
3634: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3635: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3636: END IF;

Line 3638: x_return_status := FND_API.G_RET_STS_ERROR ;

3634: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3635: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3636: END IF;
3637: ROLLBACK TO Protest_BR_PVT;
3638: x_return_status := FND_API.G_RET_STS_ERROR ;
3639: IF PG_DEBUG in ('Y', 'C') THEN
3640: arp_util.debug( 'Exception Error');
3641: END IF;
3642: RAISE;

Line 3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3640: arp_util.debug( 'Exception Error');
3641: END IF;
3642: RAISE;
3643:
3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3645: IF PG_DEBUG in ('Y', 'C') THEN
3646: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3647: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3648: END IF;

Line 3650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3672: x_return_status := FND_API.G_RET_STS_ERROR ;

3668:
3669: IF (SQLCODE = -20001)
3670: THEN
3671: ROLLBACK TO Protest_BR_PVT;
3672: x_return_status := FND_API.G_RET_STS_ERROR ;
3673: RAISE;
3674: ELSE
3675: NULL;
3676: END IF;

Line 3679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3675: NULL;
3676: END IF;
3677:
3678: ROLLBACK TO Protest_BR_PVT;
3679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3680:
3681: RAISE;
3682:
3683: END Protest_BR;

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

3697:
3698: -- ***** Standard API parameters *****
3699:
3700: p_api_version IN NUMBER ,
3701: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3702: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3704: x_return_status OUT NOCOPY VARCHAR2 ,
3705: x_msg_count OUT NOCOPY NUMBER ,

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

3698: -- ***** Standard API parameters *****
3699:
3700: p_api_version IN NUMBER ,
3701: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3702: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3704: x_return_status OUT NOCOPY VARCHAR2 ,
3705: x_msg_count OUT NOCOPY NUMBER ,
3706: x_msg_data OUT NOCOPY VARCHAR2 ,

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

3699:
3700: p_api_version IN NUMBER ,
3701: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3702: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3703: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3704: x_return_status OUT NOCOPY VARCHAR2 ,
3705: x_msg_count OUT NOCOPY NUMBER ,
3706: x_msg_data OUT NOCOPY VARCHAR2 ,
3707:

Line 3751: IF NOT FND_API.Compatible_API_Call( l_api_version ,

3747: /*-----------------------------------------------+
3748: | Standard call to check for call compatibility |
3749: +-----------------------------------------------*/
3750:
3751: IF NOT FND_API.Compatible_API_Call( l_api_version ,
3752: p_api_version ,
3753: l_api_name ,
3754: G_PKG_NAME )
3755: THEN

Line 3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3752: p_api_version ,
3753: l_api_name ,
3754: G_PKG_NAME )
3755: THEN
3756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3757: END IF;
3758:
3759:
3760: /*--------------------------------------------------------------+

Line 3764: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3760: /*--------------------------------------------------------------+
3761: | Initialize message list if p_init_msg_list is set to TRUE |
3762: +--------------------------------------------------------------*/
3763:
3764: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3765: FND_MSG_PUB.initialize;
3766: END IF;
3767:
3768:

Line 3773: x_return_status := FND_API.G_RET_STS_SUCCESS;

3769: /*-----------------------------------------------+
3770: | Initialize return status to SUCCESS |
3771: +-----------------------------------------------*/
3772:
3773: x_return_status := FND_API.G_RET_STS_SUCCESS;
3774:
3775:
3776: /*-----------------------------------------------------------------------+
3777: | ============ START OF API BODY - RESTATE BR =================== |

Line 3894: IF FND_API.To_Boolean( p_commit )

3890: /*-----------------------------------------------+
3891: | Standard check of p_commit |
3892: +-----------------------------------------------*/
3893:
3894: IF FND_API.To_Boolean( p_commit )
3895: THEN
3896: IF PG_DEBUG in ('Y', 'C') THEN
3897: arp_util.debug( 'committing');
3898: END IF;

Line 3908: WHEN FND_API.G_EXC_ERROR THEN

3904: END IF;
3905:
3906:
3907: EXCEPTION
3908: WHEN FND_API.G_EXC_ERROR THEN
3909: IF PG_DEBUG in ('Y', 'C') THEN
3910: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3911: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3912: END IF;

Line 3914: x_return_status := FND_API.G_RET_STS_ERROR ;

3910: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3911: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3912: END IF;
3913: ROLLBACK TO Restate_BR_PVT;
3914: x_return_status := FND_API.G_RET_STS_ERROR ;
3915: IF PG_DEBUG in ('Y', 'C') THEN
3916: arp_util.debug( 'Exception Error');
3917: END IF;
3918: RAISE;

Line 3920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3916: arp_util.debug( 'Exception Error');
3917: END IF;
3918: RAISE;
3919:
3920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3921: IF PG_DEBUG in ('Y', 'C') THEN
3922: arp_util.debug( 'SQLCODE : ' || SQLCODE);
3923: arp_util.debug( 'SQLERRM : ' || SQLERRM);
3924: END IF;

Line 3926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3948: x_return_status := FND_API.G_RET_STS_ERROR ;

3944:
3945: IF (SQLCODE = -20001)
3946: THEN
3947: ROLLBACK TO Restate_BR_PVT;
3948: x_return_status := FND_API.G_RET_STS_ERROR ;
3949: RAISE;
3950: ELSE
3951: NULL;
3952: END IF;

Line 3955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3951: NULL;
3952: END IF;
3953:
3954: ROLLBACK TO Restate_BR_PVT;
3955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3956: RAISE;
3957:
3958:
3959: END Restate_BR;

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

3973:
3974: -- ***** Standard API parameters *****
3975:
3976: p_api_version IN NUMBER ,
3977: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3978: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3979: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3980: x_return_status OUT NOCOPY VARCHAR2 ,
3981: x_msg_count OUT NOCOPY NUMBER ,

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

3974: -- ***** Standard API parameters *****
3975:
3976: p_api_version IN NUMBER ,
3977: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3978: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3979: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3980: x_return_status OUT NOCOPY VARCHAR2 ,
3981: x_msg_count OUT NOCOPY NUMBER ,
3982: x_msg_data OUT NOCOPY VARCHAR2 ,

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

3975:
3976: p_api_version IN NUMBER ,
3977: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
3978: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
3979: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
3980: x_return_status OUT NOCOPY VARCHAR2 ,
3981: x_msg_count OUT NOCOPY NUMBER ,
3982: x_msg_data OUT NOCOPY VARCHAR2 ,
3983:

Line 4030: IF NOT FND_API.Compatible_API_Call( l_api_version ,

4026: /*-----------------------------------------------+
4027: | Standard call to check for call compatibility |
4028: +-----------------------------------------------*/
4029:
4030: IF NOT FND_API.Compatible_API_Call( l_api_version ,
4031: p_api_version ,
4032: l_api_name ,
4033: G_PKG_NAME )
4034: THEN

Line 4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4031: p_api_version ,
4032: l_api_name ,
4033: G_PKG_NAME )
4034: THEN
4035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4036: END IF;
4037:
4038:
4039: /*--------------------------------------------------------------+

Line 4043: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4039: /*--------------------------------------------------------------+
4040: | Initialize message list if p_init_msg_list is set to TRUE |
4041: +--------------------------------------------------------------*/
4042:
4043: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4044: FND_MSG_PUB.initialize;
4045: END IF;
4046:
4047:

Line 4052: x_return_status := FND_API.G_RET_STS_SUCCESS;

4048: /*-----------------------------------------------+
4049: | Initialize return status to SUCCESS |
4050: +-----------------------------------------------*/
4051:
4052: x_return_status := FND_API.G_RET_STS_SUCCESS;
4053:
4054:
4055: /*-----------------------------------------------------------------------+
4056: | ============ START OF API BODY - RECALL BR =================== |

Line 4218: IF FND_API.To_Boolean( p_commit )

4214: /*-----------------------------------------------+
4215: | Standard check of p_commit |
4216: +-----------------------------------------------*/
4217:
4218: IF FND_API.To_Boolean( p_commit )
4219: THEN
4220: IF PG_DEBUG in ('Y', 'C') THEN
4221: arp_util.debug( 'committing');
4222: END IF;

Line 4232: WHEN FND_API.G_EXC_ERROR THEN

4228: END IF;
4229:
4230:
4231: EXCEPTION
4232: WHEN FND_API.G_EXC_ERROR THEN
4233: IF PG_DEBUG in ('Y', 'C') THEN
4234: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4235: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4236: END IF;

Line 4238: x_return_status := FND_API.G_RET_STS_ERROR ;

4234: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4235: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4236: END IF;
4237: ROLLBACK TO Recall_BR_PVT;
4238: x_return_status := FND_API.G_RET_STS_ERROR ;
4239: IF PG_DEBUG in ('Y', 'C') THEN
4240: arp_util.debug( 'Exception Error');
4241: END IF;
4242: RAISE;

Line 4244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4240: arp_util.debug( 'Exception Error');
4241: END IF;
4242: RAISE;
4243:
4244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4245: IF PG_DEBUG in ('Y', 'C') THEN
4246: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4247: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4248: END IF;

Line 4250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4272: x_return_status := FND_API.G_RET_STS_ERROR ;

4268:
4269: IF (SQLCODE = -20001)
4270: THEN
4271: ROLLBACK TO Recall_BR_PVT;
4272: x_return_status := FND_API.G_RET_STS_ERROR ;
4273: RAISE;
4274: ELSE
4275: NULL;
4276: END IF;

Line 4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4275: NULL;
4276: END IF;
4277:
4278: ROLLBACK TO Recall_BR_PVT;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4280: RAISE;
4281:
4282:
4283: END Recall_BR;

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

4297:
4298: -- ***** Standard API parameters *****
4299:
4300: p_api_version IN NUMBER ,
4301: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4302: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4304: x_return_status OUT NOCOPY VARCHAR2 ,
4305: x_msg_count OUT NOCOPY NUMBER ,

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

4298: -- ***** Standard API parameters *****
4299:
4300: p_api_version IN NUMBER ,
4301: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4302: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4304: x_return_status OUT NOCOPY VARCHAR2 ,
4305: x_msg_count OUT NOCOPY NUMBER ,
4306: x_msg_data OUT NOCOPY VARCHAR2 ,

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

4299:
4300: p_api_version IN NUMBER ,
4301: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4302: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4304: x_return_status OUT NOCOPY VARCHAR2 ,
4305: x_msg_count OUT NOCOPY NUMBER ,
4306: x_msg_data OUT NOCOPY VARCHAR2 ,
4307:

Line 4357: IF NOT FND_API.Compatible_API_Call( l_api_version ,

4353: /*-----------------------------------------------+
4354: | Standard call to check for call compatibility |
4355: +-----------------------------------------------*/
4356:
4357: IF NOT FND_API.Compatible_API_Call( l_api_version ,
4358: p_api_version ,
4359: l_api_name ,
4360: G_PKG_NAME )
4361: THEN

Line 4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4358: p_api_version ,
4359: l_api_name ,
4360: G_PKG_NAME )
4361: THEN
4362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4363: END IF;
4364:
4365:
4366: /*--------------------------------------------------------------+

Line 4370: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4366: /*--------------------------------------------------------------+
4367: | Initialize message list if p_init_msg_list is set to TRUE |
4368: +--------------------------------------------------------------*/
4369:
4370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4371: FND_MSG_PUB.initialize;
4372: END IF;
4373:
4374:

Line 4379: x_return_status := FND_API.G_RET_STS_SUCCESS;

4375: /*-----------------------------------------------+
4376: | Initialize return status to SUCCESS |
4377: +-----------------------------------------------*/
4378:
4379: x_return_status := FND_API.G_RET_STS_SUCCESS;
4380:
4381:
4382: /*-----------------------------------------------------------------------+
4383: | ============ START OF API BODY - ELIMINATE RISK BR ============ |

Line 4554: IF FND_API.To_Boolean( p_commit )

4550: /*-----------------------------------------------+
4551: | Standard check of p_commit |
4552: +-----------------------------------------------*/
4553:
4554: IF FND_API.To_Boolean( p_commit )
4555: THEN
4556: IF PG_DEBUG in ('Y', 'C') THEN
4557: arp_util.debug( 'committing');
4558: END IF;

Line 4568: WHEN FND_API.G_EXC_ERROR THEN

4564: END IF;
4565:
4566:
4567: EXCEPTION
4568: WHEN FND_API.G_EXC_ERROR THEN
4569: IF PG_DEBUG in ('Y', 'C') THEN
4570: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4571: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4572: END IF;

Line 4574: x_return_status := FND_API.G_RET_STS_ERROR ;

4570: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4571: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4572: END IF;
4573: ROLLBACK TO Eliminate_Risk_BR_PVT;
4574: x_return_status := FND_API.G_RET_STS_ERROR ;
4575: IF PG_DEBUG in ('Y', 'C') THEN
4576: arp_util.debug( 'Exception Error');
4577: END IF;
4578: RAISE;

Line 4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4576: arp_util.debug( 'Exception Error');
4577: END IF;
4578: RAISE;
4579:
4580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4581: IF PG_DEBUG in ('Y', 'C') THEN
4582: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4583: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4584: END IF;

Line 4586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4608: x_return_status := FND_API.G_RET_STS_ERROR ;

4604:
4605: IF (SQLCODE = -20001)
4606: THEN
4607: ROLLBACK TO Eliminate_Risk_BR_PVT;
4608: x_return_status := FND_API.G_RET_STS_ERROR ;
4609: RAISE;
4610: ELSE
4611: NULL;
4612: END IF;

Line 4615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4611: NULL;
4612: END IF;
4613:
4614: ROLLBACK TO Eliminate_Risk_BR_PVT;
4615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4616:
4617: RAISE;
4618:
4619: END Eliminate_Risk_BR;

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

4633:
4634: -- ***** Standard API parameters *****
4635:
4636: p_api_version IN NUMBER ,
4637: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4638: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4640: x_return_status OUT NOCOPY VARCHAR2 ,
4641: x_msg_count OUT NOCOPY NUMBER ,

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

4634: -- ***** Standard API parameters *****
4635:
4636: p_api_version IN NUMBER ,
4637: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4638: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4640: x_return_status OUT NOCOPY VARCHAR2 ,
4641: x_msg_count OUT NOCOPY NUMBER ,
4642: x_msg_data OUT NOCOPY VARCHAR2 ,

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

4635:
4636: p_api_version IN NUMBER ,
4637: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
4638: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
4639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
4640: x_return_status OUT NOCOPY VARCHAR2 ,
4641: x_msg_count OUT NOCOPY NUMBER ,
4642: x_msg_data OUT NOCOPY VARCHAR2 ,
4643:

Line 4697: IF NOT FND_API.Compatible_API_Call( l_api_version ,

4693: /*-----------------------------------------------+
4694: | Standard call to check for call compatibility |
4695: +-----------------------------------------------*/
4696:
4697: IF NOT FND_API.Compatible_API_Call( l_api_version ,
4698: p_api_version ,
4699: l_api_name ,
4700: G_PKG_NAME )
4701: THEN

Line 4702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4698: p_api_version ,
4699: l_api_name ,
4700: G_PKG_NAME )
4701: THEN
4702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4703: END IF;
4704:
4705:
4706: /*--------------------------------------------------------------+

Line 4710: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4706: /*--------------------------------------------------------------+
4707: | Initialize message list if p_init_msg_list is set to TRUE |
4708: +--------------------------------------------------------------*/
4709:
4710: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4711: FND_MSG_PUB.initialize;
4712: END IF;
4713:
4714:

Line 4719: x_return_status := FND_API.G_RET_STS_SUCCESS;

4715: /*-----------------------------------------------+
4716: | Initialize return status to SUCCESS |
4717: +-----------------------------------------------*/
4718:
4719: x_return_status := FND_API.G_RET_STS_SUCCESS;
4720:
4721:
4722: /*-----------------------------------------------------------------------+
4723: | ============ START OF API BODY - UNELIMINATE RISK BR =============|

Line 4921: IF FND_API.To_Boolean( p_commit )

4917: /*-----------------------------------------------+
4918: | Standard check of p_commit |
4919: +-----------------------------------------------*/
4920:
4921: IF FND_API.To_Boolean( p_commit )
4922: THEN
4923:
4924: IF PG_DEBUG in ('Y', 'C') THEN
4925: arp_util.debug( 'committing');

Line 4936: WHEN FND_API.G_EXC_ERROR THEN

4932: END IF;
4933:
4934:
4935: EXCEPTION
4936: WHEN FND_API.G_EXC_ERROR THEN
4937: IF PG_DEBUG in ('Y', 'C') THEN
4938: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4939: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4940: END IF;

Line 4942: x_return_status := FND_API.G_RET_STS_ERROR ;

4938: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4939: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4940: END IF;
4941: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4942: x_return_status := FND_API.G_RET_STS_ERROR ;
4943: IF PG_DEBUG in ('Y', 'C') THEN
4944: arp_util.debug( 'Exception Error');
4945: END IF;
4946: RAISE;

Line 4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4944: arp_util.debug( 'Exception Error');
4945: END IF;
4946: RAISE;
4947:
4948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4949: IF PG_DEBUG in ('Y', 'C') THEN
4950: arp_util.debug( 'SQLCODE : ' || SQLCODE);
4951: arp_util.debug( 'SQLERRM : ' || SQLERRM);
4952: END IF;

Line 4954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4976: x_return_status := FND_API.G_RET_STS_ERROR ;

4972:
4973: IF (SQLCODE = -20001)
4974: THEN
4975: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4976: x_return_status := FND_API.G_RET_STS_ERROR ;
4977: RAISE;
4978: ELSE
4979: NULL;
4980: END IF;

Line 4983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4979: NULL;
4980: END IF;
4981:
4982: ROLLBACK TO UnEliminate_Risk_BR_PVT;
4983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4984: RAISE;
4985:
4986:
4987: END UnEliminate_Risk_BR;

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

5001:
5002: -- ***** Standard API parameters *****
5003:
5004: p_api_version IN NUMBER ,
5005: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
5006: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5008: x_return_status OUT NOCOPY VARCHAR2 ,
5009: x_msg_count OUT NOCOPY NUMBER ,

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

5002: -- ***** Standard API parameters *****
5003:
5004: p_api_version IN NUMBER ,
5005: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
5006: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5008: x_return_status OUT NOCOPY VARCHAR2 ,
5009: x_msg_count OUT NOCOPY NUMBER ,
5010: x_msg_data OUT NOCOPY VARCHAR2 ,

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

5003:
5004: p_api_version IN NUMBER ,
5005: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
5006: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
5007: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
5008: x_return_status OUT NOCOPY VARCHAR2 ,
5009: x_msg_count OUT NOCOPY NUMBER ,
5010: x_msg_data OUT NOCOPY VARCHAR2 ,
5011:

Line 5061: IF NOT FND_API.Compatible_API_Call( l_api_version ,

5057: /*-----------------------------------------------+
5058: | Standard call to check for call compatibility |
5059: +-----------------------------------------------*/
5060:
5061: IF NOT FND_API.Compatible_API_Call( l_api_version ,
5062: p_api_version ,
5063: l_api_name ,
5064: G_PKG_NAME )
5065: THEN

Line 5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5062: p_api_version ,
5063: l_api_name ,
5064: G_PKG_NAME )
5065: THEN
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END IF;
5068:
5069:
5070: /*--------------------------------------------------------------+

Line 5074: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5070: /*--------------------------------------------------------------+
5071: | Initialize message list if p_init_msg_list is set to TRUE |
5072: +--------------------------------------------------------------*/
5073:
5074: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5075: FND_MSG_PUB.initialize;
5076: END IF;
5077:
5078:

Line 5083: x_return_status := FND_API.G_RET_STS_SUCCESS;

5079: /*-----------------------------------------------+
5080: | Initialize return status to SUCCESS |
5081: +-----------------------------------------------*/
5082:
5083: x_return_status := FND_API.G_RET_STS_SUCCESS;
5084:
5085:
5086: /*-----------------------------------------------------------------------+
5087: | ============ START OF API BODY - EXCHANGE BR =================== |

Line 5159: p_init_msg_list => FND_API.G_TRUE ,

5155: AR_BILLS_CREATION_PUB.create_br_header (
5156:
5157: p_api_version => 1.0 ,
5158: x_return_status => l_return_status ,
5159: p_init_msg_list => FND_API.G_TRUE ,
5160: x_msg_count => l_msg_count ,
5161: x_msg_data => l_msg_data ,
5162:
5163: p_trx_number => NULL ,

Line 5224: p_init_msg_list => FND_API.G_TRUE ,

5220:
5221: AR_BILLS_CREATION_PUB.create_br_assignment (
5222:
5223: p_api_version => 1.0 ,
5224: p_init_msg_list => FND_API.G_TRUE ,
5225: p_commit => FND_API.G_FALSE ,
5226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
5227: x_return_status => l_return_status ,
5228: x_msg_count => l_msg_count ,

Line 5225: p_commit => FND_API.G_FALSE ,

5221: AR_BILLS_CREATION_PUB.create_br_assignment (
5222:
5223: p_api_version => 1.0 ,
5224: p_init_msg_list => FND_API.G_TRUE ,
5225: p_commit => FND_API.G_FALSE ,
5226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
5227: x_return_status => l_return_status ,
5228: x_msg_count => l_msg_count ,
5229: x_msg_data => l_msg_data ,

Line 5226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

5222:
5223: p_api_version => 1.0 ,
5224: p_init_msg_list => FND_API.G_TRUE ,
5225: p_commit => FND_API.G_FALSE ,
5226: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
5227: x_return_status => l_return_status ,
5228: x_msg_count => l_msg_count ,
5229: x_msg_data => l_msg_data ,
5230:

Line 5281: IF FND_API.To_Boolean( p_commit )

5277: /*-----------------------------------------------+
5278: | Standard check of p_commit |
5279: +-----------------------------------------------*/
5280:
5281: IF FND_API.To_Boolean( p_commit )
5282: THEN
5283: IF PG_DEBUG in ('Y', 'C') THEN
5284: arp_util.debug( 'committing');
5285: END IF;

Line 5297: x_return_status := FND_API.G_RET_STS_ERROR ;

5293:
5294: EXCEPTION
5295: WHEN API_exception THEN
5296: ROLLBACK TO Exchange_BR_PVT;
5297: x_return_status := FND_API.G_RET_STS_ERROR ;
5298: IF PG_DEBUG in ('Y', 'C') THEN
5299: arp_util.debug ('API Exception : AR_BILLS_MAINTAIN_PUB.Exchange_BR : ' || SQLERRM);
5300: END IF;
5301: RAISE;

Line 5303: WHEN FND_API.G_EXC_ERROR THEN

5299: arp_util.debug ('API Exception : AR_BILLS_MAINTAIN_PUB.Exchange_BR : ' || SQLERRM);
5300: END IF;
5301: RAISE;
5302:
5303: WHEN FND_API.G_EXC_ERROR THEN
5304: IF PG_DEBUG in ('Y', 'C') THEN
5305: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5306: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5307: END IF;

Line 5309: x_return_status := FND_API.G_RET_STS_ERROR ;

5305: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5306: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5307: END IF;
5308: ROLLBACK TO Exchange_BR_PVT;
5309: x_return_status := FND_API.G_RET_STS_ERROR ;
5310: IF PG_DEBUG in ('Y', 'C') THEN
5311: arp_util.debug( 'Exception Error');
5312: END IF;
5313: RAISE;

Line 5316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5312: END IF;
5313: RAISE;
5314:
5315:
5316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5317: IF PG_DEBUG in ('Y', 'C') THEN
5318: arp_util.debug( 'SQLCODE : ' || SQLCODE);
5319: arp_util.debug( 'SQLERRM : ' || SQLERRM);
5320: END IF;

Line 5322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 5344: x_return_status := FND_API.G_RET_STS_ERROR ;

5340:
5341: IF (SQLCODE = -20001)
5342: THEN
5343: ROLLBACK TO Exchange_BR_PVT;
5344: x_return_status := FND_API.G_RET_STS_ERROR ;
5345: RAISE;
5346: ELSE
5347: NULL;
5348: END IF;

Line 5351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5347: NULL;
5348: END IF;
5349:
5350: ROLLBACK TO Exchange_BR_PVT;
5351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5352: RAISE;
5353:
5354: END Exchange_BR;
5355: