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 3292: -- p_init_msg_list - yes/no indicates whether to init FND message data

3288: -- - else = CZ_DB_LOGS.run_id
3289: -- x_return_status - status string
3290: -- x_msg_count - number of error messages
3291: -- x_msg_data - string which contains error messages
3292: -- p_init_msg_list - yes/no indicates whether to init FND message data
3293: --
3294: PROCEDURE copy_Repository_Folder
3295: (
3296: p_folder_id IN NUMBER,

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

3926:
3927: IF (l_ui_def_tbl.COUNT > 0) THEN
3928: x_msg_count := 0;
3929: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3930: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3931: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3932: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3933: FND_MSG_PUB.ADD;
3934: END LOOP;

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

3927: IF (l_ui_def_tbl.COUNT > 0) THEN
3928: x_msg_count := 0;
3929: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3930: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3931: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3932: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3933: FND_MSG_PUB.ADD;
3934: END LOOP;
3935: RAISE UIDEF_REFERENCED_EXCP;

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

3928: x_msg_count := 0;
3929: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3930: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3931: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3932: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3933: FND_MSG_PUB.ADD;
3934: END LOOP;
3935: RAISE UIDEF_REFERENCED_EXCP;
3936: END IF;

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

3944:
3945: IF (l_ui_def_tbl.COUNT > 0) THEN
3946: x_msg_count := 0;
3947: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3948: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3949: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3950: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3951: FND_MSG_PUB.ADD;
3952: END LOOP;

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

3945: IF (l_ui_def_tbl.COUNT > 0) THEN
3946: x_msg_count := 0;
3947: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3948: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3949: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3950: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3951: FND_MSG_PUB.ADD;
3952: END LOOP;
3953: RAISE UIDEF_REFERENCED_EXCP;

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

3946: x_msg_count := 0;
3947: FOR i IN l_ui_def_tbl.first..l_ui_def_tbl.last LOOP
3948: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_UIDEF_IS_REFED');
3949: FND_MESSAGE.SET_TOKEN('UIDEFNAME', l_uidef_name);
3950: FND_MESSAGE.SET_TOKEN('REFUIDEFNAME', l_name_tbl(i));
3951: FND_MSG_PUB.ADD;
3952: END LOOP;
3953: RAISE UIDEF_REFERENCED_EXCP;
3954: END IF;

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

4660: END;
4661:
4662: IF x_ref_model_ids_tbl.COUNT > 0 THEN
4663: FOR i IN 1..x_ref_model_ids_tbl.COUNT LOOP
4664: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
4665: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4666: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));
4667: FND_MSG_PUB.ADD;
4668: END LOOP;

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

4661:
4662: IF x_ref_model_ids_tbl.COUNT > 0 THEN
4663: FOR i IN 1..x_ref_model_ids_tbl.COUNT LOOP
4664: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
4665: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4666: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));
4667: FND_MSG_PUB.ADD;
4668: END LOOP;
4669: RAISE REFS_EXIST;

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

4662: IF x_ref_model_ids_tbl.COUNT > 0 THEN
4663: FOR i IN 1..x_ref_model_ids_tbl.COUNT LOOP
4664: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
4665: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4666: FND_MESSAGE.SET_TOKEN('REFMODELNAME', x_ref_model_names_tbl(i));
4667: FND_MSG_PUB.ADD;
4668: END LOOP;
4669: RAISE REFS_EXIST;
4670: END IF;

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

4717: x_return_status => x_return_status,
4718: x_msg_count => x_msg_count,
4719: x_msg_data => x_msg_data);
4720: WHEN REFS_EXIST THEN
4721: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_REFS_EXIST');
4722: FND_MSG_PUB.ADD;
4723: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4724: p_data => x_msg_data);
4725: x_return_status := FND_API.G_RET_STS_ERROR;

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

4723: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4724: p_data => x_msg_data);
4725: x_return_status := FND_API.G_RET_STS_ERROR;
4726: WHEN MODEL_PUBS_EXIST THEN
4727: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBSHD');
4728: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4729: FND_MSG_PUB.ADD;
4730: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4731: p_data => x_msg_data);

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

4724: p_data => x_msg_data);
4725: x_return_status := FND_API.G_RET_STS_ERROR;
4726: WHEN MODEL_PUBS_EXIST THEN
4727: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBSHD');
4728: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4729: FND_MSG_PUB.ADD;
4730: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4731: p_data => x_msg_data);
4732: x_return_status := FND_API.G_RET_STS_ERROR;

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

4787: END IF;
4788:
4789: EXCEPTION
4790: WHEN LOCK_MODEL_EXCP THEN
4791: FND_MESSAGE.SET_NAME('CZ','CZ_DEL_MODEL_LOCK_ERR');
4792: FND_MSG_PUB.ADD;
4793: x_msg_count := x_msg_count + 1;
4794: x_msg_data := fnd_msg_pub.GET(x_msg_count,fnd_api.g_false);
4795: WHEN OTHERS THEN

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

6432: IF l_prj_name_tbl.COUNT > 0 THEN
6433: x_return_status := FND_API.G_RET_STS_ERROR;
6434: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6435: LOOP
6436: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6437: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
6438: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));
6439: FND_MSG_PUB.ADD;
6440: END LOOP;

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

6433: x_return_status := FND_API.G_RET_STS_ERROR;
6434: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6435: LOOP
6436: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6437: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
6438: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));
6439: FND_MSG_PUB.ADD;
6440: END LOOP;
6441: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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

6434: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6435: LOOP
6436: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6437: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
6438: FND_MESSAGE.SET_TOKEN('MODELNAME', l_prj_name_tbl(i));
6439: FND_MSG_PUB.ADD;
6440: END LOOP;
6441: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
6442: p_data => x_msg_data);

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

6854: IF (l_ui_name_tbl.count > 0 ) THEN
6855: x_return_status := FND_API.G_RET_STS_ERROR;
6856: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6857: LOOP
6858: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6859: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
6860: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
6861: FND_MSG_PUB.ADD;
6862: END LOOP;

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

6855: x_return_status := FND_API.G_RET_STS_ERROR;
6856: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6857: LOOP
6858: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6859: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
6860: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
6861: FND_MSG_PUB.ADD;
6862: END LOOP;
6863: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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

6856: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6857: LOOP
6858: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6859: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
6860: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
6861: FND_MSG_PUB.ADD;
6862: END LOOP;
6863: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
6864: p_data => x_msg_data);

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

7002: x_return_status := FND_API.G_RET_STS_ERROR;
7003: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
7004: LOOP
7005: IF l_mt_flag_tbl(i) = '1' THEN
7006: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7007: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7008: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7009: ELSE
7010: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');

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

7003: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
7004: LOOP
7005: IF l_mt_flag_tbl(i) = '1' THEN
7006: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7007: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7008: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7009: ELSE
7010: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7011: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

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

7004: LOOP
7005: IF l_mt_flag_tbl(i) = '1' THEN
7006: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7007: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7008: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7009: ELSE
7010: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7011: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7012: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));

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

7006: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7007: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7008: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7009: ELSE
7010: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7011: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7012: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
7013: END IF;
7014: FND_MSG_PUB.ADD;

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

7007: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7008: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7009: ELSE
7010: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7011: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7012: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
7013: END IF;
7014: FND_MSG_PUB.ADD;
7015: END LOOP;

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

7008: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ui_name_tbl(i));
7009: ELSE
7010: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
7011: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7012: FND_MESSAGE.SET_TOKEN('UINAME', l_ui_name_tbl(i));
7013: END IF;
7014: FND_MSG_PUB.ADD;
7015: END LOOP;
7016: END IF;

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

7041: l_ref_template_name := NULL;
7042: END;
7043:
7044: IF l_ref_template_name IS NOT NULL THEN
7045: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7046: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7047: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
7048: FND_MSG_PUB.ADD;
7049: x_return_status := FND_API.G_RET_STS_ERROR;

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

7042: END;
7043:
7044: IF l_ref_template_name IS NOT NULL THEN
7045: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7046: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7047: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
7048: FND_MSG_PUB.ADD;
7049: x_return_status := FND_API.G_RET_STS_ERROR;
7050: END IF;

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

7043:
7044: IF l_ref_template_name IS NOT NULL THEN
7045: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');
7046: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
7047: FND_MESSAGE.SET_TOKEN('TEMPLNAME',l_ref_template_name);
7048: FND_MSG_PUB.ADD;
7049: x_return_status := FND_API.G_RET_STS_ERROR;
7050: END IF;
7051: END LOOP;

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

7340: x_return_status := FND_API.G_RET_STS_SUCCESS;
7341: x_msg_count := 0;
7342: x_msg_data := NULL;
7343: WHEN USG_IN_USE THEN
7344: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
7345: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
7346: FND_MSG_PUB.ADD;
7347: x_return_status := FND_API.g_ret_sts_error;
7348: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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

7341: x_msg_count := 0;
7342: x_msg_data := NULL;
7343: WHEN USG_IN_USE THEN
7344: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
7345: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
7346: FND_MSG_PUB.ADD;
7347: x_return_status := FND_API.g_ret_sts_error;
7348: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
7349: p_data => x_msg_data);

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

7659: rec_count := l_rp_model_ref.COUNT;
7660: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
7661: LOOP
7662: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7663: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');
7664: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
7665: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));
7666: FND_MSG_PUB.ADD;
7667: x_return_status := FND_API.g_ret_sts_error;

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

7660: FOR J IN l_rp_model_tbl.FIRST..l_rp_model_tbl.LAST
7661: LOOP
7662: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7663: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');
7664: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
7665: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));
7666: FND_MSG_PUB.ADD;
7667: x_return_status := FND_API.g_ret_sts_error;
7668: END IF;

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

7661: LOOP
7662: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7663: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_LOCKED_MODEL');
7664: FND_MESSAGE.SET_TOKEN('MODELNAME', l_devl_prj_name_tbl(j));
7665: FND_MESSAGE.SET_TOKEN('CHECKOUTUSER', l_checkout_user_tbl(j));
7666: FND_MSG_PUB.ADD;
7667: x_return_status := FND_API.g_ret_sts_error;
7668: END IF;
7669: rec_count := rec_count + 1;

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

7786: rec_count := l_uct_ref.COUNT;
7787: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
7788: LOOP
7789: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7790: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');
7791: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
7792: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
7793: FND_MSG_PUB.ADD;
7794: x_return_status := FND_API.g_ret_sts_error;

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

7787: FOR J IN l_uct_tbl.FIRST..l_uct_tbl.LAST
7788: LOOP
7789: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7790: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');
7791: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
7792: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
7793: FND_MSG_PUB.ADD;
7794: x_return_status := FND_API.g_ret_sts_error;
7795: END IF;

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

7788: LOOP
7789: IF ( l_checkout_user_tbl(j) IS NOT NULL AND l_checkout_user_tbl(j) <> l_user_name ) THEN
7790: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_TMPL_IS_LOCKED');
7791: FND_MESSAGE.SET_TOKEN('UCTNAME', l_template_name_tbl(j));
7792: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user_tbl(j));
7793: FND_MSG_PUB.ADD;
7794: x_return_status := FND_API.g_ret_sts_error;
7795: END IF;
7796: rec_count := rec_count + 1;

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

7831:
7832: SELECT name into l_ref_model_name from cz_devl_projects
7833: WHERE devl_project_id = l_rp_model_ref(modelId);
7834:
7835: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7836: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);
7837: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);
7838: FND_MSG_PUB.ADD;
7839: x_return_status := FND_API.g_ret_sts_error;

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

7832: SELECT name into l_ref_model_name from cz_devl_projects
7833: WHERE devl_project_id = l_rp_model_ref(modelId);
7834:
7835: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7836: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);
7837: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);
7838: FND_MSG_PUB.ADD;
7839: x_return_status := FND_API.g_ret_sts_error;
7840: END IF;

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

7833: WHERE devl_project_id = l_rp_model_ref(modelId);
7834:
7835: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_REFD_BY');
7836: FND_MESSAGE.SET_TOKEN('MODELNAME',l_ref_model_name);
7837: FND_MESSAGE.SET_TOKEN('REFMODELNAME',l_model_name);
7838: FND_MSG_PUB.ADD;
7839: x_return_status := FND_API.g_ret_sts_error;
7840: END IF;
7841:

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

7853: FOR I IN l_publication_tbl.FIRST..l_publication_tbl.LAST
7854: LOOP
7855: SELECT name into l_model_name from cz_devl_projects
7856: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7857: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7858: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7859: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));
7860: FND_MSG_PUB.ADD;
7861: x_return_status := FND_API.g_ret_sts_error;

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

7854: LOOP
7855: SELECT name into l_model_name from cz_devl_projects
7856: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7857: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7858: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7859: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));
7860: FND_MSG_PUB.ADD;
7861: x_return_status := FND_API.g_ret_sts_error;
7862: END LOOP;

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

7855: SELECT name into l_model_name from cz_devl_projects
7856: WHERE devl_project_id = l_ref_model_ids_tbl(i);
7857: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBLD');
7858: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7859: FND_MESSAGE.SET_TOKEN('PUBID', l_publication_tbl(i));
7860: FND_MSG_PUB.ADD;
7861: x_return_status := FND_API.g_ret_sts_error;
7862: END LOOP;
7863: END IF;

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

7934:
7935: IF ( (l_model_name IS NOT NULL)
7936: AND (NOT l_encl_idx_ref.EXISTS(l_encl_eff_fld ) ) ) THEN
7937: x_return_status := FND_API.G_RET_STS_ERROR;
7938: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
7939: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
7940: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7941: FND_MSG_PUB.ADD;
7942: END IF;

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

7935: IF ( (l_model_name IS NOT NULL)
7936: AND (NOT l_encl_idx_ref.EXISTS(l_encl_eff_fld ) ) ) THEN
7937: x_return_status := FND_API.G_RET_STS_ERROR;
7938: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
7939: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
7940: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7941: FND_MSG_PUB.ADD;
7942: END IF;
7943: END LOOP;

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

7936: AND (NOT l_encl_idx_ref.EXISTS(l_encl_eff_fld ) ) ) THEN
7937: x_return_status := FND_API.G_RET_STS_ERROR;
7938: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
7939: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);
7940: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
7941: FND_MSG_PUB.ADD;
7942: END IF;
7943: END LOOP;
7944: END IF;

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

7982: WHERE object_id = l_devl_project_tbl(i)
7983: AND object_type = 'PRJ';
7984: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
7985: x_return_status := FND_API.G_RET_STS_ERROR;
7986: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');
7987: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);
7988: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);
7989: FND_MSG_PUB.ADD;
7990: END IF;

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

7983: AND object_type = 'PRJ';
7984: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
7985: x_return_status := FND_API.G_RET_STS_ERROR;
7986: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');
7987: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);
7988: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);
7989: FND_MSG_PUB.ADD;
7990: END IF;
7991: END LOOP;

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

7984: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld ) ) THEN
7985: x_return_status := FND_API.G_RET_STS_ERROR;
7986: FND_MESSAGE.SET_NAME('CZ','CZ_ARC_IN_USE');
7987: FND_MESSAGE.SET_TOKEN('ARCHIVENAME',l_object_name);
7988: FND_MESSAGE.SET_TOKEN('MODELNAME',l_devl_name);
7989: FND_MSG_PUB.ADD;
7990: END IF;
7991: END LOOP;
7992: END IF;

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

8036: FROM cz_rp_entries WHERE object_id = l_devl_project_tbl(j)
8037: AND object_type = 'PRJ';
8038: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8039: x_return_status := FND_API.G_RET_STS_ERROR;
8040: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8041: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8042: FND_MSG_PUB.ADD;
8043: EXIT;
8044: END IF;

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

8037: AND object_type = 'PRJ';
8038: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8039: x_return_status := FND_API.G_RET_STS_ERROR;
8040: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8041: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8042: FND_MSG_PUB.ADD;
8043: EXIT;
8044: END IF;
8045: END LOOP;

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

8060: END;
8061:
8062: IF (l_item_prop_count > 0) THEN
8063: x_return_status := FND_API.G_RET_STS_ERROR;
8064: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8065: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8066: FND_MSG_PUB.ADD;
8067: END IF;
8068:

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

8061:
8062: IF (l_item_prop_count > 0) THEN
8063: x_return_status := FND_API.G_RET_STS_ERROR;
8064: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8065: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8066: FND_MSG_PUB.ADD;
8067: END IF;
8068:
8069: BEGIN

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

8077: l_prop_count := 0;
8078: END;
8079: IF (l_item_prop_count > 0) THEN
8080: x_return_status := FND_API.G_RET_STS_ERROR;
8081: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8082: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8083: FND_MSG_PUB.ADD;
8084: END IF;
8085: EXCEPTION

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

8078: END;
8079: IF (l_item_prop_count > 0) THEN
8080: x_return_status := FND_API.G_RET_STS_ERROR;
8081: FND_MESSAGE.SET_NAME('CZ','CZ_PROP_IN_USE');
8082: FND_MESSAGE.SET_TOKEN('NAME',l_object_name);
8083: FND_MSG_PUB.ADD;
8084: END IF;
8085: EXCEPTION
8086: WHEN NO_DATA_FOUND THEN

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

8113: IF (l_ui_name_tbl.count > 0 ) THEN
8114: x_return_status := FND_API.G_RET_STS_ERROR;
8115: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8116: LOOP
8117: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8118: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8119: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8120: FND_MSG_PUB.ADD;
8121: EXIT;

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

8114: x_return_status := FND_API.G_RET_STS_ERROR;
8115: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8116: LOOP
8117: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8118: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8119: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8120: FND_MSG_PUB.ADD;
8121: EXIT;
8122: END LOOP;

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

8115: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8116: LOOP
8117: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8118: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8119: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8120: FND_MSG_PUB.ADD;
8121: EXIT;
8122: END LOOP;
8123: END IF;

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

8155: IF (l_ui_name_tbl.count > 0 ) THEN
8156: x_return_status := FND_API.G_RET_STS_ERROR;
8157: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8158: LOOP
8159: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8160: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8161: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8162: FND_MSG_PUB.ADD;
8163: END LOOP;

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

8156: x_return_status := FND_API.G_RET_STS_ERROR;
8157: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8158: LOOP
8159: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8160: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8161: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8162: FND_MSG_PUB.ADD;
8163: END LOOP;
8164: END IF;

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

8157: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8158: LOOP
8159: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8160: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);
8161: FND_MESSAGE.SET_TOKEN('UI', l_ui_name_tbl(i));
8162: FND_MSG_PUB.ADD;
8163: END LOOP;
8164: END IF;
8165: EXCEPTION

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

8193: l_usage_count := 0;
8194: END;
8195:
8196: IF (l_usage_count = 1) THEN
8197: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8198: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8199: FND_MSG_PUB.ADD;
8200: x_return_status := FND_API.g_ret_sts_error;
8201: EXIT;

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

8194: END;
8195:
8196: IF (l_usage_count = 1) THEN
8197: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8198: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8199: FND_MSG_PUB.ADD;
8200: x_return_status := FND_API.g_ret_sts_error;
8201: EXIT;
8202: END IF;

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

8242: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8243: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8244: AND object_type = 'PRJ';
8245: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8246: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8247: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8248: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8249: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8250: FND_MSG_PUB.ADD;

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

8243: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8244: AND object_type = 'PRJ';
8245: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8246: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8247: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8248: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8249: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8250: FND_MSG_PUB.ADD;
8251: x_return_status := FND_API.g_ret_sts_error;

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

8244: AND object_type = 'PRJ';
8245: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8246: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8247: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8248: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8249: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8250: FND_MSG_PUB.ADD;
8251: x_return_status := FND_API.g_ret_sts_error;
8252: EXIT;

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

8245: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8246: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8247: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8248: FND_MESSAGE.SET_TOKEN('PSNODE',l_nodes_name_tbl(i));
8249: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8250: FND_MSG_PUB.ADD;
8251: x_return_status := FND_API.g_ret_sts_error;
8252: EXIT;
8253: END IF;

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

8263: SELECT enclosing_folder,name into l_encl_arc_fld,l_model_name
8264: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8265: AND object_type = 'PRJ';
8266: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8267: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8268: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8269: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8270: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8271: FND_MSG_PUB.ADD;

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

8264: FROM cz_rp_entries WHERE object_id = l_nodes_project_tbl(i)
8265: AND object_type = 'PRJ';
8266: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8267: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8268: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8269: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8270: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8271: FND_MSG_PUB.ADD;
8272: x_return_status := FND_API.g_ret_sts_error;

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

8265: AND object_type = 'PRJ';
8266: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8267: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8268: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8269: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8270: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8271: FND_MSG_PUB.ADD;
8272: x_return_status := FND_API.g_ret_sts_error;
8273: EXIT;

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

8266: IF ( NOT l_encl_idx_ref.EXISTS(l_encl_arc_fld) ) THEN
8267: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');
8268: FND_MESSAGE.SET_TOKEN('USAGE',l_usage_name);
8269: FND_MESSAGE.SET_TOKEN('RULE',l_rules_name_tbl(i));
8270: FND_MESSAGE.SET_TOKEN('PROJECT',l_model_name);
8271: FND_MSG_PUB.ADD;
8272: x_return_status := FND_API.g_ret_sts_error;
8273: EXIT;
8274: END IF;

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

11492:
11493: EXCEPTION
11494: WHEN SRCRULE_DOES_NOT_EXIST THEN
11495: x_return_status := FND_API.G_RET_STS_ERROR;
11496: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_DOES_NOT_EXIST');
11497: FND_MSG_PUB.ADD;
11498: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11499: p_data => x_msg_data);
11500: WHEN SRCRULE_IS_DELETED THEN

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

11498: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11499: p_data => x_msg_data);
11500: WHEN SRCRULE_IS_DELETED THEN
11501: x_return_status := FND_API.G_RET_STS_ERROR;
11502: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_IS_DELETED');
11503: FND_MSG_PUB.ADD;
11504: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11505: p_data => x_msg_data);
11506: WHEN TGTRULEFLD_DOES_NOT_EXIST THEN

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

11504: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11505: p_data => x_msg_data);
11506: WHEN TGTRULEFLD_DOES_NOT_EXIST THEN
11507: x_return_status := FND_API.G_RET_STS_ERROR;
11508: FND_MESSAGE.SET_NAME('CZ', 'CZ_TGTRULEFLD_DOES_NOT_EXIST');
11509: FND_MSG_PUB.ADD;
11510: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11511: p_data => x_msg_data);
11512: WHEN INVALID_CIRCULAR_MOVE THEN

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

11510: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11511: p_data => x_msg_data);
11512: WHEN INVALID_CIRCULAR_MOVE THEN
11513: x_return_status := FND_API.G_RET_STS_ERROR;
11514: FND_MESSAGE.SET_NAME('CZ', 'CZ_INVALID_CIRCULAR_MOVE');
11515: FND_MSG_PUB.ADD;
11516: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11517: p_data => x_msg_data);
11518: WHEN OBJTYPE_NOT_ALLOWED THEN

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

11516: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11517: p_data => x_msg_data);
11518: WHEN OBJTYPE_NOT_ALLOWED THEN
11519: x_return_status := FND_API.G_RET_STS_ERROR;
11520: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_FOLDER_SEQ_INCOMPAT_ERR');
11521: FND_MSG_PUB.ADD;
11522: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11523: p_data => x_msg_data);
11524: WHEN CANNOT_MOVE_TO_THIS_FLD THEN

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

11522: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11523: p_data => x_msg_data);
11524: WHEN CANNOT_MOVE_TO_THIS_FLD THEN
11525: x_return_status := FND_API.G_RET_STS_ERROR;
11526: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');
11527: FND_MSG_PUB.ADD;
11528: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11529: p_data => x_msg_data);
11530: WHEN CAN_MOVE_IN_SAME_PROJECT THEN

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

11528: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11529: p_data => x_msg_data);
11530: WHEN CAN_MOVE_IN_SAME_PROJECT THEN
11531: x_return_status := FND_API.G_RET_STS_ERROR;
11532: FND_MESSAGE.SET_NAME('CZ', 'CZ_CAN_MOVE_IN_SAME_PROJECT');
11533: FND_MSG_PUB.ADD;
11534: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11535: p_data => x_msg_data);
11536: WHEN OTHERS THEN

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

11534: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11535: p_data => x_msg_data);
11536: WHEN OTHERS THEN
11537: x_return_status := FND_API.G_RET_STS_ERROR;
11538: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');
11539: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11540: FND_MSG_PUB.ADD;
11541: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11542: p_data => x_msg_data);

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

11535: p_data => x_msg_data);
11536: WHEN OTHERS THEN
11537: x_return_status := FND_API.G_RET_STS_ERROR;
11538: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');
11539: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11540: FND_MSG_PUB.ADD;
11541: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11542: p_data => x_msg_data);
11543: END is_rule_movable;