[Home] [Help]
3607: l_chunk_tbl chunk_record_tbl;
3608: l_exportfinished BOOLEAN;
3609: BEGIN
3610: pbdebug := 22021;
3611: x_return_status := FND_API.G_RET_STS_SUCCESS;
3612: x_msg_count := 0;
3613: x_msg_data := '';
3614: jdr_docbuilder.REFRESH;
3615:
3660: COMMIT;
3661: jdr_docbuilder.REFRESH;
3662: EXCEPTION
3663: WHEN document_is_null THEN
3664: x_return_status := FND_API.G_RET_STS_ERROR;
3665: x_msg_count := 1;
3666: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3667: RAISE;
3668: WHEN OTHERS THEN
3665: x_msg_count := 1;
3666: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3667: RAISE;
3668: WHEN OTHERS THEN
3669: x_return_status := FND_API.G_RET_STS_ERROR;
3670: x_msg_count := 1;
3671: x_msg_data := SQLERRM;
3672: RAISE;
3673: END collect_chunks;
3719: l_chunk_tbl chunk_record_tbl;
3720: l_exportfinished BOOLEAN;
3721: BEGIN
3722: pbdebug := 22022;
3723: x_return_status := FND_API.G_RET_STS_SUCCESS;
3724: x_msg_count := 0;
3725: x_msg_data := '';
3726: jdr_docbuilder.REFRESH;
3727:
3844: COMMIT;
3845: jdr_docbuilder.REFRESH;
3846: EXCEPTION
3847: WHEN document_is_null THEN
3848: x_return_status := FND_API.G_RET_STS_ERROR;
3849: x_msg_count := 1;
3850: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3851: RAISE;
3852: WHEN OTHERS THEN
3849: x_msg_count := 1;
3850: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
3851: RAISE;
3852: WHEN OTHERS THEN
3853: x_return_status := FND_API.G_RET_STS_ERROR;
3854: x_msg_count := 1;
3855: x_msg_data := SQLERRM;
3856: RAISE;
3857: END collect_chunks;
4062:
4063: EXCEPTION
4064: WHEN NO_DATA_FOUND
4065: THEN
4066: x_return_status := FND_API.G_RET_STS_ERROR;
4067: x_msg_count := 1;
4068: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
4069: WHEN OTHERS
4070: THEN
4067: x_msg_count := 1;
4068: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_document_name);
4069: WHEN OTHERS
4070: THEN
4071: x_return_status := fnd_api.g_ret_sts_unexp_error;
4072: x_msg_count := 1;
4073: x_msg_data := cz_utils.get_text('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
4074: END export_jrad_docs;
4075:
4117: END IF;
4118: EXCEPTION
4119: WHEN link_name_is_null
4120: THEN
4121: x_return_status := FND_API.G_RET_STS_ERROR;
4122: x_msg_data := 'Db Link Name is Null';
4123: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
4124: WHEN NO_DATA_FOUND
4125: THEN
4122: x_msg_data := 'Db Link Name is Null';
4123: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
4124: WHEN NO_DATA_FOUND
4125: THEN
4126: x_return_status := FND_API.G_RET_STS_ERROR;
4127: x_msg_count := 1;
4128: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_ui_def_id);
4129: WHEN OTHERS
4130: THEN
4127: x_msg_count := 1;
4128: x_msg_data := cz_utils.get_text('CZ_NO_JRADDOC_EXISTS', 'DOC', p_ui_def_id);
4129: WHEN OTHERS
4130: THEN
4131: x_return_status := fnd_api.g_ret_sts_unexp_error;
4132: x_msg_count := 1;
4133: x_msg_data := cz_utils.get_text('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
4134: END export_jrad_docs;
4135:
4173:
4174: EXCEPTION
4175: WHEN OTHERS
4176: THEN
4177: x_return_status := FND_API.G_RET_STS_ERROR;
4178: x_msg_count := 1;
4179: x_msg_data := cz_utils.get_text('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
4180: END export_template_jrad_docs;
4181:
4218: IF (l_ui_def_id_tbl.COUNT > 0)
4219: THEN
4220: FOR i IN l_ui_def_id_tbl.FIRST .. l_ui_def_id_tbl.LAST
4221: LOOP
4222: x_return_status := FND_API.G_RET_STS_SUCCESS;
4223: x_msg_data := '';
4224: 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);
4225:
4226: IF (x_return_status = FND_API.G_RET_STS_ERROR)
4222: x_return_status := FND_API.G_RET_STS_SUCCESS;
4223: x_msg_data := '';
4224: 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);
4225:
4226: IF (x_return_status = FND_API.G_RET_STS_ERROR)
4227: THEN
4228: log_pb_errors(x_msg_data, '0', 'EXPORTJRADDOCS', SQLCODE);
4229: END IF;
4230: END LOOP;
4231: END IF;
4232: EXCEPTION
4233: WHEN link_name_is_null
4234: THEN
4235: x_return_status := FND_API.G_RET_STS_ERROR;
4236: x_msg_data := 'Db Link Name is Null';
4237: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
4238: WHEN OTHERS
4239: THEN
4236: x_msg_data := 'Db Link Name is Null';
4237: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
4238: WHEN OTHERS
4239: THEN
4240: x_return_status := FND_API.G_RET_STS_ERROR;
4241: x_msg_data := SQLERRM;
4242: log_pb_errors(x_msg_data, '2', 'EXPORTJRADDOCS', SQLCODE);
4243: END export_template_jrad_docs;
4244:
5530: --If the there is no multi-server flag then will continue with regular locking.
5531: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5532: cz_security_pvt.lock_pub_template(1.0
5533: ,l_templates_to_lock
5534: ,fnd_api.g_true
5535: ,fnd_api.g_true
5536: ,cz_pb_mgr.v_server_id
5537: ,cz_pb_mgr.v_publication_id
5538: ,l_locked_templates
5531: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5532: cz_security_pvt.lock_pub_template(1.0
5533: ,l_templates_to_lock
5534: ,fnd_api.g_true
5535: ,fnd_api.g_true
5536: ,cz_pb_mgr.v_server_id
5537: ,cz_pb_mgr.v_publication_id
5538: ,l_locked_templates
5539: ,l_return_status
5542: );
5543: ELSE
5544: cz_security_pvt.lock_template(1.0
5545: ,l_templates_to_lock
5546: ,fnd_api.g_true
5547: ,fnd_api.g_true
5548: ,l_locked_templates
5549: ,l_return_status
5550: ,l_msg_count
5543: ELSE
5544: cz_security_pvt.lock_template(1.0
5545: ,l_templates_to_lock
5546: ,fnd_api.g_true
5547: ,fnd_api.g_true
5548: ,l_locked_templates
5549: ,l_return_status
5550: ,l_msg_count
5551: ,l_msg_data
5551: ,l_msg_data
5552: );
5553: END IF;
5554:
5555: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5556: THEN
5557: RAISE failed_to_lock_template;
5558: END IF;
5559:
5656: -- END IF;
5657:
5658: -- bug #10417318
5659: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5660: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5661: ELSE
5662: 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);
5663: END IF;
5664:
5658: -- bug #10417318
5659: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5660: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5661: ELSE
5662: 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);
5663: END IF;
5664:
5665: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5666: THEN
5661: ELSE
5662: 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);
5663: END IF;
5664:
5665: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5666: THEN
5667: RAISE failed_to_unlock_template;
5668: END IF;
5669: EXCEPTION
5673: l_msg_index := 1;
5674:
5675: WHILE l_msg_count > 0
5676: LOOP
5677: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
5678: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
5679: l_msg_index := l_msg_index + 1;
5680: l_msg_count := l_msg_count - 1;
5681: END LOOP;
5681: END LOOP;
5682:
5683: -- bug #10417318
5684: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5685: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5686: ELSE
5687: 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);
5688: END IF;
5689:
5683: -- bug #10417318
5684: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5685: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5686: ELSE
5687: 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);
5688: END IF;
5689:
5690: raise_application_error('-20020', 'FAILED_TO_LOCK_TEMPLATE');
5691: WHEN failed_to_unlock_template
5694: l_msg_index := 1;
5695:
5696: WHILE l_msg_count > 0
5697: LOOP
5698: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
5699: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.CZINSERTTEMPLATES', SQLCODE);
5700: l_msg_index := l_msg_index + 1;
5701: l_msg_count := l_msg_count - 1;
5702: END LOOP;
5705: WHEN OTHERS
5706: THEN
5707: -- bug #10417318
5708: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5709: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5710: ELSE
5711: 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);
5712: END IF;
5713:
5707: -- bug #10417318
5708: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
5709: cz_security_pvt.unlock_pub_template(1.0, l_locked_templates, fnd_api.g_true, fnd_api.g_true, cz_pb_mgr.v_publication_id, l_return_status, l_msg_count, l_msg_data);
5710: ELSE
5711: 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);
5712: END IF;
5713:
5714: RAISE;
5715: END insert_ui_templates;
6626: l_child_ui_tbl cz_pb_mgr.t_ref;
6627: rec_count NUMBER := 0;
6628: plsql_table_list cz_pb_mgr.col_plsql_table_list;
6629: BEGIN
6630: x_return_status := FND_API.G_RET_STS_SUCCESS;
6631: cz_pb_mgr.v_status_code := 'OK';
6632:
6633: IF (p_ui_def_id IS NULL)
6634: THEN
6724: END IF;
6725: EXCEPTION
6726: WHEN ui_def_id_is_null
6727: THEN
6728: x_return_status := FND_API.G_RET_STS_ERROR;
6729: x_msg_data := cz_utils.get_text('UI_DEF_ID_IS_NULL');
6730: x_msg_count := 1;
6731: WHEN ui_def_id_not_found
6732: THEN
6729: x_msg_data := cz_utils.get_text('UI_DEF_ID_IS_NULL');
6730: x_msg_count := 1;
6731: WHEN ui_def_id_not_found
6732: THEN
6733: x_return_status := FND_API.G_RET_STS_ERROR;
6734: x_msg_data := cz_utils.get_text('UI_DEF_ID_NOT_FOUND', 'UIDEFID', p_ui_def_id);
6735: x_msg_count := 1;
6736: WHEN not_oa_style_ui
6737: THEN
6734: x_msg_data := cz_utils.get_text('UI_DEF_ID_NOT_FOUND', 'UIDEFID', p_ui_def_id);
6735: x_msg_count := 1;
6736: WHEN not_oa_style_ui
6737: THEN
6738: x_return_status := FND_API.G_RET_STS_ERROR;
6739: x_msg_data := cz_utils.get_text('NOT_OA_STYLE_UI', 'UIDEFID', p_ui_def_id);
6740: x_msg_count := 1;
6741: WHEN OTHERS
6742: THEN
6739: x_msg_data := cz_utils.get_text('NOT_OA_STYLE_UI', 'UIDEFID', p_ui_def_id);
6740: x_msg_count := 1;
6741: WHEN OTHERS
6742: THEN
6743: x_return_status := FND_API.G_RET_STS_ERROR;
6744: x_msg_data := cz_utils.get_text('FATAL_ERROR', 'UIDEFID', p_ui_def_id, 'ERROR', SQLERRM);
6745: x_msg_count := 1;
6746: END export_single_oa_ui;
6747:
12504: AS
12505:
12506: StIdx INTEGER:=1;
12507: EndIdx INTEGER:= CZ_PB_MGR.record_commit_size;
12508: r_return_status CHAR(1):= FND_API.G_RET_STS_SUCCESS;
12509: r_msg_string VARCHAR2(1000):='';
12510: remote_exception EXCEPTION;
12511:
12512: BEGIN
12634: WHEN OTHERS THEN
12635: NULL;
12636: END;
12637:
12638: IF (r_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
12639: CZ_PB_MGR.v_status_code := CZ_PB_MGR.PUBLICATION_ERROR;
12640: CZ_PB_MGR.v_sql_err_msg := r_msg_string;
12641: RAISE remote_exception;
12642: END IF;
12664: InsCharData IN CZ_PB_MGR.propDataType,
12665: InsNumData IN CZ_PB_MGR.t_ref)
12666: AS
12667:
12668: r_return_status CHAR(1):= FND_API.G_RET_STS_SUCCESS;
12669: r_msg_data VARCHAR2(1000) := '';
12670:
12671: BEGIN
12672:
12686: END IF;
12687:
12688: EXCEPTION
12689: WHEN OTHERS THEN
12690: r_return_status := FND_API.G_RET_STS_ERROR;
12691: r_msg_data := 'Error Executing Remote Bulk Insert - PS_PROP_VALS'||SQLERRM;
12692: DELETE FROM cz_db_logs WHERE caller = 'REMOTE_INSERT_PS_PROP_VALS';
12693:
12694: INSERT INTO cz_db_logs(logtime, caller, message, statuscode)
18431: EXECUTE IMMEDIATE 'BEGIN cz_diagnostics_pvt.verify_structure' || cz_pb_mgr.v_db_link || '(1.0, :1, ''0'', :2, :3, :4, :5); END;'
18432: 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;
18433: END IF;
18434:
18435: IF(l_return_status = FND_API.G_RET_STS_ERROR)THEN
18436:
18437: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18438: cz_pb_mgr.v_err_message := l_msg_data;
18439: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_diagnostics_pvt', -1);
18669: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');
18670: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.XFRINFO', SQLCODE);
18671: END;
18672:
18673: 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);
18674:
18675: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
18676: THEN
18677: l_msg_index := 1;
18671: END;
18672:
18673: 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);
18674:
18675: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
18676: THEN
18677: l_msg_index := 1;
18678:
18679: WHILE l_msg_count > 0
18677: l_msg_index := 1;
18678:
18679: WHILE l_msg_count > 0
18680: LOOP
18681: l_msg_data := fnd_msg_pub.get(l_msg_index, fnd_api.g_false);
18682: cz_pb_mgr.error_msg_populate(l_msg_data, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
18683: l_msg_index := l_msg_index + 1;
18684: l_msg_count := l_msg_count - 1;
18685: END LOOP;
19263: DELETE FROM cz_pb_model_exports
19264: WHERE publication_id = v_pub_id;
19265: END IF;
19266:
19267: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19268:
19269: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
19270: THEN
19271: l_msg_index := 1;
19265: END IF;
19266:
19267: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19268:
19269: IF (l_lock_status <> FND_API.G_RET_STS_SUCCESS)
19270: THEN
19271: l_msg_index := 1;
19272:
19273: WHILE l_msg_count > 0
19271: l_msg_index := 1;
19272:
19273: WHILE l_msg_count > 0
19274: LOOP
19275: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
19276: l_msg_index := l_msg_index + 1;
19277: l_msg_count := l_msg_count - 1;
19278: END LOOP;
19279: END IF;
19283: WHEN failed_to_lock_model
19284: THEN
19285: x_run_id := cz_pb_mgr.v_pb_run_id;
19286: x_status := PUBLICATION_ERROR;
19287: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19288: log_pb_trace;
19289: WHEN ui_not_uptodate THEN
19290: x_run_id := cz_pb_mgr.v_pb_run_id;
19291: x_status := PUBLICATION_ERROR;
19288: log_pb_trace;
19289: WHEN ui_not_uptodate THEN
19290: x_run_id := cz_pb_mgr.v_pb_run_id;
19291: x_status := PUBLICATION_ERROR;
19292: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19293: log_pb_trace;
19294: WHEN OTHERS
19295: THEN
19296: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19292: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19293: log_pb_trace;
19294: WHEN OTHERS
19295: THEN
19296: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
19297: cz_pb_mgr.v_err_message := 'Fatal error during deep model copy of model: ' || cz_pb_mgr.v_root_model_id;
19298: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
19299: END;
19300:
19310: ,p_copy_root IN NUMBER
19311: ,x_return_status OUT NOCOPY VARCHAR2
19312: ,x_msg_count OUT NOCOPY NUMBER
19313: ,x_msg_data OUT NOCOPY VARCHAR2
19314: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE
19315: )
19316: IS
19317: TYPE message_tbl_type IS TABLE OF VARCHAR2(2000)
19318: INDEX BY BINARY_INTEGER;
19324: l_instr NUMBER := 0;
19325: BEGIN
19326:
19327: --initialize the message stack depending on the input parameter
19328: IF (p_init_msg_list = FND_API.G_TRUE) THEN
19329: fnd_msg_pub.initialize;
19330: END IF;
19331:
19332: x_return_status := FND_API.G_RET_STS_SUCCESS;
19328: IF (p_init_msg_list = FND_API.G_TRUE) THEN
19329: fnd_msg_pub.initialize;
19330: END IF;
19331:
19332: x_return_status := FND_API.G_RET_STS_SUCCESS;
19333: x_msg_count := 0;
19334: x_msg_data := '';
19335: 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);
19336:
19335: 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);
19336:
19337: IF (l_status = PUBLICATION_ERROR)
19338: THEN
19339: x_return_status := FND_API.G_RET_STS_ERROR;
19340: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
19341: END IF;
19342: END deep_model_copy;
19343:
20213: -- bug #10417318
20214: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20215: cz_security_pvt.lock_pub_model(1.0
20216: ,cz_pb_mgr.v_root_model_id
20217: ,fnd_api.g_true
20218: ,fnd_api.g_true
20219: ,fnd_api.g_false
20220: ,cz_pb_mgr.v_server_id
20221: ,cz_pb_mgr.v_publication_id
20214: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20215: cz_security_pvt.lock_pub_model(1.0
20216: ,cz_pb_mgr.v_root_model_id
20217: ,fnd_api.g_true
20218: ,fnd_api.g_true
20219: ,fnd_api.g_false
20220: ,cz_pb_mgr.v_server_id
20221: ,cz_pb_mgr.v_publication_id
20222: ,l_locked_models
20215: cz_security_pvt.lock_pub_model(1.0
20216: ,cz_pb_mgr.v_root_model_id
20217: ,fnd_api.g_true
20218: ,fnd_api.g_true
20219: ,fnd_api.g_false
20220: ,cz_pb_mgr.v_server_id
20221: ,cz_pb_mgr.v_publication_id
20222: ,l_locked_models
20223: ,l_lock_status
20226: );
20227: ELSE
20228: cz_security_pvt.lock_model(1.0
20229: ,cz_pb_mgr.v_root_model_id
20230: ,fnd_api.g_true
20231: ,fnd_api.g_true
20232: ,l_locked_models
20233: ,l_lock_status
20234: ,l_msg_count
20227: ELSE
20228: cz_security_pvt.lock_model(1.0
20229: ,cz_pb_mgr.v_root_model_id
20230: ,fnd_api.g_true
20231: ,fnd_api.g_true
20232: ,l_locked_models
20233: ,l_lock_status
20234: ,l_msg_count
20235: ,l_msg_data
20241:
20242: WHILE l_msg_count > 0
20243: LOOP
20244: cz_pb_mgr.v_err_message :=
20245: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', fnd_msg_pub.get(l_msg_index, fnd_api.g_false));
20246: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOCKMODEL', SQLCODE);
20247: l_msg_index := l_msg_index + 1;
20248: l_msg_count := l_msg_count - 1;
20249: END LOOP;
20758: l_msg_index := 0;
20759:
20760: -- bug #10417318
20761: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20762: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, cz_pb_mgr.v_publication_id, l_lock_status, l_msg_count, l_msg_data );
20763: ELSE
20764: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20765: END IF;
20766:
20760: -- bug #10417318
20761: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20762: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, cz_pb_mgr.v_publication_id, l_lock_status, l_msg_count, l_msg_data );
20763: ELSE
20764: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20765: END IF;
20766:
20767: IF (l_lock_status <> 'S') THEN
20768: l_msg_index := 1;
20768: l_msg_index := 1;
20769:
20770: WHILE l_msg_count > 0
20771: LOOP
20772: cz_pb_mgr.error_msg_populate(fnd_msg_pub.get(l_msg_index, fnd_api.g_false), 'cz_pb_mgr.LOCKMODEL', SQLCODE);
20773: l_msg_index := l_msg_index + 1;
20774: l_msg_count := l_msg_count - 1;
20775: END LOOP;
20776: END IF;
20829: update_publication_status(publicationid, PUBLICATION_ERROR, empty_string);
20830: update_pup_status(publicationid);
20831: -- bug #10417318
20832: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20833: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, publicationid, l_lock_status, l_msg_count, l_msg_data );
20834: ELSE
20835: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20836: END IF;
20837: log_pb_trace;
20831: -- bug #10417318
20832: IF (cz_pb_mgr.v_session_parameter = pub_model AND vMultiServerPub = 'YES') THEN
20833: cz_security_pvt.unlock_pub_model(1.0, fnd_api.g_true, l_locked_models, fnd_api.g_false, publicationid, l_lock_status, l_msg_count, l_msg_data );
20834: ELSE
20835: cz_security_pvt.unlock_model(1.0, fnd_api.g_true, l_locked_models, l_lock_status, l_msg_count, l_msg_data);
20836: END IF;
20837: log_pb_trace;
20838: delete_session_parameters;
20839: WHEN not_global_template THEN
20992: cannot_del_pup EXCEPTION;
20993: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
20994: BEGIN
20995: fnd_msg_pub.initialize;
20996: x_return_status := FND_API.G_RET_STS_SUCCESS;
20997: x_msg_count := 0;
20998: x_msg_data := '';
20999: fnd_msg_pub.initialize;
21000:
21142: END IF;
21143: EXCEPTION
21144: WHEN no_link_name
21145: THEN
21146: x_return_status := FND_API.G_RET_STS_ERROR;
21147: fnd_message.set_name('CZ', 'CZ_NO_LINK_NAME');
21148: fnd_msg_pub.ADD;
21149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21150: WHEN cannot_del_pup
21148: fnd_msg_pub.ADD;
21149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21150: WHEN cannot_del_pup
21151: THEN
21152: x_return_status := FND_API.G_RET_STS_ERROR;
21153: fnd_message.set_name('CZ', 'CZ_PB_CANNOT_DELETE_PUP');
21154: fnd_message.set_token('PUBID', publicationid);
21155: fnd_msg_pub.ADD;
21156: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21155: fnd_msg_pub.ADD;
21156: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21157: WHEN invalid_object_type
21158: THEN
21159: x_return_status := FND_API.G_RET_STS_ERROR;
21160: fnd_message.set_name('CZ', 'CZ_INVALID_PUB_TYPE');
21161: fnd_msg_pub.ADD;
21162: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21163: WHEN template_in_use
21162: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21163: WHEN template_in_use
21164: THEN
21165: x_msg_data := cz_utils.get_text('CZ_TEMPLATE_IN_USE');
21166: x_return_status := FND_API.G_RET_STS_ERROR;
21167: fnd_message.set_name('CZ', 'CZ_TEMPLATE_IN_USE');
21168: fnd_msg_pub.ADD;
21169: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21170: WHEN OTHERS
21168: fnd_msg_pub.ADD;
21169: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21170: WHEN OTHERS
21171: THEN
21172: x_return_status := FND_API.G_RET_STS_ERROR;
21173: x_msg_data := SQLERRM;
21174: END delete_publication;
21175:
21176: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21189: v_export_status cz_model_publications.export_status%TYPE;
21190: cannot_disable_template EXCEPTION;
21191: cannot_disable_publication EXCEPTION;
21192: BEGIN
21193: x_return_status := FND_API.G_RET_STS_SUCCESS;
21194: fnd_msg_pub.initialize;
21195: --execute the procedure that obsoletes the records
21196: --if the target has been converted into a development
21197: --instance
21196: --if the target has been converted into a development
21197: --instance
21198: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21199:
21200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21201: THEN
21202: RAISE pub_maybe_obsoleted;
21203: END IF;
21204:
21257: EXCEPTION
21258: WHEN cannot_disable_publication
21259: THEN
21260: ----x_msg_data := CZ_UTILS.GET_TEXT('CZ_CANT_DISABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationId);
21261: x_return_status := FND_API.G_RET_STS_ERROR;
21262: fnd_message.set_name('CZ', 'CZ_CANT_DISABLE_PUB');
21263: fnd_message.set_token('STATUS', v_export_status);
21264: fnd_message.set_token('PUBID', publicationid);
21265: fnd_msg_pub.ADD;
21265: fnd_msg_pub.ADD;
21266: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21267: WHEN pub_maybe_obsoleted
21268: THEN
21269: x_return_status := FND_API.G_RET_STS_ERROR;
21270: WHEN cannot_disable_template
21271: THEN
21272: x_msg_data := cz_utils.get_text('CZ_CANT_DISABLE_TEMPL', 'PUBID', publicationid);
21273: x_return_status := FND_API.G_RET_STS_ERROR;
21269: x_return_status := FND_API.G_RET_STS_ERROR;
21270: WHEN cannot_disable_template
21271: THEN
21272: x_msg_data := cz_utils.get_text('CZ_CANT_DISABLE_TEMPL', 'PUBID', publicationid);
21273: x_return_status := FND_API.G_RET_STS_ERROR;
21274: WHEN OTHERS
21275: THEN
21276: x_return_status := FND_API.G_RET_STS_ERROR;
21277: x_msg_data := SQLERRM;
21272: x_msg_data := cz_utils.get_text('CZ_CANT_DISABLE_TEMPL', 'PUBID', publicationid);
21273: x_return_status := FND_API.G_RET_STS_ERROR;
21274: WHEN OTHERS
21275: THEN
21276: x_return_status := FND_API.G_RET_STS_ERROR;
21277: x_msg_data := SQLERRM;
21278: END disable_publication;
21279:
21280: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21561: status_str VARCHAR2(200) := '0';
21562: no_pub_found EXCEPTION;
21563: l_publication_id NUMBER;
21564: BEGIN
21565: x_return_status := FND_API.G_RET_STS_SUCCESS;
21566: fnd_msg_pub.initialize;
21567: v_application_id_tbl.DELETE;
21568: v_usage_id_tbl.DELETE;
21569: v_language_id_tbl.DELETE;
21571: --if the target has been converted into a development
21572: --instance
21573: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21574:
21575: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21576: THEN
21577: RAISE pub_maybe_obsoleted;
21578: END IF;
21579:
21595: AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR', model_publication_obselete);
21596:
21597: IF (v_count = 0)
21598: THEN
21599: x_return_status := FND_API.G_RET_STS_ERROR;
21600: x_msg_count := 1;
21601: x_msg_data := 'PUBLICATION HAS STATUS /PRC/PUP/' || model_publication_obselete;
21602: ELSE
21603: get_edit_info(publicationid, v_product_key, v_publication_mode, v_server_id, v_export_status, v_source_target_flag, v_remote_publication_id);
21633: );
21634:
21635: IF (status_str = '-1')
21636: THEN
21637: x_return_status := FND_API.G_RET_STS_ERROR;
21638: x_msg_count := 1;
21639: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21640: ELSE
21641: COMMIT;
21643: END IF;
21644: EXCEPTION
21645: WHEN pub_maybe_obsoleted
21646: THEN
21647: x_return_status := FND_API.G_RET_STS_SUCCESS;
21648: WHEN no_pub_found
21649: THEN
21650: x_return_status := FND_API.G_RET_STS_SUCCESS;
21651: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21646: THEN
21647: x_return_status := FND_API.G_RET_STS_SUCCESS;
21648: WHEN no_pub_found
21649: THEN
21650: x_return_status := FND_API.G_RET_STS_SUCCESS;
21651: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21652: WHEN OTHERS
21653: THEN
21654: x_return_status := FND_API.G_RET_STS_ERROR;
21650: x_return_status := FND_API.G_RET_STS_SUCCESS;
21651: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21652: WHEN OTHERS
21653: THEN
21654: x_return_status := FND_API.G_RET_STS_ERROR;
21655: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21656: END edit_publication;
21657:
21658: --------------------------------------------------------
21687: status_str VARCHAR2(200) := '0';
21688: no_pub_found EXCEPTION;
21689: l_publication_id NUMBER;
21690: BEGIN
21691: x_return_status := FND_API.G_RET_STS_SUCCESS;
21692: fnd_msg_pub.initialize;
21693: --execute the procedure that obsoletes the records
21694: --if the target has been converted into a development
21695: --instance
21694: --if the target has been converted into a development
21695: --instance
21696: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21697:
21698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21699: THEN
21700: RAISE pub_maybe_obsoleted;
21701: END IF;
21702:
21717: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
21718:
21719: IF (v_count = 0)
21720: THEN
21721: x_return_status := FND_API.G_RET_STS_ERROR;
21722: x_msg_count := 1;
21723: x_msg_data := 'PUBLICATION HAS STATUS /PRC/PUP';
21724: ELSE
21725: get_edit_info(publicationid, v_product_key, v_publication_mode, v_server_id, v_export_status, v_source_target_flag, v_remote_publication_id);
21752: );
21753:
21754: IF (status_str = '-1')
21755: THEN
21756: x_return_status := FND_API.G_RET_STS_ERROR;
21757: x_msg_count := 1;
21758: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21759: END IF;
21760: END IF;
21760: END IF;
21761: EXCEPTION
21762: WHEN pub_maybe_obsoleted
21763: THEN
21764: x_return_status := FND_API.G_RET_STS_SUCCESS;
21765: WHEN no_pub_found
21766: THEN
21767: x_return_status := FND_API.G_RET_STS_SUCCESS;
21768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21763: THEN
21764: x_return_status := FND_API.G_RET_STS_SUCCESS;
21765: WHEN no_pub_found
21766: THEN
21767: x_return_status := FND_API.G_RET_STS_SUCCESS;
21768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21769: WHEN OTHERS
21770: THEN
21771: x_return_status := FND_API.G_RET_STS_ERROR;
21767: x_return_status := FND_API.G_RET_STS_SUCCESS;
21768: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
21769: WHEN OTHERS
21770: THEN
21771: x_return_status := FND_API.G_RET_STS_ERROR;
21772: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21773: END edit_publication;
21774:
21775: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21805: status_str VARCHAR2(200) := '0';
21806: no_pub_found EXCEPTION;
21807: l_publication_id NUMBER;
21808: BEGIN
21809: x_return_status := FND_API.G_RET_STS_SUCCESS;
21810: fnd_msg_pub.initialize;
21811: v_application_id_tbl.DELETE;
21812: v_usage_id_tbl.DELETE;
21813: v_language_id_tbl.DELETE;
21815: --if the target has been converted into a development
21816: --instance
21817: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
21818:
21819: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
21820: THEN
21821: RAISE pub_maybe_obsoleted;
21822: END IF;
21823:
21838: WHERE cz_model_publications.publication_id = publicationid AND cz_model_publications.export_status NOT IN('PRC', 'PUP', 'ERR');
21839:
21840: IF (v_count = 0)
21841: THEN
21842: x_return_status := FND_API.G_RET_STS_ERROR;
21843: x_msg_count := 1;
21844: x_msg_data := 'PUBLICATION HAS STATUS /PRC/PUP';
21845: ELSE
21846: get_edit_info(publicationid, v_product_key, v_publication_mode, v_server_id, v_export_status, v_source_target_flag, v_remote_publication_id);
21879: );
21880:
21881: IF (status_str = '-1')
21882: THEN
21883: x_return_status := FND_API.G_RET_STS_ERROR;
21884: x_msg_count := 1;
21885: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21886: END IF;
21887: END IF;
21887: END IF;
21888: EXCEPTION
21889: WHEN pub_maybe_obsoleted
21890: THEN
21891: x_return_status := FND_API.G_RET_STS_SUCCESS;
21892: WHEN no_pub_found
21893: THEN
21894: x_return_status := FND_API.G_RET_STS_SUCCESS;
21895: WHEN OTHERS
21890: THEN
21891: x_return_status := FND_API.G_RET_STS_SUCCESS;
21892: WHEN no_pub_found
21893: THEN
21894: x_return_status := FND_API.G_RET_STS_SUCCESS;
21895: WHEN OTHERS
21896: THEN
21897: x_return_status := FND_API.G_RET_STS_ERROR;
21898: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21893: THEN
21894: x_return_status := FND_API.G_RET_STS_SUCCESS;
21895: WHEN OTHERS
21896: THEN
21897: x_return_status := FND_API.G_RET_STS_ERROR;
21898: x_msg_data := cz_utils.get_text('CZ_PB_EDIT_FAILURE_DETAILS', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21899: END edit_tgt_pub;
21900:
21901: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
22350: model_not_upto_date EXCEPTION;
22351: pub_overlap EXCEPTION;
22352: ui_def_id_is_deleted EXCEPTION;
22353: BEGIN
22354: x_return_status := FND_API.G_RET_STS_SUCCESS;
22355: fnd_msg_pub.initialize;
22356: --execute the procedure that obsoletes the records
22357: --if the target has been converted into a development
22358: --instance
22358: --instance
22359: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
22360:
22361: ----check status
22362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
22363: THEN
22364: RAISE pub_maybe_obsoleted;
22365: END IF;
22366:
22459: EXCEPTION
22460: WHEN pub_overlap
22461: THEN
22462: ROLLBACK;
22463: x_return_status := FND_API.G_RET_STS_ERROR;
22464: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22465: fnd_message.set_token('PUBID', p_publication_id);
22466: fnd_message.set_token('PUBSTR', v_publicationidstring);
22467: fnd_msg_pub.ADD;
22467: fnd_msg_pub.ADD;
22468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22469: WHEN ui_def_id_is_deleted
22470: THEN
22471: x_return_status := FND_API.G_RET_STS_ERROR;
22472:
22473: IF (l_ui_name IS NOT NULL)
22474: THEN
22475: fnd_message.set_name('CZ', 'CZ_UI_DEF_DELETED');
22484: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22485: WHEN model_not_upto_date
22486: THEN
22487: ROLLBACK;
22488: x_return_status := FND_API.G_RET_STS_ERROR;
22489: fnd_message.set_name('CZ', 'CZ_REPUB_MODEL_NOT_UP_TO_DATE');
22490: fnd_message.set_token('PUBID', p_publication_id);
22491: fnd_message.set_token('MODELUPTODATE', v_upto_date_status);
22492: fnd_msg_pub.ADD;
22493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22494: WHEN get_params_exception
22495: THEN
22496: ROLLBACK;
22497: x_return_status := FND_API.G_RET_STS_ERROR;
22498: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
22499: fnd_message.set_token('PUBID', p_publication_id);
22500: fnd_msg_pub.ADD;
22501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22502: WHEN expstatus_exception
22503: THEN
22504: ROLLBACK;
22505: x_return_status := FND_API.G_RET_STS_ERROR;
22506: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERR');
22507: fnd_message.set_token('PUBID', p_publication_id);
22508: fnd_message.set_token('EXPORT STATUS', v_source_pb_record.export_status);
22509: fnd_msg_pub.ADD;
22510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22511: cz_pb_mgr.v_republish_model := no_mode;
22512: WHEN pub_maybe_obsoleted
22513: THEN
22514: x_return_status := fnd_api.g_ret_sts_unexp_error;
22515: WHEN OTHERS
22516: THEN
22517: ROLLBACK;
22518: x_return_status := fnd_api.g_ret_sts_unexp_error;
22514: x_return_status := fnd_api.g_ret_sts_unexp_error;
22515: WHEN OTHERS
22516: THEN
22517: ROLLBACK;
22518: x_return_status := fnd_api.g_ret_sts_unexp_error;
22519: fnd_message.set_name('CZ', 'CZ_PB_CREATE_REQUEST_ERROR');
22520: fnd_message.set_token('PUBID', p_publication_id);
22521: fnd_message.set_token('SQLERRM', SQLERRM);
22522: fnd_msg_pub.ADD;
22850: get_params_exception EXCEPTION;
22851: pub_overlap EXCEPTION;
22852: cannot_enable_publication EXCEPTION;
22853: BEGIN
22854: x_return_status := FND_API.G_RET_STS_SUCCESS;
22855: fnd_msg_pub.initialize;
22856: --execute the procedure that obsoletes the records
22857: --if the target has been converted into a development
22858: --instance
22857: --if the target has been converted into a development
22858: --instance
22859: cz_model_migration_pvt.obsolete_nonpublishable('T', x_return_status, x_msg_count, x_msg_data);
22860:
22861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
22862: THEN
22863: RAISE pub_maybe_obsoleted;
22864: END IF;
22865:
22962: THEN
22963: NULL;
22964: WHEN cannot_enable_publication
22965: THEN
22966: x_return_status := FND_API.G_RET_STS_ERROR;
22967: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_PUB', 'STATUS', v_export_status, 'PUBID', publicationid);
22968: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_PUB');
22969: fnd_message.set_token('STATUS', v_export_status);
22970: fnd_message.set_token('PUBID', publicationid);
22972: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22973: WHEN cannot_enable_template
22974: THEN
22975: x_msg_data := cz_utils.get_text('CZ_CANT_ENABLE_TEMPL', 'PUBID', publicationid);
22976: x_return_status := FND_API.G_RET_STS_ERROR;
22977: fnd_message.set_name('CZ', 'CZ_CANT_ENABLE_TEMPL');
22978: fnd_message.set_token('PUBID', publicationid);
22979: fnd_msg_pub.ADD;
22980: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22980: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22981: WHEN get_params_exception
22982: THEN
22983: ROLLBACK;
22984: x_return_status := FND_API.G_RET_STS_ERROR;
22985: fnd_message.set_name('CZ', 'CZ_PB_GET_PARAMS_ERROR');
22986: fnd_message.set_token('PUBID', publicationid);
22987: fnd_msg_pub.ADD;
22988: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22988: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22989: WHEN pub_overlap
22990: THEN
22991: ROLLBACK;
22992: x_return_status := FND_API.G_RET_STS_ERROR;
22993: fnd_message.set_name('CZ', 'CZ_PB_OVERLAP');
22994: fnd_message.set_token('PUBID', publicationid);
22995: fnd_message.set_token('PUBSTR', l_publicationidstring);
22996: fnd_msg_pub.ADD;
22996: fnd_msg_pub.ADD;
22997: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
22998: WHEN pub_maybe_obsoleted
22999: THEN
23000: x_return_status := FND_API.G_RET_STS_ERROR;
23001: WHEN OTHERS
23002: THEN
23003: x_return_status := FND_API.G_RET_STS_ERROR;
23004: x_msg_data := SQLERRM;
22999: THEN
23000: x_return_status := FND_API.G_RET_STS_ERROR;
23001: WHEN OTHERS
23002: THEN
23003: x_return_status := FND_API.G_RET_STS_ERROR;
23004: x_msg_data := SQLERRM;
23005: END enable_publication;
23006:
23007: ---------------------------------
23112: no_ui_id EXCEPTION;
23113: product_key_is_null EXCEPTION;
23114: PUB_SOURCE_FLAG CONSTANT VARCHAR2(1) := 'S';
23115: BEGIN
23116: x_return_status := FND_API.G_RET_STS_SUCCESS;
23117: fnd_msg_pub.initialize;
23118:
23119: -----check if model id passed in is not null
23120: -----if not null then check if the model exists and is
23330: x_publication_id := v_new_publication_id;
23331: EXCEPTION
23332: WHEN product_key_is_null
23333: THEN
23334: x_return_status := FND_API.G_RET_STS_ERROR;
23335: fnd_message.set_name('CZ', 'CZ_PRODUCT_KEY_IS_NULL');
23336: fnd_msg_pub.ADD;
23337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23338: WHEN no_model_id
23336: fnd_msg_pub.ADD;
23337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23338: WHEN no_model_id
23339: THEN
23340: x_return_status := FND_API.G_RET_STS_ERROR;
23341: fnd_message.set_name('CZ', 'cz_pb_mgr_MODEL_ID_NULL');
23342: fnd_msg_pub.ADD;
23343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23344: WHEN no_model_exists
23342: fnd_msg_pub.ADD;
23343: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23344: WHEN no_model_exists
23345: THEN
23346: x_return_status := FND_API.G_RET_STS_ERROR;
23347: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_MODEL_EXISTS');
23348: fnd_message.set_token('MODELID', p_model_id);
23349: fnd_msg_pub.ADD;
23350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23349: fnd_msg_pub.ADD;
23350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23351: WHEN no_ui_exists
23352: THEN
23353: x_return_status := FND_API.G_RET_STS_ERROR;
23354: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_UI_EXISTS');
23355: fnd_message.set_token('MODELID', p_model_id);
23356: fnd_msg_pub.ADD;
23357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23356: fnd_msg_pub.ADD;
23357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23358: WHEN invalid_pb_mode
23359: THEN
23360: x_return_status := FND_API.G_RET_STS_ERROR;
23361: fnd_message.set_name('CZ', 'cz_pb_mgr_IVALID_PB_MODE');
23362: fnd_message.set_token('PBMODE', l_publication_mode);
23363: fnd_msg_pub.ADD;
23364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23363: fnd_msg_pub.ADD;
23364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23365: WHEN no_appl_id
23366: THEN
23367: x_return_status := FND_API.G_RET_STS_ERROR;
23368: fnd_message.set_name('CZ', 'cz_pb_mgr_NO_APPL_ID');
23369: fnd_msg_pub.ADD;
23370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23371: WHEN pub_overlap
23369: fnd_msg_pub.ADD;
23370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23371: WHEN pub_overlap
23372: THEN
23373: x_return_status := FND_API.G_RET_STS_ERROR;
23374: fnd_message.set_name('CZ', 'PUB_OVERLAP');
23375: fnd_message.set_token('PUB_OVERLAP', v_publicationidstring);
23376: fnd_msg_pub.ADD;
23377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23376: fnd_msg_pub.ADD;
23377: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23378: WHEN model_not_upto_date
23379: THEN
23380: x_return_status := FND_API.G_RET_STS_ERROR;
23381: fnd_message.set_name('CZ', 'CZ_PB_MODEL_NOT_UPTO_DATE');
23382: fnd_message.set_token('UPTODATESTR', v_upto_date_status);
23383: fnd_msg_pub.ADD;
23384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23383: fnd_msg_pub.ADD;
23384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
23385: WHEN OTHERS
23386: THEN
23387: x_return_status := FND_API.G_RET_STS_ERROR;
23388: fnd_message.set_name('CZ', 'CZ_PB_CREATE_PB_REQUEST_ERR');
23389: fnd_message.set_token('ERROR', SQLERRM);
23390: fnd_msg_pub.ADD;
23391: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);