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

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: BEGIN
90:
91: CSM_UTIL_PKG.log( 'Entered APPLY_INSERT for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: -- Start with some initialization.
96: -- We need to know if a debrief header record has been made
97: -- form this task_assignment_id. In that case we have to

Line 135: , p_init_msg_list => FND_API.G_TRUE

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

Line 136: , p_commit => FND_API.G_FALSE

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

Line 146: if x_return_status <> FND_API.G_RET_STS_SUCCESS

142: , x_msg_data => l_msg_data
143: );
144:
145: -- This could have failed, so we need to check.
146: if x_return_status <> FND_API.G_RET_STS_SUCCESS
147: THEN
148: csm_util_pkg.log('ABCD Test 03');
149: /*** exception occurred in API -> return errmsg ***/
150: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 216: , p_init_msg_list => FND_API.G_TRUE

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

Line 217: , p_commit => FND_API.G_FALSE

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

Line 225: if x_return_status <> FND_API.G_RET_STS_SUCCESS

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

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: p_api_error => TRUE
263: );
264: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
265: || ' for PK ' || p_record.DEBRIEF_LINE_ID ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: END APPLY_INSERT;
268:
269: /***
270: This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: BEGIN
302:
303: CSM_UTIL_PKG.log( 'Entered APPLY_UPDATE for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
304:
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: -- Lookup the debrief_header id. It must be there as this is an update
308: -- of a line.
309: OPEN c_cdl

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

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

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 396: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 426: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 458: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 473: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 498: x_return_status := FND_API.G_RET_STS_SUCCESS;

494: c_cur c_curtype;
495: r_debrief_expenses c_debrief_expenses%rowtype;
496: BEGIN
497: g_debug_level := p_debug_level;
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: csm_util_pkg.log('csm_debrief_expenses_pkg.apply_client_changes entered','CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
501:
502: /*** loop through debrief expenses records in inqueue ***/

Line 527: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

523: , l_process_status
524: );
525:
526: /*** was record processed successfully? ***/
527: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
528: /*** Yes -> delete record from inqueue ***/
529:
530: CSM_UTIL_PKG.DELETE_RECORD
531: (

Line 543: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

539: l_process_status
540: );
541:
542: /*** was delete successful? ***/
543: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
544: /*** no -> rollback ***/
545: CSM_UTIL_PKG.LOG
546: ( 'Deleting from inqueue failed, rolling back to savepoint'
547: || ' for PK ' || r_debrief_expenses.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: CSM_UTIL_PKG.LOG
546: ( 'Deleting from inqueue failed, rolling back to savepoint'
547: || ' for PK ' || r_debrief_expenses.debrief_line_id ,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
548: ROLLBACK TO save_rec;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: END IF;
552:
553: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 553: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: END IF;
552:
553: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
554: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
555: CSM_UTIL_PKG.LOG
556: ( 'Record not processed successfully, deferring and rejecting record'
557: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 573: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

569: , r_debrief_expenses.dmltype$$
570: );
571:
572: /*** Was defer successful? ***/
573: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
574: /*** no -> rollback ***/
575: CSM_UTIL_PKG.LOG
576: ( 'Defer record failed, rolling back to savepoint'
577: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: CSM_UTIL_PKG.LOG
576: ( 'Defer record failed, rolling back to savepoint'
577: || ' for PK ' || r_debrief_expenses.debrief_line_id,'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
578: ROLLBACK TO save_rec;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: END IF;
581: END IF;
582:
583: END LOOP;

Line 591: x_return_status := FND_API.G_RET_STS_ERROR;

587: /*** catch and log exceptions ***/
588: CSM_UTIL_PKG.LOG
589: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
590: 'CSM_DEBRIEF_EXPENSES_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION );
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: END APPLY_CLIENT_CHANGES;
593:
594: END CSM_DEBRIEF_EXPENSES_PKG;