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

APPS.AR_BILLS_CREATION_PUB dependencies on FND_API

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

47: PROCEDURE Create_BR_Header (
48:
49: -- ***** Standard API parameters *****
50: p_api_version IN NUMBER ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2 ,
55: x_msg_count OUT NOCOPY NUMBER ,

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

48:
49: -- ***** Standard API parameters *****
50: p_api_version IN NUMBER ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2 ,
55: x_msg_count OUT NOCOPY NUMBER ,
56: x_msg_data OUT NOCOPY VARCHAR2 ,

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

49: -- ***** Standard API parameters *****
50: p_api_version IN NUMBER ,
51: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
52: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
53: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54: x_return_status OUT NOCOPY VARCHAR2 ,
55: x_msg_count OUT NOCOPY NUMBER ,
56: x_msg_data OUT NOCOPY VARCHAR2 ,
57:

Line 144: IF NOT FND_API.Compatible_API_Call( l_api_version ,

140: /*-----------------------------------------------+
141: | Standard call to check for call compatibility |
142: +-----------------------------------------------*/
143:
144: IF NOT FND_API.Compatible_API_Call( l_api_version ,
145: p_api_version ,
146: l_api_name ,
147: G_PKG_NAME )
148: THEN

Line 149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

145: p_api_version ,
146: l_api_name ,
147: G_PKG_NAME )
148: THEN
149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: END IF;
151:
152:
153: /*-----------------------------------------------+

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153: /*-----------------------------------------------+
154: | Initialize return status to SUCCESS |
155: +-----------------------------------------------*/
156:
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159:
160: /*-----------------------------------------------+
161: | ======== START OF API BODY ============ |

Line 260: IF FND_API.To_Boolean( p_commit )

256: /*-----------------------------------------------+
257: | Standard check of p_commit |
258: +-----------------------------------------------*/
259:
260: IF FND_API.To_Boolean( p_commit )
261: THEN
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_util.debug( 'committing');
264: END IF;

Line 274: WHEN FND_API.G_EXC_ERROR THEN

270: END IF;
271:
272:
273: EXCEPTION
274: WHEN FND_API.G_EXC_ERROR THEN
275:
276: IF PG_DEBUG in ('Y', 'C') THEN
277: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
278: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 281: x_return_status := FND_API.G_RET_STS_ERROR ;

277: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
278: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
279: END IF;
280: ROLLBACK TO Create_BR_Header_PVT;
281: x_return_status := FND_API.G_RET_STS_ERROR ;
282: IF PG_DEBUG in ('Y', 'C') THEN
283: arp_util.debug( 'Exception Error');
284: END IF;
285: RAISE;

Line 288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

284: END IF;
285: RAISE;
286:
287:
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289:
290: IF PG_DEBUG in ('Y', 'C') THEN
291: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
292: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

291: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
292: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
293: END IF;
294: ROLLBACK TO Create_BR_Header_PVT;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: IF PG_DEBUG in ('Y', 'C') THEN
297: arp_util.debug( 'Exception Unexpected Error');
298: END IF;
299: RAISE;

Line 319: x_return_status := FND_API.G_RET_STS_ERROR ;

315: ROLLBACK TO Create_BR_Header_PVT;
316:
317: IF (SQLCODE = -20001)
318: THEN
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: ELSE
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: END IF;
323:

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

317: IF (SQLCODE = -20001)
318: THEN
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: ELSE
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: END IF;
323:
324: RAISE;
325:

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

340: PROCEDURE Update_BR_Header (
341:
342: -- ***** Standard API parameters *****
343: p_api_version IN NUMBER ,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
347: x_return_status OUT NOCOPY VARCHAR2 ,
348: x_msg_count OUT NOCOPY NUMBER ,

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

341:
342: -- ***** Standard API parameters *****
343: p_api_version IN NUMBER ,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
347: x_return_status OUT NOCOPY VARCHAR2 ,
348: x_msg_count OUT NOCOPY NUMBER ,
349: x_msg_data OUT NOCOPY VARCHAR2 ,

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

342: -- ***** Standard API parameters *****
343: p_api_version IN NUMBER ,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
347: x_return_status OUT NOCOPY VARCHAR2 ,
348: x_msg_count OUT NOCOPY NUMBER ,
349: x_msg_data OUT NOCOPY VARCHAR2 ,
350:

Line 423: IF NOT FND_API.Compatible_API_Call(

419: /*-----------------------------------------------+
420: | Standard call to check for call compatibility |
421: +-----------------------------------------------*/
422:
423: IF NOT FND_API.Compatible_API_Call(
424: l_api_version ,
425: p_api_version ,
426: l_api_name ,
427: G_PKG_NAME )

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

425: p_api_version ,
426: l_api_name ,
427: G_PKG_NAME )
428: THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431:
432:
433: /*-----------------------------------------------+

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: /*-----------------------------------------------+
434: | Initialize return status to SUCCESS |
435: +-----------------------------------------------*/
436:
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439:
440: /*-----------------------------------------------+
441: | ======== START OF API BODY ============ |

Line 580: IF FND_API.To_Boolean( p_commit )

576: /*-----------------------------------------------+
577: | Standard check of p_commit |
578: +-----------------------------------------------*/
579:
580: IF FND_API.To_Boolean( p_commit )
581: THEN
582: IF PG_DEBUG in ('Y', 'C') THEN
583: arp_util.debug( 'committing');
584: END IF;

Line 593: WHEN FND_API.G_EXC_ERROR THEN

589: arp_util.debug('AR_BILLS_CREATION_PUB.Update_BR_Header()- ');
590: END IF;
591:
592: EXCEPTION
593: WHEN FND_API.G_EXC_ERROR THEN
594:
595: IF PG_DEBUG in ('Y', 'C') THEN
596: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
597: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 600: x_return_status := FND_API.G_RET_STS_ERROR ;

596: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
597: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
598: END IF;
599: ROLLBACK TO Update_BR_Header_PVT;
600: x_return_status := FND_API.G_RET_STS_ERROR ;
601: IF PG_DEBUG in ('Y', 'C') THEN
602: arp_util.debug( 'Exception Error');
603: END IF;
604: RAISE;

Line 607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

603: END IF;
604: RAISE;
605:
606:
607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
608:
609: IF PG_DEBUG in ('Y', 'C') THEN
610: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
611: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

610: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
611: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
612: END IF;
613: ROLLBACK TO Update_BR_Header_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: IF PG_DEBUG in ('Y', 'C') THEN
616: arp_util.debug( 'Exception Unexpected Error');
617: END IF;
618: RAISE;

Line 638: x_return_status := FND_API.G_RET_STS_ERROR ;

634: ROLLBACK TO Update_BR_Header_PVT;
635:
636: IF (SQLCODE = -20001)
637: THEN
638: x_return_status := FND_API.G_RET_STS_ERROR ;
639: ELSE
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: END IF;
642:

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

636: IF (SQLCODE = -20001)
637: THEN
638: x_return_status := FND_API.G_RET_STS_ERROR ;
639: ELSE
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: END IF;
642:
643: RAISE;
644:

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

657: PROCEDURE Delete_BR_Header (
658:
659: -- ***** Standard API parameters *****
660: p_api_version IN NUMBER ,
661: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
662: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: x_return_status OUT NOCOPY VARCHAR2 ,
665: x_msg_count OUT NOCOPY NUMBER ,

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

658:
659: -- ***** Standard API parameters *****
660: p_api_version IN NUMBER ,
661: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
662: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: x_return_status OUT NOCOPY VARCHAR2 ,
665: x_msg_count OUT NOCOPY NUMBER ,
666: x_msg_data OUT NOCOPY VARCHAR2 ,

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

659: -- ***** Standard API parameters *****
660: p_api_version IN NUMBER ,
661: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
662: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: x_return_status OUT NOCOPY VARCHAR2 ,
665: x_msg_count OUT NOCOPY NUMBER ,
666: x_msg_data OUT NOCOPY VARCHAR2 ,
667:

Line 716: IF NOT FND_API.Compatible_API_Call(

712: /*-----------------------------------------------+
713: | Standard call to check for call compatibility |
714: +-----------------------------------------------*/
715:
716: IF NOT FND_API.Compatible_API_Call(
717: l_api_version ,
718: p_api_version ,
719: l_api_name ,
720: G_PKG_NAME

Line 723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

719: l_api_name ,
720: G_PKG_NAME
721: )
722: THEN
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725:
726:
727: /*-----------------------------------------------+

Line 731: x_return_status := FND_API.G_RET_STS_SUCCESS;

727: /*-----------------------------------------------+
728: | Initialize return status to SUCCESS |
729: +-----------------------------------------------*/
730:
731: x_return_status := FND_API.G_RET_STS_SUCCESS;
732:
733:
734: /*-----------------------------------------------+
735: | ======== START OF API BODY ============ |

Line 800: IF FND_API.To_Boolean( p_commit )

796: /*-----------------------------------------------+
797: | Standard check of p_commit |
798: +-----------------------------------------------*/
799:
800: IF FND_API.To_Boolean( p_commit )
801: THEN
802: IF PG_DEBUG in ('Y', 'C') THEN
803: arp_util.debug( 'committing');
804: END IF;

Line 814: WHEN FND_API.G_EXC_ERROR THEN

810: END IF;
811:
812:
813: EXCEPTION
814: WHEN FND_API.G_EXC_ERROR THEN
815:
816: IF PG_DEBUG in ('Y', 'C') THEN
817: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
818: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 821: x_return_status := FND_API.G_RET_STS_ERROR ;

817: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
818: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
819: END IF;
820: ROLLBACK TO Delete_BR_Header_PVT;
821: x_return_status := FND_API.G_RET_STS_ERROR ;
822: IF PG_DEBUG in ('Y', 'C') THEN
823: arp_util.debug( 'Exception Error');
824: END IF;
825: RAISE;

Line 827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

823: arp_util.debug( 'Exception Error');
824: END IF;
825: RAISE;
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828:
829: IF PG_DEBUG in ('Y', 'C') THEN
830: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
831: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

830: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
831: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
832: END IF;
833: ROLLBACK TO Delete_BR_Header_PVT;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
835: IF PG_DEBUG in ('Y', 'C') THEN
836: arp_util.debug( 'Exception Unexpected Error');
837: END IF;
838: RAISE;

Line 857: x_return_status := FND_API.G_RET_STS_ERROR ;

853: ROLLBACK TO Delete_BR_Header_PVT;
854:
855: IF (SQLCODE = -20001)
856: THEN
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: ELSE
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: END IF;
861:

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

855: IF (SQLCODE = -20001)
856: THEN
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: ELSE
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: END IF;
861:
862: RAISE;
863:

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

878: PROCEDURE Lock_BR_Header (
879:
880: -- ***** Standard API parameters *****
881: p_api_version IN NUMBER ,
882: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
883: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
885: x_return_status OUT NOCOPY VARCHAR2 ,
886: x_msg_count OUT NOCOPY NUMBER ,

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

879:
880: -- ***** Standard API parameters *****
881: p_api_version IN NUMBER ,
882: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
883: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
885: x_return_status OUT NOCOPY VARCHAR2 ,
886: x_msg_count OUT NOCOPY NUMBER ,
887: x_msg_data OUT NOCOPY VARCHAR2 ,

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

880: -- ***** Standard API parameters *****
881: p_api_version IN NUMBER ,
882: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
883: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
885: x_return_status OUT NOCOPY VARCHAR2 ,
886: x_msg_count OUT NOCOPY NUMBER ,
887: x_msg_data OUT NOCOPY VARCHAR2 ,
888:

Line 957: IF NOT FND_API.Compatible_API_Call(

953: /*-----------------------------------------------+
954: | Standard call to check for call compatibility |
955: +-----------------------------------------------*/
956:
957: IF NOT FND_API.Compatible_API_Call(
958: l_api_version ,
959: p_api_version ,
960: l_api_name ,
961: G_PKG_NAME

Line 964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

960: l_api_name ,
961: G_PKG_NAME
962: )
963: THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: END IF;
966:
967:
968: /*-----------------------------------------------+

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968: /*-----------------------------------------------+
969: | Initialize return status to SUCCESS |
970: +-----------------------------------------------*/
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974:
975: /*-----------------------------------------------+
976: | ======== START OF API BODY ============ |

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031: END IF;
1032:
1033:
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036:
1037: IF PG_DEBUG in ('Y', 'C') THEN
1038: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1039: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1042: x_return_status := FND_API.G_RET_STS_ERROR ;

1038: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1039: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1040: END IF;
1041: ROLLBACK TO Lock_BR_Header_PVT;
1042: x_return_status := FND_API.G_RET_STS_ERROR ;
1043: IF PG_DEBUG in ('Y', 'C') THEN
1044: arp_util.debug( 'Exception Error');
1045: END IF;
1046: RAISE;

Line 1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1044: arp_util.debug( 'Exception Error');
1045: END IF;
1046: RAISE;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049:
1050: IF PG_DEBUG in ('Y', 'C') THEN
1051: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1052: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1051: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1052: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1053: END IF;
1054: ROLLBACK TO Lock_BR_Header_PVT;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: IF PG_DEBUG in ('Y', 'C') THEN
1057: arp_util.debug( 'Exception Unexpected Error');
1058: END IF;
1059: RAISE;

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR ;

1075: ROLLBACK TO Lock_BR_Header_PVT;
1076:
1077: IF (SQLCODE = -20001)
1078: THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR ;
1080: ELSE
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1082: END IF;
1083:

Line 1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1077: IF (SQLCODE = -20001)
1078: THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR ;
1080: ELSE
1081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1082: END IF;
1083:
1084: RAISE;
1085:

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

1100: PROCEDURE Create_BR_Assignment (
1101:
1102: -- ***** Standard API parameters *****
1103: p_api_version IN NUMBER ,
1104: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1105: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1107: x_return_status OUT NOCOPY VARCHAR2 ,
1108: x_msg_count OUT NOCOPY NUMBER ,

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

1101:
1102: -- ***** Standard API parameters *****
1103: p_api_version IN NUMBER ,
1104: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1105: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1107: x_return_status OUT NOCOPY VARCHAR2 ,
1108: x_msg_count OUT NOCOPY NUMBER ,
1109: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1102: -- ***** Standard API parameters *****
1103: p_api_version IN NUMBER ,
1104: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1105: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1107: x_return_status OUT NOCOPY VARCHAR2 ,
1108: x_msg_count OUT NOCOPY NUMBER ,
1109: x_msg_data OUT NOCOPY VARCHAR2 ,
1110:

Line 1171: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1167: /*-----------------------------------------------+
1168: | Standard call to check for call compatibility |
1169: +-----------------------------------------------*/
1170:
1171: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1172: p_api_version ,
1173: l_api_name ,
1174: G_PKG_NAME )
1175: THEN

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: p_api_version ,
1173: l_api_name ,
1174: G_PKG_NAME )
1175: THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177: END IF;
1178:
1179:
1180: /*-----------------------------------------------+

Line 1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

1180: /*-----------------------------------------------+
1181: | Initialize return status to SUCCESS |
1182: +-----------------------------------------------*/
1183:
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185:
1186:
1187: /*-----------------------------------------------+
1188: | ======== START OF API BODY ============ |

Line 1323: IF FND_API.To_Boolean( p_commit )

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

Line 1337: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1344: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1354: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1355: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1356: END IF;
1357: ROLLBACK TO Create_BR_Assignment_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 1382: x_return_status := FND_API.G_RET_STS_ERROR ;

1378: ROLLBACK TO Create_BR_Assignment_PVT;
1379:
1380: IF (SQLCODE = -20001)
1381: THEN
1382: x_return_status := FND_API.G_RET_STS_ERROR ;
1383: ELSE
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385: END IF;
1386:

Line 1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1380: IF (SQLCODE = -20001)
1381: THEN
1382: x_return_status := FND_API.G_RET_STS_ERROR ;
1383: ELSE
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385: END IF;
1386:
1387: RAISE;
1388:

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

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

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

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

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

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

Line 1470: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1466: /*-----------------------------------------------+
1467: | Standard call to check for call compatibility |
1468: +-----------------------------------------------*/
1469:
1470: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1471: p_api_version ,
1472: l_api_name ,
1473: G_PKG_NAME )
1474: THEN

Line 1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1471: p_api_version ,
1472: l_api_name ,
1473: G_PKG_NAME )
1474: THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;
1477:
1478:
1479: /*-----------------------------------------------+

Line 1483: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1561: IF FND_API.To_Boolean( p_commit )

1557: /*-----------------------------------------------+
1558: | Standard check of p_commit |
1559: +-----------------------------------------------*/
1560:
1561: IF FND_API.To_Boolean( p_commit )
1562: THEN
1563: IF PG_DEBUG in ('Y', 'C') THEN
1564: arp_util.debug( 'committing');
1565: END IF;

Line 1575: WHEN FND_API.G_EXC_ERROR THEN

1571: END IF;
1572:
1573:
1574: EXCEPTION
1575: WHEN FND_API.G_EXC_ERROR THEN
1576: IF PG_DEBUG in ('Y', 'C') THEN
1577: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1578: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1579: END IF;

Line 1581: x_return_status := FND_API.G_RET_STS_ERROR ;

1577: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1578: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1579: END IF;
1580: ROLLBACK TO Update_BR_Assignment_PVT;
1581: x_return_status := FND_API.G_RET_STS_ERROR ;
1582: RAISE;
1583:
1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1585:

Line 1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1580: ROLLBACK TO Update_BR_Assignment_PVT;
1581: x_return_status := FND_API.G_RET_STS_ERROR ;
1582: RAISE;
1583:
1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1585:
1586: IF PG_DEBUG in ('Y', 'C') THEN
1587: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1588: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1587: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1588: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1589: END IF;
1590: ROLLBACK TO Update_BR_Assignment_PVT;
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: RAISE;
1593:
1594: WHEN OTHERS THEN
1595:

Line 1612: x_return_status := FND_API.G_RET_STS_ERROR ;

1608: ROLLBACK TO Update_BR_Assignment_PVT;
1609:
1610: IF (SQLCODE = -20001)
1611: THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR ;
1613: ELSE
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1615: END IF;
1616:

Line 1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1610: IF (SQLCODE = -20001)
1611: THEN
1612: x_return_status := FND_API.G_RET_STS_ERROR ;
1613: ELSE
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1615: END IF;
1616:
1617: RAISE;
1618:

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

1634: PROCEDURE Delete_BR_Assignment (
1635:
1636: -- ***** Standard API parameters *****
1637: p_api_version IN NUMBER ,
1638: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1639: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1640: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1641: x_return_status OUT NOCOPY VARCHAR2 ,
1642: x_msg_count OUT NOCOPY NUMBER ,

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

1635:
1636: -- ***** Standard API parameters *****
1637: p_api_version IN NUMBER ,
1638: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1639: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1640: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1641: x_return_status OUT NOCOPY VARCHAR2 ,
1642: x_msg_count OUT NOCOPY NUMBER ,
1643: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1636: -- ***** Standard API parameters *****
1637: p_api_version IN NUMBER ,
1638: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1639: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1640: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1641: x_return_status OUT NOCOPY VARCHAR2 ,
1642: x_msg_count OUT NOCOPY NUMBER ,
1643: x_msg_data OUT NOCOPY VARCHAR2 ,
1644:

Line 1676: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1672: /*-----------------------------------------------+
1673: | Standard call to check for call compatibility |
1674: +-----------------------------------------------*/
1675:
1676: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1677: p_api_version ,
1678: l_api_name ,
1679: G_PKG_NAME )
1680: THEN

Line 1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1677: p_api_version ,
1678: l_api_name ,
1679: G_PKG_NAME )
1680: THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1682: END IF;
1683:
1684:
1685: /*-----------------------------------------------+

Line 1689: x_return_status := FND_API.G_RET_STS_SUCCESS;

1685: /*-----------------------------------------------+
1686: | Initialize return status to SUCCESS |
1687: +-----------------------------------------------*/
1688:
1689: x_return_status := FND_API.G_RET_STS_SUCCESS;
1690:
1691:
1692: /*-----------------------------------------------+
1693: | ======== START OF API BODY ============ |

Line 1728: IF FND_API.To_Boolean( p_commit )

1724: /*-----------------------------------------------+
1725: | Standard check of p_commit |
1726: +-----------------------------------------------*/
1727:
1728: IF FND_API.To_Boolean( p_commit )
1729: THEN
1730: IF PG_DEBUG in ('Y', 'C') THEN
1731: arp_util.debug( 'committing');
1732: END IF;

Line 1742: WHEN FND_API.G_EXC_ERROR THEN

1738: END IF;
1739:
1740:
1741: EXCEPTION
1742: WHEN FND_API.G_EXC_ERROR THEN
1743:
1744: IF PG_DEBUG in ('Y', 'C') THEN
1745: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1746: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1749: x_return_status := FND_API.G_RET_STS_ERROR ;

1745: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1746: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1747: END IF;
1748: ROLLBACK TO Delete_BR_Assignment_PVT;
1749: x_return_status := FND_API.G_RET_STS_ERROR ;
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug( 'Exception Error');
1752: END IF;
1753: RAISE;

Line 1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1751: arp_util.debug( 'Exception Error');
1752: END IF;
1753: RAISE;
1754:
1755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1756:
1757: IF PG_DEBUG in ('Y', 'C') THEN
1758: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1759: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1758: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1759: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1760: END IF;
1761: ROLLBACK TO Delete_BR_Assignment_PVT;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763: IF PG_DEBUG in ('Y', 'C') THEN
1764: arp_util.debug( 'Exception Unexpected Error');
1765: END IF;
1766: RAISE;

Line 1785: x_return_status := FND_API.G_RET_STS_ERROR ;

1781: ROLLBACK TO Delete_BR_Assignment_PVT;
1782:
1783: IF (SQLCODE = -20001)
1784: THEN
1785: x_return_status := FND_API.G_RET_STS_ERROR ;
1786: ELSE
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1788: END IF;
1789:

Line 1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1783: IF (SQLCODE = -20001)
1784: THEN
1785: x_return_status := FND_API.G_RET_STS_ERROR ;
1786: ELSE
1787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1788: END IF;
1789:
1790: RAISE;
1791:

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

1806: PROCEDURE Lock_BR_Assignment (
1807:
1808: -- ***** Standard API parameters *****
1809: p_api_version IN NUMBER ,
1810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1811: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1813: x_return_status OUT NOCOPY VARCHAR2 ,
1814: x_msg_count OUT NOCOPY NUMBER ,

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

1807:
1808: -- ***** Standard API parameters *****
1809: p_api_version IN NUMBER ,
1810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1811: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1813: x_return_status OUT NOCOPY VARCHAR2 ,
1814: x_msg_count OUT NOCOPY NUMBER ,
1815: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1808: -- ***** Standard API parameters *****
1809: p_api_version IN NUMBER ,
1810: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1811: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1813: x_return_status OUT NOCOPY VARCHAR2 ,
1814: x_msg_count OUT NOCOPY NUMBER ,
1815: x_msg_data OUT NOCOPY VARCHAR2 ,
1816:

Line 1869: IF NOT FND_API.Compatible_API_Call( l_api_version ,

1865: /*-----------------------------------------------+
1866: | Standard call to check for call compatibility |
1867: +-----------------------------------------------*/
1868:
1869: IF NOT FND_API.Compatible_API_Call( l_api_version ,
1870: p_api_version ,
1871: l_api_name ,
1872: G_PKG_NAME )
1873: THEN

Line 1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1870: p_api_version ,
1871: l_api_name ,
1872: G_PKG_NAME )
1873: THEN
1874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1875: END IF;
1876:
1877:
1878: /*-----------------------------------------------+

Line 1882: x_return_status := FND_API.G_RET_STS_SUCCESS;

1878: /*-----------------------------------------------+
1879: | Initialize return status to SUCCESS |
1880: +-----------------------------------------------*/
1881:
1882: x_return_status := FND_API.G_RET_STS_SUCCESS;
1883:
1884:
1885: /*-----------------------------------------------+
1886: | ======== START OF API BODY ============ |

Line 1930: WHEN FND_API.G_EXC_ERROR THEN

1926: arp_util.debug('AR_BILLS_CREATION_PUB.Lock_BR_Assignment()- ');
1927: END IF;
1928:
1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN
1931:
1932: IF PG_DEBUG in ('Y', 'C') THEN
1933: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1934: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1937: x_return_status := FND_API.G_RET_STS_ERROR ;

1933: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1934: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1935: END IF;
1936: ROLLBACK TO Lock_BR_Assignment_PVT;
1937: x_return_status := FND_API.G_RET_STS_ERROR ;
1938: RAISE;
1939:
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941:

Line 1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1936: ROLLBACK TO Lock_BR_Assignment_PVT;
1937: x_return_status := FND_API.G_RET_STS_ERROR ;
1938: RAISE;
1939:
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941:
1942: IF PG_DEBUG in ('Y', 'C') THEN
1943: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1944: arp_util.debug ( 'SQLCODE : ' || SQLCODE);

Line 1947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1943: arp_util.debug ( 'SQLERRM : ' || SQLERRM);
1944: arp_util.debug ( 'SQLCODE : ' || SQLCODE);
1945: END IF;
1946: ROLLBACK TO Lock_BR_Assignment_PVT;
1947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1948: RAISE;
1949:
1950: WHEN OTHERS THEN
1951:

Line 1967: x_return_status := FND_API.G_RET_STS_ERROR ;

1963: ROLLBACK TO Lock_BR_Assignment_PVT;
1964:
1965: IF (SQLCODE = -20001)
1966: THEN
1967: x_return_status := FND_API.G_RET_STS_ERROR ;
1968: ELSE
1969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1970: END IF;
1971:

Line 1969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1965: IF (SQLCODE = -20001)
1966: THEN
1967: x_return_status := FND_API.G_RET_STS_ERROR ;
1968: ELSE
1969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1970: END IF;
1971:
1972: RAISE;
1973:

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

1986: PROCEDURE Create_BR_Trxn_Extension(
1987:
1988: -- ***** Standard API parameters *****
1989: p_api_version IN NUMBER ,
1990: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1991: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1992: x_return_status OUT NOCOPY VARCHAR2 ,
1993: x_msg_count OUT NOCOPY NUMBER ,
1994: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1987:
1988: -- ***** Standard API parameters *****
1989: p_api_version IN NUMBER ,
1990: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1991: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1992: x_return_status OUT NOCOPY VARCHAR2 ,
1993: x_msg_count OUT NOCOPY NUMBER ,
1994: x_msg_data OUT NOCOPY VARCHAR2 ,
1995:

Line 2015: x_return_status := FND_API.G_RET_STS_SUCCESS;

2011: Begin
2012: arp_standard.debug('AR_BILLS_CREATION_PUB.Create_BR_Trxn_Extension()+ ');
2013: x_msg_count := NULL;
2014: x_msg_data := NULL;
2015: x_return_status := FND_API.G_RET_STS_SUCCESS;
2016: l_payer_rec.party_id := arp_trx_defaults_3.get_party_Id(P_DRAWEE_ID);
2017: l_payer_rec.payment_function := 'CUSTOMER_PAYMENT';
2018: l_payer_rec.org_type := 'OPERATING_UNIT';
2019: l_payer_rec.cust_account_id := P_DRAWEE_ID;

Line 2048: IF x_return_status = fnd_api.g_ret_sts_success

2044: p_trxn_attribs => l_trxn_attribs_rec,
2045: x_entity_id => p_payment_trxn_extn_id,
2046: x_response => l_response);
2047:
2048: IF x_return_status = fnd_api.g_ret_sts_success
2049: THEN
2050: arp_standard.debug('Payment_Trxn_Extension_Id : ' || p_payment_trxn_extn_id);
2051: Else
2052: arp_standard.debug('Errors Reported by IBY API: ');

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

2071: PROCEDURE Update_BR_Trxn_Extension(
2072:
2073: -- ***** Standard API parameters *****
2074: p_api_version IN NUMBER ,
2075: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2076: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2077: x_return_status OUT NOCOPY VARCHAR2 ,
2078: x_msg_count OUT NOCOPY NUMBER ,
2079: x_msg_data OUT NOCOPY VARCHAR2 ,

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

2072:
2073: -- ***** Standard API parameters *****
2074: p_api_version IN NUMBER ,
2075: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2076: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2077: x_return_status OUT NOCOPY VARCHAR2 ,
2078: x_msg_count OUT NOCOPY NUMBER ,
2079: x_msg_data OUT NOCOPY VARCHAR2 ,
2080:

Line 2099: x_return_status := FND_API.G_RET_STS_SUCCESS;

2095: Begin
2096: arp_standard.debug('AR_BILLS_CREATION_PUB.Update_BR_Trxn_Extension()+ ');
2097: x_msg_count := NULL;
2098: x_msg_data := NULL;
2099: x_return_status := FND_API.G_RET_STS_SUCCESS;
2100: l_payer_rec.party_id := arp_trx_defaults_3.get_party_Id(P_DRAWEE_ID);
2101: l_payer_rec.payment_function := 'CUSTOMER_PAYMENT';
2102: l_payer_rec.org_type := 'OPERATING_UNIT';
2103: l_payer_rec.cust_account_id := P_DRAWEE_ID;

Line 2127: p_instr_assignment => nvl(p_instrument_assign_id,FND_API.G_MISS_NUM),

2123: x_msg_data => x_msg_data,
2124: p_payer => l_payer_rec,
2125: p_payer_equivalency => 'UPWARD',
2126: p_pmt_channel => l_payment_channel,
2127: p_instr_assignment => nvl(p_instrument_assign_id,FND_API.G_MISS_NUM),
2128: p_trxn_attribs => l_trxn_attribs_rec,
2129: p_entity_id => p_payment_trxn_extn_id,
2130: x_response => l_response);
2131:

Line 2132: IF x_return_status = fnd_api.g_ret_sts_success

2128: p_trxn_attribs => l_trxn_attribs_rec,
2129: p_entity_id => p_payment_trxn_extn_id,
2130: x_response => l_response);
2131:
2132: IF x_return_status = fnd_api.g_ret_sts_success
2133: THEN
2134: arp_standard.debug('Payment_Trxn_Extension_Id : ' || p_payment_trxn_extn_id);
2135: Else
2136: arp_standard.debug('Errors Reported by IBY API:Update Transaction Extension ');

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

2155: PROCEDURE Delete_BR_Trxn_Extension(
2156:
2157: -- ***** Standard API parameters *****
2158: p_api_version IN NUMBER ,
2159: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2160: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2161: x_return_status OUT NOCOPY VARCHAR2 ,
2162: x_msg_count OUT NOCOPY NUMBER ,
2163: x_msg_data OUT NOCOPY VARCHAR2 ,

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

2156:
2157: -- ***** Standard API parameters *****
2158: p_api_version IN NUMBER ,
2159: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
2160: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2161: x_return_status OUT NOCOPY VARCHAR2 ,
2162: x_msg_count OUT NOCOPY NUMBER ,
2163: x_msg_data OUT NOCOPY VARCHAR2 ,
2164:

Line 2183: x_return_status := FND_API.G_RET_STS_SUCCESS;

2179: Begin
2180: arp_standard.debug('AR_BILLS_CREATION_PUB.Delete_BR_Trxn_Extension()+ ');
2181: x_msg_count := NULL;
2182: x_msg_data := NULL;
2183: x_return_status := FND_API.G_RET_STS_SUCCESS;
2184: l_payer_rec.party_id := arp_trx_defaults_3.get_party_Id(P_DRAWEE_ID);
2185: l_payer_rec.payment_function := 'CUSTOMER_PAYMENT';
2186: l_payer_rec.org_type := 'OPERATING_UNIT';
2187: l_payer_rec.cust_account_id := P_DRAWEE_ID;

Line 2212: IF x_return_status = fnd_api.g_ret_sts_success

2208: p_payer_equivalency => 'UPWARD',
2209: p_entity_id => p_payment_trxn_extn_id,
2210: x_response => l_response);
2211:
2212: IF x_return_status = fnd_api.g_ret_sts_success
2213: THEN
2214: arp_standard.debug('Payment_Trxn_Extension_Id : ' || p_payment_trxn_extn_id);
2215: Else
2216: arp_standard.debug('Errors Reported by IBY API:Delete Transaction Extension ');