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.CSF_REQUESTS_PVT dependencies on FND_API

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

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

Line 37: RAISE fnd_api.g_exc_unexpected_error;

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

Line 41: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 46: x_return_status := fnd_api.g_ret_sts_success;

42: fnd_msg_pub.initialize;
43: END IF;
44:
45: -- Initialize API return status to success
46: x_return_status := fnd_api.g_ret_sts_success;
47:
48: INSERT INTO csf_r_sched_requests(
49: sched_request_id
50: , sched_request_name

Line 107: , p_init_msg_list => fnd_api.g_false

103: RETURNING request_task_id INTO l_request_task_id;
104:
105: create_resource_results(
106: p_api_version => 1
107: , p_init_msg_list => fnd_api.g_false
108: , p_commit => fnd_api.g_false
109: , x_return_status => x_return_status
110: , x_msg_count => x_msg_count
111: , x_msg_data => x_msg_data

Line 108: , p_commit => fnd_api.g_false

104:
105: create_resource_results(
106: p_api_version => 1
107: , p_init_msg_list => fnd_api.g_false
108: , p_commit => fnd_api.g_false
109: , x_return_status => x_return_status
110: , x_msg_count => x_msg_count
111: , x_msg_data => x_msg_data
112: , p_request_task_id => l_request_task_id

Line 117: IF fnd_api.to_boolean(p_commit) THEN

113: , p_resource_tbl => p_resource_tbl
114: );
115:
116: -- Standard check of p_commit
117: IF fnd_api.to_boolean(p_commit) THEN
118: COMMIT WORK;
119: END IF;
120: EXCEPTION
121: WHEN fnd_api.g_exc_error THEN

Line 121: WHEN fnd_api.g_exc_error THEN

117: IF fnd_api.to_boolean(p_commit) THEN
118: COMMIT WORK;
119: END IF;
120: EXCEPTION
121: WHEN fnd_api.g_exc_error THEN
122: ROLLBACK TO createschedulerrequest;
123: x_return_status := fnd_api.g_ret_sts_error;
124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
125: WHEN fnd_api.g_exc_unexpected_error THEN

Line 123: x_return_status := fnd_api.g_ret_sts_error;

119: END IF;
120: EXCEPTION
121: WHEN fnd_api.g_exc_error THEN
122: ROLLBACK TO createschedulerrequest;
123: x_return_status := fnd_api.g_ret_sts_error;
124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: ROLLBACK TO createschedulerrequest;
127: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 125: WHEN fnd_api.g_exc_unexpected_error THEN

121: WHEN fnd_api.g_exc_error THEN
122: ROLLBACK TO createschedulerrequest;
123: x_return_status := fnd_api.g_ret_sts_error;
124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: ROLLBACK TO createschedulerrequest;
127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: WHEN OTHERS THEN

Line 127: x_return_status := fnd_api.g_ret_sts_unexp_error;

123: x_return_status := fnd_api.g_ret_sts_error;
124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: ROLLBACK TO createschedulerrequest;
127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: WHEN OTHERS THEN
130: ROLLBACK TO createschedulerrequest;
131: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 131: x_return_status := fnd_api.g_ret_sts_unexp_error;

127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: WHEN OTHERS THEN
130: ROLLBACK TO createschedulerrequest;
131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
133: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
134: END IF;
135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

151: -- Standard start of API savepoint
152: SAVEPOINT createresourceresults;
153:
154: -- Standard call to check for call compatibility
155: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE

Line 156: RAISE fnd_api.g_exc_unexpected_error;

152: SAVEPOINT createresourceresults;
153:
154: -- Standard call to check for call compatibility
155: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE
160: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 160: IF fnd_api.to_boolean(p_init_msg_list) THEN

156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: -- Initialize message list if p_init_msg_list is set to TRUE
160: IF fnd_api.to_boolean(p_init_msg_list) THEN
161: fnd_msg_pub.initialize;
162: END IF;
163:
164: IF p_resource_tbl IS NOT NULL AND p_resource_tbl.COUNT > 0 THEN

Line 195: x_return_status := fnd_api.g_ret_sts_success;

191: END LOOP;
192: END IF;
193:
194: -- Initialize API return status to success
195: x_return_status := fnd_api.g_ret_sts_success;
196:
197: EXCEPTION
198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK TO createresourceresults;

Line 198: WHEN fnd_api.g_exc_error THEN

194: -- Initialize API return status to success
195: x_return_status := fnd_api.g_ret_sts_success;
196:
197: EXCEPTION
198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK TO createresourceresults;
200: x_return_status := fnd_api.g_ret_sts_error;
201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
202: WHEN fnd_api.g_exc_unexpected_error THEN

Line 200: x_return_status := fnd_api.g_ret_sts_error;

196:
197: EXCEPTION
198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK TO createresourceresults;
200: x_return_status := fnd_api.g_ret_sts_error;
201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
202: WHEN fnd_api.g_exc_unexpected_error THEN
203: ROLLBACK TO createresourceresults;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 202: WHEN fnd_api.g_exc_unexpected_error THEN

198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK TO createresourceresults;
200: x_return_status := fnd_api.g_ret_sts_error;
201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
202: WHEN fnd_api.g_exc_unexpected_error THEN
203: ROLLBACK TO createresourceresults;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
206: WHEN OTHERS THEN

Line 204: x_return_status := fnd_api.g_ret_sts_unexp_error;

200: x_return_status := fnd_api.g_ret_sts_error;
201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
202: WHEN fnd_api.g_exc_unexpected_error THEN
203: ROLLBACK TO createresourceresults;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
206: WHEN OTHERS THEN
207: ROLLBACK TO createresourceresults;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 208: x_return_status := fnd_api.g_ret_sts_unexp_error;

204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
206: WHEN OTHERS THEN
207: ROLLBACK TO createresourceresults;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
210: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
211: END IF;
212: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

257: -- Standard start of API savepoint
258: SAVEPOINT createplanoption;
259:
260: -- Standard call to check for call compatibility
261: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE

Line 262: RAISE fnd_api.g_exc_unexpected_error;

258: SAVEPOINT createplanoption;
259:
260: -- Standard call to check for call compatibility
261: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE
266: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 266: IF fnd_api.to_boolean(p_init_msg_list) THEN

262: RAISE fnd_api.g_exc_unexpected_error;
263: END IF;
264:
265: -- Initialize message list if p_init_msg_list is set to TRUE
266: IF fnd_api.to_boolean(p_init_msg_list) THEN
267: fnd_msg_pub.initialize;
268: END IF;
269:
270: -- Initialize API return status to success

Line 271: x_return_status := fnd_api.g_ret_sts_success;

267: fnd_msg_pub.initialize;
268: END IF;
269:
270: -- Initialize API return status to success
271: x_return_status := fnd_api.g_ret_sts_success;
272:
273: OPEN c_resource(p_request_task_id, p_resource_id, p_resource_type, p_spares_date, p_spares_cost);
274: FETCH c_resource INTO l_resource_rec;
275: IF c_resource%NOTFOUND THEN

Line 326: IF fnd_api.to_boolean(p_commit) THEN

322: -- output plan option id
323: x_plan_option_id := l_resource_rec.plan_option_id;
324:
325: -- Standard check of p_commit
326: IF fnd_api.to_boolean(p_commit) THEN
327: COMMIT WORK;
328: END IF;
329: EXCEPTION
330: WHEN fnd_api.g_exc_error THEN

Line 330: WHEN fnd_api.g_exc_error THEN

326: IF fnd_api.to_boolean(p_commit) THEN
327: COMMIT WORK;
328: END IF;
329: EXCEPTION
330: WHEN fnd_api.g_exc_error THEN
331: ROLLBACK TO createplanoption;
332: x_return_status := fnd_api.g_ret_sts_error;
333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN

Line 332: x_return_status := fnd_api.g_ret_sts_error;

328: END IF;
329: EXCEPTION
330: WHEN fnd_api.g_exc_error THEN
331: ROLLBACK TO createplanoption;
332: x_return_status := fnd_api.g_ret_sts_error;
333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO createplanoption;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 334: WHEN fnd_api.g_exc_unexpected_error THEN

330: WHEN fnd_api.g_exc_error THEN
331: ROLLBACK TO createplanoption;
332: x_return_status := fnd_api.g_ret_sts_error;
333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO createplanoption;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
338: WHEN OTHERS THEN

Line 336: x_return_status := fnd_api.g_ret_sts_unexp_error;

332: x_return_status := fnd_api.g_ret_sts_error;
333: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO createplanoption;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
338: WHEN OTHERS THEN
339: ROLLBACK TO createplanoption;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 340: x_return_status := fnd_api.g_ret_sts_unexp_error;

336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
338: WHEN OTHERS THEN
339: ROLLBACK TO createplanoption;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341:
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;

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

367: -- Standard start of API savepoint
368: SAVEPOINT createplanoptiontask;
369:
370: -- Standard call to check for call compatibility
371: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
372: RAISE fnd_api.g_exc_unexpected_error;
373: END IF;
374:
375: -- Initialize message list if p_init_msg_list is set to TRUE

Line 372: RAISE fnd_api.g_exc_unexpected_error;

368: SAVEPOINT createplanoptiontask;
369:
370: -- Standard call to check for call compatibility
371: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
372: RAISE fnd_api.g_exc_unexpected_error;
373: END IF;
374:
375: -- Initialize message list if p_init_msg_list is set to TRUE
376: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 376: IF fnd_api.to_boolean(p_init_msg_list) THEN

372: RAISE fnd_api.g_exc_unexpected_error;
373: END IF;
374:
375: -- Initialize message list if p_init_msg_list is set to TRUE
376: IF fnd_api.to_boolean(p_init_msg_list) THEN
377: fnd_msg_pub.initialize;
378: END IF;
379:
380: -- Initialize API return status to success

Line 381: x_return_status := fnd_api.g_ret_sts_success;

377: fnd_msg_pub.initialize;
378: END IF;
379:
380: -- Initialize API return status to success
381: x_return_status := fnd_api.g_ret_sts_success;
382:
383: INSERT INTO csf_r_plan_option_tasks
384: (
385: plan_option_task_id

Line 408: IF fnd_api.to_boolean(p_commit) THEN

404: , 1
405: );
406:
407: -- Standard check of p_commit
408: IF fnd_api.to_boolean(p_commit) THEN
409: COMMIT WORK;
410: END IF;
411: EXCEPTION
412: WHEN fnd_api.g_exc_error THEN

Line 412: WHEN fnd_api.g_exc_error THEN

408: IF fnd_api.to_boolean(p_commit) THEN
409: COMMIT WORK;
410: END IF;
411: EXCEPTION
412: WHEN fnd_api.g_exc_error THEN
413: ROLLBACK TO createplanoptiontask;
414: x_return_status := fnd_api.g_ret_sts_error;
415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
416: WHEN fnd_api.g_exc_unexpected_error THEN

Line 414: x_return_status := fnd_api.g_ret_sts_error;

410: END IF;
411: EXCEPTION
412: WHEN fnd_api.g_exc_error THEN
413: ROLLBACK TO createplanoptiontask;
414: x_return_status := fnd_api.g_ret_sts_error;
415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
416: WHEN fnd_api.g_exc_unexpected_error THEN
417: ROLLBACK TO createplanoptiontask;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 416: WHEN fnd_api.g_exc_unexpected_error THEN

412: WHEN fnd_api.g_exc_error THEN
413: ROLLBACK TO createplanoptiontask;
414: x_return_status := fnd_api.g_ret_sts_error;
415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
416: WHEN fnd_api.g_exc_unexpected_error THEN
417: ROLLBACK TO createplanoptiontask;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
420: WHEN OTHERS THEN

Line 418: x_return_status := fnd_api.g_ret_sts_unexp_error;

414: x_return_status := fnd_api.g_ret_sts_error;
415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
416: WHEN fnd_api.g_exc_unexpected_error THEN
417: ROLLBACK TO createplanoptiontask;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
420: WHEN OTHERS THEN
421: ROLLBACK TO createplanoptiontask;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 422: x_return_status := fnd_api.g_ret_sts_unexp_error;

418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
420: WHEN OTHERS THEN
421: ROLLBACK TO createplanoptiontask;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
425: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
426: END IF;

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

455: -- Standard start of API savepoint
456: SAVEPOINT createmessage;
457:
458: -- Standard call to check for call compatibility
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: -- Initialize message list if p_init_msg_list is set to TRUE

Line 460: RAISE fnd_api.g_exc_unexpected_error;

456: SAVEPOINT createmessage;
457:
458: -- Standard call to check for call compatibility
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: -- Initialize message list if p_init_msg_list is set to TRUE
464: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 464: IF fnd_api.to_boolean(p_init_msg_list) THEN

460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: -- Initialize message list if p_init_msg_list is set to TRUE
464: IF fnd_api.to_boolean(p_init_msg_list) THEN
465: fnd_msg_pub.initialize;
466: END IF;
467:
468: -- Initialize API return status to success

Line 469: x_return_status := fnd_api.g_ret_sts_success;

465: fnd_msg_pub.initialize;
466: END IF;
467:
468: -- Initialize API return status to success
469: x_return_status := fnd_api.g_ret_sts_success;
470:
471: OPEN c_message(p_request_id);
472: FETCH c_message INTO l_rec;
473: IF c_message%NOTFOUND THEN

Line 498: IF fnd_api.to_boolean(p_commit) THEN

494:
495: x_message_id := l_rec.message_id;
496:
497: -- Standard check of p_commit
498: IF fnd_api.to_boolean(p_commit) THEN
499: COMMIT WORK;
500: END IF;
501:
502: EXCEPTION

Line 503: WHEN fnd_api.g_exc_error THEN

499: COMMIT WORK;
500: END IF;
501:
502: EXCEPTION
503: WHEN fnd_api.g_exc_error THEN
504: ROLLBACK TO createmessage;
505: x_return_status := fnd_api.g_ret_sts_error;
506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
507: WHEN fnd_api.g_exc_unexpected_error THEN

Line 505: x_return_status := fnd_api.g_ret_sts_error;

501:
502: EXCEPTION
503: WHEN fnd_api.g_exc_error THEN
504: ROLLBACK TO createmessage;
505: x_return_status := fnd_api.g_ret_sts_error;
506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
507: WHEN fnd_api.g_exc_unexpected_error THEN
508: ROLLBACK TO createmessage;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 507: WHEN fnd_api.g_exc_unexpected_error THEN

503: WHEN fnd_api.g_exc_error THEN
504: ROLLBACK TO createmessage;
505: x_return_status := fnd_api.g_ret_sts_error;
506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
507: WHEN fnd_api.g_exc_unexpected_error THEN
508: ROLLBACK TO createmessage;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
511: WHEN OTHERS THEN

Line 509: x_return_status := fnd_api.g_ret_sts_unexp_error;

505: x_return_status := fnd_api.g_ret_sts_error;
506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
507: WHEN fnd_api.g_exc_unexpected_error THEN
508: ROLLBACK TO createmessage;
509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
511: WHEN OTHERS THEN
512: ROLLBACK TO createmessage;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 513: x_return_status := fnd_api.g_ret_sts_unexp_error;

509: x_return_status := fnd_api.g_ret_sts_unexp_error;
510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
511: WHEN OTHERS THEN
512: ROLLBACK TO createmessage;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514:
515: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
516: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
517: END IF;

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

536: -- Standard start of API savepoint
537: SAVEPOINT createmessagetoken;
538:
539: -- Standard call to check for call compatibility
540: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
541: RAISE fnd_api.g_exc_unexpected_error;
542: END IF;
543:
544: -- Initialize message list if p_init_msg_list is set to TRUE

Line 541: RAISE fnd_api.g_exc_unexpected_error;

537: SAVEPOINT createmessagetoken;
538:
539: -- Standard call to check for call compatibility
540: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
541: RAISE fnd_api.g_exc_unexpected_error;
542: END IF;
543:
544: -- Initialize message list if p_init_msg_list is set to TRUE
545: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 545: IF fnd_api.to_boolean(p_init_msg_list) THEN

541: RAISE fnd_api.g_exc_unexpected_error;
542: END IF;
543:
544: -- Initialize message list if p_init_msg_list is set to TRUE
545: IF fnd_api.to_boolean(p_init_msg_list) THEN
546: fnd_msg_pub.initialize;
547: END IF;
548:
549: -- Initialize API return status to success

Line 550: x_return_status := fnd_api.g_ret_sts_success;

546: fnd_msg_pub.initialize;
547: END IF;
548:
549: -- Initialize API return status to success
550: x_return_status := fnd_api.g_ret_sts_success;
551:
552: INSERT INTO csf_r_message_tokens
553: (
554: message_token_id

Line 569: IF fnd_api.to_boolean(p_commit) THEN

565: , 1
566: );
567:
568: -- Standard check of p_commit
569: IF fnd_api.to_boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN

Line 573: WHEN fnd_api.g_exc_error THEN

569: IF fnd_api.to_boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN
574: ROLLBACK TO createmessagetoken;
575: x_return_status := fnd_api.g_ret_sts_error;
576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
577: --

Line 575: x_return_status := fnd_api.g_ret_sts_error;

571: END IF;
572: EXCEPTION
573: WHEN fnd_api.g_exc_error THEN
574: ROLLBACK TO createmessagetoken;
575: x_return_status := fnd_api.g_ret_sts_error;
576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
577: --
578: WHEN fnd_api.g_exc_unexpected_error THEN
579: ROLLBACK TO createmessagetoken;

Line 578: WHEN fnd_api.g_exc_unexpected_error THEN

574: ROLLBACK TO createmessagetoken;
575: x_return_status := fnd_api.g_ret_sts_error;
576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
577: --
578: WHEN fnd_api.g_exc_unexpected_error THEN
579: ROLLBACK TO createmessagetoken;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
582: --

Line 580: x_return_status := fnd_api.g_ret_sts_unexp_error;

576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
577: --
578: WHEN fnd_api.g_exc_unexpected_error THEN
579: ROLLBACK TO createmessagetoken;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
582: --
583: WHEN OTHERS THEN
584: ROLLBACK TO createmessagetoken;

Line 585: x_return_status := fnd_api.g_ret_sts_unexp_error;

581: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
582: --
583: WHEN OTHERS THEN
584: ROLLBACK TO createmessagetoken;
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586:
587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
588: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
589: END IF;

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

638: -- Standard start of API savepoint
639: SAVEPOINT createplanoptions;
640:
641: -- Standard call to check for call compatibility
642: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
643: RAISE fnd_api.g_exc_unexpected_error;
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE

Line 643: RAISE fnd_api.g_exc_unexpected_error;

639: SAVEPOINT createplanoptions;
640:
641: -- Standard call to check for call compatibility
642: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
643: RAISE fnd_api.g_exc_unexpected_error;
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE
647: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 647: IF fnd_api.to_boolean(p_init_msg_list) THEN

643: RAISE fnd_api.g_exc_unexpected_error;
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE
647: IF fnd_api.to_boolean(p_init_msg_list) THEN
648: fnd_msg_pub.initialize;
649: END IF;
650:
651: -- Initialize API return status to success

Line 652: x_return_status := fnd_api.g_ret_sts_success;

648: fnd_msg_pub.initialize;
649: END IF;
650:
651: -- Initialize API return status to success
652: x_return_status := fnd_api.g_ret_sts_success;
653: x_plan_option_id_tbl := jtf_number_table();
654: IF p_resource_id_tbl IS NOT NULL AND p_resource_id_tbl.COUNT > 0 THEN
655:
656: j := p_resource_id_tbl.FIRST;

Line 713: IF fnd_api.to_boolean(p_commit) THEN

709: j := p_resource_id_tbl.NEXT(j);
710: END LOOP;
711: END IF;
712: -- Standard check of p_commit
713: IF fnd_api.to_boolean(p_commit) THEN
714: COMMIT WORK;
715: END IF;
716: EXCEPTION
717: WHEN fnd_api.g_exc_error THEN

Line 717: WHEN fnd_api.g_exc_error THEN

713: IF fnd_api.to_boolean(p_commit) THEN
714: COMMIT WORK;
715: END IF;
716: EXCEPTION
717: WHEN fnd_api.g_exc_error THEN
718: ROLLBACK TO createplanoptions;
719: x_return_status := fnd_api.g_ret_sts_error;
720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
721: WHEN fnd_api.g_exc_unexpected_error THEN

Line 719: x_return_status := fnd_api.g_ret_sts_error;

715: END IF;
716: EXCEPTION
717: WHEN fnd_api.g_exc_error THEN
718: ROLLBACK TO createplanoptions;
719: x_return_status := fnd_api.g_ret_sts_error;
720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
721: WHEN fnd_api.g_exc_unexpected_error THEN
722: ROLLBACK TO createplanoptions;
723: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 721: WHEN fnd_api.g_exc_unexpected_error THEN

717: WHEN fnd_api.g_exc_error THEN
718: ROLLBACK TO createplanoptions;
719: x_return_status := fnd_api.g_ret_sts_error;
720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
721: WHEN fnd_api.g_exc_unexpected_error THEN
722: ROLLBACK TO createplanoptions;
723: x_return_status := fnd_api.g_ret_sts_unexp_error;
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
725: WHEN OTHERS THEN

Line 723: x_return_status := fnd_api.g_ret_sts_unexp_error;

719: x_return_status := fnd_api.g_ret_sts_error;
720: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
721: WHEN fnd_api.g_exc_unexpected_error THEN
722: ROLLBACK TO createplanoptions;
723: x_return_status := fnd_api.g_ret_sts_unexp_error;
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
725: WHEN OTHERS THEN
726: ROLLBACK TO createplanoptions;
727: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 727: x_return_status := fnd_api.g_ret_sts_unexp_error;

723: x_return_status := fnd_api.g_ret_sts_unexp_error;
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
725: WHEN OTHERS THEN
726: ROLLBACK TO createplanoptions;
727: x_return_status := fnd_api.g_ret_sts_unexp_error;
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
731: END IF;

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

754: -- Standard start of API savepoint
755: SAVEPOINT create_opttrips_request;
756:
757: -- Standard call to check for call compatibility
758: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
759: RAISE fnd_api.g_exc_unexpected_error;
760: END IF;
761:
762: -- Initialize message list if p_init_msg_list is set to TRUE

Line 759: RAISE fnd_api.g_exc_unexpected_error;

755: SAVEPOINT create_opttrips_request;
756:
757: -- Standard call to check for call compatibility
758: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
759: RAISE fnd_api.g_exc_unexpected_error;
760: END IF;
761:
762: -- Initialize message list if p_init_msg_list is set to TRUE
763: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 763: IF fnd_api.to_boolean(p_init_msg_list) THEN

759: RAISE fnd_api.g_exc_unexpected_error;
760: END IF;
761:
762: -- Initialize message list if p_init_msg_list is set to TRUE
763: IF fnd_api.to_boolean(p_init_msg_list) THEN
764: fnd_msg_pub.initialize;
765: END IF;
766:
767: -- Initialize API return status to success

Line 768: x_return_status := fnd_api.g_ret_sts_success;

764: fnd_msg_pub.initialize;
765: END IF;
766:
767: -- Initialize API return status to success
768: x_return_status := fnd_api.g_ret_sts_success;
769:
770: -- Create the Parent Request
771: create_scheduler_request(
772: p_api_version => 1

Line 780: IF x_return_status = fnd_api.g_ret_sts_error THEN

776: , p_name => p_parent_req_name
777: , p_object_id => -1
778: , x_request_id => x_sched_request_id
779: );
780: IF x_return_status = fnd_api.g_ret_sts_error THEN
781: RAISE fnd_api.g_exc_error;
782: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;

Line 781: RAISE fnd_api.g_exc_error;

777: , p_object_id => -1
778: , x_request_id => x_sched_request_id
779: );
780: IF x_return_status = fnd_api.g_ret_sts_error THEN
781: RAISE fnd_api.g_exc_error;
782: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;
785:

Line 782: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

778: , x_request_id => x_sched_request_id
779: );
780: IF x_return_status = fnd_api.g_ret_sts_error THEN
781: RAISE fnd_api.g_exc_error;
782: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;
785:
786: /**

Line 783: RAISE fnd_api.g_exc_unexpected_error;

779: );
780: IF x_return_status = fnd_api.g_ret_sts_error THEN
781: RAISE fnd_api.g_exc_error;
782: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
783: RAISE fnd_api.g_exc_unexpected_error;
784: END IF;
785:
786: /**
787: * Create the Child Requests.

Line 835: IF fnd_api.to_boolean(p_commit) THEN

831: );
832: END IF;
833:
834: -- Standard check of p_commit
835: IF fnd_api.to_boolean(p_commit) THEN
836: COMMIT WORK;
837: END IF;
838: EXCEPTION
839: WHEN fnd_api.g_exc_error THEN

Line 839: WHEN fnd_api.g_exc_error THEN

835: IF fnd_api.to_boolean(p_commit) THEN
836: COMMIT WORK;
837: END IF;
838: EXCEPTION
839: WHEN fnd_api.g_exc_error THEN
840: ROLLBACK TO create_opttrips_request;
841: x_return_status := fnd_api.g_ret_sts_error;
842: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
843: WHEN fnd_api.g_exc_unexpected_error THEN

Line 841: x_return_status := fnd_api.g_ret_sts_error;

837: END IF;
838: EXCEPTION
839: WHEN fnd_api.g_exc_error THEN
840: ROLLBACK TO create_opttrips_request;
841: x_return_status := fnd_api.g_ret_sts_error;
842: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
843: WHEN fnd_api.g_exc_unexpected_error THEN
844: ROLLBACK TO create_opttrips_request;
845: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 843: WHEN fnd_api.g_exc_unexpected_error THEN

839: WHEN fnd_api.g_exc_error THEN
840: ROLLBACK TO create_opttrips_request;
841: x_return_status := fnd_api.g_ret_sts_error;
842: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
843: WHEN fnd_api.g_exc_unexpected_error THEN
844: ROLLBACK TO create_opttrips_request;
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
847: WHEN OTHERS THEN

Line 845: x_return_status := fnd_api.g_ret_sts_unexp_error;

841: x_return_status := fnd_api.g_ret_sts_error;
842: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
843: WHEN fnd_api.g_exc_unexpected_error THEN
844: ROLLBACK TO create_opttrips_request;
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
847: WHEN OTHERS THEN
848: ROLLBACK TO create_opttrips_request;
849: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 849: x_return_status := fnd_api.g_ret_sts_unexp_error;

845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
847: WHEN OTHERS THEN
848: ROLLBACK TO create_opttrips_request;
849: x_return_status := fnd_api.g_ret_sts_unexp_error;
850:
851: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
852: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;