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_DEBRIEF_HEADERS_PKG dependencies on CSM_UTIL_PKG

Line 111: CSM_UTIL_PKG.log( 'Entered APPLY_INSERT for debrief_header_id'|| p_record.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

107: l_profile_value varchar2(240);
108:
109: BEGIN
110:
111: CSM_UTIL_PKG.log( 'Entered APPLY_INSERT for debrief_header_id'|| p_record.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
112:
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: -- Start with some initialization.

Line 185: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

181: -- This could have failed, so we need to check.
182: if x_return_status <> FND_API.G_RET_STS_SUCCESS
183: then
184: /*** exception occurred in API -> return errmsg ***/
185: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
186: (
187: p_api_error => TRUE
188: );
189: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 189: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

185: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
186: (
187: p_api_error => TRUE
188: );
189: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
190: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
191: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: return;

Line 197: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '

193: return;
194: ELSE
195: -- successful insert...need to reject the record on client
196: -- as debrief_header_id and debrief_number are generated by the API
197: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '
198: || p_record.debrief_header_id
199: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
200: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
201:

Line 202: CSM_UTIL_PKG.REJECT_RECORD

198: || p_record.debrief_header_id
199: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
200: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
201:
202: CSM_UTIL_PKG.REJECT_RECORD
203: (
204: p_record.clid$$cs,
205: p_record.tranid$$,
206: p_record.seqno$$,

Line 216: CSM_UTIL_PKG.LOG

212: );
213:
214: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
215: /*** Reject successful ***/
216: CSM_UTIL_PKG.LOG
217: ( 'Debrief Header record rejected ' || ' for PK '
218: || p_record.debrief_header_id
219: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
220: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here

Line 223: CSM_UTIL_PKG.LOG

219: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
220: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
221: ELSE
222: /*** Reject unsuccessful ***/
223: CSM_UTIL_PKG.LOG
224: ( 'Debrief Header record not rejected ' || ' for PK '
225: || p_record.debrief_header_id
226: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
227: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here

Line 236: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '

232: end if;
233: ELSE
234: -- debrief header already exists at the backend
235: -- reject record on client
236: CSM_UTIL_PKG.LOG ( 'Record successfully processed, rejecting record ' || ' for PK '
237: || p_record.debrief_header_id
238: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
239: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
240:

Line 241: CSM_UTIL_PKG.REJECT_RECORD

237: || p_record.debrief_header_id
238: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
239: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
240:
241: CSM_UTIL_PKG.REJECT_RECORD
242: (
243: p_record.clid$$cs,
244: p_record.tranid$$,
245: p_record.seqno$$,

Line 255: CSM_UTIL_PKG.LOG

251: );
252:
253: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
254: /*** Reject successful ***/
255: CSM_UTIL_PKG.LOG
256: ( 'Debrief Header record rejected ' || ' for PK '
257: || p_record.debrief_header_id
258: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
259: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here

Line 262: CSM_UTIL_PKG.LOG

258: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
259: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here
260: ELSE
261: /*** Reject unsuccessful ***/
262: CSM_UTIL_PKG.LOG
263: ( 'Debrief Header record not rejected ' || ' for PK '
264: || p_record.debrief_header_id
265: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'
266: ,FND_LOG.LEVEL_PROCEDURE); -- put PK column here

Line 282: csm_util_pkg.log(p_error_msg, g_object_name || '.APPLY_UPDATE', FND_LOG.LEVEL_ERROR);

278: IF(r_deb_head.last_update_date <> p_record.server_last_update_date AND r_deb_head.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1
279: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '
280: || p_record.debrief_header_id;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: csm_util_pkg.log(p_error_msg, g_object_name || '.APPLY_UPDATE', FND_LOG.LEVEL_ERROR);
283: RETURN;
284: END IF;
285: ELSE -- client wins
286: -- apply client DFF's incase they exist since the last_updated_by is the same

Line 336: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

332: -- This could have failed, so we need to check.
333: if x_return_status <> FND_API.G_RET_STS_SUCCESS
334: then
335: /*** exception occurred in API -> return errmsg ***/
336: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
337: (
338: p_api_error => TRUE
339: );
340: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 340: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

336: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
337: (
338: p_api_error => TRUE
339: );
340: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
341: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
342: || ' for PK ' || r_deb_head.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: return;

Line 355: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

351:
352: exception
353: when others then
354: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
355: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
356: (
357: p_api_error => TRUE
358: );
359:

Line 360: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

356: (
357: p_api_error => TRUE
358: );
359:
360: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
361: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: END APPLY_INSERT;
364:

Line 402: CSM_UTIL_PKG.log( 'Entered APPLY_UPDATE for debrief_header_id'|| p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

398: l_msg_count NUMBER;
399: l_msg_data VARCHAR2(240);
400:
401: BEGIN
402: CSM_UTIL_PKG.log( 'Entered APPLY_UPDATE for debrief_header_id'|| p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
403:
404: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
405:
406: IF l_profile_value = 'SERVER_WINS' AND

Line 413: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_UPDATE:'

409: FETCH c_debrief_header INTO r_debrief_header;
410: IF c_debrief_header%FOUND THEN
411: IF (r_debrief_header.last_update_date <> p_record.server_last_update_date AND r_debrief_header.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1
412: CLOSE c_debrief_header;
413: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_UPDATE:'
414: || ' for PK ' || p_record.debrief_header_id,
415: g_object_name || '.APPLY_UPDATE',
416: FND_LOG.LEVEL_PROCEDURE );
417: fnd_message.set_name

Line 426: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_UPDATE:',

422: x_return_status := FND_API.G_RET_STS_ERROR;
423: RETURN;
424: END IF;
425: ELSE
426: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_UPDATE:',
427: g_object_name || '.APPLY_UPDATE',
428: FND_LOG.LEVEL_PROCEDURE );
429: END IF;
430: CLOSE c_debrief_header;

Line 485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

481: -- This could have failed, so we need to check.
482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
483: THEN
484: /*** exception occurred in API -> return errmsg ***/
485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
486: (
487: p_api_error => TRUE
488: );
489: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 489: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
486: (
487: p_api_error => TRUE
488: );
489: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
490: || ' ROOT ERROR: csf_debrief_pub.update_debrief'
491: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: RETURN;

Line 501: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: EXCEPTION
500: WHEN others THEN
501: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
502: || ' for PK ' || p_record.debrief_header_id,
503: g_object_name || '.APPLY_UPDATE',
504: FND_LOG.LEVEL_EXCEPTION );
505:

Line 542: CSM_UTIL_PKG.LOG

538: x_return_status
539: );
540: ELSE
541: -- Process delete not supported for this entity
542: CSM_UTIL_PKG.LOG
543: ( 'Delete is not supported for this entity'
544: || ' for PK ' || p_record.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
545:
546: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 546: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

542: CSM_UTIL_PKG.LOG
543: ( 'Delete is not supported for this entity'
544: || ' for PK ' || p_record.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
545:
546: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
547: (
548: p_message => 'CSM_DML_OPERATION'
549: , p_token_name1 => 'DML'
550: , p_token_value1 => p_record.dmltype$$

Line 558: CSM_UTIL_PKG.LOG

554: END IF;
555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** defer record when any process exception occurs ***/
558: CSM_UTIL_PKG.LOG
559: ( 'Exception occurred in CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD:' || ' ' || sqlerrm
560: || ' for PK ' || p_record.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
561:
562: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);

Line 563: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

559: ( 'Exception occurred in CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD:' || ' ' || sqlerrm
560: || ' for PK ' || p_record.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
561:
562: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
563: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
564: (
565: p_api_error => TRUE
566: );
567:

Line 572: This procedure is called by CSM_UTIL_PKG when publication item

568: x_return_status := FND_API.G_RET_STS_ERROR;
569: END APPLY_RECORD;
570:
571: /***
572: This procedure is called by CSM_UTIL_PKG when publication item
573: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
574: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
575: public APIs.
576: ***/

Line 596: csm_util_pkg.log('csm_debrief_header_pkg.apply_client_changes entered','CSM_DEBRIEF_HEADER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

592: BEGIN
593: g_debug_level := p_debug_level;
594: x_return_status := FND_API.G_RET_STS_SUCCESS;
595:
596: csm_util_pkg.log('csm_debrief_header_pkg.apply_client_changes entered','CSM_DEBRIEF_HEADER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
597:
598: /*** loop through debrief parts records in inqueue ***/
599: IF p_task_assignment_id IS NULL THEN
600: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

Line 601: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';

597:
598: /*** loop through debrief parts records in inqueue ***/
599: IF p_task_assignment_id IS NULL THEN
600: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
601: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
602: ELSE
603: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
604: OPEN c_cur FOR 'SELECT * FROM csm_debrief_headers_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
605: ||''' AND TASK_ASSIGNMENT_ID='||p_task_assignment_id;

Line 647: CSM_UTIL_PKG.DELETE_RECORD

643: CLOSE c_debrief;
644:
645: /*** Yes -> delete record from inqueue ***/
646:
647: CSM_UTIL_PKG.DELETE_RECORD
648: (
649: p_user_name,
650: p_tranid,
651: r_debrief_headers.seqno$$,

Line 662: CSM_UTIL_PKG.LOG

658:
659: /*** was delete successful? ***/
660: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
661: /*** no -> rollback ***/
662: CSM_UTIL_PKG.LOG
663: ( 'Deleting from inqueue failed, rolling back to savepoint'
664: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
665: ROLLBACK TO save_rec;
666: x_return_status := FND_API.G_RET_STS_ERROR;

Line 689: CSM_UTIL_PKG.LOG

685: END IF;
686: CLOSE c_debrief;
687:
688: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
689: CSM_UTIL_PKG.LOG
690: ( 'Record not processed successfully, deferring and rejecting record'
691: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
692:
693: CSM_UTIL_PKG.DEFER_RECORD

Line 693: CSM_UTIL_PKG.DEFER_RECORD

689: CSM_UTIL_PKG.LOG
690: ( 'Record not processed successfully, deferring and rejecting record'
691: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
692:
693: CSM_UTIL_PKG.DEFER_RECORD
694: (
695: p_user_name
696: , p_tranid
697: , r_debrief_headers.seqno$$

Line 709: CSM_UTIL_PKG.LOG

705:
706: /*** Was defer successful? ***/
707: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
708: /*** no -> rollback ***/
709: CSM_UTIL_PKG.LOG
710: ( 'Defer record failed, rolling back to savepoint'
711: || ' for PK ' || r_debrief_headers.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
712: ROLLBACK TO save_rec;
713: x_return_status := FND_API.G_RET_STS_ERROR;

Line 722: CSM_UTIL_PKG.LOG

718: CLOSE c_cur;
719:
720: EXCEPTION WHEN OTHERS THEN
721: /*** catch and log exceptions ***/
722: CSM_UTIL_PKG.LOG
723: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
724: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: END APPLY_CLIENT_CHANGES;

Line 747: CSM_UTIL_PKG.LOG('Entering CSM_DEBRIEF_HEADERS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_DEBRIEF_HEADERS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

743: AND seqno$$ = l_sequence
744: AND a.debrief_header_id = b.debrief_header_id ;
745:
746: BEGIN
747: CSM_UTIL_PKG.LOG('Entering CSM_DEBRIEF_HEADERS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_DEBRIEF_HEADERS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
748: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
749: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
750: FETCH get_user_id INTO l_user_id ;
751: CLOSE get_user_id ;