[Home] [Help]
611: END IF;
612: EXCEPTION
613: WHEN OTHERS
614: THEN
615: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);
616: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDLOCALTEXT', SQLCODE);
617: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
618: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
619: RAISE;
681: END;
682: END LOOP;
683: EXCEPTION
684: WHEN OTHERS THEN
685: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM',SQLERRM);
686: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.RESOLVEIDS',SQLCODE);
687: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
688: cz_pb_mgr.v_sql_err_msg := substr(SQLERRM,1,2000);
689: RAISE;
747: END IF;
748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM',SQLERRM);
752: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.RESOLVEIDS',SQLCODE);
753: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
754: cz_pb_mgr.v_sql_err_msg := substr(SQLERRM,1,2000);
755: END resolve_tmpl_ui_defs;
840: END IF;
841: EXCEPTION
842: WHEN OTHERS
843: THEN
844: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
845: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
846: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
847: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
848: END resolve_intl_texts;
972: WHEN OTHERS
973: THEN
974: ROLLBACK;
975: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
976: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', table_name, 'SQLERRM', SQLERRM);
977: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
978: cz_pb_mgr.v_status_code := cz_pb_mgr.PUBLICATION_ERROR;
979: RAISE;
980: END;
1018: END IF;
1019: EXCEPTION
1020: WHEN OTHERS
1021: THEN
1022: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
1023: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUB', SQLCODE);
1024: x_status := PUBLICATION_ERROR;
1025: RAISE;
1026: END get_new_publication_id;
1138: WHEN OTHERS
1139: THEN
1140: ROLLBACK;
1141: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
1142: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', table_name, 'SQLERRM', SQLERRM);
1143: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
1144: cz_pb_mgr.v_status_code := cz_pb_mgr.PUBLICATION_ERROR;
1145: RAISE;
1146: END;
1199: COMMIT;
1200: EXCEPTION
1201: WHEN OTHERS
1202: THEN
1203: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);
1204: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);
1205: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1206: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1207: RAISE;
1624: v_insertstring :=
1625: v_insertstring
1626: || ' EXCEPTION WHEN OTHERS THEN '
1627: || ' '
1628: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1629: || ' '
1630: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1631: || ' '
1632: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1746: v_insertstring :=
1747: v_insertstring
1748: || ' EXCEPTION WHEN OTHERS THEN'
1749: || ' '
1750: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1751: || ' '
1752: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1753: || ' '
1754: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1866: v_insertstring :=
1867: v_insertstring
1868: || ' EXCEPTION WHEN OTHERS THEN'
1869: || ' '
1870: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1871: || ' '
1872: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1873: || ' '
1874: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1984: v_insertstring :=
1985: v_insertstring
1986: || ' EXCEPTION WHEN OTHERS THEN '
1987: || ' '
1988: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1989: || ' '
1990: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1991: || ' '
1992: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2100: v_insertstring :=
2101: v_insertstring
2102: || ' EXCEPTION WHEN OTHERS THEN '
2103: || ' '
2104: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2105: || ' '
2106: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
2107: || ' '
2108: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2216: v_insertstring :=
2217: v_insertstring
2218: || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN NULL; WHEN OTHERS THEN'
2219: || ' '
2220: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2221: || ' '
2222: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
2223: || ' '
2224: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2334: v_insertstring :=
2335: v_insertstring
2336: || ' EXCEPTION WHEN OTHERS THEN '
2337: || ' '
2338: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2339: || ' '
2340: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
2341: || ' '
2342: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2401: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
2402: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2403: WHEN OTHERS
2404: THEN
2405: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);
2406: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2407: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
2408: END;
2409:
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
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050: x_msg_count := 1;
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
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: x_msg_count := 1;
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
3439: x_return_status := fnd_api.g_ret_sts_unexp_error;
3440: x_msg_count := 1;
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:
3444: ----------------------------------------------------
3445: PROCEDURE export_jrad_docs(
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
3497: x_return_status := fnd_api.g_ret_sts_unexp_error;
3498: x_msg_count := 1;
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:
3502: ------>>>>>>>>>>>>>>>>>>>>>>>>>>
3503: PROCEDURE export_template_jrad_docs(
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:
3545: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>
3546: PROCEDURE export_template_jrad_docs(
3814: WHEN OTHERS
3815: THEN
3816: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';
3817:
3818: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_JRAD_DOC_ERR', 'JRADDOC', p_old_document_name, 'SQLERRM', SQLERRM);
3819: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTOJRADREPOS', SQLCODE);
3820: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3821:
3822: RAISE;
3909: THEN
3910: NULL;
3911: WHEN OTHERS
3912: THEN
3913: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_pages', 'SQLERRM', SQLERRM);
3914: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGES', SQLCODE);
3915: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3916: RAISE;
3917: END bulk_collect_ui_pages;
4036: THEN
4037: NULL;
4038: WHEN OTHERS
4039: THEN
4040: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4041: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGESETS', SQLCODE);
4042: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4043: RAISE;
4044: END bulk_collect_page_sets;
4079: END IF;
4080: EXCEPTION
4081: WHEN OTHERS
4082: THEN
4083: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4084: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGESETS', SQLCODE);
4085: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4086: RAISE;
4087: END insert_into_ui_page_sets;
4163: THEN
4164: NULL;
4165: WHEN OTHERS
4166: THEN
4167: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4168: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGEREFS', SQLCODE);
4169: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4170: RAISE;
4171: END bulk_collect_page_refs;
4233: END IF;
4234: EXCEPTION
4235: WHEN OTHERS
4236: THEN
4237: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4238: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGEREFS', SQLCODE);
4239: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4240: RAISE;
4241: END insert_into_ui_page_refs;
4291: THEN
4292: NULL;
4293: WHEN OTHERS
4294: THEN
4295: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
4296: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIREFS', SQLCODE);
4297: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4298: RAISE;
4299: END bulk_collect_ui_refs;
4347: COMMIT;
4348: EXCEPTION
4349: WHEN OTHERS
4350: THEN
4351: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
4352: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIREFS', SQLCODE);
4353: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4354: RAISE;
4355: END;
4427: END IF;
4428: EXCEPTION
4429: WHEN OTHERS
4430: THEN
4431: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_ps_maps', 'SQLERRM', SQLERRM);
4432: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPSMAPS', SQLCODE);
4433: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4434: RAISE;
4435: END bulk_collect_ui_ps_maps;
4497: END IF;
4498: EXCEPTION
4499: WHEN OTHERS
4500: THEN
4501: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_elements', 'SQLERRM', SQLERRM);
4502: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPSMAPS', SQLCODE);
4503: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4504: RAISE;
4505: END insert_ui_ps_maps;
4572: )
4573: IS
4574: l_inst_str VARCHAR2(2000);
4575: l_uit_date DATE;
4576: l_applicable_from DATE := cz_utils.epoch_begin;
4577: l_applicable_until DATE := cz_utils.epoch_end;
4578: l_status NUMBER := 0;
4579: l_ref_cursor ref_cursor;
4580: l_src_pb_id cz_model_publications.publication_id%TYPE;
4573: IS
4574: l_inst_str VARCHAR2(2000);
4575: l_uit_date DATE;
4576: l_applicable_from DATE := cz_utils.epoch_begin;
4577: l_applicable_until DATE := cz_utils.epoch_end;
4578: l_status NUMBER := 0;
4579: l_ref_cursor ref_cursor;
4580: l_src_pb_id cz_model_publications.publication_id%TYPE;
4581: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
4678: EXCEPTION
4679: WHEN OTHERS
4680: THEN
4681: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4682: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
4683: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
4684: RAISE;
4685: END create_uit_publication;
4686:
5034: THEN
5035: NULL;
5036: WHEN OTHERS
5037: THEN
5038: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_cont_templates', 'SQLERRM', SQLERRM);
5039: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UICONTTEMPLATES', SQLCODE);
5040: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5041: RAISE;
5042: END bulk_collect_cont_type_templs;
5111: THEN
5112: NULL;
5113: WHEN OTHERS
5114: THEN
5115: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
5116: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
5117: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5118: RAISE;
5119: END bulk_collect_ui_actions;
5165: THEN
5166: NULL;
5167: WHEN OTHERS
5168: THEN
5169: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_images', 'SQLERRM', SQLERRM);
5170: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIIMAGES', SQLCODE);
5171: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5172: RAISE;
5173: END bulk_collect_ui_images;
5844: COMMIT;
5845: EXCEPTION
5846: WHEN OTHERS
5847: THEN
5848: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXPORT_OA_UI_ERR', 'SQLERRM', SQLERRM);
5849: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_EXPORTOAUI', SQLCODE);
5850: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5851: RAISE;
5852: END export_oa_uis;
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
5976: x_return_status := FND_API.G_RET_STS_ERROR;
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
5981: x_return_status := FND_API.G_RET_STS_ERROR;
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
5986: x_return_status := FND_API.G_RET_STS_ERROR;
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:
5991: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6222: CLOSE db_compare_cur;
6223: EXCEPTION
6224: WHEN OTHERS
6225: THEN
6226: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SRC_TO_TRGT_LINK', 'SQLERRM', SQLERRM);
6227: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RETRIEVE_DB_LINK', SQLCODE);
6228: END;
6229:
6230: IF (((v_target_instance IS NULL) OR(v_target_host IS NULL) OR(v_target_port IS NULL)) AND(v_compare_record.server_local_id <> 0.0))
6228: END;
6229:
6230: IF (((v_target_instance IS NULL) OR(v_target_host IS NULL) OR(v_target_port IS NULL)) AND(v_compare_record.server_local_id <> 0.0))
6231: THEN
6232: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SRC_TO_TRGT_LINK', 'SQLERRM', SQLERRM);
6233: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RETRIEVE_DB_LINK', SQLCODE);
6234: cz_pb_mgr.v_status_code := 'ERR';
6235: END IF;
6236:
6283: END IF;
6284: COMMIT;
6285: EXCEPTION
6286: WHEN OTHERS THEN
6287: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
6288: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6289: END delete_from_table;
6290:
6291: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6322: EXECUTE IMMEDIATE v_DeleteString;
6323: END IF;
6324: EXCEPTION
6325: WHEN OTHERS THEN
6326: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
6327: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6328: END;
6329: COMMIT;
6330: END;
6360: EXECUTE IMMEDIATE v_DeleteString;
6361: END IF;
6362: EXCEPTION
6363: WHEN OTHERS THEN
6364: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
6365: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6366: END;
6367: COMMIT;
6368: END;
6404: EXECUTE IMMEDIATE v_DeleteString;
6405: END IF;
6406: EXCEPTION
6407: WHEN OTHERS THEN
6408: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
6409: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6410: END;
6411: COMMIT;
6412: END;
6530: WHERE publication_id = cz_pb_mgr.v_publication_id;
6531:
6532: COMMIT;
6533: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6534: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_FATAL_ERR', 'PubId', cz_pb_mgr.v_publication_id, 'SQLERRM', cz_pb_mgr.v_sql_err_msg);
6535: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:ROLLBACKDATA', SQLCODE);
6536: EXCEPTION
6537: WHEN OTHERS
6538: THEN
6536: EXCEPTION
6537: WHEN OTHERS
6538: THEN
6539: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6540: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_ROLLBACK_ERR', 'SQLERRM', SQLERRM);
6541: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ROLLBACK', SQLCODE);
6542: RAISE;
6543: END rollback_data;
6544:
6579: END IF;
6580: EXCEPTION
6581: WHEN OTHERS
6582: THEN
6583: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
6584: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDPBSTATUS', SQLCODE);
6585: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6586: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
6587: RAISE;
6684: RETURN v_count;
6685: EXCEPTION
6686: WHEN NO_DATA_FOUND
6687: THEN
6688: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_LINK_NAME');
6689: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.VALIDATE_SCHEMA', SQLCODE);
6690: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6691: RETURN v_count;
6692: WHEN OTHERS
6690: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6691: RETURN v_count;
6692: WHEN OTHERS
6693: THEN
6694: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SCHEMA_VALIDATION_ERR');
6695: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.VALIDATE_SCHEMA', SQLCODE);
6696: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6697: RETURN v_count;
6698: END validate_schema;
6716: cz_pb_mgr.v_err_message := 'No model usages found';
6717: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6718: WHEN OTHERS
6719: THEN
6720: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
6721: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6722: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6723: RAISE;
6724: END;
6764: cz_pb_mgr.v_err_message := 'No model usages translations found';
6765: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6766: WHEN OTHERS
6767: THEN
6768: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);
6769: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6770: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6771: RAISE;
6772: END;
6808: EXCEPTION
6809: WHEN OTHERS
6810: THEN
6811: ROLLBACK;
6812: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
6813: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USAGES', SQLCODE);
6814: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6815: RAISE;
6816: END load_usages;
6934: AND t.expr_type <> 208;
6935: EXCEPTION
6936: WHEN OTHERS
6937: THEN
6938: x_expr_node_date := cz_utils.epoch_begin;
6939: END get_max_expr_date;
6940:
6941: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6942: -----procedure that retrieves the last_struct_update date
6950: WHERE t.deleted_flag = record_not_deleted AND t.devl_project_id = p_model_id;
6951: EXCEPTION
6952: WHEN OTHERS
6953: THEN
6954: x_last_struct_date := cz_utils.epoch_begin;
6955: END get_last_struct_date;
6956:
6957: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6958: -----procedure that returns the source ui_defs for export
7198: FROM cz_ui_page_elements
7199: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id
7200: ORDER BY last_update_date DESC;
7201: BEGIN
7202: v_initialized_date := cz_utils.epoch_begin;
7203: v_ui_def_id_date := v_initialized_date;
7204: v_ui_node_id_date := v_initialized_date;
7205: v_ui_props_date := v_initialized_date;
7206: v_ui_node_props_date := v_initialized_date;
7230: CLOSE ui_def_cur;
7231: EXCEPTION
7232: WHEN OTHERS
7233: THEN
7234: v_ui_def_id_date := cz_utils.epoch_begin;
7235:
7236: CLOSE ui_def_cur;
7237: END;
7238:
7250: CLOSE ui_nodes_cur;
7251: EXCEPTION
7252: WHEN OTHERS
7253: THEN
7254: v_ui_node_id_date := cz_utils.epoch_begin;
7255:
7256: CLOSE ui_nodes_cur;
7257: END;
7258:
7270: CLOSE ui_properties_cur;
7271: EXCEPTION
7272: WHEN OTHERS
7273: THEN
7274: v_ui_props_date := cz_utils.epoch_begin;
7275:
7276: CLOSE ui_properties_cur;
7277: END;
7278:
7290: CLOSE ui_node_props_cur;
7291: EXCEPTION
7292: WHEN OTHERS
7293: THEN
7294: v_ui_node_props_date := cz_utils.epoch_begin;
7295:
7296: CLOSE ui_node_props_cur;
7297: END;
7298:
7310: CLOSE ui_intl_texts_cur;
7311: EXCEPTION
7312: WHEN OTHERS
7313: THEN
7314: v_ui_node_intl_date := cz_utils.epoch_begin;
7315:
7316: CLOSE ui_intl_texts_cur;
7317: END;
7318:
7330: CLOSE ui_pages_cur;
7331: EXCEPTION
7332: WHEN OTHERS
7333: THEN
7334: v_ui_pages_date := cz_utils.epoch_begin;
7335:
7336: CLOSE ui_pages_cur;
7337: END;
7338:
7350: CLOSE ui_pages_capt_cur;
7351: EXCEPTION
7352: WHEN OTHERS
7353: THEN
7354: v_ui_pages_capt_date := cz_utils.epoch_begin;
7355:
7356: CLOSE ui_pages_capt_cur;
7357: END;
7358:
7370: CLOSE ui_page_sets_cur;
7371: EXCEPTION
7372: WHEN OTHERS
7373: THEN
7374: v_ui_page_sets_date := cz_utils.epoch_begin;
7375:
7376: CLOSE ui_page_sets_cur;
7377: END;
7378:
7390: CLOSE ui_page_refs_cur;
7391: EXCEPTION
7392: WHEN OTHERS
7393: THEN
7394: v_ui_page_refs_date := cz_utils.epoch_begin;
7395:
7396: CLOSE ui_page_refs_cur;
7397: END;
7398:
7410: CLOSE ui_page_refs_capt_cur;
7411: EXCEPTION
7412: WHEN OTHERS
7413: THEN
7414: v_ui_pg_ref_capt_date := cz_utils.epoch_begin;
7415:
7416: CLOSE ui_page_refs_capt_cur;
7417: END;
7418:
7430: CLOSE ui_refs_cur;
7431: EXCEPTION
7432: WHEN OTHERS
7433: THEN
7434: v_ui_refs_date := cz_utils.epoch_begin;
7435:
7436: CLOSE ui_refs_cur;
7437: END;
7438:
7450: CLOSE ui_templs_cur;
7451: EXCEPTION
7452: WHEN OTHERS
7453: THEN
7454: v_ui_templs_date := cz_utils.epoch_begin;
7455:
7456: CLOSE ui_templs_cur;
7457: END;
7458:
7470: CLOSE ui_cont_templs_cur;
7471: EXCEPTION
7472: WHEN OTHERS
7473: THEN
7474: v_ui_cont_templs_date := cz_utils.epoch_begin;
7475:
7476: CLOSE ui_cont_templs_cur;
7477: END;
7478:
7490: CLOSE ui_actions_cur;
7491: EXCEPTION
7492: WHEN OTHERS
7493: THEN
7494: v_ui_actions_date := cz_utils.epoch_begin;
7495:
7496: CLOSE ui_actions_cur;
7497: END;
7498:
7510: CLOSE ui_images_cur;
7511: EXCEPTION
7512: WHEN OTHERS
7513: THEN
7514: v_ui_images_date := cz_utils.epoch_begin;
7515:
7516: CLOSE ui_images_cur;
7517: END;
7518:
7530: CLOSE ui_page_elements;
7531: EXCEPTION
7532: WHEN OTHERS
7533: THEN
7534: v_page_elements_date := cz_utils.epoch_begin;
7535: CLOSE ui_page_elements;
7536: END;
7537: BEGIN
7538: SELECT MAX(GREATEST(v_ui_def_id_date
7558: FROM DUAL;
7559: EXCEPTION
7560: WHEN OTHERS
7561: THEN
7562: x_max_update_date := cz_utils.epoch_begin;
7563: END;
7564: EXCEPTION
7565: WHEN OTHERS
7566: THEN
7715: v_update_date cz_func_comp_specs.last_update_date%TYPE;
7716: BEGIN
7717: IF (p_model_array.COUNT > 0)
7718: THEN
7719: x_max_update_date := cz_utils.epoch_begin;
7720:
7721: FOR i IN p_model_array.FIRST .. p_model_array.LAST
7722: LOOP
7723: BEGIN
7752: FROM cz_ps_nodes
7753: WHERE devl_project_id = p_model_id;
7754: EXCEPTION
7755: WHEN OTHERS THEN
7756: x_last_update_date := cz_utils.epoch_begin;
7757: END;
7758:
7759: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7760: ------procedure that retrieves the max last update date
7768: WHERE model_id = p_model_id;
7769: EXCEPTION
7770: WHEN OTHERS
7771: THEN
7772: x_last_update_date := cz_utils.epoch_begin;
7773: END;
7774:
7775: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7776: PROCEDURE get_max_template_date(p_template_id IN NUMBER, x_max_date OUT NOCOPY DATE)
7782: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;
7783: EXCEPTION
7784: WHEN OTHERS
7785: THEN
7786: x_max_date := cz_utils.epoch_begin;
7787: END get_max_template_date;
7788:
7789: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7790: PROCEDURE get_template_date(p_global_templs_ref IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
7789: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7790: PROCEDURE get_template_date(p_global_templs_ref IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
7791: IS
7792: l_last_update_date DATE;
7793: l_prev_date DATE := cz_utils.epoch_begin;
7794: BEGIN
7795: x_max_update_date := cz_utils.epoch_begin;
7796:
7797: IF (p_global_templs_ref.COUNT > 0)
7791: IS
7792: l_last_update_date DATE;
7793: l_prev_date DATE := cz_utils.epoch_begin;
7794: BEGIN
7795: x_max_update_date := cz_utils.epoch_begin;
7796:
7797: IF (p_global_templs_ref.COUNT > 0)
7798: THEN
7799: FOR i IN p_global_templs_ref.FIRST .. p_global_templs_ref.LAST
7815: END IF;
7816: EXCEPTION
7817: WHEN NO_DATA_FOUND
7818: THEN
7819: x_max_update_date := cz_utils.epoch_begin;
7820: END get_template_date;
7821:
7822: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7823: PROCEDURE get_last_templ_activity(p_global_templs_ref IN cz_pb_mgr.t_ref, p_server_id IN NUMBER, x_last_xfr_activity OUT NOCOPY DATE)
7822: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7823: PROCEDURE get_last_templ_activity(p_global_templs_ref IN cz_pb_mgr.t_ref, p_server_id IN NUMBER, x_last_xfr_activity OUT NOCOPY DATE)
7824: IS
7825: l_last_update_date DATE;
7826: l_prev_date DATE := cz_utils.epoch_begin;
7827: rec_count NUMBER := 0;
7828: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
7829: BEGIN
7830: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
7834: THEN
7835: l_pub_mode := cz_model_migration_pvt.mode_copy;
7836: END IF;
7837:
7838: x_last_xfr_activity := cz_utils.epoch_begin;
7839:
7840: IF (p_global_templs_ref.COUNT > 0)
7841: THEN
7842: FOR i IN p_global_templs_ref.FIRST .. p_global_templs_ref.LAST
7863: END IF;
7864: EXCEPTION
7865: WHEN OTHERS
7866: THEN
7867: x_last_xfr_activity := cz_utils.epoch_begin;
7868: END get_last_templ_activity;
7869:
7870: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7871: PROCEDURE get_effectivity_set_date(p_model_id IN NUMBER, x_last_update_date OUT NOCOPY DATE)
7882: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
7883: EXCEPTION
7884: WHEN NO_DATA_FOUND
7885: THEN
7886: x_last_update_date := cz_utils.epoch_begin;
7887: END get_effectivity_set_date;
7888:
7889: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7890: ------get last update date for effectivity
7893: v_update_date cz_effectivity_sets.last_update_date%TYPE;
7894: BEGIN
7895: IF (p_model_array.COUNT > 0)
7896: THEN
7897: x_max_update_date := cz_utils.epoch_begin;
7898:
7899: FOR i IN p_model_array.FIRST .. p_model_array.LAST
7900: LOOP
7901: get_effectivity_set_date(p_model_array(i), v_update_date);
8026: EXCEPTION
8027: WHEN NO_DATA_FOUND THEN
8028: NULL;
8029: WHEN OTHERS THEN
8030: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
8031: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
8032: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8033: RAISE;
8034: END collect_global_actions;
8065: END IF;
8066: EXCEPTION
8067: WHEN OTHERS
8068: THEN
8069: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_COLLECT_GL_TEXTS', 'SQLERRM', SQLERRM);
8070: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_GLTEXTS', SQLCODE);
8071: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8072: RAISE;
8073: END collect_global_texts;
8150: END IF;
8151: END LOOP;
8152: EXCEPTION
8153: WHEN OTHERS THEN
8154: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
8155: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
8156: x_status := PUBLICATION_ERROR;
8157: RAISE;
8158: END collect_global_rules;
8238: THEN
8239: NULL;
8240: WHEN OTHERS
8241: THEN
8242: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_template_elements', 'SQLERRM', SQLERRM);
8243: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_TMPLELEM', SQLCODE);
8244: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8245: RAISE;
8246: END collect_template_elements;
8534: IF l_template_name IS NOT NULL AND
8535: ( l_parent_container_type <> j.parent_container_type
8536: OR l_root_region_type <> j.root_region_type
8537: OR l_root_element_signature_id <> j.root_element_signature_id ) THEN
8538: cz_pb_mgr.v_err_message := cz_utils.get_text('UCT synch error', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
8539: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
8540: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8541: RAISE document_synch;
8542: END IF;
8608: END IF;
8609:
8610: EXCEPTION
8611: WHEN OTHERS THEN
8612: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
8613: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
8614: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8615: RAISE;
8616: END get_oa_tmpls;
8708: WHERE model_id = v_models_tbl(i);
8709: EXCEPTION
8710: WHEN OTHERS
8711: THEN
8712: l_capt_update_date := cz_utils.epoch_begin;
8713: END;
8714:
8715: IF ((v_last_xfr_activity IS NOT NULL) AND(v_last_xfr_activity < l_capt_update_date))
8716: THEN
8722:
8723: -----check if capt rules have changed
8724: IF (v_models_tbl.COUNT > 0)
8725: THEN
8726: l_capt_update_date := cz_utils.epoch_begin;
8727:
8728: FOR i IN v_models_tbl.FIRST .. v_models_tbl.LAST
8729: LOOP
8730: BEGIN
8734: WHERE devl_project_id = v_models_tbl(i);
8735: EXCEPTION
8736: WHEN OTHERS
8737: THEN
8738: l_capt_update_date := cz_utils.epoch_begin;
8739: END;
8740:
8741: IF ((v_last_xfr_activity IS NOT NULL) AND(v_last_xfr_activity < l_capt_update_date))
8742: THEN
8749: -----check if template elements have changed
8750: -- but actually these templs are new or changed ones!
8751: IF (cz_pb_mgr.g_ui_templates_old_temp_id_ref.COUNT > 0)
8752: THEN
8753: l_capt_update_date := cz_utils.epoch_begin;
8754:
8755: FOR i IN cz_pb_mgr.g_ui_templates_old_temp_id_ref.FIRST .. cz_pb_mgr.g_ui_templates_old_temp_id_ref.LAST
8756: LOOP
8757: BEGIN
8761: WHERE template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i);
8762: EXCEPTION
8763: WHEN OTHERS
8764: THEN
8765: l_capt_update_date := cz_utils.epoch_begin;
8766: END;
8767:
8768: IF ((v_last_xfr_activity IS NOT NULL) AND(v_last_xfr_activity < l_capt_update_date))
8769: THEN
8842: END IF;
8843: EXCEPTION
8844: WHEN OTHERS
8845: THEN
8846: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_MODEL_TO_PUBLISH_ERR', 'SQLERRM', SQLERRM);
8847: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.HAS_TOBE_PUBLISHED', SQLCODE);
8848: cz_pb_mgr.v_err_message := LTRIM(RTRIM(SUBSTR(cz_pb_mgr.v_err_message, 1, 2000)));
8849: RAISE;
8850: END has_tobe_published;
9243: AND t.expr_type <> 208;
9244:
9245: IF (v_expr_last_update IS NULL)
9246: THEN
9247: v_expr_last_update := cz_utils.epoch_begin;
9248: END IF;
9249:
9250: -----effectivitity set check
9251: get_effectivity_set_date(v_model_id, l_eff_set_date);
9467: COMMIT;
9468: EXCEPTION
9469: WHEN OTHERS
9470: THEN
9471: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXP_REQUEST_ERR', 'MODELID', modelid);
9472: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CREATE_EXPORT_REQUEST', SQLCODE);
9473: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9474: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
9475: RAISE;
9530: CLOSE remote_pb_cv;
9531:
9532: IF (v_publication_id = 0)
9533: THEN
9534: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REMOTE_ERR', 'PUBID', p_publication_id);
9535: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REMOTEPBCHECKID', SQLCODE);
9536: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9537: END IF;
9538: END IF;
9541: WHEN OTHERS
9542: THEN
9543: CLOSE remote_pb_cv;
9544:
9545: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REMOTE_ERR', 'SQLERRM', SQLERRM);
9546: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REMOTEPBCHECKID', SQLCODE);
9547: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9548: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
9549: RAISE;
9606: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
9607: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EFFSETS', SQLCODE);
9608: WHEN OTHERS
9609: THEN
9610: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_effectivity_sets', 'SQLERRM', SQLERRM);
9611: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTEFFSETS', SQLCODE);
9612: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9613: END;
9614:
9768: WHERE cz_servers.server_local_id = p_server_id;
9769: EXCEPTION
9770: WHEN NO_DATA_FOUND
9771: THEN
9772: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_NO_SERVER_NAME_FOUND', 'SERVERID', p_server_id);
9773: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
9774: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9775: WHEN OTHERS
9776: THEN
9773: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
9774: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9775: WHEN OTHERS
9776: THEN
9777: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_SERVER_NAME_ERR', 'SERVERID', p_server_id);
9778: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
9779: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9780: END;
9781:
9796: THEN
9797: v_model_name := 'Model name not found for model_id: ' || cz_pb_mgr.v_root_model_id;
9798: END;
9799:
9800: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_BOMSYNCH_VERIFY_ERR', 'MODELNAME', v_model_name);
9801: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROC', SQLCODE);
9802:
9803: ----trap errors from verify model to populate cz_db_logs
9804: BEGIN
9851: END IF;
9852: EXCEPTION
9853: WHEN OTHERS
9854: THEN
9855: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_BOMSYNCH_PROC_ERR', 'SQLERRM', SQLERRM);
9856: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
9857: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9858: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
9859: RAISE;
9879: END IF;
9880: EXCEPTION
9881: WHEN OTHERS
9882: THEN
9883: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_GET_SYNC_ERR', 'SQLERRM', SQLERRM);
9884: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.GETSYNCVALUES', SQLCODE);
9885: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9886: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
9887: RAISE;
10155: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
10156: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10157: WHEN OTHERS
10158: THEN
10159: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
10160: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10161: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10162: END;
10163:
10293: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10294: RAISE;
10295: WHEN OTHERS
10296: THEN
10297: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
10298: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.COPYLCEHDRS', SQLCODE);
10299: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10300: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10301: RAISE;
10378: ORDER BY lce_header_id, seq_nbr;
10379: EXCEPTION
10380: WHEN NO_DATA_FOUND
10381: THEN
10382: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
10383: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
10384: WHEN OTHERS
10385: THEN
10386: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
10382: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
10383: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
10384: WHEN OTHERS
10385: THEN
10386: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
10387: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
10388: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10389: END;
10390:
10489: EXCEPTION
10490: WHEN OTHERS
10491: THEN
10492: ROLLBACK;
10493: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
10494: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCETEXTS', SQLCODE);
10495: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10496: END;
10497: END LOOP;
10508: END IF; /* end if of cz_pb_mgr.v_status_code <> PUBLICATION_ERROR */
10509: EXCEPTION
10510: WHEN OTHERS
10511: THEN
10512: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
10513: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.COPYLCETEXTS', SQLCODE);
10514: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10515: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10516: RAISE;
10534: ORDER BY UPPER(language_code);
10535: EXCEPTION
10536: WHEN OTHERS
10537: THEN
10538: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_LANG');
10539: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
10540: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10541: cz_pb_mgr.global_export_retcode := 2;
10542: END;
10564: END LOOP;
10565: EXCEPTION
10566: WHEN OTHERS
10567: THEN
10568: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_LANG');
10569: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
10570: cz_pb_mgr.v_status_code := 'ERR';
10571: cz_pb_mgr.global_export_retcode := 2;
10572: END;
10579: FOR l IN cz_pb_mgr.v_src_lang_code_tbl.FIRST .. cz_pb_mgr.v_src_lang_code_tbl.LAST
10580: LOOP
10581: IF (cz_pb_mgr.v_src_lang_code_tbl(l) <> cz_pb_mgr.v_tgt_lang_code_tbl(l))
10582: THEN
10583: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_SRC_TGT_LANG', 'LANGUAGE', cz_pb_mgr.v_tgt_lang_code_tbl(l));
10584: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
10585: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10586: cz_pb_mgr.global_export_retcode := 2;
10587: END IF;
10586: cz_pb_mgr.global_export_retcode := 2;
10587: END IF;
10588: END LOOP;
10589: ELSE
10590: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_LANG');
10591: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
10592: cz_pb_mgr.v_status_code := 'ERR';
10593: cz_pb_mgr.global_export_retcode := 2;
10594: END IF;
11066: END IF;
11067: EXCEPTION
11068: WHEN OTHERS
11069: THEN
11070: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REF_ID_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
11071: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11072: x_status := PUBLICATION_ERROR;
11073: RAISE;
11074: END;
11729: COMMIT;
11730: EXCEPTION
11731: WHEN OTHERS
11732: THEN
11733: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
11734: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
11735: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11736: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11737: RAISE;
11754: END LOOP;
11755: COMMIT;
11756: EXCEPTION
11757: WHEN OTHERS THEN
11758: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
11759: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
11760: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11761: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11762: RAISE;
11823: COMMIT;
11824: EXCEPTION
11825: WHEN OTHERS
11826: THEN
11827: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
11828: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);
11829: x_status := PUBLICATION_ERROR;
11830: RAISE;
11831: END;
11902: COMMIT;
11903: EXCEPTION
11904: WHEN OTHERS
11905: THEN
11906: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
11907: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);
11908: x_status := PUBLICATION_ERROR;
11909: RAISE;
11910: END;
11955: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
11956: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FUNCCOMP', SQLCODE);
11957: WHEN OTHERS
11958: THEN
11959: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_func_comp_specs', 'SQLERRM', SQLERRM);
11960: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11961: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11962: RAISE;
11963: END;
12190: END LOOP;
12191: END IF;
12192: EXCEPTION
12193: WHEN OTHERS THEN
12194: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
12195: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
12196: x_status := PUBLICATION_ERROR;
12197: RAISE;
12198: END bulk_collect_rules;
12275: END IF;
12276: EXCEPTION
12277: WHEN OTHERS
12278: THEN
12279: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_DATA_FOUND', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
12280: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:UIDEFID', SQLCODE);
12281: x_status := PUBLICATION_ERROR;
12282: RAISE;
12283: END get_new_ui_def_id;
12960: COMMIT;
12961: EXCEPTION
12962: WHEN OTHERS
12963: THEN
12964: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_devl_projects', 'SQLERRM', SQLERRM);
12965: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
12966: x_status := PUBLICATION_ERROR;
12967: RAISE;
12968: END insert_devl_projects;
12978: WHERE cz_db_settings.setting_id = sequence_incr_str;
12979: EXCEPTION
12980: WHEN OTHERS
12981: THEN
12982: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_INCR');
12983: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SEQINCR', SQLCODE);
12984: x_oraclesequenceincr := 20;
12985: END;
12986:
13311: THEN
13312: --Raise migration failure.
13313: --Proposed: Usage Limit maxed out during the migration process.
13314: cz_pb_mgr.v_err_message :=
13315: cz_utils.get_text('CZDEV_MAX_USAGES_CREATED_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
13316: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.resolve_effective_usage_mask', SQLCODE);
13317: cz_pb_mgr.v_status_code := 0; -- MIGRATION_ERROR;
13318: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
13319: RAISE NO_DATA_FOUND;
13699: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
13700: EXCEPTION
13701: WHEN OTHERS
13702: THEN
13703: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_ref_expls', 'SQLERRM', SQLERRM);
13704: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
13705: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
13706: RAISE;
13707: END;
13974: COMMIT;
13975: EXCEPTION
13976: WHEN OTHERS
13977: THEN
13978: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_node_props', 'ERR', SQLERRM);
13979: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.NODEPROPS', SQLCODE);
13980: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
13981: END insert_ui_node_props;
13982:
14275: END IF;
14276: EXCEPTION
14277: WHEN OTHERS
14278: THEN
14279: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_defs', 'SQLERRM', SQLERRM);
14280: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14281: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14282: RAISE;
14283: END;
14463: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
14464: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UINODES', SQLCODE);
14465: WHEN OTHERS
14466: THEN
14467: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_nodes', 'SQLERRM', SQLERRM);
14468: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14469: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14470: RAISE;
14471: END;
15138: END IF;
15139: EXCEPTION
15140: WHEN OTHERS
15141: THEN
15142: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_archive_refs', 'SQLERRM', SQLERRM);
15143: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ARCHIVES', SQLCODE);
15144: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15145: RAISE;
15146: END bulk_collect_archives;
15274: THEN
15275: NULL;
15276: WHEN OTHERS
15277: THEN
15278: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_filter_sets', 'SQLERRM', SQLERRM);
15279: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FILTERSETS', SQLCODE);
15280: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15281: RAISE;
15282: END;
15326: THEN
15327: NULL;
15328: WHEN OTHERS
15329: THEN
15330: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
15331: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
15332: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15333: RAISE;
15334: END;
15411: END IF;
15412: EXCEPTION
15413: WHEN OTHERS
15414: THEN
15415: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
15416: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
15417: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15418: RAISE;
15419: END export_populators;
15460: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15461: FOR j IN (SELECT rule.name rulename, prj.name prjname
15462: FROM cz_rules rule, cz_devl_projects prj
15463: WHERE rule.rule_id=p_ruleid_tbl(i) AND rule.devl_project_id=prj.devl_project_id) LOOP
15464: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MIGR_RULE_ERR', 'FK_COL', p_colname, 'RULE_NAME', j.rulename, 'MODEL_NAME', j.prjname);
15465: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'upload_rule_schema.mm_resolve_rule_fks', SQLCODE);
15466: END LOOP;
15467: RAISE;
15468: END;
15558: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
15559: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
15560: WHEN OTHERS
15561: THEN
15562: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rule_folders', 'SQLERRM', SQLERRM);
15563: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
15564: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15565: RAISE;
15566: END;
15812: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
15813: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
15814: WHEN OTHERS
15815: THEN
15816: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_expression_nodes', 'SQLERRM', SQLERRM);
15817: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
15818: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15819: RAISE;
15820: END;
15956: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
15957: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
15958: WHEN OTHERS
15959: THEN
15960: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
15961: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
15962: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15963: RAISE;
15964: END;
16025: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
16026: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
16027: WHEN OTHERS
16028: THEN
16029: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
16030: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
16031: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16032: RAISE;
16033: END;
16127:
16128: IF (v_null <> v_property_record_ref(v_remote_prop_ref(i)).data_type)
16129: THEN
16130: --~> 'Property ''%PROPERTYNAME'' has a different data type on the target instance.'
16131: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_UPVAL_PROPERTY', 'PROPERTYNAME', v_property_record_ref(v_remote_prop_ref(i)).NAME);
16132: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
16133: v_error_flag := 1;
16134: END IF;
16135: EXCEPTION
16183: WHEN NO_DATA_FOUND
16184: THEN
16185: v_error_flag := 1;
16186: --~> 'Item type ''%ITEMTYPENAME'' has a different combination of properties on the target instance.'
16187: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_UPVAL_ITEMTYPE', 'ITEMTYPENAME', v_type_record_ref(v_item_types_new_ref(i)).NAME);
16188: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
16189: END;
16190:
16191: j := v_type_property_record_ref(v_item_types_new_ref(i)).NEXT(j);
16269: , mm_v_itmst_src_app_id_ref(i)
16270: --IMPORTANT: this is bom-synchronized (if necessary) orig_sys_ref, hashed by
16271: --source item_id
16272: , NVL(mm_v_ht_items_orig_ref(v_item_masters_tbl(i)), '0');
16273: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_UPVAL_ITEM', 'ITEMNAME', mm_v_itmst_ref_part_nbr_ref(i),
16274: 'SRCNAME', v_type_record_ref(v_item_types_tbl(i)).NAME,
16275: 'TGTNAME', v_target_item_type_name);
16276: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
16277: END;
16288: RAISE;
16289: WHEN OTHERS
16290: THEN
16291: --~>'Unexpected error during upfront validation: %ERRORTEXT'
16292: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_UPVAL_UNEXPECTED', 'ERRORTEXT', SQLERRM);
16293: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
16294: RAISE;
16295: END mm_raiseallpossiblesyncerrors;
16296: ------------------------------------------------------------------------------------------------
16616: THEN
16617: NULL;
16618: WHEN OTHERS
16619: THEN
16620: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_item_type_properties', 'SQLERRM', SQLERRM);
16621: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ITEMTYPE', SQLCODE);
16622: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16623: END;
16624:
16839: EXCEPTION
16840: WHEN cz_pb_global_synch
16841: THEN
16842: --~> 'Errors in upfront validation, unable to continue.'
16843: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPVAL_ERRORS');
16844: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
16845: x_status_code := PUBLICATION_ERROR;
16846: WHEN pb_upload_ps_schema
16847: THEN
17248: END IF;
17249: ELSE
17250: IF (v_validate_count <> 1)
17251: THEN
17252: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SCHEMA_COMPAT_ERR');
17253: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:VALSCH', SQLCODE);
17254: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17255: ELSE
17256: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17308: clear_all_tables(cz_pb_mgr.v_status_code);
17309: EXCEPTION
17310: WHEN OTHERS
17311: THEN
17312: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXPORT_FAILURE', 'SQLERRM', SQLERRM);
17313: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPORT_FAILURE', SQLCODE);
17314: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17315: RAISE;
17316: END proc_export;
17385: ELSIF l_ui_style = g_ui_style_custom THEN
17386: RETURN;
17387: ELSE
17388: x_return_status := 2;
17389: x_msg_data := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'UISTYLE', l_ui_style);
17390: RETURN;
17391: END IF;
17392: END IF;
17393:
17522: FROM DUAL;
17523: EXCEPTION
17524: WHEN OTHERS
17525: THEN
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);
17609: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';
17610: EXCEPTION
17611: WHEN OTHERS
17612: THEN
17613: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL');
17614: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
17615: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17616: END;
17617:
17627: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_root_ui_def_id AND cz_ui_defs.deleted_flag = '0';
17628: EXCEPTION
17629: WHEN OTHERS
17630: THEN
17631: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI');
17632: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17633: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17634: END;
17635: END IF;
17661: ,x_model_name => l_model_name
17662: ,p_check_root_ui_only=> TRUE
17663: );
17664: IF l_ui_upto_date_status IS NOT NULL AND l_ui_upto_date_status <> 0 THEN
17665: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'UI' ||
17666: ' ''' || l_ui_name || '''', 'MODELID', '''' || l_model_name || '''');
17667: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', -20001);
17668: IF l_ui_style_tbl(i) = oa_ui_style THEN
17669: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17700: END IF;
17701:
17702: IF (v_model_chk_count = 0)
17703: THEN
17704: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL');
17705: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17706: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17707: ELSIF(v_ui_chk_count = 0)
17708: THEN
17705: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17706: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17707: ELSIF(v_ui_chk_count = 0)
17708: THEN
17709: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI');
17710: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17711: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17712: ELSE
17713: -----------create a dummy publication
17761: COMMIT;
17762: EXCEPTION
17763: WHEN OTHERS
17764: THEN
17765: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXPORT_FAILURE', 'SQLERRM', SQLERRM);
17766: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17767: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17768: END;
17769:
18232: WHEN OTHERS
18233: THEN
18234: CLOSE tobepublished_cur;
18235:
18236: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_GEN_ERROR', 'TOBEPUBLISHED', v_tobepublished, 'SQLERRM', SQLERRM);
18237: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISH_ALL_MODELS', SQLCODE);
18238: END publish_all_models;
18239:
18240: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18314: END;
18315: EXCEPTION
18316: WHEN run_id_error
18317: THEN
18318: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');
18319: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.XFRINFO', SQLCODE);
18320: WHEN OTHERS
18321: THEN
18322: RAISE;
18336: AND ROWNUM < 2;
18337: EXCEPTION
18338: WHEN NO_DATA_FOUND
18339: THEN
18340: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_GLOBAL_TMPL', 'PUBID', cz_pb_mgr.v_publication_id);
18341: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
18342: x_status := PUBLICATION_ERROR;
18343: END check_ui_template_exist;
18344:
18366: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;
18367:
18368: IF (v_model_chk_count = 0)
18369: THEN
18370: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL', 'PUBID', p_publication_id);
18371: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
18372: x_status := PUBLICATION_ERROR;
18373: END IF;
18374:
18382: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
18383:
18384: IF (v_ui_chk_count = 0)
18385: THEN
18386: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI', 'PUBID', p_publication_id);
18387: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
18388: x_status := PUBLICATION_ERROR;
18389: END IF;
18390: END IF;
18481: THEN
18482: IF ((p_export_status = 'PUP') OR(p_export_status = 'ERR') OR(p_export_status = 'PRC') OR(p_export_status = 'OK'))
18483: THEN
18484: cz_pb_mgr.v_err_message :=
18485: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', cz_pb_mgr.v_publication_id, 'SQLERRM', 'Export status check failed');
18486: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
18487: cz_pb_mgr.v_err_message := 'Publication with a status PRC/PUP/ERR may not be published';
18488: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
18489: x_status := PUBLICATION_ERROR;
18493: IF (p_export_status <> 'OK')
18494: THEN
18495: x_status := PUBLICATION_ERROR;
18496: cz_pb_mgr.v_err_message :=
18497: cz_utils.get_text('CZ_REPUB_STATUS_CHK', 'PUBID', cz_pb_mgr.v_publication_id, 'SQLERRM', 'Export status check failed');
18498: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISHMODEL', SQLCODE);
18499: END IF;
18500: END IF;
18501: END IF;
18727: END IF;
18728:
18729: IF NOT l_ui_upto_date AND l_model_upto_date THEN -- l_status = 2
18730: status :=
18731: cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'UI' || ' ''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
18732: ELSIF l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 1
18733: status := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'LOGIC', 'MODELID', '''' || l_model_name || '''');
18734: ELSIF NOT l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 3
18735: status :=
18729: IF NOT l_ui_upto_date AND l_model_upto_date THEN -- l_status = 2
18730: status :=
18731: cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'UI' || ' ''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
18732: ELSIF l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 1
18733: status := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'LOGIC', 'MODELID', '''' || l_model_name || '''');
18734: ELSIF NOT l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 3
18735: status :=
18736: cz_utils.get_text('CZ_PB_UI_LOGIC_NOT_UP_TO_DATE', 'STRING', '''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
18737: ELSE
18732: ELSIF l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 1
18733: status := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'LOGIC', 'MODELID', '''' || l_model_name || '''');
18734: ELSIF NOT l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 3
18735: status :=
18736: cz_utils.get_text('CZ_PB_UI_LOGIC_NOT_UP_TO_DATE', 'STRING', '''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
18737: ELSE
18738: status := '0';
18739: END IF;
18740: EXCEPTION
18831: END IF;
18832: EXCEPTION
18833: WHEN OTHERS
18834: THEN
18835: log_report('cz_utils', 'migrate_name', 1, SQLERRM, fnd_log.level_unexpected);
18836: v_name := 'ERROR';
18837: RETURN v_name;
18838: END;
18839:
18890: clear_all_tables(cz_pb_mgr.v_status_code);
18891: initialize_pb_parameters(publicationid);
18892:
18893: IF (fnd_global.user_name IS NULL) THEN
18894: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', 'User is not initialized on session');
18895: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CHECKUSER', 21002);
18896: RAISE user_not_initialized;
18897: END IF;
18898:
18920: END IF;
18921:
18922: IF l_proc_name IS NOT NULL THEN
18923: IF l_proc_name = l_publication_proc THEN
18924: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');
18925: ELSIF l_proc_name = l_migration_proc THEN
18926: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'model migration');
18927: ELSE
18928: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
18922: IF l_proc_name IS NOT NULL THEN
18923: IF l_proc_name = l_publication_proc THEN
18924: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');
18925: ELSIF l_proc_name = l_migration_proc THEN
18926: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'model migration');
18927: ELSE
18928: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
18929: END IF;
18930: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message,'cz_pb_mgr.CHKPROCESS',21001);
18924: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');
18925: ELSIF l_proc_name = l_migration_proc THEN
18926: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'model migration');
18927: ELSE
18928: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
18929: END IF;
18930: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message,'cz_pb_mgr.CHKPROCESS',21001);
18931: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18932: x_pb_status := PUBLICATION_ERROR;
18987: END IF;
18988:
18989: IF (l_tgt_status <> '0') THEN
18990:
18991: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', l_tgt_msg);
18992: RAISE cz_pb_link_problem;
18993: END IF;
18994: END IF;
18995:
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;
19374: LOOP
19375: IF (cz_pb_mgr.v_models_to_be_exported(i) = cz_pb_mgr.v_root_model_id) THEN
19376: --Root Model %SRCROOT was migrated to instance %TARGET as %TARGROOTPATH.
19377: l_message :=
19378: cz_utils.get_text('CZ_MM_ROOT_EXPORTED'
19379: ,'SRCROOT'
19380: ,l_srcroot
19381: ,'TARGET'
19382: ,cz_pb_mgr.v_server_local_name
19387: ELSE
19388: --Referenced Model %SRCMODEL was migrated to instance %TARGET as %TARGREPOSPATH when migrating %SRCROOT to %TARGROOTPATH.
19389: l_srcmodel := REPLACE(cz_developer_utils_pvt.get_repository_path(v_models_to_be_exported(i), 'PRJ'), '/', '.');
19390: l_message :=
19391: cz_utils.get_text('CZ_MM_MODEL_EXPORTED'
19392: ,'SRCMODEL'
19393: ,l_srcmodel
19394: ,'TARGET'
19395: ,cz_pb_mgr.v_server_local_name
19412: --Referenced Model %SRCMODEL is unchanged locally and on instance %TARGET since its prior migration as %TARGREPOSPATH.
19413: --It has been reused in migrating root Model %SRCROOT to %TARGROOTPATH.
19414: l_srcmodel := REPLACE(cz_developer_utils_pvt.get_repository_path(v_models_not_to_be_exported(i), 'PRJ'), '/', '.');
19415: l_message :=
19416: cz_utils.get_text('CZ_MM_MODEL_NOT_EXPORTED'
19417: ,'SRCMODEL'
19418: ,l_srcmodel
19419: ,'TARGET'
19420: ,cz_pb_mgr.v_server_local_name
19439: update_pb_status(cz_pb_mgr.v_publication_id, cz_pb_mgr.v_status_code, cz_pb_mgr.v_models_to_be_exported, cz_pb_mgr.v_status_code);
19440:
19441: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN
19442: cz_pb_mgr.v_err_message :=
19443: cz_utils.get_text('CZ_PB_SUCCESS', 'MODELID', cz_pb_mgr.v_root_model_id, 'SERVERID', cz_pb_mgr.v_server_id);
19444: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISH_MODEL', SQLCODE);
19445: ELSE
19446: cz_pb_mgr.global_export_retcode := 2;
19447: rollback_data(cz_pb_mgr.v_db_link);
19686: errbuf := NULL;
19687:
19688: IF (cz_pb_mgr.global_export_retcode = 1)
19689: THEN
19690: errbuf := cz_utils.get_text('CZ_PB_WARNING');
19691: END IF;
19692:
19693: IF (cz_pb_mgr.global_export_retcode = 2)
19694: THEN
19691: END IF;
19692:
19693: IF (cz_pb_mgr.global_export_retcode = 2)
19694: THEN
19695: errbuf := cz_utils.get_text('CZ_PB_FAILURE');
19696: END IF;
19697:
19698: retcode := cz_pb_mgr.global_export_retcode;
19699: EXCEPTION
19699: EXCEPTION
19700: WHEN OTHERS
19701: THEN
19702: retcode := 2;
19703: errbuf := cz_utils.get_text('CZ_PB_OTHERS');
19704: END;
19705:
19706: PROCEDURE publish_single_model_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_publication_id NUMBER)
19707: AS
19714: errbuf := NULL;
19715:
19716: IF (cz_pb_mgr.global_export_retcode = 1)
19717: THEN
19718: errbuf := cz_utils.get_text('CZ_PB_WARNING');
19719: END IF;
19720:
19721: IF (cz_pb_mgr.global_export_retcode = 2)
19722: THEN
19719: END IF;
19720:
19721: IF (cz_pb_mgr.global_export_retcode = 2)
19722: THEN
19723: errbuf := cz_utils.get_text('CZ_PB_FAILURE');
19724: END IF;
19725:
19726: retcode := cz_pb_mgr.global_export_retcode;
19727: EXCEPTION
19727: EXCEPTION
19728: WHEN OTHERS
19729: THEN
19730: retcode := 2;
19731: errbuf := cz_utils.get_text('CZ_PB_OTHERS');
19732: END;
19733:
19734: --------------------------------------
19735: PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2)
19756: EXCEPTION
19757: WHEN OTHERS
19758: THEN
19759: retcode := 2;
19760: errbuf := cz_utils.get_text('CZ_APP_OTHERS', 'SQLERRM', SQLERRM);
19761: END;
19762:
19763: ----------------------------------------
19764: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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
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);
20047: COMMIT;
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);
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;
20065: WHEN OTHERS
20066: THEN
20067: x_return_status := FND_API.G_RET_STS_ERROR;
20217: EXCEPTION
20218: WHEN OTHERS
20219: THEN
20220: x_status := '-1';
20221: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EDIT_SRC_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
20222: log_pb_errors(v_err_message, 1, 'cz_pb_mgr.EDITPB', SQLCODE);
20223: RAISE;
20224: END;
20225:
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;
20433: END IF;
20434: END IF;
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: --------------------------------------------------------
20450: PROCEDURE edit_publication(
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;
20552: EXCEPTION
20553: WHEN pub_maybe_obsoleted
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: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
20567: ---------edit publication
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;
20679: EXCEPTION
20680: WHEN pub_maybe_obsoleted
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: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
20693: PROCEDURE chk_pub_overlap_internal(
21004: BEGIN
21005: IF (p_start_date > p_end_date)
21006: THEN
21007: x_status := PUBLICATION_ERROR;
21008: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_VALIDATE_DATES', 'STARTDATE', TO_CHAR(p_start_date), 'ENDDATE', TO_CHAR(p_end_date));
21009: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21010: END IF;
21011: EXCEPTION
21012: WHEN OTHERS
21052: EXCEPTION
21053: WHEN OTHERS
21054: THEN
21055: x_status := PUBLICATION_ERROR;
21056: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_PARAM_ERROR', 'PubId', p_publication_id, 'SQLERRM', SQLERRM);
21057: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21058: END get_pb_parameters;
21059:
21060: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21110: EXCEPTION
21111: WHEN OTHERS
21112: THEN
21113: x_status := PUBLICATION_ERROR;
21114: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_CREATE_REQUEST_ERROR', 'PubId', p_publication_id, 'SQLERRM', SQLERRM);
21115: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21116: END create_republish_request;
21117:
21118: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21406: EXCEPTION
21407: WHEN reset_date_error
21408: THEN
21409: x_status := PUBLICATION_ERROR;
21410: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_RESET_DATES_ERROR', 'PubId', p_publicationid, 'SQLERRM', SQLERRM);
21411: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21412: WHEN OTHERS
21413: THEN
21414: x_status := PUBLICATION_ERROR;
21411: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21412: WHEN OTHERS
21413: THEN
21414: x_status := PUBLICATION_ERROR;
21415: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_RESET_DATES_ERROR', 'PubId', p_publicationid, 'SQLERRM', SQLERRM);
21416: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21417: END reset_pb_dates;
21418:
21419: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21436: EXCEPTION
21437: WHEN OTHERS
21438: THEN
21439: x_reset_status := PUBLICATION_ERROR;
21440: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_RESET_PB_CHANGES', 'PubId', p_publication_id, 'SQLERRM', SQLERRM);
21441: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21442: END reset_repub_changes;
21443:
21444: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
21564: );
21565:
21566: IF (v_publicationidstring <> '-1')
21567: THEN
21568: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_OVERLAP', 'PubId', p_publication_id, 'PUBSTR', v_publicationidstring);
21569: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21570: RAISE common_exception;
21571: ELSE
21572: ----create new publication request
21587: RAISE common_exception;
21588: ELSE
21589: cz_pb_mgr.v_msg_tbl.DELETE;
21590: cz_pb_mgr.v_pb_run_id := x_run_id;
21591: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REPUBLISH_SUCCESS', 'PubId', p_publication_id);
21592: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUB_MODEL', SQLCODE);
21593: log_pb_trace;
21594: END IF;
21595:
21598: EXCEPTION
21599: WHEN common_exception
21600: THEN
21601: ROLLBACK;
21602: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REPUBLISH_FAILURE', 'PubId', p_publication_id);
21603: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21604: x_status := PUBLICATION_ERROR;
21605: log_pb_trace;
21606: cz_pb_mgr.v_republish_model := no_mode;
21607: WHEN OTHERS
21608: THEN
21609: x_status := PUBLICATION_ERROR;
21610: cz_pb_mgr.v_republish_model := no_mode;
21611: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REPUBLISH_FAILURE', 'PubId', p_publication_id, 'SQLERRM', SQLERRM);
21612: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
21613: log_pb_trace;
21614: END republish_model;
21615:
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);
21762: fnd_msg_pub.ADD;
21762: fnd_msg_pub.ADD;
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;
21850: copy_name := 'Copy ('||to_char(L)||') of '||original_name;
21851: RETURN copy_name ;
21852: EXCEPTION
21853: WHEN OTHERS THEN
21854: -- x_error:= CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.COPY_NAME',-222);
21855: log_report('cz_utils', 'copy_name', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
21856: copy_name := 'ERROR';
21857: RETURN copy_name ;
21858: END copy_name;
21851: RETURN copy_name ;
21852: EXCEPTION
21853: WHEN OTHERS THEN
21854: -- x_error:= CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.COPY_NAME',-222);
21855: log_report('cz_utils', 'copy_name', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
21856: copy_name := 'ERROR';
21857: RETURN copy_name ;
21858: END copy_name;
21859:
22006: -----if no start or end dates
22007: ---- are passed, then default to epoch begin and epoch end respectively
22008: IF (p_start_date IS NULL)
22009: THEN
22010: l_start_date := cz_utils.epoch_begin;
22011: ELSE
22012: l_start_date := p_start_date;
22013: END IF;
22014:
22013: END IF;
22014:
22015: IF (p_end_date IS NULL)
22016: THEN
22017: l_end_date := cz_utils.epoch_end;
22018: ELSE
22019: l_end_date := p_end_date;
22020: END IF;
22021:
22290: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
22291: EXCEPTION
22292: WHEN OTHERS
22293: THEN
22294: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
22295: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
22296: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
22297: RAISE;
22298: END;
22930:
22931: IF (target_id IS NOT NULL)
22932: THEN
22933: cz_pb_mgr.v_err_message :=
22934: cz_utils.get_text('CZ_MM_EXISTING_GLOBAL_DATA', 'GLOBAL_ENTITY', l_sync_msg_object_type_tkn, 'ENTITY_NAME', l_sync_msg_object_name_tkn);
22935: log_pb_errors(cz_pb_mgr.v_err_message, 0, 'mm_get_ifexists_on_target', -1);
22936: END IF;
22937: EXCEPTION
22938: WHEN NO_DATA_FOUND
23074: COMMIT;
23075: EXCEPTION
23076: WHEN OTHERS
23077: THEN
23078: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
23079: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
23080: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23081: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23082: RAISE;
23355: END IF;
23356: EXCEPTION
23357: WHEN OTHERS
23358: THEN
23359: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
23360: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
23361: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23362: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23363: END mm_resolve_ids;
23395: END IF;
23396: EXCEPTION
23397: WHEN OTHERS
23398: THEN
23399: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
23400: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
23401: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23402: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23403: END mm_resolve_orig_refs;
23447: END IF;
23448: EXCEPTION
23449: WHEN OTHERS
23450: THEN
23451: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
23452: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
23453: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23454: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23455: END mm_resolve_ids_w_rp_entries;
23525: INTO l_rule_folder_name;
23526:
23527: CLOSE remote_rule_seq_name_cv;
23528:
23529: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_EFFSET_CORRUPT_RULSEQ', 'RULE_NAME', l_rule_name, 'RULE_SEQUENCE', l_rule_folder_name);
23530: log_pb_errors(cz_pb_mgr.v_err_message, 0, 'mm_resolve_rule_seq_effsetid', -1);
23531: l_sql_string :=
23532: 'UPDATE cz_rules'
23533: || cz_pb_mgr.v_db_link
23543: || ' '
23544: || ' AND deleted_flag = ''0'' ';
23545:
23546: EXECUTE IMMEDIATE l_sql_string
23547: USING cz_utils.epoch_end, cz_utils.epoch_begin;
23548: END IF;
23549: END LOOP;
23550: END IF;
23551: END mm_resolve_rule_seq_effsetid;
23580:
23581: EXCEPTION
23582: WHEN OTHERS THEN
23583: --'Unable to resolve the import source server ID for the migration target.'
23584: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_ERR_MIGTGT_IMPORT_SERVER ');
23585: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
23586: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23587: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23588: RAISE;
23623: --The import source of the migration target instance is not defined as a remote server on the migration source instance.
23624: --Please create a link to hostname '%HOSTNAME', listener port %LISTENER, instance name '%INSTANCE' by running the
23625: --Define Remote Server and Enable Remote Server concurrent programs on the migration source instance.
23626:
23627: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_ERR_MIGTGT_TARGET_SERVER', 'HOSTNAME', l_hostname, 'LISTENER', l_db_listener_port, 'INSTANCE', l_instance_name);
23628: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
23629: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23630: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
23631: RETURN -1;
23692: RETURN FALSE;
23693:
23694: EXCEPTION
23695: WHEN others THEN
23696: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_MODEL_TO_PUBLISH_ERR', 'SQLERRM', sqlerrm);
23697: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.HAS_TOBE_PUBLISHED', SQLCODE);
23698: cz_pb_mgr.v_err_message := LTRIM(RTRIM(SUBSTR(cz_pb_mgr.v_err_message, 1, 2000)));
23699: RAISE;
23700: END has_ui_inany_chld_mdl_changed;