585: -- Update the l_debrief_rec with default dff values for enabled dff.
586: BEGIN
587: fnd_dflex.get_flexfield('CSF', 'CSF_DEBRIEF_HEADERS', flexfield, flexinfo);
588:
589: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
590: fnd_log.string(fnd_log.level_statement,
591: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
592: '=== FLEXFIELD INFO ===');
593: fnd_log.string(fnd_log.level_statement,
586: BEGIN
587: fnd_dflex.get_flexfield('CSF', 'CSF_DEBRIEF_HEADERS', flexfield, flexinfo);
588:
589: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
590: fnd_log.string(fnd_log.level_statement,
591: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
592: '=== FLEXFIELD INFO ===');
593: fnd_log.string(fnd_log.level_statement,
594: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
589: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
590: fnd_log.string(fnd_log.level_statement,
591: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
592: '=== FLEXFIELD INFO ===');
593: fnd_log.string(fnd_log.level_statement,
594: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
595: 'title=' || flexinfo.title);
596: fnd_log.string(fnd_log.level_statement,
597: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
592: '=== FLEXFIELD INFO ===');
593: fnd_log.string(fnd_log.level_statement,
594: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
595: 'title=' || flexinfo.title);
596: fnd_log.string(fnd_log.level_statement,
597: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
598: 'table=' || flexinfo.table_name);
599: fnd_log.string(fnd_log.level_statement,
600: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
595: 'title=' || flexinfo.title);
596: fnd_log.string(fnd_log.level_statement,
597: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
598: 'table=' || flexinfo.table_name);
599: fnd_log.string(fnd_log.level_statement,
600: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
601: 'descr=' || flexinfo.description);
602: fnd_log.string(fnd_log.level_statement,
603: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
598: 'table=' || flexinfo.table_name);
599: fnd_log.string(fnd_log.level_statement,
600: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
601: 'descr=' || flexinfo.description);
602: fnd_log.string(fnd_log.level_statement,
603: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
604: '=== ENABLED CONTEXT INFO ===');
605: end if;
606: /*
620: FOR i IN 1 .. contexts.ncontexts
621: LOOP
622: IF(contexts.is_enabled(i)) THEN
623: --dbms_output.put_line(contexts.context_code(i) || ' - ' || contexts.context_description(i));
624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
625: fnd_log.string(fnd_log.level_statement,
626: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
627: contexts.context_code(i) || ' - ' || contexts.context_description(i));
628: end if;
621: LOOP
622: IF(contexts.is_enabled(i)) THEN
623: --dbms_output.put_line(contexts.context_code(i) || ' - ' || contexts.context_description(i));
624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
625: fnd_log.string(fnd_log.level_statement,
626: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
627: contexts.context_code(i) || ' - ' || contexts.context_description(i));
628: end if;
629: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(i)), segments, true);
630: FOR j IN 1 .. segments.nsegments
631: LOOP
632: --dbms_output.put_line(segments.segment_name(j) || ' - ' || segments.application_column_name(j) || ' - ' || segments.description(j)
633: --|| ' - ' || segments.sequence(j) || ' - ' || segments.default_type(j) || ' - ' || segments.default_value(j));
634: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
635: fnd_log.string(fnd_log.level_statement,
636: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
637: segments.segment_name(j) || ' - ' || segments.application_column_name(j) || ' - ' || segments.description(j)
638: || ' - ' || segments.sequence(j) || ' - ' || segments.default_type(j) || ' - ' || segments.default_value(j));
631: LOOP
632: --dbms_output.put_line(segments.segment_name(j) || ' - ' || segments.application_column_name(j) || ' - ' || segments.description(j)
633: --|| ' - ' || segments.sequence(j) || ' - ' || segments.default_type(j) || ' - ' || segments.default_value(j));
634: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
635: fnd_log.string(fnd_log.level_statement,
636: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
637: segments.segment_name(j) || ' - ' || segments.application_column_name(j) || ' - ' || segments.description(j)
638: || ' - ' || segments.sequence(j) || ' - ' || segments.default_type(j) || ' - ' || segments.default_value(j));
639: end if;
657: WHEN 'ATTRIBUTE15' THEN l_debrief_rec.ATTRIBUTE15 := segments.default_value(j);
658: ELSE
659: BEGIN
660: --dbms_output.put_line('It should not come here. segments.application_column_name(j) = ' || segments.application_column_name(j));
661: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
662: fnd_log.string(fnd_log.level_statement,
663: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
664: 'It should not come here. segments.application_column_name(j) = ' || segments.application_column_name(j));
665: end if;
658: ELSE
659: BEGIN
660: --dbms_output.put_line('It should not come here. segments.application_column_name(j) = ' || segments.application_column_name(j));
661: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
662: fnd_log.string(fnd_log.level_statement,
663: 'csf.plsql.CSF_DEBRIEF_PUB.Create_Debrief_With_Dff_Vals',
664: 'It should not come here. segments.application_column_name(j) = ' || segments.application_column_name(j));
665: end if;
666: END;