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 FND_LOG

Line 31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
28: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
29: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
30:
31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35: TYPE scn_child_rec_type IS RECORD (

Line 32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

28: G_AMEND_CODE_ADDED CONSTANT VARCHAR2(30) := 'ADDED';
29: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
30:
31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35: TYPE scn_child_rec_type IS RECORD (
36: id OKC_K_ARTICLES_B.id%type,

Line 33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

29: G_AMEND_CODE_UPDATED CONSTANT VARCHAR2(30) := 'UPDATED';
30:
31: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
32: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
34:
35: TYPE scn_child_rec_type IS RECORD (
36: id OKC_K_ARTICLES_B.id%type,
37: display_sequence OKC_K_ARTICLES_B.display_sequence%type,

Line 114: FND_LOG.STRING(G_PROC_LEVEL,

110: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
111: END IF;*/
112:
113: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
114: FND_LOG.STRING(G_PROC_LEVEL,
115: G_PKG_NAME, '100: Entered create_article' );
116: FND_LOG.STRING(G_PROC_LEVEL,
117: G_PKG_NAME, '100: Parameter List ' );
118: FND_LOG.STRING(G_PROC_LEVEL,

Line 116: FND_LOG.STRING(G_PROC_LEVEL,

112:
113: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
114: FND_LOG.STRING(G_PROC_LEVEL,
115: G_PKG_NAME, '100: Entered create_article' );
116: FND_LOG.STRING(G_PROC_LEVEL,
117: G_PKG_NAME, '100: Parameter List ' );
118: FND_LOG.STRING(G_PROC_LEVEL,
119: G_PKG_NAME, '100: p_api_version : '||p_api_version );
120: FND_LOG.STRING(G_PROC_LEVEL,

Line 118: FND_LOG.STRING(G_PROC_LEVEL,

114: FND_LOG.STRING(G_PROC_LEVEL,
115: G_PKG_NAME, '100: Entered create_article' );
116: FND_LOG.STRING(G_PROC_LEVEL,
117: G_PKG_NAME, '100: Parameter List ' );
118: FND_LOG.STRING(G_PROC_LEVEL,
119: G_PKG_NAME, '100: p_api_version : '||p_api_version );
120: FND_LOG.STRING(G_PROC_LEVEL,
121: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
122: FND_LOG.STRING(G_PROC_LEVEL,

Line 120: FND_LOG.STRING(G_PROC_LEVEL,

116: FND_LOG.STRING(G_PROC_LEVEL,
117: G_PKG_NAME, '100: Parameter List ' );
118: FND_LOG.STRING(G_PROC_LEVEL,
119: G_PKG_NAME, '100: p_api_version : '||p_api_version );
120: FND_LOG.STRING(G_PROC_LEVEL,
121: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
122: FND_LOG.STRING(G_PROC_LEVEL,
123: G_PKG_NAME, '100: p_mode : '||p_mode );
124: FND_LOG.STRING(G_PROC_LEVEL,

Line 122: FND_LOG.STRING(G_PROC_LEVEL,

118: FND_LOG.STRING(G_PROC_LEVEL,
119: G_PKG_NAME, '100: p_api_version : '||p_api_version );
120: FND_LOG.STRING(G_PROC_LEVEL,
121: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
122: FND_LOG.STRING(G_PROC_LEVEL,
123: G_PKG_NAME, '100: p_mode : '||p_mode );
124: FND_LOG.STRING(G_PROC_LEVEL,
125: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
126: FND_LOG.STRING(G_PROC_LEVEL,

Line 124: FND_LOG.STRING(G_PROC_LEVEL,

120: FND_LOG.STRING(G_PROC_LEVEL,
121: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
122: FND_LOG.STRING(G_PROC_LEVEL,
123: G_PKG_NAME, '100: p_mode : '||p_mode );
124: FND_LOG.STRING(G_PROC_LEVEL,
125: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
126: FND_LOG.STRING(G_PROC_LEVEL,
127: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
128: FND_LOG.STRING(G_PROC_LEVEL,

Line 126: FND_LOG.STRING(G_PROC_LEVEL,

122: FND_LOG.STRING(G_PROC_LEVEL,
123: G_PKG_NAME, '100: p_mode : '||p_mode );
124: FND_LOG.STRING(G_PROC_LEVEL,
125: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
126: FND_LOG.STRING(G_PROC_LEVEL,
127: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
128: FND_LOG.STRING(G_PROC_LEVEL,
129: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
130: FND_LOG.STRING(G_PROC_LEVEL,

Line 128: FND_LOG.STRING(G_PROC_LEVEL,

124: FND_LOG.STRING(G_PROC_LEVEL,
125: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
126: FND_LOG.STRING(G_PROC_LEVEL,
127: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
128: FND_LOG.STRING(G_PROC_LEVEL,
129: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
130: FND_LOG.STRING(G_PROC_LEVEL,
131: G_PKG_NAME, '100: p_commit : '||p_commit );
132: FND_LOG.STRING(G_PROC_LEVEL,

Line 130: FND_LOG.STRING(G_PROC_LEVEL,

126: FND_LOG.STRING(G_PROC_LEVEL,
127: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
128: FND_LOG.STRING(G_PROC_LEVEL,
129: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
130: FND_LOG.STRING(G_PROC_LEVEL,
131: G_PKG_NAME, '100: p_commit : '||p_commit );
132: FND_LOG.STRING(G_PROC_LEVEL,
133: G_PKG_NAME, '100: p_ref_type : '||p_ref_type );
134: FND_LOG.STRING(G_PROC_LEVEL,

Line 132: FND_LOG.STRING(G_PROC_LEVEL,

128: FND_LOG.STRING(G_PROC_LEVEL,
129: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
130: FND_LOG.STRING(G_PROC_LEVEL,
131: G_PKG_NAME, '100: p_commit : '||p_commit );
132: FND_LOG.STRING(G_PROC_LEVEL,
133: G_PKG_NAME, '100: p_ref_type : '||p_ref_type );
134: FND_LOG.STRING(G_PROC_LEVEL,
135: G_PKG_NAME, '100: p_ref_id : '||p_ref_id );
136: FND_LOG.STRING(G_PROC_LEVEL,

Line 134: FND_LOG.STRING(G_PROC_LEVEL,

130: FND_LOG.STRING(G_PROC_LEVEL,
131: G_PKG_NAME, '100: p_commit : '||p_commit );
132: FND_LOG.STRING(G_PROC_LEVEL,
133: G_PKG_NAME, '100: p_ref_type : '||p_ref_type );
134: FND_LOG.STRING(G_PROC_LEVEL,
135: G_PKG_NAME, '100: p_ref_id : '||p_ref_id );
136: FND_LOG.STRING(G_PROC_LEVEL,
137: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
138: FND_LOG.STRING(G_PROC_LEVEL,

Line 136: FND_LOG.STRING(G_PROC_LEVEL,

132: FND_LOG.STRING(G_PROC_LEVEL,
133: G_PKG_NAME, '100: p_ref_type : '||p_ref_type );
134: FND_LOG.STRING(G_PROC_LEVEL,
135: G_PKG_NAME, '100: p_ref_id : '||p_ref_id );
136: FND_LOG.STRING(G_PROC_LEVEL,
137: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
138: FND_LOG.STRING(G_PROC_LEVEL,
139: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
140: END IF;

Line 138: FND_LOG.STRING(G_PROC_LEVEL,

134: FND_LOG.STRING(G_PROC_LEVEL,
135: G_PKG_NAME, '100: p_ref_id : '||p_ref_id );
136: FND_LOG.STRING(G_PROC_LEVEL,
137: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
138: FND_LOG.STRING(G_PROC_LEVEL,
139: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
140: END IF;
141:
142: -- Standard Start of API savepoint

Line 171: FND_LOG.STRING(G_PROC_LEVEL,

167: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
168: END IF;*/
169:
170: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
171: FND_LOG.STRING(G_PROC_LEVEL,
172: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
173: END IF;
174: RAISE FND_API.G_EXC_ERROR ;
175: END IF;

Line 230: FND_LOG.STRING(G_PROC_LEVEL,

226: okc_debug.log('110: Creating Article No '||p_kart_tbl(i).sav_sae_id, 2);
227: END IF;*/
228:
229: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
230: FND_LOG.STRING(G_PROC_LEVEL,
231: G_PKG_NAME, '110: Creating Article No '||p_kart_tbl(i).sav_sae_id );
232: END IF;
233:
234: l_ref_sequence := l_ref_sequence + 10;

Line 289: FND_LOG.STRING(G_PROC_LEVEL,

285: okc_debug.log('120: Updating Display Sequence of cat_id '||scn_child_tbl(k).id, 2);
286: END IF;*/
287:
288: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
289: FND_LOG.STRING(G_PROC_LEVEL,
290: G_PKG_NAME, '120: Updating Display Sequence of cat_id '||scn_child_tbl(k).id );
291: END IF;
292:
293: OKC_K_ARTICLES_GRP.update_article(

Line 317: FND_LOG.STRING(G_PROC_LEVEL,

313: okc_debug.log('1000: Updating Display Sequence of scn_id '||scn_child_tbl(k).id, 2);
314: END IF;*/
315:
316: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
317: FND_LOG.STRING(G_PROC_LEVEL,
318: G_PKG_NAME, '1000: Updating Display Sequence of scn_id '||scn_child_tbl(k).id );
319: END IF;
320:
321: OKC_TERMS_SECTIONS_GRP.update_section(

Line 356: FND_LOG.STRING(G_PROC_LEVEL,

352: okc_debug.log('200: Leaving create_article', 2);
353: END IF;*/
354:
355: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
356: FND_LOG.STRING(G_PROC_LEVEL,
357: G_PKG_NAME, '200: Leaving create_article' );
358: END IF;
359:
360: EXCEPTION

Line 367: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 389: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 411: FND_LOG.STRING(G_EXCP_LEVEL,

407: okc_debug.log('500: Leaving create_article because of EXCEPTION: '||sqlerrm, 2);
408: END IF;*/
409:
410: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
411: FND_LOG.STRING(G_EXCP_LEVEL,
412: G_PKG_NAME, '500: Leaving create_article because of EXCEPTION: '||sqlerrm );
413: END IF;
414:
415: IF l_get_scn_child_csr%ISOPEN THEN

Line 478: FND_LOG.STRING(G_PROC_LEVEL,

474: okc_debug.log('100: p_commit : '||p_commit, 2);
475: END IF;*/
476:
477: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
478: FND_LOG.STRING(G_PROC_LEVEL,
479: G_PKG_NAME, '100: Entered update_article_variable' );
480: FND_LOG.STRING(G_PROC_LEVEL,
481: G_PKG_NAME, '100: Parameter List ' );
482: FND_LOG.STRING(G_PROC_LEVEL,

Line 480: FND_LOG.STRING(G_PROC_LEVEL,

476:
477: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
478: FND_LOG.STRING(G_PROC_LEVEL,
479: G_PKG_NAME, '100: Entered update_article_variable' );
480: FND_LOG.STRING(G_PROC_LEVEL,
481: G_PKG_NAME, '100: Parameter List ' );
482: FND_LOG.STRING(G_PROC_LEVEL,
483: G_PKG_NAME, '100: p_api_version : '||p_api_version );
484: FND_LOG.STRING(G_PROC_LEVEL,

Line 482: FND_LOG.STRING(G_PROC_LEVEL,

478: FND_LOG.STRING(G_PROC_LEVEL,
479: G_PKG_NAME, '100: Entered update_article_variable' );
480: FND_LOG.STRING(G_PROC_LEVEL,
481: G_PKG_NAME, '100: Parameter List ' );
482: FND_LOG.STRING(G_PROC_LEVEL,
483: G_PKG_NAME, '100: p_api_version : '||p_api_version );
484: FND_LOG.STRING(G_PROC_LEVEL,
485: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
486: FND_LOG.STRING(G_PROC_LEVEL,

Line 484: FND_LOG.STRING(G_PROC_LEVEL,

480: FND_LOG.STRING(G_PROC_LEVEL,
481: G_PKG_NAME, '100: Parameter List ' );
482: FND_LOG.STRING(G_PROC_LEVEL,
483: G_PKG_NAME, '100: p_api_version : '||p_api_version );
484: FND_LOG.STRING(G_PROC_LEVEL,
485: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
486: FND_LOG.STRING(G_PROC_LEVEL,
487: G_PKG_NAME, '100: p_mode : '||p_mode );
488: FND_LOG.STRING(G_PROC_LEVEL,

Line 486: FND_LOG.STRING(G_PROC_LEVEL,

482: FND_LOG.STRING(G_PROC_LEVEL,
483: G_PKG_NAME, '100: p_api_version : '||p_api_version );
484: FND_LOG.STRING(G_PROC_LEVEL,
485: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
486: FND_LOG.STRING(G_PROC_LEVEL,
487: G_PKG_NAME, '100: p_mode : '||p_mode );
488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
490: FND_LOG.STRING(G_PROC_LEVEL,

Line 488: FND_LOG.STRING(G_PROC_LEVEL,

484: FND_LOG.STRING(G_PROC_LEVEL,
485: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
486: FND_LOG.STRING(G_PROC_LEVEL,
487: G_PKG_NAME, '100: p_mode : '||p_mode );
488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
492: FND_LOG.STRING(G_PROC_LEVEL,

Line 490: FND_LOG.STRING(G_PROC_LEVEL,

486: FND_LOG.STRING(G_PROC_LEVEL,
487: G_PKG_NAME, '100: p_mode : '||p_mode );
488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
492: FND_LOG.STRING(G_PROC_LEVEL,
493: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
494: FND_LOG.STRING(G_PROC_LEVEL,

Line 492: FND_LOG.STRING(G_PROC_LEVEL,

488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
492: FND_LOG.STRING(G_PROC_LEVEL,
493: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
494: FND_LOG.STRING(G_PROC_LEVEL,
495: G_PKG_NAME, '100: p_commit : '||p_commit );
496: END IF;

Line 494: FND_LOG.STRING(G_PROC_LEVEL,

490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
492: FND_LOG.STRING(G_PROC_LEVEL,
493: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
494: FND_LOG.STRING(G_PROC_LEVEL,
495: G_PKG_NAME, '100: p_commit : '||p_commit );
496: END IF;
497:
498: -- Standard Start of API savepoint

Line 530: FND_LOG.STRING(G_PROC_LEVEL,

526: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
527: END IF;*/
528:
529: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
530: FND_LOG.STRING(G_PROC_LEVEL,
531: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
532: END IF;
533: RAISE FND_API.G_EXC_ERROR ;
534: END IF;

Line 547: FND_LOG.STRING(G_PROC_LEVEL,

543: okc_debug.log('115: Updating variable '||p_art_var_tbl(i).variable_code, 2);
544: END IF;*/
545:
546: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
547: FND_LOG.STRING(G_PROC_LEVEL,
548: G_PKG_NAME, '115: Updating variable '||p_art_var_tbl(i).variable_code );
549: END IF;
550:
551: OKC_K_ART_VARIABLES_PVT.update_row(

Line 583: FND_LOG.STRING(G_PROC_LEVEL,

579: okc_debug.log('125: Updating Amend Operation Code for cat_id '||p_art_var_tbl(i).cat_id, 2);
580: END IF;*/
581:
582: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
583: FND_LOG.STRING(G_PROC_LEVEL,
584: G_PKG_NAME, '125: Updating Amend Operation Code for cat_id '||p_art_var_tbl(i).cat_id );
585: END IF;
586: OKC_K_ARTICLES_GRP.Update_article(
587: p_api_version => 1,

Line 623: FND_LOG.STRING(G_PROC_LEVEL,

619: okc_debug.log('200: Leaving update_article_variable', 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, '200: Leaving update_article_variable' );
625: END IF;
626:
627: EXCEPTION

Line 634: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 652: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 670: FND_LOG.STRING(G_EXCP_LEVEL,

666: okc_debug.log('500: Leaving update_article_variable because of EXCEPTION: '||sqlerrm, 2);
667: END IF;*/
668:
669: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
670: FND_LOG.STRING(G_EXCP_LEVEL,
671: G_PKG_NAME, '500: Leaving update_article_variable because of EXCEPTION: '||sqlerrm );
672: END IF;
673:
674: IF l_doc_csr%ISOPEN THEN

Line 729: FND_LOG.STRING(G_PROC_LEVEL,

725: okc_debug.log('100: p_commit : '||p_commit, 2);
726: END IF;*/
727:
728: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
729: FND_LOG.STRING(G_PROC_LEVEL,
730: G_PKG_NAME, '100: Entered update_structure' );
731: FND_LOG.STRING(G_PROC_LEVEL,
732: G_PKG_NAME, '100: Parameter List ' );
733: FND_LOG.STRING(G_PROC_LEVEL,

Line 731: FND_LOG.STRING(G_PROC_LEVEL,

727:
728: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
729: FND_LOG.STRING(G_PROC_LEVEL,
730: G_PKG_NAME, '100: Entered update_structure' );
731: FND_LOG.STRING(G_PROC_LEVEL,
732: G_PKG_NAME, '100: Parameter List ' );
733: FND_LOG.STRING(G_PROC_LEVEL,
734: G_PKG_NAME, '100: p_api_version : '||p_api_version );
735: FND_LOG.STRING(G_PROC_LEVEL,

Line 733: FND_LOG.STRING(G_PROC_LEVEL,

729: FND_LOG.STRING(G_PROC_LEVEL,
730: G_PKG_NAME, '100: Entered update_structure' );
731: FND_LOG.STRING(G_PROC_LEVEL,
732: G_PKG_NAME, '100: Parameter List ' );
733: FND_LOG.STRING(G_PROC_LEVEL,
734: G_PKG_NAME, '100: p_api_version : '||p_api_version );
735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
737: FND_LOG.STRING(G_PROC_LEVEL,

Line 735: FND_LOG.STRING(G_PROC_LEVEL,

731: FND_LOG.STRING(G_PROC_LEVEL,
732: G_PKG_NAME, '100: Parameter List ' );
733: FND_LOG.STRING(G_PROC_LEVEL,
734: G_PKG_NAME, '100: p_api_version : '||p_api_version );
735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
739: FND_LOG.STRING(G_PROC_LEVEL,

Line 737: FND_LOG.STRING(G_PROC_LEVEL,

733: FND_LOG.STRING(G_PROC_LEVEL,
734: G_PKG_NAME, '100: p_api_version : '||p_api_version );
735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
741: FND_LOG.STRING(G_PROC_LEVEL,

Line 739: FND_LOG.STRING(G_PROC_LEVEL,

735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
741: FND_LOG.STRING(G_PROC_LEVEL,
742: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
743: FND_LOG.STRING(G_PROC_LEVEL,

Line 741: FND_LOG.STRING(G_PROC_LEVEL,

737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
741: FND_LOG.STRING(G_PROC_LEVEL,
742: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
743: FND_LOG.STRING(G_PROC_LEVEL,
744: G_PKG_NAME, '100: p_commit : '||p_commit );
745: END IF;

Line 743: FND_LOG.STRING(G_PROC_LEVEL,

739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
741: FND_LOG.STRING(G_PROC_LEVEL,
742: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
743: FND_LOG.STRING(G_PROC_LEVEL,
744: G_PKG_NAME, '100: p_commit : '||p_commit );
745: END IF;
746:
747: -- Standard Start of API savepoint

Line 791: FND_LOG.STRING(G_PROC_LEVEL,

787: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
788: END IF;*/
789:
790: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
791: FND_LOG.STRING(G_PROC_LEVEL,
792: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
793: END IF;
794: RAISE FND_API.G_EXC_ERROR ;
795: END IF;

Line 870: FND_LOG.STRING(G_PROC_LEVEL,

866: okc_debug.log('200: Leaving update_structure', 2);
867: END IF;*/
868:
869: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
870: FND_LOG.STRING(G_PROC_LEVEL,
871: G_PKG_NAME, '200: Leaving update_structure' );
872: END IF;
873:
874: EXCEPTION

Line 881: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 903: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 925: FND_LOG.STRING(G_EXCP_LEVEL,

921: okc_debug.log('500: Leaving update_structure because of EXCEPTION: '||sqlerrm, 2);
922: END IF;*/
923:
924: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
925: FND_LOG.STRING(G_EXCP_LEVEL,
926: G_PKG_NAME, '500: Leaving update_structure because of EXCEPTION: '||sqlerrm );
927: END IF;
928:
929: IF l_doc_art_csr%ISOPEN THEN

Line 1146: FND_LOG.STRING(G_PROC_LEVEL,

1142: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
1143: END IF;*/
1144:
1145: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1146: FND_LOG.STRING(G_PROC_LEVEL,
1147: G_PKG_NAME, '100: Entered sync_doc_with_expert' );
1148: FND_LOG.STRING(G_PROC_LEVEL,
1149: G_PKG_NAME, '100: Parameter List ' );
1150: FND_LOG.STRING(G_PROC_LEVEL,

Line 1148: FND_LOG.STRING(G_PROC_LEVEL,

1144:
1145: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1146: FND_LOG.STRING(G_PROC_LEVEL,
1147: G_PKG_NAME, '100: Entered sync_doc_with_expert' );
1148: FND_LOG.STRING(G_PROC_LEVEL,
1149: G_PKG_NAME, '100: Parameter List ' );
1150: FND_LOG.STRING(G_PROC_LEVEL,
1151: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1152: FND_LOG.STRING(G_PROC_LEVEL,

Line 1150: FND_LOG.STRING(G_PROC_LEVEL,

1146: FND_LOG.STRING(G_PROC_LEVEL,
1147: G_PKG_NAME, '100: Entered sync_doc_with_expert' );
1148: FND_LOG.STRING(G_PROC_LEVEL,
1149: G_PKG_NAME, '100: Parameter List ' );
1150: FND_LOG.STRING(G_PROC_LEVEL,
1151: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1152: FND_LOG.STRING(G_PROC_LEVEL,
1153: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1154: FND_LOG.STRING(G_PROC_LEVEL,

Line 1152: FND_LOG.STRING(G_PROC_LEVEL,

1148: FND_LOG.STRING(G_PROC_LEVEL,
1149: G_PKG_NAME, '100: Parameter List ' );
1150: FND_LOG.STRING(G_PROC_LEVEL,
1151: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1152: FND_LOG.STRING(G_PROC_LEVEL,
1153: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1154: FND_LOG.STRING(G_PROC_LEVEL,
1155: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1156: FND_LOG.STRING(G_PROC_LEVEL,

Line 1154: FND_LOG.STRING(G_PROC_LEVEL,

1150: FND_LOG.STRING(G_PROC_LEVEL,
1151: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1152: FND_LOG.STRING(G_PROC_LEVEL,
1153: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1154: FND_LOG.STRING(G_PROC_LEVEL,
1155: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1156: FND_LOG.STRING(G_PROC_LEVEL,
1157: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1158: FND_LOG.STRING(G_PROC_LEVEL,

Line 1156: FND_LOG.STRING(G_PROC_LEVEL,

1152: FND_LOG.STRING(G_PROC_LEVEL,
1153: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1154: FND_LOG.STRING(G_PROC_LEVEL,
1155: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1156: FND_LOG.STRING(G_PROC_LEVEL,
1157: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1158: FND_LOG.STRING(G_PROC_LEVEL,
1159: G_PKG_NAME, '100: p_commit : '||p_commit );
1160: FND_LOG.STRING(G_PROC_LEVEL,

Line 1158: FND_LOG.STRING(G_PROC_LEVEL,

1154: FND_LOG.STRING(G_PROC_LEVEL,
1155: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1156: FND_LOG.STRING(G_PROC_LEVEL,
1157: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1158: FND_LOG.STRING(G_PROC_LEVEL,
1159: G_PKG_NAME, '100: p_commit : '||p_commit );
1160: FND_LOG.STRING(G_PROC_LEVEL,
1161: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1162: FND_LOG.STRING(G_PROC_LEVEL,

Line 1160: FND_LOG.STRING(G_PROC_LEVEL,

1156: FND_LOG.STRING(G_PROC_LEVEL,
1157: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1158: FND_LOG.STRING(G_PROC_LEVEL,
1159: G_PKG_NAME, '100: p_commit : '||p_commit );
1160: FND_LOG.STRING(G_PROC_LEVEL,
1161: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1162: FND_LOG.STRING(G_PROC_LEVEL,
1163: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1164: END IF;

Line 1162: FND_LOG.STRING(G_PROC_LEVEL,

1158: FND_LOG.STRING(G_PROC_LEVEL,
1159: G_PKG_NAME, '100: p_commit : '||p_commit );
1160: FND_LOG.STRING(G_PROC_LEVEL,
1161: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1162: FND_LOG.STRING(G_PROC_LEVEL,
1163: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1164: END IF;
1165:
1166: -- Standard Start of API savepoint

Line 1201: FND_LOG.STRING(G_PROC_LEVEL,

1197: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
1198: END IF;*/
1199:
1200: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1201: FND_LOG.STRING(G_PROC_LEVEL,
1202: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
1203: END IF;
1204: RAISE FND_API.G_EXC_ERROR ;
1205: END IF;

Line 1223: FND_LOG.STRING(G_PROC_LEVEL,

1219: okc_Debug.Log('100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag,2);
1220: END IF;*/
1221:
1222: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1223: FND_LOG.STRING(G_PROC_LEVEL,
1224: G_PKG_NAME, '100: l_prov_allowed : '||l_prov_allowed );
1225: FND_LOG.STRING(G_PROC_LEVEL,
1226: G_PKG_NAME, '100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag );
1227: END IF;

Line 1225: FND_LOG.STRING(G_PROC_LEVEL,

1221:
1222: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1223: FND_LOG.STRING(G_PROC_LEVEL,
1224: G_PKG_NAME, '100: l_prov_allowed : '||l_prov_allowed );
1225: FND_LOG.STRING(G_PROC_LEVEL,
1226: G_PKG_NAME, '100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag );
1227: END IF;
1228:
1229: l_query1 := 'Select kart.id ,kart.object_version_number from okc_k_articles_b kart where document_type=:l_doc_type and document_id=:l_doc_id and source_flag=''R'' and orig_article_id not in (';

Line 1238: FND_LOG.STRING(G_PROC_LEVEL,

1234: okc_debug.log('200: Article Count from Expert : '||p_article_id_tbl.COUNT,2);
1235: END IF;*/
1236:
1237: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1238: FND_LOG.STRING(G_PROC_LEVEL,
1239: G_PKG_NAME, '200: Article Count from Expert : '||p_article_id_tbl.COUNT );
1240: END IF;
1241:
1242: IF p_article_id_tbl.COUNT > 0 THEN

Line 1274: FND_LOG.STRING(G_PROC_LEVEL,

1270: okc_debug.log('300: Query Is '||l_query);
1271: END IF;*/
1272:
1273: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1274: FND_LOG.STRING(G_PROC_LEVEL,
1275: G_PKG_NAME, '300: Query Is '||l_query );
1276: END IF;
1277:
1278: -- Find out article which

Line 1284: FND_LOG.STRING(G_PROC_LEVEL,

1280: okc_debug.log('400: Going to delete Articles which came from expert last time but not present in expert this time');
1281: END IF;*/
1282:
1283: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1284: FND_LOG.STRING(G_PROC_LEVEL,
1285: G_PKG_NAME, '400: Going to delete Articles which came from expert last time but not present in expert this time' );
1286: END IF;
1287:
1288: OPEN l_check_existing_csr FOR l_query USING p_doc_type,p_doc_id;

Line 1330: FND_LOG.STRING(G_PROC_LEVEL,

1326: okc_debug.log('600: Inserting Articles : '||l_insert_tbl.COUNT,2);
1327: END IF;*/
1328:
1329: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1330: FND_LOG.STRING(G_PROC_LEVEL,
1331: G_PKG_NAME, '500: Articles Delete ' );
1332: FND_LOG.STRING(G_PROC_LEVEL,
1333: G_PKG_NAME, '600: Going to insert new Articles retunred by expert' );
1334: FND_LOG.STRING(G_PROC_LEVEL,

Line 1332: FND_LOG.STRING(G_PROC_LEVEL,

1328:
1329: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1330: FND_LOG.STRING(G_PROC_LEVEL,
1331: G_PKG_NAME, '500: Articles Delete ' );
1332: FND_LOG.STRING(G_PROC_LEVEL,
1333: G_PKG_NAME, '600: Going to insert new Articles retunred by expert' );
1334: FND_LOG.STRING(G_PROC_LEVEL,
1335: G_PKG_NAME, '600: Inserting Articles : '||l_insert_tbl.COUNT );
1336: END IF;

Line 1334: FND_LOG.STRING(G_PROC_LEVEL,

1330: FND_LOG.STRING(G_PROC_LEVEL,
1331: G_PKG_NAME, '500: Articles Delete ' );
1332: FND_LOG.STRING(G_PROC_LEVEL,
1333: G_PKG_NAME, '600: Going to insert new Articles retunred by expert' );
1334: FND_LOG.STRING(G_PROC_LEVEL,
1335: G_PKG_NAME, '600: Inserting Articles : '||l_insert_tbl.COUNT );
1336: END IF;
1337:
1338: IF l_insert_tbl.COUNT > 0 THEN

Line 1482: FND_LOG.STRING(G_PROC_LEVEL,

1478: okc_debug.log('700: Going to create section '|| l_article_rec.scn_code);
1479: END IF;*/
1480:
1481: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1482: FND_LOG.STRING(G_PROC_LEVEL,
1483: G_PKG_NAME, '700: Going to create section '|| l_article_rec.scn_code );
1484: END IF;
1485:
1486: OKC_TERMS_SECTIONS_GRP.create_section(

Line 1516: FND_LOG.STRING(G_PROC_LEVEL,

1512: okc_debug.log('800: section created');
1513: END IF;*/
1514:
1515: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1516: FND_LOG.STRING(G_PROC_LEVEL,
1517: G_PKG_NAME, '800: section created' );
1518: END IF;
1519:
1520: END IF;

Line 1534: FND_LOG.STRING(G_PROC_LEVEL,

1530: FETCH l_get_sec_seq_csr INTO l_max_sec_seq;
1531: CLOSE l_get_sec_seq_csr;
1532:
1533: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1534: FND_LOG.STRING(G_PROC_LEVEL,
1535: G_PKG_NAME, '801: l_art_seq = '||l_art_seq);
1536: FND_LOG.STRING(G_PROC_LEVEL,
1537: G_PKG_NAME, '801: l_max_sec_seq = '||l_max_sec_seq);
1538: END IF;

Line 1536: FND_LOG.STRING(G_PROC_LEVEL,

1532:
1533: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1534: FND_LOG.STRING(G_PROC_LEVEL,
1535: G_PKG_NAME, '801: l_art_seq = '||l_art_seq);
1536: FND_LOG.STRING(G_PROC_LEVEL,
1537: G_PKG_NAME, '801: l_max_sec_seq = '||l_max_sec_seq);
1538: END IF;
1539:
1540: IF(l_max_sec_seq > l_art_seq) then

Line 1583: FND_LOG.STRING(G_PROC_LEVEL,

1579: okc_debug.log('900: New Articles Inserted');
1580: END IF;*/
1581:
1582: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1583: FND_LOG.STRING(G_PROC_LEVEL,
1584: G_PKG_NAME, '900: New Articles Inserted' );
1585: END IF;
1586:
1587: -- call renumber automatically if any articles have been added or deleted

Line 1599: FND_LOG.STRING(G_PROC_LEVEL,

1595: okc_debug.log('150: l_num_scheme_id : '||l_num_scheme_id, 2);
1596: END IF;*/
1597:
1598: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1599: FND_LOG.STRING(G_PROC_LEVEL,
1600: G_PKG_NAME, '150: l_num_scheme_id : '||l_num_scheme_id );
1601: END IF;
1602:
1603: IF NVL(l_num_scheme_id,0) <> 0 THEN

Line 1610: FND_LOG.STRING(G_PROC_LEVEL,

1606: okc_debug.log('150: Calling apply_numbering_scheme for num_scheme_id : '||l_num_scheme_id, 2);
1607: END IF;*/
1608:
1609: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1610: FND_LOG.STRING(G_PROC_LEVEL,
1611: G_PKG_NAME, '150: Calling apply_numbering_scheme for num_scheme_id : '||l_num_scheme_id );
1612: END IF;
1613:
1614: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(

Line 1636: FND_LOG.STRING(G_PROC_LEVEL,

1632: okc_debug.log('150: x_msg_data : '||l_msg_data, 2);
1633: END IF;*/
1634:
1635: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1636: FND_LOG.STRING(G_PROC_LEVEL,
1637: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
1638: FND_LOG.STRING(G_PROC_LEVEL,
1639: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1640: FND_LOG.STRING(G_PROC_LEVEL,

Line 1638: FND_LOG.STRING(G_PROC_LEVEL,

1634:
1635: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1636: FND_LOG.STRING(G_PROC_LEVEL,
1637: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
1638: FND_LOG.STRING(G_PROC_LEVEL,
1639: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1640: FND_LOG.STRING(G_PROC_LEVEL,
1641: G_PKG_NAME, '150: x_msg_count : '||l_msg_count );
1642: FND_LOG.STRING(G_PROC_LEVEL,

Line 1640: FND_LOG.STRING(G_PROC_LEVEL,

1636: FND_LOG.STRING(G_PROC_LEVEL,
1637: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
1638: FND_LOG.STRING(G_PROC_LEVEL,
1639: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1640: FND_LOG.STRING(G_PROC_LEVEL,
1641: G_PKG_NAME, '150: x_msg_count : '||l_msg_count );
1642: FND_LOG.STRING(G_PROC_LEVEL,
1643: G_PKG_NAME, '150: x_msg_data : '||l_msg_data );
1644: END IF;

Line 1642: FND_LOG.STRING(G_PROC_LEVEL,

1638: FND_LOG.STRING(G_PROC_LEVEL,
1639: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1640: FND_LOG.STRING(G_PROC_LEVEL,
1641: G_PKG_NAME, '150: x_msg_count : '||l_msg_count );
1642: FND_LOG.STRING(G_PROC_LEVEL,
1643: G_PKG_NAME, '150: x_msg_data : '||l_msg_data );
1644: END IF;
1645:
1646: END IF; --l_num_scheme_id is not 0

Line 1666: FND_LOG.STRING(G_PROC_LEVEL,

1662: okc_debug.log('200: Leaving sync_doc_with_expert', 2);
1663: END IF;*/
1664:
1665: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1666: FND_LOG.STRING(G_PROC_LEVEL,
1667: G_PKG_NAME, '200: Leaving sync_doc_with_expert' );
1668: END IF;
1669:
1670: EXCEPTION

Line 1677: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 1735: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 1793: FND_LOG.STRING(G_EXCP_LEVEL,

1789: okc_debug.log('500: Leaving sync_doc_with_expert because of EXCEPTION: '||sqlerrm, 2);
1790: END IF;*/
1791:
1792: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1793: FND_LOG.STRING(G_EXCP_LEVEL,
1794: G_PKG_NAME, '500: Leaving sync_doc_with_expert because of EXCEPTION: '||sqlerrm );
1795: END IF;
1796:
1797: IF l_get_max_local_article_csr%ISOPEN THEN

Line 1901: FND_LOG.STRING(G_PROC_LEVEL,

1897: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
1898: END IF;*/
1899:
1900: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1901: FND_LOG.STRING(G_PROC_LEVEL,
1902: G_PKG_NAME, '100: Entered refresh_articles' );
1903: FND_LOG.STRING(G_PROC_LEVEL,
1904: G_PKG_NAME, '100: Parameter List ' );
1905: FND_LOG.STRING(G_PROC_LEVEL,

Line 1903: FND_LOG.STRING(G_PROC_LEVEL,

1899:
1900: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1901: FND_LOG.STRING(G_PROC_LEVEL,
1902: G_PKG_NAME, '100: Entered refresh_articles' );
1903: FND_LOG.STRING(G_PROC_LEVEL,
1904: G_PKG_NAME, '100: Parameter List ' );
1905: FND_LOG.STRING(G_PROC_LEVEL,
1906: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1907: FND_LOG.STRING(G_PROC_LEVEL,

Line 1905: FND_LOG.STRING(G_PROC_LEVEL,

1901: FND_LOG.STRING(G_PROC_LEVEL,
1902: G_PKG_NAME, '100: Entered refresh_articles' );
1903: FND_LOG.STRING(G_PROC_LEVEL,
1904: G_PKG_NAME, '100: Parameter List ' );
1905: FND_LOG.STRING(G_PROC_LEVEL,
1906: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1907: FND_LOG.STRING(G_PROC_LEVEL,
1908: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1909: FND_LOG.STRING(G_PROC_LEVEL,

Line 1907: FND_LOG.STRING(G_PROC_LEVEL,

1903: FND_LOG.STRING(G_PROC_LEVEL,
1904: G_PKG_NAME, '100: Parameter List ' );
1905: FND_LOG.STRING(G_PROC_LEVEL,
1906: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1907: FND_LOG.STRING(G_PROC_LEVEL,
1908: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1909: FND_LOG.STRING(G_PROC_LEVEL,
1910: G_PKG_NAME, '100: p_mode : '||p_mode );
1911: FND_LOG.STRING(G_PROC_LEVEL,

Line 1909: FND_LOG.STRING(G_PROC_LEVEL,

1905: FND_LOG.STRING(G_PROC_LEVEL,
1906: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1907: FND_LOG.STRING(G_PROC_LEVEL,
1908: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1909: FND_LOG.STRING(G_PROC_LEVEL,
1910: G_PKG_NAME, '100: p_mode : '||p_mode );
1911: FND_LOG.STRING(G_PROC_LEVEL,
1912: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1913: FND_LOG.STRING(G_PROC_LEVEL,

Line 1911: FND_LOG.STRING(G_PROC_LEVEL,

1907: FND_LOG.STRING(G_PROC_LEVEL,
1908: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1909: FND_LOG.STRING(G_PROC_LEVEL,
1910: G_PKG_NAME, '100: p_mode : '||p_mode );
1911: FND_LOG.STRING(G_PROC_LEVEL,
1912: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1913: FND_LOG.STRING(G_PROC_LEVEL,
1914: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1915: FND_LOG.STRING(G_PROC_LEVEL,

Line 1913: FND_LOG.STRING(G_PROC_LEVEL,

1909: FND_LOG.STRING(G_PROC_LEVEL,
1910: G_PKG_NAME, '100: p_mode : '||p_mode );
1911: FND_LOG.STRING(G_PROC_LEVEL,
1912: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1913: FND_LOG.STRING(G_PROC_LEVEL,
1914: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1915: FND_LOG.STRING(G_PROC_LEVEL,
1916: G_PKG_NAME, '100: p_commit : '||p_commit );
1917: FND_LOG.STRING(G_PROC_LEVEL,

Line 1915: FND_LOG.STRING(G_PROC_LEVEL,

1911: FND_LOG.STRING(G_PROC_LEVEL,
1912: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1913: FND_LOG.STRING(G_PROC_LEVEL,
1914: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1915: FND_LOG.STRING(G_PROC_LEVEL,
1916: G_PKG_NAME, '100: p_commit : '||p_commit );
1917: FND_LOG.STRING(G_PROC_LEVEL,
1918: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1919: FND_LOG.STRING(G_PROC_LEVEL,

Line 1917: FND_LOG.STRING(G_PROC_LEVEL,

1913: FND_LOG.STRING(G_PROC_LEVEL,
1914: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1915: FND_LOG.STRING(G_PROC_LEVEL,
1916: G_PKG_NAME, '100: p_commit : '||p_commit );
1917: FND_LOG.STRING(G_PROC_LEVEL,
1918: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1919: FND_LOG.STRING(G_PROC_LEVEL,
1920: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1921: END IF;

Line 1919: FND_LOG.STRING(G_PROC_LEVEL,

1915: FND_LOG.STRING(G_PROC_LEVEL,
1916: G_PKG_NAME, '100: p_commit : '||p_commit );
1917: FND_LOG.STRING(G_PROC_LEVEL,
1918: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1919: FND_LOG.STRING(G_PROC_LEVEL,
1920: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1921: END IF;
1922:
1923: -- Standard Start of API savepoint

Line 1954: FND_LOG.STRING(G_PROC_LEVEL,

1950: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
1951: END IF;*/
1952:
1953: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1954: FND_LOG.STRING(G_PROC_LEVEL,
1955: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
1956: END IF;
1957: RAISE FND_API.G_EXC_ERROR ;
1958: END IF;

Line 2004: FND_LOG.STRING(G_PROC_LEVEL,

2000: okc_debug.log('200: Leaving refresh_articles', 2);
2001: END IF;*/
2002:
2003: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2004: FND_LOG.STRING(G_PROC_LEVEL,
2005: G_PKG_NAME, '200: Leaving refresh_articles' );
2006: END IF;
2007:
2008: EXCEPTION

Line 2015: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 2033: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 2051: FND_LOG.STRING(G_EXCP_LEVEL,

2047: okc_debug.log('500: Leaving refresh_articles because of EXCEPTION: '||sqlerrm, 2);
2048: END IF;*/
2049:
2050: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2051: FND_LOG.STRING(G_EXCP_LEVEL,
2052: G_PKG_NAME, '500: Leaving refresh_articles because of EXCEPTION: '||sqlerrm );
2053: END IF;
2054:
2055: IF l_check_version%ISOPEN THEN

Line 2182: FND_LOG.STRING(G_PROC_LEVEL,

2178: okc_debug.log('100: p_to_object_id : '||p_to_object_id, 2);
2179: END IF;*/
2180:
2181: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2182: FND_LOG.STRING(G_PROC_LEVEL,
2183: G_PKG_NAME, '100: Entered organize_layout' );
2184: FND_LOG.STRING(G_PROC_LEVEL,
2185: G_PKG_NAME, '100: Parameter List ' );
2186: FND_LOG.STRING(G_PROC_LEVEL,

Line 2184: FND_LOG.STRING(G_PROC_LEVEL,

2180:
2181: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2182: FND_LOG.STRING(G_PROC_LEVEL,
2183: G_PKG_NAME, '100: Entered organize_layout' );
2184: FND_LOG.STRING(G_PROC_LEVEL,
2185: G_PKG_NAME, '100: Parameter List ' );
2186: FND_LOG.STRING(G_PROC_LEVEL,
2187: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2188: FND_LOG.STRING(G_PROC_LEVEL,

Line 2186: FND_LOG.STRING(G_PROC_LEVEL,

2182: FND_LOG.STRING(G_PROC_LEVEL,
2183: G_PKG_NAME, '100: Entered organize_layout' );
2184: FND_LOG.STRING(G_PROC_LEVEL,
2185: G_PKG_NAME, '100: Parameter List ' );
2186: FND_LOG.STRING(G_PROC_LEVEL,
2187: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2188: FND_LOG.STRING(G_PROC_LEVEL,
2189: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2190: FND_LOG.STRING(G_PROC_LEVEL,

Line 2188: FND_LOG.STRING(G_PROC_LEVEL,

2184: FND_LOG.STRING(G_PROC_LEVEL,
2185: G_PKG_NAME, '100: Parameter List ' );
2186: FND_LOG.STRING(G_PROC_LEVEL,
2187: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2188: FND_LOG.STRING(G_PROC_LEVEL,
2189: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2190: FND_LOG.STRING(G_PROC_LEVEL,
2191: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2192: FND_LOG.STRING(G_PROC_LEVEL,

Line 2190: FND_LOG.STRING(G_PROC_LEVEL,

2186: FND_LOG.STRING(G_PROC_LEVEL,
2187: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2188: FND_LOG.STRING(G_PROC_LEVEL,
2189: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2190: FND_LOG.STRING(G_PROC_LEVEL,
2191: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2192: FND_LOG.STRING(G_PROC_LEVEL,
2193: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2194: FND_LOG.STRING(G_PROC_LEVEL,

Line 2192: FND_LOG.STRING(G_PROC_LEVEL,

2188: FND_LOG.STRING(G_PROC_LEVEL,
2189: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2190: FND_LOG.STRING(G_PROC_LEVEL,
2191: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2192: FND_LOG.STRING(G_PROC_LEVEL,
2193: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2194: FND_LOG.STRING(G_PROC_LEVEL,
2195: G_PKG_NAME, '100: p_commit : '||p_commit );
2196: FND_LOG.STRING(G_PROC_LEVEL,

Line 2194: FND_LOG.STRING(G_PROC_LEVEL,

2190: FND_LOG.STRING(G_PROC_LEVEL,
2191: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2192: FND_LOG.STRING(G_PROC_LEVEL,
2193: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2194: FND_LOG.STRING(G_PROC_LEVEL,
2195: G_PKG_NAME, '100: p_commit : '||p_commit );
2196: FND_LOG.STRING(G_PROC_LEVEL,
2197: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2198: FND_LOG.STRING(G_PROC_LEVEL,

Line 2196: FND_LOG.STRING(G_PROC_LEVEL,

2192: FND_LOG.STRING(G_PROC_LEVEL,
2193: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2194: FND_LOG.STRING(G_PROC_LEVEL,
2195: G_PKG_NAME, '100: p_commit : '||p_commit );
2196: FND_LOG.STRING(G_PROC_LEVEL,
2197: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2198: FND_LOG.STRING(G_PROC_LEVEL,
2199: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2200: FND_LOG.STRING(G_PROC_LEVEL,

Line 2198: FND_LOG.STRING(G_PROC_LEVEL,

2194: FND_LOG.STRING(G_PROC_LEVEL,
2195: G_PKG_NAME, '100: p_commit : '||p_commit );
2196: FND_LOG.STRING(G_PROC_LEVEL,
2197: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2198: FND_LOG.STRING(G_PROC_LEVEL,
2199: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2200: FND_LOG.STRING(G_PROC_LEVEL,
2201: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2202: FND_LOG.STRING(G_PROC_LEVEL,

Line 2200: FND_LOG.STRING(G_PROC_LEVEL,

2196: FND_LOG.STRING(G_PROC_LEVEL,
2197: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2198: FND_LOG.STRING(G_PROC_LEVEL,
2199: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2200: FND_LOG.STRING(G_PROC_LEVEL,
2201: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2202: FND_LOG.STRING(G_PROC_LEVEL,
2203: G_PKG_NAME, '100: p_to_object_type : '||p_to_object_type );
2204: FND_LOG.STRING(G_PROC_LEVEL,

Line 2202: FND_LOG.STRING(G_PROC_LEVEL,

2198: FND_LOG.STRING(G_PROC_LEVEL,
2199: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2200: FND_LOG.STRING(G_PROC_LEVEL,
2201: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2202: FND_LOG.STRING(G_PROC_LEVEL,
2203: G_PKG_NAME, '100: p_to_object_type : '||p_to_object_type );
2204: FND_LOG.STRING(G_PROC_LEVEL,
2205: G_PKG_NAME, '100: p_to_object_id : '||p_to_object_id );
2206: END IF;

Line 2204: FND_LOG.STRING(G_PROC_LEVEL,

2200: FND_LOG.STRING(G_PROC_LEVEL,
2201: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2202: FND_LOG.STRING(G_PROC_LEVEL,
2203: G_PKG_NAME, '100: p_to_object_type : '||p_to_object_type );
2204: FND_LOG.STRING(G_PROC_LEVEL,
2205: G_PKG_NAME, '100: p_to_object_id : '||p_to_object_id );
2206: END IF;
2207:
2208: -- Standard Start of API savepoint

Line 2239: FND_LOG.STRING(G_PROC_LEVEL,

2235: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
2236: END IF;*/
2237:
2238: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2239: FND_LOG.STRING(G_PROC_LEVEL,
2240: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2241: END IF;
2242: RAISE FND_API.G_EXC_ERROR ;
2243: END IF;

Line 2251: FND_LOG.STRING(G_PROC_LEVEL,

2247: okc_debug.log('800: Error: Ref point should be either A,B or S', 2);
2248: END IF;*/
2249:
2250: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
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');

Line 2266: FND_LOG.STRING(G_PROC_LEVEL,

2262: okc_debug.log('300: Wrong Selection of Item Location', 2);
2263: END IF;*/
2264:
2265: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
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,

Line 2283: FND_LOG.STRING(G_PROC_LEVEL,

2279: okc_debug.log('400: Wrong Selection of Item Location', 2);
2280: END IF;*/
2281:
2282: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
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,

Line 2304: FND_LOG.STRING(G_PROC_LEVEL,

2300: okc_debug.log('500: Wrong Selection ', 2);
2301: END IF;*/
2302:
2303: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
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,

Line 2451: FND_LOG.STRING(G_PROC_LEVEL,

2447: okc_debug.log('600: Updating Display Sequence of cat_id '||p_organize_tbl(i).id, 2);
2448: END IF;*/
2449:
2450: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2451: FND_LOG.STRING(G_PROC_LEVEL,
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

Line 2488: FND_LOG.STRING(G_PROC_LEVEL,

2484: okc_debug.log('700: Updating Display Sequence of scn_id '||p_organize_tbl(i).id, 2);
2485: END IF;*/
2486:
2487: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2488: FND_LOG.STRING(G_PROC_LEVEL,
2489: G_PKG_NAME, '700: Updating Display Sequence of scn_id '||p_organize_tbl(i).id );
2490: END IF;
2491:
2492: l_ref_sequence := l_ref_sequence+10;

Line 2540: FND_LOG.STRING(G_PROC_LEVEL,

2536: okc_debug.log('800: Updating Display Sequence of cat_id '||scn_child_tbl(k).id, 2);
2537: END IF;*/
2538:
2539: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2540: FND_LOG.STRING(G_PROC_LEVEL,
2541: G_PKG_NAME, '800: Updating Display Sequence of cat_id '||scn_child_tbl(k).id );
2542: END IF;
2543:
2544: OKC_K_ARTICLES_GRP.update_article(

Line 2568: FND_LOG.STRING(G_PROC_LEVEL,

2564: okc_debug.log('900: Updating Display Sequence of scn_id '||scn_child_tbl(k).id, 2);
2565: END IF;*/
2566:
2567: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2568: FND_LOG.STRING(G_PROC_LEVEL,
2569: G_PKG_NAME, '900: Updating Display Sequence of scn_id '||scn_child_tbl(k).id );
2570: END IF;
2571:
2572: OKC_TERMS_SECTIONS_GRP.update_section(

Line 2608: FND_LOG.STRING(G_PROC_LEVEL,

2604: okc_debug.log('1000: Leaving organize_layout', 2);
2605: END IF;*/
2606:
2607: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2608: FND_LOG.STRING(G_PROC_LEVEL,
2609: G_PKG_NAME, '1000: Leaving organize_layout' );
2610: END IF;
2611:
2612: EXCEPTION

Line 2619: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 2653: FND_LOG.STRING(G_EXCP_LEVEL,

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,
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

Line 2687: FND_LOG.STRING(G_EXCP_LEVEL,

2683: okc_debug.log('1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm, 2);
2684: END IF;*/
2685:
2686: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2687: FND_LOG.STRING(G_EXCP_LEVEL,
2688: G_PKG_NAME, '1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm );
2689: END IF;
2690:
2691: IF l_get_scn_child%ISOPEN THEN

Line 2799: FND_LOG.STRING(G_PROC_LEVEL,

2795:
2796: BEGIN
2797:
2798: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2799: FND_LOG.STRING(G_PROC_LEVEL,
2800: G_PKG_NAME, '100: Entered merge_review_clauses' );
2801: FND_LOG.STRING(G_PROC_LEVEL,
2802: G_PKG_NAME, '100: Parameter List ' );
2803: FND_LOG.STRING(G_PROC_LEVEL,

Line 2801: FND_LOG.STRING(G_PROC_LEVEL,

2797:
2798: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2799: FND_LOG.STRING(G_PROC_LEVEL,
2800: G_PKG_NAME, '100: Entered merge_review_clauses' );
2801: FND_LOG.STRING(G_PROC_LEVEL,
2802: G_PKG_NAME, '100: Parameter List ' );
2803: FND_LOG.STRING(G_PROC_LEVEL,
2804: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2805: FND_LOG.STRING(G_PROC_LEVEL,

Line 2803: FND_LOG.STRING(G_PROC_LEVEL,

2799: FND_LOG.STRING(G_PROC_LEVEL,
2800: G_PKG_NAME, '100: Entered merge_review_clauses' );
2801: FND_LOG.STRING(G_PROC_LEVEL,
2802: G_PKG_NAME, '100: Parameter List ' );
2803: FND_LOG.STRING(G_PROC_LEVEL,
2804: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2805: FND_LOG.STRING(G_PROC_LEVEL,
2806: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2807: FND_LOG.STRING(G_PROC_LEVEL,

Line 2805: FND_LOG.STRING(G_PROC_LEVEL,

2801: FND_LOG.STRING(G_PROC_LEVEL,
2802: G_PKG_NAME, '100: Parameter List ' );
2803: FND_LOG.STRING(G_PROC_LEVEL,
2804: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2805: FND_LOG.STRING(G_PROC_LEVEL,
2806: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2807: FND_LOG.STRING(G_PROC_LEVEL,
2808: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2809: FND_LOG.STRING(G_PROC_LEVEL,

Line 2807: FND_LOG.STRING(G_PROC_LEVEL,

2803: FND_LOG.STRING(G_PROC_LEVEL,
2804: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2805: FND_LOG.STRING(G_PROC_LEVEL,
2806: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2807: FND_LOG.STRING(G_PROC_LEVEL,
2808: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2809: FND_LOG.STRING(G_PROC_LEVEL,
2810: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2811: FND_LOG.STRING(G_PROC_LEVEL,

Line 2809: FND_LOG.STRING(G_PROC_LEVEL,

2805: FND_LOG.STRING(G_PROC_LEVEL,
2806: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2807: FND_LOG.STRING(G_PROC_LEVEL,
2808: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2809: FND_LOG.STRING(G_PROC_LEVEL,
2810: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2811: FND_LOG.STRING(G_PROC_LEVEL,
2812: G_PKG_NAME, '100: p_commit : '||p_commit );
2813: FND_LOG.STRING(G_PROC_LEVEL,

Line 2811: FND_LOG.STRING(G_PROC_LEVEL,

2807: FND_LOG.STRING(G_PROC_LEVEL,
2808: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2809: FND_LOG.STRING(G_PROC_LEVEL,
2810: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2811: FND_LOG.STRING(G_PROC_LEVEL,
2812: G_PKG_NAME, '100: p_commit : '||p_commit );
2813: FND_LOG.STRING(G_PROC_LEVEL,
2814: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2815: FND_LOG.STRING(G_PROC_LEVEL,

Line 2813: FND_LOG.STRING(G_PROC_LEVEL,

2809: FND_LOG.STRING(G_PROC_LEVEL,
2810: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2811: FND_LOG.STRING(G_PROC_LEVEL,
2812: G_PKG_NAME, '100: p_commit : '||p_commit );
2813: FND_LOG.STRING(G_PROC_LEVEL,
2814: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2815: FND_LOG.STRING(G_PROC_LEVEL,
2816: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2817: END IF;

Line 2815: FND_LOG.STRING(G_PROC_LEVEL,

2811: FND_LOG.STRING(G_PROC_LEVEL,
2812: G_PKG_NAME, '100: p_commit : '||p_commit );
2813: FND_LOG.STRING(G_PROC_LEVEL,
2814: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2815: FND_LOG.STRING(G_PROC_LEVEL,
2816: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2817: END IF;
2818:
2819: -- Standard Start of API savepoint

Line 2859: FND_LOG.STRING(G_PROC_LEVEL,

2855: x_msg_count => x_msg_count) ) THEN
2856:
2857:
2858: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2859: FND_LOG.STRING(G_PROC_LEVEL,
2860: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2861: END IF;
2862: RAISE FND_API.G_EXC_ERROR ;
2863: END IF;

Line 2887: FND_LOG.STRING(G_PROC_LEVEL,

2883: l_article_text_locked := 'N';
2884: IF p_merge_review_tbl(1).object_type <> 'ARTICLE' THEN
2885:
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'

Line 2906: FND_LOG.STRING(G_PROC_LEVEL,

2902:
2903: IF l_article_ibr = 'Y' and (l_user_access <> 'SUPER_USER') THEN
2904:
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'

Line 2918: FND_LOG.STRING(G_PROC_LEVEL,

2914:
2915: IF l_article_text_locked = 'Y' AND (l_user_access <> 'SUPER_USER') THEN
2916:
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');

Line 2933: FND_LOG.STRING(G_PROC_LEVEL,

2929: l_article_text_locked := 'N';
2930: IF p_merge_review_tbl(i).object_type <> 'ARTICLE' THEN
2931:
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');

Line 2948: FND_LOG.STRING(G_PROC_LEVEL,

2944: -- Fix for bug# 4779506. Changed check to NOT and changed parameter for fnd_function.test
2945: IF l_article_mandatory = 'Y' AND (l_user_access <> 'SUPER_USER') THEN
2946:
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'

Line 2966: FND_LOG.STRING(G_PROC_LEVEL,

2962: l_temp_err_msg_count,
2963: l_temp_wrn_msg_count;
2964: CLOSE l_get_article_text_csr;
2965: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2966: FND_LOG.STRING(G_PROC_LEVEL,
2967: G_PKG_NAME, '500: l_temp_action : '||l_temp_action );
2968: FND_LOG.STRING(G_PROC_LEVEL,
2969: G_PKG_NAME, '500: l_temp_err_msg_count : '||l_temp_err_msg_count);
2970: FND_LOG.STRING(G_PROC_LEVEL,

Line 2968: FND_LOG.STRING(G_PROC_LEVEL,

2964: CLOSE l_get_article_text_csr;
2965: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2966: FND_LOG.STRING(G_PROC_LEVEL,
2967: G_PKG_NAME, '500: l_temp_action : '||l_temp_action );
2968: FND_LOG.STRING(G_PROC_LEVEL,
2969: G_PKG_NAME, '500: l_temp_err_msg_count : '||l_temp_err_msg_count);
2970: FND_LOG.STRING(G_PROC_LEVEL,
2971: G_PKG_NAME, '500: l_temp_wrn_msg_count : '||l_temp_wrn_msg_count);
2972: END IF;

Line 2970: FND_LOG.STRING(G_PROC_LEVEL,

2966: FND_LOG.STRING(G_PROC_LEVEL,
2967: G_PKG_NAME, '500: l_temp_action : '||l_temp_action );
2968: FND_LOG.STRING(G_PROC_LEVEL,
2969: G_PKG_NAME, '500: l_temp_err_msg_count : '||l_temp_err_msg_count);
2970: FND_LOG.STRING(G_PROC_LEVEL,
2971: G_PKG_NAME, '500: l_temp_wrn_msg_count : '||l_temp_wrn_msg_count);
2972: END IF;
2973: l_final_article_text := l_final_article_text || l_temp_article_text;
2974: l_final_err_msg_count := l_final_err_msg_count + l_temp_err_msg_count;

Line 3031: FND_LOG.STRING(G_PROC_LEVEL,

3027: l_final_wrn_msg_count := G_MISS_NUM;
3028: END IF;
3029:
3030: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3031: FND_LOG.STRING(G_PROC_LEVEL,
3032: G_PKG_NAME, '500: l_new_action : '||l_new_action );
3033: FND_LOG.STRING(G_PROC_LEVEL,
3034: G_PKG_NAME, '500: l_final_err_msg_count : '||l_final_err_msg_count);
3035: FND_LOG.STRING(G_PROC_LEVEL,

Line 3033: FND_LOG.STRING(G_PROC_LEVEL,

3029:
3030: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3031: FND_LOG.STRING(G_PROC_LEVEL,
3032: G_PKG_NAME, '500: l_new_action : '||l_new_action );
3033: FND_LOG.STRING(G_PROC_LEVEL,
3034: G_PKG_NAME, '500: l_final_err_msg_count : '||l_final_err_msg_count);
3035: FND_LOG.STRING(G_PROC_LEVEL,
3036: G_PKG_NAME, '500: l_final_wrn_msg_count : '||l_final_wrn_msg_count);
3037: END IF;

Line 3035: FND_LOG.STRING(G_PROC_LEVEL,

3031: FND_LOG.STRING(G_PROC_LEVEL,
3032: G_PKG_NAME, '500: l_new_action : '||l_new_action );
3033: FND_LOG.STRING(G_PROC_LEVEL,
3034: G_PKG_NAME, '500: l_final_err_msg_count : '||l_final_err_msg_count);
3035: FND_LOG.STRING(G_PROC_LEVEL,
3036: G_PKG_NAME, '500: l_final_wrn_msg_count : '||l_final_wrn_msg_count);
3037: END IF;
3038:
3039: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

Line 3086: FND_LOG.STRING(G_PROC_LEVEL,

3082: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3083:
3084:
3085: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3086: FND_LOG.STRING(G_PROC_LEVEL,
3087: G_PKG_NAME, '1000: Leaving merge_review_clauses' );
3088: END IF;
3089:
3090: EXCEPTION

Line 3094: FND_LOG.STRING(G_EXCP_LEVEL,

3090: 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

Line 3111: FND_LOG.STRING(G_EXCP_LEVEL,

3107:
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

Line 3127: FND_LOG.STRING(G_EXCP_LEVEL,

3123: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3124:
3125: WHEN OTHERS THEN
3126: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3127: FND_LOG.STRING(G_EXCP_LEVEL,
3128: G_PKG_NAME, '1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm );
3129: END IF;
3130:
3131: IF article_properties%ISOPEN THEN