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_PVT

Line 12: --Called subprograms: PN_INDEX_RENT_PVT.CREATE_INDEX_RENT

8: --Name: CREATE_INDEX_RENT
9: --Type: Procedure
10: --Description: This procedure can be used to create a new index rent.
11: --
12: --Called subprograms: PN_INDEX_RENT_PVT.CREATE_INDEX_RENT
13: --
14: --
15: --
16: -- History:

Line 28: , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec

24: p_api_version IN NUMBER
25: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
27: , p_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
28: , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
29: , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
30: , x_return_status OUT NOCOPY VARCHAR2
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2

Line 29: , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl

25: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
27: , p_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE
28: , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
29: , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
30: , x_return_status OUT NOCOPY VARCHAR2
31: , x_msg_count OUT NOCOPY NUMBER
32: , x_msg_data OUT NOCOPY VARCHAR2
33: )

Line 86: pn_index_rent_pvt.DEBUG ( l_api_name_full

82: RAISE fnd_api.g_exc_error;
83: END IF;
84: ELSE
85: p_rent_index_rec.org_id:=FND_PROFILE.VALUE('ORG_ID');
86: pn_index_rent_pvt.DEBUG ( l_api_name_full
87: ||' Org Id set to:'||p_rent_index_rec.org_id
88: , 3);
89: END IF;
90:

Line 105: pn_index_rent_pvt.debug (l_func_name ||': INDEX_LEASE_NUMBER IS NULL',3);

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');
107: fnd_message.set_token ('API_NAME', l_api_name_full);
108: fnd_message.set_token ('NULL_PARAM',l_null_param );
109: fnd_msg_pub.ADD;

Line 126: pn_index_rent_pvt.debug (l_func_name||': LEASE_NUM , LEASE_ID ARE NULL',3);

122: )
123:
124: THEN
125: l_null_param := 'LEASE_NUM , LEASE_ID';
126: pn_index_rent_pvt.debug (l_func_name||': LEASE_NUM , LEASE_ID ARE NULL',3);
127: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
128: fnd_message.set_token ('API_NAME', l_api_name_full);
129: fnd_message.set_token ('NULL_PARAM', l_null_param);
130: fnd_msg_pub.ADD;

Line 143: pn_index_rent_pvt.debug (l_func_name||': INDEX_ID , INDEX_TYPE ARE NULL',3);

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);
144: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
145: fnd_message.set_token ('API_NAME', l_api_name_full);
146: fnd_message.set_token ('NULL_PARAM', l_null_param);
147: fnd_msg_pub.ADD;

Line 160: pn_index_rent_pvt.debug (l_func_name||': INCREASE_ON , INCREASE_ON_MEANING , GROSS_FLAG ARE NULL',3);

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);
161: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
162: fnd_message.set_token ('API_NAME', l_api_name_full);
163: fnd_message.set_token ('NULL_PARAM',l_null_param);
164: fnd_msg_pub.ADD;

Line 183: pn_index_rent_pvt.debug (l_func_name||': RELATIONSHIP_DEFAULT,RELATIONSHIP_DEFAULT_MEANING,BASIS_PERCENT_DEFAULT,BASE_YEAR,BASE_INDEX ARE NULL',3);

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');
185: fnd_message.set_token ('API_NAME', l_api_name_full);
186: fnd_message.set_token ('NULL_PARAM', l_null_param);
187: fnd_msg_pub.ADD;

Line 211: PN_INDEX_RENT_PVT.CREATE_INDEX_RENT

207:
208: /*********************************************
209: -- Calling private procedure create index rent
210: /********************************************/
211: PN_INDEX_RENT_PVT.CREATE_INDEX_RENT
212: ( p_api_version => p_api_version
213: , p_init_msg_list => p_init_msg_list
214: , p_commit => p_commit
215: , p_validate => p_validate

Line 243: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Exception : '

239: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
240: , p_count => x_msg_count
241: , p_data => x_msg_data
242: );
243: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Exception : '
244: || SQLERRM
245: , 3
246: );
247: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '

Line 247: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '

243: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Exception : '
244: || SQLERRM
245: , 3
246: );
247: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '
248: || x_return_status
249: , 3
250: );
251: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '

Line 251: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '

247: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '
248: || x_return_status
249: , 3
250: );
251: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '
252: || x_msg_count
253: , 3
254: );
255:

Line 263: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Unexpected Exception : '

259: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
260: , p_count => x_msg_count
261: , p_data => x_msg_data
262: );
263: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Unexpected Exception : '
264: || SQLERRM
265: , 3
266: );
267: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '

Line 267: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '

263: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Unexpected Exception : '
264: || SQLERRM
265: , 3
266: );
267: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '
268: || x_return_status
269: , 3
270: );
271: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '

Line 271: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '

267: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '
268: || x_return_status
269: , 3
270: );
271: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '
272: || x_msg_count
273: , 3
274: );
275:

Line 283: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Others Exception : '

279: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
280: , p_count => x_msg_count
281: , p_data => x_msg_data
282: );
283: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Others Exception : '
284: || SQLERRM
285: , 3
286: );
287:

Line 288: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '

284: || SQLERRM
285: , 3
286: );
287:
288: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '
289: || x_return_status
290: , 3
291: );
292: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '

Line 292: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '

288: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent Return Status : '
289: || x_return_status
290: , 3
291: );
292: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Create_Index_Rent No of Error Messages : '
293: || x_msg_count
294: , 3
295: );
296:

Line 306: --Called subprograms: PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT

302: --Name: UPDATE_INDEX_RENT
303: --Type: Procedure
304: --Description: This procedure can be used to update a index rent.
305: --
306: --Called subprograms: PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT
307: --
308: --
309: --
310: -- History:

Line 321: , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec

317: p_api_version IN NUMBER
318: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
319: , p_commit IN VARCHAR2 := fnd_api.g_false
320: , p_validate IN VARCHAR2 := fnd_api.g_false
321: , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
322: , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
323: , x_return_status OUT NOCOPY VARCHAR2
324: , x_msg_count OUT NOCOPY NUMBER
325: , x_msg_data OUT NOCOPY VARCHAR2

Line 322: , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl

318: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
319: , p_commit IN VARCHAR2 := fnd_api.g_false
320: , p_validate IN VARCHAR2 := fnd_api.g_false
321: , p_rent_index_rec IN OUT NOCOPY PN_INDEX_RENT_PVT.rent_index_rec
322: , p_index_constraint_tbl IN OUT NOCOPY PN_INDEX_RENT_PVT.index_constraint_tbl
323: , x_return_status OUT NOCOPY VARCHAR2
324: , x_msg_count OUT NOCOPY NUMBER
325: , x_msg_data OUT NOCOPY VARCHAR2
326: )

Line 334: l_func_name CONSTANT VARCHAR2 (100) := 'PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT';

330: l_api_name_full CONSTANT VARCHAR2 (61)
331: := g_pkg_name
332: || '.'
333: || l_api_name;
334: l_func_name CONSTANT VARCHAR2 (100) := 'PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT';
335:
336: BEGIN
337: -- Standard start of API savepoint
338: SAVEPOINT UPDATE_INDEX_RENT;

Line 372: pn_index_rent_pvt.DEBUG ( l_api_name_full

368: RAISE fnd_api.g_exc_error;
369: END IF;
370: ELSE
371: p_rent_index_rec.org_id:=FND_PROFILE.VALUE('ORG_ID');
372: pn_index_rent_pvt.DEBUG ( l_api_name_full
373: ||' Org Id set to:'||p_rent_index_rec.org_id
374: , 3);
375: END IF;
376:

Line 386: pn_index_rent_pvt.debug (l_func_name||': INDEX_LEASE_ID , INDEX_LEASE_NUMBER ARE NULL',3);

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);
387: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
388: fnd_message.set_token ('API_NAME', l_api_name_full);
389: fnd_message.set_token ('NULL_PARAM', l_null_param);
390: fnd_msg_pub.ADD;

Line 408: pn_index_rent_pvt.debug (l_func_name||': INDEX_CONSTRAINT_ID FOR RECORD ('||i||') IS NULL',3);

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);
409: fnd_message.set_name ('PN', 'PN_API_ALL_NULL_PARAMETER');
410: fnd_message.set_token ('API_NAME', l_api_name_full);
411: fnd_message.set_token ('NULL_PARAM', l_null_param);
412: fnd_msg_pub.ADD;

Line 434: PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT

430: fnd_msg_pub.ADD;
431: RAISE fnd_api.g_exc_error;
432: END IF;
433:
434: PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT
435: (p_api_version => p_api_version
436: , p_init_msg_list => p_init_msg_list
437: , p_commit => p_commit
438: , p_validate => p_validate

Line 465: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Exception : '

461: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
462: , p_count => x_msg_count
463: , p_data => x_msg_data
464: );
465: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Exception : '
466: || SQLERRM
467: , 3
468: );
469: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '

Line 469: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '

465: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Exception : '
466: || SQLERRM
467: , 3
468: );
469: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
470: || x_return_status
471: , 3
472: );
473: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '

Line 473: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '

469: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
470: || x_return_status
471: , 3
472: );
473: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '
474: || x_msg_count
475: , 3
476: );
477:

Line 485: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Unexpected Exception : '

481: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
482: , p_count => x_msg_count
483: , p_data => x_msg_data
484: );
485: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Unexpected Exception : '
486: || SQLERRM
487: , 3
488: );
489: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '

Line 489: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '

485: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Unexpected Exception : '
486: || SQLERRM
487: , 3
488: );
489: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
490: || x_return_status
491: , 3
492: );
493: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '

Line 493: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '

489: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
490: || x_return_status
491: , 3
492: );
493: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '
494: || x_msg_count
495: , 3
496: );
497: WHEN OTHERS

Line 504: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Others Exception : '

500: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
501: , p_count => x_msg_count
502: , p_data => x_msg_data
503: );
504: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Others Exception : '
505: || SQLERRM
506: , 3
507: );
508: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '

Line 508: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '

504: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Others Exception : '
505: || SQLERRM
506: , 3
507: );
508: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
509: || x_return_status
510: , 3
511: );
512: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '

Line 512: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '

508: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent Return Status : '
509: || x_return_status
510: , 3
511: );
512: pn_index_rent_pvt.debug ( 'PN_INDEX_RENT_PUB: Update_Index_Rent No of Error Messages : '
513: || x_msg_count
514: , 3
515: );
516: