493: end if;
494: end if;
495: else
496: close c_templates;
497: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
498: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_base_template_short_name);
499: fnd_message.raise_error;
500: end if;
501: else
494: end if;
495: else
496: close c_templates;
497: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
498: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_base_template_short_name);
499: fnd_message.raise_error;
500: end if;
501: else
502: close c_templates;
495: else
496: close c_templates;
497: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
498: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_base_template_short_name);
499: fnd_message.raise_error;
500: end if;
501: else
502: close c_templates;
503: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
499: fnd_message.raise_error;
500: end if;
501: else
502: close c_templates;
503: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
504: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_parent_template_short_name);
505: fnd_message.raise_error;
506: end if;
507: hr_general.g_data_migrator_mode := l_data_migrator_mode;
500: end if;
501: else
502: close c_templates;
503: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
504: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_parent_template_short_name);
505: fnd_message.raise_error;
506: end if;
507: hr_general.g_data_migrator_mode := l_data_migrator_mode;
508: END;
501: else
502: close c_templates;
503: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
504: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_parent_template_short_name);
505: fnd_message.raise_error;
506: end if;
507: hr_general.g_data_migrator_mode := l_data_migrator_mode;
508: END;
509: --