DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on FND_API

Line 281: RAISE FND_API.G_EXC_ERROR;

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;
284:
285: -- Check that in the case of a range of serial numbers, that the

Line 292: RAISE FND_API.G_EXC_ERROR;

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;
295:
296: -- Get the serial number length.

Line 496: --RAISE FND_API.G_EXC_ERROR;

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;
499: CLOSE tag_entry;
500:

Line 647: --RAISE FND_API.G_EXC_ERROR;

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;
650: END IF;
651:

Line 784: RAISE FND_API.G_EXC_ERROR;

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:
787: -- Get the outermost LPN ID for this record if necessary
788: IF (p_parent_lpn_id IS NOT NULL) THEN

Line 810: RAISE FND_API.G_EXC_ERROR;

806: WHEN OTHERS THEN
807: IF (l_debug = 1) THEN
808: print_debug('Unable to fetch outermost LPN for LPN ID: ' || p_parent_lpn_id);
809: END IF;
810: RAISE FND_API.G_EXC_ERROR;
811: END;
812: --Bug2935754 ends
813:
814: IF (l_debug = 1) THEN

Line 833: RAISE FND_API.G_EXC_ERROR;

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:
836: print_debug('the employee id is: ' || l_employee_id);
837:

Line 905: WHEN fnd_api.g_exc_error THEN

901: --INVCONV, NSRIVAST, END
902: );
903:
904: EXCEPTION
905: WHEN fnd_api.g_exc_error THEN
906: raise fnd_api.g_exc_error;
907: WHEN OTHERS THEN
908: print_debug(SQLERRM);
909: raise fnd_api.g_exc_unexpected_error;

Line 906: raise fnd_api.g_exc_error;

902: );
903:
904: EXCEPTION
905: WHEN fnd_api.g_exc_error THEN
906: raise fnd_api.g_exc_error;
907: WHEN OTHERS THEN
908: print_debug(SQLERRM);
909: raise fnd_api.g_exc_unexpected_error;
910:

Line 909: raise fnd_api.g_exc_unexpected_error;

905: WHEN fnd_api.g_exc_error THEN
906: raise fnd_api.g_exc_error;
907: WHEN OTHERS THEN
908: print_debug(SQLERRM);
909: raise fnd_api.g_exc_unexpected_error;
910:
911: END insert_row;
912:
913:

Line 966: RAISE FND_API.G_EXC_ERROR;

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:
969: -- Get the outermost LPN ID for this record if necessary
970: IF (p_parent_lpn_id IS NOT NULL) THEN

Line 992: RAISE FND_API.G_EXC_ERROR;

988: WHEN OTHERS THEN
989: IF (l_debug = 1) THEN
990: print_debug('Unable to fetch outermost LPN for LPN ID: ' || p_parent_lpn_id);
991: END IF;
992: RAISE FND_API.G_EXC_ERROR;
993: END;
994: --Bug2935754 ends
995:
996: IF (l_debug = 1) THEN

Line 1015: RAISE FND_API.G_EXC_ERROR;

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:
1018: print_debug('the employee id is: ' || l_employee_id);
1019:

Line 1189: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1185: IF (l_debug = 1) THEN
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:

Line 1311: raise fnd_api.g_exc_error;

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;
1314:
1315:

Line 1377: RAISE FND_API.G_EXC_ERROR;

1373: WHEN OTHERS THEN
1374: IF (l_debug = 1) THEN
1375: print_debug('Unable to fetch outermost LPN for LPN ID: ' || p_parent_lpn_id);
1376: END IF;
1377: RAISE FND_API.G_EXC_ERROR;
1378: END;
1379: --Bug2935754 ends
1380:
1381: IF (l_debug = 1) THEN