DBA Data[Home] [Help]

APPS.OZF_OFFER_BACK_CREATE_PVT dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.initialize;

65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.to_Boolean( p_init_msg_list )
68: THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Debug Message
73: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 167: FND_MSG_PUB.Count_And_Get

163: -- Debug Message
164: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
165:
166: -- Standard call to get message count and if count is 1, get message info.
167: FND_MSG_PUB.Count_And_Get
168: (p_count => x_msg_count,
169: p_data => x_msg_data
170: );
171: EXCEPTION

Line 181: FND_MSG_PUB.Count_And_Get (

177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO CREATE_Offer_Back_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR;
180: -- Standard call to get message count and if count=1, get the message
181: FND_MSG_PUB.Count_And_Get (
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );

Line 191: FND_MSG_PUB.Count_And_Get (

187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO CREATE_Offer_Back_PVT;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: -- Standard call to get message count and if count=1, get the message
191: FND_MSG_PUB.Count_And_Get (
192: p_encoded => FND_API.G_FALSE,
193: p_count => x_msg_count,
194: p_data => x_msg_data
195: );

Line 200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

196:
197: WHEN OTHERS THEN
198: ROLLBACK TO CREATE_Offer_Back_PVT;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message

Line 202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

198: ROLLBACK TO CREATE_Offer_Back_PVT;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,

Line 205: FND_MSG_PUB.Count_And_Get (

201: THEN
202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
203: END IF;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );

Line 260: FND_MSG_PUB.initialize;

256:
257: -- Initialize message list if p_init_msg_list is set to TRUE.
258: IF FND_API.to_Boolean( p_init_msg_list )
259: THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: -- Debug Message
264: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 367: FND_MSG_PUB.Count_And_Get

363: -- Debug Message
364: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
365:
366: -- Standard call to get message count and if count is 1, get message info.
367: FND_MSG_PUB.Count_And_Get
368: (p_count => x_msg_count,
369: p_data => x_msg_data
370: );
371: EXCEPTION

Line 381: FND_MSG_PUB.Count_And_Get (

377: WHEN FND_API.G_EXC_ERROR THEN
378: ROLLBACK TO UPDATE_Offer_Back_PVT;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: -- Standard call to get message count and if count=1, get the message
381: FND_MSG_PUB.Count_And_Get (
382: p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data
385: );

Line 391: FND_MSG_PUB.Count_And_Get (

387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ROLLBACK TO UPDATE_Offer_Back_PVT;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
395: );

Line 400: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

396:
397: WHEN OTHERS THEN
398: ROLLBACK TO UPDATE_Offer_Back_PVT;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
403: END IF;
404: -- Standard call to get message count and if count=1, get the message

Line 402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

398: ROLLBACK TO UPDATE_Offer_Back_PVT;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
403: END IF;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,

Line 405: FND_MSG_PUB.Count_And_Get (

401: THEN
402: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
403: END IF;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data
409: );

Line 446: FND_MSG_PUB.initialize;

442:
443: -- Initialize message list if p_init_msg_list is set to TRUE.
444: IF FND_API.to_Boolean( p_init_msg_list )
445: THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: -- Debug Message
450: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 480: FND_MSG_PUB.Count_And_Get

476: -- Debug Message
477: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get
481: (p_count => x_msg_count,
482: p_data => x_msg_data
483: );
484: EXCEPTION

Line 494: FND_MSG_PUB.Count_And_Get (

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

Line 504: FND_MSG_PUB.Count_And_Get (

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

Line 513: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

509:
510: WHEN OTHERS THEN
511: ROLLBACK TO DELETE_Offer_Back_PVT;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
516: END IF;
517: -- Standard call to get message count and if count=1, get the message

Line 515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

511: ROLLBACK TO DELETE_Offer_Back_PVT;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
514: THEN
515: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
516: END IF;
517: -- Standard call to get message count and if count=1, get the message
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.G_FALSE,

Line 518: FND_MSG_PUB.Count_And_Get (

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

Line 561: FND_MSG_PUB.initialize;

557:
558: -- Initialize message list if p_init_msg_list is set to TRUE.
559: IF FND_API.to_Boolean( p_init_msg_list )
560: THEN
561: FND_MSG_PUB.initialize;
562: END IF;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

583: FETCH c_Offer_Back_Create INTO l_OFFER_ADJUSTMENT_LINE_ID;
584:
585: IF (c_Offer_Back_Create%NOTFOUND) THEN
586: CLOSE c_Offer_Back_Create;
587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
588: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
589: FND_MSG_PUB.add;
590: END IF;
591: RAISE FND_API.g_exc_error;

Line 589: FND_MSG_PUB.add;

585: IF (c_Offer_Back_Create%NOTFOUND) THEN
586: CLOSE c_Offer_Back_Create;
587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
588: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
589: FND_MSG_PUB.add;
590: END IF;
591: RAISE FND_API.g_exc_error;
592: END IF;
593:

Line 597: FND_MSG_PUB.count_and_get(

593:
594: CLOSE c_Offer_Back_Create;
595:
596: -------------------- finish --------------------------
597: FND_MSG_PUB.count_and_get(
598: p_encoded => FND_API.g_false,
599: p_count => x_msg_count,
600: p_data => x_msg_data);
601: OZF_Utility_PVT.debug_message(l_full_name ||': end');

Line 612: FND_MSG_PUB.Count_And_Get (

608: WHEN FND_API.G_EXC_ERROR THEN
609: ROLLBACK TO LOCK_Offer_Back_PVT;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: -- Standard call to get message count and if count=1, get the message
612: FND_MSG_PUB.Count_And_Get (
613: p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
615: p_data => x_msg_data
616: );

Line 622: FND_MSG_PUB.Count_And_Get (

618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: ROLLBACK TO LOCK_Offer_Back_PVT;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: -- Standard call to get message count and if count=1, get the message
622: FND_MSG_PUB.Count_And_Get (
623: p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,
625: p_data => x_msg_data
626: );

Line 631: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

627:
628: WHEN OTHERS THEN
629: ROLLBACK TO LOCK_Offer_Back_PVT;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
632: THEN
633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
634: END IF;
635: -- Standard call to get message count and if count=1, get the message

Line 633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

629: ROLLBACK TO LOCK_Offer_Back_PVT;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
632: THEN
633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
634: END IF;
635: -- Standard call to get message count and if count=1, get the message
636: FND_MSG_PUB.Count_And_Get (
637: p_encoded => FND_API.G_FALSE,

Line 636: FND_MSG_PUB.Count_And_Get (

632: THEN
633: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
634: END IF;
635: -- Standard call to get message count and if count=1, get the message
636: FND_MSG_PUB.Count_And_Get (
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_msg_count,
639: p_data => x_msg_data
640: );

Line 879: FND_MSG_PUB.initialize;

875:
876: -- Initialize message list if p_init_msg_list is set to TRUE.
877: IF FND_API.to_Boolean( p_init_msg_list )
878: THEN
879: FND_MSG_PUB.initialize;
880: END IF;
881: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
882: Check_offer_back_Items(
883: p_offer_back_create_rec => p_offer_back_create_rec,

Line 929: FND_MSG_PUB.Count_And_Get

925: -- Debug Message
926: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
927:
928: -- Standard call to get message count and if count is 1, get message info.
929: FND_MSG_PUB.Count_And_Get
930: (p_count => x_msg_count,
931: p_data => x_msg_data
932: );
933: EXCEPTION

Line 943: FND_MSG_PUB.Count_And_Get (

939: WHEN FND_API.G_EXC_ERROR THEN
940: ROLLBACK TO VALIDATE_Offer_Back_;
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: -- Standard call to get message count and if count=1, get the message
943: FND_MSG_PUB.Count_And_Get (
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => x_msg_data
947: );

Line 953: FND_MSG_PUB.Count_And_Get (

949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
950: ROLLBACK TO VALIDATE_Offer_Back_;
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
952: -- Standard call to get message count and if count=1, get the message
953: FND_MSG_PUB.Count_And_Get (
954: p_encoded => FND_API.G_FALSE,
955: p_count => x_msg_count,
956: p_data => x_msg_data
957: );

Line 962: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

958:
959: WHEN OTHERS THEN
960: ROLLBACK TO VALIDATE_Offer_Back_;
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
965: END IF;
966: -- Standard call to get message count and if count=1, get the message

Line 964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

960: ROLLBACK TO VALIDATE_Offer_Back_;
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
963: THEN
964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
965: END IF;
966: -- Standard call to get message count and if count=1, get the message
967: FND_MSG_PUB.Count_And_Get (
968: p_encoded => FND_API.G_FALSE,

Line 967: FND_MSG_PUB.Count_And_Get (

963: THEN
964: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
965: END IF;
966: -- Standard call to get message count and if count=1, get the message
967: FND_MSG_PUB.Count_And_Get (
968: p_encoded => FND_API.G_FALSE,
969: p_count => x_msg_count,
970: p_data => x_msg_data
971: );

Line 988: FND_MSG_PUB.initialize;

984: BEGIN
985: -- Initialize message list if p_init_msg_list is set to TRUE.
986: IF FND_API.to_Boolean( p_init_msg_list )
987: THEN
988: FND_MSG_PUB.initialize;
989: END IF;
990:
991: -- Initialize API return status to SUCCESS
992: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1002: FND_MSG_PUB.Count_And_Get

998:
999: -- Debug Message
1000: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1001: -- Standard call to get message count and if count is 1, get message info.
1002: FND_MSG_PUB.Count_And_Get
1003: (p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );
1006: END Validate_offer_back_Rec;