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_SS_DOC_REQUEST dependencies on FND_MSG_PUB

Line 768: fnd_msg_pub.ADD;

764: IF c_ord%NOTFOUND THEN
765: CLOSE c_ord;
766: p_return_status := fnd_api.g_ret_sts_error;
767: fnd_message.set_name ('IGS', 'IGS_SS_AS_NO_SUCH_ORD');
768: fnd_msg_pub.ADD;
769: RAISE fnd_api.g_exc_error;
770: END IF;
771: CLOSE c_ord;
772: IF v_ord_rec.invoice_id IS NOT NULL THEN

Line 780: fnd_msg_pub.ADD;

776: IF c_igs_fi_invln%FOUND THEN
777: CLOSE c_igs_fi_invln;
778: p_return_status := fnd_api.g_ret_sts_error;
779: fnd_message.set_name ('IGS', 'IGS_FI_SRC_TXN_ACC_INV');
780: fnd_msg_pub.ADD;
781: RAISE fnd_api.g_exc_error;
782: END IF;
783: CLOSE c_igs_fi_invln;
784:

Line 795: fnd_msg_pub.ADD;

791: IF c_ftci%NOTFOUND THEN
792: CLOSE c_ftci;
793: p_return_status := fnd_api.g_ret_sts_error;
794: fnd_message.set_name ('IGS', 'IGS_SS_AS_FI_CAL_NOT_SET');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798: CLOSE c_ftci;
799: --Capture the default currency that is set up in System Options Form.

Line 807: fnd_msg_pub.ADD;

803: p_v_message_name => l_v_message_name
804: );
805: IF l_v_message_name IS NOT NULL THEN
806: fnd_message.set_name ('IGS', l_v_message_name);
807: fnd_msg_pub.ADD;
808: RAISE fnd_api.g_exc_error;
809: END IF;
810: igs_fi_ss_charges_api_pvt.create_charge (
811: p_api_version => 2.0,

Line 907: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

903: RETURN;
904: EXCEPTION
905: WHEN fnd_api.g_exc_error THEN
906: p_return_status := fnd_api.g_ret_sts_error;
907: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
908: RETURN;
909: WHEN fnd_api.g_exc_unexpected_error THEN
910: p_return_status := fnd_api.g_ret_sts_unexp_error;
911: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 911: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

907: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
908: RETURN;
909: WHEN fnd_api.g_exc_unexpected_error THEN
910: p_return_status := fnd_api.g_ret_sts_unexp_error;
911: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
912: RETURN;
913: WHEN OTHERS THEN
914: p_return_status := fnd_api.g_ret_sts_unexp_error;
915: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 917: fnd_msg_pub.ADD;

913: WHEN OTHERS THEN
914: p_return_status := fnd_api.g_ret_sts_unexp_error;
915: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
916: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
917: fnd_msg_pub.ADD;
918: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
919: RETURN;
920: END create_invoice;
921: --

Line 918: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

914: p_return_status := fnd_api.g_ret_sts_unexp_error;
915: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
916: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
917: fnd_msg_pub.ADD;
918: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
919: RETURN;
920: END create_invoice;
921: --
922: --

Line 1721: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

1717: p_msg_count := l_msg_count;
1718: EXCEPTION
1719: WHEN fnd_api.g_exc_error THEN
1720: p_return_status := fnd_api.g_ret_sts_error;
1721: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1722: WHEN fnd_api.g_exc_unexpected_error THEN
1723: p_return_status := fnd_api.g_ret_sts_unexp_error;
1724: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1725: WHEN OTHERS THEN

Line 1724: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

1720: p_return_status := fnd_api.g_ret_sts_error;
1721: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1722: WHEN fnd_api.g_exc_unexpected_error THEN
1723: p_return_status := fnd_api.g_ret_sts_unexp_error;
1724: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1725: WHEN OTHERS THEN
1726: p_return_status := fnd_api.g_ret_sts_unexp_error;
1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1728: fnd_message.set_token ('NAME', 'Pay_Lifetime_Fees: ' || SQLERRM);

Line 1729: fnd_msg_pub.ADD;

1725: WHEN OTHERS THEN
1726: p_return_status := fnd_api.g_ret_sts_unexp_error;
1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1728: fnd_message.set_token ('NAME', 'Pay_Lifetime_Fees: ' || SQLERRM);
1729: fnd_msg_pub.ADD;
1730: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1731: END pay_lifetime_fees;
1732:
1733: PROCEDURE recalc_after_lft_paid (

Line 1730: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

1726: p_return_status := fnd_api.g_ret_sts_unexp_error;
1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1728: fnd_message.set_token ('NAME', 'Pay_Lifetime_Fees: ' || SQLERRM);
1729: fnd_msg_pub.ADD;
1730: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1731: END pay_lifetime_fees;
1732:
1733: PROCEDURE recalc_after_lft_paid (
1734: p_person_id IN NUMBER,

Line 1991: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

1987: CLOSE c_order;
1988: --Initialize API return status to success.
1989: p_return_status := fnd_api.g_ret_sts_success;
1990: --Standard call to get message count and if count is 1, get message info.
1991: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1992: EXCEPTION
1993: WHEN fnd_api.g_exc_error THEN
1994: p_return_status := fnd_api.g_ret_sts_error;
1995: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 1995: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

1991: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1992: EXCEPTION
1993: WHEN fnd_api.g_exc_error THEN
1994: p_return_status := fnd_api.g_ret_sts_error;
1995: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1996: WHEN fnd_api.g_exc_unexpected_error THEN
1997: p_return_status := fnd_api.g_ret_sts_unexp_error;
1998: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1999: WHEN OTHERS THEN

Line 1998: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

1994: p_return_status := fnd_api.g_ret_sts_error;
1995: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1996: WHEN fnd_api.g_exc_unexpected_error THEN
1997: p_return_status := fnd_api.g_ret_sts_unexp_error;
1998: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
1999: WHEN OTHERS THEN
2000: p_return_status := fnd_api.g_ret_sts_unexp_error;
2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2002: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);

Line 2003: fnd_msg_pub.ADD;

1999: WHEN OTHERS THEN
2000: p_return_status := fnd_api.g_ret_sts_unexp_error;
2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2002: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);
2003: fnd_msg_pub.ADD;
2004: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2005: END recalc_after_lft_paid;
2006:
2007: PROCEDURE get_as_current_term (

Line 2004: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2000: p_return_status := fnd_api.g_ret_sts_unexp_error;
2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2002: fnd_message.set_token ('NAME', 'update_document_details: ' || SQLERRM);
2003: fnd_msg_pub.ADD;
2004: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2005: END recalc_after_lft_paid;
2006:
2007: PROCEDURE get_as_current_term (
2008: p_cal_type OUT NOCOPY VARCHAR2,

Line 2543: fnd_msg_pub.initialize;

2539: l_v_currency igs_fi_control_all.currency_cd%TYPE;
2540: l_v_curr_desc fnd_currencies_tl.NAME%TYPE;
2541: l_v_message_name fnd_new_messages.message_name%TYPE;
2542: BEGIN
2543: fnd_msg_pub.initialize;
2544: p_msg_count := 0;
2545: OPEN c_ftci;
2546: FETCH c_ftci INTO v_ftci_rec;
2547: IF c_ftci%NOTFOUND THEN

Line 2551: fnd_msg_pub.ADD;

2547: IF c_ftci%NOTFOUND THEN
2548: CLOSE c_ftci;
2549: p_return_status := fnd_api.g_ret_sts_error;
2550: fnd_message.set_name ('IGS', 'IGS_FI_FEE_ENCUMB_FEECAT_CAL');
2551: fnd_msg_pub.ADD;
2552: RAISE fnd_api.g_exc_error;
2553: END IF;
2554: CLOSE c_ftci;
2555: --Capture the default currency that is set up in System Options Form.

Line 2563: fnd_msg_pub.ADD;

2559: p_v_message_name => l_v_message_name
2560: );
2561: IF l_v_message_name IS NOT NULL THEN
2562: fnd_message.set_name ('IGS', l_v_message_name);
2563: fnd_msg_pub.ADD;
2564: RAISE fnd_api.g_exc_error;
2565: END IF;
2566: igs_fi_ss_charges_api_pvt.create_charge (
2567: p_api_version => 2.0,

Line 2602: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2598: -- COMMIT;
2599: EXCEPTION
2600: WHEN fnd_api.g_exc_error THEN
2601: p_return_status := fnd_api.g_ret_sts_error;
2602: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2603: RETURN;
2604: WHEN fnd_api.g_exc_unexpected_error THEN
2605: p_return_status := fnd_api.g_ret_sts_unexp_error;
2606: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 2606: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2602: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2603: RETURN;
2604: WHEN fnd_api.g_exc_unexpected_error THEN
2605: p_return_status := fnd_api.g_ret_sts_unexp_error;
2606: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2607: RETURN;
2608: WHEN OTHERS THEN
2609: p_return_status := fnd_api.g_ret_sts_unexp_error;
2610: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 2612: fnd_msg_pub.ADD;

2608: WHEN OTHERS THEN
2609: p_return_status := fnd_api.g_ret_sts_unexp_error;
2610: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2611: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
2612: fnd_msg_pub.ADD;
2613: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2614: RETURN;
2615: END create_trns_plan_invoice_id;
2616:

Line 2613: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2609: p_return_status := fnd_api.g_ret_sts_unexp_error;
2610: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2611: fnd_message.set_token ('NAME', 'CREATE_INVOICE_ID : ' || SQLERRM);
2612: fnd_msg_pub.ADD;
2613: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2614: RETURN;
2615: END create_trns_plan_invoice_id;
2616:
2617: PROCEDURE delete_bulk_item (

Line 2639: fnd_msg_pub.initialize;

2635: c_items_rec c_items%ROWTYPE;
2636: l_count NUMBER;
2637: l_rowid igs_as_order_hdr_v.row_id%TYPE;
2638: BEGIN
2639: fnd_msg_pub.initialize;
2640: OPEN c_chk_del_allwed;
2641: FETCH c_chk_del_allwed INTO l_count;
2642: CLOSE c_chk_del_allwed;
2643: IF l_count > 0 THEN

Line 2645: fnd_msg_pub.ADD;

2641: FETCH c_chk_del_allwed INTO l_count;
2642: CLOSE c_chk_del_allwed;
2643: IF l_count > 0 THEN
2644: fnd_message.set_name ('IGS', 'IGS_SS_AS_CNT_DEL_BLK_ITM');
2645: fnd_msg_pub.ADD;
2646: RAISE fnd_api.g_exc_error;
2647: END IF;
2648: -- Delete all the items in this order
2649: FOR c_items_rec IN c_items LOOP

Line 2666: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2662: WHERE item_number = p_item_number;
2663: -- Initialize API return status to success.
2664: p_return_status := fnd_api.g_ret_sts_success;
2665: -- Standard call to get message count and if count is 1, get message info
2666: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2667: EXCEPTION
2668: WHEN fnd_api.g_exc_error THEN
2669: p_return_status := fnd_api.g_ret_sts_error;
2670: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 2670: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2666: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2667: EXCEPTION
2668: WHEN fnd_api.g_exc_error THEN
2669: p_return_status := fnd_api.g_ret_sts_error;
2670: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2671: RETURN;
2672: WHEN fnd_api.g_exc_unexpected_error THEN
2673: p_return_status := fnd_api.g_ret_sts_unexp_error;
2674: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 2674: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2670: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2671: RETURN;
2672: WHEN fnd_api.g_exc_unexpected_error THEN
2673: p_return_status := fnd_api.g_ret_sts_unexp_error;
2674: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2675: RETURN;
2676: WHEN OTHERS THEN
2677: p_return_status := fnd_api.g_ret_sts_unexp_error;
2678: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 2680: fnd_msg_pub.ADD;

2676: WHEN OTHERS THEN
2677: p_return_status := fnd_api.g_ret_sts_unexp_error;
2678: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2679: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2680: fnd_msg_pub.ADD;
2681: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2682: RETURN;
2683: END delete_bulk_item;
2684:

Line 2681: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

2677: p_return_status := fnd_api.g_ret_sts_unexp_error;
2678: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2679: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
2680: fnd_msg_pub.ADD;
2681: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
2682: RETURN;
2683: END delete_bulk_item;
2684:
2685: PROCEDURE place_bulk_order (

Line 3056: fnd_msg_pub.ADD;

3052: x_order_placed_by => p_admin_person_id
3053: );
3054: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3055: fnd_message.set_name ('IGS', l_msg_data);
3056: fnd_msg_pub.ADD;
3057: --Log the error and exit since if order is not created, no item can be created
3058: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3059: fnd_file.put_line (fnd_file.LOG, l_msg_data);
3060: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');

Line 3305: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

3301: -- Initialize API return status to success.
3302: l_return_status := fnd_api.g_ret_sts_success;
3303: -- Standard call to get message count and if count is 1, get message
3304: -- info.
3305: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3306: EXCEPTION
3307: WHEN fnd_api.g_exc_error THEN
3308: ROLLBACK;
3309: l_return_status := fnd_api.g_ret_sts_error;

Line 3310: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

3306: EXCEPTION
3307: WHEN fnd_api.g_exc_error THEN
3308: ROLLBACK;
3309: l_return_status := fnd_api.g_ret_sts_error;
3310: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3311: errbuf := l_msg_data;
3312: retcode := 1; --l_RETURN_STATUS;
3313: RETURN;
3314: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3317: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

3313: RETURN;
3314: WHEN fnd_api.g_exc_unexpected_error THEN
3315: ROLLBACK;
3316: l_return_status := fnd_api.g_ret_sts_unexp_error;
3317: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3318: errbuf := l_msg_data;
3319: retcode := 1; --l_RETURN_STATUS;
3320: RETURN;
3321: WHEN OTHERS THEN

Line 3326: fnd_msg_pub.ADD;

3322: ROLLBACK;
3323: l_return_status := fnd_api.g_ret_sts_unexp_error;
3324: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3325: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
3326: fnd_msg_pub.ADD;
3327: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3328: errbuf := l_msg_data;
3329: retcode := 2; --l_RETURN_STATUS;
3330: RETURN;

Line 3327: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

3323: l_return_status := fnd_api.g_ret_sts_unexp_error;
3324: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3325: fnd_message.set_token ('NAME', 'Insert_Row : ' || SQLERRM);
3326: fnd_msg_pub.ADD;
3327: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3328: errbuf := l_msg_data;
3329: retcode := 2; --l_RETURN_STATUS;
3330: RETURN;
3331: END bulk_order_job;