DBA Data[Home] [Help]

APPS.ARP_TAX_RATE_UPD dependencies on FND_FILE

Line 37: fnd_file.put_line( fnd_file.log,'l_batch_size = ' || to_char(l_batch_size));

33: l_batch_size := p_batch_size;
34: l_worker_id := p_worker_id;
35: l_num_workers := p_num_workers;
36: -- Value populated if the conc. parameters are null.
37: fnd_file.put_line( fnd_file.log,'l_batch_size = ' || to_char(l_batch_size));
38: fnd_file.put_line( fnd_file.log,'l_worker_id = ' || to_char(l_worker_id));
39: fnd_file.put_line( fnd_file.log,'l_num_workers = ' || to_char(l_num_workers));
40: if l_batch_size is NULL then
41: l_batch_size := 999;

Line 38: fnd_file.put_line( fnd_file.log,'l_worker_id = ' || to_char(l_worker_id));

34: l_worker_id := p_worker_id;
35: l_num_workers := p_num_workers;
36: -- Value populated if the conc. parameters are null.
37: fnd_file.put_line( fnd_file.log,'l_batch_size = ' || to_char(l_batch_size));
38: fnd_file.put_line( fnd_file.log,'l_worker_id = ' || to_char(l_worker_id));
39: fnd_file.put_line( fnd_file.log,'l_num_workers = ' || to_char(l_num_workers));
40: if l_batch_size is NULL then
41: l_batch_size := 999;
42: end if;

Line 39: fnd_file.put_line( fnd_file.log,'l_num_workers = ' || to_char(l_num_workers));

35: l_num_workers := p_num_workers;
36: -- Value populated if the conc. parameters are null.
37: fnd_file.put_line( fnd_file.log,'l_batch_size = ' || to_char(l_batch_size));
38: fnd_file.put_line( fnd_file.log,'l_worker_id = ' || to_char(l_worker_id));
39: fnd_file.put_line( fnd_file.log,'l_num_workers = ' || to_char(l_num_workers));
40: if l_batch_size is NULL then
41: l_batch_size := 999;
42: end if;
43: if l_worker_id is NULL then

Line 55: fnd_file.put_line( fnd_file.log,'Running Tax Rate update program in '||ln_cnt|| ' operating units.');

51: BEGIN
52: select count(*) into ln_cnt from ar_system_parameters_all
53: where TAX_DATABASE_VIEW_SET in ('_V','_A')
54: and nvl(global_attribute17,'XXXXXX') not in ('EFF_RATE_ENH','EFF_RATE_RUN');
55: fnd_file.put_line( fnd_file.log,'Running Tax Rate update program in '||ln_cnt|| ' operating units.');
56: EXCEPTION
57: when no_data_found then
58: fnd_file.put_line( fnd_file.log,'Tax Partner Integration: Tax Rate Program has already been run for this instance.');
59: ln_cnt := 0;

Line 58: fnd_file.put_line( fnd_file.log,'Tax Partner Integration: Tax Rate Program has already been run for this instance.');

54: and nvl(global_attribute17,'XXXXXX') not in ('EFF_RATE_ENH','EFF_RATE_RUN');
55: fnd_file.put_line( fnd_file.log,'Running Tax Rate update program in '||ln_cnt|| ' operating units.');
56: EXCEPTION
57: when no_data_found then
58: fnd_file.put_line( fnd_file.log,'Tax Partner Integration: Tax Rate Program has already been run for this instance.');
59: ln_cnt := 0;
60: END;
61: --Disable U.S. Sales Tax Report program
62: IF ln_cnt > 0 THEN

Line 80: fnd_file.put_line( fnd_file.log,'ERROR1 =='||SQLERRM);

76: set global_attribute17='EFF_RATE_RUN'
77: where TAX_DATABASE_VIEW_SET in ('_V','_A');
78: EXCEPTION
79: when others then
80: fnd_file.put_line( fnd_file.log,'ERROR1 =='||SQLERRM);
81: raise;
82: END;
83: /* ------ Initialize the rowid ranges ------ */
84:

Line 122: fnd_file.put_line( fnd_file.log,'Row processed =='||l_rows_processed);

118: and t.global_attribute_category in ('VERTEX', 'AVP')
119: and t.rowid between l_start_rowid and l_end_rowid;
120:
121: l_rows_processed := SQL%ROWCOUNT;
122: fnd_file.put_line( fnd_file.log,'Row processed =='||l_rows_processed);
123: EXCEPTION
124: when others then
125: fnd_file.put_line( fnd_file.log,'ERROR2 =='||SQLERRM);
126: raise;

Line 125: fnd_file.put_line( fnd_file.log,'ERROR2 =='||SQLERRM);

121: l_rows_processed := SQL%ROWCOUNT;
122: fnd_file.put_line( fnd_file.log,'Row processed =='||l_rows_processed);
123: EXCEPTION
124: when others then
125: fnd_file.put_line( fnd_file.log,'ERROR2 =='||SQLERRM);
126: raise;
127: END;
128:
129: ad_parallel_updates_pkg.processed_rowid_range(

Line 156: fnd_file.put_line( fnd_file.log,'ERROR3 =='||SQLERRM);

152: where TAX_DATABASE_VIEW_SET in ('_V','_A')
153: and global_attribute17 = 'EFF_RATE_RUN';
154: exception
155: when others then
156: fnd_file.put_line( fnd_file.log,'ERROR3 =='||SQLERRM);
157: raise;
158: end;
159: -- Enable US Sales tax Report program
160: --Enable U.S. Sales Tax Report after completing all the tasks

Line 206: fnd_file.put_line( fnd_file.log,'l_batch_commit_size =='||to_char(l_batch_commit_size));

202: l_batch_commit_size := p_batch_commit_size;
203: l_num_workers := p_num_workers;
204:
205:
206: fnd_file.put_line( fnd_file.log,'l_batch_commit_size =='||to_char(l_batch_commit_size));
207: fnd_file.put_line( fnd_file.log,'l_num_workers =='||to_char(l_num_workers));
208:
209: AD_CONC_UTILS_PKG.submit_subrequests(
210: X_errbuf => errbuf,

Line 207: fnd_file.put_line( fnd_file.log,'l_num_workers =='||to_char(l_num_workers));

203: l_num_workers := p_num_workers;
204:
205:
206: fnd_file.put_line( fnd_file.log,'l_batch_commit_size =='||to_char(l_batch_commit_size));
207: fnd_file.put_line( fnd_file.log,'l_num_workers =='||to_char(l_num_workers));
208:
209: AD_CONC_UTILS_PKG.submit_subrequests(
210: X_errbuf => errbuf,
211: X_retcode => retcode,

Line 226: fnd_file.put_line( fnd_file.log,'ERROR == '||sqlerrm);

222: X_Argument10 => NULL);
223:
224: exception
225: when others then
226: fnd_file.put_line( fnd_file.log,'ERROR == '||sqlerrm);
227: END Master_Conc_Parallel_Upgrade;
228:
229: end ARP_TAX_RATE_UPD;