DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on FND_LOG

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

17: * p_message Message you want to put in log.
18: * p_prefix Prefix of the message. Default value is
19: * DEBUG.
20: * p_msg_level Message Level.Default value is 1 and the value should be between
21: * 1 and 6 corresponding to FND_LOG's
22: * LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
23: * LEVEL_ERROR CONSTANT NUMBER := 5;
24: * LEVEL_EXCEPTION CONSTANT NUMBER := 4;
25: * LEVEL_EVENT CONSTANT NUMBER := 3;

Line 40: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,

36:
37: PROCEDURE debug (
38: p_message IN VARCHAR2,
39: p_prefix IN VARCHAR2 DEFAULT 'DEBUG',
40: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT,
41: p_module_prefix IN VARCHAR2 DEFAULT 'JTF_RS_Package',
42: p_module IN VARCHAR2 DEFAULT 'JTF_RS_Module'
43: ) IS
44:

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

54: ELSE
55: l_message :=SUBSTRB(p_message,1,4000);
56: END IF;
57:
58: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
59: FND_LOG.STRING(p_msg_level,l_module,l_message);
60: end if;
61:
62: END debug;

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

55: l_message :=SUBSTRB(p_message,1,4000);
56: END IF;
57:
58: if( p_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
59: FND_LOG.STRING(p_msg_level,l_module,l_message);
60: end if;
61:
62: END debug;
63:

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

1215: l_user_orig_system_id wf_local_roles.orig_system_id%TYPE;
1216: l_debug_prefix VARCHAR2(30) := '';
1217: BEGIN
1218: -- Debug info.
1219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1220: debug(p_message=>'synchronize_group_members_wf (+)',
1221: p_prefix =>l_debug_prefix,
1222: p_msg_level=>fnd_log.level_statement);
1223: END IF;

Line 1222: p_msg_level=>fnd_log.level_statement);

1218: -- Debug info.
1219: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1220: debug(p_message=>'synchronize_group_members_wf (+)',
1221: p_prefix =>l_debug_prefix,
1222: p_msg_level=>fnd_log.level_statement);
1223: END IF;
1224:
1225: log_msg_hdr3 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR3');
1226: log_message8 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_MSG8');

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

1247: -- Fetched user_orig_system,user_orig_system_id are passed to propagate_user_role.
1248: FOR i IN c_wlur_grp_mem_del LOOP
1249: BEGIN
1250: -- Debug info.
1251: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1252: debug(p_message=>' c_wlur_grp_mem_del Resource Id : '||i.resource_id,
1253: p_prefix =>l_debug_prefix,
1254: p_msg_level=>fnd_log.level_statement);
1255: END IF;

Line 1254: p_msg_level=>fnd_log.level_statement);

1250: -- Debug info.
1251: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1252: debug(p_message=>' c_wlur_grp_mem_del Resource Id : '||i.resource_id,
1253: p_prefix =>l_debug_prefix,
1254: p_msg_level=>fnd_log.level_statement);
1255: END IF;
1256: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => i.resource_id,
1257: X_ROLE_NAME => l_user_name,
1258: X_ORIG_SYSTEM => l_user_orig_system,

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

1257: X_ROLE_NAME => l_user_name,
1258: X_ORIG_SYSTEM => l_user_orig_system,
1259: X_ORIG_SYSTEM_ID => l_user_orig_system_id);
1260: -- Debug info.
1261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1262: debug(p_message=>' User Name for Resource Id '||i.resource_id|| ' is '||l_user_name,
1263: p_prefix =>l_debug_prefix,
1264: p_msg_level=>fnd_log.level_statement);
1265: END IF;

Line 1264: p_msg_level=>fnd_log.level_statement);

1260: -- Debug info.
1261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1262: debug(p_message=>' User Name for Resource Id '||i.resource_id|| ' is '||l_user_name,
1263: p_prefix =>l_debug_prefix,
1264: p_msg_level=>fnd_log.level_statement);
1265: END IF;
1266: IF l_user_name IS NOT NULL THEN
1267: -- Debug info.
1268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1264: p_msg_level=>fnd_log.level_statement);
1265: END IF;
1266: IF l_user_name IS NOT NULL THEN
1267: -- Debug info.
1268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1269: debug(p_message=>' User Name is not NULL propagate_user_role API is called.',
1270: p_prefix =>l_debug_prefix,
1271: p_msg_level=>fnd_log.level_statement);
1272: END IF;

Line 1271: p_msg_level=>fnd_log.level_statement);

1267: -- Debug info.
1268: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1269: debug(p_message=>' User Name is not NULL propagate_user_role API is called.',
1270: p_prefix =>l_debug_prefix,
1271: p_msg_level=>fnd_log.level_statement);
1272: END IF;
1273:
1274: BEGIN
1275: Wf_local_synch.propagate_user_role (

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

1378: --fnd_file.put_line (fnd_file.log,'Successfully created Workflow User Role Records, for its corresponding records in
1379: --Resource Group Members tables. This is for Resources who category is Employee, Party, Partner or Supplier Contact.');
1380: fnd_file.new_line (fnd_file.log,1);
1381: -- Debug info.
1382: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1383: debug(p_message=>'synchronize_group_members_wf (-)',
1384: p_prefix =>l_debug_prefix,
1385: p_msg_level=>fnd_log.level_statement);
1386: END IF;

Line 1385: p_msg_level=>fnd_log.level_statement);

1381: -- Debug info.
1382: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1383: debug(p_message=>'synchronize_group_members_wf (-)',
1384: p_prefix =>l_debug_prefix,
1385: p_msg_level=>fnd_log.level_statement);
1386: END IF;
1387:
1388: EXCEPTION
1389: WHEN OTHERS THEN