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_FINNUMBERS_PKG dependencies on FND_LOG

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

76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: --enable_debug;
79: -- Debug info.
80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
81: hz_utility_v2pub.debug(p_message=>'FN:load_finnumbers()+',
82: p_prefix=>l_debug_prefix,
83: p_msg_level=>fnd_log.level_procedure);
84: END IF;

Line 83: p_msg_level=>fnd_log.level_procedure);

79: -- Debug info.
80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
81: hz_utility_v2pub.debug(p_message=>'FN:load_finnumbers()+',
82: p_prefix=>l_debug_prefix,
83: p_msg_level=>fnd_log.level_procedure);
84: END IF;
85:
86: process_insert_finnumbers(P_DML_RECORD,
87: x_return_status, x_msg_count, x_msg_data );

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

90: process_update_finnumbers(P_DML_RECORD,
91: x_return_status, x_msg_count, x_msg_data );
92: END IF;
93:
94: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
95: hz_utility_v2pub.debug(p_message=>'FN:load_finnumbers()-',
96: p_prefix=>l_debug_prefix,
97: p_msg_level=>fnd_log.level_procedure);
98: END IF;

Line 97: p_msg_level=>fnd_log.level_procedure);

93:
94: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
95: hz_utility_v2pub.debug(p_message=>'FN:load_finnumbers()-',
96: p_prefix=>l_debug_prefix,
97: p_msg_level=>fnd_log.level_procedure);
98: END IF;
99: --disable_debug;
100:
101: EXCEPTION

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

126: p_count => x_msg_count,
127: p_data => x_msg_data);
128:
129: WHEN OTHERS THEN
130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
131: hz_utility_v2pub.debug(p_message=>'load_finnumbers Exception: ',
132: p_prefix=>'SQL ERROR',
133: p_msg_level=>fnd_log.level_error);
134: hz_utility_v2pub.debug(p_message=>SQLERRM,

Line 133: p_msg_level=>fnd_log.level_error);

129: WHEN OTHERS THEN
130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
131: hz_utility_v2pub.debug(p_message=>'load_finnumbers Exception: ',
132: p_prefix=>'SQL ERROR',
133: p_msg_level=>fnd_log.level_error);
134: hz_utility_v2pub.debug(p_message=>SQLERRM,
135: p_prefix=>'SQL ERROR',
136: p_msg_level=>fnd_log.level_error);
137: END IF;

Line 136: p_msg_level=>fnd_log.level_error);

132: p_prefix=>'SQL ERROR',
133: p_msg_level=>fnd_log.level_error);
134: hz_utility_v2pub.debug(p_message=>SQLERRM,
135: p_prefix=>'SQL ERROR',
136: p_msg_level=>fnd_log.level_error);
137: END IF;
138: ----dbms_output.put_line('load_finnumbers Exception: ');
139:
140: ROLLBACK TO load_finnumbers_pvt;

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

182: --l_where_enabled_lookup_sql varchar2(3000) := ' AND ( fin_num_l.ENABLED_FLAG(+) = ''Y'' )';
183:
184: BEGIN
185:
186: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
187: hz_utility_v2pub.debug(p_message=>'FN:open_update_cursor()+',
188: p_prefix=>l_debug_prefix,
189: p_msg_level=>fnd_log.level_procedure);
190: END IF;

Line 189: p_msg_level=>fnd_log.level_procedure);

185:
186: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
187: hz_utility_v2pub.debug(p_message=>'FN:open_update_cursor()+',
188: p_prefix=>l_debug_prefix,
189: p_msg_level=>fnd_log.level_procedure);
190: END IF;
191:
192: if(P_DML_RECORD.RERUN='Y') then
193: l_sql_query := l_sql_query || l_re_run_clause;

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

200: P_DML_RECORD.BATCH_ID, P_DML_RECORD.BATCH_MODE_FLAG,
201: P_DML_RECORD.OS, P_DML_RECORD.FROM_OSR, P_DML_RECORD.TO_OSR;
202:
203:
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'FN:open_update_cursor()-',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;

Line 207: p_msg_level=>fnd_log.level_procedure);

203:
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'FN:open_update_cursor()-',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
209: END open_update_cursor;
210:
211:

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

382: TRUNC(NVL( createdby_l.START_DATE_ACTIVE,:17 ) ) AND
383: TRUNC(NVL( createdby_l.END_DATE_ACTIVE,:17 ) ) )';
384:
385: BEGIN
386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug(p_message=>'process_insert_finnumbers()+',
388: p_prefix=>l_debug_prefix,
389: p_msg_level=>fnd_log.level_procedure);
390: END IF;

Line 389: p_msg_level=>fnd_log.level_procedure);

385: BEGIN
386: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug(p_message=>'process_insert_finnumbers()+',
388: p_prefix=>l_debug_prefix,
389: p_msg_level=>fnd_log.level_procedure);
390: END IF;
391: savepoint process_insert_finnumbers_pvt;
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393:

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

420: P_DML_RECORD.OS, P_DML_RECORD.FROM_OSR, P_DML_RECORD.TO_OSR,
421: c_end_date, P_DML_RECORD.BATCH_MODE_FLAG;
422: end if;
423:
424: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
425: hz_utility_v2pub.debug(p_message=>'process_insert_finnumbers()-',
426: p_prefix=>l_debug_prefix,
427: p_msg_level=>fnd_log.level_procedure);
428: END IF;

Line 427: p_msg_level=>fnd_log.level_procedure);

423:
424: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
425: hz_utility_v2pub.debug(p_message=>'process_insert_finnumbers()-',
426: p_prefix=>l_debug_prefix,
427: p_msg_level=>fnd_log.level_procedure);
428: END IF;
429:
430: EXCEPTION
431: WHEN DUP_VAL_ON_INDEX THEN

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

459: dup_val_exp_val VARCHAR2(1) := null;
460: other_exp_val VARCHAR2(1) := 'Y';
461: l_debug_prefix VARCHAR2(30) := '';
462: BEGIN
463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
464: hz_utility_v2pub.debug(p_message=>'FN:populate_error_table()+',
465: p_prefix=>l_debug_prefix,
466: p_msg_level=>fnd_log.level_procedure);
467: END IF;

Line 466: p_msg_level=>fnd_log.level_procedure);

462: BEGIN
463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
464: hz_utility_v2pub.debug(p_message=>'FN:populate_error_table()+',
465: p_prefix=>l_debug_prefix,
466: p_msg_level=>fnd_log.level_procedure);
467: END IF;
468:
469: if (P_DUP_VAL_EXP = 'Y') then
470: dup_val_exp_val := 'Y';

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

518: and fn_sg.party_orig_system_reference
519: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
520: );
521:
522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug(p_message=>'FN:populate_error_table()-',
524: p_prefix=>l_debug_prefix,
525: p_msg_level=>fnd_log.level_procedure);
526: END IF;

Line 525: p_msg_level=>fnd_log.level_procedure);

521:
522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug(p_message=>'FN:populate_error_table()-',
524: p_prefix=>l_debug_prefix,
525: p_msg_level=>fnd_log.level_procedure);
526: END IF;
527: END populate_error_table;
528:
529:

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

536: l_dml_exception varchar2(1) := 'N';
537: l_debug_prefix VARCHAR2(30) := '';
538: BEGIN
539:
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'FN:process_update_finnumbers()+',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;

Line 543: p_msg_level=>fnd_log.level_procedure);

539:
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'FN:process_update_finnumbers()+',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545: savepoint process_update_finnumbers_pvt;
546: FND_MSG_PUB.initialize;
547: --Initialize API return status to success.

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

588: and l_error_flag(j) is null;
589:
590: report_errors(P_DML_RECORD, l_dml_exception);
591:
592: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
593: hz_utility_v2pub.debug(p_message=>'FN:process_update_finnumbers()-',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: END IF;

Line 595: p_msg_level=>fnd_log.level_procedure);

591:
592: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
593: hz_utility_v2pub.debug(p_message=>'FN:process_update_finnumbers()-',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: END IF;
597:
598: EXCEPTION
599: WHEN OTHERS THEN

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

618: num_exp NUMBER;
619: exp_ind NUMBER := 1;
620: l_debug_prefix VARCHAR2(30) := '';
621: BEGIN
622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
623: hz_utility_v2pub.debug(p_message=>'FN:report_errors()+',
624: p_prefix=>l_debug_prefix,
625: p_msg_level=>fnd_log.level_procedure);
626: END IF;

Line 625: p_msg_level=>fnd_log.level_procedure);

621: BEGIN
622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
623: hz_utility_v2pub.debug(p_message=>'FN:report_errors()+',
624: p_prefix=>l_debug_prefix,
625: p_msg_level=>fnd_log.level_procedure);
626: END IF;
627:
628: /**********************************/
629: /* Validation and Error reporting */

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

642:
643: FOR k IN 1..l_fn_id.count LOOP
644: IF SQL%BULK_ROWCOUNT(k) = 0
645: THEN
646: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
647: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
648: p_prefix=>'ERROR',
649: p_msg_level=>fnd_log.level_error);
650: END IF;

Line 649: p_msg_level=>fnd_log.level_error);

645: THEN
646: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
647: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
648: p_prefix=>'ERROR',
649: p_msg_level=>fnd_log.level_error);
650: END IF;
651: l_num_row_processed(k) := 0;
652:
653: /* Check for any exceptions during DML */

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

710: from dual
711: where l_num_row_processed(j) = 0
712: );
713:
714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug(p_message=>'FN:report_errors()-',
716: p_prefix=>l_debug_prefix,
717: p_msg_level=>fnd_log.level_procedure);
718: END IF;

Line 717: p_msg_level=>fnd_log.level_procedure);

713:
714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug(p_message=>'FN:report_errors()-',
716: p_prefix=>l_debug_prefix,
717: p_msg_level=>fnd_log.level_procedure);
718: END IF;
719: END report_errors;
720:
721: --------------------------------------