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_LOG

Line 123: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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:
126: OPEN c_get_party_site (p_record.location_id);
127: FETCH c_get_party_site INTO l_party_site_id;

Line 154: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);

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 (
158: p_init_msg_list => FND_API.G_TRUE,

Line 173: || ' for Location ID ' || p_record.LOCATION_ID,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;
177:

Line 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);

206: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
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:

Line 215: CSM_UTIL_PKG.log( 'New Party Site_id: ' ||l_party_site_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);
216:
217: --Update the Task when the Party site id
218: --This has to be done for all cases as Client is providing only Location id
219: UPDATE CSM_TASKS_INQ

Line 227: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);

223: AND location_id = p_record.location_id;
224:
225: ELSE
226: CSM_UTIL_PKG.LOG('Before calling csp create_ship_to_address for Location ID ' || p_record.LOCATION_ID ,
227: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
228:
229: create_ship_to_address(p_record.CLID$$CS,l_ta_id,p_record.address1,p_record.address2,p_record.address3,
230: p_record.county,p_record.state ,p_record.province,p_record.city ,p_record.country,p_record.postal_code,
231: null, null, null,

Line 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);

236: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
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:

Line 245: CSM_UTIL_PKG.log( 'New HR Location_id: ' ||x_loc_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);
246:
247: UPDATE CSM_REQ_HEADERS_INQ --support for special address
248: SET SHIP_TO_LOCATION_ID = x_loc_id,
249: SHIP_TO_LOC_SRC='HR'

Line 258: 'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

254: END IF;
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));

Line 268: || ' for location_id ' || p_record.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

264: (
265: p_api_error => TRUE
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:

Line 291: 'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

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);
292:
293: IF p_record.dmltype$$='I' THEN
294: -- Process insert
295: APPLY_INSERT

Line 305: || ' for Locaton ID ' || p_record.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

301: ELSE --Delete and update is not supported for this PI
302: -- invalid dml type
303: CSM_UTIL_PKG.LOG
304: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
305: || ' for Locaton ID ' || p_record.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
306:
307: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
308: (
309: p_message => 'CSM_DML_OPERATION'

Line 318: 'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

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);
319: EXCEPTION WHEN OTHERS THEN
320: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', substr(sqlerrm,1,2000));
321: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
322: (

Line 326: || ' for Locaton ID ' || p_record.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

322: (
323: p_api_error => TRUE
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;

Line 336: CSM_UTIL_PKG.log( 'Deferring dependent records for Locaton ID ' || p_loc_id ,'CSM_HZ_LOCATION_PKG.DEFER_DEPENDENT_RECORDS',FND_LOG.LEVEL_PROCEDURE);

332: PROCEDURE DEFER_DEPENDENT_RECORDS(p_user_name IN VARCHAR2, p_tranid IN NUMBER,p_loc_id IN NUMBER,p_err_msg IN VARCHAR2)
333: IS
334: l_ret_status varchar2(1);
335: BEGIN
336: CSM_UTIL_PKG.log( 'Deferring dependent records for Locaton ID ' || p_loc_id ,'CSM_HZ_LOCATION_PKG.DEFER_DEPENDENT_RECORDS',FND_LOG.LEVEL_PROCEDURE);
337:
338: --PERSONAL Tasks
339: FOR rec in (SELECT TASK_ID ,SEQNO$$,DMLTYPE$$
340: FROM CSM_TASKS_INQ

Line 403: 'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

399: l_error_msg VARCHAR2(4000);
400:
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 ***/

Line 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

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
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

Line 444: || ' for PK ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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:
446: CSM_UTIL_PKG.DEFER_RECORD
447: (
448: p_user_name

Line 466: || ' for PK ' || r_hz_location_rec.LOCATION_ID ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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
467: ROLLBACK TO save_rec;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: END IF;
470: END IF;

Line 475: 'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

471:
472: END LOOP;
473:
474: CSM_UTIL_PKG.LOG('Leaving CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',
475: 'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
476:
477: EXCEPTION WHEN OTHERS THEN
478: /*** catch and log exceptions ***/
479: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || substr(sqlerrm,1,2000)

Line 480: ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

476:
477: EXCEPTION WHEN OTHERS THEN
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;