73: END IF;
74: cz_utils.log_report(g_pkg_name, p_caller, p_ndebug, p_msg, p_level);
75: EXCEPTION WHEN OTHERS THEN
76: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
77: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
78: RAISE;
79: END log_msg;
80:
81: --procedure to log messages to cz_db_logs for use by the model conversion xml publisher report
114: COMMIT;
115:
116: EXCEPTION WHEN OTHERS THEN
117: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
118: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
119: RAISE;
120: END;
121:
122:
153: END IF;
154: RETURN p_rule_folderid;
155: EXCEPTION WHEN OTHERS THEN
156: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
157: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
158: RAISE;
159: END findOrCreateRuleFolder;
160:
161: -- procedure to populate CZ tables with data in temporary tables v_cz_rules and v_cz_expression_nodes
209:
210: EXCEPTION
211: WHEN others THEN
212: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
213: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
214: RAISE;
215: END populate_cz_tables;
216:
217:
292: WHERE ui_def_id=uiout.ui_def_id AND content_type=561) ;
293:
294: EXCEPTION WHEN OTHERS THEN
295: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
296: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
297: RAISE;
298:
299: END UPG_UI_CONT_TYPE_TMPLS;
300:
710:
711: EXCEPTION
712: WHEN others THEN
713: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
714: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
715: RAISE;
716: END processUI;
717:
718:
756:
757: EXCEPTION
758: WHEN others THEN
759: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
760: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
761: RAISE;
762: END removeEffectivityInfo;
763:
764:
846: RETURN l_rule_id;
847: EXCEPTION
848: WHEN others THEN
849: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
850: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
851: RAISE;
852: END;
853:
854:
934:
935: EXCEPTION
936: WHEN others THEN
937: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
938: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
939: RAISE;
940: END insertImpliesRuleRecords;
941:
942:
1043: END IF;
1044: EXCEPTION
1045: WHEN others THEN
1046: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1047: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1048: RAISE;
1049: END createAccumulatorRule;
1050:
1051:
1200: END IF;
1201: EXCEPTION
1202: WHEN others THEN
1203: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1204: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1205: RAISE;
1206: END createRules;
1207:
1208:
1220: OR(ps_node_type = PS_TYPE_FEATURE AND feature_type = FEATURE_TYPE_BOOLEAN));
1221: EXCEPTION
1222: WHEN others THEN
1223: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1224: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1225: RAISE;
1226: END clearinitialvalues;
1227:
1228:
1459:
1460: EXCEPTION
1461: WHEN others THEN
1462: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1463: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1464: RAISE;
1465: END assignDefaultMinMaxvalues;
1466:
1467:
1966:
1967: EXCEPTION
1968: WHEN others THEN
1969: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1970: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1971: RAISE;
1972: END convertRules;
1973:
1974:
2050:
2051: EXCEPTION
2052: WHEN others THEN
2053: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2054: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
2055: RAISE;
2056: END processModel;
2057:
2058:
2173: v_cz_expression_nodes.DELETE;
2174: v_cz_rule_count := 0;
2175: V_CZ_RULES.DELETE;
2176: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2177: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
2178: v_model_conversion_set_id:=NULL;
2179: RAISE;
2180: END convertModels;
2181:
2231: END LOOP;
2232:
2233: IF NOT l_mig_group_found THEN
2234: errbuf := cz_utils.get_text('CZ_INVALID_MIGR_GROUP_NUMBER', 'MIGRGRP', p_request_id);
2235: log_msg(l_api_name, v_ndebug, errbuf , FND_LOG.LEVEL_PROCEDURE);
2236: raise_application_error('-20020', 'INVALID_MIGRATION_GROUP');
2237: END IF;
2238:
2239: retcode := cz_pb_mgr.GLOBAL_EXPORT_RETCODE;
2240:
2241: EXCEPTION
2242: WHEN OTHERS THEN
2243: retcode := 2;
2244: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2245: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_UNEXPECTED');
2246: RAISE;
2247: END;
2248:
2289: INTEGER_MAX_VALUE := fnd_profile.value('CZ_DEFAULT_MAX_QTY_INT');
2290: SOLVER_MAX_DOUBLE := fnd_profile.value('CZ_DEFAULT_MAX_QTY_DEC');
2291:
2292: IF (INTEGER_MAX_VALUE IS NULL OR SOLVER_MAX_DOUBLE IS NULL) THEN
2293: log_msg('Model_Convert_CP', 0, cz_utils.get_text('CZ_CNV_ERR_PROFILE_NOT_SET') , fnd_log.level_unexpected);
2294: RAISE ERR_PROFILE;
2295: END IF;
2296:
2297:
2310: AND export_status = 'PEN'
2311: AND server_id = 0);
2312:
2313: IF(noofreports=0 and fnd_conc_global.request_data IS NULL ) THEN
2314: log_msg('Model_Convert_CP', 0, 'No pending request with the supplied Conversion Set ID', fnd_log.level_unexpected);
2315: errbuf := 'Error in model conversion!';
2316: retcode := 2;
2317: raise ERR_PROFILE;
2318:
2332: BEGIN
2333: BEGIN
2334:
2335: l_migration_group_id:=c_model_conv.migration_group_id;
2336: log_msg('Model_Convert_CP', 0, 'The Migration Group id that is in process is '||l_migration_group_id, fnd_log.level_unexpected);
2337: --
2338: -- Read the value from REQUEST_DATA. If this is the PL/SQL APIs for Concurrent Processing
2339: -- first run of the program, then this value will be
2340: -- null.
2388: retcode := 2;
2389: ELSE
2390: --
2391: log_msg('Model_Convert_CP', 0 ,
2392: 'Model Conversion Report Generation has been submitted as a Concurrent Request with ID '||r||'. Please review the output of the Concurrent Process for important messages about the conversion.', fnd_log.level_unexpected);
2393: errbuf := 'Request submitted!';
2394: retcode := 0 ;
2395: END IF;
2396:
2398: EXCEPTION WHEN OTHERS THEN
2399: L_ERROR_IN_CP := TRUE;
2400: retcode := 2;
2401: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2402: log_msg('Model_Convert_CP', 0, 'Error submitting request for report generation.', fnd_log.level_unexpected);
2403: IF(errbuf <> cz_utils.get_text('CZ_CNV_UNEXPECTED'))THEN
2404: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2405: END IF;
2406: cz_model_convert.CONVERT_MODEL:=FALSE;
2400: retcode := 2;
2401: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2402: log_msg('Model_Convert_CP', 0, 'Error submitting request for report generation.', fnd_log.level_unexpected);
2403: IF(errbuf <> cz_utils.get_text('CZ_CNV_UNEXPECTED'))THEN
2404: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2405: END IF;
2406: cz_model_convert.CONVERT_MODEL:=FALSE;
2407: -- rollback model copy operation when there is an error
2408: --If "cz_model_migration_pvt .migrate_models_cp" call not completed successfully then Mark the migrated models as deleted .
2428: BEGIN
2429: cz_developer_utils_pvt.delete_model(c_process.remote_model_id,L_RETURN_STATUS,L_MSG_COUNT,L_MSG_DATA);
2430: EXCEPTION WHEN OTHERS THEN
2431: errbuf := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2432: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2433: END;
2434:
2435: END LOOP;
2436:
2446: --no need to pause if child completed
2447: EXCEPTION WHEN OTHERS THEN
2448: NULL;
2449: END;
2450: log_msg('Model_Convert_CP', 0, 'The Migration Group id that is completed is '||l_migration_group_id, fnd_log.level_unexpected);
2451: END;
2452: END LOOP;
2453: cz_model_convert.CONVERT_MODEL:=FALSE;
2454: IF(L_ERROR_IN_CP)THEN
2456: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2457: END IF;
2458: EXCEPTION WHEN ERR_PROFILE THEN
2459: IF(errbuf <> cz_utils.get_text('CZ_CNV_UNEXPECTED'))THEN
2460: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2461: END IF;
2462: cz_model_convert.CONVERT_MODEL:=FALSE;
2463: retcode := 2;
2464: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2464: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2465: commit;
2466: WHEN OTHERS THEN
2467: IF(errbuf <> cz_utils.get_text('CZ_CNV_UNEXPECTED'))THEN
2468: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2469: END IF;
2470: End Model_Convert_CP;
2471:
2472: