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_CTYPE_PVT dependencies on FND_MSG_PUB

Line 150: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

146: -- Validate Environment
147: -- ******************************************************************
148: IF Fnd_Global.User_Id IS NULL
149: THEN
150: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
151: THEN
152: Fnd_Message.Set_Name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
153: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
154: Fnd_Msg_Pub.ADD;

Line 154: Fnd_Msg_Pub.ADD;

150: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
151: THEN
152: Fnd_Message.Set_Name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
153: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
154: Fnd_Msg_Pub.ADD;
155: END IF;
156: RAISE Fnd_Api.G_EXC_ERROR;
157: END IF;
158:

Line 206: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

202: -- Check for Uniqueness
203: OPEN C_Content_Type(p_Content_Type_Code => l_content_type_rec.content_type_code);
204: FETCH C_Content_Type INTO l_Content_Type_Code;
205: IF C_Content_Type%FOUND THEN
206: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
207: Fnd_Message.Set_name('IBC', 'IBC_ALREADY_EXISTS');
208: Fnd_Message.Set_Token('DUPLICATE_OBJECT_TOKEN', 'Content_Type_Code', FALSE);
209: Fnd_Msg_Pub.ADD;
210: END IF;

Line 209: Fnd_Msg_Pub.ADD;

205: IF C_Content_Type%FOUND THEN
206: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
207: Fnd_Message.Set_name('IBC', 'IBC_ALREADY_EXISTS');
208: Fnd_Message.Set_Token('DUPLICATE_OBJECT_TOKEN', 'Content_Type_Code', FALSE);
209: Fnd_Msg_Pub.ADD;
210: END IF;
211: CLOSE C_Content_Type;
212: RAISE Fnd_Api.G_EXC_ERROR;
213: END IF;

Line 364: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

360:
361: -- dbms_output.put_line('COUNT ' || l_temp);
362: ---
363: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
364: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
365: Fnd_Message.Set_name('IBC', 'IBC_INSERT_ERROR');
366: Fnd_Msg_Pub.ADD;
367: END IF;
368:

Line 366: Fnd_Msg_Pub.ADD;

362: ---
363: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
364: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
365: Fnd_Message.Set_name('IBC', 'IBC_INSERT_ERROR');
366: Fnd_Msg_Pub.ADD;
367: END IF;
368:
369: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
370: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 387: Fnd_Msg_Pub.Count_And_Get

383: COMMIT WORK;
384: END IF;
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: Fnd_Msg_Pub.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );
391:

Line 399: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

395: --ROLLBACK TO SAVEPOINT l_api_name;
396: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
397: P_API_name => L_API_name
398: ,P_PKG_name => G_PKG_name
399: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
400: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
401: ,P_SQLCODE => SQLCODE
402: ,P_SQLERRM => SQLERRM
403: ,X_MSG_COUNT => X_MSG_COUNT

Line 412: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

408: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
409: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
410: P_API_name => L_API_name
411: ,P_PKG_name => G_PKG_name
412: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
413: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
414: ,P_SQLCODE => SQLCODE
415: ,P_SQLERRM => SQLERRM
416: ,X_MSG_COUNT => X_MSG_COUNT

Line 513: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

509: OPEN C_Content_Type(p_Content_Type_Code => l_attribute_type_rec.Content_Type_Code);
510: FETCH C_Content_Type INTO l_Content_Type_Code;
511: IF C_Content_Type%NOTFOUND THEN
512: x_return_status := Fnd_Api.G_RET_STS_ERROR;
513: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
514: Fnd_Message.Set_name('IBC', 'INVALID_CONTENT_TYPE_CODE');
515: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
516: Fnd_Msg_Pub.ADD;
517: END IF;

Line 516: Fnd_Msg_Pub.ADD;

512: x_return_status := Fnd_Api.G_RET_STS_ERROR;
513: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
514: Fnd_Message.Set_name('IBC', 'INVALID_CONTENT_TYPE_CODE');
515: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
516: Fnd_Msg_Pub.ADD;
517: END IF;
518: CLOSE C_Content_Type;
519: RAISE Fnd_Api.G_EXC_ERROR;
520: END IF;

Line 628: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

624: ,p_attribute_Type_Code => l_attribute_type_rec.Attribute_type_code);
625: FETCH C_Attribute_Type INTO l_temp;
626: IF C_Attribute_Type%FOUND THEN
627: x_return_status := Fnd_Api.G_RET_STS_ERROR;
628: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
629: Fnd_Message.Set_name('IBC', 'IBC_ALREADY_EXISTS');
630: Fnd_Message.Set_Token('DUPLICATE_OBJECT_TOKEN', 'Attribute_Type_Code',FALSE);
631: Fnd_Msg_Pub.ADD;
632: END IF;

Line 631: Fnd_Msg_Pub.ADD;

627: x_return_status := Fnd_Api.G_RET_STS_ERROR;
628: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
629: Fnd_Message.Set_name('IBC', 'IBC_ALREADY_EXISTS');
630: Fnd_Message.Set_Token('DUPLICATE_OBJECT_TOKEN', 'Attribute_Type_Code',FALSE);
631: Fnd_Msg_Pub.ADD;
632: END IF;
633: END IF;
634:
635: CLOSE C_Attribute_Type;

Line 727: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

723: -- Validate Environment
724: -- ******************************************************************
725: IF Fnd_Global.User_Id IS NULL
726: THEN
727: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
728: THEN
729: Fnd_Message.Set_name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
730: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
731: Fnd_Msg_Pub.ADD;

Line 731: Fnd_Msg_Pub.ADD;

727: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
728: THEN
729: Fnd_Message.Set_name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
730: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
731: Fnd_Msg_Pub.ADD;
732: END IF;
733: RAISE Fnd_Api.G_EXC_ERROR;
734: END IF;
735:

Line 761: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

757: OPEN C_Content_Type(p_Content_Type_Code => l_content_type_rec.content_type_code);
758: FETCH C_Content_Type INTO l_Content_Type_Code;
759: IF C_Content_Type%NOTFOUND THEN
760: x_return_status := Fnd_Api.G_RET_STS_ERROR;
761: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
762: Fnd_Message.Set_name('IBC', 'INVALID_CONTENT_TYPE_CODE');
763: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
764: Fnd_Msg_Pub.ADD;
765: END IF;

Line 764: Fnd_Msg_Pub.ADD;

760: x_return_status := Fnd_Api.G_RET_STS_ERROR;
761: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
762: Fnd_Message.Set_name('IBC', 'INVALID_CONTENT_TYPE_CODE');
763: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
764: Fnd_Msg_Pub.ADD;
765: END IF;
766: CLOSE C_Content_Type;
767: RAISE Fnd_Api.G_EXC_ERROR;
768: END IF;

Line 876: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

872: END IF;
873:
874: ---
875: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
876: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
877: Fnd_Message.Set_name('IBC', 'IBC_UPDATE_ERROR');
878: Fnd_Msg_Pub.ADD;
879: END IF;
880:

Line 878: Fnd_Msg_Pub.ADD;

874: ---
875: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
876: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
877: Fnd_Message.Set_name('IBC', 'IBC_UPDATE_ERROR');
878: Fnd_Msg_Pub.ADD;
879: END IF;
880:
881: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 899: Fnd_Msg_Pub.Count_And_Get

895: COMMIT WORK;
896: END IF;
897:
898: -- Standard call to get message count and if count is 1, get message info.
899: Fnd_Msg_Pub.Count_And_Get
900: ( p_count => x_msg_count,
901: p_data => x_msg_data
902: );
903:

Line 911: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

907: ROLLBACK;
908: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
909: P_API_name => L_API_name
910: ,P_PKG_name => G_PKG_name
911: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
912: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
913: ,P_SQLCODE => SQLCODE
914: ,P_SQLERRM => SQLERRM
915: ,X_MSG_COUNT => X_MSG_COUNT

Line 924: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

920: ROLLBACK;
921: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
922: P_API_name => L_API_name
923: ,P_PKG_name => G_PKG_name
924: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
925: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
926: ,P_SQLCODE => SQLCODE
927: ,P_SQLERRM => SQLERRM
928: ,X_MSG_COUNT => X_MSG_COUNT

Line 994: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

990: -- Validate Environment
991: -- ******************************************************************
992: IF Fnd_Global.User_Id IS NULL
993: THEN
994: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
995: THEN
996: Fnd_Message.Set_name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
997: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
998: Fnd_Msg_Pub.ADD;

Line 998: Fnd_Msg_Pub.ADD;

994: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
995: THEN
996: Fnd_Message.Set_name(' + appShortname +', 'UT_CANNOT_GET_PROFILE_VALUE');
997: Fnd_Message.Set_Token('PROFILE', 'USER_ID', FALSE);
998: Fnd_Msg_Pub.ADD;
999: END IF;
1000: RAISE Fnd_Api.G_EXC_ERROR;
1001: END IF;
1002:

Line 1025: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1021: -- Check If the Record Exists
1022: OPEN C_Content_Type;
1023: FETCH C_Content_Type INTO l_Content_Type_Code;
1024: IF C_Content_Type%NOTFOUND THEN
1025: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1026: Fnd_Message.Set_name('IBC', 'Cannot Find Record to be Deleted');
1027: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1028: Fnd_Msg_Pub.ADD;
1029: END IF;

Line 1028: Fnd_Msg_Pub.ADD;

1024: IF C_Content_Type%NOTFOUND THEN
1025: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1026: Fnd_Message.Set_name('IBC', 'Cannot Find Record to be Deleted');
1027: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1028: Fnd_Msg_Pub.ADD;
1029: END IF;
1030: CLOSE C_Content_Type;
1031: RAISE Fnd_Api.G_EXC_ERROR;
1032: END IF;

Line 1038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1034:
1035: OPEN C_Attribute_Type;
1036: FETCH C_Attribute_Type INTO l_Content_Type_Code;
1037: IF C_Attribute_Type%FOUND THEN
1038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1039: Fnd_Message.Set_name('IBC', 'References_ExistContentTypeCode');
1040: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1041: Fnd_Msg_Pub.ADD;
1042: END IF;

Line 1041: Fnd_Msg_Pub.ADD;

1037: IF C_Attribute_Type%FOUND THEN
1038: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1039: Fnd_Message.Set_name('IBC', 'References_ExistContentTypeCode');
1040: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1041: Fnd_Msg_Pub.ADD;
1042: END IF;
1043: CLOSE C_Attribute_Type;
1044: RAISE Fnd_Api.G_EXC_ERROR;
1045: END IF;

Line 1072: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1068: p_CONTENT_TYPE_CODE =>p_CONTENT_TYPE_CODE);
1069:
1070:
1071: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1072: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1073: Fnd_Message.Set_name('IBC', 'IBC_DELETE_ERROR');
1074: Fnd_Msg_Pub.ADD;
1075: END IF;
1076:

Line 1074: Fnd_Msg_Pub.ADD;

1070:
1071: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
1072: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1073: Fnd_Message.Set_name('IBC', 'IBC_DELETE_ERROR');
1074: Fnd_Msg_Pub.ADD;
1075: END IF;
1076:
1077: IF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR) THEN
1078: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 1095: Fnd_Msg_Pub.Count_And_Get

1091: COMMIT WORK;
1092: END IF;
1093:
1094: -- Standard call to get message count and if count is 1, get message info.
1095: Fnd_Msg_Pub.Count_And_Get
1096: ( p_count => x_msg_count,
1097: p_data => x_msg_data
1098: );
1099:

Line 1107: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

1103: ROLLBACK;
1104: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1105: P_API_name => L_API_name
1106: ,P_PKG_name => G_PKG_name
1107: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1108: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1109: ,P_SQLCODE => SQLCODE
1110: ,P_SQLERRM => SQLERRM
1111: ,X_MSG_COUNT => X_MSG_COUNT

Line 1120: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

1116: ROLLBACK;
1117: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1118: P_API_name => L_API_name
1119: ,P_PKG_name => G_PKG_name
1120: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1121: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1122: ,P_SQLCODE => SQLCODE
1123: ,P_SQLERRM => SQLERRM
1124: ,X_MSG_COUNT => X_MSG_COUNT

Line 1395: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1391: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1392:
1393: IF l_attribute_type_rec.attribute_type_code IN (G_NAME,G_DESCRIPTION) THEN
1394: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1395: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1396: Fnd_Message.Set_name('IBC', 'Name OR Description Cannot be Deleted');
1397: Fnd_Msg_Pub.ADD;
1398: END IF;
1399: RAISE Fnd_Api.G_EXC_ERROR;

Line 1397: Fnd_Msg_Pub.ADD;

1393: IF l_attribute_type_rec.attribute_type_code IN (G_NAME,G_DESCRIPTION) THEN
1394: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1395: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1396: Fnd_Message.Set_name('IBC', 'Name OR Description Cannot be Deleted');
1397: Fnd_Msg_Pub.ADD;
1398: END IF;
1399: RAISE Fnd_Api.G_EXC_ERROR;
1400: END IF;
1401:

Line 1488: -- FND_MSG_PUB.ADD;

1484: RETURN;
1485: END IF;
1486: -- FND_MESSAGE.Set_name('IBC', 'Invalid Flex Value SET');
1487: -- FND_MESSAGE.Set_Token('COLUMN',p_attribute_type_code, FALSE);
1488: -- FND_MSG_PUB.ADD;
1489: -- CLOSE C_attribs;
1490: -- RAISE FND_API.G_EXC_ERROR;
1491: -- END IF;
1492:

Line 1528: Fnd_Msg_Pub.Count_And_Get

1524: EXECUTE IMMEDIATE 'BEGIN ' || lx_select || '; END;'
1525: USING OUT x_code, OUT x_name, OUT x_description;
1526:
1527: -- Standard call to get message count and if count is 1, get message info.
1528: Fnd_Msg_Pub.Count_And_Get
1529: ( p_count => x_msg_count,
1530: p_data => x_msg_data
1531: );
1532:

Line 1540: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

1536: ROLLBACK;
1537: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1538: P_API_name => L_API_name
1539: ,P_PKG_name => G_PKG_name
1540: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1541: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1542: ,P_SQLCODE => SQLCODE
1543: ,P_SQLERRM => SQLERRM
1544: ,X_MSG_COUNT => X_MSG_COUNT

Line 1553: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

1549: ROLLBACK;
1550: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1551: P_API_name => L_API_name
1552: ,P_PKG_name => G_PKG_name
1553: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1554: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1555: ,P_SQLCODE => SQLCODE
1556: ,P_SQLERRM => SQLERRM
1557: ,X_MSG_COUNT => X_MSG_COUNT

Line 1668: Fnd_Msg_Pub.ADD;

1664: FETCH CUR_LANG INTO l_temp;
1665: IF CUR_LANG%NOTFOUND THEN
1666: Fnd_Message.Set_name('IBC', 'IBC_INVALID_LANGUAGE_CODE');
1667: Fnd_Message.Set_Token('COLUMN', 'LANGUAGE', FALSE);
1668: Fnd_Msg_Pub.ADD;
1669: CLOSE CUR_LANG;
1670: RAISE Fnd_Api.G_EXC_ERROR;
1671: END IF;
1672: END IF;

Line 1686: Fnd_Msg_Pub.ADD;

1682: ,x_content_type_status;
1683: IF Cur_Content_Type%NOTFOUND THEN
1684: Fnd_Message.Set_name('IBC', 'Invalid Content TYPE Code');
1685: Fnd_Message.Set_Token('COLUMN', 'Content_Type_Code', FALSE);
1686: Fnd_Msg_Pub.ADD;
1687: CLOSE Cur_Content_Type;
1688: RAISE Fnd_Api.G_EXC_ERROR;
1689: END IF;
1690: CLOSE Cur_Content_Type;

Line 1730: Fnd_Msg_Pub.Count_And_Get

1726: -- END LOOP;
1727: -- END IF;
1728:
1729: -- Standard call to get message count and if count is 1, get message info.
1730: Fnd_Msg_Pub.Count_And_Get
1731: ( p_count => x_msg_count,
1732: p_data => x_msg_data
1733: );
1734:

Line 1742: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

1738: ROLLBACK;
1739: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1740: P_API_name => L_API_name
1741: ,P_PKG_name => G_PKG_name
1742: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1743: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1744: ,P_SQLCODE => SQLCODE
1745: ,P_SQLERRM => SQLERRM
1746: ,X_MSG_COUNT => X_MSG_COUNT

Line 1755: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

1751: ROLLBACK;
1752: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1753: P_API_name => L_API_name
1754: ,P_PKG_name => G_PKG_name
1755: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1756: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1757: ,P_SQLCODE => SQLCODE
1758: ,P_SQLERRM => SQLERRM
1759: ,X_MSG_COUNT => X_MSG_COUNT

Line 1894: Fnd_Msg_Pub.ADD;

1890: FETCH C_FlexValueSet INTO l_value_set_id,l_vset_type;
1891: IF C_FlexValueSet%NOTFOUND THEN
1892: Fnd_Message.Set_name('IBC', 'BAD_INPUT_VALUE');
1893: Fnd_Message.Set_Token('INPUT',p_flex_value_set_id, FALSE);
1894: Fnd_Msg_Pub.ADD;
1895: CLOSE C_FlexValueSet;
1896: x_exists := Fnd_Api.G_FALSE;
1897: RAISE Fnd_Api.G_EXC_ERROR;
1898: END IF;

Line 1953: Fnd_Msg_Pub.Count_And_Get

1949: x_exists := Fnd_Api.G_FALSE;
1950: END IF;
1951:
1952: -- Standard call to get message count and if count is 1, get message info.
1953: Fnd_Msg_Pub.Count_And_Get
1954: ( p_count => x_msg_count,
1955: p_data => x_msg_data
1956: );
1957:

Line 1964: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

1960: ROLLBACK;
1961: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1962: P_API_name => L_API_name
1963: ,P_PKG_name => G_PKG_name
1964: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
1965: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1966: ,P_SQLCODE => SQLCODE
1967: ,P_SQLERRM => SQLERRM
1968: ,X_MSG_COUNT => X_MSG_COUNT

Line 1977: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

1973: ROLLBACK;
1974: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1975: P_API_name => L_API_name
1976: ,P_PKG_name => G_PKG_name
1977: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1978: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
1979: ,P_SQLCODE => SQLCODE
1980: ,P_SQLERRM => SQLERRM
1981: ,X_MSG_COUNT => X_MSG_COUNT

Line 2034: FND_MSG_PUB.ADD;

2030: CLOSE C_flex;
2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: FND_MESSAGE.Set_Name('IBC', 'BAD_INPUT_VALUE');
2033: FND_MESSAGE.Set_Token('INPUT', 'FLEX_VALUE_SET_ID', FALSE);
2034: FND_MSG_PUB.ADD;
2035: RAISE FND_API.G_EXC_ERROR;
2036: END IF;
2037:
2038:

Line 2061: FND_MSG_PUB.ADD;

2057: -- dbms_output.put_line(lx_success);
2058: ELSE
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: FND_MESSAGE.Set_Name('IBC', 'IBC_INVALID_FLEX_VALUE_SET');
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064:
2065:

Line 2074: Fnd_Msg_Pub.Count_And_Get

2070: -- dbms_output.put_line(SUBSTR(x_select,241,480));
2071:
2072:
2073: -- Standard call to get message count and if count is 1, get message info.
2074: Fnd_Msg_Pub.Count_And_Get
2075: ( p_count => x_msg_count,
2076: p_data => x_msg_data
2077: );
2078:

Line 2086: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR

2082: ROLLBACK;
2083: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
2084: P_API_name => L_API_name
2085: ,P_PKG_name => G_PKG_name
2086: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
2087: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
2088: ,P_SQLCODE => SQLCODE
2089: ,P_SQLERRM => SQLERRM
2090: ,X_MSG_COUNT => X_MSG_COUNT

Line 2099: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR

2095: ROLLBACK;
2096: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
2097: P_API_name => L_API_name
2098: ,P_PKG_name => G_PKG_name
2099: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
2100: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
2101: ,P_SQLCODE => SQLCODE
2102: ,P_SQLERRM => SQLERRM
2103: ,X_MSG_COUNT => X_MSG_COUNT