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

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

Line 481: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 483: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 485: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 487: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 489: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 491: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 493: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 495: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 531: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 548: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 584: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 625: FND_LOG.STRING(G_PROC_LEVEL,

621: okc_debug.log('200: Leaving update_article_variable', 2);
622: END IF;*/
623:
624: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
625: FND_LOG.STRING(G_PROC_LEVEL,
626: G_PKG_NAME, '200: Leaving update_article_variable' );
627: END IF;
628:
629: EXCEPTION

Line 636: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 654: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 672: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 731: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 733: FND_LOG.STRING(G_PROC_LEVEL,

729:
730: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
731: FND_LOG.STRING(G_PROC_LEVEL,
732: G_PKG_NAME, '100: Entered update_structure' );
733: FND_LOG.STRING(G_PROC_LEVEL,
734: G_PKG_NAME, '100: Parameter List ' );
735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_api_version : '||p_api_version );
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: Entered update_structure' );
733: FND_LOG.STRING(G_PROC_LEVEL,
734: G_PKG_NAME, '100: Parameter List ' );
735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_api_version : '||p_api_version );
737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
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: Parameter List ' );
735: FND_LOG.STRING(G_PROC_LEVEL,
736: G_PKG_NAME, '100: p_api_version : '||p_api_version );
737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
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_api_version : '||p_api_version );
737: FND_LOG.STRING(G_PROC_LEVEL,
738: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
741: FND_LOG.STRING(G_PROC_LEVEL,
742: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
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_init_msg_list : '||p_init_msg_list );
739: FND_LOG.STRING(G_PROC_LEVEL,
740: G_PKG_NAME, '100: p_validation_level : '||p_validation_level );
741: FND_LOG.STRING(G_PROC_LEVEL,
742: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
743: FND_LOG.STRING(G_PROC_LEVEL,
744: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
745: FND_LOG.STRING(G_PROC_LEVEL,

Line 743: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 745: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 793: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 872: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 883: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 905: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 927: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 1169: FND_LOG.STRING(G_PROC_LEVEL,

1165: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
1166: END IF;*/
1167:
1168: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1169: FND_LOG.STRING(G_PROC_LEVEL,
1170: G_PKG_NAME, '100: Entered sync_doc_with_expert' );
1171: FND_LOG.STRING(G_PROC_LEVEL,
1172: G_PKG_NAME, '100: Parameter List ' );
1173: FND_LOG.STRING(G_PROC_LEVEL,

Line 1171: FND_LOG.STRING(G_PROC_LEVEL,

1167:
1168: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1169: FND_LOG.STRING(G_PROC_LEVEL,
1170: G_PKG_NAME, '100: Entered sync_doc_with_expert' );
1171: FND_LOG.STRING(G_PROC_LEVEL,
1172: G_PKG_NAME, '100: Parameter List ' );
1173: FND_LOG.STRING(G_PROC_LEVEL,
1174: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1175: FND_LOG.STRING(G_PROC_LEVEL,

Line 1173: FND_LOG.STRING(G_PROC_LEVEL,

1169: FND_LOG.STRING(G_PROC_LEVEL,
1170: G_PKG_NAME, '100: Entered sync_doc_with_expert' );
1171: FND_LOG.STRING(G_PROC_LEVEL,
1172: G_PKG_NAME, '100: Parameter List ' );
1173: FND_LOG.STRING(G_PROC_LEVEL,
1174: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1175: FND_LOG.STRING(G_PROC_LEVEL,
1176: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1177: FND_LOG.STRING(G_PROC_LEVEL,

Line 1175: FND_LOG.STRING(G_PROC_LEVEL,

1171: FND_LOG.STRING(G_PROC_LEVEL,
1172: G_PKG_NAME, '100: Parameter List ' );
1173: FND_LOG.STRING(G_PROC_LEVEL,
1174: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1175: FND_LOG.STRING(G_PROC_LEVEL,
1176: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1177: FND_LOG.STRING(G_PROC_LEVEL,
1178: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1179: FND_LOG.STRING(G_PROC_LEVEL,

Line 1177: FND_LOG.STRING(G_PROC_LEVEL,

1173: FND_LOG.STRING(G_PROC_LEVEL,
1174: G_PKG_NAME, '100: p_api_version : '||p_api_version );
1175: FND_LOG.STRING(G_PROC_LEVEL,
1176: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1177: FND_LOG.STRING(G_PROC_LEVEL,
1178: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1179: FND_LOG.STRING(G_PROC_LEVEL,
1180: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1181: FND_LOG.STRING(G_PROC_LEVEL,

Line 1179: FND_LOG.STRING(G_PROC_LEVEL,

1175: FND_LOG.STRING(G_PROC_LEVEL,
1176: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
1177: FND_LOG.STRING(G_PROC_LEVEL,
1178: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1179: FND_LOG.STRING(G_PROC_LEVEL,
1180: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1181: FND_LOG.STRING(G_PROC_LEVEL,
1182: G_PKG_NAME, '100: p_commit : '||p_commit );
1183: FND_LOG.STRING(G_PROC_LEVEL,

Line 1181: FND_LOG.STRING(G_PROC_LEVEL,

1177: FND_LOG.STRING(G_PROC_LEVEL,
1178: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
1179: FND_LOG.STRING(G_PROC_LEVEL,
1180: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1181: FND_LOG.STRING(G_PROC_LEVEL,
1182: G_PKG_NAME, '100: p_commit : '||p_commit );
1183: FND_LOG.STRING(G_PROC_LEVEL,
1184: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1185: FND_LOG.STRING(G_PROC_LEVEL,

Line 1183: FND_LOG.STRING(G_PROC_LEVEL,

1179: FND_LOG.STRING(G_PROC_LEVEL,
1180: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
1181: FND_LOG.STRING(G_PROC_LEVEL,
1182: G_PKG_NAME, '100: p_commit : '||p_commit );
1183: FND_LOG.STRING(G_PROC_LEVEL,
1184: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1185: FND_LOG.STRING(G_PROC_LEVEL,
1186: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1187: END IF;

Line 1185: FND_LOG.STRING(G_PROC_LEVEL,

1181: FND_LOG.STRING(G_PROC_LEVEL,
1182: G_PKG_NAME, '100: p_commit : '||p_commit );
1183: FND_LOG.STRING(G_PROC_LEVEL,
1184: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
1185: FND_LOG.STRING(G_PROC_LEVEL,
1186: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
1187: END IF;
1188:
1189: -- Standard Start of API savepoint

Line 1224: FND_LOG.STRING(G_PROC_LEVEL,

1220: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
1221: END IF;*/
1222:
1223: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1224: FND_LOG.STRING(G_PROC_LEVEL,
1225: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
1226: END IF;
1227: RAISE FND_API.G_EXC_ERROR ;
1228: END IF;

Line 1246: FND_LOG.STRING(G_PROC_LEVEL,

1242: okc_Debug.Log('100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag,2);
1243: END IF;*/
1244:
1245: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1246: FND_LOG.STRING(G_PROC_LEVEL,
1247: G_PKG_NAME, '100: l_prov_allowed : '||l_prov_allowed );
1248: FND_LOG.STRING(G_PROC_LEVEL,
1249: G_PKG_NAME, '100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag );
1250: END IF;

Line 1248: FND_LOG.STRING(G_PROC_LEVEL,

1244:
1245: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1246: FND_LOG.STRING(G_PROC_LEVEL,
1247: G_PKG_NAME, '100: l_prov_allowed : '||l_prov_allowed );
1248: FND_LOG.STRING(G_PROC_LEVEL,
1249: G_PKG_NAME, '100: l_xprt_clause_mandatory_flag : '||l_xprt_clause_mandatory_flag );
1250: END IF;
1251:
1252: 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 1261: FND_LOG.STRING(G_PROC_LEVEL,

1257: okc_debug.log('200: Article Count from Expert : '||p_article_id_tbl.COUNT,2);
1258: END IF;*/
1259:
1260: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1261: FND_LOG.STRING(G_PROC_LEVEL,
1262: G_PKG_NAME, '200: Article Count from Expert : '||p_article_id_tbl.COUNT );
1263: END IF;
1264:
1265: IF p_article_id_tbl.COUNT > 0 THEN

Line 1297: FND_LOG.STRING(G_PROC_LEVEL,

1293: okc_debug.log('300: Query Is '||l_query);
1294: END IF;*/
1295:
1296: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1297: FND_LOG.STRING(G_PROC_LEVEL,
1298: G_PKG_NAME, '300: Query Is '||l_query );
1299: END IF;
1300:
1301: -- Find out article which

Line 1307: FND_LOG.STRING(G_PROC_LEVEL,

1303: okc_debug.log('400: Going to delete Articles which came from expert last time but not present in expert this time');
1304: END IF;*/
1305:
1306: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1307: FND_LOG.STRING(G_PROC_LEVEL,
1308: G_PKG_NAME, '400: Going to delete Articles which came from expert last time but not present in expert this time' );
1309: END IF;
1310:
1311: OPEN l_check_existing_csr FOR l_query USING p_doc_type,p_doc_id;

Line 1354: FND_LOG.STRING(G_PROC_LEVEL,

1350: okc_debug.log('600: Inserting Articles : '||l_insert_tbl.COUNT,2);
1351: END IF;*/
1352:
1353: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1354: FND_LOG.STRING(G_PROC_LEVEL,
1355: G_PKG_NAME, '500: Articles Delete ' );
1356: FND_LOG.STRING(G_PROC_LEVEL,
1357: G_PKG_NAME, '600: Going to insert new Articles retunred by expert' );
1358: FND_LOG.STRING(G_PROC_LEVEL,

Line 1356: FND_LOG.STRING(G_PROC_LEVEL,

1352:
1353: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1354: FND_LOG.STRING(G_PROC_LEVEL,
1355: G_PKG_NAME, '500: Articles Delete ' );
1356: FND_LOG.STRING(G_PROC_LEVEL,
1357: G_PKG_NAME, '600: Going to insert new Articles retunred by expert' );
1358: FND_LOG.STRING(G_PROC_LEVEL,
1359: G_PKG_NAME, '600: Inserting Articles : '||l_insert_tbl.COUNT );
1360: END IF;

Line 1358: FND_LOG.STRING(G_PROC_LEVEL,

1354: FND_LOG.STRING(G_PROC_LEVEL,
1355: G_PKG_NAME, '500: Articles Delete ' );
1356: FND_LOG.STRING(G_PROC_LEVEL,
1357: G_PKG_NAME, '600: Going to insert new Articles retunred by expert' );
1358: FND_LOG.STRING(G_PROC_LEVEL,
1359: G_PKG_NAME, '600: Inserting Articles : '||l_insert_tbl.COUNT );
1360: END IF;
1361:
1362: IF l_insert_tbl.COUNT > 0 THEN

Line 1525: FND_LOG.STRING(G_PROC_LEVEL,

1521: okc_debug.log('700: Going to create section '|| l_article_rec.scn_code);
1522: END IF;*/
1523:
1524: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1525: FND_LOG.STRING(G_PROC_LEVEL,
1526: G_PKG_NAME, '700: Going to create section '|| l_article_rec.scn_code );
1527: END IF;
1528:
1529: OKC_TERMS_SECTIONS_GRP.create_section(

Line 1559: FND_LOG.STRING(G_PROC_LEVEL,

1555: okc_debug.log('800: section created');
1556: END IF;*/
1557:
1558: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1559: FND_LOG.STRING(G_PROC_LEVEL,
1560: G_PKG_NAME, '800: section created' );
1561: END IF;
1562:
1563: END IF;

Line 1577: FND_LOG.STRING(G_PROC_LEVEL,

1573: FETCH l_get_sec_seq_csr INTO l_max_sec_seq;
1574: CLOSE l_get_sec_seq_csr;
1575:
1576: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1577: FND_LOG.STRING(G_PROC_LEVEL,
1578: G_PKG_NAME, '801: l_art_seq = '||l_art_seq);
1579: FND_LOG.STRING(G_PROC_LEVEL,
1580: G_PKG_NAME, '801: l_max_sec_seq = '||l_max_sec_seq);
1581: END IF;

Line 1579: FND_LOG.STRING(G_PROC_LEVEL,

1575:
1576: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1577: FND_LOG.STRING(G_PROC_LEVEL,
1578: G_PKG_NAME, '801: l_art_seq = '||l_art_seq);
1579: FND_LOG.STRING(G_PROC_LEVEL,
1580: G_PKG_NAME, '801: l_max_sec_seq = '||l_max_sec_seq);
1581: END IF;
1582:
1583: IF(l_max_sec_seq > l_art_seq) then

Line 1626: FND_LOG.STRING(G_PROC_LEVEL,

1622: okc_debug.log('900: New Articles Inserted');
1623: END IF;*/
1624:
1625: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1626: FND_LOG.STRING(G_PROC_LEVEL,
1627: G_PKG_NAME, '900: New Articles Inserted' );
1628: END IF;
1629:
1630:

Line 1632: FND_LOG.STRING(G_PROC_LEVEL,

1628: END IF;
1629:
1630:
1631: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1632: FND_LOG.STRING(G_PROC_LEVEL,
1633: G_PKG_NAME, '950:Calling Code Hook to check if ordering by clause number has to be done');
1634: END IF;
1635:
1636: OKC_CODE_HOOK.GET_XPRT_CLAUSE_ORDER(

Line 1645: FND_LOG.STRING(G_PROC_LEVEL,

1641: x_hook_used => l_hook_used
1642: );
1643:
1644: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1645: FND_LOG.STRING(G_PROC_LEVEL,
1646: G_PKG_NAME, '975:Update the Clause Display Sequence if the code hook is being used');
1647: END IF;
1648:
1649: IF l_hook_used = 1 AND l_order_by_column='CLAUSE_NUMBER' THEN

Line 1681: FND_LOG.STRING(G_PROC_LEVEL,

1677:
1678: END IF; -- l_hook_used = 1
1679:
1680: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1681: FND_LOG.STRING(G_PROC_LEVEL,
1682: G_PKG_NAME, '980:Calling Code Hook to sync Rwa and Mandatory flags');
1683: END IF;
1684:
1685: IF p_article_id_tbl.Count > 0 THEN

Line 1710: FND_LOG.STRING(G_PROC_LEVEL,

1706: okc_debug.log('150: l_num_scheme_id : '||l_num_scheme_id, 2);
1707: END IF;*/
1708:
1709: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1710: FND_LOG.STRING(G_PROC_LEVEL,
1711: G_PKG_NAME, '150: l_num_scheme_id : '||l_num_scheme_id );
1712: END IF;
1713:
1714: IF NVL(l_num_scheme_id,0) <> 0 THEN

Line 1721: FND_LOG.STRING(G_PROC_LEVEL,

1717: okc_debug.log('150: Calling apply_numbering_scheme for num_scheme_id : '||l_num_scheme_id, 2);
1718: END IF;*/
1719:
1720: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1721: FND_LOG.STRING(G_PROC_LEVEL,
1722: G_PKG_NAME, '150: Calling apply_numbering_scheme for num_scheme_id : '||l_num_scheme_id );
1723: END IF;
1724:
1725: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(

Line 1747: FND_LOG.STRING(G_PROC_LEVEL,

1743: okc_debug.log('150: x_msg_data : '||l_msg_data, 2);
1744: END IF;*/
1745:
1746: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1747: FND_LOG.STRING(G_PROC_LEVEL,
1748: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
1749: FND_LOG.STRING(G_PROC_LEVEL,
1750: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1751: FND_LOG.STRING(G_PROC_LEVEL,

Line 1749: FND_LOG.STRING(G_PROC_LEVEL,

1745:
1746: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1747: FND_LOG.STRING(G_PROC_LEVEL,
1748: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
1749: FND_LOG.STRING(G_PROC_LEVEL,
1750: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1751: FND_LOG.STRING(G_PROC_LEVEL,
1752: G_PKG_NAME, '150: x_msg_count : '||l_msg_count );
1753: FND_LOG.STRING(G_PROC_LEVEL,

Line 1751: FND_LOG.STRING(G_PROC_LEVEL,

1747: FND_LOG.STRING(G_PROC_LEVEL,
1748: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
1749: FND_LOG.STRING(G_PROC_LEVEL,
1750: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1751: FND_LOG.STRING(G_PROC_LEVEL,
1752: G_PKG_NAME, '150: x_msg_count : '||l_msg_count );
1753: FND_LOG.STRING(G_PROC_LEVEL,
1754: G_PKG_NAME, '150: x_msg_data : '||l_msg_data );
1755: END IF;

Line 1753: FND_LOG.STRING(G_PROC_LEVEL,

1749: FND_LOG.STRING(G_PROC_LEVEL,
1750: G_PKG_NAME, '150: x_return_status : '||x_return_status );
1751: FND_LOG.STRING(G_PROC_LEVEL,
1752: G_PKG_NAME, '150: x_msg_count : '||l_msg_count );
1753: FND_LOG.STRING(G_PROC_LEVEL,
1754: G_PKG_NAME, '150: x_msg_data : '||l_msg_data );
1755: END IF;
1756:
1757: END IF; --l_num_scheme_id is not 0

Line 1777: FND_LOG.STRING(G_PROC_LEVEL,

1773: okc_debug.log('200: Leaving sync_doc_with_expert', 2);
1774: END IF;*/
1775:
1776: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1777: FND_LOG.STRING(G_PROC_LEVEL,
1778: G_PKG_NAME, '200: Leaving sync_doc_with_expert' );
1779: END IF;
1780:
1781: EXCEPTION

Line 1788: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 1846: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 1904: FND_LOG.STRING(G_EXCP_LEVEL,

1900: okc_debug.log('500: Leaving sync_doc_with_expert because of EXCEPTION: '||sqlerrm, 2);
1901: END IF;*/
1902:
1903: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1904: FND_LOG.STRING(G_EXCP_LEVEL,
1905: G_PKG_NAME, '500: Leaving sync_doc_with_expert because of EXCEPTION: '||sqlerrm );
1906: END IF;
1907:
1908: IF l_get_max_local_article_csr%ISOPEN THEN

Line 2013: FND_LOG.STRING(G_PROC_LEVEL,

2009: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
2010: END IF;*/
2011:
2012: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2013: FND_LOG.STRING(G_PROC_LEVEL,
2014: G_PKG_NAME, '100: Entered refresh_articles' );
2015: FND_LOG.STRING(G_PROC_LEVEL,
2016: G_PKG_NAME, '100: Parameter List ' );
2017: FND_LOG.STRING(G_PROC_LEVEL,

Line 2015: FND_LOG.STRING(G_PROC_LEVEL,

2011:
2012: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2013: FND_LOG.STRING(G_PROC_LEVEL,
2014: G_PKG_NAME, '100: Entered refresh_articles' );
2015: FND_LOG.STRING(G_PROC_LEVEL,
2016: G_PKG_NAME, '100: Parameter List ' );
2017: FND_LOG.STRING(G_PROC_LEVEL,
2018: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2019: FND_LOG.STRING(G_PROC_LEVEL,

Line 2017: FND_LOG.STRING(G_PROC_LEVEL,

2013: FND_LOG.STRING(G_PROC_LEVEL,
2014: G_PKG_NAME, '100: Entered refresh_articles' );
2015: FND_LOG.STRING(G_PROC_LEVEL,
2016: G_PKG_NAME, '100: Parameter List ' );
2017: FND_LOG.STRING(G_PROC_LEVEL,
2018: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2019: FND_LOG.STRING(G_PROC_LEVEL,
2020: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2021: FND_LOG.STRING(G_PROC_LEVEL,

Line 2019: FND_LOG.STRING(G_PROC_LEVEL,

2015: FND_LOG.STRING(G_PROC_LEVEL,
2016: G_PKG_NAME, '100: Parameter List ' );
2017: FND_LOG.STRING(G_PROC_LEVEL,
2018: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2019: FND_LOG.STRING(G_PROC_LEVEL,
2020: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2021: FND_LOG.STRING(G_PROC_LEVEL,
2022: G_PKG_NAME, '100: p_mode : '||p_mode );
2023: FND_LOG.STRING(G_PROC_LEVEL,

Line 2021: FND_LOG.STRING(G_PROC_LEVEL,

2017: FND_LOG.STRING(G_PROC_LEVEL,
2018: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2019: FND_LOG.STRING(G_PROC_LEVEL,
2020: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2021: FND_LOG.STRING(G_PROC_LEVEL,
2022: G_PKG_NAME, '100: p_mode : '||p_mode );
2023: FND_LOG.STRING(G_PROC_LEVEL,
2024: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2025: FND_LOG.STRING(G_PROC_LEVEL,

Line 2023: FND_LOG.STRING(G_PROC_LEVEL,

2019: FND_LOG.STRING(G_PROC_LEVEL,
2020: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2021: FND_LOG.STRING(G_PROC_LEVEL,
2022: G_PKG_NAME, '100: p_mode : '||p_mode );
2023: FND_LOG.STRING(G_PROC_LEVEL,
2024: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2025: FND_LOG.STRING(G_PROC_LEVEL,
2026: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2027: FND_LOG.STRING(G_PROC_LEVEL,

Line 2025: FND_LOG.STRING(G_PROC_LEVEL,

2021: FND_LOG.STRING(G_PROC_LEVEL,
2022: G_PKG_NAME, '100: p_mode : '||p_mode );
2023: FND_LOG.STRING(G_PROC_LEVEL,
2024: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2025: FND_LOG.STRING(G_PROC_LEVEL,
2026: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2027: FND_LOG.STRING(G_PROC_LEVEL,
2028: G_PKG_NAME, '100: p_commit : '||p_commit );
2029: FND_LOG.STRING(G_PROC_LEVEL,

Line 2027: FND_LOG.STRING(G_PROC_LEVEL,

2023: FND_LOG.STRING(G_PROC_LEVEL,
2024: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2025: FND_LOG.STRING(G_PROC_LEVEL,
2026: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2027: FND_LOG.STRING(G_PROC_LEVEL,
2028: G_PKG_NAME, '100: p_commit : '||p_commit );
2029: FND_LOG.STRING(G_PROC_LEVEL,
2030: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2031: FND_LOG.STRING(G_PROC_LEVEL,

Line 2029: FND_LOG.STRING(G_PROC_LEVEL,

2025: FND_LOG.STRING(G_PROC_LEVEL,
2026: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2027: FND_LOG.STRING(G_PROC_LEVEL,
2028: G_PKG_NAME, '100: p_commit : '||p_commit );
2029: FND_LOG.STRING(G_PROC_LEVEL,
2030: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2031: FND_LOG.STRING(G_PROC_LEVEL,
2032: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2033: END IF;

Line 2031: FND_LOG.STRING(G_PROC_LEVEL,

2027: FND_LOG.STRING(G_PROC_LEVEL,
2028: G_PKG_NAME, '100: p_commit : '||p_commit );
2029: FND_LOG.STRING(G_PROC_LEVEL,
2030: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2031: FND_LOG.STRING(G_PROC_LEVEL,
2032: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2033: END IF;
2034:
2035: -- Standard Start of API savepoint

Line 2066: FND_LOG.STRING(G_PROC_LEVEL,

2062: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
2063: END IF;*/
2064:
2065: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2066: FND_LOG.STRING(G_PROC_LEVEL,
2067: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2068: END IF;
2069: RAISE FND_API.G_EXC_ERROR ;
2070: END IF;

Line 2117: FND_LOG.STRING(G_PROC_LEVEL,

2113: okc_debug.log('200: Leaving refresh_articles', 2);
2114: END IF;*/
2115:
2116: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2117: FND_LOG.STRING(G_PROC_LEVEL,
2118: G_PKG_NAME, '200: Leaving refresh_articles' );
2119: END IF;
2120:
2121: EXCEPTION

Line 2128: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 2146: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 2164: FND_LOG.STRING(G_EXCP_LEVEL,

2160: okc_debug.log('500: Leaving refresh_articles because of EXCEPTION: '||sqlerrm, 2);
2161: END IF;*/
2162:
2163: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2164: FND_LOG.STRING(G_EXCP_LEVEL,
2165: G_PKG_NAME, '500: Leaving refresh_articles because of EXCEPTION: '||sqlerrm );
2166: END IF;
2167:
2168: IF l_check_version%ISOPEN THEN

Line 2295: FND_LOG.STRING(G_PROC_LEVEL,

2291: okc_debug.log('100: p_to_object_id : '||p_to_object_id, 2);
2292: END IF;*/
2293:
2294: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2295: FND_LOG.STRING(G_PROC_LEVEL,
2296: G_PKG_NAME, '100: Entered organize_layout' );
2297: FND_LOG.STRING(G_PROC_LEVEL,
2298: G_PKG_NAME, '100: Parameter List ' );
2299: FND_LOG.STRING(G_PROC_LEVEL,

Line 2297: FND_LOG.STRING(G_PROC_LEVEL,

2293:
2294: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2295: FND_LOG.STRING(G_PROC_LEVEL,
2296: G_PKG_NAME, '100: Entered organize_layout' );
2297: FND_LOG.STRING(G_PROC_LEVEL,
2298: G_PKG_NAME, '100: Parameter List ' );
2299: FND_LOG.STRING(G_PROC_LEVEL,
2300: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2301: FND_LOG.STRING(G_PROC_LEVEL,

Line 2299: FND_LOG.STRING(G_PROC_LEVEL,

2295: FND_LOG.STRING(G_PROC_LEVEL,
2296: G_PKG_NAME, '100: Entered organize_layout' );
2297: FND_LOG.STRING(G_PROC_LEVEL,
2298: G_PKG_NAME, '100: Parameter List ' );
2299: FND_LOG.STRING(G_PROC_LEVEL,
2300: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2301: FND_LOG.STRING(G_PROC_LEVEL,
2302: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2303: FND_LOG.STRING(G_PROC_LEVEL,

Line 2301: FND_LOG.STRING(G_PROC_LEVEL,

2297: FND_LOG.STRING(G_PROC_LEVEL,
2298: G_PKG_NAME, '100: Parameter List ' );
2299: FND_LOG.STRING(G_PROC_LEVEL,
2300: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2301: FND_LOG.STRING(G_PROC_LEVEL,
2302: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2303: FND_LOG.STRING(G_PROC_LEVEL,
2304: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2305: FND_LOG.STRING(G_PROC_LEVEL,

Line 2303: FND_LOG.STRING(G_PROC_LEVEL,

2299: FND_LOG.STRING(G_PROC_LEVEL,
2300: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2301: FND_LOG.STRING(G_PROC_LEVEL,
2302: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2303: FND_LOG.STRING(G_PROC_LEVEL,
2304: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2305: FND_LOG.STRING(G_PROC_LEVEL,
2306: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2307: FND_LOG.STRING(G_PROC_LEVEL,

Line 2305: FND_LOG.STRING(G_PROC_LEVEL,

2301: FND_LOG.STRING(G_PROC_LEVEL,
2302: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2303: FND_LOG.STRING(G_PROC_LEVEL,
2304: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2305: FND_LOG.STRING(G_PROC_LEVEL,
2306: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2307: FND_LOG.STRING(G_PROC_LEVEL,
2308: G_PKG_NAME, '100: p_commit : '||p_commit );
2309: FND_LOG.STRING(G_PROC_LEVEL,

Line 2307: FND_LOG.STRING(G_PROC_LEVEL,

2303: FND_LOG.STRING(G_PROC_LEVEL,
2304: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2305: FND_LOG.STRING(G_PROC_LEVEL,
2306: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2307: FND_LOG.STRING(G_PROC_LEVEL,
2308: G_PKG_NAME, '100: p_commit : '||p_commit );
2309: FND_LOG.STRING(G_PROC_LEVEL,
2310: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2311: FND_LOG.STRING(G_PROC_LEVEL,

Line 2309: FND_LOG.STRING(G_PROC_LEVEL,

2305: FND_LOG.STRING(G_PROC_LEVEL,
2306: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2307: FND_LOG.STRING(G_PROC_LEVEL,
2308: G_PKG_NAME, '100: p_commit : '||p_commit );
2309: FND_LOG.STRING(G_PROC_LEVEL,
2310: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2311: FND_LOG.STRING(G_PROC_LEVEL,
2312: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2313: FND_LOG.STRING(G_PROC_LEVEL,

Line 2311: FND_LOG.STRING(G_PROC_LEVEL,

2307: FND_LOG.STRING(G_PROC_LEVEL,
2308: G_PKG_NAME, '100: p_commit : '||p_commit );
2309: FND_LOG.STRING(G_PROC_LEVEL,
2310: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2311: FND_LOG.STRING(G_PROC_LEVEL,
2312: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2313: FND_LOG.STRING(G_PROC_LEVEL,
2314: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2315: FND_LOG.STRING(G_PROC_LEVEL,

Line 2313: FND_LOG.STRING(G_PROC_LEVEL,

2309: FND_LOG.STRING(G_PROC_LEVEL,
2310: G_PKG_NAME, '100: p_ref_point : '||p_ref_point );
2311: FND_LOG.STRING(G_PROC_LEVEL,
2312: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2313: FND_LOG.STRING(G_PROC_LEVEL,
2314: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2315: FND_LOG.STRING(G_PROC_LEVEL,
2316: G_PKG_NAME, '100: p_to_object_type : '||p_to_object_type );
2317: FND_LOG.STRING(G_PROC_LEVEL,

Line 2315: FND_LOG.STRING(G_PROC_LEVEL,

2311: FND_LOG.STRING(G_PROC_LEVEL,
2312: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2313: FND_LOG.STRING(G_PROC_LEVEL,
2314: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2315: FND_LOG.STRING(G_PROC_LEVEL,
2316: G_PKG_NAME, '100: p_to_object_type : '||p_to_object_type );
2317: FND_LOG.STRING(G_PROC_LEVEL,
2318: G_PKG_NAME, '100: p_to_object_id : '||p_to_object_id );
2319: END IF;

Line 2317: FND_LOG.STRING(G_PROC_LEVEL,

2313: FND_LOG.STRING(G_PROC_LEVEL,
2314: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2315: FND_LOG.STRING(G_PROC_LEVEL,
2316: G_PKG_NAME, '100: p_to_object_type : '||p_to_object_type );
2317: FND_LOG.STRING(G_PROC_LEVEL,
2318: G_PKG_NAME, '100: p_to_object_id : '||p_to_object_id );
2319: END IF;
2320:
2321: -- Standard Start of API savepoint

Line 2352: FND_LOG.STRING(G_PROC_LEVEL,

2348: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
2349: END IF;*/
2350:
2351: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2352: FND_LOG.STRING(G_PROC_LEVEL,
2353: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2354: END IF;
2355: RAISE FND_API.G_EXC_ERROR ;
2356: END IF;

Line 2364: FND_LOG.STRING(G_PROC_LEVEL,

2360: okc_debug.log('800: Error: Ref point should be either A,B or S', 2);
2361: END IF;*/
2362:
2363: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2364: FND_LOG.STRING(G_PROC_LEVEL,
2365: G_PKG_NAME, '800: Error: Ref point should be either A,B or S' );
2366: END IF;
2367:
2368: Okc_Api.Set_Message( G_FND_APP, 'OKC_WRONG_REF_POINT');

Line 2379: FND_LOG.STRING(G_PROC_LEVEL,

2375: okc_debug.log('300: Wrong Selection of Item Location', 2);
2376: END IF;*/
2377:
2378: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2379: FND_LOG.STRING(G_PROC_LEVEL,
2380: G_PKG_NAME, '300: Wrong Selection of Item Location' );
2381: END IF;
2382:
2383: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2396: FND_LOG.STRING(G_PROC_LEVEL,

2392: okc_debug.log('400: Wrong Selection of Item Location', 2);
2393: END IF;*/
2394:
2395: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2396: FND_LOG.STRING(G_PROC_LEVEL,
2397: G_PKG_NAME, '400: Wrong Selection of Item Location' );
2398: END IF;
2399:
2400: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2417: FND_LOG.STRING(G_PROC_LEVEL,

2413: okc_debug.log('500: Wrong Selection ', 2);
2414: END IF;*/
2415:
2416: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2417: FND_LOG.STRING(G_PROC_LEVEL,
2418: G_PKG_NAME, '500: Wrong Selection ' );
2419: END IF;
2420:
2421: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

Line 2564: FND_LOG.STRING(G_PROC_LEVEL,

2560: okc_debug.log('600: Updating Display Sequence of cat_id '||p_organize_tbl(i).id, 2);
2561: END IF;*/
2562:
2563: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2564: FND_LOG.STRING(G_PROC_LEVEL,
2565: G_PKG_NAME, '600: Updating Display Sequence of cat_id '||p_organize_tbl(i).id );
2566: END IF;
2567:
2568: IF l_parent_scn_id IS NULL THEN

Line 2601: FND_LOG.STRING(G_PROC_LEVEL,

2597: okc_debug.log('700: Updating Display Sequence of scn_id '||p_organize_tbl(i).id, 2);
2598: END IF;*/
2599:
2600: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2601: FND_LOG.STRING(G_PROC_LEVEL,
2602: G_PKG_NAME, '700: Updating Display Sequence of scn_id '||p_organize_tbl(i).id );
2603: END IF;
2604:
2605: l_ref_sequence := l_ref_sequence+10;

Line 2653: FND_LOG.STRING(G_PROC_LEVEL,

2649: okc_debug.log('800: Updating Display Sequence of cat_id '||scn_child_tbl(k).id, 2);
2650: END IF;*/
2651:
2652: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2653: FND_LOG.STRING(G_PROC_LEVEL,
2654: G_PKG_NAME, '800: Updating Display Sequence of cat_id '||scn_child_tbl(k).id );
2655: END IF;
2656:
2657: OKC_K_ARTICLES_GRP.update_article(

Line 2681: FND_LOG.STRING(G_PROC_LEVEL,

2677: okc_debug.log('900: Updating Display Sequence of scn_id '||scn_child_tbl(k).id, 2);
2678: END IF;*/
2679:
2680: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2681: FND_LOG.STRING(G_PROC_LEVEL,
2682: G_PKG_NAME, '900: Updating Display Sequence of scn_id '||scn_child_tbl(k).id );
2683: END IF;
2684:
2685: OKC_TERMS_SECTIONS_GRP.update_section(

Line 2721: FND_LOG.STRING(G_PROC_LEVEL,

2717: okc_debug.log('1000: Leaving organize_layout', 2);
2718: END IF;*/
2719:
2720: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2721: FND_LOG.STRING(G_PROC_LEVEL,
2722: G_PKG_NAME, '1000: Leaving organize_layout' );
2723: END IF;
2724:
2725: EXCEPTION

Line 2732: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 2766: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 2800: FND_LOG.STRING(G_EXCP_LEVEL,

2796: okc_debug.log('1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm, 2);
2797: END IF;*/
2798:
2799: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2800: FND_LOG.STRING(G_EXCP_LEVEL,
2801: G_PKG_NAME, '1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm );
2802: END IF;
2803:
2804: IF l_get_scn_child%ISOPEN THEN

Line 2912: FND_LOG.STRING(G_PROC_LEVEL,

2908:
2909: BEGIN
2910:
2911: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2912: FND_LOG.STRING(G_PROC_LEVEL,
2913: G_PKG_NAME, '100: Entered merge_review_clauses' );
2914: FND_LOG.STRING(G_PROC_LEVEL,
2915: G_PKG_NAME, '100: Parameter List ' );
2916: FND_LOG.STRING(G_PROC_LEVEL,

Line 2914: FND_LOG.STRING(G_PROC_LEVEL,

2910:
2911: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2912: FND_LOG.STRING(G_PROC_LEVEL,
2913: G_PKG_NAME, '100: Entered merge_review_clauses' );
2914: FND_LOG.STRING(G_PROC_LEVEL,
2915: G_PKG_NAME, '100: Parameter List ' );
2916: FND_LOG.STRING(G_PROC_LEVEL,
2917: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2918: FND_LOG.STRING(G_PROC_LEVEL,

Line 2916: FND_LOG.STRING(G_PROC_LEVEL,

2912: FND_LOG.STRING(G_PROC_LEVEL,
2913: G_PKG_NAME, '100: Entered merge_review_clauses' );
2914: FND_LOG.STRING(G_PROC_LEVEL,
2915: G_PKG_NAME, '100: Parameter List ' );
2916: FND_LOG.STRING(G_PROC_LEVEL,
2917: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2918: FND_LOG.STRING(G_PROC_LEVEL,
2919: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2920: FND_LOG.STRING(G_PROC_LEVEL,

Line 2918: FND_LOG.STRING(G_PROC_LEVEL,

2914: FND_LOG.STRING(G_PROC_LEVEL,
2915: G_PKG_NAME, '100: Parameter List ' );
2916: FND_LOG.STRING(G_PROC_LEVEL,
2917: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2918: FND_LOG.STRING(G_PROC_LEVEL,
2919: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2920: FND_LOG.STRING(G_PROC_LEVEL,
2921: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2922: FND_LOG.STRING(G_PROC_LEVEL,

Line 2920: FND_LOG.STRING(G_PROC_LEVEL,

2916: FND_LOG.STRING(G_PROC_LEVEL,
2917: G_PKG_NAME, '100: p_api_version : '||p_api_version );
2918: FND_LOG.STRING(G_PROC_LEVEL,
2919: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2920: FND_LOG.STRING(G_PROC_LEVEL,
2921: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2922: FND_LOG.STRING(G_PROC_LEVEL,
2923: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2924: FND_LOG.STRING(G_PROC_LEVEL,

Line 2922: FND_LOG.STRING(G_PROC_LEVEL,

2918: FND_LOG.STRING(G_PROC_LEVEL,
2919: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
2920: FND_LOG.STRING(G_PROC_LEVEL,
2921: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2922: FND_LOG.STRING(G_PROC_LEVEL,
2923: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2924: FND_LOG.STRING(G_PROC_LEVEL,
2925: G_PKG_NAME, '100: p_commit : '||p_commit );
2926: FND_LOG.STRING(G_PROC_LEVEL,

Line 2924: FND_LOG.STRING(G_PROC_LEVEL,

2920: FND_LOG.STRING(G_PROC_LEVEL,
2921: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
2922: FND_LOG.STRING(G_PROC_LEVEL,
2923: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2924: FND_LOG.STRING(G_PROC_LEVEL,
2925: G_PKG_NAME, '100: p_commit : '||p_commit );
2926: FND_LOG.STRING(G_PROC_LEVEL,
2927: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2928: FND_LOG.STRING(G_PROC_LEVEL,

Line 2926: FND_LOG.STRING(G_PROC_LEVEL,

2922: FND_LOG.STRING(G_PROC_LEVEL,
2923: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
2924: FND_LOG.STRING(G_PROC_LEVEL,
2925: G_PKG_NAME, '100: p_commit : '||p_commit );
2926: FND_LOG.STRING(G_PROC_LEVEL,
2927: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2928: FND_LOG.STRING(G_PROC_LEVEL,
2929: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2930: END IF;

Line 2928: FND_LOG.STRING(G_PROC_LEVEL,

2924: FND_LOG.STRING(G_PROC_LEVEL,
2925: G_PKG_NAME, '100: p_commit : '||p_commit );
2926: FND_LOG.STRING(G_PROC_LEVEL,
2927: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
2928: FND_LOG.STRING(G_PROC_LEVEL,
2929: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
2930: END IF;
2931:
2932: -- Standard Start of API savepoint

Line 2972: FND_LOG.STRING(G_PROC_LEVEL,

2968: x_msg_count => x_msg_count) ) THEN
2969:
2970:
2971: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
2972: FND_LOG.STRING(G_PROC_LEVEL,
2973: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
2974: END IF;
2975: RAISE FND_API.G_EXC_ERROR ;
2976: END IF;

Line 3000: FND_LOG.STRING(G_PROC_LEVEL,

2996: l_article_text_locked := 'N';
2997: IF p_merge_review_tbl(1).object_type <> 'ARTICLE' THEN
2998:
2999: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3000: FND_LOG.STRING(G_PROC_LEVEL,
3001: G_PKG_NAME, '500: Wrong Selection ' );
3002: END IF;
3003: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3004: p_msg_name => 'OKC_WRONG_SELECTION'

Line 3019: FND_LOG.STRING(G_PROC_LEVEL,

3015:
3016: IF l_article_ibr = 'Y' and (l_user_access <> 'SUPER_USER') THEN
3017:
3018: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3019: FND_LOG.STRING(G_PROC_LEVEL,
3020: G_PKG_NAME, '500: Article is IBR enabled ' );
3021: END IF;
3022: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3023: p_msg_name => 'OKC_ARTICLE_IS_IBR'

Line 3031: FND_LOG.STRING(G_PROC_LEVEL,

3027:
3028: IF l_article_text_locked = 'Y' AND (l_user_access <> 'SUPER_USER') THEN
3029:
3030: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3031: FND_LOG.STRING(G_PROC_LEVEL,
3032: G_PKG_NAME, '500: Article is Text Locked ' );
3033: END IF;
3034: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3035: p_msg_name => 'OKC_ARTICLE_IS_LOCK_TEXT');

Line 3046: FND_LOG.STRING(G_PROC_LEVEL,

3042: l_article_text_locked := 'N';
3043: IF p_merge_review_tbl(i).object_type <> 'ARTICLE' THEN
3044:
3045: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3046: FND_LOG.STRING(G_PROC_LEVEL,
3047: G_PKG_NAME, '500: Wrong Selection ' );
3048: END IF;
3049: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3050: p_msg_name => 'OKC_WRONG_SELECTION');

Line 3061: FND_LOG.STRING(G_PROC_LEVEL,

3057: -- Fix for bug# 4779506. Changed check to NOT and changed parameter for fnd_function.test
3058: IF l_article_mandatory = 'Y' AND (l_user_access <> 'SUPER_USER') THEN
3059:
3060: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3061: FND_LOG.STRING(G_PROC_LEVEL,
3062: G_PKG_NAME, '500: Article is Mandatory ' );
3063: END IF;
3064: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3065: p_msg_name => 'OKC_REVIEW_MERGE_MANDATORY'

Line 3079: FND_LOG.STRING(G_PROC_LEVEL,

3075: l_temp_err_msg_count,
3076: l_temp_wrn_msg_count;
3077: CLOSE l_get_article_text_csr;
3078: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3079: FND_LOG.STRING(G_PROC_LEVEL,
3080: G_PKG_NAME, '500: l_temp_action : '||l_temp_action );
3081: FND_LOG.STRING(G_PROC_LEVEL,
3082: G_PKG_NAME, '500: l_temp_err_msg_count : '||l_temp_err_msg_count);
3083: FND_LOG.STRING(G_PROC_LEVEL,

Line 3081: FND_LOG.STRING(G_PROC_LEVEL,

3077: CLOSE l_get_article_text_csr;
3078: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3079: FND_LOG.STRING(G_PROC_LEVEL,
3080: G_PKG_NAME, '500: l_temp_action : '||l_temp_action );
3081: FND_LOG.STRING(G_PROC_LEVEL,
3082: G_PKG_NAME, '500: l_temp_err_msg_count : '||l_temp_err_msg_count);
3083: FND_LOG.STRING(G_PROC_LEVEL,
3084: G_PKG_NAME, '500: l_temp_wrn_msg_count : '||l_temp_wrn_msg_count);
3085: END IF;

Line 3083: FND_LOG.STRING(G_PROC_LEVEL,

3079: FND_LOG.STRING(G_PROC_LEVEL,
3080: G_PKG_NAME, '500: l_temp_action : '||l_temp_action );
3081: FND_LOG.STRING(G_PROC_LEVEL,
3082: G_PKG_NAME, '500: l_temp_err_msg_count : '||l_temp_err_msg_count);
3083: FND_LOG.STRING(G_PROC_LEVEL,
3084: G_PKG_NAME, '500: l_temp_wrn_msg_count : '||l_temp_wrn_msg_count);
3085: END IF;
3086: l_final_article_text := l_final_article_text || l_temp_article_text;
3087: l_final_err_msg_count := l_final_err_msg_count + l_temp_err_msg_count;

Line 3144: FND_LOG.STRING(G_PROC_LEVEL,

3140: l_final_wrn_msg_count := G_MISS_NUM;
3141: END IF;
3142:
3143: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3144: FND_LOG.STRING(G_PROC_LEVEL,
3145: G_PKG_NAME, '500: l_new_action : '||l_new_action );
3146: FND_LOG.STRING(G_PROC_LEVEL,
3147: G_PKG_NAME, '500: l_final_err_msg_count : '||l_final_err_msg_count);
3148: FND_LOG.STRING(G_PROC_LEVEL,

Line 3146: FND_LOG.STRING(G_PROC_LEVEL,

3142:
3143: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3144: FND_LOG.STRING(G_PROC_LEVEL,
3145: G_PKG_NAME, '500: l_new_action : '||l_new_action );
3146: FND_LOG.STRING(G_PROC_LEVEL,
3147: G_PKG_NAME, '500: l_final_err_msg_count : '||l_final_err_msg_count);
3148: FND_LOG.STRING(G_PROC_LEVEL,
3149: G_PKG_NAME, '500: l_final_wrn_msg_count : '||l_final_wrn_msg_count);
3150: END IF;

Line 3148: FND_LOG.STRING(G_PROC_LEVEL,

3144: FND_LOG.STRING(G_PROC_LEVEL,
3145: G_PKG_NAME, '500: l_new_action : '||l_new_action );
3146: FND_LOG.STRING(G_PROC_LEVEL,
3147: G_PKG_NAME, '500: l_final_err_msg_count : '||l_final_err_msg_count);
3148: FND_LOG.STRING(G_PROC_LEVEL,
3149: G_PKG_NAME, '500: l_final_wrn_msg_count : '||l_final_wrn_msg_count);
3150: END IF;
3151:
3152: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

Line 3199: FND_LOG.STRING(G_PROC_LEVEL,

3195: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3196:
3197:
3198: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3199: FND_LOG.STRING(G_PROC_LEVEL,
3200: G_PKG_NAME, '1000: Leaving merge_review_clauses' );
3201: END IF;
3202:
3203: EXCEPTION

Line 3207: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 3224: FND_LOG.STRING(G_EXCP_LEVEL,

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

Line 3240: FND_LOG.STRING(G_EXCP_LEVEL,

3236: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3237:
3238: WHEN OTHERS THEN
3239: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3240: FND_LOG.STRING(G_EXCP_LEVEL,
3241: G_PKG_NAME, '1300: Leaving organize_layout because of EXCEPTION: '||sqlerrm );
3242: END IF;
3243:
3244: IF article_properties%ISOPEN THEN

Line 3301: FND_LOG.STRING(G_PROC_LEVEL,

3297:
3298: BEGIN
3299:
3300: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3301: FND_LOG.STRING(G_PROC_LEVEL,
3302: G_PKG_NAME, '100: Entered sort_clauses' );
3303: FND_LOG.STRING(G_PROC_LEVEL,
3304: G_PKG_NAME, '100: Parameter List ' );
3305: FND_LOG.STRING(G_PROC_LEVEL,

Line 3303: FND_LOG.STRING(G_PROC_LEVEL,

3299:
3300: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3301: FND_LOG.STRING(G_PROC_LEVEL,
3302: G_PKG_NAME, '100: Entered sort_clauses' );
3303: FND_LOG.STRING(G_PROC_LEVEL,
3304: G_PKG_NAME, '100: Parameter List ' );
3305: FND_LOG.STRING(G_PROC_LEVEL,
3306: G_PKG_NAME, '100: p_api_version : '||p_api_version );
3307: FND_LOG.STRING(G_PROC_LEVEL,

Line 3305: FND_LOG.STRING(G_PROC_LEVEL,

3301: FND_LOG.STRING(G_PROC_LEVEL,
3302: G_PKG_NAME, '100: Entered sort_clauses' );
3303: FND_LOG.STRING(G_PROC_LEVEL,
3304: G_PKG_NAME, '100: Parameter List ' );
3305: FND_LOG.STRING(G_PROC_LEVEL,
3306: G_PKG_NAME, '100: p_api_version : '||p_api_version );
3307: FND_LOG.STRING(G_PROC_LEVEL,
3308: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
3309: FND_LOG.STRING(G_PROC_LEVEL,

Line 3307: FND_LOG.STRING(G_PROC_LEVEL,

3303: FND_LOG.STRING(G_PROC_LEVEL,
3304: G_PKG_NAME, '100: Parameter List ' );
3305: FND_LOG.STRING(G_PROC_LEVEL,
3306: G_PKG_NAME, '100: p_api_version : '||p_api_version );
3307: FND_LOG.STRING(G_PROC_LEVEL,
3308: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
3309: FND_LOG.STRING(G_PROC_LEVEL,
3310: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
3311: FND_LOG.STRING(G_PROC_LEVEL,

Line 3309: FND_LOG.STRING(G_PROC_LEVEL,

3305: FND_LOG.STRING(G_PROC_LEVEL,
3306: G_PKG_NAME, '100: p_api_version : '||p_api_version );
3307: FND_LOG.STRING(G_PROC_LEVEL,
3308: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
3309: FND_LOG.STRING(G_PROC_LEVEL,
3310: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
3311: FND_LOG.STRING(G_PROC_LEVEL,
3312: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
3313: FND_LOG.STRING(G_PROC_LEVEL,

Line 3311: FND_LOG.STRING(G_PROC_LEVEL,

3307: FND_LOG.STRING(G_PROC_LEVEL,
3308: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
3309: FND_LOG.STRING(G_PROC_LEVEL,
3310: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
3311: FND_LOG.STRING(G_PROC_LEVEL,
3312: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
3313: FND_LOG.STRING(G_PROC_LEVEL,
3314: G_PKG_NAME, '100: p_commit : '||p_commit );
3315: FND_LOG.STRING(G_PROC_LEVEL,

Line 3313: FND_LOG.STRING(G_PROC_LEVEL,

3309: FND_LOG.STRING(G_PROC_LEVEL,
3310: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
3311: FND_LOG.STRING(G_PROC_LEVEL,
3312: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
3313: FND_LOG.STRING(G_PROC_LEVEL,
3314: G_PKG_NAME, '100: p_commit : '||p_commit );
3315: FND_LOG.STRING(G_PROC_LEVEL,
3316: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
3317: FND_LOG.STRING(G_PROC_LEVEL,

Line 3315: FND_LOG.STRING(G_PROC_LEVEL,

3311: FND_LOG.STRING(G_PROC_LEVEL,
3312: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
3313: FND_LOG.STRING(G_PROC_LEVEL,
3314: G_PKG_NAME, '100: p_commit : '||p_commit );
3315: FND_LOG.STRING(G_PROC_LEVEL,
3316: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
3317: FND_LOG.STRING(G_PROC_LEVEL,
3318: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
3319: END IF;

Line 3317: FND_LOG.STRING(G_PROC_LEVEL,

3313: FND_LOG.STRING(G_PROC_LEVEL,
3314: G_PKG_NAME, '100: p_commit : '||p_commit );
3315: FND_LOG.STRING(G_PROC_LEVEL,
3316: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
3317: FND_LOG.STRING(G_PROC_LEVEL,
3318: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
3319: END IF;
3320:
3321: -- Standard Start of API savepoint

Line 3352: FND_LOG.STRING(G_PROC_LEVEL,

3348: okc_debug.log('200: Issue with document header Record.Cannot commit', 2);
3349: END IF;*/
3350:
3351: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3352: FND_LOG.STRING(G_PROC_LEVEL,
3353: G_PKG_NAME, '200: Issue with document header Record.Cannot commit' );
3354: END IF;
3355: RAISE FND_API.G_EXC_ERROR ;
3356: END IF;

Line 3402: FND_LOG.STRING(G_PROC_LEVEL,

3398: FETCH l_get_num_scheme_id INTO l_num_scheme_id;
3399: CLOSE l_get_num_scheme_id;
3400:
3401: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3402: FND_LOG.STRING(G_PROC_LEVEL,
3403: G_PKG_NAME, '150: l_num_scheme_id : '||l_num_scheme_id );
3404: END IF;
3405:
3406: IF NVL(l_num_scheme_id,0) <> 0 THEN

Line 3410: FND_LOG.STRING(G_PROC_LEVEL,

3406: IF NVL(l_num_scheme_id,0) <> 0 THEN
3407:
3408:
3409: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3410: FND_LOG.STRING(G_PROC_LEVEL,
3411: G_PKG_NAME, '150: Calling apply_numbering_scheme for num_scheme_id : '||l_num_scheme_id );
3412: END IF;
3413:
3414: OKC_NUMBER_SCHEME_GRP.apply_numbering_scheme(

Line 3430: FND_LOG.STRING(G_PROC_LEVEL,

3426: );
3427:
3428:
3429: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3430: FND_LOG.STRING(G_PROC_LEVEL,
3431: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
3432: FND_LOG.STRING(G_PROC_LEVEL,
3433: G_PKG_NAME, '150: x_return_status : '||x_return_status );
3434: FND_LOG.STRING(G_PROC_LEVEL,

Line 3432: FND_LOG.STRING(G_PROC_LEVEL,

3428:
3429: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3430: FND_LOG.STRING(G_PROC_LEVEL,
3431: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
3432: FND_LOG.STRING(G_PROC_LEVEL,
3433: G_PKG_NAME, '150: x_return_status : '||x_return_status );
3434: FND_LOG.STRING(G_PROC_LEVEL,
3435: G_PKG_NAME, '150: x_msg_count : '||x_msg_count );
3436: FND_LOG.STRING(G_PROC_LEVEL,

Line 3434: FND_LOG.STRING(G_PROC_LEVEL,

3430: FND_LOG.STRING(G_PROC_LEVEL,
3431: G_PKG_NAME, '150: After Calling apply_numbering_scheme' );
3432: FND_LOG.STRING(G_PROC_LEVEL,
3433: G_PKG_NAME, '150: x_return_status : '||x_return_status );
3434: FND_LOG.STRING(G_PROC_LEVEL,
3435: G_PKG_NAME, '150: x_msg_count : '||x_msg_count );
3436: FND_LOG.STRING(G_PROC_LEVEL,
3437: G_PKG_NAME, '150: x_msg_data : '||x_msg_data );
3438: END IF;

Line 3436: FND_LOG.STRING(G_PROC_LEVEL,

3432: FND_LOG.STRING(G_PROC_LEVEL,
3433: G_PKG_NAME, '150: x_return_status : '||x_return_status );
3434: FND_LOG.STRING(G_PROC_LEVEL,
3435: G_PKG_NAME, '150: x_msg_count : '||x_msg_count );
3436: FND_LOG.STRING(G_PROC_LEVEL,
3437: G_PKG_NAME, '150: x_msg_data : '||x_msg_data );
3438: END IF;
3439:
3440: END IF; --l_num_scheme_id is not 0

Line 3449: FND_LOG.STRING(G_PROC_LEVEL,

3445: COMMIT WORK;
3446: END IF;
3447:
3448: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
3449: FND_LOG.STRING(G_PROC_LEVEL,
3450: G_PKG_NAME, '1000: Leaving sort_clauses' );
3451: END IF;
3452:
3453: EXCEPTION

Line 3457: FND_LOG.STRING(G_EXCP_LEVEL,

3453: EXCEPTION
3454: WHEN OTHERS THEN
3455:
3456: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
3457: FND_LOG.STRING(G_EXCP_LEVEL,
3458: G_PKG_NAME, '1300: Leaving sort_clauses because of EXCEPTION: '||sqlerrm );
3459: END IF;
3460: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3461: p_msg_name => G_UNEXPECTED_ERROR,