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 850: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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;

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

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:

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

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:

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

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:

Line 2336: log_msg('Model_Convert_CP', 0, 'The Migration Group id that is in process is '||l_migration_group_id, fnd_log.level_unexpected);

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.

Line 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);

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:

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

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;

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

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 .

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

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:

Line 2450: log_msg('Model_Convert_CP', 0, 'The Migration Group id that is completed is '||l_migration_group_id, fnd_log.level_unexpected);

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

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

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');

Line 2468: log_msg(l_api_name, v_ndebug, errbuf, fnd_log.level_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: