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_STYLESHEETS_GRP dependencies on FND_API

Line 28: IF FND_API.to_Boolean( p_init_msg_list ) THEN

24: where content_item_id = p_stylesheet_item_id;
25:
26: BEGIN
27: -- Initialize message list if p_init_msg_list is set to TRUE.
28: IF FND_API.to_Boolean( p_init_msg_list ) THEN
29: FND_MSG_PUB.initialize;
30: END IF;
31: -- Initialize API return status to success
32: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: IF FND_API.to_Boolean( p_init_msg_list ) THEN
29: FND_MSG_PUB.initialize;
30: END IF;
31: -- Initialize API return status to success
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: OPEN Get_Citem;
35: FETCH Get_Citem INTO x_live_citem_version_id, l_content_item_status;
36: -- check if p_content_item_id is valid

Line 43: RAISE FND_API.G_EXC_ERROR;

39: FND_MESSAGE.Set_Name('IBC', 'INVALID_STYLESHEET_ITEM_ID');
40: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
41: FND_MSG_PUB.ADD;
42: END IF;
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45: CLOSE Get_Citem;
46:
47: -- check if content_item_status is APPROVED

Line 55: RAISE FND_API.G_EXC_ERROR;

51: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHEET_NOT_APPROVED');
52: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
53: FND_MSG_PUB.ADD;
54: END IF;
55: RAISE FND_API.G_EXC_ERROR;
56: END IF;
57:
58: EXCEPTION
59: WHEN FND_API.G_EXC_ERROR THEN

Line 59: WHEN FND_API.G_EXC_ERROR THEN

55: RAISE FND_API.G_EXC_ERROR;
56: END IF;
57:
58: EXCEPTION
59: WHEN FND_API.G_EXC_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
62: p_data => x_msg_data);
63: END Validate_StyleSheetItem;

Line 60: x_return_status := FND_API.G_RET_STS_ERROR;

56: END IF;
57:
58: EXCEPTION
59: WHEN FND_API.G_EXC_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
62: p_data => x_msg_data);
63: END Validate_StyleSheetItem;
64:

Line 83: IF FND_API.to_Boolean( p_init_msg_list ) THEN

79: from IBC_CITEM_VERSIONS_B
80: where CITEM_VERSION_ID = p_stylesheet_version_id;
81: BEGIN
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list ) THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: IF FND_API.to_Boolean( p_init_msg_list ) THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: OPEN Get_Citem_Version;
90: FETCH Get_Citem_Version INTO l_start_date, l_end_date;
91: CLOSE Get_Citem_Version;

Line 103: RAISE FND_API.G_EXC_ERROR;

99: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
100: FND_MESSAGE.Set_token('START_DATE', l_start_date);
101: FND_MSG_PUB.ADD;
102: END IF;
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105: END IF;
106:
107: -- Check Profile if expiration date is enforced

Line 117: RAISE FND_API.G_EXC_ERROR;

113: FND_MESSAGE.Set_token('STYLESHEET_ITEM_ID', p_stylesheet_item_id);
114: FND_MESSAGE.Set_token('END_DATE', l_end_date);
115: FND_MSG_PUB.ADD;
116: END IF;
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;
119: END IF;
120:
121: EXCEPTION

Line 122: WHEN FND_API.G_EXC_ERROR THEN

118: END IF;
119: END IF;
120:
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126: END Validate_Start_End_Date;

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: END IF;
120:
121: EXCEPTION
122: WHEN FND_API.G_EXC_ERROR THEN
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
125: p_data => x_msg_data);
126: END Validate_Start_End_Date;
127:

Line 156: IF FND_API.to_Boolean( p_init_msg_list ) THEN

152: and v.ATTACHMENT_FILE_ID = f.FILE_ID;
153:
154: BEGIN
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: --******************* Real Logic Start *********************
163: Validate_StyleSheetItem (
164: p_init_msg_list => p_init_msg_list,

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

168: x_msg_count => x_msg_count,
169: x_msg_data => x_msg_data
170: );
171: -- Content Item requested is not valid
172: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: -- Check if there is a label for this content item

Line 173: RAISE FND_API.G_EXC_ERROR;

169: x_msg_data => x_msg_data
170: );
171: -- Content Item requested is not valid
172: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: -- Check if there is a label for this content item
177: IF (p_stylesheet_label_code is NULL) THEN

Line 185: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheet_label_code) = FND_API.g_false) THEN

181: FETCH Get_Citem_Ver_By_Label INTO l_citem_version_id;
182: -- Label doesn't exist for this content item id
183: IF (Get_Citem_Ver_By_Label%NOTFOUND) THEN
184: -- Validate Label
185: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheet_label_code) = FND_API.g_false) THEN
186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
187: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
188: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheet_label_code);
189: FND_MSG_PUB.ADD;

Line 191: RAISE FND_API.G_EXC_ERROR;

187: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
188: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheet_label_code);
189: FND_MSG_PUB.ADD;
190: END IF;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193: x_stylesheet := NULL;
194: return;
195: END IF;

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

204: x_return_status => x_return_status,
205: x_msg_count => x_msg_count,
206: x_msg_data => x_msg_data
207: );
208: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212: -- Retrieve Stylesheet binary file

Line 209: RAISE FND_API.G_EXC_ERROR;

205: x_msg_count => x_msg_count,
206: x_msg_data => x_msg_data
207: );
208: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212: -- Retrieve Stylesheet binary file
213: OPEN Get_StyleSheet;

Line 218: WHEN FND_API.G_EXC_ERROR THEN

214: FETCH Get_StyleSheet INTO x_stylesheet;
215: CLOSE Get_StyleSheet;
216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
221: p_data => x_msg_data);
222: END Get_StyleSheet_Private;

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: CLOSE Get_StyleSheet;
216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
221: p_data => x_msg_data);
222: END Get_StyleSheet_Private;
223:

Line 251: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;

247: select s.CONTENT_ITEM_ID
248: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
249: where i.CONTENT_ITEM_ID = p_content_item_id
250: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
251: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
252:
253: BEGIN
254: -- ******* Standard Begins ********
255: -- Standard call to check for call compatibility.

Line 256: IF NOT FND_API.Compatible_API_Call (

252:
253: BEGIN
254: -- ******* Standard Begins ********
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (
257: l_api_version,
258: p_api_version,
259: l_api_name,
260: G_PKG_NAME)

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: p_api_version,
259: l_api_name,
260: G_PKG_NAME)
261: THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list )
266: THEN

Line 265: IF FND_API.to_Boolean( p_init_msg_list )

261: THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list )
266: THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: -- Initialize API return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272: --******************* Real Logic Start *********************
273:
274: OPEN Get_StyleSheet_Id;
275: FETCH Get_StyleSheet_Id INTO l_stylesheet_id;

Line 299: WHEN FND_API.G_EXC_ERROR THEN

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

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 339: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;

335: select s.CONTENT_ITEM_ID
336: from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
337: where i.CONTENT_ITEM_ID = p_content_item_id
338: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
339: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
340:
341: BEGIN
342: -- ******* Standard Begins ********
343: -- Standard call to check for call compatibility.

Line 344: IF NOT FND_API.Compatible_API_Call (

340:
341: BEGIN
342: -- ******* Standard Begins ********
343: -- Standard call to check for call compatibility.
344: IF NOT FND_API.Compatible_API_Call (
345: l_api_version,
346: p_api_version,
347: l_api_name,
348: G_PKG_NAME)

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

346: p_api_version,
347: l_api_name,
348: G_PKG_NAME)
349: THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352: -- Initialize message list if p_init_msg_list is set to TRUE.
353: IF FND_API.to_Boolean( p_init_msg_list )
354: THEN

Line 353: IF FND_API.to_Boolean( p_init_msg_list )

349: THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352: -- Initialize message list if p_init_msg_list is set to TRUE.
353: IF FND_API.to_Boolean( p_init_msg_list )
354: THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:

Line 359: x_return_status := FND_API.G_RET_STS_SUCCESS;

355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Initialize API return status to success
359: x_return_status := FND_API.G_RET_STS_SUCCESS;
360: --******************* Real Logic Start *********************
361:
362: OPEN Get_StyleSheet_Id;
363: FETCH Get_StyleSheet_Id INTO x_stylesheet_id;

Line 375: WHEN FND_API.G_EXC_ERROR THEN

371: --******************* Real Logic End ***********************
372:
373:
374: EXCEPTION
375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

372:
373:
374: EXCEPTION
375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data);
383: WHEN OTHERS THEN

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

376: x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
378: p_data => x_msg_data);
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data);
383: WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data);
383: WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
388: END IF;

Line 413: IF NOT FND_API.Compatible_API_Call (

409:
410: BEGIN
411: -- ******* Standard Begins ********
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version,
415: p_api_version,
416: l_api_name,
417: G_PKG_NAME)

Line 419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

415: p_api_version,
416: l_api_name,
417: G_PKG_NAME)
418: THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421: -- Initialize message list if p_init_msg_list is set to TRUE.
422: IF FND_API.to_Boolean( p_init_msg_list )
423: THEN

Line 422: IF FND_API.to_Boolean( p_init_msg_list )

418: THEN
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421: -- Initialize message list if p_init_msg_list is set to TRUE.
422: IF FND_API.to_Boolean( p_init_msg_list )
423: THEN
424: FND_MSG_PUB.initialize;
425: END IF;
426:

Line 428: x_return_status := FND_API.G_RET_STS_SUCCESS;

424: FND_MSG_PUB.initialize;
425: END IF;
426:
427: -- Initialize API return status to success
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429: --******************* Real Logic Start *********************
430:
431: Get_StyleSheet_Private (
432: p_init_msg_list => p_init_msg_list,

Line 447: WHEN FND_API.G_EXC_ERROR THEN

443: -- Standard call to get message count and if count=1, get the message
444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
445: p_data => x_msg_data);
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data);
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
445: p_data => x_msg_data);
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data);
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

447: WHEN FND_API.G_EXC_ERROR THEN
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data);
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: WHEN OTHERS THEN

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
450: p_data => x_msg_data);
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
454: p_data => x_msg_data);
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
460: END IF;

Line 491: IF NOT FND_API.Compatible_API_Call (

487:
488: BEGIN
489: -- ******* Standard Begins ********
490: -- Standard call to check for call compatibility.
491: IF NOT FND_API.Compatible_API_Call (
492: l_api_version,
493: p_api_version,
494: l_api_name,
495: G_PKG_NAME)

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: p_api_version,
494: l_api_name,
495: G_PKG_NAME)
496: THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN

Line 500: IF FND_API.to_Boolean( p_init_msg_list )

496: THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:

Line 506: x_return_status := FND_API.G_RET_STS_SUCCESS;

502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Initialize API return status to success
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507: --******************* Real Logic Start *********************
508:
509: OPEN Get_StyleSheet_Id;
510: FETCH Get_StyleSheet_Id INTO l_stylesheet_id;

Line 517: RAISE FND_API.G_EXC_ERROR;

513: FND_MESSAGE.Set_Name('IBC', 'IBC_STYLESHT_RC_NOT_FOUND');
514: FND_MESSAGE.Set_token('REF_CODE', p_stylesheet_ref_code);
515: FND_MSG_PUB.ADD;
516: END IF;
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519: CLOSE Get_StyleSheet_Id;
520:
521: Get_StyleSheet_Private (

Line 537: WHEN FND_API.G_EXC_ERROR THEN

533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
535: p_data => x_msg_data);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
540: p_data => x_msg_data);
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
535: p_data => x_msg_data);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
540: p_data => x_msg_data);
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

537: WHEN FND_API.G_EXC_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
540: p_data => x_msg_data);
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
544: p_data => x_msg_data);
545: WHEN OTHERS THEN

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
540: p_data => x_msg_data);
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
544: p_data => x_msg_data);
545: WHEN OTHERS THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
544: p_data => x_msg_data);
545: WHEN OTHERS THEN
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
548: THEN
549: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
550: END IF;

Line 565: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

561: -- requirement, that stylesheet item will NOT be included in the list returned.
562: -- -----------------------------------------------------------------
563: PROCEDURE Get_StyleSheet_Items (
564: p_api_version IN NUMBER,
565: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
566: p_content_item_id IN NUMBER,
567: p_stylesheets_label_code IN VARCHAR2 DEFAULT NULL,
568: x_stylesheet_item_clobs OUT NOCOPY JTF_CLOB_TABLE,
569: x_stylesheet_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 595: IF NOT FND_API.Compatible_API_Call (

591:
592: BEGIN
593: -- ******* Standard Begins ********
594: -- Standard call to check for call compatibility.
595: IF NOT FND_API.Compatible_API_Call (
596: l_api_version,
597: p_api_version,
598: l_api_name,
599: G_PKG_NAME)

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

597: p_api_version,
598: l_api_name,
599: G_PKG_NAME)
600: THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list )
605: THEN

Line 604: IF FND_API.to_Boolean( p_init_msg_list )

600: THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603: -- Initialize message list if p_init_msg_list is set to TRUE.
604: IF FND_API.to_Boolean( p_init_msg_list )
605: THEN
606: FND_MSG_PUB.initialize;
607: END IF;
608:

Line 610: x_return_status := FND_API.G_RET_STS_SUCCESS;

606: FND_MSG_PUB.initialize;
607: END IF;
608:
609: -- Initialize API return status to success
610: x_return_status := FND_API.G_RET_STS_SUCCESS;
611: --******************* Real Logic Start *********************
612:
613: -- // Bulk fetch stylesheet item ids, labels, lang codes into array.
614: OPEN Get_StyleSheet_Ids;

Line 619: IF (Ibc_Validate_Pvt.isValidCitem(p_content_item_id) = FND_API.g_false) THEN

615: FETCH Get_StyleSheet_Ids BULK COLLECT INTO l_in_citem_ids, l_in_labels, l_in_lang_codes;
616:
617: -- // Validate p_content_item_id
618: IF (Get_StyleSheet_Ids%NOTFOUND) THEN
619: IF (Ibc_Validate_Pvt.isValidCitem(p_content_item_id) = FND_API.g_false) THEN
620: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
621: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_ID');
622: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
623: FND_MSG_PUB.ADD;

Line 625: RAISE FND_API.G_EXC_ERROR;

621: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_ID');
622: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
623: FND_MSG_PUB.ADD;
624: END IF;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627: END IF;
628: CLOSE Get_StyleSheet_Ids;
629:

Line 636: ,p_validate_dates => FND_API.G_TRUE -- // validate dates

632: p_init_msg_list => p_init_msg_list
633: ,p_content_item_ids => l_in_citem_ids
634: ,p_label_codes => l_in_labels
635: ,p_lang_codes => l_in_lang_codes
636: ,p_validate_dates => FND_API.G_TRUE -- // validate dates
637: ,x_clobs => x_stylesheet_item_clobs
638: ,x_content_item_ids => x_stylesheet_item_ids
639: ,x_label_codes => l_out_labels
640: ,x_lang_codes => x_stylesheet_lang_codes

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

641: ,x_return_status => x_return_status
642: ,x_msg_count => x_msg_count
643: ,x_msg_data => x_msg_data
644: );
645: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;
648:
649: -- // List of stylesheets returned is 0, validate Label Code

Line 646: RAISE FND_API.G_EXC_ERROR;

642: ,x_msg_count => x_msg_count
643: ,x_msg_data => x_msg_data
644: );
645: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;
648:
649: -- // List of stylesheets returned is 0, validate Label Code
650: IF (x_stylesheet_item_ids.COUNT = 0) THEN

Line 651: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheets_label_code) = FND_API.g_false) THEN

647: END IF;
648:
649: -- // List of stylesheets returned is 0, validate Label Code
650: IF (x_stylesheet_item_ids.COUNT = 0) THEN
651: IF (Ibc_Validate_Pvt.isValidLabel(p_stylesheets_label_code) = FND_API.g_false) THEN
652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
653: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
654: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheets_label_code);
655: FND_MSG_PUB.ADD;

Line 657: RAISE FND_API.G_EXC_ERROR;

653: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
654: FND_MESSAGE.Set_token('LABEL_CODE', p_stylesheets_label_code);
655: FND_MSG_PUB.ADD;
656: END IF;
657: RAISE FND_API.G_EXC_ERROR;
658: END IF;
659: END IF;
660: --******************* Real Logic End ***********************
661:

Line 666: WHEN FND_API.G_EXC_ERROR THEN

662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
664: p_data => x_msg_data);
665: EXCEPTION
666: WHEN FND_API.G_EXC_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 667: x_return_status := FND_API.G_RET_STS_ERROR;

663: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
664: p_data => x_msg_data);
665: EXCEPTION
666: WHEN FND_API.G_EXC_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

666: WHEN FND_API.G_EXC_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
673: p_data => x_msg_data);
674: WHEN OTHERS THEN

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data);
670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
673: p_data => x_msg_data);
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
673: p_data => x_msg_data);
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
679: END IF;