APPS.JAI_PA_SETUP_DEF_PKG dependencies on FND_FILE

Line 15: fnd_file.put_line(fnd_file.log, 'Updating org_id for existing setup');

11: from jai_pa_setup_values
12: where org_id is not null;
13: l_count number;
14: begin
15: fnd_file.put_line(fnd_file.log, 'Updating org_id for existing setup');
16: open c_get_pa_count;
17: fetch c_get_pa_count into l_count;
18: close c_get_pa_count;
19: if l_count > 0 then

Line 20: fnd_file.put_line(fnd_file.log, 'Records exist in jai_pa_setup_values with org_id');

16: open c_get_pa_count;
17: fetch c_get_pa_count into l_count;
18: close c_get_pa_count;
19: if l_count > 0 then
20: fnd_file.put_line(fnd_file.log, 'Records exist in jai_pa_setup_values with org_id');
21: fnd_file.put_line(fnd_file.log, 'Cannot update. Exiting...');
22: return;
23: else
24: update jai_pa_setup_values

Line 21: fnd_file.put_line(fnd_file.log, 'Cannot update. Exiting...');

17: fetch c_get_pa_count into l_count;
18: close c_get_pa_count;
19: if l_count > 0 then
20: fnd_file.put_line(fnd_file.log, 'Records exist in jai_pa_setup_values with org_id');
21: fnd_file.put_line(fnd_file.log, 'Cannot update. Exiting...');
22: return;
23: else
24: update jai_pa_setup_values
25: set org_id = p_org_id

Line 27: fnd_file.put_line(fnd_file.log, 'Updated existing records with org_id...');

23: else
24: update jai_pa_setup_values
25: set org_id = p_org_id
26: where org_id is null;
27: fnd_file.put_line(fnd_file.log, 'Updated existing records with org_id...');
28: end if;
29: retcode := 1 ;
30: errbuf := 'Normal Completion';
31: exception