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_PG_MMBR_TRANSITIONS_PVT dependencies on FND_API

Line 50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

46: -- Parameters
47: --
48: -- IN
49: -- p_api_version_number IN NUMBER Required
50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
53: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
54: --

Line 51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

47: --
48: -- IN
49: -- p_api_version_number IN NUMBER Required
50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
53: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
54: --
55: -- OUT

Line 52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

48: -- IN
49: -- p_api_version_number IN NUMBER Required
50: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
51: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
52: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
53: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
54: --
55: -- OUT
56: -- x_return_status OUT VARCHAR2

Line 76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

72: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
73:
74: PROCEDURE Create_Mmbr_Trans(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79:
80: x_return_status OUT NOCOPY VARCHAR2,

Line 77: p_commit IN VARCHAR2 := FND_API.G_FALSE,

73:
74: PROCEDURE Create_Mmbr_Trans(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79:
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,

Line 78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

74: PROCEDURE Create_Mmbr_Trans(
75: p_api_version_number IN NUMBER,
76: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
77: p_commit IN VARCHAR2 := FND_API.G_FALSE,
78: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
79:
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,

Line 93: l_org_id NUMBER := FND_API.G_MISS_NUM;

89: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Mmbr_Trans';
90: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
91: l_return_status_full VARCHAR2(1);
92: l_object_version_number NUMBER := 1;
93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_mmbr_transition_id NUMBER;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT pv_pg_mmbr_transitions_s.NEXTVAL

Line 109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

105: -- Standard Start of API savepoint
106: SAVEPOINT create_mmbr_trans_pvt;
107:
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
110: p_api_version_number,
111: l_api_name,
112: G_PKG_NAME)
113: THEN

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110: p_api_version_number,
111: l_api_name,
112: G_PKG_NAME)
113: THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 119: IF FND_API.to_Boolean( p_init_msg_list )

115: END IF;
116:
117:
118: -- Initialize message list if p_init_msg_list is set to TRUE.
119: IF FND_API.to_Boolean( p_init_msg_list )
120: THEN
121: FND_MSG_PUB.initialize;
122: END IF;
123:

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131:
132:
133:
134: -- Initialize API return status to SUCCESS
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: -- =========================================================================
138: -- Validate Environment
139: -- =========================================================================

Line 144: RAISE FND_API.G_EXC_ERROR;

140:
141: IF FND_GLOBAL.USER_ID IS NULL
142: THEN
143: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147:
148:

Line 149: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

145: END IF;
146:
147:
148:
149: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
150: THEN
151: -- Debug message
152: IF (PV_DEBUG_HIGH_ON) THEN
153:

Line 160: p_init_msg_list => FND_API.G_FALSE,

156:
157: -- Invoke validation procedures
158: Validate_mmbr_trans(
159: p_api_version_number => 1.0,
160: p_init_msg_list => FND_API.G_FALSE,
161: p_validation_level => p_validation_level,
162: p_validation_mode => JTF_PLSQL_API.g_create,
163: p_mmbr_tran_rec => p_mmbr_tran_rec,
164: x_return_status => x_return_status,

Line 169: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

165: x_msg_count => x_msg_count,
166: x_msg_data => x_msg_data);
167: END IF;
168:
169: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173: -- Local variable initialization

Line 170: RAISE FND_API.G_EXC_ERROR;

166: x_msg_data => x_msg_data);
167: END IF;
168:
169: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173: -- Local variable initialization
174:

Line 175: IF p_mmbr_tran_rec.mmbr_transition_id IS NULL OR p_mmbr_tran_rec.mmbr_transition_id = FND_API.g_miss_num THEN

171: END IF;
172:
173: -- Local variable initialization
174:
175: IF p_mmbr_tran_rec.mmbr_transition_id IS NULL OR p_mmbr_tran_rec.mmbr_transition_id = FND_API.g_miss_num THEN
176: LOOP
177: l_dummy := NULL;
178: OPEN c_id;
179: FETCH c_id INTO l_mmbr_transition_id;

Line 211: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

207: p_last_update_login => FND_GLOBAL.conc_login_id
208: );
209:
210: x_mmbr_transition_id := l_mmbr_transition_id;
211: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: --
215: -- End of API body

Line 212: RAISE FND_API.G_EXC_ERROR;

208: );
209:
210: x_mmbr_transition_id := l_mmbr_transition_id;
211: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: --
215: -- End of API body
216: --

Line 219: IF FND_API.to_Boolean( p_commit )

215: -- End of API body
216: --
217:
218: -- Standard check for p_commit
219: IF FND_API.to_Boolean( p_commit )
220: THEN
221: COMMIT WORK;
222: END IF;
223:

Line 240: x_return_status := FND_API.g_ret_sts_error;

236: );
237: EXCEPTION
238:
239: WHEN PVX_UTILITY_PVT.resource_locked THEN
240: x_return_status := FND_API.g_ret_sts_error;
241: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO CREATE_Mmbr_Trans_PVT;

Line 243: WHEN FND_API.G_EXC_ERROR THEN

239: WHEN PVX_UTILITY_PVT.resource_locked THEN
240: x_return_status := FND_API.g_ret_sts_error;
241: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: -- Standard call to get message count and if count=1, get the message
247: FND_MSG_PUB.Count_And_Get (

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: -- Standard call to get message count and if count=1, get the message
247: FND_MSG_PUB.Count_And_Get (
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,

Line 248: p_encoded => FND_API.G_FALSE,

244: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: -- Standard call to get message count and if count=1, get the message
247: FND_MSG_PUB.Count_And_Get (
248: p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data
251: );
252:

Line 253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

249: p_count => x_msg_count,
250: p_data => x_msg_data
251: );
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

251: );
252:
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,

Line 258: p_encoded => FND_API.G_FALSE,

254: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data
261: );
262:

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: );
262:
263: WHEN OTHERS THEN
264: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
267: THEN
268: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
269: END IF;

Line 272: p_encoded => FND_API.G_FALSE,

268: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
269: END IF;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );
276: End Create_Mmbr_Trans;

Line 292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

288: -- Parameters
289: --
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
296: --

Line 293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

289: --
290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
296: --
297: -- OUT

Line 294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

290: -- IN
291: -- p_api_version_number IN NUMBER Required
292: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
293: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
294: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
295: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
296: --
297: -- OUT
298: -- x_return_status OUT VARCHAR2

Line 314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

310: -- ==============================================================================
311:
312: PROCEDURE Update_Mmbr_Trans(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317:
318: x_return_status OUT NOCOPY VARCHAR2,

Line 315: p_commit IN VARCHAR2 := FND_API.G_FALSE,

311:
312: PROCEDURE Update_Mmbr_Trans(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317:
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,

Line 316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

312: PROCEDURE Update_Mmbr_Trans(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317:
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,

Line 349: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

345: -- Standard Start of API savepoint
346: SAVEPOINT update_mmbr_trans_pvt;
347:
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME)
353: THEN

Line 354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME)
353: THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 359: IF FND_API.to_Boolean( p_init_msg_list )

355: END IF;
356:
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list )
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS;

371:
372:
373:
374: -- Initialize API return status to SUCCESS
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376:
377: -- Debug Message
378: IF (PV_DEBUG_HIGH_ON) THEN
379:

Line 391: RAISE FND_API.G_EXC_ERROR;

387: If ( c_get_Mmbr_Trans%NOTFOUND) THEN
388: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
389: p_token_name => 'INFO',
390: p_token_value => 'Mmbr_Trans') ;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393: -- Debug Message
394: IF (PV_DEBUG_HIGH_ON) THEN
395:

Line 402: l_tar_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM ) Then

398: CLOSE c_get_Mmbr_Trans;
399:
400:
401: If (l_tar_mmbr_tran_rec.object_version_number is NULL or
402: l_tar_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM ) Then
403: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
404: p_token_name => 'COLUMN',
405: p_token_value => 'Last_Update_Date') ;
406: raise FND_API.G_EXC_ERROR;

Line 406: raise FND_API.G_EXC_ERROR;

402: l_tar_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM ) Then
403: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
404: p_token_name => 'COLUMN',
405: p_token_value => 'Last_Update_Date') ;
406: raise FND_API.G_EXC_ERROR;
407: End if;
408: -- Check Whether record has been changed by someone else
409: If (l_tar_mmbr_tran_rec.object_version_number <> l_ref_mmbr_tran_rec.object_version_number) Then
410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 413: raise FND_API.G_EXC_ERROR;

409: If (l_tar_mmbr_tran_rec.object_version_number <> l_ref_mmbr_tran_rec.object_version_number) Then
410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
411: p_token_name => 'INFO',
412: p_token_value => 'Mmbr_Trans') ;
413: raise FND_API.G_EXC_ERROR;
414: End if;
415:
416:
417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

413: raise FND_API.G_EXC_ERROR;
414: End if;
415:
416:
417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
418: THEN
419: -- Debug message
420: IF (PV_DEBUG_HIGH_ON) THEN
421:

Line 428: p_init_msg_list => FND_API.G_FALSE,

424:
425: -- Invoke validation procedures
426: Validate_mmbr_trans(
427: p_api_version_number => 1.0,
428: p_init_msg_list => FND_API.G_FALSE,
429: p_validation_level => p_validation_level,
430: p_validation_mode => JTF_PLSQL_API.g_update,
431: p_mmbr_tran_rec => p_mmbr_tran_rec,
432: x_return_status => x_return_status,

Line 437: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

433: x_msg_count => x_msg_count,
434: x_msg_data => x_msg_data);
435: END IF;
436:
437: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440:
441:

Line 438: RAISE FND_API.G_EXC_ERROR;

434: x_msg_data => x_msg_data);
435: END IF;
436:
437: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440:
441:
442: -- Debug Message

Line 463: IF FND_API.to_Boolean( p_commit )

459: -- End of API body.
460: --
461:
462: -- Standard check for p_commit
463: IF FND_API.to_Boolean( p_commit )
464: THEN
465: COMMIT WORK;
466: END IF;
467:

Line 484: x_return_status := FND_API.g_ret_sts_error;

480: );
481: EXCEPTION
482:
483: WHEN PVX_UTILITY_PVT.resource_locked THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;

Line 487: WHEN FND_API.G_EXC_ERROR THEN

483: WHEN PVX_UTILITY_PVT.resource_locked THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,

Line 492: p_encoded => FND_API.G_FALSE,

488: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:

Line 497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (

Line 499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

495: );
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,

Line 502: p_encoded => FND_API.G_FALSE,

498: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506:

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: );
506:
507: WHEN OTHERS THEN
508: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;

Line 516: p_encoded => FND_API.G_FALSE,

512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
514: -- Standard call to get message count and if count=1, get the message
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520: End Update_Mmbr_Trans;

Line 536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

532: -- Parameters
533: --
534: -- IN
535: -- p_api_version_number IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_mmbr_transition_id IN NUMBER
540: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

533: --
534: -- IN
535: -- p_api_version_number IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_mmbr_transition_id IN NUMBER
540: -- p_object_version_number IN NUMBER Optional Default = NULL
541: --

Line 538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

534: -- IN
535: -- p_api_version_number IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
537: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
538: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_mmbr_transition_id IN NUMBER
540: -- p_object_version_number IN NUMBER Optional Default = NULL
541: --
542: -- OUT

Line 559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

555: -- ==============================================================================
556:
557: PROCEDURE Delete_Mmbr_Trans(
558: p_api_version_number IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,

Line 560: p_commit IN VARCHAR2 := FND_API.G_FALSE,

556:
557: PROCEDURE Delete_Mmbr_Trans(
558: p_api_version_number IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,
564: x_msg_data OUT NOCOPY VARCHAR2,

Line 561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

557: PROCEDURE Delete_Mmbr_Trans(
558: p_api_version_number IN NUMBER,
559: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
560: p_commit IN VARCHAR2 := FND_API.G_FALSE,
561: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
562: x_return_status OUT NOCOPY VARCHAR2,
563: x_msg_count OUT NOCOPY NUMBER,
564: x_msg_data OUT NOCOPY VARCHAR2,
565: p_mmbr_transition_id IN NUMBER,

Line 579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

575: -- Standard Start of API savepoint
576: SAVEPOINT delete_mmbr_trans_pvt;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
583: THEN

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
583: THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 589: IF FND_API.to_Boolean( p_init_msg_list )

585: END IF;
586:
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: IF FND_API.to_Boolean( p_init_msg_list )
590: THEN
591: FND_MSG_PUB.initialize;
592: END IF;
593:

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601:
602:
603:
604: -- Initialize API return status to SUCCESS
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: --
608: -- Api body
609: --

Line 625: IF FND_API.to_Boolean( p_commit )

621: -- End of API body
622: --
623:
624: -- Standard check for p_commit
625: IF FND_API.to_Boolean( p_commit )
626: THEN
627: COMMIT WORK;
628: END IF;
629:

Line 646: x_return_status := FND_API.g_ret_sts_error;

642: );
643: EXCEPTION
644:
645: WHEN PVX_UTILITY_PVT.resource_locked THEN
646: x_return_status := FND_API.g_ret_sts_error;
647: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Mmbr_Trans_PVT;

Line 649: WHEN FND_API.G_EXC_ERROR THEN

645: WHEN PVX_UTILITY_PVT.resource_locked THEN
646: x_return_status := FND_API.g_ret_sts_error;
647: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (

Line 651: x_return_status := FND_API.G_RET_STS_ERROR;

647: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,

Line 654: p_encoded => FND_API.G_FALSE,

650: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658:

Line 659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657: );
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,

Line 664: p_encoded => FND_API.G_FALSE,

660: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );
668:

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: );
668:
669: WHEN OTHERS THEN
670: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;

Line 678: p_encoded => FND_API.G_FALSE,

674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682: End Delete_Mmbr_Trans;

Line 700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

696: -- Parameters
697: --
698: -- IN
699: -- p_api_version_number IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
703: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
704: --

Line 701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

697: --
698: -- IN
699: -- p_api_version_number IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
703: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
704: --
705: -- OUT

Line 702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

698: -- IN
699: -- p_api_version_number IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
701: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
703: -- p_mmbr_tran_rec IN mmbr_tran_rec_type Required
704: --
705: -- OUT
706: -- x_return_status OUT VARCHAR2

Line 722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

718: -- ==============================================================================
719:
720: PROCEDURE Lock_Mmbr_Trans(
721: p_api_version_number IN NUMBER,
722: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
723:
724: x_return_status OUT NOCOPY VARCHAR2,
725: x_msg_count OUT NOCOPY NUMBER,
726: x_msg_data OUT NOCOPY VARCHAR2,

Line 748: IF FND_API.to_Boolean( p_init_msg_list )

744: END IF;
745:
746:
747: -- Initialize message list if p_init_msg_list is set to TRUE.
748: IF FND_API.to_Boolean( p_init_msg_list )
749: THEN
750: FND_MSG_PUB.initialize;
751: END IF;
752:

Line 756: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

752:
753:
754:
755: -- Standard call to check for call compatibility.
756: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
757: p_api_version_number,
758: l_api_name,
759: G_PKG_NAME)
760: THEN

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: p_api_version_number,
758: l_api_name,
759: G_PKG_NAME)
760: THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763:
764:
765:

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

763:
764:
765:
766: -- Initialize API return status to SUCCESS
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769:
770: ------------------------ lock -------------------------
771: pv_pg_mmbr_transitions_Pkg.Lock_Row(l_mmbr_transition_id,p_object_version);

Line 776: p_encoded => FND_API.g_false,

772:
773:
774: -------------------- finish --------------------------
775: FND_MSG_PUB.count_and_get(
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
778: p_data => x_msg_data);
779: IF (PV_DEBUG_HIGH_ON) THEN
780:

Line 786: x_return_status := FND_API.g_ret_sts_error;

782: END IF;
783: EXCEPTION
784:
785: WHEN PVX_UTILITY_PVT.resource_locked THEN
786: x_return_status := FND_API.g_ret_sts_error;
787: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO LOCK_Mmbr_Trans_PVT;

Line 789: WHEN FND_API.G_EXC_ERROR THEN

785: WHEN PVX_UTILITY_PVT.resource_locked THEN
786: x_return_status := FND_API.g_ret_sts_error;
787: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,

Line 794: p_encoded => FND_API.G_FALSE,

790: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: -- Standard call to get message count and if count=1, get the message
793: FND_MSG_PUB.Count_And_Get (
794: p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798:

Line 799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

795: p_count => x_msg_count,
796: p_data => x_msg_data
797: );
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: -- Standard call to get message count and if count=1, get the message
803: FND_MSG_PUB.Count_And_Get (

Line 801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

797: );
798:
799: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
800: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: -- Standard call to get message count and if count=1, get the message
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE,
805: p_count => x_msg_count,

Line 804: p_encoded => FND_API.G_FALSE,

800: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: -- Standard call to get message count and if count=1, get the message
803: FND_MSG_PUB.Count_And_Get (
804: p_encoded => FND_API.G_FALSE,
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );
808:

Line 811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

807: );
808:
809: WHEN OTHERS THEN
810: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
813: THEN
814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
815: END IF;

Line 818: p_encoded => FND_API.G_FALSE,

814: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
815: END IF;
816: -- Standard call to get message count and if count=1, get the message
817: FND_MSG_PUB.Count_And_Get (
818: p_encoded => FND_API.G_FALSE,
819: p_count => x_msg_count,
820: p_data => x_msg_data
821: );
822: End Lock_Mmbr_Trans;

Line 835: x_return_status := FND_API.g_ret_sts_success;

831: IS
832: l_valid_flag VARCHAR2(1);
833:
834: BEGIN
835: x_return_status := FND_API.g_ret_sts_success;
836: IF p_validation_mode = JTF_PLSQL_API.g_create
837: AND p_mmbr_tran_rec.mmbr_transition_id IS NOT NULL
838: THEN
839: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

Line 845: IF l_valid_flag = FND_API.g_false THEN

841: 'mmbr_transition_id = ''' || p_mmbr_tran_rec.mmbr_transition_id ||''''
842: );
843: END IF;
844:
845: IF l_valid_flag = FND_API.g_false THEN
846: PVX_UTILITY_PVT.Error_Message(p_message_name => 'pv_pg_mmbr_transitionsition_id_DUPLICATE');
847: x_return_status := FND_API.g_ret_sts_error;
848: END IF;
849:

Line 847: x_return_status := FND_API.g_ret_sts_error;

843: END IF;
844:
845: IF l_valid_flag = FND_API.g_false THEN
846: PVX_UTILITY_PVT.Error_Message(p_message_name => 'pv_pg_mmbr_transitionsition_id_DUPLICATE');
847: x_return_status := FND_API.g_ret_sts_error;
848: END IF;
849:
850: END check_Mmbr_Tran_Uk_Items;
851:

Line 861: x_return_status := FND_API.g_ret_sts_success;

857: x_return_status OUT NOCOPY VARCHAR2
858: )
859: IS
860: BEGIN
861: x_return_status := FND_API.g_ret_sts_success;
862:
863: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
864:
865: /*

Line 866: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.mmbr_transition_id IS NULL THEN

862:
863: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
864:
865: /*
866: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.mmbr_transition_id IS NULL THEN
867: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: */

Line 868: x_return_status := FND_API.g_ret_sts_error;

864:
865: /*
866: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.mmbr_transition_id IS NULL THEN
867: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: */
871:
872: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.from_membership_id IS NULL THEN

Line 872: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.from_membership_id IS NULL THEN

868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: */
871:
872: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.from_membership_id IS NULL THEN
873: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );
874: x_return_status := FND_API.g_ret_sts_error;
875: END IF;
876:

Line 874: x_return_status := FND_API.g_ret_sts_error;

870: */
871:
872: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.from_membership_id IS NULL THEN
873: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );
874: x_return_status := FND_API.g_ret_sts_error;
875: END IF;
876:
877:
878: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.to_membership_id IS NULL THEN

Line 878: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.to_membership_id IS NULL THEN

874: x_return_status := FND_API.g_ret_sts_error;
875: END IF;
876:
877:
878: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.to_membership_id IS NULL THEN
879: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );
880: x_return_status := FND_API.g_ret_sts_error;
881: END IF;
882:

Line 880: x_return_status := FND_API.g_ret_sts_error;

876:
877:
878: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.to_membership_id IS NULL THEN
879: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );
880: x_return_status := FND_API.g_ret_sts_error;
881: END IF;
882:
883: /*
884: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.object_version_number IS NULL THEN

Line 884: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.object_version_number IS NULL THEN

880: x_return_status := FND_API.g_ret_sts_error;
881: END IF;
882:
883: /*
884: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.object_version_number IS NULL THEN
885: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
886: x_return_status := FND_API.g_ret_sts_error;
887: END IF;
888:

Line 886: x_return_status := FND_API.g_ret_sts_error;

882:
883: /*
884: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.object_version_number IS NULL THEN
885: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
886: x_return_status := FND_API.g_ret_sts_error;
887: END IF;
888:
889: */
890: ELSE

Line 893: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM THEN

889: */
890: ELSE
891:
892:
893: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM THEN
894: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:

Line 895: x_return_status := FND_API.g_ret_sts_error;

891:
892:
893: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM THEN
894: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:
898:
899: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM THEN

Line 899: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM THEN

895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:
898:
899: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM THEN
900: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:

Line 901: x_return_status := FND_API.g_ret_sts_error;

897:
898:
899: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM THEN
900: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904:
905: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM THEN

Line 905: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM THEN

901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904:
905: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM THEN
906: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );
907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:

Line 907: x_return_status := FND_API.g_ret_sts_error;

903:
904:
905: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM THEN
906: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );
907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:
910:
911: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 911: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM THEN

907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:
910:
911: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: END IF;

Line 913: x_return_status := FND_API.g_ret_sts_error;

909:
910:
911: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: END IF;
916:
917: END check_Mmbr_Tran_Req_Items;

Line 927: x_return_status := FND_API.g_ret_sts_success;

923: x_return_status OUT NOCOPY VARCHAR2
924: )
925: IS
926: BEGIN
927: x_return_status := FND_API.g_ret_sts_success;
928:
929: -- Enter custom code here
930:
931: END check_Mmbr_Tran_Fk_Items;

Line 941: x_return_status := FND_API.g_ret_sts_success;

937: x_return_status OUT NOCOPY VARCHAR2
938: )
939: IS
940: BEGIN
941: x_return_status := FND_API.g_ret_sts_success;
942:
943: -- Enter custom code here
944:
945: END check_Mmbr_Tran_Lookup_Items;

Line 958: l_return_status := FND_API.g_ret_sts_success;

954: IS
955: l_return_status VARCHAR2(1);
956: BEGIN
957:
958: l_return_status := FND_API.g_ret_sts_success;
959: -- Check Items Uniqueness API calls
960:
961: check_Mmbr_tran_Uk_Items(
962: p_mmbr_tran_rec => p_mmbr_tran_rec,

Line 965: IF x_return_status <> FND_API.g_ret_sts_success THEN

961: check_Mmbr_tran_Uk_Items(
962: p_mmbr_tran_rec => p_mmbr_tran_rec,
963: p_validation_mode => p_validation_mode,
964: x_return_status => x_return_status);
965: IF x_return_status <> FND_API.g_ret_sts_success THEN
966: l_return_status := FND_API.g_ret_sts_error;
967: END IF;
968:
969: -- Check Items Required/NOT NULL API calls

Line 966: l_return_status := FND_API.g_ret_sts_error;

962: p_mmbr_tran_rec => p_mmbr_tran_rec,
963: p_validation_mode => p_validation_mode,
964: x_return_status => x_return_status);
965: IF x_return_status <> FND_API.g_ret_sts_success THEN
966: l_return_status := FND_API.g_ret_sts_error;
967: END IF;
968:
969: -- Check Items Required/NOT NULL API calls
970:

Line 975: IF x_return_status <> FND_API.g_ret_sts_success THEN

971: check_mmbr_tran_req_items(
972: p_mmbr_tran_rec => p_mmbr_tran_rec,
973: p_validation_mode => p_validation_mode,
974: x_return_status => x_return_status);
975: IF x_return_status <> FND_API.g_ret_sts_success THEN
976: l_return_status := FND_API.g_ret_sts_error;
977: END IF;
978: -- Check Items Foreign Keys API calls
979:

Line 976: l_return_status := FND_API.g_ret_sts_error;

972: p_mmbr_tran_rec => p_mmbr_tran_rec,
973: p_validation_mode => p_validation_mode,
974: x_return_status => x_return_status);
975: IF x_return_status <> FND_API.g_ret_sts_success THEN
976: l_return_status := FND_API.g_ret_sts_error;
977: END IF;
978: -- Check Items Foreign Keys API calls
979:
980: check_mmbr_tran_FK_items(

Line 983: IF x_return_status <> FND_API.g_ret_sts_success THEN

979:
980: check_mmbr_tran_FK_items(
981: p_mmbr_tran_rec => p_mmbr_tran_rec,
982: x_return_status => x_return_status);
983: IF x_return_status <> FND_API.g_ret_sts_success THEN
984: l_return_status := FND_API.g_ret_sts_error;
985: END IF;
986: -- Check Items Lookups
987:

Line 984: l_return_status := FND_API.g_ret_sts_error;

980: check_mmbr_tran_FK_items(
981: p_mmbr_tran_rec => p_mmbr_tran_rec,
982: x_return_status => x_return_status);
983: IF x_return_status <> FND_API.g_ret_sts_success THEN
984: l_return_status := FND_API.g_ret_sts_error;
985: END IF;
986: -- Check Items Lookups
987:
988: check_mmbr_tran_Lookup_items(

Line 991: IF x_return_status <> FND_API.g_ret_sts_success THEN

987:
988: check_mmbr_tran_Lookup_items(
989: p_mmbr_tran_rec => p_mmbr_tran_rec,
990: x_return_status => x_return_status);
991: IF x_return_status <> FND_API.g_ret_sts_success THEN
992: l_return_status := FND_API.g_ret_sts_error;
993: END IF;
994:
995: x_return_status := l_return_status;

Line 992: l_return_status := FND_API.g_ret_sts_error;

988: check_mmbr_tran_Lookup_items(
989: p_mmbr_tran_rec => p_mmbr_tran_rec,
990: x_return_status => x_return_status);
991: IF x_return_status <> FND_API.g_ret_sts_success THEN
992: l_return_status := FND_API.g_ret_sts_error;
993: END IF;
994:
995: x_return_status := l_return_status;
996:

Line 1080: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN

1076: l_mmbr_tran_rec mmbr_tran_rec_type := p_mmbr_tran_rec;
1077: BEGIN
1078: -- Developers should put their code to default the record type
1079: -- e.g. IF p_campaign_rec.status_code IS NULL
1080: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1081: -- l_campaign_rec.status_code := 'NEW' ;
1082: -- END IF ;
1083: --
1084: NULL ;

Line 1092: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1088:
1089:
1090: PROCEDURE Validate_Mmbr_Trans(
1091: p_api_version_number IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1093: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1094: p_mmbr_tran_rec IN mmbr_tran_rec_type,
1095: p_validation_mode IN VARCHAR2,
1096: x_return_status OUT NOCOPY VARCHAR2,

Line 1093: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1089:
1090: PROCEDURE Validate_Mmbr_Trans(
1091: p_api_version_number IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1093: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1094: p_mmbr_tran_rec IN mmbr_tran_rec_type,
1095: p_validation_mode IN VARCHAR2,
1096: x_return_status OUT NOCOPY VARCHAR2,
1097: x_msg_count OUT NOCOPY NUMBER,

Line 1112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1108: -- Standard Start of API savepoint
1109: SAVEPOINT validate_mmbr_trans_;
1110:
1111: -- Standard call to check for call compatibility.
1112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1113: p_api_version_number,
1114: l_api_name,
1115: G_PKG_NAME)
1116: THEN

Line 1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1113: p_api_version_number,
1114: l_api_name,
1115: G_PKG_NAME)
1116: THEN
1117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1118: END IF;
1119:
1120:
1121: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1122: IF FND_API.to_Boolean( p_init_msg_list )

1118: END IF;
1119:
1120:
1121: -- Initialize message list if p_init_msg_list is set to TRUE.
1122: IF FND_API.to_Boolean( p_init_msg_list )
1123: THEN
1124: FND_MSG_PUB.initialize;
1125: END IF;
1126:

Line 1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1131: p_validation_mode => p_validation_mode,
1132: x_return_status => x_return_status
1133: );
1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;

Line 1136: RAISE FND_API.G_EXC_ERROR;

1132: x_return_status => x_return_status
1133: );
1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF;

Line 1137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1133: );
1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF;
1141:

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1134:
1135: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF;
1141:
1142: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1158: p_init_msg_list => FND_API.G_FALSE,

1154:
1155: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1156: Validate_mmbr_tran_Rec(
1157: p_api_version_number => 1.0,
1158: p_init_msg_list => FND_API.G_FALSE,
1159: x_return_status => x_return_status,
1160: x_msg_count => x_msg_count,
1161: x_msg_data => x_msg_data,
1162: p_mmbr_tran_rec => l_mmbr_tran_rec);

Line 1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1160: x_msg_count => x_msg_count,
1161: x_msg_data => x_msg_data,
1162: p_mmbr_tran_rec => l_mmbr_tran_rec);
1163:
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;

Line 1165: RAISE FND_API.G_EXC_ERROR;

1161: x_msg_data => x_msg_data,
1162: p_mmbr_tran_rec => l_mmbr_tran_rec);
1163:
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169: END IF;

Line 1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1162: p_mmbr_tran_rec => l_mmbr_tran_rec);
1163:
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169: END IF;
1170:

Line 1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1163:
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169: END IF;
1170:
1171:

Line 1181: x_return_status := FND_API.G_RET_STS_SUCCESS;

1177:
1178:
1179:
1180: -- Initialize API return status to SUCCESS
1181: x_return_status := FND_API.G_RET_STS_SUCCESS;
1182:
1183:
1184: -- Debug Message
1185: IF (PV_DEBUG_HIGH_ON) THEN

Line 1199: x_return_status := FND_API.g_ret_sts_error;

1195: );
1196: EXCEPTION
1197:
1198: WHEN PVX_UTILITY_PVT.resource_locked THEN
1199: x_return_status := FND_API.g_ret_sts_error;
1200: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: ROLLBACK TO VALIDATE_Mmbr_Trans_;

Line 1202: WHEN FND_API.G_EXC_ERROR THEN

1198: WHEN PVX_UTILITY_PVT.resource_locked THEN
1199: x_return_status := FND_API.g_ret_sts_error;
1200: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: -- Standard call to get message count and if count=1, get the message
1206: FND_MSG_PUB.Count_And_Get (

Line 1204: x_return_status := FND_API.G_RET_STS_ERROR;

1200: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: -- Standard call to get message count and if count=1, get the message
1206: FND_MSG_PUB.Count_And_Get (
1207: p_encoded => FND_API.G_FALSE,
1208: p_count => x_msg_count,

Line 1207: p_encoded => FND_API.G_FALSE,

1203: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: -- Standard call to get message count and if count=1, get the message
1206: FND_MSG_PUB.Count_And_Get (
1207: p_encoded => FND_API.G_FALSE,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data
1210: );
1211:

Line 1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1208: p_count => x_msg_count,
1209: p_data => x_msg_data
1210: );
1211:
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: -- Standard call to get message count and if count=1, get the message
1216: FND_MSG_PUB.Count_And_Get (

Line 1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1210: );
1211:
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: -- Standard call to get message count and if count=1, get the message
1216: FND_MSG_PUB.Count_And_Get (
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_msg_count,

Line 1217: p_encoded => FND_API.G_FALSE,

1213: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: -- Standard call to get message count and if count=1, get the message
1216: FND_MSG_PUB.Count_And_Get (
1217: p_encoded => FND_API.G_FALSE,
1218: p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );
1221:

Line 1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1220: );
1221:
1222: WHEN OTHERS THEN
1223: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1225: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1228: END IF;

Line 1231: p_encoded => FND_API.G_FALSE,

1227: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1228: END IF;
1229: -- Standard call to get message count and if count=1, get the message
1230: FND_MSG_PUB.Count_And_Get (
1231: p_encoded => FND_API.G_FALSE,
1232: p_count => x_msg_count,
1233: p_data => x_msg_data
1234: );
1235: End Validate_Mmbr_Trans;

Line 1240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1236:
1237:
1238: PROCEDURE Validate_Mmbr_Tran_Rec (
1239: p_api_version_number IN NUMBER,
1240: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1241: x_return_status OUT NOCOPY VARCHAR2,
1242: x_msg_count OUT NOCOPY NUMBER,
1243: x_msg_data OUT NOCOPY VARCHAR2,
1244: p_mmbr_tran_rec IN mmbr_tran_rec_type

Line 1249: IF FND_API.to_Boolean( p_init_msg_list )

1245: )
1246: IS
1247: BEGIN
1248: -- Initialize message list if p_init_msg_list is set to TRUE.
1249: IF FND_API.to_Boolean( p_init_msg_list )
1250: THEN
1251: FND_MSG_PUB.initialize;
1252: END IF;
1253:

Line 1257: x_return_status := FND_API.G_RET_STS_SUCCESS;

1253:
1254:
1255:
1256: -- Initialize API return status to SUCCESS
1257: x_return_status := FND_API.G_RET_STS_SUCCESS;
1258:
1259: -- Hint: Validate data
1260: -- If data not valid
1261: -- THEN

Line 1262: -- x_return_status := FND_API.G_RET_STS_ERROR;

1258:
1259: -- Hint: Validate data
1260: -- If data not valid
1261: -- THEN
1262: -- x_return_status := FND_API.G_RET_STS_ERROR;
1263:
1264: -- Debug Message
1265: IF (PV_DEBUG_HIGH_ON) THEN
1266: