358: WHEN e_AutoAssignment_Exception THEN
359: OPEN c_get_tgt_name;
360: FETCH c_get_tgt_name INTO l_template_group_name ;
361: CLOSE c_get_tgt_name;
362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
363: p_data => x_msg_data );
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);
363: p_data => x_msg_data );
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 ;
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;
373: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
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;
373: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
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 ;
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;
383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data );
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);
384: p_data => x_msg_data );
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 ;
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;
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
395: p_data => x_msg_data );
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;
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
395: p_data => x_msg_data );
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
404: WHEN e_date_pair_exception THEN
405: OPEN c_get_tgt_name;
406: FETCH c_get_tgt_name INTO l_template_group_name ;
407: CLOSE c_get_tgt_name;
408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
409: p_data => x_msg_data );
410: FND_MESSAGE.SET_NAME('CS','CS_DATE_PAIR_ERROR');
411: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
412: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
410: FND_MESSAGE.SET_NAME('CS','CS_DATE_PAIR_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 ;
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;
420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
421: p_data => x_msg_data );
422: FND_MESSAGE.SET_NAME('CS','CS_PLANNED_EFFORT_VAL_ERROR');
423: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
424: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
422: FND_MESSAGE.SET_NAME('CS','CS_PLANNED_EFFORT_VAL_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;
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,
435: p_data => x_msg_data);
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437:
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,
435: p_data => x_msg_data);
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437:
438: END Create_Task_From_Template;
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
554: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
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 );
559:
560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759:
760: close c_search_rules;
761:
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;
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;
772: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
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;
776: If c_task_template_grp%IsOpen Then
780: close c_search_rules;
781: End If;
782: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
783: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
784: FND_MSG_PUB.ADD;
785: FND_MSG_PUB.Count_And_Get(
786: p_count => x_msg_count,
787: p_data => x_msg_data);
788:
781: End If;
782: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
783: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
784: FND_MSG_PUB.ADD;
785: FND_MSG_PUB.Count_And_Get(
786: p_count => x_msg_count,
787: p_data => x_msg_data);
788:
789: END Get_Task_Template_Group;
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
865: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
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 );
870:
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109:
1110: End If; -- If (l_call_create_task_api = TRUE)
1111:
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;
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 ;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
1134: ROLLBACK to CS_AutoGen_Task_PVT ;
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(
1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
1142:
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(
1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
1142:
1143: -- Added new exception handler for auto task creation failure with single template group --anmukher -- 08/22/03
1148: -- stacking specific error message on failure --anmukher --10/30/2003
1149: /*
1150: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_SINGLE_TGT_ERROR');
1151: FND_MESSAGE.SET_TOKEN ('TASK_TEMPLATE_GROUP',l_task_tmpl_groups_found);
1152: FND_MSG_PUB.ADD;
1153: */
1154: FND_MSG_PUB.Count_And_Get(
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1150: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_SINGLE_TGT_ERROR');
1151: FND_MESSAGE.SET_TOKEN ('TASK_TEMPLATE_GROUP',l_task_tmpl_groups_found);
1152: FND_MSG_PUB.ADD;
1153: */
1154: FND_MSG_PUB.Count_And_Get(
1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:
1158: WHEN OTHERS THEN
1165: close c_get_task_templates;
1166: End If;
1167: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1168: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1169: FND_MSG_PUB.ADD;
1170: FND_MSG_PUB.Count_And_Get(
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);
1173:
1166: End If;
1167: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1168: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1169: FND_MSG_PUB.ADD;
1170: FND_MSG_PUB.Count_And_Get(
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);
1173:
1174: END Auto_Generate_Tasks;