DBA Data[Home] [Help]

APPS.ASO_PAYMENT_INT dependencies on ASO_UTILITY_PVT

Line 97: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );

93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: x_payment_rec := l_payment_rec;
96:
97: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
98:
99: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
100: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
101: END IF;

Line 100: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );

96:
97: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
98:
99: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
100: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
101: END IF;
102:
103:
104:

Line 213: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

209: END IF;
210:
211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
217: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 217: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

213: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
214: P_API_NAME => L_API_NAME
215: ,P_PKG_NAME => G_PKG_NAME
216: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
217: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
218: ,X_MSG_COUNT => X_MSG_COUNT
219: ,X_MSG_DATA => X_MSG_DATA
220: ,X_RETURN_STATUS => X_RETURN_STATUS);
221:

Line 223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

219: ,X_MSG_DATA => X_MSG_DATA
220: ,X_RETURN_STATUS => X_RETURN_STATUS);
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
224: P_API_NAME => L_API_NAME
225: ,P_PKG_NAME => G_PKG_NAME
226: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
227: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 227: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

223: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
224: P_API_NAME => L_API_NAME
225: ,P_PKG_NAME => G_PKG_NAME
226: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
227: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
228: ,X_MSG_COUNT => X_MSG_COUNT
229: ,X_MSG_DATA => X_MSG_DATA
230: ,X_RETURN_STATUS => X_RETURN_STATUS);
231:

Line 233: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

229: ,X_MSG_DATA => X_MSG_DATA
230: ,X_RETURN_STATUS => X_RETURN_STATUS);
231:
232: WHEN OTHERS THEN
233: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
234: P_API_NAME => L_API_NAME
235: ,P_PKG_NAME => G_PKG_NAME
236: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
237: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 236: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

232: WHEN OTHERS THEN
233: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
234: P_API_NAME => L_API_NAME
235: ,P_PKG_NAME => G_PKG_NAME
236: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
237: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
238: ,X_MSG_COUNT => X_MSG_COUNT
239: ,X_MSG_DATA => X_MSG_DATA
240: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 237: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

233: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
234: P_API_NAME => L_API_NAME
235: ,P_PKG_NAME => G_PKG_NAME
236: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
237: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
238: ,X_MSG_COUNT => X_MSG_COUNT
239: ,X_MSG_DATA => X_MSG_DATA
240: ,X_RETURN_STATUS => X_RETURN_STATUS);
241: End create_iby_payment;

Line 338: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );

334: close c_get_db_hdr_payment;
335: END IF;
336:
337:
338: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
339:
340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
341: aso_debug_pub.add('After querying the header row', 1, 'Y');
342: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');

Line 346: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );

342: aso_debug_pub.add('l_qte_header_rec.quote_header_id: ' || l_qte_header_rec.quote_header_id, 1, 'Y');
343: END IF;
344:
345: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
346: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
347: END IF;
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('After querying the line row', 1, 'Y');

Line 633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

629: END IF;
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
634: P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
637: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 637: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
634: P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
637: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
638: ,X_MSG_COUNT => X_MSG_COUNT
639: ,X_MSG_DATA => X_MSG_DATA
640: ,X_RETURN_STATUS => X_RETURN_STATUS);
641:

Line 643: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

639: ,X_MSG_DATA => X_MSG_DATA
640: ,X_RETURN_STATUS => X_RETURN_STATUS);
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
647: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 647: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

643: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
647: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
648: ,X_MSG_COUNT => X_MSG_COUNT
649: ,X_MSG_DATA => X_MSG_DATA
650: ,X_RETURN_STATUS => X_RETURN_STATUS);
651:

Line 653: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

649: ,X_MSG_DATA => X_MSG_DATA
650: ,X_RETURN_STATUS => X_RETURN_STATUS);
651:
652: WHEN OTHERS THEN
653: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
654: P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
657: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 656: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

652: WHEN OTHERS THEN
653: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
654: P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
657: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 657: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

653: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
654: P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
657: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);
661: End create_payment_row;

Line 758: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );

754:
755:
756:
757: -- Start API Body
758: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
759:
760: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
761: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
762: END IF;

Line 761: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );

757: -- Start API Body
758: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
759:
760: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
761: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
762: END IF;
763:
764: --Get the databse payment record and assign it to l_db_payment_rec
765: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then

Line 768: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);

764: --Get the databse payment record and assign it to l_db_payment_rec
765: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then
766: l_payment_rec.quote_line_id := null;
767: END IF;
768: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);
769: l_db_payment_rec := l_payment_tbl(1);
770:
771: /*** Start : Code Added for Bug 8712439 for HTML Quoting PA-DSS update issue ***/
772:

Line 1553: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN FND_API.G_EXC_ERROR THEN
1553: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1554: P_API_NAME => L_API_NAME
1555: ,P_PKG_NAME => G_PKG_NAME
1556: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1557: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1557: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1553: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1554: P_API_NAME => L_API_NAME
1555: ,P_PKG_NAME => G_PKG_NAME
1556: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1557: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1558: ,X_MSG_COUNT => X_MSG_COUNT
1559: ,X_MSG_DATA => X_MSG_DATA
1560: ,X_RETURN_STATUS => X_RETURN_STATUS);
1561:

Line 1563: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1559: ,X_MSG_DATA => X_MSG_DATA
1560: ,X_RETURN_STATUS => X_RETURN_STATUS);
1561:
1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1564: P_API_NAME => L_API_NAME
1565: ,P_PKG_NAME => G_PKG_NAME
1566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1567: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1567: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1563: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1564: P_API_NAME => L_API_NAME
1565: ,P_PKG_NAME => G_PKG_NAME
1566: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1567: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1568: ,X_MSG_COUNT => X_MSG_COUNT
1569: ,X_MSG_DATA => X_MSG_DATA
1570: ,X_RETURN_STATUS => X_RETURN_STATUS);
1571:

Line 1573: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1569: ,X_MSG_DATA => X_MSG_DATA
1570: ,X_RETURN_STATUS => X_RETURN_STATUS);
1571:
1572: WHEN OTHERS THEN
1573: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1574: P_API_NAME => L_API_NAME
1575: ,P_PKG_NAME => G_PKG_NAME
1576: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1577: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1576: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1572: WHEN OTHERS THEN
1573: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1574: P_API_NAME => L_API_NAME
1575: ,P_PKG_NAME => G_PKG_NAME
1576: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1577: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1578: ,X_MSG_COUNT => X_MSG_COUNT
1579: ,X_MSG_DATA => X_MSG_DATA
1580: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1577: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1573: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1574: P_API_NAME => L_API_NAME
1575: ,P_PKG_NAME => G_PKG_NAME
1576: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1577: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1578: ,X_MSG_COUNT => X_MSG_COUNT
1579: ,X_MSG_DATA => X_MSG_DATA
1580: ,X_RETURN_STATUS => X_RETURN_STATUS);
1581: end update_payment_row;

Line 1616: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );

1612: END IF;
1613:
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
1617:
1618: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1619: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
1620: END IF;

Line 1619: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );

1615:
1616: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
1617:
1618: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
1619: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
1620: END IF;
1621:
1622: --Get the databse payment record and assign it to l_payment_rec
1623: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then

Line 1627: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);

1623: IF ( l_payment_rec.Quote_Line_Id = fnd_api.g_miss_num) then
1624: l_payment_rec.quote_line_id := null;
1625: END IF;
1626:
1627: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(l_payment_rec.quote_header_id,l_payment_rec.quote_line_id);
1628: l_payment_rec := l_payment_tbl(1);
1629:
1630: if l_payment_tbl.count > 0 and l_payment_rec.payment_type_code = 'CREDIT_CARD' then
1631:

Line 1707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1703: END IF;
1704:
1705: EXCEPTION
1706: WHEN FND_API.G_EXC_ERROR THEN
1707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1708: P_API_NAME => L_API_NAME
1709: ,P_PKG_NAME => G_PKG_NAME
1710: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1708: P_API_NAME => L_API_NAME
1709: ,P_PKG_NAME => G_PKG_NAME
1710: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1712: ,X_MSG_COUNT => X_MSG_COUNT
1713: ,X_MSG_DATA => X_MSG_DATA
1714: ,X_RETURN_STATUS => X_RETURN_STATUS);
1715:

Line 1717: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1713: ,X_MSG_DATA => X_MSG_DATA
1714: ,X_RETURN_STATUS => X_RETURN_STATUS);
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1718: P_API_NAME => L_API_NAME
1719: ,P_PKG_NAME => G_PKG_NAME
1720: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1721: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1721: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1717: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1718: P_API_NAME => L_API_NAME
1719: ,P_PKG_NAME => G_PKG_NAME
1720: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1721: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1722: ,X_MSG_COUNT => X_MSG_COUNT
1723: ,X_MSG_DATA => X_MSG_DATA
1724: ,X_RETURN_STATUS => X_RETURN_STATUS);
1725:

Line 1727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1723: ,X_MSG_DATA => X_MSG_DATA
1724: ,X_RETURN_STATUS => X_RETURN_STATUS);
1725:
1726: WHEN OTHERS THEN
1727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1728: P_API_NAME => L_API_NAME
1729: ,P_PKG_NAME => G_PKG_NAME
1730: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1730: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1726: WHEN OTHERS THEN
1727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1728: P_API_NAME => L_API_NAME
1729: ,P_PKG_NAME => G_PKG_NAME
1730: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1732: ,X_MSG_COUNT => X_MSG_COUNT
1733: ,X_MSG_DATA => X_MSG_DATA
1734: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1728: P_API_NAME => L_API_NAME
1729: ,P_PKG_NAME => G_PKG_NAME
1730: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1732: ,X_MSG_COUNT => X_MSG_COUNT
1733: ,X_MSG_DATA => X_MSG_DATA
1734: ,X_RETURN_STATUS => X_RETURN_STATUS);
1735: End delete_payment_row;