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

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

58: AND parent_entity_id = p_cons_entity_id
59: AND actual_ownership_flag = 'Y';
60:
61: BEGIN
62: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
63: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
64: g_api || '.' || fn_name,
65: GCS_UTILITY_PKG.g_module_enter || fn_name ||
66: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 63: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

59: AND actual_ownership_flag = 'Y';
60:
61: BEGIN
62: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
63: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
64: g_api || '.' || fn_name,
65: GCS_UTILITY_PKG.g_module_enter || fn_name ||
66: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
67: END IF;

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

73: INTO l_bal_by_org_flag
74: FROM gcs_hierarchies_b
75: WHERE hierarchy_id = p_hierarchy_id;
76:
77: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
78: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
79: g_api || '.' || fn_name,
80: 'l_bal_by_org_flag = ' || l_bal_by_org_flag || ' ' ||
81: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 78: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

74: FROM gcs_hierarchies_b
75: WHERE hierarchy_id = p_hierarchy_id;
76:
77: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
78: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
79: g_api || '.' || fn_name,
80: 'l_bal_by_org_flag = ' || l_bal_by_org_flag || ' ' ||
81: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
82: END IF;

Line 105: GCS_AGGREGATION_PKG.g_fnd_login_id

101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
108: FEM_BALANCES fb,
109: GCS_CONS_RELATIONSHIPS gcr,

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

141: INTO l_intercompany_id
142: FROM GCS_CATEGORIES_B
143: WHERE category_code = 'AGGREGATION';
144:
145: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
147: g_api || '.' || fn_name,
148: 'l_intercompany_id = ' || l_intercompany_id || ' ' ||
149: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

142: FROM GCS_CATEGORIES_B
143: WHERE category_code = 'AGGREGATION';
144:
145: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
147: g_api || '.' || fn_name,
148: 'l_intercompany_id = ' || l_intercompany_id || ' ' ||
149: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
150: END IF;

Line 299: gcs_aggregation_pkg.g_fnd_login_id

295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
296: SUM (ytd_debit_balance_e), SUM (ytd_credit_balance_e),
297: SYSDATE, gcs_aggregation_pkg.g_fnd_user_id, SYSDATE,
298: gcs_aggregation_pkg.g_fnd_user_id,
299: gcs_aggregation_pkg.g_fnd_login_id
300: FROM gcs_entry_lines_gt
301: GROUP BY entry_id,
302: company_cost_center_org_id,
303: line_item_id,

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

303: line_item_id,
304: intercompany_id;
305: END IF; -- l_bal_by_org_flag
306:
307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
309: g_api || '.' || fn_name,
310: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
311: END IF;

Line 308: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

304: intercompany_id;
305: END IF; -- l_bal_by_org_flag
306:
307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
309: g_api || '.' || fn_name,
310: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
311: END IF;
312:

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

309: g_api || '.' || fn_name,
310: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
311: END IF;
312:
313: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
314: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
315: g_api || '.' || fn_name,
316: GCS_UTILITY_PKG.g_module_success || fn_name ||
317: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 314: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

310: 'Inserted ' || to_char(SQL%ROWCOUNT) || ' row(s)');
311: END IF;
312:
313: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
314: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
315: g_api || '.' || fn_name,
316: GCS_UTILITY_PKG.g_module_success || fn_name ||
317: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
318: END IF;

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

320: -- fn_name || to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
325: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
326: g_api || '.' || fn_name,
327: GCS_UTILITY_PKG.g_module_failure || fn_name ||
328: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));

Line 325: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
325: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
326: g_api || '.' || fn_name,
327: GCS_UTILITY_PKG.g_module_failure || fn_name ||
328: to_char(sysdate, ' DD-MON-YYYY HH:MI:SS'));
329: END IF;