539:
540: g_error_stmt := 'Debug - populate_horizontal_plan - 10';
541:
542: if g_other_text is null then
543: fnd_message.set_name('MSC', 'MSC_OTHER');
544: g_other_text := fnd_message.get;
545: fnd_message.set_name('MSC', 'MSC_TOTAL');
546: g_total_text := fnd_message.get;
547: end if;
540: g_error_stmt := 'Debug - populate_horizontal_plan - 10';
541:
542: if g_other_text is null then
543: fnd_message.set_name('MSC', 'MSC_OTHER');
544: g_other_text := fnd_message.get;
545: fnd_message.set_name('MSC', 'MSC_TOTAL');
546: g_total_text := fnd_message.get;
547: end if;
548:
541:
542: if g_other_text is null then
543: fnd_message.set_name('MSC', 'MSC_OTHER');
544: g_other_text := fnd_message.get;
545: fnd_message.set_name('MSC', 'MSC_TOTAL');
546: g_total_text := fnd_message.get;
547: end if;
548:
549: OPEN plan_buckets;
542: if g_other_text is null then
543: fnd_message.set_name('MSC', 'MSC_OTHER');
544: g_other_text := fnd_message.get;
545: fnd_message.set_name('MSC', 'MSC_TOTAL');
546: g_total_text := fnd_message.get;
547: end if;
548:
549: OPEN plan_buckets;
550: FETCH plan_buckets into g_org_id, g_inst_id;