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.FEM_DATA_LOADER_PKG dependencies on FND_FILE

Line 319: fnd_file.put_line(fnd_file.log, 'Exception - process_request ' || sqlerrm);

315: WHEN OTHERS THEN
316: fem_engines_pkg.tech_message (p_severity => g_log_level_6
317: ,p_module => g_block||'.process_request(PROCEDURE)'
318: ,p_msg_text => 'EXCEPTION in process_request ' || sqlerrm);
319: fnd_file.put_line(fnd_file.log, 'Exception - process_request ' || sqlerrm);
320: RAISE;
321:
322: END process_request;
323:

Line 354: fnd_file.put_line(FND_FILE.OUTPUT, l_message);

350: ELSIF p_trace_what = 'BLANKLINE' THEN
351: l_message := '';
352: END IF;
353:
354: fnd_file.put_line(FND_FILE.OUTPUT, l_message);
355:
356: fem_engines_pkg.tech_message (p_severity => g_log_level_2
357: ,p_module => g_block||'.trace(PROCEDURE)'
358: ,p_msg_text => 'END trace ');

Line 366: fnd_file.put_line(fnd_file.log, 'Exception - trace ' || sqlerrm);

362: WHEN OTHERS THEN
363: fem_engines_pkg.tech_message (p_severity => g_log_level_6
364: ,p_module => g_block||'.trace(PROCEDURE)'
365: ,p_msg_text => 'EXCEPTION in trace ' || sqlerrm);
366: fnd_file.put_line(fnd_file.log, 'Exception - trace ' || sqlerrm);
367: RAISE;
368:
369: END trace;
370:

Line 446: fnd_file.put_line(fnd_file.log, 'Exception - cleanup ' || sqlerrm);

442: WHEN OTHERS THEN
443: fem_engines_pkg.tech_message (p_severity => g_log_level_6
444: ,p_module => g_block||'.cleanup(PROCEDURE)'
445: ,p_msg_text => 'EXCEPTION in cleanup ' || sqlerrm);
446: fnd_file.put_line(fnd_file.log, 'Exception - cleanup ' || sqlerrm);
447: RAISE;
448: END cleanup;
449:
450: --------------

Line 490: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters ' || sqlerrm);

486: WHEN OTHERS THEN
487: fem_engines_pkg.tech_message (p_severity => g_log_level_6
488: ,p_module => g_block||'.get_parameters (PROCEDURE)'
489: ,p_msg_text => 'EXCEPTION in get_parameters.loader_type ' || sqlerrm);
490: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters ' || sqlerrm);
491: RAISE; -- loader_rule_error;
492: END;
493:
494: IF l_approval_status = 'APPROVED' THEN

Line 548: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters(DATA LOAD) ' || sqlerrm);

544: WHEN OTHERS THEN
545: fem_engines_pkg.tech_message (p_severity => g_log_level_6
546: ,p_module => g_block||'.get_parameters (PROCEDURE)'
547: ,p_msg_text => 'EXCEPTION in get_parameters ' || sqlerrm);
548: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters(DATA LOAD) ' || sqlerrm);
549: RAISE;
550: END;
551: ELSE
552: BEGIN

Line 585: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters ' || sqlerrm);

581: WHEN OTHERS THEN
582: fem_engines_pkg.tech_message (p_severity => g_log_level_6
583: ,p_module => g_block||'.get_parameters (PROCEDURE)'
584: ,p_msg_text => 'EXCEPTION in get_parameters(LEDGER LOAD) ' || sqlerrm);
585: fnd_file.put_line(fnd_file.log, 'Exception - get_parameters ' || sqlerrm);
586: RAISE;
587: END;
588:
589: END IF;

Line 626: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

622: WHEN OTHERS THEN
623: fem_engines_pkg.tech_message (p_severity => g_log_level_6
624: ,p_module => g_block||'.process_global_id(PROCEDURE)'
625: ,p_msg_text => 'EXCEPTION fetching dimension_id for LEDGER');
626: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
627: RAISE;
628: END;
629:
630: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 648: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

644: WHEN OTHERS THEN
645: fem_engines_pkg.tech_message (p_severity => g_log_level_6
646: ,p_module => g_block||'.process_global_id(PROCEDURE)'
647: ,p_msg_text => 'EXCEPTION fetching attribute_id for CAL PERIOD HIERARCHY');
648: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
649: RAISE;
650: END;
651:
652: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 668: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

664: WHEN OTHERS THEN
665: fem_engines_pkg.tech_message (p_severity => g_log_level_6
666: ,p_module => g_block||'.process_global_id(PROCEDURE)'
667: ,p_msg_text => 'EXCEPTION fetching dimension_id for CAL PERIOD');
668: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
669: RAISE;
670: END;
671:
672: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 691: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

687: WHEN OTHERS THEN
688: fem_engines_pkg.tech_message (p_severity => g_log_level_6
689: ,p_module => g_block||'.process_global_id(PROCEDURE)'
690: ,p_msg_text => 'EXCEPTION fetching attribute_id for CAL PERIOD START DATE');
691: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
692: RAISE;
693: END;
694:
695: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 715: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

711: WHEN OTHERS THEN
712: fem_engines_pkg.tech_message (p_severity => g_log_level_6
713: ,p_module => g_block||'.process_global_id(PROCEDURE)'
714: ,p_msg_text => 'EXCEPTION fetching attribute_id for CAL PERIOD END DATE');
715: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
716: RAISE;
717: END;
718:
719: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 733: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

729: WHEN OTHERS THEN
730: fem_engines_pkg.tech_message (p_severity => g_log_level_6
731: ,p_module => g_block||'.process_global_id(PROCEDURE)'
732: ,p_msg_text => 'EXCEPTION fetching dimension_id for DATASET');
733: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
734: RAISE;
735: END;
736:
737: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 756: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

752: WHEN OTHERS THEN
753: fem_engines_pkg.tech_message (p_severity => g_log_level_6
754: ,p_module => g_block||'.process_global_id(PROCEDURE)'
755: ,p_msg_text => 'EXCEPTION fetching attribute_id for DATASET BALANCE TYPE');
756: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
757: RAISE;
758: END;
759:
760: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 780: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

776: WHEN OTHERS THEN
777: fem_engines_pkg.tech_message (p_severity => g_log_level_6
778: ,p_module => g_block||'.process_global_id(PROCEDURE)'
779: ,p_msg_text => 'EXCEPTION fetching attribute_id for PRODUCTION FLAG');
780: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
781: RAISE;
782: END;
783:
784: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 799: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);

795: WHEN OTHERS THEN
796: fem_engines_pkg.tech_message (p_severity => g_log_level_6
797: ,p_module => g_block||'.process_global_id(PROCEDURE)'
798: ,p_msg_text => 'EXCEPTION fetching dimension_id for BUDGET');
799: fnd_file.put_line(fnd_file.log, 'Exception - process_global_id ' || sqlerrm);
800: RAISE;
801: END;
802:
803: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 938: fnd_file.put_line(fnd_file.log, 'Exception - wait_for_requests ' || sqlerrm);

934: WHEN OTHERS THEN
935: fem_engines_pkg.tech_message (p_severity => g_log_level_6
936: ,p_module => g_block||'.wait_for_requests(PROCEDURE)'
937: ,p_msg_text => 'EXCEPTION in wait_for_requests ' || sqlerrm);
938: fnd_file.put_line(fnd_file.log, 'Exception - wait_for_requests ' || sqlerrm);
939: RAISE;
940:
941: END wait_for_requests;
942:

Line 997: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);

993: fem_engines_pkg.tech_message (p_severity => g_log_level_6
994: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
995: ,p_msg_text => 'Error while checking if data EXISTS in interface table '
996: || dim_rec.dim_intf_table_name || ' - ' || sqlerrm);
997: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);
998: RAISE;
999: END;
1000:
1001: IF l_dummy = 1 THEN

Line 1057: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);

1053: WHEN OTHERS THEN
1054: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1055: ,p_module => g_block||'.submit_dimension_loaders(PROCEDURE)'
1056: ,p_msg_text => 'EXCEPTION in submit_dimension_loaders ' || sqlerrm);
1057: fnd_file.put_line(fnd_file.log, 'Exception - submit_dimension_loaders ' || sqlerrm);
1058: RAISE;
1059:
1060: END submit_dimension_loaders;
1061:

Line 1285: fnd_file.put_line(fnd_file.log, 'Exception - submit_data_loader ' || sqlerrm);

1281: WHEN OTHERS THEN
1282: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1283: ,p_module => g_block||'.submit_data_loaders(PROCEDURE)'
1284: ,p_msg_text => 'EXCEPTION in submit_data_loaders ' || sqlerrm);
1285: fnd_file.put_line(fnd_file.log, 'Exception - submit_data_loader ' || sqlerrm);
1286: RAISE;
1287:
1288:
1289: END submit_data_loaders;

Line 1398: fnd_file.put_line(fnd_file.log, 'Exception - submit_ledger_loader ' || sqlerrm);

1394: WHEN OTHERS THEN
1395: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1396: ,p_module => g_block||'.submit_ledger_loader(PROCEDURE)'
1397: ,p_msg_text => 'EXCEPTION in submit_ledger_loader ' || sqlerrm);
1398: fnd_file.put_line(fnd_file.log, 'Exception - submit_ledger_loader ' || sqlerrm);
1399: RAISE;
1400:
1401: END submit_ledger_loader;
1402:

Line 1499: fnd_file.put_line(fnd_file.log, 'Exception - submit_hierarchy_loaders ' || sqlerrm);

1495: WHEN OTHERS THEN
1496: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1497: ,p_module => g_block||'.submit_hierarchy_loader(PROCEDURE)'
1498: ,p_msg_text => 'EXCEPTION in submit_hierarchy_loader ' || sqlerrm);
1499: fnd_file.put_line(fnd_file.log, 'Exception - submit_hierarchy_loaders ' || sqlerrm);
1500: RAISE;
1501:
1502: END submit_hierarchy_loaders;
1503:

Line 1585: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

1581: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1582: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1583: ,p_msg_text => 'EXCEPTION in build_dim_stages - insert into
1584: fem_ld_dim_requests_gt');
1585: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1586: RAISE;
1587: END;
1588:
1589: END IF; -- l_dummy <> 1

Line 1617: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

1613: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1614: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1615: ,p_msg_text => 'EXCEPTION in build_dim_stages - fetching
1616: object_def_id for HIER');
1617: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1618: RAISE;
1619: END;
1620:
1621: END IF; -- l_object_def_id IS NULL

Line 1660: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

1656: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1657: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1658: ,p_msg_text => 'EXCEPTION in build_dim_stages - insert into
1659: fem_ld_hier_requests_gt');
1660: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1661: RAISE;
1662: END;
1663:
1664: END IF; -- l_dummy <> 1

Line 1692: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);

1688: WHEN OTHERS THEN
1689: fem_engines_pkg.tech_message (p_severity => g_log_level_6
1690: ,p_module => g_block||'.build_dim_stages(PROCEDURE)'
1691: ,p_msg_text => 'EXCEPTION in build_dim_stages ' || sqlerrm);
1692: fnd_file.put_line(fnd_file.log, 'Exception - build_dim_stages ' || sqlerrm);
1693: RAISE;
1694:
1695: END build_dim_stages;
1696:

Line 1713: fnd_file.put_line(FND_FILE.log, '=============================================================================');

1709: PROCEDURE print_params IS
1710:
1711: BEGIN
1712:
1713: fnd_file.put_line(FND_FILE.log, '=============================================================================');
1714: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');
1715:
1716: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));

Line 1714: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');

1710:
1711: BEGIN
1712:
1713: fnd_file.put_line(FND_FILE.log, '=============================================================================');
1714: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');
1715:
1716: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));
1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));

Line 1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));

1713: fnd_file.put_line(FND_FILE.log, '=============================================================================');
1714: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');
1715:
1716: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));
1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));
1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));
1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));
1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));

Line 1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));

1714: fnd_file.put_line(FND_FILE.log, '======================== Printing Parameters ==========================');
1715:
1716: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));
1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));
1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));
1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));
1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));
1722: IF g_loader_type = 'CLIENT' THEN

Line 1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));

1715:
1716: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));
1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));
1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));
1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));
1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));
1722: IF g_loader_type = 'CLIENT' THEN
1723: fnd_file.put_line(FND_FILE.log, ' Table Obj :: ' || gs_table_obj_def_id(i));

Line 1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));

1716: FOR i IN 1..gs_table_name_tab.COUNT LOOP
1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));
1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));
1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));
1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));
1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));
1722: IF g_loader_type = 'CLIENT' THEN
1723: fnd_file.put_line(FND_FILE.log, ' Table Obj :: ' || gs_table_obj_def_id(i));
1724: END IF;

Line 1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));

1717: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(i));
1718: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || gs_ledger_tab(i));
1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));
1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));
1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));
1722: IF g_loader_type = 'CLIENT' THEN
1723: fnd_file.put_line(FND_FILE.log, ' Table Obj :: ' || gs_table_obj_def_id(i));
1724: END IF;
1725: END LOOP;

Line 1723: fnd_file.put_line(FND_FILE.log, ' Table Obj :: ' || gs_table_obj_def_id(i));

1719: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || gs_ds_tab(i));
1720: fnd_file.put_line(FND_FILE.log, ' SQL Stmt :: ' || gs_sql_stmt_tab(i));
1721: fnd_file.put_line(FND_FILE.log, ' Load Option:: ' || gs_load_opt_tab(i));
1722: IF g_loader_type = 'CLIENT' THEN
1723: fnd_file.put_line(FND_FILE.log, ' Table Obj :: ' || gs_table_obj_def_id(i));
1724: END IF;
1725: END LOOP;
1726:
1727: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');

Line 1727: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');

1723: fnd_file.put_line(FND_FILE.log, ' Table Obj :: ' || gs_table_obj_def_id(i));
1724: END IF;
1725: END LOOP;
1726:
1727: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');
1728: fnd_file.put_line(FND_FILE.log, '=============================================================================');
1729:
1730:
1731: END print_params;

Line 1728: fnd_file.put_line(FND_FILE.log, '=============================================================================');

1724: END IF;
1725: END LOOP;
1726:
1727: fnd_file.put_line(FND_FILE.log, '======================== End Printing Parameters ======================');
1728: fnd_file.put_line(FND_FILE.log, '=============================================================================');
1729:
1730:
1731: END print_params;
1732:

Line 1830: fnd_file.put_line(fnd_file.log, 'Table ' || gs_table_name_tab(i) || ' does not exist ');

1826: BEGIN
1827: EXECUTE IMMEDIATE 'SELECT 1 FROM ' || gs_table_name_tab(i) || ' WHERE ROWNUM=1';
1828: EXCEPTION
1829: WHEN OTHERS THEN
1830: fnd_file.put_line(fnd_file.log, 'Table ' || gs_table_name_tab(i) || ' does not exist ');
1831: fnd_file.put_line(fnd_file.log, 'Exception - evaluate_parameters ' || sqlerrm);
1832: RAISE;
1833: END;
1834:

Line 1831: fnd_file.put_line(fnd_file.log, 'Exception - evaluate_parameters ' || sqlerrm);

1827: EXECUTE IMMEDIATE 'SELECT 1 FROM ' || gs_table_name_tab(i) || ' WHERE ROWNUM=1';
1828: EXCEPTION
1829: WHEN OTHERS THEN
1830: fnd_file.put_line(fnd_file.log, 'Table ' || gs_table_name_tab(i) || ' does not exist ');
1831: fnd_file.put_line(fnd_file.log, 'Exception - evaluate_parameters ' || sqlerrm);
1832: RAISE;
1833: END;
1834:
1835: l_dupe_count := 0.0;

Line 1991: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

1987:
1988: END LOOP; -- 1..gs_sql_stmt_tab.COUNT
1989:
1990: FOR k IN 1..gs_table_name_tab.COUNT LOOP
1991: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));

Line 1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');

1988: END LOOP; -- 1..gs_sql_stmt_tab.COUNT
1989:
1990: FOR k IN 1..gs_table_name_tab.COUNT LOOP
1991: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );

Line 1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));

1989:
1990: FOR k IN 1..gs_table_name_tab.COUNT LOOP
1991: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));

Line 1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));

1990: FOR k IN 1..gs_table_name_tab.COUNT LOOP
1991: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));

1991: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1999:

Line 1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );

1992: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1999:
2000: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));

1993: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1999:
2000: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2001: ,p_module => g_block||'.evaluate_parameters(0)'

Line 1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

1994: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
1995: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
1996: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
1997: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
1998: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
1999:
2000: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2001: ,p_module => g_block||'.evaluate_parameters(0)'
2002: ,p_msg_text => ' Table Name :: ' || gs_table_name_tab(k) ||

Line 2036: fnd_file.put_line(fnd_file.log, ' Rows updated after ID population :: ' || SQL%ROWCOUNT);

2032: fem_engines_pkg.tech_message(p_severity => g_log_level_1
2033: ,p_module => g_block||'.evaluate_parameters'
2034: ,p_msg_text => ' Rows updated after ID population(DATA LOAD) :: ' || SQL%ROWCOUNT);
2035:
2036: fnd_file.put_line(fnd_file.log, ' Rows updated after ID population :: ' || SQL%ROWCOUNT);
2037:
2038: ELSE -- g_loader_type = 'LEDGER'
2039:
2040: FOR i IN 1..gs_ledger_tab.COUNT LOOP

Line 2206: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2202:
2203: END LOOP; -- 1..gs_sql_stmt_tab.COUNT
2204:
2205: FOR k IN 1..gs_table_name_tab.COUNT LOOP
2206: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));

Line 2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');

2203: END LOOP; -- 1..gs_sql_stmt_tab.COUNT
2204:
2205: FOR k IN 1..gs_table_name_tab.COUNT LOOP
2206: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );

Line 2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));

2204:
2205: FOR k IN 1..gs_table_name_tab.COUNT LOOP
2206: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));

Line 2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));

2205: FOR k IN 1..gs_table_name_tab.COUNT LOOP
2206: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));

2206: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2214:

Line 2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );

2207: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(0) ');
2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2214:
2215: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));

2208: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || gs_table_name_tab(k));
2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2214:
2215: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2216: ,p_module => g_block||'.evaluate_parameters(0)'

Line 2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2209: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || gs_table_row_tab(k));
2210: fnd_file.put_line(FND_FILE.log, ' Dup Row :: ' || gs_sql_dup_indx_tab(k));
2211: fnd_file.put_line(FND_FILE.log, ' Dup SQL :: ' || gs_sql_dup_tab(k) );
2212: fnd_file.put_line(FND_FILE.log, ' Valid Row :: ' || gs_valid_rows(k));
2213: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2214:
2215: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2216: ,p_module => g_block||'.evaluate_parameters(0)'
2217: ,p_msg_text => ' Table Name :: ' || gs_table_name_tab(k) ||

Line 2248: fnd_file.put_line(fnd_file.log, ' Rows updated after ID population :: ' || SQL%ROWCOUNT);

2244: fem_engines_pkg.tech_message(p_severity => g_log_level_1
2245: ,p_module => g_block||'.evaluate_parameters'
2246: ,p_msg_text => ' Rows updated after ID population(LEDGER LOAD) :: ' || SQL%ROWCOUNT);
2247:
2248: fnd_file.put_line(fnd_file.log, ' Rows updated after ID population :: ' || SQL%ROWCOUNT);
2249:
2250: END IF; -- g_loader_type = 'LEDGER'
2251:
2252: IF SQL%ROWCOUNT > 0 THEN

Line 2281: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2277: FOR int_rec IN (SELECT ledger_id, dataset_code, ds_production_valid_flag, table_name, table_row
2278: FROM fem_ld_interface_data_gt
2279: ORDER BY table_row, table_name)
2280: LOOP
2281: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');
2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);

Line 2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');

2278: FROM fem_ld_interface_data_gt
2279: ORDER BY table_row, table_name)
2280: LOOP
2281: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');
2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);

Line 2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);

2279: ORDER BY table_row, table_name)
2280: LOOP
2281: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');
2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);

Line 2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);

2280: LOOP
2281: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');
2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);

2281: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');
2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2289:

Line 2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);

2282: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(1) ');
2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2289:
2290: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);

2283: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2289:
2290: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2291: ,p_module => g_block||'.evaluate_parameters(1)'

Line 2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2284: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2285: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2286: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2287: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2288: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2289:
2290: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2291: ,p_module => g_block||'.evaluate_parameters(1)'
2292: ,p_msg_text => ' Table Name :: ' || int_rec.table_name ||

Line 2338: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2334:
2335: -- The update stmt needs to be changed as there is a direct mention of
2336: -- fla.dim_attribute_numeric_member w/o querying the metadata.
2337:
2338: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2339: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);
2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));
2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 2339: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');

2335: -- The update stmt needs to be changed as there is a direct mention of
2336: -- fla.dim_attribute_numeric_member w/o querying the metadata.
2337:
2338: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2339: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);
2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));
2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2343:

Line 2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);

2336: -- fla.dim_attribute_numeric_member w/o querying the metadata.
2337:
2338: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2339: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);
2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));
2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2343:
2344: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));

2337:
2338: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2339: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);
2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));
2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2343:
2344: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2345: ,p_module => g_block||'.evaluate_parameters(1.1)'

Line 2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2338: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2339: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2340: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' COUNT(*) = ' || l_dummy);
2341: fnd_file.put_line(FND_FILE.log, ' After update ' || gs_table_name_tab(i) || ' Valid = ' || gs_valid_rows(i));
2342: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2343:
2344: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2345: ,p_module => g_block||'.evaluate_parameters(1.1)'
2346: ,p_msg_text => ' TABLE :: ' || gs_table_name_tab(i) ||

Line 2353: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2349: ' VALID :: ' || gs_valid_rows(i));
2350:
2351:
2352: ELSE
2353: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2354: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2355: fnd_file.put_line(FND_FILE.log, ' No valid rows exists for ' || gs_table_name_tab(i));
2356: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2357:

Line 2354: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');

2350:
2351:
2352: ELSE
2353: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2354: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2355: fnd_file.put_line(FND_FILE.log, ' No valid rows exists for ' || gs_table_name_tab(i));
2356: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2357:
2358: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2355: fnd_file.put_line(FND_FILE.log, ' No valid rows exists for ' || gs_table_name_tab(i));

2351:
2352: ELSE
2353: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2354: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2355: fnd_file.put_line(FND_FILE.log, ' No valid rows exists for ' || gs_table_name_tab(i));
2356: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2357:
2358: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2359: ,p_module => g_block||'.evaluate_parameters(1.1)'

Line 2356: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2352: ELSE
2353: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2354: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters ');
2355: fnd_file.put_line(FND_FILE.log, ' No valid rows exists for ' || gs_table_name_tab(i));
2356: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2357:
2358: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2359: ,p_module => g_block||'.evaluate_parameters(1.1)'
2360: ,p_msg_text => ' No valid rows exists for ' || gs_table_name_tab(i));

Line 2371: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2367: FOR int_rec IN (SELECT ledger_id, dataset_code, ds_production_valid_flag, table_name, table_row, status
2368: FROM fem_ld_interface_data_gt
2369: ORDER BY table_row, table_name)
2370: LOOP
2371: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');
2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);

Line 2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');

2368: FROM fem_ld_interface_data_gt
2369: ORDER BY table_row, table_name)
2370: LOOP
2371: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');
2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);

Line 2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);

2369: ORDER BY table_row, table_name)
2370: LOOP
2371: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');
2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);

Line 2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);

2370: LOOP
2371: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');
2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);

Line 2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);

2371: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');
2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);
2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);

2372: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(2) ');
2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);
2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2380:

Line 2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);

2373: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || int_rec.table_name);
2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);
2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2380:
2381: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);

2374: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || int_rec.table_row);
2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);
2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2380:
2381: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2382: ,p_module => g_block||'.evaluate_parameters(2)'

Line 2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2375: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || int_rec.ledger_id);
2376: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || int_rec.dataset_code);
2377: fnd_file.put_line(FND_FILE.log, ' ds valid :: ' || int_rec.ds_production_valid_flag);
2378: fnd_file.put_line(FND_FILE.log, ' Status :: ' || int_rec.status);
2379: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2380:
2381: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2382: ,p_module => g_block||'.evaluate_parameters(2)'
2383: ,p_msg_text => ' Table Name :: ' || int_rec.table_name ||

Line 2461: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2457: LPAD(TO_CHAR(idt.calendar_id),5,'0') ||
2458: LPAD(TO_CHAR(idt.time_dimension_group_key),5,'0');
2459:
2460: FOR z IN 1..g_inv_table_name.COUNT LOOP
2461: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');
2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));

Line 2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');

2458: LPAD(TO_CHAR(idt.time_dimension_group_key),5,'0');
2459:
2460: FOR z IN 1..g_inv_table_name.COUNT LOOP
2461: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');
2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));

Line 2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));

2459:
2460: FOR z IN 1..g_inv_table_name.COUNT LOOP
2461: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');
2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));

Line 2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));

2460: FOR z IN 1..g_inv_table_name.COUNT LOOP
2461: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');
2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));
2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));

2461: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');
2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));
2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2469:

Line 2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));

2462: fnd_file.put_line(FND_FILE.log, ' In Evaluate parameters(Invalid section) ');
2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));
2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2469:
2470: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));

2463: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || g_inv_table_name(z));
2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));
2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2469:
2470: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2471: ,p_module => g_block||'.evaluate_parameters(Invalid section)'

Line 2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2464: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || g_inv_table_row(z));
2465: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || g_inv_ledger(z));
2466: fnd_file.put_line(FND_FILE.log, ' Dataset :: ' || g_inv_dataset(z));
2467: fnd_file.put_line(FND_FILE.log, ' Production :: ' || g_inv_ds_pd_flag(z));
2468: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2469:
2470: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2471: ,p_module => g_block||'.evaluate_parameters(Invalid section)'
2472: ,p_msg_text => ' Table Name :: ' || g_inv_table_name(z) ||

Line 2492: fnd_file.put_line(fnd_file.log, 'Exception - evaluate_params ' || sqlerrm);

2488: WHEN OTHERS THEN
2489: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2490: ,p_module => g_block||'.evaluate_parameters(PROCEDURE)'
2491: ,p_msg_text => 'EXCEPTION in evaluate_parameters ' || sqlerrm);
2492: fnd_file.put_line(fnd_file.log, 'Exception - evaluate_params ' || sqlerrm);
2493: RAISE;
2494:
2495: END evaluate_parameters;
2496:

Line 2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2658:
2659: FOR cal_rec IN (SELECT ledger_id, table_name, table_row, cal_period_id, valid
2660: FROM fem_ld_cal_periods_gt)
2661: LOOP
2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);

Line 2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');

2659: FOR cal_rec IN (SELECT ledger_id, table_name, table_row, cal_period_id, valid
2660: FROM fem_ld_cal_periods_gt)
2661: LOOP
2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);

Line 2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);

2660: FROM fem_ld_cal_periods_gt)
2661: LOOP
2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);

Line 2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);

2661: LOOP
2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);
2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

Line 2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);

2662: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);
2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2670:

Line 2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);

2663: fnd_file.put_line(FND_FILE.log, ' In populate cal periods ');
2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);
2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2670:
2671: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);

2664: fnd_file.put_line(FND_FILE.log, ' Ledger :: ' || cal_rec.ledger_id);
2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);
2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2670:
2671: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2672: ,p_module => g_block||'.populate_cal_periods'

Line 2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');

2665: fnd_file.put_line(FND_FILE.log, ' Cal Period :: ' || cal_rec.cal_period_id);
2666: fnd_file.put_line(FND_FILE.log, ' Table Name :: ' || cal_rec.table_name);
2667: fnd_file.put_line(FND_FILE.log, ' Table Row :: ' || cal_rec.table_row);
2668: fnd_file.put_line(FND_FILE.log, ' Valid :: ' || cal_rec.valid);
2669: fnd_file.put_line(FND_FILE.log, ' ==========================================================');
2670:
2671: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2672: ,p_module => g_block||'.populate_cal_periods'
2673: ,p_msg_text => ' Table Name :: ' || cal_rec.table_name ||

Line 2690: fnd_file.put_line(FND_FILE.log, ' No valid cal Periods');

2686: g_evaluate_parameters := FALSE;
2687: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2688: ,p_module => g_block||'.populate_cal_periods'
2689: ,p_msg_text => ' No valid CAL PERIODS');
2690: fnd_file.put_line(FND_FILE.log, ' No valid cal Periods');
2691: ELSE
2692: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2693: ,p_module => g_block||'.populate_cal_periods'
2694: ,p_msg_text => 'Some valid CAL PERIODS exist');

Line 2707: fnd_file.put_line(fnd_file.log, 'Exception - populate_cal_periods ' || sqlerrm);

2703: WHEN OTHERS THEN
2704: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2705: ,p_module => g_block||'.populate_cal_periods(PROCEDURE)'
2706: ,p_msg_text => 'EXCEPTION in populate_cal_periods ' || sqlerrm);
2707: fnd_file.put_line(fnd_file.log, 'Exception - populate_cal_periods ' || sqlerrm);
2708: RAISE;
2709:
2710: END populate_cal_periods;
2711:

Line 2788: fnd_file.put_line(fnd_file.log, '=================================================================');

2784: END LOOP; -- gs_valid_rows.COUNT
2785:
2786: FOR j IN 1..g_master_rec.COUNT LOOP
2787:
2788: fnd_file.put_line(fnd_file.log, '=================================================================');
2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);

Line 2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');

2785:
2786: FOR j IN 1..g_master_rec.COUNT LOOP
2787:
2788: fnd_file.put_line(fnd_file.log, '=================================================================');
2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);

Line 2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);

2786: FOR j IN 1..g_master_rec.COUNT LOOP
2787:
2788: fnd_file.put_line(fnd_file.log, '=================================================================');
2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);

Line 2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);

2787:
2788: fnd_file.put_line(fnd_file.log, '=================================================================');
2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);

Line 2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);

2788: fnd_file.put_line(fnd_file.log, '=================================================================');
2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);

Line 2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);

2789: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2797: fnd_file.put_line(fnd_file.log, '=================================================================');

Line 2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);

2790: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2797: fnd_file.put_line(fnd_file.log, '=================================================================');
2798:

Line 2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);

2791: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2797: fnd_file.put_line(fnd_file.log, '=================================================================');
2798:
2799: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);

2792: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2797: fnd_file.put_line(fnd_file.log, '=================================================================');
2798:
2799: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2800: ,p_module => g_block||'.populate_master_table_lldr(MASTER INDEX TABLE)'

Line 2797: fnd_file.put_line(fnd_file.log, '=================================================================');

2793: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2794: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2795: fnd_file.put_line(fnd_file.log, 'Budget ID :: ' || g_master_rec(j).budget_id);
2796: fnd_file.put_line(fnd_file.log, 'Enc Type ID :: ' || g_master_rec(j).enc_type_id);
2797: fnd_file.put_line(fnd_file.log, '=================================================================');
2798:
2799: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2800: ,p_module => g_block||'.populate_master_table_lldr(MASTER INDEX TABLE)'
2801: ,p_msg_text => ' Table Name :: ' || g_master_rec(j).table_name ||

Line 2821: fnd_file.put_line(fnd_file.log, 'Exception - populate_master_table_lldr ' || sqlerrm);

2817: WHEN OTHERS THEN
2818: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2819: ,p_module => g_block||'.populate_master_table_lldr(PROCEDURE)'
2820: ,p_msg_text => 'EXCEPTION in populate_master_table_lldr ' || sqlerrm);
2821: fnd_file.put_line(fnd_file.log, 'Exception - populate_master_table_lldr ' || sqlerrm);
2822: RAISE;
2823:
2824: END populate_master_table_lldr;
2825:

Line 2896: fnd_file.put_line(fnd_file.log, '=================================================================');

2892: END LOOP; -- gs_valid_rows.COUNT
2893:
2894: FOR j IN 1..g_master_rec.COUNT LOOP
2895:
2896: fnd_file.put_line(fnd_file.log, '=================================================================');
2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);

Line 2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');

2893:
2894: FOR j IN 1..g_master_rec.COUNT LOOP
2895:
2896: fnd_file.put_line(fnd_file.log, '=================================================================');
2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);

Line 2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);

2894: FOR j IN 1..g_master_rec.COUNT LOOP
2895:
2896: fnd_file.put_line(fnd_file.log, '=================================================================');
2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);

Line 2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);

2895:
2896: fnd_file.put_line(fnd_file.log, '=================================================================');
2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);

Line 2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);

2896: fnd_file.put_line(fnd_file.log, '=================================================================');
2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);
2904: fnd_file.put_line(fnd_file.log, '=================================================================');

Line 2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);

2897: fnd_file.put_line(fnd_file.log, '===================== MASTER INDEX TABLE ========================');
2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);
2904: fnd_file.put_line(fnd_file.log, '=================================================================');
2905:

Line 2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);

2898: fnd_file.put_line(fnd_file.log, 'Table Name :: ' || g_master_rec(j).table_name);
2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);
2904: fnd_file.put_line(fnd_file.log, '=================================================================');
2905:
2906: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);

2899: fnd_file.put_line(fnd_file.log, 'Table Row :: ' || g_master_rec(j).table_row);
2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);
2904: fnd_file.put_line(fnd_file.log, '=================================================================');
2905:
2906: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2907: ,p_module => g_block||'.populate_master_table_dldr(MASTER INDEX TABLE)'

Line 2904: fnd_file.put_line(fnd_file.log, '=================================================================');

2900: fnd_file.put_line(fnd_file.log, 'Ledger ID :: ' || g_master_rec(j).ledger_id);
2901: fnd_file.put_line(fnd_file.log, 'Cal Period :: ' || g_master_rec(j).cal_period_id);
2902: fnd_file.put_line(fnd_file.log, 'Dataset Code :: ' || g_master_rec(j).dataset_code);
2903: fnd_file.put_line(fnd_file.log, 'Source System :: ' || g_master_rec(j).source_system_code);
2904: fnd_file.put_line(fnd_file.log, '=================================================================');
2905:
2906: fem_engines_pkg.tech_message (p_severity => g_log_level_1
2907: ,p_module => g_block||'.populate_master_table_dldr(MASTER INDEX TABLE)'
2908: ,p_msg_text => ' Table Name :: ' || g_master_rec(j).table_name ||

Line 2927: fnd_file.put_line(fnd_file.log, 'Exception - populate_master_table_dldr ' || sqlerrm);

2923: WHEN OTHERS THEN
2924: fem_engines_pkg.tech_message (p_severity => g_log_level_6
2925: ,p_module => g_block||'.populate_master_table_dldr(PROCEDURE)'
2926: ,p_msg_text => 'EXCEPTION in populate_master_table_dldr ' || sqlerrm);
2927: fnd_file.put_line(fnd_file.log, 'Exception - populate_master_table_dldr ' || sqlerrm);
2928: RAISE;
2929:
2930: END populate_master_table_dldr;
2931:

Line 3009: fnd_file.put_line(fnd_file.log, 'Exception - log_dimensions ' || sqlerrm);

3005: WHEN OTHERS THEN
3006: fem_engines_pkg.tech_message (p_severity => g_log_level_6
3007: ,p_module => g_block||'.log_dimensions(PROCEDURE)'
3008: ,p_msg_text => 'EXCEPTION in log_dimensions(' || p_table_name || ') - ' || sqlerrm);
3009: fnd_file.put_line(fnd_file.log, 'Exception - log_dimensions ' || sqlerrm);
3010: RAISE;
3011:
3012: END log_dimensions;
3013:

Line 3091: fnd_file.put_line(fnd_file.log, 'Exception - log_hierarchies ' || sqlerrm);

3087: WHEN OTHERS THEN
3088: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3089: ,p_module => g_block||'.log_hierarchies(PROCEDURE)'
3090: ,p_msg_text => 'EXCEPTION in log_hierarchies ' || sqlerrm);
3091: fnd_file.put_line(fnd_file.log, 'Exception - log_hierarchies ' || sqlerrm);
3092: RAISE;
3093:
3094: END log_hierarchies;
3095: ----------------------

Line 3251: fnd_file.put_line(fnd_file.log, 'Exception - log_fact_table ' || sqlerrm);

3247: fem_engines_pkg.tech_message (p_severity => g_log_level_6
3248: ,p_module => g_block||'.log_fact_table(PROCEDURE)'
3249: ,p_msg_text => 'EXCEPTION in log_fact_table(' || p_table_name || ',' ||
3250: p_table_row || ') ' || sqlerrm);
3251: fnd_file.put_line(fnd_file.log, 'Exception - log_fact_table ' || sqlerrm);
3252: RAISE;
3253: END log_fact_table;
3254:
3255: ---------------------

Line 3440: fnd_file.put_line(fnd_file.log, 'Exception - populate_log ' || sqlerrm);

3436: WHEN OTHERS THEN
3437: fem_engines_pkg.tech_message (p_severity => g_log_level_2
3438: ,p_module => g_block||'.populate_log(PROCEDURE)'
3439: ,p_msg_text => 'EXCEPTION in populate_log ' || sqlerrm);
3440: fnd_file.put_line(fnd_file.log, 'Exception - populate_log ' || sqlerrm);
3441: RAISE;
3442:
3443: END populate_log;
3444:

Line 3473: fnd_file.put_line(fnd_file.log, 'Exception - main ' || sqlerrm);

3469: fem_engines_pkg.tech_message (p_severity => g_log_level_6
3470: ,p_module => g_block||'.MAIN'
3471: ,p_msg_text => 'EXCEPTION in MAIN PACKAGE SECTION ' || sqlerrm);
3472:
3473: fnd_file.put_line(fnd_file.log, 'Exception - main ' || sqlerrm);
3474: RAISE;
3475:
3476: END Fem_Data_Loader_Pkg;