DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on FND_FILE

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

5445: BEGIN
5446: --
5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');

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

5446: --
5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:

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

5447: -- Manager processing for OKC_K_LINES_B table
5448: --
5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:
5455: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,

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

5449: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_BMGR ');
5450: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5451: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5452:
5453: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_b update worker ');
5454:
5455: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5456: X_retcode,
5457: 'OKS',

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

5458: 'OKSUBAFWKR',
5459: P_batch_size,
5460: P_Num_Workers);
5461:
5462: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5463: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5464:
5465: END Update_Annualized_Factor_BMGR;
5466:

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

5459: P_batch_size,
5460: P_Num_Workers);
5461:
5462: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5463: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5464:
5465: END Update_Annualized_Factor_BMGR;
5466:
5467: PROCEDURE Update_Annualized_Factor_HMGR(X_errbuf out NOCOPY varchar2,

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

5472: BEGIN
5473: --
5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');

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

5473: --
5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:

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

5474: -- Manager processing for OKC_K_LINES_BH table
5475: --
5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:
5482: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,

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

5476: fnd_file.put_line(FND_FILE.LOG, 'Start of Update_Annualized_Factor_HMGR ');
5477: fnd_file.put_line(FND_FILE.LOG, ' P_batch_size : '||P_batch_size);
5478: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5479:
5480: fnd_file.put_line(FND_FILE.LOG, 'starting okc_k_lines_bh update worker ');
5481:
5482: AD_CONC_UTILS_PKG.submit_subrequests(X_errbuf,
5483: X_retcode,
5484: 'OKS',

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

5485: 'OKSUHAFWKR',
5486: P_batch_size,
5487: P_Num_Workers);
5488:
5489: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5490: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5491:
5492: END Update_Annualized_Factor_HMGR;
5493:

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

5486: P_batch_size,
5487: P_Num_Workers);
5488:
5489: fnd_file.put_line(FND_FILE.LOG, 'X_errbuf : '||X_errbuf);
5490: fnd_file.put_line(FND_FILE.LOG, 'X_retcode : '||X_retcode);
5491:
5492: END Update_Annualized_Factor_HMGR;
5493:
5494: PROCEDURE Update_Annualized_Factor_BWKR(X_errbuf out NOCOPY varchar2,

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

5521: then
5522: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --

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

5522: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --
5530: -- Worker processing

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

5523: end if;
5524:
5525: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_B table ');
5526: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5527: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5528:
5529: --
5530: -- Worker processing
5531: --

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

5581: l_any_rows_to_process,
5582: P_batch_size,
5583: FALSE);
5584: end loop;
5585: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_B table completed successfully');
5586: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5587: X_errbuf := ' ';
5588: EXCEPTION
5589: WHEN OTHERS THEN

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

5588: EXCEPTION
5589: WHEN OTHERS THEN
5590: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5591: X_errbuf := SQLERRM;
5592: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5593: fnd_file.put_line(FND_FILE.LOG,' ');
5594: raise;
5595: END;
5596: END Update_Annualized_Factor_BWKR;

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

5589: WHEN OTHERS THEN
5590: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5591: X_errbuf := SQLERRM;
5592: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5593: fnd_file.put_line(FND_FILE.LOG,' ');
5594: raise;
5595: END;
5596: END Update_Annualized_Factor_BWKR;
5597:

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

5625: then
5626: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --

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

5626: raise_application_error(-20001,'Cannot get schema name for product : '||l_product);
5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --
5634: -- Worker processing

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

5627: end if;
5628:
5629: fnd_file.put_line(FND_FILE.LOG, 'Start of upgrade script for OKC_K_LINES_BH table ');
5630: fnd_file.put_line(FND_FILE.LOG, ' P_Worker_Id : '||P_Worker_Id);
5631: fnd_file.put_line(FND_FILE.LOG, 'P_Num_Workers : '||P_Num_Workers);
5632:
5633: --
5634: -- Worker processing
5635: --

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

5685: l_any_rows_to_process,
5686: P_batch_size,
5687: FALSE);
5688: end loop;
5689: fnd_file.put_line(FND_FILE.LOG,'Upgrade for OKC_K_LINES_BH table completed successfully');
5690: X_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
5691: X_errbuf := ' ';
5692: EXCEPTION
5693: WHEN OTHERS THEN

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

5692: EXCEPTION
5693: WHEN OTHERS THEN
5694: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5695: X_errbuf := SQLERRM;
5696: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5697: fnd_file.put_line(FND_FILE.LOG,' ');
5698: raise;
5699: END;
5700: END Update_Annualized_Factor_HWKR;

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

5693: WHEN OTHERS THEN
5694: X_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
5695: X_errbuf := SQLERRM;
5696: fnd_file.put_line(FND_FILE.LOG,'X_errbuf : '||X_errbuf);
5697: fnd_file.put_line(FND_FILE.LOG,' ');
5698: raise;
5699: END;
5700: END Update_Annualized_Factor_HWKR;
5701: --end npalepu