eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_INDEX_RENT_PVT dependencies on FND_MSG_PUB

Line 197: fnd_msg_pub.ADD;

193: IF (x_return_status = fnd_api.g_ret_sts_error)
194: THEN
195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
196: fnd_message.set_token('ERR_MSG', 'Index Rent constraints descriptive flexfield validation failed due to an error');
197: fnd_msg_pub.ADD;
198: RAISE fnd_api.g_exc_error;
199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
200: THEN
201: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 203: fnd_msg_pub.ADD;

199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
200: THEN
201: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
202: fnd_message.set_token('ERR_MSG', 'Index Rent constraints descriptive flexfield validation failed due to an unexpected error');
203: fnd_msg_pub.ADD;
204: RAISE fnd_api.g_exc_unexpected_error;
205: END IF;
206: END IF;
207: END IF; -- End of attributes valitions in Index Rent Constraints attributes

Line 354: fnd_msg_pub.ADD;

350: IF (x_return_status = fnd_api.g_ret_sts_error)
351: THEN
352: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
353: fnd_message.set_token('ERR_MSG', 'Index Rent descriptive flexfield validation failed due to an error');
354: fnd_msg_pub.ADD;
355: RAISE fnd_api.g_exc_error;
356: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
357: THEN
358: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 360: fnd_msg_pub.ADD;

356: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
357: THEN
358: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
359: fnd_message.set_token('ERR_MSG', 'Index Rent descriptive flexfield validation failed due to an unexpected error');
360: fnd_msg_pub.ADD;
361: RAISE fnd_api.g_exc_unexpected_error;
362: END IF;
363: END IF;
364: END IF; -- End of attributes valitions in Index Rent attribute

Line 496: fnd_msg_pub.ADD;

492: IF (x_return_status = fnd_api.g_ret_sts_error)
493: THEN
494: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
495: fnd_message.set_token('ERR_MSG', 'Index Rent agreement descriptive flexfield validation failed due to an error');
496: fnd_msg_pub.ADD;
497: RAISE fnd_api.g_exc_error;
498: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
499: THEN
500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 502: fnd_msg_pub.ADD;

498: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
499: THEN
500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
501: fnd_message.set_token('ERR_MSG', 'Index Rent agreement descriptive flexfield validation failed due to an unexpected error');
502: fnd_msg_pub.ADD;
503: RAISE fnd_api.g_exc_unexpected_error;
504: END IF;
505: END IF;
506: END IF; -- End of attributes valitions in Index Rent agreement attribute

Line 1637: fnd_msg_pub.ADD;

1633: IF (x_return_status <> 'SUCCESS_FIRE_RECALC' AND
1634: x_return_status <> 'S') THEN
1635: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
1636: fnd_message.set_token('ERR_MSG', 'Update location for IR terms failed with status: '||x_return_status);
1637: fnd_msg_pub.ADD;
1638: RAISE fnd_api.g_exc_error;
1639: END IF;
1640: END IF;
1641: END IF;

Line 1662: fnd_msg_pub.ADD;

1658: IF (x_return_status <> 'SUCCESS_FIRE_RECALC' AND
1659: x_return_status <> 'S') THEN
1660: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
1661: fnd_message.set_token('ERR_MSG', 'Update location for IR terms failed with status: '||x_return_status);
1662: fnd_msg_pub.ADD;
1663: RAISE fnd_api.g_exc_error;
1664: END IF;
1665: END IF;
1666: END IF;

Line 2145: fnd_msg_pub.ADD;

2141: IF x_return_status<>fnd_api.g_ret_sts_success
2142: THEN
2143: l_error_count:=l_error_count+1;
2144: fnd_message.set_name('PN','PN_INDEX_UPDATE_REQD_DATA');
2145: fnd_msg_pub.ADD;
2146: RAISE fnd_api.g_exc_error;
2147: END IF;
2148: END IF;
2149: --END IF;

Line 2181: fnd_msg_pub.ADD;

2177: IF x_return_status IS NOT NULL AND x_return_status<>fnd_api.g_ret_sts_success
2178: THEN
2179: l_error_count:=l_error_count+1;
2180: fnd_message.set_name('PN','PN_DUP_INDEX_LEASE_NUMBER');
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2184: END IF;
2185: END IF;

Line 2258: fnd_msg_pub.ADD;

2254: THEN
2255: l_error_count:=l_error_count+1;
2256: fnd_message.set_name('PN','PN_LEASE_ID');
2257: fnd_message.set_token (' ID', p_rent_index_rec.lease_id);
2258: fnd_msg_pub.ADD;
2259: RAISE fnd_api.g_exc_error;
2260: END IF;
2261: END IF;
2262:

Line 2292: fnd_msg_pub.ADD;

2288: IF x_return_status<>fnd_api.g_ret_sts_success
2289: THEN
2290: l_error_count:=l_error_count+1;
2291: fnd_message.set_name('PN','PN_LOCATION_NOT_EXIST');
2292: fnd_msg_pub.ADD;
2293: RAISE fnd_api.g_exc_error;
2294: END IF;
2295: END IF;
2296:

Line 2324: fnd_msg_pub.ADD;

2320: IF x_return_status<>fnd_api.g_ret_sts_success
2321: THEN
2322: l_error_count:=l_error_count+1;
2323: fnd_message.set_name('PN','PN_INDEX_TYPE_NOT_EXISTS');
2324: fnd_msg_pub.ADD;
2325: RAISE fnd_api.g_exc_error;
2326: END IF;
2327: END IF;
2328:

Line 2371: fnd_msg_pub.ADD;

2367: , NVL (l_lease_extension_end_date, l_lease_termination_date))))
2368: THEN
2369: l_error_count:=l_error_count+1;
2370: fnd_message.set_name ('PN', 'PN_INDEX_COMMENCE_TERMINATE_DT');
2371: fnd_msg_pub.ADD;
2372: RAISE fnd_api.g_exc_error;
2373: END IF;
2374:
2375: IF (p_rent_index_rec.termination_date < p_rent_index_rec.commencement_date)

Line 2379: fnd_msg_pub.ADD;

2375: IF (p_rent_index_rec.termination_date < p_rent_index_rec.commencement_date)
2376: THEN
2377: l_error_count:=l_error_count+1;
2378: fnd_message.set_name ('PN', 'PN_INDEX_TERMINATION_DT');
2379: fnd_msg_pub.ADD;
2380: RAISE fnd_api.g_exc_error;
2381: END IF;
2382:
2383: IF ( (p_rent_index_rec.termination_date < l_lease_commencement_date)

Line 2390: fnd_msg_pub.ADD;

2386: , NVL (l_lease_extension_end_date, l_lease_termination_date))))
2387: THEN
2388: l_error_count:=l_error_count+1;
2389: fnd_message.set_name ('PN', 'PN_INDEX_COMMENCE_TERMINATE_DT');
2390: fnd_msg_pub.ADD;
2391: RAISE fnd_api.g_exc_error;
2392: END IF;
2393:
2394: IF (p_rent_index_rec.termination_date < p_rent_index_rec.commencement_date)

Line 2398: fnd_msg_pub.ADD;

2394: IF (p_rent_index_rec.termination_date < p_rent_index_rec.commencement_date)
2395: THEN
2396: l_error_count:=l_error_count+1;
2397: fnd_message.set_name ('PN', 'PN_INDEX_TERMINATION_DT');
2398: fnd_msg_pub.ADD;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;
2401:
2402: --ELSE

Line 2443: fnd_msg_pub.ADD;

2439: IF x_return_status <> fnd_api.g_ret_sts_success
2440: THEN
2441: l_error_count:=l_error_count+1;
2442: fnd_message.set_name ('PN','PN_INDEX_USER_NOT_EXISTS');
2443: fnd_msg_pub.ADD;
2444: RAISE fnd_api.g_exc_error;
2445: END IF;
2446: END IF;
2447:

Line 2475: fnd_msg_pub.ADD;

2471: IF x_return_status<>fnd_api.g_ret_sts_success
2472: THEN
2473: l_error_count:=l_error_count+1;
2474: fnd_message.set_name('PN','PN_CURRENCY_CODE_NOT_EXIST');
2475: fnd_msg_pub.ADD;
2476: RAISE fnd_api.g_exc_error;
2477: END IF;
2478: END IF;*/
2479: p_rent_index_rec.currency_code:= l_func_curr_code;

Line 2504: fnd_msg_pub.ADD;

2500: OR l_mod <> 0
2501: THEN
2502: l_error_count:=l_error_count+1;
2503: fnd_message.set_name ('PN', 'PN_INVALID_ASSESS_YEAR');
2504: fnd_msg_pub.ADD;
2505: RAISE fnd_api.g_exc_error;
2506: END IF;
2507: ELSE
2508: p_rent_index_rec.assessment_interval := 1;

Line 2550: fnd_msg_pub.ADD;

2546: IF x_return_status<>fnd_api.g_ret_sts_success
2547: THEN
2548: l_error_count:=l_error_count+1;
2549: fnd_message.set_name('PN','PN_INDEX_INCREASE_ON_NOT_EXIST');
2550: fnd_msg_pub.ADD;
2551: RAISE fnd_api.g_exc_error;
2552: END IF;
2553:
2554: END IF;

Line 2593: fnd_msg_pub.ADD;

2589: IF x_return_status<>fnd_api.g_ret_sts_success
2590: THEN
2591: l_error_count:=l_error_count+1;
2592: fnd_message.set_name('PN','PN_INDEX_REFERENCE_PERIOD');
2593: fnd_msg_pub.ADD;
2594: RAISE fnd_api.g_exc_error;
2595: END IF;
2596: ELSE
2597: IF LTRIM (RTRIM (p_operation)) <> 'UPDATE_INDEX_RENT'

Line 2633: fnd_msg_pub.ADD;

2629: IF x_return_status<>fnd_api.g_ret_sts_success
2630: THEN
2631: l_error_count:=l_error_count+1;
2632: fnd_message.set_name('PN','PN_INDEX_BASIS_TYPE_NOT_EXISTS');
2633: fnd_msg_pub.ADD;
2634: RAISE fnd_api.g_exc_error;
2635: END IF;
2636: END IF;
2637:

Line 2667: fnd_msg_pub.ADD;

2663: IF x_return_status<>fnd_api.g_ret_sts_success
2664: THEN
2665: l_error_count:=l_error_count+1;
2666: fnd_message.set_name('PN','PN_INDEX_FINDER_NOT_EXISTS');
2667: fnd_msg_pub.ADD;
2668: RAISE fnd_api.g_exc_error;
2669: END IF;
2670: ELSE
2671: IF LTRIM (RTRIM (p_operation)) <> 'UPDATE_INDEX_RENT'

Line 2707: fnd_msg_pub.ADD;

2703: IF x_return_status<>fnd_api.g_ret_sts_success
2704: THEN
2705: l_error_count:=l_error_count+1;
2706: fnd_message.set_name('PN','PN_INDEX_RELATION_NOT_EXISTS');
2707: fnd_msg_pub.ADD;
2708: RAISE fnd_api.g_exc_error;
2709: END IF;
2710: END IF;
2711:

Line 2756: fnd_msg_pub.ADD;

2752: IF x_return_status<>fnd_api.g_ret_sts_success
2753: THEN
2754: l_error_count:=l_error_count+1;
2755: fnd_message.set_name('PN','PN_INDEX_TERM_TEMPL_NOT_EXISTS');
2756: fnd_msg_pub.ADD;
2757: RAISE fnd_api.g_exc_error;
2758: END IF;
2759: --END IF;
2760:

Line 2782: fnd_msg_pub.ADD;

2778: THEN
2779: l_error_count:=l_error_count+1;
2780: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2781: fnd_message.set_token('ERR_MSG', 'Both Term Template and Agreement Flag have been provided. Please provide either Term Template or Agreement Flag');
2782: fnd_msg_pub.ADD;
2783: RAISE fnd_api.g_exc_error;
2784:
2785: END IF;
2786: ----

Line 2800: fnd_msg_pub.ADD;

2796:
2797: l_error_count:=l_error_count+1;
2798: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
2799: fnd_message.set_token('ERR_MSG','The Term Template is required when index commencement date is same as lease commencement date. Please provided a valid term template');
2800: fnd_msg_pub.ADD;
2801: RAISE fnd_api.g_exc_error;
2802: END IF;
2803:
2804: ELSIF (( p_rent_index_rec.term_template_id IS NOT NULL

Line 2838: fnd_msg_pub.ADD;

2834: IF x_return_status<>fnd_api.g_ret_sts_success
2835: THEN
2836: l_error_count:=l_error_count+1;
2837: fnd_message.set_name('PN','PN_INDEX_NEGTV_RENT_NOT_EXISTS');
2838: fnd_msg_pub.ADD;
2839: RAISE fnd_api.g_exc_error;
2840: END IF;
2841: END IF;
2842:

Line 2881: fnd_msg_pub.ADD;

2877: IF x_return_status<>fnd_api.g_ret_sts_success
2878: THEN
2879: l_error_count:=l_error_count+1;
2880: fnd_message.set_name('PN','PN_INDEX_SPREAD_FRQ_NOT_EXISTS');
2881: fnd_msg_pub.ADD;
2882: --RAISE fnd_api.g_exc_error;
2883: END IF;
2884: END IF;
2885:

Line 2914: fnd_msg_pub.ADD;

2910: IF MOD (p_rent_index_rec.index_finder_months, 1) <> 0
2911: THEN
2912: l_error_count:=l_error_count+1;
2913: fnd_message.set_name ('PN', 'PN_INVALID_ASSESS_YEAR');
2914: fnd_msg_pub.ADD;
2915: RAISE fnd_api.g_exc_error;
2916:
2917: END IF;
2918: ELSE

Line 2942: fnd_msg_pub.ADD;

2938: OR p_rent_index_rec.initial_basis =pn_lease_utils.g_pn_miss_num)
2939: THEN
2940: l_error_count:=l_error_count+1;
2941: fnd_message.set_name ('PN', 'PN_INDEX_INIT_BASIS_REQD');
2942: fnd_msg_pub.ADD;
2943: RAISE fnd_api.g_exc_error;
2944: --ELSE
2945: -- IF ( p_rent_index_rec.initial_basis IS NULL
2946: -- AND pn_r12_util_pkg.is_r12)

Line 2973: fnd_msg_pub.ADD;

2969: IF p_rent_index_rec.index_multiplier <= 0
2970: THEN
2971: l_error_count:=l_error_count+1;
2972: fnd_message.set_name ('PN', 'PN_ZERO_INDEX_MULTIPLIER');
2973: fnd_msg_pub.ADD;
2974: RAISE fnd_api.g_exc_error;
2975: END IF;
2976: END IF;
2977:

Line 3033: fnd_msg_pub.ADD;

3029: IF x_return_status<>fnd_api.g_ret_sts_success
3030: THEN
3031: l_error_count:=l_error_count+1;
3032: fnd_message.set_name('PN','PN_INDEX_PRARATION_NOT_EXISTS');
3033: fnd_msg_pub.ADD;
3034: RAISE fnd_api.g_exc_error;
3035: END IF;
3036: END IF;
3037: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 3118: fnd_msg_pub.ADD;

3114: l_error_count:=l_error_count+1;
3115: --fnd_message.set_name ('PN', 'PN_INVALID_BASIS_TYPE');
3116: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3117: fnd_message.set_token('ERR_MSG', 'Please provide ROLLING\COMPOUND basis type for default reference period(Previous Year - Use Previous Current Index )');
3118: fnd_msg_pub.ADD;
3119: RAISE fnd_api.g_exc_error;
3120: ELSIF p_rent_index_rec.reference_period = 'BASE_YEAR'
3121: AND p_rent_index_rec.basis_type <> 'FIXED'
3122: THEN

Line 3125: fnd_msg_pub.ADD;

3121: AND p_rent_index_rec.basis_type <> 'FIXED'
3122: THEN
3123: l_error_count:=l_error_count+1;
3124: fnd_message.set_name ('PN', 'PN_INVALID_BASIS_TYPE');
3125: fnd_msg_pub.ADD;
3126: RAISE fnd_api.g_exc_error;
3127: END IF;
3128:
3129: -- Added by Vivek on 22Nov2010

Line 3139: fnd_msg_pub.ADD;

3135: THEN
3136: l_error_count:=l_error_count+1;
3137: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3138: fnd_message.set_token('ERR_MSG', 'Invalid basis type for the provided reference period: '||p_rent_index_rec.reference_period);
3139: fnd_msg_pub.ADD;
3140: ELSIF NVL(p_rent_index_rec.reference_period,'PREV_YEAR_PREV_CURRENT_CPI') <> 'BASE_YEAR'
3141: AND p_rent_index_rec.basis_type NOT IN ( 'ROLLING','COMPOUND')
3142: THEN
3143: l_error_count:=l_error_count+1;

Line 3146: fnd_msg_pub.ADD;

3142: THEN
3143: l_error_count:=l_error_count+1;
3144: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3145: fnd_message.set_token('ERR_MSG', 'Invalid basis type for the provided reference period: '||p_rent_index_rec.reference_period);
3146: fnd_msg_pub.ADD;
3147: --END IF;
3148: END IF;
3149:
3150: END IF;

Line 3173: fnd_msg_pub.ADD;

3169: l_error_count:=l_error_count+1;
3170: --fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_INDEX_ONLY');--PN_INDEX_BASE_INDEX_REQUIRED
3171: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3172: fnd_message.set_token('ERR_MSG', 'The Rent Increase Amount cannot be calculated. For an Index Only relation, the Index Id and Base Index are required');
3173: fnd_msg_pub.ADD;
3174: RAISE fnd_api.g_exc_error;
3175: END IF;
3176:
3177:

Line 3184: fnd_msg_pub.ADD;

3180: THEN
3181: l_error_count:=l_error_count+1;
3182: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3183: fnd_message.set_token('ERR_MSG', 'Base Year should be provided when relationship default is '||p_rent_index_rec.relationship_default);
3184: fnd_msg_pub.ADD;
3185: RAISE fnd_api.g_exc_error;
3186: END IF;
3187:
3188: ELSIF p_rent_index_rec.relationship_default IS NOT NULL

Line 3198: --fnd_msg_pub.ADD;

3194: -- OR p_rent_index_rec.basis_percent_default=pn_index_rent_utils.g_pn_miss_num
3195: --THEN
3196: --l_error_count:=l_error_count+1;
3197: --fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_BASIS_ONLY');
3198: --fnd_msg_pub.ADD;
3199: --RAISE fnd_api.g_exc_error;
3200: -- p_rent_index_rec.basis_percent_default:=0;
3201:
3202: --END IF;

Line 3230: fnd_msg_pub.ADD;

3226: OR p_rent_index_rec.base_Index =pn_index_rent_utils.g_pn_miss_num)
3227: THEN
3228: l_error_count:=l_error_count+1;
3229: fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_GT_LT_ONLY'); --PN_INVALID_BASIS_TYPE
3230: fnd_msg_pub.ADD;
3231: RAISE fnd_api.g_exc_error;
3232: END IF;
3233:
3234: IF ( p_rent_index_rec.base_year IS NULL

Line 3240: fnd_msg_pub.ADD;

3236: THEN
3237: l_error_count:=l_error_count+1;
3238: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3239: fnd_message.set_token('ERR_MSG', 'Base Year should be provided when relationship_default is '||p_rent_index_rec.relationship_default);
3240: fnd_msg_pub.ADD;
3241: RAISE fnd_api.g_exc_error;
3242: END IF;
3243:
3244: END IF;

Line 3260: fnd_msg_pub.ADD;

3256: , p_lease_cls_code => l_lease_class_code)
3257: THEN
3258: l_error_count:=l_error_count+1;
3259: fnd_message.set_name ('PN', 'PN_MISS_TERM_TEMP_DATA');
3260: fnd_msg_pub.ADD;
3261: RAISE fnd_api.g_exc_error;
3262: END IF;
3263:
3264: IF pn_r12_util_pkg.is_r12

Line 3273: fnd_msg_pub.ADD;

3269: IF l_tccstatus = 'PN_NO_TCC_FOUND'
3270: THEN
3271: l_error_count:=l_error_count+1;
3272: fnd_message.set_name ('PN', 'PN_NO_TCC_FOUND');
3273: fnd_msg_pub.ADD;
3274: RAISE fnd_api.g_exc_error;
3275: --RAISE;
3276: ELSIF l_tccstatus = 'PN_UPG_TCC'
3277: THEN

Line 3280: fnd_msg_pub.ADD;

3276: ELSIF l_tccstatus = 'PN_UPG_TCC'
3277: THEN
3278: l_error_count:=l_error_count+1;
3279: fnd_message.set_name ('PN', 'PN_UPG_TCC_FOUND');
3280: fnd_msg_pub.ADD;
3281: RAISE fnd_api.g_exc_error;
3282: END IF;
3283: END IF;
3284: END IF;

Line 3302: fnd_msg_pub.ADD;

3298: THEN
3299:
3300: l_error_count:=l_error_count+1;
3301: fnd_message.set_name ('PN', 'PN_PRORATION_PERIOD_START_DATE');
3302: fnd_msg_pub.ADD;
3303: RAISE fnd_api.g_exc_error;
3304: END IF;
3305: END IF;
3306:

Line 3327: fnd_msg_pub.ADD;

3323:
3324: l_error_count:=l_error_count+1;
3325: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3326: fnd_message.set_token('ERR_MSG', 'Proration period start data cannot be provided for No Proration Rule');
3327: fnd_msg_pub.ADD;
3328: RAISE fnd_api.g_exc_error;
3329: END IF;
3330: ELSE
3331: p_rent_index_rec.proration_period_start_date := p_rent_index_rec.commencement_date;

Line 3366: fnd_msg_pub.ADD;

3362:
3363:
3364: IF l_msg = 'PN_TERM_DATE_INV_APPR_PRDS' THEN
3365: fnd_message.set_name ('PN', l_msg);
3366: fnd_msg_pub.ADD;
3367: RAISE fnd_api.g_exc_error;
3368:
3369: ELSE
3370: fnd_message.set_name ('PN', l_msg);

Line 3371: fnd_msg_pub.ADD;

3367: RAISE fnd_api.g_exc_error;
3368:
3369: ELSE
3370: fnd_message.set_name ('PN', l_msg);
3371: fnd_msg_pub.ADD;
3372: END IF;
3373:
3374: END IF;
3375:

Line 3386: fnd_msg_pub.ADD;

3382:
3383: l_error_count:=l_error_count+1;
3384: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3385: fnd_message.set_token('ERR_MSG', 'Rounding flag should be Y/N');
3386: fnd_msg_pub.ADD;
3387: RAISE fnd_api.g_exc_error;
3388: END IF;
3389:
3390: IF p_rent_index_rec.aggregation_flag IS NULL OR p_rent_index_rec.aggregation_flag = pn_index_rent_utils.g_pn_miss_char

Line 3400: fnd_msg_pub.ADD;

3396:
3397: l_error_count:=l_error_count+1;
3398: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3399: fnd_message.set_token('ERR_MSG', 'Aggregation flag should be Y/N');
3400: fnd_msg_pub.ADD;
3401: RAISE fnd_api.g_exc_error;
3402: END IF;
3403:
3404:

Line 3415: fnd_msg_pub.ADD;

3411:
3412: l_error_count:=l_error_count+1;
3413: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3414: fnd_message.set_token('ERR_MSG', 'Aggregation flag should be Y/N');
3415: fnd_msg_pub.ADD;
3416: RAISE fnd_api.g_exc_error;
3417: END IF;
3418:
3419: IF p_rent_index_rec.vr_nbp_flag IS NOT NULL AND p_rent_index_rec.vr_nbp_flag <> pn_index_rent_utils.g_pn_miss_char

Line 3429: fnd_msg_pub.ADD;

3425:
3426: l_error_count:=l_error_count+1;
3427: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
3428: fnd_message.set_token('ERR_MSG', 'Natural Breakpoint basis flag should be N or NULL');
3429: fnd_msg_pub.ADD;
3430: RAISE fnd_api.g_exc_error;
3431: END IF;
3432: END IF;
3433: -- Validate Index Rent Descriptive Fields

Line 3607: fnd_msg_pub.ADD;

3603: IF p_index_constraint_rec.org_id IS NULL
3604: OR NVL (pn_mo_cache_utils.check_valid_org (p_index_constraint_rec.org_id), 'N') <> 'Y'
3605: THEN
3606: fnd_message.set_name ('MO', 'MO_ORG_INVALID');
3607: fnd_msg_pub.ADD;
3608: --RAISE ERROR;
3609: END IF;
3610:
3611:

Line 4054: fnd_msg_pub.ADD;

4050: , x_return_status => x_return_status);
4051: IF x_return_status<>fnd_api.g_ret_sts_success
4052: THEN
4053: fnd_message.set_name('PN','PN_CONSTRAINT_SCOPE_NOT_EXISTS');
4054: fnd_msg_pub.ADD;
4055: RAISE fnd_api.g_exc_error;
4056: END IF;
4057: END IF;
4058:

Line 4069: fnd_msg_pub.ADD;

4065:
4066: l_error_count:=l_error_count+1;
4067: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4068: fnd_message.set_token('ERR_MSG', 'Both Constraint amounts and percentages cannot be provided. Please provide either amounts or percentages ');
4069: fnd_msg_pub.ADD;
4070: RAISE fnd_api.g_exc_error;
4071: END IF;
4072:
4073: IF ( p_index_constraint_tbl (i).minimum_amount IS NOT NULL

Line 4088: fnd_msg_pub.ADD;

4084: THEN
4085: -- NULL;
4086: -- ELSE
4087: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_AMOUNT');
4088: fnd_msg_pub.ADD;
4089: RAISE fnd_api.g_exc_error;
4090: END IF;
4091: --END IF;
4092: ELSE

Line 4115: fnd_msg_pub.ADD;

4111: -- NULL;
4112: --ELSE
4113:
4114: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_AMOUNT');
4115: fnd_msg_pub.ADD;
4116: RAISE fnd_api.g_exc_error;
4117: END IF;
4118: --END IF;
4119: ELSE

Line 4139: fnd_msg_pub.ADD;

4135: THEN
4136: -- NULL;
4137: --ELSE
4138: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_PERCENT');
4139: fnd_msg_pub.ADD;
4140: RAISE fnd_api.g_exc_error;
4141: END IF;
4142: --END IF;
4143: ELSE

Line 4162: fnd_msg_pub.ADD;

4158: THEN
4159: -- NULL;
4160: --ELSE
4161: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_PERCENT');
4162: fnd_msg_pub.ADD;
4163: RAISE fnd_api.g_exc_error;
4164: END IF;
4165: --END IF;
4166: ELSE

Line 4192: fnd_msg_pub.ADD;

4188: IF x_return_status in (fnd_api.g_ret_sts_error,fnd_api.g_ret_sts_unexp_error)
4189: THEN
4190: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4191: fnd_message.set_token('ERR_MSG', 'Cannot create multiple Constraint records with the scope');
4192: fnd_msg_pub.ADD;
4193: --ROLLBACK;
4194: --RAISE fnd_api.g_exc_error;
4195: END IF;
4196:

Line 4276: fnd_msg_pub.ADD;

4272: IF x_return_status in (fnd_api.g_ret_sts_error,fnd_api.g_ret_sts_unexp_error)
4273: THEN
4274: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4275: fnd_message.set_token('ERR_MSG', 'Cannot update multiple Constraint records with the scope');
4276: fnd_msg_pub.ADD;
4277: --ROLLBACK;
4278: --RAISE fnd_api.g_exc_error;
4279: END IF;
4280:

Line 4344: fnd_msg_pub.ADD;

4340: IF p_rent_index_rec.org_id<>fnd_global.org_id
4341: THEN
4342: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4343: fnd_message.set_token('ERR_MSG', 'Operating unit provided do not exists in the list of Operating Units that are allowed access to, for a responsibility');
4344: fnd_msg_pub.ADD;
4345: RAISE fnd_api.g_exc_error;
4346: END IF;
4347: ELSE
4348: p_rent_index_rec.org_id:=FND_PROFILE.VALUE('ORG_ID');

Line 4482: fnd_msg_pub.ADD;

4478:
4479: IF l_msg IS NOT NULL
4480: THEN
4481: fnd_message.set_name ('PN', l_msg);
4482: fnd_msg_pub.ADD;
4483: END IF;
4484:
4485: END IF;
4486: END IF;

Line 4545: fnd_msg_pub.ADD;

4541: IF p_rent_index_rec.org_id<>fnd_global.org_id
4542: THEN
4543: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
4544: fnd_message.set_token('ERR_MSG', 'Operating unit provided do not exists in the list of Operating Units that are allowed access to, for a responsibility');
4545: fnd_msg_pub.ADD;
4546: RAISE fnd_api.g_exc_error;
4547: END IF;
4548: ELSE
4549: p_rent_index_rec.org_id:=FND_PROFILE.VALUE('ORG_ID');

Line 4668: fnd_msg_pub.ADD;

4664:
4665: IF l_msg IS NOT NULL
4666: THEN
4667: fnd_message.set_name ('PN', l_msg);
4668: fnd_msg_pub.ADD;
4669: END IF;
4670:
4671: END IF;
4672: END IF;