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 FND_API

Line 25: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

21: -- Procedure to create a new index rent
22: PROCEDURE CREATE_INDEX_RENT
23: (
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

Line 26: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

22: PROCEDURE CREATE_INDEX_RENT
23: (
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

Line 27: , p_validate IN VARCHAR2 DEFAULT FND_API.G_FALSE

23: (
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

Line 52: x_return_status := fnd_api.g_ret_sts_success;

48:
49: SAVEPOINT CREATE_INDEX_RENT;
50: -- Initialize API return status to success
51:
52: x_return_status := fnd_api.g_ret_sts_success;
53:
54: --Added to clear message cache in case of API called with wrong version.
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE

Line 57: IF fnd_api.to_boolean (p_init_msg_list)

53:
54: --Added to clear message cache in case of API called with wrong version.
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE
57: IF fnd_api.to_boolean (p_init_msg_list)
58: THEN
59: fnd_msg_pub.initialize;
60: END IF;
61:

Line 63: IF NOT fnd_api.compatible_api_call (l_api_version

59: fnd_msg_pub.initialize;
60: END IF;
61:
62: -- Standard call to check for call compatibility
63: IF NOT fnd_api.compatible_api_call (l_api_version
64: , p_api_version
65: , l_api_name
66: , g_pkg_name
67: )

Line 70: RAISE fnd_api.g_exc_error;

66: , g_pkg_name
67: )
68: THEN
69:
70: RAISE fnd_api.g_exc_error;
71: END IF;
72:
73:
74:

Line 82: RAISE fnd_api.g_exc_error;

78: THEN
79: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
80: fnd_message.set_token('ERR_MSG', 'Operating unit provided do not exists in the list of Operating Units that are allowed access to, for a responsibility');
81: fnd_msg_pub.ADD;
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

Line 110: RAISE fnd_api.g_exc_error;

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;
110: RAISE fnd_api.g_exc_error;
111: END IF;
112: END IF;
113:
114: ---------------------------------------------------------------

Line 131: RAISE fnd_api.g_exc_error;

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;
131: RAISE fnd_api.g_exc_error;
132: END IF;
133:
134:
135: ---------------------------------------------------

Line 148: RAISE fnd_api.g_exc_error;

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;
148: RAISE fnd_api.g_exc_error;
149: END IF;
150:
151: -----------------------------------------------------------------------------
152: -- Make sure the Increase on or Increase on meaning or Gross flag is not null

Line 165: RAISE fnd_api.g_exc_error;

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;
165: RAISE fnd_api.g_exc_error;
166: END IF;
167:
168:
169: -------------------------------------------------------------------------------------------------

Line 188: RAISE fnd_api.g_exc_error;

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;
188: RAISE fnd_api.g_exc_error;
189: END IF;
190: /*********************************************/
191: -- Required Parameters Validation Ends
192: /*********************************************/

Line 205: RAISE fnd_api.g_exc_error;

201: fnd_message.set_name ('PN'
202: , 'PN_FUNCTION_SECURITY'
203: );
204: fnd_msg_pub.ADD;
205: RAISE fnd_api.g_exc_error;
206: END IF;
207:
208: /*********************************************
209: -- Calling private procedure create index rent

Line 223: IF fnd_api.to_boolean (p_commit)

219: , x_msg_count => x_msg_count
220: , x_msg_data => x_msg_data
221: );
222: -- Standard check of p_commit
223: IF fnd_api.to_boolean (p_commit)
224: THEN
225: COMMIT WORK;
226: END IF;
227:

Line 229: ( p_encoded => fnd_api.g_false

225: COMMIT WORK;
226: END IF;
227:
228: fnd_msg_pub.Count_And_Get
229: ( p_encoded => fnd_api.g_false
230: ,p_count => x_msg_count
231: ,p_data => x_msg_data
232: );
233:

Line 235: WHEN fnd_api.g_exc_error

231: ,p_data => x_msg_data
232: );
233:
234: EXCEPTION
235: WHEN fnd_api.g_exc_error
236: THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238:
239: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

Line 237: x_return_status := fnd_api.g_ret_sts_error;

233:
234: EXCEPTION
235: WHEN fnd_api.g_exc_error
236: THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238:
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

Line 239: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

235: WHEN fnd_api.g_exc_error
236: THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238:
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 : '

Line 256: WHEN fnd_api.g_exc_unexpected_error

252: || x_msg_count
253: , 3
254: );
255:
256: WHEN fnd_api.g_exc_unexpected_error
257: THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
260: , p_count => x_msg_count

Line 258: x_return_status := fnd_api.g_ret_sts_unexp_error;

254: );
255:
256: WHEN fnd_api.g_exc_unexpected_error
257: THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
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: );

Line 259: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

255:
256: WHEN fnd_api.g_exc_unexpected_error
257: THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
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 : '

Line 278: x_return_status := fnd_api.g_ret_sts_unexp_error;

274: );
275:
276: WHEN OTHERS
277: THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
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: );

Line 279: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

275:
276: WHEN OTHERS
277: THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
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 : '

Line 318: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

314:
315: -- Procedure to update a index rent
316: PROCEDURE UPDATE_INDEX_RENT(
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

Line 319: , p_commit IN VARCHAR2 := fnd_api.g_false

315: -- Procedure to update a index rent
316: PROCEDURE UPDATE_INDEX_RENT(
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

Line 320: , p_validate IN VARCHAR2 := fnd_api.g_false

316: PROCEDURE UPDATE_INDEX_RENT(
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

Line 343: IF fnd_api.to_boolean (p_init_msg_list)

339:
340: --Added to clear message cache in case of API call wrong version.
341:
342: -- Initialize message list if p_init_msg_list is set to TRUE
343: IF fnd_api.to_boolean (p_init_msg_list)
344: THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:

Line 349: IF NOT fnd_api.compatible_api_call (l_api_version

345: fnd_msg_pub.initialize;
346: END IF;
347:
348: -- Standard call to check for call compatibility
349: IF NOT fnd_api.compatible_api_call (l_api_version
350: , p_api_version
351: , l_api_name
352: , g_pkg_name
353: )

Line 355: RAISE fnd_api.g_exc_error;

351: , l_api_name
352: , g_pkg_name
353: )
354: THEN
355: RAISE fnd_api.g_exc_error;
356: END IF;
357:
358: -- Initialize API return status to success
359: x_return_status := fnd_api.g_ret_sts_success;

Line 359: x_return_status := fnd_api.g_ret_sts_success;

355: RAISE fnd_api.g_exc_error;
356: END IF;
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

Line 368: RAISE fnd_api.g_exc_error;

364: THEN
365: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
366: fnd_message.set_token('ERR_MSG', 'Operating unit provided do not exists in the list of Operating Units that are allowed access to, for a responsibility');
367: fnd_msg_pub.ADD;
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

Line 391: RAISE fnd_api.g_exc_error;

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;
391: RAISE fnd_api.g_exc_error;
392: END IF;
393:
394: /*
395: --------------------------------------------------------------------------------

Line 413: RAISE fnd_api.g_exc_error;

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;
413: RAISE fnd_api.g_exc_error;
414: END IF;
415: END LOOP;
416: END IF;*/
417: /***********************************************************

Line 431: RAISE fnd_api.g_exc_error;

427: fnd_message.set_name ('PN'
428: , 'PN_FUNCTION_SECURITY'
429: );
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

Line 447: IF fnd_api.to_boolean (p_commit)

443: , x_msg_data => x_msg_data
444: );
445:
446: -- Standard check of p_commit
447: IF fnd_api.to_boolean (p_commit)
448: THEN
449: COMMIT WORK;
450: END IF;
451:

Line 452: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

448: THEN
449: COMMIT WORK;
450: END IF;
451:
452: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );
456:

Line 458: WHEN fnd_api.g_exc_error

454: , p_data => x_msg_data
455: );
456:
457: EXCEPTION
458: WHEN fnd_api.g_exc_error
459: THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
462: , p_count => x_msg_count

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456:
457: EXCEPTION
458: WHEN fnd_api.g_exc_error
459: THEN
460: x_return_status := fnd_api.g_ret_sts_error;
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: );

Line 461: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

457: EXCEPTION
458: WHEN fnd_api.g_exc_error
459: THEN
460: x_return_status := fnd_api.g_ret_sts_error;
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 : '

Line 478: WHEN fnd_api.g_exc_unexpected_error

474: || x_msg_count
475: , 3
476: );
477:
478: WHEN fnd_api.g_exc_unexpected_error
479: THEN
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
482: , p_count => x_msg_count

Line 480: x_return_status := fnd_api.g_ret_sts_unexp_error;

476: );
477:
478: WHEN fnd_api.g_exc_unexpected_error
479: THEN
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
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: );

Line 481: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

477:
478: WHEN fnd_api.g_exc_unexpected_error
479: THEN
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
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 : '

Line 499: x_return_status := fnd_api.g_ret_sts_unexp_error;

495: , 3
496: );
497: WHEN OTHERS
498: THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
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: );

Line 500: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false

496: );
497: WHEN OTHERS
498: THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
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 : '