DBA Data[Home] [Help]

APPS.CSM_TASKS_PKG dependencies on FND_LOG

Line 185: FND_LOG.LEVEL_ERROR );

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

Line 263: FND_LOG.LEVEL_ERROR );

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

Line 275: FND_LOG.LEVEL_EXCEPTION );

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;

Line 334: FND_LOG.LEVEL_PROCEDURE );

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

Line 346: FND_LOG.LEVEL_PROCEDURE );

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:

Line 423: FND_LOG.LEVEL_ERROR );

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

Line 435: FND_LOG.LEVEL_EXCEPTION );

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;

Line 484: FND_LOG.LEVEL_ERROR);

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'

Line 503: FND_LOG.LEVEL_EXCEPTION);

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: (

Line 536: FND_LOG.LEVEL_PROCEDURE);

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 ***/

Line 590: FND_LOG.LEVEL_ERROR); -- put PK column here

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;

Line 603: FND_LOG.LEVEL_ERROR); -- put PK column here

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

Line 624: FND_LOG.LEVEL_ERROR); -- put PK column here

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;

Line 637: FND_LOG.LEVEL_EXCEPTION);

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: