[Home] [Help]
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;
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: ---
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 ;
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,
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;
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;
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
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
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
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;
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);
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
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;
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
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
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;
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: --
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,
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
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;
749: x_task_rec_table => l_task_rec_tbl);
750: --dbms_output.put_line('Return Status(get_extnd_attr_tasks):'||x_return_status|| ':');
751: -- Create Tasks
752:
753: if (x_return_status = fnd_api.g_ret_sts_success) then
754: --l_login_id := fnd_global.login_id;
755: --l_user_id := fnd_global.user_id ;
756: -- Task api does not take user ids as parameter
757:
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: */
801: --end if;
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: */
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;
810:
811: -- 4th check: Planned Effort UOM
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:
811: -- 4th check: Planned Effort UOM
812: if (l_task_rec_tbl(l_indx).planned_effort_uom is null) then
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
820: -- as these can not be null. these are not null in respective
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
820: -- as these can not be null. these are not null in respective
821: -- source tables. planned_start_date is always set to sysdate
837: If l_task_owner_type is null or l_task_owner_id is null then
838: l_sr_rec.type_id := null;
839: cs_sr_task_autoassign_pkg.assign_task_resource(
840: p_api_version => 1,
841: p_init_msg_list => fnd_api.g_false,
842: p_commit => fnd_api.g_false,
843: p_incident_id => p_request_id,
844: p_service_request_rec => l_sr_rec,
845: p_task_attribute_rec => l_task_attr_rec,
838: l_sr_rec.type_id := null;
839: cs_sr_task_autoassign_pkg.assign_task_resource(
840: p_api_version => 1,
841: p_init_msg_list => fnd_api.g_false,
842: p_commit => fnd_api.g_false,
843: p_incident_id => p_request_id,
844: p_service_request_rec => l_sr_rec,
845: p_task_attribute_rec => l_task_attr_rec,
846: x_owner_group_id => l_owner_group_id,
850: x_territory_id => l_owner_territory_id ,
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);
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
864: l_task_owner_type := l_group_type;
917:
918: -- The palnned start date and planned end date should appear in pair.
919: -- If not,exception is thrown
920: IF ( ( (l_task_rec_tbl(l_indx).planned_start_date IS NOT NULL AND
921: l_task_rec_tbl(l_indx).planned_start_date <> FND_API.G_MISS_DATE)
922: AND
923: (l_task_rec_tbl(l_indx).planned_end_date IS NULL OR
924: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)
925: )
920: IF ( ( (l_task_rec_tbl(l_indx).planned_start_date IS NOT NULL AND
921: l_task_rec_tbl(l_indx).planned_start_date <> FND_API.G_MISS_DATE)
922: AND
923: (l_task_rec_tbl(l_indx).planned_end_date IS NULL OR
924: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)
925: )
926: OR
927: ( (l_task_rec_tbl(l_indx).planned_end_date IS NOT NULL AND
928: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)
924: l_task_rec_tbl(l_indx).planned_end_date = FND_API.G_MISS_DATE)
925: )
926: OR
927: ( (l_task_rec_tbl(l_indx).planned_end_date IS NOT NULL AND
928: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)
929: AND
930: (l_task_rec_tbl(l_indx).planned_start_date IS NULL OR
931: l_task_rec_tbl(l_indx).planned_start_date = FND_API.G_MISS_DATE)
932: )
927: ( (l_task_rec_tbl(l_indx).planned_end_date IS NOT NULL AND
928: l_task_rec_tbl(l_indx).planned_end_date <> FND_API.G_MISS_DATE)
929: AND
930: (l_task_rec_tbl(l_indx).planned_start_date IS NULL OR
931: l_task_rec_tbl(l_indx).planned_start_date = FND_API.G_MISS_DATE)
932: )
933: )THEN
934:
935: open c_task_type_name(l_task_rec_tbl(l_indx).task_type_id);
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:
947: -- no validations for scheduled and actual dates as the parameters are not passed
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:
947: -- no validations for scheduled and actual dates as the parameters are not passed
948:
952: -- local variable l_date_selected
953:
954: jtf_tasks_pub.create_task (
955: p_api_version => 1.0,
956: p_init_msg_list => fnd_api.g_false,
957: p_commit => fnd_api.g_false,
958: p_task_name => l_task_rec_tbl(l_indx).task_name,
959: p_description => l_task_rec_tbl(l_indx).task_description,
960: p_task_type_id => l_task_rec_tbl(l_indx).task_type_id,
953:
954: jtf_tasks_pub.create_task (
955: p_api_version => 1.0,
956: p_init_msg_list => fnd_api.g_false,
957: p_commit => fnd_api.g_false,
958: p_task_name => l_task_rec_tbl(l_indx).task_name,
959: p_description => l_task_rec_tbl(l_indx).task_description,
960: p_task_type_id => l_task_rec_tbl(l_indx).task_type_id,
961: p_task_status_id => l_task_rec_tbl(l_indx).task_status_id,
981: x_msg_data => x_msg_data,
982: x_task_id => l_task_id)
983: ;
984: --dbms_output.put_line('after Create Task:'||x_return_status);
985: if (x_return_status <> fnd_api.g_ret_sts_success) then
986: /***
987: dbms_output.put_line(l_task_rec_tbl(l_indx).task_name);
988: dbms_output.put_line(l_task_rec_tbl(l_indx).task_description);
989: dbms_output.put_line(l_task_rec_tbl(l_indx).task_type_id);
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
1012: x_field_service_task_created := 'Y';
1013: end if;
1025: x_msg_count => x_msg_count,
1026: x_msg_data => x_msg_data,
1027: x_task_assignment_id => l_task_assignment_id);
1028:
1029: If (x_return_status <> fnd_api.g_ret_sts_success) Then
1030: raise fnd_api.g_exc_error;
1031: End if;
1032: End If;
1033: /* End : 5686743 */
1026: x_msg_data => x_msg_data,
1027: x_task_assignment_id => l_task_assignment_id);
1028:
1029: If (x_return_status <> fnd_api.g_ret_sts_success) Then
1030: raise fnd_api.g_exc_error;
1031: End if;
1032: End If;
1033: /* End : 5686743 */
1034: if (l_task_rec_tbl(l_indx).workflow is not null) then
1040: l_task_rec_tbl(l_indx).task_description,
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;
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
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
1056: if fnd_api.to_boolean (p_commit) then
1057: commit;
1058: end if;
1059: --
1060: -- Exception handling
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;
1073: fnd_msg_pub.count_and_get (
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;
1073: fnd_msg_pub.count_and_get (
1074: p_count => x_msg_count,
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;
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
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;
1078: x_return_status := fnd_api.g_ret_sts_unexp_error;
1079: fnd_msg_pub.count_and_get (
1080: p_count => x_msg_count,
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;
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;
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;
1106: x_return_status => x_return_status,
1107: x_task_type_id => l_type_id
1108: );
1109:
1110: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1111: return 'N';
1112: END IF;
1113:
1114: IF l_type_id IS NULL THEN
1129: p_validation_type => l_type,
1130: x_return_status => x_return_status,
1131: x_task_status_id => l_status_id);
1132:
1133: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1134: return 'N';
1135: END IF;
1136: -------
1137: jtf_task_utl.validate_task_priority ( p_task_priority_id => p_task_priority_id,
1137: jtf_task_utl.validate_task_priority ( p_task_priority_id => p_task_priority_id,
1138: p_task_priority_name => l_priority,
1139: x_return_status => x_return_status,
1140: x_task_priority_id => l_priority_id);
1141: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1142: return 'N';
1143: END IF;
1144: -- All task attrributes are valid
1145: return 'Y';
1149: END;
1150: /**** not used anymore 9/30/2003
1151: procedure create_ea_tasks_isupp (
1152: p_api_version in number,
1153: p_init_msg_list in varchar2 := fnd_api.g_false,
1154: p_commit in varchar2 := fnd_api.g_false,
1155: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
1156: p_request_id in number ,
1157: x_return_status OUT NOCOPY varchar2,
1150: /**** not used anymore 9/30/2003
1151: procedure create_ea_tasks_isupp (
1152: p_api_version in number,
1153: p_init_msg_list in varchar2 := fnd_api.g_false,
1154: p_commit in varchar2 := fnd_api.g_false,
1155: p_sr_attributes_tbl in EA_SR_ATTR_TABLE_TYPE,
1156: p_request_id in number ,
1157: x_return_status OUT NOCOPY varchar2,
1158: x_msg_count OUT NOCOPY number,
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 ;
1414: jtf_notes_pub.create_note(
1414: jtf_notes_pub.create_note(
1415: p_api_version => 1,
1416: p_init_msg_list => p_init_msg_list,
1417: p_commit => p_commit,
1418: p_validation_level => fnd_api.g_valid_level_full,
1419: x_return_status => x_return_status,
1420: x_msg_count => x_msg_count,
1421: x_msg_data => x_msg_data,
1422: p_entered_by => l_user_id,
1437: --dbms_output.put_line('Return Message(note):'||x_return_status||':');
1438: end if; -- check for errors returned by autogen api
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);
1438: end if; -- check for errors returned by autogen api
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
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);
1454: end ;