eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_DELIVERABLE_GRP dependencies on FND_API

Line 38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

34: TYPE DlvCurTyp IS REF CURSOR;
35:
36: PROCEDURE list_deliverable (
37: p_api_version IN NUMBER,
38: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
39: x_return_status OUT NOCOPY VARCHAR2,
40: x_msg_count OUT NOCOPY NUMBER,
41: x_msg_data OUT NOCOPY VARCHAR2,
42: p_item_type IN VARCHAR2,

Line 97: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

93:
94:
95: PROCEDURE list_deliverable (
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_category_id IN NUMBER,

Line 158: IF NOT FND_API.compatible_api_call(

154: l_item_applicable_to VARCHAR2(30) := p_item_applicable_to;
155: BEGIN
156:
157: -- Standard call to check for call compatibility
158: IF NOT FND_API.compatible_api_call(
159: g_api_version,
160: p_api_version,
161: l_api_name,
162: g_pkg_name

Line 164: RAISE FND_API.g_exc_unexpected_error;

160: p_api_version,
161: l_api_name,
162: g_pkg_name
163: ) THEN
164: RAISE FND_API.g_exc_unexpected_error;
165: END IF;
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE
168: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 168: IF FND_API.to_boolean(p_init_msg_list) THEN

164: RAISE FND_API.g_exc_unexpected_error;
165: END IF;
166:
167: -- Initialize message list if p_init_msg_list is set to TRUE
168: IF FND_API.to_boolean(p_init_msg_list) THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171:
172: -- Initialize API rturn status to success

Line 173: x_return_status := FND_API.g_ret_sts_success;

169: FND_MSG_PUB.initialize;
170: END IF;
171:
172: -- Initialize API rturn status to success
173: x_return_status := FND_API.g_ret_sts_success;
174:
175: -- API body
176:
177: IF p_start_id < -1 OR p_batch_size < 0

Line 183: RAISE FND_API.g_exc_unexpected_error;

179: FND_MESSAGE.set_name('IBE', 'IBE_DSP_QUERY_INVLD');
180: FND_MESSAGE.set_token('0', TO_CHAR(p_start_id));
181: FND_MESSAGE.set_token('1', TO_CHAR(p_batch_size));
182: FND_MSG_PUB.add;
183: RAISE FND_API.g_exc_unexpected_error;
184: END IF;
185:
186: IF p_category_id IS NOT NULL
187: AND TRIM(p_item_applicable_to) <> 'CATEGORY' THEN

Line 192: RAISE FND_API.g_exc_unexpected_error;

188: FND_MESSAGE.set_name('IBE', 'IBE_DSP_AVAIL_INVLD');
189: FND_MESSAGE.set_token('0', TO_CHAR(p_category_id));
190: FND_MESSAGE.set_token('1', p_item_applicable_to);
191: FND_MSG_PUB.add;
192: RAISE FND_API.g_exc_unexpected_error;
193: END IF;
194:
195: IF TRIM(p_item_type) IS NOT NULL THEN
196: l_flag := 1;

Line 281: p_encoded => FND_API.g_false,

277: CLOSE l_dlv_cv;
278:
279: IF x_row_count = 0 THEN
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );
285: RETURN;

Line 306: p_encoded => FND_API.g_false,

302: -- Get matched rows
303: IF p_start_id > -1 THEN
304: IF p_start_id >= x_row_count THEN
305: FND_MSG_PUB.count_and_get(
306: p_encoded => FND_API.g_false,
307: p_count => x_msg_count,
308: p_data => x_msg_data
309: );
310: RETURN;

Line 643: p_encoded => FND_API.g_false,

639: */
640:
641: -- Standard call to get message count and if count is 1, get message info
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:

Line 650: WHEN FND_API.g_exc_unexpected_error THEN

646: );
647:
648: EXCEPTION
649:
650: WHEN FND_API.g_exc_unexpected_error THEN
651: x_return_status := FND_API.g_ret_sts_unexp_error ;
652: FND_MSG_PUB.count_and_get(
653: p_encoded => FND_API.g_false,
654: p_count => x_msg_count,

Line 651: x_return_status := FND_API.g_ret_sts_unexp_error ;

647:
648: EXCEPTION
649:
650: WHEN FND_API.g_exc_unexpected_error THEN
651: x_return_status := FND_API.g_ret_sts_unexp_error ;
652: FND_MSG_PUB.count_and_get(
653: p_encoded => FND_API.g_false,
654: p_count => x_msg_count,
655: p_data => x_msg_data

Line 653: p_encoded => FND_API.g_false,

649:
650: WHEN FND_API.g_exc_unexpected_error THEN
651: x_return_status := FND_API.g_ret_sts_unexp_error ;
652: FND_MSG_PUB.count_and_get(
653: p_encoded => FND_API.g_false,
654: p_count => x_msg_count,
655: p_data => x_msg_data
656: );
657:

Line 659: x_return_status := FND_API.g_ret_sts_unexp_error ;

655: p_data => x_msg_data
656: );
657:
658: WHEN OTHERS THEN
659: x_return_status := FND_API.g_ret_sts_unexp_error ;
660:
661: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;

Line 666: p_encoded => FND_API.g_false,

662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
663: END IF;
664:
665: FND_MSG_PUB.count_and_get(
666: p_encoded => FND_API.g_false,
667: p_count => x_msg_count,
668: p_data => x_msg_data
669: );
670:

Line 697: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

693:
694: ---------------------------------------------------------------------
695: PROCEDURE save_deliverable (
696: p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
698: p_commit IN VARCHAR2 := FND_API.g_false,
699: x_return_status OUT NOCOPY VARCHAR2,
700: x_msg_count OUT NOCOPY NUMBER,
701: x_msg_data OUT NOCOPY VARCHAR2,

Line 698: p_commit IN VARCHAR2 := FND_API.g_false,

694: ---------------------------------------------------------------------
695: PROCEDURE save_deliverable (
696: p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
698: p_commit IN VARCHAR2 := FND_API.g_false,
699: x_return_status OUT NOCOPY VARCHAR2,
700: x_msg_count OUT NOCOPY NUMBER,
701: x_msg_data OUT NOCOPY VARCHAR2,
702: p_deliverable_rec IN OUT NOCOPY DELIVERABLE_REC_TYPE ) IS

Line 722: IF NOT FND_API.compatible_api_call(

718: -- Standard start of API savepoint
719: SAVEPOINT save_deliverable_grp;
720:
721: -- Standard call to check for call compatibility
722: IF NOT FND_API.compatible_api_call(
723: g_api_version,
724: p_api_version,
725: l_api_name,
726: g_pkg_name

Line 728: RAISE FND_API.g_exc_unexpected_error;

724: p_api_version,
725: l_api_name,
726: g_pkg_name
727: ) THEN
728: RAISE FND_API.g_exc_unexpected_error;
729: END IF;
730:
731: -- Initialize message list if p_init_msg_list is set to TRUE
732: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 732: IF FND_API.to_boolean(p_init_msg_list) THEN

728: RAISE FND_API.g_exc_unexpected_error;
729: END IF;
730:
731: -- Initialize message list if p_init_msg_list is set to TRUE
732: IF FND_API.to_boolean(p_init_msg_list) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: -- Initialize API rturn status to success

Line 737: x_return_status := FND_API.g_ret_sts_success;

733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: -- Initialize API rturn status to success
737: x_return_status := FND_API.g_ret_sts_success;
738:
739: -- API body
740:
741: l_item_rec.external_access_flag := NULL;

Line 770: := FND_API.g_ret_sts_error;

766: l_item_rec.application_id := l_appl_id;
767:
768: /*
769: p_deliverable_rec.x_action_status
770: := FND_API.g_ret_sts_error;
771: */
772:
773: l_item_rec.item_id
774: := p_deliverable_rec.deliverable_id;

Line 785: RAISE FND_API.g_exc_error;

781: := p_deliverable_rec.object_version_number;
782:
783: IF NOT IBE_DSPMGRVALIDATION_GRP.check_deliverable_accessname(
784: l_item_rec.item_id, l_item_rec.access_name) THEN
785: RAISE FND_API.g_exc_error;
786: END IF;
787:
788: IF l_item_rec.item_id IS NOT NULL THEN
789: -- Update an existing deliverable

Line 806: RAISE FND_API.g_exc_error;

802: p_access_name => l_item_rec.access_name,
803: p_deliverable_type_code => l_item_rec.deliverable_type_code,
804: p_applicable_to_code => l_item_rec.applicable_to_code);
805: IF l_temp < 0 THEN
806: RAISE FND_API.g_exc_error;
807: END IF;
808: -- end for enhancement 2317704
809: JTF_AMV_ITEM_PUB.create_item(
810: p_api_version => g_amv_api_version,

Line 818: IF l_return_status = FND_API.g_ret_sts_error THEN

814: p_item_rec => l_item_rec,
815: x_item_id => l_deliverable_id
816: );
817:
818: IF l_return_status = FND_API.g_ret_sts_error THEN
819: RAISE FND_API.g_exc_error;
820: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
821: RAISE FND_API.g_exc_unexpected_error;
822: END IF;

Line 819: RAISE FND_API.g_exc_error;

815: x_item_id => l_deliverable_id
816: );
817:
818: IF l_return_status = FND_API.g_ret_sts_error THEN
819: RAISE FND_API.g_exc_error;
820: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
821: RAISE FND_API.g_exc_unexpected_error;
822: END IF;
823:

Line 820: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

816: );
817:
818: IF l_return_status = FND_API.g_ret_sts_error THEN
819: RAISE FND_API.g_exc_error;
820: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
821: RAISE FND_API.g_exc_unexpected_error;
822: END IF;
823:
824: IF TRIM(p_deliverable_rec.keywords) IS NOT NULL THEN

Line 821: RAISE FND_API.g_exc_unexpected_error;

817:
818: IF l_return_status = FND_API.g_ret_sts_error THEN
819: RAISE FND_API.g_exc_error;
820: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
821: RAISE FND_API.g_exc_unexpected_error;
822: END IF;
823:
824: IF TRIM(p_deliverable_rec.keywords) IS NOT NULL THEN
825: JTF_AMV_ITEM_PUB.add_itemkeyword(

Line 834: IF l_return_status = FND_API.g_ret_sts_error THEN

830: p_item_id => l_deliverable_id,
831: p_keyword => p_deliverable_rec.keywords
832: );
833:
834: IF l_return_status = FND_API.g_ret_sts_error THEN
835: RAISE FND_API.g_exc_error;
836: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
837: RAISE FND_API.g_exc_unexpected_error;
838: END IF;

Line 835: RAISE FND_API.g_exc_error;

831: p_keyword => p_deliverable_rec.keywords
832: );
833:
834: IF l_return_status = FND_API.g_ret_sts_error THEN
835: RAISE FND_API.g_exc_error;
836: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
837: RAISE FND_API.g_exc_unexpected_error;
838: END IF;
839: END IF;

Line 836: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

832: );
833:
834: IF l_return_status = FND_API.g_ret_sts_error THEN
835: RAISE FND_API.g_exc_error;
836: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
837: RAISE FND_API.g_exc_unexpected_error;
838: END IF;
839: END IF;
840:

Line 837: RAISE FND_API.g_exc_unexpected_error;

833:
834: IF l_return_status = FND_API.g_ret_sts_error THEN
835: RAISE FND_API.g_exc_error;
836: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
837: RAISE FND_API.g_exc_unexpected_error;
838: END IF;
839: END IF;
840:
841: p_deliverable_rec.deliverable_id := l_deliverable_id;

Line 848: l_item_rec.deliverable_type_code := FND_API.g_miss_char;

844: ELSE
845: -- 05/13/02 YAXU modified to support updateing the item_type
846: l_item_rec.deliverable_type_code := TRIM(p_deliverable_rec.item_type);
847: IF l_item_rec.deliverable_type_code IS NULL THEN
848: l_item_rec.deliverable_type_code := FND_API.g_miss_char;
849: END IF;
850: -- modified by abhandar to update the 'applicable to' also
851: --l_item_rec.applicable_to_code := FND_API.g_miss_char;
852: l_item_rec.applicable_to_code := TRIM(p_deliverable_rec.item_applicable_to);

Line 851: --l_item_rec.applicable_to_code := FND_API.g_miss_char;

847: IF l_item_rec.deliverable_type_code IS NULL THEN
848: l_item_rec.deliverable_type_code := FND_API.g_miss_char;
849: END IF;
850: -- modified by abhandar to update the 'applicable to' also
851: --l_item_rec.applicable_to_code := FND_API.g_miss_char;
852: l_item_rec.applicable_to_code := TRIM(p_deliverable_rec.item_applicable_to);
853: IF l_item_rec.applicable_to_code IS NULL THEN
854: l_item_rec.applicable_to_code := FND_API.g_miss_char;
855: END IF;

Line 854: l_item_rec.applicable_to_code := FND_API.g_miss_char;

850: -- modified by abhandar to update the 'applicable to' also
851: --l_item_rec.applicable_to_code := FND_API.g_miss_char;
852: l_item_rec.applicable_to_code := TRIM(p_deliverable_rec.item_applicable_to);
853: IF l_item_rec.applicable_to_code IS NULL THEN
854: l_item_rec.applicable_to_code := FND_API.g_miss_char;
855: END IF;
856:
857: -- new validation code for enhancement 2317704
858: l_temp := IBE_DSPMGRVALIDATION_GRP.check_media_object(

Line 864: RAISE FND_API.g_exc_error;

860: p_access_name => l_item_rec.access_name,
861: p_deliverable_type_code => l_item_rec.deliverable_type_code,
862: p_applicable_to_code => l_item_rec.applicable_to_code);
863: IF l_temp < 0 THEN
864: RAISE FND_API.g_exc_error;
865: END IF;
866: -- end for enhancement 2317704
867: JTF_AMV_ITEM_PUB.update_item(
868: p_api_version => g_amv_api_version,

Line 875: IF l_return_status = FND_API.g_ret_sts_error THEN

871: x_msg_data => x_msg_data,
872: p_item_rec => l_item_rec
873: );
874:
875: IF l_return_status = FND_API.g_ret_sts_error THEN
876: RAISE FND_API.g_exc_error;
877: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: END IF;

Line 876: RAISE FND_API.g_exc_error;

872: p_item_rec => l_item_rec
873: );
874:
875: IF l_return_status = FND_API.g_ret_sts_error THEN
876: RAISE FND_API.g_exc_error;
877: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: END IF;
880:

Line 877: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

873: );
874:
875: IF l_return_status = FND_API.g_ret_sts_error THEN
876: RAISE FND_API.g_exc_error;
877: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: END IF;
880:
881: -- Delete existing keywords

Line 878: RAISE FND_API.g_exc_unexpected_error;

874:
875: IF l_return_status = FND_API.g_ret_sts_error THEN
876: RAISE FND_API.g_exc_error;
877: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
878: RAISE FND_API.g_exc_unexpected_error;
879: END IF;
880:
881: -- Delete existing keywords
882: JTF_AMV_ITEM_PUB.delete_itemkeyword(

Line 891: IF l_return_status = FND_API.g_ret_sts_error THEN

887: p_item_id => p_deliverable_rec.deliverable_id,
888: p_keyword_tab => NULL
889: );
890:
891: IF l_return_status = FND_API.g_ret_sts_error THEN
892: RAISE FND_API.g_exc_error;
893: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
894: RAISE FND_API.g_exc_unexpected_error;
895: END IF;

Line 892: RAISE FND_API.g_exc_error;

888: p_keyword_tab => NULL
889: );
890:
891: IF l_return_status = FND_API.g_ret_sts_error THEN
892: RAISE FND_API.g_exc_error;
893: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
894: RAISE FND_API.g_exc_unexpected_error;
895: END IF;
896:

Line 893: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

889: );
890:
891: IF l_return_status = FND_API.g_ret_sts_error THEN
892: RAISE FND_API.g_exc_error;
893: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
894: RAISE FND_API.g_exc_unexpected_error;
895: END IF;
896:
897: IF TRIM(p_deliverable_rec.keywords) IS NOT NULL THEN

Line 894: RAISE FND_API.g_exc_unexpected_error;

890:
891: IF l_return_status = FND_API.g_ret_sts_error THEN
892: RAISE FND_API.g_exc_error;
893: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
894: RAISE FND_API.g_exc_unexpected_error;
895: END IF;
896:
897: IF TRIM(p_deliverable_rec.keywords) IS NOT NULL THEN
898: JTF_AMV_ITEM_PUB.add_itemkeyword(

Line 907: IF l_return_status = FND_API.g_ret_sts_error THEN

903: p_item_id => p_deliverable_rec.deliverable_id,
904: p_keyword => p_deliverable_rec.keywords
905: );
906:
907: IF l_return_status = FND_API.g_ret_sts_error THEN
908: RAISE FND_API.g_exc_error;
909: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
910: RAISE FND_API.g_exc_unexpected_error;
911: END IF;

Line 908: RAISE FND_API.g_exc_error;

904: p_keyword => p_deliverable_rec.keywords
905: );
906:
907: IF l_return_status = FND_API.g_ret_sts_error THEN
908: RAISE FND_API.g_exc_error;
909: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
910: RAISE FND_API.g_exc_unexpected_error;
911: END IF;
912: END IF;

Line 909: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

905: );
906:
907: IF l_return_status = FND_API.g_ret_sts_error THEN
908: RAISE FND_API.g_exc_error;
909: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
910: RAISE FND_API.g_exc_unexpected_error;
911: END IF;
912: END IF;
913:

Line 910: RAISE FND_API.g_exc_unexpected_error;

906:
907: IF l_return_status = FND_API.g_ret_sts_error THEN
908: RAISE FND_API.g_exc_error;
909: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
910: RAISE FND_API.g_exc_unexpected_error;
911: END IF;
912: END IF;
913:
914: -- update the object_version_number

Line 921: := FND_API.g_ret_sts_success;

917:
918: END IF;
919:
920: p_deliverable_rec.x_action_status
921: := FND_API.g_ret_sts_success;
922:
923: -- Check if the caller requested to commit ,
924: -- If p_commit set to true, commit the transaction
925: IF FND_API.to_boolean(p_commit) THEN

Line 925: IF FND_API.to_boolean(p_commit) THEN

921: := FND_API.g_ret_sts_success;
922:
923: -- Check if the caller requested to commit ,
924: -- If p_commit set to true, commit the transaction
925: IF FND_API.to_boolean(p_commit) THEN
926: COMMIT;
927: END IF;
928:
929: -- Standard call to get message count and if count is 1, get message info

Line 931: p_encoded => FND_API.g_false,

927: END IF;
928:
929: -- Standard call to get message count and if count is 1, get message info
930: FND_MSG_PUB.count_and_get(
931: p_encoded => FND_API.g_false,
932: p_count => x_msg_count,
933: p_data => x_msg_data
934: );
935:

Line 938: WHEN FND_API.g_exc_error THEN

934: );
935:
936: EXCEPTION
937:
938: WHEN FND_API.g_exc_error THEN
939: ROLLBACK TO save_deliverable_grp;
940: x_return_status := FND_API.g_ret_sts_error;
941: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_error;
942: FND_MSG_PUB.count_and_get(

Line 940: x_return_status := FND_API.g_ret_sts_error;

936: EXCEPTION
937:
938: WHEN FND_API.g_exc_error THEN
939: ROLLBACK TO save_deliverable_grp;
940: x_return_status := FND_API.g_ret_sts_error;
941: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_error;
942: FND_MSG_PUB.count_and_get(
943: p_encoded => FND_API.g_false,
944: p_count => x_msg_count,

Line 941: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_error;

937:
938: WHEN FND_API.g_exc_error THEN
939: ROLLBACK TO save_deliverable_grp;
940: x_return_status := FND_API.g_ret_sts_error;
941: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_error;
942: FND_MSG_PUB.count_and_get(
943: p_encoded => FND_API.g_false,
944: p_count => x_msg_count,
945: p_data => x_msg_data

Line 943: p_encoded => FND_API.g_false,

939: ROLLBACK TO save_deliverable_grp;
940: x_return_status := FND_API.g_ret_sts_error;
941: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_error;
942: FND_MSG_PUB.count_and_get(
943: p_encoded => FND_API.g_false,
944: p_count => x_msg_count,
945: p_data => x_msg_data
946: );
947:

Line 948: WHEN FND_API.g_exc_unexpected_error THEN

944: p_count => x_msg_count,
945: p_data => x_msg_data
946: );
947:
948: WHEN FND_API.g_exc_unexpected_error THEN
949: ROLLBACK TO save_deliverable_grp;
950: x_return_status := FND_API.g_ret_sts_unexp_error;
951: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
952: FND_MSG_PUB.count_and_get(

Line 950: x_return_status := FND_API.g_ret_sts_unexp_error;

946: );
947:
948: WHEN FND_API.g_exc_unexpected_error THEN
949: ROLLBACK TO save_deliverable_grp;
950: x_return_status := FND_API.g_ret_sts_unexp_error;
951: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
952: FND_MSG_PUB.count_and_get(
953: p_encoded => FND_API.g_false,
954: p_count => x_msg_count,

Line 951: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;

947:
948: WHEN FND_API.g_exc_unexpected_error THEN
949: ROLLBACK TO save_deliverable_grp;
950: x_return_status := FND_API.g_ret_sts_unexp_error;
951: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
952: FND_MSG_PUB.count_and_get(
953: p_encoded => FND_API.g_false,
954: p_count => x_msg_count,
955: p_data => x_msg_data

Line 953: p_encoded => FND_API.g_false,

949: ROLLBACK TO save_deliverable_grp;
950: x_return_status := FND_API.g_ret_sts_unexp_error;
951: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
952: FND_MSG_PUB.count_and_get(
953: p_encoded => FND_API.g_false,
954: p_count => x_msg_count,
955: p_data => x_msg_data
956: );
957:

Line 960: x_return_status := FND_API.g_ret_sts_unexp_error;

956: );
957:
958: WHEN OTHERS THEN
959: ROLLBACK TO save_deliverable_grp;
960: x_return_status := FND_API.g_ret_sts_unexp_error;
961: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
962:
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
964: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 961: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;

957:
958: WHEN OTHERS THEN
959: ROLLBACK TO save_deliverable_grp;
960: x_return_status := FND_API.g_ret_sts_unexp_error;
961: p_deliverable_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
962:
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
964: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
965: END IF;

Line 968: p_encoded => FND_API.g_false,

964: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
965: END IF;
966:
967: FND_MSG_PUB.count_and_get(
968: p_encoded => FND_API.g_false,
969: p_count => x_msg_count,
970: p_data => x_msg_data
971: );
972:

Line 999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

995:
996: ---------------------------------------------------------------------
997: PROCEDURE save_deliverable (
998: p_api_version IN NUMBER,
999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1000: p_commit IN VARCHAR2 := FND_API.g_false,
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,

Line 1000: p_commit IN VARCHAR2 := FND_API.g_false,

996: ---------------------------------------------------------------------
997: PROCEDURE save_deliverable (
998: p_api_version IN NUMBER,
999: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1000: p_commit IN VARCHAR2 := FND_API.g_false,
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: p_deliverable_tbl IN OUT NOCOPY DELIVERABLE_TBL_TYPE ) IS

Line 1019: IF NOT FND_API.compatible_api_call(

1015: -- Standard start of API savepoint
1016: SAVEPOINT save_deliverable_grp;
1017:
1018: -- Standard call to check for call compatibility
1019: IF NOT FND_API.compatible_api_call(
1020: g_api_version,
1021: p_api_version,
1022: l_api_name,
1023: g_pkg_name

Line 1025: RAISE FND_API.g_exc_unexpected_error;

1021: p_api_version,
1022: l_api_name,
1023: g_pkg_name
1024: ) THEN
1025: RAISE FND_API.g_exc_unexpected_error;
1026: END IF;
1027:
1028: -- Initialize message list if p_init_msg_list is set to TRUE
1029: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1029: IF FND_API.to_boolean(p_init_msg_list) THEN

1025: RAISE FND_API.g_exc_unexpected_error;
1026: END IF;
1027:
1028: -- Initialize message list if p_init_msg_list is set to TRUE
1029: IF FND_API.to_boolean(p_init_msg_list) THEN
1030: FND_MSG_PUB.initialize;
1031: END IF;
1032:
1033: -- Initialize API rturn status to success

Line 1034: x_return_status := FND_API.g_ret_sts_success;

1030: FND_MSG_PUB.initialize;
1031: END IF;
1032:
1033: -- Initialize API rturn status to success
1034: x_return_status := FND_API.g_ret_sts_success;
1035:
1036: -- API body
1037:
1038: IF p_deliverable_tbl IS NOT NULL THEN

Line 1049: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1045: x_msg_data => x_msg_data,
1046: p_deliverable_rec => p_deliverable_tbl(l_index)
1047: );
1048:
1049: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1050: x_return_status := FND_API.g_ret_sts_unexp_error;
1051: ELSIF l_return_status = FND_API.g_ret_sts_error
1052: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1053: x_return_status := FND_API.g_ret_sts_error;

Line 1050: x_return_status := FND_API.g_ret_sts_unexp_error;

1046: p_deliverable_rec => p_deliverable_tbl(l_index)
1047: );
1048:
1049: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1050: x_return_status := FND_API.g_ret_sts_unexp_error;
1051: ELSIF l_return_status = FND_API.g_ret_sts_error
1052: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1053: x_return_status := FND_API.g_ret_sts_error;
1054: END IF;

Line 1051: ELSIF l_return_status = FND_API.g_ret_sts_error

1047: );
1048:
1049: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1050: x_return_status := FND_API.g_ret_sts_unexp_error;
1051: ELSIF l_return_status = FND_API.g_ret_sts_error
1052: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1053: x_return_status := FND_API.g_ret_sts_error;
1054: END IF;
1055:

Line 1052: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN

1048:
1049: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1050: x_return_status := FND_API.g_ret_sts_unexp_error;
1051: ELSIF l_return_status = FND_API.g_ret_sts_error
1052: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1053: x_return_status := FND_API.g_ret_sts_error;
1054: END IF;
1055:
1056: END LOOP;

Line 1053: x_return_status := FND_API.g_ret_sts_error;

1049: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1050: x_return_status := FND_API.g_ret_sts_unexp_error;
1051: ELSIF l_return_status = FND_API.g_ret_sts_error
1052: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1053: x_return_status := FND_API.g_ret_sts_error;
1054: END IF;
1055:
1056: END LOOP;
1057: END IF;

Line 1061: IF FND_API.to_boolean(p_commit) THEN

1057: END IF;
1058:
1059: -- Check if the caller requested to commit ,
1060: -- If p_commit set to true, commit the transaction
1061: IF FND_API.to_boolean(p_commit) THEN
1062: COMMIT;
1063: END IF;
1064:
1065: -- Standard call to get message count and if count is 1, get message info

Line 1067: p_encoded => FND_API.g_false,

1063: END IF;
1064:
1065: -- Standard call to get message count and if count is 1, get message info
1066: FND_MSG_PUB.count_and_get(
1067: p_encoded => FND_API.g_false,
1068: p_count => x_msg_count,
1069: p_data => x_msg_data
1070: );
1071:

Line 1075: WHEN FND_API.g_exc_error THEN

1071:
1072:
1073: EXCEPTION
1074:
1075: WHEN FND_API.g_exc_error THEN
1076: ROLLBACK TO save_deliverable_grp;
1077: x_return_status := FND_API.g_ret_sts_error;
1078: FND_MSG_PUB.count_and_get(
1079: p_encoded => FND_API.g_false,

Line 1077: x_return_status := FND_API.g_ret_sts_error;

1073: EXCEPTION
1074:
1075: WHEN FND_API.g_exc_error THEN
1076: ROLLBACK TO save_deliverable_grp;
1077: x_return_status := FND_API.g_ret_sts_error;
1078: FND_MSG_PUB.count_and_get(
1079: p_encoded => FND_API.g_false,
1080: p_count => x_msg_count,
1081: p_data => x_msg_data

Line 1079: p_encoded => FND_API.g_false,

1075: WHEN FND_API.g_exc_error THEN
1076: ROLLBACK TO save_deliverable_grp;
1077: x_return_status := FND_API.g_ret_sts_error;
1078: FND_MSG_PUB.count_and_get(
1079: p_encoded => FND_API.g_false,
1080: p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083:

Line 1084: WHEN FND_API.g_exc_unexpected_error THEN

1080: p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083:
1084: WHEN FND_API.g_exc_unexpected_error THEN
1085: ROLLBACK TO save_deliverable_grp;
1086: x_return_status := FND_API.g_ret_sts_unexp_error ;
1087: FND_MSG_PUB.count_and_get(
1088: p_encoded => FND_API.g_false,

Line 1086: x_return_status := FND_API.g_ret_sts_unexp_error ;

1082: );
1083:
1084: WHEN FND_API.g_exc_unexpected_error THEN
1085: ROLLBACK TO save_deliverable_grp;
1086: x_return_status := FND_API.g_ret_sts_unexp_error ;
1087: FND_MSG_PUB.count_and_get(
1088: p_encoded => FND_API.g_false,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data

Line 1088: p_encoded => FND_API.g_false,

1084: WHEN FND_API.g_exc_unexpected_error THEN
1085: ROLLBACK TO save_deliverable_grp;
1086: x_return_status := FND_API.g_ret_sts_unexp_error ;
1087: FND_MSG_PUB.count_and_get(
1088: p_encoded => FND_API.g_false,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data
1091: );
1092:

Line 1096: x_return_status := FND_API.g_ret_sts_unexp_error ;

1092:
1093:
1094: WHEN OTHERS THEN
1095: ROLLBACK TO save_deliverable_grp;
1096: x_return_status := FND_API.g_ret_sts_unexp_error ;
1097:
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1099: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1100: END IF;

Line 1103: p_encoded => FND_API.g_false,

1099: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1100: END IF;
1101:
1102: FND_MSG_PUB.count_and_get(
1103: p_encoded => FND_API.g_false,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data
1106: );
1107:

Line 1143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1139:
1140: ---------------------------------------------------------------------
1141: PROCEDURE save_deliverable (
1142: p_api_version IN NUMBER,
1143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1144: p_commit IN VARCHAR2 := FND_API.g_false,
1145: x_return_status OUT NOCOPY VARCHAR2,
1146: x_msg_count OUT NOCOPY NUMBER,
1147: x_msg_data OUT NOCOPY VARCHAR2,

Line 1144: p_commit IN VARCHAR2 := FND_API.g_false,

1140: ---------------------------------------------------------------------
1141: PROCEDURE save_deliverable (
1142: p_api_version IN NUMBER,
1143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1144: p_commit IN VARCHAR2 := FND_API.g_false,
1145: x_return_status OUT NOCOPY VARCHAR2,
1146: x_msg_count OUT NOCOPY NUMBER,
1147: x_msg_data OUT NOCOPY VARCHAR2,
1148: p_dlv_ath_rec IN OUT NOCOPY DLV_ATH_REC_TYPE ) IS

Line 1154: l_create_attachment VARCHAR2(1) := FND_API.g_false;

1150: l_api_name CONSTANT VARCHAR2(30) := 'save_deliverable';
1151: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1152:
1153: l_operation_type VARCHAR2(10) := 'INSERT';
1154: l_create_attachment VARCHAR2(1) := FND_API.g_false;
1155: l_delete_mapping VARCHAR2(1) := FND_API.g_false;
1156: l_create_mapping VARCHAR2(1) := FND_API.g_false;
1157: l_attachment_id NUMBER;
1158:

Line 1155: l_delete_mapping VARCHAR2(1) := FND_API.g_false;

1151: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1152:
1153: l_operation_type VARCHAR2(10) := 'INSERT';
1154: l_create_attachment VARCHAR2(1) := FND_API.g_false;
1155: l_delete_mapping VARCHAR2(1) := FND_API.g_false;
1156: l_create_mapping VARCHAR2(1) := FND_API.g_false;
1157: l_attachment_id NUMBER;
1158:
1159: l_deliverable_rec DELIVERABLE_REC_TYPE;

Line 1156: l_create_mapping VARCHAR2(1) := FND_API.g_false;

1152:
1153: l_operation_type VARCHAR2(10) := 'INSERT';
1154: l_create_attachment VARCHAR2(1) := FND_API.g_false;
1155: l_delete_mapping VARCHAR2(1) := FND_API.g_false;
1156: l_create_mapping VARCHAR2(1) := FND_API.g_false;
1157: l_attachment_id NUMBER;
1158:
1159: l_deliverable_rec DELIVERABLE_REC_TYPE;
1160: l_attachment_rec IBE_Attachment_GRP.ATTACHMENT_REC_TYPE;

Line 1172: IF NOT FND_API.compatible_api_call(

1168: -- Standard start of API savepoint
1169: SAVEPOINT save_deliverable_grp;
1170:
1171: -- Standard call to check for call compatibility
1172: IF NOT FND_API.compatible_api_call(
1173: g_api_version,
1174: p_api_version,
1175: l_api_name,
1176: g_pkg_name

Line 1178: RAISE FND_API.g_exc_unexpected_error;

1174: p_api_version,
1175: l_api_name,
1176: g_pkg_name
1177: ) THEN
1178: RAISE FND_API.g_exc_unexpected_error;
1179: END IF;
1180:
1181: -- Initialize message list if p_init_msg_list is set to TRUE
1182: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1182: IF FND_API.to_boolean(p_init_msg_list) THEN

1178: RAISE FND_API.g_exc_unexpected_error;
1179: END IF;
1180:
1181: -- Initialize message list if p_init_msg_list is set to TRUE
1182: IF FND_API.to_boolean(p_init_msg_list) THEN
1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:
1186: -- Initialize API rturn status to success

Line 1187: x_return_status := FND_API.g_ret_sts_success;

1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:
1186: -- Initialize API rturn status to success
1187: x_return_status := FND_API.g_ret_sts_success;
1188:
1189: -- API body
1190:
1191: IF p_dlv_ath_rec.deliverable_id IS NOT NULL THEN

Line 1218: IF l_return_status = FND_API.g_ret_sts_error THEN

1214: p_dlv_ath_rec.deliverable_id := l_deliverable_rec.deliverable_id;
1215: p_dlv_ath_rec.object_version_number := l_deliverable_rec.object_version_number;
1216: p_dlv_ath_rec.x_action_status := l_deliverable_rec.x_action_status;
1217:
1218: IF l_return_status = FND_API.g_ret_sts_error THEN
1219: RAISE FND_API.g_exc_error;
1220: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1221: RAISE FND_API.g_exc_unexpected_error;
1222: END IF;

Line 1219: RAISE FND_API.g_exc_error;

1215: p_dlv_ath_rec.object_version_number := l_deliverable_rec.object_version_number;
1216: p_dlv_ath_rec.x_action_status := l_deliverable_rec.x_action_status;
1217:
1218: IF l_return_status = FND_API.g_ret_sts_error THEN
1219: RAISE FND_API.g_exc_error;
1220: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1221: RAISE FND_API.g_exc_unexpected_error;
1222: END IF;
1223:

Line 1220: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1216: p_dlv_ath_rec.x_action_status := l_deliverable_rec.x_action_status;
1217:
1218: IF l_return_status = FND_API.g_ret_sts_error THEN
1219: RAISE FND_API.g_exc_error;
1220: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1221: RAISE FND_API.g_exc_unexpected_error;
1222: END IF;
1223:
1224: -- Update/Create default attachment for all-site and all-language

Line 1221: RAISE FND_API.g_exc_unexpected_error;

1217:
1218: IF l_return_status = FND_API.g_ret_sts_error THEN
1219: RAISE FND_API.g_exc_error;
1220: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1221: RAISE FND_API.g_exc_unexpected_error;
1222: END IF;
1223:
1224: -- Update/Create default attachment for all-site and all-language
1225:

Line 1234: l_create_attachment := FND_API.g_true;

1230: IF l_operation_type = 'INSERT' THEN
1231:
1232: -- Create an attachment for all-site and all-language if any
1233: IF TRIM(p_dlv_ath_rec.ath_file_name) IS NOT NULL THEN
1234: l_create_attachment := FND_API.g_true;
1235: l_create_mapping := FND_API.g_true;
1236:
1237: END IF;
1238:

Line 1235: l_create_mapping := FND_API.g_true;

1231:
1232: -- Create an attachment for all-site and all-language if any
1233: IF TRIM(p_dlv_ath_rec.ath_file_name) IS NOT NULL THEN
1234: l_create_attachment := FND_API.g_true;
1235: l_create_mapping := FND_API.g_true;
1236:
1237: END IF;
1238:
1239: ELSE

Line 1244: l_delete_mapping := FND_API.g_true;

1240:
1241: -- Update the default attachment for the existing deliverable
1242:
1243: IF TRIM(p_dlv_ath_rec.ath_file_name) IS NULL THEN
1244: l_delete_mapping := FND_API.g_true;
1245:
1246: ELSE
1247:
1248: -- Check if it's an existing attachment

Line 1266: -- RAISE FND_API.g_exc_error;

1262: --modified by G. Zhang 05/23/01 10:57AM
1263: --IF NOT IBE_DSPMGRVALIDATION_GRP.check_attachment_deliverable(
1264: -- l_attachment_id, p_dlv_ath_rec.deliverable_id) THEN
1265: -- -- invalid attachment for the given deliverable
1266: -- RAISE FND_API.g_exc_error;
1267: --END IF;
1268:
1269: IF NOT IBE_DSPMGRVALIDATION_GRP.check_default_attachment(
1270: l_attachment_id) THEN

Line 1271: l_delete_mapping := FND_API.g_true;

1267: --END IF;
1268:
1269: IF NOT IBE_DSPMGRVALIDATION_GRP.check_default_attachment(
1270: l_attachment_id) THEN
1271: l_delete_mapping := FND_API.g_true;
1272: l_create_mapping := FND_API.g_true;
1273: END IF;
1274:
1275: ELSE

Line 1272: l_create_mapping := FND_API.g_true;

1268:
1269: IF NOT IBE_DSPMGRVALIDATION_GRP.check_default_attachment(
1270: l_attachment_id) THEN
1271: l_delete_mapping := FND_API.g_true;
1272: l_create_mapping := FND_API.g_true;
1273: END IF;
1274:
1275: ELSE
1276: -- new attachment

Line 1277: l_create_attachment := FND_API.g_true;

1273: END IF;
1274:
1275: ELSE
1276: -- new attachment
1277: l_create_attachment := FND_API.g_true;
1278: l_delete_mapping := FND_API.g_true;
1279: l_create_mapping := FND_API.g_true;
1280: END IF;
1281:

Line 1278: l_delete_mapping := FND_API.g_true;

1274:
1275: ELSE
1276: -- new attachment
1277: l_create_attachment := FND_API.g_true;
1278: l_delete_mapping := FND_API.g_true;
1279: l_create_mapping := FND_API.g_true;
1280: END IF;
1281:
1282: END IF;

Line 1279: l_create_mapping := FND_API.g_true;

1275: ELSE
1276: -- new attachment
1277: l_create_attachment := FND_API.g_true;
1278: l_delete_mapping := FND_API.g_true;
1279: l_create_mapping := FND_API.g_true;
1280: END IF;
1281:
1282: END IF;
1283:

Line 1286: IF l_create_attachment = FND_API.g_true THEN

1282: END IF;
1283:
1284: END IF;
1285:
1286: IF l_create_attachment = FND_API.g_true THEN
1287: l_attachment_rec.attachment_id := NULL;
1288: l_attachment_rec.deliverable_id := p_dlv_ath_rec.deliverable_id;
1289: l_attachment_rec.file_name := p_dlv_ath_rec.ath_file_name;
1290:

Line 1310: IF l_return_status = FND_API.g_ret_sts_error THEN

1306: x_msg_data => x_msg_data,
1307: p_attachment_rec => l_attachment_rec
1308: );
1309:
1310: IF l_return_status = FND_API.g_ret_sts_error THEN
1311: RAISE FND_API.g_exc_error;
1312: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1313: RAISE FND_API.g_exc_unexpected_error;
1314: END IF;

Line 1311: RAISE FND_API.g_exc_error;

1307: p_attachment_rec => l_attachment_rec
1308: );
1309:
1310: IF l_return_status = FND_API.g_ret_sts_error THEN
1311: RAISE FND_API.g_exc_error;
1312: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1313: RAISE FND_API.g_exc_unexpected_error;
1314: END IF;
1315:

Line 1312: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1308: );
1309:
1310: IF l_return_status = FND_API.g_ret_sts_error THEN
1311: RAISE FND_API.g_exc_error;
1312: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1313: RAISE FND_API.g_exc_unexpected_error;
1314: END IF;
1315:
1316: l_attachment_id := l_attachment_rec.attachment_id;

Line 1313: RAISE FND_API.g_exc_unexpected_error;

1309:
1310: IF l_return_status = FND_API.g_ret_sts_error THEN
1311: RAISE FND_API.g_exc_error;
1312: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1313: RAISE FND_API.g_exc_unexpected_error;
1314: END IF;
1315:
1316: l_attachment_id := l_attachment_rec.attachment_id;
1317: END IF;

Line 1319: IF l_delete_mapping = FND_API.g_true THEN

1315:
1316: l_attachment_id := l_attachment_rec.attachment_id;
1317: END IF;
1318:
1319: IF l_delete_mapping = FND_API.g_true THEN
1320: -- Delete all-site and all-lang mapping for this deliverable
1321: IBE_PhysicalMap_GRP.delete_dlv_all_all(
1322: p_deliverable_id => p_dlv_ath_rec.deliverable_id
1323: );

Line 1326: IF l_create_mapping = FND_API.g_true THEN

1322: p_deliverable_id => p_dlv_ath_rec.deliverable_id
1323: );
1324: END IF;
1325:
1326: IF l_create_mapping = FND_API.g_true THEN
1327: -- Create all-site and all-lang mapping for this default attachment
1328: IBE_PhysicalMap_GRP.save_physicalmap(
1329: p_api_version => p_api_version,
1330: x_return_status => l_return_status,

Line 1338: IF l_return_status = FND_API.g_ret_sts_error THEN

1334: p_msite_id => NULL,
1335: p_language_code_tbl => l_language_code_tbl
1336: );
1337:
1338: IF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1341: RAISE FND_API.g_exc_unexpected_error;
1342: END IF;

Line 1339: RAISE FND_API.g_exc_error;

1335: p_language_code_tbl => l_language_code_tbl
1336: );
1337:
1338: IF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1341: RAISE FND_API.g_exc_unexpected_error;
1342: END IF;
1343: END IF;

Line 1340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1336: );
1337:
1338: IF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1341: RAISE FND_API.g_exc_unexpected_error;
1342: END IF;
1343: END IF;
1344:

Line 1341: RAISE FND_API.g_exc_unexpected_error;

1337:
1338: IF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1341: RAISE FND_API.g_exc_unexpected_error;
1342: END IF;
1343: END IF;
1344:
1345: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_success;

Line 1345: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_success;

1341: RAISE FND_API.g_exc_unexpected_error;
1342: END IF;
1343: END IF;
1344:
1345: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_success;
1346:
1347: EXCEPTION
1348:
1349: WHEN FND_API.g_exc_error THEN

Line 1349: WHEN FND_API.g_exc_error THEN

1345: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_success;
1346:
1347: EXCEPTION
1348:
1349: WHEN FND_API.g_exc_error THEN
1350: ROLLBACK TO save_one_attachment_grp;
1351: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_error;
1352: x_return_status := FND_API.g_ret_sts_error;
1353:

Line 1351: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_error;

1347: EXCEPTION
1348:
1349: WHEN FND_API.g_exc_error THEN
1350: ROLLBACK TO save_one_attachment_grp;
1351: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_error;
1352: x_return_status := FND_API.g_ret_sts_error;
1353:
1354: WHEN FND_API.g_exc_unexpected_error THEN
1355: ROLLBACK TO save_one_attachment_grp;

Line 1352: x_return_status := FND_API.g_ret_sts_error;

1348:
1349: WHEN FND_API.g_exc_error THEN
1350: ROLLBACK TO save_one_attachment_grp;
1351: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_error;
1352: x_return_status := FND_API.g_ret_sts_error;
1353:
1354: WHEN FND_API.g_exc_unexpected_error THEN
1355: ROLLBACK TO save_one_attachment_grp;
1356: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;

Line 1354: WHEN FND_API.g_exc_unexpected_error THEN

1350: ROLLBACK TO save_one_attachment_grp;
1351: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_error;
1352: x_return_status := FND_API.g_ret_sts_error;
1353:
1354: WHEN FND_API.g_exc_unexpected_error THEN
1355: ROLLBACK TO save_one_attachment_grp;
1356: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1357: x_return_status := FND_API.g_ret_sts_unexp_error;
1358:

Line 1356: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;

1352: x_return_status := FND_API.g_ret_sts_error;
1353:
1354: WHEN FND_API.g_exc_unexpected_error THEN
1355: ROLLBACK TO save_one_attachment_grp;
1356: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1357: x_return_status := FND_API.g_ret_sts_unexp_error;
1358:
1359: WHEN OTHERS THEN
1360: ROLLBACK TO save_one_attachment_grp;

Line 1357: x_return_status := FND_API.g_ret_sts_unexp_error;

1353:
1354: WHEN FND_API.g_exc_unexpected_error THEN
1355: ROLLBACK TO save_one_attachment_grp;
1356: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1357: x_return_status := FND_API.g_ret_sts_unexp_error;
1358:
1359: WHEN OTHERS THEN
1360: ROLLBACK TO save_one_attachment_grp;
1361: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;

Line 1361: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;

1357: x_return_status := FND_API.g_ret_sts_unexp_error;
1358:
1359: WHEN OTHERS THEN
1360: ROLLBACK TO save_one_attachment_grp;
1361: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1362: x_return_status := FND_API.g_ret_sts_unexp_error ;
1363:
1364: IF FND_MSG_PUB.check_msg_level(
1365: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1362: x_return_status := FND_API.g_ret_sts_unexp_error ;

1358:
1359: WHEN OTHERS THEN
1360: ROLLBACK TO save_one_attachment_grp;
1361: p_dlv_ath_rec.x_ath_action_status := FND_API.g_ret_sts_unexp_error;
1362: x_return_status := FND_API.g_ret_sts_unexp_error ;
1363:
1364: IF FND_MSG_PUB.check_msg_level(
1365: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1366: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1372: IF FND_API.to_boolean(p_commit) THEN

1368: END;
1369:
1370: -- Check if the caller requested to commit ,
1371: -- If p_commit set to true, commit the transaction
1372: IF FND_API.to_boolean(p_commit) THEN
1373: COMMIT;
1374: END IF;
1375:
1376: -- Standard call to get message count and if count is 1, get message info

Line 1378: p_encoded => FND_API.g_false,

1374: END IF;
1375:
1376: -- Standard call to get message count and if count is 1, get message info
1377: FND_MSG_PUB.count_and_get(
1378: p_encoded => FND_API.g_false,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data
1381: );
1382:

Line 1385: WHEN FND_API.g_exc_error THEN

1381: );
1382:
1383: EXCEPTION
1384:
1385: WHEN FND_API.g_exc_error THEN
1386: ROLLBACK TO save_deliverable_grp;
1387: x_return_status := FND_API.g_ret_sts_error;
1388: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_error;
1389: FND_MSG_PUB.count_and_get(

Line 1387: x_return_status := FND_API.g_ret_sts_error;

1383: EXCEPTION
1384:
1385: WHEN FND_API.g_exc_error THEN
1386: ROLLBACK TO save_deliverable_grp;
1387: x_return_status := FND_API.g_ret_sts_error;
1388: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_error;
1389: FND_MSG_PUB.count_and_get(
1390: p_encoded => FND_API.g_false,
1391: p_count => x_msg_count,

Line 1388: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_error;

1384:
1385: WHEN FND_API.g_exc_error THEN
1386: ROLLBACK TO save_deliverable_grp;
1387: x_return_status := FND_API.g_ret_sts_error;
1388: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_error;
1389: FND_MSG_PUB.count_and_get(
1390: p_encoded => FND_API.g_false,
1391: p_count => x_msg_count,
1392: p_data => x_msg_data

Line 1390: p_encoded => FND_API.g_false,

1386: ROLLBACK TO save_deliverable_grp;
1387: x_return_status := FND_API.g_ret_sts_error;
1388: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_error;
1389: FND_MSG_PUB.count_and_get(
1390: p_encoded => FND_API.g_false,
1391: p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394:

Line 1395: WHEN FND_API.g_exc_unexpected_error THEN

1391: p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );
1394:
1395: WHEN FND_API.g_exc_unexpected_error THEN
1396: ROLLBACK TO save_deliverable_grp;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;
1398: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1399: FND_MSG_PUB.count_and_get(

Line 1397: x_return_status := FND_API.g_ret_sts_unexp_error ;

1393: );
1394:
1395: WHEN FND_API.g_exc_unexpected_error THEN
1396: ROLLBACK TO save_deliverable_grp;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;
1398: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1399: FND_MSG_PUB.count_and_get(
1400: p_encoded => FND_API.g_false,
1401: p_count => x_msg_count,

Line 1398: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;

1394:
1395: WHEN FND_API.g_exc_unexpected_error THEN
1396: ROLLBACK TO save_deliverable_grp;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;
1398: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1399: FND_MSG_PUB.count_and_get(
1400: p_encoded => FND_API.g_false,
1401: p_count => x_msg_count,
1402: p_data => x_msg_data

Line 1400: p_encoded => FND_API.g_false,

1396: ROLLBACK TO save_deliverable_grp;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;
1398: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1399: FND_MSG_PUB.count_and_get(
1400: p_encoded => FND_API.g_false,
1401: p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );
1404:

Line 1407: x_return_status := FND_API.g_ret_sts_unexp_error ;

1403: );
1404:
1405: WHEN OTHERS THEN
1406: ROLLBACK TO save_deliverable_grp;
1407: x_return_status := FND_API.g_ret_sts_unexp_error ;
1408: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1409:
1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1408: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;

1404:
1405: WHEN OTHERS THEN
1406: ROLLBACK TO save_deliverable_grp;
1407: x_return_status := FND_API.g_ret_sts_unexp_error ;
1408: p_dlv_ath_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
1409:
1410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1412: END IF;

Line 1415: p_encoded => FND_API.g_false,

1411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1412: END IF;
1413:
1414: FND_MSG_PUB.count_and_get(
1415: p_encoded => FND_API.g_false,
1416: p_count => x_msg_count,
1417: p_data => x_msg_data
1418: );
1419:

Line 1455: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1451:
1452: ---------------------------------------------------------------------
1453: PROCEDURE save_deliverable (
1454: p_api_version IN NUMBER,
1455: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1456: p_commit IN VARCHAR2 := FND_API.g_false,
1457: x_return_status OUT NOCOPY VARCHAR2,
1458: x_msg_count OUT NOCOPY NUMBER,
1459: x_msg_data OUT NOCOPY VARCHAR2,

Line 1456: p_commit IN VARCHAR2 := FND_API.g_false,

1452: ---------------------------------------------------------------------
1453: PROCEDURE save_deliverable (
1454: p_api_version IN NUMBER,
1455: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1456: p_commit IN VARCHAR2 := FND_API.g_false,
1457: x_return_status OUT NOCOPY VARCHAR2,
1458: x_msg_count OUT NOCOPY NUMBER,
1459: x_msg_data OUT NOCOPY VARCHAR2,
1460: p_dlv_ath_tbl IN OUT NOCOPY DLV_ATH_TBL_TYPE ) IS

Line 1473: IF NOT FND_API.compatible_api_call(

1469: -- Standard start of API savepoint
1470: SAVEPOINT save_deliverable_grp;
1471:
1472: -- Standard call to check for call compatibility
1473: IF NOT FND_API.compatible_api_call(
1474: g_api_version,
1475: p_api_version,
1476: l_api_name,
1477: g_pkg_name

Line 1479: RAISE FND_API.g_exc_unexpected_error;

1475: p_api_version,
1476: l_api_name,
1477: g_pkg_name
1478: ) THEN
1479: RAISE FND_API.g_exc_unexpected_error;
1480: END IF;
1481:
1482: -- Initialize message list if p_init_msg_list is set to TRUE
1483: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1483: IF FND_API.to_boolean(p_init_msg_list) THEN

1479: RAISE FND_API.g_exc_unexpected_error;
1480: END IF;
1481:
1482: -- Initialize message list if p_init_msg_list is set to TRUE
1483: IF FND_API.to_boolean(p_init_msg_list) THEN
1484: FND_MSG_PUB.initialize;
1485: END IF;
1486:
1487: -- Initialize API rturn status to success

Line 1488: x_return_status := FND_API.g_ret_sts_success;

1484: FND_MSG_PUB.initialize;
1485: END IF;
1486:
1487: -- Initialize API rturn status to success
1488: x_return_status := FND_API.g_ret_sts_success;
1489:
1490: -- API body
1491:
1492: IF p_dlv_ath_tbl IS NOT NULL THEN

Line 1503: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1499: x_msg_data => x_msg_data,
1500: p_dlv_ath_rec => p_dlv_ath_tbl(l_index)
1501: );
1502:
1503: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1504: x_return_status := FND_API.g_ret_sts_unexp_error;
1505: ELSIF l_return_status = FND_API.g_ret_sts_error
1506: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1507: x_return_status := FND_API.g_ret_sts_error;

Line 1504: x_return_status := FND_API.g_ret_sts_unexp_error;

1500: p_dlv_ath_rec => p_dlv_ath_tbl(l_index)
1501: );
1502:
1503: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1504: x_return_status := FND_API.g_ret_sts_unexp_error;
1505: ELSIF l_return_status = FND_API.g_ret_sts_error
1506: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1507: x_return_status := FND_API.g_ret_sts_error;
1508: END IF;

Line 1505: ELSIF l_return_status = FND_API.g_ret_sts_error

1501: );
1502:
1503: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1504: x_return_status := FND_API.g_ret_sts_unexp_error;
1505: ELSIF l_return_status = FND_API.g_ret_sts_error
1506: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1507: x_return_status := FND_API.g_ret_sts_error;
1508: END IF;
1509:

Line 1506: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN

1502:
1503: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1504: x_return_status := FND_API.g_ret_sts_unexp_error;
1505: ELSIF l_return_status = FND_API.g_ret_sts_error
1506: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1507: x_return_status := FND_API.g_ret_sts_error;
1508: END IF;
1509:
1510: END LOOP;

Line 1507: x_return_status := FND_API.g_ret_sts_error;

1503: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1504: x_return_status := FND_API.g_ret_sts_unexp_error;
1505: ELSIF l_return_status = FND_API.g_ret_sts_error
1506: AND x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1507: x_return_status := FND_API.g_ret_sts_error;
1508: END IF;
1509:
1510: END LOOP;
1511: END IF;

Line 1515: IF FND_API.to_boolean(p_commit) THEN

1511: END IF;
1512:
1513: -- Check if the caller requested to commit ,
1514: -- If p_commit set to true, commit the transaction
1515: IF FND_API.to_boolean(p_commit) THEN
1516: COMMIT;
1517: END IF;
1518:
1519: -- Standard call to get message count and if count is 1, get message info

Line 1521: p_encoded => FND_API.g_false,

1517: END IF;
1518:
1519: -- Standard call to get message count and if count is 1, get message info
1520: FND_MSG_PUB.count_and_get(
1521: p_encoded => FND_API.g_false,
1522: p_count => x_msg_count,
1523: p_data => x_msg_data
1524: );
1525:

Line 1528: WHEN FND_API.g_exc_error THEN

1524: );
1525:
1526: EXCEPTION
1527:
1528: WHEN FND_API.g_exc_error THEN
1529: ROLLBACK TO save_deliverable_grp;
1530: x_return_status := FND_API.g_ret_sts_error;
1531: FND_MSG_PUB.count_and_get(
1532: p_encoded => FND_API.g_false,

Line 1530: x_return_status := FND_API.g_ret_sts_error;

1526: EXCEPTION
1527:
1528: WHEN FND_API.g_exc_error THEN
1529: ROLLBACK TO save_deliverable_grp;
1530: x_return_status := FND_API.g_ret_sts_error;
1531: FND_MSG_PUB.count_and_get(
1532: p_encoded => FND_API.g_false,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data

Line 1532: p_encoded => FND_API.g_false,

1528: WHEN FND_API.g_exc_error THEN
1529: ROLLBACK TO save_deliverable_grp;
1530: x_return_status := FND_API.g_ret_sts_error;
1531: FND_MSG_PUB.count_and_get(
1532: p_encoded => FND_API.g_false,
1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );
1536:

Line 1537: WHEN FND_API.g_exc_unexpected_error THEN

1533: p_count => x_msg_count,
1534: p_data => x_msg_data
1535: );
1536:
1537: WHEN FND_API.g_exc_unexpected_error THEN
1538: ROLLBACK TO save_deliverable_grp;
1539: x_return_status := FND_API.g_ret_sts_unexp_error ;
1540: FND_MSG_PUB.count_and_get(
1541: p_encoded => FND_API.g_false,

Line 1539: x_return_status := FND_API.g_ret_sts_unexp_error ;

1535: );
1536:
1537: WHEN FND_API.g_exc_unexpected_error THEN
1538: ROLLBACK TO save_deliverable_grp;
1539: x_return_status := FND_API.g_ret_sts_unexp_error ;
1540: FND_MSG_PUB.count_and_get(
1541: p_encoded => FND_API.g_false,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data

Line 1541: p_encoded => FND_API.g_false,

1537: WHEN FND_API.g_exc_unexpected_error THEN
1538: ROLLBACK TO save_deliverable_grp;
1539: x_return_status := FND_API.g_ret_sts_unexp_error ;
1540: FND_MSG_PUB.count_and_get(
1541: p_encoded => FND_API.g_false,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data
1544: );
1545:

Line 1548: x_return_status := FND_API.g_ret_sts_unexp_error ;

1544: );
1545:
1546: WHEN OTHERS THEN
1547: ROLLBACK TO save_deliverable_grp;
1548: x_return_status := FND_API.g_ret_sts_unexp_error ;
1549:
1550: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1551: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1552: END IF;

Line 1555: p_encoded => FND_API.g_false,

1551: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1552: END IF;
1553:
1554: FND_MSG_PUB.count_and_get(
1555: p_encoded => FND_API.g_false,
1556: p_count => x_msg_count,
1557: p_data => x_msg_data
1558: );
1559:

Line 1585: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1581: -- 4. Raise an exception for any other errors
1582: ---------------------------------------------------------------------
1583: PROCEDURE delete_deliverable (
1584: p_api_version IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1586: p_commit IN VARCHAR2 := FND_API.g_false,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2,

Line 1586: p_commit IN VARCHAR2 := FND_API.g_false,

1582: ---------------------------------------------------------------------
1583: PROCEDURE delete_deliverable (
1584: p_api_version IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1586: p_commit IN VARCHAR2 := FND_API.g_false,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2,
1590: p_dlv_id_ver_tbl IN OUT NOCOPY DLV_ID_VER_TBL_TYPE ) IS

Line 1605: IF NOT FND_API.compatible_api_call(

1601: -- Standard start of API savepoint
1602: SAVEPOINT delete_deliverable_grp;
1603:
1604: -- Standard call to check for call compatibility
1605: IF NOT FND_API.compatible_api_call(
1606: g_api_version,
1607: p_api_version,
1608: l_api_name,
1609: g_pkg_name

Line 1611: RAISE FND_API.g_exc_unexpected_error;

1607: p_api_version,
1608: l_api_name,
1609: g_pkg_name
1610: ) THEN
1611: RAISE FND_API.g_exc_unexpected_error;
1612: END IF;
1613:
1614: -- Initialize message list if p_init_msg_list is set to TRUE
1615: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1615: IF FND_API.to_boolean(p_init_msg_list) THEN

1611: RAISE FND_API.g_exc_unexpected_error;
1612: END IF;
1613:
1614: -- Initialize message list if p_init_msg_list is set to TRUE
1615: IF FND_API.to_boolean(p_init_msg_list) THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618:
1619: -- Initialize API rturn status to success

Line 1620: x_return_status := FND_API.g_ret_sts_success;

1616: FND_MSG_PUB.initialize;
1617: END IF;
1618:
1619: -- Initialize API rturn status to success
1620: x_return_status := FND_API.g_ret_sts_success;
1621:
1622: -- API body
1623:
1624: -- Check if the deliverable exists

Line 1635: RAISE FND_API.g_exc_error;

1631:
1632: IF NOT IBE_DSPMGRVALIDATION_GRP.check_deliverable_exists(
1633: p_dlv_id_ver_tbl(l_index).deliverable_id,
1634: p_dlv_id_ver_tbl(l_index).object_version_number) THEN
1635: RAISE FND_API.g_exc_error;
1636: END IF;
1637:
1638: -- Delete from the section tables
1639: IBE_DSP_SECTION_GRP.update_deliverable_to_null(

Line 1647: IF l_return_status = FND_API.g_ret_sts_error THEN

1643: x_msg_count => x_msg_count,
1644: x_msg_data => x_msg_data
1645: );
1646:
1647: IF l_return_status = FND_API.g_ret_sts_error THEN
1648: RAISE FND_API.g_exc_error;
1649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1650: RAISE FND_API.g_exc_unexpected_error;
1651: END IF;

Line 1648: RAISE FND_API.g_exc_error;

1644: x_msg_data => x_msg_data
1645: );
1646:
1647: IF l_return_status = FND_API.g_ret_sts_error THEN
1648: RAISE FND_API.g_exc_error;
1649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1650: RAISE FND_API.g_exc_unexpected_error;
1651: END IF;
1652:

Line 1649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1645: );
1646:
1647: IF l_return_status = FND_API.g_ret_sts_error THEN
1648: RAISE FND_API.g_exc_error;
1649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1650: RAISE FND_API.g_exc_unexpected_error;
1651: END IF;
1652:
1653: -- Delete all the associated display contexts

Line 1650: RAISE FND_API.g_exc_unexpected_error;

1646:
1647: IF l_return_status = FND_API.g_ret_sts_error THEN
1648: RAISE FND_API.g_exc_error;
1649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1650: RAISE FND_API.g_exc_unexpected_error;
1651: END IF;
1652:
1653: -- Delete all the associated display contexts
1654: IBE_DisplayContext_GRP.delete_deliverable(

Line 1682: IF l_return_status = FND_API.g_ret_sts_error THEN

1678: x_msg_data => x_msg_data,
1679: p_item_id => p_dlv_id_ver_tbl(l_index).deliverable_id
1680: );
1681:
1682: IF l_return_status = FND_API.g_ret_sts_error THEN
1683: RAISE FND_API.g_exc_error;
1684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1685: RAISE FND_API.g_exc_unexpected_error;
1686: END IF;

Line 1683: RAISE FND_API.g_exc_error;

1679: p_item_id => p_dlv_id_ver_tbl(l_index).deliverable_id
1680: );
1681:
1682: IF l_return_status = FND_API.g_ret_sts_error THEN
1683: RAISE FND_API.g_exc_error;
1684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1685: RAISE FND_API.g_exc_unexpected_error;
1686: END IF;
1687:

Line 1684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1680: );
1681:
1682: IF l_return_status = FND_API.g_ret_sts_error THEN
1683: RAISE FND_API.g_exc_error;
1684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1685: RAISE FND_API.g_exc_unexpected_error;
1686: END IF;
1687:
1688: p_dlv_id_ver_tbl(l_index).x_action_status

Line 1685: RAISE FND_API.g_exc_unexpected_error;

1681:
1682: IF l_return_status = FND_API.g_ret_sts_error THEN
1683: RAISE FND_API.g_exc_error;
1684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1685: RAISE FND_API.g_exc_unexpected_error;
1686: END IF;
1687:
1688: p_dlv_id_ver_tbl(l_index).x_action_status
1689: := FND_API.g_ret_sts_success;

Line 1689: := FND_API.g_ret_sts_success;

1685: RAISE FND_API.g_exc_unexpected_error;
1686: END IF;
1687:
1688: p_dlv_id_ver_tbl(l_index).x_action_status
1689: := FND_API.g_ret_sts_success;
1690:
1691: EXCEPTION
1692:
1693: WHEN FND_API.g_exc_error THEN

Line 1693: WHEN FND_API.g_exc_error THEN

1689: := FND_API.g_ret_sts_success;
1690:
1691: EXCEPTION
1692:
1693: WHEN FND_API.g_exc_error THEN
1694: ROLLBACK TO delete_one_deliverable_grp;
1695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1696: x_return_status := FND_API.g_ret_sts_error;
1697: END IF;

Line 1695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

1691: EXCEPTION
1692:
1693: WHEN FND_API.g_exc_error THEN
1694: ROLLBACK TO delete_one_deliverable_grp;
1695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1696: x_return_status := FND_API.g_ret_sts_error;
1697: END IF;
1698: p_dlv_id_ver_tbl(l_index).x_action_status
1699: := FND_API.g_ret_sts_error;

Line 1696: x_return_status := FND_API.g_ret_sts_error;

1692:
1693: WHEN FND_API.g_exc_error THEN
1694: ROLLBACK TO delete_one_deliverable_grp;
1695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1696: x_return_status := FND_API.g_ret_sts_error;
1697: END IF;
1698: p_dlv_id_ver_tbl(l_index).x_action_status
1699: := FND_API.g_ret_sts_error;
1700:

Line 1699: := FND_API.g_ret_sts_error;

1695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1696: x_return_status := FND_API.g_ret_sts_error;
1697: END IF;
1698: p_dlv_id_ver_tbl(l_index).x_action_status
1699: := FND_API.g_ret_sts_error;
1700:
1701: WHEN FND_API.g_exc_unexpected_error THEN
1702: ROLLBACK TO delete_one_deliverable_grp;
1703: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1701: WHEN FND_API.g_exc_unexpected_error THEN

1697: END IF;
1698: p_dlv_id_ver_tbl(l_index).x_action_status
1699: := FND_API.g_ret_sts_error;
1700:
1701: WHEN FND_API.g_exc_unexpected_error THEN
1702: ROLLBACK TO delete_one_deliverable_grp;
1703: x_return_status := FND_API.g_ret_sts_unexp_error;
1704: p_dlv_id_ver_tbl(l_index).x_action_status
1705: := FND_API.g_ret_sts_unexp_error;

Line 1703: x_return_status := FND_API.g_ret_sts_unexp_error;

1699: := FND_API.g_ret_sts_error;
1700:
1701: WHEN FND_API.g_exc_unexpected_error THEN
1702: ROLLBACK TO delete_one_deliverable_grp;
1703: x_return_status := FND_API.g_ret_sts_unexp_error;
1704: p_dlv_id_ver_tbl(l_index).x_action_status
1705: := FND_API.g_ret_sts_unexp_error;
1706:
1707: WHEN OTHERS THEN

Line 1705: := FND_API.g_ret_sts_unexp_error;

1701: WHEN FND_API.g_exc_unexpected_error THEN
1702: ROLLBACK TO delete_one_deliverable_grp;
1703: x_return_status := FND_API.g_ret_sts_unexp_error;
1704: p_dlv_id_ver_tbl(l_index).x_action_status
1705: := FND_API.g_ret_sts_unexp_error;
1706:
1707: WHEN OTHERS THEN
1708: ROLLBACK TO delete_one_deliverable_grp;
1709: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1709: x_return_status := FND_API.g_ret_sts_unexp_error ;

1705: := FND_API.g_ret_sts_unexp_error;
1706:
1707: WHEN OTHERS THEN
1708: ROLLBACK TO delete_one_deliverable_grp;
1709: x_return_status := FND_API.g_ret_sts_unexp_error ;
1710: p_dlv_id_ver_tbl(l_index).x_action_status
1711: := FND_API.g_ret_sts_unexp_error;
1712:
1713: IF FND_MSG_PUB.check_msg_level(

Line 1711: := FND_API.g_ret_sts_unexp_error;

1707: WHEN OTHERS THEN
1708: ROLLBACK TO delete_one_deliverable_grp;
1709: x_return_status := FND_API.g_ret_sts_unexp_error ;
1710: p_dlv_id_ver_tbl(l_index).x_action_status
1711: := FND_API.g_ret_sts_unexp_error;
1712:
1713: IF FND_MSG_PUB.check_msg_level(
1714: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1715: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1724: IF FND_API.to_boolean(p_commit) THEN

1720: END IF;
1721:
1722: -- Check if the caller requested to commit ,
1723: -- If p_commit set to true, commit the transaction
1724: IF FND_API.to_boolean(p_commit) THEN
1725: COMMIT;
1726: END IF;
1727:
1728: -- Standard call to get message count and if count is 1, get message info

Line 1730: p_encoded => FND_API.g_false,

1726: END IF;
1727:
1728: -- Standard call to get message count and if count is 1, get message info
1729: FND_MSG_PUB.count_and_get(
1730: p_encoded => FND_API.g_false,
1731: p_count => x_msg_count,
1732: p_data => x_msg_data
1733: );
1734:

Line 1737: WHEN FND_API.g_exc_error THEN

1733: );
1734:
1735: EXCEPTION
1736:
1737: WHEN FND_API.g_exc_error THEN
1738: ROLLBACK TO delete_deliverable_grp;
1739: x_return_status := FND_API.g_ret_sts_error;
1740: FND_MSG_PUB.count_and_get(
1741: p_encoded => FND_API.g_false,

Line 1739: x_return_status := FND_API.g_ret_sts_error;

1735: EXCEPTION
1736:
1737: WHEN FND_API.g_exc_error THEN
1738: ROLLBACK TO delete_deliverable_grp;
1739: x_return_status := FND_API.g_ret_sts_error;
1740: FND_MSG_PUB.count_and_get(
1741: p_encoded => FND_API.g_false,
1742: p_count => x_msg_count,
1743: p_data => x_msg_data

Line 1741: p_encoded => FND_API.g_false,

1737: WHEN FND_API.g_exc_error THEN
1738: ROLLBACK TO delete_deliverable_grp;
1739: x_return_status := FND_API.g_ret_sts_error;
1740: FND_MSG_PUB.count_and_get(
1741: p_encoded => FND_API.g_false,
1742: p_count => x_msg_count,
1743: p_data => x_msg_data
1744: );
1745:

Line 1746: WHEN FND_API.g_exc_unexpected_error THEN

1742: p_count => x_msg_count,
1743: p_data => x_msg_data
1744: );
1745:
1746: WHEN FND_API.g_exc_unexpected_error THEN
1747: ROLLBACK TO delete_deliverable_grp;
1748: x_return_status := FND_API.g_ret_sts_unexp_error ;
1749: FND_MSG_PUB.count_and_get(
1750: p_encoded => FND_API.g_false,

Line 1748: x_return_status := FND_API.g_ret_sts_unexp_error ;

1744: );
1745:
1746: WHEN FND_API.g_exc_unexpected_error THEN
1747: ROLLBACK TO delete_deliverable_grp;
1748: x_return_status := FND_API.g_ret_sts_unexp_error ;
1749: FND_MSG_PUB.count_and_get(
1750: p_encoded => FND_API.g_false,
1751: p_count => x_msg_count,
1752: p_data => x_msg_data

Line 1750: p_encoded => FND_API.g_false,

1746: WHEN FND_API.g_exc_unexpected_error THEN
1747: ROLLBACK TO delete_deliverable_grp;
1748: x_return_status := FND_API.g_ret_sts_unexp_error ;
1749: FND_MSG_PUB.count_and_get(
1750: p_encoded => FND_API.g_false,
1751: p_count => x_msg_count,
1752: p_data => x_msg_data
1753: );
1754:

Line 1757: x_return_status := FND_API.g_ret_sts_unexp_error ;

1753: );
1754:
1755: WHEN OTHERS THEN
1756: ROLLBACK TO delete_deliverable_grp;
1757: x_return_status := FND_API.g_ret_sts_unexp_error ;
1758:
1759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1760: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1761: END IF;

Line 1764: p_encoded => FND_API.g_false,

1760: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1761: END IF;
1762:
1763: FND_MSG_PUB.count_and_get(
1764: p_encoded => FND_API.g_false,
1765: p_count => x_msg_count,
1766: p_data => x_msg_data
1767: );
1768: