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_LABOR_PKG dependencies on FND_API

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: l_msg_count number;
88:
89: BEGIN
90:
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: -- Start with some initialization.
94: -- We need to know if a debrief header record has been made
95: -- form this task_assignment_id. In that case we have to

Line 134: , p_init_msg_list => FND_API.G_TRUE

130: l_deb_rec.debrief_number := null ;
131:
132: csf_debrief_pub.create_debrief
133: ( p_api_version_number => 1.0
134: , p_init_msg_list => FND_API.G_TRUE
135: , p_commit => FND_API.G_FALSE
136: , p_debrief_rec => l_deb_rec
137: , p_debrief_line_tbl => l_line_tbl
138: , x_debrief_header_id => l_debrief_header_id

Line 135: , p_commit => FND_API.G_FALSE

131:
132: csf_debrief_pub.create_debrief
133: ( p_api_version_number => 1.0
134: , p_init_msg_list => FND_API.G_TRUE
135: , p_commit => FND_API.G_FALSE
136: , p_debrief_rec => l_deb_rec
137: , p_debrief_line_tbl => l_line_tbl
138: , x_debrief_header_id => l_debrief_header_id
139: , x_return_status => x_return_status

Line 144: if x_return_status <> FND_API.G_RET_STS_SUCCESS

140: , x_msg_count => l_msg_count
141: , x_msg_data => l_msg_data
142: );
143: -- This could have failed, so we need to check.
144: if x_return_status <> FND_API.G_RET_STS_SUCCESS
145: then
146: /*** exception occurred in API -> return errmsg ***/
147: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
148: (

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150: );
151: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
152: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
153: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: return;
156: end if;
157: end if;
158:

Line 215: , p_init_msg_list => FND_API.G_TRUE

211: close c_task_obj_code;
212:
213: csf_debrief_pub.create_debrief_lines
214: ( p_api_version_number => 1.0
215: , p_init_msg_list => FND_API.G_TRUE
216: , p_commit => FND_API.G_FALSE
217: , x_return_status => x_return_status
218: , x_msg_count => l_msg_count
219: , x_msg_data => l_msg_data

Line 216: , p_commit => FND_API.G_FALSE

212:
213: csf_debrief_pub.create_debrief_lines
214: ( p_api_version_number => 1.0
215: , p_init_msg_list => FND_API.G_TRUE
216: , p_commit => FND_API.G_FALSE
217: , x_return_status => x_return_status
218: , x_msg_count => l_msg_count
219: , x_msg_data => l_msg_data
220: , p_debrief_header_id => l_debrief_header_id

Line 224: if x_return_status <> FND_API.G_RET_STS_SUCCESS

220: , p_debrief_header_id => l_debrief_header_id
221: , p_debrief_line_tbl => l_line_tbl
222: , p_source_object_type_code => r_task_obj_code.source_object_type_code
223: );
224: if x_return_status <> FND_API.G_RET_STS_SUCCESS
225: then
226: /*** exception occurred in API -> return errmsg ***/
227: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
228: (

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230: );
231: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
232: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
233: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_LABOR_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: return;
236: end if;
237:
238: -- For a given debrief header check the task Assignment status.

Line 267: x_return_status := FND_API.G_RET_STS_ERROR;

263: (
264: p_api_error => TRUE
265: );
266:
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: END APPLY_INSERT;
269:
270: /***
271: This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

300:
301:
302: BEGIN
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: -- Lookup the debrief_header id. It must be there as this is an update
307: -- of a line.
308: OPEN c_cdl

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359: -- SERVER_WINS profile value
360: if(fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE)
361: = csm_profile_pkg.g_SERVER_WINS) then
362: if(r_cdl.last_update_date <> p_record.server_last_update_date) then
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: p_error_msg :=
365: 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE: P_KEY = '
366: || p_record.debrief_line_id;
367: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

Line 377: , p_init_msg_list => FND_API.G_TRUE

373:
374: -- Update the debrief line
375: csf_debrief_pub.update_debrief_line
376: ( p_api_version_number => 1.0
377: , p_init_msg_list => FND_API.G_TRUE
378: , p_commit => FND_API.G_FALSE
379: , x_return_status => x_return_status
380: , x_msg_count => l_msg_count
381: , x_msg_data => l_msg_data

Line 378: , p_commit => FND_API.G_FALSE

374: -- Update the debrief line
375: csf_debrief_pub.update_debrief_line
376: ( p_api_version_number => 1.0
377: , p_init_msg_list => FND_API.G_TRUE
378: , p_commit => FND_API.G_FALSE
379: , x_return_status => x_return_status
380: , x_msg_count => l_msg_count
381: , x_msg_data => l_msg_data
382: , p_debrief_line_rec => l_line_rec

Line 384: if x_return_status <> FND_API.G_RET_STS_SUCCESS

380: , x_msg_count => l_msg_count
381: , x_msg_data => l_msg_data
382: , p_debrief_line_rec => l_line_rec
383: );
384: if x_return_status <> FND_API.G_RET_STS_SUCCESS
385: then
386: /*** exception occurred in API -> return errmsg ***/
387: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
388: (

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390: );
391: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
392: || ' ROOT ERROR: csf_debrief_pub.update_debrief_lines'
393: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: return;
396: end if;
397:
398: exception

Line 409: x_return_status := FND_API.G_RET_STS_ERROR;

405:
406: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
407: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_LABOR_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
408:
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: END APPLY_UPDATE;
411:
412:
413: /***

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS;

420: x_return_status IN OUT NOCOPY VARCHAR2
421: ) IS
422: BEGIN
423: /*** initialize return status and message list ***/
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425: FND_MSG_PUB.INITIALIZE;
426:
427: IF p_record.dmltype$$='I' THEN
428: -- Process insert

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: , p_token_name1 => 'DML'
453: , p_token_value1 => p_record.dmltype$$
454: );
455:
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: END IF;
458:
459: EXCEPTION WHEN OTHERS THEN
460: /*** defer record when any process exception occurs ***/

Line 471: x_return_status := FND_API.G_RET_STS_ERROR;

467: (
468: p_api_error => TRUE
469: );
470:
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: END APPLY_RECORD;
473:
474: /***
475: This procedure is called by CSM_UTIL_PKG when publication item

Line 493: x_return_status := FND_API.G_RET_STS_SUCCESS;

489: l_error_msg VARCHAR2(4000);
490: BEGIN
491: csm_util_pkg.log('csm_debrief_labor_pkg.apply_client_changes entered','CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
492: g_debug_level := p_debug_level;
493: x_return_status := FND_API.G_RET_STS_SUCCESS;
494:
495: /*** loop through debrief labor records in inqueue ***/
496: FOR r_debrief_labor IN c_debrief_labor( p_user_name, p_tranid) LOOP
497:

Line 509: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

505: , l_process_status
506: );
507:
508: /*** was record processed successfully? ***/
509: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
510: /*** Yes -> delete record from inqueue ***/
511:
512: CSM_UTIL_PKG.DELETE_RECORD
513: (

Line 525: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

521: l_process_status
522: );
523:
524: /*** was delete successful? ***/
525: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
526: /*** no -> rollback ***/
527: CSM_UTIL_PKG.LOG
528: ( 'Deleting from inqueue failed, rolling back to savepoint'
529: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 531: x_return_status := FND_API.G_RET_STS_ERROR;

527: CSM_UTIL_PKG.LOG
528: ( 'Deleting from inqueue failed, rolling back to savepoint'
529: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
530: ROLLBACK TO save_rec;
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: END IF;
534:
535: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 535: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

531: x_return_status := FND_API.G_RET_STS_ERROR;
532: END IF;
533: END IF;
534:
535: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
536: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
537: CSM_UTIL_PKG.LOG
538: ( 'Record not processed successfully, deferring and rejecting record'
539: || ' for PK ' || r_debrief_labor.debrief_line_id ,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

551: , r_debrief_labor.dmltype$$
552: );
553:
554: /*** Was defer successful? ***/
555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
556: /*** no -> rollback ***/
557: CSM_UTIL_PKG.LOG
558: ( 'Defer record failed, rolling back to savepoint'
559: || ' for PK ' || r_debrief_labor.debrief_line_id,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 561: x_return_status := FND_API.G_RET_STS_ERROR;

557: CSM_UTIL_PKG.LOG
558: ( 'Defer record failed, rolling back to savepoint'
559: || ' for PK ' || r_debrief_labor.debrief_line_id,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
560: ROLLBACK TO save_rec;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: END IF;
563: END IF;
564:
565: END LOOP;

Line 571: x_return_status := FND_API.G_RET_STS_ERROR;

567: EXCEPTION WHEN OTHERS THEN
568: /*** catch and log exceptions ***/
569: CSM_UTIL_PKG.LOG
570: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,'CSM_DEBRIEF_LABOR_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: END APPLY_CLIENT_CHANGES;
573:
574: END CSM_DEBRIEF_LABOR_PKG;