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.OZF_OFFR_QUAL_PVT dependencies on FND_API

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

50: -- Parameters
51: --
52: -- IN
53: -- p_api_version_number IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
55: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
57: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
58: --

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

51: --
52: -- IN
53: -- p_api_version_number IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
55: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
57: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
58: --
59: -- OUT

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

52: -- IN
53: -- p_api_version_number IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
55: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
57: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
58: --
59: -- OUT
60: -- x_return_status OUT VARCHAR2

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

72: -- ==============================================================================
73:
74: PROCEDURE Create_Offr_Qual(
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_Offr_Qual(
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_Offr_Qual(
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_Offr_Qual';
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_qualifier_id NUMBER;
95: l_dummy NUMBER;
96: l_ozf_offr_qual_rec ozf_offr_qual_rec_type;
97: CURSOR c_id IS

Line 110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 120: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 142: RAISE FND_API.G_EXC_ERROR;

138:
139: IF FND_GLOBAL.USER_ID IS NULL
140: THEN
141: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145:
146: IF p_ozf_offr_qual_rec.qualifier_id IS NULL OR p_ozf_offr_qual_rec.qualifier_id = FND_API.g_miss_num THEN

Line 146: IF p_ozf_offr_qual_rec.qualifier_id IS NULL OR p_ozf_offr_qual_rec.qualifier_id = FND_API.g_miss_num THEN

142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145:
146: IF p_ozf_offr_qual_rec.qualifier_id IS NULL OR p_ozf_offr_qual_rec.qualifier_id = FND_API.g_miss_num THEN
147: LOOP
148: l_dummy := NULL;
149: OPEN c_id;
150: FETCH c_id INTO l_qualifier_id;

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

163:
164: l_ozf_offr_qual_rec := p_ozf_offr_qual_rec;
165: l_ozf_offr_qual_rec.qualifier_id := l_qualifier_id;
166:
167: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
168: THEN
169: -- Debug message
170: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offr_Qual');
171:

Line 175: p_init_msg_list => FND_API.G_FALSE,

171:
172: -- Invoke validation procedures
173: Validate_offr_qual(
174: p_api_version_number => 1.0,
175: p_init_msg_list => FND_API.G_FALSE,
176: p_validation_level => p_validation_level,
177: p_validation_mode => JTF_PLSQL_API.g_create,
178: p_ozf_offr_qual_rec => l_ozf_offr_qual_rec,
179: x_return_status => x_return_status,

Line 185: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

181: x_msg_data => x_msg_data);
182:
183: END IF;
184:
185: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: -- Local variable initialization

Line 186: RAISE FND_API.G_EXC_ERROR;

182:
183: END IF;
184:
185: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: -- Local variable initialization
190:

Line 232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

228: p_object_version_number => 1
229: );
230:
231: x_qualifier_id := l_qualifier_id;
232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: --
236: -- End of API body

Line 233: RAISE FND_API.G_EXC_ERROR;

229: );
230:
231: x_qualifier_id := l_qualifier_id;
232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: --
236: -- End of API body
237: --

Line 240: IF FND_API.to_Boolean( p_commit )

236: -- End of API body
237: --
238:
239: -- Standard check for p_commit
240: IF FND_API.to_Boolean( p_commit )
241: THEN
242: COMMIT WORK;
243: END IF;
244:

Line 258: x_return_status := FND_API.g_ret_sts_error;

254: );
255: EXCEPTION
256:
257: WHEN OZF_Utility_PVT.resource_locked THEN
258: x_return_status := FND_API.g_ret_sts_error;
259: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
260:
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO CREATE_Offr_Qual_PVT;

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257: WHEN OZF_Utility_PVT.resource_locked THEN
258: x_return_status := FND_API.g_ret_sts_error;
259: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
260:
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO CREATE_Offr_Qual_PVT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
260:
261: WHEN FND_API.G_EXC_ERROR THEN
262: ROLLBACK TO CREATE_Offr_Qual_PVT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,

Line 266: p_encoded => FND_API.G_FALSE,

262: ROLLBACK TO CREATE_Offr_Qual_PVT;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: -- Standard call to get message count and if count=1, get the message
265: FND_MSG_PUB.Count_And_Get (
266: p_encoded => FND_API.G_FALSE,
267: p_count => x_msg_count,
268: p_data => x_msg_data
269: );
270:

Line 271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

267: p_count => x_msg_count,
268: p_data => x_msg_data
269: );
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO CREATE_Offr_Qual_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: );
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO CREATE_Offr_Qual_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,

Line 276: p_encoded => FND_API.G_FALSE,

272: ROLLBACK TO CREATE_Offr_Qual_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );
280:

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

279: );
280:
281: WHEN OTHERS THEN
282: ROLLBACK TO CREATE_Offr_Qual_PVT;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;

Line 290: p_encoded => FND_API.G_FALSE,

286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294: End Create_Offr_Qual;

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

306: -- Parameters
307: --
308: -- IN
309: -- p_api_version_number IN NUMBER Required
310: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
314: --

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

307: --
308: -- IN
309: -- p_api_version_number IN NUMBER Required
310: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
314: --
315: -- OUT

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

308: -- IN
309: -- p_api_version_number IN NUMBER Required
310: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
311: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
312: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
313: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
314: --
315: -- OUT
316: -- x_return_status OUT VARCHAR2

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

328: -- ==============================================================================
329:
330: PROCEDURE Update_Offr_Qual(
331: p_api_version_number IN NUMBER,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
335:
336: x_return_status OUT NOCOPY VARCHAR2,

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

329:
330: PROCEDURE Update_Offr_Qual(
331: p_api_version_number IN NUMBER,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
335:
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,

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

330: PROCEDURE Update_Offr_Qual(
331: p_api_version_number IN NUMBER,
332: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
335:
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_count OUT NOCOPY NUMBER,
338: x_msg_data OUT NOCOPY VARCHAR2,

Line 367: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

363: -- Standard Start of API savepoint
364: SAVEPOINT update_offr_qual_pvt;
365:
366: -- Standard call to check for call compatibility.
367: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
368: p_api_version_number,
369: l_api_name,
370: G_PKG_NAME)
371: THEN

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: p_api_version_number,
369: l_api_name,
370: G_PKG_NAME)
371: THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 377: IF FND_API.to_Boolean( p_init_msg_list )

373: END IF;
374:
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF FND_API.to_Boolean( p_init_msg_list )
378: THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386:
387:
388:
389: -- Initialize API return status to SUCCESS
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391:
392: -- Debug Message
393: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
394:

Line 403: RAISE FND_API.G_EXC_ERROR;

399: If ( c_get_Offr_Qual%NOTFOUND) THEN
400: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
401: p_token_name => 'INFO',
402: p_token_value => 'Offr_Qual') ;
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;
405: -- Debug Message
406: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
407: CLOSE c_get_Offr_Qual;

Line 411: l_tar_ozf_offr_qual_rec.object_version_number = FND_API.G_MISS_NUM ) Then

407: CLOSE c_get_Offr_Qual;
408:
409:
410: If (l_tar_ozf_offr_qual_rec.object_version_number is NULL or
411: l_tar_ozf_offr_qual_rec.object_version_number = FND_API.G_MISS_NUM ) Then
412: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
413: p_token_name => 'COLUMN',
414: p_token_value => 'Last_Update_Date') ;
415: raise FND_API.G_EXC_ERROR;

Line 415: raise FND_API.G_EXC_ERROR;

411: l_tar_ozf_offr_qual_rec.object_version_number = FND_API.G_MISS_NUM ) Then
412: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
413: p_token_name => 'COLUMN',
414: p_token_value => 'Last_Update_Date') ;
415: raise FND_API.G_EXC_ERROR;
416: End if;
417: -- Check Whether record has been changed by someone else
418: If (l_tar_ozf_offr_qual_rec.object_version_number <> l_ref_ozf_offr_qual_rec.object_version_number) Then
419: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 422: raise FND_API.G_EXC_ERROR;

418: If (l_tar_ozf_offr_qual_rec.object_version_number <> l_ref_ozf_offr_qual_rec.object_version_number) Then
419: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
420: p_token_name => 'INFO',
421: p_token_value => 'Offr_Qual') ;
422: raise FND_API.G_EXC_ERROR;
423: End if;
424:
425: ozf_utility_pvt.debug_message('OfferId 1 is :'||p_ozf_offr_qual_rec.offer_id);
426: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

422: raise FND_API.G_EXC_ERROR;
423: End if;
424:
425: ozf_utility_pvt.debug_message('OfferId 1 is :'||p_ozf_offr_qual_rec.offer_id);
426: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
427: THEN
428: -- Debug message
429: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offr_Qual');
430:

Line 434: p_init_msg_list => FND_API.G_FALSE,

430:
431: -- Invoke validation procedures
432: Validate_offr_qual(
433: p_api_version_number => 1.0,
434: p_init_msg_list => FND_API.G_FALSE,
435: p_validation_level => p_validation_level,
436: p_validation_mode => JTF_PLSQL_API.g_update,
437: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
438: x_return_status => x_return_status,

Line 443: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

439: x_msg_count => x_msg_count,
440: x_msg_data => x_msg_data);
441: END IF;
442:
443: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: -- Debug Message

Line 444: RAISE FND_API.G_EXC_ERROR;

440: x_msg_data => x_msg_data);
441: END IF;
442:
443: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: -- Debug Message
448: OZF_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');

Line 488: IF FND_API.to_Boolean( p_commit )

484: -- End of API body.
485: --
486:
487: -- Standard check for p_commit
488: IF FND_API.to_Boolean( p_commit )
489: THEN
490: COMMIT WORK;
491: END IF;
492:

Line 506: x_return_status := FND_API.g_ret_sts_error;

502: );
503: EXCEPTION
504:
505: WHEN OZF_Utility_PVT.resource_locked THEN
506: x_return_status := FND_API.g_ret_sts_error;
507: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
508:
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO UPDATE_Offr_Qual_PVT;

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: WHEN OZF_Utility_PVT.resource_locked THEN
506: x_return_status := FND_API.g_ret_sts_error;
507: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
508:
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO UPDATE_Offr_Qual_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
508:
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO UPDATE_Offr_Qual_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,

Line 514: p_encoded => FND_API.G_FALSE,

510: ROLLBACK TO UPDATE_Offr_Qual_PVT;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );
518:

Line 519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

515: p_count => x_msg_count,
516: p_data => x_msg_data
517: );
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO UPDATE_Offr_Qual_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: );
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO UPDATE_Offr_Qual_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,

Line 524: p_encoded => FND_API.G_FALSE,

520: ROLLBACK TO UPDATE_Offr_Qual_PVT;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
527: );
528:

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: );
528:
529: WHEN OTHERS THEN
530: ROLLBACK TO UPDATE_Offr_Qual_PVT;
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
533: THEN
534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;

Line 538: p_encoded => FND_API.G_FALSE,

534: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
535: END IF;
536: -- Standard call to get message count and if count=1, get the message
537: FND_MSG_PUB.Count_And_Get (
538: p_encoded => FND_API.G_FALSE,
539: p_count => x_msg_count,
540: p_data => x_msg_data
541: );
542: End Update_Offr_Qual;

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

554: -- Parameters
555: --
556: -- IN
557: -- p_api_version_number IN NUMBER Required
558: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
559: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
560: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
561: -- p_qualifier_id IN NUMBER
562: -- p_object_version_number IN NUMBER Optional Default = NULL

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

555: --
556: -- IN
557: -- p_api_version_number IN NUMBER Required
558: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
559: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
560: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
561: -- p_qualifier_id IN NUMBER
562: -- p_object_version_number IN NUMBER Optional Default = NULL
563: --

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

556: -- IN
557: -- p_api_version_number IN NUMBER Required
558: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
559: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
560: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
561: -- p_qualifier_id IN NUMBER
562: -- p_object_version_number IN NUMBER Optional Default = NULL
563: --
564: -- OUT

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

577: -- ==============================================================================
578:
579: PROCEDURE Delete_Offr_Qual(
580: p_api_version_number IN NUMBER,
581: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582: p_commit IN VARCHAR2 := FND_API.G_FALSE,
583: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,

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

578:
579: PROCEDURE Delete_Offr_Qual(
580: p_api_version_number IN NUMBER,
581: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582: p_commit IN VARCHAR2 := FND_API.G_FALSE,
583: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,

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

579: PROCEDURE Delete_Offr_Qual(
580: p_api_version_number IN NUMBER,
581: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
582: p_commit IN VARCHAR2 := FND_API.G_FALSE,
583: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: p_qualifier_id IN NUMBER,

Line 601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

597: -- Standard Start of API savepoint
598: SAVEPOINT delete_offr_qual_pvt;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)
605: THEN

Line 606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)
605: THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 611: IF FND_API.to_Boolean( p_init_msg_list )

607: END IF;
608:
609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean( p_init_msg_list )
612: THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615:

Line 624: x_return_status := FND_API.G_RET_STS_SUCCESS;

620:
621:
622:
623: -- Initialize API return status to SUCCESS
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: --
627: -- Api body
628: --

Line 641: IF FND_API.to_Boolean( p_commit )

637: -- End of API body
638: --
639:
640: -- Standard check for p_commit
641: IF FND_API.to_Boolean( p_commit )
642: THEN
643: COMMIT WORK;
644: END IF;
645:

Line 659: x_return_status := FND_API.g_ret_sts_error;

655: );
656: EXCEPTION
657:
658: WHEN OZF_Utility_PVT.resource_locked THEN
659: x_return_status := FND_API.g_ret_sts_error;
660: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
661:
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO DELETE_Offr_Qual_PVT;

Line 662: WHEN FND_API.G_EXC_ERROR THEN

658: WHEN OZF_Utility_PVT.resource_locked THEN
659: x_return_status := FND_API.g_ret_sts_error;
660: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
661:
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO DELETE_Offr_Qual_PVT;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: -- Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
661:
662: WHEN FND_API.G_EXC_ERROR THEN
663: ROLLBACK TO DELETE_Offr_Qual_PVT;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: -- Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (
667: p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count,

Line 667: p_encoded => FND_API.G_FALSE,

663: ROLLBACK TO DELETE_Offr_Qual_PVT;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: -- Standard call to get message count and if count=1, get the message
666: FND_MSG_PUB.Count_And_Get (
667: p_encoded => FND_API.G_FALSE,
668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:

Line 672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO DELETE_Offr_Qual_PVT;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670: );
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO DELETE_Offr_Qual_PVT;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,

Line 677: p_encoded => FND_API.G_FALSE,

673: ROLLBACK TO DELETE_Offr_Qual_PVT;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681:

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

680: );
681:
682: WHEN OTHERS THEN
683: ROLLBACK TO DELETE_Offr_Qual_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;

Line 691: p_encoded => FND_API.G_FALSE,

687: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
688: END IF;
689: -- Standard call to get message count and if count=1, get the message
690: FND_MSG_PUB.Count_And_Get (
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_msg_count,
693: p_data => x_msg_data
694: );
695: End Delete_Offr_Qual;

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

709: -- Parameters
710: --
711: -- IN
712: -- p_api_version_number IN NUMBER Required
713: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
714: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
715: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
716: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
717: --

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

710: --
711: -- IN
712: -- p_api_version_number IN NUMBER Required
713: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
714: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
715: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
716: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
717: --
718: -- OUT

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

711: -- IN
712: -- p_api_version_number IN NUMBER Required
713: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
714: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
715: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
716: -- p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type Required
717: --
718: -- OUT
719: -- x_return_status OUT VARCHAR2

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

731: -- ==============================================================================
732:
733: PROCEDURE Lock_Offr_Qual(
734: p_api_version_number IN NUMBER,
735: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
736:
737: x_return_status OUT NOCOPY VARCHAR2,
738: x_msg_count OUT NOCOPY NUMBER,
739: x_msg_data OUT NOCOPY VARCHAR2,

Line 758: IF FND_API.to_Boolean( p_init_msg_list )

754: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
755:
756:
757: -- Initialize message list if p_init_msg_list is set to TRUE.
758: IF FND_API.to_Boolean( p_init_msg_list )
759: THEN
760: FND_MSG_PUB.initialize;
761: END IF;
762:

Line 766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

762:
763:
764:
765: -- Standard call to check for call compatibility.
766: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
767: p_api_version_number,
768: l_api_name,
769: G_PKG_NAME)
770: THEN

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: p_api_version_number,
768: l_api_name,
769: G_PKG_NAME)
770: THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773:
774:
775:

Line 777: x_return_status := FND_API.G_RET_STS_SUCCESS;

773:
774:
775:
776: -- Initialize API return status to SUCCESS
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778:
779:
780: ------------------------ lock -------------------------
781: Ozf_Offr_Qual_Pkg.Lock_Row(l_qualifier_id,p_object_version);

Line 786: p_encoded => FND_API.g_false,

782:
783:
784: -------------------- finish --------------------------
785: FND_MSG_PUB.count_and_get(
786: p_encoded => FND_API.g_false,
787: p_count => x_msg_count,
788: p_data => x_msg_data);
789: OZF_Utility_PVT.debug_message(l_full_name ||': end');
790: EXCEPTION

Line 793: x_return_status := FND_API.g_ret_sts_error;

789: OZF_Utility_PVT.debug_message(l_full_name ||': end');
790: EXCEPTION
791:
792: WHEN OZF_Utility_PVT.resource_locked THEN
793: x_return_status := FND_API.g_ret_sts_error;
794: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
795:
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO LOCK_Offr_Qual_PVT;

Line 796: WHEN FND_API.G_EXC_ERROR THEN

792: WHEN OZF_Utility_PVT.resource_locked THEN
793: x_return_status := FND_API.g_ret_sts_error;
794: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
795:
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO LOCK_Offr_Qual_PVT;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (

Line 798: x_return_status := FND_API.G_RET_STS_ERROR;

794: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
795:
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK TO LOCK_Offr_Qual_PVT;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,

Line 801: p_encoded => FND_API.G_FALSE,

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

Line 806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO LOCK_Offr_Qual_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: );
805:
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO LOCK_Offr_Qual_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,

Line 811: p_encoded => FND_API.G_FALSE,

807: ROLLBACK TO LOCK_Offr_Qual_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: -- Standard call to get message count and if count=1, get the message
810: FND_MSG_PUB.Count_And_Get (
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data
814: );
815:

Line 818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

814: );
815:
816: WHEN OTHERS THEN
817: ROLLBACK TO LOCK_Offr_Qual_PVT;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
820: THEN
821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;

Line 825: p_encoded => FND_API.G_FALSE,

821: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
822: END IF;
823: -- Standard call to get message count and if count=1, get the message
824: FND_MSG_PUB.Count_And_Get (
825: p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );
829: End Lock_Offr_Qual;

Line 842: x_return_status := FND_API.g_ret_sts_success;

838: IS
839: l_valid_flag VARCHAR2(1);
840:
841: BEGIN
842: x_return_status := FND_API.g_ret_sts_success;
843: IF p_validation_mode = JTF_PLSQL_API.g_create
844: AND p_ozf_offr_qual_rec.qualifier_id IS NOT NULL
845: THEN
846: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 852: IF l_valid_flag = FND_API.g_false THEN

848: 'qualifier_id = ''' || p_ozf_offr_qual_rec.qualifier_id ||''''
849: );
850: END IF;
851:
852: IF l_valid_flag = FND_API.g_false THEN
853: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_qual_id_DUP');
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856:

Line 854: x_return_status := FND_API.g_ret_sts_error;

850: END IF;
851:
852: IF l_valid_flag = FND_API.g_false THEN
853: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_qual_id_DUP');
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856:
857: END check_Ozf_Offr_Qual_Uk_Items;
858:

Line 868: x_return_status := FND_API.g_ret_sts_success;

864: x_return_status OUT NOCOPY VARCHAR2
865: )
866: IS
867: BEGIN
868: x_return_status := FND_API.g_ret_sts_success;
869:
870: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
871:
872:

Line 873: IF p_ozf_offr_qual_rec.qualifier_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.qualifier_id IS NULL THEN

869:
870: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
871:
872:
873: IF p_ozf_offr_qual_rec.qualifier_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.qualifier_id IS NULL THEN
874: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ID' );
875: x_return_status := FND_API.g_ret_sts_error;
876: END IF;
877:

Line 875: x_return_status := FND_API.g_ret_sts_error;

871:
872:
873: IF p_ozf_offr_qual_rec.qualifier_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.qualifier_id IS NULL THEN
874: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ID' );
875: x_return_status := FND_API.g_ret_sts_error;
876: END IF;
877:
878:
879: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_context IS NULL THEN

Line 879: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_context IS NULL THEN

875: x_return_status := FND_API.g_ret_sts_error;
876: END IF;
877:
878:
879: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_context IS NULL THEN
880: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_CONTEXT' );
881: x_return_status := FND_API.g_ret_sts_error;
882: END IF;
883: */

Line 881: x_return_status := FND_API.g_ret_sts_error;

877:
878:
879: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_context IS NULL THEN
880: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_CONTEXT' );
881: x_return_status := FND_API.g_ret_sts_error;
882: END IF;
883: */
884:
885: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attribute IS NULL THEN

Line 885: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attribute IS NULL THEN

881: x_return_status := FND_API.g_ret_sts_error;
882: END IF;
883: */
884:
885: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attribute IS NULL THEN
886: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTRIBUTE' );
887: x_return_status := FND_API.g_ret_sts_error;
888: END IF;
889:

Line 887: x_return_status := FND_API.g_ret_sts_error;

883: */
884:
885: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attribute IS NULL THEN
886: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTRIBUTE' );
887: x_return_status := FND_API.g_ret_sts_error;
888: END IF;
889:
890: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attr_value IS NULL THEN
891: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTR_VALUE' );

Line 890: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attr_value IS NULL THEN

886: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTRIBUTE' );
887: x_return_status := FND_API.g_ret_sts_error;
888: END IF;
889:
890: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attr_value IS NULL THEN
891: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTR_VALUE' );
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:

Line 892: x_return_status := FND_API.g_ret_sts_error;

888: END IF;
889:
890: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char OR p_ozf_offr_qual_rec.qualifier_attr_value IS NULL THEN
891: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTR_VALUE' );
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:
895:
896: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.offer_id IS NULL THEN

Line 896: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.offer_id IS NULL THEN

892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:
895:
896: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.offer_id IS NULL THEN
897: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
898: x_return_status := FND_API.g_ret_sts_error;
899: END IF;
900:

Line 898: x_return_status := FND_API.g_ret_sts_error;

894:
895:
896: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM OR p_ozf_offr_qual_rec.offer_id IS NULL THEN
897: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
898: x_return_status := FND_API.g_ret_sts_error;
899: END IF;
900:
901:
902: ELSE

Line 905: IF p_ozf_offr_qual_rec.qualifier_id = FND_API.G_MISS_NUM THEN

901:
902: ELSE
903:
904:
905: IF p_ozf_offr_qual_rec.qualifier_id = FND_API.G_MISS_NUM THEN
906: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_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_ozf_offr_qual_rec.qualifier_id = FND_API.G_MISS_NUM THEN
906: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ID' );
907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:
910:
911: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char THEN

Line 911: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char THEN

907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:
910:
911: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char THEN
912: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_CONTEXT' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: */

Line 913: x_return_status := FND_API.g_ret_sts_error;

909:
910:
911: /* IF p_ozf_offr_qual_rec.qualifier_context = FND_API.g_miss_char THEN
912: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_CONTEXT' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: */
916:
917: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char THEN

Line 917: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char THEN

913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: */
916:
917: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char THEN
918: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTRIBUTE' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:

Line 919: x_return_status := FND_API.g_ret_sts_error;

915: */
916:
917: IF p_ozf_offr_qual_rec.qualifier_attribute = FND_API.g_miss_char THEN
918: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTRIBUTE' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:
922: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char THEN
923: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTR_VALUE' );

Line 922: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char THEN

918: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTRIBUTE' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:
922: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char THEN
923: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTR_VALUE' );
924: x_return_status := FND_API.g_ret_sts_error;
925: END IF;
926:

Line 924: x_return_status := FND_API.g_ret_sts_error;

920: END IF;
921:
922: IF p_ozf_offr_qual_rec.qualifier_attr_value = FND_API.g_miss_char THEN
923: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QUALIFIER_ATTR_VALUE' );
924: x_return_status := FND_API.g_ret_sts_error;
925: END IF;
926:
927:
928: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM THEN

Line 928: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM THEN

924: x_return_status := FND_API.g_ret_sts_error;
925: END IF;
926:
927:
928: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM THEN
929: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932: END IF;

Line 930: x_return_status := FND_API.g_ret_sts_error;

926:
927:
928: IF p_ozf_offr_qual_rec.offer_id = FND_API.G_MISS_NUM THEN
929: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932: END IF;
933:
934: END check_ozf_offr_qual_req_items;

Line 945: x_return_status := FND_API.g_ret_sts_success;

941: )
942: IS
943: l_fk_exists VARCHAR2(10);
944: BEGIN
945: x_return_status := FND_API.g_ret_sts_success;
946:
947:
948: l_fk_exists := ozf_utility_pvt.check_fk_exists(
949: p_table_name => 'OZF_OFFERS',

Line 953: IF l_fk_exists = FND_API.g_false THEN

949: p_table_name => 'OZF_OFFERS',
950: p_pk_name => 'OFFER_ID',
951: p_pk_value => p_ozf_offr_qual_rec.offer_id);
952:
953: IF l_fk_exists = FND_API.g_false THEN
954: x_return_status := FND_API.g_ret_sts_error;
955: END IF;
956:
957: -- Enter custom code here

Line 954: x_return_status := FND_API.g_ret_sts_error;

950: p_pk_name => 'OFFER_ID',
951: p_pk_value => p_ozf_offr_qual_rec.offer_id);
952:
953: IF l_fk_exists = FND_API.g_false THEN
954: x_return_status := FND_API.g_ret_sts_error;
955: END IF;
956:
957: -- Enter custom code here
958: END check_ozf_offr_qual_FK_items;

Line 968: x_return_status := FND_API.g_ret_sts_success;

964: x_return_status OUT NOCOPY VARCHAR2
965: )
966: IS
967: BEGIN
968: x_return_status := FND_API.g_ret_sts_success;
969:
970: -- Enter custom code here
971:
972: END check_ozf_offr_qual_Lkp_items;

Line 985: l_return_status := FND_API.g_ret_sts_success;

981: IS
982: l_return_status VARCHAR2(1);
983: BEGIN
984:
985: l_return_status := FND_API.g_ret_sts_success;
986: -- Check Items Uniqueness API calls
987:
988: check_Ozf_Offr_Qual_Uk_Items(
989: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,

Line 992: IF x_return_status <> FND_API.g_ret_sts_success THEN

988: check_Ozf_Offr_Qual_Uk_Items(
989: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
990: p_validation_mode => p_validation_mode,
991: x_return_status => x_return_status);
992: IF x_return_status <> FND_API.g_ret_sts_success THEN
993: l_return_status := FND_API.g_ret_sts_error;
994: END IF;
995:
996: -- Check Items Required/NOT NULL API calls

Line 993: l_return_status := FND_API.g_ret_sts_error;

989: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
990: p_validation_mode => p_validation_mode,
991: x_return_status => x_return_status);
992: IF x_return_status <> FND_API.g_ret_sts_success THEN
993: l_return_status := FND_API.g_ret_sts_error;
994: END IF;
995:
996: -- Check Items Required/NOT NULL API calls
997:

Line 1002: IF x_return_status <> FND_API.g_ret_sts_success THEN

998: check_ozf_offr_qual_req_items(
999: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
1000: p_validation_mode => p_validation_mode,
1001: x_return_status => x_return_status);
1002: IF x_return_status <> FND_API.g_ret_sts_success THEN
1003: l_return_status := FND_API.g_ret_sts_error;
1004: END IF;
1005: -- Check Items Foreign Keys API calls
1006:

Line 1003: l_return_status := FND_API.g_ret_sts_error;

999: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
1000: p_validation_mode => p_validation_mode,
1001: x_return_status => x_return_status);
1002: IF x_return_status <> FND_API.g_ret_sts_success THEN
1003: l_return_status := FND_API.g_ret_sts_error;
1004: END IF;
1005: -- Check Items Foreign Keys API calls
1006:
1007: check_ozf_offr_qual_FK_items(

Line 1010: IF x_return_status <> FND_API.g_ret_sts_success THEN

1006:
1007: check_ozf_offr_qual_FK_items(
1008: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
1009: x_return_status => x_return_status);
1010: IF x_return_status <> FND_API.g_ret_sts_success THEN
1011: l_return_status := FND_API.g_ret_sts_error;
1012: END IF;
1013: -- Check Items Lookups
1014:

Line 1011: l_return_status := FND_API.g_ret_sts_error;

1007: check_ozf_offr_qual_FK_items(
1008: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
1009: x_return_status => x_return_status);
1010: IF x_return_status <> FND_API.g_ret_sts_success THEN
1011: l_return_status := FND_API.g_ret_sts_error;
1012: END IF;
1013: -- Check Items Lookups
1014:
1015: check_ozf_offr_qual_Lkp_items(

Line 1018: IF x_return_status <> FND_API.g_ret_sts_success THEN

1014:
1015: check_ozf_offr_qual_Lkp_items(
1016: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
1017: x_return_status => x_return_status);
1018: IF x_return_status <> FND_API.g_ret_sts_success THEN
1019: l_return_status := FND_API.g_ret_sts_error;
1020: END IF;
1021:
1022: x_return_status := l_return_status;

Line 1019: l_return_status := FND_API.g_ret_sts_error;

1015: check_ozf_offr_qual_Lkp_items(
1016: p_ozf_offr_qual_rec => p_ozf_offr_qual_rec,
1017: x_return_status => x_return_status);
1018: IF x_return_status <> FND_API.g_ret_sts_success THEN
1019: l_return_status := FND_API.g_ret_sts_error;
1020: END IF;
1021:
1022: x_return_status := l_return_status;
1023:

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

1215: l_ozf_offr_qual_rec ozf_offr_qual_rec_type := p_ozf_offr_qual_rec;
1216: BEGIN
1217: -- Developers should put their code to default the record type
1218: -- e.g. IF p_campaign_rec.status_code IS NULL
1219: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1220: -- l_campaign_rec.status_code := 'NEW' ;
1221: -- END IF ;
1222: --
1223: IF p_ozf_offr_qual_rec.active_flag = FND_API.G_MISS_CHAR OR p_ozf_offr_qual_rec.active_flag IS NULL THEN

Line 1223: IF p_ozf_offr_qual_rec.active_flag = FND_API.G_MISS_CHAR OR p_ozf_offr_qual_rec.active_flag IS NULL THEN

1219: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1220: -- l_campaign_rec.status_code := 'NEW' ;
1221: -- END IF ;
1222: --
1223: IF p_ozf_offr_qual_rec.active_flag = FND_API.G_MISS_CHAR OR p_ozf_offr_qual_rec.active_flag IS NULL THEN
1224: x_ozf_offr_qual_rec.active_flag := 'N';
1225: END IF;
1226: NULL ;
1227: END;

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

1230:
1231:
1232: PROCEDURE Validate_Offr_Qual(
1233: p_api_version_number IN NUMBER,
1234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type,
1237: p_validation_mode IN VARCHAR2,
1238: x_return_status OUT NOCOPY VARCHAR2,

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

1231:
1232: PROCEDURE Validate_Offr_Qual(
1233: p_api_version_number IN NUMBER,
1234: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1235: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1236: p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type,
1237: p_validation_mode IN VARCHAR2,
1238: x_return_status OUT NOCOPY VARCHAR2,
1239: x_msg_count OUT NOCOPY NUMBER,

Line 1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1253: -- Debug Message
1254: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1255:
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1258: p_api_version_number,
1259: l_api_name,
1260: G_PKG_NAME)
1261: THEN

Line 1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1258: p_api_version_number,
1259: l_api_name,
1260: G_PKG_NAME)
1261: THEN
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264:
1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1267: IF FND_API.to_Boolean( p_init_msg_list )

1263: END IF;
1264:
1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE.
1267: IF FND_API.to_Boolean( p_init_msg_list )
1268: THEN
1269: FND_MSG_PUB.initialize;
1270: END IF;
1271: l_ozf_offr_qual_rec := p_ozf_offr_qual_rec ;

Line 1282: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1278: p_validation_mode => p_validation_mode,
1279: x_return_status => x_return_status
1280: );
1281:
1282: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1283: RAISE FND_API.G_EXC_ERROR;
1284: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: END IF;

Line 1283: RAISE FND_API.G_EXC_ERROR;

1279: x_return_status => x_return_status
1280: );
1281:
1282: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1283: RAISE FND_API.G_EXC_ERROR;
1284: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: END IF;
1287: END IF;

Line 1284: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1280: );
1281:
1282: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1283: RAISE FND_API.G_EXC_ERROR;
1284: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: END IF;
1287: END IF;
1288:

Line 1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1281:
1282: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1283: RAISE FND_API.G_EXC_ERROR;
1284: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: END IF;
1287: END IF;
1288:
1289:

Line 1294: p_init_msg_list => FND_API.G_FALSE,

1290:
1291: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1292: Validate_ozf_offr_qual_Rec(
1293: p_api_version_number => 1.0,
1294: p_init_msg_list => FND_API.G_FALSE,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,
1298: p_ozf_offr_qual_rec => l_ozf_offr_qual_rec);

Line 1300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,
1298: p_ozf_offr_qual_rec => l_ozf_offr_qual_rec);
1299:
1300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297: x_msg_data => x_msg_data,
1298: p_ozf_offr_qual_rec => l_ozf_offr_qual_rec);
1299:
1300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305: END IF;

Line 1302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1298: p_ozf_offr_qual_rec => l_ozf_offr_qual_rec);
1299:
1300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305: END IF;
1306:

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299:
1300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305: END IF;
1306:
1307: -- Initialize API return status to SUCCESS

Line 1308: x_return_status := FND_API.G_RET_STS_SUCCESS;

1304: END IF;
1305: END IF;
1306:
1307: -- Initialize API return status to SUCCESS
1308: x_return_status := FND_API.G_RET_STS_SUCCESS;
1309:
1310: -- Debug Message
1311: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1312:

Line 1322: x_return_status := FND_API.g_ret_sts_error;

1318: );
1319: EXCEPTION
1320:
1321: WHEN OZF_Utility_PVT.resource_locked THEN
1322: x_return_status := FND_API.g_ret_sts_error;
1323: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1324:
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO validate_offr_qual_Pvt;

Line 1325: WHEN FND_API.G_EXC_ERROR THEN

1321: WHEN OZF_Utility_PVT.resource_locked THEN
1322: x_return_status := FND_API.g_ret_sts_error;
1323: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1324:
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO validate_offr_qual_Pvt;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (

Line 1327: x_return_status := FND_API.G_RET_STS_ERROR;

1323: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1324:
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO validate_offr_qual_Pvt;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,

Line 1330: p_encoded => FND_API.G_FALSE,

1326: ROLLBACK TO validate_offr_qual_Pvt;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: -- Standard call to get message count and if count=1, get the message
1329: FND_MSG_PUB.Count_And_Get (
1330: p_encoded => FND_API.G_FALSE,
1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );
1334:

Line 1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1331: p_count => x_msg_count,
1332: p_data => x_msg_data
1333: );
1334:
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO validate_offr_qual_Pvt;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (

Line 1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1333: );
1334:
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO validate_offr_qual_Pvt;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,

Line 1340: p_encoded => FND_API.G_FALSE,

1336: ROLLBACK TO validate_offr_qual_Pvt;
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: -- Standard call to get message count and if count=1, get the message
1339: FND_MSG_PUB.Count_And_Get (
1340: p_encoded => FND_API.G_FALSE,
1341: p_count => x_msg_count,
1342: p_data => x_msg_data
1343: );
1344:

Line 1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1343: );
1344:
1345: WHEN OTHERS THEN
1346: ROLLBACK TO validate_offr_qual_Pvt;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;

Line 1354: p_encoded => FND_API.G_FALSE,

1350: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1351: END IF;
1352: -- Standard call to get message count and if count=1, get the message
1353: FND_MSG_PUB.Count_And_Get (
1354: p_encoded => FND_API.G_FALSE,
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );
1358: End Validate_Offr_Qual;

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

1359:
1360:
1361: PROCEDURE Validate_ozf_offr_qual_Rec (
1362: p_api_version_number IN NUMBER,
1363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364: x_return_status OUT NOCOPY VARCHAR2,
1365: x_msg_count OUT NOCOPY NUMBER,
1366: x_msg_data OUT NOCOPY VARCHAR2,
1367: p_ozf_offr_qual_rec IN ozf_offr_qual_rec_type

Line 1372: IF FND_API.to_Boolean( p_init_msg_list )

1368: )
1369: IS
1370: BEGIN
1371: -- Initialize message list if p_init_msg_list is set to TRUE.
1372: IF FND_API.to_Boolean( p_init_msg_list )
1373: THEN
1374: FND_MSG_PUB.initialize;
1375: END IF;
1376:

Line 1380: x_return_status := FND_API.G_RET_STS_SUCCESS;

1376:
1377:
1378:
1379: -- Initialize API return status to SUCCESS
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: -- Hint: Validate data
1383: -- If data not valid
1384: -- THEN

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

1381:
1382: -- Hint: Validate data
1383: -- If data not valid
1384: -- THEN
1385: -- x_return_status := FND_API.G_RET_STS_ERROR;
1386:
1387: -- Debug Message
1388: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1389: -- Standard call to get message count and if count is 1, get message info.