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_VAR_RENT_PUB dependencies on FND_API

Line 44: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

40:
41:
42: PROCEDURE create_var_rent (
43: p_api_version IN NUMBER
44: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
45: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
46: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type

Line 45: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

41:
42: PROCEDURE create_var_rent (
43: p_api_version IN NUMBER
44: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
45: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
46: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
47: , p_var_rent_rec IN OUT NOCOPY pn_varen_pvt.var_rent_rec_type
48: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
49: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type

Line 73: x_return_status := fnd_api.g_ret_sts_success;

69: l_org_id NUMBER;
70: l_var_rent_rec pn_varen_pvt.var_rent_rec_type := p_var_rent_rec;
71: BEGIN
72: -- NUll;
73: x_return_status := fnd_api.g_ret_sts_success;
74: -- Standard Start of API savepoint
75: pn_varen_util.pvt_debug ( l_api_name_full
76: || ' - Starting API'
77: , 3

Line 82: IF fnd_api.to_boolean (p_init_msg_list)

78: );
79: SAVEPOINT create_var_rent;
80:
81: -- Initialize message list if p_init_msg_list is set to TRUE
82: IF fnd_api.to_boolean (p_init_msg_list)
83: THEN
84: fnd_msg_pub.initialize;
85: END IF;
86:

Line 88: IF NOT fnd_api.compatible_api_call (l_api_version

84: fnd_msg_pub.initialize;
85: END IF;
86:
87: -- Standard call to check for call compatibility.
88: IF NOT fnd_api.compatible_api_call (l_api_version
89: , p_api_version
90: , l_api_name
91: , g_pkg_name
92: )

Line 94: RAISE fnd_api.g_exc_error;

90: , l_api_name
91: , g_pkg_name
92: )
93: THEN
94: RAISE fnd_api.g_exc_error;
95: END IF;
96:
97: -- Actions performed using the APIs would be subject to
98: -- function security. If the responsibility does not allow

Line 110: RAISE fnd_api.g_exc_error;

106: fnd_message.set_name ('MO'
107: , 'MO_ORG_INVALID'
108: );
109: fnd_msg_pub.ADD;
110: RAISE fnd_api.g_exc_error;
111: END IF;
112:
113: --- Verifying whether the VRA from exists or not.
114: IF fnd_function.TEST (function_name => g_fun_name)

Line 125: RAISE fnd_api.g_exc_error;

121: fnd_message.set_name ('PN'
122: , 'PN_FUNCTION_SECURITY'
123: );
124: fnd_msg_pub.ADD;
125: RAISE fnd_api.g_exc_error;
126: END IF;
127:
128: -- Initialize API return status to success
129: -- x_return_status := fnd_api.g_ret_sts_success;

Line 129: -- x_return_status := fnd_api.g_ret_sts_success;

125: RAISE fnd_api.g_exc_error;
126: END IF;
127:
128: -- Initialize API return status to success
129: -- x_return_status := fnd_api.g_ret_sts_success;
130: l_org_return_status := fnd_api.g_ret_sts_success;
131: pn_varen_util.pvt_debug ( l_api_name_full
132: || ' : '
133: || 'l_org_return_status '

Line 130: l_org_return_status := fnd_api.g_ret_sts_success;

126: END IF;
127:
128: -- Initialize API return status to success
129: -- x_return_status := fnd_api.g_ret_sts_success;
130: l_org_return_status := fnd_api.g_ret_sts_success;
131: pn_varen_util.pvt_debug ( l_api_name_full
132: || ' : '
133: || 'l_org_return_status '
134: || l_org_return_status

Line 138: IF ( l_org_return_status <> fnd_api.g_ret_sts_success

134: || l_org_return_status
135: , 3
136: );
137:
138: IF ( l_org_return_status <> fnd_api.g_ret_sts_success
139: AND g_func_exists = 'Y')
140: THEN
141: x_return_status := fnd_api.g_ret_sts_error;
142: ELSE

Line 141: x_return_status := fnd_api.g_ret_sts_error;

137:
138: IF ( l_org_return_status <> fnd_api.g_ret_sts_success
139: AND g_func_exists = 'Y')
140: THEN
141: x_return_status := fnd_api.g_ret_sts_error;
142: ELSE
143: pn_varen_util.pvt_debug ( l_api_name_full
144: || ' : '
145: || 'Before calling pn_varen_pvt.create_var_rent package - l_org_return_status '

Line 171: IF fnd_api.to_boolean (p_commit)

167: , x_var_rent_num => x_var_rent_num
168: );
169:
170: -- Standard check of p_commit.
171: IF fnd_api.to_boolean (p_commit)
172: THEN
173: COMMIT;
174: END IF;
175:

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

173: COMMIT;
174: END IF;
175:
176: END IF;
177: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
178: , p_count => x_msg_count
179: , p_data => x_msg_data
180: );
181: EXCEPTION

Line 182: WHEN fnd_api.g_exc_error

178: , p_count => x_msg_count
179: , p_data => x_msg_data
180: );
181: EXCEPTION
182: WHEN fnd_api.g_exc_error
183: THEN
184: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
185: , p_count => x_msg_count
186: , p_data => x_msg_data

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

180: );
181: EXCEPTION
182: WHEN fnd_api.g_exc_error
183: THEN
184: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
185: , p_count => x_msg_count
186: , p_data => x_msg_data
187: );
188: x_return_status := fnd_api.g_ret_sts_error;

Line 188: x_return_status := fnd_api.g_ret_sts_error;

184: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
185: , p_count => x_msg_count
186: , p_data => x_msg_data
187: );
188: x_return_status := fnd_api.g_ret_sts_error;
189: pn_varen_util.pvt_debug ( l_api_name_full
190: || ' : '
191: || 'Exception : '
192: || SQLERRM

Line 207: WHEN fnd_api.g_exc_unexpected_error

203: || 'No of Error Messages : '
204: || x_msg_count
205: , 3
206: );
207: WHEN fnd_api.g_exc_unexpected_error
208: THEN
209: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
210: , p_count => x_msg_count
211: , p_data => x_msg_data

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

205: , 3
206: );
207: WHEN fnd_api.g_exc_unexpected_error
208: THEN
209: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
210: , p_count => x_msg_count
211: , p_data => x_msg_data
212: );
213: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 213: x_return_status := fnd_api.g_ret_sts_unexp_error;

209: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
210: , p_count => x_msg_count
211: , p_data => x_msg_data
212: );
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: pn_varen_util.pvt_debug ( l_api_name_full
215: || ' : '
216: || 'Unexpected Exception : '
217: || SQLERRM

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

230: , 3
231: );
232: WHEN OTHERS
233: THEN
234: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
235: , p_count => x_msg_count
236: , p_data => x_msg_data
237: );
238: x_return_status := fnd_api.g_ret_sts_error;

Line 238: x_return_status := fnd_api.g_ret_sts_error;

234: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
235: , p_count => x_msg_count
236: , p_data => x_msg_data
237: );
238: x_return_status := fnd_api.g_ret_sts_error;
239: pn_varen_util.pvt_debug ( l_api_name_full
240: || ' : '
241: || 'Others Exception : '
242: || SQLERRM

Line 278: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

274:
275:
276: PROCEDURE generate_periods (
277: p_api_version IN NUMBER
278: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
279: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
280: , p_var_rent_id IN NUMBER
281: , p_generate_periods IN VARCHAR2 DEFAULT 'N'
282: , x_return_status OUT NOCOPY VARCHAR2

Line 279: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

275:
276: PROCEDURE generate_periods (
277: p_api_version IN NUMBER
278: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
279: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
280: , p_var_rent_id IN NUMBER
281: , p_generate_periods IN VARCHAR2 DEFAULT 'N'
282: , x_return_status OUT NOCOPY VARCHAR2
283: , x_msg_count OUT NOCOPY NUMBER

Line 296: IF fnd_api.to_boolean (p_init_msg_list)

292: BEGIN
293: SAVEPOINT generate_periods;
294:
295: -- Initialize message list if p_init_msg_list is set to TRUE
296: IF fnd_api.to_boolean (p_init_msg_list)
297: THEN
298: fnd_msg_pub.initialize;
299: END IF;
300:

Line 302: IF NOT fnd_api.compatible_api_call (l_api_version

298: fnd_msg_pub.initialize;
299: END IF;
300:
301: -- Standard call to check for call compatibility.
302: IF NOT fnd_api.compatible_api_call (l_api_version
303: , p_api_version
304: , l_api_name
305: , g_pkg_name
306: )

Line 308: RAISE fnd_api.g_exc_error;

304: , l_api_name
305: , g_pkg_name
306: )
307: THEN
308: RAISE fnd_api.g_exc_error;
309: END IF;
310:
311: -- Actions performed using the APIs would be subject to
312: -- function security. If the responsibility does not allow

Line 324: RAISE fnd_api.g_exc_error;

320: fnd_message.set_name ('MO'
321: , 'MO_ORG_INVALID'
322: );
323: fnd_msg_pub.ADD;
324: RAISE fnd_api.g_exc_error;
325: END IF;
326:
327: --- Verifying whether the VRA from exists or not.
328: IF fnd_function.TEST (function_name => g_fun_name)

Line 339: RAISE fnd_api.g_exc_error;

335: fnd_message.set_name ('PN'
336: , 'PN_FUNCTION_SECURITY'
337: );
338: fnd_msg_pub.ADD;
339: RAISE fnd_api.g_exc_error;
340: ELSE
341: pn_varen_pvt.generate_periods (p_api_version => 1.0
342: , p_init_msg_list => fnd_api.g_false
343: , p_commit => fnd_api.g_false

Line 342: , p_init_msg_list => fnd_api.g_false

338: fnd_msg_pub.ADD;
339: RAISE fnd_api.g_exc_error;
340: ELSE
341: pn_varen_pvt.generate_periods (p_api_version => 1.0
342: , p_init_msg_list => fnd_api.g_false
343: , p_commit => fnd_api.g_false
344: , p_var_rent_id => p_var_rent_id
345: , p_var_rent_num => NULL --for future use
346: , p_org_id => g_org_id

Line 343: , p_commit => fnd_api.g_false

339: RAISE fnd_api.g_exc_error;
340: ELSE
341: pn_varen_pvt.generate_periods (p_api_version => 1.0
342: , p_init_msg_list => fnd_api.g_false
343: , p_commit => fnd_api.g_false
344: , p_var_rent_id => p_var_rent_id
345: , p_var_rent_num => NULL --for future use
346: , p_org_id => g_org_id
347: , p_generate_periods => 'Y'

Line 354: IF fnd_api.to_boolean (p_commit)

350: , x_msg_data => x_msg_data
351: );
352:
353: -- Standard check of p_commit.
354: IF fnd_api.to_boolean (p_commit)
355: THEN
356: COMMIT;
357: END IF;
358:

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

355: THEN
356: COMMIT;
357: END IF;
358:
359: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
360: , p_count => x_msg_count
361: , p_data => x_msg_data
362: );
363: END IF;

Line 365: WHEN fnd_api.g_exc_error

361: , p_data => x_msg_data
362: );
363: END IF;
364: EXCEPTION
365: WHEN fnd_api.g_exc_error
366: THEN
367: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
368: , p_count => x_msg_count
369: , p_data => x_msg_data

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

363: END IF;
364: EXCEPTION
365: WHEN fnd_api.g_exc_error
366: THEN
367: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
368: , p_count => x_msg_count
369: , p_data => x_msg_data
370: );
371: x_return_status := fnd_api.g_ret_sts_error;

Line 371: x_return_status := fnd_api.g_ret_sts_error;

367: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
368: , p_count => x_msg_count
369: , p_data => x_msg_data
370: );
371: x_return_status := fnd_api.g_ret_sts_error;
372: pn_varen_util.pvt_debug ( l_api_name_full
373: || ' : '
374: || 'Exception : '
375: || SQLERRM

Line 390: WHEN fnd_api.g_exc_unexpected_error

386: || 'No of Error Messages : '
387: || x_msg_count
388: , 3
389: );
390: WHEN fnd_api.g_exc_unexpected_error
391: THEN
392: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
393: , p_count => x_msg_count
394: , p_data => x_msg_data

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

388: , 3
389: );
390: WHEN fnd_api.g_exc_unexpected_error
391: THEN
392: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
393: , p_count => x_msg_count
394: , p_data => x_msg_data
395: );
396: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 396: x_return_status := fnd_api.g_ret_sts_unexp_error;

392: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
393: , p_count => x_msg_count
394: , p_data => x_msg_data
395: );
396: x_return_status := fnd_api.g_ret_sts_unexp_error;
397: pn_varen_util.pvt_debug ( l_api_name_full
398: || ' : '
399: || 'Unexpected Exception : '
400: || SQLERRM

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

413: , 3
414: );
415: WHEN OTHERS
416: THEN
417: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
418: , p_count => x_msg_count
419: , p_data => x_msg_data
420: );
421: x_return_status := fnd_api.g_ret_sts_error;

Line 421: x_return_status := fnd_api.g_ret_sts_error;

417: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
418: , p_count => x_msg_count
419: , p_data => x_msg_data
420: );
421: x_return_status := fnd_api.g_ret_sts_error;
422: pn_varen_util.pvt_debug ( l_api_name_full
423: || ' : '
424: || 'Others Exception : '
425: || SQLERRM

Line 459: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

455: -- Standards are incorporated.
456:
457: PROCEDURE create_bkpt_const_allow_abat (
458: p_api_version IN NUMBER
459: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
460: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
461: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type

Line 460: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

456:
457: PROCEDURE create_bkpt_const_allow_abat (
458: p_api_version IN NUMBER
459: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
460: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
461: , p_validate_flag IN VARCHAR2 DEFAULT 'N'
462: , p_variable_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
463: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type
464: , p_breakpoint_details_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_details_tbl_type

Line 481: IF fnd_api.to_boolean (p_init_msg_list)

477: BEGIN
478: SAVEPOINT create_bkpt_const_allow_abat;
479:
480: -- Initialize message list if p_init_msg_list is set to TRUE
481: IF fnd_api.to_boolean (p_init_msg_list)
482: THEN
483: fnd_msg_pub.initialize;
484: END IF;
485:

Line 487: IF NOT fnd_api.compatible_api_call (l_api_version

483: fnd_msg_pub.initialize;
484: END IF;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT fnd_api.compatible_api_call (l_api_version
488: , p_api_version
489: , l_api_name
490: , g_pkg_name
491: )

Line 493: RAISE fnd_api.g_exc_error;

489: , l_api_name
490: , g_pkg_name
491: )
492: THEN
493: RAISE fnd_api.g_exc_error;
494: END IF;
495:
496: -- Actions performed using the APIs would be subject to
497: -- function security. If the responsibility does not allow

Line 509: RAISE fnd_api.g_exc_error;

505: fnd_message.set_name ('MO'
506: , 'MO_ORG_INVALID'
507: );
508: fnd_msg_pub.ADD;
509: RAISE fnd_api.g_exc_error;
510: END IF;
511:
512: --- Verifying whether the VRA from exists or not.
513: IF fnd_function.TEST (function_name => g_fun_name)

Line 524: RAISE fnd_api.g_exc_error;

520: fnd_message.set_name ('PN'
521: , 'PN_FUNCTION_SECURITY'
522: );
523: fnd_msg_pub.ADD;
524: RAISE fnd_api.g_exc_error;
525: ELSE
526: pn_varen_util.pvt_debug ( l_api_name_full
527: || ' : '
528: || 'Start of Create Breakpoints, Constraints, Allowanced and Abatements package'

Line 552: IF fnd_api.to_boolean (p_commit)

548: , 3
549: );
550:
551: -- Standard check of p_commit.
552: IF fnd_api.to_boolean (p_commit)
553: THEN
554: COMMIT;
555: END IF;
556:

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

553: THEN
554: COMMIT;
555: END IF;
556:
557: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
558: , p_count => x_msg_count
559: , p_data => x_msg_data
560: );
561: END IF;

Line 564: WHEN fnd_api.g_exc_error

560: );
561: END IF;
562: --
563: EXCEPTION
564: WHEN fnd_api.g_exc_error
565: THEN
566: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
567: , p_count => x_msg_count
568: , p_data => x_msg_data

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

562: --
563: EXCEPTION
564: WHEN fnd_api.g_exc_error
565: THEN
566: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
567: , p_count => x_msg_count
568: , p_data => x_msg_data
569: );
570: x_return_status := fnd_api.g_ret_sts_error;

Line 570: x_return_status := fnd_api.g_ret_sts_error;

566: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
567: , p_count => x_msg_count
568: , p_data => x_msg_data
569: );
570: x_return_status := fnd_api.g_ret_sts_error;
571: pn_varen_util.pvt_debug ( l_api_name_full
572: || ' : '
573: || 'Exception : '
574: || SQLERRM

Line 589: WHEN fnd_api.g_exc_unexpected_error

585: || 'No of Error Messages : '
586: || x_msg_count
587: , 3
588: );
589: WHEN fnd_api.g_exc_unexpected_error
590: THEN
591: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
592: , p_count => x_msg_count
593: , p_data => x_msg_data

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

587: , 3
588: );
589: WHEN fnd_api.g_exc_unexpected_error
590: THEN
591: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
592: , p_count => x_msg_count
593: , p_data => x_msg_data
594: );
595: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 595: x_return_status := fnd_api.g_ret_sts_unexp_error;

591: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
592: , p_count => x_msg_count
593: , p_data => x_msg_data
594: );
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596: pn_varen_util.pvt_debug ( l_api_name_full
597: || ' : '
598: || 'Unexpected Exception : '
599: || SQLERRM

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

612: , 3
613: );
614: WHEN OTHERS
615: THEN
616: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
617: , p_count => x_msg_count
618: , p_data => x_msg_data
619: );
620: x_return_status := fnd_api.g_ret_sts_error;

Line 620: x_return_status := fnd_api.g_ret_sts_error;

616: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
617: , p_count => x_msg_count
618: , p_data => x_msg_data
619: );
620: x_return_status := fnd_api.g_ret_sts_error;
621: pn_varen_util.pvt_debug ( l_api_name_full
622: || ' : '
623: || 'Others Exception : '
624: || SQLERRM

Line 659: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

655:
656:
657: PROCEDURE update_var_rent (
658: p_api_version IN NUMBER
659: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
660: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
661: , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type

Line 660: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

656:
657: PROCEDURE update_var_rent (
658: p_api_version IN NUMBER
659: , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
660: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
661: , p_validate_flag IN VARCHAR2 DEFAULT 'Y'
662: , p_upd_var_rent_rec IN OUT NOCOPY pn_varen_pvt.upd_var_rent_rec_type
663: , p_var_rent_lines_tbl IN OUT NOCOPY pn_varen_pvt.variable_rent_lines_tbl_type
664: , p_breakpoint_header_tbl IN OUT NOCOPY pn_varen_pvt.breakpoint_header_tbl_type

Line 686: IF fnd_api.to_boolean (p_init_msg_list)

682:
683: SAVEPOINT update_var_rent;
684:
685: -- Initialize message list if p_init_msg_list is set to TRUE
686: IF fnd_api.to_boolean (p_init_msg_list)
687: THEN
688: fnd_msg_pub.initialize;
689: END IF;
690:

Line 692: IF NOT fnd_api.compatible_api_call (l_api_version

688: fnd_msg_pub.initialize;
689: END IF;
690:
691: -- Standard call to check for call compatibility.
692: IF NOT fnd_api.compatible_api_call (l_api_version
693: , p_api_version
694: , l_api_name
695: , g_pkg_name
696: )

Line 698: RAISE fnd_api.g_exc_error;

694: , l_api_name
695: , g_pkg_name
696: )
697: THEN
698: RAISE fnd_api.g_exc_error;
699: END IF;
700:
701: -- Actions performed using the APIs would be subject to
702: -- function security. If the responsibility does not allow

Line 714: RAISE fnd_api.g_exc_error;

710: fnd_message.set_name ('MO'
711: , 'MO_ORG_INVALID'
712: );
713: fnd_msg_pub.ADD;
714: RAISE fnd_api.g_exc_error;
715: END IF;
716:
717: --- Verifying whether the VRA from exists or not.
718: IF fnd_function.TEST (function_name => g_fun_name)

Line 729: RAISE fnd_api.g_exc_error;

725: fnd_message.set_name ('PN'
726: , 'PN_FUNCTION_SECURITY'
727: );
728: fnd_msg_pub.ADD;
729: RAISE fnd_api.g_exc_error;
730: ELSE
731: pn_varen_util.pvt_debug ( l_api_name_full
732: || ' : '
733: || 'Start of Update Variable Rent package'

Line 739: , p_init_msg_list => fnd_api.g_false

735: );
736:
737:
738: pn_varen_pvt.update_var_rent (p_api_version => 1.0
739: , p_init_msg_list => fnd_api.g_false
740: , p_commit => fnd_api.g_false
741: , p_validate_flag => p_validate_flag
742: , p_upd_var_rent_rec => p_upd_var_rent_rec
743: , p_var_rent_lines_tbl => p_var_rent_lines_tbl

Line 740: , p_commit => fnd_api.g_false

736:
737:
738: pn_varen_pvt.update_var_rent (p_api_version => 1.0
739: , p_init_msg_list => fnd_api.g_false
740: , p_commit => fnd_api.g_false
741: , p_validate_flag => p_validate_flag
742: , p_upd_var_rent_rec => p_upd_var_rent_rec
743: , p_var_rent_lines_tbl => p_var_rent_lines_tbl
744: , p_breakpoint_header_tbl => p_breakpoint_header_tbl

Line 763: IF fnd_api.to_boolean (p_commit)

759: , 3
760: );
761:
762: -- Standard check of p_commit.
763: IF fnd_api.to_boolean (p_commit)
764: THEN
765: COMMIT;
766: END IF;
767:

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

764: THEN
765: COMMIT;
766: END IF;
767:
768: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
769: , p_count => x_msg_count
770: , p_data => x_msg_data
771: );
772: END IF;

Line 774: WHEN fnd_api.g_exc_error

770: , p_data => x_msg_data
771: );
772: END IF;
773: EXCEPTION
774: WHEN fnd_api.g_exc_error
775: THEN
776: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
777: , p_count => x_msg_count
778: , p_data => x_msg_data

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

772: END IF;
773: EXCEPTION
774: WHEN fnd_api.g_exc_error
775: THEN
776: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
777: , p_count => x_msg_count
778: , p_data => x_msg_data
779: );
780: x_return_status := fnd_api.g_ret_sts_error;

Line 780: x_return_status := fnd_api.g_ret_sts_error;

776: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
777: , p_count => x_msg_count
778: , p_data => x_msg_data
779: );
780: x_return_status := fnd_api.g_ret_sts_error;
781: pn_varen_util.pvt_debug ( l_api_name_full
782: || ' : '
783: || 'Exception : '
784: || SQLERRM

Line 799: WHEN fnd_api.g_exc_unexpected_error

795: || 'No of Error Messages : '
796: || x_msg_count
797: , 3
798: );
799: WHEN fnd_api.g_exc_unexpected_error
800: THEN
801: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
802: , p_count => x_msg_count
803: , p_data => x_msg_data

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

797: , 3
798: );
799: WHEN fnd_api.g_exc_unexpected_error
800: THEN
801: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
802: , p_count => x_msg_count
803: , p_data => x_msg_data
804: );
805: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 805: x_return_status := fnd_api.g_ret_sts_unexp_error;

801: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
802: , p_count => x_msg_count
803: , p_data => x_msg_data
804: );
805: x_return_status := fnd_api.g_ret_sts_unexp_error;
806: pn_varen_util.pvt_debug ( l_api_name_full
807: || ' : '
808: || 'Unexpected Exception : '
809: || SQLERRM

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

822: , 3
823: );
824: WHEN OTHERS
825: THEN
826: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
827: , p_count => x_msg_count
828: , p_data => x_msg_data
829: );
830: x_return_status := fnd_api.g_ret_sts_error;

Line 830: x_return_status := fnd_api.g_ret_sts_error;

826: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false
827: , p_count => x_msg_count
828: , p_data => x_msg_data
829: );
830: x_return_status := fnd_api.g_ret_sts_error;
831: pn_varen_util.pvt_debug ( l_api_name_full
832: || ' : '
833: || 'Others Exception : '
834: || SQLERRM