45: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
46:
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,
130: x_msg_count := NULL;
131: x_msg_data := NULL;
132:
133: /*-----------------------------------------------+
134: | Standard start of API savepoint |
135: +-----------------------------------------------*/
136:
137: SAVEPOINT Create_BR_Header_PVT;
138:
137: SAVEPOINT Create_BR_Header_PVT;
138:
139:
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 ,
253: p_status := l_trh_rec.status ;
254:
255:
256: /*-----------------------------------------------+
257: | Standard check of p_commit |
258: +-----------------------------------------------*/
259:
260: IF FND_API.To_Boolean( p_commit )
261: THEN
338:
339:
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,
409: x_msg_count := NULL;
410: x_msg_data := NULL;
411:
412: /*-----------------------------------------------+
413: | Standard start of API savepoint |
414: +-----------------------------------------------*/
415:
416: SAVEPOINT Update_BR_Header_PVT;
417:
416: SAVEPOINT Update_BR_Header_PVT;
417:
418:
419: /*-----------------------------------------------+
420: | Standard call to check for call compatibility |
421: +-----------------------------------------------*/
422:
423: IF NOT FND_API.Compatible_API_Call(
424: l_api_version ,
573:
574:
575:
576: /*-----------------------------------------------+
577: | Standard check of p_commit |
578: +-----------------------------------------------*/
579:
580: IF FND_API.To_Boolean( p_commit )
581: THEN
655: +==============================================================================*/
656:
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,
702: x_msg_count := NULL;
703: x_msg_data := NULL;
704:
705: /*-----------------------------------------------+
706: | Standard start of API savepoint |
707: +-----------------------------------------------*/
708:
709: SAVEPOINT Delete_BR_Header_PVT;
710:
709: SAVEPOINT Delete_BR_Header_PVT;
710:
711:
712: /*-----------------------------------------------+
713: | Standard call to check for call compatibility |
714: +-----------------------------------------------*/
715:
716: IF NOT FND_API.Compatible_API_Call(
717: l_api_version ,
793: ARP_PROCESS_BR_HEADER.delete_header (p_customer_trx_id);
794:
795:
796: /*-----------------------------------------------+
797: | Standard check of p_commit |
798: +-----------------------------------------------*/
799:
800: IF FND_API.To_Boolean( p_commit )
801: THEN
876:
877:
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,
943: x_msg_data := NULL;
944:
945:
946: /*-----------------------------------------------+
947: | Standard start of API savepoint |
948: +-----------------------------------------------*/
949:
950: SAVEPOINT Lock_BR_Header_PVT;
951:
950: SAVEPOINT Lock_BR_Header_PVT;
951:
952:
953: /*-----------------------------------------------+
954: | Standard call to check for call compatibility |
955: +-----------------------------------------------*/
956:
957: IF NOT FND_API.Compatible_API_Call(
958: l_api_version ,
1098:
1099:
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,
1158: x_msg_data := NULL;
1159:
1160:
1161: /*-----------------------------------------------+
1162: | Standard start of API savepoint |
1163: +-----------------------------------------------*/
1164:
1165: SAVEPOINT Create_BR_Assignment_PVT;
1166:
1164:
1165: SAVEPOINT Create_BR_Assignment_PVT;
1166:
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 ,
1316:
1317:
1318:
1319: /*-----------------------------------------------+
1320: | Standard check of p_commit |
1321: +-----------------------------------------------*/
1322:
1323: IF FND_API.To_Boolean( p_commit )
1324: THEN
1402:
1403:
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,
1456: x_msg_data := NULL;
1457:
1458:
1459: /*-----------------------------------------------+
1460: | Standard start of API savepoint |
1461: +-----------------------------------------------*/
1462:
1463: SAVEPOINT Update_BR_Assignment_PVT;
1464:
1463: SAVEPOINT Update_BR_Assignment_PVT;
1464:
1465:
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 ,
1554: ARP_PROCESS_BR_LINE.update_line (l_trl_rec.customer_trx_line_id, l_trl_rec);
1555:
1556:
1557: /*-----------------------------------------------+
1558: | Standard check of p_commit |
1559: +-----------------------------------------------*/
1560:
1561: IF FND_API.To_Boolean( p_commit )
1562: THEN
1632:
1633:
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,
1662: x_msg_count := NULL;
1663: x_msg_data := NULL;
1664:
1665: /*-----------------------------------------------+
1666: | Standard start of API savepoint |
1667: +-----------------------------------------------*/
1668:
1669: SAVEPOINT Delete_BR_Assignment_PVT;
1670:
1669: SAVEPOINT Delete_BR_Assignment_PVT;
1670:
1671:
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 ,
1721:
1722: ARP_PROCESS_BR_LINE.Delete_line (p_customer_trx_line_id, l_trl_rec.customer_trx_id);
1723:
1724: /*-----------------------------------------------+
1725: | Standard check of p_commit |
1726: +-----------------------------------------------*/
1727:
1728: IF FND_API.To_Boolean( p_commit )
1729: THEN
1804:
1805:
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,
1855: x_msg_data := NULL;
1856:
1857:
1858: /*-----------------------------------------------+
1859: | Standard start of API savepoint |
1860: +-----------------------------------------------*/
1861:
1862: SAVEPOINT Lock_BR_Assignment_PVT;
1863:
1862: SAVEPOINT Lock_BR_Assignment_PVT;
1863:
1864:
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 ,
1984: +==============================================================================*/
1985:
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 ,
2008: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
2009: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
2010: l_payment_channel ar_receipt_methods.payment_channel_code%type;
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);
2027:
2028: /*-------------------------+
2029: | Call the IBY API |
2030: +-------------------------*/
2031: arp_standard.debug('Call TO IBY API ()+ ');
2032:
2033: IBY_FNDCPT_TRXN_PUB.create_transaction_extension(
2034: p_api_version => 1.0,
2035: p_init_msg_list => p_init_msg_list,
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: ');
2053: END IF;
2054: EXCEPTION
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: ');
2053: END IF;
2054: EXCEPTION
2055: WHEN OTHERS THEN
2056: arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Create_BR_Trxn_Extension ');
2052: arp_standard.debug('Errors Reported by IBY API: ');
2053: END IF;
2054: EXCEPTION
2055: WHEN OTHERS THEN
2056: arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Create_BR_Trxn_Extension ');
2057: RAISE;
2058: END Create_BR_Trxn_Extension;
2059:
2060:
2069: +==============================================================================*/
2070:
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 ,
2092: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
2093: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
2094: l_payment_channel ar_receipt_methods.payment_channel_code%type;
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);
2111:
2112: /*-------------------------+
2113: | Call the IBY API |
2114: +-------------------------*/
2115: arp_standard.debug('Call TO IBY API ()+ ');
2116:
2117: IBY_FNDCPT_TRXN_PUB.update_transaction_extension(
2118: p_api_version => 1.0,
2119: p_init_msg_list => p_init_msg_list,
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 ');
2137: END IF;
2138: EXCEPTION
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 ');
2137: END IF;
2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Update_BR_Trxn_Extension ');
2136: arp_standard.debug('Errors Reported by IBY API:Update Transaction Extension ');
2137: END IF;
2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Update_BR_Trxn_Extension ');
2141: RAISE;
2142: END Update_BR_Trxn_Extension;
2143:
2144:
2153: +==============================================================================*/
2154:
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 ,
2176: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.trxnextension_rec_type;
2177: l_response IBY_FNDCPT_COMMON_PUB.result_rec_type;
2178: l_payment_channel ar_receipt_methods.payment_channel_code%type;
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);
2190:
2191: /*-------------------------+
2192: | Call the IBY API |
2193: +-------------------------*/
2194: arp_standard.debug('Call TO IBY API ()+ ');
2195:
2196: IBY_FNDCPT_TRXN_PUB.delete_transaction_extension(
2197: p_api_version => 1.0,
2198: p_init_msg_list => p_init_msg_list,
2206: x_response => l_response);
2207:
2208: IF x_return_status = fnd_api.g_ret_sts_success
2209: THEN
2210: arp_standard.debug('Payment_Trxn_Extension_Id : ' || p_payment_trxn_extn_id);
2211: Else
2212: arp_standard.debug('Errors Reported by IBY API:Delete Transaction Extension ');
2213: END IF;
2214: EXCEPTION
2208: IF x_return_status = fnd_api.g_ret_sts_success
2209: THEN
2210: arp_standard.debug('Payment_Trxn_Extension_Id : ' || p_payment_trxn_extn_id);
2211: Else
2212: arp_standard.debug('Errors Reported by IBY API:Delete Transaction Extension ');
2213: END IF;
2214: EXCEPTION
2215: WHEN OTHERS THEN
2216: arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Delete_BR_Trxn_Extension ');
2212: arp_standard.debug('Errors Reported by IBY API:Delete Transaction Extension ');
2213: END IF;
2214: EXCEPTION
2215: WHEN OTHERS THEN
2216: arp_standard.debug('exception in AR_BILLS_CREATION_PUB.Delete_BR_Trxn_Extension ');
2217: RAISE;
2218: END Delete_BR_Trxn_Extension;
2219:
2220: