DBA Data[Home] [Help]

APPS.PV_PG_MEMBERSHIPS_PVT dependencies on FND_MESSAGE

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

69: FETCH memb_csr INTO l_value;
70: CLOSE memb_csr;
71: IF l_value IS NULL THEN
72: x_return_status := FND_API.g_ret_sts_error;
73: FND_MESSAGE.set_name('PV', 'PV_INVALID_MEMBER_TYPE');
74: FND_MESSAGE.set_token('MEMBER_TYPE',p_member_type );
75: FND_MSG_PUB.add;
76: END IF;
77:

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

70: CLOSE memb_csr;
71: IF l_value IS NULL THEN
72: x_return_status := FND_API.g_ret_sts_error;
73: FND_MESSAGE.set_name('PV', 'PV_INVALID_MEMBER_TYPE');
74: FND_MESSAGE.set_token('MEMBER_TYPE',p_member_type );
75: FND_MSG_PUB.add;
76: END IF;
77:
78: END validate_member_type;

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

93: ,p_lookup_code => p_lookup_code
94: );
95: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
96: x_return_status := FND_API.g_ret_sts_error;
97: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
98: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );
99: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );
100: FND_MSG_PUB.add;
101: END IF;

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

94: );
95: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
96: x_return_status := FND_API.g_ret_sts_error;
97: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
98: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );
99: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );
100: FND_MSG_PUB.add;
101: END IF;
102:

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

95: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
96: x_return_status := FND_API.g_ret_sts_error;
97: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
98: FND_MESSAGE.set_token('LOOKUP_TYPE',p_lookup_type );
99: FND_MESSAGE.set_token('LOOKUP_CODE', p_lookup_code );
100: FND_MSG_PUB.add;
101: END IF;
102:
103: END validate_Lookup;

Line 511: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');

507:
508: -- Invoke table handler(Pv_Pg_Memberships_Pkg.Update_Row)
509: IF p_memb_rec.original_end_date < l_ref_memb_rec.start_date THEN
510:
511: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');
512: FND_MSG_PUB.add;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:

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

1111: ,p_lookup_code => p_memb_rec.status_reason_code
1112: );
1113: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
1114: x_return_status := FND_API.g_ret_sts_error;
1115: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
1116: FND_MESSAGE.set_token('LOOKUP_TYPE', l_lookup_type );
1117: FND_MESSAGE.set_token('LOOKUP_CODE', p_memb_rec.status_reason_code );
1118: FND_MSG_PUB.add;
1119: END IF;

Line 1116: FND_MESSAGE.set_token('LOOKUP_TYPE', l_lookup_type );

1112: );
1113: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
1114: x_return_status := FND_API.g_ret_sts_error;
1115: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
1116: FND_MESSAGE.set_token('LOOKUP_TYPE', l_lookup_type );
1117: FND_MESSAGE.set_token('LOOKUP_CODE', p_memb_rec.status_reason_code );
1118: FND_MSG_PUB.add;
1119: END IF;
1120: */

Line 1117: FND_MESSAGE.set_token('LOOKUP_CODE', p_memb_rec.status_reason_code );

1113: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
1114: x_return_status := FND_API.g_ret_sts_error;
1115: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
1116: FND_MESSAGE.set_token('LOOKUP_TYPE', l_lookup_type );
1117: FND_MESSAGE.set_token('LOOKUP_CODE', p_memb_rec.status_reason_code );
1118: FND_MSG_PUB.add;
1119: END IF;
1120: */
1121: