DBA Data[Home] [Help]

APPS.IBC_VALIDATE_PVT dependencies on FND_MESSAGE

Line 795: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');

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

Line 796: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);

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

Line 828: FND_MESSAGE.Set_Name('IBC', 'API_MISSING_COLUMN');

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

Line 829: FND_MESSAGE.Set_Token('COLUMN', p_column_name, FALSE);

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

Line 874: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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;
878: ELSE

Line 875: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT_TYPE_STATUS', FALSE);

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;
878: ELSE
879: CLOSE C_Content_Type_Status;

Line 916: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_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;
920: ELSE

Line 917: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION SHORT NAME', FALSE);

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;
920: ELSE
921: CLOSE C_Get_Appl_Id;

Line 960: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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;
964: ELSE

Line 961: FND_MESSAGE.Set_Token('COLUMN', 'APPLICATION ID', FALSE);

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;
964: ELSE
965: CLOSE C_Get_Appl_Id;

Line 1003: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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;
1007: ELSE

Line 1004: FND_MESSAGE.Set_Token('COLUMN', 'CONTENT TYPE CODE', FALSE);

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;
1007: ELSE
1008: CLOSE C_CType_Code;

Line 1048: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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;
1052: ELSE

Line 1049: FND_MESSAGE.Set_Token('COLUMN', 'DATA_TYPE_CODE', FALSE);

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;
1052: ELSE
1053: CLOSE C_Data_type_Code;

Line 1119: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_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;
1123: ELSE

Line 1120: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);

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;
1123: ELSE
1124: CLOSE C_content_item_id;

Line 1144: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_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;
1148: ELSE

Line 1145: FND_MESSAGE.Set_Token('COLUMN', 'DEFAULT VALUE', FALSE);

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;
1148: ELSE
1149: CLOSE C_file_id;

Line 1198: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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

Line 1199: FND_MESSAGE.Set_Token('COLUMN', 'Reference Code', FALSE);

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

Line 1227: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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

Line 1228: FND_MESSAGE.Set_Token('COLUMN','MAX Instances', FALSE);

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

Line 1270: FND_MESSAGE.Set_Name('IBC', 'API_INVALID_ID');

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;
1274: ELSE

Line 1271: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE_ID', FALSE);

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;
1274: ELSE
1275: CLOSE C_jtf_resources;