DBA Data[Home] [Help]

APPS.CS_AUTOGEN_TASK_PVT dependencies on FND_MSG_PUB

Line 440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

436: WHEN e_AutoAssignment_Exception THEN
437: OPEN c_get_tgt_name;
438: FETCH c_get_tgt_name INTO l_template_group_name ;
439: CLOSE c_get_tgt_name;
440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
441: p_data => x_msg_data );
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);

Line 445: FND_MSG_PUB.ADD;

441: p_data => x_msg_data );
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 ;

Line 451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
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;

Line 455: FND_MSG_PUB.ADD;

451: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
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 ;

Line 461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
462: p_data => x_msg_data );
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);

Line 466: FND_MSG_PUB.ADD;

462: p_data => x_msg_data );
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 ;

Line 472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
473: p_data => x_msg_data );
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;

Line 476: FND_MSG_PUB.ADD;

472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
473: p_data => x_msg_data );
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

Line 486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

482: WHEN e_date_pair_exception THEN
483: OPEN c_get_tgt_name;
484: FETCH c_get_tgt_name INTO l_template_group_name ;
485: CLOSE c_get_tgt_name;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data => x_msg_data );
488: FND_MESSAGE.SET_NAME('CS','CS_DATE_PAIR_ERROR');
489: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
490: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);

Line 492: FND_MSG_PUB.ADD;

488: FND_MESSAGE.SET_NAME('CS','CS_DATE_PAIR_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 ;

Line 498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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;
498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
499: p_data => x_msg_data );
500: FND_MESSAGE.SET_NAME('CS','CS_PLANNED_EFFORT_VAL_ERROR');
501: FND_MESSAGE.SET_TOKEN('TASK_TEMPLATE_GROUP',l_template_group_name);
502: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);

Line 504: FND_MSG_PUB.ADD;

500: FND_MESSAGE.SET_NAME('CS','CS_PLANNED_EFFORT_VAL_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;

Line 511: FND_MSG_PUB.ADD;

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,
513: p_data => x_msg_data);
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515:

Line 512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

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,
513: p_data => x_msg_data);
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515:
516: END Create_Task_From_Template;

Line 628: FND_MSG_PUB.Initialize;

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
632: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 634: FND_MSG_PUB.Count_And_Get(

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 );
637:
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

837:
838: close c_search_rules;
839:
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;

Line 846: 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;
850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 850: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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;
854: If c_task_template_grp%IsOpen Then

Line 862: FND_MSG_PUB.ADD;

858: close c_search_rules;
859: End If;
860: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
861: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
862: FND_MSG_PUB.ADD;
863: FND_MSG_PUB.Count_And_Get(
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:

Line 863: FND_MSG_PUB.Count_And_Get(

859: End If;
860: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
861: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
862: FND_MSG_PUB.ADD;
863: FND_MSG_PUB.Count_And_Get(
864: p_count => x_msg_count,
865: p_data => x_msg_data);
866:
867: END Get_Task_Template_Group;

Line 943: FND_MSG_PUB.Initialize;

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
947: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

Line 949: FND_MSG_PUB.Count_And_Get(

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 );
952:
953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1214: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1210:
1211: End If; -- If (l_call_create_task_api = TRUE)
1212:
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;

Line 1226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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 ;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1231: 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
1235: ROLLBACK to CS_AutoGen_Task_PVT ;

Line 1239: FND_MSG_PUB.ADD;

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(
1241: p_count => x_msg_count,
1242: p_data => x_msg_data);
1243:

Line 1240: FND_MSG_PUB.Count_And_Get(

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(
1241: p_count => x_msg_count,
1242: p_data => x_msg_data);
1243:
1244: -- Added new exception handler for auto task creation failure with single template group --anmukher -- 08/22/03

Line 1253: FND_MSG_PUB.ADD;

1249: -- stacking specific error message on failure --anmukher --10/30/2003
1250: /*
1251: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_SINGLE_TGT_ERROR');
1252: FND_MESSAGE.SET_TOKEN ('TASK_TEMPLATE_GROUP',l_task_tmpl_groups_found);
1253: FND_MSG_PUB.ADD;
1254: */
1255: FND_MSG_PUB.Count_And_Get(
1256: p_count => x_msg_count,
1257: p_data => x_msg_data);

Line 1255: FND_MSG_PUB.Count_And_Get(

1251: FND_MESSAGE.SET_NAME ('CS', 'CS_SR_TGT_SINGLE_TGT_ERROR');
1252: FND_MESSAGE.SET_TOKEN ('TASK_TEMPLATE_GROUP',l_task_tmpl_groups_found);
1253: FND_MSG_PUB.ADD;
1254: */
1255: FND_MSG_PUB.Count_And_Get(
1256: p_count => x_msg_count,
1257: p_data => x_msg_data);
1258:
1259: WHEN OTHERS THEN

Line 1270: FND_MSG_PUB.ADD;

1266: close c_get_task_templates;
1267: End If;
1268: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1269: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1270: FND_MSG_PUB.ADD;
1271: FND_MSG_PUB.Count_And_Get(
1272: p_count => x_msg_count,
1273: p_data => x_msg_data);
1274:

Line 1271: FND_MSG_PUB.Count_And_Get(

1267: End If;
1268: FND_MESSAGE.SET_NAME ('CS', 'CS_API_SR_UNKNOWN_ERROR');
1269: FND_MESSAGE.SET_TOKEN ('P_TEXT',l_api_name_full||'-'||SQLERRM);
1270: FND_MSG_PUB.ADD;
1271: FND_MSG_PUB.Count_And_Get(
1272: p_count => x_msg_count,
1273: p_data => x_msg_data);
1274:
1275: END Auto_Generate_Tasks;