APPS.CS_AUDIT_UPGRADE_CON_PRG dependencies on FND_FILE

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

576: RAISE_APPLICATION_ERROR(-20001,
577: 'Cannot get schema name for product : '||l_product);
578: END IF;
579:
580: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||x_worker_id);
581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||x_num_workers);
582:
583: BEGIN -- {begin1
584:

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

577: 'Cannot get schema name for product : '||l_product);
578: END IF;
579:
580: FND_FILE.PUT_LINE(FND_FILE.LOG, ' X_Worker_Id : '||x_worker_id);
581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : '||x_num_workers);
582:
583: BEGIN -- {begin1
584:
585: l_audit_date := to_date(p_audit_date,'YYYY/MM/DD HH24:MI:SS');

Line 586: FND_FILE.Put_Line(fnd_file.log, 'p_audit_date=' || p_audit_date);

582:
583: BEGIN -- {begin1
584:
585: l_audit_date := to_date(p_audit_date,'YYYY/MM/DD HH24:MI:SS');
586: FND_FILE.Put_Line(fnd_file.log, 'p_audit_date=' || p_audit_date);
587: ad_parallel_updates_pkg.initialize_rowid_range(
588: ad_parallel_updates_pkg.ROWID_RANGE,
589: l_table_owner,
590: l_table_name,

Line 604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_start_rowid=' || l_start_rowid || ';l_end_rowid=' || l_end_rowid);

600: x_batch_size,
601: TRUE);
602:
603: WHILE (l_any_rows_to_process) LOOP --{Loop1
604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_start_rowid=' || l_start_rowid || ';l_end_rowid=' || l_end_rowid);
605: open c_sr_current(l_start_rowid,l_end_rowid,l_audit_date);
606: l_loop_counter := 0;
607: fnd_file.put_line(fnd_file.log,'Service Requests processed:');
608: LOOP -- {Loop2

Line 607: fnd_file.put_line(fnd_file.log,'Service Requests processed:');

603: WHILE (l_any_rows_to_process) LOOP --{Loop1
604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_start_rowid=' || l_start_rowid || ';l_end_rowid=' || l_end_rowid);
605: open c_sr_current(l_start_rowid,l_end_rowid,l_audit_date);
606: l_loop_counter := 0;
607: fnd_file.put_line(fnd_file.log,'Service Requests processed:');
608: LOOP -- {Loop2
609: fetch c_sr_current into l_create_audit_rec;
610: EXIT WHEN c_sr_current%NOTFOUND;
611: l_sta_update :=0;

Line 691: fnd_file.put_line(fnd_file.log,'SR Number:' ||l_create_audit_rec.incident_number

687: where incident_id= l_request_id
688: and NVL(upgrade_flag_for_create,'N') = 'N'
689: and NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER';
690:
691: fnd_file.put_line(fnd_file.log,'SR Number:' ||l_create_audit_rec.incident_number
692: || '; SR ID: ' || l_request_id);
693: fnd_file.put_line(fnd_file.log,'l_audit_count:' ||l_audit_count);
694:
695: if l_audit_count >0 then

Line 693: fnd_file.put_line(fnd_file.log,'l_audit_count:' ||l_audit_count);

689: and NVL(updated_entity_code, 'SR_HEADER') = 'SR_HEADER';
690:
691: fnd_file.put_line(fnd_file.log,'SR Number:' ||l_create_audit_rec.incident_number
692: || '; SR ID: ' || l_request_id);
693: fnd_file.put_line(fnd_file.log,'l_audit_count:' ||l_audit_count);
694:
695: if l_audit_count >0 then
696: open c_sr_audit(l_request_id);
697: LOOP