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.CS_SR_TASK_AUTOASSIGN_PKG dependencies on FND_API

Line 9: (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

5: /***********************
6: Define Local Procedures
7: ***********************/
8: PROCEDURE Assign_Group
9: (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
10: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
11: p_incident_id IN NUMBER,
12: p_total_emp IN NUMBER DEFAULT NULL,
13: p_party_name IN VARCHAR2 DEFAULT NULL,

Line 10: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

6: Define Local Procedures
7: ***********************/
8: PROCEDURE Assign_Group
9: (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
10: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
11: p_incident_id IN NUMBER,
12: p_total_emp IN NUMBER DEFAULT NULL,
13: p_party_name IN VARCHAR2 DEFAULT NULL,
14: p_service_request_rec IN CS_ServiceRequest_PUB.service_request_rec_type,

Line 25: (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

21: x_msg_data OUT NOCOPY VARCHAR2
22: );
23:
24: PROCEDURE Assign_Owner
25: (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
26: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
27: p_incident_id IN NUMBER,
28: p_total_emp IN NUMBER DEFAULT NULL,
29: p_party_name IN VARCHAR2 DEFAULT NULL,

Line 26: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

22: );
23:
24: PROCEDURE Assign_Owner
25: (p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
26: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
27: p_incident_id IN NUMBER,
28: p_total_emp IN NUMBER DEFAULT NULL,
29: p_party_name IN VARCHAR2 DEFAULT NULL,
30: p_param_resource_type IN VARCHAR2,

Line 204: IF FND_API.To_Boolean(p_init_msg_list) THEN

200: l_service_req_rec CS_ServiceRequest_PUB.service_request_rec_type default p_service_request_rec;
201:
202: BEGIN
203: -- Initialize message list if p_init_msg_list is set to TRUE
204: IF FND_API.To_Boolean(p_init_msg_list) THEN
205: FND_MSG_PUB.Initialize;
206: END IF;
207:
208: -- Initialize API return status to success

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: FND_MSG_PUB.Initialize;
206: END IF;
207:
208: -- Initialize API return status to success
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
212: -- Raise Error when both incident_id and the service request record is not
213: -- passed. The service request record is checked for null based on the

Line 210: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;

206: END IF;
207:
208: -- Initialize API return status to success
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
212: -- Raise Error when both incident_id and the service request record is not
213: -- passed. The service request record is checked for null based on the
214: -- incident_type_id. If only incident_id is passed then fetch all the

Line 211: l_main_return_status := FND_API.G_RET_STS_SUCCESS;

207:
208: -- Initialize API return status to success
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_main_return_status := FND_API.G_RET_STS_SUCCESS;
212: -- Raise Error when both incident_id and the service request record is not
213: -- passed. The service request record is checked for null based on the
214: -- incident_type_id. If only incident_id is passed then fetch all the
215: -- territory attributes from cs_incidents_all_b

Line 217: RAISE FND_API.G_EXC_ERROR;

213: -- passed. The service request record is checked for null based on the
214: -- incident_type_id. If only incident_id is passed then fetch all the
215: -- territory attributes from cs_incidents_all_b
216: IF (p_incident_id IS NULL and p_service_request_rec.type_id IS NULL) THEN
217: RAISE FND_API.G_EXC_ERROR;
218: ELSE
219: IF (p_service_request_rec.type_id IS NULL) THEN
220: OPEN c_inc_rec;
221: FETCH c_inc_rec INTO l_inc_rec;

Line 351: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

347: );
348: END IF; -- l_owner_id IS NULL
349: END IF; -- p_incident_id IS NULL
350:
351: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
352: x_owner_id := NULL;
353: x_owner_type := NULL;
354: x_owner_group_id := NULL;
355: x_group_type := NULL;

Line 360: RAISE FND_API.G_EXC_ERROR;

356: FND_MSG_PUB.Initialize;
357: FND_MESSAGE.Set_Name('CS', 'CS_SR_TASK_NO_OWNER');
358: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full);
359: FND_MSG_PUB.Add;
360: RAISE FND_API.G_EXC_ERROR;
361: ELSE
362: IF (l_owner_id IS NULL AND l_group_id IS NULL) THEN
363: -- FND_MSG_PUB.Initialize;
364: FND_MESSAGE.Set_Name('CS', 'CS_SR_TASK_NO_OWNER');

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

363: -- FND_MSG_PUB.Initialize;
364: FND_MESSAGE.Set_Name('CS', 'CS_SR_TASK_NO_OWNER');
365: FND_MESSAGE.Set_Token('API_NAME',l_api_name_full||l_service_req_rec.platform_id);
366: FND_MSG_PUB.Add;
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: ELSE
369: x_owner_id := l_owner_id;
370: x_owner_type := l_resource_type;
371: x_owner_group_id := l_group_id;

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: END IF;
376: END IF;
377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get
382: ( p_count => x_msg_count,
383: p_data => x_msg_data

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: END IF;
377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get
382: ( p_count => x_msg_count,
383: p_data => x_msg_data
384: );

Line 385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

381: FND_MSG_PUB.Count_And_Get
382: ( p_count => x_msg_count,
383: p_data => x_msg_data
384: );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: ( p_count => x_msg_count,
383: p_data => x_msg_data
384: );
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );

Line 398: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

394: /***************************************************
395: -- This Procedure returns the Group if not passed.
396: ***************************************************/
397: PROCEDURE Assign_Group
398: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_incident_id IN NUMBER,
401: p_total_emp IN NUMBER,
402: p_party_name IN VARCHAR2,

Line 399: p_commit IN VARCHAR2 := FND_API.G_FALSE,

395: -- This Procedure returns the Group if not passed.
396: ***************************************************/
397: PROCEDURE Assign_Group
398: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
399: p_commit IN VARCHAR2 := FND_API.G_FALSE,
400: p_incident_id IN NUMBER,
401: p_total_emp IN NUMBER,
402: p_party_name IN VARCHAR2,
403: p_service_request_rec IN CS_Servicerequest_PUB.service_request_rec_type,

Line 468: x_return_status := FND_API.G_RET_STS_SUCCESS;

464:
465: BEGIN
466:
467: -- Initialize API return status to success
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469:
470: -- Proceed even if the group_type is null
471: l_incident_id := p_incident_id;
472:

Line 642: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

638: );
639:
640: n := l_Assign_Groups_tbl.FIRST;
641:
642: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
643: IF (l_Assign_Groups_tbl.exists(n)) THEN
644: x_group_id := l_Assign_Groups_tbl(n).resource_id;
645: x_group_type := l_Assign_Groups_tbl(n).resource_type;
646: x_territory_id := l_Assign_Groups_tbl(n).terr_id ;

Line 660: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

656: -- This Procedure returns the individual Owner from the Group
657: -- returned by the Assign_Group Procedure.
658: **************************************************************/
659: PROCEDURE Assign_Owner
660: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_incident_id IN NUMBER,
663: p_total_emp IN NUMBER,
664: p_party_name IN VARCHAR2,

Line 661: p_commit IN VARCHAR2 := FND_API.G_FALSE,

657: -- returned by the Assign_Group Procedure.
658: **************************************************************/
659: PROCEDURE Assign_Owner
660: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_incident_id IN NUMBER,
663: p_total_emp IN NUMBER,
664: p_party_name IN VARCHAR2,
665: p_param_resource_type IN VARCHAR2,

Line 732: x_return_status := FND_API.G_RET_STS_SUCCESS;

728:
729:
730: BEGIN
731: -- Initialize API return status to success
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: -- Proceed even if the group_id is null
735: -- l_group_id := p_group_id ;
736:

Line 911: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

907: x_msg_data => x_msg_data
908: );
909:
910: --Bug 7168029
911: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
912: p := l_Assign_Owner_tbl.FIRST ;
913:
914: IF (l_Assign_Owner_tbl.COUNT > 1) THEN
915: l_count := l_Assign_Owner_tbl.COUNT;