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 FND_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 155: || g_parallel,FND_LOG.LEVEL_STATEMENT

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 (
158: 'Object Settings: Commit Size : '
159: || g_push_size,FND_LOG.LEVEL_STATEMENT

Line 159: || g_push_size,FND_LOG.LEVEL_STATEMENT

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 (
162: 'Object Settings: Operational Tablespace : '
163: || g_op_tablespace,FND_LOG.LEVEL_STATEMENT

Line 163: || g_op_tablespace,FND_LOG.LEVEL_STATEMENT

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 (
166: 'Object Settings: Rollback Segment : '
167: || g_rbs,FND_LOG.LEVEL_STATEMENT

Line 167: || g_rbs,FND_LOG.LEVEL_STATEMENT

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:
170: /*l_dir := fnd_profile.VALUE ('EDW_LOGFILE_DIR');
171:

Line 204: || p_object_name,FND_LOG.LEVEL_PROCEDURE

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);
207: edw_log.put_line (
208: 'System time at the start of the process is :'

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 209: || fnd_date.date_to_displaydt (g_start_time),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);
212:
213:

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 329: || ' tables failed. Error.',FND_LOG.LEVEL_ERROR

325: THEN
326: edw_log.put_line (
327: ' Setup of '
328: || p_object_name
329: || ' tables failed. Error.',FND_LOG.LEVEL_ERROR
330: );
331: RETURN (FALSE);
332: END setup;
333:

Line 379: 'Local Staging Table Name is Different From Remote Staging Table Name. Error.',FND_LOG.LEVEL_STATEMENT

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

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 562: || p_rows_inserted,FND_LOG.LEVEL_STATEMENT

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);
565: IF l_rows_inserted = -1
566: THEN

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 636: 'Getting the current push date in warehouse time from warehouse',FND_LOG.LEVEL_PROCEDURE

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

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 677: 'Inserted error message into the edw_push_detail_log',FND_LOG.LEVEL_ERROR

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:
681:

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 696: - g_start_time),FND_LOG.LEVEL_PROCEDURE

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')
700: THEN

Line 711: || g_errbuf,FND_LOG.LEVEL_ERROR);

707: THEN
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;

Line 713: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_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
717: THEN

Line 719: || SQLERRM,FND_LOG.LEVEL_ERROR);

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:
723: FUNCTION get_wh_language

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 1072: || SQLERRM,FND_LOG.LEVEL_ERROR

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;
1075: END staging_log;
1076: PROCEDURE staging_log (

Line 1173: || SQLERRM,FND_LOG.LEVEL_ERROR

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;
1176: END staging_log;
1177:

Line 1260: || l_lang_code,FND_LOG.LEVEL_ERROR

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;
1263: END set_wh_language;
1264:

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 1314: || g_retcode,FND_LOG.LEVEL_ERROR);

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;
1317:
1318: FUNCTION source_same_as_target

Line 1377: 'Error while checking whether source same as target',FND_LOG.LEVEL_ERROR

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: || ':'
1381: || g_retcode,FND_LOG.LEVEL_ERROR);

Line 1381: || g_retcode,FND_LOG.LEVEL_ERROR);

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;
1384:
1385: PROCEDURE truncate_stg (p_tab_list IN tablist_type)

Line 1419: || g_retcode,FND_LOG.LEVEL_ERROR

1415: edw_log.put_line (
1416: 'error while truncating local staging table '
1417: || g_errbuf
1418: || ':'
1419: || g_retcode,FND_LOG.LEVEL_ERROR
1420: );
1421: RAISE;
1422: END truncate_stg;
1423:

Line 1479: || ' proceeded.',FND_LOG.LEVEL_STATEMENT

1475: edw_log.put_line (
1476: l_rowcount
1477: || ' rows for table '
1478: || l_stgtbl_name
1479: || ' proceeded.',FND_LOG.LEVEL_STATEMENT
1480: );
1481: END IF; -- l_count>0
1482:
1483: l_total_rows := l_total_rows

Line 1496: || g_retcode,FND_LOG.LEVEL_ERROR);

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;
1499:
1500: FUNCTION get_last_push_date_logical (p_object_logical_name IN VARCHAR2)

Line 1682: || g_errbuf,FND_LOG.LEVEL_ERROR);

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 (
1684: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_ERROR
1685: );
1686: RAISE;

Line 1684: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_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
1688: THEN

Line 1694: || g_errbuf,FND_LOG.LEVEL_ERROR);

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 (
1696: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_ERROR
1697: );
1698: RAISE;

Line 1696: 'Data migration from local to remote staging have failed',FND_LOG.LEVEL_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;
1700:

Line 1899: || ' failed',FND_LOG.LEVEL_ERROR

1895: THEN
1896: edw_log.put_line (
1897: 'Update of table'
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);

Line 1903: || ' total rows proceeded.',FND_LOG.LEVEL_STATEMENT);

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
1907:

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 2265: || ' proceeded.',FND_LOG.LEVEL_STATEMENT

2261: edw_log.put_line (
2262: l_count
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;

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 2278: || l_rowcount,FND_LOG.LEVEL_STATEMENT);

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
2282: edw_log.put_line (

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 2285: || 'collected. ',FND_LOG.LEVEL_PROCEDURE

2281: THEN
2282: edw_log.put_line (
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

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 2293: || 'collected. ',FND_LOG.LEVEL_PROCEDURE

2289: THEN
2290: edw_log.put_line (
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);

Line 2296: || ' rows are updated',FND_LOG.LEVEL_PROCEDURE);

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:
2300: put_debug_msg ('********** End Procedure : push_to_target');

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 2310: 'EDW_COLLECTION_UTIL.push_to_target error while pushing to target',FND_LOG.LEVEL_ERROR

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: || ' : '
2314: || g_errbuf,FND_LOG.LEVEL_ERROR);

Line 2314: || g_errbuf,FND_LOG.LEVEL_ERROR);

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;
2317:
2318: FUNCTION get_syn_info (syn_name IN VARCHAR2)

Line 2343: || ' is invalid.',FND_LOG.LEVEL_ERROR

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: );
2345: edw_log.put_line (' ');
2346: RAISE g_push_remote_failure;
2347: END IF;

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)