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_PRICE_LIST_PVT dependencies on FND_MSG_PUB

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

59: );
60: END IF;
61: IF l_uk_flag = FND_API.g_false THEN
62:
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
64: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
65: FND_MSG_PUB.add;
66: END IF;
67:

Line 65: FND_MSG_PUB.add;

61: IF l_uk_flag = FND_API.g_false THEN
62:
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
64: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
65: FND_MSG_PUB.add;
66: END IF;
67:
68: x_return_status := FND_API.g_ret_sts_error;
69: RETURN;

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

80: END IF;
81:
82: IF l_uk_flag = FND_API.g_false THEN
83:
84: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
85: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
86: FND_MSG_PUB.add;
87: END IF;
88:

Line 86: FND_MSG_PUB.add;

82: IF l_uk_flag = FND_API.g_false THEN
83:
84: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
85: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
86: FND_MSG_PUB.add;
87: END IF;
88:
89: x_return_status := FND_API.g_ret_sts_error;
90: RETURN;

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

110: p_ozf_price_list_rec.qp_list_header_id
111: );
112:
113: IF l_fk_flag = FND_API.g_false THEN
114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
115: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_NO_QP_LIST');
116: FND_MSG_PUB.add;
117: END IF;
118:

Line 116: FND_MSG_PUB.add;

112:
113: IF l_fk_flag = FND_API.g_false THEN
114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
115: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_NO_QP_LIST');
116: FND_MSG_PUB.add;
117: END IF;
118:
119: x_return_status := FND_API.g_ret_sts_error;
120: RETURN;

Line 144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

140: p_lookup_type => 'OZF_PRICELIST_STATUS',
141: p_lookup_code => p_ozf_price_list_rec.status_code
142: ) = FND_API.g_false
143: THEN
144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
145: THEN
146: FND_MESSAGE.set_name('OZF', 'OZ0_CAMP_BAD_STATUS_CHANGE');
147: FND_MSG_PUB.add;
148: END IF;

Line 147: FND_MSG_PUB.add;

143: THEN
144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
145: THEN
146: FND_MESSAGE.set_name('OZF', 'OZ0_CAMP_BAD_STATUS_CHANGE');
147: FND_MSG_PUB.add;
148: END IF;
149: x_return_status := FND_API.g_ret_sts_error;
150: RETURN;
151: END IF;

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

167: /*
168: IF (p_ozf_price_list_rec.price_list_attribute_id IS NULL OR p_ozf_price_list_rec.price_list_attribute_id = FND_API.g_miss_num)
169: AND p_validation_mode = JTF_PLSQL_API.g_update
170: THEN
171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
172: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_PRICE_LIST_ATTR_ID');
173: FND_MSG_PUB.add;
174: END IF;
175:

Line 173: FND_MSG_PUB.add;

169: AND p_validation_mode = JTF_PLSQL_API.g_update
170: THEN
171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
172: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_PRICE_LIST_ATTR_ID');
173: FND_MSG_PUB.add;
174: END IF;
175:
176: x_return_status := FND_API.g_ret_sts_error;
177: RETURN;

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

179: */
180: IF (p_ozf_price_list_rec.object_version_number IS NULL OR p_ozf_price_list_rec.object_version_number = FND_API.g_miss_num)
181: AND p_validation_mode = JTF_PLSQL_API.g_update
182: THEN
183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
184: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
185: FND_MSG_PUB.add;
186: END IF;
187:

Line 185: FND_MSG_PUB.add;

181: AND p_validation_mode = JTF_PLSQL_API.g_update
182: THEN
183: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
184: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
185: FND_MSG_PUB.add;
186: END IF;
187:
188: x_return_status := FND_API.g_ret_sts_error;
189: RETURN;

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

191:
192: IF ( p_ozf_price_list_rec.qp_list_header_id IS NULL OR p_ozf_price_list_rec.qp_list_header_id = FND_API.g_miss_num )
193: AND p_validation_mode = JTF_PLSQL_API.g_create
194: THEN
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
196: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
197: FND_MSG_PUB.add;
198: END IF;
199:

Line 197: FND_MSG_PUB.add;

193: AND p_validation_mode = JTF_PLSQL_API.g_create
194: THEN
195: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
196: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
197: FND_MSG_PUB.add;
198: END IF;
199:
200: x_return_status := FND_API.g_ret_sts_error;
201: RETURN;

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

203:
204: IF ( p_ozf_price_list_rec.status_code IS NULL OR p_ozf_price_list_rec.status_code = FND_API.g_miss_char )
205: AND p_validation_mode = JTF_PLSQL_API.g_create
206: THEN
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
208: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_STATUS_CODE');
209: FND_MSG_PUB.add;
210: END IF;
211:

Line 209: FND_MSG_PUB.add;

205: AND p_validation_mode = JTF_PLSQL_API.g_create
206: THEN
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
208: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_STATUS_CODE');
209: FND_MSG_PUB.add;
210: END IF;
211:
212: x_return_status := FND_API.g_ret_sts_error;
213: RETURN;

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

215:
216: IF ( p_ozf_price_list_rec.owner_id IS NULL OR p_ozf_price_list_rec.owner_id = FND_API.g_miss_num )
217: AND p_validation_mode = JTF_PLSQL_API.g_create
218: THEN
219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
220: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_OWNER_ID');
221: FND_MSG_PUB.add;
222: END IF;
223:

Line 221: FND_MSG_PUB.add;

217: AND p_validation_mode = JTF_PLSQL_API.g_create
218: THEN
219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
220: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_OWNER_ID');
221: FND_MSG_PUB.add;
222: END IF;
223:
224: x_return_status := FND_API.g_ret_sts_error;
225: RETURN;

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

227:
228: IF ( p_ozf_price_list_rec.user_status_id IS NULL OR p_ozf_price_list_rec.user_status_id = FND_API.g_miss_num )
229: AND p_validation_mode = JTF_PLSQL_API.g_create
230: THEN
231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
232: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_USER_STATUS_ID');
233: FND_MSG_PUB.add;
234: END IF;
235:

Line 233: FND_MSG_PUB.add;

229: AND p_validation_mode = JTF_PLSQL_API.g_create
230: THEN
231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
232: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_USER_STATUS_ID');
233: FND_MSG_PUB.add;
234: END IF;
235:
236: x_return_status := FND_API.g_ret_sts_error;
237: RETURN;

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

239:
240: IF ( p_ozf_price_list_rec.custom_setup_id IS NULL OR p_ozf_price_list_rec.custom_setup_id = FND_API.g_miss_num )
241: AND p_validation_mode = JTF_PLSQL_API.g_create
242: THEN
243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
244: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_CUSTOM_SETUP_ID');
245: FND_MSG_PUB.add;
246: END IF;
247:

Line 245: FND_MSG_PUB.add;

241: AND p_validation_mode = JTF_PLSQL_API.g_create
242: THEN
243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
244: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_CUSTOM_SETUP_ID');
245: FND_MSG_PUB.add;
246: END IF;
247:
248: x_return_status := FND_API.g_ret_sts_error;
249: RETURN;

Line 323: FND_MSG_PUB.initialize;

319: BEGIN
320:
321: IF FND_API.to_Boolean( p_init_msg_list )
322: THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325: NULL;
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:

Line 328: FND_MSG_PUB.Count_And_Get

324: END IF;
325: NULL;
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: FND_MSG_PUB.Count_And_Get
329: (p_count => x_msg_count,
330: p_data => x_msg_data
331: );
332: END Validate_OZF_PRICE_LIST_Rec;

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

352: FETCH c_ozf_price_list INTO l_price_list_rec;
353:
354: IF (c_ozf_price_list%NOTFOUND) THEN
355: CLOSE c_ozf_price_list;
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
357: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
358: FND_MSG_PUB.add;
359: END IF;
360: RAISE FND_API.g_exc_error;

Line 358: FND_MSG_PUB.add;

354: IF (c_ozf_price_list%NOTFOUND) THEN
355: CLOSE c_ozf_price_list;
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
357: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
358: FND_MSG_PUB.add;
359: END IF;
360: RAISE FND_API.g_exc_error;
361: END IF;
362: CLOSE c_ozf_price_list;

Line 459: FND_MSG_PUB.initialize;

455: END IF;
456:
457: IF FND_API.to_Boolean( p_init_msg_list )
458: THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: If p_validation_mode = 'UPDATE' THEN
463: Complete_OZF_PRICE_LIST_Rec(

Line 504: FND_MSG_PUB.Count_And_Get

500: -- Initialize API return status to SUCCESS
501: x_return_status := FND_API.G_RET_STS_SUCCESS;
502:
503: -- Standard call to get message count and if count is 1, get message info.
504: FND_MSG_PUB.Count_And_Get
505: (p_count => x_msg_count,
506: p_data => x_msg_data
507: );
508: EXCEPTION

Line 513: FND_MSG_PUB.Count_And_Get (

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

Line 522: FND_MSG_PUB.Count_And_Get (

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

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

526: );
527: WHEN OTHERS THEN
528: ROLLBACK TO VALIDATE_PRICE_LIST_;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
533: END IF;
534: -- Standard call to get message count and if count=1, get the message

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

528: ROLLBACK TO VALIDATE_PRICE_LIST_;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
533: END IF;
534: -- Standard call to get message count and if count=1, get the message
535: FND_MSG_PUB.Count_And_Get (
536: p_encoded => FND_API.G_FALSE,

Line 535: FND_MSG_PUB.Count_And_Get (

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

Line 608: FND_MSG_PUB.initialize;

604:
605:
606: IF FND_API.to_Boolean( p_init_msg_list )
607: THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:

Line 686: FND_MSG_PUB.Count_And_Get

682: COMMIT WORK;
683: END IF;
684: x_price_list_attribute_id := l_price_list_attribute_id;
685:
686: FND_MSG_PUB.Count_And_Get
687: (p_count => x_msg_count,
688: p_data => x_msg_data
689: );
690: EXCEPTION

Line 695: FND_MSG_PUB.Count_And_Get (

691: WHEN FND_API.G_EXC_ERROR THEN
692: ROLLBACK TO CREATE_PRICE_LIST_PVT;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
699: );

Line 704: FND_MSG_PUB.Count_And_Get (

700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO CREATE_PRICE_LIST_PVT;
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: -- Standard call to get message count and if count=1, get the message
704: FND_MSG_PUB.Count_And_Get (
705: p_encoded => FND_API.G_FALSE,
706: p_count => x_msg_count,
707: p_data => x_msg_data
708: );

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

708: );
709: WHEN OTHERS THEN
710: ROLLBACK TO CREATE_PRICE_LIST_PVT;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;
716: -- Standard call to get message count and if count=1, get the message

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

710: ROLLBACK TO CREATE_PRICE_LIST_PVT;
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;
716: -- Standard call to get message count and if count=1, get the message
717: FND_MSG_PUB.Count_And_Get (
718: p_encoded => FND_API.G_FALSE,

Line 717: FND_MSG_PUB.Count_And_Get (

713: THEN
714: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
715: END IF;
716: -- Standard call to get message count and if count=1, get the message
717: FND_MSG_PUB.Count_And_Get (
718: p_encoded => FND_API.G_FALSE,
719: p_count => x_msg_count,
720: p_data => x_msg_data
721: );

Line 765: FND_MSG_PUB.initialize;

761:
762:
763: IF FND_API.to_Boolean( p_init_msg_list )
764: THEN
765: FND_MSG_PUB.initialize;
766: END IF;
767:
768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769:

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

807: where qp_list_header_id = p_OZF_PRICE_LIST_rec.qp_list_header_id
808: and object_version_number = p_OZF_PRICE_LIST_rec.object_version_number;
809:
810: IF (SQL%NOTFOUND) THEN
811: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
812: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
813: FND_MSG_PUB.add;
814: END IF;
815: RAISE FND_API.g_exc_error;

Line 813: FND_MSG_PUB.add;

809:
810: IF (SQL%NOTFOUND) THEN
811: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
812: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
813: FND_MSG_PUB.add;
814: END IF;
815: RAISE FND_API.g_exc_error;
816: END IF;
817: END IF;

Line 826: FND_MSG_PUB.Count_And_Get

822: THEN
823: COMMIT WORK;
824: END IF;
825:
826: FND_MSG_PUB.Count_And_Get
827: (p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830: EXCEPTION

Line 835: FND_MSG_PUB.Count_And_Get (

831: WHEN FND_API.G_EXC_ERROR THEN
832: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
833: x_return_status := FND_API.G_RET_STS_ERROR;
834:
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );

Line 844: FND_MSG_PUB.Count_And_Get (

840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
841: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
843:
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
848: );

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

848: );
849: WHEN OTHERS THEN
850: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856:

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

850: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856:
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,

Line 857: FND_MSG_PUB.Count_And_Get (

853: THEN
854: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
855: END IF;
856:
857: FND_MSG_PUB.Count_And_Get (
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data
861: );

Line 898: FND_MSG_PUB.initialize;

894:
895:
896: IF FND_API.to_Boolean( p_init_msg_list )
897: THEN
898: FND_MSG_PUB.initialize;
899: END IF;
900:
901: x_return_status := FND_API.G_RET_STS_SUCCESS;
902:

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

904: WHERE PRICE_LIST_ATTRIBUTE_ID = p_PRICE_LIST_ATTRIBUTE_ID
905: AND object_version_number = p_object_version_number;
906:
907: IF (SQL%NOTFOUND) THEN
908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
909: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
910: FND_MSG_PUB.add;
911: END IF;
912: RAISE FND_API.g_exc_error;

Line 910: FND_MSG_PUB.add;

906:
907: IF (SQL%NOTFOUND) THEN
908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
909: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
910: FND_MSG_PUB.add;
911: END IF;
912: RAISE FND_API.g_exc_error;
913: END IF;
914:

Line 922: FND_MSG_PUB.Count_And_Get

918: THEN
919: COMMIT WORK;
920: END IF;
921:
922: FND_MSG_PUB.Count_And_Get
923: (p_count => x_msg_count,
924: p_data => x_msg_data
925: );
926: EXCEPTION

Line 930: FND_MSG_PUB.Count_And_Get (

926: EXCEPTION
927: WHEN FND_API.G_EXC_ERROR THEN
928: ROLLBACK TO DELETE_PRICE_LIST_PVT;
929: x_return_status := FND_API.G_RET_STS_ERROR;
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: );

Line 938: FND_MSG_PUB.Count_And_Get (

934: );
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO DELETE_PRICE_LIST_PVT;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_And_Get (
939: p_encoded => FND_API.G_FALSE,
940: p_count => x_msg_count,
941: p_data => x_msg_data
942: );

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

942: );
943: WHEN OTHERS THEN
944: ROLLBACK TO DELETE_PRICE_LIST_PVT;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
949: END IF;
950: FND_MSG_PUB.Count_And_Get (

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

944: ROLLBACK TO DELETE_PRICE_LIST_PVT;
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
949: END IF;
950: FND_MSG_PUB.Count_And_Get (
951: p_encoded => FND_API.G_FALSE,
952: p_count => x_msg_count,

Line 950: FND_MSG_PUB.Count_And_Get (

946: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
949: END IF;
950: FND_MSG_PUB.Count_And_Get (
951: p_encoded => FND_API.G_FALSE,
952: p_count => x_msg_count,
953: p_data => x_msg_data
954: );