DBA Data[Home] [Help]

APPS.CSM_HZ_LOCATION_PKG dependencies on HZ_LOCATION_V2PUB

Line 88: l_location_rec hz_location_v2pub.location_rec_type;

84: --Variable Declarations
85: x_ovn NUMBER := 1;
86: l_msg_count NUMBER;
87: l_msg_data VARCHAR2(4000);
88: l_location_rec hz_location_v2pub.location_rec_type;
89: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
90: l_location_id NUMBER := NULL;
91: l_person_party_id NUMBER;
92: l_user_id NUMBER;

Line 153: CSM_UTIL_PKG.LOG('Before calling hz_location_v2pub.create_location for Location ID ' || p_record.LOCATION_ID ,

149: l_location_rec.county := p_record.county;
150: l_location_rec.address_lines_phonetic := p_record.address_lines_phonetic;
151: l_location_rec.created_by_module := 'CSFDEAR';
152:
153: CSM_UTIL_PKG.LOG('Before calling hz_location_v2pub.create_location for Location ID ' || p_record.LOCATION_ID ,
154: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
155:
156: --Call the location API to create a new location record.
157: hz_location_v2pub.create_location (

Line 157: hz_location_v2pub.create_location (

153: CSM_UTIL_PKG.LOG('Before calling hz_location_v2pub.create_location for Location ID ' || p_record.LOCATION_ID ,
154: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
155:
156: --Call the location API to create a new location record.
157: hz_location_v2pub.create_location (
158: p_init_msg_list => FND_API.G_TRUE,
159: p_location_rec => l_location_rec,
160: x_location_id => l_location_id,
161: x_return_status => x_return_status,

Line 172: CSM_UTIL_PKG.log( 'Error in hz_location_v2pub.create_location ' || p_error_msg

168: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
169: (
170: p_api_error => TRUE
171: );
172: CSM_UTIL_PKG.log( 'Error in hz_location_v2pub.create_location ' || p_error_msg
173: || ' for Location ID ' || p_record.LOCATION_ID,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
174: x_return_status := FND_API.G_RET_STS_ERROR;
175: RETURN;
176: END IF;