DBA Data[Home] [Help]

APPS.BEN_CWB_INTEGRATOR_COPY dependencies on FND_FILE

Line 368: fnd_file.put_line(Fnd_file.LOG,'1.Creating the integrator...');

364:
365: l_step := 'Integrator Creation';
366: FOR l_bne_integrator in c_bne_integrators
367: LOOP
368: fnd_file.put_line(Fnd_file.LOG,'1.Creating the integrator...');
369: l_created := 'Y';
370: bne_integrators_pkg.load_row(
371: x_integrator_asn => l_bne_integrator.application_short_name,
372: x_integrator_code => l_new_integrator_code ,

Line 400: fnd_file.put_line(Fnd_file.LOG,'2.Creating the interface...');

396: x_session_param_list_asn => l_bne_integrator.session_param_list_asn ,
397: x_session_param_list_code => l_bne_integrator.session_param_list_code ,
398: x_display_flag => l_bne_integrator.display_flag
399: );
400: fnd_file.put_line(Fnd_file.LOG,'2.Creating the interface...');
401: l_step := 'Interface Creation';
402: FOR l_bne_interface in c_bne_interfaces
403: LOOP
404: bne_interfaces_pkg.load_row(

Line 421: --fnd_file.put_line(Fnd_file.LOG,'2.2.Creating the interface columns...');

417: x_owner => l_bne_interface.owner ,
418: x_last_update_date => l_bne_interface.last_update_date ,
419: x_custom_mode => null
420: );
421: --fnd_file.put_line(Fnd_file.LOG,'2.2.Creating the interface columns...');
422: l_step := 'Interface Columns Creation';
423: FOR l_bne_interface_col in c_bne_interface_cols(l_bne_interface.interface_code)
424: LOOP
425: bne_interface_cols_pkg.load_row(

Line 483: fnd_file.put_line(Fnd_file.LOG,'3.Creating the contents...');

479: END LOOP; -- interface columns
480:
481: END LOOP; -- interface
482:
483: fnd_file.put_line(Fnd_file.LOG,'3.Creating the contents...');
484: l_step := 'Contents Creation';
485: FOR l_bne_content in c_bne_contents
486: LOOP
487: bne_contents_pkg.load_row(

Line 503: -- fnd_file.put_line(Fnd_file.LOG,'3.2.Creating the contents columns...');

499: x_custom_mode => null ,
500: x_once_only_download_flag => l_bne_content.once_only_download_flag
501: );
502:
503: -- fnd_file.put_line(Fnd_file.LOG,'3.2.Creating the contents columns...');
504: l_step := 'Contents Columns Creation';
505: FOR l_bne_content_col in c_bne_content_cols (l_bne_content.content_code)
506: LOOP
507: bne_content_cols_pkg.load_row(

Line 522: -- fnd_file.put_line(Fnd_file.LOG,'3.3.Creating the bne_stored_sql...');

518: );
519:
520: END LOOP; -- contents columns
521:
522: -- fnd_file.put_line(Fnd_file.LOG,'3.3.Creating the bne_stored_sql...');
523: l_step := 'Stored Sql Creation';
524: FOR l_bne_stored_sql in c_bne_stored_sql (l_bne_content.content_code)
525: LOOP
526: bne_stored_sql_pkg.load_row(

Line 542: fnd_file.put_line(Fnd_file.LOG,'4.Creating the mapping...');

538: END LOOP; -- bne_stored_sql
539:
540: END LOOP; -- contents
541:
542: fnd_file.put_line(Fnd_file.LOG,'4.Creating the mapping...');
543: l_step := 'Mapping Creation';
544: FOR l_bne_mapping in c_bne_mappings
545: LOOP
546: bne_mappings_pkg.load_row(

Line 560: -- fnd_file.put_line(Fnd_file.LOG,'4.2.Creating the mapping lines...');

556: x_owner => l_bne_mapping.owner ,
557: x_last_update_date => l_bne_mapping.last_update_date ,
558: x_custom_mode => null
559: );
560: -- fnd_file.put_line(Fnd_file.LOG,'4.2.Creating the mapping lines...');
561: l_step := 'Mapping Lines Creation';
562: FOR l_bne_mapping_line in c_bne_mapping_lines (l_bne_mapping.mapping_code)
563: LOOP
564: bne_mapping_lines_pkg.load_row(

Line 585: fnd_file.put_line(Fnd_file.LOG,'5.Creating the layouts...');

581: END LOOP; -- mapping lines.
582:
583: END LOOP; --mapping
584:
585: fnd_file.put_line(Fnd_file.LOG,'5.Creating the layouts...');
586: l_step := 'Layout Creation';
587: l_layout_count := 1;
588: FOR l_bne_layout in c_bne_layouts
589: LOOP

Line 687: fnd_file.put_line(Fnd_file.LOG,'6.Creating the secured objects...');

683: END LOOP; -- layout block
684:
685: END LOOP; -- layouts
686:
687: fnd_file.put_line(Fnd_file.LOG,'6.Creating the secured objects...');
688: l_step := 'Secured objects Creation';
689: FOR l_bne_secured_object in c_bne_secured_objects
690: LOOP
691: bne_secured_objects_pkg.load_row(

Line 728: fnd_file.put_line(Fnd_file.LOG,'Successfully created the Integrator Setup - ' || l_new_integrator_code);

724: and oipl_id = -1 and group_oipl_id = -1;
725:
726: --COMMIT;
727: IF(l_created = 'Y') THEN
728: fnd_file.put_line(Fnd_file.LOG,'Successfully created the Integrator Setup - ' || l_new_integrator_code);
729: END IF;
730:
731: EXCEPTION
732: WHEN OTHERS

Line 734: fnd_file.put_line(Fnd_file.LOG,'Error at step : '||l_step);

730:
731: EXCEPTION
732: WHEN OTHERS
733: THEN
734: fnd_file.put_line(Fnd_file.LOG,'Error at step : '||l_step);
735: fnd_file.put_line(Fnd_file.LOG,'Error in copy_integrator : '||SQLERRM);
736: ROLLBACK TO copy_integrator;
737: END;
738: --

Line 735: fnd_file.put_line(Fnd_file.LOG,'Error in copy_integrator : '||SQLERRM);

731: EXCEPTION
732: WHEN OTHERS
733: THEN
734: fnd_file.put_line(Fnd_file.LOG,'Error at step : '||l_step);
735: fnd_file.put_line(Fnd_file.LOG,'Error in copy_integrator : '||SQLERRM);
736: ROLLBACK TO copy_integrator;
737: END;
738: --
739: -------------------------- copy_integrator ----------------------