eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 786: fnd_msg_pub.add;

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

Line 796: fnd_msg_pub.add;

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;
800: -- 4th check: Planned Effort UOM

Line 804: fnd_msg_pub.add;

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

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

838: x_msg_count => x_msg_count,
839: x_msg_data => x_msg_data);
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;

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

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

Line 846: --l_dummy := fnd_msg_pub.change_msg;

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

Line 910: fnd_msg_pub.add;

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

Line 975: fnd_msg_pub.add;

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

Line 1014: fnd_msg_pub.add;

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

Line 1019: fnd_msg_pub.initialize;

1015: raise fnd_api.g_exc_error;
1016: end if;
1017: end if;
1018: else
1019: fnd_msg_pub.initialize;
1020: end if; -- check for validity of task attributes such as type, status, priority
1021: end loop;
1022: end if;
1023: -- All task created

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

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

Line 1036: FND_MSG_PUB.ADD;

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

Line 1041: fnd_msg_pub.count_and_get (

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;
1040: x_return_status := fnd_api.g_ret_sts_error;
1041: fnd_msg_pub.count_and_get (
1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044: WHEN fnd_api.g_exc_unexpected_error THEN
1045: rollback to create_extnd_attr_task_pvt;

Line 1047: fnd_msg_pub.count_and_get (

1043: p_data => x_msg_data);
1044: WHEN fnd_api.g_exc_unexpected_error THEN
1045: rollback to create_extnd_attr_task_pvt;
1046: x_return_status := fnd_api.g_ret_sts_unexp_error;
1047: fnd_msg_pub.count_and_get (
1048: p_count => x_msg_count,
1049: p_data => x_msg_data);
1050: WHEN OTHERS THEN
1051: rollback to create_extnd_attr_task_pvt;

Line 1054: fnd_msg_pub.add;

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

Line 1056: fnd_msg_pub.count_and_get (

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,
1058: p_data => x_msg_data);
1059: end create_extnd_attr_tasks;
1060: --------------------------------------------------

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

1364: x_field_service_Task_created );
1365: --dbms_output.put_line('Return Message(isupp):'||x_return_status||':');
1366: if (x_return_status <> 'S') then
1367: for i in 1..x_msg_count loop
1368: FND_MSG_PUB.Get(p_msg_index=>i,
1369: p_encoded=>'F',
1370: p_data=>l_msg_data,
1371: p_msg_index_out=>l_msg_index_out);
1372: l_err := l_err || l_msg_data || ',';

Line 1377: fnd_msg_pub.add;

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

Line 1411: fnd_msg_pub.count_and_get (

1407: end if; -- profile option check
1408: EXCEPTION
1409: WHEN fnd_api.g_exc_unexpected_error THEN
1410: x_return_status := fnd_api.g_ret_sts_unexp_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');

Line 1417: fnd_msg_pub.add;

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

Line 1419: fnd_msg_pub.count_and_get (

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,
1421: p_data => x_msg_data);
1422: end ;
1423: ***** 9/30/2003 *******/