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.IBC_CITEM_RUNTIME_PUB dependencies on FND_API

Line 18: -- Default = FND_API.G_FALSE

14: -- based on association.
15: -- Parameters :
16: -- IN : p_api_version IN NUMBER Required
17: -- p_init_msg_list IN VARCHAR2 Optional
18: -- Default = FND_API.G_FALSE
19: -- p_association_type_code IN VARCHAR2 Required
20: -- p_associated_object_val1 IN VARCHAR2 Required
21: -- p_associated_object_val2 IN VARCHAR2 Optional
22: -- Default = NULL

Line 57: l_item_found VARCHAR2(1) := FND_API.G_TRUE;

53: l_api_version CONSTANT NUMBER := 1.0;
54: --
55: l_citem_count NUMBER := 1;
56: l_citem_meta_rec Content_Item_Meta_Rec;
57: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
58: --
59: CURSOR Get_Citems_By_Assoc IS
60: select CONTENT_ITEM_ID
61: from IBC_ASSOCIATIONS

Line 73: IF NOT FND_API.Compatible_API_Call (

69: BEGIN
70: -- ******* Standard Begins ********
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call (
74: l_api_version,
75: p_api_version,
76: l_api_name,
77: G_PKG_NAME)

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: p_api_version,
76: l_api_name,
77: G_PKG_NAME)
78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list )
83: THEN

Line 82: IF FND_API.to_Boolean( p_init_msg_list )

78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list )
83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: FND_MSG_PUB.initialize;
85: END IF;
86:
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: --******************* Real Logic Start *********************
91:
92: x_content_item_meta_tbl := CONTENT_ITEM_META_TBL();

Line 105: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

101: x_return_status,
102: x_msg_count,
103: x_msg_data);
104: -- Content Item is not valid
105: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: IF (l_item_found = FND_API.G_TRUE) THEN

Line 106: RAISE FND_API.G_EXC_ERROR;

102: x_msg_count,
103: x_msg_data);
104: -- Content Item is not valid
105: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: IF (l_item_found = FND_API.G_TRUE) THEN
110: x_content_item_meta_tbl.EXTEND();

Line 109: IF (l_item_found = FND_API.G_TRUE) THEN

105: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: IF (l_item_found = FND_API.G_TRUE) THEN
110: x_content_item_meta_tbl.EXTEND();
111: x_content_item_meta_tbl(l_citem_count) := l_citem_meta_rec;
112: l_citem_count := l_citem_count + 1;
113: END IF;

Line 119: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN

115: END LOOP;
116:
117: -- If no matches, check if p_association_type_code is valid
118: IF (l_citem_count = 1) THEN
119: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN
120: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
121: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
122: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
123: FND_MSG_PUB.ADD;

Line 125: RAISE FND_API.G_EXC_ERROR;

121: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
122: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
123: FND_MSG_PUB.ADD;
124: END IF;
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127: END IF;
128:
129: --******************* Real Logic End ***********************

Line 135: WHEN FND_API.G_EXC_ERROR THEN

131: -- Standard call to get message count and if count=1, get the message
132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
133: p_data => x_msg_data);
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
133: p_data => x_msg_data);
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

135: WHEN FND_API.G_EXC_ERROR THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
142: p_data => x_msg_data);
143: WHEN OTHERS THEN

Line 140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

136: x_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
142: p_data => x_msg_data);
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
142: p_data => x_msg_data);
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
146: THEN
147: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
148: END IF;

Line 164: -- Default = FND_API.G_FALSE

160: -- based on association and content type.
161: -- Parameters :
162: -- IN : p_api_version IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Optional
164: -- Default = FND_API.G_FALSE
165: -- p_association_type_code IN VARCHAR2 Required
166: -- p_associated_object_val1 IN VARCHAR2 Required
167: -- p_associated_object_val2 IN VARCHAR2 Optional
168: -- Default = NULL

Line 205: l_item_found VARCHAR2(1) := FND_API.g_true;

201: l_api_version CONSTANT NUMBER := 1.0;
202: --
203: l_citem_count NUMBER := 1;
204: l_citem_meta_rec Content_Item_Meta_Rec;
205: l_item_found VARCHAR2(1) := FND_API.g_true;
206: l_invalid_input VARCHAR2(1) := FND_API.g_false;
207: --
208: CURSOR Get_Citems_By_Assoc_Ctype IS
209: select c.CONTENT_ITEM_ID

Line 206: l_invalid_input VARCHAR2(1) := FND_API.g_false;

202: --
203: l_citem_count NUMBER := 1;
204: l_citem_meta_rec Content_Item_Meta_Rec;
205: l_item_found VARCHAR2(1) := FND_API.g_true;
206: l_invalid_input VARCHAR2(1) := FND_API.g_false;
207: --
208: CURSOR Get_Citems_By_Assoc_Ctype IS
209: select c.CONTENT_ITEM_ID
210: from IBC_ASSOCIATIONS a, IBC_CONTENT_ITEMS c

Line 224: IF NOT FND_API.Compatible_API_Call (

220: BEGIN
221: -- ******* Standard Begins ********
222:
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call (
225: l_api_version,
226: p_api_version,
227: l_api_name,
228: G_PKG_NAME)

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: p_api_version,
227: l_api_name,
228: G_PKG_NAME)
229: THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: END IF;
232: -- Initialize message list if p_init_msg_list is set to TRUE.
233: IF FND_API.to_Boolean( p_init_msg_list )
234: THEN

Line 233: IF FND_API.to_Boolean( p_init_msg_list )

229: THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: END IF;
232: -- Initialize message list if p_init_msg_list is set to TRUE.
233: IF FND_API.to_Boolean( p_init_msg_list )
234: THEN
235: FND_MSG_PUB.initialize;
236: END IF;
237:

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

235: FND_MSG_PUB.initialize;
236: END IF;
237:
238: -- Initialize API return status to success
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: --******************* Real Logic Start *********************
242:
243: x_content_item_meta_tbl := CONTENT_ITEM_META_TBL();

Line 256: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

252: x_return_status,
253: x_msg_count,
254: x_msg_data);
255: -- Content Item is not valid
256: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF (l_item_found = FND_API.G_TRUE) THEN

Line 257: RAISE FND_API.G_EXC_ERROR;

253: x_msg_count,
254: x_msg_data);
255: -- Content Item is not valid
256: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF (l_item_found = FND_API.G_TRUE) THEN
261: x_content_item_meta_tbl.EXTEND();

Line 260: IF (l_item_found = FND_API.G_TRUE) THEN

256: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF (l_item_found = FND_API.G_TRUE) THEN
261: x_content_item_meta_tbl.EXTEND();
262: x_content_item_meta_tbl(l_citem_count) := l_citem_meta_rec;
263: l_citem_count := l_citem_count + 1;
264: END IF;

Line 270: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN

266: END LOOP;
267:
268: -- If no matches, check if p_association_type_code, p_content_type_code are valid
269: IF (l_citem_count = 1) THEN
270: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN
271: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
273: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
274: FND_MSG_PUB.ADD;

Line 276: l_invalid_input := FND_API.g_true;

272: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
273: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
274: FND_MSG_PUB.ADD;
275: END IF;
276: l_invalid_input := FND_API.g_true;
277: END IF;
278: IF (Ibc_Validate_Pvt.isValidCType(p_content_type_code) = FND_API.g_false) THEN
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBC', 'INVALID_CONTENT_TYPE_CODE');

Line 278: IF (Ibc_Validate_Pvt.isValidCType(p_content_type_code) = FND_API.g_false) THEN

274: FND_MSG_PUB.ADD;
275: END IF;
276: l_invalid_input := FND_API.g_true;
277: END IF;
278: IF (Ibc_Validate_Pvt.isValidCType(p_content_type_code) = FND_API.g_false) THEN
279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
280: FND_MESSAGE.Set_Name('IBC', 'INVALID_CONTENT_TYPE_CODE');
281: FND_MESSAGE.Set_token('CONTENT_TYPE_CODE', p_content_type_code);
282: FND_MSG_PUB.ADD;

Line 284: l_invalid_input := FND_API.g_true;

280: FND_MESSAGE.Set_Name('IBC', 'INVALID_CONTENT_TYPE_CODE');
281: FND_MESSAGE.Set_token('CONTENT_TYPE_CODE', p_content_type_code);
282: FND_MSG_PUB.ADD;
283: END IF;
284: l_invalid_input := FND_API.g_true;
285: END IF;
286: IF (l_invalid_input = FND_API.g_true) THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;

Line 286: IF (l_invalid_input = FND_API.g_true) THEN

282: FND_MSG_PUB.ADD;
283: END IF;
284: l_invalid_input := FND_API.g_true;
285: END IF;
286: IF (l_invalid_input = FND_API.g_true) THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: END IF;
290:

Line 287: RAISE FND_API.G_EXC_ERROR;

283: END IF;
284: l_invalid_input := FND_API.g_true;
285: END IF;
286: IF (l_invalid_input = FND_API.g_true) THEN
287: RAISE FND_API.G_EXC_ERROR;
288: END IF;
289: END IF;
290:
291: --******************* Real Logic End ***********************

Line 297: WHEN FND_API.G_EXC_ERROR THEN

293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
295: p_data => x_msg_data);
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
295: p_data => x_msg_data);
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: WHEN FND_API.G_EXC_ERROR THEN
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
304: p_data => x_msg_data);
305: WHEN OTHERS THEN

Line 302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

298: x_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
304: p_data => x_msg_data);
305: WHEN OTHERS THEN
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
304: p_data => x_msg_data);
305: WHEN OTHERS THEN
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
310: END IF;

Line 327: -- Default = FND_API.G_FALSE

323: -- based on the given list of content item ids.
324: -- Parameters :
325: -- IN : p_api_version IN NUMBER Required
326: -- p_init_msg_list IN VARCHAR2 Optional
327: -- Default = FND_API.G_FALSE
328: -- p_content_item_ids IN CONTENT_ITEM_ID_TBL Required
329: -- p_label_code IN VARCHAR2 Optional
330: -- Default = NULL
331: -- OUT : x_return_status OUT VARCHAR2

Line 353: l_item_found VARCHAR2(1) := FND_API.G_TRUE;

349: --
350: l_citem_count NUMBER := 1;
351: l_citem_id_count NUMBER := 1;
352: l_citem_meta_rec Content_Item_Meta_Rec;
353: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
354:
355: BEGIN
356: -- ******* Standard Begins ********
357:

Line 359: IF NOT FND_API.Compatible_API_Call (

355: BEGIN
356: -- ******* Standard Begins ********
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call (
360: l_api_version,
361: p_api_version,
362: l_api_name,
363: G_PKG_NAME)

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

361: p_api_version,
362: l_api_name,
363: G_PKG_NAME)
364: THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367: -- Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list )
369: THEN

Line 368: IF FND_API.to_Boolean( p_init_msg_list )

364: THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367: -- Initialize message list if p_init_msg_list is set to TRUE.
368: IF FND_API.to_Boolean( p_init_msg_list )
369: THEN
370: FND_MSG_PUB.initialize;
371: END IF;
372:

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370: FND_MSG_PUB.initialize;
371: END IF;
372:
373: -- Initialize API return status to success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: --******************* Real Logic Start *********************
377:
378: x_content_item_meta_tbl := CONTENT_ITEM_META_TBL();

Line 392: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

388: x_return_status,
389: x_msg_count,
390: x_msg_data);
391: -- Content item is not valid
392: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:
396: IF (l_item_found = FND_API.G_TRUE) THEN

Line 393: RAISE FND_API.G_EXC_ERROR;

389: x_msg_count,
390: x_msg_data);
391: -- Content item is not valid
392: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:
396: IF (l_item_found = FND_API.G_TRUE) THEN
397: x_content_item_meta_tbl.EXTEND();

Line 396: IF (l_item_found = FND_API.G_TRUE) THEN

392: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394: END IF;
395:
396: IF (l_item_found = FND_API.G_TRUE) THEN
397: x_content_item_meta_tbl.EXTEND();
398: x_content_item_meta_tbl(l_citem_count) := l_citem_meta_rec;
399: l_citem_count := l_citem_count + 1;
400: END IF;

Line 411: WHEN FND_API.G_EXC_ERROR THEN

407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
409: p_data => x_msg_data);
410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
414: p_data => x_msg_data);
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
409: p_data => x_msg_data);
410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
414: p_data => x_msg_data);
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: WHEN FND_API.G_EXC_ERROR THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
414: p_data => x_msg_data);
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN OTHERS THEN

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
414: p_data => x_msg_data);
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
418: p_data => x_msg_data);
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
422: THEN
423: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
424: END IF;

Line 439: -- Default = FND_API.G_FALSE

435: -- Function : Return a content item with just the meta-data.
436: -- Parameters :
437: -- IN : p_api_version IN NUMBER Required
438: -- p_init_msg_list IN VARCHAR2 Optional
439: -- Default = FND_API.G_FALSE
440: -- p_content_item_id IN NUMBER Required
441: -- p_label_code IN VARCHAR2 Optional
442: -- Default = NULL
443: -- OUT : x_return_status OUT VARCHAR2

Line 462: l_item_found VARCHAR2(1) := FND_API.G_TRUE;

458: --******** local variable for standards **********
459: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citem_Meta';
460: l_api_version CONSTANT NUMBER := 1.0;
461: --
462: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
463:
464: BEGIN
465: -- ******* Standard Begins ********
466:

Line 468: IF NOT FND_API.Compatible_API_Call (

464: BEGIN
465: -- ******* Standard Begins ********
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call (
469: l_api_version,
470: p_api_version,
471: l_api_name,
472: G_PKG_NAME)

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: p_api_version,
471: l_api_name,
472: G_PKG_NAME)
473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list )
478: THEN

Line 477: IF FND_API.to_Boolean( p_init_msg_list )

473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list )
478: THEN
479: FND_MSG_PUB.initialize;
480: END IF;
481:

Line 483: x_return_status := FND_API.G_RET_STS_SUCCESS;

479: FND_MSG_PUB.initialize;
480: END IF;
481:
482: -- Initialize API return status to success
483: x_return_status := FND_API.G_RET_STS_SUCCESS;
484:
485: --******************* Real Logic Start *********************
486:
487: IBC_CITEM_RUNTIME_PVT.Get_Citem_Meta( p_init_msg_list,

Line 496: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

492: x_return_status,
493: x_msg_count,
494: x_msg_data);
495: -- Content Item is not valid
496: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: --******************* Real Logic End *********************

Line 497: RAISE FND_API.G_EXC_ERROR;

493: x_msg_count,
494: x_msg_data);
495: -- Content Item is not valid
496: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: --******************* Real Logic End *********************
501:

Line 506: WHEN FND_API.G_EXC_ERROR THEN

502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
504: p_data => x_msg_data);
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 507: x_return_status := FND_API.G_RET_STS_ERROR;

503: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
504: p_data => x_msg_data);
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

506: WHEN FND_API.G_EXC_ERROR THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
513: p_data => x_msg_data);
514: WHEN OTHERS THEN

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
513: p_data => x_msg_data);
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
513: p_data => x_msg_data);
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
519: END IF;

Line 534: -- Default = FND_API.G_FALSE

530: -- Function : Return a content item with basic data.
531: -- Parameters :
532: -- IN : p_api_version IN NUMBER Required
533: -- p_init_msg_list IN VARCHAR2 Optional
534: -- Default = FND_API.G_FALSE
535: -- p_content_item_id IN NUMBER Required
536: -- p_label_code IN VARCHAR2 Optional
537: -- Default = NULL
538: -- OUT : x_return_status OUT VARCHAR2

Line 604: IF NOT FND_API.Compatible_API_Call (

600: BEGIN
601: -- ******* Standard Begins ********
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call (
605: l_api_version,
606: p_api_version,
607: l_api_name,
608: G_PKG_NAME)

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: p_api_version,
607: l_api_name,
608: G_PKG_NAME)
609: THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: -- Initialize message list if p_init_msg_list is set to TRUE.
613: IF FND_API.to_Boolean( p_init_msg_list )
614: THEN

Line 613: IF FND_API.to_Boolean( p_init_msg_list )

609: THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: -- Initialize message list if p_init_msg_list is set to TRUE.
613: IF FND_API.to_Boolean( p_init_msg_list )
614: THEN
615: FND_MSG_PUB.initialize;
616: END IF;
617:

Line 619: x_return_status := FND_API.G_RET_STS_SUCCESS;

615: FND_MSG_PUB.initialize;
616: END IF;
617:
618: -- Initialize API return status to success
619: x_return_status := FND_API.G_RET_STS_SUCCESS;
620:
621: --******************* Real Logic Start *********************
622:
623: IBC_CITEM_RUNTIME_PVT.Validate_Citem (

Line 635: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

631: x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data
633: );
634: -- Content Item requested is not valid
635: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:
639: x_content_item_basic.content_item_id := p_content_item_id;

Line 636: RAISE FND_API.G_EXC_ERROR;

632: x_msg_data => x_msg_data
633: );
634: -- Content Item requested is not valid
635: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:
639: x_content_item_basic.content_item_id := p_content_item_id;
640: x_content_item_basic.content_type_code := l_content_type_code;

Line 653: IF (Ibc_Validate_Pvt.isValidLabel(p_label_code) = FND_API.g_false) THEN

649: FETCH Get_Citem_Ver_By_Label INTO l_citem_version_id;
650: -- Label doesn't exist for this content item id
651: IF (Get_Citem_Ver_By_Label%NOTFOUND) THEN
652: -- Validate Label
653: IF (Ibc_Validate_Pvt.isValidLabel(p_label_code) = FND_API.g_false) THEN
654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
655: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
656: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
657: FND_MSG_PUB.ADD;

Line 659: RAISE FND_API.G_EXC_ERROR;

655: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
656: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
657: FND_MSG_PUB.ADD;
658: END IF;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661: x_content_item_basic := NULL;
662: return;
663: END IF;

Line 680: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

676: x_msg_count => x_msg_count,
677: x_msg_data => x_msg_data
678: );
679: -- Start/End date not valid
680: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684: -- Retrieve content item meta-data

Line 681: RAISE FND_API.G_EXC_ERROR;

677: x_msg_data => x_msg_data
678: );
679: -- Start/End date not valid
680: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684: -- Retrieve content item meta-data
685: OPEN Get_Citem_Meta_Csr;

Line 787: WHEN FND_API.G_EXC_ERROR THEN

783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
785: p_data => x_msg_data);
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
790: p_data => x_msg_data);
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
785: p_data => x_msg_data);
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
790: p_data => x_msg_data);
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

787: WHEN FND_API.G_EXC_ERROR THEN
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
790: p_data => x_msg_data);
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
794: p_data => x_msg_data);
795: WHEN OTHERS THEN

Line 792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

788: x_return_status := FND_API.G_RET_STS_ERROR;
789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
790: p_data => x_msg_data);
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
794: p_data => x_msg_data);
795: WHEN OTHERS THEN
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
794: p_data => x_msg_data);
795: WHEN OTHERS THEN
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
798: THEN
799: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
800: END IF;

Line 818: -- Default = FND_API.G_FALSE

814: -- the Xml.
815: -- Parameters :
816: -- IN : p_api_version IN NUMBER Required
817: -- p_init_msg_list IN VARCHAR2 Optional
818: -- Default = FND_API.G_FALSE
819: -- p_content_item_id IN NUMBER Required
820: -- p_label_code IN VARCHAR2 Optional
821: -- Default = NULL
822: -- OUT : x_return_status OUT VARCHAR2

Line 847: IF NOT FND_API.Compatible_API_Call (

843: BEGIN
844: -- ******* Standard Begins ********
845:
846: -- Standard call to check for call compatibility.
847: IF NOT FND_API.Compatible_API_Call (
848: l_api_version,
849: p_api_version,
850: l_api_name,
851: G_PKG_NAME)

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 856: IF FND_API.to_Boolean( p_init_msg_list )

852: THEN
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END IF;
855: -- Initialize message list if p_init_msg_list is set to TRUE.
856: IF FND_API.to_Boolean( p_init_msg_list )
857: THEN
858: FND_MSG_PUB.initialize;
859: END IF;
860:

Line 862: x_return_status := FND_API.G_RET_STS_SUCCESS;

858: FND_MSG_PUB.initialize;
859: END IF;
860:
861: -- Initialize API return status to success
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863:
864: --******************* Real Logic Start *********************
865:
866: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);

Line 879: p_validate_dates => FND_API.G_TRUE, -- p_validate_dates

875: p_content_item_id => p_content_item_id, -- p_content_item_id IN NUMBER
876: p_xml_clob_loc => x_content_item_xml, -- p_xml_clob_loc IN OUT CLOB
877: p_num_levels => 0, -- p_num_levels IN NUMBER
878: p_label_code => p_label_code, -- p_label_code IN VARCHAR2
879: p_validate_dates => FND_API.G_TRUE, -- p_validate_dates
880: x_num_levels_loaded => x_num_levels_loaded,
881: x_return_status => x_return_status,
882: x_msg_count => x_msg_count,
883: x_msg_data => x_msg_data

Line 886: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

882: x_msg_count => x_msg_count,
883: x_msg_data => x_msg_data
884: );
885: -- Content Item is not valid
886: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:
890: --******************* Real Logic End *********************

Line 887: RAISE FND_API.G_EXC_ERROR;

883: x_msg_data => x_msg_data
884: );
885: -- Content Item is not valid
886: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:
890: --******************* Real Logic End *********************
891:

Line 896: WHEN FND_API.G_EXC_ERROR THEN

892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
894: p_data => x_msg_data);
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
899: p_data => x_msg_data);
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
894: p_data => x_msg_data);
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
899: p_data => x_msg_data);
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
899: p_data => x_msg_data);
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN OTHERS THEN

Line 901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

897: x_return_status := FND_API.G_RET_STS_ERROR;
898: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
899: p_data => x_msg_data);
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN OTHERS THEN
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN OTHERS THEN
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
909: END IF;

Line 928: -- Default = FND_API.G_FALSE

924: -- also.
925: -- Parameters :
926: -- IN : p_api_version IN NUMBER Required
927: -- p_init_msg_list IN VARCHAR2 Optional
928: -- Default = FND_API.G_FALSE
929: -- p_content_item_id IN NUMBER Required
930: -- p_label_code IN VARCHAR2 Optional
931: -- Default = NULL
932: -- OUT : x_return_status OUT VARCHAR2

Line 958: IF NOT FND_API.Compatible_API_Call (

954: BEGIN
955: -- ******* Standard Begins ********
956:
957: -- Standard call to check for call compatibility.
958: IF NOT FND_API.Compatible_API_Call (
959: l_api_version,
960: p_api_version,
961: l_api_name,
962: G_PKG_NAME)

Line 964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

960: p_api_version,
961: l_api_name,
962: G_PKG_NAME)
963: THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: END IF;
966: -- Initialize message list if p_init_msg_list is set to TRUE.
967: IF FND_API.to_Boolean( p_init_msg_list )
968: THEN

Line 967: IF FND_API.to_Boolean( p_init_msg_list )

963: THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: END IF;
966: -- Initialize message list if p_init_msg_list is set to TRUE.
967: IF FND_API.to_Boolean( p_init_msg_list )
968: THEN
969: FND_MSG_PUB.initialize;
970: END IF;
971:

Line 973: x_return_status := FND_API.G_RET_STS_SUCCESS;

969: FND_MSG_PUB.initialize;
970: END IF;
971:
972: -- Initialize API return status to success
973: x_return_status := FND_API.G_RET_STS_SUCCESS;
974:
975: --******************* Real Logic Start *********************
976:
977: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);

Line 990: p_validate_dates => FND_API.G_TRUE, -- p_validate_dates

986: p_content_item_id => p_content_item_id, -- p_content_item_id IN NUMBER
987: p_xml_clob_loc => x_content_item_xml, -- p_xml_clob_loc IN OUT CLOB
988: p_num_levels => NULL, -- p_num_levels IN NUMBER
989: p_label_code => p_label_code, -- p_label_code IN VARCHAR2
990: p_validate_dates => FND_API.G_TRUE, -- p_validate_dates
991: x_num_levels_loaded => x_num_levels_loaded,
992: x_return_status => x_return_status,
993: x_msg_count => x_msg_count,
994: x_msg_data => x_msg_data

Line 997: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

993: x_msg_count => x_msg_count,
994: x_msg_data => x_msg_data
995: );
996: -- Content Item is not valid
997: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000:
1001: --******************* Real Logic End *********************

Line 998: RAISE FND_API.G_EXC_ERROR;

994: x_msg_data => x_msg_data
995: );
996: -- Content Item is not valid
997: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000:
1001: --******************* Real Logic End *********************
1002:

Line 1007: WHEN FND_API.G_EXC_ERROR THEN

1003: -- Standard call to get message count and if count=1, get the message
1004: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1005: p_data => x_msg_data);
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1010: p_data => x_msg_data);
1011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1008: x_return_status := FND_API.G_RET_STS_ERROR;

1004: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1005: p_data => x_msg_data);
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1010: p_data => x_msg_data);
1011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1007: WHEN FND_API.G_EXC_ERROR THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1010: p_data => x_msg_data);
1011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1014: p_data => x_msg_data);
1015: WHEN OTHERS THEN

Line 1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1010: p_data => x_msg_data);
1011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1014: p_data => x_msg_data);
1015: WHEN OTHERS THEN
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1013: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1014: p_data => x_msg_data);
1015: WHEN OTHERS THEN
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1020: END IF;

Line 1040: -- Default = FND_API.G_FALSE

1036: -- also.
1037: -- Parameters :
1038: -- IN : p_api_version IN NUMBER Required
1039: -- p_init_msg_list IN VARCHAR2 Optional
1040: -- Default = FND_API.G_FALSE
1041: -- p_content_item_id IN NUMBER Required
1042: -- p_citem_version_id IN NUMBER Required
1043: -- OUT : x_return_status OUT VARCHAR2
1044: -- x_msg_count OUT NUMBER

Line 1069: IF NOT FND_API.Compatible_API_Call (

1065: BEGIN
1066: -- ******* Standard Begins ********
1067:
1068: -- Standard call to check for call compatibility.
1069: IF NOT FND_API.Compatible_API_Call (
1070: l_api_version,
1071: p_api_version,
1072: l_api_name,
1073: G_PKG_NAME)

Line 1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1071: p_api_version,
1072: l_api_name,
1073: G_PKG_NAME)
1074: THEN
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077: -- Initialize message list if p_init_msg_list is set to TRUE.
1078: IF FND_API.to_Boolean( p_init_msg_list )
1079: THEN

Line 1078: IF FND_API.to_Boolean( p_init_msg_list )

1074: THEN
1075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1076: END IF;
1077: -- Initialize message list if p_init_msg_list is set to TRUE.
1078: IF FND_API.to_Boolean( p_init_msg_list )
1079: THEN
1080: FND_MSG_PUB.initialize;
1081: END IF;
1082:

Line 1084: x_return_status := FND_API.G_RET_STS_SUCCESS;

1080: FND_MSG_PUB.initialize;
1081: END IF;
1082:
1083: -- Initialize API return status to success
1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: --******************* Real Logic Start *********************
1087:
1088: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);

Line 1101: p_validate_dates => FND_API.G_TRUE, -- p_validate_dates

1097: p_content_item_id => p_content_item_id, -- p_content_item_id IN NUMBER
1098: p_xml_clob_loc => x_content_item_xml, -- p_xml_clob_loc IN OUT CLOB
1099: p_num_levels => NULL,-- p_num_levels IN NUMBER
1100: p_citem_version_id => p_citem_version_id, -- p_citem_version_id IN NUMBER
1101: p_validate_dates => FND_API.G_TRUE, -- p_validate_dates
1102: x_num_levels_loaded =>x_num_levels_loaded,
1103: x_return_status =>x_return_status,
1104: x_msg_count =>x_msg_count,
1105: x_msg_data =>x_msg_data

Line 1108: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1104: x_msg_count =>x_msg_count,
1105: x_msg_data =>x_msg_data
1106: );
1107: -- Content Item is not valid
1108: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1112: --******************* Real Logic End *********************

Line 1109: RAISE FND_API.G_EXC_ERROR;

1105: x_msg_data =>x_msg_data
1106: );
1107: -- Content Item is not valid
1108: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: RAISE FND_API.G_EXC_ERROR;
1110: END IF;
1111:
1112: --******************* Real Logic End *********************
1113:

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: -- Standard call to get message count and if count=1, get the message
1115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1116: p_data => x_msg_data);
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1121: p_data => x_msg_data);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1119: x_return_status := FND_API.G_RET_STS_ERROR;

1115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1116: p_data => x_msg_data);
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1121: p_data => x_msg_data);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1121: p_data => x_msg_data);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1125: p_data => x_msg_data);
1126: WHEN OTHERS THEN

Line 1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1121: p_data => x_msg_data);
1122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1125: p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1125: p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1128: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1129: THEN
1130: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1131: END IF;