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.

[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on FND_API

Line 40: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

36: -- Standard start of API savepoint
37: SAVEPOINT createschedulerrequest;
38:
39: -- Standard call to check for call compatibility
40: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
41: RAISE fnd_api.g_exc_unexpected_error;
42: END IF;
43:
44: -- Initialize message list if p_init_msg_list is set to TRUE

Line 41: RAISE fnd_api.g_exc_unexpected_error;

37: SAVEPOINT createschedulerrequest;
38:
39: -- Standard call to check for call compatibility
40: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
41: RAISE fnd_api.g_exc_unexpected_error;
42: END IF;
43:
44: -- Initialize message list if p_init_msg_list is set to TRUE
45: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 45: IF fnd_api.to_boolean(p_init_msg_list) THEN

41: RAISE fnd_api.g_exc_unexpected_error;
42: END IF;
43:
44: -- Initialize message list if p_init_msg_list is set to TRUE
45: IF fnd_api.to_boolean(p_init_msg_list) THEN
46: fnd_msg_pub.initialize;
47: END IF;
48:
49: -- Initialize API return status to success

Line 50: x_return_status := fnd_api.g_ret_sts_success;

46: fnd_msg_pub.initialize;
47: END IF;
48:
49: -- Initialize API return status to success
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: INSERT INTO csf_r_sched_requests(
53: sched_request_id
54: , sched_request_name

Line 122: , p_init_msg_list => fnd_api.g_false

118: RETURNING request_task_id INTO l_request_task_id;
119:
120: create_resource_results(
121: p_api_version => 1
122: , p_init_msg_list => fnd_api.g_false
123: , p_commit => fnd_api.g_false
124: , x_return_status => x_return_status
125: , x_msg_count => x_msg_count
126: , x_msg_data => x_msg_data

Line 123: , p_commit => fnd_api.g_false

119:
120: create_resource_results(
121: p_api_version => 1
122: , p_init_msg_list => fnd_api.g_false
123: , p_commit => fnd_api.g_false
124: , x_return_status => x_return_status
125: , x_msg_count => x_msg_count
126: , x_msg_data => x_msg_data
127: , p_request_task_id => l_request_task_id

Line 132: IF fnd_api.to_boolean(p_commit) THEN

128: , p_resource_tbl => p_resource_tbl
129: );
130:
131: -- Standard check of p_commit
132: IF fnd_api.to_boolean(p_commit) THEN
133: COMMIT WORK;
134: END IF;
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN

Line 136: WHEN fnd_api.g_exc_error THEN

132: IF fnd_api.to_boolean(p_commit) THEN
133: COMMIT WORK;
134: END IF;
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO createschedulerrequest;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN fnd_api.g_exc_unexpected_error THEN

Line 138: x_return_status := fnd_api.g_ret_sts_error;

134: END IF;
135: EXCEPTION
136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO createschedulerrequest;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: ROLLBACK TO createschedulerrequest;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 140: WHEN fnd_api.g_exc_unexpected_error THEN

136: WHEN fnd_api.g_exc_error THEN
137: ROLLBACK TO createschedulerrequest;
138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: ROLLBACK TO createschedulerrequest;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN

Line 142: x_return_status := fnd_api.g_ret_sts_unexp_error;

138: x_return_status := fnd_api.g_ret_sts_error;
139: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: ROLLBACK TO createschedulerrequest;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO createschedulerrequest;
146: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 146: x_return_status := fnd_api.g_ret_sts_unexp_error;

142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO createschedulerrequest;
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
148: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
149: END IF;
150: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 170: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

166: -- Standard start of API savepoint
167: SAVEPOINT createresourceresults;
168:
169: -- Standard call to check for call compatibility
170: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE

Line 171: RAISE fnd_api.g_exc_unexpected_error;

167: SAVEPOINT createresourceresults;
168:
169: -- Standard call to check for call compatibility
170: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE
175: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 175: IF fnd_api.to_boolean(p_init_msg_list) THEN

171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: -- Initialize message list if p_init_msg_list is set to TRUE
175: IF fnd_api.to_boolean(p_init_msg_list) THEN
176: fnd_msg_pub.initialize;
177: END IF;
178:
179: IF p_resource_tbl IS NOT NULL AND p_resource_tbl.COUNT > 0 THEN

Line 214: x_return_status := fnd_api.g_ret_sts_success;

210: END LOOP;
211: END IF;
212:
213: -- Initialize API return status to success
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: EXCEPTION
217: WHEN fnd_api.g_exc_error THEN
218: ROLLBACK TO createresourceresults;

Line 217: WHEN fnd_api.g_exc_error THEN

213: -- Initialize API return status to success
214: x_return_status := fnd_api.g_ret_sts_success;
215:
216: EXCEPTION
217: WHEN fnd_api.g_exc_error THEN
218: ROLLBACK TO createresourceresults;
219: x_return_status := fnd_api.g_ret_sts_error;
220: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
221: WHEN fnd_api.g_exc_unexpected_error THEN

Line 219: x_return_status := fnd_api.g_ret_sts_error;

215:
216: EXCEPTION
217: WHEN fnd_api.g_exc_error THEN
218: ROLLBACK TO createresourceresults;
219: x_return_status := fnd_api.g_ret_sts_error;
220: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
221: WHEN fnd_api.g_exc_unexpected_error THEN
222: ROLLBACK TO createresourceresults;
223: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 221: WHEN fnd_api.g_exc_unexpected_error THEN

217: WHEN fnd_api.g_exc_error THEN
218: ROLLBACK TO createresourceresults;
219: x_return_status := fnd_api.g_ret_sts_error;
220: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
221: WHEN fnd_api.g_exc_unexpected_error THEN
222: ROLLBACK TO createresourceresults;
223: x_return_status := fnd_api.g_ret_sts_unexp_error;
224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS THEN

Line 223: x_return_status := fnd_api.g_ret_sts_unexp_error;

219: x_return_status := fnd_api.g_ret_sts_error;
220: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
221: WHEN fnd_api.g_exc_unexpected_error THEN
222: ROLLBACK TO createresourceresults;
223: x_return_status := fnd_api.g_ret_sts_unexp_error;
224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS THEN
226: ROLLBACK TO createresourceresults;
227: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 227: x_return_status := fnd_api.g_ret_sts_unexp_error;

223: x_return_status := fnd_api.g_ret_sts_unexp_error;
224: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS THEN
226: ROLLBACK TO createresourceresults;
227: x_return_status := fnd_api.g_ret_sts_unexp_error;
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
229: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
230: END IF;
231: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 281: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

277: -- Standard start of API savepoint
278: SAVEPOINT createplanoption;
279:
280: -- Standard call to check for call compatibility
281: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
282: RAISE fnd_api.g_exc_unexpected_error;
283: END IF;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE

Line 282: RAISE fnd_api.g_exc_unexpected_error;

278: SAVEPOINT createplanoption;
279:
280: -- Standard call to check for call compatibility
281: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
282: RAISE fnd_api.g_exc_unexpected_error;
283: END IF;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE
286: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 286: IF fnd_api.to_boolean(p_init_msg_list) THEN

282: RAISE fnd_api.g_exc_unexpected_error;
283: END IF;
284:
285: -- Initialize message list if p_init_msg_list is set to TRUE
286: IF fnd_api.to_boolean(p_init_msg_list) THEN
287: fnd_msg_pub.initialize;
288: END IF;
289:
290: -- Initialize API return status to success

Line 291: x_return_status := fnd_api.g_ret_sts_success;

287: fnd_msg_pub.initialize;
288: END IF;
289:
290: -- Initialize API return status to success
291: x_return_status := fnd_api.g_ret_sts_success;
292:
293: OPEN c_resource(p_request_task_id, p_resource_id, p_resource_type, p_spares_date, p_spares_cost);
294: FETCH c_resource INTO l_resource_rec;
295: IF c_resource%NOTFOUND THEN

Line 348: IF fnd_api.to_boolean(p_commit) THEN

344: -- output plan option id
345: x_plan_option_id := l_resource_rec.plan_option_id;
346:
347: -- Standard check of p_commit
348: IF fnd_api.to_boolean(p_commit) THEN
349: COMMIT WORK;
350: END IF;
351: EXCEPTION
352: WHEN fnd_api.g_exc_error THEN

Line 352: WHEN fnd_api.g_exc_error THEN

348: IF fnd_api.to_boolean(p_commit) THEN
349: COMMIT WORK;
350: END IF;
351: EXCEPTION
352: WHEN fnd_api.g_exc_error THEN
353: ROLLBACK TO createplanoption;
354: x_return_status := fnd_api.g_ret_sts_error;
355: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN

Line 354: x_return_status := fnd_api.g_ret_sts_error;

350: END IF;
351: EXCEPTION
352: WHEN fnd_api.g_exc_error THEN
353: ROLLBACK TO createplanoption;
354: x_return_status := fnd_api.g_ret_sts_error;
355: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO createplanoption;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 356: WHEN fnd_api.g_exc_unexpected_error THEN

352: WHEN fnd_api.g_exc_error THEN
353: ROLLBACK TO createplanoption;
354: x_return_status := fnd_api.g_ret_sts_error;
355: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO createplanoption;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
360: WHEN OTHERS THEN

Line 358: x_return_status := fnd_api.g_ret_sts_unexp_error;

354: x_return_status := fnd_api.g_ret_sts_error;
355: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
356: WHEN fnd_api.g_exc_unexpected_error THEN
357: ROLLBACK TO createplanoption;
358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
360: WHEN OTHERS THEN
361: ROLLBACK TO createplanoption;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 362: x_return_status := fnd_api.g_ret_sts_unexp_error;

358: x_return_status := fnd_api.g_ret_sts_unexp_error;
359: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
360: WHEN OTHERS THEN
361: ROLLBACK TO createplanoption;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:
364: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
365: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
366: END IF;

Line 393: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

389: -- Standard start of API savepoint
390: SAVEPOINT createplanoptiontask;
391:
392: -- Standard call to check for call compatibility
393: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE

Line 394: RAISE fnd_api.g_exc_unexpected_error;

390: SAVEPOINT createplanoptiontask;
391:
392: -- Standard call to check for call compatibility
393: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE
398: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 398: IF fnd_api.to_boolean(p_init_msg_list) THEN

394: RAISE fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: -- Initialize message list if p_init_msg_list is set to TRUE
398: IF fnd_api.to_boolean(p_init_msg_list) THEN
399: fnd_msg_pub.initialize;
400: END IF;
401:
402: -- Initialize API return status to success

Line 403: x_return_status := fnd_api.g_ret_sts_success;

399: fnd_msg_pub.initialize;
400: END IF;
401:
402: -- Initialize API return status to success
403: x_return_status := fnd_api.g_ret_sts_success;
404:
405: INSERT INTO csf_r_plan_option_tasks
406: (
407: plan_option_task_id

Line 430: IF fnd_api.to_boolean(p_commit) THEN

426: , 1
427: );
428:
429: -- Standard check of p_commit
430: IF fnd_api.to_boolean(p_commit) THEN
431: COMMIT WORK;
432: END IF;
433: EXCEPTION
434: WHEN fnd_api.g_exc_error THEN

Line 434: WHEN fnd_api.g_exc_error THEN

430: IF fnd_api.to_boolean(p_commit) THEN
431: COMMIT WORK;
432: END IF;
433: EXCEPTION
434: WHEN fnd_api.g_exc_error THEN
435: ROLLBACK TO createplanoptiontask;
436: x_return_status := fnd_api.g_ret_sts_error;
437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
438: WHEN fnd_api.g_exc_unexpected_error THEN

Line 436: x_return_status := fnd_api.g_ret_sts_error;

432: END IF;
433: EXCEPTION
434: WHEN fnd_api.g_exc_error THEN
435: ROLLBACK TO createplanoptiontask;
436: x_return_status := fnd_api.g_ret_sts_error;
437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
438: WHEN fnd_api.g_exc_unexpected_error THEN
439: ROLLBACK TO createplanoptiontask;
440: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 438: WHEN fnd_api.g_exc_unexpected_error THEN

434: WHEN fnd_api.g_exc_error THEN
435: ROLLBACK TO createplanoptiontask;
436: x_return_status := fnd_api.g_ret_sts_error;
437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
438: WHEN fnd_api.g_exc_unexpected_error THEN
439: ROLLBACK TO createplanoptiontask;
440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
442: WHEN OTHERS THEN

Line 440: x_return_status := fnd_api.g_ret_sts_unexp_error;

436: x_return_status := fnd_api.g_ret_sts_error;
437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
438: WHEN fnd_api.g_exc_unexpected_error THEN
439: ROLLBACK TO createplanoptiontask;
440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
442: WHEN OTHERS THEN
443: ROLLBACK TO createplanoptiontask;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 444: x_return_status := fnd_api.g_ret_sts_unexp_error;

440: x_return_status := fnd_api.g_ret_sts_unexp_error;
441: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
442: WHEN OTHERS THEN
443: ROLLBACK TO createplanoptiontask;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445:
446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;

Line 481: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

477: -- Standard start of API savepoint
478: SAVEPOINT createmessage;
479:
480: -- Standard call to check for call compatibility
481: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
482: RAISE fnd_api.g_exc_unexpected_error;
483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE

Line 482: RAISE fnd_api.g_exc_unexpected_error;

478: SAVEPOINT createmessage;
479:
480: -- Standard call to check for call compatibility
481: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
482: RAISE fnd_api.g_exc_unexpected_error;
483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE
486: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 486: IF fnd_api.to_boolean(p_init_msg_list) THEN

482: RAISE fnd_api.g_exc_unexpected_error;
483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE
486: IF fnd_api.to_boolean(p_init_msg_list) THEN
487: fnd_msg_pub.initialize;
488: END IF;
489:
490: -- Initialize API return status to success

Line 491: x_return_status := fnd_api.g_ret_sts_success;

487: fnd_msg_pub.initialize;
488: END IF;
489:
490: -- Initialize API return status to success
491: x_return_status := fnd_api.g_ret_sts_success;
492:
493: OPEN c_message(p_request_id);
494: FETCH c_message INTO l_rec;
495: IF c_message%NOTFOUND THEN

Line 520: IF fnd_api.to_boolean(p_commit) THEN

516:
517: x_message_id := l_rec.message_id;
518:
519: -- Standard check of p_commit
520: IF fnd_api.to_boolean(p_commit) THEN
521: COMMIT WORK;
522: END IF;
523:
524: EXCEPTION

Line 525: WHEN fnd_api.g_exc_error THEN

521: COMMIT WORK;
522: END IF;
523:
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO createmessage;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: WHEN fnd_api.g_exc_unexpected_error THEN

Line 527: x_return_status := fnd_api.g_ret_sts_error;

523:
524: EXCEPTION
525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO createmessage;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: ROLLBACK TO createmessage;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 529: WHEN fnd_api.g_exc_unexpected_error THEN

525: WHEN fnd_api.g_exc_error THEN
526: ROLLBACK TO createmessage;
527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: ROLLBACK TO createmessage;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN

Line 531: x_return_status := fnd_api.g_ret_sts_unexp_error;

527: x_return_status := fnd_api.g_ret_sts_error;
528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
529: WHEN fnd_api.g_exc_unexpected_error THEN
530: ROLLBACK TO createmessage;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: ROLLBACK TO createmessage;
535: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 535: x_return_status := fnd_api.g_ret_sts_unexp_error;

531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: ROLLBACK TO createmessage;
535: x_return_status := fnd_api.g_ret_sts_unexp_error;
536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
539: END IF;

Line 562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

558: -- Standard start of API savepoint
559: SAVEPOINT createmessagetoken;
560:
561: -- Standard call to check for call compatibility
562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE

Line 563: RAISE fnd_api.g_exc_unexpected_error;

559: SAVEPOINT createmessagetoken;
560:
561: -- Standard call to check for call compatibility
562: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE
567: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 567: IF fnd_api.to_boolean(p_init_msg_list) THEN

563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE
567: IF fnd_api.to_boolean(p_init_msg_list) THEN
568: fnd_msg_pub.initialize;
569: END IF;
570:
571: -- Initialize API return status to success

Line 572: x_return_status := fnd_api.g_ret_sts_success;

568: fnd_msg_pub.initialize;
569: END IF;
570:
571: -- Initialize API return status to success
572: x_return_status := fnd_api.g_ret_sts_success;
573:
574: INSERT INTO csf_r_message_tokens
575: (
576: message_token_id

Line 591: IF fnd_api.to_boolean(p_commit) THEN

587: , 1
588: );
589:
590: -- Standard check of p_commit
591: IF fnd_api.to_boolean(p_commit) THEN
592: COMMIT WORK;
593: END IF;
594: EXCEPTION
595: WHEN fnd_api.g_exc_error THEN

Line 595: WHEN fnd_api.g_exc_error THEN

591: IF fnd_api.to_boolean(p_commit) THEN
592: COMMIT WORK;
593: END IF;
594: EXCEPTION
595: WHEN fnd_api.g_exc_error THEN
596: ROLLBACK TO createmessagetoken;
597: x_return_status := fnd_api.g_ret_sts_error;
598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
599: --

Line 597: x_return_status := fnd_api.g_ret_sts_error;

593: END IF;
594: EXCEPTION
595: WHEN fnd_api.g_exc_error THEN
596: ROLLBACK TO createmessagetoken;
597: x_return_status := fnd_api.g_ret_sts_error;
598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
599: --
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: ROLLBACK TO createmessagetoken;

Line 600: WHEN fnd_api.g_exc_unexpected_error THEN

596: ROLLBACK TO createmessagetoken;
597: x_return_status := fnd_api.g_ret_sts_error;
598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
599: --
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: ROLLBACK TO createmessagetoken;
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
604: --

Line 602: x_return_status := fnd_api.g_ret_sts_unexp_error;

598: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
599: --
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: ROLLBACK TO createmessagetoken;
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
604: --
605: WHEN OTHERS THEN
606: ROLLBACK TO createmessagetoken;

Line 607: x_return_status := fnd_api.g_ret_sts_unexp_error;

603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
604: --
605: WHEN OTHERS THEN
606: ROLLBACK TO createmessagetoken;
607: x_return_status := fnd_api.g_ret_sts_unexp_error;
608:
609: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
610: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
611: END IF;

Line 672: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

668: -- Standard start of API savepoint
669: SAVEPOINT createplanoptions;
670:
671: -- Standard call to check for call compatibility
672: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
673: RAISE fnd_api.g_exc_unexpected_error;
674: END IF;
675:
676: -- Initialize message list if p_init_msg_list is set to TRUE

Line 673: RAISE fnd_api.g_exc_unexpected_error;

669: SAVEPOINT createplanoptions;
670:
671: -- Standard call to check for call compatibility
672: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
673: RAISE fnd_api.g_exc_unexpected_error;
674: END IF;
675:
676: -- Initialize message list if p_init_msg_list is set to TRUE
677: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 677: IF fnd_api.to_boolean(p_init_msg_list) THEN

673: RAISE fnd_api.g_exc_unexpected_error;
674: END IF;
675:
676: -- Initialize message list if p_init_msg_list is set to TRUE
677: IF fnd_api.to_boolean(p_init_msg_list) THEN
678: fnd_msg_pub.initialize;
679: END IF;
680:
681: -- Initialize API return status to success

Line 682: x_return_status := fnd_api.g_ret_sts_success;

678: fnd_msg_pub.initialize;
679: END IF;
680:
681: -- Initialize API return status to success
682: x_return_status := fnd_api.g_ret_sts_success;
683: x_plan_option_id_tbl := jtf_number_table();
684: IF p_resource_id_tbl IS NOT NULL AND p_resource_id_tbl.COUNT > 0 THEN
685:
686: j := p_resource_id_tbl.FIRST;

Line 773: IF fnd_api.to_boolean(p_commit) THEN

769: j := p_resource_id_tbl.NEXT(j);
770: END LOOP;
771: END IF;
772: -- Standard check of p_commit
773: IF fnd_api.to_boolean(p_commit) THEN
774: COMMIT WORK;
775: END IF;
776: EXCEPTION
777: WHEN fnd_api.g_exc_error THEN

Line 777: WHEN fnd_api.g_exc_error THEN

773: IF fnd_api.to_boolean(p_commit) THEN
774: COMMIT WORK;
775: END IF;
776: EXCEPTION
777: WHEN fnd_api.g_exc_error THEN
778: ROLLBACK TO createplanoptions;
779: x_return_status := fnd_api.g_ret_sts_error;
780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_unexpected_error THEN

Line 779: x_return_status := fnd_api.g_ret_sts_error;

775: END IF;
776: EXCEPTION
777: WHEN fnd_api.g_exc_error THEN
778: ROLLBACK TO createplanoptions;
779: x_return_status := fnd_api.g_ret_sts_error;
780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_unexpected_error THEN
782: ROLLBACK TO createplanoptions;
783: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 781: WHEN fnd_api.g_exc_unexpected_error THEN

777: WHEN fnd_api.g_exc_error THEN
778: ROLLBACK TO createplanoptions;
779: x_return_status := fnd_api.g_ret_sts_error;
780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_unexpected_error THEN
782: ROLLBACK TO createplanoptions;
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
785: WHEN OTHERS THEN

Line 783: x_return_status := fnd_api.g_ret_sts_unexp_error;

779: x_return_status := fnd_api.g_ret_sts_error;
780: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_unexpected_error THEN
782: ROLLBACK TO createplanoptions;
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
785: WHEN OTHERS THEN
786: ROLLBACK TO createplanoptions;
787: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 787: x_return_status := fnd_api.g_ret_sts_unexp_error;

783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
785: WHEN OTHERS THEN
786: ROLLBACK TO createplanoptions;
787: x_return_status := fnd_api.g_ret_sts_unexp_error;
788:
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
791: END IF;

Line 818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

814: -- Standard start of API savepoint
815: SAVEPOINT create_opttrips_request;
816:
817: -- Standard call to check for call compatibility
818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821:
822: -- Initialize message list if p_init_msg_list is set to TRUE

Line 819: RAISE fnd_api.g_exc_unexpected_error;

815: SAVEPOINT create_opttrips_request;
816:
817: -- Standard call to check for call compatibility
818: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821:
822: -- Initialize message list if p_init_msg_list is set to TRUE
823: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 823: IF fnd_api.to_boolean(p_init_msg_list) THEN

819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821:
822: -- Initialize message list if p_init_msg_list is set to TRUE
823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: -- Initialize API return status to success

Line 828: x_return_status := fnd_api.g_ret_sts_success;

824: fnd_msg_pub.initialize;
825: END IF;
826:
827: -- Initialize API return status to success
828: x_return_status := fnd_api.g_ret_sts_success;
829:
830: -- Create the Parent Request
831: create_scheduler_request(
832: p_api_version => 1

Line 840: IF x_return_status = fnd_api.g_ret_sts_error THEN

836: , p_name => p_parent_req_name
837: , p_object_id => -1
838: , x_request_id => x_sched_request_id
839: );
840: IF x_return_status = fnd_api.g_ret_sts_error THEN
841: RAISE fnd_api.g_exc_error;
842: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
843: RAISE fnd_api.g_exc_unexpected_error;
844: END IF;

Line 841: RAISE fnd_api.g_exc_error;

837: , p_object_id => -1
838: , x_request_id => x_sched_request_id
839: );
840: IF x_return_status = fnd_api.g_ret_sts_error THEN
841: RAISE fnd_api.g_exc_error;
842: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
843: RAISE fnd_api.g_exc_unexpected_error;
844: END IF;
845:

Line 842: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

838: , x_request_id => x_sched_request_id
839: );
840: IF x_return_status = fnd_api.g_ret_sts_error THEN
841: RAISE fnd_api.g_exc_error;
842: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
843: RAISE fnd_api.g_exc_unexpected_error;
844: END IF;
845:
846: /**

Line 843: RAISE fnd_api.g_exc_unexpected_error;

839: );
840: IF x_return_status = fnd_api.g_ret_sts_error THEN
841: RAISE fnd_api.g_exc_error;
842: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
843: RAISE fnd_api.g_exc_unexpected_error;
844: END IF;
845:
846: /**
847: * Create the Child Requests.

Line 895: IF fnd_api.to_boolean(p_commit) THEN

891: );
892: END IF;
893:
894: -- Standard check of p_commit
895: IF fnd_api.to_boolean(p_commit) THEN
896: COMMIT WORK;
897: END IF;
898: EXCEPTION
899: WHEN fnd_api.g_exc_error THEN

Line 899: WHEN fnd_api.g_exc_error THEN

895: IF fnd_api.to_boolean(p_commit) THEN
896: COMMIT WORK;
897: END IF;
898: EXCEPTION
899: WHEN fnd_api.g_exc_error THEN
900: ROLLBACK TO create_opttrips_request;
901: x_return_status := fnd_api.g_ret_sts_error;
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903: WHEN fnd_api.g_exc_unexpected_error THEN

Line 901: x_return_status := fnd_api.g_ret_sts_error;

897: END IF;
898: EXCEPTION
899: WHEN fnd_api.g_exc_error THEN
900: ROLLBACK TO create_opttrips_request;
901: x_return_status := fnd_api.g_ret_sts_error;
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: ROLLBACK TO create_opttrips_request;
905: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 903: WHEN fnd_api.g_exc_unexpected_error THEN

899: WHEN fnd_api.g_exc_error THEN
900: ROLLBACK TO create_opttrips_request;
901: x_return_status := fnd_api.g_ret_sts_error;
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: ROLLBACK TO create_opttrips_request;
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
907: WHEN OTHERS THEN

Line 905: x_return_status := fnd_api.g_ret_sts_unexp_error;

901: x_return_status := fnd_api.g_ret_sts_error;
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: ROLLBACK TO create_opttrips_request;
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
907: WHEN OTHERS THEN
908: ROLLBACK TO create_opttrips_request;
909: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 909: x_return_status := fnd_api.g_ret_sts_unexp_error;

905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
907: WHEN OTHERS THEN
908: ROLLBACK TO create_opttrips_request;
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910:
911: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
912: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
913: END IF;