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.JTF_AMV_ITEM_PUB dependencies on FND_MESSAGE

Line 145: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');

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;

Line 146: FND_MESSAGE.Set_Token('ID',

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;

Line 165: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_NAME_NULL');

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;

Line 228: FND_MESSAGE.Set_name('JTF','JTF_AMV_NULL_ITEM_TYPE');

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;

Line 248: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');

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;

Line 255: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_NULL');

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

Line 266: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');

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;

Line 274: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICABLE_CODE_NULL');

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

Line 285: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');

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;

Line 418: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 419: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 537: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_CHANGED');

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;

Line 538: FND_MESSAGE.Set_Token('ID',

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;

Line 554: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPLICATIONID_INVALID');

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;

Line 555: FND_MESSAGE.Set_Token('ID',

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;

Line 733: FND_MESSAGE.Set_name('JTF','JTF_AMV_ACCESS_NAME_MISSING');

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;

Line 760: FND_MESSAGE.Set_name('JTF','JTF_AMV_TYPE_CODE_WRONG');

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;

Line 787: FND_MESSAGE.Set_name('JTF','JTF_AMV_APPL_TO_CODE_WRONG');

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;

Line 955: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 956: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1049: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1050: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1067: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_KEYWORD');

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;

Line 1068: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );

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

Line 1069: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));

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;

Line 1219: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1220: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1234: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_KEYWORD');

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;

Line 1235: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );

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

Line 1236: FND_MESSAGE.Set_Token('KEYWORD', p_keyword_tab(i));

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;

Line 1360: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1361: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1463: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1464: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1563: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1564: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1581: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HAS_AUTHOR');

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;

Line 1582: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );

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

Line 1583: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));

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;

Line 1731: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1732: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1746: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_HASNOT_AUTHOR');

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;

Line 1747: FND_MESSAGE.Set_Token('ID', to_char(p_item_id) );

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

Line 1748: FND_MESSAGE.Set_Token('AUTHOR', p_author_tab(i));

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;

Line 1872: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1873: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;

Line 1970: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');

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;

Line 1971: FND_MESSAGE.Set_Token('ID', to_char(nvl(p_item_id, -1) ));

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;