[Home] [Help]
791: END IF;
792: EXCEPTION
793: WHEN OTHERS
794: THEN
795: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);
796: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDLOCALTEXT', SQLCODE);
797: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
798: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
799: RAISE;
865: END IF;
866: EXCEPTION
867: WHEN OTHERS
868: THEN
869: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_localized_texts', 'SQLERRM', SQLERRM);
870: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDLOCALTEXT', SQLCODE);
871: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
872: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
873: RAISE;
935: END;
936: END LOOP;
937: EXCEPTION
938: WHEN OTHERS THEN
939: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM',SQLERRM);
940: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.RESOLVEIDS',SQLCODE);
941: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
942: cz_pb_mgr.v_sql_err_msg := substr(SQLERRM,1,2000);
943: RAISE;
1001: END IF;
1002:
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM',SQLERRM);
1006: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.RESOLVEIDS',SQLCODE);
1007: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1008: cz_pb_mgr.v_sql_err_msg := substr(SQLERRM,1,2000);
1009: END resolve_tmpl_ui_defs;
1094: END IF;
1095: EXCEPTION
1096: WHEN OTHERS
1097: THEN
1098: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
1099: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
1100: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1101: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1102: END resolve_intl_texts;
1230: WHEN OTHERS
1231: THEN
1232: ROLLBACK;
1233: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
1234: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', table_name, 'SQLERRM', SQLERRM);
1235: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
1236: cz_pb_mgr.v_status_code := cz_pb_mgr.PUBLICATION_ERROR;
1237: RAISE;
1238: END;
1276: END IF;
1277: EXCEPTION
1278: WHEN OTHERS
1279: THEN
1280: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
1281: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUB', SQLCODE);
1282: x_status := PUBLICATION_ERROR;
1283: RAISE;
1284: END get_new_publication_id;
1398: WHEN OTHERS
1399: THEN
1400: ROLLBACK;
1401: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
1402: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', table_name, 'SQLERRM', SQLERRM);
1403: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTO', SQLCODE);
1404: cz_pb_mgr.v_status_code := cz_pb_mgr.PUBLICATION_ERROR;
1405: RAISE;
1406: END;
1459: COMMIT;
1460: EXCEPTION
1461: WHEN OTHERS
1462: THEN
1463: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'CZ_LOCALIZED_TEXTS', 'SQLERRM', SQLERRM);
1464: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_localized_texts', SQLCODE);
1465: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
1466: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
1467: RAISE;
2122: v_insertstring :=
2123: v_insertstring
2124: || ' EXCEPTION WHEN OTHERS THEN '
2125: || ' '
2126: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2127: || ' '
2128: || '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'');'
2129: || ' '
2130: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2248: v_insertstring :=
2249: v_insertstring
2250: || ' EXCEPTION WHEN OTHERS THEN'
2251: || ' '
2252: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2253: || ' '
2254: || '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'');'
2255: || ' '
2256: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2372: v_insertstring :=
2373: v_insertstring
2374: || ' EXCEPTION WHEN OTHERS THEN'
2375: || ' '
2376: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2377: || ' '
2378: || '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'');'
2379: || ' '
2380: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2494: v_insertstring :=
2495: v_insertstring
2496: || ' EXCEPTION WHEN OTHERS THEN '
2497: || ' '
2498: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2499: || ' '
2500: || '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'');'
2501: || ' '
2502: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2614: v_insertstring :=
2615: v_insertstring
2616: || ' EXCEPTION WHEN OTHERS THEN '
2617: || ' '
2618: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2619: || ' '
2620: || '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'');'
2621: || ' '
2622: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2734: v_insertstring :=
2735: v_insertstring
2736: || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN NULL; WHEN OTHERS THEN'
2737: || ' '
2738: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2739: || ' '
2740: || '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'');'
2741: || ' '
2742: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2860: v_insertstring :=
2861: v_insertstring
2862: || ' EXCEPTION WHEN OTHERS THEN '
2863: || ' '
2864: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2865: || ' '
2866: || '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'');'
2867: || ' '
2868: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2931: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
2932: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2933: WHEN OTHERS
2934: THEN
2935: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);
2936: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2937: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
2938: END;
2939:
3000: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
3001: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
3002: WHEN OTHERS
3003: THEN
3004: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);
3005: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
3006: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3007: END;
3008:
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
3669: x_return_status := FND_API.G_RET_STS_ERROR;
3670: x_msg_count := 1;
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
3853: x_return_status := FND_API.G_RET_STS_ERROR;
3854: x_msg_count := 1;
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
4071: x_return_status := fnd_api.g_ret_sts_unexp_error;
4072: x_msg_count := 1;
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:
4076: ----------------------------------------------------
4077: --SManna(Jan'12). This procedure is not called from anywhere. Insert_into_repository does all the work.
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
4131: x_return_status := fnd_api.g_ret_sts_unexp_error;
4132: x_msg_count := 1;
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:
4136: ------>>>>>>>>>>>>>>>>>>>>>>>>>>
4137: --SManna(Jan'12). This procedure is not called from anywhere. Insert_into_repository does all the work.
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:
4182: ------>>>>>>>>>>>>>>>>>>>>>>>>>>>
4183: --SManna(Jan'12). This procedure is not called from anywhere. Insert_into_repository does all the work.
4472: WHEN OTHERS
4473: THEN
4474: EXECUTE IMMEDIATE 'BEGIN jdr_docbuilder.refresh; END;';
4475:
4476: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_JRAD_DOC_ERR', 'JRADDOC', p_old_document_name, 'SQLERRM', SQLERRM);
4477: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTOJRADREPOS', SQLCODE);
4478: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4479:
4480: RAISE;
4567: THEN
4568: NULL;
4569: WHEN OTHERS
4570: THEN
4571: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_pages', 'SQLERRM', SQLERRM);
4572: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGES', SQLCODE);
4573: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4574: RAISE;
4575: END bulk_collect_ui_pages;
4694: THEN
4695: NULL;
4696: WHEN OTHERS
4697: THEN
4698: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4699: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGESETS', SQLCODE);
4700: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4701: RAISE;
4702: END bulk_collect_page_sets;
4737: END IF;
4738: EXCEPTION
4739: WHEN OTHERS
4740: THEN
4741: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_sets', 'SQLERRM', SQLERRM);
4742: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGESETS', SQLCODE);
4743: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4744: RAISE;
4745: END insert_into_ui_page_sets;
4821: THEN
4822: NULL;
4823: WHEN OTHERS
4824: THEN
4825: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4826: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGEREFS', SQLCODE);
4827: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4828: RAISE;
4829: END bulk_collect_page_refs;
4894: END IF;
4895: EXCEPTION
4896: WHEN OTHERS
4897: THEN
4898: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_refs', 'SQLERRM', SQLERRM);
4899: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPAGEREFS', SQLCODE);
4900: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4901: RAISE;
4902: END insert_into_ui_page_refs;
4952: THEN
4953: NULL;
4954: WHEN OTHERS
4955: THEN
4956: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
4957: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIREFS', SQLCODE);
4958: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4959: RAISE;
4960: END bulk_collect_ui_refs;
5008: COMMIT;
5009: EXCEPTION
5010: WHEN OTHERS
5011: THEN
5012: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_refs', 'SQLERRM', SQLERRM);
5013: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIREFS', SQLCODE);
5014: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5015: RAISE;
5016: END;
5088: END IF;
5089: EXCEPTION
5090: WHEN OTHERS
5091: THEN
5092: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_ps_maps', 'SQLERRM', SQLERRM);
5093: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPSMAPS', SQLCODE);
5094: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5095: RAISE;
5096: END bulk_collect_ui_ps_maps;
5158: END IF;
5159: EXCEPTION
5160: WHEN OTHERS
5161: THEN
5162: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_page_elements', 'SQLERRM', SQLERRM);
5163: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UIPSMAPS', SQLCODE);
5164: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5165: RAISE;
5166: END insert_ui_ps_maps;
5278: )
5279: IS
5280: l_inst_str VARCHAR2(2000);
5281: l_uit_date DATE;
5282: l_applicable_from DATE := cz_utils.epoch_begin;
5283: l_applicable_until DATE := cz_utils.epoch_end;
5284: l_status NUMBER := 0;
5285: l_ref_cursor ref_cursor;
5286: l_src_pb_id cz_model_publications.publication_id%TYPE;
5279: IS
5280: l_inst_str VARCHAR2(2000);
5281: l_uit_date DATE;
5282: l_applicable_from DATE := cz_utils.epoch_begin;
5283: l_applicable_until DATE := cz_utils.epoch_end;
5284: l_status NUMBER := 0;
5285: l_ref_cursor ref_cursor;
5286: l_src_pb_id cz_model_publications.publication_id%TYPE;
5287: l_tgt_pb_id cz_model_publications.publication_id%TYPE;
5384: EXCEPTION
5385: WHEN OTHERS
5386: THEN
5387: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5388: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
5389: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
5390: RAISE;
5391: END create_uit_publication;
5392:
5774: THEN
5775: NULL;
5776: WHEN OTHERS
5777: THEN
5778: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_cont_templates', 'SQLERRM', SQLERRM);
5779: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UICONTTEMPLATES', SQLCODE);
5780: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5781: RAISE;
5782: END bulk_collect_cont_type_templs;
5857: THEN
5858: NULL;
5859: WHEN OTHERS
5860: THEN
5861: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
5862: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
5863: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5864: RAISE;
5865: END bulk_collect_ui_actions;
5911: THEN
5912: NULL;
5913: WHEN OTHERS
5914: THEN
5915: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_images', 'SQLERRM', SQLERRM);
5916: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIIMAGES', SQLCODE);
5917: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5918: RAISE;
5919: END bulk_collect_ui_images;
6601: COMMIT;
6602: EXCEPTION
6603: WHEN OTHERS
6604: THEN
6605: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXPORT_OA_UI_ERR', 'SQLERRM', SQLERRM);
6606: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_EXPORTOAUI', SQLCODE);
6607: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6608: RAISE;
6609: END export_oa_uis;
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
6733: x_return_status := FND_API.G_RET_STS_ERROR;
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
6738: x_return_status := FND_API.G_RET_STS_ERROR;
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
6743: x_return_status := FND_API.G_RET_STS_ERROR;
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:
6748: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6848: CLOSE db_compare_cur;
6849: EXCEPTION
6850: WHEN OTHERS
6851: THEN
6852: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SRC_TO_TRGT_LINK', 'SQLERRM', SQLERRM);
6853: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RETRIEVE_DB_LINK', SQLCODE);
6854: END;
6855:
6856: 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))
6854: END;
6855:
6856: 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))
6857: THEN
6858: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SRC_TO_TRGT_LINK', 'SQLERRM', SQLERRM);
6859: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RETRIEVE_DB_LINK', SQLCODE);
6860: cz_pb_mgr.v_status_code := 'ERR';
6861: END IF;
6862:
6926: END IF;
6927:
6928: EXCEPTION
6929: WHEN OTHERS THEN
6930: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', 'cz_devl_projects');
6931: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6932:
6933: END DeleteFromDevlProjects;
6934:
6964: END IF;
6965: COMMIT;
6966: EXCEPTION
6967: WHEN OTHERS THEN
6968: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
6969: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6970: END delete_from_table;
6971:
6972: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7003: EXECUTE IMMEDIATE v_DeleteString;
7004: END IF;
7005: EXCEPTION
7006: WHEN OTHERS THEN
7007: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
7008: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
7009: END;
7010: COMMIT;
7011: END;
7041: EXECUTE IMMEDIATE v_DeleteString;
7042: END IF;
7043: EXCEPTION
7044: WHEN OTHERS THEN
7045: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
7046: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
7047: END;
7048: COMMIT;
7049: END;
7085: EXECUTE IMMEDIATE v_DeleteString;
7086: END IF;
7087: EXCEPTION
7088: WHEN OTHERS THEN
7089: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', table_name);
7090: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
7091: END;
7092: COMMIT;
7093: END;
7251: WHERE publication_id = cz_pb_mgr.v_publication_id;
7252:
7253: COMMIT;
7254: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7255: 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);
7256: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:ROLLBACKDATA', SQLCODE);
7257: EXCEPTION
7258: WHEN OTHERS
7259: THEN
7257: EXCEPTION
7258: WHEN OTHERS
7259: THEN
7260: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7261: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_ROLLBACK_ERR', 'SQLERRM', SQLERRM);
7262: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ROLLBACK', SQLCODE);
7263: RAISE;
7264: END rollback_data;
7265:
7300: END IF;
7301: EXCEPTION
7302: WHEN OTHERS
7303: THEN
7304: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPDATE_ERR', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
7305: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UPDPBSTATUS', SQLCODE);
7306: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7307: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
7308: RAISE;
7405: RETURN v_count;
7406: EXCEPTION
7407: WHEN NO_DATA_FOUND
7408: THEN
7409: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_LINK_NAME');
7410: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.VALIDATE_SCHEMA', SQLCODE);
7411: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7412: RETURN v_count;
7413: WHEN OTHERS
7411: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7412: RETURN v_count;
7413: WHEN OTHERS
7414: THEN
7415: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SCHEMA_VALIDATION_ERR');
7416: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.VALIDATE_SCHEMA', SQLCODE);
7417: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7418: RETURN v_count;
7419: END validate_schema;
7437: cz_pb_mgr.v_err_message := 'No model usages found';
7438: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7439: WHEN OTHERS
7440: THEN
7441: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
7442: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7443: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7444: RAISE;
7445: END;
7485: cz_pb_mgr.v_err_message := 'No model usages translations found';
7486: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7487: WHEN OTHERS
7488: THEN
7489: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);
7490: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7491: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7492: RAISE;
7493: END;
7529: EXCEPTION
7530: WHEN OTHERS
7531: THEN
7532: ROLLBACK;
7533: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
7534: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USAGES', SQLCODE);
7535: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7536: RAISE;
7537: END load_usages;
7657: AND t.expr_type <> 208;
7658: EXCEPTION
7659: WHEN OTHERS
7660: THEN
7661: x_expr_node_date := cz_utils.epoch_begin;
7662: END get_max_expr_date;
7663:
7664: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7665: -----procedure that retrieves the last_struct_update date
7673: WHERE t.deleted_flag = record_not_deleted AND t.devl_project_id = p_model_id;
7674: EXCEPTION
7675: WHEN OTHERS
7676: THEN
7677: x_last_struct_date := cz_utils.epoch_begin;
7678: END get_last_struct_date;
7679:
7680: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7681: -----procedure that returns the source ui_defs for export
7921: FROM cz_ui_page_elements
7922: WHERE cz_ui_page_elements.ui_def_id = p_ui_def_id
7923: ORDER BY last_update_date DESC;
7924: BEGIN
7925: v_initialized_date := cz_utils.epoch_begin;
7926: v_ui_def_id_date := v_initialized_date;
7927: v_ui_node_id_date := v_initialized_date;
7928: v_ui_props_date := v_initialized_date;
7929: v_ui_node_props_date := v_initialized_date;
7953: CLOSE ui_def_cur;
7954: EXCEPTION
7955: WHEN OTHERS
7956: THEN
7957: v_ui_def_id_date := cz_utils.epoch_begin;
7958:
7959: CLOSE ui_def_cur;
7960: END;
7961:
7973: CLOSE ui_nodes_cur;
7974: EXCEPTION
7975: WHEN OTHERS
7976: THEN
7977: v_ui_node_id_date := cz_utils.epoch_begin;
7978:
7979: CLOSE ui_nodes_cur;
7980: END;
7981:
7993: CLOSE ui_properties_cur;
7994: EXCEPTION
7995: WHEN OTHERS
7996: THEN
7997: v_ui_props_date := cz_utils.epoch_begin;
7998:
7999: CLOSE ui_properties_cur;
8000: END;
8001:
8013: CLOSE ui_node_props_cur;
8014: EXCEPTION
8015: WHEN OTHERS
8016: THEN
8017: v_ui_node_props_date := cz_utils.epoch_begin;
8018:
8019: CLOSE ui_node_props_cur;
8020: END;
8021:
8033: CLOSE ui_intl_texts_cur;
8034: EXCEPTION
8035: WHEN OTHERS
8036: THEN
8037: v_ui_node_intl_date := cz_utils.epoch_begin;
8038:
8039: CLOSE ui_intl_texts_cur;
8040: END;
8041:
8053: CLOSE ui_pages_cur;
8054: EXCEPTION
8055: WHEN OTHERS
8056: THEN
8057: v_ui_pages_date := cz_utils.epoch_begin;
8058:
8059: CLOSE ui_pages_cur;
8060: END;
8061:
8073: CLOSE ui_pages_capt_cur;
8074: EXCEPTION
8075: WHEN OTHERS
8076: THEN
8077: v_ui_pages_capt_date := cz_utils.epoch_begin;
8078:
8079: CLOSE ui_pages_capt_cur;
8080: END;
8081:
8093: CLOSE ui_page_sets_cur;
8094: EXCEPTION
8095: WHEN OTHERS
8096: THEN
8097: v_ui_page_sets_date := cz_utils.epoch_begin;
8098:
8099: CLOSE ui_page_sets_cur;
8100: END;
8101:
8113: CLOSE ui_page_refs_cur;
8114: EXCEPTION
8115: WHEN OTHERS
8116: THEN
8117: v_ui_page_refs_date := cz_utils.epoch_begin;
8118:
8119: CLOSE ui_page_refs_cur;
8120: END;
8121:
8133: CLOSE ui_page_refs_capt_cur;
8134: EXCEPTION
8135: WHEN OTHERS
8136: THEN
8137: v_ui_pg_ref_capt_date := cz_utils.epoch_begin;
8138:
8139: CLOSE ui_page_refs_capt_cur;
8140: END;
8141:
8153: CLOSE ui_refs_cur;
8154: EXCEPTION
8155: WHEN OTHERS
8156: THEN
8157: v_ui_refs_date := cz_utils.epoch_begin;
8158:
8159: CLOSE ui_refs_cur;
8160: END;
8161:
8173: CLOSE ui_templs_cur;
8174: EXCEPTION
8175: WHEN OTHERS
8176: THEN
8177: v_ui_templs_date := cz_utils.epoch_begin;
8178:
8179: CLOSE ui_templs_cur;
8180: END;
8181:
8193: CLOSE ui_cont_templs_cur;
8194: EXCEPTION
8195: WHEN OTHERS
8196: THEN
8197: v_ui_cont_templs_date := cz_utils.epoch_begin;
8198:
8199: CLOSE ui_cont_templs_cur;
8200: END;
8201:
8213: CLOSE ui_actions_cur;
8214: EXCEPTION
8215: WHEN OTHERS
8216: THEN
8217: v_ui_actions_date := cz_utils.epoch_begin;
8218:
8219: CLOSE ui_actions_cur;
8220: END;
8221:
8233: CLOSE ui_images_cur;
8234: EXCEPTION
8235: WHEN OTHERS
8236: THEN
8237: v_ui_images_date := cz_utils.epoch_begin;
8238:
8239: CLOSE ui_images_cur;
8240: END;
8241:
8253: CLOSE ui_page_elements;
8254: EXCEPTION
8255: WHEN OTHERS
8256: THEN
8257: v_page_elements_date := cz_utils.epoch_begin;
8258: CLOSE ui_page_elements;
8259: END;
8260: BEGIN
8261: SELECT MAX(GREATEST(v_ui_def_id_date
8281: FROM DUAL;
8282: EXCEPTION
8283: WHEN OTHERS
8284: THEN
8285: x_max_update_date := cz_utils.epoch_begin;
8286: END;
8287: EXCEPTION
8288: WHEN OTHERS
8289: THEN
8438: v_update_date cz_func_comp_specs.last_update_date%TYPE;
8439: BEGIN
8440: IF (p_model_array.COUNT > 0)
8441: THEN
8442: x_max_update_date := cz_utils.epoch_begin;
8443:
8444: FOR i IN p_model_array.FIRST .. p_model_array.LAST
8445: LOOP
8446: BEGIN
8475: FROM cz_ps_nodes
8476: WHERE devl_project_id = p_model_id;
8477: EXCEPTION
8478: WHEN OTHERS THEN
8479: x_last_update_date := cz_utils.epoch_begin;
8480: END;
8481:
8482: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8483: ------procedure that retrieves the max last update date
8491: WHERE model_id = p_model_id;
8492: EXCEPTION
8493: WHEN OTHERS
8494: THEN
8495: x_last_update_date := cz_utils.epoch_begin;
8496: END;
8497:
8498: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8499: PROCEDURE get_max_template_date(p_template_id IN NUMBER, x_max_date OUT NOCOPY DATE)
8505: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;
8506: EXCEPTION
8507: WHEN OTHERS
8508: THEN
8509: x_max_date := cz_utils.epoch_begin;
8510: END get_max_template_date;
8511:
8512: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8513: PROCEDURE get_template_date(p_global_templs_ref IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
8512: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8513: PROCEDURE get_template_date(p_global_templs_ref IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
8514: IS
8515: l_last_update_date DATE;
8516: l_prev_date DATE := cz_utils.epoch_begin;
8517: BEGIN
8518: x_max_update_date := cz_utils.epoch_begin;
8519:
8520: IF (p_global_templs_ref.COUNT > 0)
8514: IS
8515: l_last_update_date DATE;
8516: l_prev_date DATE := cz_utils.epoch_begin;
8517: BEGIN
8518: x_max_update_date := cz_utils.epoch_begin;
8519:
8520: IF (p_global_templs_ref.COUNT > 0)
8521: THEN
8522: FOR i IN p_global_templs_ref.FIRST .. p_global_templs_ref.LAST
8538: END IF;
8539: EXCEPTION
8540: WHEN NO_DATA_FOUND
8541: THEN
8542: x_max_update_date := cz_utils.epoch_begin;
8543: END get_template_date;
8544:
8545: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8546: 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)
8545: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8546: 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)
8547: IS
8548: l_last_update_date DATE;
8549: l_prev_date DATE := cz_utils.epoch_begin;
8550: rec_count NUMBER := 0;
8551: l_pub_mode cz_model_publications.publication_mode%TYPE := cz_model_migration_pvt.mode_publication;
8552: BEGIN
8553: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model)
8557: THEN
8558: l_pub_mode := cz_model_migration_pvt.mode_copy;
8559: END IF;
8560:
8561: x_last_xfr_activity := cz_utils.epoch_begin;
8562:
8563: IF (p_global_templs_ref.COUNT > 0)
8564: THEN
8565: FOR i IN p_global_templs_ref.FIRST .. p_global_templs_ref.LAST
8587: END IF;
8588: EXCEPTION
8589: WHEN OTHERS
8590: THEN
8591: x_last_xfr_activity := cz_utils.epoch_begin;
8592: END get_last_templ_activity;
8593:
8594: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8595: PROCEDURE get_effectivity_set_date(p_model_id IN NUMBER, x_last_update_date OUT NOCOPY DATE)
8606: AND cz_ps_nodes.effectivity_set_id IS NOT NULL);
8607: EXCEPTION
8608: WHEN NO_DATA_FOUND
8609: THEN
8610: x_last_update_date := cz_utils.epoch_begin;
8611: END get_effectivity_set_date;
8612:
8613: --------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8614: ------get last update date for effectivity
8617: v_update_date cz_effectivity_sets.last_update_date%TYPE;
8618: BEGIN
8619: IF (p_model_array.COUNT > 0)
8620: THEN
8621: x_max_update_date := cz_utils.epoch_begin;
8622:
8623: FOR i IN p_model_array.FIRST .. p_model_array.LAST
8624: LOOP
8625: get_effectivity_set_date(p_model_array(i), v_update_date);
8750: EXCEPTION
8751: WHEN NO_DATA_FOUND THEN
8752: NULL;
8753: WHEN OTHERS THEN
8754: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
8755: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
8756: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8757: RAISE;
8758: END collect_global_actions;
8789: END IF;
8790: EXCEPTION
8791: WHEN OTHERS
8792: THEN
8793: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_COLLECT_GL_TEXTS', 'SQLERRM', SQLERRM);
8794: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_GLTEXTS', SQLCODE);
8795: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8796: RAISE;
8797: END collect_global_texts;
8874: END IF;
8875: END LOOP;
8876: EXCEPTION
8877: WHEN OTHERS THEN
8878: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
8879: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
8880: x_status := PUBLICATION_ERROR;
8881: RAISE;
8882: END collect_global_rules;
8962: THEN
8963: NULL;
8964: WHEN OTHERS
8965: THEN
8966: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_template_elements', 'SQLERRM', SQLERRM);
8967: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_TMPLELEM', SQLCODE);
8968: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8969: RAISE;
8970: END collect_template_elements;
9269: IF l_template_name IS NOT NULL AND
9270: ( l_parent_container_type <> j.parent_container_type
9271: OR l_root_region_type <> j.root_region_type
9272: OR l_root_element_signature_id <> j.root_element_signature_id ) THEN
9273: cz_pb_mgr.v_err_message := cz_utils.get_text('UCT synch error', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
9274: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
9275: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9276: RAISE document_synch;
9277: END IF;
9364: END IF;
9365:
9366: EXCEPTION
9367: WHEN OTHERS THEN
9368: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
9369: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
9370: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9371: RAISE;
9372: END get_oa_tmpls;
9464: WHERE model_id = v_models_tbl(i);
9465: EXCEPTION
9466: WHEN OTHERS
9467: THEN
9468: l_capt_update_date := cz_utils.epoch_begin;
9469: END;
9470:
9471: IF ((v_last_xfr_activity IS NOT NULL) AND(v_last_xfr_activity < l_capt_update_date))
9472: THEN
9478:
9479: -----check if capt rules have changed
9480: IF (v_models_tbl.COUNT > 0)
9481: THEN
9482: l_capt_update_date := cz_utils.epoch_begin;
9483:
9484: FOR i IN v_models_tbl.FIRST .. v_models_tbl.LAST
9485: LOOP
9486: BEGIN
9490: WHERE devl_project_id = v_models_tbl(i);
9491: EXCEPTION
9492: WHEN OTHERS
9493: THEN
9494: l_capt_update_date := cz_utils.epoch_begin;
9495: END;
9496:
9497: IF ((v_last_xfr_activity IS NOT NULL) AND(v_last_xfr_activity < l_capt_update_date))
9498: THEN
9505: -----check if template elements have changed
9506: -- but actually these templs are new or changed ones!
9507: IF (cz_pb_mgr.g_ui_templates_old_temp_id_ref.COUNT > 0)
9508: THEN
9509: l_capt_update_date := cz_utils.epoch_begin;
9510:
9511: 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
9512: LOOP
9513: BEGIN
9517: WHERE template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i);
9518: EXCEPTION
9519: WHEN OTHERS
9520: THEN
9521: l_capt_update_date := cz_utils.epoch_begin;
9522: END;
9523:
9524: IF ((v_last_xfr_activity IS NOT NULL) AND(v_last_xfr_activity < l_capt_update_date))
9525: THEN
9598: END IF;
9599: EXCEPTION
9600: WHEN OTHERS
9601: THEN
9602: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_MODEL_TO_PUBLISH_ERR', 'SQLERRM', SQLERRM);
9603: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.HAS_TOBE_PUBLISHED', SQLCODE);
9604: cz_pb_mgr.v_err_message := LTRIM(RTRIM(SUBSTR(cz_pb_mgr.v_err_message, 1, 2000)));
9605: RAISE;
9606: END has_tobe_published;
9999: AND t.expr_type <> 208;
10000:
10001: IF (v_expr_last_update IS NULL)
10002: THEN
10003: v_expr_last_update := cz_utils.epoch_begin;
10004: END IF;
10005:
10006: -----effectivitity set check
10007: get_effectivity_set_date(v_model_id, l_eff_set_date);
10223: COMMIT;
10224: EXCEPTION
10225: WHEN OTHERS
10226: THEN
10227: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXP_REQUEST_ERR', 'MODELID', modelid);
10228: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CREATE_EXPORT_REQUEST', SQLCODE);
10229: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10230: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10231: RAISE;
10286: CLOSE remote_pb_cv;
10287:
10288: IF (v_publication_id = 0)
10289: THEN
10290: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REMOTE_ERR', 'PUBID', p_publication_id);
10291: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REMOTEPBCHECKID', SQLCODE);
10292: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10293: END IF;
10294: END IF;
10297: WHEN OTHERS
10298: THEN
10299: CLOSE remote_pb_cv;
10300:
10301: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REMOTE_ERR', 'SQLERRM', SQLERRM);
10302: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REMOTEPBCHECKID', SQLCODE);
10303: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10304: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10305: RAISE;
10362: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
10363: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EFFSETS', SQLCODE);
10364: WHEN OTHERS
10365: THEN
10366: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_effectivity_sets', 'SQLERRM', SQLERRM);
10367: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTEFFSETS', SQLCODE);
10368: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10369: END;
10370:
10524: WHERE cz_servers.server_local_id = p_server_id;
10525: EXCEPTION
10526: WHEN NO_DATA_FOUND
10527: THEN
10528: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_NO_SERVER_NAME_FOUND', 'SERVERID', p_server_id);
10529: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
10530: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10531: WHEN OTHERS
10532: THEN
10529: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
10530: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10531: WHEN OTHERS
10532: THEN
10533: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_SERVER_NAME_ERR', 'SERVERID', p_server_id);
10534: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
10535: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10536: END;
10537:
10552: THEN
10553: v_model_name := 'Model name not found for model_id: ' || cz_pb_mgr.v_root_model_id;
10554: END;
10555:
10556: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_BOMSYNCH_VERIFY_ERR', 'MODELNAME', v_model_name);
10557: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROC', SQLCODE);
10558:
10559: ----trap errors from verify model to populate cz_db_logs
10560: BEGIN
10607: END IF;
10608: EXCEPTION
10609: WHEN OTHERS
10610: THEN
10611: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_BOMSYNCH_PROC_ERR', 'SQLERRM', SQLERRM);
10612: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROCEDURE', SQLCODE);
10613: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10614: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10615: RAISE;
10635: END IF;
10636: EXCEPTION
10637: WHEN OTHERS
10638: THEN
10639: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_GET_SYNC_ERR', 'SQLERRM', SQLERRM);
10640: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.GETSYNCVALUES', SQLCODE);
10641: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10642: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10643: RAISE;
10911: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
10912: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10913: WHEN OTHERS
10914: THEN
10915: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
10916: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10917: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10918: END;
10919:
11049: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11050: RAISE;
11051: WHEN OTHERS
11052: THEN
11053: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
11054: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.COPYLCEHDRS', SQLCODE);
11055: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11056: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11057: RAISE;
11134: ORDER BY lce_header_id, seq_nbr;
11135: EXCEPTION
11136: WHEN NO_DATA_FOUND
11137: THEN
11138: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
11139: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11140: WHEN OTHERS
11141: THEN
11142: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
11138: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
11139: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11140: WHEN OTHERS
11141: THEN
11142: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
11143: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11144: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11145: END;
11146:
11245: EXCEPTION
11246: WHEN OTHERS
11247: THEN
11248: ROLLBACK;
11249: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
11250: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCETEXTS', SQLCODE);
11251: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11252: END;
11253: END LOOP;
11264: END IF; /* end if of cz_pb_mgr.v_status_code <> PUBLICATION_ERROR */
11265: EXCEPTION
11266: WHEN OTHERS
11267: THEN
11268: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_texts', 'SQLERRM', SQLERRM);
11269: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.COPYLCETEXTS', SQLCODE);
11270: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11271: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11272: RAISE;
11290: ORDER BY UPPER(language_code);
11291: EXCEPTION
11292: WHEN OTHERS
11293: THEN
11294: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_LANG');
11295: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
11296: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11297: cz_pb_mgr.global_export_retcode := 2;
11298: END;
11320: END LOOP;
11321: EXCEPTION
11322: WHEN OTHERS
11323: THEN
11324: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_LANG');
11325: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
11326: cz_pb_mgr.v_status_code := 'ERR';
11327: cz_pb_mgr.global_export_retcode := 2;
11328: END;
11335: FOR l IN cz_pb_mgr.v_src_lang_code_tbl.FIRST .. cz_pb_mgr.v_src_lang_code_tbl.LAST
11336: LOOP
11337: IF (cz_pb_mgr.v_src_lang_code_tbl(l) <> cz_pb_mgr.v_tgt_lang_code_tbl(l))
11338: THEN
11339: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_SRC_TGT_LANG', 'LANGUAGE', cz_pb_mgr.v_tgt_lang_code_tbl(l));
11340: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
11341: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11342: cz_pb_mgr.global_export_retcode := 2;
11343: END IF;
11342: cz_pb_mgr.global_export_retcode := 2;
11343: END IF;
11344: END LOOP;
11345: ELSE
11346: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_LANG');
11347: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SRCLANG', SQLCODE);
11348: cz_pb_mgr.v_status_code := 'ERR';
11349: cz_pb_mgr.global_export_retcode := 2;
11350: END IF;
11822: END IF;
11823: EXCEPTION
11824: WHEN OTHERS
11825: THEN
11826: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REF_ID_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
11827: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
11828: x_status := PUBLICATION_ERROR;
11829: RAISE;
11830: END;
12486: COMMIT;
12487: EXCEPTION
12488: WHEN OTHERS
12489: THEN
12490: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12491: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
12492: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12493: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
12494: RAISE;
12644:
12645: COMMIT;
12646: EXCEPTION
12647: WHEN REMOTE_EXCEPTION THEN
12648: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'remote_cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12649: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12650: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12651: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12652: WHEN OTHERS THEN
12649: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12650: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12651: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12652: WHEN OTHERS THEN
12653: CZ_PB_MGR.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'local_cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12654: CZ_PB_MGR.error_msg_populate(CZ_PB_MGR.v_err_message ,'CZ_PB_MGR.LOAD_DATA:cz_ps_prop_vals',SQLCODE);
12655: CZ_PB_MGR.v_status_code := PUBLICATION_ERROR;
12656: CZ_PB_MGR.v_sql_err_msg := substr(SQLERRM,1,2000);
12657: RAISE;
12718: END LOOP;
12719: COMMIT;
12720: EXCEPTION
12721: WHEN OTHERS THEN
12722: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
12723: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
12724: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12725: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
12726: RAISE;
12787: COMMIT;
12788: EXCEPTION
12789: WHEN OTHERS
12790: THEN
12791: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
12792: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);
12793: x_status := PUBLICATION_ERROR;
12794: RAISE;
12795: END;
12866: COMMIT;
12867: EXCEPTION
12868: WHEN OTHERS
12869: THEN
12870: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
12871: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);
12872: x_status := PUBLICATION_ERROR;
12873: RAISE;
12874: END;
12919: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
12920: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FUNCCOMP', SQLCODE);
12921: WHEN OTHERS
12922: THEN
12923: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_func_comp_specs', 'SQLERRM', SQLERRM);
12924: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
12925: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12926: RAISE;
12927: END;
13182: END LOOP;
13183: END IF;
13184: EXCEPTION
13185: WHEN OTHERS THEN
13186: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rules', 'SQLERRM', SQLERRM);
13187: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_RULES', SQLCODE);
13188: x_status := PUBLICATION_ERROR;
13189: RAISE;
13190: END bulk_collect_rules;
13267: END IF;
13268: EXCEPTION
13269: WHEN OTHERS
13270: THEN
13271: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_DATA_FOUND', 'TABLENAME', 'cz_model_publications', 'SQLERRM', SQLERRM);
13272: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:UIDEFID', SQLCODE);
13273: x_status := PUBLICATION_ERROR;
13274: RAISE;
13275: END get_new_ui_def_id;
13961: COMMIT;
13962: EXCEPTION
13963: WHEN OTHERS
13964: THEN
13965: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_devl_projects', 'SQLERRM', SQLERRM);
13966: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
13967: x_status := PUBLICATION_ERROR;
13968: RAISE;
13969: END insert_devl_projects;
13979: WHERE cz_db_settings.setting_id = sequence_incr_str;
13980: EXCEPTION
13981: WHEN OTHERS
13982: THEN
13983: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_INCR');
13984: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SEQINCR', SQLCODE);
13985: x_oraclesequenceincr := 20;
13986: END;
13987:
14366: THEN
14367: --Raise migration failure.
14368: --Proposed: Usage Limit maxed out during the migration process.
14369: cz_pb_mgr.v_err_message :=
14370: cz_utils.get_text('CZDEV_MAX_USAGES_CREATED_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
14371: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.resolve_effective_usage_mask', SQLCODE);
14372: cz_pb_mgr.v_status_code := 0; -- MIGRATION_ERROR;
14373: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
14374: RAISE NO_DATA_FOUND;
14759: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
14760: EXCEPTION
14761: WHEN OTHERS
14762: THEN
14763: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_ref_expls', 'SQLERRM', SQLERRM);
14764: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14765: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14766: RAISE;
14767: END;
15034: COMMIT;
15035: EXCEPTION
15036: WHEN OTHERS
15037: THEN
15038: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_ui_node_props', 'ERR', SQLERRM);
15039: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.NODEPROPS', SQLCODE);
15040: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15041: END insert_ui_node_props;
15042:
15335: END IF;
15336: EXCEPTION
15337: WHEN OTHERS
15338: THEN
15339: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_defs', 'SQLERRM', SQLERRM);
15340: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
15341: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15342: RAISE;
15343: END;
15523: cz_pb_mgr.v_err_message := 'No ui nodes found for : ' || TO_CHAR(cz_pb_mgr.v_cz_ui_defs_old_ref(i));
15524: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.UINODES', SQLCODE);
15525: WHEN OTHERS
15526: THEN
15527: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_nodes', 'SQLERRM', SQLERRM);
15528: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
15529: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15530: RAISE;
15531: END;
16252: END IF;
16253: EXCEPTION
16254: WHEN OTHERS
16255: THEN
16256: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_archive_refs', 'SQLERRM', SQLERRM);
16257: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ARCHIVES', SQLCODE);
16258: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16259: RAISE;
16260: END bulk_collect_archives;
16388: THEN
16389: NULL;
16390: WHEN OTHERS
16391: THEN
16392: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_filter_sets', 'SQLERRM', SQLERRM);
16393: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FILTERSETS', SQLCODE);
16394: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16395: RAISE;
16396: END;
16440: THEN
16441: NULL;
16442: WHEN OTHERS
16443: THEN
16444: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
16445: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
16446: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16447: RAISE;
16448: END;
16525: END IF;
16526: EXCEPTION
16527: WHEN OTHERS
16528: THEN
16529: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_populators', 'SQLERRM', SQLERRM);
16530: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.POPULATORS', SQLCODE);
16531: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16532: RAISE;
16533: END export_populators;
16574: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16575: FOR j IN (SELECT rule.name rulename, prj.name prjname
16576: FROM cz_rules rule, cz_devl_projects prj
16577: WHERE rule.rule_id=p_ruleid_tbl(i) AND rule.devl_project_id=prj.devl_project_id) LOOP
16578: 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);
16579: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'upload_rule_schema.mm_resolve_rule_fks', SQLCODE);
16580: END LOOP;
16581: RAISE;
16582: END;
16672: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
16673: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
16674: WHEN OTHERS
16675: THEN
16676: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_rule_folders', 'SQLERRM', SQLERRM);
16677: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RULEFOLDERS', SQLCODE);
16678: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16679: RAISE;
16680: END;
16926: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
16927: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
16928: WHEN OTHERS
16929: THEN
16930: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_expression_nodes', 'SQLERRM', SQLERRM);
16931: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
16932: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16933: RAISE;
16934: END;
17070: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
17071: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
17072: WHEN OTHERS
17073: THEN
17074: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
17075: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
17076: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17077: RAISE;
17078: END;
17139: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
17140: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
17141: WHEN OTHERS
17142: THEN
17143: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
17144: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
17145: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17146: RAISE;
17147: END;
17241:
17242: IF (v_null <> v_property_record_ref(v_remote_prop_ref(i)).data_type)
17243: THEN
17244: --~> 'Property ''%PROPERTYNAME'' has a different data type on the target instance.'
17245: 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);
17246: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
17247: v_error_flag := 1;
17248: END IF;
17249: EXCEPTION
17297: WHEN NO_DATA_FOUND
17298: THEN
17299: v_error_flag := 1;
17300: --~> 'Item type ''%ITEMTYPENAME'' has a different combination of properties on the target instance.'
17301: 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);
17302: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
17303: END;
17304:
17305: j := v_type_property_record_ref(v_item_types_new_ref(i)).NEXT(j);
17383: , mm_v_itmst_src_app_id_ref(i)
17384: --IMPORTANT: this is bom-synchronized (if necessary) orig_sys_ref, hashed by
17385: --source item_id
17386: , NVL(mm_v_ht_items_orig_ref(v_item_masters_tbl(i)), '0');
17387: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_UPVAL_ITEM', 'ITEMNAME', mm_v_itmst_ref_part_nbr_ref(i),
17388: 'SRCNAME', v_type_record_ref(v_item_types_tbl(i)).NAME,
17389: 'TGTNAME', v_target_item_type_name);
17390: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
17391: END;
17402: RAISE;
17403: WHEN OTHERS
17404: THEN
17405: --~>'Unexpected error during upfront validation: %ERRORTEXT'
17406: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MM_UPVAL_UNEXPECTED', 'ERRORTEXT', SQLERRM);
17407: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
17408: RAISE;
17409: END mm_raiseallpossiblesyncerrors;
17410: ------------------------------------------------------------------------------------------------
17740: THEN
17741: NULL;
17742: WHEN OTHERS
17743: THEN
17744: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_item_type_properties', 'SQLERRM', SQLERRM);
17745: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ITEMTYPE', SQLCODE);
17746: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17747: END;
17748:
17982: EXCEPTION
17983: WHEN cz_pb_global_synch
17984: THEN
17985: --~> 'Errors in upfront validation, unable to continue.'
17986: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_UPVAL_ERRORS');
17987: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'Upfront Validation', 70000);
17988: x_status_code := PUBLICATION_ERROR;
17989: WHEN pb_upload_ps_schema
17990: THEN
18391: END IF;
18392: ELSE
18393: IF (v_validate_count <> 1)
18394: THEN
18395: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SCHEMA_COMPAT_ERR');
18396: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:VALSCH', SQLCODE);
18397: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18398: ELSE
18399: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18451: clear_all_tables(cz_pb_mgr.v_status_code);
18452: EXCEPTION
18453: WHEN OTHERS
18454: THEN
18455: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXPORT_FAILURE', 'SQLERRM', SQLERRM);
18456: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPORT_FAILURE', SQLCODE);
18457: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18458: RAISE;
18459: END proc_export;
18528: ELSIF l_ui_style = g_ui_style_custom THEN
18529: RETURN;
18530: ELSE
18531: x_return_status := 2;
18532: x_msg_data := cz_utils.get_text('CZ_UI_STYLE_ERR');
18533: RETURN;
18534: END IF;
18535: END IF;
18536:
18665: FROM DUAL;
18666: EXCEPTION
18667: WHEN OTHERS
18668: THEN
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);
18752: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';
18753: EXCEPTION
18754: WHEN OTHERS
18755: THEN
18756: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL');
18757: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
18758: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18759: END;
18760:
18770: WHERE cz_ui_defs.ui_def_id = cz_pb_mgr.v_root_ui_def_id AND cz_ui_defs.deleted_flag = '0';
18771: EXCEPTION
18772: WHEN OTHERS
18773: THEN
18774: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI');
18775: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18776: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18777: END;
18778: END IF;
18804: ,x_model_name => l_model_name
18805: ,p_check_root_ui_only=> TRUE
18806: );
18807: IF l_ui_upto_date_status IS NOT NULL AND l_ui_upto_date_status <> 0 THEN
18808: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', 'UI' ||
18809: ' ''' || l_ui_name || '''', 'MODELID', '''' || l_model_name || '''');
18810: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', -20001);
18811: IF l_ui_style_tbl(i) = oa_ui_style THEN
18812: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18843: END IF;
18844:
18845: IF (v_model_chk_count = 0)
18846: THEN
18847: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL');
18848: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18849: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18850: ELSIF(v_ui_chk_count = 0)
18851: THEN
18848: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18849: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18850: ELSIF(v_ui_chk_count = 0)
18851: THEN
18852: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI');
18853: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18854: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18855: ELSE
18856: -----------create a dummy publication
18904: COMMIT;
18905: EXCEPTION
18906: WHEN OTHERS
18907: THEN
18908: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EXPORT_FAILURE', 'SQLERRM', SQLERRM);
18909: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18910: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18911: END;
18912:
19369: EXCEPTION
19370: WHEN OTHERS
19371: THEN
19372:
19373: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_GEN_ERROR', 'TOBEPUBLISHED', v_tobepublished, 'SQLERRM', SQLERRM);
19374: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISH_ALL_MODELS', SQLCODE);
19375: END publish_all_models;
19376:
19377: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19451: END;
19452: EXCEPTION
19453: WHEN run_id_error
19454: THEN
19455: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');
19456: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.XFRINFO', SQLCODE);
19457: WHEN OTHERS
19458: THEN
19459: RAISE;
19473: AND ROWNUM < 2;
19474: EXCEPTION
19475: WHEN NO_DATA_FOUND
19476: THEN
19477: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_GLOBAL_TMPL', 'PUBID', cz_pb_mgr.v_publication_id);
19478: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
19479: x_status := PUBLICATION_ERROR;
19480: END check_ui_template_exist;
19481:
19503: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;
19504:
19505: IF (v_model_chk_count = 0)
19506: THEN
19507: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL', 'PUBID', p_publication_id);
19508: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
19509: x_status := PUBLICATION_ERROR;
19510: END IF;
19511:
19519: WHERE cz_ui_defs.ui_def_id = p_ui_def_id AND cz_ui_defs.deleted_flag = record_not_deleted;
19520:
19521: IF (v_ui_chk_count = 0)
19522: THEN
19523: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_UI', 'PUBID', p_publication_id);
19524: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
19525: x_status := PUBLICATION_ERROR;
19526: END IF;
19527: END IF;
19618: THEN
19619: IF ((p_export_status = 'PUP') OR(p_export_status = 'ERR') OR(p_export_status = 'PRC') OR(p_export_status = 'OK'))
19620: THEN
19621: cz_pb_mgr.v_err_message :=
19622: cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', cz_pb_mgr.v_publication_id, 'SQLERRM', 'Export status check failed');
19623: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
19624: cz_pb_mgr.v_err_message := 'Publication with a status PRC/PUP/ERR may not be published';
19625: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISHMODEL', SQLCODE);
19626: x_status := PUBLICATION_ERROR;
19630: IF (p_export_status <> 'OK')
19631: THEN
19632: x_status := PUBLICATION_ERROR;
19633: cz_pb_mgr.v_err_message :=
19634: cz_utils.get_text('CZ_REPUB_STATUS_CHK', 'PUBID', cz_pb_mgr.v_publication_id, 'SQLERRM', 'Export status check failed');
19635: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISHMODEL', SQLCODE);
19636: END IF;
19637: END IF;
19638: END IF;
19864: END IF;
19865:
19866: IF NOT l_ui_upto_date AND l_model_upto_date THEN -- l_status = 2
19867: status :=
19868: cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', CZ_UTILS.GET_TEXT('CZ_UI_TEXT') || ' ''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
19869: ELSIF l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 1
19870: status := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', CZ_UTILS.GET_TEXT('CZ_LOGIC_TEXT') , 'MODELID', '''' || l_model_name || '''');
19871: ELSIF NOT l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 3
19872: status :=
19866: IF NOT l_ui_upto_date AND l_model_upto_date THEN -- l_status = 2
19867: status :=
19868: cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', CZ_UTILS.GET_TEXT('CZ_UI_TEXT') || ' ''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
19869: ELSIF l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 1
19870: status := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', CZ_UTILS.GET_TEXT('CZ_LOGIC_TEXT') , 'MODELID', '''' || l_model_name || '''');
19871: ELSIF NOT l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 3
19872: status :=
19873: cz_utils.get_text('CZ_PB_UI_LOGIC_NOT_UP_TO_DATE', 'STRING', '''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
19874: ELSE
19869: ELSIF l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 1
19870: status := cz_utils.get_text('CZ_PB_MODEL_NOT_UP_TO_DATE', 'STRING', CZ_UTILS.GET_TEXT('CZ_LOGIC_TEXT') , 'MODELID', '''' || l_model_name || '''');
19871: ELSIF NOT l_ui_upto_date AND NOT l_model_upto_date THEN -- l_status = 3
19872: status :=
19873: cz_utils.get_text('CZ_PB_UI_LOGIC_NOT_UP_TO_DATE', 'STRING', '''' || l_ui_name || '''', 'MODELID', '''' || l_ui_model_name || '''');
19874: ELSE
19875: status := '0';
19876: END IF;
19877: EXCEPTION
19968: END IF;
19969: EXCEPTION
19970: WHEN OTHERS
19971: THEN
19972: log_report('cz_utils', 'migrate_name', 1, SQLERRM, fnd_log.level_unexpected);
19973: v_name := 'ERROR';
19974: RETURN v_name;
19975: END;
19976:
20036: log_timing_message('After get_multi_server_pub_flg: Multi Server Pub Flag is : '||vMultiServerPub);
20037: END IF;
20038:
20039: IF (fnd_global.user_name IS NULL) THEN
20040: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', 'User is not initialized on session');
20041: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CHECKUSER', 21002);
20042: RAISE user_not_initialized;
20043: END IF;
20044:
20083: IF l_proc_name = l_publication_proc THEN
20084: -- bug #10417318
20085: IF (vMultiServerPub = 'YES') THEN
20086: SELECT instance_name INTO l_instance_nm FROM CZ_SERVERS WHERE server_local_id = cz_pb_mgr.v_server_id;
20087: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PARALLEL_PROCESS_EXISTS', 'PROC_TYPE', 'publication', 'TGT_NAME', l_instance_nm );
20088: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 1;
20089: ELSE
20090: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');
20091: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20086: SELECT instance_name INTO l_instance_nm FROM CZ_SERVERS WHERE server_local_id = cz_pb_mgr.v_server_id;
20087: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PARALLEL_PROCESS_EXISTS', 'PROC_TYPE', 'publication', 'TGT_NAME', l_instance_nm );
20088: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 1;
20089: ELSE
20090: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');
20091: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20092: END IF;
20093: ELSIF l_proc_name = l_migration_proc THEN
20094: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'model migration');
20090: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'publication');
20091: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20092: END IF;
20093: ELSIF l_proc_name = l_migration_proc THEN
20094: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'model migration');
20095: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20096: ELSE
20097: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
20098: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20093: ELSIF l_proc_name = l_migration_proc THEN
20094: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_PROCESS_EXISTS', 'PROC_TYPE', 'model migration');
20095: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20096: ELSE
20097: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
20098: cz_pb_mgr.GLOBAL_EXPORT_RETCODE := 2;
20099: END IF;
20100: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message,'cz_pb_mgr.CHKPROCESS',21001);
20101: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
20156: END IF;
20157:
20158: IF (l_tgt_status <> '0') THEN
20159:
20160: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_FATAL_ERR', 'PUBID', publicationid, 'SQLERRM', l_tgt_msg);
20161: RAISE cz_pb_link_problem;
20162: END IF;
20163: END IF;
20164:
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;
20568: LOOP
20569: IF (cz_pb_mgr.v_models_to_be_exported(i) = cz_pb_mgr.v_root_model_id) THEN
20570: --Root Model %SRCROOT was migrated to instance %TARGET as %TARGROOTPATH.
20571: l_message :=
20572: cz_utils.get_text('CZ_MM_ROOT_EXPORTED'
20573: ,'SRCROOT'
20574: ,l_srcroot
20575: ,'TARGET'
20576: ,cz_pb_mgr.v_server_local_name
20581: ELSE
20582: --Referenced Model %SRCMODEL was migrated to instance %TARGET as %TARGREPOSPATH when migrating %SRCROOT to %TARGROOTPATH.
20583: l_srcmodel := REPLACE(cz_developer_utils_pvt.get_repository_path(v_models_to_be_exported(i), 'PRJ'), '/', '.');
20584: l_message :=
20585: cz_utils.get_text('CZ_MM_MODEL_EXPORTED'
20586: ,'SRCMODEL'
20587: ,l_srcmodel
20588: ,'TARGET'
20589: ,cz_pb_mgr.v_server_local_name
20606: --Referenced Model %SRCMODEL is unchanged locally and on instance %TARGET since its prior migration as %TARGREPOSPATH.
20607: --It has been reused in migrating root Model %SRCROOT to %TARGROOTPATH.
20608: l_srcmodel := REPLACE(cz_developer_utils_pvt.get_repository_path(v_models_not_to_be_exported(i), 'PRJ'), '/', '.');
20609: l_message :=
20610: cz_utils.get_text('CZ_MM_MODEL_NOT_EXPORTED'
20611: ,'SRCMODEL'
20612: ,l_srcmodel
20613: ,'TARGET'
20614: ,cz_pb_mgr.v_server_local_name
20633: 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);
20634:
20635: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN
20636: cz_pb_mgr.v_err_message :=
20637: cz_utils.get_text('CZ_PB_SUCCESS', 'MODELID', cz_pb_mgr.v_root_model_id, 'SERVERID', cz_pb_mgr.v_server_id);
20638: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.PUBLISH_MODEL', SQLCODE);
20639: ELSE
20640: cz_pb_mgr.global_export_retcode := 2;
20641: rollback_data(cz_pb_mgr.v_db_link);
20894: errbuf := NULL;
20895:
20896: IF (cz_pb_mgr.global_export_retcode = 1)
20897: THEN
20898: errbuf := cz_utils.get_text('CZ_PB_WARNING');
20899: END IF;
20900:
20901: IF (cz_pb_mgr.global_export_retcode = 2)
20902: THEN
20899: END IF;
20900:
20901: IF (cz_pb_mgr.global_export_retcode = 2)
20902: THEN
20903: errbuf := cz_utils.get_text('CZ_PB_FAILURE');
20904: END IF;
20905:
20906: retcode := cz_pb_mgr.global_export_retcode;
20907: EXCEPTION
20907: EXCEPTION
20908: WHEN OTHERS
20909: THEN
20910: retcode := 2;
20911: errbuf := cz_utils.get_text('CZ_PB_OTHERS');
20912: END;
20913:
20914: PROCEDURE publish_single_model_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_publication_id NUMBER)
20915: AS
20922: errbuf := NULL;
20923:
20924: IF (cz_pb_mgr.global_export_retcode = 1)
20925: THEN
20926: errbuf := cz_utils.get_text('CZ_PB_WARNING');
20927: END IF;
20928:
20929: IF (cz_pb_mgr.global_export_retcode = 2)
20930: THEN
20927: END IF;
20928:
20929: IF (cz_pb_mgr.global_export_retcode = 2)
20930: THEN
20931: errbuf := cz_utils.get_text('CZ_PB_FAILURE');
20932: END IF;
20933:
20934: retcode := cz_pb_mgr.global_export_retcode;
20935: EXCEPTION
20935: EXCEPTION
20936: WHEN OTHERS
20937: THEN
20938: retcode := 2;
20939: errbuf := cz_utils.get_text('CZ_PB_OTHERS');
20940: END;
20941:
20942: --------------------------------------
20943: PROCEDURE seed_fnd_application_cp(errbuf IN OUT NOCOPY VARCHAR2, retcode IN OUT NOCOPY PLS_INTEGER, p_application_name VARCHAR2)
20964: EXCEPTION
20965: WHEN OTHERS
20966: THEN
20967: retcode := 2;
20968: errbuf := cz_utils.get_text('CZ_APP_OTHERS', 'SQLERRM', SQLERRM);
20969: END;
20970:
20971: ----------------------------------------
20972: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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
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);
21256: COMMIT;
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);
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;
21274: WHEN OTHERS
21275: THEN
21276: x_return_status := FND_API.G_RET_STS_ERROR;
21426: EXCEPTION
21427: WHEN OTHERS
21428: THEN
21429: x_status := '-1';
21430: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_EDIT_SRC_FAILURE', 'PUBID', publicationid, 'SQLERRM', SQLERRM);
21431: log_pb_errors(v_err_message, 1, 'cz_pb_mgr.EDITPB', SQLCODE);
21432: RAISE;
21433: END;
21434:
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;
21642: END IF;
21643: END IF;
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: --------------------------------------------------------
21659: PROCEDURE edit_publication(
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;
21761: EXCEPTION
21762: WHEN pub_maybe_obsoleted
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: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21776: ---------edit publication
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;
21888: EXCEPTION
21889: WHEN pub_maybe_obsoleted
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: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
21902: PROCEDURE chk_pub_overlap_internal(
22213: BEGIN
22214: IF (p_start_date > p_end_date)
22215: THEN
22216: x_status := PUBLICATION_ERROR;
22217: 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));
22218: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22219: END IF;
22220: EXCEPTION
22221: WHEN OTHERS
22261: EXCEPTION
22262: WHEN OTHERS
22263: THEN
22264: x_status := PUBLICATION_ERROR;
22265: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_PARAM_ERROR', 'PUBID', p_publication_id, 'SQLERRM', SQLERRM);
22266: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22267: END get_pb_parameters;
22268:
22269: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22319: EXCEPTION
22320: WHEN OTHERS
22321: THEN
22322: x_status := PUBLICATION_ERROR;
22323: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_CREATE_REQUEST_ERROR', 'PUBID', p_publication_id, 'SQLERRM', SQLERRM);
22324: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22325: END create_republish_request;
22326:
22327: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22615: EXCEPTION
22616: WHEN reset_date_error
22617: THEN
22618: x_status := PUBLICATION_ERROR;
22619: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_RESET_DATES_ERROR', 'PUBID', p_publicationid, 'SQLERRM', SQLERRM);
22620: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22621: WHEN OTHERS
22622: THEN
22623: x_status := PUBLICATION_ERROR;
22620: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22621: WHEN OTHERS
22622: THEN
22623: x_status := PUBLICATION_ERROR;
22624: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_RESET_DATES_ERROR', 'PUBID', p_publicationid, 'SQLERRM', SQLERRM);
22625: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22626: END reset_pb_dates;
22627:
22628: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22645: EXCEPTION
22646: WHEN OTHERS
22647: THEN
22648: x_reset_status := PUBLICATION_ERROR;
22649: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_RESET_PB_CHANGES', 'PUBID', p_publication_id, 'SQLERRM', SQLERRM);
22650: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22651: END reset_repub_changes;
22652:
22653: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>
22773: );
22774:
22775: IF (v_publicationidstring <> '-1')
22776: THEN
22777: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_OVERLAP', 'PUBID', p_publication_id, 'PUBSTR', v_publicationidstring);
22778: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22779: RAISE common_exception;
22780: ELSE
22781: ----create new publication request
22796: RAISE common_exception;
22797: ELSE
22798: cz_pb_mgr.v_msg_tbl.DELETE;
22799: cz_pb_mgr.v_pb_run_id := x_run_id;
22800: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REPUBLISH_SUCCESS', 'PUBID', p_publication_id);
22801: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUB_MODEL', SQLCODE);
22802: log_pb_trace;
22803: END IF;
22804:
22807: EXCEPTION
22808: WHEN common_exception
22809: THEN
22810: ROLLBACK;
22811: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REPUBLISH_FAILURE', 'PUBID', p_publication_id);
22812: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22813: x_status := PUBLICATION_ERROR;
22814: log_pb_trace;
22815: cz_pb_mgr.v_republish_model := no_mode;
22816: WHEN OTHERS
22817: THEN
22818: x_status := PUBLICATION_ERROR;
22819: cz_pb_mgr.v_republish_model := no_mode;
22820: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_REPUBLISH_FAILURE', 'PUBID', p_publication_id, 'SQLERRM', SQLERRM);
22821: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.REPUBLISH_MODEL', SQLCODE);
22822: log_pb_trace;
22823: END republish_model;
22824:
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);
22971: fnd_msg_pub.ADD;
22971: fnd_msg_pub.ADD;
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;
23059: copy_name := 'Copy ('||to_char(L)||') of '||original_name;
23060: RETURN copy_name ;
23061: EXCEPTION
23062: WHEN OTHERS THEN
23063: -- x_error:= CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.COPY_NAME',-222);
23064: log_report('cz_utils', 'copy_name', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
23065: copy_name := 'ERROR';
23066: RETURN copy_name ;
23067: END copy_name;
23060: RETURN copy_name ;
23061: EXCEPTION
23062: WHEN OTHERS THEN
23063: -- x_error:= CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.COPY_NAME',-222);
23064: log_report('cz_utils', 'copy_name', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
23065: copy_name := 'ERROR';
23066: RETURN copy_name ;
23067: END copy_name;
23068:
23215: -----if no start or end dates
23216: ---- are passed, then default to epoch begin and epoch end respectively
23217: IF (p_start_date IS NULL)
23218: THEN
23219: l_start_date := cz_utils.epoch_begin;
23220: ELSE
23221: l_start_date := p_start_date;
23222: END IF;
23223:
23222: END IF;
23223:
23224: IF (p_end_date IS NULL)
23225: THEN
23226: l_end_date := cz_utils.epoch_end;
23227: ELSE
23228: l_end_date := p_end_date;
23229: END IF;
23230:
23500: WHERE cz_ps_nodes.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND deleted_flag = record_not_deleted;
23501: EXCEPTION
23502: WHEN OTHERS
23503: THEN
23504: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ps_nodes', 'SQLERRM', SQLERRM);
23505: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
23506: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
23507: RAISE;
23508: END;
24383:
24384: IF (target_id IS NOT NULL)
24385: THEN
24386: cz_pb_mgr.v_err_message :=
24387: 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);
24388: log_pb_errors(cz_pb_mgr.v_err_message, 0, 'mm_get_ifexists_on_target', -1);
24389: END IF;
24390: EXCEPTION
24391: WHEN NO_DATA_FOUND
24527: COMMIT;
24528: EXCEPTION
24529: WHEN OTHERS
24530: THEN
24531: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_ps_prop_vals', 'SQLERRM', SQLERRM);
24532: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:cz_ps_prop_vals', SQLCODE);
24533: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24534: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24535: RAISE;
24826: END IF;
24827: EXCEPTION
24828: WHEN OTHERS
24829: THEN
24830: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
24831: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
24832: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24833: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24834: END mm_resolve_ids;
24866: END IF;
24867: EXCEPTION
24868: WHEN OTHERS
24869: THEN
24870: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
24871: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
24872: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24873: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24874: END mm_resolve_orig_refs;
24906: END IF;
24907: EXCEPTION
24908: WHEN OTHERS
24909: THEN
24910: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
24911: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
24912: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24913: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24914: END mm_resolve_orig_refs;
24958: END IF;
24959: EXCEPTION
24960: WHEN OTHERS
24961: THEN
24962: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_KEY_RES_ERR', 'ResolvingId', resolving_id, 'SQLERRM', SQLERRM);
24963: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
24964: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
24965: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
24966: END mm_resolve_ids_w_rp_entries;
25036: INTO l_rule_folder_name;
25037:
25038: CLOSE remote_rule_seq_name_cv;
25039:
25040: 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);
25041: log_pb_errors(cz_pb_mgr.v_err_message, 0, 'mm_resolve_rule_seq_effsetid', -1);
25042: l_sql_string :=
25043: 'UPDATE cz_rules'
25044: || cz_pb_mgr.v_db_link
25054: || ' '
25055: || ' AND deleted_flag = ''0'' ';
25056:
25057: EXECUTE IMMEDIATE l_sql_string
25058: USING cz_utils.epoch_end, cz_utils.epoch_begin;
25059: END IF;
25060: END LOOP;
25061: END IF;
25062: END mm_resolve_rule_seq_effsetid;
25091:
25092: EXCEPTION
25093: WHEN OTHERS THEN
25094: --'Unable to resolve the import source server ID for the migration target.'
25095: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_ERR_MIGTGT_IMPORT_SERVER ');
25096: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
25097: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
25098: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
25099: RAISE;
25134: --The import source of the migration target instance is not defined as a remote server on the migration source instance.
25135: --Please create a link to hostname '%HOSTNAME', listener port %LISTENER, instance name '%INSTANCE' by running the
25136: --Define Remote Server and Enable Remote Server concurrent programs on the migration source instance.
25137:
25138: 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);
25139: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.RESOLVEIDS', SQLCODE);
25140: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
25141: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
25142: RETURN -1;
25203: RETURN FALSE;
25204:
25205: EXCEPTION
25206: WHEN others THEN
25207: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_MODEL_TO_PUBLISH_ERR', 'SQLERRM', sqlerrm);
25208: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.HAS_TOBE_PUBLISHED', SQLCODE);
25209: cz_pb_mgr.v_err_message := LTRIM(RTRIM(SUBSTR(cz_pb_mgr.v_err_message, 1, 2000)));
25210: RAISE;
25211: END has_ui_inany_chld_mdl_changed;