DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on FND_MSG_PUB

Line 197: FND_MSG_PUB.initialize;

193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list )
196: THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:
200:
201:

Line 324: FND_MSG_PUB.Count_And_Get

320: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
321:
322:
323: -- Standard call to get message count and if count is 1, get message info.
324: FND_MSG_PUB.Count_And_Get
325: (p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328: EXCEPTION

Line 338: FND_MSG_PUB.Count_And_Get (

334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: -- Standard call to get message count and if count=1, get the message
338: FND_MSG_PUB.Count_And_Get (
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data
342: );

Line 348: FND_MSG_PUB.Count_And_Get (

344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );

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

353:
354: WHEN OTHERS THEN
355: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: THEN
359: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
360: END IF;
361: -- Standard call to get message count and if count=1, get the message

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

355: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: THEN
359: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
360: END IF;
361: -- Standard call to get message count and if count=1, get the message
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,

Line 362: FND_MSG_PUB.Count_And_Get (

358: THEN
359: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
360: END IF;
361: -- Standard call to get message count and if count=1, get the message
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
366: );

Line 513: FND_MSG_PUB.initialize;

509:
510: -- Initialize message list if p_init_msg_list is set to TRUE.
511: IF FND_API.to_Boolean( p_init_msg_list )
512: THEN
513: FND_MSG_PUB.initialize;
514: END IF;
515:
516:
517:

Line 701: OZF_Offer_Adj_Line_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');

697: END IF;
698: END IF;
699: -- end of code mthumu
700: -- Debug Message
701: OZF_Offer_Adj_Line_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW||'Private API: Calling update table handler');
702: -- Invoke table handler(OZF_Offer_Adjustment_Pkg.Update_Row)
703: OZF_Offer_Adjustment_Pkg.Update_Row(
704: p_offer_adjustment_id => p_offer_adj_rec.offer_adjustment_id,
705: p_effective_date => p_offer_adj_rec.effective_date,

Line 753: FND_MSG_PUB.Count_And_Get (

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

Line 762: FND_MSG_PUB.Count_And_Get (

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

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

767:
768: WHEN OTHERS THEN
769: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
774: END IF;
775: -- Standard call to get message count and if count=1, get the message

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

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

Line 776: FND_MSG_PUB.Count_And_Get (

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

Line 852: FND_MSG_PUB.initialize;

848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.to_Boolean( p_init_msg_list )
851: THEN
852: FND_MSG_PUB.initialize;
853: END IF;
854:
855:
856:

Line 891: FND_MSG_PUB.Count_And_Get

887: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
888:
889:
890: -- Standard call to get message count and if count is 1, get message info.
891: FND_MSG_PUB.Count_And_Get
892: (p_count => x_msg_count,
893: p_data => x_msg_data
894: );
895: EXCEPTION

Line 905: FND_MSG_PUB.Count_And_Get (

901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: -- Standard call to get message count and if count=1, get the message
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data
909: );

Line 915: FND_MSG_PUB.Count_And_Get (

911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
912: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data
919: );

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

920:
921: WHEN OTHERS THEN
922: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN
926: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
927: END IF;
928: -- Standard call to get message count and if count=1, get the message

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

922: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN
926: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
927: END IF;
928: -- Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,

Line 929: FND_MSG_PUB.Count_And_Get (

925: THEN
926: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
927: END IF;
928: -- Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );

Line 999: FND_MSG_PUB.initialize;

995:
996: -- Initialize message list if p_init_msg_list is set to TRUE.
997: IF FND_API.to_Boolean( p_init_msg_list )
998: THEN
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:
1002:
1003:

Line 1024: FND_MSG_PUB.count_and_get(

1020: OZF_Offer_Adjustment_Pkg.Lock_Row(l_offer_adjustment_id,p_object_version);
1021:
1022:
1023: -------------------- finish --------------------------
1024: FND_MSG_PUB.count_and_get(
1025: p_encoded => FND_API.g_false,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data);
1028: OZF_Offer_Adj_Line_PVT.debug_message(l_full_name ||': end');

Line 1039: FND_MSG_PUB.Count_And_Get (

1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );

Line 1049: FND_MSG_PUB.Count_And_Get (

1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );

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

1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;
1062: -- Standard call to get message count and if count=1, get the message

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

1056: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,

Line 1063: FND_MSG_PUB.Count_And_Get (

1059: THEN
1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );

Line 1527: FND_MSG_PUB.initialize;

1523:
1524: -- Initialize message list if p_init_msg_list is set to TRUE.
1525: IF FND_API.to_Boolean( p_init_msg_list )
1526: THEN
1527: FND_MSG_PUB.initialize;
1528: END IF;
1529:
1530:
1531: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1593: FND_MSG_PUB.Count_And_Get

1589: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1590:
1591:
1592: -- Standard call to get message count and if count is 1, get message info.
1593: FND_MSG_PUB.Count_And_Get
1594: (p_count => x_msg_count,
1595: p_data => x_msg_data
1596: );
1597: EXCEPTION

Line 1607: FND_MSG_PUB.Count_And_Get (

1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: -- Standard call to get message count and if count=1, get the message
1607: FND_MSG_PUB.Count_And_Get (
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data
1611: );

Line 1617: FND_MSG_PUB.Count_And_Get (

1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1616: -- Standard call to get message count and if count=1, get the message
1617: FND_MSG_PUB.Count_And_Get (
1618: p_encoded => FND_API.G_FALSE,
1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1621: );

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

1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1629: END IF;
1630: -- Standard call to get message count and if count=1, get the message

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

1624: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1629: END IF;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,

Line 1631: FND_MSG_PUB.Count_And_Get (

1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1629: END IF;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );

Line 1652: FND_MSG_PUB.initialize;

1648: BEGIN
1649: -- Initialize message list if p_init_msg_list is set to TRUE.
1650: IF FND_API.to_Boolean( p_init_msg_list )
1651: THEN
1652: FND_MSG_PUB.initialize;
1653: END IF;
1654:
1655:
1656:

Line 1668: FND_MSG_PUB.Count_And_Get

1664:
1665: -- Debug Message
1666: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1667: -- Standard call to get message count and if count is 1, get message info.
1668: FND_MSG_PUB.Count_And_Get
1669: (p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );
1672: END Validate_offer_adj_Rec;