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_AUTOGEN_TASK_PVT dependencies on FND_API

Line 10: p_uom_code IN varchar2 DEFAULT FND_API.G_MISS_CHAR,

6: -- 12.1.2 SR Task Enhancement project
7: -- Get the Planned End date based on the Profile
8: PROCEDURE Default_Planned_End_Date(p_respond_by IN DATE,
9: p_resolve_by IN DATE,
10: p_uom_code IN varchar2 DEFAULT FND_API.G_MISS_CHAR,
11: p_planned_effort IN Number DEFAULT FND_API.G_MISS_NUM,
12: x_planned_end_date OUT NOCOPY DATE) IS
13:
14: l_profile Varchar2(50);

Line 11: p_planned_effort IN Number DEFAULT FND_API.G_MISS_NUM,

7: -- Get the Planned End date based on the Profile
8: PROCEDURE Default_Planned_End_Date(p_respond_by IN DATE,
9: p_resolve_by IN DATE,
10: p_uom_code IN varchar2 DEFAULT FND_API.G_MISS_CHAR,
11: p_planned_effort IN Number DEFAULT FND_API.G_MISS_NUM,
12: x_planned_end_date OUT NOCOPY DATE) IS
13:
14: l_profile Varchar2(50);
15: l_profile_respond_by Number;

Line 90: l_commit VARCHAR2(30) := fnd_api.g_false;

86: ) IS
87:
88: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';
89: l_return_status VARCHAR2(30) := 'S';
90: l_commit VARCHAR2(30) := fnd_api.g_false;
91: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
92: l_owner_group_id NUMBER ;
93: l_owner_id NUMBER ;
94: l_owner_type VARCHAR2(30) ;

Line 91: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;

87:
88: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';
89: l_return_status VARCHAR2(30) := 'S';
90: l_commit VARCHAR2(30) := fnd_api.g_false;
91: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
92: l_owner_group_id NUMBER ;
93: l_owner_id NUMBER ;
94: l_owner_type VARCHAR2(30) ;
95: l_msg_count NUMBER ;

Line 266: p_init_msg_list => fnd_api.g_false ,

262:
263:
264: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource
265: (p_api_version => 1.0 ,
266: p_init_msg_list => fnd_api.g_false ,
267: p_commit => l_commit ,
268: p_incident_id => p_incident_id ,
269: p_task_attribute_rec => l_task_attribute_rec ,
270: x_owner_group_id => l_owner_group_id ,

Line 280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

276: x_msg_count => x_msg_count ,
277: x_msg_data => x_msg_data );
278:
279:
280: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
281: -- 12.1.3 Task enh proj
282: IF l_owner_id is null or l_owner_type is null Then
283: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER', l_owner_id);
284: FND_PROFILE.Get('INC_DEFAULT_INCIDENT_TASK_OWNER_TYPE', l_owner_type);

Line 380: l_task_template_tbl(i).planned_start_date <> FND_API.G_MISS_DATE)

376:
377: -- The palnned start date and planned end date should appear in pair.
378: -- If not,exception is thrown
379: IF ( ( (l_task_template_tbl(i).planned_start_date IS NOT NULL AND
380: l_task_template_tbl(i).planned_start_date <> FND_API.G_MISS_DATE)
381: AND
382: (l_task_template_tbl(i).planned_end_date IS NULL OR
383: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)
384: )

Line 383: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)

379: IF ( ( (l_task_template_tbl(i).planned_start_date IS NOT NULL AND
380: l_task_template_tbl(i).planned_start_date <> FND_API.G_MISS_DATE)
381: AND
382: (l_task_template_tbl(i).planned_end_date IS NULL OR
383: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)
384: )
385: OR
386: ( (l_task_template_tbl(i).planned_end_date IS NOT NULL AND
387: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)

Line 387: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)

383: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)
384: )
385: OR
386: ( (l_task_template_tbl(i).planned_end_date IS NOT NULL AND
387: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)
388: AND
389: (l_task_template_tbl(i).planned_start_date IS NULL OR
390: l_task_template_tbl(i).planned_start_date = FND_API.G_MISS_DATE)
391: )

Line 390: l_task_template_tbl(i).planned_start_date = FND_API.G_MISS_DATE)

386: ( (l_task_template_tbl(i).planned_end_date IS NOT NULL AND
387: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)
388: AND
389: (l_task_template_tbl(i).planned_start_date IS NULL OR
390: l_task_template_tbl(i).planned_start_date = FND_API.G_MISS_DATE)
391: )
392: )THEN
393:
394: l_task_name := null;

Line 415: p_init_msg_list => fnd_api.g_false ,

411: l_return_status := null ;
412:
413: JTF_TASK_INST_TEMPLATES_PUB.create_task_from_template
414: (p_api_version => 1.0 ,
415: p_init_msg_list => fnd_api.g_false ,
416: p_commit => l_commit ,
417: p_task_template_group_info => l_task_template_group_info,
418: p_task_templates_tbl => l_task_template_tbl,
419: p_task_contact_points_tbl => l_task_contact_points_tbl,

Line 426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

422: x_msg_data => x_msg_data ,
423: x_task_details_tbl => l_task_details_tbl);
424:
425:
426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
427:
428: RAISE e_CreateTask_Exception;
429: ELSE
430: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 430: x_return_status := FND_API.G_RET_STS_SUCCESS ;

426: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
427:
428: RAISE e_CreateTask_Exception;
429: ELSE
430: x_return_status := FND_API.G_RET_STS_SUCCESS ;
431: x_field_service_task_created := l_field_service_task_created ;
432:
433: END IF ;
434:

Line 446: x_return_status := FND_API.G_RET_STS_ERROR ;

442: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_AUTO_ASSIGNMENT_FAIL');
443: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
444: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
445: FND_MSG_PUB.ADD;
446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: WHEN e_party_site_exception THEN
448: OPEN c_get_tgt_name;
449: FETCH c_get_tgt_name INTO l_template_group_name ;
450: CLOSE c_get_tgt_name;

Line 456: x_return_status := FND_API.G_RET_STS_ERROR ;

452: p_data => x_msg_data );
453: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_INVALID_PARTY_SITE');
454: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
455: FND_MSG_PUB.ADD;
456: x_return_status := FND_API.G_RET_STS_ERROR ;
457: WHEN e_Planned_effort_Exception THEN
458: OPEN c_get_tgt_name;
459: FETCH c_get_tgt_name INTO l_template_group_name ;
460: CLOSE c_get_tgt_name;

Line 467: x_return_status := FND_API.G_RET_STS_ERROR ;

463: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_INVALID_PLANNED_EFRT');
464: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
465: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
466: FND_MSG_PUB.ADD;
467: x_return_status := FND_API.G_RET_STS_ERROR ;
468: WHEN e_CreateTask_Exception THEN
469: OPEN c_get_tgt_name;
470: FETCH c_get_tgt_name INTO l_template_group_name ;
471: CLOSE c_get_tgt_name;

Line 478: x_return_status := FND_API.G_RET_STS_ERROR ;

474: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_CREATE_TASK_FAILED');
475: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
476: FND_MSG_PUB.ADD;
477: l_text := sqlcode||'-'||sqlerrm ;
478: x_return_status := FND_API.G_RET_STS_ERROR ;
479: -- Simplex
480: -- The following are the exceptions thrown as a part of the validations done
481: -- for Task State Restrictions
482: WHEN e_date_pair_exception THEN

Line 493: x_return_status := FND_API.G_RET_STS_ERROR ;

489: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
490: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
491: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
492: FND_MSG_PUB.ADD;
493: x_return_status := FND_API.G_RET_STS_ERROR ;
494: WHEN e_planned_effort_val_exception THEN
495: OPEN c_get_tgt_name;
496: FETCH c_get_tgt_name INTO l_template_group_name ;
497: CLOSE c_get_tgt_name;

Line 505: x_return_status := FND_API.G_RET_STS_ERROR ;

501: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
502: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
503: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
504: FND_MSG_PUB.ADD;
505: x_return_status := FND_API.G_RET_STS_ERROR ;
506: -- end of simplex
507: WHEN others THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504: FND_MSG_PUB.ADD;
505: x_return_status := FND_API.G_RET_STS_ERROR ;
506: -- end of simplex
507: WHEN others THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
510: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_level_statement ||' - '||SQLERRM);
511: FND_MSG_PUB.ADD;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 514: x_return_status := FND_API.G_RET_STS_ERROR ;

510: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_level_statement ||' - '||SQLERRM);
511: FND_MSG_PUB.ADD;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
513: p_data => x_msg_data);
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515:
516: END Create_Task_From_Template;
517:
518:

Line 523: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

519:
520: PROCEDURE Get_Task_Template_Group
521: (
522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
524: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
525: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
526: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
527: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,

Line 524: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

520: PROCEDURE Get_Task_Template_Group
521: (
522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
524: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
525: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
526: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
527: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
528: x_return_status OUT NOCOPY VARCHAR2,

Line 525: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

521: (
522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
524: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
525: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
526: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
527: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
528: x_return_status OUT NOCOPY VARCHAR2,
529: x_msg_count OUT NOCOPY NUMBER,

Line 627: IF FND_API.To_Boolean(p_init_msg_list) THEN

623:
624: Begin
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE
627: IF FND_API.To_Boolean(p_init_msg_list) THEN
628: FND_MSG_PUB.Initialize;
629: END IF;
630:
631: -- Standard call to check for call compatibility

Line 632: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

628: FND_MSG_PUB.Initialize;
629: END IF;
630:
631: -- Standard call to check for call compatibility
632: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
633: l_api_name, G_PKG_NAME) THEN
634: FND_MSG_PUB.Count_And_Get(
635: p_count => x_msg_count,
636: p_data => x_msg_data );

Line 638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634: FND_MSG_PUB.Count_And_Get(
635: p_count => x_msg_count,
636: p_data => x_msg_data );
637:
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;
640:
641: -- Initialize API return status to success
642: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 642: x_return_status := FND_API.G_RET_STS_SUCCESS;

638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;
640:
641: -- Initialize API return status to success
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: -- Get all active search rules
645: open c_search_rules;
646:

Line 844: WHEN FND_API.G_EXC_ERROR THEN

840: -- Standard call to get message count and if count is 1, get message info
841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 845: x_return_status := FND_API.G_RET_STS_ERROR;

841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: WHEN FND_API.G_EXC_ERROR THEN
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
851:
852: WHEN OTHERS THEN

Line 849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

845: x_return_status := FND_API.G_RET_STS_ERROR;
846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
851:
852: WHEN OTHERS THEN
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
851:
852: WHEN OTHERS THEN
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: If c_task_template_grp%IsOpen Then
855: close c_task_template_grp;
856: End If;
857: If c_search_rules%IsOpen Then

Line 874: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

870:
871: PROCEDURE Auto_Generate_Tasks
872: (
873: p_api_version IN NUMBER,
874: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
875: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
876: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
877: p_incident_id IN NUMBER,
878: p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,

Line 875: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

871: PROCEDURE Auto_Generate_Tasks
872: (
873: p_api_version IN NUMBER,
874: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
875: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
876: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
877: p_incident_id IN NUMBER,
878: p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,
879: p_task_template_group_owner IN NUMBER,

Line 876: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

872: (
873: p_api_version IN NUMBER,
874: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
875: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
876: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
877: p_incident_id IN NUMBER,
878: p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,
879: p_task_template_group_owner IN NUMBER,
880: p_task_tmpl_group_owner_type IN VARCHAR2,

Line 942: IF FND_API.To_Boolean(p_init_msg_list) THEN

938:
939: SAVEPOINT CS_AutoGen_Task_PVT ;
940:
941: -- Initialize message list if p_init_msg_list is set to TRUE
942: IF FND_API.To_Boolean(p_init_msg_list) THEN
943: FND_MSG_PUB.Initialize;
944: END IF;
945:
946: -- Standard call to check for call compatibility

Line 947: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

943: FND_MSG_PUB.Initialize;
944: END IF;
945:
946: -- Standard call to check for call compatibility
947: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
948: l_api_name, G_PKG_NAME) THEN
949: FND_MSG_PUB.Count_And_Get(
950: p_count => x_msg_count,
951: p_data => x_msg_data );

Line 953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

949: FND_MSG_PUB.Count_And_Get(
950: p_count => x_msg_count,
951: p_data => x_msg_data );
952:
953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
954: END IF;
955:
956: -- Initialize API return status to success
957: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 957: x_return_status := FND_API.G_RET_STS_SUCCESS;

953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
954: END IF;
955:
956: -- Initialize API return status to success
957: x_return_status := FND_API.G_RET_STS_SUCCESS;
958:
959: l_task_template_group_owner := p_task_template_group_owner;
960: l_task_tmpl_group_owner_type := p_task_tmpl_group_owner_type;
961:

Line 1003: p_init_msg_list => fnd_api.g_false,

999:
1000:
1001: CS_Autogen_Task_PVT.Get_Task_Template_Group
1002: ( p_api_version => 1.0,
1003: p_init_msg_list => fnd_api.g_false,
1004: p_commit => p_commit,
1005: p_validation_level => p_validation_level,
1006: p_task_template_search_rec => l_task_template_search_rec,
1007: x_task_template_group_tbl => l_task_template_group_tbl,

Line 1014: If (l_return_status = FND_API.G_RET_STS_ERROR) Then

1010: x_msg_data => x_msg_data
1011: );
1012:
1013:
1014: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
1015: Raise FND_API.G_EXC_ERROR;
1016: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
1017: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1018: End If;

Line 1015: Raise FND_API.G_EXC_ERROR;

1011: );
1012:
1013:
1014: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
1015: Raise FND_API.G_EXC_ERROR;
1016: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
1017: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1018: End If;
1019:

Line 1016: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then

1012:
1013:
1014: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
1015: Raise FND_API.G_EXC_ERROR;
1016: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
1017: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1018: End If;
1019:
1020: -- Check the number of task template groups returned by the Get Task Template Group API

Line 1017: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1013:
1014: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
1015: Raise FND_API.G_EXC_ERROR;
1016: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
1017: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1018: End If;
1019:
1020: -- Check the number of task template groups returned by the Get Task Template Group API
1021: -- If l_task_template_group_tbl.count > 0 Then

Line 1079: x_return_status := FND_API.G_RET_STS_SUCCESS;

1075: -- End If; -- If l_task_template_group_tbl.count > 0
1076:
1077: If l_tbl_index = 0 Then
1078: -- No task template groups are found
1079: x_return_status := FND_API.G_RET_STS_SUCCESS;
1080: x_auto_task_gen_rec.auto_task_gen_attempted := FALSE;
1081:
1082: Elsif l_tbl_index > 1 Then
1083: -- Multiple task template groups are found

Line 1201: If (l_return_status = FND_API.G_RET_STS_SUCCESS) Then

1197: x_msg_data => x_msg_data
1198: );
1199:
1200:
1201: If (l_return_status = FND_API.G_RET_STS_SUCCESS) Then
1202: x_return_status := l_return_status;
1203: x_auto_task_gen_rec.auto_task_gen_attempted := TRUE;
1204: x_auto_task_gen_rec.field_service_task_created := l_field_service_task_created;
1205: -- Modified error handling logic --anmukher --08/22/03

Line 1206: Elsif (l_return_status = FND_API.G_RET_STS_ERROR) OR (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then

1202: x_return_status := l_return_status;
1203: x_auto_task_gen_rec.auto_task_gen_attempted := TRUE;
1204: x_auto_task_gen_rec.field_service_task_created := l_field_service_task_created;
1205: -- Modified error handling logic --anmukher --08/22/03
1206: Elsif (l_return_status = FND_API.G_RET_STS_ERROR) OR (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
1207: x_auto_task_gen_rec.auto_task_gen_attempted := TRUE;
1208: Raise Task_Creation_Failed;
1209: End If;
1210:

Line 1217: IF FND_API.To_Boolean(p_commit) THEN

1213: -- Standard call to get message count and if count is 1, get message info
1214: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1215:
1216: -- Standard check of p_commit
1217: IF FND_API.To_Boolean(p_commit) THEN
1218: COMMIT WORK;
1219: END IF;
1220:
1221:

Line 1223: WHEN FND_API.G_EXC_ERROR THEN

1219: END IF;
1220:
1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: ROLLBACK to CS_AutoGen_Task_PVT ;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1227:

Line 1225: x_return_status := FND_API.G_RET_STS_ERROR;

1221:
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: ROLLBACK to CS_AutoGen_Task_PVT ;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: ROLLBACK to CS_AutoGen_Task_PVT ;

Line 1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1224: ROLLBACK to CS_AutoGen_Task_PVT ;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: ROLLBACK to CS_AutoGen_Task_PVT ;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1232:

Line 1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: ROLLBACK to CS_AutoGen_Task_PVT ;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1232:
1233: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03
1234: WHEN Many_Task_Tmpl_Found THEN

Line 1236: x_return_status := FND_API.G_RET_STS_ERROR;

1232:
1233: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03
1234: WHEN Many_Task_Tmpl_Found THEN
1235: ROLLBACK to CS_AutoGen_Task_PVT ;
1236: x_return_status := FND_API.G_RET_STS_ERROR;
1237: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_MULTIPLE_TGT_ERROR');
1238: FND_MESSAGE.SET_TOKEN ('TASK_GROUP_TEMPLATES',l_task_tmpl_groups_found);
1239: FND_MSG_PUB.ADD;
1240: FND_MSG_PUB.Count_And_Get(

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243:
1244: -- Added new exception handler for auto task creation failure with single template group --anmukher -- 08/22/03
1245: WHEN Task_Creation_Failed THEN
1246: ROLLBACK to CS_AutoGen_Task_PVT ;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Message commented out since Create_Task_From_Template API is already
1249: -- stacking specific error message on failure --anmukher --10/30/2003
1250: /*
1251: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_SINGLE_TGT_ERROR');

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1257: p_data => x_msg_data);
1258:
1259: WHEN OTHERS THEN
1260: ROLLBACK to CS_AutoGen_Task_PVT ;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: If c_get_task_tmpl_grp_info%IsOpen Then
1263: close c_get_task_tmpl_grp_info;
1264: End If;
1265: If c_get_task_templates%IsOpen Then