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.GMD_FORMULA_ANALYSIS dependencies on FND_FILE

Line 214: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);

210: COMMIT WORK;
211: EXCEPTION
212: WHEN NO_ORGN_CODE THEN
213: FND_MESSAGE.SET_NAME('GMI', 'IC_ORGNCODERR');
214: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);
215: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
216: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
217: NULL;
218: END IF;

Line 215: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

211: EXCEPTION
212: WHEN NO_ORGN_CODE THEN
213: FND_MESSAGE.SET_NAME('GMI', 'IC_ORGNCODERR');
214: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);
215: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
216: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
217: NULL;
218: END IF;
219: WHEN NO_FORMULA THEN

Line 221: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);

217: NULL;
218: END IF;
219: WHEN NO_FORMULA THEN
220: FND_MESSAGE.SET_NAME('GMD', 'QC_INVALID_FORMULA');
221: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);
222: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
223: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
224: NULL;
225: END IF;

Line 222: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

218: END IF;
219: WHEN NO_FORMULA THEN
220: FND_MESSAGE.SET_NAME('GMD', 'QC_INVALID_FORMULA');
221: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);
222: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
223: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
224: NULL;
225: END IF;
226: WHEN BAD_SYS_UOM THEN

Line 228: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);

224: NULL;
225: END IF;
226: WHEN BAD_SYS_UOM THEN
227: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_SYSTEM_UOMS');
228: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);
229: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
230: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
231: NULL;
232: END IF;

Line 229: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

225: END IF;
226: WHEN BAD_SYS_UOM THEN
227: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_SYSTEM_UOMS');
228: FND_FILE.PUT(FND_FILE.LOG, P_error||FND_MESSAGE.GET);
229: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
230: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
231: NULL;
232: END IF;
233: WHEN LOAD_DATA_ERR THEN

Line 234: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);

230: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
231: NULL;
232: END IF;
233: WHEN LOAD_DATA_ERR THEN
234: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
235: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
236: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
237: NULL;
238: END IF;

Line 235: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

231: NULL;
232: END IF;
233: WHEN LOAD_DATA_ERR THEN
234: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
235: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
236: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
237: NULL;
238: END IF;
239: WHEN LOAD_INGR_ERR THEN

Line 240: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);

236: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
237: NULL;
238: END IF;
239: WHEN LOAD_INGR_ERR THEN
240: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
241: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
242: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
243: NULL;
244: END IF;

Line 241: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

237: NULL;
238: END IF;
239: WHEN LOAD_INGR_ERR THEN
240: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
241: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
242: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
243: NULL;
244: END IF;
245: WHEN UOM_CONV_ERR THEN

Line 250: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);

246: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
247: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item);
248: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_um);
249: FND_MESSAGE.SET_TOKEN('TO_UOM', p_rep_um);
250: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
251: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
252: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
253: NULL;
254: END IF;

Line 251: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

247: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item);
248: FND_MESSAGE.SET_TOKEN('FROM_UOM', X_from_um);
249: FND_MESSAGE.SET_TOKEN('TO_UOM', p_rep_um);
250: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
251: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
252: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
253: NULL;
254: END IF;
255: WHEN OTHERS THEN

Line 258: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);

254: END IF;
255: WHEN OTHERS THEN
256: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
257: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
258: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
259: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
260: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
261: NULL;
262: END IF;

Line 259: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

255: WHEN OTHERS THEN
256: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
257: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
258: FND_FILE.PUT(FND_FILE.LOG, P_space||P_error||FND_MESSAGE.GET);
259: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
260: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', NULL)) THEN
261: NULL;
262: END IF;
263: END analyze_formula;

Line 607: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);

603: FND_MESSAGE.SET_NAME('GMD', 'GMD_CIRCULAR_REFERENCE');
604: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
605: FND_MESSAGE.SET_TOKEN('F1', X_cur_form_no);
606: FND_MESSAGE.SET_TOKEN('V1', TO_CHAR(X_cur_form_ver));
607: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
608: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
609: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
610: NULL;
611: END IF;

Line 608: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

604: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
605: FND_MESSAGE.SET_TOKEN('F1', X_cur_form_no);
606: FND_MESSAGE.SET_TOKEN('V1', TO_CHAR(X_cur_form_ver));
607: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
608: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
609: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
610: NULL;
611: END IF;
612: X_expl_fm_id := NULL;

Line 625: FND_FILE.PUT(FND_FILE.LOG, P_space||FND_MESSAGE.GET);

621: FND_MESSAGE.SET_TOKEN('F1', X_cur_form_no);
622: FND_MESSAGE.SET_TOKEN('V1', TO_CHAR(X_cur_form_ver));
623: FND_MESSAGE.SET_TOKEN('F2', X_formula_no);
624: FND_MESSAGE.SET_TOKEN('V2', TO_CHAR(X_formula_vers));
625: FND_FILE.PUT(FND_FILE.LOG, P_space||FND_MESSAGE.GET);
626: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
627: P_space := P_space ||' ';
628: END IF;
629: END IF;

Line 626: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

622: FND_MESSAGE.SET_TOKEN('V1', TO_CHAR(X_cur_form_ver));
623: FND_MESSAGE.SET_TOKEN('F2', X_formula_no);
624: FND_MESSAGE.SET_TOKEN('V2', TO_CHAR(X_formula_vers));
625: FND_FILE.PUT(FND_FILE.LOG, P_space||FND_MESSAGE.GET);
626: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
627: P_space := P_space ||' ';
628: END IF;
629: END IF;
630: X_found := 0;

Line 736: FND_FILE.PUT(FND_FILE.LOG, P_space||FND_MESSAGE.GET);

732: FND_MESSAGE.SET_NAME('GMD', 'GMD_LAST_LEVEL');
733: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
734: FND_MESSAGE.SET_TOKEN('F1', X_cur_form_no);
735: FND_MESSAGE.SET_TOKEN('V1', X_cur_form_ver);
736: FND_FILE.PUT(FND_FILE.LOG, P_space||FND_MESSAGE.GET);
737: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
738: EXCEPTION
739: WHEN LOAD_INGR_ERR THEN
740: x_return_status := 'E';

Line 737: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

733: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
734: FND_MESSAGE.SET_TOKEN('F1', X_cur_form_no);
735: FND_MESSAGE.SET_TOKEN('V1', X_cur_form_ver);
736: FND_FILE.PUT(FND_FILE.LOG, P_space||FND_MESSAGE.GET);
737: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
738: EXCEPTION
739: WHEN LOAD_INGR_ERR THEN
740: x_return_status := 'E';
741: WHEN LOAD_DATA_ERR THEN

Line 987: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);

983: CLOSE Cur_get_type;
984:
985: get_density(p_rec, p_organization_id, p_laboratory_id, P_density, X_density, X_status);
986: IF (X_status = 'W') THEN
987: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
988: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
989: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
990: NULL;
991: END IF;

Line 988: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

984:
985: get_density(p_rec, p_organization_id, p_laboratory_id, P_density, X_density, X_status);
986: IF (X_status = 'W') THEN
987: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
988: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
989: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
990: NULL;
991: END IF;
992: ELSIF (X_status <> 'S') THEN

Line 1031: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);

1027: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1028: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
1029: FND_MESSAGE.SET_TOKEN('FROM_UOM', P_mass_um);
1030: FND_MESSAGE.SET_TOKEN('TO_UOM', P_vol_um);
1031: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
1032: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1033: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
1034: NULL;
1035: END IF;

Line 1032: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1028: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
1029: FND_MESSAGE.SET_TOKEN('FROM_UOM', P_mass_um);
1030: FND_MESSAGE.SET_TOKEN('TO_UOM', P_vol_um);
1031: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
1032: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1033: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
1034: NULL;
1035: END IF;
1036: p_rec.vol_qty := 0;

Line 1079: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);

1075: FND_MESSAGE.SET_NAME('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1076: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
1077: FND_MESSAGE.SET_TOKEN('FROM_UOM', P_vol_um);
1078: FND_MESSAGE.SET_TOKEN('TO_UOM', P_mass_um);
1079: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
1080: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1081: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
1082: NULL;
1083: END IF;

Line 1080: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1076: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_rec.item_no);
1077: FND_MESSAGE.SET_TOKEN('FROM_UOM', P_vol_um);
1078: FND_MESSAGE.SET_TOKEN('TO_UOM', P_mass_um);
1079: FND_FILE.PUT(FND_FILE.LOG, P_space||P_warning||FND_MESSAGE.GET);
1080: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1081: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NULL)) THEN
1082: NULL;
1083: END IF;
1084: p_rec.mass_qty := 0;