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.EDW_COLLECTION_UTIL dependencies on EDW_LOG

Line 32: edw_log.put_line (' Setup of '|| p_object_name|| ' failed. Error '||sqlerrm,FND_LOG.LEVEL_ERROR);

28: return true;
29: EXCEPTION
30: WHEN OTHERS
31: THEN
32: edw_log.put_line (' Setup of '|| p_object_name|| ' failed. Error '||sqlerrm,FND_LOG.LEVEL_ERROR);
33: RETURN (FALSE);
34: END setup;
35:
36: FUNCTION setup (

Line 153: edw_log.put_line (

149:
150: -- End reading source options
151: IF l_status
152: THEN
153: edw_log.put_line (
154: 'Object Settings: Degree of Parallelism : '
155: || g_parallel,FND_LOG.LEVEL_STATEMENT
156: );
157: edw_log.put_line (

Line 157: edw_log.put_line (

153: edw_log.put_line (
154: 'Object Settings: Degree of Parallelism : '
155: || g_parallel,FND_LOG.LEVEL_STATEMENT
156: );
157: edw_log.put_line (
158: 'Object Settings: Commit Size : '
159: || g_push_size,FND_LOG.LEVEL_STATEMENT
160: );
161: edw_log.put_line (

Line 161: edw_log.put_line (

157: edw_log.put_line (
158: 'Object Settings: Commit Size : '
159: || g_push_size,FND_LOG.LEVEL_STATEMENT
160: );
161: edw_log.put_line (
162: 'Object Settings: Operational Tablespace : '
163: || g_op_tablespace,FND_LOG.LEVEL_STATEMENT
164: );
165: edw_log.put_line (

Line 165: edw_log.put_line (

161: edw_log.put_line (
162: 'Object Settings: Operational Tablespace : '
163: || g_op_tablespace,FND_LOG.LEVEL_STATEMENT
164: );
165: edw_log.put_line (
166: 'Object Settings: Rollback Segment : '
167: || g_rbs,FND_LOG.LEVEL_STATEMENT
168: );
169:

Line 170: /*l_dir := fnd_profile.VALUE ('EDW_LOGFILE_DIR');

166: 'Object Settings: Rollback Segment : '
167: || g_rbs,FND_LOG.LEVEL_STATEMENT
168: );
169:
170: /*l_dir := fnd_profile.VALUE ('EDW_LOGFILE_DIR');
171:
172: IF l_dir IS NULL
173: THEN
174: l_dir := '/sqlcom/log';

Line 179: l_dir := fnd_profile.value('EDW_LOGFILE_DIR');

175: END IF;
176: */
177: l_dir := fnd_profile.value('UTL_FILE_LOG');
178: if l_dir is null then
179: l_dir := fnd_profile.value('EDW_LOGFILE_DIR');
180: if l_dir is null then
181: l_dir:='/sqlcom/log';
182: end if;
183: end if;

Line 195: edw_log.put_names (

191: ELSE
192: put_debug_msg ('Transportation mode is set to FALSE');
193: END IF;
194:
195: edw_log.put_names (
196: p_object_name
197: || '.log',
198: p_object_name
199: || '.out',

Line 202: edw_log.put_line (

198: p_object_name
199: || '.out',
200: l_dir
201: );
202: edw_log.put_line (
203: 'Starting the collection program for object '
204: || p_object_name,FND_LOG.LEVEL_PROCEDURE
205: );
206: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

Line 206: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

202: edw_log.put_line (
203: 'Starting the collection program for object '
204: || p_object_name,FND_LOG.LEVEL_PROCEDURE
205: );
206: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
207: edw_log.put_line (
208: 'System time at the start of the process is :'
209: || fnd_date.date_to_displaydt (g_start_time),FND_LOG.LEVEL_PROCEDURE
210: );

Line 207: edw_log.put_line (

203: 'Starting the collection program for object '
204: || p_object_name,FND_LOG.LEVEL_PROCEDURE
205: );
206: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
207: edw_log.put_line (
208: 'System time at the start of the process is :'
209: || fnd_date.date_to_displaydt (g_start_time),FND_LOG.LEVEL_PROCEDURE
210: );
211: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

Line 211: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

207: edw_log.put_line (
208: 'System time at the start of the process is :'
209: || fnd_date.date_to_displaydt (g_start_time),FND_LOG.LEVEL_PROCEDURE
210: );
211: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
212:
213:
214: -- Get DB Link Names
215:

Line 225: edw_log.put_line('Calling get_object_type to determine if dimension or fact',FND_LOG.LEVEL_PROCEDURE);

221: RETURN (FALSE);
222: END;
223:
224: -- Determine object type
225: edw_log.put_line('Calling get_object_type to determine if dimension or fact',FND_LOG.LEVEL_PROCEDURE);
226: if get_object_type(p_object_name) = true then
227: edw_log.put_line('The object name and type are '||p_object_name||', '||g_object_type,FND_LOG.LEVEL_PROCEDURE);
228: end if;
229: edw_log.put_line( ' ',FND_LOG.LEVEL_PROCEDURE);

Line 227: edw_log.put_line('The object name and type are '||p_object_name||', '||g_object_type,FND_LOG.LEVEL_PROCEDURE);

223:
224: -- Determine object type
225: edw_log.put_line('Calling get_object_type to determine if dimension or fact',FND_LOG.LEVEL_PROCEDURE);
226: if get_object_type(p_object_name) = true then
227: edw_log.put_line('The object name and type are '||p_object_name||', '||g_object_type,FND_LOG.LEVEL_PROCEDURE);
228: end if;
229: edw_log.put_line( ' ',FND_LOG.LEVEL_PROCEDURE);
230:
231: -- ---------------------------------------------------------------------------

Line 229: edw_log.put_line( ' ',FND_LOG.LEVEL_PROCEDURE);

225: edw_log.put_line('Calling get_object_type to determine if dimension or fact',FND_LOG.LEVEL_PROCEDURE);
226: if get_object_type(p_object_name) = true then
227: edw_log.put_line('The object name and type are '||p_object_name||', '||g_object_type,FND_LOG.LEVEL_PROCEDURE);
228: end if;
229: edw_log.put_line( ' ',FND_LOG.LEVEL_PROCEDURE);
230:
231: -- ---------------------------------------------------------------------------
232: -- Cache global values
233: -- ---------------------------------------------------------------------------

Line 309: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);

305: END IF;
306:
307: IF l_status = FALSE
308: THEN
309: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);
310: edw_log.put_line ('Auto Dangling Recovery Error.',FND_LOG.LEVEL_ERROR);
311: edw_log.put_line (edw_src_dang_recovery.g_status_message,FND_LOG.LEVEL_ERROR);
312: END IF;
313: END IF; -- end if for checking EDW Object Type

Line 310: edw_log.put_line ('Auto Dangling Recovery Error.',FND_LOG.LEVEL_ERROR);

306:
307: IF l_status = FALSE
308: THEN
309: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);
310: edw_log.put_line ('Auto Dangling Recovery Error.',FND_LOG.LEVEL_ERROR);
311: edw_log.put_line (edw_src_dang_recovery.g_status_message,FND_LOG.LEVEL_ERROR);
312: END IF;
313: END IF; -- end if for checking EDW Object Type
314: END IF; -- l_status = TRUE (options read completed).

Line 311: edw_log.put_line (edw_src_dang_recovery.g_status_message,FND_LOG.LEVEL_ERROR);

307: IF l_status = FALSE
308: THEN
309: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);
310: edw_log.put_line ('Auto Dangling Recovery Error.',FND_LOG.LEVEL_ERROR);
311: edw_log.put_line (edw_src_dang_recovery.g_status_message,FND_LOG.LEVEL_ERROR);
312: END IF;
313: END IF; -- end if for checking EDW Object Type
314: END IF; -- l_status = TRUE (options read completed).
315: ELSE

Line 316: edw_log.put_line ('Error: Installation of BIS Product not found.',FND_LOG.LEVEL_ERROR);

312: END IF;
313: END IF; -- end if for checking EDW Object Type
314: END IF; -- l_status = TRUE (options read completed).
315: ELSE
316: edw_log.put_line ('Error: Installation of BIS Product not found.',FND_LOG.LEVEL_ERROR);
317: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);
318: l_status := FALSE;
319: END IF;
320:

Line 317: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);

313: END IF; -- end if for checking EDW Object Type
314: END IF; -- l_status = TRUE (options read completed).
315: ELSE
316: edw_log.put_line ('Error: Installation of BIS Product not found.',FND_LOG.LEVEL_ERROR);
317: edw_log.put_line (' ',FND_LOG.LEVEL_ERROR);
318: l_status := FALSE;
319: END IF;
320:
321: put_debug_msg ('********** End Setup Function');

Line 326: edw_log.put_line (

322: RETURN l_status;
323: EXCEPTION
324: WHEN OTHERS
325: THEN
326: edw_log.put_line (
327: ' Setup of '
328: || p_object_name
329: || ' tables failed. Error.',FND_LOG.LEVEL_ERROR
330: );

Line 378: edw_log.put_line (

374: IS
375: BEGIN
376: IF p_local_staging_table <> p_remote_staging_table
377: THEN
378: edw_log.put_line (
379: 'Local Staging Table Name is Different From Remote Staging Table Name. Error.',FND_LOG.LEVEL_STATEMENT
380: );
381: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
382: RAISE g_push_remote_failure;

Line 381: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

377: THEN
378: edw_log.put_line (
379: 'Local Staging Table Name is Different From Remote Staging Table Name. Error.',FND_LOG.LEVEL_STATEMENT
380: );
381: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
382: RAISE g_push_remote_failure;
383: END IF;
384:
385: g_staging_table := p_remote_staging_table;

Line 483: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);

479: Begin
480: wrapup (p_sucessful,0,null,null,null);
481: EXCEPTION
482: WHEN OTHERS THEN
483: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);
484: RAISE;
485: END wrapup;
486: PROCEDURE wrapup(
487: p_sucessful IN BOOLEAN,

Line 494: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);

490: Begin
491: wrapup (p_sucessful,p_rows_inserted,null,null,null);
492: EXCEPTION
493: WHEN OTHERS THEN
494: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);
495: RAISE;
496: END wrapup;
497: /*
498: Bug 2875426

Line 512: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);

508: Begin
509: wrapup (p_sucessful,p_rows_inserted,p_exception_msg,null,null);
510: EXCEPTION
511: WHEN OTHERS THEN
512: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);
513: RAISE;
514: END wrapup;
515: PROCEDURE wrapup(
516: p_sucessful IN BOOLEAN,

Line 525: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);

521: Begin
522: wrapup (p_sucessful,p_rows_inserted,null,p_period_start,p_period_end);
523: EXCEPTION
524: WHEN OTHERS THEN
525: edw_log.put_line ( 'Wrapup: '|| SQLERRM,FND_LOG.LEVEL_ERROR);
526: RAISE;
527: END wrapup;
528: PROCEDURE wrapup (
529: p_sucessful IN BOOLEAN,

Line 541: edw_log.put_line ('Wrapup called with SUCCESS',FND_LOG.LEVEL_STATEMENT);

537: l_sucessful BOOLEAN := TRUE;
538: BEGIN
539: put_debug_msg ('********** Starting EDW_COLLECTION_UTIL.wrapup');
540: if p_sucessful then
541: edw_log.put_line ('Wrapup called with SUCCESS',FND_LOG.LEVEL_STATEMENT);
542: else
543: edw_log.put_line ('Wrapup called with ERROR and message is '||p_exception_msg,FND_LOG.LEVEL_ERROR);
544: end if;
545: IF (p_sucessful)

Line 543: edw_log.put_line ('Wrapup called with ERROR and message is '||p_exception_msg,FND_LOG.LEVEL_ERROR);

539: put_debug_msg ('********** Starting EDW_COLLECTION_UTIL.wrapup');
540: if p_sucessful then
541: edw_log.put_line ('Wrapup called with SUCCESS',FND_LOG.LEVEL_STATEMENT);
542: else
543: edw_log.put_line ('Wrapup called with ERROR and message is '||p_exception_msg,FND_LOG.LEVEL_ERROR);
544: end if;
545: IF (p_sucessful)
546: THEN
547: /*

Line 560: edw_log.put_line (

556: -- update function input parameter
557:
558: BEGIN
559: l_rows_inserted := push_to_target;
560: edw_log.put_line (
561: 'Rows Inserted into Interface Tables: '
562: || p_rows_inserted,FND_LOG.LEVEL_STATEMENT
563: );
564: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

Line 564: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

560: edw_log.put_line (
561: 'Rows Inserted into Interface Tables: '
562: || p_rows_inserted,FND_LOG.LEVEL_STATEMENT
563: );
564: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
565: IF l_rows_inserted = -1
566: THEN
567: l_sucessful := FALSE;
568: ELSIF ( l_rows_inserted = 0 ) AND

Line 585: edw_log.put_line (' Push Data Failed. Error.',FND_LOG.LEVEL_ERROR);

581:
582: EXCEPTION
583: WHEN OTHERS
584: THEN
585: edw_log.put_line (' Push Data Failed. Error.',FND_LOG.LEVEL_ERROR);
586: l_sucessful := FALSE;
587: END;
588: END IF; -- end if for p_sucessful
589:

Line 604: edw_log.put_line (tab_stglist (i).tbl_name,FND_LOG.LEVEL_STATEMENT);

600: put_debug_msg ('Supposed to truncate the interface tables');
601:
602: FOR i IN tab_stglist.FIRST .. tab_stglist.LAST
603: LOOP
604: edw_log.put_line (tab_stglist (i).tbl_name,FND_LOG.LEVEL_STATEMENT);
605: END LOOP;
606: END IF;
607: END IF; -- g_debug
608: ELSE

Line 627: edw_log.put_line ('System time at the end of data push is :',FND_LOG.LEVEL_PROCEDURE);

623:
624: -- ---------------------------------------------------------------------------
625: -- Print ending messages
626: -- ---------------------------------------------------------------------------
627: edw_log.put_line ('System time at the end of data push is :',FND_LOG.LEVEL_PROCEDURE);
628: put_timestamp;
629: edw_log.put_line ('---------------------------------------------',FND_LOG.LEVEL_PROCEDURE);
630:
631: -- ---------------------------------------------------------------------------

Line 629: edw_log.put_line ('---------------------------------------------',FND_LOG.LEVEL_PROCEDURE);

625: -- Print ending messages
626: -- ---------------------------------------------------------------------------
627: edw_log.put_line ('System time at the end of data push is :',FND_LOG.LEVEL_PROCEDURE);
628: put_timestamp;
629: edw_log.put_line ('---------------------------------------------',FND_LOG.LEVEL_PROCEDURE);
630:
631: -- ---------------------------------------------------------------------------
632: -- Get the current time from the Warehouse
633: -- ---------------------------------------------------------------------------

Line 634: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

630:
631: -- ---------------------------------------------------------------------------
632: -- Get the current time from the Warehouse
633: -- ---------------------------------------------------------------------------
634: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
635: edw_log.put_line (
636: 'Getting the current push date in warehouse time from warehouse',FND_LOG.LEVEL_PROCEDURE
637: );
638: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

Line 635: edw_log.put_line (

631: -- ---------------------------------------------------------------------------
632: -- Get the current time from the Warehouse
633: -- ---------------------------------------------------------------------------
634: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
635: edw_log.put_line (
636: 'Getting the current push date in warehouse time from warehouse',FND_LOG.LEVEL_PROCEDURE
637: );
638: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
639: edw_collection_util.set_push_end_dates;

Line 638: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

634: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
635: edw_log.put_line (
636: 'Getting the current push date in warehouse time from warehouse',FND_LOG.LEVEL_PROCEDURE
637: );
638: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
639: edw_collection_util.set_push_end_dates;
640:
641: -- ---------------------------------------------------------------------------
642: -- Insert a row in collection log table for this collection run

Line 659: edw_log.put_line ('System time at the time of exception is :',FND_LOG.LEVEL_ERROR);

655:
656: -- ---------------------------------------------------------------------------
657: -- Print ending messages
658: -- ---------------------------------------------------------------------------
659: edw_log.put_line ('System time at the time of exception is :',FND_LOG.LEVEL_ERROR);
660: put_timestamp;
661: edw_log.put_line ('---------------------------------------------',FND_LOG.LEVEL_ERROR);
662:
663: -- ---------------------------------------------------------------------------

Line 661: edw_log.put_line ('---------------------------------------------',FND_LOG.LEVEL_ERROR);

657: -- Print ending messages
658: -- ---------------------------------------------------------------------------
659: edw_log.put_line ('System time at the time of exception is :',FND_LOG.LEVEL_ERROR);
660: put_timestamp;
661: edw_log.put_line ('---------------------------------------------',FND_LOG.LEVEL_ERROR);
662:
663: -- ---------------------------------------------------------------------------
664: -- Insert a row in collection log table for this collection run
665: -- with a status of ERROR

Line 667: edw_log.put_line ('Exception Handling: Following error encountered',FND_LOG.LEVEL_ERROR);

663: -- ---------------------------------------------------------------------------
664: -- Insert a row in collection log table for this collection run
665: -- with a status of ERROR
666: -- ---------------------------------------------------------------------------
667: edw_log.put_line ('Exception Handling: Following error encountered',FND_LOG.LEVEL_ERROR);
668: edw_log.put_line (p_exception_msg,FND_LOG.LEVEL_ERROR);
669: edw_collection_util.staging_log (
670: p_exception_message=> p_exception_msg,
671: p_status=> 'ERROR',

Line 668: edw_log.put_line (p_exception_msg,FND_LOG.LEVEL_ERROR);

664: -- Insert a row in collection log table for this collection run
665: -- with a status of ERROR
666: -- ---------------------------------------------------------------------------
667: edw_log.put_line ('Exception Handling: Following error encountered',FND_LOG.LEVEL_ERROR);
668: edw_log.put_line (p_exception_msg,FND_LOG.LEVEL_ERROR);
669: edw_collection_util.staging_log (
670: p_exception_message=> p_exception_msg,
671: p_status=> 'ERROR',
672: p_no_of_records=> 0,

Line 676: edw_log.put_line (

672: p_no_of_records=> 0,
673: p_period_start=> p_period_start,
674: p_period_end=> p_period_end
675: );
676: edw_log.put_line (
677: 'Inserted error message into the edw_push_detail_log',FND_LOG.LEVEL_ERROR
678: );
679: COMMIT;
680:

Line 689: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

685: RAISE g_push_remote_failure;
686: END IF;
687: END IF;
688:
689: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
690: edw_log.put_line ('System time at the end of the process is :',FND_LOG.LEVEL_PROCEDURE);
691: put_timestamp;
692: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
693: edw_log.put_line (

Line 690: edw_log.put_line ('System time at the end of the process is :',FND_LOG.LEVEL_PROCEDURE);

686: END IF;
687: END IF;
688:
689: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
690: edw_log.put_line ('System time at the end of the process is :',FND_LOG.LEVEL_PROCEDURE);
691: put_timestamp;
692: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
693: edw_log.put_line (
694: 'Total elapsed time: '

Line 692: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

688:
689: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
690: edw_log.put_line ('System time at the end of the process is :',FND_LOG.LEVEL_PROCEDURE);
691: put_timestamp;
692: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
693: edw_log.put_line (
694: 'Total elapsed time: '
695: || edw_log.duration ( SYSDATE
696: - g_start_time),FND_LOG.LEVEL_PROCEDURE

Line 693: edw_log.put_line (

689: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
690: edw_log.put_line ('System time at the end of the process is :',FND_LOG.LEVEL_PROCEDURE);
691: put_timestamp;
692: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
693: edw_log.put_line (
694: 'Total elapsed time: '
695: || edw_log.duration ( SYSDATE
696: - g_start_time),FND_LOG.LEVEL_PROCEDURE
697: );

Line 695: || edw_log.duration ( SYSDATE

691: put_timestamp;
692: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
693: edw_log.put_line (
694: 'Total elapsed time: '
695: || edw_log.duration ( SYSDATE
696: - g_start_time),FND_LOG.LEVEL_PROCEDURE
697: );
698:
699: IF (fnd_profile.VALUE ('EDW_TRACE') = 'Y')

Line 708: edw_log.put_line ( 'error '

704: put_debug_msg ('********** End EDW_COLLECTION_UTIL.wrapup');
705: EXCEPTION
706: WHEN g_push_remote_failure
707: THEN
708: edw_log.put_line ( 'error '
709: || g_retcode
710: || ':'
711: || g_errbuf,FND_LOG.LEVEL_ERROR);
712: edw_log.put_line (

Line 712: edw_log.put_line (

708: edw_log.put_line ( 'error '
709: || g_retcode
710: || ':'
711: || g_errbuf,FND_LOG.LEVEL_ERROR);
712: edw_log.put_line (
713: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_ERROR
714: );
715: RAISE;
716: WHEN OTHERS

Line 718: edw_log.put_line ( 'Wrapup: '

714: );
715: RAISE;
716: WHEN OTHERS
717: THEN
718: edw_log.put_line ( 'Wrapup: '
719: || SQLERRM,FND_LOG.LEVEL_ERROR);
720: RAISE;
721: END wrapup;
722:

Line 949: edw_log.put_line (' Instance code not found. Error.',FND_LOG.LEVEL_ERROR);

945: FROM edw_local_instance;
946: EXCEPTION
947: WHEN OTHERS
948: THEN
949: edw_log.put_line (' Instance code not found. Error.',FND_LOG.LEVEL_ERROR);
950: END;
951:
952:
953: -- ----------------------------------------------------------------------------

Line 1070: edw_log.put_line (

1066: staging_log (p_no_of_records,p_status,p_exception_message,null,null);
1067: EXCEPTION
1068: WHEN OTHERS
1069: THEN
1070: edw_log.put_line (
1071: 'Error inserting into local log table '
1072: || SQLERRM,FND_LOG.LEVEL_ERROR
1073: );
1074: RAISE;

Line 1171: edw_log.put_line (

1167: put_debug_msg ('********** End Procedure : Staging_Log');
1168: EXCEPTION
1169: WHEN OTHERS
1170: THEN
1171: edw_log.put_line (
1172: 'Error inserting into local log table '
1173: || SQLERRM,FND_LOG.LEVEL_ERROR
1174: );
1175: RAISE;

Line 1258: edw_log.put_line (

1254: WHEN OTHERS
1255: THEN
1256: fnd_message.set_name ('BIS', 'EDW_NLS_LANG_SETUP');
1257: fnd_message.set_token ('VALUE', l_lang_code);
1258: edw_log.put_line (
1259: 'Unable to set the language context to the warehouse language '
1260: || l_lang_code,FND_LOG.LEVEL_ERROR
1261: );
1262: RETURN FALSE;

Line 1311: edw_log.put_line ('Error while checking whether source is enabled',FND_LOG.LEVEL_ERROR);

1307: WHEN NO_DATA_FOUND
1308: THEN
1309: g_errbuf := SQLERRM;
1310: g_retcode := SQLCODE;
1311: edw_log.put_line ('Error while checking whether source is enabled',FND_LOG.LEVEL_ERROR);
1312: edw_log.put_line ( g_errbuf
1313: || ':'
1314: || g_retcode,FND_LOG.LEVEL_ERROR);
1315: RETURN FALSE;

Line 1312: edw_log.put_line ( g_errbuf

1308: THEN
1309: g_errbuf := SQLERRM;
1310: g_retcode := SQLCODE;
1311: edw_log.put_line ('Error while checking whether source is enabled',FND_LOG.LEVEL_ERROR);
1312: edw_log.put_line ( g_errbuf
1313: || ':'
1314: || g_retcode,FND_LOG.LEVEL_ERROR);
1315: RETURN FALSE;
1316: END is_instance_enabled;

Line 1376: edw_log.put_line (

1372: WHEN OTHERS
1373: THEN
1374: g_errbuf := SQLERRM;
1375: g_retcode := SQLCODE;
1376: edw_log.put_line (
1377: 'Error while checking whether source same as target',FND_LOG.LEVEL_ERROR
1378: );
1379: edw_log.put_line ( g_errbuf
1380: || ':'

Line 1379: edw_log.put_line ( g_errbuf

1375: g_retcode := SQLCODE;
1376: edw_log.put_line (
1377: 'Error while checking whether source same as target',FND_LOG.LEVEL_ERROR
1378: );
1379: edw_log.put_line ( g_errbuf
1380: || ':'
1381: || g_retcode,FND_LOG.LEVEL_ERROR);
1382: RAISE;
1383: END source_same_as_target;

Line 1415: edw_log.put_line (

1411: WHEN OTHERS
1412: THEN
1413: g_errbuf := SQLERRM;
1414: g_retcode := SQLCODE;
1415: edw_log.put_line (
1416: 'error while truncating local staging table '
1417: || g_errbuf
1418: || ':'
1419: || g_retcode,FND_LOG.LEVEL_ERROR

Line 1475: edw_log.put_line (

1471: + SQL%ROWCOUNT;
1472: COMMIT;
1473: END LOOP update_loop;
1474:
1475: edw_log.put_line (
1476: l_rowcount
1477: || ' rows for table '
1478: || l_stgtbl_name
1479: || ' proceeded.',FND_LOG.LEVEL_STATEMENT

Line 1494: edw_log.put_line ( 'set status failed'

1490: WHEN OTHERS
1491: THEN
1492: g_errbuf := SQLERRM;
1493: g_retcode := SQLCODE;
1494: edw_log.put_line ( 'set status failed'
1495: || g_errbuf
1496: || g_retcode,FND_LOG.LEVEL_ERROR);
1497: RETURN (-1);
1498: END set_status_ready;

Line 1679: edw_log.put_line ( 'error '

1675: || l_target_link
1676: || '. Database Global Name is '
1677: || l_gname_val;
1678: g_retcode := 'EDW: ';
1679: edw_log.put_line ( 'error '
1680: || g_retcode
1681: || ':'
1682: || g_errbuf,FND_LOG.LEVEL_ERROR);
1683: edw_log.put_line (

Line 1683: edw_log.put_line (

1679: edw_log.put_line ( 'error '
1680: || g_retcode
1681: || ':'
1682: || g_errbuf,FND_LOG.LEVEL_ERROR);
1683: edw_log.put_line (
1684: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_ERROR
1685: );
1686: RAISE;
1687: WHEN OTHERS

Line 1691: edw_log.put_line ( 'error '

1687: WHEN OTHERS
1688: THEN
1689: g_errbuf := SQLERRM;
1690: g_retcode := SQLCODE;
1691: edw_log.put_line ( 'error '
1692: || g_retcode
1693: || ':'
1694: || g_errbuf,FND_LOG.LEVEL_ERROR);
1695: edw_log.put_line (

Line 1695: edw_log.put_line (

1691: edw_log.put_line ( 'error '
1692: || g_retcode
1693: || ':'
1694: || g_errbuf,FND_LOG.LEVEL_ERROR);
1695: edw_log.put_line (
1696: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_ERROR
1697: );
1698: RAISE;
1699: END get_dblink_names;

Line 1896: edw_log.put_line (

1892: l_count := set_status_ready (tab_stglist);
1893:
1894: IF (l_count = -1)
1895: THEN
1896: edw_log.put_line (
1897: 'Update of table'
1898: || l_stgtbl_name
1899: || ' failed',FND_LOG.LEVEL_ERROR
1900: );

Line 1902: edw_log.put_line ( l_count

1898: || l_stgtbl_name
1899: || ' failed',FND_LOG.LEVEL_ERROR
1900: );
1901: ELSE
1902: edw_log.put_line ( l_count
1903: || ' total rows proceeded.',FND_LOG.LEVEL_STATEMENT);
1904: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
1905: END IF;
1906: ELSE

Line 1904: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

1900: );
1901: ELSE
1902: edw_log.put_line ( l_count
1903: || ' total rows proceeded.',FND_LOG.LEVEL_STATEMENT);
1904: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
1905: END IF;
1906: ELSE
1907:
1908: -- Decoupled Architecture Case

Line 2261: edw_log.put_line (

2257: l_count := SQL%ROWCOUNT;
2258: END IF; -- end iteration cases
2259: END IF; -- row_count>0 There is data in LSTG tables
2260:
2261: edw_log.put_line (
2262: l_count
2263: || ' rows for table '
2264: || l_stgtbl_name
2265: || ' proceeded.',FND_LOG.LEVEL_STATEMENT

Line 2267: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

2263: || ' rows for table '
2264: || l_stgtbl_name
2265: || ' proceeded.',FND_LOG.LEVEL_STATEMENT
2266: );
2267: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2268: l_rowcount := l_rowcount
2269: + l_count;
2270: END LOOP stgtbl_loop; -- end loop for table list
2271: END IF;

Line 2277: edw_log.put_line ( 'Total rows proceeded.'

2273: END IF; -- check number of stg tables
2274:
2275: IF g_source_same_as_target = FALSE
2276: THEN
2277: edw_log.put_line ( 'Total rows proceeded.'
2278: || l_rowcount,FND_LOG.LEVEL_STATEMENT);
2279: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2280: ELSIF l_rowcount = 0 AND g_source_same_as_target = TRUE
2281: THEN

Line 2279: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

2275: IF g_source_same_as_target = FALSE
2276: THEN
2277: edw_log.put_line ( 'Total rows proceeded.'
2278: || l_rowcount,FND_LOG.LEVEL_STATEMENT);
2279: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2280: ELSIF l_rowcount = 0 AND g_source_same_as_target = TRUE
2281: THEN
2282: edw_log.put_line (
2283: 'Data for Object'

Line 2282: edw_log.put_line (

2278: || l_rowcount,FND_LOG.LEVEL_STATEMENT);
2279: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2280: ELSIF l_rowcount = 0 AND g_source_same_as_target = TRUE
2281: THEN
2282: edw_log.put_line (
2283: 'Data for Object'
2284: || g_object_name
2285: || 'collected. ',FND_LOG.LEVEL_PROCEDURE
2286: );

Line 2287: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

2283: 'Data for Object'
2284: || g_object_name
2285: || 'collected. ',FND_LOG.LEVEL_PROCEDURE
2286: );
2287: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
2288: ELSIF l_rowcount > 0 AND g_source_same_as_target = TRUE
2289: THEN
2290: edw_log.put_line (
2291: 'Data for Object'

Line 2290: edw_log.put_line (

2286: );
2287: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
2288: ELSIF l_rowcount > 0 AND g_source_same_as_target = TRUE
2289: THEN
2290: edw_log.put_line (
2291: 'Data for Object'
2292: || g_object_name
2293: || 'collected. ',FND_LOG.LEVEL_PROCEDURE
2294: );

Line 2295: edw_log.put_line ( l_rowcount

2291: 'Data for Object'
2292: || g_object_name
2293: || 'collected. ',FND_LOG.LEVEL_PROCEDURE
2294: );
2295: edw_log.put_line ( l_rowcount
2296: || ' rows are updated',FND_LOG.LEVEL_PROCEDURE);
2297: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
2298: END IF;
2299:

Line 2297: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);

2293: || 'collected. ',FND_LOG.LEVEL_PROCEDURE
2294: );
2295: edw_log.put_line ( l_rowcount
2296: || ' rows are updated',FND_LOG.LEVEL_PROCEDURE);
2297: edw_log.put_line (' ',FND_LOG.LEVEL_PROCEDURE);
2298: END IF;
2299:
2300: put_debug_msg ('********** End Procedure : push_to_target');
2301: put_timestamp;

Line 2309: edw_log.put_line (

2305: THEN
2306: ROLLBACK;
2307: g_errbuf := SQLERRM;
2308: g_retcode := SQLCODE;
2309: edw_log.put_line (
2310: 'EDW_COLLECTION_UTIL.push_to_target error while pushing to target',FND_LOG.LEVEL_ERROR
2311: );
2312: edw_log.put_line ( g_retcode
2313: || ' : '

Line 2312: edw_log.put_line ( g_retcode

2308: g_retcode := SQLCODE;
2309: edw_log.put_line (
2310: 'EDW_COLLECTION_UTIL.push_to_target error while pushing to target',FND_LOG.LEVEL_ERROR
2311: );
2312: edw_log.put_line ( g_retcode
2313: || ' : '
2314: || g_errbuf,FND_LOG.LEVEL_ERROR);
2315: RETURN (-1);
2316: END push_to_target;

Line 2340: edw_log.put_line (

2336:
2337: IF c_get_tbl_owner%NOTFOUND
2338: THEN
2339: -- bug 4300166 underscore added to supress GSCC error
2340: edw_log.put_line (
2341: 'Error. Synonym _APPS_.'
2342: || syn_name
2343: || ' is invalid.',FND_LOG.LEVEL_ERROR
2344: );

Line 2345: edw_log.put_line (' ');

2341: 'Error. Synonym _APPS_.'
2342: || syn_name
2343: || ' is invalid.',FND_LOG.LEVEL_ERROR
2344: );
2345: edw_log.put_line (' ');
2346: RAISE g_push_remote_failure;
2347: END IF;
2348:
2349: CLOSE c_get_tbl_owner;

Line 2359: edw_log.put_line (fnd_date.date_to_displaydt (SYSDATE),FND_LOG.LEVEL_STATEMENT);

2355: IS
2356: BEGIN
2357: IF g_debug
2358: THEN
2359: edw_log.put_line (fnd_date.date_to_displaydt (SYSDATE),FND_LOG.LEVEL_STATEMENT);
2360: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2361: END IF;
2362: END put_timestamp;
2363:

Line 2360: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

2356: BEGIN
2357: IF g_debug
2358: THEN
2359: edw_log.put_line (fnd_date.date_to_displaydt (SYSDATE),FND_LOG.LEVEL_STATEMENT);
2360: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2361: END IF;
2362: END put_timestamp;
2363:
2364: PROCEDURE put_debug_msg (p_message IN VARCHAR2)

Line 2369: edw_log.put_line (p_message,FND_LOG.LEVEL_STATEMENT);

2365: IS
2366: BEGIN
2367: IF g_debug
2368: THEN
2369: edw_log.put_line (p_message,FND_LOG.LEVEL_STATEMENT);
2370: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2371: END IF;
2372: END put_debug_msg;
2373:

Line 2370: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);

2366: BEGIN
2367: IF g_debug
2368: THEN
2369: edw_log.put_line (p_message,FND_LOG.LEVEL_STATEMENT);
2370: edw_log.put_line (' ',FND_LOG.LEVEL_STATEMENT);
2371: END IF;
2372: END put_debug_msg;
2373:
2374: FUNCTION is_object_for_local_load (p_object_name IN VARCHAR2)

Line 2402: edw_log.put_line (SQLERRM,FND_LOG.LEVEL_ERROR);

2398: RETURN l_status;
2399: EXCEPTION
2400: WHEN OTHERS
2401: THEN
2402: edw_log.put_line (SQLERRM,FND_LOG.LEVEL_ERROR);
2403: RAISE;
2404: END is_object_for_local_load;
2405:
2406: PROCEDURE set_transaction_rbs (p_rbs IN VARCHAR2)