DBA Data[Home] [Help]

APPS.GML_AUTO_ALLOC dependencies on FND_MESSAGE

Line 142: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

138: RAISE INVALID_ALLOCATION_MODE;
139: END IF;
140: EXCEPTION
141: WHEN UOM_CONVERSION_ERROR THEN
142: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
143: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_order_um1);
144: FND_MESSAGE.SET_TOKEN('TO_UOM', ItemDetailsRec.item_um);
145: FND_MESSAGE.SET_TOKEN('ITEM_NO', ItemDetailsRec.item_no);
146: FND_MSG_PUB.ADD;

Line 143: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_order_um1);

139: END IF;
140: EXCEPTION
141: WHEN UOM_CONVERSION_ERROR THEN
142: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
143: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_order_um1);
144: FND_MESSAGE.SET_TOKEN('TO_UOM', ItemDetailsRec.item_um);
145: FND_MESSAGE.SET_TOKEN('ITEM_NO', ItemDetailsRec.item_no);
146: FND_MSG_PUB.ADD;
147: RETURN(-1);

Line 144: FND_MESSAGE.SET_TOKEN('TO_UOM', ItemDetailsRec.item_um);

140: EXCEPTION
141: WHEN UOM_CONVERSION_ERROR THEN
142: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
143: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_order_um1);
144: FND_MESSAGE.SET_TOKEN('TO_UOM', ItemDetailsRec.item_um);
145: FND_MESSAGE.SET_TOKEN('ITEM_NO', ItemDetailsRec.item_no);
146: FND_MSG_PUB.ADD;
147: RETURN(-1);
148: WHEN ITEM_NOT_FOUND THEN

Line 145: FND_MESSAGE.SET_TOKEN('ITEM_NO', ItemDetailsRec.item_no);

141: WHEN UOM_CONVERSION_ERROR THEN
142: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
143: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_order_um1);
144: FND_MESSAGE.SET_TOKEN('TO_UOM', ItemDetailsRec.item_um);
145: FND_MESSAGE.SET_TOKEN('ITEM_NO', ItemDetailsRec.item_no);
146: FND_MSG_PUB.ADD;
147: RETURN(-1);
148: WHEN ITEM_NOT_FOUND THEN
149: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_ITEM_NO');

Line 149: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_ITEM_NO');

145: FND_MESSAGE.SET_TOKEN('ITEM_NO', ItemDetailsRec.item_no);
146: FND_MSG_PUB.ADD;
147: RETURN(-1);
148: WHEN ITEM_NOT_FOUND THEN
149: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_ITEM_NO');
150: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
151: FND_MSG_PUB.ADD;
152: RETURN(-1);
153: WHEN WHSE_NOT_FOUND THEN

Line 150: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);

146: FND_MSG_PUB.ADD;
147: RETURN(-1);
148: WHEN ITEM_NOT_FOUND THEN
149: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_ITEM_NO');
150: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
151: FND_MSG_PUB.ADD;
152: RETURN(-1);
153: WHEN WHSE_NOT_FOUND THEN
154: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_WHSE_CODE');

Line 154: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_WHSE_CODE');

150: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
151: FND_MSG_PUB.ADD;
152: RETURN(-1);
153: WHEN WHSE_NOT_FOUND THEN
154: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_WHSE_CODE');
155: FND_MESSAGE.SET_TOKEN('WHSE_CODE', V_whse_code);
156: FND_MSG_PUB.ADD;
157: RETURN(-1);
158: WHEN ITEM_WHSE_NOT_LOT_LOCT THEN

Line 155: FND_MESSAGE.SET_TOKEN('WHSE_CODE', V_whse_code);

151: FND_MSG_PUB.ADD;
152: RETURN(-1);
153: WHEN WHSE_NOT_FOUND THEN
154: FND_MESSAGE.SET_NAME('GMI', 'IC_API_INVALID_WHSE_CODE');
155: FND_MESSAGE.SET_TOKEN('WHSE_CODE', V_whse_code);
156: FND_MSG_PUB.ADD;
157: RETURN(-1);
158: WHEN ITEM_WHSE_NOT_LOT_LOCT THEN
159: FND_MESSAGE.SET_NAME('GML', 'OP_NOTLOT_LOCT');

Line 159: FND_MESSAGE.SET_NAME('GML', 'OP_NOTLOT_LOCT');

155: FND_MESSAGE.SET_TOKEN('WHSE_CODE', V_whse_code);
156: FND_MSG_PUB.ADD;
157: RETURN(-1);
158: WHEN ITEM_WHSE_NOT_LOT_LOCT THEN
159: FND_MESSAGE.SET_NAME('GML', 'OP_NOTLOT_LOCT');
160: FND_MSG_PUB.ADD;
161: RETURN(-1);
162: WHEN ITEM_ALLOCATION_EXISTS THEN
163: FND_MESSAGE.SET_NAME('GML', 'OP_SHIPQTYALLOCUSESUMMARY');

Line 163: FND_MESSAGE.SET_NAME('GML', 'OP_SHIPQTYALLOCUSESUMMARY');

159: FND_MESSAGE.SET_NAME('GML', 'OP_NOTLOT_LOCT');
160: FND_MSG_PUB.ADD;
161: RETURN(-1);
162: WHEN ITEM_ALLOCATION_EXISTS THEN
163: FND_MESSAGE.SET_NAME('GML', 'OP_SHIPQTYALLOCUSESUMMARY');
164: FND_MSG_PUB.ADD;
165: RETURN(-1);
166: WHEN INVALID_ALLOCATION_MODE THEN
167: FND_MESSAGE.SET_NAME('GMI', 'IC_INVALIDMODE');

Line 167: FND_MESSAGE.SET_NAME('GMI', 'IC_INVALIDMODE');

163: FND_MESSAGE.SET_NAME('GML', 'OP_SHIPQTYALLOCUSESUMMARY');
164: FND_MSG_PUB.ADD;
165: RETURN(-1);
166: WHEN INVALID_ALLOCATION_MODE THEN
167: FND_MESSAGE.SET_NAME('GMI', 'IC_INVALIDMODE');
168: FND_MSG_PUB.ADD;
169: RETURN(-1);
170: WHEN ITEM_MISSING_ALLOCATION_CLASS THEN
171: FND_MESSAGE.SET_NAME('GMI', 'IC_INV_ALLOC_CLASS');

Line 171: FND_MESSAGE.SET_NAME('GMI', 'IC_INV_ALLOC_CLASS');

167: FND_MESSAGE.SET_NAME('GMI', 'IC_INVALIDMODE');
168: FND_MSG_PUB.ADD;
169: RETURN(-1);
170: WHEN ITEM_MISSING_ALLOCATION_CLASS THEN
171: FND_MESSAGE.SET_NAME('GMI', 'IC_INV_ALLOC_CLASS');
172: FND_MSG_PUB.ADD;
173: RETURN(-1);
174: WHEN OTHERS THEN
175: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');

Line 175: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');

171: FND_MESSAGE.SET_NAME('GMI', 'IC_INV_ALLOC_CLASS');
172: FND_MSG_PUB.ADD;
173: RETURN(-1);
174: WHEN OTHERS THEN
175: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
177: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
178: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'GET_AVAILABLE_LOTS');
179: FND_MSG_PUB.ADD;

Line 176: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);

172: FND_MSG_PUB.ADD;
173: RETURN(-1);
174: WHEN OTHERS THEN
175: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
177: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
178: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'GET_AVAILABLE_LOTS');
179: FND_MSG_PUB.ADD;
180: RETURN (-1);

Line 177: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');

173: RETURN(-1);
174: WHEN OTHERS THEN
175: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
177: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
178: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'GET_AVAILABLE_LOTS');
179: FND_MSG_PUB.ADD;
180: RETURN (-1);
181: END Get_Available_Lots;

Line 178: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'GET_AVAILABLE_LOTS');

174: WHEN OTHERS THEN
175: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
177: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
178: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'GET_AVAILABLE_LOTS');
179: FND_MSG_PUB.ADD;
180: RETURN (-1);
181: END Get_Available_Lots;
182:

Line 343: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');

339: RETURN(X_full_alloc);
340: END IF;
341: EXCEPTION
342: WHEN UOM_CONVERSION_ERROR THEN
343: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
344: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_item_um);
345: FND_MESSAGE.SET_TOKEN('TO_UOM', V_order_um1);
346: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
347: FND_MSG_PUB.ADD;

Line 344: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_item_um);

340: END IF;
341: EXCEPTION
342: WHEN UOM_CONVERSION_ERROR THEN
343: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
344: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_item_um);
345: FND_MESSAGE.SET_TOKEN('TO_UOM', V_order_um1);
346: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
347: FND_MSG_PUB.ADD;
348: RETURN(-1);

Line 345: FND_MESSAGE.SET_TOKEN('TO_UOM', V_order_um1);

341: EXCEPTION
342: WHEN UOM_CONVERSION_ERROR THEN
343: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
344: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_item_um);
345: FND_MESSAGE.SET_TOKEN('TO_UOM', V_order_um1);
346: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
347: FND_MSG_PUB.ADD;
348: RETURN(-1);
349: WHEN OTHERS THEN

Line 346: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);

342: WHEN UOM_CONVERSION_ERROR THEN
343: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
344: FND_MESSAGE.SET_TOKEN('FROM_UOM', V_item_um);
345: FND_MESSAGE.SET_TOKEN('TO_UOM', V_order_um1);
346: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
347: FND_MSG_PUB.ADD;
348: RETURN(-1);
349: WHEN OTHERS THEN
350: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');

Line 350: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');

346: FND_MESSAGE.SET_TOKEN('ITEM_NO', V_item_id);
347: FND_MSG_PUB.ADD;
348: RETURN(-1);
349: WHEN OTHERS THEN
350: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
351: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
352: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
353: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'FETCH_LOTS');
354: FND_MSG_PUB.ADD;

Line 351: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);

347: FND_MSG_PUB.ADD;
348: RETURN(-1);
349: WHEN OTHERS THEN
350: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
351: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
352: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
353: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'FETCH_LOTS');
354: FND_MSG_PUB.ADD;
355: RETURN (-1);

Line 352: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');

348: RETURN(-1);
349: WHEN OTHERS THEN
350: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
351: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
352: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
353: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'FETCH_LOTS');
354: FND_MSG_PUB.ADD;
355: RETURN (-1);
356: END fetch_lots;

Line 353: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'FETCH_LOTS');

349: WHEN OTHERS THEN
350: FND_MESSAGE.SET_NAME('GMI', 'IC_AS_UNEXPECTED_ERROR');
351: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', sqlerrm);
352: FND_MESSAGE.SET_TOKEN('PKG_NAME', 'GML_AUTO_ALLOC');
353: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME', 'FETCH_LOTS');
354: FND_MSG_PUB.ADD;
355: RETURN (-1);
356: END fetch_lots;
357: