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_DEBRIEF_HEADERS_PKG

Line 1: PACKAGE BODY CSM_DEBRIEF_HEADERS_PKG AS

1: PACKAGE BODY CSM_DEBRIEF_HEADERS_PKG AS
2: /* $Header: csmudbhb.pls 120.5 2008/03/24 08:58:35 ptomar ship $ */
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 15: g_object_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_PKG'; -- package name

11: -- --------- ------ ------------------------------------------
12: -- Melvin P 08/05/03 Create
13:
14: /*** Globals ***/
15: g_object_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_PKG'; -- package name
16: g_pub_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS'; -- publication item name
17: g_debug_level NUMBER; -- debug level
18:
19: CURSOR c_debrief_headers( b_user_name VARCHAR2, b_tranid NUMBER) is

Line 188: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;
191: ELSE
192: -- successful insert...need to reject the record on client

Line 196: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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:
199: CSM_UTIL_PKG.REJECT_RECORD
200: (

Line 216: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
218: ELSE
219: /*** Reject unsuccessful ***/
220: CSM_UTIL_PKG.LOG

Line 223: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
225:
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: return;

Line 235: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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:
238: CSM_UTIL_PKG.REJECT_RECORD
239: (

Line 255: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
257: ELSE
258: /*** Reject unsuccessful ***/
259: CSM_UTIL_PKG.LOG

Line 262: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
264:
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: return;

Line 276: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '

272: -- SERVER_WINS profile value
273: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS) AND
274: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN
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;

Line 339: || ' for PK ' || r_deb_head.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;
342: end if;
343: END IF;

Line 358: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );

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

Line 486: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

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;
489: END IF;
490:

Line 539: || ' for PK ' || p_record.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

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
542: (
543: p_message => 'CSM_DML_OPERATION'

Line 554: ( 'Exception occurred in CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD:' || ' ' || sqlerrm

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

Line 555: || ' for PK ' || p_record.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );

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);
558: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
559: (

Line 642: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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;
645: END IF;
646: END IF;

Line 669: || ' for PK ' || r_debrief_headers.debrief_header_id,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

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
672: (
673: p_user_name

Line 689: || ' for PK ' || r_debrief_headers.debrief_header_id ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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;
692: END IF;
693: END IF;

Line 701: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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;
704:
705: FUNCTION CONFLICT_RESOLUTION_METHOD (p_user_name IN VARCHAR2,

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 ;

Line 741: END CSM_DEBRIEF_HEADERS_PKG;

737: WHEN OTHERS THEN
738: RETURN 'C';
739: END CONFLICT_RESOLUTION_METHOD;
740:
741: END CSM_DEBRIEF_HEADERS_PKG;