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.IGS_AS_DOCUMENTS_API dependencies on FND_MESSAGE

Line 195: fnd_message.set_name ('IGS', 'IGS_AS_ITEM_STATUS');

191: x_produced_by => doc_details_rec.produced_by,
192: x_person_id => doc_details_rec.person_id
193: );
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

Line 196: fnd_message.set_token ('ORDER_NUMBER', doc_details_rec.order_number);

192: x_person_id => doc_details_rec.person_id
193: );
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

Line 197: fnd_message.set_token ('ITEM_NUMBER', doc_details_rec.item_number);

193: );
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;

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 205: fnd_message.set_name ('IGS', 'IGS_AS_ITEM_STATUS_ERR');

201: WHERE ROWID = processed_items_rec.row_id;
202: ELSE
203: -- IF the RETURN status IS error than LOG a message AND the message
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

Line 206: fnd_message.set_token ('ORDER_NUMBER', doc_details_rec.order_number);

202: ELSE
203: -- IF the RETURN status IS error than LOG a message AND the message
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);

Line 207: fnd_message.set_token ('ITEM_NUMBER', doc_details_rec.item_number);

203: -- IF the RETURN status IS error than LOG a message AND the message
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

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 213: fnd_message.set_encoded (fnd_msg_pub.get (p_msg_index => l_count, p_encoded => 'T'));

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);
215: END LOOP;
216: END IF;
217: END IF;

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 271: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_STATUS');

267: x_order_description => completed_orders_rec.order_description,
268: x_order_placed_by => completed_orders_rec.order_placed_by
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

Line 272: fnd_message.set_token ('ORDER_NUMBER', completed_orders_rec.order_number);

268: x_order_placed_by => completed_orders_rec.order_placed_by
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

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 277: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_STATUS_ERR');

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');
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);

Line 278: fnd_message.set_token ('ORDER_NUMBER', completed_orders_rec.order_number);

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');
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

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 284: fnd_message.set_encoded (fnd_msg_pub.get (p_msg_index => l_count, p_encoded => 'T'));

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);
286: END LOOP;
287: END IF;
288: END IF;

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 292: errbuf := fnd_message.get_string ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

288: END IF;
289: END LOOP;
290: EXCEPTION
291: WHEN OTHERS THEN
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);

Line 294: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

290: EXCEPTION
291: WHEN OTHERS THEN
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;

Line 295: fnd_message.set_token ('NAME', 'Update_Order_Item_Status(): ' || SQLERRM);

291: WHEN OTHERS THEN
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;

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:

Line 669: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_NOT_FOUND');

665: END IF;
666: ELSE
667: --If Order Details are not found for the passed Order Number
668: CLOSE cur_order_hdr;
669: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_NOT_FOUND');
670: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (p_order_number));
671: fnd_msg_pub.ADD;
672: RAISE fnd_api.g_exc_error;
673: END IF;

Line 670: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (p_order_number));

666: ELSE
667: --If Order Details are not found for the passed Order Number
668: CLOSE cur_order_hdr;
669: fnd_message.set_name ('IGS', 'IGS_AS_ORDER_NOT_FOUND');
670: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (p_order_number));
671: fnd_msg_pub.ADD;
672: RAISE fnd_api.g_exc_error;
673: END IF;
674: ELSIF p_order_number IS NULL

Line 712: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

708: p_return_status := fnd_api.g_ret_sts_unexp_error;
709: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
710: WHEN OTHERS THEN
711: p_return_status := fnd_api.g_ret_sts_unexp_error;
712: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
713: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);
714: fnd_msg_pub.ADD;
715: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
716: END update_document_details;

Line 713: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);

709: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
710: WHEN OTHERS THEN
711: p_return_status := fnd_api.g_ret_sts_unexp_error;
712: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
713: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);
714: fnd_msg_pub.ADD;
715: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
716: END update_document_details;
717: