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 CSM_UTIL_PKG

Line 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);

171: l_mat_billable_flag VARCHAR2(30);
172: l_uom_code VARCHAR2(3);
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:

Line 183: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'|| ' ROOT ERROR: ' || p_error_msg|| ' for PK ' ||

179:
180: -- validate to check if subinventory code is present
181: IF p_record.issuing_sub_inventory_code IS NULL THEN
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;

Line 238: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
240: p_api_error => TRUE
241: );
242: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 242: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

238: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
239: (
240: p_api_error => TRUE
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;

Line 313: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
315: p_api_error => TRUE
316: );
317: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '

Line 317: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '

313: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
314: (
315: p_api_error => TRUE
316: );
317: CSM_UTIL_PKG.log('Error in CSF_DEBRIEF_PARTS_PKG.APPLY_INSERT: '
318: || 'Root cause csp_transactions_pub.transact_material failed: '
319: || 'for Debrief Line Id: ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
320:
321: l_spare_update_status := 'FAILED';

Line 335: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN

331: CLOSE c_csm_user_details;
332:
333: --Get the value for Free Form profile
334: --For HTML5 user profile value defaulted to 'Y'
335: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN
336: l_freeform := 'Y';
337: ELSE
338: l_freeform := fnd_profile.value_specific('CSM_FREE_FORM_ITEM');
339: END IF;

Line 363: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN --for html5 INSTANCE NUMBER is passed in free form item.

359: l_mat_billable_flag := r_serial_item.MATERIAL_BILLABLE_FLAG;
360:
361: ELSE -- If Free Form Item is present
362:
363: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN --for html5 INSTANCE NUMBER is passed in free form item.
364: OPEN c_instance_item(p_record.FREE_FORM_ITEM, l_CS_INV_ORG_ID);
365: FETCH c_instance_item INTO r_instance_item;
366: CLOSE c_instance_item;
367: l_inventory_item_id := r_instance_item.inventory_item_id;

Line 387: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

383:
384: --Return if the item is invalid
385: IF l_inventory_item_id IS NULL THEN
386: p_error_msg := 'Item entered through Free form is Invalid.Please check if the item is valid in the Service Inventory Validation org.';
387: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
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:

Line 495: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
497: p_api_error => TRUE
498: );
499: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 499: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

495: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
496: (
497: p_api_error => TRUE
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;

Line 530: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

526:
527: exception
528: when others then
529: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
530: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
531: (
532: p_api_error => TRUE
533: );
534:

Line 535: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

531: (
532: p_api_error => TRUE
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:

Line 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);

592: l_mat_billable_flag VARCHAR2(30);
593: L_UOM_CODE varchar2(3);
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:

Line 604: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

600:
601: -- validate to check if subinventory code is present
602: IF p_record.issuing_sub_inventory_code IS NULL THEN
603: p_error_msg := 'Issuing Subinventory Code not present';
604: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
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:

Line 629: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

625:
626: -- validation for valid Debrief header id
627: IF l_debrief_header_id IS NULL THEN
628: p_error_msg := 'The Debrief Header is Missing for the Given Debrief lind id.Please verify';
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;

Line 645: csm_util_pkg.log(p_error_msg,'CSM_DEBRIEF_PARTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

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);
646: RETURN;
647: END IF;
648: END IF;
649:

Line 676: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN

672: CLOSE c_csm_user_details;
673:
674: --Get the value for Free Form profile
675: --For HTML5 user profile value defaulted to 'Y'
676: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN
677: l_freeform := 'Y';
678: ELSE
679: l_freeform := fnd_profile.value_specific('CSM_FREE_FORM_ITEM');
680: END IF;

Line 705: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN --for html5 INSTANCE NUMBER is passed in free form item.

701: l_mat_billable_flag := r_serial_item.MATERIAL_BILLABLE_FLAG;
702:
703: ELSE -- If Free Form Item is present
704:
705: IF (CSM_UTIL_PKG.is_html5_user(p_record.clid$$cs)) THEN --for html5 INSTANCE NUMBER is passed in free form item.
706: OPEN c_instance_item(p_record.FREE_FORM_ITEM, l_CS_INV_ORG_ID);
707: FETCH c_instance_item INTO r_instance_item;
708: CLOSE c_instance_item;
709: l_inventory_item_id := r_instance_item.inventory_item_id;

Line 729: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

725:
726: --Return if the item is invalid
727: IF l_inventory_item_id IS NULL THEN
728: p_error_msg := 'Item entered through Free form is Invalid.Please check if the item is valid in the Service Inventory Validation org.';
729: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
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:

Line 838: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error=> TRUE);

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:'
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;

Line 839: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

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:'
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;

Line 866: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE);

862:
863: EXCEPTION
864: WHEN OTHERS THEN
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;

Line 867: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

863: EXCEPTION
864: WHEN OTHERS THEN
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:

Line 905: CSM_UTIL_PKG.LOG

901: x_return_status
902: );
903: ELSE
904: -- Process delete ; not supported for this entity
905: CSM_UTIL_PKG.LOG
906: ( 'Delete is not supported for this entity'
907: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
908:
909: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 909: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

905: CSM_UTIL_PKG.LOG
906: ( 'Delete is not supported for this entity'
907: || ' for PK ' || p_record.debrief_line_id ,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
908:
909: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
910: (
911: p_message => 'CSM_DML_OPERATION'
912: , p_token_name1 => 'DML'
913: , p_token_value1 => p_record.dmltype$$

Line 921: CSM_UTIL_PKG.LOG

917: END IF;
918:
919: EXCEPTION WHEN OTHERS THEN
920: /*** defer record when any process exception occurs ***/
921: CSM_UTIL_PKG.LOG
922: ( 'Exception occurred in CSM_DEBRIEF_parts_PKG.APPLY_RECORD:' || ' ' || sqlerrm
923: || ' for PK ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
924:
925: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);

Line 926: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

922: ( 'Exception occurred in CSM_DEBRIEF_parts_PKG.APPLY_RECORD:' || ' ' || sqlerrm
923: || ' for PK ' || p_record.debrief_line_id,'CSM_DEBRIEF_PARTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION );
924:
925: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
926: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
927: (
928: p_api_error => TRUE
929: );
930:

Line 935: This procedure is called by CSM_UTIL_PKG when publication item

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
936: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
937: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
938: public APIs.
939: ***/

Line 956: csm_util_pkg.log('csm_debrief_parts_pkg.apply_client_changes entered','CSM_DEBRIEF_PARTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR);

952: c_cur c_curtype;
953: r_debrief_parts c_debrief_parts%rowtype;
954: BEGIN
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:

Line 964: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';

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
964: ||''' AND TASK_ASSIGNMENT_ID NOT IN ('||CSM_UTIL_PKG.get_String_fromList(g_processed_assignment_list)||')';
965: ELSE
966: g_processed_assignment_list(g_processed_assignment_list.COUNT+1):=p_task_assignment_id;
967: OPEN c_cur FOR 'SELECT * FROM csf_m_debrief_parts_inq WHERE tranid$$ = '||p_tranid||' AND clid$$cs = '''||p_user_name
968: ||''' AND TASK_ASSIGNMENT_ID='||p_task_assignment_id;

Line 989: CSM_UTIL_PKG.REJECT_RECORD

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,
991: p_tranid,
992: r_debrief_parts.seqno$$,
993: r_debrief_parts.debrief_line_id,

Line 1001: CSM_UTIL_PKG.DELETE_RECORD

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$$,
1005: r_debrief_parts.debrief_line_id,

Line 1013: CSM_UTIL_PKG.DELETE_RECORD

1009: l_process_status
1010: );
1011: end if;
1012: ELSE
1013: CSM_UTIL_PKG.DELETE_RECORD
1014: ( p_user_name,
1015: p_tranid,
1016: r_debrief_parts.seqno$$,
1017: r_debrief_parts.debrief_line_id,

Line 1027: CSM_UTIL_PKG.LOG

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
1030: ROLLBACK TO save_rec;
1031: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1037: CSM_UTIL_PKG.LOG

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
1040:
1041: CSM_UTIL_PKG.DEFER_RECORD

Line 1041: CSM_UTIL_PKG.DEFER_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
1040:
1041: CSM_UTIL_PKG.DEFER_RECORD
1042: (
1043: p_user_name
1044: , p_tranid
1045: , r_debrief_parts.seqno$$

Line 1057: CSM_UTIL_PKG.LOG

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
1060: ROLLBACK TO save_rec;
1061: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1070: CSM_UTIL_PKG.LOG

1066: CLOSE c_cur;
1067:
1068: EXCEPTION WHEN OTHERS THEN
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;