DBA Data[Home] [Help]

APPS.OKL_CREDIT_CHECKLIST_PVT dependencies on FND_MSG_PUB

Line 784: FND_MSG_PUB.initialize;

780: END IF;
781:
782: -- Initialize message list if requested
783: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
784: FND_MSG_PUB.initialize;
785: END IF;
786:
787: -- Initialize API status to success
788: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 880: FND_MSG_PUB.Count_And_Get

876:
877: /*** End API body ******************************************************/
878:
879: -- Get message count and if count is 1, get message info
880: FND_MSG_PUB.Count_And_Get
881: (p_count => x_msg_count,
882: p_data => x_msg_data);
883:
884: EXCEPTION

Line 888: FND_MSG_PUB.Count_And_Get

884: EXCEPTION
885: WHEN OKL_API.G_EXCEPTION_ERROR THEN
886: ROLLBACK TO copy_rulv_rec;
887: x_return_status := OKL_API.G_RET_STS_ERROR;
888: FND_MSG_PUB.Count_And_Get
889: (p_count => x_msg_count,
890: p_data => x_msg_data);
891:
892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 895: FND_MSG_PUB.Count_And_Get

891:
892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
893: ROLLBACK TO copy_rulv_rec;
894: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
895: FND_MSG_PUB.Count_And_Get
896: (p_count => x_msg_count,
897: p_data => x_msg_data);
898:
899: WHEN OTHERS THEN

Line 908: FND_MSG_PUB.Count_And_Get

904: p_token1 => G_SQLCODE_TOKEN,
905: p_token1_value => SQLCODE,
906: p_token2 => G_SQLERRM_TOKEN,
907: p_token2_value => SQLERRM);
908: FND_MSG_PUB.Count_And_Get
909: (p_count => x_msg_count,
910: p_data => x_msg_data);
911: end;
912: ----------------------------------------------------------------------------------

Line 953: FND_MSG_PUB.initialize;

949: END IF;
950:
951: -- Initialize message list if requested
952: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
953: FND_MSG_PUB.initialize;
954: END IF;
955:
956: -- Initialize API status to success
957: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 991: FND_MSG_PUB.Count_And_Get

987:
988: /*** End API body ******************************************************/
989:
990: -- Get message count and if count is 1, get message info
991: FND_MSG_PUB.Count_And_Get
992: (p_count => x_msg_count,
993: p_data => x_msg_data);
994:
995: EXCEPTION

Line 999: FND_MSG_PUB.Count_And_Get

995: EXCEPTION
996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
997: ROLLBACK TO copy_rulv_tbl;
998: x_return_status := OKL_API.G_RET_STS_ERROR;
999: FND_MSG_PUB.Count_And_Get
1000: (p_count => x_msg_count,
1001: p_data => x_msg_data);
1002:
1003: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1006: FND_MSG_PUB.Count_And_Get

1002:
1003: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1004: ROLLBACK TO copy_rulv_tbl;
1005: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1006: FND_MSG_PUB.Count_And_Get
1007: (p_count => x_msg_count,
1008: p_data => x_msg_data);
1009:
1010: WHEN OTHERS THEN

Line 1019: FND_MSG_PUB.Count_And_Get

1015: p_token1 => G_SQLCODE_TOKEN,
1016: p_token1_value => SQLCODE,
1017: p_token2 => G_SQLERRM_TOKEN,
1018: p_token2_value => SQLERRM);
1019: FND_MSG_PUB.Count_And_Get
1020: (p_count => x_msg_count,
1021: p_data => x_msg_data);
1022: end;
1023:

Line 1069: FND_MSG_PUB.initialize;

1065: END IF;
1066:
1067: -- Initialize message list if requested
1068: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1069: FND_MSG_PUB.initialize;
1070: END IF;
1071:
1072: -- Initialize API status to success
1073: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1132: FND_MSG_PUB.Count_And_Get

1128:
1129: /*** End API body ******************************************************/
1130:
1131: -- Get message count and if count is 1, get message info
1132: FND_MSG_PUB.Count_And_Get
1133: (p_count => x_msg_count,
1134: p_data => x_msg_data);
1135:
1136: EXCEPTION

Line 1140: FND_MSG_PUB.Count_And_Get

1136: EXCEPTION
1137: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1138: ROLLBACK TO create_credit_chklst;
1139: x_return_status := OKL_API.G_RET_STS_ERROR;
1140: FND_MSG_PUB.Count_And_Get
1141: (p_count => x_msg_count,
1142: p_data => x_msg_data);
1143:
1144: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1147: FND_MSG_PUB.Count_And_Get

1143:
1144: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1145: ROLLBACK TO create_credit_chklst;
1146: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1147: FND_MSG_PUB.Count_And_Get
1148: (p_count => x_msg_count,
1149: p_data => x_msg_data);
1150:
1151: WHEN OTHERS THEN

Line 1160: FND_MSG_PUB.Count_And_Get

1156: p_token1 => G_SQLCODE_TOKEN,
1157: p_token1_value => SQLCODE,
1158: p_token2 => G_SQLERRM_TOKEN,
1159: p_token2_value => SQLERRM);
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count,
1162: p_data => x_msg_data);
1163:
1164: end create_credit_chklst;

Line 1211: FND_MSG_PUB.initialize;

1207: END IF;
1208:
1209: -- Initialize message list if requested
1210: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1211: FND_MSG_PUB.initialize;
1212: END IF;
1213:
1214: -- Initialize API status to success
1215: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1275: FND_MSG_PUB.Count_And_Get

1271:
1272: /*** End API body ******************************************************/
1273:
1274: -- Get message count and if count is 1, get message info
1275: FND_MSG_PUB.Count_And_Get
1276: (p_count => x_msg_count,
1277: p_data => x_msg_data);
1278:
1279: EXCEPTION

Line 1283: FND_MSG_PUB.Count_And_Get

1279: EXCEPTION
1280: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1281: ROLLBACK TO update_credit_chklst;
1282: x_return_status := OKL_API.G_RET_STS_ERROR;
1283: FND_MSG_PUB.Count_And_Get
1284: (p_count => x_msg_count,
1285: p_data => x_msg_data);
1286:
1287: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1290: FND_MSG_PUB.Count_And_Get

1286:
1287: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1288: ROLLBACK TO update_credit_chklst;
1289: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1290: FND_MSG_PUB.Count_And_Get
1291: (p_count => x_msg_count,
1292: p_data => x_msg_data);
1293:
1294: WHEN OTHERS THEN

Line 1303: FND_MSG_PUB.Count_And_Get

1299: p_token1 => G_SQLCODE_TOKEN,
1300: p_token1_value => SQLCODE,
1301: p_token2 => G_SQLERRM_TOKEN,
1302: p_token2_value => SQLERRM);
1303: FND_MSG_PUB.Count_And_Get
1304: (p_count => x_msg_count,
1305: p_data => x_msg_data);
1306:
1307: end update_credit_chklst;

Line 1353: FND_MSG_PUB.initialize;

1349: END IF;
1350:
1351: -- Initialize message list if requested
1352: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1353: FND_MSG_PUB.initialize;
1354: END IF;
1355:
1356: -- Initialize API status to success
1357: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1400: FND_MSG_PUB.Count_And_Get

1396:
1397: /*** End API body ******************************************************/
1398:
1399: -- Get message count and if count is 1, get message info
1400: FND_MSG_PUB.Count_And_Get
1401: (p_count => x_msg_count,
1402: p_data => x_msg_data);
1403:
1404: EXCEPTION

Line 1408: FND_MSG_PUB.Count_And_Get

1404: EXCEPTION
1405: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1406: ROLLBACK TO delete_credit_chklst;
1407: x_return_status := OKL_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get
1409: (p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1415: FND_MSG_PUB.Count_And_Get

1411:
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1413: ROLLBACK TO delete_credit_chklst;
1414: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1415: FND_MSG_PUB.Count_And_Get
1416: (p_count => x_msg_count,
1417: p_data => x_msg_data);
1418:
1419: WHEN OTHERS THEN

Line 1428: FND_MSG_PUB.Count_And_Get

1424: p_token1 => G_SQLCODE_TOKEN,
1425: p_token1_value => SQLCODE,
1426: p_token2 => G_SQLERRM_TOKEN,
1427: p_token2_value => SQLERRM);
1428: FND_MSG_PUB.Count_And_Get
1429: (p_count => x_msg_count,
1430: p_data => x_msg_data);
1431:
1432: end delete_credit_chklst;

Line 1486: FND_MSG_PUB.initialize;

1482: END IF;
1483:
1484: -- Initialize message list if requested
1485: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1486: FND_MSG_PUB.initialize;
1487: END IF;
1488:
1489: -- Initialize API status to success
1490: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1528: FND_MSG_PUB.Count_And_Get

1524:
1525: /*** End API body ******************************************************/
1526:
1527: -- Get message count and if count is 1, get message info
1528: FND_MSG_PUB.Count_And_Get
1529: (p_count => x_msg_count,
1530: p_data => x_msg_data);
1531:
1532: EXCEPTION

Line 1536: FND_MSG_PUB.Count_And_Get

1532: EXCEPTION
1533: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1534: ROLLBACK TO approve_credit_chklst;
1535: x_return_status := OKL_API.G_RET_STS_ERROR;
1536: FND_MSG_PUB.Count_And_Get
1537: (p_count => x_msg_count,
1538: p_data => x_msg_data);
1539:
1540: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1543: FND_MSG_PUB.Count_And_Get

1539:
1540: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1541: ROLLBACK TO approve_credit_chklst;
1542: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1543: FND_MSG_PUB.Count_And_Get
1544: (p_count => x_msg_count,
1545: p_data => x_msg_data);
1546:
1547: WHEN OTHERS THEN

Line 1556: FND_MSG_PUB.Count_And_Get

1552: p_token1 => G_SQLCODE_TOKEN,
1553: p_token1_value => SQLCODE,
1554: p_token2 => G_SQLERRM_TOKEN,
1555: p_token2_value => SQLERRM);
1556: FND_MSG_PUB.Count_And_Get
1557: (p_count => x_msg_count,
1558: p_data => x_msg_data);
1559:
1560: end approve_credit_chklst;

Line 1606: FND_MSG_PUB.initialize;

1602: END IF;
1603:
1604: -- Initialize message list if requested
1605: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1606: FND_MSG_PUB.initialize;
1607: END IF;
1608:
1609: -- Initialize API status to success
1610: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1617: FND_MSG_PUB.Count_And_Get

1613: /*** Begin API body ****************************************************/
1614: /*** End API body ******************************************************/
1615:
1616: -- Get message count and if count is 1, get message info
1617: FND_MSG_PUB.Count_And_Get
1618: (p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: EXCEPTION

Line 1625: FND_MSG_PUB.Count_And_Get

1621: EXCEPTION
1622: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1623: ROLLBACK TO update_fund_chklst_tpl_hdr;
1624: x_return_status := OKL_API.G_RET_STS_ERROR;
1625: FND_MSG_PUB.Count_And_Get
1626: (p_count => x_msg_count,
1627: p_data => x_msg_data);
1628:
1629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1632: FND_MSG_PUB.Count_And_Get

1628:
1629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1630: ROLLBACK TO update_fund_chklst_tpl_hdr;
1631: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1632: FND_MSG_PUB.Count_And_Get
1633: (p_count => x_msg_count,
1634: p_data => x_msg_data);
1635:
1636: WHEN OTHERS THEN

Line 1645: FND_MSG_PUB.Count_And_Get

1641: p_token1 => G_SQLCODE_TOKEN,
1642: p_token1_value => SQLCODE,
1643: p_token2 => G_SQLERRM_TOKEN,
1644: p_token2_value => SQLERRM);
1645: FND_MSG_PUB.Count_And_Get
1646: (p_count => x_msg_count,
1647: p_data => x_msg_data);
1648:
1649: end update_fund_chklst_tpl_hdr;

Line 1696: FND_MSG_PUB.initialize;

1692: END IF;
1693:
1694: -- Initialize message list if requested
1695: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1696: FND_MSG_PUB.initialize;
1697: END IF;
1698:
1699: -- Initialize API status to success
1700: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1779: FND_MSG_PUB.Count_And_Get

1775:
1776: /*** End API body ******************************************************/
1777:
1778: -- Get message count and if count is 1, get message info
1779: FND_MSG_PUB.Count_And_Get
1780: (p_count => x_msg_count,
1781: p_data => x_msg_data);
1782:
1783: EXCEPTION

Line 1787: FND_MSG_PUB.Count_And_Get

1783: EXCEPTION
1784: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1785: ROLLBACK TO update_fund_chklst_tpl_hdr;
1786: x_return_status := OKL_API.G_RET_STS_ERROR;
1787: FND_MSG_PUB.Count_And_Get
1788: (p_count => x_msg_count,
1789: p_data => x_msg_data);
1790:
1791: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1794: FND_MSG_PUB.Count_And_Get

1790:
1791: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1792: ROLLBACK TO update_fund_chklst_tpl_hdr;
1793: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MSG_PUB.Count_And_Get
1795: (p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:
1798: WHEN OTHERS THEN

Line 1807: FND_MSG_PUB.Count_And_Get

1803: p_token1 => G_SQLCODE_TOKEN,
1804: p_token1_value => SQLCODE,
1805: p_token2 => G_SQLERRM_TOKEN,
1806: p_token2_value => SQLERRM);
1807: FND_MSG_PUB.Count_And_Get
1808: (p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: end update_fund_chklst_tpl_hdr;

Line 1858: FND_MSG_PUB.initialize;

1854: END IF;
1855:
1856: -- Initialize message list if requested
1857: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
1858: FND_MSG_PUB.initialize;
1859: END IF;
1860:
1861: -- Initialize API status to success
1862: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1922: FND_MSG_PUB.Count_And_Get

1918:
1919: /*** End API body ******************************************************/
1920:
1921: -- Get message count and if count is 1, get message info
1922: FND_MSG_PUB.Count_And_Get
1923: (p_count => x_msg_count,
1924: p_data => x_msg_data);
1925:
1926: EXCEPTION

Line 1930: FND_MSG_PUB.Count_And_Get

1926: EXCEPTION
1927: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1928: ROLLBACK TO update_funding_chklst_tpl;
1929: x_return_status := OKL_API.G_RET_STS_ERROR;
1930: FND_MSG_PUB.Count_And_Get
1931: (p_count => x_msg_count,
1932: p_data => x_msg_data);
1933:
1934: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1937: FND_MSG_PUB.Count_And_Get

1933:
1934: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1935: ROLLBACK TO update_funding_chklst_tpl;
1936: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1937: FND_MSG_PUB.Count_And_Get
1938: (p_count => x_msg_count,
1939: p_data => x_msg_data);
1940:
1941: WHEN OTHERS THEN

Line 1950: FND_MSG_PUB.Count_And_Get

1946: p_token1 => G_SQLCODE_TOKEN,
1947: p_token1_value => SQLCODE,
1948: p_token2 => G_SQLERRM_TOKEN,
1949: p_token2_value => SQLERRM);
1950: FND_MSG_PUB.Count_And_Get
1951: (p_count => x_msg_count,
1952: p_data => x_msg_data);
1953:
1954: end update_funding_chklst_tpl;

Line 2009: FND_MSG_PUB.initialize;

2005: END IF;
2006:
2007: -- Initialize message list if requested
2008: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2009: FND_MSG_PUB.initialize;
2010: END IF;
2011:
2012: -- Initialize API status to success
2013: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2044: FND_MSG_PUB.Count_And_Get

2040:
2041: /*** End API body ******************************************************/
2042:
2043: -- Get message count and if count is 1, get message info
2044: FND_MSG_PUB.Count_And_Get
2045: (p_count => x_msg_count,
2046: p_data => x_msg_data);
2047:
2048: EXCEPTION

Line 2052: FND_MSG_PUB.Count_And_Get

2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: ROLLBACK TO approve_funding_chklst_tpl;
2051: x_return_status := OKL_API.G_RET_STS_ERROR;
2052: FND_MSG_PUB.Count_And_Get
2053: (p_count => x_msg_count,
2054: p_data => x_msg_data);
2055:
2056: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2059: FND_MSG_PUB.Count_And_Get

2055:
2056: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2057: ROLLBACK TO approve_funding_chklst_tpl;
2058: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2059: FND_MSG_PUB.Count_And_Get
2060: (p_count => x_msg_count,
2061: p_data => x_msg_data);
2062:
2063: WHEN OTHERS THEN

Line 2072: FND_MSG_PUB.Count_And_Get

2068: p_token1 => G_SQLCODE_TOKEN,
2069: p_token1_value => SQLCODE,
2070: p_token2 => G_SQLERRM_TOKEN,
2071: p_token2_value => SQLERRM);
2072: FND_MSG_PUB.Count_And_Get
2073: (p_count => x_msg_count,
2074: p_data => x_msg_data);
2075:
2076: end approve_funding_chklst_tpl;

Line 2124: FND_MSG_PUB.initialize;

2120: END IF;
2121:
2122: -- Initialize message list if requested
2123: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2124: FND_MSG_PUB.initialize;
2125: END IF;
2126:
2127: -- Initialize API status to success
2128: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2187: FND_MSG_PUB.Count_And_Get

2183:
2184: /*** End API body ******************************************************/
2185:
2186: -- Get message count and if count is 1, get message info
2187: FND_MSG_PUB.Count_And_Get
2188: (p_count => x_msg_count,
2189: p_data => x_msg_data);
2190:
2191: EXCEPTION

Line 2195: FND_MSG_PUB.Count_And_Get

2191: EXCEPTION
2192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2193: ROLLBACK TO create_funding_chklst_tpl;
2194: x_return_status := OKL_API.G_RET_STS_ERROR;
2195: FND_MSG_PUB.Count_And_Get
2196: (p_count => x_msg_count,
2197: p_data => x_msg_data);
2198:
2199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2202: FND_MSG_PUB.Count_And_Get

2198:
2199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2200: ROLLBACK TO create_funding_chklst_tpl;
2201: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2202: FND_MSG_PUB.Count_And_Get
2203: (p_count => x_msg_count,
2204: p_data => x_msg_data);
2205:
2206: WHEN OTHERS THEN

Line 2215: FND_MSG_PUB.Count_And_Get

2211: p_token1 => G_SQLCODE_TOKEN,
2212: p_token1_value => SQLCODE,
2213: p_token2 => G_SQLERRM_TOKEN,
2214: p_token2_value => SQLERRM);
2215: FND_MSG_PUB.Count_And_Get
2216: (p_count => x_msg_count,
2217: p_data => x_msg_data);
2218:
2219: end create_funding_chklst_tpl;

Line 2265: FND_MSG_PUB.initialize;

2261: END IF;
2262:
2263: -- Initialize message list if requested
2264: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2265: FND_MSG_PUB.initialize;
2266: END IF;
2267:
2268: -- Initialize API status to success
2269: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2311: FND_MSG_PUB.Count_And_Get

2307:
2308: /*** End API body ******************************************************/
2309:
2310: -- Get message count and if count is 1, get message info
2311: FND_MSG_PUB.Count_And_Get
2312: (p_count => x_msg_count,
2313: p_data => x_msg_data);
2314:
2315: EXCEPTION

Line 2319: FND_MSG_PUB.Count_And_Get

2315: EXCEPTION
2316: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2317: ROLLBACK TO delete_funding_chklst_tpl;
2318: x_return_status := OKL_API.G_RET_STS_ERROR;
2319: FND_MSG_PUB.Count_And_Get
2320: (p_count => x_msg_count,
2321: p_data => x_msg_data);
2322:
2323: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2326: FND_MSG_PUB.Count_And_Get

2322:
2323: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2324: ROLLBACK TO delete_funding_chklst_tpl;
2325: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2326: FND_MSG_PUB.Count_And_Get
2327: (p_count => x_msg_count,
2328: p_data => x_msg_data);
2329:
2330: WHEN OTHERS THEN

Line 2339: FND_MSG_PUB.Count_And_Get

2335: p_token1 => G_SQLCODE_TOKEN,
2336: p_token1_value => SQLCODE,
2337: p_token2 => G_SQLERRM_TOKEN,
2338: p_token2_value => SQLERRM);
2339: FND_MSG_PUB.Count_And_Get
2340: (p_count => x_msg_count,
2341: p_data => x_msg_data);
2342:
2343: end delete_funding_chklst_tpl;