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

Line 786: FND_MSG_PUB.initialize;

782: IS
783: BEGIN
784: -- Initialize message list if p_init_msg_list is set to TRUE.
785: IF FND_API.to_Boolean( p_init_msg_list ) THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- Initialize API return status to success
790: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_NUM) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
797: FND_MSG_PUB.ADD;
798: END IF;

Line 797: FND_MSG_PUB.ADD;

793: x_return_status := FND_API.G_RET_STS_ERROR;
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
797: FND_MSG_PUB.ADD;
798: END IF;
799: END IF;
800:
801: FND_MSG_PUB.Count_And_Get(

Line 801: FND_MSG_PUB.Count_And_Get(

797: FND_MSG_PUB.ADD;
798: END IF;
799: END IF;
800:
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data);
804:
805: END Validate_NotNULL_NUMBER;

Line 819: FND_MSG_PUB.initialize;

815: IS
816: BEGIN
817: -- Initialize message list if p_init_msg_list is set to TRUE.
818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
819: FND_MSG_PUB.initialize;
820: END IF;
821:
822: -- Initialize API return status to success
823: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: IF (p_notnull_column IS NULL OR p_notnull_column = FND_API.G_MISS_CHAR) THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
830: FND_MSG_PUB.ADD;
831: END IF;

Line 830: FND_MSG_PUB.ADD;

826: x_return_status := FND_API.G_RET_STS_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');
829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);
830: FND_MSG_PUB.ADD;
831: END IF;
832: END IF;
833:
834: FND_MSG_PUB.Count_And_Get(

Line 834: FND_MSG_PUB.Count_And_Get(

830: FND_MSG_PUB.ADD;
831: END IF;
832: END IF;
833:
834: FND_MSG_PUB.Count_And_Get(
835: p_count => x_msg_count,
836: p_data => x_msg_data);
837:
838: END Validate_NotNULL_VARCHAR2;

Line 861: FND_MSG_PUB.initialize;

857: BEGIN
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list ) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863:
864: -- Initialize API return status to success
865: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

869: FETCH C_Content_Type_Status INTO l_Content_Type_Status;
870: IF (C_Content_Type_Status%NOTFOUND) THEN
871: CLOSE C_Content_Type_Status;
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
874: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
875: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT_TYPE_STATUS', FALSE);
876: FND_MSG_PUB.ADD;
877: END IF;

Line 876: FND_MSG_PUB.ADD;

872: x_return_status := FND_API.G_RET_STS_ERROR;
873: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
874: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
875: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT_TYPE_STATUS', FALSE);
876: FND_MSG_PUB.ADD;
877: END IF;
878: ELSE
879: CLOSE C_Content_Type_Status;
880: END IF;

Line 903: FND_MSG_PUB.initialize;

899:
900:
901: -- Initialize message list if p_init_msg_list is set to TRUE.
902: IF FND_API.to_Boolean( p_init_msg_list ) THEN
903: FND_MSG_PUB.initialize;
904: END IF;
905:
906: -- Initialize API return status to success
907: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

911: FETCH C_Get_Appl_Id INTO x_application_id;
912: IF (C_Get_Appl_Id%NOTFOUND) THEN
913: CLOSE C_Get_Appl_Id;
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
916: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
917: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION SHORT NAME', FALSE);
918: FND_MSG_PUB.ADD;
919: END IF;

Line 918: FND_MSG_PUB.ADD;

914: x_return_status := FND_API.G_RET_STS_ERROR;
915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
916: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
917: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION SHORT NAME', FALSE);
918: FND_MSG_PUB.ADD;
919: END IF;
920: ELSE
921: CLOSE C_Get_Appl_Id;
922: END IF;

Line 947: FND_MSG_PUB.initialize;

943:
944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF FND_API.to_Boolean( p_init_msg_list ) THEN
947: FND_MSG_PUB.initialize;
948: END IF;
949:
950: -- Initialize API return status to success
951: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

955: FETCH C_Get_Appl_Id INTO l_temp;
956: IF (C_Get_Appl_Id%NOTFOUND) THEN
957: CLOSE C_Get_Appl_Id;
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
961: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION ID', FALSE);
962: FND_MSG_PUB.ADD;
963: END IF;

Line 962: FND_MSG_PUB.ADD;

958: x_return_status := FND_API.G_RET_STS_ERROR;
959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
960: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
961: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION ID', FALSE);
962: FND_MSG_PUB.ADD;
963: END IF;
964: ELSE
965: CLOSE C_Get_Appl_Id;
966: END IF;

Line 990: FND_MSG_PUB.initialize;

986: BEGIN
987:
988: -- Initialize message list if p_init_msg_list is set to TRUE.
989: IF FND_API.to_Boolean( p_init_msg_list ) THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: -- Initialize API return status to success
994: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

998: FETCH C_CType_Code INTO l_temp;
999: IF (C_CType_Code%NOTFOUND) THEN
1000: CLOSE C_CType_Code;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1004: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT TYPE CODE', FALSE);
1005: FND_MSG_PUB.ADD;
1006: END IF;

Line 1005: FND_MSG_PUB.ADD;

1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1004: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT TYPE CODE', FALSE);
1005: FND_MSG_PUB.ADD;
1006: END IF;
1007: ELSE
1008: CLOSE C_CType_Code;
1009: END IF;

Line 1034: FND_MSG_PUB.initialize;

1030: BEGIN
1031:
1032: -- Initialize message list if p_init_msg_list is set to TRUE.
1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:
1037: -- Initialize API return status to success
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1043: FETCH C_Data_type_Code INTO l_Data_type_Code;
1044: IF (C_Data_type_Code%NOTFOUND) THEN
1045: CLOSE C_Data_type_Code;
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1048: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1049: FND_MESSAGE.Set_Token('COLUMN', 'DATA_TYPE_CODE', FALSE);
1050: FND_MSG_PUB.ADD;
1051: END IF;

Line 1050: FND_MSG_PUB.ADD;

1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1048: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1049: FND_MESSAGE.Set_Token('COLUMN', 'DATA_TYPE_CODE', FALSE);
1050: FND_MSG_PUB.ADD;
1051: END IF;
1052: ELSE
1053: CLOSE C_Data_type_Code;
1054: END IF;

Line 1074: FND_MSG_PUB.initialize;

1070:
1071:
1072: -- Initialize message list if p_init_msg_list is set to TRUE.
1073: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1074: FND_MSG_PUB.initialize;
1075: END IF;
1076:
1077: -- Initialize API return status to success
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1114: FETCH C_content_item_id INTO l_content_item_id;
1115: IF (C_content_item_id%NOTFOUND) THEN
1116: CLOSE C_content_item_id;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1120: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1121: FND_MSG_PUB.ADD;
1122: END IF;

Line 1121: FND_MSG_PUB.ADD;

1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1120: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1121: FND_MSG_PUB.ADD;
1122: END IF;
1123: ELSE
1124: CLOSE C_content_item_id;
1125: END IF;

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

1139: FETCH C_file_id INTO l_file_id;
1140: IF (C_file_id%NOTFOUND) THEN
1141: CLOSE C_file_id;
1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1144: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1145: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1146: FND_MSG_PUB.ADD;
1147: END IF;

Line 1146: FND_MSG_PUB.ADD;

1142: x_return_status := FND_API.G_RET_STS_ERROR;
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1144: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1145: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);
1146: FND_MSG_PUB.ADD;
1147: END IF;
1148: ELSE
1149: CLOSE C_file_id;
1150: END IF;

Line 1169: FND_MSG_PUB.initialize;

1165: IS
1166: BEGIN
1167: -- Initialize message list if p_init_msg_list is set to TRUE.
1168: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1169: FND_MSG_PUB.initialize;
1170: END IF;
1171:
1172: -- Initialize API return status to success
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1200: FND_MSG_PUB.ADD;

1196:
1197: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1198: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1199: FND_MESSAGE.Set_Token('COLUMN', 'Reference Code', FALSE);
1200: FND_MSG_PUB.ADD;
1201: END IF;
1202:
1203: END Validate_Reference_Code;
1204:

Line 1217: FND_MSG_PUB.initialize;

1213: BEGIN
1214:
1215: -- Initialize message list if p_init_msg_list is set to TRUE.
1216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1217: FND_MSG_PUB.initialize;
1218: END IF;
1219:
1220: -- Initialize API return status to success
1221: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1222:
1223: -- Max Instance cannot be greater than Min Instances
1224: IF (p_MAX_Instances < 1 OR p_min_instances < 0 OR NVL(p_Max_Instances,p_Min_Instances+1) < p_Min_Instances ) THEN
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1227: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1228: FND_MESSAGE.Set_Token('COLUMN','MAX Instances', FALSE);
1229: FND_MSG_PUB.ADD;
1230: END IF;

Line 1229: FND_MSG_PUB.ADD;

1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1227: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1228: FND_MESSAGE.Set_Token('COLUMN','MAX Instances', FALSE);
1229: FND_MSG_PUB.ADD;
1230: END IF;
1231: END IF;
1232:
1233: END Validate_Min_Max_Instances;

Line 1257: FND_MSG_PUB.initialize;

1253: BEGIN
1254:
1255: -- Initialize message list if p_init_msg_list is set to TRUE.
1256: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260: -- Initialize API return status to success
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1265: FETCH C_jtf_resources INTO l_tmp;
1266: IF (C_jtf_resources%NOTFOUND) THEN
1267: CLOSE C_jtf_resources;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1270: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1271: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE_ID', FALSE);
1272: FND_MSG_PUB.ADD;
1273: END IF;

Line 1272: FND_MSG_PUB.ADD;

1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1270: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');
1271: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE_ID', FALSE);
1272: FND_MSG_PUB.ADD;
1273: END IF;
1274: ELSE
1275: CLOSE C_jtf_resources;
1276: END IF;