706:
707: l_operation_type VARCHAR2(10) := 'INSERT';
708:
709: l_deliverable_id NUMBER;
710: l_item_rec JTF_AMV_ITEM_PUB.ITEM_REC_TYPE;
711: l_return_status VARCHAR2(1);
712:
713: l_appl_id NUMBER;
714:
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,
811: x_return_status => l_return_status,
812: x_msg_count => x_msg_count,
813: x_msg_data => x_msg_data,
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(
826: p_api_version => g_amv_api_version,
827: x_return_status => l_return_status,
828: x_msg_count => x_msg_count,
829: x_msg_data => x_msg_data,
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,
869: x_return_status => l_return_status,
870: x_msg_count => x_msg_count,
871: x_msg_data => x_msg_data,
878: RAISE FND_API.g_exc_unexpected_error;
879: END IF;
880:
881: -- Delete existing keywords
882: JTF_AMV_ITEM_PUB.delete_itemkeyword(
883: p_api_version => g_amv_api_version,
884: x_return_status => l_return_status,
885: x_msg_count => x_msg_count,
886: x_msg_data => x_msg_data,
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(
899: p_api_version => g_amv_api_version,
900: x_return_status => l_return_status,
901: x_msg_count => x_msg_count,
902: x_msg_data => x_msg_data,
1670: p_dlv_id_ver_tbl(l_index).deliverable_id
1671: );
1672:
1673: -- Delete the item
1674: JTF_AMV_ITEM_PUB.delete_item(
1675: p_api_version => g_amv_api_version,
1676: x_return_status => l_return_status,
1677: x_msg_count => x_msg_count,
1678: x_msg_data => x_msg_data,