DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on FND_API

Line 144: -- x_return_status := FND_API.G_RET_STS_ERROR ;

140: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
141: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC',FND_LOG.LEVEL_EVENT);
142: p_status := 'ERROR';
143: p_message := 'Error in CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC: ' || l_error_msg;
144: -- x_return_status := FND_API.G_RET_STS_ERROR ;
145: -- RAISE;
146: END PURGE_TASK_ASSIGNMENTS_CONC;
147:
148: PROCEDURE SPAWN_DEBRIEF_HEADER_INS (p_task_assignment_id IN NUMBER,

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: l_TaskAssgDetails_rec l_TaskAssgDetails_csr%ROWTYPE;
551: l_TaskAssgDetails_null_rec l_TaskAssgDetails_csr%ROWTYPE;
552:
553: BEGIN
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
556: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
557:
558: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: EXCEPTION
714: WHEN OTHERS THEN
715: l_sqlerrno := to_char(SQLCODE);
716: l_sqlerrmsg := substr(SQLERRM, 1,2000);
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: p_error_msg := ' Exception in TASK_ASSIGNMENT_INITIALIZER for task_assignment_id:' || to_char(p_task_assignment_id)
719: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
720: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);
721: RAISE;

Line 793: x_return_status := FND_API.G_RET_STS_SUCCESS;

789: l_TaskAssgDetails_rec l_TaskAssgDetails_csr%ROWTYPE;
790: l_TaskAssgDetails_null_rec l_TaskAssgDetails_csr%ROWTYPE;
791:
792: BEGIN
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id
795: || ' and parent_incident_id: ' || p_parent_incident_id,
796: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);
797:

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885: EXCEPTION
886: WHEN OTHERS THEN
887: l_sqlerrno := to_char(SQLCODE);
888: l_sqlerrmsg := substr(SQLERRM, 1,2000);
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_INIT for task_assignment_id:' || p_task_assignment_id
891: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
892: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
893: RAISE;

Line 1505: x_return_status := FND_API.G_RET_STS_SUCCESS;

1501: l_TaskAssgHistPurge_rec l_TaskAssgHistPurge_csr%ROWTYPE;
1502: l_TaskAssgHistPurge_null_rec l_TaskAssgHistPurge_csr%ROWTYPE;
1503:
1504: BEGIN
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id
1507: || ' and parent_incident_id: ' || p_parent_incident_id,
1508: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1509:

Line 1596: x_return_status := FND_API.G_RET_STS_ERROR;

1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: l_sqlerrno := to_char(SQLCODE);
1595: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id:' || p_task_assignment_id
1598: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1599: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1600: RAISE;