DBA Data[Home] [Help]

APPS.OZF_OFFER_MARKET_OPTIONS_PVT dependencies on FND_MSG_PUB

Line 476: FND_MSG_PUB.initialize;

472: END IF;
473: -- Initialize message list if p_init_msg_list is set to TRUE.
474: IF FND_API.to_Boolean( p_init_msg_list )
475: THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: -- Debug Message
480: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 529: FND_MSG_PUB.Count_And_Get

525: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
526:
527:
528: -- Standard call to get message count and if count is 1, get message info.
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533: EXCEPTION

Line 543: FND_MSG_PUB.Count_And_Get (

539: WHEN FND_API.G_EXC_ERROR THEN
540: ROLLBACK TO validate_market_options_pvt;
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: -- Standard call to get message count and if count=1, get the message
543: FND_MSG_PUB.Count_And_Get (
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count,
546: p_data => x_msg_data
547: );

Line 553: FND_MSG_PUB.Count_And_Get (

549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: ROLLBACK TO validate_market_options_pvt;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: -- Standard call to get message count and if count=1, get the message
553: FND_MSG_PUB.Count_And_Get (
554: p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );

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

558:
559: WHEN OTHERS THEN
560: ROLLBACK TO validate_market_options_pvt;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message

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

560: ROLLBACK TO validate_market_options_pvt;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,

Line 567: FND_MSG_PUB.Count_And_Get (

563: THEN
564: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
565: END IF;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 651: FND_MSG_PUB.initialize;

647:
648: -- Initialize message list if p_init_msg_list is set to TRUE.
649: IF FND_API.to_Boolean( p_init_msg_list )
650: THEN
651: FND_MSG_PUB.initialize;
652: END IF;
653:
654: -- Debug Message
655: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 745: FND_MSG_PUB.Count_And_Get

741: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
742: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
743: -- Standard call to get message count and if count is 1, get message info.
744:
745: FND_MSG_PUB.Count_And_Get
746: (p_count => x_msg_count,
747: p_data => x_msg_data
748: );
749:

Line 756: FND_MSG_PUB.Count_And_Get (

752: WHEN FND_API.G_EXC_ERROR THEN
753: ROLLBACK TO Create_market_options_pvt;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: -- Standard call to get message count and if count=1, get the message
756: FND_MSG_PUB.Count_And_Get (
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data
760: );

Line 766: FND_MSG_PUB.Count_And_Get (

762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO Create_market_options_pvt;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: -- Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );

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

771:
772: WHEN OTHERS THEN
773: ROLLBACK TO Create_market_options_pvt;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
776: THEN
777: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
778: END IF;
779: -- Standard call to get message count and if count=1, get the message

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

773: ROLLBACK TO Create_market_options_pvt;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
776: THEN
777: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
778: END IF;
779: -- Standard call to get message count and if count=1, get the message
780: FND_MSG_PUB.Count_And_Get (
781: p_encoded => FND_API.G_FALSE,

Line 780: FND_MSG_PUB.Count_And_Get (

776: THEN
777: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
778: END IF;
779: -- Standard call to get message count and if count=1, get the message
780: FND_MSG_PUB.Count_And_Get (
781: p_encoded => FND_API.G_FALSE,
782: p_count => x_msg_count,
783: p_data => x_msg_data
784: );

Line 863: FND_MSG_PUB.initialize;

859: END IF;
860: -- Initialize message list if p_init_msg_list is set to TRUE.
861: IF FND_API.to_Boolean( p_init_msg_list )
862: THEN
863: FND_MSG_PUB.initialize;
864: END IF;
865: -- Debug Message
866: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'start');
867:

Line 942: FND_MSG_PUB.Count_And_Get

938: END IF;
939: -- Debug Message
940: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
941: -- Standard call to get message count and if count is 1, get message info.
942: FND_MSG_PUB.Count_And_Get
943: (p_count => x_msg_count,
944: p_data => x_msg_data
945: );
946:

Line 958: FND_MSG_PUB.Count_And_Get (

954: WHEN FND_API.G_EXC_ERROR THEN
955: ROLLBACK TO Update_market_options_pvt;
956: x_return_status := FND_API.G_RET_STS_ERROR;
957: -- Standard call to get message count and if count=1, get the message
958: FND_MSG_PUB.Count_And_Get (
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data
962: );

Line 968: FND_MSG_PUB.Count_And_Get (

964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
965: ROLLBACK TO Update_market_options_pvt;
966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: -- Standard call to get message count and if count=1, get the message
968: FND_MSG_PUB.Count_And_Get (
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_msg_count,
971: p_data => x_msg_data
972: );

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

973:
974: WHEN OTHERS THEN
975: ROLLBACK TO Update_market_options_pvt;
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
980: END IF;
981: -- Standard call to get message count and if count=1, get the message

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

975: ROLLBACK TO Update_market_options_pvt;
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
978: THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
980: END IF;
981: -- Standard call to get message count and if count=1, get the message
982: FND_MSG_PUB.Count_And_Get (
983: p_encoded => FND_API.G_FALSE,

Line 982: FND_MSG_PUB.Count_And_Get (

978: THEN
979: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
980: END IF;
981: -- Standard call to get message count and if count=1, get the message
982: FND_MSG_PUB.Count_And_Get (
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,
985: p_data => x_msg_data
986: );

Line 1054: FND_MSG_PUB.initialize;

1050:
1051: -- Initialize message list if p_init_msg_list is set to TRUE.
1052: IF FND_API.to_Boolean( p_init_msg_list )
1053: THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: -- Initialize API return status to SUCCESS
1058: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1081: FND_MSG_PUB.Count_And_Get

1077: COMMIT WORK;
1078: END IF;
1079:
1080: -- Standard call to get message count and if count is 1, get message info.
1081: FND_MSG_PUB.Count_And_Get
1082: (p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1085: EXCEPTION

Line 1095: FND_MSG_PUB.Count_And_Get (

1091: WHEN FND_API.G_EXC_ERROR THEN
1092: ROLLBACK TO Delete_market_options_PVT;
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: -- Standard call to get message count and if count=1, get the message
1095: FND_MSG_PUB.Count_And_Get (
1096: p_encoded => FND_API.G_FALSE,
1097: p_count => x_msg_count,
1098: p_data => x_msg_data
1099: );

Line 1105: FND_MSG_PUB.Count_And_Get (

1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1102: ROLLBACK TO Delete_market_options_PVT;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: -- Standard call to get message count and if count=1, get the message
1105: FND_MSG_PUB.Count_And_Get (
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data
1109: );

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

1110:
1111: WHEN OTHERS THEN
1112: ROLLBACK TO Delete_market_options_PVT;
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1115: THEN
1116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1117: END IF;
1118: -- Standard call to get message count and if count=1, get the message

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

1112: ROLLBACK TO Delete_market_options_PVT;
1113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1114: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1115: THEN
1116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1117: END IF;
1118: -- Standard call to get message count and if count=1, get the message
1119: FND_MSG_PUB.Count_And_Get (
1120: p_encoded => FND_API.G_FALSE,

Line 1119: FND_MSG_PUB.Count_And_Get (

1115: THEN
1116: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1117: END IF;
1118: -- Standard call to get message count and if count=1, get the message
1119: FND_MSG_PUB.Count_And_Get (
1120: p_encoded => FND_API.G_FALSE,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data
1123: );