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 FND_API

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

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.
116: -- We need to know if a debrief header record has been made
117: -- form this task_assignment_id. In that case we have to

Line 171: , p_init_msg_list => FND_API.G_TRUE

167: l_deb_rec.TRAVEL_DISTANCE_IN_KM := p_record.TRAVEL_DISTANCE_IN_KM;
168: -- Create a debrief header.
169: csf_debrief_pub.create_debrief
170: ( p_api_version_number => 1.0
171: , p_init_msg_list => FND_API.G_TRUE
172: , p_commit => FND_API.G_FALSE
173: , p_debrief_rec => l_deb_rec
174: , p_debrief_line_tbl => l_line_tbl
175: , x_debrief_header_id => l_debrief_header_id

Line 172: , p_commit => FND_API.G_FALSE

168: -- Create a debrief header.
169: csf_debrief_pub.create_debrief
170: ( p_api_version_number => 1.0
171: , p_init_msg_list => FND_API.G_TRUE
172: , p_commit => FND_API.G_FALSE
173: , p_debrief_rec => l_deb_rec
174: , p_debrief_line_tbl => l_line_tbl
175: , x_debrief_header_id => l_debrief_header_id
176: , x_return_status => x_return_status

Line 182: if x_return_status <> FND_API.G_RET_STS_SUCCESS

178: , x_msg_data => l_msg_data
179: );
180:
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: (

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

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
196: -- as debrief_header_id and debrief_number are generated by the API

Line 214: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

210: l_msg_data,
211: x_return_status
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

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

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;
231: END IF;
232: end if;
233: ELSE

Line 253: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

249: l_msg_data,
250: x_return_status
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

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

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;
270: END IF;
271:
272: -- check for conflict detection

Line 277: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN

273: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
274:
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;

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

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;
284: END IF;
285: ELSE -- client wins

Line 324: p_init_msg_list => FND_API.G_TRUE,

320:
321: -- update the debrief line
322: csf_debrief_pub.Update_debrief(
323: p_api_version_number => 1.0,
324: p_init_msg_list => FND_API.G_TRUE,
325: p_commit => FND_API.G_FALSE,
326: p_debrief_rec => l_deb_rec,
327: X_Return_Status => x_return_status,
328: X_Msg_Count => l_msg_count,

Line 325: p_commit => FND_API.G_FALSE,

321: -- update the debrief line
322: csf_debrief_pub.Update_debrief(
323: p_api_version_number => 1.0,
324: p_init_msg_list => FND_API.G_TRUE,
325: p_commit => FND_API.G_FALSE,
326: p_debrief_rec => l_deb_rec,
327: X_Return_Status => x_return_status,
328: X_Msg_Count => l_msg_count,
329: X_Msg_Data => l_msg_data

Line 333: if x_return_status <> FND_API.G_RET_STS_SUCCESS

329: X_Msg_Data => l_msg_data
330: );
331:
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: (

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: END IF;
347: END IF;
348:
349: -- success
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: exception
353: when others then
354: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);

Line 362: x_return_status := FND_API.G_RET_STS_ERROR;

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:
366: PROCEDURE APPLY_UPDATE

Line 407: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN

403:
404: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
405:
406: IF l_profile_value = 'SERVER_WINS' AND
407: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN
408: OPEN c_debrief_header(b_debrief_header_id => p_record.debrief_header_id, b_task_assignment_id => p_record.task_assignment_id);
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

Line 422: x_return_status := FND_API.G_RET_STS_ERROR;

418: ( 'JTM'
419: , 'JTM_STALE_DATA'
420: );
421: fnd_msg_pub.ADD;
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:',

Line 473: p_init_msg_list => FND_API.G_TRUE,

469:
470: -- update the debrief line
471: csf_debrief_pub.Update_debrief(
472: p_api_version_number => 1.0,
473: p_init_msg_list => FND_API.G_TRUE,
474: p_commit => FND_API.G_FALSE,
475: p_debrief_rec => l_deb_rec,
476: X_Return_Status => x_return_status,
477: X_Msg_Count => l_msg_count,

Line 474: p_commit => FND_API.G_FALSE,

470: -- update the debrief line
471: csf_debrief_pub.Update_debrief(
472: p_api_version_number => 1.0,
473: p_init_msg_list => FND_API.G_TRUE,
474: p_commit => FND_API.G_FALSE,
475: p_debrief_rec => l_deb_rec,
476: X_Return_Status => x_return_status,
477: X_Msg_Count => l_msg_count,
478: X_Msg_Data => l_msg_data

Line 482: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

478: X_Msg_Data => l_msg_data
479: );
480:
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: (

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

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:
496: -- success

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: RETURN;
494: END IF;
495:
496: -- success
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:'

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: || ' for PK ' || p_record.debrief_header_id,
503: g_object_name || '.APPLY_UPDATE',
504: FND_LOG.LEVEL_EXCEPTION );
505:
506: x_return_status := FND_API.G_RET_STS_ERROR;
507:
508: END APPLY_UPDATE;
509:
510: /***

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517: x_return_status IN out nocopy VARCHAR2
518: ) IS
519: BEGIN
520: /*** initialize return status and message list ***/
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: FND_MSG_PUB.INITIALIZE;
523:
524: IF p_record.dmltype$$='I' THEN
525: -- Process insert

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: , p_token_name1 => 'DML'
550: , p_token_value1 => p_record.dmltype$$
551: );
552:
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: END IF;
555:
556: EXCEPTION WHEN OTHERS THEN
557: /*** defer record when any process exception occurs ***/

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564: (
565: p_api_error => TRUE
566: );
567:
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

Line 594: x_return_status := FND_API.G_RET_STS_SUCCESS;

590: c_cur c_curtype;
591: r_debrief_headers c_debrief_headers%rowtype;
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 ***/

Line 623: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

619: , l_process_status
620: );
621:
622: /*** was record processed successfully? ***/
623: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
624: -- check to see if any notes exist for the debrief_header
625: -- if exists update source_object_id column to new value for debrief_header_id
626:
627: OPEN c_debrief(r_debrief_headers.task_assignment_id);

Line 660: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

656: l_process_status
657: );
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

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

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;
669:
670: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 670: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

666: x_return_status := FND_API.G_RET_STS_ERROR;
667: END IF;
668: END IF;
669:
670: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
671: OPEN c_debrief(r_debrief_headers.task_assignment_id);
672: FETCH c_debrief INTO l_debrief_header_id;
673: IF c_debrief%FOUND THEN
674: FOR r_debrief_notes IN c_debrief_notes(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP

Line 707: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

703: , r_debrief_headers.dmltype$$
704: );
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

Line 713: x_return_status := FND_API.G_RET_STS_ERROR;

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;
716:
717: END LOOP;

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

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,
729: p_tran_id IN NUMBER,