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 PN_INDEX_RENT_PVT

Line 1: PACKAGE BODY pn_index_rent_pvt AS

1: PACKAGE BODY pn_index_rent_pvt AS
2: /* $Header: PNIRPVTB.pls 120.1 2010/12/15 10:40:35 seevivek noship $ */
3:
4: g_pkg_name VARCHAR2 (30);
5: g_program_unit VARCHAR2 (30);

Line 682: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

678: END IF;
679: EXCEPTION
680: WHEN fnd_api.g_exc_error
681: THEN
682: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
683: || g_pkg_name
684: || g_program_unit
685: || '-'
686: || SQLERRM

Line 692: pn_index_rent_pvt.DEBUG ( 'Exception in '

688: x_return_status := fnd_api.g_ret_sts_error;
689:
690: WHEN OTHERS
691: THEN
692: pn_index_rent_pvt.DEBUG ( 'Exception in '
693: || g_pkg_name
694: || g_program_unit
695: || '-'
696: || SQLERRM

Line 1151: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

1147: END IF;
1148: EXCEPTION
1149: WHEN fnd_api.g_exc_error
1150: THEN
1151: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
1152: || g_pkg_name
1153: || g_program_unit
1154: || '-'
1155: || SQLERRM

Line 1161: pn_index_rent_pvt.DEBUG ( 'Exception in '

1157: x_return_status := fnd_api.g_ret_sts_error;
1158:
1159: WHEN OTHERS
1160: THEN
1161: pn_index_rent_pvt.DEBUG ( 'Exception in '
1162: || g_pkg_name
1163: || g_program_unit
1164: || '-'
1165: || SQLERRM

Line 1184: pn_index_rent_pvt.DEBUG ( g_pkg_name

1180: BEGIN
1181: g_program_unit := 'UPDATE_INDENT_RENT_ROW';
1182: x_return_status := fnd_api.g_ret_sts_success;
1183:
1184: pn_index_rent_pvt.DEBUG ( g_pkg_name
1185: || g_program_unit
1186: || ' Calling pn_index_leases_pkg.update_row'
1187: , 3);
1188: pn_index_leases_pkg.update_row

Line 1263: pn_index_rent_pvt.DEBUG ( g_pkg_name

1259: , x_index_multiplier => p_rent_index_rec.index_multiplier
1260: , x_proration_rule => p_rent_index_rec.proration_rule
1261: , x_proration_period_start_date => p_rent_index_rec.proration_period_start_date);
1262:
1263: pn_index_rent_pvt.DEBUG ( g_pkg_name
1264: || g_program_unit
1265: || ' pn_index_leases_pkg.update_row successful index_lease_id:'|| p_rent_index_rec.index_lease_id
1266: , 3);
1267: IF p_rent_index_rec.index_lease_id>0

Line 1276: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

1272: END IF;
1273: EXCEPTION
1274: WHEN fnd_api.g_exc_error
1275: THEN
1276: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
1277: || g_pkg_name
1278: || g_program_unit
1279: || '-'
1280: || SQLERRM

Line 1286: pn_index_rent_pvt.DEBUG ( 'Exception in '

1282: x_return_status := fnd_api.g_ret_sts_error;
1283:
1284: WHEN OTHERS
1285: THEN
1286: pn_index_rent_pvt.DEBUG ( 'Exception in '
1287: || g_pkg_name
1288: || g_program_unit
1289: || '-'
1290: || SQLERRM

Line 1312: pn_index_rent_pvt.DEBUG ( g_pkg_name

1308: , x_return_status => x_return_status
1309: , x_msg_count => x_msg_count
1310: , x_msg_data => x_msg_count);
1311:
1312: pn_index_rent_pvt.DEBUG ( g_pkg_name
1313: || g_program_unit
1314: || ' Calling pn_index_leases_pkg.insert_row'
1315: , 3);
1316: pn_index_leases_pkg.insert_row

Line 1399: pn_index_rent_pvt.DEBUG ( g_pkg_name

1395:
1396:
1397: --IF l_rowid IS NOT NULL
1398: --THEN
1399: pn_index_rent_pvt.DEBUG ( g_pkg_name
1400: || g_program_unit
1401: || ' pn_index_leases_pkg.insert_row successful. index_lease_id:'|| p_rent_index_rec.index_lease_id
1402: , 3);
1403:

Line 1416: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

1412: END IF;
1413: EXCEPTION
1414: WHEN fnd_api.g_exc_error
1415: THEN
1416: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
1417: || g_pkg_name
1418: || g_program_unit
1419: || '-'
1420: || SQLERRM

Line 1426: pn_index_rent_pvt.DEBUG ( 'Exception in '

1422: x_return_status := fnd_api.g_ret_sts_error;
1423:
1424: WHEN OTHERS
1425: THEN
1426: pn_index_rent_pvt.DEBUG ( 'Exception in '
1427: || g_pkg_name
1428: || g_program_unit
1429: || '-'
1430: || SQLERRM

Line 1528: pn_index_rent_pvt.DEBUG ( g_pkg_name

1524: l_rent_index_rec_old pn_index_leases_all%ROWTYPE;
1525: BEGIN
1526: g_program_unit := 'GET_CHANGED_INDEX_RENT_REC';
1527: x_return_status := fnd_api.g_ret_sts_success;
1528: pn_index_rent_pvt.DEBUG ( g_pkg_name
1529: || g_program_unit
1530: || ' Inside get_changed_index_rent_rec '
1531: , 3);
1532:

Line 1542: pn_index_rent_pvt.DEBUG ( g_pkg_name

1538: IF (c_old_index_rent_values%NOTFOUND)
1539: THEN
1540: x_return_status := fnd_api.g_ret_sts_error;
1541:
1542: pn_index_rent_pvt.DEBUG ( g_pkg_name
1543: || g_program_unit
1544: || ' Cursor c_old_index_rent_values failed to return the existing record '
1545: , 3);
1546: --ELSE

Line 2088: pn_index_rent_pvt.DEBUG ( g_pkg_name

2084: BEGIN
2085: x_return_status := fnd_api.g_ret_sts_success;
2086: g_program_unit := 'VALIDATE_INDEX_RENT_REC';
2087:
2088: pn_index_rent_pvt.DEBUG ( g_pkg_name
2089: || g_program_unit
2090: || ' - Start of validate_index_rent_rec procedure'
2091: , 3);
2092:

Line 2115: pn_index_rent_pvt.DEBUG ( g_pkg_name

2111:
2112: IF LTRIM (RTRIM (p_operation)) = 'UPDATE_INDEX_RENT'
2113: THEN
2114:
2115: pn_index_rent_pvt.DEBUG ( g_pkg_name
2116: || g_program_unit
2117: || ' - Before calling PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID index_lease_id - '|| p_rent_index_rec.index_lease_id
2118: , 3);
2119: --IF LTRIM (RTRIM (p_operation)) = 'UPDATE_INDEX_RENT'

Line 2136: pn_index_rent_pvt.DEBUG ( g_pkg_name

2132: , x_org_id => p_rent_index_rec.org_id
2133: , x_index_id => p_rent_index_rec.index_id
2134: , x_return_status => x_return_status);
2135:
2136: pn_index_rent_pvt.DEBUG ( g_pkg_name
2137: || g_program_unit
2138: || ' - PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID returned index_lease_id - '|| p_rent_index_rec.index_lease_id
2139: , 3);
2140:

Line 2153: pn_index_rent_pvt.DEBUG ( g_pkg_name

2149: --END IF;
2150: END IF;
2151:
2152:
2153: pn_index_rent_pvt.DEBUG ( g_pkg_name
2154: || g_program_unit
2155: || ' - Before calling PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID index_lease_id - '|| p_rent_index_rec.index_lease_id
2156: , 3);
2157:

Line 2171: pn_index_rent_pvt.DEBUG ( g_pkg_name

2167: (x_return_status => x_return_status
2168: , x_index_lease_id => p_rent_index_rec.index_lease_id
2169: , x_index_lease_number => p_rent_index_rec.index_lease_number);
2170:
2171: pn_index_rent_pvt.DEBUG ( g_pkg_name
2172: || g_program_unit
2173: || ' - PN_INDEX_RENT_UTILS.GET_INDEX_LEASE_ID returned index_lease_id - 3'|| p_rent_index_rec.index_lease_id
2174: , 3);
2175:

Line 2197: pn_index_rent_pvt.DEBUG ( g_pkg_name

2193: l_func_curr_code := rec.currency_code;
2194: END LOOP;
2195:
2196:
2197: pn_index_rent_pvt.DEBUG ( g_pkg_name
2198: || g_program_unit
2199: || ' - Default functional currency of the operating unit '|| l_func_curr_code
2200: , 3);
2201:

Line 2206: pn_index_rent_pvt.DEBUG ( g_pkg_name

2202:
2203: ------------------------------------------------------------------
2204: -- Get the lease details for the passed Lease Number or Lease Id
2205: ------------------------------------------------------------------
2206: pn_index_rent_pvt.DEBUG ( g_pkg_name
2207: || g_program_unit||
2208: ' - Before calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2209: , 3);
2210: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 2210: pn_index_rent_pvt.DEBUG ( g_pkg_name

2206: pn_index_rent_pvt.DEBUG ( g_pkg_name
2207: || g_program_unit||
2208: ' - Before calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2209: , 3);
2210: pn_index_rent_pvt.DEBUG ( g_pkg_name
2211: || g_program_unit ||
2212: ' - Before calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2213: , 3);
2214: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 2214: pn_index_rent_pvt.DEBUG ( g_pkg_name

2210: pn_index_rent_pvt.DEBUG ( g_pkg_name
2211: || g_program_unit ||
2212: ' - Before calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2213: , 3);
2214: pn_index_rent_pvt.DEBUG ( g_pkg_name
2215: || g_program_unit||
2216: ' - Before calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2217: , 3);
2218:

Line 2240: pn_index_rent_pvt.DEBUG ( g_pkg_name

2236: , x_lease_execution_date => l_lease_lease_execution_date
2237: , x_lease_extension_end_date => l_lease_extension_end_date
2238: , x_return_status => x_return_status);
2239:
2240: pn_index_rent_pvt.DEBUG ( g_pkg_name
2241: || g_program_unit ||
2242: ' - After calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2243: , 3);
2244: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 2244: pn_index_rent_pvt.DEBUG ( g_pkg_name

2240: pn_index_rent_pvt.DEBUG ( g_pkg_name
2241: || g_program_unit ||
2242: ' - After calling pn_index_rent_utils.get_lease_id lease_id - '|| p_rent_index_rec.lease_id
2243: , 3);
2244: pn_index_rent_pvt.DEBUG ( g_pkg_name
2245: || g_program_unit ||
2246: ' - After calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2247: , 3);
2248: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 2248: pn_index_rent_pvt.DEBUG ( g_pkg_name

2244: pn_index_rent_pvt.DEBUG ( g_pkg_name
2245: || g_program_unit ||
2246: ' - After calling pn_index_rent_utils.get_lease_id lease_number - '|| p_rent_index_rec.lease_num
2247: , 3);
2248: pn_index_rent_pvt.DEBUG ( g_pkg_name
2249: || g_program_unit ||
2250: ' - After calling pn_index_rent_utils.get_lease_id lease_name - '|| p_rent_index_rec.lease_name
2251: , 3);
2252:

Line 2266: pn_index_rent_pvt.DEBUG ( g_pkg_name

2262:
2263: ------------------------------------------------------------------
2264: -- Get the location associated with Lease Number or Lease Id
2265: ------------------------------------------------------------------
2266: pn_index_rent_pvt.DEBUG ( g_pkg_name
2267: || g_program_unit ||
2268: ' - Before calling pn_index_rent_utils.get_location_id location_code - '|| p_rent_index_rec.location_id
2269: , 3);
2270:

Line 2283: pn_index_rent_pvt.DEBUG ( g_pkg_name

2279: , p_location_code => p_rent_index_rec.location_code
2280: , p_org_id => p_rent_index_rec.org_id
2281: , x_location_id => p_rent_index_rec.location_id
2282: , x_return_status => x_return_status);
2283: pn_index_rent_pvt.DEBUG ( g_pkg_name
2284: || g_program_unit||
2285: ' - After calling pn_index_rent_utils.get_location_id location_code - '|| p_rent_index_rec.location_id
2286: , 3);
2287:

Line 2297: pn_index_rent_pvt.DEBUG ( g_pkg_name

2293: RAISE fnd_api.g_exc_error;
2294: END IF;
2295: END IF;
2296:
2297: pn_index_rent_pvt.DEBUG ( g_pkg_name
2298: || g_program_unit||
2299: ' - Before calling pn_index_rent_utils.get_index_id index - '|| p_rent_index_rec.index_id
2300: , 3);
2301:

Line 2315: pn_index_rent_pvt.DEBUG ( g_pkg_name

2311: , p_operation => p_operation
2312: , p_index_name => p_rent_index_rec.index_type
2313: , x_index_id => p_rent_index_rec.index_id
2314: , x_return_status => x_return_status);
2315: pn_index_rent_pvt.DEBUG ( g_pkg_name
2316: || g_program_unit ||
2317: ' - After calling pn_index_rent_utils.get_index_id index - '|| p_rent_index_rec.index_id
2318: , 3);
2319:

Line 2333: pn_index_rent_pvt.DEBUG ( g_pkg_name

2329: ----------------------------------------------
2330: -- Validate the passed Index Commencement Date
2331: ----------------------------------------------
2332:
2333: pn_index_rent_pvt.DEBUG ( g_pkg_name
2334: || g_program_unit||
2335: ' - Before validating index commencement date - '|| p_rent_index_rec.commencement_date
2336: , 3);
2337:

Line 2338: pn_index_rent_pvt.DEBUG ( g_pkg_name

2334: || g_program_unit||
2335: ' - Before validating index commencement date - '|| p_rent_index_rec.commencement_date
2336: , 3);
2337:
2338: pn_index_rent_pvt.DEBUG ( g_pkg_name
2339: || g_program_unit||
2340: ' - Before validating index termination date - '|| p_rent_index_rec.termination_date
2341: , 3);
2342:

Line 2409: pn_index_rent_pvt.DEBUG ( g_pkg_name

2405: -- GREATEST (l_lease_termination_date
2406: -- , NVL (l_lease_extension_end_date, l_lease_termination_date));
2407: END IF;
2408:
2409: pn_index_rent_pvt.DEBUG ( g_pkg_name
2410: || g_program_unit||
2411: ' - After validating index commencement date - '|| p_rent_index_rec.commencement_date
2412: , 3);
2413:

Line 2414: pn_index_rent_pvt.DEBUG ( g_pkg_name

2410: || g_program_unit||
2411: ' - After validating index commencement date - '|| p_rent_index_rec.commencement_date
2412: , 3);
2413:
2414: pn_index_rent_pvt.DEBUG ( g_pkg_name
2415: || g_program_unit||
2416: ' - After validating index termination date - '|| p_rent_index_rec.termination_date
2417: , 3);
2418:

Line 2423: pn_index_rent_pvt.DEBUG ( g_pkg_name

2419:
2420: ---------------------------------------
2421: -- Validate the passed User Responsible
2422: ---------------------------------------
2423: pn_index_rent_pvt.DEBUG ( g_pkg_name
2424: || g_program_unit||
2425: ' - Before calling pn_index_rent_utils.get_user_id - '|| p_rent_index_rec.abstracted_by
2426: , 3);
2427:

Line 2448: pn_index_rent_pvt.DEBUG ( g_pkg_name

2444: RAISE fnd_api.g_exc_error;
2445: END IF;
2446: END IF;
2447:
2448: pn_index_rent_pvt.DEBUG ( g_pkg_name
2449: || g_program_unit||
2450: ' - After calling pn_index_rent_utils.get_user_id - '|| p_rent_index_rec.abstracted_by
2451: , 3);
2452:

Line 2456: pn_index_rent_pvt.DEBUG ( g_pkg_name

2452:
2453: -------------------------------------
2454: -- Validate the passed Currency Code
2455: -------------------------------------
2456: pn_index_rent_pvt.DEBUG ( g_pkg_name
2457: || g_program_unit||
2458: ' - Before pn_index_rent_utils.get_currency_code currency code - '|| p_rent_index_rec.currency_code
2459: , 3);
2460: /*

Line 2481: pn_index_rent_pvt.DEBUG ( g_pkg_name

2477: END IF;
2478: END IF;*/
2479: p_rent_index_rec.currency_code:= l_func_curr_code;
2480:
2481: pn_index_rent_pvt.DEBUG ( g_pkg_name
2482: || g_program_unit||
2483: ' - After pn_index_rent_utils.get_currency_code currency code - '|| p_rent_index_rec.currency_code
2484: , 3);
2485:

Line 2489: pn_index_rent_pvt.DEBUG ( g_pkg_name

2485:
2486: ------------------------------------------
2487: -- Validate the passed Assessment Interval
2488: ------------------------------------------
2489: pn_index_rent_pvt.DEBUG ( g_pkg_name
2490: || g_program_unit||
2491: ' - Before validation assessment_interval - '|| p_rent_index_rec.assessment_interval
2492: , 3);
2493:

Line 2511: pn_index_rent_pvt.DEBUG ( g_pkg_name

2507: ELSE
2508: p_rent_index_rec.assessment_interval := 1;
2509: END IF;
2510:
2511: pn_index_rent_pvt.DEBUG ( g_pkg_name
2512: || g_program_unit||
2513: ' - After validation assessment_interval - '|| p_rent_index_rec.assessment_interval
2514: , 3);
2515: ------------------------------------------

Line 2528: pn_index_rent_pvt.DEBUG ( g_pkg_name

2524:
2525: -----------------------------------
2526: -- Validate the passed Increase On
2527: -----------------------------------
2528: pn_index_rent_pvt.DEBUG ( g_pkg_name
2529: || g_program_unit||
2530: ' - Before calling pn_index_rent_utils.get_increase_on increase_on - '|| p_rent_index_rec.increase_on
2531: , 3);
2532: IF ( p_rent_index_rec.increase_on IS NOT NULL

Line 2556: pn_index_rent_pvt.DEBUG ( g_pkg_name

2552: END IF;
2553:
2554: END IF;
2555:
2556: pn_index_rent_pvt.DEBUG ( g_pkg_name
2557: || g_program_unit||
2558: ' - After calling pn_index_rent_utils.get_increase_on increase_on - '|| p_rent_index_rec.increase_on
2559: , 3);
2560:

Line 2571: pn_index_rent_pvt.DEBUG ( g_pkg_name

2567:
2568: ----------------------------------------
2569: -- Validate the passed Reference Period
2570: ----------------------------------------
2571: pn_index_rent_pvt.DEBUG ( g_pkg_name
2572: || g_program_unit||
2573: ' - Before calling pn_index_rent_utils.get_lookup_code reference_period - '|| p_rent_index_rec.reference_period
2574: , 3);
2575:

Line 2603: pn_index_rent_pvt.DEBUG ( g_pkg_name

2599: p_rent_index_rec.reference_period := 'PREV_YEAR_PREV_CURRENT_CPI';
2600: END IF;
2601: END IF;
2602:
2603: pn_index_rent_pvt.DEBUG ( g_pkg_name
2604: || g_program_unit||
2605: ' - After calling pn_index_rent_utils.get_lookup_code reference_period - '|| p_rent_index_rec.reference_period
2606: , 3);
2607:

Line 2612: pn_index_rent_pvt.DEBUG ( g_pkg_name

2608:
2609: ----------------------------------
2610: -- Validate the passed Basis Type
2611: ----------------------------------
2612: pn_index_rent_pvt.DEBUG ( g_pkg_name
2613: || g_program_unit||
2614: ' - Before calling pn_index_rent_utils.get_lookup_code basis_type - '|| p_rent_index_rec.basis_type
2615: , 3);
2616:

Line 2638: pn_index_rent_pvt.DEBUG ( g_pkg_name

2634: RAISE fnd_api.g_exc_error;
2635: END IF;
2636: END IF;
2637:
2638: pn_index_rent_pvt.DEBUG ( g_pkg_name
2639: || g_program_unit||
2640: ' - After calling pn_index_rent_utils.get_lookup_code basis_type - '|| p_rent_index_rec.basis_type
2641: , 3);
2642:

Line 2646: pn_index_rent_pvt.DEBUG ( g_pkg_name

2642:
2643: ------------------------------------------
2644: -- Validate the passed Index Finder Method
2645: ------------------------------------------
2646: pn_index_rent_pvt.DEBUG ( g_pkg_name
2647: || g_program_unit||
2648: ' - Before calling pn_index_rent_utils.get_lookup_code index_finder_method - '|| p_rent_index_rec.index_finder_method
2649: , 3);
2650:

Line 2677: pn_index_rent_pvt.DEBUG ( g_pkg_name

2673: p_rent_index_rec.index_finder_method:='FINDER_DATE';
2674: END IF;
2675: END IF;
2676:
2677: pn_index_rent_pvt.DEBUG ( g_pkg_name
2678: || g_program_unit||
2679: ' - After calling pn_index_rent_utils.get_lookup_code index_finder_method - '|| p_rent_index_rec.index_finder_method
2680: , 3);
2681:

Line 2685: pn_index_rent_pvt.DEBUG ( g_pkg_name

2681:
2682: ----------------------------------------
2683: -- Validate the passed Default Relation
2684: -----------------------------------------
2685: pn_index_rent_pvt.DEBUG ( g_pkg_name
2686: || g_program_unit||
2687: ' - Before calling pn_index_rent_utils.get_lookup_code relationship_default - '|| p_rent_index_rec.relationship_default
2688: , 3);
2689:

Line 2718: pn_index_rent_pvt.DEBUG ( g_pkg_name

2714:
2715: THEN
2716: p_rent_index_rec.relationship_default := 'INDEX_ONLY';
2717: END IF;
2718: pn_index_rent_pvt.DEBUG ( g_pkg_name
2719: || g_program_unit||
2720: ' - After calling pn_index_rent_utils.get_lookup_code relationship_default - '|| p_rent_index_rec.relationship_default
2721: ,3);
2722:

Line 2726: pn_index_rent_pvt.DEBUG ( g_pkg_name

2722:
2723: -------------------------------------
2724: -- Validate the passed Term Template
2725: -------------------------------------
2726: pn_index_rent_pvt.DEBUG ( g_pkg_name
2727: || g_program_unit||
2728: ' - Before calling pn_lease_utils.get_term_template_id term_template_id - '|| p_rent_index_rec.term_template_id
2729: ,3);
2730:

Line 2763: pn_index_rent_pvt.DEBUG ( g_pkg_name

2759: --END IF;
2760:
2761: END IF;
2762:
2763: pn_index_rent_pvt.DEBUG ( g_pkg_name
2764: || g_program_unit||
2765: ' - After calling pn_lease_utils.get_term_template_id term_template_id - '|| p_rent_index_rec.term_template_id
2766: ,3);
2767:

Line 2816: pn_index_rent_pvt.DEBUG ( g_pkg_name

2812: -------------------------------------
2813: -- Validate the passed Negative Rent
2814: -------------------------------------
2815:
2816: pn_index_rent_pvt.DEBUG ( g_pkg_name
2817: || g_program_unit||
2818: ' - Before calling pn_index_rent_utils.get_lookup_code negative_rent_type - '|| p_rent_index_rec.negative_rent_type
2819: ,3);
2820:

Line 2851: pn_index_rent_pvt.DEBUG ( g_pkg_name

2847: THEN
2848: p_rent_index_rec.negative_rent_type := 'IGNORE';
2849: END IF;
2850:
2851: pn_index_rent_pvt.DEBUG ( g_pkg_name
2852: || g_program_unit||
2853: ' - After calling pn_index_rent_utils.get_lookup_code negative_rent_type - '|| p_rent_index_rec.negative_rent_type
2854: ,3);
2855:

Line 2860: pn_index_rent_pvt.DEBUG ( g_pkg_name

2856: ----------------------------------------
2857: -- Validate the passed Spread Frequency
2858: ----------------------------------------
2859:
2860: pn_index_rent_pvt.DEBUG ( g_pkg_name
2861: || g_program_unit||
2862: ' - Before calling pn_index_rent_utils.get_lookup_code spread_frequency - '|| p_rent_index_rec.spread_frequency
2863: ,3);
2864:

Line 2892: pn_index_rent_pvt.DEBUG ( g_pkg_name

2888:
2889: THEN
2890: p_rent_index_rec.spread_frequency:='MON';
2891: END IF;
2892: pn_index_rent_pvt.DEBUG ( g_pkg_name
2893: || g_program_unit||
2894: ' - After calling pn_index_rent_utils.get_lookup_code spread_frequency - '|| p_rent_index_rec.spread_frequency
2895: ,3);
2896:

Line 2902: pn_index_rent_pvt.DEBUG ( g_pkg_name

2898: ------------------------------------------
2899: -- Validate the passed Index Finder Months
2900: ------------------------------------------
2901:
2902: pn_index_rent_pvt.DEBUG ( g_pkg_name
2903: || g_program_unit||
2904: ' - Before validating index_finder_months - '|| p_rent_index_rec.index_finder_months
2905: ,3);
2906:

Line 2922: pn_index_rent_pvt.DEBUG ( g_pkg_name

2918: ELSE
2919: p_rent_index_rec.index_finder_months := -2;
2920: END IF;
2921:
2922: pn_index_rent_pvt.DEBUG ( g_pkg_name
2923: || g_program_unit||
2924: ' - After validating index_finder_months - '|| p_rent_index_rec.index_finder_months
2925: ,3);
2926:

Line 2932: pn_index_rent_pvt.DEBUG ( g_pkg_name

2928: -------------------------------------
2929: -- Validate the passed Initial Basis
2930: -------------------------------------
2931:
2932: pn_index_rent_pvt.DEBUG ( g_pkg_name
2933: || g_program_unit||
2934: ' - Before validating initial_basis - '|| p_rent_index_rec.initial_basis
2935: ,3);
2936: IF (p_rent_index_rec.commencement_date= l_lease_commencement_date)

Line 2952: pn_index_rent_pvt.DEBUG ( g_pkg_name

2948: -- p_rent_index_rec.initial_basis := NULL;
2949: -- END IF;
2950: END IF;
2951:
2952: pn_index_rent_pvt.DEBUG ( g_pkg_name
2953: || g_program_unit||
2954: ' - After validating initial_basis - '|| p_rent_index_rec.initial_basis
2955: ,3);
2956:

Line 2961: pn_index_rent_pvt.DEBUG ( g_pkg_name

2957: ------------------------------------------
2958: -- Validate the passed Index Multiplier
2959: ------------------------------------------
2960:
2961: pn_index_rent_pvt.DEBUG ( g_pkg_name
2962: || g_program_unit||
2963: ' - Before validating index_multiplier - '|| p_rent_index_rec.index_multiplier
2964: ,3);
2965:

Line 2978: pn_index_rent_pvt.DEBUG ( g_pkg_name

2974: RAISE fnd_api.g_exc_error;
2975: END IF;
2976: END IF;
2977:
2978: pn_index_rent_pvt.DEBUG ( g_pkg_name
2979: || g_program_unit||
2980: ' - After validating index_multiplier - '|| p_rent_index_rec.index_multiplier
2981: ,3);
2982:

Line 3011: pn_index_rent_pvt.DEBUG ( g_pkg_name

3007: ------------------------------------------
3008: -- Validate the passed Proration Rule
3009: ------------------------------------------
3010:
3011: pn_index_rent_pvt.DEBUG ( g_pkg_name
3012: || g_program_unit||
3013: ' - Before calling pn_index_rent_utils.get_lookup_code proration_rule - '|| p_rent_index_rec.proration_rule
3014: ,3);
3015:

Line 3037: pn_index_rent_pvt.DEBUG ( g_pkg_name

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
3038: || g_program_unit||
3039: ' - After calling pn_index_rent_utils.get_lookup_code proration_rule - '|| p_rent_index_rec.proration_rule
3040: ,3);
3041:

Line 3058: pn_index_rent_pvt.DEBUG ( g_pkg_name

3054: --l_base_year := p_rent_index_rec.commencement_date;
3055: END IF;
3056:
3057:
3058: pn_index_rent_pvt.DEBUG ( g_pkg_name
3059: || g_program_unit||
3060: ' - End of validations base year - '|| p_rent_index_rec.base_year
3061: ,3);
3062:

Line 3245: pn_index_rent_pvt.DEBUG ( g_pkg_name

3241: RAISE fnd_api.g_exc_error;
3242: END IF;
3243:
3244: END IF;
3245: pn_index_rent_pvt.DEBUG ( g_pkg_name
3246: || g_program_unit||
3247: ' - End of validations base year - '|| p_rent_index_rec.base_year
3248: ,3);
3249:

Line 3286: pn_index_rent_pvt.DEBUG ( g_pkg_name

3282: END IF;
3283: END IF;
3284: END IF;
3285:
3286: pn_index_rent_pvt.DEBUG ( g_pkg_name
3287: || g_program_unit||
3288: ' - End of validations term_template_id - '|| p_rent_index_rec.term_template_id
3289: ,3);
3290:

Line 3337: pn_index_rent_pvt.DEBUG ( g_pkg_name

3333:
3334: END IF;
3335: END IF;
3336:
3337: pn_index_rent_pvt.DEBUG ( g_pkg_name
3338: || g_program_unit||
3339: ' - End of validations proration_rule - '|| p_rent_index_rec.proration_rule
3340: ,3);
3341:

Line 3449: pn_index_rent_pvt.DEBUG ( g_pkg_name

3445: IF p_rent_index_rec.index_lease_id IS NOT NULL
3446: OR p_rent_index_rec.index_lease_id <> pn_lease_utils.g_pn_miss_num
3447: THEN
3448:
3449: pn_index_rent_pvt.DEBUG ( g_pkg_name
3450: || g_program_unit||
3451: ' - Calling get_changed_index_rent_rec after validate_index_rent_rec '
3452: ,3);
3453:

Line 3472: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

3468: END IF;
3469: EXCEPTION
3470: WHEN fnd_api.g_exc_error
3471: THEN
3472: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
3473: || g_pkg_name
3474: || g_program_unit
3475: || '-'
3476: || SQLERRM

Line 3482: pn_index_rent_pvt.DEBUG ( 'Exception in '

3478: x_return_status := fnd_api.g_ret_sts_error;
3479:
3480: WHEN OTHERS
3481: THEN
3482: pn_index_rent_pvt.DEBUG ( 'Exception in '
3483: || g_pkg_name
3484: || g_program_unit
3485: || '-'
3486: || SQLERRM

Line 3512: pn_index_rent_pvt.DEBUG ( g_pkg_name

3508: ,x_index_lease_id
3509: ,x_scope
3510: );*/
3511:
3512: pn_index_rent_pvt.DEBUG ( g_pkg_name
3513: || g_program_unit||
3514: ' - Calling pn_index_lease_constraints_pkg.update_row for index_lease_id - '|| p_rent_index_rec.index_lease_id
3515: ,3);
3516:

Line 3556: pn_index_rent_pvt.DEBUG ( g_pkg_name

3552: (p_index_constraint_rec.last_update_login
3553: , fnd_global.user_id));
3554:
3555:
3556: pn_index_rent_pvt.DEBUG ( g_pkg_name
3557: || g_program_unit||
3558: ' - pn_index_lease_constraints_pkg.update_row successful. index_constraint_id - '||p_index_constraint_rec.index_constraint_id
3559: ,3);
3560: EXCEPTION

Line 3563: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

3559: ,3);
3560: EXCEPTION
3561: WHEN fnd_api.g_exc_error
3562: THEN
3563: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
3564: || g_pkg_name
3565: || g_program_unit
3566: || '-'
3567: || SQLERRM

Line 3573: pn_index_rent_pvt.DEBUG ( 'Exception in '

3569: x_return_status := fnd_api.g_ret_sts_error;
3570:
3571: WHEN OTHERS
3572: THEN
3573: pn_index_rent_pvt.DEBUG ( 'Exception in '
3574: || g_pkg_name
3575: || g_program_unit
3576: || '-'
3577: || SQLERRM

Line 3612: pn_index_rent_pvt.DEBUG ( g_pkg_name

3608: --RAISE ERROR;
3609: END IF;
3610:
3611:
3612: pn_index_rent_pvt.DEBUG ( g_pkg_name
3613: || g_program_unit||
3614: ' - Calling pn_index_lease_constraints_pkg.insert_row for index_constraint_id '
3615: ,3);
3616: pn_index_lease_constraints_pkg.insert_row

Line 3658: pn_index_rent_pvt.DEBUG ( g_pkg_name

3654: , x_last_update_login => NVL
3655: (p_index_constraint_rec.last_update_login
3656: , fnd_global.user_id));
3657:
3658: pn_index_rent_pvt.DEBUG ( g_pkg_name
3659: || g_program_unit||
3660: ' - pn_index_lease_constraints_pkg.insert_row successful.Index_constraint_id - '||p_index_constraint_rec.index_constraint_id
3661: ,3);
3662: IF p_index_constraint_rec.index_constraint_id >0

Line 3671: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

3667: END IF;
3668: EXCEPTION
3669: WHEN fnd_api.g_exc_error
3670: THEN
3671: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
3672: || g_pkg_name
3673: || g_program_unit
3674: || '-'
3675: || SQLERRM

Line 3683: pn_index_rent_pvt.DEBUG ( 'Exception in '

3679: x_return_status := fnd_api.g_ret_sts_error;
3680:
3681: WHEN OTHERS
3682: THEN
3683: pn_index_rent_pvt.DEBUG ( 'Exception in '
3684: || g_pkg_name
3685: || g_program_unit
3686: || '-'
3687: || SQLERRM

Line 3746: pn_index_rent_pvt.DEBUG ( g_pkg_name

3742: BEGIN
3743: g_program_unit := 'GET_CHANGED_CONSTRAINT_REC';
3744: x_return_status := fnd_api.g_ret_sts_success;
3745:
3746: pn_index_rent_pvt.DEBUG ( g_pkg_name
3747: || g_program_unit
3748: || ' Inside get_changed_constraint_rec procedure'
3749: , 3);
3750:

Line 3758: pn_index_rent_pvt.DEBUG ( g_pkg_name

3754: INTO l_constraint_rec_old;
3755:
3756: IF (c_old_constraint_values%NOTFOUND)
3757: THEN
3758: pn_index_rent_pvt.DEBUG ( g_pkg_name
3759: || g_program_unit
3760: || ' CURSOR c_old_constraint_values failed to return the existing record'
3761: , 3);
3762: x_return_status := fnd_api.g_ret_sts_error;

Line 3989: pn_index_rent_pvt.DEBUG ( g_pkg_name

3985: IF c_old_constraint_values%ISOPEN
3986: THEN
3987: CLOSE c_old_constraint_values;
3988: END IF;
3989: pn_index_rent_pvt.DEBUG ( g_pkg_name
3990: || g_program_unit
3991: || ' End of get_changed_constraint_rec procedure'
3992: , 3);
3993: EXCEPTION

Line 4024: pn_index_rent_pvt.DEBUG ( g_pkg_name

4020: --l_operation VARCHAR2 (30);
4021: BEGIN
4022: g_program_unit := 'VALIDATE_INDEX_CONSTRAINT_TBL';
4023: x_return_status := fnd_api.g_ret_sts_success;
4024: pn_index_rent_pvt.DEBUG ( g_pkg_name
4025: || g_program_unit
4026: || ' Inside validate_index_constraint_tbl procedure'
4027: , 3);
4028:

Line 4175: pn_index_rent_pvt.DEBUG(

4171: THEN
4172: IF (x_return_status = fnd_api.g_ret_sts_success) AND p_validate=fnd_api.g_false
4173: THEN
4174:
4175: pn_index_rent_pvt.DEBUG(
4176: g_pkg_name
4177: || g_program_unit
4178: || ' Calling insert_index_constraint_row from validate_index_constraint_tbl procedure'
4179: , 3);

Line 4204: pn_index_rent_pvt.DEBUG ( g_pkg_name

4200: THEN
4201: IF ( p_index_constraint_tbl (i).index_constraint_id IS NOT NULL AND p_index_constraint_tbl (i).index_constraint_id <>pn_index_rent_utils.g_pn_miss_num)
4202: THEN
4203:
4204: pn_index_rent_pvt.DEBUG ( g_pkg_name
4205: || g_program_unit
4206: || ' Inside validate_index_constraint_tbl procedure calling get_changed_constraint_rec'
4207: , 3);
4208:

Line 4242: pn_index_rent_pvt.DEBUG ( g_pkg_name

4238: IF (x_return_status = fnd_api.g_ret_sts_success) AND p_validate=fnd_api.g_false
4239: THEN
4240:
4241:
4242: pn_index_rent_pvt.DEBUG ( g_pkg_name
4243: || g_program_unit
4244: || ' Calling update_constraint_row from validate_index_constraint_tbl procedure'
4245: , 3);
4246:

Line 4256: pn_index_rent_pvt.DEBUG(

4252: , x_msg_count => x_msg_count
4253: , x_msg_data => x_msg_data);
4254: ELSE
4255:
4256: pn_index_rent_pvt.DEBUG(
4257: g_pkg_name
4258: || g_program_unit
4259: || ' Calling insert_index_constraint_row from validate_index_constraint_tbl procedure'
4260: , 3);

Line 4293: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

4289: , x_msg_data => x_msg_count);
4290: EXCEPTION
4291: WHEN fnd_api.g_exc_error
4292: THEN
4293: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
4294: || g_pkg_name
4295: || g_program_unit
4296: || '-'
4297: || SQLERRM

Line 4303: pn_index_rent_pvt.DEBUG ( 'Exception in '

4299: x_return_status := fnd_api.g_ret_sts_error;
4300:
4301: WHEN OTHERS
4302: THEN
4303: pn_index_rent_pvt.DEBUG ( 'Exception in '
4304: || g_pkg_name
4305: || g_program_unit
4306: || '-'
4307: || SQLERRM

Line 4333: g_pkg_name := 'PN_INDEX_RENT_PVT.';

4329: l_msg VARCHAR2 (100);
4330:
4331: BEGIN
4332: l_operation := 'CREATE_RENT_INDEX';
4333: g_pkg_name := 'PN_INDEX_RENT_PVT.';
4334: g_program_unit := 'CREATE_INDEX_RENT';
4335:
4336: x_return_status := fnd_api.g_ret_sts_success;
4337:

Line 4351: pn_index_rent_pvt.DEBUG ( g_pkg_name

4347: ELSE
4348: p_rent_index_rec.org_id:=FND_PROFILE.VALUE('ORG_ID');
4349: END IF;
4350:
4351: pn_index_rent_pvt.DEBUG ( g_pkg_name
4352: || g_program_unit
4353: || ' Org Id set to:'||p_rent_index_rec.org_id
4354: , 3);
4355: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 4355: pn_index_rent_pvt.DEBUG ( g_pkg_name

4351: pn_index_rent_pvt.DEBUG ( g_pkg_name
4352: || g_program_unit
4353: || ' Org Id set to:'||p_rent_index_rec.org_id
4354: , 3);
4355: pn_index_rent_pvt.DEBUG ( g_pkg_name
4356: || g_program_unit
4357: || ' Calling validate_index_rent_rec procedure from main'
4358: , 3);
4359:

Line 4372: pn_index_rent_pvt.DEBUG ( g_pkg_name

4368:
4369: IF (x_return_status = fnd_api.g_ret_sts_error)
4370: THEN
4371:
4372: pn_index_rent_pvt.DEBUG ( g_pkg_name
4373: || g_program_unit
4374: || ' validate_index_rent_rec procedure returned error'
4375: , 3);
4376:

Line 4382: pn_index_rent_pvt.DEBUG ( g_pkg_name

4378:
4379: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
4380: THEN
4381:
4382: pn_index_rent_pvt.DEBUG ( g_pkg_name
4383: || g_program_unit
4384: || ' validate_index_rent_rec procedure returned unexpected error'
4385: , 3);
4386:

Line 4391: pn_index_rent_pvt.DEBUG (' Calling INSERT_INDEX_RENT_ROW procedure from main', 3);

4387: RAISE fnd_api.g_exc_unexpected_error;
4388: END IF;
4389:
4390:
4391: pn_index_rent_pvt.DEBUG (' Calling INSERT_INDEX_RENT_ROW procedure from main', 3);
4392:
4393: IF (x_return_status = fnd_api.g_ret_sts_success)
4394: THEN
4395: pn_index_rent_pvt.DEBUG ( g_pkg_name

Line 4395: pn_index_rent_pvt.DEBUG ( g_pkg_name

4391: pn_index_rent_pvt.DEBUG (' Calling INSERT_INDEX_RENT_ROW procedure from main', 3);
4392:
4393: IF (x_return_status = fnd_api.g_ret_sts_success)
4394: THEN
4395: pn_index_rent_pvt.DEBUG ( g_pkg_name
4396: || g_program_unit
4397: || ' Calling insert_index_rent_row procedure from main'
4398: , 3);
4399:

Line 4403: pn_index_rent_pvt.DEBUG ( g_pkg_name

4399:
4400: IF p_validate=fnd_api.g_false
4401: THEN
4402:
4403: pn_index_rent_pvt.DEBUG ( g_pkg_name
4404: || g_program_unit
4405: || ' Calling insert_index_rent_row procedure from main'
4406: , 3);
4407: insert_index_rent_row (p_rent_index_rec => p_rent_index_rec

Line 4425: pn_index_rent_pvt.DEBUG ( g_pkg_name

4421:
4422: IF (x_return_status = fnd_api.g_ret_sts_success) and (p_index_constraint_tbl.count>0)
4423: THEN
4424:
4425: pn_index_rent_pvt.DEBUG ( g_pkg_name
4426: || g_program_unit
4427: || ' Calling validate_index_constraint_tbl procedure from main'
4428: , 3);
4429:

Line 4433: pn_index_rent_pvt.DEBUG (' Calling Validate_index_constraint_tbl procedure from main', 3);

4429:
4430:
4431: l_operation := 'CREATE_CONSTRAINTS';
4432:
4433: pn_index_rent_pvt.DEBUG (' Calling Validate_index_constraint_tbl procedure from main', 3);
4434:
4435: validate_index_constraint_tbl (p_index_constraint_tbl => p_index_constraint_tbl
4436: , p_rent_index_rec => p_rent_index_rec
4437: , p_validate => p_validate

Line 4462: pn_index_rent_pvt.DEBUG ( g_pkg_name

4458:
4459: IF (x_return_status = fnd_api.g_ret_sts_success)
4460: THEN
4461:
4462: pn_index_rent_pvt.DEBUG ( g_pkg_name
4463: || g_program_unit
4464: || ' Generating Periods '
4465: , 3);
4466: l_period_exists :=

Line 4471: pn_index_rent_pvt.DEBUG ( g_pkg_name

4467: pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);
4468:
4469: IF l_period_exists IS NULL
4470: THEN
4471: pn_index_rent_pvt.DEBUG ( g_pkg_name
4472: || g_program_unit
4473: || ' Generating Periods after period_exists check'
4474: , 3);
4475: pn_index_rent_periods_pkg.generate_periods

Line 4489: pn_index_rent_pvt.DEBUG ( g_pkg_name

4485: END IF;
4486: END IF;
4487:
4488:
4489: pn_index_rent_pvt.DEBUG ( g_pkg_name
4490: || g_program_unit
4491: || ' End of create_index_rent'
4492: , 3);
4493: EXCEPTION

Line 4496: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

4492: , 3);
4493: EXCEPTION
4494: WHEN fnd_api.g_exc_error
4495: THEN
4496: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
4497: || g_pkg_name
4498: || g_program_unit
4499: || '-'
4500: || SQLERRM

Line 4506: pn_index_rent_pvt.DEBUG ( 'Exception in '

4502: x_return_status := fnd_api.g_ret_sts_error;
4503:
4504: WHEN OTHERS
4505: THEN
4506: pn_index_rent_pvt.DEBUG ( 'Exception in '
4507: || g_pkg_name
4508: || g_program_unit
4509: || '-'
4510: || SQLERRM

Line 4535: g_pkg_name := 'PN_INDEX_RENT_PVT.';

4531: l_period_exists NUMBER;
4532: l_msg VARCHAR2 (100);
4533: BEGIN
4534: l_operation := 'UPDATE_INDEX_RENT';
4535: g_pkg_name := 'PN_INDEX_RENT_PVT.';
4536: g_program_unit := NULL;
4537: x_return_status := fnd_api.g_ret_sts_success;
4538:
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

Line 4552: pn_index_rent_pvt.DEBUG ( g_pkg_name

4548: ELSE
4549: p_rent_index_rec.org_id:=FND_PROFILE.VALUE('ORG_ID');
4550: END IF;
4551:
4552: pn_index_rent_pvt.DEBUG ( g_pkg_name
4553: || g_program_unit
4554: || ' Calling VALIDATE_INDEX_RENT_REC procedure from update main'
4555: , 3);
4556:

Line 4577: pn_index_rent_pvt.DEBUG ( g_pkg_name

4573: IF (x_return_status = fnd_api.g_ret_sts_success)
4574: THEN
4575: IF p_validate=fnd_api.g_false
4576: THEN
4577: pn_index_rent_pvt.DEBUG ( g_pkg_name
4578: || g_program_unit
4579: || ' Calling update_index_rent_row procedure from update main'
4580: , 3);
4581:

Line 4603: pn_index_rent_pvt.DEBUG ( g_pkg_name

4599:
4600: IF (x_return_status = fnd_api.g_ret_sts_success) and (p_index_constraint_tbl.count>0)
4601: THEN
4602:
4603: pn_index_rent_pvt.DEBUG ( g_pkg_name
4604: || g_program_unit
4605: || ' Calling validate_index_constraint_tbl procedure from update main'
4606: , 3);
4607: l_operation := 'UPDATE_INDEX_RENT_CONSTRAINTS';

Line 4609: --pn_index_rent_pvt.DEBUG (' Calling VALIDATE_INDEX_CONSTRAINT_TBL procedure', 3);

4605: || ' Calling validate_index_constraint_tbl procedure from update main'
4606: , 3);
4607: l_operation := 'UPDATE_INDEX_RENT_CONSTRAINTS';
4608:
4609: --pn_index_rent_pvt.DEBUG (' Calling VALIDATE_INDEX_CONSTRAINT_TBL procedure', 3);
4610: validate_index_constraint_tbl (p_index_constraint_tbl => p_index_constraint_tbl
4611: , p_rent_index_rec => p_rent_index_rec
4612: , p_validate => p_validate
4613: , p_operation => l_operation

Line 4638: pn_index_rent_pvt.DEBUG (g_pkg_name

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
4640: || ' Undo Periods if approved periods are not found'
4641: , 3);
4642: pn_index_rent_periods_pkg.undo_periods(p_index_lease_id => p_rent_index_rec.index_lease_id,

Line 4650: pn_index_rent_pvt.DEBUG ( g_pkg_name

4646:
4647: IF (x_return_status = fnd_api.g_ret_sts_success AND l_msg<>'PN_UNDO_PRDS_FAIL_APPROVE_PRDS')
4648: THEN
4649:
4650: pn_index_rent_pvt.DEBUG ( g_pkg_name
4651: || g_program_unit
4652: || ' Generating Periods '
4653: , 3);
4654: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);

Line 4658: pn_index_rent_pvt.DEBUG ( g_pkg_name

4654: l_period_exists := pn_index_lease_common_pkg.find_if_period_exists (p_rent_index_rec.index_lease_id);
4655:
4656: IF l_period_exists IS NULL
4657: THEN
4658: pn_index_rent_pvt.DEBUG ( g_pkg_name
4659: || g_program_unit
4660: || ' Generating Periods after period_exists check'
4661: , 3);
4662: pn_index_rent_periods_pkg.generate_periods(ip_index_lease_id => p_rent_index_rec.index_lease_id

Line 4677: pn_index_rent_pvt.DEBUG ( 'Error occurred in '

4673:
4674: EXCEPTION
4675: WHEN fnd_api.g_exc_error
4676: THEN
4677: pn_index_rent_pvt.DEBUG ( 'Error occurred in '
4678: || g_pkg_name
4679: || g_program_unit
4680: || '-'
4681: || SQLERRM

Line 4687: pn_index_rent_pvt.DEBUG ( 'Exception in '

4683: x_return_status := fnd_api.g_ret_sts_error;
4684:
4685: WHEN OTHERS
4686: THEN
4687: pn_index_rent_pvt.DEBUG ( 'Exception in '
4688: || g_pkg_name
4689: || g_program_unit
4690: || '-'
4691: || SQLERRM

Line 4696: END pn_index_rent_pvt;

4692: , 5);
4693: x_return_status := fnd_api.g_ret_sts_unexp_error;
4694: END update_index_rent;
4695:
4696: END pn_index_rent_pvt;