[Home] [Help]
46: l_Error_Token varchar2(80);
47: l_object_version_number number := 1;
48: --
49: BEGIN
50: -- Standard begin of API savepoint
51: SAVEPOINT Create_TaskTemplate_PVT;
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call (
54: l_api_version,
48: --
49: BEGIN
50: -- Standard begin of API savepoint
51: SAVEPOINT Create_TaskTemplate_PVT;
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call (
54: l_api_version,
55: p_api_version,
56: l_api_name,
100: WHEN OTHERS THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END;
103:
104: --Standard check of commit
105: IF FND_API.To_Boolean ( p_commit ) THEN
106: COMMIT WORK;
107: END IF;
108: -- Debug Message
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,
117: p_count => x_msg_count,
118: p_data => x_msg_data
120: EXCEPTION
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
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,
149: p_count => x_msg_count,
150: p_data => x_msg_data
192: l_Error_Token varchar2(80);
193: l_object_version_number number := 1;
194: --
195: BEGIN
196: -- Standard begin of API savepoint
197: SAVEPOINT Update_TaskTemplate_PVT;
198: -- Standard call to check for call compatibility.
199: IF NOT FND_API.Compatible_API_Call (
200: l_api_version,
194: --
195: BEGIN
196: -- Standard begin of API savepoint
197: SAVEPOINT Update_TaskTemplate_PVT;
198: -- Standard call to check for call compatibility.
199: IF NOT FND_API.Compatible_API_Call (
200: l_api_version,
201: p_api_version,
202: l_api_name,
247: WHEN OTHERS THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END;
250:
251: --Standard check of commit
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;
254: END IF;
255: -- Debug Message
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,
264: p_count => x_msg_count,
265: p_data => x_msg_data
267: EXCEPTION
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
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,
296: p_count => x_msg_count,
297: p_data => x_msg_data
338: l_Error_Token varchar2(80);
339: l_object_version_number number := 1;
340: --
341: BEGIN
342: -- Standard begin of API savepoint
343: SAVEPOINT Delete_TaskTemplate_PVT;
344: -- Standard call to check for call compatibility.
345: IF NOT FND_API.Compatible_API_Call (
346: l_api_version,
340: --
341: BEGIN
342: -- Standard begin of API savepoint
343: SAVEPOINT Delete_TaskTemplate_PVT;
344: -- Standard call to check for call compatibility.
345: IF NOT FND_API.Compatible_API_Call (
346: l_api_version,
347: p_api_version,
348: l_api_name,
389: WHEN OTHERS THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: END;
392:
393: --Standard check of commit
394: IF FND_API.To_Boolean ( p_commit ) THEN
395: COMMIT WORK;
396: END IF;
397: -- Debug Message
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,
406: p_count => x_msg_count,
407: p_data => x_msg_data
409: EXCEPTION
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
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,
438: p_count => x_msg_count,
439: p_data => x_msg_data
524: AND JTT.TASK_STATUS_ID = JTS.TASK_STATUS_ID
525: AND JTT.TASK_PRIORITY_ID = JTP.TASK_PRIORITY_ID;
526:
527: BEGIN
528: -- Standard begin of API savepoint
529: SAVEPOINT Get_TaskTemplate_PVT;
530: -- Standard call to check for call compatibility.
531: IF NOT FND_API.Compatible_API_Call (
532: l_api_version,
526:
527: BEGIN
528: -- Standard begin of API savepoint
529: SAVEPOINT Get_TaskTemplate_PVT;
530: -- Standard call to check for call compatibility.
531: IF NOT FND_API.Compatible_API_Call (
532: l_api_version,
533: p_api_version,
534: l_api_name,
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,
571: p_count => x_msg_count,
572: p_data => x_msg_data
574: EXCEPTION
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
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,
603: p_count => x_msg_count,
604: p_data => x_msg_data
642: l_return_status VARCHAR2(1);
643: --
644: l_task_template ozf_task_template_rec_type := p_task_template;
645: BEGIN
646: -- Standard begin of API savepoint
647: SAVEPOINT Validate_TaskTemplate_PVT;
648: -- Standard call to check for call compatibility.
649: IF NOT FND_API.Compatible_API_Call (
650: l_api_version,
644: l_task_template ozf_task_template_rec_type := p_task_template;
645: BEGIN
646: -- Standard begin of API savepoint
647: SAVEPOINT Validate_TaskTemplate_PVT;
648: -- Standard call to check for call compatibility.
649: IF NOT FND_API.Compatible_API_Call (
650: l_api_version,
651: p_api_version,
652: l_api_name,
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,
712: p_count => x_msg_count,
713: p_data => x_msg_data
715: EXCEPTION
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
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,
744: p_count => x_msg_count,
745: p_data => x_msg_data