APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on HZ_UTILITY_V2PUB

Line 53: hz_utility_v2pub.debug(p_message=>'ROLE: populate_error_table()+',

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;
57: IF(P_DUP_VAL_EXP = 'Y') then

Line 61: hz_utility_v2pub.debug(p_message=>'ROLE: HZ_ORG_CONTACT_ROLES_U1 violated',

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;
65:

Line 69: hz_utility_v2pub.debug(p_message=>'ROLE: HZ_ORG_CONTACT_ROLES_U2 violated',

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;
73:

Line 131: hz_utility_v2pub.debug(p_message=>'ROLE:populate_error_table()-',

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;
135: END populate_error_table;

Line 149: hz_utility_v2pub.enable_debug;

145: IF g_debug_count = 1 THEN
146: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
147: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
148: THEN
149: hz_utility_v2pub.enable_debug;
150: g_debug := TRUE;
151: END IF;
152: END IF;
153: END enable_debug;

Line 163: hz_utility_v2pub.disable_debug;

159:
160: IF g_debug THEN
161: g_debug_count := g_debug_count - 1;
162: IF g_debug_count = 0 THEN
163: hz_utility_v2pub.disable_debug;
164: g_debug := FALSE;
165: END IF;
166: END IF;
167:

Line 350: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',

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

Line 355: hz_utility_v2pub.debug(p_message=>'ROLE:RERUN:' || P_DML_RECORD.RERUN,

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,
359: p_prefix =>l_debug_prefix,

Line 358: hz_utility_v2pub.debug(p_message=>'ROLE:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,

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;
362:

Line 419: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles-',

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;
423:

Line 474: hz_utility_v2pub.debug(p_message=>'ROLE:process_insert_contactroles+',

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;
478:

Line 493: hz_utility_v2pub.debug(p_message=>'ROLE:load_contactroles-',

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;
497: -- if enabled, disable debug