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_API

Line 766: p_return_status := fnd_api.g_ret_sts_error;

762: OPEN c_ord (p_order_number);
763: FETCH c_ord INTO v_ord_rec;
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;

Line 769: RAISE fnd_api.g_exc_error;

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
773: -- check if invoice is generated with error account 'Y'

Line 778: p_return_status := fnd_api.g_ret_sts_error;

774: OPEN c_igs_fi_invln(cp_invoice_id => v_ord_rec.invoice_id);
775: FETCH c_igs_fi_invln INTO rec_c_igs_fi_invln;
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;

Line 781: RAISE fnd_api.g_exc_error;

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:
785: p_return_status := fnd_api.g_ret_sts_success;

Line 785: p_return_status := fnd_api.g_ret_sts_success;

781: RAISE fnd_api.g_exc_error;
782: END IF;
783: CLOSE c_igs_fi_invln;
784:
785: p_return_status := fnd_api.g_ret_sts_success;
786: p_invoice_id := v_ord_rec.invoice_id;
787: p_waiver_amount := '0.0';
788: ELSE
789: OPEN c_ftci;

Line 793: p_return_status := fnd_api.g_ret_sts_error;

789: OPEN c_ftci;
790: FETCH c_ftci INTO v_ftci_rec;
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;

Line 796: RAISE fnd_api.g_exc_error;

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.
800: igs_fi_gen_gl.finp_get_cur (

Line 808: RAISE fnd_api.g_exc_error;

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,
812: p_init_msg_list => fnd_api.g_false,

Line 812: p_init_msg_list => fnd_api.g_false,

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,
812: p_init_msg_list => fnd_api.g_false,
813: p_commit => fnd_api.g_false,
814: p_validation_level => fnd_api.g_valid_level_full,
815: p_person_id => v_ord_rec.person_id,
816: p_fee_type => v_ftci_rec.fee_type,

Line 813: p_commit => fnd_api.g_false,

809: END IF;
810: igs_fi_ss_charges_api_pvt.create_charge (
811: p_api_version => 2.0,
812: p_init_msg_list => fnd_api.g_false,
813: p_commit => fnd_api.g_false,
814: p_validation_level => fnd_api.g_valid_level_full,
815: p_person_id => v_ord_rec.person_id,
816: p_fee_type => v_ftci_rec.fee_type,
817: p_fee_cat => NULL,

Line 814: p_validation_level => fnd_api.g_valid_level_full,

810: igs_fi_ss_charges_api_pvt.create_charge (
811: p_api_version => 2.0,
812: p_init_msg_list => fnd_api.g_false,
813: p_commit => fnd_api.g_false,
814: p_validation_level => fnd_api.g_valid_level_full,
815: p_person_id => v_ord_rec.person_id,
816: p_fee_type => v_ftci_rec.fee_type,
817: p_fee_cat => NULL,
818: p_fee_cal_type => v_ftci_rec.fee_cal_type,

Line 839: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

835: x_msg_count => p_msg_count,
836: x_msg_data => p_msg_data,
837: x_waiver_amount => p_waiver_amount
838: );
839: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
840: RETURN;
841: END IF;
842: --
843: -- update the Order header table with the Invoice id returned by the create_charge api

Line 881: p_init_msg_list => FND_API.G_FALSE

877: x_msg_data => p_msg_data,
878: x_msg_count => p_msg_count,
879: x_order_placed_by => order_hdr_rec.order_placed_by,
880: x_order_description => order_hdr_rec.order_description,
881: p_init_msg_list => FND_API.G_FALSE
882: );
883: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
884: RETURN;
885: END IF;

Line 883: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

879: x_order_placed_by => order_hdr_rec.order_placed_by,
880: x_order_description => order_hdr_rec.order_description,
881: p_init_msg_list => FND_API.G_FALSE
882: );
883: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
884: RETURN;
885: END IF;
886: END LOOP;
887: END IF;

Line 896: p_init_msg_list => fnd_api.g_false,

892: IF ((p_payment_type = 'BILL_ME_LATER') OR (p_waiver_amount_ord = 0)) THEN
893: igs_as_documents_api.update_document_details (
894: p_order_number => p_order_number,
895: p_item_number => NULL,
896: p_init_msg_list => fnd_api.g_false,
897: p_return_status => p_return_status,
898: p_msg_count => p_msg_count,
899: p_msg_data => p_msg_data
900: );

Line 905: WHEN fnd_api.g_exc_error THEN

901: END IF;
902:
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

Line 906: p_return_status := fnd_api.g_ret_sts_error;

902:
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;

Line 909: WHEN fnd_api.g_exc_unexpected_error THEN

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);
912: RETURN;
913: WHEN OTHERS THEN

Line 910: p_return_status := fnd_api.g_ret_sts_unexp_error;

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);
912: RETURN;
913: WHEN OTHERS THEN
914: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 914: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1281: OR p_return_status = fnd_api.g_ret_sts_success THEN

1277: --
1278: -- Delete order now
1279: --
1280: IF p_return_status IS NULL
1281: OR p_return_status = fnd_api.g_ret_sts_success THEN
1282: FOR c_order_rec IN c_order LOOP
1283: EXIT WHEN c_order%NOTFOUND;
1284: igs_as_order_hdr_pkg.delete_row (
1285: x_rowid => c_order_rec.ROWID,

Line 1699: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

1695: -- Setting out params
1696: p_return_status := l_return_status;
1697: p_msg_data := l_msg_data;
1698: p_msg_count := l_msg_count;
1699: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
1700: RETURN;
1701: END IF;
1702: -- Inserting record into fee payment, so that transcript items dos fees are calc to Zero
1703: /*IGS_AS_DOC_FEE_PMNT_PKG.INSERT_ROW(

Line 1719: WHEN fnd_api.g_exc_error THEN

1715: p_return_status := l_return_status;
1716: p_msg_data := l_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;

Line 1720: p_return_status := fnd_api.g_ret_sts_error;

1716: p_msg_data := l_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);

Line 1722: WHEN fnd_api.g_exc_unexpected_error THEN

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
1726: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1723: p_return_status := fnd_api.g_ret_sts_unexp_error;

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
1726: p_return_status := fnd_api.g_ret_sts_unexp_error;
1727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 1726: p_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1729: fnd_msg_pub.ADD;
1730: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 1931: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

1927: -- Setting out params
1928: p_return_status := l_return_status;
1929: p_msg_data := l_msg_data;
1930: p_msg_count := l_msg_count;
1931: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
1932: RETURN;
1933: END IF;
1934: END LOOP;
1935: CLOSE c_order_item;

Line 1979: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

1975: x_mode => 'R',
1976: x_order_placed_by => c_order_rec.order_placed_by,
1977: x_order_description => c_order_rec.order_description
1978: );
1979: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
1980: RETURN;
1981: END IF;
1982: -- Setting out params
1983: p_return_status := l_return_status;

Line 1989: p_return_status := fnd_api.g_ret_sts_success;

1985: p_msg_count := l_msg_count;
1986: END LOOP;
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

Line 1993: WHEN fnd_api.g_exc_error THEN

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);
1996: WHEN fnd_api.g_exc_unexpected_error THEN
1997: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1994: p_return_status := fnd_api.g_ret_sts_error;

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

Line 1996: WHEN fnd_api.g_exc_unexpected_error THEN

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
2000: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1997: p_return_status := fnd_api.g_ret_sts_unexp_error;

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
2000: p_return_status := fnd_api.g_ret_sts_unexp_error;
2001: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

Line 2000: p_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2003: fnd_msg_pub.ADD;
2004: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

Line 2549: p_return_status := fnd_api.g_ret_sts_error;

2545: OPEN c_ftci;
2546: FETCH c_ftci INTO v_ftci_rec;
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;

Line 2552: RAISE fnd_api.g_exc_error;

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.
2556: igs_fi_gen_gl.finp_get_cur (

Line 2564: RAISE fnd_api.g_exc_error;

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,
2568: p_init_msg_list => fnd_api.g_false,

Line 2568: p_init_msg_list => fnd_api.g_false,

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,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,
2571: p_person_id => p_person_id,
2572: p_fee_type => v_ftci_rec.fee_type,

Line 2569: p_commit => fnd_api.g_false,

2565: END IF;
2566: igs_fi_ss_charges_api_pvt.create_charge (
2567: p_api_version => 2.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,
2571: p_person_id => p_person_id,
2572: p_fee_type => v_ftci_rec.fee_type,
2573: p_fee_cat => NULL,

Line 2570: p_validation_level => fnd_api.g_valid_level_full,

2566: igs_fi_ss_charges_api_pvt.create_charge (
2567: p_api_version => 2.0,
2568: p_init_msg_list => fnd_api.g_false,
2569: p_commit => fnd_api.g_false,
2570: p_validation_level => fnd_api.g_valid_level_full,
2571: p_person_id => p_person_id,
2572: p_fee_type => v_ftci_rec.fee_type,
2573: p_fee_cat => NULL,
2574: p_fee_cal_type => v_ftci_rec.fee_cal_type,

Line 2595: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2591: x_msg_count => p_msg_count,
2592: x_msg_data => p_msg_data,
2593: x_waiver_amount => p_waiver_amount
2594: );
2595: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2596: RETURN;
2597: END IF;
2598: -- COMMIT;
2599: EXCEPTION

Line 2600: WHEN fnd_api.g_exc_error THEN

2596: RETURN;
2597: END IF;
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

Line 2601: p_return_status := fnd_api.g_ret_sts_error;

2597: END IF;
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;

Line 2604: WHEN fnd_api.g_exc_unexpected_error THEN

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);
2607: RETURN;
2608: WHEN OTHERS THEN

Line 2605: p_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2607: RETURN;
2608: WHEN OTHERS THEN
2609: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2609: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2646: RAISE fnd_api.g_exc_error;

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
2650: igs_as_doc_details_pkg.delete_row (

Line 2656: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN

2652: x_return_status => p_return_status,
2653: x_msg_data => p_msg_data,
2654: x_msg_count => p_msg_count
2655: );
2656: IF NVL (p_return_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success THEN
2657: RETURN;
2658: END IF;
2659: END LOOP;
2660: --Delete all the interface items for this order

Line 2664: p_return_status := fnd_api.g_ret_sts_success;

2660: --Delete all the interface items for this order
2661: DELETE igs_as_ord_itm_int
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

Line 2668: WHEN fnd_api.g_exc_error THEN

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

Line 2669: p_return_status := fnd_api.g_ret_sts_error;

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);
2671: RETURN;
2672: WHEN fnd_api.g_exc_unexpected_error THEN
2673: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2672: WHEN fnd_api.g_exc_unexpected_error THEN

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);
2675: RETURN;
2676: WHEN OTHERS THEN

Line 2673: p_return_status := fnd_api.g_ret_sts_unexp_error;

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);
2675: RETURN;
2676: WHEN OTHERS THEN
2677: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2677: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 2724: p_status := fnd_api.g_ret_sts_error;

2720: p_purpose => p_purpose
2721: );
2722: IF p_action_type = 'PRODUCE_DOCS'
2723: AND p_effbuff = 0 THEN
2724: p_status := fnd_api.g_ret_sts_error;
2725: p_effbuff := fnd_message.get;
2726: ELSIF p_status = 1 THEN
2727: p_status := fnd_api.g_ret_sts_error;
2728: ELSE

Line 2727: p_status := fnd_api.g_ret_sts_error;

2723: AND p_effbuff = 0 THEN
2724: p_status := fnd_api.g_ret_sts_error;
2725: p_effbuff := fnd_message.get;
2726: ELSIF p_status = 1 THEN
2727: p_status := fnd_api.g_ret_sts_error;
2728: ELSE
2729: p_status := fnd_api.g_ret_sts_success;
2730: END IF;
2731: END place_bulk_order;

Line 2729: p_status := fnd_api.g_ret_sts_success;

2725: p_effbuff := fnd_message.get;
2726: ELSIF p_status = 1 THEN
2727: p_status := fnd_api.g_ret_sts_error;
2728: ELSE
2729: p_status := fnd_api.g_ret_sts_success;
2730: END IF;
2731: END place_bulk_order;
2732:
2733: PROCEDURE submit_print_request (

Line 2877: p_ret_status := fnd_api.g_ret_sts_error;

2873: argument9 => NULL, --Order Number
2874: argument10 => p_item_numbers --Concatr string of item number
2875: );
2876: IF l_req_id = 0 THEN
2877: p_ret_status := fnd_api.g_ret_sts_error;
2878: p_effbuff := fnd_message.get;
2879: ELSIF l_req_id IS NULL THEN
2880: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2881: p_effbuff := fnd_message.get;

Line 2880: p_ret_status := fnd_api.g_ret_sts_unexp_error;

2876: IF l_req_id = 0 THEN
2877: p_ret_status := fnd_api.g_ret_sts_error;
2878: p_effbuff := fnd_message.get;
2879: ELSIF l_req_id IS NULL THEN
2880: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2881: p_effbuff := fnd_message.get;
2882: ELSE
2883: p_ret_status := fnd_api.g_ret_sts_success;
2884: p_req_ids := l_req_id;

Line 2883: p_ret_status := fnd_api.g_ret_sts_success;

2879: ELSIF l_req_id IS NULL THEN
2880: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2881: p_effbuff := fnd_message.get;
2882: ELSE
2883: p_ret_status := fnd_api.g_ret_sts_success;
2884: p_req_ids := l_req_id;
2885: END IF;
2886: END IF;
2887: IF l_encert = 1 THEN

Line 2915: p_ret_status := fnd_api.g_ret_sts_error;

2911: argument6 => '',
2912: argument7 => ''
2913: );
2914: IF l_req_id = 0 THEN
2915: p_ret_status := fnd_api.g_ret_sts_error;
2916: p_effbuff := fnd_message.get;
2917: ELSIF l_req_id IS NULL THEN
2918: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2919: p_effbuff := fnd_message.get;

Line 2918: p_ret_status := fnd_api.g_ret_sts_unexp_error;

2914: IF l_req_id = 0 THEN
2915: p_ret_status := fnd_api.g_ret_sts_error;
2916: p_effbuff := fnd_message.get;
2917: ELSIF l_req_id IS NULL THEN
2918: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2919: p_effbuff := fnd_message.get;
2920: ELSE
2921: p_ret_status := fnd_api.g_ret_sts_success;
2922: IF p_req_ids IS NULL THEN

Line 2921: p_ret_status := fnd_api.g_ret_sts_success;

2917: ELSIF l_req_id IS NULL THEN
2918: p_ret_status := fnd_api.g_ret_sts_unexp_error;
2919: p_effbuff := fnd_message.get;
2920: ELSE
2921: p_ret_status := fnd_api.g_ret_sts_success;
2922: IF p_req_ids IS NULL THEN
2923: p_req_ids := l_req_id;
2924: ELSE
2925: p_req_ids := p_req_ids || ', ' || l_req_id;

Line 3054: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3050: x_mode => 'R',
3051: x_order_description => p_order_desc,
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, '------------------------------------------------------------------------');

Line 3061: RAISE fnd_api.g_exc_error;

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, '------------------------------------------------------------------------');
3061: RAISE fnd_api.g_exc_error;
3062: END IF;
3063: -- This is the main loop which loops through the persons for whom the items are to be created ---------
3064: l_one_item_created := FALSE;
3065: WHILE LENGTH (l_person_ids) > 2 LOOP

Line 3200: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3196: x_plan_id => NULL,
3197: x_produced_by => NULL,
3198: x_person_id => l_person_id
3199: );
3200: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3201: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3202: fnd_file.put_line (fnd_file.LOG, l_msg_data);
3203: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3204: RAISE fnd_api.g_exc_error;

Line 3204: RAISE fnd_api.g_exc_error;

3200: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3201: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3202: fnd_file.put_line (fnd_file.LOG, l_msg_data);
3203: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3204: RAISE fnd_api.g_exc_error;
3205: ELSIF l_one_item_created = FALSE
3206: AND l_return_status = fnd_api.g_ret_sts_success THEN
3207: l_one_item_created := TRUE;
3208: END IF;

Line 3206: AND l_return_status = fnd_api.g_ret_sts_success THEN

3202: fnd_file.put_line (fnd_file.LOG, l_msg_data);
3203: fnd_file.put_line (fnd_file.LOG, '------------------------------------------------------------------------');
3204: RAISE fnd_api.g_exc_error;
3205: ELSIF l_one_item_created = FALSE
3206: AND l_return_status = fnd_api.g_ret_sts_success THEN
3207: l_one_item_created := TRUE;
3208: END IF;
3209: --If docs are to be produced, create order Interface table item here so that report can pick it up
3210: INSERT INTO igs_as_ord_itm_int

Line 3302: l_return_status := fnd_api.g_ret_sts_success;

3298: -- End of the main loop which loops through the persons for whom the order is to be created ---------
3299: errbuf := NVL (l_req_id, 0);
3300: COMMIT;
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

Line 3307: WHEN fnd_api.g_exc_error THEN

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;
3310: fnd_msg_pub.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3311: errbuf := l_msg_data;

Line 3309: l_return_status := fnd_api.g_ret_sts_error;

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

Line 3314: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 3316: l_return_status := fnd_api.g_ret_sts_unexp_error;

3312: retcode := 1; --l_RETURN_STATUS;
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;

Line 3323: l_return_status := fnd_api.g_ret_sts_unexp_error;

3319: retcode := 1; --l_RETURN_STATUS;
3320: RETURN;
3321: WHEN OTHERS THEN
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);