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.AMV_CONTENT_TYPE_PVT dependencies on FND_MSG_PUB

Line 89: FND_MSG_PUB.initialize;

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: --Initialize message list if p_init_msg_list is TRUE.
88: IF FND_API.To_Boolean (p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: -- Get the current (login) user id.

Line 104: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

100: IF (p_check_login_user = FND_API.G_TRUE) THEN
101: -- Check if user is login and has the required privilege.
102: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
103: -- User is not login.
104: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
105: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
106: FND_MSG_PUB.Add;
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;

Line 106: FND_MSG_PUB.Add;

102: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
103: -- User is not login.
104: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
105: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
106: FND_MSG_PUB.Add;
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110: AMV_USER_PVT.Is_Administrator

Line 122: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

118: x_result_flag => l_admin_flag
119: );
120: IF (l_admin_flag <> FND_API.G_TRUE) THEN
121: -- User is not an administrator.
122: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
123: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
124: FND_MSG_PUB.Add;
125: END IF;
126: RAISE FND_API.G_EXC_ERROR;

Line 124: FND_MSG_PUB.Add;

120: IF (l_admin_flag <> FND_API.G_TRUE) THEN
121: -- User is not an administrator.
122: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
123: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
124: FND_MSG_PUB.Add;
125: END IF;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128: END IF;

Line 139: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

135: FETCH Check_DupContTypeName_csr Into l_content_type_id;
136: IF Check_DupContTypeName_csr%FOUND THEN
137: -- The name is already used
138: CLOSE Check_DupContTypeName_csr;
139: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
140: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');
141: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
142: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
143: FND_MSG_PUB.Add;

Line 143: FND_MSG_PUB.Add;

139: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
140: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');
141: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
142: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
143: FND_MSG_PUB.Add;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: CLOSE Check_DupContTypeName_csr;

Line 177: FND_MSG_PUB.Count_And_Get (

173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END IF;
176: --Standard call to get message count and if count=1, get the message
177: FND_MSG_PUB.Count_And_Get (
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data
181: );

Line 187: FND_MSG_PUB.Count_And_Get (

183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO Add_ContentType_Pvt;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
191: );

Line 196: FND_MSG_PUB.Count_And_Get (

192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: ROLLBACK TO Add_ContentType_Pvt;
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: -- Standard call to get message count and if count=1, get the message
196: FND_MSG_PUB.Count_And_Get (
197: p_encoded => FND_API.G_FALSE,
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );

Line 204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

200: );
201: WHEN OTHERS THEN
202: ROLLBACK TO Add_ContentType_Pvt;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
205: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
206: END IF;
207: -- Standard call to get message count and if count=1, get the message
208: FND_MSG_PUB.Count_And_Get (

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

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

Line 208: FND_MSG_PUB.Count_And_Get (

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

Line 258: FND_MSG_PUB.initialize;

254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: --Initialize message list if p_init_msg_list is TRUE.
257: IF FND_API.To_Boolean (p_init_msg_list) THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260: -- Initialize API return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262: -- Get the current (login) user id.

Line 273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

269: IF (p_check_login_user = FND_API.G_TRUE) THEN
270: -- Check if user is login and has the required privilege.
271: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
272: -- User is not login.
273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
275: FND_MSG_PUB.Add;
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;

Line 275: FND_MSG_PUB.Add;

271: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
272: -- User is not login.
273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
275: FND_MSG_PUB.Add;
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: AMV_USER_PVT.Is_Administrator

Line 291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

287: x_result_flag => l_admin_flag
288: );
289: IF (l_admin_flag <> FND_API.G_TRUE) THEN
290: -- User is not an administrator.
291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
293: FND_MSG_PUB.Add;
294: END IF;
295: RAISE FND_API.G_EXC_ERROR;

Line 293: FND_MSG_PUB.Add;

289: IF (l_admin_flag <> FND_API.G_TRUE) THEN
290: -- User is not an administrator.
291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
293: FND_MSG_PUB.Add;
294: END IF;
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: END IF;

Line 308: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

304: -- Check if user pass the valid content type id
305: IF AMV_UTILITY_PVT.Is_ContentTypeIdValid(p_content_type_id) = TRUE THEN
306: l_content_type_id := p_content_type_id;
307: ELSE
308: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
309: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
310: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
311: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
312: FND_MSG_PUB.Add;

Line 312: FND_MSG_PUB.Add;

308: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
309: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
310: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
311: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
312: FND_MSG_PUB.Add;
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN

Line 321: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

317: OPEN Check_ValidContTypeName_csr(p_content_type_name);
318: FETCH Check_ValidContTypeName_csr Into l_content_type_id;
319: IF (Check_ValidContTypeName_csr%NOTFOUND) THEN
320: CLOSE Check_ValidContTypeName_csr;
321: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
322: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
323: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
324: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
325: FND_MSG_PUB.Add;

Line 325: FND_MSG_PUB.Add;

321: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
322: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
323: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
324: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
325: FND_MSG_PUB.Add;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329: CLOSE Check_ValidContTypeName_csr;

Line 331: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329: CLOSE Check_ValidContTypeName_csr;
330: ELSE
331: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
333: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
334: FND_MSG_PUB.Add;
335: END IF;

Line 334: FND_MSG_PUB.Add;

330: ELSE
331: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
333: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
334: FND_MSG_PUB.Add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: --

Line 344: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

340: OPEN Get_Item_csr (l_content_type_id);
341: FETCH Get_Item_csr INTO l_item_id;
342: IF (Get_Item_csr%FOUND) THEN
343: CLOSE Get_Item_csr;
344: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MESSAGE.Set_name('AMV','AMV_ITEM_USING_ATTR');
346: FND_MESSAGE.Set_Token('RECORDID', TO_CHAR(l_item_id) );
347: FND_MSG_PUB.Add;
348: END IF;

Line 347: FND_MSG_PUB.Add;

343: CLOSE Get_Item_csr;
344: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MESSAGE.Set_name('AMV','AMV_ITEM_USING_ATTR');
346: FND_MESSAGE.Set_Token('RECORDID', TO_CHAR(l_item_id) );
347: FND_MSG_PUB.Add;
348: END IF;
349: RAISE FND_API.G_EXC_ERROR;
350: ELSE
351: CLOSE Get_Item_csr;

Line 366: FND_MSG_PUB.Count_And_Get (

362: IF FND_API.To_Boolean ( p_commit ) THEN
363: COMMIT WORK;
364: END IF;
365: --Standard call to get message count and if count=1, get the message
366: FND_MSG_PUB.Count_And_Get (
367: p_encoded => FND_API.G_FALSE,
368: p_count => x_msg_count,
369: p_data => x_msg_data
370: );

Line 376: FND_MSG_PUB.Count_And_Get (

372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO Delete_ContentType_Pvt;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: -- Standard call to get message count and if count=1, get the message
376: FND_MSG_PUB.Count_And_Get (
377: p_encoded => FND_API.G_FALSE,
378: p_count => x_msg_count,
379: p_data => x_msg_data
380: );

Line 385: FND_MSG_PUB.Count_And_Get (

381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: ROLLBACK TO Delete_ContentType_Pvt;
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: -- Standard call to get message count and if count=1, get the message
385: FND_MSG_PUB.Count_And_Get (
386: p_encoded => FND_API.G_FALSE,
387: p_count => x_msg_count,
388: p_data => x_msg_data
389: );

Line 393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

389: );
390: WHEN OTHERS THEN
391: ROLLBACK TO Delete_ContentType_Pvt;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
395: END IF;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (

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

390: WHEN OTHERS THEN
391: ROLLBACK TO Delete_ContentType_Pvt;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
395: END IF;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,

Line 397: FND_MSG_PUB.Count_And_Get (

393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
395: END IF;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );

Line 450: FND_MSG_PUB.initialize;

446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447: END IF;
448: --Initialize message list if p_init_msg_list is TRUE.
449: IF FND_API.To_Boolean (p_init_msg_list) THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452: -- Initialize API return status to success
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454: -- Get the current (login) user id.

Line 465: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

461: IF (p_check_login_user = FND_API.G_TRUE) THEN
462: -- Check if user is login and has the required privilege.
463: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
464: -- User is not login.
465: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
466: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
467: FND_MSG_PUB.Add;
468: END IF;
469: RAISE FND_API.G_EXC_ERROR;

Line 467: FND_MSG_PUB.Add;

463: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
464: -- User is not login.
465: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
466: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
467: FND_MSG_PUB.Add;
468: END IF;
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471: AMV_USER_PVT.Is_Administrator

Line 483: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

479: x_result_flag => l_admin_flag
480: );
481: IF (l_admin_flag <> FND_API.G_TRUE) THEN
482: -- User is not an administrator.
483: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
484: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
485: FND_MSG_PUB.Add;
486: END IF;
487: RAISE FND_API.G_EXC_ERROR;

Line 485: FND_MSG_PUB.Add;

481: IF (l_admin_flag <> FND_API.G_TRUE) THEN
482: -- User is not an administrator.
483: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
484: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
485: FND_MSG_PUB.Add;
486: END IF;
487: RAISE FND_API.G_EXC_ERROR;
488: END IF;
489: END IF;

Line 500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

496: OPEN Check_DupContTypeName_csr(p_content_type_new_name);
497: FETCH Check_DupContTypeName_csr INTO l_content_type_id;
498: IF Check_DupContTypeName_csr%FOUND THEN
499: CLOSE Check_DupContTypeName_csr;
500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
501: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');
502: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
503: FND_MESSAGE.Set_Token('NAME', p_content_type_new_name);
504: FND_MSG_PUB.Add;

Line 504: FND_MSG_PUB.Add;

500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
501: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');
502: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
503: FND_MESSAGE.Set_Token('NAME', p_content_type_new_name);
504: FND_MSG_PUB.Add;
505: END IF;
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;
508: CLOSE Check_DupContTypeName_csr;

Line 515: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

511: -- Check if user pass the valid content type id
512: IF AMV_UTILITY_PVT.Is_ContentTypeIdValid(p_content_type_id) = TRUE THEN
513: l_content_type_id := p_content_type_id;
514: ELSE
515: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
516: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
517: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
518: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
519: FND_MSG_PUB.Add;

Line 519: FND_MSG_PUB.Add;

515: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
516: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
517: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
518: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
519: FND_MSG_PUB.Add;
520: END IF;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN

Line 528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

524: OPEN Check_ValidContTypeName_csr(p_content_type_name);
525: FETCH Check_ValidContTypeName_csr Into l_content_type_id;
526: IF (Check_ValidContTypeName_csr%NOTFOUND) THEN
527: CLOSE Check_ValidContTypeName_csr;
528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
529: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
530: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
531: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
532: FND_MSG_PUB.Add;

Line 532: FND_MSG_PUB.Add;

528: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
529: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
530: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
531: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
532: FND_MSG_PUB.Add;
533: END IF;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: CLOSE Check_ValidContTypeName_csr;

Line 538: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536: CLOSE Check_ValidContTypeName_csr;
537: ELSE
538: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
540: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
541: FND_MSG_PUB.Add;
542: END IF;

Line 541: FND_MSG_PUB.Add;

537: ELSE
538: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
539: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
540: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
541: FND_MSG_PUB.Add;
542: END IF;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545: -- Get the current version number

Line 550: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

546: OPEN Get_Version_csr(l_content_type_id);
547: FETCH Get_Version_csr INTO l_object_version;
548: CLOSE Get_Version_csr;
549: -- Debug Message
550: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
551: FND_MESSAGE.Set_name('AMV','Updating Content Type.');
552: FND_MSG_PUB.Add;
553: END IF;
554: -- Now do the updating:

Line 552: FND_MSG_PUB.Add;

548: CLOSE Get_Version_csr;
549: -- Debug Message
550: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
551: FND_MESSAGE.Set_name('AMV','Updating Content Type.');
552: FND_MSG_PUB.Add;
553: END IF;
554: -- Now do the updating:
555: AMV_I_CONTENT_TYPES_PKG.UPDATE_ROW
556: (

Line 570: FND_MSG_PUB.Count_And_Get (

566: IF FND_API.To_Boolean ( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: --Standard call to get message count and if count=1, get the message
570: FND_MSG_PUB.Count_And_Get (
571: p_encoded => FND_API.G_FALSE,
572: p_count => x_msg_count,
573: p_data => x_msg_data
574: );

Line 580: FND_MSG_PUB.Count_And_Get (

576: WHEN FND_API.G_EXC_ERROR THEN
577: ROLLBACK TO Update_ContentType_Pvt;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: -- Standard call to get message count and if count=1, get the message
580: FND_MSG_PUB.Count_And_Get (
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );

Line 589: FND_MSG_PUB.Count_And_Get (

585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: ROLLBACK TO Update_ContentType_Pvt;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data
593: );

Line 597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

593: );
594: WHEN OTHERS THEN
595: ROLLBACK TO Update_ContentType_Pvt;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (

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

594: WHEN OTHERS THEN
595: ROLLBACK TO Update_ContentType_Pvt;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,

Line 601: FND_MSG_PUB.Count_And_Get (

597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );

Line 662: FND_MSG_PUB.initialize;

658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660: --Initialize message list if p_init_msg_list is TRUE.
661: IF FND_API.To_Boolean (p_init_msg_list) THEN
662: FND_MSG_PUB.initialize;
663: END IF;
664: -- Initialize API return status to success
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666: -- Get the current (login) user id.

Line 677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

673: IF (p_check_login_user = FND_API.G_TRUE) THEN
674: -- Check if user is login and has the required privilege.
675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
676: -- User is not login.
677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
679: FND_MSG_PUB.Add;
680: END IF;
681: RAISE FND_API.G_EXC_ERROR;

Line 679: FND_MSG_PUB.Add;

675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
676: -- User is not login.
677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
679: FND_MSG_PUB.Add;
680: END IF;
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683: END IF;

Line 694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

690: -- Check if user pass the valid content type id
691: IF AMV_UTILITY_PVT.Is_ContentTypeIdValid(p_content_type_id) = TRUE THEN
692: l_content_type_id := p_content_type_id;
693: ELSE
694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
696: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
697: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
698: FND_MSG_PUB.Add;

Line 698: FND_MSG_PUB.Add;

694: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
695: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
696: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
697: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
698: FND_MSG_PUB.Add;
699: END IF;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN

Line 707: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

703: OPEN Check_ValidContTypeName_csr(p_content_type_name);
704: FETCH Check_ValidContTypeName_csr Into l_content_type_id;
705: IF (Check_ValidContTypeName_csr%NOTFOUND) THEN
706: CLOSE Check_ValidContTypeName_csr;
707: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
708: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
709: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
710: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
711: FND_MSG_PUB.Add;

Line 711: FND_MSG_PUB.Add;

707: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
708: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
709: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
710: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
711: FND_MSG_PUB.Add;
712: END IF;
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715: CLOSE Check_ValidContTypeName_csr;

Line 717: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715: CLOSE Check_ValidContTypeName_csr;
716: ELSE
717: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
718: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
719: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
720: FND_MSG_PUB.Add;
721: END IF;

Line 720: FND_MSG_PUB.Add;

716: ELSE
717: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
718: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
719: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
720: FND_MSG_PUB.Add;
721: END IF;
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724: -- Now query and return the content type record

Line 729: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

725: OPEN Get_CntTypeRecord_csr(l_content_type_id);
726: FETCH Get_CntTypeRecord_csr INTO l_content_type_rec;
727: IF (Get_CntTypeRecord_csr%NOTFOUND) THEN
728: CLOSE Get_CntTypeRecord_csr;
729: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
730: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NOT_FOUND');
731: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
732: FND_MSG_PUB.Add;
733: END IF;

Line 732: FND_MSG_PUB.Add;

728: CLOSE Get_CntTypeRecord_csr;
729: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
730: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NOT_FOUND');
731: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
732: FND_MSG_PUB.Add;
733: END IF;
734: RAISE FND_API.G_EXC_ERROR;
735: ELSE
736: x_content_type_obj.content_type_id := l_content_type_rec.content_type_id;

Line 766: FND_MSG_PUB.Count_And_Get (

762: */
763: END IF;
764: CLOSE Get_CntTypeRecord_csr;
765: --Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );

Line 775: FND_MSG_PUB.Count_And_Get (

771: EXCEPTION
772: WHEN FND_API.G_EXC_ERROR THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );

Line 783: FND_MSG_PUB.Count_And_Get (

779: );
780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_MSG_PUB.Count_And_Get (
784: p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );

Line 790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

786: p_data => x_msg_data
787: );
788: WHEN OTHERS THEN
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (

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

787: );
788: WHEN OTHERS THEN
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,

Line 794: FND_MSG_PUB.Count_And_Get (

790: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data
798: );

Line 857: FND_MSG_PUB.initialize;

853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END IF;
855: --Initialize message list if p_init_msg_list is TRUE.
856: IF FND_API.To_Boolean (p_init_msg_list) THEN
857: FND_MSG_PUB.initialize;
858: END IF;
859: -- Initialize API return status to success
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861: -- Get the current (login) user id.

Line 872: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

868: IF (p_check_login_user = FND_API.G_TRUE) THEN
869: -- Check if user is login and has the required privilege.
870: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
871: -- User is not login.
872: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
873: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;

Line 874: FND_MSG_PUB.Add;

870: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
871: -- User is not login.
872: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
873: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;

Line 920: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

916: l_sql_statement := l_sql_statement ||
917: l_where_clause || 'ORDER BY T.CONTENT_TYPE_NAME ';
918: l_sql_statement2 := l_sql_statement2 || l_where_clause;
919: --
920: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
921: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
922: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
923: FND_MSG_PUB.Add;
924: --

Line 923: FND_MSG_PUB.Add;

919: --
920: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
921: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
922: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
923: FND_MSG_PUB.Add;
924: --
925: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
926: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);
927: FND_MSG_PUB.Add;

Line 927: FND_MSG_PUB.Add;

923: FND_MSG_PUB.Add;
924: --
925: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
926: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);
927: FND_MSG_PUB.Add;
928: END IF;
929:
930: --Execute the SQL statements to get the total count:
931: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN

Line 1007: FND_MSG_PUB.Count_And_Get (

1003: );
1004: */
1005:
1006: --Standard call to get message count and if count=1, get the message
1007: FND_MSG_PUB.Count_And_Get (
1008: p_encoded => FND_API.G_FALSE,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );

Line 1016: FND_MSG_PUB.Count_And_Get (

1012: EXCEPTION
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: -- Standard call to get message count and if count=1, get the message
1016: FND_MSG_PUB.Count_And_Get (
1017: p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );

Line 1024: FND_MSG_PUB.Count_And_Get (

1020: );
1021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );

Line 1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1027: p_data => x_msg_data
1028: );
1029: WHEN OTHERS THEN
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1032: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1033: END IF;
1034: -- Standard call to get message count and if count=1, get the message
1035: FND_MSG_PUB.Count_And_Get (

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

1028: );
1029: WHEN OTHERS THEN
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1032: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1033: END IF;
1034: -- Standard call to get message count and if count=1, get the message
1035: FND_MSG_PUB.Count_And_Get (
1036: p_encoded => FND_API.G_FALSE,

Line 1035: FND_MSG_PUB.Count_And_Get (

1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1032: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1033: END IF;
1034: -- Standard call to get message count and if count=1, get the message
1035: FND_MSG_PUB.Count_And_Get (
1036: p_encoded => FND_API.G_FALSE,
1037: p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );