[Home] [Help]
1239: IF NOT l_is_overridable
1240: THEN
1241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1242: THEN
1243: FND_MESSAGE.SET_NAME('PA','PA_DESCRIPTION_NOT_OVERRIDABLE');
1244: FND_MSG_PUB.add;
1245: END IF;
1246:
1247: p_project_out.return_status := FND_API.G_RET_STS_ERROR;
2767: -- Project Currency related attributes
2768: IF l_project_in_rec.PROJECT_BIL_RATE_TYPE is NULL
2769: OR l_project_in_rec.PROJECT_BIL_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_PROJ_RATE_TYPE_INV_AMG:The project exchage rate type is invalid
2770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2771: FND_MESSAGE.SET_NAME('PA','PA_PROJ_RATE_TYPE_INV_AMG');
2772: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
2773: FND_MSG_PUB.ADD;
2774: RAISE FND_API.G_EXC_ERROR;
2775: END IF;
2768: IF l_project_in_rec.PROJECT_BIL_RATE_TYPE is NULL
2769: OR l_project_in_rec.PROJECT_BIL_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_PROJ_RATE_TYPE_INV_AMG:The project exchage rate type is invalid
2770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2771: FND_MESSAGE.SET_NAME('PA','PA_PROJ_RATE_TYPE_INV_AMG');
2772: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
2773: FND_MSG_PUB.ADD;
2774: RAISE FND_API.G_EXC_ERROR;
2775: END IF;
2776: ELSE
2777: IF l_project_in_rec.PROJECT_BIL_RATE_TYPE = 'User' THEN
2778: IF l_project_in_rec.PROJECT_BIL_EXCHANGE_RATE is NULL
2779: OR l_project_in_rec.PROJECT_BIL_EXCHANGE_RATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- PA_EXCH_RATE_NULL_PC_AMG:Project Exchange Rate cannot be null when project rate type is User.
2781: FND_MESSAGE.SET_NAME('PA','PA_EXCH_RATE_NULL_PC_AMG');
2782: FND_MSG_PUB.ADD;
2783: RAISE FND_API.G_EXC_ERROR;
2784: END IF;
2785: END IF;
2787: IF l_project_in_rec.PROJECT_BIL_RATE_DATE_CODE is NULL
2788: OR l_project_in_rec.PROJECT_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2789:
2790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2791: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
2792: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
2793: FND_MSG_PUB.ADD;
2794: RAISE FND_API.G_EXC_ERROR;
2795: END IF;
2788: OR l_project_in_rec.PROJECT_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2789:
2790: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2791: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
2792: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
2793: FND_MSG_PUB.ADD;
2794: RAISE FND_API.G_EXC_ERROR;
2795: END IF;
2796: ELSE
2797: IF l_project_in_rec.PROJECT_BIL_RATE_DATE_CODE = 'FIXED_DATE' THEN --Modified for bug 6332591
2798: IF l_project_in_rec.PROJECT_BIL_RATE_DATE is NULL
2799: OR l_project_in_rec.PROJECT_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2801: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
2802: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
2803: FND_MSG_PUB.ADD;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END IF;
2798: IF l_project_in_rec.PROJECT_BIL_RATE_DATE is NULL
2799: OR l_project_in_rec.PROJECT_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2801: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
2802: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
2803: FND_MSG_PUB.ADD;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END IF;
2806: END IF;
2812: -- Project Functional Currency related attributes
2813: IF l_project_in_rec.PROJFUNC_BIL_RATE_TYPE is NULL
2814: OR l_project_in_rec.PROJFUNC_BIL_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_PFC_RATE_TYPE_INV_AMG:The project functional exchage rate type is invalid
2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2816: FND_MESSAGE.SET_NAME('PA','PA_PFC_RATE_TYPE_INV_AMG');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_ERROR;
2819: END IF;
2820: ELSE
2821: IF l_project_in_rec.PROJFUNC_BIL_RATE_TYPE = 'User' THEN
2822: IF l_project_in_rec.PROJFUNC_BIL_EXCHANGE_RATE is NULL
2823: OR l_project_in_rec.PROJFUNC_BIL_EXCHANGE_RATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- PA_EXCH_RATE_NULL_PF_AMG:Project Functional Exchange Rate cannot be null when project functional rate type is User.
2825: FND_MESSAGE.SET_NAME('PA','PA_EXCH_RATE_NULL_PF_AMG');
2826: FND_MSG_PUB.ADD;
2827: RAISE FND_API.G_EXC_ERROR;
2828: END IF;
2829: END IF;
2831: ELSE -- non-User type
2832: IF l_project_in_rec.PROJFUNC_BIL_RATE_DATE_CODE is NULL
2833: OR l_project_in_rec.PROJFUNC_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2835: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
2836: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
2837: FND_MSG_PUB.ADD;
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2832: IF l_project_in_rec.PROJFUNC_BIL_RATE_DATE_CODE is NULL
2833: OR l_project_in_rec.PROJFUNC_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2835: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
2836: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
2837: FND_MSG_PUB.ADD;
2838: RAISE FND_API.G_EXC_ERROR;
2839: END IF;
2840: ELSE
2841: IF l_project_in_rec.PROJFUNC_BIL_RATE_DATE_CODE = 'FIXED_DATE' THEN --Modified for bug 6332591
2842: IF l_project_in_rec.PROJFUNC_BIL_RATE_DATE is NULL
2843: OR l_project_in_rec.PROJFUNC_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2845: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
2846: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
2847: FND_MSG_PUB.ADD;
2848: RAISE FND_API.G_EXC_ERROR;
2849: END IF;
2842: IF l_project_in_rec.PROJFUNC_BIL_RATE_DATE is NULL
2843: OR l_project_in_rec.PROJFUNC_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2845: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
2846: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
2847: FND_MSG_PUB.ADD;
2848: RAISE FND_API.G_EXC_ERROR;
2849: END IF;
2850: END IF;
2857: -- Funding Currency related attributes
2858: IF l_project_in_rec.FUNDING_RATE_TYPE is NULL
2859: OR l_project_in_rec.FUNDING_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_FUND_RATE_TYPE_INV_AMG:The funding exchage rate type is invalid
2860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2861: FND_MESSAGE.SET_NAME('PA','PA_FUND_RATE_TYPE_INV_AMG');
2862: FND_MSG_PUB.ADD;
2863: RAISE FND_API.G_EXC_ERROR;
2864: END IF;
2865: ELSE
2866: IF l_project_in_rec.FUNDING_RATE_TYPE = 'User' THEN
2867: IF l_project_in_rec.FUNDING_EXCHANGE_RATE is NULL
2868: OR l_project_in_rec.FUNDING_EXCHANGE_RATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
2869: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- PA_EXCHANGE_RATE_NULL:Exchange rate cannot be null when rate type is User.
2870: FND_MESSAGE.SET_NAME('PA','PA_EXCHANGE_RATE_NULL');
2871: FND_MSG_PUB.ADD;
2872: RAISE FND_API.G_EXC_ERROR;
2873: END IF;
2874: END IF;
2876: ELSE -- non-User type
2877: IF l_project_in_rec.FUNDING_RATE_DATE_CODE is NULL
2878: OR l_project_in_rec.FUNDING_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2880: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
2881: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2877: IF l_project_in_rec.FUNDING_RATE_DATE_CODE is NULL
2878: OR l_project_in_rec.FUNDING_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2880: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
2881: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
2882: FND_MSG_PUB.ADD;
2883: RAISE FND_API.G_EXC_ERROR;
2884: END IF;
2885: ELSE
2886: IF l_project_in_rec.FUNDING_RATE_DATE_CODE = 'FIXED_DATE' THEN --Modified for bug 6332591
2887: IF l_project_in_rec.FUNDING_RATE_DATE is NULL
2888: OR l_project_in_rec.FUNDING_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2890: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
2891: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
2892: FND_MSG_PUB.ADD;
2893: RAISE FND_API.G_EXC_ERROR;
2894: END IF;
2887: IF l_project_in_rec.FUNDING_RATE_DATE is NULL
2888: OR l_project_in_rec.FUNDING_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
2889: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2890: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
2891: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
2892: FND_MSG_PUB.ADD;
2893: RAISE FND_API.G_EXC_ERROR;
2894: END IF;
2895: END IF;
3380: pa_interface_utils_pub.map_new_amg_msg('PA_COPY_PROJECT_FAILED','CHANGE','N',
3381: 'PROJ',l_project_in_rec.pm_project_reference,
3382: '','','','');
3383: /* Added the following code for bug 3725338 */
3384: FND_MESSAGE.SET_NAME('PA','PA_UNEXPECTED_ERR_AMG');
3385: FND_MESSAGE.SET_TOKEN('ORAERR', l_err_stage);
3386: FND_MSG_PUB.add;
3387: /* Code addition ended for bug 3725338 */
3388: END IF;
3381: 'PROJ',l_project_in_rec.pm_project_reference,
3382: '','','','');
3383: /* Added the following code for bug 3725338 */
3384: FND_MESSAGE.SET_NAME('PA','PA_UNEXPECTED_ERR_AMG');
3385: FND_MESSAGE.SET_TOKEN('ORAERR', l_err_stage);
3386: FND_MSG_PUB.add;
3387: /* Code addition ended for bug 3725338 */
3388: END IF;
3389:
14165: -- if attempting to change MCB flag; check if it can be allowed
14166: IF NVL(pa_multi_currency_billing.check_mcb_trans_exist(p_project_in.pa_project_id),'N') = 'Y'
14167: OR NVL(pa_multi_currency_billing.check_mcb_setup_exists(p_project_in.pa_project_id),'N') = 'Y' THEN
14168: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14169: FND_MESSAGE.SET_NAME('PA','PA_MCB_ALLOW_NO_CHG_AMG'); -- Cannot change MCB flag
14170: FND_MSG_PUB.ADD;
14171: RAISE FND_API.G_EXC_ERROR;
14172: END IF;
14173:
14185: -- Project Currency related attributes
14186: IF p_project_in.PROJECT_BIL_RATE_TYPE is NULL
14187: OR p_project_in.PROJECT_BIL_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_PROJ_RATE_TYPE_INV_AMG:The project exchage rate type is invalid
14188: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14189: FND_MESSAGE.SET_NAME('PA','PA_PROJ_RATE_TYPE_INV_AMG');
14190: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
14191: FND_MSG_PUB.ADD;
14192: RAISE FND_API.G_EXC_ERROR;
14193: END IF;
14186: IF p_project_in.PROJECT_BIL_RATE_TYPE is NULL
14187: OR p_project_in.PROJECT_BIL_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_PROJ_RATE_TYPE_INV_AMG:The project exchage rate type is invalid
14188: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14189: FND_MESSAGE.SET_NAME('PA','PA_PROJ_RATE_TYPE_INV_AMG');
14190: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
14191: FND_MSG_PUB.ADD;
14192: RAISE FND_API.G_EXC_ERROR;
14193: END IF;
14194: ELSE
14195: IF p_project_in.PROJECT_BIL_RATE_TYPE = 'User' THEN
14196: IF p_project_in.PROJECT_BIL_EXCHANGE_RATE is NULL
14197: OR p_project_in.PROJECT_BIL_EXCHANGE_RATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- PA_EXCH_RATE_NULL_PC_AMG:Project Exchange Rate cannot be null when project rate type is User.
14199: FND_MESSAGE.SET_NAME('PA','PA_EXCH_RATE_NULL_PC_AMG');
14200: FND_MSG_PUB.ADD;
14201: RAISE FND_API.G_EXC_ERROR;
14202: END IF;
14203: END IF;
14210: IF p_project_in.PROJECT_BIL_RATE_DATE_CODE is NULL
14211: OR p_project_in.PROJECT_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14212:
14213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14214: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
14215: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
14216: FND_MSG_PUB.ADD;
14217: RAISE FND_API.G_EXC_ERROR;
14218: END IF;
14211: OR p_project_in.PROJECT_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14212:
14213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14214: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
14215: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
14216: FND_MSG_PUB.ADD;
14217: RAISE FND_API.G_EXC_ERROR;
14218: END IF;
14219: ELSE
14220: IF p_project_in.PROJECT_BIL_RATE_DATE_CODE = 'FIXED_DATE' THEN --Modified for bug 6332591
14221: IF p_project_in.PROJECT_BIL_RATE_DATE is NULL
14222: OR p_project_in.PROJECT_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
14223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14224: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
14225: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
14226: FND_MSG_PUB.ADD;
14227: RAISE FND_API.G_EXC_ERROR;
14228: END IF;
14221: IF p_project_in.PROJECT_BIL_RATE_DATE is NULL
14222: OR p_project_in.PROJECT_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
14223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14224: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
14225: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Currency');
14226: FND_MSG_PUB.ADD;
14227: RAISE FND_API.G_EXC_ERROR;
14228: END IF;
14229: END IF;
14249: -- Project Functional Currency related attributes
14250: IF p_project_in.PROJFUNC_BIL_RATE_TYPE is NULL
14251: OR p_project_in.PROJFUNC_BIL_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_PFC_RATE_TYPE_INV_AMG:The project functional exchage rate type is invalid
14252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14253: FND_MESSAGE.SET_NAME('PA','PA_PFC_RATE_TYPE_INV_AMG');
14254: FND_MSG_PUB.ADD;
14255: RAISE FND_API.G_EXC_ERROR;
14256: END IF;
14257: ELSE
14258: IF p_project_in.PROJFUNC_BIL_RATE_TYPE = 'User' THEN
14259: IF p_project_in.PROJFUNC_BIL_EXCHANGE_RATE is NULL
14260: OR p_project_in.PROJFUNC_BIL_EXCHANGE_RATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14261: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- PA_EXCH_RATE_NULL_PF_AMG:Project Functional Exchange Rate cannot be null when project functional rate type is User.
14262: FND_MESSAGE.SET_NAME('PA','PA_EXCH_RATE_NULL_PF_AMG');
14263: FND_MSG_PUB.ADD;
14264: RAISE FND_API.G_EXC_ERROR;
14265: END IF;
14266: END IF;
14273: IF p_project_in.PROJFUNC_BIL_RATE_DATE_CODE is NULL
14274: OR p_project_in.PROJFUNC_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14275:
14276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14277: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
14278: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
14279: FND_MSG_PUB.ADD;
14280: RAISE FND_API.G_EXC_ERROR;
14281: END IF;
14274: OR p_project_in.PROJFUNC_BIL_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14275:
14276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14277: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
14278: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
14279: FND_MSG_PUB.ADD;
14280: RAISE FND_API.G_EXC_ERROR;
14281: END IF;
14282: ELSE
14283: IF p_project_in.PROJFUNC_BIL_RATE_DATE_CODE = 'FIXED_DATE' THEN --Modified for bug 6332591
14284: IF p_project_in.PROJFUNC_BIL_RATE_DATE is NULL
14285: OR p_project_in.PROJFUNC_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
14286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14287: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
14288: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
14289: FND_MSG_PUB.ADD;
14290: RAISE FND_API.G_EXC_ERROR;
14291: END IF;
14284: IF p_project_in.PROJFUNC_BIL_RATE_DATE is NULL
14285: OR p_project_in.PROJFUNC_BIL_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
14286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14287: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
14288: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Project Functional Currency');
14289: FND_MSG_PUB.ADD;
14290: RAISE FND_API.G_EXC_ERROR;
14291: END IF;
14292: END IF;
14310: -- Funding Currency related attributes
14311: IF p_project_in.FUNDING_RATE_TYPE is NULL
14312: OR p_project_in.FUNDING_RATE_TYPE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN -- PA_FUND_RATE_TYPE_INV_AMG:The funding exchage rate type is invalid
14313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14314: FND_MESSAGE.SET_NAME('PA','PA_FUND_RATE_TYPE_INV_AMG');
14315: FND_MSG_PUB.ADD;
14316: RAISE FND_API.G_EXC_ERROR;
14317: END IF;
14318: ELSE
14319: IF p_project_in.FUNDING_RATE_TYPE = 'User' THEN
14320: IF p_project_in.FUNDING_EXCHANGE_RATE is NULL
14321: OR p_project_in.FUNDING_EXCHANGE_RATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
14322: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN -- PA_EXCHANGE_RATE_NULL:Exchange rate cannot be null when rate type is User.
14323: FND_MESSAGE.SET_NAME('PA','PA_EXCHANGE_RATE_NULL');
14324: FND_MSG_PUB.ADD;
14325: RAISE FND_API.G_EXC_ERROR;
14326: END IF;
14327: END IF;
14333: IF p_project_in.FUNDING_RATE_DATE_CODE is NULL
14334: OR p_project_in.FUNDING_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14335:
14336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14337: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
14338: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
14339: FND_MSG_PUB.ADD;
14340: RAISE FND_API.G_EXC_ERROR;
14341: END IF;
14334: OR p_project_in.FUNDING_RATE_DATE_CODE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
14335:
14336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14337: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_TYPE_INVALID_AMG');
14338: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
14339: FND_MSG_PUB.ADD;
14340: RAISE FND_API.G_EXC_ERROR;
14341: END IF;
14342: ELSE
14343: IF p_project_in.FUNDING_RATE_DATE_CODE = 'FIXED_DATE' THEN --Modified for bug 6332591
14344: IF p_project_in.FUNDING_RATE_DATE is NULL
14345: OR p_project_in.FUNDING_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
14346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14347: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
14348: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
14349: FND_MSG_PUB.ADD;
14350: RAISE FND_API.G_EXC_ERROR;
14351: END IF;
14344: IF p_project_in.FUNDING_RATE_DATE is NULL
14345: OR p_project_in.FUNDING_RATE_DATE = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE THEN
14346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14347: FND_MESSAGE.SET_NAME('PA','PA_RATE_DATE_INVALID_AMG');
14348: FND_MESSAGE.SET_TOKEN('CURR_TYPE','Funding Currency');
14349: FND_MSG_PUB.ADD;
14350: RAISE FND_API.G_EXC_ERROR;
14351: END IF;
14352: END IF;
21592: --Bug 14100051
21593: l_status_changeable := PA_Project_Stus_Utils.allow_status_change(l_project_rec.project_status_code,p_project_in.project_status_code);
21594:
21595: IF (l_status_changeable='N') THEN
21596: FND_MESSAGE.SET_NAME('PA', 'PA_STATUS_CANT_CHANGE');
21597: FND_MSG_PUB.ADD;
21598: RAISE FND_API.G_EXC_ERROR;
21599: END IF;
21600:
22484: G_TASK_STR_UPDATE_MODE := null;
22485: end if;
22486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
22487: THEN
22488: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
22489: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
22490: FND_MESSAGE.SET_TOKEN('ENTITY', G_PROJECT_CODE);
22491: FND_MSG_PUB.ADD;
22492: END IF;
22485: end if;
22486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
22487: THEN
22488: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
22489: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
22490: FND_MESSAGE.SET_TOKEN('ENTITY', G_PROJECT_CODE);
22491: FND_MSG_PUB.ADD;
22492: END IF;
22493:
22486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
22487: THEN
22488: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
22489: FND_MESSAGE.SET_TOKEN('PROJECT', l_project_rec.segment1);
22490: FND_MESSAGE.SET_TOKEN('ENTITY', G_PROJECT_CODE);
22491: FND_MSG_PUB.ADD;
22492: END IF;
22493:
22494: FND_MSG_PUB.Count_And_Get
30564:
30565: ELSE --l_dlvr_action_enabled <> 'Y'
30566:
30567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
30568: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_ACTION_NOT_ENABLED') ;
30569: PA_UTILS.ADD_MESSAGE
30570: (p_app_short_name => 'PA',
30571: p_msg_name => 'PA_DLVR_VALID_ERR',
30572: p_token1 => 'PROJECT',
31037:
31038: ELSE --l_dlvr_action_enabled <> 'Y'
31039:
31040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
31041: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_ACTION_NOT_ENABLED') ;
31042: PA_UTILS.ADD_MESSAGE
31043: (p_app_short_name => 'PA',
31044: p_msg_name => 'PA_DLVR_VALID_ERR',
31045: p_token1 => 'PROJECT',