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.

APPS.CS_EA_AUTOGEN_TASKS_PVT dependencies on FND_API

Line 54: x_return_status := fnd_api.g_ret_sts_success;

50: FROM dual;
51:
52: BEGIN
53: SAVEPOINT start_task_workflow;
54: x_return_status := fnd_api.g_ret_sts_success;
55:
56: OPEN c_wf_processs_id;
57: FETCH c_wf_processs_id INTO l_wf_process_id;
58: CLOSE c_wf_processs_id;

Line 157: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 159: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 171: x_return_status := fnd_api.g_ret_sts_unexp_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;
174: procedure get_new_task_types(
175: p_task_tbl_old in ea_task_table_type,

Line 364: raise fnd_api.g_exc_unexpected_error;

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;
366: close c_task_attributes;
367: p_task_count := p_task_count + 1;
368: p_taskrec_table(p_task_count).task_name := l_task_name;

Line 394: raise fnd_api.g_exc_unexpected_error;

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;
396: close c_planned_effort;
397: p_taskrec_table(p_task_count).workflow := l_workflow;
398: p_taskrec_table(p_task_count).workflow_type := l_workflow_type;

Line 455: if fnd_api.to_boolean (p_init_msg_list) then

451: l_task_count_old number;
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

Line 463: raise fnd_api.g_exc_unexpected_error;

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
467: if (p_incident_type_id_old is null) then

Line 470: raise fnd_api.g_exc_unexpected_error;

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
474: if (p_incident_type_id_new is null) then

Line 477: raise fnd_api.g_exc_unexpected_error;

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;
481: l_task_count_old := 0;

Line 552: WHEN fnd_api.g_exc_unexpected_error THEN

548: --
549: -- Exception handling
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);

Line 553: x_return_status := fnd_api.g_ret_sts_unexp_error;

549: -- Exception handling
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

Line 561: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
565: end get_affected_tasks;

Line 587: if fnd_api.to_boolean (p_init_msg_list) then

583: l_indx number;
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

Line 595: raise fnd_api.g_exc_unexpected_error;

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
599: if (p_request_id is null) then

Line 602: raise fnd_api.g_exc_unexpected_error;

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';
606: l_indx := 0;

Line 629: x_return_status := fnd_api.g_ret_sts_success;

625: get_tasks_for_sr_attribute(p_sr_rec.type_id,
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: --

Line 635: WHEN fnd_api.g_exc_unexpected_error THEN

631: --
632: -- Exception handling
633: --
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,

Line 637: x_return_status := fnd_api.g_ret_sts_unexp_error;

633: --
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

Line 646: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
650: end get_extnd_attr_tasks;

Line 744: if (x_return_status = fnd_api.g_ret_sts_success) then

740: x_msg_data => x_msg_data,
741: x_task_rec_table => l_task_rec_tbl);
742: --dbms_output.put_line('Return Status(get_extnd_attr_tasks):'||x_return_status|| ':');
743: -- Create Tasks
744: if (x_return_status = fnd_api.g_ret_sts_success) then
745: --l_login_id := fnd_global.login_id;
746: --l_user_id := fnd_global.user_id ;
747: -- Task api does not take user ids as parameter
748:

Line 787: x_return_status := fnd_api.g_ret_sts_error;

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: */
791: --end if;

Line 788: raise fnd_api.g_exc_error;

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: */
791: --end if;
792: -- 3rd check: Planned Effort

Line 797: x_return_status := fnd_api.g_ret_sts_error;

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
801: if (l_task_rec_tbl(l_indx).planned_effort_uom is null) then

Line 798: raise fnd_api.g_exc_error;

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

Line 805: x_return_status := fnd_api.g_ret_sts_error;

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
809: -- as these can not be null. these are not null in respective

Line 806: raise fnd_api.g_exc_error;

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
809: -- as these can not be null. these are not null in respective
810: -- source tables. planned_start_date is always set to sysdate

Line 828: p_init_msg_list => fnd_api.g_false,

824:
825: l_sr_rec.type_id := null;
826: cs_sr_task_autoassign_pkg.assign_task_resource(
827: p_api_version => 1,
828: p_init_msg_list => fnd_api.g_false,
829: p_commit => fnd_api.g_false,
830: p_incident_id => p_request_id,
831: p_service_request_rec => l_sr_rec,
832: p_task_attribute_rec => l_task_attr_rec,

Line 829: p_commit => fnd_api.g_false,

825: l_sr_rec.type_id := null;
826: cs_sr_task_autoassign_pkg.assign_task_resource(
827: p_api_version => 1,
828: p_init_msg_list => fnd_api.g_false,
829: p_commit => fnd_api.g_false,
830: p_incident_id => p_request_id,
831: p_service_request_rec => l_sr_rec,
832: p_task_attribute_rec => l_task_attr_rec,
833: x_owner_group_id => l_owner_group_id,

Line 840: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

836: x_owner_id => l_owner_id,
837: x_return_status => x_return_status,
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');

Line 847: --raise fnd_api.g_exc_error;

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
851: l_task_owner_type := l_group_type;

Line 848: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
851: l_task_owner_type := l_group_type;
852: l_task_owner_id := l_owner_group_id;

Line 889: l_task_rec_tbl(l_indx).planned_start_date <> FND_API.G_MISS_DATE)

885:
886: -- The palnned start date and planned end date should appear in pair.
887: -- If not,exception is thrown
888: IF ( ( (l_task_rec_tbl(l_indx).planned_start_date IS NOT NULL AND
889: l_task_rec_tbl(l_indx).planned_start_date <> FND_API.G_MISS_DATE)
890: AND
891: (l_task_rec_tbl(l_indx).planned_end_date IS NULL OR
892: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)
893: )

Line 892: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)

888: IF ( ( (l_task_rec_tbl(l_indx).planned_start_date IS NOT NULL AND
889: l_task_rec_tbl(l_indx).planned_start_date <> FND_API.G_MISS_DATE)
890: AND
891: (l_task_rec_tbl(l_indx).planned_end_date IS NULL OR
892: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)
893: )
894: OR
895: ( (l_task_rec_tbl(l_indx).planned_end_date IS NOT NULL AND
896: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)

Line 896: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)

892: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)
893: )
894: OR
895: ( (l_task_rec_tbl(l_indx).planned_end_date IS NOT NULL AND
896: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)
897: AND
898: (l_task_rec_tbl(l_indx).planned_start_date IS NULL OR
899: l_task_rec_tbl(l_indx).planned_start_date = FND_API.G_MISS_DATE)
900: )

Line 899: l_task_rec_tbl(l_indx).planned_start_date = FND_API.G_MISS_DATE)

895: ( (l_task_rec_tbl(l_indx).planned_end_date IS NOT NULL AND
896: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)
897: AND
898: (l_task_rec_tbl(l_indx).planned_start_date IS NULL OR
899: l_task_rec_tbl(l_indx).planned_start_date = FND_API.G_MISS_DATE)
900: )
901: )THEN
902:
903: open c_task_type_name(l_task_rec_tbl(l_indx).task_type_id);

Line 911: x_return_status := fnd_api.g_ret_sts_error;

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:
915: -- no validations for scheduled and actual dates as the parameters are not passed

Line 912: raise fnd_api.g_exc_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:
915: -- no validations for scheduled and actual dates as the parameters are not passed
916:

Line 924: p_init_msg_list => fnd_api.g_false,

920: -- local variable l_date_selected
921:
922: jtf_tasks_pub.create_task (
923: p_api_version => 1.0,
924: p_init_msg_list => fnd_api.g_false,
925: p_commit => fnd_api.g_false,
926: p_task_name => l_task_rec_tbl(l_indx).task_name,
927: p_description => l_task_rec_tbl(l_indx).task_description,
928: p_task_type_id => l_task_rec_tbl(l_indx).task_type_id,

Line 925: p_commit => fnd_api.g_false,

921:
922: jtf_tasks_pub.create_task (
923: p_api_version => 1.0,
924: p_init_msg_list => fnd_api.g_false,
925: p_commit => fnd_api.g_false,
926: p_task_name => l_task_rec_tbl(l_indx).task_name,
927: p_description => l_task_rec_tbl(l_indx).task_description,
928: p_task_type_id => l_task_rec_tbl(l_indx).task_type_id,
929: p_task_status_id => l_task_rec_tbl(l_indx).task_status_id,

Line 953: if (x_return_status <> fnd_api.g_ret_sts_success) then

949: x_msg_data => x_msg_data,
950: x_task_id => l_task_id)
951: ;
952: --dbms_output.put_line('after Create Task:'||x_return_status);
953: if (x_return_status <> fnd_api.g_ret_sts_success) then
954: /***
955: dbms_output.put_line(l_task_rec_tbl(l_indx).task_name);
956: dbms_output.put_line(l_task_rec_tbl(l_indx).task_description);
957: dbms_output.put_line(l_task_rec_tbl(l_indx).task_type_id);

Line 977: raise fnd_api.g_exc_error;

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
980: x_field_service_task_created := 'Y';
981: end if;

Line 997: If (x_return_status <> fnd_api.g_ret_sts_success) Then

993: x_msg_count => x_msg_count,
994: x_msg_data => x_msg_data,
995: x_task_assignment_id => l_task_assignment_id);
996:
997: If (x_return_status <> fnd_api.g_ret_sts_success) Then
998: raise fnd_api.g_exc_error;
999: End if;
1000: End If;
1001: /* End : 5686743 */

Line 998: raise fnd_api.g_exc_error;

994: x_msg_data => x_msg_data,
995: x_task_assignment_id => l_task_assignment_id);
996:
997: If (x_return_status <> fnd_api.g_ret_sts_success) Then
998: raise fnd_api.g_exc_error;
999: End if;
1000: End If;
1001: /* End : 5686743 */
1002: if (l_task_rec_tbl(l_indx).workflow is not null) then

Line 1012: if (x_return_status <> fnd_api.g_ret_sts_success) then

1008: l_task_rec_tbl(l_indx).task_description,
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;

Line 1015: raise fnd_api.g_exc_error;

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
1019: fnd_msg_pub.initialize;

Line 1024: if fnd_api.to_boolean (p_commit) then

1020: end if; -- check for validity of task attributes such as type, status, priority
1021: end loop;
1022: end if;
1023: -- All task created
1024: if fnd_api.to_boolean (p_commit) then
1025: commit;
1026: end if;
1027: --
1028: -- Exception handling

Line 1037: x_return_status := FND_API.G_RET_STS_ERROR ;

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;
1041: fnd_msg_pub.count_and_get (

Line 1038: WHEN fnd_api.g_exc_error THEN

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;
1041: fnd_msg_pub.count_and_get (
1042: p_count => x_msg_count,

Line 1040: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1044: WHEN fnd_api.g_exc_unexpected_error THEN

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;
1046: x_return_status := fnd_api.g_ret_sts_unexp_error;
1047: fnd_msg_pub.count_and_get (
1048: p_count => x_msg_count,

Line 1046: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1055: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1059: end create_extnd_attr_tasks;

Line 1078: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1074: x_return_status => x_return_status,
1075: x_task_type_id => l_type_id
1076: );
1077:
1078: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1079: return 'N';
1080: END IF;
1081:
1082: IF l_type_id IS NULL THEN

Line 1101: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1097: p_validation_type => l_type,
1098: x_return_status => x_return_status,
1099: x_task_status_id => l_status_id);
1100:
1101: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1102: return 'N';
1103: END IF;
1104: -------
1105: jtf_task_utl.validate_task_priority ( p_task_priority_id => p_task_priority_id,

Line 1109: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1105: jtf_task_utl.validate_task_priority ( p_task_priority_id => p_task_priority_id,
1106: p_task_priority_name => l_priority,
1107: x_return_status => x_return_status,
1108: x_task_priority_id => l_priority_id);
1109: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1110: return 'N';
1111: END IF;
1112: -- All task attrributes are valid
1113: return 'Y';

Line 1121: p_init_msg_list in varchar2 := fnd_api.g_false,

1117: END;
1118: /**** not used anymore 9/30/2003
1119: procedure create_ea_tasks_isupp (
1120: p_api_version in number,
1121: p_init_msg_list in varchar2 := fnd_api.g_false,
1122: p_commit in varchar2 := fnd_api.g_false,
1123: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
1124: p_request_id in number ,
1125: x_return_status OUT NOCOPY varchar2,

Line 1122: p_commit in varchar2 := fnd_api.g_false,

1118: /**** not used anymore 9/30/2003
1119: procedure create_ea_tasks_isupp (
1120: p_api_version in number,
1121: p_init_msg_list in varchar2 := fnd_api.g_false,
1122: p_commit in varchar2 := fnd_api.g_false,
1123: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
1124: p_request_id in number ,
1125: x_return_status OUT NOCOPY varchar2,
1126: x_msg_count OUT NOCOPY number,

Line 1378: raise fnd_api.g_exc_unexpected_error;

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 ;
1382: jtf_notes_pub.create_note(

Line 1386: p_validation_level => fnd_api.g_valid_level_full,

1382: jtf_notes_pub.create_note(
1383: p_api_version => 1,
1384: p_init_msg_list => p_init_msg_list,
1385: p_commit => p_commit,
1386: p_validation_level => fnd_api.g_valid_level_full,
1387: x_return_status => x_return_status,
1388: x_msg_count => x_msg_count,
1389: x_msg_data => x_msg_data,
1390: p_entered_by => l_user_id,

Line 1409: WHEN fnd_api.g_exc_unexpected_error THEN

1405: --dbms_output.put_line('Return Message(note):'||x_return_status||':');
1406: end if; -- check for errors returned by autogen api
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);

Line 1410: x_return_status := fnd_api.g_ret_sts_unexp_error;

1406: end if; -- check for errors returned by autogen api
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

Line 1418: x_return_status := fnd_api.g_ret_sts_unexp_error;

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);
1422: end ;