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 50: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

46: );
47: END IF;
48: IF l_uk_flag = FND_API.g_false THEN
49:
50: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
51: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
52: FND_MSG_PUB.add;
53: END IF;
54:

Line 52: FND_MSG_PUB.add;

48: IF l_uk_flag = FND_API.g_false THEN
49:
50: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
51: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
52: FND_MSG_PUB.add;
53: END IF;
54:
55: x_return_status := FND_API.g_ret_sts_error;
56: RETURN;

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

67: END IF;
68:
69: IF l_uk_flag = FND_API.g_false THEN
70:
71: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
72: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
73: FND_MSG_PUB.add;
74: END IF;
75:

Line 73: FND_MSG_PUB.add;

69: IF l_uk_flag = FND_API.g_false THEN
70:
71: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
72: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_DUP_PK');
73: FND_MSG_PUB.add;
74: END IF;
75:
76: x_return_status := FND_API.g_ret_sts_error;
77: RETURN;

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

97: p_ozf_price_list_rec.qp_list_header_id
98: );
99:
100: IF l_fk_flag = FND_API.g_false THEN
101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
102: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_NO_QP_LIST');
103: FND_MSG_PUB.add;
104: END IF;
105:

Line 103: FND_MSG_PUB.add;

99:
100: IF l_fk_flag = FND_API.g_false THEN
101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
102: FND_MESSAGE.set_name('OZF', 'OZF_PRICE_LIST_NO_QP_LIST');
103: FND_MSG_PUB.add;
104: END IF;
105:
106: x_return_status := FND_API.g_ret_sts_error;
107: RETURN;

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

127: p_lookup_type => 'OZF_PRICELIST_STATUS',
128: p_lookup_code => p_ozf_price_list_rec.status_code
129: ) = FND_API.g_false
130: THEN
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN
133: FND_MESSAGE.set_name('OZF', 'OZ0_CAMP_BAD_STATUS_CHANGE');
134: FND_MSG_PUB.add;
135: END IF;

Line 134: FND_MSG_PUB.add;

130: THEN
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN
133: FND_MESSAGE.set_name('OZF', 'OZ0_CAMP_BAD_STATUS_CHANGE');
134: FND_MSG_PUB.add;
135: END IF;
136: x_return_status := FND_API.g_ret_sts_error;
137: RETURN;
138: END IF;

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

154: /*
155: 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)
156: AND p_validation_mode = JTF_PLSQL_API.g_update
157: THEN
158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
159: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_PRICE_LIST_ATTR_ID');
160: FND_MSG_PUB.add;
161: END IF;
162:

Line 160: FND_MSG_PUB.add;

156: AND p_validation_mode = JTF_PLSQL_API.g_update
157: THEN
158: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
159: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_PRICE_LIST_ATTR_ID');
160: FND_MSG_PUB.add;
161: END IF;
162:
163: x_return_status := FND_API.g_ret_sts_error;
164: RETURN;

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

166: */
167: 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)
168: AND p_validation_mode = JTF_PLSQL_API.g_update
169: THEN
170: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
171: FND_MESSAGE.set_name('OZF', 'OZF_API_NO_OBJ_VER_NUM');
172: FND_MSG_PUB.add;
173: END IF;
174:

Line 172: FND_MSG_PUB.add;

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

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

178:
179: 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 )
180: AND p_validation_mode = JTF_PLSQL_API.g_create
181: THEN
182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
183: FND_MESSAGE.set_name('OZF', 'OZF_ACT_OFFER_NO_LIST_HEAD_ID');
184: FND_MSG_PUB.add;
185: END IF;
186:

Line 184: FND_MSG_PUB.add;

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

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

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

Line 196: FND_MSG_PUB.add;

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

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

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

Line 208: FND_MSG_PUB.add;

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

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

214:
215: 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 )
216: AND p_validation_mode = JTF_PLSQL_API.g_create
217: THEN
218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
219: FND_MESSAGE.set_name('OZF', 'OZF_CAMP_NO_USER_STATUS_ID');
220: FND_MSG_PUB.add;
221: END IF;
222:

Line 220: FND_MSG_PUB.add;

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

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

226:
227: 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 )
228: AND p_validation_mode = JTF_PLSQL_API.g_create
229: THEN
230: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
231: FND_MESSAGE.set_name('OZF', 'OZF_PRIC_NO_CUSTOM_SETUP_ID');
232: FND_MSG_PUB.add;
233: END IF;
234:

Line 232: FND_MSG_PUB.add;

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

Line 310: FND_MSG_PUB.initialize;

306: BEGIN
307:
308: IF FND_API.to_Boolean( p_init_msg_list )
309: THEN
310: FND_MSG_PUB.initialize;
311: END IF;
312: NULL;
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:

Line 315: FND_MSG_PUB.Count_And_Get

311: END IF;
312: NULL;
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: FND_MSG_PUB.Count_And_Get
316: (p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319: END Validate_OZF_PRICE_LIST_Rec;

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

339: FETCH c_ozf_price_list INTO l_price_list_rec;
340:
341: IF (c_ozf_price_list%NOTFOUND) THEN
342: CLOSE c_ozf_price_list;
343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
344: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
345: FND_MSG_PUB.add;
346: END IF;
347: RAISE FND_API.g_exc_error;

Line 345: FND_MSG_PUB.add;

341: IF (c_ozf_price_list%NOTFOUND) THEN
342: CLOSE c_ozf_price_list;
343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
344: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
345: FND_MSG_PUB.add;
346: END IF;
347: RAISE FND_API.g_exc_error;
348: END IF;
349: CLOSE c_ozf_price_list;

Line 446: FND_MSG_PUB.initialize;

442: END IF;
443:
444: IF FND_API.to_Boolean( p_init_msg_list )
445: THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: If p_validation_mode = 'UPDATE' THEN
450: Complete_OZF_PRICE_LIST_Rec(

Line 491: FND_MSG_PUB.Count_And_Get

487: -- Initialize API return status to SUCCESS
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: -- Standard call to get message count and if count is 1, get message info.
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495: EXCEPTION

Line 500: FND_MSG_PUB.Count_And_Get (

496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO VALIDATE_PRICE_LIST_;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data
504: );

Line 509: FND_MSG_PUB.Count_And_Get (

505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO VALIDATE_PRICE_LIST_;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );

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

513: );
514: WHEN OTHERS THEN
515: ROLLBACK TO VALIDATE_PRICE_LIST_;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
520: END IF;
521: -- Standard call to get message count and if count=1, get the message

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

515: ROLLBACK TO VALIDATE_PRICE_LIST_;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
520: END IF;
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,

Line 522: FND_MSG_PUB.Count_And_Get (

518: THEN
519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
520: END IF;
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 595: FND_MSG_PUB.initialize;

591:
592:
593: IF FND_API.to_Boolean( p_init_msg_list )
594: THEN
595: FND_MSG_PUB.initialize;
596: END IF;
597:
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599:

Line 673: FND_MSG_PUB.Count_And_Get

669: COMMIT WORK;
670: END IF;
671: x_price_list_attribute_id := l_price_list_attribute_id;
672:
673: FND_MSG_PUB.Count_And_Get
674: (p_count => x_msg_count,
675: p_data => x_msg_data
676: );
677: EXCEPTION

Line 682: FND_MSG_PUB.Count_And_Get (

678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO CREATE_PRICE_LIST_PVT;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
686: );

Line 691: FND_MSG_PUB.Count_And_Get (

687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO CREATE_PRICE_LIST_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );

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

695: );
696: WHEN OTHERS THEN
697: ROLLBACK TO CREATE_PRICE_LIST_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
700: THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
702: END IF;
703: -- Standard call to get message count and if count=1, get the message

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

697: ROLLBACK TO CREATE_PRICE_LIST_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
700: THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
702: END IF;
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,

Line 704: FND_MSG_PUB.Count_And_Get (

700: THEN
701: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
702: END IF;
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 752: FND_MSG_PUB.initialize;

748:
749:
750: IF FND_API.to_Boolean( p_init_msg_list )
751: THEN
752: FND_MSG_PUB.initialize;
753: END IF;
754:
755: x_return_status := FND_API.G_RET_STS_SUCCESS;
756:

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

794: where qp_list_header_id = p_OZF_PRICE_LIST_rec.qp_list_header_id
795: and object_version_number = p_OZF_PRICE_LIST_rec.object_version_number;
796:
797: IF (SQL%NOTFOUND) THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
799: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
800: FND_MSG_PUB.add;
801: END IF;
802: RAISE FND_API.g_exc_error;

Line 800: FND_MSG_PUB.add;

796:
797: IF (SQL%NOTFOUND) THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
799: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
800: FND_MSG_PUB.add;
801: END IF;
802: RAISE FND_API.g_exc_error;
803: END IF;
804: END IF;

Line 813: FND_MSG_PUB.Count_And_Get

809: THEN
810: COMMIT WORK;
811: END IF;
812:
813: FND_MSG_PUB.Count_And_Get
814: (p_count => x_msg_count,
815: p_data => x_msg_data
816: );
817: EXCEPTION

Line 822: FND_MSG_PUB.Count_And_Get (

818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821:
822: FND_MSG_PUB.Count_And_Get (
823: p_encoded => FND_API.G_FALSE,
824: p_count => x_msg_count,
825: p_data => x_msg_data
826: );

Line 831: FND_MSG_PUB.Count_And_Get (

827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830:
831: FND_MSG_PUB.Count_And_Get (
832: p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,
834: p_data => x_msg_data
835: );

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

835: );
836: WHEN OTHERS THEN
837: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843:

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

837: ROLLBACK TO UPDATE_PRICE_LIST_PVT;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843:
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,

Line 844: FND_MSG_PUB.Count_And_Get (

840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
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 885: FND_MSG_PUB.initialize;

881:
882:
883: IF FND_API.to_Boolean( p_init_msg_list )
884: THEN
885: FND_MSG_PUB.initialize;
886: END IF;
887:
888: x_return_status := FND_API.G_RET_STS_SUCCESS;
889:

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

891: WHERE PRICE_LIST_ATTRIBUTE_ID = p_PRICE_LIST_ATTRIBUTE_ID
892: AND object_version_number = p_object_version_number;
893:
894: IF (SQL%NOTFOUND) THEN
895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
896: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
897: FND_MSG_PUB.add;
898: END IF;
899: RAISE FND_API.g_exc_error;

Line 897: FND_MSG_PUB.add;

893:
894: IF (SQL%NOTFOUND) THEN
895: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
896: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
897: FND_MSG_PUB.add;
898: END IF;
899: RAISE FND_API.g_exc_error;
900: END IF;
901:

Line 909: FND_MSG_PUB.Count_And_Get

905: THEN
906: COMMIT WORK;
907: END IF;
908:
909: FND_MSG_PUB.Count_And_Get
910: (p_count => x_msg_count,
911: p_data => x_msg_data
912: );
913: EXCEPTION

Line 917: FND_MSG_PUB.Count_And_Get (

913: EXCEPTION
914: WHEN FND_API.G_EXC_ERROR THEN
915: ROLLBACK TO DELETE_PRICE_LIST_PVT;
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );

Line 925: FND_MSG_PUB.Count_And_Get (

921: );
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923: ROLLBACK TO DELETE_PRICE_LIST_PVT;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data
929: );

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

929: );
930: WHEN OTHERS THEN
931: ROLLBACK TO DELETE_PRICE_LIST_PVT;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
936: END IF;
937: FND_MSG_PUB.Count_And_Get (

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

931: ROLLBACK TO DELETE_PRICE_LIST_PVT;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
936: END IF;
937: FND_MSG_PUB.Count_And_Get (
938: p_encoded => FND_API.G_FALSE,
939: p_count => x_msg_count,

Line 937: FND_MSG_PUB.Count_And_Get (

933: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
936: END IF;
937: FND_MSG_PUB.Count_And_Get (
938: p_encoded => FND_API.G_FALSE,
939: p_count => x_msg_count,
940: p_data => x_msg_data
941: );