665: WHEN OTHERS THEN
666:
667: RAISE;
668:
669: /* FND_MESSAGE.SET_NAME('AMV','AMV_API_ERROR');
670:
671: FND_MESSAGE.Set_Token('API', 'Parse_IMT_String');
672:
673: FND_MSG_PUB.ADD;*/
667: RAISE;
668:
669: /* FND_MESSAGE.SET_NAME('AMV','AMV_API_ERROR');
670:
671: FND_MESSAGE.Set_Token('API', 'Parse_IMT_String');
672:
673: FND_MSG_PUB.ADD;*/
674:
675: END Parse_IMT_String;
6348: -- Debug Message
6349:
6350: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6351:
6352: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6353:
6354: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
6355:
6356: FND_MSG_PUB.Add;
6350: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6351:
6352: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6353:
6354: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
6355:
6356: FND_MSG_PUB.Add;
6357:
6358: END IF;
6390: -- User is not login.
6391:
6392: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6393:
6394: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
6395:
6396: FND_MSG_PUB.Add;
6397:
6398: END IF;
6548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
6549:
6550: THEN
6551:
6552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
6553:
6554: FND_MESSAGE.Set_Token('ROW', l_full_name);
6555:
6556: FND_MSG_PUB.Add;
6550: THEN
6551:
6552: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
6553:
6554: FND_MESSAGE.Set_Token('ROW', l_full_name);
6555:
6556: FND_MSG_PUB.Add;
6557:
6558: END IF;
6562: -- Debug Message
6563:
6564: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6565:
6566: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6567:
6568: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
6569:
6570: FND_MSG_PUB.Add;
6564: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6565:
6566: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6567:
6568: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
6569:
6570: FND_MSG_PUB.Add;
6571:
6572: END IF;
6958: -- Debug Message
6959:
6960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6961:
6962: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6963:
6964: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
6965:
6966: FND_MSG_PUB.Add;
6960: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
6961:
6962: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
6963:
6964: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
6965:
6966: FND_MSG_PUB.Add;
6967:
6968: END IF;
7000: -- User is not login.
7001:
7002: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7003:
7004: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7005:
7006: FND_MSG_PUB.Add;
7007:
7008: END IF;
7218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
7219:
7220: THEN
7221:
7222: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
7223:
7224: FND_MESSAGE.Set_Token('ROW', l_full_name);
7225:
7226: FND_MSG_PUB.Add;
7220: THEN
7221:
7222: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
7223:
7224: FND_MESSAGE.Set_Token('ROW', l_full_name);
7225:
7226: FND_MSG_PUB.Add;
7227:
7228: END IF;
7232: -- Debug Message
7233:
7234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7235:
7236: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7237:
7238: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
7239:
7240: FND_MSG_PUB.Add;
7234: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7235:
7236: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7237:
7238: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
7239:
7240: FND_MSG_PUB.Add;
7241:
7242: END IF;
7864: -- Debug Message
7865:
7866: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7867:
7868: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7869:
7870: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
7871:
7872: FND_MSG_PUB.Add;
7866: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
7867:
7868: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
7869:
7870: FND_MESSAGE.Set_Token('ROW',l_full_name||': Start');
7871:
7872: FND_MSG_PUB.Add;
7873:
7874: END IF;
7906: -- User is not login.
7907:
7908: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7909:
7910: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
7911:
7912: FND_MSG_PUB.Add;
7913:
7914: END IF;
7976: -- Must pass query string
7977:
7978: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7979:
7980: FND_MESSAGE.Set_name('AMV','AMV_SRCH_QRY_STR_NULL');
7981:
7982: FND_MSG_PUB.Add;
7983:
7984: END IF;
8102: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
8103:
8104: THEN
8105:
8106: FND_MESSAGE.Set_name('AMV','AMV_CAT_USR_NOACCS');
8107:
8108: FND_MESSAGE.Set_Token('TKN',p_user_id);
8109:
8110: FND_MSG_PUB.Add;
8104: THEN
8105:
8106: FND_MESSAGE.Set_name('AMV','AMV_CAT_USR_NOACCS');
8107:
8108: FND_MESSAGE.Set_Token('TKN',p_user_id);
8109:
8110: FND_MSG_PUB.Add;
8111:
8112: END IF;
8276: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
8277:
8278: THEN
8279:
8280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
8281:
8282: FND_MESSAGE.Set_Token('ROW', l_full_name);
8283:
8284: FND_MSG_PUB.Add;
8278: THEN
8279:
8280: FND_MESSAGE.Set_Name('AMV', 'AMV_API_SUCCESS_MESSAGE');
8281:
8282: FND_MESSAGE.Set_Token('ROW', l_full_name);
8283:
8284: FND_MSG_PUB.Add;
8285:
8286: END IF;
8290: -- Debug Message
8291:
8292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
8293:
8294: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
8295:
8296: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
8297:
8298: FND_MSG_PUB.Add;
8292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
8293:
8294: FND_MESSAGE.Set_Name('AMV','AMV_API_DEBUG_MESSAGE');
8295:
8296: FND_MESSAGE.Set_Token('ROW',l_full_name||': End');
8297:
8298: FND_MSG_PUB.Add;
8299:
8300: END IF;