DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on FND_MSG_PUB

Line 198: FND_MSG_PUB.initialize;

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

Line 325: FND_MSG_PUB.Count_And_Get

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

Line 339: FND_MSG_PUB.Count_And_Get (

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

Line 349: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 363: FND_MSG_PUB.Count_And_Get (

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

Line 514: FND_MSG_PUB.initialize;

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

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

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

Line 754: FND_MSG_PUB.Count_And_Get (

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

Line 763: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 777: FND_MSG_PUB.Count_And_Get (

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

Line 853: FND_MSG_PUB.initialize;

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

Line 892: FND_MSG_PUB.Count_And_Get

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

Line 906: FND_MSG_PUB.Count_And_Get (

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

Line 916: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 930: FND_MSG_PUB.Count_And_Get (

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

Line 1000: FND_MSG_PUB.initialize;

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

Line 1025: FND_MSG_PUB.count_and_get(

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

Line 1040: FND_MSG_PUB.Count_And_Get (

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

Line 1050: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 1064: FND_MSG_PUB.Count_And_Get (

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

Line 1553: FND_MSG_PUB.initialize;

1549:
1550: -- Initialize message list if p_init_msg_list is set to TRUE.
1551: IF FND_API.to_Boolean( p_init_msg_list )
1552: THEN
1553: FND_MSG_PUB.initialize;
1554: END IF;
1555:
1556:
1557: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1619: FND_MSG_PUB.Count_And_Get

1615: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1616:
1617:
1618: -- Standard call to get message count and if count is 1, get message info.
1619: FND_MSG_PUB.Count_And_Get
1620: (p_count => x_msg_count,
1621: p_data => x_msg_data
1622: );
1623: EXCEPTION

Line 1633: FND_MSG_PUB.Count_And_Get (

1629: WHEN FND_API.G_EXC_ERROR THEN
1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );

Line 1643: FND_MSG_PUB.Count_And_Get (

1639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1640: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1642: -- Standard call to get message count and if count=1, get the message
1643: FND_MSG_PUB.Count_And_Get (
1644: p_encoded => FND_API.G_FALSE,
1645: p_count => x_msg_count,
1646: p_data => x_msg_data
1647: );

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

1648:
1649: WHEN OTHERS THEN
1650: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1655: END IF;
1656: -- Standard call to get message count and if count=1, get the message

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

1650: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1655: END IF;
1656: -- Standard call to get message count and if count=1, get the message
1657: FND_MSG_PUB.Count_And_Get (
1658: p_encoded => FND_API.G_FALSE,

Line 1657: FND_MSG_PUB.Count_And_Get (

1653: THEN
1654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1655: END IF;
1656: -- Standard call to get message count and if count=1, get the message
1657: FND_MSG_PUB.Count_And_Get (
1658: p_encoded => FND_API.G_FALSE,
1659: p_count => x_msg_count,
1660: p_data => x_msg_data
1661: );

Line 1678: FND_MSG_PUB.initialize;

1674: BEGIN
1675: -- Initialize message list if p_init_msg_list is set to TRUE.
1676: IF FND_API.to_Boolean( p_init_msg_list )
1677: THEN
1678: FND_MSG_PUB.initialize;
1679: END IF;
1680:
1681:
1682:

Line 1694: FND_MSG_PUB.Count_And_Get

1690:
1691: -- Debug Message
1692: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1693: -- Standard call to get message count and if count is 1, get message info.
1694: FND_MSG_PUB.Count_And_Get
1695: (p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );
1698: END Validate_offer_adj_Rec;