DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on FND_MSG_PUB

Line 154: -- fnd_msg_pub.initialize;

150: --
151: --PROCEDURE Initialize IS
152: --BEGIN
153: -- SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO gRUN_ID FROM dual;
154: -- fnd_msg_pub.initialize;
155: --END Initialize;
156:
157: --
158: --

Line 181: FND_MSG_PUB.ADD;

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);
184: END add_Error_Message;
185:

Line 182: FND_MSG_PUB.count_and_get(p_count => l_msg_count,

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);
184: END add_Error_Message;
185:
186: --

Line 210: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);

206: p_token_name2 => p_token_name2,
207: p_token_value2 => p_token_value2,
208: p_token_name3 => p_token_name3,
209: p_token_value3 => p_token_value3);
210: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);
211: END handle_Error;
212:
213: --
214: -- handle exception and put error message to FND stack

Line 226: fnd_msg_pub.add_exc_msg('CZ_DEVELOPER_UTILS_PVT', p_procedure_name, x_msg_data);

222: BEGIN
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: x_msg_count := 1;
225: x_msg_data := 'Fatal error : '||p_error_message;
226: fnd_msg_pub.add_exc_msg('CZ_DEVELOPER_UTILS_PVT', p_procedure_name, x_msg_data);
227: END handle_Error;
228:
229: /*
230: * This procedure loops over the objects in a folder checking/logging

Line 311: FND_MSG_PUB.ADD;

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;
315: END IF;

Line 337: FND_MSG_PUB.ADD;

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;
341: END IF;

Line 346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

342:
343: END LOOP;
344: END IF;
345:
346: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
347: p_data => x_msg_data);
348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN

Line 810: FND_MSG_PUB.initialize;

806: l_new_expl_id NUMBER;
807:
808: BEGIN
809:
810: FND_MSG_PUB.initialize;
811: Initialize;
812: l_ps_nodes_tbl.delete;
813: l_persistent_tbl.delete;
814: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1755: FND_MSG_PUB.initialize;

1751: l_class_seq NUMBER;
1752:
1753: BEGIN
1754: IF p_init_msg_list = FND_API.G_TRUE THEN
1755: FND_MSG_PUB.initialize;
1756: END IF;
1757: x_run_id := 0;
1758: x_return_status := FND_API.G_RET_STS_SUCCESS;
1759:

Line 2500: FND_MSG_PUB.initialize;

2496: l_msg_count NUMBER;
2497:
2498: BEGIN
2499: IF p_init_msg_list = FND_API.G_TRUE THEN
2500: FND_MSG_PUB.initialize;
2501: END IF;
2502:
2503: x_run_id := 0;
2504: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3260: fnd_msg_pub.initialize;

3256: l_lock_profile VARCHAR2(3);
3257:
3258: BEGIN
3259:
3260: fnd_msg_pub.initialize;
3261: l_return_status := FND_API.g_ret_sts_success;
3262:
3263: ----check if locking is enabled
3264: ----if the site level profile for locking is not enabled then

Line 3288: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

3284:
3285: -- If there are locked objects, outro, else perform copy operation
3286: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
3287: x_return_status := l_return_status;
3288: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
3289: p_data => x_msg_data);
3290: RETURN;
3291: ELSE
3292: FOR i IN 1..p_folder_ids.COUNT LOOP

Line 3353: fnd_msg_pub.initialize;

3349: BEGIN
3350:
3351: --initialize the message stack depending on the input parameter
3352: IF (p_init_msg_list = FND_API.G_TRUE ) THEN
3353: fnd_msg_pub.initialize;
3354: END IF;
3355:
3356: x_run_id := 0;
3357: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3669: FND_MSG_PUB.initialize;

3665: END process_children;
3666:
3667: BEGIN
3668:
3669: FND_MSG_PUB.initialize;
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;
3671:
3672: --------------------------------------------------
3673: -- Get the node info and return error if BOM node

Line 3884: FND_MSG_PUB.initialize;

3880: AND n.deleted_flag = '0';
3881:
3882: BEGIN
3883:
3884: FND_MSG_PUB.initialize;
3885: x_return_status := FND_API.G_RET_STS_SUCCESS;
3886:
3887: --------------------------
3888: -- get the devl project id

Line 3961: FND_MSG_PUB.ADD;

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;
3965: ELSIF (l_ui_style = CZ_UIOA_PVT.G_OA_STYLE_UI) THEN

Line 3979: FND_MSG_PUB.ADD;

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;
3983: END IF;

Line 4105: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

4101: x_msg_count => x_msg_count,
4102: x_msg_data => x_msg_data);
4103: WHEN DEL_UI_IS_PUBLISHED THEN
4104: x_return_status := FND_API.G_RET_STS_ERROR;
4105: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4106: p_data => x_msg_data);
4107: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);
4108: WHEN OTHERS THEN
4109: handle_Error(p_procedure_name => 'delete_ui_def',

Line 4107: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);

4103: WHEN DEL_UI_IS_PUBLISHED THEN
4104: x_return_status := FND_API.G_RET_STS_ERROR;
4105: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4106: p_data => x_msg_data);
4107: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);
4108: WHEN OTHERS THEN
4109: handle_Error(p_procedure_name => 'delete_ui_def',
4110: p_error_message => SQLERRM,
4111: x_return_status => x_return_status,

Line 4159: FND_MSG_PUB.initialize;

4155: p_del_logically INTEGER:=1;
4156:
4157: BEGIN
4158:
4159: FND_MSG_PUB.initialize;
4160: x_return_status := FND_API.G_RET_STS_SUCCESS;
4161:
4162: --------------------------
4163: -- get the devl project id

Line 4336: FND_MSG_PUB.initialize;

4332: p_del_logically INTEGER:=1;
4333:
4334: BEGIN
4335:
4336: FND_MSG_PUB.initialize;
4337: x_return_status := FND_API.G_RET_STS_SUCCESS;
4338:
4339: --------------------------
4340: -- get the devl project id

Line 4484: FND_MSG_PUB.initialize;

4480: AND deleted_flag = '0';
4481:
4482: BEGIN
4483:
4484: FND_MSG_PUB.initialize;
4485: x_return_status := FND_API.G_RET_STS_SUCCESS;
4486:
4487: IF (p_item_type_id = G_DEFAULT_ITEM_TYPE) THEN
4488: RAISE SEEDED_FLAG_EXCP;

Line 4631: FND_MSG_PUB.initialize;

4627: l_procedure_name CONSTANT VARCHAR2(30) := 'is_model_deleteable';
4628:
4629: BEGIN
4630:
4631: FND_MSG_PUB.initialize;
4632: l_user_name := FND_GLOBAL.user_name;
4633: x_return_status := FND_API.G_RET_STS_SUCCESS;
4634:
4635: ------------------------------

Line 4695: FND_MSG_PUB.ADD;

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;
4699:

Line 4750: FND_MSG_PUB.ADD;

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;
4754: WHEN MODEL_PUBS_EXIST THEN

Line 4751: FND_MSG_PUB.count_and_get(p_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;
4754: WHEN MODEL_PUBS_EXIST THEN
4755: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEL_MODEL_IS_PUBSHD');

Line 4757: FND_MSG_PUB.ADD;

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;
4761: WHEN NO_PRIV THEN

Line 4758: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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;
4761: WHEN NO_PRIV THEN
4762: handle_Error(p_message_name => 'CZ_DEL_MODEL_NO_MODEL_PRIV',

Line 4791: FND_MSG_PUB.initialize;

4787: LOCK_MODEL_EXCP EXCEPTION;
4788: l_locked_model_tbl cz_security_pvt.number_type_tbl;
4789: BEGIN
4790:
4791: FND_MSG_PUB.initialize;
4792:
4793: is_model_deleteable(p_model_id, x_return_status, x_msg_count, x_msg_data);
4794:
4795: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4821: FND_MSG_PUB.ADD;

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
4825: handle_Error(p_procedure_name => 'delete_model',

Line 4823: x_msg_data := fnd_msg_pub.GET(x_msg_count,fnd_api.g_false);

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
4825: handle_Error(p_procedure_name => 'delete_model',
4826: p_error_message => SQLERRM,
4827: x_return_status => x_return_status,

Line 4861: FND_MSG_PUB.initialize;

4857: USER_IS_NULL_EXCP EXCEPTION;
4858: usageID NUMBER := 0;
4859: l_usage_name cz_model_usages.name%TYPE;
4860: BEGIN
4861: FND_MSG_PUB.initialize;
4862: x_return_status := FND_API.G_RET_STS_SUCCESS;
4863: new_usage (p_encl_folder_id,usageID);
4864: IF (usageID = -2) THEN
4865: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5070: FND_MSG_PUB.initialize;

5066: INVALID_EFF_SET_ID_EXCP EXCEPTION;
5067: USER_IS_NULL_EXCP EXCEPTION;
5068: l_name cz_rp_entries.name%TYPE;
5069: BEGIN
5070: FND_MSG_PUB.initialize;
5071: x_return_status := FND_API.G_RET_STS_SUCCESS;
5072: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');
5073: l_name := copy_name(p_effectivity_set_id,'EFF');
5074: INSERT INTO CZ_RP_ENTRIES

Line 5789: FND_MSG_PUB.initialize;

5785: jrad_save_status PLS_INTEGER;
5786: g_jrad_trans_list jdr_utils.translationlist := jdr_utils.translationlist();
5787: l_exportfinished BOOLEAN;
5788: BEGIN
5789: FND_MSG_PUB.initialize;
5790: x_return_status := FND_API.G_RET_STS_SUCCESS;
5791: jdr_docbuilder.refresh;
5792:
5793: IF (p_old_document_name IS NULL) THEN

Line 5913: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

5909: NULL;
5910:
5911: WHEN COPY_RULE_FAILURE THEN
5912: x_return_status := FND_API.G_RET_STS_ERROR;
5913: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
5914: p_data => x_msg_data);
5915: RAISE;
5916: WHEN OTHERS THEN
5917: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5918: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

5914: p_data => x_msg_data);
5915: RAISE;
5916: WHEN OTHERS THEN
5917: x_return_status := FND_API.G_RET_STS_ERROR;
5918: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
5919: p_data => x_msg_data);
5920: RAISE;
5921: END replace_global_ids_in_XML ;
5922:

Line 6146: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

6142: x_return_status := FND_API.G_RET_STS_ERROR;
6143: add_error_message(p_message_name => 'CZ_CP_CANNOT_LOC_UCT',
6144: p_token_name1 => 'UICTNAME',
6145: p_token_value1 => l_template_name);
6146: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
6147: p_data => x_msg_data);
6148: WHEN OTHERS THEN
6149: handle_Error(p_procedure_name => 'copy_ui_template',
6150: p_error_message => SQLERRM,

Line 6436: FND_MSG_PUB.initialize;

6432: l_eff_set_id NUMBER;
6433: l_eff_name VARCHAR2(255);
6434:
6435: BEGIN
6436: FND_MSG_PUB.initialize;
6437: x_return_status := FND_API.G_RET_STS_SUCCESS;
6438: x_msg_count := 0;
6439: x_msg_data := '';
6440:

Line 6468: FND_MSG_PUB.ADD;

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);
6472: END IF;

Line 6470: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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);
6472: END IF;
6473: EXCEPTION
6474: WHEN NO_DATA_FOUND THEN

Line 6497: FND_MSG_PUB.initialize;

6493: l_msg_count NUMBER;
6494: l_msg_data VARCHAR2(2000);
6495:
6496: BEGIN
6497: FND_MSG_PUB.initialize;
6498: x_return_status := FND_API.G_RET_STS_SUCCESS;
6499: x_msg_count := 0;
6500: x_msg_data := '';
6501:

Line 6543: FND_MSG_PUB.initialize;

6539: l_object_name cz_rp_entries.name%TYPE;
6540: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6541: l_devl_name cz_devl_projects.name%TYPE;
6542: BEGIN
6543: FND_MSG_PUB.initialize;
6544: x_return_status := FND_API.G_RET_STS_SUCCESS;
6545: x_msg_count := 0;
6546: x_msg_data := '';
6547:

Line 6631: FND_MSG_PUB.initialize;

6627: l_msg_count NUMBER := 0;
6628: l_msg_data VARCHAR2(2000);
6629:
6630: BEGIN
6631: FND_MSG_PUB.initialize;
6632: x_return_status := FND_API.G_RET_STS_SUCCESS;
6633: x_msg_count := 0;
6634: x_msg_data := '';
6635:

Line 6683: FND_MSG_PUB.initialize;

6679:
6680: PROPERTY_IN_USE EXCEPTION;
6681:
6682: BEGIN
6683: FND_MSG_PUB.initialize;
6684: x_return_status := FND_API.G_RET_STS_SUCCESS;
6685: x_msg_count := 0;
6686: x_msg_data := '';
6687:

Line 6795: FND_MSG_PUB.initialize;

6791: l_msg_count NUMBER := 0;
6792: l_msg_data VARCHAR2(2000);
6793:
6794: BEGIN
6795: FND_MSG_PUB.initialize;
6796: x_return_status := FND_API.G_RET_STS_SUCCESS;
6797: x_msg_count := 0;
6798: x_msg_data := '';
6799:

Line 6842: FND_MSG_PUB.initialize;

6838: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6839: l_ui_name_tbl ui_name_tbl;
6840:
6841: BEGIN
6842: FND_MSG_PUB.initialize;
6843: ----check if p_umt_id exists
6844: x_return_status := FND_API.G_RET_STS_SUCCESS;
6845: x_msg_count := 0;
6846: x_msg_data := '';

Line 6890: FND_MSG_PUB.ADD;

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);
6894: END IF;

Line 6892: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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);
6894: END IF;
6895:
6896: EXCEPTION

Line 6926: FND_MSG_PUB.initialize;

6922: l_msg_count NUMBER := 0;
6923: l_msg_data VARCHAR2(2000);
6924:
6925: BEGIN
6926: FND_MSG_PUB.initialize;
6927: x_return_status := FND_API.G_RET_STS_SUCCESS;
6928: x_msg_count := 0;
6929: x_msg_data := '';
6930:

Line 6979: FND_MSG_PUB.initialize;

6975: l_ref_templ_ui_tbl num_type_tbl;
6976: l_ref_template_name cz_ui_templates.template_name%TYPE;
6977:
6978: BEGIN
6979: FND_MSG_PUB.initialize;
6980: x_return_status := FND_API.G_RET_STS_SUCCESS;
6981: x_msg_count := 0;
6982: x_msg_data := '';
6983:

Line 7043: FND_MSG_PUB.ADD;

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;
7046:
7047: BEGIN

Line 7077: FND_MSG_PUB.ADD;

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;
7081: END IF;

Line 7082: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

7078: x_return_status := FND_API.G_RET_STS_ERROR;
7079: END IF;
7080: END LOOP;
7081: END IF;
7082: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
7083: p_data => x_msg_data);
7084: EXCEPTION
7085: WHEN OBJECT_NOT_FOUND THEN
7086: NULL;

Line 7117: FND_MSG_PUB.initialize;

7113: l_template_name cz_ui_templates.template_name%TYPE;
7114: FAILED_TO_LOCK_UCT EXCEPTION;
7115:
7116: BEGIN
7117: FND_MSG_PUB.initialize;
7118: x_return_status := FND_API.G_RET_STS_SUCCESS;
7119: x_msg_count := 0;
7120: x_msg_data := '';
7121:

Line 7161: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

7157: x_return_status := FND_API.G_RET_STS_ERROR;
7158: add_error_message(p_message_name => 'CZ_CANNOT_LOC_UCT',
7159: p_token_name1 => 'UCTNAME',
7160: p_token_value1 => l_template_name);
7161: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
7162: p_data => x_msg_data);
7163: WHEN OTHERS THEN
7164: handle_Error(p_procedure_name => 'delete_uct',
7165: p_error_message => SQLERRM,

Line 7295: FND_MSG_PUB.initialize;

7291: v_masks_nodes t_mask;
7292: v_masks_rules t_mask;
7293: l_usage_name cz_model_usages.name%TYPE;
7294: BEGIN
7295: FND_MSG_PUB.initialize;
7296: x_return_status := FND_API.G_RET_STS_SUCCESS;
7297: x_msg_count := 0;
7298: x_msg_data := '';
7299:

Line 7399: FND_MSG_PUB.ADD;

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);
7403: WHEN OTHERS THEN

Line 7401: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

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);
7403: WHEN OTHERS THEN
7404: handle_Error(p_message_name => 'CZ_DEL_USG_FATAL_ERR',
7405: p_token_name1 => 'USAGE',

Line 7426: FND_MSG_PUB.initialize;

7422: v_last_old_mask VARCHAR2(16);
7423: v_first_index BINARY_INTEGER;
7424:
7425: BEGIN
7426: FND_MSG_PUB.initialize;
7427: v_nodes.DELETE;
7428: v_rules.DELETE;
7429: v_masks_nodes.DELETE;
7430: v_masks_rules.DELETE;

Line 7541: FND_MSG_PUB.initialize;

7537: l_msg_count NUMBER := 0;
7538: l_msg_data VARCHAR2(2000);
7539: DEL_USG_ERR EXCEPTION;
7540: BEGIN
7541: FND_MSG_PUB.initialize;
7542: x_return_status := FND_API.G_RET_STS_SUCCESS;
7543: x_msg_count := 0;
7544: x_msg_data := '';
7545:

Line 7668: FND_MSG_PUB.initialize;

7664: l_ref_templ_ui_tbl number_type_tbl;
7665: l_ref_template_name cz_ui_templates.template_name%TYPE;
7666:
7667: BEGIN
7668: FND_MSG_PUB.initialize;
7669: x_return_status := FND_API.g_ret_sts_success;
7670: x_msg_count := 0;
7671: x_msg_data := '';
7672:

Line 7724: FND_MSG_PUB.ADD;

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;
7728: l_rp_model_ref(rec_count) := l_rp_model_tbl(j);

Line 7851: FND_MSG_PUB.ADD;

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;
7855: l_uct_ref(rec_count) := l_uct_tbl(j);

Line 7896: FND_MSG_PUB.ADD;

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:
7900: l_publication_tbl.DELETE;

Line 7918: FND_MSG_PUB.ADD;

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;
7922: END LOOP;

Line 7999: FND_MSG_PUB.ADD;

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;
8003: EXCEPTION

Line 8047: FND_MSG_PUB.ADD;

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;
8051: EXCEPTION

Line 8100: FND_MSG_PUB.ADD;

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;
8104: END IF;

Line 8124: FND_MSG_PUB.ADD;

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
8128: SELECT 1

Line 8141: FND_MSG_PUB.ADD;

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
8145: NULL;

Line 8181: FND_MSG_PUB.ADD;

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;
8185: EXCEPTION

Line 8231: FND_MSG_PUB.ADD;

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
8235:

Line 8268: FND_MSG_PUB.ADD;

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;
8272: END IF;

Line 8308: FND_MSG_PUB.ADD;

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;
8312:

Line 8359: FND_MSG_PUB.ADD;

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;
8363: END IF;

Line 8380: FND_MSG_PUB.ADD;

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;
8384: END IF;

Line 8393: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

8389: NULL;
8390: END;
8391: END LOOP;
8392: END IF;
8393: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
8394: p_data => x_msg_data);
8395: EXCEPTION
8396: WHEN NO_DATA_FOUND THEN
8397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8423: FND_MSG_PUB.initialize;

8419: l_template_name cz_ui_templates.template_name%TYPE;
8420: l_count NUMBER := 0;
8421:
8422: BEGIN
8423: FND_MSG_PUB.initialize;
8424: x_return_status := FND_API.g_ret_sts_success;
8425: x_msg_count := 0;
8426: x_msg_data := '';
8427:

Line 11484: fnd_msg_pub.initialize;

11480: l_rule_fld_tbl t_ref;
11481:
11482: BEGIN
11483: x_return_status := FND_API.G_RET_STS_SUCCESS;
11484: fnd_msg_pub.initialize;
11485:
11486: BEGIN
11487: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11488: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id

Line 11571: FND_MSG_PUB.ADD;

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
11575: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11572: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11575: x_return_status := FND_API.G_RET_STS_ERROR;
11576: FND_MESSAGE.SET_NAME('CZ', 'CZ_SRCRULE_IS_DELETED');

Line 11577: FND_MSG_PUB.ADD;

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
11581: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11578: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11581: x_return_status := FND_API.G_RET_STS_ERROR;
11582: FND_MESSAGE.SET_NAME('CZ', 'CZ_TGTRULEFLD_DOES_NOT_EXIST');

Line 11583: FND_MSG_PUB.ADD;

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
11587: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11584: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11587: x_return_status := FND_API.G_RET_STS_ERROR;
11588: FND_MESSAGE.SET_NAME('CZ', 'CZ_INVALID_CIRCULAR_MOVE');

Line 11589: FND_MSG_PUB.ADD;

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
11593: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11590: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11593: x_return_status := FND_API.G_RET_STS_ERROR;
11594: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_FOLDER_SEQ_INCOMPAT_ERR');

Line 11595: FND_MSG_PUB.ADD;

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
11599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11596: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11599: x_return_status := FND_API.G_RET_STS_ERROR;
11600: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');

Line 11601: FND_MSG_PUB.ADD;

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
11605: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11602: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11605: x_return_status := FND_API.G_RET_STS_ERROR;
11606: FND_MESSAGE.SET_NAME('CZ', 'CZ_CAN_MOVE_IN_SAME_PROJECT');

Line 11607: FND_MSG_PUB.ADD;

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
11611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 11608: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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
11611: x_return_status := FND_API.G_RET_STS_ERROR;
11612: FND_MESSAGE.SET_NAME('CZ', 'CZ_CANNOT_MOVE_TO_THIS_FLD');

Line 11614: FND_MSG_PUB.ADD;

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;
11618: ---------------------------------------------------------------------------------------

Line 11615: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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;
11618: ---------------------------------------------------------------------------------------
11619: /*#