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.

[Home] [Help]

APPS.GCS_AGGREGATION_DYN_BUILD_PKG dependencies on GCS_UTILITY_PKG

Line 41: GCS_UTILITY_PKG.g_module_enter || fn_name ||

37: BEGIN
38: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
39: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
40: g_api || '.' || fn_name,
41: GCS_UTILITY_PKG.g_module_enter || fn_name ||
42: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
43: END IF;
44: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
45: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 44: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

40: g_api || '.' || fn_name,
41: GCS_UTILITY_PKG.g_module_enter || fn_name ||
42: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
43: END IF;
44: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
45: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
46:
47: -- **************************************************
48:

Line 49: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;

45: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
46:
47: -- **************************************************
48:
49: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;
50: l_num_dims := 0;
51: l_prefix := '';
52: l_suffix := '';
53:

Line 57: l_dim_req := GCS_UTILITY_PKG.get_dimension_required(l_col_name);

53:
54: LOOP
55: EXIT WHEN (l_col_name IS NULL);
56:
57: l_dim_req := GCS_UTILITY_PKG.get_dimension_required(l_col_name);
58:
59: -- skip certain dimensions, and only process required dimensions
60: IF ( l_dim_req = 'Y'
61: AND l_col_name NOT IN ('COMPANY_COST_CENTER_ORG_ID',

Line 79: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.NEXT(l_col_name);

75: l_suffix := l_suffix || ' ''N''),';
76: END IF;
77: END IF;
78:
79: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.NEXT(l_col_name);
80: END LOOP;
81:
82: -- **************************************************
83:

Line 87: GCS_UTILITY_PKG.g_module_success || fn_name ||

83:
84: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
85: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
86: g_api || '.' || fn_name,
87: GCS_UTILITY_PKG.g_module_success || fn_name ||
88: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
89: END IF;
90: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
91: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 90: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

86: g_api || '.' || fn_name,
87: GCS_UTILITY_PKG.g_module_success || fn_name ||
88: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
89: END IF;
90: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
91: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
92:
93: -- **************************************************
94: RETURN (l_prefix || l_suffix);

Line 101: GCS_UTILITY_PKG.g_module_failure || fn_name ||

97: WHEN OTHERS THEN
98: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
99: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
100: g_api || '.' || fn_name,
101: GCS_UTILITY_PKG.g_module_failure || fn_name ||
102: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
103: END IF;
104: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
105: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 104: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

100: g_api || '.' || fn_name,
101: GCS_UTILITY_PKG.g_module_failure || fn_name ||
102: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
103: END IF;
104: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
105: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
106: RAISE;
107: END build_dim_match_str;
108:

Line 135: GCS_UTILITY_PKG.g_module_enter || fn_name ||

131: BEGIN
132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
134: g_api || '.' || fn_name,
135: GCS_UTILITY_PKG.g_module_enter || fn_name ||
136: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
137: END IF;
138: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
139: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 138: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

134: g_api || '.' || fn_name,
135: GCS_UTILITY_PKG.g_module_enter || fn_name ||
136: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
137: END IF;
138: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
139: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
140:
141: -- **************************************************
142: -- GCS_UTILITY_PKG.init_dimension_info;

Line 142: -- GCS_UTILITY_PKG.init_dimension_info;

138: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
139: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
140:
141: -- **************************************************
142: -- GCS_UTILITY_PKG.init_dimension_info;
143:
144: g_common_str := ' decode(''Y'',
145: -- matching against Retained Earnings Account template
146: ' || build_dim_match_str('l_re_template') || ' l_default_org_id,

Line 155: GCS_UTILITY_PKG.g_module_success || fn_name ||

151: -- **************************************************
152: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
154: g_api || '.' || fn_name,
155: GCS_UTILITY_PKG.g_module_success || fn_name ||
156: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
157: END IF;
158: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
159: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 158: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

154: g_api || '.' || fn_name,
155: GCS_UTILITY_PKG.g_module_success || fn_name ||
156: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
157: END IF;
158: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
159: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
160:
161: EXCEPTION
162: WHEN OTHERS THEN

Line 166: GCS_UTILITY_PKG.g_module_failure || fn_name ||

162: WHEN OTHERS THEN
163: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
164: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
165: g_api || '.' || fn_name,
166: GCS_UTILITY_PKG.g_module_failure || fn_name ||
167: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
168: END IF;
169: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
170: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 169: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

165: g_api || '.' || fn_name,
166: GCS_UTILITY_PKG.g_module_failure || fn_name ||
167: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
168: END IF;
169: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
170: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
171: RAISE;
172: END build_org_id_str;
173:

Line 192: GCS_UTILITY_PKG.g_module_enter || fn_name ||

188: BEGIN
189: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
190: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
191: g_api || '.' || fn_name,
192: GCS_UTILITY_PKG.g_module_enter || fn_name ||
193: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
194: END IF;
195: g_subqry_sel := '';
196: g_subqry_grp := '';

Line 198: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;

194: END IF;
195: g_subqry_sel := '';
196: g_subqry_grp := '';
197:
198: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;
199: LOOP
200: EXIT WHEN (l_col_name IS NULL);
201:
202: l_dim_req := GCS_UTILITY_PKG.get_dimension_required(l_col_name);

Line 202: l_dim_req := GCS_UTILITY_PKG.get_dimension_required(l_col_name);

198: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.FIRST;
199: LOOP
200: EXIT WHEN (l_col_name IS NULL);
201:
202: l_dim_req := GCS_UTILITY_PKG.get_dimension_required(l_col_name);
203:
204: -- skip certain dimensions, and only process required dimensions
205: IF ( l_dim_req = 'Y'
206: AND l_col_name NOT IN ('COMPANY_COST_CENTER_ORG_ID',

Line 227: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.NEXT(l_col_name);

223: l_ct_prefix || l_col_name || ',
224: ';
225: END IF;
226:
227: l_col_name := GCS_UTILITY_PKG.g_gcs_dimension_info.NEXT(l_col_name);
228: END LOOP;
229:
230: -- **************************************************
231:

Line 235: GCS_UTILITY_PKG.g_module_success || fn_name ||

231:
232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
234: g_api || '.' || fn_name,
235: GCS_UTILITY_PKG.g_module_success || fn_name ||
236: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
237: END IF;
238: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
239: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 238: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

234: g_api || '.' || fn_name,
235: GCS_UTILITY_PKG.g_module_success || fn_name ||
236: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
237: END IF;
238: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
239: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
240:
241: EXCEPTION
242: WHEN OTHERS THEN

Line 246: GCS_UTILITY_PKG.g_module_failure || fn_name ||

242: WHEN OTHERS THEN
243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
244: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
245: g_api || '.' || fn_name,
246: GCS_UTILITY_PKG.g_module_failure || fn_name ||
247: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
248: END IF;
249: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
250: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 249: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

245: g_api || '.' || fn_name,
246: GCS_UTILITY_PKG.g_module_failure || fn_name ||
247: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
248: END IF;
249: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
250: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
251: RAISE;
252: END build_gct_subqry_clauses;
253:

Line 275: GCS_UTILITY_PKG.g_module_enter || fn_name ||

271: BEGIN
272: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
274: g_api || '.' || fn_name,
275: GCS_UTILITY_PKG.g_module_enter || fn_name ||
276: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
277: END IF;
278: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
279: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 278: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

274: g_api || '.' || fn_name,
275: GCS_UTILITY_PKG.g_module_enter || fn_name ||
276: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
277: END IF;
278: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
279: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
280:
281: -- prepare building block strings
282: build_org_id_str;

Line 286: ' || g_common_str || GCS_UTILITY_PKG.g_nl;

282: build_org_id_str;
283: build_gct_subqry_clauses;
284:
285: l_org_dim_str := ' -- company_cost_center_org_id
286: ' || g_common_str || GCS_UTILITY_PKG.g_nl;
287:
288: l_ic_dim_str := ' -- intercompany_id
289: decode(intercompany_id, company_cost_center_org_id,
290: decode(l_intercompany_id, NULL,

Line 292: intercompany_id), intercompany_id),' || GCS_UTILITY_PKG.g_nl;

288: l_ic_dim_str := ' -- intercompany_id
289: decode(intercompany_id, company_cost_center_org_id,
290: decode(l_intercompany_id, NULL,
291: ' || g_common_str || '
292: intercompany_id), intercompany_id),' || GCS_UTILITY_PKG.g_nl;
293:
294: body_block :=
295: 'CREATE OR REPLACE PACKAGE BODY GCS_AGGREGATION_DYNAMIC_PKG AS
296: /* $Header: gcsaggbb.pls 120.3 2006/03/06 23:05:29 yingliu noship $ */

Line 349: gcs_utility_pkg.get_org_id(child_entity_id, hierarchy_id) org_id

345: l_sus_template GCS_TEMPLATES_PKG.TemplateRecord;
346:
347: CURSOR get_child_info IS
348: SELECT child_entity_id,
349: gcs_utility_pkg.get_org_id(child_entity_id, hierarchy_id) org_id
350: FROM gcs_cons_relationships
351: WHERE hierarchy_id = p_hierarchy_id
352: AND parent_entity_id = p_cons_entity_id
353: AND actual_ownership_flag = ''Y'';

Line 359: GCS_UTILITY_PKG.g_module_enter || fn_name ||

355: BEGIN
356: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
358: g_api || ''.'' || fn_name,
359: GCS_UTILITY_PKG.g_module_enter || fn_name ||
360: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
361: END IF;
362: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
363: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

Line 362: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

358: g_api || ''.'' || fn_name,
359: GCS_UTILITY_PKG.g_module_enter || fn_name ||
360: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
361: END IF;
362: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||
363: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
364:
365: -- Get information of the hierarchy
366: SELECT balance_by_org_flag

Line 398: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

394: line_num := line_num + 1;
395: END LOOP;
396:
397: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
398: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
399:
400: body_block :=
401: ' xtd_balance_e, ytd_balance_e,
402: ptd_debit_balance_e, ptd_credit_balance_e,

Line 421: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

417: line_num := line_num + 1;
418: END LOOP;
419:
420: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
421: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
422:
423: body_block :=
424: ' sum(xtd_balance_e), sum(ytd_balance_e),
425: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),

Line 447: AND fb.source_system_code = GCS_UTILITY_PKG.g_gcs_source_system_code

443: AND nvl(gt.consolidation_type_code, ''FULL'') <> ''NONE''
444: AND fb.dataset_code = p_dataset_code
445: AND fb.ledger_id = ghb.fem_ledger_id
446: AND fb.cal_period_id = p_cal_period_id
447: AND fb.source_system_code = GCS_UTILITY_PKG.g_gcs_source_system_code
448: AND fb.currency_code IN (p_currency_code, ''STAT'')
449: AND fb.entity_id = gcr.child_entity_id
450: GROUP BY
451: fb.currency_code,

Line 466: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);

462: line_num := line_num + 1;
463: END LOOP;
464:
465: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
466: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);
467:
468: body_block :=
469: ' fb.line_item_id;
470:

Line 475: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_cons_entity_id,

471: ELSE -- Balancing by Entity: need special handling of RE/Suspense/CTA
472:
473: -- Values used for the special processing:
474: -- * default org id for the consolidation entity
475: l_default_org_id := GCS_UTILITY_PKG.get_org_id(p_cons_entity_id,
476: p_hierarchy_id);
477:
478: -- * For determining intercompany type
479: SELECT specific_intercompany_id

Line 525: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

521: line_num := line_num + 1;
522: END LOOP;
523:
524: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
525: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
526:
527: body_block :=
528: ' xtd_balance_e, ytd_balance_e,
529: ptd_debit_balance_e, ptd_credit_balance_e,

Line 567: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);

563: END LOOP;
564:
565: -- optional active dimensions
566: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
567: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);
568:
569: body_block :=
570: ' sum(xtd_balance_e), sum(ytd_balance_e),
571: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),

Line 589: AND fb.source_system_code = gcs_utility_pkg.g_gcs_source_system_code

585: AND NVL(gt.consolidation_type_code, ''FULL'') <> ''NONE''
586: AND fb.dataset_code = p_dataset_code
587: AND fb.ledger_id = ghb.fem_ledger_id
588: AND fb.cal_period_id = p_cal_period_id
589: AND fb.source_system_code = gcs_utility_pkg.g_gcs_source_system_code
590: AND fb.currency_code IN (p_currency_code, ''STAT'')
591: AND fb.entity_id = gcr.child_entity_id
592: GROUP BY
593: fb.currency_code,

Line 627: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);

623: END LOOP;
624:
625: -- optional active dimensions
626: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
627: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);
628:
629: body_block :=
630: ' fb.line_item_id;
631:

Line 651: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

647: END LOOP;
648:
649: -- optional active dimensions
650: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
651: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
652:
653: body_block :=
654: ' line_item_id, company_cost_center_org_id) IN (
655: SELECT

Line 719: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

715: END LOOP;
716:
717: -- optional active dimensions
718: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
719: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
720:
721: body_block :=
722: ' xtd_balance_e, ytd_balance_e,
723: ptd_debit_balance_e, ptd_credit_balance_e,

Line 742: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

738: END LOOP;
739:
740: -- optional active dimensions
741: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
742: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
743:
744: body_block :=
745: '
746: SUM (xtd_balance_e), SUM (ytd_balance_e),

Line 767: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);

763: END LOOP;
764:
765: -- optional active dimensions
766: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
767: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
768:
769: body_block :=
770: ' company_cost_center_org_id,
771: line_item_id,

Line 784: GCS_UTILITY_PKG.g_module_success || fn_name ||

780:
781: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
783: g_api || ''.'' || fn_name,
784: GCS_UTILITY_PKG.g_module_success || fn_name ||
785: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
786: END IF;
787: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
788: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

Line 787: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

783: g_api || ''.'' || fn_name,
784: GCS_UTILITY_PKG.g_module_success || fn_name ||
785: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
786: END IF;
787: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
788: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
789:
790: EXCEPTION
791: WHEN OTHERS THEN

Line 795: GCS_UTILITY_PKG.g_module_failure || fn_name ||

791: WHEN OTHERS THEN
792: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
794: g_api || ''.'' || fn_name,
795: GCS_UTILITY_PKG.g_module_failure || fn_name ||
796: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
797: END IF;
798: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
799: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));

Line 798: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

794: g_api || ''.'' || fn_name,
795: GCS_UTILITY_PKG.g_module_failure || fn_name ||
796: to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
797: END IF;
798: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
799: -- fn_name || to_char(sysdate, '' DD-MON-YYYY HH:MI:SS''));
800: RAISE;
801: END insert_full_entry_lines;
802:

Line 821: GCS_UTILITY_PKG.g_module_success || fn_name ||

817:
818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
819: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
820: g_api || '.' || fn_name,
821: GCS_UTILITY_PKG.g_module_success || fn_name ||
822: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
823: END IF;
824: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
825: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 824: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||

820: g_api || '.' || fn_name,
821: GCS_UTILITY_PKG.g_module_success || fn_name ||
822: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
823: END IF;
824: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_success ||
825: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
826:
827: EXCEPTION
828: WHEN OTHERS THEN

Line 835: GCS_UTILITY_PKG.g_module_failure || fn_name ||

831: g_api || '.' || fn_name,
832: SUBSTR(SQLERRM, 1, 4000));
833: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
834: g_api || '.' || fn_name,
835: GCS_UTILITY_PKG.g_module_failure || fn_name ||
836: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
837: END IF;
838: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
839: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 838: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||

834: g_api || '.' || fn_name,
835: GCS_UTILITY_PKG.g_module_failure || fn_name ||
836: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
837: END IF;
838: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
839: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
840: END create_package;
841:
842: END GCS_AGGREGATION_DYN_BUILD_PKG;