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

Line 87: FND_MSG_PUB.initialize;

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: --Initialize message list if p_init_msg_list is TRUE.
86: IF FND_API.To_Boolean (p_init_msg_list) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89: -- Initialize API return status to success
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: --

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

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

Line 105: FND_MSG_PUB.Add;

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

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

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

Line 123: FND_MSG_PUB.Add;

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

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

135: FETCH Check_DupPerspectName_csr Into l_perspective_id;
136: IF Check_DupPerspectName_csr%FOUND THEN
137: -- The name is already used
138: CLOSE Check_DupPerspectName_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_PERSPECTIVE_TK', TRUE);
142: FND_MESSAGE.Set_Token('NAME', p_perspective_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_PERSPECTIVE_TK', TRUE);
142: FND_MESSAGE.Set_Token('NAME', p_perspective_name);
143: FND_MSG_PUB.Add;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: CLOSE Check_DupPerspectName_csr;

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

173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END IF;
176: -- Debug Message
177: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
178: FND_MESSAGE.Set_name('AMV','PVT Add Persp. API: End');
179: FND_MSG_PUB.Add;
180: END IF;
181: --Standard call to get message count and if count=1, get the message

Line 179: FND_MSG_PUB.Add;

175: END IF;
176: -- Debug Message
177: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
178: FND_MESSAGE.Set_name('AMV','PVT Add Persp. API: End');
179: FND_MSG_PUB.Add;
180: END IF;
181: --Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,

Line 182: FND_MSG_PUB.Count_And_Get (

178: FND_MESSAGE.Set_name('AMV','PVT Add Persp. API: End');
179: FND_MSG_PUB.Add;
180: END IF;
181: --Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,
184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );

Line 192: FND_MSG_PUB.Count_And_Get (

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

Line 201: FND_MSG_PUB.Count_And_Get (

197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO Add_Perspective_Pvt;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: -- Standard call to get message count and if count=1, get the message
201: FND_MSG_PUB.Count_And_Get (
202: p_encoded => FND_API.G_FALSE,
203: p_count => x_msg_count,
204: p_data => x_msg_data
205: );

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

205: );
206: WHEN OTHERS THEN
207: ROLLBACK TO Add_Perspective_Pvt;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
211: END IF;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (

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

206: WHEN OTHERS THEN
207: ROLLBACK TO Add_Perspective_Pvt;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
211: END IF;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,

Line 213: FND_MSG_PUB.Count_And_Get (

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

Line 257: FND_MSG_PUB.initialize;

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

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

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

Line 274: FND_MSG_PUB.Add;

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

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

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

Line 292: FND_MSG_PUB.Add;

288: IF (l_admin_flag <> FND_API.G_TRUE) THEN
289: -- User is not an administrator.
290: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
292: FND_MSG_PUB.Add;
293: END IF;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: 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 perspective id
305: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN
306: l_perspective_id := p_perspective_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_PERSPECTIVE_TK', TRUE);
311: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_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_PERSPECTIVE_TK', TRUE);
311: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
312: FND_MSG_PUB.Add;
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: ELSIF (p_perspective_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_ValidPerspectName_csr(p_perspective_name);
318: FETCH Check_ValidPerspectName_csr Into l_perspective_id;
319: IF (Check_ValidPerspectName_csr%NOTFOUND) THEN
320: CLOSE Check_ValidPerspectName_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_PERSPECTIVE_TK', TRUE);
324: FND_MESSAGE.Set_Token('NAME', p_perspective_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_PERSPECTIVE_TK', TRUE);
324: FND_MESSAGE.Set_Token('NAME', p_perspective_name);
325: FND_MSG_PUB.Add;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
329: CLOSE Check_ValidPerspectName_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_ValidPerspectName_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_PERSPECTIVE_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_PERSPECTIVE_TK', TRUE);
334: FND_MSG_PUB.Add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: -- Now do the deleting:

Line 354: FND_MSG_PUB.Count_And_Get (

350: IF FND_API.To_Boolean ( p_commit ) THEN
351: COMMIT WORK;
352: END IF;
353: --Standard call to get message count and if count=1, get the message
354: FND_MSG_PUB.Count_And_Get (
355: p_encoded => FND_API.G_FALSE,
356: p_count => x_msg_count,
357: p_data => x_msg_data
358: );

Line 364: FND_MSG_PUB.Count_And_Get (

360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO Delete_Perspective_Pvt;
362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
363: -- Standard call to get message count and if count=1, get the message
364: FND_MSG_PUB.Count_And_Get (
365: p_encoded => FND_API.G_FALSE,
366: p_count => x_msg_count,
367: p_data => x_msg_data
368: );

Line 373: FND_MSG_PUB.Count_And_Get (

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

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

377: );
378: WHEN OTHERS THEN
379: ROLLBACK TO Delete_Perspective_Pvt;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
382: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
383: END IF;
384: -- Standard call to get message count and if count=1, get the message
385: FND_MSG_PUB.Count_And_Get (

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

378: WHEN OTHERS THEN
379: ROLLBACK TO Delete_Perspective_Pvt;
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
382: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
383: END IF;
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,

Line 385: FND_MSG_PUB.Count_And_Get (

381: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
382: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
383: END IF;
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 438: FND_MSG_PUB.initialize;

434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436: --Initialize message list if p_init_msg_list is TRUE.
437: IF FND_API.To_Boolean (p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440: -- Initialize API return status to success
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: -- Get the current (login) user id.

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

449: IF (p_check_login_user = FND_API.G_TRUE) THEN
450: -- Check if user is login and has the required privilege.
451: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
452: -- User is not login.
453: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
454: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
455: FND_MSG_PUB.Add;
456: END IF;
457: RAISE FND_API.G_EXC_ERROR;

Line 455: FND_MSG_PUB.Add;

451: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
452: -- User is not login.
453: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
454: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
455: FND_MSG_PUB.Add;
456: END IF;
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;
459: AMV_USER_PVT.Is_Administrator

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

467: x_result_flag => l_admin_flag
468: );
469: IF (l_admin_flag <> FND_API.G_TRUE) THEN
470: -- User is not an administrator.
471: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
472: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
473: FND_MSG_PUB.Add;
474: END IF;
475: RAISE FND_API.G_EXC_ERROR;

Line 473: FND_MSG_PUB.Add;

469: IF (l_admin_flag <> FND_API.G_TRUE) THEN
470: -- User is not an administrator.
471: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
472: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
473: FND_MSG_PUB.Add;
474: END IF;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: END IF;

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

484: OPEN Check_DupPerspectName_csr(p_perspective_new_name);
485: FETCH Check_DupPerspectName_csr INTO l_perspective_id;
486: IF Check_DupPerspectName_csr%FOUND THEN
487: CLOSE Check_DupPerspectName_csr;
488: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
489: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');
490: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
491: FND_MESSAGE.Set_Token('NAME', p_perspective_new_name);
492: FND_MSG_PUB.Add;

Line 492: FND_MSG_PUB.Add;

488: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
489: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');
490: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
491: FND_MESSAGE.Set_Token('NAME', p_perspective_new_name);
492: FND_MSG_PUB.Add;
493: END IF;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496: CLOSE Check_DupPerspectName_csr;

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

499: -- Check if user pass the valid perspective id
500: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN
501: l_perspective_id := p_perspective_id;
502: ELSE
503: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
504: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
505: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
506: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
507: FND_MSG_PUB.Add;

Line 507: FND_MSG_PUB.Add;

503: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
504: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
505: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
506: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
507: FND_MSG_PUB.Add;
508: END IF;
509: RAISE FND_API.G_EXC_ERROR;
510: END IF;
511: ELSIF (p_perspective_name <> FND_API.G_MISS_CHAR) THEN

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

512: OPEN Check_ValidPerspectName_csr(p_perspective_name);
513: FETCH Check_ValidPerspectName_csr Into l_perspective_id;
514: IF (Check_ValidPerspectName_csr%NOTFOUND) THEN
515: CLOSE Check_ValidPerspectName_csr;
516: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
517: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
518: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
519: FND_MESSAGE.Set_Token('NAME', p_perspective_name);
520: FND_MSG_PUB.Add;

Line 520: FND_MSG_PUB.Add;

516: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
517: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
518: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
519: FND_MESSAGE.Set_Token('NAME', p_perspective_name);
520: FND_MSG_PUB.Add;
521: END IF;
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: CLOSE Check_ValidPerspectName_csr;

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

522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: CLOSE Check_ValidPerspectName_csr;
525: ELSE
526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
528: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
529: FND_MSG_PUB.Add;
530: END IF;

Line 529: FND_MSG_PUB.Add;

525: ELSE
526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
527: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
528: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
529: FND_MSG_PUB.Add;
530: END IF;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533: -- Get the current version number

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

549: IF FND_API.To_Boolean ( p_commit ) THEN
550: COMMIT WORK;
551: END IF;
552: -- Debug Message
553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
554: FND_MESSAGE.Set_name('AMV','PVT Update Persp. API: End');
555: FND_MSG_PUB.Add;
556: END IF;
557: --Standard call to get message count and if count=1, get the message

Line 555: FND_MSG_PUB.Add;

551: END IF;
552: -- Debug Message
553: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
554: FND_MESSAGE.Set_name('AMV','PVT Update Persp. API: End');
555: FND_MSG_PUB.Add;
556: END IF;
557: --Standard call to get message count and if count=1, get the message
558: FND_MSG_PUB.Count_And_Get (
559: p_encoded => FND_API.G_FALSE,

Line 558: FND_MSG_PUB.Count_And_Get (

554: FND_MESSAGE.Set_name('AMV','PVT Update Persp. API: End');
555: FND_MSG_PUB.Add;
556: END IF;
557: --Standard call to get message count and if count=1, get the message
558: FND_MSG_PUB.Count_And_Get (
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data
562: );

Line 569: FND_MSG_PUB.Count_And_Get (

565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Update_Perspective_Pvt;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );

Line 578: FND_MSG_PUB.Count_And_Get (

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

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

582: );
583: WHEN OTHERS THEN
584: ROLLBACK TO Update_Perspective_Pvt;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
588: END IF;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (

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

583: WHEN OTHERS THEN
584: ROLLBACK TO Update_Perspective_Pvt;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
588: END IF;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,

Line 590: FND_MSG_PUB.Count_And_Get (

586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
587: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
588: END IF;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data
594: );

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

646: G_PKG_NAME) THEN
647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
648: END IF;
649: -- Debug Message
650: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
651: FND_MESSAGE.Set_name('AMV','PVT Get Persp. API: Start');
652: FND_MSG_PUB.Add;
653: END IF;
654: --Initialize message list if p_init_msg_list is TRUE.

Line 652: FND_MSG_PUB.Add;

648: END IF;
649: -- Debug Message
650: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
651: FND_MESSAGE.Set_name('AMV','PVT Get Persp. API: Start');
652: FND_MSG_PUB.Add;
653: END IF;
654: --Initialize message list if p_init_msg_list is TRUE.
655: IF FND_API.To_Boolean (p_init_msg_list) THEN
656: FND_MSG_PUB.initialize;

Line 656: FND_MSG_PUB.initialize;

652: FND_MSG_PUB.Add;
653: END IF;
654: --Initialize message list if p_init_msg_list is TRUE.
655: IF FND_API.To_Boolean (p_init_msg_list) THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658: -- Initialize API return status to success
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660: --

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

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

Line 674: FND_MSG_PUB.Add;

670: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
671: -- User is not login.
672: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
673: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
674: FND_MSG_PUB.Add;
675: END IF;
676: RAISE FND_API.G_EXC_ERROR;
677: END IF;
678: END IF;

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

685: -- Check if user pass the valid perspective id
686: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) = TRUE THEN
687: l_perspective_id := p_perspective_id;
688: ELSE
689: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
690: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
691: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
692: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
693: FND_MSG_PUB.Add;

Line 693: FND_MSG_PUB.Add;

689: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
690: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
691: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
692: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
693: FND_MSG_PUB.Add;
694: END IF;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697: ELSIF (p_perspective_name <> FND_API.G_MISS_CHAR) THEN

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

698: OPEN Check_ValidPerspectName_csr(p_perspective_name);
699: FETCH Check_ValidPerspectName_csr Into l_perspective_id;
700: IF (Check_ValidPerspectName_csr%NOTFOUND) THEN
701: CLOSE Check_ValidPerspectName_csr;
702: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
703: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
704: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
705: FND_MESSAGE.Set_Token('NAME', p_perspective_name);
706: FND_MSG_PUB.Add;

Line 706: FND_MSG_PUB.Add;

702: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
703: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');
704: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
705: FND_MESSAGE.Set_Token('NAME', p_perspective_name);
706: FND_MSG_PUB.Add;
707: END IF;
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710: CLOSE Check_ValidPerspectName_csr;

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

708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710: CLOSE Check_ValidPerspectName_csr;
711: ELSE
712: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
713: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
714: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
715: FND_MSG_PUB.Add;
716: END IF;

Line 715: FND_MSG_PUB.Add;

711: ELSE
712: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
713: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
714: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
715: FND_MSG_PUB.Add;
716: END IF;
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719: -- Now query and return the perspective record

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

720: OPEN Get_PerspRecord_csr(l_perspective_id);
721: FETCH Get_PerspRecord_csr INTO l_perspective_rec;
722: IF (Get_PerspRecord_csr%NOTFOUND) THEN
723: CLOSE Get_PerspRecord_csr;
724: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NOT_FOUND');
726: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
727: FND_MSG_PUB.Add;
728: END IF;

Line 727: FND_MSG_PUB.Add;

723: CLOSE Get_PerspRecord_csr;
724: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
725: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NOT_FOUND');
726: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
727: FND_MSG_PUB.Add;
728: END IF;
729: RAISE FND_API.G_EXC_ERROR;
730: ELSE
731: x_perspective_obj.perspective_id := l_perspective_rec.perspective_id;

Line 761: FND_MSG_PUB.Count_And_Get (

757: */
758: END IF;
759: CLOSE Get_PerspRecord_csr;
760: --Standard call to get message count and if count=1, get the message
761: FND_MSG_PUB.Count_And_Get (
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_msg_count,
764: p_data => x_msg_data
765: );

Line 770: FND_MSG_PUB.Count_And_Get (

766: EXCEPTION
767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: -- Standard call to get message count and if count=1, get the message
770: FND_MSG_PUB.Count_And_Get (
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_msg_count,
773: p_data => x_msg_data
774: );

Line 778: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 789: FND_MSG_PUB.Count_And_Get (

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

Line 851: FND_MSG_PUB.initialize;

847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: END IF;
849: --Initialize message list if p_init_msg_list is TRUE.
850: IF FND_API.To_Boolean (p_init_msg_list) THEN
851: FND_MSG_PUB.initialize;
852: END IF;
853: -- Initialize API return status to success
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855: -- Get the current (login) user id.

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

862: IF (p_check_login_user = FND_API.G_TRUE) THEN
863: -- Check if user is login and has the required privilege.
864: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
865: -- User is not login.
866: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
868: FND_MSG_PUB.Add;
869: END IF;
870: RAISE FND_API.G_EXC_ERROR;

Line 868: FND_MSG_PUB.Add;

864: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
865: -- User is not login.
866: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
867: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
868: FND_MSG_PUB.Add;
869: END IF;
870: RAISE FND_API.G_EXC_ERROR;
871: END IF;
872: END IF;

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

913: l_where_clause;
914: --
915: --dbms_output.put_line('sql stmt = '|| substr(l_sql_statement, 1, 80));
916: --dbms_output.put_line(substr(l_sql_statement, 81, 80));
917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
918: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
919: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
920: FND_MSG_PUB.Add;
921: --

Line 920: FND_MSG_PUB.Add;

916: --dbms_output.put_line(substr(l_sql_statement, 81, 80));
917: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
918: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
919: FND_MESSAGE.Set_Token('ROW', l_sql_statement);
920: FND_MSG_PUB.Add;
921: --
922: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
923: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);
924: FND_MSG_PUB.Add;

Line 924: FND_MSG_PUB.Add;

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

Line 1001: FND_MSG_PUB.Count_And_Get (

997: l_total_record_count
998: );
999: */
1000: --Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );

Line 1010: FND_MSG_PUB.Count_And_Get (

1006: EXCEPTION
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: -- Standard call to get message count and if count=1, get the message
1010: FND_MSG_PUB.Count_And_Get (
1011: p_encoded => FND_API.G_FALSE,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data
1014: );

Line 1018: FND_MSG_PUB.Count_And_Get (

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

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

1021: p_data => x_msg_data
1022: );
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1027: END IF;
1028: -- Standard call to get message count and if count=1, get the message
1029: FND_MSG_PUB.Count_And_Get (

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

1022: );
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1027: END IF;
1028: -- Standard call to get message count and if count=1, get the message
1029: FND_MSG_PUB.Count_And_Get (
1030: p_encoded => FND_API.G_FALSE,

Line 1029: FND_MSG_PUB.Count_And_Get (

1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1026: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1027: END IF;
1028: -- Standard call to get message count and if count=1, get the message
1029: FND_MSG_PUB.Count_And_Get (
1030: p_encoded => FND_API.G_FALSE,
1031: p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );

Line 1087: FND_MSG_PUB.initialize;

1083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: END IF;
1085: --Initialize message list if p_init_msg_list is TRUE.
1086: IF FND_API.To_Boolean (p_init_msg_list) THEN
1087: FND_MSG_PUB.initialize;
1088: END IF;
1089: -- Initialize API return status to success
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091: --

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

1099: IF (p_check_login_user = FND_API.G_TRUE) THEN
1100: -- Check if user is login and has the required privilege.
1101: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1102: -- User is not login.
1103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1104: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1105: FND_MSG_PUB.Add;
1106: END IF;
1107: RAISE FND_API.G_EXC_ERROR;

Line 1105: FND_MSG_PUB.Add;

1101: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1102: -- User is not login.
1103: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1104: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1105: FND_MSG_PUB.Add;
1106: END IF;
1107: RAISE FND_API.G_EXC_ERROR;
1108: END IF;
1109: AMV_USER_PVT.Is_Administrator

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

1117: x_result_flag => l_admin_flag
1118: );
1119: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1120: -- User is not an administrator.
1121: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1122: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1123: FND_MSG_PUB.Add;
1124: END IF;
1125: RAISE FND_API.G_EXC_ERROR;

Line 1123: FND_MSG_PUB.Add;

1119: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1120: -- User is not an administrator.
1121: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1122: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1123: FND_MSG_PUB.Add;
1124: END IF;
1125: RAISE FND_API.G_EXC_ERROR;
1126: END IF;
1127: END IF;

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

1131: l_current_user_id := -1;
1132: END IF;
1133: -- Check if item id is valid.
1134: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1135: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1136: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1137: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1138: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1139: FND_MSG_PUB.Add;

Line 1139: FND_MSG_PUB.Add;

1135: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1136: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1137: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1138: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1139: FND_MSG_PUB.Add;
1140: END IF;
1141: RAISE FND_API.G_EXC_ERROR;
1142: END IF;
1143: l_count := p_perspective_array.count;

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

1147: FETCH Check_ItemPerspectives_csr INTO l_temp_number;
1148: IF (Check_ItemPerspectives_csr%FOUND) THEN
1149: CLOSE Check_ItemPerspectives_csr;
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1152: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
1153: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1154: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1155: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);

Line 1157: FND_MSG_PUB.Add;

1153: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1154: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1155: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);
1156: FND_MESSAGE.Set_Token('ATTRID', to_char(l_perspective_id));
1157: FND_MSG_PUB.Add;
1158: END IF;
1159: ELSE
1160: CLOSE Check_ItemPerspectives_csr;
1161: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(l_perspective_id) THEN

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

1186: l_perspective_id
1187: );
1188: ELSE
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1191: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1192: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
1193: FND_MESSAGE.Set_Token('ID',
1194: to_char( nvl(l_perspective_id, -1) ) );

Line 1195: FND_MSG_PUB.Add;

1191: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1192: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
1193: FND_MESSAGE.Set_Token('ID',
1194: to_char( nvl(l_perspective_id, -1) ) );
1195: FND_MSG_PUB.Add;
1196: END IF;
1197: END IF;
1198: END IF;
1199: END LOOP;

Line 1205: FND_MSG_PUB.Count_And_Get (

1201: IF FND_API.To_Boolean ( p_commit ) THEN
1202: COMMIT WORK;
1203: END IF;
1204: --Standard call to get message count and if count=1, get the message
1205: FND_MSG_PUB.Count_And_Get (
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data
1209: );

Line 1215: FND_MSG_PUB.Count_And_Get (

1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: ROLLBACK TO Add_ItemPersps_Pvt;
1213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1214: -- Standard call to get message count and if count=1, get the message
1215: FND_MSG_PUB.Count_And_Get (
1216: p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1219: );

Line 1224: FND_MSG_PUB.Count_And_Get (

1220: WHEN FND_API.G_EXC_ERROR THEN
1221: ROLLBACK TO Add_ItemPersps_Pvt;
1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: -- Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );

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

1228: );
1229: WHEN OTHERS THEN
1230: ROLLBACK TO Add_ItemPersps_Pvt;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (

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

1229: WHEN OTHERS THEN
1230: ROLLBACK TO Add_ItemPersps_Pvt;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,

Line 1236: FND_MSG_PUB.Count_And_Get (

1232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,
1238: p_count => x_msg_count,
1239: p_data => x_msg_data
1240: );

Line 1291: FND_MSG_PUB.initialize;

1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: END IF;
1289: --Initialize message list if p_init_msg_list is TRUE.
1290: IF FND_API.To_Boolean (p_init_msg_list) THEN
1291: FND_MSG_PUB.initialize;
1292: END IF;
1293: -- Initialize API return status to success
1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295: -- Get the current (login) user id.

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

1302: IF (p_check_login_user = FND_API.G_TRUE) THEN
1303: -- Check if user is login and has the required privilege.
1304: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1305: -- User is not login.
1306: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1307: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1308: FND_MSG_PUB.Add;
1309: END IF;
1310: RAISE FND_API.G_EXC_ERROR;

Line 1308: FND_MSG_PUB.Add;

1304: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1305: -- User is not login.
1306: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1307: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1308: FND_MSG_PUB.Add;
1309: END IF;
1310: RAISE FND_API.G_EXC_ERROR;
1311: END IF;
1312: AMV_USER_PVT.Is_Administrator

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

1320: x_result_flag => l_admin_flag
1321: );
1322: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1323: -- User is not an administrator.
1324: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1325: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1326: FND_MSG_PUB.Add;
1327: END IF;
1328: RAISE FND_API.G_EXC_ERROR;

Line 1326: FND_MSG_PUB.Add;

1322: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1323: -- User is not an administrator.
1324: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1325: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1326: FND_MSG_PUB.Add;
1327: END IF;
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330: END IF;

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

1334: l_current_user_id := -1;
1335: END IF;
1336: -- Check if item id is valid.
1337: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1338: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1339: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1340: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1341: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1342: FND_MSG_PUB.Add;

Line 1342: FND_MSG_PUB.Add;

1338: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1339: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1340: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1341: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1342: FND_MSG_PUB.Add;
1343: END IF;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: IF (AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) <> TRUE) THEN

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

1343: END IF;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346: IF (AMV_UTILITY_PVT.Is_PerspectiveIdValid(p_perspective_id) <> TRUE) THEN
1347: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1348: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1349: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
1350: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
1351: FND_MSG_PUB.Add;

Line 1351: FND_MSG_PUB.Add;

1347: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1348: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1349: FND_MESSAGE.Set_Token('RECORD', 'AMV_PERSPECTIVE_TK', TRUE);
1350: FND_MESSAGE.Set_Token('ID', to_char(p_perspective_id));
1351: FND_MSG_PUB.Add;
1352: END IF;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355: OPEN Check_ItemPerspectives_csr;

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

1356: FETCH Check_ItemPerspectives_csr INTO l_item_persp;
1357: IF (Check_ItemPerspectives_csr%FOUND) THEN
1358: CLOSE Check_ItemPerspectives_csr;
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1361: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_ATTR');
1362: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1363: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1364: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);

Line 1366: FND_MSG_PUB.Add;

1362: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1363: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1364: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);
1365: FND_MESSAGE.Set_Token('ATTRID', to_char(p_perspective_id));
1366: FND_MSG_PUB.Add;
1367: END IF;
1368: ELSE
1369: CLOSE Check_ItemPerspectives_csr;
1370: OPEN Get_IDandDate_csr;

Line 1400: FND_MSG_PUB.Count_And_Get (

1396: IF FND_API.To_Boolean ( p_commit ) THEN
1397: COMMIT WORK;
1398: END IF;
1399: --Standard call to get message count and if count=1, get the message
1400: FND_MSG_PUB.Count_And_Get (
1401: p_encoded => FND_API.G_FALSE,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data
1404: );

Line 1410: FND_MSG_PUB.Count_And_Get (

1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: ROLLBACK TO Add_ItemPersps_Pvt;
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409: -- Standard call to get message count and if count=1, get the message
1410: FND_MSG_PUB.Count_And_Get (
1411: p_encoded => FND_API.G_FALSE,
1412: p_count => x_msg_count,
1413: p_data => x_msg_data
1414: );

Line 1419: FND_MSG_PUB.Count_And_Get (

1415: WHEN FND_API.G_EXC_ERROR THEN
1416: ROLLBACK TO Add_ItemPersps_Pvt;
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: -- Standard call to get message count and if count=1, get the message
1419: FND_MSG_PUB.Count_And_Get (
1420: p_encoded => FND_API.G_FALSE,
1421: p_count => x_msg_count,
1422: p_data => x_msg_data
1423: );

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

1423: );
1424: WHEN OTHERS THEN
1425: ROLLBACK TO Add_ItemPersps_Pvt;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1429: END IF;
1430: -- Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (

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

1424: WHEN OTHERS THEN
1425: ROLLBACK TO Add_ItemPersps_Pvt;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1429: END IF;
1430: -- Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,

Line 1431: FND_MSG_PUB.Count_And_Get (

1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1429: END IF;
1430: -- Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );

Line 1485: FND_MSG_PUB.initialize;

1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: END IF;
1483: --Initialize message list if p_init_msg_list is TRUE.
1484: IF FND_API.To_Boolean (p_init_msg_list) THEN
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487: -- Initialize API return status to success
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489: -- Get the current (login) user id.

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

1496: IF (p_check_login_user = FND_API.G_TRUE) THEN
1497: -- Check if user is login and has the required privilege.
1498: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1499: -- User is not login.
1500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1501: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1502: FND_MSG_PUB.Add;
1503: END IF;
1504: RAISE FND_API.G_EXC_ERROR;

Line 1502: FND_MSG_PUB.Add;

1498: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1499: -- User is not login.
1500: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1501: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1502: FND_MSG_PUB.Add;
1503: END IF;
1504: RAISE FND_API.G_EXC_ERROR;
1505: END IF;
1506: AMV_USER_PVT.Is_Administrator

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

1514: x_result_flag => l_admin_flag
1515: );
1516: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1517: -- User is not an administrator.
1518: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1519: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1520: FND_MSG_PUB.Add;
1521: END IF;
1522: RAISE FND_API.G_EXC_ERROR;

Line 1520: FND_MSG_PUB.Add;

1516: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1517: -- User is not an administrator.
1518: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1519: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1520: FND_MSG_PUB.Add;
1521: END IF;
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524: END IF;

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

1528: l_current_user_id := -1;
1529: END IF;
1530: -- Check if item id is valid.
1531: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1532: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1534: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1535: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1536: FND_MSG_PUB.Add;

Line 1536: FND_MSG_PUB.Add;

1532: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1534: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1535: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1536: FND_MSG_PUB.Add;
1537: END IF;
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;
1540: l_count := p_perspective_array.count;

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

1544: FETCH Check_ItemPerspectives_csr INTO l_temp_number;
1545: IF (Check_ItemPerspectives_csr%NOTFOUND) THEN
1546: CLOSE Check_ItemPerspectives_csr;
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1549: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
1550: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1551: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1552: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);

Line 1554: FND_MSG_PUB.Add;

1550: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1551: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1552: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);
1553: FND_MESSAGE.Set_Token('ATTRID', to_char(l_perspective_id));
1554: FND_MSG_PUB.Add;
1555: END IF;
1556: ELSE
1557: CLOSE Check_ItemPerspectives_csr;
1558: Delete from amv_i_item_perspectives

Line 1568: FND_MSG_PUB.Count_And_Get (

1564: IF FND_API.To_Boolean ( p_commit ) THEN
1565: COMMIT WORK;
1566: END IF;
1567: --Standard call to get message count and if count=1, get the message
1568: FND_MSG_PUB.Count_And_Get (
1569: p_encoded => FND_API.G_FALSE,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );

Line 1578: FND_MSG_PUB.Count_And_Get (

1574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1575: ROLLBACK TO Delete_ItemPersps_Pvt;
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: -- Standard call to get message count and if count=1, get the message
1578: FND_MSG_PUB.Count_And_Get (
1579: p_encoded => FND_API.G_FALSE,
1580: p_count => x_msg_count,
1581: p_data => x_msg_data
1582: );

Line 1587: FND_MSG_PUB.Count_And_Get (

1583: WHEN FND_API.G_EXC_ERROR THEN
1584: ROLLBACK TO Delete_ItemPersps_Pvt;
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: -- Standard call to get message count and if count=1, get the message
1587: FND_MSG_PUB.Count_And_Get (
1588: p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data
1591: );

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

1591: );
1592: WHEN OTHERS THEN
1593: ROLLBACK TO Delete_ItemPersps_Pvt;
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1597: END IF;
1598: -- Standard call to get message count and if count=1, get the message
1599: FND_MSG_PUB.Count_And_Get (

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

1592: WHEN OTHERS THEN
1593: ROLLBACK TO Delete_ItemPersps_Pvt;
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1597: END IF;
1598: -- Standard call to get message count and if count=1, get the message
1599: FND_MSG_PUB.Count_And_Get (
1600: p_encoded => FND_API.G_FALSE,

Line 1599: FND_MSG_PUB.Count_And_Get (

1595: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1596: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1597: END IF;
1598: -- Standard call to get message count and if count=1, get the message
1599: FND_MSG_PUB.Count_And_Get (
1600: p_encoded => FND_API.G_FALSE,
1601: p_count => x_msg_count,
1602: p_data => x_msg_data
1603: );

Line 1650: FND_MSG_PUB.initialize;

1646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1647: END IF;
1648: --Initialize message list if p_init_msg_list is TRUE.
1649: IF FND_API.To_Boolean (p_init_msg_list) THEN
1650: FND_MSG_PUB.initialize;
1651: END IF;
1652: -- Initialize API return status to success
1653: x_return_status := FND_API.G_RET_STS_SUCCESS;
1654: -- Get the current (login) user id.

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

1661: IF (p_check_login_user = FND_API.G_TRUE) THEN
1662: -- Check if user is login and has the required privilege.
1663: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1664: -- User is not login.
1665: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1666: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1667: FND_MSG_PUB.Add;
1668: END IF;
1669: RAISE FND_API.G_EXC_ERROR;

Line 1667: FND_MSG_PUB.Add;

1663: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1664: -- User is not login.
1665: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1666: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1667: FND_MSG_PUB.Add;
1668: END IF;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END IF;
1671: AMV_USER_PVT.Is_Administrator

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

1679: x_result_flag => l_admin_flag
1680: );
1681: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1682: -- User is not an administrator.
1683: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1684: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1685: FND_MSG_PUB.Add;
1686: END IF;
1687: RAISE FND_API.G_EXC_ERROR;

Line 1685: FND_MSG_PUB.Add;

1681: IF (l_admin_flag <> FND_API.G_TRUE) THEN
1682: -- User is not an administrator.
1683: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1684: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
1685: FND_MSG_PUB.Add;
1686: END IF;
1687: RAISE FND_API.G_EXC_ERROR;
1688: END IF;
1689: END IF;

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

1693: l_current_user_id := -1;
1694: END IF;
1695: -- Check if item id is valid.
1696: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1697: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1698: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1699: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1700: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1701: FND_MSG_PUB.Add;

Line 1701: FND_MSG_PUB.Add;

1697: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1698: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1699: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1700: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1701: FND_MSG_PUB.Add;
1702: END IF;
1703: RAISE FND_API.G_EXC_ERROR;
1704: END IF;
1705: IF (p_perspective_id <> FND_API.G_MISS_NUM) THEN

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

1706: OPEN Check_ItemPerspectives_csr;
1707: FETCH Check_ItemPerspectives_csr INTO l_temp_number;
1708: IF (Check_ItemPerspectives_csr%NOTFOUND) THEN
1709: CLOSE Check_ItemPerspectives_csr;
1710: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1711: FND_MESSAGE.Set_name('AMV','AMV_ENTITY_HAS_NOT_ATTR');
1712: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1713: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1714: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);

Line 1716: FND_MSG_PUB.Add;

1712: FND_MESSAGE.Set_Token('ENTITY', 'AMV_ITEM_TK', TRUE);
1713: FND_MESSAGE.Set_Token('ENTID', to_char(p_item_id));
1714: FND_MESSAGE.Set_Token('ATTRIBUTE', 'AMV_PERSPECTIVE_TK', TRUE);
1715: FND_MESSAGE.Set_Token('ATTRID', to_char(p_perspective_id));
1716: FND_MSG_PUB.Add;
1717: END IF;
1718: RAISE FND_API.G_EXC_ERROR;
1719: ELSE
1720: CLOSE Check_ItemPerspectives_csr;

Line 1736: FND_MSG_PUB.Count_And_Get (

1732: IF FND_API.To_Boolean ( p_commit ) THEN
1733: COMMIT WORK;
1734: END IF;
1735: --Standard call to get message count and if count=1, get the message
1736: FND_MSG_PUB.Count_And_Get (
1737: p_encoded => FND_API.G_FALSE,
1738: p_count => x_msg_count,
1739: p_data => x_msg_data
1740: );

Line 1746: FND_MSG_PUB.Count_And_Get (

1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743: ROLLBACK TO Delete_ItemPersps_Pvt;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: -- Standard call to get message count and if count=1, get the message
1746: FND_MSG_PUB.Count_And_Get (
1747: p_encoded => FND_API.G_FALSE,
1748: p_count => x_msg_count,
1749: p_data => x_msg_data
1750: );

Line 1755: FND_MSG_PUB.Count_And_Get (

1751: WHEN FND_API.G_EXC_ERROR THEN
1752: ROLLBACK TO Delete_ItemPersps_Pvt;
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: -- Standard call to get message count and if count=1, get the message
1755: FND_MSG_PUB.Count_And_Get (
1756: p_encoded => FND_API.G_FALSE,
1757: p_count => x_msg_count,
1758: p_data => x_msg_data
1759: );

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

1759: );
1760: WHEN OTHERS THEN
1761: ROLLBACK TO Delete_ItemPersps_Pvt;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1765: END IF;
1766: -- Standard call to get message count and if count=1, get the message
1767: FND_MSG_PUB.Count_And_Get (

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

1760: WHEN OTHERS THEN
1761: ROLLBACK TO Delete_ItemPersps_Pvt;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1765: END IF;
1766: -- Standard call to get message count and if count=1, get the message
1767: FND_MSG_PUB.Count_And_Get (
1768: p_encoded => FND_API.G_FALSE,

Line 1767: FND_MSG_PUB.Count_And_Get (

1763: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1764: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1765: END IF;
1766: -- Standard call to get message count and if count=1, get the message
1767: FND_MSG_PUB.Count_And_Get (
1768: p_encoded => FND_API.G_FALSE,
1769: p_count => x_msg_count,
1770: p_data => x_msg_data
1771: );

Line 1874: FND_MSG_PUB.initialize;

1870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1871: END IF;
1872: --Initialize message list if p_init_msg_list is TRUE.
1873: IF FND_API.To_Boolean (p_init_msg_list) THEN
1874: FND_MSG_PUB.initialize;
1875: END IF;
1876: -- Initialize API return status to success
1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878: -- Get the current (login) user id.

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

1885: IF (p_check_login_user = FND_API.G_TRUE) THEN
1886: -- Check if user is login and has the required privilege.
1887: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1888: -- User is not login.
1889: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1890: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1891: FND_MSG_PUB.Add;
1892: END IF;
1893: RAISE FND_API.G_EXC_ERROR;

Line 1891: FND_MSG_PUB.Add;

1887: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
1888: -- User is not login.
1889: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1890: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
1891: FND_MSG_PUB.Add;
1892: END IF;
1893: RAISE FND_API.G_EXC_ERROR;
1894: END IF;
1895: END IF;

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

1899: l_current_user_id := -1;
1900: END IF;
1901: -- Check if item id is valid.
1902: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1903: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1904: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1905: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1906: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1907: FND_MSG_PUB.Add;

Line 1907: FND_MSG_PUB.Add;

1903: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1904: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1905: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1906: FND_MESSAGE.Set_Token('ID', to_char(p_item_id));
1907: FND_MSG_PUB.Add;
1908: END IF;
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911: --Execute the SQL statements to get records

Line 1945: FND_MSG_PUB.Count_And_Get (

1941: );
1942: */
1943: END LOOP;
1944: --Standard call to get message count and if count=1, get the message
1945: FND_MSG_PUB.Count_And_Get (
1946: p_encoded => FND_API.G_FALSE,
1947: p_count => x_msg_count,
1948: p_data => x_msg_data
1949: );

Line 1954: FND_MSG_PUB.Count_And_Get (

1950: EXCEPTION
1951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: -- Standard call to get message count and if count=1, get the message
1954: FND_MSG_PUB.Count_And_Get (
1955: p_encoded => FND_API.G_FALSE,
1956: p_count => x_msg_count,
1957: p_data => x_msg_data
1958: );

Line 1962: FND_MSG_PUB.Count_And_Get (

1958: );
1959: WHEN FND_API.G_EXC_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: -- Standard call to get message count and if count=1, get the message
1962: FND_MSG_PUB.Count_And_Get (
1963: p_encoded => FND_API.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => x_msg_data
1966: );

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

1965: p_data => x_msg_data
1966: );
1967: WHEN OTHERS THEN
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1971: END IF;
1972: -- Standard call to get message count and if count=1, get the message
1973: FND_MSG_PUB.Count_And_Get (

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

1966: );
1967: WHEN OTHERS THEN
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1971: END IF;
1972: -- Standard call to get message count and if count=1, get the message
1973: FND_MSG_PUB.Count_And_Get (
1974: p_encoded => FND_API.G_FALSE,

Line 1973: FND_MSG_PUB.Count_And_Get (

1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1971: END IF;
1972: -- Standard call to get message count and if count=1, get the message
1973: FND_MSG_PUB.Count_And_Get (
1974: p_encoded => FND_API.G_FALSE,
1975: p_count => x_msg_count,
1976: p_data => x_msg_data
1977: );