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.OKC_ARTICLES_GRP dependencies on OKC_DEBUG

Line 235: okc_debug.log('100: In find variables : variable_name ' || p_extracted_var_name

231: end if;
232: if p_extracted_var_name is not null
233: then
234: --dbms_output.put_line(' l_extracted_var_name '|| p_extracted_var_name) ;
235: okc_debug.log('100: In find variables : variable_name ' || p_extracted_var_name
236: || ' intent = ' || p_intent
237: || ' language = ' || p_language , 2);
238: OPEN get_variable_metadata_csr (p_intent,
239: p_language,

Line 370: okc_debug.log('100: Entering parse_n_replace_text', 2);

366: l_return_status Varchar2(1) := null;
367: l_invalid_var_intent Varchar2(1) := null;
368:
369: BEGIN
370: okc_debug.log('100: Entering parse_n_replace_text', 2);
371: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);
372: l_amount_left_to_read := l_article_text_length;
373: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
374:

Line 542: okc_debug.log('100: Leaving parse_n_replace_text', 2);

538: end if;
539:
540: --dbms_lob.freetemporary(l_clob);
541: --dbms_lob.freetemporary(p_dest_clob);
542: okc_debug.log('100: Leaving parse_n_replace_text', 2);
543: EXCEPTION
544: WHEN G_VAR_NOT_FOUND then
545: --dbms_output.put_line(' VAR NOT FOUND 1 ');
546: x_return_status := G_VAR_NOT_FOUND_RET_STS;

Line 779: okc_debug.log('2400: Leaving get article number: OKC_API.G_EXCEPTION_ERROR Exception', 2);

775: END IF;
776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: IF (l_debug = 'Y') THEN
779: okc_debug.log('2400: Leaving get article number: OKC_API.G_EXCEPTION_ERROR Exception', 2);
780: --dbms_output.put_line('2400: Leaving get article number: OKC_API.G_EXCEPTION_ERROR Exception');
781: END IF;
782: x_return_status := G_RET_STS_ERROR ;
783: WHEN OTHERS THEN

Line 831: okc_debug.log('2200: Entered delete_article_version', 2);

827:
828: BEGIN
829:
830: IF (l_debug = 'Y') THEN
831: okc_debug.log('2200: Entered delete_article_version', 2);
832: END IF;
833: -- MOAC
834: G_CURRENT_ORG_ID := mo_global.get_current_org_id() ;
835: /*

Line 922: okc_debug.log('2300: Leaving delete_article_version', 2);

918: -- Standard call to get message count and if count is 1, get message info.
919: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
920:
921: IF (l_debug = 'Y') THEN
922: okc_debug.log('2300: Leaving delete_article_version', 2);
923: END IF;
924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN

Line 928: okc_debug.log('2400: Leaving delete_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);

924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: IF (l_debug = 'Y') THEN
928: okc_debug.log('2400: Leaving delete_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
929: END IF;
930: ROLLBACK TO g_delete_article_version_GRP;
931: x_return_status := G_RET_STS_ERROR ;
932: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 936: okc_debug.log('2500: Leaving delete_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

932: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
933:
934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
935: IF (l_debug = 'Y') THEN
936: okc_debug.log('2500: Leaving delete_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
937: END IF;
938: ROLLBACK TO g_delete_article_version_GRP;
939: x_return_status := G_RET_STS_UNEXP_ERROR ;
940: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 944: okc_debug.log('2600: Leaving delete_article_version because of EXCEPTION: '||sqlerrm, 2);

940: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
941:
942: WHEN OTHERS THEN
943: IF (l_debug = 'Y') THEN
944: okc_debug.log('2600: Leaving delete_article_version because of EXCEPTION: '||sqlerrm, 2);
945: END IF;
946:
947: ROLLBACK TO g_delete_article_version_GRP;
948: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1028: okc_debug.log('100: Entered validate_article', 2);

1024:
1025: BEGIN
1026:
1027: IF (l_debug = 'Y') THEN
1028: okc_debug.log('100: Entered validate_article', 2);
1029: END IF;
1030:
1031: -- Standard Start of API savepoint
1032: SAVEPOINT g_validate_article_GRP;

Line 1141: okc_debug.log('200: Leaving validate_article', 2);

1137: -- Standard call to get message count and if count is 1, get message info.
1138: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1139:
1140: IF (l_debug = 'Y') THEN
1141: okc_debug.log('200: Leaving validate_article', 2);
1142: END IF;
1143:
1144: EXCEPTION
1145: WHEN FND_API.G_EXC_ERROR THEN

Line 1147: okc_debug.log('300: Leaving Validate_Article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1143:
1144: EXCEPTION
1145: WHEN FND_API.G_EXC_ERROR THEN
1146: IF (l_debug = 'Y') THEN
1147: okc_debug.log('300: Leaving Validate_Article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1148: END IF;
1149: ROLLBACK TO g_validate_article_GRP;
1150: l_return_status := G_RET_STS_ERROR ;
1151: x_return_status := G_RET_STS_ERROR ;

Line 1157: okc_debug.log('400: Leaving Validate_Article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1153: --dbms_output.put_line('Msg data2:' || x_msg_data);
1154:
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: IF (l_debug = 'Y') THEN
1157: okc_debug.log('400: Leaving Validate_Article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1158: END IF;
1159: ROLLBACK TO g_validate_article_GRP;
1160: l_return_status := G_RET_STS_UNEXP_ERROR ;
1161: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1166: okc_debug.log('500: Leaving Validate_Article because of EXCEPTION: '||sqlerrm, 2);

1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1163:
1164: WHEN OTHERS THEN
1165: IF (l_debug = 'Y') THEN
1166: okc_debug.log('500: Leaving Validate_Article because of EXCEPTION: '||sqlerrm, 2);
1167: END IF;
1168:
1169: ROLLBACK TO g_validate_article_GRP;
1170: l_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1260: okc_debug.log('600: Entered create_article', 2);

1256: BEGIN
1257:
1258: --dbms_output.put_line('600: Entered create_article from copy');
1259: IF (l_debug = 'Y') THEN
1260: okc_debug.log('600: Entered create_article', 2);
1261: END IF;
1262:
1263: -- Standard Start of API savepoint
1264: SAVEPOINT g_create_article_GRP;

Line 1419: okc_debug.log('700: Leaving create_article', 2);

1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1417:
1418: IF (l_debug = 'Y') THEN
1419: okc_debug.log('700: Leaving create_article', 2);
1420: END IF;
1421:
1422: EXCEPTION
1423: WHEN FND_API.G_EXC_ERROR THEN

Line 1425: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1421:
1422: EXCEPTION
1423: WHEN FND_API.G_EXC_ERROR THEN
1424: IF (l_debug = 'Y') THEN
1425: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1426: END IF;
1427: ROLLBACK TO g_create_article_GRP;
1428: x_return_status := G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 1433: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1429: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: IF (l_debug = 'Y') THEN
1433: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1434: END IF;
1435: ROLLBACK TO g_create_article_GRP;
1436: x_return_status := G_RET_STS_UNEXP_ERROR ;
1437: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 1441: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);

1437: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1438:
1439: WHEN OTHERS THEN
1440: IF (l_debug = 'Y') THEN
1441: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);
1442: END IF;
1443:
1444: ROLLBACK TO g_create_article_GRP;
1445: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1472: okc_debug.log('1100: Entered lock_article', 2);

1468: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_article';
1469: BEGIN
1470:
1471: IF (l_debug = 'Y') THEN
1472: okc_debug.log('1100: Entered lock_article', 2);
1473: END IF;
1474:
1475: -- Standard Start of API savepoint
1476: SAVEPOINT g_lock_article_GRP;

Line 1528: okc_debug.log('1200: Leaving lock_article', 2);

1524: -- Standard call to get message count and if count is 1, get message info.
1525: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1526:
1527: IF (l_debug = 'Y') THEN
1528: okc_debug.log('1200: Leaving lock_article', 2);
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN FND_API.G_EXC_ERROR THEN

Line 1534: okc_debug.log('1300: Leaving lock_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1530:
1531: EXCEPTION
1532: WHEN FND_API.G_EXC_ERROR THEN
1533: IF (l_debug = 'Y') THEN
1534: okc_debug.log('1300: Leaving lock_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1535: END IF;
1536: ROLLBACK TO g_lock_article_GRP;
1537: x_return_status := G_RET_STS_ERROR ;
1538: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 1542: okc_debug.log('1400: Leaving lock_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1538: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1539:
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: IF (l_debug = 'Y') THEN
1542: okc_debug.log('1400: Leaving lock_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1543: END IF;
1544: ROLLBACK TO g_lock_article_GRP;
1545: x_return_status := G_RET_STS_UNEXP_ERROR ;
1546: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 1550: okc_debug.log('1500: Leaving lock_article because of EXCEPTION: '||sqlerrm, 2);

1546: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1547:
1548: WHEN OTHERS THEN
1549: IF (l_debug = 'Y') THEN
1550: okc_debug.log('1500: Leaving lock_article because of EXCEPTION: '||sqlerrm, 2);
1551: END IF;
1552:
1553: ROLLBACK TO g_lock_article_GRP;
1554: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1637: okc_debug.log('1600: Entered update_article', 2);

1633:
1634: BEGIN
1635:
1636: IF (l_debug = 'Y') THEN
1637: okc_debug.log('1600: Entered update_article', 2);
1638: okc_debug.log('1700: Locking row', 2);
1639: END IF;
1640:
1641: -- Standard Start of API savepoint

Line 1638: okc_debug.log('1700: Locking row', 2);

1634: BEGIN
1635:
1636: IF (l_debug = 'Y') THEN
1637: okc_debug.log('1600: Entered update_article', 2);
1638: okc_debug.log('1700: Locking row', 2);
1639: END IF;
1640:
1641: -- Standard Start of API savepoint
1642: SAVEPOINT g_update_article_GRP;

Line 1768: okc_debug.log('1800: Leaving update_article', 2);

1764: -- Standard call to get message count and if count is 1, get message info.
1765: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1766:
1767: IF (l_debug = 'Y') THEN
1768: okc_debug.log('1800: Leaving update_article', 2);
1769: END IF;
1770:
1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN

Line 1774: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1770:
1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN
1773: IF (l_debug = 'Y') THEN
1774: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1775: END IF;
1776: ROLLBACK TO g_update_article_GRP;
1777: x_return_status := G_RET_STS_ERROR ;
1778: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 1782: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1778: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1779:
1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781: IF (l_debug = 'Y') THEN
1782: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1783: END IF;
1784: ROLLBACK TO g_update_article_GRP;
1785: x_return_status := G_RET_STS_UNEXP_ERROR ;
1786: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 1790: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);

1786: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1787:
1788: WHEN OTHERS THEN
1789: IF (l_debug = 'Y') THEN
1790: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);
1791: END IF;
1792:
1793: ROLLBACK TO g_update_article_GRP;
1794: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1850: okc_debug.log('2200: Entered delete_article', 2);

1846: AND document_type = 'TEMPLATE';
1847: BEGIN
1848:
1849: IF (l_debug = 'Y') THEN
1850: okc_debug.log('2200: Entered delete_article', 2);
1851: END IF;
1852:
1853: -- Standard Start of API savepoint
1854: SAVEPOINT g_delete_article_GRP;

Line 1874: Okc_Debug.Log('2200: - Article Status is not Draft or Rejected,It cannot be deleted',2);

1870:
1871: IF l_standard_yn = 'Y' THEN
1872: IF l_status NOT IN ( 'DRAFT','REJECTED') THEN
1873: IF (l_debug = 'Y') THEN
1874: Okc_Debug.Log('2200: - Article Status is not Draft or Rejected,It cannot be deleted',2);
1875: END IF;
1876: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DEL_INV_STATUS');
1877: x_return_status := G_RET_STS_ERROR;
1878: RAISE FND_API.G_EXC_ERROR;

Line 1887: Okc_Debug.Log('2200: - Article Version is the only version',2);

1883: --dbms_output.put_line('Only version available:' || l_only_version ||
1884: -- p_article_id ||'*'||p_article_version_id);
1885: IF l_only_version = 'T' THEN
1886: IF (l_debug = 'Y') THEN
1887: Okc_Debug.Log('2200: - Article Version is the only version',2);
1888: END IF;
1889: OPEN l_template_csr (p_article_id);
1890: FETCH l_template_csr INTO l_dummy1;
1891: CLOSE l_template_csr;

Line 1895: Okc_Debug.Log('2200: - Article Version is already Used in the Templates',2);

1891: CLOSE l_template_csr;
1892: --dbms_output.put_line('Used in Template:' || l_dummy1);
1893: IF l_dummy1 = '1' THEN
1894: IF (l_debug = 'Y') THEN
1895: Okc_Debug.Log('2200: - Article Version is already Used in the Templates',2);
1896: END IF;
1897: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_USED_IN_TEMPL');
1898: x_return_status := G_RET_STS_ERROR;
1899: RAISE FND_API.G_EXC_ERROR;

Line 1903: Okc_Debug.Log('2200: - Article Version is already Used in the Rules',2);

1899: RAISE FND_API.G_EXC_ERROR;
1900: ELSE -- Check if it used in any of the Rules (Bug 3971186)
1901: IF (OKC_XPRT_UTIL_PVT.ok_to_delete_clause(p_article_id) = 'N') THEN
1902: IF (l_debug = 'Y') THEN
1903: Okc_Debug.Log('2200: - Article Version is already Used in the Rules',2);
1904: END IF;
1905: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_USED_IN_RULES');
1906: x_return_status := G_RET_STS_ERROR;
1907: RAISE FND_API.G_EXC_ERROR;

Line 1969: okc_debug.log('2300: Leaving delete_article', 2);

1965: -- Standard call to get message count and if count is 1, get message info.
1966: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1967:
1968: IF (l_debug = 'Y') THEN
1969: okc_debug.log('2300: Leaving delete_article', 2);
1970: END IF;
1971:
1972: EXCEPTION
1973: WHEN FND_API.G_EXC_ERROR THEN

Line 1975: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1971:
1972: EXCEPTION
1973: WHEN FND_API.G_EXC_ERROR THEN
1974: IF (l_debug = 'Y') THEN
1975: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1976: END IF;
1977: IF l_status_csr%ISOPEN THEN
1978: CLOSE l_status_csr;
1979: END IF;

Line 1992: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

1988: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1989:
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: IF (l_debug = 'Y') THEN
1992: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1993: END IF;
1994: IF l_status_csr%ISOPEN THEN
1995: CLOSE l_status_csr;
1996: END IF;

Line 2009: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);

2005: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2006:
2007: WHEN OTHERS THEN
2008: IF (l_debug = 'Y') THEN
2009: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);
2010: END IF;
2011: IF l_status_csr%ISOPEN THEN
2012: CLOSE l_status_csr;
2013: END IF;

Line 2094: okc_debug.log('100: Entered validate_article_version', 2);

2090:
2091: BEGIN
2092:
2093: IF (l_debug = 'Y') THEN
2094: okc_debug.log('100: Entered validate_article_version', 2);
2095: END IF;
2096:
2097: -- Standard Start of API savepoint
2098: SAVEPOINT g_validate_article_version_GRP;

Line 2177: okc_debug.log('200: Leaving validate_article_version', 2);

2173: -- Standard call to get message count and if count is 1, get message info.
2174: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2175:
2176: IF (l_debug = 'Y') THEN
2177: okc_debug.log('200: Leaving validate_article_version', 2);
2178: END IF;
2179:
2180: EXCEPTION
2181: WHEN FND_API.G_EXC_ERROR THEN

Line 2183: okc_debug.log('300: Leaving Validate_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);

2179:
2180: EXCEPTION
2181: WHEN FND_API.G_EXC_ERROR THEN
2182: IF (l_debug = 'Y') THEN
2183: okc_debug.log('300: Leaving Validate_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2184: END IF;
2185: ROLLBACK TO g_validate_article_version_GRP;
2186: x_return_status := G_RET_STS_ERROR ;
2187: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 2191: okc_debug.log('400: Leaving Validate_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2187: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2188:
2189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2190: IF (l_debug = 'Y') THEN
2191: okc_debug.log('400: Leaving Validate_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2192: END IF;
2193: ROLLBACK TO g_validate_article_version_GRP;
2194: x_return_status := G_RET_STS_UNEXP_ERROR ;
2195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 2199: okc_debug.log('500: Leaving Validate_article_version because of EXCEPTION: '||sqlerrm, 2);

2195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2196:
2197: WHEN OTHERS THEN
2198: IF (l_debug = 'Y') THEN
2199: okc_debug.log('500: Leaving Validate_article_version because of EXCEPTION: '||sqlerrm, 2);
2200: END IF;
2201:
2202: ROLLBACK TO g_validate_article_version_GRP;
2203: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2303: okc_debug.log('600: Entered create_article_version', 2);

2299: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2300: BEGIN
2301:
2302: IF (l_debug = 'Y') THEN
2303: okc_debug.log('600: Entered create_article_version', 2);
2304: END IF;
2305:
2306: -- Standard Start of API savepoint
2307: SAVEPOINT g_create_article_version_GRP;

Line 2516: okc_debug.log('700: Leaving create_article_version', 2);

2512: -- Standard call to get message count and if count is 1, get message info.
2513: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2514:
2515: IF (l_debug = 'Y') THEN
2516: okc_debug.log('700: Leaving create_article_version', 2);
2517: END IF;
2518:
2519: EXCEPTION
2520: WHEN FND_API.G_EXC_ERROR THEN

Line 2522: okc_debug.log('800: Leaving create_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);

2518:
2519: EXCEPTION
2520: WHEN FND_API.G_EXC_ERROR THEN
2521: IF (l_debug = 'Y') THEN
2522: okc_debug.log('800: Leaving create_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2523: END IF;
2524: ROLLBACK TO g_create_article_version_GRP;
2525: x_return_status := G_RET_STS_ERROR ;
2526: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 2530: okc_debug.log('900: Leaving create_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2526: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2527:
2528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2529: IF (l_debug = 'Y') THEN
2530: okc_debug.log('900: Leaving create_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2531: END IF;
2532: ROLLBACK TO g_create_article_version_GRP;
2533: x_return_status := G_RET_STS_UNEXP_ERROR ;
2534: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 2538: okc_debug.log('1000: Leaving create_article_version because of EXCEPTION: '||sqlerrm, 2);

2534: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2535:
2536: WHEN OTHERS THEN
2537: IF (l_debug = 'Y') THEN
2538: okc_debug.log('1000: Leaving create_article_version because of EXCEPTION: '||sqlerrm, 2);
2539: END IF;
2540:
2541: ROLLBACK TO g_create_article_version_GRP;
2542: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2568: okc_debug.log('1100: Entered lock_article_version', 2);

2564: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_article_version';
2565: BEGIN
2566:
2567: IF (l_debug = 'Y') THEN
2568: okc_debug.log('1100: Entered lock_article_version', 2);
2569: END IF;
2570:
2571: -- Standard Start of API savepoint
2572: SAVEPOINT g_lock_article_version_GRP;

Line 2604: okc_debug.log('1200: Leaving lock_article_version', 2);

2600: -- Standard call to get message count and if count is 1, get message info.
2601: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2602:
2603: IF (l_debug = 'Y') THEN
2604: okc_debug.log('1200: Leaving lock_article_version', 2);
2605: END IF;
2606:
2607: EXCEPTION
2608: WHEN FND_API.G_EXC_ERROR THEN

Line 2610: okc_debug.log('1300: Leaving lock_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);

2606:
2607: EXCEPTION
2608: WHEN FND_API.G_EXC_ERROR THEN
2609: IF (l_debug = 'Y') THEN
2610: okc_debug.log('1300: Leaving lock_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2611: END IF;
2612: ROLLBACK TO g_lock_article_version_GRP;
2613: x_return_status := G_RET_STS_ERROR ;
2614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 2618: okc_debug.log('1400: Leaving lock_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2615:
2616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2617: IF (l_debug = 'Y') THEN
2618: okc_debug.log('1400: Leaving lock_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2619: END IF;
2620: ROLLBACK TO g_lock_article_version_GRP;
2621: x_return_status := G_RET_STS_UNEXP_ERROR ;
2622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 2626: okc_debug.log('1500: Leaving lock_article_version because of EXCEPTION: '||sqlerrm, 2);

2622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2623:
2624: WHEN OTHERS THEN
2625: IF (l_debug = 'Y') THEN
2626: okc_debug.log('1500: Leaving lock_article_version because of EXCEPTION: '||sqlerrm, 2);
2627: END IF;
2628:
2629: ROLLBACK TO g_lock_article_version_GRP;
2630: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2665: okc_debug.log('1750: Entered update_article_variables', 2);

2661: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES
2662: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2663: BEGIN
2664: IF (l_debug = 'Y') THEN
2665: okc_debug.log('1750: Entered update_article_variables', 2);
2666: END IF;
2667: OPEN existing_art_variable_csr(p_article_version_id);
2668: FETCH existing_art_variable_csr BULK COLLECT INTO l_existing_variables_tbl;
2669: CLOSE existing_art_variable_csr;

Line 2738: Okc_Debug.Log('1750: Leaving Update Article variables successfully', 2);

2734: END IF;
2735: END IF;
2736:
2737: IF (l_debug = 'Y') THEN
2738: Okc_Debug.Log('1750: Leaving Update Article variables successfully', 2);
2739: END IF;
2740: x_return_status := G_RET_STS_SUCCESS;
2741:
2742: EXCEPTION

Line 2746: okc_debug.log('1750: Leaving update_article_variables because of EXCEPTION: '||sqlerrm, 2);

2742: EXCEPTION
2743:
2744: WHEN OTHERS THEN
2745: IF (l_debug = 'Y') THEN
2746: okc_debug.log('1750: Leaving update_article_variables because of EXCEPTION: '||sqlerrm, 2);
2747: END IF;
2748: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2749: p_msg_name => G_UNEXPECTED_ERROR,
2750: p_token1 => G_SQLCODE_TOKEN,

Line 2842: okc_debug.log('1600: Entered update_article_version', 2);

2838:
2839: BEGIN
2840:
2841: IF (l_debug = 'Y') THEN
2842: okc_debug.log('1600: Entered update_article_version', 2);
2843: okc_debug.log('1700: Locking row', 2);
2844: END IF;
2845:
2846: -- Standard Start of API savepoint

Line 2843: okc_debug.log('1700: Locking row', 2);

2839: BEGIN
2840:
2841: IF (l_debug = 'Y') THEN
2842: okc_debug.log('1600: Entered update_article_version', 2);
2843: okc_debug.log('1700: Locking row', 2);
2844: END IF;
2845:
2846: -- Standard Start of API savepoint
2847: SAVEPOINT g_update_article_version_GRP;

Line 3005: okc_debug.log('1800: Leaving update_article_version', 2);

3001: -- Standard call to get message count and if count is 1, get message info.
3002: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3003:
3004: IF (l_debug = 'Y') THEN
3005: okc_debug.log('1800: Leaving update_article_version', 2);
3006: END IF;
3007:
3008: EXCEPTION
3009: WHEN FND_API.G_EXC_ERROR THEN

Line 3011: okc_debug.log('1900: Leaving update_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);

3007:
3008: EXCEPTION
3009: WHEN FND_API.G_EXC_ERROR THEN
3010: IF (l_debug = 'Y') THEN
3011: okc_debug.log('1900: Leaving update_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
3012: END IF;
3013: ROLLBACK TO g_update_article_version_GRP;
3014: x_return_status := G_RET_STS_ERROR ;
3015: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 3019: okc_debug.log('2000: Leaving update_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3015: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3016:
3017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3018: IF (l_debug = 'Y') THEN
3019: okc_debug.log('2000: Leaving update_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3020: END IF;
3021: ROLLBACK TO g_update_article_version_GRP;
3022: x_return_status := G_RET_STS_UNEXP_ERROR ;
3023: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 3027: okc_debug.log('2100: Leaving update_article_version because of EXCEPTION: '||sqlerrm, 2);

3023: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3024:
3025: WHEN OTHERS THEN
3026: IF (l_debug = 'Y') THEN
3027: okc_debug.log('2100: Leaving update_article_version because of EXCEPTION: '||sqlerrm, 2);
3028: END IF;
3029:
3030: ROLLBACK TO g_update_article_version_GRP;
3031: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 3196: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);

3192: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3193: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3194: BEGIN
3195: IF (l_debug = 'Y') THEN
3196: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);
3197: END IF;
3198: --dbms_output.put_line('2700: Entered Copy_Articles ');
3199:
3200: -- Standard Start of API savepoint

Line 3664: okc_debug.log('2800: Leaving copy_article', 2);

3660: -- Standard call to get message count and if count is 1, get message info.
3661: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3662:
3663: IF (l_debug = 'Y') THEN
3664: okc_debug.log('2800: Leaving copy_article', 2);
3665: END IF;
3666:
3667: EXCEPTION
3668: WHEN FND_API.G_EXC_ERROR THEN

Line 3670: okc_debug.log('2900: Leaving copy_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);

3666:
3667: EXCEPTION
3668: WHEN FND_API.G_EXC_ERROR THEN
3669: IF (l_debug = 'Y') THEN
3670: okc_debug.log('2900: Leaving copy_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
3671: END IF;
3672: ROLLBACK TO g_copy_article_GRP;
3673: x_return_status := G_RET_STS_ERROR ;
3674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 3678: okc_debug.log('3000: Leaving copy_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

3674: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3675:
3676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3677: IF (l_debug = 'Y') THEN
3678: okc_debug.log('3000: Leaving copy_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3679: END IF;
3680: ROLLBACK TO g_copy_article_GRP;
3681: x_return_status := G_RET_STS_UNEXP_ERROR ;
3682: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 3686: okc_debug.log('3100: Leaving copy_article because of EXCEPTION: '||sqlerrm, 2);

3682: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3683:
3684: WHEN OTHERS THEN
3685: IF (l_debug = 'Y') THEN
3686: okc_debug.log('3100: Leaving copy_article because of EXCEPTION: '||sqlerrm, 2);
3687: END IF;
3688:
3689: ROLLBACK TO g_copy_article_GRP;
3690: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 3786: okc_debug.log('500: Leaving get local article id EXCEPTION: '||sqlerrm, 2);

3782: END IF;
3783: EXCEPTION
3784: WHEN OTHERS THEN
3785: IF (l_debug = 'Y') THEN
3786: okc_debug.log('500: Leaving get local article id EXCEPTION: '||sqlerrm, 2);
3787: END IF;
3788: IF l_local_article_csr%ISOPEN THEN
3789: CLOSE l_local_article_csr;
3790: END IF;

Line 3848: okc_debug.log('500: Leaving check adopted.. EXCEPTION: '||sqlerrm, 2);

3844: END IF;
3845: EXCEPTION
3846: WHEN OTHERS THEN
3847: IF (l_debug = 'Y') THEN
3848: okc_debug.log('500: Leaving check adopted.. EXCEPTION: '||sqlerrm, 2);
3849: END IF;
3850: IF l_local_article_csr%ISOPEN THEN
3851: CLOSE l_local_article_csr;
3852: END IF;

Line 3941: okc_debug.log('100: Entered auto adopt relationship', 2);

3937:
3938: BEGIN
3939: x_return_status := G_RET_STS_SUCCESS;
3940: IF (l_debug = 'Y') THEN
3941: okc_debug.log('100: Entered auto adopt relationship', 2);
3942: END IF;
3943:
3944: x_return_status := FND_API.G_RET_STS_SUCCESS;
3945: --dbms_output.put_line('Global org is: '|| l_global_org_id);

Line 4078: okc_debug.log('300: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);

4074: CLOSE l_org_info_csr;
4075: EXCEPTION
4076: WHEN FND_API.G_EXC_ERROR THEN
4077: IF (l_debug = 'Y') THEN
4078: okc_debug.log('300: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4079: END IF;
4080: x_return_status := G_RET_STS_ERROR ;
4081:
4082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4084: okc_debug.log('400: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

4080: x_return_status := G_RET_STS_ERROR ;
4081:
4082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4083: IF (l_debug = 'Y') THEN
4084: okc_debug.log('400: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4085: END IF;
4086: IF l_org_info_csr%ISOPEN THEN
4087: CLOSE l_org_info_csr;
4088: END IF;

Line 4096: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);

4092: x_return_status := G_RET_STS_UNEXP_ERROR ;
4093:
4094: WHEN OTHERS THEN
4095: IF (l_debug = 'Y') THEN
4096: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
4097: END IF;
4098: IF l_org_info_csr%ISOPEN THEN
4099: CLOSE l_org_info_csr;
4100: END IF;

Line 4138: okc_debug.log('600: Entered insert_row', 2);

4134: l_org_id NUMBER;
4135: BEGIN
4136:
4137: IF (l_debug = 'Y') THEN
4138: okc_debug.log('600: Entered insert_row', 2);
4139: END IF;
4140:
4141: -- Standard Start of API savepoint
4142: SAVEPOINT g_insert_row_GRP;

Line 4229: okc_debug.log('700: Leaving insert_row', 2);

4225: -- Standard call to get message count and if count is 1, get message info.
4226: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4227:
4228: IF (l_debug = 'Y') THEN
4229: okc_debug.log('700: Leaving insert_row', 2);
4230: END IF;
4231:
4232: EXCEPTION
4233: WHEN FND_API.G_EXC_ERROR THEN

Line 4235: okc_debug.log('800: Leaving insert_row: OKC_API.G_EXCEPTION_ERROR Exception', 2);

4231:
4232: EXCEPTION
4233: WHEN FND_API.G_EXC_ERROR THEN
4234: IF (l_debug = 'Y') THEN
4235: okc_debug.log('800: Leaving insert_row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4236: END IF;
4237: ROLLBACK TO g_insert_row_GRP;
4238: x_return_status := G_RET_STS_ERROR ;
4239: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 4243: okc_debug.log('900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

4239: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4240:
4241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4242: IF (l_debug = 'Y') THEN
4243: okc_debug.log('900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4244: END IF;
4245: ROLLBACK TO g_insert_row_GRP;
4246: x_return_status := G_RET_STS_UNEXP_ERROR ;
4247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 4251: okc_debug.log('1000: Leaving insert_row because of EXCEPTION: '||sqlerrm, 2);

4247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4248:
4249: WHEN OTHERS THEN
4250: IF (l_debug = 'Y') THEN
4251: okc_debug.log('1000: Leaving insert_row because of EXCEPTION: '||sqlerrm, 2);
4252: END IF;
4253:
4254: ROLLBACK TO g_insert_row_GRP;
4255: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 4307: okc_debug.log('100: Entered create_adoption', 2);

4303: */
4304:
4305: BEGIN
4306: IF (l_debug = 'Y') THEN
4307: okc_debug.log('100: Entered create_adoption', 2);
4308: END IF;
4309:
4310: -- Standard Start of API savepoint
4311: -- Initialize API return status to success

Line 4355: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);

4351: CLOSE l_relationship_csr;
4352: EXCEPTION
4353: WHEN OTHERS THEN
4354: IF (l_debug = 'Y') THEN
4355: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
4356: END IF;
4357: IF l_relationship_csr%ISOPEN THEN
4358: CLOSE l_relationship_csr;
4359: END IF;

Line 4387: okc_debug.log('2200: Entered delete_row', 2);

4383: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_row';
4384: BEGIN
4385:
4386: IF (l_debug = 'Y') THEN
4387: okc_debug.log('2200: Entered delete_row', 2);
4388: END IF;
4389:
4390: -- Standard Start of API savepoint
4391: SAVEPOINT g_delete_row_GRP;

Line 4468: okc_debug.log('2300: Leaving delete_row', 2);

4464: -- Standard call to get message count and if count is 1, get message info.
4465: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4466:
4467: IF (l_debug = 'Y') THEN
4468: okc_debug.log('2300: Leaving delete_row', 2);
4469: END IF;
4470:
4471: EXCEPTION
4472: WHEN FND_API.G_EXC_ERROR THEN

Line 4474: okc_debug.log('2400: Leaving delete_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);

4470:
4471: EXCEPTION
4472: WHEN FND_API.G_EXC_ERROR THEN
4473: IF (l_debug = 'Y') THEN
4474: okc_debug.log('2400: Leaving delete_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4475: END IF;
4476: ROLLBACK TO g_delete_row_GRP;
4477: x_return_status := G_RET_STS_ERROR ;
4478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 4482: okc_debug.log('2500: Leaving delete_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

4478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4479:
4480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4481: IF (l_debug = 'Y') THEN
4482: okc_debug.log('2500: Leaving delete_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4483: END IF;
4484: ROLLBACK TO g_delete_row_GRP;
4485: x_return_status := G_RET_STS_UNEXP_ERROR ;
4486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

Line 4490: okc_debug.log('2600: Leaving delete_Row because of EXCEPTION: '||sqlerrm, 2);

4486: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4487:
4488: WHEN OTHERS THEN
4489: IF (l_debug = 'Y') THEN
4490: okc_debug.log('2600: Leaving delete_Row because of EXCEPTION: '||sqlerrm, 2);
4491: END IF;
4492:
4493: ROLLBACK TO g_delete_row_GRP;
4494: x_return_status := G_RET_STS_UNEXP_ERROR ;