DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on FND_LOG

Line 77: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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

Line 118: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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:

Line 157: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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

Line 213: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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:

Line 296: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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:

Line 714: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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:

Line 760: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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:

Line 844: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

840: RETURN l_rule_id;
841: EXCEPTION
842: WHEN others THEN
843: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
844: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
845: RAISE;
846: END;
847:
848:

Line 932: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

928:
929: EXCEPTION
930: WHEN others THEN
931: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
932: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
933: RAISE;
934: END insertImpliesRuleRecords;
935:
936:

Line 1041: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

1037: END IF;
1038: EXCEPTION
1039: WHEN others THEN
1040: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1041: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1042: RAISE;
1043: END createAccumulatorRule;
1044:
1045:

Line 1198: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

1194: END IF;
1195: EXCEPTION
1196: WHEN others THEN
1197: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1198: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1199: RAISE;
1200: END createRules;
1201:
1202:

Line 1218: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

1214: OR(ps_node_type = PS_TYPE_FEATURE AND feature_type = FEATURE_TYPE_BOOLEAN));
1215: EXCEPTION
1216: WHEN others THEN
1217: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1218: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1219: RAISE;
1220: END clearinitialvalues;
1221:
1222:

Line 1436: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

1432:
1433: EXCEPTION
1434: WHEN others THEN
1435: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1436: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1437: RAISE;
1438: END assignDefaultMinMaxvalues;
1439:
1440:

Line 1943: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

1939:
1940: EXCEPTION
1941: WHEN others THEN
1942: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
1943: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
1944: RAISE;
1945: END convertRules;
1946:
1947:

Line 2027: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

2023:
2024: EXCEPTION
2025: WHEN others THEN
2026: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2027: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
2028: RAISE;
2029: END processModel;
2030:
2031:

Line 2145: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

2141: v_cz_expression_nodes.DELETE;
2142: v_cz_rule_count := 0;
2143: V_CZ_RULES.DELETE;
2144: l_msg := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2145: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
2146: v_model_conversion_set_id:=NULL;
2147: RAISE;
2148: END convertModels;
2149:

Line 2203: log_msg(l_api_name, v_ndebug, errbuf , FND_LOG.LEVEL_PROCEDURE);

2199: END LOOP;
2200:
2201: IF NOT l_mig_group_found THEN
2202: errbuf := cz_utils.get_text('CZ_INVALID_MIGR_GROUP_NUMBER', 'MIGRGRP', p_request_id);
2203: log_msg(l_api_name, v_ndebug, errbuf , FND_LOG.LEVEL_PROCEDURE);
2204: raise_application_error('-20020', 'INVALID_MIGRATION_GROUP');
2205: END IF;
2206:
2207: retcode := cz_pb_mgr.GLOBAL_EXPORT_RETCODE;

Line 2212: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);

2208:
2209: EXCEPTION
2210: WHEN OTHERS THEN
2211: retcode := 2;
2212: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2213: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_UNEXPECTED');
2214: RAISE;
2215: END;
2216:

Line 2261: log_msg('Model_Convert_CP', 0, cz_utils.get_text('CZ_CNV_ERR_PROFILE_NOT_SET') , fnd_log.level_unexpected);

2257: INTEGER_MAX_VALUE := fnd_profile.value('CZ_DEFAULT_MAX_QTY_INT');
2258: SOLVER_MAX_DOUBLE := fnd_profile.value('CZ_DEFAULT_MAX_QTY_DEC');
2259:
2260: IF (INTEGER_MAX_VALUE IS NULL OR SOLVER_MAX_DOUBLE IS NULL) THEN
2261: log_msg('Model_Convert_CP', 0, cz_utils.get_text('CZ_CNV_ERR_PROFILE_NOT_SET') , fnd_log.level_unexpected);
2262: RAISE ERR_PROFILE;
2263: END IF;
2264:
2265:

Line 2282: log_msg('Model_Convert_CP', 0, 'No pending request with the supplied Conversion Set ID', fnd_log.level_unexpected);

2278: AND export_status = 'PEN'
2279: AND server_id = 0);
2280:
2281: IF(noofreports=0 and fnd_conc_global.request_data IS NULL ) THEN
2282: log_msg('Model_Convert_CP', 0, 'No pending request with the supplied Conversion Set ID', fnd_log.level_unexpected);
2283: errbuf := 'Error in model conversion!';
2284: retcode := 2;
2285: raise ERR_PROFILE;
2286:

Line 2359: '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);

2355: retcode := 2;
2356: ELSE
2357: --
2358: log_msg('Model_Convert_CP', 0 ,
2359: '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);
2360: errbuf := 'Request submitted!';
2361: retcode := 0 ;
2362: END IF;
2363:

Line 2369: log_msg('Model_Convert_CP', 0, 'Error submitting request for report generation.', fnd_log.level_unexpected);

2365: EXCEPTION WHEN OTHERS THEN
2366: L_ERROR_IN_CP := TRUE;
2367: retcode := 2;
2368: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2369: log_msg('Model_Convert_CP', 0, 'Error submitting request for report generation.', fnd_log.level_unexpected);
2370: cz_model_convert.CONVERT_MODEL:=FALSE;
2371: BEGIN
2372: call_status := FND_CONCURRENT.GET_REQUEST_STATUS(r, '', '', rphase,rstatus,dphase,dstatus, message);
2373: IF dphase<>'COMPLETE' THEN

Line 2403: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);

2399: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2400: END IF;
2401: EXCEPTION WHEN ERR_PROFILE THEN
2402: IF(errbuf <> cz_utils.get_text('CZ_CNV_UNEXPECTED'))THEN
2403: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2404: END IF;
2405: cz_model_convert.CONVERT_MODEL:=FALSE;
2406: retcode := 2;
2407: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');

Line 2411: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);

2407: errbuf := cz_utils.get_text('CZ_CNV_UNEXPECTED');
2408: commit;
2409: WHEN OTHERS THEN
2410: IF(errbuf <> cz_utils.get_text('CZ_CNV_UNEXPECTED'))THEN
2411: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2412: END IF;
2413: cz_model_convert.CONVERT_MODEL:=FALSE;
2414: -- rollback model copy operation when there is an error
2415: --If "cz_model_migration_pvt .migrate_models_cp" call not completed successfully then Mark the migrated models as deleted .

Line 2439: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);

2435: BEGIN
2436: cz_developer_utils_pvt.delete_model(c_process.remote_model_id,L_RETURN_STATUS,L_MSG_COUNT,L_MSG_DATA);
2437: EXCEPTION WHEN OTHERS THEN
2438: errbuf := 'Fatal error in ' || l_api_name || '.' || v_ndebug || ': ' || SUBSTR(sqlerrm, 1, 900);
2439: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_unexpected);
2440: END;
2441:
2442: END LOOP;
2443: