[Home] [Help]
123: -------------------- put required items here ---------------------
124:
125: --IF p_act_attachment_rec.xxx IS NULL THEN
126: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
127: -- FND_MESSAGE.set_name('JTF', 'JTF_AMV_API_RECORD_NOT_FOUND');
128: -- FND_MSG_PUB.add;
129: -- END IF;
130:
131: -- x_return_status := FND_API.g_ret_sts_error;
161: 'jtf_amv_attachments',
162: 'attachment_id = ' || p_act_attachment_rec.attachment_id
163: ) = FND_API.g_false 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_ACT_ATTACH_DUPL_ID');
166: FND_MSG_PUB.add;
167: END IF;
168: x_return_status := FND_API.g_ret_sts_error;
169: RETURN;
200: ) = FND_API.g_false
201: THEN
202: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
203: THEN
204: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_BAD_XXX');
205: FND_MSG_PUB.add;
206: END IF;
207:
208: x_return_status := FND_API.g_ret_sts_error;
260: THEN
261: IF is_Y_or_N(p_act_attachment_rec.enabled_flag) = FND_API.g_false THEN
262: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
263: THEN
264: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_BAD_FLAG');
265: FND_MSG_PUB.add;
266: END IF;
267: x_return_status := FND_API.g_ret_sts_error;
268: RETURN;
275: THEN
276: IF is_Y_or_N(p_act_attachment_rec.can_fulfill_electronic_flag)
277: = FND_API.g_false THEN
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
279: FND_MESSAGE.set_name('JTF', 'JTF_AMV_BAD_CAN_FUL_ELEC');
280: FND_MSG_PUB.add;
281: END IF;
282: x_return_status := FND_API.g_ret_sts_error;
283: RETURN;
386: FETCH c_get_deli_type_code INTO l_deli_type_code;
387: IF (c_get_deli_type_code%NOTFOUND) THEN
388: CLOSE c_get_deli_type_code;
389: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
390: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
391: FND_MESSAGE.Set_Token('ID',
392: to_char(nvl(l_act_attachment_rec.attachment_used_by_id,-1)));
393: FND_MSG_PUB.Add;
394: END IF;
387: IF (c_get_deli_type_code%NOTFOUND) THEN
388: CLOSE c_get_deli_type_code;
389: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
390: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
391: FND_MESSAGE.Set_Token('ID',
392: to_char(nvl(l_act_attachment_rec.attachment_used_by_id,-1)));
393: FND_MSG_PUB.Add;
394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
399: -- Istore specific stuff.
400: IF (l_act_attachment_rec.application_id = G_ISTORE_APPL_ID) THEN
401: IF l_act_attachment_rec.file_name is null THEN
402: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
403: FND_MESSAGE.Set_name('JTF','JTF_AMV_FILENAME_NULL');
404: FND_MSG_PUB.Add;
405: END IF;
406: RAISE FND_API.G_EXC_ERROR;
407: END IF;
408: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM AND
409: l_act_attachment_rec.display_url is null AND
410: l_deli_type_code = 'MEDIA') THEN
411: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
412: FND_MESSAGE.Set_name('JTF','JTF_AMV_DISPLAY_RUL_NULL');
413: FND_MSG_PUB.Add;
414: END IF;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
617: AND object_version_number = p_object_version;
618:
619: IF (SQL%NOTFOUND) THEN
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
621: FND_MESSAGE.set_name('JTF', 'JTF_AMV_API_RECORD_NOT_FOUND');
622: FND_MSG_PUB.add;
623: END IF;
624: RAISE FND_API.g_exc_error;
625: END IF;
757: FETCH c_get_deli_type_code INTO l_deli_type_code;
758: IF (c_get_deli_type_code%NOTFOUND) THEN
759: CLOSE c_get_deli_type_code;
760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
761: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
762: FND_MESSAGE.Set_Token('ID',
763: to_char(nvl(l_act_attachment_rec.attachment_used_by_id,-1)));
764: FND_MSG_PUB.Add;
765: END IF;
758: IF (c_get_deli_type_code%NOTFOUND) THEN
759: CLOSE c_get_deli_type_code;
760: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
761: FND_MESSAGE.Set_name('JTF','JTF_AMV_ITEM_RECORD_MISSING');
762: FND_MESSAGE.Set_Token('ID',
763: to_char(nvl(l_act_attachment_rec.attachment_used_by_id,-1)));
764: FND_MSG_PUB.Add;
765: END IF;
766: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770: IF (l_act_attachment_rec.application_id = G_ISTORE_APPL_ID) THEN
771: IF l_act_attachment_rec.file_name is null THEN
772: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
773: FND_MESSAGE.Set_name('JTF','JTF_AMV_FILENAME_NULL');
774: FND_MSG_PUB.Add;
775: END IF;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM AND
779: l_act_attachment_rec.display_url is null AND
780: l_deli_type_code = 'MEDIA') THEN
781: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
782: FND_MESSAGE.Set_name('JTF','JTF_AMV_DISPLAY_RUL_NULL');
783: FND_MSG_PUB.Add;
784: END IF;
785: RAISE FND_API.G_EXC_ERROR;
786: END IF;
841: AND object_version_number = l_act_attachment_rec.object_version_number;
842:
843: IF (SQL%NOTFOUND) THEN
844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
845: FND_MESSAGE.set_name('AMS', 'JTF_AMV_API_RECORD_NOT_FOUND');
846: FND_MSG_PUB.add;
847: END IF;
848: RAISE FND_API.g_exc_error;
849: END IF;
955: FETCH c_act_attachment INTO l_act_attachment_id;
956: IF (c_act_attachment%NOTFOUND) THEN
957: CLOSE c_act_attachment;
958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('AMS', 'JTF_AMV_API_RECORD_NOT_FOUND');
960: FND_MSG_PUB.add;
961: END IF;
962: RAISE FND_API.g_exc_error;
963: END IF;
1290: FETCH c_act_attachment INTO l_act_attachment_rec;
1291: IF c_act_attachment%NOTFOUND THEN
1292: CLOSE c_act_attachment;
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1294: FND_MESSAGE.set_name('JTF', 'JTF_AMV_API_RECORD_NOT_FOUND');
1295: FND_MSG_PUB.add;
1296: END IF;
1297: RAISE FND_API.g_exc_error;
1298: END IF;