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

Line 32: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN

28: text_with_date_len NUMBER;
29: curr_index NUMBER;
30: BEGIN
31: -- Only print if the log level is set at the appropriate level
32: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= p_level THEN
33: api_module_concat := g_api || '.' || p_module;
34: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
35: text_with_date_len := length(text_with_date);
36: curr_index := 1;

Line 38: fnd_log.string(p_level, api_module_concat,

34: text_with_date := to_char(sysdate,'DD-MON-YYYY HH:MI:SS')||g_nl||p_text;
35: text_with_date_len := length(text_with_date);
36: curr_index := 1;
37: WHILE curr_index <= text_with_date_len LOOP
38: fnd_log.string(p_level, api_module_concat,
39: substr(text_with_date, curr_index, 3500));
40: curr_index := curr_index + 3500;
41: END LOOP;
42: END IF;

Line 243: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;

239: ad_ddl.build_statement(' p_currency_code IN VARCHAR2) ' , r); r:=r+1;
240: ad_ddl.build_statement(' IS PRAGMA AUTONOMOUS_TRANSACTION; ', r); r:=r+1;
241: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
242: ad_ddl.build_statement(' ', r); r:=r+1;
243: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
244: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.begin'', ''<>'' ); ', r); r:=r+1;
245: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
246: ad_ddl.build_statement(' ', r); r:=r+1;
247: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;

Line 244: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.begin'', ''<>'' ); ', r); r:=r+1;

240: ad_ddl.build_statement(' IS PRAGMA AUTONOMOUS_TRANSACTION; ', r); r:=r+1;
241: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
242: ad_ddl.build_statement(' ', r); r:=r+1;
243: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
244: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.begin'', ''<>'' ); ', r); r:=r+1;
245: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
246: ad_ddl.build_statement(' ', r); r:=r+1;
247: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
248: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

Line 247: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;

243: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
244: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.begin'', ''<>'' ); ', r); r:=r+1;
245: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
246: ad_ddl.build_statement(' ', r); r:=r+1;
247: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
248: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
249: ''Load Id : '' || p_load_id );', r); r:=r+1;
250: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
251: ''Source System : '' || p_source_system_code );', r); r:=r+1;

Line 248: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

244: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.begin'', ''<>'' ); ', r); r:=r+1;
245: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
246: ad_ddl.build_statement(' ', r); r:=r+1;
247: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
248: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
249: ''Load Id : '' || p_load_id );', r); r:=r+1;
250: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
251: ''Source System : '' || p_source_system_code );', r); r:=r+1;
252: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

Line 250: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

246: ad_ddl.build_statement(' ', r); r:=r+1;
247: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
248: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
249: ''Load Id : '' || p_load_id );', r); r:=r+1;
250: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
251: ''Source System : '' || p_source_system_code );', r); r:=r+1;
252: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
253: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
254: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

Line 252: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

248: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
249: ''Load Id : '' || p_load_id );', r); r:=r+1;
250: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
251: ''Source System : '' || p_source_system_code );', r); r:=r+1;
252: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
253: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
254: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
255: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
256: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

Line 254: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

250: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
251: ''Source System : '' || p_source_system_code );', r); r:=r+1;
252: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
253: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
254: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
255: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
256: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
257: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
258: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

Line 256: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

252: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
253: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
254: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
255: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
256: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
257: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
258: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
259: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
260: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

Line 258: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

254: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
255: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
256: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
257: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
258: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
259: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
260: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
261: ''Currency Code : '' || p_currency_code );', r); r:=r+1;
262: ad_ddl.build_statement(' ', r); r:=r+1;

Line 260: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',

256: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
257: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
258: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
259: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
260: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_YTD_BALANCES'',
261: ''Currency Code : '' || p_currency_code );', r); r:=r+1;
262: ad_ddl.build_statement(' ', r); r:=r+1;
263: ad_ddl.build_statement(' END IF;', r); r:=r+1;
264: ad_ddl.build_statement(' ', r); r:=r+1;

Line 302: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;

298: build_where_clause_list(r);
299: ad_ddl.build_statement(' )', r); r:=r+1;
300: ad_ddl.build_statement(' WHERE load_id = p_load_id;', r); r:=r+1;
301: ad_ddl.build_statement(' ', r); r:=r+1;
302: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
303: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.end'', ''<>''); ', r); r:=r+1;
304: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
305: ad_ddl.build_statement(' ', r); r:=r+1;
306: ad_ddl.build_statement(' COMMIT;', r); r:=r+1;

Line 303: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.end'', ''<>''); ', r); r:=r+1;

299: ad_ddl.build_statement(' )', r); r:=r+1;
300: ad_ddl.build_statement(' WHERE load_id = p_load_id;', r); r:=r+1;
301: ad_ddl.build_statement(' ', r); r:=r+1;
302: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
303: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_YTD_BALANCES.end'', ''<>''); ', r); r:=r+1;
304: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
305: ad_ddl.build_statement(' ', r); r:=r+1;
306: ad_ddl.build_statement(' COMMIT;', r); r:=r+1;
307: ad_ddl.build_statement(' END update_ytd_balances;', r); r:=r+1;

Line 320: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;

316: ad_ddl.build_statement(' p_currency_code IN VARCHAR2) ' , r); r:=r+1;
317: ad_ddl.build_statement(' IS PRAGMA AUTONOMOUS_TRANSACTION; ', r); r:=r+1;
318: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
319: ad_ddl.build_statement(' ', r); r:=r+1;
320: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
321: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.begin'',
322: ''<>'' ); ', r); r:=r+1;
323: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
324: ad_ddl.build_statement(' ', r); r:=r+1;

Line 321: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.begin'',

317: ad_ddl.build_statement(' IS PRAGMA AUTONOMOUS_TRANSACTION; ', r); r:=r+1;
318: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
319: ad_ddl.build_statement(' ', r); r:=r+1;
320: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
321: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.begin'',
322: ''<>'' ); ', r); r:=r+1;
323: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
324: ad_ddl.build_statement(' ', r); r:=r+1;
325: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;

Line 325: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;

321: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.begin'',
322: ''<>'' ); ', r); r:=r+1;
323: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
324: ad_ddl.build_statement(' ', r); r:=r+1;
325: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
326: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
327: ''Load Id : '' || p_load_id );', r); r:=r+1;
328: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
329: ''Source System : '' || p_source_system_code );', r); r:=r+1;

Line 326: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

322: ''<>'' ); ', r); r:=r+1;
323: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
324: ad_ddl.build_statement(' ', r); r:=r+1;
325: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
326: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
327: ''Load Id : '' || p_load_id );', r); r:=r+1;
328: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
329: ''Source System : '' || p_source_system_code );', r); r:=r+1;
330: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

Line 328: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

324: ad_ddl.build_statement(' ', r); r:=r+1;
325: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
326: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
327: ''Load Id : '' || p_load_id );', r); r:=r+1;
328: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
329: ''Source System : '' || p_source_system_code );', r); r:=r+1;
330: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
331: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
332: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

Line 330: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

326: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
327: ''Load Id : '' || p_load_id );', r); r:=r+1;
328: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
329: ''Source System : '' || p_source_system_code );', r); r:=r+1;
330: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
331: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
332: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
333: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
334: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

Line 332: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

328: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
329: ''Source System : '' || p_source_system_code );', r); r:=r+1;
330: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
331: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
332: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
333: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
334: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
335: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
336: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

Line 334: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

330: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
331: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
332: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
333: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
334: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
335: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
336: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
337: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
338: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

Line 336: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

332: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
333: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
334: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
335: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
336: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
337: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
338: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
339: ''Currency Code : '' || p_currency_code );', r); r:=r+1;
340: ad_ddl.build_statement(' ', r); r:=r+1;

Line 338: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',

334: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
335: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
336: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
337: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
338: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCES'',
339: ''Currency Code : '' || p_currency_code );', r); r:=r+1;
340: ad_ddl.build_statement(' ', r); r:=r+1;
341: ad_ddl.build_statement(' END IF;', r); r:=r+1;
342: ad_ddl.build_statement(' ', r); r:=r+1;

Line 378: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;

374: build_where_clause_list(r);
375: ad_ddl.build_statement(' )', r); r:=r+1;
376: ad_ddl.build_statement(' WHERE gbit.load_id = p_load_id;', r); r:=r+1;
377: ad_ddl.build_statement(' ', r); r:=r+1;
378: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;
379: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.end'', ''<>''); ', r); r:=r+1;
380: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
381: ad_ddl.build_statement(' ', r); r:=r+1;
382: ad_ddl.build_statement(' COMMIT; ' , r); r:=r+1;

Line 379: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.end'', ''<>''); ', r); r:=r+1;

375: ad_ddl.build_statement(' )', r); r:=r+1;
376: ad_ddl.build_statement(' WHERE gbit.load_id = p_load_id;', r); r:=r+1;
377: ad_ddl.build_statement(' ', r); r:=r+1;
378: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;
379: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCES.end'', ''<>''); ', r); r:=r+1;
380: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
381: ad_ddl.build_statement(' ', r); r:=r+1;
382: ad_ddl.build_statement(' COMMIT; ' , r); r:=r+1;
383: ad_ddl.build_statement(' END update_ptd_balances;', r); r:=r+1;

Line 409: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;

405: ad_ddl.build_statement(' gcs_utility_pkg.g_dimension_attr_info(''EXT_ACCOUNT_TYPE_CODE-BASIC_ACCOUNT_TYPE_CODE'').version_id;', r); r:=r+1;
406: ad_ddl.build_statement(' ', r); r:=r+1;
407: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
408: ad_ddl.build_statement(' ', r); r:=r+1;
409: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
410: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.begin'',
411: ''<>'' ); ', r); r:=r+1;
412: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
413: ad_ddl.build_statement(' ', r); r:=r+1;

Line 410: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.begin'',

406: ad_ddl.build_statement(' ', r); r:=r+1;
407: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
408: ad_ddl.build_statement(' ', r); r:=r+1;
409: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
410: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.begin'',
411: ''<>'' ); ', r); r:=r+1;
412: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
413: ad_ddl.build_statement(' ', r); r:=r+1;
414: ad_ddl.build_statement(' SELECT fgvcd.value_set_id ', r); r:=r+1;

Line 424: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;

420: ad_ddl.build_statement(' AND fla.attribute_id = l_ledger_vs_combo_attr ', r); r:=r+1;
421: ad_ddl.build_statement(' AND fla.version_id = l_ledger_vs_combo_version ', r); r:=r+1;
422: ad_ddl.build_statement(' AND fgvcd.dimension_id = 14; ', r); r:=r+1;
423: ad_ddl.build_statement(' ', r); r:=r+1;
424: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
425: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
426: ''Load Id : '' || p_load_id );', r); r:=r+1;
427: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
428: ''Source System : '' || p_source_system_code );', r); r:=r+1;

Line 425: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

421: ad_ddl.build_statement(' AND fla.version_id = l_ledger_vs_combo_version ', r); r:=r+1;
422: ad_ddl.build_statement(' AND fgvcd.dimension_id = 14; ', r); r:=r+1;
423: ad_ddl.build_statement(' ', r); r:=r+1;
424: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
425: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
426: ''Load Id : '' || p_load_id );', r); r:=r+1;
427: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
428: ''Source System : '' || p_source_system_code );', r); r:=r+1;
429: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

Line 427: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

423: ad_ddl.build_statement(' ', r); r:=r+1;
424: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN ', r); r:=r+1;
425: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
426: ''Load Id : '' || p_load_id );', r); r:=r+1;
427: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
428: ''Source System : '' || p_source_system_code );', r); r:=r+1;
429: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
430: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
431: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

Line 429: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

425: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
426: ''Load Id : '' || p_load_id );', r); r:=r+1;
427: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
428: ''Source System : '' || p_source_system_code );', r); r:=r+1;
429: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
430: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
431: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
432: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
433: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

Line 431: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

427: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
428: ''Source System : '' || p_source_system_code );', r); r:=r+1;
429: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
430: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
431: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
432: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
433: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
434: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
435: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

Line 433: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

429: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
430: ''Dataset Code : '' || p_dataset_code );', r); r:=r+1;
431: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
432: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
433: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
434: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
435: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
436: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
437: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

Line 435: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

431: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
432: ''Cal Period Id : '' || p_cal_period_id );', r); r:=r+1;
433: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
434: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
435: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
436: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
437: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
438: ''Currency Code : '' || p_currency_code );', r); r:=r+1;
439: ad_ddl.build_statement(' ', r); r:=r+1;

Line 437: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',

433: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
434: ''Ledger Id : '' || p_ledger_id );', r); r:=r+1;
435: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
436: ''Currency Type : '' || p_currency_type );', r); r:=r+1;
437: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.UPDATE_PTD_BALANCE_SHEET'',
438: ''Currency Code : '' || p_currency_code );', r); r:=r+1;
439: ad_ddl.build_statement(' ', r); r:=r+1;
440: ad_ddl.build_statement(' END IF;', r); r:=r+1;
441: ad_ddl.build_statement(' ', r); r:=r+1;

Line 494: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;

490: ad_ddl.build_statement(' ''LIABILITY''', r); r:=r+1;
491: ad_ddl.build_statement(' ) ', r); r:=r+1;
492: ad_ddl.build_statement(' ); ', r); r:=r+1;
493: ad_ddl.build_statement(' ', r); r:=r+1;
494: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;
495: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.end'', ''<>''); ', r); r:=r+1;
496: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
497: ad_ddl.build_statement(' ', r); r:=r+1;
498: ad_ddl.build_statement(' COMMIT; ' , r); r:=r+1;

Line 495: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.end'', ''<>''); ', r); r:=r+1;

491: ad_ddl.build_statement(' ) ', r); r:=r+1;
492: ad_ddl.build_statement(' ); ', r); r:=r+1;
493: ad_ddl.build_statement(' ', r); r:=r+1;
494: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;
495: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.UPDATE_PTD_BALANCE_SHEET.end'', ''<>''); ', r); r:=r+1;
496: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
497: ad_ddl.build_statement(' ', r); r:=r+1;
498: ad_ddl.build_statement(' COMMIT; ' , r); r:=r+1;
499: ad_ddl.build_statement(' END update_ptd_balance_sheet;', r); r:=r+1;

Line 520: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;

516: ad_ddl.build_statement(' l_null_err_msg VARCHAR2(2000); ', r); r:=r+1;
517: -- Bugfix 5358633, End
518: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
519: ad_ddl.build_statement(' ', r); r:=r+1;
520: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
521: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.begin'',
522: ''<>'' ); ', r); r:=r+1;
523: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.VALIDATE_DIMENSION_MEMBERS'',
524: ''Load Id : '' || p_load_id );', r); r:=r+1;

Line 521: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.begin'',

517: -- Bugfix 5358633, End
518: ad_ddl.build_statement(' BEGIN ', r); r:=r+1;
519: ad_ddl.build_statement(' ', r); r:=r+1;
520: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
521: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.begin'',
522: ''<>'' ); ', r); r:=r+1;
523: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.VALIDATE_DIMENSION_MEMBERS'',
524: ''Load Id : '' || p_load_id );', r); r:=r+1;
525: ad_ddl.build_statement(' END IF;', r); r:=r+1;

Line 523: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.VALIDATE_DIMENSION_MEMBERS'',

519: ad_ddl.build_statement(' ', r); r:=r+1;
520: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN ', r); r:=r+1;
521: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.begin'',
522: ''<>'' ); ', r); r:=r+1;
523: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || ''.VALIDATE_DIMENSION_MEMBERS'',
524: ''Load Id : '' || p_load_id );', r); r:=r+1;
525: ad_ddl.build_statement(' END IF;', r); r:=r+1;
526: ad_ddl.build_statement(' ', r); r:=r+1;
527: ad_ddl.build_statement(' ', r); r:=r+1;

Line 779: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;

775: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
776: ad_ddl.build_statement(' ', r); r:=r+1;
777: ad_ddl.build_statement(' COMMIT; ' , r); r:=r+1;
778: ad_ddl.build_statement(' ', r); r:=r+1;
779: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;
780: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.end'', ''<>''); ', r); r:=r+1;
781: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
782: ad_ddl.build_statement(' ', r); r:=r+1;
783: ad_ddl.build_statement(' END validate_dimension_members; ', r); r:=r+1;

Line 780: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.end'', ''<>''); ', r); r:=r+1;

776: ad_ddl.build_statement(' ', r); r:=r+1;
777: ad_ddl.build_statement(' COMMIT; ' , r); r:=r+1;
778: ad_ddl.build_statement(' ', r); r:=r+1;
779: ad_ddl.build_statement(' IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN', r); r:=r+1;
780: ad_ddl.build_statement(' FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || ''.VALIDATE_DIMENSION_MEMBERS.end'', ''<>''); ', r); r:=r+1;
781: ad_ddl.build_statement(' END IF; ', r); r:=r+1;
782: ad_ddl.build_statement(' ', r); r:=r+1;
783: ad_ddl.build_statement(' END validate_dimension_members; ', r); r:=r+1;
784: -- Bug Fix : 5234796, End