DBA Data[Home] [Help]

APPS.GMI_PURGE_EMPTY_BAL_PKG dependencies on FND_MESSAGE

Line 191: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_PURGE_LOG');

187:
188: IF (l_loct_onhand = 0) THEN
189: l_zero_count := l_zero_count + 1;
190: END IF;
191: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_PURGE_LOG');
192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);

Line 192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);

188: IF (l_loct_onhand = 0) THEN
189: l_zero_count := l_zero_count + 1;
190: END IF;
191: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_PURGE_LOG');
192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);
196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));

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

189: l_zero_count := l_zero_count + 1;
190: END IF;
191: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_PURGE_LOG');
192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);
196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));
197: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

Line 194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);

190: END IF;
191: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_PURGE_LOG');
192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);
196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));
197: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
198: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

Line 195: FND_MESSAGE.SET_TOKEN('LOC',l_location);

191: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_PURGE_LOG');
192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);
196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));
197: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
198: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
199: END IF;

Line 196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));

192: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_no);
193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);
196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));
197: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
198: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
199: END IF;
200: END;

Line 197: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

193: FND_MESSAGE.SET_TOKEN('LOT_NO',l_lot_no);
194: FND_MESSAGE.SET_TOKEN('WHSE',l_whse_code);
195: FND_MESSAGE.SET_TOKEN('LOC',l_location);
196: FND_MESSAGE.SET_TOKEN('QTY',to_char(l_loct_onhand));
197: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
198: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
199: END IF;
200: END;
201: END LOOP;

Line 223: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_INVALID_ARG');

219: /******** 3377672 Purge Empty Balances Enhancment - End********/
220:
221: EXCEPTION
222: WHEN invalid_arguments THEN
223: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_INVALID_ARG');
224: FND_MESSAGE.SET_TOKEN('C',to_char(p_criteria_id));
225: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
226: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
227: WHEN OTHERS THEN

Line 224: FND_MESSAGE.SET_TOKEN('C',to_char(p_criteria_id));

220:
221: EXCEPTION
222: WHEN invalid_arguments THEN
223: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_INVALID_ARG');
224: FND_MESSAGE.SET_TOKEN('C',to_char(p_criteria_id));
225: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
226: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
227: WHEN OTHERS THEN
228: FND_FILE.PUT(FND_FILE.LOG,SQLERRM);

Line 225: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

221: EXCEPTION
222: WHEN invalid_arguments THEN
223: FND_MESSAGE.SET_NAME('GMI','GMI_CONC_REQUEST_INVALID_ARG');
224: FND_MESSAGE.SET_TOKEN('C',to_char(p_criteria_id));
225: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
226: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
227: WHEN OTHERS THEN
228: FND_FILE.PUT(FND_FILE.LOG,SQLERRM);
229: FND_FILE.NEW_LINE(FND_FILE.LOG,1);