520: end if;
521: end if;
522: else
523: close c_templates;
524: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
525: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_base_template_short_name);
526: fnd_message.raise_error;
527: end if;
528: else
521: end if;
522: else
523: close c_templates;
524: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
525: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_base_template_short_name);
526: fnd_message.raise_error;
527: end if;
528: else
529: close c_templates;
522: else
523: close c_templates;
524: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
525: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_base_template_short_name);
526: fnd_message.raise_error;
527: end if;
528: else
529: close c_templates;
530: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
526: fnd_message.raise_error;
527: end if;
528: else
529: close c_templates;
530: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
531: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_parent_template_short_name);
532: fnd_message.raise_error;
533: end if;
534: hr_general.g_data_migrator_mode := l_data_migrator_mode;
527: end if;
528: else
529: close c_templates;
530: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
531: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_parent_template_short_name);
532: fnd_message.raise_error;
533: end if;
534: hr_general.g_data_migrator_mode := l_data_migrator_mode;
535: END;
528: else
529: close c_templates;
530: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
531: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_parent_template_short_name);
532: fnd_message.raise_error;
533: end if;
534: hr_general.g_data_migrator_mode := l_data_migrator_mode;
535: END;
536: --