eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MULTI_CURRENCY dependencies on PA_CC_UTILS

Line 4: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode;

1: PACKAGE BODY pa_multi_currency AS
2: --$Header: PAXTMCTB.pls 120.2.12000000.2 2007/06/26 11:39:32 sugupta ship $
3:
4: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode;
5: ------------------------------------------------------------------------------
6: -- Function pa_multi_currency.check_rate_date_code.
7: -- Comments for the function are at the package specification level
8: ------------------------------------------------------------------------------

Line 377: pa_cc_utils.set_curr_function('convert_closest_amount');

373: V_allow_user_rate_type VARCHAR2(1) ;
374: V_converted_amount NUMBER ;
375:
376: BEGIN
377: pa_cc_utils.set_curr_function('convert_closest_amount');
378: IF P_DEBUG_MODE THEN
379: pa_cc_utils.log_message('convert_closest_amount: ' || 'Start ');
380: END IF;
381:

Line 379: pa_cc_utils.log_message('convert_closest_amount: ' || 'Start ');

375:
376: BEGIN
377: pa_cc_utils.set_curr_function('convert_closest_amount');
378: IF P_DEBUG_MODE THEN
379: pa_cc_utils.log_message('convert_closest_amount: ' || 'Start ');
380: END IF;
381:
382: X_status := null ;
383: P_conversion_date := NVL(P_conversion_date, sysdate);

Line 390: pa_cc_utils.reset_curr_function ;

386: P_conversion_date := null;
387: P_conversion_type := null;
388: P_rate := null;
389: P_converted_amount:= P_amount;
390: pa_cc_utils.reset_curr_function ;
391: RETURN;
392: END IF;
393:
394: IF ( P_conversion_type = 'User') THEN

Line 397: pa_cc_utils.log_message('convert_closest_amount: ' || 'Before calling is_user_rate_type_allowed');

393:
394: IF ( P_conversion_type = 'User') THEN
395: IF( P_user_validate_flag = 'Y') THEN
396: IF P_DEBUG_MODE THEN
397: pa_cc_utils.log_message('convert_closest_amount: ' || 'Before calling is_user_rate_type_allowed');
398: END IF;
399: V_allow_user_rate_type := is_user_rate_type_allowed (P_from_currency ,
400: P_to_currency ,
401: P_conversion_date) ;

Line 411: pa_cc_utils.reset_curr_function ;

407: P_denominator := 1 ;
408: P_numerator := NVL(P_rate,1) ;
409: ELSE
410: X_status := 'PA_USR_RATE_NOT_ALLOWED';
411: pa_cc_utils.reset_curr_function ;
412: RETURN ;
413: END IF;
414:
415: ELSE P_converted_amount := PA_CURRENCY.round_trans_currency_amt

Line 423: pa_cc_utils.log_message('Before Calling GL_CURRENCY_API.convert_closest_amount');

419: END IF;
420:
421: ELSE
422: IF P_DEBUG_MODE THEN
423: pa_cc_utils.log_message('Before Calling GL_CURRENCY_API.convert_closest_amount');
424: END IF;
425: GL_CURRENCY_API.convert_closest_amount
426: ( P_from_currency ,
427: P_to_currency ,

Line 438: pa_cc_utils.log_message('After Calling GL_CURRENCY_API.convert_closest_amount');

434: P_denominator ,
435: P_numerator ,
436: P_rate ) ;
437: IF P_DEBUG_MODE THEN
438: pa_cc_utils.log_message('After Calling GL_CURRENCY_API.convert_closest_amount');
439: END IF;
440: P_converted_amount := PA_CURRENCY.round_trans_currency_amt
441: ( P_converted_amount, P_to_currency);
442: END IF ;

Line 444: pa_cc_utils.log_message('convert_closest_amount: ' || 'End ');

440: P_converted_amount := PA_CURRENCY.round_trans_currency_amt
441: ( P_converted_amount, P_to_currency);
442: END IF ;
443: IF P_DEBUG_MODE THEN
444: pa_cc_utils.log_message('convert_closest_amount: ' || 'End ');
445: END IF;
446: pa_cc_utils.reset_curr_function ;
447:
448: EXCEPTION

Line 446: pa_cc_utils.reset_curr_function ;

442: END IF ;
443: IF P_DEBUG_MODE THEN
444: pa_cc_utils.log_message('convert_closest_amount: ' || 'End ');
445: END IF;
446: pa_cc_utils.reset_curr_function ;
447:
448: EXCEPTION
449:
450: WHEN gl_currency_api.no_rate THEN

Line 455: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);

451: IF (P_handle_exception_flag = 'Y') THEN
452: X_status := 'PA_NO_EXCH_RATE_EXISTS';
453: ELSE
454: IF P_DEBUG_MODE THEN
455: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);
456: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
457: END IF;
458: RAISE;
459: END IF;

Line 456: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);

452: X_status := 'PA_NO_EXCH_RATE_EXISTS';
453: ELSE
454: IF P_DEBUG_MODE THEN
455: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);
456: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
457: END IF;
458: RAISE;
459: END IF;
460: WHEN gl_currency_api.invalid_currency THEN

Line 465: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);

461: IF (P_handle_exception_flag = 'Y') THEN
462: X_status := 'PA_CURR_NOT_VALID';
463: ELSE
464: IF P_DEBUG_MODE THEN
465: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);
466: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
467: END IF;
468: RAISE;
469: END IF;

Line 466: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);

462: X_status := 'PA_CURR_NOT_VALID';
463: ELSE
464: IF P_DEBUG_MODE THEN
465: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);
466: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
467: END IF;
468: RAISE;
469: END IF;
470: WHEN others THEN

Line 472: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);

468: RAISE;
469: END IF;
470: WHEN others THEN
471: IF P_DEBUG_MODE THEN
472: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);
473: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
474: END IF;
475: RAISE;
476:

Line 473: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);

469: END IF;
470: WHEN others THEN
471: IF P_DEBUG_MODE THEN
472: pa_cc_utils.log_message('convert_closest_amount: ' || pa_debug.G_err_stack);
473: pa_cc_utils.log_message('convert_closest_amount: ' || SQLERRM);
474: END IF;
475: RAISE;
476:
477: END convert_closest_amount;

Line 495: pa_cc_utils.set_curr_function('format_amount');

491: num_rows NUMBER ;
492:
493: BEGIN
494:
495: pa_cc_utils.set_curr_function('format_amount');
496: IF P_DEBUG_MODE THEN
497: pa_cc_utils.log_message('format_amount: ' || 'Start ');
498: END IF;
499:

Line 497: pa_cc_utils.log_message('format_amount: ' || 'Start ');

493: BEGIN
494:
495: pa_cc_utils.set_curr_function('format_amount');
496: IF P_DEBUG_MODE THEN
497: pa_cc_utils.log_message('format_amount: ' || 'Start ');
498: END IF;
499:
500: num_rows := FormatMaskTab.count ;
501: -- This gets the Number of Rows in the PL/SQL table.

Line 505: pa_cc_utils.log_message('format_amount: ' || 'Start of Loop');

501: -- This gets the Number of Rows in the PL/SQL table.
502:
503: FOR i in 1..num_rows LOOP
504: IF P_DEBUG_MODE THEN
505: pa_cc_utils.log_message('format_amount: ' || 'Start of Loop');
506: END IF;
507: IF ( P_currency IS NOT NULL
508: AND FormatMaskTab(i).currency_code = P_currency) THEN
509: IF P_DEBUG_MODE THEN

Line 510: pa_cc_utils.log_message('format_amount: ' || 'Before retrieving from PLSQL Table');

506: END IF;
507: IF ( P_currency IS NOT NULL
508: AND FormatMaskTab(i).currency_code = P_currency) THEN
509: IF P_DEBUG_MODE THEN
510: pa_cc_utils.log_message('format_amount: ' || 'Before retrieving from PLSQL Table');
511: END IF;
512:
513: l_format_mask := FormatMaskTab(i).format_mask ;
514: IF P_DEBUG_MODE THEN

Line 515: pa_cc_utils.log_message('format_amount: ' || 'Before exit after getting format mask');

511: END IF;
512:
513: l_format_mask := FormatMaskTab(i).format_mask ;
514: IF P_DEBUG_MODE THEN
515: pa_cc_utils.log_message('format_amount: ' || 'Before exit after getting format mask');
516: END IF;
517:
518: EXIT ;
519: END IF ;

Line 521: pa_cc_utils.log_message('format_amount: ' || 'End of Loop');

517:
518: EXIT ;
519: END IF ;
520: IF P_DEBUG_MODE THEN
521: pa_cc_utils.log_message('format_amount: ' || 'End of Loop');
522: END IF;
523:
524: END LOOP ;
525:

Line 535: pa_cc_utils.log_message('format_amount: ' || 'Before calling FND_CURRENCY.get_format_mask');

531:
532: IF ( l_format_mask is NULL
533: AND P_currency IS NOT NULL )THEN
534: IF P_DEBUG_MODE THEN
535: pa_cc_utils.log_message('format_amount: ' || 'Before calling FND_CURRENCY.get_format_mask');
536: END IF;
537:
538: l_format_mask := FND_CURRENCY.get_format_mask (P_currency,
539: P_field_length ) ;

Line 545: pa_cc_utils.log_message('format_amount: ' || 'End ');

541: FormatMaskTab(num_rows + 1).format_mask := l_format_mask ;
542: END IF;
543: P_formatted_amount := TO_CHAR(P_amount, l_format_mask) ;
544: IF P_DEBUG_MODE THEN
545: pa_cc_utils.log_message('format_amount: ' || 'End ');
546: END IF;
547: pa_cc_utils.reset_curr_function ;
548:
549: -- This applies the format mask to the amount to get the formatted amount.

Line 547: pa_cc_utils.reset_curr_function ;

543: P_formatted_amount := TO_CHAR(P_amount, l_format_mask) ;
544: IF P_DEBUG_MODE THEN
545: pa_cc_utils.log_message('format_amount: ' || 'End ');
546: END IF;
547: pa_cc_utils.reset_curr_function ;
548:
549: -- This applies the format mask to the amount to get the formatted amount.
550: EXCEPTION
551: WHEN OTHERS THEN

Line 553: pa_cc_utils.log_message('format_amount: ' || pa_debug.G_err_stack);

549: -- This applies the format mask to the amount to get the formatted amount.
550: EXCEPTION
551: WHEN OTHERS THEN
552: IF P_DEBUG_MODE THEN
553: pa_cc_utils.log_message('format_amount: ' || pa_debug.G_err_stack);
554: pa_cc_utils.log_message('format_amount: ' || SQLERRM);
555: END IF;
556: RAISE ;
557: END format_amount ;

Line 554: pa_cc_utils.log_message('format_amount: ' || SQLERRM);

550: EXCEPTION
551: WHEN OTHERS THEN
552: IF P_DEBUG_MODE THEN
553: pa_cc_utils.log_message('format_amount: ' || pa_debug.G_err_stack);
554: pa_cc_utils.log_message('format_amount: ' || SQLERRM);
555: END IF;
556: RAISE ;
557: END format_amount ;
558:

Line 577: pa_cc_utils.set_curr_function('validate_rate_type');

573:
574: l_Rate_type C1%ROWTYPE;
575:
576: BEGIN
577: pa_cc_utils.set_curr_function('validate_rate_type');
578: IF P_DEBUG_MODE THEN
579: pa_cc_utils.log_message('validate_rate_type: ' || 'Start ');
580: END IF;
581:

Line 579: pa_cc_utils.log_message('validate_rate_type: ' || 'Start ');

575:
576: BEGIN
577: pa_cc_utils.set_curr_function('validate_rate_type');
578: IF P_DEBUG_MODE THEN
579: pa_cc_utils.log_message('validate_rate_type: ' || 'Start ');
580: END IF;
581:
582: OPEN C1 ;
583: IF P_DEBUG_MODE THEN

Line 584: pa_cc_utils.log_message('validate_rate_type: ' || 'After Open Cursor');

580: END IF;
581:
582: OPEN C1 ;
583: IF P_DEBUG_MODE THEN
584: pa_cc_utils.log_message('validate_rate_type: ' || 'After Open Cursor');
585: END IF;
586: FETCH C1 INTO l_Rate_type ;
587: IF P_DEBUG_MODE THEN
588: pa_cc_utils.log_message('validate_rate_type: ' || 'After fetch Cursor');

Line 588: pa_cc_utils.log_message('validate_rate_type: ' || 'After fetch Cursor');

584: pa_cc_utils.log_message('validate_rate_type: ' || 'After Open Cursor');
585: END IF;
586: FETCH C1 INTO l_Rate_type ;
587: IF P_DEBUG_MODE THEN
588: pa_cc_utils.log_message('validate_rate_type: ' || 'After fetch Cursor');
589: END IF;
590: IF C1%NOTFOUND THEN
591: CLOSE C1;
592: pa_cc_utils.reset_curr_function ;

Line 592: pa_cc_utils.reset_curr_function ;

588: pa_cc_utils.log_message('validate_rate_type: ' || 'After fetch Cursor');
589: END IF;
590: IF C1%NOTFOUND THEN
591: CLOSE C1;
592: pa_cc_utils.reset_curr_function ;
593: RETURN 'N';
594: ELSE
595: CLOSE C1;
596: pa_cc_utils.reset_curr_function ;

Line 596: pa_cc_utils.reset_curr_function ;

592: pa_cc_utils.reset_curr_function ;
593: RETURN 'N';
594: ELSE
595: CLOSE C1;
596: pa_cc_utils.reset_curr_function ;
597: RETURN 'Y';
598: END IF ;
599: IF P_DEBUG_MODE THEN
600: pa_cc_utils.log_message('validate_rate_type: ' || 'End ');

Line 600: pa_cc_utils.log_message('validate_rate_type: ' || 'End ');

596: pa_cc_utils.reset_curr_function ;
597: RETURN 'Y';
598: END IF ;
599: IF P_DEBUG_MODE THEN
600: pa_cc_utils.log_message('validate_rate_type: ' || 'End ');
601: END IF;
602: pa_cc_utils.reset_curr_function ;
603:
604: EXCEPTION

Line 602: pa_cc_utils.reset_curr_function ;

598: END IF ;
599: IF P_DEBUG_MODE THEN
600: pa_cc_utils.log_message('validate_rate_type: ' || 'End ');
601: END IF;
602: pa_cc_utils.reset_curr_function ;
603:
604: EXCEPTION
605: WHEN others THEN
606: IF P_DEBUG_MODE THEN

Line 607: pa_cc_utils.log_message('validate_rate_type: ' || pa_debug.G_err_stack);

603:
604: EXCEPTION
605: WHEN others THEN
606: IF P_DEBUG_MODE THEN
607: pa_cc_utils.log_message('validate_rate_type: ' || pa_debug.G_err_stack);
608: pa_cc_utils.log_message('validate_rate_type: ' || SQLERRM);
609: END IF;
610: RAISE ;
611: END validate_rate_type ;

Line 608: pa_cc_utils.log_message('validate_rate_type: ' || SQLERRM);

604: EXCEPTION
605: WHEN others THEN
606: IF P_DEBUG_MODE THEN
607: pa_cc_utils.log_message('validate_rate_type: ' || pa_debug.G_err_stack);
608: pa_cc_utils.log_message('validate_rate_type: ' || SQLERRM);
609: END IF;
610: RAISE ;
611: END validate_rate_type ;
612:

Line 641: pa_cc_utils.set_curr_function('validate_currency_code');

637:
638: l_currency_code C1%ROWTYPE;
639:
640: BEGIN
641: pa_cc_utils.set_curr_function('validate_currency_code');
642: IF P_DEBUG_MODE THEN
643: pa_cc_utils.log_message('validate_currency_code: ' || 'Start ');
644: END IF;
645:

Line 643: pa_cc_utils.log_message('validate_currency_code: ' || 'Start ');

639:
640: BEGIN
641: pa_cc_utils.set_curr_function('validate_currency_code');
642: IF P_DEBUG_MODE THEN
643: pa_cc_utils.log_message('validate_currency_code: ' || 'Start ');
644: END IF;
645:
646: If (G_PrevCurr = P_Currency_code and trunc(G_PrevEiDate) = trunc(P_EI_date)) Then
647:

Line 649: pa_cc_utils.reset_curr_function ;

645:
646: If (G_PrevCurr = P_Currency_code and trunc(G_PrevEiDate) = trunc(P_EI_date)) Then
647:
648: --Bug 2749049
649: pa_cc_utils.reset_curr_function ;
650: RETURN G_CurrValid;
651:
652: Else
653:

Line 656: pa_cc_utils.log_message('validate_currency_code: ' || 'After Open Cursor');

652: Else
653:
654: OPEN C1 ;
655: IF P_DEBUG_MODE THEN
656: pa_cc_utils.log_message('validate_currency_code: ' || 'After Open Cursor');
657: END IF;
658: FETCH C1 INTO l_currency_code ;
659: IF P_DEBUG_MODE THEN
660: pa_cc_utils.log_message('validate_currency_code: ' || 'After fetch Cursor');

Line 660: pa_cc_utils.log_message('validate_currency_code: ' || 'After fetch Cursor');

656: pa_cc_utils.log_message('validate_currency_code: ' || 'After Open Cursor');
657: END IF;
658: FETCH C1 INTO l_currency_code ;
659: IF P_DEBUG_MODE THEN
660: pa_cc_utils.log_message('validate_currency_code: ' || 'After fetch Cursor');
661: END IF;
662: IF C1%NOTFOUND THEN
663: CLOSE C1;
664: IF P_DEBUG_MODE THEN

Line 665: pa_cc_utils.log_message('validate_currency_code: ' || 'After close Cursor when currency is not valid');

661: END IF;
662: IF C1%NOTFOUND THEN
663: CLOSE C1;
664: IF P_DEBUG_MODE THEN
665: pa_cc_utils.log_message('validate_currency_code: ' || 'After close Cursor when currency is not valid');
666: END IF;
667: pa_cc_utils.reset_curr_function ;
668: G_CurrValid := 'N';
669: G_PrevCurr := P_Currency_code;

Line 667: pa_cc_utils.reset_curr_function ;

663: CLOSE C1;
664: IF P_DEBUG_MODE THEN
665: pa_cc_utils.log_message('validate_currency_code: ' || 'After close Cursor when currency is not valid');
666: END IF;
667: pa_cc_utils.reset_curr_function ;
668: G_CurrValid := 'N';
669: G_PrevCurr := P_Currency_code;
670: G_PrevEiDate := P_EI_date;
671: RETURN 'N';

Line 675: pa_cc_utils.log_message('validate_currency_code: ' || 'After close Cursor when currency is valid');

671: RETURN 'N';
672: ELSE
673: CLOSE C1;
674: IF P_DEBUG_MODE THEN
675: pa_cc_utils.log_message('validate_currency_code: ' || 'After close Cursor when currency is valid');
676: END IF;
677: pa_cc_utils.reset_curr_function ;
678: G_CurrValid := 'Y';
679: G_PrevCurr := P_Currency_code;

Line 677: pa_cc_utils.reset_curr_function ;

673: CLOSE C1;
674: IF P_DEBUG_MODE THEN
675: pa_cc_utils.log_message('validate_currency_code: ' || 'After close Cursor when currency is valid');
676: END IF;
677: pa_cc_utils.reset_curr_function ;
678: G_CurrValid := 'Y';
679: G_PrevCurr := P_Currency_code;
680: G_PrevEiDate := P_EI_date;
681: RETURN 'Y';

Line 687: pa_cc_utils.log_message('validate_currency_code: ' || 'End ');

683:
684: End If;
685:
686: IF P_DEBUG_MODE THEN
687: pa_cc_utils.log_message('validate_currency_code: ' || 'End ');
688: END IF;
689: pa_cc_utils.reset_curr_function ;
690:
691: EXCEPTION

Line 689: pa_cc_utils.reset_curr_function ;

685:
686: IF P_DEBUG_MODE THEN
687: pa_cc_utils.log_message('validate_currency_code: ' || 'End ');
688: END IF;
689: pa_cc_utils.reset_curr_function ;
690:
691: EXCEPTION
692: WHEN others THEN
693: IF P_DEBUG_MODE THEN

Line 694: pa_cc_utils.log_message('validate_currency_code: ' || pa_debug.G_err_stack);

690:
691: EXCEPTION
692: WHEN others THEN
693: IF P_DEBUG_MODE THEN
694: pa_cc_utils.log_message('validate_currency_code: ' || pa_debug.G_err_stack);
695: pa_cc_utils.log_message('validate_currency_code: ' || SQLERRM);
696: END IF;
697: --Bug 2749049
698: pa_cc_utils.reset_curr_function ;

Line 695: pa_cc_utils.log_message('validate_currency_code: ' || SQLERRM);

691: EXCEPTION
692: WHEN others THEN
693: IF P_DEBUG_MODE THEN
694: pa_cc_utils.log_message('validate_currency_code: ' || pa_debug.G_err_stack);
695: pa_cc_utils.log_message('validate_currency_code: ' || SQLERRM);
696: END IF;
697: --Bug 2749049
698: pa_cc_utils.reset_curr_function ;
699: RAISE ;

Line 698: pa_cc_utils.reset_curr_function ;

694: pa_cc_utils.log_message('validate_currency_code: ' || pa_debug.G_err_stack);
695: pa_cc_utils.log_message('validate_currency_code: ' || SQLERRM);
696: END IF;
697: --Bug 2749049
698: pa_cc_utils.reset_curr_function ;
699: RAISE ;
700: END validate_currency_code ;
701:
702:

Line 716: pa_cc_utils.set_curr_function('get_conversion_type');

712:
713: l_Rate_type pa_conversion_types_v.conversion_type%TYPE;
714:
715: BEGIN
716: pa_cc_utils.set_curr_function('get_conversion_type');
717: IF P_DEBUG_MODE THEN
718: pa_cc_utils.log_message('get_conversion_type: ' || 'Start ');
719: END IF;
720:

Line 718: pa_cc_utils.log_message('get_conversion_type: ' || 'Start ');

714:
715: BEGIN
716: pa_cc_utils.set_curr_function('get_conversion_type');
717: IF P_DEBUG_MODE THEN
718: pa_cc_utils.log_message('get_conversion_type: ' || 'Start ');
719: END IF;
720:
721: If (G_PrevUserRateType = P_user_rate_type) Then
722:

Line 723: pa_cc_utils.reset_curr_function ; /* Added for Bug 3161853 */

719: END IF;
720:
721: If (G_PrevUserRateType = P_user_rate_type) Then
722:
723: pa_cc_utils.reset_curr_function ; /* Added for Bug 3161853 */
724: RETURN G_PrevRateType;
725:
726: Else
727:

Line 730: pa_cc_utils.log_message('get_conversion_type: ' || 'After Opening Cursor');

726: Else
727:
728: OPEN C1 ;
729: IF P_DEBUG_MODE THEN
730: pa_cc_utils.log_message('get_conversion_type: ' || 'After Opening Cursor');
731: END IF;
732: FETCH C1 INTO l_Rate_type ;
733: IF P_DEBUG_MODE THEN
734: pa_cc_utils.log_message('get_conversion_type: ' || 'After Fetching Cursor');

Line 734: pa_cc_utils.log_message('get_conversion_type: ' || 'After Fetching Cursor');

730: pa_cc_utils.log_message('get_conversion_type: ' || 'After Opening Cursor');
731: END IF;
732: FETCH C1 INTO l_Rate_type ;
733: IF P_DEBUG_MODE THEN
734: pa_cc_utils.log_message('get_conversion_type: ' || 'After Fetching Cursor');
735: END IF;
736:
737: G_PrevRateType := l_Rate_type;
738: G_PrevUserRateType := P_user_rate_type;

Line 742: pa_cc_utils.log_message('get_conversion_type: ' || 'After closing Cursor');

738: G_PrevUserRateType := P_user_rate_type;
739:
740: CLOSE C1;
741: IF P_DEBUG_MODE THEN
742: pa_cc_utils.log_message('get_conversion_type: ' || 'After closing Cursor');
743: END IF;
744: pa_cc_utils.reset_curr_function ;
745: RETURN l_rate_type;
746:

Line 744: pa_cc_utils.reset_curr_function ;

740: CLOSE C1;
741: IF P_DEBUG_MODE THEN
742: pa_cc_utils.log_message('get_conversion_type: ' || 'After closing Cursor');
743: END IF;
744: pa_cc_utils.reset_curr_function ;
745: RETURN l_rate_type;
746:
747: End If;
748:

Line 750: pa_cc_utils.log_message('get_conversion_type: ' || 'End ');

746:
747: End If;
748:
749: IF P_DEBUG_MODE THEN
750: pa_cc_utils.log_message('get_conversion_type: ' || 'End ');
751: END IF;
752: pa_cc_utils.reset_curr_function ;
753:
754: EXCEPTION

Line 752: pa_cc_utils.reset_curr_function ;

748:
749: IF P_DEBUG_MODE THEN
750: pa_cc_utils.log_message('get_conversion_type: ' || 'End ');
751: END IF;
752: pa_cc_utils.reset_curr_function ;
753:
754: EXCEPTION
755: WHEN others THEN
756: IF P_DEBUG_MODE THEN

Line 757: pa_cc_utils.log_message('get_conversion_type: ' || pa_debug.G_err_stack);

753:
754: EXCEPTION
755: WHEN others THEN
756: IF P_DEBUG_MODE THEN
757: pa_cc_utils.log_message('get_conversion_type: ' || pa_debug.G_err_stack);
758: pa_cc_utils.log_message('get_conversion_type: ' || SQLERRM);
759: END IF;
760: pa_cc_utils.reset_curr_function ;
761: RETURN NULL;

Line 758: pa_cc_utils.log_message('get_conversion_type: ' || SQLERRM);

754: EXCEPTION
755: WHEN others THEN
756: IF P_DEBUG_MODE THEN
757: pa_cc_utils.log_message('get_conversion_type: ' || pa_debug.G_err_stack);
758: pa_cc_utils.log_message('get_conversion_type: ' || SQLERRM);
759: END IF;
760: pa_cc_utils.reset_curr_function ;
761: RETURN NULL;
762: END get_conversion_type ;

Line 760: pa_cc_utils.reset_curr_function ;

756: IF P_DEBUG_MODE THEN
757: pa_cc_utils.log_message('get_conversion_type: ' || pa_debug.G_err_stack);
758: pa_cc_utils.log_message('get_conversion_type: ' || SQLERRM);
759: END IF;
760: pa_cc_utils.reset_curr_function ;
761: RETURN NULL;
762: END get_conversion_type ;
763:
764:

Line 772: pa_cc_utils.set_curr_function('Init');

768: PROCEDURE init IS
769:
770: BEGIN
771:
772: pa_cc_utils.set_curr_function('Init');
773: pa_cc_utils.log_message('Start ');
774:
775: G_accounting_currency_code := get_acct_currency_code ;
776:

Line 773: pa_cc_utils.log_message('Start ');

769:
770: BEGIN
771:
772: pa_cc_utils.set_curr_function('Init');
773: pa_cc_utils.log_message('Start ');
774:
775: G_accounting_currency_code := get_acct_currency_code ;
776:
777: G_rate_date_code := check_rate_date_code ;

Line 780: pa_cc_utils.log_message('End ');

776:
777: G_rate_date_code := check_rate_date_code ;
778:
779: G_rate_type := get_rate_type ;
780: pa_cc_utils.log_message('End ');
781: pa_cc_utils.reset_curr_function ;
782:
783: END init ;
784:

Line 781: pa_cc_utils.reset_curr_function ;

777: G_rate_date_code := check_rate_date_code ;
778:
779: G_rate_type := get_rate_type ;
780: pa_cc_utils.log_message('End ');
781: pa_cc_utils.reset_curr_function ;
782:
783: END init ;
784:
785: ------------------------------------------------------------------------------