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

Line 158: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

154:
155: BEGIN
156:
157: -- check version compatibility
158: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
159: l_api_name, g_pkg_name)
160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;

Line 161: RAISE fnd_api.g_exc_unexpected_error;

157: -- check version compatibility
158: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
159: l_api_name, g_pkg_name)
160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163: -- initialize message stack if required
164: IF fnd_api.to_boolean(p_init_msg_list)
165: THEN

Line 164: IF fnd_api.to_boolean(p_init_msg_list)

160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163: -- initialize message stack if required
164: IF fnd_api.to_boolean(p_init_msg_list)
165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168: -- initialize return status

Line 169: x_return_status := fnd_api.g_ret_sts_success;

165: THEN
166: fnd_msg_pub.initialize;
167: END IF;
168: -- initialize return status
169: x_return_status := fnd_api.g_ret_sts_success;
170:
171: -- call current shift api to get resource shifts
172: JTF_CALENDAR_PUB_24HR.GET_RESOURCE_SHIFTS
173: ( p_api_version => 1.0

Line 183: IF l_return_status <> fnd_api.g_ret_sts_success

179: , x_msg_count => l_msg_count
180: , x_msg_data => l_msg_data
181: , x_shift => l_shift
182: );
183: IF l_return_status <> fnd_api.g_ret_sts_success
184: THEN
185: IF l_return_status = fnd_api.g_ret_sts_error
186: THEN
187: RAISE fnd_api.g_exc_error;

Line 185: IF l_return_status = fnd_api.g_ret_sts_error

181: , x_shift => l_shift
182: );
183: IF l_return_status <> fnd_api.g_ret_sts_success
184: THEN
185: IF l_return_status = fnd_api.g_ret_sts_error
186: THEN
187: RAISE fnd_api.g_exc_error;
188: ELSE
189: RAISE fnd_api.g_exc_unexpected_error;

Line 187: RAISE fnd_api.g_exc_error;

183: IF l_return_status <> fnd_api.g_ret_sts_success
184: THEN
185: IF l_return_status = fnd_api.g_ret_sts_error
186: THEN
187: RAISE fnd_api.g_exc_error;
188: ELSE
189: RAISE fnd_api.g_exc_unexpected_error;
190: END IF;
191: END IF;

Line 189: RAISE fnd_api.g_exc_unexpected_error;

185: IF l_return_status = fnd_api.g_ret_sts_error
186: THEN
187: RAISE fnd_api.g_exc_error;
188: ELSE
189: RAISE fnd_api.g_exc_unexpected_error;
190: END IF;
191: END IF;
192:
193: l_tbl_count := 0;

Line 194: l_Populate_ID := fnd_api.to_boolean(p_Populate_ID);

190: END IF;
191: END IF;
192:
193: l_tbl_count := 0;
194: l_Populate_ID := fnd_api.to_boolean(p_Populate_ID);
195: l_idx := l_shift.FIRST;
196:
197: WHILE (l_idx IS NOT NULL)
198: LOOP

Line 224: IF fnd_api.to_boolean(p_Fetch_Tasks)

220:
221: -- Fetch tasks now
222: l_tbl_count := 0;
223: l_idx := x_object_capacity.FIRST;
224: IF fnd_api.to_boolean(p_Fetch_Tasks)
225: THEN
226: -- to take care of any boundry condition fetch tasks with -+ 1 days of the start and end
227: FOR ref_tasks IN c_tasks(p_object_type,p_object_id,p_start_date-1,p_end_date+1)
228: LOOP

Line 293: WHEN fnd_api.g_exc_error THEN

289: , p_data => x_msg_data
290: );
291: EXCEPTION
292:
293: WHEN fnd_api.g_exc_error THEN
294: x_return_status := fnd_api.g_ret_sts_error;
295: fnd_msg_pub.count_and_get( p_encoded => 'F'
296: , p_count => x_msg_count
297: , p_data => x_msg_data

Line 294: x_return_status := fnd_api.g_ret_sts_error;

290: );
291: EXCEPTION
292:
293: WHEN fnd_api.g_exc_error THEN
294: x_return_status := fnd_api.g_ret_sts_error;
295: fnd_msg_pub.count_and_get( p_encoded => 'F'
296: , p_count => x_msg_count
297: , p_data => x_msg_data
298: );

Line 300: WHEN fnd_api.g_exc_unexpected_error THEN

296: , p_count => x_msg_count
297: , p_data => x_msg_data
298: );
299:
300: WHEN fnd_api.g_exc_unexpected_error THEN
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: fnd_msg_pub.count_and_get( p_encoded => 'F'
303: , p_count => x_msg_count
304: , p_data => x_msg_data

Line 301: x_return_status := fnd_api.g_ret_sts_unexp_error;

297: , p_data => x_msg_data
298: );
299:
300: WHEN fnd_api.g_exc_unexpected_error THEN
301: x_return_status := fnd_api.g_ret_sts_unexp_error;
302: fnd_msg_pub.count_and_get( p_encoded => 'F'
303: , p_count => x_msg_count
304: , p_data => x_msg_data
305: );

Line 308: x_return_status := fnd_api.g_ret_sts_unexp_error;

304: , p_data => x_msg_data
305: );
306:
307: WHEN OTHERS THEN
308: x_return_status := fnd_api.g_ret_sts_unexp_error;
309: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
310: THEN
311: fnd_msg_pub.add_exc_msg( g_pkg_name
312: , l_api_name

Line 363: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

359:
360: BEGIN
361:
362: -- check version compatibility
363: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
364: l_api_name, g_pkg_name)
365: THEN
366: RAISE fnd_api.g_exc_unexpected_error;
367: END IF;

Line 366: RAISE fnd_api.g_exc_unexpected_error;

362: -- check version compatibility
363: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
364: l_api_name, g_pkg_name)
365: THEN
366: RAISE fnd_api.g_exc_unexpected_error;
367: END IF;
368: -- initialize message stack if required
369: IF fnd_api.to_boolean(p_init_msg_list)
370: THEN

Line 369: IF fnd_api.to_boolean(p_init_msg_list)

365: THEN
366: RAISE fnd_api.g_exc_unexpected_error;
367: END IF;
368: -- initialize message stack if required
369: IF fnd_api.to_boolean(p_init_msg_list)
370: THEN
371: fnd_msg_pub.initialize;
372: END IF;
373: -- initialize return status

Line 374: x_return_status := fnd_api.g_ret_sts_success;

370: THEN
371: fnd_msg_pub.initialize;
372: END IF;
373: -- initialize return status
374: x_return_status := fnd_api.g_ret_sts_success;
375:
376: l_current_date := SYSDATE;
377: l_user := FND_GLOBAL.USER_ID;
378: l_login := FND_GLOBAL.LOGIN_ID;

Line 387: RAISE fnd_api.g_exc_unexpected_error;

383: LOOP
384: -- validate if the record is correct
385: IF NOT validate_object_capacity(p_Object_Capacity(l_idx))
386: THEN
387: RAISE fnd_api.g_exc_unexpected_error;
388: END IF;
389: -- populate the primary key if needed
390: IF p_Object_Capacity(l_idx).OBJECT_CAPACITY_ID IS NULL
391: THEN

Line 433: IF fnd_api.to_boolean(p_Update_Tasks)

429: l_idx := p_Object_Capacity.NEXT(l_idx);
430: END LOOP;
431:
432: -- check if task assignments need to be updated
433: IF fnd_api.to_boolean(p_Update_Tasks)
434: THEN
435: l_idx := p_Object_Tasks.FIRST;
436: WHILE l_idx IS NOT NULL
437: LOOP

Line 447: p_commit => fnd_api.G_FALSE,

443: l_ovn := p_Object_Tasks(l_idx).TASK_ASSIGNMENT_OVN;
444: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT
445: (
446: p_api_version => 1.0,
447: p_commit => fnd_api.G_FALSE,
448: p_object_version_number => l_ovn,
449: p_task_assignment_id => p_Object_Tasks(l_idx).TASK_ASSIGNMENT_ID,
450: p_enable_workflow => NULL,
451: p_abort_workflow => NULL,

Line 457: IF l_return_status <> fnd_api.g_ret_sts_success

453: x_return_status => l_return_status,
454: x_msg_count => l_msg_count,
455: x_msg_data => l_msg_data
456: );
457: IF l_return_status <> fnd_api.g_ret_sts_success
458: THEN
459: IF l_return_status = fnd_api.g_ret_sts_error
460: THEN
461: RAISE fnd_api.g_exc_error;

Line 459: IF l_return_status = fnd_api.g_ret_sts_error

455: x_msg_data => l_msg_data
456: );
457: IF l_return_status <> fnd_api.g_ret_sts_success
458: THEN
459: IF l_return_status = fnd_api.g_ret_sts_error
460: THEN
461: RAISE fnd_api.g_exc_error;
462: ELSE
463: RAISE fnd_api.g_exc_unexpected_error;

Line 461: RAISE fnd_api.g_exc_error;

457: IF l_return_status <> fnd_api.g_ret_sts_success
458: THEN
459: IF l_return_status = fnd_api.g_ret_sts_error
460: THEN
461: RAISE fnd_api.g_exc_error;
462: ELSE
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465: END IF;

Line 463: RAISE fnd_api.g_exc_unexpected_error;

459: IF l_return_status = fnd_api.g_ret_sts_error
460: THEN
461: RAISE fnd_api.g_exc_error;
462: ELSE
463: RAISE fnd_api.g_exc_unexpected_error;
464: END IF;
465: END IF;
466: END IF;
467: l_idx := p_Object_Tasks.NEXT(l_idx);

Line 477: WHEN fnd_api.g_exc_error THEN

473: , p_data => x_msg_data
474: );
475: EXCEPTION
476:
477: WHEN fnd_api.g_exc_error THEN
478: x_return_status := fnd_api.g_ret_sts_error;
479: fnd_msg_pub.count_and_get( p_encoded => 'F'
480: , p_count => x_msg_count
481: , p_data => x_msg_data

Line 478: x_return_status := fnd_api.g_ret_sts_error;

474: );
475: EXCEPTION
476:
477: WHEN fnd_api.g_exc_error THEN
478: x_return_status := fnd_api.g_ret_sts_error;
479: fnd_msg_pub.count_and_get( p_encoded => 'F'
480: , p_count => x_msg_count
481: , p_data => x_msg_data
482: );

Line 484: WHEN fnd_api.g_exc_unexpected_error THEN

480: , p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483:
484: WHEN fnd_api.g_exc_unexpected_error THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.count_and_get( p_encoded => 'F'
487: , p_count => x_msg_count
488: , p_data => x_msg_data

Line 485: x_return_status := fnd_api.g_ret_sts_unexp_error;

481: , p_data => x_msg_data
482: );
483:
484: WHEN fnd_api.g_exc_unexpected_error THEN
485: x_return_status := fnd_api.g_ret_sts_unexp_error;
486: fnd_msg_pub.count_and_get( p_encoded => 'F'
487: , p_count => x_msg_count
488: , p_data => x_msg_data
489: );

Line 492: x_return_status := fnd_api.g_ret_sts_unexp_error;

488: , p_data => x_msg_data
489: );
490:
491: WHEN OTHERS THEN
492: x_return_status := fnd_api.g_ret_sts_unexp_error;
493: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
494: THEN
495: fnd_msg_pub.add_exc_msg( g_pkg_name
496: , l_api_name

Line 523: -- If it is FND_API.G_MISS_NUM then the value will be set to NULL in the database

519: , p_available_hours IN NUMBER DEFAULT NULL -- The new value of available hours
520: -- If it is NULL then no change is done to the existing data
521: , p_available_hours_before IN NUMBER DEFAULT NULL -- The new value of available before hours.
522: -- If it is NULL then no change is done to the existing data
523: -- If it is FND_API.G_MISS_NUM then the value will be set to NULL in the database
524: , p_available_hours_after IN NUMBER DEFAULT NULL -- The new value of available before hours.
525: -- If it is NULL then no change is done to the existing data
526: -- If it is FND_API.G_MISS_NUM then the value will be set to NULL in the database
527: , p_status IN NUMBER DEFAULT NULL -- The new value of the status

Line 526: -- If it is FND_API.G_MISS_NUM then the value will be set to NULL in the database

522: -- If it is NULL then no change is done to the existing data
523: -- If it is FND_API.G_MISS_NUM then the value will be set to NULL in the database
524: , p_available_hours_after IN NUMBER DEFAULT NULL -- The new value of available before hours.
525: -- If it is NULL then no change is done to the existing data
526: -- If it is FND_API.G_MISS_NUM then the value will be set to NULL in the database
527: , p_status IN NUMBER DEFAULT NULL -- The new value of the status
528: -- If it is NULL then no change is done to the existing data
529: , p_availability_type IN VARCHAR2 DEFAULT NULL -- The new value of availability_type
530: --If it is NULL then no change is done to the existing data

Line 577: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

573:
574: BEGIN
575:
576: -- check version compatibility
577: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
578: l_api_name, g_pkg_name)
579: THEN
580: RAISE fnd_api.g_exc_unexpected_error;
581: END IF;

Line 580: RAISE fnd_api.g_exc_unexpected_error;

576: -- check version compatibility
577: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
578: l_api_name, g_pkg_name)
579: THEN
580: RAISE fnd_api.g_exc_unexpected_error;
581: END IF;
582: -- initialize message stack if required
583: IF fnd_api.to_boolean(p_init_msg_list)
584: THEN

Line 583: IF fnd_api.to_boolean(p_init_msg_list)

579: THEN
580: RAISE fnd_api.g_exc_unexpected_error;
581: END IF;
582: -- initialize message stack if required
583: IF fnd_api.to_boolean(p_init_msg_list)
584: THEN
585: fnd_msg_pub.initialize;
586: END IF;
587: -- initialize return status

Line 588: x_return_status := fnd_api.g_ret_sts_success;

584: THEN
585: fnd_msg_pub.initialize;
586: END IF;
587: -- initialize return status
588: x_return_status := fnd_api.g_ret_sts_success;
589:
590: l_Object_Capacity.OBJECT_CAPACITY_ID := p_object_capacity_id;
591:
592: OPEN C_ObjCap(l_Object_Capacity.OBJECT_CAPACITY_ID);

Line 611: RAISE fnd_api.g_exc_unexpected_error;

607: THEN
608: CLOSE C_ObjCap;
609: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
610: fnd_msg_pub.add;
611: RAISE fnd_api.g_exc_unexpected_error;
612: END IF;
613: CLOSE C_ObjCap;
614:
615: -- check if record updated by another user

Line 621: RAISE fnd_api.g_exc_unexpected_error;

617: l_Object_Capacity.OBJECT_VERSION_NUMBER)
618: THEN
619: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
620: fnd_msg_pub.add;
621: RAISE fnd_api.g_exc_unexpected_error;
622: END IF;
623:
624: -- Copy the changed values
625:

Line 628: IF ((p_available_hours IS NULL) OR (p_available_hours = FND_API.G_MISS_NUM))

624: -- Copy the changed values
625:
626: -- Available hours is mandatory field, so update only if a new valid
627: -- value is passed.
628: IF ((p_available_hours IS NULL) OR (p_available_hours = FND_API.G_MISS_NUM))
629: THEN
630: NULL;
631: ELSE
632: l_Object_Capacity.AVAILABLE_HOURS := p_available_hours;

Line 639: ELSIF (p_available_hours_before = FND_API.G_MISS_NUM)

635: -- Available hours before can be set to NULL or a new value
636: IF (p_available_hours_before IS NULL)
637: THEN
638: NULL;
639: ELSIF (p_available_hours_before = FND_API.G_MISS_NUM)
640: THEN
641: l_Object_Capacity.AVAILABLE_HOURS_BEFORE := NULL;
642: ELSE
643: l_Object_Capacity.AVAILABLE_HOURS_BEFORE := p_available_hours_before;

Line 650: ELSIF (p_available_hours_after = FND_API.G_MISS_NUM)

646: -- Available hours after can be set to NULL or a new value
647: IF (p_available_hours_after IS NULL)
648: THEN
649: NULL;
650: ELSIF (p_available_hours_after = FND_API.G_MISS_NUM)
651: THEN
652: l_Object_Capacity.AVAILABLE_HOURS_AFTER := NULL;
653: ELSE
654: l_Object_Capacity.AVAILABLE_HOURS_AFTER := p_available_hours_after;

Line 658: IF ((p_status IS NULL) OR (p_status = FND_API.G_MISS_NUM))

654: l_Object_Capacity.AVAILABLE_HOURS_AFTER := p_available_hours_after;
655: END IF;
656:
657: -- Status is mandatory field, so update only if a new valid value is passed.
658: IF ((p_status IS NULL) OR (p_status = FND_API.G_MISS_NUM))
659: THEN
660: NULL;
661: ELSE
662: l_Object_Capacity.STATUS := p_status;

Line 674: IF ((p_start_date_time IS NULL) OR (p_start_date_time = FND_API.G_MISS_DATE))

670: l_Object_Capacity.AVAILABILITY_TYPE := p_availability_type;
671: END IF;
672:
673: -- start date time is mandatory field, so update only if a new valid value is passed.
674: IF ((p_start_date_time IS NULL) OR (p_start_date_time = FND_API.G_MISS_DATE))
675: THEN
676: NULL;
677: ELSE
678: l_Object_Capacity.START_DATE_TIME := p_start_date_time;

Line 682: IF ((p_end_date_time IS NULL) OR (p_end_date_time = FND_API.G_MISS_DATE))

678: l_Object_Capacity.START_DATE_TIME := p_start_date_time;
679: END IF;
680:
681: -- end date time is mandatory field, so update only if a new valid value is passed.
682: IF ((p_end_date_time IS NULL) OR (p_end_date_time = FND_API.G_MISS_DATE))
683: THEN
684: NULL;
685: ELSE
686: l_Object_Capacity.END_DATE_TIME := p_end_date_time;

Line 690: IF ((p_source_type IS NULL) OR (p_source_type = FND_API.G_MISS_CHAR))

686: l_Object_Capacity.END_DATE_TIME := p_end_date_time;
687: END IF;
688:
689: -- for source type field update only if a new valid value is passed.
690: IF ((p_source_type IS NULL) OR (p_source_type = FND_API.G_MISS_CHAR))
691: THEN
692: NULL;
693: ELSE
694: l_Object_Capacity.SOURCE_TYPE := p_source_type;

Line 733: WHEN fnd_api.g_exc_error THEN

729: , p_data => x_msg_data
730: );
731: EXCEPTION
732:
733: WHEN fnd_api.g_exc_error THEN
734: x_return_status := fnd_api.g_ret_sts_error;
735: fnd_msg_pub.count_and_get( p_encoded => 'F'
736: , p_count => x_msg_count
737: , p_data => x_msg_data

Line 734: x_return_status := fnd_api.g_ret_sts_error;

730: );
731: EXCEPTION
732:
733: WHEN fnd_api.g_exc_error THEN
734: x_return_status := fnd_api.g_ret_sts_error;
735: fnd_msg_pub.count_and_get( p_encoded => 'F'
736: , p_count => x_msg_count
737: , p_data => x_msg_data
738: );

Line 740: WHEN fnd_api.g_exc_unexpected_error THEN

736: , p_count => x_msg_count
737: , p_data => x_msg_data
738: );
739:
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get( p_encoded => 'F'
743: , p_count => x_msg_count
744: , p_data => x_msg_data

Line 741: x_return_status := fnd_api.g_ret_sts_unexp_error;

737: , p_data => x_msg_data
738: );
739:
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get( p_encoded => 'F'
743: , p_count => x_msg_count
744: , p_data => x_msg_data
745: );

Line 748: x_return_status := fnd_api.g_ret_sts_unexp_error;

744: , p_data => x_msg_data
745: );
746:
747: WHEN OTHERS THEN
748: x_return_status := fnd_api.g_ret_sts_unexp_error;
749: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
750: THEN
751: fnd_msg_pub.add_exc_msg( g_pkg_name
752: , l_api_name

Line 819: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

815:
816: BEGIN
817:
818: -- check version compatibility
819: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
820: l_api_name, g_pkg_name)
821: THEN
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;

Line 822: RAISE fnd_api.g_exc_unexpected_error;

818: -- check version compatibility
819: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
820: l_api_name, g_pkg_name)
821: THEN
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
824: -- initialize message stack if required
825: IF fnd_api.to_boolean(p_init_msg_list)
826: THEN

Line 825: IF fnd_api.to_boolean(p_init_msg_list)

821: THEN
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
824: -- initialize message stack if required
825: IF fnd_api.to_boolean(p_init_msg_list)
826: THEN
827: fnd_msg_pub.initialize;
828: END IF;
829: -- initialize return status

Line 830: x_return_status := fnd_api.g_ret_sts_success;

826: THEN
827: fnd_msg_pub.initialize;
828: END IF;
829: -- initialize return status
830: x_return_status := fnd_api.g_ret_sts_success;
831:
832: OPEN C_ObjCap(p_object_capacity_id);
833: FETCH C_ObjCap
834: INTO l_object_version_number;

Line 840: RAISE fnd_api.g_exc_unexpected_error;

836: THEN
837: CLOSE C_ObjCap;
838: fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');
839: fnd_msg_pub.add;
840: RAISE fnd_api.g_exc_unexpected_error;
841: END IF;
842: CLOSE C_ObjCap;
843:
844: -- check if record updated by another user

Line 849: RAISE fnd_api.g_exc_unexpected_error;

845: IF (NVL(p_object_version_number, -1) <> l_object_version_number)
846: THEN
847: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
848: fnd_msg_pub.add;
849: RAISE fnd_api.g_exc_unexpected_error;
850: END IF;
851:
852: -- check if task assignments need to be updated
853: IF fnd_api.to_boolean(p_Update_Tasks)

Line 853: IF fnd_api.to_boolean(p_Update_Tasks)

849: RAISE fnd_api.g_exc_unexpected_error;
850: END IF;
851:
852: -- check if task assignments need to be updated
853: IF fnd_api.to_boolean(p_Update_Tasks)
854: THEN
855: -- First get all the open task assignments and remove the object capacity
856: FOR ref_tasks IN c_tasks(p_object_capacity_id)
857: LOOP

Line 862: p_commit => fnd_api.G_FALSE,

858: -- Call assignments api to update object capacity id
859: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT
860: (
861: p_api_version => 1.0,
862: p_commit => fnd_api.G_FALSE,
863: p_object_version_number => ref_tasks.OBJECT_VERSION_NUMBER,
864: p_task_assignment_id => ref_tasks.TASK_ASSIGNMENT_ID,
865: p_enable_workflow => NULL,
866: p_abort_workflow => NULL,

Line 872: IF l_return_status <> fnd_api.g_ret_sts_success

868: x_return_status => l_return_status,
869: x_msg_count => l_msg_count,
870: x_msg_data => l_msg_data
871: );
872: IF l_return_status <> fnd_api.g_ret_sts_success
873: THEN
874: IF l_return_status = fnd_api.g_ret_sts_error
875: THEN
876: RAISE fnd_api.g_exc_error;

Line 874: IF l_return_status = fnd_api.g_ret_sts_error

870: x_msg_data => l_msg_data
871: );
872: IF l_return_status <> fnd_api.g_ret_sts_success
873: THEN
874: IF l_return_status = fnd_api.g_ret_sts_error
875: THEN
876: RAISE fnd_api.g_exc_error;
877: ELSE
878: RAISE fnd_api.g_exc_unexpected_error;

Line 876: RAISE fnd_api.g_exc_error;

872: IF l_return_status <> fnd_api.g_ret_sts_success
873: THEN
874: IF l_return_status = fnd_api.g_ret_sts_error
875: THEN
876: RAISE fnd_api.g_exc_error;
877: ELSE
878: RAISE fnd_api.g_exc_unexpected_error;
879: END IF;
880: END IF;

Line 878: RAISE fnd_api.g_exc_unexpected_error;

874: IF l_return_status = fnd_api.g_ret_sts_error
875: THEN
876: RAISE fnd_api.g_exc_error;
877: ELSE
878: RAISE fnd_api.g_exc_unexpected_error;
879: END IF;
880: END IF;
881: END LOOP;
882: END IF;

Line 896: WHEN fnd_api.g_exc_error THEN

892: , p_data => x_msg_data
893: );
894: EXCEPTION
895:
896: WHEN fnd_api.g_exc_error THEN
897: x_return_status := fnd_api.g_ret_sts_error;
898: fnd_msg_pub.count_and_get( p_encoded => 'F'
899: , p_count => x_msg_count
900: , p_data => x_msg_data

Line 897: x_return_status := fnd_api.g_ret_sts_error;

893: );
894: EXCEPTION
895:
896: WHEN fnd_api.g_exc_error THEN
897: x_return_status := fnd_api.g_ret_sts_error;
898: fnd_msg_pub.count_and_get( p_encoded => 'F'
899: , p_count => x_msg_count
900: , p_data => x_msg_data
901: );

Line 903: WHEN fnd_api.g_exc_unexpected_error THEN

899: , p_count => x_msg_count
900: , p_data => x_msg_data
901: );
902:
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: x_return_status := fnd_api.g_ret_sts_unexp_error;
905: fnd_msg_pub.count_and_get( p_encoded => 'F'
906: , p_count => x_msg_count
907: , p_data => x_msg_data

Line 904: x_return_status := fnd_api.g_ret_sts_unexp_error;

900: , p_data => x_msg_data
901: );
902:
903: WHEN fnd_api.g_exc_unexpected_error THEN
904: x_return_status := fnd_api.g_ret_sts_unexp_error;
905: fnd_msg_pub.count_and_get( p_encoded => 'F'
906: , p_count => x_msg_count
907: , p_data => x_msg_data
908: );

Line 911: x_return_status := fnd_api.g_ret_sts_unexp_error;

907: , p_data => x_msg_data
908: );
909:
910: WHEN OTHERS THEN
911: x_return_status := fnd_api.g_ret_sts_unexp_error;
912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
913: THEN
914: fnd_msg_pub.add_exc_msg( g_pkg_name
915: , l_api_name

Line 958: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,

954:
955: BEGIN
956:
957: -- check version compatibility
958: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
959: l_api_name, g_pkg_name)
960: THEN
961: RAISE fnd_api.g_exc_unexpected_error;
962: END IF;

Line 961: RAISE fnd_api.g_exc_unexpected_error;

957: -- check version compatibility
958: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
959: l_api_name, g_pkg_name)
960: THEN
961: RAISE fnd_api.g_exc_unexpected_error;
962: END IF;
963: -- initialize message stack if required
964: IF fnd_api.to_boolean(p_init_msg_list)
965: THEN

Line 964: IF fnd_api.to_boolean(p_init_msg_list)

960: THEN
961: RAISE fnd_api.g_exc_unexpected_error;
962: END IF;
963: -- initialize message stack if required
964: IF fnd_api.to_boolean(p_init_msg_list)
965: THEN
966: fnd_msg_pub.initialize;
967: END IF;
968: -- initialize return status

Line 969: x_return_status := fnd_api.g_ret_sts_success;

965: THEN
966: fnd_msg_pub.initialize;
967: END IF;
968: -- initialize return status
969: x_return_status := fnd_api.g_ret_sts_success;
970:
971: fnd_msg_pub.count_and_get( p_encoded => 'F'
972: , p_count => x_msg_count
973: , p_data => x_msg_data

Line 977: WHEN fnd_api.g_exc_error THEN

973: , p_data => x_msg_data
974: );
975: EXCEPTION
976:
977: WHEN fnd_api.g_exc_error THEN
978: x_return_status := fnd_api.g_ret_sts_error;
979: fnd_msg_pub.count_and_get( p_encoded => 'F'
980: , p_count => x_msg_count
981: , p_data => x_msg_data

Line 978: x_return_status := fnd_api.g_ret_sts_error;

974: );
975: EXCEPTION
976:
977: WHEN fnd_api.g_exc_error THEN
978: x_return_status := fnd_api.g_ret_sts_error;
979: fnd_msg_pub.count_and_get( p_encoded => 'F'
980: , p_count => x_msg_count
981: , p_data => x_msg_data
982: );

Line 984: WHEN fnd_api.g_exc_unexpected_error THEN

980: , p_count => x_msg_count
981: , p_data => x_msg_data
982: );
983:
984: WHEN fnd_api.g_exc_unexpected_error THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986: fnd_msg_pub.count_and_get( p_encoded => 'F'
987: , p_count => x_msg_count
988: , p_data => x_msg_data

Line 985: x_return_status := fnd_api.g_ret_sts_unexp_error;

981: , p_data => x_msg_data
982: );
983:
984: WHEN fnd_api.g_exc_unexpected_error THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986: fnd_msg_pub.count_and_get( p_encoded => 'F'
987: , p_count => x_msg_count
988: , p_data => x_msg_data
989: );

Line 992: x_return_status := fnd_api.g_ret_sts_unexp_error;

988: , p_data => x_msg_data
989: );
990:
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
994: THEN
995: fnd_msg_pub.add_exc_msg( g_pkg_name
996: , l_api_name