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

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: l_spare_update_status csf_debrief_lines.spare_update_status%TYPE;
118:
119: BEGIN
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: -- validate to check if subinventory code is present
124: IF p_record.issuing_sub_inventory_code IS NULL THEN
125: p_error_msg := 'Issuing Subinventory Code not present';

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: || ' ROOT ERROR: ' || p_error_msg
128: || ' for PK ' ||
129: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
130:
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RETURN;
133: END IF;
134:
135:

Line 173: , p_init_msg_list => FND_API.G_TRUE

169: l_deb_rec.debrief_number := null ;
170:
171: csf_debrief_pub.create_debrief
172: ( p_api_version_number => 1.0
173: , p_init_msg_list => FND_API.G_TRUE
174: , p_commit => FND_API.G_FALSE
175: , p_debrief_rec => l_deb_rec
176: , p_debrief_line_tbl => l_line_tbl
177: , x_debrief_header_id => l_debrief_header_id

Line 174: , p_commit => FND_API.G_FALSE

170:
171: csf_debrief_pub.create_debrief
172: ( p_api_version_number => 1.0
173: , p_init_msg_list => FND_API.G_TRUE
174: , p_commit => FND_API.G_FALSE
175: , p_debrief_rec => l_deb_rec
176: , p_debrief_line_tbl => l_line_tbl
177: , x_debrief_header_id => l_debrief_header_id
178: , x_return_status => x_return_status

Line 183: if x_return_status <> FND_API.G_RET_STS_SUCCESS

179: , x_msg_count => l_msg_count
180: , x_msg_data => l_msg_data
181: );
182: -- This could have failed, so we need to check.
183: if x_return_status <> FND_API.G_RET_STS_SUCCESS
184: then
185: /*** exception occurred in API -> return errmsg ***/
186: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
187: (

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: );
190: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
191: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
192: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: return;
195: end if;
196: end if;
197:

Line 230: , p_init_msg_list => FND_API.G_TRUE

226: -- Call the transact-material API. This API will update
227: -- the on-hand quantity.
228: csp_transactions_pub.transact_material
229: ( p_api_version => 1.0
230: , p_init_msg_list => FND_API.G_TRUE
231: , p_commit => FND_API.G_FALSE
232: , px_transaction_id => l_transaction_id
233: , px_transaction_header_id => l_transaction_header_id
234: , p_inventory_item_id => p_record.inventory_item_id

Line 231: , p_commit => FND_API.G_FALSE

227: -- the on-hand quantity.
228: csp_transactions_pub.transact_material
229: ( p_api_version => 1.0
230: , p_init_msg_list => FND_API.G_TRUE
231: , p_commit => FND_API.G_FALSE
232: , px_transaction_id => l_transaction_id
233: , px_transaction_header_id => l_transaction_header_id
234: , p_inventory_item_id => p_record.inventory_item_id
235: , p_organization_id => p_record.issuing_inventory_org_id

Line 258: if x_return_status <> FND_API.G_RET_STS_SUCCESS

254: , x_msg_data => l_msg_data
255: );
256:
257: -- This could have failed, so we need to log the error.
258: if x_return_status <> FND_API.G_RET_STS_SUCCESS
259: then
260: -- exception occurred in API -> return errmsg
261: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
262: (

Line 347: , p_init_msg_list => FND_API.G_TRUE

343: close c_task_obj_code;
344:
345: csf_debrief_pub.create_debrief_lines
346: ( p_api_version_number => 1.0
347: , p_init_msg_list => FND_API.G_TRUE
348: , p_commit => FND_API.G_FALSE
349: , x_return_status => x_return_status
350: , x_msg_count => l_msg_count
351: , x_msg_data => l_msg_data

Line 348: , p_commit => FND_API.G_FALSE

344:
345: csf_debrief_pub.create_debrief_lines
346: ( p_api_version_number => 1.0
347: , p_init_msg_list => FND_API.G_TRUE
348: , p_commit => FND_API.G_FALSE
349: , x_return_status => x_return_status
350: , x_msg_count => l_msg_count
351: , x_msg_data => l_msg_data
352: , p_debrief_header_id => l_debrief_header_id

Line 356: if x_return_status <> FND_API.G_RET_STS_SUCCESS

352: , p_debrief_header_id => l_debrief_header_id
353: , p_debrief_line_tbl => l_line_tbl
354: , p_source_object_type_code => r_task_obj_code.source_object_type_code
355: );
356: if x_return_status <> FND_API.G_RET_STS_SUCCESS
357: then
358: /*** exception occurred in API -> return errmsg ***/
359: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
360: (

Line 366: x_return_status := FND_API.G_RET_STS_ERROR;

362: );
363: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
364: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
365: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: return;
368: end if;
369:
370: -- For a given debrief header check the task Assignment status.

Line 398: x_return_status := FND_API.G_RET_STS_ERROR;

394: );
395:
396: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
397: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: END APPLY_INSERT;
400:
401:
402: /***

Line 413: x_return_status := FND_API.G_RET_STS_SUCCESS;

409: x_return_status IN out nocopy VARCHAR2
410: ) IS
411: BEGIN
412: /*** initialize return status and message list ***/
413: x_return_status := FND_API.G_RET_STS_SUCCESS;
414: FND_MSG_PUB.INITIALIZE;
415:
416: IF p_record.dmltype$$='I' THEN
417: -- Process insert

Line 437: x_return_status := FND_API.G_RET_STS_ERROR;

433: , p_token_name1 => 'DML'
434: , p_token_value1 => p_record.dmltype$$
435: );
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: END IF;
439:
440: EXCEPTION WHEN OTHERS THEN
441: /*** defer record when any process exception occurs ***/

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: (
449: p_api_error => TRUE
450: );
451:
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: END APPLY_RECORD;
454:
455: /***
456: This procedure is called by CSM_UTIL_PKG when publication item

Line 473: x_return_status := FND_API.G_RET_STS_SUCCESS;

469: l_process_status VARCHAR2(1);
470: l_error_msg VARCHAR2(4000);
471: BEGIN
472: g_debug_level := p_debug_level;
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475:
476:
477: /*** loop through debrief parts records in inqueue ***/

Line 491: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

487: , l_process_status
488: );
489:
490: /*** was record processed successfully? ***/
491: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
492: /*** Yes -> delete record from inqueue ***/
493:
494: CSM_UTIL_PKG.DELETE_RECORD
495: (

Line 507: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

503: l_process_status
504: );
505:
506: /*** was delete successful? ***/
507: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
508: /*** no -> rollback ***/
509: CSM_UTIL_PKG.LOG
510: ( 'Deleting from inqueue failed, rolling back to savepoint'
511: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509: CSM_UTIL_PKG.LOG
510: ( 'Deleting from inqueue failed, rolling back to savepoint'
511: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
512: ROLLBACK TO save_rec;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515: END IF;
516:
517: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 517: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515: END IF;
516:
517: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
518: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
519: CSM_UTIL_PKG.LOG
520: ( 'Record not processed successfully, deferring and rejecting record'
521: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 537: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

533: , r_debrief_parts.dmltype$$
534: );
535:
536: /*** Was defer successful? ***/
537: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
538: /*** no -> rollback ***/
539: CSM_UTIL_PKG.LOG
540: ( 'Defer record failed, rolling back to savepoint'
541: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 543: x_return_status := FND_API.G_RET_STS_ERROR;

539: CSM_UTIL_PKG.LOG
540: ( 'Defer record failed, rolling back to savepoint'
541: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
542: ROLLBACK TO save_rec;
543: x_return_status := FND_API.G_RET_STS_ERROR;
544: END IF;
545: END IF;
546:
547: END LOOP;

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: /*** catch and log exceptions ***/
551: CSM_UTIL_PKG.LOG
552: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
553: ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: END APPLY_CLIENT_CHANGES;
556: END CSM_DEBRIEF_PARTS_PKG;