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 807: FND_MSG_PUB.initialize;

803: l_new_expl_id NUMBER;
804:
805: BEGIN
806:
807: FND_MSG_PUB.initialize;
808: Initialize;
809: l_ps_nodes_tbl.delete;
810: l_persistent_tbl.delete;
811: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1727: FND_MSG_PUB.initialize;

1723: l_class_seq NUMBER;
1724:
1725: BEGIN
1726: IF p_init_msg_list = FND_API.G_TRUE THEN
1727: FND_MSG_PUB.initialize;
1728: END IF;
1729: x_run_id := 0;
1730: x_return_status := FND_API.G_RET_STS_SUCCESS;
1731:

Line 2472: FND_MSG_PUB.initialize;

2468: l_msg_count NUMBER;
2469:
2470: BEGIN
2471: IF p_init_msg_list = FND_API.G_TRUE THEN
2472: FND_MSG_PUB.initialize;
2473: END IF;
2474:
2475: x_run_id := 0;
2476: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3232: fnd_msg_pub.initialize;

3228: l_lock_profile VARCHAR2(3);
3229:
3230: BEGIN
3231:
3232: fnd_msg_pub.initialize;
3233: l_return_status := FND_API.g_ret_sts_success;
3234:
3235: ----check if locking is enabled
3236: ----if the site level profile for locking is not enabled then

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

3256:
3257: -- If there are locked objects, outro, else perform copy operation
3258: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
3259: x_return_status := l_return_status;
3260: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
3261: p_data => x_msg_data);
3262: RETURN;
3263: ELSE
3264: FOR i IN 1..p_folder_ids.COUNT LOOP

Line 3325: fnd_msg_pub.initialize;

3321: BEGIN
3322:
3323: --initialize the message stack depending on the input parameter
3324: IF (p_init_msg_list = FND_API.G_TRUE ) THEN
3325: fnd_msg_pub.initialize;
3326: END IF;
3327:
3328: x_run_id := 0;
3329: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3641: FND_MSG_PUB.initialize;

3637: END process_children;
3638:
3639: BEGIN
3640:
3641: FND_MSG_PUB.initialize;
3642: x_return_status := FND_API.G_RET_STS_SUCCESS;
3643:
3644: --------------------------------------------------
3645: -- Get the node info and return error if BOM node

Line 3856: FND_MSG_PUB.initialize;

3852: AND n.deleted_flag = '0';
3853:
3854: BEGIN
3855:
3856: FND_MSG_PUB.initialize;
3857: x_return_status := FND_API.G_RET_STS_SUCCESS;
3858:
3859: --------------------------
3860: -- get the devl project id

Line 3933: FND_MSG_PUB.ADD;

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

Line 3951: FND_MSG_PUB.ADD;

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

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

4073: x_msg_count => x_msg_count,
4074: x_msg_data => x_msg_data);
4075: WHEN DEL_UI_IS_PUBLISHED THEN
4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4078: p_data => x_msg_data);
4079: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);
4080: WHEN OTHERS THEN
4081: handle_Error(p_procedure_name => 'delete_ui_def',

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

4075: WHEN DEL_UI_IS_PUBLISHED THEN
4076: x_return_status := FND_API.G_RET_STS_ERROR;
4077: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
4078: p_data => x_msg_data);
4079: x_msg_data := fnd_msg_pub.GET(1,fnd_api.g_false);
4080: WHEN OTHERS THEN
4081: handle_Error(p_procedure_name => 'delete_ui_def',
4082: p_error_message => SQLERRM,
4083: x_return_status => x_return_status,

Line 4131: FND_MSG_PUB.initialize;

4127: p_del_logically INTEGER:=1;
4128:
4129: BEGIN
4130:
4131: FND_MSG_PUB.initialize;
4132: x_return_status := FND_API.G_RET_STS_SUCCESS;
4133:
4134: --------------------------
4135: -- get the devl project id

Line 4308: FND_MSG_PUB.initialize;

4304: p_del_logically INTEGER:=1;
4305:
4306: BEGIN
4307:
4308: FND_MSG_PUB.initialize;
4309: x_return_status := FND_API.G_RET_STS_SUCCESS;
4310:
4311: --------------------------
4312: -- get the devl project id

Line 4456: FND_MSG_PUB.initialize;

4452: AND deleted_flag = '0';
4453:
4454: BEGIN
4455:
4456: FND_MSG_PUB.initialize;
4457: x_return_status := FND_API.G_RET_STS_SUCCESS;
4458:
4459: IF (p_item_type_id = G_DEFAULT_ITEM_TYPE) THEN
4460: RAISE SEEDED_FLAG_EXCP;

Line 4603: FND_MSG_PUB.initialize;

4599: l_procedure_name CONSTANT VARCHAR2(30) := 'is_model_deleteable';
4600:
4601: BEGIN
4602:
4603: FND_MSG_PUB.initialize;
4604: l_user_name := FND_GLOBAL.user_name;
4605: x_return_status := FND_API.G_RET_STS_SUCCESS;
4606:
4607: ------------------------------

Line 4667: FND_MSG_PUB.ADD;

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

Line 4722: FND_MSG_PUB.ADD;

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

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

Line 4729: FND_MSG_PUB.ADD;

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

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

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

Line 4763: FND_MSG_PUB.initialize;

4759: LOCK_MODEL_EXCP EXCEPTION;
4760: l_locked_model_tbl cz_security_pvt.number_type_tbl;
4761: BEGIN
4762:
4763: FND_MSG_PUB.initialize;
4764:
4765: is_model_deleteable(p_model_id, x_return_status, x_msg_count, x_msg_data);
4766:
4767: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 4792: FND_MSG_PUB.ADD;

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

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

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
4796: handle_Error(p_procedure_name => 'delete_model',
4797: p_error_message => SQLERRM,
4798: x_return_status => x_return_status,

Line 4832: FND_MSG_PUB.initialize;

4828: USER_IS_NULL_EXCP EXCEPTION;
4829: usageID NUMBER := 0;
4830: l_usage_name cz_model_usages.name%TYPE;
4831: BEGIN
4832: FND_MSG_PUB.initialize;
4833: x_return_status := FND_API.G_RET_STS_SUCCESS;
4834: new_usage (p_encl_folder_id,usageID);
4835: IF (usageID = -2) THEN
4836: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5041: FND_MSG_PUB.initialize;

5037: INVALID_EFF_SET_ID_EXCP EXCEPTION;
5038: USER_IS_NULL_EXCP EXCEPTION;
5039: l_name cz_rp_entries.name%TYPE;
5040: BEGIN
5041: FND_MSG_PUB.initialize;
5042: x_return_status := FND_API.G_RET_STS_SUCCESS;
5043: x_new_effectivity_set_id := allocateId('CZ_EFFECTIVITY_SETS_S');
5044: l_name := copy_name(p_effectivity_set_id,'EFF');
5045: INSERT INTO CZ_RP_ENTRIES

Line 5760: FND_MSG_PUB.initialize;

5756: jrad_save_status PLS_INTEGER;
5757: g_jrad_trans_list jdr_utils.translationlist := jdr_utils.translationlist();
5758: l_exportfinished BOOLEAN;
5759: BEGIN
5760: FND_MSG_PUB.initialize;
5761: x_return_status := FND_API.G_RET_STS_SUCCESS;
5762: jdr_docbuilder.refresh;
5763:
5764: IF (p_old_document_name IS NULL) THEN

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

5880: NULL;
5881:
5882: WHEN COPY_RULE_FAILURE THEN
5883: x_return_status := FND_API.G_RET_STS_ERROR;
5884: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
5885: p_data => x_msg_data);
5886: RAISE;
5887: WHEN OTHERS THEN
5888: x_return_status := FND_API.G_RET_STS_ERROR;

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

5885: p_data => x_msg_data);
5886: RAISE;
5887: WHEN OTHERS THEN
5888: x_return_status := FND_API.G_RET_STS_ERROR;
5889: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
5890: p_data => x_msg_data);
5891: RAISE;
5892: END replace_global_ids_in_XML ;
5893:

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

6113: x_return_status := FND_API.G_RET_STS_ERROR;
6114: add_error_message(p_message_name => 'CZ_CP_CANNOT_LOC_UCT',
6115: p_token_name1 => 'UICTNAME',
6116: p_token_value1 => l_template_name);
6117: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
6118: p_data => x_msg_data);
6119: WHEN OTHERS THEN
6120: handle_Error(p_procedure_name => 'copy_ui_template',
6121: p_error_message => SQLERRM,

Line 6407: FND_MSG_PUB.initialize;

6403: l_eff_set_id NUMBER;
6404: l_eff_name VARCHAR2(255);
6405:
6406: BEGIN
6407: FND_MSG_PUB.initialize;
6408: x_return_status := FND_API.G_RET_STS_SUCCESS;
6409: x_msg_count := 0;
6410: x_msg_data := '';
6411:

Line 6439: FND_MSG_PUB.ADD;

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

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

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);
6443: END IF;
6444: EXCEPTION
6445: WHEN NO_DATA_FOUND THEN

Line 6468: FND_MSG_PUB.initialize;

6464: l_msg_count NUMBER;
6465: l_msg_data VARCHAR2(2000);
6466:
6467: BEGIN
6468: FND_MSG_PUB.initialize;
6469: x_return_status := FND_API.G_RET_STS_SUCCESS;
6470: x_msg_count := 0;
6471: x_msg_data := '';
6472:

Line 6514: FND_MSG_PUB.initialize;

6510: l_object_name cz_rp_entries.name%TYPE;
6511: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
6512: l_devl_name cz_devl_projects.name%TYPE;
6513: BEGIN
6514: FND_MSG_PUB.initialize;
6515: x_return_status := FND_API.G_RET_STS_SUCCESS;
6516: x_msg_count := 0;
6517: x_msg_data := '';
6518:

Line 6602: FND_MSG_PUB.initialize;

6598: l_msg_count NUMBER := 0;
6599: l_msg_data VARCHAR2(2000);
6600:
6601: BEGIN
6602: FND_MSG_PUB.initialize;
6603: x_return_status := FND_API.G_RET_STS_SUCCESS;
6604: x_msg_count := 0;
6605: x_msg_data := '';
6606:

Line 6654: FND_MSG_PUB.initialize;

6650:
6651: PROPERTY_IN_USE EXCEPTION;
6652:
6653: BEGIN
6654: FND_MSG_PUB.initialize;
6655: x_return_status := FND_API.G_RET_STS_SUCCESS;
6656: x_msg_count := 0;
6657: x_msg_data := '';
6658:

Line 6766: FND_MSG_PUB.initialize;

6762: l_msg_count NUMBER := 0;
6763: l_msg_data VARCHAR2(2000);
6764:
6765: BEGIN
6766: FND_MSG_PUB.initialize;
6767: x_return_status := FND_API.G_RET_STS_SUCCESS;
6768: x_msg_count := 0;
6769: x_msg_data := '';
6770:

Line 6813: FND_MSG_PUB.initialize;

6809: TYPE ui_name_tbl is TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
6810: l_ui_name_tbl ui_name_tbl;
6811:
6812: BEGIN
6813: FND_MSG_PUB.initialize;
6814: ----check if p_umt_id exists
6815: x_return_status := FND_API.G_RET_STS_SUCCESS;
6816: x_msg_count := 0;
6817: x_msg_data := '';

Line 6861: FND_MSG_PUB.ADD;

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

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

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);
6865: END IF;
6866:
6867: EXCEPTION

Line 6897: FND_MSG_PUB.initialize;

6893: l_msg_count NUMBER := 0;
6894: l_msg_data VARCHAR2(2000);
6895:
6896: BEGIN
6897: FND_MSG_PUB.initialize;
6898: x_return_status := FND_API.G_RET_STS_SUCCESS;
6899: x_msg_count := 0;
6900: x_msg_data := '';
6901:

Line 6950: FND_MSG_PUB.initialize;

6946: l_ref_templ_ui_tbl num_type_tbl;
6947: l_ref_template_name cz_ui_templates.template_name%TYPE;
6948:
6949: BEGIN
6950: FND_MSG_PUB.initialize;
6951: x_return_status := FND_API.G_RET_STS_SUCCESS;
6952: x_msg_count := 0;
6953: x_msg_data := '';
6954:

Line 7014: FND_MSG_PUB.ADD;

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;
7017:
7018: BEGIN

Line 7048: FND_MSG_PUB.ADD;

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

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

7049: x_return_status := FND_API.G_RET_STS_ERROR;
7050: END IF;
7051: END LOOP;
7052: END IF;
7053: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
7054: p_data => x_msg_data);
7055: EXCEPTION
7056: WHEN OBJECT_NOT_FOUND THEN
7057: NULL;

Line 7086: FND_MSG_PUB.initialize;

7082: l_msg_count NUMBER := 0;
7083: l_msg_data VARCHAR2(2000);
7084:
7085: BEGIN
7086: FND_MSG_PUB.initialize;
7087: x_return_status := FND_API.G_RET_STS_SUCCESS;
7088: x_msg_count := 0;
7089: x_msg_data := '';
7090:

Line 7242: FND_MSG_PUB.initialize;

7238: v_masks_nodes t_mask;
7239: v_masks_rules t_mask;
7240: l_usage_name cz_model_usages.name%TYPE;
7241: BEGIN
7242: FND_MSG_PUB.initialize;
7243: x_return_status := FND_API.G_RET_STS_SUCCESS;
7244: x_msg_count := 0;
7245: x_msg_data := '';
7246:

Line 7346: FND_MSG_PUB.ADD;

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

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

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);
7350: WHEN OTHERS THEN
7351: handle_Error(p_message_name => 'CZ_DEL_USG_FATAL_ERR',
7352: p_token_name1 => 'USAGE',

Line 7373: FND_MSG_PUB.initialize;

7369: v_last_old_mask VARCHAR2(16);
7370: v_first_index BINARY_INTEGER;
7371:
7372: BEGIN
7373: FND_MSG_PUB.initialize;
7374: v_nodes.DELETE;
7375: v_rules.DELETE;
7376: v_masks_nodes.DELETE;
7377: v_masks_rules.DELETE;

Line 7488: FND_MSG_PUB.initialize;

7484: l_msg_count NUMBER := 0;
7485: l_msg_data VARCHAR2(2000);
7486: DEL_USG_ERR EXCEPTION;
7487: BEGIN
7488: FND_MSG_PUB.initialize;
7489: x_return_status := FND_API.G_RET_STS_SUCCESS;
7490: x_msg_count := 0;
7491: x_msg_data := '';
7492:

Line 7610: FND_MSG_PUB.initialize;

7606: l_user_name cz_devl_projects.checkout_user%TYPE;
7607: l_devl_prj_name_tbl name_tbl;
7608: l_template_name_tbl name_tbl;
7609: BEGIN
7610: FND_MSG_PUB.initialize;
7611: x_return_status := FND_API.g_ret_sts_success;
7612: x_msg_count := 0;
7613: x_msg_data := '';
7614:

Line 7666: FND_MSG_PUB.ADD;

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

Line 7793: FND_MSG_PUB.ADD;

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

Line 7838: FND_MSG_PUB.ADD;

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

Line 7860: FND_MSG_PUB.ADD;

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

Line 7941: FND_MSG_PUB.ADD;

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

Line 7989: FND_MSG_PUB.ADD;

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

Line 8042: FND_MSG_PUB.ADD;

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

Line 8066: FND_MSG_PUB.ADD;

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

Line 8083: FND_MSG_PUB.ADD;

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

Line 8120: FND_MSG_PUB.ADD;

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

Line 8162: FND_MSG_PUB.ADD;

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
8166: WHEN NO_DATA_FOUND THEN

Line 8199: FND_MSG_PUB.ADD;

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

Line 8250: FND_MSG_PUB.ADD;

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

Line 8271: FND_MSG_PUB.ADD;

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

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

8280: NULL;
8281: END;
8282: END LOOP;
8283: END IF;
8284: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
8285: p_data => x_msg_data);
8286: EXCEPTION
8287: WHEN NO_DATA_FOUND THEN
8288: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8315: FND_MSG_PUB.initialize;

8311: l_count NUMBER := 0;
8312: FAILED_TO_LOCK_PRJ EXCEPTION;
8313: FAILED_TO_LOCK_UCT EXCEPTION;
8314: BEGIN
8315: FND_MSG_PUB.initialize;
8316: x_return_status := FND_API.g_ret_sts_success;
8317: x_msg_count := 0;
8318: x_msg_data := '';
8319:

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

8442: x_return_status := FND_API.G_RET_STS_ERROR;
8443: add_error_message(p_message_name => 'CZ_CANNOT_LOC_PRJ',
8444: p_token_name1 => 'PRJNAME',
8445: p_token_value1 => l_model_name);
8446: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
8447: p_data => x_msg_data);
8448: WHEN FAILED_TO_LOCK_UCT THEN
8449: x_return_status := FND_API.G_RET_STS_ERROR;
8450: add_error_message(p_message_name => 'CZ_CANNOT_LOC_UCT',

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

8449: x_return_status := FND_API.G_RET_STS_ERROR;
8450: add_error_message(p_message_name => 'CZ_CANNOT_LOC_UCT',
8451: p_token_name1 => 'UCTNAME',
8452: p_token_value1 => l_template_name);
8453: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
8454: p_data => x_msg_data);
8455: WHEN OTHERS THEN
8456: handle_Error(p_procedure_name => 'delete_repository_folder',
8457: p_error_message => SQLERRM,

Line 11410: fnd_msg_pub.initialize;

11406: l_rule_fld_tbl t_ref;
11407:
11408: BEGIN
11409: x_return_status := FND_API.G_RET_STS_SUCCESS;
11410: fnd_msg_pub.initialize;
11411:
11412: BEGIN
11413: SELECT rule_folder_id,object_type,deleted_flag,parent_rule_folder_id,devl_project_id
11414: INTO l_src_rule_id,l_src_object_type,l_deleted_flag,l_parent_rule_folder_id,l_src_devl_project_id

Line 11497: FND_MSG_PUB.ADD;

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

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

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

Line 11503: FND_MSG_PUB.ADD;

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

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

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

Line 11509: FND_MSG_PUB.ADD;

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

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

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

Line 11515: FND_MSG_PUB.ADD;

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

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

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

Line 11521: FND_MSG_PUB.ADD;

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

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

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

Line 11527: FND_MSG_PUB.ADD;

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

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

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

Line 11533: FND_MSG_PUB.ADD;

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

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

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

Line 11540: FND_MSG_PUB.ADD;

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

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

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;
11544: ---------------------------------------------------------------------------------------
11545: /*#