DBA Data[Home] [Help]

APPS.OKI_DBI_CURRENCY_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 129: BIS_COLLECTION_UTILITIES.log(sqlerrm || ' chr_id '||

125: -- rate
126: NULL ;
127:
128: WHEN TOO_MANY_ROWS THEN
129: BIS_COLLECTION_UTILITIES.log(sqlerrm || ' chr_id '||
130: to_char(p_chr_id) ,3) ;
131: OKI_DBI_CURRENCY_PVT.g_conversion_date := NULL ;
132: OKI_DBI_CURRENCY_PVT.g_trx_func_rate := -10 ;
133: OKI_DBI_CURRENCY_PVT.g_func_global_rate := -10 ;

Line 139: BIS_COLLECTION_UTILITIES.log(sqlerrm || ' chr_id '||

135: OKI_DBI_CURRENCY_PVT.g_func_sglobal_rate := -10 ;
136: RETURN OKI_DBI_CURRENCY_PVT.g_conversion_date ;
137:
138: WHEN OTHERS THEN
139: BIS_COLLECTION_UTILITIES.log(sqlerrm || ' chr_id '||
140: to_char(p_chr_id) ,3) ;
141: OKI_DBI_CURRENCY_PVT.g_conversion_date := NULL ;
142: OKI_DBI_CURRENCY_PVT.g_trx_func_rate := -11 ;
143: OKI_DBI_CURRENCY_PVT.g_func_global_rate := -11 ;

Line 398: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

394: END IF ;
395: RETURN OKI_DBI_CURRENCY_PVT.g_func_global_rate ;
396: EXCEPTION
397: WHEN OTHERS THEN
398: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
399: fnd_message.set_name( application => 'FND'
400: , name => 'CRM-DEBUG ERROR' ) ;
401: fnd_message.set_token( token => 'ROUTINE'
402: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_global_rate_init ' ) ;

Line 403: bis_collection_utilities.put_line(fnd_message.get) ;

399: fnd_message.set_name( application => 'FND'
400: , name => 'CRM-DEBUG ERROR' ) ;
401: fnd_message.set_token( token => 'ROUTINE'
402: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_global_rate_init ' ) ;
403: bis_collection_utilities.put_line(fnd_message.get) ;
404: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
405: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: END get_dbi_global_rate_init ;
407:

Line 404: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

400: , name => 'CRM-DEBUG ERROR' ) ;
401: fnd_message.set_token( token => 'ROUTINE'
402: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_global_rate_init ' ) ;
403: bis_collection_utilities.put_line(fnd_message.get) ;
404: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
405: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
406: END get_dbi_global_rate_init ;
407:
408: /* ***********************************************************************

Line 441: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

437: END IF ;
438: RETURN OKI_DBI_CURRENCY_PVT.g_func_sglobal_rate ;
439: EXCEPTION
440: WHEN OTHERS THEN
441: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
442: fnd_message.set_name( application => 'FND'
443: , name => 'CRM-DEBUG ERROR' ) ;
444: fnd_message.set_token( token => 'ROUTINE'
445: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_sglobal_rate_init ' ) ;

Line 446: bis_collection_utilities.put_line(fnd_message.get) ;

442: fnd_message.set_name( application => 'FND'
443: , name => 'CRM-DEBUG ERROR' ) ;
444: fnd_message.set_token( token => 'ROUTINE'
445: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_sglobal_rate_init ' ) ;
446: bis_collection_utilities.put_line(fnd_message.get) ;
447: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
449: END get_dbi_sglobal_rate_init ;
450:

Line 447: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

443: , name => 'CRM-DEBUG ERROR' ) ;
444: fnd_message.set_token( token => 'ROUTINE'
445: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_sglobal_rate_init ' ) ;
446: bis_collection_utilities.put_line(fnd_message.get) ;
447: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
449: END get_dbi_sglobal_rate_init ;
450:
451: -- -------------------------------

Line 487: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

483: END IF ;
484: RETURN OKI_DBI_CURRENCY_PVT.g_func_global_rate ;
485: EXCEPTION
486: WHEN OTHERS THEN
487: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
488: fnd_message.set_name( application => 'FND'
489: , name => 'CRM-DEBUG ERROR' ) ;
490: fnd_message.set_token( token => 'ROUTINE'
491: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_global_rate ' ) ;

Line 492: bis_collection_utilities.put_line(fnd_message.get) ;

488: fnd_message.set_name( application => 'FND'
489: , name => 'CRM-DEBUG ERROR' ) ;
490: fnd_message.set_token( token => 'ROUTINE'
491: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_global_rate ' ) ;
492: bis_collection_utilities.put_line(fnd_message.get) ;
493: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
494: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
495: END get_dbi_global_rate ;
496:

Line 493: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

489: , name => 'CRM-DEBUG ERROR' ) ;
490: fnd_message.set_token( token => 'ROUTINE'
491: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_global_rate ' ) ;
492: bis_collection_utilities.put_line(fnd_message.get) ;
493: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
494: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
495: END get_dbi_global_rate ;
496:
497: -- -------------------------------

Line 534: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

530: END IF ;
531: RETURN OKI_DBI_CURRENCY_PVT.g_func_sglobal_rate ;
532: EXCEPTION
533: WHEN OTHERS THEN
534: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
535: fnd_message.set_name( application => 'FND'
536: , name => 'CRM-DEBUG ERROR' ) ;
537: fnd_message.set_token( token => 'ROUTINE'
538: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_sglobal_rate ' ) ;

Line 539: bis_collection_utilities.put_line(fnd_message.get) ;

535: fnd_message.set_name( application => 'FND'
536: , name => 'CRM-DEBUG ERROR' ) ;
537: fnd_message.set_token( token => 'ROUTINE'
538: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_sglobal_rate ' ) ;
539: bis_collection_utilities.put_line(fnd_message.get) ;
540: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
542: END get_dbi_sglobal_rate ;
543:

Line 540: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

536: , name => 'CRM-DEBUG ERROR' ) ;
537: fnd_message.set_token( token => 'ROUTINE'
538: , value => 'OKI_DBI_CURRENCY_PVT.get_dbi_sglobal_rate ' ) ;
539: bis_collection_utilities.put_line(fnd_message.get) ;
540: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
542: END get_dbi_sglobal_rate ;
543:
544: /* *******************************************************

Line 577: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

573: END IF ;
574: RETURN OKI_DBI_CURRENCY_PVT.g_trx_func_rate ;
575: EXCEPTION
576: WHEN OTHERS THEN
577: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
578: fnd_message.set_name( application => 'FND'
579: , name => 'CRM-DEBUG ERROR' ) ;
580: fnd_message.set_token( token => 'ROUTINE'
581: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_func_rate ' ) ;

Line 582: bis_collection_utilities.put_line(fnd_message.get) ;

578: fnd_message.set_name( application => 'FND'
579: , name => 'CRM-DEBUG ERROR' ) ;
580: fnd_message.set_token( token => 'ROUTINE'
581: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_func_rate ' ) ;
582: bis_collection_utilities.put_line(fnd_message.get) ;
583: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
585: END get_trx_func_rate ;
586:

Line 583: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

579: , name => 'CRM-DEBUG ERROR' ) ;
580: fnd_message.set_token( token => 'ROUTINE'
581: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_func_rate ' ) ;
582: bis_collection_utilities.put_line(fnd_message.get) ;
583: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
584: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
585: END get_trx_func_rate ;
586:
587: -----------------------

Line 621: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

617: END IF ;
618: RETURN OKI_DBI_CURRENCY_PVT.g_trx_func_rate ;
619: EXCEPTION
620: WHEN OTHERS THEN
621: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
622: fnd_message.set_name( application => 'FND'
623: , name => 'CRM-DEBUG ERROR' ) ;
624: fnd_message.set_token( token => 'ROUTINE'
625: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_func_rate_init ' ) ;

Line 626: bis_collection_utilities.put_line(fnd_message.get) ;

622: fnd_message.set_name( application => 'FND'
623: , name => 'CRM-DEBUG ERROR' ) ;
624: fnd_message.set_token( token => 'ROUTINE'
625: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_func_rate_init ' ) ;
626: bis_collection_utilities.put_line(fnd_message.get) ;
627: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: END get_trx_func_rate_init ;
630:

Line 627: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

623: , name => 'CRM-DEBUG ERROR' ) ;
624: fnd_message.set_token( token => 'ROUTINE'
625: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_func_rate_init ' ) ;
626: bis_collection_utilities.put_line(fnd_message.get) ;
627: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
628: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: END get_trx_func_rate_init ;
630:
631:

Line 665: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

661: END IF ;
662: RETURN OKI_DBI_CURRENCY_PVT.g_trx_rate_type ;
663: EXCEPTION
664: WHEN OTHERS THEN
665: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
666: fnd_message.set_name( application => 'FND'
667: , name => 'CRM-DEBUG ERROR' ) ;
668: fnd_message.set_token( token => 'ROUTINE'
669: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_rate_type ' ) ;

Line 670: bis_collection_utilities.put_line(fnd_message.get) ;

666: fnd_message.set_name( application => 'FND'
667: , name => 'CRM-DEBUG ERROR' ) ;
668: fnd_message.set_token( token => 'ROUTINE'
669: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_rate_type ' ) ;
670: bis_collection_utilities.put_line(fnd_message.get) ;
671: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
672: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
673: END get_trx_rate_type ;
674: -----------------------

Line 671: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

667: , name => 'CRM-DEBUG ERROR' ) ;
668: fnd_message.set_token( token => 'ROUTINE'
669: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_rate_type ' ) ;
670: bis_collection_utilities.put_line(fnd_message.get) ;
671: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
672: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
673: END get_trx_rate_type ;
674: -----------------------
675: /*******************************************************************************

Line 707: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

703: END IF ;
704: RETURN OKI_DBI_CURRENCY_PVT.g_trx_rate_type ;
705: EXCEPTION
706: WHEN OTHERS THEN
707: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
708: fnd_message.set_name( application => 'FND'
709: , name => 'CRM-DEBUG ERROR' ) ;
710: fnd_message.set_token( token => 'ROUTINE'
711: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_rate_type_init ' ) ;

Line 712: bis_collection_utilities.put_line(fnd_message.get) ;

708: fnd_message.set_name( application => 'FND'
709: , name => 'CRM-DEBUG ERROR' ) ;
710: fnd_message.set_token( token => 'ROUTINE'
711: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_rate_type_init ' ) ;
712: bis_collection_utilities.put_line(fnd_message.get) ;
713: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
715: END get_trx_rate_type_init ;
716:

Line 713: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;

709: , name => 'CRM-DEBUG ERROR' ) ;
710: fnd_message.set_token( token => 'ROUTINE'
711: , value => 'OKI_DBI_CURRENCY_PVT.get_trx_rate_type_init ' ) ;
712: bis_collection_utilities.put_line(fnd_message.get) ;
713: bis_collection_utilities.put_line( ' CHR_ID : ' || to_char(p_chr_id) ) ;
714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR ;
715: END get_trx_rate_type_init ;
716:
717: END OKI_DBI_CURRENCY_PVT;