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 374: okc_debug.log('100: Entering parse_n_replace_text', 2);

370: l_chk_max_read_amt BINARY_INTEGER := 2;
371:
372:
373: BEGIN
374: okc_debug.log('100: Entering parse_n_replace_text', 2);
375: l_article_text_length := DBMS_LOB.GETLENGTH(p_article_text);
376: l_amount_left_to_read := l_article_text_length;
377: --dbms_output.put_line('the lenght of the article text clob' || l_article_text_length);
378:

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

549: end if;
550:
551: --dbms_lob.freetemporary(l_clob);
552: --dbms_lob.freetemporary(p_dest_clob);
553: okc_debug.log('100: Leaving parse_n_replace_text', 2);
554: EXCEPTION
555: WHEN G_VAR_NOT_FOUND then
556: --dbms_output.put_line(' VAR NOT FOUND 1 ');
557: x_return_status := G_VAR_NOT_FOUND_RET_STS;

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

786: END IF;
787: EXCEPTION
788: WHEN FND_API.G_EXC_ERROR THEN
789: IF (l_debug = 'Y') THEN
790: okc_debug.log('2400: Leaving get article number: OKC_API.G_EXCEPTION_ERROR Exception', 2);
791: --dbms_output.put_line('2400: Leaving get article number: OKC_API.G_EXCEPTION_ERROR Exception');
792: END IF;
793: x_return_status := G_RET_STS_ERROR ;
794: WHEN OTHERS THEN

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

838:
839: BEGIN
840:
841: IF (l_debug = 'Y') THEN
842: okc_debug.log('2200: Entered delete_article_version', 2);
843: END IF;
844: -- MOAC
845: G_CURRENT_ORG_ID := mo_global.get_current_org_id() ;
846: /*

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

929: -- Standard call to get message count and if count is 1, get message info.
930: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
931:
932: IF (l_debug = 'Y') THEN
933: okc_debug.log('2300: Leaving delete_article_version', 2);
934: END IF;
935:
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN

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

935:
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN
938: IF (l_debug = 'Y') THEN
939: okc_debug.log('2400: Leaving delete_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
940: END IF;
941: ROLLBACK TO g_delete_article_version_GRP;
942: x_return_status := G_RET_STS_ERROR ;
943: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

943: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
944:
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: IF (l_debug = 'Y') THEN
947: okc_debug.log('2500: Leaving delete_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
948: END IF;
949: ROLLBACK TO g_delete_article_version_GRP;
950: x_return_status := G_RET_STS_UNEXP_ERROR ;
951: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

951: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
952:
953: WHEN OTHERS THEN
954: IF (l_debug = 'Y') THEN
955: okc_debug.log('2600: Leaving delete_article_version because of EXCEPTION: '||sqlerrm, 2);
956: END IF;
957:
958: ROLLBACK TO g_delete_article_version_GRP;
959: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1040:
1041: BEGIN
1042:
1043: IF (l_debug = 'Y') THEN
1044: okc_debug.log('100: Entered validate_article', 2);
1045: END IF;
1046:
1047: -- Standard Start of API savepoint
1048: SAVEPOINT g_validate_article_GRP;

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

1159: -- Standard call to get message count and if count is 1, get message info.
1160: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1161:
1162: IF (l_debug = 'Y') THEN
1163: okc_debug.log('200: Leaving validate_article', 2);
1164: END IF;
1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN

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

1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: IF (l_debug = 'Y') THEN
1169: okc_debug.log('300: Leaving Validate_Article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1170: END IF;
1171: ROLLBACK TO g_validate_article_GRP;
1172: l_return_status := G_RET_STS_ERROR ;
1173: x_return_status := G_RET_STS_ERROR ;

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

1175: --dbms_output.put_line('Msg data2:' || x_msg_data);
1176:
1177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1178: IF (l_debug = 'Y') THEN
1179: okc_debug.log('400: Leaving Validate_Article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1180: END IF;
1181: ROLLBACK TO g_validate_article_GRP;
1182: l_return_status := G_RET_STS_UNEXP_ERROR ;
1183: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1185:
1186: WHEN OTHERS THEN
1187: IF (l_debug = 'Y') THEN
1188: okc_debug.log('500: Leaving Validate_Article because of EXCEPTION: '||sqlerrm, 2);
1189: END IF;
1190:
1191: ROLLBACK TO g_validate_article_GRP;
1192: l_return_status := G_RET_STS_UNEXP_ERROR ;

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

1283: BEGIN
1284:
1285: --dbms_output.put_line('600: Entered create_article from copy');
1286: IF (l_debug = 'Y') THEN
1287: okc_debug.log('600: Entered create_article', 2);
1288: END IF;
1289:
1290: -- Standard Start of API savepoint
1291: SAVEPOINT g_create_article_GRP;

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

1447: -- Standard call to get message count and if count is 1, get message info.
1448: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1449:
1450: IF (l_debug = 'Y') THEN
1451: okc_debug.log('700: Leaving create_article', 2);
1452: END IF;
1453:
1454: EXCEPTION
1455: WHEN FND_API.G_EXC_ERROR THEN

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

1453:
1454: EXCEPTION
1455: WHEN FND_API.G_EXC_ERROR THEN
1456: IF (l_debug = 'Y') THEN
1457: okc_debug.log('800: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1458: END IF;
1459: ROLLBACK TO g_create_article_GRP;
1460: x_return_status := G_RET_STS_ERROR ;
1461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

1461: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1462:
1463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1464: IF (l_debug = 'Y') THEN
1465: okc_debug.log('900: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1466: END IF;
1467: ROLLBACK TO g_create_article_GRP;
1468: x_return_status := G_RET_STS_UNEXP_ERROR ;
1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1470:
1471: WHEN OTHERS THEN
1472: IF (l_debug = 'Y') THEN
1473: okc_debug.log('1000: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);
1474: END IF;
1475:
1476: ROLLBACK TO g_create_article_GRP;
1477: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1500: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_article';
1501: BEGIN
1502:
1503: IF (l_debug = 'Y') THEN
1504: okc_debug.log('1100: Entered lock_article', 2);
1505: END IF;
1506:
1507: -- Standard Start of API savepoint
1508: SAVEPOINT g_lock_article_GRP;

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

1556: -- Standard call to get message count and if count is 1, get message info.
1557: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1558:
1559: IF (l_debug = 'Y') THEN
1560: okc_debug.log('1200: Leaving lock_article', 2);
1561: END IF;
1562:
1563: EXCEPTION
1564: WHEN FND_API.G_EXC_ERROR THEN

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

1562:
1563: EXCEPTION
1564: WHEN FND_API.G_EXC_ERROR THEN
1565: IF (l_debug = 'Y') THEN
1566: okc_debug.log('1300: Leaving lock_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1567: END IF;
1568: ROLLBACK TO g_lock_article_GRP;
1569: x_return_status := G_RET_STS_ERROR ;
1570: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

1570: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1571:
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: IF (l_debug = 'Y') THEN
1574: okc_debug.log('1400: Leaving lock_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1575: END IF;
1576: ROLLBACK TO g_lock_article_GRP;
1577: x_return_status := G_RET_STS_UNEXP_ERROR ;
1578: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

1578: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1579:
1580: WHEN OTHERS THEN
1581: IF (l_debug = 'Y') THEN
1582: okc_debug.log('1500: Leaving lock_article because of EXCEPTION: '||sqlerrm, 2);
1583: END IF;
1584:
1585: ROLLBACK TO g_lock_article_GRP;
1586: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1670:
1671: BEGIN
1672:
1673: IF (l_debug = 'Y') THEN
1674: okc_debug.log('1600: Entered update_article', 2);
1675: okc_debug.log('1700: Locking row', 2);
1676: END IF;
1677:
1678: -- Standard Start of API savepoint

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

1671: BEGIN
1672:
1673: IF (l_debug = 'Y') THEN
1674: okc_debug.log('1600: Entered update_article', 2);
1675: okc_debug.log('1700: Locking row', 2);
1676: END IF;
1677:
1678: -- Standard Start of API savepoint
1679: SAVEPOINT g_update_article_GRP;

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

1806: -- Standard call to get message count and if count is 1, get message info.
1807: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1808:
1809: IF (l_debug = 'Y') THEN
1810: okc_debug.log('1800: Leaving update_article', 2);
1811: END IF;
1812:
1813: EXCEPTION
1814: WHEN FND_API.G_EXC_ERROR THEN

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

1812:
1813: EXCEPTION
1814: WHEN FND_API.G_EXC_ERROR THEN
1815: IF (l_debug = 'Y') THEN
1816: okc_debug.log('1900: Leaving update_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1817: END IF;
1818: ROLLBACK TO g_update_article_GRP;
1819: x_return_status := G_RET_STS_ERROR ;
1820: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

1820: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1821:
1822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1823: IF (l_debug = 'Y') THEN
1824: okc_debug.log('2000: Leaving update_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1825: END IF;
1826: ROLLBACK TO g_update_article_GRP;
1827: x_return_status := G_RET_STS_UNEXP_ERROR ;
1828: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

1828: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
1829:
1830: WHEN OTHERS THEN
1831: IF (l_debug = 'Y') THEN
1832: okc_debug.log('2100: Leaving update_article because of EXCEPTION: '||sqlerrm, 2);
1833: END IF;
1834:
1835: ROLLBACK TO g_update_article_GRP;
1836: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1888: AND document_type = 'TEMPLATE';
1889: BEGIN
1890:
1891: IF (l_debug = 'Y') THEN
1892: okc_debug.log('2200: Entered delete_article', 2);
1893: END IF;
1894:
1895: -- Standard Start of API savepoint
1896: SAVEPOINT g_delete_article_GRP;

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

1912:
1913: IF l_standard_yn = 'Y' THEN
1914: IF l_status NOT IN ( 'DRAFT','REJECTED') THEN
1915: IF (l_debug = 'Y') THEN
1916: Okc_Debug.Log('2200: - Article Status is not Draft or Rejected,It cannot be deleted',2);
1917: END IF;
1918: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_DEL_INV_STATUS');
1919: x_return_status := G_RET_STS_ERROR;
1920: RAISE FND_API.G_EXC_ERROR;

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

1925: --dbms_output.put_line('Only version available:' || l_only_version ||
1926: -- p_article_id ||'*'||p_article_version_id);
1927: IF l_only_version = 'T' THEN
1928: IF (l_debug = 'Y') THEN
1929: Okc_Debug.Log('2200: - Article Version is the only version',2);
1930: END IF;
1931: OPEN l_template_csr (p_article_id);
1932: FETCH l_template_csr INTO l_dummy1;
1933: CLOSE l_template_csr;

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

1933: CLOSE l_template_csr;
1934: --dbms_output.put_line('Used in Template:' || l_dummy1);
1935: IF l_dummy1 = '1' THEN
1936: IF (l_debug = 'Y') THEN
1937: Okc_Debug.Log('2200: - Article Version is already Used in the Templates',2);
1938: END IF;
1939: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_USED_IN_TEMPL');
1940: x_return_status := G_RET_STS_ERROR;
1941: RAISE FND_API.G_EXC_ERROR;

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

1941: RAISE FND_API.G_EXC_ERROR;
1942: ELSE -- Check if it used in any of the Rules (Bug 3971186)
1943: IF (OKC_XPRT_UTIL_PVT.ok_to_delete_clause(p_article_id) = 'N') THEN
1944: IF (l_debug = 'Y') THEN
1945: Okc_Debug.Log('2200: - Article Version is already Used in the Rules',2);
1946: END IF;
1947: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_USED_IN_RULES');
1948: x_return_status := G_RET_STS_ERROR;
1949: RAISE FND_API.G_EXC_ERROR;

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

2007: -- Standard call to get message count and if count is 1, get message info.
2008: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2009:
2010: IF (l_debug = 'Y') THEN
2011: okc_debug.log('2300: Leaving delete_article', 2);
2012: END IF;
2013:
2014: EXCEPTION
2015: WHEN FND_API.G_EXC_ERROR THEN

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

2013:
2014: EXCEPTION
2015: WHEN FND_API.G_EXC_ERROR THEN
2016: IF (l_debug = 'Y') THEN
2017: okc_debug.log('2400: Leaving delete_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2018: END IF;
2019: IF l_status_csr%ISOPEN THEN
2020: CLOSE l_status_csr;
2021: END IF;

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

2030: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2031:
2032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2033: IF (l_debug = 'Y') THEN
2034: okc_debug.log('2500: Leaving delete_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2035: END IF;
2036: IF l_status_csr%ISOPEN THEN
2037: CLOSE l_status_csr;
2038: END IF;

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

2047: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2048:
2049: WHEN OTHERS THEN
2050: IF (l_debug = 'Y') THEN
2051: okc_debug.log('2600: Leaving delete_article because of EXCEPTION: '||sqlerrm, 2);
2052: END IF;
2053: IF l_status_csr%ISOPEN THEN
2054: CLOSE l_status_csr;
2055: END IF;

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

2136:
2137: BEGIN
2138:
2139: IF (l_debug = 'Y') THEN
2140: okc_debug.log('100: Entered validate_article_version', 2);
2141: END IF;
2142:
2143: -- Standard Start of API savepoint
2144: SAVEPOINT g_validate_article_version_GRP;

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

2224: -- Standard call to get message count and if count is 1, get message info.
2225: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2226:
2227: IF (l_debug = 'Y') THEN
2228: okc_debug.log('200: Leaving validate_article_version', 2);
2229: END IF;
2230:
2231: EXCEPTION
2232: WHEN FND_API.G_EXC_ERROR THEN

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

2230:
2231: EXCEPTION
2232: WHEN FND_API.G_EXC_ERROR THEN
2233: IF (l_debug = 'Y') THEN
2234: okc_debug.log('300: Leaving Validate_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2235: END IF;
2236: ROLLBACK TO g_validate_article_version_GRP;
2237: x_return_status := G_RET_STS_ERROR ;
2238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

2238: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2239:
2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2241: IF (l_debug = 'Y') THEN
2242: okc_debug.log('400: Leaving Validate_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2243: END IF;
2244: ROLLBACK TO g_validate_article_version_GRP;
2245: x_return_status := G_RET_STS_UNEXP_ERROR ;
2246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

2246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2247:
2248: WHEN OTHERS THEN
2249: IF (l_debug = 'Y') THEN
2250: okc_debug.log('500: Leaving Validate_article_version because of EXCEPTION: '||sqlerrm, 2);
2251: END IF;
2252:
2253: ROLLBACK TO g_validate_article_version_GRP;
2254: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2355: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2356: BEGIN
2357:
2358: IF (l_debug = 'Y') THEN
2359: okc_debug.log('600: Entered create_article_version', 2);
2360: END IF;
2361:
2362: -- Standard Start of API savepoint
2363: SAVEPOINT g_create_article_version_GRP;

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

2614: -- Standard call to get message count and if count is 1, get message info.
2615: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2616:
2617: IF (l_debug = 'Y') THEN
2618: okc_debug.log('700: Leaving create_article_version', 2);
2619: END IF;
2620:
2621: EXCEPTION
2622: WHEN FND_API.G_EXC_ERROR THEN

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

2620:
2621: EXCEPTION
2622: WHEN FND_API.G_EXC_ERROR THEN
2623: IF (l_debug = 'Y') THEN
2624: okc_debug.log('800: Leaving create_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2625: END IF;
2626: ROLLBACK TO g_create_article_version_GRP;
2627: x_return_status := G_RET_STS_ERROR ;
2628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

2628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2629:
2630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2631: IF (l_debug = 'Y') THEN
2632: okc_debug.log('900: Leaving create_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2633: END IF;
2634: ROLLBACK TO g_create_article_version_GRP;
2635: x_return_status := G_RET_STS_UNEXP_ERROR ;
2636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

2636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2637:
2638: WHEN OTHERS THEN
2639: IF (l_debug = 'Y') THEN
2640: okc_debug.log('1000: Leaving create_article_version because of EXCEPTION: '||sqlerrm, 2);
2641: END IF;
2642:
2643: ROLLBACK TO g_create_article_version_GRP;
2644: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2666: l_api_name CONSTANT VARCHAR2(30) := 'g_lock_article_version';
2667: BEGIN
2668:
2669: IF (l_debug = 'Y') THEN
2670: okc_debug.log('1100: Entered lock_article_version', 2);
2671: END IF;
2672:
2673: -- Standard Start of API savepoint
2674: SAVEPOINT g_lock_article_version_GRP;

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

2702: -- Standard call to get message count and if count is 1, get message info.
2703: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2704:
2705: IF (l_debug = 'Y') THEN
2706: okc_debug.log('1200: Leaving lock_article_version', 2);
2707: END IF;
2708:
2709: EXCEPTION
2710: WHEN FND_API.G_EXC_ERROR THEN

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

2708:
2709: EXCEPTION
2710: WHEN FND_API.G_EXC_ERROR THEN
2711: IF (l_debug = 'Y') THEN
2712: okc_debug.log('1300: Leaving lock_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2713: END IF;
2714: ROLLBACK TO g_lock_article_version_GRP;
2715: x_return_status := G_RET_STS_ERROR ;
2716: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

2716: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2717:
2718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2719: IF (l_debug = 'Y') THEN
2720: okc_debug.log('1400: Leaving lock_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2721: END IF;
2722: ROLLBACK TO g_lock_article_version_GRP;
2723: x_return_status := G_RET_STS_UNEXP_ERROR ;
2724: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

2724: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
2725:
2726: WHEN OTHERS THEN
2727: IF (l_debug = 'Y') THEN
2728: okc_debug.log('1500: Leaving lock_article_version because of EXCEPTION: '||sqlerrm, 2);
2729: END IF;
2730:
2731: ROLLBACK TO g_lock_article_version_GRP;
2732: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2763: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES
2764: WHERE ARTICLE_VERSION_ID = cp_article_version_id;
2765: BEGIN
2766: IF (l_debug = 'Y') THEN
2767: okc_debug.log('1750: Entered update_article_variables', 2);
2768: END IF;
2769: OPEN existing_art_variable_csr(p_article_version_id);
2770: FETCH existing_art_variable_csr BULK COLLECT INTO l_existing_variables_tbl;
2771: CLOSE existing_art_variable_csr;

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

2836: END IF;
2837: END IF;
2838:
2839: IF (l_debug = 'Y') THEN
2840: Okc_Debug.Log('1750: Leaving Update Article variables successfully', 2);
2841: END IF;
2842: x_return_status := G_RET_STS_SUCCESS;
2843:
2844: EXCEPTION

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

2844: EXCEPTION
2845:
2846: WHEN OTHERS THEN
2847: IF (l_debug = 'Y') THEN
2848: okc_debug.log('1750: Leaving update_article_variables because of EXCEPTION: '||sqlerrm, 2);
2849: END IF;
2850: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2851: p_msg_name => G_UNEXPECTED_ERROR,
2852: p_token1 => G_SQLCODE_TOKEN,

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

2945:
2946: BEGIN
2947:
2948: IF (l_debug = 'Y') THEN
2949: okc_debug.log('1600: Entered update_article_version', 2);
2950: okc_debug.log('1700: Locking row', 2);
2951: END IF;
2952:
2953: -- Standard Start of API savepoint

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

2946: BEGIN
2947:
2948: IF (l_debug = 'Y') THEN
2949: okc_debug.log('1600: Entered update_article_version', 2);
2950: okc_debug.log('1700: Locking row', 2);
2951: END IF;
2952:
2953: -- Standard Start of API savepoint
2954: SAVEPOINT g_update_article_version_GRP;

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

3113: -- Standard call to get message count and if count is 1, get message info.
3114: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3115:
3116: IF (l_debug = 'Y') THEN
3117: okc_debug.log('1800: Leaving update_article_version', 2);
3118: END IF;
3119:
3120: EXCEPTION
3121: WHEN FND_API.G_EXC_ERROR THEN

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

3119:
3120: EXCEPTION
3121: WHEN FND_API.G_EXC_ERROR THEN
3122: IF (l_debug = 'Y') THEN
3123: okc_debug.log('1900: Leaving update_article_version: OKC_API.G_EXCEPTION_ERROR Exception', 2);
3124: END IF;
3125: ROLLBACK TO g_update_article_version_GRP;
3126: x_return_status := G_RET_STS_ERROR ;
3127: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

3127: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3128:
3129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3130: IF (l_debug = 'Y') THEN
3131: okc_debug.log('2000: Leaving update_article_version: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3132: END IF;
3133: ROLLBACK TO g_update_article_version_GRP;
3134: x_return_status := G_RET_STS_UNEXP_ERROR ;
3135: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

3135: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3136:
3137: WHEN OTHERS THEN
3138: IF (l_debug = 'Y') THEN
3139: okc_debug.log('2100: Leaving update_article_version because of EXCEPTION: '||sqlerrm, 2);
3140: END IF;
3141:
3142: ROLLBACK TO g_update_article_version_GRP;
3143: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3309: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3310: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3311: BEGIN
3312: IF (l_debug = 'Y') THEN
3313: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);
3314: END IF;
3315: --dbms_output.put_line('2700: Entered Copy_Articles ');
3316:
3317: -- Standard Start of API savepoint

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

3827: -- Standard call to get message count and if count is 1, get message info.
3828: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3829:
3830: IF (l_debug = 'Y') THEN
3831: okc_debug.log('2800: Leaving copy_article', 2);
3832: END IF;
3833:
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN

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

3833:
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN
3836: IF (l_debug = 'Y') THEN
3837: okc_debug.log('2900: Leaving copy_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
3838: END IF;
3839: ROLLBACK TO g_copy_article_GRP;
3840: x_return_status := G_RET_STS_ERROR ;
3841: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

3841: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3842:
3843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3844: IF (l_debug = 'Y') THEN
3845: okc_debug.log('3000: Leaving copy_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
3846: END IF;
3847: ROLLBACK TO g_copy_article_GRP;
3848: x_return_status := G_RET_STS_UNEXP_ERROR ;
3849: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

3849: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
3850:
3851: WHEN OTHERS THEN
3852: IF (l_debug = 'Y') THEN
3853: okc_debug.log('3100: Leaving copy_article because of EXCEPTION: '||sqlerrm, 2);
3854: END IF;
3855:
3856: ROLLBACK TO g_copy_article_GRP;
3857: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3949: END IF;
3950: EXCEPTION
3951: WHEN OTHERS THEN
3952: IF (l_debug = 'Y') THEN
3953: okc_debug.log('500: Leaving get local article id EXCEPTION: '||sqlerrm, 2);
3954: END IF;
3955: IF l_local_article_csr%ISOPEN THEN
3956: CLOSE l_local_article_csr;
3957: END IF;

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

4011: END IF;
4012: EXCEPTION
4013: WHEN OTHERS THEN
4014: IF (l_debug = 'Y') THEN
4015: okc_debug.log('500: Leaving check adopted.. EXCEPTION: '||sqlerrm, 2);
4016: END IF;
4017: IF l_local_article_csr%ISOPEN THEN
4018: CLOSE l_local_article_csr;
4019: END IF;

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

4104:
4105: BEGIN
4106: x_return_status := G_RET_STS_SUCCESS;
4107: IF (l_debug = 'Y') THEN
4108: okc_debug.log('100: Entered auto adopt relationship', 2);
4109: END IF;
4110:
4111: x_return_status := FND_API.G_RET_STS_SUCCESS;
4112: --dbms_output.put_line('Global org is: '|| l_global_org_id);

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

4241: CLOSE l_org_info_csr;
4242: EXCEPTION
4243: WHEN FND_API.G_EXC_ERROR THEN
4244: IF (l_debug = 'Y') THEN
4245: okc_debug.log('300: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4246: END IF;
4247: x_return_status := G_RET_STS_ERROR ;
4248:
4249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4247: x_return_status := G_RET_STS_ERROR ;
4248:
4249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4250: IF (l_debug = 'Y') THEN
4251: okc_debug.log('400: Leaving Auto_Adoption: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4252: END IF;
4253: IF l_org_info_csr%ISOPEN THEN
4254: CLOSE l_org_info_csr;
4255: END IF;

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

4259: x_return_status := G_RET_STS_UNEXP_ERROR ;
4260:
4261: WHEN OTHERS THEN
4262: IF (l_debug = 'Y') THEN
4263: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
4264: END IF;
4265: IF l_org_info_csr%ISOPEN THEN
4266: CLOSE l_org_info_csr;
4267: END IF;

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

4301: l_org_id NUMBER;
4302: BEGIN
4303:
4304: IF (l_debug = 'Y') THEN
4305: okc_debug.log('600: Entered insert_row', 2);
4306: END IF;
4307:
4308: -- Standard Start of API savepoint
4309: SAVEPOINT g_insert_row_GRP;

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

4392: -- Standard call to get message count and if count is 1, get message info.
4393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4394:
4395: IF (l_debug = 'Y') THEN
4396: okc_debug.log('700: Leaving insert_row', 2);
4397: END IF;
4398:
4399: EXCEPTION
4400: WHEN FND_API.G_EXC_ERROR THEN

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

4398:
4399: EXCEPTION
4400: WHEN FND_API.G_EXC_ERROR THEN
4401: IF (l_debug = 'Y') THEN
4402: okc_debug.log('800: Leaving insert_row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4403: END IF;
4404: ROLLBACK TO g_insert_row_GRP;
4405: x_return_status := G_RET_STS_ERROR ;
4406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

4406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4407:
4408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4409: IF (l_debug = 'Y') THEN
4410: okc_debug.log('900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4411: END IF;
4412: ROLLBACK TO g_insert_row_GRP;
4413: x_return_status := G_RET_STS_UNEXP_ERROR ;
4414: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

4414: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4415:
4416: WHEN OTHERS THEN
4417: IF (l_debug = 'Y') THEN
4418: okc_debug.log('1000: Leaving insert_row because of EXCEPTION: '||sqlerrm, 2);
4419: END IF;
4420:
4421: ROLLBACK TO g_insert_row_GRP;
4422: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

4470: */
4471:
4472: BEGIN
4473: IF (l_debug = 'Y') THEN
4474: okc_debug.log('100: Entered create_adoption', 2);
4475: END IF;
4476:
4477: -- Standard Start of API savepoint
4478: -- Initialize API return status to success

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

4518: CLOSE l_relationship_csr;
4519: EXCEPTION
4520: WHEN OTHERS THEN
4521: IF (l_debug = 'Y') THEN
4522: okc_debug.log('500: Leaving Auto_Adoption because of EXCEPTION: '||sqlerrm, 2);
4523: END IF;
4524: IF l_relationship_csr%ISOPEN THEN
4525: CLOSE l_relationship_csr;
4526: END IF;

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

4550: l_api_name CONSTANT VARCHAR2(30) := 'g_delete_row';
4551: BEGIN
4552:
4553: IF (l_debug = 'Y') THEN
4554: okc_debug.log('2200: Entered delete_row', 2);
4555: END IF;
4556:
4557: -- Standard Start of API savepoint
4558: SAVEPOINT g_delete_row_GRP;

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

4631: -- Standard call to get message count and if count is 1, get message info.
4632: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4633:
4634: IF (l_debug = 'Y') THEN
4635: okc_debug.log('2300: Leaving delete_row', 2);
4636: END IF;
4637:
4638: EXCEPTION
4639: WHEN FND_API.G_EXC_ERROR THEN

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

4637:
4638: EXCEPTION
4639: WHEN FND_API.G_EXC_ERROR THEN
4640: IF (l_debug = 'Y') THEN
4641: okc_debug.log('2400: Leaving delete_Row: OKC_API.G_EXCEPTION_ERROR Exception', 2);
4642: END IF;
4643: ROLLBACK TO g_delete_row_GRP;
4644: x_return_status := G_RET_STS_ERROR ;
4645: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

4645: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4646:
4647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4648: IF (l_debug = 'Y') THEN
4649: okc_debug.log('2500: Leaving delete_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
4650: END IF;
4651: ROLLBACK TO g_delete_row_GRP;
4652: x_return_status := G_RET_STS_UNEXP_ERROR ;
4653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );

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

4653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
4654:
4655: WHEN OTHERS THEN
4656: IF (l_debug = 'Y') THEN
4657: okc_debug.log('2600: Leaving delete_Row because of EXCEPTION: '||sqlerrm, 2);
4658: END IF;
4659:
4660: ROLLBACK TO g_delete_row_GRP;
4661: x_return_status := G_RET_STS_UNEXP_ERROR ;