DBA Data[Home] [Help]

APPS.CS_AUTOGEN_TASK_PVT dependencies on FND_MSG_PUB

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

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);

Line 367: FND_MSG_PUB.ADD;

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 ;

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

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;

Line 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 ;

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

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);

Line 388: FND_MSG_PUB.ADD;

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 ;

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

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;

Line 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

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

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);

Line 414: FND_MSG_PUB.ADD;

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 ;

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

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);

Line 426: FND_MSG_PUB.ADD;

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;

Line 433: FND_MSG_PUB.ADD;

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:

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

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;

Line 550: FND_MSG_PUB.Initialize;

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,

Line 556: FND_MSG_PUB.Count_And_Get(

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;

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

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;

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

Line 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

Line 784: FND_MSG_PUB.ADD;

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:

Line 785: FND_MSG_PUB.Count_And_Get(

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;

Line 861: FND_MSG_PUB.Initialize;

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,

Line 867: FND_MSG_PUB.Count_And_Get(

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;

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

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;

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

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;

Line 1130: 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
1134: ROLLBACK to CS_AutoGen_Task_PVT ;

Line 1138: FND_MSG_PUB.ADD;

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:

Line 1139: FND_MSG_PUB.Count_And_Get(

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

Line 1152: FND_MSG_PUB.ADD;

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);

Line 1154: FND_MSG_PUB.Count_And_Get(

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

Line 1169: FND_MSG_PUB.ADD;

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:

Line 1170: FND_MSG_PUB.Count_And_Get(

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;