DBA Data[Home] [Help]

APPS.IGS_AS_DOCUMENTS_API dependencies on FND_FILE

Line 198: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

194: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
195: fnd_message.set_name ('IGS', 'IGS_AS_ITEM_STATUS');
196: fnd_message.set_token ('ORDER_NUMBER', doc_details_rec.order_number);
197: fnd_message.set_token ('ITEM_NUMBER', doc_details_rec.item_number);
198: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
199: --Delete the Item Number record from Interface table after updating the OSS Document Details Table
200: DELETE igs_as_ord_itm_int
201: WHERE ROWID = processed_items_rec.row_id;
202: ELSE

Line 208: fnd_file.put_line (fnd_file.LOG, l_msg_data);

204: -- data that was retunred by the above API
205: fnd_message.set_name ('IGS', 'IGS_AS_ITEM_STATUS_ERR');
206: fnd_message.set_token ('ORDER_NUMBER', doc_details_rec.order_number);
207: fnd_message.set_token ('ITEM_NUMBER', doc_details_rec.item_number);
208: fnd_file.put_line (fnd_file.LOG, l_msg_data);
209: IF l_msg_count = 1 THEN
210: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
211: ELSE
212: FOR l_count IN 1 .. l_msg_count LOOP

Line 210: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

206: fnd_message.set_token ('ORDER_NUMBER', doc_details_rec.order_number);
207: fnd_message.set_token ('ITEM_NUMBER', doc_details_rec.item_number);
208: fnd_file.put_line (fnd_file.LOG, l_msg_data);
209: IF l_msg_count = 1 THEN
210: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
211: ELSE
212: FOR l_count IN 1 .. l_msg_count LOOP
213: fnd_message.set_encoded (fnd_msg_pub.get (p_msg_index => l_count, p_encoded => 'T'));
214: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

Line 214: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

210: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
211: ELSE
212: FOR l_count IN 1 .. l_msg_count LOOP
213: fnd_message.set_encoded (fnd_msg_pub.get (p_msg_index => l_count, p_encoded => 'T'));
214: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
215: END LOOP;
216: END IF;
217: END IF;
218: END IF;

Line 221: fnd_file.put_line (fnd_file.LOG, '+---------------------------------------------------------------------------+');

217: END IF;
218: END IF;
219: CLOSE cur_doc_details;
220: END LOOP;
221: fnd_file.put_line (fnd_file.LOG, '+---------------------------------------------------------------------------+');
222: --
223: -- Update the order/request status to 'COMPLETED' if all the
224: -- items of the order have status 'PROCESSED'
225: --

Line 273: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

269: );
270: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
271: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_STATUS');
272: fnd_message.set_token ('ORDER_NUMBER', completed_orders_rec.order_number);
273: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
274: ELSE
275: -- IF the RETURN status IS error than LOG a message AND the message
276: -- data that was retunred by the above API
277: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_STATUS_ERR');

Line 279: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

275: -- IF the RETURN status IS error than LOG a message AND the message
276: -- data that was retunred by the above API
277: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_STATUS_ERR');
278: fnd_message.set_token ('ORDER_NUMBER', completed_orders_rec.order_number);
279: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
280: IF l_msg_count = 1 THEN
281: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
282: ELSE
283: FOR l_count IN 1 .. l_msg_count LOOP

Line 281: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

277: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_STATUS_ERR');
278: fnd_message.set_token ('ORDER_NUMBER', completed_orders_rec.order_number);
279: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
280: IF l_msg_count = 1 THEN
281: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
282: ELSE
283: FOR l_count IN 1 .. l_msg_count LOOP
284: fnd_message.set_encoded (fnd_msg_pub.get (p_msg_index => l_count, p_encoded => 'T'));
285: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

Line 285: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

281: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
282: ELSE
283: FOR l_count IN 1 .. l_msg_count LOOP
284: fnd_message.set_encoded (fnd_msg_pub.get (p_msg_index => l_count, p_encoded => 'T'));
285: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
286: END LOOP;
287: END IF;
288: END IF;
289: END LOOP;

Line 296: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

292: errbuf := fnd_message.get_string ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
293: retcode := 2;
294: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
295: fnd_message.set_token ('NAME', 'Update_Order_Item_Status(): ' || SQLERRM);
296: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
297: igs_ge_msg_stack.ADD;
298: igs_ge_msg_stack.conc_exception_hndl;
299: END update_order_item_status;
300: