eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PTR_MEMBER_TYPE_PVT dependencies on FND_MSG_PUB

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

14:
15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Pv_ptr_member_type_pvt';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmtcb.pls';
17:
18: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22:

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

15: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Pv_ptr_member_type_pvt';
16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmtcb.pls';
17:
18: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22:
23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

16: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmtcb.pls';
17:
18: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
22:
23: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 108: FND_MSG_PUB.add;

104: IF l_value IS NULL THEN
105: x_return_status := FND_API.g_ret_sts_error;
106: FND_MESSAGE.set_name('PV', 'PV_INVALID_MEMBER_TYPE');
107: FND_MESSAGE.set_token('MEMBER_TYPE',p_member_type );
108: FND_MSG_PUB.add;
109: END IF;
110:
111: END validate_member_type;
112:

Line 133: FND_MSG_PUB.add;

129: x_return_status := FND_API.g_ret_sts_error;
130: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
131: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );
132: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );
133: FND_MSG_PUB.add;
134: END IF;
135:
136: END validate_Lookup;
137:

Line 217: FND_MSG_PUB.add;

213: IF l_is_valid='N' THEN
214: x_return_status := FND_API.g_ret_sts_error;
215: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');
216: FND_MESSAGE.set_token('ID',p_partner_id );
217: FND_MSG_PUB.add;
218: END IF;
219: END validate_partner_id;
220:
221: --------------------------------------------

Line 440: FND_MSG_PUB.initialize;

436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF ;
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
440: FND_MSG_PUB.initialize;
441: END IF;
442: -- Debug Message
443:
444: IF (PV_DEBUG_HIGH_ON) THEN

Line 866: FND_MSG_PUB.add;

862: END IF;
863: ELSE
864: --raise error if the global is invalid
865: FND_MESSAGE.set_name('PV', 'PV_GLOBAL_PARTNER_ID_INVALID');
866: FND_MSG_PUB.add;
867: RAISE FND_API.G_EXC_ERROR;
868: END IF;-- global exists
869: END IF; --end of iif to check whether the subsidiary already has an active relationship with a global
870: END IF;--if new memb type is subsidiary

Line 875: FND_MSG_PUB.Count_And_Get

871: END IF;--end of if , if the current member type and new member type are not equal
872: END IF; --if we terminating or creating
873:
874: -- Standard call to get message count and if count is 1, get message info.
875: FND_MSG_PUB.Count_And_Get
876: (p_count => x_msg_count,
877: p_data => x_msg_data
878: );
879:

Line 893: FND_MSG_PUB.Count_And_Get (

889: WHEN FND_API.G_EXC_ERROR THEN
890: ROLLBACK TO Register_term_ptr_memb_type;
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get (
894: p_encoded => FND_API.G_FALSE,
895: p_count => x_msg_count,
896: p_data => x_msg_data
897: );

Line 903: FND_MSG_PUB.Count_And_Get (

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

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

908:
909: WHEN OTHERS THEN
910: ROLLBACK TO Register_term_ptr_memb_type;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: -- Standard call to get message count and if count=1, get the message

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

910: ROLLBACK TO Register_term_ptr_memb_type;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,

Line 917: FND_MSG_PUB.Count_And_Get (

913: THEN
914: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
915: END IF;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );

Line 1002: FND_MSG_PUB.initialize;

998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1002: FND_MSG_PUB.initialize;
1003: END IF;
1004: -- Debug Message
1005: IF (PV_DEBUG_HIGH_ON) THEN
1006: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1133: FND_MSG_PUB.Count_And_Get

1129:
1130:
1131:
1132:
1133: FND_MSG_PUB.Count_And_Get
1134: (
1135: p_count => x_msg_count
1136: , p_data => x_msg_data
1137: );

Line 1151: FND_MSG_PUB.Count_And_Get (

1147: WHEN FND_API.G_EXC_ERROR THEN
1148: ROLLBACK TO Process_ptr_member_type;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: -- Standard call to get message count and if count=1, get the message
1151: FND_MSG_PUB.Count_And_Get (
1152: p_encoded => FND_API.G_FALSE,
1153: p_count => x_msg_count,
1154: p_data => x_msg_data
1155: );

Line 1161: FND_MSG_PUB.Count_And_Get (

1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: ROLLBACK TO Process_ptr_member_type;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: -- Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (
1162: p_encoded => FND_API.G_FALSE,
1163: p_count => x_msg_count,
1164: p_data => x_msg_data
1165: );

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

1166:
1167: WHEN OTHERS THEN
1168: ROLLBACK TO Process_ptr_member_type;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174: -- Standard call to get message count and if count=1, get the message

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

1168: ROLLBACK TO Process_ptr_member_type;
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,

Line 1175: FND_MSG_PUB.Count_And_Get (

1171: THEN
1172: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1173: END IF;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );

Line 1549: FND_MSG_PUB.ADD;

1545: WF_CORE.CONTEXT('pv_ptr_member_type_pvt', 'terminate_partner', p_event.getEventName(), p_subscription_guid);
1546: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1547: FND_MESSAGE.SET_NAME('PV', 'PV_API_OTHERS_EXCEP');
1548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1549: FND_MSG_PUB.ADD;
1550: RETURN 'ERROR';
1551: END;
1552:
1553:

Line 1609: FND_MSG_PUB.initialize;

1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: -- Initialize message list if p_init_msg_list is set to TRUE.
1608: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1609: FND_MSG_PUB.initialize;
1610: END IF;
1611: -- Debug Message
1612:
1613: IF (PV_DEBUG_HIGH_ON) THEN

Line 1629: FND_MSG_PUB.add;

1625: -- validate all the required in parameters
1626: IF ( p_partner_id IS NULL OR p_partner_id = FND_API.G_MISS_NUM ) THEN
1627: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1628: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'PARTNER_ID' );
1629: FND_MSG_PUB.add;
1630: RAISE FND_API.G_EXC_ERROR;
1631: END IF;
1632: IF ( p_old_partner_status = FND_API.G_MISS_CHAR OR p_old_partner_status is NULL ) THEN
1633: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

Line 1635: FND_MSG_PUB.add;

1631: END IF;
1632: IF ( p_old_partner_status = FND_API.G_MISS_CHAR OR p_old_partner_status is NULL ) THEN
1633: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1634: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD PARTNER STATUS' );
1635: FND_MSG_PUB.add;
1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;
1638: IF ( p_new_partner_status = FND_API.G_MISS_CHAR OR p_new_partner_status is NULL ) THEN
1639: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

Line 1641: FND_MSG_PUB.add;

1637: END IF;
1638: IF ( p_new_partner_status = FND_API.G_MISS_CHAR OR p_new_partner_status is NULL ) THEN
1639: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1640: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW PARTNER STATUS' );
1641: FND_MSG_PUB.add;
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644: IF ( p_new_partner_status = 'A' ) THEN
1645: IF ( p_chg_from_memb_type IS NULL OR p_chg_from_memb_type = FND_API.G_MISS_CHAR ) THEN

Line 1648: FND_MSG_PUB.add;

1644: IF ( p_new_partner_status = 'A' ) THEN
1645: IF ( p_chg_from_memb_type IS NULL OR p_chg_from_memb_type = FND_API.G_MISS_CHAR ) THEN
1646: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1647: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_FROM_MEMBER_TYPE' );
1648: FND_MSG_PUB.add;
1649: RAISE FND_API.G_EXC_ERROR;
1650: END IF;
1651:
1652: IF ( p_chg_to_memb_type IS NULL OR p_chg_to_memb_type = FND_API.G_MISS_CHAR ) THEN

Line 1655: FND_MSG_PUB.add;

1651:
1652: IF ( p_chg_to_memb_type IS NULL OR p_chg_to_memb_type = FND_API.G_MISS_CHAR ) THEN
1653: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1654: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_TO_MEMBER_TYPE' );
1655: FND_MSG_PUB.add;
1656: RAISE FND_API.G_EXC_ERROR;
1657: END IF;
1658: IF ( p_chg_to_memb_type ='SUBSIDIARY' AND ( p_new_global_ptr_id IS NULL OR p_new_global_ptr_id = FND_API.G_MISS_NUM) ) THEN
1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

Line 1661: FND_MSG_PUB.add;

1657: END IF;
1658: IF ( p_chg_to_memb_type ='SUBSIDIARY' AND ( p_new_global_ptr_id IS NULL OR p_new_global_ptr_id = FND_API.G_MISS_NUM) ) THEN
1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1660: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW GlOBAL PARTNER ID' );
1661: FND_MSG_PUB.add;
1662: RAISE FND_API.G_EXC_ERROR;
1663: IF ( p_chg_from_memb_type ='SUBSIDIARY'AND ( p_old_global_ptr_id IS NULL OR p_old_global_ptr_id = FND_API.G_MISS_NUM ) ) THEN
1664: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1665: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD GlOBAL PARTNER ID' );

Line 1666: FND_MSG_PUB.add;

1662: RAISE FND_API.G_EXC_ERROR;
1663: IF ( p_chg_from_memb_type ='SUBSIDIARY'AND ( p_old_global_ptr_id IS NULL OR p_old_global_ptr_id = FND_API.G_MISS_NUM ) ) THEN
1664: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');
1665: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD GlOBAL PARTNER ID' );
1666: FND_MSG_PUB.add;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: END IF;
1670: END IF;

Line 1842: FND_MSG_PUB.Count_And_Get

1838: END IF;
1839:
1840:
1841:
1842: FND_MSG_PUB.Count_And_Get
1843: (
1844: p_count => x_msg_count
1845: , p_data => x_msg_data
1846: );

Line 1861: FND_MSG_PUB.Count_And_Get (

1857: WHEN FND_API.G_EXC_ERROR THEN
1858: ROLLBACK TO update_partner_dtl;
1859: x_return_status := FND_API.G_RET_STS_ERROR;
1860: -- Standard call to get message count and if count=1, get the message
1861: FND_MSG_PUB.Count_And_Get (
1862: p_encoded => FND_API.G_FALSE,
1863: p_count => x_msg_count,
1864: p_data => x_msg_data
1865: );

Line 1871: FND_MSG_PUB.Count_And_Get (

1867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1868: ROLLBACK TO update_partner_dtl;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: -- Standard call to get message count and if count=1, get the message
1871: FND_MSG_PUB.Count_And_Get (
1872: p_encoded => FND_API.G_FALSE,
1873: p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );

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

1876:
1877: WHEN OTHERS THEN
1878: ROLLBACK TO update_partner_dtl;
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1881: THEN
1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884: -- Standard call to get message count and if count=1, get the message

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

1878: ROLLBACK TO update_partner_dtl;
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1881: THEN
1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884: -- Standard call to get message count and if count=1, get the message
1885: FND_MSG_PUB.Count_And_Get (
1886: p_encoded => FND_API.G_FALSE,

Line 1885: FND_MSG_PUB.Count_And_Get (

1881: THEN
1882: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1883: END IF;
1884: -- Standard call to get message count and if count=1, get the message
1885: FND_MSG_PUB.Count_And_Get (
1886: p_encoded => FND_API.G_FALSE,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );