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_LEASE_UTILS

Line 170: pn_lease_utils.validate_desc_flex (p_api_name => g_pkg_name||'.'||g_program_unit

166: AND (p_index_constraint_tbl(i).attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_index_constraint_tbl(i).attribute15 IS NULL)
167: )
168: THEN
169:
170: pn_lease_utils.validate_desc_flex (p_api_name => g_pkg_name||'.'||g_program_unit
171: , p_application_short_name => 'PN'
172: , p_desc_flex_name => 'PN_INDEX_CONSTRAINTS'
173: , p_desc_segment1 => p_index_constraint_tbl(i).attribute1
174: , p_desc_segment2 => p_index_constraint_tbl(i).attribute2

Line 327: pn_lease_utils.validate_desc_flex ( p_api_name => g_pkg_name||'.'||g_program_unit

323: AND (p_rent_index_rec.attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.attribute15 IS NULL)
324: )
325: THEN
326:
327: pn_lease_utils.validate_desc_flex ( p_api_name => g_pkg_name||'.'||g_program_unit
328: , p_application_short_name => 'PN'
329: , p_desc_flex_name => 'PN_INDEX_RENT'
330: , p_desc_segment1 => p_rent_index_rec.attribute1
331: , p_desc_segment2 => p_rent_index_rec.attribute2

Line 469: pn_lease_utils.validate_desc_flex ( p_api_name => g_pkg_name||'.'||g_program_unit

465: AND (p_rent_index_rec.agreement_attribute15 = pn_index_rent_utils.g_pn_miss_char OR p_rent_index_rec.agreement_attribute15 IS NULL)
466: )
467: THEN
468:
469: pn_lease_utils.validate_desc_flex ( p_api_name => g_pkg_name||'.'||g_program_unit
470: , p_application_short_name => 'PN'
471: , p_desc_flex_name => 'PN_INDEX_AGREEMENT'
472: , p_desc_segment1 => p_rent_index_rec.agreement_attribute1
473: , p_desc_segment2 => p_rent_index_rec.agreement_attribute2

Line 2728: ' - Before calling pn_lease_utils.get_term_template_id term_template_id - '|| p_rent_index_rec.term_template_id

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:
2731: IF l_lease_class_code = 'DIRECT'
2732: --OR p_lease_rec.lease_class = 'Expense'

Line 2740: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)

2736: l_term_template_type := 'BILLING';
2737: END IF;
2738:
2739: IF ( ( p_rent_index_rec.term_template_id IS NOT NULL
2740: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)
2741: OR ( p_rent_index_rec.term_template_name IS NOT NULL
2742: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))
2743: THEN
2744: pn_lease_utils.get_term_template_id

Line 2742: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))

2738:
2739: IF ( ( p_rent_index_rec.term_template_id IS NOT NULL
2740: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)
2741: OR ( p_rent_index_rec.term_template_name IS NOT NULL
2742: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))
2743: THEN
2744: pn_lease_utils.get_term_template_id
2745: (p_parameter_name => l_param_lease_template
2746: , p_termtemp_name => p_rent_index_rec.term_template_name

Line 2744: pn_lease_utils.get_term_template_id

2740: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)
2741: OR ( p_rent_index_rec.term_template_name IS NOT NULL
2742: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))
2743: THEN
2744: pn_lease_utils.get_term_template_id
2745: (p_parameter_name => l_param_lease_template
2746: , p_termtemp_name => p_rent_index_rec.term_template_name
2747: , p_operation => p_operation
2748: , p_termtemp_type => l_term_template_type

Line 2765: ' - After calling pn_lease_utils.get_term_template_id term_template_id - '|| p_rent_index_rec.term_template_id

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:
2768: -- Below If Block code has been added by Vivek on 27NOV2010
2769: --

Line 2771: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)

2767:
2768: -- Below If Block code has been added by Vivek on 27NOV2010
2769: --
2770: IF ( ( p_rent_index_rec.term_template_id IS NOT NULL
2771: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)
2772: OR ( p_rent_index_rec.term_template_name IS NOT NULL
2773: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))
2774:
2775: AND( p_rent_index_rec.aggregation_flag IS NOT NULL

Line 2773: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))

2769: --
2770: IF ( ( p_rent_index_rec.term_template_id IS NOT NULL
2771: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num)
2772: OR ( p_rent_index_rec.term_template_name IS NOT NULL
2773: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))
2774:
2775: AND( p_rent_index_rec.aggregation_flag IS NOT NULL
2776: AND p_rent_index_rec.aggregation_flag<> pn_lease_utils.g_pn_miss_char
2777: AND p_rent_index_rec.aggregation_flag='Y')

Line 2776: AND p_rent_index_rec.aggregation_flag<> pn_lease_utils.g_pn_miss_char

2772: OR ( p_rent_index_rec.term_template_name IS NOT NULL
2773: AND p_rent_index_rec.term_template_name <> pn_lease_utils.g_pn_miss_char))
2774:
2775: AND( p_rent_index_rec.aggregation_flag IS NOT NULL
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');

Line 2790: AND p_rent_index_rec.commencement_date <> pn_lease_utils.g_pn_miss_date

2786: ----
2787:
2788:
2789: IF ( p_rent_index_rec.commencement_date IS NOT NULL
2790: AND p_rent_index_rec.commencement_date <> pn_lease_utils.g_pn_miss_date
2791: AND p_rent_index_rec.commencement_date= l_lease_commencement_date)
2792: THEN
2793: IF p_rent_index_rec.term_template_id IS NULL
2794: OR p_rent_index_rec.term_template_id =pn_lease_utils.g_pn_miss_num

Line 2794: OR p_rent_index_rec.term_template_id =pn_lease_utils.g_pn_miss_num

2790: AND p_rent_index_rec.commencement_date <> pn_lease_utils.g_pn_miss_date
2791: AND p_rent_index_rec.commencement_date= l_lease_commencement_date)
2792: THEN
2793: IF p_rent_index_rec.term_template_id IS NULL
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');

Line 2805: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num))

2801: RAISE fnd_api.g_exc_error;
2802: END IF;
2803:
2804: ELSIF (( p_rent_index_rec.term_template_id IS NOT NULL
2805: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num))
2806: THEN
2807: p_rent_index_rec.aggregation_flag := 'N';
2808:
2809: --END IF;

Line 2823: AND p_rent_index_rec.negative_rent_type <> pn_lease_utils.g_pn_miss_char)

2819: ,3);
2820:
2821:
2822: IF ( ( p_rent_index_rec.negative_rent_type IS NOT NULL
2823: AND p_rent_index_rec.negative_rent_type <> pn_lease_utils.g_pn_miss_char)
2824: OR ( p_rent_index_rec.negative_rent_type_meaning IS NOT NULL
2825: AND p_rent_index_rec.negative_rent_type_meaning <> pn_lease_utils.g_pn_miss_char))
2826: THEN
2827: pn_index_rent_utils.get_lookup_code

Line 2825: AND p_rent_index_rec.negative_rent_type_meaning <> pn_lease_utils.g_pn_miss_char))

2821:
2822: IF ( ( p_rent_index_rec.negative_rent_type IS NOT NULL
2823: AND p_rent_index_rec.negative_rent_type <> pn_lease_utils.g_pn_miss_char)
2824: OR ( p_rent_index_rec.negative_rent_type_meaning IS NOT NULL
2825: AND p_rent_index_rec.negative_rent_type_meaning <> pn_lease_utils.g_pn_miss_char))
2826: THEN
2827: pn_index_rent_utils.get_lookup_code
2828: (p_parameter_name => l_negative_rent_type_param
2829: , p_operation => p_operation

Line 2866: AND p_rent_index_rec.spread_frequency <> pn_lease_utils.g_pn_miss_char)

2862: ' - Before calling pn_index_rent_utils.get_lookup_code spread_frequency - '|| p_rent_index_rec.spread_frequency
2863: ,3);
2864:
2865: IF ( ( p_rent_index_rec.spread_frequency IS NOT NULL
2866: AND p_rent_index_rec.spread_frequency <> pn_lease_utils.g_pn_miss_char)
2867: OR ( p_rent_index_rec.spread_frequency_meaning IS NOT NULL
2868: AND p_rent_index_rec.spread_frequency_meaning <> pn_lease_utils.g_pn_miss_char))
2869: THEN
2870: pn_index_rent_utils.get_lookup_code

Line 2868: AND p_rent_index_rec.spread_frequency_meaning <> pn_lease_utils.g_pn_miss_char))

2864:
2865: IF ( ( p_rent_index_rec.spread_frequency IS NOT NULL
2866: AND p_rent_index_rec.spread_frequency <> pn_lease_utils.g_pn_miss_char)
2867: OR ( p_rent_index_rec.spread_frequency_meaning IS NOT NULL
2868: AND p_rent_index_rec.spread_frequency_meaning <> pn_lease_utils.g_pn_miss_char))
2869: THEN
2870: pn_index_rent_utils.get_lookup_code
2871: (p_parameter_name => l_spread_frequency_param
2872: , p_operation => p_operation

Line 2887: OR p_rent_index_rec.spread_frequency = pn_lease_utils.g_pn_miss_char))

2883: END IF;
2884: END IF;
2885:
2886: IF ( ( p_rent_index_rec.spread_frequency IS NULL
2887: OR p_rent_index_rec.spread_frequency = pn_lease_utils.g_pn_miss_char))
2888:
2889: THEN
2890: p_rent_index_rec.spread_frequency:='MON';
2891: END IF;

Line 2908: AND p_rent_index_rec.index_finder_months <> pn_lease_utils.g_pn_miss_num)

2904: ' - Before validating index_finder_months - '|| p_rent_index_rec.index_finder_months
2905: ,3);
2906:
2907: IF ( p_rent_index_rec.index_finder_months IS NOT NULL
2908: AND p_rent_index_rec.index_finder_months <> pn_lease_utils.g_pn_miss_num)
2909: THEN
2910: IF MOD (p_rent_index_rec.index_finder_months, 1) <> 0
2911: THEN
2912: l_error_count:=l_error_count+1;

Line 2938: OR p_rent_index_rec.initial_basis =pn_lease_utils.g_pn_miss_num)

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

Line 2967: AND p_rent_index_rec.index_multiplier <> pn_lease_utils.g_pn_miss_num

2963: ' - Before validating index_multiplier - '|| p_rent_index_rec.index_multiplier
2964: ,3);
2965:
2966: IF p_rent_index_rec.index_multiplier IS NOT NULL
2967: AND p_rent_index_rec.index_multiplier <> pn_lease_utils.g_pn_miss_num
2968: THEN
2969: IF p_rent_index_rec.index_multiplier <= 0
2970: THEN
2971: l_error_count:=l_error_count+1;

Line 2996: AND p_rent_index_rec.gross_flag <> pn_lease_utils.g_pn_miss_char

2992: ------------------------------------------
2993: -- Validate the passed Gross Flag
2994: ------------------------------------------
2995: IF p_rent_index_rec.gross_flag IS NOT NULL
2996: AND p_rent_index_rec.gross_flag <> pn_lease_utils.g_pn_miss_char
2997: THEN
2998: IF NVL (p_rent_index_rec.gross_flag, 'N') = 'Y'
2999: THEN
3000: --IF p_rent_index_rec.increase_on IS NOT NULL OR p_rent_index_rec.increase_on <> pn_lease_utils.g_pn_miss_char

Line 3000: --IF p_rent_index_rec.increase_on IS NOT NULL OR p_rent_index_rec.increase_on <> pn_lease_utils.g_pn_miss_char

2996: AND p_rent_index_rec.gross_flag <> pn_lease_utils.g_pn_miss_char
2997: THEN
2998: IF NVL (p_rent_index_rec.gross_flag, 'N') = 'Y'
2999: THEN
3000: --IF p_rent_index_rec.increase_on IS NOT NULL OR p_rent_index_rec.increase_on <> pn_lease_utils.g_pn_miss_char
3001: --THEN
3002: p_rent_index_rec.increase_on := NULL;
3003: --END IF;
3004: END IF;

Line 3017: AND p_rent_index_rec.proration_rule <> pn_lease_utils.g_pn_miss_char)

3013: ' - Before calling pn_index_rent_utils.get_lookup_code proration_rule - '|| p_rent_index_rec.proration_rule
3014: ,3);
3015:
3016: IF ( ( p_rent_index_rec.proration_rule IS NOT NULL
3017: AND p_rent_index_rec.proration_rule <> pn_lease_utils.g_pn_miss_char)
3018: OR ( p_rent_index_rec.proration_rule_meaning IS NOT NULL
3019: AND p_rent_index_rec.proration_rule_meaning <> pn_lease_utils.g_pn_miss_char))
3020: THEN
3021: pn_index_rent_utils.get_lookup_code

Line 3019: AND p_rent_index_rec.proration_rule_meaning <> pn_lease_utils.g_pn_miss_char))

3015:
3016: IF ( ( p_rent_index_rec.proration_rule IS NOT NULL
3017: AND p_rent_index_rec.proration_rule <> pn_lease_utils.g_pn_miss_char)
3018: OR ( p_rent_index_rec.proration_rule_meaning IS NOT NULL
3019: AND p_rent_index_rec.proration_rule_meaning <> pn_lease_utils.g_pn_miss_char))
3020: THEN
3021: pn_index_rent_utils.get_lookup_code
3022: (p_parameter_name => l_constraint_proration_param
3023: , p_operation => p_operation

Line 3251: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num

3247: ' - End of validations base year - '|| p_rent_index_rec.base_year
3248: ,3);
3249:
3250: IF p_rent_index_rec.term_template_id IS NOT NULL
3251: AND p_rent_index_rec.term_template_id <> pn_lease_utils.g_pn_miss_num
3252: THEN
3253:
3254: IF NOT pnp_util_func.validate_term_template
3255: (p_term_temp_id => p_rent_index_rec.term_template_id

Line 3446: OR p_rent_index_rec.index_lease_id <> pn_lease_utils.g_pn_miss_num

3442: THEN
3443:
3444:
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||

Line 4211: OR p_rent_index_rec.index_lease_id <> pn_lease_utils.g_pn_miss_num)

4207: , 3);
4208:
4209:
4210: IF ( p_rent_index_rec.index_lease_id IS NOT NULL
4211: OR p_rent_index_rec.index_lease_id <> pn_lease_utils.g_pn_miss_num)
4212: AND ( p_index_constraint_tbl (i).index_constraint_id IS NOT NULL
4213: OR p_index_constraint_tbl (i).index_constraint_id <> pn_lease_utils.g_pn_miss_num)
4214: THEN
4215:

Line 4213: OR p_index_constraint_tbl (i).index_constraint_id <> pn_lease_utils.g_pn_miss_num)

4209:
4210: IF ( p_rent_index_rec.index_lease_id IS NOT NULL
4211: OR p_rent_index_rec.index_lease_id <> pn_lease_utils.g_pn_miss_num)
4212: AND ( p_index_constraint_tbl (i).index_constraint_id IS NOT NULL
4213: OR p_index_constraint_tbl (i).index_constraint_id <> pn_lease_utils.g_pn_miss_num)
4214: THEN
4215:
4216: get_changed_constraint_rec (p_index_constraint_rec => p_index_constraint_tbl(i)
4217: , p_rent_index_rec => p_rent_index_rec