DBA Data[Home] [Help]

APPS.PV_PARTNER_UTIL_PVT dependencies on FND_MSG_PUB

Line 4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

1: PACKAGE BODY PV_PARTNER_UTIL_PVT AS
2: /* $Header: pvxvputb.pls 120.13 2006/02/26 21:01:48 rdsharma noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:

Line 5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1: PACKAGE BODY PV_PARTNER_UTIL_PVT AS
2: /* $Header: pvxvputb.pls 120.13 2006/02/26 21:01:48 rdsharma noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:
9: PROCEDURE map_location_rec( p_location_rec IN PV_PARTNER_UTIL_PVT.location_rec_type,

Line 6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

2: /* $Header: pvxvputb.pls 120.13 2006/02/26 21:01:48 rdsharma noship $ */
3:
4: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
5: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
6: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
7:
8:
9: PROCEDURE map_location_rec( p_location_rec IN PV_PARTNER_UTIL_PVT.location_rec_type,
10: x_location_rec OUT NOCOPY HZ_LOCATION_V2PUB.location_rec_type)

Line 318: FND_MSG_PUB.Count_And_Get

314: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
315: END IF;
316:
317: -- Standard call to get message count and if count is 1, get message info.
318: FND_MSG_PUB.Count_And_Get
319: (p_count => x_msg_count,
320: p_data => x_msg_data
321: );
322:

Line 437: FND_MSG_PUB.initialize;

433:
434: -- Initialize message list if p_init_msg_list is set to TRUE.
435: IF FND_API.to_Boolean( p_init_msg_list )
436: THEN
437: FND_MSG_PUB.initialize;
438: END IF;
439:
440: -- Debug Message
441: IF (PV_DEBUG_HIGH_ON) THEN

Line 691: FND_MSG_PUB.Count_And_Get

687: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
688: END IF;
689:
690: -- Standard call to get message count and if count is 1, get message info.
691: FND_MSG_PUB.Count_And_Get
692: (p_count => x_msg_count,
693: p_data => x_msg_data
694: );
695: */

Line 706: FND_MSG_PUB.Count_And_Get (

702: WHEN FND_API.G_EXC_ERROR THEN
703: ROLLBACK TO create_partner_pvt;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,
709: p_data => x_msg_data
710: );

Line 713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

709: p_data => x_msg_data
710: );
711:
712: -- Debug Message
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
714: hz_utility_v2pub.debug_return_messages (
715: x_msg_count, x_msg_data, 'ERROR');
716: hz_utility_v2pub.debug('Create_Partner (-)');
717: END IF;

Line 723: FND_MSG_PUB.Count_And_Get (

719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_partner_pvt;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: -- Standard call to get message count and if count=1, get the message
723: FND_MSG_PUB.Count_And_Get (
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data
727: );

Line 730: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

726: p_data => x_msg_data
727: );
728:
729: -- Debug Message
730: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
731: hz_utility_v2pub.debug_return_messages (
732: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
733: hz_utility_v2pub.debug('Create_Partner (-)');
734: END IF;

Line 739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

735:
736: WHEN OTHERS THEN
737: ROLLBACK TO create_partner_pvt;
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742:
743: -- Standard call to get message count and if count=1, get the message

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

736: WHEN OTHERS THEN
737: ROLLBACK TO create_partner_pvt;
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742:
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (

Line 744: FND_MSG_PUB.Count_And_Get (

740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742:
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data );
748:

Line 750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

746: p_count => x_msg_count,
747: p_data => x_msg_data );
748:
749: -- Debug Message
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
751: hz_utility_v2pub.debug_return_messages (
752: x_msg_count, x_msg_data, 'SQL ERROR');
753: hz_utility_v2pub.debug('Create_Partner (-)');
754: END IF;

Line 933: FND_MSG_PUB.count_and_get (

929:
930: EXCEPTION
931: WHEN FND_API.g_exc_error THEN
932: x_return_status := FND_API.g_ret_sts_error;
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 941: FND_MSG_PUB.count_and_get (

937: );
938:
939: WHEN FND_API.g_exc_unexpected_error THEN
940: x_return_status := FND_API.g_ret_sts_unexp_error ;
941: FND_MSG_PUB.count_and_get (
942: p_encoded => FND_API.g_false
943: ,p_count => x_msg_count
944: ,p_data => x_msg_data
945: );

Line 950: FND_MSG_PUB.count_and_get(

946:
947: WHEN OTHERS THEN
948: x_return_status := FND_API.g_ret_sts_unexp_error ;
949:
950: FND_MSG_PUB.count_and_get(
951: p_encoded => FND_API.g_false
952: ,p_count => x_msg_count
953: ,p_data => x_msg_data
954: );

Line 1140: FND_MSG_PUB.initialize;

1136:
1137: -- Initialize message list if p_init_msg_list is set to TRUE.
1138: IF FND_API.to_Boolean( p_init_msg_list )
1139: THEN
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:
1143: -- Debug Message
1144: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1193: fnd_msg_pub.Add;

1189:
1190: IF l_vendor_org_id IS NULL OR l_vendor_org_id = FND_API.g_miss_num THEN
1191: l_return_status := FND_API.G_RET_STS_ERROR ;
1192: fnd_message.Set_Name('PV', 'PV_NO_DEF_VENDOR_ORG');
1193: fnd_msg_pub.Add;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197:

Line 1577: FND_MSG_PUB.Count_And_Get

1573: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1574: END IF;
1575:
1576: -- Standard call to get message count and if count is 1, get message info.
1577: FND_MSG_PUB.Count_And_Get
1578: (p_count => x_msg_count,
1579: p_data => x_msg_data
1580: );
1581:

Line 1595: FND_MSG_PUB.Count_And_Get (

1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO create_relationship_pvt;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: -- Standard call to get message count and if count=1, get the message
1595: FND_MSG_PUB.Count_And_Get (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1599: );

Line 1605: FND_MSG_PUB.Count_And_Get (

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

Line 1614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1610:
1611: WHEN OTHERS THEN
1612: ROLLBACK TO create_relationship_pvt;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1616: END IF;
1617:
1618: -- Standard call to get message count and if count=1, get the message

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

1611: WHEN OTHERS THEN
1612: ROLLBACK TO create_relationship_pvt;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1614: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1616: END IF;
1617:
1618: -- Standard call to get message count and if count=1, get the message
1619: FND_MSG_PUB.Count_And_Get (

Line 1619: FND_MSG_PUB.Count_And_Get (

1615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1616: END IF;
1617:
1618: -- Standard call to get message count and if count=1, get the message
1619: FND_MSG_PUB.Count_And_Get (
1620: p_encoded => FND_API.G_FALSE,
1621: p_count => x_msg_count,
1622: p_data => x_msg_data );
1623:

Line 1784: FND_MSG_PUB.Count_And_Get (

1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781: ROLLBACK TO create_relationship_pvt;
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783: -- Standard call to get message count and if count=1, get the message
1784: FND_MSG_PUB.Count_And_Get (
1785: p_encoded => FND_API.G_FALSE,
1786: p_count => x_msg_count,
1787: p_data => x_msg_data
1788: );

Line 1793: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1789:
1790: WHEN OTHERS THEN
1791: ROLLBACK TO create_relationship_pvt;
1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1794: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1795: END IF;
1796:
1797: -- Standard call to get message count and if count=1, get the message

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

1790: WHEN OTHERS THEN
1791: ROLLBACK TO create_relationship_pvt;
1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1794: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1795: END IF;
1796:
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (

Line 1798: FND_MSG_PUB.Count_And_Get (

1794: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1795: END IF;
1796:
1797: -- Standard call to get message count and if count=1, get the message
1798: FND_MSG_PUB.Count_And_Get (
1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data );
1802:

Line 1947: FND_MSG_PUB.initialize;

1943:
1944: -- Initialize message list if p_init_msg_list is set to TRUE.
1945: IF FND_API.to_Boolean( p_init_msg_list )
1946: THEN
1947: FND_MSG_PUB.initialize;
1948: END IF;
1949:
1950: -- Debug Message
1951: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 2069: FND_MSG_PUB.Add;

2065: RAISE FND_API.G_EXC_ERROR;
2066: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2067: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2068: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_V2PUB.create_person');
2069: FND_MSG_PUB.Add;
2070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2071: END IF;
2072: END IF;
2073:

Line 2111: FND_MSG_PUB.Add;

2107: RAISE FND_API.G_EXC_ERROR;
2108: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2109: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2110: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_PARTY_CONTACT_V2PUB.create_org_contact');
2111: FND_MSG_PUB.Add;
2112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2113: END IF;
2114: END IF;
2115:

Line 2144: FND_MSG_PUB.Add;

2140: RAISE FND_API.G_EXC_ERROR;
2141: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2142: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2143: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_phone_contact_point');
2144: FND_MSG_PUB.Add;
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;
2147: END IF;
2148:

Line 2170: FND_MSG_PUB.Add;

2166: RAISE FND_API.G_EXC_ERROR;
2167: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2168: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2169: FND_MESSAGE.SET_TOKEN('API_NAME', 'HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
2170: FND_MSG_PUB.Add;
2171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2172: END IF;
2173: END IF;
2174:

Line 2213: FND_MSG_PUB.Add;

2209: RAISE FND_API.G_EXC_ERROR;
2210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2211: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2212: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_PRGM_APPROVAL_PVT.Create_Default_Membership');
2213: FND_MSG_PUB.Add;
2214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2215: END IF;
2216: END IF;
2217: **/

Line 2231: FND_MSG_PUB.Count_And_Get

2227: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' end.');
2228: END IF;
2229:
2230: -- Standard call to get message count and if count is 1, get message info.
2231: FND_MSG_PUB.Count_And_Get
2232: (p_count => x_msg_count,
2233: p_data => x_msg_data
2234: );
2235:

Line 2246: FND_MSG_PUB.Count_And_Get (

2242: WHEN FND_API.G_EXC_ERROR THEN
2243: ROLLBACK TO invite_partner_pvt;
2244: x_return_status := FND_API.G_RET_STS_ERROR;
2245: -- Standard call to get message count and if count=1, get the message
2246: FND_MSG_PUB.Count_And_Get (
2247: p_encoded => FND_API.G_FALSE,
2248: p_count => x_msg_count,
2249: p_data => x_msg_data
2250: );

Line 2256: FND_MSG_PUB.Count_And_Get (

2252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2253: ROLLBACK TO invite_partner_pvt;
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255: -- Standard call to get message count and if count=1, get the message
2256: FND_MSG_PUB.Count_And_Get (
2257: p_encoded => FND_API.G_FALSE,
2258: p_count => x_msg_count,
2259: p_data => x_msg_data
2260: );

Line 2265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2261:
2262: WHEN OTHERS THEN
2263: ROLLBACK TO invite_partner_pvt;
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2267: END IF;
2268:
2269: -- Standard call to get message count and if count=1, get the message

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

2262: WHEN OTHERS THEN
2263: ROLLBACK TO invite_partner_pvt;
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2267: END IF;
2268:
2269: -- Standard call to get message count and if count=1, get the message
2270: FND_MSG_PUB.Count_And_Get (

Line 2270: FND_MSG_PUB.Count_And_Get (

2266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2267: END IF;
2268:
2269: -- Standard call to get message count and if count=1, get the message
2270: FND_MSG_PUB.Count_And_Get (
2271: p_encoded => FND_API.G_FALSE,
2272: p_count => x_msg_count,
2273: p_data => x_msg_data );
2274: