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

Line 40: IF FND_API.to_Boolean( p_init_msg_list ) THEN

36: from IBC_CONTENT_ITEMS
37: where content_item_id = p_content_item_id;
38: BEGIN
39: -- Initialize message list if p_init_msg_list is set to TRUE.
40: IF FND_API.to_Boolean( p_init_msg_list ) THEN
41: FND_MSG_PUB.initialize;
42: END IF;
43: -- Initialize API return status to success
44: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: IF FND_API.to_Boolean( p_init_msg_list ) THEN
41: FND_MSG_PUB.initialize;
42: END IF;
43: -- Initialize API return status to success
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: OPEN Get_Citem;
47: FETCH Get_Citem INTO x_content_type_code, x_item_reference_code,
48: l_wd_restricted_flag, x_live_citem_version_id,

Line 58: RAISE FND_API.G_EXC_ERROR;

54: FND_MESSAGE.Set_Name('IBC', 'INVALID_CITEM_ID');
55: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
56: FND_MSG_PUB.ADD;
57: END IF;
58: RAISE FND_API.G_EXC_ERROR;
59: END IF;
60: CLOSE Get_Citem;
61:
62: -- check if content_item_status is APPROVED

Line 71: RAISE FND_API.G_EXC_ERROR;

67: -- FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
68: FND_MESSAGE.Set_token('CITEM_NAME',IBC_UTILITIES_PVT.get_citem_name(p_content_item_id));
69: FND_MSG_PUB.ADD;
70: END IF;
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74: -- check if wd_restricted_flag is true
75: IF (l_wd_restricted_flag = FND_API.G_TRUE) THEN

Line 75: IF (l_wd_restricted_flag = FND_API.G_TRUE) THEN

71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:
74: -- check if wd_restricted_flag is true
75: IF (l_wd_restricted_flag = FND_API.G_TRUE) THEN
76: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
77: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_PUBLISHED');
78: -- FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
79: FND_MESSAGE.Set_token('CITEM_NAME',IBC_UTILITIES_PVT.get_citem_name(p_content_item_id));

Line 82: RAISE FND_API.G_EXC_ERROR;

78: -- FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
79: FND_MESSAGE.Set_token('CITEM_NAME',IBC_UTILITIES_PVT.get_citem_name(p_content_item_id));
80: FND_MSG_PUB.ADD;
81: END IF;
82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84:
85: -- check if parent_item_id is not null (DECIDED NOT REQUIRED)
86: -- if (p_check_parent_item_id = FND_API.G_TRUE AND

Line 86: -- if (p_check_parent_item_id = FND_API.G_TRUE AND

82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84:
85: -- check if parent_item_id is not null (DECIDED NOT REQUIRED)
86: -- if (p_check_parent_item_id = FND_API.G_TRUE AND
87: -- l_parent_item_id is NOT NULL) THEN
88: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
89: -- FND_MESSAGE.Set_Name('IBC', 'CITEM_IS_ONLY_COMPONENT');
90: -- FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);

Line 93: -- RAISE FND_API.G_EXC_ERROR;

89: -- FND_MESSAGE.Set_Name('IBC', 'CITEM_IS_ONLY_COMPONENT');
90: -- FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
91: -- FND_MSG_PUB.ADD;
92: -- END IF;
93: -- RAISE FND_API.G_EXC_ERROR;
94: -- END IF;
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN

Line 97: WHEN FND_API.G_EXC_ERROR THEN

93: -- RAISE FND_API.G_EXC_ERROR;
94: -- END IF;
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
100: p_data => x_msg_data);
101: END Validate_Citem;

Line 98: x_return_status := FND_API.G_RET_STS_ERROR;

94: -- END IF;
95:
96: EXCEPTION
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
100: p_data => x_msg_data);
101: END Validate_Citem;
102:

Line 132: IF FND_API.to_Boolean( p_init_msg_list ) THEN

128: from IBC_CITEM_VERSIONS_B
129: where CITEM_VERSION_ID = p_citem_version_id;
130: BEGIN
131: -- Initialize message list if p_init_msg_list is set to TRUE.
132: IF FND_API.to_Boolean( p_init_msg_list ) THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135: -- Initialize API return status to success
136: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 136: x_return_status := FND_API.G_RET_STS_SUCCESS;

132: IF FND_API.to_Boolean( p_init_msg_list ) THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135: -- Initialize API return status to success
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: OPEN Get_Citem_Version;
139: FETCH Get_Citem_Version INTO x_start_date, x_end_date, x_version_number;
140: CLOSE Get_Citem_Version;

Line 152: RAISE FND_API.G_EXC_ERROR;

148: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
149: FND_MESSAGE.Set_token('START_DATE', x_start_date);
150: FND_MSG_PUB.ADD;
151: END IF;
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154: END IF;
155:
156: -- Check Profile if expiration date is enforced

Line 166: RAISE FND_API.G_EXC_ERROR;

162: FND_MESSAGE.Set_token('CITEM_ID', p_content_item_id);
163: FND_MESSAGE.Set_token('END_DATE', x_end_date);
164: FND_MSG_PUB.ADD;
165: END IF;
166: RAISE FND_API.G_EXC_ERROR;
167: END IF;
168: END IF;
169:
170: EXCEPTION

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: END IF;
168: END IF;
169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
174: p_data => x_msg_data);
175: END Validate_Start_End_Date;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: END IF;
169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
174: p_data => x_msg_data);
175: END Validate_Start_End_Date;
176:

Line 238: IF FND_API.to_Boolean( p_init_msg_list ) THEN

234: AND LOOKUP_CODE = l_default_mime_type;
235:
236: BEGIN
237: -- Initialize message list if p_init_msg_list is set to TRUE.
238: IF FND_API.to_Boolean( p_init_msg_list ) THEN
239: FND_MSG_PUB.initialize;
240: END IF;
241: -- Initialize API return status to success
242: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

238: IF FND_API.to_Boolean( p_init_msg_list ) THEN
239: FND_MSG_PUB.initialize;
240: END IF;
241: -- Initialize API return status to success
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: x_item_found := FND_API.G_TRUE;
244:
245: -- ******************** Real Logic *****************************
246: Validate_Citem (

Line 243: x_item_found := FND_API.G_TRUE;

239: FND_MSG_PUB.initialize;
240: END IF;
241: -- Initialize API return status to success
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243: x_item_found := FND_API.G_TRUE;
244:
245: -- ******************** Real Logic *****************************
246: Validate_Citem (
247: p_init_msg_list => p_init_msg_list,

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

254: x_msg_count => x_msg_count,
255: x_msg_data => x_msg_data
256: );
257: -- Content Item requested is not valid
258: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
259: RAISE FND_API.G_EXC_ERROR;
260: END IF;
261:
262: x_content_item_meta.content_item_id := p_content_item_id;

Line 259: RAISE FND_API.G_EXC_ERROR;

255: x_msg_data => x_msg_data
256: );
257: -- Content Item requested is not valid
258: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
259: RAISE FND_API.G_EXC_ERROR;
260: END IF;
261:
262: x_content_item_meta.content_item_id := p_content_item_id;
263:

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

269: FETCH Get_Citem_Ver_By_Label INTO l_citem_version_id;
270: -- Label doesn't exist for this content item id
271: IF (Get_Citem_Ver_By_Label%NOTFOUND) THEN
272: -- Validate Label
273: IF (Ibc_Validate_Pvt.isValidLabel(p_label_code) = FND_API.g_false) THEN
274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
275: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
276: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
277: FND_MSG_PUB.ADD;

Line 279: RAISE FND_API.G_EXC_ERROR;

275: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
276: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
277: FND_MSG_PUB.ADD;
278: END IF;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: x_item_found := FND_API.G_FALSE;
282: x_content_item_meta := NULL;
283: return;

Line 281: x_item_found := FND_API.G_FALSE;

277: FND_MSG_PUB.ADD;
278: END IF;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: x_item_found := FND_API.G_FALSE;
282: x_content_item_meta := NULL;
283: return;
284: END IF;
285: CLOSE Get_Citem_Ver_By_Label;

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

297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data
299: );
300: -- Start/End date not valid
301: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: -- // Retrieve content item data (session language)

Line 302: RAISE FND_API.G_EXC_ERROR;

298: x_msg_data => x_msg_data
299: );
300: -- Start/End date not valid
301: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: -- // Retrieve content item data (session language)
306: OPEN Get_Citem_Meta_Csr;

Line 346: WHEN FND_API.G_EXC_ERROR THEN

342: x_content_item_meta.default_rendition_name := NULL;
343: END IF;
344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
349: p_data => x_msg_data);
350: END Get_Citem_Meta;

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343: END IF;
344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
349: p_data => x_msg_data);
350: END Get_Citem_Meta;
351:

Line 395: l_has_component_items VARCHAR2(1) := FND_API.g_false;

391: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
392:
393: l_comp_content_item_id NUMBER;
394: l_tmp_num_levels NUMBER;
395: l_has_component_items VARCHAR2(1) := FND_API.g_false;
396: l_max_num_levels_loaded NUMBER := 0;
397: --
398: -- // Retrieve label version
399: CURSOR Get_Citem_Ver_By_Label IS

Line 437: IF FND_API.to_Boolean( p_init_msg_list ) THEN

433:
434: BEGIN
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440: -- Initialize API return status to success
441: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 441: x_return_status := FND_API.G_RET_STS_SUCCESS;

437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440: -- Initialize API return status to success
441: x_return_status := FND_API.G_RET_STS_SUCCESS;
442: -- **************** Real Logic Starts *****************
443:
444: Validate_Citem (
445: p_init_msg_list => p_init_msg_list,

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

452: x_msg_count => x_msg_count,
453: x_msg_data => x_msg_data
454: );
455: -- Content Item requested is not valid
456: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;
459: -- Check if there is a label for this content item
460: IF (p_label_code is NULL) THEN

Line 457: RAISE FND_API.G_EXC_ERROR;

453: x_msg_data => x_msg_data
454: );
455: -- Content Item requested is not valid
456: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;
459: -- Check if there is a label for this content item
460: IF (p_label_code is NULL) THEN
461: l_citem_version_id := l_live_citem_version_id;

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

464: FETCH Get_Citem_Ver_By_Label INTO l_citem_version_id;
465: -- Label doesn't exist for this content item id
466: IF (Get_Citem_Ver_By_Label%NOTFOUND) THEN
467: -- Validate Label
468: IF (Ibc_Validate_Pvt.isValidLabel(p_label_code) = FND_API.g_false) THEN
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
470: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
471: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
472: FND_MSG_PUB.ADD;

Line 474: RAISE FND_API.G_EXC_ERROR;

470: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
471: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
472: FND_MSG_PUB.ADD;
473: END IF;
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476: -- Label is valid, but there is no mapping to this item, return NULL
477: p_xml_clob_loc := NULL;
478: x_num_levels_loaded := -1;

Line 485: IF (p_validate_dates = FND_API.G_FALSE) THEN

481: CLOSE Get_Citem_Ver_By_Label;
482: END IF;
483:
484: -- This is preloading, DO NOT validate DATES
485: IF (p_validate_dates = FND_API.G_FALSE) THEN
486: OPEN Get_Citem_Version;
487: FETCH Get_Citem_Version INTO l_start_date,l_end_date,l_version_number;
488: CLOSE Get_Citem_Version;
489:

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

500: x_msg_count => x_msg_count,
501: x_msg_data => x_msg_data
502: );
503: -- Start/End date not valid
504: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507: END IF;
508:

Line 505: RAISE FND_API.G_EXC_ERROR;

501: x_msg_data => x_msg_data
502: );
503: -- Start/End date not valid
504: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507: END IF;
508:
509: -- // Retrieve Meta Data in specified language

Line 525: RAISE FND_API.G_EXC_ERROR;

521: FND_MESSAGE.Set_Name('IBC', 'INVALID_LANG_CODE');
522: FND_MESSAGE.Set_token('LANG_CODE', p_lang_code);
523: FND_MSG_PUB.ADD;
524: END IF;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527: CLOSE Get_Citem_Meta_Csr;
528:
529: -- // If translation status is not APPROVED, retrieve based language translation

Line 560: ,p_is_preview => FND_API.G_FALSE

556: ,p_attachment_attribute_code => l_attachment_attribute_code
557: ,p_attachment_file_id => l_attachment_file_id
558: ,p_attachment_file_name => l_attachment_file_name
559: ,p_default_mime_type => l_default_mime_type
560: ,p_is_preview => FND_API.G_FALSE
561: ,p_xml_clob_loc => p_xml_clob_loc
562: );
563: -- User defined primitive attributes
564: IBC_UTILITIES_PVT.Build_Attribute_Bundle (

Line 574: l_has_component_items := FND_API.g_true;

570: IF (p_num_levels IS NULL OR p_num_levels > 0) THEN
571:
572: -- compound items expanded
573: FOR compound_item_rec IN Get_Compound_Item_Ref LOOP
574: l_has_component_items := FND_API.g_true;
575: l_comp_content_item_id := compound_item_rec.content_item_id;
576:
577: IBC_UTILITIES_PVT.Build_Compound_Item_Open_Tag (
578: p_attribute_type_code => compound_item_rec.attribute_type_code,

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

597: x_msg_count => x_msg_count,
598: x_msg_data => x_msg_data
599: );
600: -- nested compounded items not valid
601: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- check if component item is matched with label

Line 602: RAISE FND_API.G_EXC_ERROR;

598: x_msg_data => x_msg_data
599: );
600: -- nested compounded items not valid
601: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- check if component item is matched with label
606: IF (p_xml_clob_loc is NULL) THEN

Line 623: IF (l_has_component_items = FND_API.g_false) THEN

619: END IF;
620: END LOOP;
621:
622: -- set number of levels loaded
623: IF (l_has_component_items = FND_API.g_false) THEN
624: x_num_levels_loaded := 0;
625: ELSE
626: x_num_levels_loaded := l_max_num_levels_loaded + 1;
627: END IF;

Line 649: WHEN FND_API.G_EXC_ERROR THEN

645: p_xml_clob_loc -- p_xml_clob_loc IN OUT CLOB
646: );
647: -- **************** Real Logic Ends *****************
648: EXCEPTION
649: WHEN FND_API.G_EXC_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
652: p_data => x_msg_data);
653: END Get_Citem_Xml;

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: );
647: -- **************** Real Logic Ends *****************
648: EXCEPTION
649: WHEN FND_API.G_EXC_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
652: p_data => x_msg_data);
653: END Get_Citem_Xml;
654:

Line 692: IF FND_API.to_Boolean( p_init_msg_list ) THEN

688: and LANGUAGE = SOURCE_LANG;
689:
690: BEGIN
691: -- Initialize message list if p_init_msg_list is set to TRUE.
692: IF FND_API.to_Boolean( p_init_msg_list ) THEN
693: FND_MSG_PUB.initialize;
694: END IF;
695: -- Initialize API return status to success
696: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 696: x_return_status := FND_API.G_RET_STS_SUCCESS;

692: IF FND_API.to_Boolean( p_init_msg_list ) THEN
693: FND_MSG_PUB.initialize;
694: END IF;
695: -- Initialize API return status to success
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697: --******************* Real Logic Start *********************
698:
699: -- Call to get content items and versions to be loaded
700: IBC_LOAD_CITEMS_PVT.Get_Citems_To_Be_Loaded (

Line 736: ,p_validate_dates => FND_API.G_FALSE

732: p_init_msg_list => p_init_msg_list
733: ,p_content_item_ids => l_final_citem_ids
734: ,p_label_codes => l_final_labels
735: ,p_lang_codes => l_final_lang_codes
736: ,p_validate_dates => FND_API.G_FALSE
737: ,x_clobs => x_clobs
738: ,x_content_item_ids => x_content_item_ids
739: ,x_label_codes => x_label_codes
740: ,x_lang_codes => x_lang_codes

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

741: ,x_return_status => x_return_status
742: ,x_msg_count => x_msg_count
743: ,x_msg_data => x_msg_data
744: );
745: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
746: RAISE FND_API.G_EXC_ERROR;
747: END IF;
748:
749: --******************* Real Logic End ***********************

Line 746: RAISE FND_API.G_EXC_ERROR;

742: ,x_msg_count => x_msg_count
743: ,x_msg_data => x_msg_data
744: );
745: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
746: RAISE FND_API.G_EXC_ERROR;
747: END IF;
748:
749: --******************* Real Logic End ***********************
750: EXCEPTION

Line 751: WHEN FND_API.G_EXC_ERROR THEN

747: END IF;
748:
749: --******************* Real Logic End ***********************
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
754: p_data => x_msg_data);
755: END Bulk_Load;

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

748:
749: --******************* Real Logic End ***********************
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
754: p_data => x_msg_data);
755: END Bulk_Load;
756:

Line 781: IF FND_API.to_Boolean( p_init_msg_list ) THEN

777: --
778: l_id NUMBER;
779: BEGIN
780: -- Initialize message list if p_init_msg_list is set to TRUE.
781: IF FND_API.to_Boolean( p_init_msg_list ) THEN
782: FND_MSG_PUB.initialize;
783: END IF;
784: -- Initialize API return status to success
785: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

781: IF FND_API.to_Boolean( p_init_msg_list ) THEN
782: FND_MSG_PUB.initialize;
783: END IF;
784: -- Initialize API return status to success
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: --******************* Real Logic Start *********************
788: x_clobs := JTF_CLOB_TABLE();
789: x_content_item_ids := JTF_NUMBER_TABLE();

Line 817: IF (x_return_status <> FND_API.G_RET_STS_ERROR AND

813: ,x_msg_count => x_msg_count
814: ,x_msg_data => x_msg_data
815: );
816: -- if NO Error AND Label does point to a version, add to result list
817: IF (x_return_status <> FND_API.G_RET_STS_ERROR AND
818: l_tmp_clob IS NOT NULL) THEN
819: x_clobs.EXTEND();
820: x_clobs(l_output_count) := l_tmp_clob;
821: x_content_item_ids.EXTEND();

Line 835: WHEN FND_API.G_EXC_ERROR THEN

831: END LOOP;
832:
833: --******************* Real Logic End *********************
834: EXCEPTION
835: WHEN FND_API.G_EXC_ERROR THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
838: p_data => x_msg_data);
839: END Load_Translated_Content_Items;

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

832:
833: --******************* Real Logic End *********************
834: EXCEPTION
835: WHEN FND_API.G_EXC_ERROR THEN
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
838: p_data => x_msg_data);
839: END Load_Translated_Content_Items;
840:

Line 872: IF FND_API.to_Boolean( p_init_msg_list ) THEN

868: where citem_version_id = l_citem_version_id;
869:
870: BEGIN
871: -- Initialize message list if p_init_msg_list is set to TRUE.
872: IF FND_API.to_Boolean( p_init_msg_list ) THEN
873: FND_MSG_PUB.initialize;
874: END IF;
875: -- Initialize API return status to success
876: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 876: x_return_status := FND_API.G_RET_STS_SUCCESS;

872: IF FND_API.to_Boolean( p_init_msg_list ) THEN
873: FND_MSG_PUB.initialize;
874: END IF;
875: -- Initialize API return status to success
876: x_return_status := FND_API.G_RET_STS_SUCCESS;
877:
878: --******************* Real Logic Start *********************
879: Validate_Citem (
880: p_init_msg_list => p_init_msg_list,

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

887: x_msg_count => x_msg_count,
888: x_msg_data => x_msg_data
889: );
890: -- Content Item requested is not valid
891: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:
895: -- Check if there is a label for this content item

Line 892: RAISE FND_API.G_EXC_ERROR;

888: x_msg_data => x_msg_data
889: );
890: -- Content Item requested is not valid
891: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:
895: -- Check if there is a label for this content item
896: IF (p_label_code is NULL) THEN

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

900: FETCH Get_Citem_Ver_By_Label INTO l_citem_version_id;
901: -- Label doesn't exist for this content item id
902: IF (Get_Citem_Ver_By_Label%NOTFOUND) THEN
903: -- Validate Label
904: IF (Ibc_Validate_Pvt.isValidLabel(p_label_code) = FND_API.g_false) THEN
905: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
906: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
907: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
908: FND_MSG_PUB.ADD;

Line 910: RAISE FND_API.G_EXC_ERROR;

906: FND_MESSAGE.Set_Name('IBC', 'INVALID_LABEL_CODE');
907: FND_MESSAGE.Set_token('LABEL_CODE', p_label_code);
908: FND_MSG_PUB.ADD;
909: END IF;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: x_version_number := -1;
913: return;
914: END IF;

Line 928: WHEN FND_API.G_EXC_ERROR THEN

924: -- Standard call to get message count and if count=1, get the message
925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
926: p_data => x_msg_data);
927: EXCEPTION
928: WHEN FND_API.G_EXC_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
931: p_data => x_msg_data);
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
926: p_data => x_msg_data);
927: EXCEPTION
928: WHEN FND_API.G_EXC_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
931: p_data => x_msg_data);
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

928: WHEN FND_API.G_EXC_ERROR THEN
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
931: p_data => x_msg_data);
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
935: p_data => x_msg_data);
936: WHEN OTHERS THEN

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

929: x_return_status := FND_API.G_RET_STS_ERROR;
930: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
931: p_data => x_msg_data);
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
935: p_data => x_msg_data);
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
935: p_data => x_msg_data);
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
939: p_data => x_msg_data);
940: END Load_Citem_Version_Number;
941:

Line 978: IF FND_API.to_Boolean( p_init_msg_list ) THEN

974: AND live_citem_ver_id = citem_ver_id);
975:
976: BEGIN
977: -- Initialize message list if p_init_msg_list is set to TRUE.
978: IF FND_API.to_Boolean( p_init_msg_list ) THEN
979: FND_MSG_PUB.initialize;
980: END IF;
981: -- Initialize API return status to success
982: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 982: x_return_status := FND_API.G_RET_STS_SUCCESS;

978: IF FND_API.to_Boolean( p_init_msg_list ) THEN
979: FND_MSG_PUB.initialize;
980: END IF;
981: -- Initialize API return status to success
982: x_return_status := FND_API.G_RET_STS_SUCCESS;
983:
984: --******************* Real Logic Start *********************
985:
986: x_content_item_id_tbl := JTF_NUMBER_TABLE();

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

992: END LOOP;
993:
994: -- If no matches, check if p_association_type_code is valid
995: IF (l_citem_count = 1) THEN
996: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN
997: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
998: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
999: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
1000: FND_MSG_PUB.ADD;

Line 1002: RAISE FND_API.G_EXC_ERROR;

998: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
999: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
1000: FND_MSG_PUB.ADD;
1001: END IF;
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004: END IF;
1005:
1006: --******************* Real Logic End *********************

Line 1012: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1013: 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: EXCEPTION
1012: WHEN FND_API.G_EXC_ERROR THEN
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1015: p_data => x_msg_data);
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1012: WHEN FND_API.G_EXC_ERROR THEN
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1015: p_data => x_msg_data);
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: WHEN OTHERS THEN

Line 1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1015: p_data => x_msg_data);
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: WHEN OTHERS THEN
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: WHEN OTHERS THEN
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1022: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1023: p_data => x_msg_data);
1024: END Load_Associations;
1025:

Line 1069: l_has_component_items VARCHAR2(1) := FND_API.g_false;

1065: l_default_mime_type IBC_CITEM_VERSIONS_TL.DEFAULT_RENDITION_MIME_TYPE%TYPE;
1066:
1067: l_comp_content_item_id NUMBER;
1068: l_tmp_num_levels NUMBER;
1069: l_has_component_items VARCHAR2(1) := FND_API.g_false;
1070: l_max_num_levels_loaded NUMBER := 0;
1071:
1072: -- Retrive the Content Item Version details
1073:

Line 1107: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1103:
1104: BEGIN
1105:
1106: -- Initialize message list if p_init_msg_list is set to TRUE.
1107: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1108: FND_MSG_PUB.initialize;
1109: END IF;
1110: -- Initialize API return status to success
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1111: x_return_status := FND_API.G_RET_STS_SUCCESS;

1107: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1108: FND_MSG_PUB.initialize;
1109: END IF;
1110: -- Initialize API return status to success
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112: -- **************** Real Logic Starts *****************
1113:
1114: Validate_Citem (
1115: p_init_msg_list => p_init_msg_list,

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

1122: x_msg_count => x_msg_count,
1123: x_msg_data => x_msg_data
1124: );
1125: -- Content Item requested is not valid
1126: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130: -- This is preloading, DO NOT validate DATES

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123: x_msg_data => x_msg_data
1124: );
1125: -- Content Item requested is not valid
1126: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130: -- This is preloading, DO NOT validate DATES
1131: IF (p_validate_dates = FND_API.G_FALSE) THEN

Line 1131: IF (p_validate_dates = FND_API.G_FALSE) THEN

1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130: -- This is preloading, DO NOT validate DATES
1131: IF (p_validate_dates = FND_API.G_FALSE) THEN
1132: OPEN Get_Citem_Version;
1133: FETCH Get_Citem_Version INTO l_start_date,l_end_date,l_version_number;
1134: CLOSE Get_Citem_Version;
1135:

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

1146: x_msg_count => x_msg_count,
1147: x_msg_data => x_msg_data
1148: );
1149: -- Start/End date not valid
1150: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153: END IF;
1154:

Line 1151: RAISE FND_API.G_EXC_ERROR;

1147: x_msg_data => x_msg_data
1148: );
1149: -- Start/End date not valid
1150: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153: END IF;
1154:
1155: -- // Retrieve Meta Data in specified language

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167: FND_MESSAGE.Set_Name('IBC', 'INVALID_LANG_CODE');
1168: FND_MESSAGE.Set_token('LANG_CODE', p_lang_code);
1169: FND_MSG_PUB.ADD;
1170: END IF;
1171: RAISE FND_API.G_EXC_ERROR;
1172: END IF;
1173: CLOSE Get_Citem_Meta_Csr;
1174:
1175: -- // If translation status is not APPROVED, retrieve based language translation

Line 1206: ,p_is_preview => FND_API.G_FALSE

1202: ,p_attachment_attribute_code => l_attachment_attribute_code
1203: ,p_attachment_file_id => l_attachment_file_id
1204: ,p_attachment_file_name => l_attachment_file_name
1205: ,p_default_mime_type => l_default_mime_type
1206: ,p_is_preview => FND_API.G_FALSE
1207: ,p_xml_clob_loc => p_xml_clob_loc
1208: );
1209: -- User defined primitive attributes
1210: IBC_UTILITIES_PVT.Build_Attribute_Bundle (

Line 1220: l_has_component_items := FND_API.g_true;

1216: IF (p_num_levels IS NULL OR p_num_levels > 0) THEN
1217:
1218: -- compound items expanded
1219: FOR compound_item_rec IN Get_Compound_Item_Ref LOOP
1220: l_has_component_items := FND_API.g_true;
1221: l_comp_content_item_id := compound_item_rec.content_item_id;
1222:
1223: IBC_UTILITIES_PVT.Build_Compound_Item_Open_Tag (
1224: p_attribute_type_code => compound_item_rec.attribute_type_code,

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

1244: x_msg_data => x_msg_data
1245: );
1246:
1247: -- nested compounded items not valid
1248: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:
1252: -- check if component item is matched with label

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: );
1246:
1247: -- nested compounded items not valid
1248: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: END IF;
1251:
1252: -- check if component item is matched with label
1253: IF (p_xml_clob_loc is NULL) THEN

Line 1271: IF (l_has_component_items = FND_API.g_false) THEN

1267:
1268: END LOOP;
1269:
1270: -- set number of levels loaded
1271: IF (l_has_component_items = FND_API.g_false) THEN
1272: x_num_levels_loaded := 0;
1273: ELSE
1274: x_num_levels_loaded := l_max_num_levels_loaded + 1;
1275: END IF;

Line 1297: WHEN FND_API.G_EXC_ERROR THEN

1293: p_xml_clob_loc -- p_xml_clob_loc IN OUT CLOB
1294: );
1295: -- **************** Real Logic Ends *****************
1296: EXCEPTION
1297: WHEN FND_API.G_EXC_ERROR THEN
1298: x_return_status := FND_API.G_RET_STS_ERROR;
1299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1300: p_data => x_msg_data);
1301: END Get_Citem_Xml;

Line 1298: x_return_status := FND_API.G_RET_STS_ERROR;

1294: );
1295: -- **************** Real Logic Ends *****************
1296: EXCEPTION
1297: WHEN FND_API.G_EXC_ERROR THEN
1298: x_return_status := FND_API.G_RET_STS_ERROR;
1299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1300: p_data => x_msg_data);
1301: END Get_Citem_Xml;
1302: