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.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on FND_LOG

Line 52: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

48: other_exp_val VARCHAR2(1) := 'Y';
49: l_debug_prefix VARCHAR2(30) := '';
50: BEGIN
51:
52: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
53: hz_utility_v2pub.debug(p_message=>'ROLE: populate_error_table()+',
54: p_prefix=>l_debug_prefix,
55: p_msg_level=>fnd_log.level_procedure);
56: END IF;

Line 55: p_msg_level=>fnd_log.level_procedure);

51:
52: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
53: hz_utility_v2pub.debug(p_message=>'ROLE: populate_error_table()+',
54: p_prefix=>l_debug_prefix,
55: p_msg_level=>fnd_log.level_procedure);
56: END IF;
57: IF(P_DUP_VAL_EXP = 'Y') then
58: other_exp_val := null;
59: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN

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

56: END IF;
57: IF(P_DUP_VAL_EXP = 'Y') then
58: other_exp_val := null;
59: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN
60: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
61: hz_utility_v2pub.debug(p_message=>'ROLE: HZ_ORG_CONTACT_ROLES_U1 violated',
62: p_prefix =>l_debug_prefix,
63: p_msg_level=>fnd_log.level_statement);
64: END IF;

Line 63: p_msg_level=>fnd_log.level_statement);

59: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN
60: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
61: hz_utility_v2pub.debug(p_message=>'ROLE: HZ_ORG_CONTACT_ROLES_U1 violated',
62: p_prefix =>l_debug_prefix,
63: p_msg_level=>fnd_log.level_statement);
64: END IF;
65:
66: dup_val_exp_val := 'A';
67: ELSE -- '_U2'

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

64: END IF;
65:
66: dup_val_exp_val := 'A';
67: ELSE -- '_U2'
68: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
69: hz_utility_v2pub.debug(p_message=>'ROLE: HZ_ORG_CONTACT_ROLES_U2 violated',
70: p_prefix =>l_debug_prefix,
71: p_msg_level=>fnd_log.level_statement);
72: END IF;

Line 71: p_msg_level=>fnd_log.level_statement);

67: ELSE -- '_U2'
68: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
69: hz_utility_v2pub.debug(p_message=>'ROLE: HZ_ORG_CONTACT_ROLES_U2 violated',
70: p_prefix =>l_debug_prefix,
71: p_msg_level=>fnd_log.level_statement);
72: END IF;
73:
74: dup_val_exp_val := 'B';
75: END IF;

Line 130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

126: and int.sub_orig_system = P_DML_RECORD.OS
127: and int.sub_orig_system_reference
128: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
129: );
130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
131: hz_utility_v2pub.debug(p_message=>'ROLE:populate_error_table()-',
132: p_prefix=>l_debug_prefix,
133: p_msg_level=>fnd_log.level_procedure);
134: END IF;

Line 133: p_msg_level=>fnd_log.level_procedure);

129: );
130: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
131: hz_utility_v2pub.debug(p_message=>'ROLE:populate_error_table()-',
132: p_prefix=>l_debug_prefix,
133: p_msg_level=>fnd_log.level_procedure);
134: END IF;
135: END populate_error_table;
136:
137: --------------------------------------

Line 349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

345: l_debug_prefix VARCHAR2(30) := '';
346:
347: BEGIN
348:
349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
350: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',
351: p_prefix=>l_debug_prefix,
352: p_msg_level=>fnd_log.level_procedure);
353: END IF;

Line 352: p_msg_level=>fnd_log.level_procedure);

348:
349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
350: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',
351: p_prefix=>l_debug_prefix,
352: p_msg_level=>fnd_log.level_procedure);
353: END IF;
354: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
355: hz_utility_v2pub.debug(p_message=>'ROLE:RERUN:' || P_DML_RECORD.RERUN,
356: p_prefix =>l_debug_prefix,

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

350: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',
351: p_prefix=>l_debug_prefix,
352: p_msg_level=>fnd_log.level_procedure);
353: END IF;
354: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
355: hz_utility_v2pub.debug(p_message=>'ROLE:RERUN:' || P_DML_RECORD.RERUN,
356: p_prefix =>l_debug_prefix,
357: p_msg_level=>fnd_log.level_statement);
358: hz_utility_v2pub.debug(p_message=>'ROLE:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,

Line 357: p_msg_level=>fnd_log.level_statement);

353: END IF;
354: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
355: hz_utility_v2pub.debug(p_message=>'ROLE:RERUN:' || P_DML_RECORD.RERUN,
356: p_prefix =>l_debug_prefix,
357: p_msg_level=>fnd_log.level_statement);
358: hz_utility_v2pub.debug(p_message=>'ROLE:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
359: p_prefix =>l_debug_prefix,
360: p_msg_level=>fnd_log.level_statement);
361: END IF;

Line 360: p_msg_level=>fnd_log.level_statement);

356: p_prefix =>l_debug_prefix,
357: p_msg_level=>fnd_log.level_statement);
358: hz_utility_v2pub.debug(p_message=>'ROLE:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
359: p_prefix =>l_debug_prefix,
360: p_msg_level=>fnd_log.level_statement);
361: END IF;
362:
363: savepoint load_contactroles_pvt;
364:

Line 418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

414: P_DML_RECORD.FROM_OSR,
415: P_DML_RECORD.TO_OSR,
416: P_DML_RECORD.BATCH_MODE_FLAG;
417:
418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
419: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles-',
420: p_prefix=>l_debug_prefix,
421: p_msg_level=>fnd_log.level_procedure);
422: END IF;

Line 421: p_msg_level=>fnd_log.level_procedure);

417:
418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
419: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles-',
420: p_prefix=>l_debug_prefix,
421: p_msg_level=>fnd_log.level_procedure);
422: END IF;
423:
424: EXCEPTION
425: WHEN DUP_VAL_ON_INDEX THEN

Line 473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

469:
470: -- Check if API is called in debug mode. If yes, enable debug.
471: --enable_debug;
472:
473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
474: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',
475: p_prefix=>l_debug_prefix,
476: p_msg_level=>fnd_log.level_procedure);
477: END IF;

Line 476: p_msg_level=>fnd_log.level_procedure);

472:
473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
474: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',
475: p_prefix=>l_debug_prefix,
476: p_msg_level=>fnd_log.level_procedure);
477: END IF;
478:
479: FND_MSG_PUB.initialize;
480:

Line 492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

488: ,x_msg_count => x_msg_count
489: ,x_msg_data => x_msg_data
490: );
491:
492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
493: hz_utility_v2pub.debug(p_message=>'ROLE:load_contactroles-',
494: p_prefix=>l_debug_prefix,
495: p_msg_level=>fnd_log.level_procedure);
496: END IF;

Line 495: p_msg_level=>fnd_log.level_procedure);

491:
492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
493: hz_utility_v2pub.debug(p_message=>'ROLE:load_contactroles-',
494: p_prefix=>l_debug_prefix,
495: p_msg_level=>fnd_log.level_procedure);
496: END IF;
497: -- if enabled, disable debug
498: --disable_debug;
499: