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

Line 314: RAISE FND_API.G_EXC_ERROR;

310: log('p_adapter_content_source: '||p_adapter_content_source);
311: log('p_country_code: '||p_country);
312: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
313: FND_MSG_PUB.ADD;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: END IF;
317:
318: -- get default batch size

Line 486: WHEN FND_API.G_EXC_ERROR THEN

482: RETURN;
483: END IF;
484:
485: EXCEPTION
486: WHEN FND_API.G_EXC_ERROR THEN
487: log('Error: Aborting Location Service');
488: ROLLBACK TO address_validation_pub;
489: Retcode := 2;
490: Errbuf := logerror(SQLERRM);

Line 492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

488: ROLLBACK TO address_validation_pub;
489: Retcode := 2;
490: Errbuf := logerror(SQLERRM);
491: FND_FILE.close;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: log('Error: Aborting Location Service');
494: ROLLBACK TO address_validation_pub;
495: Retcode := 2;
496: Errbuf := logerror(SQLERRM);

Line 597: WHEN FND_API.G_EXC_ERROR THEN

593:
594: l_parameter_list.DELETE;
595:
596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: log('Error: Aborting Location Service at worker level');
599: ROLLBACK TO address_validation_w_pub;
600: Retcode := 2;
601: Errbuf := logerror(SQLERRM);

Line 603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

599: ROLLBACK TO address_validation_w_pub;
600: Retcode := 2;
601: Errbuf := logerror(SQLERRM);
602: FND_FILE.close;
603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: log('Error: Aborting Location Service at worker level');
605: ROLLBACK TO address_validation_w_pub;
606: Retcode := 2;
607: Errbuf := logerror(SQLERRM);

Line 710: l_return_status := fnd_api.g_ret_sts_success;

706: AND hps.identifying_address_flag = 'Y';
707:
708: BEGIN
709:
710: l_return_status := fnd_api.g_ret_sts_success;
711:
712: log('p_adapter_id: '||p_adapter_id);
713: log('p_overwrite_threshold: '||p_overwrite_threshold);
714: log('p_location_id: '||p_location_id);

Line 786: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

782: END IF;
783:
784: validate_mandatory_column(l_location_rec, l_return_status);
785:
786: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
787: log('Expected error at update_location_profile. Mandatory column checking failed.');
788: RETURN;
789: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
790: log('Unexpected error at update_location_profile. Mandatory column checking failed.');

Line 789: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

785:
786: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
787: log('Expected error at update_location_profile. Mandatory column checking failed.');
788: RETURN;
789: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
790: log('Unexpected error at update_location_profile. Mandatory column checking failed.');
791: RETURN;
792: END IF;
793:

Line 797: l_location_profile_rec.address1 := nvl(p_address1,fnd_api.g_miss_char);

793:
794: -- Fix bug 3395521, if returned value is NULL, then pass it as g_miss to
795: -- hz_location_profile_pvt
796: l_location_profile_rec.location_id := p_location_id;
797: l_location_profile_rec.address1 := nvl(p_address1,fnd_api.g_miss_char);
798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);
799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);
800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */

Line 798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);

794: -- Fix bug 3395521, if returned value is NULL, then pass it as g_miss to
795: -- hz_location_profile_pvt
796: l_location_profile_rec.location_id := p_location_id;
797: l_location_profile_rec.address1 := nvl(p_address1,fnd_api.g_miss_char);
798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);
799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);
800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);

Line 799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);

795: -- hz_location_profile_pvt
796: l_location_profile_rec.location_id := p_location_id;
797: l_location_profile_rec.address1 := nvl(p_address1,fnd_api.g_miss_char);
798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);
799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);
800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);

Line 800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);

796: l_location_profile_rec.location_id := p_location_id;
797: l_location_profile_rec.address1 := nvl(p_address1,fnd_api.g_miss_char);
798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);
799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);
800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);

Line 802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);

798: l_location_profile_rec.address2 := nvl(p_address2,fnd_api.g_miss_char);
799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);
800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);

Line 803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);

799: l_location_profile_rec.address3 := nvl(p_address3,fnd_api.g_miss_char);
800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);

Line 804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);

800: l_location_profile_rec.address4 := nvl(p_address4,fnd_api.g_miss_char);
801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);

Line 805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);

801: /* Bug 3527919: get country code from database, don't get it from Trillium */
802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);
809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);

Line 806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);

802: --l_location_profile_rec.country := nvl(upper(p_country),fnd_api.g_miss_char);
803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);
809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);
810: l_location_profile_rec.date_validated := nvl(sysdate,fnd_api.g_miss_date);

Line 807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);

803: l_location_profile_rec.country := nvl(upper(l_country),fnd_api.g_miss_char);
804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);
809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);
810: l_location_profile_rec.date_validated := nvl(sysdate,fnd_api.g_miss_date);
811:

Line 808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);

804: l_location_profile_rec.county := nvl(p_county,fnd_api.g_miss_char);
805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);
809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);
810: l_location_profile_rec.date_validated := nvl(sysdate,fnd_api.g_miss_date);
811:
812: IF(l_validation_status_code <= l_overwrite_threshold) THEN

Line 809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);

805: l_location_profile_rec.city := nvl(p_city,fnd_api.g_miss_char);
806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);
809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);
810: l_location_profile_rec.date_validated := nvl(sysdate,fnd_api.g_miss_date);
811:
812: IF(l_validation_status_code <= l_overwrite_threshold) THEN
813:

Line 810: l_location_profile_rec.date_validated := nvl(sysdate,fnd_api.g_miss_date);

806: l_location_profile_rec.postal_code := nvl(p_postal_code,fnd_api.g_miss_char);
807: l_location_profile_rec.prov_state_admin_code := nvl(p_prov_state_admin_code,fnd_api.g_miss_char);
808: l_location_profile_rec.actual_content_source := nvl(l_adapter_content_source,fnd_api.g_miss_char);
809: l_location_profile_rec.validation_status_code := nvl(p_validation_status_code,fnd_api.g_miss_char);
810: l_location_profile_rec.date_validated := nvl(sysdate,fnd_api.g_miss_date);
811:
812: IF(l_validation_status_code <= l_overwrite_threshold) THEN
813:
814: log('Record has status code less than or equal to overwrite threshold. Accept returned location.');

Line 822: IF l_return_status = fnd_api.g_ret_sts_error THEN

818: x_return_status => l_return_status );
819:
820: -- not doing any update on HZ_LOCATIONS, but only
821: -- put location profile to keep history if needed
822: IF l_return_status = fnd_api.g_ret_sts_error THEN
823:
824: log('Tax validation not passed.');
825: -- check if the adapter content source has active record
826: -- with SST flag='Y' in location profile already

Line 868: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

864: x_msg_count => l_msg_count,
865: x_msg_data => l_msg_data
866: );
867:
868: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
869: -- write to log file about the error
870: -- not raising error, continue the next record
871: log('Expected error at update_location_profile');
872: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 872: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

868: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
869: -- write to log file about the error
870: -- not raising error, continue the next record
871: log('Expected error at update_location_profile');
872: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
873: -- write to log file about the error
874: -- not raising error, continue the next record
875: log('Unexpected error at update_location_profile');
876: END IF;

Line 879: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN

875: log('Unexpected error at update_location_profile');
876: END IF;
877: log('Location profile updated.');
878: END IF; -- maintain history
879: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN
880:
881: log('Tax validation passed.');
882: BEGIN
883:

Line 913: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

909: x_msg_count => l_msg_count,
910: x_msg_data => l_msg_data
911: );
912:
913: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
914: -- write to log file about the error
915: -- not raising error, continue the next record
916: log('Expected error at update_location_profile. Rollback changes.');
917: rollback to get_validated_xml_pub;

Line 918: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

914: -- write to log file about the error
915: -- not raising error, continue the next record
916: log('Expected error at update_location_profile. Rollback changes.');
917: rollback to get_validated_xml_pub;
918: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
919: -- write to log file about the error
920: -- not raising error, continue the next record
921: log('Unexpected error at update_location_profile. Rollback changes.');
922: rollback to get_validated_xml_pub;

Line 923: ELSIF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

919: -- write to log file about the error
920: -- not raising error, continue the next record
921: log('Unexpected error at update_location_profile. Rollback changes.');
922: rollback to get_validated_xml_pub;
923: ELSIF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
924: -- update HZ_LOCATIONS directly only if the allow update profile is yes
925: -- AND validation_status_code is below threshold
926: IF(l_validation_sst_flag = 'Y') THEN
927: BEGIN

Line 1019: RAISE fnd_api.g_exc_error;

1015: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1016: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1017: fnd_msg_pub.add;
1018: CLOSE ident_address;
1019: RAISE fnd_api.g_exc_error;
1020: END;
1021:
1022: IF((l_location_rec.country IS NOT NULL AND
1023: NVL(l_country, fnd_api.g_miss_char) <> l_location_rec.country)

Line 1023: NVL(l_country, fnd_api.g_miss_char) <> l_location_rec.country)

1019: RAISE fnd_api.g_exc_error;
1020: END;
1021:
1022: IF((l_location_rec.country IS NOT NULL AND
1023: NVL(l_country, fnd_api.g_miss_char) <> l_location_rec.country)
1024: OR (l_location_rec.city IS NOT NULL AND
1025: NVL(l_city, fnd_api.g_miss_char) <> l_location_rec.city)
1026: OR (l_location_rec.postal_code IS NOT NULL AND
1027: NVL(l_postal_code, fnd_api.g_miss_char) <> l_location_rec.postal_code)

Line 1025: NVL(l_city, fnd_api.g_miss_char) <> l_location_rec.city)

1021:
1022: IF((l_location_rec.country IS NOT NULL AND
1023: NVL(l_country, fnd_api.g_miss_char) <> l_location_rec.country)
1024: OR (l_location_rec.city IS NOT NULL AND
1025: NVL(l_city, fnd_api.g_miss_char) <> l_location_rec.city)
1026: OR (l_location_rec.postal_code IS NOT NULL AND
1027: NVL(l_postal_code, fnd_api.g_miss_char) <> l_location_rec.postal_code)
1028: OR (l_location_rec.state IS NOT NULL AND
1029: NVL(l_state, fnd_api.g_miss_char) <> l_location_rec.state)

Line 1027: NVL(l_postal_code, fnd_api.g_miss_char) <> l_location_rec.postal_code)

1023: NVL(l_country, fnd_api.g_miss_char) <> l_location_rec.country)
1024: OR (l_location_rec.city IS NOT NULL AND
1025: NVL(l_city, fnd_api.g_miss_char) <> l_location_rec.city)
1026: OR (l_location_rec.postal_code IS NOT NULL AND
1027: NVL(l_postal_code, fnd_api.g_miss_char) <> l_location_rec.postal_code)
1028: OR (l_location_rec.state IS NOT NULL AND
1029: NVL(l_state, fnd_api.g_miss_char) <> l_location_rec.state)
1030: OR (l_location_rec.province IS NOT NULL AND
1031: NVL(l_province,fnd_api.g_miss_char) <> l_location_rec.province)

Line 1029: NVL(l_state, fnd_api.g_miss_char) <> l_location_rec.state)

1025: NVL(l_city, fnd_api.g_miss_char) <> l_location_rec.city)
1026: OR (l_location_rec.postal_code IS NOT NULL AND
1027: NVL(l_postal_code, fnd_api.g_miss_char) <> l_location_rec.postal_code)
1028: OR (l_location_rec.state IS NOT NULL AND
1029: NVL(l_state, fnd_api.g_miss_char) <> l_location_rec.state)
1030: OR (l_location_rec.province IS NOT NULL AND
1031: NVL(l_province,fnd_api.g_miss_char) <> l_location_rec.province)
1032: OR (l_location_rec.county IS NOT NULL AND
1033: NVL(l_county, fnd_api.g_miss_char) <> l_location_rec.county)) THEN

Line 1031: NVL(l_province,fnd_api.g_miss_char) <> l_location_rec.province)

1027: NVL(l_postal_code, fnd_api.g_miss_char) <> l_location_rec.postal_code)
1028: OR (l_location_rec.state IS NOT NULL AND
1029: NVL(l_state, fnd_api.g_miss_char) <> l_location_rec.state)
1030: OR (l_location_rec.province IS NOT NULL AND
1031: NVL(l_province,fnd_api.g_miss_char) <> l_location_rec.province)
1032: OR (l_location_rec.county IS NOT NULL AND
1033: NVL(l_county, fnd_api.g_miss_char) <> l_location_rec.county)) THEN
1034: /*
1035: log('Start ARP_ADDS.Set_Location_CCID call.');

Line 1033: NVL(l_county, fnd_api.g_miss_char) <> l_location_rec.county)) THEN

1029: NVL(l_state, fnd_api.g_miss_char) <> l_location_rec.state)
1030: OR (l_location_rec.province IS NOT NULL AND
1031: NVL(l_province,fnd_api.g_miss_char) <> l_location_rec.province)
1032: OR (l_location_rec.county IS NOT NULL AND
1033: NVL(l_county, fnd_api.g_miss_char) <> l_location_rec.county)) THEN
1034: /*
1035: log('Start ARP_ADDS.Set_Location_CCID call.');
1036: -- call ARP_ADDS.Set_Location_CCID, according to bug 2983977
1037: -- this should be replaced by new api call that we don't need

Line 1068: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

1064: x_return_status => l_return_status,
1065: x_msg_count => l_msg_count,
1066: x_msg_data => l_msg_data );
1067:
1068: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
1069: -- write to log file about the error
1070: -- not raising error, continue the next record
1071: log('Expected error at set_loc_assign_id. Location Id: '||l_location_rec.location_id||'. Rollback changes.');
1072: rollback to get_validated_xml_pub;

Line 1073: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1069: -- write to log file about the error
1070: -- not raising error, continue the next record
1071: log('Expected error at set_loc_assign_id. Location Id: '||l_location_rec.location_id||'. Rollback changes.');
1072: rollback to get_validated_xml_pub;
1073: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1074: -- write to log file about the error
1075: -- not raising error, continue the next record
1076: log('UnExpected error at set_loc_assign_id. Location Id: '||l_location_rec.location_id||'. Rollback changes.');
1077: rollback to get_validated_xml_pub;

Line 1153: x_return_status := FND_API.G_RET_STS_SUCCESS;

1149: l_loc_assignment_exist VARCHAR2(1) := 'N';
1150: l_dummy NUMBER;
1151: BEGIN
1152: --Initialize API return status to success.
1153: x_return_status := FND_API.G_RET_STS_SUCCESS;
1154:
1155: l_location_rec := p_location_rec;
1156:
1157: -- Fix bug 4539117

Line 1215: --x_return_status := FND_API.G_RET_STS_ERROR;

1211: EXCEPTION
1212: WHEN NO_DATA_FOUND THEN
1213: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
1214: FND_MSG_PUB.ADD;
1215: --x_return_status := FND_API.G_RET_STS_ERROR;
1216: END;
1217:
1218: log('Country: '||l_location_rec.country);
1219: log('Default country for the org: '||l_default_country);

Line 1284: x_return_status := FND_API.G_RET_STS_SUCCESS;

1280: BEGIN
1281: null;
1282: /*
1283: --Initialize API return status to success.
1284: x_return_status := FND_API.G_RET_STS_SUCCESS;
1285:
1286: OPEN get_xml(p_adapter_log_id);
1287: FETCH get_xml INTO out_doc;
1288: CLOSE get_xml;

Line 1300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN

1296: x_return_status => x_return_status,
1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data );
1299:
1300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data );
1299:
1300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:

Line 1302: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1298: x_msg_data => x_msg_data );
1299:
1300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: EXCEPTION

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299:
1300: IF(x_return_status = FND_API.G_RET_STS_ERROR) THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: EXCEPTION
1307: WHEN FND_API.G_EXC_ERROR THEN

Line 1307: WHEN FND_API.G_EXC_ERROR THEN

1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: EXCEPTION
1307: WHEN FND_API.G_EXC_ERROR THEN
1308: log('Error: Aborting Location Service at submit request: '||p_adapter_log_id);
1309: FND_FILE.close;
1310: -- Retcode := 2;
1311: -- Errbuf := logerror(SQLERRM);

Line 1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1309: FND_FILE.close;
1310: -- Retcode := 2;
1311: -- Errbuf := logerror(SQLERRM);
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: log('Error: Aborting Location Service at submit request: '||p_adapter_log_id);
1315: FND_FILE.close;
1316: -- Retcode := 2;
1317: -- Errbuf := logerror(SQLERRM);

Line 1385: x_return_status := FND_API.G_RET_STS_SUCCESS;

1381: savepoint submit_addrval_doc_pub;
1382: --FND_MSG_PUB.initialize;
1383:
1384: --Initialize API return status to success.
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: log('Adapter ID: '||p_adapter_id);
1388: log('Country Code: '||p_country_code);
1389: l_adapter_id := get_adapter_id(p_adapter_id, p_country_code);

Line 1396: RAISE FND_API.G_EXC_ERROR;

1392: log('p_adapter_id: '||p_adapter_id);
1393: log('p_country_code: '||p_country_code);
1394: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
1395: FND_MSG_PUB.ADD;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: l_write_log := nvl(fnd_profile.value('HZ_WRITE_ADAPTER_LOG'), 'N');
1400:

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423: WHEN NO_DATA_FOUND THEN
1424: log('Cannot find adapter log: '||l_adapter_log_id);
1425: log('x_created_by_module: '||p_module);
1426: log('x_created_by_module_id: '||p_module_id);
1427: RAISE FND_API.G_EXC_ERROR;
1428: END;
1429: END IF;
1430:
1431: BEGIN

Line 1573: RAISE FND_API.G_EXC_ERROR;

1569: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1570: log('Location Service Timeout Occur');
1571: -- need message for invalid adapter
1572: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_TIMEOUT');
1573: RAISE FND_API.G_EXC_ERROR;
1574: WHEN OTHERS THEN
1575: log('Location Service Others Error Occur');
1576: -- need message for invalid adapter
1577: RAISE FND_API.G_EXC_ERROR;

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573: RAISE FND_API.G_EXC_ERROR;
1574: WHEN OTHERS THEN
1575: log('Location Service Others Error Occur');
1576: -- need message for invalid adapter
1577: RAISE FND_API.G_EXC_ERROR;
1578: END;
1579: END IF;
1580:
1581: UTL_HTTP.END_RESPONSE(http_resp);

Line 1594: RAISE FND_API.G_EXC_ERROR;

1590: WHEN UTL_HTTP.REQUEST_FAILED THEN
1591: log('REQUEST_FAILED: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1592: --FND_FILE.close;
1593: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1594: RAISE FND_API.G_EXC_ERROR;
1595:
1596: -- raised by URL http://xxx.oracle.com/
1597: WHEN UTL_HTTP.HTTP_SERVER_ERROR THEN
1598: log('HTTP_SERVER_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);

Line 1601: RAISE FND_API.G_EXC_ERROR;

1597: WHEN UTL_HTTP.HTTP_SERVER_ERROR THEN
1598: log('HTTP_SERVER_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1599: --FND_FILE.close;
1600: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1601: RAISE FND_API.G_EXC_ERROR;
1602:
1603: -- raised by URL http://otn.oracle.com/xxx
1604: WHEN UTL_HTTP.HTTP_CLIENT_ERROR THEN
1605: log('HTTP_CLIENT_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);

Line 1608: RAISE FND_API.G_EXC_ERROR;

1604: WHEN UTL_HTTP.HTTP_CLIENT_ERROR THEN
1605: log('HTTP_CLIENT_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1606: --FND_FILE.close;
1607: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1608: RAISE FND_API.G_EXC_ERROR;
1609:
1610: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1611: log('HTTP TRANSFER TIMEOUT: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1612: --FND_FILE.close;

Line 1614: RAISE FND_API.G_EXC_ERROR;

1610: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1611: log('HTTP TRANSFER TIMEOUT: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1612: --FND_FILE.close;
1613: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1614: RAISE FND_API.G_EXC_ERROR;
1615:
1616: WHEN OTHERS THEN
1617: log('HTTP OTHER EXCEPTION: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1618: log('Check SQL EXCEPTION: '|| SQLERRM);

Line 1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1617: log('HTTP OTHER EXCEPTION: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1618: log('Check SQL EXCEPTION: '|| SQLERRM);
1619: --FND_FILE.close;
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1622: END;
1623:
1624: -- ************************************************************************************ --
1625: -- update log for this transaction, from the id of the log and will update the inbound doc

Line 1643: WHEN FND_API.G_EXC_ERROR THEN

1639:
1640: p_addrval_doc := to_nclob(in_xml);
1641:
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: log('Error: Aborting Location Service');
1645: --FND_FILE.close;
1646: ROLLBACK TO submit_addrval_doc_pub;
1647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1647: x_return_status := FND_API.G_RET_STS_ERROR;

1643: WHEN FND_API.G_EXC_ERROR THEN
1644: log('Error: Aborting Location Service');
1645: --FND_FILE.close;
1646: ROLLBACK TO submit_addrval_doc_pub;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get(
1649: p_encoded => FND_API.G_FALSE,
1650: p_count => x_msg_count,
1651: p_data => x_msg_data);

Line 1649: p_encoded => FND_API.G_FALSE,

1645: --FND_FILE.close;
1646: ROLLBACK TO submit_addrval_doc_pub;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get(
1649: p_encoded => FND_API.G_FALSE,
1650: p_count => x_msg_count,
1651: p_data => x_msg_data);
1652:
1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1649: p_encoded => FND_API.G_FALSE,
1650: p_count => x_msg_count,
1651: p_data => x_msg_data);
1652:
1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1654: log('Error: Aborting Location Service');
1655: --FND_FILE.close;
1656: ROLLBACK TO submit_addrval_doc_pub;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1653: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1654: log('Error: Aborting Location Service');
1655: --FND_FILE.close;
1656: ROLLBACK TO submit_addrval_doc_pub;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: FND_MSG_PUB.Count_And_Get(
1659: p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => x_msg_data);

Line 1659: p_encoded => FND_API.G_FALSE,

1655: --FND_FILE.close;
1656: ROLLBACK TO submit_addrval_doc_pub;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: FND_MSG_PUB.Count_And_Get(
1659: p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => x_msg_data);
1662:
1663: WHEN OTHERS THEN

Line 1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1664: log('Error: Aborting Location Service');
1665: log('SQL Error: '||SQLERRM);
1666: --FND_FILE.close;
1667: ROLLBACK TO submit_addrval_doc_pub;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669: FND_MSG_PUB.Count_And_Get(
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => x_msg_count,
1672: p_data => x_msg_data);

Line 1670: p_encoded => FND_API.G_FALSE,

1666: --FND_FILE.close;
1667: ROLLBACK TO submit_addrval_doc_pub;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669: FND_MSG_PUB.Count_And_Get(
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => x_msg_count,
1672: p_data => x_msg_data);
1673:
1674: END submit_addrval_doc;

Line 1933: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

1929: BEGIN
1930: FND_MSG_PUB.Reset;
1931:
1932: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1933: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1934: END LOOP;
1935: IF (SQLERRM IS NOT NULL) THEN
1936: l_msg_data := l_msg_data || SQLERRM;
1937: END IF;

Line 1997: IF(p_location_rec.address1 IS NULL OR p_location_rec.address1 = FND_API.G_MISS_CHAR) THEN

1993: p_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
1994: x_return_status IN OUT NOCOPY VARCHAR2) IS
1995: BEGIN
1996:
1997: IF(p_location_rec.address1 IS NULL OR p_location_rec.address1 = FND_API.G_MISS_CHAR) THEN
1998: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1999: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');
2000: FND_MSG_PUB.ADD;
2001: log('Address1 is mandatory');

Line 2002: RAISE FND_API.G_EXC_ERROR;

1998: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1999: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');
2000: FND_MSG_PUB.ADD;
2001: log('Address1 is mandatory');
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: IF(p_location_rec.country IS NULL OR p_location_rec.country = FND_API.G_MISS_CHAR) THEN
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 2005: IF(p_location_rec.country IS NULL OR p_location_rec.country = FND_API.G_MISS_CHAR) THEN

2001: log('Address1 is mandatory');
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: IF(p_location_rec.country IS NULL OR p_location_rec.country = FND_API.G_MISS_CHAR) THEN
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');
2008: FND_MSG_PUB.ADD;
2009: log('Country is mandatory');

Line 2010: RAISE FND_API.G_EXC_ERROR;

2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');
2008: FND_MSG_PUB.ADD;
2009: log('Country is mandatory');
2010: RAISE FND_API.G_EXC_ERROR;
2011: END IF;
2012: EXCEPTION
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2013: WHEN FND_API.G_EXC_ERROR THEN

2009: log('Country is mandatory');
2010: RAISE FND_API.G_EXC_ERROR;
2011: END IF;
2012: EXCEPTION
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2014: x_return_status := FND_API.G_RET_STS_ERROR;

2010: RAISE FND_API.G_EXC_ERROR;
2011: END IF;
2012: EXCEPTION
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018:

Line 2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2012: EXCEPTION
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018:
2019: WHEN OTHERS THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2013: WHEN FND_API.G_EXC_ERROR THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018:
2019: WHEN OTHERS THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018:
2019: WHEN OTHERS THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2023: FND_MSG_PUB.ADD;
2024: END validate_mandatory_column;

Line 2081: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

2077: x_msg_data => l_msg_data );
2078:
2079: l_event_data := to_clob(l_event_nclob_data);
2080:
2081: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2082: RAISE FND_API.G_EXC_ERROR;
2083: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;

Line 2082: RAISE FND_API.G_EXC_ERROR;

2078:
2079: l_event_data := to_clob(l_event_nclob_data);
2080:
2081: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2082: RAISE FND_API.G_EXC_ERROR;
2083: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;
2086:

Line 2083: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2079: l_event_data := to_clob(l_event_nclob_data);
2080:
2081: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2082: RAISE FND_API.G_EXC_ERROR;
2083: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;
2086:
2087: l_parameter_list := wf_parameter_list_t();

Line 2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2080:
2081: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2082: RAISE FND_API.G_EXC_ERROR;
2083: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2085: END IF;
2086:
2087: l_parameter_list := wf_parameter_list_t();
2088:

Line 2123: WHEN FND_API.G_EXC_ERROR THEN

2119: l_parameter_list.DELETE;
2120:
2121: RETURN 'SUCCESS';
2122: EXCEPTION
2123: WHEN FND_API.G_EXC_ERROR THEN
2124: log('Expected Error: Aborting Location Service for this batch');
2125: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2126: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2127: --return 'ERROR';

Line 2128: RAISE FND_API.G_EXC_ERROR;

2124: log('Expected Error: Aborting Location Service for this batch');
2125: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2126: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2127: --return 'ERROR';
2128: RAISE FND_API.G_EXC_ERROR;
2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2130: log('Unexpected Error: Aborting Location Service for this batch');
2131: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2132: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2125: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2126: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2127: --return 'ERROR';
2128: RAISE FND_API.G_EXC_ERROR;
2129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2130: log('Unexpected Error: Aborting Location Service for this batch');
2131: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2132: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2133: --return 'ERROR';

Line 2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2130: log('Unexpected Error: Aborting Location Service for this batch');
2131: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);
2132: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2133: --return 'ERROR';
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: WHEN OTHERS THEN
2136: log('Others Error: Aborting Location Service for this batch');
2137: log('SQL Error: '||SQLERRM);
2138: Wf_Core.Context('ECX_RULE', 'GENERATEXML', p_event.getEventName(), p_subscription_guid);