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_PARTY_SITE_USE_PKG dependencies on HZ_UTILITY_V2PUB

Line 51: hz_utility_v2pub.debug(p_message=>'PSU:populate_error_table()+',

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

Line 59: hz_utility_v2pub.debug(p_message=>'PSU: HZ_PARTY_SITE_USES_U1 violated',

55: IF(P_DUP_VAL_EXP = 'Y') then
56: other_exp_val := null;
57: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN
58: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
59: hz_utility_v2pub.debug(p_message=>'PSU: HZ_PARTY_SITE_USES_U1 violated',
60: p_prefix=>'ERROR',
61: p_msg_level=>fnd_log.level_error);
62: END IF;
63: dup_val_exp_val := 'A';

Line 66: hz_utility_v2pub.debug('PSU: violated');

62: END IF;
63: dup_val_exp_val := 'A';
64: /* ELSE -- '_U2'
65: IF g_debug THEN
66: hz_utility_v2pub.debug('PSU: violated');
67: END IF;
68: dup_val_exp_val := 'B'; */
69: END IF;
70: END IF;

Line 124: hz_utility_v2pub.debug(p_message=>'PSU:populate_error_table()-',

120: and int.party_orig_system_reference
121: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
122: );
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'PSU:populate_error_table()-',
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
128: END populate_error_table;

Line 142: hz_utility_v2pub.enable_debug;

138: IF g_debug_count = 1 THEN
139: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
140: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
141: THEN
142: hz_utility_v2pub.enable_debug;
143: g_debug := TRUE;
144: END IF;
145: END IF;
146: END enable_debug;

Line 156: hz_utility_v2pub.disable_debug;

152:
153: IF g_debug THEN
154: g_debug_count := g_debug_count - 1;
155: IF g_debug_count = 0 THEN
156: hz_utility_v2pub.disable_debug;
157: g_debug := FALSE;
158: END IF;
159: END IF;
160:

Line 335: hz_utility_v2pub.debug(p_message=>'PSU:process_insert_partysiteuses+',

331: l_dml_exception varchar2(1) := 'N';
332: l_debug_prefix VARCHAR2(30) := '';
333: BEGIN
334: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
335: hz_utility_v2pub.debug(p_message=>'PSU:process_insert_partysiteuses+',
336: p_prefix=>l_debug_prefix,
337: p_msg_level=>fnd_log.level_procedure);
338: END IF;
339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 340: hz_utility_v2pub.debug(p_message=>'PSU:RERUN:' || P_DML_RECORD.RERUN,

336: p_prefix=>l_debug_prefix,
337: p_msg_level=>fnd_log.level_procedure);
338: END IF;
339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug(p_message=>'PSU:RERUN:' || P_DML_RECORD.RERUN,
341: p_prefix =>l_debug_prefix,
342: p_msg_level=>fnd_log.level_statement);
343: hz_utility_v2pub.debug(p_message=>'PSU:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
344: p_prefix =>l_debug_prefix,

Line 343: hz_utility_v2pub.debug(p_message=>'PSU:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,

339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug(p_message=>'PSU:RERUN:' || P_DML_RECORD.RERUN,
341: p_prefix =>l_debug_prefix,
342: p_msg_level=>fnd_log.level_statement);
343: hz_utility_v2pub.debug(p_message=>'PSU:ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
344: p_prefix =>l_debug_prefix,
345: p_msg_level=>fnd_log.level_statement);
346: END IF;
347:

Line 405: hz_utility_v2pub.debug(p_message=>'PSU:process_insert_partysiteuses-',

401: P_DML_RECORD.TO_OSR,
402: P_DML_RECORD.BATCH_MODE_FLAG;
403:
404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
405: hz_utility_v2pub.debug(p_message=>'PSU:process_insert_partysiteuses-',
406: p_prefix=>l_debug_prefix,
407: p_msg_level=>fnd_log.level_procedure);
408: END IF;
409: EXCEPTION

Line 459: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses()+',

455:
456: -- Check if API is called in debug mode. If yes, enable debug.
457: --enable_debug;
458: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
459: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses()+',
460: p_prefix=>l_debug_prefix,
461: p_msg_level=>fnd_log.level_procedure);
462: END IF;
463:

Line 478: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses()-',

474: ,x_msg_data => x_msg_data
475: );
476:
477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
478: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses()-',
479: p_prefix=>l_debug_prefix,
480: p_msg_level=>fnd_log.level_procedure);
481: END IF;
482: -- if enabled, disable debug

Line 510: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses Exception:',

506: p_data => x_msg_data);
507:
508: WHEN OTHERS THEN
509: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
510: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses Exception:',
511: p_prefix=>'SQL ERROR',
512: p_msg_level=>fnd_log.level_error);
513: hz_utility_v2pub.debug(p_message=>SQLERRM,
514: p_prefix=>'SQL ERROR',

Line 513: hz_utility_v2pub.debug(p_message=>SQLERRM,

509: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
510: hz_utility_v2pub.debug(p_message=>'PSU:load_partysiteuses Exception:',
511: p_prefix=>'SQL ERROR',
512: p_msg_level=>fnd_log.level_error);
513: hz_utility_v2pub.debug(p_message=>SQLERRM,
514: p_prefix=>'SQL ERROR',
515: p_msg_level=>fnd_log.level_error);
516: END IF;
517: