[Home] [Help]
17:
18: PROCEDURE create_pricelist_header
19: (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_return_values IN VARCHAR2 := FND_API.g_false,
23: p_commit IN VARCHAR2 := FND_API.g_false,
24: p_deliv_rec IN deliv_rec_type,
25: x_return_status OUT NOCOPY VARCHAR2,
18: PROCEDURE create_pricelist_header
19: (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_return_values IN VARCHAR2 := FND_API.g_false,
23: p_commit IN VARCHAR2 := FND_API.g_false,
24: p_deliv_rec IN deliv_rec_type,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
19: (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_return_values IN VARCHAR2 := FND_API.g_false,
23: p_commit IN VARCHAR2 := FND_API.g_false,
24: p_deliv_rec IN deliv_rec_type,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
52:
53: PROCEDURE create_pricelist_line
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
57: p_return_values IN VARCHAR2 := FND_API.g_false,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_price_hdr_id IN NUMBER,
60: p_deliv_rec IN deliv_rec_type,
53: PROCEDURE create_pricelist_line
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
57: p_return_values IN VARCHAR2 := FND_API.g_false,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_price_hdr_id IN NUMBER,
60: p_deliv_rec IN deliv_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2,
54: (
55: p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
57: p_return_values IN VARCHAR2 := FND_API.g_false,
58: p_commit IN VARCHAR2 := FND_API.g_false,
59: p_price_hdr_id IN NUMBER,
60: p_deliv_rec IN deliv_rec_type,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
198:
199: PROCEDURE create_deliverable
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
203: p_commit IN VARCHAR2 := FND_API.g_false,
204: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
199: PROCEDURE create_deliverable
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
203: p_commit IN VARCHAR2 := FND_API.g_false,
204: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
203: p_commit IN VARCHAR2 := FND_API.g_false,
204: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
297: IF (AMS_DEBUG_HIGH_ON) THEN
298: AMS_Utility_PVT.debug_message(l_full_name||': start');
299: END IF;
300:
301: IF FND_API.to_boolean(p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: IF NOT FND_API.compatible_api_call
301: IF FND_API.to_boolean(p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: IF NOT FND_API.compatible_api_call
306: (
307: l_api_version,
308: p_api_version,
309: l_api_name,
308: p_api_version,
309: l_api_name,
310: g_pkg_name
311: ) THEN
312: RAISE FND_API.g_exc_unexpected_error;
313: END IF;
314:
315: x_return_status := FND_API.g_ret_sts_success;
316:
311: ) THEN
312: RAISE FND_API.g_exc_unexpected_error;
313: END IF;
314:
315: x_return_status := FND_API.g_ret_sts_success;
316:
317: /* added by musman
318: if the periods exist then only the calendar values has to updated
319: */
332: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
333: END IF;
334:
335: IF l_deliv_rec.transaction_currency_code IS NULL
336: OR l_deliv_rec.transaction_currency_code = FND_API.G_MISS_CHAR
337: THEN
338: l_deliv_rec.transaction_currency_code := l_deliv_rec.currency_code;
339: END IF;
340:
342: -- validate_deliverable
343: ams_deliverable_pub.validate_deliverable
344: (
345: p_api_version_number => l_api_version,
346: p_init_msg_list => FND_API.g_false,
347: p_validation_level => p_validation_level,
348: --p_validation_mode => JTF_PLSQL_API.g_create,
349: x_return_status => l_return_status,
350: x_msg_count => x_msg_count,
351: x_msg_data => x_msg_data,
352: p_deliv_rec => l_deliv_rec
353: );
354:
355: IF l_return_status = FND_API.g_ret_sts_error THEN
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: RAISE FND_API.g_exc_unexpected_error;
359: END IF;
352: p_deliv_rec => l_deliv_rec
353: );
354:
355: IF l_return_status = FND_API.g_ret_sts_error THEN
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: RAISE FND_API.g_exc_unexpected_error;
359: END IF;
360:
353: );
354:
355: IF l_return_status = FND_API.g_ret_sts_error THEN
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: RAISE FND_API.g_exc_unexpected_error;
359: END IF;
360:
361: -------------------------- insert --------------------------
354:
355: IF l_return_status = FND_API.g_ret_sts_error THEN
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: RAISE FND_API.g_exc_unexpected_error;
359: END IF;
360:
361: -------------------------- insert --------------------------
362: IF (AMS_DEBUG_HIGH_ON) THEN
603: END IF;
604:
605: AMS_ObjectAttribute_PVT.create_object_attributes(
606: l_api_version,
607: FND_API.g_false, -- p_init_msg_list - use same message queue as the calling API
608: FND_API.g_false, -- p_commit - commiting will cause problem with rollback in the calling API
609: p_validation_level,
610: l_return_status,
611: x_msg_count,
604:
605: AMS_ObjectAttribute_PVT.create_object_attributes(
606: l_api_version,
607: FND_API.g_false, -- p_init_msg_list - use same message queue as the calling API
608: FND_API.g_false, -- p_commit - commiting will cause problem with rollback in the calling API
609: p_validation_level,
610: l_return_status,
611: x_msg_count,
612: x_msg_data,
614: l_obj_id,
615: l_setup_id
616: );
617:
618: IF l_return_status = FND_API.g_ret_sts_error THEN
619: RAISE FND_API.g_exc_error;
620: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
615: l_setup_id
616: );
617:
618: IF l_return_status = FND_API.g_ret_sts_error THEN
619: RAISE FND_API.g_exc_error;
620: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
623: */
616: );
617:
618: IF l_return_status = FND_API.g_ret_sts_error THEN
619: RAISE FND_API.g_exc_error;
620: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
623: */
624: l_access_rec.act_access_to_object_id := l_obj_id;
617:
618: IF l_return_status = FND_API.g_ret_sts_error THEN
619: RAISE FND_API.g_exc_error;
620: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
623: */
624: l_access_rec.act_access_to_object_id := l_obj_id;
625: l_access_rec.arc_act_access_to_object := l_obj_type;
638: l_access_rec.admin_flag := 'Y'; /* bug fix for Hp: */
639: l_access_rec.delete_flag := 'N';
640: AMS_Access_PVT.create_access (
641: p_api_version => 1.0,
642: p_init_msg_list => FND_API.G_FALSE,
643: p_commit => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: x_return_status => x_return_status,
646: x_msg_count => x_msg_count,
639: l_access_rec.delete_flag := 'N';
640: AMS_Access_PVT.create_access (
641: p_api_version => 1.0,
642: p_init_msg_list => FND_API.G_FALSE,
643: p_commit => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: x_return_status => x_return_status,
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data,
640: AMS_Access_PVT.create_access (
641: p_api_version => 1.0,
642: p_init_msg_list => FND_API.G_FALSE,
643: p_commit => FND_API.G_FALSE,
644: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
645: x_return_status => x_return_status,
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data,
648: p_access_rec => l_access_rec,
647: x_msg_data => x_msg_data,
648: p_access_rec => l_access_rec,
649: x_access_id => l_access_rec.activity_access_id
650: );
651: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655:
648: p_access_rec => l_access_rec,
649: x_access_id => l_access_rec.activity_access_id
650: );
651: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655:
656: /*added by musman this to create jtf_Amv_item_item if it is a electronic deliverable */
673: p_deliv_rec => x_deliv_rec
674: );
675: END IF;
676:
677: IF l_return_status <> FND_API.g_ret_sts_success THEN
678: IF (AMS_DEBUG_HIGH_ON) THEN
679:
680: AMS_Utility_PVT.debug_message(l_full_name||': in the exception of call to update');
681: END IF;
680: AMS_Utility_PVT.debug_message(l_full_name||': in the exception of call to update');
681: END IF;
682: x_msg_count := l_msg_count;
683: x_msg_data := l_msg_data;
684: RAISE FND_API.G_EXC_ERROR;
685: END IF;
686:
687:
688: -- attach seeded metrics
699: p_act_metric_used_by_id => l_deliv_rec.deliverable_id,
700: p_act_metric_used_by_type => NULL
701: );
702:
703: IF l_return_status = FND_API.g_ret_sts_error THEN
704: RAISE FND_API.g_exc_error;
705: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
706: RAISE FND_API.g_exc_unexpected_error;
707: END IF;
700: p_act_metric_used_by_type => NULL
701: );
702:
703: IF l_return_status = FND_API.g_ret_sts_error THEN
704: RAISE FND_API.g_exc_error;
705: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
706: RAISE FND_API.g_exc_unexpected_error;
707: END IF;
708:
701: );
702:
703: IF l_return_status = FND_API.g_ret_sts_error THEN
704: RAISE FND_API.g_exc_error;
705: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
706: RAISE FND_API.g_exc_unexpected_error;
707: END IF;
708:
709:
702:
703: IF l_return_status = FND_API.g_ret_sts_error THEN
704: RAISE FND_API.g_exc_error;
705: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
706: RAISE FND_API.g_exc_unexpected_error;
707: END IF;
708:
709:
710: -- create task
722:
723: AMS_TASK_PVT.Create_task
724: (
725: p_api_version => l_api_version,
726: p_init_msg_list => FND_API.g_false, -- use the same message queue as the calling API
727: p_commit => FND_API.g_false, -- committing in the called api will cause problems with rollback in the calling API
728: p_task_id => NULL,
729: p_task_name => l_trim_task_name, -- 'Prep. task for - '||l_deliv_rec.deliverable_name,
730: p_task_type_id => 15,
723: AMS_TASK_PVT.Create_task
724: (
725: p_api_version => l_api_version,
726: p_init_msg_list => FND_API.g_false, -- use the same message queue as the calling API
727: p_commit => FND_API.g_false, -- committing in the called api will cause problems with rollback in the calling API
728: p_task_id => NULL,
729: p_task_name => l_trim_task_name, -- 'Prep. task for - '||l_deliv_rec.deliverable_name,
730: p_task_type_id => 15,
731: p_task_status_id => 14, -- in jtf_task_statuses_vl, 13 is Unassigned
749: IF (AMS_DEBUG_HIGH_ON) THEN
750: AMS_UTILITY_PVT.debug_message('the return status from :'||l_return_status);
751: END IF;
752:
753: IF l_return_status = FND_API.g_ret_sts_error THEN
754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
755: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
756: END IF;
757:
755: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
756: END IF;
757:
758: FND_MSG_PUB.count_and_get(
759: p_encoded => FND_API.g_false,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:
764: RAISE FND_API.g_exc_error;
765:
766: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
768: THEN
762: );
763:
764: RAISE FND_API.g_exc_error;
765:
766: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
768: THEN
769: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
770: END IF;
769: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
770: END IF;
771:
772: FND_MSG_PUB.count_and_get(
773: p_encoded => FND_API.g_false,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777:
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777:
778: RAISE FND_API.g_exc_unexpected_error;
779: END IF;
780:
781: -- create task assignment
782: IF (AMS_DEBUG_HIGH_ON) THEN
784: END IF;
785:
786: AMS_TASK_PVT.Create_Task_Assignment (
787: p_api_version => l_api_version,
788: p_init_msg_list => FND_API.g_false,
789: p_commit => FND_API.g_false,
790: p_task_id => x_task_id,
791: p_resource_type_code => 'RS_EMPLOYEE',
792: p_resource_id => l_deliv_rec.owner_user_id,
785:
786: AMS_TASK_PVT.Create_Task_Assignment (
787: p_api_version => l_api_version,
788: p_init_msg_list => FND_API.g_false,
789: p_commit => FND_API.g_false,
790: p_task_id => x_task_id,
791: p_resource_type_code => 'RS_EMPLOYEE',
792: p_resource_id => l_deliv_rec.owner_user_id,
793: p_assignment_status_id => 1,
796: x_msg_data => x_msg_data,
797: x_task_assignment_id => x_task_assignment_id
798: );
799:
800: IF l_return_status = FND_API.g_ret_sts_error THEN
801:
802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
803: THEN
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: END IF;
806:
807: FND_MSG_PUB.count_and_get(
808: p_encoded => FND_API.g_false,
809: p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: RAISE FND_API.g_exc_error;
808: p_encoded => FND_API.g_false,
809: p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: RAISE FND_API.g_exc_error;
813: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
814:
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
816: THEN
809: p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: RAISE FND_API.g_exc_error;
813: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
814:
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
816: THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819:
820: FND_MSG_PUB.count_and_get(
821: p_encoded => FND_API.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825: RAISE FND_API.g_exc_unexpected_error;
821: p_encoded => FND_API.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825: RAISE FND_API.g_exc_unexpected_error;
826: END IF;
827:
828: -------------------- code added by abhola ---------------------
829: --------- ams_association pvt. create association ------------
838: l_association_rec.usage_type :='USED_BY';
839:
840: AMS_Associations_PVT.create_association
841: ( p_api_version => l_api_version,
842: p_init_msg_list => FND_API.g_false,
843: p_commit => FND_API.g_false,
844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
845: x_return_status => l_return_status,
846: x_msg_count => x_msg_count,
839:
840: AMS_Associations_PVT.create_association
841: ( p_api_version => l_api_version,
842: p_init_msg_list => FND_API.g_false,
843: p_commit => FND_API.g_false,
844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
845: x_return_status => l_return_status,
846: x_msg_count => x_msg_count,
847: x_msg_data => x_msg_data,
840: AMS_Associations_PVT.create_association
841: ( p_api_version => l_api_version,
842: p_init_msg_list => FND_API.g_false,
843: p_commit => FND_API.g_false,
844: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
845: x_return_status => l_return_status,
846: x_msg_count => x_msg_count,
847: x_msg_data => x_msg_data,
848: p_association_rec => l_association_rec,
847: x_msg_data => x_msg_data,
848: p_association_rec => l_association_rec,
849: x_object_association_id => l_object_association_id
850: );
851: IF l_return_status = FND_API.g_ret_sts_error THEN
852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
853: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
854: END IF;
855: FND_MSG_PUB.count_and_get
853: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
854: END IF;
855: FND_MSG_PUB.count_and_get
856: (
857: p_encoded => FND_API.g_false,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: RAISE FND_API.g_exc_error;
857: p_encoded => FND_API.g_false,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: RAISE FND_API.g_exc_error;
862: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: RAISE FND_API.g_exc_error;
862: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get
867: (
868: p_encoded => FND_API.g_false,
869: p_count => x_msg_count,
870: p_data => x_msg_data
871: );
872: RAISE FND_API.g_exc_unexpected_error;
868: p_encoded => FND_API.g_false,
869: p_count => x_msg_count,
870: p_data => x_msg_data
871: );
872: RAISE FND_API.g_exc_unexpected_error;
873: END IF;
874: end if;
875: end if;
876: ----------------- end code added by abhola --------------------
876: ----------------- end code added by abhola --------------------
877: ------------------------- finish -------------------------------
878: x_deliv_id := l_deliv_rec.deliverable_id;
879:
880: IF FND_API.to_boolean(p_commit) THEN
881: COMMIT;
882: END IF;
883:
884: FND_MSG_PUB.count_and_get(
881: COMMIT;
882: END IF;
883:
884: FND_MSG_PUB.count_and_get(
885: p_encoded => FND_API.g_false,
886: p_count => x_msg_count,
887: p_data => x_msg_data
888: );
889:
892: END IF;
893:
894: EXCEPTION
895:
896: WHEN FND_API.g_exc_error THEN
897: ROLLBACK TO create_deliverable;
898: x_return_status := FND_API.g_ret_sts_error;
899: FND_MSG_PUB.count_and_get(
900: p_encoded => FND_API.g_false,
894: EXCEPTION
895:
896: WHEN FND_API.g_exc_error THEN
897: ROLLBACK TO create_deliverable;
898: x_return_status := FND_API.g_ret_sts_error;
899: FND_MSG_PUB.count_and_get(
900: p_encoded => FND_API.g_false,
901: p_count => x_msg_count,
902: p_data => x_msg_data
896: WHEN FND_API.g_exc_error THEN
897: ROLLBACK TO create_deliverable;
898: x_return_status := FND_API.g_ret_sts_error;
899: FND_MSG_PUB.count_and_get(
900: p_encoded => FND_API.g_false,
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904:
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );
904:
905: WHEN FND_API.g_exc_unexpected_error THEN
906: ROLLBACK TO create_deliverable;
907: x_return_status := FND_API.g_ret_sts_unexp_error ;
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
903: );
904:
905: WHEN FND_API.g_exc_unexpected_error THEN
906: ROLLBACK TO create_deliverable;
907: x_return_status := FND_API.g_ret_sts_unexp_error ;
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data
905: WHEN FND_API.g_exc_unexpected_error THEN
906: ROLLBACK TO create_deliverable;
907: x_return_status := FND_API.g_ret_sts_unexp_error ;
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data
912: );
913:
912: );
913:
914: WHEN OTHERS THEN
915: ROLLBACK TO create_deliverable;
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917:
918: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
919: THEN
920: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
920: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
921: END IF;
922:
923: FND_MSG_PUB.count_and_get(
924: p_encoded => FND_API.g_false,
925: p_count => x_msg_count,
926: p_data => x_msg_data
927: );
928:
939:
940: PROCEDURE delete_deliverable
941: (
942: p_api_version IN NUMBER,
943: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
944: p_commit IN VARCHAR2 := FND_API.g_false,
945:
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
940: PROCEDURE delete_deliverable
941: (
942: p_api_version IN NUMBER,
943: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
944: p_commit IN VARCHAR2 := FND_API.g_false,
945:
946: x_return_status OUT NOCOPY VARCHAR2,
947: x_msg_count OUT NOCOPY NUMBER,
948: x_msg_data OUT NOCOPY VARCHAR2,
964: IF (AMS_DEBUG_HIGH_ON) THEN
965: AMS_Utility_PVT.debug_message(l_full_name||': start');
966: END IF;
967:
968: IF FND_API.to_boolean(p_init_msg_list) THEN
969: FND_MSG_PUB.initialize;
970: END IF;
971:
972: IF NOT FND_API.compatible_api_call(
968: IF FND_API.to_boolean(p_init_msg_list) THEN
969: FND_MSG_PUB.initialize;
970: END IF;
971:
972: IF NOT FND_API.compatible_api_call(
973: l_api_version,
974: p_api_version,
975: l_api_name,
976: g_pkg_name
974: p_api_version,
975: l_api_name,
976: g_pkg_name
977: ) THEN
978: RAISE FND_API.g_exc_unexpected_error;
979: END IF;
980:
981: x_return_status := FND_API.G_RET_STS_SUCCESS;
982:
977: ) THEN
978: RAISE FND_API.g_exc_unexpected_error;
979: END IF;
980:
981: x_return_status := FND_API.G_RET_STS_SUCCESS;
982:
983: ------------------------ delete ------------------------
984: IF (AMS_DEBUG_HIGH_ON) THEN
985: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
994: THEN
995: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
996: FND_MSG_PUB.add;
997: END IF;
998: RAISE FND_API.g_exc_error;
999: END IF;
1000:
1001: DELETE FROM ams_deliverables_all_tl
1002: WHERE deliverable_id = p_deliv_id;
1006: THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1008: FND_MSG_PUB.add;
1009: END IF;
1010: RAISE FND_API.g_exc_error;
1011: END IF;
1012:
1013: -------------------- finish --------------------------
1014: IF FND_API.to_boolean(p_commit) THEN
1010: RAISE FND_API.g_exc_error;
1011: END IF;
1012:
1013: -------------------- finish --------------------------
1014: IF FND_API.to_boolean(p_commit) THEN
1015: COMMIT;
1016: END IF;
1017:
1018: FND_MSG_PUB.count_and_get(
1015: COMMIT;
1016: END IF;
1017:
1018: FND_MSG_PUB.count_and_get(
1019: p_encoded => FND_API.g_false,
1020: p_count => x_msg_count,
1021: p_data => x_msg_data
1022: );
1023:
1026: END IF;
1027:
1028: EXCEPTION
1029:
1030: WHEN FND_API.g_exc_error THEN
1031: ROLLBACK TO delete_deliverable;
1032: x_return_status := FND_API.g_ret_sts_error;
1033: FND_MSG_PUB.count_and_get(
1034: p_encoded => FND_API.g_false,
1028: EXCEPTION
1029:
1030: WHEN FND_API.g_exc_error THEN
1031: ROLLBACK TO delete_deliverable;
1032: x_return_status := FND_API.g_ret_sts_error;
1033: FND_MSG_PUB.count_and_get(
1034: p_encoded => FND_API.g_false,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data
1030: WHEN FND_API.g_exc_error THEN
1031: ROLLBACK TO delete_deliverable;
1032: x_return_status := FND_API.g_ret_sts_error;
1033: FND_MSG_PUB.count_and_get(
1034: p_encoded => FND_API.g_false,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data
1037: );
1038:
1035: p_count => x_msg_count,
1036: p_data => x_msg_data
1037: );
1038:
1039: WHEN FND_API.g_exc_unexpected_error THEN
1040: ROLLBACK TO delete_deliverable;
1041: x_return_status := FND_API.g_ret_sts_unexp_error ;
1042: FND_MSG_PUB.count_and_get(
1043: p_encoded => FND_API.g_false,
1037: );
1038:
1039: WHEN FND_API.g_exc_unexpected_error THEN
1040: ROLLBACK TO delete_deliverable;
1041: x_return_status := FND_API.g_ret_sts_unexp_error ;
1042: FND_MSG_PUB.count_and_get(
1043: p_encoded => FND_API.g_false,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1039: WHEN FND_API.g_exc_unexpected_error THEN
1040: ROLLBACK TO delete_deliverable;
1041: x_return_status := FND_API.g_ret_sts_unexp_error ;
1042: FND_MSG_PUB.count_and_get(
1043: p_encoded => FND_API.g_false,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1046: );
1047:
1046: );
1047:
1048: WHEN OTHERS THEN
1049: ROLLBACK TO delete_deliverable;
1050: x_return_status := FND_API.g_ret_sts_unexp_error ;
1051:
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1053: THEN
1054: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1054: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1055: END IF;
1056:
1057: FND_MSG_PUB.count_and_get(
1058: p_encoded => FND_API.g_false,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );
1062:
1073:
1074: PROCEDURE lock_deliverable
1075: (
1076: p_api_version IN NUMBER,
1077: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1078:
1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_msg_count OUT NOCOPY NUMBER,
1081: x_msg_data OUT NOCOPY VARCHAR2,
1112:
1113: AMS_Utility_PVT.debug_message(l_full_name||': start');
1114: END IF;
1115:
1116: IF FND_API.to_boolean(p_init_msg_list) THEN
1117: FND_MSG_PUB.initialize;
1118: END IF;
1119:
1120: IF NOT FND_API.compatible_api_call(
1116: IF FND_API.to_boolean(p_init_msg_list) THEN
1117: FND_MSG_PUB.initialize;
1118: END IF;
1119:
1120: IF NOT FND_API.compatible_api_call(
1121: l_api_version,
1122: p_api_version,
1123: l_api_name,
1124: g_pkg_name
1122: p_api_version,
1123: l_api_name,
1124: g_pkg_name
1125: ) THEN
1126: RAISE FND_API.g_exc_unexpected_error;
1127: END IF;
1128:
1129: x_return_status := FND_API.G_RET_STS_SUCCESS;
1130:
1125: ) THEN
1126: RAISE FND_API.g_exc_unexpected_error;
1127: END IF;
1128:
1129: x_return_status := FND_API.G_RET_STS_SUCCESS;
1130:
1131: ------------------------ lock -------------------------
1132: IF (AMS_DEBUG_HIGH_ON) THEN
1133:
1141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1142: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1143: FND_MSG_PUB.add;
1144: END IF;
1145: RAISE FND_API.g_exc_error;
1146: END IF;
1147: CLOSE c_deliv_b;
1148:
1149: OPEN c_deliv_tl;
1150: CLOSE c_deliv_tl;
1151:
1152: -------------------- finish --------------------------
1153: FND_MSG_PUB.count_and_get(
1154: p_encoded => FND_API.g_false,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data
1157: );
1158:
1158:
1159: EXCEPTION
1160:
1161: WHEN AMS_Utility_PVT.resource_locked THEN
1162: x_return_status := FND_API.g_ret_sts_error;
1163: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1164: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1165: FND_MSG_PUB.add;
1166: END IF;
1165: FND_MSG_PUB.add;
1166: END IF;
1167:
1168: FND_MSG_PUB.count_and_get(
1169: p_encoded => FND_API.g_false,
1170: p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );
1173:
1170: p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );
1173:
1174: WHEN FND_API.g_exc_error THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: FND_MSG_PUB.count_and_get(
1177: p_encoded => FND_API.g_false,
1178: p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );
1173:
1174: WHEN FND_API.g_exc_error THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: FND_MSG_PUB.count_and_get(
1177: p_encoded => FND_API.g_false,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data
1173:
1174: WHEN FND_API.g_exc_error THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: FND_MSG_PUB.count_and_get(
1177: p_encoded => FND_API.g_false,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );
1181:
1178: p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );
1181:
1182: WHEN FND_API.g_exc_unexpected_error THEN
1183: x_return_status := FND_API.g_ret_sts_unexp_error ;
1184: FND_MSG_PUB.count_and_get(
1185: p_encoded => FND_API.g_false,
1186: p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );
1181:
1182: WHEN FND_API.g_exc_unexpected_error THEN
1183: x_return_status := FND_API.g_ret_sts_unexp_error ;
1184: FND_MSG_PUB.count_and_get(
1185: p_encoded => FND_API.g_false,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1181:
1182: WHEN FND_API.g_exc_unexpected_error THEN
1183: x_return_status := FND_API.g_ret_sts_unexp_error ;
1184: FND_MSG_PUB.count_and_get(
1185: p_encoded => FND_API.g_false,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189:
1187: p_data => x_msg_data
1188: );
1189:
1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1193: THEN
1194: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1195: END IF;
1194: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1195: END IF;
1196:
1197: FND_MSG_PUB.count_and_get(
1198: p_encoded => FND_API.g_false,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data
1201: );
1202:
1216:
1217: PROCEDURE update_deliverable
1218: (
1219: p_api_version IN NUMBER,
1220: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1221: p_commit IN VARCHAR2 := FND_API.g_false,
1222: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1223:
1224: x_return_status OUT NOCOPY VARCHAR2,
1217: PROCEDURE update_deliverable
1218: (
1219: p_api_version IN NUMBER,
1220: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1221: p_commit IN VARCHAR2 := FND_API.g_false,
1222: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1223:
1224: x_return_status OUT NOCOPY VARCHAR2,
1225: x_msg_count OUT NOCOPY NUMBER,
1218: (
1219: p_api_version IN NUMBER,
1220: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1221: p_commit IN VARCHAR2 := FND_API.g_false,
1222: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1223:
1224: x_return_status OUT NOCOPY VARCHAR2,
1225: x_msg_count OUT NOCOPY NUMBER,
1226: x_msg_data OUT NOCOPY VARCHAR2,
1408: IF (AMS_DEBUG_HIGH_ON) THEN
1409: AMS_Utility_PVT.debug_message(l_full_name||': start');
1410: END IF;
1411:
1412: IF FND_API.to_boolean(p_init_msg_list) THEN
1413: FND_MSG_PUB.initialize;
1414: END IF;
1415:
1416: IF NOT FND_API.compatible_api_call(
1412: IF FND_API.to_boolean(p_init_msg_list) THEN
1413: FND_MSG_PUB.initialize;
1414: END IF;
1415:
1416: IF NOT FND_API.compatible_api_call(
1417: l_api_version,
1418: p_api_version,
1419: l_api_name,
1420: g_pkg_name
1418: p_api_version,
1419: l_api_name,
1420: g_pkg_name
1421: ) THEN
1422: RAISE FND_API.g_exc_unexpected_error;
1423: END IF;
1424:
1425: x_return_status := FND_API.G_RET_STS_SUCCESS;
1426:
1421: ) THEN
1422: RAISE FND_API.g_exc_unexpected_error;
1423: END IF;
1424:
1425: x_return_status := FND_API.G_RET_STS_SUCCESS;
1426:
1427: ----------------------- validate ----------------------
1428: --01/24/02 added for access check bug #2764852 mukumar start
1429:
1441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1442: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1443: FND_MSG_PUB.add;
1444: END IF;
1445: RAISE FND_API.g_exc_error;
1446: end if;
1447: --01/24/02 added for access check bug #2764852 mukumar end
1448:
1449: IF (AMS_DEBUG_HIGH_ON) THEN
1452: AMS_Utility_PVT.debug_message('l_deliv_rec.currency_code:'||l_deliv_rec.currency_code);
1453: END IF;
1454:
1455:
1456: IF l_deliv_rec.transaction_currency_code = FND_API.G_MISS_CHAR
1457: OR l_deliv_rec.transaction_currency_code IS NULL
1458: THEN
1459: l_deliv_rec.transaction_currency_code := l_deliv_rec.currency_code;
1460: END IF;
1476: ,x_deliverable_calendar => l_deliverable_calendar
1477: ,x_return_status => l_return_Status
1478: );
1479:
1480: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1481: RAISE FND_API.g_exc_unexpected_error;
1482: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1477: ,x_return_status => l_return_Status
1478: );
1479:
1480: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1481: RAISE FND_API.g_exc_unexpected_error;
1482: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1485: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1478: );
1479:
1480: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1481: RAISE FND_API.g_exc_unexpected_error;
1482: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1485: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1486: END IF;
1479:
1480: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1481: RAISE FND_API.g_exc_unexpected_error;
1482: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1485: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1486: END IF;
1487: ELSIF ((l_deliv_rec.start_period_name IS NULL)
1480: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1481: RAISE FND_API.g_exc_unexpected_error;
1482: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1483: RAISE FND_API.g_exc_error;
1484: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1485: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1486: END IF;
1487: ELSIF ((l_deliv_rec.start_period_name IS NULL)
1488: AND (l_deliv_rec.end_period_name IS NULL)) THEN
1496: -- validate_deliverable
1497: ams_deliverable_pub.validate_deliverable
1498: (
1499: p_api_version_number => l_api_version,
1500: p_init_msg_list => FND_API.g_false,
1501: p_validation_level => p_validation_level,
1502: p_validation_mode => JTF_PLSQL_API.g_update,
1503: x_return_status => l_return_status,
1504: x_msg_count => x_msg_count,
1513: p_validation_mode => JTF_PLSQL_API.g_update,
1514: x_return_status => l_return_status
1515: );
1516:
1517: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1518: RAISE FND_API.g_exc_unexpected_error;
1519: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1520: RAISE FND_API.g_exc_error;
1521: END IF;
1514: x_return_status => l_return_status
1515: );
1516:
1517: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1518: RAISE FND_API.g_exc_unexpected_error;
1519: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1520: RAISE FND_API.g_exc_error;
1521: END IF;
1522: END IF;
1515: );
1516:
1517: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1518: RAISE FND_API.g_exc_unexpected_error;
1519: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1520: RAISE FND_API.g_exc_error;
1521: END IF;
1522: END IF;
1523:
1516:
1517: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1518: RAISE FND_API.g_exc_unexpected_error;
1519: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1520: RAISE FND_API.g_exc_error;
1521: END IF;
1522: END IF;
1523:
1524: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1533: x_return_status => l_return_status
1534: );
1535: */
1536:
1537: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1538: RAISE FND_API.g_exc_unexpected_error;
1539: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1540: RAISE FND_API.g_exc_error;
1541: END IF;
1534: );
1535: */
1536:
1537: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1538: RAISE FND_API.g_exc_unexpected_error;
1539: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1540: RAISE FND_API.g_exc_error;
1541: END IF;
1542: END IF;
1535: */
1536:
1537: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1538: RAISE FND_API.g_exc_unexpected_error;
1539: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1540: RAISE FND_API.g_exc_error;
1541: END IF;
1542: END IF;
1543:
1536:
1537: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1538: RAISE FND_API.g_exc_unexpected_error;
1539: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1540: RAISE FND_API.g_exc_error;
1541: END IF;
1542: END IF;
1543:
1544: OPEN c_new_status_code(l_deliv_rec.user_status_id);
1553:
1554: -- for cancellation change musman 10/04/00
1555: IF l_deliv_rec.status_code IN ('CANCELLED', 'ARCHIVED') THEN
1556: Deliverable_cancellation(l_deliv_rec, l_return_status);
1557: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1558: RAISE FND_API.g_exc_unexpected_error;
1559: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1560: RAISE FND_API.g_exc_error;
1561: END IF;
1554: -- for cancellation change musman 10/04/00
1555: IF l_deliv_rec.status_code IN ('CANCELLED', 'ARCHIVED') THEN
1556: Deliverable_cancellation(l_deliv_rec, l_return_status);
1557: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1558: RAISE FND_API.g_exc_unexpected_error;
1559: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1560: RAISE FND_API.g_exc_error;
1561: END IF;
1562: END IF;
1555: IF l_deliv_rec.status_code IN ('CANCELLED', 'ARCHIVED') THEN
1556: Deliverable_cancellation(l_deliv_rec, l_return_status);
1557: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1558: RAISE FND_API.g_exc_unexpected_error;
1559: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1560: RAISE FND_API.g_exc_error;
1561: END IF;
1562: END IF;
1563:
1556: Deliverable_cancellation(l_deliv_rec, l_return_status);
1557: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1558: RAISE FND_API.g_exc_unexpected_error;
1559: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1560: RAISE FND_API.g_exc_error;
1561: END IF;
1562: END IF;
1563:
1564: -- Bug 1350422 modified by khung 07/11/2000
1618: x_msg_count => x_msg_count,
1619: x_msg_data => x_msg_data
1620: );
1621:
1622: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1623: RAISE FND_API.g_exc_unexpected_error;
1624: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1625: RAISE FND_API.g_exc_error;
1626: END IF;
1619: x_msg_data => x_msg_data
1620: );
1621:
1622: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1623: RAISE FND_API.g_exc_unexpected_error;
1624: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1625: RAISE FND_API.g_exc_error;
1626: END IF;
1627:
1620: );
1621:
1622: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1623: RAISE FND_API.g_exc_unexpected_error;
1624: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1625: RAISE FND_API.g_exc_error;
1626: END IF;
1627:
1628: -- this is needed if the user passes the inv_id,org_id from the public api
1621:
1622: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1623: RAISE FND_API.g_exc_unexpected_error;
1624: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1625: RAISE FND_API.g_exc_error;
1626: END IF;
1627:
1628: -- this is needed if the user passes the inv_id,org_id from the public api
1629: -- validating whether the inv item has reqd attributes set.
1639: check_inv_item(
1640: p_deliv_rec => l_deliv_rec
1641: ,x_return_status => x_return_status);
1642:
1643: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1644: RAISE FND_API.g_exc_unexpected_error;
1645: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1646: RAISE FND_API.g_exc_error;
1647: END IF;
1640: p_deliv_rec => l_deliv_rec
1641: ,x_return_status => x_return_status);
1642:
1643: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1644: RAISE FND_API.g_exc_unexpected_error;
1645: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1646: RAISE FND_API.g_exc_error;
1647: END IF;
1648:
1641: ,x_return_status => x_return_status);
1642:
1643: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1644: RAISE FND_API.g_exc_unexpected_error;
1645: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1646: RAISE FND_API.g_exc_error;
1647: END IF;
1648:
1649: END IF;
1642:
1643: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1644: RAISE FND_API.g_exc_unexpected_error;
1645: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1646: RAISE FND_API.g_exc_error;
1647: END IF;
1648:
1649: END IF;
1650: -- End Inventory creation
1678:
1679: JTF_AMV_ITEM_PUB.Create_Item
1680: (
1681: p_api_version => 1.0,
1682: p_init_msg_list => FND_API.g_true,
1683: p_commit => FND_API.g_false,
1684: x_return_status => l_return_status,
1685: x_msg_count => l_msg_count,
1686: x_msg_data => l_msg_data,
1679: JTF_AMV_ITEM_PUB.Create_Item
1680: (
1681: p_api_version => 1.0,
1682: p_init_msg_list => FND_API.g_true,
1683: p_commit => FND_API.g_false,
1684: x_return_status => l_return_status,
1685: x_msg_count => l_msg_count,
1686: x_msg_data => l_msg_data,
1687: p_item_rec => l_jtf_amv_item_rec,
1688: x_item_id => x_jtf_amv_item_id
1689: );
1690: x_return_status := l_return_status;
1691:
1692: IF l_return_status <> FND_API.g_ret_sts_success THEN
1693: RAISE jtf_inv_item_creation_error;
1694: ELSE
1695: l_deliv_rec.jtf_amv_item_id := x_jtf_amv_item_id;
1696: l_jtf_delv_item_id := x_jtf_amv_item_id;
1790: FETCH c_user_status_id INTO l_reject_status_id;
1791: -- CLOSE c_user_status_id;
1792: --
1793: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(' the approval reqd flag gives : '||Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr)); END IF;
1794: -- IF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_true
1795: -- THEN
1796: -- -- choang - 13-sep-2000
1797: -- -- Change of approval process.
1798: -- -- flip the status to pending budget approval
1803: -- FETCH c_user_status_id INTO l_pending_budget_stat_id;
1804: -- CLOSE c_user_status_id;
1805:
1806: -- IF (AMS_DEBUG_HIGH_ON) THEN ams_utility_pvt.debug_message (' l_pending_budget_stat_id : '||l_pending_budget_stat_id); END IF;
1807: -- ELSIF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_false
1808: -- THEN
1809: -- l_pending_budget_stat_id :=l_deliv_rec.user_status_id;
1810: -- l_pending_budget_stat := l_deliv_rec.status_code;
1811: -- END IF; -- if approval needed / BAPL exists
1919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1920: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1921: FND_MSG_PUB.add;
1922: END IF;
1923: RAISE FND_API.g_exc_error;
1924: END IF;
1925: IF (AMS_DEBUG_HIGH_ON) THEN
1926:
1927: ams_utility_pvt.debug_message (l_full_name ||' end of update 1 ');
1940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1941: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1942: FND_MSG_PUB.add;
1943: END IF;
1944: RAISE FND_API.g_exc_error;
1945: END IF;
1946:
1947: IF (l_Deliv_rec.owner_user_id <> FND_API.g_miss_NUM
1948: AND l_owner_user_id <> l_deliv_Rec.owner_user_id )
1943: END IF;
1944: RAISE FND_API.g_exc_error;
1945: END IF;
1946:
1947: IF (l_Deliv_rec.owner_user_id <> FND_API.g_miss_NUM
1948: AND l_owner_user_id <> l_deliv_Rec.owner_user_id )
1949: THEN
1950: AMS_Access_PVT.update_object_owner
1951: ( p_api_version => 1.0
1948: AND l_owner_user_id <> l_deliv_Rec.owner_user_id )
1949: THEN
1950: AMS_Access_PVT.update_object_owner
1951: ( p_api_version => 1.0
1952: ,p_init_msg_list => FND_API.G_FALSE
1953: ,p_commit => FND_API.G_FALSE
1954: ,p_validation_level => p_validation_level
1955: ,x_return_status => x_return_status
1956: ,x_msg_count => x_msg_count
1949: THEN
1950: AMS_Access_PVT.update_object_owner
1951: ( p_api_version => 1.0
1952: ,p_init_msg_list => FND_API.G_FALSE
1953: ,p_commit => FND_API.G_FALSE
1954: ,p_validation_level => p_validation_level
1955: ,x_return_status => x_return_status
1956: ,x_msg_count => x_msg_count
1957: ,x_msg_data => x_msg_data
1959: ,p_object_id => l_deliv_Rec.deliverable_id
1960: ,p_resource_id => l_deliv_rec.owner_user_id
1961: ,p_old_resource_id => l_owner_user_id
1962: );
1963: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966: END IF;
1967:
1960: ,p_resource_id => l_deliv_rec.owner_user_id
1961: ,p_old_resource_id => l_owner_user_id
1962: );
1963: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966: END IF;
1967:
1968: -------------------------------------
1995: -- FETCH check_budget INTO l_budget_lines_exist;
1996: -- CLOSE check_budget;
1997: --
1998: --
1999: -- IF Approval_required_flag( l_deliv_rec.setup_id, 'BAPL') = FND_API.g_true
2000: -- AND l_budget_lines_exist = 'N' THEN
2001: --
2002: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2003: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2002: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2003: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2004: -- FND_MSG_PUB.add;
2005: -- END IF;
2006: -- RAISE FND_API.g_exc_error;
2007: -- END IF;
2008: -- *****************************************
2009: --
2010: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('after update the approval reqd flag gives : '||Approval_required_flag( l_deliv_rec.setup_id, 'BAPL')||' and fnd_api.g_true :'|| FND_API.g_true); END IF;
2006: -- RAISE FND_API.g_exc_error;
2007: -- END IF;
2008: -- *****************************************
2009: --
2010: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('after update the approval reqd flag gives : '||Approval_required_flag( l_deliv_rec.setup_id, 'BAPL')||' and fnd_api.g_true :'|| FND_API.g_true); END IF;
2011: -- IF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_true
2012: -- THEN
2013: --
2014: -- choang - 13-sep-2000
2007: -- END IF;
2008: -- *****************************************
2009: --
2010: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message('after update the approval reqd flag gives : '||Approval_required_flag( l_deliv_rec.setup_id, 'BAPL')||' and fnd_api.g_true :'|| FND_API.g_true); END IF;
2011: -- IF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_true
2012: -- THEN
2013: --
2014: -- choang - 13-sep-2000
2015: -- -- Change of approval process.
2044: p_deliverable_id => l_deliv_rec.deliverable_id
2045: ,p_user_status_id => l_deliv_rec.user_status_id
2046: );
2047:
2048: -- IF x_return_status <> FND_API.g_ret_sts_success
2049: -- THEN
2050: -- RAISE FND_API.g_exc_error;
2051: -- END IF;
2052:
2046: );
2047:
2048: -- IF x_return_status <> FND_API.g_ret_sts_success
2049: -- THEN
2050: -- RAISE FND_API.g_exc_error;
2051: -- END IF;
2052:
2053: IF (AMS_DEBUG_HIGH_ON) THEN
2054:
2057: ams_utility_pvt.debug_message (l_full_name ||' end of update 2 ');
2058:
2059: END IF;
2060: -------------------- finish --------------------------
2061: IF FND_API.to_boolean(p_commit) THEN
2062: COMMIT;
2063: END IF;
2064:
2065: FND_MSG_PUB.count_and_get(
2062: COMMIT;
2063: END IF;
2064:
2065: FND_MSG_PUB.count_and_get(
2066: p_encoded => FND_API.g_false,
2067: p_count => x_msg_count,
2068: p_data => x_msg_data
2069: );
2070:
2077: END IF;
2078:
2079: EXCEPTION
2080:
2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO update_deliverable;
2083: x_return_status := FND_API.g_ret_sts_error;
2084: FND_MSG_PUB.count_and_get(
2085: p_encoded => FND_API.g_false,
2079: EXCEPTION
2080:
2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO update_deliverable;
2083: x_return_status := FND_API.g_ret_sts_error;
2084: FND_MSG_PUB.count_and_get(
2085: p_encoded => FND_API.g_false,
2086: p_count => x_msg_count,
2087: p_data => x_msg_data
2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO update_deliverable;
2083: x_return_status := FND_API.g_ret_sts_error;
2084: FND_MSG_PUB.count_and_get(
2085: p_encoded => FND_API.g_false,
2086: p_count => x_msg_count,
2087: p_data => x_msg_data
2088: );
2089:
2086: p_count => x_msg_count,
2087: p_data => x_msg_data
2088: );
2089:
2090: WHEN FND_API.g_exc_unexpected_error THEN
2091: ROLLBACK TO update_deliverable;
2092: x_return_status := FND_API.g_ret_sts_unexp_error ;
2093: FND_MSG_PUB.count_and_get(
2094: p_encoded => FND_API.g_false,
2088: );
2089:
2090: WHEN FND_API.g_exc_unexpected_error THEN
2091: ROLLBACK TO update_deliverable;
2092: x_return_status := FND_API.g_ret_sts_unexp_error ;
2093: FND_MSG_PUB.count_and_get(
2094: p_encoded => FND_API.g_false,
2095: p_count => x_msg_count,
2096: p_data => x_msg_data
2090: WHEN FND_API.g_exc_unexpected_error THEN
2091: ROLLBACK TO update_deliverable;
2092: x_return_status := FND_API.g_ret_sts_unexp_error ;
2093: FND_MSG_PUB.count_and_get(
2094: p_encoded => FND_API.g_false,
2095: p_count => x_msg_count,
2096: p_data => x_msg_data
2097: );
2098:
2098:
2099: WHEN inv_creation_error THEN
2100: /*-modify on 08/07/2000 khung
2101: --FND_MSG_PUB.count_and_get(
2102: p_encoded => FND_API.g_false,
2103: -- p_count => x_msg_count,
2104: -- p_data => x_msg_data
2105: -- );*/
2106: ROLLBACK TO update_deliverable;
2105: -- );*/
2106: ROLLBACK TO update_deliverable;
2107: FOR i IN 1 .. x_error_tbl.count LOOP
2108: FND_MSG_PUB.count_and_get(
2109: p_encoded => FND_API.g_false,
2110: p_count => x_msg_count,
2111: p_data => x_error_tbl(i).message_text
2112: );
2113: IF (AMS_DEBUG_HIGH_ON) THEN
2118:
2119: WHEN jtf_inv_item_creation_error THEN
2120: ROLLBACK TO update_deliverable;
2121: FND_MSG_PUB.count_and_get(
2122: p_encoded => FND_API.g_false,
2123: p_count => x_msg_count,
2124: p_data => x_msg_data
2125: );
2126: WHEN OTHERS THEN
2124: p_data => x_msg_data
2125: );
2126: WHEN OTHERS THEN
2127: ROLLBACK TO update_deliverable;
2128: x_return_status := FND_API.g_ret_sts_unexp_error ;
2129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.count_and_get(
2129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.count_and_get(
2133: p_encoded => FND_API.g_false,
2134: p_count => x_msg_count,
2135: p_data => x_msg_data
2136: );
2137: END update_deliverable;
2146:
2147: PROCEDURE validate_deliverable
2148: (
2149: p_api_version IN NUMBER,
2150: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2152: p_validation_mode IN VARCHAR2,
2153: x_return_status OUT NOCOPY VARCHAR2,
2154: x_msg_count OUT NOCOPY NUMBER,
2147: PROCEDURE validate_deliverable
2148: (
2149: p_api_version IN NUMBER,
2150: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2151: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2152: p_validation_mode IN VARCHAR2,
2153: x_return_status OUT NOCOPY VARCHAR2,
2154: x_msg_count OUT NOCOPY NUMBER,
2155: x_msg_data OUT NOCOPY VARCHAR2,
2169:
2170: AMS_Utility_PVT.debug_message(l_full_name||': start');
2171: END IF;
2172:
2173: IF FND_API.to_boolean(p_init_msg_list) THEN
2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177: IF NOT FND_API.compatible_api_call(
2173: IF FND_API.to_boolean(p_init_msg_list) THEN
2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177: IF NOT FND_API.compatible_api_call(
2178: l_api_version,
2179: p_api_version,
2180: l_api_name,
2181: g_pkg_name
2179: p_api_version,
2180: l_api_name,
2181: g_pkg_name
2182: ) THEN
2183: RAISE FND_API.g_exc_unexpected_error;
2184: END IF;
2185:
2186: x_return_status := FND_API.g_ret_sts_success;
2187:
2182: ) THEN
2183: RAISE FND_API.g_exc_unexpected_error;
2184: END IF;
2185:
2186: x_return_status := FND_API.g_ret_sts_success;
2187:
2188: ---------------------- validate ------------------------
2189: IF (AMS_DEBUG_HIGH_ON) THEN
2190:
2197: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,
2198: x_return_status => l_return_status
2199: );
2200:
2201: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2202: RAISE FND_API.g_exc_unexpected_error;
2203: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2204: RAISE FND_API.g_exc_error;
2205: END IF;
2198: x_return_status => l_return_status
2199: );
2200:
2201: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2202: RAISE FND_API.g_exc_unexpected_error;
2203: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2204: RAISE FND_API.g_exc_error;
2205: END IF;
2206: END IF;
2199: );
2200:
2201: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2202: RAISE FND_API.g_exc_unexpected_error;
2203: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2204: RAISE FND_API.g_exc_error;
2205: END IF;
2206: END IF;
2207:
2200:
2201: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2202: RAISE FND_API.g_exc_unexpected_error;
2203: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2204: RAISE FND_API.g_exc_error;
2205: END IF;
2206: END IF;
2207:
2208: IF (AMS_DEBUG_HIGH_ON) THEN
2217: p_deliv_rec => p_deliv_rec,
2218: p_complete_rec => NULL,
2219: x_return_status => l_return_status
2220: );
2221: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2222: RAISE FND_API.g_exc_unexpected_error;
2223: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2224: RAISE FND_API.g_exc_error;
2225: END IF;
2218: p_complete_rec => NULL,
2219: x_return_status => l_return_status
2220: );
2221: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2222: RAISE FND_API.g_exc_unexpected_error;
2223: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2224: RAISE FND_API.g_exc_error;
2225: END IF;
2226:
2219: x_return_status => l_return_status
2220: );
2221: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2222: RAISE FND_API.g_exc_unexpected_error;
2223: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2224: RAISE FND_API.g_exc_error;
2225: END IF;
2226:
2227: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2220: );
2221: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2222: RAISE FND_API.g_exc_unexpected_error;
2223: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2224: RAISE FND_API.g_exc_error;
2225: END IF;
2226:
2227: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2228: AND p_validation_mode = JTF_PLSQL_API.g_update
2232: p_deliv_rec => p_deliv_rec,
2233: p_complete_rec => p_deliv_rec,
2234: x_return_status => l_return_status
2235: );
2236: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2237: RAISE FND_API.g_exc_unexpected_error;
2238: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2239: RAISE FND_API.g_exc_error;
2240: END IF;
2233: p_complete_rec => p_deliv_rec,
2234: x_return_status => l_return_status
2235: );
2236: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2237: RAISE FND_API.g_exc_unexpected_error;
2238: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2239: RAISE FND_API.g_exc_error;
2240: END IF;
2241:
2234: x_return_status => l_return_status
2235: );
2236: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2237: RAISE FND_API.g_exc_unexpected_error;
2238: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2239: RAISE FND_API.g_exc_error;
2240: END IF;
2241:
2242: END IF;
2235: );
2236: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2237: RAISE FND_API.g_exc_unexpected_error;
2238: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2239: RAISE FND_API.g_exc_error;
2240: END IF;
2241:
2242: END IF;
2243:
2242: END IF;
2243:
2244: -------------------- finish --------------------------
2245: FND_MSG_PUB.count_and_get(
2246: p_encoded => FND_API.g_false,
2247: p_count => x_msg_count,
2248: p_data => x_msg_data
2249: );
2250:
2257: END IF;
2258:
2259: EXCEPTION
2260:
2261: WHEN FND_API.g_exc_error THEN
2262: x_return_status := FND_API.g_ret_sts_error;
2263: FND_MSG_PUB.count_and_get(
2264: p_encoded => FND_API.g_false,
2265: p_count => x_msg_count,
2258:
2259: EXCEPTION
2260:
2261: WHEN FND_API.g_exc_error THEN
2262: x_return_status := FND_API.g_ret_sts_error;
2263: FND_MSG_PUB.count_and_get(
2264: p_encoded => FND_API.g_false,
2265: p_count => x_msg_count,
2266: p_data => x_msg_data
2260:
2261: WHEN FND_API.g_exc_error THEN
2262: x_return_status := FND_API.g_ret_sts_error;
2263: FND_MSG_PUB.count_and_get(
2264: p_encoded => FND_API.g_false,
2265: p_count => x_msg_count,
2266: p_data => x_msg_data
2267: );
2268:
2265: p_count => x_msg_count,
2266: p_data => x_msg_data
2267: );
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: x_return_status := FND_API.g_ret_sts_unexp_error ;
2271: FND_MSG_PUB.count_and_get(
2272: p_encoded => FND_API.g_false,
2273: p_count => x_msg_count,
2266: p_data => x_msg_data
2267: );
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: x_return_status := FND_API.g_ret_sts_unexp_error ;
2271: FND_MSG_PUB.count_and_get(
2272: p_encoded => FND_API.g_false,
2273: p_count => x_msg_count,
2274: p_data => x_msg_data
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: x_return_status := FND_API.g_ret_sts_unexp_error ;
2271: FND_MSG_PUB.count_and_get(
2272: p_encoded => FND_API.g_false,
2273: p_count => x_msg_count,
2274: p_data => x_msg_data
2275: );
2276:
2274: p_data => x_msg_data
2275: );
2276:
2277: WHEN OTHERS THEN
2278: x_return_status := FND_API.g_ret_sts_unexp_error;
2279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2280: THEN
2281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2282: END IF;
2281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2282: END IF;
2283:
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false,
2286: p_count => x_msg_count,
2287: p_data => x_msg_data
2288: );
2289:
2303: )
2304: IS
2305: BEGIN
2306:
2307: x_return_status := FND_API.g_ret_sts_success;
2308:
2309: -------------------- put required items here ---------------------
2310:
2311: IF p_deliv_rec.language_code IS NULL THEN
2314: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_LANGUAGE_CODE');
2315: FND_MSG_PUB.add;
2316: END IF;
2317:
2318: x_return_status := FND_API.g_ret_sts_error;
2319: RETURN;
2320: END IF;
2321:
2322: IF p_deliv_rec.deliverable_name IS NULL THEN
2325: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_DELIVERABLE_NAME');
2326: FND_MSG_PUB.add;
2327: END IF;
2328:
2329: x_return_status := FND_API.g_ret_sts_error;
2330: RETURN;
2331: END IF;
2332:
2333: IF p_deliv_rec.actual_avail_from_date IS NULL THEN
2336: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FROM_DATE');
2337: FND_MSG_PUB.add;
2338: END IF;
2339:
2340: x_return_status := FND_API.g_ret_sts_error;
2341: RETURN;
2342: END IF;
2343:
2344: IF p_deliv_rec.actual_avail_to_date IS NULL THEN
2347: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_TO_DATE');
2348: FND_MSG_PUB.add;
2349: END IF;
2350:
2351: x_return_status := FND_API.g_ret_sts_error;
2352: RETURN;
2353: END IF;
2354:
2355: IF p_deliv_rec.forecasted_complete_date IS NULL THEN
2358: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FOREC_DATE');
2359: FND_MSG_PUB.add;
2360: END IF;
2361:
2362: x_return_status := FND_API.g_ret_sts_error;
2363: RETURN;
2364: END IF;
2365:
2366: IF p_deliv_rec.owner_user_id IS NULL THEN
2369: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_OWNER_ID');
2370: FND_MSG_PUB.add;
2371: END IF;
2372:
2373: x_return_status := FND_API.g_ret_sts_error;
2374: RETURN;
2375: END IF;
2376:
2377: IF p_deliv_rec.setup_id IS NULL THEN
2380: FND_MESSAGE.set_name('AMS', 'AMS_FUND_NO_CUSTOM_SETUP');
2381: FND_MSG_PUB.add;
2382: END IF;
2383:
2384: x_return_status := FND_API.g_ret_sts_error;
2385: RETURN;
2386: END IF;
2387:
2388: IF p_deliv_rec.country_id IS NULL THEN
2391: FND_MESSAGE.set_name('AMS', 'AMS_DILG_BAD_CITY');
2392: FND_MSG_PUB.add;
2393: END IF;
2394:
2395: x_return_status := FND_API.g_ret_sts_error;
2396: RETURN;
2397: END IF;
2398:
2399: IF p_deliv_rec.category_Type_id IS NULL THEN
2402: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_CATEGORY_ID');
2403: FND_MSG_PUB.add;
2404: END IF;
2405:
2406: x_return_status := FND_API.g_ret_sts_error;
2407: RETURN;
2408: END IF;
2409:
2410: IF p_deliv_rec.category_sub_Type_id IS NULL THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2414: FND_MSG_PUB.add;
2415: END IF;
2416:
2417: x_return_status := FND_API.g_ret_sts_error;
2418: RETURN;
2419: END IF;
2420:
2421: IF p_deliv_rec.version IS NULL THEN
2424: FND_MESSAGE.set_name('AMS', 'AMS_DELV_VERSION_MISSING');
2425: FND_MSG_PUB.add;
2426: END IF;
2427:
2428: x_return_status := FND_API.g_ret_sts_error;
2429: RETURN;
2430: END IF;
2431:
2432: IF p_deliv_rec.transaction_currency_code IS NULL THEN
2435: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2436: FND_MSG_PUB.add;
2437: END IF;
2438:
2439: x_return_status := FND_API.g_ret_sts_error;
2440: RETURN;
2441: END IF;
2442:
2443: END check_deliv_req_items;
2481:
2482:
2483: BEGIN
2484:
2485: x_return_status := FND_API.g_ret_sts_success;
2486:
2487: -- For create_deliverable, when deliverable_id is passed in, we need to
2488: -- check if this deliverable_id is unique.
2489: IF p_validation_mode = JTF_PLSQL_API.g_create
2491: THEN
2492: IF AMS_Utility_PVT.check_uniqueness(
2493: 'ams_deliverables_vl',
2494: 'deliverable_id = ' || p_deliv_rec.deliverable_id
2495: ) = FND_API.g_false
2496: THEN
2497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2498: THEN
2499: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2498: THEN
2499: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2500: FND_MSG_PUB.add;
2501: END IF;
2502: x_return_status := FND_API.g_ret_sts_error;
2503: RETURN;
2504: END IF;
2505: END IF;
2506:
2524: THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2526: FND_MSG_PUB.add;
2527: END IF;
2528: x_return_status := FND_API.g_ret_sts_error;
2529: RETURN;
2530: END IF;
2531: END IF;
2532:
2552: THEN
2553: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2554: FND_MSG_PUB.add;
2555: END IF;
2556: x_return_status := FND_API.g_ret_sts_error;
2557: RETURN;
2558: END IF;
2559: END IF;
2560:
2575: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2576: -- ''' AND deliverable_id <> ' || p_deliv_rec.deliverable_id
2577: -- );
2578: --END IF;
2579: --IF l_valid_flag = FND_API.g_false THEN
2580: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2581: -- THEN
2582: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2583: -- FND_MSG_PUB.add;
2581: -- THEN
2582: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2583: -- FND_MSG_PUB.add;
2584: -- END IF;
2585: -- x_return_status := FND_API.g_ret_sts_error;
2586: -- RETURN;
2587: --END IF;
2588:
2589: -- check other unique items
2603: )
2604: IS
2605: BEGIN
2606:
2607: x_return_status := FND_API.g_ret_sts_success;
2608: -- check other fk items
2609:
2610: --------------------- owner_user_id ------------------------
2611: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num
2607: x_return_status := FND_API.g_ret_sts_success;
2608: -- check other fk items
2609:
2610: --------------------- owner_user_id ------------------------
2611: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num
2612: THEN
2613: IF AMS_Utility_PVT.check_fk_exists(
2614: -- 'ams_jtf_rs_emp_v',
2615: 'jtf_rs_resource_extns',
2614: -- 'ams_jtf_rs_emp_v',
2615: 'jtf_rs_resource_extns',
2616: 'resource_id',
2617: p_deliv_rec.owner_user_id
2618: ) = FND_API.g_false
2619: THEN
2620: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_OWNER_USER_ID');
2621: x_return_status := FND_API.g_ret_sts_error;
2622: RETURN;
2617: p_deliv_rec.owner_user_id
2618: ) = FND_API.g_false
2619: THEN
2620: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_OWNER_USER_ID');
2621: x_return_status := FND_API.g_ret_sts_error;
2622: RETURN;
2623: END IF;
2624: END IF;
2625:
2623: END IF;
2624: END IF;
2625:
2626: --------------------- application_id ------------------------
2627: IF p_deliv_rec.application_id <> FND_API.g_miss_num
2628: THEN
2629: IF AMS_Utility_PVT.check_fk_exists(
2630: 'fnd_application',
2631: 'application_id',
2629: IF AMS_Utility_PVT.check_fk_exists(
2630: 'fnd_application',
2631: 'application_id',
2632: p_deliv_rec.application_id
2633: ) = FND_API.g_false
2634: THEN
2635: AMS_Utility_PVT.Error_Message('AMS_API_NO_APPLICATION_ID');
2636: x_return_status := FND_API.g_ret_sts_error;
2637: RETURN;
2632: p_deliv_rec.application_id
2633: ) = FND_API.g_false
2634: THEN
2635: AMS_Utility_PVT.Error_Message('AMS_API_NO_APPLICATION_ID');
2636: x_return_status := FND_API.g_ret_sts_error;
2637: RETURN;
2638: END IF;
2639: END IF;
2640:
2638: END IF;
2639: END IF;
2640:
2641: --------------------- category_type_id ------------------------
2642: IF p_deliv_rec.category_type_id <> FND_API.g_miss_num
2643: AND p_deliv_rec.category_type_id IS NOT NULL
2644: THEN
2645: IF AMS_Utility_PVT.check_fk_exists(
2646: 'ams_categories_b',
2645: IF AMS_Utility_PVT.check_fk_exists(
2646: 'ams_categories_b',
2647: 'category_id',
2648: p_deliv_rec.category_type_id
2649: ) = FND_API.g_false
2650: THEN
2651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2652: THEN
2653: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2652: THEN
2653: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2654: FND_MSG_PUB.add;
2655: END IF;
2656: x_return_status := FND_API.g_ret_sts_error;
2657: RETURN;
2658: END IF;
2659: END IF;
2660:
2658: END IF;
2659: END IF;
2660:
2661: --------------------- category_sub_type_id ------------------------
2662: IF p_deliv_rec.category_sub_type_id <> FND_API.g_miss_num
2663: AND p_deliv_rec.category_sub_type_id IS NOT NULL
2664: THEN
2665: IF AMS_Utility_PVT.check_fk_exists(
2666: 'ams_categories_b',
2665: IF AMS_Utility_PVT.check_fk_exists(
2666: 'ams_categories_b',
2667: 'category_id',
2668: p_deliv_rec.category_sub_type_id
2669: ) = FND_API.g_false
2670: THEN
2671: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2672: THEN
2673: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2672: THEN
2673: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2674: FND_MSG_PUB.add;
2675: END IF;
2676: x_return_status := FND_API.g_ret_sts_error;
2677: RETURN;
2678: END IF;
2679: END IF;
2680:
2678: END IF;
2679: END IF;
2680:
2681: --------------------- custom_setup_id ----------------------------
2682: IF p_deliv_rec.setup_id <> FND_API.g_miss_num
2683: AND p_deliv_rec.setup_id IS NOT NULL
2684: THEN
2685: IF AMS_Utility_PVT.check_fk_exists(
2686: 'ams_custom_setups_b',
2685: IF AMS_Utility_PVT.check_fk_exists(
2686: 'ams_custom_setups_b',
2687: 'custom_setup_id',
2688: p_deliv_rec.setup_id
2689: ) = FND_API.g_false
2690: THEN
2691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2692: THEN
2693: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2692: THEN
2693: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2694: FND_MSG_PUB.add;
2695: END IF;
2696: x_return_status := FND_API.g_ret_sts_error;
2697: RETURN;
2698: END IF;
2699:
2700: END IF;
2699:
2700: END IF;
2701:
2702: --------------------- country_id ----------------------------
2703: IF p_deliv_rec.country_id <> FND_API.g_miss_num
2704: AND p_deliv_rec.country_id IS NOT NULL
2705: THEN
2706: IF AMS_Utility_PVT.check_fk_exists(
2707: 'jtf_loc_hierarchies_b',
2708: 'location_hierarchy_id',
2709: p_deliv_rec.country_id,
2710: AMS_Utility_PVT.g_number,
2711: NULL
2712: ) = FND_API.g_false
2713: THEN
2714: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_COUNTRY');
2715: x_return_status := FND_API.g_ret_sts_error;
2716: RETURN;
2711: NULL
2712: ) = FND_API.g_false
2713: THEN
2714: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_COUNTRY');
2715: x_return_status := FND_API.g_ret_sts_error;
2716: RETURN;
2717: END IF;
2718: END IF;
2719:
2717: END IF;
2718: END IF;
2719:
2720: --------------------- Currency_code ----------------------------
2721: IF p_deliv_rec.currency_code <> FND_API.g_miss_char
2722: AND p_deliv_rec.currency_code IS NOT NULL
2723: THEN
2724: IF AMS_Utility_PVT.check_fk_exists(
2725: 'fnd_currencies',
2726: 'currency_code',
2727: p_deliv_rec.currency_code,
2728: AMS_Utility_PVT.g_varchar2,
2729: NULL
2730: ) = FND_API.g_false
2731: THEN
2732: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2733: x_return_status := FND_API.g_ret_sts_error;
2734: RETURN;
2729: NULL
2730: ) = FND_API.g_false
2731: THEN
2732: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2733: x_return_status := FND_API.g_ret_sts_error;
2734: RETURN;
2735: END IF;
2736: END IF;
2737:
2735: END IF;
2736: END IF;
2737:
2738: ---------------------Transaction_Currency_code ----------------------------
2739: IF p_deliv_rec.transaction_currency_code <> FND_API.g_miss_char
2740: AND p_deliv_rec.transaction_currency_code IS NOT NULL
2741: THEN
2742: IF AMS_Utility_PVT.check_fk_exists(
2743: 'fnd_currencies',
2744: 'currency_code',
2745: p_deliv_rec.transaction_currency_code,
2746: AMS_Utility_PVT.g_varchar2,
2747: NULL
2748: ) = FND_API.g_false
2749: THEN
2750: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2751: x_return_status := FND_API.g_ret_sts_error;
2752: RETURN;
2747: NULL
2748: ) = FND_API.g_false
2749: THEN
2750: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2751: x_return_status := FND_API.g_ret_sts_error;
2752: RETURN;
2753: END IF;
2754: END IF;
2755:
2753: END IF;
2754: END IF;
2755:
2756: --------------------- Language ----------------------------
2757: IF p_deliv_rec.language_code <> FND_API.g_miss_char
2758: AND p_deliv_rec.language_code IS NOT NULL
2759: THEN
2760: IF AMS_Utility_PVT.check_fk_exists(
2761: 'fnd_languages',
2762: 'language_code',
2763: p_deliv_rec.language_code,
2764: AMS_Utility_PVT.g_varchar2,
2765: NULL
2766: ) = FND_API.g_false
2767: THEN
2768: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_LANG');
2769: x_return_status := FND_API.g_ret_sts_error;
2770: RETURN;
2765: NULL
2766: ) = FND_API.g_false
2767: THEN
2768: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_LANG');
2769: x_return_status := FND_API.g_ret_sts_error;
2770: RETURN;
2771: END IF;
2772: END IF;
2773:
2786: )
2787: IS
2788: BEGIN
2789:
2790: x_return_status := FND_API.g_ret_sts_success;
2791:
2792: ----------------------- status_code ------------------------
2793: IF p_deliv_rec.status_code <> FND_API.g_miss_char THEN
2794: IF AMS_Utility_PVT.check_lookup_exists(
2789:
2790: x_return_status := FND_API.g_ret_sts_success;
2791:
2792: ----------------------- status_code ------------------------
2793: IF p_deliv_rec.status_code <> FND_API.g_miss_char THEN
2794: IF AMS_Utility_PVT.check_lookup_exists(
2795: p_lookup_type => 'AMS_DELIV_STATUS',
2796: p_lookup_code => p_deliv_rec.status_code
2797: ) = FND_API.g_false
2793: IF p_deliv_rec.status_code <> FND_API.g_miss_char THEN
2794: IF AMS_Utility_PVT.check_lookup_exists(
2795: p_lookup_type => 'AMS_DELIV_STATUS',
2796: p_lookup_code => p_deliv_rec.status_code
2797: ) = FND_API.g_false
2798: THEN
2799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2800: THEN
2801: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2801: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2802: FND_MSG_PUB.add;
2803: END IF;
2804:
2805: x_return_status := FND_API.g_ret_sts_error;
2806: RETURN;
2807: END IF;
2808: END IF;
2809:
2869: IF l_qp_profile IS NULL THEN
2870: l_qp_profile := 'N';
2871: END IF;
2872:
2873: x_return_status := FND_API.g_ret_sts_success;
2874:
2875: -- validation added for the public apis
2876:
2877: IF p_validation_mode = JTF_PLSQL_API.g_create
2879: IF NVL(p_deliv_rec.inventory_flag,'N') = 'Y'
2880: THEN
2881: AMS_UTILITY_PVT.error_message('AMS_DELV_NO_INV_CRE');
2882: --- Inventory option can be enabled only after the deliverable is created.
2883: x_return_status := FND_API.g_ret_sts_error;
2884: RETURN;
2885: END IF;
2886: END IF;
2887:
2888: IF NVL(p_deliv_rec.can_fulfill_electronic_flag,'N') = NVL(p_deliv_rec.can_fulfill_physical_flag,'N')
2889: THEN
2890: AMS_UTILITY_PVT.error_message('AMS_DELV_PHY_OR_ELEC');
2891: --Please select this deliverable as physical or electronic.
2892: x_return_status := FND_API.g_ret_sts_error;
2893: RETURN;
2894: END IF;
2895:
2896: IF NVL(p_deliv_rec.can_fulfill_electronic_flag ,'N') ='Y'
2897: AND p_deliv_rec.non_inv_quantity_on_hand > 0
2898: THEN
2899: AMS_UTILITY_PVT.error_message('AMS_DELV_NO_QUAN_ELEC');
2900: --- Quantity cannot be tracked for electronic deliverable. Please change your options
2901: x_return_status := FND_API.g_ret_sts_error;
2902: RETURN;
2903: END IF;
2904: -- validation added for the public api -- end
2905: ----------------------- rollup_flag ------------------------
2902: RETURN;
2903: END IF;
2904: -- validation added for the public api -- end
2905: ----------------------- rollup_flag ------------------------
2906: IF p_deliv_rec.kit_flag <> FND_API.g_miss_char
2907: AND p_deliv_rec.kit_flag IS NOT NULL
2908: THEN
2909: IF AMS_Utility_PVT.is_Y_or_N(p_deliv_rec.kit_flag) = FND_API.g_false
2910: THEN
2905: ----------------------- rollup_flag ------------------------
2906: IF p_deliv_rec.kit_flag <> FND_API.g_miss_char
2907: AND p_deliv_rec.kit_flag IS NOT NULL
2908: THEN
2909: IF AMS_Utility_PVT.is_Y_or_N(p_deliv_rec.kit_flag) = FND_API.g_false
2910: THEN
2911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2912: THEN
2913: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2913: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2914: FND_MSG_PUB.add;
2915: END IF;
2916:
2917: x_return_status := FND_API.g_ret_sts_error;
2918: RETURN;
2919: END IF;
2920: END IF;
2921:
2952: THEN
2953: FND_MESSAGE.set_name('AMS', 'AMS_DELV_NO_UPD_AVAL_STATUS');
2954: FND_MSG_PUB.add;
2955: END IF;
2956: x_return_status := FND_API.g_ret_sts_error;
2957: RETURN;
2958: END IF;
2959:
2960: IF (l_old_electronic_flag='N'
2964: THEN
2965: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
2966: FND_MSG_PUB.add;
2967: END IF;
2968: x_return_status := FND_API.g_ret_sts_error;
2969: RETURN;
2970: END IF;
2971:
2972:
2978: THEN
2979: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2980: FND_MSG_PUB.add;
2981: END IF;
2982: x_return_status := FND_API.g_ret_sts_error;
2983: RETURN;
2984: -- if an inv item is attached ,cannot change phy-inventoried to stock manually
2985: -- except if kit_flag is 'Y' and pricing profile is 'N'
2986: ELSIF (l_old_inventory_flag ='Y'
2992: THEN
2993: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2994: FND_MSG_PUB.add;
2995: END IF;
2996: x_return_status := FND_API.g_ret_sts_error;
2997: RETURN;
2998: END IF;
2999:
3000: IF (AMS_DEBUG_HIGH_ON) THEN
3008: THEN
3009: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3010: FND_MSG_PUB.add;
3011: END IF;
3012: x_return_status := FND_API.g_ret_sts_error;
3013: RETURN;
3014: END IF;
3015:
3016: IF (AMS_DEBUG_HIGH_ON) THEN
3023: THEN
3024: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3025: FND_MSG_PUB.add;
3026: END IF;
3027: x_return_status := FND_API.g_ret_sts_error;
3028: RETURN;
3029: END IF;
3030:
3031: --- before updating the physical and electronic flag checking whether it has kit parts
3046: THEN
3047: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3048: FND_MSG_PUB.add;
3049: END IF;
3050: x_return_status := FND_API.g_ret_sts_error;
3051: RETURN;
3052: END IF;
3053:
3054: IF (l_old_physical_flag='Y'
3059: THEN
3060: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3061: FND_MSG_PUB.add;
3062: END IF;
3063: x_return_status := FND_API.g_ret_sts_error;
3064: RETURN;
3065: END IF;
3066:
3067: IF ( p_deliv_rec.can_fulfill_physical_flag = 'Y'
3073: THEN
3074: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3075: FND_MSG_PUB.add;
3076: END IF;
3077: x_return_status := FND_API.g_ret_sts_error;
3078: RETURN;
3079: END IF;
3080:
3081: -- cannot change the stock manually deliv to physically inventoried if it as phys- inv kit.
3088: THEN
3089: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3090: FND_MSG_PUB.add;
3091: END IF;
3092: x_return_status := FND_API.g_ret_sts_error;
3093: RETURN;
3094: /*
3095: ELSIF ( p_deliv_rec.can_fulfill_physical_flag = 'Y'
3096: AND l_old_inventory_flag ='Y'
3102: THEN
3103: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3104: FND_MSG_PUB.add;
3105: END IF;
3106: x_return_status := FND_API.g_ret_sts_error;
3107: RETURN;
3108: */
3109: END IF;
3110:
3119: THEN
3120: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_N');
3121: FND_MSG_PUB.add;
3122: END IF;
3123: x_return_status := FND_API.g_ret_sts_error;
3124: RETURN;
3125: end if;
3126:
3127: l_kits_check := 0;
3135: THEN
3136: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_Y');
3137: FND_MSG_PUB.add;
3138: END IF;
3139: x_return_status := FND_API.g_ret_sts_error;
3140: RETURN;
3141: end if;
3142: -- end by abhola
3143:
3153: THEN
3154: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_KIT');
3155: FND_MSG_PUB.add;
3156: END IF;
3157: x_return_status := FND_API.g_ret_sts_error;
3158: RETURN;
3159: END IF;
3160:
3161: -- check whether the deliv is a part of a kit before updating the electronic,physical,inventory flags
3167: THEN
3168: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3169: FND_MSG_PUB.add;
3170: END IF;
3171: x_return_status := FND_API.g_ret_sts_error;
3172: RETURN;
3173: END IF;
3174:
3175: IF (l_old_physical_flag='Y'
3180: THEN
3181: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3182: FND_MSG_PUB.add;
3183: END IF;
3184: x_return_status := FND_API.g_ret_sts_error;
3185: RETURN;
3186: END IF;
3187:
3188: IF ( p_deliv_rec.can_fulfill_physical_flag = 'Y'
3194: THEN
3195: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3196: FND_MSG_PUB.add;
3197: END IF;
3198: x_return_status := FND_API.g_ret_sts_error;
3199: RETURN;
3200: END IF;
3201:
3202: -- cannot change the stock manually deliv to physically inventoried if it is part of phys- inv kit.
3209: THEN
3210: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3211: FND_MSG_PUB.add;
3212: END IF;
3213: x_return_status := FND_API.g_ret_sts_error;
3214: RETURN;
3215: END IF;
3216:
3217:
3252: ( p_deliv_rec => p_deliv_rec,
3253: x_return_status => x_return_status
3254: );
3255:
3256: IF x_return_status <> FND_API.g_ret_sts_success THEN
3257: RETURN;
3258: END IF;
3259: 01/29/03 commented out to allow user to chnage th status check bug #2764840 mukumar end */
3260:
3264: p_deliv_rec => p_deliv_rec,
3265: x_return_status => x_return_status
3266: );
3267:
3268: IF x_return_status <> FND_API.g_ret_sts_success THEN
3269: RETURN;
3270: END IF;
3271:
3272: check_deliv_uk_items
3275: p_validation_mode => p_validation_mode,
3276: x_return_status => x_return_status
3277: );
3278:
3279: IF x_return_status <> FND_API.g_ret_sts_success THEN
3280: RETURN;
3281: END IF;
3282:
3283: check_deliv_fk_items
3285: p_deliv_rec => p_deliv_rec,
3286: x_return_status => x_return_status
3287: );
3288:
3289: IF x_return_status <> FND_API.g_ret_sts_success THEN
3290: RETURN;
3291: END IF;
3292:
3293: check_deliv_lookup_items
3295: p_deliv_rec => p_deliv_rec,
3296: x_return_status => x_return_status
3297: );
3298:
3299: IF x_return_status <> FND_API.g_ret_sts_success THEN
3300: RETURN;
3301: END IF;
3302:
3303: check_deliv_flag_items
3306: p_validation_mode => p_validation_mode,
3307: x_return_status => x_return_status
3308: );
3309:
3310: IF x_return_status <> FND_API.g_ret_sts_success THEN
3311: RETURN;
3312: END IF;
3313:
3314: check_owner_id
3316: p_deliv_rec => p_deliv_Rec,
3317: x_return_status => x_return_status
3318: );
3319:
3320: IF x_return_status <> FND_API.g_ret_sts_success THEN
3321: RETURN;
3322: END IF;
3323:
3324: IF (AMS_DEBUG_HIGH_ON) THEN
3330: p_deliv_rec => p_deliv_rec,
3331: x_return_status => x_Return_status
3332: );
3333:
3334: IF x_return_status <> FND_API.g_ret_sts_success THEN
3335: RETURN;
3336: END IF;
3337:
3338: IF (AMS_DEBUG_HIGH_ON) THEN
3344: IF p_deliv_rec.start_period_name IS NOT NULL THEN
3345: OPEN c_period (p_deliv_rec.start_period_name);
3346: FETCH c_period INTO l_dummy;
3347: IF c_period%NOTFOUND THEN
3348: x_return_status := FND_API.g_ret_sts_error;
3349: AMS_Utility_PVT.error_message ('AMS_CAMP_BAD_START_PERIOD');
3350: END IF;
3351: CLOSE c_period;
3352: END IF;
3354: IF p_deliv_rec.end_period_name iS NOT NULL THEN
3355: OPEN c_period (p_deliv_rec.end_period_name);
3356: FETCH c_period INTO l_dummy;
3357: IF c_period%NOTFOUND THEN
3358: x_return_status := FND_API.g_ret_sts_error;
3359: AMS_Utility_PVT.error_message ('AMS_CAMP_BAD_END_PERIOD');
3360: END IF;
3361: CLOSE c_period;
3362: END IF;
3399: l_start_rec c_period%ROWTYPE;
3400: l_end_rec c_period%ROWTYPE;
3401: BEGIN
3402:
3403: x_return_status := FND_API.g_ret_sts_success;
3404:
3405: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3406: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3407: THEN
3401: BEGIN
3402:
3403: x_return_status := FND_API.g_ret_sts_success;
3404:
3405: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3406: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3407: THEN
3408: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3409: l_start_date := p_complete_rec.actual_avail_from_date;
3402:
3403: x_return_status := FND_API.g_ret_sts_success;
3404:
3405: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3406: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3407: THEN
3408: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3409: l_start_date := p_complete_rec.actual_avail_from_date;
3410: ELSE
3404:
3405: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3406: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3407: THEN
3408: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3409: l_start_date := p_complete_rec.actual_avail_from_date;
3410: ELSE
3411: l_start_date := p_deliv_rec.actual_avail_from_date;
3412: END IF;
3410: ELSE
3411: l_start_date := p_deliv_rec.actual_avail_from_date;
3412: END IF;
3413:
3414: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3415: l_end_date := p_complete_rec.actual_avail_to_date;
3416: ELSE
3417: l_end_date := p_deliv_rec.actual_avail_to_date;
3418: END IF;
3422: THEN
3423: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DATE_AFTER_DATE');
3424: FND_MSG_PUB.add;
3425: END IF;
3426: x_return_status := FND_API.g_ret_sts_error;
3427: END IF;
3428: END IF;
3429:
3430: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3426: x_return_status := FND_API.g_ret_sts_error;
3427: END IF;
3428: END IF;
3429:
3430: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3431: OR p_deliv_rec.forecasted_complete_date <> FND_API.g_miss_date
3432: THEN
3433: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3434: l_start_date := p_complete_rec.actual_avail_from_date;
3427: END IF;
3428: END IF;
3429:
3430: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3431: OR p_deliv_rec.forecasted_complete_date <> FND_API.g_miss_date
3432: THEN
3433: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3434: l_start_date := p_complete_rec.actual_avail_from_date;
3435: ELSE
3429:
3430: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3431: OR p_deliv_rec.forecasted_complete_date <> FND_API.g_miss_date
3432: THEN
3433: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3434: l_start_date := p_complete_rec.actual_avail_from_date;
3435: ELSE
3436: l_start_date := p_deliv_rec.actual_avail_from_date;
3437: END IF;
3435: ELSE
3436: l_start_date := p_deliv_rec.actual_avail_from_date;
3437: END IF;
3438:
3439: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3440: l_fore_comp_date := p_complete_rec.forecasted_complete_date;
3441: ELSE
3442: l_fore_comp_date := p_deliv_rec.forecasted_complete_date;
3443: END IF;
3447: THEN
3448: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_AFTER_START');
3449: FND_MSG_PUB.add;
3450: END IF;
3451: x_return_status := FND_API.g_ret_sts_error;
3452: END IF;
3453:
3454: /* remove on 06/07/2000 by khung
3455: IF p_deliv_rec.deliverable_id IS NULL THEN -- only for creation
3458: THEN
3459: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_BEFORE_TODAY');
3460: FND_MSG_PUB.add;
3461: END IF;
3462: x_return_status := FND_API.g_ret_sts_error;
3463: END IF;
3464: END IF;
3465: */
3466: END IF;
3472: -- validate calendr exists only if start or end period is chosen
3473: OPEN c_calendar (p_deliv_rec.deliverable_calendar);
3474: FETCH c_calendar INTO l_dummy;
3475: IF c_calendar%NOTFOUND THEN
3476: x_return_status := FND_API.g_ret_sts_error;
3477: AMS_Utility_PVT.error_message ('AMS_CAMP_NO_CAMPAIGN_CALENDAR');
3478: END IF;
3479: CLOSE c_calendar;
3480: END IF;
3495: -- The start period start date should be
3496: -- before the end period end date
3497: IF l_start_rec.start_date IS NOT NULL AND l_end_rec.end_date IS NOT NULL THEN
3498: IF l_start_rec.start_date > l_end_rec.end_date THEN
3499: x_return_status := FND_API.g_ret_sts_error;
3500: AMS_Utility_PVT.error_message ('AMS_CAMP_BAD_PERIODS');
3501: END IF;
3502: END IF;
3503:
3505: -- Available From date should be within
3506: -- the given start period date range.
3507: IF l_start_rec.start_date IS NOT NULL THEN
3508: IF p_complete_rec.actual_avail_from_date < l_start_rec.start_date OR p_complete_rec.actual_avail_from_date > l_start_rec.end_date THEN
3509: x_return_status := FND_API.g_ret_sts_error;
3510: AMS_Utility_PVT.error_message ('AMS_DELV_OUT_START_DATE');
3511: END IF;
3512: END IF;
3513:
3515: -- Available To date should be within the
3516: -- given end period date range.
3517: IF l_end_rec.start_date IS NOT NULL THEN
3518: IF p_complete_rec.actual_avail_to_date < l_end_rec.start_date OR p_complete_rec.actual_avail_to_date > l_end_rec.end_date THEN
3519: x_return_status := FND_API.g_ret_sts_error;
3520: AMS_Utility_PVT.error_message ('AMS_DELV_OUT_END_DATE');
3521: END IF;
3522: END IF;
3523:
3543:
3544: IF (AMS_DEBUG_HIGH_ON) THEN
3545: AMS_Utility_PVT.debug_message('IN THE INIT_DELIV REC');
3546: END IF;
3547: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3548: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3544: IF (AMS_DEBUG_HIGH_ON) THEN
3545: AMS_Utility_PVT.debug_message('IN THE INIT_DELIV REC');
3546: END IF;
3547: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3548: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3545: AMS_Utility_PVT.debug_message('IN THE INIT_DELIV REC');
3546: END IF;
3547: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3548: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3546: END IF;
3547: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3548: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3547: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3548: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3548: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3549: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3550: x_deliv_rec.creation_date := FND_API.g_miss_date;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3551: x_deliv_rec.created_by := FND_API.g_miss_num;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3552: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3553: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3554: x_deliv_rec.language_code := FND_API.g_miss_char;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3555: x_deliv_rec.version := FND_API.g_miss_char;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3556: x_deliv_rec.application_id := FND_API.g_miss_num;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3557: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3558: x_deliv_rec.status_code := FND_API.g_miss_char;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3559: x_deliv_rec.status_date := FND_API.g_miss_date;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3560: x_deliv_rec.active_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3561: x_deliv_rec.private_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3562: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3563: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3564: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3565: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3566: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3567: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3568: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3569: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3570: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3571: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3572: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3573: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3574: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3575: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3576: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3577: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3578: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3579: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3580: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3581: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3582: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3583: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3584: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3585: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3587: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3588: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3589: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3590: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3591: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3592: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3593: x_deliv_rec.currency_code := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3594: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3595: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3596: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3597: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3598: x_deliv_rec.country_id := FND_API.g_miss_num;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3599: x_deliv_rec.setup_id := FND_API.g_miss_num;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3600: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3601: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3602: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3603: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3604: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3605: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3606: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3607: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3608: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3609: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3610: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3611: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3612: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3620: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3613: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3620: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3621: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3614: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3620: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3621: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3622:
3615: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3620: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3621: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3622:
3623: END init_deliv_rec;
3616: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3620: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3621: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3622:
3623: END init_deliv_rec;
3624:
3617: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3618: x_deliv_rec.description := FND_API.g_miss_char;
3619: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3620: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3621: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3622:
3623: END init_deliv_rec;
3624:
3625: ---------------------------------------------------------------------
3662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3663: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3664: FND_MSG_PUB.add;
3665: END IF;
3666: RAISE FND_API.g_exc_error;
3667: END IF;
3668: CLOSE c_deliv;
3669:
3670: IF p_deliv_rec.language_code = FND_API.g_miss_char THEN
3666: RAISE FND_API.g_exc_error;
3667: END IF;
3668: CLOSE c_deliv;
3669:
3670: IF p_deliv_rec.language_code = FND_API.g_miss_char THEN
3671: x_complete_rec.language_code := l_deliv_rec.language_code;
3672: END IF;
3673:
3674: IF p_deliv_rec.version = FND_API.g_miss_char THEN
3670: IF p_deliv_rec.language_code = FND_API.g_miss_char THEN
3671: x_complete_rec.language_code := l_deliv_rec.language_code;
3672: END IF;
3673:
3674: IF p_deliv_rec.version = FND_API.g_miss_char THEN
3675: x_complete_rec.version := l_deliv_rec.version;
3676: END IF;
3677:
3678: IF p_deliv_rec.application_id = FND_API.g_miss_num THEN
3674: IF p_deliv_rec.version = FND_API.g_miss_char THEN
3675: x_complete_rec.version := l_deliv_rec.version;
3676: END IF;
3677:
3678: IF p_deliv_rec.application_id = FND_API.g_miss_num THEN
3679: x_complete_rec.application_id := l_deliv_rec.application_id;
3680: END IF;
3681:
3682: IF p_deliv_rec.user_status_id = FND_API.g_miss_num THEN
3678: IF p_deliv_rec.application_id = FND_API.g_miss_num THEN
3679: x_complete_rec.application_id := l_deliv_rec.application_id;
3680: END IF;
3681:
3682: IF p_deliv_rec.user_status_id = FND_API.g_miss_num THEN
3683: x_complete_rec.user_status_id := l_deliv_rec.user_status_id;
3684: END IF;
3685:
3686: IF p_deliv_rec.status_code = FND_API.g_miss_char THEN
3682: IF p_deliv_rec.user_status_id = FND_API.g_miss_num THEN
3683: x_complete_rec.user_status_id := l_deliv_rec.user_status_id;
3684: END IF;
3685:
3686: IF p_deliv_rec.status_code = FND_API.g_miss_char THEN
3687: x_complete_rec.status_code := l_deliv_rec.status_code;
3688: END IF;
3689:
3690: IF p_deliv_rec.status_date = FND_API.g_miss_date THEN
3686: IF p_deliv_rec.status_code = FND_API.g_miss_char THEN
3687: x_complete_rec.status_code := l_deliv_rec.status_code;
3688: END IF;
3689:
3690: IF p_deliv_rec.status_date = FND_API.g_miss_date THEN
3691: x_complete_rec.status_date := l_deliv_rec.status_date;
3692: END IF;
3693:
3694: IF p_deliv_rec.active_flag = FND_API.g_miss_char THEN
3690: IF p_deliv_rec.status_date = FND_API.g_miss_date THEN
3691: x_complete_rec.status_date := l_deliv_rec.status_date;
3692: END IF;
3693:
3694: IF p_deliv_rec.active_flag = FND_API.g_miss_char THEN
3695: x_complete_rec.active_flag := l_deliv_rec.active_flag;
3696: END IF;
3697:
3698: IF p_deliv_rec.private_flag = FND_API.g_miss_char THEN
3694: IF p_deliv_rec.active_flag = FND_API.g_miss_char THEN
3695: x_complete_rec.active_flag := l_deliv_rec.active_flag;
3696: END IF;
3697:
3698: IF p_deliv_rec.private_flag = FND_API.g_miss_char THEN
3699: x_complete_rec.private_flag := l_deliv_rec.private_flag;
3700: END IF;
3701:
3702: IF p_deliv_rec.owner_user_id = FND_API.g_miss_num THEN
3698: IF p_deliv_rec.private_flag = FND_API.g_miss_char THEN
3699: x_complete_rec.private_flag := l_deliv_rec.private_flag;
3700: END IF;
3701:
3702: IF p_deliv_rec.owner_user_id = FND_API.g_miss_num THEN
3703: x_complete_rec.owner_user_id := l_deliv_rec.owner_user_id;
3704: END IF;
3705:
3706: IF p_deliv_rec.fund_source_id = FND_API.g_miss_num THEN
3702: IF p_deliv_rec.owner_user_id = FND_API.g_miss_num THEN
3703: x_complete_rec.owner_user_id := l_deliv_rec.owner_user_id;
3704: END IF;
3705:
3706: IF p_deliv_rec.fund_source_id = FND_API.g_miss_num THEN
3707: x_complete_rec.fund_source_id := l_deliv_rec.fund_source_id;
3708: END IF;
3709:
3710: IF p_deliv_rec.fund_source_type = FND_API.g_miss_char THEN
3706: IF p_deliv_rec.fund_source_id = FND_API.g_miss_num THEN
3707: x_complete_rec.fund_source_id := l_deliv_rec.fund_source_id;
3708: END IF;
3709:
3710: IF p_deliv_rec.fund_source_type = FND_API.g_miss_char THEN
3711: x_complete_rec.fund_source_type := l_deliv_rec.fund_source_type;
3712: END IF;
3713:
3714: IF p_deliv_rec.category_type_id = FND_API.g_miss_num THEN
3710: IF p_deliv_rec.fund_source_type = FND_API.g_miss_char THEN
3711: x_complete_rec.fund_source_type := l_deliv_rec.fund_source_type;
3712: END IF;
3713:
3714: IF p_deliv_rec.category_type_id = FND_API.g_miss_num THEN
3715: x_complete_rec.category_type_id := l_deliv_rec.category_type_id;
3716: END IF;
3717:
3718: IF p_deliv_rec.category_sub_type_id = FND_API.g_miss_num THEN
3714: IF p_deliv_rec.category_type_id = FND_API.g_miss_num THEN
3715: x_complete_rec.category_type_id := l_deliv_rec.category_type_id;
3716: END IF;
3717:
3718: IF p_deliv_rec.category_sub_type_id = FND_API.g_miss_num THEN
3719: x_complete_rec.category_sub_type_id := l_deliv_rec.category_sub_type_id;
3720: END IF;
3721:
3722: IF p_deliv_rec.kit_flag = FND_API.g_miss_char THEN
3718: IF p_deliv_rec.category_sub_type_id = FND_API.g_miss_num THEN
3719: x_complete_rec.category_sub_type_id := l_deliv_rec.category_sub_type_id;
3720: END IF;
3721:
3722: IF p_deliv_rec.kit_flag = FND_API.g_miss_char THEN
3723: x_complete_rec.kit_flag := l_deliv_rec.kit_flag;
3724: END IF;
3725:
3726: IF p_deliv_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
3722: IF p_deliv_rec.kit_flag = FND_API.g_miss_char THEN
3723: x_complete_rec.kit_flag := l_deliv_rec.kit_flag;
3724: END IF;
3725:
3726: IF p_deliv_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
3727: x_complete_rec.can_fulfill_electronic_flag := l_deliv_rec.can_fulfill_electronic_flag;
3728: END IF;
3729:
3730: IF p_deliv_rec.can_fulfill_physical_flag = FND_API.g_miss_char THEN
3726: IF p_deliv_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
3727: x_complete_rec.can_fulfill_electronic_flag := l_deliv_rec.can_fulfill_electronic_flag;
3728: END IF;
3729:
3730: IF p_deliv_rec.can_fulfill_physical_flag = FND_API.g_miss_char THEN
3731: x_complete_rec.can_fulfill_physical_flag := l_deliv_rec.can_fulfill_physical_flag;
3732: END IF;
3733:
3734: IF p_deliv_rec.jtf_amv_item_id = FND_API.g_miss_num THEN
3730: IF p_deliv_rec.can_fulfill_physical_flag = FND_API.g_miss_char THEN
3731: x_complete_rec.can_fulfill_physical_flag := l_deliv_rec.can_fulfill_physical_flag;
3732: END IF;
3733:
3734: IF p_deliv_rec.jtf_amv_item_id = FND_API.g_miss_num THEN
3735: x_complete_rec.jtf_amv_item_id := l_deliv_rec.jtf_amv_item_id;
3736: END IF;
3737:
3738: IF p_deliv_rec.inventory_flag = FND_API.g_miss_char THEN
3734: IF p_deliv_rec.jtf_amv_item_id = FND_API.g_miss_num THEN
3735: x_complete_rec.jtf_amv_item_id := l_deliv_rec.jtf_amv_item_id;
3736: END IF;
3737:
3738: IF p_deliv_rec.inventory_flag = FND_API.g_miss_char THEN
3739: x_complete_rec.inventory_flag := l_deliv_rec.inventory_flag;
3740: END IF;
3741:
3742: IF p_deliv_rec.transaction_currency_code = FND_API.g_miss_char THEN
3738: IF p_deliv_rec.inventory_flag = FND_API.g_miss_char THEN
3739: x_complete_rec.inventory_flag := l_deliv_rec.inventory_flag;
3740: END IF;
3741:
3742: IF p_deliv_rec.transaction_currency_code = FND_API.g_miss_char THEN
3743: x_complete_rec.transaction_currency_code := l_deliv_rec.transaction_currency_code;
3744: END IF;
3745:
3746: IF p_deliv_rec.functional_currency_code = FND_API.g_miss_char THEN
3742: IF p_deliv_rec.transaction_currency_code = FND_API.g_miss_char THEN
3743: x_complete_rec.transaction_currency_code := l_deliv_rec.transaction_currency_code;
3744: END IF;
3745:
3746: IF p_deliv_rec.functional_currency_code = FND_API.g_miss_char THEN
3747: x_complete_rec.functional_currency_code := l_deliv_rec.functional_currency_code;
3748: END IF;
3749:
3750: IF p_deliv_rec.budget_amount_tc = FND_API.g_miss_num THEN
3746: IF p_deliv_rec.functional_currency_code = FND_API.g_miss_char THEN
3747: x_complete_rec.functional_currency_code := l_deliv_rec.functional_currency_code;
3748: END IF;
3749:
3750: IF p_deliv_rec.budget_amount_tc = FND_API.g_miss_num THEN
3751: x_complete_rec.budget_amount_tc := l_deliv_rec.budget_amount_tc;
3752: END IF;
3753:
3754: IF p_deliv_rec.budget_amount_fc = FND_API.g_miss_num THEN
3750: IF p_deliv_rec.budget_amount_tc = FND_API.g_miss_num THEN
3751: x_complete_rec.budget_amount_tc := l_deliv_rec.budget_amount_tc;
3752: END IF;
3753:
3754: IF p_deliv_rec.budget_amount_fc = FND_API.g_miss_num THEN
3755: x_complete_rec.budget_amount_fc := l_deliv_rec.budget_amount_fc;
3756: END IF;
3757:
3758: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3754: IF p_deliv_rec.budget_amount_fc = FND_API.g_miss_num THEN
3755: x_complete_rec.budget_amount_fc := l_deliv_rec.budget_amount_fc;
3756: END IF;
3757:
3758: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3759: x_complete_rec.actual_avail_from_date := l_deliv_rec.actual_avail_from_date;
3760: END IF;
3761:
3762: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3758: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3759: x_complete_rec.actual_avail_from_date := l_deliv_rec.actual_avail_from_date;
3760: END IF;
3761:
3762: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3763: x_complete_rec.actual_avail_to_date := l_deliv_rec.actual_avail_to_date;
3764: END IF;
3765:
3766: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3762: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3763: x_complete_rec.actual_avail_to_date := l_deliv_rec.actual_avail_to_date;
3764: END IF;
3765:
3766: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3767: x_complete_rec.forecasted_complete_date := l_deliv_rec.forecasted_complete_date;
3768: END IF;
3769:
3770: IF p_deliv_rec.actual_complete_date = FND_API.g_miss_date THEN
3766: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3767: x_complete_rec.forecasted_complete_date := l_deliv_rec.forecasted_complete_date;
3768: END IF;
3769:
3770: IF p_deliv_rec.actual_complete_date = FND_API.g_miss_date THEN
3771: x_complete_rec.actual_complete_date := l_deliv_rec.actual_complete_date;
3772: END IF;
3773:
3774: IF p_deliv_rec.replaced_by_deliverable_id = FND_API.g_miss_num THEN
3770: IF p_deliv_rec.actual_complete_date = FND_API.g_miss_date THEN
3771: x_complete_rec.actual_complete_date := l_deliv_rec.actual_complete_date;
3772: END IF;
3773:
3774: IF p_deliv_rec.replaced_by_deliverable_id = FND_API.g_miss_num THEN
3775: x_complete_rec.replaced_by_deliverable_id := l_deliv_rec.replaced_by_deliverable_id;
3776: END IF;
3777:
3778: IF p_deliv_rec.inventory_item_id = FND_API.g_miss_num THEN
3774: IF p_deliv_rec.replaced_by_deliverable_id = FND_API.g_miss_num THEN
3775: x_complete_rec.replaced_by_deliverable_id := l_deliv_rec.replaced_by_deliverable_id;
3776: END IF;
3777:
3778: IF p_deliv_rec.inventory_item_id = FND_API.g_miss_num THEN
3779: x_complete_rec.inventory_item_id := l_deliv_rec.inventory_item_id;
3780: END IF;
3781:
3782: IF p_deliv_rec.inventory_item_org_id = FND_API.g_miss_num THEN
3778: IF p_deliv_rec.inventory_item_id = FND_API.g_miss_num THEN
3779: x_complete_rec.inventory_item_id := l_deliv_rec.inventory_item_id;
3780: END IF;
3781:
3782: IF p_deliv_rec.inventory_item_org_id = FND_API.g_miss_num THEN
3783: x_complete_rec.inventory_item_org_id := l_deliv_rec.inventory_item_org_id;
3784: END IF;
3785:
3786: IF p_deliv_rec.pricelist_header_id = FND_API.g_miss_num THEN
3782: IF p_deliv_rec.inventory_item_org_id = FND_API.g_miss_num THEN
3783: x_complete_rec.inventory_item_org_id := l_deliv_rec.inventory_item_org_id;
3784: END IF;
3785:
3786: IF p_deliv_rec.pricelist_header_id = FND_API.g_miss_num THEN
3787: x_complete_rec.pricelist_header_id := l_deliv_rec.pricelist_header_id;
3788: END IF;
3789:
3790: IF p_deliv_rec.pricelist_line_id = FND_API.g_miss_num THEN
3786: IF p_deliv_rec.pricelist_header_id = FND_API.g_miss_num THEN
3787: x_complete_rec.pricelist_header_id := l_deliv_rec.pricelist_header_id;
3788: END IF;
3789:
3790: IF p_deliv_rec.pricelist_line_id = FND_API.g_miss_num THEN
3791: x_complete_rec.pricelist_line_id := l_deliv_rec.pricelist_line_id;
3792: END IF;
3793:
3794: IF p_deliv_rec.non_inv_ctrl_code = FND_API.g_miss_char THEN
3790: IF p_deliv_rec.pricelist_line_id = FND_API.g_miss_num THEN
3791: x_complete_rec.pricelist_line_id := l_deliv_rec.pricelist_line_id;
3792: END IF;
3793:
3794: IF p_deliv_rec.non_inv_ctrl_code = FND_API.g_miss_char THEN
3795: x_complete_rec.non_inv_ctrl_code := l_deliv_rec.non_inv_ctrl_code;
3796: END IF;
3797:
3798: IF p_deliv_rec.non_inv_quantity_on_hand = FND_API.g_miss_num THEN
3794: IF p_deliv_rec.non_inv_ctrl_code = FND_API.g_miss_char THEN
3795: x_complete_rec.non_inv_ctrl_code := l_deliv_rec.non_inv_ctrl_code;
3796: END IF;
3797:
3798: IF p_deliv_rec.non_inv_quantity_on_hand = FND_API.g_miss_num THEN
3799: x_complete_rec.non_inv_quantity_on_hand := l_deliv_rec.non_inv_quantity_on_hand;
3800: END IF;
3801:
3802: IF p_deliv_rec.non_inv_quantity_on_order = FND_API.g_miss_num THEN
3798: IF p_deliv_rec.non_inv_quantity_on_hand = FND_API.g_miss_num THEN
3799: x_complete_rec.non_inv_quantity_on_hand := l_deliv_rec.non_inv_quantity_on_hand;
3800: END IF;
3801:
3802: IF p_deliv_rec.non_inv_quantity_on_order = FND_API.g_miss_num THEN
3803: x_complete_rec.non_inv_quantity_on_order := l_deliv_rec.non_inv_quantity_on_order;
3804: END IF;
3805:
3806: IF p_deliv_rec.non_inv_quantity_on_reserve = FND_API.g_miss_num THEN
3802: IF p_deliv_rec.non_inv_quantity_on_order = FND_API.g_miss_num THEN
3803: x_complete_rec.non_inv_quantity_on_order := l_deliv_rec.non_inv_quantity_on_order;
3804: END IF;
3805:
3806: IF p_deliv_rec.non_inv_quantity_on_reserve = FND_API.g_miss_num THEN
3807: x_complete_rec.non_inv_quantity_on_reserve := l_deliv_rec.non_inv_quantity_on_reserve;
3808: END IF;
3809:
3810: IF p_deliv_rec.chargeback_amount = FND_API.g_miss_num THEN
3806: IF p_deliv_rec.non_inv_quantity_on_reserve = FND_API.g_miss_num THEN
3807: x_complete_rec.non_inv_quantity_on_reserve := l_deliv_rec.non_inv_quantity_on_reserve;
3808: END IF;
3809:
3810: IF p_deliv_rec.chargeback_amount = FND_API.g_miss_num THEN
3811: x_complete_rec.chargeback_amount := l_deliv_rec.chargeback_amount;
3812: END IF;
3813:
3814: IF p_deliv_rec.chargeback_amount_curr_code = FND_API.g_miss_char THEN
3810: IF p_deliv_rec.chargeback_amount = FND_API.g_miss_num THEN
3811: x_complete_rec.chargeback_amount := l_deliv_rec.chargeback_amount;
3812: END IF;
3813:
3814: IF p_deliv_rec.chargeback_amount_curr_code = FND_API.g_miss_char THEN
3815: x_complete_rec.chargeback_amount_curr_code := l_deliv_rec.chargeback_amount_curr_code;
3816: END IF;
3817:
3818: IF p_deliv_rec.deliverable_code = FND_API.g_miss_char THEN
3814: IF p_deliv_rec.chargeback_amount_curr_code = FND_API.g_miss_char THEN
3815: x_complete_rec.chargeback_amount_curr_code := l_deliv_rec.chargeback_amount_curr_code;
3816: END IF;
3817:
3818: IF p_deliv_rec.deliverable_code = FND_API.g_miss_char THEN
3819: x_complete_rec.deliverable_code := l_deliv_rec.deliverable_code;
3820: END IF;
3821:
3822: IF p_deliv_rec.deliverable_pick_flag = FND_API.g_miss_char THEN
3818: IF p_deliv_rec.deliverable_code = FND_API.g_miss_char THEN
3819: x_complete_rec.deliverable_code := l_deliv_rec.deliverable_code;
3820: END IF;
3821:
3822: IF p_deliv_rec.deliverable_pick_flag = FND_API.g_miss_char THEN
3823: x_complete_rec.deliverable_pick_flag := l_deliv_rec.deliverable_pick_flag;
3824: END IF;
3825:
3826: IF p_deliv_rec.currency_code = FND_API.g_miss_char THEN
3822: IF p_deliv_rec.deliverable_pick_flag = FND_API.g_miss_char THEN
3823: x_complete_rec.deliverable_pick_flag := l_deliv_rec.deliverable_pick_flag;
3824: END IF;
3825:
3826: IF p_deliv_rec.currency_code = FND_API.g_miss_char THEN
3827: x_complete_rec.currency_code := l_deliv_rec.currency_code;
3828: END IF;
3829:
3830: IF p_deliv_rec.forecasted_cost = FND_API.g_miss_num THEN
3826: IF p_deliv_rec.currency_code = FND_API.g_miss_char THEN
3827: x_complete_rec.currency_code := l_deliv_rec.currency_code;
3828: END IF;
3829:
3830: IF p_deliv_rec.forecasted_cost = FND_API.g_miss_num THEN
3831: x_complete_rec.forecasted_cost := l_deliv_rec.forecasted_cost;
3832: END IF;
3833:
3834: IF p_deliv_rec.actual_cost = FND_API.g_miss_num THEN
3830: IF p_deliv_rec.forecasted_cost = FND_API.g_miss_num THEN
3831: x_complete_rec.forecasted_cost := l_deliv_rec.forecasted_cost;
3832: END IF;
3833:
3834: IF p_deliv_rec.actual_cost = FND_API.g_miss_num THEN
3835: x_complete_rec.actual_cost := l_deliv_rec.actual_cost;
3836: END IF;
3837:
3838: IF p_deliv_rec.forecasted_responses = FND_API.g_miss_num THEN
3834: IF p_deliv_rec.actual_cost = FND_API.g_miss_num THEN
3835: x_complete_rec.actual_cost := l_deliv_rec.actual_cost;
3836: END IF;
3837:
3838: IF p_deliv_rec.forecasted_responses = FND_API.g_miss_num THEN
3839: x_complete_rec.forecasted_responses := l_deliv_rec.forecasted_responses;
3840: END IF;
3841:
3842: IF p_deliv_rec.actual_responses = FND_API.g_miss_num THEN
3838: IF p_deliv_rec.forecasted_responses = FND_API.g_miss_num THEN
3839: x_complete_rec.forecasted_responses := l_deliv_rec.forecasted_responses;
3840: END IF;
3841:
3842: IF p_deliv_rec.actual_responses = FND_API.g_miss_num THEN
3843: x_complete_rec.actual_responses := l_deliv_rec.actual_responses;
3844: END IF;
3845:
3846: IF p_deliv_rec.country = FND_API.g_miss_char THEN
3842: IF p_deliv_rec.actual_responses = FND_API.g_miss_num THEN
3843: x_complete_rec.actual_responses := l_deliv_rec.actual_responses;
3844: END IF;
3845:
3846: IF p_deliv_rec.country = FND_API.g_miss_char THEN
3847: x_complete_rec.country := l_deliv_rec.country;
3848: END IF;
3849:
3850: IF p_deliv_rec.attribute_category = FND_API.g_miss_char THEN
3846: IF p_deliv_rec.country = FND_API.g_miss_char THEN
3847: x_complete_rec.country := l_deliv_rec.country;
3848: END IF;
3849:
3850: IF p_deliv_rec.attribute_category = FND_API.g_miss_char THEN
3851: x_complete_rec.attribute_category := l_deliv_rec.attribute_category;
3852: END IF;
3853:
3854: IF p_deliv_rec.attribute1 = FND_API.g_miss_char THEN
3850: IF p_deliv_rec.attribute_category = FND_API.g_miss_char THEN
3851: x_complete_rec.attribute_category := l_deliv_rec.attribute_category;
3852: END IF;
3853:
3854: IF p_deliv_rec.attribute1 = FND_API.g_miss_char THEN
3855: x_complete_rec.attribute1 := l_deliv_rec.attribute1;
3856: END IF;
3857:
3858: IF p_deliv_rec.attribute2 = FND_API.g_miss_char THEN
3854: IF p_deliv_rec.attribute1 = FND_API.g_miss_char THEN
3855: x_complete_rec.attribute1 := l_deliv_rec.attribute1;
3856: END IF;
3857:
3858: IF p_deliv_rec.attribute2 = FND_API.g_miss_char THEN
3859: x_complete_rec.attribute2 := l_deliv_rec.attribute2;
3860: END IF;
3861:
3862: IF p_deliv_rec.attribute3 = FND_API.g_miss_char THEN
3858: IF p_deliv_rec.attribute2 = FND_API.g_miss_char THEN
3859: x_complete_rec.attribute2 := l_deliv_rec.attribute2;
3860: END IF;
3861:
3862: IF p_deliv_rec.attribute3 = FND_API.g_miss_char THEN
3863: x_complete_rec.attribute3 := l_deliv_rec.attribute3;
3864: END IF;
3865:
3866: IF p_deliv_rec.attribute4 = FND_API.g_miss_char THEN
3862: IF p_deliv_rec.attribute3 = FND_API.g_miss_char THEN
3863: x_complete_rec.attribute3 := l_deliv_rec.attribute3;
3864: END IF;
3865:
3866: IF p_deliv_rec.attribute4 = FND_API.g_miss_char THEN
3867: x_complete_rec.attribute4 := l_deliv_rec.attribute4;
3868: END IF;
3869:
3870: IF p_deliv_rec.attribute5 = FND_API.g_miss_char THEN
3866: IF p_deliv_rec.attribute4 = FND_API.g_miss_char THEN
3867: x_complete_rec.attribute4 := l_deliv_rec.attribute4;
3868: END IF;
3869:
3870: IF p_deliv_rec.attribute5 = FND_API.g_miss_char THEN
3871: x_complete_rec.attribute5 := l_deliv_rec.attribute5;
3872: END IF;
3873:
3874: IF p_deliv_rec.attribute6 = FND_API.g_miss_char THEN
3870: IF p_deliv_rec.attribute5 = FND_API.g_miss_char THEN
3871: x_complete_rec.attribute5 := l_deliv_rec.attribute5;
3872: END IF;
3873:
3874: IF p_deliv_rec.attribute6 = FND_API.g_miss_char THEN
3875: x_complete_rec.attribute6 := l_deliv_rec.attribute6;
3876: END IF;
3877:
3878: IF p_deliv_rec.attribute7 = FND_API.g_miss_char THEN
3874: IF p_deliv_rec.attribute6 = FND_API.g_miss_char THEN
3875: x_complete_rec.attribute6 := l_deliv_rec.attribute6;
3876: END IF;
3877:
3878: IF p_deliv_rec.attribute7 = FND_API.g_miss_char THEN
3879: x_complete_rec.attribute7 := l_deliv_rec.attribute7;
3880: END IF;
3881:
3882: IF p_deliv_rec.attribute8 = FND_API.g_miss_char THEN
3878: IF p_deliv_rec.attribute7 = FND_API.g_miss_char THEN
3879: x_complete_rec.attribute7 := l_deliv_rec.attribute7;
3880: END IF;
3881:
3882: IF p_deliv_rec.attribute8 = FND_API.g_miss_char THEN
3883: x_complete_rec.attribute8 := l_deliv_rec.attribute8;
3884: END IF;
3885:
3886: IF p_deliv_rec.attribute9 = FND_API.g_miss_char THEN
3882: IF p_deliv_rec.attribute8 = FND_API.g_miss_char THEN
3883: x_complete_rec.attribute8 := l_deliv_rec.attribute8;
3884: END IF;
3885:
3886: IF p_deliv_rec.attribute9 = FND_API.g_miss_char THEN
3887: x_complete_rec.attribute9 := l_deliv_rec.attribute9;
3888: END IF;
3889:
3890: IF p_deliv_rec.attribute10 = FND_API.g_miss_char THEN
3886: IF p_deliv_rec.attribute9 = FND_API.g_miss_char THEN
3887: x_complete_rec.attribute9 := l_deliv_rec.attribute9;
3888: END IF;
3889:
3890: IF p_deliv_rec.attribute10 = FND_API.g_miss_char THEN
3891: x_complete_rec.attribute10 := l_deliv_rec.attribute10;
3892: END IF;
3893:
3894: IF p_deliv_rec.attribute11 = FND_API.g_miss_char THEN
3890: IF p_deliv_rec.attribute10 = FND_API.g_miss_char THEN
3891: x_complete_rec.attribute10 := l_deliv_rec.attribute10;
3892: END IF;
3893:
3894: IF p_deliv_rec.attribute11 = FND_API.g_miss_char THEN
3895: x_complete_rec.attribute11 := l_deliv_rec.attribute11;
3896: END IF;
3897:
3898: IF p_deliv_rec.attribute12 = FND_API.g_miss_char THEN
3894: IF p_deliv_rec.attribute11 = FND_API.g_miss_char THEN
3895: x_complete_rec.attribute11 := l_deliv_rec.attribute11;
3896: END IF;
3897:
3898: IF p_deliv_rec.attribute12 = FND_API.g_miss_char THEN
3899: x_complete_rec.attribute12 := l_deliv_rec.attribute12;
3900: END IF;
3901:
3902: IF p_deliv_rec.attribute13 = FND_API.g_miss_char THEN
3898: IF p_deliv_rec.attribute12 = FND_API.g_miss_char THEN
3899: x_complete_rec.attribute12 := l_deliv_rec.attribute12;
3900: END IF;
3901:
3902: IF p_deliv_rec.attribute13 = FND_API.g_miss_char THEN
3903: x_complete_rec.attribute13 := l_deliv_rec.attribute13;
3904: END IF;
3905:
3906: IF p_deliv_rec.attribute14 = FND_API.g_miss_char THEN
3902: IF p_deliv_rec.attribute13 = FND_API.g_miss_char THEN
3903: x_complete_rec.attribute13 := l_deliv_rec.attribute13;
3904: END IF;
3905:
3906: IF p_deliv_rec.attribute14 = FND_API.g_miss_char THEN
3907: x_complete_rec.attribute14 := l_deliv_rec.attribute14;
3908: END IF;
3909:
3910: IF p_deliv_rec.attribute15 = FND_API.g_miss_char THEN
3906: IF p_deliv_rec.attribute14 = FND_API.g_miss_char THEN
3907: x_complete_rec.attribute14 := l_deliv_rec.attribute14;
3908: END IF;
3909:
3910: IF p_deliv_rec.attribute15 = FND_API.g_miss_char THEN
3911: x_complete_rec.attribute15 := l_deliv_rec.attribute15;
3912: END IF;
3913:
3914: IF p_deliv_rec.chargeback_uom = FND_API.g_miss_char THEN
3910: IF p_deliv_rec.attribute15 = FND_API.g_miss_char THEN
3911: x_complete_rec.attribute15 := l_deliv_rec.attribute15;
3912: END IF;
3913:
3914: IF p_deliv_rec.chargeback_uom = FND_API.g_miss_char THEN
3915: x_complete_rec.chargeback_uom := l_deliv_rec.chargeback_uom;
3916: END IF;
3917:
3918: IF p_deliv_rec.deliverable_name = FND_API.g_miss_char THEN
3914: IF p_deliv_rec.chargeback_uom = FND_API.g_miss_char THEN
3915: x_complete_rec.chargeback_uom := l_deliv_rec.chargeback_uom;
3916: END IF;
3917:
3918: IF p_deliv_rec.deliverable_name = FND_API.g_miss_char THEN
3919: x_complete_rec.deliverable_name := l_deliv_rec.deliverable_name;
3920: END IF;
3921:
3922: IF p_deliv_rec.description = FND_API.g_miss_char THEN
3918: IF p_deliv_rec.deliverable_name = FND_API.g_miss_char THEN
3919: x_complete_rec.deliverable_name := l_deliv_rec.deliverable_name;
3920: END IF;
3921:
3922: IF p_deliv_rec.description = FND_API.g_miss_char THEN
3923: x_complete_rec.description := l_deliv_rec.description;
3924: END IF;
3925:
3926: IF p_deliv_rec.deliverable_calendar = FND_API.g_miss_char THEN
3922: IF p_deliv_rec.description = FND_API.g_miss_char THEN
3923: x_complete_rec.description := l_deliv_rec.description;
3924: END IF;
3925:
3926: IF p_deliv_rec.deliverable_calendar = FND_API.g_miss_char THEN
3927: x_complete_rec.deliverable_calendar := l_deliv_rec.deliverable_calendar;
3928: END IF;
3929:
3930: IF p_deliv_rec.start_period_name = FND_API.g_miss_char THEN
3926: IF p_deliv_rec.deliverable_calendar = FND_API.g_miss_char THEN
3927: x_complete_rec.deliverable_calendar := l_deliv_rec.deliverable_calendar;
3928: END IF;
3929:
3930: IF p_deliv_rec.start_period_name = FND_API.g_miss_char THEN
3931: x_complete_rec.start_period_name := l_deliv_rec.start_period_name;
3932: END IF;
3933:
3934: IF p_deliv_rec.end_period_name = FND_API.g_miss_char THEN
3930: IF p_deliv_rec.start_period_name = FND_API.g_miss_char THEN
3931: x_complete_rec.start_period_name := l_deliv_rec.start_period_name;
3932: END IF;
3933:
3934: IF p_deliv_rec.end_period_name = FND_API.g_miss_char THEN
3935: x_complete_rec.end_period_name := l_deliv_rec.end_period_name;
3936: END IF;
3937:
3938: IF p_deliv_rec.country_id = FND_API.g_miss_num THEN
3934: IF p_deliv_rec.end_period_name = FND_API.g_miss_char THEN
3935: x_complete_rec.end_period_name := l_deliv_rec.end_period_name;
3936: END IF;
3937:
3938: IF p_deliv_rec.country_id = FND_API.g_miss_num THEN
3939: x_complete_rec.country_id := l_deliv_rec.country_id;
3940: END IF;
3941:
3942: IF p_deliv_rec.Setup_id = FND_API.g_miss_num THEN
3938: IF p_deliv_rec.country_id = FND_API.g_miss_num THEN
3939: x_complete_rec.country_id := l_deliv_rec.country_id;
3940: END IF;
3941:
3942: IF p_deliv_rec.Setup_id = FND_API.g_miss_num THEN
3943: x_complete_rec.Setup_id := l_deliv_rec.custom_setup_id;
3944: END IF;
3945:
3946: END complete_deliv_rec;
3956:
3957: PROCEDURE create_pricelist_header
3958: (
3959: p_api_version IN NUMBER,
3960: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3961: p_return_values IN VARCHAR2 := FND_API.g_false,
3962: p_commit IN VARCHAR2 := FND_API.g_false,
3963: p_deliv_rec IN deliv_rec_type,
3964: x_return_status OUT NOCOPY VARCHAR2,
3957: PROCEDURE create_pricelist_header
3958: (
3959: p_api_version IN NUMBER,
3960: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3961: p_return_values IN VARCHAR2 := FND_API.g_false,
3962: p_commit IN VARCHAR2 := FND_API.g_false,
3963: p_deliv_rec IN deliv_rec_type,
3964: x_return_status OUT NOCOPY VARCHAR2,
3965: x_msg_count OUT NOCOPY NUMBER,
3958: (
3959: p_api_version IN NUMBER,
3960: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3961: p_return_values IN VARCHAR2 := FND_API.g_false,
3962: p_commit IN VARCHAR2 := FND_API.g_false,
3963: p_deliv_rec IN deliv_rec_type,
3964: x_return_status OUT NOCOPY VARCHAR2,
3965: x_msg_count OUT NOCOPY NUMBER,
3966: x_msg_data OUT NOCOPY VARCHAR2,
3996:
3997: BEGIN
3998:
3999: --dbms_output.put_line('create List header called');
4000: x_return_status := FND_API.g_ret_sts_success;
4001:
4002: p_price_list_rec.name := 'Deliverable Inventory HDR';
4003: p_price_list_rec.created_by := p_deliv_rec.owner_user_id;
4004: p_price_list_rec.creation_date := sysdate;
4014: END IF;
4015:
4016: QP_PRICE_LIST_PUB.Process_Price_List(
4017: p_api_version_number => 1.0,
4018: p_init_msg_list => FND_API.g_false,
4019: p_return_values => FND_API.G_TRUE,
4020: p_commit => FND_API.g_false,
4021: x_return_status => l_return_status,
4022: x_msg_count => l_msg_count,
4015:
4016: QP_PRICE_LIST_PUB.Process_Price_List(
4017: p_api_version_number => 1.0,
4018: p_init_msg_list => FND_API.g_false,
4019: p_return_values => FND_API.G_TRUE,
4020: p_commit => FND_API.g_false,
4021: x_return_status => l_return_status,
4022: x_msg_count => l_msg_count,
4023: x_msg_data => l_msg_data,
4016: QP_PRICE_LIST_PUB.Process_Price_List(
4017: p_api_version_number => 1.0,
4018: p_init_msg_list => FND_API.g_false,
4019: p_return_values => FND_API.G_TRUE,
4020: p_commit => FND_API.g_false,
4021: x_return_status => l_return_status,
4022: x_msg_count => l_msg_count,
4023: x_msg_data => l_msg_data,
4024: p_price_list_rec => p_price_list_rec,
4041:
4042: x_pricelist_header_id := l_price_list_rec.list_header_id;
4043: x_return_status := l_return_status;
4044:
4045: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4046: RAISE FND_API.g_exc_unexpected_error;
4047: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4048: RAISE FND_API.g_exc_error;
4049: END IF;
4042: x_pricelist_header_id := l_price_list_rec.list_header_id;
4043: x_return_status := l_return_status;
4044:
4045: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4046: RAISE FND_API.g_exc_unexpected_error;
4047: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4048: RAISE FND_API.g_exc_error;
4049: END IF;
4050:
4043: x_return_status := l_return_status;
4044:
4045: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4046: RAISE FND_API.g_exc_unexpected_error;
4047: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4048: RAISE FND_API.g_exc_error;
4049: END IF;
4050:
4051: IF p_commit = FND_API.g_true THEN
4044:
4045: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4046: RAISE FND_API.g_exc_unexpected_error;
4047: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4048: RAISE FND_API.g_exc_error;
4049: END IF;
4050:
4051: IF p_commit = FND_API.g_true THEN
4052: COMMIT WORK;
4047: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4048: RAISE FND_API.g_exc_error;
4049: END IF;
4050:
4051: IF p_commit = FND_API.g_true THEN
4052: COMMIT WORK;
4053: END IF;
4054: END create_pricelist_header;
4055:
4063:
4064: PROCEDURE create_pricelist_line
4065: (
4066: p_api_version IN NUMBER,
4067: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4068: p_return_values IN VARCHAR2 := FND_API.g_false,
4069: p_commit IN VARCHAR2 := FND_API.g_false,
4070: p_price_hdr_id IN NUMBER,
4071: p_deliv_rec IN deliv_rec_type,
4064: PROCEDURE create_pricelist_line
4065: (
4066: p_api_version IN NUMBER,
4067: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4068: p_return_values IN VARCHAR2 := FND_API.g_false,
4069: p_commit IN VARCHAR2 := FND_API.g_false,
4070: p_price_hdr_id IN NUMBER,
4071: p_deliv_rec IN deliv_rec_type,
4072: x_return_status OUT NOCOPY VARCHAR2,
4065: (
4066: p_api_version IN NUMBER,
4067: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4068: p_return_values IN VARCHAR2 := FND_API.g_false,
4069: p_commit IN VARCHAR2 := FND_API.g_false,
4070: p_price_hdr_id IN NUMBER,
4071: p_deliv_rec IN deliv_rec_type,
4072: x_return_status OUT NOCOPY VARCHAR2,
4073: x_msg_count OUT NOCOPY NUMBER,
4103:
4104: BEGIN
4105:
4106: --dbms_output.put_line('create List line called');
4107: x_return_status := FND_API.g_ret_sts_success;
4108:
4109: p_price_list_line_tbl(1).list_header_id := p_price_hdr_id;
4110: --dbms_output.put_line('p_price_hdr_id: '||p_price_hdr_id);
4111: p_price_list_line_tbl(1).list_line_type_code := 'PLL';
4116: p_price_list_line_tbl(1).end_date_active := p_deliv_rec.actual_avail_to_date;
4117: p_price_list_line_tbl(1).organization_id := p_deliv_rec.inventory_item_org_id;
4118: p_price_list_line_tbl(1).operation :=QP_GLOBALS.G_OPR_CREATE;
4119: p_price_list_line_tbl(1).automatic_flag := 'Y';
4120: -- if p_deliv_rec.PRICELIST_LIST_PRICE is NULL or p_deliv_rec.PRICELIST_LIST_PRICE = FND_API.g_miss_num then
4121: p_price_list_line_tbl(1).list_price := 0;
4122: --else
4123: --p_price_list_line_tbl(1).list_price := p_deliv_rec.PRICELIST_LIST_PRICE;
4124: --end if;
4128: END IF;
4129:
4130: QP_PRICE_LIST_PUB.Process_Price_List(
4131: p_api_version_number => 1.0,
4132: p_init_msg_list => FND_API.g_false,
4133: p_return_values => FND_API.G_TRUE,
4134: p_commit => FND_API.g_false,
4135: x_return_status => l_return_status,
4136: x_msg_count => l_msg_count,
4129:
4130: QP_PRICE_LIST_PUB.Process_Price_List(
4131: p_api_version_number => 1.0,
4132: p_init_msg_list => FND_API.g_false,
4133: p_return_values => FND_API.G_TRUE,
4134: p_commit => FND_API.g_false,
4135: x_return_status => l_return_status,
4136: x_msg_count => l_msg_count,
4137: x_msg_data => l_msg_data,
4130: QP_PRICE_LIST_PUB.Process_Price_List(
4131: p_api_version_number => 1.0,
4132: p_init_msg_list => FND_API.g_false,
4133: p_return_values => FND_API.G_TRUE,
4134: p_commit => FND_API.g_false,
4135: x_return_status => l_return_status,
4136: x_msg_count => l_msg_count,
4137: x_msg_data => l_msg_data,
4138: p_price_list_rec => p_price_list_rec,
4155:
4156: x_pricelist_line_id := l_PRICE_LIST_LINE_tbl(1).list_line_id;
4157: x_return_status := l_return_status;
4158:
4159: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4160: RAISE FND_API.g_exc_unexpected_error;
4161: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4162: RAISE FND_API.g_exc_error;
4163: END IF;
4156: x_pricelist_line_id := l_PRICE_LIST_LINE_tbl(1).list_line_id;
4157: x_return_status := l_return_status;
4158:
4159: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4160: RAISE FND_API.g_exc_unexpected_error;
4161: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4162: RAISE FND_API.g_exc_error;
4163: END IF;
4164:
4157: x_return_status := l_return_status;
4158:
4159: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4160: RAISE FND_API.g_exc_unexpected_error;
4161: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4162: RAISE FND_API.g_exc_error;
4163: END IF;
4164:
4165: IF p_commit = FND_API.g_true THEN
4158:
4159: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4160: RAISE FND_API.g_exc_unexpected_error;
4161: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4162: RAISE FND_API.g_exc_error;
4163: END IF;
4164:
4165: IF p_commit = FND_API.g_true THEN
4166: COMMIT WORK;
4161: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4162: RAISE FND_API.g_exc_error;
4163: END IF;
4164:
4165: IF p_commit = FND_API.g_true THEN
4166: COMMIT WORK;
4167: END IF;
4168: END create_pricelist_line;
4169:
4183:
4184: l_api_name CONSTANT VARCHAR2(30) := 'create_jtf_attachment';
4185:
4186: l_api_version NUMBER := 1.0;
4187: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
4188: l_commit VARCHAR2(1) := FND_API.g_false;
4189: l_validation_level NUMBER := FND_API.g_valid_level_full;
4190: l_return_status VARCHAR2(1);
4191: l_msg_count NUMBER;
4184: l_api_name CONSTANT VARCHAR2(30) := 'create_jtf_attachment';
4185:
4186: l_api_version NUMBER := 1.0;
4187: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
4188: l_commit VARCHAR2(1) := FND_API.g_false;
4189: l_validation_level NUMBER := FND_API.g_valid_level_full;
4190: l_return_status VARCHAR2(1);
4191: l_msg_count NUMBER;
4192: l_msg_data VARCHAR2(2000);
4185:
4186: l_api_version NUMBER := 1.0;
4187: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
4188: l_commit VARCHAR2(1) := FND_API.g_false;
4189: l_validation_level NUMBER := FND_API.g_valid_level_full;
4190: l_return_status VARCHAR2(1);
4191: l_msg_count NUMBER;
4192: l_msg_data VARCHAR2(2000);
4193:
4195: l_att_id NUMBER;
4196:
4197: BEGIN
4198:
4199: x_return_status := FND_API.g_ret_sts_success;
4200:
4201: l_att_rec.attachment_used_by := p_used_by;
4202: l_att_rec.attachment_used_by_id := p_used_by_id;
4203: l_att_rec.file_id := p_file_id;
4276: FROM ams_event_offers_vl
4277: WHERE event_offer_id = l_master_object_id;
4278:
4279: BEGIN
4280: x_return_status := FND_API.g_ret_sts_success;
4281: OPEN c_parent_deliv(p_deliverable_rec.deliverable_id);
4282: LOOP
4283: FETCH c_parent_deliv INTO l_parent_deliv_rec;
4284: EXIT WHEN c_parent_deliv%NOTFOUND;
4347: WHEN others THEN
4348: IF c_parent_deliv%ISOPEN THEN
4349: CLOSE c_parent_deliv;
4350: END IF;
4351: x_return_status := FND_API.g_ret_sts_unexp_error ;
4352: IF (AMS_DEBUG_HIGH_ON) THEN
4353:
4354: AMS_UTILITY_PVT.debug_message(l_full_name||' Unhandled Error');
4355: END IF;
4379:
4380:
4381: BEGIN
4382:
4383: x_return_status := FND_API.g_ret_sts_success;
4384:
4385: OPEN c_get_period_dets(p_deliv_rec.deliverable_id);
4386: FETCH c_get_period_dets INTO l_get_period_cur;
4387: CLOSE c_get_period_dets;
4401:
4402:
4403: EXCEPTION
4404: WHEN OTHERS THEN
4405: x_return_status := FND_API.g_ret_sts_unexp_error ;
4406: END check_periods;
4407:
4408: -------------------------------------------------------------------
4409: -- PROCEDURE
4428: l_resource_id NUMBER := AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.User_id);
4429:
4430: BEGIN
4431:
4432: x_return_status := FND_API.g_ret_sts_success;
4433:
4434:
4435: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num THEN
4436:
4431:
4432: x_return_status := FND_API.g_ret_sts_success;
4433:
4434:
4435: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num THEN
4436:
4437: OPEN c_owner_id(p_deliv_rec.deliverable_id);
4438: FETCH c_owner_id INTO l_owner_user_id;
4439: CLOSE c_owner_id;
4448: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_OWNER');
4449: FND_MSG_PUB.add;
4450: END IF;
4451:
4452: x_return_status := FND_API.g_ret_sts_error;
4453: RETURN;
4454:
4455: END IF;
4456: END IF;
4491: l_budget_lines VARCHAR2(1) := 'N';
4492:
4493: BEGIN
4494:
4495: x_return_status := FND_API.g_ret_sts_success;
4496:
4497: IF p_deliv_rec.currency_code <> FND_API.g_miss_char THEN
4498:
4499: OPEN get_currency_code(p_deliv_rec.deliverable_id);
4493: BEGIN
4494:
4495: x_return_status := FND_API.g_ret_sts_success;
4496:
4497: IF p_deliv_rec.currency_code <> FND_API.g_miss_char THEN
4498:
4499: OPEN get_currency_code(p_deliv_rec.deliverable_id);
4500: FETCH get_currency_code INTO l_currency_code;
4501: CLOSE get_currency_code;
4510: THEN
4511: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_CURRENCY');
4512: FND_MSG_PUB.add;
4513: END IF;
4514: x_return_status := FND_API.g_ret_sts_error;
4515: RETURN;
4516: END IF;
4517: END IF;
4518: END IF;
4545: FETCH c_custom_attr INTO l_flag ;
4546: CLOSE c_custom_attr ;
4547:
4548: IF l_flag = 'Y' THEN
4549: l_flag := FND_API.g_true;
4550: ELSIF l_flag = 'N' THEN
4551: l_flag := FND_API.g_false;
4552: END IF;
4553:
4547:
4548: IF l_flag = 'Y' THEN
4549: l_flag := FND_API.g_true;
4550: ELSIF l_flag = 'N' THEN
4551: l_flag := FND_API.g_false;
4552: END IF;
4553:
4554: RETURN l_flag ;
4555:
4592: x_item_owner_id NUMBER;
4593:
4594: BEGIN
4595:
4596: x_return_status := FND_API.g_ret_sts_success;
4597: -- Begin Inventory creation
4598:
4599: IF l_qp_profile IS NULL THEN
4600: l_qp_profile := 'N';
4608: AMS_Utility_PVT.debug_message(l_full_name ||' Price Profile :'||l_qp_profile);
4609: END IF;
4610:
4611: IF (p_deliv_rec.item_number IS NULL
4612: OR p_deliv_rec.item_number = FND_API.g_miss_char)
4613: THEN
4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4615: THEN
4616: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4615: THEN
4616: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4617: FND_MSG_PUB.add;
4618: END IF;
4619: x_return_status := FND_API.g_ret_sts_error;
4620: RETURN;
4621: END IF;
4622:
4623: IF (l_org_Id IS NULL)
4626: THEN
4627: FND_MESSAGE.set_name('AMS', 'AMS_PROD_PROFILE_TIP');
4628: FND_MSG_PUB.add;
4629: END IF;
4630: x_return_status := FND_API.g_ret_sts_error;
4631: RETURN;
4632: END IF;
4633:
4634:
4668: x_Error_tbl => x_error_tbl );
4669:
4670: /*
4671: INV_Item_GRP.Create_Item
4672: ( p_commit => FND_API.g_false
4673: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4674: , p_Item_rec => l_item_rec
4675: , x_Item_rec => x_item_rec
4676: , x_return_status => x_return_status
4669:
4670: /*
4671: INV_Item_GRP.Create_Item
4672: ( p_commit => FND_API.g_false
4673: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4674: , p_Item_rec => l_item_rec
4675: , x_Item_rec => x_item_rec
4676: , x_return_status => x_return_status
4677: , x_Error_tbl => x_error_tbl
4682: IF (AMS_DEBUG_HIGH_ON) THEN
4683: AMS_Utility_PVT.debug_message(l_full_name ||' Status of Inv API '||x_return_status);
4684: END IF;
4685:
4686: IF ( x_return_status <> FND_API.g_ret_sts_success
4687: OR x_item_return_status <> FND_API.g_ret_sts_success )
4688: THEN
4689: RAISE inv_creation_error;
4690: ELSE
4683: AMS_Utility_PVT.debug_message(l_full_name ||' Status of Inv API '||x_return_status);
4684: END IF;
4685:
4686: IF ( x_return_status <> FND_API.g_ret_sts_success
4687: OR x_item_return_status <> FND_API.g_ret_sts_success )
4688: THEN
4689: RAISE inv_creation_error;
4690: ELSE
4691: x_inv_id := x_item_rec.inventory_item_id;
4693: END IF;
4694:
4695: EXCEPTION
4696: WHEN inv_creation_error THEN
4697: IF x_item_return_status <> FND_API.g_ret_sts_success
4698: THEN
4699: x_msg_count := x_error_tbl.count;
4700: FOR i IN 1 .. x_error_tbl.count LOOP
4701: /*
4699: x_msg_count := x_error_tbl.count;
4700: FOR i IN 1 .. x_error_tbl.count LOOP
4701: /*
4702: FND_MSG_PUB.count_and_get(
4703: p_encoded => FND_API.g_false,
4704: p_count => x_msg_count,
4705: p_data => x_error_tbl(i).message_text
4706: ); */
4707: IF x_error_tbl(i).message_name IS NOT NULL
4717: AMS_Utility_PVT.debug_message(l_full_name ||'the error text is '||x_error_tbl(i).message_text);
4718: END IF;
4719: END LOOP;
4720: END IF;
4721: x_return_status := FND_API.g_ret_sts_error;
4722: RETURN;
4723: END creat_inv_item;
4724:
4725: -------------------------------------------------------------------
4747: l_active_flag VARCHAR2(1) := 'Y';
4748:
4749: BEGIN
4750:
4751: x_return_status := FND_API.g_ret_sts_success;
4752:
4753: OPEN get_active_flag(p_deliv_rec.deliverable_id);
4754: FETCH get_active_flag INTO l_active_flag;
4755: CLOSE get_active_flag;
4760: THEN
4761: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_INACTIVE');
4762: FND_MSG_PUB.add;
4763: END IF;
4764: x_return_status := FND_API.g_ret_sts_error;
4765: RETURN;
4766: END IF;
4767:
4768: IF (AMS_DEBUG_HIGH_ON) THEN
4806: l_active_flag VARCHAR2(1) := 'Y';
4807:
4808: BEGIN
4809:
4810: x_return_status := FND_API.g_ret_sts_success;
4811:
4812: OPEN get_flag(p_deliv_rec.inventory_item_id,p_deliv_rec.inventory_item_org_id);
4813: FETCH get_flag INTO l_flag_rec;
4814: CLOSE get_flag;
4824: THEN
4825: AMS_UTILITY_PVT.error_message('AMS_DELV_API_BAD_INV');
4826: --Program Error: Inventory item passed to the API ,should hava the value set to "Y" for the following flags collateral_flag
4827: --,costing_enabled_flag,customer_order_flag,customer_order_enabled_flag,shippable_item_flag.
4828: x_return_status := FND_API.g_ret_sts_error;
4829: RETURN;
4830: END IF;
4831: ELSE
4832: IF l_flag_rec.collateral_flag = 'N'
4832: IF l_flag_rec.collateral_flag = 'N'
4833: THEN
4834: AMS_UTILITY_PVT.error_message('AMS_DELV_API_BAD_INV_COLL');
4835: --Program Error: Inventory item passed to the API ,should have the value set to "Y" for collateral_flag
4836: x_return_status := FND_API.g_ret_sts_error;
4837: RETURN;
4838: END IF;
4839: END IF;
4840: