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_PUB dependencies on PN_INDEX_RENT_UTILS

Line 75: 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

71: END IF;
72:
73:
74:
75: 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
76: THEN
77: IF p_rent_index_rec.org_id<>fnd_global.org_id
78: THEN
79: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 102: IF ( p_rent_index_rec .index_lease_number IS NULL OR p_rent_index_rec .index_lease_number = pn_index_rent_utils.g_pn_miss_char)

98: -- Make sure the Index Lease Number is not null if Auto Index Lease Number is setup to No
99:
100: IF (NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_INDEX_RENT_NUMBERING', g_org_id), 'N')) <> 'Y'
101: THEN
102: IF ( p_rent_index_rec .index_lease_number IS NULL OR p_rent_index_rec .index_lease_number = pn_index_rent_utils.g_pn_miss_char)
103: THEN
104: l_null_param := 'INDEX_LEASE_NUMBER';
105: pn_index_rent_pvt.debug (l_func_name ||': INDEX_LEASE_NUMBER IS NULL',3);
106: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');

Line 118: OR p_rent_index_rec.lease_id = pn_index_rent_utils.g_pn_miss_num

114: ---------------------------------------------------------------
115: -- Make sure the Lease id or Lease ID or Lease Num is not null
116: ---------------------------------------------------------------
117: IF (p_rent_index_rec .lease_id IS NULL
118: OR p_rent_index_rec.lease_id = pn_index_rent_utils.g_pn_miss_num
119: )
120: AND (p_rent_index_rec .lease_num IS NULL
121: OR p_rent_index_rec.lease_num = pn_index_rent_utils.g_pn_miss_char
122: )

Line 121: OR p_rent_index_rec.lease_num = pn_index_rent_utils.g_pn_miss_char

117: IF (p_rent_index_rec .lease_id IS NULL
118: OR p_rent_index_rec.lease_id = pn_index_rent_utils.g_pn_miss_num
119: )
120: AND (p_rent_index_rec .lease_num IS NULL
121: OR p_rent_index_rec.lease_num = pn_index_rent_utils.g_pn_miss_char
122: )
123:
124: THEN
125: l_null_param := 'LEASE_NUM , LEASE_ID';

Line 138: IF ( (p_rent_index_rec .index_id IS NULL OR p_rent_index_rec .index_id = pn_index_rent_utils.g_pn_miss_num)

134:
135: ---------------------------------------------------
136: -- Make sure the Index Type or Index id is not null
137: ---------------------------------------------------
138: IF ( (p_rent_index_rec .index_id IS NULL OR p_rent_index_rec .index_id = pn_index_rent_utils.g_pn_miss_num)
139: AND (p_rent_index_rec .index_type IS NULL OR p_rent_index_rec.index_type = pn_index_rent_utils.g_pn_miss_char)
140: )
141: THEN
142: l_null_param := 'INDEX_ID , INDEX_TYPE';

Line 139: AND (p_rent_index_rec .index_type IS NULL OR p_rent_index_rec.index_type = pn_index_rent_utils.g_pn_miss_char)

135: ---------------------------------------------------
136: -- Make sure the Index Type or Index id is not null
137: ---------------------------------------------------
138: IF ( (p_rent_index_rec .index_id IS NULL OR p_rent_index_rec .index_id = pn_index_rent_utils.g_pn_miss_num)
139: AND (p_rent_index_rec .index_type IS NULL OR p_rent_index_rec.index_type = pn_index_rent_utils.g_pn_miss_char)
140: )
141: THEN
142: l_null_param := 'INDEX_ID , INDEX_TYPE';
143: pn_index_rent_pvt.debug (l_func_name||': INDEX_ID , INDEX_TYPE ARE NULL',3);

Line 154: IF ( (p_rent_index_rec .increase_on IS NULL OR p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char)

150:
151: -----------------------------------------------------------------------------
152: -- Make sure the Increase on or Increase on meaning or Gross flag is not null
153: -- ---------------------------------------------------------------------------
154: IF ( (p_rent_index_rec .increase_on IS NULL OR p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char)
155: AND (p_rent_index_rec .increase_on_meaning IS NULL OR p_rent_index_rec.increase_on_meaning = pn_index_rent_utils.g_pn_miss_char)
156: AND (p_rent_index_rec .gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char)
157: )
158: THEN

Line 155: AND (p_rent_index_rec .increase_on_meaning IS NULL OR p_rent_index_rec.increase_on_meaning = pn_index_rent_utils.g_pn_miss_char)

151: -----------------------------------------------------------------------------
152: -- Make sure the Increase on or Increase on meaning or Gross flag is not null
153: -- ---------------------------------------------------------------------------
154: IF ( (p_rent_index_rec .increase_on IS NULL OR p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char)
155: AND (p_rent_index_rec .increase_on_meaning IS NULL OR p_rent_index_rec.increase_on_meaning = pn_index_rent_utils.g_pn_miss_char)
156: AND (p_rent_index_rec .gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char)
157: )
158: THEN
159: l_null_param := 'INCREASE_ON , INCREASE_ON_MEANING , GROSS_FLAG';

Line 156: AND (p_rent_index_rec .gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char)

152: -- Make sure the Increase on or Increase on meaning or Gross flag is not null
153: -- ---------------------------------------------------------------------------
154: IF ( (p_rent_index_rec .increase_on IS NULL OR p_rent_index_rec.increase_on = pn_index_rent_utils.g_pn_miss_char)
155: AND (p_rent_index_rec .increase_on_meaning IS NULL OR p_rent_index_rec.increase_on_meaning = pn_index_rent_utils.g_pn_miss_char)
156: AND (p_rent_index_rec .gross_flag IS NULL OR p_rent_index_rec.gross_flag = pn_index_rent_utils.g_pn_miss_char)
157: )
158: THEN
159: l_null_param := 'INCREASE_ON , INCREASE_ON_MEANING , GROSS_FLAG';
160: pn_index_rent_pvt.debug (l_func_name||': INCREASE_ON , INCREASE_ON_MEANING , GROSS_FLAG ARE NULL',3);

Line 172: IF ( (p_rent_index_rec .relationship_default IS NULL OR p_rent_index_rec .relationship_default = pn_index_rent_utils.g_pn_miss_char)

168:
169: -------------------------------------------------------------------------------------------------
170: -- Make sure RELATIONSHIP_DEFAULT,RELATIONSHIP_DEFAULT_MEANING,BASIS_PERCENT_DEFAULT,BASE_YEAR,BASE_INDEX ARE NOT NULL
171: ------------------------------------------------------------------------------------------------
172: IF ( (p_rent_index_rec .relationship_default IS NULL OR p_rent_index_rec .relationship_default = pn_index_rent_utils.g_pn_miss_char)
173: AND (p_rent_index_rec .relationship_default_meaning IS NULL OR p_rent_index_rec .relationship_default_meaning = pn_index_rent_utils.g_pn_miss_char)
174: )
175: AND
176: (p_rent_index_rec .basis_percent_default IS NULL OR p_rent_index_rec .basis_percent_default = pn_index_rent_utils.g_pn_miss_num )

Line 173: AND (p_rent_index_rec .relationship_default_meaning IS NULL OR p_rent_index_rec .relationship_default_meaning = pn_index_rent_utils.g_pn_miss_char)

169: -------------------------------------------------------------------------------------------------
170: -- Make sure RELATIONSHIP_DEFAULT,RELATIONSHIP_DEFAULT_MEANING,BASIS_PERCENT_DEFAULT,BASE_YEAR,BASE_INDEX ARE NOT NULL
171: ------------------------------------------------------------------------------------------------
172: IF ( (p_rent_index_rec .relationship_default IS NULL OR p_rent_index_rec .relationship_default = pn_index_rent_utils.g_pn_miss_char)
173: AND (p_rent_index_rec .relationship_default_meaning IS NULL OR p_rent_index_rec .relationship_default_meaning = pn_index_rent_utils.g_pn_miss_char)
174: )
175: AND
176: (p_rent_index_rec .basis_percent_default IS NULL OR p_rent_index_rec .basis_percent_default = pn_index_rent_utils.g_pn_miss_num )
177: AND

Line 176: (p_rent_index_rec .basis_percent_default IS NULL OR p_rent_index_rec .basis_percent_default = pn_index_rent_utils.g_pn_miss_num )

172: IF ( (p_rent_index_rec .relationship_default IS NULL OR p_rent_index_rec .relationship_default = pn_index_rent_utils.g_pn_miss_char)
173: AND (p_rent_index_rec .relationship_default_meaning IS NULL OR p_rent_index_rec .relationship_default_meaning = pn_index_rent_utils.g_pn_miss_char)
174: )
175: AND
176: (p_rent_index_rec .basis_percent_default IS NULL OR p_rent_index_rec .basis_percent_default = pn_index_rent_utils.g_pn_miss_num )
177: AND
178: (p_rent_index_rec .base_year IS NULL OR p_rent_index_rec .base_year = pn_index_rent_utils.g_pn_miss_date )
179: AND
180: (p_rent_index_rec .base_index IS NULL OR p_rent_index_rec .base_index = pn_index_rent_utils.g_pn_miss_num )

Line 178: (p_rent_index_rec .base_year IS NULL OR p_rent_index_rec .base_year = pn_index_rent_utils.g_pn_miss_date )

174: )
175: AND
176: (p_rent_index_rec .basis_percent_default IS NULL OR p_rent_index_rec .basis_percent_default = pn_index_rent_utils.g_pn_miss_num )
177: AND
178: (p_rent_index_rec .base_year IS NULL OR p_rent_index_rec .base_year = pn_index_rent_utils.g_pn_miss_date )
179: AND
180: (p_rent_index_rec .base_index IS NULL OR p_rent_index_rec .base_index = pn_index_rent_utils.g_pn_miss_num )
181: THEN
182: l_null_param := 'RELATIONSHIP_DEFAULT, RELATIONSHIP_DEFAULT_MEANING, BASIS_PERCENT_DEFAULT, BASE_YEAR, BASE_INDEX';

Line 180: (p_rent_index_rec .base_index IS NULL OR p_rent_index_rec .base_index = pn_index_rent_utils.g_pn_miss_num )

176: (p_rent_index_rec .basis_percent_default IS NULL OR p_rent_index_rec .basis_percent_default = pn_index_rent_utils.g_pn_miss_num )
177: AND
178: (p_rent_index_rec .base_year IS NULL OR p_rent_index_rec .base_year = pn_index_rent_utils.g_pn_miss_date )
179: AND
180: (p_rent_index_rec .base_index IS NULL OR p_rent_index_rec .base_index = pn_index_rent_utils.g_pn_miss_num )
181: THEN
182: l_null_param := 'RELATIONSHIP_DEFAULT, RELATIONSHIP_DEFAULT_MEANING, BASIS_PERCENT_DEFAULT, BASE_YEAR, BASE_INDEX';
183: pn_index_rent_pvt.debug (l_func_name||': RELATIONSHIP_DEFAULT,RELATIONSHIP_DEFAULT_MEANING,BASIS_PERCENT_DEFAULT,BASE_YEAR,BASE_INDEX ARE NULL',3);
184: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');

Line 361: 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

357:
358: -- Initialize API return status to success
359: x_return_status := fnd_api.g_ret_sts_success;
360:
361: 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
362: THEN
363: IF p_rent_index_rec.org_id<>fnd_global.org_id
364: THEN
365: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 381: IF ( (p_rent_index_rec .index_lease_id IS NULL OR p_rent_index_rec .index_lease_id = pn_index_rent_utils.g_pn_miss_num)

377:
378: -- -------------------------------------------
379: -- Make sure the Index lease id or Index lease number is not null in index rent record
380: -- -------------------------------------------
381: IF ( (p_rent_index_rec .index_lease_id IS NULL OR p_rent_index_rec .index_lease_id = pn_index_rent_utils.g_pn_miss_num)
382: AND (p_rent_index_rec .index_lease_number IS NULL OR p_rent_index_rec .index_lease_number = pn_index_rent_utils.g_pn_miss_char)
383: )
384: THEN
385: l_null_param := 'INDEX_LEASE_NUMBER';

Line 382: AND (p_rent_index_rec .index_lease_number IS NULL OR p_rent_index_rec .index_lease_number = pn_index_rent_utils.g_pn_miss_char)

378: -- -------------------------------------------
379: -- Make sure the Index lease id or Index lease number is not null in index rent record
380: -- -------------------------------------------
381: IF ( (p_rent_index_rec .index_lease_id IS NULL OR p_rent_index_rec .index_lease_id = pn_index_rent_utils.g_pn_miss_num)
382: AND (p_rent_index_rec .index_lease_number IS NULL OR p_rent_index_rec .index_lease_number = pn_index_rent_utils.g_pn_miss_char)
383: )
384: THEN
385: l_null_param := 'INDEX_LEASE_NUMBER';
386: pn_index_rent_pvt.debug (l_func_name||': INDEX_LEASE_ID , INDEX_LEASE_NUMBER ARE NULL',3);

Line 404: p_index_constraint_tbl(i).index_constraint_id = pn_index_rent_utils.g_pn_miss_num

400: FOR i IN 1 .. p_index_constraint_tbl.COUNT
401: LOOP
402: IF ( p_index_constraint_tbl(i).index_constraint_id IS NULL
403: OR
404: p_index_constraint_tbl(i).index_constraint_id = pn_index_rent_utils.g_pn_miss_num
405: )
406: THEN
407: l_null_param := 'INDEX_CONSTRAINT_ID';
408: pn_index_rent_pvt.debug (l_func_name||': INDEX_CONSTRAINT_ID FOR RECORD ('||i||') IS NULL',3);