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

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

96:
97: l_address_info c_address_info%ROWTYPE;
98: l_locus_valid VARCHAR2(6);
99: BEGIN
100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 101: RAISE fnd_api.g_exc_unexpected_error;

97: l_address_info c_address_info%ROWTYPE;
98: l_locus_valid VARCHAR2(6);
99: BEGIN
100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN
105: fnd_msg_pub.initialize;

Line 104: IF fnd_api.to_boolean(p_init_msg_list) THEN

100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: x_return_status := fnd_api.g_ret_sts_success;

Line 108: x_return_status := fnd_api.g_ret_sts_success;

104: IF fnd_api.to_boolean(p_init_msg_list) THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: x_return_status := fnd_api.g_ret_sts_success;
109:
110: OPEN c_address_info;
111: FETCH c_address_info INTO l_address_info;
112: CLOSE c_address_info;

Line 117: RAISE fnd_api.g_exc_error;

113:
114: -- The Task has no Address Information.
115: IF l_address_info.location_id IS NULL THEN
116: -- Need to throw with proper error message
117: RAISE fnd_api.g_exc_error;
118: END IF;
119:
120: IF l_address_info.geometry IS NULL THEN
121: l_locus_valid := 'FALSE';

Line 137: , p_init_msg_list => fnd_api.g_false

133: -- Geocode of the Task is invalid. Try to Geocode the Task
134: IF l_locus_valid = 'FALSE' THEN
135: csf_resource_address_pvt.resolve_address(
136: p_api_version => 1
137: , p_init_msg_list => fnd_api.g_false
138: , x_return_status => x_return_status
139: , x_msg_count => x_msg_count
140: , x_msg_data => x_msg_data
141: , p_location_id => l_address_info.location_id

Line 154: IF x_return_status = fnd_api.g_ret_sts_error THEN

150: , p_country => l_address_info.country
151: , p_country_code => l_address_info.country_code
152: , x_geometry => l_address_info.geometry
153: );
154: IF x_return_status = fnd_api.g_ret_sts_error THEN
155: RAISE fnd_api.g_exc_error;
156: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;

Line 155: RAISE fnd_api.g_exc_error;

151: , p_country_code => l_address_info.country_code
152: , x_geometry => l_address_info.geometry
153: );
154: IF x_return_status = fnd_api.g_ret_sts_error THEN
155: RAISE fnd_api.g_exc_error;
156: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;
159: END IF;

Line 156: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

152: , x_geometry => l_address_info.geometry
153: );
154: IF x_return_status = fnd_api.g_ret_sts_error THEN
155: RAISE fnd_api.g_exc_error;
156: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;
159: END IF;
160:

Line 157: RAISE fnd_api.g_exc_unexpected_error;

153: );
154: IF x_return_status = fnd_api.g_ret_sts_error THEN
155: RAISE fnd_api.g_exc_error;
156: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;
159: END IF;
160:
161: IF x_return_status = fnd_api.g_ret_sts_success AND l_address_info.geometry IS NOT NULL THEN

Line 161: IF x_return_status = fnd_api.g_ret_sts_success AND l_address_info.geometry IS NOT NULL THEN

157: RAISE fnd_api.g_exc_unexpected_error;
158: END IF;
159: END IF;
160:
161: IF x_return_status = fnd_api.g_ret_sts_success AND l_address_info.geometry IS NOT NULL THEN
162: x_locus_segment_id := csf_locus_pub.get_locus_segmentid(l_address_info.geometry);
163: x_locus_side := csf_locus_pub.get_locus_side(l_address_info.geometry);
164: x_locus_spot := csf_locus_pub.get_locus_spot(l_address_info.geometry);
165: x_locus_lat := csf_locus_pub.get_locus_lat(l_address_info.geometry);

Line 171: IF fnd_api.to_boolean(p_commit) THEN

167: x_should_call_lf := csf_locus_pub.should_call_lf(l_address_info.geometry);
168: x_location_id := l_address_info.location_id;
169: x_srid := csf_locus_pub.get_locus_srid(l_address_info.geometry);
170:
171: IF fnd_api.to_boolean(p_commit) THEN
172: COMMIT;
173: END IF;
174: END IF;
175: EXCEPTION

Line 176: WHEN fnd_api.g_exc_error THEN

172: COMMIT;
173: END IF;
174: END IF;
175: EXCEPTION
176: WHEN fnd_api.g_exc_error THEN
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 177: x_return_status := fnd_api.g_ret_sts_error;

173: END IF;
174: END IF;
175: EXCEPTION
176: WHEN fnd_api.g_exc_error THEN
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 179: WHEN fnd_api.g_exc_unexpected_error THEN

175: EXCEPTION
176: WHEN fnd_api.g_exc_error THEN
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 180: x_return_status := fnd_api.g_ret_sts_unexp_error;

176: WHEN fnd_api.g_exc_error THEN
177: x_return_status := fnd_api.g_ret_sts_error;
178: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 183: x_return_status := fnd_api.g_ret_sts_unexp_error;

179: WHEN fnd_api.g_exc_unexpected_error THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
186: END IF;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 304: , p_init_msg_list => fnd_api.g_false

300: , 'DD-MM-YYYY HH24:MI'
301: );
302:
303: hz_timezone_pub.get_time(p_api_version => 1
304: , p_init_msg_list => fnd_api.g_false
305: , x_return_status => l_return_status
306: , x_msg_count => l_msg_count
307: , x_msg_data => l_msg_data
308: , p_source_tz_id => p_timezone_id

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

383:
384: l_task_info c_task_info%ROWTYPE;
385:
386: BEGIN
387: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
388: RAISE fnd_api.g_exc_unexpected_error;
389: END IF;
390:
391: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 388: RAISE fnd_api.g_exc_unexpected_error;

384: l_task_info c_task_info%ROWTYPE;
385:
386: BEGIN
387: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
388: RAISE fnd_api.g_exc_unexpected_error;
389: END IF;
390:
391: IF fnd_api.to_boolean(p_init_msg_list) THEN
392: fnd_msg_pub.initialize;

Line 391: IF fnd_api.to_boolean(p_init_msg_list) THEN

387: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
388: RAISE fnd_api.g_exc_unexpected_error;
389: END IF;
390:
391: IF fnd_api.to_boolean(p_init_msg_list) THEN
392: fnd_msg_pub.initialize;
393: END IF;
394:
395: x_return_status := fnd_api.g_ret_sts_success;

Line 395: x_return_status := fnd_api.g_ret_sts_success;

391: IF fnd_api.to_boolean(p_init_msg_list) THEN
392: fnd_msg_pub.initialize;
393: END IF;
394:
395: x_return_status := fnd_api.g_ret_sts_success;
396:
397: -- Find the qualified resoucres for the task based on the given resoucer qualifiers
398:
399: OPEN c_task_info;

Line 412: , p_init_msg_list => fnd_api.g_false

408: csf_tasks_pub.validate_planned_dates(l_task_info.planned_start_date, l_task_info.planned_end_date);
409:
410: csf_resource_pub.get_resources_to_schedule(
411: p_api_version => 1
412: , p_init_msg_list => fnd_api.g_false
413: , x_return_status => x_return_status
414: , x_msg_count => x_msg_count
415: , x_msg_data => x_msg_data
416: , p_scheduling_mode => 'X' -- Auto Assign mode

Line 433: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

429: );
430:
431: -- Unless it is an Unexpected Error... continue even with
432: -- "No Resources Found" error. Java will do the proper error handling.
433: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
434: RAISE fnd_api.g_exc_unexpected_error;
435: END IF;
436:
437: -- Create Scheduler Search Request based on the given information.

Line 434: RAISE fnd_api.g_exc_unexpected_error;

430:
431: -- Unless it is an Unexpected Error... continue even with
432: -- "No Resources Found" error. Java will do the proper error handling.
433: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
434: RAISE fnd_api.g_exc_unexpected_error;
435: END IF;
436:
437: -- Create Scheduler Search Request based on the given information.
438: csf_requests_pvt.create_scheduler_request(

Line 440: , p_init_msg_list => fnd_api.g_false

436:
437: -- Create Scheduler Search Request based on the given information.
438: csf_requests_pvt.create_scheduler_request(
439: p_api_version => 1
440: , p_init_msg_list => fnd_api.g_false
441: , p_commit => fnd_api.g_false
442: , x_return_status => x_return_status
443: , x_msg_count => x_msg_count
444: , x_msg_data => x_msg_data

Line 441: , p_commit => fnd_api.g_false

437: -- Create Scheduler Search Request based on the given information.
438: csf_requests_pvt.create_scheduler_request(
439: p_api_version => 1
440: , p_init_msg_list => fnd_api.g_false
441: , p_commit => fnd_api.g_false
442: , x_return_status => x_return_status
443: , x_msg_count => x_msg_count
444: , x_msg_data => x_msg_data
445: , p_name => p_request_name

Line 454: IF x_return_status = fnd_api.g_ret_sts_error THEN

450: , p_disabled_access_hours_flag => p_disabled_access_hours_flag
451: , x_request_id => x_request_id
452: );
453:
454: IF x_return_status = fnd_api.g_ret_sts_error THEN
455: RAISE fnd_api.g_exc_error;
456: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;

Line 455: RAISE fnd_api.g_exc_error;

451: , x_request_id => x_request_id
452: );
453:
454: IF x_return_status = fnd_api.g_ret_sts_error THEN
455: RAISE fnd_api.g_exc_error;
456: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:

Line 456: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

452: );
453:
454: IF x_return_status = fnd_api.g_ret_sts_error THEN
455: RAISE fnd_api.g_exc_error;
456: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:
460: IF fnd_api.to_boolean(p_commit) THEN

Line 457: RAISE fnd_api.g_exc_unexpected_error;

453:
454: IF x_return_status = fnd_api.g_ret_sts_error THEN
455: RAISE fnd_api.g_exc_error;
456: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:
460: IF fnd_api.to_boolean(p_commit) THEN
461: COMMIT;

Line 460: IF fnd_api.to_boolean(p_commit) THEN

456: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:
460: IF fnd_api.to_boolean(p_commit) THEN
461: COMMIT;
462: END IF;
463:
464: EXCEPTION

Line 465: WHEN fnd_api.g_exc_error THEN

461: COMMIT;
462: END IF;
463:
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 466: x_return_status := fnd_api.g_ret_sts_error;

462: END IF;
463:
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 468: WHEN fnd_api.g_exc_unexpected_error THEN

464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN
472: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 469: x_return_status := fnd_api.g_ret_sts_unexp_error;

465: WHEN fnd_api.g_exc_error THEN
466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 472: x_return_status := fnd_api.g_ret_sts_unexp_error;

468: WHEN fnd_api.g_exc_unexpected_error THEN
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS THEN
472: x_return_status := fnd_api.g_ret_sts_unexp_error;
473: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
474: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
475: END IF;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

507: ) IS
508: l_api_version CONSTANT NUMBER := 1.0;
509: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SCHEDULE_OPTION_REQUEST';
510: BEGIN
511: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
512: RAISE fnd_api.g_exc_unexpected_error;
513: END IF;
514:
515: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 512: RAISE fnd_api.g_exc_unexpected_error;

508: l_api_version CONSTANT NUMBER := 1.0;
509: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SCHEDULE_OPTION_REQUEST';
510: BEGIN
511: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
512: RAISE fnd_api.g_exc_unexpected_error;
513: END IF;
514:
515: IF fnd_api.to_boolean(p_init_msg_list) THEN
516: fnd_msg_pub.initialize;

Line 515: IF fnd_api.to_boolean(p_init_msg_list) THEN

511: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
512: RAISE fnd_api.g_exc_unexpected_error;
513: END IF;
514:
515: IF fnd_api.to_boolean(p_init_msg_list) THEN
516: fnd_msg_pub.initialize;
517: END IF;
518:
519: x_return_status := fnd_api.g_ret_sts_success;

Line 519: x_return_status := fnd_api.g_ret_sts_success;

515: IF fnd_api.to_boolean(p_init_msg_list) THEN
516: fnd_msg_pub.initialize;
517: END IF;
518:
519: x_return_status := fnd_api.g_ret_sts_success;
520:
521: csf_requests_pvt.create_scheduler_request(
522: p_api_version => 1
523: , x_return_status => x_return_status

Line 533: IF x_return_status = fnd_api.g_ret_sts_error THEN

529: , p_set_plan_task_confirmed => p_set_plan_task_confirmed
530: , x_request_id => x_request_id
531: );
532:
533: IF x_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;

Line 534: RAISE fnd_api.g_exc_error;

530: , x_request_id => x_request_id
531: );
532:
533: IF x_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:

Line 535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

531: );
532:
533: IF x_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539: IF fnd_api.to_boolean(p_commit) THEN

Line 536: RAISE fnd_api.g_exc_unexpected_error;

532:
533: IF x_return_status = fnd_api.g_ret_sts_error THEN
534: RAISE fnd_api.g_exc_error;
535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539: IF fnd_api.to_boolean(p_commit) THEN
540: COMMIT;

Line 539: IF fnd_api.to_boolean(p_commit) THEN

535: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
536: RAISE fnd_api.g_exc_unexpected_error;
537: END IF;
538:
539: IF fnd_api.to_boolean(p_commit) THEN
540: COMMIT;
541: END IF;
542:
543: EXCEPTION

Line 544: WHEN fnd_api.g_exc_error THEN

540: COMMIT;
541: END IF;
542:
543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 545: x_return_status := fnd_api.g_ret_sts_error;

541: END IF;
542:
543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 547: WHEN fnd_api.g_exc_unexpected_error THEN

543: EXCEPTION
544: WHEN fnd_api.g_exc_error THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 548: x_return_status := fnd_api.g_ret_sts_unexp_error;

544: WHEN fnd_api.g_exc_error THEN
545: x_return_status := fnd_api.g_ret_sts_error;
546: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 551: x_return_status := fnd_api.g_ret_sts_unexp_error;

547: WHEN fnd_api.g_exc_unexpected_error THEN
548: x_return_status := fnd_api.g_ret_sts_unexp_error;
549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error;
552: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
553: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
554: END IF;
555: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 563: , p_find_resources IN VARCHAR2 DEFAULT fnd_api.g_true

559: x_return_status OUT NOCOPY VARCHAR2
560: , x_msg_count OUT NOCOPY NUMBER
561: , x_msg_data OUT NOCOPY VARCHAR2
562: , p_task_tbl IN csf_requests_pvt.object_tbl_type
563: , p_find_resources IN VARCHAR2 DEFAULT fnd_api.g_true
564: , x_request_id OUT NOCOPY NUMBER
565: ) IS
566: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AUTO_REQUEST';
567:

Line 583: x_return_status := fnd_api.g_ret_sts_success;

579: WHERE t.task_id = p_task_id;
580:
581: l_task_info c_task_info%ROWTYPE;
582: BEGIN
583: x_return_status := fnd_api.g_ret_sts_success;
584:
585:
586: IF p_task_tbl IS NULL OR p_task_tbl.COUNT <= 0 THEN
587: x_request_id := -1;

Line 596: , p_init_msg_list => fnd_api.g_true

592: -- Create the SearchAndScheduleAuto Request which will serve as
593: -- the Parent Request for the subsequents requests created for each Task.
594: csf_requests_pvt.create_scheduler_request(
595: p_api_version => 1
596: , p_init_msg_list => fnd_api.g_true
597: , p_commit => fnd_api.g_false
598: , x_return_status => x_return_status
599: , x_msg_count => x_msg_count
600: , x_msg_data => x_msg_data

Line 597: , p_commit => fnd_api.g_false

593: -- the Parent Request for the subsequents requests created for each Task.
594: csf_requests_pvt.create_scheduler_request(
595: p_api_version => 1
596: , p_init_msg_list => fnd_api.g_true
597: , p_commit => fnd_api.g_false
598: , x_return_status => x_return_status
599: , x_msg_count => x_msg_count
600: , x_msg_data => x_msg_data
601: , p_name => 'SearchAndScheduleAuto'

Line 606: IF x_return_status <> fnd_api.g_ret_sts_success THEN

602: , p_object_id => -1
603: , x_request_id => x_request_id
604: );
605:
606: IF x_return_status <> fnd_api.g_ret_sts_success THEN
607: RAISE fnd_api.g_exc_error;
608: END IF;
609:
610:

Line 607: RAISE fnd_api.g_exc_error;

603: , x_request_id => x_request_id
604: );
605:
606: IF x_return_status <> fnd_api.g_ret_sts_success THEN
607: RAISE fnd_api.g_exc_error;
608: END IF;
609:
610:
611: -- For each task, create a SearchAndSchedule Request with Parent

Line 615: IF p_find_resources = fnd_api.g_true THEN

611: -- For each task, create a SearchAndSchedule Request with Parent
612: -- Request being the Request created above.
613: i := p_task_tbl.FIRST;
614: WHILE i IS NOT NULL LOOP
615: IF p_find_resources = fnd_api.g_true THEN
616:
617: OPEN c_task_info(p_task_tbl(i));
618: FETCH c_task_info INTO l_task_info;
619: CLOSE c_task_info;

Line 627: , p_init_msg_list => fnd_api.g_false

623:
624: -- Get the Resources for this Task.
625: csf_resource_pub.get_resources_to_schedule(
626: p_api_version => 1
627: , p_init_msg_list => fnd_api.g_false
628: , x_return_status => x_return_status
629: , x_msg_count => x_msg_count
630: , x_msg_data => x_msg_data
631: , p_scheduling_mode => 'X' -- Auto Assign mode

Line 646: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

642: );
643:
644: -- Unless it is an Unexpected Error... continue even with
645: -- "No Resources Found" error. Java will do the proper error handling.
646: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: END IF;
650:

Line 647: RAISE fnd_api.g_exc_unexpected_error;

643:
644: -- Unless it is an Unexpected Error... continue even with
645: -- "No Resources Found" error. Java will do the proper error handling.
646: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: END IF;
650:
651: csf_requests_pvt.create_scheduler_request(

Line 653: , p_init_msg_list => fnd_api.g_false

649: END IF;
650:
651: csf_requests_pvt.create_scheduler_request(
652: p_api_version => 1
653: , p_init_msg_list => fnd_api.g_false
654: , p_commit => fnd_api.g_false
655: , x_return_status => x_return_status
656: , x_msg_count => x_msg_count
657: , x_msg_data => x_msg_data

Line 654: , p_commit => fnd_api.g_false

650:
651: csf_requests_pvt.create_scheduler_request(
652: p_api_version => 1
653: , p_init_msg_list => fnd_api.g_false
654: , p_commit => fnd_api.g_false
655: , x_return_status => x_return_status
656: , x_msg_count => x_msg_count
657: , x_msg_data => x_msg_data
658: , p_name => 'SearchAndSchedule'

Line 670: WHEN fnd_api.g_exc_error THEN

666: i := p_task_tbl.NEXT(i);
667:
668: END LOOP;
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 671: x_return_status := fnd_api.g_ret_sts_error;

667:
668: END LOOP;
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 673: WHEN fnd_api.g_exc_unexpected_error THEN

669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 674: x_return_status := fnd_api.g_ret_sts_unexp_error;

670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 677: x_return_status := fnd_api.g_ret_sts_unexp_error;

673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
679: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
680: END IF;
681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

724:
725: BEGIN
726: SAVEPOINT fill_request_resources;
727:
728: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
729: RAISE fnd_api.g_exc_unexpected_error;
730: END IF;
731:
732: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 729: RAISE fnd_api.g_exc_unexpected_error;

725: BEGIN
726: SAVEPOINT fill_request_resources;
727:
728: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
729: RAISE fnd_api.g_exc_unexpected_error;
730: END IF;
731:
732: IF fnd_api.to_boolean(p_init_msg_list) THEN
733: fnd_msg_pub.initialize;

Line 732: IF fnd_api.to_boolean(p_init_msg_list) THEN

728: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
729: RAISE fnd_api.g_exc_unexpected_error;
730: END IF;
731:
732: IF fnd_api.to_boolean(p_init_msg_list) THEN
733: fnd_msg_pub.initialize;
734: END IF;
735:
736: x_return_status := fnd_api.g_ret_sts_success;

Line 736: x_return_status := fnd_api.g_ret_sts_success;

732: IF fnd_api.to_boolean(p_init_msg_list) THEN
733: fnd_msg_pub.initialize;
734: END IF;
735:
736: x_return_status := fnd_api.g_ret_sts_success;
737:
738: FOR l_task_rec IN c_request_task_list LOOP
739:
740: -- Get the Qualified Resources for this Task.

Line 747: , p_init_msg_list => fnd_api.g_false

743:
744: -- Get the Resources for this Task.
745: csf_resource_pub.get_resources_to_schedule(
746: p_api_version => 1
747: , p_init_msg_list => fnd_api.g_false
748: , x_return_status => x_return_status
749: , x_msg_count => x_msg_count
750: , x_msg_data => x_msg_data
751: , p_scheduling_mode => 'X' -- Auto Assign mode

Line 766: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

762: );
763:
764: -- Unless it is an Unexpected Error... continue even with
765: -- "No Resources Found" error. Java will do the proper error handling.
766: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
767: RAISE fnd_api.g_exc_unexpected_error;
768: END IF;
769:
770: csf_requests_pvt.create_resource_results(

Line 767: RAISE fnd_api.g_exc_unexpected_error;

763:
764: -- Unless it is an Unexpected Error... continue even with
765: -- "No Resources Found" error. Java will do the proper error handling.
766: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
767: RAISE fnd_api.g_exc_unexpected_error;
768: END IF;
769:
770: csf_requests_pvt.create_resource_results(
771: p_api_version => 1

Line 772: , p_init_msg_list => fnd_api.g_false

768: END IF;
769:
770: csf_requests_pvt.create_resource_results(
771: p_api_version => 1
772: , p_init_msg_list => fnd_api.g_false
773: , p_commit => fnd_api.g_false
774: , x_return_status => x_return_status
775: , x_msg_count => x_msg_count
776: , x_msg_data => x_msg_data

Line 773: , p_commit => fnd_api.g_false

769:
770: csf_requests_pvt.create_resource_results(
771: p_api_version => 1
772: , p_init_msg_list => fnd_api.g_false
773: , p_commit => fnd_api.g_false
774: , x_return_status => x_return_status
775: , x_msg_count => x_msg_count
776: , x_msg_data => x_msg_data
777: , p_request_task_id => l_task_rec.request_task_id

Line 782: IF fnd_api.to_boolean(p_commit) THEN

778: , p_resource_tbl => l_res_tbl
779: );
780: END LOOP;
781:
782: IF fnd_api.to_boolean(p_commit) THEN
783: COMMIT WORK;
784: END IF;
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN

Line 786: WHEN fnd_api.g_exc_error THEN

782: IF fnd_api.to_boolean(p_commit) THEN
783: COMMIT WORK;
784: END IF;
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: ROLLBACK TO fill_request_resources;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
790: WHEN fnd_api.g_exc_unexpected_error THEN

Line 788: x_return_status := fnd_api.g_ret_sts_error;

784: END IF;
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: ROLLBACK TO fill_request_resources;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
790: WHEN fnd_api.g_exc_unexpected_error THEN
791: ROLLBACK TO fill_request_resources;
792: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 790: WHEN fnd_api.g_exc_unexpected_error THEN

786: WHEN fnd_api.g_exc_error THEN
787: ROLLBACK TO fill_request_resources;
788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
790: WHEN fnd_api.g_exc_unexpected_error THEN
791: ROLLBACK TO fill_request_resources;
792: x_return_status := fnd_api.g_ret_sts_unexp_error;
793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
794: WHEN OTHERS THEN

Line 792: x_return_status := fnd_api.g_ret_sts_unexp_error;

788: x_return_status := fnd_api.g_ret_sts_error;
789: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
790: WHEN fnd_api.g_exc_unexpected_error THEN
791: ROLLBACK TO fill_request_resources;
792: x_return_status := fnd_api.g_ret_sts_unexp_error;
793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
794: WHEN OTHERS THEN
795: x_return_status := fnd_api.g_ret_sts_unexp_error;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 795: x_return_status := fnd_api.g_ret_sts_unexp_error;

791: ROLLBACK TO fill_request_resources;
792: x_return_status := fnd_api.g_ret_sts_unexp_error;
793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
794: WHEN OTHERS THEN
795: x_return_status := fnd_api.g_ret_sts_unexp_error;
796: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
797: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
798: END IF;
799: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

815: l_api_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
816: BEGIN
817: SAVEPOINT search_and_schedule_auto_pub;
818:
819: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
820: RAISE fnd_api.g_exc_unexpected_error;
821: END IF;
822:
823: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 820: RAISE fnd_api.g_exc_unexpected_error;

816: BEGIN
817: SAVEPOINT search_and_schedule_auto_pub;
818:
819: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
820: RAISE fnd_api.g_exc_unexpected_error;
821: END IF;
822:
823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;

Line 823: IF fnd_api.to_boolean(p_init_msg_list) THEN

819: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
820: RAISE fnd_api.g_exc_unexpected_error;
821: END IF;
822:
823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: x_return_status := fnd_api.g_ret_sts_success;

Line 827: x_return_status := fnd_api.g_ret_sts_success;

823: IF fnd_api.to_boolean(p_init_msg_list) THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: x_return_status := fnd_api.g_ret_sts_success;
828:
829: IF NOT p_task_tbl.LAST > 0 THEN
830: IF NOT valid_argument(NULL, 'task_tbl', l_api_name) THEN
831: RAISE fnd_api.g_exc_error;

Line 831: RAISE fnd_api.g_exc_error;

827: x_return_status := fnd_api.g_ret_sts_success;
828:
829: IF NOT p_task_tbl.LAST > 0 THEN
830: IF NOT valid_argument(NULL, 'task_tbl', l_api_name) THEN
831: RAISE fnd_api.g_exc_error;
832: END IF;
833: END IF;
834:
835: -- Create the SearchAndScheduleAuto Request.

Line 841: , p_find_resources => fnd_api.g_false

837: x_return_status => x_return_status
838: , x_msg_count => x_msg_count
839: , x_msg_data => x_msg_data
840: , p_task_tbl => p_task_tbl
841: , p_find_resources => fnd_api.g_false
842: , x_request_id => x_sched_request_id
843: );
844:
845: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 845: IF x_return_status = fnd_api.g_ret_sts_error THEN

841: , p_find_resources => fnd_api.g_false
842: , x_request_id => x_sched_request_id
843: );
844:
845: IF x_return_status = fnd_api.g_ret_sts_error THEN
846: RAISE fnd_api.g_exc_error;
847: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
848: RAISE fnd_api.g_exc_unexpected_error;
849: END IF;

Line 846: RAISE fnd_api.g_exc_error;

842: , x_request_id => x_sched_request_id
843: );
844:
845: IF x_return_status = fnd_api.g_ret_sts_error THEN
846: RAISE fnd_api.g_exc_error;
847: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
848: RAISE fnd_api.g_exc_unexpected_error;
849: END IF;
850:

Line 847: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

843: );
844:
845: IF x_return_status = fnd_api.g_ret_sts_error THEN
846: RAISE fnd_api.g_exc_error;
847: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
848: RAISE fnd_api.g_exc_unexpected_error;
849: END IF;
850:
851: -- Submit the Scheduler concurrent program

Line 848: RAISE fnd_api.g_exc_unexpected_error;

844:
845: IF x_return_status = fnd_api.g_ret_sts_error THEN
846: RAISE fnd_api.g_exc_error;
847: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
848: RAISE fnd_api.g_exc_unexpected_error;
849: END IF;
850:
851: -- Submit the Scheduler concurrent program
852: x_conc_request_id := fnd_request.submit_request(

Line 862: RAISE fnd_api.g_exc_error;

858: );
859:
860: IF x_conc_request_id = 0 THEN
861: -- FND_REQUEST.SUBMIT_REQUEST should have populated the Message Stack.
862: RAISE fnd_api.g_exc_error;
863: END IF;
864:
865: IF fnd_api.to_boolean(p_commit) THEN
866: COMMIT WORK;

Line 865: IF fnd_api.to_boolean(p_commit) THEN

861: -- FND_REQUEST.SUBMIT_REQUEST should have populated the Message Stack.
862: RAISE fnd_api.g_exc_error;
863: END IF;
864:
865: IF fnd_api.to_boolean(p_commit) THEN
866: COMMIT WORK;
867: END IF;
868: EXCEPTION
869: WHEN fnd_api.g_exc_error THEN

Line 869: WHEN fnd_api.g_exc_error THEN

865: IF fnd_api.to_boolean(p_commit) THEN
866: COMMIT WORK;
867: END IF;
868: EXCEPTION
869: WHEN fnd_api.g_exc_error THEN
870: ROLLBACK TO search_and_schedule_auto_pub;
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
873: WHEN fnd_api.g_exc_unexpected_error THEN

Line 871: x_return_status := fnd_api.g_ret_sts_error;

867: END IF;
868: EXCEPTION
869: WHEN fnd_api.g_exc_error THEN
870: ROLLBACK TO search_and_schedule_auto_pub;
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
873: WHEN fnd_api.g_exc_unexpected_error THEN
874: ROLLBACK TO search_and_schedule_auto_pub;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 873: WHEN fnd_api.g_exc_unexpected_error THEN

869: WHEN fnd_api.g_exc_error THEN
870: ROLLBACK TO search_and_schedule_auto_pub;
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
873: WHEN fnd_api.g_exc_unexpected_error THEN
874: ROLLBACK TO search_and_schedule_auto_pub;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
877: WHEN OTHERS THEN

Line 875: x_return_status := fnd_api.g_ret_sts_unexp_error;

871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
873: WHEN fnd_api.g_exc_unexpected_error THEN
874: ROLLBACK TO search_and_schedule_auto_pub;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
877: WHEN OTHERS THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 878: x_return_status := fnd_api.g_ret_sts_unexp_error;

874: ROLLBACK TO search_and_schedule_auto_pub;
875: x_return_status := fnd_api.g_ret_sts_unexp_error;
876: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
877: WHEN OTHERS THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
880: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
881: END IF;
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

902: l_task_tbl csf_requests_pvt.object_tbl_type;
903: BEGIN
904: SAVEPOINT create_auto_request_pub;
905:
906: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
907: RAISE fnd_api.g_exc_error;
908: END IF;
909:
910: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 907: RAISE fnd_api.g_exc_error;

903: BEGIN
904: SAVEPOINT create_auto_request_pub;
905:
906: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
907: RAISE fnd_api.g_exc_error;
908: END IF;
909:
910: IF fnd_api.to_boolean(p_init_msg_list) THEN
911: fnd_msg_pub.initialize;

Line 910: IF fnd_api.to_boolean(p_init_msg_list) THEN

906: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
907: RAISE fnd_api.g_exc_error;
908: END IF;
909:
910: IF fnd_api.to_boolean(p_init_msg_list) THEN
911: fnd_msg_pub.initialize;
912: END IF;
913:
914: IF NOT valid_argument(p_query_id, 'query_id', l_api_name) THEN

Line 915: RAISE fnd_api.g_exc_error;

911: fnd_msg_pub.initialize;
912: END IF;
913:
914: IF NOT valid_argument(p_query_id, 'query_id', l_api_name) THEN
915: RAISE fnd_api.g_exc_error;
916: END IF;
917:
918: -- Get the WHERE CLAUSE for the Given Query ID.
919:

Line 945: IF x_return_status = fnd_api.g_ret_sts_error THEN

941: , p_task_tbl => l_task_tbl
942: , x_request_id => x_sched_request_id
943: );
944:
945: IF x_return_status = fnd_api.g_ret_sts_error THEN
946: RAISE fnd_api.g_exc_error;
947: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
948: RAISE fnd_api.g_exc_unexpected_error;
949: END IF;

Line 946: RAISE fnd_api.g_exc_error;

942: , x_request_id => x_sched_request_id
943: );
944:
945: IF x_return_status = fnd_api.g_ret_sts_error THEN
946: RAISE fnd_api.g_exc_error;
947: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
948: RAISE fnd_api.g_exc_unexpected_error;
949: END IF;
950:

Line 947: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

943: );
944:
945: IF x_return_status = fnd_api.g_ret_sts_error THEN
946: RAISE fnd_api.g_exc_error;
947: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
948: RAISE fnd_api.g_exc_unexpected_error;
949: END IF;
950:
951: IF fnd_api.to_boolean(p_commit) THEN

Line 948: RAISE fnd_api.g_exc_unexpected_error;

944:
945: IF x_return_status = fnd_api.g_ret_sts_error THEN
946: RAISE fnd_api.g_exc_error;
947: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
948: RAISE fnd_api.g_exc_unexpected_error;
949: END IF;
950:
951: IF fnd_api.to_boolean(p_commit) THEN
952: COMMIT WORK;

Line 951: IF fnd_api.to_boolean(p_commit) THEN

947: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
948: RAISE fnd_api.g_exc_unexpected_error;
949: END IF;
950:
951: IF fnd_api.to_boolean(p_commit) THEN
952: COMMIT WORK;
953: END IF;
954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN

Line 955: WHEN fnd_api.g_exc_error THEN

951: IF fnd_api.to_boolean(p_commit) THEN
952: COMMIT WORK;
953: END IF;
954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN
956: ROLLBACK TO create_auto_request_pub;
957: x_return_status := fnd_api.g_ret_sts_error;
958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
959: WHEN fnd_api.g_exc_unexpected_error THEN

Line 957: x_return_status := fnd_api.g_ret_sts_error;

953: END IF;
954: EXCEPTION
955: WHEN fnd_api.g_exc_error THEN
956: ROLLBACK TO create_auto_request_pub;
957: x_return_status := fnd_api.g_ret_sts_error;
958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
959: WHEN fnd_api.g_exc_unexpected_error THEN
960: ROLLBACK TO create_auto_request_pub;
961: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 959: WHEN fnd_api.g_exc_unexpected_error THEN

955: WHEN fnd_api.g_exc_error THEN
956: ROLLBACK TO create_auto_request_pub;
957: x_return_status := fnd_api.g_ret_sts_error;
958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
959: WHEN fnd_api.g_exc_unexpected_error THEN
960: ROLLBACK TO create_auto_request_pub;
961: x_return_status := fnd_api.g_ret_sts_unexp_error;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: WHEN OTHERS THEN

Line 961: x_return_status := fnd_api.g_ret_sts_unexp_error;

957: x_return_status := fnd_api.g_ret_sts_error;
958: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
959: WHEN fnd_api.g_exc_unexpected_error THEN
960: ROLLBACK TO create_auto_request_pub;
961: x_return_status := fnd_api.g_ret_sts_unexp_error;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 964: x_return_status := fnd_api.g_ret_sts_unexp_error;

960: ROLLBACK TO create_auto_request_pub;
961: x_return_status := fnd_api.g_ret_sts_unexp_error;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
963: WHEN OTHERS THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
966: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
967: END IF;
968: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

996: l_resource_tbl csf_requests_pvt.resource_tbl_type;
997: BEGIN
998: SAVEPOINT create_opt_request_pub;
999:
1000: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:
1004: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1001: RAISE fnd_api.g_exc_error;

997: BEGIN
998: SAVEPOINT create_opt_request_pub;
999:
1000: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:
1004: IF fnd_api.to_boolean(p_init_msg_list) THEN
1005: fnd_msg_pub.initialize;

Line 1004: IF fnd_api.to_boolean(p_init_msg_list) THEN

1000: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1001: RAISE fnd_api.g_exc_error;
1002: END IF;
1003:
1004: IF fnd_api.to_boolean(p_init_msg_list) THEN
1005: fnd_msg_pub.initialize;
1006: END IF;
1007:
1008: OPEN c_resources;

Line 1034: IF x_return_status = fnd_api.g_ret_sts_error THEN

1030: , p_resource_tbl => l_resource_tbl
1031: , x_request_id => x_sched_request_id
1032: );
1033:
1034: IF x_return_status = fnd_api.g_ret_sts_error THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;

Line 1035: RAISE fnd_api.g_exc_error;

1031: , x_request_id => x_sched_request_id
1032: );
1033:
1034: IF x_return_status = fnd_api.g_ret_sts_error THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039:

Line 1036: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1032: );
1033:
1034: IF x_return_status = fnd_api.g_ret_sts_error THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039:
1040: IF fnd_api.to_boolean(p_commit) THEN

Line 1037: RAISE fnd_api.g_exc_unexpected_error;

1033:
1034: IF x_return_status = fnd_api.g_ret_sts_error THEN
1035: RAISE fnd_api.g_exc_error;
1036: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039:
1040: IF fnd_api.to_boolean(p_commit) THEN
1041: COMMIT WORK;

Line 1040: IF fnd_api.to_boolean(p_commit) THEN

1036: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: END IF;
1039:
1040: IF fnd_api.to_boolean(p_commit) THEN
1041: COMMIT WORK;
1042: END IF;
1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN

Line 1044: WHEN fnd_api.g_exc_error THEN

1040: IF fnd_api.to_boolean(p_commit) THEN
1041: COMMIT WORK;
1042: END IF;
1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: ROLLBACK TO create_opt_request_pub;
1046: x_return_status := fnd_api.g_ret_sts_error;
1047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1048: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1046: x_return_status := fnd_api.g_ret_sts_error;

1042: END IF;
1043: EXCEPTION
1044: WHEN fnd_api.g_exc_error THEN
1045: ROLLBACK TO create_opt_request_pub;
1046: x_return_status := fnd_api.g_ret_sts_error;
1047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1048: WHEN fnd_api.g_exc_unexpected_error THEN
1049: ROLLBACK TO create_opt_request_pub;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1048: WHEN fnd_api.g_exc_unexpected_error THEN

1044: WHEN fnd_api.g_exc_error THEN
1045: ROLLBACK TO create_opt_request_pub;
1046: x_return_status := fnd_api.g_ret_sts_error;
1047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1048: WHEN fnd_api.g_exc_unexpected_error THEN
1049: ROLLBACK TO create_opt_request_pub;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: WHEN OTHERS THEN

Line 1050: x_return_status := fnd_api.g_ret_sts_unexp_error;

1046: x_return_status := fnd_api.g_ret_sts_error;
1047: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1048: WHEN fnd_api.g_exc_unexpected_error THEN
1049: ROLLBACK TO create_opt_request_pub;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: WHEN OTHERS THEN
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1053: x_return_status := fnd_api.g_ret_sts_unexp_error;

1049: ROLLBACK TO create_opt_request_pub;
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: WHEN OTHERS THEN
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1055: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1056: END IF;
1057: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1087: l_start_date DATE;
1088: l_end_date DATE;
1089:
1090: BEGIN
1091: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094:
1095: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1092: RAISE fnd_api.g_exc_error;

1088: l_end_date DATE;
1089:
1090: BEGIN
1091: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094:
1095: IF fnd_api.to_boolean(p_init_msg_list) THEN
1096: fnd_msg_pub.initialize;

Line 1095: IF fnd_api.to_boolean(p_init_msg_list) THEN

1091: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094:
1095: IF fnd_api.to_boolean(p_init_msg_list) THEN
1096: fnd_msg_pub.initialize;
1097: END IF;
1098:
1099: x_return_status := fnd_api.g_ret_sts_success;

Line 1099: x_return_status := fnd_api.g_ret_sts_success;

1095: IF fnd_api.to_boolean(p_init_msg_list) THEN
1096: fnd_msg_pub.initialize;
1097: END IF;
1098:
1099: x_return_status := fnd_api.g_ret_sts_success;
1100:
1101: l_task_res_tbl := csf_resource_tbl();
1102: x_task_resources_tbl := csf_task_resources_tbl_type();
1103:

Line 1119: , p_init_msg_list => fnd_api.g_false

1115:
1116: -- Get the Resources for this Task.
1117: csf_resource_pub.get_resources_to_schedule(
1118: p_api_version => 1.0
1119: , p_init_msg_list => fnd_api.g_false
1120: , x_return_status => x_return_status
1121: , x_msg_count => x_msg_count
1122: , x_msg_data => x_msg_data
1123: , p_scheduling_mode => 'O' -- Optimizer mode

Line 1163: WHEN fnd_api.g_exc_error THEN

1159: x_task_resources_tbl.EXTEND();
1160: x_task_resources_tbl(i) := l_task_res_tbl;
1161: END LOOP;
1162: EXCEPTION
1163: WHEN fnd_api.g_exc_error THEN
1164: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1164: x_return_status := fnd_api.g_ret_sts_error;

1160: x_task_resources_tbl(i) := l_task_res_tbl;
1161: END LOOP;
1162: EXCEPTION
1163: WHEN fnd_api.g_exc_error THEN
1164: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1166: WHEN fnd_api.g_exc_unexpected_error THEN

1162: EXCEPTION
1163: WHEN fnd_api.g_exc_error THEN
1164: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1167: x_return_status := fnd_api.g_ret_sts_unexp_error;

1163: WHEN fnd_api.g_exc_error THEN
1164: x_return_status := fnd_api.g_ret_sts_error;
1165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1170: x_return_status := fnd_api.g_ret_sts_unexp_error;

1166: WHEN fnd_api.g_exc_unexpected_error THEN
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1169: WHEN OTHERS THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1172: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1173: END IF;
1174: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1290: FOR UPDATE OF t.task_id, ta.task_assignment_id, ah.access_hour_id, oc.object_capacity_id NOWAIT;
1291:
1292: l_objects_locked BOOLEAN;
1293: BEGIN
1294: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1295: RAISE fnd_api.g_exc_error;
1296: END IF;
1297:
1298: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1295: RAISE fnd_api.g_exc_error;

1291:
1292: l_objects_locked BOOLEAN;
1293: BEGIN
1294: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1295: RAISE fnd_api.g_exc_error;
1296: END IF;
1297:
1298: IF fnd_api.to_boolean(p_init_msg_list) THEN
1299: fnd_msg_pub.initialize;

Line 1298: IF fnd_api.to_boolean(p_init_msg_list) THEN

1294: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1295: RAISE fnd_api.g_exc_error;
1296: END IF;
1297:
1298: IF fnd_api.to_boolean(p_init_msg_list) THEN
1299: fnd_msg_pub.initialize;
1300: END IF;
1301:
1302: x_return_status := fnd_api.g_ret_sts_success;

Line 1302: x_return_status := fnd_api.g_ret_sts_success;

1298: IF fnd_api.to_boolean(p_init_msg_list) THEN
1299: fnd_msg_pub.initialize;
1300: END IF;
1301:
1302: x_return_status := fnd_api.g_ret_sts_success;
1303:
1304: l_objects_locked := FALSE;
1305:
1306: FOR i IN 1..3 LOOP

Line 1326: RAISE fnd_api.g_exc_error;

1322:
1323: IF NOT l_objects_locked THEN
1324: fnd_message.set_name ('CSR', 'CSR_LOCKING_RES_TRIPS_FAILED');
1325: fnd_msg_pub.ADD;
1326: RAISE fnd_api.g_exc_error;
1327: END IF;
1328:
1329: EXCEPTION
1330: WHEN fnd_api.g_exc_error THEN

Line 1330: WHEN fnd_api.g_exc_error THEN

1326: RAISE fnd_api.g_exc_error;
1327: END IF;
1328:
1329: EXCEPTION
1330: WHEN fnd_api.g_exc_error THEN
1331: x_return_status := fnd_api.g_ret_sts_error;
1332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1333: WHEN OTHERS THEN
1334: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1331: x_return_status := fnd_api.g_ret_sts_error;

1327: END IF;
1328:
1329: EXCEPTION
1330: WHEN fnd_api.g_exc_error THEN
1331: x_return_status := fnd_api.g_ret_sts_error;
1332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1333: WHEN OTHERS THEN
1334: x_return_status := fnd_api.g_ret_sts_unexp_error;
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1334: x_return_status := fnd_api.g_ret_sts_unexp_error;

1330: WHEN fnd_api.g_exc_error THEN
1331: x_return_status := fnd_api.g_ret_sts_error;
1332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1333: WHEN OTHERS THEN
1334: x_return_status := fnd_api.g_ret_sts_unexp_error;
1335: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1336: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1337: END IF;
1338: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);