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 FND_LOG

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

205: dss_msg_data VARCHAR2(2000):= null;
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;

Line 212: p_msg_level=>fnd_log.level_procedure);

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.
215: Only check for update. */
216: FOR i IN 1..l_relationship_id.count LOOP

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

226: x_msg_data => dss_msg_data);
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;

Line 233: p_msg_level=>fnd_log.level_procedure);

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;
236:
237:

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

246: l_debug_prefix VARCHAR2(30) := '';
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;

Line 253: p_msg_level=>fnd_log.level_procedure);

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:
256: /**********************************/
257: /* Validation and Error reporting */

Line 274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 277: p_msg_level=>fnd_log.level_error);

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;
280:
281: /* Check for any exceptions during DML */

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

344: from dual
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;

Line 351: p_msg_level=>fnd_log.level_procedure);

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;
354:
355:

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

364: other_exp_val VARCHAR2(1) := 'Y';
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;

Line 371: p_msg_level=>fnd_log.level_procedure);

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:
374: /* other entities need to add checking for other constraints */
375: if (P_DUP_VAL_EXP = 'Y') then

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

433: and rel_sg.sub_orig_system_reference
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;

Line 440: p_msg_level=>fnd_log.level_procedure);

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;
443:
444:

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

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

Line 1146: p_msg_level=>fnd_log.level_procedure);

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:
1149: FND_MSG_PUB.initialize;
1150:

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

1255: END IF;
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;

Line 1262: p_msg_level=>fnd_log.level_statement);

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:
1265: IF P_DML_RECORD.OS = 'DNB' THEN
1266: /* End date old DNB parents */

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

1289: and e.int_row_id is not null));
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;

Line 1296: p_msg_level=>fnd_log.level_procedure);

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:
1299: EXCEPTION
1300: WHEN DUP_VAL_ON_INDEX THEN

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

1398: BEGIN
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;

Line 1405: p_msg_level=>fnd_log.level_procedure);

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:
1408: FND_MSG_PUB.initialize;
1409:

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

1483: /*** Update HZ_RELATIONSHIPS (Both directions) ***/
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;

Line 1490: p_msg_level=>fnd_log.level_statement);

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:
1493: /*
1494: Reason for disallowing update to start_date and end_date:

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

1655: report_errors(P_DML_RECORD, 'U', l_dml_exception);
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;

Line 1662: p_msg_level=>fnd_log.level_procedure);

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:
1665: EXCEPTION
1666:

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

1703: FND_MSG_PUB.initialize;
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;

Line 1710: p_msg_level=>fnd_log.level_procedure);

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.
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;
1714:

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

1730: ,x_msg_data => x_msg_data
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;

Line 1737: p_msg_level=>fnd_log.level_procedure);

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:
1740: -- if enabled, disable debug
1741: --disable_debug;