1: PACKAGE BODY CZ_UTILS AS
2: /* $Header: czcutilb.pls 120.3 2006/01/20 02:14:02 amdixit ship $ */
3:
4: PROCEDURE get_App_Info(p_app_short_name IN VARCHAR2,
5: x_oracle_schema OUT NOCOPY VARCHAR2) IS
170:
171: RETURN PK_USEEXPANSION_FLAG;
172: EXCEPTION
173: WHEN OTHERS THEN
174: -- x_error:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.GET_PK_USEEXPANSION_FLAG',11276);
175: log_report('cz_utils', 'GET_PK_USEEXPANSION_FLAG', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
176: RETURN 0;
177: END;
178: END GET_PK_USEEXPANSION_FLAG;
171: RETURN PK_USEEXPANSION_FLAG;
172: EXCEPTION
173: WHEN OTHERS THEN
174: -- x_error:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.GET_PK_USEEXPANSION_FLAG',11276);
175: log_report('cz_utils', 'GET_PK_USEEXPANSION_FLAG', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
176: RETURN 0;
177: END;
178: END GET_PK_USEEXPANSION_FLAG;
179:
195: RETURN TO_NUMBER(NVL(NOUPDATE_FLAG,'0'));
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: -- x_error:=CZ_UTILS.REPORT(SQLERRM,0,'CZ_UTILS.GET_NOUPDATE_FLAG',11276);
200: log_report('cz_utils', 'GET_NOUPDATE_FLAG', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
201: RETURN 0;
202: END;
203: END GET_NOUPDATE_FLAG;
196:
197: EXCEPTION
198: WHEN OTHERS THEN
199: -- x_error:=CZ_UTILS.REPORT(SQLERRM,0,'CZ_UTILS.GET_NOUPDATE_FLAG',11276);
200: log_report('cz_utils', 'GET_NOUPDATE_FLAG', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
201: RETURN 0;
202: END;
203: END GET_NOUPDATE_FLAG;
204:
232: outNAME:=sFND;
233: END IF;
234: EXCEPTION
235: WHEN OTHERS THEN
236: -- X_ERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.GET_USER_NAME',11276);
237: log_report('cz_utils', 'GET_USER_NAME', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
238: END GET_USER_NAME;
239:
240: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
233: END IF;
234: EXCEPTION
235: WHEN OTHERS THEN
236: -- X_ERROR:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.GET_USER_NAME',11276);
237: log_report('cz_utils', 'GET_USER_NAME', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
238: END GET_USER_NAME;
239:
240: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
241: function conv_num(str varchar2)
443: RETURN 0;
444:
445: EXCEPTION
446: WHEN OTHERS THEN
447: -- x_error:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.CHECK_INSTALLED_LANG',11276);
448: log_report('cz_utils', 'check_installed_lang', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
449: RETURN 1;
450: END check_installed_lang;
451:
444:
445: EXCEPTION
446: WHEN OTHERS THEN
447: -- x_error:=CZ_UTILS.REPORT(SQLERRM,1,'CZ_UTILS.CHECK_INSTALLED_LANG',11276);
448: log_report('cz_utils', 'check_installed_lang', 1, SQLERRM, fnd_log.LEVEL_UNEXPECTED);
449: RETURN 1;
450: END check_installed_lang;
451:
452: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>
474: textString VARCHAR2(2000);
475:
476: PROCEDURE REPORT(inMessage IN VARCHAR2) IS
477: BEGIN
478: log_report('CZ_UTILS', defCaller, defStatusCode, inMessage, fnd_log.LEVEL_STATEMENT);
479: -- INSERT INTO cz_db_logs (message, statuscode, caller, urgency, logtime)
480: -- VALUES (inMessage, defStatusCode, defCaller, defUrgency, SYSDATE);
481:
482: END;
733: fnd_msg_pub.add_exc_msg(p_package_name, p_procedure_name, p_error_message);
734: END add_exc_msg_to_fndstack;
735: ---------------------------------------------
736:
737: END CZ_UTILS;