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

Line 69: hz_utility_v2pub.enable_debug;

65: IF g_debug_count = 1 THEN
66: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
67: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
68: THEN
69: hz_utility_v2pub.enable_debug;
70: g_debug := TRUE;
71: END IF;
72: END IF;
73: END enable_debug;

Line 81: hz_utility_v2pub.disable_debug;

77:
78: IF g_debug THEN
79: g_debug_count := g_debug_count - 1;
80: IF g_debug_count = 0 THEN
81: hz_utility_v2pub.disable_debug;
82: g_debug := FALSE;
83: END IF;
84: END IF;
85:

Line 210: hz_utility_v2pub.debug(p_message=>'REL:validate_DSS_security()+',

206: l_debug_prefix VARCHAR2(30) := '';
207:
208: BEGIN
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'REL:validate_DSS_security()+',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214: /* Check if the DSS security is granted to the user.

Line 231: hz_utility_v2pub.debug(p_message=>'REL:validate_DSS_security()-',

227:
228: END LOOP;
229:
230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
231: hz_utility_v2pub.debug(p_message=>'REL:validate_DSS_security()-',
232: p_prefix=>l_debug_prefix,
233: p_msg_level=>fnd_log.level_procedure);
234: END IF;
235: END validate_DSS_security;

Line 251: hz_utility_v2pub.debug(p_message=>'REL:report_errors()+',

247: l_exception_exists FLAG_ERROR;
248: BEGIN
249:
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'REL:report_errors()+',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;
255:

Line 275: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,

271: FOR k IN 1..l_relationship_id.count LOOP
272:
273: IF SQL%BULK_ROWCOUNT(k) = 0 THEN
274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
275: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
276: p_prefix=>'ERROR',
277: p_msg_level=>fnd_log.level_error);
278: END IF;
279: l_num_row_processed(k) := 0;

Line 349: hz_utility_v2pub.debug(p_message=>'REL:report_errors()-',

345: where l_num_row_processed(j) = 0
346: );
347:
348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
349: hz_utility_v2pub.debug(p_message=>'REL:report_errors()-',
350: p_prefix=>l_debug_prefix,
351: p_msg_level=>fnd_log.level_procedure);
352: END IF;
353: END report_errors;

Line 369: hz_utility_v2pub.debug(p_message=>'REL:populate_error_table()+',

365: l_debug_prefix VARCHAR2(30) := '';
366: BEGIN
367:
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'REL:populate_error_table()+',
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;
373:

Line 438: hz_utility_v2pub.debug(p_message=>'REL:populate_error_table()-',

434: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
435: );
436:
437: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
438: hz_utility_v2pub.debug(p_message=>'REL:populate_error_table()-',
439: p_prefix=>l_debug_prefix,
440: p_msg_level=>fnd_log.level_procedure);
441: END IF;
442: END populate_error_table;

Line 1144: hz_utility_v2pub.debug(p_message=>'REL:process_insert_rels()+',

1140: BEGIN
1141: savepoint process_insert_rels_pvt;
1142:
1143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1144: hz_utility_v2pub.debug(p_message=>'REL:process_insert_rels()+',
1145: p_prefix=>l_debug_prefix,
1146: p_msg_level=>fnd_log.level_procedure);
1147: END IF;
1148:

Line 1260: hz_utility_v2pub.debug(p_message=>'REL:Rows inserted in MTI = ' || SQL%ROWCOUNT,

1256:
1257: END IF;
1258:
1259: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1260: hz_utility_v2pub.debug(p_message=>'REL:Rows inserted in MTI = ' || SQL%ROWCOUNT,
1261: p_prefix =>l_debug_prefix,
1262: p_msg_level=>fnd_log.level_statement);
1263: END IF;
1264:

Line 1294: hz_utility_v2pub.debug(p_message=>'REL:process_insert_rels()-',

1290:
1291: END IF;
1292:
1293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1294: hz_utility_v2pub.debug(p_message=>'REL:process_insert_rels()-',
1295: p_prefix=>l_debug_prefix,
1296: p_msg_level=>fnd_log.level_procedure);
1297: END IF;
1298:

Line 1403: hz_utility_v2pub.debug(p_message=>'REL:process_update_rels()+',

1399:
1400: savepoint process_update_rels_pvt;
1401:
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'REL:process_update_rels()+',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407:

Line 1488: hz_utility_v2pub.debug(p_message=>'REL:Update relationships',

1484: /*************************************************/
1485:
1486:
1487: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1488: hz_utility_v2pub.debug(p_message=>'REL:Update relationships',
1489: p_prefix =>l_debug_prefix,
1490: p_msg_level=>fnd_log.level_statement);
1491: END IF;
1492:

Line 1660: hz_utility_v2pub.debug(p_message=>'REL:process_update_rels()-',

1656:
1657: CLOSE c_handle_update;
1658:
1659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1660: hz_utility_v2pub.debug(p_message=>'REL:process_update_rels()-',
1661: p_prefix=>l_debug_prefix,
1662: p_msg_level=>fnd_log.level_procedure);
1663: END IF;
1664:

Line 1708: hz_utility_v2pub.debug(p_message=>'REL:load_relationships()+',

1704:
1705: -- Check if API is called in debug mode. If yes, enable debug.
1706: --enable_debug;
1707: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1708: hz_utility_v2pub.debug(p_message=>'REL:load_relationships()+',
1709: p_prefix=>l_debug_prefix,
1710: p_msg_level=>fnd_log.level_procedure);
1711: END IF;
1712: --Initialize API return status to success.

Line 1735: hz_utility_v2pub.debug(p_message=>'REL:load_relationships()-',

1731: );
1732: END IF;
1733:
1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>'REL:load_relationships()-',
1736: p_prefix=>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_procedure);
1738: END IF;
1739: