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_TERMS_MULTIREC_GRP dependencies on OKC_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_MULTIREC_GRP';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_MULTIREC_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

Line 295: p_init_msg_list => OKC_API.G_FALSE,

291: END IF;
292:
293: OKC_K_ARTICLES_GRP.update_article(
294: p_api_version =>1,
295: p_init_msg_list => OKC_API.G_FALSE,
296: x_return_status => x_return_status,
297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data,
299: p_id => scn_child_tbl(k).id,

Line 323: p_init_msg_list => OKC_API.G_FALSE,

319: END IF;
320:
321: OKC_TERMS_SECTIONS_GRP.update_section(
322: p_api_version =>1,
323: p_init_msg_list => OKC_API.G_FALSE,
324: x_return_status => x_return_status,
325: x_msg_count => x_msg_count,
326: x_msg_data => x_msg_data,
327: p_id => scn_child_tbl(k).id,

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

359:
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: /*IF (l_debug = 'Y') THEN
363: okc_debug.log('300: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
364: END IF;*/
365:
366: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
367: FND_LOG.STRING(G_EXCP_LEVEL,

Line 368: G_PKG_NAME, '300: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception' );

364: END IF;*/
365:
366: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
367: FND_LOG.STRING(G_EXCP_LEVEL,
368: G_PKG_NAME, '300: Leaving create_article: OKC_API.G_EXCEPTION_ERROR Exception' );
369: END IF;
370:
371: IF l_get_scn_child_csr%ISOPEN THEN
372: CLOSE l_get_scn_child_csr;

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

381: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: /*IF (l_debug = 'Y') THEN
385: okc_debug.log('400: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
386: END IF;*/
387:
388: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
389: FND_LOG.STRING(G_EXCP_LEVEL,

Line 390: G_PKG_NAME, '400: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

386: END IF;*/
387:
388: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
389: FND_LOG.STRING(G_EXCP_LEVEL,
390: G_PKG_NAME, '400: Leaving create_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
391: END IF;
392:
393: IF l_get_scn_child_csr%ISOPEN THEN
394: CLOSE l_get_scn_child_csr;

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

628:
629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: /*IF (l_debug = 'Y') THEN
632: okc_debug.log('300: Leaving update_article_variable: OKC_API.G_EXCEPTION_ERROR Exception', 2);
633: END IF;*/
634:
635: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
636: FND_LOG.STRING(G_EXCP_LEVEL,

Line 637: G_PKG_NAME, '300: Leaving update_article_variable: OKC_API.G_EXCEPTION_ERROR Exception' );

633: END IF;*/
634:
635: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
636: FND_LOG.STRING(G_EXCP_LEVEL,
637: G_PKG_NAME, '300: Leaving update_article_variable: OKC_API.G_EXCEPTION_ERROR Exception' );
638: END IF;
639:
640: IF l_doc_csr%ISOPEN THEN
641: CLOSE l_doc_csr;

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

646: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: /*IF (l_debug = 'Y') THEN
650: okc_debug.log('400: Leaving update_article_variable: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
651: END IF;*/
652:
653: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
654: FND_LOG.STRING(G_EXCP_LEVEL,

Line 655: G_PKG_NAME, '400: Leaving update_article_variable: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

651: END IF;*/
652:
653: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
654: FND_LOG.STRING(G_EXCP_LEVEL,
655: G_PKG_NAME, '400: Leaving update_article_variable: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
656: END IF;
657:
658: IF l_doc_csr%ISOPEN THEN
659: CLOSE l_doc_csr;

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

875:
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
878: /*IF (l_debug = 'Y') THEN
879: okc_debug.log('300: Leaving update_structure: OKC_API.G_EXCEPTION_ERROR Exception', 2);
880: END IF;*/
881:
882: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
883: FND_LOG.STRING(G_EXCP_LEVEL,

Line 884: G_PKG_NAME, '300: Leaving update_structure: OKC_API.G_EXCEPTION_ERROR Exception' );

880: END IF;*/
881:
882: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
883: FND_LOG.STRING(G_EXCP_LEVEL,
884: G_PKG_NAME, '300: Leaving update_structure: OKC_API.G_EXCEPTION_ERROR Exception' );
885: END IF;
886:
887: IF l_doc_art_csr%ISOPEN THEN
888: CLOSE l_doc_art_csr;

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

897: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: /*IF (l_debug = 'Y') THEN
901: okc_debug.log('400: Leaving update_structure: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
902: END IF;*/
903:
904: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
905: FND_LOG.STRING(G_EXCP_LEVEL,

Line 906: G_PKG_NAME, '400: Leaving update_structure: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

902: END IF;*/
903:
904: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
905: FND_LOG.STRING(G_EXCP_LEVEL,
906: G_PKG_NAME, '400: Leaving update_structure: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
907: END IF;
908:
909: IF l_doc_art_csr%ISOPEN THEN
910: CLOSE l_doc_art_csr;

Line 1459: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1455: So we will decide the number of articles dropped for now
1456: l_art_title := okc_terms_util_pvt.get_article_name
1457: (l_article_rec.article_id,
1458: l_article_rec.article_version_id);
1459: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1460: p_msg_name => 'OKC_PROV_ART_DROPPED',
1461: p_token1 => 'ARTICLE_TITLE',
1462: p_token1_value => l_art_title,
1463: p_token2 => 'DOCUMENT_TYPE',

Line 1661: p_init_msg_list => OKC_API.G_FALSE,

1657: l_section_id:=articles_order_art_num.scn_id;
1658: END IF;
1659: OKC_K_ARTICLES_GRP.update_article(
1660: p_api_version =>1,
1661: p_init_msg_list => OKC_API.G_FALSE,
1662: x_return_status => x_return_status,
1663: x_msg_count => l_msg_count,
1664: x_msg_data => l_msg_data,
1665: p_id => articles_order_art_num.id,

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

1780:
1781: EXCEPTION
1782: WHEN FND_API.G_EXC_ERROR THEN
1783: /*IF (l_debug = 'Y') THEN
1784: okc_debug.log('300: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1785: END IF;*/
1786:
1787: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1788: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1789: G_PKG_NAME, '300: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_ERROR Exception' );

1785: END IF;*/
1786:
1787: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1788: FND_LOG.STRING(G_EXCP_LEVEL,
1789: G_PKG_NAME, '300: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_ERROR Exception' );
1790: END IF;
1791:
1792: IF l_get_max_local_article_csr%ISOPEN THEN
1793: CLOSE l_get_max_local_article_csr;

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

1838: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1839:
1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1841: /*IF (l_debug = 'Y') THEN
1842: okc_debug.log('400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1843: END IF;*/
1844:
1845: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1846: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1847: G_PKG_NAME, '400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

1843: END IF;*/
1844:
1845: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1846: FND_LOG.STRING(G_EXCP_LEVEL,
1847: G_PKG_NAME, '400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1848: END IF;
1849:
1850: IF l_get_max_local_article_csr%ISOPEN THEN
1851: CLOSE l_get_max_local_article_csr;

Line 1952: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1948: IF l_get_art_seq_csr%ISOPEN THEN
1949: CLOSE l_get_art_seq_csr;
1950: END IF;
1951:
1952: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1953: p_msg_name => G_UNEXPECTED_ERROR,
1954: p_token1 => G_SQLCODE_TOKEN,
1955: p_token1_value => sqlcode,
1956: p_token2 => G_SQLERRM_TOKEN,

Line 2082: p_init_msg_list => OKC_API.G_FALSE,

2078:
2079: IF l_dummy <>'?' THEN
2080: OKC_K_ARTICLES_GRP.update_article(
2081: p_api_version =>1,
2082: p_init_msg_list => OKC_API.G_FALSE,
2083: x_return_status => x_return_status,
2084: x_msg_count => x_msg_count,
2085: x_msg_data => x_msg_data,
2086: p_mode => p_mode,

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

2120:
2121: EXCEPTION
2122: WHEN FND_API.G_EXC_ERROR THEN
2123: /*IF (l_debug = 'Y') THEN
2124: okc_debug.log('300: Leaving refresh_articles: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2125: END IF;*/
2126:
2127: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2128: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2129: G_PKG_NAME, '300: Leaving refresh_articles: OKC_API.G_EXCEPTION_ERROR Exception' );

2125: END IF;*/
2126:
2127: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2128: FND_LOG.STRING(G_EXCP_LEVEL,
2129: G_PKG_NAME, '300: Leaving refresh_articles: OKC_API.G_EXCEPTION_ERROR Exception' );
2130: END IF;
2131:
2132: IF l_check_version%ISOPEN THEN
2133: close l_check_version;

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

2138: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2139:
2140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2141: /*IF (l_debug = 'Y') THEN
2142: okc_debug.log('400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2143: END IF;*/
2144:
2145: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2146: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2147: G_PKG_NAME, '400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

2143: END IF;*/
2144:
2145: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2146: FND_LOG.STRING(G_EXCP_LEVEL,
2147: G_PKG_NAME, '400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
2148: END IF;
2149:
2150: IF l_check_version%ISOPEN THEN
2151: close l_check_version;

Line 2173: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2169: close l_check_version;
2170: END IF;
2171:
2172:
2173: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2174: p_msg_name => G_UNEXPECTED_ERROR,
2175: p_token1 => G_SQLCODE_TOKEN,
2176: p_token1_value => sqlcode,
2177: p_token2 => G_SQLERRM_TOKEN,

Line 2368: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');

2364: FND_LOG.STRING(G_PROC_LEVEL,
2365: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
2366: END IF;
2367:
2368: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');
2369: RAISE FND_API.G_EXC_ERROR ;
2370:
2371: END IF;
2372:

Line 2383: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2379: FND_LOG.STRING(G_PROC_LEVEL,
2380: G_PKG_NAME, '300: Wrong Selection of Item Location' );
2381: END IF;
2382:
2383: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2384: p_msg_name => 'OKC_WRONG_ITEM_LOCATION'
2385: );
2386:
2387: RAISE FND_API.G_EXC_ERROR ;

Line 2400: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2396: FND_LOG.STRING(G_PROC_LEVEL,
2397: G_PKG_NAME, '400: Wrong Selection of Item Location' );
2398: END IF;
2399:
2400: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2401: p_msg_name => 'OKC_WRONG_ITEM_LOCATION1'
2402: );
2403:
2404: RAISE FND_API.G_EXC_ERROR ;

Line 2421: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2417: FND_LOG.STRING(G_PROC_LEVEL,
2418: G_PKG_NAME, '500: Wrong Selection ' );
2419: END IF;
2420:
2421: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2422: p_msg_name => 'OKC_WRONG_SELECTION'
2423: );
2424: RAISE FND_API.G_EXC_ERROR ;
2425: END IF;

Line 2569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2565: G_PKG_NAME, '600: Updating Display Sequence of cat_id '||p_organize_tbl(i).id );
2566: END IF;
2567:
2568: IF l_parent_scn_id IS NULL THEN
2569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2570: p_msg_name => 'OKC_ART_MOVE_TO_DOC'
2571: );
2572: RAISE FND_API.G_EXC_ERROR ;
2573: END IF;

Line 2578: p_init_msg_list => OKC_API.G_FALSE,

2574: l_ref_sequence := l_ref_sequence+10;
2575:
2576: OKC_K_ARTICLES_GRP.update_article(
2577: p_api_version =>1,
2578: p_init_msg_list => OKC_API.G_FALSE,
2579: x_return_status => x_return_status,
2580: x_msg_count => x_msg_count,
2581: x_msg_data => x_msg_data,
2582: p_id => p_organize_tbl(i).id,

Line 2608: p_init_msg_list => OKC_API.G_FALSE,

2604:
2605: l_ref_sequence := l_ref_sequence+10;
2606: OKC_TERMS_SECTIONS_GRP.update_section(
2607: p_api_version =>1,
2608: p_init_msg_list => OKC_API.G_FALSE,
2609: x_return_status => x_return_status,
2610: x_msg_count => x_msg_count,
2611: x_msg_data => x_msg_data,
2612: p_id => p_organize_tbl(i).id,

Line 2613: p_scn_id => nvl(l_parent_scn_id,OKC_API.G_MISS_NUM),

2609: x_return_status => x_return_status,
2610: x_msg_count => x_msg_count,
2611: x_msg_data => x_msg_data,
2612: p_id => p_organize_tbl(i).id,
2613: p_scn_id => nvl(l_parent_scn_id,OKC_API.G_MISS_NUM),
2614: p_section_sequence => l_ref_sequence,
2615: p_object_version_number =>Null
2616: );
2617: --------------------------------------------

Line 2659: p_init_msg_list => OKC_API.G_FALSE,

2655: END IF;
2656:
2657: OKC_K_ARTICLES_GRP.update_article(
2658: p_api_version =>1,
2659: p_init_msg_list => OKC_API.G_FALSE,
2660: x_return_status => x_return_status,
2661: x_msg_count => x_msg_count,
2662: x_msg_data => x_msg_data,
2663: p_id => scn_child_tbl(k).id,

Line 2687: p_init_msg_list => OKC_API.G_FALSE,

2683: END IF;
2684:
2685: OKC_TERMS_SECTIONS_GRP.update_section(
2686: p_api_version =>1,
2687: p_init_msg_list => OKC_API.G_FALSE,
2688: x_return_status => x_return_status,
2689: x_msg_count => x_msg_count,
2690: x_msg_data => x_msg_data,
2691: p_id => scn_child_tbl(k).id,

Line 2728: okc_debug.log('1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception', 2);

2724:
2725: EXCEPTION
2726: WHEN FND_API.G_EXC_ERROR THEN
2727: /*IF (l_debug = 'Y') THEN
2728: okc_debug.log('1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2729: END IF;*/
2730:
2731: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2732: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2733: G_PKG_NAME, '1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception' );

2729: END IF;*/
2730:
2731: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2732: FND_LOG.STRING(G_EXCP_LEVEL,
2733: G_PKG_NAME, '1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception' );
2734: END IF;
2735:
2736: IF l_get_scn_child%ISOPEN THEN
2737: CLOSE l_get_scn_child;

Line 2762: okc_debug.log('1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

2758: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2759:
2760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2761: /*IF (l_debug = 'Y') THEN
2762: okc_debug.log('1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2763: END IF;*/
2764:
2765: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2766: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2767: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

2763: END IF;*/
2764:
2765: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2766: FND_LOG.STRING(G_EXCP_LEVEL,
2767: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
2768: END IF;
2769:
2770: IF l_get_scn_child%ISOPEN THEN
2771: CLOSE l_get_scn_child;

Line 2824: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2820: IF l_get_max_seq_csr%ISOPEN THEN
2821: CLOSE l_get_scn_child;
2822: END IF;
2823:
2824: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2825: p_msg_name => G_UNEXPECTED_ERROR,
2826: p_token1 => G_SQLCODE_TOKEN,
2827: p_token1_value => sqlcode,
2828: p_token2 => G_SQLERRM_TOKEN,

Line 3003: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2999: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3000: FND_LOG.STRING(G_PROC_LEVEL,
3001: G_PKG_NAME, '500: Wrong Selection ' );
3002: END IF;
3003: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3004: p_msg_name => 'OKC_WRONG_SELECTION'
3005: );
3006: RAISE FND_API.G_EXC_ERROR ;
3007: END IF;

Line 3022: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3018: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3019: FND_LOG.STRING(G_PROC_LEVEL,
3020: G_PKG_NAME, '500: Article is IBR enabled ' );
3021: END IF;
3022: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3023: p_msg_name => 'OKC_ARTICLE_IS_IBR'
3024: );
3025: RAISE FND_API.G_EXC_ERROR ;
3026: END IF;

Line 3034: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3030: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3031: FND_LOG.STRING(G_PROC_LEVEL,
3032: G_PKG_NAME, '500: Article is Text Locked ' );
3033: END IF;
3034: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3035: p_msg_name => 'OKC_ARTICLE_IS_LOCK_TEXT');
3036: RAISE FND_API.G_EXC_ERROR ;
3037: END IF;
3038:

Line 3049: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3045: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3046: FND_LOG.STRING(G_PROC_LEVEL,
3047: G_PKG_NAME, '500: Wrong Selection ' );
3048: END IF;
3049: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3050: p_msg_name => 'OKC_WRONG_SELECTION');
3051: RAISE FND_API.G_EXC_ERROR ;
3052: END IF;
3053: OPEN article_properties(p_merge_review_tbl(i).review_upld_terms_id);

Line 3064: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3060: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3061: FND_LOG.STRING(G_PROC_LEVEL,
3062: G_PKG_NAME, '500: Article is Mandatory ' );
3063: END IF;
3064: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3065: p_msg_name => 'OKC_REVIEW_MERGE_MANDATORY'
3066: );
3067: RAISE FND_API.G_EXC_ERROR ;
3068: END IF;

Line 3208: G_PKG_NAME, '1100: Leaving merge_review_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );

3204: WHEN FND_API.G_EXC_ERROR THEN
3205:
3206: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3207: FND_LOG.STRING(G_EXCP_LEVEL,
3208: G_PKG_NAME, '1100: Leaving merge_review_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );
3209: END IF;
3210:
3211: IF article_properties%ISOPEN THEN
3212: CLOSE article_properties;

Line 3225: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

3221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3222:
3223: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3224: FND_LOG.STRING(G_EXCP_LEVEL,
3225: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
3226: END IF;
3227:
3228: IF article_properties%ISOPEN THEN
3229: CLOSE article_properties;

Line 3248: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3244: IF article_properties%ISOPEN THEN
3245: CLOSE article_properties;
3246: END IF;
3247:
3248: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3249: p_msg_name => G_UNEXPECTED_ERROR,
3250: p_token1 => G_SQLCODE_TOKEN,
3251: p_token1_value => sqlcode,
3252: p_token2 => G_SQLERRM_TOKEN,

Line 3377: p_init_msg_list => OKC_API.G_FALSE,

3373: l_section_id:=cont_art_tbl(i).scn_id;
3374: END IF;
3375: OKC_K_ARTICLES_GRP.update_article(
3376: p_api_version =>1,
3377: p_init_msg_list => OKC_API.G_FALSE,
3378: x_return_status => x_return_status,
3379: x_msg_count => x_msg_count,
3380: x_msg_data => x_msg_data,
3381: p_id => cont_art_tbl(i).id,

Line 3460: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3456: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3457: FND_LOG.STRING(G_EXCP_LEVEL,
3458: G_PKG_NAME, '1300: Leaving sort_clauses because of EXCEPTION: '||sqlerrm );
3459: END IF;
3460: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3461: p_msg_name => G_UNEXPECTED_ERROR,
3462: p_token1 => G_SQLCODE_TOKEN,
3463: p_token1_value => sqlcode,
3464: p_token2 => G_SQLERRM_TOKEN,