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 CSM_UTIL_PKG

Line 122: CSM_UTIL_PKG.LOG('Entering CSM_HZ_LOCATION_PKG.APPLY_INSERT for Special Location Id ' || p_record.LOCATION_ID ,

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

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

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
171: );
172: CSM_UTIL_PKG.log( 'Error in hz_location_v2pub.create_location ' || p_error_msg

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;

Line 206: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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 226: CSM_UTIL_PKG.LOG('Before calling csp create_ship_to_address for Location ID ' || p_record.LOCATION_ID ,

222: AND clid$$cs = p_record.CLID$$CS
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,

Line 236: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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 257: CSM_UTIL_PKG.LOG('Leaving CSM_HZ_LOCATION_PKG.APPLY_INSERT for Location ID ' || p_record.LOCATION_ID ,

253: AND ADDRESS_TYPE='S';
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

Line 263: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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
264: (
265: p_api_error => TRUE
266: );
267: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || substr(sqlerrm,1,2000)

Line 267: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || substr(sqlerrm,1,2000)

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

Line 290: CSM_UTIL_PKG.LOG('Entering CSM_HZ_LOCATION_PKG.APPLY_RECORD for Special Location Id ' || p_record.LOCATION_ID ,

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

Line 303: CSM_UTIL_PKG.LOG

299: x_return_status
300: );
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

Line 307: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
310: , p_token_name1 => 'DML'
311: , p_token_value1 => p_record.dmltype$$

Line 317: CSM_UTIL_PKG.LOG('Leaving CSM_HZ_LOCATION_PKG.APPLY_RECORD for Locaton ID ' || p_record.LOCATION_ID ,

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

Line 321: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
323: p_api_error => TRUE
324: );
325: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || substr(sqlerrm,1,2000)

Line 325: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || substr(sqlerrm,1,2000)

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

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 345: CSM_UTIL_PKG.DEFER_RECORD

341: WHERE tranid$$ = p_tranid
342: AND clid$$cs = p_user_name
343: AND location_id = p_loc_id)
344: LOOP
345: CSM_UTIL_PKG.DEFER_RECORD
346: ( p_user_name , p_tranid , rec.seqno$$
347: , rec.TASK_ID , g_object_name , 'CSM_TASKS'
348: , 'Creation of new Location failed :'||p_err_msg , l_ret_status , rec.dmltype$$
349: );

Line 361: CSM_UTIL_PKG.DEFER_RECORD

357: AND SHIP_TO_LOCATION_ID = p_loc_id
358: AND ADDRESS_TYPE='S')
359: LOOP
360:
361: CSM_UTIL_PKG.DEFER_RECORD
362: ( p_user_name , p_tranid , rec.seqno$$
363: , rec.REQUIREMENT_HEADER_ID , g_object_name , 'CSM_REQ_HEADERS'
364: , 'Creation of Special Ship To Location failed :'||p_err_msg , l_ret_status , rec.dmltype$$
365: );

Line 373: CSM_UTIL_PKG.DEFER_RECORD

369: WHERE tranid$$ = p_tranid
370: AND clid$$cs = p_user_name
371: AND REQUIREMENT_HEADER_ID=rec.REQUIREMENT_HEADER_ID)
372: LOOP
373: CSM_UTIL_PKG.DEFER_RECORD
374: ( p_user_name , p_tranid , rec2.seqno$$
375: , rec2.REQUIREMENT_LINE_ID , g_object_name , 'CSM_REQ_LINES'
376: , 'Header failed on creation of special address :'||p_err_msg , l_ret_status , rec2.dmltype$$
377: );

Line 402: CSM_UTIL_PKG.LOG('Entering CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES ',

398: l_process_status VARCHAR2(1);
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:

Line 421: CSM_UTIL_PKG.DELETE_RECORD

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,
424: p_tranid,
425: r_hz_location_rec.seqno$$,

Line 435: CSM_UTIL_PKG.LOG

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
438: ROLLBACK TO save_rec;
439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 443: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

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

Line 446: CSM_UTIL_PKG.DEFER_RECORD

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
449: , p_tranid
450: , r_hz_location_rec.seqno$$

Line 464: CSM_UTIL_PKG.LOG

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

Line 474: CSM_UTIL_PKG.LOG('Leaving CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',

470: END IF;
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 ***/

Line 479: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || substr(sqlerrm,1,2000)

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)
480: ,'CSM_HZ_LOCATION_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
481:
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: