181: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
182: || ' ROOT ERROR: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource'
183: || ' for PK ' || p_record.TASK_ID || l_msg_data,
184: g_object_name || '.APPLY_INSERT',
185: FND_LOG.LEVEL_ERROR );
186: END IF;
187: ELSE
188: l_owner_type := csm_profile_pkg.value_specific('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE', p_record.created_by);
189: l_owner_id := csm_profile_pkg.value_specific('INC_DEFAULT_INCIDENT_TASK_OWNER', p_record.created_by);
259: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
260: || ' ROOT ERROR: jtf_tasks_pub.Create_Task'
261: || ' for PK ' || p_record.TASK_ID,
262: g_object_name || '.APPLY_INSERT',
263: FND_LOG.LEVEL_ERROR );
264: RETURN ;
265: END IF;
266:
267: -- success
271: WHEN others THEN
272: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
273: || ' for PK ' || p_record.task_id,
274: g_object_name || '.APPLY_INSERT',
275: FND_LOG.LEVEL_EXCEPTION );
276:
277: x_return_status := FND_API.G_RET_STS_ERROR;
278:
279: END APPLY_INSERT;
330: CLOSE c_last_update_date;
331: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_INSERT:'
332: || ' for PK ' || p_record.task_id,
333: g_object_name || '.APPLY_INSERT',
334: FND_LOG.LEVEL_PROCEDURE );
335: fnd_message.set_name
336: ( 'JTM'
337: , 'JTM_STALE_DATA'
338: );
342: END IF;
343: ELSE
344: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_INSERT:',
345: g_object_name || '.APPLY_INSERT',
346: FND_LOG.LEVEL_PROCEDURE );
347: END IF;
348: CLOSE c_last_update_date;
349: END IF;
350:
419: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
420: || ' ROOT ERROR: jtf_tasks_pub.UPDATE_TASK'
421: || ' for PK ' || p_record.TASK_ID,
422: g_object_name || '.APPLY_UPDATE',
423: FND_LOG.LEVEL_ERROR );
424: RETURN ;
425: END IF;
426:
427: -- success
431: WHEN others THEN
432: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
433: || ' for PK ' || p_record.task_id,
434: g_object_name || '.APPLY_UPDATE',
435: FND_LOG.LEVEL_EXCEPTION );
436:
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: END APPLY_UPDATE;
480: CSM_UTIL_PKG.LOG
481: ( 'Delete and Update is not supported for this entity'
482: || ' for PK ' || p_record.task_id ,
483: g_object_name || '.APPLY_RECORD',
484: FND_LOG.LEVEL_ERROR);
485:
486: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
487: (
488: p_message => 'CSM_DML_OPERATION'
499: CSM_UTIL_PKG.LOG
500: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
501: || ' for PK ' || p_record.task_id ,
502: g_object_name || '.APPLY_RECORD',
503: FND_LOG.LEVEL_EXCEPTION);
504: -- temp -- find more detail --remove comment
505: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
506: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
507: (
532: BEGIN
533: csm_util_pkg.log
534: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
535: g_object_name || '.APPLY_CLIENT_CHANGES',
536: FND_LOG.LEVEL_PROCEDURE);
537: g_debug_level := p_debug_level;
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: /*** loop through tasks records in inqueue ***/
586: CSM_UTIL_PKG.LOG
587: ( 'Deleting from inqueue failed, rolling back to savepoint'
588: || ' for PK ' || r_tasks.task_id ,
589: g_object_name || '.APPLY_CLIENT_CHANGES',
590: FND_LOG.LEVEL_ERROR); -- put PK column here
591: ROLLBACK TO save_rec;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: END IF;
594: END IF;
599: CSM_UTIL_PKG.LOG
600: ( 'Record not processed successfully, deferring and rejecting record'
601: || ' for PK ' || r_tasks.task_id ,
602: g_object_name || '.APPLY_CLIENT_CHANGES',
603: FND_LOG.LEVEL_ERROR); -- put PK column here
604:
605: CSM_UTIL_PKG.DEFER_RECORD
606: ( p_user_name
607: , p_tranid
620: CSM_UTIL_PKG.LOG
621: ( 'Defer record failed, rolling back to savepoint'
622: || ' for PK ' || r_tasks.task_id ,
623: g_object_name || '.APPLY_CLIENT_CHANGES',
624: FND_LOG.LEVEL_ERROR); -- put PK column here
625: ROLLBACK TO save_rec;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: END IF;
633: /*** catch and log exceptions ***/
634: CSM_UTIL_PKG.LOG
635: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
636: g_object_name || '.APPLY_CLIENT_CHANGES',
637: FND_LOG.LEVEL_EXCEPTION);
638: x_return_status := FND_API.G_RET_STS_ERROR;
639:
640: END APPLY_CLIENT_CHANGES;
641: