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

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

20: p_currency_code IN VARCHAR2)
21: IS PRAGMA AUTONOMOUS_TRANSACTION;
22: BEGIN
23:
24: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.begin', '<>' );
26: END IF;
27:
28: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.begin', '<>' );

21: IS PRAGMA AUTONOMOUS_TRANSACTION;
22: BEGIN
23:
24: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.begin', '<>' );
26: END IF;
27:
28: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

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

24: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.begin', '<>' );
26: END IF;
27:
28: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
30: 'Load Id : ' || p_load_id );
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
32: 'Source System : ' || p_source_system_code );

Line 29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

25: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.begin', '<>' );
26: END IF;
27:
28: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
30: 'Load Id : ' || p_load_id );
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
32: 'Source System : ' || p_source_system_code );
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

Line 31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

27:
28: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
30: 'Load Id : ' || p_load_id );
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
32: 'Source System : ' || p_source_system_code );
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
34: 'Dataset Code : ' || p_dataset_code );
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

Line 33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

29: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
30: 'Load Id : ' || p_load_id );
31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
32: 'Source System : ' || p_source_system_code );
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
34: 'Dataset Code : ' || p_dataset_code );
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
36: 'Cal Period Id : ' || p_cal_period_id );
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

Line 35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

31: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
32: 'Source System : ' || p_source_system_code );
33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
34: 'Dataset Code : ' || p_dataset_code );
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
36: 'Cal Period Id : ' || p_cal_period_id );
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
38: 'Ledger Id : ' || p_ledger_id );
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

Line 37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

33: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
34: 'Dataset Code : ' || p_dataset_code );
35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
36: 'Cal Period Id : ' || p_cal_period_id );
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
38: 'Ledger Id : ' || p_ledger_id );
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
40: 'Currency Type : ' || p_currency_type );
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

Line 39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

35: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
36: 'Cal Period Id : ' || p_cal_period_id );
37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
38: 'Ledger Id : ' || p_ledger_id );
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
40: 'Currency Type : ' || p_currency_type );
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
42: 'Currency Code : ' || p_currency_code );
43:

Line 41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',

37: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
38: 'Ledger Id : ' || p_ledger_id );
39: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
40: 'Currency Type : ' || p_currency_type );
41: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_YTD_BALANCES',
42: 'Currency Code : ' || p_currency_code );
43:
44: END IF;
45:

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

74: AND fcib.cctr_org_display_code = gbit.intercompany_display_code
75: )
76: WHERE load_id = p_load_id;
77:
78: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.end', '<>');
80: END IF;
81:
82: COMMIT;

Line 79: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.end', '<>');

75: )
76: WHERE load_id = p_load_id;
77:
78: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_YTD_BALANCES.end', '<>');
80: END IF;
81:
82: COMMIT;
83: END update_ytd_balances;

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

92: p_currency_code IN VARCHAR2)
93: IS PRAGMA AUTONOMOUS_TRANSACTION;
94: BEGIN
95:
96: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.begin',
98: '<>' );
99: END IF;
100:

Line 97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.begin',

93: IS PRAGMA AUTONOMOUS_TRANSACTION;
94: BEGIN
95:
96: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.begin',
98: '<>' );
99: END IF;
100:
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.begin',
98: '<>' );
99: END IF;
100:
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
103: 'Load Id : ' || p_load_id );
104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
105: 'Source System : ' || p_source_system_code );

Line 102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

98: '<>' );
99: END IF;
100:
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
103: 'Load Id : ' || p_load_id );
104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
105: 'Source System : ' || p_source_system_code );
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

Line 104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

100:
101: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
103: 'Load Id : ' || p_load_id );
104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
105: 'Source System : ' || p_source_system_code );
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
107: 'Dataset Code : ' || p_dataset_code );
108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

Line 106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
103: 'Load Id : ' || p_load_id );
104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
105: 'Source System : ' || p_source_system_code );
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
107: 'Dataset Code : ' || p_dataset_code );
108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
109: 'Cal Period Id : ' || p_cal_period_id );
110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

Line 108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
105: 'Source System : ' || p_source_system_code );
106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
107: 'Dataset Code : ' || p_dataset_code );
108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
109: 'Cal Period Id : ' || p_cal_period_id );
110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
111: 'Ledger Id : ' || p_ledger_id );
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

Line 110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
107: 'Dataset Code : ' || p_dataset_code );
108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
109: 'Cal Period Id : ' || p_cal_period_id );
110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
111: 'Ledger Id : ' || p_ledger_id );
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
113: 'Currency Type : ' || p_currency_type );
114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

Line 112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
109: 'Cal Period Id : ' || p_cal_period_id );
110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
111: 'Ledger Id : ' || p_ledger_id );
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
113: 'Currency Type : ' || p_currency_type );
114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
115: 'Currency Code : ' || p_currency_code );
116:

Line 114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',

110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
111: 'Ledger Id : ' || p_ledger_id );
112: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
113: 'Currency Type : ' || p_currency_type );
114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCES',
115: 'Currency Code : ' || p_currency_code );
116:
117: END IF;
118:

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

145: AND fcib.cctr_org_display_code = gbit.intercompany_display_code
146: )
147: WHERE gbit.load_id = p_load_id;
148:
149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.end', '<>');
151: END IF;
152:
153: COMMIT;

Line 150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.end', '<>');

146: )
147: WHERE gbit.load_id = p_load_id;
148:
149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCES.end', '<>');
151: END IF;
152:
153: COMMIT;
154: END update_ptd_balances;

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

176: gcs_utility_pkg.g_dimension_attr_info('EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE').version_id;
177:
178: BEGIN
179:
180: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCE_SHEET.begin',
182: '<>' );
183: END IF;
184:

Line 181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCE_SHEET.begin',

177:
178: BEGIN
179:
180: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCE_SHEET.begin',
182: '<>' );
183: END IF;
184:
185: SELECT fgvcd.value_set_id

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

191: AND fla.attribute_id = l_ledger_vs_combo_attr
192: AND fla.version_id = l_ledger_vs_combo_version
193: AND fgvcd.dimension_id = 14;
194:
195: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
197: 'Load Id : ' || p_load_id );
198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
199: 'Source System : ' || p_source_system_code );

Line 196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

192: AND fla.version_id = l_ledger_vs_combo_version
193: AND fgvcd.dimension_id = 14;
194:
195: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
197: 'Load Id : ' || p_load_id );
198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
199: 'Source System : ' || p_source_system_code );
200: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

Line 198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

194:
195: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
197: 'Load Id : ' || p_load_id );
198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
199: 'Source System : ' || p_source_system_code );
200: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
201: 'Dataset Code : ' || p_dataset_code );
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

Line 200: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

196: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
197: 'Load Id : ' || p_load_id );
198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
199: 'Source System : ' || p_source_system_code );
200: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
201: 'Dataset Code : ' || p_dataset_code );
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
203: 'Cal Period Id : ' || p_cal_period_id );
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

Line 202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

198: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
199: 'Source System : ' || p_source_system_code );
200: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
201: 'Dataset Code : ' || p_dataset_code );
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
203: 'Cal Period Id : ' || p_cal_period_id );
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
205: 'Ledger Id : ' || p_ledger_id );
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

Line 204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

200: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
201: 'Dataset Code : ' || p_dataset_code );
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
203: 'Cal Period Id : ' || p_cal_period_id );
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
205: 'Ledger Id : ' || p_ledger_id );
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
207: 'Currency Type : ' || p_currency_type );
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

Line 206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
203: 'Cal Period Id : ' || p_cal_period_id );
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
205: 'Ledger Id : ' || p_ledger_id );
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
207: 'Currency Type : ' || p_currency_type );
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
209: 'Currency Code : ' || p_currency_code );
210:

Line 208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',

204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
205: 'Ledger Id : ' || p_ledger_id );
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
207: 'Currency Type : ' || p_currency_type );
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PTD_BALANCE_SHEET',
209: 'Currency Code : ' || p_currency_code );
210:
211: END IF;
212:

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

257: 'LIABILITY'
258: )
259: );
260:
261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCE_SHEET.end', '<>');
263: END IF;
264:
265: COMMIT;

Line 262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCE_SHEET.end', '<>');

258: )
259: );
260:
261: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PTD_BALANCE_SHEET.end', '<>');
263: END IF;
264:
265: COMMIT;
266: END update_ptd_balance_sheet;

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

280: l_invalid_err_msg VARCHAR2(2000);
281: l_null_err_msg VARCHAR2(2000);
282: BEGIN
283:
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.begin',
286: '<>' );
287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.VALIDATE_DIMENSION_MEMBERS',
288: 'Load Id : ' || p_load_id );

Line 285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.begin',

281: l_null_err_msg VARCHAR2(2000);
282: BEGIN
283:
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.begin',
286: '<>' );
287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.VALIDATE_DIMENSION_MEMBERS',
288: 'Load Id : ' || p_load_id );
289: END IF;

Line 287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.VALIDATE_DIMENSION_MEMBERS',

283:
284: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.begin',
286: '<>' );
287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.VALIDATE_DIMENSION_MEMBERS',
288: 'Load Id : ' || p_load_id );
289: END IF;
290:
291:

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

534: END IF;
535:
536: COMMIT;
537:
538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.end', '<>');
540: END IF;
541:
542: END validate_dimension_members;

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.end', '<>');

535:
536: COMMIT;
537:
538: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.VALIDATE_DIMENSION_MEMBERS.end', '<>');
540: END IF;
541:
542: END validate_dimension_members;
543: --