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 630: okc_debug.log('300: Leaving update_article_variable: OKC_API.G_EXCEPTION_ERROR Exception', 2);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1431: So we will decide the number of articles dropped for now
1432: l_art_title := okc_terms_util_pvt.get_article_name
1433: (l_article_rec.article_id,
1434: l_article_rec.article_version_id);
1435: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1436: p_msg_name => 'OKC_PROV_ART_DROPPED',
1437: p_token1 => 'ARTICLE_TITLE',
1438: p_token1_value => l_art_title,
1439: p_token2 => 'DOCUMENT_TYPE',

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

1669:
1670: EXCEPTION
1671: WHEN FND_API.G_EXC_ERROR THEN
1672: /*IF (l_debug = 'Y') THEN
1673: okc_debug.log('300: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1674: END IF;*/
1675:
1676: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1677: FND_LOG.STRING(G_EXCP_LEVEL,

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

1674: END IF;*/
1675:
1676: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1677: FND_LOG.STRING(G_EXCP_LEVEL,
1678: G_PKG_NAME, '300: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_ERROR Exception' );
1679: END IF;
1680:
1681: IF l_get_max_local_article_csr%ISOPEN THEN
1682: CLOSE l_get_max_local_article_csr;

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

1727: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: /*IF (l_debug = 'Y') THEN
1731: okc_debug.log('400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1732: END IF;*/
1733:
1734: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1735: FND_LOG.STRING(G_EXCP_LEVEL,

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

1732: END IF;*/
1733:
1734: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1735: FND_LOG.STRING(G_EXCP_LEVEL,
1736: G_PKG_NAME, '400: Leaving sync_doc_with_expert: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1737: END IF;
1738:
1739: IF l_get_max_local_article_csr%ISOPEN THEN
1740: CLOSE l_get_max_local_article_csr;

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

1837: IF l_get_art_seq_csr%ISOPEN THEN
1838: CLOSE l_get_art_seq_csr;
1839: END IF;
1840:
1841: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1842: p_msg_name => G_UNEXPECTED_ERROR,
1843: p_token1 => G_SQLCODE_TOKEN,
1844: p_token1_value => sqlcode,
1845: p_token2 => G_SQLERRM_TOKEN,

Line 1970: p_init_msg_list => OKC_API.G_FALSE,

1966:
1967: IF l_dummy <>'?' THEN
1968: OKC_K_ARTICLES_GRP.update_article(
1969: p_api_version =>1,
1970: p_init_msg_list => OKC_API.G_FALSE,
1971: x_return_status => x_return_status,
1972: x_msg_count => x_msg_count,
1973: x_msg_data => x_msg_data,
1974: p_mode => p_mode,

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

2007:
2008: EXCEPTION
2009: WHEN FND_API.G_EXC_ERROR THEN
2010: /*IF (l_debug = 'Y') THEN
2011: okc_debug.log('300: Leaving refresh_articles: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2012: END IF;*/
2013:
2014: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2015: FND_LOG.STRING(G_EXCP_LEVEL,

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

2012: END IF;*/
2013:
2014: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2015: FND_LOG.STRING(G_EXCP_LEVEL,
2016: G_PKG_NAME, '300: Leaving refresh_articles: OKC_API.G_EXCEPTION_ERROR Exception' );
2017: END IF;
2018:
2019: IF l_check_version%ISOPEN THEN
2020: close l_check_version;

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

2025: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2026:
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: /*IF (l_debug = 'Y') THEN
2029: okc_debug.log('400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2030: END IF;*/
2031:
2032: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2033: FND_LOG.STRING(G_EXCP_LEVEL,

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

2030: END IF;*/
2031:
2032: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2033: FND_LOG.STRING(G_EXCP_LEVEL,
2034: G_PKG_NAME, '400: Leaving refresh_articles: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
2035: END IF;
2036:
2037: IF l_check_version%ISOPEN THEN
2038: close l_check_version;

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

2056: close l_check_version;
2057: END IF;
2058:
2059:
2060: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2061: p_msg_name => G_UNEXPECTED_ERROR,
2062: p_token1 => G_SQLCODE_TOKEN,
2063: p_token1_value => sqlcode,
2064: p_token2 => G_SQLERRM_TOKEN,

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

2251: FND_LOG.STRING(G_PROC_LEVEL,
2252: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
2253: END IF;
2254:
2255: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');
2256: RAISE FND_API.G_EXC_ERROR ;
2257:
2258: END IF;
2259:

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

2266: FND_LOG.STRING(G_PROC_LEVEL,
2267: G_PKG_NAME, '300: Wrong Selection of Item Location' );
2268: END IF;
2269:
2270: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2271: p_msg_name => 'OKC_WRONG_ITEM_LOCATION'
2272: );
2273:
2274: RAISE FND_API.G_EXC_ERROR ;

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

2283: FND_LOG.STRING(G_PROC_LEVEL,
2284: G_PKG_NAME, '400: Wrong Selection of Item Location' );
2285: END IF;
2286:
2287: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2288: p_msg_name => 'OKC_WRONG_ITEM_LOCATION1'
2289: );
2290:
2291: RAISE FND_API.G_EXC_ERROR ;

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

2304: FND_LOG.STRING(G_PROC_LEVEL,
2305: G_PKG_NAME, '500: Wrong Selection ' );
2306: END IF;
2307:
2308: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2309: p_msg_name => 'OKC_WRONG_SELECTION'
2310: );
2311: RAISE FND_API.G_EXC_ERROR ;
2312: END IF;

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

2452: G_PKG_NAME, '600: Updating Display Sequence of cat_id '||p_organize_tbl(i).id );
2453: END IF;
2454:
2455: IF l_parent_scn_id IS NULL THEN
2456: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2457: p_msg_name => 'OKC_ART_MOVE_TO_DOC'
2458: );
2459: RAISE FND_API.G_EXC_ERROR ;
2460: END IF;

Line 2465: p_init_msg_list => OKC_API.G_FALSE,

2461: l_ref_sequence := l_ref_sequence+10;
2462:
2463: OKC_K_ARTICLES_GRP.update_article(
2464: p_api_version =>1,
2465: p_init_msg_list => OKC_API.G_FALSE,
2466: x_return_status => x_return_status,
2467: x_msg_count => x_msg_count,
2468: x_msg_data => x_msg_data,
2469: p_id => p_organize_tbl(i).id,

Line 2495: p_init_msg_list => OKC_API.G_FALSE,

2491:
2492: l_ref_sequence := l_ref_sequence+10;
2493: OKC_TERMS_SECTIONS_GRP.update_section(
2494: p_api_version =>1,
2495: p_init_msg_list => OKC_API.G_FALSE,
2496: x_return_status => x_return_status,
2497: x_msg_count => x_msg_count,
2498: x_msg_data => x_msg_data,
2499: p_id => p_organize_tbl(i).id,

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

2496: x_return_status => x_return_status,
2497: x_msg_count => x_msg_count,
2498: x_msg_data => x_msg_data,
2499: p_id => p_organize_tbl(i).id,
2500: p_scn_id => nvl(l_parent_scn_id,OKC_API.G_MISS_NUM),
2501: p_section_sequence => l_ref_sequence,
2502: p_object_version_number =>Null
2503: );
2504: --------------------------------------------

Line 2546: p_init_msg_list => OKC_API.G_FALSE,

2542: END IF;
2543:
2544: OKC_K_ARTICLES_GRP.update_article(
2545: p_api_version =>1,
2546: p_init_msg_list => OKC_API.G_FALSE,
2547: x_return_status => x_return_status,
2548: x_msg_count => x_msg_count,
2549: x_msg_data => x_msg_data,
2550: p_id => scn_child_tbl(k).id,

Line 2574: p_init_msg_list => OKC_API.G_FALSE,

2570: END IF;
2571:
2572: OKC_TERMS_SECTIONS_GRP.update_section(
2573: p_api_version =>1,
2574: p_init_msg_list => OKC_API.G_FALSE,
2575: x_return_status => x_return_status,
2576: x_msg_count => x_msg_count,
2577: x_msg_data => x_msg_data,
2578: p_id => scn_child_tbl(k).id,

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

2611:
2612: EXCEPTION
2613: WHEN FND_API.G_EXC_ERROR THEN
2614: /*IF (l_debug = 'Y') THEN
2615: okc_debug.log('1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception', 2);
2616: END IF;*/
2617:
2618: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2619: FND_LOG.STRING(G_EXCP_LEVEL,

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

2616: END IF;*/
2617:
2618: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2619: FND_LOG.STRING(G_EXCP_LEVEL,
2620: G_PKG_NAME, '1100: Leaving organize_layout: OKC_API.G_EXCEPTION_ERROR Exception' );
2621: END IF;
2622:
2623: IF l_get_scn_child%ISOPEN THEN
2624: CLOSE l_get_scn_child;

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

2645: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2646:
2647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2648: /*IF (l_debug = 'Y') THEN
2649: okc_debug.log('1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
2650: END IF;*/
2651:
2652: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2653: FND_LOG.STRING(G_EXCP_LEVEL,

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

2650: END IF;*/
2651:
2652: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2653: FND_LOG.STRING(G_EXCP_LEVEL,
2654: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
2655: END IF;
2656:
2657: IF l_get_scn_child%ISOPEN THEN
2658: CLOSE l_get_scn_child;

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

2707: IF l_get_max_seq_csr%ISOPEN THEN
2708: CLOSE l_get_scn_child;
2709: END IF;
2710:
2711: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2712: p_msg_name => G_UNEXPECTED_ERROR,
2713: p_token1 => G_SQLCODE_TOKEN,
2714: p_token1_value => sqlcode,
2715: p_token2 => G_SQLERRM_TOKEN,

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

2886: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2887: FND_LOG.STRING(G_PROC_LEVEL,
2888: G_PKG_NAME, '500: Wrong Selection ' );
2889: END IF;
2890: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2891: p_msg_name => 'OKC_WRONG_SELECTION'
2892: );
2893: RAISE FND_API.G_EXC_ERROR ;
2894: END IF;

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

2905: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2906: FND_LOG.STRING(G_PROC_LEVEL,
2907: G_PKG_NAME, '500: Article is IBR enabled ' );
2908: END IF;
2909: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2910: p_msg_name => 'OKC_ARTICLE_IS_IBR'
2911: );
2912: RAISE FND_API.G_EXC_ERROR ;
2913: END IF;

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

2917: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2918: FND_LOG.STRING(G_PROC_LEVEL,
2919: G_PKG_NAME, '500: Article is Text Locked ' );
2920: END IF;
2921: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2922: p_msg_name => 'OKC_ARTICLE_IS_LOCK_TEXT');
2923: RAISE FND_API.G_EXC_ERROR ;
2924: END IF;
2925:

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

2932: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2933: FND_LOG.STRING(G_PROC_LEVEL,
2934: G_PKG_NAME, '500: Wrong Selection ' );
2935: END IF;
2936: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2937: p_msg_name => 'OKC_WRONG_SELECTION');
2938: RAISE FND_API.G_EXC_ERROR ;
2939: END IF;
2940: OPEN article_properties(p_merge_review_tbl(i).review_upld_terms_id);

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

2947: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2948: FND_LOG.STRING(G_PROC_LEVEL,
2949: G_PKG_NAME, '500: Article is Mandatory ' );
2950: END IF;
2951: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2952: p_msg_name => 'OKC_REVIEW_MERGE_MANDATORY'
2953: );
2954: RAISE FND_API.G_EXC_ERROR ;
2955: END IF;

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

3091: WHEN FND_API.G_EXC_ERROR THEN
3092:
3093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3094: FND_LOG.STRING(G_EXCP_LEVEL,
3095: G_PKG_NAME, '1100: Leaving merge_review_clauses: OKC_API.G_EXCEPTION_ERROR Exception' );
3096: END IF;
3097:
3098: IF article_properties%ISOPEN THEN
3099: CLOSE article_properties;

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

3108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3109:
3110: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3111: FND_LOG.STRING(G_EXCP_LEVEL,
3112: G_PKG_NAME, '1200: Leaving organize_layout: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
3113: END IF;
3114:
3115: IF article_properties%ISOPEN THEN
3116: CLOSE article_properties;

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

3131: IF article_properties%ISOPEN THEN
3132: CLOSE article_properties;
3133: END IF;
3134:
3135: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3136: p_msg_name => G_UNEXPECTED_ERROR,
3137: p_token1 => G_SQLCODE_TOKEN,
3138: p_token1_value => sqlcode,
3139: p_token2 => G_SQLERRM_TOKEN,