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_API

Line 48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

44: --------------------------------------------------------------------------------
45: PROCEDURE Add_ContentType
46: (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,

Line 49: p_commit IN VARCHAR2 := FND_API.G_FALSE,

45: PROCEDURE Add_ContentType
46: (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,

Line 50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

46: (
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 54: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

50: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
55: p_content_type_name IN VARCHAR2,
56: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: x_content_type_id OUT NOCOPY NUMBER
58: ) IS

Line 56: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
55: p_content_type_name IN VARCHAR2,
56: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
57: x_content_type_id OUT NOCOPY NUMBER
58: ) IS
59: l_api_name CONSTANT VARCHAR2(30) := 'Add_ContentType';
60: l_api_version CONSTANT NUMBER := 1.0;

Line 80: IF NOT FND_API.Compatible_API_Call (

76: --
77: BEGIN
78: -- Standard call to check for call compatibility.
79: SAVEPOINT Add_ContentType_Pvt;
80: IF NOT FND_API.Compatible_API_Call (
81: l_api_version,
82: p_api_version,
83: l_api_name,
84: G_PKG_NAME) THEN

Line 85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

81: l_api_version,
82: p_api_version,
83: l_api_name,
84: G_PKG_NAME) THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: --Initialize message list if p_init_msg_list is TRUE.
88: IF FND_API.To_Boolean (p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;

Line 88: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: IF FND_API.To_Boolean (p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: -- Get the current (login) user id.
94: AMV_UTILITY_PVT.Get_UserInfo(
95: x_resource_id => l_resource_id,
96: x_user_id => l_current_user_id,

Line 100: IF (p_check_login_user = FND_API.G_TRUE) THEN

96: x_user_id => l_current_user_id,
97: x_login_id => l_current_login_id,
98: x_user_status => l_current_user_status
99: );
100: IF (p_check_login_user = FND_API.G_TRUE) THEN
101: -- Check if user is login and has the required privilege.
102: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
103: -- User is not login.
104: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 102: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

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

Line 108: RAISE FND_API.G_EXC_ERROR;

104: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
105: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
106: FND_MSG_PUB.Add;
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110: AMV_USER_PVT.Is_Administrator
111: (
112: p_api_version => 1.0,

Line 116: p_check_login_user => FND_API.G_FALSE,

112: p_api_version => 1.0,
113: x_return_status => x_return_status,
114: x_msg_count => x_msg_count,
115: x_msg_data => x_msg_data,
116: p_check_login_user => FND_API.G_FALSE,
117: p_resource_id => l_resource_id,
118: x_result_flag => l_admin_flag
119: );
120: IF (l_admin_flag <> FND_API.G_TRUE) THEN

Line 120: IF (l_admin_flag <> FND_API.G_TRUE) THEN

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

Line 126: RAISE FND_API.G_EXC_ERROR;

122: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
123: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
124: FND_MSG_PUB.Add;
125: END IF;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128: END IF;
129: -- This is to make database happy
130: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

Line 130: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128: END IF;
129: -- This is to make database happy
130: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
131: l_current_login_id := -1;
132: l_current_user_id := -1;
133: END IF;
134: OPEN Check_DupContTypeName_csr(p_content_type_name);

Line 145: RAISE FND_API.G_EXC_ERROR;

141: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
142: FND_MESSAGE.Set_Token('NAME', p_content_type_name);
143: FND_MSG_PUB.Add;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: CLOSE Check_DupContTypeName_csr;
148: --
149: OPEN Get_DateAndId_csr;

Line 153: IF (p_cnt_type_description = FND_API.G_MISS_CHAR) THEN

149: OPEN Get_DateAndId_csr;
150: FETCH Get_DateAndId_csr Into l_content_type_id, l_current_date;
151: CLOSE Get_DateAndId_csr;
152: --
153: IF (p_cnt_type_description = FND_API.G_MISS_CHAR) THEN
154: l_description := NULL;
155: ELSE
156: l_description := p_cnt_type_description;
157: END IF;

Line 173: IF FND_API.To_Boolean ( p_commit ) THEN

169: X_LAST_UPDATED_BY => l_current_user_id,
170: X_LAST_UPDATE_LOGIN => l_current_login_id
171: );
172: --Standard check of commit
173: IF FND_API.To_Boolean ( p_commit ) THEN
174: COMMIT WORK;
175: END IF;
176: --Standard call to get message count and if count=1, get the message
177: FND_MSG_PUB.Count_And_Get (

Line 178: p_encoded => FND_API.G_FALSE,

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

Line 183: WHEN FND_API.G_EXC_ERROR THEN

179: p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO Add_ContentType_Pvt;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 188: p_encoded => FND_API.G_FALSE,

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

Line 192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 197: p_encoded => FND_API.G_FALSE,

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

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 209: p_encoded => FND_API.G_FALSE,

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

Line 219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

215: --------------------------------------------------------------------------------
216: PROCEDURE Delete_ContentType
217: (
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,

Line 220: p_commit IN VARCHAR2 := FND_API.G_FALSE,

216: PROCEDURE Delete_ContentType
217: (
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,

Line 221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

217: (
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 225: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
226: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
228: ) IS
229: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ContentType';

Line 226: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,

222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
226: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
228: ) IS
229: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ContentType';
230: l_api_version CONSTANT NUMBER := 1.0;

Line 227: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR

223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
226: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
227: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
228: ) IS
229: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ContentType';
230: l_api_version CONSTANT NUMBER := 1.0;
231: l_resource_id NUMBER := -1;

Line 249: IF NOT FND_API.Compatible_API_Call (

245: --
246: BEGIN
247: -- Standard call to check for call compatibility.
248: SAVEPOINT Delete_ContentType_Pvt;
249: IF NOT FND_API.Compatible_API_Call (
250: l_api_version,
251: p_api_version,
252: l_api_name,
253: G_PKG_NAME) THEN

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: l_api_version,
251: p_api_version,
252: l_api_name,
253: G_PKG_NAME) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: --Initialize message list if p_init_msg_list is TRUE.
257: IF FND_API.To_Boolean (p_init_msg_list) THEN
258: FND_MSG_PUB.initialize;

Line 257: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257: IF FND_API.To_Boolean (p_init_msg_list) THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260: -- Initialize API return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262: -- Get the current (login) user id.
263: AMV_UTILITY_PVT.Get_UserInfo(
264: x_resource_id => l_resource_id,
265: x_user_id => l_current_user_id,

Line 269: IF (p_check_login_user = FND_API.G_TRUE) THEN

265: x_user_id => l_current_user_id,
266: x_login_id => l_current_login_id,
267: x_user_status => l_current_user_status
268: );
269: IF (p_check_login_user = FND_API.G_TRUE) THEN
270: -- Check if user is login and has the required privilege.
271: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
272: -- User is not login.
273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 271: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

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

Line 277: RAISE FND_API.G_EXC_ERROR;

273: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
275: FND_MSG_PUB.Add;
276: END IF;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: AMV_USER_PVT.Is_Administrator
280: (
281: p_api_version => 1.0,

Line 285: p_check_login_user => FND_API.G_FALSE,

281: p_api_version => 1.0,
282: x_return_status => x_return_status,
283: x_msg_count => x_msg_count,
284: x_msg_data => x_msg_data,
285: p_check_login_user => FND_API.G_FALSE,
286: p_resource_id => l_resource_id,
287: x_result_flag => l_admin_flag
288: );
289: IF (l_admin_flag <> FND_API.G_TRUE) THEN

Line 289: IF (l_admin_flag <> FND_API.G_TRUE) THEN

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

Line 295: RAISE FND_API.G_EXC_ERROR;

291: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
292: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
293: FND_MSG_PUB.Add;
294: END IF;
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: END IF;
298: -- This is to make database happy
299: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

Line 299: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297: END IF;
298: -- This is to make database happy
299: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
300: l_current_login_id := -1;
301: l_current_user_id := -1;
302: END IF;
303: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN

Line 303: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN

299: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
300: l_current_login_id := -1;
301: l_current_user_id := -1;
302: END IF;
303: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN
304: -- Check if user pass the valid content type id
305: IF AMV_UTILITY_PVT.Is_ContentTypeIdValid(p_content_type_id) = TRUE THEN
306: l_content_type_id := p_content_type_id;
307: ELSE

Line 314: RAISE FND_API.G_EXC_ERROR;

310: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
311: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
312: FND_MSG_PUB.Add;
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN
317: OPEN Check_ValidContTypeName_csr(p_content_type_name);
318: FETCH Check_ValidContTypeName_csr Into l_content_type_id;

Line 316: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN

312: FND_MSG_PUB.Add;
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN
317: OPEN Check_ValidContTypeName_csr(p_content_type_name);
318: FETCH Check_ValidContTypeName_csr Into l_content_type_id;
319: IF (Check_ValidContTypeName_csr%NOTFOUND) THEN
320: CLOSE Check_ValidContTypeName_csr;

Line 327: RAISE FND_API.G_EXC_ERROR;

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

Line 336: RAISE FND_API.G_EXC_ERROR;

332: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
333: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
334: FND_MSG_PUB.Add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: --
339: -- Check if any item uses this content type. If so, error out.
340: OPEN Get_Item_csr (l_content_type_id);

Line 349: RAISE FND_API.G_EXC_ERROR;

345: FND_MESSAGE.Set_name('AMV','AMV_ITEM_USING_ATTR');
346: FND_MESSAGE.Set_Token('RECORDID', TO_CHAR(l_item_id) );
347: FND_MSG_PUB.Add;
348: END IF;
349: RAISE FND_API.G_EXC_ERROR;
350: ELSE
351: CLOSE Get_Item_csr;
352: END IF;
353: -- Now do the deleting:

Line 362: IF FND_API.To_Boolean ( p_commit ) THEN

358: (
359: X_CONTENT_TYPE_ID => l_content_type_id
360: );
361: --Standard check of commit
362: IF FND_API.To_Boolean ( p_commit ) THEN
363: COMMIT WORK;
364: END IF;
365: --Standard call to get message count and if count=1, get the message
366: FND_MSG_PUB.Count_And_Get (

Line 367: p_encoded => FND_API.G_FALSE,

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

Line 372: WHEN FND_API.G_EXC_ERROR THEN

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

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 377: p_encoded => FND_API.G_FALSE,

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

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 386: p_encoded => FND_API.G_FALSE,

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

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 398: p_encoded => FND_API.G_FALSE,

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

Line 408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

404: --------------------------------------------------------------------------------
405: PROCEDURE Update_ContentType
406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY NUMBER,

Line 409: p_commit IN VARCHAR2 := FND_API.G_FALSE,

405: PROCEDURE Update_ContentType
406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY NUMBER,
413: x_msg_data OUT NOCOPY VARCHAR2,

Line 410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY NUMBER,
413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

410: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY NUMBER,
413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
415: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 415: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,

411: x_return_status OUT NOCOPY VARCHAR2,
412: x_msg_count OUT NOCOPY NUMBER,
413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
415: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
419: ) IS

Line 416: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

412: x_msg_count OUT NOCOPY NUMBER,
413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
415: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
419: ) IS
420: l_api_name CONSTANT VARCHAR2(30) := 'Update_ContentType';

Line 417: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

413: x_msg_data OUT NOCOPY VARCHAR2,
414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
415: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
419: ) IS
420: l_api_name CONSTANT VARCHAR2(30) := 'Update_ContentType';
421: l_api_version CONSTANT NUMBER := 1.0;

Line 418: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR

414: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
415: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
416: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
419: ) IS
420: l_api_name CONSTANT VARCHAR2(30) := 'Update_ContentType';
421: l_api_version CONSTANT NUMBER := 1.0;
422: l_resource_id NUMBER := -1;

Line 441: IF NOT FND_API.Compatible_API_Call (

437: --
438: BEGIN
439: -- Standard call to check for call compatibility.
440: SAVEPOINT Update_ContentType_Pvt;
441: IF NOT FND_API.Compatible_API_Call (
442: l_api_version,
443: p_api_version,
444: l_api_name,
445: G_PKG_NAME) THEN

Line 446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

442: l_api_version,
443: p_api_version,
444: l_api_name,
445: G_PKG_NAME) THEN
446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
447: END IF;
448: --Initialize message list if p_init_msg_list is TRUE.
449: IF FND_API.To_Boolean (p_init_msg_list) THEN
450: FND_MSG_PUB.initialize;

Line 449: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: IF FND_API.To_Boolean (p_init_msg_list) THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452: -- Initialize API return status to success
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454: -- Get the current (login) user id.
455: AMV_UTILITY_PVT.Get_UserInfo(
456: x_resource_id => l_resource_id,
457: x_user_id => l_current_user_id,

Line 461: IF (p_check_login_user = FND_API.G_TRUE) THEN

457: x_user_id => l_current_user_id,
458: x_login_id => l_current_login_id,
459: x_user_status => l_current_user_status
460: );
461: IF (p_check_login_user = FND_API.G_TRUE) THEN
462: -- Check if user is login and has the required privilege.
463: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
464: -- User is not login.
465: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 463: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

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

Line 469: RAISE FND_API.G_EXC_ERROR;

465: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
466: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
467: FND_MSG_PUB.Add;
468: END IF;
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471: AMV_USER_PVT.Is_Administrator
472: (
473: p_api_version => 1.0,

Line 477: p_check_login_user => FND_API.G_FALSE,

473: p_api_version => 1.0,
474: x_return_status => x_return_status,
475: x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data,
477: p_check_login_user => FND_API.G_FALSE,
478: p_resource_id => l_resource_id,
479: x_result_flag => l_admin_flag
480: );
481: IF (l_admin_flag <> FND_API.G_TRUE) THEN

Line 481: IF (l_admin_flag <> FND_API.G_TRUE) THEN

477: p_check_login_user => FND_API.G_FALSE,
478: p_resource_id => l_resource_id,
479: x_result_flag => l_admin_flag
480: );
481: IF (l_admin_flag <> FND_API.G_TRUE) THEN
482: -- User is not an administrator.
483: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
484: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
485: FND_MSG_PUB.Add;

Line 487: RAISE FND_API.G_EXC_ERROR;

483: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
484: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_HAVE_PRIVILEGE');
485: FND_MSG_PUB.Add;
486: END IF;
487: RAISE FND_API.G_EXC_ERROR;
488: END IF;
489: END IF;
490: -- This is to make database happy
491: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

Line 491: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

487: RAISE FND_API.G_EXC_ERROR;
488: END IF;
489: END IF;
490: -- This is to make database happy
491: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
492: l_current_login_id := -1;
493: l_current_user_id := -1;
494: END IF;
495: -- Ensure the name is not used yet.

Line 506: RAISE FND_API.G_EXC_ERROR;

502: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
503: FND_MESSAGE.Set_Token('NAME', p_content_type_new_name);
504: FND_MSG_PUB.Add;
505: END IF;
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;
508: CLOSE Check_DupContTypeName_csr;
509: --
510: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN

Line 510: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN

506: RAISE FND_API.G_EXC_ERROR;
507: END IF;
508: CLOSE Check_DupContTypeName_csr;
509: --
510: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN
511: -- Check if user pass the valid content type id
512: IF AMV_UTILITY_PVT.Is_ContentTypeIdValid(p_content_type_id) = TRUE THEN
513: l_content_type_id := p_content_type_id;
514: ELSE

Line 521: RAISE FND_API.G_EXC_ERROR;

517: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
518: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
519: FND_MSG_PUB.Add;
520: END IF;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN
524: OPEN Check_ValidContTypeName_csr(p_content_type_name);
525: FETCH Check_ValidContTypeName_csr Into l_content_type_id;

Line 523: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN

519: FND_MSG_PUB.Add;
520: END IF;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN
524: OPEN Check_ValidContTypeName_csr(p_content_type_name);
525: FETCH Check_ValidContTypeName_csr Into l_content_type_id;
526: IF (Check_ValidContTypeName_csr%NOTFOUND) THEN
527: CLOSE Check_ValidContTypeName_csr;

Line 534: RAISE FND_API.G_EXC_ERROR;

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

Line 543: RAISE FND_API.G_EXC_ERROR;

539: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
540: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
541: FND_MSG_PUB.Add;
542: END IF;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545: -- Get the current version number
546: OPEN Get_Version_csr(l_content_type_id);
547: FETCH Get_Version_csr INTO l_object_version;

Line 566: IF FND_API.To_Boolean ( p_commit ) THEN

562: X_LAST_UPDATED_BY => l_current_user_id,
563: X_LAST_UPDATE_LOGIN => l_current_login_id
564: );
565: --Standard check of commit
566: IF FND_API.To_Boolean ( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569: --Standard call to get message count and if count=1, get the message
570: FND_MSG_PUB.Count_And_Get (

Line 571: p_encoded => FND_API.G_FALSE,

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

Line 576: WHEN FND_API.G_EXC_ERROR THEN

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

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 581: p_encoded => FND_API.G_FALSE,

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

Line 585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 590: p_encoded => FND_API.G_FALSE,

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

Line 596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 602: p_encoded => FND_API.G_FALSE,

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

Line 612: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

608: --------------------------------------------------------------------------------
609: PROCEDURE Get_ContentType
610: (
611: p_api_version IN NUMBER,
612: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,

Line 613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

609: PROCEDURE Get_ContentType
610: (
611: p_api_version IN NUMBER,
612: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 617: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
618: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
619: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: x_content_type_obj OUT NOCOPY AMV_CONTENT_TYPE_OBJ_TYPE
621: ) IS

Line 618: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,

614: x_return_status OUT NOCOPY VARCHAR2,
615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
618: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
619: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: x_content_type_obj OUT NOCOPY AMV_CONTENT_TYPE_OBJ_TYPE
621: ) IS
622: l_api_name CONSTANT VARCHAR2(30) := 'Get_ContentType';

Line 619: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

615: x_msg_count OUT NOCOPY NUMBER,
616: x_msg_data OUT NOCOPY VARCHAR2,
617: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
618: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
619: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
620: x_content_type_obj OUT NOCOPY AMV_CONTENT_TYPE_OBJ_TYPE
621: ) IS
622: l_api_name CONSTANT VARCHAR2(30) := 'Get_ContentType';
623: l_api_version CONSTANT NUMBER := 1.0;

Line 653: IF NOT FND_API.Compatible_API_Call (

649: l_content_type_rec Get_CntTypeRecord_csr%ROWTYPE;
650: --
651: BEGIN
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call (
654: l_api_version,
655: p_api_version,
656: l_api_name,
657: G_PKG_NAME) THEN

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: l_api_version,
655: p_api_version,
656: l_api_name,
657: G_PKG_NAME) THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660: --Initialize message list if p_init_msg_list is TRUE.
661: IF FND_API.To_Boolean (p_init_msg_list) THEN
662: FND_MSG_PUB.initialize;

Line 661: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

Line 665: x_return_status := FND_API.G_RET_STS_SUCCESS;

661: IF FND_API.To_Boolean (p_init_msg_list) THEN
662: FND_MSG_PUB.initialize;
663: END IF;
664: -- Initialize API return status to success
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666: -- Get the current (login) user id.
667: AMV_UTILITY_PVT.Get_UserInfo(
668: x_resource_id => l_resource_id,
669: x_user_id => l_current_user_id,

Line 673: IF (p_check_login_user = FND_API.G_TRUE) THEN

669: x_user_id => l_current_user_id,
670: x_login_id => l_current_login_id,
671: x_user_status => l_current_user_status
672: );
673: IF (p_check_login_user = FND_API.G_TRUE) THEN
674: -- Check if user is login and has the required privilege.
675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
676: -- User is not login.
677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 675: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

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

Line 681: RAISE FND_API.G_EXC_ERROR;

677: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
678: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
679: FND_MSG_PUB.Add;
680: END IF;
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683: END IF;
684: -- This is to make database happy
685: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

Line 685: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683: END IF;
684: -- This is to make database happy
685: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
686: l_current_login_id := -1;
687: l_current_user_id := -1;
688: END IF;
689: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN

Line 689: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN

685: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
686: l_current_login_id := -1;
687: l_current_user_id := -1;
688: END IF;
689: IF (p_content_type_id <> FND_API.G_MISS_NUM) THEN
690: -- Check if user pass the valid content type id
691: IF AMV_UTILITY_PVT.Is_ContentTypeIdValid(p_content_type_id) = TRUE THEN
692: l_content_type_id := p_content_type_id;
693: ELSE

Line 700: RAISE FND_API.G_EXC_ERROR;

696: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
697: FND_MESSAGE.Set_Token('ID', to_char(p_content_type_id));
698: FND_MSG_PUB.Add;
699: END IF;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN
703: OPEN Check_ValidContTypeName_csr(p_content_type_name);
704: FETCH Check_ValidContTypeName_csr Into l_content_type_id;

Line 702: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN

698: FND_MSG_PUB.Add;
699: END IF;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702: ELSIF (p_content_type_name <> FND_API.G_MISS_CHAR) THEN
703: OPEN Check_ValidContTypeName_csr(p_content_type_name);
704: FETCH Check_ValidContTypeName_csr Into l_content_type_id;
705: IF (Check_ValidContTypeName_csr%NOTFOUND) THEN
706: CLOSE Check_ValidContTypeName_csr;

Line 713: RAISE FND_API.G_EXC_ERROR;

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

Line 722: RAISE FND_API.G_EXC_ERROR;

718: FND_MESSAGE.Set_name('AMV','AMV_NEED_RECORD_NAME_OR_ID');
719: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
720: FND_MSG_PUB.Add;
721: END IF;
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724: -- Now query and return the content type record
725: OPEN Get_CntTypeRecord_csr(l_content_type_id);
726: FETCH Get_CntTypeRecord_csr INTO l_content_type_rec;

Line 734: RAISE FND_API.G_EXC_ERROR;

730: FND_MESSAGE.Set_name('AMV','AMV_RECORD_NOT_FOUND');
731: FND_MESSAGE.Set_Token('RECORD', 'AMV_CONTENTTYPE_TK', TRUE);
732: FND_MSG_PUB.Add;
733: END IF;
734: RAISE FND_API.G_EXC_ERROR;
735: ELSE
736: x_content_type_obj.content_type_id := l_content_type_rec.content_type_id;
737: x_content_type_obj.object_version_number := l_content_type_rec.object_version_number;
738: x_content_type_obj.content_type_name := l_content_type_rec.content_type_name;

Line 767: p_encoded => FND_API.G_FALSE,

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

Line 772: WHEN FND_API.G_EXC_ERROR THEN

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

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 776: p_encoded => FND_API.G_FALSE,

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

Line 780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 784: p_encoded => FND_API.G_FALSE,

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

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 795: p_encoded => FND_API.G_FALSE,

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

Line 806: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

802: --------------------------------------------------------------------------------
803: PROCEDURE Find_ContentType
804: (
805: p_api_version IN NUMBER,
806: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,

Line 807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

803: PROCEDURE Find_ContentType
804: (
805: p_api_version IN NUMBER,
806: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,
811: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 811: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

807: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,
811: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
812: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
815: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 812: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,
811: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
812: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
815: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
816: x_content_type_obj_varray OUT NOCOPY AMV_CONTENT_TYPE_OBJ_VARRAY

Line 813: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2,
811: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
812: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
813: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
814: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
815: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
816: x_content_type_obj_varray OUT NOCOPY AMV_CONTENT_TYPE_OBJ_VARRAY
817: ) IS

Line 848: IF NOT FND_API.Compatible_API_Call (

844: l_last_update_login NUMBER;
845: --
846: BEGIN
847: -- Standard call to check for call compatibility.
848: IF NOT FND_API.Compatible_API_Call (
849: l_api_version,
850: p_api_version,
851: l_api_name,
852: G_PKG_NAME) THEN

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

849: l_api_version,
850: p_api_version,
851: l_api_name,
852: G_PKG_NAME) THEN
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END IF;
855: --Initialize message list if p_init_msg_list is TRUE.
856: IF FND_API.To_Boolean (p_init_msg_list) THEN
857: FND_MSG_PUB.initialize;

Line 856: IF FND_API.To_Boolean (p_init_msg_list) THEN

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

Line 860: x_return_status := FND_API.G_RET_STS_SUCCESS;

856: IF FND_API.To_Boolean (p_init_msg_list) THEN
857: FND_MSG_PUB.initialize;
858: END IF;
859: -- Initialize API return status to success
860: x_return_status := FND_API.G_RET_STS_SUCCESS;
861: -- Get the current (login) user id.
862: AMV_UTILITY_PVT.Get_UserInfo(
863: x_resource_id => l_resource_id,
864: x_user_id => l_current_user_id,

Line 868: IF (p_check_login_user = FND_API.G_TRUE) THEN

864: x_user_id => l_current_user_id,
865: x_login_id => l_current_login_id,
866: x_user_status => l_current_user_status
867: );
868: IF (p_check_login_user = FND_API.G_TRUE) THEN
869: -- Check if user is login and has the required privilege.
870: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
871: -- User is not login.
872: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 870: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

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

Line 876: RAISE FND_API.G_EXC_ERROR;

872: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
873: FND_MESSAGE.Set_name('AMV','AMV_USER_NOT_LOGIN');
874: FND_MSG_PUB.Add;
875: END IF;
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879: -- This is to make database happy
880: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

Line 880: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN

876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879: -- This is to make database happy
880: IF (l_current_login_id = FND_API.G_MISS_NUM) THEN
881: l_current_login_id := -1;
882: l_current_user_id := -1;
883: END IF;
884: -- Now create SQL statement and find the results:

Line 907: p_content_type_name <> FND_API.G_MISS_CHAR) THEN

903: l_where_clause :=
904: 'Where B.CONTENT_TYPE_ID = T.CONTENT_TYPE_ID ' ||
905: 'And T.LANGUAGE = userenv(''LANG'') ';
906: IF (p_content_type_name IS NOT NULL AND
907: p_content_type_name <> FND_API.G_MISS_CHAR) THEN
908: l_where_clause := l_where_clause ||
909: 'And T.CONTENT_TYPE_NAME Like ''' || p_content_type_name || ''' ';
910: END IF;
911: IF (p_cnt_type_description IS NOT NULL AND

Line 912: p_cnt_type_description <> FND_API.G_MISS_CHAR) THEN

908: l_where_clause := l_where_clause ||
909: 'And T.CONTENT_TYPE_NAME Like ''' || p_content_type_name || ''' ';
910: END IF;
911: IF (p_cnt_type_description IS NOT NULL AND
912: p_cnt_type_description <> FND_API.G_MISS_CHAR) THEN
913: l_where_clause := l_where_clause ||
914: 'And T.DESCRIPTION Like ''' || p_cnt_type_description || ''' ';
915: END IF;
916: l_sql_statement := l_sql_statement ||

Line 931: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN

927: FND_MSG_PUB.Add;
928: END IF;
929:
930: --Execute the SQL statements to get the total count:
931: IF (p_subset_request_obj.return_total_count_flag = FND_API.G_TRUE) THEN
932: OPEN l_cursor FOR l_sql_statement2;
933: FETCH l_cursor INTO l_total_record_count;
934: CLOSE l_cursor;
935: END IF;

Line 1008: p_encoded => FND_API.G_FALSE,

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

Line 1013: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1014: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1017: p_encoded => FND_API.G_FALSE,

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

Line 1021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1025: p_encoded => FND_API.G_FALSE,

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

Line 1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1036: p_encoded => FND_API.G_FALSE,

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