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 106: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 138: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 153: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 229: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 240: FND_LOG.STRING(G_PROC_LEVEL,

236: okc_debug.log('400: Updating k article record', 2);
237: END IF;*/
238:
239: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
240: FND_LOG.STRING(G_PROC_LEVEL,
241: G_PKG_NAME, '400: Updating k article record' );
242: END IF;
243:
244: OKC_K_ARTICLES_GRP.update_article(

Line 290: FND_LOG.STRING(G_PROC_LEVEL,

286: okc_debug.log('500: Creating k article record', 2);
287: END IF;*/
288:
289: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
290: FND_LOG.STRING(G_PROC_LEVEL,
291: G_PKG_NAME, '500: Creating k article record' );
292: END IF;
293:
294: OKC_TERMS_MULTIREC_GRP.create_article(

Line 339: FND_LOG.STRING(G_PROC_LEVEL,

335: okc_debug.log('900: Leaving create_non_std_article', 2);
336: END IF;*/
337:
338: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
339: FND_LOG.STRING(G_PROC_LEVEL,
340: G_PKG_NAME, '900: Leaving create_non_std_article' );
341: END IF;
342:
343: EXCEPTION

Line 350: FND_LOG.STRING(G_EXCP_LEVEL,

346: okc_debug.log('300: Leaving create_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
347: END IF;*/
348:
349: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
350: FND_LOG.STRING(G_EXCP_LEVEL,
351: G_PKG_NAME, '300: Leaving create_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception' );
352: END IF;
353:
354: IF l_get_intent_csr%ISOPEN THEN

Line 368: FND_LOG.STRING(G_EXCP_LEVEL,

364: okc_debug.log('400: Leaving create_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
365: END IF;*/
366:
367: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
368: FND_LOG.STRING(G_EXCP_LEVEL,
369: G_PKG_NAME, '400: Leaving create_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
370: END IF;
371:
372: IF l_get_intent_csr%ISOPEN THEN

Line 386: FND_LOG.STRING(G_EXCP_LEVEL,

382: okc_debug.log('500: Leaving create_non_std_article because of EXCEPTION: '||sqlerrm, 2);
383: END IF;*/
384:
385: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
386: FND_LOG.STRING(G_EXCP_LEVEL,
387: G_PKG_NAME, '500: Leaving create_non_std_article because of EXCEPTION: '||sqlerrm );
388: END IF;
389:
390: IF l_get_intent_csr%ISOPEN THEN

Line 464: FND_LOG.STRING(G_PROC_LEVEL,

460: okc_debug.log('100: Entered update_non_std_article', 2);
461: END IF;*/
462:
463: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
464: FND_LOG.STRING(G_PROC_LEVEL,
465: G_PKG_NAME, '100: Entered update_non_std_article' );
466: END IF;
467:
468: -- Standard Start of API savepoint

Line 496: FND_LOG.STRING(G_PROC_LEVEL,

492: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
493: END IF;*/
494:
495: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
496: FND_LOG.STRING(G_PROC_LEVEL,
497: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
498: END IF;
499: RAISE FND_API.G_EXC_ERROR ;
500: END IF;

Line 511: FND_LOG.STRING(G_PROC_LEVEL,

507: okc_debug.log('200: Updating non-std article', 2);
508: END IF;*/
509:
510: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
511: FND_LOG.STRING(G_PROC_LEVEL,
512: G_PKG_NAME, '200: Updating non-std article' );
513: END IF;
514:
515: OPEN l_get_kart_dtl_csr;

Line 628: FND_LOG.STRING(G_PROC_LEVEL,

624: okc_debug.log('300: non-std article created.Version id is '||x_article_version_id, 2);
625: END IF;*/
626:
627: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
628: FND_LOG.STRING(G_PROC_LEVEL,
629: G_PKG_NAME, '300: non-std article created.Version id is '||x_article_version_id );
630: END IF;
631:
632: /*IF (l_debug = 'Y') THEN

Line 637: FND_LOG.STRING(G_PROC_LEVEL,

633: okc_debug.log('400: Updating k article record', 2);
634: END IF;*/
635:
636: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
637: FND_LOG.STRING(G_PROC_LEVEL,
638: G_PKG_NAME, '400: Updating k article record' );
639: END IF;
640:
641: OKC_K_ARTICLES_GRP.update_article(

Line 682: FND_LOG.STRING(G_PROC_LEVEL,

678: okc_debug.log('900: Leavingupdate_non_std_article', 2);
679: END IF;*/
680:
681: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
682: FND_LOG.STRING(G_PROC_LEVEL,
683: G_PKG_NAME, '900: Leavingupdate_non_std_article' );
684: END IF;
685:
686: EXCEPTION

Line 693: FND_LOG.STRING(G_EXCP_LEVEL,

689: okc_debug.log('300: Leaving update_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception', 2);
690: END IF;*/
691:
692: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
693: FND_LOG.STRING(G_EXCP_LEVEL,
694: G_PKG_NAME, '300: Leaving update_non_std_article: OKC_API.G_EXCEPTION_ERROR Exception' );
695: END IF;
696:
697: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 712: FND_LOG.STRING(G_EXCP_LEVEL,

708: okc_debug.log('400: Leavingupdate_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
709: END IF;*/
710:
711: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
712: FND_LOG.STRING(G_EXCP_LEVEL,
713: G_PKG_NAME, '400: Leavingupdate_non_std_article: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
714: END IF;
715:
716: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 731: FND_LOG.STRING(G_EXCP_LEVEL,

727: okc_debug.log('500: Leaving update_non_std_article because of EXCEPTION: '||sqlerrm, 2);
728: END IF;*/
729:
730: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
731: FND_LOG.STRING(G_EXCP_LEVEL,
732: G_PKG_NAME, '500: Leaving update_non_std_article because of EXCEPTION: '||sqlerrm );
733: END IF;
734:
735: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 819: FND_LOG.STRING(G_PROC_LEVEL,

815: okc_debug.log('100: Entered revert_to_standard', 2);
816: END IF;*/
817:
818: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
819: FND_LOG.STRING(G_PROC_LEVEL,
820: G_PKG_NAME, '100: Entered revert_to_standard' );
821: END IF;
822:
823: -- Standard Start of API savepoint

Line 851: FND_LOG.STRING(G_PROC_LEVEL,

847: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
848: END IF;*/
849:
850: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
851: FND_LOG.STRING(G_PROC_LEVEL,
852: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
853: END IF;
854: RAISE FND_API.G_EXC_ERROR ;
855: END IF;

Line 866: FND_LOG.STRING(G_PROC_LEVEL,

862: okc_debug.log('200: revert_to_standard', 2);
863: END IF;*/
864:
865: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
866: FND_LOG.STRING(G_PROC_LEVEL,
867: G_PKG_NAME, '200: revert_to_standard' );
868: END IF;
869:
870: OPEN l_get_kart_dtl_csr;

Line 887: FND_LOG.STRING(G_PROC_LEVEL,

883: okc_debug.log('400: Before invoking OKC_K_ARTICLES_GRP.delete_article record for p_id = ' || p_k_art_id, 2);
884: END IF;*/
885:
886: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
887: FND_LOG.STRING(G_PROC_LEVEL,
888: G_PKG_NAME, '400: Before invoking OKC_K_ARTICLES_GRP.delete_article record for p_id = ' || p_k_art_id );
889: END IF;
890:
891: /*

Line 910: FND_LOG.STRING(G_PROC_LEVEL,

906: okc_debug.log('500: After invoking OKC_K_ARTICLES_GRP.delete_article record x_return_status = ' || x_return_status, 2);
907: END IF;*/
908:
909: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
910: FND_LOG.STRING(G_PROC_LEVEL,
911: G_PKG_NAME, '500: After invoking OKC_K_ARTICLES_GRP.delete_article record x_return_status = ' || x_return_status );
912: END IF;
913:
914: --------------------------------------------

Line 928: FND_LOG.STRING(G_PROC_LEVEL,

924: okc_debug.log('600: Before invoking OKC_K_ARTICLES_GRP.create_article record for orig_article_id = ' || l_orig_article_id, 2);
925: END IF;*/
926:
927: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
928: FND_LOG.STRING(G_PROC_LEVEL,
929: G_PKG_NAME, '600: Before invoking OKC_K_ARTICLES_GRP.create_article record for orig_article_id = ' || l_orig_article_id );
930: END IF;
931: /*
932: OKC_K_ARTICLES_GRP.create_article(

Line 988: FND_LOG.STRING(G_PROC_LEVEL,

984: okc_debug.log('700: After invoking OKC_K_ARTICLES_GRP.create_article record x_return_status = ' || x_return_status, 2);
985: END IF;*/
986:
987: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
988: FND_LOG.STRING(G_PROC_LEVEL,
989: G_PKG_NAME, '700: After invoking OKC_K_ARTICLES_GRP.create_article record x_return_status = ' || x_return_status );
990: END IF;
991: /*
992: Delete those variables that are not in the Standard Article Version

Line 1053: FND_LOG.STRING(G_PROC_LEVEL,

1049: okc_debug.log('900: Leaving revert_to_standard', 2);
1050: END IF;*/
1051:
1052: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1053: FND_LOG.STRING(G_PROC_LEVEL,
1054: G_PKG_NAME, '900: Leaving revert_to_standard' );
1055: END IF;
1056:
1057: EXCEPTION

Line 1064: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 1083: FND_LOG.STRING(G_EXCP_LEVEL,

1079: okc_debug.log('400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
1080: END IF;*/
1081:
1082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1083: FND_LOG.STRING(G_EXCP_LEVEL,
1084: G_PKG_NAME, '400: Leaving revert_to_standard: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1085: END IF;
1086:
1087: IF l_get_kart_dtl_csr%ISOPEN THEN

Line 1102: FND_LOG.STRING(G_EXCP_LEVEL,

1098: okc_debug.log('500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm, 2);
1099: END IF;*/
1100:
1101: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1102: FND_LOG.STRING(G_EXCP_LEVEL,
1103: G_PKG_NAME, '500: Leaving revert_to_standard because of EXCEPTION: '||sqlerrm );
1104: END IF;
1105:
1106: IF l_get_kart_dtl_csr%ISOPEN THEN