APPS.OZF_TASK_TEMPLATE_PVT dependencies on FND_MSG_PUB

Line 62: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 65: FND_MSG_PUB.Add;

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;

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

Line 109: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 112: FND_MSG_PUB.Add;

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,

Line 115: FND_MSG_PUB.Count_And_Get (

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

Line 125: FND_MSG_PUB.Count_And_Get (

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

Line 134: FND_MSG_PUB.Count_And_Get (

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

Line 142: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 144: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 147: FND_MSG_PUB.Count_And_Get (

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

Line 208: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 211: FND_MSG_PUB.Add;

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;

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

Line 256: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 259: FND_MSG_PUB.Add;

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,

Line 262: FND_MSG_PUB.Count_And_Get (

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

Line 272: FND_MSG_PUB.Count_And_Get (

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

Line 281: FND_MSG_PUB.Count_And_Get (

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

Line 289: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 294: FND_MSG_PUB.Count_And_Get (

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

Line 354: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 357: FND_MSG_PUB.Add;

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;

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

Line 367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;

Line 369: FND_MSG_PUB.Add;

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

Line 398: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 401: FND_MSG_PUB.Add;

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,

Line 404: FND_MSG_PUB.Count_And_Get (

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

Line 414: FND_MSG_PUB.Count_And_Get (

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

Line 423: FND_MSG_PUB.Count_And_Get (

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

Line 431: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 436: FND_MSG_PUB.Count_And_Get (

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

Line 540: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 543: FND_MSG_PUB.Add;

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;

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

Line 563: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 566: FND_MSG_PUB.Add;

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,

Line 569: FND_MSG_PUB.Count_And_Get (

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

Line 579: FND_MSG_PUB.Count_And_Get (

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

Line 588: FND_MSG_PUB.Count_And_Get (

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

Line 596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 601: FND_MSG_PUB.Count_And_Get (

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

Line 658: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 661: FND_MSG_PUB.Add;

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;

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

Line 704: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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;

Line 707: FND_MSG_PUB.Add;

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,

Line 710: FND_MSG_PUB.Count_And_Get (

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

Line 720: FND_MSG_PUB.Count_And_Get (

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

Line 729: FND_MSG_PUB.Count_And_Get (

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

Line 737: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

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,

Line 742: FND_MSG_PUB.Count_And_Get (

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

Line 881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;

Line 883: FND_MSG_PUB.add;

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;