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);
367: FND_MSG_PUB.ADD;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
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);
367: FND_MSG_PUB.ADD;
368: x_return_status := FND_API.G_RET_STS_ERROR ;
369: WHEN e_party_site_exception THEN
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);
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;
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
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;
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;
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);
388: FND_MSG_PUB.ADD;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
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);
388: FND_MSG_PUB.ADD;
389: x_return_status := FND_API.G_RET_STS_ERROR ;
390: WHEN e_CreateTask_Exception THEN
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);
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;
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 ;
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;
399: l_text := sqlcode||'-'||sqlerrm ;
400: x_return_status := FND_API.G_RET_STS_ERROR ;
401: -- Simplex
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);
413: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
414: FND_MSG_PUB.ADD;
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);
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 ;
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);
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
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);
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;
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);
425: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE',l_task_name);
426: FND_MSG_PUB.ADD;
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);
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 ;
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);
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
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);
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
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,
435: p_data => x_msg_data);
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,
435: p_data => x_msg_data);
436: x_return_status := FND_API.G_RET_STS_ERROR ;
778: End If;
779: If c_search_rules%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,
779: If c_search_rules%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);
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(
1140: p_count => x_msg_count,
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(
1140: p_count => x_msg_count,
1141: p_data => x_msg_data);
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');
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(
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');
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,
1163: End If;
1164: If c_get_task_templates%IsOpen 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,
1164: If c_get_task_templates%IsOpen 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);