eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_UTILS_PKG dependencies on FND_LOG

Line 109: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

105: Issue: WHILE BOOKING THE ORDER CURRENCY CONVERSION VALIDATION IS MISSING
106: Fix: Commented use of cursor get_curr_rate and used select statement instead
107:
108: *********************************************************************************************************/
109: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

106: Fix: Commented use of cursor get_curr_rate and used select statement instead
107:
108: *********************************************************************************************************/
109: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

107:
108: *********************************************************************************************************/
109: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

108: *********************************************************************************************************/
109: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
116: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_CMN_UTILS_PKG.';

Line 113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

109: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
116: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_CMN_UTILS_PKG.';
117: FUNCTION get_currency_code(p_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE) RETURN VARCHAR2 IS

Line 114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

110: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
116: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_CMN_UTILS_PKG.';
117: FUNCTION get_currency_code(p_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE) RETURN VARCHAR2 IS
118: /* Bug 5243532. Added by Lakshmi Gopalsami.

Line 115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

111: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
112: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
113: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
114: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
115: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
116: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'JAI.PLSQL.JAI_CMN_UTILS_PKG.';
117: FUNCTION get_currency_code(p_operating_unit_id HR_OPERATING_UNITS.ORGANIZATION_ID%TYPE) RETURN VARCHAR2 IS
118: /* Bug 5243532. Added by Lakshmi Gopalsami.
119: Removed the cursor c_set_of_books and c_sob_currency

Line 991: PROCEDURE WRITE_FND_LOG_MSG (

987: RETURN ( lb_drilldown_flag );
988:
989: END if_IL_drilldown;
990:
991: PROCEDURE WRITE_FND_LOG_MSG (
992: module IN VARCHAR2,
993: message IN VARCHAR2
994: ) IS
995:

Line 1000: IF (ln_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

996: ln_log_level NUMBER := 6;
997:
998: BEGIN
999:
1000: IF (ln_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1001: THEN
1002:
1003: fnd_log.STRING(log_level => ln_log_level
1004: ,module => module

Line 1003: fnd_log.STRING(log_level => ln_log_level

999:
1000: IF (ln_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1001: THEN
1002:
1003: fnd_log.STRING(log_level => ln_log_level
1004: ,module => module
1005: ,message => message );
1006:
1007: END IF;

Line 1013: END WRITE_FND_LOG_MSG;

1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: Null;
1013: END WRITE_FND_LOG_MSG;
1014:
1015:
1016: --==========================================================================
1017: -- FUNCTION NAME:

Line 1018: -- WRITE_FND_LOG Public

1014:
1015:
1016: --==========================================================================
1017: -- FUNCTION NAME:
1018: -- WRITE_FND_LOG Public
1019: --
1020: -- DESCRIPTION:
1021: -- Write FND log with given log level.
1022: --

Line 1021: -- Write FND log with given log level.

1017: -- FUNCTION NAME:
1018: -- WRITE_FND_LOG Public
1019: --
1020: -- DESCRIPTION:
1021: -- Write FND log with given log level.
1022: --
1023: -- PARAMETERS:
1024: -- In: pn_message_level Given log level
1025: -- pv_module module name

Line 1026: -- pv_message fnd log message contents

1022: --
1023: -- PARAMETERS:
1024: -- In: pn_message_level Given log level
1025: -- pv_module module name
1026: -- pv_message fnd log message contents
1027: --
1028: -- DESIGN REFERENCES:
1029: --
1030: -- CHANGE HISTORY:

Line 1033: PROCEDURE WRITE_FND_LOG(

1029: --
1030: -- CHANGE HISTORY:
1031: -- 15-JUN-2012 Chong created
1032: --==========================================================================
1033: PROCEDURE WRITE_FND_LOG(
1034: pn_message_level IN NUMBER DEFAUlt 1, --FND log level, default 1: statument level
1035: pv_module IN VARCHAR2,
1036: pv_message IN VARCHAR2
1037: ) IS

Line 1034: pn_message_level IN NUMBER DEFAUlt 1, --FND log level, default 1: statument level

1030: -- CHANGE HISTORY:
1031: -- 15-JUN-2012 Chong created
1032: --==========================================================================
1033: PROCEDURE WRITE_FND_LOG(
1034: pn_message_level IN NUMBER DEFAUlt 1, --FND log level, default 1: statument level
1035: pv_module IN VARCHAR2,
1036: pv_message IN VARCHAR2
1037: ) IS
1038:

Line 1043: IF (pn_message_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1039: ln_log_level NUMBER := 6;
1040:
1041: BEGIN
1042:
1043: IF (pn_message_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044:
1045: FND_LOG.STRING(log_level => pn_message_level
1046: ,module => pv_module
1047: ,message => pv_message );

Line 1045: FND_LOG.STRING(log_level => pn_message_level

1041: BEGIN
1042:
1043: IF (pn_message_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044:
1045: FND_LOG.STRING(log_level => pn_message_level
1046: ,module => pv_module
1047: ,message => pv_message );
1048: END IF;
1049:

Line 1053: END WRITE_FND_LOG;

1049:
1050: EXCEPTION
1051: WHEN OTHERS THEN
1052: Null;
1053: END WRITE_FND_LOG;
1054:
1055: --==========================================================================
1056: -- FUNCTION NAME:
1057: -- IS_ACCRUAL_BASIS Public

Line 1117: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||lv_api_name,lv_debug_info);

1113: lv_debug_info := 'pn_regime_id = '||pn_regime_id||', pn_organization_id = '||pn_organization_id ||
1114: ', pn_location_id = '|| pn_location_id || ', pd_gl_date = '|| pd_gl_date;
1115:
1116: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1117: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||lv_api_name,lv_debug_info);
1118: END IF;
1119:
1120: OPEN c_get_st_accrual_date(pn_regime_id,pn_organization_id,pn_location_id);
1121: FETCH c_get_st_accrual_date INTO ld_st_accrual_date;

Line 1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||lv_api_name,lv_debug_info);

1123:
1124: lv_debug_info := 'pd_gl_date = '|| pd_gl_date||', ld_st_accrual_date = '||ld_st_accrual_date;
1125:
1126: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||lv_api_name,lv_debug_info);
1128: END IF;
1129:
1130: IF pd_gl_date >= ld_st_accrual_date THEN
1131: lb_is_accrual_basis := TRUE;