554: g_attribute13 := NULL;
555: g_attribute14 := NULL;
556: g_attribute15 := NULL;
557:
558: IF FND_FLEX_DESCVAL.Validate_Desccols( 'QP', p_flex_name, 'D') THEN
559:
560:
561: -- Copying values into global variables
562: l_count := fnd_flex_descval.segment_count;
558: IF FND_FLEX_DESCVAL.Validate_Desccols( 'QP', p_flex_name, 'D') THEN
559:
560:
561: -- Copying values into global variables
562: l_count := fnd_flex_descval.segment_count;
563: qp_bulk_loader_pub.write_log( 'segment count='||to_char(l_count));
564:
565: FOR i IN 1..l_count LOOP
566:
563: qp_bulk_loader_pub.write_log( 'segment count='||to_char(l_count));
564:
565: FOR i IN 1..l_count LOOP
566:
567: qp_bulk_loader_pub.write_log( 'segment col nam='||FND_FLEX_DESCVAL.segment_column_name(i));
568: qp_bulk_loader_pub.write_log( 'segment ID='|| FND_FLEX_DESCVAL.segment_id(i));
569:
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
564:
565: FOR i IN 1..l_count LOOP
566:
567: qp_bulk_loader_pub.write_log( 'segment col nam='||FND_FLEX_DESCVAL.segment_column_name(i));
568: qp_bulk_loader_pub.write_log( 'segment ID='|| FND_FLEX_DESCVAL.segment_id(i));
569:
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
566:
567: qp_bulk_loader_pub.write_log( 'segment col nam='||FND_FLEX_DESCVAL.segment_column_name(i));
568: qp_bulk_loader_pub.write_log( 'segment ID='|| FND_FLEX_DESCVAL.segment_id(i));
569:
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
567: qp_bulk_loader_pub.write_log( 'segment col nam='||FND_FLEX_DESCVAL.segment_column_name(i));
568: qp_bulk_loader_pub.write_log( 'segment ID='|| FND_FLEX_DESCVAL.segment_id(i));
569:
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
568: qp_bulk_loader_pub.write_log( 'segment ID='|| FND_FLEX_DESCVAL.segment_id(i));
569:
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
569:
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
570: IF FND_FLEX_DESCVAL.segment_column_name(i) = g_context_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
571: g_context := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
572: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute1_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
573: g_attribute1 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
574: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute2_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
575: g_attribute2 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
576: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute3_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
577: g_attribute3 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
578: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute4_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
579: g_attribute4 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
580: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute5_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
581: g_attribute5 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
582: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute6_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
583: g_attribute6 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
584: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute7_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
585: g_attribute7 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
586: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute8_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
587: g_attribute8 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
588: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute9_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
589: g_attribute9 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
590: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute10_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
591: g_attribute10 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
592: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute11_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
600: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute15_name THEN
593: g_attribute11 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
600: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute15_name THEN
601: g_attribute15 := FND_FLEX_DESCVAL.segment_id(i);
594: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute12_name THEN
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
600: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute15_name THEN
601: g_attribute15 := FND_FLEX_DESCVAL.segment_id(i);
602: END IF;
595: g_attribute12 := FND_FLEX_DESCVAL.segment_id(i);
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
600: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute15_name THEN
601: g_attribute15 := FND_FLEX_DESCVAL.segment_id(i);
602: END IF;
603: END LOOP;
596: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute13_name THEN
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
600: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute15_name THEN
601: g_attribute15 := FND_FLEX_DESCVAL.segment_id(i);
602: END IF;
603: END LOOP;
604:
597: g_attribute13 := FND_FLEX_DESCVAL.segment_id(i);
598: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute14_name THEN
599: g_attribute14 := FND_FLEX_DESCVAL.segment_id(i);
600: ELSIF FND_FLEX_DESCVAL.segment_column_name(i) = g_attribute15_name THEN
601: g_attribute15 := FND_FLEX_DESCVAL.segment_id(i);
602: END IF;
603: END LOOP;
604:
605: RETURN TRUE;
607: ELSE
608: -- Prepare the encoded message by setting it on the message
609: -- dictionary stack. Then, add it to the API message list.
610:
611: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
612:
613: -- Derive return status.
614:
615: IF FND_FLEX_DESCVAL.value_error OR
611: FND_MESSAGE.Set_Encoded(FND_FLEX_DESCVAL.Encoded_Error_Message);
612:
613: -- Derive return status.
614:
615: IF FND_FLEX_DESCVAL.value_error OR
616: FND_FLEX_DESCVAL.unsupported_error
617: THEN
618: -- In case of an expected error return FALSE
619: qp_bulk_loader_pub.write_log( p_flex_name||'Desc Flex value/unsupport error');
612:
613: -- Derive return status.
614:
615: IF FND_FLEX_DESCVAL.value_error OR
616: FND_FLEX_DESCVAL.unsupported_error
617: THEN
618: -- In case of an expected error return FALSE
619: qp_bulk_loader_pub.write_log( p_flex_name||'Desc Flex value/unsupport error');
620: RETURN FALSE;
679: qp_bulk_loader_pub.write_log( 'Attribute1='||l_column_value);
680:
681: END IF;
682:
683: FND_FLEX_DESCVAL.Set_Column_Value
684: ( column_name => 'ATTRIBUTE1'
685: , column_value => l_column_value);
686:
687: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
694: qp_bulk_loader_pub.write_log( 'Attribute2='||l_column_value);
695:
696: END IF;
697:
698: FND_FLEX_DESCVAL.Set_Column_Value
699: ( column_name => 'ATTRIBUTE2'
700: , column_value => l_column_value);
701:
702: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
709: qp_bulk_loader_pub.write_log( 'Attribute3='||l_column_value);
710:
711: END IF;
712:
713: FND_FLEX_DESCVAL.Set_Column_Value
714: ( column_name => 'ATTRIBUTE3'
715: , column_value => l_column_value);
716:
717: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
724: qp_bulk_loader_pub.write_log( 'Attribute4='||l_column_value);
725:
726: END IF;
727:
728: FND_FLEX_DESCVAL.Set_Column_Value
729: ( column_name => 'ATTRIBUTE4'
730: , column_value => l_column_value);
731:
732: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
739: qp_bulk_loader_pub.write_log( 'Attribute5='||l_column_value);
740:
741: END IF;
742:
743: FND_FLEX_DESCVAL.Set_Column_Value
744: ( column_name => 'ATTRIBUTE5'
745: , column_value => l_column_value);
746:
747: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
754: qp_bulk_loader_pub.write_log( 'Attribute6='||l_column_value);
755:
756: END IF;
757:
758: FND_FLEX_DESCVAL.Set_Column_Value
759: ( column_name => 'ATTRIBUTE6'
760: , column_value => l_column_value);
761:
762: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
769: qp_bulk_loader_pub.write_log( 'Attribute7='||l_column_value);
770:
771: END IF;
772:
773: FND_FLEX_DESCVAL.Set_Column_Value
774: ( column_name => 'ATTRIBUTE7'
775: , column_value => l_column_value);
776:
777: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
784: qp_bulk_loader_pub.write_log( 'Attribute8='||l_column_value);
785:
786: END IF;
787:
788: FND_FLEX_DESCVAL.Set_Column_Value
789: ( column_name => 'ATTRIBUTE8'
790: , column_value => l_column_value);
791:
792: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
799: qp_bulk_loader_pub.write_log( 'Attribute9='||l_column_value);
800:
801: END IF;
802:
803: FND_FLEX_DESCVAL.Set_Column_Value
804: ( column_name => 'ATTRIBUTE9'
805: , column_value => l_column_value);
806:
807: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
814: qp_bulk_loader_pub.write_log( 'Attribute10='||l_column_value);
815:
816: END IF;
817:
818: FND_FLEX_DESCVAL.Set_Column_Value
819: ( column_name => 'ATTRIBUTE10'
820: , column_value => l_column_value);
821:
822: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
829: qp_bulk_loader_pub.write_log( 'Attribute11='||l_column_value);
830:
831: END IF;
832:
833: FND_FLEX_DESCVAL.Set_Column_Value
834: ( column_name => 'ATTRIBUTE11'
835: , column_value => l_column_value);
836:
837: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
844: qp_bulk_loader_pub.write_log( 'Attribute12='||l_column_value);
845:
846: END IF;
847:
848: FND_FLEX_DESCVAL.Set_Column_Value
849: ( column_name => 'ATTRIBUTE12'
850: , column_value => l_column_value);
851:
852: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
859: qp_bulk_loader_pub.write_log( 'Attribute13='||l_column_value);
860:
861: END IF;
862:
863: FND_FLEX_DESCVAL.Set_Column_Value
864: ( column_name => 'ATTRIBUTE13'
865: , column_value => l_column_value);
866:
867: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
874: qp_bulk_loader_pub.write_log( 'Attribute14='||l_column_value);
875:
876: END IF;
877:
878: FND_FLEX_DESCVAL.Set_Column_Value
879: ( column_name => 'ATTRIBUTE14'
880: , column_value => l_column_value);
881:
882: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
889: qp_bulk_loader_pub.write_log( 'Attribute15='||l_column_value);
890:
891: END IF;
892:
893: FND_FLEX_DESCVAL.Set_Column_Value
894: ( column_name => 'ATTRIBUTE15'
895: , column_value => l_column_value);
896:
897: IF p_context = FND_API.G_MISS_CHAR THEN
903: l_column_value := p_context;
904: qp_bulk_loader_pub.write_log( 'Context='||l_column_value);
905:
906: END IF;
907: FND_FLEX_DESCVAL.Set_Context_Value
908: ( context_value => l_column_value);
909:
910: IF NOT Desc_Flex(p_flex_name) THEN
911: RETURN FALSE;