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_MESSAGE

Line 105: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

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;
109: END IF;

Line 123: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

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;
127: END IF;

Line 140: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');

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;
144: END IF;

Line 141: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;

Line 142: FND_MESSAGE.Set_Token('NAME', p_content_type_name);

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;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;

Line 274: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

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;
278: END IF;

Line 292: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

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;
296: END IF;

Line 309: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

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;
313: END IF;

Line 310: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;

Line 311: FND_MESSAGE.Set_Token('ID', to_char(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;
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;

Line 322: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');

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;
326: END IF;

Line 323: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;

Line 324: FND_MESSAGE.Set_Token('NAME', p_content_type_name);

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;
326: END IF;
327: RAISE FND_API.G_EXC_ERROR;
328: END IF;

Line 332: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');

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;
336: RAISE FND_API.G_EXC_ERROR;

Line 333: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;

Line 345: FND_MESSAGE.Set_name('AMV','AMV_ITEM_USING_ATTR');

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;
349: RAISE FND_API.G_EXC_ERROR;

Line 346: FND_MESSAGE.Set_Token('RECORDID', TO_CHAR(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;
349: RAISE FND_API.G_EXC_ERROR;
350: ELSE

Line 466: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

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;
470: END IF;

Line 484: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');

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;
488: END IF;

Line 501: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_DUPLICATED');

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;
505: END IF;

Line 502: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
505: END IF;
506: RAISE FND_API.G_EXC_ERROR;

Line 503: FND_MESSAGE.Set_Token('NAME', p_content_type_new_name);

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;
505: END IF;
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;

Line 516: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

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;
520: END IF;

Line 517: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
520: END IF;
521: RAISE FND_API.G_EXC_ERROR;

Line 518: FND_MESSAGE.Set_Token('ID', to_char(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;
520: END IF;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;

Line 529: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');

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;
533: END IF;

Line 530: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
533: END IF;
534: RAISE FND_API.G_EXC_ERROR;

Line 531: FND_MESSAGE.Set_Token('NAME', p_content_type_name);

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;
533: END IF;
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;

Line 539: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');

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;
543: RAISE FND_API.G_EXC_ERROR;

Line 540: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;

Line 551: FND_MESSAGE.Set_name('AMV','Updating Content Type.');

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:
555: AMV_I_CONTENT_TYPES_PKG.UPDATE_ROW

Line 678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

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;
682: END IF;

Line 695: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');

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;
699: END IF;

Line 696: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
699: END IF;
700: RAISE FND_API.G_EXC_ERROR;

Line 697: FND_MESSAGE.Set_Token('ID', to_char(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;
699: END IF;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;

Line 708: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NAME_MISSING');

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;
712: END IF;

Line 709: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
712: END IF;
713: RAISE FND_API.G_EXC_ERROR;

Line 710: FND_MESSAGE.Set_Token('NAME', p_content_type_name);

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;
712: END IF;
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;

Line 718: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');

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;
722: RAISE FND_API.G_EXC_ERROR;

Line 719: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;

Line 730: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NOT_FOUND');

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;
734: RAISE FND_API.G_EXC_ERROR;

Line 731: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);

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;
734: RAISE FND_API.G_EXC_ERROR;
735: ELSE

Line 873: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');

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;
877: END IF;

Line 921: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');

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: --
925: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');

Line 922: FND_MESSAGE.Set_Token('ROW', l_sql_statement);

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: --
925: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');
926: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);

Line 925: FND_MESSAGE.Set_name('AMV','AMV_API_DEBUG_MESSAGE');

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;
928: END IF;
929:

Line 926: FND_MESSAGE.Set_Token('ROW', l_sql_statement2);

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;
928: END IF;
929:
930: --Execute the SQL statements to get the total count: