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 22: l_commit VARCHAR2(30) := fnd_api.g_false;

18: ) IS
19:
20: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';
21: l_return_status VARCHAR2(30) := 'S';
22: l_commit VARCHAR2(30) := fnd_api.g_false;
23: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
24: l_owner_group_id NUMBER ;
25: l_owner_id NUMBER ;
26: l_owner_type VARCHAR2(30) ;

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

19:
20: l_level_statement VARCHAR2(240) := 'cs.plsql.cs_autogen_task_pvt.create_task_from_template';
21: l_return_status VARCHAR2(30) := 'S';
22: l_commit VARCHAR2(30) := fnd_api.g_false;
23: l_init_msg_list VARCHAR2(30) := fnd_api.g_false;
24: l_owner_group_id NUMBER ;
25: l_owner_id NUMBER ;
26: l_owner_type VARCHAR2(30) ;
27: l_msg_count NUMBER ;

Line 198: p_init_msg_list => fnd_api.g_false ,

194:
195:
196: CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource
197: (p_api_version => 1.0 ,
198: p_init_msg_list => fnd_api.g_false ,
199: p_commit => l_commit ,
200: p_incident_id => p_incident_id ,
201: p_task_attribute_rec => l_task_attribute_rec ,
202: x_owner_group_id => l_owner_group_id ,

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

208: x_msg_count => x_msg_count ,
209: x_msg_data => x_msg_data );
210:
211:
212: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
213:
214:
215: l_task_name := null;
216: l_task_name := l_task_template_tbl(i).task_name;

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

298:
299: -- The palnned start date and planned end date should appear in pair.
300: -- If not,exception is thrown
301: IF ( ( (l_task_template_tbl(i).planned_start_date IS NOT NULL AND
302: l_task_template_tbl(i).planned_start_date <> FND_API.G_MISS_DATE)
303: AND
304: (l_task_template_tbl(i).planned_end_date IS NULL OR
305: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)
306: )

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

301: IF ( ( (l_task_template_tbl(i).planned_start_date IS NOT NULL AND
302: l_task_template_tbl(i).planned_start_date <> FND_API.G_MISS_DATE)
303: AND
304: (l_task_template_tbl(i).planned_end_date IS NULL OR
305: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)
306: )
307: OR
308: ( (l_task_template_tbl(i).planned_end_date IS NOT NULL AND
309: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)

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

305: l_task_template_tbl(i).planned_end_date = FND_API.G_MISS_DATE)
306: )
307: OR
308: ( (l_task_template_tbl(i).planned_end_date IS NOT NULL AND
309: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)
310: AND
311: (l_task_template_tbl(i).planned_start_date IS NULL OR
312: l_task_template_tbl(i).planned_start_date = FND_API.G_MISS_DATE)
313: )

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

308: ( (l_task_template_tbl(i).planned_end_date IS NOT NULL AND
309: l_task_template_tbl(i).planned_end_date <> FND_API.G_MISS_DATE)
310: AND
311: (l_task_template_tbl(i).planned_start_date IS NULL OR
312: l_task_template_tbl(i).planned_start_date = FND_API.G_MISS_DATE)
313: )
314: )THEN
315:
316: l_task_name := null;

Line 337: p_init_msg_list => fnd_api.g_false ,

333: l_return_status := null ;
334:
335: JTF_TASK_INST_TEMPLATES_PUB.create_task_from_template
336: (p_api_version => 1.0 ,
337: p_init_msg_list => fnd_api.g_false ,
338: p_commit => l_commit ,
339: p_task_template_group_info => l_task_template_group_info,
340: p_task_templates_tbl => l_task_template_tbl,
341: p_task_contact_points_tbl => l_task_contact_points_tbl,

Line 348: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

344: x_msg_data => x_msg_data ,
345: x_task_details_tbl => l_task_details_tbl);
346:
347:
348: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
349:
350: RAISE e_CreateTask_Exception;
351: ELSE
352: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS ;

348: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
349:
350: RAISE e_CreateTask_Exception;
351: ELSE
352: x_return_status := FND_API.G_RET_STS_SUCCESS ;
353: x_field_service_task_created := l_field_service_task_created ;
354:
355: END IF ;
356:

Line 368: x_return_status := FND_API.G_RET_STS_ERROR ;

364: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_AUTO_ASSIGNMENT_FAIL');
365: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
366: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
367: FND_MSG_PUB.ADD;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: WHEN e_party_site_exception THEN
370: OPEN c_get_tgt_name;
371: FETCH c_get_tgt_name INTO l_template_group_name ;
372: CLOSE c_get_tgt_name;

Line 378: x_return_status := FND_API.G_RET_STS_ERROR ;

374: p_data => x_msg_data );
375: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_INVALID_PARTY_SITE');
376: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
377: FND_MSG_PUB.ADD;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: WHEN e_Planned_effort_Exception THEN
380: OPEN c_get_tgt_name;
381: FETCH c_get_tgt_name INTO l_template_group_name ;
382: CLOSE c_get_tgt_name;

Line 389: x_return_status := FND_API.G_RET_STS_ERROR ;

385: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_INVALID_PLANNED_EFRT');
386: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
387: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
388: FND_MSG_PUB.ADD;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: WHEN e_CreateTask_Exception THEN
391: OPEN c_get_tgt_name;
392: FETCH c_get_tgt_name INTO l_template_group_name ;
393: CLOSE c_get_tgt_name;

Line 400: x_return_status := FND_API.G_RET_STS_ERROR ;

396: FND_MESSAGE.SET_NAME('CS','CS_SR_TSK_CREATE_TASK_FAILED');
397: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
398: FND_MSG_PUB.ADD;
399: l_text := sqlcode||'-'||sqlerrm ;
400: x_return_status := FND_API.G_RET_STS_ERROR ;
401: -- Simplex
402: -- The following are the exceptions thrown as a part of the validations done
403: -- for Task State Restrictions
404: WHEN e_date_pair_exception THEN

Line 415: x_return_status := FND_API.G_RET_STS_ERROR ;

411: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
412: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
413: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
414: FND_MSG_PUB.ADD;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: WHEN e_planned_effort_val_exception THEN
417: OPEN c_get_tgt_name;
418: FETCH c_get_tgt_name INTO l_template_group_name ;
419: CLOSE c_get_tgt_name;

Line 427: x_return_status := FND_API.G_RET_STS_ERROR ;

423: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
424: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
425: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
426: FND_MSG_PUB.ADD;
427: x_return_status := FND_API.G_RET_STS_ERROR ;
428: -- end of simplex
429: WHEN others THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

426: FND_MSG_PUB.ADD;
427: x_return_status := FND_API.G_RET_STS_ERROR ;
428: -- end of simplex
429: WHEN others THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
432: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_level_statement ||' - '||SQLERRM);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 436: x_return_status := FND_API.G_RET_STS_ERROR ;

432: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_level_statement ||' - '||SQLERRM);
433: FND_MSG_PUB.ADD;
434: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
435: p_data => x_msg_data);
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437:
438: END Create_Task_From_Template;
439:
440:

Line 445: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

441:
442: PROCEDURE Get_Task_Template_Group
443: (
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
446: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
447: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
448: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
449: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,

Line 446: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

442: PROCEDURE Get_Task_Template_Group
443: (
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
446: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
447: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
448: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
449: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
450: x_return_status OUT NOCOPY VARCHAR2,

Line 447: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

443: (
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
446: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
447: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
448: p_task_template_search_rec IN CS_AutoGen_Task_PVT.task_template_search_rec_type,
449: x_task_template_group_tbl OUT NOCOPY CS_AutoGen_Task_PVT.task_template_group_tbl_type,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,

Line 549: IF FND_API.To_Boolean(p_init_msg_list) THEN

545:
546: Begin
547:
548: -- Initialize message list if p_init_msg_list is set to TRUE
549: IF FND_API.To_Boolean(p_init_msg_list) THEN
550: FND_MSG_PUB.Initialize;
551: END IF;
552:
553: -- Standard call to check for call compatibility

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

550: FND_MSG_PUB.Initialize;
551: END IF;
552:
553: -- Standard call to check for call compatibility
554: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
555: l_api_name, G_PKG_NAME) THEN
556: FND_MSG_PUB.Count_And_Get(
557: p_count => x_msg_count,
558: p_data => x_msg_data );

Line 560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

556: FND_MSG_PUB.Count_And_Get(
557: p_count => x_msg_count,
558: p_data => x_msg_data );
559:
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:
563: -- Initialize API return status to success
564: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
561: END IF;
562:
563: -- Initialize API return status to success
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: -- Get all active search rules
567: open c_search_rules;
568:

Line 766: WHEN FND_API.G_EXC_ERROR THEN

762: -- Standard call to get message count and if count is 1, get message info
763: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

766: WHEN FND_API.G_EXC_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
773:
774: WHEN OTHERS THEN

Line 771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

767: x_return_status := FND_API.G_RET_STS_ERROR;
768: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
773:
774: WHEN OTHERS THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
773:
774: WHEN OTHERS THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: If c_task_template_grp%IsOpen Then
777: close c_task_template_grp;
778: End If;
779: If c_search_rules%IsOpen Then

Line 796: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

792:
793: PROCEDURE Auto_Generate_Tasks
794: (
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
797: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
798: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
799: p_incident_id IN NUMBER,
800: p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,

Line 797: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

793: PROCEDURE Auto_Generate_Tasks
794: (
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
797: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
798: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
799: p_incident_id IN NUMBER,
800: p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,
801: p_task_template_group_owner IN NUMBER,

Line 798: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

794: (
795: p_api_version IN NUMBER,
796: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
797: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
798: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
799: p_incident_id IN NUMBER,
800: p_service_request_rec IN Cs_ServiceRequest_PVT.Service_Request_rec_type,
801: p_task_template_group_owner IN NUMBER,
802: p_task_tmpl_group_owner_type IN VARCHAR2,

Line 860: IF FND_API.To_Boolean(p_init_msg_list) THEN

856:
857: SAVEPOINT CS_AutoGen_Task_PVT ;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE
860: IF FND_API.To_Boolean(p_init_msg_list) THEN
861: FND_MSG_PUB.Initialize;
862: END IF;
863:
864: -- Standard call to check for call compatibility

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

861: FND_MSG_PUB.Initialize;
862: END IF;
863:
864: -- Standard call to check for call compatibility
865: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
866: l_api_name, G_PKG_NAME) THEN
867: FND_MSG_PUB.Count_And_Get(
868: p_count => x_msg_count,
869: p_data => x_msg_data );

Line 871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

867: FND_MSG_PUB.Count_And_Get(
868: p_count => x_msg_count,
869: p_data => x_msg_data );
870:
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END IF;
873:
874: -- Initialize API return status to success
875: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 875: x_return_status := FND_API.G_RET_STS_SUCCESS;

871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END IF;
873:
874: -- Initialize API return status to success
875: x_return_status := FND_API.G_RET_STS_SUCCESS;
876:
877: l_task_template_group_owner := p_task_template_group_owner;
878: l_task_tmpl_group_owner_type := p_task_tmpl_group_owner_type;
879:

Line 921: p_init_msg_list => fnd_api.g_false,

917:
918:
919: CS_Autogen_Task_PVT.Get_Task_Template_Group
920: ( p_api_version => 1.0,
921: p_init_msg_list => fnd_api.g_false,
922: p_commit => p_commit,
923: p_validation_level => p_validation_level,
924: p_task_template_search_rec => l_task_template_search_rec,
925: x_task_template_group_tbl => l_task_template_group_tbl,

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

928: x_msg_data => x_msg_data
929: );
930:
931:
932: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
933: Raise FND_API.G_EXC_ERROR;
934: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
935: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
936: End If;

Line 933: Raise FND_API.G_EXC_ERROR;

929: );
930:
931:
932: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
933: Raise FND_API.G_EXC_ERROR;
934: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
935: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
936: End If;
937:

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

930:
931:
932: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
933: Raise FND_API.G_EXC_ERROR;
934: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
935: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
936: End If;
937:
938: -- Check the number of task template groups returned by the Get Task Template Group API

Line 935: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

931:
932: If (l_return_status = FND_API.G_RET_STS_ERROR) Then
933: Raise FND_API.G_EXC_ERROR;
934: Elsif (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
935: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
936: End If;
937:
938: -- Check the number of task template groups returned by the Get Task Template Group API
939: -- If l_task_template_group_tbl.count > 0 Then

Line 997: x_return_status := FND_API.G_RET_STS_SUCCESS;

993: -- End If; -- If l_task_template_group_tbl.count > 0
994:
995: If l_tbl_index = 0 Then
996: -- No task template groups are found
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998: x_auto_task_gen_rec.auto_task_gen_attempted := FALSE;
999:
1000: Elsif l_tbl_index > 1 Then
1001: -- Multiple task template groups are found

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

1096: x_msg_data => x_msg_data
1097: );
1098:
1099:
1100: If (l_return_status = FND_API.G_RET_STS_SUCCESS) Then
1101: x_return_status := l_return_status;
1102: x_auto_task_gen_rec.auto_task_gen_attempted := TRUE;
1103: x_auto_task_gen_rec.field_service_task_created := l_field_service_task_created;
1104: -- Modified error handling logic --anmukher --08/22/03

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

1101: x_return_status := l_return_status;
1102: x_auto_task_gen_rec.auto_task_gen_attempted := TRUE;
1103: x_auto_task_gen_rec.field_service_task_created := l_field_service_task_created;
1104: -- Modified error handling logic --anmukher --08/22/03
1105: Elsif (l_return_status = FND_API.G_RET_STS_ERROR) OR (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) Then
1106: x_auto_task_gen_rec.auto_task_gen_attempted := TRUE;
1107: Raise Task_Creation_Failed;
1108: End If;
1109:

Line 1116: IF FND_API.To_Boolean(p_commit) THEN

1112: -- Standard call to get message count and if count is 1, get message info
1113: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1114:
1115: -- Standard check of p_commit
1116: IF FND_API.To_Boolean(p_commit) THEN
1117: COMMIT WORK;
1118: END IF;
1119:
1120:

Line 1122: WHEN FND_API.G_EXC_ERROR THEN

1118: END IF;
1119:
1120:
1121: EXCEPTION
1122: WHEN FND_API.G_EXC_ERROR THEN
1123: ROLLBACK to CS_AutoGen_Task_PVT ;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1126:

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120:
1121: EXCEPTION
1122: WHEN FND_API.G_EXC_ERROR THEN
1123: ROLLBACK to CS_AutoGen_Task_PVT ;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK to CS_AutoGen_Task_PVT ;

Line 1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1123: ROLLBACK to CS_AutoGen_Task_PVT ;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK to CS_AutoGen_Task_PVT ;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1131:

Line 1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1125: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1126:
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK to CS_AutoGen_Task_PVT ;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1131:
1132: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03
1133: WHEN Many_Task_Tmpl_Found THEN

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131:
1132: -- Added new exception handler for mutiple template group error --anmukher -- 08/22/03
1133: WHEN Many_Task_Tmpl_Found THEN
1134: ROLLBACK to CS_AutoGen_Task_PVT ;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_MULTIPLE_TGT_ERROR');
1137: FND_MESSAGE.SET_TOKEN ('TASK_GROUP_TEMPLATES',l_task_tmpl_groups_found);
1138: FND_MSG_PUB.ADD;
1139: FND_MSG_PUB.Count_And_Get(

Line 1146: x_return_status := FND_API.G_RET_STS_ERROR;

1142:
1143: -- Added new exception handler for auto task creation failure with single template group --anmukher -- 08/22/03
1144: WHEN Task_Creation_Failed THEN
1145: ROLLBACK to CS_AutoGen_Task_PVT ;
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: -- Message commented out since Create_Task_From_Template API is already
1148: -- stacking specific error message on failure --anmukher --10/30/2003
1149: /*
1150: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_SINGLE_TGT_ERROR');

Line 1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1156: p_data => x_msg_data);
1157:
1158: WHEN OTHERS THEN
1159: ROLLBACK to CS_AutoGen_Task_PVT ;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: If c_get_task_tmpl_grp_info%IsOpen Then
1162: close c_get_task_tmpl_grp_info;
1163: End If;
1164: If c_get_task_templates%IsOpen Then