[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
616: END IF;
617:
618: AMS_ObjectAttribute_PVT.create_object_attributes(
619: l_api_version,
620: FND_API.g_false, -- p_init_msg_list - use same message queue as the calling API
621: FND_API.g_false, -- p_commit - commiting will cause problem with rollback in the calling API
622: p_validation_level,
623: l_return_status,
624: x_msg_count,
617:
618: AMS_ObjectAttribute_PVT.create_object_attributes(
619: l_api_version,
620: FND_API.g_false, -- p_init_msg_list - use same message queue as the calling API
621: FND_API.g_false, -- p_commit - commiting will cause problem with rollback in the calling API
622: p_validation_level,
623: l_return_status,
624: x_msg_count,
625: x_msg_data,
627: l_obj_id,
628: l_setup_id
629: );
630:
631: IF l_return_status = FND_API.g_ret_sts_error THEN
632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: END IF;
628: l_setup_id
629: );
630:
631: IF l_return_status = FND_API.g_ret_sts_error THEN
632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: END IF;
636: */
629: );
630:
631: IF l_return_status = FND_API.g_ret_sts_error THEN
632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: END IF;
636: */
637: l_access_rec.act_access_to_object_id := l_obj_id;
630:
631: IF l_return_status = FND_API.g_ret_sts_error THEN
632: RAISE FND_API.g_exc_error;
633: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
634: RAISE FND_API.g_exc_unexpected_error;
635: END IF;
636: */
637: l_access_rec.act_access_to_object_id := l_obj_id;
638: l_access_rec.arc_act_access_to_object := l_obj_type;
651: l_access_rec.admin_flag := 'Y'; /* bug fix for Hp: */
652: l_access_rec.delete_flag := 'N';
653: AMS_Access_PVT.create_access (
654: p_api_version => 1.0,
655: p_init_msg_list => FND_API.G_FALSE,
656: p_commit => FND_API.G_FALSE,
657: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
658: x_return_status => x_return_status,
659: x_msg_count => x_msg_count,
652: l_access_rec.delete_flag := 'N';
653: AMS_Access_PVT.create_access (
654: p_api_version => 1.0,
655: p_init_msg_list => FND_API.G_FALSE,
656: p_commit => FND_API.G_FALSE,
657: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
658: x_return_status => x_return_status,
659: x_msg_count => x_msg_count,
660: x_msg_data => x_msg_data,
653: AMS_Access_PVT.create_access (
654: p_api_version => 1.0,
655: p_init_msg_list => FND_API.G_FALSE,
656: p_commit => FND_API.G_FALSE,
657: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
658: x_return_status => x_return_status,
659: x_msg_count => x_msg_count,
660: x_msg_data => x_msg_data,
661: p_access_rec => l_access_rec,
660: x_msg_data => x_msg_data,
661: p_access_rec => l_access_rec,
662: x_access_id => l_access_rec.activity_access_id
663: );
664: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667:
668:
661: p_access_rec => l_access_rec,
662: x_access_id => l_access_rec.activity_access_id
663: );
664: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667:
668:
669: /*added by musman this to create jtf_Amv_item_item if it is a electronic deliverable */
686: p_deliv_rec => x_deliv_rec
687: );
688: END IF;
689:
690: IF l_return_status <> FND_API.g_ret_sts_success THEN
691: IF (AMS_DEBUG_HIGH_ON) THEN
692:
693: AMS_Utility_PVT.debug_message(l_full_name||': in the exception of call to update');
694: END IF;
693: AMS_Utility_PVT.debug_message(l_full_name||': in the exception of call to update');
694: END IF;
695: x_msg_count := l_msg_count;
696: x_msg_data := l_msg_data;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700:
701: -- attach seeded metrics
712: p_act_metric_used_by_id => l_deliv_rec.deliverable_id,
713: p_act_metric_used_by_type => NULL
714: );
715:
716: IF l_return_status = FND_API.g_ret_sts_error THEN
717: RAISE FND_API.g_exc_error;
718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
719: RAISE FND_API.g_exc_unexpected_error;
720: END IF;
713: p_act_metric_used_by_type => NULL
714: );
715:
716: IF l_return_status = FND_API.g_ret_sts_error THEN
717: RAISE FND_API.g_exc_error;
718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
719: RAISE FND_API.g_exc_unexpected_error;
720: END IF;
721:
714: );
715:
716: IF l_return_status = FND_API.g_ret_sts_error THEN
717: RAISE FND_API.g_exc_error;
718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
719: RAISE FND_API.g_exc_unexpected_error;
720: END IF;
721:
722:
715:
716: IF l_return_status = FND_API.g_ret_sts_error THEN
717: RAISE FND_API.g_exc_error;
718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
719: RAISE FND_API.g_exc_unexpected_error;
720: END IF;
721:
722:
723: -- create task
735:
736: AMS_TASK_PVT.Create_task
737: (
738: p_api_version => l_api_version,
739: p_init_msg_list => FND_API.g_false, -- use the same message queue as the calling API
740: p_commit => FND_API.g_false, -- committing in the called api will cause problems with rollback in the calling API
741: p_task_id => NULL,
742: p_task_name => l_trim_task_name, -- 'Prep. task for - '||l_deliv_rec.deliverable_name,
743: p_task_type_id => 15,
736: AMS_TASK_PVT.Create_task
737: (
738: p_api_version => l_api_version,
739: p_init_msg_list => FND_API.g_false, -- use the same message queue as the calling API
740: p_commit => FND_API.g_false, -- committing in the called api will cause problems with rollback in the calling API
741: p_task_id => NULL,
742: p_task_name => l_trim_task_name, -- 'Prep. task for - '||l_deliv_rec.deliverable_name,
743: p_task_type_id => 15,
744: p_task_status_id => 14, -- in jtf_task_statuses_vl, 13 is Unassigned
762: IF (AMS_DEBUG_HIGH_ON) THEN
763: AMS_UTILITY_PVT.debug_message('the return status from :'||l_return_status);
764: END IF;
765:
766: IF l_return_status = FND_API.g_ret_sts_error THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:
771: FND_MSG_PUB.count_and_get(
772: p_encoded => FND_API.g_false,
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776:
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776:
777: RAISE FND_API.g_exc_error;
778:
779: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
781: THEN
775: );
776:
777: RAISE FND_API.g_exc_error;
778:
779: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
781: THEN
782: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
783: END IF;
782: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
783: END IF;
784:
785: FND_MSG_PUB.count_and_get(
786: p_encoded => FND_API.g_false,
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790:
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );
790:
791: RAISE FND_API.g_exc_unexpected_error;
792: END IF;
793:
794: -- create task assignment
795: IF (AMS_DEBUG_HIGH_ON) THEN
797: END IF;
798:
799: AMS_TASK_PVT.Create_Task_Assignment (
800: p_api_version => l_api_version,
801: p_init_msg_list => FND_API.g_false,
802: p_commit => FND_API.g_false,
803: p_task_id => x_task_id,
804: p_resource_type_code => 'RS_EMPLOYEE',
805: p_resource_id => l_deliv_rec.owner_user_id,
798:
799: AMS_TASK_PVT.Create_Task_Assignment (
800: p_api_version => l_api_version,
801: p_init_msg_list => FND_API.g_false,
802: p_commit => FND_API.g_false,
803: p_task_id => x_task_id,
804: p_resource_type_code => 'RS_EMPLOYEE',
805: p_resource_id => l_deliv_rec.owner_user_id,
806: p_assignment_status_id => 1,
809: x_msg_data => x_msg_data,
810: x_task_assignment_id => x_task_assignment_id
811: );
812:
813: IF l_return_status = FND_API.g_ret_sts_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_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_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827:
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
829: THEN
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827:
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
829: THEN
830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
831: END IF;
832:
833: FND_MSG_PUB.count_and_get(
834: p_encoded => FND_API.g_false,
835: p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838: RAISE FND_API.g_exc_unexpected_error;
834: p_encoded => FND_API.g_false,
835: p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838: RAISE FND_API.g_exc_unexpected_error;
839: END IF;
840:
841: -------------------- code added by abhola ---------------------
842: --------- ams_association pvt. create association ------------
851: l_association_rec.usage_type :='USED_BY';
852:
853: AMS_Associations_PVT.create_association
854: ( p_api_version => l_api_version,
855: p_init_msg_list => FND_API.g_false,
856: p_commit => FND_API.g_false,
857: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
858: x_return_status => l_return_status,
859: x_msg_count => x_msg_count,
852:
853: AMS_Associations_PVT.create_association
854: ( p_api_version => l_api_version,
855: p_init_msg_list => FND_API.g_false,
856: p_commit => FND_API.g_false,
857: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
858: x_return_status => l_return_status,
859: x_msg_count => x_msg_count,
860: x_msg_data => x_msg_data,
853: AMS_Associations_PVT.create_association
854: ( p_api_version => l_api_version,
855: p_init_msg_list => FND_API.g_false,
856: p_commit => FND_API.g_false,
857: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
858: x_return_status => l_return_status,
859: x_msg_count => x_msg_count,
860: x_msg_data => x_msg_data,
861: p_association_rec => l_association_rec,
860: x_msg_data => x_msg_data,
861: p_association_rec => l_association_rec,
862: x_object_association_id => l_object_association_id
863: );
864: IF l_return_status = FND_API.g_ret_sts_error THEN
865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
867: END IF;
868: FND_MSG_PUB.count_and_get
866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
867: END IF;
868: FND_MSG_PUB.count_and_get
869: (
870: p_encoded => FND_API.g_false,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );
874: RAISE FND_API.g_exc_error;
870: p_encoded => FND_API.g_false,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );
874: RAISE FND_API.g_exc_error;
875: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
877: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
878: END IF;
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );
874: RAISE FND_API.g_exc_error;
875: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
877: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
878: END IF;
879: FND_MSG_PUB.count_and_get
877: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
878: END IF;
879: FND_MSG_PUB.count_and_get
880: (
881: p_encoded => FND_API.g_false,
882: p_count => x_msg_count,
883: p_data => x_msg_data
884: );
885: RAISE FND_API.g_exc_unexpected_error;
881: p_encoded => FND_API.g_false,
882: p_count => x_msg_count,
883: p_data => x_msg_data
884: );
885: RAISE FND_API.g_exc_unexpected_error;
886: END IF;
887: end if;
888: end if;
889: ----------------- end code added by abhola --------------------
889: ----------------- end code added by abhola --------------------
890: ------------------------- finish -------------------------------
891: x_deliv_id := l_deliv_rec.deliverable_id;
892:
893: IF FND_API.to_boolean(p_commit) THEN
894: COMMIT;
895: END IF;
896:
897: FND_MSG_PUB.count_and_get(
894: COMMIT;
895: END IF;
896:
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );
902:
905: END IF;
906:
907: EXCEPTION
908:
909: WHEN FND_API.g_exc_error THEN
910: ROLLBACK TO create_deliverable;
911: x_return_status := FND_API.g_ret_sts_error;
912: FND_MSG_PUB.count_and_get(
913: p_encoded => FND_API.g_false,
907: EXCEPTION
908:
909: WHEN FND_API.g_exc_error THEN
910: ROLLBACK TO create_deliverable;
911: x_return_status := FND_API.g_ret_sts_error;
912: FND_MSG_PUB.count_and_get(
913: p_encoded => FND_API.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data
909: WHEN FND_API.g_exc_error THEN
910: ROLLBACK TO create_deliverable;
911: x_return_status := FND_API.g_ret_sts_error;
912: FND_MSG_PUB.count_and_get(
913: p_encoded => FND_API.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data
916: );
917:
914: p_count => x_msg_count,
915: p_data => x_msg_data
916: );
917:
918: WHEN FND_API.g_exc_unexpected_error THEN
919: ROLLBACK TO create_deliverable;
920: x_return_status := FND_API.g_ret_sts_unexp_error ;
921: FND_MSG_PUB.count_and_get(
922: p_encoded => FND_API.g_false,
916: );
917:
918: WHEN FND_API.g_exc_unexpected_error THEN
919: ROLLBACK TO create_deliverable;
920: x_return_status := FND_API.g_ret_sts_unexp_error ;
921: FND_MSG_PUB.count_and_get(
922: p_encoded => FND_API.g_false,
923: p_count => x_msg_count,
924: p_data => x_msg_data
918: WHEN FND_API.g_exc_unexpected_error THEN
919: ROLLBACK TO create_deliverable;
920: x_return_status := FND_API.g_ret_sts_unexp_error ;
921: FND_MSG_PUB.count_and_get(
922: p_encoded => FND_API.g_false,
923: p_count => x_msg_count,
924: p_data => x_msg_data
925: );
926:
925: );
926:
927: WHEN OTHERS THEN
928: ROLLBACK TO create_deliverable;
929: x_return_status := FND_API.g_ret_sts_unexp_error ;
930:
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
932: THEN
933: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
933: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
934: END IF;
935:
936: FND_MSG_PUB.count_and_get(
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941:
952:
953: PROCEDURE delete_deliverable
954: (
955: p_api_version IN NUMBER,
956: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
957: p_commit IN VARCHAR2 := FND_API.g_false,
958:
959: x_return_status OUT NOCOPY VARCHAR2,
960: x_msg_count OUT NOCOPY NUMBER,
953: PROCEDURE delete_deliverable
954: (
955: p_api_version IN NUMBER,
956: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
957: p_commit IN VARCHAR2 := FND_API.g_false,
958:
959: x_return_status OUT NOCOPY VARCHAR2,
960: x_msg_count OUT NOCOPY NUMBER,
961: x_msg_data OUT NOCOPY VARCHAR2,
977: IF (AMS_DEBUG_HIGH_ON) THEN
978: AMS_Utility_PVT.debug_message(l_full_name||': start');
979: END IF;
980:
981: IF FND_API.to_boolean(p_init_msg_list) THEN
982: FND_MSG_PUB.initialize;
983: END IF;
984:
985: IF NOT FND_API.compatible_api_call(
981: IF FND_API.to_boolean(p_init_msg_list) THEN
982: FND_MSG_PUB.initialize;
983: END IF;
984:
985: IF NOT FND_API.compatible_api_call(
986: l_api_version,
987: p_api_version,
988: l_api_name,
989: g_pkg_name
987: p_api_version,
988: l_api_name,
989: g_pkg_name
990: ) THEN
991: RAISE FND_API.g_exc_unexpected_error;
992: END IF;
993:
994: x_return_status := FND_API.G_RET_STS_SUCCESS;
995:
990: ) THEN
991: RAISE FND_API.g_exc_unexpected_error;
992: END IF;
993:
994: x_return_status := FND_API.G_RET_STS_SUCCESS;
995:
996: ------------------------ delete ------------------------
997: IF (AMS_DEBUG_HIGH_ON) THEN
998: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
1007: THEN
1008: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1009: FND_MSG_PUB.add;
1010: END IF;
1011: RAISE FND_API.g_exc_error;
1012: END IF;
1013:
1014: DELETE FROM ams_deliverables_all_tl
1015: WHERE deliverable_id = p_deliv_id;
1019: THEN
1020: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1021: FND_MSG_PUB.add;
1022: END IF;
1023: RAISE FND_API.g_exc_error;
1024: END IF;
1025:
1026: -------------------- finish --------------------------
1027: IF FND_API.to_boolean(p_commit) THEN
1023: RAISE FND_API.g_exc_error;
1024: END IF;
1025:
1026: -------------------- finish --------------------------
1027: IF FND_API.to_boolean(p_commit) THEN
1028: COMMIT;
1029: END IF;
1030:
1031: FND_MSG_PUB.count_and_get(
1028: COMMIT;
1029: END IF;
1030:
1031: FND_MSG_PUB.count_and_get(
1032: p_encoded => FND_API.g_false,
1033: p_count => x_msg_count,
1034: p_data => x_msg_data
1035: );
1036:
1039: END IF;
1040:
1041: EXCEPTION
1042:
1043: WHEN FND_API.g_exc_error THEN
1044: ROLLBACK TO delete_deliverable;
1045: x_return_status := FND_API.g_ret_sts_error;
1046: FND_MSG_PUB.count_and_get(
1047: p_encoded => FND_API.g_false,
1041: EXCEPTION
1042:
1043: WHEN FND_API.g_exc_error THEN
1044: ROLLBACK TO delete_deliverable;
1045: x_return_status := FND_API.g_ret_sts_error;
1046: FND_MSG_PUB.count_and_get(
1047: p_encoded => FND_API.g_false,
1048: p_count => x_msg_count,
1049: p_data => x_msg_data
1043: WHEN FND_API.g_exc_error THEN
1044: ROLLBACK TO delete_deliverable;
1045: x_return_status := FND_API.g_ret_sts_error;
1046: FND_MSG_PUB.count_and_get(
1047: p_encoded => FND_API.g_false,
1048: p_count => x_msg_count,
1049: p_data => x_msg_data
1050: );
1051:
1048: p_count => x_msg_count,
1049: p_data => x_msg_data
1050: );
1051:
1052: WHEN FND_API.g_exc_unexpected_error THEN
1053: ROLLBACK TO delete_deliverable;
1054: x_return_status := FND_API.g_ret_sts_unexp_error ;
1055: FND_MSG_PUB.count_and_get(
1056: p_encoded => FND_API.g_false,
1050: );
1051:
1052: WHEN FND_API.g_exc_unexpected_error THEN
1053: ROLLBACK TO delete_deliverable;
1054: x_return_status := FND_API.g_ret_sts_unexp_error ;
1055: FND_MSG_PUB.count_and_get(
1056: p_encoded => FND_API.g_false,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data
1052: WHEN FND_API.g_exc_unexpected_error THEN
1053: ROLLBACK TO delete_deliverable;
1054: x_return_status := FND_API.g_ret_sts_unexp_error ;
1055: FND_MSG_PUB.count_and_get(
1056: p_encoded => FND_API.g_false,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data
1059: );
1060:
1059: );
1060:
1061: WHEN OTHERS THEN
1062: ROLLBACK TO delete_deliverable;
1063: x_return_status := FND_API.g_ret_sts_unexp_error ;
1064:
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1066: THEN
1067: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1067: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1068: END IF;
1069:
1070: FND_MSG_PUB.count_and_get(
1071: p_encoded => FND_API.g_false,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data
1074: );
1075:
1086:
1087: PROCEDURE lock_deliverable
1088: (
1089: p_api_version IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1091:
1092: x_return_status OUT NOCOPY VARCHAR2,
1093: x_msg_count OUT NOCOPY NUMBER,
1094: x_msg_data OUT NOCOPY VARCHAR2,
1125:
1126: AMS_Utility_PVT.debug_message(l_full_name||': start');
1127: END IF;
1128:
1129: IF FND_API.to_boolean(p_init_msg_list) THEN
1130: FND_MSG_PUB.initialize;
1131: END IF;
1132:
1133: IF NOT FND_API.compatible_api_call(
1129: IF FND_API.to_boolean(p_init_msg_list) THEN
1130: FND_MSG_PUB.initialize;
1131: END IF;
1132:
1133: IF NOT FND_API.compatible_api_call(
1134: l_api_version,
1135: p_api_version,
1136: l_api_name,
1137: g_pkg_name
1135: p_api_version,
1136: l_api_name,
1137: g_pkg_name
1138: ) THEN
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;
1141:
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143:
1138: ) THEN
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;
1141:
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143:
1144: ------------------------ lock -------------------------
1145: IF (AMS_DEBUG_HIGH_ON) THEN
1146:
1154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1155: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1156: FND_MSG_PUB.add;
1157: END IF;
1158: RAISE FND_API.g_exc_error;
1159: END IF;
1160: CLOSE c_deliv_b;
1161:
1162: OPEN c_deliv_tl;
1163: CLOSE c_deliv_tl;
1164:
1165: -------------------- finish --------------------------
1166: FND_MSG_PUB.count_and_get(
1167: p_encoded => FND_API.g_false,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );
1171:
1171:
1172: EXCEPTION
1173:
1174: WHEN AMS_Utility_PVT.resource_locked THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1178: FND_MSG_PUB.add;
1179: END IF;
1178: FND_MSG_PUB.add;
1179: END IF;
1180:
1181: FND_MSG_PUB.count_and_get(
1182: p_encoded => FND_API.g_false,
1183: p_count => x_msg_count,
1184: p_data => x_msg_data
1185: );
1186:
1183: p_count => x_msg_count,
1184: p_data => x_msg_data
1185: );
1186:
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189: FND_MSG_PUB.count_and_get(
1190: p_encoded => FND_API.g_false,
1191: p_count => x_msg_count,
1184: p_data => x_msg_data
1185: );
1186:
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189: FND_MSG_PUB.count_and_get(
1190: p_encoded => FND_API.g_false,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1186:
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189: FND_MSG_PUB.count_and_get(
1190: p_encoded => FND_API.g_false,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1193: );
1194:
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1193: );
1194:
1195: WHEN FND_API.g_exc_unexpected_error THEN
1196: x_return_status := FND_API.g_ret_sts_unexp_error ;
1197: FND_MSG_PUB.count_and_get(
1198: p_encoded => FND_API.g_false,
1199: p_count => x_msg_count,
1192: p_data => x_msg_data
1193: );
1194:
1195: WHEN FND_API.g_exc_unexpected_error THEN
1196: x_return_status := FND_API.g_ret_sts_unexp_error ;
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
1194:
1195: WHEN FND_API.g_exc_unexpected_error THEN
1196: x_return_status := FND_API.g_ret_sts_unexp_error ;
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:
1200: p_data => x_msg_data
1201: );
1202:
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.g_ret_sts_unexp_error ;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209:
1210: FND_MSG_PUB.count_and_get(
1211: p_encoded => FND_API.g_false,
1212: p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215:
1229:
1230: PROCEDURE update_deliverable
1231: (
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1234: p_commit IN VARCHAR2 := FND_API.g_false,
1235: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1236:
1237: x_return_status OUT NOCOPY VARCHAR2,
1230: PROCEDURE update_deliverable
1231: (
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1234: p_commit IN VARCHAR2 := FND_API.g_false,
1235: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1236:
1237: x_return_status OUT NOCOPY VARCHAR2,
1238: x_msg_count OUT NOCOPY NUMBER,
1231: (
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1234: p_commit IN VARCHAR2 := FND_API.g_false,
1235: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1236:
1237: x_return_status OUT NOCOPY VARCHAR2,
1238: x_msg_count OUT NOCOPY NUMBER,
1239: x_msg_data OUT NOCOPY VARCHAR2,
1421: IF (AMS_DEBUG_HIGH_ON) THEN
1422: AMS_Utility_PVT.debug_message(l_full_name||': start');
1423: END IF;
1424:
1425: IF FND_API.to_boolean(p_init_msg_list) THEN
1426: FND_MSG_PUB.initialize;
1427: END IF;
1428:
1429: IF NOT FND_API.compatible_api_call(
1425: IF FND_API.to_boolean(p_init_msg_list) THEN
1426: FND_MSG_PUB.initialize;
1427: END IF;
1428:
1429: IF NOT FND_API.compatible_api_call(
1430: l_api_version,
1431: p_api_version,
1432: l_api_name,
1433: g_pkg_name
1431: p_api_version,
1432: l_api_name,
1433: g_pkg_name
1434: ) THEN
1435: RAISE FND_API.g_exc_unexpected_error;
1436: END IF;
1437:
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1434: ) THEN
1435: RAISE FND_API.g_exc_unexpected_error;
1436: END IF;
1437:
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1440: ----------------------- validate ----------------------
1441: --01/24/02 added for access check bug #2764852 mukumar start
1442:
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1455: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1456: FND_MSG_PUB.add;
1457: END IF;
1458: RAISE FND_API.g_exc_error;
1459: end if;
1460: --01/24/02 added for access check bug #2764852 mukumar end
1461:
1462: IF (AMS_DEBUG_HIGH_ON) THEN
1465: AMS_Utility_PVT.debug_message('l_deliv_rec.currency_code:'||l_deliv_rec.currency_code);
1466: END IF;
1467:
1468:
1469: IF l_deliv_rec.transaction_currency_code = FND_API.G_MISS_CHAR
1470: OR l_deliv_rec.transaction_currency_code IS NULL
1471: THEN
1472: l_deliv_rec.transaction_currency_code := l_deliv_rec.currency_code;
1473: END IF;
1489: ,x_deliverable_calendar => l_deliverable_calendar
1490: ,x_return_status => l_return_Status
1491: );
1492:
1493: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1494: RAISE FND_API.g_exc_unexpected_error;
1495: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1496: RAISE FND_API.g_exc_error;
1497: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1490: ,x_return_status => l_return_Status
1491: );
1492:
1493: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1494: RAISE FND_API.g_exc_unexpected_error;
1495: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1496: RAISE FND_API.g_exc_error;
1497: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1498: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1491: );
1492:
1493: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1494: RAISE FND_API.g_exc_unexpected_error;
1495: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1496: RAISE FND_API.g_exc_error;
1497: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1498: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1499: END IF;
1492:
1493: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1494: RAISE FND_API.g_exc_unexpected_error;
1495: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1496: RAISE FND_API.g_exc_error;
1497: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1498: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1499: END IF;
1500: ELSIF ((l_deliv_rec.start_period_name IS NULL)
1493: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1494: RAISE FND_API.g_exc_unexpected_error;
1495: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1496: RAISE FND_API.g_exc_error;
1497: ELSIF l_return_status = FND_API.g_ret_sts_success THEN
1498: l_deliv_Rec.deliverable_calendar := l_deliverable_calendar;
1499: END IF;
1500: ELSIF ((l_deliv_rec.start_period_name IS NULL)
1501: AND (l_deliv_rec.end_period_name IS NULL)) THEN
1509: -- validate_deliverable
1510: ams_deliverable_pub.validate_deliverable
1511: (
1512: p_api_version_number => l_api_version,
1513: p_init_msg_list => FND_API.g_false,
1514: p_validation_level => p_validation_level,
1515: p_validation_mode => JTF_PLSQL_API.g_update,
1516: x_return_status => l_return_status,
1517: x_msg_count => x_msg_count,
1526: p_validation_mode => JTF_PLSQL_API.g_update,
1527: x_return_status => l_return_status
1528: );
1529:
1530: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1533: RAISE FND_API.g_exc_error;
1534: END IF;
1527: x_return_status => l_return_status
1528: );
1529:
1530: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1533: RAISE FND_API.g_exc_error;
1534: END IF;
1535: END IF;
1528: );
1529:
1530: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1533: RAISE FND_API.g_exc_error;
1534: END IF;
1535: END IF;
1536:
1529:
1530: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1533: RAISE FND_API.g_exc_error;
1534: END IF;
1535: END IF;
1536:
1537: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1546: x_return_status => l_return_status
1547: );
1548: */
1549:
1550: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1551: RAISE FND_API.g_exc_unexpected_error;
1552: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1553: RAISE FND_API.g_exc_error;
1554: END IF;
1547: );
1548: */
1549:
1550: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1551: RAISE FND_API.g_exc_unexpected_error;
1552: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1553: RAISE FND_API.g_exc_error;
1554: END IF;
1555: END IF;
1548: */
1549:
1550: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1551: RAISE FND_API.g_exc_unexpected_error;
1552: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1553: RAISE FND_API.g_exc_error;
1554: END IF;
1555: END IF;
1556:
1549:
1550: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1551: RAISE FND_API.g_exc_unexpected_error;
1552: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1553: RAISE FND_API.g_exc_error;
1554: END IF;
1555: END IF;
1556:
1557: OPEN c_new_status_code(l_deliv_rec.user_status_id);
1566:
1567: -- for cancellation change musman 10/04/00
1568: IF l_deliv_rec.status_code IN ('CANCELLED', 'ARCHIVED') THEN
1569: Deliverable_cancellation(l_deliv_rec, l_return_status);
1570: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1571: RAISE FND_API.g_exc_unexpected_error;
1572: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1573: RAISE FND_API.g_exc_error;
1574: END IF;
1567: -- for cancellation change musman 10/04/00
1568: IF l_deliv_rec.status_code IN ('CANCELLED', 'ARCHIVED') THEN
1569: Deliverable_cancellation(l_deliv_rec, l_return_status);
1570: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1571: RAISE FND_API.g_exc_unexpected_error;
1572: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1573: RAISE FND_API.g_exc_error;
1574: END IF;
1575: END IF;
1568: IF l_deliv_rec.status_code IN ('CANCELLED', 'ARCHIVED') THEN
1569: Deliverable_cancellation(l_deliv_rec, l_return_status);
1570: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1571: RAISE FND_API.g_exc_unexpected_error;
1572: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1573: RAISE FND_API.g_exc_error;
1574: END IF;
1575: END IF;
1576:
1569: Deliverable_cancellation(l_deliv_rec, l_return_status);
1570: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1571: RAISE FND_API.g_exc_unexpected_error;
1572: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1573: RAISE FND_API.g_exc_error;
1574: END IF;
1575: END IF;
1576:
1577: -- Bug 1350422 modified by khung 07/11/2000
1631: x_msg_count => x_msg_count,
1632: x_msg_data => x_msg_data
1633: );
1634:
1635: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1636: RAISE FND_API.g_exc_unexpected_error;
1637: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1638: RAISE FND_API.g_exc_error;
1639: END IF;
1632: x_msg_data => x_msg_data
1633: );
1634:
1635: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1636: RAISE FND_API.g_exc_unexpected_error;
1637: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1638: RAISE FND_API.g_exc_error;
1639: END IF;
1640:
1633: );
1634:
1635: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1636: RAISE FND_API.g_exc_unexpected_error;
1637: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1638: RAISE FND_API.g_exc_error;
1639: END IF;
1640:
1641: -- this is needed if the user passes the inv_id,org_id from the public api
1634:
1635: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1636: RAISE FND_API.g_exc_unexpected_error;
1637: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1638: RAISE FND_API.g_exc_error;
1639: END IF;
1640:
1641: -- this is needed if the user passes the inv_id,org_id from the public api
1642: -- validating whether the inv item has reqd attributes set.
1652: check_inv_item(
1653: p_deliv_rec => l_deliv_rec
1654: ,x_return_status => x_return_status);
1655:
1656: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1657: RAISE FND_API.g_exc_unexpected_error;
1658: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1659: RAISE FND_API.g_exc_error;
1660: END IF;
1653: p_deliv_rec => l_deliv_rec
1654: ,x_return_status => x_return_status);
1655:
1656: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1657: RAISE FND_API.g_exc_unexpected_error;
1658: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1659: RAISE FND_API.g_exc_error;
1660: END IF;
1661:
1654: ,x_return_status => x_return_status);
1655:
1656: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1657: RAISE FND_API.g_exc_unexpected_error;
1658: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1659: RAISE FND_API.g_exc_error;
1660: END IF;
1661:
1662: END IF;
1655:
1656: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1657: RAISE FND_API.g_exc_unexpected_error;
1658: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1659: RAISE FND_API.g_exc_error;
1660: END IF;
1661:
1662: END IF;
1663: -- End Inventory creation
1691:
1692: JTF_AMV_ITEM_PUB.Create_Item
1693: (
1694: p_api_version => 1.0,
1695: p_init_msg_list => FND_API.g_true,
1696: p_commit => FND_API.g_false,
1697: x_return_status => l_return_status,
1698: x_msg_count => l_msg_count,
1699: x_msg_data => l_msg_data,
1692: JTF_AMV_ITEM_PUB.Create_Item
1693: (
1694: p_api_version => 1.0,
1695: p_init_msg_list => FND_API.g_true,
1696: p_commit => FND_API.g_false,
1697: x_return_status => l_return_status,
1698: x_msg_count => l_msg_count,
1699: x_msg_data => l_msg_data,
1700: p_item_rec => l_jtf_amv_item_rec,
1701: x_item_id => x_jtf_amv_item_id
1702: );
1703: x_return_status := l_return_status;
1704:
1705: IF l_return_status <> FND_API.g_ret_sts_success THEN
1706: RAISE jtf_inv_item_creation_error;
1707: ELSE
1708: l_deliv_rec.jtf_amv_item_id := x_jtf_amv_item_id;
1709: l_jtf_delv_item_id := x_jtf_amv_item_id;
1803: FETCH c_user_status_id INTO l_reject_status_id;
1804: -- CLOSE c_user_status_id;
1805: --
1806: -- 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;
1807: -- IF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_true
1808: -- THEN
1809: -- -- choang - 13-sep-2000
1810: -- -- Change of approval process.
1811: -- -- flip the status to pending budget approval
1816: -- FETCH c_user_status_id INTO l_pending_budget_stat_id;
1817: -- CLOSE c_user_status_id;
1818:
1819: -- IF (AMS_DEBUG_HIGH_ON) THEN ams_utility_pvt.debug_message (' l_pending_budget_stat_id : '||l_pending_budget_stat_id); END IF;
1820: -- ELSIF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_false
1821: -- THEN
1822: -- l_pending_budget_stat_id :=l_deliv_rec.user_status_id;
1823: -- l_pending_budget_stat := l_deliv_rec.status_code;
1824: -- END IF; -- if approval needed / BAPL exists
1932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1933: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1934: FND_MSG_PUB.add;
1935: END IF;
1936: RAISE FND_API.g_exc_error;
1937: END IF;
1938: IF (AMS_DEBUG_HIGH_ON) THEN
1939:
1940: ams_utility_pvt.debug_message (l_full_name ||' end of update 1 ');
1953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1954: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1955: FND_MSG_PUB.add;
1956: END IF;
1957: RAISE FND_API.g_exc_error;
1958: END IF;
1959:
1960: IF (l_Deliv_rec.owner_user_id <> FND_API.g_miss_NUM
1961: AND l_owner_user_id <> l_deliv_Rec.owner_user_id )
1956: END IF;
1957: RAISE FND_API.g_exc_error;
1958: END IF;
1959:
1960: IF (l_Deliv_rec.owner_user_id <> FND_API.g_miss_NUM
1961: AND l_owner_user_id <> l_deliv_Rec.owner_user_id )
1962: THEN
1963: AMS_Access_PVT.update_object_owner
1964: ( p_api_version => 1.0
1961: AND l_owner_user_id <> l_deliv_Rec.owner_user_id )
1962: THEN
1963: AMS_Access_PVT.update_object_owner
1964: ( p_api_version => 1.0
1965: ,p_init_msg_list => FND_API.G_FALSE
1966: ,p_commit => FND_API.G_FALSE
1967: ,p_validation_level => p_validation_level
1968: ,x_return_status => x_return_status
1969: ,x_msg_count => x_msg_count
1962: THEN
1963: AMS_Access_PVT.update_object_owner
1964: ( p_api_version => 1.0
1965: ,p_init_msg_list => FND_API.G_FALSE
1966: ,p_commit => FND_API.G_FALSE
1967: ,p_validation_level => p_validation_level
1968: ,x_return_status => x_return_status
1969: ,x_msg_count => x_msg_count
1970: ,x_msg_data => x_msg_data
1972: ,p_object_id => l_deliv_Rec.deliverable_id
1973: ,p_resource_id => l_deliv_rec.owner_user_id
1974: ,p_old_resource_id => l_owner_user_id
1975: );
1976: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: END IF;
1979: END IF;
1980:
1973: ,p_resource_id => l_deliv_rec.owner_user_id
1974: ,p_old_resource_id => l_owner_user_id
1975: );
1976: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: END IF;
1979: END IF;
1980:
1981: -------------------------------------
2008: -- FETCH check_budget INTO l_budget_lines_exist;
2009: -- CLOSE check_budget;
2010: --
2011: --
2012: -- IF Approval_required_flag( l_deliv_rec.setup_id, 'BAPL') = FND_API.g_true
2013: -- AND l_budget_lines_exist = 'N' THEN
2014: --
2015: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2016: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2015: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2016: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2017: -- FND_MSG_PUB.add;
2018: -- END IF;
2019: -- RAISE FND_API.g_exc_error;
2020: -- END IF;
2021: -- *****************************************
2022: --
2023: -- 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;
2019: -- RAISE FND_API.g_exc_error;
2020: -- END IF;
2021: -- *****************************************
2022: --
2023: -- 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;
2024: -- IF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_true
2025: -- THEN
2026: --
2027: -- choang - 13-sep-2000
2020: -- END IF;
2021: -- *****************************************
2022: --
2023: -- 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;
2024: -- IF Approval_required_flag( l_deliv_rec.setup_id, l_custom_setup_attr) = FND_API.g_true
2025: -- THEN
2026: --
2027: -- choang - 13-sep-2000
2028: -- -- Change of approval process.
2057: p_deliverable_id => l_deliv_rec.deliverable_id
2058: ,p_user_status_id => l_deliv_rec.user_status_id
2059: );
2060:
2061: -- IF x_return_status <> FND_API.g_ret_sts_success
2062: -- THEN
2063: -- RAISE FND_API.g_exc_error;
2064: -- END IF;
2065:
2059: );
2060:
2061: -- IF x_return_status <> FND_API.g_ret_sts_success
2062: -- THEN
2063: -- RAISE FND_API.g_exc_error;
2064: -- END IF;
2065:
2066: IF (AMS_DEBUG_HIGH_ON) THEN
2067:
2070: ams_utility_pvt.debug_message (l_full_name ||' end of update 2 ');
2071:
2072: END IF;
2073: -------------------- finish --------------------------
2074: IF FND_API.to_boolean(p_commit) THEN
2075: COMMIT;
2076: END IF;
2077:
2078: FND_MSG_PUB.count_and_get(
2075: COMMIT;
2076: END IF;
2077:
2078: FND_MSG_PUB.count_and_get(
2079: p_encoded => FND_API.g_false,
2080: p_count => x_msg_count,
2081: p_data => x_msg_data
2082: );
2083:
2090: END IF;
2091:
2092: EXCEPTION
2093:
2094: WHEN FND_API.g_exc_error THEN
2095: ROLLBACK TO update_deliverable;
2096: x_return_status := FND_API.g_ret_sts_error;
2097: FND_MSG_PUB.count_and_get(
2098: p_encoded => FND_API.g_false,
2092: EXCEPTION
2093:
2094: WHEN FND_API.g_exc_error THEN
2095: ROLLBACK TO update_deliverable;
2096: x_return_status := FND_API.g_ret_sts_error;
2097: FND_MSG_PUB.count_and_get(
2098: p_encoded => FND_API.g_false,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data
2094: WHEN FND_API.g_exc_error THEN
2095: ROLLBACK TO update_deliverable;
2096: x_return_status := FND_API.g_ret_sts_error;
2097: FND_MSG_PUB.count_and_get(
2098: p_encoded => FND_API.g_false,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data
2101: );
2102:
2099: p_count => x_msg_count,
2100: p_data => x_msg_data
2101: );
2102:
2103: WHEN FND_API.g_exc_unexpected_error THEN
2104: ROLLBACK TO update_deliverable;
2105: x_return_status := FND_API.g_ret_sts_unexp_error ;
2106: FND_MSG_PUB.count_and_get(
2107: p_encoded => FND_API.g_false,
2101: );
2102:
2103: WHEN FND_API.g_exc_unexpected_error THEN
2104: ROLLBACK TO update_deliverable;
2105: x_return_status := FND_API.g_ret_sts_unexp_error ;
2106: FND_MSG_PUB.count_and_get(
2107: p_encoded => FND_API.g_false,
2108: p_count => x_msg_count,
2109: p_data => x_msg_data
2103: WHEN FND_API.g_exc_unexpected_error THEN
2104: ROLLBACK TO update_deliverable;
2105: x_return_status := FND_API.g_ret_sts_unexp_error ;
2106: FND_MSG_PUB.count_and_get(
2107: p_encoded => FND_API.g_false,
2108: p_count => x_msg_count,
2109: p_data => x_msg_data
2110: );
2111:
2111:
2112: WHEN inv_creation_error THEN
2113: /*-modify on 08/07/2000 khung
2114: --FND_MSG_PUB.count_and_get(
2115: p_encoded => FND_API.g_false,
2116: -- p_count => x_msg_count,
2117: -- p_data => x_msg_data
2118: -- );*/
2119: ROLLBACK TO update_deliverable;
2118: -- );*/
2119: ROLLBACK TO update_deliverable;
2120: FOR i IN 1 .. x_error_tbl.count LOOP
2121: FND_MSG_PUB.count_and_get(
2122: p_encoded => FND_API.g_false,
2123: p_count => x_msg_count,
2124: p_data => x_error_tbl(i).message_text
2125: );
2126: IF (AMS_DEBUG_HIGH_ON) THEN
2131:
2132: WHEN jtf_inv_item_creation_error THEN
2133: ROLLBACK TO update_deliverable;
2134: FND_MSG_PUB.count_and_get(
2135: p_encoded => FND_API.g_false,
2136: p_count => x_msg_count,
2137: p_data => x_msg_data
2138: );
2139: WHEN OTHERS THEN
2137: p_data => x_msg_data
2138: );
2139: WHEN OTHERS THEN
2140: ROLLBACK TO update_deliverable;
2141: x_return_status := FND_API.g_ret_sts_unexp_error ;
2142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2143: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2144: END IF;
2145: FND_MSG_PUB.count_and_get(
2142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2143: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2144: END IF;
2145: FND_MSG_PUB.count_and_get(
2146: p_encoded => FND_API.g_false,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data
2149: );
2150: END update_deliverable;
2159:
2160: PROCEDURE validate_deliverable
2161: (
2162: p_api_version IN NUMBER,
2163: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2165: p_validation_mode IN VARCHAR2,
2166: x_return_status OUT NOCOPY VARCHAR2,
2167: x_msg_count OUT NOCOPY NUMBER,
2160: PROCEDURE validate_deliverable
2161: (
2162: p_api_version IN NUMBER,
2163: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2164: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2165: p_validation_mode IN VARCHAR2,
2166: x_return_status OUT NOCOPY VARCHAR2,
2167: x_msg_count OUT NOCOPY NUMBER,
2168: x_msg_data OUT NOCOPY VARCHAR2,
2182:
2183: AMS_Utility_PVT.debug_message(l_full_name||': start');
2184: END IF;
2185:
2186: IF FND_API.to_boolean(p_init_msg_list) THEN
2187: FND_MSG_PUB.initialize;
2188: END IF;
2189:
2190: IF NOT FND_API.compatible_api_call(
2186: IF FND_API.to_boolean(p_init_msg_list) THEN
2187: FND_MSG_PUB.initialize;
2188: END IF;
2189:
2190: IF NOT FND_API.compatible_api_call(
2191: l_api_version,
2192: p_api_version,
2193: l_api_name,
2194: g_pkg_name
2192: p_api_version,
2193: l_api_name,
2194: g_pkg_name
2195: ) THEN
2196: RAISE FND_API.g_exc_unexpected_error;
2197: END IF;
2198:
2199: x_return_status := FND_API.g_ret_sts_success;
2200:
2195: ) THEN
2196: RAISE FND_API.g_exc_unexpected_error;
2197: END IF;
2198:
2199: x_return_status := FND_API.g_ret_sts_success;
2200:
2201: ---------------------- validate ------------------------
2202: IF (AMS_DEBUG_HIGH_ON) THEN
2203:
2210: p_validation_mode => p_validation_mode, --JTF_PLSQL_API.g_create,
2211: x_return_status => l_return_status
2212: );
2213:
2214: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2215: RAISE FND_API.g_exc_unexpected_error;
2216: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2217: RAISE FND_API.g_exc_error;
2218: END IF;
2211: x_return_status => l_return_status
2212: );
2213:
2214: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2215: RAISE FND_API.g_exc_unexpected_error;
2216: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2217: RAISE FND_API.g_exc_error;
2218: END IF;
2219: END IF;
2212: );
2213:
2214: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2215: RAISE FND_API.g_exc_unexpected_error;
2216: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2217: RAISE FND_API.g_exc_error;
2218: END IF;
2219: END IF;
2220:
2213:
2214: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2215: RAISE FND_API.g_exc_unexpected_error;
2216: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2217: RAISE FND_API.g_exc_error;
2218: END IF;
2219: END IF;
2220:
2221: IF (AMS_DEBUG_HIGH_ON) THEN
2230: p_deliv_rec => p_deliv_rec,
2231: p_complete_rec => NULL,
2232: x_return_status => l_return_status
2233: );
2234: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2235: RAISE FND_API.g_exc_unexpected_error;
2236: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2237: RAISE FND_API.g_exc_error;
2238: END IF;
2231: p_complete_rec => NULL,
2232: x_return_status => l_return_status
2233: );
2234: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2235: RAISE FND_API.g_exc_unexpected_error;
2236: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2237: RAISE FND_API.g_exc_error;
2238: END IF;
2239:
2232: x_return_status => l_return_status
2233: );
2234: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2235: RAISE FND_API.g_exc_unexpected_error;
2236: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2237: RAISE FND_API.g_exc_error;
2238: END IF;
2239:
2240: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2233: );
2234: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2235: RAISE FND_API.g_exc_unexpected_error;
2236: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2237: RAISE FND_API.g_exc_error;
2238: END IF;
2239:
2240: ELSIF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
2241: AND p_validation_mode = JTF_PLSQL_API.g_update
2245: p_deliv_rec => p_deliv_rec,
2246: p_complete_rec => p_deliv_rec,
2247: x_return_status => l_return_status
2248: );
2249: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2250: RAISE FND_API.g_exc_unexpected_error;
2251: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2252: RAISE FND_API.g_exc_error;
2253: END IF;
2246: p_complete_rec => p_deliv_rec,
2247: x_return_status => l_return_status
2248: );
2249: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2250: RAISE FND_API.g_exc_unexpected_error;
2251: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2252: RAISE FND_API.g_exc_error;
2253: END IF;
2254:
2247: x_return_status => l_return_status
2248: );
2249: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2250: RAISE FND_API.g_exc_unexpected_error;
2251: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2252: RAISE FND_API.g_exc_error;
2253: END IF;
2254:
2255: END IF;
2248: );
2249: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2250: RAISE FND_API.g_exc_unexpected_error;
2251: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2252: RAISE FND_API.g_exc_error;
2253: END IF;
2254:
2255: END IF;
2256:
2255: END IF;
2256:
2257: -------------------- finish --------------------------
2258: FND_MSG_PUB.count_and_get(
2259: p_encoded => FND_API.g_false,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data
2262: );
2263:
2270: END IF;
2271:
2272: EXCEPTION
2273:
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: FND_MSG_PUB.count_and_get(
2277: p_encoded => FND_API.g_false,
2278: p_count => x_msg_count,
2271:
2272: EXCEPTION
2273:
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: FND_MSG_PUB.count_and_get(
2277: p_encoded => FND_API.g_false,
2278: p_count => x_msg_count,
2279: p_data => x_msg_data
2273:
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: FND_MSG_PUB.count_and_get(
2277: p_encoded => FND_API.g_false,
2278: p_count => x_msg_count,
2279: p_data => x_msg_data
2280: );
2281:
2278: p_count => x_msg_count,
2279: p_data => x_msg_data
2280: );
2281:
2282: WHEN FND_API.g_exc_unexpected_error THEN
2283: x_return_status := FND_API.g_ret_sts_unexp_error ;
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false,
2286: p_count => x_msg_count,
2279: p_data => x_msg_data
2280: );
2281:
2282: WHEN FND_API.g_exc_unexpected_error THEN
2283: x_return_status := FND_API.g_ret_sts_unexp_error ;
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
2281:
2282: WHEN FND_API.g_exc_unexpected_error THEN
2283: x_return_status := FND_API.g_ret_sts_unexp_error ;
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:
2287: p_data => x_msg_data
2288: );
2289:
2290: WHEN OTHERS THEN
2291: x_return_status := FND_API.g_ret_sts_unexp_error;
2292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2293: THEN
2294: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2295: END IF;
2294: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2295: END IF;
2296:
2297: FND_MSG_PUB.count_and_get(
2298: p_encoded => FND_API.g_false,
2299: p_count => x_msg_count,
2300: p_data => x_msg_data
2301: );
2302:
2316: )
2317: IS
2318: BEGIN
2319:
2320: x_return_status := FND_API.g_ret_sts_success;
2321:
2322: -------------------- put required items here ---------------------
2323:
2324: IF p_deliv_rec.language_code IS NULL THEN
2327: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_LANGUAGE_CODE');
2328: FND_MSG_PUB.add;
2329: END IF;
2330:
2331: x_return_status := FND_API.g_ret_sts_error;
2332: RETURN;
2333: END IF;
2334:
2335: IF p_deliv_rec.deliverable_name IS NULL THEN
2338: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_DELIVERABLE_NAME');
2339: FND_MSG_PUB.add;
2340: END IF;
2341:
2342: x_return_status := FND_API.g_ret_sts_error;
2343: RETURN;
2344: END IF;
2345:
2346: IF p_deliv_rec.actual_avail_from_date IS NULL THEN
2349: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FROM_DATE');
2350: FND_MSG_PUB.add;
2351: END IF;
2352:
2353: x_return_status := FND_API.g_ret_sts_error;
2354: RETURN;
2355: END IF;
2356:
2357: IF p_deliv_rec.actual_avail_to_date IS NULL THEN
2360: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_TO_DATE');
2361: FND_MSG_PUB.add;
2362: END IF;
2363:
2364: x_return_status := FND_API.g_ret_sts_error;
2365: RETURN;
2366: END IF;
2367:
2368: IF p_deliv_rec.forecasted_complete_date IS NULL THEN
2371: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FOREC_DATE');
2372: FND_MSG_PUB.add;
2373: END IF;
2374:
2375: x_return_status := FND_API.g_ret_sts_error;
2376: RETURN;
2377: END IF;
2378:
2379: IF p_deliv_rec.owner_user_id IS NULL THEN
2382: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_OWNER_ID');
2383: FND_MSG_PUB.add;
2384: END IF;
2385:
2386: x_return_status := FND_API.g_ret_sts_error;
2387: RETURN;
2388: END IF;
2389:
2390: IF p_deliv_rec.setup_id IS NULL THEN
2393: FND_MESSAGE.set_name('AMS', 'AMS_FUND_NO_CUSTOM_SETUP');
2394: FND_MSG_PUB.add;
2395: END IF;
2396:
2397: x_return_status := FND_API.g_ret_sts_error;
2398: RETURN;
2399: END IF;
2400:
2401: IF p_deliv_rec.country_id IS NULL THEN
2404: FND_MESSAGE.set_name('AMS', 'AMS_DILG_BAD_CITY');
2405: FND_MSG_PUB.add;
2406: END IF;
2407:
2408: x_return_status := FND_API.g_ret_sts_error;
2409: RETURN;
2410: END IF;
2411:
2412: IF p_deliv_rec.category_Type_id IS NULL THEN
2415: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_CATEGORY_ID');
2416: FND_MSG_PUB.add;
2417: END IF;
2418:
2419: x_return_status := FND_API.g_ret_sts_error;
2420: RETURN;
2421: END IF;
2422:
2423: IF p_deliv_rec.category_sub_Type_id IS NULL THEN
2426: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2427: FND_MSG_PUB.add;
2428: END IF;
2429:
2430: x_return_status := FND_API.g_ret_sts_error;
2431: RETURN;
2432: END IF;
2433:
2434: IF p_deliv_rec.version IS NULL THEN
2437: FND_MESSAGE.set_name('AMS', 'AMS_DELV_VERSION_MISSING');
2438: FND_MSG_PUB.add;
2439: END IF;
2440:
2441: x_return_status := FND_API.g_ret_sts_error;
2442: RETURN;
2443: END IF;
2444:
2445: IF p_deliv_rec.transaction_currency_code IS NULL THEN
2448: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2449: FND_MSG_PUB.add;
2450: END IF;
2451:
2452: x_return_status := FND_API.g_ret_sts_error;
2453: RETURN;
2454: END IF;
2455:
2456: END check_deliv_req_items;
2494:
2495:
2496: BEGIN
2497:
2498: x_return_status := FND_API.g_ret_sts_success;
2499:
2500: -- For create_deliverable, when deliverable_id is passed in, we need to
2501: -- check if this deliverable_id is unique.
2502: IF p_validation_mode = JTF_PLSQL_API.g_create
2504: THEN
2505: IF AMS_Utility_PVT.check_uniqueness(
2506: 'ams_deliverables_vl',
2507: 'deliverable_id = ' || p_deliv_rec.deliverable_id
2508: ) = FND_API.g_false
2509: THEN
2510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2511: THEN
2512: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2511: THEN
2512: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2513: FND_MSG_PUB.add;
2514: END IF;
2515: x_return_status := FND_API.g_ret_sts_error;
2516: RETURN;
2517: END IF;
2518: END IF;
2519:
2537: THEN
2538: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2539: FND_MSG_PUB.add;
2540: END IF;
2541: x_return_status := FND_API.g_ret_sts_error;
2542: RETURN;
2543: END IF;
2544: END IF;
2545:
2565: THEN
2566: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2567: FND_MSG_PUB.add;
2568: END IF;
2569: x_return_status := FND_API.g_ret_sts_error;
2570: RETURN;
2571: END IF;
2572: END IF;
2573:
2588: -- 'deliverable_name = ''' || p_deliv_rec.deliverable_name ||
2589: -- ''' AND deliverable_id <> ' || p_deliv_rec.deliverable_id
2590: -- );
2591: --END IF;
2592: --IF l_valid_flag = FND_API.g_false THEN
2593: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2594: -- THEN
2595: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2596: -- FND_MSG_PUB.add;
2594: -- THEN
2595: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2596: -- FND_MSG_PUB.add;
2597: -- END IF;
2598: -- x_return_status := FND_API.g_ret_sts_error;
2599: -- RETURN;
2600: --END IF;
2601:
2602: -- check other unique items
2616: )
2617: IS
2618: BEGIN
2619:
2620: x_return_status := FND_API.g_ret_sts_success;
2621: -- check other fk items
2622:
2623: --------------------- owner_user_id ------------------------
2624: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num
2620: x_return_status := FND_API.g_ret_sts_success;
2621: -- check other fk items
2622:
2623: --------------------- owner_user_id ------------------------
2624: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num
2625: THEN
2626: IF AMS_Utility_PVT.check_fk_exists(
2627: -- 'ams_jtf_rs_emp_v',
2628: 'jtf_rs_resource_extns',
2627: -- 'ams_jtf_rs_emp_v',
2628: 'jtf_rs_resource_extns',
2629: 'resource_id',
2630: p_deliv_rec.owner_user_id
2631: ) = FND_API.g_false
2632: THEN
2633: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_OWNER_USER_ID');
2634: x_return_status := FND_API.g_ret_sts_error;
2635: RETURN;
2630: p_deliv_rec.owner_user_id
2631: ) = FND_API.g_false
2632: THEN
2633: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_OWNER_USER_ID');
2634: x_return_status := FND_API.g_ret_sts_error;
2635: RETURN;
2636: END IF;
2637: END IF;
2638:
2636: END IF;
2637: END IF;
2638:
2639: --------------------- application_id ------------------------
2640: IF p_deliv_rec.application_id <> FND_API.g_miss_num
2641: THEN
2642: IF AMS_Utility_PVT.check_fk_exists(
2643: 'fnd_application',
2644: 'application_id',
2642: IF AMS_Utility_PVT.check_fk_exists(
2643: 'fnd_application',
2644: 'application_id',
2645: p_deliv_rec.application_id
2646: ) = FND_API.g_false
2647: THEN
2648: AMS_Utility_PVT.Error_Message('AMS_API_NO_APPLICATION_ID');
2649: x_return_status := FND_API.g_ret_sts_error;
2650: RETURN;
2645: p_deliv_rec.application_id
2646: ) = FND_API.g_false
2647: THEN
2648: AMS_Utility_PVT.Error_Message('AMS_API_NO_APPLICATION_ID');
2649: x_return_status := FND_API.g_ret_sts_error;
2650: RETURN;
2651: END IF;
2652: END IF;
2653:
2651: END IF;
2652: END IF;
2653:
2654: --------------------- category_type_id ------------------------
2655: IF p_deliv_rec.category_type_id <> FND_API.g_miss_num
2656: AND p_deliv_rec.category_type_id IS NOT NULL
2657: THEN
2658: IF AMS_Utility_PVT.check_fk_exists(
2659: 'ams_categories_b',
2658: IF AMS_Utility_PVT.check_fk_exists(
2659: 'ams_categories_b',
2660: 'category_id',
2661: p_deliv_rec.category_type_id
2662: ) = FND_API.g_false
2663: THEN
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2665: THEN
2666: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2665: THEN
2666: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2667: FND_MSG_PUB.add;
2668: END IF;
2669: x_return_status := FND_API.g_ret_sts_error;
2670: RETURN;
2671: END IF;
2672: END IF;
2673:
2671: END IF;
2672: END IF;
2673:
2674: --------------------- category_sub_type_id ------------------------
2675: IF p_deliv_rec.category_sub_type_id <> FND_API.g_miss_num
2676: AND p_deliv_rec.category_sub_type_id IS NOT NULL
2677: THEN
2678: IF AMS_Utility_PVT.check_fk_exists(
2679: 'ams_categories_b',
2678: IF AMS_Utility_PVT.check_fk_exists(
2679: 'ams_categories_b',
2680: 'category_id',
2681: p_deliv_rec.category_sub_type_id
2682: ) = FND_API.g_false
2683: THEN
2684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2685: THEN
2686: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2685: THEN
2686: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2687: FND_MSG_PUB.add;
2688: END IF;
2689: x_return_status := FND_API.g_ret_sts_error;
2690: RETURN;
2691: END IF;
2692: END IF;
2693:
2691: END IF;
2692: END IF;
2693:
2694: --------------------- custom_setup_id ----------------------------
2695: IF p_deliv_rec.setup_id <> FND_API.g_miss_num
2696: AND p_deliv_rec.setup_id IS NOT NULL
2697: THEN
2698: IF AMS_Utility_PVT.check_fk_exists(
2699: 'ams_custom_setups_b',
2698: IF AMS_Utility_PVT.check_fk_exists(
2699: 'ams_custom_setups_b',
2700: 'custom_setup_id',
2701: p_deliv_rec.setup_id
2702: ) = FND_API.g_false
2703: THEN
2704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2705: THEN
2706: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2705: THEN
2706: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2707: FND_MSG_PUB.add;
2708: END IF;
2709: x_return_status := FND_API.g_ret_sts_error;
2710: RETURN;
2711: END IF;
2712:
2713: END IF;
2712:
2713: END IF;
2714:
2715: --------------------- country_id ----------------------------
2716: IF p_deliv_rec.country_id <> FND_API.g_miss_num
2717: AND p_deliv_rec.country_id IS NOT NULL
2718: THEN
2719: IF AMS_Utility_PVT.check_fk_exists(
2720: 'jtf_loc_hierarchies_b',
2721: 'location_hierarchy_id',
2722: p_deliv_rec.country_id,
2723: AMS_Utility_PVT.g_number,
2724: NULL
2725: ) = FND_API.g_false
2726: THEN
2727: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_COUNTRY');
2728: x_return_status := FND_API.g_ret_sts_error;
2729: RETURN;
2724: NULL
2725: ) = FND_API.g_false
2726: THEN
2727: AMS_Utility_PVT.Error_Message('AMS_CSCH_BAD_COUNTRY');
2728: x_return_status := FND_API.g_ret_sts_error;
2729: RETURN;
2730: END IF;
2731: END IF;
2732:
2730: END IF;
2731: END IF;
2732:
2733: --------------------- Currency_code ----------------------------
2734: IF p_deliv_rec.currency_code <> FND_API.g_miss_char
2735: AND p_deliv_rec.currency_code IS NOT NULL
2736: THEN
2737: IF AMS_Utility_PVT.check_fk_exists(
2738: 'fnd_currencies',
2739: 'currency_code',
2740: p_deliv_rec.currency_code,
2741: AMS_Utility_PVT.g_varchar2,
2742: NULL
2743: ) = FND_API.g_false
2744: THEN
2745: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2746: x_return_status := FND_API.g_ret_sts_error;
2747: RETURN;
2742: NULL
2743: ) = FND_API.g_false
2744: THEN
2745: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2746: x_return_status := FND_API.g_ret_sts_error;
2747: RETURN;
2748: END IF;
2749: END IF;
2750:
2748: END IF;
2749: END IF;
2750:
2751: ---------------------Transaction_Currency_code ----------------------------
2752: IF p_deliv_rec.transaction_currency_code <> FND_API.g_miss_char
2753: AND p_deliv_rec.transaction_currency_code IS NOT NULL
2754: THEN
2755: IF AMS_Utility_PVT.check_fk_exists(
2756: 'fnd_currencies',
2757: 'currency_code',
2758: p_deliv_rec.transaction_currency_code,
2759: AMS_Utility_PVT.g_varchar2,
2760: NULL
2761: ) = FND_API.g_false
2762: THEN
2763: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2764: x_return_status := FND_API.g_ret_sts_error;
2765: RETURN;
2760: NULL
2761: ) = FND_API.g_false
2762: THEN
2763: AMS_Utility_PVT.Error_Message('AMS_TRIG_INVALID_CURR');
2764: x_return_status := FND_API.g_ret_sts_error;
2765: RETURN;
2766: END IF;
2767: END IF;
2768:
2766: END IF;
2767: END IF;
2768:
2769: --------------------- Language ----------------------------
2770: IF p_deliv_rec.language_code <> FND_API.g_miss_char
2771: AND p_deliv_rec.language_code IS NOT NULL
2772: THEN
2773: IF AMS_Utility_PVT.check_fk_exists(
2774: 'fnd_languages',
2775: 'language_code',
2776: p_deliv_rec.language_code,
2777: AMS_Utility_PVT.g_varchar2,
2778: NULL
2779: ) = FND_API.g_false
2780: THEN
2781: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_LANG');
2782: x_return_status := FND_API.g_ret_sts_error;
2783: RETURN;
2778: NULL
2779: ) = FND_API.g_false
2780: THEN
2781: AMS_Utility_PVT.Error_Message('AMS_CAMP_BAD_LANG');
2782: x_return_status := FND_API.g_ret_sts_error;
2783: RETURN;
2784: END IF;
2785: END IF;
2786:
2799: )
2800: IS
2801: BEGIN
2802:
2803: x_return_status := FND_API.g_ret_sts_success;
2804:
2805: ----------------------- status_code ------------------------
2806: IF p_deliv_rec.status_code <> FND_API.g_miss_char THEN
2807: IF AMS_Utility_PVT.check_lookup_exists(
2802:
2803: x_return_status := FND_API.g_ret_sts_success;
2804:
2805: ----------------------- status_code ------------------------
2806: IF p_deliv_rec.status_code <> FND_API.g_miss_char THEN
2807: IF AMS_Utility_PVT.check_lookup_exists(
2808: p_lookup_type => 'AMS_DELIV_STATUS',
2809: p_lookup_code => p_deliv_rec.status_code
2810: ) = FND_API.g_false
2806: IF p_deliv_rec.status_code <> FND_API.g_miss_char THEN
2807: IF AMS_Utility_PVT.check_lookup_exists(
2808: p_lookup_type => 'AMS_DELIV_STATUS',
2809: p_lookup_code => p_deliv_rec.status_code
2810: ) = FND_API.g_false
2811: THEN
2812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2813: THEN
2814: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2814: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2815: FND_MSG_PUB.add;
2816: END IF;
2817:
2818: x_return_status := FND_API.g_ret_sts_error;
2819: RETURN;
2820: END IF;
2821: END IF;
2822:
2882: IF l_qp_profile IS NULL THEN
2883: l_qp_profile := 'N';
2884: END IF;
2885:
2886: x_return_status := FND_API.g_ret_sts_success;
2887:
2888: -- validation added for the public apis
2889:
2890: IF p_validation_mode = JTF_PLSQL_API.g_create
2892: IF NVL(p_deliv_rec.inventory_flag,'N') = 'Y'
2893: THEN
2894: AMS_UTILITY_PVT.error_message('AMS_DELV_NO_INV_CRE');
2895: --- Inventory option can be enabled only after the deliverable is created.
2896: x_return_status := FND_API.g_ret_sts_error;
2897: RETURN;
2898: END IF;
2899: END IF;
2900:
2901: IF NVL(p_deliv_rec.can_fulfill_electronic_flag,'N') = NVL(p_deliv_rec.can_fulfill_physical_flag,'N')
2902: THEN
2903: AMS_UTILITY_PVT.error_message('AMS_DELV_PHY_OR_ELEC');
2904: --Please select this deliverable as physical or electronic.
2905: x_return_status := FND_API.g_ret_sts_error;
2906: RETURN;
2907: END IF;
2908:
2909: IF NVL(p_deliv_rec.can_fulfill_electronic_flag ,'N') ='Y'
2910: AND p_deliv_rec.non_inv_quantity_on_hand > 0
2911: THEN
2912: AMS_UTILITY_PVT.error_message('AMS_DELV_NO_QUAN_ELEC');
2913: --- Quantity cannot be tracked for electronic deliverable. Please change your options
2914: x_return_status := FND_API.g_ret_sts_error;
2915: RETURN;
2916: END IF;
2917: -- validation added for the public api -- end
2918: ----------------------- rollup_flag ------------------------
2915: RETURN;
2916: END IF;
2917: -- validation added for the public api -- end
2918: ----------------------- rollup_flag ------------------------
2919: IF p_deliv_rec.kit_flag <> FND_API.g_miss_char
2920: AND p_deliv_rec.kit_flag IS NOT NULL
2921: THEN
2922: IF AMS_Utility_PVT.is_Y_or_N(p_deliv_rec.kit_flag) = FND_API.g_false
2923: THEN
2918: ----------------------- rollup_flag ------------------------
2919: IF p_deliv_rec.kit_flag <> FND_API.g_miss_char
2920: AND p_deliv_rec.kit_flag IS NOT NULL
2921: THEN
2922: IF AMS_Utility_PVT.is_Y_or_N(p_deliv_rec.kit_flag) = FND_API.g_false
2923: THEN
2924: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2925: THEN
2926: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2926: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2927: FND_MSG_PUB.add;
2928: END IF;
2929:
2930: x_return_status := FND_API.g_ret_sts_error;
2931: RETURN;
2932: END IF;
2933: END IF;
2934:
2965: THEN
2966: FND_MESSAGE.set_name('AMS', 'AMS_DELV_NO_UPD_AVAL_STATUS');
2967: FND_MSG_PUB.add;
2968: END IF;
2969: x_return_status := FND_API.g_ret_sts_error;
2970: RETURN;
2971: END IF;
2972:
2973: IF (l_old_electronic_flag='N'
2977: THEN
2978: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
2979: FND_MSG_PUB.add;
2980: END IF;
2981: x_return_status := FND_API.g_ret_sts_error;
2982: RETURN;
2983: END IF;
2984:
2985:
2991: THEN
2992: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2993: FND_MSG_PUB.add;
2994: END IF;
2995: x_return_status := FND_API.g_ret_sts_error;
2996: RETURN;
2997: -- if an inv item is attached ,cannot change phy-inventoried to stock manually
2998: -- except if kit_flag is 'Y' and pricing profile is 'N'
2999: ELSIF (l_old_inventory_flag ='Y'
3005: THEN
3006: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3007: FND_MSG_PUB.add;
3008: END IF;
3009: x_return_status := FND_API.g_ret_sts_error;
3010: RETURN;
3011: END IF;
3012:
3013: IF (AMS_DEBUG_HIGH_ON) THEN
3021: THEN
3022: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3023: FND_MSG_PUB.add;
3024: END IF;
3025: x_return_status := FND_API.g_ret_sts_error;
3026: RETURN;
3027: END IF;
3028:
3029: IF (AMS_DEBUG_HIGH_ON) THEN
3036: THEN
3037: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3038: FND_MSG_PUB.add;
3039: END IF;
3040: x_return_status := FND_API.g_ret_sts_error;
3041: RETURN;
3042: END IF;
3043:
3044: --- before updating the physical and electronic flag checking whether it has kit parts
3059: THEN
3060: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
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 (l_old_physical_flag='Y'
3072: THEN
3073: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3074: FND_MSG_PUB.add;
3075: END IF;
3076: x_return_status := FND_API.g_ret_sts_error;
3077: RETURN;
3078: END IF;
3079:
3080: IF ( p_deliv_rec.can_fulfill_physical_flag = 'Y'
3086: THEN
3087: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3088: FND_MSG_PUB.add;
3089: END IF;
3090: x_return_status := FND_API.g_ret_sts_error;
3091: RETURN;
3092: END IF;
3093:
3094: -- cannot change the stock manually deliv to physically inventoried if it as phys- inv kit.
3101: THEN
3102: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3103: FND_MSG_PUB.add;
3104: END IF;
3105: x_return_status := FND_API.g_ret_sts_error;
3106: RETURN;
3107: /*
3108: ELSIF ( p_deliv_rec.can_fulfill_physical_flag = 'Y'
3109: AND l_old_inventory_flag ='Y'
3115: THEN
3116: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3117: FND_MSG_PUB.add;
3118: END IF;
3119: x_return_status := FND_API.g_ret_sts_error;
3120: RETURN;
3121: */
3122: END IF;
3123:
3132: THEN
3133: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_N');
3134: FND_MSG_PUB.add;
3135: END IF;
3136: x_return_status := FND_API.g_ret_sts_error;
3137: RETURN;
3138: end if;
3139:
3140: l_kits_check := 0;
3148: THEN
3149: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_Y');
3150: FND_MSG_PUB.add;
3151: END IF;
3152: x_return_status := FND_API.g_ret_sts_error;
3153: RETURN;
3154: end if;
3155: -- end by abhola
3156:
3166: THEN
3167: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_KIT');
3168: FND_MSG_PUB.add;
3169: END IF;
3170: x_return_status := FND_API.g_ret_sts_error;
3171: RETURN;
3172: END IF;
3173:
3174: -- check whether the deliv is a part of a kit before updating the electronic,physical,inventory flags
3180: THEN
3181: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
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 (l_old_physical_flag='Y'
3193: THEN
3194: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3195: FND_MSG_PUB.add;
3196: END IF;
3197: x_return_status := FND_API.g_ret_sts_error;
3198: RETURN;
3199: END IF;
3200:
3201: IF ( p_deliv_rec.can_fulfill_physical_flag = 'Y'
3207: THEN
3208: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3209: FND_MSG_PUB.add;
3210: END IF;
3211: x_return_status := FND_API.g_ret_sts_error;
3212: RETURN;
3213: END IF;
3214:
3215: -- cannot change the stock manually deliv to physically inventoried if it is part of phys- inv kit.
3222: THEN
3223: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3224: FND_MSG_PUB.add;
3225: END IF;
3226: x_return_status := FND_API.g_ret_sts_error;
3227: RETURN;
3228: END IF;
3229:
3230:
3265: ( p_deliv_rec => p_deliv_rec,
3266: x_return_status => x_return_status
3267: );
3268:
3269: IF x_return_status <> FND_API.g_ret_sts_success THEN
3270: RETURN;
3271: END IF;
3272: 01/29/03 commented out to allow user to chnage th status check bug #2764840 mukumar end */
3273:
3277: p_deliv_rec => p_deliv_rec,
3278: x_return_status => x_return_status
3279: );
3280:
3281: IF x_return_status <> FND_API.g_ret_sts_success THEN
3282: RETURN;
3283: END IF;
3284:
3285: check_deliv_uk_items
3288: p_validation_mode => p_validation_mode,
3289: x_return_status => x_return_status
3290: );
3291:
3292: IF x_return_status <> FND_API.g_ret_sts_success THEN
3293: RETURN;
3294: END IF;
3295:
3296: check_deliv_fk_items
3298: p_deliv_rec => p_deliv_rec,
3299: x_return_status => x_return_status
3300: );
3301:
3302: IF x_return_status <> FND_API.g_ret_sts_success THEN
3303: RETURN;
3304: END IF;
3305:
3306: check_deliv_lookup_items
3308: p_deliv_rec => p_deliv_rec,
3309: x_return_status => x_return_status
3310: );
3311:
3312: IF x_return_status <> FND_API.g_ret_sts_success THEN
3313: RETURN;
3314: END IF;
3315:
3316: check_deliv_flag_items
3319: p_validation_mode => p_validation_mode,
3320: x_return_status => x_return_status
3321: );
3322:
3323: IF x_return_status <> FND_API.g_ret_sts_success THEN
3324: RETURN;
3325: END IF;
3326:
3327: check_owner_id
3329: p_deliv_rec => p_deliv_Rec,
3330: x_return_status => x_return_status
3331: );
3332:
3333: IF x_return_status <> FND_API.g_ret_sts_success THEN
3334: RETURN;
3335: END IF;
3336:
3337: IF (AMS_DEBUG_HIGH_ON) THEN
3343: p_deliv_rec => p_deliv_rec,
3344: x_return_status => x_Return_status
3345: );
3346:
3347: IF x_return_status <> FND_API.g_ret_sts_success THEN
3348: RETURN;
3349: END IF;
3350:
3351: IF (AMS_DEBUG_HIGH_ON) THEN
3357: IF p_deliv_rec.start_period_name IS NOT NULL THEN
3358: OPEN c_period (p_deliv_rec.start_period_name);
3359: FETCH c_period INTO l_dummy;
3360: IF c_period%NOTFOUND THEN
3361: x_return_status := FND_API.g_ret_sts_error;
3362: AMS_Utility_PVT.error_message ('AMS_CAMP_BAD_START_PERIOD');
3363: END IF;
3364: CLOSE c_period;
3365: END IF;
3367: IF p_deliv_rec.end_period_name iS NOT NULL THEN
3368: OPEN c_period (p_deliv_rec.end_period_name);
3369: FETCH c_period INTO l_dummy;
3370: IF c_period%NOTFOUND THEN
3371: x_return_status := FND_API.g_ret_sts_error;
3372: AMS_Utility_PVT.error_message ('AMS_CAMP_BAD_END_PERIOD');
3373: END IF;
3374: CLOSE c_period;
3375: END IF;
3412: l_start_rec c_period%ROWTYPE;
3413: l_end_rec c_period%ROWTYPE;
3414: BEGIN
3415:
3416: x_return_status := FND_API.g_ret_sts_success;
3417:
3418: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3419: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3420: THEN
3414: BEGIN
3415:
3416: x_return_status := FND_API.g_ret_sts_success;
3417:
3418: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3419: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3420: THEN
3421: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3422: l_start_date := p_complete_rec.actual_avail_from_date;
3415:
3416: x_return_status := FND_API.g_ret_sts_success;
3417:
3418: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3419: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3420: THEN
3421: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3422: l_start_date := p_complete_rec.actual_avail_from_date;
3423: ELSE
3417:
3418: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3419: OR p_deliv_rec.actual_avail_to_date <> FND_API.g_miss_date
3420: THEN
3421: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3422: l_start_date := p_complete_rec.actual_avail_from_date;
3423: ELSE
3424: l_start_date := p_deliv_rec.actual_avail_from_date;
3425: END IF;
3423: ELSE
3424: l_start_date := p_deliv_rec.actual_avail_from_date;
3425: END IF;
3426:
3427: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3428: l_end_date := p_complete_rec.actual_avail_to_date;
3429: ELSE
3430: l_end_date := p_deliv_rec.actual_avail_to_date;
3431: END IF;
3435: THEN
3436: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DATE_AFTER_DATE');
3437: FND_MSG_PUB.add;
3438: END IF;
3439: x_return_status := FND_API.g_ret_sts_error;
3440: END IF;
3441: END IF;
3442:
3443: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3439: x_return_status := FND_API.g_ret_sts_error;
3440: END IF;
3441: END IF;
3442:
3443: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3444: OR p_deliv_rec.forecasted_complete_date <> FND_API.g_miss_date
3445: THEN
3446: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3447: l_start_date := p_complete_rec.actual_avail_from_date;
3440: END IF;
3441: END IF;
3442:
3443: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3444: OR p_deliv_rec.forecasted_complete_date <> FND_API.g_miss_date
3445: THEN
3446: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3447: l_start_date := p_complete_rec.actual_avail_from_date;
3448: ELSE
3442:
3443: IF p_deliv_rec.actual_avail_from_date <> FND_API.g_miss_date
3444: OR p_deliv_rec.forecasted_complete_date <> FND_API.g_miss_date
3445: THEN
3446: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3447: l_start_date := p_complete_rec.actual_avail_from_date;
3448: ELSE
3449: l_start_date := p_deliv_rec.actual_avail_from_date;
3450: END IF;
3448: ELSE
3449: l_start_date := p_deliv_rec.actual_avail_from_date;
3450: END IF;
3451:
3452: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3453: l_fore_comp_date := p_complete_rec.forecasted_complete_date;
3454: ELSE
3455: l_fore_comp_date := p_deliv_rec.forecasted_complete_date;
3456: END IF;
3460: THEN
3461: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_AFTER_START');
3462: FND_MSG_PUB.add;
3463: END IF;
3464: x_return_status := FND_API.g_ret_sts_error;
3465: END IF;
3466:
3467: /* remove on 06/07/2000 by khung
3468: IF p_deliv_rec.deliverable_id IS NULL THEN -- only for creation
3471: THEN
3472: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_BEFORE_TODAY');
3473: FND_MSG_PUB.add;
3474: END IF;
3475: x_return_status := FND_API.g_ret_sts_error;
3476: END IF;
3477: END IF;
3478: */
3479: END IF;
3485: -- validate calendr exists only if start or end period is chosen
3486: OPEN c_calendar (p_deliv_rec.deliverable_calendar);
3487: FETCH c_calendar INTO l_dummy;
3488: IF c_calendar%NOTFOUND THEN
3489: x_return_status := FND_API.g_ret_sts_error;
3490: AMS_Utility_PVT.error_message ('AMS_CAMP_NO_CAMPAIGN_CALENDAR');
3491: END IF;
3492: CLOSE c_calendar;
3493: END IF;
3508: -- The start period start date should be
3509: -- before the end period end date
3510: IF l_start_rec.start_date IS NOT NULL AND l_end_rec.end_date IS NOT NULL THEN
3511: IF l_start_rec.start_date > l_end_rec.end_date THEN
3512: x_return_status := FND_API.g_ret_sts_error;
3513: AMS_Utility_PVT.error_message ('AMS_CAMP_BAD_PERIODS');
3514: END IF;
3515: END IF;
3516:
3518: -- Available From date should be within
3519: -- the given start period date range.
3520: IF l_start_rec.start_date IS NOT NULL THEN
3521: 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
3522: x_return_status := FND_API.g_ret_sts_error;
3523: AMS_Utility_PVT.error_message ('AMS_DELV_OUT_START_DATE');
3524: END IF;
3525: END IF;
3526:
3528: -- Available To date should be within the
3529: -- given end period date range.
3530: IF l_end_rec.start_date IS NOT NULL THEN
3531: 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
3532: x_return_status := FND_API.g_ret_sts_error;
3533: AMS_Utility_PVT.error_message ('AMS_DELV_OUT_END_DATE');
3534: END IF;
3535: END IF;
3536:
3556:
3557: IF (AMS_DEBUG_HIGH_ON) THEN
3558: AMS_Utility_PVT.debug_message('IN THE INIT_DELIV REC');
3559: END IF;
3560: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3561: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3557: IF (AMS_DEBUG_HIGH_ON) THEN
3558: AMS_Utility_PVT.debug_message('IN THE INIT_DELIV REC');
3559: END IF;
3560: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3561: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3558: AMS_Utility_PVT.debug_message('IN THE INIT_DELIV REC');
3559: END IF;
3560: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3561: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3559: END IF;
3560: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3561: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3560: x_deliv_rec.deliverable_id := FND_API.g_miss_num;
3561: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3561: x_deliv_rec.last_update_date := FND_API.g_miss_date;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3562: x_deliv_rec.last_updated_by := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3563: x_deliv_rec.creation_date := FND_API.g_miss_date;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3564: x_deliv_rec.created_by := FND_API.g_miss_num;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3565: x_deliv_rec.last_update_login := FND_API.g_miss_num;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3566: x_deliv_rec.object_version_number := FND_API.g_miss_num;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3567: x_deliv_rec.language_code := FND_API.g_miss_char;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3568: x_deliv_rec.version := FND_API.g_miss_char;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3569: x_deliv_rec.application_id := FND_API.g_miss_num;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3570: x_deliv_rec.user_status_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3571: x_deliv_rec.status_code := FND_API.g_miss_char;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3572: x_deliv_rec.status_date := FND_API.g_miss_date;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3573: x_deliv_rec.active_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3574: x_deliv_rec.private_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3575: x_deliv_rec.owner_user_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3576: x_deliv_rec.fund_source_id := FND_API.g_miss_num;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3577: x_deliv_rec.fund_source_type := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3578: x_deliv_rec.category_type_id := FND_API.g_miss_num;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3579: x_deliv_rec.category_sub_type_id := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3580: x_deliv_rec.kit_flag := FND_API.g_miss_char;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3581: x_deliv_rec.can_fulfill_electronic_flag := FND_API.g_miss_char;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3582: x_deliv_rec.can_fulfill_physical_flag := FND_API.g_miss_char;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3583: x_deliv_rec.jtf_amv_item_id := FND_API.g_miss_num;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3584: x_deliv_rec.inventory_flag := FND_API.g_miss_char;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3585: x_deliv_rec.transaction_currency_code := FND_API.g_miss_char;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3586: x_deliv_rec.functional_currency_code := FND_API.g_miss_char;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3587: x_deliv_rec.budget_amount_tc := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3588: x_deliv_rec.budget_amount_fc := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3589: x_deliv_rec.actual_avail_from_date := FND_API.g_miss_date;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3590: x_deliv_rec.actual_avail_to_date := FND_API.g_miss_date;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3591: x_deliv_rec.forecasted_complete_date := FND_API.g_miss_date;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3592: x_deliv_rec.actual_complete_date := FND_API.g_miss_date;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3593: x_deliv_rec.replaced_by_deliverable_id := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3594: x_deliv_rec.inventory_item_id := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3595: x_deliv_rec.inventory_item_org_id := FND_API.g_miss_num;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3596: x_deliv_rec.pricelist_header_id := FND_API.g_miss_num;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3597: x_deliv_rec.pricelist_line_id := FND_API.g_miss_num;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3598: x_deliv_rec.non_inv_ctrl_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3599: x_deliv_rec.non_inv_quantity_on_hand := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3600: x_deliv_rec.non_inv_quantity_on_order := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3601: x_deliv_rec.non_inv_quantity_on_reserve := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3602: x_deliv_rec.chargeback_amount := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3603: x_deliv_rec.chargeback_amount_curr_code := FND_API.g_miss_char;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3604: x_deliv_rec.deliverable_code := FND_API.g_miss_char;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3605: x_deliv_rec.deliverable_pick_flag := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3606: x_deliv_rec.currency_code := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3607: x_deliv_rec.forecasted_cost := FND_API.g_miss_num;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3608: x_deliv_rec.actual_cost := FND_API.g_miss_num;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3609: x_deliv_rec.forecasted_responses := FND_API.g_miss_num;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3610: x_deliv_rec.actual_responses := FND_API.g_miss_num;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3611: x_deliv_rec.country_id := FND_API.g_miss_num;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3612: x_deliv_rec.setup_id := FND_API.g_miss_num;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3613: x_deliv_rec.attribute_category := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3614: x_deliv_rec.attribute1 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3615: x_deliv_rec.attribute2 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3616: x_deliv_rec.attribute3 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3617: x_deliv_rec.attribute4 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3618: x_deliv_rec.attribute5 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3619: x_deliv_rec.attribute6 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3620: x_deliv_rec.attribute7 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3621: x_deliv_rec.attribute8 := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3622: x_deliv_rec.attribute9 := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3623: x_deliv_rec.attribute10 := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3624: x_deliv_rec.attribute11 := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3625: x_deliv_rec.attribute12 := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3633: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3626: x_deliv_rec.attribute13 := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3633: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3634: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3627: x_deliv_rec.attribute14 := FND_API.g_miss_char;
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3633: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3634: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3635:
3628: x_deliv_rec.attribute15 := FND_API.g_miss_char;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3633: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3634: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3635:
3636: END init_deliv_rec;
3629: x_deliv_rec.chargeback_uom := FND_API.g_miss_char;
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3633: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3634: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3635:
3636: END init_deliv_rec;
3637:
3630: x_deliv_rec.deliverable_name := FND_API.g_miss_char;
3631: x_deliv_rec.description := FND_API.g_miss_char;
3632: x_deliv_rec.deliverable_calendar := FND_API.g_miss_char;
3633: x_deliv_rec.start_period_name := FND_API.g_miss_char;
3634: x_deliv_rec.end_period_name := FND_API.g_miss_char;
3635:
3636: END init_deliv_rec;
3637:
3638: ---------------------------------------------------------------------
3675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3676: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3677: FND_MSG_PUB.add;
3678: END IF;
3679: RAISE FND_API.g_exc_error;
3680: END IF;
3681: CLOSE c_deliv;
3682:
3683: IF p_deliv_rec.language_code = FND_API.g_miss_char THEN
3679: RAISE FND_API.g_exc_error;
3680: END IF;
3681: CLOSE c_deliv;
3682:
3683: IF p_deliv_rec.language_code = FND_API.g_miss_char THEN
3684: x_complete_rec.language_code := l_deliv_rec.language_code;
3685: END IF;
3686:
3687: IF p_deliv_rec.version = FND_API.g_miss_char THEN
3683: IF p_deliv_rec.language_code = FND_API.g_miss_char THEN
3684: x_complete_rec.language_code := l_deliv_rec.language_code;
3685: END IF;
3686:
3687: IF p_deliv_rec.version = FND_API.g_miss_char THEN
3688: x_complete_rec.version := l_deliv_rec.version;
3689: END IF;
3690:
3691: IF p_deliv_rec.application_id = FND_API.g_miss_num THEN
3687: IF p_deliv_rec.version = FND_API.g_miss_char THEN
3688: x_complete_rec.version := l_deliv_rec.version;
3689: END IF;
3690:
3691: IF p_deliv_rec.application_id = FND_API.g_miss_num THEN
3692: x_complete_rec.application_id := l_deliv_rec.application_id;
3693: END IF;
3694:
3695: IF p_deliv_rec.user_status_id = FND_API.g_miss_num THEN
3691: IF p_deliv_rec.application_id = FND_API.g_miss_num THEN
3692: x_complete_rec.application_id := l_deliv_rec.application_id;
3693: END IF;
3694:
3695: IF p_deliv_rec.user_status_id = FND_API.g_miss_num THEN
3696: x_complete_rec.user_status_id := l_deliv_rec.user_status_id;
3697: END IF;
3698:
3699: IF p_deliv_rec.status_code = FND_API.g_miss_char THEN
3695: IF p_deliv_rec.user_status_id = FND_API.g_miss_num THEN
3696: x_complete_rec.user_status_id := l_deliv_rec.user_status_id;
3697: END IF;
3698:
3699: IF p_deliv_rec.status_code = FND_API.g_miss_char THEN
3700: x_complete_rec.status_code := l_deliv_rec.status_code;
3701: END IF;
3702:
3703: IF p_deliv_rec.status_date = FND_API.g_miss_date THEN
3699: IF p_deliv_rec.status_code = FND_API.g_miss_char THEN
3700: x_complete_rec.status_code := l_deliv_rec.status_code;
3701: END IF;
3702:
3703: IF p_deliv_rec.status_date = FND_API.g_miss_date THEN
3704: x_complete_rec.status_date := l_deliv_rec.status_date;
3705: END IF;
3706:
3707: IF p_deliv_rec.active_flag = FND_API.g_miss_char THEN
3703: IF p_deliv_rec.status_date = FND_API.g_miss_date THEN
3704: x_complete_rec.status_date := l_deliv_rec.status_date;
3705: END IF;
3706:
3707: IF p_deliv_rec.active_flag = FND_API.g_miss_char THEN
3708: x_complete_rec.active_flag := l_deliv_rec.active_flag;
3709: END IF;
3710:
3711: IF p_deliv_rec.private_flag = FND_API.g_miss_char THEN
3707: IF p_deliv_rec.active_flag = FND_API.g_miss_char THEN
3708: x_complete_rec.active_flag := l_deliv_rec.active_flag;
3709: END IF;
3710:
3711: IF p_deliv_rec.private_flag = FND_API.g_miss_char THEN
3712: x_complete_rec.private_flag := l_deliv_rec.private_flag;
3713: END IF;
3714:
3715: IF p_deliv_rec.owner_user_id = FND_API.g_miss_num THEN
3711: IF p_deliv_rec.private_flag = FND_API.g_miss_char THEN
3712: x_complete_rec.private_flag := l_deliv_rec.private_flag;
3713: END IF;
3714:
3715: IF p_deliv_rec.owner_user_id = FND_API.g_miss_num THEN
3716: x_complete_rec.owner_user_id := l_deliv_rec.owner_user_id;
3717: END IF;
3718:
3719: IF p_deliv_rec.fund_source_id = FND_API.g_miss_num THEN
3715: IF p_deliv_rec.owner_user_id = FND_API.g_miss_num THEN
3716: x_complete_rec.owner_user_id := l_deliv_rec.owner_user_id;
3717: END IF;
3718:
3719: IF p_deliv_rec.fund_source_id = FND_API.g_miss_num THEN
3720: x_complete_rec.fund_source_id := l_deliv_rec.fund_source_id;
3721: END IF;
3722:
3723: IF p_deliv_rec.fund_source_type = FND_API.g_miss_char THEN
3719: IF p_deliv_rec.fund_source_id = FND_API.g_miss_num THEN
3720: x_complete_rec.fund_source_id := l_deliv_rec.fund_source_id;
3721: END IF;
3722:
3723: IF p_deliv_rec.fund_source_type = FND_API.g_miss_char THEN
3724: x_complete_rec.fund_source_type := l_deliv_rec.fund_source_type;
3725: END IF;
3726:
3727: IF p_deliv_rec.category_type_id = FND_API.g_miss_num THEN
3723: IF p_deliv_rec.fund_source_type = FND_API.g_miss_char THEN
3724: x_complete_rec.fund_source_type := l_deliv_rec.fund_source_type;
3725: END IF;
3726:
3727: IF p_deliv_rec.category_type_id = FND_API.g_miss_num THEN
3728: x_complete_rec.category_type_id := l_deliv_rec.category_type_id;
3729: END IF;
3730:
3731: IF p_deliv_rec.category_sub_type_id = FND_API.g_miss_num THEN
3727: IF p_deliv_rec.category_type_id = FND_API.g_miss_num THEN
3728: x_complete_rec.category_type_id := l_deliv_rec.category_type_id;
3729: END IF;
3730:
3731: IF p_deliv_rec.category_sub_type_id = FND_API.g_miss_num THEN
3732: x_complete_rec.category_sub_type_id := l_deliv_rec.category_sub_type_id;
3733: END IF;
3734:
3735: IF p_deliv_rec.kit_flag = FND_API.g_miss_char THEN
3731: IF p_deliv_rec.category_sub_type_id = FND_API.g_miss_num THEN
3732: x_complete_rec.category_sub_type_id := l_deliv_rec.category_sub_type_id;
3733: END IF;
3734:
3735: IF p_deliv_rec.kit_flag = FND_API.g_miss_char THEN
3736: x_complete_rec.kit_flag := l_deliv_rec.kit_flag;
3737: END IF;
3738:
3739: IF p_deliv_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
3735: IF p_deliv_rec.kit_flag = FND_API.g_miss_char THEN
3736: x_complete_rec.kit_flag := l_deliv_rec.kit_flag;
3737: END IF;
3738:
3739: IF p_deliv_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
3740: x_complete_rec.can_fulfill_electronic_flag := l_deliv_rec.can_fulfill_electronic_flag;
3741: END IF;
3742:
3743: IF p_deliv_rec.can_fulfill_physical_flag = FND_API.g_miss_char THEN
3739: IF p_deliv_rec.can_fulfill_electronic_flag = FND_API.g_miss_char THEN
3740: x_complete_rec.can_fulfill_electronic_flag := l_deliv_rec.can_fulfill_electronic_flag;
3741: END IF;
3742:
3743: IF p_deliv_rec.can_fulfill_physical_flag = FND_API.g_miss_char THEN
3744: x_complete_rec.can_fulfill_physical_flag := l_deliv_rec.can_fulfill_physical_flag;
3745: END IF;
3746:
3747: IF p_deliv_rec.jtf_amv_item_id = FND_API.g_miss_num THEN
3743: IF p_deliv_rec.can_fulfill_physical_flag = FND_API.g_miss_char THEN
3744: x_complete_rec.can_fulfill_physical_flag := l_deliv_rec.can_fulfill_physical_flag;
3745: END IF;
3746:
3747: IF p_deliv_rec.jtf_amv_item_id = FND_API.g_miss_num THEN
3748: x_complete_rec.jtf_amv_item_id := l_deliv_rec.jtf_amv_item_id;
3749: END IF;
3750:
3751: IF p_deliv_rec.inventory_flag = FND_API.g_miss_char THEN
3747: IF p_deliv_rec.jtf_amv_item_id = FND_API.g_miss_num THEN
3748: x_complete_rec.jtf_amv_item_id := l_deliv_rec.jtf_amv_item_id;
3749: END IF;
3750:
3751: IF p_deliv_rec.inventory_flag = FND_API.g_miss_char THEN
3752: x_complete_rec.inventory_flag := l_deliv_rec.inventory_flag;
3753: END IF;
3754:
3755: IF p_deliv_rec.transaction_currency_code = FND_API.g_miss_char THEN
3751: IF p_deliv_rec.inventory_flag = FND_API.g_miss_char THEN
3752: x_complete_rec.inventory_flag := l_deliv_rec.inventory_flag;
3753: END IF;
3754:
3755: IF p_deliv_rec.transaction_currency_code = FND_API.g_miss_char THEN
3756: x_complete_rec.transaction_currency_code := l_deliv_rec.transaction_currency_code;
3757: END IF;
3758:
3759: IF p_deliv_rec.functional_currency_code = FND_API.g_miss_char THEN
3755: IF p_deliv_rec.transaction_currency_code = FND_API.g_miss_char THEN
3756: x_complete_rec.transaction_currency_code := l_deliv_rec.transaction_currency_code;
3757: END IF;
3758:
3759: IF p_deliv_rec.functional_currency_code = FND_API.g_miss_char THEN
3760: x_complete_rec.functional_currency_code := l_deliv_rec.functional_currency_code;
3761: END IF;
3762:
3763: IF p_deliv_rec.budget_amount_tc = FND_API.g_miss_num THEN
3759: IF p_deliv_rec.functional_currency_code = FND_API.g_miss_char THEN
3760: x_complete_rec.functional_currency_code := l_deliv_rec.functional_currency_code;
3761: END IF;
3762:
3763: IF p_deliv_rec.budget_amount_tc = FND_API.g_miss_num THEN
3764: x_complete_rec.budget_amount_tc := l_deliv_rec.budget_amount_tc;
3765: END IF;
3766:
3767: IF p_deliv_rec.budget_amount_fc = FND_API.g_miss_num THEN
3763: IF p_deliv_rec.budget_amount_tc = FND_API.g_miss_num THEN
3764: x_complete_rec.budget_amount_tc := l_deliv_rec.budget_amount_tc;
3765: END IF;
3766:
3767: IF p_deliv_rec.budget_amount_fc = FND_API.g_miss_num THEN
3768: x_complete_rec.budget_amount_fc := l_deliv_rec.budget_amount_fc;
3769: END IF;
3770:
3771: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3767: IF p_deliv_rec.budget_amount_fc = FND_API.g_miss_num THEN
3768: x_complete_rec.budget_amount_fc := l_deliv_rec.budget_amount_fc;
3769: END IF;
3770:
3771: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3772: x_complete_rec.actual_avail_from_date := l_deliv_rec.actual_avail_from_date;
3773: END IF;
3774:
3775: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3771: IF p_deliv_rec.actual_avail_from_date = FND_API.g_miss_date THEN
3772: x_complete_rec.actual_avail_from_date := l_deliv_rec.actual_avail_from_date;
3773: END IF;
3774:
3775: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3776: x_complete_rec.actual_avail_to_date := l_deliv_rec.actual_avail_to_date;
3777: END IF;
3778:
3779: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3775: IF p_deliv_rec.actual_avail_to_date = FND_API.g_miss_date THEN
3776: x_complete_rec.actual_avail_to_date := l_deliv_rec.actual_avail_to_date;
3777: END IF;
3778:
3779: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3780: x_complete_rec.forecasted_complete_date := l_deliv_rec.forecasted_complete_date;
3781: END IF;
3782:
3783: IF p_deliv_rec.actual_complete_date = FND_API.g_miss_date THEN
3779: IF p_deliv_rec.forecasted_complete_date = FND_API.g_miss_date THEN
3780: x_complete_rec.forecasted_complete_date := l_deliv_rec.forecasted_complete_date;
3781: END IF;
3782:
3783: IF p_deliv_rec.actual_complete_date = FND_API.g_miss_date THEN
3784: x_complete_rec.actual_complete_date := l_deliv_rec.actual_complete_date;
3785: END IF;
3786:
3787: IF p_deliv_rec.replaced_by_deliverable_id = FND_API.g_miss_num THEN
3783: IF p_deliv_rec.actual_complete_date = FND_API.g_miss_date THEN
3784: x_complete_rec.actual_complete_date := l_deliv_rec.actual_complete_date;
3785: END IF;
3786:
3787: IF p_deliv_rec.replaced_by_deliverable_id = FND_API.g_miss_num THEN
3788: x_complete_rec.replaced_by_deliverable_id := l_deliv_rec.replaced_by_deliverable_id;
3789: END IF;
3790:
3791: IF p_deliv_rec.inventory_item_id = FND_API.g_miss_num THEN
3787: IF p_deliv_rec.replaced_by_deliverable_id = FND_API.g_miss_num THEN
3788: x_complete_rec.replaced_by_deliverable_id := l_deliv_rec.replaced_by_deliverable_id;
3789: END IF;
3790:
3791: IF p_deliv_rec.inventory_item_id = FND_API.g_miss_num THEN
3792: x_complete_rec.inventory_item_id := l_deliv_rec.inventory_item_id;
3793: END IF;
3794:
3795: IF p_deliv_rec.inventory_item_org_id = FND_API.g_miss_num THEN
3791: IF p_deliv_rec.inventory_item_id = FND_API.g_miss_num THEN
3792: x_complete_rec.inventory_item_id := l_deliv_rec.inventory_item_id;
3793: END IF;
3794:
3795: IF p_deliv_rec.inventory_item_org_id = FND_API.g_miss_num THEN
3796: x_complete_rec.inventory_item_org_id := l_deliv_rec.inventory_item_org_id;
3797: END IF;
3798:
3799: IF p_deliv_rec.pricelist_header_id = FND_API.g_miss_num THEN
3795: IF p_deliv_rec.inventory_item_org_id = FND_API.g_miss_num THEN
3796: x_complete_rec.inventory_item_org_id := l_deliv_rec.inventory_item_org_id;
3797: END IF;
3798:
3799: IF p_deliv_rec.pricelist_header_id = FND_API.g_miss_num THEN
3800: x_complete_rec.pricelist_header_id := l_deliv_rec.pricelist_header_id;
3801: END IF;
3802:
3803: IF p_deliv_rec.pricelist_line_id = FND_API.g_miss_num THEN
3799: IF p_deliv_rec.pricelist_header_id = FND_API.g_miss_num THEN
3800: x_complete_rec.pricelist_header_id := l_deliv_rec.pricelist_header_id;
3801: END IF;
3802:
3803: IF p_deliv_rec.pricelist_line_id = FND_API.g_miss_num THEN
3804: x_complete_rec.pricelist_line_id := l_deliv_rec.pricelist_line_id;
3805: END IF;
3806:
3807: IF p_deliv_rec.non_inv_ctrl_code = FND_API.g_miss_char THEN
3803: IF p_deliv_rec.pricelist_line_id = FND_API.g_miss_num THEN
3804: x_complete_rec.pricelist_line_id := l_deliv_rec.pricelist_line_id;
3805: END IF;
3806:
3807: IF p_deliv_rec.non_inv_ctrl_code = FND_API.g_miss_char THEN
3808: x_complete_rec.non_inv_ctrl_code := l_deliv_rec.non_inv_ctrl_code;
3809: END IF;
3810:
3811: IF p_deliv_rec.non_inv_quantity_on_hand = FND_API.g_miss_num THEN
3807: IF p_deliv_rec.non_inv_ctrl_code = FND_API.g_miss_char THEN
3808: x_complete_rec.non_inv_ctrl_code := l_deliv_rec.non_inv_ctrl_code;
3809: END IF;
3810:
3811: IF p_deliv_rec.non_inv_quantity_on_hand = FND_API.g_miss_num THEN
3812: x_complete_rec.non_inv_quantity_on_hand := l_deliv_rec.non_inv_quantity_on_hand;
3813: END IF;
3814:
3815: IF p_deliv_rec.non_inv_quantity_on_order = FND_API.g_miss_num THEN
3811: IF p_deliv_rec.non_inv_quantity_on_hand = FND_API.g_miss_num THEN
3812: x_complete_rec.non_inv_quantity_on_hand := l_deliv_rec.non_inv_quantity_on_hand;
3813: END IF;
3814:
3815: IF p_deliv_rec.non_inv_quantity_on_order = FND_API.g_miss_num THEN
3816: x_complete_rec.non_inv_quantity_on_order := l_deliv_rec.non_inv_quantity_on_order;
3817: END IF;
3818:
3819: IF p_deliv_rec.non_inv_quantity_on_reserve = FND_API.g_miss_num THEN
3815: IF p_deliv_rec.non_inv_quantity_on_order = FND_API.g_miss_num THEN
3816: x_complete_rec.non_inv_quantity_on_order := l_deliv_rec.non_inv_quantity_on_order;
3817: END IF;
3818:
3819: IF p_deliv_rec.non_inv_quantity_on_reserve = FND_API.g_miss_num THEN
3820: x_complete_rec.non_inv_quantity_on_reserve := l_deliv_rec.non_inv_quantity_on_reserve;
3821: END IF;
3822:
3823: IF p_deliv_rec.chargeback_amount = FND_API.g_miss_num THEN
3819: IF p_deliv_rec.non_inv_quantity_on_reserve = FND_API.g_miss_num THEN
3820: x_complete_rec.non_inv_quantity_on_reserve := l_deliv_rec.non_inv_quantity_on_reserve;
3821: END IF;
3822:
3823: IF p_deliv_rec.chargeback_amount = FND_API.g_miss_num THEN
3824: x_complete_rec.chargeback_amount := l_deliv_rec.chargeback_amount;
3825: END IF;
3826:
3827: IF p_deliv_rec.chargeback_amount_curr_code = FND_API.g_miss_char THEN
3823: IF p_deliv_rec.chargeback_amount = FND_API.g_miss_num THEN
3824: x_complete_rec.chargeback_amount := l_deliv_rec.chargeback_amount;
3825: END IF;
3826:
3827: IF p_deliv_rec.chargeback_amount_curr_code = FND_API.g_miss_char THEN
3828: x_complete_rec.chargeback_amount_curr_code := l_deliv_rec.chargeback_amount_curr_code;
3829: END IF;
3830:
3831: IF p_deliv_rec.deliverable_code = FND_API.g_miss_char THEN
3827: IF p_deliv_rec.chargeback_amount_curr_code = FND_API.g_miss_char THEN
3828: x_complete_rec.chargeback_amount_curr_code := l_deliv_rec.chargeback_amount_curr_code;
3829: END IF;
3830:
3831: IF p_deliv_rec.deliverable_code = FND_API.g_miss_char THEN
3832: x_complete_rec.deliverable_code := l_deliv_rec.deliverable_code;
3833: END IF;
3834:
3835: IF p_deliv_rec.deliverable_pick_flag = FND_API.g_miss_char THEN
3831: IF p_deliv_rec.deliverable_code = FND_API.g_miss_char THEN
3832: x_complete_rec.deliverable_code := l_deliv_rec.deliverable_code;
3833: END IF;
3834:
3835: IF p_deliv_rec.deliverable_pick_flag = FND_API.g_miss_char THEN
3836: x_complete_rec.deliverable_pick_flag := l_deliv_rec.deliverable_pick_flag;
3837: END IF;
3838:
3839: IF p_deliv_rec.currency_code = FND_API.g_miss_char THEN
3835: IF p_deliv_rec.deliverable_pick_flag = FND_API.g_miss_char THEN
3836: x_complete_rec.deliverable_pick_flag := l_deliv_rec.deliverable_pick_flag;
3837: END IF;
3838:
3839: IF p_deliv_rec.currency_code = FND_API.g_miss_char THEN
3840: x_complete_rec.currency_code := l_deliv_rec.currency_code;
3841: END IF;
3842:
3843: IF p_deliv_rec.forecasted_cost = FND_API.g_miss_num THEN
3839: IF p_deliv_rec.currency_code = FND_API.g_miss_char THEN
3840: x_complete_rec.currency_code := l_deliv_rec.currency_code;
3841: END IF;
3842:
3843: IF p_deliv_rec.forecasted_cost = FND_API.g_miss_num THEN
3844: x_complete_rec.forecasted_cost := l_deliv_rec.forecasted_cost;
3845: END IF;
3846:
3847: IF p_deliv_rec.actual_cost = FND_API.g_miss_num THEN
3843: IF p_deliv_rec.forecasted_cost = FND_API.g_miss_num THEN
3844: x_complete_rec.forecasted_cost := l_deliv_rec.forecasted_cost;
3845: END IF;
3846:
3847: IF p_deliv_rec.actual_cost = FND_API.g_miss_num THEN
3848: x_complete_rec.actual_cost := l_deliv_rec.actual_cost;
3849: END IF;
3850:
3851: IF p_deliv_rec.forecasted_responses = FND_API.g_miss_num THEN
3847: IF p_deliv_rec.actual_cost = FND_API.g_miss_num THEN
3848: x_complete_rec.actual_cost := l_deliv_rec.actual_cost;
3849: END IF;
3850:
3851: IF p_deliv_rec.forecasted_responses = FND_API.g_miss_num THEN
3852: x_complete_rec.forecasted_responses := l_deliv_rec.forecasted_responses;
3853: END IF;
3854:
3855: IF p_deliv_rec.actual_responses = FND_API.g_miss_num THEN
3851: IF p_deliv_rec.forecasted_responses = FND_API.g_miss_num THEN
3852: x_complete_rec.forecasted_responses := l_deliv_rec.forecasted_responses;
3853: END IF;
3854:
3855: IF p_deliv_rec.actual_responses = FND_API.g_miss_num THEN
3856: x_complete_rec.actual_responses := l_deliv_rec.actual_responses;
3857: END IF;
3858:
3859: IF p_deliv_rec.country = FND_API.g_miss_char THEN
3855: IF p_deliv_rec.actual_responses = FND_API.g_miss_num THEN
3856: x_complete_rec.actual_responses := l_deliv_rec.actual_responses;
3857: END IF;
3858:
3859: IF p_deliv_rec.country = FND_API.g_miss_char THEN
3860: x_complete_rec.country := l_deliv_rec.country;
3861: END IF;
3862:
3863: IF p_deliv_rec.attribute_category = FND_API.g_miss_char THEN
3859: IF p_deliv_rec.country = FND_API.g_miss_char THEN
3860: x_complete_rec.country := l_deliv_rec.country;
3861: END IF;
3862:
3863: IF p_deliv_rec.attribute_category = FND_API.g_miss_char THEN
3864: x_complete_rec.attribute_category := l_deliv_rec.attribute_category;
3865: END IF;
3866:
3867: IF p_deliv_rec.attribute1 = FND_API.g_miss_char THEN
3863: IF p_deliv_rec.attribute_category = FND_API.g_miss_char THEN
3864: x_complete_rec.attribute_category := l_deliv_rec.attribute_category;
3865: END IF;
3866:
3867: IF p_deliv_rec.attribute1 = FND_API.g_miss_char THEN
3868: x_complete_rec.attribute1 := l_deliv_rec.attribute1;
3869: END IF;
3870:
3871: IF p_deliv_rec.attribute2 = FND_API.g_miss_char THEN
3867: IF p_deliv_rec.attribute1 = FND_API.g_miss_char THEN
3868: x_complete_rec.attribute1 := l_deliv_rec.attribute1;
3869: END IF;
3870:
3871: IF p_deliv_rec.attribute2 = FND_API.g_miss_char THEN
3872: x_complete_rec.attribute2 := l_deliv_rec.attribute2;
3873: END IF;
3874:
3875: IF p_deliv_rec.attribute3 = FND_API.g_miss_char THEN
3871: IF p_deliv_rec.attribute2 = FND_API.g_miss_char THEN
3872: x_complete_rec.attribute2 := l_deliv_rec.attribute2;
3873: END IF;
3874:
3875: IF p_deliv_rec.attribute3 = FND_API.g_miss_char THEN
3876: x_complete_rec.attribute3 := l_deliv_rec.attribute3;
3877: END IF;
3878:
3879: IF p_deliv_rec.attribute4 = FND_API.g_miss_char THEN
3875: IF p_deliv_rec.attribute3 = FND_API.g_miss_char THEN
3876: x_complete_rec.attribute3 := l_deliv_rec.attribute3;
3877: END IF;
3878:
3879: IF p_deliv_rec.attribute4 = FND_API.g_miss_char THEN
3880: x_complete_rec.attribute4 := l_deliv_rec.attribute4;
3881: END IF;
3882:
3883: IF p_deliv_rec.attribute5 = FND_API.g_miss_char THEN
3879: IF p_deliv_rec.attribute4 = FND_API.g_miss_char THEN
3880: x_complete_rec.attribute4 := l_deliv_rec.attribute4;
3881: END IF;
3882:
3883: IF p_deliv_rec.attribute5 = FND_API.g_miss_char THEN
3884: x_complete_rec.attribute5 := l_deliv_rec.attribute5;
3885: END IF;
3886:
3887: IF p_deliv_rec.attribute6 = FND_API.g_miss_char THEN
3883: IF p_deliv_rec.attribute5 = FND_API.g_miss_char THEN
3884: x_complete_rec.attribute5 := l_deliv_rec.attribute5;
3885: END IF;
3886:
3887: IF p_deliv_rec.attribute6 = FND_API.g_miss_char THEN
3888: x_complete_rec.attribute6 := l_deliv_rec.attribute6;
3889: END IF;
3890:
3891: IF p_deliv_rec.attribute7 = FND_API.g_miss_char THEN
3887: IF p_deliv_rec.attribute6 = FND_API.g_miss_char THEN
3888: x_complete_rec.attribute6 := l_deliv_rec.attribute6;
3889: END IF;
3890:
3891: IF p_deliv_rec.attribute7 = FND_API.g_miss_char THEN
3892: x_complete_rec.attribute7 := l_deliv_rec.attribute7;
3893: END IF;
3894:
3895: IF p_deliv_rec.attribute8 = FND_API.g_miss_char THEN
3891: IF p_deliv_rec.attribute7 = FND_API.g_miss_char THEN
3892: x_complete_rec.attribute7 := l_deliv_rec.attribute7;
3893: END IF;
3894:
3895: IF p_deliv_rec.attribute8 = FND_API.g_miss_char THEN
3896: x_complete_rec.attribute8 := l_deliv_rec.attribute8;
3897: END IF;
3898:
3899: IF p_deliv_rec.attribute9 = FND_API.g_miss_char THEN
3895: IF p_deliv_rec.attribute8 = FND_API.g_miss_char THEN
3896: x_complete_rec.attribute8 := l_deliv_rec.attribute8;
3897: END IF;
3898:
3899: IF p_deliv_rec.attribute9 = FND_API.g_miss_char THEN
3900: x_complete_rec.attribute9 := l_deliv_rec.attribute9;
3901: END IF;
3902:
3903: IF p_deliv_rec.attribute10 = FND_API.g_miss_char THEN
3899: IF p_deliv_rec.attribute9 = FND_API.g_miss_char THEN
3900: x_complete_rec.attribute9 := l_deliv_rec.attribute9;
3901: END IF;
3902:
3903: IF p_deliv_rec.attribute10 = FND_API.g_miss_char THEN
3904: x_complete_rec.attribute10 := l_deliv_rec.attribute10;
3905: END IF;
3906:
3907: IF p_deliv_rec.attribute11 = FND_API.g_miss_char THEN
3903: IF p_deliv_rec.attribute10 = FND_API.g_miss_char THEN
3904: x_complete_rec.attribute10 := l_deliv_rec.attribute10;
3905: END IF;
3906:
3907: IF p_deliv_rec.attribute11 = FND_API.g_miss_char THEN
3908: x_complete_rec.attribute11 := l_deliv_rec.attribute11;
3909: END IF;
3910:
3911: IF p_deliv_rec.attribute12 = FND_API.g_miss_char THEN
3907: IF p_deliv_rec.attribute11 = FND_API.g_miss_char THEN
3908: x_complete_rec.attribute11 := l_deliv_rec.attribute11;
3909: END IF;
3910:
3911: IF p_deliv_rec.attribute12 = FND_API.g_miss_char THEN
3912: x_complete_rec.attribute12 := l_deliv_rec.attribute12;
3913: END IF;
3914:
3915: IF p_deliv_rec.attribute13 = FND_API.g_miss_char THEN
3911: IF p_deliv_rec.attribute12 = FND_API.g_miss_char THEN
3912: x_complete_rec.attribute12 := l_deliv_rec.attribute12;
3913: END IF;
3914:
3915: IF p_deliv_rec.attribute13 = FND_API.g_miss_char THEN
3916: x_complete_rec.attribute13 := l_deliv_rec.attribute13;
3917: END IF;
3918:
3919: IF p_deliv_rec.attribute14 = FND_API.g_miss_char THEN
3915: IF p_deliv_rec.attribute13 = FND_API.g_miss_char THEN
3916: x_complete_rec.attribute13 := l_deliv_rec.attribute13;
3917: END IF;
3918:
3919: IF p_deliv_rec.attribute14 = FND_API.g_miss_char THEN
3920: x_complete_rec.attribute14 := l_deliv_rec.attribute14;
3921: END IF;
3922:
3923: IF p_deliv_rec.attribute15 = FND_API.g_miss_char THEN
3919: IF p_deliv_rec.attribute14 = FND_API.g_miss_char THEN
3920: x_complete_rec.attribute14 := l_deliv_rec.attribute14;
3921: END IF;
3922:
3923: IF p_deliv_rec.attribute15 = FND_API.g_miss_char THEN
3924: x_complete_rec.attribute15 := l_deliv_rec.attribute15;
3925: END IF;
3926:
3927: IF p_deliv_rec.chargeback_uom = FND_API.g_miss_char THEN
3923: IF p_deliv_rec.attribute15 = FND_API.g_miss_char THEN
3924: x_complete_rec.attribute15 := l_deliv_rec.attribute15;
3925: END IF;
3926:
3927: IF p_deliv_rec.chargeback_uom = FND_API.g_miss_char THEN
3928: x_complete_rec.chargeback_uom := l_deliv_rec.chargeback_uom;
3929: END IF;
3930:
3931: IF p_deliv_rec.deliverable_name = FND_API.g_miss_char THEN
3927: IF p_deliv_rec.chargeback_uom = FND_API.g_miss_char THEN
3928: x_complete_rec.chargeback_uom := l_deliv_rec.chargeback_uom;
3929: END IF;
3930:
3931: IF p_deliv_rec.deliverable_name = FND_API.g_miss_char THEN
3932: x_complete_rec.deliverable_name := l_deliv_rec.deliverable_name;
3933: END IF;
3934:
3935: IF p_deliv_rec.description = FND_API.g_miss_char THEN
3931: IF p_deliv_rec.deliverable_name = FND_API.g_miss_char THEN
3932: x_complete_rec.deliverable_name := l_deliv_rec.deliverable_name;
3933: END IF;
3934:
3935: IF p_deliv_rec.description = FND_API.g_miss_char THEN
3936: x_complete_rec.description := l_deliv_rec.description;
3937: END IF;
3938:
3939: IF p_deliv_rec.deliverable_calendar = FND_API.g_miss_char THEN
3935: IF p_deliv_rec.description = FND_API.g_miss_char THEN
3936: x_complete_rec.description := l_deliv_rec.description;
3937: END IF;
3938:
3939: IF p_deliv_rec.deliverable_calendar = FND_API.g_miss_char THEN
3940: x_complete_rec.deliverable_calendar := l_deliv_rec.deliverable_calendar;
3941: END IF;
3942:
3943: IF p_deliv_rec.start_period_name = FND_API.g_miss_char THEN
3939: IF p_deliv_rec.deliverable_calendar = FND_API.g_miss_char THEN
3940: x_complete_rec.deliverable_calendar := l_deliv_rec.deliverable_calendar;
3941: END IF;
3942:
3943: IF p_deliv_rec.start_period_name = FND_API.g_miss_char THEN
3944: x_complete_rec.start_period_name := l_deliv_rec.start_period_name;
3945: END IF;
3946:
3947: IF p_deliv_rec.end_period_name = FND_API.g_miss_char THEN
3943: IF p_deliv_rec.start_period_name = FND_API.g_miss_char THEN
3944: x_complete_rec.start_period_name := l_deliv_rec.start_period_name;
3945: END IF;
3946:
3947: IF p_deliv_rec.end_period_name = FND_API.g_miss_char THEN
3948: x_complete_rec.end_period_name := l_deliv_rec.end_period_name;
3949: END IF;
3950:
3951: IF p_deliv_rec.country_id = FND_API.g_miss_num THEN
3947: IF p_deliv_rec.end_period_name = FND_API.g_miss_char THEN
3948: x_complete_rec.end_period_name := l_deliv_rec.end_period_name;
3949: END IF;
3950:
3951: IF p_deliv_rec.country_id = FND_API.g_miss_num THEN
3952: x_complete_rec.country_id := l_deliv_rec.country_id;
3953: END IF;
3954:
3955: IF p_deliv_rec.Setup_id = FND_API.g_miss_num THEN
3951: IF p_deliv_rec.country_id = FND_API.g_miss_num THEN
3952: x_complete_rec.country_id := l_deliv_rec.country_id;
3953: END IF;
3954:
3955: IF p_deliv_rec.Setup_id = FND_API.g_miss_num THEN
3956: x_complete_rec.Setup_id := l_deliv_rec.custom_setup_id;
3957: END IF;
3958:
3959: END complete_deliv_rec;
3969:
3970: PROCEDURE create_pricelist_header
3971: (
3972: p_api_version IN NUMBER,
3973: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3974: p_return_values IN VARCHAR2 := FND_API.g_false,
3975: p_commit IN VARCHAR2 := FND_API.g_false,
3976: p_deliv_rec IN deliv_rec_type,
3977: x_return_status OUT NOCOPY VARCHAR2,
3970: PROCEDURE create_pricelist_header
3971: (
3972: p_api_version IN NUMBER,
3973: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3974: p_return_values IN VARCHAR2 := FND_API.g_false,
3975: p_commit IN VARCHAR2 := FND_API.g_false,
3976: p_deliv_rec IN deliv_rec_type,
3977: x_return_status OUT NOCOPY VARCHAR2,
3978: x_msg_count OUT NOCOPY NUMBER,
3971: (
3972: p_api_version IN NUMBER,
3973: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
3974: p_return_values IN VARCHAR2 := FND_API.g_false,
3975: p_commit IN VARCHAR2 := FND_API.g_false,
3976: p_deliv_rec IN deliv_rec_type,
3977: x_return_status OUT NOCOPY VARCHAR2,
3978: x_msg_count OUT NOCOPY NUMBER,
3979: x_msg_data OUT NOCOPY VARCHAR2,
4009:
4010: BEGIN
4011:
4012: --dbms_output.put_line('create List header called');
4013: x_return_status := FND_API.g_ret_sts_success;
4014:
4015: p_price_list_rec.name := 'Deliverable Inventory HDR';
4016: p_price_list_rec.created_by := p_deliv_rec.owner_user_id;
4017: p_price_list_rec.creation_date := sysdate;
4027: END IF;
4028:
4029: QP_PRICE_LIST_PUB.Process_Price_List(
4030: p_api_version_number => 1.0,
4031: p_init_msg_list => FND_API.g_false,
4032: p_return_values => FND_API.G_TRUE,
4033: p_commit => FND_API.g_false,
4034: x_return_status => l_return_status,
4035: x_msg_count => l_msg_count,
4028:
4029: QP_PRICE_LIST_PUB.Process_Price_List(
4030: p_api_version_number => 1.0,
4031: p_init_msg_list => FND_API.g_false,
4032: p_return_values => FND_API.G_TRUE,
4033: p_commit => FND_API.g_false,
4034: x_return_status => l_return_status,
4035: x_msg_count => l_msg_count,
4036: x_msg_data => l_msg_data,
4029: QP_PRICE_LIST_PUB.Process_Price_List(
4030: p_api_version_number => 1.0,
4031: p_init_msg_list => FND_API.g_false,
4032: p_return_values => FND_API.G_TRUE,
4033: p_commit => FND_API.g_false,
4034: x_return_status => l_return_status,
4035: x_msg_count => l_msg_count,
4036: x_msg_data => l_msg_data,
4037: p_price_list_rec => p_price_list_rec,
4054:
4055: x_pricelist_header_id := l_price_list_rec.list_header_id;
4056: x_return_status := l_return_status;
4057:
4058: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4059: RAISE FND_API.g_exc_unexpected_error;
4060: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4061: RAISE FND_API.g_exc_error;
4062: END IF;
4055: x_pricelist_header_id := l_price_list_rec.list_header_id;
4056: x_return_status := l_return_status;
4057:
4058: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4059: RAISE FND_API.g_exc_unexpected_error;
4060: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4061: RAISE FND_API.g_exc_error;
4062: END IF;
4063:
4056: x_return_status := l_return_status;
4057:
4058: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4059: RAISE FND_API.g_exc_unexpected_error;
4060: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4061: RAISE FND_API.g_exc_error;
4062: END IF;
4063:
4064: IF p_commit = FND_API.g_true THEN
4057:
4058: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4059: RAISE FND_API.g_exc_unexpected_error;
4060: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4061: RAISE FND_API.g_exc_error;
4062: END IF;
4063:
4064: IF p_commit = FND_API.g_true THEN
4065: COMMIT WORK;
4060: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4061: RAISE FND_API.g_exc_error;
4062: END IF;
4063:
4064: IF p_commit = FND_API.g_true THEN
4065: COMMIT WORK;
4066: END IF;
4067: END create_pricelist_header;
4068:
4076:
4077: PROCEDURE create_pricelist_line
4078: (
4079: p_api_version IN NUMBER,
4080: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4081: p_return_values IN VARCHAR2 := FND_API.g_false,
4082: p_commit IN VARCHAR2 := FND_API.g_false,
4083: p_price_hdr_id IN NUMBER,
4084: p_deliv_rec IN deliv_rec_type,
4077: PROCEDURE create_pricelist_line
4078: (
4079: p_api_version IN NUMBER,
4080: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4081: p_return_values IN VARCHAR2 := FND_API.g_false,
4082: p_commit IN VARCHAR2 := FND_API.g_false,
4083: p_price_hdr_id IN NUMBER,
4084: p_deliv_rec IN deliv_rec_type,
4085: x_return_status OUT NOCOPY VARCHAR2,
4078: (
4079: p_api_version IN NUMBER,
4080: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
4081: p_return_values IN VARCHAR2 := FND_API.g_false,
4082: p_commit IN VARCHAR2 := FND_API.g_false,
4083: p_price_hdr_id IN NUMBER,
4084: p_deliv_rec IN deliv_rec_type,
4085: x_return_status OUT NOCOPY VARCHAR2,
4086: x_msg_count OUT NOCOPY NUMBER,
4116:
4117: BEGIN
4118:
4119: --dbms_output.put_line('create List line called');
4120: x_return_status := FND_API.g_ret_sts_success;
4121:
4122: p_price_list_line_tbl(1).list_header_id := p_price_hdr_id;
4123: --dbms_output.put_line('p_price_hdr_id: '||p_price_hdr_id);
4124: p_price_list_line_tbl(1).list_line_type_code := 'PLL';
4129: p_price_list_line_tbl(1).end_date_active := p_deliv_rec.actual_avail_to_date;
4130: p_price_list_line_tbl(1).organization_id := p_deliv_rec.inventory_item_org_id;
4131: p_price_list_line_tbl(1).operation :=QP_GLOBALS.G_OPR_CREATE;
4132: p_price_list_line_tbl(1).automatic_flag := 'Y';
4133: -- if p_deliv_rec.PRICELIST_LIST_PRICE is NULL or p_deliv_rec.PRICELIST_LIST_PRICE = FND_API.g_miss_num then
4134: p_price_list_line_tbl(1).list_price := 0;
4135: --else
4136: --p_price_list_line_tbl(1).list_price := p_deliv_rec.PRICELIST_LIST_PRICE;
4137: --end if;
4141: END IF;
4142:
4143: QP_PRICE_LIST_PUB.Process_Price_List(
4144: p_api_version_number => 1.0,
4145: p_init_msg_list => FND_API.g_false,
4146: p_return_values => FND_API.G_TRUE,
4147: p_commit => FND_API.g_false,
4148: x_return_status => l_return_status,
4149: x_msg_count => l_msg_count,
4142:
4143: QP_PRICE_LIST_PUB.Process_Price_List(
4144: p_api_version_number => 1.0,
4145: p_init_msg_list => FND_API.g_false,
4146: p_return_values => FND_API.G_TRUE,
4147: p_commit => FND_API.g_false,
4148: x_return_status => l_return_status,
4149: x_msg_count => l_msg_count,
4150: x_msg_data => l_msg_data,
4143: QP_PRICE_LIST_PUB.Process_Price_List(
4144: p_api_version_number => 1.0,
4145: p_init_msg_list => FND_API.g_false,
4146: p_return_values => FND_API.G_TRUE,
4147: p_commit => FND_API.g_false,
4148: x_return_status => l_return_status,
4149: x_msg_count => l_msg_count,
4150: x_msg_data => l_msg_data,
4151: p_price_list_rec => p_price_list_rec,
4168:
4169: x_pricelist_line_id := l_PRICE_LIST_LINE_tbl(1).list_line_id;
4170: x_return_status := l_return_status;
4171:
4172: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4173: RAISE FND_API.g_exc_unexpected_error;
4174: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4175: RAISE FND_API.g_exc_error;
4176: END IF;
4169: x_pricelist_line_id := l_PRICE_LIST_LINE_tbl(1).list_line_id;
4170: x_return_status := l_return_status;
4171:
4172: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4173: RAISE FND_API.g_exc_unexpected_error;
4174: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4175: RAISE FND_API.g_exc_error;
4176: END IF;
4177:
4170: x_return_status := l_return_status;
4171:
4172: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4173: RAISE FND_API.g_exc_unexpected_error;
4174: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4175: RAISE FND_API.g_exc_error;
4176: END IF;
4177:
4178: IF p_commit = FND_API.g_true THEN
4171:
4172: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
4173: RAISE FND_API.g_exc_unexpected_error;
4174: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4175: RAISE FND_API.g_exc_error;
4176: END IF;
4177:
4178: IF p_commit = FND_API.g_true THEN
4179: COMMIT WORK;
4174: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
4175: RAISE FND_API.g_exc_error;
4176: END IF;
4177:
4178: IF p_commit = FND_API.g_true THEN
4179: COMMIT WORK;
4180: END IF;
4181: END create_pricelist_line;
4182:
4196:
4197: l_api_name CONSTANT VARCHAR2(30) := 'create_jtf_attachment';
4198:
4199: l_api_version NUMBER := 1.0;
4200: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
4201: l_commit VARCHAR2(1) := FND_API.g_false;
4202: l_validation_level NUMBER := FND_API.g_valid_level_full;
4203: l_return_status VARCHAR2(1);
4204: l_msg_count NUMBER;
4197: l_api_name CONSTANT VARCHAR2(30) := 'create_jtf_attachment';
4198:
4199: l_api_version NUMBER := 1.0;
4200: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
4201: l_commit VARCHAR2(1) := FND_API.g_false;
4202: l_validation_level NUMBER := FND_API.g_valid_level_full;
4203: l_return_status VARCHAR2(1);
4204: l_msg_count NUMBER;
4205: l_msg_data VARCHAR2(2000);
4198:
4199: l_api_version NUMBER := 1.0;
4200: l_init_msg_list VARCHAR2(1) := FND_API.g_false;
4201: l_commit VARCHAR2(1) := FND_API.g_false;
4202: l_validation_level NUMBER := FND_API.g_valid_level_full;
4203: l_return_status VARCHAR2(1);
4204: l_msg_count NUMBER;
4205: l_msg_data VARCHAR2(2000);
4206:
4208: l_att_id NUMBER;
4209:
4210: BEGIN
4211:
4212: x_return_status := FND_API.g_ret_sts_success;
4213:
4214: l_att_rec.attachment_used_by := p_used_by;
4215: l_att_rec.attachment_used_by_id := p_used_by_id;
4216: l_att_rec.file_id := p_file_id;
4289: FROM ams_event_offers_vl
4290: WHERE event_offer_id = l_master_object_id;
4291:
4292: BEGIN
4293: x_return_status := FND_API.g_ret_sts_success;
4294: OPEN c_parent_deliv(p_deliverable_rec.deliverable_id);
4295: LOOP
4296: FETCH c_parent_deliv INTO l_parent_deliv_rec;
4297: EXIT WHEN c_parent_deliv%NOTFOUND;
4360: WHEN others THEN
4361: IF c_parent_deliv%ISOPEN THEN
4362: CLOSE c_parent_deliv;
4363: END IF;
4364: x_return_status := FND_API.g_ret_sts_unexp_error ;
4365: IF (AMS_DEBUG_HIGH_ON) THEN
4366:
4367: AMS_UTILITY_PVT.debug_message(l_full_name||' Unhandled Error');
4368: END IF;
4392:
4393:
4394: BEGIN
4395:
4396: x_return_status := FND_API.g_ret_sts_success;
4397:
4398: OPEN c_get_period_dets(p_deliv_rec.deliverable_id);
4399: FETCH c_get_period_dets INTO l_get_period_cur;
4400: CLOSE c_get_period_dets;
4414:
4415:
4416: EXCEPTION
4417: WHEN OTHERS THEN
4418: x_return_status := FND_API.g_ret_sts_unexp_error ;
4419: END check_periods;
4420:
4421: -------------------------------------------------------------------
4422: -- PROCEDURE
4441: l_resource_id NUMBER := AMS_UTILITY_PVT.get_resource_id(FND_GLOBAL.User_id);
4442:
4443: BEGIN
4444:
4445: x_return_status := FND_API.g_ret_sts_success;
4446:
4447:
4448: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num THEN
4449:
4444:
4445: x_return_status := FND_API.g_ret_sts_success;
4446:
4447:
4448: IF p_deliv_rec.owner_user_id <> FND_API.g_miss_num THEN
4449:
4450: OPEN c_owner_id(p_deliv_rec.deliverable_id);
4451: FETCH c_owner_id INTO l_owner_user_id;
4452: CLOSE c_owner_id;
4461: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_OWNER');
4462: FND_MSG_PUB.add;
4463: END IF;
4464:
4465: x_return_status := FND_API.g_ret_sts_error;
4466: RETURN;
4467:
4468: END IF;
4469: END IF;
4504: l_budget_lines VARCHAR2(1) := 'N';
4505:
4506: BEGIN
4507:
4508: x_return_status := FND_API.g_ret_sts_success;
4509:
4510: IF p_deliv_rec.currency_code <> FND_API.g_miss_char THEN
4511:
4512: OPEN get_currency_code(p_deliv_rec.deliverable_id);
4506: BEGIN
4507:
4508: x_return_status := FND_API.g_ret_sts_success;
4509:
4510: IF p_deliv_rec.currency_code <> FND_API.g_miss_char THEN
4511:
4512: OPEN get_currency_code(p_deliv_rec.deliverable_id);
4513: FETCH get_currency_code INTO l_currency_code;
4514: CLOSE get_currency_code;
4523: THEN
4524: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_CURRENCY');
4525: FND_MSG_PUB.add;
4526: END IF;
4527: x_return_status := FND_API.g_ret_sts_error;
4528: RETURN;
4529: END IF;
4530: END IF;
4531: END IF;
4558: FETCH c_custom_attr INTO l_flag ;
4559: CLOSE c_custom_attr ;
4560:
4561: IF l_flag = 'Y' THEN
4562: l_flag := FND_API.g_true;
4563: ELSIF l_flag = 'N' THEN
4564: l_flag := FND_API.g_false;
4565: END IF;
4566:
4560:
4561: IF l_flag = 'Y' THEN
4562: l_flag := FND_API.g_true;
4563: ELSIF l_flag = 'N' THEN
4564: l_flag := FND_API.g_false;
4565: END IF;
4566:
4567: RETURN l_flag ;
4568:
4605: x_item_owner_id NUMBER;
4606:
4607: BEGIN
4608:
4609: x_return_status := FND_API.g_ret_sts_success;
4610: -- Begin Inventory creation
4611:
4612: IF l_qp_profile IS NULL THEN
4613: l_qp_profile := 'N';
4621: AMS_Utility_PVT.debug_message(l_full_name ||' Price Profile :'||l_qp_profile);
4622: END IF;
4623:
4624: IF (p_deliv_rec.item_number IS NULL
4625: OR p_deliv_rec.item_number = FND_API.g_miss_char)
4626: THEN
4627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4628: THEN
4629: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4628: THEN
4629: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4630: FND_MSG_PUB.add;
4631: END IF;
4632: x_return_status := FND_API.g_ret_sts_error;
4633: RETURN;
4634: END IF;
4635:
4636: IF (l_org_Id IS NULL)
4639: THEN
4640: FND_MESSAGE.set_name('AMS', 'AMS_PROD_PROFILE_TIP');
4641: FND_MSG_PUB.add;
4642: END IF;
4643: x_return_status := FND_API.g_ret_sts_error;
4644: RETURN;
4645: END IF;
4646:
4647:
4681: x_Error_tbl => x_error_tbl );
4682:
4683: /*
4684: INV_Item_GRP.Create_Item
4685: ( p_commit => FND_API.g_false
4686: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4687: , p_Item_rec => l_item_rec
4688: , x_Item_rec => x_item_rec
4689: , x_return_status => x_return_status
4682:
4683: /*
4684: INV_Item_GRP.Create_Item
4685: ( p_commit => FND_API.g_false
4686: , p_validation_level => fnd_api.g_VALID_LEVEL_FULL
4687: , p_Item_rec => l_item_rec
4688: , x_Item_rec => x_item_rec
4689: , x_return_status => x_return_status
4690: , x_Error_tbl => x_error_tbl
4695: IF (AMS_DEBUG_HIGH_ON) THEN
4696: AMS_Utility_PVT.debug_message(l_full_name ||' Status of Inv API '||x_return_status);
4697: END IF;
4698:
4699: IF ( x_return_status <> FND_API.g_ret_sts_success
4700: OR x_item_return_status <> FND_API.g_ret_sts_success )
4701: THEN
4702: RAISE inv_creation_error;
4703: ELSE
4696: AMS_Utility_PVT.debug_message(l_full_name ||' Status of Inv API '||x_return_status);
4697: END IF;
4698:
4699: IF ( x_return_status <> FND_API.g_ret_sts_success
4700: OR x_item_return_status <> FND_API.g_ret_sts_success )
4701: THEN
4702: RAISE inv_creation_error;
4703: ELSE
4704: x_inv_id := x_item_rec.inventory_item_id;
4706: END IF;
4707:
4708: EXCEPTION
4709: WHEN inv_creation_error THEN
4710: IF x_item_return_status <> FND_API.g_ret_sts_success
4711: THEN
4712: x_msg_count := x_error_tbl.count;
4713: FOR i IN 1 .. x_error_tbl.count LOOP
4714: /*
4712: x_msg_count := x_error_tbl.count;
4713: FOR i IN 1 .. x_error_tbl.count LOOP
4714: /*
4715: FND_MSG_PUB.count_and_get(
4716: p_encoded => FND_API.g_false,
4717: p_count => x_msg_count,
4718: p_data => x_error_tbl(i).message_text
4719: ); */
4720: IF x_error_tbl(i).message_name IS NOT NULL
4730: AMS_Utility_PVT.debug_message(l_full_name ||'the error text is '||x_error_tbl(i).message_text);
4731: END IF;
4732: END LOOP;
4733: END IF;
4734: x_return_status := FND_API.g_ret_sts_error;
4735: RETURN;
4736: END creat_inv_item;
4737:
4738: -------------------------------------------------------------------
4760: l_active_flag VARCHAR2(1) := 'Y';
4761:
4762: BEGIN
4763:
4764: x_return_status := FND_API.g_ret_sts_success;
4765:
4766: OPEN get_active_flag(p_deliv_rec.deliverable_id);
4767: FETCH get_active_flag INTO l_active_flag;
4768: CLOSE get_active_flag;
4773: THEN
4774: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_INACTIVE');
4775: FND_MSG_PUB.add;
4776: END IF;
4777: x_return_status := FND_API.g_ret_sts_error;
4778: RETURN;
4779: END IF;
4780:
4781: IF (AMS_DEBUG_HIGH_ON) THEN
4819: l_active_flag VARCHAR2(1) := 'Y';
4820:
4821: BEGIN
4822:
4823: x_return_status := FND_API.g_ret_sts_success;
4824:
4825: OPEN get_flag(p_deliv_rec.inventory_item_id,p_deliv_rec.inventory_item_org_id);
4826: FETCH get_flag INTO l_flag_rec;
4827: CLOSE get_flag;
4837: THEN
4838: AMS_UTILITY_PVT.error_message('AMS_DELV_API_BAD_INV');
4839: --Program Error: Inventory item passed to the API ,should hava the value set to "Y" for the following flags collateral_flag
4840: --,costing_enabled_flag,customer_order_flag,customer_order_enabled_flag,shippable_item_flag.
4841: x_return_status := FND_API.g_ret_sts_error;
4842: RETURN;
4843: END IF;
4844: ELSE
4845: IF l_flag_rec.collateral_flag = 'N'
4845: IF l_flag_rec.collateral_flag = 'N'
4846: THEN
4847: AMS_UTILITY_PVT.error_message('AMS_DELV_API_BAD_INV_COLL');
4848: --Program Error: Inventory item passed to the API ,should have the value set to "Y" for collateral_flag
4849: x_return_status := FND_API.g_ret_sts_error;
4850: RETURN;
4851: END IF;
4852: END IF;
4853: