222: --
223: -- start added for bug #1657510
224: --
225: when l_order_exception then
226: fnd_message.set_name('OTA', 'OTA_TDB_CANCEL_LINE_FAILED');
227: fnd_message.set_token('OM_ERR_MSG',l_message_data);
228: fnd_message.raise_error;
229: --
230: -- end added for bug #1657510
223: -- start added for bug #1657510
224: --
225: when l_order_exception then
226: fnd_message.set_name('OTA', 'OTA_TDB_CANCEL_LINE_FAILED');
227: fnd_message.set_token('OM_ERR_MSG',l_message_data);
228: fnd_message.raise_error;
229: --
230: -- end added for bug #1657510
231: --
224: --
225: when l_order_exception then
226: fnd_message.set_name('OTA', 'OTA_TDB_CANCEL_LINE_FAILED');
227: fnd_message.set_token('OM_ERR_MSG',l_message_data);
228: fnd_message.raise_error;
229: --
230: -- end added for bug #1657510
231: --
232:
633: --
634: -- start added for bug #1657510
635: --
636: when l_order_exception then
637: fnd_message.set_name('OTA', 'OTA_TDB_CREATE_RMA_FAILED');
638: fnd_message.set_token('OM_ERR_MSG',l_message_data);
639: fnd_message.raise_error;
640: --
641: -- end added for bug #1657510
634: -- start added for bug #1657510
635: --
636: when l_order_exception then
637: fnd_message.set_name('OTA', 'OTA_TDB_CREATE_RMA_FAILED');
638: fnd_message.set_token('OM_ERR_MSG',l_message_data);
639: fnd_message.raise_error;
640: --
641: -- end added for bug #1657510
642: --
635: --
636: when l_order_exception then
637: fnd_message.set_name('OTA', 'OTA_TDB_CREATE_RMA_FAILED');
638: fnd_message.set_token('OM_ERR_MSG',l_message_data);
639: fnd_message.raise_error;
640: --
641: -- end added for bug #1657510
642: --
643: when others then
963: );
964:
965: if l_msg_count > 0 then
966: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
967: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR_MSG');
968: FND_MSG_PUB.ADD;
969: END IF;
970: end if;
971:
974: p_encoded => 'F'
975: );
976:
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR');
979: FND_MESSAGE.Set_Token('MSG_TXT', x_msg_data, FALSE);
980: FND_MSG_PUB.ADD;
981:
982: p_msg_data := x_msg_data;
975: );
976:
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('OTA', 'OTA_OM_ERROR');
979: FND_MESSAGE.Set_Token('MSG_TXT', x_msg_data, FALSE);
980: FND_MSG_PUB.ADD;
981:
982: p_msg_data := x_msg_data;
983: END IF;
1244: -- * Check line Id
1245:
1246: x_return_status :='F';
1247: IF p_line_id is null then
1248: FND_MESSAGE.set_name ('OTA', 'OTA_13901_TDB_NO_LINE_ID');
1249: -- FND_MESSAGE.error;
1250: fnd_message.raise_error;
1251: END IF;
1252: -- ***
1245:
1246: x_return_status :='F';
1247: IF p_line_id is null then
1248: FND_MESSAGE.set_name ('OTA', 'OTA_13901_TDB_NO_LINE_ID');
1249: -- FND_MESSAGE.error;
1250: fnd_message.raise_error;
1251: END IF;
1252: -- ***
1253:
1246: x_return_status :='F';
1247: IF p_line_id is null then
1248: FND_MESSAGE.set_name ('OTA', 'OTA_13901_TDB_NO_LINE_ID');
1249: -- FND_MESSAGE.error;
1250: fnd_message.raise_error;
1251: END IF;
1252: -- ***
1253:
1254: IF P_SOLD_TO_ORG_ID is null or
1252: -- ***
1253:
1254: IF P_SOLD_TO_ORG_ID is null or
1255: (P_SOLD_TO_CONTACT_ID is null and P_SHIP_TO_CONTACT_ID is null) then
1256: FND_MESSAGE.set_name ('OTA', 'OTA_13903_TDB_OM_MISS_PAR_VAL');
1257: -- FND_MESSAGE.error;
1258: fnd_message.raise_error;
1259: END IF;
1260: IF l_single_business_group_id is not null then
1253:
1254: IF P_SOLD_TO_ORG_ID is null or
1255: (P_SOLD_TO_CONTACT_ID is null and P_SHIP_TO_CONTACT_ID is null) then
1256: FND_MESSAGE.set_name ('OTA', 'OTA_13903_TDB_OM_MISS_PAR_VAL');
1257: -- FND_MESSAGE.error;
1258: fnd_message.raise_error;
1259: END IF;
1260: IF l_single_business_group_id is not null then
1261: l_business_group_id := l_single_business_group_id;
1254: IF P_SOLD_TO_ORG_ID is null or
1255: (P_SOLD_TO_CONTACT_ID is null and P_SHIP_TO_CONTACT_ID is null) then
1256: FND_MESSAGE.set_name ('OTA', 'OTA_13903_TDB_OM_MISS_PAR_VAL');
1257: -- FND_MESSAGE.error;
1258: fnd_message.raise_error;
1259: END IF;
1260: IF l_single_business_group_id is not null then
1261: l_business_group_id := l_single_business_group_id;
1262: ELSE
1303: -- ***
1304: IF ota_tdb_bus.Booking_status_type(l_booking_status_type_id) = 'W' then
1305: l_booking_priority := fnd_profile.value('OTA_WAITLIST_PRIORITY');
1306: if l_booking_priority is null then
1307: FND_MESSAGE.set_name ('OTA', 'OTA_13902_TDB_OM_NO_PROFILE');
1308:
1309: fnd_message.raise_error;
1310: end if;
1311:
1305: l_booking_priority := fnd_profile.value('OTA_WAITLIST_PRIORITY');
1306: if l_booking_priority is null then
1307: FND_MESSAGE.set_name ('OTA', 'OTA_13902_TDB_OM_NO_PROFILE');
1308:
1309: fnd_message.raise_error;
1310: end if;
1311:
1312: END IF;
1313: