58: THEN
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END IF;
61: -- Debug Message
62: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
63: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
64: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
65: FND_MSG_PUB.Add;
66: END IF;
61: -- Debug Message
62: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
63: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
64: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
65: FND_MSG_PUB.Add;
66: END IF;
67: --Initialize message list if p_init_msg_list is TRUE.
68: IF FND_API.To_Boolean (p_init_msg_list) THEN
69: FND_MSG_PUB.initialize;
65: FND_MSG_PUB.Add;
66: END IF;
67: --Initialize message list if p_init_msg_list is TRUE.
68: IF FND_API.To_Boolean (p_init_msg_list) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71: -- Initialize API return status to sucess
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
105: IF FND_API.To_Boolean ( p_commit ) THEN
106: COMMIT WORK;
107: END IF;
108: -- Debug Message
109: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
110: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
111: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
112: FND_MSG_PUB.Add;
113: END IF;
108: -- Debug Message
109: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
110: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
111: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
112: FND_MSG_PUB.Add;
113: END IF;
114: --Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
111: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
112: FND_MSG_PUB.Add;
113: END IF;
114: --Standard call to get message count and if count=1, get the message
115: FND_MSG_PUB.Count_And_Get (
116: p_encoded => FND_API.G_FALSE,
117: p_count => x_msg_count,
118: p_data => x_msg_data
119: );
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO Create_TaskTemplate_PVT;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data
129: );
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO Create_TaskTemplate_PVT;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data
138: );
138: );
139: WHEN OTHERS THEN
140: ROLLBACK TO Create_TaskTemplate_PVT;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
143: THEN
144: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
145: END IF;
146: -- Standard call to get message count and if count=1, get the message
140: ROLLBACK TO Create_TaskTemplate_PVT;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
143: THEN
144: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
145: END IF;
146: -- Standard call to get message count and if count=1, get the message
147: FND_MSG_PUB.Count_And_Get (
148: p_encoded => FND_API.G_FALSE,
143: THEN
144: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
145: END IF;
146: -- Standard call to get message count and if count=1, get the message
147: FND_MSG_PUB.Count_And_Get (
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,
150: p_data => x_msg_data
151: );
204: THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207: -- Debug Message
208: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
209: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
210: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
211: FND_MSG_PUB.Add;
212: END IF;
207: -- Debug Message
208: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
209: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
210: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
211: FND_MSG_PUB.Add;
212: END IF;
213: --Initialize message list if p_init_msg_list is TRUE.
214: IF FND_API.To_Boolean (p_init_msg_list) THEN
215: FND_MSG_PUB.initialize;
211: FND_MSG_PUB.Add;
212: END IF;
213: --Initialize message list if p_init_msg_list is TRUE.
214: IF FND_API.To_Boolean (p_init_msg_list) THEN
215: FND_MSG_PUB.initialize;
216: END IF;
217: -- Initialize API return status to sucess
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;
254: END IF;
255: -- Debug Message
256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
257: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
258: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
259: FND_MSG_PUB.Add;
260: END IF;
255: -- Debug Message
256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
257: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
258: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
259: FND_MSG_PUB.Add;
260: END IF;
261: --Standard call to get message count and if count=1, get the message
262: FND_MSG_PUB.Count_And_Get (
263: p_encoded => FND_API.G_FALSE,
258: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
259: FND_MSG_PUB.Add;
260: END IF;
261: --Standard call to get message count and if count=1, get the message
262: FND_MSG_PUB.Count_And_Get (
263: p_encoded => FND_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data
266: );
268: WHEN FND_API.G_EXC_ERROR THEN
269: ROLLBACK TO Update_TaskTemplate_PVT;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
276: );
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO Update_TaskTemplate_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data
285: );
285: );
286: WHEN OTHERS THEN
287: ROLLBACK TO Update_TaskTemplate_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message
287: ROLLBACK TO Update_TaskTemplate_PVT;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get (
295: p_encoded => FND_API.G_FALSE,
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
292: END IF;
293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get (
295: p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,
297: p_data => x_msg_data
298: );
350: THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353: -- Debug Message
354: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
355: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
356: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
357: FND_MSG_PUB.Add;
358: END IF;
353: -- Debug Message
354: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
355: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
356: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
357: FND_MSG_PUB.Add;
358: END IF;
359: --Initialize message list if p_init_msg_list is TRUE.
360: IF FND_API.To_Boolean (p_init_msg_list) THEN
361: FND_MSG_PUB.initialize;
357: FND_MSG_PUB.Add;
358: END IF;
359: --Initialize message list if p_init_msg_list is TRUE.
360: IF FND_API.To_Boolean (p_init_msg_list) THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363: -- Initialize API return status to sucess
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365:
363: -- Initialize API return status to sucess
364: x_return_status := FND_API.G_RET_STS_SUCCESS;
365:
366: IF p_task_template_id.count <> p_object_version_number.count THEN
367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
368: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_INCONSISTANT_TASK_RECORDS');
369: FND_MSG_PUB.Add;
370: END IF;
371: END IF;
365:
366: IF p_task_template_id.count <> p_object_version_number.count THEN
367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
368: FND_MESSAGE.Set_Name('OZF','OZF_CLAIM_INCONSISTANT_TASK_RECORDS');
369: FND_MSG_PUB.Add;
370: END IF;
371: END IF;
372:
373: BEGIN
394: IF FND_API.To_Boolean ( p_commit ) THEN
395: COMMIT WORK;
396: END IF;
397: -- Debug Message
398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
399: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
400: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
401: FND_MSG_PUB.Add;
402: END IF;
397: -- Debug Message
398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
399: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
400: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
401: FND_MSG_PUB.Add;
402: END IF;
403: --Standard call to get message count and if count=1, get the message
404: FND_MSG_PUB.Count_And_Get (
405: p_encoded => FND_API.G_FALSE,
400: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
401: FND_MSG_PUB.Add;
402: END IF;
403: --Standard call to get message count and if count=1, get the message
404: FND_MSG_PUB.Count_And_Get (
405: p_encoded => FND_API.G_FALSE,
406: p_count => x_msg_count,
407: p_data => x_msg_data
408: );
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO Delete_TaskTemplate_PVT;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: -- Standard call to get message count and if count=1, get the message
414: FND_MSG_PUB.Count_And_Get (
415: p_encoded => FND_API.G_FALSE,
416: p_count => x_msg_count,
417: p_data => x_msg_data
418: );
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
420: ROLLBACK TO Delete_TaskTemplate_PVT;
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data
427: );
427: );
428: WHEN OTHERS THEN
429: ROLLBACK TO Delete_TaskTemplate_PVT;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
434: END IF;
435: -- Standard call to get message count and if count=1, get the message
429: ROLLBACK TO Delete_TaskTemplate_PVT;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
432: THEN
433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
434: END IF;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE,
432: THEN
433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
434: END IF;
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get (
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_msg_count,
439: p_data => x_msg_data
440: );
536: THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539: -- Debug Message
540: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
541: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
542: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
543: FND_MSG_PUB.Add;
544: END IF;
539: -- Debug Message
540: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
541: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
542: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
543: FND_MSG_PUB.Add;
544: END IF;
545: --Initialize message list if p_init_msg_list is TRUE.
546: IF FND_API.To_Boolean (p_init_msg_list) THEN
547: FND_MSG_PUB.initialize;
543: FND_MSG_PUB.Add;
544: END IF;
545: --Initialize message list if p_init_msg_list is TRUE.
546: IF FND_API.To_Boolean (p_init_msg_list) THEN
547: FND_MSG_PUB.initialize;
548: END IF;
549: -- Initialize API return status to sucess
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
559: END LOOP;
560: CLOSE c_tasks;
561:
562: -- Debug Message
563: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
564: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
565: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
566: FND_MSG_PUB.Add;
567: END IF;
562: -- Debug Message
563: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
564: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
565: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
566: FND_MSG_PUB.Add;
567: END IF;
568: --Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
565: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
566: FND_MSG_PUB.Add;
567: END IF;
568: --Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );
575: WHEN FND_API.G_EXC_ERROR THEN
576: ROLLBACK TO Get_TaskTemplate_PVT;
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: -- Standard call to get message count and if count=1, get the message
579: FND_MSG_PUB.Count_And_Get (
580: p_encoded => FND_API.G_FALSE,
581: p_count => x_msg_count,
582: p_data => x_msg_data
583: );
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: ROLLBACK TO Get_TaskTemplate_PVT;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: -- Standard call to get message count and if count=1, get the message
588: FND_MSG_PUB.Count_And_Get (
589: p_encoded => FND_API.G_FALSE,
590: p_count => x_msg_count,
591: p_data => x_msg_data
592: );
592: );
593: WHEN OTHERS THEN
594: ROLLBACK TO Get_TaskTemplate_PVT;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
594: ROLLBACK TO Get_TaskTemplate_PVT;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );
654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: -- Debug Message
658: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
659: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
660: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
661: FND_MSG_PUB.Add;
662: END IF;
657: -- Debug Message
658: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
659: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
660: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
661: FND_MSG_PUB.Add;
662: END IF;
663: --Initialize message list if p_init_msg_list is TRUE.
664: IF FND_API.To_Boolean (p_init_msg_list) THEN
665: FND_MSG_PUB.initialize;
661: FND_MSG_PUB.Add;
662: END IF;
663: --Initialize message list if p_init_msg_list is TRUE.
664: IF FND_API.To_Boolean (p_init_msg_list) THEN
665: FND_MSG_PUB.initialize;
666: END IF;
667: -- Initialize API return status to sucess
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669:
700: END IF;
701: END IF;
702:
703: -- Debug Message
704: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
705: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
706: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
707: FND_MSG_PUB.Add;
708: END IF;
703: -- Debug Message
704: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
705: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
706: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
707: FND_MSG_PUB.Add;
708: END IF;
709: --Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
706: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
707: FND_MSG_PUB.Add;
708: END IF;
709: --Standard call to get message count and if count=1, get the message
710: FND_MSG_PUB.Count_And_Get (
711: p_encoded => FND_API.G_FALSE,
712: p_count => x_msg_count,
713: p_data => x_msg_data
714: );
716: WHEN FND_API.G_EXC_ERROR THEN
717: ROLLBACK TO Validate_TaskTemplate_PVT;
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: -- Standard call to get message count and if count=1, get the message
720: FND_MSG_PUB.Count_And_Get (
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data
724: );
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO Validate_TaskTemplate_PVT;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data
733: );
733: );
734: WHEN OTHERS THEN
735: ROLLBACK TO Validate_TaskTemplate_PVT;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
738: THEN
739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
740: END IF;
741: -- Standard call to get message count and if count=1, get the message
735: ROLLBACK TO Validate_TaskTemplate_PVT;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
738: THEN
739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
740: END IF;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => FND_API.G_FALSE,
738: THEN
739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
740: END IF;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_msg_count,
745: p_data => x_msg_data
746: );
877: OPEN c_task_template(p_task_template_rec.task_template_id);
878: FETCH c_task_template INTO l_task_template_rec;
879: IF c_task_template%NOTFOUND THEN
880: CLOSE c_task_template;
881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
882: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
883: FND_MSG_PUB.add;
884: END IF;
885: RAISE FND_API.g_exc_error;
879: IF c_task_template%NOTFOUND THEN
880: CLOSE c_task_template;
881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
882: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
883: FND_MSG_PUB.add;
884: END IF;
885: RAISE FND_API.g_exc_error;
886: END IF;
887: CLOSE c_task_template;