DBA Data[Home] [Help]

APPS.CN_UPG_PMT_TRXNS_PKG dependencies on FND_FILE

Line 11: fnd_file.put_line(FND_FILE.LOG, 'Before CNUPGPMTCLWRKER ');

7: X_batch_size in number,
8: X_Num_Workers in number)
9: IS
10: BEGIN
11: fnd_file.put_line(FND_FILE.LOG, 'Before CNUPGPMTCLWRKER ');
12: --
13: -- Manager processing for commission
14: --
15: AD_CONC_UTILS_PKG.submit_subrequests(

Line 23: fnd_file.put_line(FND_FILE.LOG, 'Completed CNUPGPMTCLWRKER ');

19: X_WorkerConc_progname=> 'CNUPGPMTCLWRKER' ,
20: X_batch_size=>X_batch_size,
21: X_Num_Workers=>X_Num_Workers);
22:
23: fnd_file.put_line(FND_FILE.LOG, 'Completed CNUPGPMTCLWRKER ');
24:
25: END CommLines_Upgrade_Mgr;
26:
27:

Line 35: fnd_file.put_line(FND_FILE.LOG, 'Before CNUPGPMTRXWRKER ');

31: X_batch_size in number,
32: X_Num_Workers in number)
33: IS
34: BEGIN
35: fnd_file.put_line(FND_FILE.LOG, 'Before CNUPGPMTRXWRKER ');
36: --
37: -- Manager processing for transactions
38: --
39: AD_CONC_UTILS_PKG.submit_subrequests(

Line 47: fnd_file.put_line(FND_FILE.LOG, 'Completed CNUPGPMTRXWRKER ');

43: X_WorkerConc_progname=> 'CNUPGPMTRXWRKER' ,
44: X_batch_size=>X_batch_size,
45: X_Num_Workers=>X_Num_Workers);
46:
47: fnd_file.put_line(FND_FILE.LOG, 'Completed CNUPGPMTRXWRKER ');
48:
49: END PmtTrxns_Upgrade_Mgr ;
50:
51:

Line 88: fnd_file.put_line(FND_FILE.LOG, 'Entering Update_Commlines_WRK ');

84:
85: --
86: -- get schema name of the table for ROWID range processing
87: --
88: fnd_file.put_line(FND_FILE.LOG, 'Entering Update_Commlines_WRK ');
89: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
90:
91: if ((l_retstatus = FALSE) OR (l_table_owner is null))
92: then

Line 96: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);

92: then
93: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
94: end if;
95:
96: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);
97: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
98:
99: --=========================
100: -- Worker processing

Line 97: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);

93: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
94: end if;
95:
96: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);
97: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
98:
99: --=========================
100: -- Worker processing
101: --=========================

Line 131: fnd_file.put_line(FND_FILE.LOG, 'updating commission lines posting column to UNPOSTED ');

127: -- product specific processing here
128: -----------------------------------------------------
129:
130: -- Code your update logic here
131: fnd_file.put_line(FND_FILE.LOG, 'updating commission lines posting column to UNPOSTED ');
132:
133: update /*+ rowid(CL) */ cn_commission_lines_all cl
134: set posting_status = 'UNPOSTED',
135: last_update_date = sysdate

Line 143: fnd_file.put_line(FND_FILE.LOG, 'Finished updating upgrade data until rowend = '||l_end_rowid);

139: l_rows_processed := SQL%ROWCOUNT;
140:
141: ad_parallel_updates_pkg.processed_rowid_range(l_rows_processed, l_end_rowid);
142:
143: fnd_file.put_line(FND_FILE.LOG, 'Finished updating upgrade data until rowend = '||l_end_rowid);
144:
145: COMMIT;
146:
147: ad_parallel_updates_pkg.get_rowid_range(

Line 201: fnd_file.put_line(FND_FILE.LOG, 'Entering Update_Pmt_Trxns_WRK ');

197: x_msg_data varchar2(240);
198:
199: BEGIN
200:
201: fnd_file.put_line(FND_FILE.LOG, 'Entering Update_Pmt_Trxns_WRK ');
202: -- get schema name of the table for ROWID range processing
203: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
204:
205: if ((l_retstatus = FALSE) OR (l_table_owner is null))

Line 210: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);

206: then
207: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
208: end if;
209:
210: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);
211: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
212:
213: --=========================
214: -- Worker processing

Line 211: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);

207: raise_application_error(-20001, 'Cannot get schema name for product : '||l_product);
208: end if;
209:
210: fnd_file.put_line(FND_FILE.LOG, 'X_Worker_Id : '||X_Worker_Id);
211: fnd_file.put_line(FND_FILE.LOG, 'X_Num_Workers : '||X_Num_Workers);
212:
213: --=========================
214: -- Worker processing
215: --=========================

Line 299: fnd_file.put_line(FND_FILE.LOG, 'Rows with plans ending : '|| l_rows_processed );

295:
296:
297:
298: l_rows_processed := SQL%ROWCOUNT;
299: fnd_file.put_line(FND_FILE.LOG, 'Rows with plans ending : '|| l_rows_processed );
300: ad_parallel_updates_pkg.processed_rowid_range(l_rows_processed,l_end_rowid);
301: COMMIT;
302: fnd_file.put_line(FND_FILE.LOG, 'Finished updating upgrade data until rowend = '||l_end_rowid);
303: ad_parallel_updates_pkg.get_rowid_range(

Line 302: fnd_file.put_line(FND_FILE.LOG, 'Finished updating upgrade data until rowend = '||l_end_rowid);

298: l_rows_processed := SQL%ROWCOUNT;
299: fnd_file.put_line(FND_FILE.LOG, 'Rows with plans ending : '|| l_rows_processed );
300: ad_parallel_updates_pkg.processed_rowid_range(l_rows_processed,l_end_rowid);
301: COMMIT;
302: fnd_file.put_line(FND_FILE.LOG, 'Finished updating upgrade data until rowend = '||l_end_rowid);
303: ad_parallel_updates_pkg.get_rowid_range(
304: l_start_rowid,
305: l_end_rowid,
306: l_any_rows_to_process,