DBA Data[Home] [Help]

APPS.OKS_IMPORT_REPORT dependencies on FND_GLOBAL

Line 26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;

22: --========================================================================
23: -- PRIVATE CONSTANTS AND VARIABLES
24: --========================================================================
25: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'oks.plsql.import.' || G_PKG_NAME;
26: G_WORKER_REQ_ID CONSTANT NUMBER := FND_GLOBAL.conc_request_id;
27: G_MODULE_HEAD CONSTANT VARCHAR2(200) := G_MODULE_NAME || '(Req Id = '||G_WORKER_REQ_ID||').';
28: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
29: G_UNEXPECTED_LOG CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
30: fnd_log.TEST(fnd_log.level_unexpected, G_MODULE_HEAD);

Line 128: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));

124: lpad(l_statistics_tab(i).Notes_Stat, 10));
125: END LOOP;
126:
127: FND_FILE.put_line(FND_FILE.OUTPUT, '___________________________________________________________________________________________________________________________');
128: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
129: IF G_PROCEDURE_LOG THEN
130: fnd_log.string(fnd_log.level_procedure,
131: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
132: 'Exit.');

Line 292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));

288: l_stmt_num := 20;
289:
290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;
291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);

Line 294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));

290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;
291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
295: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Process Request Id: ', 35) || P_parent_request_id);
296: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request Start Date: ', 35) || l_start_date);
297: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Request End Date: ', 35) || l_end_date);
298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);

Line 302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));

298: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Batch Number: ', 35) || P_batch_id);
299: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Mode: ', 35) || l_mode);
300: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Number of Workers: ', 35) || P_Num_Workers);
301: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Commit Size : ', 35) || P_commit_size);
302: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));
303:
304:
305: l_stmt_num := 30;
306: Print_Statistics(P_batch_id,