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_LEASE_PUB dependencies on PN_LEASE_UTILS

Line 93: OR p_lease_rec.lease_num = pn_lease_utils.g_pn_miss_char

89: IF (NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_LEASE_NUMBER', p_lease_rec.org_id), 'N')) <> 'Y'
90: THEN
91:
92: IF ( p_lease_rec.lease_num IS NULL
93: OR p_lease_rec.lease_num = pn_lease_utils.g_pn_miss_char
94: )
95: THEN
96: ------dbms_output.put_line('Public:1'); --Rupak
97: pn_lease_utils.add_null_parameter_msg

Line 97: pn_lease_utils.add_null_parameter_msg

93: OR p_lease_rec.lease_num = pn_lease_utils.g_pn_miss_char
94: )
95: THEN
96: ------dbms_output.put_line('Public:1'); --Rupak
97: pn_lease_utils.add_null_parameter_msg
98: (p_token_apiname => l_api_name_full
99: , p_token_nullparam => 'lease_num');
100: RAISE fnd_api.g_exc_error;
101: END IF;

Line 107: OR p_lease_rec.lease_name = pn_lease_utils.g_pn_miss_char

103: ------dbms_output.put_line('Public:12'); --Rupak
104: -- Make sure the Lease Name is not null
105: -- -------------------------------------------
106: IF ( p_lease_rec.lease_name IS NULL
107: OR p_lease_rec.lease_name = pn_lease_utils.g_pn_miss_char
108: )
109: THEN
110: pn_lease_utils.add_null_parameter_msg
111: (p_token_apiname => l_api_name_full

Line 110: pn_lease_utils.add_null_parameter_msg

106: IF ( p_lease_rec.lease_name IS NULL
107: OR p_lease_rec.lease_name = pn_lease_utils.g_pn_miss_char
108: )
109: THEN
110: pn_lease_utils.add_null_parameter_msg
111: (p_token_apiname => l_api_name_full
112: , p_token_nullparam => 'lease_name');
113: RAISE fnd_api.g_exc_error;
114: END IF;

Line 122: OR ( p_lease_rec.lease_type = pn_lease_utils.g_pn_miss_char

118: -- -------------------------------------------
119: IF ( p_lease_rec.lease_type IS NULL
120: AND p_lease_rec.lease_type_code IS NULL
121: )
122: OR ( p_lease_rec.lease_type = pn_lease_utils.g_pn_miss_char
123: AND p_lease_rec.lease_type_code = pn_lease_utils.g_pn_miss_char
124: )
125: THEN
126: pn_lease_utils.add_null_parameter_msg

Line 123: AND p_lease_rec.lease_type_code = pn_lease_utils.g_pn_miss_char

119: IF ( p_lease_rec.lease_type IS NULL
120: AND p_lease_rec.lease_type_code IS NULL
121: )
122: OR ( p_lease_rec.lease_type = pn_lease_utils.g_pn_miss_char
123: AND p_lease_rec.lease_type_code = pn_lease_utils.g_pn_miss_char
124: )
125: THEN
126: pn_lease_utils.add_null_parameter_msg
127: (p_token_apiname => l_api_name_full

Line 126: pn_lease_utils.add_null_parameter_msg

122: OR ( p_lease_rec.lease_type = pn_lease_utils.g_pn_miss_char
123: AND p_lease_rec.lease_type_code = pn_lease_utils.g_pn_miss_char
124: )
125: THEN
126: pn_lease_utils.add_null_parameter_msg
127: (p_token_apiname => l_api_name_full
128: , p_token_nullparam => 'lease_type');
129: RAISE fnd_api.g_exc_error;
130: END IF;

Line 138: OR ( p_lease_rec.lease_class = pn_lease_utils.g_pn_miss_char

134: ---------------------------------------------
135: IF ( p_lease_rec.lease_class IS NULL
136: AND p_lease_rec.lease_class_code IS NULL
137: )
138: OR ( p_lease_rec.lease_class = pn_lease_utils.g_pn_miss_char
139: AND p_lease_rec.lease_class_code = pn_lease_utils.g_pn_miss_char
140: )
141: THEN
142: pn_lease_utils.add_null_parameter_msg

Line 139: AND p_lease_rec.lease_class_code = pn_lease_utils.g_pn_miss_char

135: IF ( p_lease_rec.lease_class IS NULL
136: AND p_lease_rec.lease_class_code IS NULL
137: )
138: OR ( p_lease_rec.lease_class = pn_lease_utils.g_pn_miss_char
139: AND p_lease_rec.lease_class_code = pn_lease_utils.g_pn_miss_char
140: )
141: THEN
142: pn_lease_utils.add_null_parameter_msg
143: (p_token_apiname => l_api_name_full

Line 142: pn_lease_utils.add_null_parameter_msg

138: OR ( p_lease_rec.lease_class = pn_lease_utils.g_pn_miss_char
139: AND p_lease_rec.lease_class_code = pn_lease_utils.g_pn_miss_char
140: )
141: THEN
142: pn_lease_utils.add_null_parameter_msg
143: (p_token_apiname => l_api_name_full
144: , p_token_nullparam => 'lease_class');
145: RAISE fnd_api.g_exc_error;
146: END IF;

Line 159: pn_lease_utils.g_pn_miss_char

155: IF ( p_lease_rec.parent_lease_id IS NULL
156: AND p_lease_rec.parent_lease_name IS NULL
157: )
158: OR ( p_lease_rec.parent_lease_name =
159: pn_lease_utils.g_pn_miss_char
160: AND p_lease_rec.parent_lease_id =
161: pn_lease_utils.g_pn_miss_num
162: )
163: THEN

Line 161: pn_lease_utils.g_pn_miss_num

157: )
158: OR ( p_lease_rec.parent_lease_name =
159: pn_lease_utils.g_pn_miss_char
160: AND p_lease_rec.parent_lease_id =
161: pn_lease_utils.g_pn_miss_num
162: )
163: THEN
164: pn_lease_utils.add_null_parameter_msg
165: (p_token_apiname => l_api_name_full

Line 164: pn_lease_utils.add_null_parameter_msg

160: AND p_lease_rec.parent_lease_id =
161: pn_lease_utils.g_pn_miss_num
162: )
163: THEN
164: pn_lease_utils.add_null_parameter_msg
165: (p_token_apiname => l_api_name_full
166: , p_token_nullparam => 'Parent_Lease');
167: RAISE fnd_api.g_exc_error;
168: END IF;

Line 177: OR ( p_lease_rec.abstracted_by_user = pn_lease_utils.g_pn_miss_char

173: -- -------------------------------------------
174: IF ( p_lease_rec.abstracted_by_user IS NULL
175: AND p_lease_rec.abstracted_by_user_id IS NULL
176: )
177: OR ( p_lease_rec.abstracted_by_user = pn_lease_utils.g_pn_miss_char
178: AND p_lease_rec.abstracted_by_user_id = pn_lease_utils.g_pn_miss_num
179: )
180: THEN
181: pn_lease_utils.add_null_parameter_msg

Line 178: AND p_lease_rec.abstracted_by_user_id = pn_lease_utils.g_pn_miss_num

174: IF ( p_lease_rec.abstracted_by_user IS NULL
175: AND p_lease_rec.abstracted_by_user_id IS NULL
176: )
177: OR ( p_lease_rec.abstracted_by_user = pn_lease_utils.g_pn_miss_char
178: AND p_lease_rec.abstracted_by_user_id = pn_lease_utils.g_pn_miss_num
179: )
180: THEN
181: pn_lease_utils.add_null_parameter_msg
182: (p_token_apiname => l_api_name_full

Line 181: pn_lease_utils.add_null_parameter_msg

177: OR ( p_lease_rec.abstracted_by_user = pn_lease_utils.g_pn_miss_char
178: AND p_lease_rec.abstracted_by_user_id = pn_lease_utils.g_pn_miss_num
179: )
180: THEN
181: pn_lease_utils.add_null_parameter_msg
182: (p_token_apiname => l_api_name_full
183: , p_token_nullparam => 'abstracted_by_user');
184: RAISE fnd_api.g_exc_error;
185: END IF;

Line 192: OR ( p_lease_rec.status = pn_lease_utils.g_pn_miss_char

188: -- Make sure the Approval_status is not null
189: -- -------------------------------------------
190: IF ( p_lease_rec.status IS NULL
191: AND p_lease_rec.status_code IS NULL)
192: OR ( p_lease_rec.status = pn_lease_utils.g_pn_miss_char
193: AND p_lease_rec.status_code = pn_lease_utils.g_pn_miss_char
194: )
195: THEN
196: pn_lease_utils.add_null_parameter_msg

Line 193: AND p_lease_rec.status_code = pn_lease_utils.g_pn_miss_char

189: -- -------------------------------------------
190: IF ( p_lease_rec.status IS NULL
191: AND p_lease_rec.status_code IS NULL)
192: OR ( p_lease_rec.status = pn_lease_utils.g_pn_miss_char
193: AND p_lease_rec.status_code = pn_lease_utils.g_pn_miss_char
194: )
195: THEN
196: pn_lease_utils.add_null_parameter_msg
197: (p_token_apiname => l_api_name_full

Line 196: pn_lease_utils.add_null_parameter_msg

192: OR ( p_lease_rec.status = pn_lease_utils.g_pn_miss_char
193: AND p_lease_rec.status_code = pn_lease_utils.g_pn_miss_char
194: )
195: THEN
196: pn_lease_utils.add_null_parameter_msg
197: (p_token_apiname => l_api_name_full
198: , p_token_nullparam => 'Approval_status');
199: RAISE fnd_api.g_exc_error;
200: END IF;

Line 208: OR ( p_lease_rec.lease_status_code = pn_lease_utils.g_pn_miss_char

204: -- -------------------------------------------
205: IF ( p_lease_rec.lease_status_code IS NULL
206: AND p_lease_rec.lease_status IS NULL
207: )
208: OR ( p_lease_rec.lease_status_code = pn_lease_utils.g_pn_miss_char
209: AND p_lease_rec.lease_status = pn_lease_utils.g_pn_miss_char
210: )
211: THEN
212: pn_lease_utils.add_null_parameter_msg

Line 209: AND p_lease_rec.lease_status = pn_lease_utils.g_pn_miss_char

205: IF ( p_lease_rec.lease_status_code IS NULL
206: AND p_lease_rec.lease_status IS NULL
207: )
208: OR ( p_lease_rec.lease_status_code = pn_lease_utils.g_pn_miss_char
209: AND p_lease_rec.lease_status = pn_lease_utils.g_pn_miss_char
210: )
211: THEN
212: pn_lease_utils.add_null_parameter_msg
213: (p_token_apiname => l_api_name_full

Line 212: pn_lease_utils.add_null_parameter_msg

208: OR ( p_lease_rec.lease_status_code = pn_lease_utils.g_pn_miss_char
209: AND p_lease_rec.lease_status = pn_lease_utils.g_pn_miss_char
210: )
211: THEN
212: pn_lease_utils.add_null_parameter_msg
213: (p_token_apiname => l_api_name_full
214: , p_token_nullparam => 'lease_status');
215: RAISE fnd_api.g_exc_error;
216: END IF;

Line 225: pn_lease_utils.add_null_parameter_msg

221: IF ( p_lease_rec.lease_termination_date IS NULL
222: OR p_lease_rec.lease_termination_date = fnd_api.g_miss_date
223: )
224: THEN
225: pn_lease_utils.add_null_parameter_msg
226: (p_token_apiname => l_api_name_full
227: , p_token_nullparam => 'lease_termination_date');
228: RAISE fnd_api.g_exc_error;
229: END IF;

Line 238: pn_lease_utils.add_null_parameter_msg

234: IF ( p_lease_rec.lease_execution_date IS NULL
235: OR p_lease_rec.lease_execution_date = fnd_api.g_miss_date
236: )
237: THEN
238: pn_lease_utils.add_null_parameter_msg
239: (p_token_apiname => l_api_name_full
240: , p_token_nullparam => 'lease_execution_date');
241: RAISE fnd_api.g_exc_error;
242: END IF;

Line 251: pn_lease_utils.add_null_parameter_msg

247: IF ( p_lease_rec.lease_commencement_date IS NULL
248: OR p_lease_rec.lease_commencement_date = fnd_api.g_miss_date
249: )
250: THEN
251: pn_lease_utils.add_null_parameter_msg
252: (p_token_apiname => l_api_name_full
253: , p_token_nullparam => 'lease_commencement_date');
254: RAISE fnd_api.g_exc_error;
255: END IF;

Line 264: AND p_lease_rec.pymt_term_pro_rule_id = pn_lease_utils.g_pn_miss_char

260: IF ( p_lease_rec.pymt_term_pro_rule IS NULL
261: AND p_lease_rec.pymt_term_pro_rule_id IS NULL
262: )
263: OR ( p_lease_rec.pymt_term_pro_rule = fnd_api.g_null_char
264: AND p_lease_rec.pymt_term_pro_rule_id = pn_lease_utils.g_pn_miss_char
265: )
266: THEN
267: pn_lease_utils.add_null_parameter_msg
268: (p_token_apiname => l_api_name_full

Line 267: pn_lease_utils.add_null_parameter_msg

263: OR ( p_lease_rec.pymt_term_pro_rule = fnd_api.g_null_char
264: AND p_lease_rec.pymt_term_pro_rule_id = pn_lease_utils.g_pn_miss_char
265: )
266: THEN
267: pn_lease_utils.add_null_parameter_msg
268: (p_token_apiname => l_api_name_full
269: , p_token_nullparam => 'pymt_term_pro_rule');
270: RAISE fnd_api.g_exc_error;
271: END IF;

Line 279: OR ( p_lease_rec.responsible_user = pn_lease_utils.g_pn_miss_char

275: -- -------------------------------------------
276: IF ( p_lease_rec.responsible_user IS NULL
277: AND p_lease_rec.responsible_user_id IS NULL
278: )
279: OR ( p_lease_rec.responsible_user = pn_lease_utils.g_pn_miss_char
280: AND p_lease_rec.responsible_user_id = pn_lease_utils.g_pn_miss_num
281: )
282: THEN
283: pn_lease_utils.add_null_parameter_msg

Line 280: AND p_lease_rec.responsible_user_id = pn_lease_utils.g_pn_miss_num

276: IF ( p_lease_rec.responsible_user IS NULL
277: AND p_lease_rec.responsible_user_id IS NULL
278: )
279: OR ( p_lease_rec.responsible_user = pn_lease_utils.g_pn_miss_char
280: AND p_lease_rec.responsible_user_id = pn_lease_utils.g_pn_miss_num
281: )
282: THEN
283: pn_lease_utils.add_null_parameter_msg
284: (p_token_apiname => l_api_name_full

Line 283: pn_lease_utils.add_null_parameter_msg

279: OR ( p_lease_rec.responsible_user = pn_lease_utils.g_pn_miss_char
280: AND p_lease_rec.responsible_user_id = pn_lease_utils.g_pn_miss_num
281: )
282: THEN
283: pn_lease_utils.add_null_parameter_msg
284: (p_token_apiname => l_api_name_full
285: , p_token_nullparam => 'responsible_user');
286: RAISE fnd_api.g_exc_error;
287: END IF;

Line 443: IF ( p_lease_rec.lease_id IS NULL OR p_lease_rec.lease_id = pn_lease_utils.g_pn_miss_num) THEN

439:
440: x_return_status := fnd_api.g_ret_sts_success;
441:
442:
443: IF ( p_lease_rec.lease_id IS NULL OR p_lease_rec.lease_id = pn_lease_utils.g_pn_miss_num) THEN
444: IF ( p_lease_rec.lease_name IS NOT NULL AND p_lease_rec.lease_name <> pn_lease_utils.g_pn_miss_char) THEN
445: BEGIN
446:
447: SELECT lease_id

Line 444: IF ( p_lease_rec.lease_name IS NOT NULL AND p_lease_rec.lease_name <> pn_lease_utils.g_pn_miss_char) THEN

440: x_return_status := fnd_api.g_ret_sts_success;
441:
442:
443: IF ( p_lease_rec.lease_id IS NULL OR p_lease_rec.lease_id = pn_lease_utils.g_pn_miss_num) THEN
444: IF ( p_lease_rec.lease_name IS NOT NULL AND p_lease_rec.lease_name <> pn_lease_utils.g_pn_miss_char) THEN
445: BEGIN
446:
447: SELECT lease_id
448: INTO p_lease_rec.lease_id

Line 468: ELSIF(p_lease_rec.lease_num IS NOT NULL AND p_lease_rec.lease_num <> pn_lease_utils.g_pn_miss_char) THEN

464: fnd_message.set_token ('NULL_PARAM', 'LEASE NAME:NOT UNIQUE');
465: fnd_msg_pub.ADD;
466: RAISE fnd_api.g_exc_error;
467: END;
468: ELSIF(p_lease_rec.lease_num IS NOT NULL AND p_lease_rec.lease_num <> pn_lease_utils.g_pn_miss_char) THEN
469: BEGIN
470: SELECT lease_id
471: INTO p_lease_rec.lease_id
472: FROM pn_leases_all

Line 844: IF ( p_lease_id IS NULL OR p_lease_id = pn_lease_utils.g_pn_miss_num

840: -- -------------------------------------------
841: -- Make sure the Lease Type is not null
842: -- -------------------------------------------
843:
844: IF ( p_lease_id IS NULL OR p_lease_id = pn_lease_utils.g_pn_miss_num
845: )
846: THEN
847: pn_lease_utils.add_null_parameter_msg
848: (p_token_apiname => l_api_name_full

Line 847: pn_lease_utils.add_null_parameter_msg

843:
844: IF ( p_lease_id IS NULL OR p_lease_id = pn_lease_utils.g_pn_miss_num
845: )
846: THEN
847: pn_lease_utils.add_null_parameter_msg
848: (p_token_apiname => l_api_name_full
849: , p_token_nullparam => 'p_lease_id');
850: RAISE fnd_api.g_exc_error;
851: END IF;

Line 857: IF p_new_approval_status_code IS NULL OR p_new_approval_status_code = pn_lease_utils.g_pn_miss_char

853: -- -------------------------------------------
854: -- Make sure the new approval status_code is not null
855: -- -------------------------------------------
856:
857: IF p_new_approval_status_code IS NULL OR p_new_approval_status_code = pn_lease_utils.g_pn_miss_char
858: THEN
859: pn_lease_utils.add_null_parameter_msg
860: (p_token_apiname => l_api_name_full
861: , p_token_nullparam => 'p_new_approval_status_code');

Line 859: pn_lease_utils.add_null_parameter_msg

855: -- -------------------------------------------
856:
857: IF p_new_approval_status_code IS NULL OR p_new_approval_status_code = pn_lease_utils.g_pn_miss_char
858: THEN
859: pn_lease_utils.add_null_parameter_msg
860: (p_token_apiname => l_api_name_full
861: , p_token_nullparam => 'p_new_approval_status_code');
862: RAISE fnd_api.g_exc_error;
863: END IF;

Line 868: IF p_new_lease_status IS NULL OR p_new_lease_status= pn_lease_utils.g_pn_miss_char

864:
865: -- -------------------------------------------
866: -- Make sure the new lease status is not null
867: -- -------------------------------------------
868: IF p_new_lease_status IS NULL OR p_new_lease_status= pn_lease_utils.g_pn_miss_char
869: THEN
870: pn_lease_utils.add_null_parameter_msg
871: (p_token_apiname => l_api_name_full
872: , p_token_nullparam => 'p_new_lease_status');

Line 870: pn_lease_utils.add_null_parameter_msg

866: -- Make sure the new lease status is not null
867: -- -------------------------------------------
868: IF p_new_lease_status IS NULL OR p_new_lease_status= pn_lease_utils.g_pn_miss_char
869: THEN
870: pn_lease_utils.add_null_parameter_msg
871: (p_token_apiname => l_api_name_full
872: , p_token_nullparam => 'p_new_lease_status');
873: RAISE fnd_api.g_exc_error;
874: END IF;