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 795: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_END_DATE');

791:
792: -- 2nd check: Planed End Date
793: /*
794: if (p_sr_rec.obligation_date is null) then
795: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_END_DATE');
796: fnd_msg_pub.add;
797: x_return_status := fnd_api.g_ret_sts_error;
798: raise fnd_api.g_exc_error;
799: else

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

800: */
801: --end if;
802: -- 3rd check: Planned Effort
803: if (l_task_rec_tbl(l_indx).planned_effort is null) then
804: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT');
805: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
806: fnd_msg_pub.add;
807: x_return_status := fnd_api.g_ret_sts_error;
808: raise fnd_api.g_exc_error;

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

801: --end if;
802: -- 3rd check: Planned Effort
803: if (l_task_rec_tbl(l_indx).planned_effort is null) then
804: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT');
805: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
806: fnd_msg_pub.add;
807: x_return_status := fnd_api.g_ret_sts_error;
808: raise fnd_api.g_exc_error;
809: end if;

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

809: end if;
810:
811: -- 4th check: Planned Effort UOM
812: if (l_task_rec_tbl(l_indx).planned_effort_uom is null) then
813: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT_UOM');
814: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
815: fnd_msg_pub.add;
816: x_return_status := fnd_api.g_ret_sts_error;
817: raise fnd_api.g_exc_error;

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

810:
811: -- 4th check: Planned Effort UOM
812: if (l_task_rec_tbl(l_indx).planned_effort_uom is null) then
813: fnd_message.set_name ('CS', 'CS_EA_NO_PLANNED_EFFORT_UOM');
814: fnd_message.set_token('P_TYPE_ID',l_task_rec_tbl(l_indx).task_type_id);
815: fnd_msg_pub.add;
816: x_return_status := fnd_api.g_ret_sts_error;
817: raise fnd_api.g_exc_error;
818: end if;

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

853: x_msg_data => x_msg_data);
854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
855: fnd_msg_pub.set_search_name('CS','CS_SR_TASK_NO_OWNER');
856: fnd_msg_pub.set_search_token('API_NAME','CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource');
857: fnd_message.set_name ('CS', 'CS_EA_ASSIGN_TASK_ERROR');
858: fnd_message.set_token('TASK_NAME',l_task_rec_tbl(l_indx).task_name);
859: l_dummy := fnd_msg_pub.change_msg;
860: raise fnd_api.g_exc_error;
861:

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

854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
855: fnd_msg_pub.set_search_name('CS','CS_SR_TASK_NO_OWNER');
856: fnd_msg_pub.set_search_token('API_NAME','CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource');
857: fnd_message.set_name ('CS', 'CS_EA_ASSIGN_TASK_ERROR');
858: fnd_message.set_token('TASK_NAME',l_task_rec_tbl(l_indx).task_name);
859: l_dummy := fnd_msg_pub.change_msg;
860: raise fnd_api.g_exc_error;
861:
862: ELSE

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

935: open c_task_type_name(l_task_rec_tbl(l_indx).task_type_id);
936: fetch c_task_type_name into l_task_type_name;
937: close c_task_type_name;
938:
939: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');
940: fnd_message.set_token('TASK_TYPE',l_task_type_name);
941: fnd_message.set_token('API_NAME',l_api_name);
942: fnd_msg_pub.add;
943: x_return_status := fnd_api.g_ret_sts_error;

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

936: fetch c_task_type_name into l_task_type_name;
937: close c_task_type_name;
938:
939: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');
940: fnd_message.set_token('TASK_TYPE',l_task_type_name);
941: fnd_message.set_token('API_NAME',l_api_name);
942: fnd_msg_pub.add;
943: x_return_status := fnd_api.g_ret_sts_error;
944: raise fnd_api.g_exc_error;

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

937: close c_task_type_name;
938:
939: fnd_message.set_name ('CS', 'CS_EA_DATE_PAIR_ERROR');
940: fnd_message.set_token('TASK_TYPE',l_task_type_name);
941: fnd_message.set_token('API_NAME',l_api_name);
942: fnd_msg_pub.add;
943: x_return_status := fnd_api.g_ret_sts_error;
944: raise fnd_api.g_exc_error;
945: END IF;

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

1002: dbms_output.put_line('Owner Type:'||l_owner_type||':');
1003: dbms_output.put_line(':'||to_char(l_owner_group_id));
1004: dbms_output.put_line('Owner Type:'||l_group_type||':');
1005: dbms_output.put_line('====');
1006: fnd_message.set_name ('CS', 'CS_EA_CREATE_TASK_API_ERROR');
1007: fnd_msg_pub.add;
1008: *****/
1009: raise fnd_api.g_exc_error;
1010: end if;

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

1041: x_return_status ,
1042: x_msg_count ,
1043: x_msg_data );
1044: if (x_return_status <> fnd_api.g_ret_sts_success) then
1045: fnd_message.set_name ('CS', 'CS_EA_START_WORKFLOW_ERROR');
1046: fnd_msg_pub.add;
1047: raise fnd_api.g_exc_error;
1048: end if;
1049: end if;

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

1063: EXCEPTION
1064: WHEN e_party_site_exception THEN
1065: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1066: p_data => x_msg_data );
1067: FND_MESSAGE.SET_NAME('CS','CS_EA_NO_PARTY_SITE');
1068: FND_MSG_PUB.ADD;
1069: x_return_status := FND_API.G_RET_STS_ERROR ;
1070: WHEN fnd_api.g_exc_error THEN
1071: rollback to create_extnd_attr_task_pvt;

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

1080: p_count => x_msg_count,
1081: p_data => x_msg_data);
1082: WHEN OTHERS THEN
1083: rollback to create_extnd_attr_task_pvt;
1084: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1085: fnd_message.set_token ('P_TEXT', SQLERRM);
1086: fnd_msg_pub.add;
1087: x_return_status := fnd_api.g_ret_sts_unexp_error;
1088: fnd_msg_pub.count_and_get (

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

1081: p_data => x_msg_data);
1082: WHEN OTHERS THEN
1083: rollback to create_extnd_attr_task_pvt;
1084: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1085: fnd_message.set_token ('P_TEXT', SQLERRM);
1086: fnd_msg_pub.add;
1087: x_return_status := fnd_api.g_ret_sts_unexp_error;
1088: fnd_msg_pub.count_and_get (
1089: p_count => x_msg_count,

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

1404: l_err := l_err || l_msg_data || ',';
1405: end loop;
1406: l_note_type := fnd_profile.value('CS_SR_TASK_ERROR_NOTE_TYPE');
1407: if (l_note_type is null) then
1408: fnd_message.set_name ('CS', 'CS_EA_NULL_NOTE_TYPE');
1409: fnd_msg_pub.add;
1410: raise fnd_api.g_exc_unexpected_error;
1411: end if;
1412: l_login_id := fnd_global.login_id;

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

1443: fnd_msg_pub.count_and_get (
1444: p_count => x_msg_count,
1445: p_data => x_msg_data);
1446: WHEN OTHERS THEN
1447: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1448: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1449: fnd_msg_pub.add;
1450: x_return_status := fnd_api.g_ret_sts_unexp_error;
1451: fnd_msg_pub.count_and_get (

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

1444: p_count => x_msg_count,
1445: p_data => x_msg_data);
1446: WHEN OTHERS THEN
1447: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1448: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1449: fnd_msg_pub.add;
1450: x_return_status := fnd_api.g_ret_sts_unexp_error;
1451: fnd_msg_pub.count_and_get (
1452: p_count => x_msg_count,