[Home] [Help]
275: x_quantity => l_quantity,
276: x_from_number => l_from_number,
277: x_to_number => l_to_number,
278: x_errorcode => l_errorcode)) THEN
279: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SER');
280: FND_MSG_PUB.ADD;
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283: END IF;
286: -- inputted p_tag_quantity equals the amount of items in the serial
287: -- range. Do this check only if a range of serials is submitted
288: IF (p_from_serial_number <> p_to_serial_number) THEN
289: IF (p_tag_quantity <> l_quantity) THEN
290: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_X_QTY');
291: FND_MSG_PUB.ADD;
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: END IF;
490: ELSE
491: -- Dynamic tag entries are not allowed
492: -- This shouldn't happen if the mobile form's LOV
493: -- statements are correctly set
494: FND_MESSAGE.SET_NAME('INV','INV_NO_DYNAMIC_TAGS');
495: FND_MSG_PUB.ADD;
496: --RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: END IF;
641: ELSE
642: -- Dynamic tag entries are not allowed
643: -- This shouldn't happen if the mobile form's LOV
644: -- statements are correctly set
645: FND_MESSAGE.SET_NAME('INV','INV_NO_DYNAMIC_TAGS');
646: FND_MSG_PUB.ADD;
647: --RAISE FND_API.G_EXC_ERROR;
648: END IF;
649: END IF;
778: from_name => NULL,
779: to_name => NULL);
780: -- Conversion will return -99999 if unsuccessful so need to check for this
781: IF (l_tag_qty_at_standard_uom = -99999) THEN
782: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONVERSION');
783: FND_MSG_PUB.ADD;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786:
827: AND mec.employee_id = fus.employee_id
828: AND mec.organization_id = p_organization_id;
829: EXCEPTION
830: WHEN OTHERS THEN
831: FND_MESSAGE.SET_NAME('INV', 'INV_EMP');
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834: END;
835:
960: from_name => NULL,
961: to_name => NULL);
962: -- Conversion will return -99999 if unsuccessful so need to check for this
963: IF (l_tag_qty_at_standard_uom = -99999) THEN
964: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_CONVERSION');
965: FND_MSG_PUB.ADD;
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;
968:
1009: AND mec.employee_id = fus.employee_id
1010: AND mec.organization_id = p_organization_id;
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: FND_MESSAGE.SET_NAME('INV', 'INV_EMP');
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END;
1017:
1178: WHEN OTHERS THEN
1179: IF (l_debug = 1) THEN
1180: print_debug('Error while calling label printing API');
1181: END IF;
1182: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
1183: FND_MSG_PUB.ADD;
1184: END;
1185: IF (l_debug = 1) THEN
1186: print_debug('After calling label printing API: ' || l_return_status || ', ' || l_label_status || ', ' || l_msg_data);
1186: print_debug('After calling label printing API: ' || l_return_status || ', ' || l_label_status || ', ' || l_msg_data);
1187: END IF;
1188:
1189: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1190: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
1191: FND_MSG_PUB.ADD;
1192: END IF;
1193:
1194: END IF;
1304: and physical_inventory_id = p_physical_inventory_id;
1305:
1306: if (nvl(l_approval_status,0) = 3) then
1307: print_debug('Error: The corresponding adjustment_id '||l_adj_id||' is already posted');
1308: fnd_message.set_name('INV','INV_PHYSICAL_ADJ_POSTED');
1309: fnd_message.set_token('TOKEN1', l_adj_id);
1310: fnd_msg_pub.add;
1311: raise fnd_api.g_exc_error;
1312: end if;
1305:
1306: if (nvl(l_approval_status,0) = 3) then
1307: print_debug('Error: The corresponding adjustment_id '||l_adj_id||' is already posted');
1308: fnd_message.set_name('INV','INV_PHYSICAL_ADJ_POSTED');
1309: fnd_message.set_token('TOKEN1', l_adj_id);
1310: fnd_msg_pub.add;
1311: raise fnd_api.g_exc_error;
1312: end if;
1313: END IF;