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 177: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

173: BEGIN
174:
175: CSM_UTIL_PKG.log( 'Entered APPLY_INSERT for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
176:
177: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
178: G_REJECT_ROW := true;
179:
180: -- validate to check if subinventory code is present
181: IF p_record.issuing_sub_inventory_code IS NULL THEN

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182: p_error_msg := 'Issuing Subinventory Code not present';
183: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'|| ' ROOT ERROR: ' || p_error_msg|| ' for PK ' ||
184: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
185:
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: RETURN;
188: END IF;
189:
190:

Line 225: , p_init_msg_list => FND_API.G_TRUE

221: l_deb_rec.debrief_number := null ;
222:
223: csf_debrief_pub.create_debrief
224: ( p_api_version_number => 1.0
225: , p_init_msg_list => FND_API.G_TRUE
226: , p_commit => FND_API.G_FALSE
227: , p_debrief_rec => l_deb_rec
228: , p_debrief_line_tbl => l_line_tbl
229: , x_debrief_header_id => l_debrief_header_id

Line 226: , p_commit => FND_API.G_FALSE

222:
223: csf_debrief_pub.create_debrief
224: ( p_api_version_number => 1.0
225: , p_init_msg_list => FND_API.G_TRUE
226: , p_commit => FND_API.G_FALSE
227: , p_debrief_rec => l_deb_rec
228: , p_debrief_line_tbl => l_line_tbl
229: , x_debrief_header_id => l_debrief_header_id
230: , x_return_status => x_return_status

Line 235: if x_return_status <> FND_API.G_RET_STS_SUCCESS

231: , x_msg_count => l_msg_count
232: , x_msg_data => l_msg_data
233: );
234: -- This could have failed, so we need to check.
235: if x_return_status <> FND_API.G_RET_STS_SUCCESS
236: then
237: /*** exception occurred in API -> return errmsg ***/
238: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
239: (

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: );
242: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
243: || ' ROOT ERROR: csf_debrief_pub.create_debrief'
244: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: return;
247: end if;
248: end if;
249:

Line 282: , p_init_msg_list => FND_API.G_TRUE

278: -- Call the transact-material API. This API will update
279: -- the on-hand quantity.
280: csp_transactions_pub.transact_material
281: ( p_api_version => 1.0
282: , p_init_msg_list => FND_API.G_TRUE
283: , p_commit => FND_API.G_FALSE
284: , px_transaction_id => l_transaction_id
285: , px_transaction_header_id => l_transaction_header_id
286: , p_inventory_item_id => p_record.inventory_item_id

Line 283: , p_commit => FND_API.G_FALSE

279: -- the on-hand quantity.
280: csp_transactions_pub.transact_material
281: ( p_api_version => 1.0
282: , p_init_msg_list => FND_API.G_TRUE
283: , p_commit => FND_API.G_FALSE
284: , px_transaction_id => l_transaction_id
285: , px_transaction_header_id => l_transaction_header_id
286: , p_inventory_item_id => p_record.inventory_item_id
287: , p_organization_id => p_record.issuing_inventory_org_id

Line 310: if x_return_status <> FND_API.G_RET_STS_SUCCESS

306: , x_msg_data => l_msg_data
307: );
308:
309: -- This could have failed, so we need to log the error.
310: if x_return_status <> FND_API.G_RET_STS_SUCCESS
311: then
312: -- exception occurred in API -> return errmsg
313: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
314: (

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: || ' ROOT ERROR: ' || p_error_msg
389: || ' for PK ' ||p_record.DEBRIEF_LINE_ID,
390: 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
391:
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: RETURN;
394: END IF;
395:
396: l_line_rec.inventory_item_id := l_inventory_item_id;

Line 483: , p_init_msg_list => FND_API.G_TRUE

479: close c_task_obj_code;
480:
481: csf_debrief_pub.create_debrief_lines
482: ( p_api_version_number => 1.0
483: , p_init_msg_list => FND_API.G_TRUE
484: , p_commit => FND_API.G_FALSE
485: , x_return_status => x_return_status
486: , x_msg_count => l_msg_count
487: , x_msg_data => l_msg_data

Line 484: , p_commit => FND_API.G_FALSE

480:
481: csf_debrief_pub.create_debrief_lines
482: ( p_api_version_number => 1.0
483: , p_init_msg_list => FND_API.G_TRUE
484: , p_commit => FND_API.G_FALSE
485: , x_return_status => x_return_status
486: , x_msg_count => l_msg_count
487: , x_msg_data => l_msg_data
488: , p_debrief_header_id => l_debrief_header_id

Line 492: if x_return_status <> FND_API.G_RET_STS_SUCCESS

488: , p_debrief_header_id => l_debrief_header_id
489: , p_debrief_line_tbl => l_line_tbl
490: , p_source_object_type_code => r_task_obj_code.source_object_type_code
491: );
492: if x_return_status <> FND_API.G_RET_STS_SUCCESS
493: then
494: /*** exception occurred in API -> return errmsg ***/
495: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
496: (

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: );
499: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
500: || ' ROOT ERROR: csf_debrief_pub.create_debrief_lines'
501: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: return;
504: end if;
505:
506: -- For a given debrief header check the task Assignment status.

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533: );
534:
535: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
536: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION );
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END APPLY_INSERT;
539:
540: /***
541: This procedure is called by APPLY_CLIENT_CHANGES when an inserted record is to be processed.

Line 598: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

594: l_debrief_line_id NUMBER;
595: BEGIN
596: CSM_UTIL_PKG.log( 'Entered APPLY_UPDATE for debrief_line_id'|| p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
597:
598: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
599: G_REJECT_ROW := FALSE;
600:
601: -- validate to check if subinventory code is present
602: IF p_record.issuing_sub_inventory_code IS NULL THEN

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: || ' ROOT ERROR: ' || p_error_msg
606: || ' for PK ' ||
607: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
608:
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: RETURN;
611: END IF;
612:
613: if P_RECORD.DEBRIEF_HEADER_ID is null then

Line 633: x_return_status := FND_API.G_RET_STS_ERROR;

629: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
630: || ' ROOT ERROR: ' || p_error_msg
631: || ' for PK ' ||
632: p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: RETURN;
635: END IF;
636: --check for the stale data
637: -- SERVER_WINS profile value

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

637: -- SERVER_WINS profile value
638: IF(fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE)
639: = csm_profile_pkg.g_SERVER_WINS) THEN
640: IF(r_cdl.last_update_date <> p_record.server_last_update_date) THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: p_error_msg :=
643: 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE: P_KEY = '
644: || p_record.debrief_line_id;
645: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: || ' ROOT ERROR: ' || p_error_msg
731: || ' for PK ' ||p_record.DEBRIEF_LINE_ID,
732: 'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
733:
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: RETURN;
736: END IF;
737:
738: l_line_rec.inventory_item_id := l_inventory_item_id;

Line 827: , p_init_msg_list => FND_API.G_TRUE

823:
824: -- Update the debrief line
825: csf_debrief_pub.update_debrief_line
826: ( p_api_version_number => 1.0
827: , p_init_msg_list => FND_API.G_TRUE
828: , p_commit => FND_API.G_FALSE
829: , x_return_status => x_return_status
830: , x_msg_count => l_msg_count
831: , x_msg_data => l_msg_data

Line 828: , p_commit => FND_API.G_FALSE

824: -- Update the debrief line
825: csf_debrief_pub.update_debrief_line
826: ( p_api_version_number => 1.0
827: , p_init_msg_list => FND_API.G_TRUE
828: , p_commit => FND_API.G_FALSE
829: , x_return_status => x_return_status
830: , x_msg_count => l_msg_count
831: , x_msg_data => l_msg_data
832: , p_debrief_line_rec => l_line_rec

Line 835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

831: , x_msg_data => l_msg_data
832: , p_debrief_line_rec => l_line_rec
833: );
834:
835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
836: THEN
837: /*** exception occurred in API -> return errmsg ***/
838: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error=> TRUE);
839: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

838: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error=> TRUE);
839: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
840: || ' ROOT ERROR: csf_debrief_pub.update_debrief_line'
841: || ' for PK ' || p_record.DEBRIEF_LINE_ID, 'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: RETURN;
844: END IF;
845:
846: -- For a given debrief header check the task Assignment status.

Line 869: x_return_status := FND_API.G_RET_STS_ERROR;

865: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
866: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE);
867: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
868: || ' for PK ' || p_record.DEBRIEF_LINE_ID,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION );
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: END APPLY_UPDATE;
871:
872:
873: /***

Line 884: x_return_status := FND_API.G_RET_STS_SUCCESS;

880: x_return_status IN out nocopy VARCHAR2
881: ) IS
882: BEGIN
883: /*** initialize return status and message list ***/
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885: FND_MSG_PUB.INITIALIZE;
886:
887: IF p_record.dmltype$$='I' THEN
888: -- Process insert

Line 916: x_return_status := FND_API.G_RET_STS_SUCCESS;

912: , p_token_name1 => 'DML'
913: , p_token_value1 => p_record.dmltype$$
914: );
915:
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917: END IF;
918:
919: EXCEPTION WHEN OTHERS THEN
920: /*** defer record when any process exception occurs ***/

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: (
928: p_api_error => TRUE
929: );
930:
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: END APPLY_RECORD;
933:
934: /***
935: This procedure is called by CSM_UTIL_PKG when publication item

Line 959: x_return_status := FND_API.G_RET_STS_SUCCESS;

955:
956: csm_util_pkg.log('csm_debrief_parts_pkg.apply_client_changes entered','CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);
957:
958: g_debug_level := p_debug_level;
959: x_return_status := FND_API.G_RET_STS_SUCCESS;
960:
961: /*** loop through debrief parts records in inqueue ***/
962: IF p_task_assignment_id IS NULL THEN
963: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name

Line 986: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

982: , l_process_status
983: );
984:
985: /*** was record processed successfully? ***/
986: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
987: /*** Yes -> delete record from inqueue ***/
988: if G_REJECT_ROW then --IF insert then reject the record as new line id has to be downloaded
989: CSM_UTIL_PKG.REJECT_RECORD
990: ( p_user_name,

Line 999: IF (l_process_status = FND_API.G_RET_STS_SUCCESS AND --When reapplying rejet row will not call delete

995: g_pub_name,
996: l_error_msg,
997: l_process_status
998: );
999: IF (l_process_status = FND_API.G_RET_STS_SUCCESS AND --When reapplying rejet row will not call delete
1000: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_debrief_parts.seqno$$)=FND_API.G_TRUE) THEN
1001: CSM_UTIL_PKG.DELETE_RECORD
1002: ( p_user_name,
1003: p_tranid,

Line 1000: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_debrief_parts.seqno$$)=FND_API.G_TRUE) THEN

996: l_error_msg,
997: l_process_status
998: );
999: IF (l_process_status = FND_API.G_RET_STS_SUCCESS AND --When reapplying rejet row will not call delete
1000: ASG_DEFER.is_deferred(p_user_name,p_tranid,g_pub_name,r_debrief_parts.seqno$$)=FND_API.G_TRUE) THEN
1001: CSM_UTIL_PKG.DELETE_RECORD
1002: ( p_user_name,
1003: p_tranid,
1004: r_debrief_parts.seqno$$,

Line 1025: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

1021: l_process_status
1022: );
1023: END IF;
1024: /*** was delete successful? ***/
1025: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
1026: /*** no -> rollback ***/
1027: CSM_UTIL_PKG.LOG
1028: ( 'Deleting from inqueue failed, rolling back to savepoint'
1029: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 1031: x_return_status := FND_API.G_RET_STS_ERROR;

1027: CSM_UTIL_PKG.LOG
1028: ( 'Deleting from inqueue failed, rolling back to savepoint'
1029: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here
1030: ROLLBACK TO save_rec;
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: END IF;
1033: END IF;
1034:
1035: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1035: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: END IF;
1033: END IF;
1034:
1035: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
1036: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
1037: CSM_UTIL_PKG.LOG
1038: ( 'Record not processed successfully, deferring and rejecting record'
1039: || ' for PK ' || r_debrief_parts.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR ); -- put PK column here

Line 1055: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

1051: , r_debrief_parts.dmltype$$
1052: );
1053:
1054: /*** Was defer successful? ***/
1055: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
1056: /*** no -> rollback ***/
1057: CSM_UTIL_PKG.LOG
1058: ( 'Defer record failed, rolling back to savepoint'
1059: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057: CSM_UTIL_PKG.LOG
1058: ( 'Defer record failed, rolling back to savepoint'
1059: || ' for PK ' || r_debrief_parts.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
1060: ROLLBACK TO save_rec;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: END IF;
1063: END IF;
1064:
1065: END LOOP;

Line 1073: x_return_status := FND_API.G_RET_STS_ERROR;

1069: /*** catch and log exceptions ***/
1070: CSM_UTIL_PKG.LOG
1071: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm
1072: ,'CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: END APPLY_CLIENT_CHANGES;
1075: END CSM_DEBRIEF_PARTS_PKG;