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

Line 112: RAISE Fnd_Api.g_exc_error;

108: p_event_key => l_item_key,
109: p_parameters => l_parameter_list);
110: EXCEPTION
111: WHEN OTHERS THEN
112: RAISE Fnd_Api.g_exc_error;
113: OZF_Offer_Adj_Line_PVT.debug_message('Exception in raising business event');
114: END;
115:
116: -- Hint: Primary key needs to be returned.

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

126: -- Parameters
127: --
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_offer_adj_rec IN offer_adj_rec_type Required
134: --

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

127: --
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_offer_adj_rec IN offer_adj_rec_type Required
134: --
135: -- OUT

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

128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_offer_adj_rec IN offer_adj_rec_type Required
134: --
135: -- OUT
136: -- x_return_status OUT VARCHAR2

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

148: -- ==============================================================================
149:
150: PROCEDURE Create_Offer_Adjustment(
151: p_api_version_number IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155:
156: x_return_status OUT NOCOPY VARCHAR2,

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

149:
150: PROCEDURE Create_Offer_Adjustment(
151: p_api_version_number IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155:
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,

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

150: PROCEDURE Create_Offer_Adjustment(
151: p_api_version_number IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155:
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,

Line 169: l_org_id NUMBER := FND_API.G_MISS_NUM;

165: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Offer_Adjustment';
166: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
167: l_return_status_full VARCHAR2(1);
168: l_object_version_number NUMBER := 1;
169: l_org_id NUMBER := FND_API.G_MISS_NUM;
170: l_offer_adjustment_id NUMBER;
171: l_dummy NUMBER;
172: CURSOR c_id IS
173: SELECT ozf_offer_adjustments_b_s.NEXTVAL

Line 185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

181: -- Standard Start of API savepoint
182: SAVEPOINT create_offer_adjustment_pvt;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
186: p_api_version_number,
187: l_api_name,
188: G_PKG_NAME)
189: THEN

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: p_api_version_number,
187: l_api_name,
188: G_PKG_NAME)
189: THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 195: IF FND_API.to_Boolean( p_init_msg_list )

191: END IF;
192:
193:
194: -- Initialize message list if p_init_msg_list is set to TRUE.
195: IF FND_API.to_Boolean( p_init_msg_list )
196: THEN
197: FND_MSG_PUB.initialize;
198: END IF;
199:

Line 208: x_return_status := FND_API.G_RET_STS_SUCCESS;

204:
205:
206:
207: -- Initialize API return status to SUCCESS
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209:
210: -- Local variable initialization
211:
212: IF p_offer_adj_rec.offer_adjustment_id IS NULL OR p_offer_adj_rec.offer_adjustment_id = FND_API.g_miss_num THEN

Line 212: IF p_offer_adj_rec.offer_adjustment_id IS NULL OR p_offer_adj_rec.offer_adjustment_id = FND_API.g_miss_num THEN

208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209:
210: -- Local variable initialization
211:
212: IF p_offer_adj_rec.offer_adjustment_id IS NULL OR p_offer_adj_rec.offer_adjustment_id = FND_API.g_miss_num THEN
213: LOOP
214: l_dummy := NULL;
215: OPEN c_id;
216: FETCH c_id INTO l_offer_adjustment_id;

Line 237: RAISE FND_API.G_EXC_ERROR;

233:
234: IF FND_GLOBAL.USER_ID IS NULL
235: THEN
236: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240:
241:

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

238: END IF;
239:
240:
241:
242: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
243: THEN
244: -- Debug message
245: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_Offer_Adjustment');
246:

Line 250: p_init_msg_list => FND_API.G_FALSE,

246:
247: -- Invoke validation procedures
248: Validate_offer_adjustment(
249: p_api_version_number => 1.0,
250: p_init_msg_list => FND_API.G_FALSE,
251: p_validation_level => p_validation_level,
252: p_validation_mode => JTF_PLSQL_API.g_create,
253: p_offer_adj_rec => p_offer_adj_rec,
254: x_return_status => x_return_status,

Line 259: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

255: x_msg_count => x_msg_count,
256: x_msg_data => x_msg_data);
257: END IF;
258:
259: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:
263:

Line 260: RAISE FND_API.G_EXC_ERROR;

256: x_msg_data => x_msg_data);
257: END IF;
258:
259: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:
263:
264: -- Debug Message

Line 303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

299: p_description => p_offer_adj_rec.description
300: );
301:
302: x_offer_adjustment_id := l_offer_adjustment_id;
303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306: --
307: -- End of API body

Line 304: RAISE FND_API.G_EXC_ERROR;

300: );
301:
302: x_offer_adjustment_id := l_offer_adjustment_id;
303: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306: --
307: -- End of API body
308: --

Line 311: IF FND_API.to_Boolean( p_commit )

307: -- End of API body
308: --
309:
310: -- Standard check for p_commit
311: IF FND_API.to_Boolean( p_commit )
312: THEN
313: -- OZF_Offer_Adj_Line_PVT.debug_message('Problemo hereo: ');
314: -- RAISE FND_API.G_EXC_ERROR;
315: COMMIT WORK;

Line 314: -- RAISE FND_API.G_EXC_ERROR;

310: -- Standard check for p_commit
311: IF FND_API.to_Boolean( p_commit )
312: THEN
313: -- OZF_Offer_Adj_Line_PVT.debug_message('Problemo hereo: ');
314: -- RAISE FND_API.G_EXC_ERROR;
315: COMMIT WORK;
316: END IF;
317:
318:

Line 331: x_return_status := FND_API.g_ret_sts_error;

327: );
328: EXCEPTION
329:
330: WHEN OZF_Utility_PVT.resource_locked THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
333:
334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO CREATE_Offer_Adjustment_PVT;

Line 334: WHEN FND_API.G_EXC_ERROR THEN

330: WHEN OZF_Utility_PVT.resource_locked THEN
331: x_return_status := FND_API.g_ret_sts_error;
332: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
333:
334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: -- Standard call to get message count and if count=1, get the message
338: FND_MSG_PUB.Count_And_Get (

Line 336: x_return_status := FND_API.G_RET_STS_ERROR;

332: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
333:
334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: -- Standard call to get message count and if count=1, get the message
338: FND_MSG_PUB.Count_And_Get (
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,

Line 339: p_encoded => FND_API.G_FALSE,

335: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: -- Standard call to get message count and if count=1, get the message
338: FND_MSG_PUB.Count_And_Get (
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data
342: );
343:

Line 344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

340: p_count => x_msg_count,
341: p_data => x_msg_data
342: );
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: );
343:
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,

Line 349: p_encoded => FND_API.G_FALSE,

345: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: FND_MSG_PUB.Count_And_Get (
349: p_encoded => FND_API.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );
353:

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: );
353:
354: WHEN OTHERS THEN
355: ROLLBACK TO CREATE_Offer_Adjustment_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
358: THEN
359: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
360: END IF;

Line 363: p_encoded => FND_API.G_FALSE,

359: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
360: END IF;
361: -- Standard call to get message count and if count=1, get the message
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367: End Create_Offer_Adjustment;

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

379: -- Parameters
380: --
381: -- IN
382: -- p_api_version_number IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
384: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
385: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
386: -- p_offer_adj_rec IN offer_adj_rec_type Required
387: --

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

380: --
381: -- IN
382: -- p_api_version_number IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
384: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
385: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
386: -- p_offer_adj_rec IN offer_adj_rec_type Required
387: --
388: -- OUT

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

381: -- IN
382: -- p_api_version_number IN NUMBER Required
383: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
384: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
385: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
386: -- p_offer_adj_rec IN offer_adj_rec_type Required
387: --
388: -- OUT
389: -- x_return_status OUT VARCHAR2

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

401: -- ==============================================================================
402:
403: PROCEDURE Update_Offer_Adjustment(
404: p_api_version_number IN NUMBER,
405: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
406: p_commit IN VARCHAR2 := FND_API.G_FALSE,
407: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
408:
409: x_return_status OUT NOCOPY VARCHAR2,

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

402:
403: PROCEDURE Update_Offer_Adjustment(
404: p_api_version_number IN NUMBER,
405: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
406: p_commit IN VARCHAR2 := FND_API.G_FALSE,
407: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
408:
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,

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

403: PROCEDURE Update_Offer_Adjustment(
404: p_api_version_number IN NUMBER,
405: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
406: p_commit IN VARCHAR2 := FND_API.G_FALSE,
407: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
408:
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,

Line 501: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

497: -- Standard Start of API savepoint
498: SAVEPOINT update_offer_adjustment_pvt;
499:
500: -- Standard call to check for call compatibility.
501: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
502: p_api_version_number,
503: l_api_name,
504: G_PKG_NAME)
505: THEN

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: p_api_version_number,
503: l_api_name,
504: G_PKG_NAME)
505: THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509:
510: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 511: IF FND_API.to_Boolean( p_init_msg_list )

507: END IF;
508:
509:
510: -- Initialize message list if p_init_msg_list is set to TRUE.
511: IF FND_API.to_Boolean( p_init_msg_list )
512: THEN
513: FND_MSG_PUB.initialize;
514: END IF;
515:

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS;

522: -- Initialize Object_Version_Number
523: l_object_version_number := p_offer_adj_rec.object_version_number ;
524:
525: -- Initialize API return status to SUCCESS
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: -- Debug Message
529: OZF_Offer_Adj_Line_PVT.debug_message('Private API: - Open Cursor to Select');
530:

Line 539: RAISE FND_API.G_EXC_ERROR;

535: If ( c_get_Offer_Adjustment%NOTFOUND) THEN
536: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
537: p_token_name => 'INFO',
538: p_token_value => 'Offer_Adjustment') ;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541:
542: -- Debug Message
543: OZF_Offer_Adj_Line_PVT.debug_message('Private API: - Close Cursor');

Line 548: l_tar_offer_adj_rec.object_version_number = FND_API.G_MISS_NUM ) Then

544: CLOSE c_get_Offer_Adjustment;
545:
546:
547: If (l_tar_offer_adj_rec.object_version_number is NULL or
548: l_tar_offer_adj_rec.object_version_number = FND_API.G_MISS_NUM ) Then
549: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
550: p_token_name => 'COLUMN',
551: p_token_value => 'Last_Update_Date') ;
552: raise FND_API.G_EXC_ERROR;

Line 552: raise FND_API.G_EXC_ERROR;

548: l_tar_offer_adj_rec.object_version_number = FND_API.G_MISS_NUM ) Then
549: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
550: p_token_name => 'COLUMN',
551: p_token_value => 'Last_Update_Date') ;
552: raise FND_API.G_EXC_ERROR;
553: End if;
554:
555:
556: -- Check Whether record has been changed by someone else

Line 562: raise FND_API.G_EXC_ERROR;

558: If (l_tar_offer_adj_rec.object_version_number <> l_ref_offer_adj_rec.object_version_number) Then
559: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
560: p_token_name => 'INFO',
561: p_token_value => 'Offer_Adjustment') ;
562: raise FND_API.G_EXC_ERROR;
563: End if;
564:
565:
566: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

562: raise FND_API.G_EXC_ERROR;
563: End if;
564:
565:
566: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
567: THEN
568: -- Debug message
569: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_Offer_Adjustment');
570:

Line 574: p_init_msg_list => FND_API.G_FALSE,

570:
571: -- Invoke validation procedures
572: Validate_offer_adjustment(
573: p_api_version_number => 1.0,
574: p_init_msg_list => FND_API.G_FALSE,
575: p_validation_level => p_validation_level,
576: p_validation_mode => JTF_PLSQL_API.g_update,
577: p_offer_adj_rec => p_offer_adj_rec,
578: x_return_status => x_return_status,

Line 583: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

579: x_msg_count => x_msg_count,
580: x_msg_data => x_msg_data);
581: END IF;
582:
583: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: -- code added by mthumu to call the budget approval

Line 584: RAISE FND_API.G_EXC_ERROR;

580: x_msg_data => x_msg_data);
581: END IF;
582:
583: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:
587: -- code added by mthumu to call the budget approval
588: OPEN c_get_offer_status(p_offer_adj_rec.offer_adjustment_id);

Line 608: RAISE FND_API.G_EXC_ERROR;

604:
605: IF l_if_lines_exist IS NULL THEN
606: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFRADJ_DISCRULE');
607:
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: -- Call Approval Work Flow
612: -- Select attr_available_flag

Line 672: p_init_msg_list => FND_API.G_FALSE

668:
669: l_new_status_code := 'PENDING';
670: ELSE
671: OZF_Offer_Backdate_PVT.Update_Offer_Discounts (
672: p_init_msg_list => FND_API.G_FALSE
673: ,p_api_version => 1.0
674: ,p_commit => FND_API.G_FALSE
675: ,x_return_status => x_return_status
676: ,x_msg_count => x_msg_count

Line 674: ,p_commit => FND_API.G_FALSE

670: ELSE
671: OZF_Offer_Backdate_PVT.Update_Offer_Discounts (
672: p_init_msg_list => FND_API.G_FALSE
673: ,p_api_version => 1.0
674: ,p_commit => FND_API.G_FALSE
675: ,x_return_status => x_return_status
676: ,x_msg_count => x_msg_count
677: ,x_msg_data => x_msg_data
678: ,p_offer_adjustment_id => p_offer_adj_rec.offer_adjustment_id

Line 681: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

677: ,x_msg_data => x_msg_data
678: ,p_offer_adjustment_id => p_offer_adj_rec.offer_adjustment_id
679: -- ,p_close_adj => 'Y'
680: ) ;
681: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
682: RAISE FND_API.G_EXC_ERROR;
683: END IF;
684: OZF_Offer_Backdate_PVT.getCloseAdjustmentParams
685: (

Line 682: RAISE FND_API.G_EXC_ERROR;

678: ,p_offer_adjustment_id => p_offer_adj_rec.offer_adjustment_id
679: -- ,p_close_adj => 'Y'
680: ) ;
681: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
682: RAISE FND_API.G_EXC_ERROR;
683: END IF;
684: OZF_Offer_Backdate_PVT.getCloseAdjustmentParams
685: (
686: p_offer_adjustment_id => p_offer_adj_rec.offer_adjustment_id

Line 693: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

689: ,x_msg_data => x_msg_data
690: ,x_newStatus => l_new_status_code
691: ,x_budgetAdjFlag => l_budgetAdjFlag
692: );
693: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696: END IF;
697: END IF;

Line 694: RAISE FND_API.G_EXC_ERROR;

690: ,x_newStatus => l_new_status_code
691: ,x_budgetAdjFlag => l_budgetAdjFlag
692: );
693: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696: END IF;
697: END IF;
698: END IF;

Line 739: IF FND_API.to_Boolean( p_commit )

735: x_object_version_number := l_object_version_number;
736: --
737: -- End of API body.
738: --
739: IF FND_API.to_Boolean( p_commit )
740: THEN
741: COMMIT WORK;
742: END IF;
743: -- Debug Message

Line 747: x_return_status := FND_API.g_ret_sts_error;

743: -- Debug Message
744: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
745: EXCEPTION
746: WHEN OZF_Utility_PVT.resource_locked THEN
747: x_return_status := FND_API.g_ret_sts_error;
748: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
751: x_return_status := FND_API.G_RET_STS_ERROR;

Line 749: WHEN FND_API.G_EXC_ERROR THEN

745: EXCEPTION
746: WHEN OZF_Utility_PVT.resource_locked THEN
747: x_return_status := FND_API.g_ret_sts_error;
748: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (

Line 751: x_return_status := FND_API.G_RET_STS_ERROR;

747: x_return_status := FND_API.g_ret_sts_error;
748: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,

Line 754: p_encoded => FND_API.G_FALSE,

750: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: -- Standard call to get message count and if count=1, get the message
753: FND_MSG_PUB.Count_And_Get (
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data
757: );
758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 763: p_encoded => FND_API.G_FALSE,

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

Line 770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

766: );
767:
768: WHEN OTHERS THEN
769: ROLLBACK TO UPDATE_Offer_Adjustment_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
772: THEN
773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
774: END IF;

Line 777: p_encoded => FND_API.G_FALSE,

773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
774: END IF;
775: -- Standard call to get message count and if count=1, get the message
776: FND_MSG_PUB.Count_And_Get (
777: p_encoded => FND_API.G_FALSE,
778: p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781: End Update_Offer_Adjustment;

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

793: -- Parameters
794: --
795: -- IN
796: -- p_api_version_number IN NUMBER Required
797: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
798: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
799: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
800: -- p_offer_adjustment_id IN NUMBER
801: -- p_object_version_number IN NUMBER Optional Default = NULL

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

794: --
795: -- IN
796: -- p_api_version_number IN NUMBER Required
797: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
798: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
799: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
800: -- p_offer_adjustment_id IN NUMBER
801: -- p_object_version_number IN NUMBER Optional Default = NULL
802: --

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

795: -- IN
796: -- p_api_version_number IN NUMBER Required
797: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
798: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
799: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
800: -- p_offer_adjustment_id IN NUMBER
801: -- p_object_version_number IN NUMBER Optional Default = NULL
802: --
803: -- OUT

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

816: -- ==============================================================================
817:
818: PROCEDURE Delete_Offer_Adjustment(
819: p_api_version_number IN NUMBER,
820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
821: p_commit IN VARCHAR2 := FND_API.G_FALSE,
822: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
823: x_return_status OUT NOCOPY VARCHAR2,
824: x_msg_count OUT NOCOPY NUMBER,

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

817:
818: PROCEDURE Delete_Offer_Adjustment(
819: p_api_version_number IN NUMBER,
820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
821: p_commit IN VARCHAR2 := FND_API.G_FALSE,
822: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
823: x_return_status OUT NOCOPY VARCHAR2,
824: x_msg_count OUT NOCOPY NUMBER,
825: x_msg_data OUT NOCOPY VARCHAR2,

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

818: PROCEDURE Delete_Offer_Adjustment(
819: p_api_version_number IN NUMBER,
820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
821: p_commit IN VARCHAR2 := FND_API.G_FALSE,
822: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
823: x_return_status OUT NOCOPY VARCHAR2,
824: x_msg_count OUT NOCOPY NUMBER,
825: x_msg_data OUT NOCOPY VARCHAR2,
826: p_offer_adjustment_id IN NUMBER,

Line 840: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

836: -- Standard Start of API savepoint
837: SAVEPOINT delete_offer_adjustment_pvt;
838:
839: -- Standard call to check for call compatibility.
840: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
841: p_api_version_number,
842: l_api_name,
843: G_PKG_NAME)
844: THEN

Line 845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

841: p_api_version_number,
842: l_api_name,
843: G_PKG_NAME)
844: THEN
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847:
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 850: IF FND_API.to_Boolean( p_init_msg_list )

846: END IF;
847:
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.to_Boolean( p_init_msg_list )
851: THEN
852: FND_MSG_PUB.initialize;
853: END IF;
854:

Line 863: x_return_status := FND_API.G_RET_STS_SUCCESS;

859:
860:
861:
862: -- Initialize API return status to SUCCESS
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864:
865: --
866: -- Api body
867: --

Line 880: IF FND_API.to_Boolean( p_commit )

876: -- End of API body
877: --
878:
879: -- Standard check for p_commit
880: IF FND_API.to_Boolean( p_commit )
881: THEN
882: COMMIT WORK;
883: END IF;
884:

Line 898: x_return_status := FND_API.g_ret_sts_error;

894: );
895: EXCEPTION
896:
897: WHEN OZF_Utility_PVT.resource_locked THEN
898: x_return_status := FND_API.g_ret_sts_error;
899: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
900:
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO DELETE_Offer_Adjustment_PVT;

Line 901: WHEN FND_API.G_EXC_ERROR THEN

897: WHEN OZF_Utility_PVT.resource_locked THEN
898: x_return_status := FND_API.g_ret_sts_error;
899: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
900:
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: -- Standard call to get message count and if count=1, get the message
905: FND_MSG_PUB.Count_And_Get (

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
900:
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: -- Standard call to get message count and if count=1, get the message
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,

Line 906: p_encoded => FND_API.G_FALSE,

902: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: -- Standard call to get message count and if count=1, get the message
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data
909: );
910:

Line 911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

907: p_count => x_msg_count,
908: p_data => x_msg_data
909: );
910:
911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
912: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (

Line 913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

909: );
910:
911: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
912: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,

Line 916: p_encoded => FND_API.G_FALSE,

912: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: -- Standard call to get message count and if count=1, get the message
915: FND_MSG_PUB.Count_And_Get (
916: p_encoded => FND_API.G_FALSE,
917: p_count => x_msg_count,
918: p_data => x_msg_data
919: );
920:

Line 923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

919: );
920:
921: WHEN OTHERS THEN
922: ROLLBACK TO DELETE_Offer_Adjustment_PVT;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
925: THEN
926: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
927: END IF;

Line 930: p_encoded => FND_API.G_FALSE,

926: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
927: END IF;
928: -- Standard call to get message count and if count=1, get the message
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );
934: End Delete_Offer_Adjustment;

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

948: -- Parameters
949: --
950: -- IN
951: -- p_api_version_number IN NUMBER Required
952: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
953: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
954: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
955: -- p_offer_adj_rec IN offer_adj_rec_type Required
956: --

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

949: --
950: -- IN
951: -- p_api_version_number IN NUMBER Required
952: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
953: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
954: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
955: -- p_offer_adj_rec IN offer_adj_rec_type Required
956: --
957: -- OUT

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

950: -- IN
951: -- p_api_version_number IN NUMBER Required
952: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
953: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
954: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
955: -- p_offer_adj_rec IN offer_adj_rec_type Required
956: --
957: -- OUT
958: -- x_return_status OUT VARCHAR2

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

970: -- ==============================================================================
971:
972: PROCEDURE Lock_Offer_Adjustment(
973: p_api_version_number IN NUMBER,
974: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
975:
976: x_return_status OUT NOCOPY VARCHAR2,
977: x_msg_count OUT NOCOPY NUMBER,
978: x_msg_data OUT NOCOPY VARCHAR2,

Line 997: IF FND_API.to_Boolean( p_init_msg_list )

993: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
994:
995:
996: -- Initialize message list if p_init_msg_list is set to TRUE.
997: IF FND_API.to_Boolean( p_init_msg_list )
998: THEN
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:

Line 1005: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1001:
1002:
1003:
1004: -- Standard call to check for call compatibility.
1005: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1006: p_api_version_number,
1007: l_api_name,
1008: G_PKG_NAME)
1009: THEN

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: p_api_version_number,
1007: l_api_name,
1008: G_PKG_NAME)
1009: THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END IF;
1012:
1013:
1014:

Line 1016: x_return_status := FND_API.G_RET_STS_SUCCESS;

1012:
1013:
1014:
1015: -- Initialize API return status to SUCCESS
1016: x_return_status := FND_API.G_RET_STS_SUCCESS;
1017:
1018:
1019: ------------------------ lock -------------------------
1020: OZF_Offer_Adjustment_Pkg.Lock_Row(l_offer_adjustment_id,p_object_version);

Line 1025: p_encoded => FND_API.g_false,

1021:
1022:
1023: -------------------- finish --------------------------
1024: FND_MSG_PUB.count_and_get(
1025: p_encoded => FND_API.g_false,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data);
1028: OZF_Offer_Adj_Line_PVT.debug_message(l_full_name ||': end');
1029: EXCEPTION

Line 1032: x_return_status := FND_API.g_ret_sts_error;

1028: OZF_Offer_Adj_Line_PVT.debug_message(l_full_name ||': end');
1029: EXCEPTION
1030:
1031: WHEN OZF_Utility_PVT.resource_locked THEN
1032: x_return_status := FND_API.g_ret_sts_error;
1033: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO LOCK_Offer_Adjustment_PVT;

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031: WHEN OZF_Utility_PVT.resource_locked THEN
1032: x_return_status := FND_API.g_ret_sts_error;
1033: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (

Line 1037: x_return_status := FND_API.G_RET_STS_ERROR;

1033: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1041: p_count => x_msg_count,

Line 1040: p_encoded => FND_API.G_FALSE,

1036: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044:

Line 1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (

Line 1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1043: );
1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,

Line 1050: p_encoded => FND_API.G_FALSE,

1046: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );
1054:

Line 1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1053: );
1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO LOCK_Offer_Adjustment_PVT;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;

Line 1064: p_encoded => FND_API.G_FALSE,

1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );
1068: End Lock_Offer_Adjustment;

Line 1100: x_return_status := FND_API.g_ret_sts_success;

1096: l_strClosed VARCHAR2(20) := ' ''CLOSED'' ';
1097: l_strTerminated VARCHAR2(20) := ' ''TERMINATED'' ';
1098:
1099: BEGIN
1100: x_return_status := FND_API.g_ret_sts_success;
1101: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1102: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1103: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1104: ' ozf_offer_adjustments_vl ',

Line 1147: IF l_valid_flag = FND_API.g_false THEN

1143:
1144: END IF;
1145:
1146:
1147: IF l_valid_flag = FND_API.g_false THEN
1148: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1149: x_return_status := FND_API.g_ret_sts_error;
1150: END IF;
1151:

Line 1149: x_return_status := FND_API.g_ret_sts_error;

1145:
1146:
1147: IF l_valid_flag = FND_API.g_false THEN
1148: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1149: x_return_status := FND_API.g_ret_sts_error;
1150: END IF;
1151:
1152: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );
1153:

Line 1157: x_return_status := FND_API.g_ret_sts_error;

1153:
1154: IF l_dup_effective_dt IS NOT NULL THEN
1155: IF l_dup_effective_dt = 1 THEN -- Show error, if 2 adjs. with same eff date exists. - sangara
1156: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');
1157: x_return_status := FND_API.g_ret_sts_error;
1158: END IF;
1159: END IF;
1160:
1161: END check_Offer_Adj_Uk_Items;

Line 1172: x_return_status := FND_API.g_ret_sts_success;

1168: x_return_status OUT NOCOPY VARCHAR2
1169: )
1170: IS
1171: BEGIN
1172: x_return_status := FND_API.g_ret_sts_success;
1173:
1174: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1175:
1176:

Line 1177: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN

1173:
1174: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1175:
1176:
1177: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN
1178: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1179: -- x_return_status := FND_API.g_ret_sts_error;
1180: -- END IF;
1181:

Line 1179: -- x_return_status := FND_API.g_ret_sts_error;

1175:
1176:
1177: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN
1178: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1179: -- x_return_status := FND_API.g_ret_sts_error;
1180: -- END IF;
1181:
1182: -- List Header Id check
1183: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN

Line 1183: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN

1179: -- x_return_status := FND_API.g_ret_sts_error;
1180: -- END IF;
1181:
1182: -- List Header Id check
1183: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN
1184: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1185: x_return_status := FND_API.g_ret_sts_error;
1186: END IF;
1187:

Line 1185: x_return_status := FND_API.g_ret_sts_error;

1181:
1182: -- List Header Id check
1183: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN
1184: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1185: x_return_status := FND_API.g_ret_sts_error;
1186: END IF;
1187:
1188: -- Adjustment Name check
1189: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN

Line 1189: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN

1185: x_return_status := FND_API.g_ret_sts_error;
1186: END IF;
1187:
1188: -- Adjustment Name check
1189: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1190: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );
1191: x_return_status := FND_API.g_ret_sts_error;
1192: END IF;
1193:

Line 1191: x_return_status := FND_API.g_ret_sts_error;

1187:
1188: -- Adjustment Name check
1189: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1190: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );
1191: x_return_status := FND_API.g_ret_sts_error;
1192: END IF;
1193:
1194: -- Status Code check
1195: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN

Line 1195: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN

1191: x_return_status := FND_API.g_ret_sts_error;
1192: END IF;
1193:
1194: -- Status Code check
1195: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1196: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
1197: x_return_status := FND_API.g_ret_sts_error;
1198: END IF;
1199:

Line 1197: x_return_status := FND_API.g_ret_sts_error;

1193:
1194: -- Status Code check
1195: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1196: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
1197: x_return_status := FND_API.g_ret_sts_error;
1198: END IF;
1199:
1200: -- Effective Date check
1201: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN

Line 1201: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN

1197: x_return_status := FND_API.g_ret_sts_error;
1198: END IF;
1199:
1200: -- Effective Date check
1201: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN
1202: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );
1203: x_return_status := FND_API.g_ret_sts_error;
1204: END IF;
1205:

Line 1203: x_return_status := FND_API.g_ret_sts_error;

1199:
1200: -- Effective Date check
1201: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN
1202: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );
1203: x_return_status := FND_API.g_ret_sts_error;
1204: END IF;
1205:
1206: ELSE
1207:

Line 1208: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN

1204: END IF;
1205:
1206: ELSE
1207:
1208: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1209: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1210: x_return_status := FND_API.g_ret_sts_error;
1211: END IF;
1212:

Line 1210: x_return_status := FND_API.g_ret_sts_error;

1206: ELSE
1207:
1208: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1209: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1210: x_return_status := FND_API.g_ret_sts_error;
1211: END IF;
1212:
1213:
1214: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1214: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN

1210: x_return_status := FND_API.g_ret_sts_error;
1211: END IF;
1212:
1213:
1214: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
1215: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1216: x_return_status := FND_API.g_ret_sts_error;
1217: END IF;
1218:

Line 1216: x_return_status := FND_API.g_ret_sts_error;

1212:
1213:
1214: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
1215: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1216: x_return_status := FND_API.g_ret_sts_error;
1217: END IF;
1218:
1219: END IF;
1220:

Line 1231: x_return_status := FND_API.g_ret_sts_success;

1227: x_return_status OUT NOCOPY VARCHAR2
1228: )
1229: IS
1230: BEGIN
1231: x_return_status := FND_API.g_ret_sts_success;
1232:
1233: -- Enter custom code here
1234:
1235: END check_Offer_Adj_Fk_Items;

Line 1245: x_return_status := FND_API.g_ret_sts_success;

1241: x_return_status OUT NOCOPY VARCHAR2
1242: )
1243: IS
1244: BEGIN
1245: x_return_status := FND_API.g_ret_sts_success;
1246:
1247: -- Enter custom code here
1248:
1249: END check_Offer_Adj_Lookup_Items;

Line 1262: l_return_status := FND_API.g_ret_sts_success;

1258: IS
1259: l_return_status VARCHAR2(1);
1260: BEGIN
1261:
1262: l_return_status := FND_API.g_ret_sts_success;
1263: -- Check Items Uniqueness API calls
1264:
1265: check_Offer_adj_Uk_Items(
1266: p_offer_adj_rec => p_offer_adj_rec,

Line 1269: IF x_return_status <> FND_API.g_ret_sts_success THEN

1265: check_Offer_adj_Uk_Items(
1266: p_offer_adj_rec => p_offer_adj_rec,
1267: p_validation_mode => p_validation_mode,
1268: x_return_status => x_return_status);
1269: IF x_return_status <> FND_API.g_ret_sts_success THEN
1270: l_return_status := FND_API.g_ret_sts_error;
1271: END IF;
1272:
1273: -- Check Items Required/NOT NULL API calls

Line 1270: l_return_status := FND_API.g_ret_sts_error;

1266: p_offer_adj_rec => p_offer_adj_rec,
1267: p_validation_mode => p_validation_mode,
1268: x_return_status => x_return_status);
1269: IF x_return_status <> FND_API.g_ret_sts_success THEN
1270: l_return_status := FND_API.g_ret_sts_error;
1271: END IF;
1272:
1273: -- Check Items Required/NOT NULL API calls
1274:

Line 1279: IF x_return_status <> FND_API.g_ret_sts_success THEN

1275: check_offer_adj_req_items(
1276: p_offer_adj_rec => p_offer_adj_rec,
1277: p_validation_mode => p_validation_mode,
1278: x_return_status => x_return_status);
1279: IF x_return_status <> FND_API.g_ret_sts_success THEN
1280: l_return_status := FND_API.g_ret_sts_error;
1281: END IF;
1282: -- Check Items Foreign Keys API calls
1283:

Line 1280: l_return_status := FND_API.g_ret_sts_error;

1276: p_offer_adj_rec => p_offer_adj_rec,
1277: p_validation_mode => p_validation_mode,
1278: x_return_status => x_return_status);
1279: IF x_return_status <> FND_API.g_ret_sts_success THEN
1280: l_return_status := FND_API.g_ret_sts_error;
1281: END IF;
1282: -- Check Items Foreign Keys API calls
1283:
1284: check_offer_adj_FK_items(

Line 1287: IF x_return_status <> FND_API.g_ret_sts_success THEN

1283:
1284: check_offer_adj_FK_items(
1285: p_offer_adj_rec => p_offer_adj_rec,
1286: x_return_status => x_return_status);
1287: IF x_return_status <> FND_API.g_ret_sts_success THEN
1288: l_return_status := FND_API.g_ret_sts_error;
1289: END IF;
1290: -- Check Items Lookups
1291:

Line 1288: l_return_status := FND_API.g_ret_sts_error;

1284: check_offer_adj_FK_items(
1285: p_offer_adj_rec => p_offer_adj_rec,
1286: x_return_status => x_return_status);
1287: IF x_return_status <> FND_API.g_ret_sts_success THEN
1288: l_return_status := FND_API.g_ret_sts_error;
1289: END IF;
1290: -- Check Items Lookups
1291:
1292: check_offer_adj_Lookup_items(

Line 1295: IF x_return_status <> FND_API.g_ret_sts_success THEN

1291:
1292: check_offer_adj_Lookup_items(
1293: p_offer_adj_rec => p_offer_adj_rec,
1294: x_return_status => x_return_status);
1295: IF x_return_status <> FND_API.g_ret_sts_success THEN
1296: l_return_status := FND_API.g_ret_sts_error;
1297: END IF;
1298:
1299: x_return_status := l_return_status;

Line 1296: l_return_status := FND_API.g_ret_sts_error;

1292: check_offer_adj_Lookup_items(
1293: p_offer_adj_rec => p_offer_adj_rec,
1294: x_return_status => x_return_status);
1295: IF x_return_status <> FND_API.g_ret_sts_success THEN
1296: l_return_status := FND_API.g_ret_sts_error;
1297: END IF;
1298:
1299: x_return_status := l_return_status;
1300:

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

1480: l_offer_adj_rec offer_adj_rec_type := p_offer_adj_rec;
1481: BEGIN
1482: -- Developers should put their code to default the record type
1483: -- e.g. IF p_campaign_rec.status_code IS NULL
1484: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1485: -- l_campaign_rec.status_code := 'NEW' ;
1486: -- END IF ;
1487: --
1488: NULL ;

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

1492:
1493:
1494: PROCEDURE Validate_Offer_Adjustment(
1495: p_api_version_number IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1498: p_offer_adj_rec IN offer_adj_rec_type,
1499: p_validation_mode IN VARCHAR2,
1500: x_return_status OUT NOCOPY VARCHAR2,

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

1493:
1494: PROCEDURE Validate_Offer_Adjustment(
1495: p_api_version_number IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1498: p_offer_adj_rec IN offer_adj_rec_type,
1499: p_validation_mode IN VARCHAR2,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,

Line 1515: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1511: -- Standard Start of API savepoint
1512: SAVEPOINT validate_offer_adjustment_;
1513:
1514: -- Standard call to check for call compatibility.
1515: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1516: p_api_version_number,
1517: l_api_name,
1518: G_PKG_NAME)
1519: THEN

Line 1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1516: p_api_version_number,
1517: l_api_name,
1518: G_PKG_NAME)
1519: THEN
1520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1521: END IF;
1522:
1523:
1524: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1525: IF FND_API.to_Boolean( p_init_msg_list )

1521: END IF;
1522:
1523:
1524: -- Initialize message list if p_init_msg_list is set to TRUE.
1525: IF FND_API.to_Boolean( p_init_msg_list )
1526: THEN
1527: FND_MSG_PUB.initialize;
1528: END IF;
1529:

Line 1538: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1534: p_validation_mode => p_validation_mode,
1535: x_return_status => x_return_status
1536: );
1537:
1538: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;

Line 1539: RAISE FND_API.G_EXC_ERROR;

1535: x_return_status => x_return_status
1536: );
1537:
1538: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;
1543: END IF;

Line 1540: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1536: );
1537:
1538: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;
1543: END IF;
1544:

Line 1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1537:
1538: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1539: RAISE FND_API.G_EXC_ERROR;
1540: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: END IF;
1543: END IF;
1544:
1545: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1559: RAISE FND_API.G_EXC_ERROR;

1555:
1556: -- If the Effective date is before the start date of any of the budgets dont create or update adjustments
1557: IF l_offer_adj_rec.effective_date < get_budget_start_date(l_offer_adj_rec.list_header_id) AND isBudgetOffer(p_listHeaderId => l_offer_adj_rec.list_header_id) = 'N' THEN
1558: ozf_utility_pvt.error_message('OZF_OFFR_ADJ_DT_LT_BUDGET_DT');
1559: RAISE FND_API.G_EXC_ERROR;
1560: END IF;
1561:
1562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1563: Validate_offer_adj_Rec(

Line 1565: p_init_msg_list => FND_API.G_FALSE,

1561:
1562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1563: Validate_offer_adj_Rec(
1564: p_api_version_number => 1.0,
1565: p_init_msg_list => FND_API.G_FALSE,
1566: x_return_status => x_return_status,
1567: x_msg_count => x_msg_count,
1568: x_msg_data => x_msg_data,
1569: p_offer_adj_rec => l_offer_adj_rec);

Line 1571: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1567: x_msg_count => x_msg_count,
1568: x_msg_data => x_msg_data,
1569: p_offer_adj_rec => l_offer_adj_rec);
1570:
1571: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: END IF;

Line 1572: RAISE FND_API.G_EXC_ERROR;

1568: x_msg_data => x_msg_data,
1569: p_offer_adj_rec => l_offer_adj_rec);
1570:
1571: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: END IF;
1576: END IF;

Line 1573: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1569: p_offer_adj_rec => l_offer_adj_rec);
1570:
1571: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: END IF;
1576: END IF;
1577:

Line 1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1570:
1571: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1572: RAISE FND_API.G_EXC_ERROR;
1573: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: END IF;
1576: END IF;
1577:
1578:

Line 1585: x_return_status := FND_API.G_RET_STS_SUCCESS;

1581:
1582:
1583:
1584: -- Initialize API return status to SUCCESS
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586:
1587:
1588: -- Debug Message
1589: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 1600: x_return_status := FND_API.g_ret_sts_error;

1596: );
1597: EXCEPTION
1598:
1599: WHEN OZF_Utility_PVT.resource_locked THEN
1600: x_return_status := FND_API.g_ret_sts_error;
1601: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;

Line 1603: WHEN FND_API.G_EXC_ERROR THEN

1599: WHEN OZF_Utility_PVT.resource_locked THEN
1600: x_return_status := FND_API.g_ret_sts_error;
1601: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: -- Standard call to get message count and if count=1, get the message
1607: FND_MSG_PUB.Count_And_Get (

Line 1605: x_return_status := FND_API.G_RET_STS_ERROR;

1601: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1602:
1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: -- Standard call to get message count and if count=1, get the message
1607: FND_MSG_PUB.Count_And_Get (
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,

Line 1608: p_encoded => FND_API.G_FALSE,

1604: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: -- Standard call to get message count and if count=1, get the message
1607: FND_MSG_PUB.Count_And_Get (
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data
1611: );
1612:

Line 1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1609: p_count => x_msg_count,
1610: p_data => x_msg_data
1611: );
1612:
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1616: -- Standard call to get message count and if count=1, get the message
1617: FND_MSG_PUB.Count_And_Get (

Line 1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1611: );
1612:
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1616: -- Standard call to get message count and if count=1, get the message
1617: FND_MSG_PUB.Count_And_Get (
1618: p_encoded => FND_API.G_FALSE,
1619: p_count => x_msg_count,

Line 1618: p_encoded => FND_API.G_FALSE,

1614: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1616: -- Standard call to get message count and if count=1, get the message
1617: FND_MSG_PUB.Count_And_Get (
1618: p_encoded => FND_API.G_FALSE,
1619: p_count => x_msg_count,
1620: p_data => x_msg_data
1621: );
1622:

Line 1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1621: );
1622:
1623: WHEN OTHERS THEN
1624: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1627: THEN
1628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1629: END IF;

Line 1632: p_encoded => FND_API.G_FALSE,

1628: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1629: END IF;
1630: -- Standard call to get message count and if count=1, get the message
1631: FND_MSG_PUB.Count_And_Get (
1632: p_encoded => FND_API.G_FALSE,
1633: p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );
1636: End Validate_Offer_Adjustment;

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

1637:
1638:
1639: PROCEDURE Validate_Offer_Adj_Rec (
1640: p_api_version_number IN NUMBER,
1641: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1642: x_return_status OUT NOCOPY VARCHAR2,
1643: x_msg_count OUT NOCOPY NUMBER,
1644: x_msg_data OUT NOCOPY VARCHAR2,
1645: p_offer_adj_rec IN offer_adj_rec_type

Line 1650: IF FND_API.to_Boolean( p_init_msg_list )

1646: )
1647: IS
1648: BEGIN
1649: -- Initialize message list if p_init_msg_list is set to TRUE.
1650: IF FND_API.to_Boolean( p_init_msg_list )
1651: THEN
1652: FND_MSG_PUB.initialize;
1653: END IF;
1654:

Line 1658: x_return_status := FND_API.G_RET_STS_SUCCESS;

1654:
1655:
1656:
1657: -- Initialize API return status to SUCCESS
1658: x_return_status := FND_API.G_RET_STS_SUCCESS;
1659:
1660: -- Hint: Validate data
1661: -- If data not valid
1662: -- THEN

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

1659:
1660: -- Hint: Validate data
1661: -- If data not valid
1662: -- THEN
1663: -- x_return_status := FND_API.G_RET_STS_ERROR;
1664:
1665: -- Debug Message
1666: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1667: -- Standard call to get message count and if count is 1, get message info.