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 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: l_TaskAssgDetails_null_rec l_TaskAssgDetails_csr%ROWTYPE;
561: l_htm5_user boolean:=false;
562:
563: BEGIN
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
566: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
567:
568: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755: EXCEPTION
756: WHEN OTHERS THEN
757: l_sqlerrno := to_char(SQLCODE);
758: l_sqlerrmsg := substr(SQLERRM, 1,2000);
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: p_error_msg := ' Exception in TASK_ASSIGNMENT_INITIALIZER for task_assignment_id:' || to_char(p_task_assignment_id)
761: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
762: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);
763: RAISE;

Line 835: x_return_status := FND_API.G_RET_STS_SUCCESS;

831: l_TaskAssgDetails_rec l_TaskAssgDetails_csr%ROWTYPE;
832: l_TaskAssgDetails_null_rec l_TaskAssgDetails_csr%ROWTYPE;
833:
834: BEGIN
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id
837: || ' and parent_incident_id: ' || p_parent_incident_id,
838: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);
839:

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: EXCEPTION
928: WHEN OTHERS THEN
929: l_sqlerrno := to_char(SQLCODE);
930: l_sqlerrmsg := substr(SQLERRM, 1,2000);
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_INIT for task_assignment_id:' || p_task_assignment_id
933: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
934: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
935: RAISE;

Line 1577: x_return_status := FND_API.G_RET_STS_SUCCESS;

1573: l_TaskAssgHistPurge_rec l_TaskAssgHistPurge_csr%ROWTYPE;
1574: l_TaskAssgHistPurge_null_rec l_TaskAssgHistPurge_csr%ROWTYPE;
1575:
1576: BEGIN
1577: x_return_status := FND_API.G_RET_STS_SUCCESS;
1578: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id
1579: || ' and parent_incident_id: ' || p_parent_incident_id,
1580: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1581:

Line 1668: x_return_status := FND_API.G_RET_STS_ERROR;

1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: l_sqlerrno := to_char(SQLCODE);
1667: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id:' || p_task_assignment_id
1670: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1671: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1672: RAISE;