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.IGC_CC_INT_CC_REL_PUB dependencies on FND_API

Line 72: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

68: p_filename_val => NULL,
69: x_Return_Status => l_Return_Status
70: );
71:
72: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
73: raise FND_API.G_EXC_ERROR;
74: END IF;*/
75: IF (g_state_level >= g_debug_level)
76: THEN

Line 73: raise FND_API.G_EXC_ERROR;

69: x_Return_Status => l_Return_Status
70: );
71:
72: IF (l_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
73: raise FND_API.G_EXC_ERROR;
74: END IF;*/
75: IF (g_state_level >= g_debug_level)
76: THEN
77: fnd_log.STRING (g_state_level, p_path, p_debug_msg);

Line 85: /*WHEN FND_API.G_EXC_ERROR THEN

81: -- --------------------------------------------------------------------
82: -- Exception handler section for the Output_Debug procedure.
83: -- --------------------------------------------------------------------
84: EXCEPTION
85: /*WHEN FND_API.G_EXC_ERROR THEN
86: RETURN;*/
87: WHEN OTHERS
88: THEN
89: IF (fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

Line 100: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

96: END output_debug;
97:
98: PROCEDURE create_releases (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
101: p_commit IN VARCHAR2 := fnd_api.g_false,
102: p_validation_level IN NUMBER
103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,

Line 101: p_commit IN VARCHAR2 := fnd_api.g_false,

97:
98: PROCEDURE create_releases (
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
101: p_commit IN VARCHAR2 := fnd_api.g_false,
102: p_validation_level IN NUMBER
103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,

Line 103: := fnd_api.g_valid_level_full,

99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
101: p_commit IN VARCHAR2 := fnd_api.g_false,
102: p_validation_level IN NUMBER
103: := fnd_api.g_valid_level_full,
104: p_org_id IN igc_cc_headers.org_id%TYPE,
105: p_sob_id IN igc_cc_headers.set_of_books_id%TYPE,
106: p_cover_cc_header_id IN igc_cc_headers.cc_header_id%TYPE,
107: p_invoice_id IN ap_invoices_all.invoice_id%TYPE,

Line 190: x_return_status := fnd_api.g_ret_sts_success;

186: l_full_path := g_path || 'create_releases';
187: -- -------------------------------------------------------------------
188: -- Initialize the return values.
189: -- -------------------------------------------------------------------
190: x_return_status := fnd_api.g_ret_sts_success;
191: x_msg_data := NULL;
192: x_msg_count := 0;
193: x_release_num := NULL;
194: SAVEPOINT int_rel_api_pt;

Line 199: IF NOT fnd_api.compatible_api_call (l_api_version,

195:
196: -- -------------------------------------------------------------------
197: -- Make sure that the appropriate version is being used
198: -- -------------------------------------------------------------------
199: IF NOT fnd_api.compatible_api_call (l_api_version,
200: p_api_version,
201: l_api_name,
202: g_pkg_name
203: )

Line 205: RAISE fnd_api.g_exc_unexpected_error;

201: l_api_name,
202: g_pkg_name
203: )
204: THEN
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:
208: -- -------------------------------------------------------------------
209: -- Make sure that if the message stack is to be initialized it is.

Line 211: IF fnd_api.to_boolean (p_init_msg_list)

207:
208: -- -------------------------------------------------------------------
209: -- Make sure that if the message stack is to be initialized it is.
210: -- -------------------------------------------------------------------
211: IF fnd_api.to_boolean (p_init_msg_list)
212: THEN
213: fnd_msg_pub.initialize;
214: END IF;
215:

Line 221: -- l_debug := FND_API.G_TRUE;

217: -- Setup Debug info for API usage if needed.
218: -- -------------------------------------------------------------------
219: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
220: -- IF (l_debug = 'Y') THEN
221: -- l_debug := FND_API.G_TRUE;
222: -- ELSE
223: -- l_debug := FND_API.G_FALSE;
224: -- END IF;
225: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

Line 223: -- l_debug := FND_API.G_FALSE;

219: -- l_debug := FND_PROFILE.VALUE('IGC_DEBUG_ENABLED');
220: -- IF (l_debug = 'Y') THEN
221: -- l_debug := FND_API.G_TRUE;
222: -- ELSE
223: -- l_debug := FND_API.G_FALSE;
224: -- END IF;
225: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
226: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
227: IF (g_debug_mode = 'Y')

Line 225: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);

221: -- l_debug := FND_API.G_TRUE;
222: -- ELSE
223: -- l_debug := FND_API.G_FALSE;
224: -- END IF;
225: -- IGC_MSGS_PKG.g_debug_mode := FND_API.TO_BOOLEAN(l_debug);
226: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
227: IF (g_debug_mode = 'Y')
228: THEN
229: g_debug_msg :=

Line 524: p_init_msg_list => fnd_api.g_false,

520: x_release_cc_num => l_release_cc_num);*/
521: -- new
522: igc_cc_system_options_pkg.create_auto_cc_num
523: (p_api_version => 1.0,
524: p_init_msg_list => fnd_api.g_false,
525: p_commit => fnd_api.g_false,
526: p_validation_level => fnd_api.g_valid_level_full,
527: x_return_status => l_return_status,
528: x_msg_count => l_msg_count,

Line 525: p_commit => fnd_api.g_false,

521: -- new
522: igc_cc_system_options_pkg.create_auto_cc_num
523: (p_api_version => 1.0,
524: p_init_msg_list => fnd_api.g_false,
525: p_commit => fnd_api.g_false,
526: p_validation_level => fnd_api.g_valid_level_full,
527: x_return_status => l_return_status,
528: x_msg_count => l_msg_count,
529: x_msg_data => l_msg_data,

Line 526: p_validation_level => fnd_api.g_valid_level_full,

522: igc_cc_system_options_pkg.create_auto_cc_num
523: (p_api_version => 1.0,
524: p_init_msg_list => fnd_api.g_false,
525: p_commit => fnd_api.g_false,
526: p_validation_level => fnd_api.g_valid_level_full,
527: x_return_status => l_return_status,
528: x_msg_count => l_msg_count,
529: x_msg_data => l_msg_data,
530: p_org_id => p_org_id,

Line 538: RAISE fnd_api.g_exc_unexpected_error;

534:
535: -- mh: end
536: IF l_release_cc_num IS NULL
537: THEN
538: RAISE fnd_api.g_exc_unexpected_error;
539: END IF; -- CC Header Number.
540: END IF;
541:
542: release_cc_header_id

Line 547: RAISE fnd_api.g_exc_unexpected_error;

543: (x_release_cc_header_id => l_release_cc_header_id);
544:
545: IF l_release_cc_header_id IS NULL
546: THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF; -- CC Header Identification.
549:
550: igc_cc_headers_pkg.insert_row
551: (p_api_version => 1.0,

Line 552: p_init_msg_list => fnd_api.g_false,

548: END IF; -- CC Header Identification.
549:
550: igc_cc_headers_pkg.insert_row
551: (p_api_version => 1.0,
552: p_init_msg_list => fnd_api.g_false,
553: p_commit => fnd_api.g_false,
554: p_validation_level => fnd_api.g_valid_level_full,
555: x_return_status => l_return_status,
556: x_msg_count => l_msg_count,

Line 553: p_commit => fnd_api.g_false,

549:
550: igc_cc_headers_pkg.insert_row
551: (p_api_version => 1.0,
552: p_init_msg_list => fnd_api.g_false,
553: p_commit => fnd_api.g_false,
554: p_validation_level => fnd_api.g_valid_level_full,
555: x_return_status => l_return_status,
556: x_msg_count => l_msg_count,
557: x_msg_data => l_msg_data,

Line 554: p_validation_level => fnd_api.g_valid_level_full,

550: igc_cc_headers_pkg.insert_row
551: (p_api_version => 1.0,
552: p_init_msg_list => fnd_api.g_false,
553: p_commit => fnd_api.g_false,
554: p_validation_level => fnd_api.g_valid_level_full,
555: x_return_status => l_return_status,
556: x_msg_count => l_msg_count,
557: x_msg_data => l_msg_data,
558: p_rowid => l_row_id,

Line 613: IF l_return_status <> fnd_api.g_ret_sts_success

609: p_cc_guarantee_flag => l_cc_headers_rec.cc_guarantee_flag,
610: g_flag => l_version_flag
611: );
612:
613: IF l_return_status <> fnd_api.g_ret_sts_success
614: THEN
615: x_msg_data := l_msg_data;
616: x_msg_count := l_msg_count;
617: RAISE fnd_api.g_exc_unexpected_error;

Line 617: RAISE fnd_api.g_exc_unexpected_error;

613: IF l_return_status <> fnd_api.g_ret_sts_success
614: THEN
615: x_msg_data := l_msg_data;
616: x_msg_count := l_msg_count;
617: RAISE fnd_api.g_exc_unexpected_error;
618: ELSE
619: OPEN c_cc_acct_csr (p_cover_cc_header_id);
620:
621: LOOP

Line 631: RAISE fnd_api.g_exc_unexpected_error;

627: (x_release_cc_acct_line_id => l_release_cc_acct_line_id);
628:
629: IF l_release_cc_acct_line_id IS NULL
630: THEN
631: RAISE fnd_api.g_exc_unexpected_error;
632: END IF; -- Account Line Identification.
633:
634: igc_cc_acct_lines_pkg.insert_row
635: (p_api_version => 1.0,

Line 636: p_init_msg_list => fnd_api.g_false,

632: END IF; -- Account Line Identification.
633:
634: igc_cc_acct_lines_pkg.insert_row
635: (p_api_version => 1.0,
636: p_init_msg_list => fnd_api.g_false,
637: p_commit => fnd_api.g_false,
638: p_validation_level => fnd_api.g_valid_level_full,
639: x_return_status => l_return_status,
640: x_msg_count => l_msg_count,

Line 637: p_commit => fnd_api.g_false,

633:
634: igc_cc_acct_lines_pkg.insert_row
635: (p_api_version => 1.0,
636: p_init_msg_list => fnd_api.g_false,
637: p_commit => fnd_api.g_false,
638: p_validation_level => fnd_api.g_valid_level_full,
639: x_return_status => l_return_status,
640: x_msg_count => l_msg_count,
641: x_msg_data => l_msg_data,

Line 638: p_validation_level => fnd_api.g_valid_level_full,

634: igc_cc_acct_lines_pkg.insert_row
635: (p_api_version => 1.0,
636: p_init_msg_list => fnd_api.g_false,
637: p_commit => fnd_api.g_false,
638: p_validation_level => fnd_api.g_valid_level_full,
639: x_return_status => l_return_status,
640: x_msg_count => l_msg_count,
641: x_msg_data => l_msg_data,
642: p_rowid => l_row_id,

Line 700: IF l_return_status <> fnd_api.g_ret_sts_success

696: g_flag => l_version_flag,
697: p_tax_classif_code => l_cc_acct_lines_rec.tax_classif_code -- modified for Ebtax uptake (Bug No-6472296)
698: );
699:
700: IF l_return_status <> fnd_api.g_ret_sts_success
701: THEN
702: x_msg_data := l_msg_data;
703: x_msg_count := l_msg_count;
704: RAISE fnd_api.g_exc_unexpected_error;

Line 704: RAISE fnd_api.g_exc_unexpected_error;

700: IF l_return_status <> fnd_api.g_ret_sts_success
701: THEN
702: x_msg_data := l_msg_data;
703: x_msg_count := l_msg_count;
704: RAISE fnd_api.g_exc_unexpected_error;
705: ELSE
706: -- Payment Forecast Details
707: OPEN c_cc_det_pf_csr
708: (l_cc_acct_lines_rec.cc_acct_line_id);

Line 721: RAISE fnd_api.g_exc_unexpected_error;

717: );
718:
719: IF l_release_cc_det_pf_line_id IS NULL
720: THEN
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF; -- Payment Forecast Line Identification.
723:
724: igc_cc_det_pf_pkg.insert_row
725: (p_api_version => 1.0,

Line 726: p_init_msg_list => fnd_api.g_false,

722: END IF; -- Payment Forecast Line Identification.
723:
724: igc_cc_det_pf_pkg.insert_row
725: (p_api_version => 1.0,
726: p_init_msg_list => fnd_api.g_false,
727: p_commit => fnd_api.g_false,
728: p_validation_level => fnd_api.g_valid_level_full,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,

Line 727: p_commit => fnd_api.g_false,

723:
724: igc_cc_det_pf_pkg.insert_row
725: (p_api_version => 1.0,
726: p_init_msg_list => fnd_api.g_false,
727: p_commit => fnd_api.g_false,
728: p_validation_level => fnd_api.g_valid_level_full,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,

Line 728: p_validation_level => fnd_api.g_valid_level_full,

724: igc_cc_det_pf_pkg.insert_row
725: (p_api_version => 1.0,
726: p_init_msg_list => fnd_api.g_false,
727: p_commit => fnd_api.g_false,
728: p_validation_level => fnd_api.g_valid_level_full,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,
732: p_rowid => l_row_id,

Line 778: IF l_return_status <> fnd_api.g_ret_sts_success

774: p_context => NULL,
775: g_flag => l_version_flag
776: );
777:
778: IF l_return_status <> fnd_api.g_ret_sts_success
779: THEN
780: x_msg_data := l_msg_data;
781: x_msg_count := l_msg_count;
782: RAISE fnd_api.g_exc_unexpected_error;

Line 782: RAISE fnd_api.g_exc_unexpected_error;

778: IF l_return_status <> fnd_api.g_ret_sts_success
779: THEN
780: x_msg_data := l_msg_data;
781: x_msg_count := l_msg_count;
782: RAISE fnd_api.g_exc_unexpected_error;
783: ELSE
784: BEGIN
785: -- PO Creation.
786: igc_cc_po_interface_pkg.convert_cc_to_po

Line 788: p_init_msg_list => fnd_api.g_false,

784: BEGIN
785: -- PO Creation.
786: igc_cc_po_interface_pkg.convert_cc_to_po
787: (p_api_version => 1.0,
788: p_init_msg_list => fnd_api.g_false,
789: p_commit => fnd_api.g_false,
790: p_validation_level => fnd_api.g_valid_level_full,
791: x_return_status => l_return_status,
792: x_msg_count => l_msg_count,

Line 789: p_commit => fnd_api.g_false,

785: -- PO Creation.
786: igc_cc_po_interface_pkg.convert_cc_to_po
787: (p_api_version => 1.0,
788: p_init_msg_list => fnd_api.g_false,
789: p_commit => fnd_api.g_false,
790: p_validation_level => fnd_api.g_valid_level_full,
791: x_return_status => l_return_status,
792: x_msg_count => l_msg_count,
793: x_msg_data => l_msg_data,

Line 790: p_validation_level => fnd_api.g_valid_level_full,

786: igc_cc_po_interface_pkg.convert_cc_to_po
787: (p_api_version => 1.0,
788: p_init_msg_list => fnd_api.g_false,
789: p_commit => fnd_api.g_false,
790: p_validation_level => fnd_api.g_valid_level_full,
791: x_return_status => l_return_status,
792: x_msg_count => l_msg_count,
793: x_msg_data => l_msg_data,
794: p_cc_header_id => l_release_cc_header_id

Line 797: IF l_return_status <> fnd_api.g_ret_sts_success

793: x_msg_data => l_msg_data,
794: p_cc_header_id => l_release_cc_header_id
795: );
796:
797: IF l_return_status <> fnd_api.g_ret_sts_success
798: THEN
799: x_msg_data := l_msg_data;
800: x_msg_count := l_msg_count;
801: RAISE fnd_api.g_exc_unexpected_error;

Line 801: RAISE fnd_api.g_exc_unexpected_error;

797: IF l_return_status <> fnd_api.g_ret_sts_success
798: THEN
799: x_msg_data := l_msg_data;
800: x_msg_count := l_msg_count;
801: RAISE fnd_api.g_exc_unexpected_error;
802: ELSE
803: BEGIN
804: -- Update PO Approved Flag
805: igc_cc_po_interface_pkg.update_po_approved_flag

Line 807: p_init_msg_list => fnd_api.g_false,

803: BEGIN
804: -- Update PO Approved Flag
805: igc_cc_po_interface_pkg.update_po_approved_flag
806: (p_api_version => 1.0,
807: p_init_msg_list => fnd_api.g_false,
808: p_commit => fnd_api.g_false,
809: p_validation_level => fnd_api.g_valid_level_full,
810: x_return_status => l_return_status,
811: x_msg_count => l_msg_count,

Line 808: p_commit => fnd_api.g_false,

804: -- Update PO Approved Flag
805: igc_cc_po_interface_pkg.update_po_approved_flag
806: (p_api_version => 1.0,
807: p_init_msg_list => fnd_api.g_false,
808: p_commit => fnd_api.g_false,
809: p_validation_level => fnd_api.g_valid_level_full,
810: x_return_status => l_return_status,
811: x_msg_count => l_msg_count,
812: x_msg_data => l_msg_data,

Line 809: p_validation_level => fnd_api.g_valid_level_full,

805: igc_cc_po_interface_pkg.update_po_approved_flag
806: (p_api_version => 1.0,
807: p_init_msg_list => fnd_api.g_false,
808: p_commit => fnd_api.g_false,
809: p_validation_level => fnd_api.g_valid_level_full,
810: x_return_status => l_return_status,
811: x_msg_count => l_msg_count,
812: x_msg_data => l_msg_data,
813: p_cc_header_id => l_release_cc_header_id

Line 817: fnd_api.g_ret_sts_success

813: p_cc_header_id => l_release_cc_header_id
814: );
815:
816: IF l_return_status <>
817: fnd_api.g_ret_sts_success
818: THEN
819: x_msg_data := l_msg_data;
820: x_msg_count := l_msg_count;
821: RAISE fnd_api.g_exc_unexpected_error;

Line 821: RAISE fnd_api.g_exc_unexpected_error;

817: fnd_api.g_ret_sts_success
818: THEN
819: x_msg_data := l_msg_data;
820: x_msg_count := l_msg_count;
821: RAISE fnd_api.g_exc_unexpected_error;
822: ELSE
823: x_msg_data := l_msg_data;
824: x_msg_count := l_msg_count;
825: x_release_num := l_release_cc_num;

Line 869: IF fnd_api.to_boolean (p_commit)

865: THEN
866: CLOSE c_inv_csr;
867: END IF;
868:
869: IF fnd_api.to_boolean (p_commit)
870: THEN
871: -- IF (IGC_MSGS_PKG.g_debug_mode) THEN
872: IF (g_debug_mode = 'Y')
873: THEN

Line 905: x_return_status := fnd_api.g_ret_sts_unexp_error;

901: THEN
902: CLOSE c_inv_csr;
903: END IF;
904:
905: x_return_status := fnd_api.g_ret_sts_unexp_error;
906: fnd_msg_pub.count_and_get (p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909:

Line 919: WHEN fnd_api.g_exc_unexpected_error

915: 'E_INT_REL_NO_SUP or E_INT_REL_NO_INV or E_INT_REL_NO_COVER_CC'
916: || ' or E_INT_REL_NO_NUM_METHOD or E_INT_REL_NO_NUM_METHOD or E_INT_REL_INVALID_USER_ID or E_INT_REL_INVALID_LOGIN_ID'
917: );
918: END IF;
919: WHEN fnd_api.g_exc_unexpected_error
920: THEN
921: IF (c_cc_det_pf_csr%ISOPEN)
922: THEN
923: CLOSE c_cc_det_pf_csr;

Line 941: x_return_status := fnd_api.g_ret_sts_unexp_error;

937: THEN
938: CLOSE c_inv_csr;
939: END IF;
940:
941: x_return_status := fnd_api.g_ret_sts_unexp_error;
942: fnd_msg_pub.count_and_get (p_count => x_msg_count,
943: p_data => x_msg_data
944: );
945:

Line 950: 'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised'

946: IF (g_excep_level >= g_debug_level)
947: THEN
948: fnd_log.STRING (g_excep_level,
949: l_full_path,
950: 'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised'
951: );
952: END IF;
953: WHEN OTHERS
954: THEN

Line 975: x_return_status := fnd_api.g_ret_sts_unexp_error;

971: THEN
972: CLOSE c_inv_csr;
973: END IF;
974:
975: x_return_status := fnd_api.g_ret_sts_unexp_error;
976:
977: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
978: THEN
979: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1035: RAISE fnd_api.g_exc_error;

1031: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1032: END IF;
1033:
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_error;
1036: END;
1037: END IF;
1038:
1039: RETURN;

Line 1086: RAISE fnd_api.g_exc_error;

1082: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1083: END IF;
1084:
1085: fnd_msg_pub.ADD;
1086: RAISE fnd_api.g_exc_error;
1087: END;
1088:
1089: RETURN;
1090: EXCEPTION

Line 1136: RAISE fnd_api.g_exc_error;

1132: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1133: END IF;
1134:
1135: fnd_msg_pub.ADD;
1136: RAISE fnd_api.g_exc_error;
1137: END;
1138:
1139: RETURN;
1140: EXCEPTION

Line 1186: RAISE fnd_api.g_exc_error;

1182: fnd_log.MESSAGE (g_excep_level, l_full_path, FALSE);
1183: END IF;
1184:
1185: fnd_msg_pub.ADD;
1186: RAISE fnd_api.g_exc_error;
1187: END;
1188:
1189: RETURN;
1190: EXCEPTION