DBA Data[Home] [Help]

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on FND_MESSAGE

Line 166: fnd_message.set_name('FND', 'WF_ERROR');

162: WHEN OTHERS THEN
163: ROLLBACK TO start_task_workflow ;
164: wf_core.get_error(l_errname, l_errmsg, l_errstack);
165: if (l_errname is not null) then
166: fnd_message.set_name('FND', 'WF_ERROR');
167: fnd_message.set_token('ERROR_MESSAGE', l_errmsg);
168: fnd_message.set_token('ERROR_STACK', l_errstack);
169: fnd_msg_pub.add;
170: end if;

Line 167: fnd_message.set_token('ERROR_MESSAGE', l_errmsg);

163: ROLLBACK TO start_task_workflow ;
164: wf_core.get_error(l_errname, l_errmsg, l_errstack);
165: if (l_errname is not null) then
166: fnd_message.set_name('FND', 'WF_ERROR');
167: fnd_message.set_token('ERROR_MESSAGE', l_errmsg);
168: fnd_message.set_token('ERROR_STACK', l_errstack);
169: fnd_msg_pub.add;
170: end if;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 168: fnd_message.set_token('ERROR_STACK', l_errstack);

164: wf_core.get_error(l_errname, l_errmsg, l_errstack);
165: if (l_errname is not null) then
166: fnd_message.set_name('FND', 'WF_ERROR');
167: fnd_message.set_token('ERROR_MESSAGE', l_errmsg);
168: fnd_message.set_token('ERROR_STACK', l_errstack);
169: fnd_msg_pub.add;
170: end if;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 360: fnd_message.set_name ('CS', 'CS_EA_NO_TASK_ATTRIBUTES');

356: ;
357: if (c_task_attributes%notfound) then
358: --add a error message
359: -- This should never happen because form force this validation
360: fnd_message.set_name ('CS', 'CS_EA_NO_TASK_ATTRIBUTES');
361: fnd_msg_pub.add;
362: close c_task_attributes;
363: close c_sr_attr_tasks;
364: raise fnd_api.g_exc_unexpected_error;

Line 389: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');

385: open c_planned_effort;
386: fetch c_planned_effort into l_planned_effort,
387: l_planned_effort_uom, l_rule, l_workflow, l_workflow_type;
388: if (c_planned_effort%notfound) then
389: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');
390: fnd_message.set_token('P_TASK_TYPE_ID',l_task_type_id);
391: fnd_msg_pub.add;
392: close c_planned_effort;
393: close c_sr_attr_tasks;

Line 390: fnd_message.set_token('P_TASK_TYPE_ID',l_task_type_id);

386: fetch c_planned_effort into l_planned_effort,
387: l_planned_effort_uom, l_rule, l_workflow, l_workflow_type;
388: if (c_planned_effort%notfound) then
389: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');
390: fnd_message.set_token('P_TASK_TYPE_ID',l_task_type_id);
391: fnd_msg_pub.add;
392: close c_planned_effort;
393: close c_sr_attr_tasks;
394: raise fnd_api.g_exc_unexpected_error;

Line 428: fnd_message.set_name ('CS', 'CS_EA_NO_CONFIGURED_TASKS');

424: close c_sr_attr_tasks;
425: /* 10/28/2003
426: this may happen for check of task types with null attributes.
427: if (l_sr_attr_task_found = 'n') then
428: fnd_message.set_name ('CS', 'CS_EA_NO_CONFIGURED_TASKS');
429: fnd_message.set_token('P_SR_TYPE',p_incident_type_id);
430: fnd_message.set_token('P_EA_CODE',p_sr_ea_attr_code);
431: fnd_msg_pub.add;
432: end if;

Line 429: fnd_message.set_token('P_SR_TYPE',p_incident_type_id);

425: /* 10/28/2003
426: this may happen for check of task types with null attributes.
427: if (l_sr_attr_task_found = 'n') then
428: fnd_message.set_name ('CS', 'CS_EA_NO_CONFIGURED_TASKS');
429: fnd_message.set_token('P_SR_TYPE',p_incident_type_id);
430: fnd_message.set_token('P_EA_CODE',p_sr_ea_attr_code);
431: fnd_msg_pub.add;
432: end if;
433: */

Line 430: fnd_message.set_token('P_EA_CODE',p_sr_ea_attr_code);

426: this may happen for check of task types with null attributes.
427: if (l_sr_attr_task_found = 'n') then
428: fnd_message.set_name ('CS', 'CS_EA_NO_CONFIGURED_TASKS');
429: fnd_message.set_token('P_SR_TYPE',p_incident_type_id);
430: fnd_message.set_token('P_EA_CODE',p_sr_ea_attr_code);
431: fnd_msg_pub.add;
432: end if;
433: */
434: end get_tasks_for_sr_attribute;

Line 461: fnd_message.set_name ('CS', 'CS_EA_US_INVALID_API_VER');

457: end if;
458: --
459: -- check API version
460: if (p_api_version <> 1) then
461: fnd_message.set_name ('CS', 'CS_EA_US_INVALID_API_VER');
462: fnd_msg_pub.add;
463: raise fnd_api.g_exc_unexpected_error;
464: end if;
465: --

Line 468: fnd_message.set_name ('CS', 'CS_EA_NULL_OLD_INCIDENT_TYPE');

464: end if;
465: --
466: -- check old incident type ID
467: if (p_incident_type_id_old is null) then
468: fnd_message.set_name ('CS', 'CS_EA_NULL_OLD_INCIDENT_TYPE');
469: fnd_msg_pub.add;
470: raise fnd_api.g_exc_unexpected_error;
471: end if;
472: --

Line 475: fnd_message.set_name ('CS', 'CS_EA_NULL_NEW_INCIDENT_TYPE');

471: end if;
472: --
473: -- check new incident type ID
474: if (p_incident_type_id_new is null) then
475: fnd_message.set_name ('CS', 'CS_EA_NULL_NEW_INCIDENT_TYPE');
476: fnd_msg_pub.add;
477: raise fnd_api.g_exc_unexpected_error;
478: end if;
479: ----------------------------------------------------------

Line 558: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

554: fnd_msg_pub.count_and_get (
555: p_count => x_msg_count,
556: p_data => x_msg_data);
557: WHEN OTHERS THEN
558: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
559: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
560: fnd_msg_pub.add;
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: fnd_msg_pub.count_and_get (

Line 559: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

555: p_count => x_msg_count,
556: p_data => x_msg_data);
557: WHEN OTHERS THEN
558: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
559: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
560: fnd_msg_pub.add;
561: x_return_status := fnd_api.g_ret_sts_unexp_error;
562: fnd_msg_pub.count_and_get (
563: p_count => x_msg_count,

Line 593: fnd_message.set_name ('CS', 'CS_EA_US_INVALID_API_VER');

589: end if;
590: --
591: -- check API version
592: if (p_api_version <> 1) then
593: fnd_message.set_name ('CS', 'CS_EA_US_INVALID_API_VER');
594: fnd_msg_pub.add;
595: raise fnd_api.g_exc_unexpected_error;
596: end if;
597: --

Line 600: fnd_message.set_name ('CS', 'CS_EA_NULL_REQUEST_ID');

596: end if;
597: --
598: -- Check Service request id
599: if (p_request_id is null) then
600: fnd_message.set_name ('CS', 'CS_EA_NULL_REQUEST_ID');
601: fnd_msg_pub.add;
602: raise fnd_api.g_exc_unexpected_error;
603: end if;
604: -- Get Service Extended Attributes

Line 643: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

639: p_count => x_msg_count,
640: p_data => x_msg_data);
641: WHEN OTHERS THEN
642: --dbms_output.put_line('get_extnd others error');
643: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
644: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
645: fnd_msg_pub.add;
646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647: fnd_msg_pub.count_and_get (

Line 644: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

640: p_data => x_msg_data);
641: WHEN OTHERS THEN
642: --dbms_output.put_line('get_extnd others error');
643: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
644: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
645: fnd_msg_pub.add;
646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647: fnd_msg_pub.count_and_get (
648: p_count => x_msg_count,

Line 785: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_END_DATE');

781:
782: -- 2nd check: Planed End Date
783: /*
784: if (p_sr_rec.obligation_date is null) then
785: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_END_DATE');
786: fnd_msg_pub.add;
787: x_return_status := fnd_api.g_ret_sts_error;
788: raise fnd_api.g_exc_error;
789: else

Line 794: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT');

790: */
791: --end if;
792: -- 3rd check: Planned Effort
793: if (l_task_rec_tbl(l_indx).planned_effort is null) then
794: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT');
795: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
796: fnd_msg_pub.add;
797: x_return_status := fnd_api.g_ret_sts_error;
798: raise fnd_api.g_exc_error;

Line 795: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);

791: --end if;
792: -- 3rd check: Planned Effort
793: if (l_task_rec_tbl(l_indx).planned_effort is null) then
794: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT');
795: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
796: fnd_msg_pub.add;
797: x_return_status := fnd_api.g_ret_sts_error;
798: raise fnd_api.g_exc_error;
799: end if;

Line 802: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT_UOM');

798: raise fnd_api.g_exc_error;
799: end if;
800: -- 4th check: Planned Effort UOM
801: if (l_task_rec_tbl(l_indx).planned_effort_uom is null) then
802: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT_UOM');
803: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
804: fnd_msg_pub.add;
805: x_return_status := fnd_api.g_ret_sts_error;
806: raise fnd_api.g_exc_error;

Line 803: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);

799: end if;
800: -- 4th check: Planned Effort UOM
801: if (l_task_rec_tbl(l_indx).planned_effort_uom is null) then
802: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT_UOM');
803: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
804: fnd_msg_pub.add;
805: x_return_status := fnd_api.g_ret_sts_error;
806: raise fnd_api.g_exc_error;
807: end if;

Line 844: --fnd_message.set_name ('CS', 'CS_EA_ASSIGN_TASK_ERROR');

840: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
841: THEN
842: --fnd_msg_pub.set_search_name('CS','CS_SR_TASK_NO_OWNER');
843: --fnd_msg_pub.set_search_token('API_NAME','CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource');
844: --fnd_message.set_name ('CS', 'CS_EA_ASSIGN_TASK_ERROR');
845: --fnd_message.set_token('TASK_NAME',l_task_rec_tbl(l_indx).task_name);
846: --l_dummy := fnd_msg_pub.change_msg;
847: --raise fnd_api.g_exc_error;
848: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 845: --fnd_message.set_token('TASK_NAME',l_task_rec_tbl(l_indx).task_name);

841: THEN
842: --fnd_msg_pub.set_search_name('CS','CS_SR_TASK_NO_OWNER');
843: --fnd_msg_pub.set_search_token('API_NAME','CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource');
844: --fnd_message.set_name ('CS', 'CS_EA_ASSIGN_TASK_ERROR');
845: --fnd_message.set_token('TASK_NAME',l_task_rec_tbl(l_indx).task_name);
846: --l_dummy := fnd_msg_pub.change_msg;
847: --raise fnd_api.g_exc_error;
848: x_return_status := FND_API.G_RET_STS_SUCCESS;
849: ELSE

Line 907: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');

903: open c_task_type_name(l_task_rec_tbl(l_indx).task_type_id);
904: fetch c_task_type_name into l_task_type_name;
905: close c_task_type_name;
906:
907: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');
908: fnd_message.set_token('TASK_TYPE',l_task_type_name);
909: fnd_message.set_token('API_NAME',l_api_name);
910: fnd_msg_pub.add;
911: x_return_status := fnd_api.g_ret_sts_error;

Line 908: fnd_message.set_token('TASK_TYPE',l_task_type_name);

904: fetch c_task_type_name into l_task_type_name;
905: close c_task_type_name;
906:
907: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');
908: fnd_message.set_token('TASK_TYPE',l_task_type_name);
909: fnd_message.set_token('API_NAME',l_api_name);
910: fnd_msg_pub.add;
911: x_return_status := fnd_api.g_ret_sts_error;
912: raise fnd_api.g_exc_error;

Line 909: fnd_message.set_token('API_NAME',l_api_name);

905: close c_task_type_name;
906:
907: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');
908: fnd_message.set_token('TASK_TYPE',l_task_type_name);
909: fnd_message.set_token('API_NAME',l_api_name);
910: fnd_msg_pub.add;
911: x_return_status := fnd_api.g_ret_sts_error;
912: raise fnd_api.g_exc_error;
913: END IF;

Line 974: fnd_message.set_name ('CS', 'CS_EA_CREATE_TASK_API_ERROR');

970: dbms_output.put_line('Owner Type:'||l_owner_type||':');
971: dbms_output.put_line(':'||to_char(l_owner_group_id));
972: dbms_output.put_line('Owner Type:'||l_group_type||':');
973: dbms_output.put_line('====');
974: fnd_message.set_name ('CS', 'CS_EA_CREATE_TASK_API_ERROR');
975: fnd_msg_pub.add;
976: *****/
977: raise fnd_api.g_exc_error;
978: end if;

Line 1013: fnd_message.set_name ('CS', 'CS_EA_START_WORKFLOW_ERROR');

1009: x_return_status ,
1010: x_msg_count ,
1011: x_msg_data );
1012: if (x_return_status <> fnd_api.g_ret_sts_success) then
1013: fnd_message.set_name ('CS', 'CS_EA_START_WORKFLOW_ERROR');
1014: fnd_msg_pub.add;
1015: raise fnd_api.g_exc_error;
1016: end if;
1017: end if;

Line 1035: FND_MESSAGE.SET_NAME('CS','CS_EA_NO_PARTY_SITE');

1031: EXCEPTION
1032: WHEN e_party_site_exception THEN
1033: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1034: p_data => x_msg_data );
1035: FND_MESSAGE.SET_NAME('CS','CS_EA_NO_PARTY_SITE');
1036: FND_MSG_PUB.ADD;
1037: x_return_status := FND_API.G_RET_STS_ERROR ;
1038: WHEN fnd_api.g_exc_error THEN
1039: rollback to create_extnd_attr_task_pvt;

Line 1052: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

1048: p_count => x_msg_count,
1049: p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: rollback to create_extnd_attr_task_pvt;
1052: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1053: fnd_message.set_token ('P_TEXT', SQLERRM);
1054: fnd_msg_pub.add;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: fnd_msg_pub.count_and_get (

Line 1053: fnd_message.set_token ('P_TEXT', SQLERRM);

1049: p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: rollback to create_extnd_attr_task_pvt;
1052: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1053: fnd_message.set_token ('P_TEXT', SQLERRM);
1054: fnd_msg_pub.add;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: fnd_msg_pub.count_and_get (
1057: p_count => x_msg_count,

Line 1376: fnd_message.set_name ('CS', 'CS_EA_NULL_NOTE_TYPE');

1372: l_err := l_err || l_msg_data || ',';
1373: end loop;
1374: l_note_type := fnd_profile.value('CS_SR_TASK_ERROR_NOTE_TYPE');
1375: if (l_note_type is null) then
1376: fnd_message.set_name ('CS', 'CS_EA_NULL_NOTE_TYPE');
1377: fnd_msg_pub.add;
1378: raise fnd_api.g_exc_unexpected_error;
1379: end if;
1380: l_login_id := fnd_global.login_id;

Line 1415: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

1411: fnd_msg_pub.count_and_get (
1412: p_count => x_msg_count,
1413: p_data => x_msg_data);
1414: WHEN OTHERS THEN
1415: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1416: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1417: fnd_msg_pub.add;
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: fnd_msg_pub.count_and_get (

Line 1416: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

1412: p_count => x_msg_count,
1413: p_data => x_msg_data);
1414: WHEN OTHERS THEN
1415: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1416: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1417: fnd_msg_pub.add;
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: fnd_msg_pub.count_and_get (
1420: p_count => x_msg_count,