eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CUG_PREVENT_SR_UPDATE_PKG dependencies on FND_API

Line 22: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

18: -- Enter procedure, function bodies as shown below
19:
20: PROCEDURE Update_ServiceRequest_Prevent
21: ( p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
23: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
24: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,

Line 23: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

19:
20: PROCEDURE Update_ServiceRequest_Prevent
21: ( p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
23: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
24: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,

Line 24: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

20: PROCEDURE Update_ServiceRequest_Prevent
21: ( p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
23: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
24: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_request_id IN NUMBER,

Line 36: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

32: p_last_updated_by IN NUMBER,
33: p_last_update_login IN NUMBER DEFAULT NULL,
34: p_last_update_date IN DATE,
35: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
36: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_notes IN CS_ServiceRequest_PVT.notes_table,
38: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
39: p_audit_comments IN VARCHAR2 DEFAULT NULL,
40: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 40: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

36: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_notes IN CS_ServiceRequest_PVT.notes_table,
38: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
39: p_audit_comments IN VARCHAR2 DEFAULT NULL,
40: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
41: p_workflow_process_id IN NUMBER DEFAULT NULL,
42: x_workflow_process_id OUT NOCOPY NUMBER,
43: x_interaction_id OUT NOCOPY NUMBER
44: )

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: FETCH l_CurrentServiceRequest_csr INTO l_CurrentServiceRequest_rec;
127:
128:
129: IF (l_CurrentServiceRequest_csr%NOTFOUND) THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132: CLOSE l_CurrentServiceRequest_csr;
133:
134: l_request_number := l_CurrentServiceRequest_rec.incident_number;

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138: OPEN l_WFDetails_csr;
139: FETCH l_WFDetails_csr into l_WFDetails_rec;
140: IF (l_WFDetails_csr%NOTFOUND) THEN
141: -- start for bug 2802879 ignoring the situation when no workflow is associated
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143: return;
144: --end for bug 2802879
145: ELSE
146: l_end_date := l_WFDetails_rec.end_date;

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: IF (l_WFActivityDetails_csr%NOTFOUND) THEN
151: null;
152: ELSE
153: IF( l_WFActivityDetails_rec.activity_end_date is null) THEN
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155: return;
156: END IF;
157: END IF;
158: END IF;

Line 174: RAISE FND_API.G_EXC_ERROR;

170: THEN
171: FND_MESSAGE.Set_Name('CUG', 'CUG_SR_UPDATE_NOT_ALLOWED');
172: -- FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
173: FND_MSG_PUB.Add;
174: RAISE FND_API.G_EXC_ERROR;
175:
176: -- Begin of changes by ANEEMUCH date 20-May-2002
177: -- removed check from install_site_use_id as incident address is part of service request
178: /*

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: OPEN l_IncidentDetails_csr;
181: FETCH l_IncidentDetails_csr INTO l_IncidentDetails_rec;
182:
183: IF (l_IncidentDetails_csr%NOTFOUND) THEN
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: ELSE
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: FND_MESSAGE.Set_Name('CUG', 'CUG_SR_UPDATE_NOT_ALLOWED');
188: -- FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182:
183: IF (l_IncidentDetails_csr%NOTFOUND) THEN
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: ELSE
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: FND_MESSAGE.Set_Name('CUG', 'CUG_SR_UPDATE_NOT_ALLOWED');
188: -- FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
189: FND_MSG_PUB.Add;
190: RAISE FND_API.G_EXC_ERROR;

Line 190: RAISE FND_API.G_EXC_ERROR;

186: x_return_status := FND_API.G_RET_STS_ERROR;
187: FND_MESSAGE.Set_Name('CUG', 'CUG_SR_UPDATE_NOT_ALLOWED');
188: -- FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
189: FND_MSG_PUB.Add;
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: CLOSE l_IncidentDetails_csr;
193: */
194:

Line 204: x_return_status := FND_API.G_RET_STS_ERROR;

200: l_incident_province <> l_CurrentServiceRequest_rec.incident_province or
201: l_incident_postal_code <> l_CurrentServiceRequest_rec.incident_postal_code or
202: l_incident_country <> l_CurrentServiceRequest_rec.incident_country) THEN
203:
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.Set_Name('CUG', 'CUG_INC_ADDR_UPD_NOT_ALLOWED');
206: FND_MSG_PUB.Add;
207: RAISE FND_API.G_EXC_ERROR;
208:

Line 207: RAISE FND_API.G_EXC_ERROR;

203:
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.Set_Name('CUG', 'CUG_INC_ADDR_UPD_NOT_ALLOWED');
206: FND_MSG_PUB.Add;
207: RAISE FND_API.G_EXC_ERROR;
208:
209: -- End of changes by ANEEMUCH date 20-May-2002
210:
211: END IF;

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210:
211: END IF;
212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count,
218: p_data => x_msg_data

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: END IF;
212:
213: EXCEPTION
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count,
218: p_data => x_msg_data
219: );

Line 220: WHEN FND_API.G_EXC_ERROR THEN

216: FND_MSG_PUB.Count_And_Get
217: ( p_count => x_msg_count,
218: p_data => x_msg_data
219: );
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,
224: p_data => x_msg_data

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: ( p_count => x_msg_count,
218: p_data => x_msg_data
219: );
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,
224: p_data => x_msg_data
225: );