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_DATA_PREP_PKG dependencies on GCS_DATA_PREP_PKG

Line 1: PACKAGE BODY GCS_DATA_PREP_PKG AS

1: PACKAGE BODY GCS_DATA_PREP_PKG AS
2: /* $Header: gcsdpb.pls 120.23 2007/11/14 17:09:37 smatam ship $ */
3: --
4: -- Exceptions
5: --

Line 17: g_pkg_name CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_DATA_PREP_PKG';

13: -- A newline character. Included for convenience when writing long strings.
14: g_nl CONSTANT VARCHAR2(1) := '
15: ';
16: -- The API name
17: g_pkg_name CONSTANT VARCHAR2(30) := 'gcs.plsql.GCS_DATA_PREP_PKG';
18: -- get_dimension_text
19: -- Purpose
20: -- Create part of the dynamic sql.
21: -- Arguments

Line 36: 'GCS_DATA_PREP_PKG::get_dimension_text -- Enter');

32: BEGIN
33: fnd_file.put_line(fnd_file.log,
34: '============================================');
35: fnd_file.put_line(fnd_file.log,
36: 'GCS_DATA_PREP_PKG::get_dimension_text -- Enter');
37: fnd_file.put_line(fnd_file.log, 'p_prefix := ' || p_prefix);
38: fnd_file.put_line(fnd_file.log, 'p_suffix := ' || p_suffix);
39: fnd_file.put_line(fnd_file.log, 'p_repeat_flag := ' || p_repeat_flag);
40: fnd_file.put_line(fnd_file.log, 'Beginning of parameters ');

Line 69: 'GCS_DATA_PREP_PKG::get_dimension_text -- Exit');

65: l_index_column_name := gcs_utility_pkg.g_gcs_dimension_info.NEXT(l_index_column_name);
66: END LOOP;
67: fnd_file.put_line(fnd_file.log, 'l_dim_text := ' || l_dim_text);
68: fnd_file.put_line(fnd_file.log,
69: 'GCS_DATA_PREP_PKG::get_dimension_text -- Exit');
70: fnd_file.put_line(fnd_file.log,
71: '============================================');
72: RETURN l_dim_text;
73: END get_dimension_text;

Line 1242: 'GCS_DATA_PREP_PKG::create_process -- Enter');

1238: SAVEPOINT create_process_start;
1239: fnd_file.put_line(fnd_file.log,
1240: '============================================');
1241: fnd_file.put_line(fnd_file.log,
1242: 'GCS_DATA_PREP_PKG::create_process -- Enter');
1243: --Bugfix 5329620: Determine Currency Clause Based on Status of Financial Element
1244: IF (gcs_utility_pkg.get_dimension_required('FINANCIAL_ELEM_ID') = 'Y') THEN
1245: l_curr_where_clause := '
1246: AND fb.currency_code IN (p_source_currency_code, ''STAT'')

Line 3270: 'GCS_DATA_PREP_PKG::create_process -- Before ad_ddl.create_plsql_object API Call');

3266: END LOOP;
3267: fnd_file.put_line(fnd_file.log, '@ad_ddl.build_statement --- 10');
3268: fnd_file.put_line(fnd_file.log, 'Body Length :=' || body_len);
3269: fnd_file.put_line(fnd_file.log,
3270: 'GCS_DATA_PREP_PKG::create_process -- Before ad_ddl.create_plsql_object API Call');
3271: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
3272: 'GCS',
3273: 'GCS_DP_DYNAMIC_PKG',
3274: 1,

Line 3279: 'GCS_DATA_PREP_PKG::create_process -- After ad_ddl.create_plsql_object API Call');

3275: lines,
3276: 'FALSE',
3277: err);
3278: fnd_file.put_line(fnd_file.log,
3279: 'GCS_DATA_PREP_PKG::create_process -- After ad_ddl.create_plsql_object API Call');
3280: fnd_file.put_line(fnd_file.log,
3281: 'GCS_DATA_PREP_PKG::create_process -- End');
3282: fnd_file.put_line(fnd_file.log,
3283: '=========================================');

Line 3281: 'GCS_DATA_PREP_PKG::create_process -- End');

3277: err);
3278: fnd_file.put_line(fnd_file.log,
3279: 'GCS_DATA_PREP_PKG::create_process -- After ad_ddl.create_plsql_object API Call');
3280: fnd_file.put_line(fnd_file.log,
3281: 'GCS_DATA_PREP_PKG::create_process -- End');
3282: fnd_file.put_line(fnd_file.log,
3283: '=========================================');
3284: EXCEPTION
3285: -- no required dimension found

Line 3297: 'GCS_DATA_PREP_PKG::create_process -- NO_DATA_FOUND Exception');

3293: gcs_utility_pkg.g_module_failure || ' ' ||
3294: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3295: END IF;
3296: fnd_file.put_line(fnd_file.log,
3297: 'GCS_DATA_PREP_PKG::create_process -- NO_DATA_FOUND Exception');
3298: fnd_file.put_line(fnd_file.log,
3299: 'GCS_DATA_PREP_PKG::create_process -- End');
3300: fnd_file.put_line(fnd_file.log,
3301: '=========================================');

Line 3299: 'GCS_DATA_PREP_PKG::create_process -- End');

3295: END IF;
3296: fnd_file.put_line(fnd_file.log,
3297: 'GCS_DATA_PREP_PKG::create_process -- NO_DATA_FOUND Exception');
3298: fnd_file.put_line(fnd_file.log,
3299: 'GCS_DATA_PREP_PKG::create_process -- End');
3300: fnd_file.put_line(fnd_file.log,
3301: '=========================================');
3302: WHEN OTHERS THEN
3303: ROLLBACK TO create_process_start;

Line 3313: 'GCS_DATA_PREP_PKG::create_process -- OTHERS Exception := ' ||

3309: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf || ' ' ||
3310: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3311: END IF;
3312: fnd_file.put_line(fnd_file.log,
3313: 'GCS_DATA_PREP_PKG::create_process -- OTHERS Exception := ' ||
3314: x_errbuf);
3315: fnd_file.put_line(fnd_file.log,
3316: 'GCS_DATA_PREP_PKG::create_process -- End');
3317: fnd_file.put_line(fnd_file.log,

Line 3316: 'GCS_DATA_PREP_PKG::create_process -- End');

3312: fnd_file.put_line(fnd_file.log,
3313: 'GCS_DATA_PREP_PKG::create_process -- OTHERS Exception := ' ||
3314: x_errbuf);
3315: fnd_file.put_line(fnd_file.log,
3316: 'GCS_DATA_PREP_PKG::create_process -- End');
3317: fnd_file.put_line(fnd_file.log,
3318: '=========================================');
3319: END create_process;
3320: ---------------------------------------------------------------------------

Line 3417: END gcs_data_prep_pkg;

3413: gcs_utility_pkg.g_module_failure || ' ' || x_errbuf ||
3414: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
3415: END IF;
3416: END gcs_incremental_data_prep;
3417: END gcs_data_prep_pkg;