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_NUMBER_SCHEME_GRP dependencies on OKC_DEBUG

Line 129: okc_debug.log('100: Inside convert_to_roman', 2);

125: fifth number;
126:
127: begin
128: /*IF (l_debug = 'Y') THEN
129: okc_debug.log('100: Inside convert_to_roman', 2);
130: okc_debug.log('100: p_number : '||p_number, 2);
131: END IF;*/
132:
133: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 130: okc_debug.log('100: p_number : '||p_number, 2);

126:
127: begin
128: /*IF (l_debug = 'Y') THEN
129: okc_debug.log('100: Inside convert_to_roman', 2);
130: okc_debug.log('100: p_number : '||p_number, 2);
131: END IF;*/
132:
133: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
134: FND_LOG.STRING(G_PROC_LEVEL,

Line 222: okc_debug.log('1000: Leaving convert_to_roman', 2);

218: end if;
219: end if;
220:
221: /*IF (l_debug = 'Y') THEN
222: okc_debug.log('1000: Leaving convert_to_roman', 2);
223: okc_debug.log('1000: out_roman : '||out_roman, 2);
224: END IF;*/
225:
226: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 223: okc_debug.log('1000: out_roman : '||out_roman, 2);

219: end if;
220:
221: /*IF (l_debug = 'Y') THEN
222: okc_debug.log('1000: Leaving convert_to_roman', 2);
223: okc_debug.log('1000: out_roman : '||out_roman, 2);
224: END IF;*/
225:
226: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
227: FND_LOG.STRING(G_PROC_LEVEL,

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

234:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR THEN
237: /*IF (l_debug = 'Y') THEN
238: okc_debug.log('300: Leaving convert_to_roman: OKC_API.G_EXCEPTION_ERROR Exception', 2);
239: END IF;*/
240:
241: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
242: FND_LOG.STRING(G_EXCP_LEVEL,

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

247:
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: /*IF (l_debug = 'Y') THEN
251: okc_debug.log('400: Leaving convert_to_roman: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
252: END IF;*/
253:
254: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
255: FND_LOG.STRING(G_EXCP_LEVEL,

Line 264: okc_debug.log('500: Leaving convert_to_roman because of EXCEPTION: '||sqlerrm, 2);

260:
261:
262: WHEN OTHERS THEN
263: /*IF (l_debug = 'Y') THEN
264: okc_debug.log('500: Leaving convert_to_roman because of EXCEPTION: '||sqlerrm, 2);
265: END IF;*/
266:
267: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
268: FND_LOG.STRING(G_EXCP_LEVEL,

Line 283: okc_debug.log('100: Entering get_numbering_seq', 2);

279: l_lvl_sequence NUMBER;
280: l_vl_seq_code VARCHAR2(30);
281: BEGIN
282: /*IF (l_debug = 'Y') THEN
283: okc_debug.log('100: Entering get_numbering_seq', 2);
284: okc_debug.log('100: p_level : '||p_level, 2);
285: END IF;*/
286:
287: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 284: okc_debug.log('100: p_level : '||p_level, 2);

280: l_vl_seq_code VARCHAR2(30);
281: BEGIN
282: /*IF (l_debug = 'Y') THEN
283: okc_debug.log('100: Entering get_numbering_seq', 2);
284: okc_debug.log('100: p_level : '||p_level, 2);
285: END IF;*/
286:
287: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
288: FND_LOG.STRING(G_PROC_LEVEL,

Line 298: okc_debug.log('150: l_vl_seq_code : '||l_vl_seq_code, 2);

294: Select decode(p_level,1,l_lvl1_seq_code,2,l_lvl2_seq_code,3,l_lvl3_seq_code,4,l_lvl4_seq_code,5,l_lvl5_seq_code,NULL)
295: INTO l_vl_seq_code from dual;
296:
297: /*IF (l_debug = 'Y') THEN
298: okc_debug.log('150: l_vl_seq_code : '||l_vl_seq_code, 2);
299: END IF;*/
300:
301: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
302: FND_LOG.STRING(G_PROC_LEVEL,

Line 328: okc_debug.log('180: l_lvl_sequence : '||l_lvl_sequence, 2);

324: l_lvl_sequence := NULL;
325: END IF;
326:
327: /*IF (l_debug = 'Y') THEN
328: okc_debug.log('180: l_lvl_sequence : '||l_lvl_sequence, 2);
329: END IF;*/
330:
331: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
332: FND_LOG.STRING(G_PROC_LEVEL,

Line 352: okc_debug.log('300: Leaving get_numbering_seq ', 2);

348: END IF;
349:
350:
351: /*IF (l_debug = 'Y') THEN
352: okc_debug.log('300: Leaving get_numbering_seq ', 2);
353: okc_debug.log('300: l_number : '||l_number, 2);
354: END IF;*/
355:
356: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 353: okc_debug.log('300: l_number : '||l_number, 2);

349:
350:
351: /*IF (l_debug = 'Y') THEN
352: okc_debug.log('300: Leaving get_numbering_seq ', 2);
353: okc_debug.log('300: l_number : '||l_number, 2);
354: END IF;*/
355:
356: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
357: FND_LOG.STRING(G_PROC_LEVEL,

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

365: EXCEPTION
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: /*IF (l_debug = 'Y') THEN
369: okc_debug.log('400: Leaving get_numbering_seq: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
370: END IF;*/
371:
372: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
373: FND_LOG.STRING(G_EXCP_LEVEL,

Line 381: okc_debug.log('500: Leaving get_numbering_seq because of EXCEPTION: '||sqlerrm, 2);

377: raise;
378:
379: WHEN OTHERS THEN
380: /*IF (l_debug = 'Y') THEN
381: okc_debug.log('500: Leaving get_numbering_seq because of EXCEPTION: '||sqlerrm, 2);
382: END IF;*/
383:
384: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
385: FND_LOG.STRING(G_EXCP_LEVEL,

Line 421: okc_debug.log('100: Entering section_numbering ', 2);

417: i NUMBER;
418: BEGIN
419:
420: /*IF (l_debug = 'Y') THEN
421: okc_debug.log('100: Entering section_numbering ', 2);
422: okc_debug.log('100: Parameters ', 2);
423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);

Line 422: okc_debug.log('100: Parameters ', 2);

418: BEGIN
419:
420: /*IF (l_debug = 'Y') THEN
421: okc_debug.log('100: Entering section_numbering ', 2);
422: okc_debug.log('100: Parameters ', 2);
423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);
426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);

Line 423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);

419:
420: /*IF (l_debug = 'Y') THEN
421: okc_debug.log('100: Entering section_numbering ', 2);
422: okc_debug.log('100: Parameters ', 2);
423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);
426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);
427: okc_debug.log('100: p_scn_id : '||p_scn_id, 2);

Line 424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);

420: /*IF (l_debug = 'Y') THEN
421: okc_debug.log('100: Entering section_numbering ', 2);
422: okc_debug.log('100: Parameters ', 2);
423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);
426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);
427: okc_debug.log('100: p_scn_id : '||p_scn_id, 2);
428: END IF;*/

Line 425: okc_debug.log('100: p_level : '||p_level, 2);

421: okc_debug.log('100: Entering section_numbering ', 2);
422: okc_debug.log('100: Parameters ', 2);
423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);
426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);
427: okc_debug.log('100: p_scn_id : '||p_scn_id, 2);
428: END IF;*/
429:

Line 426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);

422: okc_debug.log('100: Parameters ', 2);
423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);
426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);
427: okc_debug.log('100: p_scn_id : '||p_scn_id, 2);
428: END IF;*/
429:
430: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 427: okc_debug.log('100: p_scn_id : '||p_scn_id, 2);

423: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
424: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
425: okc_debug.log('100: p_level : '||p_level, 2);
426: okc_debug.log('100: p_parent_label : '||p_parent_label, 2);
427: okc_debug.log('100: p_scn_id : '||p_scn_id, 2);
428: END IF;*/
429:
430: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
431: FND_LOG.STRING(G_PROC_LEVEL,

Line 452: okc_debug.log('110: l_concat_yn : '||l_concat_yn, 2);

448: decode(p_level,1,l_lvl1_end_char ,2,l_lvl2_end_char ,3,l_lvl3_end_char ,4,l_lvl4_end_char ,5,l_lvl5_end_char ,NULL)
449: into l_concat_yn ,l_end_char from dual;
450:
451: /*IF (l_debug = 'Y') THEN
452: okc_debug.log('110: l_concat_yn : '||l_concat_yn, 2);
453: okc_debug.log('110: l_end_char : '||l_end_char, 2);
454: END IF;*/
455:
456: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 453: okc_debug.log('110: l_end_char : '||l_end_char, 2);

449: into l_concat_yn ,l_end_char from dual;
450:
451: /*IF (l_debug = 'Y') THEN
452: okc_debug.log('110: l_concat_yn : '||l_concat_yn, 2);
453: okc_debug.log('110: l_end_char : '||l_end_char, 2);
454: END IF;*/
455:
456: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
457: FND_LOG.STRING(G_PROC_LEVEL,

Line 479: okc_debug.log('120: i : '||i, 2);

475: l_structure_tbl(i).type := cr.type;
476: l_structure_tbl(i).label := l_label;
477:
478: /*IF (l_debug = 'Y') THEN
479: okc_debug.log('120: i : '||i, 2);
480: okc_debug.log('120: l_structure_tbl(i).id : '||l_structure_tbl(i).id, 2);
481: okc_debug.log('120: l_structure_tbl(i).type : '||l_structure_tbl(i).type, 2);
482: okc_debug.log('120: l_structure_tbl(i).label : '||l_structure_tbl(i).label, 2);
483: END IF;*/

Line 480: okc_debug.log('120: l_structure_tbl(i).id : '||l_structure_tbl(i).id, 2);

476: l_structure_tbl(i).label := l_label;
477:
478: /*IF (l_debug = 'Y') THEN
479: okc_debug.log('120: i : '||i, 2);
480: okc_debug.log('120: l_structure_tbl(i).id : '||l_structure_tbl(i).id, 2);
481: okc_debug.log('120: l_structure_tbl(i).type : '||l_structure_tbl(i).type, 2);
482: okc_debug.log('120: l_structure_tbl(i).label : '||l_structure_tbl(i).label, 2);
483: END IF;*/
484:

Line 481: okc_debug.log('120: l_structure_tbl(i).type : '||l_structure_tbl(i).type, 2);

477:
478: /*IF (l_debug = 'Y') THEN
479: okc_debug.log('120: i : '||i, 2);
480: okc_debug.log('120: l_structure_tbl(i).id : '||l_structure_tbl(i).id, 2);
481: okc_debug.log('120: l_structure_tbl(i).type : '||l_structure_tbl(i).type, 2);
482: okc_debug.log('120: l_structure_tbl(i).label : '||l_structure_tbl(i).label, 2);
483: END IF;*/
484:
485: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 482: okc_debug.log('120: l_structure_tbl(i).label : '||l_structure_tbl(i).label, 2);

478: /*IF (l_debug = 'Y') THEN
479: okc_debug.log('120: i : '||i, 2);
480: okc_debug.log('120: l_structure_tbl(i).id : '||l_structure_tbl(i).id, 2);
481: okc_debug.log('120: l_structure_tbl(i).type : '||l_structure_tbl(i).type, 2);
482: okc_debug.log('120: l_structure_tbl(i).label : '||l_structure_tbl(i).label, 2);
483: END IF;*/
484:
485: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
486: FND_LOG.STRING(G_PROC_LEVEL,

Line 517: okc_debug.log('300: Leaving section_numbering ', 2);

513: END LOOP;
514:
515:
516: /*IF (l_debug = 'Y') THEN
517: okc_debug.log('300: Leaving section_numbering ', 2);
518: END IF;*/
519:
520: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
521: FND_LOG.STRING(G_PROC_LEVEL,

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

525: EXCEPTION
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: /*IF (l_debug = 'Y') THEN
529: okc_debug.log('400: Leaving section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
530: END IF;*/
531:
532: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
533: FND_LOG.STRING(G_EXCP_LEVEL,

Line 541: okc_debug.log('500: Leaving section_numbering because of EXCEPTION: '||sqlerrm, 2);

537: raise;
538:
539: WHEN OTHERS THEN
540: /*IF (l_debug = 'Y') THEN
541: okc_debug.log('500: Leaving section_numbering because of EXCEPTION: '||sqlerrm, 2);
542: END IF;*/
543:
544: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
545: FND_LOG.STRING(G_EXCP_LEVEL,

Line 583: okc_debug.log('100: Entered generate_preview', 2);

579: l_api_version NUMBER :=1;
580: k NUMBER :=0;
581: BEGIN
582: /*IF (l_debug = 'Y') THEN
583: okc_debug.log('100: Entered generate_preview', 2);
584: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);
585: END IF;*/
586:
587: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 584: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);

580: k NUMBER :=0;
581: BEGIN
582: /*IF (l_debug = 'Y') THEN
583: okc_debug.log('100: Entered generate_preview', 2);
584: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);
585: END IF;*/
586:
587: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
588: FND_LOG.STRING(G_PROC_LEVEL,

Line 649: okc_debug.log('300: Leaving generate_preview ', 2);

645:
646: END IF;
647:
648: /*IF (l_debug = 'Y') THEN
649: okc_debug.log('300: Leaving generate_preview ', 2);
650: END IF;*/
651:
652: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
653: FND_LOG.STRING(G_PROC_LEVEL,

Line 660: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);

656:
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: /*IF (l_debug = 'Y') THEN
660: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
661: END IF;*/
662:
663: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
664: FND_LOG.STRING(G_EXCP_LEVEL,

Line 674: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);

670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: /*IF (l_debug = 'Y') THEN
674: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
675: END IF;*/
676:
677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
678: FND_LOG.STRING(G_EXCP_LEVEL,

Line 688: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);

684: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
685:
686: WHEN OTHERS THEN
687: /*IF (l_debug = 'Y') THEN
688: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
689: END IF;*/
690:
691: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
692: FND_LOG.STRING(G_EXCP_LEVEL,

Line 769: okc_debug.log('100: Entered apply_numbering_scheme', 2);

765:
766: BEGIN
767:
768: /*IF (l_debug = 'Y') THEN
769: okc_debug.log('100: Entered apply_numbering_scheme', 2);
770: okc_debug.log('100: Parameter List ', 2);
771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);

Line 770: okc_debug.log('100: Parameter List ', 2);

766: BEGIN
767:
768: /*IF (l_debug = 'Y') THEN
769: okc_debug.log('100: Entered apply_numbering_scheme', 2);
770: okc_debug.log('100: Parameter List ', 2);
771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);

Line 771: okc_debug.log('100: p_api_version : '||p_api_version, 2);

767:
768: /*IF (l_debug = 'Y') THEN
769: okc_debug.log('100: Entered apply_numbering_scheme', 2);
770: okc_debug.log('100: Parameter List ', 2);
771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);

Line 772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);

768: /*IF (l_debug = 'Y') THEN
769: okc_debug.log('100: Entered apply_numbering_scheme', 2);
770: okc_debug.log('100: Parameter List ', 2);
771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);

Line 773: okc_debug.log('100: p_commit : '||p_commit, 2);

769: okc_debug.log('100: Entered apply_numbering_scheme', 2);
770: okc_debug.log('100: Parameter List ', 2);
771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);

Line 774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);

770: okc_debug.log('100: Parameter List ', 2);
771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
778: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);

Line 775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);

771: okc_debug.log('100: p_api_version : '||p_api_version, 2);
772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
778: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);
779: END IF;*/

Line 776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);

772: okc_debug.log('100: p_init_msg_list : '||p_init_msg_list, 2);
773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
778: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);
779: END IF;*/
780:

Line 777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);

773: okc_debug.log('100: p_commit : '||p_commit, 2);
774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
778: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);
779: END IF;*/
780:
781: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 778: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);

774: okc_debug.log('100: p_validate_commit : '||p_validate_commit, 2);
775: okc_debug.log('100: p_validation_string : '||p_validation_string , 2);
776: okc_debug.log('100: p_doc_type : '||p_doc_type, 2);
777: okc_debug.log('100: p_doc_id : '||p_doc_id, 2);
778: okc_debug.log('100: p_num_scheme_id : '||p_num_scheme_id, 2);
779: END IF;*/
780:
781: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
782: FND_LOG.STRING(G_PROC_LEVEL,

Line 831: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);

827: x_msg_data => x_msg_data,
828: x_msg_count => x_msg_count) ) THEN
829:
830: /*IF (l_debug = 'Y') THEN
831: okc_debug.log('110: Issue with document header Record.Cannot commit', 2);
832: END IF;*/
833:
834: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
835: FND_LOG.STRING(G_PROC_LEVEL,

Line 854: okc_debug.log('110: Numbering Scheme Detail Count : '||l_dtl_count,2);

850:
851: l_no_of_levels := l_dtl_count;
852:
853: /*IF (l_debug = 'Y') THEN
854: okc_debug.log('110: Numbering Scheme Detail Count : '||l_dtl_count,2);
855: END IF;*/
856:
857: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
858: FND_LOG.STRING(G_PROC_LEVEL,

Line 888: okc_debug.log('120: l_number_article_yn : '||l_number_article_yn, 2);

884: END IF;
885: CLOSE l_get_num_scheme ;
886:
887: /*IF (l_debug = 'Y') THEN
888: okc_debug.log('120: l_number_article_yn : '||l_number_article_yn, 2);
889: END IF;*/
890:
891: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
892: FND_LOG.STRING(G_PROC_LEVEL,

Line 922: okc_debug.log('130: Sequence Level 1 ', 2);

918:
919: END LOOP;
920:
921: /*IF (l_debug = 'Y') THEN
922: okc_debug.log('130: Sequence Level 1 ', 2);
923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);
924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);

Line 923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);

919: END LOOP;
920:
921: /*IF (l_debug = 'Y') THEN
922: okc_debug.log('130: Sequence Level 1 ', 2);
923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);
924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);

Line 924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);

920:
921: /*IF (l_debug = 'Y') THEN
922: okc_debug.log('130: Sequence Level 1 ', 2);
923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);
924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);

Line 925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);

921: /*IF (l_debug = 'Y') THEN
922: okc_debug.log('130: Sequence Level 1 ', 2);
923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);
924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);

Line 926: okc_debug.log('130: Sequence Level 2 ', 2);

922: okc_debug.log('130: Sequence Level 1 ', 2);
923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);
924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);

Line 927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);

923: okc_debug.log('130: l_lvl1_seq_code : '||l_lvl1_seq_code, 2);
924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);

Line 928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);

924: okc_debug.log('130: l_lvl1_concat_yn : '||l_lvl1_concat_yn, 2);
925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);

Line 929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);

925: okc_debug.log('130: l_lvl1_end_char : '||l_lvl1_end_char, 2);
926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);

Line 930: okc_debug.log('130: Sequence Level 3 ', 2);

926: okc_debug.log('130: Sequence Level 2 ', 2);
927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);

Line 931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);

927: okc_debug.log('130: l_lvl2_seq_code : '||l_lvl2_seq_code, 2);
928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);

Line 932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);

928: okc_debug.log('130: l_lvl2_concat_yn : '||l_lvl2_concat_yn, 2);
929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);

Line 933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);

929: okc_debug.log('130: l_lvl2_end_char : '||l_lvl2_end_char, 2);
930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);

Line 934: okc_debug.log('130: Sequence Level 4 ', 2);

930: okc_debug.log('130: Sequence Level 3 ', 2);
931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);

Line 935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);

931: okc_debug.log('130: l_lvl3_seq_code : '||l_lvl3_seq_code, 2);
932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);

Line 936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);

932: okc_debug.log('130: l_lvl3_concat_yn : '||l_lvl3_concat_yn, 2);
933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);
940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);

Line 937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);

933: okc_debug.log('130: l_lvl3_end_char : '||l_lvl3_end_char, 2);
934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);
940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);
941: okc_debug.log('130: l_lvl5_end_char : '||l_lvl5_end_char, 2);

Line 938: okc_debug.log('130: Sequence Level 5 ', 2);

934: okc_debug.log('130: Sequence Level 4 ', 2);
935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);
940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);
941: okc_debug.log('130: l_lvl5_end_char : '||l_lvl5_end_char, 2);
942: END IF;*/

Line 939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);

935: okc_debug.log('130: l_lvl4_seq_code : '||l_lvl4_seq_code, 2);
936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);
940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);
941: okc_debug.log('130: l_lvl5_end_char : '||l_lvl5_end_char, 2);
942: END IF;*/
943:

Line 940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);

936: okc_debug.log('130: l_lvl4_concat_yn : '||l_lvl4_concat_yn, 2);
937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);
940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);
941: okc_debug.log('130: l_lvl5_end_char : '||l_lvl5_end_char, 2);
942: END IF;*/
943:
944:

Line 941: okc_debug.log('130: l_lvl5_end_char : '||l_lvl5_end_char, 2);

937: okc_debug.log('130: l_lvl4_end_char : '||l_lvl4_end_char, 2);
938: okc_debug.log('130: Sequence Level 5 ', 2);
939: okc_debug.log('130: l_lvl5_seq_code : '||l_lvl5_seq_code, 2);
940: okc_debug.log('130: l_lvl5_concat_yn : '||l_lvl5_concat_yn, 2);
941: okc_debug.log('130: l_lvl5_end_char : '||l_lvl5_end_char, 2);
942: END IF;*/
943:
944:
945: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 999: okc_debug.log('140: l_number : '||l_number, 2);

995:
996: l_number := get_numbering_seq(p_level => 1);
997:
998: /*IF (l_debug = 'Y') THEN
999: okc_debug.log('140: l_number : '||l_number, 2);
1000: END IF;*/
1001:
1002: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1003: FND_LOG.STRING(G_PROC_LEVEL,

Line 1010: okc_debug.log('150: l_label : '||l_label, 2);

1006:
1007: l_label := l_number||l_lvl1_end_char;
1008:
1009: /*IF (l_debug = 'Y') THEN
1010: okc_debug.log('150: l_label : '||l_label, 2);
1011: END IF;*/
1012:
1013: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1014: FND_LOG.STRING(G_PROC_LEVEL,

Line 1032: okc_debug.log('160: Count of l_structure_tbl : '||l_structure_tbl.count, 2);

1028:
1029: END LOOP;
1030:
1031: /*IF (l_debug = 'Y') THEN
1032: okc_debug.log('160: Count of l_structure_tbl : '||l_structure_tbl.count, 2);
1033: END IF;*/
1034:
1035: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1036: FND_LOG.STRING(G_PROC_LEVEL,

Line 1045: okc_debug.log('170: Calling OKC_TERMS_SECTIONS_GRP.update_section', 2);

1041: For k in l_structure_tbl.FIRST..l_structure_tbl.LAST LOOP
1042: IF l_structure_tbl(k).type ='SECTION' THEN
1043:
1044: /*IF (l_debug = 'Y') THEN
1045: okc_debug.log('170: Calling OKC_TERMS_SECTIONS_GRP.update_section', 2);
1046: okc_debug.log('170: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);
1047: okc_debug.log('170: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);
1048: END IF;*/
1049:

Line 1046: okc_debug.log('170: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);

1042: IF l_structure_tbl(k).type ='SECTION' THEN
1043:
1044: /*IF (l_debug = 'Y') THEN
1045: okc_debug.log('170: Calling OKC_TERMS_SECTIONS_GRP.update_section', 2);
1046: okc_debug.log('170: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);
1047: okc_debug.log('170: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);
1048: END IF;*/
1049:
1050: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 1047: okc_debug.log('170: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);

1043:
1044: /*IF (l_debug = 'Y') THEN
1045: okc_debug.log('170: Calling OKC_TERMS_SECTIONS_GRP.update_section', 2);
1046: okc_debug.log('170: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);
1047: okc_debug.log('170: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);
1048: END IF;*/
1049:
1050: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1051: FND_LOG.STRING(G_PROC_LEVEL,

Line 1072: okc_debug.log('170: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status, 2);

1068: p_object_version_number => NULL
1069: );
1070:
1071: /*IF (l_debug = 'Y') THEN
1072: okc_debug.log('170: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status, 2);
1073: END IF;*/
1074:
1075: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1076: FND_LOG.STRING(G_PROC_LEVEL,

Line 1088: okc_debug.log('180: Calling OKC_K_ARTICLES_GRP.update_article', 2);

1084: END IF;
1085: ELSIF l_structure_tbl(k).type ='ARTICLE' THEN
1086:
1087: /*IF (l_debug = 'Y') THEN
1088: okc_debug.log('180: Calling OKC_K_ARTICLES_GRP.update_article', 2);
1089: okc_debug.log('180: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);
1090: okc_debug.log('180: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);
1091: END IF;*/
1092:

Line 1089: okc_debug.log('180: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);

1085: ELSIF l_structure_tbl(k).type ='ARTICLE' THEN
1086:
1087: /*IF (l_debug = 'Y') THEN
1088: okc_debug.log('180: Calling OKC_K_ARTICLES_GRP.update_article', 2);
1089: okc_debug.log('180: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);
1090: okc_debug.log('180: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);
1091: END IF;*/
1092:
1093: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 1090: okc_debug.log('180: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);

1086:
1087: /*IF (l_debug = 'Y') THEN
1088: okc_debug.log('180: Calling OKC_K_ARTICLES_GRP.update_article', 2);
1089: okc_debug.log('180: l_structure_tbl(k).id : '||l_structure_tbl(k).id, 2);
1090: okc_debug.log('180: l_structure_tbl(k).label : '||l_structure_tbl(k).label, 2);
1091: END IF;*/
1092:
1093: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1094: FND_LOG.STRING(G_PROC_LEVEL,

Line 1114: okc_debug.log('180: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status, 2);

1110: p_label => l_structure_tbl(k).label,
1111: p_object_version_number => NULL
1112: );
1113: /*IF (l_debug = 'Y') THEN
1114: okc_debug.log('180: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status, 2);
1115: END IF;*/
1116:
1117: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1118: FND_LOG.STRING(G_PROC_LEVEL,

Line 1166: okc_debug.log('300: p_doc_type = TEMPLATE', 2);

1162:
1163: IF p_doc_type='TEMPLATE' THEN
1164:
1165: /*IF (l_debug = 'Y') THEN
1166: okc_debug.log('300: p_doc_type = TEMPLATE', 2);
1167: okc_debug.log('300: OKC_TERMS_TEMPLATES_GRP.update_template', 2);
1168: END IF;*/
1169:
1170: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN

Line 1167: okc_debug.log('300: OKC_TERMS_TEMPLATES_GRP.update_template', 2);

1163: IF p_doc_type='TEMPLATE' THEN
1164:
1165: /*IF (l_debug = 'Y') THEN
1166: okc_debug.log('300: p_doc_type = TEMPLATE', 2);
1167: okc_debug.log('300: OKC_TERMS_TEMPLATES_GRP.update_template', 2);
1168: END IF;*/
1169:
1170: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1171: FND_LOG.STRING(G_PROC_LEVEL,

Line 1203: okc_debug.log('300: After Call to OKC_TERMS_TEMPLATES_GRP.update_template x_return_status : '||x_return_status, 2);

1199: p_object_version_number => NULL
1200: );
1201:
1202: /*IF (l_debug = 'Y') THEN
1203: okc_debug.log('300: After Call to OKC_TERMS_TEMPLATES_GRP.update_template x_return_status : '||x_return_status, 2);
1204: END IF;*/
1205:
1206: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1207: FND_LOG.STRING(G_PROC_LEVEL,

Line 1223: okc_debug.log('400: OKC_TEMPLATE_USAGES_GRP.update_template_usages', 2);

1219: FOR cr in l_get_usage_rec LOOP
1220:
1221: -- Updating usage rec with numbering scheme
1222: /*IF (l_debug = 'Y') THEN
1223: okc_debug.log('400: OKC_TEMPLATE_USAGES_GRP.update_template_usages', 2);
1224: END IF;*/
1225:
1226: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1227: FND_LOG.STRING(G_PROC_LEVEL,

Line 1250: okc_debug.log('400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status, 2);

1246: p_object_version_number =>cr.object_version_number
1247: );
1248:
1249: /*IF (l_debug = 'Y') THEN
1250: okc_debug.log('400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status, 2);
1251: END IF;*/
1252:
1253: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1254: FND_LOG.STRING(G_PROC_LEVEL,

Line 1275: okc_debug.log('2000: Leaving apply_numbering_scheme', 2);

1271: -- Standard call to get message count and if count is 1, get message info.
1272: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1273:
1274: /*IF (l_debug = 'Y') THEN
1275: okc_debug.log('2000: Leaving apply_numbering_scheme', 2);
1276: END IF;*/
1277:
1278: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1279: FND_LOG.STRING(G_PROC_LEVEL,

Line 1285: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1281: END IF;
1282: EXCEPTION
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: /*IF (l_debug = 'Y') THEN
1285: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1286: END IF;*/
1287:
1288: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1289: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1299: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1296:
1297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1298: /*IF (l_debug = 'Y') THEN
1299: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1300: END IF;*/
1301:
1302: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1303: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1313: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1309: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1310:
1311: WHEN OTHERS THEN
1312: /*IF (l_debug = 'Y') THEN
1313: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1314: END IF;*/
1315:
1316: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1317: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1848: okc_debug.log('2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1844: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1845:
1846: WHEN OTHERS THEN
1847: IF (l_debug = 'Y') THEN
1848: okc_debug.log('2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1849: END IF;
1850:
1851: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1852: FND_LOG.STRING(G_EXCP_LEVEL,