141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: -- Check if application id of the item record is valid
143: IF (Is_ApplIdValid(l_item_rec.application_id) <> TRUE) THEN
144: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
145: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
146: FND_MESSAGE.Set_Token('ID',
147: to_char( nvl(l_item_rec.application_id, -1) ) );
148: FND_MSG_PUB.Add;
149: END IF;
142: -- Check if application id of the item record is valid
143: IF (Is_ApplIdValid(l_item_rec.application_id) <> TRUE) THEN
144: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
145: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
146: FND_MESSAGE.Set_Token('ID',
147: to_char( nvl(l_item_rec.application_id, -1) ) );
148: FND_MSG_PUB.Add;
149: END IF;
150: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162: IF (l_item_rec.item_name is null OR
163: l_item_rec.item_name = FND_API.G_MISS_CHAR) THEN
164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_NAME_NULL');
166: FND_MSG_PUB.Add;
167: END IF;
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
224: IF (l_item_rec.application_id = G_MES_APPL_ID) THEN
225: -- Check if item type in the item record is null
226: IF (l_item_rec.item_type IS NULL ) THEN
227: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
228: FND_MESSAGE.Set_name('JTF','JTF_AMV_NULL_ITEM_TYPE');
229: FND_MSG_PUB.Add;
230: END IF;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
244: /*
245: ELSIF (l_item_rec.application_id = G_ISTORE_APPL_ID ) THEN
246: IF (l_item_rec.access_name is null ) THEN
247: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
248: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: IF (l_item_rec.deliverable_type_code is null ) THEN
254: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
255: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_NULL');
256: FND_MSG_PUB.Add;
257: END IF;
258: RAISE FND_API.G_EXC_ERROR;
259: ELSE
262: p_lookup_type => 'JTF_AMV_DELV_TYPE_CODE',
263: p_lookup_code => l_item_rec.deliverable_type_code
264: ) = FND_API.G_FALSE THEN
265: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
266: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');
267: FND_MSG_PUB.Add;
268: END IF;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
270: END IF;
271: END IF;
272: IF (l_item_rec.applicable_to_code is null ) THEN
273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICABLE_CODE_NULL');
275: FND_MSG_PUB.Add;
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;
278: ELSE
281: p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
282: p_lookup_code => l_item_rec.applicable_to_code
283: ) = FND_API.G_FALSE THEN
284: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
285: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');
286: FND_MSG_PUB.Add;
287: END IF;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415: -- Check if item id is valid.
416: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
417: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
418: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
419: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
420: FND_MSG_PUB.Add;
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
415: -- Check if item id is valid.
416: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
417: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
418: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
419: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
420: FND_MSG_PUB.Add;
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
533: l_new_item_rec.object_version_number :=
534: l_new_item_rec.object_version_number +1;
535: ELSE
536: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_CHANGED');
538: FND_MESSAGE.Set_Token('ID',
539: to_char(nvl(l_new_item_rec.item_id,-1)) );
540: FND_MSG_PUB.Add;
541: END IF;
534: l_new_item_rec.object_version_number +1;
535: ELSE
536: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
537: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_CHANGED');
538: FND_MESSAGE.Set_Token('ID',
539: to_char(nvl(l_new_item_rec.item_id,-1)) );
540: FND_MSG_PUB.Add;
541: END IF;
542: RAISE FND_API.G_EXC_ERROR;
550: -- Check if application in the item object is valid
551: l_record_change_flag := true;
552: IF (Is_ApplIdValid(l_new_item_rec.application_id) <> TRUE) THEN
553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
555: FND_MESSAGE.Set_Token('ID',
556: to_char( l_new_item_rec.application_id ) );
557: FND_MSG_PUB.Add;
558: END IF;
551: l_record_change_flag := true;
552: IF (Is_ApplIdValid(l_new_item_rec.application_id) <> TRUE) THEN
553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
554: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');
555: FND_MESSAGE.Set_Token('ID',
556: to_char( l_new_item_rec.application_id ) );
557: FND_MSG_PUB.Add;
558: END IF;
559: RAISE FND_API.G_EXC_ERROR;
729: l_new_item_rec.application_id = FND_API.G_MISS_CHAR and
730: l_old_item_rec.application_id = G_ISTORE_APPL_ID ) THEN
731: IF (l_new_item_rec.access_name IS NULL) THEN
732: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
733: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');
734: FND_MSG_PUB.Add;
735: END IF;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
756: p_lookup_type => 'JTF_AMV_DELV_TYPE_CODE',
757: p_lookup_code => l_new_item_rec.deliverable_type_code
758: ) = FND_API.G_FALSE THEN
759: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
760: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');
761: FND_MSG_PUB.Add;
762: END IF;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
783: p_lookup_type => 'JTF_AMV_APPLI_TO_CODE',
784: p_lookup_code => l_new_item_rec.applicable_to_code
785: ) = FND_API.G_FALSE THEN
786: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
787: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');
788: FND_MSG_PUB.Add;
789: END IF;
790: RAISE FND_API.G_EXC_ERROR;
791: END IF;
951: FETCH Get_Item_csr INTO x_item_rec;
952: IF (Get_Item_csr%NOTFOUND) THEN
953: CLOSE Get_Item_csr;
954: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
955: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
956: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
957: FND_MSG_PUB.Add;
958: END IF;
959: RAISE FND_API.G_EXC_ERROR;
952: IF (Get_Item_csr%NOTFOUND) THEN
953: CLOSE Get_Item_csr;
954: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
955: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
956: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
957: FND_MSG_PUB.Add;
958: END IF;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: -- Check if item id is valid.
1047: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1048: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1050: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: RAISE FND_API.G_EXC_ERROR;
1046: -- Check if item id is valid.
1047: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1048: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1049: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1050: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1051: FND_MSG_PUB.Add;
1052: END IF;
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1063: IF (Check_Itemkeyword_csr%FOUND) THEN
1064: CLOSE Check_Itemkeyword_csr;
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1067: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_KEYWORD');
1068: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1069: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1070: FND_MSG_PUB.Add;
1071: END IF;
1064: CLOSE Check_Itemkeyword_csr;
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1067: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_KEYWORD');
1068: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1069: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1070: FND_MSG_PUB.Add;
1071: END IF;
1072: ELSE
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1067: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_KEYWORD');
1068: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1069: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1070: FND_MSG_PUB.Add;
1071: END IF;
1072: ELSE
1073: CLOSE Check_Itemkeyword_csr;
1215: --
1216: -- Check if item id is valid.
1217: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1219: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1220: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1221: FND_MSG_PUB.Add;
1222: END IF;
1223: RAISE FND_API.G_EXC_ERROR;
1216: -- Check if item id is valid.
1217: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1218: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1219: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1220: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1221: FND_MSG_PUB.Add;
1222: END IF;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1230: IF (Check_Itemkeyword_csr%NOTFOUND) THEN
1231: CLOSE Check_Itemkeyword_csr;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_KEYWORD');
1235: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1236: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1237: FND_MSG_PUB.Add;
1238: END IF;
1231: CLOSE Check_Itemkeyword_csr;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_KEYWORD');
1235: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1236: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1237: FND_MSG_PUB.Add;
1238: END IF;
1239: ELSE
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_KEYWORD');
1235: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1236: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));
1237: FND_MSG_PUB.Add;
1238: END IF;
1239: ELSE
1240: CLOSE Check_Itemkeyword_csr;
1356: x_return_status := FND_API.G_RET_STS_SUCCESS;
1357: -- Check if item id is valid.
1358: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1359: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1360: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1361: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1362: FND_MSG_PUB.Add;
1363: END IF;
1364: RAISE FND_API.G_EXC_ERROR;
1357: -- Check if item id is valid.
1358: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1359: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1360: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1361: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1362: FND_MSG_PUB.Add;
1363: END IF;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: -- Check if item id is valid.
1461: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1462: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1463: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1464: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1465: FND_MSG_PUB.Add;
1466: END IF;
1467: RAISE FND_API.G_EXC_ERROR;
1460: -- Check if item id is valid.
1461: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1462: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1463: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1464: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1465: FND_MSG_PUB.Add;
1466: END IF;
1467: RAISE FND_API.G_EXC_ERROR;
1468: END IF;
1559: x_return_status := FND_API.G_RET_STS_SUCCESS;
1560: -- Check if item id is valid.
1561: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1562: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1563: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1564: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1565: FND_MSG_PUB.Add;
1566: END IF;
1567: RAISE FND_API.G_EXC_ERROR;
1560: -- Check if item id is valid.
1561: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1562: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1563: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1564: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1565: FND_MSG_PUB.Add;
1566: END IF;
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;
1577: IF (Check_Itemauthor_csr%FOUND) THEN
1578: CLOSE Check_Itemauthor_csr;
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1581: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_AUTHOR');
1582: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1583: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1584: FND_MSG_PUB.Add;
1585: END IF;
1578: CLOSE Check_Itemauthor_csr;
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1581: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_AUTHOR');
1582: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1583: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1584: FND_MSG_PUB.Add;
1585: END IF;
1586: ELSE
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1581: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_AUTHOR');
1582: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1583: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1584: FND_MSG_PUB.Add;
1585: END IF;
1586: ELSE
1587: CLOSE Check_Itemauthor_csr;
1727: --
1728: -- Check if item id is valid.
1729: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1730: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1732: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1733: FND_MSG_PUB.Add;
1734: END IF;
1735: RAISE FND_API.G_EXC_ERROR;
1728: -- Check if item id is valid.
1729: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1730: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1731: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1732: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1733: FND_MSG_PUB.Add;
1734: END IF;
1735: RAISE FND_API.G_EXC_ERROR;
1736: END IF;
1742: IF (Check_Itemauthor_csr%NOTFOUND) THEN
1743: CLOSE Check_Itemauthor_csr;
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1746: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_AUTHOR');
1747: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1748: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1749: FND_MSG_PUB.Add;
1750: END IF;
1743: CLOSE Check_Itemauthor_csr;
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1746: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_AUTHOR');
1747: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1748: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1749: FND_MSG_PUB.Add;
1750: END IF;
1751: ELSE
1744: x_return_status := FND_API.G_RET_STS_ERROR;
1745: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1746: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_AUTHOR');
1747: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );
1748: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));
1749: FND_MSG_PUB.Add;
1750: END IF;
1751: ELSE
1752: CLOSE Check_Itemauthor_csr;
1868: x_return_status := FND_API.G_RET_STS_SUCCESS;
1869: -- Check if item id is valid.
1870: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1873: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1874: FND_MSG_PUB.Add;
1875: END IF;
1876: RAISE FND_API.G_EXC_ERROR;
1869: -- Check if item id is valid.
1870: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1873: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1874: FND_MSG_PUB.Add;
1875: END IF;
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF;
1966: x_return_status := FND_API.G_RET_STS_SUCCESS;
1967: -- Check if item id is valid.
1968: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1969: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1971: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1972: FND_MSG_PUB.Add;
1973: END IF;
1974: RAISE FND_API.G_EXC_ERROR;
1967: -- Check if item id is valid.
1968: IF (Is_ItemIdValid(p_item_id) <> TRUE) THEN
1969: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1970: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
1971: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));
1972: FND_MSG_PUB.Add;
1973: END IF;
1974: RAISE FND_API.G_EXC_ERROR;
1975: END IF;