[Home] [Help]
63: CURSOR reason_type_id_seq IS
64: SELECT ozf_reasons_s.nextval FROM DUAL;
65:
66: BEGIN
67: -- Standard begin of API savepoint
68: SAVEPOINT Create_task_group_PVT;
69: -- Standard call to check for call compatibility.
70: IF NOT FND_API.Compatible_API_Call (
71: l_api_version,
65:
66: BEGIN
67: -- Standard begin of API savepoint
68: SAVEPOINT Create_task_group_PVT;
69: -- Standard call to check for call compatibility.
70: IF NOT FND_API.Compatible_API_Call (
71: l_api_version,
72: p_api_version,
73: l_api_name,
178:
179: -- assign reason code id to out param
180: x_task_template_group_id := l_task_template_group_id;
181:
182: --Standard check of commit
183: IF FND_API.To_Boolean ( p_commit ) THEN
184: COMMIT WORK;
185: END IF;
186: -- Debug Message
188: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
189: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
190: FND_MSG_PUB.Add;
191: END IF;
192: --Standard call to get message count and if count=1, get the message
193: FND_MSG_PUB.Count_And_Get (
194: p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data
198: EXCEPTION
199: WHEN FND_API.G_EXC_ERROR THEN
200: ROLLBACK TO Create_task_group_PVT;
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: -- Standard call to get message count and if count=1, get the message
203: FND_MSG_PUB.Count_And_Get (
204: p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data
207: );
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ROLLBACK TO Create_task_group_PVT;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: -- Standard call to get message count and if count=1, get the message
212: FND_MSG_PUB.Count_And_Get (
213: p_encoded => FND_API.G_FALSE,
214: p_count => x_msg_count,
215: p_data => x_msg_data
220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
221: THEN
222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
223: END IF;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
280: where task_template_group_id = cv_temp_group_id;
281:
282: BEGIN
283:
284: -- Standard begin of API savepoint
285: SAVEPOINT Update_task_group_PVT;
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call (
288: l_api_version,
282: BEGIN
283:
284: -- Standard begin of API savepoint
285: SAVEPOINT Update_task_group_PVT;
286: -- Standard call to check for call compatibility.
287: IF NOT FND_API.Compatible_API_Call (
288: l_api_version,
289: p_api_version,
290: l_api_name,
395: WHERE TASK_TEMPLATE_GROUP_ID = l_task_group.task_template_group_id;
396: END IF;
397: */
398:
399: --Standard check of commit
400: IF FND_API.To_Boolean ( p_commit ) THEN
401: COMMIT WORK;
402: END IF;
403: -- Debug Message
405: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
406: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
407: FND_MSG_PUB.Add;
408: END IF;
409: --Standard call to get message count and if count=1, get the message
410: FND_MSG_PUB.Count_And_Get (
411: p_encoded => FND_API.G_FALSE,
412: p_count => x_msg_count,
413: p_data => x_msg_data
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO Update_task_group_PVT;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: -- Standard call to get message count and if count=1, get the message
420: FND_MSG_PUB.Count_And_Get (
421: p_encoded => FND_API.G_FALSE,
422: p_count => x_msg_count,
423: p_data => x_msg_data
424: );
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO Update_task_group_PVT;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
437: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
440: END IF;
441: -- Standard call to get message count and if count=1, get the message
442: FND_MSG_PUB.Count_And_Get (
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data
494: where task_template_group_id = p_id;
495:
496: --
497: BEGIN
498: -- Standard begin of API savepoint
499: SAVEPOINT Delete_task_group_PVT;
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (
502: l_api_version,
496: --
497: BEGIN
498: -- Standard begin of API savepoint
499: SAVEPOINT Delete_task_group_PVT;
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call (
502: l_api_version,
503: p_api_version,
504: l_api_name,
556: -- CHECK Check to see if this should be deleted or made inactive
557: DELETE FROM ozf_reasons
558: WHERE task_template_group_id = p_task_template_group_id;
559:
560: --Standard check of commit
561: IF FND_API.To_Boolean ( p_commit ) THEN
562: COMMIT WORK;
563: END IF;
564: -- Debug Message
566: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
567: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
568: FND_MSG_PUB.Add;
569: END IF;
570: --Standard call to get message count and if count=1, get the message
571: FND_MSG_PUB.Count_And_Get (
572: p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data
576: EXCEPTION
577: WHEN FND_API.G_EXC_ERROR THEN
578: ROLLBACK TO Delete_task_group_PVT;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data
585: );
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: ROLLBACK TO Delete_task_group_PVT;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data
598: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
601: END IF;
602: -- Standard call to get message count and if count=1, get the message
603: FND_MSG_PUB.Count_And_Get (
604: p_encoded => FND_API.G_FALSE,
605: p_count => x_msg_count,
606: p_data => x_msg_data
666: from ozf_reasons
667: where task_template_group_id = cv_temp_group_id;
668:
669: BEGIN
670: -- Standard begin of API savepoint
671: SAVEPOINT Get_task_group_PVT;
672: -- Standard call to check for call compatibility.
673: IF NOT FND_API.Compatible_API_Call (
674: l_api_version,
668:
669: BEGIN
670: -- Standard begin of API savepoint
671: SAVEPOINT Get_task_group_PVT;
672: -- Standard call to check for call compatibility.
673: IF NOT FND_API.Compatible_API_Call (
674: l_api_version,
675: p_api_version,
676: l_api_name,
777: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
778: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
779: FND_MSG_PUB.Add;
780: END IF;
781: --Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
787: EXCEPTION
788: WHEN FND_API.G_EXC_ERROR THEN
789: ROLLBACK TO Get_task_group_PVT;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: -- Standard call to get message count and if count=1, get the message
792: FND_MSG_PUB.Count_And_Get (
793: p_encoded => FND_API.G_FALSE,
794: p_count => x_msg_count,
795: p_data => x_msg_data
796: );
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: ROLLBACK TO Get_task_group_PVT;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: -- Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
809: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
812: END IF;
813: -- Standard call to get message count and if count=1, get the message
814: FND_MSG_PUB.Count_And_Get (
815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data
855: l_return_status VARCHAR2(1);
856: --
857: l_task_group task_group_rec_type := p_task_group;
858: BEGIN
859: -- Standard begin of API savepoint
860: SAVEPOINT Validate_task_group_PVT;
861: -- Standard call to check for call compatibility.
862: IF NOT FND_API.Compatible_API_Call (
863: l_api_version,
857: l_task_group task_group_rec_type := p_task_group;
858: BEGIN
859: -- Standard begin of API savepoint
860: SAVEPOINT Validate_task_group_PVT;
861: -- Standard call to check for call compatibility.
862: IF NOT FND_API.Compatible_API_Call (
863: l_api_version,
864: p_api_version,
865: l_api_name,
918: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
919: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
920: FND_MSG_PUB.Add;
921: END IF;
922: --Standard call to get message count and if count=1, get the message
923: FND_MSG_PUB.Count_And_Get (
924: p_encoded => FND_API.G_FALSE,
925: p_count => x_msg_count,
926: p_data => x_msg_data
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: ROLLBACK TO Validate_task_group_PVT;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,
935: p_count => x_msg_count,
936: p_data => x_msg_data
937: );
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: ROLLBACK TO Validate_task_group_PVT;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941: -- Standard call to get message count and if count=1, get the message
942: FND_MSG_PUB.Count_And_Get (
943: p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,
945: p_data => x_msg_data
950: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
953: END IF;
954: -- Standard call to get message count and if count=1, get the message
955: FND_MSG_PUB.Count_And_Get (
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data