DBA Data[Home] [Help]

APPS.OKC_K_NON_STD_ART_GRP dependencies on FND_LOG

Line 33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

29: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: Procedure create_non_std_article(

Line 34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

30: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: Procedure create_non_std_article(
38: p_api_version IN NUMBER,

Line 35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

31: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
32:
33: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
36:
37: Procedure create_non_std_article(
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2,

Line 103: FND_LOG.STRING(G_PROC_LEVEL,

99: okc_debug.log('100: Entered create_non_std_article', 2);
100: END IF;*/
101:
102: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
103: FND_LOG.STRING(G_PROC_LEVEL,
104: G_PKG_NAME, '100: Entered create_non_std_article' );
105: END IF;
106:
107: -- Standard Start of API savepoint

Line 135: FND_LOG.STRING(G_PROC_LEVEL,

131: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
132: END IF;*/
133:
134: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
135: FND_LOG.STRING(G_PROC_LEVEL,
136: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
137: END IF;
138: RAISE FND_API.G_EXC_ERROR ;
139: END IF;

Line 150: FND_LOG.STRING(G_PROC_LEVEL,

146: okc_debug.log('200: Creating non-std article', 2);
147: END IF;*/
148:
149: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
150: FND_LOG.STRING(G_PROC_LEVEL,
151: G_PKG_NAME, '200: Creating non-std article' );
152: END IF;
153: OPEN l_get_intent_csr;
154: FETCH l_get_intent_csr INTO l_intent;

Line 224: FND_LOG.STRING(G_PROC_LEVEL,

220: okc_debug.log('300: non-std article created.Version id is '||x_article_version_id, 2);
221: END IF;*/
222:
223: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
224: FND_LOG.STRING(G_PROC_LEVEL,
225: G_PKG_NAME, '300: non-std article created.Version id is '||x_article_version_id );
226: END IF;
227:
228: IF p_cat_id IS NOT NULL THEN

Line 235: FND_LOG.STRING(G_PROC_LEVEL,

231: okc_debug.log('400: Updating k article record', 2);
232: END IF;*/
233:
234: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
235: FND_LOG.STRING(G_PROC_LEVEL,
236: G_PKG_NAME, '400: Updating k article record' );
237: END IF;
238:
239: OKC_K_ARTICLES_GRP.update_article(

Line 284: FND_LOG.STRING(G_PROC_LEVEL,

280: okc_debug.log('500: Creating k article record', 2);
281: END IF;*/
282:
283: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
284: FND_LOG.STRING(G_PROC_LEVEL,
285: G_PKG_NAME, '500: Creating k article record' );
286: END IF;
287:
288: OKC_TERMS_MULTIREC_GRP.create_article(

Line 333: FND_LOG.STRING(G_PROC_LEVEL,

329: okc_debug.log('900: Leaving create_non_std_article', 2);
330: END IF;*/
331:
332: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
333: FND_LOG.STRING(G_PROC_LEVEL,
334: G_PKG_NAME, '900: Leaving create_non_std_article' );
335: END IF;
336:
337: EXCEPTION

Line 344: FND_LOG.STRING(G_EXCP_LEVEL,

340: okc_debug.log('300: Leaving create_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
341: END IF;*/
342:
343: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
344: FND_LOG.STRING(G_EXCP_LEVEL,
345: G_PKG_NAME, '300: Leaving create_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception' );
346: END IF;
347:
348: IF l_get_intent_csr%ISOPEN THEN

Line 362: FND_LOG.STRING(G_EXCP_LEVEL,

358: okc_debug.log('400: Leaving create_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
359: END IF;*/
360:
361: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
362: FND_LOG.STRING(G_EXCP_LEVEL,
363: G_PKG_NAME, '400: Leaving create_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
364: END IF;
365:
366: IF l_get_intent_csr%ISOPEN THEN

Line 380: FND_LOG.STRING(G_EXCP_LEVEL,

376: okc_debug.log('500: Leaving create_non_std_article because of EXCEPTION: '||sqlerrm, 2);
377: END IF;*/
378:
379: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
380: FND_LOG.STRING(G_EXCP_LEVEL,
381: G_PKG_NAME, '500: Leaving create_non_std_article because of EXCEPTION: '||sqlerrm );
382: END IF;
383:
384: IF l_get_intent_csr%ISOPEN THEN

Line 455: FND_LOG.STRING(G_PROC_LEVEL,

451: okc_debug.log('100: Entered update_non_std_article', 2);
452: END IF;*/
453:
454: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
455: FND_LOG.STRING(G_PROC_LEVEL,
456: G_PKG_NAME, '100: Entered update_non_std_article' );
457: END IF;
458:
459: -- Standard Start of API savepoint

Line 487: FND_LOG.STRING(G_PROC_LEVEL,

483: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
484: END IF;*/
485:
486: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
487: FND_LOG.STRING(G_PROC_LEVEL,
488: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
489: END IF;
490: RAISE FND_API.G_EXC_ERROR ;
491: END IF;

Line 502: FND_LOG.STRING(G_PROC_LEVEL,

498: okc_debug.log('200: Updating non-std article', 2);
499: END IF;*/
500:
501: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
502: FND_LOG.STRING(G_PROC_LEVEL,
503: G_PKG_NAME, '200: Updating non-std article' );
504: END IF;
505:
506: OPEN l_get_kart_dtl_csr;

Line 614: FND_LOG.STRING(G_PROC_LEVEL,

610: okc_debug.log('300: non-std article created.Version id is '||x_article_version_id, 2);
611: END IF;*/
612:
613: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
614: FND_LOG.STRING(G_PROC_LEVEL,
615: G_PKG_NAME, '300: non-std article created.Version id is '||x_article_version_id );
616: END IF;
617:
618: /*IF (l_debug = 'Y') THEN

Line 623: FND_LOG.STRING(G_PROC_LEVEL,

619: okc_debug.log('400: Updating k article record', 2);
620: END IF;*/
621:
622: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
623: FND_LOG.STRING(G_PROC_LEVEL,
624: G_PKG_NAME, '400: Updating k article record' );
625: END IF;
626:
627: OKC_K_ARTICLES_GRP.update_article(

Line 667: FND_LOG.STRING(G_PROC_LEVEL,

663: okc_debug.log('900: Leavingupdate_non_std_article', 2);
664: END IF;*/
665:
666: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
667: FND_LOG.STRING(G_PROC_LEVEL,
668: G_PKG_NAME, '900: Leavingupdate_non_std_article' );
669: END IF;
670:
671: EXCEPTION

Line 678: FND_LOG.STRING(G_EXCP_LEVEL,

674: okc_debug.log('300: Leaving update_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
675: END IF;*/
676:
677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
678: FND_LOG.STRING(G_EXCP_LEVEL,
679: G_PKG_NAME, '300: Leaving update_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception' );
680: END IF;
681:
682: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 697: FND_LOG.STRING(G_EXCP_LEVEL,

693: okc_debug.log('400: Leavingupdate_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
694: END IF;*/
695:
696: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
697: FND_LOG.STRING(G_EXCP_LEVEL,
698: G_PKG_NAME, '400: Leavingupdate_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
699: END IF;
700:
701: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 716: FND_LOG.STRING(G_EXCP_LEVEL,

712: okc_debug.log('500: Leaving update_non_std_article because of EXCEPTION: '||sqlerrm, 2);
713: END IF;*/
714:
715: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
716: FND_LOG.STRING(G_EXCP_LEVEL,
717: G_PKG_NAME, '500: Leaving update_non_std_article because of EXCEPTION: '||sqlerrm );
718: END IF;
719:
720: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 803: FND_LOG.STRING(G_PROC_LEVEL,

799: okc_debug.log('100: Entered revert_to_standard', 2);
800: END IF;*/
801:
802: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
803: FND_LOG.STRING(G_PROC_LEVEL,
804: G_PKG_NAME, '100: Entered revert_to_standard' );
805: END IF;
806:
807: -- Standard Start of API savepoint

Line 835: FND_LOG.STRING(G_PROC_LEVEL,

831: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
832: END IF;*/
833:
834: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
835: FND_LOG.STRING(G_PROC_LEVEL,
836: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
837: END IF;
838: RAISE FND_API.G_EXC_ERROR ;
839: END IF;

Line 850: FND_LOG.STRING(G_PROC_LEVEL,

846: okc_debug.log('200: revert_to_standard', 2);
847: END IF;*/
848:
849: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
850: FND_LOG.STRING(G_PROC_LEVEL,
851: G_PKG_NAME, '200: revert_to_standard' );
852: END IF;
853:
854: OPEN l_get_kart_dtl_csr;

Line 871: FND_LOG.STRING(G_PROC_LEVEL,

867: okc_debug.log('400: Before invoking OKC_K_ARTICLES_GRP.delete_article record for p_id = ' || p_k_art_id, 2);
868: END IF;*/
869:
870: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
871: FND_LOG.STRING(G_PROC_LEVEL,
872: G_PKG_NAME, '400: Before invoking OKC_K_ARTICLES_GRP.delete_article record for p_id = ' || p_k_art_id );
873: END IF;
874:
875: /*

Line 894: FND_LOG.STRING(G_PROC_LEVEL,

890: okc_debug.log('500: After invoking OKC_K_ARTICLES_GRP.delete_article record x_return_status = ' || x_return_status, 2);
891: END IF;*/
892:
893: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
894: FND_LOG.STRING(G_PROC_LEVEL,
895: G_PKG_NAME, '500: After invoking OKC_K_ARTICLES_GRP.delete_article record x_return_status = ' || x_return_status );
896: END IF;
897:
898: --------------------------------------------

Line 912: FND_LOG.STRING(G_PROC_LEVEL,

908: okc_debug.log('600: Before invoking OKC_K_ARTICLES_GRP.create_article record for orig_article_id = ' || l_orig_article_id, 2);
909: END IF;*/
910:
911: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
912: FND_LOG.STRING(G_PROC_LEVEL,
913: G_PKG_NAME, '600: Before invoking OKC_K_ARTICLES_GRP.create_article record for orig_article_id = ' || l_orig_article_id );
914: END IF;
915: /*
916: OKC_K_ARTICLES_GRP.create_article(

Line 971: FND_LOG.STRING(G_PROC_LEVEL,

967: okc_debug.log('700: After invoking OKC_K_ARTICLES_GRP.create_article record x_return_status = ' || x_return_status, 2);
968: END IF;*/
969:
970: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
971: FND_LOG.STRING(G_PROC_LEVEL,
972: G_PKG_NAME, '700: After invoking OKC_K_ARTICLES_GRP.create_article record x_return_status = ' || x_return_status );
973: END IF;
974: /*
975: Delete those variables that are not in the Standard Article Version

Line 1036: FND_LOG.STRING(G_PROC_LEVEL,

1032: okc_debug.log('900: Leaving revert_to_standard', 2);
1033: END IF;*/
1034:
1035: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1036: FND_LOG.STRING(G_PROC_LEVEL,
1037: G_PKG_NAME, '900: Leaving revert_to_standard' );
1038: END IF;
1039:
1040: EXCEPTION

Line 1047: FND_LOG.STRING(G_EXCP_LEVEL,

1043: okc_debug.log('300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1044: END IF;*/
1045:
1046: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1047: FND_LOG.STRING(G_EXCP_LEVEL,
1048: G_PKG_NAME, '300: Leaving revert_to_standard: OKC_API.G_EXCEPTION_ERROR Exception' );
1049: END IF;
1050:
1051: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 1066: FND_LOG.STRING(G_EXCP_LEVEL,

1062: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1063: END IF;*/
1064:
1065: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1066: FND_LOG.STRING(G_EXCP_LEVEL,
1067: G_PKG_NAME, '400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1068: END IF;
1069:
1070: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 1085: FND_LOG.STRING(G_EXCP_LEVEL,

1081: okc_debug.log('500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm, 2);
1082: END IF;*/
1083:
1084: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1085: FND_LOG.STRING(G_EXCP_LEVEL,
1086: G_PKG_NAME, '500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm );
1087: END IF;
1088:
1089: IF l_get_kart_dtl_csr%ISOPEN THEN