eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_QUANTITY_PUB dependencies on FND_MESSAGE

Line 132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');

128: );
129:
130: IF l_user_id = 0
131: THEN
132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;

Line 133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);

129:
130: IF l_user_id = 0
131: THEN
132: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
133: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
134: FND_MSG_PUB.Add;
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137:

Line 186: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');

182: -- Get the surrogate key (journal_id) for the journal
183: SELECT gem5_journal_id_s.nextval INTO l_journal_id FROM dual;
184: IF (l_journal_id <=0)
185: THEN
186: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
187: FND_MESSAGE.SET_TOKEN('SKEY','journal_id');
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;

Line 187: FND_MESSAGE.SET_TOKEN('SKEY','journal_id');

183: SELECT gem5_journal_id_s.nextval INTO l_journal_id FROM dual;
184: IF (l_journal_id <=0)
185: THEN
186: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
187: FND_MESSAGE.SET_TOKEN('SKEY','journal_id');
188: FND_MSG_PUB.Add;
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:

Line 225: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');

221: -- First get the surrogate key (doc_id) for the transaction.
222: SELECT gem5_doc_id_s.nextval INTO l_doc_id FROM dual;
223: IF (l_doc_id <=0)
224: THEN
225: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
226: FND_MESSAGE.SET_TOKEN('SKEY','doc_id');
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;

Line 226: FND_MESSAGE.SET_TOKEN('SKEY','doc_id');

222: SELECT gem5_doc_id_s.nextval INTO l_doc_id FROM dual;
223: IF (l_doc_id <=0)
224: THEN
225: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
226: FND_MESSAGE.SET_TOKEN('SKEY','doc_id');
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230:

Line 254: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');

250: THEN
251: SELECT gem5_line_id_s.nextval INTO l_line_id FROM dual;
252: IF (l_line_id <=0)
253: THEN
254: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
255: FND_MESSAGE.SET_TOKEN('SKEY','line_id');
256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;

Line 255: FND_MESSAGE.SET_TOKEN('SKEY','line_id');

251: SELECT gem5_line_id_s.nextval INTO l_line_id FROM dual;
252: IF (l_line_id <=0)
253: THEN
254: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
255: FND_MESSAGE.SET_TOKEN('SKEY','line_id');
256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259: END IF;

Line 392: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');

388: END IF;
389: -- Success message
390: IF (l_trans_rec.trans_type = 1)
391: THEN
392: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');
393: ELSIF (l_trans_rec.trans_type = 2)
394: THEN
395: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
396: ELSIF (l_trans_rec.trans_type = 3)

Line 395: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');

391: THEN
392: FND_MESSAGE.SET_NAME('GMI','IC_API_CRE_TRAN_POSTED');
393: ELSIF (l_trans_rec.trans_type = 2)
394: THEN
395: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
396: ELSIF (l_trans_rec.trans_type = 3)
397: THEN
398: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
399: ELSIF (l_trans_rec.trans_type = 4)

Line 398: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');

394: THEN
395: FND_MESSAGE.SET_NAME('GMI','IC_API_ADJ_TRAN_POSTED');
396: ELSIF (l_trans_rec.trans_type = 3)
397: THEN
398: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
399: ELSIF (l_trans_rec.trans_type = 4)
400: THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
402: ELSIF (l_trans_rec.trans_type = 5)

Line 401: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');

397: THEN
398: FND_MESSAGE.SET_NAME('GMI','IC_API_TRN_TRAN_POSTED');
399: ELSIF (l_trans_rec.trans_type = 4)
400: THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
402: ELSIF (l_trans_rec.trans_type = 5)
403: THEN
404: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
405: END IF;

Line 404: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');

400: THEN
401: FND_MESSAGE.SET_NAME('GMI','IC_API_STS_TRAN_POSTED');
402: ELSIF (l_trans_rec.trans_type = 5)
403: THEN
404: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
405: END IF;
406:
407: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_trans_rec.item_no);
408: FND_MESSAGE.SET_TOKEN('LOT_NO',p_trans_rec.lot_no);

Line 407: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_trans_rec.item_no);

403: THEN
404: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
405: END IF;
406:
407: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_trans_rec.item_no);
408: FND_MESSAGE.SET_TOKEN('LOT_NO',p_trans_rec.lot_no);
409: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_trans_rec.sublot_no);
410: FND_MSG_PUB.Add;
411: -- Standard Call to get message count and if count is 1,

Line 408: FND_MESSAGE.SET_TOKEN('LOT_NO',p_trans_rec.lot_no);

404: FND_MESSAGE.SET_NAME('GMI','IC_API_GRD_TRAN_POSTED');
405: END IF;
406:
407: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_trans_rec.item_no);
408: FND_MESSAGE.SET_TOKEN('LOT_NO',p_trans_rec.lot_no);
409: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_trans_rec.sublot_no);
410: FND_MSG_PUB.Add;
411: -- Standard Call to get message count and if count is 1,
412: -- get message info.

Line 409: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_trans_rec.sublot_no);

405: END IF;
406:
407: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_trans_rec.item_no);
408: FND_MESSAGE.SET_TOKEN('LOT_NO',p_trans_rec.lot_no);
409: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',p_trans_rec.sublot_no);
410: FND_MSG_PUB.Add;
411: -- Standard Call to get message count and if count is 1,
412: -- get message info.
413: