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

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

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

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

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

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

Line 199: CSM_UTIL_PKG.REJECT_RECORD

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

Line 213: CSM_UTIL_PKG.LOG

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

Line 220: CSM_UTIL_PKG.LOG

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

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

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

Line 238: CSM_UTIL_PKG.REJECT_RECORD

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

Line 252: CSM_UTIL_PKG.LOG

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

Line 259: CSM_UTIL_PKG.LOG

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

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

275: 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
276: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '
277: || p_record.debrief_header_id;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: csm_util_pkg.log(p_error_msg, g_object_name || '.APPLY_UPDATE', FND_LOG.LEVEL_ERROR);
280: RETURN;
281: END IF;
282: ELSE -- client wins
283: -- apply client DFF's incase they exist since the last_updated_by is the same

Line 333: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

Line 352: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

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

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

404: FETCH c_debrief_header INTO r_debrief_header;
405: IF c_debrief_header%FOUND THEN
406: 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
407: CLOSE c_debrief_header;
408: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_UPDATE:'
409: || ' for PK ' || p_record.debrief_header_id,
410: g_object_name || '.APPLY_UPDATE',
411: FND_LOG.LEVEL_PROCEDURE );
412: fnd_message.set_name

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

417: x_return_status := FND_API.G_RET_STS_ERROR;
418: RETURN;
419: END IF;
420: ELSE
421: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_UPDATE:',
422: g_object_name || '.APPLY_UPDATE',
423: FND_LOG.LEVEL_PROCEDURE );
424: END IF;
425: CLOSE c_debrief_header;

Line 480: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

480: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
481: (
482: p_api_error => TRUE
483: );
484: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
485: || ' ROOT ERROR: csf_debrief_pub.update_debrief'
486: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: RETURN;

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

492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493:
494: EXCEPTION
495: WHEN others THEN
496: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
497: || ' for PK ' || p_record.debrief_header_id,
498: g_object_name || '.APPLY_UPDATE',
499: FND_LOG.LEVEL_EXCEPTION );
500:

Line 537: CSM_UTIL_PKG.LOG

533: x_return_status
534: );
535: ELSE
536: -- Process delete not supported for this entity
537: CSM_UTIL_PKG.LOG
538: ( 'Delete is not supported for this entity'
539: || ' for PK ' || p_record.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
540:
541: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 541: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

537: CSM_UTIL_PKG.LOG
538: ( 'Delete is not supported for this entity'
539: || ' for PK ' || p_record.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
540:
541: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
542: (
543: p_message => 'CSM_DML_OPERATION'
544: , p_token_name1 => 'DML'
545: , p_token_value1 => p_record.dmltype$$

Line 553: CSM_UTIL_PKG.LOG

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

Line 558: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

554: ( 'Exception occurred in CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD:' || ' ' || sqlerrm
555: || ' for PK ' || p_record.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
556:
557: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
558: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
559: (
560: p_api_error => TRUE
561: );
562:

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

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

Line 625: CSM_UTIL_PKG.DELETE_RECORD

621: CLOSE c_debrief;
622:
623: /*** Yes -> delete record from inqueue ***/
624:
625: CSM_UTIL_PKG.DELETE_RECORD
626: (
627: p_user_name,
628: p_tranid,
629: r_debrief_headers.seqno$$,

Line 640: CSM_UTIL_PKG.LOG

636:
637: /*** was delete successful? ***/
638: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
639: /*** no -> rollback ***/
640: CSM_UTIL_PKG.LOG
641: ( 'Deleting from inqueue failed, rolling back to savepoint'
642: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
643: ROLLBACK TO save_rec;
644: x_return_status := FND_API.G_RET_STS_ERROR;

Line 667: CSM_UTIL_PKG.LOG

663: END IF;
664: CLOSE c_debrief;
665:
666: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
667: CSM_UTIL_PKG.LOG
668: ( 'Record not processed successfully, deferring and rejecting record'
669: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
670:
671: CSM_UTIL_PKG.DEFER_RECORD

Line 671: CSM_UTIL_PKG.DEFER_RECORD

667: CSM_UTIL_PKG.LOG
668: ( 'Record not processed successfully, deferring and rejecting record'
669: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
670:
671: CSM_UTIL_PKG.DEFER_RECORD
672: (
673: p_user_name
674: , p_tranid
675: , r_debrief_headers.seqno$$

Line 687: CSM_UTIL_PKG.LOG

683:
684: /*** Was defer successful? ***/
685: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
686: /*** no -> rollback ***/
687: CSM_UTIL_PKG.LOG
688: ( 'Defer record failed, rolling back to savepoint'
689: || ' for PK ' || r_debrief_headers.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
690: ROLLBACK TO save_rec;
691: x_return_status := FND_API.G_RET_STS_ERROR;

Line 699: CSM_UTIL_PKG.LOG

695: END LOOP;
696:
697: EXCEPTION WHEN OTHERS THEN
698: /*** catch and log exceptions ***/
699: CSM_UTIL_PKG.LOG
700: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
701: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: END APPLY_CLIENT_CHANGES;

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

720: AND seqno$$ = l_sequence
721: AND a.debrief_header_id = b.debrief_header_id ;
722:
723: BEGIN
724: 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);
725: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
726: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
727: FETCH get_user_id INTO l_user_id ;
728: CLOSE get_user_id ;