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

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

Line 1367: FND_API.G_FALSE,

1363: IF (l_copy_rule = TRUE AND (l_rule_type_tbl(i) = RULE_TYPE_JAVA_METHOD OR l_rule_nodes_tbl.COUNT > 0)) THEN
1364:
1365: copy_Rule(l_rule_id_tbl(i),
1366: l_rule_folder_id_tbl(i),
1367: FND_API.G_FALSE,
1368: l_new_rule_id,
1369: x_run_id,
1370: l_return_status,
1371: l_msg_count,

Line 1726: IF p_init_msg_list = FND_API.G_TRUE THEN

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

Line 1730: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1732: SELECT devl_project_id,rule_folder_id, rule_type, seeded_flag
1733: INTO l_model_id,l_rule_folder_id, l_rule_type, l_seeded_flag
1734: FROM CZ_RULES

Line 2404: p_init_msg_list => FND_API.G_TRUE,

2400: BEGIN
2401:
2402: copy_Rule(p_rule_id => p_rule_id,
2403: p_rule_folder_id => p_rule_folder_id,
2404: p_init_msg_list => FND_API.G_TRUE,
2405: x_out_new_rule_id => x_out_new_rule_id,
2406: x_run_id => x_run_id,
2407: x_return_status => x_return_status,
2408: x_msg_count => x_msg_count,

Line 2471: IF p_init_msg_list = FND_API.G_TRUE THEN

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

Line 2476: x_return_status := FND_API.G_RET_STS_SUCCESS;

2472: FND_MSG_PUB.initialize;
2473: END IF;
2474:
2475: x_run_id := 0;
2476: x_return_status := FND_API.G_RET_STS_SUCCESS;
2477:
2478: --
2479: -- check global flag that equals '1' if model is already locked
2480: -- by calling sequirity package

Line 2562: ,p_init_msg_list => FND_API.G_FALSE

2558: LOOP
2559: IF i.object_type IN ('RFL', 'RSQ') THEN
2560: copy_rule_folder(p_rule_folder_id => i.rule_folder_id
2561: ,p_new_parent_folder_id => x_out_rule_folder_id
2562: ,p_init_msg_list => FND_API.G_FALSE
2563: ,x_out_rule_folder_id => l_rule_folder_id
2564: ,x_run_id => x_run_id
2565: ,x_return_status => x_return_status
2566: ,x_msg_count => x_msg_count

Line 2571: p_init_msg_list => FND_API.G_FALSE,

2567: ,x_msg_data => x_msg_data);
2568: ELSE
2569: copy_Rule(p_rule_id => i.rule_folder_id,
2570: p_rule_folder_id => x_out_rule_folder_id,
2571: p_init_msg_list => FND_API.G_FALSE,
2572: x_out_new_rule_id => l_rule_id,
2573: x_run_id => x_run_id,
2574: x_return_status => x_return_status,
2575: x_msg_count => x_msg_count,

Line 2579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2575: x_msg_count => x_msg_count,
2576: x_msg_data => x_msg_data);
2577: END IF;
2578:
2579: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2580: RETURN;
2581: END IF;
2582: END LOOP;
2583:

Line 2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2599: l_locked_entities_tbl,
2600: x_return_status,
2601: x_msg_count,
2602: x_msg_data);
2603: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2604: x_run_id := GetRunID;
2605: LOG_REPORT(x_run_id,x_msg_count);
2606: RETURN;
2607: END IF;

Line 2636: ,p_init_msg_list => FND_API.G_TRUE

2632:
2633: BEGIN
2634: copy_rule_folder(p_rule_folder_id => p_rule_folder_id
2635: ,p_new_parent_folder_id => p_new_parent_folder_id
2636: ,p_init_msg_list => FND_API.G_TRUE
2637: ,x_out_rule_folder_id => x_out_rule_folder_id
2638: ,x_run_id => x_run_id
2639: ,x_return_status => x_return_status
2640: ,x_msg_count => x_msg_count

Line 3233: l_return_status := FND_API.g_ret_sts_success;

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

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

3247: x_msg_data);
3248:
3249: -- Need to store status as we are looping and the status will get overwritten for
3250: -- each folder.
3251: IF (l_return_status = FND_API.g_ret_sts_success AND x_return_status <> FND_API.g_ret_sts_success) THEN
3252: l_return_status := x_return_status;
3253: END IF;
3254: END LOOP;
3255: END IF;

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

3254: END LOOP;
3255: END IF;
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;

Line 3276: FND_API.G_FALSE);

3272: x_run_id,
3273: x_return_status,
3274: x_msg_count,
3275: x_msg_data,
3276: FND_API.G_FALSE);
3277:
3278: END LOOP;
3279: END IF;
3280: END;

Line 3303: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE

3299: x_run_id OUT NOCOPY NUMBER,
3300: x_return_status OUT NOCOPY VARCHAR2,
3301: x_msg_count OUT NOCOPY NUMBER,
3302: x_msg_data OUT NOCOPY VARCHAR2,
3303: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
3304: ) IS
3305:
3306: INVALID_ENCL_FLD_EXCP EXCEPTION;
3307: INVALID_FLD_EXCP EXCEPTION;

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

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

Line 3329: x_return_status := FND_API.G_RET_STS_SUCCESS;

3325: fnd_msg_pub.initialize;
3326: END IF;
3327:
3328: x_run_id := 0;
3329: x_return_status := FND_API.G_RET_STS_SUCCESS;
3330:
3331: BEGIN
3332: SELECT name INTO l_folder_name
3333: FROM cz_rp_entries

Line 3642: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3734: x_return_status := FND_API.G_RET_STS_SUCCESS;

3730: IF (x_return_status <> 'T') THEN
3731: RAISE MODEL_UNLOCKED_EXCP;
3732: END IF;
3733: */
3734: x_return_status := FND_API.G_RET_STS_SUCCESS;
3735:
3736: EXCEPTION
3737: WHEN REF_EXPLS_DEL_EXCP THEN
3738: handle_Error(p_message_name => 'CZ_DEL_NODE_DEL_EXLS',

Line 3857: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4076: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 4309: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4457: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 4605: x_return_status := FND_API.G_RET_STS_SUCCESS;

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: ------------------------------
4608: -- check for valid p_model_id
4609: ------------------------------

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

4636: -------------------------------------
4637: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');
4638: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4639: RAISE NO_PRIV;
4640: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4641: RAISE UNEXPECTED_ERROR;
4642: END IF;
4643:
4644: ----------------------------------

Line 4725: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 4732: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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
4768:
4769: cz_security_pvt.lock_model(
4770: p_api_version => 1.0,
4771: p_model_id => p_model_id,

Line 4772: p_lock_child_models => FND_API.G_FALSE,

4768:
4769: cz_security_pvt.lock_model(
4770: p_api_version => 1.0,
4771: p_model_id => p_model_id,
4772: p_lock_child_models => FND_API.G_FALSE,
4773: p_commit_flag => FND_API.G_FALSE,
4774: x_locked_entities => l_locked_model_tbl,
4775: x_return_status => x_return_status,
4776: x_msg_count => x_msg_count,

Line 4773: p_commit_flag => FND_API.G_FALSE,

4769: cz_security_pvt.lock_model(
4770: p_api_version => 1.0,
4771: p_model_id => p_model_id,
4772: p_lock_child_models => FND_API.G_FALSE,
4773: p_commit_flag => FND_API.G_FALSE,
4774: x_locked_entities => l_locked_model_tbl,
4775: x_return_status => x_return_status,
4776: x_msg_count => x_msg_count,
4777: x_msg_data => x_msg_data);

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

4774: x_locked_entities => l_locked_model_tbl,
4775: x_return_status => x_return_status,
4776: x_msg_count => x_msg_count,
4777: x_msg_data => x_msg_data);
4778: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4779: RAISE LOCK_MODEL_EXCP;
4780: END IF;
4781:
4782: UPDATE cz_devl_projects

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

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

Line 4836: x_return_status := FND_API.G_RET_STS_ERROR;

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;
4837: x_msg_count := 1;
4838: handle_Error(p_message_name => 'CZ_COPY_MODELUSG_MAX',
4839: x_return_status => x_return_status,
4840: x_msg_count => x_msg_count,

Line 4902: x_return_status := FND_API.G_RET_STS_SUCCESS;

4898: l_text_id NUMBER;
4899:
4900: BEGIN
4901:
4902: x_return_status := FND_API.G_RET_STS_SUCCESS;
4903: x_new_property_id := allocateId('CZ_PROPERTIES_S');
4904: l_name := copy_name(p_property_id,'PRP');
4905: INSERT INTO CZ_PROPERTIES
4906: (

Line 5042: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 5205: x_return_status := FND_API.G_RET_STS_SUCCESS;

5201: IF SQL%ROWCOUNT = 0 THEN
5202: RAISE INVALID_ARCHIVE_ID_EXCP;
5203: END IF;
5204:
5205: x_return_status := FND_API.G_RET_STS_SUCCESS;
5206:
5207: EXCEPTION
5208: WHEN INVALID_ARCHIVE_ID_EXCP THEN
5209: handle_Error(p_message_name => 'CZ_COPY_ARC_INV_ID',

Line 5492: FND_API.G_TRUE,

5488:
5489:
5490: cz_developer_utils_pvt.copy_Rule (l_element_id,
5491: l_rule_folder_id,
5492: FND_API.G_TRUE,
5493: l_new_element_id,
5494: l_run_id,
5495: l_return_status,
5496: l_msg_count,

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

5495: l_return_status,
5496: l_msg_count,
5497: l_msg_data);
5498:
5499: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5500: RAISE COPY_RULE_FAILURE;
5501: END IF;
5502:
5503: ELSIF ( p_id_type = G_INTL_TEXT_TYPE ) THEN

Line 5761: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 5883: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 5935: p_commit_flag => FND_API.G_FALSE,

5931: l_templates(1) := p_template_id;
5932: cz_security_pvt.lock_template(
5933: p_api_version => 1.0,
5934: p_templates_to_lock => l_templates,
5935: p_commit_flag => FND_API.G_FALSE,
5936: p_init_msg_list => FND_API.G_FALSE,
5937: x_locked_templates => l_locked_templates,
5938: x_return_status => x_return_status,
5939: x_msg_count => x_msg_count,

Line 5936: p_init_msg_list => FND_API.G_FALSE,

5932: cz_security_pvt.lock_template(
5933: p_api_version => 1.0,
5934: p_templates_to_lock => l_templates,
5935: p_commit_flag => FND_API.G_FALSE,
5936: p_init_msg_list => FND_API.G_FALSE,
5937: x_locked_templates => l_locked_templates,
5938: x_return_status => x_return_status,
5939: x_msg_count => x_msg_count,
5940: x_msg_data => x_msg_data);

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

5937: x_locked_templates => l_locked_templates,
5938: x_return_status => x_return_status,
5939: x_msg_count => x_msg_count,
5940: x_msg_data => x_msg_data);
5941: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5942: RAISE FAILED_TO_LOCK_UCT;
5943: END IF;
5944: x_new_template_id := allocateId('CZ_UI_TEMPLATES_S');
5945: l_name := copy_name(p_template_id,'UCT');

Line 6097: p_commit_flag => FND_API.G_FALSE,

6093: IF ( l_locked_templates.COUNT > 0 ) THEN
6094: cz_security_pvt.unlock_template(
6095: p_api_version => 1.0,
6096: p_templates_to_unlock => l_locked_templates,
6097: p_commit_flag => FND_API.G_FALSE,
6098: p_init_msg_list => FND_API.G_FALSE,
6099: x_return_status => x_return_status,
6100: x_msg_count => x_msg_count,
6101: x_msg_data => x_msg_data);

Line 6098: p_init_msg_list => FND_API.G_FALSE,

6094: cz_security_pvt.unlock_template(
6095: p_api_version => 1.0,
6096: p_templates_to_unlock => l_locked_templates,
6097: p_commit_flag => FND_API.G_FALSE,
6098: p_init_msg_list => FND_API.G_FALSE,
6099: x_return_status => x_return_status,
6100: x_msg_count => x_msg_count,
6101: x_msg_data => x_msg_data);
6102: END IF;

Line 6103: x_return_status := FND_API.G_RET_STS_SUCCESS;

6099: x_return_status => x_return_status,
6100: x_msg_count => x_msg_count,
6101: x_msg_data => x_msg_data);
6102: END IF;
6103: x_return_status := FND_API.G_RET_STS_SUCCESS;
6104: EXCEPTION
6105: WHEN INVALID_TEMPLATE_ID_EXCP THEN
6106: handle_Error(p_message_name => 'CZ_COPY_UCT_INV_ID',
6107: p_token_name1 => 'OBJID',

Line 6113: x_return_status := FND_API.G_RET_STS_ERROR;

6109: x_return_status => x_return_status,
6110: x_msg_count => x_msg_count,
6111: x_msg_data => x_msg_data);
6112: WHEN FAILED_TO_LOCK_UCT THEN
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,

Line 6128: p_commit_flag => FND_API.G_FALSE,

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

Line 6129: p_init_msg_list => FND_API.G_FALSE,

6125: IF ( l_locked_templates.COUNT > 0 ) THEN
6126: cz_security_pvt.unlock_template(p_api_version => 1.0,
6127: p_templates_to_unlock => l_locked_templates,
6128: p_commit_flag => FND_API.G_FALSE,
6129: p_init_msg_list => FND_API.G_FALSE,
6130: x_return_status => l_return_status,
6131: x_msg_count => l_msg_count,
6132: x_msg_data => l_msg_data);
6133:

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

6131: x_msg_count => l_msg_count,
6132: x_msg_data => l_msg_data);
6133:
6134: -- propogate the status from unlock template only in case of an error during unlock
6135: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6136: x_return_status := l_return_status;
6137: x_msg_count := l_msg_count;
6138: x_msg_data := l_msg_data;
6139: END IF;

Line 6373: x_return_status := FND_API.G_RET_STS_SUCCESS;

6369: IF SQL%ROWCOUNT = 0 THEN
6370: RAISE INVALID_UIDEF_ID_EXCP;
6371: END IF;
6372:
6373: x_return_status := FND_API.G_RET_STS_SUCCESS;
6374:
6375: EXCEPTION
6376: WHEN INVALID_UIDEF_ID_EXCP THEN
6377: handle_Error(p_message_name => 'CZ_COPY_UMT_INV_ID',

Line 6408: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 6433: x_return_status := FND_API.G_RET_STS_ERROR;

6429: WHERE effectivity_set_id = p_eff_set_id
6430: AND deleted_flag = '0');
6431:
6432: IF l_prj_name_tbl.COUNT > 0 THEN
6433: x_return_status := FND_API.G_RET_STS_ERROR;
6434: FOR i IN l_prj_name_tbl.FIRST..l_prj_name_tbl.LAST
6435: LOOP
6436: FND_MESSAGE.SET_NAME('CZ', 'CZ_DEV_UTILS_EFF_SET_IN_USE');
6437: FND_MESSAGE.SET_TOKEN('EFFSETNAME', l_eff_name);

Line 6469: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

6470: x_msg_count := 0;
6471: x_msg_data := '';
6472:
6473: is_eff_set_deleteable(p_eff_set_id,l_return_status,l_msg_count,l_msg_data);
6474: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6475: UPDATE cz_effectivity_sets
6476: SET deleted_flag = '1',
6477: name = append_name(p_eff_set_id, 'EFF', name)
6478: WHERE effectivity_set_id = p_eff_set_id;

Line 6515: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 6554: x_return_status := FND_API.G_RET_STS_ERROR;

6550: WHERE object_type = 'PRJ'
6551: AND deleted_flag = '0');
6552:
6553: IF (l_devl_project_tbl.COUNT > 0) THEN
6554: x_return_status := FND_API.G_RET_STS_ERROR;
6555: FOR I IN l_devl_project_tbl.FIRST..l_devl_project_tbl.LAST
6556: LOOP
6557: x_msg_count := x_msg_count + 1;
6558: SELECT name into l_devl_name FROM cz_devl_projects WHERE devl_project_id = l_devl_project_tbl(i);

Line 6603: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

6604: x_msg_count := 0;
6605: x_msg_data := '';
6606:
6607: is_archive_deleteable(p_archive_id,l_return_status,l_msg_count,l_msg_data);
6608: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6609: UPDATE cz_rp_entries
6610: set deleted_flag = '1',
6611: name = append_name(p_archive_id, 'ARC', name)
6612: where object_id = p_archive_id

Line 6655: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 6767: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

6768: x_msg_count := 0;
6769: x_msg_data := '';
6770:
6771: is_property_deleteable(p_property_id,l_return_status,l_msg_count,l_msg_data);
6772: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6773: UPDATE cz_rp_entries
6774: SET deleted_flag = '1',
6775: name = append_name(p_property_id, 'PRP', name)
6776: WHERE object_id = p_property_id

Line 6815: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 := '';
6818:
6819: BEGIN

Line 6855: x_return_status := FND_API.G_RET_STS_ERROR;

6851: l_object_id := -1;
6852: END;
6853:
6854: IF (l_ui_name_tbl.count > 0 ) THEN
6855: x_return_status := FND_API.G_RET_STS_ERROR;
6856: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
6857: LOOP
6858: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
6859: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 6898: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

6899: x_msg_count := 0;
6900: x_msg_data := '';
6901:
6902: is_umt_deleteable(p_umt_id,l_return_status,l_msg_count,l_msg_data);
6903: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6904: UPDATE cz_rp_entries
6905: SET deleted_flag = '1',
6906: name = append_name(p_umt_id, 'UMT', name)
6907: WHERE object_id = p_umt_id

Line 6951: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 7002: x_return_status := FND_API.G_RET_STS_ERROR;

6998: l_object_id := -1;
6999: END;
7000:
7001: IF (l_ui_name_tbl.count > 0 ) THEN
7002: x_return_status := FND_API.G_RET_STS_ERROR;
7003: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
7004: LOOP
7005: IF l_mt_flag_tbl(i) = '1' THEN
7006: FND_MESSAGE.SET_NAME ('CZ', 'CZ_UCT_IN_USE_TEMPL');

Line 7049: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 7087: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

7088: x_msg_count := 0;
7089: x_msg_data := '';
7090:
7091: is_uct_deleteable(p_uct_id,l_return_status,l_msg_count,l_msg_data);
7092: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7093: UPDATE cz_rp_entries
7094: SET deleted_flag = '1',
7095: name = append_name(p_uct_id, 'UCT', name)
7096: WHERE object_id = p_uct_id

Line 7243: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 7336: x_return_status := FND_API.G_RET_STS_SUCCESS;

7332: END IF;
7333:
7334: EXCEPTION
7335: WHEN NO_DATA_FOUND THEN
7336: x_return_status := FND_API.G_RET_STS_SUCCESS;
7337: x_msg_count := 0;
7338: x_msg_data := NULL;
7339: WHEN NO_USG_EXISTS THEN
7340: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7340: x_return_status := FND_API.G_RET_STS_SUCCESS;

7336: x_return_status := FND_API.G_RET_STS_SUCCESS;
7337: x_msg_count := 0;
7338: x_msg_data := NULL;
7339: WHEN NO_USG_EXISTS THEN
7340: x_return_status := FND_API.G_RET_STS_SUCCESS;
7341: x_msg_count := 0;
7342: x_msg_data := NULL;
7343: WHEN USG_IN_USE THEN
7344: FND_MESSAGE.SET_NAME('CZ','CZ_USG_IN_USE');

Line 7347: x_return_status := FND_API.g_ret_sts_error;

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

Line 7489: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

7490: x_msg_count := 0;
7491: x_msg_data := '';
7492:
7493: is_usage_deleteable(p_usage_id,l_return_status,l_msg_count,l_msg_data);
7494: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7495: delete_usage(p_usage_id,l_usg_status);
7496: IF (l_usg_status <> 0) THEN
7497: RAISE DEL_USG_ERR ;
7498: END IF;

Line 7506: x_return_status := FND_API.G_RET_STS_ERROR;

7502: x_msg_data := l_msg_data;
7503: END IF;
7504: EXCEPTION
7505: WHEN DEL_USG_ERR THEN
7506: x_return_status := FND_API.G_RET_STS_ERROR;
7507: handle_Error(p_message_name => 'CZ_CANNOT_DEL_USG',
7508: p_token_name1 => 'USAGE',
7509: p_token_value1 => TO_CHAR(p_usage_id),
7510: x_return_status => x_return_status,

Line 7611: x_return_status := FND_API.g_ret_sts_success;

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

Line 7667: x_return_status := FND_API.g_ret_sts_error;

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

Line 7794: x_return_status := FND_API.g_ret_sts_error;

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

Line 7839: x_return_status := FND_API.g_ret_sts_error;

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

Line 7861: x_return_status := FND_API.g_ret_sts_error;

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

Line 7937: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 7985: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8039: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8063: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8080: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 8114: x_return_status := FND_API.G_RET_STS_ERROR;

8110: AND cz_ui_defs.deleted_flag = '0'
8111: AND cz_ui_defs.seeded_flag <> '1';
8112:
8113: IF (l_ui_name_tbl.count > 0 ) THEN
8114: x_return_status := FND_API.G_RET_STS_ERROR;
8115: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8116: LOOP
8117: FND_MESSAGE.SET_NAME('CZ', 'CZ_UMT_IN_USE');
8118: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 8156: x_return_status := FND_API.G_RET_STS_ERROR;

8152: AND cz_ui_cont_type_templs.seeded_flag <> '1')
8153: AND cz_ui_defs.deleted_flag = '0';
8154:
8155: IF (l_ui_name_tbl.count > 0 ) THEN
8156: x_return_status := FND_API.G_RET_STS_ERROR;
8157: FOR I IN l_ui_name_tbl.FIRST..l_ui_name_tbl.LAST
8158: LOOP
8159: FND_MESSAGE.SET_NAME('CZ', 'CZ_UCT_IN_USE');
8160: FND_MESSAGE.SET_TOKEN('NAME', l_object_name);

Line 8200: x_return_status := FND_API.g_ret_sts_error;

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

Line 8251: x_return_status := FND_API.g_ret_sts_error;

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

Line 8272: x_return_status := FND_API.g_ret_sts_error;

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

Line 8288: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
8289: WHEN OTHERS THEN
8290: handle_Error( p_procedure_name => 'is_repos_fld_deleteable',
8291: p_error_message => SQLERRM,
8292: x_return_status => x_return_status,

Line 8316: x_return_status := FND_API.g_ret_sts_success;

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

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

8331: CONNECT BY PRIOR cz_rp_entries.object_id = cz_rp_entries.enclosing_folder
8332: AND PRIOR cz_rp_entries.object_type = 'FLD';
8333:
8334: is_repos_fld_deleteable (p_rp_folder_id,x_return_status,x_msg_count,x_msg_data);
8335: IF ( (x_return_status = FND_API.g_ret_sts_success)
8336: AND (l_rp_fld_tbl.COUNT > 0) ) THEN
8337: FOR I IN l_rp_fld_tbl.FIRST..l_rp_fld_tbl.LAST
8338: LOOP
8339: l_object_typ_tbl.DELETE;

Line 8361: p_lock_child_models => FND_API.G_FALSE,

8357: IF (l_object_typ_tbl(i) = 'PRJ') THEN
8358: cz_security_pvt.lock_model(
8359: p_api_version => 1.0,
8360: p_model_id => l_object_id_tbl(i),
8361: p_lock_child_models => FND_API.G_FALSE,
8362: p_commit_flag => FND_API.G_FALSE,
8363: x_locked_entities => l_locked_models_tbl,
8364: x_return_status => x_return_status,
8365: x_msg_count => x_msg_count,

Line 8362: p_commit_flag => FND_API.G_FALSE,

8358: cz_security_pvt.lock_model(
8359: p_api_version => 1.0,
8360: p_model_id => l_object_id_tbl(i),
8361: p_lock_child_models => FND_API.G_FALSE,
8362: p_commit_flag => FND_API.G_FALSE,
8363: x_locked_entities => l_locked_models_tbl,
8364: x_return_status => x_return_status,
8365: x_msg_count => x_msg_count,
8366: x_msg_data => x_msg_data);

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

8363: x_locked_entities => l_locked_models_tbl,
8364: x_return_status => x_return_status,
8365: x_msg_count => x_msg_count,
8366: x_msg_data => x_msg_data);
8367: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8368: SELECT name INTO l_model_name FROM cz_devl_projects
8369: WHERE devl_project_id = l_object_id_tbl(i);
8370: RAISE FAILED_TO_LOCK_PRJ;
8371: END IF;

Line 8380: p_commit_flag => FND_API.G_FALSE,

8376: ELSIF (l_object_typ_tbl(i) = 'UCT') THEN
8377: cz_security_pvt.lock_template(
8378: p_api_version => 1.0,
8379: p_template_id => l_object_id_tbl(i),
8380: p_commit_flag => FND_API.G_FALSE,
8381: p_init_msg_list => FND_API.G_FALSE,
8382: x_return_status => x_return_status,
8383: x_msg_count => x_msg_count,
8384: x_msg_data => x_msg_data);

Line 8381: p_init_msg_list => FND_API.G_FALSE,

8377: cz_security_pvt.lock_template(
8378: p_api_version => 1.0,
8379: p_template_id => l_object_id_tbl(i),
8380: p_commit_flag => FND_API.G_FALSE,
8381: p_init_msg_list => FND_API.G_FALSE,
8382: x_return_status => x_return_status,
8383: x_msg_count => x_msg_count,
8384: x_msg_data => x_msg_data);
8385: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

8381: p_init_msg_list => FND_API.G_FALSE,
8382: x_return_status => x_return_status,
8383: x_msg_count => x_msg_count,
8384: x_msg_data => x_msg_data);
8385: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8386: SELECT template_name INTO l_template_name FROM cz_ui_templates
8387: WHERE template_id = l_object_id_tbl(i);
8388: RAISE FAILED_TO_LOCK_UCT;
8389: END IF;

Line 8442: x_return_status := FND_API.G_RET_STS_ERROR;

8438: END LOOP;
8439: END IF;
8440: EXCEPTION
8441: WHEN FAILED_TO_LOCK_PRJ THEN
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,

Line 8449: x_return_status := FND_API.G_RET_STS_ERROR;

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',
8451: p_token_name1 => 'UCTNAME',
8452: p_token_value1 => l_template_name);
8453: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 11409: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 11495: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11501: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11507: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11513: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11519: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11525: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11531: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11537: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 11937: x_return_status := FND_API.g_ret_sts_success;

11933: ) IS
11934: l_new_class_name CZ_RULES.class_name%TYPE;
11935: BEGIN
11936:
11937: x_return_status := FND_API.g_ret_sts_success;
11938: x_msg_count := 0;
11939: x_msg_data := '';
11940:
11941: FOR i IN(SELECT args.argument_signature_id, args.java_data_type, args.data_type, args.argument_index, rul.class_name, rul.rule_id