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_MESSAGE

Line 195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

191: , p_return_status => x_return_status
192: );
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)

Line 196: fnd_message.set_token('ERR_MSG', 'Index Rent constraints descriptive flexfield validation failed due to an error');

192: );
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

Line 201: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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');
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;

Line 202: fnd_message.set_token('ERR_MSG', 'Index Rent constraints descriptive flexfield validation failed due to an unexpected error');

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');
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;

Line 352: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

348: , p_return_status => x_return_status
349: );
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)

Line 353: fnd_message.set_token('ERR_MSG', 'Index Rent descriptive flexfield validation failed due to an error');

349: );
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

Line 358: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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');
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;

Line 359: fnd_message.set_token('ERR_MSG', 'Index Rent descriptive flexfield validation failed due to an unexpected error');

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');
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;

Line 494: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

490: , p_return_status => x_return_status
491: );
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)

Line 495: fnd_message.set_token('ERR_MSG', 'Index Rent agreement descriptive flexfield validation failed due to an error');

491: );
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

Line 500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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');
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;

Line 501: fnd_message.set_token('ERR_MSG', 'Index Rent agreement descriptive flexfield validation failed due to an unexpected error');

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');
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;

Line 1635: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

1631: l_rent_index_rec_old.location_id,
1632: x_return_status);
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;

Line 1636: fnd_message.set_token('ERR_MSG', 'Update location for IR terms failed with status: '||x_return_status);

1632: x_return_status);
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;

Line 1660: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

1656: l_rent_index_rec_old.location_id,
1657: x_return_status);
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;

Line 1661: fnd_message.set_token('ERR_MSG', 'Update location for IR terms failed with status: '||x_return_status);

1657: x_return_status);
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;

Line 2144: fnd_message.set_name('PN','PN_INDEX_UPDATE_REQD_DATA');

2140:
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;

Line 2180: fnd_message.set_name('PN','PN_DUP_INDEX_LEASE_NUMBER');

2176:
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;

Line 2256: fnd_message.set_name('PN','PN_LEASE_ID');

2252:
2253: IF x_return_status<>fnd_api.g_ret_sts_success
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;

Line 2257: fnd_message.set_token (' ID', p_rent_index_rec.lease_id);

2253: IF x_return_status<>fnd_api.g_ret_sts_success
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;

Line 2291: fnd_message.set_name('PN','PN_LOCATION_NOT_EXIST');

2287:
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;

Line 2323: fnd_message.set_name('PN','PN_INDEX_TYPE_NOT_EXISTS');

2319:
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;

Line 2370: fnd_message.set_name ('PN', 'PN_INDEX_COMMENCE_TERMINATE_DT');

2366: GREATEST (l_lease_termination_date
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:

Line 2378: fnd_message.set_name ('PN', 'PN_INDEX_TERMINATION_DT');

2374:
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:

Line 2389: fnd_message.set_name ('PN', 'PN_INDEX_COMMENCE_TERMINATE_DT');

2385: GREATEST (l_lease_termination_date
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:

Line 2397: fnd_message.set_name ('PN', 'PN_INDEX_TERMINATION_DT');

2393:
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:

Line 2442: fnd_message.set_name ('PN','PN_INDEX_USER_NOT_EXISTS');

2438:
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;

Line 2474: fnd_message.set_name('PN','PN_CURRENCY_CODE_NOT_EXIST');

2470: , x_return_status => x_return_status);
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;*/

Line 2503: fnd_message.set_name ('PN', 'PN_INVALID_ASSESS_YEAR');

2499: IF p_rent_index_rec.assessment_interval <= 0
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

Line 2549: fnd_message.set_name('PN','PN_INDEX_INCREASE_ON_NOT_EXIST');

2545: , x_return_status => x_return_status);
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:

Line 2592: fnd_message.set_name('PN','PN_INDEX_REFERENCE_PERIOD');

2588: , x_return_status => x_return_status);
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

Line 2632: fnd_message.set_name('PN','PN_INDEX_BASIS_TYPE_NOT_EXISTS');

2628: , x_return_status => x_return_status);
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;

Line 2666: fnd_message.set_name('PN','PN_INDEX_FINDER_NOT_EXISTS');

2662: , x_return_status => x_return_status);
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

Line 2706: fnd_message.set_name('PN','PN_INDEX_RELATION_NOT_EXISTS');

2702: , x_return_status => x_return_status);
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;

Line 2755: fnd_message.set_name('PN','PN_INDEX_TERM_TEMPL_NOT_EXISTS');

2751: , x_termtemp_id => p_rent_index_rec.term_template_id);
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;

Line 2780: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

2776: AND p_rent_index_rec.aggregation_flag<> pn_lease_utils.g_pn_miss_char
2777: AND p_rent_index_rec.aggregation_flag='Y')
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:

Line 2781: fnd_message.set_token('ERR_MSG', 'Both Term Template and Agreement Flag have been provided. Please provide either Term Template or Agreement Flag');

2777: AND p_rent_index_rec.aggregation_flag='Y')
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;

Line 2798: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

2794: OR p_rent_index_rec.term_template_id =pn_lease_utils.g_pn_miss_num
2795: THEN
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;

Line 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');

2795: THEN
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:

Line 2837: fnd_message.set_name('PN','PN_INDEX_NEGTV_RENT_NOT_EXISTS');

2833: , x_return_status => x_return_status);
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;

Line 2880: fnd_message.set_name('PN','PN_INDEX_SPREAD_FRQ_NOT_EXISTS');

2876: , x_return_status => x_return_status);
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;

Line 2913: fnd_message.set_name ('PN', 'PN_INVALID_ASSESS_YEAR');

2909: THEN
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;

Line 2941: fnd_message.set_name ('PN', 'PN_INDEX_INIT_BASIS_REQD');

2937: AND ( p_rent_index_rec.initial_basis IS NULL
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

Line 2972: fnd_message.set_name ('PN', 'PN_ZERO_INDEX_MULTIPLIER');

2968: THEN
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;

Line 3032: fnd_message.set_name('PN','PN_INDEX_PRARATION_NOT_EXISTS');

3028:
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;

Line 3115: --fnd_message.set_name ('PN', 'PN_INVALID_BASIS_TYPE');

3111: AND p_rent_index_rec.basis_type <> 'ROLLING'
3112: AND p_rent_index_rec.basis_type <> 'COMPOUND'
3113: THEN
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;

Line 3116: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3112: AND p_rent_index_rec.basis_type <> 'COMPOUND'
3113: THEN
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'

Line 3117: fnd_message.set_token('ERR_MSG', 'Please provide ROLLING\COMPOUND basis type for default reference period(Previous Year - Use Previous Current Index )');

3113: THEN
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'

Line 3124: fnd_message.set_name ('PN', 'PN_INVALID_BASIS_TYPE');

3120: ELSIF p_rent_index_rec.reference_period = 'BASE_YEAR'
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:

Line 3137: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3133: IF NVL(p_rent_index_rec.reference_period,'PREV_YEAR_PREV_CURRENT_CPI') = 'BASE_YEAR'
3134: AND p_rent_index_rec.basis_type <> 'FIXED'
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')

Line 3138: fnd_message.set_token('ERR_MSG', 'Invalid basis type for the provided reference period: '||p_rent_index_rec.reference_period);

3134: AND p_rent_index_rec.basis_type <> 'FIXED'
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

Line 3144: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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;
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;

Line 3145: fnd_message.set_token('ERR_MSG', 'Invalid basis type for the provided reference period: '||p_rent_index_rec.reference_period);

3141: AND p_rent_index_rec.basis_type NOT IN ( 'ROLLING','COMPOUND')
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:

Line 3170: --fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_INDEX_ONLY');--PN_INDEX_BASE_INDEX_REQUIRED

3166: )
3167: THEN
3168:
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;

Line 3171: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3167: THEN
3168:
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;

Line 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');

3168:
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:

Line 3182: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3178: IF ( p_rent_index_rec.base_year IS NULL
3179: OR p_rent_index_rec.base_year =pn_index_rent_utils.g_pn_miss_date)
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;

Line 3183: fnd_message.set_token('ERR_MSG', 'Base Year should be provided when relationship default is '||p_rent_index_rec.relationship_default);

3179: OR p_rent_index_rec.base_year =pn_index_rent_utils.g_pn_miss_date)
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:

Line 3197: --fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_BASIS_ONLY');

3193: --IF p_rent_index_rec.basis_percent_default IS NULL
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:

Line 3229: fnd_message.set_name ('PN', 'PN_INDEX_REQD_FLDS_GT_LT_ONLY'); --PN_INVALID_BASIS_TYPE

3225: IF ( p_rent_index_rec.base_Index IS NULL
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:

Line 3238: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3234: IF ( p_rent_index_rec.base_year IS NULL
3235: OR p_rent_index_rec.base_year =pn_index_rent_utils.g_pn_miss_date)
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;

Line 3239: fnd_message.set_token('ERR_MSG', 'Base Year should be provided when relationship_default is '||p_rent_index_rec.relationship_default);

3235: OR p_rent_index_rec.base_year =pn_index_rent_utils.g_pn_miss_date)
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:

Line 3259: fnd_message.set_name ('PN', 'PN_MISS_TERM_TEMP_DATA');

3255: (p_term_temp_id => p_rent_index_rec.term_template_id
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:

Line 3272: fnd_message.set_name ('PN', 'PN_NO_TCC_FOUND');

3268:
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'

Line 3279: fnd_message.set_name ('PN', 'PN_UPG_TCC_FOUND');

3275: --RAISE;
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;

Line 3301: fnd_message.set_name ('PN', 'PN_PRORATION_PERIOD_START_DATE');

3297: IF p_rent_index_rec.proration_period_start_date >= p_rent_index_rec.commencement_date
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;

Line 3325: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3321: AND p_rent_index_rec.proration_period_start_date <> pn_index_rent_utils.g_pn_miss_date
3322: THEN
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;

Line 3326: fnd_message.set_token('ERR_MSG', 'Proration period start data cannot be provided for No Proration Rule');

3322: THEN
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

Line 3365: fnd_message.set_name ('PN', l_msg);

3361: END IF;
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

Line 3370: 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);
3371: fnd_msg_pub.ADD;
3372: END IF;
3373:
3374: END IF;

Line 3384: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3380: ELSIF p_rent_index_rec.rounding_flag NOT IN ('Y','N')
3381: THEN
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;

Line 3385: fnd_message.set_token('ERR_MSG', 'Rounding flag should be Y/N');

3381: THEN
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:

Line 3398: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3394: ELSIF p_rent_index_rec.aggregation_flag NOT IN ('Y','N')
3395: THEN
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;

Line 3399: fnd_message.set_token('ERR_MSG', 'Aggregation flag should be Y/N');

3395: THEN
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:

Line 3413: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3409: ELSIF p_rent_index_rec.retain_initial_basis_flag NOT IN ('Y','N')
3410: THEN
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;

Line 3414: fnd_message.set_token('ERR_MSG', 'Aggregation flag should be Y/N');

3410: THEN
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:

Line 3427: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

3423: IF p_rent_index_rec.vr_nbp_flag NOT IN ('N')
3424: THEN
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;

Line 3428: fnd_message.set_token('ERR_MSG', 'Natural Breakpoint basis flag should be N or NULL');

3424: THEN
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;

Line 3606: fnd_message.set_name ('MO', 'MO_ORG_INVALID');

3602:
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:

Line 4053: fnd_message.set_name('PN','PN_CONSTRAINT_SCOPE_NOT_EXISTS');

4049: , x_lookup_type_code => p_index_constraint_tbl (i).SCOPE
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;

Line 4067: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

4063: AND (p_index_constraint_tbl (i).maximum_percent IS NOT NULL AND p_index_constraint_tbl (i).maximum_percent<>pn_index_rent_utils.g_pn_miss_num)
4064: THEN
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;

Line 4068: fnd_message.set_token('ERR_MSG', 'Both Constraint amounts and percentages cannot be provided. Please provide either amounts or percentages ');

4064: THEN
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:

Line 4087: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_AMOUNT');

4083: IF (p_index_constraint_tbl (i).maximum_amount < NVL(p_index_constraint_tbl (i).minimum_amount,pn_index_rent_utils.g_pn_miss_num))
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;

Line 4114: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_AMOUNT');

4110: THEN
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;

Line 4138: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_PERCENT');

4134: IF (p_index_constraint_tbl (i).maximum_percent 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;

Line 4161: fnd_message.set_name ('PN', 'PN_INDEX_CONSTRAINT_PERCENT');

4157: IF (p_index_constraint_tbl (i).maximum_percent 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;

Line 4190: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

4186: END IF;
4187:
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;

Line 4191: fnd_message.set_token('ERR_MSG', 'Cannot create multiple Constraint records with the scope');

4187:
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;

Line 4274: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

4270: END IF;
4271:
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;

Line 4275: fnd_message.set_token('ERR_MSG', 'Cannot update multiple Constraint records with the scope');

4271:
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;

Line 4342: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

4338: IF p_rent_index_rec.org_id IS NOT NULL AND p_rent_index_rec.org_id<>pn_index_rent_utils.g_pn_miss_num
4339: THEN
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;

Line 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');

4339: THEN
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

Line 4481: fnd_message.set_name ('PN', l_msg);

4477: , op_msg => l_msg);
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;

Line 4543: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

4539: IF p_rent_index_rec.org_id IS NOT NULL AND p_rent_index_rec.org_id<>pn_index_rent_utils.g_pn_miss_num
4540: THEN
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;

Line 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');

4540: THEN
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

Line 4635: fnd_message.set_name ('PN', l_msg);

4631: );
4632: END IF;
4633:
4634: IF l_msg = 'PN_APPROVED_PERIODS_FOUND' THEN
4635: fnd_message.set_name ('PN', l_msg);
4636: RAISE fnd_api.g_exc_error;
4637: ELSE
4638: pn_index_rent_pvt.DEBUG (g_pkg_name
4639: || g_program_unit

Line 4667: fnd_message.set_name ('PN', l_msg);

4663: , op_msg => l_msg);
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;