DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on FND_API

Line 113: RAISE Fnd_Api.g_exc_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 170: l_org_id NUMBER := FND_API.G_MISS_NUM;

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

Line 186: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 196: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205:
206:
207:
208: -- Initialize API return status to SUCCESS
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: -- Local variable initialization
212:
213: 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 213: IF p_offer_adj_rec.offer_adjustment_id IS NULL OR p_offer_adj_rec.offer_adjustment_id = FND_API.g_miss_num THEN

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

Line 238: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 251: p_init_msg_list => FND_API.G_FALSE,

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

Line 260: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 261: RAISE FND_API.G_EXC_ERROR;

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

Line 304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 305: RAISE FND_API.G_EXC_ERROR;

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

Line 312: IF FND_API.to_Boolean( p_commit )

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

Line 315: -- RAISE FND_API.G_EXC_ERROR;

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

Line 332: x_return_status := FND_API.g_ret_sts_error;

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

Line 335: WHEN FND_API.G_EXC_ERROR THEN

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

Line 337: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 340: p_encoded => FND_API.G_FALSE,

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

Line 345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 350: p_encoded => FND_API.G_FALSE,

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

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 364: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 502: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 512: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 527: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 540: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 553: raise FND_API.G_EXC_ERROR;

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

Line 563: raise FND_API.G_EXC_ERROR;

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

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

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

Line 575: p_init_msg_list => FND_API.G_FALSE,

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

Line 584: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 585: RAISE FND_API.G_EXC_ERROR;

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

Line 609: RAISE FND_API.G_EXC_ERROR;

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

Line 673: p_init_msg_list => FND_API.G_FALSE

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

Line 675: ,p_commit => FND_API.G_FALSE

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

Line 682: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 683: RAISE FND_API.G_EXC_ERROR;

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

Line 694: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

Line 695: RAISE FND_API.G_EXC_ERROR;

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

Line 740: IF FND_API.to_Boolean( p_commit )

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

Line 748: x_return_status := FND_API.g_ret_sts_error;

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

Line 750: WHEN FND_API.G_EXC_ERROR THEN

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

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 755: p_encoded => FND_API.G_FALSE,

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

Line 759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 764: p_encoded => FND_API.G_FALSE,

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

Line 771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 778: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 841: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 851: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 881: IF FND_API.to_Boolean( p_commit )

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

Line 899: x_return_status := FND_API.g_ret_sts_error;

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

Line 902: WHEN FND_API.G_EXC_ERROR THEN

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

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 907: p_encoded => FND_API.G_FALSE,

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

Line 912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 917: p_encoded => FND_API.G_FALSE,

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

Line 924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 931: p_encoded => FND_API.G_FALSE,

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

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

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

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

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

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

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

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

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

Line 998: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 1006: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1017: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1026: p_encoded => FND_API.g_false,

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

Line 1033: x_return_status := FND_API.g_ret_sts_error;

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

Line 1036: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1038: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1041: p_encoded => FND_API.G_FALSE,

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

Line 1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1051: p_encoded => FND_API.G_FALSE,

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

Line 1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1065: p_encoded => FND_API.G_FALSE,

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

Line 1115: x_return_status := FND_API.g_ret_sts_success;

1111: AND list_header_id = p_offer_adj_rec.list_header_id
1112: AND offer_adjustment_id <> p_offer_adj_rec.offer_adjustment_id;
1113:
1114: BEGIN
1115: x_return_status := FND_API.g_ret_sts_success;
1116: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1117: OZF_Offer_Adj_Line_PVT.debug_message('Inside Uk_Items::Create');
1118: --nepanda : fix for bug 9149865
1119: /*l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 1173: IF l_valid_flag = 1 THEN --FND_API.g_false THEN

1169:
1170: END IF;
1171:
1172:
1173: IF l_valid_flag = 1 THEN --FND_API.g_false THEN
1174: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:

Line 1175: x_return_status := FND_API.g_ret_sts_error;

1171:
1172:
1173: IF l_valid_flag = 1 THEN --FND_API.g_false THEN
1174: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_NAME_DUP');
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:
1178: OZF_Offer_Adj_Line_PVT.debug_message('check_Offer_Adj_Uk_Items :: l_dup_effective_dt ' || l_dup_effective_dt );
1179:

Line 1183: x_return_status := FND_API.g_ret_sts_error;

1179:
1180: IF l_dup_effective_dt IS NOT NULL THEN
1181: IF l_dup_effective_dt = 1 THEN -- Show error, if 2 adjs. with same eff date exists. - sangara
1182: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFADJ_DUP_EFFDT');
1183: x_return_status := FND_API.g_ret_sts_error;
1184: END IF;
1185: END IF;
1186:
1187: END check_Offer_Adj_Uk_Items;

Line 1198: x_return_status := FND_API.g_ret_sts_success;

1194: x_return_status OUT NOCOPY VARCHAR2
1195: )
1196: IS
1197: BEGIN
1198: x_return_status := FND_API.g_ret_sts_success;
1199:
1200: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1201:
1202:

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

1199:
1200: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1201:
1202:
1203: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN
1204: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1205: -- x_return_status := FND_API.g_ret_sts_error;
1206: -- END IF;
1207:

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

1201:
1202:
1203: -- IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.offer_adjustment_id IS NULL THEN
1204: -- OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1205: -- x_return_status := FND_API.g_ret_sts_error;
1206: -- END IF;
1207:
1208: -- List Header Id check
1209: 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 1209: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN

1205: -- x_return_status := FND_API.g_ret_sts_error;
1206: -- END IF;
1207:
1208: -- List Header Id check
1209: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN
1210: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1211: x_return_status := FND_API.g_ret_sts_error;
1212: END IF;
1213:

Line 1211: x_return_status := FND_API.g_ret_sts_error;

1207:
1208: -- List Header Id check
1209: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM OR p_offer_adj_rec.list_header_id IS NULL THEN
1210: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1211: x_return_status := FND_API.g_ret_sts_error;
1212: END IF;
1213:
1214: -- Adjustment Name check
1215: 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 1215: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN

1211: x_return_status := FND_API.g_ret_sts_error;
1212: END IF;
1213:
1214: -- Adjustment Name check
1215: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1216: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );
1217: x_return_status := FND_API.g_ret_sts_error;
1218: END IF;
1219:

Line 1217: x_return_status := FND_API.g_ret_sts_error;

1213:
1214: -- Adjustment Name check
1215: IF p_offer_adj_rec.offer_adjustment_name = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1216: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_NAME' );
1217: x_return_status := FND_API.g_ret_sts_error;
1218: END IF;
1219:
1220: -- Status Code check
1221: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN

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

1217: x_return_status := FND_API.g_ret_sts_error;
1218: END IF;
1219:
1220: -- Status Code check
1221: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1222: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
1223: x_return_status := FND_API.g_ret_sts_error;
1224: END IF;
1225:

Line 1223: x_return_status := FND_API.g_ret_sts_error;

1219:
1220: -- Status Code check
1221: IF p_offer_adj_rec.status_code = FND_API.G_MISS_CHAR OR p_offer_adj_rec.offer_adjustment_name IS NULL THEN
1222: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'STATUS_CODE' );
1223: x_return_status := FND_API.g_ret_sts_error;
1224: END IF;
1225:
1226: -- Effective Date check
1227: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN

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

1223: x_return_status := FND_API.g_ret_sts_error;
1224: END IF;
1225:
1226: -- Effective Date check
1227: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN
1228: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );
1229: x_return_status := FND_API.g_ret_sts_error;
1230: END IF;
1231:

Line 1229: x_return_status := FND_API.g_ret_sts_error;

1225:
1226: -- Effective Date check
1227: IF p_offer_adj_rec.effective_date = FND_API.G_MISS_DATE OR p_offer_adj_rec.effective_date IS NULL THEN
1228: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_DATE' );
1229: x_return_status := FND_API.g_ret_sts_error;
1230: END IF;
1231:
1232: ELSE
1233:

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

1230: END IF;
1231:
1232: ELSE
1233:
1234: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1235: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1236: x_return_status := FND_API.g_ret_sts_error;
1237: END IF;
1238:

Line 1236: x_return_status := FND_API.g_ret_sts_error;

1232: ELSE
1233:
1234: IF p_offer_adj_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1235: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1236: x_return_status := FND_API.g_ret_sts_error;
1237: END IF;
1238:
1239:
1240: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN

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

1236: x_return_status := FND_API.g_ret_sts_error;
1237: END IF;
1238:
1239:
1240: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
1241: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1242: x_return_status := FND_API.g_ret_sts_error;
1243: END IF;
1244:

Line 1242: x_return_status := FND_API.g_ret_sts_error;

1238:
1239:
1240: IF p_offer_adj_rec.list_header_id = FND_API.G_MISS_NUM THEN
1241: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1242: x_return_status := FND_API.g_ret_sts_error;
1243: END IF;
1244:
1245: END IF;
1246:

Line 1257: x_return_status := FND_API.g_ret_sts_success;

1253: x_return_status OUT NOCOPY VARCHAR2
1254: )
1255: IS
1256: BEGIN
1257: x_return_status := FND_API.g_ret_sts_success;
1258:
1259: -- Enter custom code here
1260:
1261: END check_Offer_Adj_Fk_Items;

Line 1271: x_return_status := FND_API.g_ret_sts_success;

1267: x_return_status OUT NOCOPY VARCHAR2
1268: )
1269: IS
1270: BEGIN
1271: x_return_status := FND_API.g_ret_sts_success;
1272:
1273: -- Enter custom code here
1274:
1275: END check_Offer_Adj_Lookup_Items;

Line 1288: l_return_status := FND_API.g_ret_sts_success;

1284: IS
1285: l_return_status VARCHAR2(1);
1286: BEGIN
1287:
1288: l_return_status := FND_API.g_ret_sts_success;
1289: -- Check Items Uniqueness API calls
1290:
1291: check_Offer_adj_Uk_Items(
1292: p_offer_adj_rec => p_offer_adj_rec,

Line 1295: IF x_return_status <> FND_API.g_ret_sts_success THEN

1291: check_Offer_adj_Uk_Items(
1292: p_offer_adj_rec => p_offer_adj_rec,
1293: p_validation_mode => p_validation_mode,
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: -- Check Items Required/NOT NULL API calls

Line 1296: l_return_status := FND_API.g_ret_sts_error;

1292: p_offer_adj_rec => p_offer_adj_rec,
1293: p_validation_mode => p_validation_mode,
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: -- Check Items Required/NOT NULL API calls
1300:

Line 1305: IF x_return_status <> FND_API.g_ret_sts_success THEN

1301: check_offer_adj_req_items(
1302: p_offer_adj_rec => p_offer_adj_rec,
1303: p_validation_mode => p_validation_mode,
1304: x_return_status => x_return_status);
1305: IF x_return_status <> FND_API.g_ret_sts_success THEN
1306: l_return_status := FND_API.g_ret_sts_error;
1307: END IF;
1308: -- Check Items Foreign Keys API calls
1309:

Line 1306: l_return_status := FND_API.g_ret_sts_error;

1302: p_offer_adj_rec => p_offer_adj_rec,
1303: p_validation_mode => p_validation_mode,
1304: x_return_status => x_return_status);
1305: IF x_return_status <> FND_API.g_ret_sts_success THEN
1306: l_return_status := FND_API.g_ret_sts_error;
1307: END IF;
1308: -- Check Items Foreign Keys API calls
1309:
1310: check_offer_adj_FK_items(

Line 1313: IF x_return_status <> FND_API.g_ret_sts_success THEN

1309:
1310: check_offer_adj_FK_items(
1311: p_offer_adj_rec => p_offer_adj_rec,
1312: x_return_status => x_return_status);
1313: IF x_return_status <> FND_API.g_ret_sts_success THEN
1314: l_return_status := FND_API.g_ret_sts_error;
1315: END IF;
1316: -- Check Items Lookups
1317:

Line 1314: l_return_status := FND_API.g_ret_sts_error;

1310: check_offer_adj_FK_items(
1311: p_offer_adj_rec => p_offer_adj_rec,
1312: x_return_status => x_return_status);
1313: IF x_return_status <> FND_API.g_ret_sts_success THEN
1314: l_return_status := FND_API.g_ret_sts_error;
1315: END IF;
1316: -- Check Items Lookups
1317:
1318: check_offer_adj_Lookup_items(

Line 1321: IF x_return_status <> FND_API.g_ret_sts_success THEN

1317:
1318: check_offer_adj_Lookup_items(
1319: p_offer_adj_rec => p_offer_adj_rec,
1320: x_return_status => x_return_status);
1321: IF x_return_status <> FND_API.g_ret_sts_success THEN
1322: l_return_status := FND_API.g_ret_sts_error;
1323: END IF;
1324:
1325: x_return_status := l_return_status;

Line 1322: l_return_status := FND_API.g_ret_sts_error;

1318: check_offer_adj_Lookup_items(
1319: p_offer_adj_rec => p_offer_adj_rec,
1320: x_return_status => x_return_status);
1321: IF x_return_status <> FND_API.g_ret_sts_success THEN
1322: l_return_status := FND_API.g_ret_sts_error;
1323: END IF;
1324:
1325: x_return_status := l_return_status;
1326:

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

1506: l_offer_adj_rec offer_adj_rec_type := p_offer_adj_rec;
1507: BEGIN
1508: -- Developers should put their code to default the record type
1509: -- e.g. IF p_campaign_rec.status_code IS NULL
1510: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1511: -- l_campaign_rec.status_code := 'NEW' ;
1512: -- END IF ;
1513: --
1514: NULL ;

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

1518:
1519:
1520: PROCEDURE Validate_Offer_Adjustment(
1521: p_api_version_number IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1524: p_offer_adj_rec IN offer_adj_rec_type,
1525: p_validation_mode IN VARCHAR2,
1526: x_return_status OUT NOCOPY VARCHAR2,

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

1519:
1520: PROCEDURE Validate_Offer_Adjustment(
1521: p_api_version_number IN NUMBER,
1522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1524: p_offer_adj_rec IN offer_adj_rec_type,
1525: p_validation_mode IN VARCHAR2,
1526: x_return_status OUT NOCOPY VARCHAR2,
1527: x_msg_count OUT NOCOPY NUMBER,

Line 1541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1537: -- Standard Start of API savepoint
1538: SAVEPOINT validate_offer_adjustment_;
1539:
1540: -- Standard call to check for call compatibility.
1541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1542: p_api_version_number,
1543: l_api_name,
1544: G_PKG_NAME)
1545: THEN

Line 1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1542: p_api_version_number,
1543: l_api_name,
1544: G_PKG_NAME)
1545: THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548:
1549:
1550: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1551: IF FND_API.to_Boolean( p_init_msg_list )

1547: END IF;
1548:
1549:
1550: -- Initialize message list if p_init_msg_list is set to TRUE.
1551: IF FND_API.to_Boolean( p_init_msg_list )
1552: THEN
1553: FND_MSG_PUB.initialize;
1554: END IF;
1555:

Line 1564: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1560: p_validation_mode => p_validation_mode,
1561: x_return_status => x_return_status
1562: );
1563:
1564: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1565: RAISE FND_API.G_EXC_ERROR;
1566: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: END IF;

Line 1565: RAISE FND_API.G_EXC_ERROR;

1561: x_return_status => x_return_status
1562: );
1563:
1564: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1565: RAISE FND_API.G_EXC_ERROR;
1566: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: END IF;
1569: END IF;

Line 1566: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1562: );
1563:
1564: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1565: RAISE FND_API.G_EXC_ERROR;
1566: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: END IF;
1569: END IF;
1570:

Line 1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1563:
1564: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1565: RAISE FND_API.G_EXC_ERROR;
1566: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: END IF;
1569: END IF;
1570:
1571: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1585: RAISE FND_API.G_EXC_ERROR;

1581:
1582: -- If the Effective date is before the start date of any of the budgets dont create or update adjustments
1583: 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
1584: ozf_utility_pvt.error_message('OZF_OFFR_ADJ_DT_LT_BUDGET_DT');
1585: RAISE FND_API.G_EXC_ERROR;
1586: END IF;
1587:
1588: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1589: Validate_offer_adj_Rec(

Line 1591: p_init_msg_list => FND_API.G_FALSE,

1587:
1588: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1589: Validate_offer_adj_Rec(
1590: p_api_version_number => 1.0,
1591: p_init_msg_list => FND_API.G_FALSE,
1592: x_return_status => x_return_status,
1593: x_msg_count => x_msg_count,
1594: x_msg_data => x_msg_data,
1595: p_offer_adj_rec => l_offer_adj_rec);

Line 1597: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1593: x_msg_count => x_msg_count,
1594: x_msg_data => x_msg_data,
1595: p_offer_adj_rec => l_offer_adj_rec);
1596:
1597: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1598: RAISE FND_API.G_EXC_ERROR;
1599: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;

Line 1598: RAISE FND_API.G_EXC_ERROR;

1594: x_msg_data => x_msg_data,
1595: p_offer_adj_rec => l_offer_adj_rec);
1596:
1597: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1598: RAISE FND_API.G_EXC_ERROR;
1599: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602: END IF;

Line 1599: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1595: p_offer_adj_rec => l_offer_adj_rec);
1596:
1597: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1598: RAISE FND_API.G_EXC_ERROR;
1599: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602: END IF;
1603:

Line 1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1596:
1597: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1598: RAISE FND_API.G_EXC_ERROR;
1599: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602: END IF;
1603:
1604:

Line 1611: x_return_status := FND_API.G_RET_STS_SUCCESS;

1607:
1608:
1609:
1610: -- Initialize API return status to SUCCESS
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613:
1614: -- Debug Message
1615: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 1626: x_return_status := FND_API.g_ret_sts_error;

1622: );
1623: EXCEPTION
1624:
1625: WHEN OZF_Utility_PVT.resource_locked THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1628:
1629: WHEN FND_API.G_EXC_ERROR THEN
1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;

Line 1629: WHEN FND_API.G_EXC_ERROR THEN

1625: WHEN OZF_Utility_PVT.resource_locked THEN
1626: x_return_status := FND_API.g_ret_sts_error;
1627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1628:
1629: WHEN FND_API.G_EXC_ERROR THEN
1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (

Line 1631: x_return_status := FND_API.G_RET_STS_ERROR;

1627: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1628:
1629: WHEN FND_API.G_EXC_ERROR THEN
1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,

Line 1634: p_encoded => FND_API.G_FALSE,

1630: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );
1638:

Line 1639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );
1638:
1639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1640: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1642: -- Standard call to get message count and if count=1, get the message
1643: FND_MSG_PUB.Count_And_Get (

Line 1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1637: );
1638:
1639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1640: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1642: -- Standard call to get message count and if count=1, get the message
1643: FND_MSG_PUB.Count_And_Get (
1644: p_encoded => FND_API.G_FALSE,
1645: p_count => x_msg_count,

Line 1644: p_encoded => FND_API.G_FALSE,

1640: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1642: -- Standard call to get message count and if count=1, get the message
1643: FND_MSG_PUB.Count_And_Get (
1644: p_encoded => FND_API.G_FALSE,
1645: p_count => x_msg_count,
1646: p_data => x_msg_data
1647: );
1648:

Line 1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1647: );
1648:
1649: WHEN OTHERS THEN
1650: ROLLBACK TO VALIDATE_Offer_Adjustment_;
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1655: END IF;

Line 1658: p_encoded => FND_API.G_FALSE,

1654: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1655: END IF;
1656: -- Standard call to get message count and if count=1, get the message
1657: FND_MSG_PUB.Count_And_Get (
1658: p_encoded => FND_API.G_FALSE,
1659: p_count => x_msg_count,
1660: p_data => x_msg_data
1661: );
1662: End Validate_Offer_Adjustment;

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

1663:
1664:
1665: PROCEDURE Validate_Offer_Adj_Rec (
1666: p_api_version_number IN NUMBER,
1667: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1668: x_return_status OUT NOCOPY VARCHAR2,
1669: x_msg_count OUT NOCOPY NUMBER,
1670: x_msg_data OUT NOCOPY VARCHAR2,
1671: p_offer_adj_rec IN offer_adj_rec_type

Line 1676: IF FND_API.to_Boolean( p_init_msg_list )

1672: )
1673: IS
1674: BEGIN
1675: -- Initialize message list if p_init_msg_list is set to TRUE.
1676: IF FND_API.to_Boolean( p_init_msg_list )
1677: THEN
1678: FND_MSG_PUB.initialize;
1679: END IF;
1680:

Line 1684: x_return_status := FND_API.G_RET_STS_SUCCESS;

1680:
1681:
1682:
1683: -- Initialize API return status to SUCCESS
1684: x_return_status := FND_API.G_RET_STS_SUCCESS;
1685:
1686: -- Hint: Validate data
1687: -- If data not valid
1688: -- THEN

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

1685:
1686: -- Hint: Validate data
1687: -- If data not valid
1688: -- THEN
1689: -- x_return_status := FND_API.G_RET_STS_ERROR;
1690:
1691: -- Debug Message
1692: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1693: -- Standard call to get message count and if count is 1, get message info.