DBA Data[Home] [Help]

APPS.GMIUTILS dependencies on FND_MESSAGE

Line 72: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');

68:
69: WHEN OTHERS THEN
70: ROLLBACK to get_doc_no;
71: IF (SQLCODE IS NOT NULL) THEN
72: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
73: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
74: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
75: FND_MSG_PUB.Add;
76: END IF;

Line 73: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);

69: WHEN OTHERS THEN
70: ROLLBACK to get_doc_no;
71: IF (SQLCODE IS NOT NULL) THEN
72: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
73: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
74: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
75: FND_MSG_PUB.Add;
76: END IF;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 74: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);

70: ROLLBACK to get_doc_no;
71: IF (SQLCODE IS NOT NULL) THEN
72: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
73: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
74: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
75: FND_MSG_PUB.Add;
76: END IF;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.Count_AND_GET

Line 233: FND_MESSAGE.SET_NAME('GMI','IC_INVQTYNEG');

229:
230: /* If transaction causes inventory to go negative in
231: either primary or secondary qty, then report error */
232: IF ( (l_onhand + p_qty) < 0 OR (l_onhand2 + p_qty2) < 0 )THEN
233: FND_MESSAGE.SET_NAME('GMI','IC_INVQTYNEG');
234: FND_MSG_PUB.Add;
235: RETURN FALSE;
236: END IF;
237: END IF;

Line 371: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');

367: OPEN get_lot_no(l_loct_inv_rec.lot_id);
368: FETCH get_lot_no INTO l_lot_no,l_sublot_no;
369: CLOSE get_lot_no;
370:
371: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
372: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_mst_rec.item_no);
373: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
374: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_sublot_no);
375: FND_MSG_PUB.Add;

Line 372: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_mst_rec.item_no);

368: FETCH get_lot_no INTO l_lot_no,l_sublot_no;
369: CLOSE get_lot_no;
370:
371: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
372: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_mst_rec.item_no);
373: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
374: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_sublot_no);
375: FND_MSG_PUB.Add;
376: RETURN FALSE;

Line 373: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);

369: CLOSE get_lot_no;
370:
371: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
372: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_mst_rec.item_no);
373: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
374: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_sublot_no);
375: FND_MSG_PUB.Add;
376: RETURN FALSE;
377: END IF;

Line 374: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_sublot_no);

370:
371: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
372: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_mst_rec.item_no);
373: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
374: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_sublot_no);
375: FND_MSG_PUB.Add;
376: RETURN FALSE;
377: END IF;
378: END IF; /* end of move diff sts check */

Line 424: FND_MESSAGE.SET_NAME('GMI','IC_INVLOTSTST');

420:
421: /* If the lot status is not valid for the document type
422: of the transaction, then report error */
423: IF NOT l_valid_sts_doc THEN
424: FND_MESSAGE.SET_NAME('GMI','IC_INVLOTSTST');
425: FND_MSG_PUB.Add;
426: RETURN FALSE;
427: END IF;
428: END IF;