DBA Data[Home] [Help]

APPS.CS_SR_CHILD_AUDIT_PKG dependencies on FND_API

Line 521: p_validation_level => fnd_api.g_valid_level_none,

517: CS_ServiceRequest_pvt.Update_ServiceRequest(
518: p_api_version => 4.0,
519: p_init_msg_list => 'T',
520: p_commit => 'T',
521: p_validation_level => fnd_api.g_valid_level_none,
522: x_return_status => l_return_status,
523: x_msg_count => l_msg_count,
524: x_msg_data => l_msg_data,
525: p_request_id => l_incident_id,

Line 579: p_validation_level => fnd_api.g_valid_level_none,

575: CS_WF_EVENT_PKG.RAISE_SERVICEREQUEST_EVENT(
576: p_api_version => l_api_version,
577: p_init_msg_list => 'T',
578: p_commit => 'T',
579: p_validation_level => fnd_api.g_valid_level_none,
580: p_event_code => 'UPDATE_SERVICE_REQUEST',
581: p_incident_number => l_incident_number,
582: p_user_id => l_last_updated_by,
583: p_resp_id => NULL,

Line 695: x_return_status := FND_API.G_RET_STS_SUCCESS;

691:
692: BEGIN
693:
694: --Added initilization of return status to Success --anmukher --09/12/03
695: x_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: -- Compare SR last Modified date with the entity date and update if entity date is later
698:
699: OPEN get_sr_date ;

Line 768: IF (p_owner_group_id IS NOT NULL AND p_owner_group_id<>FND_API.G_MISS_NUM)

764: l_audit_vals_rec.old_group_id := l_service_request_rec.OWNER_GROUP_ID ;
765: l_audit_vals_rec.group_id := l_service_request_rec.OWNER_GROUP_ID ;
766: END IF;
767:
768: IF (p_owner_group_id IS NOT NULL AND p_owner_group_id<>FND_API.G_MISS_NUM)
769: THEN
770: l_audit_vals_rec.group_type:='RS_GROUP';
771: ELSE
772: l_audit_vals_rec.group_type:=NULL;

Line 1256: p_init_msg_list => FND_API.G_FALSE ,

1252: -- Call CS_ServiceRequest_PVT.Create_Audit_Record API to create SR Audit record.
1253:
1254: CS_ServiceRequest_PVT.Create_Audit_Record (
1255: p_api_version => 2.0,
1256: p_init_msg_list => FND_API.G_FALSE ,
1257: p_commit => FND_API.G_FALSE ,
1258: p_request_id => p_incident_id ,
1259: p_audit_id => null ,
1260: p_audit_vals_rec => l_audit_vals_rec ,

Line 1257: p_commit => FND_API.G_FALSE ,

1253:
1254: CS_ServiceRequest_PVT.Create_Audit_Record (
1255: p_api_version => 2.0,
1256: p_init_msg_list => FND_API.G_FALSE ,
1257: p_commit => FND_API.G_FALSE ,
1258: p_request_id => p_incident_id ,
1259: p_audit_id => null ,
1260: p_audit_vals_rec => l_audit_vals_rec ,
1261: p_user_id => NVL(p_user_id,FND_GLOBAL.USER_ID),

Line 1269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1265: x_msg_count => x_msg_count ,
1266: x_msg_data => x_msg_data ,
1267: x_audit_id => x_audit_id );
1268:
1269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1270: RAISE e_create_audit_failed ;
1271: END IF ;
1272:
1273: CLOSE get_sr_date;

Line 1278: x_return_status := FND_API.G_RET_STS_ERROR;

1274:
1275: EXCEPTION
1276: WHEN e_create_audit_failed THEN
1277: CLOSE get_sr_date;
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279:
1280: WHEN SR_Lock_Row THEN
1281: IF (get_sr_date%ISOPEN) THEN
1282: CLOSE get_sr_date;

Line 1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1280: WHEN SR_Lock_Row THEN
1281: IF (get_sr_date%ISOPEN) THEN
1282: CLOSE get_sr_date;
1283: END IF;
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1285: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
1286: FND_MSG_PUB.ADD;
1287: FND_MSG_PUB.Count_And_Get
1288: ( p_count => x_msg_count,

Line 1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1292: WHEN others THEN
1293: CLOSE get_sr_date;
1294: l_text := sqlerrm ;
1295: l_num := sqlcode ;
1296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1297:
1298: END CS_SR_AUDIT_CHILD;
1299:
1300: -- Added for status update --anmukher -- 10/16/03