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_AGGREGATION_PKG dependencies on FND_LOG

Line 35: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

31: p_curr_round_factor NUMBER)
32: IS
33: fn_name VARCHAR2(30) := 'INSERT_PROP_ENTRY_LINES';
34: BEGIN
35: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
36: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
37: g_api || '.' || fn_name,
38: GCS_UTILITY_PKG.g_module_enter || fn_name ||
39: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 36: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

32: IS
33: fn_name VARCHAR2(30) := 'INSERT_PROP_ENTRY_LINES';
34: BEGIN
35: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
36: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
37: g_api || '.' || fn_name,
38: GCS_UTILITY_PKG.g_module_enter || fn_name ||
39: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
40: END IF;

Line 82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

78: sysdate, last_updated_by, last_update_login
79: FROM GCS_ENTRY_LINES gel2
80: WHERE gel2.entry_id = p_full_entry_id;
81:
82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
83: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
84: g_api || '.' || fn_name,
85: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
86: END IF;

Line 83: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

79: FROM GCS_ENTRY_LINES gel2
80: WHERE gel2.entry_id = p_full_entry_id;
81:
82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
83: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
84: g_api || '.' || fn_name,
85: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
86: END IF;
87:

Line 88: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

84: g_api || '.' || fn_name,
85: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
86: END IF;
87:
88: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
90: g_api || '.' || fn_name,
91: GCS_UTILITY_PKG.g_module_success || fn_name ||
92: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 89: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

85: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
86: END IF;
87:
88: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
89: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
90: g_api || '.' || fn_name,
91: GCS_UTILITY_PKG.g_module_success || fn_name ||
92: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
93: END IF;

Line 99: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

Line 100: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

Line 142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

138: fn_name VARCHAR2(30) := 'MAINTAIN_ENTRIES';
139:
140: l_category_code VARCHAR2(30);
141: BEGIN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
144: g_api || '.' || fn_name,
145: GCS_UTILITY_PKG.g_module_enter || fn_name ||
146: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

139:
140: l_category_code VARCHAR2(30);
141: BEGIN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
144: g_api || '.' || fn_name,
145: GCS_UTILITY_PKG.g_module_enter || fn_name ||
146: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
147: END IF;

Line 262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

258: p_stat_round_factor);
259: END IF;
260: END IF;
261:
262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
264: g_api || '.' || fn_name,
265: GCS_UTILITY_PKG.g_module_success || fn_name ||
266: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

259: END IF;
260: END IF;
261:
262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
263: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
264: g_api || '.' || fn_name,
265: GCS_UTILITY_PKG.g_module_success || fn_name ||
266: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
267: END IF;

Line 273: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

269: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
270:
271: EXCEPTION
272: WHEN GCS_AGGR_ENTRY_FAILURE THEN
273: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
274: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
275: g_api || '.' || fn_name,
276: GCS_UTILITY_PKG.g_module_failure || fn_name ||
277: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 274: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

270:
271: EXCEPTION
272: WHEN GCS_AGGR_ENTRY_FAILURE THEN
273: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
274: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
275: g_api || '.' || fn_name,
276: GCS_UTILITY_PKG.g_module_failure || fn_name ||
277: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
278: END IF;

Line 283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

279: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_failure ||
280: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
281: RAISE GCS_AGGR_ENTRY_FAILURE;
282: WHEN OTHERS THEN
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
285: g_api || '.' || fn_name,
286: GCS_UTILITY_PKG.g_module_failure || fn_name ||
287: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 284: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

280: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
281: RAISE GCS_AGGR_ENTRY_FAILURE;
282: WHEN OTHERS THEN
283: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
285: g_api || '.' || fn_name,
286: GCS_UTILITY_PKG.g_module_failure || fn_name ||
287: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
288: END IF;

Line 326: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

322:
323: l_curr_round_factor NUMBER;
324: l_stat_round_factor NUMBER;
325: BEGIN
326: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
328: g_api || '.' || fn_name,
329: GCS_UTILITY_PKG.g_module_enter || fn_name ||
330: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

323: l_curr_round_factor NUMBER;
324: l_stat_round_factor NUMBER;
325: BEGIN
326: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
328: g_api || '.' || fn_name,
329: GCS_UTILITY_PKG.g_module_enter || fn_name ||
330: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
331:

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

329: GCS_UTILITY_PKG.g_module_enter || fn_name ||
330: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
331:
332: -- parameters passed in
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
334: g_api || '.' || fn_name,
335: 'p_run_detail_id = ' || to_char(p_run_detail_id));
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
337: g_api || '.' || fn_name,

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

332: -- parameters passed in
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
334: g_api || '.' || fn_name,
335: 'p_run_detail_id = ' || to_char(p_run_detail_id));
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
337: g_api || '.' || fn_name,
338: 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
340: g_api || '.' || fn_name,

Line 339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

335: 'p_run_detail_id = ' || to_char(p_run_detail_id));
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
337: g_api || '.' || fn_name,
338: 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
340: g_api || '.' || fn_name,
341: 'p_relationship_id = ' || to_char(p_relationship_id));
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
343: g_api || '.' || fn_name,

Line 342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

338: 'p_hierarchy_id = ' || to_char(p_hierarchy_id));
339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
340: g_api || '.' || fn_name,
341: 'p_relationship_id = ' || to_char(p_relationship_id));
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
343: g_api || '.' || fn_name,
344: 'p_cons_entity_id = ' || to_char(p_cons_entity_id));
345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
346: g_api || '.' || fn_name,

Line 345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

341: 'p_relationship_id = ' || to_char(p_relationship_id));
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
343: g_api || '.' || fn_name,
344: 'p_cons_entity_id = ' || to_char(p_cons_entity_id));
345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
346: g_api || '.' || fn_name,
347: 'p_cal_period_id = ' || to_char(p_cal_period_id));
348: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
349: g_api || '.' || fn_name,

Line 348: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

344: 'p_cons_entity_id = ' || to_char(p_cons_entity_id));
345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
346: g_api || '.' || fn_name,
347: 'p_cal_period_id = ' || to_char(p_cal_period_id));
348: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
349: g_api || '.' || fn_name,
350: 'p_period_end_date = ' || to_char(p_period_end_date,
351: 'DD-MON-YYYY'));
352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

348: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
349: g_api || '.' || fn_name,
350: 'p_period_end_date = ' || to_char(p_period_end_date,
351: 'DD-MON-YYYY'));
352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
353: g_api || '.' || fn_name,
354: 'p_balance_type_code = ' || p_balance_type_code);
355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
356: g_api || '.' || fn_name,

Line 355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

351: 'DD-MON-YYYY'));
352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
353: g_api || '.' || fn_name,
354: 'p_balance_type_code = ' || p_balance_type_code);
355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
356: g_api || '.' || fn_name,
357: 'p_stat_required = ' || p_stat_required);
358: END IF;
359: --FND_FILE.PUT_LINE(FND_FILE.LOG, GCS_UTILITY_PKG.g_module_enter ||

Line 367: g_fnd_login_id := fnd_global.login_id;

363: SAVEPOINT gcs_aggregation_start;
364:
365: -- ***** Setup *****
366: g_fnd_user_id := fnd_global.user_id;
367: g_fnd_login_id := fnd_global.login_id;
368:
369: -- get the consolidation entity's currency
370: SELECT currency_code
371: INTO l_cons_entity_curr

Line 438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

434: l_entry_id,
435: l_stat_entry_id);
436: END IF;
437:
438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
440: g_api || '.' || fn_name,
441: GCS_UTILITY_PKG.g_module_success || fn_name ||
442: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

435: l_stat_entry_id);
436: END IF;
437:
438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
440: g_api || '.' || fn_name,
441: GCS_UTILITY_PKG.g_module_success || fn_name ||
442: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
443: END IF;

Line 449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

445: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
446:
447: EXCEPTION
448: WHEN GCS_AGGR_ENTRY_FAILURE THEN
449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
450: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
451: g_api || '.' || fn_name,
452: GCS_UTILITY_PKG.g_module_failure || fn_name ||
453: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 450: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

446:
447: EXCEPTION
448: WHEN GCS_AGGR_ENTRY_FAILURE THEN
449: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
450: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
451: g_api || '.' || fn_name,
452: GCS_UTILITY_PKG.g_module_failure || fn_name ||
453: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
454: END IF;

Line 461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

457:
458: ROLLBACK TO gcs_aggregation_start;
459: -- p_errbuf and p_retcode are set by GCS_ENTRY_PKG.create_entry_header()
460: WHEN NO_DATA_FOUND THEN
461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
463: g_api || '.' || fn_name,
464: 'Consolidation Entity Curr = ' || l_cons_entity_curr);
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

Line 462: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

458: ROLLBACK TO gcs_aggregation_start;
459: -- p_errbuf and p_retcode are set by GCS_ENTRY_PKG.create_entry_header()
460: WHEN NO_DATA_FOUND THEN
461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
463: g_api || '.' || fn_name,
464: 'Consolidation Entity Curr = ' || l_cons_entity_curr);
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
466: g_api || '.' || fn_name,

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

461: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
463: g_api || '.' || fn_name,
464: 'Consolidation Entity Curr = ' || l_cons_entity_curr);
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
466: g_api || '.' || fn_name,
467: 'Dataset Code = ' || to_char(p_hier_dataset_code));
468: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
469: g_api || '.' || fn_name,

Line 468: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

464: 'Consolidation Entity Curr = ' || l_cons_entity_curr);
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
466: g_api || '.' || fn_name,
467: 'Dataset Code = ' || to_char(p_hier_dataset_code));
468: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
469: g_api || '.' || fn_name,
470: 'Consolidation Type = ' || l_consolidation_type);
471: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
472: g_api || '.' || fn_name,

Line 471: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

467: 'Dataset Code = ' || to_char(p_hier_dataset_code));
468: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
469: g_api || '.' || fn_name,
470: 'Consolidation Type = ' || l_consolidation_type);
471: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
472: g_api || '.' || fn_name,
473: 'Ownership Percent = ' || to_char(l_ownership_percent));
474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
475: g_api || '.' || fn_name,

Line 474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

470: 'Consolidation Type = ' || l_consolidation_type);
471: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
472: g_api || '.' || fn_name,
473: 'Ownership Percent = ' || to_char(l_ownership_percent));
474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
475: g_api || '.' || fn_name,
476: 'Currency MAU = ' || to_char(l_curr_round_factor));
477: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
478: g_api || '.' || fn_name,

Line 477: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

473: 'Ownership Percent = ' || to_char(l_ownership_percent));
474: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
475: g_api || '.' || fn_name,
476: 'Currency MAU = ' || to_char(l_curr_round_factor));
477: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
478: g_api || '.' || fn_name,
479: 'STAT MAU = ' || to_char(l_stat_round_factor));
480:
481: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

Line 481: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,

477: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
478: g_api || '.' || fn_name,
479: 'STAT MAU = ' || to_char(l_stat_round_factor));
480:
481: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
482: g_api || '.' || fn_name,
483: GCS_UTILITY_PKG.g_module_failure || fn_name ||
484: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
485: END IF;

Line 493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

489: ROLLBACK TO gcs_aggregation_start;
490: p_errbuf := 'GCS_AGGR_NO_DATA_FOUND';
491: p_retcode := '2';
492: WHEN OTHERS THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
495: g_api || '.' || fn_name,
496: SUBSTR(SQLERRM, 1, 4000));
497: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 494: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

490: p_errbuf := 'GCS_AGGR_NO_DATA_FOUND';
491: p_retcode := '2';
492: WHEN OTHERS THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
495: g_api || '.' || fn_name,
496: SUBSTR(SQLERRM, 1, 4000));
497: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
498: g_api || '.' || fn_name,

Line 497: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
495: g_api || '.' || fn_name,
496: SUBSTR(SQLERRM, 1, 4000));
497: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
498: g_api || '.' || fn_name,
499: GCS_UTILITY_PKG.g_module_failure || fn_name ||
500: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
501: END IF;