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

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

753: -- p_Insert_cur M U S T be zero (0).
754: -- ******************************************************
755: PROCEDURE insert_into_prod_interface_pvt(
756: p_api_version_number IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
758: p_simulate IN VARCHAR2 := fnd_api.g_false,
759: p_commit IN VARCHAR2 := fnd_api.g_false,
760: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,

Line 758: p_simulate IN VARCHAR2 := fnd_api.g_false,

754: -- ******************************************************
755: PROCEDURE insert_into_prod_interface_pvt(
756: p_api_version_number IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
758: p_simulate IN VARCHAR2 := fnd_api.g_false,
759: p_commit IN VARCHAR2 := fnd_api.g_false,
760: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,
762: x_msg_count OUT NOCOPY NUMBER,

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

755: PROCEDURE insert_into_prod_interface_pvt(
756: p_api_version_number IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
758: p_simulate IN VARCHAR2 := fnd_api.g_false,
759: p_commit IN VARCHAR2 := fnd_api.g_false,
760: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,
762: x_msg_count OUT NOCOPY NUMBER,
763: x_msg_data OUT NOCOPY VARCHAR2,

Line 760: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

756: p_api_version_number IN NUMBER,
757: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
758: p_simulate IN VARCHAR2 := fnd_api.g_false,
759: p_commit IN VARCHAR2 := fnd_api.g_false,
760: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,
762: x_msg_count OUT NOCOPY NUMBER,
763: x_msg_data OUT NOCOPY VARCHAR2,
764: p_interface_table IN VARCHAR2,

Line 799: IF NOT fnd_api.compatible_api_call(

795: -- Standard Start of API savepoint
796: SAVEPOINT insert_into_prod_interface_pvt;
797:
798: -- Standard call to check for call compatibility.
799: IF NOT fnd_api.compatible_api_call(
800: l_api_version_number,
801: p_api_version_number,
802: l_api_name,
803: g_pkg_name) THEN

Line 804: RAISE fnd_api.g_exc_unexpected_error;

800: l_api_version_number,
801: p_api_version_number,
802: l_api_name,
803: g_pkg_name) THEN
804: RAISE fnd_api.g_exc_unexpected_error;
805: END IF;
806:
807: -- Initialize message list if p_init_msg_list is set to TRUE.
808: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 808: IF fnd_api.to_boolean(p_init_msg_list) THEN

804: RAISE fnd_api.g_exc_unexpected_error;
805: END IF;
806:
807: -- Initialize message list if p_init_msg_list is set to TRUE.
808: IF fnd_api.to_boolean(p_init_msg_list) THEN
809: fnd_msg_pub.initialize;
810: END IF;
811:
812: -- Initialize API return status to success

Line 813: x_return_status := fnd_api.g_ret_sts_success;

809: fnd_msg_pub.initialize;
810: END IF;
811:
812: -- Initialize API return status to success
813: x_return_status := fnd_api.g_ret_sts_success;
814: if EC_DEBUG.G_debug_level >= 2 then
815: EC_DEBUG.PL(3, 'x_return_status: ',x_return_status);
816: end if;
817: IF p_insert_cur = 0 THEN

Line 1012: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1008: END IF;
1009:
1010: -- Both G_EXC_ERROR and G_EXC_UNEXPECTED_ERROR are handled in
1011: -- the API exception handler.
1012: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: -- Unexpected error, abort processing.
1014: RAISE fnd_api.g_exc_unexpected_error;
1015: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1016: -- Error, abort processing

Line 1014: RAISE fnd_api.g_exc_unexpected_error;

1010: -- Both G_EXC_ERROR and G_EXC_UNEXPECTED_ERROR are handled in
1011: -- the API exception handler.
1012: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: -- Unexpected error, abort processing.
1014: RAISE fnd_api.g_exc_unexpected_error;
1015: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1016: -- Error, abort processing
1017: RAISE fnd_api.g_exc_error;
1018: END IF;

Line 1015: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1011: -- the API exception handler.
1012: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1013: -- Unexpected error, abort processing.
1014: RAISE fnd_api.g_exc_unexpected_error;
1015: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1016: -- Error, abort processing
1017: RAISE fnd_api.g_exc_error;
1018: END IF;
1019:

Line 1017: RAISE fnd_api.g_exc_error;

1013: -- Unexpected error, abort processing.
1014: RAISE fnd_api.g_exc_unexpected_error;
1015: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1016: -- Error, abort processing
1017: RAISE fnd_api.g_exc_error;
1018: END IF;
1019:
1020: -- Standard check of p_simulate and p_commit parameters
1021: IF fnd_api.to_boolean(p_simulate) THEN

Line 1021: IF fnd_api.to_boolean(p_simulate) THEN

1017: RAISE fnd_api.g_exc_error;
1018: END IF;
1019:
1020: -- Standard check of p_simulate and p_commit parameters
1021: IF fnd_api.to_boolean(p_simulate) THEN
1022: ROLLBACK TO insert_into_prod_interface_pvt;
1023: ELSIF fnd_api.to_boolean(p_commit) THEN
1024: COMMIT WORK;
1025: END IF;

Line 1023: ELSIF fnd_api.to_boolean(p_commit) THEN

1019:
1020: -- Standard check of p_simulate and p_commit parameters
1021: IF fnd_api.to_boolean(p_simulate) THEN
1022: ROLLBACK TO insert_into_prod_interface_pvt;
1023: ELSIF fnd_api.to_boolean(p_commit) THEN
1024: COMMIT WORK;
1025: END IF;
1026:
1027: -- Standard call to get message count and if count is 1, get message info.

Line 1034: WHEN fnd_api.g_exc_error THEN

1030: p_data => x_msg_data);
1031: EC_DEBUG.POP('ece_extract_utils_pub.insert_into_prod_interface_pvt');
1032:
1033: EXCEPTION
1034: WHEN fnd_api.g_exc_error THEN
1035: ROLLBACK TO insert_into_prod_interface_pvt;
1036: x_return_status := fnd_api.g_ret_sts_error;
1037:
1038: fnd_msg_pub.count_and_get(

Line 1036: x_return_status := fnd_api.g_ret_sts_error;

1032:
1033: EXCEPTION
1034: WHEN fnd_api.g_exc_error THEN
1035: ROLLBACK TO insert_into_prod_interface_pvt;
1036: x_return_status := fnd_api.g_ret_sts_error;
1037:
1038: fnd_msg_pub.count_and_get(
1039: p_count => x_msg_count,
1040: p_data => x_msg_data);

Line 1041: WHEN fnd_api.g_exc_unexpected_error THEN

1037:
1038: fnd_msg_pub.count_and_get(
1039: p_count => x_msg_count,
1040: p_data => x_msg_data);
1041: WHEN fnd_api.g_exc_unexpected_error THEN
1042: ROLLBACK TO insert_into_prod_interface_pvt;
1043: x_return_status := fnd_api.g_ret_sts_error;
1044:
1045: fnd_msg_pub.count_and_get(

Line 1043: x_return_status := fnd_api.g_ret_sts_error;

1039: p_count => x_msg_count,
1040: p_data => x_msg_data);
1041: WHEN fnd_api.g_exc_unexpected_error THEN
1042: ROLLBACK TO insert_into_prod_interface_pvt;
1043: x_return_status := fnd_api.g_ret_sts_error;
1044:
1045: fnd_msg_pub.count_and_get(
1046: p_count => x_msg_count,
1047: p_data => x_msg_data);

Line 1053: x_return_status := fnd_api.g_ret_sts_error;

1049: ece_error_handling_pvt.print_parse_error(
1050: dbms_sql.last_error_position,
1051: '');
1052: ROLLBACK TO insert_into_prod_interface_pvt;
1053: x_return_status := fnd_api.g_ret_sts_error;
1054:
1055: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1056: fnd_msg_pub.add_exc_msg(
1057: g_file_name,