359: --
360: end if;
361: else
362: close c_att_txn_category;
363: fnd_message.set_name(8302,'PQH_INVALID_TXN_CAT_ATTR');
364: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
365: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
366: fnd_message.raise_error;
367: end if;
360: end if;
361: else
362: close c_att_txn_category;
363: fnd_message.set_name(8302,'PQH_INVALID_TXN_CAT_ATTR');
364: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
365: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
366: fnd_message.raise_error;
367: end if;
368: else
361: else
362: close c_att_txn_category;
363: fnd_message.set_name(8302,'PQH_INVALID_TXN_CAT_ATTR');
364: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
365: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
366: fnd_message.raise_error;
367: end if;
368: else
369: close c_templates;
362: close c_att_txn_category;
363: fnd_message.set_name(8302,'PQH_INVALID_TXN_CAT_ATTR');
364: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
365: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
366: fnd_message.raise_error;
367: end if;
368: else
369: close c_templates;
370: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
366: fnd_message.raise_error;
367: end if;
368: else
369: close c_templates;
370: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
371: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
372: fnd_message.raise_error;
373: end if;
374: else
367: end if;
368: else
369: close c_templates;
370: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
371: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
372: fnd_message.raise_error;
373: end if;
374: else
375: close c_attributes;
368: else
369: close c_templates;
370: fnd_message.set_name(8302,'PQH_INVALID_TEMPLATE');
371: fnd_message.set_token('TEMPLATE_SHORT_NAME',p_template_short_name);
372: fnd_message.raise_error;
373: end if;
374: else
375: close c_attributes;
376: fnd_message.set_name(8302,'PQH_INVALID_ATTRIBUTE');
372: fnd_message.raise_error;
373: end if;
374: else
375: close c_attributes;
376: fnd_message.set_name(8302,'PQH_INVALID_ATTRIBUTE');
377: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
378: fnd_message.raise_error;
379: end if;
380: hr_general.g_data_migrator_mode := l_data_migrator_mode;
373: end if;
374: else
375: close c_attributes;
376: fnd_message.set_name(8302,'PQH_INVALID_ATTRIBUTE');
377: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
378: fnd_message.raise_error;
379: end if;
380: hr_general.g_data_migrator_mode := l_data_migrator_mode;
381: END;
374: else
375: close c_attributes;
376: fnd_message.set_name(8302,'PQH_INVALID_ATTRIBUTE');
377: fnd_message.set_token('ATTRIBUTE_COLUMN_NAME',p_att_column_name);
378: fnd_message.raise_error;
379: end if;
380: hr_general.g_data_migrator_mode := l_data_migrator_mode;
381: END;
382: --