APPS.OZF_TASK_GROUP_PVT dependencies on FND_MSG_PUB

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

75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Debug Message
79: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
80: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
81: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
82: FND_MSG_PUB.Add;
83: END IF;

Line 82: FND_MSG_PUB.Add;

78: -- Debug Message
79: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
80: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
81: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
82: FND_MSG_PUB.Add;
83: END IF;
84: --Initialize message list if p_init_msg_list is TRUE.
85: IF FND_API.To_Boolean (p_init_msg_list) THEN
86: FND_MSG_PUB.initialize;

Line 86: FND_MSG_PUB.initialize;

82: FND_MSG_PUB.Add;
83: END IF;
84: --Initialize message list if p_init_msg_list is TRUE.
85: IF FND_API.To_Boolean (p_init_msg_list) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: -- Initialize API return status to sucess
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:

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

183: IF FND_API.To_Boolean ( p_commit ) THEN
184: COMMIT WORK;
185: END IF;
186: -- Debug Message
187: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 190: FND_MSG_PUB.Add;

186: -- Debug Message
187: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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,

Line 193: FND_MSG_PUB.Count_And_Get (

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

Line 203: FND_MSG_PUB.Count_And_Get (

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

Line 212: FND_MSG_PUB.Count_And_Get (

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

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

216: );
217: WHEN OTHERS THEN
218: ROLLBACK TO Create_task_group_PVT;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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

218: ROLLBACK TO Create_task_group_PVT;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 225: FND_MSG_PUB.Count_And_Get (

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

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

292: THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295: -- Debug Message
296: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
297: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
298: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
299: FND_MSG_PUB.Add;
300: END IF;

Line 299: FND_MSG_PUB.Add;

295: -- Debug Message
296: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
297: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
298: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
299: FND_MSG_PUB.Add;
300: END IF;
301:
302: --Initialize message list if p_init_msg_list is TRUE.
303: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 304: FND_MSG_PUB.initialize;

300: END IF;
301:
302: --Initialize message list if p_init_msg_list is TRUE.
303: IF FND_API.To_Boolean (p_init_msg_list) THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306: -- Initialize API return status to sucess
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308:

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

376: OPEN c_reason_type(l_task_group.task_template_group_id);
377: FETCH c_reason_type INTO l_reason_type, l_object_version_number;
378: IF c_reason_type%NOTFOUND THEN
379: CLOSE c_reason_type;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
382: FND_MSG_PUB.add;
383: END IF;
384: RAISE FND_API.g_exc_error;

Line 382: FND_MSG_PUB.add;

378: IF c_reason_type%NOTFOUND THEN
379: CLOSE c_reason_type;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
382: FND_MSG_PUB.add;
383: END IF;
384: RAISE FND_API.g_exc_error;
385: END IF;
386: CLOSE c_reason_type;

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

400: IF FND_API.To_Boolean ( p_commit ) THEN
401: COMMIT WORK;
402: END IF;
403: -- Debug Message
404: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 407: FND_MSG_PUB.Add;

403: -- Debug Message
404: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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,

Line 410: FND_MSG_PUB.Count_And_Get (

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

Line 420: FND_MSG_PUB.Count_And_Get (

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

Line 429: FND_MSG_PUB.Count_And_Get (

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

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

433: );
434: WHEN OTHERS THEN
435: ROLLBACK TO Update_task_group_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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

435: ROLLBACK TO Update_task_group_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 442: FND_MSG_PUB.Count_And_Get (

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

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

508: END IF;
509:
510:
511: -- Debug Message
512: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
513: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
514: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
515: FND_MSG_PUB.Add;
516: END IF;

Line 515: FND_MSG_PUB.Add;

511: -- Debug Message
512: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
513: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
514: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
515: FND_MSG_PUB.Add;
516: END IF;
517: --Initialize message list if p_init_msg_list is TRUE.
518: IF FND_API.To_Boolean (p_init_msg_list) THEN
519: FND_MSG_PUB.initialize;

Line 519: FND_MSG_PUB.initialize;

515: FND_MSG_PUB.Add;
516: END IF;
517: --Initialize message list if p_init_msg_list is TRUE.
518: IF FND_API.To_Boolean (p_init_msg_list) THEN
519: FND_MSG_PUB.initialize;
520: END IF;
521: -- Initialize API return status to sucess
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523:

Line 529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

525: FETCH exist_task_group_csr INTO l_task_template_group_id;
526: CLOSE exist_task_group_csr;
527:
528: IF l_task_template_group_id IS NOT NULL THEN
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
530: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TASK_GROUP_USED');
531: FND_MSG_PUB.add;
532: END IF;
533: RAISE FND_API.g_exc_error;

Line 531: FND_MSG_PUB.add;

527:
528: IF l_task_template_group_id IS NOT NULL THEN
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
530: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_TASK_GROUP_USED');
531: FND_MSG_PUB.add;
532: END IF;
533: RAISE FND_API.g_exc_error;
534: END IF;
535:

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

561: IF FND_API.To_Boolean ( p_commit ) THEN
562: COMMIT WORK;
563: END IF;
564: -- Debug Message
565: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 568: FND_MSG_PUB.Add;

564: -- Debug Message
565: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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,

Line 571: FND_MSG_PUB.Count_And_Get (

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

Line 581: FND_MSG_PUB.Count_And_Get (

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

Line 590: FND_MSG_PUB.Count_And_Get (

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

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

594: );
595: WHEN OTHERS THEN
596: ROLLBACK TO Delete_task_group_PVT;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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

596: ROLLBACK TO Delete_task_group_PVT;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 603: FND_MSG_PUB.Count_And_Get (

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

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

678: THEN
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681: -- Debug Message
682: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
683: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
684: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
685: FND_MSG_PUB.Add;
686: END IF;

Line 685: FND_MSG_PUB.Add;

681: -- Debug Message
682: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
683: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
684: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
685: FND_MSG_PUB.Add;
686: END IF;
687: --Initialize message list if p_init_msg_list is TRUE.
688: IF FND_API.To_Boolean (p_init_msg_list) THEN
689: FND_MSG_PUB.initialize;

Line 689: FND_MSG_PUB.initialize;

685: FND_MSG_PUB.Add;
686: END IF;
687: --Initialize message list if p_init_msg_list is TRUE.
688: IF FND_API.To_Boolean (p_init_msg_list) THEN
689: FND_MSG_PUB.initialize;
690: END IF;
691: -- Initialize API return status to sucess
692: x_return_status := FND_API.G_RET_STS_SUCCESS;
693:

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

734: OPEN c_reason_type(l_template_group(i).task_template_group_id);
735: FETCH c_reason_type INTO l_reason_type;
736: IF c_reason_type%NOTFOUND THEN
737: CLOSE c_reason_type;
738: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
740: FND_MSG_PUB.add;
741: END IF;
742: RAISE FND_API.g_exc_error;

Line 740: FND_MSG_PUB.add;

736: IF c_reason_type%NOTFOUND THEN
737: CLOSE c_reason_type;
738: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
740: FND_MSG_PUB.add;
741: END IF;
742: RAISE FND_API.g_exc_error;
743: END IF;
744: CLOSE c_reason_type;

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

772: END LOOP;
773:
774:
775: -- Debug Message
776: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 779: FND_MSG_PUB.Add;

775: -- Debug Message
776: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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,

Line 782: FND_MSG_PUB.Count_And_Get (

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

Line 792: FND_MSG_PUB.Count_And_Get (

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

Line 801: FND_MSG_PUB.Count_And_Get (

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

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

805: );
806: WHEN OTHERS THEN
807: ROLLBACK TO Get_task_group_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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

807: ROLLBACK TO Get_task_group_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 814: FND_MSG_PUB.Count_And_Get (

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

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

867: THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: -- Debug Message
871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
872: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
873: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
874: FND_MSG_PUB.Add;
875: END IF;

Line 874: FND_MSG_PUB.Add;

870: -- Debug Message
871: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
872: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
873: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
874: FND_MSG_PUB.Add;
875: END IF;
876: --Initialize message list if p_init_msg_list is TRUE.
877: IF FND_API.To_Boolean (p_init_msg_list) THEN
878: FND_MSG_PUB.initialize;

Line 878: FND_MSG_PUB.initialize;

874: FND_MSG_PUB.Add;
875: END IF;
876: --Initialize message list if p_init_msg_list is TRUE.
877: IF FND_API.To_Boolean (p_init_msg_list) THEN
878: FND_MSG_PUB.initialize;
879: END IF;
880: -- Initialize API return status to sucess
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882:

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

913: END IF;
914: END IF;
915: */
916: -- Debug Message
917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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;

Line 920: FND_MSG_PUB.Add;

916: -- Debug Message
917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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,

Line 923: FND_MSG_PUB.Count_And_Get (

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

Line 933: FND_MSG_PUB.Count_And_Get (

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

Line 942: FND_MSG_PUB.Count_And_Get (

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

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

946: );
947: WHEN OTHERS THEN
948: ROLLBACK TO Validate_task_group_PVT;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

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

948: ROLLBACK TO Validate_task_group_PVT;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 955: FND_MSG_PUB.Count_And_Get (

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

Line 990: FND_MSG_PUB.ADD;

986: IF( (l_source_object IS NULL)
987: OR (l_source_object = FND_API.G_MISS_CHAR) )
988: THEN
989: FND_MESSAGE.Set_Name('OZF', 'OZF_ACTION_NULL_SOURCEOBJ');
990: FND_MSG_PUB.ADD;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:

Line 1000: FND_MSG_PUB.ADD;

996: IF( (l_task_group_name IS NULL)
997: OR (l_task_group_name = FND_API.G_MISS_CHAR) )
998: THEN
999: FND_MESSAGE.Set_Name('OZF', 'OZF_ACTION_NULL_TASK_GROUPNAME');
1000: FND_MSG_PUB.ADD;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004:

Line 1010: FND_MSG_PUB.ADD;

1006: IF( (l_start_date IS NULL)
1007: OR (l_start_date = FND_API.G_MISS_DATE) )
1008: THEN
1009: FND_MESSAGE.Set_Name('OZF', 'OZF_ACTION_NULL_STDATE');
1010: FND_MSG_PUB.ADD;
1011: x_return_status := FND_API.G_RET_STS_ERROR;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:

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

1241: OPEN c_task_group(p_task_group_rec.task_template_group_id);
1242: FETCH c_task_group INTO l_task_group_rec;
1243: IF c_task_group%NOTFOUND THEN
1244: CLOSE c_task_group;
1245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1246: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
1247: FND_MSG_PUB.add;
1248: END IF;
1249: RAISE FND_API.g_exc_error;

Line 1247: FND_MSG_PUB.add;

1243: IF c_task_group%NOTFOUND THEN
1244: CLOSE c_task_group;
1245: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1246: FND_MESSAGE.set_name('OZF','OZF_API_RECORD_NOT_FOUND');
1247: FND_MSG_PUB.add;
1248: END IF;
1249: RAISE FND_API.g_exc_error;
1250: END IF;
1251: CLOSE c_task_group;