DBA Data[Home] [Help]

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on FND_MSG_PUB

Line 154: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

150: itemtype => p_workflow_type,
151: itemkey => l_itemkey
152: );
153:
154: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
155:
156: EXCEPTION
157: WHEN fnd_api.g_exc_unexpected_error THEN
158: ROLLBACK TO start_task_workflow;

Line 160: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

156: EXCEPTION
157: WHEN fnd_api.g_exc_unexpected_error THEN
158: ROLLBACK TO start_task_workflow;
159: x_return_status := fnd_api.g_ret_sts_unexp_error;
160: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
161: ---
162: WHEN OTHERS THEN
163: ROLLBACK TO start_task_workflow ;
164: wf_core.get_error(l_errname, l_errmsg, l_errstack);

Line 169: fnd_msg_pub.add;

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);
173: END;

Line 172: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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);
173: END;
174: procedure get_new_task_types(
175: p_task_tbl_old in ea_task_table_type,
176: p_task_tbl_new in ea_task_table_type,

Line 361: fnd_msg_pub.add;

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;
365: end if;

Line 391: fnd_msg_pub.add;

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;
395: end if;

Line 431: fnd_msg_pub.add;

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;
435: --------------------------------------------

Line 456: fnd_msg_pub.initialize;

452: begin
453: --
454: -- initialize message list
455: if fnd_api.to_boolean (p_init_msg_list) then
456: fnd_msg_pub.initialize;
457: end if;
458: --
459: -- check API version
460: if (p_api_version <> 1) then

Line 462: fnd_msg_pub.add;

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: --
466: -- check old incident type ID

Line 469: fnd_msg_pub.add;

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: --
473: -- check new incident type ID

Line 476: fnd_msg_pub.add;

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: ----------------------------------------------------------
480: l_task_count_new := 0;

Line 554: fnd_msg_pub.count_and_get (

550: --
551: EXCEPTION
552: WHEN fnd_api.g_exc_unexpected_error THEN
553: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 560: fnd_msg_pub.add;

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

Line 562: fnd_msg_pub.count_and_get (

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,
564: p_data => x_msg_data);
565: end get_affected_tasks;
566: --------------------------------------------

Line 588: fnd_msg_pub.initialize;

584: begin
585: --
586: -- initialize message list
587: if fnd_api.to_boolean (p_init_msg_list) then
588: fnd_msg_pub.initialize;
589: end if;
590: --
591: -- check API version
592: if (p_api_version <> 1) then

Line 594: fnd_msg_pub.add;

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: --
598: -- Check Service request id

Line 601: fnd_msg_pub.add;

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
605: l_sr_attr_found := 'n';

Line 630: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

626: null, null,
627: x_task_rec_table, l_indx);
628: --dbms_output.put_line('After get_task_for_sr_attribute call');
629: x_return_status := fnd_api.g_ret_sts_success;
630: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
631: --
632: -- Exception handling
633: --
634: EXCEPTION

Line 638: fnd_msg_pub.count_and_get (

634: EXCEPTION
635: WHEN fnd_api.g_exc_unexpected_error THEN
636: --dbms_output.put_line('get_extnd g_exc_unexpected error');
637: x_return_status := fnd_api.g_ret_sts_unexp_error;
638: fnd_msg_pub.count_and_get (
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');

Line 645: fnd_msg_pub.add;

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

Line 647: fnd_msg_pub.count_and_get (

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,
649: p_data => x_msg_data);
650: end get_extnd_attr_tasks;
651:

Line 796: fnd_msg_pub.add;

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
800: */

Line 806: fnd_msg_pub.add;

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;
810:

Line 815: fnd_msg_pub.add;

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;
819: -- no need to check task name, status, type and planned start date

Line 855: fnd_msg_pub.set_search_name('CS','CS_SR_TASK_NO_OWNER');

851: x_return_status => x_return_status,
852: x_msg_count => x_msg_count,
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;

Line 856: fnd_msg_pub.set_search_token('API_NAME','CS_SR_TASK_AUTOASSIGN_PKG.Assign_Task_Resource');

852: x_msg_count => x_msg_count,
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;

Line 859: l_dummy := fnd_msg_pub.change_msg;

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
863: IF (l_owner_type is null) then

Line 942: fnd_msg_pub.add;

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;
946:

Line 1007: fnd_msg_pub.add;

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;
1011: if (l_task_rec_tbl(l_indx).field_service_task_flag = 'Y') then

Line 1046: fnd_msg_pub.add;

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;
1050: else

Line 1051: fnd_msg_pub.initialize;

1047: raise fnd_api.g_exc_error;
1048: end if;
1049: end if;
1050: else
1051: fnd_msg_pub.initialize;
1052: end if; -- check for validity of task attributes such as type, status, priority
1053: end loop;
1054: end if;
1055: -- All task created

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

1061: --
1062: --raise_application_error(-20001,'For testing msg JTF_TASK_UNKNOWN_ERROR');
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 ;

Line 1068: FND_MSG_PUB.ADD;

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;
1072: x_return_status := fnd_api.g_ret_sts_error;

Line 1073: fnd_msg_pub.count_and_get (

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;
1072: x_return_status := fnd_api.g_ret_sts_error;
1073: fnd_msg_pub.count_and_get (
1074: p_count => x_msg_count,
1075: p_data => x_msg_data);
1076: WHEN fnd_api.g_exc_unexpected_error THEN
1077: rollback to create_extnd_attr_task_pvt;

Line 1079: fnd_msg_pub.count_and_get (

1075: p_data => x_msg_data);
1076: WHEN fnd_api.g_exc_unexpected_error THEN
1077: rollback to create_extnd_attr_task_pvt;
1078: x_return_status := fnd_api.g_ret_sts_unexp_error;
1079: fnd_msg_pub.count_and_get (
1080: p_count => x_msg_count,
1081: p_data => x_msg_data);
1082: WHEN OTHERS THEN
1083: rollback to create_extnd_attr_task_pvt;

Line 1086: fnd_msg_pub.add;

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

Line 1088: fnd_msg_pub.count_and_get (

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,
1090: p_data => x_msg_data);
1091: end create_extnd_attr_tasks;
1092: --------------------------------------------------

Line 1400: FND_MSG_PUB.Get(p_msg_index=>i,

1396: x_field_service_Task_created );
1397: --dbms_output.put_line('Return Message(isupp):'||x_return_status||':');
1398: if (x_return_status <> 'S') then
1399: for i in 1..x_msg_count loop
1400: FND_MSG_PUB.Get(p_msg_index=>i,
1401: p_encoded=>'F',
1402: p_data=>l_msg_data,
1403: p_msg_index_out=>l_msg_index_out);
1404: l_err := l_err || l_msg_data || ',';

Line 1409: fnd_msg_pub.add;

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;
1413: l_user_id := fnd_global.user_id ;

Line 1443: fnd_msg_pub.count_and_get (

1439: end if; -- profile option check
1440: EXCEPTION
1441: WHEN fnd_api.g_exc_unexpected_error THEN
1442: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 1449: fnd_msg_pub.add;

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

Line 1451: fnd_msg_pub.count_and_get (

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,
1453: p_data => x_msg_data);
1454: end ;
1455: ***** 9/30/2003 *******/