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_MSG_PUB

Line 41: FND_MSG_PUB.initialize;

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;
45:

Line 53: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

49: l_content_item_status, x_encrypt_flag,
50: l_parent_item_id;
51: -- check if p_content_item_id is valid
52: IF Get_Citem%NOTFOUND THEN
53: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 56: FND_MSG_PUB.ADD;

52: IF Get_Citem%NOTFOUND THEN
53: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

61:
62: -- check if content_item_status is APPROVED
63: IF (l_content_item_status IS NULL OR
64: l_content_item_status <> IBC_UTILITIES_PUB.G_STI_APPROVED) THEN
65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
66: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_PUBLISHED');
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;

Line 69: FND_MSG_PUB.ADD;

65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
66: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_PUBLISHED');
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:

Line 76: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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));
80: FND_MSG_PUB.ADD;

Line 80: FND_MSG_PUB.ADD;

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));
80: FND_MSG_PUB.ADD;
81: END IF;
82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84:

Line 88: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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);
91: -- FND_MSG_PUB.ADD;
92: -- END IF;

Line 91: -- FND_MSG_PUB.ADD;

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);
91: -- FND_MSG_PUB.ADD;
92: -- END IF;
93: -- RAISE FND_API.G_EXC_ERROR;
94: -- END IF;
95:

Line 99: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
103:

Line 133: FND_MSG_PUB.initialize;

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;
137:

Line 146: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

142: -- Check Profile if availabe date is enforced
143: IF (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') IS NULL) OR
144: (FND_PROFILE.Value('IBC_ENFORCE_AVAILABLE_DATE') = 'Y') THEN
145: IF (NVL(x_start_date, SYSDATE) > SYSDATE) THEN
146: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
147: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_YET_AVAILABLE');
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;

Line 150: FND_MSG_PUB.ADD;

146: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
147: FND_MESSAGE.Set_Name('IBC', 'CITEM_NOT_YET_AVAILABLE');
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;

Line 160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

156: -- Check Profile if expiration date is enforced
157: IF (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') IS NULL) OR
158: (FND_PROFILE.Value('IBC_ENFORCE_EXPIRATION_DATE') = 'Y') THEN
159: IF (NVL(x_end_date, SYSDATE) < SYSDATE) THEN
160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
161: FND_MESSAGE.Set_Name('IBC', 'CITEM_EXPIRED');
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;

Line 164: FND_MSG_PUB.ADD;

160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
161: FND_MESSAGE.Set_Name('IBC', 'CITEM_EXPIRED');
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;

Line 173: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
177:

Line 239: FND_MSG_PUB.initialize;

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;
243: x_item_found := FND_API.G_TRUE;

Line 274: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
278: END IF;

Line 277: FND_MSG_PUB.ADD;

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;
278: END IF;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: x_item_found := FND_API.G_FALSE;

Line 348: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
352:

Line 438: FND_MSG_PUB.initialize;

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;
442: -- **************** Real Logic Starts *****************

Line 469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
473: END IF;

Line 472: FND_MSG_PUB.ADD;

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;
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

Line 520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

516: l_attachment_file_name,
517: l_default_mime_type;
518: -- Not found, input LANGUAGE must be invalid (b/c version id already verified)
519: IF Get_Citem_Meta_Csr%NOTFOUND THEN
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 523: FND_MSG_PUB.ADD;

519: IF Get_Citem_Meta_Csr%NOTFOUND THEN
520: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 651: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
655:

Line 693: FND_MSG_PUB.initialize;

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;
697: --******************* Real Logic Start *********************

Line 753: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
757:

Line 782: FND_MSG_PUB.initialize;

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;
786:

Line 837: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
841:

Line 873: FND_MSG_PUB.initialize;

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;
877:

Line 905: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
909: END IF;

Line 908: FND_MSG_PUB.ADD;

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;
909: END IF;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: x_version_number := -1;

Line 925: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

921:
922: --******************* Real Logic End *********************
923:
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;

Line 930: 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;
934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 934: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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;
938: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 938: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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:
942:

Line 973: FND_MSG_PUB.initialize;

969:
970: BEGIN
971: -- Initialize message list if p_init_msg_list is set to TRUE.
972: IF FND_API.to_Boolean( p_init_msg_list ) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975: -- Initialize API return status to success
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:

Line 991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

987:
988: -- If no matches, check if p_association_type_code is valid
989: IF (l_citem_count = 1) THEN
990: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
992: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
993: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
994: FND_MSG_PUB.ADD;
995: END IF;

Line 994: FND_MSG_PUB.ADD;

990: IF (Ibc_Validate_Pvt.isValidAssocType(p_association_type_code) = FND_API.g_false) THEN
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
992: FND_MESSAGE.Set_Name('IBC', 'INVALID_ASSOC_TYPE_CODE');
993: FND_MESSAGE.Set_token('ASSOC_TYPE_CODE', p_association_type_code);
994: FND_MSG_PUB.ADD;
995: END IF;
996: RAISE FND_API.G_EXC_ERROR;
997: END IF;
998: END IF;

Line 1003: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

999:
1000: --******************* Real Logic End *********************
1001:
1002: -- Standard call to get message count and if count=1, get the message
1003: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1004: p_data => x_msg_data);
1005: EXCEPTION
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1008: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

Line 1012: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

Line 1016: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

Line 1102: FND_MSG_PUB.initialize;

1098: BEGIN
1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.
1101: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1102: FND_MSG_PUB.initialize;
1103: END IF;
1104: -- Initialize API return status to success
1105: x_return_status := FND_API.G_RET_STS_SUCCESS;
1106: -- **************** Real Logic Starts *****************

Line 1160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1156: l_attachment_file_name,
1157: l_default_mime_type;
1158: -- Not found, input LANGUAGE must be invalid (b/c version id already verified)
1159: IF Get_Citem_Meta_Csr%NOTFOUND THEN
1160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1161: FND_MESSAGE.Set_Name('IBC', 'INVALID_LANG_CODE');
1162: FND_MESSAGE.Set_token('LANG_CODE', p_lang_code);
1163: FND_MSG_PUB.ADD;
1164: END IF;

Line 1163: FND_MSG_PUB.ADD;

1159: IF Get_Citem_Meta_Csr%NOTFOUND THEN
1160: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1161: FND_MESSAGE.Set_Name('IBC', 'INVALID_LANG_CODE');
1162: FND_MESSAGE.Set_token('LANG_CODE', p_lang_code);
1163: FND_MSG_PUB.ADD;
1164: END IF;
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;
1167: CLOSE Get_Citem_Meta_Csr;

Line 1293: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1289: -- **************** Real Logic Ends *****************
1290: EXCEPTION
1291: WHEN FND_API.G_EXC_ERROR THEN
1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: END Get_Citem_Xml;
1296:
1297: