DBA Data[Home] [Help]

APPS.CS_CREATE_AUDIT_REC_PKG dependencies on FND_FILE

Line 340: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||x_worker_id);

336: RAISE_APPLICATION_ERROR(-20001,
337: 'Cannot get schema name for product : '||l_product);
338: END IF;
339:
340: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||x_worker_id);
341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||x_num_workers);
342:
343: --
344: -- Worker processing

Line 341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||x_num_workers);

337: 'Cannot get schema name for product : '||l_product);
338: END IF;
339:
340: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||x_worker_id);
341: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||x_num_workers);
342:
343: --
344: -- Worker processing
345: --

Line 368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing: l_start_row_id='||l_start_rowid

364: x_batch_size,
365: TRUE);
366:
367: WHILE (l_any_rows_to_process) LOOP --{Loop1
368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing: l_start_row_id='||l_start_rowid
369: || '; l_end_rowid=' || l_end_rowid);
370: OPEN c_sr_current(l_start_rowid, l_end_rowid);
371: l_loop_counter := 0;
372: LOOP --{Loop2

Line 377: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Service Request Id : '||l_request_id);

373: FETCH c_sr_current INTO l_create_audit_rec;
374: EXIT WHEN c_sr_current%NOTFOUND;
375:
376: l_request_id := l_create_audit_rec.incident_id;
377: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Service Request Id : '||l_request_id);
378: SELECT COUNT(incident_audit_id) INTO l_audit_count
379: FROM cs_incidents_audit_b
380: WHERE incident_id= l_request_id;
381: