DBA Data[Home] [Help]

APPS.PV_PTR_MEMBER_TYPE_PVT dependencies on FND_MESSAGE

Line 106: FND_MESSAGE.set_name('PV', 'PV_INVALID_MEMBER_TYPE');

102: FETCH memb_csr INTO l_value;
103: CLOSE memb_csr;
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:

Line 107: FND_MESSAGE.set_token('MEMBER_TYPE',p_member_type );

103: CLOSE memb_csr;
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;

Line 130: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');

126: ,p_lookup_code => p_lookup_code
127: );
128: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
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;

Line 131: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );

127: );
128: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
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:

Line 132: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );

128: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
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;

Line 215: FND_MESSAGE.set_name('PV', 'PV_NO_PARTNER_ID');

211: END IF;
212: END IF;
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;

Line 216: FND_MESSAGE.set_token('ID',p_partner_id );

212: END IF;
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:

Line 865: FND_MESSAGE.set_name('PV', 'PV_GLOBAL_PARTNER_ID_INVALID');

861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1547: FND_MESSAGE.SET_NAME('PV', 'PV_API_OTHERS_EXCEP');

1543: EXCEPTION
1544: WHEN OTHERS THEN
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;

Line 1548: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1544: WHEN OTHERS THEN
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:

Line 1627: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

1623: END IF;
1624:
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;

Line 1628: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'PARTNER_ID' );

1624:
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

Line 1633: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

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');
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;

Line 1634: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD PARTNER STATUS' );

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');
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

Line 1639: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

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');
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;

Line 1640: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW PARTNER STATUS' );

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');
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

Line 1646: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

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
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;

Line 1647: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_FROM_MEMBER_TYPE' );

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
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:

Line 1653: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

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
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;

Line 1654: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'CHANGE_TO_MEMBER_TYPE' );

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
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

Line 1659: FND_MESSAGE.SET_NAME('PV', 'PV_MISSING_ITEM');

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');
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

Line 1660: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'NEW GlOBAL PARTNER ID' );

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');
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');

Line 1664: 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' );
1666: FND_MSG_PUB.add;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;

Line 1665: FND_MESSAGE.SET_TOKEN('ITEM_NAME', 'OLD 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' );
1666: FND_MSG_PUB.add;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: END IF;