[Home] [Help]
463: , 3
464: );
465: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
466: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Generate_Breakpoints: Breakpoint Detail Lines are not Created for breakpoint Hdr Id');
467: fnd_msg_pub.ADD;
468: RAISE fnd_api.g_exc_error;
469: END IF;
470: EXCEPTION
471: WHEN fnd_api.g_exc_error THEN
549:
550: IF l_dummy IS NOT NULL
551: THEN
552: -- fnd_message.set_name ('PN' , 'PN_WARN_TRANSACTION_SETUP_DEL' );
553: --fnd_msg_pub.ADD;
554: l_answer := 2;
555:
556: --fnd_message.question(NAME_IN('parameter.pn_option_no'), NAME_IN('parameter.pn_option_yes'), NULL);
557: IF l_answer = 1
603:
604: -- fnd_message.set_name ('PN'
605: -- , 'PN_VAR_LINES_DELETED'
606: -- );
607: -- fnd_msg_pub.ADD;
608: pn_varen_util.pvt_debug
609: ('PN_VAREN_PVT: Undo_Breakpoints: You have successfully removed all breakpoint definitions from the variable rent agreement.'
610: , 3
611: );
2021: , 3
2022: );
2023: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2024: fnd_message.set_token ('ERR_MSG', 'Var Rent : Val_Ins_Allow_Abat: Variable Rent Number or Variable Rent Id doesnot exists While selecting the count');
2025: fnd_msg_pub.ADD;
2026: RAISE fnd_api.g_exc_error;
2027: END;
2028:
2029: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Val_Ins_Allow_Abat: Abatements var_rent_Id :'
2064: );
2065: fnd_message.set_name ('PN'
2066: , 'PN_VAR_ALL_ABA_TY'
2067: );
2068: fnd_msg_pub.ADD;
2069: RAISE fnd_api.g_exc_error;
2070: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
2071: THEN
2072: pn_varen_util.pvt_debug
2076: );
2077: fnd_message.set_name ('PN'
2078: , 'PN_VAR_ALL_ABA_TY'
2079: );
2080: fnd_msg_pub.ADD;
2081: RAISE fnd_api.g_exc_unexpected_error;
2082: END IF;
2083: END IF;
2084:
2105: );
2106: fnd_message.set_name ('PN'
2107: , 'PN_ST_DT_INV_MSG'
2108: );
2109: fnd_msg_pub.ADD;
2110: RAISE fnd_api.g_exc_error;
2111: END IF;
2112:
2113: ----------------------------------------------------------------------
2152: );
2153: fnd_message.set_name ('PN'
2154: , 'PN_VAR_ABT_STRDT_VAL_MSG'
2155: );
2156: fnd_msg_pub.ADD;
2157: RAISE fnd_api.g_exc_error;
2158:
2159: ELSIF (p_allow_abat_tbl_type (b).abat_start_date > p_allow_abat_tbl_type (b).abat_end_date)
2160: THEN
2168: );
2169: fnd_message.set_name ('PN'
2170: , 'PN_STR_GRT_END_DT'
2171: );
2172: fnd_msg_pub.ADD;
2173: RAISE fnd_api.g_exc_error;
2174: END IF;
2175: ELSE
2176: --
2188: ------------------------------------------------------------------------
2189: IF (p_allow_abat_tbl_type (b).abat_end_date IS NOT NULL OR p_allow_abat_tbl_type (b).abat_end_date <> pn_varen_util.g_pn_miss_date) THEN
2190: IF (p_allow_abat_tbl_type (b).abat_end_date < l_var_commencement_date OR p_allow_abat_tbl_type (b).abat_end_date > l_var_termination_date) THEN
2191: fnd_message.set_name('PN', 'PN_VAR_ABT_END_MSG');
2192: fnd_msg_pub.ADD;
2193: RAISE fnd_api.g_exc_error;
2194: ELSIF( p_allow_abat_tbl_type (b).abat_start_date > p_allow_abat_tbl_type (b).abat_end_date) THEN
2195: fnd_message.set_name('PN', 'PN_STR_GRT_END_DT');
2196: fnd_msg_pub.ADD;
2192: fnd_msg_pub.ADD;
2193: RAISE fnd_api.g_exc_error;
2194: ELSIF( p_allow_abat_tbl_type (b).abat_start_date > p_allow_abat_tbl_type (b).abat_end_date) THEN
2195: fnd_message.set_name('PN', 'PN_STR_GRT_END_DT');
2196: fnd_msg_pub.ADD;
2197: RAISE fnd_api.g_exc_error;
2198: END IF;
2199:
2200: BEGIN
2213: END;
2214: IF l_exist IS NULL THEN
2215: /* End date is not coinciding with the invoice End date */
2216: fnd_message.set_name('PN', 'PN_SED_DT_INV_MSG');
2217: fnd_msg_pub.ADD;
2218: RAISE fnd_api.g_exc_error;
2219: END IF;
2220: ELSE
2221: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2219: END IF;
2220: ELSE
2221: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2222: fnd_message.set_token('ERR_MSG', 'Invalid ABAT End Date');
2223: fnd_msg_pub.ADD;
2224: RAISE fnd_api.g_exc_error;
2225: END IF;
2226:
2227:
2262: );
2263: fnd_message.set_name ('PN'
2264: , 'PN_VAR_ABT_END_MSG'
2265: );
2266: fnd_msg_pub.ADD;
2267: RAISE fnd_api.g_exc_error;
2268: ELSIF ( p_allow_abat_tbl_type (b).abat_end_date > l_var_termination_date
2269: OR p_allow_abat_tbl_type (b).abat_end_date < l_var_commencement_date
2270: )
2277: );
2278: fnd_message.set_name ('PN'
2279: , 'PN_VAR_ABT_END_MSG'
2280: );
2281: fnd_msg_pub.ADD;
2282: RAISE fnd_api.g_exc_error;
2283: ELSIF (p_allow_abat_tbl_type (b).abat_start_date > p_allow_abat_tbl_type (b).abat_end_date)
2284: THEN
2285: pn_varen_util.pvt_debug
2290: );
2291: fnd_message.set_name ('PN'
2292: , 'PN_STR_GRT_END_DT'
2293: );
2294: fnd_msg_pub.ADD;
2295: RAISE fnd_api.g_exc_error;
2296: END IF;
2297: ELSE
2298: p_allow_abat_tbl_type (b).abat_end_date := l_var_termination_date;
2314: );
2315: fnd_message.set_name ('PN'
2316: , 'PN_VAR_ALL_ABA_AT'
2317: );
2318: fnd_msg_pub.ADD;
2319: RAISE fnd_api.g_exc_error;
2320: END IF;
2321: */
2322:
2365:
2366: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2367: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2368: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_ALLOW_ABATE Descriptive Fields Error');
2369: fnd_msg_pub.ADD;
2370: RAISE fnd_api.g_exc_error;
2371: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
2372: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2373: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_ALLOW_ABATE Descriptive Fields Error');
2370: RAISE fnd_api.g_exc_error;
2371: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
2372: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2373: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_ALLOW_ABATE Descriptive Fields Error');
2374: fnd_msg_pub.ADD;
2375: RAISE fnd_api.g_exc_unexpected_error;
2376: END IF;
2377: END IF;
2378: END IF; -- End of attributes valitions in create var Allow and Abate*/
2401: );
2402: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
2403: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2404: fnd_message.set_token ('ERR_MSG', 'Var Rent:INSERT_ALLOW_ABAT:Exception');
2405: fnd_msg_pub.ADD;
2406: RAISE fnd_api.g_exc_error;
2407: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
2408: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2409: fnd_message.set_token ('ERR_MSG', 'Var Rent : INSERT_ALLOW_ABAT:Unexpected Exception');
2406: RAISE fnd_api.g_exc_error;
2407: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
2408: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
2409: fnd_message.set_token ('ERR_MSG', 'Var Rent : INSERT_ALLOW_ABAT:Unexpected Exception');
2410: fnd_msg_pub.ADD;
2411: RAISE fnd_api.g_exc_unexpected_error;
2412: END IF;
2413: ELSE
2414: pn_varen_util.pvt_debug
2429: , 3
2430: );
2431: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2432: fnd_message.set_token('ERR_MSG', 'Pn_Varen_Pvt.Val_Ins_Allow_Abat - Rent_Num provided is not found');
2433: fnd_msg_pub.ADD;
2434: RAISE fnd_api.g_exc_error;
2435: END IF;
2436:
2437: EXCEPTION
2713: , 3
2714: );
2715: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2716: fnd_message.set_token('ERR_MSG', 'Rent ID/Rent Number doesnt exist.');
2717: fnd_msg_pub.ADD;
2718: RAISE fnd_api.g_exc_error;
2719: END;
2720:
2721: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Val_Ins_Constraints: Constratints var_rent_Id :'
2739: , 3
2740: );
2741: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2742: fnd_message.set_token('ERR_MSG', 'Please ensure that constraint dates you enter coincide with invoice period dates');
2743: fnd_msg_pub.ADD;
2744: RAISE fnd_api.g_exc_error;
2745: --l_const_val := 'N';
2746: END IF;
2747:
2775: --
2776: fnd_message.set_name ('PN'
2777: , 'PN_VAR_CONSTR_TY'
2778: );
2779: fnd_msg_pub.ADD;
2780: RAISE fnd_api.g_exc_error;
2781: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
2782: THEN
2783: --
2783: --
2784: fnd_message.set_name ('PN'
2785: , 'PN_VAR_CONSTR_TY'
2786: );
2787: fnd_msg_pub.ADD;
2788: RAISE fnd_api.g_exc_unexpected_error;
2789: END IF;
2790: END IF;
2791:
2827: , 3
2828: );
2829: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2830: fnd_message.set_token('ERR_MSG', ' Constraint Variable Rent Id doesnot exists');
2831: fnd_msg_pub.ADD;
2832: RAISE fnd_api.g_exc_error;
2833: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
2834: pn_varen_util.pvt_debug
2835: ( 'PN_VAREN_PVT: Val_Ins_Constraints: Unexpected Error Constraint Variable Rent Id doesnot exists : '
2837: , 3
2838: );
2839: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2840: fnd_message.set_token('ERR_MSG', 'Unexpected Constraint Variable Rent Id doesnot exists');
2841: fnd_msg_pub.ADD;
2842: RAISE fnd_api.g_exc_unexpected_error;
2843: END IF;
2844: ELSE
2845: pn_varen_util.pvt_debug
2849: );
2850: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
2851: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
2852: fnd_message.set_token ('NULL_PARAM', 'RENT_ID ');
2853: fnd_msg_pub.ADD;
2854: RAISE fnd_api.g_exc_error;
2855: END IF;
2856:
2857: ----------------------------------------------------------------------
2901: );
2902: fnd_message.set_name ('PN'
2903: , 'PN_VAR_CONSTR_STRDT_VAL_MSG'
2904: );
2905: fnd_msg_pub.ADD;
2906: RAISE fnd_api.g_exc_error;
2907: ELSIF (p_constraints_tbl_type (c).constr_start_date > l_var_commencement_date)
2908: THEN
2909: pn_varen_util.pvt_debug
2914: );
2915: fnd_message.set_name ('PN'
2916: , 'PN_VAR_CONSTR_STRDT_VAL_MSG'
2917: );
2918: fnd_msg_pub.ADD;
2919: RAISE fnd_api.g_exc_error;
2920: END IF;
2921: ELSE
2922: --
2972: );
2973: fnd_message.set_name ('PN'
2974: , 'PN_VAR_CONSTR_ENDDT_VAL_MSG'
2975: );
2976: fnd_msg_pub.ADD;
2977: RAISE fnd_api.g_exc_error;
2978: ELSIF (p_constraints_tbl_type (c).constr_end_date < l_var_termination_date)
2979: THEN
2980: pn_varen_util.pvt_debug
2985: );
2986: fnd_message.set_name ('PN'
2987: , 'PN_VAR_CONSTR_ENDDT_VAL_MSG'
2988: );
2989: fnd_msg_pub.ADD;
2990: RAISE fnd_api.g_exc_error;
2991: END IF;
2992: ELSE
2993: --
3010: );
3011: fnd_message.set_name ('PN'
3012: , 'PN_VAR_CONSTR_AMT'
3013: );
3014: fnd_msg_pub.ADD;
3015: RAISE fnd_api.g_exc_error;
3016: END IF;
3017:
3018: ---------------------------------------------------------------------------------------------------------------------
3052: );
3053: fnd_message.set_name ('PN'
3054: , 'PN_VAR_WRONG_RANGE'
3055: );
3056: fnd_msg_pub.ADD;
3057: RAISE fnd_api.g_exc_error;
3058: END IF;
3059: ELSIF ( p_constraints_tbl_type (c).constr_type_code <> l_first_constr_type_code
3060: -- second record 'MIN'
3074: );
3075: fnd_message.set_name ('PN'
3076: , 'PN_VAR_WRONG_RANGE'
3077: );
3078: fnd_msg_pub.ADD;
3079: RAISE fnd_api.g_exc_error;
3080: END IF;
3081: END IF;
3082: END IF;
3125:
3126: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3127: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3128: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_CONSTRAINTS Descriptive Fields Error');
3129: fnd_msg_pub.ADD;
3130: RAISE fnd_api.g_exc_error;
3131: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3132: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3133: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_CONSTRAINTS Descriptive Fields Error');
3130: RAISE fnd_api.g_exc_error;
3131: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3132: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3133: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_CONSTRAINTS Descriptive Fields Error');
3134: fnd_msg_pub.ADD;
3135: RAISE fnd_api.g_exc_unexpected_error;
3136: END IF;
3137: END IF;
3138: END IF; -- End of attributes valitions in pn_var_constraints
3164: );
3165: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3166: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3167: fnd_message.set_token ('ERR_MSG', 'VAR RENT Contraints : INSERT_CONSTRAINTS Error');
3168: fnd_msg_pub.ADD;
3169: RAISE fnd_api.g_exc_error;
3170: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3171: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3172: fnd_message.set_token ('ERR_MSG', 'VAR RENT Contraints : INSERT_CONSTRAINTS Unexpected Error');
3169: RAISE fnd_api.g_exc_error;
3170: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3171: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3172: fnd_message.set_token ('ERR_MSG', 'VAR RENT Contraints : INSERT_CONSTRAINTS Unexpected Error');
3173: fnd_msg_pub.ADD;
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176: ELSE
3177: pn_varen_util.pvt_debug
3186: , 3
3187: );
3188: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3189: fnd_message.set_token ('ERR_MSG', 'VAR RENT Incorrect Rent Number:Error');
3190: fnd_msg_pub.ADD;
3191: RAISE fnd_api.g_exc_error;
3192: END IF;
3193: EXCEPTION
3194: WHEN fnd_api.g_exc_error THEN
3224: );
3225: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3226: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3227: fnd_message.set_token('ERR_MSG', 'Error in Generating the Constraints');
3228: fnd_msg_pub.ADD;
3229: RAISE fnd_api.g_exc_error;
3230: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3231: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3232: fnd_message.set_token('ERR_MSG', 'Unexpected Error in Generating the Constraints');
3229: RAISE fnd_api.g_exc_error;
3230: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3231: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3232: fnd_message.set_token('ERR_MSG', 'Unexpected Error in Generating the Constraints');
3233: fnd_msg_pub.ADD;
3234: RAISE fnd_api.g_exc_unexpected_error;
3235: END IF;
3236: ELSE
3237: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Val_Ins_Constraints: Generate Constraints not initiated'
3333: , 3
3334: );
3335: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3336: fnd_message.set_token('ERR_MSG', 'Validate_Breakpoint_Details: Variable Rent Id doesnot exists in Breakpoint Details');
3337: fnd_msg_pub.ADD;
3338: RAISE fnd_api.g_exc_error;
3339: END;
3340: IF( trim(l_break_type) <> 'NATURAL') THEN
3341: ----------------------------------------------------------------------------------------------------
3365: , 3
3366: );
3367: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3368: fnd_message.set_token('ERR_MSG', 'Validate_Breakpoint_Details: Mulitple period_id exists for the same variable rent Id');
3369: fnd_msg_pub.ADD;
3370: RAISE fnd_api.g_exc_error;
3371: WHEN OTHERS
3372: THEN
3373: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Breakpoint_Details: Variable Rent '
3377: , 3
3378: );
3379: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3380: fnd_message.set_token('ERR_MSG', 'Validate_Breakpoint_Details: Mulitple period_id exists for the same variable rent Id');
3381: fnd_msg_pub.ADD;
3382: RAISE fnd_api.g_exc_error;
3383: END;
3384:
3385: ----------------------------------------------------------------------
3443: );
3444: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3445: fnd_message.set_token('ERR_MSG', 'Validate_Breakpoint_Details: Please enter dates for breakpoint details:'
3446: ||p_breakpoint_details_rec_type.bkdt_start_date||' that coincide with the breakpoint dates');
3447: fnd_msg_pub.ADD;
3448: RAISE fnd_api.g_exc_error;
3449: END IF;
3450: ELSE
3451: pn_varen_util.pvt_debug
3467: );
3468: fnd_message.set_name ('PN'
3469: , 'PN_VAR_DATES_INTERSECT'
3470: );
3471: fnd_msg_pub.ADD;
3472: RAISE fnd_api.g_exc_error;
3473: --
3474: END IF;
3475:
3524: );
3525: fnd_message.set_name ('PN'
3526: , 'PN_VAR_DATES_INTERSECT'
3527: );
3528: fnd_msg_pub.ADD;
3529: RAISE fnd_api.g_exc_error;
3530:
3531: END IF;
3532: ELSE
3562: );
3563: fnd_message.set_name ('PN'
3564: , 'PN_VAR_WRONG_RANGE'
3565: );
3566: fnd_msg_pub.ADD;
3567: RAISE fnd_api.g_exc_error;
3568: END IF;
3569:
3570: -----------------------------------------------------------------------------------------
3578: );
3579: fnd_message.set_name ('PN'
3580: , 'PN_VAR_WRONG_RANGE'
3581: );
3582: fnd_msg_pub.ADD;
3583: RAISE fnd_api.g_exc_error;
3584: END IF;
3585:
3586: ----------------------------------------------------------------------------------------------
3768: );
3769: fnd_message.set_name ('PN'
3770: , 'PN_VAR_BKPT_OVERLAP'
3771: );
3772: fnd_msg_pub.ADD;
3773: RAISE fnd_api.g_exc_error;
3774: END IF;
3775:
3776: -----------------------------------------------------------------------------------------------------
3791: );
3792: fnd_message.set_name ('PN'
3793: , 'PN_VAR_BKPT_OVERLAP'
3794: );
3795: fnd_msg_pub.ADD;
3796: RAISE fnd_api.g_exc_error;
3797: END IF;
3798: END IF;
3799:
3818: );
3819: IF(x_return_status = fnd_api.g_ret_sts_error) THEN
3820: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3821: fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Break Point Details not inserted properly');
3822: fnd_msg_pub.ADD;
3823: RAISE fnd_api.g_exc_error;
3824: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3825: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3826: fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Break Point Details not inserted properly:Unexpected Exception');
3823: RAISE fnd_api.g_exc_error;
3824: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3825: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3826: fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Break Point Details not inserted properly:Unexpected Exception');
3827: fnd_msg_pub.ADD;
3828: RAISE fnd_api.g_exc_unexpected_error;
3829: END IF;
3830:
3831: -- Capturing previous breakpoint details start date and breakpoint details end date.
3860: );
3861: IF(x_return_status = fnd_api.g_ret_sts_error) THEN
3862: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3863: fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details: Natural::Break Point Details not inserted properly');
3864: fnd_msg_pub.ADD;
3865: RAISE fnd_api.g_exc_error;
3866: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3867: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3868: fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details:Natural:: Break Point Details not inserted properly:Unexpected Exception');
3865: RAISE fnd_api.g_exc_error;
3866: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3867: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
3868: fnd_message.set_token ('ERR_MSG', 'Var Rent : validate_breakpoint_details:Natural:: Break Point Details not inserted properly:Unexpected Exception');
3869: fnd_msg_pub.ADD;
3870: RAISE fnd_api.g_exc_unexpected_error;
3871: END IF;
3872: x_return_status := fnd_api.g_ret_sts_success;
3873: END IF;--Artificial/Natural
3949: THEN
3950: fnd_message.set_name ('PN'
3951: , 'PN_VAR_BKHD_BRK_TY'
3952: );
3953: fnd_msg_pub.ADD;
3954: RAISE fnd_api.g_exc_error;
3955: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3956: fnd_message.set_name ('PN','PN_VAR_BKHD_BRK_TY');
3957: fnd_msg_pub.ADD;
3953: fnd_msg_pub.ADD;
3954: RAISE fnd_api.g_exc_error;
3955: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3956: fnd_message.set_name ('PN','PN_VAR_BKHD_BRK_TY');
3957: fnd_msg_pub.ADD;
3958: RAISE fnd_api.g_exc_unexpected_error;
3959: END IF;
3960: ELSE
3961: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
3960: ELSE
3961: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
3962: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
3963: fnd_message.set_token ('NULL_PARAM', 'Break Type:NULL');
3964: fnd_msg_pub.ADD;
3965: RAISE fnd_api.g_exc_error;
3966: END IF;
3967:
3968: ----------------------------------------------------------------------
3997: , 3
3998: );
3999: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4000: fnd_message.set_token('ERR_MSG', 'Variable Rent ID doesnt exist');
4001: fnd_msg_pub.ADD;
4002: RAISE fnd_api.g_exc_error;
4003: --x_return_status := fnd_api.g_ret_sts_error;
4004: -- l_validate_success:= 'N';
4005: END;
4076: ELSE
4077: fnd_message.set_name ('PN'
4078: , 'PN_VAR_DATES_INTERSECT'
4079: );
4080: fnd_msg_pub.ADD;
4081: RAISE fnd_api.g_exc_error;
4082: pn_varen_util.pvt_debug
4083: ( 'PN_VAREN_PVT: Validate_Breakpoint_Header: BREAK POINT START DATE Validation ERROR :'
4084: || p_breakpoint_header_rec_type.bkhd_start_date
4124: );
4125: fnd_message.set_name ('PN'
4126: , 'PN_VAR_DATES_INTERSECT'
4127: );
4128: fnd_msg_pub.ADD;
4129: RAISE fnd_api.g_exc_error;
4130:
4131: END IF;
4132:
4154: );
4155: fnd_message.set_name ('PN'
4156: , 'PN_VAR_DATES_INTERSECT'
4157: );
4158: fnd_msg_pub.ADD;
4159: RAISE fnd_api.g_exc_error;
4160: END IF;
4161: ELSE
4162: p_breakpoint_header_rec_type.bkhd_end_date := l_bkhd_term_date;
4191: );
4192:
4193: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
4194: fnd_message.set_name ('PN','PN_VAR_BKHD_BKPT_TY');
4195: fnd_msg_pub.ADD;
4196: RAISE fnd_api.g_exc_error;
4197: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4198: fnd_message.set_name ('PN','PN_VAR_BKHD_BKPT_TY');
4199: fnd_msg_pub.ADD;
4195: fnd_msg_pub.ADD;
4196: RAISE fnd_api.g_exc_error;
4197: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4198: fnd_message.set_name ('PN','PN_VAR_BKHD_BKPT_TY');
4199: fnd_msg_pub.ADD;
4200: RAISE fnd_api.g_exc_unexpected_error;
4201: END IF;
4202: ELSE
4203: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
4202: ELSE
4203: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
4204: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
4205: fnd_message.set_token ('NULL_PARAM', 'Break Point Type:NULL');
4206: fnd_msg_pub.ADD;
4207: RAISE fnd_api.g_exc_error;
4208: END IF;
4209:
4210: ----------------------------------
4216: IF (p_breakpoint_header_rec_type.natural_break_rate IS NULL OR p_breakpoint_header_rec_type.natural_break_rate = pn_varen_util.g_pn_miss_num) THEN
4217: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
4218: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
4219: fnd_message.set_token ('NULL_PARAM', 'Natural Rate: NULL');
4220: fnd_msg_pub.ADD;
4221: RAISE fnd_api.g_exc_error;
4222: END IF;
4223: ELSIF(p_breakpoint_header_rec_type.break_type_code = 'ARTIFICIAL') THEN
4224: p_breakpoint_header_rec_type.natural_break_rate := NULL;
4226: ELSE
4227: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
4228: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
4229: fnd_message.set_token ('NULL_PARAM', 'Break Type:NULL');
4230: fnd_msg_pub.ADD;
4231: RAISE fnd_api.g_exc_error;
4232: END IF;
4233:
4234: /*
4252: --
4253: fnd_message.set_name ('PN'
4254: , 'PN_VAR_BKHD_BRK_RT'
4255: );
4256: fnd_msg_pub.ADD;
4257: RAISE fnd_api.g_exc_error;
4258: --
4259: x_return_status := fnd_api.g_ret_sts_error;
4260: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Breakpoint_Header: Natural Break Rate is null - Error '
4283: );
4284: fnd_message.set_name ('PN'
4285: , 'PN_VAR_BKHD_BT_BKPT_TY'
4286: );
4287: fnd_msg_pub.ADD;
4288: RAISE fnd_api.g_exc_error;
4289: END IF;
4290: END IF;
4291:
4332: );
4333: fnd_message.set_name ('PN'
4334: , 'PN_VAR_BKPT_OVERLAP'
4335: );
4336: fnd_msg_pub.ADD;
4337: RAISE fnd_api.g_exc_error;
4338: END IF;
4339:
4340: -----------------------------------------------------------------------------------------------------
4355: );
4356: fnd_message.set_name ('PN'
4357: , 'PN_VAR_BKPT_OVERLAP'
4358: );
4359: fnd_msg_pub.ADD;
4360: RAISE fnd_api.g_exc_error;
4361: END IF;
4362: END IF; --l_previous_bkhd_start_date --l_previous_bkhd_end_date
4363:
4405:
4406: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
4407: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
4408: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_BKPTS_HEAD Descriptive Fields Error '||l_return_msg);
4409: fnd_msg_pub.ADD;
4410: RAISE fnd_api.g_exc_error;
4411: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4412: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
4413: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_BKPTS_HEAD Descriptive Fields Error '||l_return_msg);
4410: RAISE fnd_api.g_exc_error;
4411: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4412: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
4413: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_BKPTS_HEAD Descriptive Fields Error '||l_return_msg);
4414: fnd_msg_pub.ADD;
4415: RAISE fnd_api.g_exc_unexpected_error;
4416: END IF;
4417: END IF;
4418: END IF; -- End of attributes validations in PN_VAR_BKPTS_HEAD
4441:
4442: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
4443: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
4444: fnd_message.set_token ('ERR_MSG', 'INSERT_BREAKPOINT_HEADERS:Error');
4445: fnd_msg_pub.ADD;
4446: RAISE fnd_api.g_exc_error;
4447: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4448: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
4449: fnd_message.set_token ('ERR_MSG', 'INSERT_BREAKPOINT_HEADERS:Unexpected Error');
4446: RAISE fnd_api.g_exc_error;
4447: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4448: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
4449: fnd_message.set_token ('ERR_MSG', 'INSERT_BREAKPOINT_HEADERS:Unexpected Error');
4450: fnd_msg_pub.ADD;
4451: RAISE fnd_api.g_exc_unexpected_error;
4452: END IF;
4453:
4454: -- capturing the previous breakpoint header start date into a variable.
4772: --
4773: fnd_message.set_name ('PN'
4774: , 'PN_VAR_LIN_SAL_CHL'
4775: );
4776: fnd_msg_pub.ADD;
4777: RAISE fnd_api.g_exc_error;
4778: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
4779: THEN
4780: fnd_message.set_name ('PN'
4779: THEN
4780: fnd_message.set_name ('PN'
4781: , 'PN_VAR_LIN_SAL_CHL'
4782: );
4783: fnd_msg_pub.ADD;
4784: RAISE fnd_api.g_exc_unexpected_error;
4785: END IF;
4786: END IF;
4787:
4813: --
4814: fnd_message.set_name ('PN'
4815: , 'PN_VAR_LIN_ITM_CAY'
4816: );
4817: fnd_msg_pub.ADD;
4818: RAISE fnd_api.g_exc_error;
4819: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
4820: THEN
4821: --
4821: --
4822: fnd_message.set_name ('PN'
4823: , 'PN_VAR_LIN_ITM_CAY'
4824: );
4825: fnd_msg_pub.ADD;
4826: RAISE fnd_api.g_exc_unexpected_error;
4827: END IF;
4828: END IF;
4829:
4849: pn_varen_util.pvt_debug('PN_VAREN_PVT: Var_Rent_Line_Bkhd: End of Calling Variable Rent Lines Insert Procedure :'||l_return_status,3);
4850: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
4851: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4852: fnd_message.set_token('ERR_MSG', 'Error while inserting the VRA lines.');
4853: fnd_msg_pub.ADD;
4854: RAISE fnd_api.g_exc_error;
4855: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4856: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4857: fnd_message.set_token('ERR_MSG', 'Unexpected Error while inserting the VRA lines.');
4854: RAISE fnd_api.g_exc_error;
4855: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
4856: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4857: fnd_message.set_token('ERR_MSG', 'Unexpected Error while inserting the VRA lines.');
4858: fnd_msg_pub.ADD;
4859: RAISE fnd_api.g_exc_unexpected_error;
4860: END IF;
4861: END IF;
4862:
5054: IF(NVL(l_date_range_count,0) > 0) THEN
5055: --fnd_message.set_name('PN','PN_VAR_BKPT_OVERLAP');
5056: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5057: fnd_message.set_token('ERR_MSG', 'Please review each breakpoint component and remove any overlap in the breakpoint Header dates.');
5058: fnd_msg_pub.ADD;
5059: RAISE fnd_api.g_exc_error;
5060: END IF;
5061:
5062:
5346: IF(NVL(l_date_range_bkdt_count,0) > 0) THEN
5347: --fnd_message.set_name('PN','PN_VAR_BKPT_OVERLAP');
5348: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5349: fnd_message.set_token('ERR_MSG', 'Please review each breakpoint component and remove any overlap in the breakpoint Details dates.');
5350: fnd_msg_pub.ADD;
5351: RAISE fnd_api.g_exc_error;
5352: END IF;
5353:
5354:
5391: , 3
5392: );
5393: --fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5394: --fnd_message.set_token('ERR_MSG', 'Breakpoint Details not created:'|| p_breakpoint_details_tbl (k).bkdt_detail_num);
5395: --fnd_msg_pub.ADD;
5396: RAISE fnd_api.g_exc_error;
5397: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
5398: pn_varen_util.pvt_debug
5399: ( 'PN_VAREN_PVT: Var_Rent_Line_Bkhd: Breakpoint Details not created - BKDT_DETAIL_NUM : '
5401: , 3
5402: );
5403: --fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5404: --fnd_message.set_token('ERR_MSG', 'Breakpoint Details not created:'|| p_breakpoint_details_tbl (k).bkdt_detail_num);
5405: --fnd_msg_pub.ADD;
5406: RAISE fnd_api.g_exc_unexpected_error;
5407: END IF;
5408: ELSE
5409: pn_varen_util.pvt_debug
5489: , 3
5490: );
5491: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5492: fnd_message.set_token('ERR_MSG', 'Periods are not generated for Rent Num :'||p_variable_rent_lines_tbl (i).var_rent_num);
5493: fnd_msg_pub.ADD;
5494: RAISE fnd_api.g_exc_error;
5495: END IF; -- End of l_period_exists condition
5496: END IF; --l_variable_rent_exists
5497:
5525: );
5526: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
5527: --fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5528: --fnd_message.set_token('ERR_MSG', 'Break Points are not generated:'||l_var_rent_id);--OOPS(RHIA)
5529: --fnd_msg_pub.ADD;
5530: RAISE fnd_api.g_exc_error;
5531: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
5532: --fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5533: --fnd_message.set_token('ERR_MSG', 'Break Points are not generated:'||l_var_rent_id);
5530: RAISE fnd_api.g_exc_error;
5531: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
5532: --fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
5533: --fnd_message.set_token('ERR_MSG', 'Break Points are not generated:'||l_var_rent_id);
5534: --fnd_msg_pub.ADD;
5535: RAISE fnd_api.g_exc_unexpected_error;
5536: END IF;
5537: ELSE
5538: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Var_Rent_Line_Bkhd: Generate Constraints not initiated'
5908: THEN
5909: fnd_message.set_name ('PN'
5910: , 'PN_DUP_LEASE_NUMBER'
5911: );
5912: fnd_msg_pub.ADD;
5913: RAISE fnd_api.g_exc_error;
5914: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Var_Rent: Variable Rent Num Expected Error :'
5915: || p_upd_var_rent_rec_type.rent_num
5916: , 3
5919: THEN
5920: fnd_message.set_name ('PN'
5921: , 'PN_DUP_LEASE_NUMBER'
5922: );
5923: fnd_msg_pub.ADD;
5924: RAISE fnd_api.g_exc_unexpected_error;
5925: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Var_Rent: Variable Rent Num Un-Expected Error :'
5926: || p_upd_var_rent_rec_type.rent_num
5927: , 3
6014: );
6015: fnd_message.set_name ('PN'
6016: , 'PN_VAR_NVALID_LEASE'
6017: );
6018: fnd_msg_pub.ADD;
6019: RAISE fnd_api.g_exc_error;
6020: ELSE
6021: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Validate_Var_Rent: Calling Lease Validation '
6022: , 3
6046: );
6047: fnd_message.set_name ('PN'
6048: , 'PN_VAR_NVALID_LEASE'
6049: );
6050: fnd_msg_pub.ADD;
6051: RAISE fnd_api.g_exc_error;
6052:
6053: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6054: THEN
6058: );
6059: fnd_message.set_name ('PN'
6060: , 'PN_VAR_NVALID_LEASE'
6061: );
6062: fnd_msg_pub.ADD;
6063: RAISE fnd_api.g_exc_unexpected_error;
6064:
6065: ELSE
6066: l_return_status := fnd_api.g_ret_sts_success;
6118: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
6119: fnd_message.set_name ('PN'
6120: , 'PN_DUP_LEASE_NUMBER'
6121: );
6122: fnd_msg_pub.ADD;
6123: RAISE fnd_api.g_exc_error;
6124: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
6125: fnd_message.set_name ('PN'
6126: , 'PN_DUP_LEASE_NUMBER'
6124: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
6125: fnd_message.set_name ('PN'
6126: , 'PN_DUP_LEASE_NUMBER'
6127: );
6128: fnd_msg_pub.ADD;
6129: RAISE fnd_api.g_exc_unexpected_error;
6130: ELSE
6131: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Variable Rent Id Success :'
6132: || l_var_rent_id
6156: ELSE
6157: fnd_message.set_name ('PN'
6158: , 'PN_VAR_RENT_NUM_NULL'
6159: );
6160: fnd_msg_pub.ADD;
6161: RAISE fnd_api.g_exc_error;
6162: pn_varen_util.pvt_debug
6163: ('PN_VAREN_PVT: Validate_Var_Rent: VRA Number is Null and Automatic Number Generation for Variable Rent is set to No.'
6164: , 3
6261: , 3
6262: );
6263: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6264: fnd_message.set_token('ERR_MSG', 'Lease Commencement Date is NULL');
6265: fnd_msg_pub.ADD;
6266: RAISE fnd_api.g_exc_error;
6267: END IF;
6268:
6269: --------------------------------------------------------------------------------
6301: , 3
6302: );
6303: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6304: fnd_message.set_token('ERR_MSG', 'Lease Termination Date is NULL');
6305: fnd_msg_pub.ADD;
6306: RAISE fnd_api.g_exc_error;
6307: END IF;
6308:
6309: --------------------------------------------------------------------------------
6329: IF (l_return_status = fnd_api.g_ret_sts_error)
6330: THEN
6331: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6332: fnd_message.set_token('ERR_MSG', 'Invalid Location Code/ID,Please Provide Valid Location Code/ID');
6333: fnd_msg_pub.ADD;
6334: RAISE fnd_api.g_exc_error;
6335: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6336: THEN
6337: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6335: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6336: THEN
6337: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6338: fnd_message.set_token('ERR_MSG', 'Invalid Location Code/ID,Please Provide Valid Location Code/ID:Unexpected Error');
6339: fnd_msg_pub.ADD;
6340: RAISE fnd_api.g_exc_unexpected_error;
6341: ELSE
6342: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Location ID Validation Success :'
6343: || p_var_rent_rec.location_id
6379: , p_var_rent_rec.purpose_code_meaning
6380: || '/'
6381: || p_var_rent_rec.purpose_code
6382: );
6383: fnd_msg_pub.ADD;
6384: RAISE fnd_api.g_exc_error;
6385:
6386: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6387: THEN
6397: , p_var_rent_rec.purpose_code_meaning
6398: || '/'
6399: || p_var_rent_rec.purpose_code
6400: );
6401: fnd_msg_pub.ADD;
6402: RAISE fnd_api.g_exc_unexpected_error;
6403:
6404: ELSE
6405: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Payment Purpose Code Success :'
6421: , p_var_rent_rec.purpose_code_meaning
6422: || '/'
6423: || p_var_rent_rec.purpose_code
6424: );
6425: fnd_msg_pub.ADD;
6426: RAISE fnd_api.g_exc_error;
6427: END IF;
6428:
6429: --------------------------------------------------------------------------------
6458: , p_var_rent_rec.type_meaning
6459: || '/'
6460: || p_var_rent_rec.type_code
6461: );
6462: fnd_msg_pub.ADD;
6463: RAISE fnd_api.g_exc_error;
6464: pn_varen_util.pvt_debug
6465: ( 'PN_VAREN_PVT: Validate_Var_Rent: Rent Type Meaning Validation Expected Error :'
6466: || p_var_rent_rec.type_meaning
6475: , p_var_rent_rec.type_meaning
6476: || '/'
6477: || p_var_rent_rec.type_code
6478: );
6479: fnd_msg_pub.ADD;
6480: RAISE fnd_api.g_exc_unexpected_error;
6481: pn_varen_util.pvt_debug
6482: ( 'PN_VAREN_PVT: Validate_Var_Rent: Rent Type Meaning Validation Un-Expected Error :'
6483: || p_var_rent_rec.type_meaning
6503: , p_var_rent_rec.type_meaning
6504: || '/'
6505: || p_var_rent_rec.type_code
6506: );
6507: fnd_msg_pub.ADD;
6508: RAISE fnd_api.g_exc_error;
6509: END IF;
6510:
6511: --------------------------------------------------------------------------------
6539: , p_var_rent_rec.abstracted_by_user
6540: || '/'
6541: || p_var_rent_rec.abstracted_by_user_id
6542: );
6543: fnd_msg_pub.ADD;
6544: RAISE fnd_api.g_exc_error;
6545:
6546: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6547: THEN
6557: , p_var_rent_rec.abstracted_by_user
6558: || '/'
6559: || p_var_rent_rec.abstracted_by_user_id
6560: );
6561: fnd_msg_pub.ADD;
6562: RAISE fnd_api.g_exc_unexpected_error;
6563:
6564: ELSE
6565: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: User Validation user id Success:'
6570: ELSE
6571: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
6572: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
6573: fnd_message.set_token ('NULL_PARAM', 'Abstracted By is NULL.Please provide the valid value');
6574: fnd_msg_pub.ADD;
6575: RAISE fnd_api.g_exc_error;
6576: END IF;
6577:
6578: --------------------------------------------------------------------------------
6607: , p_var_rent_rec.cumulative_vol_meaning
6608: || '/'
6609: || p_var_rent_rec.cumulative_vol_code
6610: );
6611: fnd_msg_pub.ADD;
6612: RAISE fnd_api.g_exc_error;
6613:
6614: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6615: THEN
6625: , p_var_rent_rec.cumulative_vol_meaning
6626: || '/'
6627: || p_var_rent_rec.cumulative_vol_code
6628: );
6629: fnd_msg_pub.ADD;
6630: RAISE fnd_api.g_exc_unexpected_error;
6631:
6632: ELSE
6633: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Cumulative Volume Code Success:'
6653: );
6654: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
6655: fnd_message.set_token ('API_NAME', 'PN_VAR_RENT_PVT');
6656: fnd_message.set_token ('NULL_PARAM', 'CUMULATIVE_VOL is NULL');
6657: fnd_msg_pub.ADD;
6658: RAISE fnd_api.g_exc_error;
6659: END IF;
6660:
6661: --------------------------------------------------------------------------------
6686: , p_var_rent_rec.proration_rule_meaning
6687: || '/'
6688: || p_var_rent_rec.proration_rule_code
6689: );
6690: fnd_msg_pub.ADD;
6691: RAISE fnd_api.g_exc_error;
6692: pn_varen_util.pvt_debug
6693: ( 'PN_VAREN_PVT: Validate_Var_Rent: Proration Rule / Parial Year Method Meaning Expected Error :'
6694: || p_var_rent_rec.proration_rule_meaning
6703: , p_var_rent_rec.proration_rule_meaning
6704: || '/'
6705: || p_var_rent_rec.proration_rule_code
6706: );
6707: fnd_msg_pub.ADD;
6708: RAISE fnd_api.g_exc_unexpected_error;
6709: pn_varen_util.pvt_debug
6710: ( 'PN_VAREN_PVT: Validate_Var_Rent: Proration Rule / Parial Year Method Meaning Un-Expected Error :'
6711: || p_var_rent_rec.proration_rule_meaning
6761: , p_var_rent_rec.invoice_on_meaning
6762: || '/'
6763: || p_var_rent_rec.invoice_on_code
6764: );
6765: fnd_msg_pub.ADD;
6766: RAISE fnd_api.g_exc_error;
6767: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Invoice on Meaning Expected Error :'
6768: || p_var_rent_rec.invoice_on_meaning
6769: , 3
6777: , p_var_rent_rec.invoice_on_meaning
6778: || '/'
6779: || p_var_rent_rec.invoice_on_code
6780: );
6781: fnd_msg_pub.ADD;
6782: RAISE fnd_api.g_exc_unexpected_error;
6783: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Invoice on Meaning Un-Expected Error :'
6784: || p_var_rent_rec.invoice_on_meaning
6785: , 3
6907: , p_var_rent_rec.negative_rent_meaning
6908: || '/'
6909: || p_var_rent_rec.negative_rent_code
6910: );
6911: fnd_msg_pub.ADD;
6912: RAISE fnd_api.g_exc_error;
6913:
6914: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6915: THEN
6924: , p_var_rent_rec.negative_rent_meaning
6925: || '/'
6926: || p_var_rent_rec.negative_rent_code
6927: );
6928: fnd_msg_pub.ADD;
6929: RAISE fnd_api.g_exc_unexpected_error;
6930:
6931: ELSE
6932: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Negative Rent Code Success :'
6976: , p_var_rent_rec.term_template_id
6977: || '/'
6978: || p_var_rent_rec.term_template_name
6979: );
6980: fnd_msg_pub.ADD;
6981: RAISE fnd_api.g_exc_error;
6982:
6983: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6984: THEN
6989: , p_var_rent_rec.term_template_id
6990: || '/'
6991: || p_var_rent_rec.term_template_name
6992: );
6993: fnd_msg_pub.ADD;
6994: RAISE fnd_api.g_exc_unexpected_error;
6995:
6996: ELSE
6997: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Term Template Id Success :'
7005: ELSE
7006: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Term Template Id IS NULL:',3);
7007: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7008: fnd_message.set_token('ERR_MSG', 'Term Template ID has not been mentioned in either Variable Rent/Lease');
7009: fnd_msg_pub.ADD;
7010: RAISE fnd_api.g_exc_error;
7011: END IF;
7012:
7013: --------------------------------------------------------------------------------
7029: );
7030: fnd_message.set_token ('CURRENCY_CODE'
7031: , p_var_rent_rec.currency_code
7032: );
7033: fnd_msg_pub.ADD;
7034: RAISE fnd_api.g_exc_error;
7035:
7036: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7037: THEN
7040: );
7041: fnd_message.set_token ('CURRENCY_CODE'
7042: , p_var_rent_rec.currency_code
7043: );
7044: fnd_msg_pub.ADD;
7045: RAISE fnd_api.g_exc_unexpected_error;
7046: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Currency Code Un-Expected Error :'
7047: || p_var_rent_rec.currency_code
7048: , 3
7056: ELSE
7057: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Currency Code IS NULL:',3);
7058: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7059: fnd_message.set_token('ERR_MSG', 'Please provide Currency Code for the VAR Rent');
7060: fnd_msg_pub.ADD;
7061: RAISE fnd_api.g_exc_error;
7062: END IF;
7063:
7064: pn_varen_util.pvt_debug ('PN_VAREN_PVT: End - Variable Rent validations'
7112:
7113: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
7114: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
7115: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_RENTS Descriptive Fields Error'||l_return_msg);
7116: fnd_msg_pub.ADD;
7117: RAISE fnd_api.g_exc_error;
7118: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7119: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
7120: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_RENTS Descriptive Fields Error'||l_return_msg);
7117: RAISE fnd_api.g_exc_error;
7118: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7119: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
7120: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_RENTS Descriptive Fields Error'||l_return_msg);
7121: fnd_msg_pub.ADD;
7122: RAISE fnd_api.g_exc_unexpected_error;
7123: END IF;
7124: END IF;
7125: END IF; -- End of attributes valitions in create var rent*/
7165:
7166: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
7167: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
7168: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN VAR DATES Descriptive Fields Error');
7169: fnd_msg_pub.ADD;
7170: RAISE fnd_api.g_exc_error;
7171: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7172: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
7173: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN VAR DATES Descriptive Fields Error');
7170: RAISE fnd_api.g_exc_error;
7171: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
7172: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
7173: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN VAR DATES Descriptive Fields Error');
7174: fnd_msg_pub.ADD;
7175: RAISE fnd_api.g_exc_unexpected_error;
7176: END IF;
7177: END IF;
7178: END IF; -- End of attributes valitions in create var rent dates */
7225: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Upd_Val_Varent: Please pass the variable rent details'
7226: , 3
7227: );
7228: --fnd_message.set_name ('PN', 'PN_VAR_NVALID_LEASE');
7229: --fnd_msg_pub.ADD;
7230: RAISE fnd_api.g_exc_error;
7231: x_return_status := fnd_api.g_ret_sts_error;
7232: ELSE
7233: pn_varen_util.val_rent_details (p_rent_num => p_upd_var_rent_rec_type.rent_num
7244:
7245: IF (l_return_status = fnd_api.g_ret_sts_error)
7246: THEN
7247: --fnd_message.set_name ('PN' , 'PN_VAR_NVALID_LEASE');
7248: --fnd_msg_pub.ADD;
7249: RAISE fnd_api.g_exc_error;
7250: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: p_upd_var_rent_rec_type.rent_num error: '
7251: || p_upd_var_rent_rec_type.rent_num
7252: , 3
7253: );
7254: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7255: THEN
7256: --fnd_message.set_name ('PN' , 'PN_VAR_NVALID_LEASE');
7257: --fnd_msg_pub.ADD;
7258: RAISE fnd_api.g_exc_unexpected_error;
7259: pn_varen_util.pvt_debug
7260: ( 'PN_VAREN_PVT: Upd_Val_Varent: p_upd_var_rent_rec_type.rent_num unexpected error: '
7261: || p_upd_var_rent_rec_type.rent_num
7278: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Upd_Val_Varent: Please pass the variable rent details'
7279: , 3
7280: );
7281: --fnd_message.set_name ('PN', 'PN_VAR_NVALID_LEASE');
7282: --fnd_msg_pub.ADD;
7283: RAISE fnd_api.g_exc_error;
7284: x_return_status := fnd_api.g_ret_sts_error;
7285: ELSE
7286: pn_varen_util.val_rent_details (p_rent_num => p_upd_var_rent_rec_type.rent_num
7295:
7296: IF (l_return_status = fnd_api.g_ret_sts_error)
7297: THEN
7298: --fnd_message.set_name ('PN' , 'PN_VAR_NVALID_LEASE');
7299: --fnd_msg_pub.ADD;
7300: RAISE fnd_api.g_exc_error;
7301: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: p_upd_var_rent_rec_type.rent_num error: '
7302: || p_upd_var_rent_rec_type.rent_num
7303: , 3
7304: );
7305: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7306: THEN
7307: --fnd_message.set_name ('PN' , 'PN_VAR_NVALID_LEASE');
7308: --fnd_msg_pub.ADD;
7309: RAISE fnd_api.g_exc_unexpected_error;
7310: pn_varen_util.pvt_debug
7311: ( 'PN_VAREN_PVT: Upd_Val_Varent: p_upd_var_rent_rec_type.rent_num unexpected error: '
7312: || p_upd_var_rent_rec_type.rent_num
7338:
7339: IF (l_return_status <> fnd_api.g_ret_sts_success)
7340: THEN
7341: --fnd_message.set_name ('PN' , 'PN_VAR_NVALID_LEASE');
7342: --fnd_msg_pub.ADD;
7343:
7344: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: p_upd_var_rent_rec_type.lease_id error: '
7345: || p_upd_var_rent_rec_type.lease_id
7346: , 3
7369:
7370: IF (l_return_status <> fnd_api.g_ret_sts_success)
7371: THEN
7372: --fnd_message.set_name ('PN' , 'PN_VAR_NVALID_LEASE');
7373: --fnd_msg_pub.ADD;
7374:
7375: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: p_upd_var_rent_rec_type.location_id error: '
7376: || p_upd_var_rent_rec_type.location_id
7377: , 3
7409: THEN
7410: fnd_message.set_name ('PN'
7411: , 'PN_VAR_CALC_PRO_CODE'
7412: );
7413: fnd_msg_pub.ADD;
7414: RAISE fnd_api.g_exc_error;
7415: x_return_status := fnd_api.g_ret_sts_error;
7416: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7417: THEN
7417: THEN
7418: fnd_message.set_name ('PN'
7419: , 'PN_VAR_CALC_PRO_CODE'
7420: );
7421: fnd_msg_pub.ADD;
7422: RAISE fnd_api.g_exc_unexpected_error;
7423: x_return_status :=
7424: fnd_api.g_ret_sts_unexp_error;
7425: ELSE
7455: THEN
7456: fnd_message.set_name ('PN'
7457: , 'PN_VAR_FOR_PRO_CODE'
7458: );
7459: fnd_msg_pub.ADD;
7460: RAISE fnd_api.g_exc_error;
7461: x_return_status := fnd_api.g_ret_sts_error;
7462: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error
7463: THEN
7463: THEN
7464: fnd_message.set_name ('PN'
7465: , 'PN_VAR_FOR_PRO_CODE'
7466: );
7467: fnd_msg_pub.ADD;
7468: RAISE fnd_api.g_exc_unexpected_error;
7469: x_return_status :=
7470: fnd_api.g_ret_sts_unexp_error;
7471: ELSE
7827: );
7828: fnd_message.set_token ('YEAR_START_DATE'
7829: , p_var_rent_rec.year_start_date
7830: );
7831: fnd_msg_pub.ADD;
7832: RAISE fnd_api.g_exc_error;
7833: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7834: THEN
7835: fnd_message.set_name ('PN'
7843: );
7844: fnd_message.set_token ('YEAR_START_DATE'
7845: , p_var_rent_rec.year_start_date
7846: );
7847: fnd_msg_pub.ADD;
7848: RAISE fnd_api.g_exc_unexpected_error;
7849: ELSE
7850: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Dates: Calendar and Date year_start_date :'
7851: || p_var_rent_rec.year_start_date
7904: , p_var_rent_rec.reptg_freq_meaning
7905: || '/'
7906: || p_var_rent_rec.reptg_freq_code
7907: );
7908: fnd_msg_pub.ADD;
7909: RAISE fnd_api.g_exc_error;
7910:
7911: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7912: THEN
7917: , p_var_rent_rec.reptg_freq_meaning
7918: || '/'
7919: || p_var_rent_rec.reptg_freq_code
7920: );
7921: fnd_msg_pub.ADD;
7922: RAISE fnd_api.g_exc_unexpected_error;
7923:
7924: ELSE
7925: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Dates: Calculation Frequency Code Success :'
7968: , p_var_rent_rec.vrg_reptg_freq_meaning
7969: || '/'
7970: || p_var_rent_rec.vrg_reptg_freq_code
7971: );
7972: fnd_msg_pub.ADD;
7973: RAISE fnd_api.g_exc_error;
7974:
7975: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7976: THEN
7981: , p_var_rent_rec.vrg_reptg_freq_meaning
7982: || '/'
7983: || p_var_rent_rec.vrg_reptg_freq_code
7984: );
7985: fnd_msg_pub.ADD;
7986: RAISE fnd_api.g_exc_unexpected_error;
7987:
7988: ELSE
7989: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Dates: Reporting Frequency Code Success :'
8032: , p_var_rent_rec.invg_freq_meaning
8033: || '/'
8034: || p_var_rent_rec.invg_freq_code
8035: );
8036: fnd_msg_pub.ADD;
8037: RAISE fnd_api.g_exc_error;
8038:
8039: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
8040: THEN
8045: , p_var_rent_rec.invg_freq_meaning
8046: || '/'
8047: || p_var_rent_rec.invg_freq_code
8048: );
8049: fnd_msg_pub.ADD;
8050: RAISE fnd_api.g_exc_unexpected_error;
8051:
8052: ELSE
8053: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Dates: Invoicing Frequency Code Success :'
8136: p_var_rent_rec.reptg_days_after := NULL;
8137: fnd_message.set_name ('PN'
8138: , 'PN_VAR_REPTG_DAY_OF_MONTH'
8139: );
8140: fnd_msg_pub.ADD;
8141: RAISE fnd_api.g_exc_error;
8142: END IF;
8143:
8144: ------------------------------------------------------------------------------------
8178: p_var_rent_rec.invg_days_after := NULL;
8179: fnd_message.set_name ('PN'
8180: , 'PN_VAR_INVG_DAY_OF_MONTH'
8181: );
8182: fnd_msg_pub.ADD;
8183: RAISE fnd_api.g_exc_error;
8184:
8185: END IF;
8186: /*
8228:
8229: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
8230: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
8231: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN VAR DATES Descriptive Fields Error '||l_return_msg);
8232: fnd_msg_pub.ADD;
8233: RAISE fnd_api.g_exc_error;
8234: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8235: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
8236: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN VAR DATES Descriptive Fields Error '||l_return_msg);
8233: RAISE fnd_api.g_exc_error;
8234: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8235: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
8236: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN VAR DATES Descriptive Fields Error '||l_return_msg);
8237: fnd_msg_pub.ADD;
8238: RAISE fnd_api.g_exc_unexpected_error;
8239: END IF;
8240: END IF;
8241: END IF; -- End of attributes valitions in create var rent
8306: THEN
8307: fnd_message.set_name ('PN'
8308: , 'PN_VAR_CALC_REPTG_FREQ'
8309: );
8310: fnd_msg_pub.ADD;
8311: RAISE fnd_api.g_exc_error;
8312: pn_varen_util.pvt_debug
8313: ( 'PN_VAREN_PVT: Upd_Validate_Rent_Dates: Please reset the variable rent calculation frequency to be equal to or less than the reporting frequency :'
8314: || p_upd_var_rent_rec_type.vrg_reptg_freq_code
8320: THEN
8321: fnd_message.set_name ('PN'
8322: , 'PN_VAR_CALC_REPTG_FREQ'
8323: );
8324: fnd_msg_pub.ADD;
8325: RAISE fnd_api.g_exc_unexpected_error;
8326: pn_varen_util.pvt_debug
8327: ( 'PN_VAREN_PVT: Upd_Validate_Rent_Dates: Please reset the variable rent calculation frequency to be equal to or less than the reporting frequency :'
8328: || p_upd_var_rent_rec_type.vrg_reptg_freq_code
8365: THEN
8366: fnd_message.set_name ('PN'
8367: , 'PN_VAR_INVG_CALC_FREQ'
8368: );
8369: fnd_msg_pub.ADD;
8370: RAISE fnd_api.g_exc_error;
8371: pn_varen_util.pvt_debug
8372: ( 'PN_VAREN_PVT: Upd_Validate_Rent_Dates: Please reset the invoicing frequency to be equal to or less than the variable rent calculation frequency.'
8373: || p_upd_var_rent_rec_type.reptg_freq_code
8379: THEN
8380: fnd_message.set_name ('PN'
8381: , 'PN_VAR_INVG_CALC_FREQ'
8382: );
8383: fnd_msg_pub.ADD;
8384: RAISE fnd_api.g_exc_unexpected_error;
8385: pn_varen_util.pvt_debug
8386: ( 'PN_VAREN_PVT: Upd_Validate_Rent_Dates: Please reset the invoicing frequency to be equal to or less than the variable rent calculation frequency.'
8387: || p_upd_var_rent_rec_type.reptg_freq_code
8433: THEN
8434: fnd_message.set_name ('PN'
8435: , 'PN_VAR_REPTG_DAY_OF_MONTH'
8436: );
8437: fnd_msg_pub.ADD;
8438: RAISE fnd_api.g_exc_error;
8439: p_upd_var_rent_rec_type.reptg_days_after := NULL;
8440: --
8441: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Upd_Validate_Rent_Dates: Reporting Frequecy Due day is error '
8485: THEN
8486: fnd_message.set_name ('PN'
8487: , 'PN_VAR_INVG_DAY_OF_MONTH'
8488: );
8489: fnd_msg_pub.ADD;
8490: RAISE fnd_api.g_exc_error;
8491: p_upd_var_rent_rec_type.invg_days_after := NULL;
8492: --
8493: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Upd_Validate_Rent_Dates: Invoicing Frequecy Due day error '
8541: fnd_message.set_name ('PN'
8542: , 'PN_OTHERS_EXCEPTION'
8543: );
8544: fnd_message.set_token('ERR_MSG', 'Rent Dates DFF validation failed');
8545: fnd_msg_pub.ADD;
8546: RAISE fnd_api.g_exc_error;
8547: pn_varen_util.pvt_debug
8548: ( 'PN_VAREN_PVT: pn_varen_util.validate_flex_fields dates dff validation failed', 3);
8549: END IF;
8594:
8595: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
8596: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
8597: fnd_message.set_token ('ERR_MSG', l_return_msg);
8598: fnd_msg_pub.ADD;
8599: RAISE fnd_api.g_exc_error;
8600: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8601: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
8602: fnd_message.set_token ('ERR_MSG', l_return_msg);
8599: RAISE fnd_api.g_exc_error;
8600: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
8601: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
8602: fnd_message.set_token ('ERR_MSG', l_return_msg);
8603: fnd_msg_pub.ADD;
8604: RAISE fnd_api.g_exc_unexpected_error;
8605: END IF;
8606: END IF;
8607: END IF; -- End of attributes valitions in update var rent dates*/
9304: || pn_varen_util.g_debug
9305: , 3
9306: );
9307: pn_debug.set_err_stack ('PN_VAREN_PVT: Create_Var_Rent: TESTING');
9308: fnd_msg_pub.initialize;
9309: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Start of pn_varen_pvt.CREATE_VAR_RENT'
9310: , 3
9311: );
9312: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Create_Var_Rent: g_org_id :'
9328: --
9329: -- IF NVL (mo_global.check_valid_org (g_org_id), 'N') <> 'Y'
9330: -- THEN
9331: -- fnd_message.set_name ('MO', 'MO_ORG_INVALID');
9332: -- fnd_msg_pub.ADD;
9333: -- RAISE fnd_api.g_exc_error;
9334: -- END IF;
9335: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Create_Var_Rent: x_return_status Before assigning value to the API: '
9336: || x_return_status
9458: , 3
9459: );
9460: --fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9461: --fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_VAR_RENTS: Validation on Var Rent Failed');
9462: --fnd_msg_pub.ADD;
9463: RAISE fnd_api.g_exc_error;
9464: END IF;
9465:
9466: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Before PN_VAR_RENTS_PKG.INSERT_ROW PACKAGE'
9543: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9544: l_var_rent_err_count := l_var_rent_err_count+1;
9545: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9546: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : VAR RENT INSERTION Error');
9547: fnd_msg_pub.ADD;
9548: RAISE fnd_api.g_exc_error;
9549: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9550: l_var_rent_err_count := l_var_rent_err_count+1;
9551: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9549: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9550: l_var_rent_err_count := l_var_rent_err_count+1;
9551: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9552: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : VAR RENT INSERTION Unexpected Error');
9553: fnd_msg_pub.ADD;
9554: RAISE fnd_api.g_exc_unexpected_error;
9555: END IF;
9556: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Create_Var_Rent: End of CALL_VAREN_INSERT_ROW Procedure status : '
9557: || x_return_status
9581: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
9582: --l_var_rent_err_count := l_var_rent_err_count+1;
9583: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9584: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : GENERATE_PERIODS Return Status Error');
9585: fnd_msg_pub.ADD;
9586: RAISE fnd_api.g_exc_error;
9587: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9588: --l_var_rent_err_count := l_var_rent_err_count+1;
9589: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9587: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9588: --l_var_rent_err_count := l_var_rent_err_count+1;
9589: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9590: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : GENERATE_PERIODS Return Status Unexpected Error');
9591: fnd_msg_pub.ADD;
9592: RAISE fnd_api.g_exc_unexpected_error;
9593: END IF;
9594: pn_varen_util.pvt_debug
9595: ( 'PN_VAREN_PVT: Create_Var_Rent: End of calling VALIDATE_DATES Procedure status : '
9669: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9670: --l_var_rent_err_count := l_var_rent_err_count+1;
9671: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9672: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : GENERATE_PERIODS Return Status Error');
9673: fnd_msg_pub.ADD;
9674: RAISE fnd_api.g_exc_error;
9675: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9676: --l_var_rent_err_count := l_var_rent_err_count+1;
9677: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9675: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9676: --l_var_rent_err_count := l_var_rent_err_count+1;
9677: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9678: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : GENERATE_PERIODS Return Status Unexpected Error');
9679: fnd_msg_pub.ADD;
9680: RAISE fnd_api.g_exc_unexpected_error;
9681: END IF;
9682: pn_varen_util.pvt_debug
9683: ( 'PN_VAREN_PVT: Create_Var_Rent: End of calling CALL_VAREN_DATES_INSERT_ROW Procedure status : '
9720: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
9721: --l_var_rent_err_count := l_var_rent_err_count+1;
9722: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9723: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : GENERATE_PERIODS Return Status Error');
9724: fnd_msg_pub.ADD;
9725: RAISE fnd_api.g_exc_error;
9726: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9727: --l_var_rent_err_count := l_var_rent_err_count+1;
9728: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9726: ELSIF(l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9727: --l_var_rent_err_count := l_var_rent_err_count+1;
9728: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9729: fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : GENERATE_PERIODS Return Status Unexpected Error');
9730: fnd_msg_pub.ADD;
9731: RAISE fnd_api.g_exc_unexpected_error;
9732: END IF;
9733: pn_varen_util.pvt_debug
9734: ( 'PN_VAREN_PVT: Create_Var_Rent: start of Calling Generate Periods procedure status : '
9771: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
9772: l_var_rent_err_count := l_var_rent_err_count+1;
9773: --fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9774: -- fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : CREATE_BKPT_CONST_ALLOW_ABAT Return Status Error'||x_return_status);
9775: --fnd_msg_pub.ADD;
9776: --RAISE fnd_api.g_exc_error;
9777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9778: l_var_rent_err_count := l_var_rent_err_count+1;
9779: -- fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
9778: l_var_rent_err_count := l_var_rent_err_count+1;
9779: -- fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
9780: -- fnd_message.set_token ('ERR_MSG', 'CREATE_VAR_RENT : CREATE_BKPT_CONST_ALLOW_ABAT Return Status Unexpected Error'||x_return_status);
9781: -- fnd_msg_pub.ADD;
9782: --RAISE fnd_api.g_exc_unexpected_error;
9783: END IF;
9784: pn_varen_util.pvt_debug
9785: ( ' PN_VAREN_PVT: Create_Var_Rent: End of CREATE_BKPT_CONST_ALLOW_ABAT procedure status :'
9792: , 3
9793: );
9794: END IF;
9795:
9796: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
9797: , p_count => x_msg_count
9798: , p_data => x_msg_data
9799: );
9800:
9817: EXCEPTION
9818: WHEN fnd_api.g_exc_error THEN
9819: x_return_status := fnd_api.g_ret_sts_error;
9820: pn_varen_util.pvt_debug('PN_VAREN_PVT:FND_API.G_RET_STS_ERROR:Exception:'||SQLERRM,3);
9821: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
9822: , p_count => x_msg_count
9823: , p_data => x_msg_data
9824: );
9825: RAISE;
9825: RAISE;
9826: WHEN OTHERS THEN
9827: x_return_status := fnd_api.g_ret_sts_unexp_error;
9828: pn_varen_util.pvt_debug('PN_VAREN_PVT:FND_API.G_RET_STS_UNEXP_ERROR:Exception:'||SQLERRM,3);
9829: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
9830: , p_count => x_msg_count
9831: , p_data => x_msg_data
9832: );
9833: RAISE;
10098: WHEN OTHERS
10099: THEN
10100: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
10101: fnd_message.set_token ('ERR_MSG', 'Exception in GENERATE_PERIODS');
10102: fnd_msg_pub.ADD;
10103: x_return_status := fnd_api.g_ret_sts_error;
10104: RAISE;
10105: END generate_periods;
10106:
10317: , 3
10318: );
10319: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
10320: fnd_message.set_token ('ERR_MSG', 'Exception in UNDO_PERIODS');
10321: fnd_msg_pub.ADD;
10322: x_return_status := fnd_api.g_ret_sts_error;
10323: RAISE;
10324: END undo_periods;
10325:
10967: ( 'PN_VAREN_PVT: Validate_Var_Rent: p_var_rent_rec.lease_id Error: '
10968: || p_upd_var_rent_rec.lease_id
10969: , 3);
10970: fnd_message.set_name ('PN', 'PN_VAR_INVALID_LEASE');
10971: fnd_msg_pub.ADD;
10972: RAISE fnd_api.g_exc_error;
10973: END IF;
10974:
10975: IF p_upd_var_rent_rec.location_id IS NULL
11043: pn_varen_util.pvt_debug
11044: ( 'PN_VAREN_PVT: Upd_Val_Varent: User Validation User Name Expected Error:'
11045: || p_upd_var_rent_rec.abstracted_by_user
11046: , 3);
11047: fnd_msg_pub.ADD;
11048: RAISE fnd_api.g_exc_error;
11049: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11050: THEN
11051: fnd_message.set_name ('PN', 'PN_VAR_ABS_USER');
11056: pn_varen_util.pvt_debug
11057: ( 'PN_VAREN_PVT: Upd_Val_Varent: User Validation user Name Un-Expected Error:'
11058: || p_upd_var_rent_rec.abstracted_by_user
11059: , 3);
11060: fnd_msg_pub.ADD;
11061: RAISE fnd_api.g_exc_unexpected_error;
11062: ELSE
11063: pn_varen_util.pvt_debug
11064: ( 'PN_VAREN_PVT: Upd_Val_Varent: User Validation user id Success:'
11156: pn_varen_util.pvt_debug
11157: ( 'PN_VAREN_PVT: Upd_Val_Varent: Term Template Name Expected Error :'
11158: || p_upd_var_rent_rec.term_template_name
11159: , 3);
11160: fnd_msg_pub.ADD;
11161: RAISE fnd_api.g_exc_error;
11162: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11163: THEN
11164: fnd_message.set_name ('PN', 'PN_VAR_TRM_TEM');
11169: pn_varen_util.pvt_debug
11170: ( 'PN_VAREN_PVT: Upd_Val_Varent: Term Template Name Un-Expected Error :'
11171: || p_upd_var_rent_rec.term_template_name
11172: , 3);
11173: fnd_msg_pub.ADD;
11174: RAISE fnd_api.g_exc_unexpected_error;
11175: ELSE
11176: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: Term Template Id Success :'
11177: || p_upd_var_rent_rec.term_template_id
11219: pn_varen_util.pvt_debug
11220: ( 'PN_VAREN_PVT: Upd_Val_Varent: Currency Code Expected Error :'
11221: || p_upd_var_rent_rec.currency_code
11222: , 3);
11223: fnd_msg_pub.ADD;
11224: RAISE fnd_api.g_exc_error;
11225: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11226: THEN
11227: fnd_message.set_name ('PN', 'PN_VAR_CUR_CODE');
11229: pn_varen_util.pvt_debug
11230: ( 'PN_VAREN_PVT: Upd_Val_Varent: Currency Code Un-Expected Error :'
11231: || p_upd_var_rent_rec.currency_code
11232: , 3);
11233: fnd_msg_pub.ADD;
11234: RAISE fnd_api.g_exc_error;
11235: ELSE
11236: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: Currency Code Success :'
11237: || p_upd_var_rent_rec.currency_code
11332: pn_varen_util.pvt_debug
11333: ( 'PN_VAREN_PVT: Upd_Val_Varent: Cumulative Volume Meaning Expected Error:'
11334: || p_upd_var_rent_rec.cumulative_vol_meaning
11335: , 3);
11336: fnd_msg_pub.ADD;
11337: RAISE fnd_api.g_exc_error;
11338: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11339: THEN
11340: fnd_message.set_name ('PN', 'PN_VAR_CUMM_VOL');
11345: pn_varen_util.pvt_debug
11346: ( 'PN_VAREN_PVT: Upd_Val_Varent: Cumulative Volume Meaning Un-Expected Error:'
11347: || p_upd_var_rent_rec.cumulative_vol_meaning
11348: , 3);
11349: fnd_msg_pub.ADD;
11350: RAISE fnd_api.g_exc_unexpected_error;
11351: ELSE
11352: pn_varen_util.pvt_debug
11353: ( 'PN_VAREN_PVT: Upd_Val_Varent: Cumulative Volume Code Success:'
11421: pn_varen_util.pvt_debug
11422: ( 'PN_VAREN_PVT: Upd_Val_Varent: Proration Rule / Parial Year Method Meaning Expected Error :'
11423: || p_upd_var_rent_rec.proration_rule_meaning
11424: , 3);
11425: fnd_msg_pub.ADD;
11426: RAISE fnd_api.g_exc_error;
11427: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11428: THEN
11429: fnd_message.set_name ('PN', 'PN_VAR_PRO_RUL');
11434: pn_varen_util.pvt_debug
11435: ( 'PN_VAREN_PVT: Upd_Val_Varent: Proration Rule / Parial Year Method Meaning Un-Expected Error :'
11436: || p_upd_var_rent_rec.proration_rule_meaning
11437: , 3);
11438: fnd_msg_pub.ADD;
11439: RAISE fnd_api.g_exc_unexpected_error;
11440: ELSE
11441: pn_varen_util.pvt_debug
11442: ( 'PN_VAREN_PVT: Upd_Val_Varent: Proration Rule / Parial Year Method Code Success :'
11507: pn_varen_util.pvt_debug
11508: ( 'PN_VAREN_PVT: Upd_Val_Varent: Invoice on Meaning Expected Error :'
11509: || p_upd_var_rent_rec.invoice_on_meaning
11510: , 3);
11511: fnd_msg_pub.ADD;
11512: RAISE fnd_api.g_exc_error;
11513: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11514: THEN
11515: fnd_message.set_name ('PN', 'PN_VAR_INV_ON');
11520: pn_varen_util.pvt_debug
11521: ( 'PN_VAREN_PVT: Upd_Val_Varent: Invoice on Meaning Un-Expected Error :'
11522: || p_upd_var_rent_rec.invoice_on_meaning
11523: , 3);
11524: fnd_msg_pub.ADD;
11525: RAISE fnd_api.g_exc_unexpected_error;
11526: ELSE
11527: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: Invoice on Code Success :'
11528: || p_upd_var_rent_rec.invoice_on_code
11593: fnd_message.set_token ('NEGATIVE_RENT_CODE_MEANING'
11594: , p_upd_var_rent_rec.negative_rent_meaning
11595: || '/'
11596: || p_upd_var_rent_rec.negative_rent_code);
11597: fnd_msg_pub.ADD;
11598: RAISE fnd_api.g_exc_error;
11599: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11600: THEN
11601: pn_varen_util.pvt_debug
11606: fnd_message.set_token ('NEGATIVE_RENT_CODE_MEANING'
11607: , p_upd_var_rent_rec.negative_rent_meaning
11608: || '/'
11609: || p_upd_var_rent_rec.negative_rent_code);
11610: fnd_msg_pub.ADD;
11611: RAISE fnd_api.g_exc_unexpected_error;
11612: ELSE
11613: pn_varen_util.pvt_debug
11614: ( 'PN_VAREN_PVT: Upd_Val_Varent: Negative Rent Code Success :'
11684: pn_varen_util.pvt_debug
11685: ( 'PN_VAREN_PVT: Upd_Val_Varent: Rent Type Meaning Validation Expected Error :'
11686: || p_upd_var_rent_rec.type_meaning
11687: , 3);
11688: fnd_msg_pub.ADD;
11689: RAISE fnd_api.g_exc_error;
11690: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11691: THEN
11692: fnd_message.set_name ('PN', 'PN_VAR_VOL_TY');
11697: pn_varen_util.pvt_debug
11698: ( 'PN_VAREN_PVT: Upd_Val_Varent: Rent Type Meaning Validation Un-Expected Error :'
11699: || p_upd_var_rent_rec.type_meaning
11700: , 3);
11701: fnd_msg_pub.ADD;
11702: RAISE fnd_api.g_exc_unexpected_error;
11703: ELSE
11704: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Upd_Val_Varent: Rent Type Code Success :'
11705: || p_upd_var_rent_rec.type_code
11772: pn_varen_util.pvt_debug
11773: ( 'PN_VAREN_PVT: Upd_Val_Varent: Payment Purpose Meaning Expected Error :'
11774: || p_upd_var_rent_rec.purpose_code_meaning
11775: , 3);
11776: fnd_msg_pub.ADD;
11777: RAISE fnd_api.g_exc_error;
11778: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
11779: THEN
11780: fnd_message.set_name ('PN', 'PN_VAR_PUR_CODE');
11785: pn_varen_util.pvt_debug
11786: ( 'PN_VAREN_PVT: Upd_Val_Varent: Payment Purpose Meaning Un-Expected Error :'
11787: || p_upd_var_rent_rec.purpose_code_meaning
11788: , 3);
11789: fnd_msg_pub.ADD;
11790: RAISE fnd_api.g_exc_unexpected_error;
11791: ELSE
11792: pn_varen_util.pvt_debug
11793: ( 'PN_VAREN_PVT: Upd_Val_Varent: Payment Purpose Code Success :'
12120: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
12121: THEN
12122: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
12123: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPD_VAL_VARENT returned error');
12124: fnd_msg_pub.ADD;
12125: RAISE fnd_api.g_exc_error;
12126: END IF;
12127:
12128: IF (p_validate_flag <> 'Y') --and x_return_status = 'S')
12139: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
12140: THEN
12141: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
12142: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_VARENT returned error');
12143: fnd_msg_pub.ADD;
12144: RAISE fnd_api.g_exc_error;
12145: END IF;
12146: END IF; --p_validate_flag
12147: END IF; -- c_pn_var_rents
12312: || p_upd_var_rent_rec.gl_period_set_name
12313: || ' , '
12314: || p_upd_var_rent_rec.period_type
12315: , 3);
12316: fnd_msg_pub.ADD;
12317: RAISE fnd_api.g_exc_error;
12318: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
12319: THEN
12320: fnd_message.set_name ('PN', 'PN_VAR_PERIOD_SET_TYPE');
12327: || p_upd_var_rent_rec.gl_period_set_name
12328: || ' , '
12329: || p_upd_var_rent_rec.period_type
12330: , 3);
12331: fnd_msg_pub.ADD;
12332: RAISE fnd_api.g_exc_unexpected_error;
12333: --x_return_status :=fnd_api.g_ret_sts_unexp_error;
12334: ELSE
12335: pn_varen_util.pvt_debug
12429: ( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Meaning Expected Error :'
12430: || p_upd_var_rent_rec.vrg_reptg_freq_meaning
12431: , 3);
12432: x_return_status := fnd_api.g_ret_sts_error;
12433: fnd_msg_pub.ADD;
12434: RAISE fnd_api.g_exc_error;
12435: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
12436: THEN
12437: fnd_message.set_name ('PN', 'PN_VAR_VRG_REPT_CODE');
12443: ( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Meaning Un-Expected Error :'
12444: || p_upd_var_rent_rec.vrg_reptg_freq_meaning
12445: , 3);
12446: --x_return_status :=fnd_api.g_ret_sts_unexp_error;
12447: fnd_msg_pub.ADD;
12448: RAISE fnd_api.g_exc_unexpected_error;
12449: ELSE
12450: pn_varen_util.pvt_debug
12451: ( 'PN_VAREN_PVT: Update_Var_Rent: Reporting Frequency Code Success :'
12528: pn_varen_util.pvt_debug
12529: ( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency Meaning Expected Error :'
12530: || p_upd_var_rent_rec.reptg_freq_meaning
12531: , 3);
12532: fnd_msg_pub.ADD;
12533: RAISE fnd_api.g_exc_error;
12534: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
12535: THEN
12536: fnd_message.set_name ('PN', 'PN_VAR_REPT_CODE');
12541: pn_varen_util.pvt_debug
12542: ( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency Meaning Un-Expected Error :'
12543: || p_upd_var_rent_rec.reptg_freq_meaning
12544: , 3);
12545: fnd_msg_pub.ADD;
12546: RAISE fnd_api.g_exc_unexpected_error;
12547: ELSE
12548: pn_varen_util.pvt_debug
12549: ( 'PN_VAREN_PVT: Update_Var_Rent: Calculation Frequency Code Success :'
12581: OR p_upd_var_rent_rec.reptg_day_of_month > 28
12582: THEN
12583: p_upd_var_rent_rec.reptg_day_of_month := NULL;
12584: fnd_message.set_name ('PN', 'PN_VAR_REPTG_DAY_OF_MONTH');
12585: fnd_msg_pub.ADD;
12586: RAISE fnd_api.g_exc_error;
12587: END IF;
12588: END IF;
12589:
12605: OR p_upd_var_rent_rec.reptg_days_after > 28
12606: THEN
12607: p_upd_var_rent_rec.reptg_days_after := NULL;
12608: fnd_message.set_name ('PN', 'PN_VAR_INVG_DAY_OF_MONTH');
12609: fnd_msg_pub.ADD;
12610: RAISE fnd_api.g_exc_error;
12611: END IF;
12612: END IF;
12613:
12645: OR p_upd_var_rent_rec.invg_day_of_month > 28
12646: THEN
12647: p_upd_var_rent_rec.invg_day_of_month := NULL;
12648: fnd_message.set_name ('PN', 'PN_VAR_INVG_DAY_OF_MONTH');
12649: fnd_msg_pub.ADD;
12650: RAISE fnd_api.g_exc_error;
12651: END IF;
12652: END IF;
12653:
12746: pn_varen_util.pvt_debug
12747: ( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Meaning Expected Error :'
12748: || p_upd_var_rent_rec.invg_freq_meaning
12749: , 3);
12750: fnd_msg_pub.ADD;
12751: RAISE fnd_api.g_exc_error;
12752: --x_return_status := fnd_api.g_ret_sts_error;
12753: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
12754: THEN
12761: ( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Meaning Un-Expected Error :'
12762: || p_upd_var_rent_rec.invg_freq_meaning
12763: , 3);
12764: --x_return_status := fnd_api.g_ret_sts_unexp_error;
12765: fnd_msg_pub.ADD;
12766: RAISE fnd_api.g_exc_unexpected_error;
12767: ELSE
12768: pn_varen_util.pvt_debug
12769: ( 'PN_VAREN_PVT: Update_Var_Rent: Invoicing Frequency Code Success :'
12900: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
12901:
12902: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
12903: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : Undo Periods returned error');
12904: fnd_msg_pub.ADD;
12905: RAISE fnd_api.g_exc_error;
12906: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
12907: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
12908: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : Undo Periods returned error');
12905: RAISE fnd_api.g_exc_error;
12906: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
12907: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
12908: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : Undo Periods returned error');
12909: fnd_msg_pub.ADD;
12910: RAISE fnd_api.g_exc_unexpected_error;
12911: END IF;
12912: END IF;
12913:
13208: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
13209: THEN
13210: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13211: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: UPD_VALIDATE_RENT_DATES returned error');
13212: fnd_msg_pub.ADD;
13213: RAISE fnd_api.g_exc_error;
13214: END IF;
13215:
13216:
13234: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
13235:
13236: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13237: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: update_varen_dates: Error');
13238: fnd_msg_pub.ADD;
13239: RAISE fnd_api.g_exc_error;
13240: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
13241: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13242: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: update_varen_dates: Error');
13239: RAISE fnd_api.g_exc_error;
13240: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
13241: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13242: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: update_varen_dates: Error');
13243: fnd_msg_pub.ADD;
13244: RAISE fnd_api.g_exc_unexpected_error;
13245: END IF;
13246:
13247: END IF; -- p_validate_flag
13324: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
13325: THEN
13326: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13327: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: UNDO_BREAKPOINTS returned error');
13328: fnd_msg_pub.ADD;
13329: RAISE fnd_api.g_exc_error;
13330: END IF;
13331: END IF;
13332:
13370: , 3);
13371: pn_varen_util.pvt_debug
13372: ('PN_VAREN_PVT: Update_Var_Rent: Sales Channel Lookup Validation Error'
13373: , 3);
13374: fnd_msg_pub.ADD;
13375: RAISE fnd_api.g_exc_error;
13376: --
13377: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13378: THEN
13385: , 3);
13386: pn_varen_util.pvt_debug
13387: ('PN_VAREN_PVT: Update_Var_Rent: Sales Channel Lookup Validation Unexpected Error'
13388: , 3);
13389: fnd_msg_pub.ADD;
13390: RAISE fnd_api.g_exc_unexpected_error;
13391: --
13392: ELSE
13393: x_return_status := fnd_api.g_ret_sts_success;
13452: pn_varen_util.pvt_debug
13453: ( 'PN_VAREN_PVT: Update_Var_Rent: ITEM_CATEGORY(Type 2) Meaning Expected Error :'
13454: || p_var_rent_lines_tbl (ul).item_category_meaning
13455: , 3);
13456: fnd_msg_pub.ADD;
13457: RAISE fnd_api.g_exc_error;
13458: --
13459: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13460: THEN
13468: pn_varen_util.pvt_debug
13469: ( 'PN_VAREN_PVT: Update_Var_Rent: ITEM_CATEGORY(Type 2) Meaning Un-Expected Error :'
13470: || p_var_rent_lines_tbl (ul).item_category_meaning
13471: , 3);
13472: fnd_msg_pub.ADD;
13473: RAISE fnd_api.g_exc_error;
13474: --
13475:
13476: --RAISE fnd_api.g_exc_unexpected_error;
13738:
13739: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
13740: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13741: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_RENTS Descriptive Fields Error '||l_return_msg);
13742: fnd_msg_pub.ADD;
13743: RAISE fnd_api.g_exc_error;
13744: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
13745: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13746: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_RENTS Descriptive Fields Error'||l_return_msg);
13743: RAISE fnd_api.g_exc_error;
13744: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
13745: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
13746: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_RENTS Descriptive Fields Error'||l_return_msg);
13747: fnd_msg_pub.ADD;
13748: RAISE fnd_api.g_exc_unexpected_error;
13749: END IF;
13750: END IF;
13751: END IF; -- End of attributes valitions in create var rent
14054: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
14055: THEN
14056: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14057: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: INSERT_VARIABLE_RENT_LINES procedure returned error');
14058: fnd_msg_pub.ADD;
14059: RAISE fnd_api.g_exc_error;
14060: END IF;
14061: ELSE
14062:
14077: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
14078: THEN
14079: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14080: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent: UPDATE_VARIABLE_RENT_LINES procedure returned error');
14081: fnd_msg_pub.ADD;
14082: RAISE fnd_api.g_exc_error;
14083: END IF;
14084: END IF; --p_var_rent_lines_tbl (ul).line_default_id IS NULL
14085: END IF;
14192: , 3);
14193: pn_varen_util.pvt_debug
14194: ('PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Lookup Validation Error'
14195: , 3);
14196: fnd_msg_pub.ADD;
14197: RAISE fnd_api.g_exc_error;
14198: --
14199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
14200: THEN
14207: , 3);
14208: pn_varen_util.pvt_debug
14209: ('PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Lookup Validation Unexpected Error'
14210: , 3);
14211: fnd_msg_pub.ADD;
14212: RAISE fnd_api.g_exc_unexpected_error;
14213: --
14214: ELSE
14215: x_return_status := fnd_api.g_ret_sts_success;
14282: , 3);
14283: pn_varen_util.pvt_debug
14284: ('PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Lookup Validation Error'
14285: , 3);
14286: fnd_msg_pub.ADD;
14287: RAISE fnd_api.g_exc_error;
14288: --
14289: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
14290: THEN
14297: , 3);
14298: pn_varen_util.pvt_debug
14299: ('PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Lookup Validation Unexpected Error'
14300: , 3);
14301: fnd_msg_pub.ADD;
14302: RAISE fnd_api.g_exc_unexpected_error;
14303: --
14304: ELSE
14305: x_return_status := fnd_api.g_ret_sts_success;
14334: pn_varen_util.pvt_debug
14335: ( 'PN_VAREN_PVT: Update_Var_Rent: Provide a correct combination of BREAKPOINT_TYPE_code and Break Type code - Validation Error :'
14336: || p_breakpoint_header_tbl (ubk).breakpoint_type_code
14337: , 3);
14338: fnd_msg_pub.ADD;
14339: RAISE fnd_api.g_exc_error;
14340: --
14341: ELSE
14342: pn_varen_util.pvt_debug
14575:
14576: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
14577: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14578: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_BKPTS_HEAD Descriptive Fields Error '||l_return_msg);
14579: fnd_msg_pub.ADD;
14580: RAISE fnd_api.g_exc_error;
14581: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
14582: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14583: fnd_message.set_token ('ERR_MSG','UPDATE_VAR_RENT : PN_VAR_BKPTS_HEAD Descriptive Fields Error '|| l_return_msg);
14580: RAISE fnd_api.g_exc_error;
14581: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
14582: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14583: fnd_message.set_token ('ERR_MSG','UPDATE_VAR_RENT : PN_VAR_BKPTS_HEAD Descriptive Fields Error '|| l_return_msg);
14584: fnd_msg_pub.ADD;
14585: RAISE fnd_api.g_exc_unexpected_error;
14586: END IF;
14587: END IF;
14588: END IF; -- End of attributes validations in PN_VAR_BKPTS_HEAD
14614:
14615: --fnd_message.set_name('PN','PN_VAR_BKPT_OVERLAP');
14616: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
14617: fnd_message.set_token('ERR_MSG', 'Please review each breakpoint header dates and remove any overlap with the variable rent dates.');
14618: fnd_msg_pub.ADD;
14619: RAISE fnd_api.g_exc_error;
14620: END IF;
14621:
14622: l_date_range_count := 0;
14640: IF(NVL(l_date_range_count,0) > 0) THEN
14641: --fnd_message.set_name('PN','PN_VAR_BKPT_OVERLAP');
14642: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
14643: fnd_message.set_token('ERR_MSG', 'Please review each breakpoint component and remove any overlap in the breakpoint Header dates.');
14644: fnd_msg_pub.ADD;
14645: RAISE fnd_api.g_exc_error;
14646: END IF;
14647:
14648: -- Below if block has been added by Vivek on 09-DEC-2010
14659: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
14660: THEN
14661: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14662: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:INSERT_BREAKPOINT_HEADERS procedure returned error');
14663: fnd_msg_pub.ADD;
14664: RAISE fnd_api.g_exc_error;
14665: END IF;
14666: END IF;
14667: END IF;
14689: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
14690: THEN
14691: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
14692: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_BREAKPOINT_HEADERS procedure returned error');
14693: fnd_msg_pub.ADD;
14694: RAISE fnd_api.g_exc_error;
14695: END IF;
14696:
14697: END IF;
15032:
15033: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
15034: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15035: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_BKPTS_DETAIL Descriptive Fields Error '||l_return_msg);
15036: fnd_msg_pub.ADD;
15037: RAISE fnd_api.g_exc_error;
15038: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
15039: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15040: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT: PN_VAR_BKPTS_DETAIL Descriptive Fields Error '||l_return_msg);
15037: RAISE fnd_api.g_exc_error;
15038: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
15039: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15040: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT: PN_VAR_BKPTS_DETAIL Descriptive Fields Error '||l_return_msg);
15041: fnd_msg_pub.ADD;
15042: RAISE fnd_api.g_exc_unexpected_error;
15043: END IF;
15044: END IF;
15045: END IF; -- End of attributes validations in PN_VAR_BKPTS_HEAD
15059:
15060: --fnd_message.set_name('PN','PN_VAR_BKPT_OVERLAP');
15061: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
15062: fnd_message.set_token('ERR_MSG', 'Please review each breakpoint header dates and remove any overlap with the variable rent date.');
15063: fnd_msg_pub.ADD;
15064: RAISE fnd_api.g_exc_error;
15065: END IF;
15066: l_date_range_bkdt_count :=0;
15067: BEGIN
15080: IF(NVL(l_date_range_bkdt_count,0) > 0) THEN
15081: --fnd_message.set_name('PN','PN_VAR_BKPT_OVERLAP');
15082: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
15083: fnd_message.set_token('ERR_MSG', 'Please review each breakpoint component and remove any overlap in the breakpoint Details dates.');
15084: fnd_msg_pub.ADD;
15085: RAISE fnd_api.g_exc_error;
15086: END IF;
15087: IF x_return_status = 'S'
15088: THEN
15104: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
15105: THEN
15106: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15107: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_BREAKPOINT_DETAILS procedure returned error');
15108: fnd_msg_pub.ADD;
15109: RAISE fnd_api.g_exc_error;
15110: END IF;
15111: ELSE
15112: insert_breakpoint_details
15115: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
15116: THEN
15117: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15118: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:INSERT_BREAKPOINT_DETAILS procedure returned error');
15119: fnd_msg_pub.ADD;
15120: RAISE fnd_api.g_exc_error;
15121: END IF;
15122: END IF;
15123: END IF;
15387: ( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error : '
15388: || p_constraints_tbl (uc).constr_start_date
15389: || 'Please enter a constraint start date that is the same as or after the commencement date of the variable rent agreement.'
15390: , 3);
15391: fnd_msg_pub.ADD;
15392: --x_return_status := fnd_api.g_ret_sts_error;
15393: RAISE fnd_api.g_exc_error;
15394: --
15395:
15409: ( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error : '
15410: || p_constraints_tbl (uc).constr_start_date
15411: || 'Please ensure that constraint dates you enter coincide with invoice period dates'
15412: , 3);
15413: fnd_msg_pub.ADD;
15414: RAISE fnd_api.g_exc_error;
15415: --
15416:
15417: --l_const_val :=
15483: ( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date Validation Error : '
15484: || p_constraints_tbl (uc).constr_end_date
15485: || 'Please enter a constraint end date that is the same as or before the termination date of the variable rent agreement.'
15486: , 3);
15487: fnd_msg_pub.ADD;
15488: RAISE fnd_api.g_exc_error;
15489: --
15490:
15491: --l_const_val :=
15504: ( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date Validation Error : '
15505: || p_constraints_tbl (uc).constr_end_date
15506: || 'Please enter an end date that is greater than or equal to the start date.'
15507: , 3);
15508: fnd_msg_pub.ADD;
15509: RAISE fnd_api.g_exc_error;
15510: --
15511:
15512: --l_const_val :=
15602: , 3);
15603: pn_varen_util.pvt_debug
15604: ('PN_VAREN_PVT: Update_Var_Rent: Constraint Type Lookup Validation Error'
15605: , 3);
15606: fnd_msg_pub.ADD;
15607: RAISE fnd_api.g_exc_error;
15608: --
15609: --l_const_val :=
15610: -- 'N';
15620: , 3);
15621: pn_varen_util.pvt_debug
15622: ('PN_VAREN_PVT: Update_Var_Rent: Constraint Type Lookup Validation Unexpected Error'
15623: , 3);
15624: fnd_msg_pub.ADD;
15625: RAISE fnd_api.g_exc_unexpected_error;
15626: --
15627:
15628: --
15886:
15887: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
15888: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15889: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT: PN_VAR_CONSTRAINTS Descriptive Fields Error '||l_return_msg);
15890: fnd_msg_pub.ADD;
15891: RAISE fnd_api.g_exc_error;
15892: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
15893: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15894: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_CONSTRAINTS Descriptive Fields Error '||l_return_msg);
15891: RAISE fnd_api.g_exc_error;
15892: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
15893: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15894: fnd_message.set_token ('ERR_MSG', 'UPDATE_VAR_RENT : PN_VAR_CONSTRAINTS Descriptive Fields Error '||l_return_msg);
15895: fnd_msg_pub.ADD;
15896: RAISE fnd_api.g_exc_unexpected_error;
15897: END IF;
15898: END IF;
15899: END IF; -- End of attributes valitions in pn_var_constraints
15956: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
15957: THEN
15958: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15959: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:VAL_INS_CONSTRAINTS procedure returned error');
15960: fnd_msg_pub.ADD;
15961: RAISE fnd_api.g_exc_error;
15962: END IF;
15963: END IF;
15964: ELSIF (l_constr_count > 2)
15967: pn_varen_util.pvt_debug
15968: ('PN_VAREN_PVT: Update_Var_Rent: Only two constraints records can exists with constraint type as MAX and MIN.'
15969: , 3);
15970: fnd_message.set_name ('PN', 'PN_VAR_NO_CONSTR_REC');
15971: fnd_msg_pub.ADD;
15972: RAISE fnd_api.g_exc_error;
15973: --x_return_status := fnd_api.g_ret_sts_error;
15974: END IF; -- l_constr_count >=1
15975: --p_constraints_tbl (uc).constr_default_id := l_pn_var_constraints.constr_default_id;
15995: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
15996: THEN
15997: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
15998: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_CONSTRAINTS procedure returned error');
15999: fnd_msg_pub.ADD;
16000: RAISE fnd_api.g_exc_error;
16001: END IF;
16002: ELSE
16003: pn_varen_util.pvt_debug
16119: ('PN_VAREN_PVT: Update_Var_Rent: Allowance and Abatements Lookup Validation Error'
16120: , 3);
16121: --
16122: l_upd_allow_abat_val := 'N';
16123: fnd_msg_pub.ADD;
16124: RAISE fnd_api.g_exc_error;
16125: --
16126:
16127: --
16138: l_upd_allow_abat_val := 'N';
16139: RAISE fnd_api.g_exc_unexpected_error;
16140: --
16141: fnd_message.set_name ('PN', 'PN_VAR_ALL_ABA_TY');
16142: fnd_msg_pub.ADD;
16143: --
16144:
16145: --
16146:
16196: || p_allow_abat_tbl (ua).abat_start_date
16197: || ' and '
16198: || p_allow_abat_tbl (ua).abat_end_date
16199: , 3);
16200: fnd_msg_pub.ADD;
16201: RAISE fnd_api.g_exc_error;
16202: --
16203:
16204: --
16245:
16246: --x_return_status := fnd_api.g_ret_sts_error;
16247: l_upd_allow_abat_val := 'N';
16248: fnd_message.set_name ('PN', 'PN_VAR_ABT_STRDT_VAL_MSG');
16249: fnd_msg_pub.ADD;
16250: pn_varen_util.pvt_debug
16251: ( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date Validation Error : '
16252: || p_allow_abat_tbl (ua).abat_start_date
16253: || 'Please ensure that the start date for a rolling allowance or fixed abatement is within the variable rent agreement dates.'
16269: , 3);
16270: --
16271: l_upd_allow_abat_val := 'N';
16272: --x_return_status := fnd_api.g_ret_sts_error;
16273: fnd_msg_pub.ADD;
16274: RAISE fnd_api.g_exc_error;
16275: --
16276:
16277: --
16332: || 'Please ensure that the end date for a roslling allowance or fixed abatement is within the variable rent agreement dates.'
16333: , 3);
16334: l_upd_allow_abat_val := 'N';
16335: fnd_message.set_name ('PN', 'PN_VAR_ABT_END_MSG');
16336: fnd_msg_pub.ADD;
16337: --
16338: RAISE fnd_api.g_exc_error;
16339: --
16340:
16349: || 'Please ensure that the start date for a rolling allowance or fixed abatement is less than the end date.'
16350: , 3);
16351: l_upd_allow_abat_val := 'N';
16352: fnd_message.set_name ('PN', 'PN_STR_GRT_END_DT');
16353: fnd_msg_pub.ADD;
16354: RAISE fnd_api.g_exc_error;
16355: END IF;
16356: ELSE
16357: --
16594:
16595: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
16596: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
16597: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_ALLOW_ABATE Descriptive Fields Error');
16598: fnd_msg_pub.ADD;
16599: RAISE fnd_api.g_exc_error;
16600: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
16601: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
16602: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_ALLOW_ABATE Descriptive Fields Error');
16599: RAISE fnd_api.g_exc_error;
16600: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
16601: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
16602: fnd_message.set_token ('ERR_MSG', 'Var Rent : PN_ALLOW_ABATE Descriptive Fields Error');
16603: fnd_msg_pub.ADD;
16604: RAISE fnd_api.g_exc_unexpected_error;
16605: END IF;
16606: END IF;
16607: END IF; -- End of attributes valitions in update var Allow and Abate
16644: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
16645: THEN
16646: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
16647: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:VAL_INS_ALLOW_ABAT procedure returned error');
16648: fnd_msg_pub.ADD;
16649: RAISE fnd_api.g_exc_error;
16650: ELSE
16651: l_allow_abat_update := 'Y';
16652: END IF;
16677: IF x_return_status <> fnd_api.g_ret_sts_success --'S'
16678: THEN
16679: fnd_message.set_name ('PN', 'PN_OTHERS_EXCEPTION');
16680: fnd_message.set_token ('ERR_MSG', 'PN_VAREN_PVT: Update_Var_Rent:UPDATE_ALLOW_ABAT procedure returned error');
16681: fnd_msg_pub.ADD;
16682: RAISE fnd_api.g_exc_error;
16683: END IF;
16684: END IF; -- x_return_status
16685: END IF; --p_allow_abat_tbl (ua).abatement_id IS NULL