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 FND_LOG

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

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

Line 53: p_msg_level=>fnd_log.level_procedure);

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
56: other_exp_val := null;
57: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN

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

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

Line 61: p_msg_level=>fnd_log.level_error);

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';
64: /* ELSE -- '_U2'
65: IF g_debug THEN

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

119: and int.party_orig_system = P_DML_RECORD.OS
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;

Line 126: p_msg_level=>fnd_log.level_procedure);

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;
129:
130: --------------------------------------

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

330: l_final_sql VARCHAR2(15000);
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;

Line 337: p_msg_level=>fnd_log.level_procedure);

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
340: hz_utility_v2pub.debug(p_message=>'PSU:RERUN:' || P_DML_RECORD.RERUN,
341: p_prefix =>l_debug_prefix,

Line 339: IF fnd_log.level_statement>=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
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,

Line 342: p_msg_level=>fnd_log.level_statement);

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,
345: p_msg_level=>fnd_log.level_statement);
346: END IF;

Line 345: p_msg_level=>fnd_log.level_statement);

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:
348: savepoint process_insert_psu_pvt;
349:

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

400: P_DML_RECORD.FROM_OSR,
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;

Line 407: p_msg_level=>fnd_log.level_procedure);

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
410: WHEN DUP_VAL_ON_INDEX THEN
411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert partysiteuses dup val exception: ' || SQLERRM);

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

454: savepoint load_partysiteuses_pvt;
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;

Line 461: p_msg_level=>fnd_log.level_procedure);

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

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

473: ,x_msg_count => x_msg_count
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;

Line 480: p_msg_level=>fnd_log.level_procedure);

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
483: --disable_debug;
484:

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

505: p_count => x_msg_count,
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,

Line 512: p_msg_level=>fnd_log.level_error);

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',
515: p_msg_level=>fnd_log.level_error);
516: END IF;

Line 515: p_msg_level=>fnd_log.level_error);

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:
518: ROLLBACK TO load_partysiteuses_pvt;
519: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading partysiteuses');