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

Line 61: ,p_api_version_number => 1.0,p_init_msg_list => FND_API.G_TRUE , p_commit => FND_API.G_TRUE

57: ,p_tax_name =>null,p_region_1=>l_region_1,p_region_2=>l_region_2,p_region_3=>null
58: ,p_loc_information13 => null ,p_loc_information14 => null ,p_loc_information15 => null ,p_loc_information16 => null
59: ,p_loc_information17 => null ,p_loc_information18 => null,p_loc_information19 => null
60: ,p_loc_information20 => null ,p_timezone => null ,p_primary_flag=> null ,p_status => null
61: ,p_api_version_number => 1.0,p_init_msg_list => FND_API.G_TRUE , p_commit => FND_API.G_TRUE
62: ,p_attribute_category => null ,p_attribute1 => null ,p_attribute2 => null
63: ,p_attribute3 => null ,p_attribute4 => null ,p_attribute5 => null
64: ,p_attribute6 => null,p_attribute7 => null ,p_attribute8 => null
65: ,p_attribute9 => null,p_attribute10 => null ,p_attribute11 => null

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117:
118: l_ta_id NUMBER:=NULL;
119: BEGIN
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: CSM_UTIL_PKG.LOG('Entering CSM_HZ_LOCATION_PKG.APPLY_INSERT for Special Location Id ' || p_record.LOCATION_ID ,
123: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
124:
125:

Line 158: p_init_msg_list => FND_API.G_TRUE,

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,
162: x_msg_count => l_msg_count,

Line 166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

162: x_msg_count => l_msg_count,
163: x_msg_data => l_msg_data
164: );
165:
166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
167: /*** exception occurred in API -> return errmsg ***/
168: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
169: (
170: p_api_error => TRUE

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

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;
177:
178: --Get the person party id for the user from fnd user.

Line 195: p_init_msg_list => fnd_api.g_false

191: FROM dual;
192: END IF;
193:
194: hz_party_site_v2pub.create_party_site(
195: p_init_msg_list => fnd_api.g_false
196: , p_party_site_rec => l_party_site_rec
197: , x_return_status => x_return_status
198: , x_msg_count => l_msg_count
199: , x_msg_data => l_msg_data

Line 204: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

200: , x_party_site_id => l_party_site_id
201: , x_party_site_number => l_party_site_number
202: );
203:
204: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: /*** exception occurred in API -> return errmsg ***/
206: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
207: (
208: p_api_error => TRUE

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: (
208: p_api_error => TRUE
209: );
210: CSM_UTIL_PKG.log( 'Error in hz_party_site_v2pub.create_party_site ' || p_error_msg||' for location id ' || p_record.LOCATION_ID,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: RETURN;
213: END IF;
214:
215: CSM_UTIL_PKG.log( 'New Party Site_id: ' ||l_party_site_id ,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

Line 234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

230: p_record.county,p_record.state ,p_record.province,p_record.city ,p_record.country,p_record.postal_code,
231: null, null, null,
232: x_loc_id ,x_cust_id , x_ovn,x_return_status ,l_msg_count,l_msg_data );
233:
234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
235: /*** exception occurred in API -> return errmsg ***/
236: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
237: (
238: p_api_error => TRUE

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237: (
238: p_api_error => TRUE
239: );
240: CSM_UTIL_PKG.log( 'Error in csp create_ship_to_address ' || p_error_msg||' for location id ' || p_record.LOCATION_ID,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: RETURN;
243: END IF;
244:
245: CSM_UTIL_PKG.log( 'New HR Location_id: ' ||x_loc_id ,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

255: END IF;
256:
257: CSM_UTIL_PKG.LOG('Leaving CSM_HZ_LOCATION_PKG.APPLY_INSERT for Location ID ' || p_record.LOCATION_ID ,
258: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: EXCEPTION WHEN OTHERS THEN
262: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', substr(sqlerrm,1,2000));
263: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: );
267: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || substr(sqlerrm,1,2000)
268: || ' for location_id ' || p_record.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
269:
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END APPLY_INSERT;
272:
273:
274: /***

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: l_rc BOOLEAN;
284: l_access_id NUMBER;
285: BEGIN
286: /*** initialize return status and message list ***/
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: FND_MSG_PUB.INITIALIZE;
289:
290: CSM_UTIL_PKG.LOG('Entering CSM_HZ_LOCATION_PKG.APPLY_RECORD for Special Location Id ' || p_record.LOCATION_ID ,
291: 'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: , p_token_name1 => 'DML'
311: , p_token_value1 => p_record.dmltype$$
312: );
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: END IF;
316:
317: CSM_UTIL_PKG.LOG('Leaving CSM_HZ_LOCATION_PKG.APPLY_RECORD for Locaton ID ' || p_record.LOCATION_ID ,
318: 'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: );
325: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || substr(sqlerrm,1,2000)
326: || ' for Locaton ID ' || p_record.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
327:
328: x_return_status := FND_API.G_RET_STS_ERROR;
329:
330: END APPLY_RECORD;
331:
332: PROCEDURE DEFER_DEPENDENT_RECORDS(p_user_name IN VARCHAR2, p_tranid IN NUMBER,p_loc_id IN NUMBER,p_err_msg IN VARCHAR2)

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

401: BEGIN
402: CSM_UTIL_PKG.LOG('Entering CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES ',
403: 'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
404: g_debug_level := p_debug_level;
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: /*** loop through all the records in inqueue ***/
408: FOR r_hz_location_rec IN c_hz_location( p_user_name, p_tranid) LOOP
409: SAVEPOINT save_rec ;

Line 419: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

415: , l_process_status
416: );
417:
418: /*** was record processed successfully? ***/
419: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
420: /*** Yes -> Reject record from inqueue ***/
421: CSM_UTIL_PKG.DELETE_RECORD
422: (
423: p_user_name,

Line 433: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

429: l_error_msg,
430: l_process_status
431: );
432: /*** was delete successful? ***/
433: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
434: /*** no -> rollback ***/
435: CSM_UTIL_PKG.LOG
436: ( 'Deleting from inqueue failed, rolling back to savepoint'
437: || ' for Location ID ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: CSM_UTIL_PKG.LOG
436: ( 'Deleting from inqueue failed, rolling back to savepoint'
437: || ' for Location ID ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
438: ROLLBACK TO save_rec;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: END IF;
441: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
442: /*** Record was not applied successfully -> defer and reject records ***/
443: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

Line 441: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

437: || ' for Location ID ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
438: ROLLBACK TO save_rec;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: END IF;
441: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
442: /*** Record was not applied successfully -> defer and reject records ***/
443: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
444: || ' for PK ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
445:

Line 462: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

458:
459: DEFER_DEPENDENT_RECORDS(p_user_name,p_tranid,r_hz_location_rec.LOCATION_ID,l_error_msg);
460:
461: /*** Was defer successful? ***/
462: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
463: /*** no -> rollback ***/
464: CSM_UTIL_PKG.LOG
465: ( 'Defer record failed, rolling back to savepoint'
466: || ' for PK ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464: CSM_UTIL_PKG.LOG
465: ( 'Defer record failed, rolling back to savepoint'
466: || ' for PK ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
467: ROLLBACK TO save_rec;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: END IF;
470: END IF;
471:
472: END LOOP;

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478: /*** catch and log exceptions ***/
479: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || substr(sqlerrm,1,2000)
480: ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
481:
482: x_return_status := FND_API.G_RET_STS_ERROR;
483:
484: END APPLY_CLIENT_CHANGES;
485:
486: END CSM_HZ_LOCATION_PKG;