187: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
188: || ' ROOT ERROR: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource'
189: || ' for PK ' || p_record.TASK_ID || l_msg_data,
190: g_object_name || '.APPLY_INSERT',
191: FND_LOG.LEVEL_ERROR );
192: END IF;
193: ELSE
194: l_owner_type := csm_profile_pkg.value_specific('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE', p_record.created_by);
195: l_owner_id := csm_profile_pkg.value_specific('INC_DEFAULT_INCIDENT_TASK_OWNER', p_record.created_by);
261: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
262: || ' ROOT ERROR: jtf_tasks_pub.Create_Task'
263: || ' for PK ' || p_record.TASK_ID,
264: g_object_name || '.APPLY_INSERT',
265: FND_LOG.LEVEL_ERROR );
266: RETURN ;
267: END IF;
268:
269: -- success
273: WHEN others THEN
274: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
275: || ' for PK ' || p_record.task_id,
276: g_object_name || '.APPLY_INSERT',
277: FND_LOG.LEVEL_EXCEPTION );
278:
279: x_return_status := FND_API.G_RET_STS_ERROR;
280:
281: END APPLY_INSERT;
332: CLOSE c_last_update_date;
333: CSM_UTIL_PKG.log( 'Record has stale data. Leaving ' || g_object_name || '.APPLY_INSERT:'
334: || ' for PK ' || p_record.task_id,
335: g_object_name || '.APPLY_INSERT',
336: FND_LOG.LEVEL_PROCEDURE );
337: fnd_message.set_name
338: ( 'JTM'
339: , 'JTM_STALE_DATA'
340: );
344: END IF;
345: ELSE
346: CSM_UTIL_PKG.log( 'No record found in Apps Database in ' || g_object_name || '.APPLY_INSERT:',
347: g_object_name || '.APPLY_INSERT',
348: FND_LOG.LEVEL_PROCEDURE );
349: END IF;
350: CLOSE c_last_update_date;
351: END IF;
352:
422: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
423: || ' ROOT ERROR: jtf_tasks_pub.UPDATE_TASK'
424: || ' for PK ' || p_record.TASK_ID,
425: g_object_name || '.APPLY_UPDATE',
426: FND_LOG.LEVEL_ERROR );
427: RETURN ;
428: END IF;
429:
430: -- success
434: WHEN others THEN
435: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
436: || ' for PK ' || p_record.task_id,
437: g_object_name || '.APPLY_UPDATE',
438: FND_LOG.LEVEL_EXCEPTION );
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: END APPLY_UPDATE;
483: CSM_UTIL_PKG.LOG
484: ( 'Delete and Update is not supported for this entity'
485: || ' for PK ' || p_record.task_id ,
486: g_object_name || '.APPLY_RECORD',
487: FND_LOG.LEVEL_ERROR);
488:
489: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
490: (
491: p_message => 'CSM_DML_OPERATION'
502: CSM_UTIL_PKG.LOG
503: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
504: || ' for PK ' || p_record.task_id ,
505: g_object_name || '.APPLY_RECORD',
506: FND_LOG.LEVEL_EXCEPTION);
507: -- temp -- find more detail --remove comment
508: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
509: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
510: (
535: BEGIN
536: csm_util_pkg.log
537: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
538: g_object_name || '.APPLY_CLIENT_CHANGES',
539: FND_LOG.LEVEL_PROCEDURE);
540: g_debug_level := p_debug_level;
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: /*** loop through tasks records in inqueue ***/
605: CSM_UTIL_PKG.LOG
606: ( 'Deleting from inqueue failed, rolling back to savepoint'
607: || ' for PK ' || r_tasks.task_id ,
608: g_object_name || '.APPLY_CLIENT_CHANGES',
609: FND_LOG.LEVEL_ERROR); -- put PK column here
610: ROLLBACK TO save_rec;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: END IF;
613: END IF;
618: CSM_UTIL_PKG.LOG
619: ( 'Record not processed successfully, deferring and rejecting record'
620: || ' for PK ' || r_tasks.task_id ,
621: g_object_name || '.APPLY_CLIENT_CHANGES',
622: FND_LOG.LEVEL_ERROR); -- put PK column here
623:
624: CSM_UTIL_PKG.DEFER_RECORD
625: ( p_user_name
626: , p_tranid
639: CSM_UTIL_PKG.LOG
640: ( 'Defer record failed, rolling back to savepoint'
641: || ' for PK ' || r_tasks.task_id ,
642: g_object_name || '.APPLY_CLIENT_CHANGES',
643: FND_LOG.LEVEL_ERROR); -- put PK column here
644: ROLLBACK TO save_rec;
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647: END IF;
652: /*** catch and log exceptions ***/
653: CSM_UTIL_PKG.LOG
654: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
655: g_object_name || '.APPLY_CLIENT_CHANGES',
656: FND_LOG.LEVEL_EXCEPTION);
657: x_return_status := FND_API.G_RET_STS_ERROR;
658:
659: END APPLY_CLIENT_CHANGES;
660: