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_API

Line 194: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

190: x_plan_id => doc_details_rec.plan_id,
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);

Line 270: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

266: x_msg_count => l_msg_count,
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

Line 368: IF fnd_api.to_boolean (p_init_msg_list) THEN

364: lv_rowid VARCHAR2 (25);
365: l_create_interface_item BOOLEAN;
366: BEGIN
367: --Initialize message list if p_init_msg_list is set to TRUE.
368: IF fnd_api.to_boolean (p_init_msg_list) THEN
369: fnd_msg_pub.initialize;
370: END IF;
371: OPEN cur_order_hdr;
372: FETCH cur_order_hdr INTO order_hdr_rec;

Line 414: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

410: x_msg_count => l_msg_count,
411: x_order_description => order_hdr_rec.order_description,
412: x_order_placed_by => order_hdr_rec.order_placed_by
413: );
414: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
415: p_return_status := l_return_status;
416: p_msg_count := l_msg_count;
417: p_msg_data := l_msg_data;
418: RETURN;

Line 545: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

541: x_plan_id => doc_details_rec.plan_id,
542: x_produced_by => doc_details_rec.produced_by,
543: x_person_id => doc_details_rec.person_id
544: );
545: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
546: p_return_status := l_return_status;
547: p_msg_count := l_msg_count;
548: p_msg_data := l_msg_data;
549: RETURN;

Line 660: IF (NVL (l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN

656: p_return_status => p_return_status,
657: p_msg_data => p_msg_data,
658: p_msg_count => p_msg_count
659: );
660: IF (NVL (l_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success) THEN
661: p_return_status := l_return_status;
662: p_msg_count := l_msg_count;
663: p_msg_data := l_msg_data;
664: RETURN;

Line 672: RAISE fnd_api.g_exc_error;

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
675: AND p_plan_id IS NOT NULL THEN
676: -- Insert a record into IGS_AS_DOC_FEE_PMNT table to note that the student has subscribed to the plan.

Line 700: p_return_status := fnd_api.g_ret_sts_success;

696: x_msg_count => l_msg_count
697: );
698: END IF;
699: --Initialize API return status to success.
700: p_return_status := fnd_api.g_ret_sts_success;
701: --Standard call to get message count and if count is 1, get message info.
702: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN

Line 702: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);

698: END IF;
699: --Initialize API return status to success.
700: p_return_status := fnd_api.g_ret_sts_success;
701: --Standard call to get message count and if count is 1, get message info.
702: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN
705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);

Line 704: WHEN fnd_api.g_exc_error THEN

700: p_return_status := fnd_api.g_ret_sts_success;
701: --Standard call to get message count and if count is 1, get message info.
702: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN
705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 705: p_return_status := fnd_api.g_ret_sts_error;

701: --Standard call to get message count and if count is 1, get message info.
702: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN
705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
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);

Line 706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);

702: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN
705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
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

Line 707: WHEN fnd_api.g_exc_unexpected_error THEN

703: EXCEPTION
704: WHEN fnd_api.g_exc_error THEN
705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
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;

Line 708: p_return_status := fnd_api.g_ret_sts_unexp_error;

704: WHEN fnd_api.g_exc_error THEN
705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
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');

Line 709: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);

705: p_return_status := fnd_api.g_ret_sts_error;
706: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
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);

Line 711: p_return_status := fnd_api.g_ret_sts_unexp_error;

707: WHEN fnd_api.g_exc_unexpected_error THEN
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);

Line 715: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false, p_count => p_msg_count, p_data => p_msg_data);

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:
718: PROCEDURE upd_doc_fee_pmnt (
719: p_person_id NUMBER,