DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_QUAL_PVT dependencies on FND_MSG_PUB

Line 7: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Volume_Offer_Qual_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvvoqb.pls';
6:
7: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11:

Line 8: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Volume_Offer_Qual_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvvoqb.pls';
6:
7: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11:
12: PROCEDURE debug_message(p_message IN VARCHAR2)

Line 9: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvvoqb.pls';
6:
7: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
8: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
9: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
10:
11:
12: PROCEDURE debug_message(p_message IN VARCHAR2)
13: IS

Line 161: FND_MSG_PUB.initialize;

157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list )
160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:
164: -- Debug Message
165: debug_message('Private API: ' || l_api_name || 'start');

Line 296: Fnd_Msg_Pub.Count_AND_Get

292:
293: END LOOP;
294:
295: -- commit
296: Fnd_Msg_Pub.Count_AND_Get
297: ( p_count => x_msg_count,
298: p_data => x_msg_data,
299: p_encoded => Fnd_Api.G_FALSE
300: );

Line 310: Fnd_Msg_Pub.Count_AND_Get

306: EXCEPTION
307: WHEN Fnd_Api.G_EXC_ERROR THEN
308: x_return_status := Fnd_Api.g_ret_sts_error ;
309: ROLLBACK TO create_volume_offer_qual_pvt;
310: Fnd_Msg_Pub.Count_AND_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data,
313: p_encoded => Fnd_Api.G_FALSE
314: );

Line 318: Fnd_Msg_Pub.Count_AND_Get

314: );
315: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
316: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
317: ROLLBACK TO create_volume_offer_qual_pvt;
318: Fnd_Msg_Pub.Count_AND_Get
319: ( p_count => x_msg_count,
320: p_data => x_msg_data,
321: p_encoded => Fnd_Api.G_FALSE
322: );

Line 326: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

322: );
323: WHEN OTHERS THEN
324: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
325: ROLLBACK TO create_volume_offer_qual_pvt;
326: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
327: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
328: END IF;
329: Fnd_Msg_Pub.Count_AND_Get
330: ( p_count => x_msg_count,

Line 327: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

323: WHEN OTHERS THEN
324: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
325: ROLLBACK TO create_volume_offer_qual_pvt;
326: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
327: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
328: END IF;
329: Fnd_Msg_Pub.Count_AND_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data,

Line 329: Fnd_Msg_Pub.Count_AND_Get

325: ROLLBACK TO create_volume_offer_qual_pvt;
326: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
327: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
328: END IF;
329: Fnd_Msg_Pub.Count_AND_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => Fnd_Api.G_FALSE
333: );

Line 432: FND_MSG_PUB.initialize;

428: END IF;
429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN
432: FND_MSG_PUB.initialize;
433: END IF;
434: -- Debug Message
435: debug_message('Private API: ' || l_api_name || 'start');
436:

Line 623: Fnd_Msg_Pub.Count_AND_Get

619:
620: END LOOP;
621:
622: -- commit;
623: Fnd_Msg_Pub.Count_AND_Get
624: ( p_count => x_msg_count,
625: p_data => x_msg_data,
626: p_encoded => Fnd_Api.G_FALSE
627: );

Line 637: Fnd_Msg_Pub.Count_AND_Get

633: EXCEPTION
634: WHEN Fnd_Api.G_EXC_ERROR THEN
635: x_return_status := Fnd_Api.g_ret_sts_error ;
636: ROLLBACK TO update_volume_offer_qual_pvt;
637: Fnd_Msg_Pub.Count_AND_Get
638: ( p_count => x_msg_count,
639: p_data => x_msg_data,
640: p_encoded => Fnd_Api.G_FALSE
641: );

Line 645: Fnd_Msg_Pub.Count_AND_Get

641: );
642: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
643: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
644: ROLLBACK TO update_volume_offer_qual_pvt;
645: Fnd_Msg_Pub.Count_AND_Get
646: ( p_count => x_msg_count,
647: p_data => x_msg_data,
648: p_encoded => Fnd_Api.G_FALSE
649: );

Line 653: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

649: );
650: WHEN OTHERS THEN
651: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
652: ROLLBACK TO update_volume_offer_qual_pvt;
653: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
654: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;
656: Fnd_Msg_Pub.Count_AND_Get
657: ( p_count => x_msg_count,

Line 654: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

650: WHEN OTHERS THEN
651: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
652: ROLLBACK TO update_volume_offer_qual_pvt;
653: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
654: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;
656: Fnd_Msg_Pub.Count_AND_Get
657: ( p_count => x_msg_count,
658: p_data => x_msg_data,

Line 656: Fnd_Msg_Pub.Count_AND_Get

652: ROLLBACK TO update_volume_offer_qual_pvt;
653: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
654: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;
656: Fnd_Msg_Pub.Count_AND_Get
657: ( p_count => x_msg_count,
658: p_data => x_msg_data,
659: p_encoded => Fnd_Api.G_FALSE
660: );

Line 724: FND_MSG_PUB.initialize;

720: END IF;
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: IF FND_API.to_Boolean( p_init_msg_list )
723: THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726: -- Debug Message
727: debug_message('Private API: ' || l_api_name || 'start');
728:

Line 833: Fnd_Msg_Pub.Count_AND_Get

829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:
832: END IF;
833: Fnd_Msg_Pub.Count_AND_Get
834: ( p_count => x_msg_count,
835: p_data => x_msg_data,
836: p_encoded => Fnd_Api.G_FALSE
837: );

Line 847: Fnd_Msg_Pub.Count_AND_Get

843: EXCEPTION
844: WHEN Fnd_Api.G_EXC_ERROR THEN
845: x_return_status := Fnd_Api.g_ret_sts_error ;
846: ROLLBACK TO Delete_volume_offer_qual_pvt;
847: Fnd_Msg_Pub.Count_AND_Get
848: ( p_count => x_msg_count,
849: p_data => x_msg_data,
850: p_encoded => Fnd_Api.G_FALSE
851: );

Line 855: Fnd_Msg_Pub.Count_AND_Get

851: );
852: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
854: ROLLBACK TO Delete_volume_offer_qual_pvt;
855: Fnd_Msg_Pub.Count_AND_Get
856: ( p_count => x_msg_count,
857: p_data => x_msg_data,
858: p_encoded => Fnd_Api.G_FALSE
859: );

Line 863: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

859: );
860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
862: ROLLBACK TO Delete_volume_offer_qual_pvt;
863: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
864: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
865: END IF;
866: Fnd_Msg_Pub.Count_AND_Get
867: ( p_count => x_msg_count,

Line 864: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
862: ROLLBACK TO Delete_volume_offer_qual_pvt;
863: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
864: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
865: END IF;
866: Fnd_Msg_Pub.Count_AND_Get
867: ( p_count => x_msg_count,
868: p_data => x_msg_data,

Line 866: Fnd_Msg_Pub.Count_AND_Get

862: ROLLBACK TO Delete_volume_offer_qual_pvt;
863: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
864: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
865: END IF;
866: Fnd_Msg_Pub.Count_AND_Get
867: ( p_count => x_msg_count,
868: p_data => x_msg_data,
869: p_encoded => Fnd_Api.G_FALSE
870: );