APPS.CZ_PB_MGR dependencies on FND_API

Line 2995: x_return_status := FND_API.G_RET_STS_SUCCESS;

2991: l_chunk_tbl chunk_record_tbl;
2992: l_exportfinished BOOLEAN;
2993: BEGIN
2994: pbdebug := 22021;
2995: x_return_status := FND_API.G_RET_STS_SUCCESS;
2996: x_msg_count := 0;
2997: x_msg_data := '';
2998: jdr_docbuilder.REFRESH;
2999:

Line 3044: x_return_status := FND_API.G_RET_STS_ERROR;

3040: COMMIT;
3041: jdr_docbuilder.REFRESH;
3042: EXCEPTION
3043: WHEN document_is_null THEN
3044: x_return_status := FND_API.G_RET_STS_ERROR;
3045: x_msg_count := 1;
3046: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3047: RAISE;
3048: WHEN OTHERS THEN

Line 3049: x_return_status := FND_API.G_RET_STS_ERROR;

3045: x_msg_count := 1;
3046: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3047: RAISE;
3048: WHEN OTHERS THEN
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050: x_msg_count := 1;
3051: x_msg_data := SQLERRM;
3052: RAISE;
3053: END collect_chunks;

Line 3103: x_return_status := FND_API.G_RET_STS_SUCCESS;

3099: l_chunk_tbl chunk_record_tbl;
3100: l_exportfinished BOOLEAN;
3101: BEGIN
3102: pbdebug := 22022;
3103: x_return_status := FND_API.G_RET_STS_SUCCESS;
3104: x_msg_count := 0;
3105: x_msg_data := '';
3106: jdr_docbuilder.REFRESH;
3107:

Line 3226: x_return_status := FND_API.G_RET_STS_ERROR;

3222: COMMIT;
3223: jdr_docbuilder.REFRESH;
3224: EXCEPTION
3225: WHEN document_is_null THEN
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: x_msg_count := 1;
3228: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3229: RAISE;
3230: WHEN OTHERS THEN

Line 3231: x_return_status := FND_API.G_RET_STS_ERROR;

3227: x_msg_count := 1;
3228: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3229: RAISE;
3230: WHEN OTHERS THEN
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: x_msg_count := 1;
3233: x_msg_data := SQLERRM;
3234: RAISE;
3235: END collect_chunks;

Line 3434: x_return_status := FND_API.G_RET_STS_ERROR;

3430: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';
3431: EXCEPTION
3432: WHEN NO_DATA_FOUND
3433: THEN
3434: x_return_status := FND_API.G_RET_STS_ERROR;
3435: x_msg_count := 1;
3436: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3437: WHEN OTHERS
3438: THEN

Line 3439: x_return_status := fnd_api.g_ret_sts_unexp_error;

3435: x_msg_count := 1;
3436: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3437: WHEN OTHERS
3438: THEN
3439: x_return_status := fnd_api.g_ret_sts_unexp_error;
3440: x_msg_count := 1;
3441: x_msg_data := cz_utils.get_text('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
3442: END export_jrad_docs;
3443:

Line 3487: x_return_status := FND_API.G_RET_STS_ERROR;

3483: END IF;
3484: EXCEPTION
3485: WHEN link_name_is_null
3486: THEN
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488: x_msg_data := 'Db Link Name is Null';
3489: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
3490: WHEN NO_DATA_FOUND
3491: THEN

Line 3492: x_return_status := FND_API.G_RET_STS_ERROR;

3488: x_msg_data := 'Db Link Name is Null';
3489: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
3490: WHEN NO_DATA_FOUND
3491: THEN
3492: x_return_status := FND_API.G_RET_STS_ERROR;
3493: x_msg_count := 1;
3494: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_ui_def_id);
3495: WHEN OTHERS
3496: THEN

Line 3497: x_return_status := fnd_api.g_ret_sts_unexp_error;

3493: x_msg_count := 1;
3494: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_ui_def_id);
3495: WHEN OTHERS
3496: THEN
3497: x_return_status := fnd_api.g_ret_sts_unexp_error;
3498: x_msg_count := 1;
3499: x_msg_data := cz_utils.get_text('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
3500: END export_jrad_docs;
3501:

Line 3540: x_return_status := FND_API.G_RET_STS_ERROR;

3536: END IF;
3537: EXCEPTION
3538: WHEN OTHERS
3539: THEN
3540: x_return_status := FND_API.G_RET_STS_ERROR;
3541: x_msg_count := 1;
3542: x_msg_data := cz_utils.get_text('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
3543: END export_template_jrad_docs;
3544:

Line 3584: x_return_status := FND_API.G_RET_STS_SUCCESS;

3580: IF (l_ui_def_id_tbl.COUNT > 0)
3581: THEN
3582: FOR i IN l_ui_def_id_tbl.FIRST .. l_ui_def_id_tbl.LAST
3583: LOOP
3584: x_return_status := FND_API.G_RET_STS_SUCCESS;
3585: x_msg_data := '';
3586: export_template_jrad_docs(l_ui_def_id_tbl(i), l_template_id_tbl(i), l_link_name, x_return_status, x_msg_count, x_msg_data);
3587:
3588: IF (x_return_status = FND_API.G_RET_STS_ERROR)

Line 3588: IF (x_return_status = FND_API.G_RET_STS_ERROR)

3584: x_return_status := FND_API.G_RET_STS_SUCCESS;
3585: x_msg_data := '';
3586: export_template_jrad_docs(l_ui_def_id_tbl(i), l_template_id_tbl(i), l_link_name, x_return_status, x_msg_count, x_msg_data);
3587:
3588: IF (x_return_status = FND_API.G_RET_STS_ERROR)
3589: THEN
3590: log_pb_errors(x_msg_data, '0', 'EXPORTJRADDOCS', SQLCODE);
3591: END IF;
3592: END LOOP;

Line 3597: x_return_status := FND_API.G_RET_STS_ERROR;

3593: END IF;
3594: EXCEPTION
3595: WHEN link_name_is_null
3596: THEN
3597: x_return_status := FND_API.G_RET_STS_ERROR;
3598: x_msg_data := 'Db Link Name is Null';
3599: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
3600: WHEN OTHERS
3601: THEN

Line 3602: x_return_status := FND_API.G_RET_STS_ERROR;

3598: x_msg_data := 'Db Link Name is Null';
3599: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
3600: WHEN OTHERS
3601: THEN
3602: x_return_status := FND_API.G_RET_STS_ERROR;
3603: x_msg_data := SQLERRM;
3604: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
3605: END export_template_jrad_docs;
3606:

Line 4824: ,fnd_api.g_true

4820: END LOOP;
4821:
4822: cz_security_pvt.lock_template(1.0
4823: ,l_templates_to_lock
4824: ,fnd_api.g_true
4825: ,fnd_api.g_true
4826: ,l_locked_templates
4827: ,l_return_status
4828: ,l_msg_count

Line 4825: ,fnd_api.g_true

4821:
4822: cz_security_pvt.lock_template(1.0
4823: ,l_templates_to_lock
4824: ,fnd_api.g_true
4825: ,fnd_api.g_true
4826: ,l_locked_templates
4827: ,l_return_status
4828: ,l_msg_count
4829: ,l_msg_data

Line 4832: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

4828: ,l_msg_count
4829: ,l_msg_data
4830: );
4831:
4832: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4833: THEN
4834: RAISE failed_to_lock_template;
4835: END IF;
4836:

Line 4935: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

4931: ----------end insert into cz_rp_entries----------------
4932: END IF;
4933: -- END IF;
4934:
4935: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4936:
4937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4938: THEN
4939: RAISE failed_to_unlock_template;

Line 4937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

4933: -- END IF;
4934:
4935: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4936:
4937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4938: THEN
4939: RAISE failed_to_unlock_template;
4940: END IF;
4941: EXCEPTION

Line 4949: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

4945: l_msg_index := 1;
4946:
4947: WHILE l_msg_count > 0
4948: LOOP
4949: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
4950: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
4951: l_msg_index := l_msg_index + 1;
4952: l_msg_count := l_msg_count - 1;
4953: END LOOP;

Line 4955: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

4951: l_msg_index := l_msg_index + 1;
4952: l_msg_count := l_msg_count - 1;
4953: END LOOP;
4954:
4955: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4956: raise_application_error('-20020', 'FAILED_TO_LOCK_TEMPLATE');
4957: WHEN failed_to_unlock_template
4958: THEN
4959: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;

Line 4964: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

4960: l_msg_index := 1;
4961:
4962: WHILE l_msg_count > 0
4963: LOOP
4964: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
4965: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
4966: l_msg_index := l_msg_index + 1;
4967: l_msg_count := l_msg_count - 1;
4968: END LOOP;

Line 4973: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);

4969:
4970: raise_application_error('-20030', 'FAILED_TO_UNLOCK_TEMPLATE');
4971: WHEN OTHERS
4972: THEN
4973: cz_security_pvt.unlock_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, l_return_status, l_msg_count, l_msg_data);
4974: RAISE;
4975: END insert_ui_templates;
4976:
4977: --------------------------------------------------------------

Line 5873: x_return_status := FND_API.G_RET_STS_SUCCESS;

5869: l_child_ui_tbl cz_pb_mgr.t_ref;
5870: rec_count NUMBER := 0;
5871: plsql_table_list cz_pb_mgr.col_plsql_table_list;
5872: BEGIN
5873: x_return_status := FND_API.G_RET_STS_SUCCESS;
5874: cz_pb_mgr.v_status_code := 'OK';
5875:
5876: IF (p_ui_def_id IS NULL)
5877: THEN

Line 5971: x_return_status := FND_API.G_RET_STS_ERROR;

5967: END IF;
5968: EXCEPTION
5969: WHEN ui_def_id_is_null
5970: THEN
5971: x_return_status := FND_API.G_RET_STS_ERROR;
5972: x_msg_data := cz_utils.get_text('UI_DEF_ID_IS_NULL');
5973: x_msg_count := 1;
5974: WHEN ui_def_id_not_found
5975: THEN

Line 5976: x_return_status := FND_API.G_RET_STS_ERROR;

5972: x_msg_data := cz_utils.get_text('UI_DEF_ID_IS_NULL');
5973: x_msg_count := 1;
5974: WHEN ui_def_id_not_found
5975: THEN
5976: x_return_status := FND_API.G_RET_STS_ERROR;
5977: x_msg_data := cz_utils.get_text('UI_DEF_ID_NOT_FOUND', 'UIDEFID', p_ui_def_id);
5978: x_msg_count := 1;
5979: WHEN not_oa_style_ui
5980: THEN

Line 5981: x_return_status := FND_API.G_RET_STS_ERROR;

5977: x_msg_data := cz_utils.get_text('UI_DEF_ID_NOT_FOUND', 'UIDEFID', p_ui_def_id);
5978: x_msg_count := 1;
5979: WHEN not_oa_style_ui
5980: THEN
5981: x_return_status := FND_API.G_RET_STS_ERROR;
5982: x_msg_data := cz_utils.get_text('NOT_OA_STYLE_UI', 'UIDEFID', p_ui_def_id);
5983: x_msg_count := 1;
5984: WHEN OTHERS
5985: THEN

Line 5986: x_return_status := FND_API.G_RET_STS_ERROR;

5982: x_msg_data := cz_utils.get_text('NOT_OA_STYLE_UI', 'UIDEFID', p_ui_def_id);
5983: x_msg_count := 1;
5984: WHEN OTHERS
5985: THEN
5986: x_return_status := FND_API.G_RET_STS_ERROR;
5987: x_msg_data := cz_utils.get_text('FATAL_ERROR', 'UIDEFID', p_ui_def_id, 'ERROR', SQLERRM);
5988: x_msg_count := 1;
5989: END export_single_oa_ui;
5990:

Line 17292: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN

17288: EXECUTE IMMEDIATE 'BEGIN cz_diagnostics_pvt.verify_structure' || cz_pb_mgr.v_db_link || '(1.0, :1, ''0'', :2, :3, :4, :5); END;'
17289: USING cz_pb_mgr.target_root_model_id, IN OUT l_run_id, IN OUT l_return_status, IN OUT l_msg_count, IN OUT l_msg_data;
17290: END IF;
17291:
17292: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
17293:
17294: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17295: cz_pb_mgr.v_err_message := l_msg_data;
17296: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_diagnostics_pvt', -1);

Line 17530: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

17526: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');
17527: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.XFRINFO', SQLCODE);
17528: END;
17529:
17530: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
17531:
17532: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
17533: THEN
17534: l_msg_index := 1;

Line 17532: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)

17528: END;
17529:
17530: cz_security_pvt.lock_model(1.0, p_model_id, fnd_api.g_true, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
17531:
17532: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
17533: THEN
17534: l_msg_index := 1;
17535:
17536: WHILE l_msg_count > 0

Line 17538: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);

17534: l_msg_index := 1;
17535:
17536: WHILE l_msg_count > 0
17537: LOOP
17538: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
17539: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
17540: l_msg_index := l_msg_index + 1;
17541: l_msg_count := l_msg_count - 1;
17542: END LOOP;

Line 18124: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18120: DELETE FROM cz_pb_model_exports
18121: WHERE publication_id = v_pub_id;
18122: END IF;
18123:
18124: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18125:
18126: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
18127: THEN
18128: l_msg_index := 1;

Line 18126: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)

18122: END IF;
18123:
18124: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18125:
18126: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
18127: THEN
18128: l_msg_index := 1;
18129:
18130: WHILE l_msg_count > 0

Line 18132: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);

18128: l_msg_index := 1;
18129:
18130: WHILE l_msg_count > 0
18131: LOOP
18132: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
18133: l_msg_index := l_msg_index + 1;
18134: l_msg_count := l_msg_count - 1;
18135: END LOOP;
18136: END IF;

Line 18144: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18140: WHEN failed_to_lock_model
18141: THEN
18142: x_run_id := cz_pb_mgr.v_pb_run_id;
18143: x_status := PUBLICATION_ERROR;
18144: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18145: log_pb_trace;
18146: WHEN ui_not_uptodate THEN
18147: x_run_id := cz_pb_mgr.v_pb_run_id;
18148: x_status := PUBLICATION_ERROR;

Line 18149: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18145: log_pb_trace;
18146: WHEN ui_not_uptodate THEN
18147: x_run_id := cz_pb_mgr.v_pb_run_id;
18148: x_status := PUBLICATION_ERROR;
18149: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18150: log_pb_trace;
18151: WHEN OTHERS
18152: THEN
18153: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

Line 18153: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

18149: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18150: log_pb_trace;
18151: WHEN OTHERS
18152: THEN
18153: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
18154: cz_pb_mgr.v_err_message := 'Fatal error during deep model copy of model: ' || cz_pb_mgr.v_root_model_id;
18155: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18156: END;
18157:

Line 18171: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE

18167: ,p_copy_root IN NUMBER
18168: ,x_return_status OUT NOCOPY VARCHAR2
18169: ,x_msg_count OUT NOCOPY NUMBER
18170: ,x_msg_data OUT NOCOPY VARCHAR2
18171: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
18172: )
18173: IS
18174: TYPE message_tbl_type IS TABLE OF VARCHAR2(2000)
18175: INDEX BY BINARY_INTEGER;

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

18181: l_instr NUMBER := 0;
18182: BEGIN
18183:
18184: --initialize the message stack depending on the input parameter
18185: IF (p_init_msg_list = FND_API.G_TRUE) THEN
18186: fnd_msg_pub.initialize;
18187: END IF;
18188:
18189: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 18189: x_return_status := FND_API.G_RET_STS_SUCCESS;

18185: IF (p_init_msg_list = FND_API.G_TRUE) THEN
18186: fnd_msg_pub.initialize;
18187: END IF;
18188:
18189: x_return_status := FND_API.G_RET_STS_SUCCESS;
18190: x_msg_count := 0;
18191: x_msg_data := '';
18192: deep_model_copy(p_model_id, p_server_id, p_folder, p_copy_rules, p_copy_uis, p_copy_root, l_model_id, l_run_id, l_status);
18193:

Line 18196: x_return_status := FND_API.G_RET_STS_ERROR;

18192: deep_model_copy(p_model_id, p_server_id, p_folder, p_copy_rules, p_copy_uis, p_copy_root, l_model_id, l_run_id, l_status);
18193:
18194: IF (l_status = PUBLICATION_ERROR)
18195: THEN
18196: x_return_status := FND_API.G_RET_STS_ERROR;
18197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
18198: END IF;
18199: END deep_model_copy;
18200:

Line 19046: ,fnd_api.g_true

19042: END IF;
19043:
19044: cz_security_pvt.lock_model(1.0
19045: ,cz_pb_mgr.v_root_model_id
19046: ,fnd_api.g_true
19047: ,fnd_api.g_true
19048: ,l_locked_models
19049: ,l_lock_status
19050: ,l_msg_count

Line 19047: ,fnd_api.g_true

19043:
19044: cz_security_pvt.lock_model(1.0
19045: ,cz_pb_mgr.v_root_model_id
19046: ,fnd_api.g_true
19047: ,fnd_api.g_true
19048: ,l_locked_models
19049: ,l_lock_status
19050: ,l_msg_count
19051: ,l_msg_data

Line 19060: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', fnd_msg_pub.get(l_msg_index, fnd_api.g_false));

19056:
19057: WHILE l_msg_count > 0
19058: LOOP
19059: cz_pb_mgr.v_err_message :=
19060: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', fnd_msg_pub.get(l_msg_index, fnd_api.g_false));
19061: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
19062: l_msg_index := l_msg_index + 1;
19063: l_msg_count := l_msg_count - 1;
19064: END LOOP;

Line 19565: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19561: END IF; /* end if of (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) */
19562:
19563: l_msg_count := 0;
19564: l_msg_index := 0;
19565: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19566:
19567: IF (l_lock_status <> 'S') THEN
19568: l_msg_index := 1;
19569:

Line 19572: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);

19568: l_msg_index := 1;
19569:
19570: WHILE l_msg_count > 0
19571: LOOP
19572: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
19573: l_msg_index := l_msg_index + 1;
19574: l_msg_count := l_msg_count - 1;
19575: END LOOP;
19576: END IF;

Line 19631: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);

19627: x_run_id := cz_pb_mgr.v_pb_run_id;
19628: cz_pb_mgr.global_export_retcode := 2;
19629: update_publication_status(publicationid, PUBLICATION_ERROR, empty_string);
19630: update_pup_status(publicationid);
19631: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19632: log_pb_trace;
19633: delete_session_parameters;
19634: WHEN not_global_template THEN
19635: x_pb_status := PUBLICATION_ERROR;

Line 19788: x_return_status := FND_API.G_RET_STS_SUCCESS;

19784: cannot_del_pup EXCEPTION;
19785: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
19786: BEGIN
19787: fnd_msg_pub.initialize;
19788: x_return_status := FND_API.G_RET_STS_SUCCESS;
19789: x_msg_count := 0;
19790: x_msg_data := '';
19791: fnd_msg_pub.initialize;
19792:

Line 19937: x_return_status := FND_API.G_RET_STS_ERROR;

19933: END IF;
19934: EXCEPTION
19935: WHEN no_link_name
19936: THEN
19937: x_return_status := FND_API.G_RET_STS_ERROR;
19938: fnd_message.set_name('CZ', 'CZ_NO_LINK_NAME');
19939: fnd_msg_pub.ADD;
19940: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19941: WHEN cannot_del_pup

Line 19943: x_return_status := FND_API.G_RET_STS_ERROR;

19939: fnd_msg_pub.ADD;
19940: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19941: WHEN cannot_del_pup
19942: THEN
19943: x_return_status := FND_API.G_RET_STS_ERROR;
19944: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');
19945: fnd_message.set_token('PUBID', publicationid);
19946: fnd_msg_pub.ADD;
19947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 19950: x_return_status := FND_API.G_RET_STS_ERROR;

19946: fnd_msg_pub.ADD;
19947: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19948: WHEN invalid_object_type
19949: THEN
19950: x_return_status := FND_API.G_RET_STS_ERROR;
19951: fnd_message.set_name('CZ', 'CZ_INVALID_PUB_TYPE');
19952: fnd_msg_pub.ADD;
19953: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19954: WHEN template_in_use

Line 19957: x_return_status := FND_API.G_RET_STS_ERROR;

19953: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19954: WHEN template_in_use
19955: THEN
19956: x_msg_data := cz_utils.get_text('CZ_TEMPLATE_IN_USE');
19957: x_return_status := FND_API.G_RET_STS_ERROR;
19958: fnd_message.set_name('CZ', 'CZ_TEMPLATE_IN_USE');
19959: fnd_msg_pub.ADD;
19960: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19961: WHEN OTHERS

Line 19963: x_return_status := FND_API.G_RET_STS_ERROR;

19959: fnd_msg_pub.ADD;
19960: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19961: WHEN OTHERS
19962: THEN
19963: x_return_status := FND_API.G_RET_STS_ERROR;
19964: x_msg_data := SQLERRM;
19965: END delete_publication;
19966:
19967: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 19984: x_return_status := FND_API.G_RET_STS_SUCCESS;

19980: v_export_status cz_model_publications.export_status%TYPE;
19981: cannot_disable_template EXCEPTION;
19982: cannot_disable_publication EXCEPTION;
19983: BEGIN
19984: x_return_status := FND_API.G_RET_STS_SUCCESS;
19985: fnd_msg_pub.initialize;
19986: --execute the procedure that obsoletes the records
19987: --if the target has been converted into a development
19988: --instance

Line 19991: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

19987: --if the target has been converted into a development
19988: --instance
19989: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
19990:
19991: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
19992: THEN
19993: RAISE pub_maybe_obsoleted;
19994: END IF;
19995:

Line 20052: x_return_status := FND_API.G_RET_STS_ERROR;

20048: EXCEPTION
20049: WHEN cannot_disable_publication
20050: THEN
20051: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
20052: x_return_status := FND_API.G_RET_STS_ERROR;
20053: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
20054: fnd_message.set_token('STATUS', v_export_status);
20055: fnd_message.set_token('PUBID', publicationid);
20056: fnd_msg_pub.ADD;

Line 20060: x_return_status := FND_API.G_RET_STS_ERROR;

20056: fnd_msg_pub.ADD;
20057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20058: WHEN pub_maybe_obsoleted
20059: THEN
20060: x_return_status := FND_API.G_RET_STS_ERROR;
20061: WHEN cannot_disable_template
20062: THEN
20063: x_msg_data := cz_utils.get_text('CZ_CANT_DISABLE_TEMPL', 'PUBID', publicationid);
20064: x_return_status := FND_API.G_RET_STS_ERROR;

Line 20064: x_return_status := FND_API.G_RET_STS_ERROR;

20060: x_return_status := FND_API.G_RET_STS_ERROR;
20061: WHEN cannot_disable_template
20062: THEN
20063: x_msg_data := cz_utils.get_text('CZ_CANT_DISABLE_TEMPL', 'PUBID', publicationid);
20064: x_return_status := FND_API.G_RET_STS_ERROR;
20065: WHEN OTHERS
20066: THEN
20067: x_return_status := FND_API.G_RET_STS_ERROR;
20068: x_msg_data := SQLERRM;

Line 20067: x_return_status := FND_API.G_RET_STS_ERROR;

20063: x_msg_data := cz_utils.get_text('CZ_CANT_DISABLE_TEMPL', 'PUBID', publicationid);
20064: x_return_status := FND_API.G_RET_STS_ERROR;
20065: WHEN OTHERS
20066: THEN
20067: x_return_status := FND_API.G_RET_STS_ERROR;
20068: x_msg_data := SQLERRM;
20069: END disable_publication;
20070:
20071: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 20356: x_return_status := FND_API.G_RET_STS_SUCCESS;

20352: status_str VARCHAR2(200) := '0';
20353: no_pub_found EXCEPTION;
20354: l_publication_id NUMBER;
20355: BEGIN
20356: x_return_status := FND_API.G_RET_STS_SUCCESS;
20357: fnd_msg_pub.initialize;
20358: v_application_id_tbl.DELETE;
20359: v_usage_id_tbl.DELETE;
20360: v_language_id_tbl.DELETE;

Line 20366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

20362: --if the target has been converted into a development
20363: --instance
20364: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
20365:
20366: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
20367: THEN
20368: RAISE pub_maybe_obsoleted;
20369: END IF;
20370:

Line 20390: x_return_status := FND_API.G_RET_STS_ERROR;

20386: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
20387:
20388: IF (v_count = 0)
20389: THEN
20390: x_return_status := FND_API.G_RET_STS_ERROR;
20391: x_msg_count := 1;
20392: x_msg_data := 'PUBLICATION HAS STATUS /PRC/PUP/' || model_publication_obselete;
20393: ELSE
20394: get_edit_info(publicationid, v_product_key, v_publication_mode, v_server_id, v_export_status, v_source_target_flag, v_remote_publication_id);

Line 20428: x_return_status := FND_API.G_RET_STS_ERROR;

20424: );
20425:
20426: IF (status_str = '-1')
20427: THEN
20428: x_return_status := FND_API.G_RET_STS_ERROR;
20429: x_msg_count := 1;
20430: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20431: ELSE
20432: COMMIT;

Line 20438: x_return_status := FND_API.G_RET_STS_SUCCESS;

20434: END IF;
20435: EXCEPTION
20436: WHEN pub_maybe_obsoleted
20437: THEN
20438: x_return_status := FND_API.G_RET_STS_SUCCESS;
20439: WHEN no_pub_found
20440: THEN
20441: x_return_status := FND_API.G_RET_STS_SUCCESS;
20442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 20441: x_return_status := FND_API.G_RET_STS_SUCCESS;

20437: THEN
20438: x_return_status := FND_API.G_RET_STS_SUCCESS;
20439: WHEN no_pub_found
20440: THEN
20441: x_return_status := FND_API.G_RET_STS_SUCCESS;
20442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20443: WHEN OTHERS
20444: THEN
20445: x_return_status := FND_API.G_RET_STS_ERROR;

Line 20445: x_return_status := FND_API.G_RET_STS_ERROR;

20441: x_return_status := FND_API.G_RET_STS_SUCCESS;
20442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20443: WHEN OTHERS
20444: THEN
20445: x_return_status := FND_API.G_RET_STS_ERROR;
20446: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20447: END edit_publication;
20448:
20449: --------------------------------------------------------

Line 20482: x_return_status := FND_API.G_RET_STS_SUCCESS;

20478: status_str VARCHAR2(200) := '0';
20479: no_pub_found EXCEPTION;
20480: l_publication_id NUMBER;
20481: BEGIN
20482: x_return_status := FND_API.G_RET_STS_SUCCESS;
20483: fnd_msg_pub.initialize;
20484: --execute the procedure that obsoletes the records
20485: --if the target has been converted into a development
20486: --instance

Line 20489: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

20485: --if the target has been converted into a development
20486: --instance
20487: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
20488:
20489: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
20490: THEN
20491: RAISE pub_maybe_obsoleted;
20492: END IF;
20493:

Line 20512: x_return_status := FND_API.G_RET_STS_ERROR;

20508: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
20509:
20510: IF (v_count = 0)
20511: THEN
20512: x_return_status := FND_API.G_RET_STS_ERROR;
20513: x_msg_count := 1;
20514: x_msg_data := 'PUBLICATION HAS STATUS /PRC/PUP';
20515: ELSE
20516: get_edit_info(publicationid, v_product_key, v_publication_mode, v_server_id, v_export_status, v_source_target_flag, v_remote_publication_id);

Line 20547: x_return_status := FND_API.G_RET_STS_ERROR;

20543: );
20544:
20545: IF (status_str = '-1')
20546: THEN
20547: x_return_status := FND_API.G_RET_STS_ERROR;
20548: x_msg_count := 1;
20549: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20550: END IF;
20551: END IF;

Line 20555: x_return_status := FND_API.G_RET_STS_SUCCESS;

20551: END IF;
20552: EXCEPTION
20553: WHEN pub_maybe_obsoleted
20554: THEN
20555: x_return_status := FND_API.G_RET_STS_SUCCESS;
20556: WHEN no_pub_found
20557: THEN
20558: x_return_status := FND_API.G_RET_STS_SUCCESS;
20559: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 20558: x_return_status := FND_API.G_RET_STS_SUCCESS;

20554: THEN
20555: x_return_status := FND_API.G_RET_STS_SUCCESS;
20556: WHEN no_pub_found
20557: THEN
20558: x_return_status := FND_API.G_RET_STS_SUCCESS;
20559: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20560: WHEN OTHERS
20561: THEN
20562: x_return_status := FND_API.G_RET_STS_ERROR;

Line 20562: x_return_status := FND_API.G_RET_STS_ERROR;

20558: x_return_status := FND_API.G_RET_STS_SUCCESS;
20559: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
20560: WHEN OTHERS
20561: THEN
20562: x_return_status := FND_API.G_RET_STS_ERROR;
20563: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20564: END edit_publication;
20565:
20566: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 20600: x_return_status := FND_API.G_RET_STS_SUCCESS;

20596: status_str VARCHAR2(200) := '0';
20597: no_pub_found EXCEPTION;
20598: l_publication_id NUMBER;
20599: BEGIN
20600: x_return_status := FND_API.G_RET_STS_SUCCESS;
20601: fnd_msg_pub.initialize;
20602: v_application_id_tbl.DELETE;
20603: v_usage_id_tbl.DELETE;
20604: v_language_id_tbl.DELETE;

Line 20610: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

20606: --if the target has been converted into a development
20607: --instance
20608: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
20609:
20610: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
20611: THEN
20612: RAISE pub_maybe_obsoleted;
20613: END IF;
20614:

Line 20633: x_return_status := FND_API.G_RET_STS_ERROR;

20629: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
20630:
20631: IF (v_count = 0)
20632: THEN
20633: x_return_status := FND_API.G_RET_STS_ERROR;
20634: x_msg_count := 1;
20635: x_msg_data := 'PUBLICATION HAS STATUS /PRC/PUP';
20636: ELSE
20637: get_edit_info(publicationid, v_product_key, v_publication_mode, v_server_id, v_export_status, v_source_target_flag, v_remote_publication_id);

Line 20674: x_return_status := FND_API.G_RET_STS_ERROR;

20670: );
20671:
20672: IF (status_str = '-1')
20673: THEN
20674: x_return_status := FND_API.G_RET_STS_ERROR;
20675: x_msg_count := 1;
20676: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20677: END IF;
20678: END IF;

Line 20682: x_return_status := FND_API.G_RET_STS_SUCCESS;

20678: END IF;
20679: EXCEPTION
20680: WHEN pub_maybe_obsoleted
20681: THEN
20682: x_return_status := FND_API.G_RET_STS_SUCCESS;
20683: WHEN no_pub_found
20684: THEN
20685: x_return_status := FND_API.G_RET_STS_SUCCESS;
20686: WHEN OTHERS

Line 20685: x_return_status := FND_API.G_RET_STS_SUCCESS;

20681: THEN
20682: x_return_status := FND_API.G_RET_STS_SUCCESS;
20683: WHEN no_pub_found
20684: THEN
20685: x_return_status := FND_API.G_RET_STS_SUCCESS;
20686: WHEN OTHERS
20687: THEN
20688: x_return_status := FND_API.G_RET_STS_ERROR;
20689: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);

Line 20688: x_return_status := FND_API.G_RET_STS_ERROR;

20684: THEN
20685: x_return_status := FND_API.G_RET_STS_SUCCESS;
20686: WHEN OTHERS
20687: THEN
20688: x_return_status := FND_API.G_RET_STS_ERROR;
20689: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20690: END edit_tgt_pub;
20691:
20692: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 21145: x_return_status := FND_API.G_RET_STS_SUCCESS;

21141: model_not_upto_date EXCEPTION;
21142: pub_overlap EXCEPTION;
21143: ui_def_id_is_deleted EXCEPTION;
21144: BEGIN
21145: x_return_status := FND_API.G_RET_STS_SUCCESS;
21146: fnd_msg_pub.initialize;
21147: --execute the procedure that obsoletes the records
21148: --if the target has been converted into a development
21149: --instance

Line 21153: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

21149: --instance
21150: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21151:
21152: ----check status
21153: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21154: THEN
21155: RAISE pub_maybe_obsoleted;
21156: END IF;
21157:

Line 21254: x_return_status := FND_API.G_RET_STS_ERROR;

21250: EXCEPTION
21251: WHEN pub_overlap
21252: THEN
21253: ROLLBACK;
21254: x_return_status := FND_API.G_RET_STS_ERROR;
21255: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21256: fnd_message.set_token('PubId', p_publication_id);
21257: fnd_message.set_token('PUBSTR', v_publicationidstring);
21258: fnd_msg_pub.ADD;

Line 21262: x_return_status := FND_API.G_RET_STS_ERROR;

21258: fnd_msg_pub.ADD;
21259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21260: WHEN ui_def_id_is_deleted
21261: THEN
21262: x_return_status := FND_API.G_RET_STS_ERROR;
21263:
21264: IF (l_ui_name IS NOT NULL)
21265: THEN
21266: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');

Line 21279: x_return_status := FND_API.G_RET_STS_ERROR;

21275: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21276: WHEN model_not_upto_date
21277: THEN
21278: ROLLBACK;
21279: x_return_status := FND_API.G_RET_STS_ERROR;
21280: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
21281: fnd_message.set_token('PubId', p_publication_id);
21282: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
21283: fnd_msg_pub.ADD;

Line 21288: x_return_status := FND_API.G_RET_STS_ERROR;

21284: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21285: WHEN get_params_exception
21286: THEN
21287: ROLLBACK;
21288: x_return_status := FND_API.G_RET_STS_ERROR;
21289: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
21290: fnd_message.set_token('PubId', p_publication_id);
21291: fnd_msg_pub.ADD;
21292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 21296: x_return_status := FND_API.G_RET_STS_ERROR;

21292: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21293: WHEN expstatus_exception
21294: THEN
21295: ROLLBACK;
21296: x_return_status := FND_API.G_RET_STS_ERROR;
21297: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
21298: fnd_message.set_token('PubId', p_publication_id);
21299: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
21300: fnd_msg_pub.ADD;

Line 21305: x_return_status := fnd_api.g_ret_sts_unexp_error;

21301: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21302: cz_pb_mgr.v_republish_model := no_mode;
21303: WHEN pub_maybe_obsoleted
21304: THEN
21305: x_return_status := fnd_api.g_ret_sts_unexp_error;
21306: WHEN OTHERS
21307: THEN
21308: ROLLBACK;
21309: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 21309: x_return_status := fnd_api.g_ret_sts_unexp_error;

21305: x_return_status := fnd_api.g_ret_sts_unexp_error;
21306: WHEN OTHERS
21307: THEN
21308: ROLLBACK;
21309: x_return_status := fnd_api.g_ret_sts_unexp_error;
21310: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
21311: fnd_message.set_token('PubId', p_publication_id);
21312: fnd_message.set_token('SQLERRM', SQLERRM);
21313: fnd_msg_pub.ADD;

Line 21645: x_return_status := FND_API.G_RET_STS_SUCCESS;

21641: get_params_exception EXCEPTION;
21642: pub_overlap EXCEPTION;
21643: cannot_enable_publication EXCEPTION;
21644: BEGIN
21645: x_return_status := FND_API.G_RET_STS_SUCCESS;
21646: fnd_msg_pub.initialize;
21647: --execute the procedure that obsoletes the records
21648: --if the target has been converted into a development
21649: --instance

Line 21652: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

21648: --if the target has been converted into a development
21649: --instance
21650: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21651:
21652: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21653: THEN
21654: RAISE pub_maybe_obsoleted;
21655: END IF;
21656:

Line 21757: x_return_status := FND_API.G_RET_STS_ERROR;

21753: THEN
21754: NULL;
21755: WHEN cannot_enable_publication
21756: THEN
21757: x_return_status := FND_API.G_RET_STS_ERROR;
21758: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
21759: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
21760: fnd_message.set_token('STATUS', v_export_status);
21761: fnd_message.set_token('PUBID', publicationid);

Line 21767: x_return_status := FND_API.G_RET_STS_ERROR;

21763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21764: WHEN cannot_enable_template
21765: THEN
21766: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
21767: x_return_status := FND_API.G_RET_STS_ERROR;
21768: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');
21769: fnd_message.set_token('PUBID', publicationid);
21770: fnd_msg_pub.ADD;
21771: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 21775: x_return_status := FND_API.G_RET_STS_ERROR;

21771: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21772: WHEN get_params_exception
21773: THEN
21774: ROLLBACK;
21775: x_return_status := FND_API.G_RET_STS_ERROR;
21776: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
21777: fnd_message.set_token('PUBID', publicationid);
21778: fnd_msg_pub.ADD;
21779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 21783: x_return_status := FND_API.G_RET_STS_ERROR;

21779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21780: WHEN pub_overlap
21781: THEN
21782: ROLLBACK;
21783: x_return_status := FND_API.G_RET_STS_ERROR;
21784: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
21785: fnd_message.set_token('PUBID', publicationid);
21786: fnd_message.set_token('PUBSTR', l_publicationidstring);
21787: fnd_msg_pub.ADD;

Line 21791: x_return_status := FND_API.G_RET_STS_ERROR;

21787: fnd_msg_pub.ADD;
21788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21789: WHEN pub_maybe_obsoleted
21790: THEN
21791: x_return_status := FND_API.G_RET_STS_ERROR;
21792: WHEN OTHERS
21793: THEN
21794: x_return_status := FND_API.G_RET_STS_ERROR;
21795: x_msg_data := SQLERRM;

Line 21794: x_return_status := FND_API.G_RET_STS_ERROR;

21790: THEN
21791: x_return_status := FND_API.G_RET_STS_ERROR;
21792: WHEN OTHERS
21793: THEN
21794: x_return_status := FND_API.G_RET_STS_ERROR;
21795: x_msg_data := SQLERRM;
21796: END enable_publication;
21797:
21798: ---------------------------------

Line 21907: x_return_status := FND_API.G_RET_STS_SUCCESS;

21903: no_ui_id EXCEPTION;
21904: product_key_is_null EXCEPTION;
21905: PUB_SOURCE_FLAG CONSTANT VARCHAR2(1) := 'S';
21906: BEGIN
21907: x_return_status := FND_API.G_RET_STS_SUCCESS;
21908: fnd_msg_pub.initialize;
21909:
21910: -----check if model id passed in is not null
21911: -----if not null then check if the model exists and is

Line 22125: x_return_status := FND_API.G_RET_STS_ERROR;

22121: x_publication_id := v_new_publication_id;
22122: EXCEPTION
22123: WHEN product_key_is_null
22124: THEN
22125: x_return_status := FND_API.G_RET_STS_ERROR;
22126: fnd_message.set_name('CZ', 'CZ_PRODUCT_KEY_IS_NULL');
22127: fnd_msg_pub.ADD;
22128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22129: WHEN no_model_id

Line 22131: x_return_status := FND_API.G_RET_STS_ERROR;

22127: fnd_msg_pub.ADD;
22128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22129: WHEN no_model_id
22130: THEN
22131: x_return_status := FND_API.G_RET_STS_ERROR;
22132: fnd_message.set_name('CZ', 'cz_pb_mgr_MODEL_ID_NULL');
22133: fnd_msg_pub.ADD;
22134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22135: WHEN no_model_exists

Line 22137: x_return_status := FND_API.G_RET_STS_ERROR;

22133: fnd_msg_pub.ADD;
22134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22135: WHEN no_model_exists
22136: THEN
22137: x_return_status := FND_API.G_RET_STS_ERROR;
22138: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');
22139: fnd_message.set_token('MODELID', p_model_id);
22140: fnd_msg_pub.ADD;
22141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22144: x_return_status := FND_API.G_RET_STS_ERROR;

22140: fnd_msg_pub.ADD;
22141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22142: WHEN no_ui_exists
22143: THEN
22144: x_return_status := FND_API.G_RET_STS_ERROR;
22145: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');
22146: fnd_message.set_token('MODELID', p_model_id);
22147: fnd_msg_pub.ADD;
22148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22151: x_return_status := FND_API.G_RET_STS_ERROR;

22147: fnd_msg_pub.ADD;
22148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22149: WHEN invalid_pb_mode
22150: THEN
22151: x_return_status := FND_API.G_RET_STS_ERROR;
22152: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');
22153: fnd_message.set_token('PBMODE', l_publication_mode);
22154: fnd_msg_pub.ADD;
22155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22158: x_return_status := FND_API.G_RET_STS_ERROR;

22154: fnd_msg_pub.ADD;
22155: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22156: WHEN no_appl_id
22157: THEN
22158: x_return_status := FND_API.G_RET_STS_ERROR;
22159: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_APPL_ID');
22160: fnd_msg_pub.ADD;
22161: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22162: WHEN pub_overlap

Line 22164: x_return_status := FND_API.G_RET_STS_ERROR;

22160: fnd_msg_pub.ADD;
22161: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22162: WHEN pub_overlap
22163: THEN
22164: x_return_status := FND_API.G_RET_STS_ERROR;
22165: fnd_message.set_name('CZ', 'PUB_OVERLAP');
22166: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);
22167: fnd_msg_pub.ADD;
22168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22171: x_return_status := FND_API.G_RET_STS_ERROR;

22167: fnd_msg_pub.ADD;
22168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22169: WHEN model_not_upto_date
22170: THEN
22171: x_return_status := FND_API.G_RET_STS_ERROR;
22172: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
22173: fnd_message.set_token('UPTODATESTR', v_upto_date_status);
22174: fnd_msg_pub.ADD;
22175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 22178: x_return_status := FND_API.G_RET_STS_ERROR;

22174: fnd_msg_pub.ADD;
22175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22176: WHEN OTHERS
22177: THEN
22178: x_return_status := FND_API.G_RET_STS_ERROR;
22179: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
22180: fnd_message.set_token('ERROR', SQLERRM);
22181: fnd_msg_pub.ADD;
22182: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);