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_OFFER_ADJ_TIER_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_offadj_tier_rec IN offadj_tier_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_offadj_tier_rec IN offadj_tier_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_offadj_tier_rec IN offadj_tier_rec_type Required
54: --
55: -- OUT
56: -- x_return_status OUT VARCHAR2

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

68: -- ==============================================================================
69:
70: PROCEDURE Create_Offer_Adj_Tier(
71: p_api_version_number IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75:
76: x_return_status OUT NOCOPY VARCHAR2,

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

69:
70: PROCEDURE Create_Offer_Adj_Tier(
71: p_api_version_number IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75:
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,

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

70: PROCEDURE Create_Offer_Adj_Tier(
71: p_api_version_number IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75:
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_data OUT NOCOPY VARCHAR2,

Line 89: l_org_id NUMBER := FND_API.G_MISS_NUM;

85: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Offer_Adj_Tier';
86: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
87: l_return_status_full VARCHAR2(1);
88: l_object_version_number NUMBER := 1;
89: l_org_id NUMBER := FND_API.G_MISS_NUM;
90: l_offer_adjst_tier_id NUMBER;
91: l_dummy NUMBER;
92: CURSOR c_id IS
93: SELECT ozf_offer_adjustment_tiers_s.NEXTVAL

Line 105: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

101: -- Standard Start of API savepoint
102: SAVEPOINT create_offer_adj_tier_pvt;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
106: p_api_version_number,
107: l_api_name,
108: G_PKG_NAME)
109: THEN

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106: p_api_version_number,
107: l_api_name,
108: G_PKG_NAME)
109: THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113:
114: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 115: IF FND_API.to_Boolean( p_init_msg_list )

111: END IF;
112:
113:
114: -- Initialize message list if p_init_msg_list is set to TRUE.
115: IF FND_API.to_Boolean( p_init_msg_list )
116: THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119:

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124:
125:
126:
127: -- Initialize API return status to SUCCESS
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: -- =========================================================================
131: -- Validate Environment
132: -- =========================================================================

Line 137: RAISE FND_API.G_EXC_ERROR;

133:
134: IF FND_GLOBAL.USER_ID IS NULL
135: THEN
136: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
140:
141:

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

138: END IF;
139:
140:
141:
142: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
143: THEN
144: -- Debug message
145: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Adj_Tier');
146:

Line 150: p_init_msg_list => FND_API.G_FALSE,

146:
147: -- Invoke validation procedures
148: Validate_offer_adj_tier(
149: p_api_version_number => 1.0,
150: p_init_msg_list => FND_API.G_FALSE,
151: p_validation_level => p_validation_level,
152: p_validation_mode => JTF_PLSQL_API.g_create,
153: p_offadj_tier_rec => p_offadj_tier_rec,
154: x_return_status => x_return_status,

Line 159: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data);
157: END IF;
158:
159: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: -- Local variable initialization

Line 160: RAISE FND_API.G_EXC_ERROR;

156: x_msg_data => x_msg_data);
157: END IF;
158:
159: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: -- Local variable initialization
164:

Line 165: IF p_offadj_tier_rec.offer_adjst_tier_id IS NULL OR p_offadj_tier_rec.offer_adjst_tier_id = FND_API.g_miss_num THEN

161: END IF;
162:
163: -- Local variable initialization
164:
165: IF p_offadj_tier_rec.offer_adjst_tier_id IS NULL OR p_offadj_tier_rec.offer_adjst_tier_id = FND_API.g_miss_num THEN
166: LOOP
167: l_dummy := NULL;
168: OPEN c_id;
169: FETCH c_id INTO l_offer_adjst_tier_id;

Line 203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

199: px_object_version_number => l_object_version_number
200: );
201:
202: x_offer_adjst_tier_id := l_offer_adjst_tier_id;
203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: --
207: -- End of API body

Line 204: RAISE FND_API.G_EXC_ERROR;

200: );
201:
202: x_offer_adjst_tier_id := l_offer_adjst_tier_id;
203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: --
207: -- End of API body
208: --

Line 211: IF FND_API.to_Boolean( p_commit )

207: -- End of API body
208: --
209:
210: -- Standard check for p_commit
211: IF FND_API.to_Boolean( p_commit )
212: THEN
213: COMMIT WORK;
214: END IF;
215:

Line 229: x_return_status := FND_API.g_ret_sts_error;

225: );
226: EXCEPTION
227:
228: WHEN OZF_Utility_PVT.resource_locked THEN
229: x_return_status := FND_API.g_ret_sts_error;
230: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;

Line 232: WHEN FND_API.G_EXC_ERROR THEN

228: WHEN OZF_Utility_PVT.resource_locked THEN
229: x_return_status := FND_API.g_ret_sts_error;
230: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
231:
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,

Line 237: p_encoded => FND_API.G_FALSE,

233: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:

Line 242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: -- Standard call to get message count and if count=1, get the message
246: FND_MSG_PUB.Count_And_Get (

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: );
241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: -- Standard call to get message count and if count=1, get the message
246: FND_MSG_PUB.Count_And_Get (
247: p_encoded => FND_API.G_FALSE,
248: p_count => x_msg_count,

Line 247: p_encoded => FND_API.G_FALSE,

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

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: );
251:
252: WHEN OTHERS THEN
253: ROLLBACK TO CREATE_Offer_Adj_Tier_PVT;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
258: END IF;

Line 261: p_encoded => FND_API.G_FALSE,

257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
260: FND_MSG_PUB.Count_And_Get (
261: p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265: End Create_Offer_Adj_Tier;

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

277: -- Parameters
278: --
279: -- IN
280: -- p_api_version_number IN NUMBER Required
281: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
282: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
283: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
284: -- p_offadj_tier_rec IN offadj_tier_rec_type Required
285: --

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

278: --
279: -- IN
280: -- p_api_version_number IN NUMBER Required
281: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
282: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
283: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
284: -- p_offadj_tier_rec IN offadj_tier_rec_type Required
285: --
286: -- OUT

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

279: -- IN
280: -- p_api_version_number IN NUMBER Required
281: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
282: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
283: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
284: -- p_offadj_tier_rec IN offadj_tier_rec_type Required
285: --
286: -- OUT
287: -- x_return_status OUT VARCHAR2

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

299: -- ==============================================================================
300:
301: PROCEDURE Update_Offer_Adj_Tier(
302: p_api_version_number IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306:
307: x_return_status OUT NOCOPY VARCHAR2,

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

300:
301: PROCEDURE Update_Offer_Adj_Tier(
302: p_api_version_number IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306:
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,

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

301: PROCEDURE Update_Offer_Adj_Tier(
302: p_api_version_number IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306:
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,

Line 339: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

335: -- Standard Start of API savepoint
336: SAVEPOINT update_offer_adj_tier_pvt;
337:
338: -- Standard call to check for call compatibility.
339: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
340: p_api_version_number,
341: l_api_name,
342: G_PKG_NAME)
343: THEN

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: p_api_version_number,
341: l_api_name,
342: G_PKG_NAME)
343: THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347:
348: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 349: IF FND_API.to_Boolean( p_init_msg_list )

345: END IF;
346:
347:
348: -- Initialize message list if p_init_msg_list is set to TRUE.
349: IF FND_API.to_Boolean( p_init_msg_list )
350: THEN
351: FND_MSG_PUB.initialize;
352: END IF;
353:

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

358:
359:
360:
361: -- Initialize API return status to SUCCESS
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: -- Debug Message
365: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
366:

Line 375: RAISE FND_API.G_EXC_ERROR;

371: If ( c_get_Offer_Adj_Tier%NOTFOUND) THEN
372: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
373: p_token_name => 'INFO',
374: p_token_value => 'Offer_Adj_Tier') ;
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377: -- Debug Message
378: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
379: CLOSE c_get_Offer_Adj_Tier;

Line 383: l_tar_offadj_tier_rec.object_version_number = FND_API.G_MISS_NUM ) Then

379: CLOSE c_get_Offer_Adj_Tier;
380:
381:
382: If (l_tar_offadj_tier_rec.object_version_number is NULL or
383: l_tar_offadj_tier_rec.object_version_number = FND_API.G_MISS_NUM ) Then
384: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
385: p_token_name => 'COLUMN',
386: p_token_value => 'Last_Update_Date') ;
387: raise FND_API.G_EXC_ERROR;

Line 387: raise FND_API.G_EXC_ERROR;

383: l_tar_offadj_tier_rec.object_version_number = FND_API.G_MISS_NUM ) Then
384: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
385: p_token_name => 'COLUMN',
386: p_token_value => 'Last_Update_Date') ;
387: raise FND_API.G_EXC_ERROR;
388: End if;
389: -- Check Whether record has been changed by someone else
390: If (l_tar_offadj_tier_rec.object_version_number <> l_ref_offadj_tier_rec.object_version_number) Then
391: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 394: raise FND_API.G_EXC_ERROR;

390: If (l_tar_offadj_tier_rec.object_version_number <> l_ref_offadj_tier_rec.object_version_number) Then
391: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
392: p_token_name => 'INFO',
393: p_token_value => 'Offer_Adj_Tier') ;
394: raise FND_API.G_EXC_ERROR;
395: End if;
396:
397:
398: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

394: raise FND_API.G_EXC_ERROR;
395: End if;
396:
397:
398: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
399: THEN
400: -- Debug message
401: OZF_UTILITY_PVT.debug_message('Private API: Validate_Offer_Adj_Tier');
402:

Line 406: p_init_msg_list => FND_API.G_FALSE,

402:
403: -- Invoke validation procedures
404: Validate_offer_adj_tier(
405: p_api_version_number => 1.0,
406: p_init_msg_list => FND_API.G_FALSE,
407: p_validation_level => p_validation_level,
408: p_validation_mode => JTF_PLSQL_API.g_update,
409: p_offadj_tier_rec => p_offadj_tier_rec,
410: x_return_status => x_return_status,

Line 415: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

411: x_msg_count => x_msg_count,
412: x_msg_data => x_msg_data);
413: END IF;
414:
415: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:
419:

Line 416: RAISE FND_API.G_EXC_ERROR;

412: x_msg_data => x_msg_data);
413: END IF;
414:
415: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:
419:
420: -- Debug Message

Line 446: IF FND_API.to_Boolean( p_commit )

442: -- End of API body.
443: --
444:
445: -- Standard check for p_commit
446: IF FND_API.to_Boolean( p_commit )
447: THEN
448: COMMIT WORK;
449: END IF;
450:

Line 464: x_return_status := FND_API.g_ret_sts_error;

460: );
461: EXCEPTION
462:
463: WHEN OZF_Utility_PVT.resource_locked THEN
464: x_return_status := FND_API.g_ret_sts_error;
465: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
466:
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;

Line 467: WHEN FND_API.G_EXC_ERROR THEN

463: WHEN OZF_Utility_PVT.resource_locked THEN
464: x_return_status := FND_API.g_ret_sts_error;
465: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
466:
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
466:
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_msg_count,

Line 472: p_encoded => FND_API.G_FALSE,

468: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: -- Standard call to get message count and if count=1, get the message
471: FND_MSG_PUB.Count_And_Get (
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_msg_count,
474: p_data => x_msg_data
475: );
476:

Line 477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

473: p_count => x_msg_count,
474: p_data => x_msg_data
475: );
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: -- Standard call to get message count and if count=1, get the message
481: FND_MSG_PUB.Count_And_Get (

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

475: );
476:
477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
478: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: -- Standard call to get message count and if count=1, get the message
481: FND_MSG_PUB.Count_And_Get (
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_msg_count,

Line 482: p_encoded => FND_API.G_FALSE,

478: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: -- Standard call to get message count and if count=1, get the message
481: FND_MSG_PUB.Count_And_Get (
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_msg_count,
484: p_data => x_msg_data
485: );
486:

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: );
486:
487: WHEN OTHERS THEN
488: ROLLBACK TO UPDATE_Offer_Adj_Tier_PVT;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;

Line 496: p_encoded => FND_API.G_FALSE,

492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
493: END IF;
494: -- Standard call to get message count and if count=1, get the message
495: FND_MSG_PUB.Count_And_Get (
496: p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500: End Update_Offer_Adj_Tier;

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

512: -- Parameters
513: --
514: -- IN
515: -- p_api_version_number IN NUMBER Required
516: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
517: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
518: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
519: -- p_offer_adjst_tier_id IN NUMBER
520: -- p_object_version_number IN NUMBER Optional Default = NULL

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

513: --
514: -- IN
515: -- p_api_version_number IN NUMBER Required
516: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
517: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
518: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
519: -- p_offer_adjst_tier_id IN NUMBER
520: -- p_object_version_number IN NUMBER Optional Default = NULL
521: --

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

514: -- IN
515: -- p_api_version_number IN NUMBER Required
516: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
517: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
518: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
519: -- p_offer_adjst_tier_id IN NUMBER
520: -- p_object_version_number IN NUMBER Optional Default = NULL
521: --
522: -- OUT

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

535: -- ==============================================================================
536:
537: PROCEDURE Delete_Offer_Adj_Tier(
538: p_api_version_number IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: x_return_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,

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

536:
537: PROCEDURE Delete_Offer_Adj_Tier(
538: p_api_version_number IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: x_return_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2,

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

537: PROCEDURE Delete_Offer_Adj_Tier(
538: p_api_version_number IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_commit IN VARCHAR2 := FND_API.G_FALSE,
541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542: x_return_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2,
545: p_offer_adjst_tier_id IN NUMBER,

Line 559: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

555: -- Standard Start of API savepoint
556: SAVEPOINT delete_offer_adj_tier_pvt;
557:
558: -- Standard call to check for call compatibility.
559: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
560: p_api_version_number,
561: l_api_name,
562: G_PKG_NAME)
563: THEN

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: p_api_version_number,
561: l_api_name,
562: G_PKG_NAME)
563: THEN
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;
566:
567:
568: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 569: IF FND_API.to_Boolean( p_init_msg_list )

565: END IF;
566:
567:
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569: IF FND_API.to_Boolean( p_init_msg_list )
570: THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578:
579:
580:
581: -- Initialize API return status to SUCCESS
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: --
585: -- Api body
586: --

Line 599: IF FND_API.to_Boolean( p_commit )

595: -- End of API body
596: --
597:
598: -- Standard check for p_commit
599: IF FND_API.to_Boolean( p_commit )
600: THEN
601: COMMIT WORK;
602: END IF;
603:

Line 617: x_return_status := FND_API.g_ret_sts_error;

613: );
614: EXCEPTION
615:
616: WHEN OZF_Utility_PVT.resource_locked THEN
617: x_return_status := FND_API.g_ret_sts_error;
618: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
619:
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;

Line 620: WHEN FND_API.G_EXC_ERROR THEN

616: WHEN OZF_Utility_PVT.resource_locked THEN
617: x_return_status := FND_API.g_ret_sts_error;
618: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
619:
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: -- Standard call to get message count and if count=1, get the message
624: FND_MSG_PUB.Count_And_Get (

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
619:
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: -- Standard call to get message count and if count=1, get the message
624: FND_MSG_PUB.Count_And_Get (
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,

Line 625: p_encoded => FND_API.G_FALSE,

621: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: -- Standard call to get message count and if count=1, get the message
624: FND_MSG_PUB.Count_And_Get (
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data
628: );
629:

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: p_count => x_msg_count,
627: p_data => x_msg_data
628: );
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: );
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,

Line 635: p_encoded => FND_API.G_FALSE,

631: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
639:

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638: );
639:
640: WHEN OTHERS THEN
641: ROLLBACK TO DELETE_Offer_Adj_Tier_PVT;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
644: THEN
645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
646: END IF;

Line 649: p_encoded => FND_API.G_FALSE,

645: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
646: END IF;
647: -- Standard call to get message count and if count=1, get the message
648: FND_MSG_PUB.Count_And_Get (
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data
652: );
653: End Delete_Offer_Adj_Tier;

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

667: -- Parameters
668: --
669: -- IN
670: -- p_api_version_number IN NUMBER Required
671: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
672: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
673: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_offadj_tier_rec IN offadj_tier_rec_type Required
675: --

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

668: --
669: -- IN
670: -- p_api_version_number IN NUMBER Required
671: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
672: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
673: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_offadj_tier_rec IN offadj_tier_rec_type Required
675: --
676: -- OUT

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

669: -- IN
670: -- p_api_version_number IN NUMBER Required
671: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
672: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
673: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
674: -- p_offadj_tier_rec IN offadj_tier_rec_type Required
675: --
676: -- OUT
677: -- x_return_status OUT VARCHAR2

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

689: -- ==============================================================================
690:
691: PROCEDURE Lock_Offer_Adj_Tier(
692: p_api_version_number IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
694:
695: x_return_status OUT NOCOPY VARCHAR2,
696: x_msg_count OUT NOCOPY NUMBER,
697: x_msg_data OUT NOCOPY VARCHAR2,

Line 716: IF FND_API.to_Boolean( p_init_msg_list )

712: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
713:
714:
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list )
717: THEN
718: FND_MSG_PUB.initialize;
719: END IF;
720:

Line 724: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

720:
721:
722:
723: -- Standard call to check for call compatibility.
724: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
725: p_api_version_number,
726: l_api_name,
727: G_PKG_NAME)
728: THEN

Line 729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

725: p_api_version_number,
726: l_api_name,
727: G_PKG_NAME)
728: THEN
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732:
733:

Line 735: x_return_status := FND_API.G_RET_STS_SUCCESS;

731:
732:
733:
734: -- Initialize API return status to SUCCESS
735: x_return_status := FND_API.G_RET_STS_SUCCESS;
736:
737:
738: ------------------------ lock -------------------------
739: OZF_Offer_Adj_Tier_PKG.Lock_Row(l_offer_adjst_tier_id,p_object_version);

Line 744: p_encoded => FND_API.g_false,

740:
741:
742: -------------------- finish --------------------------
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,
745: p_count => x_msg_count,
746: p_data => x_msg_data);
747: OZF_Utility_PVT.debug_message(l_full_name ||': end');
748: EXCEPTION

Line 751: x_return_status := FND_API.g_ret_sts_error;

747: OZF_Utility_PVT.debug_message(l_full_name ||': end');
748: EXCEPTION
749:
750: WHEN OZF_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;

Line 754: WHEN FND_API.G_EXC_ERROR THEN

750: WHEN OZF_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,

Line 759: p_encoded => FND_API.G_FALSE,

755: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

762: );
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,

Line 769: p_encoded => FND_API.G_FALSE,

765: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data
772: );
773:

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: );
773:
774: WHEN OTHERS THEN
775: ROLLBACK TO LOCK_Offer_Adj_Tier_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;

Line 783: p_encoded => FND_API.G_FALSE,

779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787: End Lock_Offer_Adj_Tier;

Line 800: x_return_status := FND_API.g_ret_sts_success;

796: IS
797: l_valid_flag VARCHAR2(1);
798:
799: BEGIN
800: x_return_status := FND_API.g_ret_sts_success;
801: IF p_validation_mode = JTF_PLSQL_API.g_create
802: AND p_offadj_tier_rec.offer_adjst_tier_id IS NOT NULL
803: THEN
804: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 810: IF l_valid_flag = FND_API.g_false THEN

806: 'offer_adjst_tier_id = ''' || p_offadj_tier_rec.offer_adjst_tier_id ||''''
807: );
808: END IF;
809:
810: IF l_valid_flag = FND_API.g_false THEN
811: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_TIER_ID_DUP');
812: x_return_status := FND_API.g_ret_sts_error;
813: END IF;
814:

Line 812: x_return_status := FND_API.g_ret_sts_error;

808: END IF;
809:
810: IF l_valid_flag = FND_API.g_false THEN
811: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_TIER_ID_DUP');
812: x_return_status := FND_API.g_ret_sts_error;
813: END IF;
814:
815: END check_Offadj_Tier_Uk_Items;
816:

Line 826: x_return_status := FND_API.g_ret_sts_success;

822: x_return_status OUT NOCOPY VARCHAR2
823: )
824: IS
825: BEGIN
826: x_return_status := FND_API.g_ret_sts_success;
827:
828: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
829:
830: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.offer_adjustment_id IS NULL THEN

Line 830: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.offer_adjustment_id IS NULL THEN

826: x_return_status := FND_API.g_ret_sts_success;
827:
828: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
829:
830: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.offer_adjustment_id IS NULL THEN
831: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
832: x_return_status := FND_API.g_ret_sts_error;
833: return;
834: END IF;

Line 832: x_return_status := FND_API.g_ret_sts_error;

828: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
829:
830: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.offer_adjustment_id IS NULL THEN
831: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
832: x_return_status := FND_API.g_ret_sts_error;
833: return;
834: END IF;
835:
836: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.qp_list_header_id IS NULL THEN

Line 836: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.qp_list_header_id IS NULL THEN

832: x_return_status := FND_API.g_ret_sts_error;
833: return;
834: END IF;
835:
836: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.qp_list_header_id IS NULL THEN
837: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
838: x_return_status := FND_API.g_ret_sts_error;
839: return;
840: END IF;

Line 838: x_return_status := FND_API.g_ret_sts_error;

834: END IF;
835:
836: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM OR p_offadj_tier_rec.qp_list_header_id IS NULL THEN
837: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
838: x_return_status := FND_API.g_ret_sts_error;
839: return;
840: END IF;
841:
842: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_tier_rec.modified_discount IS NULL THEN

Line 842: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_tier_rec.modified_discount IS NULL THEN

838: x_return_status := FND_API.g_ret_sts_error;
839: return;
840: END IF;
841:
842: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_tier_rec.modified_discount IS NULL THEN
843: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
844: x_return_status := FND_API.g_ret_sts_error;
845: return;
846: END IF;

Line 844: x_return_status := FND_API.g_ret_sts_error;

840: END IF;
841:
842: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_tier_rec.modified_discount IS NULL THEN
843: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
844: x_return_status := FND_API.g_ret_sts_error;
845: return;
846: END IF;
847:
848: ozf_utility_pvt.debug_message('OfferDiscountLineId is : '||p_offadj_tier_rec.offer_discount_line_id);

Line 849: IF p_offadj_tier_rec.offer_discount_line_id IS NULL OR p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

845: return;
846: END IF;
847:
848: ozf_utility_pvt.debug_message('OfferDiscountLineId is : '||p_offadj_tier_rec.offer_discount_line_id);
849: IF p_offadj_tier_rec.offer_discount_line_id IS NULL OR p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
850: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
851: x_return_status := FND_API.g_ret_sts_error;
852: return;
853: END IF;

Line 851: x_return_status := FND_API.g_ret_sts_error;

847:
848: ozf_utility_pvt.debug_message('OfferDiscountLineId is : '||p_offadj_tier_rec.offer_discount_line_id);
849: IF p_offadj_tier_rec.offer_discount_line_id IS NULL OR p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
850: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
851: x_return_status := FND_API.g_ret_sts_error;
852: return;
853: END IF;
854:
855: ELSE

Line 858: IF p_offadj_tier_rec.offer_adjst_tier_id = FND_API.G_MISS_NUM THEN

854:
855: ELSE
856:
857:
858: IF p_offadj_tier_rec.offer_adjst_tier_id = FND_API.G_MISS_NUM THEN
859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJST_TIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:

Line 860: x_return_status := FND_API.g_ret_sts_error;

856:
857:
858: IF p_offadj_tier_rec.offer_adjst_tier_id = FND_API.G_MISS_NUM THEN
859: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJST_TIER_ID' );
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863:
864: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN

Line 864: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN

860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862:
863:
864: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
865: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:

Line 866: x_return_status := FND_API.g_ret_sts_error;

862:
863:
864: IF p_offadj_tier_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
865: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM THEN
870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );

Line 869: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM THEN

865: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM THEN
870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873:

Line 871: x_return_status := FND_API.g_ret_sts_error;

867: END IF;
868:
869: IF p_offadj_tier_rec.qp_list_header_id = FND_API.G_MISS_NUM THEN
870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873:
874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );

Line 874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN

870: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'QP_LIST_HEADER_ID' );
871: x_return_status := FND_API.g_ret_sts_error;
872: END IF;
873:
874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

Line 876: x_return_status := FND_API.g_ret_sts_error;

872: END IF;
873:
874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
879: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_DISCOUNT_LINE_ID');
880: x_return_status := FND_API.g_ret_sts_error;

Line 878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

874: IF p_offadj_tier_rec.modified_discount = FND_API.G_MISS_NUM THEN
875: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
879: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_DISCOUNT_LINE_ID');
880: x_return_status := FND_API.g_ret_sts_error;
881: return;
882: END IF;

Line 880: x_return_status := FND_API.g_ret_sts_error;

876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: IF p_offadj_tier_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
879: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFFER_DISCOUNT_LINE_ID');
880: x_return_status := FND_API.g_ret_sts_error;
881: return;
882: END IF;
883:
884: END IF;

Line 896: x_return_status := FND_API.g_ret_sts_success;

892: x_return_status OUT NOCOPY VARCHAR2
893: )
894: IS
895: BEGIN
896: x_return_status := FND_API.g_ret_sts_success;
897:
898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');

Line 898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN

894: IS
895: BEGIN
896: x_return_status := FND_API.g_ret_sts_success;
897:
898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');
901: x_return_status := FND_API.g_ret_sts_error;
902: return;

Line 899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN

895: BEGIN
896: x_return_status := FND_API.g_ret_sts_success;
897:
898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');
901: x_return_status := FND_API.g_ret_sts_error;
902: return;
903: END IF;

Line 901: x_return_status := FND_API.g_ret_sts_error;

897:
898: IF p_offadj_tier_rec.offer_discount_line_id IS NOT NULL AND p_offadj_tier_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
899: IF OZF_UTILITY_PVT.CHECK_FK_EXISTS('ozf_offer_discount_lines', 'offer_discount_line_id' , to_char(p_offadj_tier_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
900: OZF_Utility_PVT.Error_Message('OZF_OFF_ADJ_TIER_INV_DISC');
901: x_return_status := FND_API.g_ret_sts_error;
902: return;
903: END IF;
904: END IF;
905: -- Enter custom code here

Line 917: x_return_status := FND_API.g_ret_sts_success;

913: x_return_status OUT NOCOPY VARCHAR2
914: )
915: IS
916: BEGIN
917: x_return_status := FND_API.g_ret_sts_success;
918:
919: -- Enter custom code here
920:
921: END check_Offadj_Tier_Lookup_Items;

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927: , x_return_status OUT NOCOPY VARCHAR2
928: )
929: IS
930: BEGIN
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932: END check_offadj_attr;
933:
934: PROCEDURE check_offadj_inter_attr
935: (

Line 942: x_return_status := FND_API.G_RET_STS_SUCCESS;

938: , x_return_status OUT NOCOPY VARCHAR2
939: )
940: IS
941: BEGIN
942: x_return_status := FND_API.G_RET_STS_SUCCESS;
943: IF
944: (p_offadj_tier_rec.modified_discount > 0 AND p_offadj_tier_rec.original_discount < 0)
945: OR
946: (p_offadj_tier_rec.modified_discount < 0 AND p_offadj_tier_rec.original_discount > 0)

Line 949: x_return_status := FND_API.g_ret_sts_error;

945: OR
946: (p_offadj_tier_rec.modified_discount < 0 AND p_offadj_tier_rec.original_discount > 0)
947: THEN
948: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');
949: x_return_status := FND_API.g_ret_sts_error;
950: return;
951: END IF;
952: END check_offadj_inter_attr;
953:

Line 964: l_return_status := FND_API.g_ret_sts_success;

960: IS
961: l_return_status VARCHAR2(1);
962: BEGIN
963:
964: l_return_status := FND_API.g_ret_sts_success;
965: -- Check Items Uniqueness API calls
966:
967: check_Offadj_tier_Uk_Items(
968: p_offadj_tier_rec => p_offadj_tier_rec,

Line 971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

967: check_Offadj_tier_Uk_Items(
968: p_offadj_tier_rec => p_offadj_tier_rec,
969: p_validation_mode => p_validation_mode,
970: x_return_status => x_return_status);
971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END IF;

Line 972: RAISE FND_API.G_EXC_ERROR;

968: p_offadj_tier_rec => p_offadj_tier_rec,
969: p_validation_mode => p_validation_mode,
970: x_return_status => x_return_status);
971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END IF;
976:

Line 973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

969: p_validation_mode => p_validation_mode,
970: x_return_status => x_return_status);
971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END IF;
976:
977: -- Check Items Required/NOT NULL API calls

Line 974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

970: x_return_status => x_return_status);
971: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975: END IF;
976:
977: -- Check Items Required/NOT NULL API calls
978:

Line 983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

979: check_offadj_tier_req_items(
980: p_offadj_tier_rec => p_offadj_tier_rec,
981: p_validation_mode => p_validation_mode,
982: x_return_status => x_return_status);
983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
984: RAISE FND_API.G_EXC_ERROR;
985: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;

Line 984: RAISE FND_API.G_EXC_ERROR;

980: p_offadj_tier_rec => p_offadj_tier_rec,
981: p_validation_mode => p_validation_mode,
982: x_return_status => x_return_status);
983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
984: RAISE FND_API.G_EXC_ERROR;
985: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988: -- Check Items Foreign Keys API calls

Line 985: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

981: p_validation_mode => p_validation_mode,
982: x_return_status => x_return_status);
983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
984: RAISE FND_API.G_EXC_ERROR;
985: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988: -- Check Items Foreign Keys API calls
989:

Line 986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

982: x_return_status => x_return_status);
983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
984: RAISE FND_API.G_EXC_ERROR;
985: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
987: END IF;
988: -- Check Items Foreign Keys API calls
989:
990: check_offadj_tier_FK_items(

Line 993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

989:
990: check_offadj_tier_FK_items(
991: p_offadj_tier_rec => p_offadj_tier_rec,
992: x_return_status => x_return_status);
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF; -- Check Items Lookups

Line 994: RAISE FND_API.G_EXC_ERROR;

990: check_offadj_tier_FK_items(
991: p_offadj_tier_rec => p_offadj_tier_rec,
992: x_return_status => x_return_status);
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF; -- Check Items Lookups
998:

Line 995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

991: p_offadj_tier_rec => p_offadj_tier_rec,
992: x_return_status => x_return_status);
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF; -- Check Items Lookups
998:
999: check_offadj_tier_Lookup_items(

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: x_return_status => x_return_status);
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF; -- Check Items Lookups
998:
999: check_offadj_tier_Lookup_items(
1000: p_offadj_tier_rec => p_offadj_tier_rec,

Line 1002: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

998:
999: check_offadj_tier_Lookup_items(
1000: p_offadj_tier_rec => p_offadj_tier_rec,
1001: x_return_status => x_return_status);
1002: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: check_offadj_tier_Lookup_items(
1000: p_offadj_tier_rec => p_offadj_tier_rec,
1001: x_return_status => x_return_status);
1002: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:

Line 1004: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1000: p_offadj_tier_rec => p_offadj_tier_rec,
1001: x_return_status => x_return_status);
1002: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008:

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: x_return_status => x_return_status);
1002: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007:
1008:
1009: check_offadj_attr

Line 1015: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1011: p_offadj_tier_rec => p_offadj_tier_rec
1012: , p_validation_mode => p_validation_mode
1013: , x_return_status => x_return_status
1014: );
1015: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;

Line 1016: RAISE FND_API.G_EXC_ERROR;

1012: , p_validation_mode => p_validation_mode
1013: , x_return_status => x_return_status
1014: );
1015: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:

Line 1017: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1013: , x_return_status => x_return_status
1014: );
1015: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: check_offadj_inter_attr

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: );
1015: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020:
1021: check_offadj_inter_attr
1022: (

Line 1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1023: p_offadj_tier_rec => p_offadj_tier_rec
1024: , p_validation_mode => p_validation_mode
1025: , x_return_status => x_return_status
1026: );
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;

Line 1028: RAISE FND_API.G_EXC_ERROR;

1024: , p_validation_mode => p_validation_mode
1025: , x_return_status => x_return_status
1026: );
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:

Line 1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1025: , x_return_status => x_return_status
1026: );
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:
1033: END Check_offadj_tier_Items;

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: );
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:
1033: END Check_offadj_tier_Items;
1034:

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

1132: l_offadj_tier_rec offadj_tier_rec_type := p_offadj_tier_rec;
1133: BEGIN
1134: -- Developers should put their code to default the record type
1135: -- e.g. IF p_campaign_rec.status_code IS NULL
1136: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1137: -- l_campaign_rec.status_code := 'NEW' ;
1138: -- END IF ;
1139: --
1140: NULL ;

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

1144:
1145:
1146: PROCEDURE Validate_Offer_Adj_Tier(
1147: p_api_version_number IN NUMBER,
1148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1150: p_offadj_tier_rec IN offadj_tier_rec_type,
1151: p_validation_mode IN VARCHAR2,
1152: x_return_status OUT NOCOPY VARCHAR2,

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

1145:
1146: PROCEDURE Validate_Offer_Adj_Tier(
1147: p_api_version_number IN NUMBER,
1148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1149: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1150: p_offadj_tier_rec IN offadj_tier_rec_type,
1151: p_validation_mode IN VARCHAR2,
1152: x_return_status OUT NOCOPY VARCHAR2,
1153: x_msg_count OUT NOCOPY NUMBER,

Line 1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1163: -- Standard Start of API savepoint
1164: SAVEPOINT validate_offer_adj_tier_;
1165:
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1168: p_api_version_number,
1169: l_api_name,
1170: G_PKG_NAME)
1171: THEN

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: p_api_version_number,
1169: l_api_name,
1170: G_PKG_NAME)
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174:
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1177: IF FND_API.to_Boolean( p_init_msg_list )

1173: END IF;
1174:
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.
1177: IF FND_API.to_Boolean( p_init_msg_list )
1178: THEN
1179: FND_MSG_PUB.initialize;
1180: END IF;
1181:

Line 1190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1186: p_validation_mode => p_validation_mode,
1187: x_return_status => x_return_status
1188: );
1189:
1190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: x_return_status => x_return_status
1188: );
1189:
1190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;

Line 1192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1188: );
1189:
1190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;
1196:

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189:
1190: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;
1196:
1197: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1211: p_init_msg_list => FND_API.G_FALSE,

1207:
1208: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1209: Validate_offadj_tier_Rec(
1210: p_api_version_number => 1.0,
1211: p_init_msg_list => FND_API.G_FALSE,
1212: x_return_status => x_return_status,
1213: x_msg_count => x_msg_count,
1214: x_msg_data => x_msg_data,
1215: p_offadj_tier_rec => l_offadj_tier_rec);

Line 1217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1213: x_msg_count => x_msg_count,
1214: x_msg_data => x_msg_data,
1215: p_offadj_tier_rec => l_offadj_tier_rec);
1216:
1217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;

Line 1218: RAISE FND_API.G_EXC_ERROR;

1214: x_msg_data => x_msg_data,
1215: p_offadj_tier_rec => l_offadj_tier_rec);
1216:
1217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222: END IF;

Line 1219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1215: p_offadj_tier_rec => l_offadj_tier_rec);
1216:
1217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222: END IF;
1223:

Line 1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1216:
1217: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222: END IF;
1223:
1224:

Line 1231: x_return_status := FND_API.G_RET_STS_SUCCESS;

1227:
1228:
1229:
1230: -- Initialize API return status to SUCCESS
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:
1233:
1234: -- Debug Message
1235: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 1246: x_return_status := FND_API.g_ret_sts_error;

1242: );
1243: EXCEPTION
1244:
1245: WHEN OZF_Utility_PVT.resource_locked THEN
1246: x_return_status := FND_API.g_ret_sts_error;
1247: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;

Line 1249: WHEN FND_API.G_EXC_ERROR THEN

1245: WHEN OZF_Utility_PVT.resource_locked THEN
1246: x_return_status := FND_API.g_ret_sts_error;
1247: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: -- Standard call to get message count and if count=1, get the message
1253: FND_MSG_PUB.Count_And_Get (

Line 1251: x_return_status := FND_API.G_RET_STS_ERROR;

1247: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: -- Standard call to get message count and if count=1, get the message
1253: FND_MSG_PUB.Count_And_Get (
1254: p_encoded => FND_API.G_FALSE,
1255: p_count => x_msg_count,

Line 1254: p_encoded => FND_API.G_FALSE,

1250: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: -- Standard call to get message count and if count=1, get the message
1253: FND_MSG_PUB.Count_And_Get (
1254: p_encoded => FND_API.G_FALSE,
1255: p_count => x_msg_count,
1256: p_data => x_msg_data
1257: );
1258:

Line 1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1255: p_count => x_msg_count,
1256: p_data => x_msg_data
1257: );
1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: -- Standard call to get message count and if count=1, get the message
1263: FND_MSG_PUB.Count_And_Get (

Line 1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1257: );
1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: -- Standard call to get message count and if count=1, get the message
1263: FND_MSG_PUB.Count_And_Get (
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,

Line 1264: p_encoded => FND_API.G_FALSE,

1260: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: -- Standard call to get message count and if count=1, get the message
1263: FND_MSG_PUB.Count_And_Get (
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268:

Line 1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1267: );
1268:
1269: WHEN OTHERS THEN
1270: ROLLBACK TO VALIDATE_Offer_Adj_Tier_;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1273: THEN
1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;

Line 1278: p_encoded => FND_API.G_FALSE,

1274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1275: END IF;
1276: -- Standard call to get message count and if count=1, get the message
1277: FND_MSG_PUB.Count_And_Get (
1278: p_encoded => FND_API.G_FALSE,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data
1281: );
1282: End Validate_Offer_Adj_Tier;

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

1283:
1284:
1285: PROCEDURE Validate_Offadj_Tier_Rec (
1286: p_api_version_number IN NUMBER,
1287: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1288: x_return_status OUT NOCOPY VARCHAR2,
1289: x_msg_count OUT NOCOPY NUMBER,
1290: x_msg_data OUT NOCOPY VARCHAR2,
1291: p_offadj_tier_rec IN offadj_tier_rec_type

Line 1296: IF FND_API.to_Boolean( p_init_msg_list )

1292: )
1293: IS
1294: BEGIN
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list )
1297: THEN
1298: FND_MSG_PUB.initialize;
1299: END IF;
1300:

Line 1304: x_return_status := FND_API.G_RET_STS_SUCCESS;

1300:
1301:
1302:
1303: -- Initialize API return status to SUCCESS
1304: x_return_status := FND_API.G_RET_STS_SUCCESS;
1305:
1306: -- Hint: Validate data
1307: -- If data not valid
1308: -- THEN

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

1305:
1306: -- Hint: Validate data
1307: -- If data not valid
1308: -- THEN
1309: -- x_return_status := FND_API.G_RET_STS_ERROR;
1310:
1311: -- Debug Message
1312: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1313: -- Standard call to get message count and if count is 1, get message info.