DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on FND_LOG

Line 1197: * 1 and 6 corresponding to FND_LOG's

1193: * p_message Message you want to put in log.
1194: * p_prefix Prefix of the message. Default value is
1195: * DEBUG.
1196: * p_msg_level Message Level.Default value is 1 and the value should be between
1197: * 1 and 6 corresponding to FND_LOG's
1198: * LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
1199: * LEVEL_ERROR CONSTANT NUMBER := 5;
1200: * LEVEL_EXCEPTION CONSTANT NUMBER := 4;
1201: * LEVEL_EVENT CONSTANT NUMBER := 3;

Line 1217: * Also modified the logic to call FND_LOG.STRING procedure to store the

1213: * p_message is passed as NULL: Initilized l_len, l_times to
1214: * 0 and added NVL around l_len.
1215: * 10-Dec-2003 Ramesh Ch Added p_msg_level,p_module_prefix,p_module parameters
1216: * with default values as part of Common Logging Infrastrycture Uptake.
1217: * Also modified the logic to call FND_LOG.STRING procedure to store the
1218: * messages in FND_LOG_MESSAGES.
1219: */
1220:
1221: PROCEDURE debug (

Line 1218: * messages in FND_LOG_MESSAGES.

1214: * 0 and added NVL around l_len.
1215: * 10-Dec-2003 Ramesh Ch Added p_msg_level,p_module_prefix,p_module parameters
1216: * with default values as part of Common Logging Infrastrycture Uptake.
1217: * Also modified the logic to call FND_LOG.STRING procedure to store the
1218: * messages in FND_LOG_MESSAGES.
1219: */
1220:
1221: PROCEDURE debug (
1222: p_message IN VARCHAR2,

Line 1224: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

1220:
1221: PROCEDURE debug (
1222: p_message IN VARCHAR2,
1223: p_prefix IN VARCHAR2 DEFAULT 'DEBUG',
1224: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
1225: p_module_prefix IN VARCHAR2 DEFAULT 'HZ_Package',
1226: p_module IN VARCHAR2 DEFAULT 'HZ_Module'
1227: ) IS
1228:

Line 1242: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1238: ELSE
1239: l_message :=SUBSTRB(p_message,1,4000);
1240: END IF;
1241:
1242: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1243: FND_LOG.STRING(p_msg_level,l_module,l_message);
1244: end if;
1245:
1246: END debug;

Line 1243: FND_LOG.STRING(p_msg_level,l_module,l_message);

1239: l_message :=SUBSTRB(p_message,1,4000);
1240: END IF;
1241:
1242: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1243: FND_LOG.STRING(p_msg_level,l_module,l_message);
1244: end if;
1245:
1246: END debug;
1247:

Line 1262: * 1 and 6 corresponding to FND_LOG's

1258: * p_msg_count Message count in message stack.
1259: * p_msg_data Message data if message count is 1.
1260: * p_msg_type Message type used as prefix of the message.
1261: * p_msg_level Message Level.Default value is 1 and the value should be between
1262: * 1 and 6 corresponding to FND_LOG's
1263: * LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
1264: * LEVEL_ERROR CONSTANT NUMBER := 5;
1265: * LEVEL_EXCEPTION CONSTANT NUMBER := 4;
1266: * LEVEL_EVENT CONSTANT NUMBER := 3;

Line 1289: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

1285: PROCEDURE debug_return_messages (
1286: p_msg_count IN NUMBER,
1287: p_msg_data IN VARCHAR2,
1288: p_msg_type IN VARCHAR2 DEFAULT 'ERROR',
1289: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
1290: p_module_prefix IN VARCHAR2 DEFAULT 'HZ_Package',
1291: p_module IN VARCHAR2 DEFAULT 'HZ_Module'
1292: ) IS
1293:

Line 3087: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3083: p_column => 'created_by_module',
3084: p_column_value => p_created_by_module,
3085: x_return_status => x_return_status);
3086:
3087: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3088: debug(
3089: p_prefix => '',
3090: p_message => 'created_by_module is mandatory. ' ||
3091: 'x_return_status = ' || x_return_status,

Line 3092: p_msg_level => fnd_log.level_statement);

3088: debug(
3089: p_prefix => '',
3090: p_message => 'created_by_module is mandatory. ' ||
3091: 'x_return_status = ' || x_return_status,
3092: p_msg_level => fnd_log.level_statement);
3093: END IF;
3094: END IF;
3095:
3096: -- created_by_module is non-updateable field. But it can be updated from

Line 3109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3105: p_old_column_value => p_old_created_by_module,
3106: p_restricted => 'N',
3107: x_return_status => x_return_status);
3108:
3109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3110: debug(
3111: p_prefix => '',
3112: p_message => 'created_by_module is non-updateable. It can be updated from NULL to a value. ' ||
3113: 'x_return_status = ' || x_return_status,

Line 3114: p_msg_level => fnd_log.level_statement);

3110: debug(
3111: p_prefix => '',
3112: p_message => 'created_by_module is non-updateable. It can be updated from NULL to a value. ' ||
3113: 'x_return_status = ' || x_return_status,
3114: p_msg_level => fnd_log.level_statement);
3115: END IF;
3116: END IF;
3117: END IF;
3118:

Line 3133: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3129: p_lookup_type => 'HZ_CREATED_BY_MODULES',
3130: p_column_value => p_created_by_module,
3131: x_return_status => x_return_status);
3132:
3133: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3134: debug(
3135: p_prefix => '',
3136: p_message => 'created_by_module is lookup code in lookup type HZ_CREATED_BY_MODULES. ' ||
3137: 'x_return_status = ' || x_return_status,

Line 3138: p_msg_level => fnd_log.level_statement);

3134: debug(
3135: p_prefix => '',
3136: p_message => 'created_by_module is lookup code in lookup type HZ_CREATED_BY_MODULES. ' ||
3137: 'x_return_status = ' || x_return_status,
3138: p_msg_level => fnd_log.level_statement);
3139: END IF;
3140: END IF;
3141:
3142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3138: p_msg_level => fnd_log.level_statement);
3139: END IF;
3140: END IF;
3141:
3142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3143: debug(
3144: p_prefix => '',
3145: p_message => 'after validate created_by_module ... ' ||
3146: 'x_return_status = ' || x_return_status,

Line 3147: p_msg_level => fnd_log.level_statement);

3143: debug(
3144: p_prefix => '',
3145: p_message => 'after validate created_by_module ... ' ||
3146: 'x_return_status = ' || x_return_status,
3147: p_msg_level => fnd_log.level_statement);
3148: END IF;
3149:
3150: END validate_created_by_module;
3151:

Line 3192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3188: p_old_column_value => p_old_application_id,
3189: p_restricted => 'N',
3190: x_return_status => x_return_status);
3191:
3192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3193: debug(
3194: p_prefix => '',
3195: p_message => l_column || ' is non-updateable. It can be updated from NULL to a value. ' ||
3196: 'x_return_status = ' || x_return_status,

Line 3197: p_msg_level => fnd_log.level_statement);

3193: debug(
3194: p_prefix => '',
3195: p_message => l_column || ' is non-updateable. It can be updated from NULL to a value. ' ||
3196: 'x_return_status = ' || x_return_status,
3197: p_msg_level => fnd_log.level_statement);
3198: END IF;
3199: END IF;
3200: END IF;
3201:

Line 3202: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3198: END IF;
3199: END IF;
3200: END IF;
3201:
3202: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3203: debug(
3204: p_prefix => '',
3205: p_message => 'after validate ' || l_column || ' ... ' ||
3206: 'x_return_status = ' || x_return_status,

Line 3207: p_msg_level => fnd_log.level_statement);

3203: debug(
3204: p_prefix => '',
3205: p_message => 'after validate ' || l_column || ' ... ' ||
3206: 'x_return_status = ' || x_return_status,
3207: p_msg_level => fnd_log.level_statement);
3208: END IF;
3209:
3210: END validate_application_id;
3211: