DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_MULTI_CURRENCY

Line 611: pa_debug.G_err_Stage := 'call to pa_multi_currency.init';

607: IS
608: BEGIN
609: pa_cc_utils.set_curr_function('GetImpCurrInfo');
610: IF PG_DEBUG = 'Y' THEN
611: pa_debug.G_err_Stage := 'call to pa_multi_currency.init';
612: log_message('log_message: ' || pa_debug.G_err_Stage);
613: END IF;
614:
615: pa_multi_currency.init;

Line 615: pa_multi_currency.init;

611: pa_debug.G_err_Stage := 'call to pa_multi_currency.init';
612: log_message('log_message: ' || pa_debug.G_err_Stage);
613: END IF;
614:
615: pa_multi_currency.init;
616:
617: IF PG_DEBUG = 'Y' THEN
618: pa_debug.G_err_stage := 'Assigning currency code and rate type to local variables';
619: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 621: G_accounting_currency_code := pa_multi_currency.G_accounting_currency_code;

617: IF PG_DEBUG = 'Y' THEN
618: pa_debug.G_err_stage := 'Assigning currency code and rate type to local variables';
619: log_message('log_message: ' || pa_debug.G_err_Stage);
620: END IF;
621: G_accounting_currency_code := pa_multi_currency.G_accounting_currency_code;
622: G_default_rate_type := pa_multi_currency.G_rate_type;
623:
624: IF PG_DEBUG = 'Y' THEN
625: pa_debug.G_err_Stage := 'Before calling pa_cc_utils.reset_curr_function';

Line 622: G_default_rate_type := pa_multi_currency.G_rate_type;

618: pa_debug.G_err_stage := 'Assigning currency code and rate type to local variables';
619: log_message('log_message: ' || pa_debug.G_err_Stage);
620: END IF;
621: G_accounting_currency_code := pa_multi_currency.G_accounting_currency_code;
622: G_default_rate_type := pa_multi_currency.G_rate_type;
623:
624: IF PG_DEBUG = 'Y' THEN
625: pa_debug.G_err_Stage := 'Before calling pa_cc_utils.reset_curr_function';
626: log_message('log_message: ' || pa_debug.G_err_Stage);

Line 685: log_message('log_message: Calling pa_multi_currency_txn.get_proj_rate_type');

681:
682: IF PG_DEBUG = 'Y' THEN
683: pa_debug.G_err_stage := 'Selecting Values';
684: log_message('log_message: ' || pa_debug.G_err_Stage);
685: log_message('log_message: Calling pa_multi_currency_txn.get_proj_rate_type');
686: END IF;
687:
688: -- PA-I Changes : The API get_project_rate_type has been renamed to get_proj_rate_type
689: pa_multi_currency_txn.get_proj_rate_type(P_task_id => X_task_id,

Line 689: pa_multi_currency_txn.get_proj_rate_type(P_task_id => X_task_id,

685: log_message('log_message: Calling pa_multi_currency_txn.get_proj_rate_type');
686: END IF;
687:
688: -- PA-I Changes : The API get_project_rate_type has been renamed to get_proj_rate_type
689: pa_multi_currency_txn.get_proj_rate_type(P_task_id => X_task_id,
690: P_project_currency_code => X_project_currency_code,
691: P_project_rate_type => X_project_rate_type);
692:
693: IF PG_DEBUG = 'Y' THEN

Line 694: log_message('log_message: After Calling pa_multi_currency_txn.get_proj_rate_type');

690: P_project_currency_code => X_project_currency_code,
691: P_project_rate_type => X_project_rate_type);
692:
693: IF PG_DEBUG = 'Y' THEN
694: log_message('log_message: After Calling pa_multi_currency_txn.get_proj_rate_type');
695: pa_debug.G_err_stage := 'Calling pa_multi_currency_txn.get_projfunc_cost_rate_type';
696: log_message('log_message: ' || pa_debug.G_err_Stage);
697: END IF;
698:

Line 695: pa_debug.G_err_stage := 'Calling pa_multi_currency_txn.get_projfunc_cost_rate_type';

691: P_project_rate_type => X_project_rate_type);
692:
693: IF PG_DEBUG = 'Y' THEN
694: log_message('log_message: After Calling pa_multi_currency_txn.get_proj_rate_type');
695: pa_debug.G_err_stage := 'Calling pa_multi_currency_txn.get_projfunc_cost_rate_type';
696: log_message('log_message: ' || pa_debug.G_err_Stage);
697: END IF;
698:
699: -- PA-I Changes : Calling API to get Proj Functional Currency Code only

Line 700: pa_multi_currency_txn.get_projfunc_cost_rate_type(P_task_id => X_task_id,

696: log_message('log_message: ' || pa_debug.G_err_Stage);
697: END IF;
698:
699: -- PA-I Changes : Calling API to get Proj Functional Currency Code only
700: pa_multi_currency_txn.get_projfunc_cost_rate_type(P_task_id => X_task_id,
701: P_projfunc_currency_code => X_projfunc_currency_code,
702: P_projfunc_cost_rate_type => X_projfunc_cost_rate_type);
703: IF PG_DEBUG = 'Y' THEN
704: pa_debug.G_err_stage := 'After Calling get_projfunc_rate_type';

Line 764: performed during costing in pa_multi_currency_txn. To avoid redundant code

760:
761: /* PA-I Changes
762: For un-accounted transactions we need not call DefaultCurrAttributes.
763: This is because the checks that are being performed here will be anyway
764: performed during costing in pa_multi_currency_txn. To avoid redundant code
765: we are not performing these checks in PA_TRX_IMPORT.
766: Please see prior versions for the changed DefaultCurrAttributes if needed.
767: */
768:

Line 3161: pa_debug.G_err_stage := 'Calling pa_multi_currency.validate_currency_code';

3157:
3158: ELSE -- X_denom_currency_code IS NOT NULL
3159:
3160: IF PG_DEBUG = 'Y' THEN
3161: pa_debug.G_err_stage := 'Calling pa_multi_currency.validate_currency_code';
3162: log_message('log_message: ' || pa_debug.G_err_Stage);
3163: END IF;
3164: IF (pa_multi_currency.validate_currency_code(
3165: P_currency_code =>X_denom_currency_code,

Line 3164: IF (pa_multi_currency.validate_currency_code(

3160: IF PG_DEBUG = 'Y' THEN
3161: pa_debug.G_err_stage := 'Calling pa_multi_currency.validate_currency_code';
3162: log_message('log_message: ' || pa_debug.G_err_Stage);
3163: END IF;
3164: IF (pa_multi_currency.validate_currency_code(
3165: P_currency_code =>X_denom_currency_code,
3166: P_ei_date =>X_ei_date)= 'N')
3167: THEN
3168:

Line 3236: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';

3232:
3233: Else
3234:
3235: IF PG_DEBUG = 'Y' THEN
3236: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';
3237: log_message('log_message: ' || pa_debug.G_err_Stage);
3238: END IF;
3239: G_acct_rate_type := pa_multi_currency.get_conversion_type(
3240: P_user_rate_type => X_acct_rate_type);

Line 3239: G_acct_rate_type := pa_multi_currency.get_conversion_type(

3235: IF PG_DEBUG = 'Y' THEN
3236: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';
3237: log_message('log_message: ' || pa_debug.G_err_Stage);
3238: END IF;
3239: G_acct_rate_type := pa_multi_currency.get_conversion_type(
3240: P_user_rate_type => X_acct_rate_type);
3241:
3242: End If;
3243:

Line 3267: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';

3263:
3264: --Corrected Fix for Bug 2489534
3265: If (nvl(X_module, 'EXTERNAL') <> 'PAAPIMP') Then
3266: IF PG_DEBUG = 'Y' THEN
3267: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';
3268: log_message('log_message: ' || pa_debug.G_err_Stage);
3269: END IF;
3270: G_project_rate_type := pa_multi_currency.get_conversion_type(
3271: P_user_rate_type => X_project_rate_type);

Line 3270: G_project_rate_type := pa_multi_currency.get_conversion_type(

3266: IF PG_DEBUG = 'Y' THEN
3267: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';
3268: log_message('log_message: ' || pa_debug.G_err_Stage);
3269: END IF;
3270: G_project_rate_type := pa_multi_currency.get_conversion_type(
3271: P_user_rate_type => X_project_rate_type);
3272: Else
3273: G_project_rate_type := X_project_rate_type;
3274: End If;

Line 3299: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';

3295:
3296: --Corrected Fix for Bug 2489534
3297: If (nvl(X_module, 'EXTERNAL') <> 'PAAPIMP') Then
3298: IF PG_DEBUG = 'Y' THEN
3299: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';
3300: log_message('log_message: ' || pa_debug.G_err_Stage);
3301: END IF;
3302: G_projfunc_cost_rate_type := pa_multi_currency.get_conversion_type(
3303: P_user_rate_type => X_projfunc_cost_rate_type);

Line 3302: G_projfunc_cost_rate_type := pa_multi_currency.get_conversion_type(

3298: IF PG_DEBUG = 'Y' THEN
3299: pa_debug.G_err_stage := 'Calling pa_multi_currency.get_conversion_type';
3300: log_message('log_message: ' || pa_debug.G_err_Stage);
3301: END IF;
3302: G_projfunc_cost_rate_type := pa_multi_currency.get_conversion_type(
3303: P_user_rate_type => X_projfunc_cost_rate_type);
3304: Else
3305: G_projfunc_cost_rate_type := X_projfunc_cost_rate_type;
3306: End If;

Line 3329: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';

3325: IF (( G_acct_rate_type = 'User' ) and (X_denom_currency_code <> G_accounting_currency_code) ) THEN
3326:
3327: -- check if rate type 'User' is allowed
3328: IF PG_DEBUG = 'Y' THEN
3329: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';
3330: log_message('log_message: ' || pa_debug.G_err_Stage);
3331: END IF;
3332: IF ( pa_multi_currency.is_user_rate_type_allowed(
3333: P_from_currency => X_denom_currency_code,

Line 3332: IF ( pa_multi_currency.is_user_rate_type_allowed(

3328: IF PG_DEBUG = 'Y' THEN
3329: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';
3330: log_message('log_message: ' || pa_debug.G_err_Stage);
3331: END IF;
3332: IF ( pa_multi_currency.is_user_rate_type_allowed(
3333: P_from_currency => X_denom_currency_code,
3334: P_to_currency => G_accounting_currency_code,
3335: P_conversion_date => nvl(X_acct_rate_date,sysdate))='N')
3336: THEN

Line 3364: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';

3360: -- Added below for Bug 16451280
3361: IF (( G_project_rate_type = 'User' ) and (X_denom_currency_code <> X_project_currency_code) ) THEN
3362:
3363: IF PG_DEBUG = 'Y' THEN
3364: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';
3365: log_message('log_message: ' || pa_debug.G_err_Stage);
3366: END IF;
3367: IF ( pa_multi_currency.is_user_rate_type_allowed(
3368: P_from_currency => X_denom_currency_code,

Line 3367: IF ( pa_multi_currency.is_user_rate_type_allowed(

3363: IF PG_DEBUG = 'Y' THEN
3364: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';
3365: log_message('log_message: ' || pa_debug.G_err_Stage);
3366: END IF;
3367: IF ( pa_multi_currency.is_user_rate_type_allowed(
3368: P_from_currency => X_denom_currency_code,
3369: P_to_currency => X_project_currency_code,
3370: P_conversion_date => nvl(X_project_rate_date,sysdate))='N')
3371: THEN

Line 3396: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';

3392:
3393: IF ( ( G_projfunc_cost_rate_type = 'User' ) and (X_denom_currency_code <> X_projfunc_currency_code) ) THEN
3394:
3395: IF PG_DEBUG = 'Y' THEN
3396: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';
3397: log_message('log_message: ' || pa_debug.G_err_Stage);
3398: END IF;
3399: IF ( pa_multi_currency.is_user_rate_type_allowed(
3400: P_from_currency => X_denom_currency_code,

Line 3399: IF ( pa_multi_currency.is_user_rate_type_allowed(

3395: IF PG_DEBUG = 'Y' THEN
3396: pa_debug.G_err_stage := 'Calling pa_multi_currency.is_user_rate_type_allowed';
3397: log_message('log_message: ' || pa_debug.G_err_Stage);
3398: END IF;
3399: IF ( pa_multi_currency.is_user_rate_type_allowed(
3400: P_from_currency => X_denom_currency_code,
3401: P_to_currency => X_projfunc_currency_code,
3402: P_conversion_date => nvl(X_projfunc_cost_rate_date,sysdate))='N')
3403: THEN

Line 3474: pa_debug.G_err_stage := 'Calling pa_multi_currency.validate_currency_code';

3470:
3471: IF ( X_receipt_currency_code IS NOT NULL ) THEN
3472:
3473: IF PG_DEBUG = 'Y' THEN
3474: pa_debug.G_err_stage := 'Calling pa_multi_currency.validate_currency_code';
3475: log_message('log_message: ' || pa_debug.G_err_Stage);
3476: END IF;
3477: IF (pa_multi_currency.validate_currency_code(
3478: P_currency_code =>X_receipt_currency_code,

Line 3477: IF (pa_multi_currency.validate_currency_code(

3473: IF PG_DEBUG = 'Y' THEN
3474: pa_debug.G_err_stage := 'Calling pa_multi_currency.validate_currency_code';
3475: log_message('log_message: ' || pa_debug.G_err_Stage);
3476: END IF;
3477: IF (pa_multi_currency.validate_currency_code(
3478: P_currency_code =>X_receipt_currency_code,
3479: P_ei_date => X_ei_date)= 'N')
3480: THEN
3481:

Line 3538: performed during costing in pa_multi_currency_txn. To avoid redundant code

3534: -----------------------------------------------------------------------------*/
3535: /* PA-I Changes
3536: For un-accounted transactions we need not call DefaultCurrAttributes.
3537: This is because the checks that are being performed here will be anyway
3538: performed during costing in pa_multi_currency_txn. To avoid redundant code
3539: we are not performing these checks in PA_TRX_IMPORT.
3540: */
3541:
3542: /*-----------------------------------------------------------------------------

Line 3638: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount';

3634: l_acct_exchange_rate := X_acct_exchange_rate;
3635: l_acct_raw_cost := X_acct_raw_cost;
3636:
3637: IF PG_DEBUG = 'Y' THEN
3638: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount';
3639: log_message('log_message: ' || pa_debug.G_err_Stage);
3640: END IF;
3641:
3642: pa_multi_currency.convert_amount(

Line 3642: pa_multi_currency.convert_amount(

3638: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount';
3639: log_message('log_message: ' || pa_debug.G_err_Stage);
3640: END IF;
3641:
3642: pa_multi_currency.convert_amount(
3643: P_from_currency => X_denom_currency_code,
3644: P_to_currency => G_accounting_currency_code,
3645: P_conversion_date => l_acct_rate_date,
3646: P_conversion_type => l_acct_rate_type,

Line 3707: pa_debug.G_err_stage := 'Calling pa_multi_currency.round_trans_currency_amt';

3703: -- If functional and transaction currencies are same the the
3704: -- corresponding amounts should also be equal
3705: --
3706: IF PG_DEBUG = 'Y' THEN
3707: pa_debug.G_err_stage := 'Calling pa_multi_currency.round_trans_currency_amt';
3708: log_message('log_message: ' || pa_debug.G_err_Stage);
3709: END IF;
3710:
3711:

Line 3746: -- the G_gl_accted_flag to pa_multi_currency_txn package, the

3742: -- for accounted transactions. For accounted transactions
3743: -- the EI's are created with cost_distributed_flag='Y', so
3744: -- the the costing program cannot pick up these records
3745: -- to calculate the project currency costs. Here we are passing
3746: -- the G_gl_accted_flag to pa_multi_currency_txn package, the
3747: -- package will calculate the project cost if the gl_accted_flag
3748: -- is 'Y'.
3749: --
3750: -- initilize the local variables before passing them to

Line 3761: pa_debug.G_err_stage := 'Calling pa_multi_currency_txn.get_currency_amounts';

3757:
3758: BEGIN
3759:
3760: IF PG_DEBUG = 'Y' THEN
3761: pa_debug.G_err_stage := 'Calling pa_multi_currency_txn.get_currency_amounts';
3762: log_message('log_message: ' || pa_debug.G_err_Stage);
3763: END IF;
3764: pa_multi_currency_txn.get_currency_amounts(
3765: P_task_id => G_task_id,

Line 3764: pa_multi_currency_txn.get_currency_amounts(

3760: IF PG_DEBUG = 'Y' THEN
3761: pa_debug.G_err_stage := 'Calling pa_multi_currency_txn.get_currency_amounts';
3762: log_message('log_message: ' || pa_debug.G_err_Stage);
3763: END IF;
3764: pa_multi_currency_txn.get_currency_amounts(
3765: P_task_id => G_task_id,
3766: P_ei_date => X_ei_date,
3767: P_denom_raw_cost => X_denom_raw_cost,
3768: P_denom_curr_code => X_denom_currency_code,

Line 3796: the pa_multi_currency_txn pkg.

3792: X_actual_project_raw_cost := pa_currency.round_trans_currency_amt1(X_actual_project_raw_cost,X_project_currency_code); -- Bug 8621083 / 8595274
3793:
3794: /***************PA-I changes************************
3795: Commenting the exception section as the exceptions are already handled in
3796: the pa_multi_currency_txn pkg.
3797: ****************************************************/
3798:
3799: END; -- end calculate project raw cost
3800:

Line 4286: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for functional currency';

4282: -- initilize l_status
4283: l_status := NULL;
4284:
4285: IF PG_DEBUG = 'Y' THEN
4286: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for functional currency';
4287: log_message('log_message: ' || pa_debug.G_err_Stage);
4288: END IF;
4289: pa_multi_currency.convert_amount(
4290: P_from_currency => X_denom_currency_code,

Line 4289: pa_multi_currency.convert_amount(

4285: IF PG_DEBUG = 'Y' THEN
4286: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for functional currency';
4287: log_message('log_message: ' || pa_debug.G_err_Stage);
4288: END IF;
4289: pa_multi_currency.convert_amount(
4290: P_from_currency => X_denom_currency_code,
4291: P_to_currency => G_accounting_currency_code,
4292: P_conversion_date => X_acct_rate_date,
4293: P_conversion_type => G_acct_rate_type,

Line 4317: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for project currency';

4313:
4314: l_status := NULL;
4315:
4316: IF PG_DEBUG = 'Y' THEN
4317: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for project currency';
4318: log_message('log_message: ' || pa_debug.G_err_Stage);
4319: END IF;
4320: pa_multi_currency.convert_amount(
4321: P_from_currency => X_denom_currency_code,

Line 4320: pa_multi_currency.convert_amount(

4316: IF PG_DEBUG = 'Y' THEN
4317: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for project currency';
4318: log_message('log_message: ' || pa_debug.G_err_Stage);
4319: END IF;
4320: pa_multi_currency.convert_amount(
4321: P_from_currency => X_denom_currency_code,
4322: P_to_currency => X_project_currency_code,
4323: P_conversion_date => X_project_rate_date,
4324: P_conversion_type => G_project_rate_type,

Line 4349: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for project functional currency';

4345:
4346: l_status := NULL;
4347:
4348: IF PG_DEBUG = 'Y' THEN
4349: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for project functional currency';
4350: log_message('log_message: ' || pa_debug.G_err_Stage);
4351: END IF;
4352: pa_multi_currency.convert_amount(
4353: P_from_currency => X_denom_currency_code,

Line 4352: pa_multi_currency.convert_amount(

4348: IF PG_DEBUG = 'Y' THEN
4349: pa_debug.G_err_stage := 'Calling pa_multi_currency.convert_amount for project functional currency';
4350: log_message('log_message: ' || pa_debug.G_err_Stage);
4351: END IF;
4352: pa_multi_currency.convert_amount(
4353: P_from_currency => X_denom_currency_code,
4354: P_to_currency => X_projfunc_currency_code,
4355: P_conversion_date => X_projfunc_cost_rate_date,
4356: P_conversion_type => G_projfunc_cost_rate_type,

Line 7134: l_acct_rate_type := pa_multi_currency.get_rate_type;

7130: IF ( (current_system_linkage = 'ER') and
7131: (p_denom_currency_code <> p_acct_currency_code) ) THEN
7132:
7133: if (p_acct_rate_type is null) then
7134: l_acct_rate_type := pa_multi_currency.get_rate_type;
7135: else
7136: l_acct_rate_type := p_acct_rate_type;
7137: end if;
7138:

Line 7140: pa_multi_currency_txn.get_acct_rate_date(

7136: l_acct_rate_type := p_acct_rate_type;
7137: end if;
7138:
7139: if (p_acct_rate_date is null) then
7140: pa_multi_currency_txn.get_acct_rate_date(
7141: P_EI_date => ending_date,
7142: P_acct_rate_date => l_acct_rate_date);
7143: else
7144: l_acct_rate_date := p_acct_rate_date;