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.12020000.2 2013/04/09 11:02:46 saradhak 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: g_processed_assignment_list ASG_DOWNLOAD.ACCESS_LIST;
19:

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 191: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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

Line 199: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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:
202: CSM_UTIL_PKG.REJECT_RECORD
203: (

Line 219: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
221: ELSE
222: /*** Reject unsuccessful ***/
223: CSM_UTIL_PKG.LOG

Line 226: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
228:
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: return;

Line 238: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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:
241: CSM_UTIL_PKG.REJECT_RECORD
242: (

Line 258: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
260: ELSE
261: /*** Reject unsuccessful ***/
262: CSM_UTIL_PKG.LOG

Line 265: ,'CSM_DEBRIEF_HEADERS_PKG.APPLY_INSERT'

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
267:
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: return;

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

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

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

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;
345: end if;
346: END IF;

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

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

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 491: || ' for PK ' || p_record.DEBRIEF_HEADER_ID,'CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

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;
494: END IF;
495:

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

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
547: (
548: p_message => 'CSM_DML_OPERATION'

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

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

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

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

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

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;
667: END IF;
668: END IF;

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

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
694: (
695: p_user_name

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

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;
714: END IF;
715: END IF;

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

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

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 ;

Line 764: END CSM_DEBRIEF_HEADERS_PKG;

760: WHEN OTHERS THEN
761: RETURN 'C';
762: END CONFLICT_RESOLUTION_METHOD;
763:
764: END CSM_DEBRIEF_HEADERS_PKG;