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.GCS_DYN_FEM_POSTING_PKG dependencies on FND_LOG

Line 4: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;

1: PACKAGE BODY GCS_DYN_FEM_POSTING_PKG AS
2:
3: -- Store the log level
4: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;

Line 5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;

1: PACKAGE BODY GCS_DYN_FEM_POSTING_PKG AS
2:
3: -- Store the log level
4: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;

Line 6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;

2:
3: -- Store the log level
4: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:

Line 7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;

3: -- Store the log level
4: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:
11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;

Line 8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;

4: runtimeLogLevel NUMBER := FND_LOG.g_current_runtime_level;
5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:
11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
12: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info

Line 9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;

5: statementLogLevel CONSTANT NUMBER := FND_LOG.level_statement;
6: procedureLogLevel CONSTANT NUMBER := FND_LOG.level_procedure;
7: exceptionLogLevel CONSTANT NUMBER := FND_LOG.level_exception;
8: errorLogLevel CONSTANT NUMBER := FND_LOG.level_error;
9: unexpectedLogLevel CONSTANT NUMBER := FND_LOG.level_unexpected;
10:
11: g_src_sys_code NUMBER := GCS_UTILITY_PKG.g_gcs_source_system_code;
12: g_dimension_attr_info gcs_utility_pkg.t_hash_dimension_attr_info
13: := gcs_utility_pkg.g_dimension_attr_info;

Line 38: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.POPULATE_GT_TABLE.begin', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

34:
35: BEGIN
36:
37: IF (procedureloglevel >= runtimeloglevel ) THEN
38: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.POPULATE_GT_TABLE.begin', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
39: END IF;
40:
41: IF (p_entry_id IS NOT NULL OR p_run_detail_id IS NOT NULL) THEN
42: IF (p_entry_id IS NOT NULL) THEN

Line 375: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.POPULATE_GT_TABLE.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

371: END;
372: END IF;
373:
374: IF (procedureloglevel >= runtimeloglevel ) THEN
375: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.POPULATE_GT_TABLE.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
376: END IF;
377:
378: END Populate_GT_Table;
379:

Line 410: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT.begin', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

406:
407: BEGIN
408:
409: IF (procedureloglevel >= runtimeloglevel ) THEN
410: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT.begin', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
411: END IF;
412:
413: Populate_Gt_Table(p_category_code => p_category_code,
414: p_cons_entity_id => p_cons_entity_id,

Line 477: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

473: DECODE(p_topmost_entity_flag, 'Y', YTD_BALANCE_E, NULL) YTD_BALANCE_F
474: FROM GCS_FEM_POSTING_GT;
475:
476: IF (procedureloglevel >= runtimeloglevel ) THEN
477: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
478: END IF;
479:
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN

Line 483: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT', 'GCS_NO_DATA_FOUND');

479:
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482: IF (unexpectedloglevel >= runtimeloglevel ) THEN
483: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT', 'GCS_NO_DATA_FOUND');
484: END IF;
485: retcode := '0';
486: errbuf := 'GCS_NO_DATA_FOUND';
487: RAISE NO_DATA_FOUND;

Line 492: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT', errbuf);

488:
489: WHEN OTHERS THEN
490: errbuf := substr( SQLERRM, 1, 2000);
491: IF (unexpectedloglevel >= runtimeloglevel ) THEN
492: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_INSERT', errbuf);
493: END IF;
494: retcode := '0';
495: RAISE;
496:

Line 522: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_MERGE.begin', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

518:
519: BEGIN
520:
521: IF (procedureloglevel >= runtimeloglevel ) THEN
522: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_MERGE.begin', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
523: END IF;
524:
525: Populate_Gt_Table(p_category_code => p_category_code,
526: p_cons_entity_id => p_cons_entity_id,

Line 732: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.PROCESS_MERGE.rowcount ', to_char(SQL%ROWCOUNT));

728: l_login_id
729: FROM GCS_FEM_POSTING_GT GFPG;
730:
731: IF (statementloglevel >= runtimeloglevel ) THEN
732: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.PROCESS_MERGE.rowcount ', to_char(SQL%ROWCOUNT));
733: END IF;
734:
735: -- If there are any rows processed, then register to FEM_DATA_LOCATIONS
736: IF (SQL%ROWCOUNT <> 0) THEN

Line 750: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_MERGE.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

746:
747: END IF;
748:
749: IF (procedureloglevel >= runtimeloglevel ) THEN
750: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.PROCESS_MERGE.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
751: END IF;
752:
753: -- FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success || 'PROCESS_MERGE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
754:

Line 758: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'GCS_NO_DATA_FOUND');

754:
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
757: IF (unexpectedloglevel >= runtimeloglevel ) THEN
758: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'GCS_NO_DATA_FOUND');
759: END IF;
760: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
761: -- 'PROCESS_MERGE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
762: retcode := '0';

Line 769: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', errbuf);

765:
766: WHEN OTHERS THEN
767: errbuf := substr( SQLERRM, 1, 2000);
768: IF (unexpectedloglevel >= runtimeloglevel ) THEN
769: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', errbuf);
770: END IF;
771: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
772: -- 'PROCESS_MERGE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
773: retcode := '0';

Line 809: runtimeLogLevel := FND_LOG.g_current_runtime_level;

805: l_entity_id NUMBER;
806:
807: BEGIN
808:
809: runtimeLogLevel := FND_LOG.g_current_runtime_level;
810:
811: IF (procedureloglevel >= runtimeloglevel ) THEN
812: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;

Line 812: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

808:
809: runtimeLogLevel := FND_LOG.g_current_runtime_level;
810:
811: IF (procedureloglevel >= runtimeloglevel ) THEN
812: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;
814: IF (statementloglevel >= runtimeloglevel ) THEN
815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));

Line 815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);

811: IF (procedureloglevel >= runtimeloglevel ) THEN
812: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;
814: IF (statementloglevel >= runtimeloglevel ) THEN
815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);
818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);
819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);

Line 816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));

812: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
813: END IF;
814: IF (statementloglevel >= runtimeloglevel ) THEN
815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);
818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);
819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);
820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));

Line 817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);

813: END IF;
814: IF (statementloglevel >= runtimeloglevel ) THEN
815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);
818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);
819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);
820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));
821: END IF;

Line 818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);

814: IF (statementloglevel >= runtimeloglevel ) THEN
815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);
818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);
819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);
820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));
821: END IF;
822:

Line 819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);

815: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_run_name = ' || p_run_name);
816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);
818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);
819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);
820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));
821: END IF;
822:
823: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));

816: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
817: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_balance_type_code = ' || p_balance_type_code);
818: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_mode = ' || p_mode);
819: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_category_code = ' || p_category_code);
820: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'p_entry_id = ' || to_char(p_entry_id));
821: END IF;
822:
823: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter || 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
824:

Line 869: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.undo.balrowcount ', to_char(SQL%ROWCOUNT));

865: AND source_system_code = g_src_sys_code
866: AND entity_id = l_entity_id;
867:
868: IF (statementloglevel >= runtimeloglevel ) THEN
869: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.undo.balrowcount ', to_char(SQL%ROWCOUNT));
870: END IF;
871: --Bugfix 5704055: Removed Deletion from GCS_FEM_CONTRIBUTIONS_H
872: --This mode will only be called for removal of Translation Rows
873: ELSIF p_undo = 'Y' AND p_entry_id IS NOT NULL THEN

Line 888: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.undo.balrowcount ', to_char(SQL%ROWCOUNT));

884: AND source_system_code = g_src_sys_code
885: AND entity_id = l_entity_id;
886:
887: IF (statementloglevel >= runtimeloglevel ) THEN
888: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.undo.balrowcount ', to_char(SQL%ROWCOUNT));
889: END IF;
890: --Bugfix 5704055: Removed Deletion from GCS_FEM_CONTRIBUTIONS_H
891: END IF;
892: EXCEPTION

Line 940: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

936: END IF;
937:
938:
939: IF (procedureloglevel >= runtimeloglevel ) THEN
940: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST.end', to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
941: END IF;
942: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
943: -- 'gcs_fem_post' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
944: EXCEPTION

Line 947: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'GCS_NO_DATA_FOUND');

943: -- 'gcs_fem_post' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
944: EXCEPTION
945: WHEN NO_DATA_FOUND THEN
946: IF (unexpectedloglevel >= runtimeloglevel ) THEN
947: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', 'GCS_NO_DATA_FOUND');
948: END IF;
949: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
950: -- 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
951: retcode := '0';

Line 958: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

954:
955: WHEN no_proc_data_err THEN
956: retcode := gcs_utility_pkg.g_ret_sts_warn;
957: errbuf := 'No processing data found.';
958: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
959: fnd_log.STRING (fnd_log.level_error,
960: 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST',
961: gcs_utility_pkg.g_module_failure
962: || ' '

Line 959: fnd_log.STRING (fnd_log.level_error,

955: WHEN no_proc_data_err THEN
956: retcode := gcs_utility_pkg.g_ret_sts_warn;
957: errbuf := 'No processing data found.';
958: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
959: fnd_log.STRING (fnd_log.level_error,
960: 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST',
961: gcs_utility_pkg.g_module_failure
962: || ' '
963: || errbuf

Line 971: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', errbuf);

967:
968: WHEN OTHERS THEN
969: errbuf := substr( SQLERRM, 1, 2000);
970: IF (unexpectedloglevel >= runtimeloglevel ) THEN
971: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_POST', errbuf);
972: END IF;
973: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
974: -- 'GCS_FEM_POST' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
975: retcode := '0';

Line 1000: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

996: g_elim_entity_ver NUMBER(15) := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ELIMINATION_ENTITY').version_id;
997: BEGIN
998:
999: IF (procedureloglevel >= runtimeloglevel ) THEN
1000: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1001: END IF;
1002: IF (statementloglevel >= runtimeloglevel ) THEN
1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));

Line 1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));

999: IF (procedureloglevel >= runtimeloglevel ) THEN
1000: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1001: END IF;
1002: IF (statementloglevel >= runtimeloglevel ) THEN
1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));
1005: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_balance_type_code = ' || p_balance_type_code);
1006: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_id = ' || to_char(p_entity_id));
1007: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_type = ' || p_entity_type);

Line 1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));

1000: FND_LOG.STRING(procedureloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.begin' || GCS_UTILITY_PKG.g_module_enter, to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1001: END IF;
1002: IF (statementloglevel >= runtimeloglevel ) THEN
1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));
1005: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_balance_type_code = ' || p_balance_type_code);
1006: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_id = ' || to_char(p_entity_id));
1007: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_type = ' || p_entity_type);
1008: END IF;

Line 1005: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_balance_type_code = ' || p_balance_type_code);

1001: END IF;
1002: IF (statementloglevel >= runtimeloglevel ) THEN
1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));
1005: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_balance_type_code = ' || p_balance_type_code);
1006: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_id = ' || to_char(p_entity_id));
1007: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_type = ' || p_entity_type);
1008: END IF;
1009:

Line 1006: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_id = ' || to_char(p_entity_id));

1002: IF (statementloglevel >= runtimeloglevel ) THEN
1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));
1005: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_balance_type_code = ' || p_balance_type_code);
1006: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_id = ' || to_char(p_entity_id));
1007: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_type = ' || p_entity_type);
1008: END IF;
1009:
1010: -- Get the ledger_id

Line 1007: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_type = ' || p_entity_type);

1003: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
1004: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_cal_period_id = ' || to_char(p_cal_period_id));
1005: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_balance_type_code = ' || p_balance_type_code);
1006: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_id = ' || to_char(p_entity_id));
1007: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'p_entity_type = ' || p_entity_type);
1008: END IF;
1009:
1010: -- Get the ledger_id
1011: SELECT ghb.fem_ledger_id

Line 1087: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.rowcount ', to_char(SQL%ROWCOUNT));

1083:
1084: END IF;
1085:
1086: IF (statementloglevel >= runtimeloglevel ) THEN
1087: FND_LOG.STRING(statementloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE.rowcount ', to_char(SQL%ROWCOUNT));
1088: END IF;
1089:
1090: EXCEPTION
1091: WHEN NO_DATA_FOUND THEN

Line 1093: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'GCS_NO_DATA_FOUND');

1089:
1090: EXCEPTION
1091: WHEN NO_DATA_FOUND THEN
1092: IF (unexpectedloglevel >= runtimeloglevel ) THEN
1093: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', 'GCS_NO_DATA_FOUND');
1094: END IF;
1095: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1096: -- 'GCS_FEM_DELETE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1097: retcode := '0';

Line 1104: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', errbuf);

1100:
1101: WHEN OTHERS THEN
1102: errbuf := substr( SQLERRM, 1, 2000);
1103: IF (unexpectedloglevel >= runtimeloglevel ) THEN
1104: FND_LOG.STRING(unexpectedloglevel, 'gcs.plsql.GCS_FEM_POSTING_PKG.GCS_FEM_DELETE', errbuf);
1105: END IF;
1106: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
1107: -- 'GCS_FEM_DELETE' || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
1108: retcode := '0';