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 205: IF FND_API.To_Boolean(p_init_msg_list) THEN

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

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 211: l_grp_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 212: l_main_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 218: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 361: RAISE FND_API.G_EXC_ERROR;

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

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 380: WHEN FND_API.G_EXC_ERROR THEN

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

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: WHERE hzp.contact_point_id = c_customer_phone_id;
446:
447: BEGIN
448: -- Initialize API return status to success
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: -- Proceed even if the group_type is null
452: l_incident_id := p_incident_id;
453:

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

582: );
583:
584: n := l_Assign_Groups_tbl.FIRST;
585:
586: IF (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
587: IF (l_Assign_Groups_tbl.exists(n)) THEN
588: x_group_id := l_Assign_Groups_tbl(n).resource_id;
589: x_group_type := l_Assign_Groups_tbl(n).resource_type;
590: x_territory_id := l_Assign_Groups_tbl(n).terr_id ;

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

600: -- This Procedure returns the individual Owner from the Group
601: -- returned by the Assign_Group Procedure.
602: **************************************************************/
603: PROCEDURE Assign_Owner
604: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_incident_id IN NUMBER,
607: p_total_emp IN NUMBER,
608: p_party_name IN VARCHAR2,

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

601: -- returned by the Assign_Group Procedure.
602: **************************************************************/
603: PROCEDURE Assign_Owner
604: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
605: p_commit IN VARCHAR2 := FND_API.G_FALSE,
606: p_incident_id IN NUMBER,
607: p_total_emp IN NUMBER,
608: p_party_name IN VARCHAR2,
609: p_param_resource_type IN VARCHAR2,

Line 661: x_return_status := FND_API.G_RET_STS_SUCCESS;

657:
658: BEGIN
659:
660: -- Initialize API return status to success
661: x_return_status := FND_API.G_RET_STS_SUCCESS;
662:
663: -- Proceed even if the group_id is null
664: -- l_group_id := p_group_id ;
665:

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

793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data
795: );
796:
797: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
798: p := l_Assign_Owner_tbl.FIRST ;
799: IF (l_Assign_Owner_tbl.COUNT >= 1) THEN
800: x_resource_id := l_Assign_Owner_tbl(p).resource_id ;
801: x_resource_type := l_Assign_Owner_tbl(p).resource_type ;