[Home] [Help]
461: ( 'PN_VAREN_PVT: Generate_Breakpoints: Breakpoint Detail Lines are not Created for breakpoint Hdr id: '
462: || l_bkdt_default_id
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;
462: || l_bkdt_default_id
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
548: );
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);
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
558: THEN -- Cancel
559: -- RAISE fnd_api.g_ret_sts_error;
560: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Undo_Breakpoints: Value of l_answer : '
600: );
601: END LOOP;
602: END LOOP;
603:
604: -- fnd_message.set_name ('PN'
605: -- , 'PN_VAR_LINES_DELETED'
606: -- );
607: -- fnd_msg_pub.ADD;
608: pn_varen_util.pvt_debug
2019: ( 'PN_VAREN_PVT: Val_Ins_Allow_Abat: Variable Rent Number or Variable Rent Id doesnot exists :'
2020: || SQLERRM
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;
2020: || SQLERRM
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:
2061: pn_varen_util.pvt_debug
2062: ('PN_VAREN_PVT: Val_Ins_Allow_Abat: Allowance and Abatements Lookup Validation Error'
2063: , 3
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;
2073: ( 'PN_VAR_RENT_PVT: Val_Ins_Allow_Abat: Allowance and Abatements Meaning Un-Expected Error :'
2074: || p_allow_abat_tbl_type (b).abat_type_meaning
2075: , 3
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;
2102: || ' and '
2103: || p_allow_abat_tbl_type (b).abat_end_date
2104: , 3
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;
2149: || p_allow_abat_tbl_type (b).abat_start_date
2150: || 'Please ensure that the start date for a rolling allowance or fixed abatement is within the variable rent agreement dates.'
2151: , 3
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;
2165: || p_allow_abat_tbl_type (b).abat_end_date
2166: || 'Please ensure that the start date for a rolling allowance or fixed abatement is less than the end date.'
2167: , 3
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;
2187: --- Validation of Allowance and Abatement end date
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');
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;
2197: RAISE fnd_api.g_exc_error;
2198: END IF;
2199:
2212: pn_varen_util.pvt_debug('PN_VAR_RENT_PVT: Val_Ins_Allow_Abat:Exception in ABAT END DATE Retrieval:'||SQLERRM,3);
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
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');
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;
2218: RAISE fnd_api.g_exc_error;
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:
2259: || p_allow_abat_tbl_type (b).abat_end_date
2260: || 'Please ensure that the end date for a roslling allowance or fixed abatement is within the variable rent agreement dates.'
2261: , 3
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;
2274: || p_allow_abat_tbl_type (b).abat_end_date
2275: || 'Please ensure that the end date for a roslling allowance or fixed abatement is within the variable rent agreement dates.'
2276: , 3
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;
2287: || p_allow_abat_tbl_type (b).abat_end_date
2288: || 'Please ensure that the start date for a rolling allowance or fixed abatement is less than the end date.'
2289: , 3
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;
2311: || p_allow_abat_tbl_type (b).abat_amount
2312: || 'Please enter Allowance and Abatement amount.'
2313: , 3
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;
2363: , x_return_status => l_return_status
2364: );
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
2364: );
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');
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');
2374: fnd_msg_pub.ADD;
2375: RAISE fnd_api.g_exc_unexpected_error;
2376: END IF;
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');
2374: fnd_msg_pub.ADD;
2375: RAISE fnd_api.g_exc_unexpected_error;
2376: END IF;
2377: END IF;
2399: insert_allow_abat (p_allow_abat_rec_type => p_allow_abat_tbl_type (b)
2400: , x_return_status => x_return_status
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
2400: , x_return_status => x_return_status
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');
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');
2410: fnd_msg_pub.ADD;
2411: RAISE fnd_api.g_exc_unexpected_error;
2412: END IF;
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');
2410: fnd_msg_pub.ADD;
2411: RAISE fnd_api.g_exc_unexpected_error;
2412: END IF;
2413: ELSE
2427: pn_varen_util.pvt_debug
2428: ('PN_VAR_RENT_PVT: Val_Ins_Allow_Abat: Pn_Varen_Pvt.Val_Ins_Allow_Abat - Rent_Num provided is not found'
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;
2428: ('PN_VAR_RENT_PVT: Val_Ins_Allow_Abat: Pn_Varen_Pvt.Val_Ins_Allow_Abat - Rent_Num provided is not found'
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:
2711: ( 'PN_VAREN_PVT: Val_Ins_Constraints: Variable Rent Number or Variable Rent Id doesnot exists :'
2712: || SQLERRM
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;
2712: || SQLERRM
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:
2737: pn_varen_util.pvt_debug
2738: ('PN_VAREN_PVT: Val_Ins_Constraints: Please ensure that constraint dates you enter coincide with invoice period dates'
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';
2738: ('PN_VAREN_PVT: Val_Ins_Constraints: Please ensure that constraint dates you enter coincide with invoice period dates'
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;
2772:
2773: IF (l_return_status = fnd_api.g_ret_sts_error)
2774: THEN
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;
2780: RAISE fnd_api.g_exc_error;
2781: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
2782: THEN
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;
2825: ( 'PN_VAREN_PVT: Val_Ins_Constraints: Constraint Variable Rent Id doesnot exists : '
2826: || p_constraints_tbl_type (c).var_rent_id
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
2826: || p_constraints_tbl_type (c).var_rent_id
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 : '
2836: || p_constraints_tbl_type (c).var_rent_id
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;
2836: || p_constraints_tbl_type (c).var_rent_id
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
2846: ( 'PN_VAREN_PVT: Val_Ins_Constraints: Constraint Variable Rent Id is null : '
2847: || p_constraints_tbl_type (c).var_rent_id
2848: , 3
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;
2847: || p_constraints_tbl_type (c).var_rent_id
2848: , 3
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;
2848: , 3
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:
2898: || p_constraints_tbl_type (c).constr_start_date
2899: || 'Please enter a constraint start date that is the same as or after the commencement date of the variable rent agreement.'
2900: , 3
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;
2911: || p_constraints_tbl_type (c).constr_start_date
2912: || 'Please ensure that constraint dates you enter coincide with invoice period dates'
2913: , 3
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;
2969: || p_constraints_tbl_type (c).constr_end_date
2970: || 'Please enter a constraint end date that is the same as or before the termination date of the variable rent agreement.'
2971: , 3
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;
2982: || p_constraints_tbl_type (c).constr_end_date
2983: || 'Please enter an end date that is greater than or equal to the start date.'
2984: , 3
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;
3007: || p_constraints_tbl_type (c).constr_amount
3008: || 'Please enter constraint amount'
3009: , 3
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;
3049: pn_varen_util.pvt_debug
3050: ('PN_VAREN_PVT: Val_Ins_Constraints: For Next Constraint record, constraint type is MAX and amount is less than first record amount.'
3051: , 3
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;
3071: pn_varen_util.pvt_debug
3072: ('PN_VAREN_PVT: Val_Ins_Constraints: For Next Constraint record, constraint type is MIN and amount is greater than first record amount '
3073: , 3
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;
3123: , x_return_status => l_return_status
3124: );
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
3124: );
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');
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');
3134: fnd_msg_pub.ADD;
3135: RAISE fnd_api.g_exc_unexpected_error;
3136: END IF;
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');
3134: fnd_msg_pub.ADD;
3135: RAISE fnd_api.g_exc_unexpected_error;
3136: END IF;
3137: END IF;
3162: insert_constraints (p_constraints_rec_type => p_constraints_tbl_type (c)
3163: , x_return_status => x_return_status
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
3163: , x_return_status => x_return_status
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');
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');
3173: fnd_msg_pub.ADD;
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
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');
3173: fnd_msg_pub.ADD;
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176: ELSE
3184: pn_varen_util.pvt_debug
3185: ('PN_VAREN_PVT: Val_Ins_Constraints: RENT_NUM not found, please provide the correct rent_num'
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;
3185: ('PN_VAREN_PVT: Val_Ins_Constraints: RENT_NUM not found, please provide the correct rent_num'
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
3222: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Val_Ins_Constraints: Generate Constraints Return Status'||l_return_status
3223: , 3
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
3223: , 3
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');
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');
3233: fnd_msg_pub.ADD;
3234: RAISE fnd_api.g_exc_unexpected_error;
3235: END IF;
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');
3233: fnd_msg_pub.ADD;
3234: RAISE fnd_api.g_exc_unexpected_error;
3235: END IF;
3236: ELSE
3331: ( 'PN_VAREN_PVT: Validate_Breakpoint_Details: Variable Rent Id doesnot exists in Breakpoint Details: '
3332: || p_breakpoint_details_rec_type.var_rent_id
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;
3332: || p_breakpoint_details_rec_type.var_rent_id
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
3363: ( 'PN_VAREN_PVT: Validate_Breakpoint_Details: Mulitple period_id exists for the same variable rent Id'
3364: || p_breakpoint_details_rec_type.var_rent_id
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
3364: || p_breakpoint_details_rec_type.var_rent_id
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
3375: || 'Period Id '
3376: || l_period_id
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;
3376: || l_period_id
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:
3440: || p_breakpoint_details_rec_type.bkdt_start_date
3441: || 'Please enter dates for breakpoint details that coincide with the breakpoint dates'
3442: , 3
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;
3441: || 'Please enter dates for breakpoint details that coincide with the breakpoint dates'
3442: , 3
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;
3464: pn_varen_util.pvt_debug
3465: ('PN_VAREN_PVT: Validate_Breakpoint_Details: Breakpoint Details start Date is greater than Breakpoint Details End Date'
3466: , 3
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;
3521: || p_breakpoint_details_rec_type.bkdt_end_date
3522: || 'Please enter dates for breakpoint details that coincide with the breakpoint header dates'
3523: , 3
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;
3559: || 'is less than Period Breakpoint volume end '
3560: || p_breakpoint_details_rec_type.period_bkpt_vol_end
3561: , 3
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;
3575: pn_varen_util.pvt_debug
3576: ('PN_VAREN_PVT: Validate_Breakpoint_Details: In Break Point Details, The range of numbers entered is invalid.'
3577: , 3
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;
3765: pn_varen_util.pvt_debug
3766: ('PN_VAREN_PVT: Validate_Breakpoint_Details: Next record Breakpoint Details start date is less than previous record Breakpoint Details start date'
3767: , 3
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;
3788: pn_varen_util.pvt_debug
3789: ('PN_VAREN_PVT: Validate_Breakpoint_Details: Next record Breakpoint Details end date is not greater than previous record Breakpoint Details end date'
3790: , 3
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;
3816: ('PN_VAREN_PVT: Validate_Breakpoint_Details: End of calling Breakpoint Details Insert Procedure Return Status'||x_return_status
3817: , 3
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
3817: , 3
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');
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');
3827: fnd_msg_pub.ADD;
3828: RAISE fnd_api.g_exc_unexpected_error;
3829: END IF;
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');
3827: fnd_msg_pub.ADD;
3828: RAISE fnd_api.g_exc_unexpected_error;
3829: END IF;
3830:
3858: ('PN_VAREN_PVT: Validate_Breakpoint_Details Natural: End of calling Breakpoint Details Insert Procedure Return Status'||x_return_status
3859: , 3
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
3859: , 3
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');
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');
3869: fnd_msg_pub.ADD;
3870: RAISE fnd_api.g_exc_unexpected_error;
3871: END IF;
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');
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;
3946: );
3947:
3948: IF (l_return_status = fnd_api.g_ret_sts_error)
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;
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;
3958: RAISE fnd_api.g_exc_unexpected_error;
3959: END IF;
3960: ELSE
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');
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;
3958: RAISE fnd_api.g_exc_unexpected_error;
3959: END IF;
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;
3959: END IF;
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:
3995: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Breakpoint_Header: Variable Rent Id doesnot exists : '
3996: || p_breakpoint_header_rec_type.var_rent_id
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;
3996: || p_breakpoint_header_rec_type.var_rent_id
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';
4073: || p_breakpoint_header_rec_type.bkhd_start_date
4074: , 3
4075: );
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;
4121: || 'is greater than '
4122: || p_breakpoint_header_rec_type.bkhd_end_date
4123: , 3
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;
4151: || p_breakpoint_header_rec_type.bkhd_end_date
4152: || 'Please enter dates for breakpoint details that coincide with the breakpoint dates'
4153: , 3
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;
4190: , 3
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');
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;
4200: RAISE fnd_api.g_exc_unexpected_error;
4201: END IF;
4202: ELSE
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');
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;
4200: RAISE fnd_api.g_exc_unexpected_error;
4201: END IF;
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;
4201: END IF;
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:
4213:
4214: IF (p_breakpoint_header_rec_type.break_type_code IS NOT NULL OR p_breakpoint_header_rec_type.break_type_code <> pn_varen_util.g_pn_miss_char) THEN
4215: IF (p_breakpoint_header_rec_type.break_type_code = 'NATURAL') THEN
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;
4214: IF (p_breakpoint_header_rec_type.break_type_code IS NOT NULL OR p_breakpoint_header_rec_type.break_type_code <> pn_varen_util.g_pn_miss_char) THEN
4215: IF (p_breakpoint_header_rec_type.break_type_code = 'NATURAL') THEN
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;
4215: IF (p_breakpoint_header_rec_type.break_type_code = 'NATURAL') THEN
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
4223: ELSIF(p_breakpoint_header_rec_type.break_type_code = 'ARTIFICIAL') THEN
4224: p_breakpoint_header_rec_type.natural_break_rate := NULL;
4225: END IF;
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;
4224: p_breakpoint_header_rec_type.natural_break_rate := NULL;
4225: END IF;
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;
4225: END IF;
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:
4249: OR p_breakpoint_header_rec_type.breakpoint_type_meaning = 'Natural'
4250: )
4251: THEN
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;
4280: ( 'PN_VAREN_PVT: Validate_Breakpoint_Header: Provide a correct combination of BREAKPOINT_TYPE_code and Break Type code - Validation Error :'
4281: || p_breakpoint_header_rec_type.breakpoint_type_code
4282: , 3
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;
4329: pn_varen_util.pvt_debug
4330: ('PN_VAREN_PVT: Validate_Breakpoint_Header: Next record Breakpoint Header start date is less than previous record Breakpoint Header end date'
4331: , 3
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;
4352: pn_varen_util.pvt_debug
4353: ('PN_VAREN_PVT: Validate_Breakpoint_Header: Next record Breakpoint Header end date is not greater than previous record Breakpoint Header end date'
4354: , 3
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;
4403: , x_return_status => l_return_status
4404: );
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
4404: );
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');
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);
4414: fnd_msg_pub.ADD;
4415: RAISE fnd_api.g_exc_unexpected_error;
4416: END IF;
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);
4414: fnd_msg_pub.ADD;
4415: RAISE fnd_api.g_exc_unexpected_error;
4416: END IF;
4417: END IF;
4439: );
4440: pn_varen_util.pvt_debug('PN_VAREN_PVT: Validate_Breakpoint_Header: End of Calling Breakpoint Headers Insert Procedure :'|| l_return_status, 3);
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
4440: pn_varen_util.pvt_debug('PN_VAREN_PVT: Validate_Breakpoint_Header: End of Calling Breakpoint Headers Insert Procedure :'|| l_return_status, 3);
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');
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');
4450: fnd_msg_pub.ADD;
4451: RAISE fnd_api.g_exc_unexpected_error;
4452: END IF;
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');
4450: fnd_msg_pub.ADD;
4451: RAISE fnd_api.g_exc_unexpected_error;
4452: END IF;
4453:
4769:
4770: IF (l_return_status = fnd_api.g_ret_sts_error)
4771: THEN
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;
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'
4781: , 'PN_VAR_LIN_SAL_CHL'
4782: );
4783: fnd_msg_pub.ADD;
4784: RAISE fnd_api.g_exc_unexpected_error;
4810:
4811: IF (l_return_status = fnd_api.g_ret_sts_error)
4812: THEN
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;
4818: RAISE fnd_api.g_exc_error;
4819: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
4820: THEN
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;
4847: , x_return_status => l_return_status
4848: );
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
4848: );
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');
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.');
4858: fnd_msg_pub.ADD;
4859: RAISE fnd_api.g_exc_unexpected_error;
4860: END IF;
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.');
4858: fnd_msg_pub.ADD;
4859: RAISE fnd_api.g_exc_unexpected_error;
4860: END IF;
4861: END IF;
5051: pn_varen_util.pvt_debug('PN_VAREN_PVT:Remove any overlap in the breakpoint Headers',3);
5052: END;
5053:
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;
5052: END;
5053:
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;
5053:
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:
5343: pn_varen_util.pvt_debug('PN_VAREN_PVT:Remove any overlap in the breakpoint details',3);
5344: END;
5345:
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;
5344: END;
5345:
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;
5345:
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:
5389: ( 'PN_VAREN_PVT: Var_Rent_Line_Bkhd: Breakpoint Details not created - BKDT_DETAIL_NUM : '
5390: || p_breakpoint_details_tbl (k).bkdt_detail_num
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
5390: || p_breakpoint_details_tbl (k).bkdt_detail_num
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 : '
5400: || p_breakpoint_details_tbl (k).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;
5400: || p_breakpoint_details_tbl (k).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
5487: ( 'PN_VAREN_PVT: Var_Rent_Line_Bkhd: Periods are not generated for Rent Num :'
5488: || p_variable_rent_lines_tbl (i).var_rent_num
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
5488: || p_variable_rent_lines_tbl (i).var_rent_num
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
5523: , p_org_id => g_org_id
5524: , x_return_status => l_return_status
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
5524: , x_return_status => l_return_status
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');
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);
5534: --fnd_msg_pub.ADD;
5535: RAISE fnd_api.g_exc_unexpected_error;
5536: END IF;
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);
5534: --fnd_msg_pub.ADD;
5535: RAISE fnd_api.g_exc_unexpected_error;
5536: END IF;
5537: ELSE
5905: );
5906:
5907: IF (x_return_status = fnd_api.g_ret_sts_error)
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;
5916: , 3
5917: );
5918: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
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;
6011: pn_varen_util.pvt_debug
6012: ('PN_VAREN_PVT: Validate_Var_Rent: Please pass the lease details to create Variable Rent'
6013: , 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;
6043: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Validate_Var_Rent: p_var_rent_rec.lease_id Error: '
6044: || p_var_rent_rec.lease_id
6045: , 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;
6055: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: p_var_rent_rec.lease_id Unexpected Error: '
6056: || p_var_rent_rec.lease_id
6057: , 3
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;
6115: , 3
6116: );
6117:
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;
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'
6127: );
6128: fnd_msg_pub.ADD;
6129: RAISE fnd_api.g_exc_unexpected_error;
6153: , 3
6154: );
6155: x_return_status := fnd_api.g_ret_sts_success;
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;
6259: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: ELSE: Lease Commencement date validation Failed :'
6260: || l_lease_commencement_date
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;
6260: || l_lease_commencement_date
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:
6299: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Commencement date validation Failed :'
6300: || p_var_rent_rec.termination_date
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;
6300: || p_var_rent_rec.termination_date
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:
6327: );
6328:
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)
6328:
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
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');
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
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');
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 :'
6371: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Payment Purpose Meaning Expected Error :'
6372: || p_var_rent_rec.purpose_code_meaning
6373: , 3
6374: );
6375: fnd_message.set_name ('PN'
6376: , 'PN_VAR_PUR_CODE'
6377: );
6378: fnd_message.set_token ('PURPOSE_CODE_MEANING'
6379: , p_var_rent_rec.purpose_code_meaning
6374: );
6375: fnd_message.set_name ('PN'
6376: , 'PN_VAR_PUR_CODE'
6377: );
6378: fnd_message.set_token ('PURPOSE_CODE_MEANING'
6379: , p_var_rent_rec.purpose_code_meaning
6380: || '/'
6381: || p_var_rent_rec.purpose_code
6382: );
6389: ( 'PN_VAREN_PVT: Validate_Var_Rent: Payment Purpose Meaning Un-Expected Error :'
6390: || p_var_rent_rec.purpose_code_meaning
6391: , 3
6392: );
6393: fnd_message.set_name ('PN'
6394: , 'PN_VAR_PUR_CODE'
6395: );
6396: fnd_message.set_token ('PURPOSE_CODE_MEANING'
6397: , p_var_rent_rec.purpose_code_meaning
6392: );
6393: fnd_message.set_name ('PN'
6394: , 'PN_VAR_PUR_CODE'
6395: );
6396: fnd_message.set_token ('PURPOSE_CODE_MEANING'
6397: , p_var_rent_rec.purpose_code_meaning
6398: || '/'
6399: || p_var_rent_rec.purpose_code
6400: );
6413: ELSE
6414: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Purpose_code is null'
6415: , 3
6416: );
6417: fnd_message.set_name ('PN'
6418: , 'PN_VAR_PUR_CODE'
6419: );
6420: fnd_message.set_token ('PURPOSE_CODE_MEANING'
6421: , p_var_rent_rec.purpose_code_meaning
6416: );
6417: fnd_message.set_name ('PN'
6418: , 'PN_VAR_PUR_CODE'
6419: );
6420: fnd_message.set_token ('PURPOSE_CODE_MEANING'
6421: , p_var_rent_rec.purpose_code_meaning
6422: || '/'
6423: || p_var_rent_rec.purpose_code
6424: );
6450: );
6451:
6452: IF (l_return_status = fnd_api.g_ret_sts_error)
6453: THEN
6454: fnd_message.set_name ('PN'
6455: , 'PN_VAR_VOL_TY'
6456: );
6457: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
6458: , p_var_rent_rec.type_meaning
6453: THEN
6454: fnd_message.set_name ('PN'
6455: , 'PN_VAR_VOL_TY'
6456: );
6457: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
6458: , p_var_rent_rec.type_meaning
6459: || '/'
6460: || p_var_rent_rec.type_code
6461: );
6467: , 3
6468: );
6469: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6470: THEN
6471: fnd_message.set_name ('PN'
6472: , 'PN_VAR_VOL_TY'
6473: );
6474: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
6475: , p_var_rent_rec.type_meaning
6470: THEN
6471: fnd_message.set_name ('PN'
6472: , 'PN_VAR_VOL_TY'
6473: );
6474: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
6475: , p_var_rent_rec.type_meaning
6476: || '/'
6477: || p_var_rent_rec.type_code
6478: );
6495: ELSE
6496: pn_varen_util.pvt_debug ('PN_VAREN_PVT: TYPE_CODE is NULL'
6497: , 3
6498: );
6499: fnd_message.set_name ('PN'
6500: , 'PN_VAR_VOL_TY'
6501: );
6502: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
6503: , p_var_rent_rec.type_meaning
6498: );
6499: fnd_message.set_name ('PN'
6500: , 'PN_VAR_VOL_TY'
6501: );
6502: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
6503: , p_var_rent_rec.type_meaning
6504: || '/'
6505: || p_var_rent_rec.type_code
6506: );
6531: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: User Validation User Name Expected Error:'
6532: || p_var_rent_rec.abstracted_by_user
6533: , 3
6534: );
6535: fnd_message.set_name ('PN'
6536: , 'PN_VAR_ABS_USER'
6537: );
6538: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
6539: , p_var_rent_rec.abstracted_by_user
6534: );
6535: fnd_message.set_name ('PN'
6536: , 'PN_VAR_ABS_USER'
6537: );
6538: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
6539: , p_var_rent_rec.abstracted_by_user
6540: || '/'
6541: || p_var_rent_rec.abstracted_by_user_id
6542: );
6549: ( 'PN_VAREN_PVT: Validate_Var_Rent: User Validation user Name Un-Expected Error:'
6550: || p_var_rent_rec.abstracted_by_user
6551: , 3
6552: );
6553: fnd_message.set_name ('PN'
6554: , 'PN_VAR_ABS_USER'
6555: );
6556: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
6557: , p_var_rent_rec.abstracted_by_user
6552: );
6553: fnd_message.set_name ('PN'
6554: , 'PN_VAR_ABS_USER'
6555: );
6556: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
6557: , p_var_rent_rec.abstracted_by_user
6558: || '/'
6559: || p_var_rent_rec.abstracted_by_user_id
6560: );
6567: , 3
6568: );
6569: END IF;
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;
6568: );
6569: END IF;
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;
6569: END IF;
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:
6599: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Cumulative Volume Meaning Expected Error:'
6600: || p_var_rent_rec.cumulative_vol_meaning
6601: , 3
6602: );
6603: fnd_message.set_name ('PN'
6604: , 'PN_VAR_CUMM_VOL'
6605: );
6606: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
6607: , p_var_rent_rec.cumulative_vol_meaning
6602: );
6603: fnd_message.set_name ('PN'
6604: , 'PN_VAR_CUMM_VOL'
6605: );
6606: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
6607: , p_var_rent_rec.cumulative_vol_meaning
6608: || '/'
6609: || p_var_rent_rec.cumulative_vol_code
6610: );
6617: ( 'PN_VAREN_PVT: Validate_Var_Rent: Cumulative Volume Meaning Un-Expected Error:'
6618: || p_var_rent_rec.cumulative_vol_meaning
6619: , 3
6620: );
6621: fnd_message.set_name ('PN'
6622: , 'PN_VAR_CUMM_VOL'
6623: );
6624: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
6625: , p_var_rent_rec.cumulative_vol_meaning
6620: );
6621: fnd_message.set_name ('PN'
6622: , 'PN_VAR_CUMM_VOL'
6623: );
6624: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
6625: , p_var_rent_rec.cumulative_vol_meaning
6626: || '/'
6627: || p_var_rent_rec.cumulative_vol_code
6628: );
6650: ELSE
6651: pn_varen_util.pvt_debug ('PN_VAREN_PVT: CUMULATIVE_VOL is NULL'
6652: , 3
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;
6651: pn_varen_util.pvt_debug ('PN_VAREN_PVT: CUMULATIVE_VOL is NULL'
6652: , 3
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;
6652: , 3
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:
6678: );
6679:
6680: IF (l_return_status = fnd_api.g_ret_sts_error)
6681: THEN
6682: fnd_message.set_name ('PN'
6683: , 'PN_VAR_PRO_RUL'
6684: );
6685: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
6686: , p_var_rent_rec.proration_rule_meaning
6681: THEN
6682: fnd_message.set_name ('PN'
6683: , 'PN_VAR_PRO_RUL'
6684: );
6685: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
6686: , p_var_rent_rec.proration_rule_meaning
6687: || '/'
6688: || p_var_rent_rec.proration_rule_code
6689: );
6695: , 3
6696: );
6697: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6698: THEN
6699: fnd_message.set_name ('PN'
6700: , 'PN_VAR_PRO_RUL'
6701: );
6702: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
6703: , p_var_rent_rec.proration_rule_meaning
6698: THEN
6699: fnd_message.set_name ('PN'
6700: , 'PN_VAR_PRO_RUL'
6701: );
6702: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
6703: , p_var_rent_rec.proration_rule_meaning
6704: || '/'
6705: || p_var_rent_rec.proration_rule_code
6706: );
6753: );
6754:
6755: IF (l_return_status = fnd_api.g_ret_sts_error)
6756: THEN
6757: fnd_message.set_name ('PN'
6758: , 'PN_VAR_INV_ON'
6759: );
6760: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
6761: , p_var_rent_rec.invoice_on_meaning
6756: THEN
6757: fnd_message.set_name ('PN'
6758: , 'PN_VAR_INV_ON'
6759: );
6760: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
6761: , p_var_rent_rec.invoice_on_meaning
6762: || '/'
6763: || p_var_rent_rec.invoice_on_code
6764: );
6769: , 3
6770: );
6771: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6772: THEN
6773: fnd_message.set_name ('PN'
6774: , 'PN_VAR_INV_ON'
6775: );
6776: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
6777: , p_var_rent_rec.invoice_on_meaning
6772: THEN
6773: fnd_message.set_name ('PN'
6774: , 'PN_VAR_INV_ON'
6775: );
6776: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
6777: , p_var_rent_rec.invoice_on_meaning
6778: || '/'
6779: || p_var_rent_rec.invoice_on_code
6780: );
6828: );
6829:
6830: IF l_return_status = 'E'
6831: THEN
6832: fnd_message.set_name ('PN'
6833: , 'PN_VAR_CALC_PRO_CODE'
6834: );
6835: RAISE fnd_api.g_exc_error;
6836: ELSIF l_return_status = 'U'
6834: );
6835: RAISE fnd_api.g_exc_error;
6836: ELSIF l_return_status = 'U'
6837: THEN
6838: fnd_message.set_name ('PN'
6839: , 'PN_VAR_CALC_PRO_CODE'
6840: );
6841: RAISE fnd_api.g_exc_unexpected_error;
6842: END IF;
6861: );
6862:
6863: IF (l_return_status = fnd_api.g_ret_sts_error)
6864: THEN
6865: fnd_message.set_name ('PN'
6866: , 'PN_VAR_FOR_PRO_CODE'
6867: );
6868: RAISE fnd_api.g_exc_error;
6869: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6867: );
6868: RAISE fnd_api.g_exc_error;
6869: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6870: THEN
6871: fnd_message.set_name ('PN'
6872: , 'PN_VAR_FOR_PRO_CODE'
6873: );
6874: RAISE fnd_api.g_exc_unexpected_error;
6875: END IF;
6899: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Negative Rent Meaning Expected Error :'
6900: || p_var_rent_rec.negative_rent_meaning
6901: , 3
6902: );
6903: fnd_message.set_name ('PN'
6904: , 'PN_VAR_NEG_REN'
6905: );
6906: fnd_message.set_token ('NEGATIVE_RENT_CODE_MEANING'
6907: , p_var_rent_rec.negative_rent_meaning
6902: );
6903: fnd_message.set_name ('PN'
6904: , 'PN_VAR_NEG_REN'
6905: );
6906: fnd_message.set_token ('NEGATIVE_RENT_CODE_MEANING'
6907: , p_var_rent_rec.negative_rent_meaning
6908: || '/'
6909: || p_var_rent_rec.negative_rent_code
6910: );
6916: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Validate_Var_Rent: Negative Rent Meaning Un-Expected Error :'
6917: || p_var_rent_rec.negative_rent_meaning
6918: , 3
6919: );
6920: fnd_message.set_name ('PN'
6921: , 'PN_VAR_NEG_REN'
6922: );
6923: fnd_message.set_token ('NEGATIVE_RENT_CODE_MEANING'
6924: , p_var_rent_rec.negative_rent_meaning
6919: );
6920: fnd_message.set_name ('PN'
6921: , 'PN_VAR_NEG_REN'
6922: );
6923: fnd_message.set_token ('NEGATIVE_RENT_CODE_MEANING'
6924: , p_var_rent_rec.negative_rent_meaning
6925: || '/'
6926: || p_var_rent_rec.negative_rent_code
6927: );
6968: );
6969:
6970: IF (l_return_status = fnd_api.g_ret_sts_error)
6971: THEN
6972: fnd_message.set_name ('PN'
6973: , 'PN_VAR_TRM_TEM'
6974: );
6975: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
6976: , p_var_rent_rec.term_template_id
6971: THEN
6972: fnd_message.set_name ('PN'
6973: , 'PN_VAR_TRM_TEM'
6974: );
6975: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
6976: , p_var_rent_rec.term_template_id
6977: || '/'
6978: || p_var_rent_rec.term_template_name
6979: );
6981: RAISE fnd_api.g_exc_error;
6982:
6983: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
6984: THEN
6985: fnd_message.set_name ('PN'
6986: , 'PN_VAR_TRM_TEM'
6987: );
6988: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
6989: , p_var_rent_rec.term_template_id
6984: THEN
6985: fnd_message.set_name ('PN'
6986: , 'PN_VAR_TRM_TEM'
6987: );
6988: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
6989: , p_var_rent_rec.term_template_id
6990: || '/'
6991: || p_var_rent_rec.term_template_name
6992: );
7003: THEN
7004: p_var_rent_rec.term_template_id := l_term_template_id;
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;
7004: p_var_rent_rec.term_template_id := l_term_template_id;
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:
7023: );
7024:
7025: IF (l_return_status = fnd_api.g_ret_sts_error)
7026: THEN
7027: fnd_message.set_name ('PN'
7028: , 'PN_VAR_CUR_CODE'
7029: );
7030: fnd_message.set_token ('CURRENCY_CODE'
7031: , p_var_rent_rec.currency_code
7026: THEN
7027: fnd_message.set_name ('PN'
7028: , 'PN_VAR_CUR_CODE'
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;
7034: RAISE fnd_api.g_exc_error;
7035:
7036: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7037: THEN
7038: fnd_message.set_name ('PN'
7039: , 'PN_VAR_CUR_CODE'
7040: );
7041: fnd_message.set_token ('CURRENCY_CODE'
7042: , p_var_rent_rec.currency_code
7037: THEN
7038: fnd_message.set_name ('PN'
7039: , 'PN_VAR_CUR_CODE'
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;
7054: );
7055: END IF;
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;
7055: END IF;
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:
7110: , x_return_status => l_return_status
7111: );
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
7111: );
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');
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);
7121: fnd_msg_pub.ADD;
7122: RAISE fnd_api.g_exc_unexpected_error;
7123: END IF;
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);
7121: fnd_msg_pub.ADD;
7122: RAISE fnd_api.g_exc_unexpected_error;
7123: END IF;
7124: END IF;
7163: , x_return_status => x_return_status
7164: );
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
7164: );
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');
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');
7174: fnd_msg_pub.ADD;
7175: RAISE fnd_api.g_exc_unexpected_error;
7176: END IF;
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');
7174: fnd_msg_pub.ADD;
7175: RAISE fnd_api.g_exc_unexpected_error;
7176: END IF;
7177: END IF;
7224: THEN
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
7243: );
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: '
7277: THEN
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
7294: );
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: '
7337: );
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
7368: );
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
7406: );
7407:
7408: IF l_return_status = fnd_api.g_ret_sts_error
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;
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
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;
7452: );
7453:
7454: IF l_return_status = fnd_api.g_ret_sts_error
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;
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
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;
7815: );
7816:
7817: IF (l_return_status = fnd_api.g_ret_sts_error)
7818: THEN
7819: fnd_message.set_name ('PN'
7820: , 'PN_VAR_GL_CAL_PER_TY'
7821: );
7822: fnd_message.set_token ('GL_CALENDAR'
7823: , p_var_rent_rec.gl_period_set_name
7818: THEN
7819: fnd_message.set_name ('PN'
7820: , 'PN_VAR_GL_CAL_PER_TY'
7821: );
7822: fnd_message.set_token ('GL_CALENDAR'
7823: , p_var_rent_rec.gl_period_set_name
7824: );
7825: fnd_message.set_token ('PERIOD_TYPE'
7826: , p_var_rent_rec.period_type
7821: );
7822: fnd_message.set_token ('GL_CALENDAR'
7823: , p_var_rent_rec.gl_period_set_name
7824: );
7825: fnd_message.set_token ('PERIOD_TYPE'
7826: , p_var_rent_rec.period_type
7827: );
7828: fnd_message.set_token ('YEAR_START_DATE'
7829: , p_var_rent_rec.year_start_date
7824: );
7825: fnd_message.set_token ('PERIOD_TYPE'
7826: , p_var_rent_rec.period_type
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;
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'
7836: , 'PN_VAR_GL_CAL_PER_TY'
7837: );
7838: fnd_message.set_token ('GL_CALENDAR'
7839: , p_var_rent_rec.gl_period_set_name
7834: THEN
7835: fnd_message.set_name ('PN'
7836: , 'PN_VAR_GL_CAL_PER_TY'
7837: );
7838: fnd_message.set_token ('GL_CALENDAR'
7839: , p_var_rent_rec.gl_period_set_name
7840: );
7841: fnd_message.set_token ('PERIOD_TYPE'
7842: , p_var_rent_rec.period_type
7837: );
7838: fnd_message.set_token ('GL_CALENDAR'
7839: , p_var_rent_rec.gl_period_set_name
7840: );
7841: fnd_message.set_token ('PERIOD_TYPE'
7842: , p_var_rent_rec.period_type
7843: );
7844: fnd_message.set_token ('YEAR_START_DATE'
7845: , p_var_rent_rec.year_start_date
7840: );
7841: fnd_message.set_token ('PERIOD_TYPE'
7842: , p_var_rent_rec.period_type
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;
7896: );
7897:
7898: IF (l_return_status = fnd_api.g_ret_sts_error)
7899: THEN
7900: fnd_message.set_name ('PN'
7901: , 'PN_VAR_REPT_CODE'
7902: );
7903: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
7904: , p_var_rent_rec.reptg_freq_meaning
7899: THEN
7900: fnd_message.set_name ('PN'
7901: , 'PN_VAR_REPT_CODE'
7902: );
7903: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
7904: , p_var_rent_rec.reptg_freq_meaning
7905: || '/'
7906: || p_var_rent_rec.reptg_freq_code
7907: );
7909: RAISE fnd_api.g_exc_error;
7910:
7911: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7912: THEN
7913: fnd_message.set_name ('PN'
7914: , 'PN_VAR_REPT_CODE'
7915: );
7916: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
7917: , p_var_rent_rec.reptg_freq_meaning
7912: THEN
7913: fnd_message.set_name ('PN'
7914: , 'PN_VAR_REPT_CODE'
7915: );
7916: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
7917: , p_var_rent_rec.reptg_freq_meaning
7918: || '/'
7919: || p_var_rent_rec.reptg_freq_code
7920: );
7960: );
7961:
7962: IF (l_return_status = fnd_api.g_ret_sts_error)
7963: THEN
7964: fnd_message.set_name ('PN'
7965: , 'PN_VAR_VRG_REPT_CODE'
7966: );
7967: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
7968: , p_var_rent_rec.vrg_reptg_freq_meaning
7963: THEN
7964: fnd_message.set_name ('PN'
7965: , 'PN_VAR_VRG_REPT_CODE'
7966: );
7967: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
7968: , p_var_rent_rec.vrg_reptg_freq_meaning
7969: || '/'
7970: || p_var_rent_rec.vrg_reptg_freq_code
7971: );
7973: RAISE fnd_api.g_exc_error;
7974:
7975: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
7976: THEN
7977: fnd_message.set_name ('PN'
7978: , 'PN_VAR_VRG_REPT_CODE'
7979: );
7980: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
7981: , p_var_rent_rec.vrg_reptg_freq_meaning
7976: THEN
7977: fnd_message.set_name ('PN'
7978: , 'PN_VAR_VRG_REPT_CODE'
7979: );
7980: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
7981: , p_var_rent_rec.vrg_reptg_freq_meaning
7982: || '/'
7983: || p_var_rent_rec.vrg_reptg_freq_code
7984: );
8024: );
8025:
8026: IF (l_return_status = fnd_api.g_ret_sts_error)
8027: THEN
8028: fnd_message.set_name ('PN'
8029: , 'PN_VAR_INVG_FREQ_CODE'
8030: );
8031: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
8032: , p_var_rent_rec.invg_freq_meaning
8027: THEN
8028: fnd_message.set_name ('PN'
8029: , 'PN_VAR_INVG_FREQ_CODE'
8030: );
8031: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
8032: , p_var_rent_rec.invg_freq_meaning
8033: || '/'
8034: || p_var_rent_rec.invg_freq_code
8035: );
8037: RAISE fnd_api.g_exc_error;
8038:
8039: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error)
8040: THEN
8041: fnd_message.set_name ('PN'
8042: , 'PN_VAR_INVG_FREQ_CODE'
8043: );
8044: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
8045: , p_var_rent_rec.invg_freq_meaning
8040: THEN
8041: fnd_message.set_name ('PN'
8042: , 'PN_VAR_INVG_FREQ_CODE'
8043: );
8044: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
8045: , p_var_rent_rec.invg_freq_meaning
8046: || '/'
8047: || p_var_rent_rec.invg_freq_code
8048: );
8133: OR p_var_rent_rec.reptg_day_of_month > 28)
8134: )
8135: THEN
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;
8175: OR p_var_rent_rec.invg_day_of_month > 28)
8176: )
8177: THEN
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;
8226: , x_return_status => l_return_status
8227: );
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
8227: );
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');
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);
8237: fnd_msg_pub.ADD;
8238: RAISE fnd_api.g_exc_unexpected_error;
8239: END IF;
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);
8237: fnd_msg_pub.ADD;
8238: RAISE fnd_api.g_exc_unexpected_error;
8239: END IF;
8240: END IF;
8303: );
8304:
8305: IF x_return_status = fnd_api.g_ret_sts_error
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;
8317: , 3
8318: );
8319: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
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;
8362: );
8363:
8364: IF x_return_status = fnd_api.g_ret_sts_error
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;
8376: , 3
8377: );
8378: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
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;
8430: AND p_upd_var_rent_rec_type.reptg_day_of_month < 1
8431: AND p_upd_var_rent_rec_type.reptg_day_of_month > 28
8432: )
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;
8482: AND ( p_upd_var_rent_rec_type.invg_day_of_month < 1
8483: AND p_upd_var_rent_rec_type.invg_day_of_month > 28)
8484: )
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;
8537:
8538:
8539: IF x_return_status <> fnd_api.g_ret_sts_success
8540: THEN
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;
8540: THEN
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);
8592: , x_return_status => x_return_status
8593: );
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
8593: );
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');
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);
8603: fnd_msg_pub.ADD;
8604: RAISE fnd_api.g_exc_unexpected_error;
8605: END IF;
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);
8603: fnd_msg_pub.ADD;
8604: RAISE fnd_api.g_exc_unexpected_error;
8605: END IF;
8606: END IF;
9327:
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: '
9456: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
9457: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Validation on Var Rent Failed'
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;
9457: pn_varen_util.pvt_debug ('PN_VAREN_PVT: Create_Var_Rent: Validation on Var Rent Failed'
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:
9541: , x_return_status => x_return_status
9542: );
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
9542: );
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;
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');
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;
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');
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 : '
9579: , x_return_status => l_return_status
9580: );
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
9580: );
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;
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');
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;
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');
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
9667: , x_return_status => x_return_status
9668: );
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
9668: );
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;
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');
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;
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');
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
9718: , x_msg_data => x_msg_data
9719: );
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
9719: );
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;
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');
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;
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');
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
9769: , x_msg_data => x_msg_data
9770: );
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
9770: );
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;
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');
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;
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');
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
10096: EXCEPTION
10097:
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;
10097:
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;
10315: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Undo_Periods: Variable Rent record doesnot exists : '
10316: || l_dates_ctd
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;
10316: || l_dates_ctd
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;
10966: pn_varen_util.pvt_debug
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:
11034: , 3);
11035:
11036: IF (x_return_status = fnd_api.g_ret_sts_error)
11037: THEN
11038: fnd_message.set_name ('PN', 'PN_VAR_ABS_USER');
11039: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
11040: , p_upd_var_rent_rec.abstracted_by_user
11041: || '/'
11042: || p_upd_var_rent_rec.abstracted_by_user_id);
11035:
11036: IF (x_return_status = fnd_api.g_ret_sts_error)
11037: THEN
11038: fnd_message.set_name ('PN', 'PN_VAR_ABS_USER');
11039: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
11040: , p_upd_var_rent_rec.abstracted_by_user
11041: || '/'
11042: || p_upd_var_rent_rec.abstracted_by_user_id);
11043: pn_varen_util.pvt_debug
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');
11052: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
11053: , p_upd_var_rent_rec.abstracted_by_user
11054: || '/'
11055: || p_upd_var_rent_rec.abstracted_by_user_id);
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');
11052: fnd_message.set_token ('ABSTRACTED_BY_USER_ID'
11053: , p_upd_var_rent_rec.abstracted_by_user
11054: || '/'
11055: || p_upd_var_rent_rec.abstracted_by_user_id);
11056: pn_varen_util.pvt_debug
11147: , 3);
11148:
11149: IF (x_return_status = fnd_api.g_ret_sts_error)
11150: THEN
11151: fnd_message.set_name ('PN', 'PN_VAR_TRM_TEM');
11152: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
11153: , p_upd_var_rent_rec.term_template_id
11154: || '/'
11155: || p_upd_var_rent_rec.term_template_name);
11148:
11149: IF (x_return_status = fnd_api.g_ret_sts_error)
11150: THEN
11151: fnd_message.set_name ('PN', 'PN_VAR_TRM_TEM');
11152: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
11153: , p_upd_var_rent_rec.term_template_id
11154: || '/'
11155: || p_upd_var_rent_rec.term_template_name);
11156: pn_varen_util.pvt_debug
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');
11165: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
11166: , p_upd_var_rent_rec.term_template_id
11167: || '/'
11168: || p_upd_var_rent_rec.term_template_name);
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');
11165: fnd_message.set_token ('TERM_TEMPLATE_ID_NAME'
11166: , p_upd_var_rent_rec.term_template_id
11167: || '/'
11168: || p_upd_var_rent_rec.term_template_name);
11169: pn_varen_util.pvt_debug
11213: , 3);
11214:
11215: IF (x_return_status = fnd_api.g_ret_sts_error)
11216: THEN
11217: fnd_message.set_name ('PN', 'PN_VAR_CUR_CODE');
11218: fnd_message.set_token ('CURRENCY_CODE', p_upd_var_rent_rec.currency_code);
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
11214:
11215: IF (x_return_status = fnd_api.g_ret_sts_error)
11216: THEN
11217: fnd_message.set_name ('PN', 'PN_VAR_CUR_CODE');
11218: fnd_message.set_token ('CURRENCY_CODE', p_upd_var_rent_rec.currency_code);
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');
11228: fnd_message.set_token ('CURRENCY_CODE', p_upd_var_rent_rec.currency_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
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');
11228: fnd_message.set_token ('CURRENCY_CODE', p_upd_var_rent_rec.currency_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);
11323: , 3);
11324:
11325: IF (x_return_status = fnd_api.g_ret_sts_error)
11326: THEN
11327: fnd_message.set_name ('PN', 'PN_VAR_CUMM_VOL');
11328: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
11329: , p_upd_var_rent_rec.cumulative_vol_meaning
11330: || '/'
11331: || p_upd_var_rent_rec.cumulative_vol_code);
11324:
11325: IF (x_return_status = fnd_api.g_ret_sts_error)
11326: THEN
11327: fnd_message.set_name ('PN', 'PN_VAR_CUMM_VOL');
11328: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
11329: , p_upd_var_rent_rec.cumulative_vol_meaning
11330: || '/'
11331: || p_upd_var_rent_rec.cumulative_vol_code);
11332: pn_varen_util.pvt_debug
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');
11341: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
11342: , p_upd_var_rent_rec.cumulative_vol_meaning
11343: || '/'
11344: || p_upd_var_rent_rec.cumulative_vol_code);
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');
11341: fnd_message.set_token ('CUMULATIVE_VOL_CODE_MEANING'
11342: , p_upd_var_rent_rec.cumulative_vol_meaning
11343: || '/'
11344: || p_upd_var_rent_rec.cumulative_vol_code);
11345: pn_varen_util.pvt_debug
11412: , 3);
11413:
11414: IF (x_return_status = fnd_api.g_ret_sts_error)
11415: THEN
11416: fnd_message.set_name ('PN', 'PN_VAR_PRO_RUL');
11417: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
11418: , p_upd_var_rent_rec.proration_rule_meaning
11419: || '/'
11420: || p_upd_var_rent_rec.proration_rule_code);
11413:
11414: IF (x_return_status = fnd_api.g_ret_sts_error)
11415: THEN
11416: fnd_message.set_name ('PN', 'PN_VAR_PRO_RUL');
11417: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
11418: , p_upd_var_rent_rec.proration_rule_meaning
11419: || '/'
11420: || p_upd_var_rent_rec.proration_rule_code);
11421: pn_varen_util.pvt_debug
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');
11430: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
11431: , p_upd_var_rent_rec.proration_rule_meaning
11432: || '/'
11433: || p_upd_var_rent_rec.proration_rule_code);
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');
11430: fnd_message.set_token ('PRORATION_RULE_CODE_MEANING'
11431: , p_upd_var_rent_rec.proration_rule_meaning
11432: || '/'
11433: || p_upd_var_rent_rec.proration_rule_code);
11434: pn_varen_util.pvt_debug
11498: , 3);
11499:
11500: IF (x_return_status = fnd_api.g_ret_sts_error)
11501: THEN
11502: fnd_message.set_name ('PN', 'PN_VAR_INV_ON');
11503: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
11504: , p_upd_var_rent_rec.invoice_on_meaning
11505: || '/'
11506: || p_upd_var_rent_rec.invoice_on_code);
11499:
11500: IF (x_return_status = fnd_api.g_ret_sts_error)
11501: THEN
11502: fnd_message.set_name ('PN', 'PN_VAR_INV_ON');
11503: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
11504: , p_upd_var_rent_rec.invoice_on_meaning
11505: || '/'
11506: || p_upd_var_rent_rec.invoice_on_code);
11507: pn_varen_util.pvt_debug
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');
11516: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
11517: , p_upd_var_rent_rec.invoice_on_meaning
11518: || '/'
11519: || p_upd_var_rent_rec.invoice_on_code);
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');
11516: fnd_message.set_token ('INVOICE_ON_CODE_MEANING'
11517: , p_upd_var_rent_rec.invoice_on_meaning
11518: || '/'
11519: || p_upd_var_rent_rec.invoice_on_code);
11520: pn_varen_util.pvt_debug
11588: pn_varen_util.pvt_debug
11589: ( 'PN_VAREN_PVT: Upd_Val_Varent: Negative Rent Meaning Expected Error :'
11590: || p_upd_var_rent_rec.negative_rent_meaning
11591: , 3);
11592: fnd_message.set_name ('PN', 'PN_VAR_NEG_REN');
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);
11589: ( 'PN_VAREN_PVT: Upd_Val_Varent: Negative Rent Meaning Expected Error :'
11590: || p_upd_var_rent_rec.negative_rent_meaning
11591: , 3);
11592: fnd_message.set_name ('PN', 'PN_VAR_NEG_REN');
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;
11601: pn_varen_util.pvt_debug
11602: ( 'PN_VAREN_PVT: Upd_Val_Varent: Negative Rent Meaning Un-Expected Error :'
11603: || p_upd_var_rent_rec.negative_rent_meaning
11604: , 3);
11605: fnd_message.set_name ('PN', 'PN_VAR_NEG_REN');
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);
11602: ( 'PN_VAREN_PVT: Upd_Val_Varent: Negative Rent Meaning Un-Expected Error :'
11603: || p_upd_var_rent_rec.negative_rent_meaning
11604: , 3);
11605: fnd_message.set_name ('PN', 'PN_VAR_NEG_REN');
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;
11675: , 3);
11676:
11677: IF (x_return_status = fnd_api.g_ret_sts_error)
11678: THEN
11679: fnd_message.set_name ('PN', 'PN_VAR_VOL_TY');
11680: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
11681: , p_upd_var_rent_rec.type_meaning
11682: || '/'
11683: || p_upd_var_rent_rec.type_code);
11676:
11677: IF (x_return_status = fnd_api.g_ret_sts_error)
11678: THEN
11679: fnd_message.set_name ('PN', 'PN_VAR_VOL_TY');
11680: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
11681: , p_upd_var_rent_rec.type_meaning
11682: || '/'
11683: || p_upd_var_rent_rec.type_code);
11684: pn_varen_util.pvt_debug
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');
11693: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
11694: , p_upd_var_rent_rec.type_meaning
11695: || '/'
11696: || p_upd_var_rent_rec.type_code);
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');
11693: fnd_message.set_token ('VOLUME_TYPE_CODE_MEANING'
11694: , p_upd_var_rent_rec.type_meaning
11695: || '/'
11696: || p_upd_var_rent_rec.type_code);
11697: pn_varen_util.pvt_debug
11763: , 3);
11764:
11765: IF (x_return_status = fnd_api.g_ret_sts_error)
11766: THEN
11767: fnd_message.set_name ('PN', 'PN_VAR_PUR_CODE');
11768: fnd_message.set_token ('PURPOSE_CODE_MEANING'
11769: , p_upd_var_rent_rec.purpose_code_meaning
11770: || '/'
11771: || p_upd_var_rent_rec.purpose_code);
11764:
11765: IF (x_return_status = fnd_api.g_ret_sts_error)
11766: THEN
11767: fnd_message.set_name ('PN', 'PN_VAR_PUR_CODE');
11768: fnd_message.set_token ('PURPOSE_CODE_MEANING'
11769: , p_upd_var_rent_rec.purpose_code_meaning
11770: || '/'
11771: || p_upd_var_rent_rec.purpose_code);
11772: pn_varen_util.pvt_debug
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');
11781: fnd_message.set_token ('PURPOSE_CODE_MEANING'
11782: , p_upd_var_rent_rec.purpose_code_meaning
11783: || '/'
11784: || p_upd_var_rent_rec.purpose_code);
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');
11781: fnd_message.set_token ('PURPOSE_CODE_MEANING'
11782: , p_upd_var_rent_rec.purpose_code_meaning
11783: || '/'
11784: || p_upd_var_rent_rec.purpose_code);
11785: pn_varen_util.pvt_debug
12118: || p_validate_flag
12119: , 3);
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;
12119: , 3);
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:
12137: || x_return_status
12138: , 3);
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;
12138: , 3);
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
12301: , 3);
12302:
12303: IF (x_return_status = fnd_api.g_ret_sts_error)
12304: THEN
12305: fnd_message.set_name ('PN', 'PN_VAR_PERIOD_SET_TYPE');
12306: fnd_message.set_token ('PERIOD_SET_TYPE'
12307: , p_upd_var_rent_rec.gl_period_set_name
12308: || '/'
12309: || p_upd_var_rent_rec.period_type);
12302:
12303: IF (x_return_status = fnd_api.g_ret_sts_error)
12304: THEN
12305: fnd_message.set_name ('PN', 'PN_VAR_PERIOD_SET_TYPE');
12306: fnd_message.set_token ('PERIOD_SET_TYPE'
12307: , p_upd_var_rent_rec.gl_period_set_name
12308: || '/'
12309: || p_upd_var_rent_rec.period_type);
12310: pn_varen_util.pvt_debug
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');
12321: fnd_message.set_token ('PERIOD_SET_TYPE'
12322: , p_upd_var_rent_rec.gl_period_set_name
12323: || '/'
12324: || p_upd_var_rent_rec.period_type);
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');
12321: fnd_message.set_token ('PERIOD_SET_TYPE'
12322: , p_upd_var_rent_rec.gl_period_set_name
12323: || '/'
12324: || p_upd_var_rent_rec.period_type);
12325: pn_varen_util.pvt_debug
12419: , 3);
12420:
12421: IF (x_return_status = fnd_api.g_ret_sts_error)
12422: THEN
12423: fnd_message.set_name ('PN', 'PN_VAR_VRG_REPT_CODE');
12424: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
12425: , p_upd_var_rent_rec.vrg_reptg_freq_meaning
12426: || '/'
12427: || p_upd_var_rent_rec.vrg_reptg_freq_code);
12420:
12421: IF (x_return_status = fnd_api.g_ret_sts_error)
12422: THEN
12423: fnd_message.set_name ('PN', 'PN_VAR_VRG_REPT_CODE');
12424: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
12425: , p_upd_var_rent_rec.vrg_reptg_freq_meaning
12426: || '/'
12427: || p_upd_var_rent_rec.vrg_reptg_freq_code);
12428: pn_varen_util.pvt_debug
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');
12438: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
12439: , p_upd_var_rent_rec.vrg_reptg_freq_meaning
12440: || '/'
12441: || p_upd_var_rent_rec.vrg_reptg_freq_code);
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');
12438: fnd_message.set_token ('VRG_REPTG_FREQ_CODE_MEANING'
12439: , p_upd_var_rent_rec.vrg_reptg_freq_meaning
12440: || '/'
12441: || p_upd_var_rent_rec.vrg_reptg_freq_code);
12442: pn_varen_util.pvt_debug
12519: , 3);
12520:
12521: IF (x_return_status = fnd_api.g_ret_sts_error)
12522: THEN
12523: fnd_message.set_name ('PN', 'PN_VAR_REPT_CODE');
12524: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
12525: , p_upd_var_rent_rec.reptg_freq_meaning
12526: || '/'
12527: || p_upd_var_rent_rec.reptg_freq_code);
12520:
12521: IF (x_return_status = fnd_api.g_ret_sts_error)
12522: THEN
12523: fnd_message.set_name ('PN', 'PN_VAR_REPT_CODE');
12524: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
12525: , p_upd_var_rent_rec.reptg_freq_meaning
12526: || '/'
12527: || p_upd_var_rent_rec.reptg_freq_code);
12528: pn_varen_util.pvt_debug
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');
12537: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
12538: , p_upd_var_rent_rec.reptg_freq_meaning
12539: || '/'
12540: || p_upd_var_rent_rec.reptg_freq_code);
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');
12537: fnd_message.set_token ('REPTG_FREQ_CODE_MEANING'
12538: , p_upd_var_rent_rec.reptg_freq_meaning
12539: || '/'
12540: || p_upd_var_rent_rec.reptg_freq_code);
12541: pn_varen_util.pvt_debug
12580: IF p_upd_var_rent_rec.reptg_day_of_month < 1
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;
12604: IF p_upd_var_rent_rec.reptg_days_after < 1
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;
12644: IF p_upd_var_rent_rec.invg_day_of_month < 1
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;
12737: , 3);
12738:
12739: IF (x_return_status = fnd_api.g_ret_sts_error)
12740: THEN
12741: fnd_message.set_name ('PN', 'PN_VAR_INVG_FREQ_CODE');
12742: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
12743: , p_upd_var_rent_rec.invg_freq_meaning
12744: || '/'
12745: || p_upd_var_rent_rec.invg_freq_code);
12738:
12739: IF (x_return_status = fnd_api.g_ret_sts_error)
12740: THEN
12741: fnd_message.set_name ('PN', 'PN_VAR_INVG_FREQ_CODE');
12742: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
12743: , p_upd_var_rent_rec.invg_freq_meaning
12744: || '/'
12745: || p_upd_var_rent_rec.invg_freq_code);
12746: pn_varen_util.pvt_debug
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
12755: fnd_message.set_name ('PN', 'PN_VAR_INVG_FREQ_CODE');
12756: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
12757: , p_upd_var_rent_rec.invg_freq_meaning
12758: || '/'
12759: || p_upd_var_rent_rec.invg_freq_code);
12752: --x_return_status := fnd_api.g_ret_sts_error;
12753: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
12754: THEN
12755: fnd_message.set_name ('PN', 'PN_VAR_INVG_FREQ_CODE');
12756: fnd_message.set_token ('INVG_FREQ_CODE_MEANING'
12757: , p_upd_var_rent_rec.invg_freq_meaning
12758: || '/'
12759: || p_upd_var_rent_rec.invg_freq_code);
12760: pn_varen_util.pvt_debug
12898:
12899:
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
12899:
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');
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');
12909: fnd_msg_pub.ADD;
12910: RAISE fnd_api.g_exc_unexpected_error;
12911: END IF;
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');
12909: fnd_msg_pub.ADD;
12910: RAISE fnd_api.g_exc_unexpected_error;
12911: END IF;
12912: END IF;
13206: || p_validate_flag
13207: , 3);
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;
13207: , 3);
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:
13232: || x_return_status
13233: , 3);
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
13233: , 3);
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');
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');
13243: fnd_msg_pub.ADD;
13244: RAISE fnd_api.g_exc_unexpected_error;
13245: END IF;
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');
13243: fnd_msg_pub.ADD;
13244: RAISE fnd_api.g_exc_unexpected_error;
13245: END IF;
13246:
13322: || x_return_status
13323: , 3);
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;
13323: , 3);
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;
13361:
13362: IF (x_return_status = fnd_api.g_ret_sts_error)
13363: THEN
13364: --
13365: fnd_message.set_name ('PN', 'PN_VAR_LIN_SAL_CHL');
13366: --x_return_status :=fnd_api.g_ret_sts_error;
13367: pn_varen_util.pvt_debug
13368: ( 'PN_VAREN_PVT: Update_Var_Rent: SALES_CHANNEL (Type 1) Meaning Expected Error :'
13369: || p_var_rent_lines_tbl (ul).sales_channel_meaning
13376: --
13377: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13378: THEN
13379: --
13380: fnd_message.set_name ('PN', 'PN_VAR_LIN_SAL_CHL');
13381: --x_return_status := fnd_api.g_ret_sts_unexp_error;
13382: pn_varen_util.pvt_debug
13383: ( 'PN_VAREN_PVT: Update_Var_Rent: SALES_CHANNEL (Type 1) Meaning Un-Expected Error :'
13384: || p_var_rent_lines_tbl (ul).sales_channel_meaning
13443:
13444: IF (x_return_status = fnd_api.g_ret_sts_error)
13445: THEN
13446: --
13447: fnd_message.set_name ('PN', 'PN_VAR_LIN_ITM_CAY');
13448: x_return_status := fnd_api.g_ret_sts_error;
13449: pn_varen_util.pvt_debug
13450: ('PN_VAREN_PVT: Update_Var_Rent: Item Category Lookup Validation Error'
13451: , 3);
13458: --
13459: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
13460: THEN
13461: --
13462: fnd_message.set_name ('PN', 'PN_VAR_LIN_ITM_CAY');
13463: --x_return_status :=fnd_api.g_ret_sts_unexp_error;
13464: pn_varen_util.pvt_debug
13465: ( 'PN_VAREN_PVT: Update_Var_Rent: Item Category Lookup Validation Unexpected Error :'
13466: || p_var_rent_lines_tbl (ul).item_category_meaning
13736: , x_return_status => x_return_status
13737: );
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
13737: );
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');
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);
13747: fnd_msg_pub.ADD;
13748: RAISE fnd_api.g_exc_unexpected_error;
13749: END IF;
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);
13747: fnd_msg_pub.ADD;
13748: RAISE fnd_api.g_exc_unexpected_error;
13749: END IF;
13750: END IF;
14052: || x_return_status
14053: , 3);
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;
14053: , 3);
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
14075: || x_return_status
14076: , 3);
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;
14076: , 3);
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
14183:
14184: IF (x_return_status = fnd_api.g_ret_sts_error)
14185: THEN
14186: --
14187: fnd_message.set_name ('PN', 'PN_VAR_BKHD_BRK_TY');
14188: --x_return_status := fnd_api.g_ret_sts_error;
14189: pn_varen_util.pvt_debug
14190: ( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Meaning Expected Error :'
14191: || p_breakpoint_header_tbl (ubk).break_type_meaning
14198: --
14199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
14200: THEN
14201: --
14202: fnd_message.set_name ('PN', 'PN_VAR_BKHD_BRK_TY');
14203: --x_return_status := fnd_api.g_ret_sts_unexp_error;
14204: pn_varen_util.pvt_debug
14205: ( 'PN_VAREN_PVT: Update_Var_Rent: BREAK_TYPE Meaning Un-Expected Error :'
14206: || p_breakpoint_header_tbl (ubk).break_type_meaning
14273:
14274: IF (x_return_status = fnd_api.g_ret_sts_error)
14275: THEN
14276: --
14277: fnd_message.set_name ('PN', 'PN_VAR_BKHD_BKPT_TY');
14278: x_return_status := fnd_api.g_ret_sts_error;
14279: pn_varen_util.pvt_debug
14280: ( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Meaning Expected Error :'
14281: || p_breakpoint_header_tbl (ubk).breakpoint_type_meaning
14288: --
14289: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
14290: THEN
14291: --
14292: fnd_message.set_name ('PN', 'PN_VAR_BKHD_BKPT_TY');
14293: --x_return_status := fnd_api.g_ret_sts_unexp_error;
14294: pn_varen_util.pvt_debug
14295: ( 'PN_VAREN_PVT: Update_Var_Rent: BREAKPOINT_TYPE Meaning Un-Expected Error :'
14296: || p_breakpoint_header_tbl (ubk).breakpoint_type_meaning
14329: IF p_breakpoint_header_tbl (ubk).break_type_code = 'NATURAL'
14330: THEN
14331: IF p_breakpoint_header_tbl (ubk).breakpoint_type_code <> 'FLAT'
14332: THEN
14333: fnd_message.set_name ('PN', 'PN_VAR_BKHD_BT_BKPT_TY');
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);
14573: , x_return_status => x_return_status
14574: );
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
14574: );
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');
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);
14584: fnd_msg_pub.ADD;
14585: RAISE fnd_api.g_exc_unexpected_error;
14586: END IF;
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);
14584: fnd_msg_pub.ADD;
14585: RAISE fnd_api.g_exc_unexpected_error;
14586: END IF;
14587: END IF;
14611: IF p_breakpoint_header_tbl (ubk).bkhd_start_date
14613: THEN
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;
14612: OR p_breakpoint_header_tbl (ubk).bkhd_end_date >l_pn_var_rents_rec.termination_date
14613: THEN
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;
14613: THEN
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:
14637: pn_varen_util.pvt_debug('PN_VAREN_PVT:Remove any overlap in the breakpoint Headers',3);
14638: END;
14639:
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;
14638: END;
14639:
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;
14639:
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:
14657: (p_breakpoint_header_rec_type => p_breakpoint_header_tbl (ubk)
14658: , x_return_status => x_return_status);
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;
14658: , x_return_status => x_return_status);
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;
14687: || x_return_status
14688: , 3);
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;
14688: , 3);
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:
15030: , x_return_status => x_return_status
15031: );
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
15031: );
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');
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);
15041: fnd_msg_pub.ADD;
15042: RAISE fnd_api.g_exc_unexpected_error;
15043: END IF;
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);
15041: fnd_msg_pub.ADD;
15042: RAISE fnd_api.g_exc_unexpected_error;
15043: END IF;
15044: END IF;
15056: IF p_breakpoint_details_tbl (ubd).bkdt_start_date
15058: THEN
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;
15057: OR p_breakpoint_details_tbl (ubd).bkdt_end_date >l_pn_var_rents_rec.termination_date
15058: THEN
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;
15058: THEN
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;
15077: pn_varen_util.pvt_debug('PN_VAREN_PVT:Remove any overlap in the breakpoint details',3);
15078: END;
15079:
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;
15078: END;
15079:
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;
15079:
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'
15102: || x_return_status
15103: , 3);
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;
15103: , 3);
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
15113: (p_breakpoint_details_rec_type => p_breakpoint_details_tbl (ubd)
15114: , x_return_status => x_return_status);
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;
15114: , x_return_status => x_return_status);
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;
15376: ELSIF ( p_constraints_tbl (uc).constr_start_date < l_var_commencement_date
15377: OR p_constraints_tbl (uc).constr_start_date > l_var_termination_date)
15378: THEN
15379: --
15380: fnd_message.set_name ('PN', 'PN_VAR_CONSTR_STRDT_VAL_MSG');
15381: pn_varen_util.pvt_debug
15382: ( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error :'
15383: || p_constraints_tbl (uc).constr_start_date
15384: || 'Please enter a constraint start date that is the same as or after the commencement date of the variable rent agreement.'
15397: -- 'N';
15398: ELSIF (p_constraints_tbl (uc).constr_start_date > l_var_commencement_date)
15399: THEN
15400: --
15401: fnd_message.set_name ('PN', 'PN_VAR_CONSTR_STRDT_VAL_MSG');
15402: --x_return_status :=fnd_api.g_ret_sts_error;
15403: pn_varen_util.pvt_debug
15404: ( 'PN_VAREN_PVT: Update_Var_Rent: Constratint Start Date Validation Error :'
15405: || p_constraints_tbl (uc).constr_start_date
15471: ELSIF ( p_constraints_tbl (uc).constr_end_date > l_var_termination_date
15472: OR p_constraints_tbl (uc).constr_end_date < l_var_commencement_date)
15473: THEN
15474: --
15475: fnd_message.set_name ('PN', 'PN_VAR_CONSTR_ENDDT_VAL_MSG');
15476: --x_return_status := fnd_api.g_ret_sts_error;
15477: pn_varen_util.pvt_debug
15478: ( 'PN_VAREN_PVT: Update_Var_Rent: Constratint end Date Validation Error :'
15479: || p_constraints_tbl (uc).constr_end_date
15492: -- 'N';
15493: ELSIF (p_constraints_tbl (uc).constr_end_date < l_var_termination_date)
15494: THEN
15495: --
15496: fnd_message.set_name ('PN', 'PN_VAR_CONSTR_ENDDT_VAL_MSG');
15497: --x_return_status := fnd_api.g_ret_sts_error;
15498: pn_varen_util.pvt_debug
15499: ( 'PN_VAREN_PVT: Update_Var_Rent: Constraint end Date Validation Error :'
15500: || p_constraints_tbl (uc).constr_end_date
15593:
15594: IF (x_return_status = fnd_api.g_ret_sts_error)
15595: THEN
15596: --
15597: fnd_message.set_name ('PN', 'PN_VAR_CONSTR_TY');
15598: --x_return_status := fnd_api.g_ret_sts_error;
15599: pn_varen_util.pvt_debug
15600: ( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Type Meaning Expected Error :'
15601: || p_constraints_tbl (uc).constr_type_meaning
15611: --
15612: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
15613: THEN
15614: --
15615: fnd_message.set_name ('PN', 'PN_VAR_CONSTR_TY');
15616: --x_return_status := fnd_api.g_ret_sts_unexp_error;
15617: pn_varen_util.pvt_debug
15618: ( 'PN_VAREN_PVT: Update_Var_Rent: Constraint Type Meaning Un-Expected Error :'
15619: || p_constraints_tbl (uc).constr_type_meaning
15884: , x_return_status => x_return_status
15885: );
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
15885: );
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');
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);
15895: fnd_msg_pub.ADD;
15896: RAISE fnd_api.g_exc_unexpected_error;
15897: END IF;
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);
15895: fnd_msg_pub.ADD;
15896: RAISE fnd_api.g_exc_unexpected_error;
15897: END IF;
15898: END IF;
15954: || x_return_status
15955: , 3);
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;
15955: , 3);
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;
15966: --1234
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
15993: || x_return_status
15994: , 3);
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;
15994: , 3);
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
16108: , 3);
16109:
16110: IF (x_return_status = fnd_api.g_ret_sts_error)
16111: THEN
16112: fnd_message.set_name ('PN', 'PN_VAR_ALL_ABA_TY');
16113: --x_return_status := fnd_api.g_ret_sts_error;
16114: pn_varen_util.pvt_debug
16115: ( 'PN_VAR_RENT_PVT: Update_Var_Rent: Please provide correct Allowance and Abatements Type Code Expected Error :'
16116: || p_allow_abat_tbl (ua).abat_type_meaning
16137: , 3);
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: --
16189: --
16190: l_upd_allow_abat_val := 'N';
16191: --x_return_status := fnd_api.g_ret_sts_error;
16192: --
16193: fnd_message.set_name ('PN', 'PN_ST_DT_INV_MSG');
16194: pn_varen_util.pvt_debug
16195: ( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowances and abatements must start on the same date as the invoice period.Please change the allowance or abatement start date. '
16196: || p_allow_abat_tbl (ua).abat_start_date
16197: || ' and '
16244: --
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
16258: --
16259: ELSIF (p_allow_abat_tbl (ua).abat_start_date > p_allow_abat_tbl (ua).abat_end_date)
16260: THEN
16261: --
16262: fnd_message.set_name ('PN', 'PN_STR_GRT_END_DT');
16263: pn_varen_util.pvt_debug
16264: ( 'PN_VAR_RENT_PVT: Update_Var_Rent: Allowance and Abatement Start date Validation Error : '
16265: || p_allow_abat_tbl (ua).abat_start_date
16266: || ' and '
16331: || p_allow_abat_tbl (ua).abat_end_date
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: --
16348: || p_allow_abat_tbl (ua).abat_end_date
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
16592: , x_return_status => x_return_status
16593: );
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
16593: );
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');
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');
16603: fnd_msg_pub.ADD;
16604: RAISE fnd_api.g_exc_unexpected_error;
16605: END IF;
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');
16603: fnd_msg_pub.ADD;
16604: RAISE fnd_api.g_exc_unexpected_error;
16605: END IF;
16606: END IF;
16642: , p_validate_flag => p_validate_flag
16643: , x_return_status => x_return_status);
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
16643: , x_return_status => x_return_status);
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';
16675: || x_return_status
16676: , 3);
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;
16676: , 3);
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