eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on FND_MESSAGE

Line 171: FND_MESSAGE.SET_NAME('CZ', p_message_name);

167: p_token_value3 IN VARCHAR2 DEFAULT NULL) IS
168: l_msg_count NUMBER;
169: l_msg_data VARCHAR2(32000);
170: BEGIN
171: FND_MESSAGE.SET_NAME('CZ', p_message_name);
172: IF p_token_name1 IS NOT NULL THEN
173: FND_MESSAGE.SET_TOKEN(p_token_name1, p_token_value1);
174: END IF;
175: IF p_token_name2 IS NOT NULL THEN

Line 173: FND_MESSAGE.SET_TOKEN(p_token_name1, p_token_value1);

169: l_msg_data VARCHAR2(32000);
170: BEGIN
171: FND_MESSAGE.SET_NAME('CZ', p_message_name);
172: IF p_token_name1 IS NOT NULL THEN
173: FND_MESSAGE.SET_TOKEN(p_token_name1, p_token_value1);
174: END IF;
175: IF p_token_name2 IS NOT NULL THEN
176: FND_MESSAGE.SET_TOKEN(p_token_name2, p_token_value2);
177: END IF;

Line 176: FND_MESSAGE.SET_TOKEN(p_token_name2, p_token_value2);

172: IF p_token_name1 IS NOT NULL THEN
173: FND_MESSAGE.SET_TOKEN(p_token_name1, p_token_value1);
174: END IF;
175: IF p_token_name2 IS NOT NULL THEN
176: FND_MESSAGE.SET_TOKEN(p_token_name2, p_token_value2);
177: END IF;
178: IF p_token_name3 IS NOT NULL THEN
179: FND_MESSAGE.SET_TOKEN(p_token_name3, p_token_value3);
180: END IF;

Line 179: FND_MESSAGE.SET_TOKEN(p_token_name3, p_token_value3);

175: IF p_token_name2 IS NOT NULL THEN
176: FND_MESSAGE.SET_TOKEN(p_token_name2, p_token_value2);
177: END IF;
178: IF p_token_name3 IS NOT NULL THEN
179: FND_MESSAGE.SET_TOKEN(p_token_name3, p_token_value3);
180: END IF;
181: FND_MSG_PUB.ADD;
182: FND_MSG_PUB.count_and_get(p_count => l_msg_count,
183: p_data => l_msg_data);

Line 308: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_MODEL_IS_LOCKED');

304: IF (l_rp_model_tbl.COUNT > 0) THEN
305: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
306: LOOP
307: IF (l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
308: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_MODEL_IS_LOCKED');
309: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
310: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
311: FND_MSG_PUB.ADD;
312: x_return_status := FND_API.g_ret_sts_error;

Line 309: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));

305: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
306: LOOP
307: IF (l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
308: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_MODEL_IS_LOCKED');
309: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
310: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
311: FND_MSG_PUB.ADD;
312: x_return_status := FND_API.g_ret_sts_error;
313: END IF;

Line 310: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));

306: LOOP
307: IF (l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
308: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_MODEL_IS_LOCKED');
309: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
310: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
311: FND_MSG_PUB.ADD;
312: x_return_status := FND_API.g_ret_sts_error;
313: END IF;
314: END LOOP;

Line 334: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_TMPL_IS_LOCKED');

330: IF (l_uct_tbl.COUNT > 0) THEN
331: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
332: LOOP
333: IF (l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
334: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_TMPL_IS_LOCKED');
335: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
336: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.g_ret_sts_error;

Line 335: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));

331: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
332: LOOP
333: IF (l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
334: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_TMPL_IS_LOCKED');
335: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
336: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.g_ret_sts_error;
339: END IF;

Line 336: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));

332: LOOP
333: IF (l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
334: FND_MESSAGE.SET_NAME('CZ', 'CZ_COPY_TMPL_IS_LOCKED');
335: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
336: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.g_ret_sts_error;
339: END IF;
340: END LOOP;

Line 3320: -- p_init_msg_list - yes/no indicates whether to init FND message data

3316: -- - else = CZ_DB_LOGS.run_id
3317: -- x_return_status - status string
3318: -- x_msg_count - number of error messages
3319: -- x_msg_data - string which contains error messages
3320: -- p_init_msg_list - yes/no indicates whether to init FND message data
3321: --
3322: PROCEDURE copy_Repository_Folder
3323: (
3324: p_folder_id IN NUMBER,

Line 3958: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');

3954:
3955: IF (l_ui_def_tbl.COUNT > 0) THEN
3956: x_msg_count := 0;
3957: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3958: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3959: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3960: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3961: FND_MSG_PUB.ADD;
3962: END LOOP;

Line 3959: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);

3955: IF (l_ui_def_tbl.COUNT > 0) THEN
3956: x_msg_count := 0;
3957: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3958: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3959: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3960: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3961: FND_MSG_PUB.ADD;
3962: END LOOP;
3963: RAISE UIDEF_REFERENCED_EXCP;

Line 3960: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));

3956: x_msg_count := 0;
3957: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3958: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3959: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3960: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3961: FND_MSG_PUB.ADD;
3962: END LOOP;
3963: RAISE UIDEF_REFERENCED_EXCP;
3964: END IF;

Line 3976: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');

3972:
3973: IF (l_ui_def_tbl.COUNT > 0) THEN
3974: x_msg_count := 0;
3975: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3976: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3977: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3978: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3979: FND_MSG_PUB.ADD;
3980: END LOOP;

Line 3977: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);

3973: IF (l_ui_def_tbl.COUNT > 0) THEN
3974: x_msg_count := 0;
3975: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3976: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3977: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3978: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3979: FND_MSG_PUB.ADD;
3980: END LOOP;
3981: RAISE UIDEF_REFERENCED_EXCP;

Line 3978: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));

3974: x_msg_count := 0;
3975: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3976: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3977: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3978: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3979: FND_MSG_PUB.ADD;
3980: END LOOP;
3981: RAISE UIDEF_REFERENCED_EXCP;
3982: END IF;

Line 4692: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');

4688: END;
4689:
4690: IF x_ref_model_ids_tbl.COUNT > 0 THEN
4691: FOR i IN 1..x_ref_model_ids_tbl.COUNT LOOP
4692: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
4693: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4694: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));
4695: FND_MSG_PUB.ADD;
4696: END LOOP;

Line 4693: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);

4689:
4690: IF x_ref_model_ids_tbl.COUNT > 0 THEN
4691: FOR i IN 1..x_ref_model_ids_tbl.COUNT LOOP
4692: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
4693: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4694: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));
4695: FND_MSG_PUB.ADD;
4696: END LOOP;
4697: RAISE REFS_EXIST;

Line 4694: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));

4690: IF x_ref_model_ids_tbl.COUNT > 0 THEN
4691: FOR i IN 1..x_ref_model_ids_tbl.COUNT LOOP
4692: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
4693: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4694: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));
4695: FND_MSG_PUB.ADD;
4696: END LOOP;
4697: RAISE REFS_EXIST;
4698: END IF;

Line 4749: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_REFS_EXIST');

4745: x_return_status => x_return_status,
4746: x_msg_count => x_msg_count,
4747: x_msg_data => x_msg_data);
4748: WHEN REFS_EXIST THEN
4749: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_REFS_EXIST');
4750: FND_MSG_PUB.ADD;
4751: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4752: p_data => x_msg_data);
4753: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4755: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBSHD');

4751: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4752: p_data => x_msg_data);
4753: x_return_status := FND_API.G_RET_STS_ERROR;
4754: WHEN MODEL_PUBS_EXIST THEN
4755: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBSHD');
4756: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4757: FND_MSG_PUB.ADD;
4758: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4759: p_data => x_msg_data);

Line 4756: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);

4752: p_data => x_msg_data);
4753: x_return_status := FND_API.G_RET_STS_ERROR;
4754: WHEN MODEL_PUBS_EXIST THEN
4755: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBSHD');
4756: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4757: FND_MSG_PUB.ADD;
4758: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4759: p_data => x_msg_data);
4760: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4820: FND_MESSAGE.SET_NAME('CZ','CZ_DEL_MODEL_LOCK_ERR');

4816: END IF;
4817:
4818: EXCEPTION
4819: WHEN LOCK_MODEL_EXCP THEN
4820: FND_MESSAGE.SET_NAME('CZ','CZ_DEL_MODEL_LOCK_ERR');
4821: FND_MSG_PUB.ADD;
4822: x_msg_count := x_msg_count + 1;
4823: x_msg_data := fnd_msg_pub.GET(x_msg_count,fnd_api.g_false);
4824: WHEN OTHERS THEN

Line 6465: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');

6461: IF l_prj_name_tbl.COUNT > 0 THEN
6462: x_return_status := FND_API.G_RET_STS_ERROR;
6463: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6464: LOOP
6465: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6466: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
6467: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));
6468: FND_MSG_PUB.ADD;
6469: END LOOP;

Line 6466: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);

6462: x_return_status := FND_API.G_RET_STS_ERROR;
6463: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6464: LOOP
6465: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6466: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
6467: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));
6468: FND_MSG_PUB.ADD;
6469: END LOOP;
6470: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 6467: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));

6463: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6464: LOOP
6465: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6466: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
6467: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));
6468: FND_MSG_PUB.ADD;
6469: END LOOP;
6470: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
6471: p_data => x_msg_data);

Line 6887: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');

6883: IF (l_ui_name_tbl.count > 0 ) THEN
6884: x_return_status := FND_API.G_RET_STS_ERROR;
6885: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6886: LOOP
6887: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6888: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
6889: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
6890: FND_MSG_PUB.ADD;
6891: END LOOP;

Line 6888: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

6884: x_return_status := FND_API.G_RET_STS_ERROR;
6885: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6886: LOOP
6887: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6888: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
6889: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
6890: FND_MSG_PUB.ADD;
6891: END LOOP;
6892: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 6889: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));

6885: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6886: LOOP
6887: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6888: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
6889: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
6890: FND_MSG_PUB.ADD;
6891: END LOOP;
6892: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
6893: p_data => x_msg_data);

Line 7035: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');

7031: x_return_status := FND_API.G_RET_STS_ERROR;
7032: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
7033: LOOP
7034: IF l_mt_flag_tbl(i) = '1' THEN
7035: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7036: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7038: ELSE
7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');

Line 7036: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

7032: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
7033: LOOP
7034: IF l_mt_flag_tbl(i) = '1' THEN
7035: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7036: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7038: ELSE
7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7040: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));

7033: LOOP
7034: IF l_mt_flag_tbl(i) = '1' THEN
7035: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7036: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7038: ELSE
7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7040: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7041: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));

Line 7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');

7035: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7036: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7038: ELSE
7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7040: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7041: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
7042: END IF;
7043: FND_MSG_PUB.ADD;

Line 7040: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

7036: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7038: ELSE
7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7040: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7041: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
7042: END IF;
7043: FND_MSG_PUB.ADD;
7044: END LOOP;

Line 7041: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));

7037: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7038: ELSE
7039: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7040: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7041: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
7042: END IF;
7043: FND_MSG_PUB.ADD;
7044: END LOOP;
7045: END IF;

Line 7074: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');

7070: l_ref_template_name := NULL;
7071: END;
7072:
7073: IF l_ref_template_name IS NOT NULL THEN
7074: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7075: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7076: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
7077: FND_MSG_PUB.ADD;
7078: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7075: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

7071: END;
7072:
7073: IF l_ref_template_name IS NOT NULL THEN
7074: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7075: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7076: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
7077: FND_MSG_PUB.ADD;
7078: x_return_status := FND_API.G_RET_STS_ERROR;
7079: END IF;

Line 7076: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);

7072:
7073: IF l_ref_template_name IS NOT NULL THEN
7074: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7075: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7076: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
7077: FND_MSG_PUB.ADD;
7078: x_return_status := FND_API.G_RET_STS_ERROR;
7079: END IF;
7080: END LOOP;

Line 7397: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');

7393: x_return_status := FND_API.G_RET_STS_SUCCESS;
7394: x_msg_count := 0;
7395: x_msg_data := NULL;
7396: WHEN USG_IN_USE THEN
7397: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
7398: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
7399: FND_MSG_PUB.ADD;
7400: x_return_status := FND_API.g_ret_sts_error;
7401: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 7398: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

7394: x_msg_count := 0;
7395: x_msg_data := NULL;
7396: WHEN USG_IN_USE THEN
7397: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
7398: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
7399: FND_MSG_PUB.ADD;
7400: x_return_status := FND_API.g_ret_sts_error;
7401: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
7402: p_data => x_msg_data);

Line 7721: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');

7717: rec_count := l_rp_model_ref.COUNT;
7718: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
7719: LOOP
7720: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7721: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');
7722: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
7723: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));
7724: FND_MSG_PUB.ADD;
7725: x_return_status := FND_API.g_ret_sts_error;

Line 7722: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));

7718: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
7719: LOOP
7720: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7721: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');
7722: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
7723: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));
7724: FND_MSG_PUB.ADD;
7725: x_return_status := FND_API.g_ret_sts_error;
7726: END IF;

Line 7723: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));

7719: LOOP
7720: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7721: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');
7722: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
7723: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));
7724: FND_MSG_PUB.ADD;
7725: x_return_status := FND_API.g_ret_sts_error;
7726: END IF;
7727: rec_count := rec_count + 1;

Line 7848: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');

7844: rec_count := l_uct_ref.COUNT;
7845: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
7846: LOOP
7847: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7848: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');
7849: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
7850: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
7851: FND_MSG_PUB.ADD;
7852: x_return_status := FND_API.g_ret_sts_error;

Line 7849: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));

7845: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
7846: LOOP
7847: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7848: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');
7849: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
7850: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
7851: FND_MSG_PUB.ADD;
7852: x_return_status := FND_API.g_ret_sts_error;
7853: END IF;

Line 7850: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));

7846: LOOP
7847: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7848: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');
7849: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
7850: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
7851: FND_MSG_PUB.ADD;
7852: x_return_status := FND_API.g_ret_sts_error;
7853: END IF;
7854: rec_count := rec_count + 1;

Line 7893: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');

7889:
7890: SELECT name into l_ref_model_name from cz_devl_projects
7891: WHERE devl_project_id = l_rp_model_ref(modelId);
7892:
7893: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7894: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);
7895: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);
7896: FND_MSG_PUB.ADD;
7897: x_return_status := FND_API.g_ret_sts_error;

Line 7894: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);

7890: SELECT name into l_ref_model_name from cz_devl_projects
7891: WHERE devl_project_id = l_rp_model_ref(modelId);
7892:
7893: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7894: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);
7895: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);
7896: FND_MSG_PUB.ADD;
7897: x_return_status := FND_API.g_ret_sts_error;
7898: END IF;

Line 7895: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);

7891: WHERE devl_project_id = l_rp_model_ref(modelId);
7892:
7893: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7894: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);
7895: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);
7896: FND_MSG_PUB.ADD;
7897: x_return_status := FND_API.g_ret_sts_error;
7898: END IF;
7899:

Line 7915: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');

7911: FOR I IN l_publication_tbl.FIRST..l_publication_tbl.LAST
7912: LOOP
7913: SELECT name into l_model_name from cz_devl_projects
7914: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7915: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7916: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7917: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));
7918: FND_MSG_PUB.ADD;
7919: x_return_status := FND_API.g_ret_sts_error;

Line 7916: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);

7912: LOOP
7913: SELECT name into l_model_name from cz_devl_projects
7914: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7915: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7916: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7917: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));
7918: FND_MSG_PUB.ADD;
7919: x_return_status := FND_API.g_ret_sts_error;
7920: END LOOP;

Line 7917: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));

7913: SELECT name into l_model_name from cz_devl_projects
7914: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7915: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7916: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7917: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));
7918: FND_MSG_PUB.ADD;
7919: x_return_status := FND_API.g_ret_sts_error;
7920: END LOOP;
7921: END IF;

Line 7996: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');

7992:
7993: IF ( (l_model_name IS NOT NULL)
7994: AND (NOT l_encl_idx_ref.EXISTS(l_encl_eff_fld ) ) ) THEN
7995: x_return_status := FND_API.G_RET_STS_ERROR;
7996: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
7997: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
7998: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7999: FND_MSG_PUB.ADD;
8000: END IF;

Line 7997: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);

7993: IF ( (l_model_name IS NOT NULL)
7994: AND (NOT l_encl_idx_ref.EXISTS(l_encl_eff_fld ) ) ) THEN
7995: x_return_status := FND_API.G_RET_STS_ERROR;
7996: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
7997: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
7998: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7999: FND_MSG_PUB.ADD;
8000: END IF;
8001: END LOOP;

Line 7998: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);

7994: AND (NOT l_encl_idx_ref.EXISTS(l_encl_eff_fld ) ) ) THEN
7995: x_return_status := FND_API.G_RET_STS_ERROR;
7996: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
7997: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
7998: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7999: FND_MSG_PUB.ADD;
8000: END IF;
8001: END LOOP;
8002: END IF;

Line 8044: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');

8040: WHERE object_id = l_devl_project_tbl(i)
8041: AND object_type = 'PRJ';
8042: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
8043: x_return_status := FND_API.G_RET_STS_ERROR;
8044: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');
8045: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);
8046: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);
8047: FND_MSG_PUB.ADD;
8048: END IF;

Line 8045: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);

8041: AND object_type = 'PRJ';
8042: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
8043: x_return_status := FND_API.G_RET_STS_ERROR;
8044: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');
8045: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);
8046: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);
8047: FND_MSG_PUB.ADD;
8048: END IF;
8049: END LOOP;

Line 8046: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);

8042: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
8043: x_return_status := FND_API.G_RET_STS_ERROR;
8044: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');
8045: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);
8046: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);
8047: FND_MSG_PUB.ADD;
8048: END IF;
8049: END LOOP;
8050: END IF;

Line 8098: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');

8094: FROM cz_rp_entries WHERE object_id = l_devl_project_tbl(j)
8095: AND object_type = 'PRJ';
8096: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8097: x_return_status := FND_API.G_RET_STS_ERROR;
8098: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8099: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8100: FND_MSG_PUB.ADD;
8101: EXIT;
8102: END IF;

Line 8099: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);

8095: AND object_type = 'PRJ';
8096: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8097: x_return_status := FND_API.G_RET_STS_ERROR;
8098: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8099: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8100: FND_MSG_PUB.ADD;
8101: EXIT;
8102: END IF;
8103: END LOOP;

Line 8122: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');

8118: END;
8119:
8120: IF (l_item_prop_count > 0) THEN
8121: x_return_status := FND_API.G_RET_STS_ERROR;
8122: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8123: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8124: FND_MSG_PUB.ADD;
8125: END IF;
8126:

Line 8123: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);

8119:
8120: IF (l_item_prop_count > 0) THEN
8121: x_return_status := FND_API.G_RET_STS_ERROR;
8122: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8123: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8124: FND_MSG_PUB.ADD;
8125: END IF;
8126:
8127: BEGIN

Line 8139: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');

8135: l_prop_count := 0;
8136: END;
8137: IF (l_item_prop_count > 0) THEN
8138: x_return_status := FND_API.G_RET_STS_ERROR;
8139: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8140: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8141: FND_MSG_PUB.ADD;
8142: END IF;
8143: EXCEPTION

Line 8140: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);

8136: END;
8137: IF (l_item_prop_count > 0) THEN
8138: x_return_status := FND_API.G_RET_STS_ERROR;
8139: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8140: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8141: FND_MSG_PUB.ADD;
8142: END IF;
8143: EXCEPTION
8144: WHEN NO_DATA_FOUND THEN

Line 8178: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');

8174: IF (l_ui_name_tbl.count > 0 ) THEN
8175: x_return_status := FND_API.G_RET_STS_ERROR;
8176: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8177: LOOP
8178: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8179: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8180: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8181: FND_MSG_PUB.ADD;
8182: EXIT;

Line 8179: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

8175: x_return_status := FND_API.G_RET_STS_ERROR;
8176: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8177: LOOP
8178: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8179: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8180: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8181: FND_MSG_PUB.ADD;
8182: EXIT;
8183: END LOOP;

Line 8180: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));

8176: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8177: LOOP
8178: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8179: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8180: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8181: FND_MSG_PUB.ADD;
8182: EXIT;
8183: END LOOP;
8184: END IF;

Line 8228: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');

8224: IF (l_ui_name_tbl.count > 0 ) THEN
8225: x_return_status := FND_API.G_RET_STS_ERROR;
8226: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8227: LOOP
8228: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8229: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8230: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
8231: FND_MSG_PUB.ADD;
8232: END LOOP;

Line 8229: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

8225: x_return_status := FND_API.G_RET_STS_ERROR;
8226: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8227: LOOP
8228: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8229: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8230: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
8231: FND_MSG_PUB.ADD;
8232: END LOOP;
8233: END IF;

Line 8230: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));

8226: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8227: LOOP
8228: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8229: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8230: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
8231: FND_MSG_PUB.ADD;
8232: END LOOP;
8233: END IF;
8234: --Bug#13770170: Adding missing check for cz_ui_ref_templates

Line 8265: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');

8261: l_ref_template_name := NULL;
8262: END;
8263:
8264: IF l_ref_template_name IS NOT NULL THEN
8265: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
8266: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8267: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
8268: FND_MSG_PUB.ADD;
8269: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8266: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

8262: END;
8263:
8264: IF l_ref_template_name IS NOT NULL THEN
8265: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
8266: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8267: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
8268: FND_MSG_PUB.ADD;
8269: x_return_status := FND_API.G_RET_STS_ERROR;
8270: END IF;

Line 8267: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);

8263:
8264: IF l_ref_template_name IS NOT NULL THEN
8265: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
8266: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8267: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
8268: FND_MSG_PUB.ADD;
8269: x_return_status := FND_API.G_RET_STS_ERROR;
8270: END IF;
8271: END LOOP;

Line 8306: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');

8302: l_usage_count := 0;
8303: END;
8304:
8305: IF (l_usage_count = 1) THEN
8306: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8307: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8308: FND_MSG_PUB.ADD;
8309: x_return_status := FND_API.g_ret_sts_error;
8310: EXIT;

Line 8307: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

8303: END;
8304:
8305: IF (l_usage_count = 1) THEN
8306: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8307: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8308: FND_MSG_PUB.ADD;
8309: x_return_status := FND_API.g_ret_sts_error;
8310: EXIT;
8311: END IF;

Line 8355: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');

8351: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8352: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8353: AND object_type = 'PRJ';
8354: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8355: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8356: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8357: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8358: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8359: FND_MSG_PUB.ADD;

Line 8356: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

8352: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8353: AND object_type = 'PRJ';
8354: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8355: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8356: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8357: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8358: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8359: FND_MSG_PUB.ADD;
8360: x_return_status := FND_API.g_ret_sts_error;

Line 8357: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));

8353: AND object_type = 'PRJ';
8354: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8355: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8356: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8357: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8358: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8359: FND_MSG_PUB.ADD;
8360: x_return_status := FND_API.g_ret_sts_error;
8361: EXIT;

Line 8358: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);

8354: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8355: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8356: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8357: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8358: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8359: FND_MSG_PUB.ADD;
8360: x_return_status := FND_API.g_ret_sts_error;
8361: EXIT;
8362: END IF;

Line 8376: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');

8372: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8373: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8374: AND object_type = 'PRJ';
8375: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8376: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8377: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8378: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8379: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8380: FND_MSG_PUB.ADD;

Line 8377: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);

8373: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8374: AND object_type = 'PRJ';
8375: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8376: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8377: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8378: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8379: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8380: FND_MSG_PUB.ADD;
8381: x_return_status := FND_API.g_ret_sts_error;

Line 8378: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));

8374: AND object_type = 'PRJ';
8375: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8376: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8377: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8378: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8379: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8380: FND_MSG_PUB.ADD;
8381: x_return_status := FND_API.g_ret_sts_error;
8382: EXIT;

Line 8379: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);

8375: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8376: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8377: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8378: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8379: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8380: FND_MSG_PUB.ADD;
8381: x_return_status := FND_API.g_ret_sts_error;
8382: EXIT;
8383: END IF;

Line 11570: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_DOES_NOT_EXIST');

11566:
11567: EXCEPTION
11568: WHEN SRCRULE_DOES_NOT_EXIST THEN
11569: x_return_status := FND_API.G_RET_STS_ERROR;
11570: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_DOES_NOT_EXIST');
11571: FND_MSG_PUB.ADD;
11572: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11573: p_data => x_msg_data);
11574: WHEN SRCRULE_IS_DELETED THEN

Line 11576: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_IS_DELETED');

11572: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11573: p_data => x_msg_data);
11574: WHEN SRCRULE_IS_DELETED THEN
11575: x_return_status := FND_API.G_RET_STS_ERROR;
11576: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_IS_DELETED');
11577: FND_MSG_PUB.ADD;
11578: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11579: p_data => x_msg_data);
11580: WHEN TGTRULEFLD_DOES_NOT_EXIST THEN

Line 11582: FND_MESSAGE.SET_NAME('CZ', 'CZ_TGTRULEFLD_DOES_NOT_EXIST');

11578: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11579: p_data => x_msg_data);
11580: WHEN TGTRULEFLD_DOES_NOT_EXIST THEN
11581: x_return_status := FND_API.G_RET_STS_ERROR;
11582: FND_MESSAGE.SET_NAME('CZ', 'CZ_TGTRULEFLD_DOES_NOT_EXIST');
11583: FND_MSG_PUB.ADD;
11584: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11585: p_data => x_msg_data);
11586: WHEN INVALID_CIRCULAR_MOVE THEN

Line 11588: FND_MESSAGE.SET_NAME('CZ', 'CZ_INVALID_CIRCULAR_MOVE');

11584: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11585: p_data => x_msg_data);
11586: WHEN INVALID_CIRCULAR_MOVE THEN
11587: x_return_status := FND_API.G_RET_STS_ERROR;
11588: FND_MESSAGE.SET_NAME('CZ', 'CZ_INVALID_CIRCULAR_MOVE');
11589: FND_MSG_PUB.ADD;
11590: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11591: p_data => x_msg_data);
11592: WHEN OBJTYPE_NOT_ALLOWED THEN

Line 11594: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_FOLDER_SEQ_INCOMPAT_ERR');

11590: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11591: p_data => x_msg_data);
11592: WHEN OBJTYPE_NOT_ALLOWED THEN
11593: x_return_status := FND_API.G_RET_STS_ERROR;
11594: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_FOLDER_SEQ_INCOMPAT_ERR');
11595: FND_MSG_PUB.ADD;
11596: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11597: p_data => x_msg_data);
11598: WHEN CANNOT_MOVE_TO_THIS_FLD THEN

Line 11600: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');

11596: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11597: p_data => x_msg_data);
11598: WHEN CANNOT_MOVE_TO_THIS_FLD THEN
11599: x_return_status := FND_API.G_RET_STS_ERROR;
11600: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');
11601: FND_MSG_PUB.ADD;
11602: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11603: p_data => x_msg_data);
11604: WHEN CAN_MOVE_IN_SAME_PROJECT THEN

Line 11606: FND_MESSAGE.SET_NAME('CZ', 'CZ_CAN_MOVE_IN_SAME_PROJECT');

11602: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11603: p_data => x_msg_data);
11604: WHEN CAN_MOVE_IN_SAME_PROJECT THEN
11605: x_return_status := FND_API.G_RET_STS_ERROR;
11606: FND_MESSAGE.SET_NAME('CZ', 'CZ_CAN_MOVE_IN_SAME_PROJECT');
11607: FND_MSG_PUB.ADD;
11608: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11609: p_data => x_msg_data);
11610: WHEN OTHERS THEN

Line 11612: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');

11608: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11609: p_data => x_msg_data);
11610: WHEN OTHERS THEN
11611: x_return_status := FND_API.G_RET_STS_ERROR;
11612: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');
11613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11614: FND_MSG_PUB.ADD;
11615: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11616: p_data => x_msg_data);

Line 11613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

11609: p_data => x_msg_data);
11610: WHEN OTHERS THEN
11611: x_return_status := FND_API.G_RET_STS_ERROR;
11612: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');
11613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11614: FND_MSG_PUB.ADD;
11615: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11616: p_data => x_msg_data);
11617: END is_rule_movable;