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_FP_TXN_CURRENCIES_PUB dependencies on PA_FP_CONSTANTS_PKG

Line 654: IF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN

650: pa_debug.write('Set_Default_Currencies: ' || l_module_name,pa_debug.g_err_stage,3);
651: END IF;
652:
653:
654: IF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
655:
656: IF p_srce_all_default_curr_code IS NOT NULL THEN
657:
658: l_srce_cost_default_curr_code := p_srce_all_default_curr_code;

Line 682: ELSIF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN

678: ,default_rev_curr_flag = 'N'
679: ,default_all_curr_flag = 'N'
680: WHERE proj_fp_options_id = p_target_fp_option_id ;
681:
682: ELSIF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
683:
684: IF p_srce_all_default_curr_code IS NOT NULL THEN
685:
686: l_srce_rev_default_curr_code := p_srce_all_default_curr_code;

Line 723: ELSIF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

719: ,default_rev_curr_flag = DECODE(txn_currency_code,l_srce_rev_default_curr_code,'Y','N')
720: ,default_all_curr_flag = 'N'
721: WHERE proj_fp_options_id = p_target_fp_option_id ;
722:
723: ELSIF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
724:
725: IF p_srce_cost_default_curr_code IS NOT NULL THEN
726:
727: l_srce_all_default_curr_code := p_srce_cost_default_curr_code;

Line 765: ELSIF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

761: ,default_rev_curr_flag = 'N'
762: ,default_all_curr_flag = DECODE(txn_currency_code,l_srce_all_default_curr_code,'Y','N')
763: WHERE proj_fp_options_id = p_target_fp_option_id ;
764:
765: ELSIF p_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
766:
767: IF p_srce_all_default_curr_code IS NOT NULL THEN
768:
769: l_srce_cost_default_curr_code := p_srce_all_default_curr_code;

Line 888: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

884: -- Check for business rules violations
885:
886: IF P_PA_DEBUG_MODE = 'Y' THEN
887: pa_debug.g_err_stage:= 'Validating input parameters';
888: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
889: END IF;
890:
891: --Check if plan version id is null
892:

Line 899: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

895: (p_ci_id IS NULL)
896: THEN
897: IF P_PA_DEBUG_MODE = 'Y' THEN
898: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
899: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
900: pa_debug.g_err_stage:= 'p_fin_plan_version_id = '|| p_fin_plan_version_id;
901: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
902: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
903: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 901: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

897: IF P_PA_DEBUG_MODE = 'Y' THEN
898: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
899: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
900: pa_debug.g_err_stage:= 'p_fin_plan_version_id = '|| p_fin_plan_version_id;
901: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
902: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
903: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
904: END IF;
905:

Line 903: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

899: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
900: pa_debug.g_err_stage:= 'p_fin_plan_version_id = '|| p_fin_plan_version_id;
901: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
902: pa_debug.g_err_stage:= 'p_ci_id = '|| p_ci_id;
903: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
904: END IF;
905:
906: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
907: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 909: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

905:
906: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
907: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
908:
909: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
910: END IF;
911:
912: -- Using the project_id and ci_id fetch the agreement_currency
913:

Line 916: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

912: -- Using the project_id and ci_id fetch the agreement_currency
913:
914: IF P_PA_DEBUG_MODE = 'Y' THEN
915: pa_debug.g_err_stage:='Fetching the agreement details';
916: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
917: END IF;
918:
919: Pa_Fp_Control_Items_Utils.get_fp_ci_agreement_dtls(
920: p_project_id => p_project_id

Line 934: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

930: (l_return_status <> FND_API.G_RET_STS_SUCCESS)
931: THEN
932: IF P_PA_DEBUG_MODE = 'Y' THEN
933: pa_debug.g_err_stage:='Agreement_currency_code is null';
934: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
935: END IF;
936: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
937: END IF;
938:

Line 936: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

932: IF P_PA_DEBUG_MODE = 'Y' THEN
933: pa_debug.g_err_stage:='Agreement_currency_code is null';
934: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
935: END IF;
936: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
937: END IF;
938:
939: -- Get the required details of the fin plan version from the fp options table
940:

Line 943: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

939: -- Get the required details of the fin plan version from the fp options table
940:
941: IF P_PA_DEBUG_MODE = 'Y' THEN
942: pa_debug.g_err_stage:='Fetching the version details';
943: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
944: END IF;
945:
946: OPEN version_details_cur;
947: FETCH version_details_cur INTO version_details_rec;

Line 970: pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

966:
967: IF P_PA_DEBUG_MODE = 'Y' THEN
968: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
969: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,
970: pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
971: END IF;
972: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
973: END IF;
974:

Line 972: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

968: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
969: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,
970: pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
971: END IF;
972: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
973: END IF;
974:
975: END IF;
976:

Line 1036: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1032: FROM DUAL;
1033:
1034: IF P_PA_DEBUG_MODE = 'Y' THEN
1035: pa_debug.g_err_stage:= 'Exiting enter_agreement_curr_for_ci';
1036: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1037: END IF;
1038: pa_debug.reset_err_stack;
1039:
1040: EXCEPTION

Line 1042: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1038: pa_debug.reset_err_stack;
1039:
1040: EXCEPTION
1041:
1042: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1043:
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: l_msg_count := FND_MSG_PUB.count_msg;
1046: IF l_msg_count = 1 THEN

Line 1062: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1058: END IF;
1059:
1060: IF P_PA_DEBUG_MODE = 'Y' THEN
1061: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
1062: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1063: END IF;
1064: pa_debug.reset_err_stack;
1065: RAISE;
1066:

Line 1076: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

1072: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_txn_currencies_pub'
1073: ,p_procedure_name => 'enter_agreement_curr_for_ci');
1074: IF P_PA_DEBUG_MODE = 'Y' THEN
1075: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
1076: pa_debug.write('enter_agreement_curr_for_ci: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1077: END IF;
1078: pa_debug.reset_err_stack;
1079: RAISE;
1080: END enter_agreement_curr_for_ci;

Line 1110: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1106: BEGIN
1107:
1108: IF P_PA_DEBUG_MODE = 'Y' THEN
1109: pa_debug.g_err_stage:='In Insert_Only_Projfunc_Curr';
1110: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1111: END IF;
1112:
1113: l_insert_only_proj_func_curr := FALSE;
1114:

Line 1120: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1116: -- Getting the Proj FP Option details for the Proj FP Option ID.
1117:
1118: IF P_PA_DEBUG_MODE = 'Y' THEN
1119: pa_debug.g_err_stage:='Getting the FP Option details';
1120: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1121: END IF;
1122:
1123: SELECT fin_plan_option_level_code
1124: ,fin_plan_preference_code

Line 1134: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1130: WHERE proj_fp_options_id = p_proj_fp_options_id;
1131:
1132: IF P_PA_DEBUG_MODE = 'Y' THEN
1133: pa_debug.g_err_stage:='Approved Revenue Flag is Y';
1134: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1135: END IF;
1136:
1137: IF l_approved_rev_plan_type_flag = 'Y' AND
1138: (l_planning_level IN (PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,

Line 1138: (l_planning_level IN (PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,

1134: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1135: END IF;
1136:
1137: IF l_approved_rev_plan_type_flag = 'Y' AND
1138: (l_planning_level IN (PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,
1139: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION)) AND
1140: (l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,
1141: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)) THEN
1142:

Line 1139: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION)) AND

1135: END IF;
1136:
1137: IF l_approved_rev_plan_type_flag = 'Y' AND
1138: (l_planning_level IN (PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,
1139: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION)) AND
1140: (l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,
1141: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)) THEN
1142:
1143: -- Approved Rev Plan Type Flag is Y

Line 1140: (l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,

1136:
1137: IF l_approved_rev_plan_type_flag = 'Y' AND
1138: (l_planning_level IN (PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,
1139: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION)) AND
1140: (l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,
1141: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)) THEN
1142:
1143: -- Approved Rev Plan Type Flag is Y
1144: -- Planning Level is Plan Type/Plan Version,

Line 1141: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)) THEN

1137: IF l_approved_rev_plan_type_flag = 'Y' AND
1138: (l_planning_level IN (PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,
1139: PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION)) AND
1140: (l_fp_preference_code IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME,
1141: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY)) THEN
1142:
1143: -- Approved Rev Plan Type Flag is Y
1144: -- Planning Level is Plan Type/Plan Version,
1145: -- Fin Plan Preference code is Cost_And_Rev_Same/Revenue_Only.

Line 1150: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

1146: -- For all the above conditions, set the l_insert_only_proj_func_curr as TRUE
1147:
1148: IF P_PA_DEBUG_MODE = 'Y' THEN
1149: pa_debug.g_err_stage:='Setting the l_insert_only_proj_func_curr as TRUE';
1150: pa_debug.write('Insert_Only_Projfunc_Curr: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1151: END IF;
1152:
1153: l_insert_only_proj_func_curr := TRUE;
1154: