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 FND_LOG

Line 30: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

26:
27: G_UPPERCASE_ROMAN_NUMBER CONSTANT VARCHAR2(30) :='UPPERCASE_ROMAN_NUMBER';
28: G_LOWERCASE_ROMAN_NUMBER CONSTANT VARCHAR2(30) :='LOWERCASE_ROMAN_NUMBER';
29:
30: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
33:
34: TYPE structure_rec_type IS RECORD (

Line 31: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;

27: G_UPPERCASE_ROMAN_NUMBER CONSTANT VARCHAR2(30) :='UPPERCASE_ROMAN_NUMBER';
28: G_LOWERCASE_ROMAN_NUMBER CONSTANT VARCHAR2(30) :='LOWERCASE_ROMAN_NUMBER';
29:
30: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
33:
34: TYPE structure_rec_type IS RECORD (
35: ID NUMBER,

Line 32: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;

28: G_LOWERCASE_ROMAN_NUMBER CONSTANT VARCHAR2(30) :='LOWERCASE_ROMAN_NUMBER';
29:
30: G_DBG_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
31: G_PROC_LEVEL NUMBER := FND_LOG.LEVEL_PROCEDURE;
32: G_EXCP_LEVEL NUMBER := FND_LOG.LEVEL_EXCEPTION;
33:
34: TYPE structure_rec_type IS RECORD (
35: ID NUMBER,
36: Type VARCHAR2(30),

Line 134: FND_LOG.STRING(G_PROC_LEVEL,

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,
135: G_PKG_NAME, '100: Inside convert_to_roman' );
136: FND_LOG.STRING(G_PROC_LEVEL,
137: G_PKG_NAME, '100: p_number : '||p_number );
138: END IF;

Line 136: FND_LOG.STRING(G_PROC_LEVEL,

132:
133: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
134: FND_LOG.STRING(G_PROC_LEVEL,
135: G_PKG_NAME, '100: Inside convert_to_roman' );
136: FND_LOG.STRING(G_PROC_LEVEL,
137: G_PKG_NAME, '100: p_number : '||p_number );
138: END IF;
139:
140: If p_number > 3999 then

Line 227: FND_LOG.STRING(G_PROC_LEVEL,

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,
228: G_PKG_NAME, '1000: Leaving convert_to_roman' );
229: FND_LOG.STRING(G_PROC_LEVEL,
230: G_PKG_NAME, '1000: out_roman : '||out_roman );
231: END IF;

Line 229: FND_LOG.STRING(G_PROC_LEVEL,

225:
226: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
227: FND_LOG.STRING(G_PROC_LEVEL,
228: G_PKG_NAME, '1000: Leaving convert_to_roman' );
229: FND_LOG.STRING(G_PROC_LEVEL,
230: G_PKG_NAME, '1000: out_roman : '||out_roman );
231: END IF;
232:
233: return out_roman;

Line 242: FND_LOG.STRING(G_EXCP_LEVEL,

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,
243: G_PKG_NAME, '300: Leaving convert_to_roman: OKC_API.G_EXCEPTION_ERROR Exception' );
244: END IF;
245:
246: raise;

Line 255: FND_LOG.STRING(G_EXCP_LEVEL,

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,
256: G_PKG_NAME, '400: Leaving convert_to_roman: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
257: END IF;
258:
259: raise;

Line 268: FND_LOG.STRING(G_EXCP_LEVEL,

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,
269: G_PKG_NAME, '500: Leaving convert_to_roman because of EXCEPTION: '||sqlerrm );
270: END IF;
271:
272: raise;

Line 288: FND_LOG.STRING(G_PROC_LEVEL,

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,
289: G_PKG_NAME, '100: Entering get_numbering_seq' );
290: FND_LOG.STRING(G_PROC_LEVEL,
291: G_PKG_NAME, '100: p_level : '||p_level );
292: END IF;

Line 290: FND_LOG.STRING(G_PROC_LEVEL,

286:
287: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
288: FND_LOG.STRING(G_PROC_LEVEL,
289: G_PKG_NAME, '100: Entering get_numbering_seq' );
290: FND_LOG.STRING(G_PROC_LEVEL,
291: G_PKG_NAME, '100: p_level : '||p_level );
292: END IF;
293:
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)

Line 302: FND_LOG.STRING(G_PROC_LEVEL,

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,
303: G_PKG_NAME, '150: l_vl_seq_code : '||l_vl_seq_code );
304: END IF;
305:
306: IF p_level = 1 THEN

Line 332: FND_LOG.STRING(G_PROC_LEVEL,

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,
333: G_PKG_NAME, '180: l_lvl_sequence : '||l_lvl_sequence );
334: END IF;
335:
336: IF l_vl_seq_code = G_NUMBER_SEQUENCE THEN

Line 357: FND_LOG.STRING(G_PROC_LEVEL,

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,
358: G_PKG_NAME, '300: Leaving get_numbering_seq ' );
359: FND_LOG.STRING(G_PROC_LEVEL,
360: G_PKG_NAME, '300: l_number : '||l_number );
361: END IF;

Line 359: FND_LOG.STRING(G_PROC_LEVEL,

355:
356: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
357: FND_LOG.STRING(G_PROC_LEVEL,
358: G_PKG_NAME, '300: Leaving get_numbering_seq ' );
359: FND_LOG.STRING(G_PROC_LEVEL,
360: G_PKG_NAME, '300: l_number : '||l_number );
361: END IF;
362:
363: return l_number;

Line 373: FND_LOG.STRING(G_EXCP_LEVEL,

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,
374: G_PKG_NAME, '400: Leaving get_numbering_seq: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
375: END IF;
376:
377: raise;

Line 385: FND_LOG.STRING(G_EXCP_LEVEL,

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,
386: G_PKG_NAME, '500: Leaving get_numbering_seq because of EXCEPTION: '||sqlerrm );
387: END IF;
388:
389: raise;

Line 431: FND_LOG.STRING(G_PROC_LEVEL,

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,
432: G_PKG_NAME, '100: Entering section_numbering ' );
433: FND_LOG.STRING(G_PROC_LEVEL,
434: G_PKG_NAME, '100: Parameters ' );
435: FND_LOG.STRING(G_PROC_LEVEL,

Line 433: FND_LOG.STRING(G_PROC_LEVEL,

429:
430: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
431: FND_LOG.STRING(G_PROC_LEVEL,
432: G_PKG_NAME, '100: Entering section_numbering ' );
433: FND_LOG.STRING(G_PROC_LEVEL,
434: G_PKG_NAME, '100: Parameters ' );
435: FND_LOG.STRING(G_PROC_LEVEL,
436: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
437: FND_LOG.STRING(G_PROC_LEVEL,

Line 435: FND_LOG.STRING(G_PROC_LEVEL,

431: FND_LOG.STRING(G_PROC_LEVEL,
432: G_PKG_NAME, '100: Entering section_numbering ' );
433: FND_LOG.STRING(G_PROC_LEVEL,
434: G_PKG_NAME, '100: Parameters ' );
435: FND_LOG.STRING(G_PROC_LEVEL,
436: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
437: FND_LOG.STRING(G_PROC_LEVEL,
438: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
439: FND_LOG.STRING(G_PROC_LEVEL,

Line 437: FND_LOG.STRING(G_PROC_LEVEL,

433: FND_LOG.STRING(G_PROC_LEVEL,
434: G_PKG_NAME, '100: Parameters ' );
435: FND_LOG.STRING(G_PROC_LEVEL,
436: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
437: FND_LOG.STRING(G_PROC_LEVEL,
438: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
439: FND_LOG.STRING(G_PROC_LEVEL,
440: G_PKG_NAME, '100: p_level : '||p_level );
441: FND_LOG.STRING(G_PROC_LEVEL,

Line 439: FND_LOG.STRING(G_PROC_LEVEL,

435: FND_LOG.STRING(G_PROC_LEVEL,
436: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
437: FND_LOG.STRING(G_PROC_LEVEL,
438: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
439: FND_LOG.STRING(G_PROC_LEVEL,
440: G_PKG_NAME, '100: p_level : '||p_level );
441: FND_LOG.STRING(G_PROC_LEVEL,
442: G_PKG_NAME, '100: p_parent_label : '||p_parent_label );
443: FND_LOG.STRING(G_PROC_LEVEL,

Line 441: FND_LOG.STRING(G_PROC_LEVEL,

437: FND_LOG.STRING(G_PROC_LEVEL,
438: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
439: FND_LOG.STRING(G_PROC_LEVEL,
440: G_PKG_NAME, '100: p_level : '||p_level );
441: FND_LOG.STRING(G_PROC_LEVEL,
442: G_PKG_NAME, '100: p_parent_label : '||p_parent_label );
443: FND_LOG.STRING(G_PROC_LEVEL,
444: G_PKG_NAME, '100: p_scn_id : '||p_scn_id );
445: END IF;

Line 443: FND_LOG.STRING(G_PROC_LEVEL,

439: FND_LOG.STRING(G_PROC_LEVEL,
440: G_PKG_NAME, '100: p_level : '||p_level );
441: FND_LOG.STRING(G_PROC_LEVEL,
442: G_PKG_NAME, '100: p_parent_label : '||p_parent_label );
443: FND_LOG.STRING(G_PROC_LEVEL,
444: G_PKG_NAME, '100: p_scn_id : '||p_scn_id );
445: END IF;
446:
447: select decode(p_level,1,NULL,2,l_lvl1_concat_yn,3,l_lvl2_concat_yn,4,l_lvl3_concat_yn,5,l_lvl4_concat_yn,'N'),

Line 457: FND_LOG.STRING(G_PROC_LEVEL,

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,
458: G_PKG_NAME, '110: l_concat_yn : '||l_concat_yn );
459: FND_LOG.STRING(G_PROC_LEVEL,
460: G_PKG_NAME, '110: l_end_char : '||l_end_char );
461: END IF;

Line 459: FND_LOG.STRING(G_PROC_LEVEL,

455:
456: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
457: FND_LOG.STRING(G_PROC_LEVEL,
458: G_PKG_NAME, '110: l_concat_yn : '||l_concat_yn );
459: FND_LOG.STRING(G_PROC_LEVEL,
460: G_PKG_NAME, '110: l_end_char : '||l_end_char );
461: END IF;
462:
463: FOR cr in l_get_child_csr LOOP

Line 486: FND_LOG.STRING(G_PROC_LEVEL,

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,
487: G_PKG_NAME, '120: i : '||i );
488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '120: l_structure_tbl(i).id : '||l_structure_tbl(i).id );
490: FND_LOG.STRING(G_PROC_LEVEL,

Line 488: FND_LOG.STRING(G_PROC_LEVEL,

484:
485: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
486: FND_LOG.STRING(G_PROC_LEVEL,
487: G_PKG_NAME, '120: i : '||i );
488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '120: l_structure_tbl(i).id : '||l_structure_tbl(i).id );
490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '120: l_structure_tbl(i).type : '||l_structure_tbl(i).type );
492: FND_LOG.STRING(G_PROC_LEVEL,

Line 490: FND_LOG.STRING(G_PROC_LEVEL,

486: FND_LOG.STRING(G_PROC_LEVEL,
487: G_PKG_NAME, '120: i : '||i );
488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '120: l_structure_tbl(i).id : '||l_structure_tbl(i).id );
490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '120: l_structure_tbl(i).type : '||l_structure_tbl(i).type );
492: FND_LOG.STRING(G_PROC_LEVEL,
493: G_PKG_NAME, '120: l_structure_tbl(i).label : '||l_structure_tbl(i).label );
494: END IF;

Line 492: FND_LOG.STRING(G_PROC_LEVEL,

488: FND_LOG.STRING(G_PROC_LEVEL,
489: G_PKG_NAME, '120: l_structure_tbl(i).id : '||l_structure_tbl(i).id );
490: FND_LOG.STRING(G_PROC_LEVEL,
491: G_PKG_NAME, '120: l_structure_tbl(i).type : '||l_structure_tbl(i).type );
492: FND_LOG.STRING(G_PROC_LEVEL,
493: G_PKG_NAME, '120: l_structure_tbl(i).label : '||l_structure_tbl(i).label );
494: END IF;
495:
496: IF cr.type='SECTION' THEN

Line 521: FND_LOG.STRING(G_PROC_LEVEL,

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,
522: G_PKG_NAME, '300: Leaving section_numbering ' );
523: END IF;
524:
525: EXCEPTION

Line 533: FND_LOG.STRING(G_EXCP_LEVEL,

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,
534: G_PKG_NAME, '400: Leaving section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
535: END IF;
536:
537: raise;

Line 545: FND_LOG.STRING(G_EXCP_LEVEL,

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,
546: G_PKG_NAME, '500: Leaving section_numbering because of EXCEPTION: '||sqlerrm );
547: END IF;
548:
549: raise;

Line 588: FND_LOG.STRING(G_PROC_LEVEL,

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,
589: G_PKG_NAME, '100: Entered generate_preview' );
590: FND_LOG.STRING(G_PROC_LEVEL,
591: G_PKG_NAME, '100: p_num_scheme_id : '||p_num_scheme_id );
592: END IF;

Line 590: FND_LOG.STRING(G_PROC_LEVEL,

586:
587: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
588: FND_LOG.STRING(G_PROC_LEVEL,
589: G_PKG_NAME, '100: Entered generate_preview' );
590: FND_LOG.STRING(G_PROC_LEVEL,
591: G_PKG_NAME, '100: p_num_scheme_id : '||p_num_scheme_id );
592: END IF;
593:
594: -- Standard Start of API savepoint

Line 653: FND_LOG.STRING(G_PROC_LEVEL,

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,
654: G_PKG_NAME, '300: Leaving generate_preview' );
655: END IF;
656:
657: EXCEPTION

Line 664: FND_LOG.STRING(G_EXCP_LEVEL,

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,
665: G_PKG_NAME, '2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception' );
666: END IF;
667:
668: Rollback to g_generate_preview;

Line 678: FND_LOG.STRING(G_EXCP_LEVEL,

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,
679: G_PKG_NAME, '2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception' );
680: END IF;
681:
682: Rollback to g_generate_preview;

Line 692: FND_LOG.STRING(G_EXCP_LEVEL,

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,
693: G_PKG_NAME, '2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception' );
694: END IF;
695:
696: Rollback to g_generate_preview;

Line 782: FND_LOG.STRING(G_PROC_LEVEL,

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,
783: G_PKG_NAME, '100: Entered apply_numbering_scheme' );
784: FND_LOG.STRING(G_PROC_LEVEL,
785: G_PKG_NAME, '100: Parameter List ' );
786: FND_LOG.STRING(G_PROC_LEVEL,

Line 784: FND_LOG.STRING(G_PROC_LEVEL,

780:
781: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
782: FND_LOG.STRING(G_PROC_LEVEL,
783: G_PKG_NAME, '100: Entered apply_numbering_scheme' );
784: FND_LOG.STRING(G_PROC_LEVEL,
785: G_PKG_NAME, '100: Parameter List ' );
786: FND_LOG.STRING(G_PROC_LEVEL,
787: G_PKG_NAME, '100: p_api_version : '||p_api_version );
788: FND_LOG.STRING(G_PROC_LEVEL,

Line 786: FND_LOG.STRING(G_PROC_LEVEL,

782: FND_LOG.STRING(G_PROC_LEVEL,
783: G_PKG_NAME, '100: Entered apply_numbering_scheme' );
784: FND_LOG.STRING(G_PROC_LEVEL,
785: G_PKG_NAME, '100: Parameter List ' );
786: FND_LOG.STRING(G_PROC_LEVEL,
787: G_PKG_NAME, '100: p_api_version : '||p_api_version );
788: FND_LOG.STRING(G_PROC_LEVEL,
789: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
790: FND_LOG.STRING(G_PROC_LEVEL,

Line 788: FND_LOG.STRING(G_PROC_LEVEL,

784: FND_LOG.STRING(G_PROC_LEVEL,
785: G_PKG_NAME, '100: Parameter List ' );
786: FND_LOG.STRING(G_PROC_LEVEL,
787: G_PKG_NAME, '100: p_api_version : '||p_api_version );
788: FND_LOG.STRING(G_PROC_LEVEL,
789: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
790: FND_LOG.STRING(G_PROC_LEVEL,
791: G_PKG_NAME, '100: p_commit : '||p_commit );
792: FND_LOG.STRING(G_PROC_LEVEL,

Line 790: FND_LOG.STRING(G_PROC_LEVEL,

786: FND_LOG.STRING(G_PROC_LEVEL,
787: G_PKG_NAME, '100: p_api_version : '||p_api_version );
788: FND_LOG.STRING(G_PROC_LEVEL,
789: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
790: FND_LOG.STRING(G_PROC_LEVEL,
791: G_PKG_NAME, '100: p_commit : '||p_commit );
792: FND_LOG.STRING(G_PROC_LEVEL,
793: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
794: FND_LOG.STRING(G_PROC_LEVEL,

Line 792: FND_LOG.STRING(G_PROC_LEVEL,

788: FND_LOG.STRING(G_PROC_LEVEL,
789: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list );
790: FND_LOG.STRING(G_PROC_LEVEL,
791: G_PKG_NAME, '100: p_commit : '||p_commit );
792: FND_LOG.STRING(G_PROC_LEVEL,
793: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
794: FND_LOG.STRING(G_PROC_LEVEL,
795: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
796: FND_LOG.STRING(G_PROC_LEVEL,

Line 794: FND_LOG.STRING(G_PROC_LEVEL,

790: FND_LOG.STRING(G_PROC_LEVEL,
791: G_PKG_NAME, '100: p_commit : '||p_commit );
792: FND_LOG.STRING(G_PROC_LEVEL,
793: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
794: FND_LOG.STRING(G_PROC_LEVEL,
795: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
796: FND_LOG.STRING(G_PROC_LEVEL,
797: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
798: FND_LOG.STRING(G_PROC_LEVEL,

Line 796: FND_LOG.STRING(G_PROC_LEVEL,

792: FND_LOG.STRING(G_PROC_LEVEL,
793: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit );
794: FND_LOG.STRING(G_PROC_LEVEL,
795: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
796: FND_LOG.STRING(G_PROC_LEVEL,
797: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
798: FND_LOG.STRING(G_PROC_LEVEL,
799: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
800: FND_LOG.STRING(G_PROC_LEVEL,

Line 798: FND_LOG.STRING(G_PROC_LEVEL,

794: FND_LOG.STRING(G_PROC_LEVEL,
795: G_PKG_NAME, '100: p_validation_string : '||p_validation_string );
796: FND_LOG.STRING(G_PROC_LEVEL,
797: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
798: FND_LOG.STRING(G_PROC_LEVEL,
799: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
800: FND_LOG.STRING(G_PROC_LEVEL,
801: G_PKG_NAME, '100: p_num_scheme_id : '||p_num_scheme_id );
802: END IF;

Line 800: FND_LOG.STRING(G_PROC_LEVEL,

796: FND_LOG.STRING(G_PROC_LEVEL,
797: G_PKG_NAME, '100: p_doc_type : '||p_doc_type );
798: FND_LOG.STRING(G_PROC_LEVEL,
799: G_PKG_NAME, '100: p_doc_id : '||p_doc_id );
800: FND_LOG.STRING(G_PROC_LEVEL,
801: G_PKG_NAME, '100: p_num_scheme_id : '||p_num_scheme_id );
802: END IF;
803:
804: -- Initialize the global Structure Table bug 3200243

Line 835: FND_LOG.STRING(G_PROC_LEVEL,

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

Line 858: FND_LOG.STRING(G_PROC_LEVEL,

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,
859: G_PKG_NAME, '110: Numbering Scheme Detail Count : '||l_dtl_count );
860: END IF;
861:
862: --IF l_dtl_count = 0 THEN

Line 892: FND_LOG.STRING(G_PROC_LEVEL,

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,
893: G_PKG_NAME, '120: l_number_article_yn : '||l_number_article_yn );
894: END IF;
895:
896: FOR CR in l_get_num_scheme_dtl LOOP

Line 946: FND_LOG.STRING(G_PROC_LEVEL,

942: END IF;*/
943:
944:
945: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
946: FND_LOG.STRING(G_PROC_LEVEL,
947: G_PKG_NAME, '130: Sequence Level 1 ');
948: FND_LOG.STRING(G_PROC_LEVEL,
949: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
950: FND_LOG.STRING(G_PROC_LEVEL,

Line 948: FND_LOG.STRING(G_PROC_LEVEL,

944:
945: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
946: FND_LOG.STRING(G_PROC_LEVEL,
947: G_PKG_NAME, '130: Sequence Level 1 ');
948: FND_LOG.STRING(G_PROC_LEVEL,
949: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
950: FND_LOG.STRING(G_PROC_LEVEL,
951: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
952: FND_LOG.STRING(G_PROC_LEVEL,

Line 950: FND_LOG.STRING(G_PROC_LEVEL,

946: FND_LOG.STRING(G_PROC_LEVEL,
947: G_PKG_NAME, '130: Sequence Level 1 ');
948: FND_LOG.STRING(G_PROC_LEVEL,
949: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
950: FND_LOG.STRING(G_PROC_LEVEL,
951: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
952: FND_LOG.STRING(G_PROC_LEVEL,
953: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
954: FND_LOG.STRING(G_PROC_LEVEL,

Line 952: FND_LOG.STRING(G_PROC_LEVEL,

948: FND_LOG.STRING(G_PROC_LEVEL,
949: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
950: FND_LOG.STRING(G_PROC_LEVEL,
951: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
952: FND_LOG.STRING(G_PROC_LEVEL,
953: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
954: FND_LOG.STRING(G_PROC_LEVEL,
955: G_PKG_NAME, '130: Sequence Level 2 ');
956: FND_LOG.STRING(G_PROC_LEVEL,

Line 954: FND_LOG.STRING(G_PROC_LEVEL,

950: FND_LOG.STRING(G_PROC_LEVEL,
951: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
952: FND_LOG.STRING(G_PROC_LEVEL,
953: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
954: FND_LOG.STRING(G_PROC_LEVEL,
955: G_PKG_NAME, '130: Sequence Level 2 ');
956: FND_LOG.STRING(G_PROC_LEVEL,
957: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
958: FND_LOG.STRING(G_PROC_LEVEL,

Line 956: FND_LOG.STRING(G_PROC_LEVEL,

952: FND_LOG.STRING(G_PROC_LEVEL,
953: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
954: FND_LOG.STRING(G_PROC_LEVEL,
955: G_PKG_NAME, '130: Sequence Level 2 ');
956: FND_LOG.STRING(G_PROC_LEVEL,
957: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
958: FND_LOG.STRING(G_PROC_LEVEL,
959: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
960: FND_LOG.STRING(G_PROC_LEVEL,

Line 958: FND_LOG.STRING(G_PROC_LEVEL,

954: FND_LOG.STRING(G_PROC_LEVEL,
955: G_PKG_NAME, '130: Sequence Level 2 ');
956: FND_LOG.STRING(G_PROC_LEVEL,
957: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
958: FND_LOG.STRING(G_PROC_LEVEL,
959: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
960: FND_LOG.STRING(G_PROC_LEVEL,
961: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
962: FND_LOG.STRING(G_PROC_LEVEL,

Line 960: FND_LOG.STRING(G_PROC_LEVEL,

956: FND_LOG.STRING(G_PROC_LEVEL,
957: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
958: FND_LOG.STRING(G_PROC_LEVEL,
959: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
960: FND_LOG.STRING(G_PROC_LEVEL,
961: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
962: FND_LOG.STRING(G_PROC_LEVEL,
963: G_PKG_NAME, '130: Sequence Level 3 ');
964: FND_LOG.STRING(G_PROC_LEVEL,

Line 962: FND_LOG.STRING(G_PROC_LEVEL,

958: FND_LOG.STRING(G_PROC_LEVEL,
959: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
960: FND_LOG.STRING(G_PROC_LEVEL,
961: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
962: FND_LOG.STRING(G_PROC_LEVEL,
963: G_PKG_NAME, '130: Sequence Level 3 ');
964: FND_LOG.STRING(G_PROC_LEVEL,
965: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
966: FND_LOG.STRING(G_PROC_LEVEL,

Line 964: FND_LOG.STRING(G_PROC_LEVEL,

960: FND_LOG.STRING(G_PROC_LEVEL,
961: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
962: FND_LOG.STRING(G_PROC_LEVEL,
963: G_PKG_NAME, '130: Sequence Level 3 ');
964: FND_LOG.STRING(G_PROC_LEVEL,
965: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
966: FND_LOG.STRING(G_PROC_LEVEL,
967: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
968: FND_LOG.STRING(G_PROC_LEVEL,

Line 966: FND_LOG.STRING(G_PROC_LEVEL,

962: FND_LOG.STRING(G_PROC_LEVEL,
963: G_PKG_NAME, '130: Sequence Level 3 ');
964: FND_LOG.STRING(G_PROC_LEVEL,
965: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
966: FND_LOG.STRING(G_PROC_LEVEL,
967: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
968: FND_LOG.STRING(G_PROC_LEVEL,
969: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
970: FND_LOG.STRING(G_PROC_LEVEL,

Line 968: FND_LOG.STRING(G_PROC_LEVEL,

964: FND_LOG.STRING(G_PROC_LEVEL,
965: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
966: FND_LOG.STRING(G_PROC_LEVEL,
967: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
968: FND_LOG.STRING(G_PROC_LEVEL,
969: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '130: Sequence Level 4 ');
972: FND_LOG.STRING(G_PROC_LEVEL,

Line 970: FND_LOG.STRING(G_PROC_LEVEL,

966: FND_LOG.STRING(G_PROC_LEVEL,
967: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
968: FND_LOG.STRING(G_PROC_LEVEL,
969: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '130: Sequence Level 4 ');
972: FND_LOG.STRING(G_PROC_LEVEL,
973: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
974: FND_LOG.STRING(G_PROC_LEVEL,

Line 972: FND_LOG.STRING(G_PROC_LEVEL,

968: FND_LOG.STRING(G_PROC_LEVEL,
969: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '130: Sequence Level 4 ');
972: FND_LOG.STRING(G_PROC_LEVEL,
973: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
974: FND_LOG.STRING(G_PROC_LEVEL,
975: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
976: FND_LOG.STRING(G_PROC_LEVEL,

Line 974: FND_LOG.STRING(G_PROC_LEVEL,

970: FND_LOG.STRING(G_PROC_LEVEL,
971: G_PKG_NAME, '130: Sequence Level 4 ');
972: FND_LOG.STRING(G_PROC_LEVEL,
973: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
974: FND_LOG.STRING(G_PROC_LEVEL,
975: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
976: FND_LOG.STRING(G_PROC_LEVEL,
977: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
978: FND_LOG.STRING(G_PROC_LEVEL,

Line 976: FND_LOG.STRING(G_PROC_LEVEL,

972: FND_LOG.STRING(G_PROC_LEVEL,
973: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
974: FND_LOG.STRING(G_PROC_LEVEL,
975: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
976: FND_LOG.STRING(G_PROC_LEVEL,
977: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
978: FND_LOG.STRING(G_PROC_LEVEL,
979: G_PKG_NAME, '130: Sequence Level 5 ');
980: FND_LOG.STRING(G_PROC_LEVEL,

Line 978: FND_LOG.STRING(G_PROC_LEVEL,

974: FND_LOG.STRING(G_PROC_LEVEL,
975: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
976: FND_LOG.STRING(G_PROC_LEVEL,
977: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
978: FND_LOG.STRING(G_PROC_LEVEL,
979: G_PKG_NAME, '130: Sequence Level 5 ');
980: FND_LOG.STRING(G_PROC_LEVEL,
981: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
982: FND_LOG.STRING(G_PROC_LEVEL,

Line 980: FND_LOG.STRING(G_PROC_LEVEL,

976: FND_LOG.STRING(G_PROC_LEVEL,
977: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
978: FND_LOG.STRING(G_PROC_LEVEL,
979: G_PKG_NAME, '130: Sequence Level 5 ');
980: FND_LOG.STRING(G_PROC_LEVEL,
981: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
982: FND_LOG.STRING(G_PROC_LEVEL,
983: G_PKG_NAME, '130: l_lvl5_concat_yn : '||l_lvl5_concat_yn);
984: FND_LOG.STRING(G_PROC_LEVEL,

Line 982: FND_LOG.STRING(G_PROC_LEVEL,

978: FND_LOG.STRING(G_PROC_LEVEL,
979: G_PKG_NAME, '130: Sequence Level 5 ');
980: FND_LOG.STRING(G_PROC_LEVEL,
981: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
982: FND_LOG.STRING(G_PROC_LEVEL,
983: G_PKG_NAME, '130: l_lvl5_concat_yn : '||l_lvl5_concat_yn);
984: FND_LOG.STRING(G_PROC_LEVEL,
985: G_PKG_NAME, '130: l_lvl5_end_char : '||l_lvl5_end_char);
986: END IF;

Line 984: FND_LOG.STRING(G_PROC_LEVEL,

980: FND_LOG.STRING(G_PROC_LEVEL,
981: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
982: FND_LOG.STRING(G_PROC_LEVEL,
983: G_PKG_NAME, '130: l_lvl5_concat_yn : '||l_lvl5_concat_yn);
984: FND_LOG.STRING(G_PROC_LEVEL,
985: G_PKG_NAME, '130: l_lvl5_end_char : '||l_lvl5_end_char);
986: END IF;
987:
988: l_lvl1_sequence :=0;

Line 1003: FND_LOG.STRING(G_PROC_LEVEL,

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,
1004: G_PKG_NAME, '140: l_number : '||l_number );
1005: END IF;
1006:
1007: l_label := l_number||l_lvl1_end_char;

Line 1014: FND_LOG.STRING(G_PROC_LEVEL,

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,
1015: G_PKG_NAME, '150: l_label : '||l_label );
1016: END IF;
1017:
1018: i := l_structure_tbl.count+1;

Line 1036: FND_LOG.STRING(G_PROC_LEVEL,

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,
1037: G_PKG_NAME, '160: Count of l_structure_tbl : '||l_structure_tbl.count );
1038: END IF;
1039:
1040: IF l_structure_tbl.count > 0 THEN

Line 1051: FND_LOG.STRING(G_PROC_LEVEL,

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,
1052: G_PKG_NAME, '170: Calling OKC_TERMS_SECTIONS_GRP.update_section' );
1053: FND_LOG.STRING(G_PROC_LEVEL,
1054: G_PKG_NAME, '170: l_structure_tbl(k).id : '||l_structure_tbl(k).id );
1055: FND_LOG.STRING(G_PROC_LEVEL,

Line 1053: FND_LOG.STRING(G_PROC_LEVEL,

1049:
1050: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1051: FND_LOG.STRING(G_PROC_LEVEL,
1052: G_PKG_NAME, '170: Calling OKC_TERMS_SECTIONS_GRP.update_section' );
1053: FND_LOG.STRING(G_PROC_LEVEL,
1054: G_PKG_NAME, '170: l_structure_tbl(k).id : '||l_structure_tbl(k).id );
1055: FND_LOG.STRING(G_PROC_LEVEL,
1056: G_PKG_NAME, '170: l_structure_tbl(k).label : '||l_structure_tbl(k).label );
1057: END IF;

Line 1055: FND_LOG.STRING(G_PROC_LEVEL,

1051: FND_LOG.STRING(G_PROC_LEVEL,
1052: G_PKG_NAME, '170: Calling OKC_TERMS_SECTIONS_GRP.update_section' );
1053: FND_LOG.STRING(G_PROC_LEVEL,
1054: G_PKG_NAME, '170: l_structure_tbl(k).id : '||l_structure_tbl(k).id );
1055: FND_LOG.STRING(G_PROC_LEVEL,
1056: G_PKG_NAME, '170: l_structure_tbl(k).label : '||l_structure_tbl(k).label );
1057: END IF;
1058:
1059: OKC_TERMS_SECTIONS_GRP.update_section(

Line 1076: FND_LOG.STRING(G_PROC_LEVEL,

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,
1077: G_PKG_NAME, '170: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status );
1078: END IF;
1079:
1080: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1094: FND_LOG.STRING(G_PROC_LEVEL,

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,
1095: G_PKG_NAME, '180: Calling OKC_K_ARTICLES_GRP.update_article');
1096: FND_LOG.STRING(G_PROC_LEVEL,
1097: G_PKG_NAME, '180: l_structure_tbl(k).id : '||l_structure_tbl(k).id);
1098: FND_LOG.STRING(G_PROC_LEVEL,

Line 1096: FND_LOG.STRING(G_PROC_LEVEL,

1092:
1093: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1094: FND_LOG.STRING(G_PROC_LEVEL,
1095: G_PKG_NAME, '180: Calling OKC_K_ARTICLES_GRP.update_article');
1096: FND_LOG.STRING(G_PROC_LEVEL,
1097: G_PKG_NAME, '180: l_structure_tbl(k).id : '||l_structure_tbl(k).id);
1098: FND_LOG.STRING(G_PROC_LEVEL,
1099: G_PKG_NAME, '180: l_structure_tbl(k).label : '||l_structure_tbl(k).label);
1100: END IF;

Line 1098: FND_LOG.STRING(G_PROC_LEVEL,

1094: FND_LOG.STRING(G_PROC_LEVEL,
1095: G_PKG_NAME, '180: Calling OKC_K_ARTICLES_GRP.update_article');
1096: FND_LOG.STRING(G_PROC_LEVEL,
1097: G_PKG_NAME, '180: l_structure_tbl(k).id : '||l_structure_tbl(k).id);
1098: FND_LOG.STRING(G_PROC_LEVEL,
1099: G_PKG_NAME, '180: l_structure_tbl(k).label : '||l_structure_tbl(k).label);
1100: END IF;
1101:
1102: OKC_K_ARTICLES_GRP.update_article(

Line 1118: FND_LOG.STRING(G_PROC_LEVEL,

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,
1119: G_PKG_NAME, '180: After Calling OKC_TERMS_SECTIONS_GRP.update_section x_return_status : '||x_return_status );
1120: END IF;
1121:
1122: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1171: FND_LOG.STRING(G_PROC_LEVEL,

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,
1172: G_PKG_NAME, '300: p_doc_type = TEMPLATE' );
1173: FND_LOG.STRING(G_PROC_LEVEL,
1174: G_PKG_NAME, '300: OKC_TERMS_TEMPLATES_GRP.update_template' );
1175: END IF;

Line 1173: FND_LOG.STRING(G_PROC_LEVEL,

1169:
1170: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1171: FND_LOG.STRING(G_PROC_LEVEL,
1172: G_PKG_NAME, '300: p_doc_type = TEMPLATE' );
1173: FND_LOG.STRING(G_PROC_LEVEL,
1174: G_PKG_NAME, '300: OKC_TERMS_TEMPLATES_GRP.update_template' );
1175: END IF;
1176:
1177: OKC_TERMS_TEMPLATES_GRP.update_template(

Line 1207: FND_LOG.STRING(G_PROC_LEVEL,

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,
1208: G_PKG_NAME, '300: After Call to OKC_TERMS_TEMPLATES_GRP.update_template x_return_status : '||x_return_status );
1209: END IF;
1210:
1211: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1227: FND_LOG.STRING(G_PROC_LEVEL,

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,
1228: G_PKG_NAME, '400: OKC_TEMPLATE_USAGES_GRP.update_template_usages' );
1229: END IF;
1230:
1231: OKC_TEMPLATE_USAGES_GRP.update_template_usages(

Line 1254: FND_LOG.STRING(G_PROC_LEVEL,

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,
1255: G_PKG_NAME, '400: After Call to OKC_TEMPLATE_USAGES_GRP.update_template_usages x_return_status : '||x_return_status );
1256: END IF;
1257:
1258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1279: FND_LOG.STRING(G_PROC_LEVEL,

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,
1280: G_PKG_NAME, '2000: Leaving apply_numbering_scheme' );
1281: END IF;
1282: EXCEPTION
1283: WHEN FND_API.G_EXC_ERROR THEN

Line 1289: FND_LOG.STRING(G_EXCP_LEVEL,

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,
1290: G_PKG_NAME, '2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception' );
1291: END IF;
1292:
1293: ROLLBACK TO g_apply_numbering_scheme;

Line 1303: FND_LOG.STRING(G_EXCP_LEVEL,

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,
1304: G_PKG_NAME, '2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception' );
1305: END IF;
1306:
1307: ROLLBACK TO g_apply_numbering_scheme;

Line 1317: FND_LOG.STRING(G_EXCP_LEVEL,

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,
1318: G_PKG_NAME, '2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception' );
1319: END IF;
1320:
1321: ROLLBACK TO g_apply_numbering_scheme;

Line 1400: FND_LOG.STRING(G_PROC_LEVEL,

1396: i NUMBER;
1397: BEGIN
1398:
1399: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1400: FND_LOG.STRING(G_PROC_LEVEL,
1401: G_PKG_NAME, '100: Entering review_section_numbering ');
1402: FND_LOG.STRING(G_PROC_LEVEL,
1403: G_PKG_NAME, '100: Parameters ');
1404: FND_LOG.STRING(G_PROC_LEVEL,

Line 1402: FND_LOG.STRING(G_PROC_LEVEL,

1398:
1399: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1400: FND_LOG.STRING(G_PROC_LEVEL,
1401: G_PKG_NAME, '100: Entering review_section_numbering ');
1402: FND_LOG.STRING(G_PROC_LEVEL,
1403: G_PKG_NAME, '100: Parameters ');
1404: FND_LOG.STRING(G_PROC_LEVEL,
1405: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1406: FND_LOG.STRING(G_PROC_LEVEL,

Line 1404: FND_LOG.STRING(G_PROC_LEVEL,

1400: FND_LOG.STRING(G_PROC_LEVEL,
1401: G_PKG_NAME, '100: Entering review_section_numbering ');
1402: FND_LOG.STRING(G_PROC_LEVEL,
1403: G_PKG_NAME, '100: Parameters ');
1404: FND_LOG.STRING(G_PROC_LEVEL,
1405: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1406: FND_LOG.STRING(G_PROC_LEVEL,
1407: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1408: FND_LOG.STRING(G_PROC_LEVEL,

Line 1406: FND_LOG.STRING(G_PROC_LEVEL,

1402: FND_LOG.STRING(G_PROC_LEVEL,
1403: G_PKG_NAME, '100: Parameters ');
1404: FND_LOG.STRING(G_PROC_LEVEL,
1405: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1406: FND_LOG.STRING(G_PROC_LEVEL,
1407: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1408: FND_LOG.STRING(G_PROC_LEVEL,
1409: G_PKG_NAME, '100: p_level : '||p_level);
1410: FND_LOG.STRING(G_PROC_LEVEL,

Line 1408: FND_LOG.STRING(G_PROC_LEVEL,

1404: FND_LOG.STRING(G_PROC_LEVEL,
1405: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1406: FND_LOG.STRING(G_PROC_LEVEL,
1407: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1408: FND_LOG.STRING(G_PROC_LEVEL,
1409: G_PKG_NAME, '100: p_level : '||p_level);
1410: FND_LOG.STRING(G_PROC_LEVEL,
1411: G_PKG_NAME, '100: p_parent_label : '||p_parent_label);
1412: FND_LOG.STRING(G_PROC_LEVEL,

Line 1410: FND_LOG.STRING(G_PROC_LEVEL,

1406: FND_LOG.STRING(G_PROC_LEVEL,
1407: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1408: FND_LOG.STRING(G_PROC_LEVEL,
1409: G_PKG_NAME, '100: p_level : '||p_level);
1410: FND_LOG.STRING(G_PROC_LEVEL,
1411: G_PKG_NAME, '100: p_parent_label : '||p_parent_label);
1412: FND_LOG.STRING(G_PROC_LEVEL,
1413: G_PKG_NAME, '100: review_upld_terms_id : '||p_review_upld_terms_id);
1414: END IF;

Line 1412: FND_LOG.STRING(G_PROC_LEVEL,

1408: FND_LOG.STRING(G_PROC_LEVEL,
1409: G_PKG_NAME, '100: p_level : '||p_level);
1410: FND_LOG.STRING(G_PROC_LEVEL,
1411: G_PKG_NAME, '100: p_parent_label : '||p_parent_label);
1412: FND_LOG.STRING(G_PROC_LEVEL,
1413: G_PKG_NAME, '100: review_upld_terms_id : '||p_review_upld_terms_id);
1414: END IF;
1415:
1416: select decode(p_level,1,NULL,2,l_lvl1_concat_yn,3,l_lvl2_concat_yn,4,l_lvl3_concat_yn,5,l_lvl4_concat_yn,'N'),

Line 1421: FND_LOG.STRING(G_PROC_LEVEL,

1417: 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)
1418: into l_concat_yn ,l_end_char from dual;
1419:
1420: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1421: FND_LOG.STRING(G_PROC_LEVEL,
1422: G_PKG_NAME, '110: l_concat_yn : '||l_concat_yn );
1423: FND_LOG.STRING(G_PROC_LEVEL,
1424: G_PKG_NAME, '110: l_end_char : '||l_end_char );
1425: END IF;

Line 1423: FND_LOG.STRING(G_PROC_LEVEL,

1419:
1420: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1421: FND_LOG.STRING(G_PROC_LEVEL,
1422: G_PKG_NAME, '110: l_concat_yn : '||l_concat_yn );
1423: FND_LOG.STRING(G_PROC_LEVEL,
1424: G_PKG_NAME, '110: l_end_char : '||l_end_char );
1425: END IF;
1426:
1427: FOR cr in l_get_child_csr LOOP

Line 1443: FND_LOG.STRING(G_PROC_LEVEL,

1439: l_review_tbl(i).type := cr.type;
1440: l_review_tbl(i).label := l_label;
1441:
1442: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1443: FND_LOG.STRING(G_PROC_LEVEL,
1444: G_PKG_NAME, '120: i : '||i);
1445: FND_LOG.STRING(G_PROC_LEVEL,
1446: G_PKG_NAME, '120: l_review_tbl(i).id : '||l_review_tbl(i).review_upld_terms_id);
1447: FND_LOG.STRING(G_PROC_LEVEL,

Line 1445: FND_LOG.STRING(G_PROC_LEVEL,

1441:
1442: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1443: FND_LOG.STRING(G_PROC_LEVEL,
1444: G_PKG_NAME, '120: i : '||i);
1445: FND_LOG.STRING(G_PROC_LEVEL,
1446: G_PKG_NAME, '120: l_review_tbl(i).id : '||l_review_tbl(i).review_upld_terms_id);
1447: FND_LOG.STRING(G_PROC_LEVEL,
1448: G_PKG_NAME, '120: l_review_tbl(i).type : '||l_review_tbl(i).type);
1449: FND_LOG.STRING(G_PROC_LEVEL,

Line 1447: FND_LOG.STRING(G_PROC_LEVEL,

1443: FND_LOG.STRING(G_PROC_LEVEL,
1444: G_PKG_NAME, '120: i : '||i);
1445: FND_LOG.STRING(G_PROC_LEVEL,
1446: G_PKG_NAME, '120: l_review_tbl(i).id : '||l_review_tbl(i).review_upld_terms_id);
1447: FND_LOG.STRING(G_PROC_LEVEL,
1448: G_PKG_NAME, '120: l_review_tbl(i).type : '||l_review_tbl(i).type);
1449: FND_LOG.STRING(G_PROC_LEVEL,
1450: G_PKG_NAME, '120: l_review_tbl(i).label : '||l_review_tbl(i).label);
1451: END IF;

Line 1449: FND_LOG.STRING(G_PROC_LEVEL,

1445: FND_LOG.STRING(G_PROC_LEVEL,
1446: G_PKG_NAME, '120: l_review_tbl(i).id : '||l_review_tbl(i).review_upld_terms_id);
1447: FND_LOG.STRING(G_PROC_LEVEL,
1448: G_PKG_NAME, '120: l_review_tbl(i).type : '||l_review_tbl(i).type);
1449: FND_LOG.STRING(G_PROC_LEVEL,
1450: G_PKG_NAME, '120: l_review_tbl(i).label : '||l_review_tbl(i).label);
1451: END IF;
1452:
1453: IF cr.type='SECTION' THEN

Line 1477: FND_LOG.STRING(G_PROC_LEVEL,

1473: END IF;
1474: END LOOP;
1475:
1476: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1477: FND_LOG.STRING(G_PROC_LEVEL,
1478: G_PKG_NAME, '300: Leaving review_section_numbering ' );
1479: END IF;
1480:
1481: EXCEPTION

Line 1486: FND_LOG.STRING(G_EXCP_LEVEL,

1482:
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484:
1485: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1486: FND_LOG.STRING(G_EXCP_LEVEL,
1487: G_PKG_NAME, '400: Leaving review_section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1488: END IF;
1489:
1490: raise;

Line 1495: FND_LOG.STRING(G_EXCP_LEVEL,

1491:
1492: WHEN OTHERS THEN
1493:
1494: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1495: FND_LOG.STRING(G_EXCP_LEVEL,
1496: G_PKG_NAME, '500: Leaving review_section_numbering because of EXCEPTION: '||sqlerrm);
1497: END IF;
1498:
1499: raise;

Line 1569: FND_LOG.STRING(G_PROC_LEVEL,

1565:
1566: BEGIN
1567:
1568: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1569: FND_LOG.STRING(G_PROC_LEVEL,
1570: G_PKG_NAME, '100: Entered apply_num_scheme_4_Review');
1571: FND_LOG.STRING(G_PROC_LEVEL,
1572: G_PKG_NAME, '100: Parameter List ');
1573: FND_LOG.STRING(G_PROC_LEVEL,

Line 1571: FND_LOG.STRING(G_PROC_LEVEL,

1567:
1568: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1569: FND_LOG.STRING(G_PROC_LEVEL,
1570: G_PKG_NAME, '100: Entered apply_num_scheme_4_Review');
1571: FND_LOG.STRING(G_PROC_LEVEL,
1572: G_PKG_NAME, '100: Parameter List ');
1573: FND_LOG.STRING(G_PROC_LEVEL,
1574: G_PKG_NAME, '100: p_api_version : '||p_api_version);
1575: FND_LOG.STRING(G_PROC_LEVEL,

Line 1573: FND_LOG.STRING(G_PROC_LEVEL,

1569: FND_LOG.STRING(G_PROC_LEVEL,
1570: G_PKG_NAME, '100: Entered apply_num_scheme_4_Review');
1571: FND_LOG.STRING(G_PROC_LEVEL,
1572: G_PKG_NAME, '100: Parameter List ');
1573: FND_LOG.STRING(G_PROC_LEVEL,
1574: G_PKG_NAME, '100: p_api_version : '||p_api_version);
1575: FND_LOG.STRING(G_PROC_LEVEL,
1576: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list);
1577: FND_LOG.STRING(G_PROC_LEVEL,

Line 1575: FND_LOG.STRING(G_PROC_LEVEL,

1571: FND_LOG.STRING(G_PROC_LEVEL,
1572: G_PKG_NAME, '100: Parameter List ');
1573: FND_LOG.STRING(G_PROC_LEVEL,
1574: G_PKG_NAME, '100: p_api_version : '||p_api_version);
1575: FND_LOG.STRING(G_PROC_LEVEL,
1576: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list);
1577: FND_LOG.STRING(G_PROC_LEVEL,
1578: G_PKG_NAME, '100: p_commit : '||p_commit);
1579: FND_LOG.STRING(G_PROC_LEVEL,

Line 1577: FND_LOG.STRING(G_PROC_LEVEL,

1573: FND_LOG.STRING(G_PROC_LEVEL,
1574: G_PKG_NAME, '100: p_api_version : '||p_api_version);
1575: FND_LOG.STRING(G_PROC_LEVEL,
1576: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list);
1577: FND_LOG.STRING(G_PROC_LEVEL,
1578: G_PKG_NAME, '100: p_commit : '||p_commit);
1579: FND_LOG.STRING(G_PROC_LEVEL,
1580: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit);
1581: FND_LOG.STRING(G_PROC_LEVEL,

Line 1579: FND_LOG.STRING(G_PROC_LEVEL,

1575: FND_LOG.STRING(G_PROC_LEVEL,
1576: G_PKG_NAME, '100: p_init_msg_list : '||p_init_msg_list);
1577: FND_LOG.STRING(G_PROC_LEVEL,
1578: G_PKG_NAME, '100: p_commit : '||p_commit);
1579: FND_LOG.STRING(G_PROC_LEVEL,
1580: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit);
1581: FND_LOG.STRING(G_PROC_LEVEL,
1582: G_PKG_NAME, '100: p_validation_string : '||p_validation_string);
1583: FND_LOG.STRING(G_PROC_LEVEL,

Line 1581: FND_LOG.STRING(G_PROC_LEVEL,

1577: FND_LOG.STRING(G_PROC_LEVEL,
1578: G_PKG_NAME, '100: p_commit : '||p_commit);
1579: FND_LOG.STRING(G_PROC_LEVEL,
1580: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit);
1581: FND_LOG.STRING(G_PROC_LEVEL,
1582: G_PKG_NAME, '100: p_validation_string : '||p_validation_string);
1583: FND_LOG.STRING(G_PROC_LEVEL,
1584: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1585: FND_LOG.STRING(G_PROC_LEVEL,

Line 1583: FND_LOG.STRING(G_PROC_LEVEL,

1579: FND_LOG.STRING(G_PROC_LEVEL,
1580: G_PKG_NAME, '100: p_validate_commit : '||p_validate_commit);
1581: FND_LOG.STRING(G_PROC_LEVEL,
1582: G_PKG_NAME, '100: p_validation_string : '||p_validation_string);
1583: FND_LOG.STRING(G_PROC_LEVEL,
1584: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1585: FND_LOG.STRING(G_PROC_LEVEL,
1586: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1587: FND_LOG.STRING(G_PROC_LEVEL,

Line 1585: FND_LOG.STRING(G_PROC_LEVEL,

1581: FND_LOG.STRING(G_PROC_LEVEL,
1582: G_PKG_NAME, '100: p_validation_string : '||p_validation_string);
1583: FND_LOG.STRING(G_PROC_LEVEL,
1584: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1585: FND_LOG.STRING(G_PROC_LEVEL,
1586: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1587: FND_LOG.STRING(G_PROC_LEVEL,
1588: G_PKG_NAME, '100: p_num_scheme_id : '||p_num_scheme_id);
1589: END IF;

Line 1587: FND_LOG.STRING(G_PROC_LEVEL,

1583: FND_LOG.STRING(G_PROC_LEVEL,
1584: G_PKG_NAME, '100: p_doc_type : '||p_doc_type);
1585: FND_LOG.STRING(G_PROC_LEVEL,
1586: G_PKG_NAME, '100: p_doc_id : '||p_doc_id);
1587: FND_LOG.STRING(G_PROC_LEVEL,
1588: G_PKG_NAME, '100: p_num_scheme_id : '||p_num_scheme_id);
1589: END IF;
1590:
1591: -- Initialize the global Structure Table

Line 1618: FND_LOG.STRING(G_PROC_LEVEL,

1614: x_msg_data => x_msg_data,
1615: x_msg_count => x_msg_count) ) THEN
1616:
1617: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1618: FND_LOG.STRING(G_PROC_LEVEL,
1619: G_PKG_NAME, '110: Issue with document header Record.Cannot commit' );
1620: END IF;
1621: RAISE FND_API.G_EXC_ERROR ;
1622: END IF;

Line 1637: FND_LOG.STRING(G_PROC_LEVEL,

1633:
1634: l_no_of_levels := l_dtl_count;
1635:
1636: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1637: FND_LOG.STRING(G_PROC_LEVEL,
1638: G_PKG_NAME, '110: Numbering Scheme Detail Count : '||l_dtl_count );
1639: END IF;
1640:
1641: UPDATE okc_review_upld_terms

Line 1658: FND_LOG.STRING(G_PROC_LEVEL,

1654: CLOSE l_get_num_scheme ;
1655:
1656:
1657: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1658: FND_LOG.STRING(G_PROC_LEVEL,
1659: G_PKG_NAME, '120: l_number_article_yn : '||l_number_article_yn );
1660: END IF;
1661:
1662: FOR CR in l_get_num_scheme_dtl LOOP

Line 1688: FND_LOG.STRING(G_PROC_LEVEL,

1684: END LOOP;
1685:
1686:
1687: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1688: FND_LOG.STRING(G_PROC_LEVEL,
1689: G_PKG_NAME, '130: Sequence Level 1 ');
1690: FND_LOG.STRING(G_PROC_LEVEL,
1691: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
1692: FND_LOG.STRING(G_PROC_LEVEL,

Line 1690: FND_LOG.STRING(G_PROC_LEVEL,

1686:
1687: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1688: FND_LOG.STRING(G_PROC_LEVEL,
1689: G_PKG_NAME, '130: Sequence Level 1 ');
1690: FND_LOG.STRING(G_PROC_LEVEL,
1691: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
1692: FND_LOG.STRING(G_PROC_LEVEL,
1693: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
1694: FND_LOG.STRING(G_PROC_LEVEL,

Line 1692: FND_LOG.STRING(G_PROC_LEVEL,

1688: FND_LOG.STRING(G_PROC_LEVEL,
1689: G_PKG_NAME, '130: Sequence Level 1 ');
1690: FND_LOG.STRING(G_PROC_LEVEL,
1691: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
1692: FND_LOG.STRING(G_PROC_LEVEL,
1693: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
1694: FND_LOG.STRING(G_PROC_LEVEL,
1695: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
1696: FND_LOG.STRING(G_PROC_LEVEL,

Line 1694: FND_LOG.STRING(G_PROC_LEVEL,

1690: FND_LOG.STRING(G_PROC_LEVEL,
1691: G_PKG_NAME, '130: l_lvl1_seq_code : '||l_lvl1_seq_code);
1692: FND_LOG.STRING(G_PROC_LEVEL,
1693: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
1694: FND_LOG.STRING(G_PROC_LEVEL,
1695: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
1696: FND_LOG.STRING(G_PROC_LEVEL,
1697: G_PKG_NAME, '130: Sequence Level 2 ');
1698: FND_LOG.STRING(G_PROC_LEVEL,

Line 1696: FND_LOG.STRING(G_PROC_LEVEL,

1692: FND_LOG.STRING(G_PROC_LEVEL,
1693: G_PKG_NAME, '130: l_lvl1_concat_yn : '||l_lvl1_concat_yn);
1694: FND_LOG.STRING(G_PROC_LEVEL,
1695: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
1696: FND_LOG.STRING(G_PROC_LEVEL,
1697: G_PKG_NAME, '130: Sequence Level 2 ');
1698: FND_LOG.STRING(G_PROC_LEVEL,
1699: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
1700: FND_LOG.STRING(G_PROC_LEVEL,

Line 1698: FND_LOG.STRING(G_PROC_LEVEL,

1694: FND_LOG.STRING(G_PROC_LEVEL,
1695: G_PKG_NAME, '130: l_lvl1_end_char : '||l_lvl1_end_char);
1696: FND_LOG.STRING(G_PROC_LEVEL,
1697: G_PKG_NAME, '130: Sequence Level 2 ');
1698: FND_LOG.STRING(G_PROC_LEVEL,
1699: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
1700: FND_LOG.STRING(G_PROC_LEVEL,
1701: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
1702: FND_LOG.STRING(G_PROC_LEVEL,

Line 1700: FND_LOG.STRING(G_PROC_LEVEL,

1696: FND_LOG.STRING(G_PROC_LEVEL,
1697: G_PKG_NAME, '130: Sequence Level 2 ');
1698: FND_LOG.STRING(G_PROC_LEVEL,
1699: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
1700: FND_LOG.STRING(G_PROC_LEVEL,
1701: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
1702: FND_LOG.STRING(G_PROC_LEVEL,
1703: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
1704: FND_LOG.STRING(G_PROC_LEVEL,

Line 1702: FND_LOG.STRING(G_PROC_LEVEL,

1698: FND_LOG.STRING(G_PROC_LEVEL,
1699: G_PKG_NAME, '130: l_lvl2_seq_code : '||l_lvl2_seq_code);
1700: FND_LOG.STRING(G_PROC_LEVEL,
1701: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
1702: FND_LOG.STRING(G_PROC_LEVEL,
1703: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
1704: FND_LOG.STRING(G_PROC_LEVEL,
1705: G_PKG_NAME, '130: Sequence Level 3 ');
1706: FND_LOG.STRING(G_PROC_LEVEL,

Line 1704: FND_LOG.STRING(G_PROC_LEVEL,

1700: FND_LOG.STRING(G_PROC_LEVEL,
1701: G_PKG_NAME, '130: l_lvl2_concat_yn : '||l_lvl2_concat_yn);
1702: FND_LOG.STRING(G_PROC_LEVEL,
1703: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
1704: FND_LOG.STRING(G_PROC_LEVEL,
1705: G_PKG_NAME, '130: Sequence Level 3 ');
1706: FND_LOG.STRING(G_PROC_LEVEL,
1707: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
1708: FND_LOG.STRING(G_PROC_LEVEL,

Line 1706: FND_LOG.STRING(G_PROC_LEVEL,

1702: FND_LOG.STRING(G_PROC_LEVEL,
1703: G_PKG_NAME, '130: l_lvl2_end_char : '||l_lvl2_end_char);
1704: FND_LOG.STRING(G_PROC_LEVEL,
1705: G_PKG_NAME, '130: Sequence Level 3 ');
1706: FND_LOG.STRING(G_PROC_LEVEL,
1707: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
1708: FND_LOG.STRING(G_PROC_LEVEL,
1709: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
1710: FND_LOG.STRING(G_PROC_LEVEL,

Line 1708: FND_LOG.STRING(G_PROC_LEVEL,

1704: FND_LOG.STRING(G_PROC_LEVEL,
1705: G_PKG_NAME, '130: Sequence Level 3 ');
1706: FND_LOG.STRING(G_PROC_LEVEL,
1707: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
1708: FND_LOG.STRING(G_PROC_LEVEL,
1709: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
1710: FND_LOG.STRING(G_PROC_LEVEL,
1711: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
1712: FND_LOG.STRING(G_PROC_LEVEL,

Line 1710: FND_LOG.STRING(G_PROC_LEVEL,

1706: FND_LOG.STRING(G_PROC_LEVEL,
1707: G_PKG_NAME, '130: l_lvl3_seq_code : '||l_lvl3_seq_code);
1708: FND_LOG.STRING(G_PROC_LEVEL,
1709: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
1710: FND_LOG.STRING(G_PROC_LEVEL,
1711: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
1712: FND_LOG.STRING(G_PROC_LEVEL,
1713: G_PKG_NAME, '130: Sequence Level 4 ');
1714: FND_LOG.STRING(G_PROC_LEVEL,

Line 1712: FND_LOG.STRING(G_PROC_LEVEL,

1708: FND_LOG.STRING(G_PROC_LEVEL,
1709: G_PKG_NAME, '130: l_lvl3_concat_yn : '||l_lvl3_concat_yn);
1710: FND_LOG.STRING(G_PROC_LEVEL,
1711: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
1712: FND_LOG.STRING(G_PROC_LEVEL,
1713: G_PKG_NAME, '130: Sequence Level 4 ');
1714: FND_LOG.STRING(G_PROC_LEVEL,
1715: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
1716: FND_LOG.STRING(G_PROC_LEVEL,

Line 1714: FND_LOG.STRING(G_PROC_LEVEL,

1710: FND_LOG.STRING(G_PROC_LEVEL,
1711: G_PKG_NAME, '130: l_lvl3_end_char : '||l_lvl3_end_char);
1712: FND_LOG.STRING(G_PROC_LEVEL,
1713: G_PKG_NAME, '130: Sequence Level 4 ');
1714: FND_LOG.STRING(G_PROC_LEVEL,
1715: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
1716: FND_LOG.STRING(G_PROC_LEVEL,
1717: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
1718: FND_LOG.STRING(G_PROC_LEVEL,

Line 1716: FND_LOG.STRING(G_PROC_LEVEL,

1712: FND_LOG.STRING(G_PROC_LEVEL,
1713: G_PKG_NAME, '130: Sequence Level 4 ');
1714: FND_LOG.STRING(G_PROC_LEVEL,
1715: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
1716: FND_LOG.STRING(G_PROC_LEVEL,
1717: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
1718: FND_LOG.STRING(G_PROC_LEVEL,
1719: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
1720: FND_LOG.STRING(G_PROC_LEVEL,

Line 1718: FND_LOG.STRING(G_PROC_LEVEL,

1714: FND_LOG.STRING(G_PROC_LEVEL,
1715: G_PKG_NAME, '130: l_lvl4_seq_code : '||l_lvl4_seq_code);
1716: FND_LOG.STRING(G_PROC_LEVEL,
1717: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
1718: FND_LOG.STRING(G_PROC_LEVEL,
1719: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
1720: FND_LOG.STRING(G_PROC_LEVEL,
1721: G_PKG_NAME, '130: Sequence Level 5 ');
1722: FND_LOG.STRING(G_PROC_LEVEL,

Line 1720: FND_LOG.STRING(G_PROC_LEVEL,

1716: FND_LOG.STRING(G_PROC_LEVEL,
1717: G_PKG_NAME, '130: l_lvl4_concat_yn : '||l_lvl4_concat_yn);
1718: FND_LOG.STRING(G_PROC_LEVEL,
1719: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
1720: FND_LOG.STRING(G_PROC_LEVEL,
1721: G_PKG_NAME, '130: Sequence Level 5 ');
1722: FND_LOG.STRING(G_PROC_LEVEL,
1723: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
1724: FND_LOG.STRING(G_PROC_LEVEL,

Line 1722: FND_LOG.STRING(G_PROC_LEVEL,

1718: FND_LOG.STRING(G_PROC_LEVEL,
1719: G_PKG_NAME, '130: l_lvl4_end_char : '||l_lvl4_end_char);
1720: FND_LOG.STRING(G_PROC_LEVEL,
1721: G_PKG_NAME, '130: Sequence Level 5 ');
1722: FND_LOG.STRING(G_PROC_LEVEL,
1723: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
1724: FND_LOG.STRING(G_PROC_LEVEL,
1725: G_PKG_NAME, '130: l_lvl5_concat_yn : '||l_lvl5_concat_yn);
1726: FND_LOG.STRING(G_PROC_LEVEL,

Line 1724: FND_LOG.STRING(G_PROC_LEVEL,

1720: FND_LOG.STRING(G_PROC_LEVEL,
1721: G_PKG_NAME, '130: Sequence Level 5 ');
1722: FND_LOG.STRING(G_PROC_LEVEL,
1723: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
1724: FND_LOG.STRING(G_PROC_LEVEL,
1725: G_PKG_NAME, '130: l_lvl5_concat_yn : '||l_lvl5_concat_yn);
1726: FND_LOG.STRING(G_PROC_LEVEL,
1727: G_PKG_NAME, '130: l_lvl5_end_char : '||l_lvl5_end_char);
1728: END IF;

Line 1726: FND_LOG.STRING(G_PROC_LEVEL,

1722: FND_LOG.STRING(G_PROC_LEVEL,
1723: G_PKG_NAME, '130: l_lvl5_seq_code : '||l_lvl5_seq_code);
1724: FND_LOG.STRING(G_PROC_LEVEL,
1725: G_PKG_NAME, '130: l_lvl5_concat_yn : '||l_lvl5_concat_yn);
1726: FND_LOG.STRING(G_PROC_LEVEL,
1727: G_PKG_NAME, '130: l_lvl5_end_char : '||l_lvl5_end_char);
1728: END IF;
1729:
1730: l_lvl1_sequence :=0;

Line 1742: FND_LOG.STRING(G_PROC_LEVEL,

1738: l_number := get_numbering_seq(p_level => 1);
1739:
1740:
1741: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1742: FND_LOG.STRING(G_PROC_LEVEL,
1743: G_PKG_NAME, '140: l_number : '||l_number );
1744: END IF;
1745:
1746: l_label := l_number||l_lvl1_end_char;

Line 1750: FND_LOG.STRING(G_PROC_LEVEL,

1746: l_label := l_number||l_lvl1_end_char;
1747:
1748:
1749: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1750: FND_LOG.STRING(G_PROC_LEVEL,
1751: G_PKG_NAME, '150: l_label : '||l_label );
1752: END IF;
1753:
1754: i := l_review_tbl.count+1;

Line 1773: FND_LOG.STRING(G_PROC_LEVEL,

1769:
1770: END LOOP;
1771:
1772: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1773: FND_LOG.STRING(G_PROC_LEVEL,
1774: G_PKG_NAME, '160: Count of l_review_tbl : '||l_review_tbl.count );
1775: END IF;
1776:
1777:

Line 1782: FND_LOG.STRING(G_PROC_LEVEL,

1778: IF l_review_tbl.count > 0 THEN
1779: For k in l_review_tbl.FIRST..l_review_tbl.LAST LOOP
1780:
1781: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1782: FND_LOG.STRING(G_PROC_LEVEL,
1783: G_PKG_NAME, '170: Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row');
1784: FND_LOG.STRING(G_PROC_LEVEL,
1785: G_PKG_NAME, '170: l_review_tbl(k).id : '||l_review_tbl(k).review_upld_terms_id);
1786: FND_LOG.STRING(G_PROC_LEVEL,

Line 1784: FND_LOG.STRING(G_PROC_LEVEL,

1780:
1781: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1782: FND_LOG.STRING(G_PROC_LEVEL,
1783: G_PKG_NAME, '170: Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row');
1784: FND_LOG.STRING(G_PROC_LEVEL,
1785: G_PKG_NAME, '170: l_review_tbl(k).id : '||l_review_tbl(k).review_upld_terms_id);
1786: FND_LOG.STRING(G_PROC_LEVEL,
1787: G_PKG_NAME, '170: l_review_tbl(k).label : '||l_review_tbl(k).label);
1788: END IF;

Line 1786: FND_LOG.STRING(G_PROC_LEVEL,

1782: FND_LOG.STRING(G_PROC_LEVEL,
1783: G_PKG_NAME, '170: Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row');
1784: FND_LOG.STRING(G_PROC_LEVEL,
1785: G_PKG_NAME, '170: l_review_tbl(k).id : '||l_review_tbl(k).review_upld_terms_id);
1786: FND_LOG.STRING(G_PROC_LEVEL,
1787: G_PKG_NAME, '170: l_review_tbl(k).label : '||l_review_tbl(k).label);
1788: END IF;
1789:
1790: OKC_REVIEW_UPLD_TERMS_PVT.update_row(

Line 1797: FND_LOG.STRING(G_PROC_LEVEL,

1793: p_label => l_review_tbl(k).label,
1794: p_object_version_number => NULL);
1795:
1796: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1797: FND_LOG.STRING(G_PROC_LEVEL,
1798: G_PKG_NAME, '170: After Calling OKC_REVIEW_UPLD_TERMS_PVT.update_row x_return_status : '||x_return_status );
1799: END IF;
1800:
1801: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1819: FND_LOG.STRING(G_PROC_LEVEL,

1815: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1816:
1817:
1818: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
1819: FND_LOG.STRING(G_PROC_LEVEL,
1820: G_PKG_NAME, '2000: Leaving apply_num_scheme_4_Review' );
1821: END IF;
1822:
1823: EXCEPTION

Line 1827: FND_LOG.STRING(G_EXCP_LEVEL,

1823: EXCEPTION
1824: WHEN FND_API.G_EXC_ERROR THEN
1825:
1826: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1827: FND_LOG.STRING(G_EXCP_LEVEL,
1828: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );
1829: END IF;
1830:
1831: ROLLBACK TO g_apply_num_scheme_4_Review;

Line 1838: FND_LOG.STRING(G_EXCP_LEVEL,

1834:
1835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1836:
1837: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1838: FND_LOG.STRING(G_EXCP_LEVEL,
1839: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );
1840: END IF;
1841:
1842: ROLLBACK TO g_apply_num_scheme_4_Review;

Line 1852: FND_LOG.STRING(G_EXCP_LEVEL,

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,
1853: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );
1854: END IF;
1855:
1856: ROLLBACK TO g_apply_num_scheme_4_Review;