APPS.CZ_DEVELOPER_UTILS_PVT dependencies on FND_API

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2) IS
200: BEGIN
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: x_msg_count := 1;
203: add_Error_Message(p_message_name => p_message_name,
204: p_token_name1 => p_token_name1,
205: p_token_value1 => p_token_value1,

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

219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2) IS
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;

Line 260: x_return_status := FND_API.g_ret_sts_success;

256: l_template_name_tbl name_tbl;
257:
258: BEGIN
259:
260: x_return_status := FND_API.g_ret_sts_success;
261: x_msg_count := 0;
262: x_msg_data := '';
263:
264: l_user_name := FND_GLOBAL.user_name;

Line 312: x_return_status := FND_API.g_ret_sts_error;

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

Line 338: x_return_status := FND_API.g_ret_sts_error;

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

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: p_data => x_msg_data);
348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352: WHEN OTHERS THEN
353: handle_Error(p_procedure_name => 'check_folder_for_locks',
354: p_error_message => SQLERRM,
355: x_return_status => x_return_status,

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
815:
816: -- get the info from the node to be copied
817: SELECT devl_project_id,parent_id,reference_id,component_id,virtual_flag,ps_node_type
818: INTO l_model_id,l_parent_id,l_reference_id,l_component_id,l_virtual_flag,l_ps_node_type

Line 1395: FND_API.G_FALSE,

1391: IF (l_copy_rule = TRUE AND (l_rule_type_tbl(i) = RULE_TYPE_JAVA_METHOD OR l_rule_nodes_tbl.COUNT > 0)) THEN
1392:
1393: copy_Rule(l_rule_id_tbl(i),
1394: l_rule_folder_id_tbl(i),
1395: FND_API.G_FALSE,
1396: l_new_rule_id,
1397: x_run_id,
1398: l_return_status,
1399: l_msg_count,

Line 1754: IF p_init_msg_list = FND_API.G_TRUE THEN

1750: l_model_ref_expl_id NUMBER;
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;

Line 1758: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1760: SELECT devl_project_id,rule_folder_id, rule_type, seeded_flag
1761: INTO l_model_id,l_rule_folder_id, l_rule_type, l_seeded_flag
1762: FROM CZ_RULES

Line 2432: p_init_msg_list => FND_API.G_TRUE,

2428: BEGIN
2429:
2430: copy_Rule(p_rule_id => p_rule_id,
2431: p_rule_folder_id => p_rule_folder_id,
2432: p_init_msg_list => FND_API.G_TRUE,
2433: x_out_new_rule_id => x_out_new_rule_id,
2434: x_run_id => x_run_id,
2435: x_return_status => x_return_status,
2436: x_msg_count => x_msg_count,

Line 2499: IF p_init_msg_list = FND_API.G_TRUE THEN

2495: l_return_status VARCHAR2(255);
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;

Line 2504: x_return_status := FND_API.G_RET_STS_SUCCESS;

2500: FND_MSG_PUB.initialize;
2501: END IF;
2502:
2503: x_run_id := 0;
2504: x_return_status := FND_API.G_RET_STS_SUCCESS;
2505:
2506: --
2507: -- check global flag that equals '1' if model is already locked
2508: -- by calling sequirity package

Line 2590: ,p_init_msg_list => FND_API.G_FALSE

2586: LOOP
2587: IF i.object_type IN ('RFL', 'RSQ') THEN
2588: copy_rule_folder(p_rule_folder_id => i.rule_folder_id
2589: ,p_new_parent_folder_id => x_out_rule_folder_id
2590: ,p_init_msg_list => FND_API.G_FALSE
2591: ,x_out_rule_folder_id => l_rule_folder_id
2592: ,x_run_id => x_run_id
2593: ,x_return_status => x_return_status
2594: ,x_msg_count => x_msg_count

Line 2599: p_init_msg_list => FND_API.G_FALSE,

2595: ,x_msg_data => x_msg_data);
2596: ELSE
2597: copy_Rule(p_rule_id => i.rule_folder_id,
2598: p_rule_folder_id => x_out_rule_folder_id,
2599: p_init_msg_list => FND_API.G_FALSE,
2600: x_out_new_rule_id => l_rule_id,
2601: x_run_id => x_run_id,
2602: x_return_status => x_return_status,
2603: x_msg_count => x_msg_count,

Line 2607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2603: x_msg_count => x_msg_count,
2604: x_msg_data => x_msg_data);
2605: END IF;
2606:
2607: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2608: RETURN;
2609: END IF;
2610: END LOOP;
2611:

Line 2631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2627: l_locked_entities_tbl,
2628: x_return_status,
2629: x_msg_count,
2630: x_msg_data);
2631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2632: x_run_id := GetRunID;
2633: LOG_REPORT(x_run_id,x_msg_count);
2634: RETURN;
2635: END IF;

Line 2664: ,p_init_msg_list => FND_API.G_TRUE

2660:
2661: BEGIN
2662: copy_rule_folder(p_rule_folder_id => p_rule_folder_id
2663: ,p_new_parent_folder_id => p_new_parent_folder_id
2664: ,p_init_msg_list => FND_API.G_TRUE
2665: ,x_out_rule_folder_id => x_out_rule_folder_id
2666: ,x_run_id => x_run_id
2667: ,x_return_status => x_return_status
2668: ,x_msg_count => x_msg_count

Line 3261: l_return_status := FND_API.g_ret_sts_success;

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
3265: ----there is no need to check for locked objects in the folder

Line 3279: IF (l_return_status = FND_API.g_ret_sts_success AND x_return_status <> FND_API.g_ret_sts_success) THEN

3275: x_msg_data);
3276:
3277: -- Need to store status as we are looping and the status will get overwritten for
3278: -- each folder.
3279: IF (l_return_status = FND_API.g_ret_sts_success AND x_return_status <> FND_API.g_ret_sts_success) THEN
3280: l_return_status := x_return_status;
3281: END IF;
3282: END LOOP;
3283: END IF;

Line 3286: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

3282: END LOOP;
3283: END IF;
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;

Line 3304: FND_API.G_FALSE);

3300: x_run_id,
3301: x_return_status,
3302: x_msg_count,
3303: x_msg_data,
3304: FND_API.G_FALSE);
3305:
3306: END LOOP;
3307: END IF;
3308: END;

Line 3331: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE

3327: x_run_id OUT NOCOPY NUMBER,
3328: x_return_status OUT NOCOPY VARCHAR2,
3329: x_msg_count OUT NOCOPY NUMBER,
3330: x_msg_data OUT NOCOPY VARCHAR2,
3331: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
3332: ) IS
3333:
3334: INVALID_ENCL_FLD_EXCP EXCEPTION;
3335: INVALID_FLD_EXCP EXCEPTION;

Line 3352: IF (p_init_msg_list = FND_API.G_TRUE ) THEN

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

Line 3357: x_return_status := FND_API.G_RET_STS_SUCCESS;

3353: fnd_msg_pub.initialize;
3354: END IF;
3355:
3356: x_run_id := 0;
3357: x_return_status := FND_API.G_RET_STS_SUCCESS;
3358:
3359: BEGIN
3360: SELECT name INTO l_folder_name
3361: FROM cz_rp_entries

Line 3670: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3762: x_return_status := FND_API.G_RET_STS_SUCCESS;

3758: IF (x_return_status <> 'T') THEN
3759: RAISE MODEL_UNLOCKED_EXCP;
3760: END IF;
3761: */
3762: x_return_status := FND_API.G_RET_STS_SUCCESS;
3763:
3764: EXCEPTION
3765: WHEN REF_EXPLS_DEL_EXCP THEN
3766: handle_Error(p_message_name => 'CZ_DEL_NODE_DEL_EXLS',

Line 3885: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4104: x_return_status := FND_API.G_RET_STS_ERROR;

4100: x_return_status => x_return_status,
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

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 4160: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4337: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4485: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4633: x_return_status := FND_API.G_RET_STS_SUCCESS;

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: ------------------------------
4636: -- check for valid p_model_id
4637: ------------------------------

Line 4668: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN

4664: -------------------------------------
4665: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');
4666: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4667: RAISE NO_PRIV;
4668: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4669: RAISE UNEXPECTED_ERROR;
4670: END IF;
4671:
4672: ----------------------------------

Line 4753: x_return_status := FND_API.G_RET_STS_ERROR;

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');
4756: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
4757: FND_MSG_PUB.ADD;

Line 4760: x_return_status := FND_API.G_RET_STS_ERROR;

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',
4763: p_token_name1 => 'MODELNAME',
4764: p_token_value1 => l_model_name,

Line 4795: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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
4796:
4797: cz_security_pvt.lock_model(
4798: p_api_version => 1.0,
4799: p_model_id => p_model_id,

Line 4800: p_lock_child_models => FND_API.G_FALSE,

4796:
4797: cz_security_pvt.lock_model(
4798: p_api_version => 1.0,
4799: p_model_id => p_model_id,
4800: p_lock_child_models => FND_API.G_FALSE,
4801: p_commit_flag => FND_API.G_FALSE,
4802: x_locked_entities => l_locked_model_tbl,
4803: x_return_status => x_return_status,
4804: x_msg_count => x_msg_count,

Line 4801: p_commit_flag => FND_API.G_FALSE,

4797: cz_security_pvt.lock_model(
4798: p_api_version => 1.0,
4799: p_model_id => p_model_id,
4800: p_lock_child_models => FND_API.G_FALSE,
4801: p_commit_flag => FND_API.G_FALSE,
4802: x_locked_entities => l_locked_model_tbl,
4803: x_return_status => x_return_status,
4804: x_msg_count => x_msg_count,
4805: x_msg_data => x_msg_data);

Line 4806: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4802: x_locked_entities => l_locked_model_tbl,
4803: x_return_status => x_return_status,
4804: x_msg_count => x_msg_count,
4805: x_msg_data => x_msg_data);
4806: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4807: RAISE LOCK_MODEL_EXCP;
4808: END IF;
4809:
4810: -- Note: Updating(logical deletion) to the RP_ENTRIES is done through the trigger on cz_devl_projects

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 4862: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
4866: x_msg_count := 1;

Line 4865: x_return_status := FND_API.G_RET_STS_ERROR;

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;
4866: x_msg_count := 1;
4867: handle_Error(p_message_name => 'CZ_COPY_MODELUSG_MAX',
4868: x_return_status => x_return_status,
4869: x_msg_count => x_msg_count,

Line 4931: x_return_status := FND_API.G_RET_STS_SUCCESS;

4927: l_text_id NUMBER;
4928:
4929: BEGIN
4930:
4931: x_return_status := FND_API.G_RET_STS_SUCCESS;
4932: x_new_property_id := allocateId('CZ_PROPERTIES_S');
4933: l_name := copy_name(p_property_id,'PRP');
4934: INSERT INTO CZ_PROPERTIES
4935: (

Line 5071: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
5075: (

Line 5234: x_return_status := FND_API.G_RET_STS_SUCCESS;

5230: IF SQL%ROWCOUNT = 0 THEN
5231: RAISE INVALID_ARCHIVE_ID_EXCP;
5232: END IF;
5233:
5234: x_return_status := FND_API.G_RET_STS_SUCCESS;
5235:
5236: EXCEPTION
5237: WHEN INVALID_ARCHIVE_ID_EXCP THEN
5238: handle_Error(p_message_name => 'CZ_COPY_ARC_INV_ID',

Line 5521: FND_API.G_TRUE,

5517:
5518:
5519: cz_developer_utils_pvt.copy_Rule (l_element_id,
5520: l_rule_folder_id,
5521: FND_API.G_TRUE,
5522: l_new_element_id,
5523: l_run_id,
5524: l_return_status,
5525: l_msg_count,

Line 5528: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5524: l_return_status,
5525: l_msg_count,
5526: l_msg_data);
5527:
5528: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5529: RAISE COPY_RULE_FAILURE;
5530: END IF;
5531:
5532: ELSIF ( p_id_type = G_INTL_TEXT_TYPE ) THEN

Line 5790: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
5794: RAISE DOCUMENT_IS_NULL;

Line 5912: x_return_status := FND_API.G_RET_STS_ERROR;

5908: WHEN DOCUMENT_IS_NULL THEN
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

Line 5917: 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;
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 ;

Line 5964: p_commit_flag => FND_API.G_FALSE,

5960: l_templates(1) := p_template_id;
5961: cz_security_pvt.lock_template(
5962: p_api_version => 1.0,
5963: p_templates_to_lock => l_templates,
5964: p_commit_flag => FND_API.G_FALSE,
5965: p_init_msg_list => FND_API.G_FALSE,
5966: x_locked_templates => l_locked_templates,
5967: x_return_status => x_return_status,
5968: x_msg_count => x_msg_count,

Line 5965: p_init_msg_list => FND_API.G_FALSE,

5961: cz_security_pvt.lock_template(
5962: p_api_version => 1.0,
5963: p_templates_to_lock => l_templates,
5964: p_commit_flag => FND_API.G_FALSE,
5965: p_init_msg_list => FND_API.G_FALSE,
5966: x_locked_templates => l_locked_templates,
5967: x_return_status => x_return_status,
5968: x_msg_count => x_msg_count,
5969: x_msg_data => x_msg_data);

Line 5970: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5966: x_locked_templates => l_locked_templates,
5967: x_return_status => x_return_status,
5968: x_msg_count => x_msg_count,
5969: x_msg_data => x_msg_data);
5970: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5971: RAISE FAILED_TO_LOCK_UCT;
5972: END IF;
5973: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
5974: l_name := copy_name(p_template_id,'UCT');

Line 6126: p_commit_flag => FND_API.G_FALSE,

6122: IF ( l_locked_templates.COUNT > 0 ) THEN
6123: cz_security_pvt.unlock_template(
6124: p_api_version => 1.0,
6125: p_templates_to_unlock => l_locked_templates,
6126: p_commit_flag => FND_API.G_FALSE,
6127: p_init_msg_list => FND_API.G_FALSE,
6128: x_return_status => x_return_status,
6129: x_msg_count => x_msg_count,
6130: x_msg_data => x_msg_data);

Line 6127: p_init_msg_list => FND_API.G_FALSE,

6123: cz_security_pvt.unlock_template(
6124: p_api_version => 1.0,
6125: p_templates_to_unlock => l_locked_templates,
6126: p_commit_flag => FND_API.G_FALSE,
6127: p_init_msg_list => FND_API.G_FALSE,
6128: x_return_status => x_return_status,
6129: x_msg_count => x_msg_count,
6130: x_msg_data => x_msg_data);
6131: END IF;

Line 6132: x_return_status := FND_API.G_RET_STS_SUCCESS;

6128: x_return_status => x_return_status,
6129: x_msg_count => x_msg_count,
6130: x_msg_data => x_msg_data);
6131: END IF;
6132: x_return_status := FND_API.G_RET_STS_SUCCESS;
6133: EXCEPTION
6134: WHEN INVALID_TEMPLATE_ID_EXCP THEN
6135: handle_Error(p_message_name => 'CZ_COPY_UCT_INV_ID',
6136: p_token_name1 => 'OBJID',

Line 6142: x_return_status := FND_API.G_RET_STS_ERROR;

6138: x_return_status => x_return_status,
6139: x_msg_count => x_msg_count,
6140: x_msg_data => x_msg_data);
6141: WHEN FAILED_TO_LOCK_UCT THEN
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,

Line 6157: p_commit_flag => FND_API.G_FALSE,

6153: x_msg_data => x_msg_data);
6154: IF ( l_locked_templates.COUNT > 0 ) THEN
6155: cz_security_pvt.unlock_template(p_api_version => 1.0,
6156: p_templates_to_unlock => l_locked_templates,
6157: p_commit_flag => FND_API.G_FALSE,
6158: p_init_msg_list => FND_API.G_FALSE,
6159: x_return_status => l_return_status,
6160: x_msg_count => l_msg_count,
6161: x_msg_data => l_msg_data);

Line 6158: p_init_msg_list => FND_API.G_FALSE,

6154: IF ( l_locked_templates.COUNT > 0 ) THEN
6155: cz_security_pvt.unlock_template(p_api_version => 1.0,
6156: p_templates_to_unlock => l_locked_templates,
6157: p_commit_flag => FND_API.G_FALSE,
6158: p_init_msg_list => FND_API.G_FALSE,
6159: x_return_status => l_return_status,
6160: x_msg_count => l_msg_count,
6161: x_msg_data => l_msg_data);
6162:

Line 6164: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

6160: x_msg_count => l_msg_count,
6161: x_msg_data => l_msg_data);
6162:
6163: -- propogate the status from unlock template only in case of an error during unlock
6164: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6165: x_return_status := l_return_status;
6166: x_msg_count := l_msg_count;
6167: x_msg_data := l_msg_data;
6168: END IF;

Line 6402: x_return_status := FND_API.G_RET_STS_SUCCESS;

6398: IF SQL%ROWCOUNT = 0 THEN
6399: RAISE INVALID_UIDEF_ID_EXCP;
6400: END IF;
6401:
6402: x_return_status := FND_API.G_RET_STS_SUCCESS;
6403:
6404: EXCEPTION
6405: WHEN INVALID_UIDEF_ID_EXCP THEN
6406: handle_Error(p_message_name => 'CZ_COPY_UMT_INV_ID',

Line 6437: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6441: ----check if eff set exists

Line 6462: x_return_status := FND_API.G_RET_STS_ERROR;

6458: WHERE effectivity_set_id = p_eff_set_id
6459: AND deleted_flag = '0');
6460:
6461: IF l_prj_name_tbl.COUNT > 0 THEN
6462: x_return_status := FND_API.G_RET_STS_ERROR;
6463: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6464: LOOP
6465: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6466: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);

Line 6498: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6502: is_eff_set_deleteable(p_eff_set_id,l_return_status,l_msg_count,l_msg_data);

Line 6503: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6499: x_msg_count := 0;
6500: x_msg_data := '';
6501:
6502: is_eff_set_deleteable(p_eff_set_id,l_return_status,l_msg_count,l_msg_data);
6503: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6504: UPDATE cz_effectivity_sets
6505: SET deleted_flag = '1',
6506: name = append_name(p_eff_set_id, 'EFF', name)
6507: WHERE effectivity_set_id = p_eff_set_id;

Line 6544: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6548: ----check if archive exists

Line 6583: x_return_status := FND_API.G_RET_STS_ERROR;

6579: WHERE object_type = 'PRJ'
6580: AND deleted_flag = '0');
6581:
6582: IF (l_devl_project_tbl.COUNT > 0) THEN
6583: x_return_status := FND_API.G_RET_STS_ERROR;
6584: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
6585: LOOP
6586: x_msg_count := x_msg_count + 1;
6587: SELECT name into l_devl_name FROM cz_devl_projects WHERE devl_project_id = l_devl_project_tbl(i);

Line 6632: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6636: is_archive_deleteable(p_archive_id,l_return_status,l_msg_count,l_msg_data);

Line 6637: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6633: x_msg_count := 0;
6634: x_msg_data := '';
6635:
6636: is_archive_deleteable(p_archive_id,l_return_status,l_msg_count,l_msg_data);
6637: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6638: UPDATE cz_rp_entries
6639: set deleted_flag = '1',
6640: name = append_name(p_archive_id, 'ARC', name)
6641: where object_id = p_archive_id

Line 6684: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6688: ----check if prop exists

Line 6796: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6800: is_property_deleteable(p_property_id,l_return_status,l_msg_count,l_msg_data);

Line 6801: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6797: x_msg_count := 0;
6798: x_msg_data := '';
6799:
6800: is_property_deleteable(p_property_id,l_return_status,l_msg_count,l_msg_data);
6801: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6802: UPDATE cz_rp_entries
6803: SET deleted_flag = '1',
6804: name = append_name(p_property_id, 'PRP', name)
6805: WHERE object_id = p_property_id

Line 6844: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 := '';
6847:
6848: BEGIN

Line 6884: x_return_status := FND_API.G_RET_STS_ERROR;

6880: l_object_id := -1;
6881: END;
6882:
6883: IF (l_ui_name_tbl.count > 0 ) THEN
6884: x_return_status := FND_API.G_RET_STS_ERROR;
6885: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6886: LOOP
6887: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6888: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 6927: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6931: is_umt_deleteable(p_umt_id,l_return_status,l_msg_count,l_msg_data);

Line 6932: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

6928: x_msg_count := 0;
6929: x_msg_data := '';
6930:
6931: is_umt_deleteable(p_umt_id,l_return_status,l_msg_count,l_msg_data);
6932: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6933: UPDATE cz_rp_entries
6934: SET deleted_flag = '1',
6935: name = append_name(p_umt_id, 'UMT', name)
6936: WHERE object_id = p_umt_id

Line 6980: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
6984: -- check if p_uct_id exists

Line 7031: x_return_status := FND_API.G_RET_STS_ERROR;

7027: l_object_id := -1;
7028: END;
7029:
7030: IF (l_ui_name_tbl.count > 0 ) THEN
7031: x_return_status := FND_API.G_RET_STS_ERROR;
7032: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
7033: LOOP
7034: IF l_mt_flag_tbl(i) = '1' THEN
7035: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');

Line 7078: x_return_status := FND_API.G_RET_STS_ERROR;

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;
7082: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 7118: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
7122: is_uct_deleteable(p_uct_id,l_return_status,l_msg_count,l_msg_data);

Line 7123: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7119: x_msg_count := 0;
7120: x_msg_data := '';
7121:
7122: is_uct_deleteable(p_uct_id,l_return_status,l_msg_count,l_msg_data);
7123: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7124: --Added: smanna: Check if template is lockable before delete like any other entity
7125: cz_security_pvt.lock_template(
7126: p_api_version => 1.0,
7127: p_template_id => p_uct_id,

Line 7128: p_commit_flag => FND_API.G_FALSE,

7124: --Added: smanna: Check if template is lockable before delete like any other entity
7125: cz_security_pvt.lock_template(
7126: p_api_version => 1.0,
7127: p_template_id => p_uct_id,
7128: p_commit_flag => FND_API.G_FALSE,
7129: p_init_msg_list => FND_API.G_FALSE,
7130: x_return_status => x_return_status,
7131: x_msg_count => x_msg_count,
7132: x_msg_data => x_msg_data);

Line 7129: p_init_msg_list => FND_API.G_FALSE,

7125: cz_security_pvt.lock_template(
7126: p_api_version => 1.0,
7127: p_template_id => p_uct_id,
7128: p_commit_flag => FND_API.G_FALSE,
7129: p_init_msg_list => FND_API.G_FALSE,
7130: x_return_status => x_return_status,
7131: x_msg_count => x_msg_count,
7132: x_msg_data => x_msg_data);
7133: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 7133: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

7129: p_init_msg_list => FND_API.G_FALSE,
7130: x_return_status => x_return_status,
7131: x_msg_count => x_msg_count,
7132: x_msg_data => x_msg_data);
7133: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7134: SELECT template_name INTO l_template_name FROM cz_ui_templates
7135: WHERE template_id = p_uct_id;
7136: RAISE FAILED_TO_LOCK_UCT;
7137: END IF;

Line 7157: x_return_status := FND_API.G_RET_STS_ERROR;

7153: x_msg_data := l_msg_data;
7154: END IF;
7155: EXCEPTION
7156: WHEN FAILED_TO_LOCK_UCT THEN
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,

Line 7296: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
7300: BEGIN

Line 7389: x_return_status := FND_API.G_RET_STS_SUCCESS;

7385: END IF;
7386:
7387: EXCEPTION
7388: WHEN NO_DATA_FOUND THEN
7389: x_return_status := FND_API.G_RET_STS_SUCCESS;
7390: x_msg_count := 0;
7391: x_msg_data := NULL;
7392: WHEN NO_USG_EXISTS THEN
7393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7393: x_return_status := FND_API.G_RET_STS_SUCCESS;

7389: x_return_status := FND_API.G_RET_STS_SUCCESS;
7390: x_msg_count := 0;
7391: x_msg_data := NULL;
7392: WHEN NO_USG_EXISTS THEN
7393: x_return_status := FND_API.G_RET_STS_SUCCESS;
7394: x_msg_count := 0;
7395: x_msg_data := NULL;
7396: WHEN USG_IN_USE THEN
7397: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');

Line 7400: x_return_status := FND_API.g_ret_sts_error;

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
7404: handle_Error(p_message_name => 'CZ_DEL_USG_FATAL_ERR',

Line 7542: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
7546: is_usage_deleteable(p_usage_id,l_return_status,l_msg_count,l_msg_data);

Line 7547: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7543: x_msg_count := 0;
7544: x_msg_data := '';
7545:
7546: is_usage_deleteable(p_usage_id,l_return_status,l_msg_count,l_msg_data);
7547: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7548: delete_usage(p_usage_id,l_usg_status);
7549: IF (l_usg_status <> 0) THEN
7550: RAISE DEL_USG_ERR ;
7551: END IF;

Line 7559: x_return_status := FND_API.G_RET_STS_ERROR;

7555: x_msg_data := l_msg_data;
7556: END IF;
7557: EXCEPTION
7558: WHEN DEL_USG_ERR THEN
7559: x_return_status := FND_API.G_RET_STS_ERROR;
7560: handle_Error(p_message_name => 'CZ_CANNOT_DEL_USG',
7561: p_token_name1 => 'USAGE',
7562: p_token_value1 => TO_CHAR(p_usage_id),
7563: x_return_status => x_return_status,

Line 7669: x_return_status := FND_API.g_ret_sts_success;

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:
7673: l_user_name := FND_GLOBAL.user_name;

Line 7725: x_return_status := FND_API.g_ret_sts_error;

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

Line 7852: x_return_status := FND_API.g_ret_sts_error;

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

Line 7897: x_return_status := FND_API.g_ret_sts_error;

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;
7901: SELECT publication_id

Line 7919: x_return_status := FND_API.g_ret_sts_error;

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

Line 7995: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8043: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8097: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8121: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8138: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8175: x_return_status := FND_API.G_RET_STS_ERROR;

8171: AND EXISTS (SELECT 1 FROM cz_rp_entries WHERE deleted_flag = '0'
8172: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ');
8173:
8174: IF (l_ui_name_tbl.count > 0 ) THEN
8175: x_return_status := FND_API.G_RET_STS_ERROR;
8176: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8177: LOOP
8178: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8179: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 8225: x_return_status := FND_API.G_RET_STS_ERROR;

8221: AND object_id = cz_ui_defs.devl_project_id AND object_type = 'PRJ')
8222: AND cz_ui_defs.deleted_flag = '0';
8223:
8224: IF (l_ui_name_tbl.count > 0 ) THEN
8225: x_return_status := FND_API.G_RET_STS_ERROR;
8226: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8227: LOOP
8228: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8229: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 8269: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8309: x_return_status := FND_API.g_ret_sts_error;

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:
8313: v_nodes.DELETE;

Line 8360: x_return_status := FND_API.g_ret_sts_error;

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

Line 8381: x_return_status := FND_API.g_ret_sts_error;

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

Line 8397: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
8398: WHEN OTHERS THEN
8399: handle_Error( p_procedure_name => 'is_repos_fld_deleteable',
8400: p_error_message => SQLERRM,
8401: x_return_status => x_return_status,

Line 8424: x_return_status := FND_API.g_ret_sts_success;

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:
8428: ---check if models in the repository folder are locked

Line 8443: IF ( (x_return_status = FND_API.g_ret_sts_success)

8439: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8440: AND PRIOR cz_rp_entries.object_type = 'FLD';
8441:
8442: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);
8443: IF ( (x_return_status = FND_API.g_ret_sts_success)
8444: AND (l_rp_fld_tbl.COUNT > 0) ) THEN
8445: FOR I IN l_rp_fld_tbl.FIRST..l_rp_fld_tbl.LAST
8446: LOOP
8447: l_object_typ_tbl.DELETE;

Line 8492: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8488: END LOOP;
8489:
8490: l_count := l_rp_fld_tbl.COUNT;
8491:
8492: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8493: WHILE (l_count > 0)
8494: LOOP
8495: UPDATE cz_rp_entries
8496: SET deleted_flag = '1',

Line 11483: x_return_status := FND_API.G_RET_STS_SUCCESS;

11479: OBJTYPE_NOT_ALLOWED EXCEPTION;
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

Line 11569: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11575: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11577: FND_MSG_PUB.ADD;
11578: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11579: p_data => x_msg_data);

Line 11581: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11583: FND_MSG_PUB.ADD;
11584: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11585: p_data => x_msg_data);

Line 11587: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11589: FND_MSG_PUB.ADD;
11590: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11591: p_data => x_msg_data);

Line 11593: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11595: FND_MSG_PUB.ADD;
11596: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11597: p_data => x_msg_data);

Line 11599: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11601: FND_MSG_PUB.ADD;
11602: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11603: p_data => x_msg_data);

Line 11605: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11607: FND_MSG_PUB.ADD;
11608: fnd_msg_pub.count_and_get(p_count => x_msg_count,
11609: p_data => x_msg_data);

Line 11611: x_return_status := FND_API.G_RET_STS_ERROR;

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');
11613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11614: FND_MSG_PUB.ADD;
11615: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 12011: x_return_status := FND_API.g_ret_sts_success;

12007: ) IS
12008: l_new_class_name CZ_RULES.class_name%TYPE;
12009: BEGIN
12010:
12011: x_return_status := FND_API.g_ret_sts_success;
12012: x_msg_count := 0;
12013: x_msg_data := '';
12014:
12015: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id