DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on FND_FILE

Line 5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');

5436: BEGIN
5437: --
5438: -- Manager processing for OKC_K_LINES_B table
5439: --
5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5443:
5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');

Line 5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);

5437: --
5438: -- Manager processing for OKC_K_LINES_B table
5439: --
5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5443:
5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5445:

Line 5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

5438: -- Manager processing for OKC_K_LINES_B table
5439: --
5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5443:
5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5445:
5446: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,

Line 5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');

5440: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5441: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5442: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5443:
5444: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5445:
5446: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5447: X_retcode,
5448: 'OKS',

Line 5453: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);

5449: 'OKSUBAFWKR',
5450: P_batch_size,
5451: P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5454: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5455:
5456: END Update_Annualized_Factor_BMGR;
5457:

Line 5454: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);

5450: P_batch_size,
5451: P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5454: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5455:
5456: END Update_Annualized_Factor_BMGR;
5457:
5458: PROCEDURE Update_Annualized_Factor_HMGR(X_errbuf out NOCOPY varchar2,

Line 5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');

5463: BEGIN
5464: --
5465: -- Manager processing for OKC_K_LINES_BH table
5466: --
5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5470:
5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');

Line 5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);

5464: --
5465: -- Manager processing for OKC_K_LINES_BH table
5466: --
5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5470:
5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5472:

Line 5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

5465: -- Manager processing for OKC_K_LINES_BH table
5466: --
5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5470:
5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5472:
5473: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,

Line 5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');

5467: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5468: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5469: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5470:
5471: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5472:
5473: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5474: X_retcode,
5475: 'OKS',

Line 5480: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);

5476: 'OKSUHAFWKR',
5477: P_batch_size,
5478: P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5481: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5482:
5483: END Update_Annualized_Factor_HMGR;
5484:

Line 5481: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);

5477: P_batch_size,
5478: P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5481: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5482:
5483: END Update_Annualized_Factor_HMGR;
5484:
5485: PROCEDURE Update_Annualized_Factor_BWKR(X_errbuf out NOCOPY varchar2,

Line 5516: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');

5512: then
5513: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5514: end if;
5515:
5516: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5517: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5518: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5519:
5520: --

Line 5517: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);

5513: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5514: end if;
5515:
5516: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5517: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5518: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5519:
5520: --
5521: -- Worker processing

Line 5518: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

5514: end if;
5515:
5516: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5517: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5518: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5519:
5520: --
5521: -- Worker processing
5522: --

Line 5576: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');

5572: l_any_rows_to_process,
5573: P_batch_size,
5574: FALSE);
5575: end loop;
5576: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');
5577: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5578: X_errbuf := ' ';
5579: EXCEPTION
5580: WHEN OTHERS THEN

Line 5583: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);

5579: EXCEPTION
5580: WHEN OTHERS THEN
5581: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5582: X_errbuf := SQLERRM;
5583: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5584: fnd_file.put_line(FND_FILE.LOG,' ');
5585: raise;
5586: END;
5587: END Update_Annualized_Factor_BWKR;

Line 5584: fnd_file.put_line(FND_FILE.LOG,' ');

5580: WHEN OTHERS THEN
5581: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5582: X_errbuf := SQLERRM;
5583: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5584: fnd_file.put_line(FND_FILE.LOG,' ');
5585: raise;
5586: END;
5587: END Update_Annualized_Factor_BWKR;
5588:

Line 5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');

5616: then
5617: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5618: end if;
5619:
5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5621: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5622: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5623:
5624: --

Line 5621: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);

5617: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5618: end if;
5619:
5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5621: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5622: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5623:
5624: --
5625: -- Worker processing

Line 5622: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);

5618: end if;
5619:
5620: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5621: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5622: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5623:
5624: --
5625: -- Worker processing
5626: --

Line 5680: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');

5676: l_any_rows_to_process,
5677: P_batch_size,
5678: FALSE);
5679: end loop;
5680: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');
5681: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5682: X_errbuf := ' ';
5683: EXCEPTION
5684: WHEN OTHERS THEN

Line 5687: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);

5683: EXCEPTION
5684: WHEN OTHERS THEN
5685: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5686: X_errbuf := SQLERRM;
5687: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5688: fnd_file.put_line(FND_FILE.LOG,' ');
5689: raise;
5690: END;
5691: END Update_Annualized_Factor_HWKR;

Line 5688: fnd_file.put_line(FND_FILE.LOG,' ');

5684: WHEN OTHERS THEN
5685: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5686: X_errbuf := SQLERRM;
5687: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5688: fnd_file.put_line(FND_FILE.LOG,' ');
5689: raise;
5690: END;
5691: END Update_Annualized_Factor_HWKR;
5692: --end npalepu