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 3071: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3067: p_column => 'created_by_module',
3068: p_column_value => p_created_by_module,
3069: x_return_status => x_return_status);
3070:
3071: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3072: debug(
3073: p_prefix => '',
3074: p_message => 'created_by_module is mandatory. ' ||
3075: 'x_return_status = ' || x_return_status,

Line 3076: p_msg_level => fnd_log.level_statement);

3072: debug(
3073: p_prefix => '',
3074: p_message => 'created_by_module is mandatory. ' ||
3075: 'x_return_status = ' || x_return_status,
3076: p_msg_level => fnd_log.level_statement);
3077: END IF;
3078: END IF;
3079:
3080: -- created_by_module is non-updateable field. But it can be updated from

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

3089: p_old_column_value => p_old_created_by_module,
3090: p_restricted => 'N',
3091: x_return_status => x_return_status);
3092:
3093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3094: debug(
3095: p_prefix => '',
3096: p_message => 'created_by_module is non-updateable. It can be updated from NULL to a value. ' ||
3097: 'x_return_status = ' || x_return_status,

Line 3098: p_msg_level => fnd_log.level_statement);

3094: debug(
3095: p_prefix => '',
3096: p_message => 'created_by_module is non-updateable. It can be updated from NULL to a value. ' ||
3097: 'x_return_status = ' || x_return_status,
3098: p_msg_level => fnd_log.level_statement);
3099: END IF;
3100: END IF;
3101: END IF;
3102:

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

3113: p_lookup_type => 'HZ_CREATED_BY_MODULES',
3114: p_column_value => p_created_by_module,
3115: x_return_status => x_return_status);
3116:
3117: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3118: debug(
3119: p_prefix => '',
3120: p_message => 'created_by_module is lookup code in lookup type HZ_CREATED_BY_MODULES. ' ||
3121: 'x_return_status = ' || x_return_status,

Line 3122: p_msg_level => fnd_log.level_statement);

3118: debug(
3119: p_prefix => '',
3120: p_message => 'created_by_module is lookup code in lookup type HZ_CREATED_BY_MODULES. ' ||
3121: 'x_return_status = ' || x_return_status,
3122: p_msg_level => fnd_log.level_statement);
3123: END IF;
3124: END IF;
3125:
3126: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3122: p_msg_level => fnd_log.level_statement);
3123: END IF;
3124: END IF;
3125:
3126: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3127: debug(
3128: p_prefix => '',
3129: p_message => 'after validate created_by_module ... ' ||
3130: 'x_return_status = ' || x_return_status,

Line 3131: p_msg_level => fnd_log.level_statement);

3127: debug(
3128: p_prefix => '',
3129: p_message => 'after validate created_by_module ... ' ||
3130: 'x_return_status = ' || x_return_status,
3131: p_msg_level => fnd_log.level_statement);
3132: END IF;
3133:
3134: END validate_created_by_module;
3135:

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

3172: p_old_column_value => p_old_application_id,
3173: p_restricted => 'N',
3174: x_return_status => x_return_status);
3175:
3176: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3177: debug(
3178: p_prefix => '',
3179: p_message => l_column || ' is non-updateable. It can be updated from NULL to a value. ' ||
3180: 'x_return_status = ' || x_return_status,

Line 3181: p_msg_level => fnd_log.level_statement);

3177: debug(
3178: p_prefix => '',
3179: p_message => l_column || ' is non-updateable. It can be updated from NULL to a value. ' ||
3180: 'x_return_status = ' || x_return_status,
3181: p_msg_level => fnd_log.level_statement);
3182: END IF;
3183: END IF;
3184: END IF;
3185:

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

3182: END IF;
3183: END IF;
3184: END IF;
3185:
3186: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3187: debug(
3188: p_prefix => '',
3189: p_message => 'after validate ' || l_column || ' ... ' ||
3190: 'x_return_status = ' || x_return_status,

Line 3191: p_msg_level => fnd_log.level_statement);

3187: debug(
3188: p_prefix => '',
3189: p_message => 'after validate ' || l_column || ' ... ' ||
3190: 'x_return_status = ' || x_return_status,
3191: p_msg_level => fnd_log.level_statement);
3192: END IF;
3193:
3194: END validate_application_id;
3195: