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

Line 56: fnd_file.put_line(FND_FILE.LOG,'Shipping status check started.');

52: lb_completion_status BOOLEAN;
53:
54: BEGIN
55:
56: fnd_file.put_line(FND_FILE.LOG,'Shipping status check started.');
57: fnd_file.put_line(FND_FILE.LOG,'Fetching exception details for delivery : ' || p_delivery_id);
58:
59: for rec_exp in c_get_exp_details
60: loop

Line 57: fnd_file.put_line(FND_FILE.LOG,'Fetching exception details for delivery : ' || p_delivery_id);

53:
54: BEGIN
55:
56: fnd_file.put_line(FND_FILE.LOG,'Shipping status check started.');
57: fnd_file.put_line(FND_FILE.LOG,'Fetching exception details for delivery : ' || p_delivery_id);
58:
59: for rec_exp in c_get_exp_details
60: loop
61: fnd_file.put_line(FND_FILE.OUTPUT,'Delivery Id :' || rec_exp.DELIVERY_ID ||

Line 61: fnd_file.put_line(FND_FILE.OUTPUT,'Delivery Id :' || rec_exp.DELIVERY_ID ||

57: fnd_file.put_line(FND_FILE.LOG,'Fetching exception details for delivery : ' || p_delivery_id);
58:
59: for rec_exp in c_get_exp_details
60: loop
61: fnd_file.put_line(FND_FILE.OUTPUT,'Delivery Id :' || rec_exp.DELIVERY_ID ||
62: ', Exception Entity :' || rec_exp.EXCEPTION_ENTITY ||
63: ', Error Message : ' || rec_exp.ERROR_MESSAGE);
64: ln_count := ln_count + 1;
65:

Line 68: fnd_file.put_line(FND_FILE.LOG,'Shipping status check ended.');

64: ln_count := ln_count + 1;
65:
66: end loop;
67:
68: fnd_file.put_line(FND_FILE.LOG,'Shipping status check ended.');
69:
70: if (ln_count > 0) then
71: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', ln_count || ' errors are outputed.' || 'Please refer to output file for details.');
72: else

Line 141: fnd_file.put_line(FND_FILE.LOG,'Delivery Interface Processing started. Delivery Id : ' || lv_delivery_id);

137: exception_entity = 'INVENTORY_INTERFACE';
138:
139: BEGIN
140: lv_delivery_id := p_delivery_id;
141: fnd_file.put_line(FND_FILE.LOG,'Delivery Interface Processing started. Delivery Id : ' || lv_delivery_id);
142:
143: open c_om_interface_exist;
144: fetch c_om_interface_exist into lv_error_exist;
145: close c_om_interface_exist;

Line 148: fnd_file.put_line(FND_FILE.LOG,'Process OM Interface. Delivery Id : ' || lv_delivery_id);

144: fetch c_om_interface_exist into lv_error_exist;
145: close c_om_interface_exist;
146:
147: if nvl(lv_error_exist, 'N') = 'Y' then
148: fnd_file.put_line(FND_FILE.LOG,'Process OM Interface. Delivery Id : ' || lv_delivery_id);
149:
150: lv_exp_entity := 'OM_INTERFACE';
151:
152: -- clear GT table

Line 163: fnd_file.put_line(FND_FILE.LOG,

159: JAI_OM_WDD_PROCESSING_PKG.PROCESS_VALIDATION (p_delivery_id => lv_delivery_id,
160: p_rec_new => rec_wdd,
161: px_return_code => lv_return_code,
162: px_exp_msg => lt_exp_msg);
163: fnd_file.put_line(FND_FILE.LOG,
164: 'Validation processing returned with ' || lv_return_code);
165:
166: IF lv_return_code <> jai_constants.successful then
167: raise le_val;

Line 177: fnd_file.put_line(FND_FILE.LOG,

173: pv_action => jai_constants.updating,
174: pv_return_code => lv_return_code,
175: pv_return_message => lv_return_msg);
176:
177: fnd_file.put_line(FND_FILE.LOG,
178: 'Interfaced processing returned with ' || lv_return_code || lv_return_msg);
179:
180: IF lv_return_code <> jai_constants.successful then
181: raise le_sub;

Line 190: fnd_file.put_line(FND_FILE.LOG,

186: pv_return_code => lv_return_code ,
187: pv_return_message => lv_return_msg);
188:
189:
190: fnd_file.put_line(FND_FILE.LOG,
191: 'accounting entries for RG23D reversal returned with ' || lv_return_code || lv_return_msg);
192:
193:
194: IF lv_return_code <> jai_constants.successful then

Line 209: fnd_file.put_line(FND_FILE.LOG,'Process Inventory Interface.');

205: fetch c_inv_interface_exist into lv_error_exist;
206: close c_inv_interface_exist;
207:
208: if nvl(lv_error_exist, 'N') = 'Y' then
209: fnd_file.put_line(FND_FILE.LOG,'Process Inventory Interface.');
210: lv_exp_entity := 'INVENTORY_INTERFACE';
211:
212: -- clear GT table
213: JAI_OM_WDD_PROCESSING_PKG.CLEAR_EXP_MSG(p_delivery_id => lv_delivery_id,

Line 216: fnd_file.put_line(FND_FILE.LOG,

212: -- clear GT table
213: JAI_OM_WDD_PROCESSING_PKG.CLEAR_EXP_MSG(p_delivery_id => lv_delivery_id,
214: p_exp_entity => lv_exp_entity);
215:
216: fnd_file.put_line(FND_FILE.LOG,
217: 'Process Inventory Interface. Delivery Id : ' || lv_delivery_id);
218:
219: -- process Delivery Inventory Interface
220: JAI_OM_WDD_PROCESSING_PKG.process_inventory(pv_return_code => lv_return_code,

Line 228: fnd_file.put_line(FND_FILE.LOG,

224: if lv_return_code <> '0' then
225: raise le_sub;
226: end if;
227:
228: fnd_file.put_line(FND_FILE.LOG,
229: 'Commit the changes.');
230: commit;
231:
232: end if;

Line 245: fnd_file.put_line(FND_FILE.LOG,

241: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', null);
242:
243: EXCEPTION
244: WHEN LE_VAL THEN
245: fnd_file.put_line(FND_FILE.LOG,
246: 'Validation failed.');
247: JAI_OM_WDD_PROCESSING_PKG.POPULATE_EXP_MSG(p_delivery_id => lv_delivery_id,
248: p_exp_msg => lt_exp_msg);
249: ln_req_id := FND_REQUEST.SUBMIT_REQUEST('JA',

Line 258: fnd_file.put_line(FND_FILE.LOG,

254: lv_delivery_id);
255:
256: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Validation failed. Please check error details.');
257: WHEN LE_SUB THEN
258: fnd_file.put_line(FND_FILE.LOG,
259: 'Rollback the changes.');
260: rollback;
261:
262: rec_exp_msg.EXCEPTION_TYPE := 'U';

Line 282: fnd_file.put_line(FND_FILE.LOG,

278:
279: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Processing failed. Please check error details.');
280:
281: WHEN OTHERS THEN
282: fnd_file.put_line(FND_FILE.LOG,
283: 'Rollback the changes.');
284: rollback;
285:
286: rec_exp_msg.EXCEPTION_TYPE := 'E';